{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 1, "name": "NPS_CDS.dbo.ALL_CRASH", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "RTE_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "INCID_NO", "type": "esriFieldTypeString", "alias": "INCID_NO", "length": 16, "domain": null }, { "name": "CASE_NUM", "type": "esriFieldTypeString", "alias": "CASE_NUM", "length": 10, "domain": null }, { "name": "PARK_ALPHA", "type": "esriFieldTypeString", "alias": "PARK_ALPHA", "length": 4, "domain": null }, { "name": "STATE_CODE", "type": "esriFieldTypeString", "alias": "STATE_CODE", "length": 2, "domain": null }, { "name": "CRASH_DATE", "type": "esriFieldTypeDate", "alias": "CRASH_DATE", "length": 8, "domain": null }, { "name": "CRASH_TIME", "type": "esriFieldTypeSmallInteger", "alias": "CRASH_TIME", "domain": null }, { "name": "RTE_NO", "type": "esriFieldTypeString", "alias": "RTE_NO", "length": 15, "domain": null }, { "name": "RTE_NAME", "type": "esriFieldTypeString", "alias": "RTE_NAME", "length": 50, "domain": null }, { "name": "NODE_DIST_FT", "type": "esriFieldTypeDouble", "alias": "NODE_DIST_FT", "domain": null }, { "name": "NODE_DIST_MI", "type": "esriFieldTypeDouble", "alias": "NODE_DIST_MI", "domain": null }, { "name": "NODE_DIR", "type": "esriFieldTypeString", "alias": "NODE_DIR", "length": 1, "domain": null }, { "name": "NODE_NUM", "type": "esriFieldTypeString", "alias": "NODE_NUM", "length": 10, "domain": null }, { "name": "LIGHT", "type": "esriFieldTypeString", "alias": "LIGHT", "length": 2, "domain": null }, { "name": "WEATHER", "type": "esriFieldTypeString", "alias": "WEATHER", "length": 2, "domain": null }, { "name": "CRASH_LOCATION", "type": "esriFieldTypeString", "alias": "CRASH_LOCATION", "length": 2, "domain": null }, { "name": "SURF_COND", "type": "esriFieldTypeString", "alias": "SURF_COND", "length": 2, "domain": null }, { "name": "CRASH_CLASS", "type": "esriFieldTypeString", "alias": "CRASH_CLASS", "length": 2, "domain": null }, { "name": "VEH_COLL", "type": "esriFieldTypeString", "alias": "VEH_COLL", "length": 2, "domain": null }, { "name": "OBJ_STRUCK", "type": "esriFieldTypeString", "alias": "OBJ_STRUCK", "length": 2, "domain": null }, { "name": "ROAD_CHAR", "type": "esriFieldTypeString", "alias": "ROAD_CHAR", "length": 2, "domain": null }, { "name": "CON_FACT1", "type": "esriFieldTypeString", "alias": "CON_FACT1", "length": 3, "domain": null }, { "name": "CON_FACT2", "type": "esriFieldTypeString", "alias": "CON_FACT2", "length": 3, "domain": null }, { "name": "CON_FACT3", "type": "esriFieldTypeString", "alias": "CON_FACT3", "length": 3, "domain": null }, { "name": "CON_FACT4", "type": "esriFieldTypeString", "alias": "CON_FACT4", "length": 3, "domain": null }, { "name": "CON_FACT5", "type": "esriFieldTypeString", "alias": "CON_FACT5", "length": 3, "domain": null }, { "name": "CON_FACT6", "type": "esriFieldTypeString", "alias": "CON_FACT6", "length": 3, "domain": null }, { "name": "HIT_RUN", "type": "esriFieldTypeSmallInteger", "alias": "HIT_RUN", "domain": null }, { "name": "CATEGORY", "type": "esriFieldTypeString", "alias": "CATEGORY", "length": 7, "domain": null }, { "name": "FATALS", "type": "esriFieldTypeSmallInteger", "alias": "FATALS", "domain": null }, { "name": "INJURED", "type": "esriFieldTypeSmallInteger", "alias": "INJURED", "domain": null }, { "name": "PED_FAT", "type": "esriFieldTypeSmallInteger", "alias": "PED_FAT", "domain": null }, { "name": "PED_INJ", "type": "esriFieldTypeSmallInteger", "alias": "PED_INJ", "domain": null }, { "name": "BIKE_FAT", "type": "esriFieldTypeSmallInteger", "alias": "BIKE_FAT", "domain": null }, { "name": "BIKE_INJ", "type": "esriFieldTypeSmallInteger", "alias": "BIKE_INJ", "domain": null }, { "name": "PED", "type": "esriFieldTypeSmallInteger", "alias": "PED", "domain": null }, { "name": "CRASH_YEAR", "type": "esriFieldTypeString", "alias": "CRASH_YEAR", "length": 4, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 250, "domain": null }, { "name": "ZIPFILE", "type": "esriFieldTypeString", "alias": "ZIPFILE", "length": 50, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 100, "domain": null }, { "name": "PHOTOS_TAKEN", "type": "esriFieldTypeSmallInteger", "alias": "PHOTOS_TAKEN", "domain": null }, { "name": "USPP_NPS_VEH_INV", "type": "esriFieldTypeSmallInteger", "alias": "USPP_NPS_VEH_INV", "domain": null }, { "name": "PARK_PTY_DEST", "type": "esriFieldTypeSmallInteger", "alias": "PARK_PTY_DEST", "domain": null }, { "name": "LOCKED_UPDATE", "type": "esriFieldTypeSmallInteger", "alias": "LOCKED_UPDATE", "domain": null }, { "name": "LOCKED_BY_USER", "type": "esriFieldTypeString", "alias": "LOCKED_BY_USER", "length": 40, "domain": null }, { "name": "DATA_SRC", "type": "esriFieldTypeString", "alias": "DATA_SRC", "length": 10, "domain": null }, { "name": "LATITUDE", "type": "esriFieldTypeDouble", "alias": "LATITUDE", "domain": null }, { "name": "LONGITUDE", "type": "esriFieldTypeDouble", "alias": "LONGITUDE", "domain": null }, { "name": "MILEPOST", "type": "esriFieldTypeDouble", "alias": "MILEPOST", "domain": null }, { "name": "IMPORT_DATE", "type": "esriFieldTypeDate", "alias": "IMPORT_DATE", "length": 8, "domain": null }, { "name": "FILE_NAME", "type": "esriFieldTypeString", "alias": "FILE_NAME", "length": 55, "domain": null }, { "name": "SAVE_DATE", "type": "esriFieldTypeDate", "alias": "SAVE_DATE", "length": 8, "domain": null }, { "name": "ROUTE_IDENT", "type": "esriFieldTypeString", "alias": "ROUTE_IDENT", "length": 15, "domain": null }, { "name": "RIP_CYCLE", "type": "esriFieldTypeString", "alias": "RIP_CYCLE", "length": 2, "domain": null }, { "name": "MP_NODE", "type": "esriFieldTypeDouble", "alias": "MP_NODE", "domain": null }, { "name": "SPTL_LOC", "type": "esriFieldTypeSmallInteger", "alias": "SPTL_LOC", "domain": null } ], "indexes": [ { "name": "ALL_ACCIDENT_PK", "fields": "INCID_NO", "isAscending": true, "isUnique": true, "description": "" }, { "name": "ALL_ACCIDENT_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }