RAMS - Routes County Signed

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.iowa.gov
Id 4wsj-b7h8
Name RAMS - Routes County Signed
Attribution Iowa Department of Transportation - Office of Research & Analytics
Category Transportation & Utilities
Tags iowa dot, iowa department of transportation, rams, routes county signed, asset, classification
Created 2016-12-06T20:09:00Z
Publication Date 2016-12-06T20:10:44Z

Description

Routes County Signed data maintained inside the Roadway Asset Management System (RAMS).

Columns

| Included | Schema Type    | Field Name           | Name                 | Data Type  | Render Type |
| ======== | ============== | ==================== | ==================== | ========== | =========== |
| Yes      | series tag     | event_id             | EVENT_ID             | text       | text        |
| Yes      | series tag     | route_id             | ROUTE_ID             | text       | text        |
| Yes      | numeric metric | from_measure         | FROM_MEASURE         | number     | number      |
| Yes      | numeric metric | to_measure           | TO_MEASURE           | number     | number      |
| Yes      | time           | business_date        | BUSINESS_DATE        | date       | date        |
| No       |                | effective_start_date | EFFECTIVE_START_DATE | date       | date        |
| No       |                | effective_end_date   | EFFECTIVE_END_DATE   | date       | date        |
| Yes      | series tag     | user_create          | USER_CREATE          | text       | text        |
| Yes      | series tag     | user_mod             | USER_MOD             | text       | text        |
| No       |                | system_create_date   | SYSTEM_CREATE_DATE   | date       | date        |
| No       |                | system_mod_date      | SYSTEM_MOD_DATE      | date       | date        |
| Yes      | series tag     | route_name           | ROUTE_NAME           | text       | text        |
| Yes      | numeric metric | priority             | PRIORITY             | number     | number      |
| Yes      | series tag     | locerror             | LOCERROR             | text       | text        |
| Yes      | numeric metric | shape_len            | SHAPE.LEN            | number     | number      |
| Yes      | series tag     | objectid             | OBJECTID             | text       | number      |
| No       |                | shape                | SHAPE                | geospatial | geospatial  |

Time Field

Value = business_date
Format & Zone = seconds

Series Fields

Excluded Fields = effective_start_date,effective_end_date,system_create_date,system_mod_date,shape

Data Commands

series e:4wsj-b7h8 d:2016-01-01T06:00:00.000Z t:shape.longitude=-92.83676265699995 t:shape.needs_recoding=false t:route_id=C005046450E t:route_name="STATE OF IOWA, F 62, E" t:event_id=0000013652 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=41.58106971400008 t:user_mod=RAMS t:objectid=1 m:priority=1 m:to_measure=11.864993 m:from_measure=9.697205

series e:4wsj-b7h8 d:2016-01-01T06:00:00.000Z t:shape.longitude=-92.83676265699995 t:shape.needs_recoding=false t:route_id=C005046450E t:route_name="STATE OF IOWA, F 62, W" t:event_id=0000001786 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=41.58106971400008 t:user_mod=RAMS t:objectid=2 m:priority=2 m:to_measure=11.864993 m:from_measure=9.697205

series e:4wsj-b7h8 d:2016-01-01T06:00:00.000Z t:shape.longitude=-91.94894390799999 t:shape.needs_recoding=false t:route_id=C005141840N t:route_name="STATE OF IOWA, W 21, S" t:event_id=0000007853 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=41.021154557000045 t:user_mod=RAMS t:objectid=3 m:priority=2 m:to_measure=10.38941 m:from_measure=0

Meta Commands

metric m:from_measure p:decimal l:FROM_MEASURE d:"From Measure" t:dataTypeName=number

metric m:to_measure p:decimal l:TO_MEASURE d:"To Measure" t:dataTypeName=number

metric m:priority p:integer l:PRIORITY d:PRIORITY t:dataTypeName=number

metric m:shape_len p:long l:SHAPE.LEN d:"Length (Meter)" t:dataTypeName=number

entity e:4wsj-b7h8 l:"RAMS - Routes County Signed" t:attribution="Iowa Department of Transportation - Office of Research & Analytics" t:url=https://data.iowa.gov/api/views/4wsj-b7h8

property e:4wsj-b7h8 t:meta.view v:id=4wsj-b7h8 v:category="Transportation & Utilities" v:averageRating=0 v:name="RAMS - Routes County Signed" v:attribution="Iowa Department of Transportation - Office of Research & Analytics"

property e:4wsj-b7h8 t:meta.view.owner v:id=2cmj-63jw v:profileImageUrlMedium=/api/users/2cmj-63jw/profile_images/THUMB v:profileImageUrlLarge=/api/users/2cmj-63jw/profile_images/LARGE v:screenName="Iowa Department of Transportation" v:profileImageUrlSmall=/api/users/2cmj-63jw/profile_images/TINY v:displayName="Iowa Department of Transportation"

property e:4wsj-b7h8 t:meta.view.tableauthor v:id=2cmj-63jw v:profileImageUrlMedium=/api/users/2cmj-63jw/profile_images/THUMB v:profileImageUrlLarge=/api/users/2cmj-63jw/profile_images/LARGE v:screenName="Iowa Department of Transportation" v:profileImageUrlSmall=/api/users/2cmj-63jw/profile_images/TINY v:roleName=administrator v:displayName="Iowa Department of Transportation"

Top Records

| event_id   | route_id    | from_measure                                              | to_measure                                                | business_date | effective_start_date | effective_end_date | user_create | user_mod | system_create_date | system_mod_date | route_name             | priority | locerror | shape_len | objectid | shape                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 
| ========== | =========== | ========================================================= | ========================================================= | ============= | ==================== | ================== | =========== | ======== | ================== | =============== | ====================== | ======== | ======== | ========= | ======== | =================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================== | 
| 0000013652 | C005046450E | 9.697205000000000296722646453417837619781494140625        | 11.8649930000000001228954715770669281482696533203125      | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1460018841         | 1464712603      | STATE OF IOWA, F 62, E | 1        | NO ERROR |           | 1        | [null, 41.58106971400008, -92.83676265699995, null, false, {paths=[[[-92.83676265699995, 41.58106971400008], [-92.83592712499996, 41.58106776900007], [-92.83496556999995, 41.58108075500007], [-92.83437656099994, 41.58108746000005], [-92.83435484899996, 41.58108770600006], [-92.83406593899997, 41.58109099500007], [-92.83360366399995, 41.58110378500004], [-92.83121370099997, 41.58118583400005], [-92.82987222799994, 41.581227529000046], [-92.82870423999998, 41.58125164000006], [-92.82830005299996, 41.58123376900005], [-92.82803481199994, 41.58121004000003], [-92.82777080199997, 41.58117955000006], [-92.82750832499994, 41.58114233600003], [-92.82724768499997, 41.58109844300003], [-92.82698918499995, 41.58104791900007], [-92.82673311899998, 41.58099082500007], [-92.82647979399997, 41.58092722300006], [-92.82622949099994, 41.58085719300004], [-92.82598250599995, 41.58078081000008], [-92.82573912499998, 41.58069816400007], [-92.82556247699995, 41.580628587000035], [-92.82551204199996, 41.58060872300007], [-92.82531587299997, 41.58053145800005], [-92.82498745299995, 41.58037150900003], [-92.82440836299997, 41.58011403000006], [-92.82364445399998, 41.57977489900003], [-92.82343232499994, 41.579689347000055], [-92.82321592599999, 41.57961004900005], [-92.82299558799997, 41.57953712500006], [-92.82277164099997, 41.57947068400006], [-92.82254442699997, 41.57941082600007], [-92.82231428599994, 41.57935764500007], [-92.82208156899998, 41.579311215000075], [-92.82184662299994, 41.57927161300006], [-92.82042957399995, 41.579049404000045], [-92.81991568699999, 41.57897097500006], [-92.81960567799996, 41.57892366200008], [-92.81886000999998, 41.57881387200007], [-92.81815151099994, 41.57870120100006], [-92.81649119599996, 41.57846509400008], [-92.81529242599998, 41.57828440500003], [-92.81400299199998, 41.57809386200006], [-92.81233465299994, 41.57783905900004], [-92.81101655699996, 41.57762972000006], [-92.81025249399994, 41.57752627700006], [-92.80942883799997, 41.57744783900006], [-92.80918796299994, 41.577430641000035], [-92.80834946399995, 41.57743342800006], [-92.80726986099995, 41.57743998900003], [-92.80652911899995, 41.57744860400004], [-92.80598048599995, 41.57746100500003], [-92.80541091899994, 41.57747065400008], [-92.80418450999997, 41.57748416100003], [-92.80322365499995, 41.57749403300005], [-92.80264366199998, 41.57749835800007], [-92.80124618799994, 41.57750029500005], [-92.80028536099996, 41.57750752000004], [-92.79828000499998, 41.57750831200008], [-92.79590417899999, 41.57752252100005], [-92.79573223299997, 41.577522513000076]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | 
| 0000001786 | C005046450E | 9.697205000000000296722646453417837619781494140625        | 11.8649930000000001228954715770669281482696533203125      | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1460018837         | 1464712604      | STATE OF IOWA, F 62, W | 2        | NO ERROR |           | 2        | [null, 41.58106971400008, -92.83676265699995, null, false, {paths=[[[-92.83676265699995, 41.58106971400008], [-92.83592712499996, 41.58106776900007], [-92.83496556999995, 41.58108075500007], [-92.83437656099994, 41.58108746000005], [-92.83435484899996, 41.58108770600006], [-92.83406593899997, 41.58109099500007], [-92.83360366399995, 41.58110378500004], [-92.83121370099997, 41.58118583400005], [-92.82987222799994, 41.581227529000046], [-92.82870423999998, 41.58125164000006], [-92.82830005299996, 41.58123376900005], [-92.82803481199994, 41.58121004000003], [-92.82777080199997, 41.58117955000006], [-92.82750832499994, 41.58114233600003], [-92.82724768499997, 41.58109844300003], [-92.82698918499995, 41.58104791900007], [-92.82673311899998, 41.58099082500007], [-92.82647979399997, 41.58092722300006], [-92.82622949099994, 41.58085719300004], [-92.82598250599995, 41.58078081000008], [-92.82573912499998, 41.58069816400007], [-92.82556247699995, 41.580628587000035], [-92.82551204199996, 41.58060872300007], [-92.82531587299997, 41.58053145800005], [-92.82498745299995, 41.58037150900003], [-92.82440836299997, 41.58011403000006], [-92.82364445399998, 41.57977489900003], [-92.82343232499994, 41.579689347000055], [-92.82321592599999, 41.57961004900005], [-92.82299558799997, 41.57953712500006], [-92.82277164099997, 41.57947068400006], [-92.82254442699997, 41.57941082600007], [-92.82231428599994, 41.57935764500007], [-92.82208156899998, 41.579311215000075], [-92.82184662299994, 41.57927161300006], [-92.82042957399995, 41.579049404000045], [-92.81991568699999, 41.57897097500006], [-92.81960567799996, 41.57892366200008], [-92.81886000999998, 41.57881387200007], [-92.81815151099994, 41.57870120100006], [-92.81649119599996, 41.57846509400008], [-92.81529242599998, 41.57828440500003], [-92.81400299199998, 41.57809386200006], [-92.81233465299994, 41.57783905900004], [-92.81101655699996, 41.57762972000006], [-92.81025249399994, 41.57752627700006], [-92.80942883799997, 41.57744783900006], [-92.80918796299994, 41.577430641000035], [-92.80834946399995, 41.57743342800006], [-92.80726986099995, 41.57743998900003], [-92.80652911899995, 41.57744860400004], [-92.80598048599995, 41.57746100500003], [-92.80541091899994, 41.57747065400008], [-92.80418450999997, 41.57748416100003], [-92.80322365499995, 41.57749403300005], [-92.80264366199998, 41.57749835800007], [-92.80124618799994, 41.57750029500005], [-92.80028536099996, 41.57750752000004], [-92.79828000499998, 41.57750831200008], [-92.79590417899999, 41.57752252100005], [-92.79573223299997, 41.577522513000076]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | 
| 0000007853 | C005141840N | 0                                                         | 10.3894099999999998118482835707254707813262939453125      | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1460018839         | 1464712604      | STATE OF IOWA, W 21, S | 2        | NO ERROR |           | 3        | [null, 41.021154557000045, -91.94894390799999, null, false, {paths=[[[-91.94894390799999, 41.021154557000045], [-91.94821170299997, 41.02214845100008], [-91.94734014699998, 41.023458435000066], [-91.94602553299995, 41.02532450100006], [-91.94537969799995, 41.026270199000066], [-91.94420612699997, 41.02795942600005], [-91.94358949899998, 41.02886619000003], [-91.94207823399995, 41.031047697000076], [-91.94175972199997, 41.03152437400007], [-91.94151011899999, 41.03189791600005], [-91.94135376999998, 41.03211300400005], [-91.94046027799999, 41.033342126000036], [-91.93917522099997, 41.035140597000066], [-91.93854472499999, 41.03602926900004], [-91.93711312899995, 41.038025908000066], [-91.93622697199999, 41.03925554600005], [-91.93613605099995, 41.03938170400005], [-91.93535790499999, 41.04051500700007], [-91.93420871299998, 41.04215085000004], [-91.93340105399994, 41.04333020800004], [-91.93205120799996, 41.04525284300007], [-91.93108318199995, 41.04661587500004], [-91.93010576099994, 41.04797519600004], [-91.92905419299996, 41.04946933600007], [-91.92853547099998, 41.05021650100008], [-91.92817851899997, 41.050719221000065], [-91.92726828699995, 41.05202940000004], [-91.92641194999999, 41.05325809100003], [-91.92617908599999, 41.05366782500005], [-91.92584949499997, 41.05424775200004], [-91.92546086899995, 41.054885883000054], [-91.92520501499996, 41.05530777300004], [-91.92490011999996, 41.055804058000035], [-91.92447414099996, 41.05642379100004], [-91.92417673599994, 41.05680577100003], [-91.92398650799998, 41.05705338800004], [-91.92325730499994, 41.05790485400007], [-91.92236738899999, 41.05895428700006], [-91.92203201299998, 41.059342885000035], [-91.92145638299996, 41.06009280100005], [-91.92089044299996, 41.06083212600004], [-91.92056405899996, 41.06123872000006], [-91.91969539899998, 41.06238138700007], [-91.91914332299996, 41.06313162200007], [-91.91836730199998, 41.06415401700008], [-91.91817905599999, 41.06441014400008], [-91.91768324499998, 41.065084736000074], [-91.91673079799995, 41.066365646000065], [-91.91598810399995, 41.067374191000056], [-91.91474594599998, 41.069101508000074], [-91.91408076399995, 41.07002889700004], [-91.91300397599997, 41.07155830000005], [-91.91192224099996, 41.07309477700005], [-91.91103629799994, 41.07435154800004], [-91.91057105099998, 41.07502073400008], [-91.90974898099995, 41.07636777500005], [-91.90894777199998, 41.077825939000036], [-91.90841904199999, 41.07876951700007], [-91.90801320499997, 41.07951818500004], [-91.90781067799998, 41.07987643600006], [-91.90757464699999, 41.080252091000034], [-91.90740256499998, 41.08052496300007], [-91.90712270099999, 41.08095362800003], [-91.90685377399996, 41.081321668000044], [-91.90656131699996, 41.08168580100005], [-91.90641539199999, 41.08185535800004], [-91.90620122999997, 41.08210975900005], [-91.90590037399994, 41.08243086900006], [-91.90537598499998, 41.08300267100003], [-91.90462831699995, 41.08381443900004], [-91.90450421499997, 41.08394683700004], [-91.90396348899998, 41.08452368800005], [-91.90329873399997, 41.08522936000003], [-91.90244409699994, 41.08616116500008], [-91.90144909199995, 41.087226841000074], [-91.90127391699997, 41.08743173000005], [-91.90110871799999, 41.08761531000005], [-91.90094762699994, 41.08782397400006], [-91.90068720099998, 41.08822787300005], [-91.90016607599995, 41.08904639000008], [-91.89960608799998, 41.08990725900003], [-91.89923257599997, 41.09048832000008], [-91.89873521099997, 41.09130001800003], [-91.89852946599996, 41.09159385300006], [-91.89817651099997, 41.09210727000004], [-91.89769797999998, 41.09272974100003], [-91.89715625499997, 41.093422822000036], [-91.89675621599997, 41.09392841700003], [-91.89626829599996, 41.09454717500006], [-91.89539778699998, 41.09572897400005], [-91.89494586799998, 41.096419741000034], [-91.89485667999998, 41.09656703400003], [-91.89459598699995, 41.09699754900004], [-91.89388631799994, 41.09817089300003], [-91.89349292199995, 41.09878740500005], [-91.89333168899998, 41.09899963200007], [-91.89317615399995, 41.099172613000064], [-91.89298299899997, 41.09933790800005], [-91.89279518699999, 41.09947825200004], [-91.89258375299994, 41.09961826000006], [-91.89228718199996, 41.09976063300007], [-91.89200522899995, 41.09988533600006], [-91.89175259899997, 41.09997112900004], [-91.89145780199999, 41.100042020000046], [-91.89116808299997, 41.10009868000003], [-91.89094022999996, 41.10013834400007], [-91.89059461499994, 41.10016203300006], [-91.88999430499996, 41.10016422000007], [-91.88856226499996, 41.10016171400008], [-91.88648337999996, 41.10013209300007], [-91.88510865799998, 41.10011930400003], [-91.88360093599994, 41.10010525900003], [-91.88179109599997, 41.10009012000006], [-91.88060483199996, 41.10008745300007], [-91.88017915899997, 41.10009923600006], [-91.87965426899996, 41.100109599000064], [-91.87871733899999, 41.100153384000066], [-91.87634221099995, 41.10025161800007], [-91.87460099799995, 41.10032673200004], [-91.87311545699998, 41.10038404100004], [-91.87111365499999, 41.10048395700005], [-91.87073772299999, 41.10049995400004], [-91.86886649899998, 41.10057956900005], [-91.86721330899996, 41.10063472000007], [-91.86674740999996, 41.100663901000075], [-91.86643818299996, 41.100691752000046], [-91.86615240399999, 41.100730713000075], [-91.86592347699997, 41.10077408300003], [-91.86567055099994, 41.100827879000065], [-91.86548906999997, 41.100871933000064], [-91.86528359099998, 41.100926413000025], [-91.86497282099998, 41.101015276000055], [-91.86462756399999, 41.101153907000025], [-91.86441634299996, 41.10124779800003], [-91.86424316999995, 41.10133864800008], [-91.86410375699995, 41.101408442000036], [-91.86389189799996, 41.10152745700003], [-91.86371808899997, 41.101643428000045], [-91.86355385999997, 41.10175595000004], [-91.86336481599994, 41.10191119900003], [-91.86303508399999, 41.10218648600005], [-91.86275207599994, 41.10249117500007], [-91.86221013299996, 41.103086535000045], [-91.86195183799998, 41.10335208400005], [-91.86168377899997, 41.10362826200003], [-91.86133178199998, 41.10403248000006], [-91.86120386799996, 41.10421015400004], [-91.86109420599996, 41.10441681300006], [-91.86101839699995, 41.104598829000054], [-91.86097187599995, 41.10474895800007], [-91.86090857299996, 41.104999375000034], [-91.86088459599995, 41.10519650400005], [-91.86085202899994, 41.106108017000054], [-91.86079742799996, 41.107514698000045], [-91.86074666399998, 41.108957340000075], [-91.86069385799999, 41.11010553300008], [-91.86066847599994, 41.11080031600005], [-91.86063198099998, 41.11179934900008], [-91.86060260599999, 41.112771946000066], [-91.86059035999995, 41.113062780000064], [-91.86053114199996, 41.11446921400005], [-91.86051743699994, 41.11519788500004], [-91.86045038699996, 41.117282991000025], [-91.86039351799997, 41.11896610800005], [-91.86037235599997, 41.11998909300007], [-91.86032851899995, 41.12153237200005], [-91.86032373699999, 41.122096009000074], [-91.86026937099996, 41.12333739500008], [-91.86022237799995, 41.12441041100004], [-91.86017142599997, 41.12698405900005], [-91.86014305599997, 41.12810388400004], [-91.86014007399996, 41.129132629000026], [-91.86010372699997, 41.13019397000005], [-91.86002400399997, 41.132034099000066], [-91.86000500299997, 41.13297055400005], [-91.85994816699997, 41.13465370100005], [-91.85990799299998, 41.13567923200003], [-91.85986739999998, 41.13709446800004], [-91.85984841199996, 41.13821684100003], [-91.85979667599997, 41.13973715800006], [-91.85979104299997, 41.13990288800005]]]}] | 
| 0000004641 | C005147110E | 11.1909390000000001919033820740878582000732421875         | 16.201823000000000973841451923362910747528076171875       | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1460018838         | 1464712604      | STATE OF IOWA, H 17, W | 2        | NO ERROR |           | 4        | [null, 41.14837502000006, -91.96537737099999, null, false, {paths=[[[-91.96537737099999, 41.14837502000006], [-91.96343524499997, 41.14834951200004], [-91.95899001899994, 41.148314140000025], [-91.95771775899999, 41.14831112300004], [-91.95459173999996, 41.14829353700003], [-91.95120050799994, 41.14829011200004], [-91.94761068799994, 41.148283864000064], [-91.94609991499999, 41.148275873000046], [-91.94591288199996, 41.14827488100008], [-91.94317544899997, 41.14822655900008], [-91.94012629699995, 41.14815957500008], [-91.93784725799998, 41.148128162000035], [-91.93500607599998, 41.14806748500007], [-91.93210253199999, 41.14801588900008], [-91.93137510099996, 41.14800295100008], [-91.92855722199994, 41.147956736000026], [-91.92728411999997, 41.147943647000034], [-91.92657117499994, 41.14793631100008], [-91.92295834699996, 41.147903935000045], [-91.91874949799995, 41.14787385000005], [-91.91761405199998, 41.14785977200006], [-91.91647039499998, 41.14784558200006], [-91.91325518699995, 41.14780058000008], [-91.90938713499997, 41.14776061900005], [-91.90785820699995, 41.14774494400007], [-91.90750511899995, 41.14774132200006], [-91.90500887799999, 41.14769546700006], [-91.90160464399997, 41.147643895000044], [-91.89922617599996, 41.14761745200008], [-91.89812685499999, 41.14760002700007], [-91.89713639299998, 41.14758432000008], [-91.89468735899999, 41.14754248000003], [-91.89178424199997, 41.14750129200007], [-91.88899406999997, 41.14748308700007], [-91.88840487999994, 41.14747528600003], [-91.88537691399995, 41.147435151000025], [-91.88177831899998, 41.147401665000075], [-91.87971656599996, 41.14738291100008], [-91.87882570599999, 41.14737794700005], [-91.87808025799995, 41.14737378900003], [-91.87542221599995, 41.14736786900005], [-91.87148185299998, 41.14738278100003], [-91.86929863399996, 41.14735863000004]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | 
| 0000012261 | C005242180N | 0                                                         | 2.007912999999999836830966160050593316555023193359375     | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1460018840         | 1464712604      | STATE OF IOWA, W 66, S | 2        | NO ERROR |           | 5        | [null, 41.423884540000074, -91.47710751599999, null, false, {paths=[[[-91.47710751599999, 41.423884540000074], [-91.47709292899998, 41.42388484500003], [-91.47684061199999, 41.423901810000075], [-91.47659734199999, 41.423933239000064], [-91.47635339899995, 41.423986110000044], [-91.47614268899997, 41.42403957200003], [-91.47596013299994, 41.424104261000025], [-91.47573808499999, 41.424191620000045], [-91.47573405599996, 41.42419320600004], [-91.47554110399994, 41.424286315000074], [-91.47535222699997, 41.42440095000006], [-91.47520166799995, 41.42450554000004], [-91.47508976899996, 41.42458936400004], [-91.47494825699994, 41.42470841900007], [-91.47481115399995, 41.42483827900003], [-91.47468276299998, 41.42499332400007], [-91.47456849999998, 41.42515219400008], [-91.47447797799998, 41.42531148900008], [-91.47441628399997, 41.42546057000004], [-91.47435200199999, 41.425691845000074], [-91.47431665899995, 41.42590933400004], [-91.47430699599994, 41.42621667100008], [-91.47431172199998, 41.427275165000026], [-91.47431915099997, 41.42945647300007], [-91.47432140499996, 41.43059358600004], [-91.47430741199997, 41.43073636500003], [-91.47427170299994, 41.43081439500003], [-91.47422208199998, 41.43088145000007], [-91.47415843999994, 41.43094110200008], [-91.47407150499998, 41.43098603800007], [-91.47398027299994, 41.43101659400003], [-91.47383736799998, 41.431028352000055], [-91.47305363799995, 41.431021540000074], [-91.47140025599998, 41.43102066800003], [-91.46891554799998, 41.431015658000035], [-91.46686770299999, 41.43101840300005], [-91.46619805199998, 41.431010005000076], [-91.46605480499994, 41.43103247400006], [-91.46593496499997, 41.43106608900007], [-91.46581942099994, 41.43111408200008], [-91.46567425799998, 41.43119730300003], [-91.46558121499999, 41.43128503100007], [-91.46549665199996, 41.43140509300008], [-91.46542498099996, 41.431568293000055], [-91.46511502299995, 41.43265691600004], [-91.46491697799996, 41.433511543000066], [-91.46489177299998, 41.433707757000036], [-91.46488036399995, 41.43391851900003], [-91.46488717299997, 41.434454997000046], [-91.46490219299994, 41.436536329000035], [-91.46489258199995, 41.43894618600007], [-91.46489010199997, 41.44158143900006], [-91.46489620299997, 41.443945093000025], [-91.46488161599996, 41.445505135000076]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | 
| 0000006905 | C003741830S | 0                                                         | 0.1594029999999999891446833544250694103538990020751953125 | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1460018838         | 1464712627      | STATE OF IOWA, P 46, N | 1        | NO ERROR |           | 6        | [null, 41.91372682000008, -94.22021668799994, null, false, {paths=[[[-94.22021668799994, 41.91372682000008], [-94.22044140499997, 41.913707534000025], [-94.22064681899997, 41.91367407000007], [-94.22086172499996, 41.91363339700007], [-94.22100967399996, 41.913596720000044], [-94.22115745899998, 41.91354574300004], [-94.22132406699995, 41.91346605200005], [-94.22147631599995, 41.913386451000065], [-94.22162361599999, 41.913292581000064], [-94.22175652199996, 41.91319522800006], [-94.22184659899995, 41.913119591000054], [-94.22194576299995, 41.913001002000044], [-94.22202136099997, 41.91291473300004], [-94.22207315299994, 41.912839338000026], [-94.22213885799994, 41.91272453400006], [-94.22220415799995, 41.91257398400006], [-94.22224553299998, 41.912423586000045], [-94.22227741399996, 41.912280397000075]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | 
| 0000008976 | C003546350E | 9.5096709999999990969854479772038757801055908203125       | 11.3315520000000002909246177296154201030731201171875      | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1460018839         | 1464712627      | STATE OF IOWA, C 33, W | 2        | NO ERROR |           | 7        | [null, 42.75919743900005, -93.14259095699998, null, false, {paths=[[[-93.14259095699998, 42.75919743900005], [-93.14247520799995, 42.759284939000054], [-93.14234133099995, 42.75936009700007], [-93.14220182099996, 42.75942947300007], [-93.14205714099995, 42.75949283700004], [-93.14190776499998, 42.75954998200007], [-93.14175418799994, 42.75960071800006], [-93.14159691299994, 42.759644879000064], [-93.14143646199994, 42.75968232100007], [-93.14127335799998, 42.75971291800005], [-93.14110813999997, 42.759736572000065], [-93.14094135399995, 42.75975320300006], [-93.14077354699998, 42.75976275700003], [-93.14060527299995, 42.75976520100005], [-93.13974681399998, 42.75976969100003], [-93.13676894299994, 42.75977471500005], [-93.13282112399997, 42.75977302700005], [-93.12947468399994, 42.75977312500004], [-93.12589049799999, 42.75979023000008], [-93.12440162499996, 42.75978185300005], [-93.12384133299997, 42.75975250700003], [-93.12352891699999, 42.759736142000065], [-93.12257848199994, 42.759711614000025], [-93.12222940699996, 42.75971147300004], [-93.12188119499996, 42.75971133000007], [-93.12156286299995, 42.75971120000003], [-93.12132235699994, 42.75971110000006], [-93.12051738999997, 42.759709989000044], [-93.11942120599997, 42.759708465000074], [-93.11650640499994, 42.759709601000054], [-93.11264099799996, 42.75971464700007], [-93.10924608199997, 42.75971042500004], [-93.10734006599995, 42.759711149000054], [-93.10696391499994, 42.759710324000025]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | 
| 0000004263 | C003546350E | 14.161598999999998937937562004663050174713134765625       | 15.10511699999999990495780366472899913787841796875        | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1460018838         | 1464712627      | STATE OF IOWA, C 33, W | 2        | NO ERROR |           | 8        | [null, 42.76322829500003, -93.04545611499998, null, false, {paths=[[[-93.04545611499998, 42.76322829500003], [-93.04379178299996, 42.76322176800005], [-93.04155100099996, 42.763220097000044], [-93.03882526599995, 42.763209310000036], [-93.03522148999997, 42.763219966000065], [-93.03074480699996, 42.76321269400006], [-93.02808697399996, 42.76320192900005], [-93.02689964599995, 42.763204382000026]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | 
| 0000009958 | C003642170N | 0                                                         | 0.2477209999999999967545960544157424010336399078369140625 | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1460018840         | 1464712627      | STATE OF IOWA, M 21, S | 2        | NO ERROR |           | 9        | [null, 40.88356487300007, -95.42973098699997, null, false, {paths=[[[-95.42973098699997, 40.88356487300007], [-95.42973723499995, 40.88360921300006], [-95.42978059099994, 40.88391701200004], [-95.43008945899999, 40.886067722000064], [-95.43018660499996, 40.88664170700008], [-95.43024317999999, 40.88680163400005], [-95.43030308299996, 40.886915024000075], [-95.43041256599997, 40.88710423300006]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 
| 0000011838 | C003646160E | 0.1718329999999999857518417911705910228192806243896484375 | 0.69433699999999998198063622112385928630828857421875      | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1460018840         | 1464712627      | STATE OF IOWA, L 40, N | 1        | NO ERROR |           | 10       | [null, 40.65234501000003, -95.74577593399994, null, false, {paths=[[[-95.74577593399994, 40.65234501000003], [-95.74558914399995, 40.652330547000076], [-95.74512390499996, 40.65232715900004], [-95.74375174699998, 40.652312805000065], [-95.74274066799995, 40.65230792600005], [-95.74027667699994, 40.65228694700005], [-95.73803152599999, 40.652278797000065], [-95.73618938699997, 40.652261047000025], [-95.73583401399998, 40.652250034000076]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |