{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "Conversion DEL des luminaires", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ARRONDISSEMENT", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ARRONDISSEMENT", "type": "esriFieldTypeSmallInteger", "alias": "Arrondissement", "domain": { "type": "codedValue", "name": "dArrond", "description": "Arrondissement", "codedValues": [ { "name": "Greenfield Park", "code": 1 }, { "name": "Saint-Hubert", "code": 2 }, { "name": "Vieux-Longueuil", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SUPPORT_ID", "type": "esriFieldTypeString", "alias": "Support ID", "length": 25, "domain": null }, { "name": "CONVERSION_LUMINAIRE", "type": "esriFieldTypeSmallInteger", "alias": "Conversion du luminaire", "domain": { "type": "codedValue", "name": "dOuiNon_2", "description": "Oui/Non", "codedValues": [ { "name": "Oui", "code": 1 }, { "name": "Non", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DATECOLLECTE", "type": "esriFieldTypeDate", "alias": "Date de collecte", "length": 8, "domain": null }, { "name": "PUISSANCE_NEWLUMINAIRE", "type": "esriFieldTypeSmallInteger", "alias": "Puissance du nouveau luminaire", "domain": { "type": "codedValue", "name": "dPuissanceEclairage", "description": "", "codedValues": [ { "name": "1000W", "code": 8 }, { "name": "100W", "code": 3 }, { "name": "105W", "code": 33 }, { "name": "108W", "code": 35 }, { "name": "110W", "code": 31 }, { "name": "140W", "code": 41 }, { "name": "145W", "code": 32 }, { "name": "150W", "code": 4 }, { "name": "160W", "code": 26 }, { "name": "175W", "code": 22 }, { "name": "180W", "code": 39 }, { "name": "190W", "code": 45 }, { "name": "200W", "code": 5 }, { "name": "20W", "code": 40 }, { "name": "250W", "code": 6 }, { "name": "270W", "code": 25 }, { "name": "335W", "code": 46 }, { "name": "35W", "code": 27 }, { "name": "400W", "code": 7 }, { "name": "40W", "code": 36 }, { "name": "50W", "code": 19 }, { "name": "54W", "code": 28 }, { "name": "55W", "code": 38 }, { "name": "60W", "code": 23 }, { "name": "64W", "code": 47 }, { "name": "65W", "code": 21 }, { "name": "70W", "code": 1 }, { "name": "72W", "code": 20 }, { "name": "78W", "code": 29 }, { "name": "80W", "code": 34 }, { "name": "81W", "code": 30 }, { "name": "83W", "code": 43 }, { "name": "90W", "code": 2 }, { "name": "91W", "code": 48 }, { "name": "N/A", "code": 18 }, { "name": "46W", "code": 49 }, { "name": "45W", "code": 50 }, { "name": "93W", "code": 51 }, { "name": "79W", "code": 52 }, { "name": "152W", "code": 53 }, { "name": "63W", "code": 54 }, { "name": "106W", "code": 55 }, { "name": "174W", "code": 56 }, { "name": "53W", "code": 57 }, { "name": "38W", "code": 58 }, { "name": "24W", "code": 59 }, { "name": "30W", "code": 60 }, { "name": "25W", "code": 61 }, { "name": "324W", "code": 62 }, { "name": "141W", "code": 63 }, { "name": "36W", "code": 64 }, { "name": "15W", "code": 65 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REMARQUES", "type": "esriFieldTypeString", "alias": "Remarques", "length": 500, "domain": null }, { "name": "SCAN", "type": "esriFieldTypeString", "alias": "Scan ou code QR", "length": 255, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "GLOBALID_SUPPORT", "type": "esriFieldTypeGUID", "alias": "GLOBALID_Support", "length": 38, "domain": null }, { "name": "ANOMALIES", "type": "esriFieldTypeInteger", "alias": "Anomalies détectées 1", "domain": { "type": "codedValue", "name": "dAnomaliesInstallationDEL", "description": "Anomalies d'installation des luminaires DEL", "codedValues": [ { "name": "Absence de porte-fusible", "code": 1 }, { "name": "Conducteurs endommagés", "code": 2 }, { "name": "Distance d'approche haute tension", "code": 3 }, { "name": "Luminaire déjà converti laissé en place", "code": 7 }, { "name": "Luminaire inaccessible", "code": 8 }, { "name": "Porte de lampadaire à remplacer", "code": 4 }, { "name": "Potence sur poteau de bois à ajuster ou remplacer par HQ", "code": 5 }, { "name": "Lampadaire absent", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ANOMALIES_2", "type": "esriFieldTypeInteger", "alias": "Anomalies détectées 2", "domain": { "type": "codedValue", "name": "dAnomaliesInstallationDEL", "description": "Anomalies d'installation des luminaires DEL", "codedValues": [ { "name": "Absence de porte-fusible", "code": 1 }, { "name": "Conducteurs endommagés", "code": 2 }, { "name": "Distance d'approche haute tension", "code": 3 }, { "name": "Luminaire déjà converti laissé en place", "code": 7 }, { "name": "Luminaire inaccessible", "code": 8 }, { "name": "Porte de lampadaire à remplacer", "code": 4 }, { "name": "Potence sur poteau de bois à ajuster ou remplacer par HQ", "code": 5 }, { "name": "Lampadaire absent", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ANOMALIES_3", "type": "esriFieldTypeInteger", "alias": "Anomalies détectées 3", "domain": { "type": "codedValue", "name": "dAnomaliesInstallationDEL", "description": "Anomalies d'installation des luminaires DEL", "codedValues": [ { "name": "Absence de porte-fusible", "code": 1 }, { "name": "Conducteurs endommagés", "code": 2 }, { "name": "Distance d'approche haute tension", "code": 3 }, { "name": "Luminaire déjà converti laissé en place", "code": 7 }, { "name": "Luminaire inaccessible", "code": 8 }, { "name": "Porte de lampadaire à remplacer", "code": 4 }, { "name": "Potence sur poteau de bois à ajuster ou remplacer par HQ", "code": 5 }, { "name": "Lampadaire absent", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ANOMALIES_4", "type": "esriFieldTypeInteger", "alias": "Anomalies détectées 4", "domain": { "type": "codedValue", "name": "dAnomaliesInstallationDEL", "description": "Anomalies d'installation des luminaires DEL", "codedValues": [ { "name": "Absence de porte-fusible", "code": 1 }, { "name": "Conducteurs endommagés", "code": 2 }, { "name": "Distance d'approche haute tension", "code": 3 }, { "name": "Luminaire déjà converti laissé en place", "code": 7 }, { "name": "Luminaire inaccessible", "code": 8 }, { "name": "Porte de lampadaire à remplacer", "code": 4 }, { "name": "Potence sur poteau de bois à ajuster ou remplacer par HQ", "code": 5 }, { "name": "Lampadaire absent", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "GDB_58881_SUPPOR", "fields": "SUPPORT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R1260259_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1260259", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_1260259", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "GOCITE.Support", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GLOBALID_SUPPORT", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "1a1e48b5a4cc4aa99595cf3b31331d8c" }