Name: Active Projects

Display Field: PRONAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Has Views: true

Source Schema Changes Allowed: true

Views

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:

XMin: 626166.480569746
YMin: 26359196.2554573
XMax: 1090252.11430658
YMax: 26984124.2834859
Spatial Reference: 102707 (3421)

Drawing Info:

{"renderer":{"authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[244,252,194,255],"toColor":[244,252,194,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,179,252,255],"toColor":[179,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,188,255],"toColor":[252,179,188,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[197,240,252,255],"toColor":[197,240,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,244,255],"toColor":[252,184,244,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,227,212,255],"toColor":[252,227,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,252,223,255],"toColor":[184,252,223,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[220,215,252,255],"toColor":[220,215,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[192,252,184,255],"toColor":[192,252,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,234,255],"toColor":[252,212,234,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[217,179,252,255],"toColor":[217,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,216,255],"toColor":[252,179,216,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,217,252,255],"toColor":[179,217,252,255]}]}},"type":"uniqueValue","field1":"PROSTATUS","fieldDelimiter":",","defaultSymbol":{"color":[0,0,0,64],"outline":{"color":[0,0,0,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"color":[0,0,0,64],"outline":{"color":[0,0,0,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"Construction","label":"Construction"},{"symbol":{"color":[0,0,0,64],"outline":{"color":[0,0,0,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"Design","label":"Design"}]},"transparency":0}

HasZ: true

HasM: false

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: PROSTATUS

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• PRONAME (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PROSTATUS (type: esriFieldTypeString, alias: Project Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PRONUM (type: esriFieldTypeString, alias: Project Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• ESTCONSTYR (type: esriFieldTypeString, alias: Est. Construction Year, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• NTPDate (type: esriFieldTypeString, alias: Construction NTP Date, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CNSTBIDNOM (type: esriFieldTypeString, alias: Bid Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LSTUPDTED (type: esriFieldTypeDate, alias: Last Updated Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ESTADVDATE (type: esriFieldTypeDate, alias: Est. Advertise Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• COMMSDST (type: esriFieldTypeString, alias: Commission District, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CMFIRM (type: esriFieldTypeString, alias: Cm Firm, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• COUNTYPM (type: esriFieldTypeString, alias: County Project Engineer, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• CNSTLTCON (type: esriFieldTypeString, alias: County Construction Manager, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• DESGNCONSLT (type: esriFieldTypeString, alias: Design Consultant, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• DESGNFUND (type: esriFieldTypeString, alias: Design Fund, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• FYFUNDS (type: esriFieldTypeString, alias: FY Funds, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• CMPLTDTE (type: esriFieldTypeDate, alias: Completion Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• TempLink (type: esriFieldTypeSmallInteger, alias: Temp Link, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ContractorBidEst (type: esriFieldTypeInteger, alias: Contractor Bid Est., SQL Type: sqlTypeOther, nullable: true, editable: true)
• RAWENGBID (type: esriFieldTypeInteger, alias: Engineer Bid Estimate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Design_L_Number (type: esriFieldTypeString, alias: Design L#, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Work_Order_Number (type: esriFieldTypeString, alias: Work Order #, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Contract_Date (type: esriFieldTypeString, alias: Construction Contract Date, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• JoinField (type: esriFieldTypeInteger, alias: Join Field, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Construction_Fund (type: esriFieldTypeString, alias: Construction Fund, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Finance_Name (type: esriFieldTypeString, alias: Finance Name, SQL Type: sqlTypeOther, length: 400, nullable: true, editable: true)
• Bid_Name (type: esriFieldTypeString, alias: Bid Name, SQL Type: sqlTypeOther, length: 400, nullable: true, editable: true)
• Re_rate_Date (type: esriFieldTypeDate, alias: Re-Rate Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Flag (type: esriFieldTypeString, alias: Flag, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Verify (type: esriFieldTypeString, alias: Verify, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PERCMPTE (type: esriFieldTypeInteger, alias: PercentComplete, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CUBBIE (type: esriFieldTypeString, alias: Cubbie, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UTILTYLTR (type: esriFieldTypeString, alias: UtilityLetters, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ROWComplete (type: esriFieldTypeString, alias: ROWComplete, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• EstTotalCost (type: esriFieldTypeString, alias: EstTotalCost, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• EstConstructionStart (type: esriFieldTypeString, alias: EstConstructionStart, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• EstConstComplete (type: esriFieldTypeString, alias: EstConstComplete, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• ProjDescription (type: esriFieldTypeString, alias: ProjDescription, SQL Type: sqlTypeOther, length: 800, nullable: true, editable: true)
• Prodsc (type: esriFieldTypeString, alias: Design Description, SQL Type: sqlTypeOther, length: 2200, nullable: true, editable: true)
• NEWDISTRICT (type: esriFieldTypeString, alias: District (Updated 7/31/23), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ProjConstDesc (type: esriFieldTypeString, alias: Construction Description, SQL Type: sqlTypeOther, length: 3000, nullable: true, editable: true)
• Contractor (type: esriFieldTypeString, alias: Contractor, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• TotContractCOST (type: esriFieldTypeInteger, alias: Total Contract Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ConstPctComplete (type: esriFieldTypeInteger, alias: Construction Percent Complete, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ConstructionStart (type: esriFieldTypeDate, alias: Construction Start, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Contact (type: esriFieldTypeString, alias: Contact, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• BIDOPEN (type: esriFieldTypeDate, alias: BIDOPEN, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• BIDAWARD (type: esriFieldTypeDate, alias: BIDAWARD, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MNTPSTART (type: esriFieldTypeDate, alias: MNTPSTART, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MNTPDUR (type: esriFieldTypeInteger, alias: MNTPDUR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROJADD (type: esriFieldTypeInteger, alias: PROJADD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONTSBCMP (type: esriFieldTypeDate, alias: CONTSBCMP, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OVERCONT (type: esriFieldTypeInteger, alias: OVERCONT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESTSUBCMP (type: esriFieldTypeDate, alias: ESTSUBCMP, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OPTOAWRD (type: esriFieldTypeInteger, alias: OPTOAWRD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OPTONTP (type: esriFieldTypeInteger, alias: OPTONTP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AWRDTONTP (type: esriFieldTypeInteger, alias: AWRDTONTP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SAPID (type: esriFieldTypeString, alias: SAPID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• PRONUM_CONST (type: esriFieldTypeString, alias: PRONUM_CONST, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PRONUM_ACTIVE (type: esriFieldTypeString, alias: PRONUM_ACTIVE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ACTIVE_NAME (type: esriFieldTypeString, alias: ACTIVE_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EXT (type: esriFieldTypeString, alias: EXT, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PM (type: esriFieldTypeString, alias: PM, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Scale (type: esriFieldTypeInteger, alias: Scale, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PROJ_DESC (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• Desc1 (type: esriFieldTypeString, alias: Description 1, SQL Type: sqlTypeOther, length: 10000, nullable: true, editable: true)
• EstTotalCost_Int (type: esriFieldTypeInteger, alias: EstTotalCost_Int, SQL Type: sqlTypeOther, nullable: true, editable: true)

Types:

ID: Construction
Name: Construction
Domains:

Templates:

Name: Construction
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• PROSTATUS: Construction
• ProjConstDesc: N/A

---

ID: Design
Name: Design
Domains:

Templates:

Name: Design
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• PROSTATUS: Design
• ProjConstDesc: N/A

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/19/2026 8:41:49 PM

Schema Last Edit Date: 3/19/2026 8:41:49 PM

Data Last Edit Date: 3/19/2026 8:41:49 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat