View In:   ArcGIS Online Map Viewer

Name: Infrastructure Projects

Display Field: proj_name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: This layer includes planned, in-construction, and completed infrastructure projects from across the Metro Omaha area. The data is updated regularly by Omaha Public Works, the Douglas County Engineer, and various fiber contractors.

Service Item Id: ce1732b6b9cc447483f57f22f906941c

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

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

Extent:

XMin: 2617758.554160297
YMin: 479916.9997288883
XMax: 2778069.1682497263
YMax: 594262.5712341368
Spatial Reference: 102704  (26852)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: organization
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 0
  Label: Omaha Public Works
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [0, 230, 169, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 3
  Label: Fiber Projects
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [85, 255, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 4
  Label: Private
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [112, 168, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 5
  Label: OPW Street Preservation
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [168, 0, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 7
  Label: DC Engineer
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 85, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
Transparency: 0
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

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: organization

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• organization ( nullable: true, editable: true, defaultValue: 0, type: esriFieldTypeSmallInteger, modelName: ORGANIZATION, alias: Organization )
• proj_type ( nullable: true, editable: true, defaultValue: null, length: 35, type: esriFieldTypeString, modelName: PROJ_TYPE, alias: Project Type )
• proj_id ( nullable: true, editable: true, defaultValue: null, length: 25, type: esriFieldTypeString, modelName: PROJ_ID, alias: Project ID )
• proj_id2 ( nullable: true, editable: true, defaultValue: null, length: 25, type: esriFieldTypeString, modelName: PROJ_ID2, alias: Project ID2 )
• proj_name ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: PROJ_NAME, alias: Project Name )
• proj_desc ( nullable: true, editable: true, defaultValue: null, length: 300, type: esriFieldTypeString, modelName: PROJ_DESC, alias: Project Description )
• proj_link ( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: CONST_START_DATE, alias: Project Link )
• current_phase ( nullable: true, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, modelName: PROJ_MANAGER, alias: Current Phase )
• const_duration_months ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, modelName: PROJ_DETAILS, alias: Construction Duration in Months )
• contact ( nullable: true, editable: true, defaultValue: null, length: 35, type: esriFieldTypeString, modelName: PHASE_END_DATE, alias: Contact )
• contact_phone ( nullable: true, editable: true, defaultValue: null, length: 25, type: esriFieldTypeString, modelName: PHASE_DURATION, alias: Contact Phone )
• contact_email ( nullable: true, editable: true, defaultValue: null, length: 40, type: esriFieldTypeString, modelName: CONTACT_EMAIL, alias: Contact Email )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• created_user ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
• created_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
• last_edited_user ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
• last_edited_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
• show_on_proj_viewer ( nullable: true, editable: true, defaultValue: null, length: 3, type: esriFieldTypeString, modelName: SHOW_ON_PROJ_VIEWER, alias: Show on Project Viewer? , Coded Values: [Yes: Yes] , [No: No] )
• opw_proj_number ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: opw_proj_number, alias: OPW Project Number )
• design_proj_mgr ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: design_proj_mgr, alias: Design Project Manager )
• city_const_mgr ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: city_const_mgr, alias: City Construction Manager )
• const_start_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: const_start_date, alias: Construction Start Date )
• const_end_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: const_end_date, alias: Construction End Date )
• design_start_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: design_start_date, alias: Design Start Date )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• SHAPE__Area ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )

Types:

ID: 0
Name: Omaha Public Works
Domains:
• proj_type:
  Coded Values: [CSO: CSO] , [Environmental: Environmental] , [Facility: Facility] , ...5 more...
• current_phase:
  Coded Values: [Design: Design] , [Construction: Construction] , [LTCP: LTCP] , ...1 more...
Templates:
• Name: Omaha Public Works
  Description:
  Prototype:
  proj_type: null
  const_start_date: null
  design_start_date: null
  proj_id2: null
  contact_phone: null
  proj_link: null
  proj_desc: null
  current_phase: Design
  city_const_mgr: null
  design_proj_mgr: null
  const_end_date: null
  proj_id: null
  contact_email: null
  opw_proj_number: null
  const_duration_months: null
  organization: 0
  proj_name: null
  contact: null
  show_on_proj_viewer: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 3
Name: Fiber Projects
Domains:
• current_phase:
  Coded Values: [Design: Design] , [Construction: Construction] , [LTCP: LTCP] , ...1 more...
Templates:
• Name: Fiber Projects
  Description:
  Prototype:
  proj_type: Fiber
  const_start_date: null
  design_start_date: null
  proj_id2: null
  contact_phone: null
  proj_link: null
  proj_desc: null
  current_phase: Construction
  city_const_mgr: null
  design_proj_mgr: null
  const_end_date: null
  proj_id: null
  contact_email: null
  opw_proj_number: null
  const_duration_months: null
  organization: 3
  proj_name: null
  contact: null
  show_on_proj_viewer: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 4
Name: Private
Domains:
• current_phase:
  Coded Values: [Design: Design] , [Construction: Construction] , [LTCP: LTCP] , ...1 more...
Templates:
• Name: Private
  Description:
  Prototype:
  proj_type: Private
  const_start_date: null
  design_start_date: null
  proj_id2: null
  contact_phone: null
  proj_link: null
  proj_desc: null
  current_phase: null
  city_const_mgr: null
  design_proj_mgr: null
  const_end_date: null
  proj_id: null
  contact_email: null
  opw_proj_number: null
  const_duration_months: null
  organization: 4
  proj_name: null
  contact: null
  show_on_proj_viewer: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 5
Name: OPW Street Preservation
Domains:
• proj_type:
  Coded Values: [Resurfacing: Resurfacing] , [Concrete Repair: Concrete Repair] , [Brick Restoration: Brick Restoration] , ...2 more...
• current_phase:
  Coded Values: [Design: Design] , [Construction: Construction] , [LTCP: LTCP] , ...1 more...
• show_on_proj_viewer:
  Inherited
Templates:
• Name: OPW Street Preservation
  Description:
  Prototype:
  proj_type: null
  const_start_date: null
  design_start_date: null
  proj_id2: null
  contact_phone: null
  proj_link: null
  proj_desc: null
  current_phase: null
  city_const_mgr: null
  design_proj_mgr: null
  const_end_date: null
  proj_id: null
  contact_email: null
  opw_proj_number: null
  const_duration_months: null
  organization: 5
  proj_name: null
  contact: null
  show_on_proj_viewer: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 7
Name: DC Engineer
Domains:
• proj_type:
  Coded Values: [Signal: Signal] , [Paving: Paving] , [Resurfacing: Resurfacing] , ...2 more...
• current_phase:
  Coded Values: [Design: Design] , [Construction: Construction] , [LTCP: LTCP] , ...1 more...
Templates:
• Name: DC Engineer
  Description:
  Prototype:
  proj_type: null
  const_start_date: null
  design_start_date: null
  proj_id2: null
  contact_phone: null
  proj_link: null
  proj_desc: null
  current_phase: null
  city_const_mgr: null
  design_proj_mgr: null
  const_end_date: null
  proj_id: null
  contact_email: null
  opw_proj_number: null
  const_duration_months: null
  organization: 7
  proj_name: null
  contact: null
  show_on_proj_viewer: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

Capabilities: Query,Extract

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:

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