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 160824
  • CONTROL_SECT_JOB
    Text
    {"value"=>"091234197", "count"=>1} (), {"value"=>"030510008", "count"=>1} (), {"value"=>"059802120", "count"=>1} (), {"value"=>"092106304", "count"=>1} (), {"value"=>"017803154", "count"=>1} (), {"value"=>"354001001", "count"=>1} (), {"value"=>"185001014", "count"=>1} (), {"value"=>"117701023", "count"=>1} (), {"value"=>"092102321", "count"=>1} (), {"value"=>"092106267", "count"=>1} ()
  • DISTRICT_NUMBER
    Number
    1 to 50
  • COUNTY_NUMBER
    Number
    1 to 254
  • HIGHWAY_NUMBER
    Text
    {"value"=>"CR", "count"=>633} (), {"value"=>"VA", "count"=>605} (), {"value"=>"CS", "count"=>517} (), {"value"=>"IH 20", "count"=>247} (), {"value"=>"IH 10", "count"=>230} (), {"value"=>"IH 35", "count"=>229} (), {"value"=>"US 83", "count"=>189} (), {"value"=>"US 59", "count"=>174} (), {"value"=>"US 67", "count"=>147} (), {"value"=>"US 69", "count"=>130} ()
  • PROJ_LENGTH
    Number
    0.001 to 418.658
  • PROJ_CLASS
    Text
    {"value"=>"SC", "count"=>2848} (), {"value"=>"SFT", "count"=>2702} (), {"value"=>"OV", "count"=>1173} (), {"value"=>"BR", "count"=>1135} (), {"value"=>"MSC", "count"=>1019} (), {"value"=>"RER", "count"=>947} (), {"value"=>"WNF", "count"=>649} (), {"value"=>"WF", "count"=>323} (), {"value"=>"BMN", "count"=>307} (), {"value"=>"RES", "count"=>251} ()
  • EST_CONST_COST
    Number
    0 to 989631249
  • TYPE_OF_WORK
    Text
    {"value"=>"SEAL COAT", "count"=>1638} (), {"value"=>"REPLACE BRIDGE AND APPROACHES", "count"=>511} (), {"value"=>"OVERLAY", "count"=>238} (), {"value"=>"BRIDGE REPLACEMENT", "count"=>235} (), {"value"=>"IMPROVE TRAFFIC SIGNALS", "count"=>224} (), {"value"=>"SEAL COAT AND PAVEMENT MARKINGS", "count"=>201} (), {"value"=>"RESURFACE WITH SEAL COAT", "count"=>186} (), {"value"=>"SAFETY TREAT FIXED OBJECTS", "count"=>172} (), {"value"=>"SEALCOAT", "count"=>149} (), {"value"=>"UPGRADE BRIDGE AND APPROACH RAILING", "count"=>147} ()
  • LIMITS_FROM
    Text
    {"value"=>"VARIOUS LOCATIONS DISTRICTWIDE", "count"=>53} (), {"value"=>"VARIOUS LOCATIONS", "count"=>50} (), {"value"=>"US 59", "count"=>49} (), {"value"=>"DISTRICTWIDE", "count"=>48} (), {"value"=>"US 281", "count"=>47} (), {"value"=>"US 87", "count"=>45} (), {"value"=>"US 84", "count"=>44} (), {"value"=>"US 82", "count"=>39} (), {"value"=>"IH 35", "count"=>38} (), {"value"=>"IH 20", "count"=>37} ()
  • LIMITS_TO
    Text
    {"value"=>".", "count"=>1932} (), {"value"=>"US 59", "count"=>59} (), {"value"=>"US 67", "count"=>57} (), {"value"=>"IH 35", "count"=>41} (), {"value"=>"IH 10", "count"=>40} (), {"value"=>"US 87", "count"=>40} (), {"value"=>"US 82", "count"=>38} (), {"value"=>"US 190", "count"=>38} (), {"value"=>"US 281", "count"=>34} (), {"value"=>"US 84", "count"=>33} ()
  • LAYMAN_DESCRIPTION1
    Text
    {"value"=>"SEAL COAT", "count"=>1431} (), {"value"=>"REPLACE BRIDGE AND APPROACHES", "count"=>723} (), {"value"=>"IMPROVE TRAFFIC SIGNALS", "count"=>227} (), {"value"=>"SEAL COAT AND PAVEMENT MARKINGS", "count"=>211} (), {"value"=>"SAFETY TREAT FIXED OBJECTS", "count"=>207} (), {"value"=>"RESURFACE WITH SEAL COAT", "count"=>185} (), {"value"=>"OVERLAY", "count"=>163} (), {"value"=>"SEALCOAT", "count"=>143} (), {"value"=>"SEAL COAT CONSISTING OF A ONE COURSE SURFACE TREATMENT AND", "count"=>133} (), {"value"=>"RESURFACE OF EXISTING HIGHWAY", "count"=>114} ()
  • LAYMAN_DESCRIPTION2
    Text
    {"value"=>"PAVEMENT MARKINGS AND MARKERS", "count"=>134} (), {"value"=>"INTERSECTION", "count"=>75} (), {"value"=>"STRIPS", "count"=>63} (), {"value"=>"PAVEMENT MARKINGS", "count"=>51} (), {"value"=>"TREATMENT OR REPLACE GUARDFENCE", "count"=>37} (), {"value"=>"PAVEMENT MARKERS", "count"=>26} (), {"value"=>"OBJECTS", "count"=>26} (), {"value"=>"CENTERLINE MARKINGS)", "count"=>25} (), {"value"=>"AND BASE", "count"=>22} (), {"value"=>"TEXTURING", "count"=>21} ()
  • 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"=>92} (), {"value"=>"091847", "count"=>76} (), {"value"=>"091272", "count"=>62} (), {"value"=>"091512", "count"=>48} (), {"value"=>"092406", "count"=>37} (), {"value"=>"091200", "count"=>36} (), {"value"=>"091104", "count"=>35} (), {"value"=>"050003", "count"=>32} (), {"value"=>"092106", "count"=>32} (), {"value"=>"090290", "count"=>30} ()
  • DISTRICT_NAME
    Text
    {"value"=>"Dallas", "count"=>963} (), {"value"=>"Houston", "count"=>929} (), {"value"=>"Fort Worth", "count"=>707} (), {"value"=>"Austin", "count"=>694} (), {"value"=>"Paris", "count"=>692} (), {"value"=>"San Antonio", "count"=>685} (), {"value"=>"Lufkin", "count"=>649} (), {"value"=>"Pharr", "count"=>570} (), {"value"=>"Atlanta", "count"=>568} (), {"value"=>"Yoakum", "count"=>564} ()
  • COUNTY_NAME
    Text
    {"value"=>"Harris", "count"=>446} (), {"value"=>"Dallas", "count"=>326} (), {"value"=>"Tarrant", "count"=>302} (), {"value"=>"Hidalgo", "count"=>287} (), {"value"=>"Bexar", "count"=>269} (), {"value"=>"Travis", "count"=>213} (), {"value"=>"Cameron", "count"=>184} (), {"value"=>"El Paso", "count"=>175} (), {"value"=>"Nueces", "count"=>164} (), {"value"=>"Grayson", "count"=>163} ()
  • 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 98.52941
  • UTP_TOTAL_SCORE
    Number
    0 to 96
  • UTP_TOTAL_PROJECT_COST
    Number
    0 to 1635794506
  • UTP_TOTAL_FUNDING_AVAILABLE
    Number
    1 to 856500001
  • 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 4140536
  • 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