View In:   ArcGIS Online Map Viewer

Name: Gallatin Crash Data

Display Field: IntersectRoadNameTxt

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>The dataset show historical crash sites located in the City of Gallatin Urban Growth Boundary.</SPAN></P></DIV></DIV></DIV>

Service Item Id: 80c7303325ba4e46879e17a637d31330

Copyright Text: TN STS

Default Visibility: true

MaxRecordCount: 5000

Supported Query Formats: JSON, geoJSON, PBF

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: 1777169.231636554
YMin: 718551.3040988147
XMax: 1877543.0230145603
YMax: 796673.9746248126
Spatial Reference: 102736  (2274)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [165, 48, 106, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

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 )
• MstrRecNbrTxt ( type: esriFieldTypeString, alias: MstrRecNbrTxt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: MstrRecNbrTxt )
• CollisionDte ( type: esriFieldTypeString, alias: CollisionDte, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CollisionDte )
• CollisionTimeTxt ( type: esriFieldTypeString, alias: CollisionTimeTxt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CollisionTimeTxt )
• NbrUnitsNmb ( type: esriFieldTypeInteger, alias: NbrUnitsNmb, editable: true, nullable: true, defaultValue: null, modelName: NbrUnitsNmb )
• NbrFatalitiesNmb ( type: esriFieldTypeString, alias: NbrFatalitiesNmb, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: NbrFatalitiesNmb )
• NbrInjuredNmb ( type: esriFieldTypeDouble, alias: NbrInjuredNmb, editable: true, nullable: true, defaultValue: null, modelName: NbrInjuredNmb )
• NbrNonInjuredNmb ( type: esriFieldTypeDouble, alias: NbrNonInjuredNmb, editable: true, nullable: true, defaultValue: null, modelName: NbrNonInjuredNmb )
• NbrMotoristsNmb ( type: esriFieldTypeInteger, alias: NbrMotoristsNmb, editable: true, nullable: true, defaultValue: null, modelName: NbrMotoristsNmb )
• NbrNonMotoristsNmb ( type: esriFieldTypeInteger, alias: NbrNonMotoristsNmb, editable: true, nullable: true, defaultValue: null, modelName: NbrNonMotoristsNmb )
• NbrPropOwnersNmb ( type: esriFieldTypeDouble, alias: NbrPropOwnersNmb, editable: true, nullable: true, defaultValue: null, modelName: NbrPropOwnersNmb )
• NbrWitnessesNmb ( type: esriFieldTypeInteger, alias: NbrWitnessesNmb, editable: true, nullable: true, defaultValue: null, modelName: NbrWitnessesNmb )
• AgencyOriTxt ( type: esriFieldTypeString, alias: AgencyOriTxt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: AgencyOriTxt )
• AgencyTrackingNbrTxt ( type: esriFieldTypeString, alias: AgencyTrackingNbrTxt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: AgencyTrackingNbrTxt )
• AlcoholInd ( type: esriFieldTypeString, alias: AlcoholInd, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: AlcoholInd )
• AreaDesignationCde ( type: esriFieldTypeString, alias: AreaDesignationCde, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: AreaDesignationCde )
• ArrivedDte ( type: esriFieldTypeDate, alias: ArrivedDte, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ArrivedDte )
• BlockNbrTxt ( type: esriFieldTypeString, alias: BlockNbrTxt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: BlockNbrTxt )
• CityCde ( type: esriFieldTypeInteger, alias: CityCde, editable: true, nullable: true, defaultValue: null, modelName: CityCde )
• CommercialInd ( type: esriFieldTypeString, alias: CommercialInd, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CommercialInd )
• ConstructionMaintZoneCde ( type: esriFieldTypeString, alias: ConstructionMaintZoneCde, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ConstructionMaintZoneCde )
• ConstructionMaintZoneLocationCd ( type: esriFieldTypeString, alias: ConstructionMaintZoneLocationCde, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ConstructionMaintZoneLocationCd )
• CountyStateCde ( type: esriFieldTypeString, alias: CountyStateCde, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CountyStateCde )
• CrashTypeCde ( type: esriFieldTypeInteger, alias: CrashTypeCde, editable: true, nullable: true, defaultValue: null, modelName: CrashTypeCde )
• DiagramPresentInd ( type: esriFieldTypeString, alias: DiagramPresentInd, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: DiagramPresentInd )
• DirFromRefCde ( type: esriFieldTypeString, alias: DirFromRefCde, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: DirFromRefCde )
• DistFromRefNmb ( type: esriFieldTypeDouble, alias: DistFromRefNmb, editable: true, nullable: true, defaultValue: null, modelName: DistFromRefNmb )
• DrugInd ( type: esriFieldTypeString, alias: DrugInd, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: DrugInd )
• FatalCaseNbrTxt ( type: esriFieldTypeString, alias: FatalCaseNbrTxt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FatalCaseNbrTxt )
• FatalitiesInd ( type: esriFieldTypeString, alias: FatalitiesInd, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FatalitiesInd )
• FirstHarmfulEventCde ( type: esriFieldTypeString, alias: FirstHarmfulEventCde, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FirstHarmfulEventCde )
• HazMatInd ( type: esriFieldTypeString, alias: HazMatInd, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: HazMatInd )
• HitAndRunSolvedInd ( type: esriFieldTypeString, alias: HitAndRunSolvedInd, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: HitAndRunSolvedInd )
• HitRunInd ( type: esriFieldTypeString, alias: HitRunInd, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: HitRunInd )
• InjuredTransInd ( type: esriFieldTypeString, alias: InjuredTransInd, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: InjuredTransInd )
• InterchangeRelatedInd ( type: esriFieldTypeString, alias: InterchangeRelatedInd, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: InterchangeRelatedInd )
• IntersectionInd ( type: esriFieldTypeString, alias: IntersectionInd, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: IntersectionInd )
• IntersectLocalIDTxt ( type: esriFieldTypeString, alias: IntersectLocalIDTxt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: IntersectLocalIDTxt )
• IntersectRoadNameTxt ( type: esriFieldTypeString, alias: IntersectRoadNameTxt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: IntersectRoadNameTxt )
• IntersectRoadNameSuffixTxt ( type: esriFieldTypeString, alias: IntersectRoadNameSuffixTxt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: IntersectRoadNameSuffixTxt )
• IntersectRoadNbrTxt ( type: esriFieldTypeString, alias: IntersectRoadNbrTxt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: IntersectRoadNbrTxt )
• IntersectTypeCde ( type: esriFieldTypeString, alias: IntersectTypeCde, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: IntersectTypeCde )
• InvestigationCompleteInd ( type: esriFieldTypeString, alias: InvestigationCompleteInd, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: InvestigationCompleteInd )
• LatDecimalNmb ( type: esriFieldTypeDouble, alias: LatDecimalNmb, editable: true, nullable: true, defaultValue: null, modelName: LatDecimalNmb )
• LongDecimalNmb ( type: esriFieldTypeDouble, alias: LongDecimalNmb, editable: true, nullable: true, defaultValue: null, modelName: LongDecimalNmb )
• LightConditionCde ( type: esriFieldTypeString, alias: LightConditionCde, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LightConditionCde )
• MannerCollisionCde ( type: esriFieldTypeString, alias: MannerCollisionCde, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: MannerCollisionCde )
• MileMarkNmb ( type: esriFieldTypeDouble, alias: MileMarkNmb, editable: true, nullable: true, defaultValue: null, modelName: MileMarkNmb )
• MilesFeetCde ( type: esriFieldTypeString, alias: MilesFeetCde, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: MilesFeetCde )
• NineOrMoreInd ( type: esriFieldTypeString, alias: NineOrMoreInd, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: NineOrMoreInd )
• NotifiedDte ( type: esriFieldTypeString, alias: NotifiedDte, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: NotifiedDte )
• PhotosTakenInd ( type: esriFieldTypeString, alias: PhotosTakenInd, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PhotosTakenInd )
• PhotosByCde ( type: esriFieldTypeString, alias: PhotosByCde, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PhotosByCde )
• PhotosByDescTxt ( type: esriFieldTypeString, alias: PhotosByDescTxt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PhotosByDescTxt )
• PolicePursuitInd ( type: esriFieldTypeString, alias: PolicePursuitInd, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PolicePursuitInd )
• RailCrossingIDTxt ( type: esriFieldTypeString, alias: RailCrossingIDTxt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: RailCrossingIDTxt )
• RdwyLocalIDTxt ( type: esriFieldTypeString, alias: RdwyLocalIDTxt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: RdwyLocalIDTxt )
• RdwyNameTxt ( type: esriFieldTypeString, alias: RdwyNameTxt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: RdwyNameTxt )
• RdwyNameSuffixTxt ( type: esriFieldTypeString, alias: RdwyNameSuffixTxt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: RdwyNameSuffixTxt )
• RdwyNbrTxt ( type: esriFieldTypeString, alias: RdwyNbrTxt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: RdwyNbrTxt )
• RelationToJunctionCde ( type: esriFieldTypeString, alias: RelationToJunctionCde, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: RelationToJunctionCde )
• RelationToRoadCde ( type: esriFieldTypeString, alias: RelationToRoadCde, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: RelationToRoadCde )
• RolloverInd ( type: esriFieldTypeString, alias: RolloverInd, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: RolloverInd )
• RouteSigningCde ( type: esriFieldTypeString, alias: RouteSigningCde, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: RouteSigningCde )
• SchoolBusCde ( type: esriFieldTypeDouble, alias: SchoolBusCde, editable: true, nullable: true, defaultValue: null, modelName: SchoolBusCde )
• SpeedInd ( type: esriFieldTypeString, alias: SpeedInd, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SpeedInd )
• SubmissionTypeCde ( type: esriFieldTypeString, alias: SubmissionTypeCde, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SubmissionTypeCde )
• SubmittedByBadgeNbrTxt ( type: esriFieldTypeString, alias: SubmittedByBadgeNbrTxt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SubmittedByBadgeNbrTxt )
• TenKPlusInd ( type: esriFieldTypeString, alias: TenKPlusInd, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: TenKPlusInd )
• TrafficwayTypeCde ( type: esriFieldTypeInteger, alias: TrafficwayTypeCde, editable: true, nullable: true, defaultValue: null, modelName: TrafficwayTypeCde )
• TowedInd ( type: esriFieldTypeString, alias: TowedInd, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: TowedInd )
• WeatherCde ( type: esriFieldTypeString, alias: WeatherCde, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: WeatherCde )
• WorkersPresentCde ( type: esriFieldTypeString, alias: WorkersPresentCde, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: WorkersPresentCde )
• WorkZoneTypeCde ( type: esriFieldTypeInteger, alias: WorkZoneTypeCde, editable: true, nullable: true, defaultValue: null, modelName: WorkZoneTypeCde )
• VersionNbrTxt ( type: esriFieldTypeString, alias: VersionNbrTxt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: VersionNbrTxt )
• MeasurementTypeCde ( type: esriFieldTypeString, alias: MeasurementTypeCde, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: MeasurementTypeCde )
• FormLevel ( type: esriFieldTypeInteger, alias: FormLevel, editable: true, nullable: true, defaultValue: null, modelName: FormLevel )
• SecondaryCollision ( type: esriFieldTypeString, alias: SecondaryCollision, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SecondaryCollision )
• BlockageOccurred ( type: esriFieldTypeString, alias: BlockageOccurred, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: BlockageOccurred )
• SecondaryCollisionType ( type: esriFieldTypeString, alias: SecondaryCollisionType, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SecondaryCollisionType )
• CollisionUID ( type: esriFieldTypeString, alias: CollisionUID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CollisionUID )
• LIGHTCONDITION_TEXT ( type: esriFieldTypeString, alias: LIGHTCONDITION_TEXT, editable: true, nullable: true, length: 75, defaultValue: null, modelName: LIGHTCONDITION_TEXT )
• WEATHERCONDITION_TEXT ( type: esriFieldTypeString, alias: WEATHERCONDITION_TEXT, editable: true, nullable: true, length: 75, defaultValue: null, modelName: WEATHERCONDITION_TEXT )
• CRASHTYPE_TEXT ( type: esriFieldTypeString, alias: CRASHTYPE_TEXT, editable: true, nullable: true, length: 75, defaultValue: null, modelName: CRASHTYPE_TEXT )
• MANNERCOLLISION_TEXT ( type: esriFieldTypeString, alias: MANNERCOLLISION_TEXT, editable: true, nullable: true, length: 75, defaultValue: null, modelName: MANNERCOLLISION_TEXT )
• JUNCTIONRELATION_TEXT ( type: esriFieldTypeString, alias: JUNCTIONRELATION_TEXT, editable: true, nullable: true, length: 100, defaultValue: null, modelName: JUNCTIONRELATION_TEXT )
• ROADRELATION_TEXT ( type: esriFieldTypeString, alias: ROADRELATION_TEXT, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ROADRELATION_TEXT )
• CrashTypeCdeSTRING ( type: esriFieldTypeString, alias: CrashTypeCdeSTRING, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CrashTypeCdeSTRING )
• COLLISION_YEAR ( type: esriFieldTypeString, alias: COLLISION_YEAR, editable: true, nullable: true, length: 10, defaultValue: null, modelName: COLLISION_YEAR )
• COLLISION_DATE ( type: esriFieldTypeString, alias: COLLISION_DATE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COLLISION_DATE )

