Name: Projects

Display Field: projname

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Has Views: true

Source Schema Changes Allowed: true

Views

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

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