{ "currentVersion": 10.51, "id": 43, "name": "APP_SIN.vhdPropostas", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "IDPROPOSTA", "typeIdField": null, "subtypeFieldName": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "IDPROPOSTA", "type": "esriFieldTypeString", "alias": "ID de proposta", "length": 20, "domain": null }, { "name": "IDPROCESSO", "type": "esriFieldTypeString", "alias": "ID de processo", "length": 20, "domain": null }, { "name": "TECNICO", "type": "esriFieldTypeString", "alias": "Técnico", "length": 100, "domain": { "type": "codedValue", "name": "dTecnico", "codedValues": [ { "name": "Aldina", "code": "Aldina" }, { "name": "Alexandre Jorge", "code": "AlexandreJorge" }, { "name": "Alexandre Marques", "code": "AlexandreMarques" }, { "name": "Amorim Silva", "code": "AmorimSilva" }, { "name": "Ana Luísa Ferreira", "code": "AnaLuisaFerreira" }, { "name": "Ana Rita Sousa", "code": "AnaRitaSousa" }, { "name": "António Abreu", "code": "AntonioAbreu" }, { "name": "António Duarte", "code": "AntonioDuarte" }, { "name": "Carla Lopes", "code": "CarlaLopes" }, { "name": "Carlos Duarte", "code": "CarlosDuarte" }, { "name": "Carlos Roque", "code": "CarlosRoque" }, { "name": "Carlos Sousa Ferreira", "code": "CarlosSousaFerreira" }, { "name": "Carmen Antunes", "code": "CarmenAntunes" }, { "name": "Carmen Franco", "code": "CarmenFranco" }, { "name": "DAGPM", "code": "DAGPM" }, { "name": "DDGM", "code": "DDGM" }, { "name": "DDGMT", "code": "DDGMT" }, { "name": "DDMMT", "code": "DDMMT" }, { "name": "DGMT (Secretaria)", "code": "DGMTSecretaria" }, { "name": "DIPM", "code": "DIPM" }, { "name": "Eduardo Santos", "code": "EduardoSantos" }, { "name": "Elisabete Portalegre", "code": "ElisabetePortalegre" }, { "name": "Fátima Roxo", "code": "FatimaRoxo" }, { "name": "Fernando Valente", "code": "FernandoValente" }, { "name": "Filipe Simões", "code": "FilipeSimoes" }, { "name": "Fiscalização DGM", "code": "FiscalizacaoDGM" }, { "name": "Fiscalização SMC", "code": "FiscalizacaoSMC" }, { "name": "Gonçalo Costa", "code": "GoncaloCosta" }, { "name": "Graça Reis", "code": "GracaReis" }, { "name": "GVCC", "code": "GVCC" }, { "name": "GVFNS", "code": "GVFNS" }, { "name": "Hélder Cristóvão", "code": "HelderCristovao" }, { "name": "Inês Guerreiro", "code": "InesGuerreiro" }, { "name": "Isabel Margarida Morais", "code": "IsabelMargaridaMorais" }, { "name": "João Mesquita", "code": "JoaoMesquita" }, { "name": "Jorge Jordão", "code": "JorgeJordao" }, { "name": "José Afonso Dias", "code": "JoseAfonsoDias" }, { "name": "José Miguel Cabral", "code": "JoseMiguelCabral" }, { "name": "José Pais", "code": "JosePais" }, { "name": "Lino Rilhó", "code": "LinoRilho" }, { "name": "Luís Filipe", "code": "LuisFilipe" }, { "name": "Mafalda Pinto", "code": "MafaldaPinto" }, { "name": "Manuela Reis", "code": "ManuelaReis" }, { "name": "Margarida Morais", "code": "MargaridaMorais" }, { "name": "Margarida Rodrigues", "code": "MargaridaRodrigues" }, { "name": "Mário Marques", "code": "MarioMarques" }, { "name": "Não conhecido", "code": "NC" }, { "name": "Paula Antunes", "code": "PaulaAntunes" }, { "name": "Paula Carpinteiro", "code": "PaulaCarpinteiro" }, { "name": "Paulo Simões", "code": "PauloSimoes" }, { "name": "Pedro Moniz Barreto", "code": "PedroMonizBarreto" }, { "name": "Polícia Municipal", "code": "PoliciaMunicipal" }, { "name": "PSP", "code": "PSP" }, { "name": "Requerente", "code": "Requerente" }, { "name": "Rita Palmeiro", "code": "RitaPalmeiro" }, { "name": "Romeu Rosa", "code": "RomeuRosa" }, { "name": "Sibila Sobral", "code": "SibilaSobral" }, { "name": "SIG", "code": "SIG" }, { "name": "Sofia Lima", "code": "SofiaLima" }, { "name": "Sónia Martins", "code": "SoniaMartins" }, { "name": "Susana Nascimento", "code": "SusanaNascimento" }, { "name": "Susana Paulo", "code": "SusanaPaulo" }, { "name": "Tiago Raimundo", "code": "TiagoRaimundo" }, { "name": "Sofia Norberto", "code": "SofiaNorberto" }, { "name": "Ana Clara Melo", "code": "AnaClaraMelo" }, { "name": "Mafalda Costa", "code": "MafaldaCosta" }, { "name": "Isabel Gago", "code": "IsabelGago" }, { "name": "João Lomelino", "code": "JoaoLomelino" }, { "name": "António Figueiroa", "code": "AntonioFigueiroa" }, { "name": "Paula Roxo", "code": "PaulaRoxo" }, { "name": "Luísa Teixeira", "code": "LuisaTeixeira" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ESTADOPROPOSTA", "type": "esriFieldTypeString", "alias": "Estado da proposta", "length": 50, "domain": null }, { "name": "MODOSOLICITACAO", "type": "esriFieldTypeString", "alias": "Modo de solicitação", "length": 50, "domain": null }, { "name": "PRIORITARIO", "type": "esriFieldTypeString", "alias": "Prioritário", "length": 15, "domain": { "type": "codedValue", "name": "dPrioridade", "codedValues": [ { "name": "Não prioritário", "code": "NaoPrioritario" }, { "name": "Prioritário", "code": "Prioritario" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ENTIDADE", "type": "esriFieldTypeString", "alias": "Entidade", "length": 100, "domain": { "type": "codedValue", "name": "dEntidadeExecutora", "codedValues": [ { "name": "31/DMSC/DA/10 - TRAFIURBE / MASITRAVE", "code": "31/DMSC/DA/10Trafiurbe/Masitrave" }, { "name": "Brigada A", "code": "BrigadaA" }, { "name": "Brigada B", "code": "BrigadaB" }, { "name": "Brigada CML", "code": "BrigadaCML" }, { "name": "Brigada Dia", "code": "BrigadaDia" }, { "name": "Brigada SH", "code": "BrigadaSH" }, { "name": "Brigadas LX", "code": "BrigadasLX" }, { "name": "CARRIS", "code": "Carris" }, { "name": "CEMUSA", "code": "Cemusa" }, { "name": "COPI", "code": "Copi" }, { "name": "DMAU", "code": "DMAU" }, { "name": "DMIVP", "code": "DMIVP" }, { "name": "DMPO/DIVPS", "code": "DMPO/DIVPS" }, { "name": "Dois", "code": "Dois" }, { "name": "DOIS/DMIVP", "code": "DOIS/DMIVP" }, { "name": "EMEL", "code": "Emel" }, { "name": "Empreiteiro (obra aprovada)", "code": "EmpreiteiroObraAprovada" }, { "name": "EYSSA", "code": "Eyssa" }, { "name": "Fiscais", "code": "Fiscais" }, { "name": "FLGASPAR", "code": "FlGaspar" }, { "name": "GEBALIS", "code": "Gebalis" }, { "name": "HABIDOM", "code": "Habidom" }, { "name": "JCDECAUX", "code": "JCDECAUX" }, { "name": "JF24 Ajuda", "code": "JF24Ajuda" }, { "name": "JF24 Alcântara", "code": "JF24Alcantara" }, { "name": "JF24 Alvalade", "code": "JF24Alvalade" }, { "name": "JF24 Arreiro", "code": "JF24Areeiro" }, { "name": "JF24 Arroios", "code": "JF24Arroios" }, { "name": "JF24 Avenidas Novas", "code": "JF24AvenidasNovas" }, { "name": "JF24 Beato", "code": "JF24Beato" }, { "name": "JF24 Belém", "code": "JF24Belem" }, { "name": "JF24 Benfica", "code": "JF24Benfica" }, { "name": "JF24 Campolide", "code": "JF24Campolide" }, { "name": "JF24 Campo Ourique", "code": "JF24CampoOurique" }, { "name": "JF24 Carnide", "code": "JF24Carnide" }, { "name": "JF24 Estrela", "code": "JF24Estrela" }, { "name": "JF24 Lumiar", "code": "JF24Lumiar" }, { "name": "JF24 Marvila", "code": "JF24Marvila" }, { "name": "JF24 Misericórdia", "code": "JF24Misericordia" }, { "name": "JF24 Olivais", "code": "JF24Olivais" }, { "name": "JF24 Parque das Nações", "code": "JF24ParqueNacoes" }, { "name": "JF24 Penha de França", "code": "JF24PenhaFranca" }, { "name": "JF24 Santa Clara", "code": "JF24SantaClara" }, { "name": "JF24 Santa Maria Maior", "code": "JF24SantaMariaMaior" }, { "name": "JF24 Santo António", "code": "JF24SantoAntonio" }, { "name": "JF24 São Domingos de Benfica", "code": "JF24SaoDomingosBenfica" }, { "name": "JF24 São Vicente", "code": "JF24SaoVicente" }, { "name": "JF Ajuda", "code": "JFAjuda" }, { "name": "JF Alcântara", "code": "JFAlcantara" }, { "name": "JF Alto Do Pina", "code": "JFAltoDoPina" }, { "name": "JF Alvalade", "code": "JFAlvalade" }, { "name": "JF Ameixoeira", "code": "JFAmeixoeira" }, { "name": "JF Anjos", "code": "JFAnjos" }, { "name": "JF Beato", "code": "JFBeato" }, { "name": "JF Benfica", "code": "JFBenfica" }, { "name": "JF Campo Grande", "code": "JFCampoGrande" }, { "name": "JF Campolide", "code": "JFCampolide" }, { "name": "JF Carnide", "code": "JFCarnide" }, { "name": "JF Castelo", "code": "JFCastelo" }, { "name": "JF Charneca", "code": "JFCharneca" }, { "name": "JF Coração de Jesus", "code": "JFCoracaoDeJesus" }, { "name": "JF Encarnação", "code": "JFEncarnacao" }, { "name": "JF Graça", "code": "JFGraca" }, { "name": "JF Lapa", "code": "JFLapa" }, { "name": "JF Lumiar", "code": "JFLumiar" }, { "name": "JF Madalena", "code": "JFMadalena" }, { "name": "JF Mártires", "code": "JFMartires" }, { "name": "JF Marvila", "code": "JFMarvila" }, { "name": "JF Mercês", "code": "JFMerces" }, { "name": "JF Nossa Senhora de Fátima", "code": "JFNossaSraFatima" }, { "name": "JF Penha de França", "code": "JFPenhaDeFranca" }, { "name": "JF Prazares", "code": "JFPrazeres" }, { "name": "JF Sacramento", "code": "JFSacramento" }, { "name": "JF Santa Catarina", "code": "JFSantaCatarina" }, { "name": "JF Santa Engrácia", "code": "JFSantaEngracia" }, { "name": "JF Santa Isabel", "code": "JFSantaIsabel" }, { "name": "JF Santa Justa", "code": "JFSantaJusta" }, { "name": "JF Santa Maria de Belém", "code": "JFSantaMariaBelem" }, { "name": "JF Santa Maria dos Olivais", "code": "JFSantaMariaOlivais" }, { "name": "JF Santiago", "code": "JFSantiago" }, { "name": "JF Santo Condestável", "code": "JFSantoCondestavel" }, { "name": "JF Santo Estêvão", "code": "JFSantoEstevao" }, { "name": "JF Santos", "code": "JFSantos" }, { "name": "JF Santos-O-Velho", "code": "JFSantosOVelho" }, { "name": "JF São Cristóvão e São Lourenço", "code": "JFSaoCristovaoESaoLourenco" }, { "name": "JF São Domingos de Benfica", "code": "JFSaoDomingosDeBenfica" }, { "name": "JF São Francisco Xavier", "code": "JFSaoFranciscoXavier" }, { "name": "JF São João", "code": "JFSaoJoao" }, { "name": "JF São João de Brito", "code": "JFSaoJoaoDeBrito" }, { "name": "JF São João de Deus", "code": "JFSaoJoaoDeDeus" }, { "name": "JF São Jorge de Arroios", "code": "JFSaoJorgeDeArroios" }, { "name": "JF São José", "code": "JFSaoJose" }, { "name": "JF São Mamede", "code": "JFSaoMamede" }, { "name": "JF São Miguel", "code": "JFSaoMiguel" }, { "name": "JF São Nicolau", "code": "JFSaoNicolau" }, { "name": "JF São Paulo", "code": "JFSaoPaulo" }, { "name": "JF São Sebastião da Pedreira", "code": "JFSaoSebastiaoDaPedreira" }, { "name": "JF São Vicente de Fora", "code": "JFSaoVicenteDeFora" }, { "name": "JF Sé", "code": "JFSe" }, { "name": "JF Socorro", "code": "JFSocorro" }, { "name": "Junta de freguesia", "code": "JuntaFreguesia" }, { "name": "LOURESVIAS", "code": "LouresVias" }, { "name": "Não conhecido", "code": "NC" }, { "name": "Particular", "code": "Particular" }, { "name": "Requerente", "code": "Requerente" }, { "name": "RSB", "code": "RSB" }, { "name": "Salvador Santos Dias", "code": "SalvadorSantosDias" }, { "name": "SIMTEJO", "code": "SimTejo" }, { "name": "SOLTRÁFEGO", "code": "SolTrafego" }, { "name": "SOLTRÁFEGO (AD Mq Pombal)", "code": "SoltrafegoADMarquesPombal" }, { "name": "Tomás De Oliveira", "code": "TomasDeOliveira" }, { "name": "TRAFIURBE", "code": "Trafiurbe" }, { "name": "UCT-DFA", "code": "UCT-DFA" }, { "name": "UCT/DO", "code": "UCT/DO" }, { "name": "UCT/N", "code": "UCT/N" }, { "name": "UIT-C", "code": "UIT-C" }, { "name": "Empreiteiro", "code": "Empreiteiro" }, { "name": "DMMC-DIOA-DGI", "code": "DMMC-DIOA-DGI" }, { "name": "JF Penha", "code": "JFPena" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DATAPROPOSTA", "type": "esriFieldTypeDate", "alias": "Data de proposta", "length": 8, "domain": null }, { "name": "OBSERVACOES", "type": "esriFieldTypeString", "alias": "Observações", "length": 255, "domain": null }, { "name": "UTILIZADORCRIACAO", "type": "esriFieldTypeString", "alias": "Utilizador de criação", "length": 50, "domain": null }, { "name": "DATACRIACAO", "type": "esriFieldTypeDate", "alias": "Data de criação", "length": 8, "domain": null }, { "name": "UTILIZADOREDICAO", "type": "esriFieldTypeString", "alias": "Utilizador de edição", "length": 50, "domain": null }, { "name": "DATAEDICAO", "type": "esriFieldTypeDate", "alias": "Data de edição", "length": 8, "domain": null } ], "indexes": [ { "name": "G25020IDPROCESSO", "fields": "IDPROCESSO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G25020IDPROPOSTA", "fields": "IDPROPOSTA", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R192047_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "vhdProcessos", "relatedTableId": 93, "role": "esriRelRoleOrigin", "keyField": "IDProcesso", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 7, "name": "vOperacoesVerticais", "relatedTableId": 40, "role": "esriRelRoleDestination", "keyField": "IDProposta", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 9, "name": "vSinaisVerticais", "relatedTableId": 117, "role": "esriRelRoleDestination", "keyField": "IDProposta", "cardinality": "esriRelCardinalityOneToOne", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": false, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }