Name: Project List
Display Field: projname
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Description:
Copyright Text:
Min. Scale: 577791
Max. Scale: 1128
Default Visibility: true
Max Record Count: 1000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -122.561605332
YMin: 47.1668239190001
XMax: -122.348374939
YMax: 47.318831829
Spatial Reference: 4326 (4326)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,178,255,48],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,178,255,255],"width":2}},"label":"Proj Updates - CIP, CFP, TIP"},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: true
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: objectid
Unique ID Field:
IsSystemMaintained : True
Global ID Field: globalid
Type ID Field:
Fields:
- projname (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- objectid (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- uniquerowid (type: esriFieldTypeGUID, alias: RowID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
- websiteurl (type: esriFieldTypeString, alias: Website URL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- needs_website (type: esriFieldTypeString, alias: Needs Website, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- associated_programs_6ytip (type: esriFieldTypeString, alias: TIP, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- associated_programs_cfp (type: esriFieldTypeString, alias: CFP, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- associated_programs_si (type: esriFieldTypeString, alias: SI, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- lead_department (type: esriFieldTypeString, alias: Lead Department, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [City Manager's Office: City Manager's Office], [Community and Economic Development: Community and Economic Development], [Cross-Departmental: Cross - Departmental], ... 12 more ...)
- contact_name (type: esriFieldTypeString, alias: Contact Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- contact_email (type: esriFieldTypeString, alias: Contact Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- contact_phone (type: esriFieldTypeString, alias: Contact Phone, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- partners (type: esriFieldTypeString, alias: Partners, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- wbs_element (type: esriFieldTypeString, alias: WBS Element, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- project_type (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Active Transportation & Transportation Accessibility: Active Transportation & Transportation Accessibility], [Bridge: Bridge], [Community Development: Community Development], ... 16 more ...)
- project_description (type: esriFieldTypeString, alias: Project Description, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- website_project_description (type: esriFieldTypeString, alias: Website Project Description, SQL Type: sqlTypeOther, length: 10000, nullable: true, editable: true)
- city_council_districts (type: esriFieldTypeString, alias: City Council Districts, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- neighborhood_councils (type: esriFieldTypeString, alias: Neighborhood Councils, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- business_districts (type: esriFieldTypeString, alias: Business Districts, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- current_phase (type: esriFieldTypeString, alias: Current Phase, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Unfunded: Unfunded], [Planning: Planning], [Design: Design], ... 6 more ...)
- construction_start (type: esriFieldTypeDate, alias: Construction Start, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- construction_end (type: esriFieldTypeDate, alias: Construction End, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- schedule_notes (type: esriFieldTypeString, alias: Schedule Notes, SQL Type: sqlTypeOther, length: 10000, nullable: true, editable: true)
- total_estimated_cost (type: esriFieldTypeDouble, alias: Estimated Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
- confirmed_funds_so_far (type: esriFieldTypeDouble, alias: Total Funds Confirmed, SQL Type: sqlTypeOther, nullable: true, editable: true)
- funding_notes (type: esriFieldTypeString, alias: Funding/Budget Notes, SQL Type: sqlTypeOther, length: 10000, nullable: true, editable: true)
- budget_by_phase_phasenames (type: esriFieldTypeString, alias: Phase Name Array, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- budget_by_phase_costs (type: esriFieldTypeString, alias: Phase Cost Array, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- funding_prog_funds (type: esriFieldTypeString, alias: Funding Amount Array, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- funding_prog_prevapprop_prior (type: esriFieldTypeInteger, alias: Spending PrevApprop Prior, SQL Type: sqlTypeOther, nullable: true, editable: true)
- funding_prog_prevapprop_y1 (type: esriFieldTypeInteger, alias: Spending PrevApprop y1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- funding_prog_prevapprop_y2 (type: esriFieldTypeInteger, alias: Spending PrevApprop y2, SQL Type: sqlTypeOther, nullable: true, editable: true)
- funding_prog_prevapprop_yx (type: esriFieldTypeInteger, alias: Spending PrevApprop yx, SQL Type: sqlTypeOther, nullable: true, editable: true)
- funding_prog_new_y1 (type: esriFieldTypeInteger, alias: Spending New y1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- funding_prog_new_y2 (type: esriFieldTypeInteger, alias: Spending New y2, SQL Type: sqlTypeOther, nullable: true, editable: true)
- funding_prog_new_yx (type: esriFieldTypeInteger, alias: Spending New yx, SQL Type: sqlTypeOther, nullable: true, editable: true)
- funding_prog_unconfirmed_yx (type: esriFieldTypeInteger, alias: Spending Unconfirmed yx, SQL Type: sqlTypeOther, nullable: true, editable: true)
- additional_section_titles (type: esriFieldTypeString, alias: Additional Section Titles, SQL Type: sqlTypeOther, length: 50000, nullable: true, editable: true)
- additional_section_texts (type: esriFieldTypeString, alias: Additional Section Texts, SQL Type: sqlTypeOther, length: 50000, 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)
- location_description (type: esriFieldTypeString, alias: Project Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- project_rationale (type: esriFieldTypeString, alias: Project Rationale, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- phase_notes (type: esriFieldTypeString, alias: Phase Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- funding_prog_confirmed (type: esriFieldTypeString, alias: Funding Confirmed Array, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- total_reported_funds (type: esriFieldTypeDouble, alias: Total Funds Reported, SQL Type: sqlTypeOther, nullable: true, editable: true)
- tip_table_row (type: esriFieldTypeString, alias: Funding Row for TIP Table, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- cipstatus (type: esriFieldTypeString, alias: Exists in CIP Map, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- needs_cip (type: esriFieldTypeString, alias: Needs added to CIP Map, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- remove_project (type: esriFieldTypeString, alias: Remove Project, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- remove_reason (type: esriFieldTypeString, alias: Removal Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- reqstatus (type: esriFieldTypeString, alias: Request Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [New: New], [Inactive: Inactive], [Active: Active], ... 3 more ...)
- last_edit_text (type: esriFieldTypeString, alias: Last Edit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- citywide (type: esriFieldTypeString, alias: Citywide, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- timeline_dates (type: esriFieldTypeString, alias: Timeline Dates, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- timeline_events (type: esriFieldTypeString, alias: Timeline Events, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
- funding_source_types (type: esriFieldTypeString, alias: Funding Source Types, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- funding_source_notes (type: esriFieldTypeString, alias: Funding Source Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- funding_source_names (type: esriFieldTypeString, alias: Funding Source Names, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- prevapprop_prior_bysource (type: esriFieldTypeString, alias: prevapprop_prior_bysource, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- prevapprop_y1_bysource (type: esriFieldTypeString, alias: prevapprop_y1_bysource, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- prevapprop_y2_bysource (type: esriFieldTypeString, alias: prevapprop_y2_bysource, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- prevapprop_yx_bysource (type: esriFieldTypeString, alias: prevapprop_yx_bysource, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- new_y1_bysource (type: esriFieldTypeString, alias: new_y1_bysource, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- new_y2_bysource (type: esriFieldTypeString, alias: new_y2_bysource, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- new_yx_bysource (type: esriFieldTypeString, alias: new_yx_bysource, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- unconfirmed_yx_bysource (type: esriFieldTypeString, alias: unconfirmed_yx_bysource, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- 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: Proj Updates - CIP, CFP, TIP
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 7/20/2025 2:08:22 AM
Schema Last Edit Date: 7/18/2025 2:08:59 AM
Data Last Edit Date: 7/18/2025 2:08:59 AM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Attachments
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat