Name: Automated Safety Cameras (ASC)

Display Field: ENFORCEMENT_SPACE_CODE

Type: Table

Geometry Type: N/A

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’s 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.

Copyright Text: District Department of Transportation

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• ENFORCEMENT_SPACE_CODE ( type: esriFieldTypeString, alias: Enforcement Space Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ENFORCEMENT_SPACE_CODE )
• LOCATION_DESCRIPTION ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATION_DESCRIPTION )
• SITE_CODE ( type: esriFieldTypeInteger, alias: Site Code, editable: true, nullable: true, defaultValue: null, modelName: SITE_CODE )
• ACTIVE_STATUS ( type: esriFieldTypeString, alias: Active Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ACTIVE_STATUS )
• CAMERA_STATUS ( type: esriFieldTypeString, alias: Camera Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CAMERA_STATUS )
• START_DATE ( type: esriFieldTypeDate, alias: Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: START_DATE )
• END_DATE ( type: esriFieldTypeDate, alias: End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: END_DATE )
• DEVICE_MOBILITY ( type: esriFieldTypeString, alias: Device Mobility, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEVICE_MOBILITY )
• ENFORCEMENT_TYPE ( type: esriFieldTypeString, alias: Enforcement Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ENFORCEMENT_TYPE )
• SPEED_LIMIT ( type: esriFieldTypeDouble, alias: Speed Limit, editable: true, nullable: true, defaultValue: null, modelName: SPEED_LIMIT )
• CAMERA_LATITUDE ( type: esriFieldTypeDouble, alias: Camera Latitude, editable: true, nullable: true, defaultValue: null, modelName: CAMERA_LATITUDE )
• CAMERA_LONGITUDE ( type: esriFieldTypeDouble, alias: Camera Longitude, editable: true, nullable: true, defaultValue: null, modelName: CAMERA_LONGITUDE )
• CAMERA_EASTING ( type: esriFieldTypeDouble, alias: Camera Easting, editable: true, nullable: true, defaultValue: null, modelName: CAMERA_EASTING )
• CAMERA_NORTHING ( type: esriFieldTypeDouble, alias: Camera Northing, editable: true, nullable: true, defaultValue: null, modelName: CAMERA_NORTHING )
• WARD ( type: esriFieldTypeString, alias: Ward, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WARD )
• ANC ( type: esriFieldTypeString, alias: Advisory Neighborhood Commission, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ANC )
• SMD ( type: esriFieldTypeString, alias: Single Member District, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SMD )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Templates:

• Name: Automated Safety Cameras (ASC)
  Description:
  Prototype:
  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
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata