RAMS - Widening Potential

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.iowa.gov
Id tsau-bwnw
Name RAMS - Widening Potential
Attribution Iowa Department of Transportation - Office of Research & Analytics
Category Transportation & Utilities
Tags iowa dot, iowa department of transportation, rams, widening potential, asset, classification
Created 2016-12-06T21:03:52Z
Publication Date 2016-12-06T21:05:23Z

Description

Widening Potential 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      | numeric metric | widening_potential   | WIDENING_POTENTIAL   | number     | number      |
| Yes      | series tag     | locerror             | LOCERROR             | text       | text        |
| Yes      | numeric metric | shape_len            | SHAPE.LEN            | number     | number      |
| Yes      | series tag     | objectid             | OBJECTID             | text       | number      |
| No       |                | shape                | SHAPE                | geospatial | geospatial  |

Time Field

Value = business_date
Format & Zone = seconds

Series Fields

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

Data Commands

series e:tsau-bwnw d:2016-01-01T06:00:00.000Z t:shape.longitude=-92.86727265699994 t:shape.needs_recoding=false t:route_id=C000446010E t:event_id=0000004218 t:user_create=MCLEMEN t:locerror="NO ERROR" t:shape.latitude=40.59506296500007 t:objectid=1 m:to_measure=2.664609 m:widening_potential=5 m:from_measure=1.5988829999999998

series e:tsau-bwnw d:2016-01-01T06:00:00.000Z t:shape.longitude=-93.00150585699998 t:shape.needs_recoding=false t:route_id=C000446510E t:event_id=0000026393 t:user_create=MCLEMEN t:locerror="NO ERROR" t:shape.latitude=40.688837532000036 t:objectid=2 m:to_measure=0.9978659999999999 m:widening_potential=5 m:from_measure=0

series e:tsau-bwnw d:2016-01-01T06:00:00.000Z t:shape.longitude=-92.89953688499997 t:shape.needs_recoding=false t:route_id=C000446510E t:event_id=0000019586 t:user_create=MCLEMEN t:locerror="NO ERROR" t:shape.latitude=40.68907893700003 t:objectid=3 m:to_measure=2.04445 m:widening_potential=5 m:from_measure=1.3885939999999999

Meta Commands

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

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

metric m:widening_potential p:long l:WIDENING_POTENTIAL d:"Widening Potential" t:dataTypeName=number

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

entity e:tsau-bwnw l:"RAMS - Widening Potential" t:attribution="Iowa Department of Transportation - Office of Research & Analytics" t:url=https://data.iowa.gov/api/views/tsau-bwnw

property e:tsau-bwnw t:meta.view v:id=tsau-bwnw v:category="Transportation & Utilities" v:averageRating=0 v:name="RAMS - Widening Potential" v:attribution="Iowa Department of Transportation - Office of Research & Analytics"

property e:tsau-bwnw 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:tsau-bwnw 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 | widening_potential | locerror | shape_len | objectid | shape                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 
| ========== | =========== | ======================================================= | ====================================================== | ============= | ==================== | ================== | =========== | ======== | ================== | =============== | ================== | ======== | ========= | ======== | ========================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================= | 
| 0000004218 | C000446010E | 1.59888299999999983214138410403393208980560302734375    | 2.664609000000000005314859663485549390316009521484375  | 1451628000    | 1451606401           |                    | MCLEMEN     |          | 1465458774         |                 | 5                  | NO ERROR |           | 1        | [null, 40.59506296500007, -92.86727265699994, null, false, {paths=[[[-92.86727265699994, 40.59506296500007], [-92.86723031299994, 40.59503020600005], [-92.86714618999997, 40.595001137000054], [-92.86694484599997, 40.59497140700006], [-92.86525237099994, 40.59494040800007], [-92.86230741399999, 40.59495947100004], [-92.85984561799995, 40.59495976300008], [-92.85875815199995, 40.59491781400004], [-92.85861780299996, 40.594884844000035], [-92.85808488899994, 40.59471737600006], [-92.85644491799997, 40.59411821100008], [-92.85567380799995, 40.59385643100006], [-92.85546792399998, 40.59381235500007], [-92.85501364299995, 40.59375613200007], [-92.85305925699998, 40.59352876000003], [-92.85207231799995, 40.59341392700003], [-92.85113076799996, 40.593319131000044], [-92.85083544699995, 40.59331027600007], [-92.85043672599994, 40.59332584300006], [-92.85021607099998, 40.59335316100004], [-92.84970843899998, 40.59347532800007], [-92.84931806099996, 40.59359459800004], [-92.84916741499995, 40.59365449000006], [-92.84881862599997, 40.593834764000064], [-92.84837051699998, 40.594100249000064], [-92.84783252899996, 40.59444384500006]]]}]                                                                                                                                                                                                                                                                                                     | 
| 0000026393 | C000446510E | 0                                                       | 0.9978659999999999197228817138238810002803802490234375 | 1451628000    | 1451606401           |                    | MCLEMEN     |          | 1465458784         |                 | 5                  | NO ERROR |           | 2        | [null, 40.688837532000036, -93.00150585699998, null, false, {paths=[[[-93.00150585699998, 40.688837532000036], [-93.00112599599998, 40.68883823800007], [-92.99996624599999, 40.68882236600007], [-92.99939364799997, 40.68878407300008], [-92.99861899999996, 40.68876275000008], [-92.99744964299998, 40.68877540400007], [-92.99630856799996, 40.68877387300006], [-92.99550549899999, 40.68878457300008], [-92.99452902199994, 40.68875159300006], [-92.99256134299998, 40.688767754000025], [-92.99164104699997, 40.68875645000003], [-92.99015696799995, 40.68878190100003], [-92.98875771499996, 40.68876840000007], [-92.98764873899995, 40.68874162600008], [-92.98748069099997, 40.68873756800008], [-92.98734233399995, 40.68873303100003], [-92.98581458299998, 40.68872345400007], [-92.98487857899994, 40.68871757800008], [-92.98420306199995, 40.68872973400005], [-92.98330786599996, 40.688707699000076], [-92.98251141999998, 40.68870268100005]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | 
| 0000019586 | C000446510E | 1.388593999999999883954160395660437643527984619140625   | 2.044449999999999878497192185022868216037750244140625  | 1451628000    | 1451606401           |                    | MCLEMEN     |          | 1465458781         |                 | 5                  | NO ERROR |           | 3        | [null, 40.68907893700003, -92.89953688499997, null, false, {paths=[[[-92.89953688499997, 40.68907893700003], [-92.89948127799994, 40.689078780000045], [-92.89524965199996, 40.68906669100005], [-92.89179351999996, 40.689062353000054], [-92.88944546199997, 40.689074652000045], [-92.88704873599994, 40.68910185500005]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 
| 0000076382 | C000446510E | 2.88093299999999974403408486978150904178619384765625    | 3.38094499999999964501284921425394713878631591796875   | 1451628000    | 1451606401           |                    | MCLEMEN     |          | 1465458807         |                 | 5                  | NO ERROR |           | 4        | [null, 40.68920689600003, -92.66680623199994, null, false, {paths=[[[-92.66680623199994, 40.68920689600003], [-92.66559815099998, 40.68921703600006], [-92.66409023699998, 40.689255883000044], [-92.66346080299996, 40.68926907600007], [-92.66225814199998, 40.689306593000026], [-92.66186375999996, 40.689300080000066], [-92.66153990399994, 40.68928694300007], [-92.66121139899997, 40.68927019400007], [-92.66061055199998, 40.68925141400007], [-92.65960073199994, 40.68926532000006], [-92.65729063399999, 40.689323914000056]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 
| 0000088875 | C000446510E | 2.044449999999999878497192185022868216037750244140625   | 2.88093299999999974403408486978150904178619384765625   | 1451628000    | 1451606401           |                    | MCLEMEN     |          | 1465458812         |                 | 5                  | NO ERROR |           | 5        | [null, 40.68886077600007, -92.79115508699994, null, false, {paths=[[[-92.79115508699994, 40.68886077600007], [-92.79097329799998, 40.68888066300008], [-92.79055672099997, 40.688881939000055], [-92.78944707299996, 40.68888533000006], [-92.78808527299998, 40.688883866000026], [-92.78611754499997, 40.688896416000034], [-92.78415932699994, 40.68889826900005], [-92.78215422999995, 40.68889263900007], [-92.78169573699995, 40.68891165700006], [-92.78073540999998, 40.68895148800004], [-92.77910114699995, 40.68895889800007], [-92.77876775899995, 40.68895676100004], [-92.77860321499998, 40.68897357800006], [-92.77845737399997, 40.688997665000045], [-92.77828324299998, 40.68903229400007], [-92.77815128999998, 40.68907434000005], [-92.77796259399997, 40.68915177000008], [-92.77779733699998, 40.68923292200003], [-92.77763661599994, 40.68932840300005], [-92.77749933299998, 40.68942760900006], [-92.77741401899999, 40.68949855000005], [-92.77729524099999, 40.68962289600006], [-92.77720956999997, 40.68972600700005], [-92.77715239099996, 40.68980070400005], [-92.77705183799998, 40.68997521000006], [-92.77698900999997, 40.69013566000007], [-92.77695467499996, 40.690267697000024], [-92.77692837999996, 40.69052132100006], [-92.77692406899996, 40.69090986900005]]]}]                                                                                                                                                                          | 
| 0000005752 | C000446510E | 0.99791799999999997172750454410561360418796539306640625 | 1.388593999999999883954160395660437643527984619140625  | 1451628000    | 1451606401           |                    | MCLEMEN     |          | 1465458775         |                 | 5                  | NO ERROR |           | 6        | [null, 40.68920995000008, -92.95252759699997, null, false, {paths=[[[-92.95252759699997, 40.68920995000008], [-92.95240712399999, 40.689153892000036], [-92.95221511299997, 40.689092189000064], [-92.95198984099994, 40.68907679500006], [-92.94923359999996, 40.68904903300006], [-92.94561769199998, 40.68905986400006], [-92.94529365999995, 40.68906184200006], [-92.94520895499994, 40.68908287100004], [-92.94515085099994, 40.68912216100006]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | 
| 0000004079 | C000447350E | 0                                                       | 1.255123999999999906407310845679603517055511474609375  | 1451628000    | 1451606401           |                    | MCLEMEN     |          | 1465458774         |                 | 5                  | NO ERROR |           | 7        | [null, 40.84837530900006, -93.00711560399998, null, false, {paths=[[[-93.00711560399998, 40.84837530900006], [-93.00667315499999, 40.84836980000006], [-93.00511972499999, 40.84837014000004], [-93.00405595299998, 40.848358318000066], [-93.00285578299997, 40.84833158500004], [-93.00223738899996, 40.84833424300007], [-93.00039375399996, 40.848342149000075], [-92.99780482699998, 40.84832707100003], [-92.99550774399995, 40.848313242000074], [-92.99182198699998, 40.848300264000045], [-92.98819254899996, 40.84830886900005], [-92.98572615399996, 40.848276199000054], [-92.98385283799996, 40.84824976500005], [-92.98315922499995, 40.84824584000006]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | 
| 0000010645 | C000447350E | 1.255123999999999906407310845679603517055511474609375   | 2.606535999999999742016143500222824513912200927734375  | 1451628000    | 1451606401           |                    | MCLEMEN     |          | 1465458777         |                 | 5                  | NO ERROR |           | 8        | [null, 40.84887844200006, -92.81115541799994, null, false, {paths=[[[-92.81115541799994, 40.84887844200006], [-92.81078676199996, 40.84888015900003], [-92.80824003599997, 40.84887886000007], [-92.80538267599997, 40.84887201500004], [-92.80388109399996, 40.84886275400004], [-92.80215372099997, 40.848837778000075], [-92.80192758499999, 40.84885425200008], [-92.80166312699998, 40.848841728000025], [-92.80151877399999, 40.84884425800004], [-92.80060845499997, 40.84886021400007], [-92.80026000999999, 40.84886877500003], [-92.79939412399995, 40.848841949000075], [-92.79823137999995, 40.84884186700003], [-92.79745473799994, 40.84883345600008], [-92.79579315399997, 40.84881951500006], [-92.79355243399999, 40.84881622200004], [-92.79128810199995, 40.84881988300003], [-92.78874596999998, 40.84882889800008], [-92.78782336799998, 40.84882307400005], [-92.78759295399999, 40.84880017100005], [-92.78751312699995, 40.84878179300006], [-92.78742408399995, 40.84874548300007], [-92.78734480699995, 40.84867706400007], [-92.78726564999994, 40.84859792200007], [-92.78721516499996, 40.84847963900006], [-92.78722696699998, 40.84826166100004], [-92.78727108599998, 40.847243167000045]]]}]                                                                                                                                                                                                                                                             | 
| 0000004381 | C000641130N | 0                                                       | 0.30182500000000000994759830064140260219573974609375   | 1451628000    | 1451606401           |                    | MCLEMEN     |          | 1465458774         |                 | 5                  | NO ERROR |           | 9        | [null, 41.894601987000044, -92.19577385899998, null, false, {paths=[[[-92.19577385899998, 41.894601987000044], [-92.19578461199995, 41.89610837400005], [-92.19579326299998, 41.89740500400006], [-92.19580464799998, 41.898880416000054], [-92.19579949199994, 41.89897683000004]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 
| 0000035206 | C000641130N | 0.30182500000000000994759830064140260219573974609375    | 2.292733999999999827679175723460502922534942626953125  | 1451628000    | 1451606401           |                    | MCLEMEN     |          | 1465458789         |                 | 5                  | NO ERROR |           | 10       | [null, 42.26858751000003, -92.18601353199995, null, false, {paths=[[[-92.18601353199995, 42.26858751000003], [-92.18601453199994, 42.26869159100005], [-92.18601631699994, 42.26984744300006], [-92.18602069399998, 42.270567207000056], [-92.18600395999994, 42.271532197000056], [-92.18601037099995, 42.272464084000035], [-92.18601287899997, 42.27327438700007], [-92.18603082199996, 42.274890371000026], [-92.18604758499998, 42.27547681900006], [-92.18605356399996, 42.27565324100004], [-92.18606753799997, 42.275753492000035], [-92.18610994299996, 42.27587551700003], [-92.18612712299995, 42.27597580400004], [-92.18615108899996, 42.276524204000054], [-92.18615076799995, 42.27793741200003], [-92.18615241299995, 42.27925531400007], [-92.18616437499998, 42.27960815600005], [-92.18618217099998, 42.28107638200004], [-92.18619716899997, 42.282835318000025], [-92.18620266199997, 42.28308086800007], [-92.18620884399996, 42.28335736100007], [-92.18620570099995, 42.28459656500007], [-92.18622800299994, 42.28631268700008], [-92.18622665399994, 42.28793082800007], [-92.18624401099999, 42.28942049400007], [-92.18626329699998, 42.290972142000044], [-92.18629211899997, 42.292683569000076], [-92.18627361099999, 42.29373432500006], [-92.18626798099996, 42.294627940000055], [-92.18628659499996, 42.29559094200005], [-92.18629829899999, 42.29657769700003], [-92.18630607899996, 42.29713305900003], [-92.18631323099999, 42.29743673000007]]]}] |