{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "Pedestrian_Vehicle_Counting_Data", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsDistinct": true, "supportsPagination": true, "supportsOrderBy": true, "supportsPaginationOnAggregatedQueries": true, "supportsQueryWithResultType": true, "supportsHavingClause": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsOrderByOnlyOnLayerFields": false, "supportsPercentileStatistics": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithDatumTransformation": true }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": null, "displayField": "device_name", "typeIdField": "", "fields": [ { "name": "organisation", "type": "esriFieldTypeString", "alias": "organisation", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "organisation" }, { "name": "device_id", "type": "esriFieldTypeString", "alias": "device_id", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "device_id" }, { "name": "device_name", "type": "esriFieldTypeString", "alias": "device_name", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "device_name" }, { "name": "device_type", "type": "esriFieldTypeString", "alias": "device_type", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "device_type" }, { "name": "new_", "type": "esriFieldTypeInteger", "alias": "new_", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "new_" }, { "name": "current", "type": "esriFieldTypeInteger", "alias": "current", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "current" }, { "name": "left_", "type": "esriFieldTypeInteger", "alias": "left_", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "left_" }, { "name": "left_avg_mins_dwell_time", "type": "esriFieldTypeInteger", "alias": "left_avg_mins_dwell_time", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "left_avg_mins_dwell_time" }, { "name": "total", "type": "esriFieldTypeInteger", "alias": "total", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "total" }, { "name": "datetime", "type": "esriFieldTypeString", "alias": "datetime", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "datetime" }, { "name": "dayofweek", "type": "esriFieldTypeString", "alias": "dayofweek", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "dayofweek" }, { "name": "month", "type": "esriFieldTypeString", "alias": "month", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "month" }, { "name": "year", "type": "esriFieldTypeString", "alias": "year", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "year" }, { "name": "datetime_local", "type": "esriFieldTypeString", "alias": "datetime_local", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "datetime_local" }, { "name": "dayofweek_local", "type": "esriFieldTypeString", "alias": "dayofweek_local", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "dayofweek_local" }, { "name": "month_local", "type": "esriFieldTypeString", "alias": "month_local", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "month_local" }, { "name": "year_local", "type": "esriFieldTypeString", "alias": "year_local", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "year_local" }, { "name": "latitude", "type": "esriFieldTypeDouble", "alias": "latitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "latitude" }, { "name": "longitude", "type": "esriFieldTypeDouble", "alias": "longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "longitude" }, { "name": "portal_last_updated", "type": "esriFieldTypeString", "alias": "portal_last_updated", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "portal_last_updated" }, { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "nullable": false, "defaultValue": null, "modelName": "objectid", "editable": false } ], "indexes": [ { "name": "r7325_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Pedestrian_Vehicle_Counting_Data", "description": "", "prototype": { "attributes": { "portal_last_updated": null, "organisation": null, "device_id": null, "device_name": null, "device_type": null, "new_": null, "current": null, "left_": null, "left_avg_mins_dwell_time": null, "total": null, "datetime": null, "dayofweek": null, "month": null, "year": null, "datetime_local": null, "dayofweek_local": null, "month_local": null, "year_local": null, "latitude": null, "longitude": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "useStandardizedQueries": true, "standardMaxRecordCount": 16000, "tileMaxRecordCount": 4000, "maxRecordCountFactor": 1, "supportedQueryFormats": "JSON, geoJSON, PBF", "enableZDefaults": true, "maxRecordCount": 1000, "allowGeometryUpdates": true, "capabilities": "Query", "allowUpdateWithoutMValues": true, "zDefault": 0, "serviceItemId": "bc752c043e5d4b6597b02518d1ace62d", "hasMetadata": true, "viewSourceHasAttachments": false, "isView": true, "syncEnabled": false, "sourceSchemaChangesAllowed": true, "isUpdatableView": true, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "supportsApplyEditsWithGlobalIds": false, "supportsAppend": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection", "supportsQuantizationEditMode": true, "supportsAttachmentsByUploadId": true, "supportsAsyncDelete": true, "supportsFieldDescriptionProperty": true, "supportsExceedsLimitStatistics": true, "sqlParserVersion": "PG_10.8.1" }