Name: IH20_Projects

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• Study_Subarea (type: esriFieldTypeString, alias: Study_Subarea, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DISTRICT (type: esriFieldTypeString, alias: DISTRICT, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PROJECT_NAME (type: esriFieldTypeString, alias: PROJECT NAME, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CONTROLLING_PROJECT_ID (type: esriFieldTypeString, alias: CONTROLLING PROJECT ID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CONTROL_SECTION_JOB (type: esriFieldTypeString, alias: CONTROL SECTION JOB, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FISCAL_YEAR (type: esriFieldTypeInteger, alias: FISCAL YEAR, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• LET_SCHEDULE_FISCAL_YEAR (type: esriFieldTypeInteger, alias: LET SCHEDULE FISCAL YEAR, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• HIGHWAY (type: esriFieldTypeString, alias: HIGHWAY, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SHORT_DESCRIPTION (type: esriFieldTypeString, alias: SHORT DESCRIPTION, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PROJECT_DESCRIPTION (type: esriFieldTypeString, alias: PROJECT DESCRIPTION, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• LIMITS_FROM (type: esriFieldTypeString, alias: LIMITS FROM, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• LIMITS_TO (type: esriFieldTypeString, alias: LIMITS TO, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• TYPE_OF_WORK (type: esriFieldTypeString, alias: TYPE OF WORK, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CONSTRUCTION_ESTIMATE (type: esriFieldTypeInteger, alias: CONSTRUCTION ESTIMATE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ENGINEERS_ESTIMATE_AMOUNT (type: esriFieldTypeInteger, alias: ENGINEERS ESTIMATE AMOUNT, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• PROJECT_STAGE (type: esriFieldTypeString, alias: PROJECT STAGE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PROJECT_STATUS (type: esriFieldTypeString, alias: PROJECT STATUS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PROJECT_TYPE (type: esriFieldTypeString, alias: PROJECT TYPE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PROJECT_SUBTYPE (type: esriFieldTypeString, alias: PROJECT SUBTYPE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PROJECT_CLASS (type: esriFieldTypeString, alias: PROJECT CLASS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• EXISTING_LENGTH (type: esriFieldTypeDouble, alias: EXISTING LENGTH, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• FROM_DFO (type: esriFieldTypeDouble, alias: FROM DFO, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• TO_DFO (type: esriFieldTypeDouble, alias: TO DFO, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• NHS_FLAG (type: esriFieldTypeString, alias: NHS FLAG, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FUNCTIONAL_CLASS (type: esriFieldTypeInteger, alias: FUNCTIONAL CLASS, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ENERGY_SECTOR (type: esriFieldTypeString, alias: ENERGY SECTOR, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• TEXAS_TRUNK_SYSTEM_TYPE (type: esriFieldTypeString, alias: TEXAS TRUNK SYSTEM TYPE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DEPARTMENT_INITIATIVES (type: esriFieldTypeString, alias: DEPARTMENT INITIATIVES, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Plan_Link (type: esriFieldTypeString, alias: Plan_Link, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• I_20_Project_Group (type: esriFieldTypeString, alias: I-20 Project Group, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• I_20_Project_Type (type: esriFieldTypeString, alias: I-20 Project Type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Funding (type: esriFieldTypeInteger, alias: Funding, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Length_Calc (type: esriFieldTypeDouble, alias: Length_Calc, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Funding_Per_ConstEst (type: esriFieldTypeDouble, alias: Funding_Per_ConstEst, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Funding_Status (type: esriFieldTypeString, alias: Funding_Status, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CSJ_Join (type: esriFieldTypeInteger, alias: CSJ_Join, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• CSJ_Text_Join (type: esriFieldTypeString, alias: CSJ_Text_Join, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/28/2021 11:04:50 PM

Schema Last Edit Date: 1/28/2021 11:04:50 PM

Data Last Edit Date: 1/28/2021 11:04:50 PM

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