Name: ProjectSites

Display Field: project_name

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: 1458844.67665915
YMin: 1450289.76109824
XMax: 1603085.9744615
YMax: 1534958.71495654
Spatial Reference: 2903 (2903)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[115,223,255,52],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":2}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

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)
• project_identifier (type: esriFieldTypeString, alias: Project Identifier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• project_name (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• project_type (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Traffic Engineering: Traffic Engineering], [Street Maintenance: Street Maintenance], [Transportation: Transportation], ... 10 more ...)
• project_location (type: esriFieldTypeString, alias: Project Location/Address, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• project_status (type: esriFieldTypeString, alias: Project Status/Phase, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Design: Design], [BID: BID], [Construction: Construction], ... 9 more ...)
• project_description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• department (type: esriFieldTypeString, alias: Department, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [DMD: DMD], [GSD: GSD], [Parks: Parks], ... 7 more ...)
• division (type: esriFieldTypeString, alias: Division, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Engineering: Engineering], [Streets: Streets], [Traffic Engineering: Traffic Engineering], ... 6 more ...)
• project_funding (type: esriFieldTypeString, alias: Funding Source(s), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• est_start_date (type: esriFieldTypeDate, alias: Planned Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• est_end_date (type: esriFieldTypeDate, alias: Planned End Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• total_cost_est (type: esriFieldTypeDouble, alias: Total Planned Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_cost_final (type: esriFieldTypeDouble, alias: Actual Final Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cpn (type: esriFieldTypeString, alias: City Project Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• year_fiscal (type: esriFieldTypeSmallInteger, alias: Fiscal Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• year_started (type: esriFieldTypeSmallInteger, alias: Year Started, SQL Type: sqlTypeOther, nullable: true, editable: true)
• year_completed (type: esriFieldTypeSmallInteger, alias: Year Completed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• vision_zero_flag (type: esriFieldTypeString, alias: Vision Zero Project, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown], ... 1 more ...)
• council_district (type: esriFieldTypeSmallInteger, alias: Council District, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1=TELLES], [3: 3=PEÑA], [4: 4=BASSAN], ... 7 more ...)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• project_subtype (type: esriFieldTypeString, alias: Project Subtype, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [TE-Rewiring: TE - Rewiring], [TE-Signal Cabinet: TE - Signal Cabinet], [TE-Jbox: TE - Jbox], ... 17 more ...)
• construction_start_date (type: esriFieldTypeDate, alias: Construction Start, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• construction_end_date (type: esriFieldTypeDate, alias: Construction End, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• public_notice_issued (type: esriFieldTypeString, alias: Public Notice Issued, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• public_notice_date (type: esriFieldTypeDate, alias: Public Notice Date Issued, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• dept_section (type: esriFieldTypeString, alias: Section, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Signals: Signals], [Signs and Markings: Signs and Markings], [Studies and Street Lights: Studies and Street Lights], ... 4 more ...)
• bike_ped_flag (type: esriFieldTypeString, alias: Bike/Pedestrian Project, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown], ... 1 more ...)
• vision_zero_funding (type: esriFieldTypeInteger, alias: Vision Zero Funding Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: ProjectSites
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• project_status: Pre-Design
• department: DMD
• total_cost_est: 0
• total_cost_final: 0
• funded_flag: No
• expansion_flag: No
• council_flag: No
• repair_flag: No
• replacement_flag: No
• vision_zero_flag: No
• efficiency_flag: No
• visibility: Internal
• email_updates: Y
• public_notice_needed: No

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/24/2026 9:02:19 PM

Schema Last Edit Date: 9/17/2026 5:18:14 PM

Data Last Edit Date: 9/24/2026 9:02:19 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat