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:
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)
- 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)
- 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)
- 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 ...)
- 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])
- globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Templates:
Name: Active Transportation
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- projid:
- projname:
- projtype: Active Transportation
Relationships:
- Funding (1) -- Related To: Funding (2)
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
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat