Name: CrashLayer2023TestRelatedTableREPORT_ExportFeatures

Display Field: Reference_Roadname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

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.794
YMin: 37.0049866620001
XMax: -74.9999999999999
YMax: 39.9923575
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[103,158,52,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: esriFieldTypeInteger, 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: esriFieldTypeInteger, 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: esriFieldTypeInteger, 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: esriFieldTypeInteger, 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)

Templates:

Name: CrashLayer2023TestRelatedTableREPORT_ExportFeatures
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Relationships:

• CrashMap_DRIVER_data (0) -- Related To: CrashMap_DRIVER_data (5)
• CrashMap_NONMOTORIST_data (1) -- Related To: CrashMap_NONMOTORIST_data (4)
• CrashMap_VEHICLE_data (2) -- Related To: CrashMap_VEHICLE_data (3)
• CrashMap_CIRCUMSTANCES_data (3) -- Related To: CrashMap_CIRCUMSTANCES_data (6)
• CrashMap_PASSENGER_data (4) -- Related To: CrashMap_PASSENGER_data (2)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/27/2024 7:10:41 PM

Schema Last Edit Date: 3/27/2024 7:10:41 PM

Data Last Edit Date: 3/27/2024 7:10:35 PM

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