View In:   ArcGIS Online Map Viewer

Name: Individual Projects

Display Field: RoadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: b97d7458a55b4960a5815531b079bb7d

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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: 5649632.356017381
YMin: 3626586.4046491385
XMax: 5690396.602572724
YMax: 3677416.923066646
Spatial Reference: 102675  (3417)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ProjectStatus
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Active
  Label: Active Construction Project
  Description: N/A
  Symbol:
  
• Value: Design
  Label: Planned Construction Project
  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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: ProjectStatus

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Office ( type: esriFieldTypeString, alias: Department, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Office , Coded Values: [CLERK: City Clerk] , [EMERGENCY MANAGEMENT: Emergency Management] , [ENGINEERING: Engineering] , ...7 more... )
• ProjectContact ( type: esriFieldTypeString, alias: Project Contact for Non-City Project, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectContact )
• Phone ( type: esriFieldTypeString, alias: Phone, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Phone , Coded Values: [Engineering: 563.589.4270] , [Parks: 563.589.4263] , [Parking: 563.589.4266] , ...6 more... )
• ProjectTitle ( type: esriFieldTypeString, alias: Project Title, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ProjectTitle )
• ProjectType ( type: esriFieldTypeString, alias: Project Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ProjectType , Coded Values: [Asphalt Overlay: Asphalt Overlay] , [Green Alley: Green Alley Construction] , [Sewer: Sewer Repair or Service] , ...30 more... )
• Description ( type: esriFieldTypeString, alias: Project Description, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Description )
• ProjectStatus ( type: esriFieldTypeString, alias: Project Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ProjectStatus , Coded Values: [Design: Planned] , [Complete: Complete] , [Removed: Removed from Project List] , ...1 more... )
• DesignPhaseStart ( type: esriFieldTypeDate, alias: Begins, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DesignPhaseStart )
• DesignPhaseEnd ( type: esriFieldTypeDate, alias: Ends, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DesignPhaseEnd )
• LaneClosures ( type: esriFieldTypeSmallInteger, alias: Lane Closures?, editable: true, nullable: true, defaultValue: null, modelName: LaneClosures , Coded Values: [0: No affect to traffic] , [1: Lane shift/some affect to traffic] , [2: Complete street closure] )
• ParkingImpact ( type: esriFieldTypeSmallInteger, alias: Is Parking Affected?, editable: true, nullable: true, defaultValue: null, modelName: ParkingImpact , Coded Values: [0: No] , [1: Yes] )
• Detour ( type: esriFieldTypeSmallInteger, alias: Detour?, editable: true, nullable: true, defaultValue: null, modelName: Detour , Coded Values: [0: No] , [1: Yes] )
• RoadName ( type: esriFieldTypeString, alias: Road Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RoadName )
• AtRoadName ( type: esriFieldTypeString, alias: @ Intersection or Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AtRoadName )
• LastUpdate ( type: esriFieldTypeDate, alias: Info Last Updated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastUpdate )
• Cost ( type: esriFieldTypeDouble, alias: Cost ($), editable: true, nullable: true, defaultValue: null, modelName: Cost )
• ProjectNotes ( type: esriFieldTypeString, alias: Project Notes/Update, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ProjectNotes )
• SegmentID ( type: esriFieldTypeSmallInteger, alias: Segment ID, editable: true, nullable: true, defaultValue: null, modelName: SegmentID )
• Funding ( type: esriFieldTypeString, alias: Funding, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Funding )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Types:

ID: Active
Name: Active Construction Project
Domains:
• Office:
  Inherited
• Phone:
  Inherited
• ProjectType:
  Inherited
• ProjectStatus:
  Inherited
• LaneClosures:
  Inherited
• ParkingImpact:
  Inherited
• Detour:
  Inherited
Templates:
• Name: Active Construction Project
  Description:
  Prototype:
  Department: 1
  Description: null
  last_edited_user: null
  Office: null
  ProjectContact: null
  Phone: null
  ProjectTitle: null
  ProjectType: null
  ProjectStatus: Active
  DesignPhaseStart: null
  DesignPhaseEnd: null
  LaneClosures: null
  ParkingImpact: null
  Detour: null
  RoadName: null
  AtRoadName: null
  LastUpdate: null
  Cost: null
  ProjectNotes: null
  SegmentID: null
  Funding: null
  created_user: null
  created_date: null
  last_edited_date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Design
Name: Planned Construction Project
Domains:
• Office:
  Inherited
• Phone:
  Inherited
• ProjectType:
  Inherited
• ProjectStatus:
  Inherited
• LaneClosures:
  Inherited
• ParkingImpact:
  Inherited
• Detour:
  Inherited
Templates:
• Name: Planned Construction Project
  Description:
  Prototype:
  Department: 1
  Description: null
  last_edited_user: null
  Office: null
  ProjectContact: null
  Phone: null
  ProjectTitle: null
  ProjectType: null
  ProjectStatus: Design
  DesignPhaseStart: null
  DesignPhaseEnd: null
  LaneClosures: null
  ParkingImpact: null
  Detour: null
  RoadName: null
  AtRoadName: null
  LastUpdate: null
  Cost: null
  ProjectNotes: null
  SegmentID: null
  Funding: null
  created_user: null
  created_date: null
  last_edited_date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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