ArcGIS REST Services Directory
Home
>
services
>
MSP_MHSO_Crash_Workzone (FeatureServer)
>
All Layers and Tables
|
API Reference
JSON
All Layers and Tables (MSP_MHSO_Crash_Workzone)
Layers:
Layer:
MSP_MHSO_Report
(0)
Name:
MSP_MHSO_Report
Display Field:
Reference_Roadname
Type:
Feature Layer
Geometry Type:
esriGeometryPoint
Is View:
true
Is Updatable View:
true
Source Schema Changes Allowed:
true
Description:
Copyright Text:
Min. Scale:
0
Max. Scale:
0
Default Visibility:
true
Max Record Count:
2000
Supported query Formats:
JSON, geoJSON, PBF
Use Standardized Queries:
True
Extent:
XMin: -79.9961
YMin: 37.0000000000001
XMax: -74.9999999999999
YMax: 39.992755
Spatial Reference: 4326 (4326)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[73,150,83,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ:
false
HasM:
false
Has Attachments:
false
Has Geometry Properties:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Object ID Field:
OBJECTID
Unique ID Field:
Name : OBJECTID
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
OBJECTID
(type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
Reportnumber
(type: esriFieldTypeString, alias: Reportnumber, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
AgencyCode
(type: esriFieldTypeString, alias: AgencyCode, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
CountyOfCrash
(type: esriFieldTypeString, alias: CountyOfCrash, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Reporttype
(type: esriFieldTypeString, alias: Reporttype, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
UseData
(type: esriFieldTypeString, alias: UseData, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Crashdate
(type: esriFieldTypeDateOnly, alias: Crashdate, SQL Type: sqlTypeOther, nullable: true, editable: true)
CrashPoint
(type: esriFieldTypeString, alias: CrashPoint, 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)
Collisiontype
(type: esriFieldTypeString, alias: Collisiontype, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Doctype
(type: esriFieldTypeString, alias: Doctype, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Fixedobjectstruck
(type: esriFieldTypeString, alias: Fixedobjectstruck, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Harmfuleventone
(type: esriFieldTypeString, alias: Harmfuleventone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Harmfuleventtwo
(type: esriFieldTypeString, alias: Harmfuleventtwo, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Interchangearea
(type: esriFieldTypeString, alias: Interchangearea, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Intersectiontype
(type: esriFieldTypeString, alias: Intersectiontype, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Junction
(type: esriFieldTypeString, alias: Junction, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Lanedirection
(type: esriFieldTypeString, alias: Lanedirection, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Lanenumber
(type: esriFieldTypeDouble, alias: Lanenumber, SQL Type: sqlTypeOther, nullable: true, editable: true)
Lanetype
(type: esriFieldTypeString, alias: Lanetype, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Lighting
(type: esriFieldTypeString, alias: Lighting, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Logmile_Dir
(type: esriFieldTypeString, alias: Logmile Dir, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
MaintenanceClosure
(type: esriFieldTypeString, alias: MaintenanceClosure, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
MaintenanceLocation
(type: esriFieldTypeString, alias: MaintenanceLocation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
MaintenanceWorkersPresent
(type: esriFieldTypeString, alias: MaintenanceWorkersPresent, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
MaintenanceZone
(type: esriFieldTypeString, alias: MaintenanceZone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Milepoint
(type: esriFieldTypeDouble, alias: Milepoint, SQL Type: sqlTypeOther, nullable: true, editable: true)
Milepointdirection
(type: esriFieldTypeString, alias: Milepointdirection, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Milepointdistance
(type: esriFieldTypeDouble, alias: Milepointdistance, SQL Type: sqlTypeOther, nullable: true, editable: true)
Milepointdistanceunits
(type: esriFieldTypeString, alias: Milepointdistanceunits, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Nontraffic
(type: esriFieldTypeString, alias: Nontraffic, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Numberoflanes
(type: esriFieldTypeDouble, alias: Numberoflanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
Offroaddescription
(type: esriFieldTypeString, alias: Offroaddescription, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Reference_Roadname
(type: esriFieldTypeString, alias: Reference Roadname, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Reference_Route_Number
(type: esriFieldTypeDouble, alias: Reference Route Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
Reference_Route_Type
(type: esriFieldTypeString, alias: Reference Route Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Road_Name
(type: esriFieldTypeString, alias: Road Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Roadalignment
(type: esriFieldTypeString, alias: Roadalignment, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Roadcondition
(type: esriFieldTypeString, alias: Roadcondition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Roaddivision
(type: esriFieldTypeString, alias: Roaddivision, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Roadgrade
(type: esriFieldTypeString, alias: Roadgrade, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Route_Number
(type: esriFieldTypeDouble, alias: Route Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
Route_Type
(type: esriFieldTypeString, alias: Route Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Schoolbusinvolvement
(type: esriFieldTypeInteger, alias: Schoolbusinvolvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
Status_Id
(type: esriFieldTypeString, alias: Status Id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Surfacecondition
(type: esriFieldTypeString, alias: Surfacecondition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Timeofcrash
(type: esriFieldTypeTimeOnly, alias: Timeofcrash, SQL Type: sqlTypeOther, nullable: true, editable: true)
Trafficcontrol
(type: esriFieldTypeInteger, alias: Trafficcontrol, SQL Type: sqlTypeOther, nullable: true, editable: true)
Trafficcontrolfunctioning
(type: esriFieldTypeString, alias: Trafficcontrolfunctioning, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Weather
(type: esriFieldTypeString, alias: Weather, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
CrashYear
(type: esriFieldTypeInteger, alias: CrashYear, SQL Type: sqlTypeOther, nullable: true, editable: true)
CrashMonth
(type: esriFieldTypeInteger, alias: CrashMonth, SQL Type: sqlTypeOther, nullable: true, editable: true)
CrashWeekday
(type: esriFieldTypeInteger, alias: CrashWeekday, SQL Type: sqlTypeOther, nullable: true, editable: true)
CrashHour
(type: esriFieldTypeInteger, alias: CrashHour, SQL Type: sqlTypeOther, nullable: true, editable: true)
VehicleCount
(type: esriFieldTypeInteger, alias: VehicleCount, SQL Type: sqlTypeOther, nullable: true, editable: true)
DriverCount
(type: esriFieldTypeInteger, alias: DriverCount, SQL Type: sqlTypeOther, nullable: true, editable: true)
PassengerCount
(type: esriFieldTypeInteger, alias: PassengerCount, SQL Type: sqlTypeOther, nullable: true, editable: true)
NonMotoristCount
(type: esriFieldTypeInteger, alias: NonMotoristCount, SQL Type: sqlTypeOther, nullable: true, editable: true)
TotalPersons
(type: esriFieldTypeInteger, alias: TotalPersons, SQL Type: sqlTypeOther, nullable: true, editable: true)
DriverFatals
(type: esriFieldTypeInteger, alias: DriverFatals, SQL Type: sqlTypeOther, nullable: true, editable: true)
PassengerFatals
(type: esriFieldTypeInteger, alias: PassengerFatals, SQL Type: sqlTypeOther, nullable: true, editable: true)
NonMotoristFatals
(type: esriFieldTypeInteger, alias: NonMotoristFatals, SQL Type: sqlTypeOther, nullable: true, editable: true)
TotalFatals
(type: esriFieldTypeInteger, alias: TotalFatals, SQL Type: sqlTypeOther, nullable: true, editable: true)
DriverInjs
(type: esriFieldTypeInteger, alias: DriverInjs, SQL Type: sqlTypeOther, nullable: true, editable: true)
PassengerInjs
(type: esriFieldTypeInteger, alias: PassengerInjs, SQL Type: sqlTypeOther, nullable: true, editable: true)
NonMotoristInjs
(type: esriFieldTypeInteger, alias: NonMotoristInjs, SQL Type: sqlTypeOther, nullable: true, editable: true)
TotalInjs
(type: esriFieldTypeInteger, alias: TotalInjs, SQL Type: sqlTypeOther, nullable: true, editable: true)
FlagMotorc
(type: esriFieldTypeInteger, alias: FlagMotorc, SQL Type: sqlTypeOther, nullable: true, editable: true)
FlagBike
(type: esriFieldTypeInteger, alias: FlagBike, SQL Type: sqlTypeOther, nullable: true, editable: true)
FlagPedes
(type: esriFieldTypeInteger, alias: FlagPedes, SQL Type: sqlTypeOther, nullable: true, editable: true)
FlagSpeed
(type: esriFieldTypeInteger, alias: FlagSpeed, SQL Type: sqlTypeOther, nullable: true, editable: true)
FlagAgg
(type: esriFieldTypeInteger, alias: FlagAgg, SQL Type: sqlTypeOther, nullable: true, editable: true)
FlagImp
(type: esriFieldTypeInteger, alias: FlagImp, SQL Type: sqlTypeOther, nullable: true, editable: true)
FlagDist
(type: esriFieldTypeInteger, alias: FlagDist, SQL Type: sqlTypeOther, nullable: true, editable: true)
FlagMature
(type: esriFieldTypeInteger, alias: FlagMature, SQL Type: sqlTypeOther, nullable: true, editable: true)
FlagYoung
(type: esriFieldTypeInteger, alias: FlagYoung, SQL Type: sqlTypeOther, nullable: true, editable: true)
FlagUnbelt
(type: esriFieldTypeInteger, alias: FlagUnbelt, SQL Type: sqlTypeOther, nullable: true, editable: true)
DriverMotorcycleFatals
(type: esriFieldTypeInteger, alias: DriverMotorcycleFatals, SQL Type: sqlTypeOther, nullable: true, editable: true)
PassengerMotorcycleFatals
(type: esriFieldTypeInteger, alias: PassengerMotorcycleFatals, SQL Type: sqlTypeOther, nullable: true, editable: true)
TotalMotorcycleFatals
(type: esriFieldTypeInteger, alias: TotalMotorcycleFatals, SQL Type: sqlTypeOther, nullable: true, editable: true)
DriverUnbeltedFatals
(type: esriFieldTypeInteger, alias: DriverUnbeltedFatals, SQL Type: sqlTypeOther, nullable: true, editable: true)
PassengerUnbeltedFatals
(type: esriFieldTypeInteger, alias: PassengerUnbeltedFatals, SQL Type: sqlTypeOther, nullable: true, editable: true)
TotalUnbeltedFatals
(type: esriFieldTypeInteger, alias: TotalUnbeltedFatals, SQL Type: sqlTypeOther, nullable: true, editable: true)
MatureDriverFatals
(type: esriFieldTypeInteger, alias: MatureDriverFatals, SQL Type: sqlTypeOther, nullable: true, editable: true)
YoungDriverFatals
(type: esriFieldTypeInteger, alias: YoungDriverFatals, SQL Type: sqlTypeOther, nullable: true, editable: true)
PedestrianFatals
(type: esriFieldTypeInteger, alias: PedestrianFatals, SQL Type: sqlTypeOther, nullable: true, editable: true)
BicyclistFatals
(type: esriFieldTypeInteger, alias: BicyclistFatals, SQL Type: sqlTypeOther, nullable: true, editable: true)
CrashDateQuery
(type: esriFieldTypeDate, alias: CrashDateQuery, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Templates:
Name: MSP_MHSO_Report
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
Relationships:
MSP_Nonmotorist_Table (0) --
Related To
:
MSP_Nonmotorist_Table
(3)
MSP_Vehicle_Table (1) --
Related To
:
MSP_Vehicle_Table
(1)
MSP_Circumstances_Tables (2) --
Related To
:
MSP_Circumstances_Tables
(5)
MSP_Driver_Table (3) --
Related To
:
MSP_Driver_Table
(4)
MSP_Passenger_Table (4) --
Related To
:
MSP_Passenger_Table
(2)
Is Data Versioned:
false
Has Contingent Values:
false
Supports Rollback On Failure Parameter:
true
Last Edit Date:
4/30/2024 7:33:20 PM
Schema Last Edit Date:
4/30/2024 7:33:20 PM
Data Last Edit Date:
4/30/2024 7:32:39 PM
Tables:
MSP_Vehicle_Table
(1)
Name:
MSP_Vehicle_Table
Display Field:
Reportnumber
Type:
Table
Is View:
true
Is Updatable View:
true
Source Schema Changes Allowed:
true
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:
Type ID Field:
Fields:
OBJECTID
(type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
Reportnumber
(type: esriFieldTypeString, alias: Reportnumber, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Vehicleid
(type: esriFieldTypeString, alias: Vehicleid, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
CommercialBodyType
(type: esriFieldTypeString, alias: CommercialBodyType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
CommercialCarrierClassification
(type: esriFieldTypeString, alias: CommercialCarrierClassification, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
CommercialConfiguration
(type: esriFieldTypeString, alias: CommercialConfiguration, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
CommercialGVW
(type: esriFieldTypeString, alias: CommercialGVW, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
CommercialHazmatClass
(type: esriFieldTypeString, alias: CommercialHazmatClass, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
CommercialHazmatNumber
(type: esriFieldTypeString, alias: CommercialHazmatNumber, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
CommercialHazmatPlacardVisible
(type: esriFieldTypeString, alias: CommercialHazmatPlacardVisible, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
CommercialHazmatSpill
(type: esriFieldTypeString, alias: CommercialHazmatSpill, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
CommercialNumberofaxles
(type: esriFieldTypeString, alias: CommercialNumberofaxles, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Continuedirection
(type: esriFieldTypeString, alias: Continuedirection, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Damageextent
(type: esriFieldTypeString, alias: Damageextent, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Driverlessvehicle
(type: esriFieldTypeString, alias: Driverlessvehicle, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Emergencymotorvehicleuse
(type: esriFieldTypeString, alias: Emergencymotorvehicleuse, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Fire
(type: esriFieldTypeString, alias: Fire, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Firstimpact
(type: esriFieldTypeString, alias: Firstimpact, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Goingdirection
(type: esriFieldTypeString, alias: Goingdirection, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Mainimpact
(type: esriFieldTypeString, alias: Mainimpact, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Mostharmfulevent
(type: esriFieldTypeString, alias: Mostharmfulevent, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Parkedvehicle
(type: esriFieldTypeString, alias: Parkedvehicle, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Speedlimit
(type: esriFieldTypeDouble, alias: Speedlimit, SQL Type: sqlTypeOther, nullable: true, editable: true)
Towedunittype
(type: esriFieldTypeString, alias: Towedunittype, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Unitnumber
(type: esriFieldTypeDouble, alias: Unitnumber, SQL Type: sqlTypeOther, nullable: true, editable: true)
Vehiclebodytype
(type: esriFieldTypeString, alias: Vehiclebodytype, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
VehicleBusUse
(type: esriFieldTypeString, alias: VehicleBusUse, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
VehicleLeftScene
(type: esriFieldTypeString, alias: VehicleLeftScene, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Vehiclemake
(type: esriFieldTypeString, alias: Vehiclemake, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Vehiclemodel
(type: esriFieldTypeString, alias: Vehiclemodel, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Vehiclemovement
(type: esriFieldTypeDouble, alias: Vehiclemovement, SQL Type: sqlTypeOther, nullable: true, editable: true)
VehicleSpecialFunction
(type: esriFieldTypeString, alias: VehicleSpecialFunction, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Vehicleyear
(type: esriFieldTypeDouble, alias: Vehicleyear, SQL Type: sqlTypeOther, nullable: true, editable: true)
VIN
(type: esriFieldTypeString, alias: VIN, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Templates:
Name: MSP_Vehicle_Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
Relationships:
MSP_MHSO_Report (1) --
Related To
:
MSP_MHSO_Report
(0)
Is Data Versioned:
false
Has Contingent Values:
false
Supports Rollback On Failure Parameter:
true
Last Edit Date:
4/30/2024 7:33:20 PM
Schema Last Edit Date:
4/30/2024 7:33:20 PM
Data Last Edit Date:
4/30/2024 7:32:39 PM
MSP_Passenger_Table
(2)
Name:
MSP_Passenger_Table
Display Field:
Reportnumber
Type:
Table
Is View:
true
Is Updatable View:
true
Source Schema Changes Allowed:
true
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:
Type ID Field:
Fields:
OBJECTID
(type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
Reportnumber
(type: esriFieldTypeString, alias: Reportnumber, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PassengerID
(type: esriFieldTypeString, alias: PassengerID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PassengerAirbagDeployed
(type: esriFieldTypeString, alias: PassengerAirbagDeployed, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PassengerDOB
(type: esriFieldTypeDateOnly, alias: PassengerDOB, SQL Type: sqlTypeOther, nullable: true, editable: true)
PassengerEjection
(type: esriFieldTypeString, alias: PassengerEjection, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PassengerEquipmentProblem
(type: esriFieldTypeString, alias: PassengerEquipmentProblem, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PassengerInjurySeverity
(type: esriFieldTypeString, alias: PassengerInjurySeverity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PassengerSafetyEquipment
(type: esriFieldTypeString, alias: PassengerSafetyEquipment, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PassengerSeat
(type: esriFieldTypeString, alias: PassengerSeat, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PassengerSeatingLocation
(type: esriFieldTypeString, alias: PassengerSeatingLocation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PassengerSeatingRow
(type: esriFieldTypeDouble, alias: PassengerSeatingRow, SQL Type: sqlTypeOther, nullable: true, editable: true)
PassengerSex
(type: esriFieldTypeString, alias: PassengerSex, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PassengerVehicleID
(type: esriFieldTypeString, alias: PassengerVehicleID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PassengerAge
(type: esriFieldTypeDouble, alias: PassengerAge, SQL Type: sqlTypeOther, nullable: true, editable: true)
OnMotorcycle
(type: esriFieldTypeInteger, alias: OnMotorcycle, SQL Type: sqlTypeOther, nullable: true, editable: true)
Unbelted
(type: esriFieldTypeInteger, alias: Unbelted, SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: MSP_Passenger_Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
Relationships:
MSP_MHSO_Report (4) --
Related To
:
MSP_MHSO_Report
(0)
Is Data Versioned:
false
Has Contingent Values:
false
Supports Rollback On Failure Parameter:
true
Last Edit Date:
4/30/2024 7:33:20 PM
Schema Last Edit Date:
4/30/2024 7:33:20 PM
Data Last Edit Date:
4/30/2024 7:32:39 PM
MSP_Nonmotorist_Table
(3)
Name:
MSP_Nonmotorist_Table
Display Field:
Reportnumber
Type:
Table
Is View:
true
Is Updatable View:
true
Source Schema Changes Allowed:
true
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:
Type ID Field:
Fields:
OBJECTID
(type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
Reportnumber
(type: esriFieldTypeString, alias: Reportnumber, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NonMotoristID
(type: esriFieldTypeString, alias: NonMotoristID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NonMotoristActions
(type: esriFieldTypeString, alias: NonMotoristActions, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NonMotoristAlcoholTestindicator
(type: esriFieldTypeString, alias: NonMotoristAlcoholTestindicator, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NonMotoristAlcoholTestType
(type: esriFieldTypeString, alias: NonMotoristAlcoholTestType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NonMotoristBAC
(type: esriFieldTypeDouble, alias: NonMotoristBAC, SQL Type: sqlTypeOther, nullable: true, editable: true)
NonMotoristCondition
(type: esriFieldTypeString, alias: NonMotoristCondition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NonMotoristDOB
(type: esriFieldTypeDateOnly, alias: NonMotoristDOB, SQL Type: sqlTypeOther, nullable: true, editable: true)
NonMotoristDrugTestIndicator
(type: esriFieldTypeString, alias: NonMotoristDrugTestIndicator, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NonMotoristDrugTestResult
(type: esriFieldTypeString, alias: NonMotoristDrugTestResult, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NonMotoristInjurySeverity
(type: esriFieldTypeString, alias: NonMotoristInjurySeverity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NonMotoristLocation
(type: esriFieldTypeString, alias: NonMotoristLocation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NonMotoristMovement
(type: esriFieldTypeString, alias: NonMotoristMovement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NonMotoristObeyTrafficSignal
(type: esriFieldTypeString, alias: NonMotoristObeyTrafficSignal, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NonMotoristSafetyEquipment
(type: esriFieldTypeString, alias: NonMotoristSafetyEquipment, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NonMotoristSex
(type: esriFieldTypeString, alias: NonMotoristSex, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NonMotoristSubstanceUse
(type: esriFieldTypeString, alias: NonMotoristSubstanceUse, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NonMotoristType
(type: esriFieldTypeString, alias: NonMotoristType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NonMotoristUnitNumberFirstStrik
(type: esriFieldTypeDouble, alias: NonMotoristUnitNumberFirstStrike, SQL Type: sqlTypeOther, nullable: true, editable: true)
NonMotoristVisibility
(type: esriFieldTypeString, alias: NonMotoristVisibility, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NonMotoristAge
(type: esriFieldTypeDouble, alias: NonMotoristAge, SQL Type: sqlTypeOther, nullable: true, editable: true)
NonMotoristImpaired
(type: esriFieldTypeInteger, alias: NonMotoristImpaired, SQL Type: sqlTypeOther, nullable: true, editable: true)
Pedestrian
(type: esriFieldTypeInteger, alias: Pedestrian, SQL Type: sqlTypeOther, nullable: true, editable: true)
Bicyclist
(type: esriFieldTypeInteger, alias: Bicyclist, SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: MSP_Nonmotorist_Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
Relationships:
MSP_MHSO_Report (0) --
Related To
:
MSP_MHSO_Report
(0)
Is Data Versioned:
false
Has Contingent Values:
false
Supports Rollback On Failure Parameter:
true
Last Edit Date:
4/30/2024 7:33:20 PM
Schema Last Edit Date:
4/30/2024 7:33:20 PM
Data Last Edit Date:
4/30/2024 7:32:39 PM
MSP_Driver_Table
(4)
Name:
MSP_Driver_Table
Display Field:
Reportnumber
Type:
Table
Is View:
true
Is Updatable View:
true
Source Schema Changes Allowed:
true
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:
Type ID Field:
Fields:
OBJECTID
(type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
Reportnumber
(type: esriFieldTypeString, alias: Reportnumber, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DriverID
(type: esriFieldTypeString, alias: DriverID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DriverAirbagDeployed
(type: esriFieldTypeString, alias: DriverAirbagDeployed, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DriverAlcoholTestIndicator
(type: esriFieldTypeString, alias: DriverAlcoholTestIndicator, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DriverAlcoholTestType
(type: esriFieldTypeString, alias: DriverAlcoholTestType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DriverBAC
(type: esriFieldTypeString, alias: DriverBAC, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DriverCondition
(type: esriFieldTypeString, alias: DriverCondition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Driverdistractedby
(type: esriFieldTypeString, alias: Driverdistractedby, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DriverDOB
(type: esriFieldTypeString, alias: DriverDOB, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DriverDrugTestIndicator
(type: esriFieldTypeString, alias: DriverDrugTestIndicator, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DriverDrugTestResult
(type: esriFieldTypeString, alias: DriverDrugTestResult, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DriverEjection
(type: esriFieldTypeString, alias: DriverEjection, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DriverEquipmentProblem
(type: esriFieldTypeString, alias: DriverEquipmentProblem, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DriverHasCDL
(type: esriFieldTypeString, alias: DriverHasCDL, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DriverInjurySeverity
(type: esriFieldTypeString, alias: DriverInjurySeverity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DriverSafetyEquipment
(type: esriFieldTypeString, alias: DriverSafetyEquipment, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DriverSex
(type: esriFieldTypeString, alias: DriverSex, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DriverSubstanceUse
(type: esriFieldTypeString, alias: DriverSubstanceUse, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DriverVehicleID
(type: esriFieldTypeString, alias: DriverVehicleID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DriverAge
(type: esriFieldTypeString, alias: DriverAge, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DriverMature
(type: esriFieldTypeInteger, alias: DriverMature, SQL Type: sqlTypeOther, nullable: true, editable: true)
DriverYoung
(type: esriFieldTypeInteger, alias: DriverYoung, SQL Type: sqlTypeOther, nullable: true, editable: true)
DriverDistracted
(type: esriFieldTypeInteger, alias: DriverDistracted, SQL Type: sqlTypeOther, nullable: true, editable: true)
DriverSpeeding
(type: esriFieldTypeInteger, alias: DriverSpeeding, SQL Type: sqlTypeOther, nullable: true, editable: true)
DriverAggressive
(type: esriFieldTypeInteger, alias: DriverAggressive, SQL Type: sqlTypeOther, nullable: true, editable: true)
DriverImpaired
(type: esriFieldTypeInteger, alias: DriverImpaired, SQL Type: sqlTypeOther, nullable: true, editable: true)
OnMotorcycle
(type: esriFieldTypeInteger, alias: OnMotorcycle, SQL Type: sqlTypeOther, nullable: true, editable: true)
Unbelted
(type: esriFieldTypeInteger, alias: Unbelted, SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: MSP_Driver_Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
Relationships:
MSP_MHSO_Report (3) --
Related To
:
MSP_MHSO_Report
(0)
Is Data Versioned:
false
Has Contingent Values:
false
Supports Rollback On Failure Parameter:
true
Last Edit Date:
4/30/2024 7:33:20 PM
Schema Last Edit Date:
4/30/2024 7:33:20 PM
Data Last Edit Date:
4/30/2024 7:32:39 PM
MSP_Circumstances_Tables
(5)
Name:
MSP_Circumstances_Tables
Display Field:
Reportnumber
Type:
Table
Is View:
true
Is Updatable View:
true
Source Schema Changes Allowed:
true
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:
Type ID Field:
Fields:
OBJECTID
(type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
Reportnumber
(type: esriFieldTypeString, alias: Reportnumber, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
CircumstancesCode
(type: esriFieldTypeString, alias: CircumstancesCode, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
CircumstancesPersonID
(type: esriFieldTypeString, alias: CircumstancesPersonID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
CircumstancesType
(type: esriFieldTypeString, alias: CircumstancesType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
CircumstancesVehicleID
(type: esriFieldTypeString, alias: CircumstancesVehicleID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Templates:
Name: MSP_Circumstances_Tables
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
Relationships:
MSP_MHSO_Report (2) --
Related To
:
MSP_MHSO_Report
(0)
Is Data Versioned:
false
Has Contingent Values:
false
Supports Rollback On Failure Parameter:
true
Last Edit Date:
4/30/2024 7:33:20 PM
Schema Last Edit Date:
4/30/2024 7:33:20 PM
Data Last Edit Date:
4/30/2024 7:32:39 PM