RAMS - Adjacent County Number

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.iowa.gov
Id c4m7-9ycm
Name RAMS - Adjacent County Number
Attribution Iowa Department of Transportation - Office of Research & Analytics
Category Transportation & Utilities
Tags iowa dot, iowa department of transportation, rams, adjacent county number, asset, inventory
Created 2016-12-06T16:36:24Z
Publication Date 2016-12-06T16:38:35Z

Description

Adjacent County Number 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 | to_measure             | TO_MEASURE             | number     | number      |
| Yes      | numeric metric | from_measure           | FROM_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     | adjacent_county_number | ADJACENT_COUNTY_NUMBER | text       | 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:c4m7-9ycm d:2016-01-01T06:00:00.000Z t:shape.longitude=-91.83137915399999 t:shape.needs_recoding=false t:route_id=C005741000N t:event_id=0000000234 t:user_create=RWYLLIE t:adjacent_county_number=6 t:locerror="NO ERROR" t:shape.latitude=41.86184920900007 t:user_mod=RAMS t:objectid=1 m:to_measure=0.941668 m:from_measure=0

series e:c4m7-9ycm d:2016-01-01T06:00:00.000Z t:shape.longitude=-91.83238547199994 t:shape.needs_recoding=false t:route_id=C005747595E t:event_id=0000000141 t:user_create=RWYLLIE t:adjacent_county_number=6 t:locerror="NO ERROR" t:shape.latitude=42.22467723200003 t:user_mod=RAMS t:objectid=2 m:to_measure=0.12024 m:from_measure=0

series e:c4m7-9ycm d:2016-01-01T06:00:00.000Z t:shape.longitude=-91.48514197599997 t:shape.needs_recoding=false t:route_id=C005841000N t:event_id=0000000164 t:user_create=RWYLLIE t:adjacent_county_number=92 t:locerror="NO ERROR" t:shape.latitude=41.27143059800005 t:user_mod=RAMS t:objectid=3 m:to_measure=11.533598999999999 m:from_measure=7.020397999999999

Meta Commands

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

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

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

entity e:c4m7-9ycm l:"RAMS - Adjacent County Number" t:attribution="Iowa Department of Transportation - Office of Research & Analytics" t:url=https://data.iowa.gov/api/views/c4m7-9ycm

property e:c4m7-9ycm t:meta.view d:2017-06-09T13:53:06.812Z v:id=c4m7-9ycm v:category="Transportation & Utilities" v:averageRating=0 v:name="RAMS - Adjacent County Number" v:attribution="Iowa Department of Transportation - Office of Research & Analytics"

