RAMS - Road Ownership

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.iowa.gov
Id 4fpq-c8sw
Name RAMS - Road Ownership
Attribution Iowa Department of Transportation - Office of Research & Analytics
Category Transportation & Utilities
Tags iowa dot, iowa department of transportation, rams, road ownership, asset, classification
Created 2016-12-06T19:51:37Z
Publication Date 2016-12-06T19:53:11Z

Description

Road Ownership 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     | owner_code           | OWNER_CODE           | 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:4fpq-c8sw d:2016-01-01T06:00:00.000Z t:shape.longitude=-95.19444419899997 t:owner_code=2 t:shape.needs_recoding=false t:route_id=C007341370N t:event_id=0000001958 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=40.771758789000046 t:user_mod=RAMS t:objectid=1 m:to_measure=11.202638 m:from_measure=6.273775

series e:4fpq-c8sw d:2016-01-01T06:00:00.000Z t:shape.longitude=-94.55091067199999 t:owner_code=2 t:shape.needs_recoding=false t:route_id=C007441490N t:event_id=0000002482 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=42.939328921000026 t:user_mod=RAMS t:objectid=2 m:to_measure=3.352897 m:from_measure=2.1050109999999997

series e:4fpq-c8sw d:2016-01-01T06:00:00.000Z t:shape.longitude=-93.22073161799995 t:owner_code=2 t:shape.needs_recoding=false t:route_id=M392746070E t:event_id=0000002656 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=43.35710474200005 t:user_mod=RAMS t:objectid=3 m:to_measure=1.006677 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:shape_len p:long l:SHAPE.LEN d:"Length (Meter)" t:dataTypeName=number

entity e:4fpq-c8sw l:"RAMS - Road Ownership" t:attribution="Iowa Department of Transportation - Office of Research & Analytics" t:url=https://data.iowa.gov/api/views/4fpq-c8sw

property e:4fpq-c8sw t:meta.view v:id=4fpq-c8sw v:category="Transportation & Utilities" v:averageRating=0 v:name="RAMS - Road Ownership" v:attribution="Iowa Department of Transportation - Office of Research & Analytics"

property e:4fpq-c8sw 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:4fpq-c8sw 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 | owner_code | locerror                           | shape_len | objectid | shape                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | 
| ========== | =========== | ================================================================ | ======================================================== | ============= | ==================== | ================== | =========== | ======== | ================== | =============== | ========== | ================================== | ========= | ======== | ===================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================== | 
| 0000001958 | C007341370N | 6.27377499999999965751840136363171041011810302734375             | 11.20263800000000031786839826963841915130615234375       | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459843017         | 1463759392      | 2          | NO ERROR                           |           | 1        | [null, 40.771758789000046, -95.19444419899997, null, false, {paths=[[[-95.19444419899997, 40.771758789000046], [-95.19443659599995, 40.77189429200007], [-95.19445458299998, 40.77335436100003], [-95.19445167699996, 40.775410126000054], [-95.19444210499995, 40.77811310000004], [-95.19443444799998, 40.78034769800007], [-95.19441906099996, 40.78264676600003], [-95.19443434899995, 40.785220663000075], [-95.19441912699995, 40.78577347200007], [-95.19440775699996, 40.78618636200008], [-95.19441574899997, 40.78757698700008], [-95.19439375999997, 40.78890013300003], [-95.19438308499997, 40.79011585500007], [-95.19439536999994, 40.790587593000055], [-95.19439620399999, 40.790980852000075], [-95.19436798099997, 40.791703462000044], [-95.19436778799997, 40.79241850100004], [-95.19437987799995, 40.793605281000055], [-95.19436547899994, 40.79467805100006], [-95.19434973699998, 40.79515736400003], [-95.19434744499995, 40.79597254000004], [-95.19434608499995, 40.79682345300006], [-95.19435734199999, 40.79761697500004], [-95.19434875899998, 40.799093656000025], [-95.19433701299994, 40.800087734000044], [-95.19433826499994, 40.800258978000045], [-95.19435542099995, 40.80260081500006], [-95.19436257199999, 40.80432037500003], [-95.19438370599994, 40.80477053100003], [-95.19440286699995, 40.80695110700003], [-95.19440619499994, 40.80924633200004], [-95.19444034699995, 40.81200229400008], [-95.19444414499998, 40.81395429300005], [-95.19444885099995, 40.81413491600006], [-95.19446211499996, 40.81464403600006], [-95.19445710699995, 40.81716105100003], [-95.19444786199995, 40.819334911000055], [-95.19443588699994, 40.81977841500003], [-95.19445584599998, 40.82180882900008], [-95.19445643299997, 40.82345698900008], [-95.19444454799998, 40.82426516400005], [-95.19447368799996, 40.82610595600005], [-95.19447791999994, 40.82681020800004], [-95.19448125799994, 40.82838324800008], [-95.19448361599996, 40.82868430700006], [-95.19448935399998, 40.82941636000004], [-95.19445542699998, 40.83064316700006], [-95.19445239399994, 40.831068661000074], [-95.19444638199997, 40.83137979500003], [-95.19446258699998, 40.832001637000076], [-95.19447390199997, 40.83261640400008], [-95.19446159699999, 40.83322795000004], [-95.19445287899998, 40.83379653700007], [-95.19445380199994, 40.83455446900007], [-95.19445262599999, 40.83577363300003], [-95.19444790799997, 40.836856993000026], [-95.19446000599999, 40.83840487800006], [-95.19446861199998, 40.839638197000056], [-95.19444902099997, 40.84177647000007], [-95.19445707699998, 40.842266153000025], [-95.19446326399998, 40.84304545700007], [-95.19446332499996, 40.84319805900003]]]}] | 
| 0000002482 | C007441490N | 2.105010999999999743437228971743024885654449462890625            | 3.352897000000000016228796084760688245296478271484375    | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459843017         | 1463759392      | 2          | NO ERROR                           |           | 2        | [null, 42.939328921000026, -94.55091067199999, null, false, {paths=[[[-94.55091067199999, 42.939328921000026], [-94.55091029199997, 42.94036953800003], [-94.55090836999995, 42.94287473900005], [-94.55090167699996, 42.94567659900008], [-94.55089160699998, 42.94798531400005], [-94.55088183999999, 42.95089440500004], [-94.55087989499998, 42.95214976900007], [-94.55087812499994, 42.953292400000066], [-94.55088039999998, 42.95401069400003], [-94.55088641499998, 42.95640859500003], [-94.55089698399996, 42.95704104600003], [-94.55091798599994, 42.95741096800003], [-94.55091798599994, 42.95741098000008]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | 
| 0000002656 | M392746070E | 0                                                                | 1.0066770000000000440110170529806055128574371337890625   | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459843017         | 1463759389      | 2          | NO ERROR                           |           | 3        | [null, 43.35710474200005, -93.22073161799995, null, false, {paths=[[[-93.22073161799995, 43.35710474200005], [-93.21987181999998, 43.35710269200007], [-93.21722785499998, 43.35709992200003], [-93.21309099199999, 43.35709053800008], [-93.21257921399996, 43.35708936900005], [-93.21187456799998, 43.35709017900007], [-93.21059621799998, 43.35709163800004], [-93.21038258999994, 43.357092703000035], [-93.21011637299995, 43.35709402800006], [-93.20910360599999, 43.35707455900007], [-93.20862314899995, 43.35706531900007], [-93.20792578899994, 43.35706218100006], [-93.20648077599998, 43.357055668000044], [-93.20311707099995, 43.35705077700004], [-93.20074530999995, 43.35703873500006]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | 
| 0000009949 | M449041030N | 0                                                                | 0.30271999999999998909316900608246214687824249267578125  | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459843020         | 1463759389      | 2          | NO ERROR                           |           | 4        | [null, 43.21840390800003, -94.32458424799995, null, false, {paths=[[[-94.32458424799995, 43.21840390800003], [-94.32456654699996, 43.219821901000046], [-94.32456627199997, 43.21984397600005], [-94.32457492099996, 43.220878377000076], [-94.32458190499995, 43.22171339000005], [-94.32458347499994, 43.22187839400004], [-94.32459213799996, 43.222789738000074]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 
| 0000006639 | M479746270E | 0.00148799999999999995638211292003916241810657083988189697265625 | 0.97961499999999990251353665371425449848175048828125     | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459843019         | 1463759389      | 4          | PARTIAL MATCH FOR THE FROM-MEASURE |           | 5        | [null, 42.01795906900003, -92.91222324499995, null, false, {paths=[[[-92.91222324499995, 42.01795906900003], [-92.91201283799995, 42.017961556000046], [-92.91111541699996, 42.01795145700004], [-92.91026334999998, 42.017941860000064], [-92.90985665099998, 42.017940957000064], [-92.90762039599997, 42.01793596300007], [-92.90658671699998, 42.017933639000034], [-92.90632709199997, 42.01793229700007], [-92.90520019599995, 42.01792646400003], [-92.90490423599994, 42.01792493000005], [-92.90307326199996, 42.01790470200007], [-92.90261657299999, 42.017909572000065], [-92.90194664899997, 42.017916712000044], [-92.90154415599994, 42.01792200400007], [-92.89941530299996, 42.01794996900003], [-92.89693657999999, 42.017994169000076], [-92.89439078099997, 42.018034388000046], [-92.89333515699997, 42.018039636000026]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 
| 0000001554 | M482241020N | 0.004249000000000000172584169177980584208853542804718017578125   | 1.4805629999999998513970922431326471269130706787109375   | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459843016         | 1463759389      | 4          | NO ERROR                           |           | 6        | [null, 43.14827551500008, -93.26061643499997, null, false, {paths=[[[-93.26061643499997, 43.14827551500008], [-93.26061723899994, 43.14834829200004], [-93.26061958699995, 43.14856110800008], [-93.26063671799994, 43.149186437000026], [-93.26062518999998, 43.15008454100007], [-93.26060838799998, 43.15192822900008], [-93.26058678799996, 43.153750466000076], [-93.26058424299998, 43.15569422500005], [-93.26056749599996, 43.15752361400007], [-93.26057464499996, 43.15948525500005], [-93.26057313699994, 43.16115745600007], [-93.26057537199995, 43.162705456000026], [-93.26057581399994, 43.16301189200004], [-93.26057283299997, 43.165069979000066], [-93.26055211399995, 43.166659956000046], [-93.26057002999994, 43.16708161500003], [-93.26056358599999, 43.16876809100006], [-93.26056015899997, 43.16966515000007]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | 
| 0000010933 | M487041110N | 0                                                                | 0.498884999999999967368324860217398963868618011474609375 | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459843021         | 1463759389      | 4          | NO ERROR                           |           | 7        | [null, 42.77385640800003, -91.87737364699996, null, false, {paths=[[[-91.87737364699996, 42.77385640800003], [-91.87731408399998, 42.77515855100006], [-91.87730635399998, 42.775351675000024], [-91.87723257599998, 42.77719479700005], [-91.87721667499994, 42.77752025400008], [-91.87717618399995, 42.77834889400003], [-91.87711982299999, 42.77950225600006], [-91.87708882899994, 42.780706545000044], [-91.87707914999999, 42.78108261600005]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 
| 0000003471 | M533047100E | 0                                                                | 0.54867399999999999504751713175210170447826385498046875  | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459843017         | 1463759389      | 4          | NO ERROR                           |           | 8        | [null, 41.432791112000075, -91.04058922599995, null, false, {paths=[[[-91.04058922599995, 41.432791112000075], [-91.04018909099995, 41.43301390900007], [-91.03958668499996, 41.43335849500005], [-91.03937354099997, 41.43346474600003], [-91.03910933199995, 41.433551340000065], [-91.03872869699995, 41.43367609300003], [-91.03794735599996, 41.43397746100004], [-91.03749584399998, 41.434103580000055], [-91.03691855699998, 41.434287770000026], [-91.03663135899995, 41.43439276000004], [-91.03510749699996, 41.43494981900005], [-91.03493293099996, 41.435013629000025], [-91.03443757799994, 41.43516739800003], [-91.03410192299998, 41.435245948000045], [-91.03378228899999, 41.43527835700007], [-91.03340880899998, 41.43529519800006], [-91.03249699499997, 41.435336309000036], [-91.03210896699994, 41.43533412900007], [-91.03179367099995, 41.43533235700005], [-91.03083397299997, 41.43531141100004]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 
| 0000008366 | M537546140E | 0                                                                | 0.366348999999999980214937522760010324418544769287109375 | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459843019         | 1463759389      | 4          | NO ERROR                           |           | 9        | [null, 42.95079330300007, -92.55912352199994, null, false, {paths=[[[-92.55912352199994, 42.95079330300007], [-92.55737748399997, 42.95079626000006], [-92.55475647799994, 42.95078625900004], [-92.55419472599999, 42.95082228800004], [-92.55419307199998, 42.95082239300007], [-92.55367265299998, 42.95088177400004], [-92.55313182399999, 42.951018729000054], [-92.55252226599998, 42.951246996000066], [-92.55210055799995, 42.95145912000004]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 
| 0000003713 | M552746130E | 0                                                                | 0.55419099999999998917843413437367416918277740478515625  | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459843017         | 1463759389      | 4          | NO ERROR                           |           | 10       | [null, 43.142722615000025, -93.00561104699995, null, false, {paths=[[[-93.00561104699995, 43.142722615000025], [-93.00433003799998, 43.142729909000025], [-93.00415404399996, 43.14273091100006], [-93.00311467699999, 43.14273082100004], [-93.00186266699995, 43.14273070300004], [-93.00157763299995, 43.14273067500005], [-93.00061207299996, 43.14273502200007], [-92.99994779899998, 43.14273800700005], [-92.99932211099997, 43.14273967300005], [-92.99788857599998, 43.14274347600008], [-92.99749825099997, 43.14274517700005], [-92.99582444299995, 43.142752459000064], [-92.99464565399995, 43.14275110600005]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |