Layer: TxDOT_Projects_STIP

View In: Map Viewer

Name: TxDOT_Projects_STIP_JOIN

Display Field: DISTRICT_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"PT_PHASE","uniqueValueGroups":[{"heading":"Project Status","classes":[{"label":"Construction begins in 5 to 10 years","description":"Construction begins in 5 to 10 years","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[128,205,193,255],"width":3},"values":[["Construction begins in 5 to 10 years"]]},{"label":"Construction begins within 4 years","description":"Construction begins within 4 years","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[253,174,97,255],"width":3},"values":[["Construction begins within 4 years"]]},{"label":"Construction underway or begins soon","description":"Construction underway or begins soon","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[215,25,28,255],"width":3},"values":[["Construction underway or begins soon"]]},{"label":"Planning, 10+ years","description":"Planning, 10+ years","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[169,183,204,255],"width":3},"values":[["Planning, 10+ years"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[128,205,193,255],"width":3},"value":"Construction begins in 5 to 10 years","label":"Construction begins in 5 to 10 years"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[253,174,97,255],"width":3},"value":"Construction begins within 4 years","label":"Construction begins within 4 years"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[215,25,28,255],"width":3},"value":"Construction underway or begins soon","label":"Construction underway or begins soon"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[169,183,204,255],"width":3},"value":"Planning, 10+ years","label":"Planning, 10+ years"}],"fieldDelimiter":";","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[246,187,252,255],"toColor":[246,187,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[195,252,179,255],"toColor":[195,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,211,192,255],"toColor":[252,211,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,230,252,255],"toColor":[182,230,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,252,228,255],"toColor":[204,252,228,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,240,179,255],"toColor":[252,240,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[194,196,252,255],"toColor":[194,196,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,189,209,255],"toColor":[252,189,209,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[232,252,204,255],"toColor":[232,252,204,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[248,212,252,255],"toColor":[248,212,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[215,251,252,255],"toColor":[215,251,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[207,217,252,255],"toColor":[207,217,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,243,207,255],"toColor":[252,243,207,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field: PT_PHASE

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
CONTROL_SECT_JOB (type: esriFieldTypeString, alias: Control Sections, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
DISTRICT_NUMBER (type: esriFieldTypeDouble, alias: District Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
COUNTY_NUMBER (type: esriFieldTypeDouble, alias: County Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
HIGHWAY_NUMBER (type: esriFieldTypeString, alias: Highway Number, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
PROJ_CLASS (type: esriFieldTypeString, alias: Project Class, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
TYPE_OF_WORK (type: esriFieldTypeString, alias: Type of Work, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
LIMITS_FROM (type: esriFieldTypeString, alias: Limits From, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
LIMITS_TO (type: esriFieldTypeString, alias: Limits To, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
BEG_MILE_POINT (type: esriFieldTypeDouble, alias: Beginning Mile Point, SQL Type: sqlTypeOther, nullable: true, editable: true)
END_MILE_POINT (type: esriFieldTypeDouble, alias: End Mile Point, SQL Type: sqlTypeOther, nullable: true, editable: true)
DIST_LET_DATE (type: esriFieldTypeDouble, alias: District Let Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
TRUNK_SYS_FLAG (type: esriFieldTypeString, alias: Trunk System Flag, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
FREIGHT (type: esriFieldTypeString, alias: Freight, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
ENERGY (type: esriFieldTypeString, alias: Energy, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
PROJ_LENGTH (type: esriFieldTypeDouble, alias: Project Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
RAIL_COORDINATION (type: esriFieldTypeString, alias: Rail Coordination, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
ACTUAL_LET_DATE (type: esriFieldTypeDouble, alias: Actual Let Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
CONTROL_SECTION (type: esriFieldTypeString, alias: Control Section, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
DISTRICT_NAME (type: esriFieldTypeString, alias: District Name, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
COUNTY_NAME (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
PT_TOP100 (type: esriFieldTypeSmallInteger, alias: PT Top 100, SQL Type: sqlTypeOther, nullable: true, editable: true)
PT_PHASE (type: esriFieldTypeString, alias: Project Status, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
TPP_WORK_PROGRAM (type: esriFieldTypeString, alias: TPP Work Program, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
PRJ_TIER (type: esriFieldTypeString, alias: PRJ Tier, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
PRJ_UTP (type: esriFieldTypeSmallInteger, alias: PRJ UTP, SQL Type: sqlTypeOther, nullable: true, editable: true)
PRJ_UTP_TxC (type: esriFieldTypeString, alias: PRJ_UTP_TxC, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
STATE_HSE_NBR (type: esriFieldTypeString, alias: STATE HOUSE, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
US_HSE_NBR (type: esriFieldTypeString, alias: US HOUSE, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
STATE_SEN_NBR (type: esriFieldTypeString, alias: STATE SENATE, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
PROJ_ESTMTD_LET_D (type: esriFieldTypeDate, alias: PROJ_ESTMTD_LET_D, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
COMMISSION_AWARD_OF_CONTRACT (type: esriFieldTypeDate, alias: COMMISSION_AWARD_OF_CONTRACT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
EST_CONSTRUCTION_COST (type: esriFieldTypeDouble, alias: EST_CONSTRUCTION_COST, SQL Type: sqlTypeOther, nullable: true, editable: true)
LET_TYPE_CD (type: esriFieldTypeString, alias: LET_TYPE_CD, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
LET_TYPE_DSCR (type: esriFieldTypeString, alias: LET_TYPE_DSCR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
MPO_NM (type: esriFieldTypeString, alias: MPO_NM, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
CSJ_TEXT (type: esriFieldTypeString, alias: CSJ_TEXT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
NHS_FLAG (type: esriFieldTypeString, alias: NHS_FLAG, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
PROJECT_ID (type: esriFieldTypeString, alias: PROJECT_ID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
PROJ_STG (type: esriFieldTypeString, alias: PROJ_STG, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
PROJ_STAT (type: esriFieldTypeString, alias: PROJ_STAT, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
ESTMTD_FISCAL_YR (type: esriFieldTypeInteger, alias: ESTMTD_FISCAL_YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
OBJECTID_1 (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESTIP_PROJECT_ID (type: esriFieldTypeInteger, alias: ESTIP PROJECT ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
CSJ (type: esriFieldTypeInteger, alias: CSJ, SQL Type: sqlTypeOther, nullable: true, editable: true)
MPO_PROJECT_NUMBER (type: esriFieldTypeString, alias: MPO PROJECT NUMBER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DISTRICT (type: esriFieldTypeString, alias: DISTRICT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
MPO (type: esriFieldTypeString, alias: MPO, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
HIGHWAY_NUMBER_1 (type: esriFieldTypeString, alias: HIGHWAY NUMBER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CITY (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TIP_FY (type: esriFieldTypeInteger, alias: TIP FY, SQL Type: sqlTypeOther, nullable: true, editable: true)
PhC (type: esriFieldTypeString, alias: PhC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PhE (type: esriFieldTypeString, alias: PhE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PhE_ENV (type: esriFieldTypeString, alias: PhE:ENV, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PhE_ENG (type: esriFieldTypeString, alias: PhE:ENG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PhR (type: esriFieldTypeString, alias: PhR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PhR_ACQ (type: esriFieldTypeString, alias: PhR:ACQ, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PhR_UTL (type: esriFieldTypeString, alias: PhR:UTL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PhT (type: esriFieldTypeString, alias: PhT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
STIP (type: esriFieldTypeString, alias: STIP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
REVISION (type: esriFieldTypeString, alias: REVISION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TIMESTAMP (type: esriFieldTypeDate, alias: TIMESTAMP, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PROJECT_SPONSOR (type: esriFieldTypeString, alias: PROJECT SPONSOR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
MTP_REFERENCE (type: esriFieldTypeString, alias: MTP REFERENCE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
LIMITS_FROM_1 (type: esriFieldTypeString, alias: LIMITS FROM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
LIMITS_TO_1 (type: esriFieldTypeString, alias: LIMITS TO, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DESCRIPTION (type: esriFieldTypeString, alias: DESCRIPTION, SQL Type: sqlTypeOther, length: 265, nullable: true, editable: true)
REMARKS (type: esriFieldTypeString, alias: REMARKS, SQL Type: sqlTypeOther, length: 265, nullable: true, editable: true)
PROJECT_HISTORY (type: esriFieldTypeString, alias: PROJECT HISTORY, SQL Type: sqlTypeOther, length: 277, nullable: true, editable: true)
CSJ_TEXT_1 (type: esriFieldTypeString, alias: CSJ Text, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
ProjMatchYN (type: esriFieldTypeString, alias: Project Match, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

PT_PHASE: Construction begins in 5 to 10 years

PT_PHASE: Construction begins within 4 years

PT_PHASE: Construction underway or begins soon

PT_PHASE: Planning, 10+ years

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/16/2025 2:22:48 PM

Schema Last Edit Date: 5/16/2025 2:22:48 PM

Data Last Edit Date: 5/16/2025 2:22:48 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat

Layer: TxDOT_Projects_STIP_JOIN (ID:95)