RAMS - Access Control

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.iowa.gov
Id 9ehx-738h
Name RAMS - Access Control
Attribution Iowa Department of Transportation - Office of Research & Analytics
Category Transportation & Utilities
Tags iowa dot, iowa department of transportation, rams, access control, asset, inventory
Created 2016-12-06T16:28:27Z
Publication Date 2016-12-06T16:30:30Z

Description

Access Control 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      |
| No       |                | business_date        | BUSINESS_DATE        | date       | date        |
| Yes      | time           | 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 | access_control       | ACCESS_CONTROL       | 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 = effective_start_date
Format & Zone = seconds

Series Fields

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

Data Commands

series e:9ehx-738h d:2016-01-01T00:00:01.000Z t:shape.longitude=-93.79453472399996 t:shape.needs_recoding=false t:route_id=S001910035S1460 t:event_id=0000000278 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=41.02654987900007 t:user_mod=RAMS t:objectid=1 m:to_measure=0.23086399999999999 m:access_control=1 m:from_measure=0

series e:9ehx-738h d:2016-01-01T00:00:01.000Z t:shape.longitude=-93.79623061399997 t:shape.needs_recoding=false t:route_id=S001910035S1465 t:event_id=0000002617 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=41.02628280700003 t:user_mod=RAMS t:objectid=2 m:to_measure=0.406118 m:access_control=1 m:from_measure=0.011042

series e:9ehx-738h d:2016-01-01T00:00:01.000Z t:shape.longitude=-93.78592826199997 t:shape.needs_recoding=false t:route_id=S001910035S1510 t:event_id=0000001349 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=41.04781004700004 t:user_mod=RAMS t:objectid=3 m:to_measure=0.605202 m:access_control=1 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:access_control p:integer l:ACCESS_CONTROL d:"Access Control" t:dataTypeName=number

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

entity e:9ehx-738h l:"RAMS - Access Control" t:attribution="Iowa Department of Transportation - Office of Research & Analytics" t:url=https://data.iowa.gov/api/views/9ehx-738h

property e:9ehx-738h t:meta.view v:id=9ehx-738h v:category="Transportation & Utilities" v:averageRating=0 v:name="RAMS - Access Control" v:attribution="Iowa Department of Transportation - Office of Research & Analytics"

property e:9ehx-738h 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:9ehx-738h 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 | access_control | locerror | shape_len | objectid | shape                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 
| ========== | =============== | ============================================================ | ========================================================= | ============= | ==================== | ================== | =========== | ======== | ================== | =============== | ============== | ======== | ========= | ======== | ================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================== | 
| 0000000278 | S001910035S1460 | 0                                                            | 0.2308639999999999858903976246438105590641498565673828125 | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459767909         | 1463658670      | 1              | NO ERROR |           | 1        | [null, 41.02654987900007, -93.79453472399996, null, false, {paths=[[[-93.79453472399996, 41.02654987900007], [-93.79456184799994, 41.02565180400006], [-93.79457066799995, 41.02557849900006], [-93.79458764399999, 41.02550602300005], [-93.79461265099997, 41.02543489100003], [-93.79464551099994, 41.025365615000055], [-93.79467243099998, 41.02531182800004], [-93.79470760799995, 41.02526084500005], [-93.79475054099998, 41.02521339300006], [-93.79480062499994, 41.02517014600005], [-93.79485714299994, 41.02513171500004], [-93.79491929599999, 41.025098651000064], [-93.79498619999998, 41.02507141700005], [-93.79505690699995, 41.02505040500006], [-93.79513041299998, 41.02503591000004], [-93.79520567399999, 41.02502813900003], [-93.79527619099997, 41.02502798200004], [-93.79534615799997, 41.02503463900007], [-93.79541443399995, 41.02504800000003], [-93.79547990099996, 41.02506784600007], [-93.79554149199998, 41.02509385500008], [-93.79559819799994, 41.02512560100007], [-93.79564909399994, 41.02516256500007], [-93.79569334799999, 41.02520414500003], [-93.79573023899997, 41.02524966000004], [-93.79575915999999, 41.02529836400004], [-93.79594544699995, 41.02578045200005], [-93.79606712599997, 41.02611503000003], [-93.79613551899996, 41.02630308000005]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | 
| 0000002617 | S001910035S1465 | 0.0110419999999999997319921618554872111417353153228759765625 | 0.4061179999999999790105675856466405093669891357421875    | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459767910         | 1463658900      | 1              | NO ERROR |           | 2        | [null, 41.02628280700003, -93.79623061399997, null, false, {paths=[[[-93.79623061399997, 41.02628280700003], [-93.79616335499998, 41.02609252000008], [-93.79607315099997, 41.02583731200008], [-93.79583459899999, 41.02528029500007], [-93.79576796499998, 41.02515893100008], [-93.79564922999998, 41.024998383000025], [-93.79538353799995, 41.02469880900003], [-93.79519849499997, 41.024488389000055], [-93.79504190599994, 41.02430649000007], [-93.79491845199999, 41.02414595400006], [-93.79480915999994, 41.023985382000035], [-93.79471407899996, 41.02383549500007], [-93.79462357099999, 41.02365342500008], [-93.79453285199997, 41.023424885000054], [-93.79447543299995, 41.02325345200006], [-93.79442735599997, 41.02306054700006], [-93.79440280099999, 41.022849707000034], [-93.79433410799999, 41.02227437000005], [-93.79417818499996, 41.020874108000044]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | 
| 0000001349 | S001910035S1510 | 0                                                            | 0.6052020000000000177209358298568986356258392333984375    | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459767909         | 1463658430      | 1              | NO ERROR |           | 3        | [null, 41.04781004700004, -93.78592826199997, null, false, {paths=[[[-93.78592826199997, 41.04781004700004], [-93.78667577199997, 41.04704458500004], [-93.78719737699998, 41.04647846700004], [-93.78743707099994, 41.04622763400005], [-93.78760630499994, 41.046059196000044], [-93.78778033799995, 41.045908618000055], [-93.78796387499995, 41.04577231500008], [-93.78817569499995, 41.04562521400004], [-93.78835466899994, 41.04552466900003], [-93.78858550199999, 41.04540611600004], [-93.78881637999996, 41.045298288000026], [-93.78937567699995, 41.045072867000044], [-93.78982498499994, 41.044891774000064], [-93.79056964099999, 41.04458959200008], [-93.79122001799999, 41.04432339500005], [-93.79174784199995, 41.04410398300007], [-93.79186781799996, 41.04404909300007], [-93.79198268099998, 41.04398825700008], [-93.79209191699994, 41.04392174800006], [-93.79219503899998, 41.04384986100007], [-93.79229158599998, 41.04377291700007], [-93.79238112799999, 41.04369126200004], [-93.79246326199996, 41.04360525800007], [-93.79254382199997, 41.04352271000005], [-93.79261777399995, 41.04343668800004], [-93.79268485099999, 41.043347494000045], [-93.79274482499994, 41.043255446000046], [-93.79279747999999, 41.04316086700004], [-93.79284262999994, 41.04306408900004], [-93.79288012099994, 41.04296545400007], [-93.79290981399998, 41.042865310000025], [-93.79293160999998, 41.04276400500004], [-93.79294509599998, 41.04261383700003], [-93.79295725499998, 41.04217055000004], [-93.79296433999997, 41.04164863300008], [-93.79291666499995, 41.04154610100005]]]}]                                                                                                                                                                                                                                                                                                                                                                                 | 
| 0000001812 | S001910035N3855 | 0                                                            | 0.405947000000000002284394895468722097575664520263671875  | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459767909         | 1463658431      | 1              | NO ERROR |           | 4        | [null, 43.19876332500007, -93.34701977399999, null, false, {paths=[[[-93.34701977399999, 43.19876332500007], [-93.34701979899995, 43.19876624600005], [-93.34702808699996, 43.19884009300006], [-93.34704399299994, 43.19891326900006], [-93.34706741899998, 43.19898535500005], [-93.34709823599997, 43.199055937000026], [-93.34748217299995, 43.19983178000007], [-93.34827940899999, 43.20137278000004], [-93.34836678299996, 43.20159441900006], [-93.34847350099994, 43.20189826200004], [-93.34853627399997, 43.20219490200003], [-93.34857462099995, 43.20249508200004], [-93.34859770399999, 43.203048926000065], [-93.34868850999999, 43.20445673000006]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 
| 0000001947 | S001910035S1515 | 0                                                            | 0.38870599999999999596411726088263094425201416015625      | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459767909         | 1463658597      | 1              | NO ERROR |           | 5        | [null, 41.04154610100005, -93.79291666499995, null, false, {paths=[[[-93.79291666499995, 41.04154610100005], [-93.79286811599997, 41.04167022900003], [-93.79288163399997, 41.04215287200003], [-93.79286478499995, 41.04260332000007], [-93.79280424599995, 41.04278935900004], [-93.79276794799995, 41.04286010700008], [-93.79272370099994, 41.04292821100006], [-93.79267183799999, 41.04299316300006], [-93.79261274899994, 41.04305447400003], [-93.79254687099996, 41.04311168300006], [-93.79247470699994, 41.04316436300007], [-93.79239679299997, 41.04321211900003], [-93.79231370999997, 41.04325459300003], [-93.79222608899994, 41.04329146500004], [-93.79213457999998, 41.04332246000007], [-93.79203987399995, 41.04334734400004], [-93.79194267899999, 41.04336593200003], [-93.79184372599997, 41.04337808200006], [-93.79174316399997, 41.04338445700006], [-93.79164224799996, 41.04338416400003], [-93.79154174999996, 41.04337720700005], [-93.79144244099996, 41.04336363600004], [-93.79134507199996, 41.04334355800006], [-93.79125038899997, 41.04331712100003], [-93.79115911499997, 41.043284533000076], [-93.79107194399995, 41.04324603800006], [-93.79098954399996, 41.043201931000056], [-93.79091253999997, 41.04315254900007], [-93.79084152099995, 41.04309826900004], [-93.79077911799999, 41.04304308800005], [-93.79072302399999, 41.042984156000045], [-93.79067362599994, 41.04292188200003], [-93.79063127199998, 41.04285670200005], [-93.79059625499997, 41.04278907200006], [-93.79056882199995, 41.042719463000026], [-93.79054916399997, 41.04264836200008], [-93.79053741799999, 41.04257626800006], [-93.79053366899996, 41.04250368100003], [-93.79053793799994, 41.04243111200003], [-93.79055019899994, 41.042359066000074], [-93.79057809399995, 41.042262479000044], [-93.79063894199999, 41.042144360000066], [-93.79080312999997, 41.04190801200008], [-93.79135699699998, 41.04118450900006], [-93.79159226799999, 41.04079882000008]]]}] | 
| 0000002800 | S001910035S1660 | 0                                                            | 0.298269999999999979589659915291122160851955413818359375  | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459767910         | 1463658653      | 1              | NO ERROR |           | 6        | [null, 41.227840376000074, -93.78242135999994, null, false, {paths=[[[-93.78242135999994, 41.227840376000074], [-93.78241587199994, 41.22787152800004], [-93.78239474999998, 41.227943433000064], [-93.78236552399994, 41.228013704000034], [-93.78232840899994, 41.22808181800008], [-93.78214422499997, 41.22840828900007], [-93.78163658999995, 41.229267478000054], [-93.78132817999995, 41.22977442000007], [-93.78125876599995, 41.229910338000025], [-93.78119494699996, 41.23004780800005], [-93.78113678099999, 41.23018670000005], [-93.78105909599998, 41.23061585600004], [-93.78093546099996, 41.231960155000024]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | 
| 0000001365 | S001910035S1665 | 0                                                            | 0.315645000000000008899547765395254828035831451416015625  | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459767909         | 1463658852      | 1              | NO ERROR |           | 7        | [null, 41.227840376000074, -93.78242135999994, null, false, {paths=[[[-93.78242135999994, 41.227840376000074], [-93.78242873399995, 41.22779851800004], [-93.78243324199997, 41.227724944000045], [-93.78242935999998, 41.22765135100008], [-93.78241711999999, 41.227578280000046], [-93.78224451899996, 41.227086831000065], [-93.78208695599994, 41.226569606000055], [-93.78203301499997, 41.22636097900005], [-93.78199067699995, 41.226206657000034], [-93.78198238999994, 41.22604367200006], [-93.78244317399998, 41.22332603900003]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | 
| 0000000559 | S001910035S1715 | 0                                                            | 0.310269999999999990247800951692624948918819427490234375  | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459767909         | 1463658374      | 1              | NO ERROR |           | 8        | [null, 41.29345963600008, -93.78076506699995, null, false, {paths=[[[-93.78076506699995, 41.29345963600008], [-93.78077058599996, 41.29341174100006], [-93.78076990399995, 41.29336366800004], [-93.78076302499994, 41.29331587300004], [-93.78075001799994, 41.29326880900004], [-93.78070984999994, 41.29318740400004], [-93.78050308399997, 41.292724633000034], [-93.78030217399998, 41.29230045300005], [-93.78023601399997, 41.29212688700005], [-93.78019275399998, 41.29198758000007], [-93.78016034699999, 41.291728136000074], [-93.78008276999998, 41.29088970000004], [-93.78000290399996, 41.29017781600004], [-93.77995533199999, 41.28969963800006], [-93.77989656099999, 41.28926223800005], [-93.77985191099998, 41.28904356100003]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 
| 0000002153 | S001910035S1770 | 0                                                            | 0.51453399999999993585930724293575622141361236572265625   | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459767909         | 1463658699      | 1              | NO ERROR |           | 9        | [null, 41.36770606700003, -93.78068282199996, null, false, {paths=[[[-93.78068282199996, 41.36770606700003], [-93.78069402699998, 41.36742897100004], [-93.78069117199999, 41.36742683500006], [-93.78067165299996, 41.366867082000056], [-93.78067393899994, 41.366738386000065], [-93.78067602099998, 41.36656250500005], [-93.78067528399998, 41.36639306600006], [-93.78067739399995, 41.36622361800005], [-93.78068256499995, 41.36610349500006], [-93.78069623999994, 41.36597477200007], [-93.78071280899997, 41.365856765000046], [-93.78075192999995, 41.36568722700008], [-93.78079687599995, 41.36554770200007], [-93.78084458199999, 41.365388867000036], [-93.78091782999996, 41.365210664000074], [-93.78098561299998, 41.36508609700007], [-93.78104213399996, 41.364989440000045], [-93.78111285099999, 41.36488416800006], [-93.78118636599999, 41.36476816700008], [-93.78133079399998, 41.36459193200005], [-93.78160840099997, 41.36427166500005], [-93.78195115399996, 41.36387616600007], [-93.78221178599995, 41.36358167800006], [-93.78246097099998, 41.36327434700007], [-93.78285214899995, 41.36288730600006], [-93.78312459299997, 41.36269144800008], [-93.78323533999998, 41.36262682600005], [-93.78338309299994, 41.36256211300008], [-93.78352516499996, 41.36249955900007], [-93.78372132499999, 41.36243686900008], [-93.78396582199997, 41.36236118900007], [-93.78430703899994, 41.36226810800008], [-93.78483283399999, 41.36213685200005], [-93.78497531999994, 41.36210128300007], [-93.78520281099998, 41.36204280100003], [-93.78545772999996, 41.36196860600006]]]}]                                                                                                                                                                                                                                                                                                                                                                                   | 
| 0000002210 | S001910035S1775 | 0                                                            | 0.4151439999999999574953335468308068811893463134765625    | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459767909         | 1463658900      | 1              | NO ERROR |           | 10       | [null, 41.36188880800006, -93.78509976299995, null, false, {paths=[[[-93.78509976299995, 41.36188880800006], [-93.78503650099998, 41.36188896700003], [-93.78483249199996, 41.36192454400003], [-93.78365100199994, 41.36213057900005], [-93.78351455499995, 41.36215278700007], [-93.78337645399995, 41.36216815900008], [-93.78323731099994, 41.36217663300005], [-93.78309772899996, 41.362178164000056], [-93.78295831399998, 41.36217275200005], [-93.78281968099998, 41.36216041700004], [-93.78268242999997, 41.362141214000076], [-93.78254715999998, 41.36211522900004], [-93.78241446299995, 41.36208257100003], [-93.78228491799996, 41.36204338300007], [-93.78215908899995, 41.36199784000007], [-93.78203752299999, 41.36194613600003], [-93.78193633899997, 41.361896683000055], [-93.78183906299995, 41.36184296000005], [-93.78174601499995, 41.361785144000066], [-93.78165749399994, 41.36172342200007], [-93.78150914399998, 41.361614159000055], [-93.78136751399995, 41.36149994700003], [-93.78123289099995, 41.361381022000046], [-93.78110555299997, 41.361257626000054], [-93.78098576299999, 41.36113001100006], [-93.78087376499997, 41.36099844300003], [-93.78076978799999, 41.36086318900004], [-93.78067404799998, 41.36072452600007], [-93.78058673699996, 41.36058274000004], [-93.78050803699995, 41.36043812100007], [-93.78043810799994, 41.360290967000026], [-93.78037709499995, 41.36014157500006], [-93.78028357499994, 41.35981566000004], [-93.78024543899994, 41.35951736700008], [-93.78021682699995, 41.35929191100007], [-93.78012368499998, 41.35875863900003]]]}]                                                                                                                                                                                                                                                                                                                                                                                 |