Name: Alabama.DBO.ALABAMAECRASHCRASHDATA

Display Field: UserName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Supports Datum Transformation: true

Extent:

XMin: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 26916  (26916)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [255, 0, 0, 255]
Size: 6.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
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: false
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: true
Supports Sql Format: true
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• CUDrvBACNCV ( type: esriFieldTypeDouble, alias: CUDrvBACNCV )
• Milepost ( type: esriFieldTypeDouble, alias: Milepost )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• County ( type: esriFieldTypeString, alias: County, length: 200 )
• City ( type: esriFieldTypeString, alias: City, length: 200 )
• Year ( type: esriFieldTypeString, alias: Year, length: 200 )
• Month ( type: esriFieldTypeString, alias: Month, length: 200 )
• Day ( type: esriFieldTypeString, alias: Day, length: 200 )
• DayOfWeek ( type: esriFieldTypeString, alias: DayOfWeek, length: 200 )
• Week ( type: esriFieldTypeString, alias: Week, length: 200 )
• Time ( type: esriFieldTypeString, alias: Time, length: 200 )
• Date ( type: esriFieldTypeString, alias: Date, length: 200 )
• RuralUrban ( type: esriFieldTypeString, alias: RuralUrban, length: 200 )
• HwyClass ( type: esriFieldTypeString, alias: HwyClass, length: 200 )
• CtlAccess ( type: esriFieldTypeString, alias: CtlAccess, length: 200 )
• HwySide ( type: esriFieldTypeString, alias: HwySide, length: 200 )
• PriCause ( type: esriFieldTypeString, alias: PriCause, length: 200 )
• PriUnit ( type: esriFieldTypeString, alias: PriUnit, length: 200 )
• FrstHmEv ( type: esriFieldTypeString, alias: FrstHmEv, length: 200 )
• FrstHmEvLoc ( type: esriFieldTypeString, alias: FrstHmEvLoc, length: 200 )
• MostHmEv ( type: esriFieldTypeString, alias: MostHmEv, length: 200 )
• Distracted ( type: esriFieldTypeString, alias: Distracted, length: 200 )
• DistToObj ( type: esriFieldTypeString, alias: DistToObj, length: 200 )
• RdJnctFeat ( type: esriFieldTypeString, alias: RdJnctFeat, length: 200 )
• CrshManner ( type: esriFieldTypeString, alias: CrshManner, length: 200 )
• SchoolBus ( type: esriFieldTypeString, alias: SchoolBus, length: 200 )
• CrSeverity ( type: esriFieldTypeString, alias: CrSeverity, length: 200 )
• IntRelated ( type: esriFieldTypeString, alias: IntRelated, length: 200 )
• AtInt ( type: esriFieldTypeString, alias: AtInt, length: 200 )
• MPRoute ( type: esriFieldTypeString, alias: MPRoute, length: 200 )
• Lighting ( type: esriFieldTypeString, alias: Lighting, length: 200 )
• Weather ( type: esriFieldTypeString, alias: Weather, length: 200 )
• Locale ( type: esriFieldTypeString, alias: Locale, length: 200 )
• PolicePres ( type: esriFieldTypeString, alias: PolicePres, length: 200 )
• PolNtfyDel ( type: esriFieldTypeString, alias: PolNtfyDel, length: 200 )
• PolArrDel ( type: esriFieldTypeString, alias: PolArrDel, length: 200 )
• EMSArrDel ( type: esriFieldTypeString, alias: EMSArrDel, length: 200 )
• PropDamag ( type: esriFieldTypeString, alias: PropDamag, length: 200 )
• RptOfficer ( type: esriFieldTypeString, alias: RptOfficer, length: 200 )
• SupOfficer ( type: esriFieldTypeString, alias: SupOfficer, length: 200 )
• AgencyORI ( type: esriFieldTypeString, alias: AgencyORI, length: 200 )
• ORINumber ( type: esriFieldTypeString, alias: ORINumber, length: 200 )
• HPTroop ( type: esriFieldTypeString, alias: HPTroop, length: 200 )
• HPPost ( type: esriFieldTypeString, alias: HPPost, length: 200 )
• ALEADiv ( type: esriFieldTypeString, alias: ALEADiv, length: 200 )
• ALDOTArea ( type: esriFieldTypeString, alias: ALDOTArea, length: 200 )
• ALDOTReg ( type: esriFieldTypeString, alias: ALDOTReg, length: 200 )
• AHSORegion ( type: esriFieldTypeString, alias: AHSORegion, length: 200 )
• RPOrg ( type: esriFieldTypeString, alias: RPOrg, length: 200 )
• HasCoord ( type: esriFieldTypeString, alias: HasCoord, length: 200 )
• MapClick ( type: esriFieldTypeString, alias: MapClick, length: 200 )
• NumVeh ( type: esriFieldTypeString, alias: NumVeh, length: 200 )
• NumDrivers ( type: esriFieldTypeString, alias: NumDrivers, length: 200 )
• NumPersons ( type: esriFieldTypeString, alias: NumPersons, length: 200 )
• NumOcc ( type: esriFieldTypeString, alias: NumOcc, length: 200 )
• NumNonOcc ( type: esriFieldTypeString, alias: NumNonOcc, length: 200 )
• NumPed ( type: esriFieldTypeString, alias: NumPed, length: 200 )
• NumByc ( type: esriFieldTypeString, alias: NumByc, length: 200 )
• NumInjured ( type: esriFieldTypeString, alias: NumInjured, length: 200 )
• NumInjFat ( type: esriFieldTypeString, alias: NumInjFat, length: 200 )
• NumKilled ( type: esriFieldTypeString, alias: NumKilled, length: 200 )
• NumTrain ( type: esriFieldTypeString, alias: NumTrain, length: 200 )
• HasRRXing ( type: esriFieldTypeString, alias: HasRRXing, length: 200 )
• CMVInv ( type: esriFieldTypeString, alias: CMVInv, length: 200 )
• TruckBus ( type: esriFieldTypeString, alias: TruckBus, length: 200 )
• BusInv ( type: esriFieldTypeString, alias: BusInv, length: 200 )
• CUType ( type: esriFieldTypeString, alias: CUType, length: 200 )
• CUNonMotor ( type: esriFieldTypeString, alias: CUNonMotor, length: 200 )
• CUCMV ( type: esriFieldTypeString, alias: CUCMV, length: 200 )
• CULeftScen ( type: esriFieldTypeString, alias: CULeftScen, length: 200 )
• CUDrvAgeR1 ( type: esriFieldTypeString, alias: CUDrvAgeR1, length: 200 )
• CUDrvAgeR2 ( type: esriFieldTypeString, alias: CUDrvAgeR2, length: 200 )
• CUDrvAge ( type: esriFieldTypeString, alias: CUDrvAge, length: 200 )
• CUDrvRace ( type: esriFieldTypeString, alias: CUDrvRace, length: 200 )
• CUDrvGendr ( type: esriFieldTypeString, alias: CUDrvGendr, length: 200 )
• CUResDist ( type: esriFieldTypeString, alias: CUResDist, length: 200 )
• CUDLState ( type: esriFieldTypeString, alias: CUDLState, length: 200 )
• CUDLClass1 ( type: esriFieldTypeString, alias: CUDLClass1, length: 200 )
• CUDLClass2 ( type: esriFieldTypeString, alias: CUDLClass2, length: 200 )
• CUDLStatus ( type: esriFieldTypeString, alias: CUDLStatus, length: 200 )
• CUCDLStatu ( type: esriFieldTypeString, alias: CUCDLStatu, length: 200 )
• CUDLRestr1 ( type: esriFieldTypeString, alias: CUDLRestr1, length: 200 )
• CUDLRestr2 ( type: esriFieldTypeString, alias: CUDLRestr2, length: 200 )
• CUDLEndrs1 ( type: esriFieldTypeString, alias: CUDLEndrs1, length: 200 )
• CUDLEndrs2 ( type: esriFieldTypeString, alias: CUDLEndrs2, length: 200 )
• CUDrvEmp ( type: esriFieldTypeString, alias: CUDrvEmp, length: 200 )
• CUDrvCond ( type: esriFieldTypeString, alias: CUDrvCond, length: 200 )
• CUDrvAlc ( type: esriFieldTypeString, alias: CUDrvAlc, length: 200 )
• CUDrvDrug ( type: esriFieldTypeString, alias: CUDrvDrug, length: 200 )
• CUAlcTest ( type: esriFieldTypeString, alias: CUAlcTest, length: 200 )
• CUDrugTest ( type: esriFieldTypeString, alias: CUDrugTest, length: 200 )
• CUAlcRes ( type: esriFieldTypeString, alias: CUAlcRes, length: 200 )
• CUDrugRes ( type: esriFieldTypeString, alias: CUDrugRes, length: 200 )
• CUTravlDir ( type: esriFieldTypeString, alias: CUTravlDir, length: 200 )
• CUVehManuv ( type: esriFieldTypeString, alias: CUVehManuv, length: 200 )
• CUNMManuv ( type: esriFieldTypeString, alias: CUNMManuv, length: 200 )
• CUMostHarm ( type: esriFieldTypeString, alias: CUMostHarm, length: 200 )
• CUContCirc ( type: esriFieldTypeString, alias: CUContCirc, length: 200 )
• CUHarmEv1 ( type: esriFieldTypeString, alias: CUHarmEv1, length: 200 )
• CUSeqEv1 ( type: esriFieldTypeString, alias: CUSeqEv1, length: 200 )
• CUSeqEv2 ( type: esriFieldTypeString, alias: CUSeqEv2, length: 200 )
• CUSeqEv3 ( type: esriFieldTypeString, alias: CUSeqEv3, length: 200 )
• CUSeqEv4 ( type: esriFieldTypeString, alias: CUSeqEv4, length: 200 )
• CUModelYr ( type: esriFieldTypeString, alias: CUModelYr, length: 200 )
• CUMake ( type: esriFieldTypeString, alias: CUMake, length: 200 )
• CUBody ( type: esriFieldTypeString, alias: CUBody, length: 200 )
• CUOwnState ( type: esriFieldTypeString, alias: CUOwnState, length: 200 )
• CUTagState ( type: esriFieldTypeString, alias: CUTagState, length: 200 )
• CUVehUsage ( type: esriFieldTypeString, alias: CUVehUsage, length: 200 )
• CUEmergncy ( type: esriFieldTypeString, alias: CUEmergncy, length: 200 )
• CUPlacRqd ( type: esriFieldTypeString, alias: CUPlacRqd, length: 200 )
• CUPlacSts ( type: esriFieldTypeString, alias: CUPlacSts, length: 200 )
• CUHazCargo ( type: esriFieldTypeString, alias: CUHazCargo, length: 200 )
• CUHazRel ( type: esriFieldTypeString, alias: CUHazRel, length: 200 )
• CUAttach ( type: esriFieldTypeString, alias: CUAttach, length: 200 )
• CUOversize ( type: esriFieldTypeString, alias: CUOversize, length: 200 )
• CUOSPermit ( type: esriFieldTypeString, alias: CUOSPermit, length: 200 )
• CUVehDfect ( type: esriFieldTypeString, alias: CUVehDfect, length: 200 )
• CUSpeedLim ( type: esriFieldTypeString, alias: CUSpeedLim, length: 200 )
• CUSpeed ( type: esriFieldTypeString, alias: CUSpeed, length: 200 )
• CUCitation ( type: esriFieldTypeString, alias: CUCitation, length: 200 )
• CUVehDamag ( type: esriFieldTypeString, alias: CUVehDamag, length: 200 )
• CUTowed ( type: esriFieldTypeString, alias: CUTowed, length: 200 )
• CUDamageA1 ( type: esriFieldTypeString, alias: CUDamageA1, length: 200 )
• CUDamageA2 ( type: esriFieldTypeString, alias: CUDamageA2, length: 200 )
• CUDamageA3 ( type: esriFieldTypeString, alias: CUDamageA3, length: 200 )
• CUInitImp ( type: esriFieldTypeString, alias: CUInitImp, length: 200 )
• CUNMPreAct ( type: esriFieldTypeString, alias: CUNMPreAct, length: 200 )
• CUChildSch ( type: esriFieldTypeString, alias: CUChildSch, length: 200 )
• CUNMAct1 ( type: esriFieldTypeString, alias: CUNMAct1, length: 200 )
• CUNMAct2 ( type: esriFieldTypeString, alias: CUNMAct2, length: 200 )
• CUNMLoc ( type: esriFieldTypeString, alias: CUNMLoc, length: 200 )
• VehHitCUNM ( type: esriFieldTypeString, alias: VehHitCUNM, length: 200 )
• CUNMCond ( type: esriFieldTypeString, alias: CUNMCond, length: 200 )
• CUNMAlc ( type: esriFieldTypeString, alias: CUNMAlc, length: 200 )
• CUNMDrug ( type: esriFieldTypeString, alias: CUNMDrug, length: 200 )
• CUNMMstHrm ( type: esriFieldTypeString, alias: CUNMMstHrm, length: 200 )
• CUDNMSeat ( type: esriFieldTypeString, alias: CUDNMSeat, length: 200 )
• CUDNMType ( type: esriFieldTypeString, alias: CUDNMType, length: 200 )
• CUDNMSafty ( type: esriFieldTypeString, alias: CUDNMSafty, length: 200 )
• CUDrvAirbag ( type: esriFieldTypeString, alias: CUDrvAirbag, length: 200 )
• CUDNMAge ( type: esriFieldTypeString, alias: CUDNMAge, length: 200 )
• CUDNMGendr ( type: esriFieldTypeString, alias: CUDNMGendr, length: 200 )
• CUDrvEject ( type: esriFieldTypeString, alias: CUDrvEject, length: 200 )
• CUDNMInj ( type: esriFieldTypeString, alias: CUDNMInj, length: 200 )
• CUDNMFAid ( type: esriFieldTypeString, alias: CUDNMFAid, length: 200 )
• CUDNMXport ( type: esriFieldTypeString, alias: CUDNMXport, length: 200 )
• CUDNMXType ( type: esriFieldTypeString, alias: CUDNMXType, length: 200 )
• CURdBridge ( type: esriFieldTypeString, alias: CURdBridge, length: 200 )
• CURdSurfac ( type: esriFieldTypeString, alias: CURdSurfac, length: 200 )
• CURoadCond ( type: esriFieldTypeString, alias: CURoadCond, length: 200 )
• CUEnvContr ( type: esriFieldTypeString, alias: CUEnvContr, length: 200 )
• CURdMat ( type: esriFieldTypeString, alias: CURdMat, length: 200 )
• CURdMatSrc ( type: esriFieldTypeString, alias: CURdMatSrc, length: 200 )
• CURdCrvGrd ( type: esriFieldTypeString, alias: CURdCrvGrd, length: 200 )
• CUVisionOb ( type: esriFieldTypeString, alias: CUVisionOb, length: 200 )
• CUTraffCtl ( type: esriFieldTypeString, alias: CUTraffCtl, length: 200 )
• CUCtlFunct ( type: esriFieldTypeString, alias: CUCtlFunct, length: 200 )
• CUDivided ( type: esriFieldTypeString, alias: CUDivided, length: 200 )
• CUNumLanes ( type: esriFieldTypeString, alias: CUNumLanes, length: 200 )
• CUTurnLane ( type: esriFieldTypeString, alias: CUTurnLane, length: 200 )
• CUOneWay ( type: esriFieldTypeString, alias: CUOneWay, length: 200 )
• CUWorkzone ( type: esriFieldTypeString, alias: CUWorkzone, length: 200 )
• CUWorkZTyp ( type: esriFieldTypeString, alias: CUWorkZTyp, length: 200 )
• CUWorkers ( type: esriFieldTypeString, alias: CUWorkers, length: 200 )
• CULEPresnt ( type: esriFieldTypeString, alias: CULEPresnt, length: 200 )
• CUCMVInd ( type: esriFieldTypeString, alias: CUCMVInd, length: 200 )
• CUCMVWgt ( type: esriFieldTypeString, alias: CUCMVWgt, length: 200 )
• CUCMVHMInv ( type: esriFieldTypeString, alias: CUCMVHMInv, length: 200 )
• CUCMVHMRel ( type: esriFieldTypeString, alias: CUCMVHMRel, length: 200 )
• CUCMVBus ( type: esriFieldTypeString, alias: CUCMVBus, length: 200 )
• CUCMVCnfig ( type: esriFieldTypeString, alias: CUCMVCnfig, length: 200 )
• CUCMVCargo ( type: esriFieldTypeString, alias: CUCMVCargo, length: 200 )
• CUCMVBody ( type: esriFieldTypeString, alias: CUCMVBody, length: 200 )
• CUCMVSeq1 ( type: esriFieldTypeString, alias: CUCMVSeq1, length: 200 )
• CUCMVSeq2 ( type: esriFieldTypeString, alias: CUCMVSeq2, length: 200 )
• CUCMVSeq3 ( type: esriFieldTypeString, alias: CUCMVSeq3, length: 200 )
• CUCMVSeq4 ( type: esriFieldTypeString, alias: CUCMVSeq4, length: 200 )
• CUCMVMCTyp ( type: esriFieldTypeString, alias: CUCMVMCTyp, length: 200 )
• V2Type ( type: esriFieldTypeString, alias: V2Type, length: 200 )
• V2LeftScen ( type: esriFieldTypeString, alias: V2LeftScen, length: 200 )
• V2ResDist ( type: esriFieldTypeString, alias: V2ResDist, length: 200 )
• V2DLState ( type: esriFieldTypeString, alias: V2DLState, length: 200 )
• V2DLRestr1 ( type: esriFieldTypeString, alias: V2DLRestr1, length: 200 )
• V2DrvCond ( type: esriFieldTypeString, alias: V2DrvCond, length: 200 )
• V2DrvAlc ( type: esriFieldTypeString, alias: V2DrvAlc, length: 200 )
• V2DrvDrug ( type: esriFieldTypeString, alias: V2DrvDrug, length: 200 )
• V2TravlDir ( type: esriFieldTypeString, alias: V2TravlDir, length: 200 )
• V2VehManuv ( type: esriFieldTypeString, alias: V2VehManuv, length: 200 )
• V2MostHarm ( type: esriFieldTypeString, alias: V2MostHarm, length: 200 )
• V2ContCirc ( type: esriFieldTypeString, alias: V2ContCirc, length: 200 )
• V2HazCargo ( type: esriFieldTypeString, alias: V2HazCargo, length: 200 )
• V2Attach ( type: esriFieldTypeString, alias: V2Attach, length: 200 )
• V2Oversize ( type: esriFieldTypeString, alias: V2Oversize, length: 200 )
• V2SpeedLim ( type: esriFieldTypeString, alias: V2SpeedLim, length: 200 )
• V2Speed ( type: esriFieldTypeString, alias: V2Speed, length: 200 )
• V2Citation ( type: esriFieldTypeString, alias: V2Citation, length: 200 )
• V2VehDamag ( type: esriFieldTypeString, alias: V2VehDamag, length: 200 )
• V2Towed ( type: esriFieldTypeString, alias: V2Towed, length: 200 )
• V2InitImp ( type: esriFieldTypeString, alias: V2InitImp, length: 200 )
• V2RdBridge ( type: esriFieldTypeString, alias: V2RdBridge, length: 200 )
• V2RoadCond ( type: esriFieldTypeString, alias: V2RoadCond, length: 200 )
• V2VisionOb ( type: esriFieldTypeString, alias: V2VisionOb, length: 200 )
• V2TraffCtl ( type: esriFieldTypeString, alias: V2TraffCtl, length: 200 )
• V2NumLanes ( type: esriFieldTypeString, alias: V2NumLanes, length: 200 )
• HasPhoto ( type: esriFieldTypeString, alias: HasPhoto, length: 200 )
• Datetime ( type: esriFieldTypeDate, alias: Datetime, length: 8 )
• RecordID ( type: esriFieldTypeString, alias: RecordID, length: 200 )
• CrashNum ( type: esriFieldTypeString, alias: CrashNum, length: 200 )
• CaseNum ( type: esriFieldTypeString, alias: CaseNum, length: 200 )
• BadgeNum ( type: esriFieldTypeString, alias: BadgeNum, length: 200 )
• UserName ( type: esriFieldTypeString, alias: UserName, length: 200 )
• EMSRunNum ( type: esriFieldTypeString, alias: EMSRunNum, length: 200 )
• CUDrvAgeNCV ( type: esriFieldTypeInteger, alias: CUDrvAgeNCV )
• CUVIN ( type: esriFieldTypeString, alias: CUVIN, length: 200 )
• NumInjNCV ( type: esriFieldTypeInteger, alias: NumInjNCV )
• NumInjFatNCV ( type: esriFieldTypeInteger, alias: NumInjFatNCV )
• NumKilledNCV ( type: esriFieldTypeInteger, alias: NumKilledNCV )
• RRXingNum ( type: esriFieldTypeString, alias: RRXingNum, length: 200 )
• Link ( type: esriFieldTypeString, alias: Link, length: 200 )
• Node1 ( type: esriFieldTypeInteger, alias: Node1 )
• Node2 ( type: esriFieldTypeInteger, alias: Node2 )
• LocalZone ( type: esriFieldTypeString, alias: LocalZone, length: 200 )
• CAREKey ( type: esriFieldTypeString, alias: CAREKey, length: 200 )
• ProcessTime ( type: esriFieldTypeDate, alias: ProcessTime, length: 8 )
• mapTitle ( type: esriFieldTypeString, alias: mapTitle, length: 211 )
• mapDescription ( type: esriFieldTypeString, alias: mapDescription, length: 638 )
• url ( type: esriFieldTypeString, alias: url, length: 106 )
• Route ( type: esriFieldTypeString, alias: Route, length: 200 )
• RouteId ( type: esriFieldTypeString, alias: RouteId, length: 200 )
• Milepoint ( type: esriFieldTypeDouble, alias: Milepoint )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata