RAMS - Urban Area Code

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.iowa.gov
Id 8jn5-wpse
Name RAMS - Urban Area Code
Attribution Iowa Department of Transportation - Office of Research & Analytics
Category Transportation & Utilities
Tags iowa dot, iowa department of transportation, rams, urban area code, asset, inventory
Created 2016-12-06T20:59:16Z
Publication Date 2016-12-06T21:00:57Z

Description

Urban Area Code 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     | urban_area_code      | URBAN_AREA_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:8jn5-wpse d:2016-01-01T06:00:00.000Z t:shape.longitude=-90.68004825399998 t:urban_area_code=206 t:shape.needs_recoding=false t:route_id=M210042810N t:event_id=0000007133 t:user_create=JDENKER t:locerror="NO ERROR" t:shape.latitude=42.44211464000006 t:user_mod=RAMS t:objectid=1 m:to_measure=0.463412 m:from_measure=0.007552

series e:8jn5-wpse d:2016-01-01T06:00:00.000Z t:shape.longitude=-90.71624351099996 t:urban_area_code=206 t:shape.needs_recoding=false t:route_id=M210047095E t:event_id=0000003578 t:user_create=JDENKER t:locerror="NO ERROR" t:shape.latitude=42.50835114200004 t:user_mod=RAMS t:objectid=2 m:to_measure=0.059805 m:from_measure=0

series e:8jn5-wpse d:2016-01-01T06:00:00.000Z t:shape.longitude=-92.93545577399999 t:urban_area_code=876 t:shape.needs_recoding=false t:route_id=M479747030E t:event_id=0000026768 t:user_create=JDENKER t:locerror="NO ERROR" t:shape.latitude=42.045489736000036 t:user_mod=RAMS t:objectid=3 m:to_measure=0.176371 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:8jn5-wpse l:"RAMS - Urban Area Code" t:attribution="Iowa Department of Transportation - Office of Research & Analytics" t:url=https://data.iowa.gov/api/views/8jn5-wpse

property e:8jn5-wpse t:meta.view v:id=8jn5-wpse v:category="Transportation & Utilities" v:averageRating=0 v:name="RAMS - Urban Area Code" v:attribution="Iowa Department of Transportation - Office of Research & Analytics"

property e:8jn5-wpse 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:8jn5-wpse 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 | urban_area_code | locerror | shape_len | objectid | shape                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | 
| ========== | =========== | ============================================================ | ========================================================= | ============= | ==================== | ================== | =========== | ======== | ================== | =============== | =============== | ======== | ========= | ======== | ====================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================== | 
| 0000007133 | M210042810N | 0.0075519999999999996853627948212306364439427852630615234375 | 0.463411999999999990595966892215074039995670318603515625  | 1451628000    | 1451606401           |                    | JDENKER     | RAMS     | 1459761331         | 1464282532      | 206             | NO ERROR |           | 1        | [null, 42.44211464000006, -90.68004825399998, null, false, {paths=[[[-90.68004825399998, 42.44211464000006], [-90.67992625599999, 42.44211583100008], [-90.67879209999995, 42.44212691100006], [-90.67857089899996, 42.44212954200003], [-90.67819850499995, 42.44224288800007], [-90.67791868499995, 42.44245708700004], [-90.67776733199997, 42.44269826800007], [-90.67772873199999, 42.44297650100003], [-90.67773358599999, 42.44316379900005], [-90.67777654899999, 42.44482218400003], [-90.67777930999995, 42.44653273700004], [-90.67778327599996, 42.44655284800007], [-90.67781913299996, 42.44673467100006], [-90.67796742599995, 42.44695711600008], [-90.67821605099994, 42.447181414000056], [-90.67827751499999, 42.44723686300006]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | 
| 0000003578 | M210047095E | 0                                                            | 0.05980499999999999705124764659558422863483428955078125   | 1451628000    | 1451606401           |                    | JDENKER     | RAMS     | 1459761329         | 1464282532      | 206             | NO ERROR |           | 2        | [null, 42.50835114200004, -90.71624351099996, null, false, {paths=[[[-90.71624351099996, 42.50835114200004], [-90.71596442499998, 42.50832297100004], [-90.71521520599998, 42.507967810000025]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 
| 0000026768 | M479747030E | 0                                                            | 0.176370999999999999996447286321199499070644378662109375  | 1451628000    | 1451606401           |                    | JDENKER     | RAMS     | 1459761337         | 1464282512      | 876             | NO ERROR |           | 3        | [null, 42.045489736000036, -92.93545577399999, null, false, {paths=[[[-92.93545577399999, 42.045489736000036], [-92.93543369899999, 42.044992138000055], [-92.93540055599999, 42.04490202900007], [-92.93534084699996, 42.04483146600006], [-92.93522449899996, 42.04476905700005], [-92.93494948399996, 42.044739598000035], [-92.93465948499994, 42.044698821000054], [-92.93451262499997, 42.04467561100006], [-92.93438843999996, 42.04464689100007], [-92.93418117299996, 42.04463181600005], [-92.93403768399997, 42.044653596000046], [-92.93400357399997, 42.044673104000026], [-92.93393522499997, 42.044726172000026], [-92.93389294899998, 42.04481590700004], [-92.93388423799996, 42.04494797000007], [-92.93387042999996, 42.04522898100004], [-92.93387576799995, 42.04548942000008]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                | 
| 0000015323 | M479747480E | 0                                                            | 0.4977519999999999722462007412104867398738861083984375    | 1451628000    | 1451606401           |                    | JDENKER     | RAMS     | 1459761333         | 1464282512      | 876             | NO ERROR |           | 4        | [null, 42.06264260300003, -92.90809220099999, null, false, {paths=[[[-92.90809220099999, 42.06264260300003], [-92.90797759499998, 42.062632474000054], [-92.90782412099998, 42.062629300000026], [-92.90768641599999, 42.06265003900006], [-92.90720247899998, 42.06276192900003], [-92.90658363099999, 42.06290160000003], [-92.90622183399995, 42.06298325500006], [-92.90548792699997, 42.06315103900005], [-92.90518956599999, 42.06321756600005], [-92.90464189199997, 42.06333968400003], [-92.90389013699996, 42.063509199000066], [-92.90336463799997, 42.063618475000055], [-92.90301844199996, 42.06370484900003], [-92.90283254199994, 42.06374916000004], [-92.90251458799997, 42.06389287300004], [-92.90215792399994, 42.064072130000056], [-92.90136737299997, 42.064480282000034], [-92.90117462499995, 42.064572215000055], [-92.90096935199995, 42.06463548700003], [-92.90059114599995, 42.06472407100006], [-92.89952491099996, 42.06485910300006], [-92.89902236199998, 42.06490651900003]]]}]                                                                                                                                                                                                                    | 
| 0000033849 | M482241650N | 0                                                            | 0.36416999999999999371169678852311335504055023193359375   | 1451628000    | 1451606401           |                    | JDENKER     | RAMS     | 1459761339         | 1464282512      | 877             | NO ERROR |           | 5        | [null, 43.142857598000035, -93.21289136599995, null, false, {paths=[[[-93.21289136599995, 43.142857598000035], [-93.21288899299998, 43.14337569600008], [-93.21287752799998, 43.143804266000075], [-93.21285955399998, 43.144476145000056], [-93.21287703099995, 43.14598761800005], [-93.21287324199994, 43.146376082000074], [-93.21286782899995, 43.14693089900004], [-93.21285698299994, 43.14733435100004], [-93.21285494399996, 43.14741019600007], [-93.21284110999994, 43.14813361700004]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | 
| 0000016932 | M529241290N | 0                                                            | 0.80699299999999996035882077194401063024997711181640625   | 1451628000    | 1451606401           |                    | JDENKER     | RAMS     | 1459761334         | 1464282512      | 827             | NO ERROR |           | 6        | [null, 40.96982673300005, -91.55411209599998, null, false, {paths=[[[-91.55411209599998, 40.96982673300005], [-91.55419896499996, 40.96999493200008], [-91.55430504899994, 40.970232743000054], [-91.55434448299997, 40.970333536000055], [-91.55436998599998, 40.97042693900005], [-91.55438037999994, 40.97055226100008], [-91.55437502199999, 40.97088826600003], [-91.55436856799997, 40.972435242000074], [-91.55436815899998, 40.97253288400003], [-91.55437204399999, 40.97320781800005], [-91.55437651399996, 40.97398468500006], [-91.55438165799995, 40.97474575600006], [-91.55438519199998, 40.97526844200007], [-91.55438778399997, 40.97584634300006], [-91.55439010899994, 40.97636402900008], [-91.55439259999997, 40.97691918700008], [-91.55439440299995, 40.97732094600008], [-91.55439418099996, 40.97742013900006], [-91.55439339499998, 40.97776916600003], [-91.55439172199999, 40.97851154600005], [-91.55439171699999, 40.97853922200005], [-91.55439151399997, 40.979578857000035], [-91.55439130499997, 40.98064366600005], [-91.55439128799998, 40.98072835700003], [-91.55439284399995, 40.98143848800004], [-91.55439289399999, 40.981461366000076], [-91.55439327199997, 40.98149189700007]]]}]         | 
| 0000033076 | M530241080N | 0                                                            | 0.1343870000000000064499516838623094372451305389404296875 | 1451628000    | 1451606401           |                    | JDENKER     | RAMS     | 1459761339         | 1464282512      | 851             | NO ERROR |           | 7        | [null, 41.92121524100003, -91.42570103299994, null, false, {paths=[[[-91.42570103299994, 41.92121524100003], [-91.42567681999998, 41.92151873100005], [-91.42566342099997, 41.92229654100004], [-91.42566056499999, 41.92246240000003], [-91.42565822599994, 41.92316256500004]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 
| 0000021154 | M533041850N | 0                                                            | 0.7764269999999999782858139951713383197784423828125       | 1451628000    | 1451606401           |                    | JDENKER     | RAMS     | 1459761335         | 1464282512      | 828             | NO ERROR |           | 8        | [null, 41.416354367000054, -91.05888245799997, null, false, {paths=[[[-91.05888245799997, 41.416354367000054], [-91.05858498699996, 41.416559447000054], [-91.05833612799995, 41.416732910000064], [-91.05812740899995, 41.41685001700006], [-91.05797266499997, 41.41692179300003], [-91.05780476399997, 41.41696467700007], [-91.05764743799995, 41.416979179000066], [-91.05733358099997, 41.416977882000026], [-91.05661668999994, 41.416974915000026], [-91.05595077299995, 41.416996364000056], [-91.05570759599999, 41.41701974800003], [-91.05554972999994, 41.417048539000064], [-91.05532934099995, 41.417097442000056], [-91.05515641799997, 41.41714736700004], [-91.05496946099998, 41.41726177900006], [-91.05420798899996, 41.41772776500005], [-91.05395732199997, 41.41787392200007], [-91.05288427699998, 41.41849956800007], [-91.05211400799999, 41.41894866600006], [-91.05178661799994, 41.419130521000056], [-91.05071475899996, 41.41972589400007], [-91.05027942199996, 41.419967702000065], [-91.04967354599995, 41.42030999900004], [-91.04857699799999, 41.420929493000074], [-91.04791971099996, 41.42130081700003], [-91.04757006099999, 41.42149772500005], [-91.04647032699995, 41.42211703500004]]]}] | 
| 0000035737 | M548241530N | 0.224932999999999994056310015366761945188045501708984375     | 0.4195160000000000000142108547152020037174224853515625    | 1451628000    | 1451606401           |                    | JDENKER     | RAMS     | 1459761340         | 1464282512      | 829             | NO ERROR |           | 9        | [null, 41.692760546000045, -93.04642806899994, null, false, {paths=[[[-93.04642806899994, 41.692760546000045], [-93.04635790099996, 41.69333861800004], [-93.04634046899997, 41.693645496000045], [-93.04634412399997, 41.694207934000076], [-93.04634106399999, 41.69464069900005], [-93.04635735999994, 41.69485429400004], [-93.04639115199996, 41.69511180600006], [-93.04642103499998, 41.69557629900004]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 
| 0000034664 | M548246040E | 0                                                            | 0.179636999999999991128873944035149179399013519287109375  | 1451628000    | 1451606401           |                    | JDENKER     | RAMS     | 1459761340         | 1464282512      | 829             | NO ERROR |           | 10       | [null, 41.68513315700005, -93.06618469999995, null, false, {paths=[[[-93.06618469999995, 41.68513315700005], [-93.06607663199998, 41.68500714700008], [-93.06594399799997, 41.68485482900007], [-93.06584313299999, 41.68479675700007], [-93.06570575299997, 41.68474765600007], [-93.06556822799996, 41.68471980700008], [-93.06519560299995, 41.68471838900007], [-93.06389656399995, 41.68470988200005], [-93.06317460399998, 41.68469853200003], [-93.06301647899994, 41.68472221700006], [-93.06296734999995, 41.684739431000025]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |