Name: AEM_driverEvents_10min_quarterMile

Display Field: global_crash_uuid

Type: Table

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: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• global_crash_uuid (type: esriFieldTypeString, alias: global_crash_uuid, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• local_crash_id (type: esriFieldTypeInteger, alias: local_crash_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• private_property_flag (type: esriFieldTypeString, alias: private_property_flag, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• off_road_flag (type: esriFieldTypeString, alias: off_road_flag, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• secondary_crash_flag (type: esriFieldTypeString, alias: secondary_crash_flag, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• city (type: esriFieldTypeString, alias: city, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• county (type: esriFieldTypeString, alias: county, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• crashLatitude (type: esriFieldTypeDouble, alias: crashLatitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• crashLongitude (type: esriFieldTypeDouble, alias: crashLongitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• urban_rural (type: esriFieldTypeString, alias: urban_rural, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• injury_severity_kabco (type: esriFieldTypeString, alias: injury_severity_kabco, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• injury_flag (type: esriFieldTypeString, alias: injury_flag, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• alcohol_involved (type: esriFieldTypeString, alias: alcohol_involved, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• drugs_involved (type: esriFieldTypeString, alias: drugs_involved, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• roadway_clearance_time (type: esriFieldTypeInteger, alias: roadway_clearance_time, SQL Type: sqlTypeOther, nullable: true, editable: true)
• incident_clearance_time (type: esriFieldTypeInteger, alias: incident_clearance_time, SQL Type: sqlTypeOther, nullable: true, editable: true)
• t1_incident_reportedDate (type: esriFieldTypeString, alias: t1_incident_reportedDate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• t5_roadway_clearedDate (type: esriFieldTypeString, alias: t5_roadway_clearedDate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• t6_incident_clearedDate (type: esriFieldTypeString, alias: t6_incident_clearedDate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• incidentDate (type: esriFieldTypeDate, alias: incidentDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• incidentTime (type: esriFieldTypeString, alias: incidentTime, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HourUpper (type: esriFieldTypeString, alias: HourUpper, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HourLower (type: esriFieldTypeString, alias: HourLower, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• capturedTimestamp (type: esriFieldTypeDouble, alias: capturedTimestamp, SQL Type: sqlTypeOther, nullable: true, editable: true)
• capturedTimestampTz (type: esriFieldTypeInteger, alias: capturedTimestampTz, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dataPointId (type: esriFieldTypeString, alias: dataPointId, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• journeyId (type: esriFieldTypeString, alias: journeyId, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• accelerationType (type: esriFieldTypeString, alias: accelerationType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• journeyEventType (type: esriFieldTypeString, alias: journeyEventType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• seatBeltStatus (type: esriFieldTypeString, alias: seatBeltStatus, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• seatIdentifier (type: esriFieldTypeString, alias: seatIdentifier, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• speedThresholdChangeType (type: esriFieldTypeString, alias: speedThresholdChangeType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• eventType (type: esriFieldTypeString, alias: eventType, SQL Type: sqlTypeOther, length: 8000, 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)
• heading (type: esriFieldTypeInteger, alias: heading, SQL Type: sqlTypeOther, nullable: true, editable: true)
• speed (type: esriFieldTypeDouble, alias: speed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ignitionState (type: esriFieldTypeString, alias: ignitionState, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• capturedTimestampUTC (type: esriFieldTypeString, alias: capturedTimestampUTC, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• timezoneHr (type: esriFieldTypeInteger, alias: timezoneHr, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Localtimestamp (type: esriFieldTypeString, alias: Localtimestamp, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LocalDate (type: esriFieldTypeDate, alias: LocalDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• distance_ft (type: esriFieldTypeDouble, alias: distance_ft, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TimeLabel (type: esriFieldTypeString, alias: TimeLabel, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: AEM_driverEvents_10min_quarterMile
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/9/2022 3:04:27 AM

Schema Last Edit Date: 11/9/2022 3:04:27 AM

Data Last Edit Date: 11/9/2022 3:04:27 AM

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