Description

more
The TxDOT planned projects service layer is a dataset of roadway construction and maintenance projects that are either currently under construction, or are in some phase of the planning process. Projects are grouped into 4 categories: projects that are currently let (Construction Scheduled); projects in the construct authority (Finalizing for Construction); projects in the develop authority (Under Development); and projects in the initial phases of project development (Long Term Planning). The dataset excludes non-letting projects. It is updated daily and used in the Project Tracker application (http://apps.dot.state.tx.us/apps-cq/project_tracker/) on TxDOT.gov.

Dataset Attributes

  • OBJECTID
    Number
  • ISN
    Number
    64 to 162479
  • CONTROL_SECT_JOB
    Text
    {"value"=>"030510008", "count"=>1} (), {"value"=>"091234197", "count"=>1} (), {"value"=>"059802120", "count"=>1} (), {"value"=>"017803154", "count"=>1} (), {"value"=>"092106304", "count"=>1} (), {"value"=>"354001001", "count"=>1} (), {"value"=>"117701023", "count"=>1} (), {"value"=>"092102321", "count"=>1} (), {"value"=>"092106267", "count"=>1} (), {"value"=>"091139059", "count"=>1} ()
  • DISTRICT_NUMBER
    Number
    1 to 50
  • COUNTY_NUMBER
    Number
    1 to 254
  • HIGHWAY_NUMBER
    Text
    {"value"=>"VA", "count"=>592} (), {"value"=>"CR", "count"=>569} (), {"value"=>"CS", "count"=>479} (), {"value"=>"IH 20", "count"=>237} (), {"value"=>"IH 10", "count"=>213} (), {"value"=>"IH 35", "count"=>206} (), {"value"=>"US 83", "count"=>167} (), {"value"=>"US 59", "count"=>160} (), {"value"=>"US 67", "count"=>128} (), {"value"=>"IH 45", "count"=>121} ()
  • PROJ_LENGTH
    Number
    0.001 to 418.658
  • PROJ_CLASS
    Text
    {"value"=>"SFT", "count"=>2389} (), {"value"=>"SC", "count"=>2151} (), {"value"=>"BR", "count"=>1057} (), {"value"=>"OV", "count"=>1024} (), {"value"=>"RER", "count"=>880} (), {"value"=>"WNF", "count"=>647} (), {"value"=>"MSC", "count"=>519} (), {"value"=>"WF", "count"=>330} (), {"value"=>"BMN", "count"=>307} (), {"value"=>"INC", "count"=>244} ()
  • EST_CONST_COST
    Number
    0 to 989631249
  • TYPE_OF_WORK
    Text
    {"value"=>"SEAL COAT", "count"=>1219} (), {"value"=>"REPLACE BRIDGE AND APPROACHES", "count"=>462} (), {"value"=>"BRIDGE REPLACEMENT", "count"=>213} (), {"value"=>"IMPROVE TRAFFIC SIGNALS", "count"=>204} (), {"value"=>"OVERLAY", "count"=>199} (), {"value"=>"SEAL COAT AND PAVEMENT MARKINGS", "count"=>171} (), {"value"=>"SAFETY TREAT FIXED OBJECTS", "count"=>163} (), {"value"=>"RESURFACE WITH SEAL COAT", "count"=>155} (), {"value"=>"REHABILITATION OF EXISTING ROAD", "count"=>119} (), {"value"=>"UPGRADE BRIDGE AND APPROACH RAILING", "count"=>117} ()
  • LIMITS_FROM
    Text
    {"value"=>"VARIOUS LOCATIONS DISTRICTWIDE", "count"=>57} (), {"value"=>"VARIOUS LOCATIONS", "count"=>54} (), {"value"=>"DISTRICTWIDE", "count"=>50} (), {"value"=>"US 281", "count"=>48} (), {"value"=>"US 84", "count"=>40} (), {"value"=>"IH 35", "count"=>39} (), {"value"=>"US 87", "count"=>38} (), {"value"=>"US 59", "count"=>37} (), {"value"=>"IH 20", "count"=>34} (), {"value"=>"VARIOUS LOCATIONS IN", "count"=>32} ()
  • LIMITS_TO
    Text
    {"value"=>".", "count"=>1813} (), {"value"=>"US 59", "count"=>52} (), {"value"=>"US 67", "count"=>46} (), {"value"=>"IH 35", "count"=>42} (), {"value"=>"IH 10", "count"=>37} (), {"value"=>"US 190", "count"=>36} (), {"value"=>"US 281", "count"=>36} (), {"value"=>"US 82", "count"=>34} (), {"value"=>"US 87", "count"=>34} (), {"value"=>"IH 20", "count"=>31} ()
  • LAYMAN_DESCRIPTION1
    Text
    {"value"=>"SEAL COAT", "count"=>1062} (), {"value"=>"REPLACE BRIDGE AND APPROACHES", "count"=>662} (), {"value"=>"IMPROVE TRAFFIC SIGNALS", "count"=>208} (), {"value"=>"SAFETY TREAT FIXED OBJECTS", "count"=>192} (), {"value"=>"SEAL COAT AND PAVEMENT MARKINGS", "count"=>180} (), {"value"=>"RESURFACE WITH SEAL COAT", "count"=>155} (), {"value"=>"OVERLAY", "count"=>133} (), {"value"=>"SEALCOAT", "count"=>99} (), {"value"=>"SEAL COAT CONSISTING OF A ONE COURSE SURFACE TREATMENT AND", "count"=>96} (), {"value"=>"RESURFACE OF EXISTING HIGHWAY", "count"=>91} ()
  • LAYMAN_DESCRIPTION2
    Text
    {"value"=>"PAVEMENT MARKINGS AND MARKERS", "count"=>96} (), {"value"=>"INTERSECTION", "count"=>77} (), {"value"=>"PAVEMENT MARKERS", "count"=>72} (), {"value"=>"STRIPS", "count"=>59} (), {"value"=>"PAVEMENT MARKINGS", "count"=>46} (), {"value"=>"TREATMENT OR REPLACE GUARDFENCE", "count"=>31} (), {"value"=>"OBJECTS", "count"=>26} (), {"value"=>"CENTERLINE MARKINGS)", "count"=>25} (), {"value"=>"AND BASE", "count"=>20} (), {"value"=>"SHOULDERS AND CENTERLINE", "count"=>16} ()
  • BEG_MILE_POINT
    Number
    -0.039 to 800
  • END_MILE_POINT
    Number
    0 to 806.79
  • DIST_LET_DATE
    Number
    708 to 4008
  • CITY_CODE
    Number
    0 to 80000
  • MPO_CODE
    Number
    0 to 1127
  • CONTROL_SECTION
    Text
    {"value"=>"092102", "count"=>89} (), {"value"=>"091847", "count"=>75} (), {"value"=>"091272", "count"=>59} (), {"value"=>"091512", "count"=>47} (), {"value"=>"090290", "count"=>40} (), {"value"=>"091104", "count"=>33} (), {"value"=>"050003", "count"=>33} (), {"value"=>"091200", "count"=>31} (), {"value"=>"092106", "count"=>31} (), {"value"=>"092406", "count"=>29} ()
  • DISTRICT_NAME
    Text
    {"value"=>"Houston", "count"=>893} (), {"value"=>"Dallas", "count"=>892} (), {"value"=>"Fort Worth", "count"=>657} (), {"value"=>"San Antonio", "count"=>634} (), {"value"=>"Paris", "count"=>605} (), {"value"=>"Austin", "count"=>585} (), {"value"=>"Yoakum", "count"=>568} (), {"value"=>"Lufkin", "count"=>567} (), {"value"=>"Pharr", "count"=>542} (), {"value"=>"Bryan", "count"=>502} ()
  • COUNTY_NAME
    Text
    {"value"=>"Harris", "count"=>453} (), {"value"=>"Dallas", "count"=>317} (), {"value"=>"Tarrant", "count"=>297} (), {"value"=>"Hidalgo", "count"=>265} (), {"value"=>"Bexar", "count"=>262} (), {"value"=>"Travis", "count"=>190} (), {"value"=>"Cameron", "count"=>180} (), {"value"=>"El Paso", "count"=>164} (), {"value"=>"Nueces", "count"=>151} (), {"value"=>"Grayson", "count"=>149} ()
  • UTP_FUNDING_AVAILABLE
    Number
    0 to 33
  • UTP_PRJ_PHASING
    Number
    0 to 16.5
  • UTP_PRJ_READINESS_ENV_CLEARANCE
    Number
    0 to 7
  • UTP_PRJ_READINESS_MINIMAL_ENV
    Number
    0 to 0
  • UTP_PRJ_READINESS_ROW
    Number
    0 to 7
  • UTP_PRJ_READINESS_MINIMAL_ROW
    Number
    0 to 7
  • UTP_PRJ_READINESS_PSE_READY
    Number
    0 to 2.5
  • UTP_STR_GOAL_ALTERNATIVE_MODE
    Number
    0 to 0.5
  • UTP_STR_GOAL_FILLS_GAP
    Number
    0 to 0.5
  • UTP_STR_GOAL_CONNECT
    Number
    0.35 to 4.5
  • UTP_STR_GOAL_TRUNK_FREIGHT
    Number
    0 to 1.5
  • UTP_STR_GOAL_TRUCK_TRAFFIC
    Number
    0 to 1
  • UTP_STR_GOAL_BEST_CLASS_MTP
    Number
    0 to 4.5
  • UTP_STR_GOAL_BEST_CLASS_RTP
    Number
    0 to 4.5
  • UTP_STR_GOAL_BEST_CLASS_COST_PER_VMT
    Number
    1 to 3.5
  • UTP_STR_GOAL_BEST_CLASS_COST_PER_VMT_OVERRIDE
    Number
    0 to 3.5
  • UTP_STR_GOAL_SAFETY_CRASH
    Number
    0 to 3.5
  • UTP_STR_GOAL_SAFETY_FATALITY
    Number
    0 to 3.5
  • UTP_STR_GOAL_SAFETY_OVERRIDE
    Number
    0 to 7
  • UTP_STR_GOAL_CONGESTION
    Number
    1 to 7
  • UTP_STR_GOAL_CONGESTION_OVERRIDE
    Number
    0 to 7
  • UTP_STR_GOAL_ENERGY_SECTOR
    Number
    0 to 1
  • UTP_STR_GOAL_TOP100
    Number
    0 to 1
  • UTP_STR_PRIORITY
    Number
    0 to 2
  • UTP_STRATEGIC_SCORE
    Number
    0 to 95.58823
  • UTP_TOTAL_SCORE
    Number
    0 to 96
  • UTP_TOTAL_PROJECT_COST
    Number
    0 to 1970000000
  • UTP_TOTAL_FUNDING_AVAILABLE
    Number
    1 to 873200001
  • UTP_TOTAL_AUTHORIZED_AMOUNT
    Number
  • NBR_LET_YEAR
    Number
    2010 to 2040
  • NBR_LET_MONTH
    Number
    1 to 12
  • NBR_TOTAL_MONTHS
    Number
    24124 to 24488
  • CRASH_COUNT
    Number
    0 to 9879
  • FATAL_COUNT
    Number
    0 to 57
  • VMT
    Number
    1 to 4752902
  • FC
    Number
    1 to 19
  • INRIX_SPEED_HOUR7
    Number
  • INRIX_SPEED_HOUR17
    Number
  • PRJ_DENSITY
    Number
  • PRJ_AADT
    Number
  • DIST_ENV_STATUS
    Text
  • DIST_ROW_PARCELS
    Number
  • DIST_ROW
    Text
  • DIST_MIN_ROW_For_Construction
    Text
  • DIST_PSE_STATUS
    Text
  • DIST_PRIORITY
    Text
  • DIST_SAFETY_OVERRIDE
    Text
  • DIST_CONGESTION_OVERRIDE
    Text
  • DIST_COST_PER_VMT_OVERRIDE
    Text
  • DIST_ALT_MODE
    Text
  • DIST_FILLS_GAP
    Text
  • DIST_MTP
    Text
  • PRJ_AADT_TRUCK
    Number
  • PRJ_KFAC
    Number
  • PRJ_LANES
    Number
  • LOC_ERROR
    Text
  • TPP_CATEGORY_P2
    Text
  • TPP_WORK_PROGRAM
    Text
  • TPP_PID
    Text
  • TPP_P1_TOTAL
    Number
  • PRJ_STATUS
    Text
  • PRJ_TIER
    Text
  • Shape__Length
    Number

Related Datasets