{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 500, "name": "MOB-Bdd_charges", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "", "displayField": "nom_du_badge", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "objectid_1", "type": "esriFieldTypeDouble", "alias": "objectid", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "objectid_1" }, { "name": "facturation_ttc_total", "type": "esriFieldTypeDouble", "alias": "facturation_ttc_total", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "facturation_ttc_total" }, { "name": "facturation_ttc_forfait", "type": "esriFieldTypeDouble", "alias": "facturation_ttc_forfait", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "facturation_ttc_forfait" }, { "name": "facturation_ttc_au_temps", "type": "esriFieldTypeDouble", "alias": "facturation_ttc_au_temps", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "facturation_ttc_au_temps" }, { "name": "facturation_ht_total", "type": "esriFieldTypeDouble", "alias": "facturation_ht_total", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "facturation_ht_total" }, { "name": "facturation_ht_forfait", "type": "esriFieldTypeDouble", "alias": "facturation_ht_forfait", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "facturation_ht_forfait" }, { "name": "facturation_ht_au_temps", "type": "esriFieldTypeDouble", "alias": "facturation_ht_au_temps", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "facturation_ht_au_temps" }, { "name": "consommations_en_mwh", "type": "esriFieldTypeDouble", "alias": "consommations_en_mwh", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "consommations_en_mwh" }, { "name": "code_insee", "type": "esriFieldTypeString", "alias": "code_insee", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "code_insee" }, { "name": "duree_heures", "type": "esriFieldTypeDouble", "alias": "duree_heures", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "duree_heures" }, { "name": "duree_hm", "type": "esriFieldTypeDouble", "alias": "duree_hm", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "duree_hm" }, { "name": "station", "type": "esriFieldTypeString", "alias": "station", "domain": null, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "station" }, { "name": "borne", "type": "esriFieldTypeString", "alias": "borne", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "borne" }, { "name": "type_de_prise", "type": "esriFieldTypeString", "alias": "type_de_prise", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "type_de_prise" }, { "name": "prise_de_courant", "type": "esriFieldTypeSmallInteger", "alias": "prise_de_courant", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "prise_de_courant" }, { "name": "fabricant", "type": "esriFieldTypeString", "alias": "fabricant", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "fabricant" }, { "name": "date_de_debut", "type": "esriFieldTypeDate", "alias": "date_de_debut", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "date_de_debut" }, { "name": "jour_de_debut", "type": "esriFieldTypeInteger", "alias": "jour_de_debut", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "jour_de_debut" }, { "name": "mois_de_debut", "type": "esriFieldTypeInteger", "alias": "mois_de_debut", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "mois_de_debut" }, { "name": "annee_de_debut", "type": "esriFieldTypeInteger", "alias": "annee_de_debut", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "annee_de_debut" }, { "name": "heure_de_debut", "type": "esriFieldTypeInteger", "alias": "heure_de_debut", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "heure_de_debut" }, { "name": "minute_de_debut", "type": "esriFieldTypeInteger", "alias": "minute_de_debut", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "minute_de_debut" }, { "name": "date_de_fin", "type": "esriFieldTypeDate", "alias": "date_de_fin", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "date_de_fin" }, { "name": "jour_de_fin", "type": "esriFieldTypeInteger", "alias": "jour_de_fin", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "jour_de_fin" }, { "name": "mois_de_fin", "type": "esriFieldTypeInteger", "alias": "mois_de_fin", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "mois_de_fin" }, { "name": "annee_de_fin", "type": "esriFieldTypeInteger", "alias": "annee_de_fin", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "annee_de_fin" }, { "name": "heure_de_fin", "type": "esriFieldTypeInteger", "alias": "heure_de_fin", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "heure_de_fin" }, { "name": "minute_de_fin", "type": "esriFieldTypeInteger", "alias": "minute_de_fin", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "minute_de_fin" }, { "name": "duree_sec", "type": "esriFieldTypeInteger", "alias": "duree_sec", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "duree_sec" }, { "name": "energie_wh", "type": "esriFieldTypeInteger", "alias": "energie_wh", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "energie_wh" }, { "name": "puissance_max_w", "type": "esriFieldTypeInteger", "alias": "puissance_max_w", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "puissance_max_w" }, { "name": "nom_du_badge", "type": "esriFieldTypeString", "alias": "nom_du_badge", "domain": null, "editable": true, "nullable": true, "length": 55, "defaultValue": null, "modelName": "nom_du_badge" }, { "name": "uuid_badge", "type": "esriFieldTypeString", "alias": "uuid_badge", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "uuid_badge" }, { "name": "nombre_charges", "type": "esriFieldTypeInteger", "alias": "nombre_charges", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "nombre_charges" }, { "name": "identification_badge_technique", "type": "esriFieldTypeString", "alias": "identification_badge_technique", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "identification_badge_technique" }, { "name": "charges_reussies_wh", "type": "esriFieldTypeString", "alias": "charges_reussies_wh", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "charges_reussies_wh" }, { "name": "charges_reussies_3_min", "type": "esriFieldTypeString", "alias": "charges_reussies_3_min", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "charges_reussies_3_min" }, { "name": "calcul_client", "type": "esriFieldTypeString", "alias": "calcul_client", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "calcul_client" }, { "name": "type_client", "type": "esriFieldTypeString", "alias": "type_client", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "type_client" }, { "name": "code_postal_borne", "type": "esriFieldTypeInteger", "alias": "code_postal_borne", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "code_postal_borne" }, { "name": "epci", "type": "esriFieldTypeString", "alias": "epci", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "epci" }, { "name": "territoire_sdesm", "type": "esriFieldTypeString", "alias": "territoire_sdesm", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "territoire_sdesm" }, { "name": "pdl", "type": "esriFieldTypeString", "alias": "pdl", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "pdl" }, { "name": "code_postal_residence_badge_uti", "type": "esriFieldTypeInteger", "alias": "code_postal_residence_badge_uti", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "code_postal_residence_badge_uti" }, { "name": "charge_resident_ou_exterieur", "type": "esriFieldTypeString", "alias": "charge_resident_ou_exterieur", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "charge_resident_ou_exterieur" }, { "name": "modele_vehicule", "type": "esriFieldTypeString", "alias": "modele_vehicule", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "modele_vehicule" }, { "name": "jour_semaine_de_debut", "type": "esriFieldTypeString", "alias": "jour_semaine_de_debut", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "jour_semaine_de_debut" }, { "name": "jour_semaine_de_fin", "type": "esriFieldTypeString", "alias": "jour_semaine_de_fin", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "jour_semaine_de_fin" }, { "name": "charge_superieure_a_3h", "type": "esriFieldTypeString", "alias": "charge_superieure_a_3h", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "charge_superieure_a_3h" }, { "name": "emp", "type": "esriFieldTypeString", "alias": "emp", "domain": null, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "emp" }, { "name": "charge_simulatanee_pdc", "type": "esriFieldTypeString", "alias": "charge_simulatanee_pdc", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "charge_simulatanee_pdc" }, { "name": "minutes_simulatanee_pdc", "type": "esriFieldTypeInteger", "alias": "minutes_simulatanee_pdc", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "minutes_simulatanee_pdc" }, { "name": "date_integration", "type": "esriFieldTypeDateOnly", "alias": "date_integration", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "date_integration" } ], "indexes": [ { "name": "r2878_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MOB-Bdd_charges", "description": "", "prototype": { "attributes": { "minutes_simulatanee_pdc": null, "date_integration": null, "objectid_1": 0, "facturation_ttc_total": null, "facturation_ttc_forfait": null, "facturation_ttc_au_temps": null, "facturation_ht_total": null, "facturation_ht_forfait": null, "facturation_ht_au_temps": null, "consommations_en_mwh": null, "code_insee": null, "duree_heures": null, "duree_hm": null, "station": null, "borne": null, "type_de_prise": null, "prise_de_courant": null, "fabricant": null, "date_de_debut": null, "jour_de_debut": null, "mois_de_debut": null, "annee_de_debut": null, "heure_de_debut": null, "minute_de_debut": null, "date_de_fin": null, "jour_de_fin": null, "mois_de_fin": null, "annee_de_fin": null, "heure_de_fin": null, "minute_de_fin": null, "duree_sec": null, "energie_wh": null, "puissance_max_w": null, "nom_du_badge": null, "uuid_badge": null, "nombre_charges": null, "identification_badge_technique": null, "charges_reussies_wh": null, "charges_reussies_3_min": null, "calcul_client": null, "type_client": null, "code_postal_borne": null, "epci": null, "territoire_sdesm": null, "pdl": null, "code_postal_residence_badge_uti": null, "charge_resident_ou_exterieur": null, "modele_vehicule": null, "jour_semaine_de_debut": null, "jour_semaine_de_fin": null, "charge_superieure_a_3h": null, "emp": null, "charge_simulatanee_pdc": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "28ac031ff80643a78224bf754e3cc766" }