Name: NSTRI Local Road HPMS

Display Field: ROADNAME

Type: Table

Geometry Type: N/A

Description: This table consolidates the Non-State Trunk Road Inventory (NSTRI) attributes, route IDs, and from–to measures associated with the All Roads Network of Linear Referenced Data (ARNOLD). It supports the annual HPMS submittal and includes only data elements required for HPMS reporting. The dataset can be dynamically segmented to the ARNOLD using the Route_ID field as the route identifier and the From_Mile and To_Mile fields as the linear referencing measures. The data is updated annually.

Service Item Id: b3d97c6e02dc42a6acc280aa6a21b2b4

Copyright Text: South Dakota Department of Transportation

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

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: true
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: false
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• From_Mile ( type: esriFieldTypeDouble, alias: From_Mile, editable: true, nullable: true, defaultValue: null, modelName: From_Mile )
• To_Mile ( type: esriFieldTypeDouble, alias: To_Mile, editable: true, nullable: true, defaultValue: null, modelName: To_Mile )
• ROADNAME ( type: esriFieldTypeString, alias: ROADNAME, editable: true, nullable: true, length: 35, defaultValue: null, modelName: ROADNAME )
• SURFACE_WIDTH ( type: esriFieldTypeSmallInteger, alias: SURFACE_WIDTH, editable: true, nullable: true, defaultValue: 0, modelName: SURFACE_WIDTH , Range: [0, 99] )
• SURFACE_TYPE ( type: esriFieldTypeSmallInteger, alias: SURFACE_TYPE, editable: true, nullable: true, defaultValue: 0, modelName: SURFACE_TYPE , Coded Values: [0: 0 - Not Attributed] , [1: 1 - Primitive (Trail)] , [2: 2 - Unimproved] , ...5 more... )
• TOTAL_LANES ( type: esriFieldTypeSmallInteger, alias: TOTAL_LANES, editable: true, nullable: true, defaultValue: 0, modelName: TOTAL_LANES , Coded Values: [0: 0 - Not Attributed] , [1: 1 Lane] , [2: 2 Lanes] , ...6 more... )
• THROUGH_LANES ( type: esriFieldTypeSmallInteger, alias: THROUGH_LANES, editable: true, nullable: true, defaultValue: 0, modelName: THROUGH_LANES , Coded Values: [0: 0 - Not Attributed] , [1: 1 Lane] , [2: 2 Lanes] , ...6 more... )
• CURB_SHLDR_DESIG ( type: esriFieldTypeSmallInteger, alias: CURB_SHLDR_DESIG, editable: true, nullable: true, defaultValue: 0, modelName: CURB_SHLDR_DESIG , Coded Values: [0: 0 - Not Attributed] , [1: 1 - Curb on the left and curb on the right] , [2: 2 - Curb on the left and shoulder on the right] , ...7 more... )
• SHOULDER_TYPE ( type: esriFieldTypeSmallInteger, alias: SHOULDER_TYPE, editable: true, nullable: true, defaultValue: 9, modelName: SHOULDER_TYPE , Coded Values: [0: 0 - No Shoulders] , [1: 1 - Earth] , [2: 2 - Gravel or Crushed Stone] , ...3 more... )
• SHOULDER_WIDTH ( type: esriFieldTypeSmallInteger, alias: SHOULDER_WIDTH, editable: true, nullable: true, defaultValue: 0, modelName: SHOULDER_WIDTH , Range: [0, 99] )
• SPEED_LIMIT ( type: esriFieldTypeSmallInteger, alias: SPEED_LIMIT, editable: true, nullable: true, defaultValue: 0, modelName: SPEED_LIMIT , Coded Values: [0: 0 - Not Attributed] , [5: 5 MPH] , [10: 10 MPH] , ...14 more... )
• PARKING ( type: esriFieldTypeSmallInteger, alias: PARKING, editable: true, nullable: true, defaultValue: 0, modelName: PARKING , Coded Values: [0: 0 - Not Attributed] , [1: 1 - Parking allowed on one side] , [2: 2 - Parking allowed on both sides] , ...1 more... )
• TERRAIN ( type: esriFieldTypeSmallInteger, alias: TERRAIN, editable: true, nullable: true, defaultValue: 0, modelName: TERRAIN , Coded Values: [0: 0 - Not Attributed] , [1: 1 - Level] , [2: 2 - Rolling] , ...1 more... )
• MEDIAN_TYPE ( type: esriFieldTypeSmallInteger, alias: MEDIAN_TYPE, editable: true, nullable: true, defaultValue: null, modelName: MEDIAN_TYPE , Coded Values: [0: 0 - Undivided] , [1: 1 - Flush paved median (at least 4 ft in width)] , [2: 2 - Raised median] , ...7 more... )
• ONE_WAY_TWO_WAY ( type: esriFieldTypeSmallInteger, alias: ONE_WAY_TWO_WAY, editable: true, nullable: true, defaultValue: null, modelName: ONE_WAY_TWO_WAY , Coded Values: [0: 0 - One-way] , [1: 1 - Two-way] , [2: 2 - One direction of travel for divided roadways] , ...1 more... )
• ACCESS_CONTROL ( type: esriFieldTypeSmallInteger, alias: ACCESS_CONTROL, editable: true, nullable: true, defaultValue: null, modelName: ACCESS_CONTROL , Coded Values: [0: 0 - Full access control] , [1: 1 - Partial access control] , [2: 2 - No access control] , ...1 more... )
• DATA_CLASS ( type: esriFieldTypeSmallInteger, alias: DATA_CLASS, editable: true, nullable: true, defaultValue: 0, modelName: DATA_CLASS , Coded Values: [0: 0 - Not Attributed] , [1: 1 - State Highway System] , [2: 2 - Rural Road] , ...2 more... )
• COUNTY_CODE ( type: esriFieldTypeSmallInteger, alias: COUNTY_CODE, editable: true, nullable: true, defaultValue: 0, modelName: COUNTY_CODE , Coded Values: [0: 00 - Not Attributed] , [1: 01 - Statewide] , [2: 02 - Aurora] , ...65 more... )
• CITY_CODE ( type: esriFieldTypeString, alias: CITY_CODE, editable: true, nullable: true, length: 3, defaultValue: 999, modelName: CITY_CODE , Coded Values: [999: No City Code] , [AB: AB - Aberdeen] , [AD: AD - Agar] , ...308 more... )
• SDDOT_ID ( type: esriFieldTypeString, alias: SDDOT_ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SDDOT_ID )
• SECT_NUM ( type: esriFieldTypeDouble, alias: SECT_NUM, editable: true, nullable: true, defaultValue: null, modelName: SECT_NUM , Range: [0, 999.99] )
• RUR_URB_DESIG ( type: esriFieldTypeSmallInteger, alias: RUR_URB_DESIG, editable: true, nullable: true, defaultValue: 0, modelName: RUR_URB_DESIG , Coded Values: [0: 0 - Not Attributed] , [1: 1 - Entirely Rural] , [2: 2 - Incorporated place, but not part of a FA Urban Area] , ...2 more... )
• URBAN_AREA ( type: esriFieldTypeSmallInteger, alias: URBAN_AREA, editable: true, nullable: true, defaultValue: 99, modelName: URBAN_AREA , Coded Values: [0: 00 - Not in an Urban Area] , [5: 05 - Aberdeen] , [7: 07 - Belle Fourche] , ...19 more... )
• MPO_AREA ( type: esriFieldTypeSmallInteger, alias: MPO_AREA, editable: true, nullable: true, defaultValue: null, modelName: MPO_AREA , Coded Values: [0: 0 - Not in a MPO area] , [1: 1 - Sioux Falls] , [2: 2 - Rapid City] , ...2 more... )
• LOCAL_SYSTEM ( type: esriFieldTypeSmallInteger, alias: LOCAL_SYSTEM, editable: true, nullable: true, defaultValue: 99, modelName: LOCAL_SYSTEM , Coded Values: [0: 0 - Other Administration] , [3: 3 - County Secondary System] , [4: 4 - County System] , ...4 more... )
• CURRENT_ADT ( type: esriFieldTypeInteger, alias: CURRENT_ADT, editable: true, nullable: true, defaultValue: 0, modelName: CURRENT_ADT , Range: [0, 99999] )
• FEDAID_RT_ADT ( type: esriFieldTypeDouble, alias: FEDAID_RT_ADT, editable: true, nullable: true, defaultValue: 0, modelName: FEDAID_RT_ADT )
• FEDAID_ELIG ( type: esriFieldTypeSmallInteger, alias: FEDAID_ELIG, editable: true, nullable: true, defaultValue: 99, modelName: FEDAID_ELIG , Coded Values: [0: 0 - Non Federal Aid] , [1: 1 - Federal Aid - STP] , [2: 2 - Federal Aid - NHS] , ...5 more... )
• FEDAID_RTNUM ( type: esriFieldTypeSmallInteger, alias: FEDAID_RTNUM, editable: true, nullable: true, defaultValue: 0, modelName: FEDAID_RTNUM , Range: [0, 9999] )
• STATE_ADMIN ( type: esriFieldTypeSmallInteger, alias: STATE_ADMIN, editable: true, nullable: true, defaultValue: 99, modelName: STATE_ADMIN , Coded Values: [0: 0 - No State Administration] , [4: 4 - State Institutional Roads] , [5: 5 - Game, Fish and Parks Roads] , ...2 more... )
• FED_DOMAIN ( type: esriFieldTypeSmallInteger, alias: FED_DOMAIN, editable: true, nullable: true, defaultValue: 99, modelName: FED_DOMAIN , Coded Values: [0: 0 - Not Federally Administrated] , [1: 1 - National Indian Reservation System (BIA)] , [2: 2 - Department of Defense] , ...9 more... )
• RESPRK_DESIG ( type: esriFieldTypeSmallInteger, alias: RESPRK_DESIG, editable: true, nullable: true, defaultValue: 99, modelName: RESPRK_DESIG , Coded Values: [0: 00 - No Reservation and Park] , [1: 01 - Black Hills National Forest] , [2: 02 - Custer National Forest] , ...19 more... )
• FUNC_CLASS ( type: esriFieldTypeSmallInteger, alias: FUNC_CLASS, editable: true, nullable: true, defaultValue: 0, modelName: FUNC_CLASS , Coded Values: [0: 00 - Not Attributed] , [1: 01 - Rural Interstate] , [2: 02 - Rural Other Freeways and Expressways] , ...11 more... )
• YR_ADDED ( type: esriFieldTypeSmallInteger, alias: YR_ADDED, editable: true, nullable: true, defaultValue: null, modelName: YR_ADDED )
• ARC_LENGTH ( type: esriFieldTypeDouble, alias: ARC_LENGTH, editable: true, nullable: true, defaultValue: 0, modelName: ARC_LENGTH , Range: [0, 9999.999] )
• HPMS_SEC_ID ( type: esriFieldTypeString, alias: HPMS_SEC_ID, editable: true, nullable: true, length: 12, defaultValue: null, modelName: HPMS_SEC_ID )
• ROADNAME_ALIAS ( type: esriFieldTypeString, alias: ROADNAME_ALIAS, editable: true, nullable: true, length: 35, defaultValue: null, modelName: ROADNAME_ALIAS )
• CRITICAL_FREIGHT ( type: esriFieldTypeSmallInteger, alias: CRITICAL_FREIGHT, editable: true, nullable: true, defaultValue: null, modelName: CRITICAL_FREIGHT , Coded Values: [0: 0 - None] , [1: 1 - Preferential Truck Network Only] , [4: 4 - Preferential Truck Network / Critical Urban Freight Corridor] , ...3 more... )
• Route_ID ( type: esriFieldTypeString, alias: Route_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Route_ID )

Templates:

• Name: NSTRI Local Road HPMS
  Description:
  Prototype:
  CRITICAL_FREIGHT: null
  Route_ID: null
  From_Mile: null
  To_Mile: null
  ROADNAME: null
  SURFACE_WIDTH: 0
  SURFACE_TYPE: 0
  TOTAL_LANES: 0
  THROUGH_LANES: 0
  CURB_SHLDR_DESIG: 0
  SHOULDER_TYPE: 9
  SHOULDER_WIDTH: 0
  SPEED_LIMIT: 0
  PARKING: 0
  TERRAIN: 0
  MEDIAN_TYPE: null
  ONE_WAY_TWO_WAY: null
  ACCESS_CONTROL: null
  DATA_CLASS: 0
  COUNTY_CODE: 0
  CITY_CODE: 999
  SDDOT_ID: null
  SECT_NUM: null
  RUR_URB_DESIG: 0
  URBAN_AREA: 99
  MPO_AREA: null
  LOCAL_SYSTEM: 99
  CURRENT_ADT: 0
  FEDAID_RT_ADT: 0
  FEDAID_ELIG: 99
  FEDAID_RTNUM: 0
  STATE_ADMIN: 99
  FED_DOMAIN: 99
  RESPRK_DESIG: 99
  FUNC_CLASS: 0
  YR_ADDED: null
  ARC_LENGTH: 0
  HPMS_SEC_ID: null
  ROADNAME_ALIAS: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata