Name: PSS Public Bid Point

Display Field: COUNTY_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

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, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -10744248.2207063
YMin: 4949551.90099141
XMax: -10038675.2614155
YMax: 5384877.71074436
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,255,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: false

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_NUMBER (type: esriFieldTypeDouble, alias: County Number, SQL Type: sqlTypeOther, nullable: false, editable: true)
• COUNTY_NAME (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 13, 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: false, editable: true)
• DESIGN_NO (type: esriFieldTypeString, alias: Design Number, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• DESIGN_NO_COUNTY (type: esriFieldTypeString, alias: Design Number County, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• DESIGN_NO_DESC (type: esriFieldTypeString, alias: Design Number Description, SQL Type: sqlTypeOther, length: 182, nullable: true, editable: true)
• STATION_NO (type: esriFieldTypeString, alias: Station Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• EXISTING_FHWA_NO (type: esriFieldTypeString, alias: Existing FHWA Number, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• REPLACEMENT_FHWA_NO (type: esriFieldTypeString, alias: Replacment FHWA Number, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• MAINTENANCE_NO (type: esriFieldTypeString, alias: Maintenance Number, SQL Type: sqlTypeOther, length: 10, 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: Contract 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 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)
• ROUTE_ID (type: esriFieldTypeString, alias: Route ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• FROM_MEASURE (type: esriFieldTypeDouble, alias: PSS From Measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TO_MEASURE (type: esriFieldTypeDouble, alias: PSS To Measure, SQL Type: sqlTypeOther, 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)
• GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: PSS Public Bid Point
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• DISTRICT: 0
• COUNTY_NUMBER: 0
• WORK_DESC:
• 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: 1/28/2026 1:30:15 AM

Schema Last Edit Date: 11/28/2022 2:23:13 PM

Data Last Edit Date: 1/28/2026 1:30:15 AM

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