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: 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)
• 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_manager (type: esriFieldTypeString, alias: Project Manager, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• 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)
• start_date (type: esriFieldTypeDate, alias: Actual Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• end_date (type: esriFieldTypeDate, alias: Actual End Date, SQL Type: sqlTypeOther, length: 8, 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)
• outside_id (type: esriFieldTypeInteger, alias: ProCore/Outside ID, SQL Type: sqlTypeOther, 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)
• design_contractor (type: esriFieldTypeString, alias: Design Consultant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• construction_contractor (type: esriFieldTypeString, alias: Construction Consultant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• funded_flag (type: esriFieldTypeString, alias: Funded Project, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown], ... 1 more ...)
• expansion_flag (type: esriFieldTypeString, alias: Expansion Project, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown], ... 1 more ...)
• council_flag (type: esriFieldTypeString, alias: Council Project, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown], ... 1 more ...)
• repair_flag (type: esriFieldTypeString, alias: Repair Project, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown], ... 1 more ...)
• replacement_flag (type: esriFieldTypeString, alias: Replacement Project, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown], ... 1 more ...)
• 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 ...)
• efficiency_flag (type: esriFieldTypeString, alias: Efficiency 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 ...)
• visibility (type: esriFieldTypeString, alias: Visibility, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Public: Public], [Internal: Internal], [Hidden: Hidden])
• notes_update (type: esriFieldTypeString, alias: Update Notes, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• notes_closeout (type: esriFieldTypeString, alias: Closeout Notes, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• email_updates (type: esriFieldTypeString, alias: Email Updates, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• additional_1 (type: esriFieldTypeString, alias: Additional Info 1, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• additional_2 (type: esriFieldTypeString, alias: Additional Info 2, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, 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 ...)
• general_consultant (type: esriFieldTypeString, alias: General Consultant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• construction_cost_est (type: esriFieldTypeDouble, alias: Construction Cost Est., SQL Type: sqlTypeOther, nullable: true, editable: true)
• design_cost_est (type: esriFieldTypeDouble, alias: Design Cost Est., SQL Type: sqlTypeOther, nullable: true, editable: true)
• construction_cost_final (type: esriFieldTypeDouble, alias: Construction Cost Final, SQL Type: sqlTypeOther, nullable: true, editable: true)
• design_cost_final (type: esriFieldTypeDouble, alias: Design Cost Final, SQL Type: sqlTypeOther, nullable: true, editable: true)
• 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)
• control_number (type: esriFieldTypeString, alias: Control Number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• po_number (type: esriFieldTypeString, alias: PO Number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• design_start_date (type: esriFieldTypeDate, alias: Design Start, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• design_end_date (type: esriFieldTypeDate, alias: Design End, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• planning_cost_est (type: esriFieldTypeDouble, alias: Planning Cost Est., SQL Type: sqlTypeOther, nullable: true, editable: true)
• planning_cost_final (type: esriFieldTypeDouble, alias: Planning Cost Final, SQL Type: sqlTypeOther, nullable: true, editable: true)
• const_management_cost (type: esriFieldTypeDouble, alias: Construction Management Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• state_funding (type: esriFieldTypeDouble, alias: State Funding Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• local_funding (type: esriFieldTypeDouble, alias: Local Funding Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• federal_funding (type: esriFieldTypeDouble, alias: Federal Funding Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Area (type: esriFieldTypeDouble, alias: SHAPE__Area, SQL Type: sqlTypeDouble, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: SHAPE__Length, SQL Type: sqlTypeDouble, nullable: true, editable: true)
• public_notice_needed (type: esriFieldTypeString, alias: Public Notice Needed, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• 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 ...)
• accomplishments (type: esriFieldTypeString, alias: Add to Accomplishments, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• public_notice_notes (type: esriFieldTypeString, alias: Public Notice Description, SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
• safety_enhancement_flag (type: esriFieldTypeString, alias: Safety Enhancement Project, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unknown], ... 1 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
• bike_ped_flag: No

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/25/2026 9:03:09 PM

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

Data Last Edit Date: 9/25/2026 9:03:09 PM

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