RAMS - Institutional Number

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.iowa.gov
Id mdc9-qh2x
Name RAMS - Institutional Number
Attribution Iowa Department of Transportation - Office of Research & Analytics
Category Transportation & Utilities
Tags iowa dot, iowa department of transportation, rams, institutional number, asset, inventory
Created 2016-12-06T17:09:27Z
Publication Date 2016-12-06T17:11:49Z

Description

Institutional 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 | 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     | institution_number   | INSTITUTION_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:mdc9-qh2x d:2016-01-01T06:00:00.000Z t:shape.longitude=-91.53854212499994 t:institution_number=801 t:shape.needs_recoding=false t:route_id=M371546775E t:event_id=0000000016 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=41.65446780100007 t:user_mod=RAMS t:objectid=1 m:to_measure=0.039832 m:from_measure=0

series e:mdc9-qh2x d:2016-01-01T06:00:00.000Z t:shape.longitude=-91.53916128999998 t:institution_number=801 t:shape.needs_recoding=false t:route_id=M371546830E t:event_id=0000000180 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=41.65557156300008 t:user_mod=RAMS t:objectid=2 m:to_measure=0.152744 m:from_measure=0.000707

series e:mdc9-qh2x d:2016-01-01T06:00:00.000Z t:shape.longitude=-95.13569425899999 t:institution_number=435 t:shape.needs_recoding=false t:route_id=P043541010N t:event_id=0000000043 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=43.42697655600006 t:user_mod=RAMS t:objectid=3 m:to_measure=0.120305 m:from_measure=0

Meta Commands

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

metric m:to_measure p:float 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:mdc9-qh2x l:"RAMS - Institutional Number" t:attribution="Iowa Department of Transportation - Office of Research & Analytics" t:url=https://data.iowa.gov/api/views/mdc9-qh2x

property e:mdc9-qh2x t:meta.view v:id=mdc9-qh2x v:category="Transportation & Utilities" v:averageRating=0 v:name="RAMS - Institutional Number" v:attribution="Iowa Department of Transportation - Office of Research & Analytics"

property e:mdc9-qh2x 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:mdc9-qh2x 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 | institution_number | locerror | shape_len | objectid | shape                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 
| ========== | =========== | ================================================================ | =========================================================== | ============= | ==================== | ================== | =========== | ======== | ================== | =============== | ================== | ======== | ========= | ======== | ================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================= | 
| 0000000016 | M371546775E | 0                                                                | 0.039831999999999999351185664409058517776429653167724609375 | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459769159         | 1464001661      | 801                | NO ERROR |           | 1        | [null, 41.65446780100007, -91.53854212499994, null, false, {paths=[[[-91.53854212499994, 41.65446780100007], [-91.53790931699996, 41.65445032800005], [-91.53777270999996, 41.65445224600006]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | 
| 0000000180 | M371546830E | 0.00070699999999999994619581666910335115971975028514862060546875 | 0.1527439999999999908908421275555156171321868896484375      | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459769159         | 1464001661      | 801                | NO ERROR |           | 2        | [null, 41.65557156300008, -91.53916128999998, null, false, {paths=[[[-91.53916128999998, 41.65557156300008], [-91.53879243399996, 41.655563776000065], [-91.53840959599995, 41.65555306200008], [-91.53784221099994, 41.65555403800005], [-91.53776091799995, 41.65555264100004], [-91.53711313399998, 41.65554150300005], [-91.53639380899995, 41.655521978000024], [-91.53622377599999, 41.65552101500003]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | 
| 0000000043 | P043541010N | 0                                                                | 0.12030499999999999527489080719533376395702362060546875     | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459769159         | 1464001661      | 435                | NO ERROR |           | 3        | [null, 43.42697655600006, -95.13569425899999, null, false, {paths=[[[-95.13569425899999, 43.42697655600006], [-95.13569018099997, 43.42701200500005], [-95.13568610199997, 43.42704745300006], [-95.13568880199995, 43.42711724700007], [-95.13571017999999, 43.42724720500007], [-95.13571467899999, 43.427262115000076], [-95.13575107299994, 43.42738269200004], [-95.13583489199999, 43.42758974900005], [-95.13584703299995, 43.427615572000036], [-95.13589300899997, 43.42771336700008], [-95.13593027299999, 43.427772523000044], [-95.13599773699997, 43.42783812500005], [-95.13623353399998, 43.427987518000066], [-95.13628518399997, 43.42802024000008], [-95.13635523899995, 43.42806751300003], [-95.13643410299994, 43.428085460000034], [-95.13702384299995, 43.428120411000066]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 
| 0000000093 | P043741010N | 0                                                                | 0.665383999999999975472064761561341583728790283203125       | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459769159         | 1464001661      | 437                | NO ERROR |           | 4        | [null, 43.47387139800003, -94.93936979099999, null, false, {paths=[[[-94.93936979099999, 43.47387139800003], [-94.93937061399998, 43.47387436900004], [-94.93937321899995, 43.473883783000076], [-94.93942512699994, 43.474071296000034], [-94.93948093999995, 43.47419311500005], [-94.93973663299994, 43.47468839600003], [-94.93994044599998, 43.47508107600004], [-94.94019916399998, 43.47560530100003], [-94.94030074099999, 43.47586899300006], [-94.94033484299996, 43.47599064800005], [-94.94037012099994, 43.47620205900006], [-94.94039650699995, 43.47660739200006], [-94.94038319799995, 43.47673055900003], [-94.94032658999998, 43.47700869200003], [-94.94031223499996, 43.47707923100006], [-94.93999977299995, 43.47806322900004], [-94.93974102499999, 43.47864069000008], [-94.93966354299994, 43.47877053500008], [-94.93957903699999, 43.47887148500007], [-94.93948057899996, 43.47897007500006], [-94.93930817299997, 43.47913435600003], [-94.93912431799998, 43.47926153100008], [-94.93873059899994, 43.47951044600006], [-94.93842442899995, 43.47967734100007], [-94.93820729499998, 43.479765040000075], [-94.93766951899994, 43.479891387000066], [-94.93746107899995, 43.479917337000074], [-94.93720849799996, 43.479933774000074], [-94.93666705599998, 43.479953039000065], [-94.93638568599994, 43.47995268500006], [-94.93577868899996, 43.47988115100003], [-94.93557767399994, 43.47986011000006], [-94.93542987799998, 43.479853064000054], [-94.93530654299997, 43.479852040000026], [-94.93516801599998, 43.47987017200006], [-94.93502899699996, 43.479920777000075], [-94.93496448299999, 43.47993146700003], [-94.93491298299995, 43.47992007900007], [-94.93485538799996, 43.47989282700007], [-94.93470846899999, 43.47978329000006], [-94.93429677999995, 43.47947634900004]]]}] | 
| 0000000052 | P044241020N | 0                                                                | 1.1613029999999999741788769824779592454433441162109375      | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459769159         | 1464001661      | 442                | NO ERROR |           | 5        | [null, 41.77116292300008, -91.78815928099999, null, false, {paths=[[[-91.78815928099999, 41.77116292300008], [-91.78814837399995, 41.77161598600003], [-91.78808650399998, 41.77247787300007], [-91.78798549899994, 41.773895398000036], [-91.78793334799997, 41.774569642000074], [-91.78792176999997, 41.77468327500003], [-91.78791314399996, 41.77472364700003], [-91.78788173699996, 41.77487056900003], [-91.78783054099995, 41.775150944000075], [-91.78781364599996, 41.77529853400006], [-91.78779754399994, 41.77547703600004], [-91.78774462099994, 41.778093768000076], [-91.78774966499998, 41.77875307200003], [-91.78773517799999, 41.78020400500003], [-91.78769735099996, 41.78168003800005], [-91.78770364899998, 41.78223211400007], [-91.78768182999994, 41.783048550000046], [-91.78764473199999, 41.78407319200005], [-91.78760769499996, 41.78497422600003], [-91.78758134399999, 41.785596707000025], [-91.78755194999997, 41.786211869000056], [-91.78753051099994, 41.78798322100005]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 
| 0000000133 | P045041010N | 0                                                                | 0.11845299999999998885602536802252870984375476837158203125  | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459769159         | 1464001661      | 450                | NO ERROR |           | 6        | [null, 42.25139534700003, -90.51821155899995, null, false, {paths=[[[-90.51821155899995, 42.25139534700003], [-90.51838019099995, 42.25140019500003], [-90.51859278999996, 42.251406307000025], [-90.51860453799998, 42.25140664300005], [-90.51877138699996, 42.25142022000006], [-90.51889573199998, 42.251422811000054], [-90.51966201699997, 42.25143081900006], [-90.51989527099994, 42.251436854000076], [-90.52015365099999, 42.25146408300003], [-90.52028169899995, 42.25148566000007], [-90.52034804299996, 42.25151248800006], [-90.52047056599997, 42.25158642800005]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 
| 0000000014 | P048141010N | 0                                                                | 0.0844439999999999912905224164205719716846942901611328125   | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459769159         | 1464001661      | 481                | NO ERROR |           | 7        | [null, 41.38742219400007, -94.43915180699997, null, false, {paths=[[[-94.43915180699997, 41.38742219400007], [-94.43908742399998, 41.38775651800006], [-94.43903034699997, 41.38794692400006], [-94.43897207199996, 41.38816000200006], [-94.43893649099994, 41.388365296000075], [-94.43892931799996, 41.38847823000003], [-94.43892976499995, 41.38863162300004]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | 
| 0000000075 | P048141020N | 0                                                                | 0.141645999999999994134469716300372965633869171142578125    | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459769159         | 1464001661      | 481                | NO ERROR |           | 8        | [null, 41.38726225500005, -94.43541590599995, null, false, {paths=[[[-94.43541590599995, 41.38726225500005], [-94.43535712599999, 41.38731253700007], [-94.43530025999996, 41.38734288300003], [-94.43521537899994, 41.38735305700004], [-94.43515170299997, 41.38735821500006], [-94.43509027199997, 41.38737780900004], [-94.43504126499994, 41.387418050000065], [-94.43500545499995, 41.387456522000036], [-94.43492414699995, 41.387549318000026], [-94.43479966399997, 41.38770471200007], [-94.43459468699996, 41.38794713100003], [-94.43453301699998, 41.38801233100003], [-94.43444330799997, 41.38805788500008], [-94.43435667699998, 41.38808764500004], [-94.43426633999997, 41.38809004800004], [-94.43418688099996, 41.388082402000066], [-94.43411042599996, 41.38805398200003], [-94.43404042199995, 41.38802091600007], [-94.43396489599996, 41.387973841000075], [-94.43388684699994, 41.38791140500007], [-94.43381340999997, 41.38786304000007], [-94.43373775899994, 41.387813864000066], [-94.43367555799995, 41.387780348000035], [-94.43361135899994, 41.38776095500003], [-94.43348347399996, 41.387757857000054], [-94.43336879299994, 41.38776207500007]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 
| 0000000159 | C000447460E | 0                                                                | 0.3127109999999999612185774822137318551540374755859375      | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459769159         | 1464001662      | 926                | NO ERROR |           | 9        | [null, 40.866590976000055, -92.90620627999994, null, false, {paths=[[[-92.90620627999994, 40.866590976000055], [-92.90402605699995, 40.86660092300008], [-92.90023602499997, 40.86664628600005]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 
| 0000000063 | C002741040N | 3.490439999999999987068122209166176617145538330078125            | 3.993900000000000005684341886080801486968994140625          | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459769159         | 1464001662      | 506                | NO ERROR |           | 10       | [null, 40.86470064000008, -94.00474875999998, null, false, {paths=[[[-94.00474875999998, 40.86470064000008], [-94.00471928099995, 40.865755275000026], [-94.00471599799994, 40.86654527400003], [-94.00472501899998, 40.86770697700007], [-94.00472010099998, 40.868286083000044], [-94.00469163599996, 40.868865295000035], [-94.00464876699994, 40.86940882500005], [-94.00464046999997, 40.870159525000076], [-94.00467834499995, 40.87079206000004], [-94.00474233599994, 40.87114923200005], [-94.00478640799997, 40.87136708600008], [-94.00479727099997, 40.87155291700003], [-94.00480860199997, 40.87198979400006]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |