Layers:

Layer: Projects (0)


Name: Projects

Display Field: projname

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Has Views: true

Source Schema Changes Allowed: true

Description:

Copyright Text:

Min. Scale: 1155582

Max. Scale: 9027

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -10671641.541
YMin: 3430059.33504373
XMax: -10571134.3585866
YMax: 3540704.73954746
Spatial Reference: 102100 (3857)


Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[252,201,246,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

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)
• 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: false, editable: true)
• projdesc (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 4000, 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: [Active Transportation: Active Transportation], [Facilities: Facilities], [Parks & Recreation: Parks & Recreation], ... 8 more ...)
• priority (type: esriFieldTypeString, alias: Priority, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [High: High], [Medium: Medium], [Low: Low], ... 1 more ...)
• planalignment (type: esriFieldTypeString, alias: Plan Alignment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ADA Transition Plan: ADA Transition Plan], [Bicycle and Pedestrian Master Plan: Bicycle and Pedestrian Master Plan], [Comprehensive Plan: Comprehensive Plan], ... 6 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 Budget, SQL Type: sqlTypeOther, nullable: true, editable: true)
• contingency (type: esriFieldTypeDouble, alias: Contingency, 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)
• agency (type: esriFieldTypeString, alias: Agency, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• department (type: esriFieldTypeString, alias: Department Responsible, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Facilities: Facilities], [Parks: Parks], [Public Works: Public Works], ... 3 more ...)
• projphase (type: esriFieldTypeString, alias: Project Phase, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Plan], [2: PreDesign], [3: Design], ... 3 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: Expenditures, SQL Type: sqlTypeOther, nullable: true, editable: true)
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• docpath (type: esriFieldTypeString, alias: Document Path, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• publicview (type: esriFieldTypeString, alias: Public View, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• funding (type: esriFieldTypeDouble, alias: Funding total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• fundingsources (type: esriFieldTypeString, alias: Funding Sources, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• fiscalyears (type: esriFieldTypeString, alias: Fiscal Years, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• projrank (type: esriFieldTypeDouble, alias: Number of drivers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cip (type: esriFieldTypeString, alias: CIP, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [N/A: N/A], [2018-2024: 2018-2024], [2024-2030: 2024-2030], ... 1 more ...)
• externalproject (type: esriFieldTypeString, alias: External Project, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• driver1 (type: esriFieldTypeString, alias: Health and Safety, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• driver2 (type: esriFieldTypeString, alias: Mandate, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• driver3 (type: esriFieldTypeString, alias: Repair or Maintenance, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• driver4 (type: esriFieldTypeString, alias: Replacement, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• driver5 (type: esriFieldTypeString, alias: Expansion, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• driver6 (type: esriFieldTypeString, alias: Resiliency, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• driver7 (type: esriFieldTypeString, alias: Quality of Life / Aesthetic Value, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• driver8 (type: esriFieldTypeString, alias: Economic Development, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• driver9 (type: esriFieldTypeString, alias: Participatory Budgeting, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• driver10 (type: esriFieldTypeString, alias: Disadvantaged Community, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• internalprojectreview (type: esriFieldTypeString, alias: Internal Project Review, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• externalprojectreview (type: esriFieldTypeString, alias: External Project Review, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• roadreview (type: esriFieldTypeString, alias: Road Review, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• conflictexception (type: esriFieldTypeString, alias: Conflict Exception, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: Created On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: Last Edited By, SQL Type: sqlTypeOther, length: 8, 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)

Templates:

Name: Active Transportation
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• projtype: Active Transportation
• conflictexception: No
• driver1: No
• driver2: No
• driver3: No
• driver4: No
• driver5: No
• driver6: No
• driver7: No
• driver8: No
• driver9: No
• driver10: No
• internalprojectreview: No
• externalprojectreview: No
• roadreview: No
Name: Facilities
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• projtype: Facilities
• conflictexception: No
• driver1: No
• driver2: No
• driver3: No
• driver4: No
• driver5: No
• driver6: No
• driver7: No
• driver8: No
• driver9: No
• driver10: No
• internalprojectreview: No
• externalprojectreview: No
• roadreview: No
Name: Parks & Recreation
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• projtype: Parks & Recreation
• conflictexception: No
• driver1: No
• driver2: No
• driver3: No
• driver4: No
• driver5: No
• driver6: No
• driver7: No
• driver8: No
• driver9: No
• driver10: No
• internalprojectreview: No
• externalprojectreview: No
• roadreview: No
Name: Sanitary Sewer
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• projtype: Sanitary Sewer
• conflictexception: No
• driver1: No
• driver2: No
• driver3: No
• driver4: No
• driver5: No
• driver6: No
• driver7: No
• driver8: No
• driver9: No
• driver10: No
• internalprojectreview: No
• externalprojectreview: No
• roadreview: No
Name: Stormwater
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• projtype: Stormwater
• conflictexception: No
• driver1: No
• driver2: No
• driver3: No
• driver4: No
• driver5: No
• driver6: No
• driver7: No
• driver8: No
• driver9: No
• driver10: No
• internalprojectreview: No
• externalprojectreview: No
• roadreview: No
Name: Telecommunications
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• projtype: Telecommunications
• conflictexception: No
• driver1: No
• driver2: No
• driver3: No
• driver4: No
• driver5: No
• driver6: No
• driver7: No
• driver8: No
• driver9: No
• driver10: No
• internalprojectreview: No
• externalprojectreview: No
• roadreview: No
Name: Transit
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• projtype: Transit
• conflictexception: No
• driver1: No
• driver2: No
• driver3: No
• driver4: No
• driver5: No
• driver6: No
• driver7: No
• driver8: No
• driver9: No
• driver10: No
• internalprojectreview: No
• externalprojectreview: No
• roadreview: No
Name: Transportation
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• projtype: Transportation
• conflictexception: No
• driver1: No
• driver2: No
• driver3: No
• driver4: No
• driver5: No
• driver6: No
• driver7: No
• driver8: No
• driver9: No
• driver10: No
• internalprojectreview: No
• externalprojectreview: No
• roadreview: No
Name: Water Distribution
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• projtype: Water Distribution
• conflictexception: No
• driver1: No
• driver2: No
• driver3: No
• driver4: No
• driver5: No
• driver6: No
• driver7: No
• driver8: No
• driver9: No
• driver10: No
• internalprojectreview: No
• externalprojectreview: No
• roadreview: No
Name: Other
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• projtype: Other
• conflictexception: No
• driver1: No
• driver2: No
• driver3: No
• driver4: No
• driver5: No
• driver6: No
• driver7: No
• driver8: No
• driver9: No
• driver10: No
• internalprojectreview: No
• externalprojectreview: No
• roadreview: No

Relationships:
• Comments (0) -- Related To: Comments (1)
• Funding (1) -- Related To: Funding (2)
• Spending (3) -- Related To: Spending (4)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/29/2025 9:15:26 PM

Schema Last Edit Date: 6/29/2025 9:02:23 PM

Data Last Edit Date: 6/29/2025 9:15:26 PM

Tables:

Comments (1)


Name: Comments

Display Field: name

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

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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)
• name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 150, nullable: false, editable: true)
• comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• commentdt (type: esriFieldTypeDate, alias: Comment date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• projectguid (type: esriFieldTypeGUID, alias: Project GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: Created On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: Last Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)

Templates:

Name: Comments
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• name:

Relationships:
• Projects (0) -- Related To: Projects (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/29/2025 9:15:26 PM

Schema Last Edit Date: 6/28/2025 2:07:02 AM

Data Last Edit Date: 6/29/2025 9:15:26 PM

Funding (2)


Name: Funding

Display Field: fiscalyear

Type: Table

Has Views: true

Source Schema Changes Allowed: true

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

Type ID Field:

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• fiscalyear (type: esriFieldTypeString, alias: Fiscal Year, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [2024: 2024], [2025: 2025], [2026: 2026], ... 12 more ...)
• fundingsource (type: esriFieldTypeString, alias: Funding Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [General Fund: General Fund], [Mobility Fund: Mobility Fund], [Flex Fund: Flex Fund], ... 6 more ...)
• fundamount (type: esriFieldTypeDouble, alias: Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• projectguid (type: esriFieldTypeGUID, alias: Project GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: Created On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: Last Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• UPIN (type: esriFieldTypeGUID, alias: UPIN, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)

Templates:

Name: Funding
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:


Relationships:
• Projects (1) -- Related To: Projects (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/29/2025 9:15:26 PM

Schema Last Edit Date: 6/28/2025 2:07:02 AM

Data Last Edit Date: 6/29/2025 9:15:26 PM

Spending (4)


Name: Spending

Display Field: description

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

Type ID Field:

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• category (type: esriFieldTypeString, alias: Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• costamount (type: esriFieldTypeDouble, alias: Cost Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• projectguid (type: esriFieldTypeGUID, alias: Project GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• datespent (type: esriFieldTypeDateOnly, alias: Date Spent, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Spending
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:


Relationships:
• Projects (3) -- Related To: Projects (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/29/2025 9:15:26 PM

Schema Last Edit Date: 6/28/2025 2:07:02 AM

Data Last Edit Date: 6/29/2025 9:15:26 PM