Name: CIP Citywide

Display Field: SITE

Type: Table

Geometry Type: N/A

Description: This is a points feature layer displaying the authoritative data for the 2023 Budget Cycle Capital Improvement Projects. The attribute table contains the site location, the project title, the latitude and longitude of the point, the program category, the project manager's name and email, the capital improvement budget link, the project website if applicable, and the estimated start and completion dates.

Service Item Id: 831261bbcd444834a8e6e323df244161

Copyright Text: City of Thousand Oaks

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID_12, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID_12 )
• PROJ_TITLE ( type: esriFieldTypeString, alias: Title, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PROJ_TITLE )
• NUMBER__ ( type: esriFieldTypeString, alias: Number, editable: true, nullable: true, length: 254, defaultValue: null, modelName: NUMBER__ )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 254, defaultValue: null, modelName: STATUS , Coded Values: [Design: Design] , [Construction: Construction] , [Complete: Complete] , ...1 more... )
• SITE ( type: esriFieldTypeString, alias: Site, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SITE , Coded Values: [MSC: Municipal Service Center] , [CAP: City Hll] , [Other: Other] , ...2 more... )
• PROJ_TYPE ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PROJ_TYPE , Coded Values: [Stormwater: Stormwater Project] , [Facility: Facility Project] , [Street: Street Project] , ...7 more... )
• PROGRAM_ ( type: esriFieldTypeString, alias: Program, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PROGRAM_ )
• PRJ_Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 1070, defaultValue: null, modelName: PRJ_Description )
• Proj_Manager ( type: esriFieldTypeString, alias: Manager, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Proj_Manager )
• Manager_Email ( type: esriFieldTypeString, alias: Manager Email, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Manager_Email )
• CI_Budget_Link ( type: esriFieldTypeString, alias: Budget Link, editable: true, nullable: true, length: 250, defaultValue: null, modelName: CI_Budget_Link )
• Proj_Website ( type: esriFieldTypeString, alias: Website, editable: true, nullable: true, length: 350, defaultValue: null, modelName: Proj_Website )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Year ( type: esriFieldTypeString, alias: Year, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Year )
• DWG_NO ( type: esriFieldTypeString, alias: DWG_NO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: DWG_NO )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• PrimeContractor ( type: esriFieldTypeString, alias: PrimeContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PrimeContractor )
• AwardAmount ( type: esriFieldTypeDouble, alias: AwardAmount, editable: true, nullable: true, defaultValue: null, modelName: AwardAmount )
• ContractValue ( type: esriFieldTypeDouble, alias: ContractValue, editable: true, nullable: true, defaultValue: null, modelName: ContractValue )
• ChangeOrders ( type: esriFieldTypeString, alias: ChangeOrders, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ChangeOrders )
• DistrictNumber ( type: esriFieldTypeString, alias: DistrictNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DistrictNumber )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LegacyID )
• PublicDisplay ( type: esriFieldTypeString, alias: PublicDisplay, editable: true, nullable: true, length: 3, defaultValue: null, modelName: PublicDisplay , Coded Values: [Y: Yes] , [N: No] )

Templates:

• Name: CIP Citywide
  Description:
  Prototype:
  LegacyID: null
  DistrictNumber: null
  PROJ_TITLE: null
  NUMBER__: null
  STATUS: null
  SITE: null
  PROJ_TYPE: null
  PROGRAM_: null
  PRJ_Description: null
  Proj_Manager: null
  Manager_Email: null
  CI_Budget_Link: null
  Proj_Website: null
  PublicDisplay: null
  Year: null
  DWG_NO: null
  ChangeOrders: null
  ContractValue: null
  AwardAmount: null
  PrimeContractor: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata