Layers:

Layer: Individual Projects (0)

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

---

Layer: Detour Route (1)

Name: Detour Route

Display Field: ProjectName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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: 5629404.020817965
YMin: 3595142.3120256364
XMax: 5701381.845365971
YMax: 3674628.9050206393
Spatial Reference: 102675  (3417)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: DetourStatus
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Active
  Label: Active Detour Route
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 3
• Value: Design
  Label: Planned Detour Route
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 3
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: DetourStatus

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ProjectName ( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ProjectName )
• DriveDirection ( type: esriFieldTypeString, alias: Driving Direction Detour, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DriveDirection , Coded Values: [NB: NORTHBOUND] , [SB: SOUTHBOUND] , [EB: EASTBOUND] , ...8 more... )
• StreetName ( type: esriFieldTypeString, alias: Road Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StreetName )
• DetourBegin ( type: esriFieldTypeDate, alias: Begins, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DetourBegin )
• DetourEnds ( type: esriFieldTypeDate, alias: Ends, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DetourEnds )
• DetourStatus ( type: esriFieldTypeString, alias: Detour Status, editable: true, nullable: true, length: 15, defaultValue: null, modelName: DetourStatus , Coded Values: [Design: Planned] , [Complete: Complete] , [Removed: Removed from Project List] , ...1 more... )
• 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 )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength(), required: true )
Types:
ID: Active
Name: Active Detour Route
Domains:
• DriveDirection:
  Inherited
• DetourStatus:
  Inherited
Templates:
• Name: Active Detour Route
  Description:
  Prototype:
  DetourEnds: null
  DetourStatus: Active
  ProjectName: null
  DriveDirection: null
  StreetName: null
  DetourBegin: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Design
Name: Planned Detour Route
Domains:
• DriveDirection:
  Inherited
• DetourStatus:
  Inherited
Templates:
• Name: Planned Detour Route
  Description:
  Prototype:
  DetourEnds: null
  DetourStatus: Design
  ProjectName: null
  DriveDirection: null
  StreetName: null
  DetourBegin: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Layer: Construction Area - Roads (2)

Name: Construction Area - Roads

Display Field: Office

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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: 5649439.177926049
YMin: 3630733.2516703904
XMax: 5691848.3047218025
YMax: 3678760.9784493893
Spatial Reference: 102675  (3417)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: Status
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:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 3
• Value: Design
  Label: Planned Construction Project
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 3
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: Status

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... )
• Contact ( type: esriFieldTypeString, alias: Project Contact, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Contact )
• Phone ( type: esriFieldTypeString, alias: Phone xxx.xxx.xxxx, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Phone )
• ProjectTitle ( type: esriFieldTypeString, alias: Project Title, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ProjectTitle )
• Description ( type: esriFieldTypeString, alias: Project Description, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Description )
• Status ( type: esriFieldTypeString, alias: Project Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Status , Coded Values: [Design: Planned] , [Complete: Complete] , [Removed: Removed from Project List] , ...1 more... )
• DesignBegin ( type: esriFieldTypeDate, alias: Starts, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DesignBegin )
• DesignEnd ( type: esriFieldTypeDate, alias: Ends, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DesignEnd )
• ConstructBegin ( type: esriFieldTypeDate, alias: Construction Begins, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ConstructBegin )
• ConstructEnd ( type: esriFieldTypeDate, alias: Construction Ends, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ConstructEnd )
• Year ( type: esriFieldTypeSmallInteger, alias: Year Scheduled, editable: true, nullable: true, defaultValue: null, modelName: Year )
• LaneClose ( type: esriFieldTypeSmallInteger, alias: Lane Closures?, editable: true, nullable: true, defaultValue: null, modelName: LaneClose , Coded Values: [0: No affect to traffic] , [1: Lane shift/some affect to traffic] , [2: Complete street closure] )
• Parking ( type: esriFieldTypeSmallInteger, alias: Parking Impact?, editable: true, nullable: true, defaultValue: null, modelName: Parking , 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] )
• RoadON ( type: esriFieldTypeString, alias: Road Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RoadON )
• FromAdd ( type: esriFieldTypeString, alias: From Address/Road, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FromAdd )
• ToAdd ( type: esriFieldTypeString, alias: To Address/Road, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ToAdd )
• LastUpdate ( type: esriFieldTypeDate, alias: Last Updated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastUpdate )
• Cost ( type: esriFieldTypeDouble, alias: Project Cost, editable: true, nullable: true, defaultValue: null, modelName: Cost )
• ProjectEmail ( type: esriFieldTypeString, alias: Email Contact, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ProjectEmail )
• ProjectWebsite ( type: esriFieldTypeString, alias: Project Website, editable: true, nullable: true, length: 300, defaultValue: null, modelName: ProjectWebsite )
• ProjectNotes ( type: esriFieldTypeString, alias: Project Update/Notes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ProjectNotes )
• 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 )
• ProjectType ( type: esriFieldTypeString, alias: Project Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectType , Coded Values: [Asphalt Overlay: Asphalt Overlay] , [Green Alley: Green Alley Construction] , [Sewer: Sewer Repair or Service] , ...30 more... )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )
Types:
ID: Active
Name: Active Construction Project
Domains:
• Office:
  Inherited
• Status:
  Inherited
• LaneClose:
  Inherited
• Parking:
  Inherited
• Detour:
  Inherited
• ProjectType:
  Inherited
Templates:
• Name: Active Construction Project
  Description:
  Prototype:
  Department: 1
  Description: null
  ProjectType: null
  Office: null
  Contact: null
  Phone: null
  ProjectTitle: null
  Status: Active
  DesignBegin: null
  DesignEnd: null
  ConstructBegin: null
  ConstructEnd: null
  Year: null
  LaneClose: null
  Parking: null
  Detour: null
  RoadON: null
  FromAdd: null
  ToAdd: null
  LastUpdate: null
  Cost: null
  ProjectEmail: null
  ProjectWebsite: null
  ProjectNotes: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Design
Name: Planned Construction Project
Domains:
• Office:
  Inherited
• Status:
  Inherited
• LaneClose:
  Inherited
• Parking:
  Inherited
• Detour:
  Inherited
• ProjectType:
  Inherited
Templates:
• Name: Planned Construction Project
  Description:
  Prototype:
  Department: 1
  Description: null
  ProjectType: null
  Office: null
  Contact: null
  Phone: null
  ProjectTitle: null
  Status: Design
  DesignBegin: null
  DesignEnd: null
  ConstructBegin: null
  ConstructEnd: null
  Year: null
  LaneClose: null
  Parking: null
  Detour: null
  RoadON: null
  FromAdd: null
  ToAdd: null
  LastUpdate: null
  Cost: null
  ProjectEmail: null
  ProjectWebsite: null
  ProjectNotes: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  
  Drawing Tool: esriFeatureEditToolLine

---