Name: Join_CIP_Buffer_to_Projects_Polygon_view

Display Field: projname

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

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: -10453491.1508
YMin: 3810502.7531
XMax: -10429195.3794
YMax: 3840631.1372
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[207,252,239,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,0],"width":0.7}}},"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:

• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• fiscalyr (type: esriFieldTypeString, alias: Fiscal Year, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [2021: 2021], [2022: 2022], [2023: 2023], ... 7 more ...)
• project_ID (type: esriFieldTypeString, alias: project_ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• projname (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Department (type: esriFieldTypeString, alias: Department, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [FD: Fire], [PD: Police], [WS: Water & Sewer], ... 2 more ...)
• projtype (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [01: Facilities], [02: Vehicles and Equipment], [03: Parks], ... 5 more ...)
• projphase (type: esriFieldTypeString, alias: Project Phase, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Funding], [2: Design], [3: Bid], ... 3 more ...)
• city_council_district (type: esriFieldTypeString, alias: City Council District, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [A: A], [B: B], [C: C], ... 4 more ...)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• BUFF_DIST (type: esriFieldTypeDouble, alias: BUFF_DIST, SQL Type: sqlTypeOther, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: parentglobalid, SQL Type: sqlTypeOther, length: 38, 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)
• projstatus (type: esriFieldTypeString, alias: projstatus, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Project Initiation], [2: Analysis and Review], [3: Executive Approval], ... 1 more ...)
• funded (type: esriFieldTypeString, alias: funded, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• sort_type (type: esriFieldTypeString, alias: sort_type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeOther, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeOther, nullable: true, editable: false)
• GlobalID_1731100717755 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• fiscalyr_1731100717755 (type: esriFieldTypeString, alias: Fiscal Year, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [2021: 2021], [2022: 2022], [2023: 2023], ... 7 more ...)
• projid (type: esriFieldTypeString, alias: Project Identifier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• project_ID_1731100717755 (type: esriFieldTypeString, alias: project_ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• projname_1731100717755 (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• projdesc (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• rationale (type: esriFieldTypeString, alias: Rationale, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• Department_1731100717755 (type: esriFieldTypeString, alias: Department, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [FD: Fire], [PD: Police], [WS: Water & Sewer], ... 2 more ...)
• projtype_1731100717755 (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [01: Facilities], [02: Vehicles and Equipment], [03: Parks], ... 5 more ...)
• projstatus_1731100717755 (type: esriFieldTypeString, alias: Project Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Project Initiation], [2: Analysis and Review], [3: Executive Approval], ... 1 more ...)
• projphase_1731100717755 (type: esriFieldTypeString, alias: Project Phase, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Funding], [2: Design], [3: Bid], ... 3 more ...)
• city_council_district_1731100717755 (type: esriFieldTypeString, alias: City Council District, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [A: A], [B: B], [C: C], ... 4 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)
• 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)
• estcost (type: esriFieldTypeDouble, alias: Estimated Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• actcost (type: esriFieldTypeDouble, alias: Actual Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• funded_1731100717755 (type: esriFieldTypeString, alias: Funded Project, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• fundsource (type: esriFieldTypeString, alias: Funding Source, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Capital Fund: Capital Fund], [Connection Fee: Connection Fee], [General Fund: General Fund], ... 8 more ...)
• fundsource_amount (type: esriFieldTypeDouble, alias: Funding Source Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• fundsource2 (type: esriFieldTypeString, alias: Second Funding Source, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Capital Fund: Capital Fund], [Connection Fee: Connection Fee], [General Fund: General Fund], ... 8 more ...)
• fundsource2_amount (type: esriFieldTypeDouble, alias: Second Funding Source Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• fundsource3 (type: esriFieldTypeString, alias: Third Funding Source, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Capital Fund: Capital Fund], [Connection Fee: Connection Fee], [General Fund: General Fund], ... 8 more ...)
• fundsource3_amount (type: esriFieldTypeDouble, alias: Third Funding Source Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• fundsource_totalAmount (type: esriFieldTypeDouble, alias: Total Source Funds, SQL Type: sqlTypeOther, nullable: true, editable: true)
• funds_committed_to_date (type: esriFieldTypeDouble, alias: Funds Committed to Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• funds_committed_percentage (type: esriFieldTypeDouble, alias: Percentage of Funds Committed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Phase_1 (type: esriFieldTypeDouble, alias: Phase 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Phase_2 (type: esriFieldTypeDouble, alias: Phase 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• safety (type: esriFieldTypeString, alias: Health and Safety, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• mandate (type: esriFieldTypeString, alias: Mandate, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• repair (type: esriFieldTypeString, alias: Repair or Maintenance, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• replace (type: esriFieldTypeString, alias: Replacement, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• expand (type: esriFieldTypeString, alias: Expansion, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• efficient (type: esriFieldTypeString, alias: Efficiency, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• docpath (type: esriFieldTypeString, alias: Document Path, SQL Type: sqlTypeOther, length: 1000, 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)
• created_user_1731100717755 (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date_1731100717755 (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user_1731100717755 (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date_1731100717755 (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Board_Authorized_Date (type: esriFieldTypeDate, alias: Board_Authorized_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• image_url (type: esriFieldTypeString, alias: image_url, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sort_type_1731100717755 (type: esriFieldTypeString, alias: sort_type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Shape__Area_1731100717755 (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeOther, nullable: true, editable: false)
• Shape__Length_1731100717755 (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeOther, nullable: true, editable: false)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Templates:

Name: Centroid Buffer
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/6/2024 11:07:17 PM

Schema Last Edit Date: 11/8/2024 9:11:13 PM

Data Last Edit Date: 11/8/2024 9:11:13 PM

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