{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 47, "name": "Automated Safety Cameras (ASC)", "type": "Table", "description": "The Automated Safety Cameras (ASC) is a division of the District Department of Transportation (DDOT) that uses photo enforcement cameras as a traffic calming measure to enforce traffic laws, and to reduce violations on DC\u2019s streets and most intersections. ATE is currently enforcing Posted Speed Limit (Speed), Stop Sign (Failure to come to a complete STOP), Red-Light (Running Red-Light), Bus Lane, Bus Zone, School Bus Stop-Arm, and Truck Restriction routes.This version of ASC data includes devices with no coordinates and because of that, the data is in table format. Data can be mapped using Lat/Lon or X/Y MD State Plane (Meters) but there will be records with null coordinate values.", "copyrightText": "District Department of Transportation", "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, "supportsDurableUrlForSyncModelNone": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "ENFORCEMENT_SPACE_CODE", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "ENFORCEMENT_SPACE_CODE", "type": "esriFieldTypeString", "alias": "Enforcement Space Code", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ENFORCEMENT_SPACE_CODE" }, { "name": "LOCATION_DESCRIPTION", "type": "esriFieldTypeString", "alias": "Location Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION_DESCRIPTION" }, { "name": "SITE_CODE", "type": "esriFieldTypeInteger", "alias": "Site Code", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SITE_CODE" }, { "name": "ACTIVE_STATUS", "type": "esriFieldTypeString", "alias": "Active Status", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ACTIVE_STATUS" }, { "name": "CAMERA_STATUS", "type": "esriFieldTypeString", "alias": "Camera Status", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CAMERA_STATUS" }, { "name": "START_DATE", "type": "esriFieldTypeDate", "alias": "Start Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "START_DATE" }, { "name": "END_DATE", "type": "esriFieldTypeDate", "alias": "End Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "END_DATE" }, { "name": "DEVICE_MOBILITY", "type": "esriFieldTypeString", "alias": "Device Mobility", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DEVICE_MOBILITY" }, { "name": "ENFORCEMENT_TYPE", "type": "esriFieldTypeString", "alias": "Enforcement Type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ENFORCEMENT_TYPE" }, { "name": "SPEED_LIMIT", "type": "esriFieldTypeDouble", "alias": "Speed Limit", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SPEED_LIMIT" }, { "name": "CAMERA_LATITUDE", "type": "esriFieldTypeDouble", "alias": "Camera Latitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CAMERA_LATITUDE" }, { "name": "CAMERA_LONGITUDE", "type": "esriFieldTypeDouble", "alias": "Camera Longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CAMERA_LONGITUDE" }, { "name": "CAMERA_EASTING", "type": "esriFieldTypeDouble", "alias": "Camera Easting", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CAMERA_EASTING" }, { "name": "CAMERA_NORTHING", "type": "esriFieldTypeDouble", "alias": "Camera Northing", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CAMERA_NORTHING" }, { "name": "WARD", "type": "esriFieldTypeString", "alias": "Ward", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WARD" }, { "name": "ANC", "type": "esriFieldTypeString", "alias": "Advisory Neighborhood Commission", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ANC" }, { "name": "SMD", "type": "esriFieldTypeString", "alias": "Single Member District", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SMD" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" } ], "indexes": [ { "name": "R54028_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "UUID_54028", "isAscending": true, "isUnique": true, "description": "", "fields": "GLOBALID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Automated Safety Cameras (ASC)", "description": "", "prototype": { "attributes": { "SMD": null, "ENFORCEMENT_SPACE_CODE": null, "LOCATION_DESCRIPTION": null, "SITE_CODE": null, "ACTIVE_STATUS": null, "CAMERA_STATUS": null, "START_DATE": null, "END_DATE": null, "DEVICE_MOBILITY": null, "ENFORCEMENT_TYPE": null, "SPEED_LIMIT": null, "CAMERA_LATITUDE": null, "CAMERA_LONGITUDE": null, "CAMERA_EASTING": null, "CAMERA_NORTHING": null, "WARD": null, "ANC": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }