View In:   ArcGIS Online Map Viewer

Name: Capital Improvement Projects

Display Field: project

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: Capital Improvement Projects

Service Item Id: ef02f404248e40b6a241408dd6f4dd43

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 166184.1973154284
YMin: 1704024.866866529
XMax: 215920.35735734552
YMax: 1728577.4440736175
Spatial Reference: 2244  (2965)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: currentphase
Field 2: N/A
Field 3: N/A
Field Delimiter: N/A
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Construction
  Label: Construction
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [237, 81, 81, 255]
  Outline:
  Style: esriSLSSolid
  Color: [153, 153, 153, 64]
  Width: 0
• Value: Design
  Label: Design
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [20, 158, 206, 255]
  Outline:
  Style: esriSLSSolid
  Color: [153, 153, 153, 64]
  Width: 0
• Value: Pre-Design
  Label: Pre-Design
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [167, 198, 54, 255]
  Outline:
  Style: esriSLSSolid
  Color: [153, 153, 153, 64]
  Width: 0
Transparency: 51
Labeling Info:

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: true
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
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

Time Info:

Start Time Field: startcons
End Time Field: substantialcomp
Track ID Field: null
Time Extent:
[2022/09/05 04:00:00 UTC, 2026/10/05 04:00:00 UTC]

Time Reference:
Time Zone: UTC
Respects Daylight Saving: false

Time Interval: 0
Time Interval Units: null
Has Live Data: false
Export Options:
Use Time: false
Time Data Cumulative: false
Time Offset: 0 (esriTimeUnitsUnknown)

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: currentphase

Fields:

• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: OBJECTID )
• project ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Project, type: esriFieldTypeString )
• projectnumber ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Number, type: esriFieldTypeString )
• currentphase ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Current Phase, type: esriFieldTypeString )
• fedaid ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Federal Aid?, type: esriFieldTypeString )
• departmentpm ( nullable: true, editable: true, defaultValue: null, length: 255, alias: DepartmentPM, type: esriFieldTypeString )
• designconsultant ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Design Consultant, type: esriFieldTypeString )
• contractor ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Contractor, type: esriFieldTypeString )
• constructionins ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Construction Inspector, type: esriFieldTypeString )
• biddate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Bid Date, type: esriFieldTypeDate )
• startcons ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Start Construction, type: esriFieldTypeDate )
• substantialcomp ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Substantial Completion, type: esriFieldTypeDate )
• fullclosure ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Full Closure, type: esriFieldTypeString )
• originalbudget ( nullable: true, editable: true, defaultValue: null, alias: Awarded Bid Amount, type: esriFieldTypeDouble )
• currentbudget ( nullable: true, editable: true, defaultValue: null, alias: Final Construction Invoiced Amount, type: esriFieldTypeDouble )
• invoicedtodate ( nullable: true, editable: true, defaultValue: null, alias: Invoiced to Date, type: esriFieldTypeDouble )
• councildistrict ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Council District, type: esriFieldTypeString )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• plansets ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Plan Link, type: esriFieldTypeString )
• datecomplete ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Final Completion, type: esriFieldTypeDate )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: globalid )

Types:

ID: Construction
Name: Construction
Domains:
Templates:
• Name: Construction
  Description:
  Prototype:
  designconsultant: null
  contractor: null
  substantialcomp: null
  projectnumber: null
  constructionins: null
  departmentpm: null
  currentbudget: null
  project: null
  invoicedtodate: null
  councildistrict: null
  originalbudget: null
  startcons: null
  biddate: null
  plansets: null
  currentphase: Construction
  fullclosure: null
  fedaid: null
  datecomplete: null
  
  Drawing Tool: N/A

---

ID: Design
Name: Design
Domains:
Templates:
• Name: Design
  Description:
  Prototype:
  designconsultant: null
  contractor: null
  substantialcomp: null
  projectnumber: null
  constructionins: null
  departmentpm: null
  currentbudget: null
  project: null
  invoicedtodate: null
  councildistrict: null
  originalbudget: null
  startcons: null
  biddate: null
  plansets: null
  currentphase: Design
  fullclosure: null
  fedaid: null
  datecomplete: null
  
  Drawing Tool: N/A

---

ID: Pre-Design
Name: Pre-Design
Domains:
Templates:
• Name: Pre-Design
  Description:
  Prototype:
  designconsultant: null
  contractor: null
  substantialcomp: null
  projectnumber: null
  constructionins: null
  departmentpm: null
  currentbudget: null
  project: null
  invoicedtodate: null
  councildistrict: null
  originalbudget: null
  startcons: null
  biddate: null
  plansets: null
  currentphase: Pre-Design
  fullclosure: null
  fedaid: null
  datecomplete: null
  
  Drawing Tool: N/A

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

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: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata