Name: TPD_OPEN_DATA_CollisionsPublicDash

Display Field: AccidentID

Type: Table

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ESRI_OID

Unique ID Field:

Name : ESRI_OID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• DW_Id (type: esriFieldTypeDouble, alias: DW_Id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AccidentID (type: esriFieldTypeString, alias: AccidentID, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• Dupe (type: esriFieldTypeDouble, alias: Dupe, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Agency (type: esriFieldTypeString, alias: Agency, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• CollisionDate (type: esriFieldTypeDate, alias: CollisionDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• YearOccu (type: esriFieldTypeInteger, alias: YearOccu, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Month (type: esriFieldTypeString, alias: Month, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• MonthOccu (type: esriFieldTypeInteger, alias: MonthOccu, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MonthAbbr (type: esriFieldTypeString, alias: MonthAbbr, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• TimeOccu (type: esriFieldTypeString, alias: TimeOccu, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Day (type: esriFieldTypeString, alias: Day, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• YeartoDate (type: esriFieldTypeString, alias: YeartoDate, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• YtdDupl (type: esriFieldTypeInteger, alias: YtdDupl, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TrafficOffense (type: esriFieldTypeString, alias: TrafficOffense, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• OffenseDesc (type: esriFieldTypeString, alias: OffenseDesc, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• InjurySeverity (type: esriFieldTypeString, alias: InjurySeverity, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• CollisionType (type: esriFieldTypeString, alias: CollisionType, SQL Type: sqlTypeOther, length: 43, nullable: true, editable: true)
• CollisionManner (type: esriFieldTypeString, alias: CollisionManner, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Division (type: esriFieldTypeString, alias: Division, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Squad (type: esriFieldTypeString, alias: Squad, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• Ward (type: esriFieldTypeString, alias: Ward, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• CollisionNeighborhd (type: esriFieldTypeString, alias: CollisionNeighborhd, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• AccidentLocation (type: esriFieldTypeString, alias: AccidentLocation, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• CollisionDirection (type: esriFieldTypeString, alias: CollisionDirection, SQL Type: sqlTypeOther, length: 43, nullable: true, editable: true)
• Distance (type: esriFieldTypeString, alias: Distance, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• HitandRun (type: esriFieldTypeString, alias: HitandRun, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Pedestrian (type: esriFieldTypeString, alias: Pedestrian, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• FatalCollision (type: esriFieldTypeString, alias: FatalCollision, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• IntersectionRelated (type: esriFieldTypeString, alias: IntersectionRelated, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• TrafficControlDevice (type: esriFieldTypeInteger, alias: TrafficControlDevice, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WorkZone (type: esriFieldTypeInteger, alias: WorkZone, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ViolationSpeed (type: esriFieldTypeString, alias: ViolationSpeed, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• ViolationTooClose (type: esriFieldTypeInteger, alias: ViolationTooClose, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ViolationTrafficControlDevice (type: esriFieldTypeInteger, alias: ViolationTrafficControlDevice, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ViolationTurning (type: esriFieldTypeInteger, alias: ViolationTurning, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ViolationWrongWay (type: esriFieldTypeInteger, alias: ViolationWrongWay, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ViolationLane (type: esriFieldTypeInteger, alias: ViolationLane, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ViolationCrosswalk (type: esriFieldTypeInteger, alias: ViolationCrosswalk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ViolationFailureToYield (type: esriFieldTypeInteger, alias: ViolationFailureToYield, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ViolationAggressiveDriving (type: esriFieldTypeInteger, alias: ViolationAggressiveDriving, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OperatorImpaired (type: esriFieldTypeString, alias: OperatorImpaired, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• OperatorDistracted (type: esriFieldTypeString, alias: OperatorDistracted, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• XCoordinate (type: esriFieldTypeDouble, alias: XCoordinate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YCoordinate (type: esriFieldTypeDouble, alias: YCoordinate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalFatalities (type: esriFieldTypeInteger, alias: TotalFatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalInjuries (type: esriFieldTypeInteger, alias: TotalInjuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalUnits (type: esriFieldTypeInteger, alias: TotalUnits, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LatitudePublic (type: esriFieldTypeDouble, alias: LatitudePublic, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LongitudePublic (type: esriFieldTypeDouble, alias: LongitudePublic, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DW_Batch (type: esriFieldTypeDouble, alias: DW_Batch, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DW_SourceCode (type: esriFieldTypeString, alias: DW_SourceCode, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• DW_TimeStamp (type: esriFieldTypeDate, alias: DW_TimeStamp, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ESRI_OID (type: esriFieldTypeOID, alias: ESRI_OID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)

Templates:

Name: TPD_OPEN_DATA_CollisionsPublicDash
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/29/2025 10:07:41 PM

Schema Last Edit Date: 7/29/2025 10:07:41 PM

Data Last Edit Date: 7/23/2025 1:11:27 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat