Name: Infrastructure Projects

Display Field: projname

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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: -14999999.9999899
YMin: -4167501.10155041
XMax: 13121719.7601208
YMax: 6567396.5829583
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"visualVariables":[{"type":"sizeInfo","target":"outline","expression":"view.scale","valueExpression":"$view.scale","stops":[{"size":1.5,"value":13834},{"size":0.75,"value":43231},{"size":0.375,"value":172925},{"size":0,"value":345850}]}],"type":"simple","symbol":{"color":[25,135,187,255],"outline":{"color":[9,48,66,255],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}},"transparency":35}

HasZ: false

HasM: false

Has Attachments: true

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)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• projid (type: esriFieldTypeString, alias: Project Identifier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• projname (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• projdesc (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• rationale (type: esriFieldTypeString, alias: Rationale, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• projtype (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true, Coded Values: [Facilities: Facilities], [Parks: Parks], [Sewer Collection: Sewer Collection], ... 4 more ...)
• safety (type: esriFieldTypeString, alias: Health and Safety, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• mandate (type: esriFieldTypeString, alias: Mandate, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• repair (type: esriFieldTypeString, alias: Repair or Maintenance, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• replace (type: esriFieldTypeString, alias: Replacement, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• expand (type: esriFieldTypeString, alias: Expansion, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• efficient (type: esriFieldTypeString, alias: Efficiency, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• fiscalyr (type: esriFieldTypeString, alias: Fiscal Year, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• fundsource (type: esriFieldTypeString, alias: Funding Source, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Capital Fund: Capital Fund], [Connection Fee: Connection Fee], [General Fund: General Fund], ... 7 more ...)
• planstart (type: esriFieldTypeDate, alias: Planned Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• planend (type: esriFieldTypeDate, alias: Planned End Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• estcost (type: esriFieldTypeDouble, alias: Estimated Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pocname (type: esriFieldTypeString, alias: Contact Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pocphone (type: esriFieldTypeString, alias: Contact Phone, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• pocemail (type: esriFieldTypeString, alias: Contact Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• projstatus (type: esriFieldTypeString, alias: Project Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Project Initiation: Project Initiation], [Analysis and Review: Analysis and Review], [Executive Approval: Executive Approval], ... 1 more ...)
• funded (type: esriFieldTypeString, alias: Funded Project, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• projphase (type: esriFieldTypeString, alias: Project Phase, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [PreDesign: PreDesign], [Design: Design], [Construction: Construction], ... 2 more ...)
• actstart (type: esriFieldTypeDate, alias: Actual Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• actend (type: esriFieldTypeDate, alias: Actual End Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• actcost (type: esriFieldTypeDouble, alias: Actual Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• docpath (type: esriFieldTypeString, alias: Document Path, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 50, 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: 50, nullable: true, editable: false)
• 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)

Types:

ID: Transportation
Name: Transportation
Domains:

• Field Name: projtype
  Inherited
  
• Field Name: safety
  Inherited
  
• Field Name: mandate
  Inherited
  
• Field Name: repair
  Inherited
  
• Field Name: replace
  Inherited
  
• Field Name: expand
  Inherited
  
• Field Name: efficient
  Inherited
  
• Field Name: fundsource
  Inherited
  
• Field Name: projstatus
  Inherited
  
• Field Name: funded
  Inherited
  
• Field Name: projphase
  Inherited
  
Templates:

Name: Transportation
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• projstatus: Project Initiation
• projtype: Transportation
• funded: No
• projphase: PreDesign

---

Relationships:

• (0) -- Related To: Project Comments (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/22/2025 1:11:59 PM

Schema Last Edit Date: 11/15/2022 6:02:09 PM

Data Last Edit Date: 7/22/2025 1:11:59 PM

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