All Layers and Tables (hpms_v2

Layers:

Layer: HPMS (0)

Name:

Display Field:

Type:

Geometry Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[140,60,102,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
Year_Record (type: esriFieldTypeSmallInteger, alias: Year Record, SQL Type: sqlTypeOther, nullable: true, editable: true)
State_Code (type: esriFieldTypeSmallInteger, alias: State Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
Route_ID (type: esriFieldTypeString, alias: Route Identifier, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
Begin_Point (type: esriFieldTypeDouble, alias: Begin Point, SQL Type: sqlTypeOther, nullable: true, editable: true)
End_Point (type: esriFieldTypeDouble, alias: End Point, SQL Type: sqlTypeOther, nullable: true, editable: true)
F_SYSTEM (type: esriFieldTypeInteger, alias: Functional System, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Interstate], [2: Principal Arterial – Other Freeways and Expressways], [3: Principal Arterial - Other], ... 4 more ...)
COUNTY_CODE (type: esriFieldTypeInteger, alias: County Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
NHS (type: esriFieldTypeInteger, alias: National Highway System, SQL Type: sqlTypeOther, nullable: true, editable: true)
URBAN_CODE (type: esriFieldTypeInteger, alias: Urban Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
FACILITY_TYPE (type: esriFieldTypeInteger, alias: Facility Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: One-Way Roadway], [2: Two-Way Roadway], [4: Ramp], ... 3 more ...)
STRUCTURE_TYPE (type: esriFieldTypeInteger, alias: Structure Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Bridge], [2: Tunnel], [3: Causeway])
ACCESS_CONTROL (type: esriFieldTypeInteger, alias: Access Control, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Full Access Control], [2: Partial Access Control], [3: No Access Control])
OWNERSHIP (type: esriFieldTypeInteger, alias: Ownership Code, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: State Highway Agency], [2: County Highway Agency], [3: Town or Township Highway Agency], ... 24 more ...)
THROUGH_LANES (type: esriFieldTypeInteger, alias: Through Lanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
DIR_TROUGH_LANES (type: esriFieldTypeInteger, alias: Directional Through Lanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
HOV_TYPE (type: esriFieldTypeInteger, alias: High Occupancy Vehicle Operations Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Full-time Managed Lanes], [2: Part-time Managed Lanes], [3: Part-time Manager Lane])
HOV_LANES (type: esriFieldTypeInteger, alias: High Occupancy Vehicle Lanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
PEAK_LANES (type: esriFieldTypeInteger, alias: Peak Lanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
COUNTER_PEAK_LANES (type: esriFieldTypeInteger, alias: Counter-Peak Lanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
TURN_LANES_R (type: esriFieldTypeInteger, alias: Right Turn Lanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
TURN_LANES_L (type: esriFieldTypeInteger, alias: Left Turn Lanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
SPEED_LIMIT (type: esriFieldTypeInteger, alias: Speed Limit, SQL Type: sqlTypeOther, nullable: true, editable: true)
TOL_CHARGED (type: esriFieldTypeInteger, alias: Toll Charged, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Toll charged in one direction only], [2: Toll charged in both directions], [3: No toll charged])
TOLL_ID (type: esriFieldTypeString, alias: Toll ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
TOLL_TYPE (type: esriFieldTypeInteger, alias: Toll Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: This section has toll lanes but no special tolls (e.g., HOT lanes)], [2: This section has HOT lanes], [3: This section has other special tolls])
ROUTE_NUMBER (type: esriFieldTypeInteger, alias: Route Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
ROUTE_NAME (type: esriFieldTypeString, alias: Route Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ROUTE_SIGNING (type: esriFieldTypeInteger, alias: Route Signing, SQL Type: sqlTypeOther, nullable: true, editable: true)
ROUTE_QUALIFIER (type: esriFieldTypeInteger, alias: Route Qualifier, SQL Type: sqlTypeOther, nullable: true, editable: true)
AADT (type: esriFieldTypeInteger, alias: Annual Average Daily Traffic, SQL Type: sqlTypeOther, nullable: true, editable: true)
AADT_SINGLE_UNIT (type: esriFieldTypeInteger, alias: Single-Unit Vehicle AADT, SQL Type: sqlTypeOther, nullable: true, editable: true)
Pct_Peak_Single (type: esriFieldTypeDouble, alias: Percent Peak Single-Unit Trucks and Buses, SQL Type: sqlTypeOther, nullable: true, editable: true)
AADT_COMBINATION (type: esriFieldTypeInteger, alias: Combination Truck AADT, SQL Type: sqlTypeOther, nullable: true, editable: true)
Pct_Peak_Combination (type: esriFieldTypeDouble, alias: Percent Peak Combination Trucks, SQL Type: sqlTypeOther, nullable: true, editable: true)
K_Factor (type: esriFieldTypeDouble, alias: K-factor, SQL Type: sqlTypeOther, nullable: true, editable: true)
Dir_Factor (type: esriFieldTypeDouble, alias: Directional Factor, SQL Type: sqlTypeOther, nullable: true, editable: true)
FUTURE_AADT (type: esriFieldTypeInteger, alias: Future Annual Average Daily Traffic, SQL Type: sqlTypeOther, nullable: true, editable: true)
FUTURE_AADT_YEAR (type: esriFieldTypeDate, alias: Future Annual Average Daily Traffic Year, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SIGNAL_TYPE (type: esriFieldTypeInteger, alias: Signal Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Uncoordinated Fixed Time (may include pre-programmed changes for peak or other time periods)], [2: Uncoordinated Traffic Actuated], [3: Coordinated Progressive (coordinated signals through several intersections)], ... 1 more ...)
Pct_Green_Time (type: esriFieldTypeDouble, alias: Percent Green Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
NUMBER_SIGNALS (type: esriFieldTypeInteger, alias: Number of Signalized Intersections, SQL Type: sqlTypeOther, nullable: true, editable: true)
STOP_SIGNS (type: esriFieldTypeInteger, alias: Number of Stop-Sign Controlled Intersections, SQL Type: sqlTypeOther, nullable: true, editable: true)
AT_GRADE_OTHER (type: esriFieldTypeInteger, alias: Number of Intersections, Type Other, SQL Type: sqlTypeOther, nullable: true, editable: true)
LANE_WIDTH (type: esriFieldTypeInteger, alias: Lane Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
MEDIAN_TYPE (type: esriFieldTypeInteger, alias: Median Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: None], [2: Unprotected], [3: Curbed], ... 4 more ...)
MEDIAN_WIDTH (type: esriFieldTypeInteger, alias: Median Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
SHOULDER_TYPE (type: esriFieldTypeInteger, alias: Shoulder Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: None], [2: Surfaced shoulder exists – bituminous concrete (AC)], [3: Surfaced shoulder exists – Portland Cement Concrete surface (PCC)], ... 4 more ...)
SHOULDER_WIDTH_R (type: esriFieldTypeInteger, alias: Right Shoulder Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
Shoulder_Width_L (type: esriFieldTypeInteger, alias: Left Shoulder Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
Peak_Parking (type: esriFieldTypeInteger, alias: Peak Parking, SQL Type: sqlTypeOther, nullable: true, editable: true)
Widening_Obstacle (type: esriFieldTypeString, alias: Widening Obstacle, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Widening_Potential (type: esriFieldTypeInteger, alias: Widening Potential, SQL Type: sqlTypeOther, nullable: true, editable: true)
Terrain_Type (type: esriFieldTypeInteger, alias: Terrain Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Level], [2: Rolling], [3: Mountainous])
Pct_Pass_Sight (type: esriFieldTypeDouble, alias: Percent Passing Sight Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
IRI (type: esriFieldTypeInteger, alias: International Roughness Index, SQL Type: sqlTypeOther, nullable: true, editable: true)
IRI_YEAR (type: esriFieldTypeDate, alias: International Roughness Index Year, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PSR (type: esriFieldTypeDouble, alias: Present Serviceability Rating, SQL Type: sqlTypeOther, nullable: true, editable: true)
SURFACE_TYPE (type: esriFieldTypeInteger, alias: Surface Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Unpaved], [2: Bituminous], [3: PCP – Jointed Plain Concrete Pavement (includes whitetopping)], ... 8 more ...)
Rutting (type: esriFieldTypeDouble, alias: Rutting, SQL Type: sqlTypeOther, nullable: true, editable: true)
Faulting (type: esriFieldTypeDouble, alias: Faulting, SQL Type: sqlTypeOther, nullable: true, editable: true)
Cracking_Percent (type: esriFieldTypeDouble, alias: Cracking Percent, SQL Type: sqlTypeOther, nullable: true, editable: true)
YEAR_LAST_IMPROVEMENT (type: esriFieldTypeDate, alias: Year of Last Improvement, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Year_Last_Construction (type: esriFieldTypeDate, alias: Year of Last Construction, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Last_Overlay_Thickness (type: esriFieldTypeDouble, alias: Last Overlay Thickness, SQL Type: sqlTypeOther, nullable: true, editable: true)
Thickness_Rigid (type: esriFieldTypeDouble, alias: Thickness Rigid, SQL Type: sqlTypeOther, nullable: true, editable: true)
Thickness_Flexible (type: esriFieldTypeDouble, alias: Thickness Flexible, SQL Type: sqlTypeOther, nullable: true, editable: true)
BASE_TYPE (type: esriFieldTypeInteger, alias: Base Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
Base_Thickness (type: esriFieldTypeDouble, alias: Base Thickness, SQL Type: sqlTypeOther, nullable: true, editable: true)
STRAHNET_TYPE (type: esriFieldTypeInteger, alias: Strategic Highway Network, SQL Type: sqlTypeOther, nullable: true, editable: true)
NN (type: esriFieldTypeInteger, alias: National Truck Network, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Section is on the National Network (NN)], [2: Other State-designated truck route (optional)])
MAINTENANCE_OPERATIONS (type: esriFieldTypeInteger, alias: Maintenance and Operations, SQL Type: sqlTypeOther, nullable: true, editable: true)
Is_Sample (type: esriFieldTypeSmallInteger, alias: Sample, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Not a sample], [1: Sample])
Expansion_Factor (type: esriFieldTypeDouble, alias: Expansion Factor, SQL Type: sqlTypeOther, nullable: true, editable: true)
Sample_ID (type: esriFieldTypeString, alias: Sample Identifier, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
FullIntersection_Code (type: esriFieldTypeSmallInteger, alias: Full Intersection Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
Ownership_T (type: esriFieldTypeString, alias: Ownership Text, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Toll_Charged (type: esriFieldTypeDouble, alias: Toll Charged, SQL Type: sqlTypeOther, nullable: true, editable: true)
Toll_Charged_T (type: esriFieldTypeString, alias: Toll Charged Text, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Route_Number_T (type: esriFieldTypeString, alias: Route Number Text, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Alternative_Route_Name (type: esriFieldTypeString, alias: Alternative Route Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Future_AADT_D (type: esriFieldTypeDate, alias: Future AADT Year, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Curves_A (type: esriFieldTypeDouble, alias: Curve Classification A, SQL Type: sqlTypeOther, nullable: true, editable: true)
Curves_B (type: esriFieldTypeDouble, alias: Curve Classification B, SQL Type: sqlTypeOther, nullable: true, editable: true)
Curves_C (type: esriFieldTypeDouble, alias: Curve Classification C, SQL Type: sqlTypeOther, nullable: true, editable: true)
Curves_D (type: esriFieldTypeDouble, alias: Curve Classification D, SQL Type: sqlTypeOther, nullable: true, editable: true)
Curves_E (type: esriFieldTypeDouble, alias: Curve Classification E, SQL Type: sqlTypeOther, nullable: true, editable: true)
Curves_F (type: esriFieldTypeDouble, alias: Curve Classification F, SQL Type: sqlTypeOther, nullable: true, editable: true)
Grades_A (type: esriFieldTypeDouble, alias: Grade Classification A, SQL Type: sqlTypeOther, nullable: true, editable: true)
Grades_B (type: esriFieldTypeDouble, alias: Grade Classification B, SQL Type: sqlTypeOther, nullable: true, editable: true)
Grades_C (type: esriFieldTypeDouble, alias: Grade Classification C, SQL Type: sqlTypeOther, nullable: true, editable: true)
Grades_D (type: esriFieldTypeDouble, alias: Grade Classification D, SQL Type: sqlTypeOther, nullable: true, editable: true)
Grades_E (type: esriFieldTypeDouble, alias: Grade Classification E, SQL Type: sqlTypeOther, nullable: true, editable: true)
Grades_F (type: esriFieldTypeDouble, alias: Grade Classification F, SQL Type: sqlTypeOther, nullable: true, editable: true)
IRI_D (type: esriFieldTypeDate, alias: International Roughness Index Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Cracking_Length (type: esriFieldTypeDouble, alias: Cracking Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
Year_Last_Improv (type: esriFieldTypeDate, alias: Year of Last Improvement, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Climate_Zone (type: esriFieldTypeDouble, alias: Climate Zone, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Wet-Freeze], [2: Wet-Non-freeze], [3: Dry-Freeze], ... 1 more ...)
Soil_Type (type: esriFieldTypeDouble, alias: Soil Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
Truck (type: esriFieldTypeDouble, alias: National Truck Network, SQL Type: sqlTypeOther, nullable: true, editable: true)
Future_Facility (type: esriFieldTypeDouble, alias: Future National Highway System, SQL Type: sqlTypeOther, nullable: true, editable: true)
Sample_Invalid (type: esriFieldTypeSmallInteger, alias: Sample Invalid, SQL Type: sqlTypeOther, nullable: true, editable: true)
Last_Modified_On (type: esriFieldTypeDate, alias: Last Modified On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Last_Modified_By (type: esriFieldTypeString, alias: Last Modified By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Sample_Begin_Point (type: esriFieldTypeDouble, alias: Sample Begin Point, SQL Type: sqlTypeOther, nullable: true, editable: true)
Sample_End_Point (type: esriFieldTypeDouble, alias: Sample End Point, SQL Type: sqlTypeOther, nullable: true, editable: true)
StateYearKey (type: esriFieldTypeInteger, alias: State Year Key, SQL Type: sqlTypeOther, nullable: true, editable: true)
Dir_Through_Lanes (type: esriFieldTypeDouble, alias: Directional Through Lanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
IRI_T (type: esriFieldTypeString, alias: International Roughness Index Text, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
PSR_T (type: esriFieldTypeString, alias: Present Serviceability Rating Text, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
PSR_D (type: esriFieldTypeDate, alias: Present Serviceability Rating Direction, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Segment_Length (type: esriFieldTypeDouble, alias: Segment Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
AVMT (type: esriFieldTypeDouble, alias: Annual Vehicle Miles Traveled, SQL Type: sqlTypeOther, nullable: true, editable: true)
STUSPS (type: esriFieldTypeString, alias: State USPS code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

All Layers and Tables (hpms_v2_view)

Layers:

Layer: HPMS (0)