Name: 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: 1155582

Max. Scale: 9027

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -9817155.1104
YMin: 5124829.7766
XMax: -9806228.6511
YMax: 5131838.5154
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: 7/17/2025 10:29:14 PM

Schema Last Edit Date: 7/16/2025 4:25:21 PM

Data Last Edit Date: 7/17/2025 10:29:14 PM

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