View In:   ArcGIS Online Map Viewer

Name: Centerline Rumble Strips

Display Field: state_route_name_1

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Inventory of centerline rumble strip locations for the State of Iowa. Routes inventoried are primary road network locations (excluding routes that are multi-lane and within incorporated city limits).Original linework was an extract of Iowa Department of Transportation RAMS road network as of February 2022.

Service Item Id: abbe6b7833ec42de878e02bbd8d6004d

Copyright Text: Iowa Department of Transportation

Default Visibility: true

MaxRecordCount: 2000

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: -1.0757095924E7
YMin: 4922100.191299997
XMax: -1.00366681513E7
YMax: 5388546.4657000005
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: cl_status
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Existing Locations
  Label: Existing Locations
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 0, 0, 255]
  Width: 4
• Value: None Present - Potential for Installation
  Label: None Present - Potential for Installation
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 4
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: false
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: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: cl_status

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• id ( modelName: id, nullable: true, editable: true, defaultValue: null, length: 38, alias: ID, type: esriFieldTypeString )
• routeid ( modelName: routeid, nullable: true, editable: true, defaultValue: null, length: 15, alias: RouteID, type: esriFieldTypeString , Coded Values: [S001910029N: I 29 N] , [S001910029S: I 29 S] , [S001910035N: I 35 N] , ...271 more... )
• frommeasure ( modelName: frommeasure, nullable: true, editable: true, defaultValue: null, alias: From Measure, type: esriFieldTypeDouble )
• tomeasure ( modelName: tomeasure, nullable: true, editable: true, defaultValue: null, alias: To Measure, type: esriFieldTypeDouble )
• cl_status ( modelName: cl_status, nullable: true, editable: true, defaultValue: null, length: 255, alias: Centerline Status, type: esriFieldTypeString )
• installyear ( modelName: installyear, nullable: true, editable: true, defaultValue: null, alias: Year Installed, type: esriFieldTypeSmallInteger )
• location ( modelName: location, nullable: true, editable: true, defaultValue: null, length: 80, alias: Location, type: esriFieldTypeString )
• projecttype ( modelName: projecttype, nullable: true, editable: true, defaultValue: null, length: 255, alias: ProjectType, type: esriFieldTypeString )
• project ( modelName: project, nullable: true, editable: true, defaultValue: null, length: 80, alias: Project, type: esriFieldTypeString )
• frommp ( modelName: frommp, nullable: true, editable: true, defaultValue: null, length: 80, alias: From Milepost, type: esriFieldTypeString )
• tomp ( modelName: tomp, nullable: true, editable: true, defaultValue: null, length: 80, alias: To Milepost, type: esriFieldTypeString )
• startinglatitude ( modelName: startinglatitude, nullable: true, editable: true, defaultValue: null, alias: Starting Latitude, type: esriFieldTypeDouble )
• endinglatitude ( modelName: endinglatitude, nullable: true, editable: true, defaultValue: null, alias: Ending Latitude, type: esriFieldTypeDouble )
• startinglongitude ( modelName: startinglongitude, nullable: true, editable: true, defaultValue: null, alias: StartingLongitude, type: esriFieldTypeDouble )
• endinglongitude ( modelName: endinglongitude, nullable: true, editable: true, defaultValue: null, alias: EndingLongitude, type: esriFieldTypeDouble )
• county ( modelName: county, nullable: true, editable: true, defaultValue: null, alias: County, type: esriFieldTypeInteger , Coded Values: [1: 01-Adair] , [2: 02-Adams] , [3: 03-Allamakee] , ...96 more... )
• dotdistrictnumber ( modelName: dotdistrictnumber, nullable: true, editable: true, defaultValue: null, alias: DOT District, type: esriFieldTypeInteger , Coded Values: [1: 1-District 1 (Central)] , [2: 2-District 2 (Northeast)] , [3: 3-District 3 (Northwest)] , ...3 more... )
• mpoorrpa ( modelName: mpoorrpa, nullable: true, editable: true, defaultValue: null, alias: MPO or RPA, type: esriFieldTypeInteger , Coded Values: [1: 1-Upper Explorerland Regional Planning Commission] , [2: 2-North Iowa Area Council of Governments] , [3: 3-Northwest Iowa Planning and Development Commission] , ...24 more... )
• city ( modelName: city, nullable: true, editable: true, defaultValue: null, alias: City, type: esriFieldTypeInteger , Coded Values: [15: 0015-Ackley] , [17: 0017-Ackworth] , [22: 0022-Adair] , ...947 more... )
• urbanorrural ( modelName: urbanorrural, nullable: true, editable: true, defaultValue: null, alias: Urban or Rural, type: esriFieldTypeInteger , Coded Values: [1: 1-Urban] , [2: 2-Rural] )
• state_route_name_1 ( modelName: state_route_name_1, nullable: true, editable: true, defaultValue: null, length: 255, alias: STATE_ROUTE_NAME_1, type: esriFieldTypeString )
• state_route_name_2 ( modelName: state_route_name_2, nullable: true, editable: true, defaultValue: null, length: 255, alias: STATE_ROUTE_NAME_2, type: esriFieldTypeString )
• secondary_route_name_1 ( modelName: secondary_route_name_1, nullable: true, editable: true, defaultValue: null, length: 255, alias: SECONDARY_ROUTE_NAME_1, type: esriFieldTypeString )
• secondary_route_name_2 ( modelName: secondary_route_name_2, nullable: true, editable: true, defaultValue: null, length: 255, alias: SECONDARY_ROUTE_NAME_2, type: esriFieldTypeString )
• municipal_route_name_1 ( modelName: municipal_route_name_1, nullable: true, editable: true, defaultValue: null, length: 255, alias: MUNICIPAL_ROUTE_NAME_1, type: esriFieldTypeString )
• municipal_route_name_2 ( modelName: municipal_route_name_2, nullable: true, editable: true, defaultValue: null, length: 255, alias: MUNICIPAL_ROUTE_NAME_2, type: esriFieldTypeString )
• county_signed_route_1 ( modelName: county_signed_route_1, nullable: true, editable: true, defaultValue: null, length: 255, alias: COUNTY_SIGNED_ROUTE_1, type: esriFieldTypeString )
• county_signed_route_2 ( modelName: county_signed_route_2, nullable: true, editable: true, defaultValue: null, length: 255, alias: COUNTY_SIGNED_ROUTE_2, type: esriFieldTypeString )
• run_date ( modelName: run_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: RUN_DATE, type: esriFieldTypeDate )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: globalid, type: esriFieldTypeGlobalID )
• 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 )

Types:

ID: Existing Locations
Name: Existing Locations
Domains:
• mpoorrpa:
  Inherited
• routeid:
  Inherited
• city:
  Inherited
• county:
  Inherited
• dotdistrictnumber:
  Inherited
• urbanorrural:
  Inherited
Templates:
• Name: Existing Locations
  Description:
  Prototype:
  endinglongitude: null
  frommp: null
  city: null
  startinglatitude: null
  county: null
  project: null
  urbanorrural: null
  installyear: null
  tomeasure: null
  endinglatitude: null
  state_route_name_1: null
  state_route_name_2: null
  projecttype: null
  id: null
  county_signed_route_1: null
  county_signed_route_2: null
  mpoorrpa: null
  startinglongitude: null
  tomp: null
  secondary_route_name_2: null
  secondary_route_name_1: null
  routeid: null
  frommeasure: null
  location: null
  dotdistrictnumber: null
  cl_status: Existing Locations
  municipal_route_name_1: null
  run_date: null
  municipal_route_name_2: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: None Present - Potential for Installation
Name: None Present - Potential for Installation
Domains:
• mpoorrpa:
  Inherited
• routeid:
  Inherited
• city:
  Inherited
• county:
  Inherited
• dotdistrictnumber:
  Inherited
• urbanorrural:
  Inherited
Templates:
• Name: None Present - Potential for Installation
  Description:
  Prototype:
  endinglongitude: null
  frommp: null
  city: null
  startinglatitude: null
  county: null
  project: null
  urbanorrural: null
  installyear: null
  tomeasure: null
  endinglatitude: null
  state_route_name_1: null
  state_route_name_2: null
  projecttype: null
  id: null
  county_signed_route_1: null
  county_signed_route_2: null
  mpoorrpa: null
  startinglongitude: null
  tomp: null
  secondary_route_name_2: null
  secondary_route_name_1: null
  routeid: null
  frommeasure: null
  location: null
  dotdistrictnumber: null
  cl_status: None Present - Potential for Installation
  municipal_route_name_1: null
  run_date: null
  municipal_route_name_2: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Extract,ChangeTracking

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