View In:   ArcGIS Online Map Viewer

Name: Capital Project

Display Field: ProjectName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: cotgispub.dbo.vw_CIP_Pts

Service Item Id: 80951de469c341519006b1a21fba609d

Copyright Text:

Default Visibility: true

MaxRecordCount: 4000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 1937839.8572419733
YMin: 225423.16654622555
XMax: 1990287.0354838818
YMax: 288660.1772110611
Spatial Reference: 102677  (3419)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Category
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: Other/Combination
UniqueValueInfos:
• Value: Facilities
  Label: Facilites
  Description: N/A
  Symbol:
  
• Value: Neighborhoods
  Label: Neighborhoods
  Description: N/A
  Symbol:
  
• Value: Public Safety
  Label: Public Safety
  Description: N/A
  Symbol:
  
• Value: Quality of Life
  Label: Quality of Life
  Description: N/A
  Symbol:
  
• Value: Streets
  Label: Streets
  Description: N/A
  Symbol:
  
• Value: Traffic
  Label: Traffic
  Description: N/A
  Symbol:
  
• Value: Utilities
  Label: Utilities
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Category

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ProjectID ( type: esriFieldTypeString, alias: ProjectID, editable: true, nullable: true, length: 250, defaultValue: null, modelName: ProjectID )
• ProjectName ( type: esriFieldTypeString, alias: ProjectName, editable: true, nullable: true, length: 250, defaultValue: null, modelName: ProjectName )
• Category ( type: esriFieldTypeString, alias: Category, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Category )
• ProjectStatus ( type: esriFieldTypeString, alias: ProjectStatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectStatus )
• TotalBudget ( type: esriFieldTypeDouble, alias: TotalBudget, editable: true, nullable: true, defaultValue: null, modelName: TotalBudget )
• TotalActual ( type: esriFieldTypeDouble, alias: TotalActual, editable: true, nullable: true, defaultValue: null, modelName: TotalActual )
• PrimaryFundingSource ( type: esriFieldTypeString, alias: PrimaryFundingSource, editable: true, nullable: true, length: 150, defaultValue: null, modelName: PrimaryFundingSource )
• Division ( type: esriFieldTypeString, alias: Division, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Division )
• DateStart ( type: esriFieldTypeDate, alias: DateStart, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateStart )
• DateEnd ( type: esriFieldTypeDate, alias: DateEnd, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateEnd )
• AssetCategory ( type: esriFieldTypeString, alias: AssetCategory, editable: true, nullable: true, length: 150, defaultValue: null, modelName: AssetCategory )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 1500, defaultValue: null, modelName: Description )
• CostCheck ( type: esriFieldTypeString, alias: CostCheck, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CostCheck )
• ScheduleCheck ( type: esriFieldTypeString, alias: ScheduleCheck, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ScheduleCheck )
• ProjectOverallCheck ( type: esriFieldTypeString, alias: ProjectOverallCheck, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectOverallCheck )
• ProjectPhoto ( type: esriFieldTypeString, alias: ProjectPhoto, editable: true, nullable: true, length: 150, defaultValue: null, modelName: ProjectPhoto )
• PROJMANAGER ( type: esriFieldTypeString, alias: PROJMANAGER, editable: true, nullable: true, length: 40, defaultValue: null, modelName: PROJMANAGER )
• CouncilDist ( type: esriFieldTypeString, alias: CouncilDist, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CouncilDist )
• STATUS_UP ( type: esriFieldTypeString, alias: STATUS_UP, editable: true, nullable: true, length: 1500, defaultValue: null, modelName: STATUS_UP )
• STATUS_DT ( type: esriFieldTypeDate, alias: STATUS_DT, editable: true, nullable: true, length: 8, defaultValue: null, modelName: STATUS_DT )
• CostImage ( type: esriFieldTypeString, alias: CostImage, editable: true, nullable: false, length: 63, defaultValue: null, modelName: CostImage )
• ScheduleImage ( type: esriFieldTypeString, alias: ScheduleImage, editable: true, nullable: false, length: 63, defaultValue: null, modelName: ScheduleImage )
• ProjectImage ( type: esriFieldTypeString, alias: ProjectImage, editable: true, nullable: false, length: 63, defaultValue: null, modelName: ProjectImage )
• portal ( type: esriFieldTypeString, alias: portal, editable: true, nullable: true, length: 1, defaultValue: null, modelName: portal )
• globalid ( type: esriFieldTypeGUID, alias: globalid, editable: true, nullable: false, length: 38, defaultValue: {00000000-0000-0000-0000-000000000000}, modelName: globalid )
• Layer ( type: esriFieldTypeString, alias: Layer, editable: true, nullable: false, length: 2, defaultValue: null, modelName: Layer )
• lon ( type: esriFieldTypeDouble, alias: lon, editable: true, nullable: true, defaultValue: null, modelName: lon )
• lat ( type: esriFieldTypeDouble, alias: lat, editable: true, nullable: true, defaultValue: null, modelName: lat )

Types:

ID: Facilities
Name: Facilites
Domains:
Templates:
• Name: Facilities
  Description:
  Prototype:
  lon: null
  lat: null
  ProjectID: null
  ProjectName: null
  Category: Facilities
  ProjectStatus: null
  TotalBudget: null
  TotalActual: null
  PrimaryFundingSource: null
  Division: null
  DateStart: null
  DateEnd: null
  AssetCategory: null
  Description: null
  CostCheck: null
  ScheduleCheck: null
  ProjectOverallCheck: null
  ProjectPhoto: null
  PROJMANAGER: null
  CouncilDist: null
  STATUS_UP: null
  STATUS_DT: null
  CostImage:
  ScheduleImage:
  ProjectImage:
  portal: null
  globalid: {00000000-0000-0000-0000-000000000000}
  Layer:
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Neighborhoods
Name: Neighborhoods
Domains:
Templates:
• Name: Neighborhoods
  Description:
  Prototype:
  lon: null
  lat: null
  ProjectID: null
  ProjectName: null
  Category: Neighborhoods
  ProjectStatus: null
  TotalBudget: null
  TotalActual: null
  PrimaryFundingSource: null
  Division: null
  DateStart: null
  DateEnd: null
  AssetCategory: null
  Description: null
  CostCheck: null
  ScheduleCheck: null
  ProjectOverallCheck: null
  ProjectPhoto: null
  PROJMANAGER: null
  CouncilDist: null
  STATUS_UP: null
  STATUS_DT: null
  CostImage:
  ScheduleImage:
  ProjectImage:
  portal: null
  globalid: {00000000-0000-0000-0000-000000000000}
  Layer:
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Public Safety
Name: Public Safety
Domains:
Templates:
• Name: Public Safety
  Description:
  Prototype:
  lon: null
  lat: null
  ProjectID: null
  ProjectName: null
  Category: Public Safety
  ProjectStatus: null
  TotalBudget: null
  TotalActual: null
  PrimaryFundingSource: null
  Division: null
  DateStart: null
  DateEnd: null
  AssetCategory: null
  Description: null
  CostCheck: null
  ScheduleCheck: null
  ProjectOverallCheck: null
  ProjectPhoto: null
  PROJMANAGER: null
  CouncilDist: null
  STATUS_UP: null
  STATUS_DT: null
  CostImage:
  ScheduleImage:
  ProjectImage:
  portal: null
  globalid: {00000000-0000-0000-0000-000000000000}
  Layer:
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Quality of Life
Name: Quality of Life
Domains:
Templates:
• Name: Quality of Life
  Description:
  Prototype:
  lon: null
  lat: null
  ProjectID: null
  ProjectName: null
  Category: Quality of Life
  ProjectStatus: null
  TotalBudget: null
  TotalActual: null
  PrimaryFundingSource: null
  Division: null
  DateStart: null
  DateEnd: null
  AssetCategory: null
  Description: null
  CostCheck: null
  ScheduleCheck: null
  ProjectOverallCheck: null
  ProjectPhoto: null
  PROJMANAGER: null
  CouncilDist: null
  STATUS_UP: null
  STATUS_DT: null
  CostImage:
  ScheduleImage:
  ProjectImage:
  portal: null
  globalid: {00000000-0000-0000-0000-000000000000}
  Layer:
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Streets
Name: Streets
Domains:
Templates:
• Name: Streets
  Description:
  Prototype:
  lon: null
  lat: null
  ProjectID: null
  ProjectName: null
  Category: Streets
  ProjectStatus: null
  TotalBudget: null
  TotalActual: null
  PrimaryFundingSource: null
  Division: null
  DateStart: null
  DateEnd: null
  AssetCategory: null
  Description: null
  CostCheck: null
  ScheduleCheck: null
  ProjectOverallCheck: null
  ProjectPhoto: null
  PROJMANAGER: null
  CouncilDist: null
  STATUS_UP: null
  STATUS_DT: null
  CostImage:
  ScheduleImage:
  ProjectImage:
  portal: null
  globalid: {00000000-0000-0000-0000-000000000000}
  Layer:
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Traffic
Name: Traffic
Domains:
Templates:
• Name: Traffic
  Description:
  Prototype:
  lon: null
  lat: null
  ProjectID: null
  ProjectName: null
  Category: Traffic
  ProjectStatus: null
  TotalBudget: null
  TotalActual: null
  PrimaryFundingSource: null
  Division: null
  DateStart: null
  DateEnd: null
  AssetCategory: null
  Description: null
  CostCheck: null
  ScheduleCheck: null
  ProjectOverallCheck: null
  ProjectPhoto: null
  PROJMANAGER: null
  CouncilDist: null
  STATUS_UP: null
  STATUS_DT: null
  CostImage:
  ScheduleImage:
  ProjectImage:
  portal: null
  globalid: {00000000-0000-0000-0000-000000000000}
  Layer:
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Utilities
Name: Utilities
Domains:
Templates:
• Name: Utilities
  Description:
  Prototype:
  lon: null
  lat: null
  ProjectID: null
  ProjectName: null
  Category: Utilities
  ProjectStatus: null
  TotalBudget: null
  TotalActual: null
  PrimaryFundingSource: null
  Division: null
  DateStart: null
  DateEnd: null
  AssetCategory: null
  Description: null
  CostCheck: null
  ScheduleCheck: null
  ProjectOverallCheck: null
  ProjectPhoto: null
  PROJMANAGER: null
  CouncilDist: null
  STATUS_UP: null
  STATUS_DT: null
  CostImage:
  ScheduleImage:
  ProjectImage:
  portal: null
  globalid: {00000000-0000-0000-0000-000000000000}
  Layer:
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata