{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 123, "name": "gpso.aop.GPSEO_EP_EP_SUPPORT", "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": "sup_mis_service", "type": "esriFieldTypeDate", "alias": "SUP_Mise en service\n", "length": 8, "domain": null }, { "name": "sup_date_dern_inv", "type": "esriFieldTypeDate", "alias": "SUP_Date dernier inventaire\n", "length": 8, "domain": null }, { "name": "num_support", "type": "esriFieldTypeString", "alias": "N° du support\n", "length": 255, "domain": null }, { "name": "id_support", "type": "esriFieldTypeString", "alias": "ID_Support\n", "length": 255, "domain": null }, { "name": "sup_fabric", "type": "esriFieldTypeString", "alias": "SUP_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": "sup_fabric_autr", "type": "esriFieldTypeString", "alias": "SUP_Fabricant autre\n", "length": 255, "domain": null }, { "name": "sup_modele", "type": "esriFieldTypeString", "alias": "SUP_Modèle mât\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_Support_2", "description": "Modèle mât", "codedValues": [ { "name": "AD0 - AD1", "code": "AD0 - AD1" }, { "name": "AE1 - AE2", "code": "AE1 - AE2" }, { "name": "Centurion A", "code": "Centurion A" }, { "name": "Galaxie", "code": "Galaxie" }, { "name": "Oméga 60", "code": "Oméga 60" }, { "name": "Oméga 62", "code": "Oméga 62" }, { "name": "Non connu", "code": "Non connu" }, { "name": "Autre", "code": "Autre" }, { "name": "Auriga", "code": "Auriga" }, { "name": "Saturne", "code": "Saturne" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sup_model_autr_mat", "type": "esriFieldTypeString", "alias": "SUP_Modèle autre mât\n", "length": 255, "domain": null }, { "name": "sup_haut_mat", "type": "esriFieldTypeString", "alias": "SUP_Hauteur mât en m\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_Sup_haut_mat", "description": "Hauteur mat", "codedValues": [ { "name": "Non connu", "code": "Non connu" }, { "name": "0", "code": "0" }, { "name": "0.5", "code": "0.5" }, { "name": "0.8", "code": "0.8" }, { "name": "1", "code": "1" }, { "name": "1.2", "code": "1.2" }, { "name": "1.5", "code": "1.5" }, { "name": "1.7", "code": "1.7" }, { "name": "1.8", "code": "1.8" }, { "name": "2", "code": "2" }, { "name": "2.5", "code": "2.5" }, { "name": "2.7", "code": "2.7" }, { "name": "2.8", "code": "2.8" }, { "name": "3", "code": "3" }, { "name": "3.2", "code": "3.2" }, { "name": "3.4", "code": "3.4" }, { "name": "3.5", "code": "3.5" }, { "name": "3.7", "code": "3.7" }, { "name": "3.75", "code": "3.75" }, { "name": "3.8", "code": "3.8" }, { "name": "4", "code": "4" }, { "name": "4.1", "code": "4.1" }, { "name": "4.2", "code": "4.2" }, { "name": "4.4", "code": "4.4" }, { "name": "4.5", "code": "4.5" }, { "name": "4.7", "code": "4.7" }, { "name": "5", "code": "5" }, { "name": "5.5", "code": "5.5" }, { "name": "6", "code": "6" }, { "name": "6.5", "code": "6.5" }, { "name": "7", "code": "7" }, { "name": "7.5", "code": "7.5" }, { "name": "8", "code": "8" }, { "name": "8.5", "code": "8.5" }, { "name": "9", "code": "9" }, { "name": "9.5", "code": "9.5" }, { "name": "10", "code": "10" }, { "name": "10.5", "code": "10.5" }, { "name": "11", "code": "11" }, { "name": "11.5", "code": "11.5" }, { "name": "12", "code": "12" }, { "name": "13", "code": "13" }, { "name": "14", "code": "14" }, { "name": "15", "code": "15" }, { "name": "16", "code": "16" }, { "name": "18", "code": "18" }, { "name": "20", "code": "20" }, { "name": "23", "code": "23" }, { "name": "25", "code": "25" }, { "name": "27", "code": "27" }, { "name": "30", "code": "30" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sup_form_mat", "type": "esriFieldTypeString", "alias": "SUP_Forme mât\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_Sup_form_mat", "description": "Forme mât", "codedValues": [ { "name": "Octo-conique basculant", "code": "Octo-conique basculant" }, { "name": "Octogonal", "code": "Octogonal" }, { "name": "Rectangulaire", "code": "Rectangulaire" }, { "name": "Sous halle ?", "code": "Sous halle ?" }, { "name": "Sans objet", "code": "Sans objet" }, { "name": "Non connu", "code": "Non connu" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sup_materiau_mat", "type": "esriFieldTypeString", "alias": "SUP_Matériau mât\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_Sup_materiau_mat", "description": "Matériau mât", "codedValues": [ { "name": "Acier", "code": "Acier" }, { "name": "Acier galvanisé", "code": "Acier galvanisé" }, { "name": "Aluminium", "code": "Aluminium" }, { "name": "Béton", "code": "Béton" }, { "name": "Bois", "code": "Bois" }, { "name": "Fonte", "code": "Fonte" }, { "name": "Pierre", "code": "Pierre" }, { "name": "Sans objet", "code": "Sans objet" }, { "name": "Non connu", "code": "Non connu" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sup_couleur_mat", "type": "esriFieldTypeString", "alias": "SUP_Couleur mât\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_Sup_couleur_mat", "description": "Couleur mât", "codedValues": [ { "name": "RAL 6012 - Vert noir", "code": "RAL 6012 - Vert noir" }, { "name": "RAL 7024 - Gris graphite", "code": "RAL 7024 - Gris graphite" }, { "name": "RAL 8017 - Brun chocolat", "code": "RAL 8017 - Brun chocolat" }, { "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": "RAL 900 - Gris sablé", "code": "RAL 900 - Gris sablé" }, { "name": "RAL 9021 - Noir goudron", "code": "RAL 9021 - Noir goudron" }, { "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": "Sans objet", "code": "Sans objet" }, { "name": "Non connu", "code": "Non connu" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sup_date_remis_peintur", "type": "esriFieldTypeDate", "alias": "SUP_Date remise en peinture support\n", "length": 8, "domain": null }, { "name": "sup_schema_liais_terre", "type": "esriFieldTypeString", "alias": "SUP_Schéma de liaison à la Terre EP\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_SLT_env_schema_liais", "description": "Schéma liaison à la terre", "codedValues": [ { "name": "TT", "code": "TT" }, { "name": "TN", "code": "TN" }, { "name": "TNS", "code": "TNS" }, { "name": "TNC", "code": "TNC" }, { "name": "Non connu", "code": "Non connu" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sup_date_control_mat", "type": "esriFieldTypeDate", "alias": "SUP_Date contrôle mât\n", "length": 8, "domain": null }, { "name": "sup_etat_vetust_mat", "type": "esriFieldTypeString", "alias": "SUP_Etat vétusté mât\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_Sup_etat_vetu", "description": "Etat vétusté mât", "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": "sup_commentair_visite", "type": "esriFieldTypeString", "alias": "SUP_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_support", "type": "esriFieldTypeString", "alias": "Nouveau n° de support", "length": 100, "domain": null }, { "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_44379_num_ca", "fields": "num_candelabre", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r3984_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "GPSEO_EP_EP_POINT_LUMINEUX", "relatedTableId": 117, "role": "esriRelRoleDestination", "keyField": "num_candelabre", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{3DE39C1A-722D-4364-B80B-642B044E0270}" } ], "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" }