Templates:

• Name: Gallatin Crash Data
  Description:
  Prototype:
  COLLISION_YEAR: null
  MstrRecNbrTxt: null
  CollisionDte: null
  CollisionTimeTxt: null
  NbrUnitsNmb: null
  NbrFatalitiesNmb: null
  NbrInjuredNmb: null
  NbrNonInjuredNmb: null
  NbrMotoristsNmb: null
  NbrNonMotoristsNmb: null
  NbrPropOwnersNmb: null
  NbrWitnessesNmb: null
  AgencyOriTxt: null
  AgencyTrackingNbrTxt: null
  AlcoholInd: null
  AreaDesignationCde: null
  ArrivedDte: null
  BlockNbrTxt: null
  CityCde: null
  CommercialInd: null
  ConstructionMaintZoneCde: null
  ConstructionMaintZoneLocationCd: null
  CountyStateCde: null
  CrashTypeCde: null
  DiagramPresentInd: null
  DirFromRefCde: null
  DistFromRefNmb: null
  DrugInd: null
  FatalCaseNbrTxt: null
  FatalitiesInd: null
  FirstHarmfulEventCde: null
  HazMatInd: null
  HitAndRunSolvedInd: null
  HitRunInd: null
  InjuredTransInd: null
  InterchangeRelatedInd: null
  IntersectionInd: null
  IntersectLocalIDTxt: null
  IntersectRoadNameTxt: null
  IntersectRoadNameSuffixTxt: null
  IntersectRoadNbrTxt: null
  IntersectTypeCde: null
  InvestigationCompleteInd: null
  LatDecimalNmb: null
  LongDecimalNmb: null
  LightConditionCde: null
  MannerCollisionCde: null
  MileMarkNmb: null
  MilesFeetCde: null
  NineOrMoreInd: null
  NotifiedDte: null
  PhotosTakenInd: null
  PhotosByCde: null
  PhotosByDescTxt: null
  PolicePursuitInd: null
  RailCrossingIDTxt: null
  RdwyLocalIDTxt: null
  RdwyNameTxt: null
  RdwyNameSuffixTxt: null
  RdwyNbrTxt: null
  RelationToJunctionCde: null
  RelationToRoadCde: null
  RolloverInd: null
  RouteSigningCde: null
  SchoolBusCde: null
  SpeedInd: null
  SubmissionTypeCde: null
  SubmittedByBadgeNbrTxt: null
  TenKPlusInd: null
  TrafficwayTypeCde: null
  TowedInd: null
  WeatherCde: null
  WorkersPresentCde: null
  WorkZoneTypeCde: null
  VersionNbrTxt: null
  MeasurementTypeCde: null
  FormLevel: null
  SecondaryCollision: null
  BlockageOccurred: null
  SecondaryCollisionType: null
  CollisionUID: null
  LIGHTCONDITION_TEXT: null
  WEATHERCONDITION_TEXT: null
  CRASHTYPE_TEXT: null
  MANNERCOLLISION_TEXT: null
  JUNCTIONRELATION_TEXT: null
  ROADRELATION_TEXT: null
  CrashTypeCdeSTRING: null
  COLLISION_DATE: 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

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata