Name: NPS_CDS.dbo.ALL_CRASH
Display Field: RTE_NAME
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: null
Default Visibility: false
MaxRecordCount: 2000
MaxSelectionCount: 0
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Feature Draw Order:
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