property e:c4m7-9ycm t:meta.view.owner d:2017-06-09T13:53:06.812Z 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:c4m7-9ycm t:meta.view.tableauthor d:2017-06-09T13:53:06.812Z 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    | to_measure                                                 | from_measure                                           | business_date | effective_start_date | effective_end_date | user_create | user_mod | system_create_date | system_mod_date | adjacent_county_number | locerror | shape_len | objectid | shape                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | 
| ========== | =========== | ========================================================== | ====================================================== | ============= | ==================== | ================== | =========== | ======== | ================== | =============== | ====================== | ======== | ========= | ======== | ========================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================== | 
| 0000000234 | C005741000N | 0.94166799999999994952304405160248279571533203125          | 0                                                      | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459761536         | 1463659328      | 6                      | NO ERROR |           | 1        | [null, 41.86184920900007, -91.83137915399999, null, false, {paths=[[[-91.83137915399999, 41.86184920900007], [-91.83138812799996, 41.86211298200004], [-91.83139586399994, 41.863650465000035], [-91.83141754599995, 41.865020111000035], [-91.83142249799994, 41.866114218000064], [-91.83144492499997, 41.86745527200003], [-91.83146946799997, 41.86853178800004], [-91.83147308799994, 41.869112391000044], [-91.83147928699998, 41.87017298200004], [-91.83149014299994, 41.87181339400007], [-91.83149090699999, 41.87192861200003], [-91.83149678599995, 41.87280455000007], [-91.83149690699997, 41.872822506000034], [-91.83149702599997, 41.872840462000056], [-91.83150069899995, 41.873387466000054], [-91.83152223199994, 41.87439600500005], [-91.83154755499999, 41.87549800000005]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 
| 0000000141 | C005747595E | 0.12023999999999999965805130841545178554952144622802734375 | 0                                                      | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459761536         | 1463659328      | 6                      | NO ERROR |           | 2        | [null, 42.22467723200003, -91.83238547199994, null, false, {paths=[[[-91.83238547199994, 42.22467723200003], [-91.83238372399995, 42.22400986900004], [-91.83240807699997, 42.22308071200007], [-91.83239700299998, 42.22301381800003], [-91.83233778499994, 42.22294861000006], [-91.83233777399994, 42.22294860400007]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 
| 0000000164 | C005841000N | 11.533598999999998824250724283047020435333251953125        | 7.02039799999999925006477496935985982418060302734375   | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459761536         | 1463659328      | 92                     | NO ERROR |           | 3        | [null, 41.27143059800005, -91.48514197599997, null, false, {paths=[[[-91.48514197599997, 41.27143059800005], [-91.48514340699995, 41.272521330000075], [-91.48514323099994, 41.273286523000024], [-91.48513596899994, 41.27473454400007], [-91.48512292099997, 41.27545659800006], [-91.48510578399998, 41.277676790000044], [-91.48512276599996, 41.27910736200005], [-91.48509689599996, 41.279936460000044], [-91.48509735899995, 41.28102469100003], [-91.48509759899997, 41.281584861000056], [-91.48505582699994, 41.283683042000064], [-91.48502358299999, 41.28562763900004], [-91.48499440299997, 41.28762592600003], [-91.48499406099995, 41.28824451300005], [-91.48494860299996, 41.290156695000064], [-91.48492813899998, 41.29066050100005], [-91.48492358999994, 41.29243168200003], [-91.48491801399996, 41.29305237600005], [-91.48491991399999, 41.29324662400006], [-91.48492130699998, 41.29338884200007], [-91.48491378099999, 41.29407192700006], [-91.48490097899997, 41.29517610400006], [-91.48489298899995, 41.29619145400005], [-91.48489643499994, 41.29699246800004], [-91.48486915699999, 41.29801820500006], [-91.48485771499998, 41.298840408000046], [-91.48483014999994, 41.30033097900008], [-91.48483010699994, 41.30051352700008], [-91.48482997099995, 41.30109617100004], [-91.48482314999995, 41.30222596400006], [-91.48480098699997, 41.30399911000006], [-91.48478580099999, 41.30509299900007], [-91.48477948499999, 41.30605474600003], [-91.48477139199997, 41.30646580600006], [-91.48476714199995, 41.30725640800006], [-91.48476949199994, 41.30779284100004], [-91.48477180799995, 41.30832204300003], [-91.48475622899997, 41.309533472000055], [-91.48474505899998, 41.31049870800007], [-91.48474197199994, 41.311660750000044], [-91.48475422499996, 41.31248337400007], [-91.48472604099999, 41.313841635000074], [-91.48472329399999, 41.31468902300003], [-91.48472644799995, 41.31595487000004], [-91.48471287599995, 41.317148908000036], [-91.48471586699998, 41.31826815000005], [-91.48471378399995, 41.31939802800008], [-91.48472062599996, 41.32024201200005], [-91.48471670299995, 41.32127889100008], [-91.48470960299994, 41.322265654000034], [-91.48470908199994, 41.322331328000075], [-91.48470636099995, 41.32267322400003], [-91.48470393099996, 41.324421691000055], [-91.48469253099995, 41.325698008000074], [-91.48468927699997, 41.32671344500005], [-91.48469165499995, 41.32770037600005], [-91.48468896099996, 41.328697945000044], [-91.48469847899997, 41.329760091000026], [-91.48469951999994, 41.33078990700005], [-91.48470178799994, 41.33178041300005], [-91.48469624899997, 41.33271714400007], [-91.48469617399996, 41.33378269700006], [-91.48469381199999, 41.33476954500003], [-91.48468810999998, 41.33555966900008], [-91.48468535999996, 41.33640705800008], [-91.48467837199996, 41.33684905700005]]]}] | 
| 0000000722 | C005942060N | 13.6941709999999989832986102555878460407257080078125       | 13.4099769999999995917505657416768372058868408203125   | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459761536         | 1463659328      | 59                     | NO ERROR |           | 4        | [null, 41.11141829600007, -93.09895571699997, null, false, {paths=[[[-93.09895571699997, 41.11141829600007], [-93.09889686499997, 41.111468873000035], [-93.09881585399995, 41.111575826000035], [-93.09875352499995, 41.111718592000045], [-93.09871007799995, 41.11186500000008], [-93.09869861099997, 41.112190257000066], [-93.09869469599994, 41.11358437000007], [-93.09870722299996, 41.114613924000025], [-93.09870649799996, 41.11549329400003]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 
| 0000000320 | C006141000N | 3.345920000000000005258016244624741375446319580078125      | 0                                                      | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459761536         | 1463659328      | 1                      | NO ERROR |           | 5        | [null, 41.24374718300004, -94.24170503199997, null, false, {paths=[[[-94.24170503199997, 41.24374718300004], [-94.24170540699998, 41.24432987500006], [-94.24170192399998, 41.244851822000044], [-94.24169990799999, 41.246739338000054], [-94.24169022599995, 41.24878419700008], [-94.24167369299994, 41.25105788800005], [-94.24168242999997, 41.253608616000065], [-94.24169081399998, 41.255989389000035], [-94.24169056099998, 41.25803061400006], [-94.24169068699996, 41.258159298000066], [-94.24169233899994, 41.25983588400004], [-94.24167098499998, 41.26210246000005], [-94.24164550199998, 41.26359690100003], [-94.24164554999999, 41.264426257000025], [-94.24162837499995, 41.26623165400008], [-94.24164342899996, 41.266717732000075], [-94.24163689099998, 41.26738626500003], [-94.24162774999996, 41.268240708000064], [-94.24163675499994, 41.268612431000065], [-94.24164818499997, 41.269195051000054], [-94.24162269399994, 41.26986370900005], [-94.24160948699995, 41.27036426900003], [-94.24162228799997, 41.27065374700004], [-94.24160487699999, 41.27120080800006], [-94.24161136199996, 41.27176558800005], [-94.24158917299997, 41.27230910500003], [-94.24158873999994, 41.27254804200004], [-94.24158659499994, 41.27373547600007], [-94.24157568799995, 41.27443621100008], [-94.24156879999998, 41.27548725400004], [-94.24154925899995, 41.276674222000054], [-94.24155297699997, 41.27741061100005], [-94.24158085299996, 41.27777506100006], [-94.24157601599995, 41.27817904700004], [-94.24155123599996, 41.278497370000025], [-94.24151528099998, 41.27908030000003], [-94.24150855299996, 41.279319857000075], [-94.24148086399998, 41.28021016800005], [-94.24147912199999, 41.28047114300006], [-94.24148907199998, 41.28092507900004], [-94.24151834699995, 41.281411063000064], [-94.24148134299998, 41.282315736000044], [-94.24150075299997, 41.28318071600006], [-94.24148649799997, 41.28400301800008], [-94.24149708699997, 41.28492525300004], [-94.24149840399997, 41.285865423000075], [-94.24150396799996, 41.28676266800005], [-94.24150881399999, 41.288010248000035], [-94.24155024299995, 41.28955430100007], [-94.24154606499997, 41.29084126500004], [-94.24153346899999, 41.29139544700007], [-94.24151950799995, 41.292242404000035]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 
| 0000000828 | C006147560E | 0.416435999999999972853714780285372398793697357177734375   | 0                                                      | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459761536         | 1463659328      | 25                     | NO ERROR |           | 6        | [null, 41.50369177500005, -94.24159086999998, null, false, {paths=[[[-94.24159086999998, 41.50369177500005], [-94.23986583299995, 41.50368296500005], [-94.23730743499999, 41.50368287500004], [-94.23472359699997, 41.50367574200004], [-94.23390556999999, 41.503666716000055], [-94.23359490799999, 41.50366871800003], [-94.23356111399994, 41.50366984000004]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 
| 0000000210 | C006241000N | 4.708876000000000061618266045115888118743896484375         | 4.61830499999999943838702165521681308746337890625      | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459761536         | 1463659328      | 63                     | NO ERROR |           | 7        | [null, 41.34806696100003, -92.87074374399998, null, false, {paths=[[[-92.87074374399998, 41.34806696100003], [-92.87074782499997, 41.34829122200006], [-92.87074947599996, 41.348770253000055], [-92.87074985099997, 41.349379818000045]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 
| 0000000907 | C003846280E | 21.101043999999998135308487690053880214691162109375        | 20.062062999999998424982550204731523990631103515625    | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459761536         | 1463659328      | 7                      | NO ERROR |           | 8        | [null, 42.469615625000074, -92.55432084199998, null, false, {paths=[[[-92.55432084199998, 42.469615625000074], [-92.55265590799996, 42.469611722000025], [-92.54950427899996, 42.46961528700007], [-92.54637404299996, 42.469611721000035], [-92.54321171899994, 42.46960815600005], [-92.54014565599994, 42.46961528700007], [-92.53697263699996, 42.46961885300004], [-92.53462673099995, 42.469612013000074], [-92.53453048099999, 42.46961173400007], [-92.53452691699994, 42.469611722000025], [-92.53398144399995, 42.46960815700004]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | 
| 0000000713 | C003846350E | 23.115892999999999801730155013501644134521484375           | 20.098502999999997342683855094946920871734619140625    | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459761536         | 1463659328      | 12                     | NO ERROR |           | 9        | [null, 42.555876166000076, -92.61345150899996, null, false, {paths=[[[-92.61345150899996, 42.555876166000076], [-92.61296127799994, 42.55588185100004], [-92.61019105499997, 42.55588561600007], [-92.60636198799995, 42.55589544800006], [-92.60199151399996, 42.55590095400004], [-92.59576937099996, 42.555909721000035], [-92.59350192999995, 42.55591344000004], [-92.58965871599997, 42.55589758700006], [-92.58557354799996, 42.55589756900008], [-92.58208784499999, 42.55589858500008], [-92.58031301099999, 42.555890387000034], [-92.57885376699994, 42.55588362700007], [-92.57767412499999, 42.555884959000025], [-92.57487011299997, 42.555884037000055], [-92.57410557199995, 42.55588080600006], [-92.57202275299994, 42.55587197700004], [-92.56931053699998, 42.55587523100007], [-92.56178842999998, 42.55584669800004], [-92.55844270099999, 42.55586243400006], [-92.55584633699999, 42.55587703500004], [-92.55430202199994, 42.555871882000076]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | 
| 0000000915 | C003941070N | 4.0231189999999994455492924316786229610443115234375        | 0.9948509999999999298125885616173036396503448486328125 | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459761536         | 1463659328      | 5                      | NO ERROR |           | 10       | [null, 41.51855126500004, -94.70065970399997, null, false, {paths=[[[-94.70065970399997, 41.51855126500004], [-94.70066541199998, 41.51956293100005], [-94.70067861899997, 41.52027065000004], [-94.70066755699997, 41.52120742900007], [-94.70068448099994, 41.52236914100007], [-94.70067859899996, 41.52307348700003], [-94.70068993899997, 41.52368112600004], [-94.70068716299994, 41.524042235000024], [-94.70068423499998, 41.52465002500003], [-94.70070053099994, 41.52526833600007], [-94.70068419999996, 41.525922741000045], [-94.70069782799999, 41.52639807800006], [-94.70067965599998, 41.52746363500006], [-94.70069980299996, 41.52854308500008], [-94.70069809399996, 41.52896138400007], [-94.70069894999995, 41.53002674000004], [-94.70068341899997, 41.53072403700003], [-94.70069489399998, 41.531338823000056], [-94.70068334399997, 41.53250440900007], [-94.70068895899999, 41.53296206600004], [-94.70069246499997, 41.53324792500007], [-94.70068671199994, 41.53395941800005], [-94.70067863199995, 41.535310871000036], [-94.70068726699998, 41.53628319200004], [-94.70069010199995, 41.53770960600008], [-94.70068352899995, 41.53863203600008], [-94.70068950099994, 41.54022644300005], [-94.70070457999998, 41.54103424400006], [-94.70066822099994, 41.54240029600004], [-94.70067060999997, 41.54354786000005], [-94.70068700999997, 41.545446035000055], [-94.70070547499995, 41.54668995700007], [-94.70070663999996, 41.547381218000055], [-94.70070925299996, 41.54893147000007], [-94.70069889399997, 41.54939633300006], [-94.70069737299997, 41.55084424200004], [-94.70068541599994, 41.551223323000045], [-94.70069744699998, 41.551612876000036], [-94.70072168399997, 41.55189147400006], [-94.70071425099997, 41.55353249700005], [-94.70070929999997, 41.55428688500007], [-94.70072436399994, 41.55534851400006], [-94.70069105999994, 41.556113923000055], [-94.70071983799994, 41.556635577000065], [-94.70072537699997, 41.55693224600003], [-94.70072027099997, 41.557933312000046], [-94.70072277499997, 41.559341853000035], [-94.70072650799995, 41.56132596200007], [-94.70072204399997, 41.561818591000076], [-94.70071717799999, 41.56235567300007], [-94.70070680099997, 41.56244381500005]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |