Name: odot_crash_data_non_fwy

Display Field: CRASH_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: For general mapping and support of analyzing crash data within Tigard. Based on ODOT Crash Unit 2007-2014 crash data. Does not include any I-5 or 217 intersections (except for ramps). For internal use only.

Service Item Id: c62dc01ce5f24e3997547a4b1ca7d764

Copyright Text: ODOT Crash Unit

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: -1.36763733151E7
YMin: 5684223.049999997
XMax: -1.36637374816E7
YMax: 5693696.460699998
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [52, 143, 173, 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:

Feature Draw Order:

N/A

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: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CRASH_ID ( type: esriFieldTypeInteger, alias: CRASH ID )
• SER_NO ( type: esriFieldTypeString, alias: DMV Serial No, length: 5 )
• CRASH_DT ( type: esriFieldTypeDate, alias: CRASH Date, length: 8 )
• CRASH_HR_NO ( type: esriFieldTypeString, alias: CRASH Hour, length: 2 )
• CRASH_HR_LONG_DESC ( type: esriFieldTypeString, alias: CRASH Hour Desc, length: 50 )
• CNTY_ID ( type: esriFieldTypeString, alias: County Code, length: 2 )
• CNTY_NM ( type: esriFieldTypeString, alias: County Name, length: 50 )
• CITY_SECT_ID ( type: esriFieldTypeInteger, alias: City Code )
• CITY_SECT_NM ( type: esriFieldTypeString, alias: City Name, length: 25 )
• URB_AREA_CD ( type: esriFieldTypeSmallInteger, alias: Urban Area (FAUB) )
• URB_AREA_LONG_NM ( type: esriFieldTypeString, alias: Urban Area Name (FAUB), length: 50 )
• FC_CD ( type: esriFieldTypeString, alias: Functional Class Code, length: 2 )
• FC_DESC ( type: esriFieldTypeString, alias: Functional Class Desc, length: 50 )
• NHS_FLG ( type: esriFieldTypeSmallInteger, alias: NHS Flag )
• RTE_ID ( type: esriFieldTypeString, alias: Route ID, length: 5 )
• RTE_NM ( type: esriFieldTypeString, alias: Route Name, length: 10 )
• RTE_TYP_CD ( type: esriFieldTypeString, alias: Route Type, length: 2 )
• HWY_NO ( type: esriFieldTypeString, alias: Highway Num, length: 3 )
• HWY_MED_NM ( type: esriFieldTypeString, alias: Highway Name, length: 30 )
• HWY_SFX_NO ( type: esriFieldTypeString, alias: Highway Suffix, length: 2 )
• RDWY_NO ( type: esriFieldTypeString, alias: Roadway Num, length: 1 )
• HWY_COMPNT_CD ( type: esriFieldTypeString, alias: HWY Component Code, length: 1 )
• HWY_COMPNT_LONG_DESC ( type: esriFieldTypeString, alias: Highway Component Desc, length: 50 )
• MLGE_TYP_CD ( type: esriFieldTypeString, alias: Mileage Type, length: 1 )
• MLGE_TYP_LONG_DESC ( type: esriFieldTypeString, alias: Mileage Type Desc, length: 50 )
• RD_CON_NO ( type: esriFieldTypeString, alias: Connection No, length: 1 )
• MP_NO ( type: esriFieldTypeDouble, alias: Milepoint )
• LRS_VAL ( type: esriFieldTypeString, alias: LRS, length: 20 )
• LAT_DEG_NO ( type: esriFieldTypeInteger, alias: Latitude Degree )
• LAT_MINUTE_NO ( type: esriFieldTypeInteger, alias: Latitude Minute )
• LAT_SEC_NO ( type: esriFieldTypeDouble, alias: Latitude Second )
• LONGTD_DEG_NO ( type: esriFieldTypeInteger, alias: Longitude Degree )
• LONGTD_MINUTE_NO ( type: esriFieldTypeInteger, alias: Longitude Minute )
• LONGTD_SEC_NO ( type: esriFieldTypeDouble, alias: Longitude Second )
• LAT_DD ( type: esriFieldTypeDouble, alias: Latitude Decimal Deg )
• LONGTD_DD ( type: esriFieldTypeDouble, alias: Longitude Decimal Deg )
• SEG_MRK_ID ( type: esriFieldTypeString, alias: Segment Marker ID, length: 30 )
• SEG_PT_LRS_MEAS ( type: esriFieldTypeDouble, alias: Segment LRS Measure )
• UNLOCT_FLG ( type: esriFieldTypeSmallInteger, alias: Unlocatable Flag )
• SPECL_JRSDCT_ID ( type: esriFieldTypeString, alias: Special Jurisdiction ID, length: 2 )
• SPECL_JRSDCT_LONG_DESC ( type: esriFieldTypeString, alias: Special Jurisdiction Desc, length: 50 )
• RECRE_RD_NM ( type: esriFieldTypeString, alias: Recreational Rd Name, length: 15 )
• ISECT_RECRE_RD_NM ( type: esriFieldTypeString, alias: Intersecting Rec Rd Name, length: 15 )
• AGY_ST_NO ( type: esriFieldTypeString, alias: Street No, length: 7 )
• ST_FULL_NM ( type: esriFieldTypeString, alias: Street Name, length: 28 )
• ISECT_AGY_ST_NO ( type: esriFieldTypeString, alias: Intersecting Street No, length: 7 )
• ISECT_ST_FULL_NM ( type: esriFieldTypeString, alias: Intersecting Street Name, length: 28 )
• ISECT_SEQ_NO ( type: esriFieldTypeSmallInteger, alias: Intersection Sequence No )
• FROM_ISECT_DSTNC_QTY ( type: esriFieldTypeInteger, alias: Distance from Intersection )
• CMPSS_DIR_CD ( type: esriFieldTypeString, alias: Direction from Intersection, length: 1 )
• CMPSS_DIR_SHORT_DESC ( type: esriFieldTypeString, alias: Direction from Intersection Desc, length: 2 )
• POST_SPEED_LMT_VAL ( type: esriFieldTypeString, alias: Posted Speed, length: 2 )
• RD_CHAR_CD ( type: esriFieldTypeString, alias: Rd Character Code, length: 1 )
• RD_CHAR_LONG_DESC ( type: esriFieldTypeString, alias: Rd Character Desc, length: 50 )
• OFF_RDWY_FLG ( type: esriFieldTypeSmallInteger, alias: Off Roadway Flag )
• ISECT_TYP_CD ( type: esriFieldTypeString, alias: Intersection Type, length: 1 )
• ISECT_TYP_SHORT_DESC ( type: esriFieldTypeString, alias: Intersection Type Desc, length: 7 )
• ISECT_REL_FLG ( type: esriFieldTypeSmallInteger, alias: Intersection Related Flag )
• RNDABT_FLG ( type: esriFieldTypeSmallInteger, alias: Roundabout Flag )
• DRVWY_REL_FLG ( type: esriFieldTypeSmallInteger, alias: Driveway Related Flag )
• LN_QTY ( type: esriFieldTypeSmallInteger, alias: Number of Lanes )
• TURNG_LEG_QTY ( type: esriFieldTypeInteger, alias: Number of Turning Legs )
• MEDN_TYP_CD ( type: esriFieldTypeString, alias: Median Type Code, length: 1 )
• MEDN_TYP_LONG_DESC ( type: esriFieldTypeString, alias: Median Type Desc, length: 50 )
• IMPCT_LOC_CD ( type: esriFieldTypeString, alias: Location of Impact, length: 2 )
• CRASH_TYP_CD ( type: esriFieldTypeString, alias: Crash Type Code, length: 1 )
• CRASH_TYP_LONG_DESC ( type: esriFieldTypeString, alias: Crash Type Desc, length: 75 )
• COLLIS_TYP_CD ( type: esriFieldTypeString, alias: Collision Type Code, length: 1 )
• COLLIS_TYP_LONG_DESC ( type: esriFieldTypeString, alias: Collison Type Desc, length: 30 )
• CRASH_SVRTY_CD ( type: esriFieldTypeString, alias: Crash Severity Code, length: 1 )
• CRASH_SVRTY_LONG_DESC ( type: esriFieldTypeString, alias: Crash Severity Desc, length: 50 )
• WTHR_COND_CD ( type: esriFieldTypeString, alias: Weather Condition, length: 1 )
• WTHR_COND_LONG_DESC ( type: esriFieldTypeString, alias: Weather Desc, length: 10 )
• RD_SURF_COND_CD ( type: esriFieldTypeString, alias: Road Surface Condition, length: 1 )
• RD_SURF_MED_DESC ( type: esriFieldTypeString, alias: Road Surface Condition Desc, length: 20 )
• LGT_COND_CD ( type: esriFieldTypeString, alias: Light Condition, length: 1 )
• LGT_COND_LONG_DESC ( type: esriFieldTypeString, alias: Light Condition Desc, length: 50 )
• TRAF_CNTL_DEVICE_CD ( type: esriFieldTypeString, alias: Traffic Control Device Code, length: 3 )
• TRAF_CNTL_DEVICE_LONG_DESC ( type: esriFieldTypeString, alias: Traffic Control Device Desc, length: 50 )
• TRAF_CNTL_FUNC_FLG ( type: esriFieldTypeSmallInteger, alias: TCD Functioning )
• INVSTG_AGY_CD ( type: esriFieldTypeString, alias: Investigating Agency, length: 1 )
• INVSTG_AGY_LONG_DESC ( type: esriFieldTypeString, alias: Investigating Agency Desc, length: 50 )
• SCHL_ZONE_IND ( type: esriFieldTypeString, alias: School Zone Indicator, length: 1 )
• WRK_ZONE_IND ( type: esriFieldTypeString, alias: Work Zone Indicator, length: 1 )
• ALCHL_INVLV_FLG ( type: esriFieldTypeSmallInteger, alias: Alcohol Involved Flag )
• DRUG_INVLV_FLG ( type: esriFieldTypeSmallInteger, alias: Drug Involved Flag )
• CRASH_SPEED_INVLV_FLG ( type: esriFieldTypeSmallInteger, alias: Speed Involved Flag )
• CRASH_HIT_RUN_FLG ( type: esriFieldTypeSmallInteger, alias: Hit and Run Flag )
• POP_RNG_CD ( type: esriFieldTypeString, alias: Population Range Code, length: 1 )
• POP_RNG_MED_DESC ( type: esriFieldTypeString, alias: Population Range Desc, length: 20 )
• RD_CNTL_CD ( type: esriFieldTypeString, alias: Rd Control Code, length: 1 )
• RD_CNTL_MED_DESC ( type: esriFieldTypeString, alias: Rd Control Desc, length: 20 )
• REG_ID ( type: esriFieldTypeString, alias: ODOT Region ID, length: 1 )
• DIST_ID ( type: esriFieldTypeString, alias: ODOT District ID, length: 3 )
• TOT_VHCL_CNT ( type: esriFieldTypeInteger, alias: Total Vehicles )
• TOT_FATAL_CNT ( type: esriFieldTypeInteger, alias: Total Deaths )
• TOT_INJ_LVL_A_CNT ( type: esriFieldTypeInteger, alias: Total Serious Injuries )
• TOT_INJ_LVL_B_CNT ( type: esriFieldTypeInteger, alias: Total Moderate Injuries )
• TOT_INJ_LVL_C_CNT ( type: esriFieldTypeInteger, alias: Total Minor Injuries )
• TOT_INJ_CNT ( type: esriFieldTypeInteger, alias: Total Non-Fatal Injuries )
• TOT_UNINJD_AGE00_04_CNT ( type: esriFieldTypeInteger, alias: Total Un-injured Age 00-04 )
• TOT_OCCUP_CNT ( type: esriFieldTypeInteger, alias: Total Vehicle Occupants )
• TOT_UNINJD_PER_CNT ( type: esriFieldTypeInteger, alias: Total Un-injured Persons )
• TOT_PED_CNT ( type: esriFieldTypeInteger, alias: Total Pedestrians )
• TOT_PED_FATAL_CNT ( type: esriFieldTypeInteger, alias: Total Pedestrian Deaths )
• TOT_PED_INJ_CNT ( type: esriFieldTypeInteger, alias: Total Pedestrian Injuries )
• TOT_PEDCYCL_CNT ( type: esriFieldTypeInteger, alias: Total Pedal-cyclists )
• TOT_PEDCYCL_FATAL_CNT ( type: esriFieldTypeInteger, alias: Total Pedal-cyclist Deaths )
• TOT_PEDCYCL_INJ_CNT ( type: esriFieldTypeInteger, alias: Total Pedal-cyclist Injuries )
• TOT_UNKNWN_CNT ( type: esriFieldTypeInteger, alias: Total Unknown Non-Motorists )
• TOT_UNKNWN_FATAL_CNT ( type: esriFieldTypeInteger, alias: Total Unknown Non-Motorist Deaths )
• TOT_UNKNWN_INJ_CNT ( type: esriFieldTypeInteger, alias: Total Unknown Non-Motorist Injured )
• TOT_PER_INVLV_CNT ( type: esriFieldTypeInteger, alias: Total Persons Involved )
• TOT_SFTY_EQUIP_USED_QTY ( type: esriFieldTypeInteger, alias: Total Safety Equip Used )
• TOT_SFTY_EQUIP_UNUSED_QTY ( type: esriFieldTypeInteger, alias: Total Safety Equip Un-used )
• TOT_SFTY_EQUIP_USE_UNKNWN_QTY ( type: esriFieldTypeInteger, alias: Total Safety Equip Unknown if Used )
• CRASH_MO_NO ( type: esriFieldTypeString, alias: Crash Month, length: 2 )
• CRASH_DAY_NO ( type: esriFieldTypeString, alias: Crash Day, length: 2 )
• CRASH_YR_NO ( type: esriFieldTypeString, alias: Crash Year, length: 4 )
• CRASH_WK_DAY_CD ( type: esriFieldTypeString, alias: Day of Week, length: 1 )
• CRASH_CAUSE_1_CD ( type: esriFieldTypeString, alias: Crash Cause 1 Code, length: 20 )
• CRASH_CAUSE_1_LONG_DESC ( type: esriFieldTypeString, alias: Crash Cause 1 Desc, length: 100 )
• CRASH_CAUSE_2_CD ( type: esriFieldTypeString, alias: Crash Cause 2 Code, length: 20 )
• CRASH_CAUSE_2_LONG_DESC ( type: esriFieldTypeString, alias: Crash Cause 2 Desc, length: 100 )
• CRASH_CAUSE_3_CD ( type: esriFieldTypeString, alias: Crash Cause 3 Code, length: 20 )
• CRASH_CAUSE_3_LONG_DESC ( type: esriFieldTypeString, alias: Crash Cause 3 Desc, length: 100 )
• CRASH_EVNT_1_CD ( type: esriFieldTypeString, alias: Crash Event 1 Code, length: 20 )
• CRASH_EVNT_1_LONG_DESC ( type: esriFieldTypeString, alias: Crash Event 1 Desc, length: 100 )
• CRASH_EVNT_2_CD ( type: esriFieldTypeString, alias: Crash Event 2 Code, length: 20 )
• CRASH_EVNT_2_LONG_DESC ( type: esriFieldTypeString, alias: Crash Event 2 Desc, length: 100 )
• CRASH_EVNT_3_CD ( type: esriFieldTypeString, alias: Crash Event 3 Code, length: 20 )
• CRASH_EVNT_3_LONG_DESC ( type: esriFieldTypeString, alias: Crash Event 3 Desc, length: 100 )
• GIS_PRC_DT ( type: esriFieldTypeString, alias: GIS Processing Date, length: 10 )
• EFFECTV_DT ( type: esriFieldTypeString, alias: Effective Date, length: 4 )
• tig_sev_calc ( type: esriFieldTypeInteger, alias: Severity Calculation )
• NEAR_FID ( type: esriFieldTypeInteger, alias: NEAR_FID )
• NEAR_DIST ( type: esriFieldTypeDouble, alias: NEAR_DIST )
• IntersectingStreet1 ( type: esriFieldTypeString, alias: IntersectingStreet1, length: 60 )
• IntersectingStreet2 ( type: esriFieldTypeString, alias: IntersectingStreet2, length: 60 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• CreateUser ( type: esriFieldTypeString, alias: CreateUser, length: 255 )
• CreateDate ( type: esriFieldTypeDate, alias: CreateDate, length: 8 )
• LastEditUser ( type: esriFieldTypeString, alias: LastEditUser, length: 255 )
• LastEditDate ( type: esriFieldTypeDate, alias: LastEditDate, length: 8 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• TIG_JURISDICTION ( type: esriFieldTypeString, alias: Crash Jurisdiction, length: 25 , Coded Values: [PRVT: Private] , [CWS: Clean Water Services] , [WASCO: Washington County] , ...17 more... )
• TIG_INJ_SVRTY_LONG_DESC ( type: esriFieldTypeString, alias: Tig Injury Severity Description, length: 50 )
• TIG_INJ_SVRTY_CD ( type: esriFieldTypeSmallInteger, alias: Tig Injury Severity Code , Range: [1, 9] )

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

  Iteminfo   Thumbnail   Metadata