Name: NPS_CDS.dbo.ALL_CRASH

Display Field: RTE_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• INCID_NO ( type: esriFieldTypeString, alias: INCID_NO, length: 16 )
• CASE_NUM ( type: esriFieldTypeString, alias: CASE_NUM, length: 10 )
• PARK_ALPHA ( type: esriFieldTypeString, alias: PARK_ALPHA, length: 4 )
• STATE_CODE ( type: esriFieldTypeString, alias: STATE_CODE, length: 2 )
• CRASH_DATE ( type: esriFieldTypeDate, alias: CRASH_DATE, length: 8 )
• CRASH_TIME ( type: esriFieldTypeSmallInteger, alias: CRASH_TIME )
• RTE_NO ( type: esriFieldTypeString, alias: RTE_NO, length: 15 )
• RTE_NAME ( type: esriFieldTypeString, alias: RTE_NAME, length: 50 )
• NODE_DIST_FT ( type: esriFieldTypeDouble, alias: NODE_DIST_FT )
• NODE_DIST_MI ( type: esriFieldTypeDouble, alias: NODE_DIST_MI )
• NODE_DIR ( type: esriFieldTypeString, alias: NODE_DIR, length: 1 )
• NODE_NUM ( type: esriFieldTypeString, alias: NODE_NUM, length: 10 )
• LIGHT ( type: esriFieldTypeString, alias: LIGHT, length: 2 )
• WEATHER ( type: esriFieldTypeString, alias: WEATHER, length: 2 )
• CRASH_LOCATION ( type: esriFieldTypeString, alias: CRASH_LOCATION, length: 2 )
• SURF_COND ( type: esriFieldTypeString, alias: SURF_COND, length: 2 )
• CRASH_CLASS ( type: esriFieldTypeString, alias: CRASH_CLASS, length: 2 )
• VEH_COLL ( type: esriFieldTypeString, alias: VEH_COLL, length: 2 )
• OBJ_STRUCK ( type: esriFieldTypeString, alias: OBJ_STRUCK, length: 2 )
• ROAD_CHAR ( type: esriFieldTypeString, alias: ROAD_CHAR, length: 2 )
• CON_FACT1 ( type: esriFieldTypeString, alias: CON_FACT1, length: 3 )
• CON_FACT2 ( type: esriFieldTypeString, alias: CON_FACT2, length: 3 )
• CON_FACT3 ( type: esriFieldTypeString, alias: CON_FACT3, length: 3 )
• CON_FACT4 ( type: esriFieldTypeString, alias: CON_FACT4, length: 3 )
• CON_FACT5 ( type: esriFieldTypeString, alias: CON_FACT5, length: 3 )
• CON_FACT6 ( type: esriFieldTypeString, alias: CON_FACT6, length: 3 )
• HIT_RUN ( type: esriFieldTypeSmallInteger, alias: HIT_RUN )
• CATEGORY ( type: esriFieldTypeString, alias: CATEGORY, length: 7 )
• FATALS ( type: esriFieldTypeSmallInteger, alias: FATALS )
• INJURED ( type: esriFieldTypeSmallInteger, alias: INJURED )
• PED_FAT ( type: esriFieldTypeSmallInteger, alias: PED_FAT )
• PED_INJ ( type: esriFieldTypeSmallInteger, alias: PED_INJ )
• BIKE_FAT ( type: esriFieldTypeSmallInteger, alias: BIKE_FAT )
• BIKE_INJ ( type: esriFieldTypeSmallInteger, alias: BIKE_INJ )
• PED ( type: esriFieldTypeSmallInteger, alias: PED )
• CRASH_YEAR ( type: esriFieldTypeString, alias: CRASH_YEAR, length: 4 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 250 )
• ZIPFILE ( type: esriFieldTypeString, alias: ZIPFILE, length: 50 )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 100 )
• PHOTOS_TAKEN ( type: esriFieldTypeSmallInteger, alias: PHOTOS_TAKEN )
• USPP_NPS_VEH_INV ( type: esriFieldTypeSmallInteger, alias: USPP_NPS_VEH_INV )
• PARK_PTY_DEST ( type: esriFieldTypeSmallInteger, alias: PARK_PTY_DEST )
• LOCKED_UPDATE ( type: esriFieldTypeSmallInteger, alias: LOCKED_UPDATE )
• LOCKED_BY_USER ( type: esriFieldTypeString, alias: LOCKED_BY_USER, length: 40 )
• DATA_SRC ( type: esriFieldTypeString, alias: DATA_SRC, length: 10 )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE )
• MILEPOST ( type: esriFieldTypeDouble, alias: MILEPOST )
• IMPORT_DATE ( type: esriFieldTypeDate, alias: IMPORT_DATE, length: 8 )
• FILE_NAME ( type: esriFieldTypeString, alias: FILE_NAME, length: 55 )
• SAVE_DATE ( type: esriFieldTypeDate, alias: SAVE_DATE, length: 8 )
• ROUTE_IDENT ( type: esriFieldTypeString, alias: ROUTE_IDENT, length: 15 )
• RIP_CYCLE ( type: esriFieldTypeString, alias: RIP_CYCLE, length: 2 )
• MP_NODE ( type: esriFieldTypeDouble, alias: MP_NODE )
• SPTL_LOC ( type: esriFieldTypeSmallInteger, alias: SPTL_LOC )

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

  Iteminfo   Thumbnail   Metadata