{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "Interventions sur les lampadaires", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "GOCITE.Support", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ID_LAMPADAIRE", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "LOCALISATION", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SECTEUR", "type": "esriFieldTypeInteger", "alias": "Secteur", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SECTEUR" }, { "name": "DATE_INTERVENTION", "type": "esriFieldTypeDate", "alias": "Date d'intervention", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATE_INTERVENTION" }, { "name": "NUMERO_REQUETE", "type": "esriFieldTypeInteger", "alias": "Numéro de la requête", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NUMERO_REQUETE" }, { "name": "LOCALISATION", "type": "esriFieldTypeString", "alias": "Localisation", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LOCALISATION" }, { "name": "LAMPE_WATT", "type": "esriFieldTypeSmallInteger", "alias": "Lampe (watt)", "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LAMPE_WATT" }, { "name": "BALLAST", "type": "esriFieldTypeString", "alias": "Ballast", "domain": { "type": "codedValue", "name": "dTypeBallastIntervention", "description": "Type de ballast pour intervention de lampadaires", "codedValues": [ { "name": "Ballast 70/120V", "code": "1" }, { "name": "Ballast 70/240V", "code": "2" }, { "name": "Ballast 100/240V", "code": "3" }, { "name": "Ballast 120/240V", "code": "4" }, { "name": "Ballast 150/120V", "code": "5" }, { "name": "Ballast 150/240V", "code": "6" }, { "name": "Ballast 250/240V", "code": "7" }, { "name": "Ballast 340V", "code": "8" }, { "name": "Ballast 600V", "code": "9" }, { "name": "N/A", "code": "10" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "BALLAST" }, { "name": "AMORCEUR", "type": "esriFieldTypeString", "alias": "Amorceur", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "AMORCEUR" }, { "name": "FUSIBLE", "type": "esriFieldTypeString", "alias": "Fusible", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "FUSIBLE" }, { "name": "PORTE_FUSIBLE", "type": "esriFieldTypeString", "alias": "Porte-fusibles", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "PORTE_FUSIBLE" }, { "name": "PROBLEME_BOITE_CONTROLE", "type": "esriFieldTypeString", "alias": "Problème boîte de contrôle", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "PROBLEME_BOITE_CONTROLE" }, { "name": "AUTRES", "type": "esriFieldTypeString", "alias": "Autres", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "AUTRES" }, { "name": "COMMENTAIRES", "type": "esriFieldTypeString", "alias": "Commentaires", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "COMMENTAIRES" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" }, { "name": "ID_LAMPADAIRE", "type": "esriFieldTypeGUID", "alias": "ID Lampadaire", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "ID_LAMPADAIRE" }, { "name": "CREATIONDATE", "type": "esriFieldTypeDate", "alias": "CreationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATIONDATE" }, { "name": "CREATOR", "type": "esriFieldTypeString", "alias": "Creator", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CREATOR" }, { "name": "EDITDATE", "type": "esriFieldTypeDate", "alias": "EditDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EDITDATE" }, { "name": "EDITOR", "type": "esriFieldTypeString", "alias": "Editor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EDITOR" } ], "indexes": [ { "name": "R450664_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_450664", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_450664", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Interventions sur les lampadaires", "description": "", "prototype": { "attributes": { "EDITDATE": null, "CREATOR": null, "SECTEUR": null, "DATE_INTERVENTION": null, "NUMERO_REQUETE": null, "LOCALISATION": null, "LAMPE_WATT": null, "BALLAST": null, "AMORCEUR": null, "FUSIBLE": null, "PORTE_FUSIBLE": null, "PROBLEME_BOITE_CONTROLE": null, "AUTRES": null, "COMMENTAIRES": null, "EDITOR": null, "ID_LAMPADAIRE": null, "CREATIONDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "32665ea1ce2e41858db2b19f5ac8df76" }