Name: PSS Line

Display Field: COUNTY_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text: Iowa Department of Transportation

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON

Use Standardized Queries: True

Extent:

XMin: -10749494.7925675
YMin: 4940716.94665
XMax: -10038790.0883245
YMax: 5384923.4478475
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,255,255],"width":1}},"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:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GLOBALID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• DISTRICT (type: esriFieldTypeSmallInteger, alias: District, SQL Type: sqlTypeOther, nullable: false, editable: true)
• COUNTY_NAME (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• ROUTE_SYSTEM (type: esriFieldTypeString, alias: Route System, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ROUTE_NAME (type: esriFieldTypeString, alias: Route Name, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• TRAVELED_WAY (type: esriFieldTypeString, alias: Traveled Way, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• PIN (type: esriFieldTypeString, alias: PIN, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• PROJECT_NUMBER (type: esriFieldTypeString, alias: Project Number, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• ASSIGNED_TO (type: esriFieldTypeString, alias: Assigned To, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 121, nullable: true, editable: true)
• WORK_DESC (type: esriFieldTypeString, alias: Work Description, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• LETTING_FISCAL_YEAR (type: esriFieldTypeSmallInteger, alias: Letting Fiscal Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONTRACT_AWARDED (type: esriFieldTypeDate, alias: Contract Awarded (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CONSTRUCTION_ACTUAL_START (type: esriFieldTypeDate, alias: Construction Actual Start (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PROGRAM_ESTIMATE (type: esriFieldTypeDouble, alias: Program Estimate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AWARDED (type: esriFieldTypeDouble, alias: Awarded, SQL Type: sqlTypeOther, nullable: false, editable: true)
• FINAL_CONTRACT (type: esriFieldTypeDouble, alias: Final Contract, SQL Type: sqlTypeOther, nullable: false, editable: true)
• ABSTRACT (type: esriFieldTypeDate, alias: Abstract (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RCE (type: esriFieldTypeString, alias: RCE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• RCE_ENGINEER (type: esriFieldTypeString, alias: RCE Engineer, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• CONTRACT_ID (type: esriFieldTypeString, alias: Contract ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• CONTRACT_DESCRIPTION (type: esriFieldTypeString, alias: Contract Description, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• CONTRACTOR_ID (type: esriFieldTypeString, alias: Contractor ID, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• CONTRACTOR (type: esriFieldTypeString, alias: Contractor, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• DISTRICT_435 (type: esriFieldTypeString, alias: District 435, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MATERIALS_436 (type: esriFieldTypeString, alias: Materials 436, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• DISTRICT_436 (type: esriFieldTypeString, alias: District 436, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• FINAL_CENTRAL_OFFICE (type: esriFieldTypeString, alias: Final Central Office, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• AS_BUILT (type: esriFieldTypeString, alias: As Built, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• UTILITY_EOT_ASSIGNED_TO (type: esriFieldTypeString, alias: Utility EOT Assigned To, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• RAILROAD_INVOLVED (type: esriFieldTypeString, alias: Railroad Involved, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• RAILROAD_AGREEMENT (type: esriFieldTypeString, alias: Railroad Agreement, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• UKEY (type: esriFieldTypeInteger, alias: UKEY, SQL Type: sqlTypeOther, nullable: false, editable: true)
• FROM_MEASURE (type: esriFieldTypeDouble, alias: From Measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TO_MEASURE (type: esriFieldTypeDouble, alias: To Measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROUTE_ID (type: esriFieldTypeString, alias: Route ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• REST_UPDATED (type: esriFieldTypeDate, alias: Rest Service Last Updated (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• REST_UTC_OFFSET (type: esriFieldTypeString, alias: REST UTC Offset, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• LENGTH_MILE (type: esriFieldTypeDouble, alias: Length (Mile - State Plane), SQL Type: sqlTypeOther, nullable: true, editable: true)
• COUNTY_NUMBER (type: esriFieldTypeDouble, alias: County Number, SQL Type: sqlTypeOther, nullable: false, 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: true)

Templates:

Name: PSS Line
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• COUNTY_NUMBER: 0
• DISTRICT: 0
• AWARDED: 0
• FINAL_CONTRACT: 0
• UKEY: 0

Relationships:

• PSS_BID_ITEMS (0) -- Related To: PSS Bid Items (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/19/2024 11:42:35 PM

Schema Last Edit Date: 11/28/2022 1:37:27 PM

Data Last Edit Date: 4/19/2024 11:42:35 PM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates