{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 120, "name": "gpso.aop.GPSEO_EP_EP_CROSSE", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "nom_voie", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "num_candelabre", "type": "esriFieldTypeString", "alias": "N° de candélabre\n", "length": 255, "domain": null }, { "name": "type_materiel", "type": "esriFieldTypeString", "alias": "Type de matériel\n", "length": 255, "domain": null }, { "name": "lot_geo_march", "type": "esriFieldTypeString", "alias": "Lot géographique marché\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_Ouvrage_1", "description": "Lot geographique marche", "codedValues": [ { "name": "Zone 1", "code": "Zone 1" }, { "name": "Zone 2", "code": "Zone 2" }, { "name": "Zone 3", "code": "Zone 3" }, { "name": "Zone 4", "code": "Zone 4" }, { "name": "Zone 5", "code": "Zone 5" }, { "name": "Zone_MLJ", "code": "Zone_MLJ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "commune", "type": "esriFieldTypeString", "alias": "Commune", "length": 255, "domain": { "type": "codedValue", "name": "carl_commune", "description": "Commune Syntaxe CARL", "codedValues": [ { "name": "Achères", "code": "Achères" }, { "name": "Andrésy", "code": "Andrésy" }, { "name": "Arnouville-lès-Mantes", "code": "Arnouville-lès-Mantes" }, { "name": "Aubergenville", "code": "Aubergenville" }, { "name": "Auffreville-Brasseuil", "code": "Auffreville-Brasseuil" }, { "name": "Aulnay-sur-Mauldre", "code": "Aulnay-sur-Mauldre" }, { "name": "Boinville-en-Mantois", "code": "Boinville-en-Mantois" }, { "name": "Bouafle", "code": "Bouafle" }, { "name": "Breuil-Bois-Robert", "code": "Breuil-Bois-Robert" }, { "name": "Brueil-en-Vexin", "code": "Brueil-en-Vexin" }, { "name": "Buchelay", "code": "Buchelay" }, { "name": "Carrières-sous-Poissy", "code": "Carrières-sous-Poissy" }, { "name": "Chanteloup-les-Vignes", "code": "Chanteloup-les-Vignes" }, { "name": "Chapet", "code": "Chapet" }, { "name": "Conflans St Honorine", "code": "Conflans St Honorine" }, { "name": "Drocourt", "code": "Drocourt" }, { "name": "Ecquevilly", "code": "Ecquevilly" }, { "name": "Épône", "code": "Épône" }, { "name": "Évecquemont", "code": "Évecquemont" }, { "name": "Favrieux", "code": "Favrieux" }, { "name": "Flacourt", "code": "Flacourt" }, { "name": "Flins-sur-Seine", "code": "Flins-sur-Seine" }, { "name": "Follainville-Dennemont", "code": "Follainville-Dennemont" }, { "name": "Fontenay-Mauvoisin", "code": "Fontenay-Mauvoisin" }, { "name": "Fontenay-Saint-Père", "code": "Fontenay-Saint-Père" }, { "name": "Gaillon-sur-Montcient", "code": "Gaillon-sur-Montcient" }, { "name": "Gargenville", "code": "Gargenville" }, { "name": "Goussonville", "code": "Goussonville" }, { "name": "Guernes", "code": "Guernes" }, { "name": "Guerville", "code": "Guerville" }, { "name": "Guitrancourt", "code": "Guitrancourt" }, { "name": "Hardricourt", "code": "Hardricourt" }, { "name": "Hargeville", "code": "Hargeville" }, { "name": "Issou", "code": "Issou" }, { "name": "Jambville", "code": "Jambville" }, { "name": "Jouy-Mauvoisin", "code": "Jouy-Mauvoisin" }, { "name": "Jumeauville", "code": "Jumeauville" }, { "name": "Juziers", "code": "Juziers" }, { "name": "La Falaise", "code": "La Falaise" }, { "name": "Lainville-en-Vexin", "code": "Lainville-en-Vexin" }, { "name": "Le Tertre-Saint-Denis", "code": "Le Tertre-Saint-Denis" }, { "name": "Les Alluets-le-Roi", "code": "Les Alluets-le-Roi" }, { "name": "Les Mureaux", "code": "Les Mureaux" }, { "name": "Limay", "code": "Limay" }, { "name": "Magnanville", "code": "Magnanville" }, { "name": "Mantes-la-Jolie", "code": "Mantes-la-Jolie" }, { "name": "Mantes-la-Ville", "code": "Mantes-la-Ville" }, { "name": "Médan", "code": "Médan" }, { "name": "Méricourt", "code": "Méricourt" }, { "name": "Meulan-en-Yvelines", "code": "Meulan-en-Yvelines" }, { "name": "Mézières-sur-Seine", "code": "Mézières-sur-Seine" }, { "name": "Mézy sur Seine", "code": "Mézy sur Seine" }, { "name": "Montalet-le-Bois", "code": "Montalet-le-Bois" }, { "name": "Morainvilliers", "code": "Morainvilliers" }, { "name": "Mousseaux-sur-Seine", "code": "Mousseaux-sur-Seine" }, { "name": "Nézel", "code": "Nézel" }, { "name": "Oinville-sur-Montcient", "code": "Oinville-sur-Montcient" }, { "name": "Orgeval", "code": "Orgeval" }, { "name": "Perdreauville", "code": "Perdreauville" }, { "name": "Poissy", "code": "Poissy" }, { "name": "Porcheville", "code": "Porcheville" }, { "name": "Rolleboise", "code": "Rolleboise" }, { "name": "Rosny-sur-Seine", "code": "Rosny-sur-Seine" }, { "name": "Sailly", "code": "Sailly" }, { "name": "Saint-Martin-la-Garenne", "code": "Saint-Martin-la-Garenne" }, { "name": "Soindres", "code": "Soindres" }, { "name": "Tessancourt-sur-Aubette", "code": "Tessancourt-sur-Aubette" }, { "name": "Triel-sur-Seine", "code": "Triel-sur-Seine" }, { "name": "Vaux-sur-Seine", "code": "Vaux-sur-Seine" }, { "name": "Verneuil-sur-Seine", "code": "Verneuil-sur-Seine" }, { "name": "Vernouillet", "code": "Vernouillet" }, { "name": "Vert", "code": "Vert" }, { "name": "Villennes-sur-Seine", "code": "Villennes-sur-Seine" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "quartier", "type": "esriFieldTypeString", "alias": "Quartier", "length": 255, "domain": null }, { "name": "nom_voie", "type": "esriFieldTypeString", "alias": "Nom de la voie\n", "length": 255, "domain": null }, { "name": "x", "type": "esriFieldTypeString", "alias": "Coordonnée en X\n", "length": 255, "domain": null }, { "name": "y", "type": "esriFieldTypeString", "alias": "Coordonnée en Y", "length": 255, "domain": null }, { "name": "cro_mis_service", "type": "esriFieldTypeDate", "alias": "CRO_Mise en service\n", "length": 8, "domain": null }, { "name": "cro_date_dern_inv", "type": "esriFieldTypeDate", "alias": "CRO_Date dernier inventaire\n", "length": 8, "domain": null }, { "name": "num_crosse", "type": "esriFieldTypeString", "alias": "N° de crosse\n", "length": 255, "domain": null }, { "name": "id_crosse", "type": "esriFieldTypeString", "alias": "ID_Crosse\n", "length": 255, "domain": null }, { "name": "cro_fabric", "type": "esriFieldTypeString", "alias": "CRO_Fabricant\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_Support", "description": "Fabricant support", "codedValues": [ { "name": "Aubrilam", "code": "Aubrilam" }, { "name": "Blachère", "code": "Blachère" }, { "name": "Comatelec", "code": "Comatelec" }, { "name": "Eclatec", "code": "Eclatec" }, { "name": "Fonte de Paris", "code": "Fonte de Paris" }, { "name": "GHM", "code": "GHM" }, { "name": "Mazda", "code": "Mazda" }, { "name": "Petitjean", "code": "Petitjean" }, { "name": "Thorn", "code": "Thorn" }, { "name": "Valmont", "code": "Valmont" }, { "name": "Non connu", "code": "Non connu" }, { "name": "Autre", "code": "Autre" }, { "name": "Selux", "code": "Selux" }, { "name": "Conimast / Galva", "code": "Conimast / Galva" }, { "name": "Degembes", "code": "Degembes" }, { "name": "Disano", "code": "Disano" }, { "name": "Indal", "code": "Indal" }, { "name": "Lenzi", "code": "Lenzi" }, { "name": "Louis Poulsen", "code": "Louis Poulsen" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cro_modele", "type": "esriFieldTypeString", "alias": "CRO_Modèle crosse\n", "length": 255, "domain": null }, { "name": "cro_saillie", "type": "esriFieldTypeString", "alias": "CRO_Saillie crosse\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_Cro_saillie", "description": "Saillie crosse", "codedValues": [ { "name": "Sans objet", "code": "Sans objet" }, { "name": "0", "code": "0" }, { "name": "0,15", "code": "0,15" }, { "name": "0,2", "code": "0,2" }, { "name": "0,25", "code": "0,25" }, { "name": "0,3", "code": "0,3" }, { "name": "0,35", "code": "0,35" }, { "name": "0,4", "code": "0,4" }, { "name": "0,45", "code": "0,45" }, { "name": "0,5", "code": "0,5" }, { "name": "0,55", "code": "0,55" }, { "name": "0,6", "code": "0,6" }, { "name": "0,65", "code": "0,65" }, { "name": "0,7", "code": "0,7" }, { "name": "0,75", "code": "0,75" }, { "name": "0,8", "code": "0,8" }, { "name": "0,85", "code": "0,85" }, { "name": "0,9", "code": "0,9" }, { "name": "0,95", "code": "0,95" }, { "name": "1", "code": "1" }, { "name": "1,05", "code": "1,05" }, { "name": "1,1", "code": "1,1" }, { "name": "1,15", "code": "1,15" }, { "name": "1,2", "code": "1,2" }, { "name": "1,25", "code": "1,25" }, { "name": "1,3", "code": "1,3" }, { "name": "1,35", "code": "1,35" }, { "name": "1,4", "code": "1,4" }, { "name": "1,45", "code": "1,45" }, { "name": "1,5", "code": "1,5" }, { "name": "1,55", "code": "1,55" }, { "name": "1,6", "code": "1,6" }, { "name": "1,65", "code": "1,65" }, { "name": "1,7", "code": "1,7" }, { "name": "1,75", "code": "1,75" }, { "name": "1,8", "code": "1,8" }, { "name": "1,85", "code": "1,85" }, { "name": "1,9", "code": "1,9" }, { "name": "1,95", "code": "1,95" }, { "name": "2", "code": "2" }, { "name": "2,05", "code": "2,05" }, { "name": "2,1", "code": "2,1" }, { "name": "2,15", "code": "2,15" }, { "name": "2,2", "code": "2,2" }, { "name": "2,25", "code": "2,25" }, { "name": "2,3", "code": "2,3" }, { "name": "2,35", "code": "2,35" }, { "name": "2,4", "code": "2,4" }, { "name": "2,45", "code": "2,45" }, { "name": "2,5", "code": "2,5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cro_materiau", "type": "esriFieldTypeString", "alias": "CRO_Matériau crosse\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_cro_materiau", "description": "Matériau crosse", "codedValues": [ { "name": "Acier", "code": "Acier" }, { "name": "Acier galvanisé", "code": "Acier galvanisé" }, { "name": "Aluminium", "code": "Aluminium" }, { "name": "Fer forgé", "code": "Fer forgé" }, { "name": "Fonte", "code": "Fonte" }, { "name": "Non connu", "code": "Non connu" }, { "name": "Sans objet", "code": "Sans objet" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cro_date_remise_peint", "type": "esriFieldTypeDate", "alias": "CRO_Date remise en peinture crosse\n", "length": 8, "domain": null }, { "name": "cro_date_control", "type": "esriFieldTypeDate", "alias": "CRO_Date contrôle crosse\n", "length": 8, "domain": null }, { "name": "cro_etat_vetust", "type": "esriFieldTypeString", "alias": "CRO_Etat vétusté crosse\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_Cro_etat_vetust", "description": "Etat vétusté crosse", "codedValues": [ { "name": "Conforme", "code": "Conforme" }, { "name": "Moyen", "code": "Moyen" }, { "name": "Vétuste", "code": "Vétuste" }, { "name": "Non conforme", "code": "Non conforme" }, { "name": "Vétuste avec présence de corrosion", "code": "Vétuste avec présence de corrosion" }, { "name": "Sans objet", "code": "Sans objet" }, { "name": "Non connu", "code": "Non connu" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cro_commentaire_visit", "type": "esriFieldTypeString", "alias": "CRO_Commentaire suite visite\n", "length": 255, "domain": null }, { "name": "num_new_candelabre", "type": "esriFieldTypeString", "alias": "Nouveau n° de candélabre", "length": 100, "domain": null }, { "name": "num_new_crosse", "type": "esriFieldTypeString", "alias": "Nouveau n° de crosse", "length": 100, "domain": null }, { "name": "cro_fabric_autr", "type": "esriFieldTypeString", "alias": "cro_fabric_autr", "length": 255, "domain": null }, { "name": "cro_couleur", "type": "esriFieldTypeString", "alias": "cro_couleur", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_Cro_couleur", "description": "Couleur crosse", "codedValues": [ { "name": "RAL 9021 - Noir goudron", "code": "RAL 9021 - Noir goudron" }, { "name": "RAL 1014 - Ivoire", "code": "RAL 1014 - Ivoire" }, { "name": "RAL 1015 - Ivoire clair", "code": "RAL 1015 - Ivoire clair" }, { "name": "RAL 6026 - Vert opale", "code": "RAL 6026 - Vert opale" }, { "name": "Beige", "code": "Beige" }, { "name": "Bicolore : blanc / bleu", "code": "Bicolore : blanc / bleu" }, { "name": "Bicolore : blanc / rouille", "code": "Bicolore : blanc / rouille" }, { "name": "Blanc", "code": "Blanc" }, { "name": "Bleu", "code": "Bleu" }, { "name": "Bordeaux", "code": "Bordeaux" }, { "name": "Bronze", "code": "Bronze" }, { "name": "Brun / Marron", "code": "Brun / Marron" }, { "name": "Gris", "code": "Gris" }, { "name": "Noir", "code": "Noir" }, { "name": "Rose", "code": "Rose" }, { "name": "Rouge", "code": "Rouge" }, { "name": "Sablé", "code": "Sablé" }, { "name": "Violet", "code": "Violet" }, { "name": "Vert", "code": "Vert" }, { "name": "Sans objet", "code": "Sans objet" }, { "name": "Non connu", "code": "Non connu" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "gdb_44374_num_ca", "fields": "num_candelabre", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r3982_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "GPSEO_EP_EP_POINT_LUMINEUX", "relatedTableId": 117, "role": "esriRelRoleDestination", "keyField": "num_candelabre", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{0DE2B477-0C36-4D08-8C1C-BFD35925EB6B}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "d88d50087f3041a5a0e95f49b71a2d0d" }