RAMS - Maintenance Residency

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.iowa.gov
Id 5fbb-kt2v
Name RAMS - Maintenance Residency
Attribution Iowa Department of Transportation - Office of Research & Analytics
Category Transportation & Utilities
Tags iowa dot, iowa department of transportation, rams, maintenance residency, asset, inventory
Created 2016-12-06T18:46:34Z
Publication Date 2016-12-06T18:48:29Z

Description

Maintenance Residency 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 | maintenance_residency | MAINTENANCE_RESIDENCY | 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:5fbb-kt2v d:2016-01-01T06:00:00.000Z t:shape.longitude=-93.65938574699999 t:shape.needs_recoding=false t:route_id=S001910235W5465 t:event_id=0000001181 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=41.59353520700006 t:user_mod=RAMS t:objectid=1 m:maintenance_residency=8 m:to_measure=0.316137 m:from_measure=0

series e:5fbb-kt2v d:2016-01-01T06:00:00.000Z t:shape.longitude=-94.19199961599998 t:shape.needs_recoding=false t:route_id=S001910080W6450 t:event_id=0000001581 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=41.51673504200005 t:user_mod=RAMS t:objectid=2 m:maintenance_residency=6 m:to_measure=0.296886 m:from_measure=0

series e:5fbb-kt2v d:2016-01-01T06:00:00.000Z t:shape.longitude=-93.77116449699997 t:shape.needs_recoding=false t:route_id=S001910235E5110 t:event_id=0000001203 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=41.591658661000054 t:user_mod=RAMS t:objectid=3 m:maintenance_residency=8 m:to_measure=0.498774 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:maintenance_residency p:integer l:MAINTENANCE_RESIDENCY d:"Maintenance Residency" t:dataTypeName=number

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

entity e:5fbb-kt2v l:"RAMS - Maintenance Residency" t:attribution="Iowa Department of Transportation - Office of Research & Analytics" t:url=https://data.iowa.gov/api/views/5fbb-kt2v

property e:5fbb-kt2v t:meta.view v:id=5fbb-kt2v v:category="Transportation & Utilities" v:averageRating=0 v:name="RAMS - Maintenance Residency" v:attribution="Iowa Department of Transportation - Office of Research & Analytics"

property e:5fbb-kt2v 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:5fbb-kt2v 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 | maintenance_residency | locerror | shape_len | objectid | shape                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 
| ========== | =============== | ============================================================ | ========================================================= | ============= | ==================== | ================== | =========== | ======== | ================== | =============== | ===================== | ======== | ========= | ======== | ================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================== | 
| 0000001181 | S001910235W5465 | 0                                                            | 0.31613700000000000134292577058658935129642486572265625   | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459769603         | 1463760458      | 8                     | NO ERROR |           | 1        | [null, 41.59353520700006, -93.65938574699999, null, false, {paths=[[[-93.65938574699999, 41.59353520700006], [-93.66007343999996, 41.59351349100007], [-93.66124273199995, 41.59345827300007], [-93.66266525899994, 41.593407865000074], [-93.66363890599996, 41.59336499700004], [-93.66482901999996, 41.59335118600006], [-93.66547800299998, 41.59328555700006]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 
| 0000001581 | S001910080W6450 | 0                                                            | 0.2968859999999999832454022907768376171588897705078125    | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459769603         | 1463760457      | 6                     | NO ERROR |           | 2        | [null, 41.51673504200005, -94.19199961599998, null, false, {paths=[[[-94.19199961599998, 41.51673504200005], [-94.19246455099994, 41.516530025000066], [-94.19282404199998, 41.516352694000034], [-94.19309318699999, 41.516221923000046], [-94.19363286099997, 41.51590545000005], [-94.19384476899995, 41.51577799700004], [-94.19399387099998, 41.51568654600004], [-94.19407041899996, 41.51564303500004], [-94.19415203199998, 41.515594598000064], [-94.19423907899994, 41.51555184000006], [-94.19433086599997, 41.51551510400003], [-94.19442665599996, 41.51548468400006], [-94.19452567999997, 41.51546082300007], [-94.19462714599996, 41.51544371400007], [-94.19498649199994, 41.51543924300006], [-94.19508038699996, 41.51545025900003], [-94.19517237499997, 41.51546819400005], [-94.19526155699998, 41.515492867000034], [-94.19534706099995, 41.51552404000006], [-94.19542805199995, 41.51556140900004], [-94.19550373399994, 41.51560460600007], [-94.19557857099994, 41.51564942500005], [-94.19564854999999, 41.51569847800005], [-94.19571325099997, 41.51575146400006], [-94.19577228099996, 41.51580807000005], [-94.19582528599994, 41.51586794800005], [-94.19587194599995, 41.515930738000066], [-94.19591197499994, 41.515996062000056], [-94.19594513599998, 41.51606352500005], [-94.19596709199999, 41.51614531700005], [-94.19598168499994, 41.516228031000026], [-94.19598885599999, 41.51631129700007], [-94.19598856699997, 41.51639473600005], [-94.19598082199997, 41.516477972000075], [-94.19595369899997, 41.516715978000036]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | 
| 0000001203 | S001910235E5110 | 0                                                            | 0.498773999999999995136334973722114227712154388427734375  | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459769603         | 1463760457      | 8                     | NO ERROR |           | 3        | [null, 41.591658661000054, -93.77116449699997, null, false, {paths=[[[-93.77116449699997, 41.591658661000054], [-93.77069433999998, 41.59173943900004], [-93.77038221299995, 41.591797374000066], [-93.77002812399996, 41.59184110900003], [-93.76969305599994, 41.59187908000007], [-93.76931226399995, 41.59191429700007], [-93.76893525399998, 41.59194378400008], [-93.76861537499997, 41.59197027500005], [-93.76823071299998, 41.59199119900006], [-93.76783457399995, 41.59200070900005], [-93.76728986799998, 41.592010567000045], [-93.76643285499995, 41.592035450000026], [-93.76461214999995, 41.59208258500007], [-93.76320649999997, 41.592088699000044], [-93.76157635299995, 41.592158073000064]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 
| 0000002484 | S001910029N2955 | 0                                                            | 0.457298999999999955523577455096528865396976470947265625  | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459769603         | 1463760458      | 6                     | NO ERROR |           | 4        | [null, 42.446289326000056, -96.37523907399998, null, false, {paths=[[[-96.37523907399998, 42.446289326000056], [-96.37521879199994, 42.44634145900005], [-96.37520183199996, 42.44638505700004], [-96.37514775899996, 42.44652404900006], [-96.37510527099994, 42.44697147000005], [-96.37507856699995, 42.447120924000046], [-96.37504906399994, 42.44718589800004], [-96.37501122799995, 42.447248459000036], [-96.37496541099995, 42.44730802300006], [-96.37491204499997, 42.44736403100006], [-96.37485162699994, 42.44741596400007], [-96.37478472199996, 42.44746333300003], [-96.37471195399996, 42.447505697000054], [-96.37463400099995, 42.44754266000007], [-96.37455159399997, 42.447573876000035], [-96.37446550499999, 42.44759905400008], [-96.37437653499995, 42.44761795900007], [-96.37428551499994, 42.44763041400006], [-96.37419657799995, 42.44763304800006], [-96.37410773799996, 42.44762901100006], [-96.37401990099994, 42.44761834600007], [-96.37393397099999, 42.44760116000003], [-96.37385082699996, 42.44757763200005], [-96.37377131699998, 42.447548002000076], [-96.37369625899998, 42.447512569000025], [-96.37362641999994, 42.44747170200003], [-96.37356251599994, 42.44742581500003], [-96.37350520099994, 42.447375382000075], [-96.37345506299994, 42.44732091700007], [-96.37341261199998, 42.44726297700004], [-96.37337828399995, 42.44720215700005], [-96.37335243499996, 42.44713907900007], [-96.37333532299999, 42.44707438900008], [-96.37332576299997, 42.447006318000035], [-96.37332588399994, 42.446937880000064], [-96.37333568899999, 42.44686982800005], [-96.37335506799997, 42.446802913000056], [-96.37338380899996, 42.44673786900006], [-96.37342159499997, 42.44667541500007], [-96.37346800899996, 42.44661623700006], [-96.37352254199999, 42.446560985000076], [-96.37358458899996, 42.44651027100008], [-96.37365347199994, 42.44646465200003], [-96.37372843099996, 42.446424629000035], [-96.37380863999994, 42.446390644000076], [-96.37389321599994, 42.446363071000064], [-96.37397415899994, 42.446342499000025], [-96.37405725599996, 42.446327343000064], [-96.37414184199997, 42.44631772400004], [-96.37422724699996, 42.446313717000066], [-96.37431279699996, 42.446315354000035], [-96.37439780999995, 42.44632262300007], [-96.37498144999995, 42.44636389800007], [-96.37520178199998, 42.44638505300003], [-96.37520183199996, 42.44638505700004], [-96.37523979299999, 42.446388701000046], [-96.37551718799995, 42.446415331000026], [-96.37575072399994, 42.44643775000003], [-96.37639941799995, 42.44650117900005], [-96.37715011099999, 42.446574576000046], [-96.37801848599997, 42.44665947200008]]]}] | 
| 0000002563 | S001910029N3150 | 0                                                            | 0.1806839999999999835100794598474749363958835601806640625 | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459769603         | 1463760458      | 6                     | NO ERROR |           | 5        | [null, 42.488257598000075, -96.39886686299997, null, false, {paths=[[[-96.39886686299997, 42.488257598000075], [-96.39903647799997, 42.488334542000075], [-96.39986030199998, 42.48849269300007], [-96.40025614299998, 42.48859004900004], [-96.40056477999997, 42.48868244100004], [-96.40074229199996, 42.488760238000054], [-96.40087620299994, 42.488835556000026], [-96.40101641099994, 42.48894289700007], [-96.40113780699994, 42.48906144100005], [-96.40115949199998, 42.489093327000035], [-96.40123106299995, 42.48919857200008], [-96.40135785799998, 42.48943499200004], [-96.40144407999998, 42.489629516000036], [-96.40147610999998, 42.48970447200003], [-96.40148424899996, 42.48972351700007]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 
| 0000000325 | S001910029N3200 | 0                                                            | 0.1888039999999999996038724248137441463768482208251953125 | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459769602         | 1463760458      | 6                     | NO ERROR |           | 6        | [null, 42.489446487000066, -96.40635234899997, null, false, {paths=[[[-96.40635234899997, 42.489446487000066], [-96.40715715999994, 42.48956112600007], [-96.40760160899998, 42.48966438800005], [-96.40806667599998, 42.489795740000034], [-96.40855752099998, 42.48996220300006], [-96.40905098899998, 42.490185817000054], [-96.40937724699995, 42.49034568700006], [-96.40964125399995, 42.49051785300003], [-96.40965987299995, 42.49055408000004]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | 
| 0000000802 | S001910029S1660 | 0                                                            | 0.2433869999999999922390969686603057198226451873779296875 | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459769603         | 1463760458      | 8                     | NO ERROR |           | 7        | [null, 41.25368352600003, -95.90733543599998, null, false, {paths=[[[-95.90733543599998, 41.25368352600003], [-95.90734336499997, 41.25341881400004], [-95.90730844099994, 41.25308958900007], [-95.90726369199996, 41.252861444000075], [-95.90720009999995, 41.252674729000034], [-95.90712666099995, 41.25240616100007], [-95.90709516699997, 41.25229057300004], [-95.90708896699994, 41.252086837000036], [-95.90704599899999, 41.251576182000065], [-95.90702754999995, 41.251208236000025], [-95.90695348199995, 41.25017612700003]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 
| 0000001311 | S001910029S1800 | 0.0254939999999999993007815390910764108411967754364013671875 | 0.19319100000000000161293201017542742192745208740234375   | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459769603         | 1463760458      | 8                     | NO ERROR |           | 8        | [null, 41.26842306800006, -95.90941840899995, null, false, {paths=[[[-95.90941840899995, 41.26842306800006], [-95.90924176599998, 41.26877012400007], [-95.90916645399994, 41.268911192000076], [-95.90905678499996, 41.269020803000046], [-95.90887974799995, 41.26910323800007], [-95.90870531299998, 41.26912839800008], [-95.90851994199994, 41.26911445300004], [-95.90839547099995, 41.26908133400008], [-95.90821110399997, 41.26896723700003], [-95.90813199599995, 41.26887951500004], [-95.90809024399994, 41.26877669400005], [-95.90808017599994, 41.26863386400004], [-95.90812654299998, 41.268479107000076], [-95.90821980999999, 41.26818388700008], [-95.90828521399999, 41.26794917600006]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | 
| 0000000714 | S001910029S2225 | 0                                                            | 0.285767999999999966487251867874874733388423919677734375  | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459769603         | 1463760458      | 8                     | NO ERROR |           | 9        | [null, 41.55008648100005, -95.91746711399998, null, false, {paths=[[[-95.91746711399998, 41.55008648100005], [-95.91766342999995, 41.55009834900005], [-95.91797314099995, 41.550117072000035], [-95.91834115799998, 41.55015575200008], [-95.91858168399995, 41.55022216900005], [-95.91877531399996, 41.550307461000045], [-95.91892613299996, 41.55039366400007], [-95.91902965499997, 41.550488021000035], [-95.91911971399998, 41.55060412100005], [-95.91916776699998, 41.55074256900008], [-95.91917381699994, 41.550903367000046], [-95.91913624999995, 41.551043632000074], [-95.91903181599997, 41.55117816600006], [-95.91893977299998, 41.551262371000064], [-95.91882789499994, 41.55132554000005], [-95.91867239899995, 41.551368178000075], [-95.91850604499996, 41.55137528600005], [-95.91835275099999, 41.55134993100006], [-95.91823208099999, 41.55130600200005], [-95.91813941699996, 41.551247173000036], [-95.91802597799995, 41.55114229700007], [-95.91794135099997, 41.55104396100006], [-95.91787126199995, 41.55095247100007], [-95.91781356299998, 41.550810650000074], [-95.91775954399998, 41.55064014300007], [-95.91766343699999, 41.55009838600006], [-95.91766342999995, 41.55009834900005], [-95.91764274099995, 41.54998171600005]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | 
| 0000002595 | S001910029S2450 | 0                                                            | 0.363062999999999969080732853399240411818027496337890625  | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459769603         | 1463760458      | 6                     | NO ERROR |           | 10       | [null, 41.935939258000076, -96.10391121899994, null, false, {paths=[[[-96.10391121899994, 41.935939258000076], [-96.10399897599996, 41.93505970900003], [-96.10405220599995, 41.93450108800005], [-96.10409898899997, 41.934222988000045], [-96.10412750999996, 41.93407211700003], [-96.10416399299999, 41.933922206000034], [-96.10420837899994, 41.93377348800004], [-96.10426059699995, 41.933626195000045], [-96.10432056399998, 41.93348055600006], [-96.10438819399997, 41.93333680200004], [-96.10446337199994, 41.93319515400003], [-96.10454598599995, 41.933055833000026], [-96.10463590499995, 41.93291905700005], [-96.10473642499994, 41.93275322100004], [-96.10498401099994, 41.93235707100007], [-96.10524066099998, 41.93196405400005], [-96.10545063299998, 41.93163217700004], [-96.10560188599999, 41.93139509200006], [-96.10573121599998, 41.93116851800005], [-96.10580156099996, 41.93103006900003], [-96.10581899699997, 41.93094253000004]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |