{ "currentVersion": 10.51, "id": 39, "name": "APP_SIN.vhdExecucoes", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "IDEXECUCAO", "typeIdField": null, "subtypeFieldName": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "IDEXECUCAO", "type": "esriFieldTypeString", "alias": "ID de execução", "length": 20, "domain": null }, { "name": "IDPROCESSO", "type": "esriFieldTypeString", "alias": "ID do processo", "length": 20, "domain": null }, { "name": "MEDIDORFISCAL", "type": "esriFieldTypeString", "alias": "Medidor fiscal", "length": 50, "domain": { "type": "codedValue", "name": "dMedidorFiscal", "codedValues": [ { "name": "Abílio (TRAFIURBE)", "code": "AbílioTrafiurbe" }, { "name": "Alberto (TRAFIURBE)", "code": "AlbertoTrafiurbe" }, { "name": "Alexandre Marques", "code": "AlexandreMarques" }, { "name": "Ambrósio", "code": "Ambrosio" }, { "name": "Amorim Silva", "code": "AmorimSilva" }, { "name": "Ana Mafalda Pinto", "code": "AnaMafaldaPinto" }, { "name": "António Abreu", "code": "AntonioAbreu" }, { "name": "António Antunes", "code": "AntonioAntunes" }, { "name": "António Capelo", "code": "AntonioCapelo" }, { "name": "António Pedroso", "code": "AntonioPedroso" }, { "name": "António Pereira", "code": "AntonioPereira" }, { "name": "António Sanguinho", "code": "AntonioSanguinho" }, { "name": "Antunes Borrego", "code": "AntunesBorrego" }, { "name": "Baptista", "code": "Baptista" }, { "name": "Bruno", "code": "Bruno" }, { "name": "Carlos Duarte", "code": "CarlosDuarte" }, { "name": "Carlos Marques", "code": "CarlosMarques" }, { "name": "Carlos Morgado", "code": "CarlosMorgado" }, { "name": "Carlos Roque", "code": "CarlosRoque" }, { "name": "Carlos Sousa Ferreira", "code": "CarlosSousaFerreira" }, { "name": "Carmen Franco", "code": "CarmenFranco" }, { "name": "CARRIS", "code": "Carris" }, { "name": "Dionísio Fortuna", "code": "DionisioFortuna" }, { "name": "Domingos Fernandes", "code": "DomingosFernandes" }, { "name": "Edson (TRAFIURBE)", "code": "EdsonTrafiurbe" }, { "name": "Eduard Covali", "code": "EduardCovali" }, { "name": "Eduardo Santos", "code": "EduardoSantos" }, { "name": "Elisabete Portalegre", "code": "ElisabetePortalegre" }, { "name": "Elsa Casanova", "code": "ElsaCasanova" }, { "name": "EMEL", "code": "EMEL" }, { "name": "Emília Velasco", "code": "EmiliaVelasco" }, { "name": "Fátima Crespo", "code": "FatimaCrespo" }, { "name": "Fernando Eisele", "code": "FernandoEisele" }, { "name": "Fernando Pinheiro", "code": "FernandoPinheiro" }, { "name": "Flávio Matos", "code": "FlavioMatos" }, { "name": "Francisco Sena", "code": "FranciscoSena" }, { "name": "Gonçalo Costa", "code": "GoncaloCosta" }, { "name": "Inês Guerreiro", "code": "InesGuerreiro" }, { "name": "Inês Machado", "code": "InesMachado" }, { "name": "InfoPortugal (Mobile Mapping)", "code": "InfoPortugal" }, { "name": "Ivan (TRAFIURBE)", "code": "IvanTrafiurbe" }, { "name": "João Carvalho", "code": "JoaoCarvalho" }, { "name": "João Pires", "code": "JoaoPires" }, { "name": "Jorge Capelo", "code": "JorgeCapelo" }, { "name": "Jorge Gouveia (DMIVP)", "code": "JorgeGouveiaDMIVP" }, { "name": "Jorge Jordão", "code": "JorgeJordao" }, { "name": "Jorge Pereira", "code": "JorgePereira" }, { "name": "Jorge Reis", "code": "JorgeReis" }, { "name": "José Afonso Dias", "code": "JoseAfonsoDias" }, { "name": "José Alexandre", "code": "JoseAlexandre" }, { "name": "José Cunha", "code": "JoseCunha" }, { "name": "José Lourenço", "code": "JoseLourenco" }, { "name": "José Martinho", "code": "JoseMartinho" }, { "name": "José Miguel Cabral", "code": "JoseMiguelCabral" }, { "name": "José Oliveira", "code": "JoseOliveira" }, { "name": "José Outeiro (DMIVP)", "code": "JoseOuteiroDMIVP" }, { "name": "Juliano (TRAFIURBE)", "code": "JulianoTrafiurbe" }, { "name": "Lilian (TRAFIURBE)", "code": "LilianTrafiurbe" }, { "name": "Lourdes Nunes", "code": "LourdesNunes" }, { "name": "Luís Filipe", "code": "LuisFilipe" }, { "name": "Manuela Reis", "code": "ManuelaReis" }, { "name": "Márcio (TRAFIURBE)", "code": "MarcioTrafiurbe" }, { "name": "Margarida Morais", "code": "MargaridaMorais" }, { "name": "Margarida Rodrigues", "code": "MargaridaRodrigues" }, { "name": "Mário Marques", "code": "MarioMarques" }, { "name": "Não conhecido", "code": "NC" }, { "name": "Oliveira", "code": "Oliveira" }, { "name": "Outeiro", "code": "Outeiro" }, { "name": "Outro", "code": "Outro" }, { "name": "Paula Antunes", "code": "PaulaAntunes" }, { "name": "Paula Dias", "code": "PaulaDias" }, { "name": "Paulo (Brigada CML)", "code": "PauloBrigadaCML" }, { "name": "Paulo Constantino", "code": "PauloConstantino" }, { "name": "Paulo (TRAFIURBE)", "code": "PauloTrafiurbe" }, { "name": "Pedro Barroca", "code": "PedroBarroca" }, { "name": "Pedro Lopes", "code": "PedroLopes" }, { "name": "Pedro Moniz Barreto", "code": "PedroMonizBarreto" }, { "name": "Polícia Municipal", "code": "PoliciaMunicipal" }, { "name": "PSP", "code": "PSP" }, { "name": "Requerente", "code": "Requerente" }, { "name": "Ricardo Gomes (FLGaspar)", "code": "RicardoGomes" }, { "name": "Rita Palmeiro", "code": "RitaPalmeiro" }, { "name": "Rita Raposo", "code": "RitaRaposo" }, { "name": "Rui Paixão", "code": "RuiPaixao" }, { "name": "Rui Paulo", "code": "RuiPaulo" }, { "name": "Sérgio (TRAFIURBE)", "code": "SergioTrafiurbe" }, { "name": "Sibila Sobral", "code": "SibilaSobral" }, { "name": "Sílvia Baeta", "code": "SilviaBaeta" }, { "name": "Sofia Norberto", "code": "SofiaNorberto" }, { "name": "Sofia Silvestre", "code": "SofiaSilvestre" }, { "name": "Sr. Abel", "code": "SrAbel" }, { "name": "Susana Paulo", "code": "SusanaPaulo" }, { "name": "Tiago Raimundo", "code": "TiagoRaimundo" }, { "name": "Tony (TRAFIURBE)", "code": "TonyTrafiurbe" }, { "name": "Vazil (TRAFIURBE)", "code": "VazilTrafiurbe" }, { "name": "Victor Canudo", "code": "VictorCanudo" }, { "name": "Vitor Fonseca", "code": "VitorFonseca" }, { "name": "Vladimir (TRAFIURBE)", "code": "VladimirTrafiurbe" }, { "name": "Alexandra Pinto", "code": "AlexandraPinto" }, { "name": "Pedro Ladeira", "code": "PedroLadeira" }, { "name": "Jorge Oliveira", "code": "JorgeOliveira" }, { "name": "Mafalda Pinto", "code": "MafaldaPinto" }, { "name": "António Figueiroa", "code": "AntonioFigueiroa" }, { "name": "Márcio Samora", "code": "MarcioSamora" }, { "name": "Paula Roxo", "code": "PaulaRoxo" }, { "name": "Ruben Matias", "code": "RubenMatias" }, { "name": "António Silva", "code": "Antonio Silva" }, { "name": "João Dias", "code": "JoaoDias" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ENTIDADEEXECUTORA", "type": "esriFieldTypeString", "alias": "Entidade executora", "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": "DATAEXECUCAO", "type": "esriFieldTypeDate", "alias": "Data de execução", "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": "G25021IDEXECUCAO", "fields": "IDEXECUCAO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G25021IDPROCESSO", "fields": "IDPROCESSO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R192048_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "vhdProcessos", "relatedTableId": 93, "role": "esriRelRoleOrigin", "keyField": "IDProcesso", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 5, "name": "vOperacoesVerticais", "relatedTableId": 40, "role": "esriRelRoleDestination", "keyField": "IDExecucao", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 6, "name": "vSinaisVerticais", "relatedTableId": 117, "role": "esriRelRoleDestination", "keyField": "IDExecucao", "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 }