View In:   ArcGIS Online map viewer

Name: TCRPC_crashes_2017_2022

Display Field: CityName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -89.99999999999994
YMin: 5.6843418860808015E-14
XMax: 5.6843418860808015E-14
YMax: 40.97380011100006
Spatial Reference: 4326  (4326)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [128, 51, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label:
Description:
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CrashID ( type: esriFieldTypeInteger, alias: CrashID, editable: true, nullable: true, defaultValue: null, modelName: CrashID )
• CountyCode ( type: esriFieldTypeInteger, alias: CountyCode, editable: true, nullable: true, defaultValue: null, modelName: CountyCode )
• CrashYr ( type: esriFieldTypeInteger, alias: CrashYr, editable: true, nullable: true, defaultValue: null, modelName: CrashYr )
• CrashMonth ( type: esriFieldTypeInteger, alias: CrashMonth, editable: true, nullable: true, defaultValue: null, modelName: CrashMonth )
• CrashDay ( type: esriFieldTypeInteger, alias: CrashDay, editable: true, nullable: true, defaultValue: null, modelName: CrashDay )
• NumberOfVehicles ( type: esriFieldTypeInteger, alias: NumberOfVehicles, editable: true, nullable: true, defaultValue: null, modelName: NumberOfVehicles )
• DayOfWeekCode ( type: esriFieldTypeInteger, alias: DayOfWeekCode, editable: true, nullable: true, defaultValue: null, modelName: DayOfWeekCode )
• CrashHour ( type: esriFieldTypeInteger, alias: CrashHour, editable: true, nullable: true, defaultValue: null, modelName: CrashHour )
• CityCode ( type: esriFieldTypeInteger, alias: CityCode, editable: true, nullable: true, defaultValue: null, modelName: CityCode )
• CityClassCode ( type: esriFieldTypeInteger, alias: CityClassCode, editable: true, nullable: true, defaultValue: null, modelName: CityClassCode )
• Township ( type: esriFieldTypeString, alias: Township, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: Township )
• CollisionTypeCode ( type: esriFieldTypeInteger, alias: CollisionTypeCode, editable: true, nullable: true, defaultValue: null, modelName: CollisionTypeCode )
• TotalFatals ( type: esriFieldTypeInteger, alias: TotalFatals, editable: true, nullable: true, defaultValue: null, modelName: TotalFatals )
• TotalInjured ( type: esriFieldTypeInteger, alias: TotalInjured, editable: true, nullable: true, defaultValue: null, modelName: TotalInjured )
• NoInjuries ( type: esriFieldTypeInteger, alias: NoInjuries, editable: true, nullable: true, defaultValue: null, modelName: NoInjuries )
• AInjuries ( type: esriFieldTypeInteger, alias: AInjuries, editable: true, nullable: true, defaultValue: null, modelName: AInjuries )
• BInjuries ( type: esriFieldTypeInteger, alias: BInjuries, editable: true, nullable: true, defaultValue: null, modelName: BInjuries )
• CInjuries ( type: esriFieldTypeInteger, alias: CInjuries, editable: true, nullable: true, defaultValue: null, modelName: CInjuries )
• CrashSeverity ( type: esriFieldTypeString, alias: CrashSeverity, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: CrashSeverity )
• AgencyCode ( type: esriFieldTypeInteger, alias: AgencyCode, editable: true, nullable: true, defaultValue: null, modelName: AgencyCode )
• RouteNumber ( type: esriFieldTypeInteger, alias: RouteNumber, editable: true, nullable: true, defaultValue: null, modelName: RouteNumber )
• Milestation ( type: esriFieldTypeDouble, alias: Milestation, editable: true, nullable: true, defaultValue: null, modelName: Milestation )
• ClassOfTrafficwayCode ( type: esriFieldTypeInteger, alias: ClassOfTrafficwayCode, editable: true, nullable: true, defaultValue: null, modelName: ClassOfTrafficwayCode )
• NHS ( type: esriFieldTypeString, alias: NHS, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: NHS )
• TrafficControlDeviceCode ( type: esriFieldTypeInteger, alias: TrafficControlDeviceCode, editable: true, nullable: true, defaultValue: null, modelName: TrafficControlDeviceCode )
• RoadSurfaceConditionCode ( type: esriFieldTypeInteger, alias: RoadSurfaceConditionCode, editable: true, nullable: true, defaultValue: null, modelName: RoadSurfaceConditionCode )
• RoadDefectsCode ( type: esriFieldTypeInteger, alias: RoadDefectsCode, editable: true, nullable: true, defaultValue: null, modelName: RoadDefectsCode )
• LightConditionCode ( type: esriFieldTypeInteger, alias: LightConditionCode, editable: true, nullable: true, defaultValue: null, modelName: LightConditionCode )
• WeatherCode ( type: esriFieldTypeInteger, alias: WeatherCode, editable: true, nullable: true, defaultValue: null, modelName: WeatherCode )
• Cause1Code ( type: esriFieldTypeInteger, alias: Cause1Code, editable: true, nullable: true, defaultValue: null, modelName: Cause1Code )
• Cause2Code ( type: esriFieldTypeInteger, alias: Cause2Code, editable: true, nullable: true, defaultValue: null, modelName: Cause2Code )
• RailroadCrossingNumber ( type: esriFieldTypeString, alias: RailroadCrossingNumber, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: RailroadCrossingNumber )
• TimeOfCrash ( type: esriFieldTypeDouble, alias: TimeOfCrash, editable: true, nullable: true, defaultValue: null, modelName: TimeOfCrash )
• TrafficControlDeviceConditionCode ( type: esriFieldTypeInteger, alias: TrafficControlDeviceConditionCode, editable: true, nullable: true, defaultValue: null, modelName: TrafficControlDeviceConditionCode )
• IntersectionRelated ( type: esriFieldTypeString, alias: IntersectionRelated, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: IntersectionRelated )
• HitAndRun ( type: esriFieldTypeString, alias: HitAndRun, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: HitAndRun )
• CrashDate ( type: esriFieldTypeInteger, alias: CrashDate, editable: true, nullable: true, defaultValue: null, modelName: CrashDate )
• NumberOfLanes ( type: esriFieldTypeString, alias: NumberOfLanes, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: NumberOfLanes )
• AlignmentCode ( type: esriFieldTypeInteger, alias: AlignmentCode, editable: true, nullable: true, defaultValue: null, modelName: AlignmentCode )
• TrafficwayDescriptionCode ( type: esriFieldTypeInteger, alias: TrafficwayDescriptionCode, editable: true, nullable: true, defaultValue: null, modelName: TrafficwayDescriptionCode )
• RoadwayFunctionalClassCode ( type: esriFieldTypeInteger, alias: RoadwayFunctionalClassCode, editable: true, nullable: true, defaultValue: null, modelName: RoadwayFunctionalClassCode )
• WorkZoneRelated ( type: esriFieldTypeString, alias: WorkZoneRelated, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: WorkZoneRelated )
• City_Township_Flag ( type: esriFieldTypeString, alias: City_Township_Flag, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: City_Township_Flag )
• TSCrashCoordinateX ( type: esriFieldTypeDouble, alias: TSCrashCoordinateX, editable: true, nullable: true, defaultValue: null, modelName: TSCrashCoordinateX )
• TSCrashCoordinateY ( type: esriFieldTypeDouble, alias: TSCrashCoordinateY, editable: true, nullable: true, defaultValue: null, modelName: TSCrashCoordinateY )
• TSCrashLatitude ( type: esriFieldTypeDouble, alias: TSCrashLatitude, editable: true, nullable: true, defaultValue: null, modelName: TSCrashLatitude )
• TSCrashLongitude ( type: esriFieldTypeDouble, alias: TSCrashLongitude, editable: true, nullable: true, defaultValue: null, modelName: TSCrashLongitude )
• CrashReportCounty ( type: esriFieldTypeString, alias: CrashReportCounty, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: CrashReportCounty )
• DayOfWeek ( type: esriFieldTypeString, alias: DayOfWeek, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: DayOfWeek )
• TypeOfFirstCrash ( type: esriFieldTypeString, alias: TypeOfFirstCrash, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: TypeOfFirstCrash )
• CityName ( type: esriFieldTypeString, alias: CityName, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: CityName )
• CityClass ( type: esriFieldTypeString, alias: CityClass, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: CityClass )
• ClassOfTrafficway ( type: esriFieldTypeString, alias: ClassOfTrafficway, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: ClassOfTrafficway )
• Cause1 ( type: esriFieldTypeString, alias: Cause1, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: Cause1 )
• Cause2 ( type: esriFieldTypeString, alias: Cause2, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: Cause2 )
• TrafficControlDevice ( type: esriFieldTypeString, alias: TrafficControlDevice, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: TrafficControlDevice )
• TrafficControlDeviceCond ( type: esriFieldTypeString, alias: TrafficControlDeviceCond, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: TrafficControlDeviceCond )
• RoadSurfaceCond ( type: esriFieldTypeString, alias: RoadSurfaceCond, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: RoadSurfaceCond )
• RoadDefects ( type: esriFieldTypeString, alias: RoadDefects, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: RoadDefects )
• CrashInjurySeverity ( type: esriFieldTypeString, alias: CrashInjurySeverity, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: CrashInjurySeverity )
• LightingCond ( type: esriFieldTypeString, alias: LightingCond, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: LightingCond )
• WeatherCond ( type: esriFieldTypeString, alias: WeatherCond, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: WeatherCond )
• RoadAlignment ( type: esriFieldTypeString, alias: RoadAlignment, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: RoadAlignment )
• TrafficwayDescrip ( type: esriFieldTypeString, alias: TrafficwayDescrip, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: TrafficwayDescrip )
• RoadwayFunctionalClass ( type: esriFieldTypeString, alias: RoadwayFunctionalClass, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: RoadwayFunctionalClass )
• InvestigatingAgencyDescrip ( type: esriFieldTypeString, alias: InvestigatingAgencyDescrip, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: InvestigatingAgencyDescrip )
• CrashSeverityCd ( type: esriFieldTypeInteger, alias: CrashSeverityCd, editable: true, nullable: true, defaultValue: null, modelName: CrashSeverityCd )
• DamagedProperty1 ( type: esriFieldTypeString, alias: DamagedProperty1, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: DamagedProperty1 )
• DamagedProperty2 ( type: esriFieldTypeString, alias: DamagedProperty2, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: DamagedProperty2 )
• AgencyReportYear ( type: esriFieldTypeInteger, alias: AgencyReportYear, editable: true, nullable: true, defaultValue: null, modelName: AgencyReportYear )
• AgencyReportNumber ( type: esriFieldTypeString, alias: AgencyReportNumber, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: AgencyReportNumber )
• SFE ( type: esriFieldTypeString, alias: SFE, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: SFE )
• DidCrashOccurInWorkZone ( type: esriFieldTypeString, alias: DidCrashOccurInWorkZone, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: DidCrashOccurInWorkZone )
• WorkZoneType ( type: esriFieldTypeString, alias: WorkZoneType, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: WorkZoneType )
• WereWorkersPresent ( type: esriFieldTypeString, alias: WereWorkersPresent, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: WereWorkersPresent )
• WorkZone ( type: esriFieldTypeString, alias: WorkZone, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: WorkZone )
• AccessControl ( type: esriFieldTypeString, alias: AccessControl, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: AccessControl )
• FlowCondition ( type: esriFieldTypeString, alias: FlowCondition, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: FlowCondition )
• DidInvolveSecondaryCrash ( type: esriFieldTypeString, alias: DidInvolveSecondaryCrash, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: DidInvolveSecondaryCrash )
• UrbanRural ( type: esriFieldTypeString, alias: UrbanRural, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: UrbanRural )
• Toll ( type: esriFieldTypeString, alias: Toll, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: Toll )
• TypeofReport ( type: esriFieldTypeString, alias: TypeofReport, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: TypeofReport )

Templates:

• Name: TCRPC_crashes_2017_2022
  Description:
  Prototype:
  Toll: null
  TypeofReport: null
  CrashID: null
  CountyCode: null
  CrashYr: null
  CrashMonth: null
  CrashDay: null
  NumberOfVehicles: null
  DayOfWeekCode: null
  CrashHour: null
  CityCode: null
  CityClassCode: null
  Township: null
  CollisionTypeCode: null
  TotalFatals: null
  TotalInjured: null
  NoInjuries: null
  AInjuries: null
  BInjuries: null
  CInjuries: null
  CrashSeverity: null
  AgencyCode: null
  RouteNumber: null
  Milestation: null
  ClassOfTrafficwayCode: null
  NHS: null
  TrafficControlDeviceCode: null
  RoadSurfaceConditionCode: null
  RoadDefectsCode: null
  LightConditionCode: null
  WeatherCode: null
  Cause1Code: null
  Cause2Code: null
  RailroadCrossingNumber: null
  TimeOfCrash: null
  TrafficControlDeviceConditionCode: null
  IntersectionRelated: null
  HitAndRun: null
  CrashDate: null
  NumberOfLanes: null
  AlignmentCode: null
  TrafficwayDescriptionCode: null
  RoadwayFunctionalClassCode: null
  WorkZoneRelated: null
  City_Township_Flag: null
  TSCrashCoordinateX: null
  TSCrashCoordinateY: null
  TSCrashLatitude: null
  TSCrashLongitude: null
  CrashReportCounty: null
  DayOfWeek: null
  TypeOfFirstCrash: null
  CityName: null
  CityClass: null
  ClassOfTrafficway: null
  Cause1: null
  Cause2: null
  TrafficControlDevice: null
  TrafficControlDeviceCond: null
  RoadSurfaceCond: null
  RoadDefects: null
  CrashInjurySeverity: null
  LightingCond: null
  WeatherCond: null
  RoadAlignment: null
  TrafficwayDescrip: null
  RoadwayFunctionalClass: null
  InvestigatingAgencyDescrip: null
  CrashSeverityCd: null
  DamagedProperty1: null
  DamagedProperty2: null
  AgencyReportYear: null
  AgencyReportNumber: null
  SFE: null
  DidCrashOccurInWorkZone: null
  WorkZoneType: null
  WereWorkersPresent: null
  WorkZone: null
  AccessControl: null
  FlowCondition: null
  DidInvolveSecondaryCrash: null
  UrbanRural: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata