Name: CrashStatistics_ExportTable

Display Field: CityVillageTownshipName

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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• LocalReportNumber (type: esriFieldTypeString, alias: LocalReportNumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DocumentNumber (type: esriFieldTypeDouble, alias: DocumentNumber, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CrashSeverity (type: esriFieldTypeString, alias: CrashSeverity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HitSkip (type: esriFieldTypeString, alias: HitSkip, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LocalInformation (type: esriFieldTypeString, alias: LocalInformation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SecondaryCrash (type: esriFieldTypeSmallInteger, alias: SecondaryCrash, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PhotosTaken (type: esriFieldTypeSmallInteger, alias: PhotosTaken, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OH2 (type: esriFieldTypeSmallInteger, alias: OH2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OH3 (type: esriFieldTypeSmallInteger, alias: OH3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OH1P (type: esriFieldTypeSmallInteger, alias: OH1P, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OHOther (type: esriFieldTypeSmallInteger, alias: OHOther, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PrivateProperty (type: esriFieldTypeSmallInteger, alias: PrivateProperty, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ReportingAgencyNCIC (type: esriFieldTypeString, alias: ReportingAgencyNCIC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NumberOfUnits (type: esriFieldTypeDouble, alias: NumberOfUnits, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UnitInError (type: esriFieldTypeDouble, alias: UnitInError, SQL Type: sqlTypeOther, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InCityVillageTownship (type: esriFieldTypeString, alias: InCityVillageTownship, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CityVillageTownshipName (type: esriFieldTypeString, alias: CityVillageTownshipName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CrashDateTime (type: esriFieldTypeDate, alias: CrashDateTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FIPSPlaceCode (type: esriFieldTypeDouble, alias: FIPSPlaceCode, 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)
• LocationRouteType (type: esriFieldTypeString, alias: LocationRouteType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LocationRouteNumber (type: esriFieldTypeDouble, alias: LocationRouteNumber, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LocationPrefix (type: esriFieldTypeString, alias: LocationPrefix, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LocationRoadName (type: esriFieldTypeString, alias: LocationRoadName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LocationRoadType (type: esriFieldTypeString, alias: LocationRoadType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DistanceFromReference (type: esriFieldTypeDouble, alias: DistanceFromReference, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DistanceReferenceMeasurement (type: esriFieldTypeString, alias: DistanceReferenceMeasurement, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DirectionFromReference (type: esriFieldTypeString, alias: DirectionFromReference, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ReferenceRouteType (type: esriFieldTypeString, alias: ReferenceRouteType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ReferenceRouteNumber (type: esriFieldTypeString, alias: ReferenceRouteNumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ReferencePrefix (type: esriFieldTypeString, alias: ReferencePrefix, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ReferenceName (type: esriFieldTypeString, alias: ReferenceName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ReferencePointUsed (type: esriFieldTypeString, alias: ReferencePointUsed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ReferenceRoadType (type: esriFieldTypeString, alias: ReferenceRoadType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IntersectionOrApproachRelated (type: esriFieldTypeSmallInteger, alias: IntersectionOrApproachRelated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NumberOfApproaches (type: esriFieldTypeString, alias: NumberOfApproaches, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WithinInterchangeArea (type: esriFieldTypeSmallInteger, alias: WithinInterchangeArea, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LocationFirstHarmfulEvent (type: esriFieldTypeString, alias: LocationFirstHarmfulEvent, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MannerOfCollision (type: esriFieldTypeString, alias: MannerOfCollision, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Weather (type: esriFieldTypeString, alias: Weather, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LightCondition (type: esriFieldTypeString, alias: LightCondition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ActiveSchoolZoneRelated (type: esriFieldTypeSmallInteger, alias: ActiveSchoolZoneRelated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WorkZoneRelated (type: esriFieldTypeSmallInteger, alias: WorkZoneRelated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WorkersPresent (type: esriFieldTypeSmallInteger, alias: WorkersPresent, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LawEnforcementPresentInWorkZone (type: esriFieldTypeSmallInteger, alias: LawEnforcementPresentInWorkZone, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WorkZoneType (type: esriFieldTypeString, alias: WorkZoneType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WorkZoneLocation (type: esriFieldTypeString, alias: WorkZoneLocation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Narrative (type: esriFieldTypeString, alias: Narrative, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ReportTakenBy (type: esriFieldTypeString, alias: ReportTakenBy, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Supplement (type: esriFieldTypeSmallInteger, alias: Supplement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CrashReportedDateTime (type: esriFieldTypeDate, alias: CrashReportedDateTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DispatchedDateTime (type: esriFieldTypeDate, alias: DispatchedDateTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ArrivedDateTime (type: esriFieldTypeDate, alias: ArrivedDateTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SceneClearedDateTime (type: esriFieldTypeDate, alias: SceneClearedDateTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OtherInvestigationTime (type: esriFieldTypeDouble, alias: OtherInvestigationTime, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalTimeRoadwayClosed (type: esriFieldTypeString, alias: TotalTimeRoadwayClosed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OfficerName (type: esriFieldTypeString, alias: OfficerName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OfficerBadgeNumber (type: esriFieldTypeDouble, alias: OfficerBadgeNumber, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CheckedByOfficerName (type: esriFieldTypeString, alias: CheckedByOfficerName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CheckedByBadgeNumber (type: esriFieldTypeString, alias: CheckedByBadgeNumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RoadwayDivided (type: esriFieldTypeSmallInteger, alias: RoadwayDivided, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DividedLaneTravelDirection (type: esriFieldTypeString, alias: DividedLaneTravelDirection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DividedMedianType (type: esriFieldTypeString, alias: DividedMedianType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RoadContour (type: esriFieldTypeString, alias: RoadContour, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RoadCondition (type: esriFieldTypeString, alias: RoadCondition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RoadSurface (type: esriFieldTypeString, alias: RoadSurface, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TotalInjured (type: esriFieldTypeDouble, alias: TotalInjured, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalKilled (type: esriFieldTypeDouble, alias: TotalKilled, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalMinutes (type: esriFieldTypeDouble, alias: TotalMinutes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AnimalRelated (type: esriFieldTypeSmallInteger, alias: AnimalRelated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AnimalDeerRelated (type: esriFieldTypeSmallInteger, alias: AnimalDeerRelated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AlcoholRelated (type: esriFieldTypeSmallInteger, alias: AlcoholRelated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DrugRelated (type: esriFieldTypeSmallInteger, alias: DrugRelated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BicycleRelated (type: esriFieldTypeSmallInteger, alias: BicycleRelated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MotorCycleRelated (type: esriFieldTypeSmallInteger, alias: MotorCycleRelated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SpeedRelated (type: esriFieldTypeSmallInteger, alias: SpeedRelated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PedestrianRelated (type: esriFieldTypeSmallInteger, alias: PedestrianRelated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SemiTruckRelated (type: esriFieldTypeSmallInteger, alias: SemiTruckRelated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SmallTruckRelated (type: esriFieldTypeSmallInteger, alias: SmallTruckRelated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YouthRelated (type: esriFieldTypeSmallInteger, alias: YouthRelated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TeenRelated (type: esriFieldTypeSmallInteger, alias: TeenRelated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DUI21Related (type: esriFieldTypeSmallInteger, alias: DUI21Related, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SeniorRelated (type: esriFieldTypeSmallInteger, alias: SeniorRelated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FatalNotReportable (type: esriFieldTypeSmallInteger, alias: FatalNotReportable, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CommercialRelated (type: esriFieldTypeSmallInteger, alias: CommercialRelated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CommercialAtFault (type: esriFieldTypeSmallInteger, alias: CommercialAtFault, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: CrashStatistics_ExportTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/3/2023 6:23:55 PM

Schema Last Edit Date: 4/3/2023 6:23:55 PM

Data Last Edit Date: 4/3/2023 6:23:55 PM

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