Name: PublicWorks.DBO.Routes

Display Field: FullRoadName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 10440

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

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: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CenterlineID ( type: esriFieldTypeInteger, alias: CenterlineID )
• RouteID ( type: esriFieldTypeString, alias: RouteID, length: 10 )
• FullRoadName ( type: esriFieldTypeString, alias: FullRoadName, length: 125 )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, length: 30 , Coded Values: [CEDAR RAPIDS: CEDAR RAPIDS] , [COUNTY: COUNTY] , [PRIVATE: PRIVATE] , ...6 more... )
• EmergencyRoute ( type: esriFieldTypeString, alias: EmergencyRoute, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Priority ( type: esriFieldTypeSmallInteger, alias: Priority )
• Response01 ( type: esriFieldTypeString, alias: Response01, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Response02 ( type: esriFieldTypeString, alias: Response02, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• AllPlowRouteName ( type: esriFieldTypeString, alias: AllPlowRouteName, length: 10 )
• PriorityRouteName ( type: esriFieldTypeString, alias: PriorityRouteName, length: 40 )
• Supervisor ( type: esriFieldTypeString, alias: Supervisor, length: 30 , Coded Values: [SW: Brett Lerch] , [NW: Breck Raim] , [SE: Tyler Adams] , ...1 more... )
• Status ( type: esriFieldTypeString, alias: Status, length: 30 )
• Mileage ( type: esriFieldTypeDouble, alias: Mileage )
• LaneCount ( type: esriFieldTypeDouble, alias: LaneCount )
• LaneMileage ( type: esriFieldTypeDouble, alias: LaneMileage )
• SurfaceType ( type: esriFieldTypeString, alias: SurfaceType, length: 40 , Coded Values: [Concrete: Concrete] , [Asphalt: Asphalt] , [Chip and Seal: Chip and Seal] , ...7 more... )
• SurfaceWidth ( type: esriFieldTypeDouble, alias: SurfaceWidth )
• MasterSymbology ( type: esriFieldTypeSmallInteger, alias: MasterSymbology )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 100 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 30 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 30 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• PretreatRoute ( type: esriFieldTypeString, alias: PretreatRoute, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SweepingRoute ( type: esriFieldTypeString, alias: SweepingRoute, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• LastSweptDate ( type: esriFieldTypeDate, alias: Last Swept Date, length: 8 )
• MaintenanceAgreement ( type: esriFieldTypeString, alias: MaintenanceAgreement, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata