National Park Service GIS Data Services Directory
JSON

Layer: NPS_CDS.dbo.ALL_CRASH (ID: 1)

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