Name: cip_projects_points_jan2024

Display Field: SUB_PROJECT_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Points for active Parks and Recreation Department capital improvement program projects as of May 2023

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: 3071462.43289955
YMin: 10029896.8423261
XMax: 3156746.34861746
YMax: 10145243.8665529
Spatial Reference: 102739 (2277)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[54,98,142,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• SUB_PROJECT_ID (type: esriFieldTypeDouble, alias: SUB_PROJECT_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SUBPROJECT_ID_UK (type: esriFieldTypeDouble, alias: SUBPROJECT_ID_UK, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AMANDA_ROW_ID (type: esriFieldTypeInteger, alias: AMANDA_ROW_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CIP_PROJECT_TYPE (type: esriFieldTypeString, alias: CIP_PROJECT_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PRIORITY (type: esriFieldTypeSmallInteger, alias: PRIORITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SUB_PROJECT_NAME (type: esriFieldTypeString, alias: SUB_PROJECT_NAME, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• SUB_PROJECT_MANAGER (type: esriFieldTypeString, alias: SUB_PROJECT_MANAGER, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• SUB_PROJECT_TYPE (type: esriFieldTypeString, alias: SUB_PROJECT_TYPE, SQL Type: sqlTypeOther, length: 65, nullable: true, editable: true)
• SUB_PROJECT_STATUS (type: esriFieldTypeString, alias: SUB_PROJECT_STATUS, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• SUB_PROJECT_PHASE (type: esriFieldTypeString, alias: SUB_PROJECT_PHASE, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• SUB_PROJECT_DESCRIPTION (type: esriFieldTypeString, alias: SUB_PROJECT_DESCRIPTION, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SUB_PROJECT_TYPE_CATEGORY (type: esriFieldTypeString, alias: SUB_PROJECT_TYPE_CATEGORY, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• SUB_PROJECT_CLOSED (type: esriFieldTypeString, alias: SUB_PROJECT_CLOSED, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• PLANNING_SUBPROJECT (type: esriFieldTypeString, alias: PLANNING_SUBPROJECT, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• SPONSOR_CONTACT (type: esriFieldTypeString, alias: SPONSOR_CONTACT, SQL Type: sqlTypeOther, length: 180, nullable: true, editable: true)
• CONSTRUCTION_START_DATE (type: esriFieldTypeDate, alias: CONSTRUCTION_START_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CONSTRUCTION_END_DATE (type: esriFieldTypeDate, alias: CONSTRUCTION_END_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MANAGING_DEPARTMENT (type: esriFieldTypeString, alias: MANAGING_DEPARTMENT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ENGINEERING_SCHEDULE (type: esriFieldTypeString, alias: ENGINEERING_SCHEDULE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MANAGER_PHONE (type: esriFieldTypeString, alias: MANAGER_PHONE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MANAGER_EMAIL (type: esriFieldTypeString, alias: MANAGER_EMAIL, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• FME_LOADED_DATE (type: esriFieldTypeDate, alias: FME_LOADED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FME_CHANGED_DATE (type: esriFieldTypeDate, alias: FME_CHANGED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PHASE_START_DATE (type: esriFieldTypeDate, alias: PHASE_START_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PHASE_END_DATE (type: esriFieldTypeDate, alias: PHASE_END_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RESPONSIBLE_DEPARTMENT (type: esriFieldTypeString, alias: RESPONSIBLE_DEPARTMENT, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• CPE_PROJECT_WEBSITE_URL (type: esriFieldTypeString, alias: CPE_PROJECT_WEBSITE_URL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ORIG_FID (type: esriFieldTypeInteger, alias: ORIG_FID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Subproject_Number (type: esriFieldTypeDouble, alias: Subproject Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Manager (type: esriFieldTypeString, alias: Manager, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Current_Status (type: esriFieldTypeString, alias: Current Status, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Current_Subproject_Status_Type (type: esriFieldTypeString, alias: Current Subproject Status Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Status_Date (type: esriFieldTypeDate, alias: Status Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Current_Phase (type: esriFieldTypeString, alias: Current Phase, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Substantial_Completion (type: esriFieldTypeString, alias: Substantial Completion, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Estimated_Cost (type: esriFieldTypeDouble, alias: Estimated Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Expenses (type: esriFieldTypeDouble, alias: Expenses, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Estimated_Cost_mill (type: esriFieldTypeDouble, alias: Estimated Cost (Millions of Dollars), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Subproject_Number_1 (type: esriFieldTypeDouble, alias: Subproject Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Subproject_Name_1 (type: esriFieldTypeString, alias: Subproject Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Manager_1 (type: esriFieldTypeString, alias: Manager, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Description_1 (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Current_Status_1 (type: esriFieldTypeString, alias: Current Status, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Current_Subproject_Status_Type_ (type: esriFieldTypeString, alias: Current Subproject Status Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Status_Date_1 (type: esriFieldTypeDate, alias: Status Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Current_Phase_1 (type: esriFieldTypeString, alias: Current Phase, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Substantial_Completion_1 (type: esriFieldTypeString, alias: Substantial Completion, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Estimated_Cost_1 (type: esriFieldTypeDouble, alias: Estimated Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Expenses_1 (type: esriFieldTypeDouble, alias: Expenses, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: cip_projects_points_jan2024
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/16/2024 8:51:58 PM

Schema Last Edit Date: 1/8/2024 11:17:26 PM

Data Last Edit Date: 1/16/2024 8:51:58 PM

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