{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 116, "name": "gpso.aop.GPSEO_EP_EP_COFFRET", "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\nCoordonnée en Y\n", "length": 255, "domain": null }, { "name": "cof_mis_service", "type": "esriFieldTypeDate", "alias": "COF_Mise en service\n", "length": 8, "domain": null }, { "name": "cof_date_dern_inv", "type": "esriFieldTypeDate", "alias": "COF_Date dernier inventaire\n", "length": 8, "domain": null }, { "name": "num_crosse", "type": "esriFieldTypeString", "alias": "N° de coffret", "length": 255, "domain": null }, { "name": "id_coffret", "type": "esriFieldTypeString", "alias": "ID_Coffret\n", "length": 255, "domain": null }, { "name": "cof_ep_fabric", "type": "esriFieldTypeString", "alias": "COF_EP_Fabricant\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_Cof_fabric", "description": "Fabricant coffret", "codedValues": [ { "name": "Abel", "code": "Abel" }, { "name": "Depagne", "code": "Depagne" }, { "name": "Grolleau", "code": "Grolleau" }, { "name": "Groupe Cahors", "code": "Groupe Cahors" }, { "name": "GURO", "code": "GURO" }, { "name": "Incotex Electronics Group", "code": "Incotex Electronics Group" }, { "name": "Legrand", "code": "Legrand" }, { "name": "Philips", "code": "Philips" }, { "name": "Seifel - Connection/protection", "code": "Seifel - Connection/protection" }, { "name": "Sogexi Lacroix", "code": "Sogexi Lacroix" }, { "name": "Sans objet", "code": "Sans objet" }, { "name": "Non connu", "code": "Non connu" }, { "name": "Autre", "code": "Autre" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cof_ep_fabric_autre", "type": "esriFieldTypeString", "alias": "COF_EP_Fabricant autre\n", "length": 255, "domain": null }, { "name": "cof_ep_modele", "type": "esriFieldTypeString", "alias": "COF_Modèle coffret\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_Cof_model", "description": "Modèle du coffret", "codedValues": [ { "name": "Blue Box", "code": "Blue Box" }, { "name": "C90", "code": "C90" }, { "name": "Citypak", "code": "Citypak" }, { "name": "Dynapak", "code": "Dynapak" }, { "name": "Ecofast", "code": "Ecofast" }, { "name": "Europak", "code": "Europak" }, { "name": "Flexy Fast 52", "code": "Flexy Fast 52" }, { "name": "Flexy Fast 82", "code": "Flexy Fast 82" }, { "name": "Grid Fast", "code": "Grid Fast" }, { "name": "Grid Fast SL31", "code": "Grid Fast SL31" }, { "name": "Interpak", "code": "Interpak" }, { "name": "Lightbox", "code": "Lightbox" }, { "name": "Lightbox Goulotte", "code": "Lightbox Goulotte" }, { "name": "Lightbox mini", "code": "Lightbox mini" }, { "name": "Lotipak", "code": "Lotipak" }, { "name": "Luxi", "code": "Luxi" }, { "name": "Micropak", "code": "Micropak" }, { "name": "Mini CP lum", "code": "Mini CP lum" }, { "name": "Minipak", "code": "Minipak" }, { "name": "Modul 35", "code": "Modul 35" }, { "name": "Modul 50", "code": "Modul 50" }, { "name": "Perfo Fast 52", "code": "Perfo Fast 52" }, { "name": "Perfo Fast 72", "code": "Perfo Fast 72" }, { "name": "Polypak", "code": "Polypak" }, { "name": "Streetbox L", "code": "Streetbox L" }, { "name": "Type 0", "code": "Type 0" }, { "name": "Type 1", "code": "Type 1" }, { "name": "Type 2", "code": "Type 2" }, { "name": "Type 3", "code": "Type 3" }, { "name": "Type 4", "code": "Type 4" }, { "name": "Type 593", "code": "Type 593" }, { "name": "Type 597", "code": "Type 597" }, { "name": "Type 598", "code": "Type 598" }, { "name": "Lumipak", "code": "Lumipak" }, { "name": "Non connu", "code": "Non connu" }, { "name": "Autre", "code": "Autre" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cof_ep_model_autre", "type": "esriFieldTypeString", "alias": "COF_Modèle autre coffret\n", "length": 255, "domain": null }, { "name": "cof_type_cable_elec", "type": "esriFieldTypeString", "alias": "COF_Type câble électrique\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_Energie_5", "description": "Type cable electrique", "codedValues": [ { "name": "PRC", "code": "PRC" }, { "name": "Cuivre nu", "code": "Cuivre nu" }, { "name": "Non connu", "code": "Non connu" }, { "name": "RO2V cuivre non armé (sans fourreau)", "code": "RO2V cuivre non armé (sans fourreau)" }, { "name": "RVFV cuivre armé (pour la pleine terre, sans fourreau)", "code": "RVFV cuivre armé (pour la pleine terre, sans fourreau)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cof_ep_protect_elec", "type": "esriFieldTypeString", "alias": "COF_EP_Protection électrique\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_cof_protect_elec", "description": "Protection électrique", "codedValues": [ { "name": "Coupe-circuit à fusible", "code": "Coupe-circuit à fusible" }, { "name": "Disjoncteur", "code": "Disjoncteur" }, { "name": "Disjoncteur différentiel", "code": "Disjoncteur différentiel" }, { "name": "Disjoncteur différentiel + coupe-circuit fusible", "code": "Disjoncteur différentiel + coupe-circuit fusible" }, { "name": "Pas de protection", "code": "Pas de protection" }, { "name": "Non connu", "code": "Non connu" }, { "name": "Autre", "code": "Autre" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cof_ep_protect_elec_autre", "type": "esriFieldTypeString", "alias": "COF_EP_Protection électrique autre\n", "length": 255, "domain": null }, { "name": "cof_ep_calibre_protect_elec", "type": "esriFieldTypeString", "alias": "COF_EP_Calibre de protection électrique\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_cof_calibre_protect_elec", "description": "Calibre de protection du coffret", "codedValues": [ { "name": "Non connu", "code": "Non connu" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "6", "code": "6" }, { "name": "8", "code": "8" }, { "name": "10", "code": "10" }, { "name": "16", "code": "16" }, { "name": "32", "code": "32" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cof_ep_pres_modul_communi", "type": "esriFieldTypeString", "alias": "COF_Présence module communicant\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_cof_pres_mod_com", "description": "Oui-Non-SO-NC", "codedValues": [ { "name": "Oui", "code": "Oui" }, { "name": "Non", "code": "Non" }, { "name": "Sans objet", "code": "Sans objet" }, { "name": "Non connu", "code": "Non connu" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cof_ep_pres_para", "type": "esriFieldTypeString", "alias": "COF_Présence Parasurtenseur\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_cof_pres_mod_com", "description": "Oui-Non-SO-NC", "codedValues": [ { "name": "Oui", "code": "Oui" }, { "name": "Non", "code": "Non" }, { "name": "Sans objet", "code": "Sans objet" }, { "name": "Non connu", "code": "Non connu" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cof_ep_pres_cof_class2", "type": "esriFieldTypeString", "alias": "COF_Présence coffret classe II\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_cof_pres_mod_com", "description": "Oui-Non-SO-NC", "codedValues": [ { "name": "Oui", "code": "Oui" }, { "name": "Non", "code": "Non" }, { "name": "Sans objet", "code": "Sans objet" }, { "name": "Non connu", "code": "Non connu" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cof_ep_schema_liais_terre", "type": "esriFieldTypeString", "alias": "COF_EP_Schéma de liaison à la Terre sur support\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": "cof_ep_pres_prises_illuminat", "type": "esriFieldTypeString", "alias": "COF_Présence prises d'illumination\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_cof_pres_mod_com", "description": "Oui-Non-SO-NC", "codedValues": [ { "name": "Oui", "code": "Oui" }, { "name": "Non", "code": "Non" }, { "name": "Sans objet", "code": "Sans objet" }, { "name": "Non connu", "code": "Non connu" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cof_ep_date_control_cable", "type": "esriFieldTypeDate", "alias": "COF_EP_Date contrôle câble\n", "length": 8, "domain": null }, { "name": "cof_ep_etat_vetust_cable", "type": "esriFieldTypeString", "alias": "COF_EP_Etat vétusté câble coffret\n", "length": 255, "domain": { "type": "codedValue", "name": "DEP_EP_cof_etat_vetust_cabl", "description": "Etat vétusté câble coffret", "codedValues": [ { "name": "Bon", "code": "Bon" }, { "name": "Moyen", "code": "Moyen" }, { "name": "Vétuste", "code": "Vétuste" }, { "name": "HS", "code": "HS" }, { "name": "Sans objet", "code": "Sans objet" }, { "name": "Non connu", "code": "Non connu" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "num_new_candelabre", "type": "esriFieldTypeString", "alias": "Nouveau n° de candélabre", "length": 100, "domain": null }, { "name": "num_new_coffret", "type": "esriFieldTypeString", "alias": "Nouveau n° de coffret", "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_44385_num_ca", "fields": "num_candelabre", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r3985_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "GPSEO_EP_EP_POINT_LUMINEUX", "relatedTableId": 117, "role": "esriRelRoleDestination", "keyField": "num_candelabre", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{F8FE6B27-79A1-4582-932E-6B0703F26614}" } ], "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" }