RAMS - Left Shoulder Curbed

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.iowa.gov
Id 4hd4-c29b
Name RAMS - Left Shoulder Curbed
Attribution Iowa Department of Transportation - Office of Research & Analytics
Category Transportation & Utilities
Tags iowa dot, iowa department of transportation, rams, left shoulder curbed, asset, inventory
Created 2016-12-06T17:15:40Z
Publication Date 2016-12-06T17:18:11Z

Description

Left Shoulder Curbed 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 | left_shoulder_curbed | LEFT_SHOULDER_CURBED | 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:4hd4-c29b d:2016-01-01T06:00:00.000Z t:shape.longitude=-95.81965787099995 t:shape.needs_recoding=false t:route_id=M164242000N t:event_id=0000033731 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=41.241805802000044 t:user_mod=RAMS t:objectid=1 m:to_measure=1.6938369999999998 m:from_measure=0.08390199999999999 m:left_shoulder_curbed=1

series e:4hd4-c29b d:2016-01-01T06:00:00.000Z t:shape.longitude=-95.83996264899997 t:shape.needs_recoding=false t:route_id=M164242015N t:event_id=0000027774 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=41.282045794000055 t:user_mod=RAMS t:objectid=2 m:to_measure=0.236291 m:from_measure=0 m:left_shoulder_curbed=1

series e:4hd4-c29b d:2016-01-01T06:00:00.000Z t:shape.longitude=-95.83791658299998 t:shape.needs_recoding=false t:route_id=M164242035N t:event_id=0000021435 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=41.237521643000036 t:user_mod=RAMS t:objectid=3 m:to_measure=0.109819 m:from_measure=0.004177999999999999 m:left_shoulder_curbed=1

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:left_shoulder_curbed p:integer l:LEFT_SHOULDER_CURBED d:"Left Shoulder Curbed" t:dataTypeName=number

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

entity e:4hd4-c29b l:"RAMS - Left Shoulder Curbed" t:attribution="Iowa Department of Transportation - Office of Research & Analytics" t:url=https://data.iowa.gov/api/views/4hd4-c29b

property e:4hd4-c29b t:meta.view v:id=4hd4-c29b v:category="Transportation & Utilities" v:averageRating=0 v:name="RAMS - Left Shoulder Curbed" v:attribution="Iowa Department of Transportation - Office of Research & Analytics"

property e:4hd4-c29b 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:4hd4-c29b 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 | left_shoulder_curbed | locerror | shape_len | objectid | shape                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 
| ========== | =========== | =============================================================== | ========================================================= | ============= | ==================== | ================== | =========== | ======== | ================== | =============== | ==================== | ======== | ========= | ======== | ========================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================= | 
| 0000033731 | M164242000N | 0.08390199999999999047606280555555713362991809844970703125      | 1.693836999999999815003093317500315606594085693359375     | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459778164         | 1463770675      | 1                    | NO ERROR |           | 1        | [null, 41.241805802000044, -95.81965787099995, null, false, {paths=[[[-95.81965787099995, 41.241805802000044], [-95.82034510199998, 41.24161178800006], [-95.82068570199999, 41.24157767100007], [-95.82092084299995, 41.24156610700004], [-95.82132851299997, 41.24155835900007], [-95.82173996999995, 41.241591922000055], [-95.82222031599997, 41.241639312000075], [-95.82236679599998, 41.241672863000076], [-95.82260592499995, 41.24173144800005], [-95.82278958199998, 41.241749828000025], [-95.82300728699994, 41.241847429000074], [-95.82324628599997, 41.24194346200005], [-95.82360982199998, 41.24209281000003], [-95.82384885699997, 41.24219141000003], [-95.82420136399998, 41.242335765000064], [-95.82465861499998, 41.24249201500004], [-95.82510579999996, 41.24271325700005], [-95.82566036799994, 41.242967358000044], [-95.82584919099997, 41.24304428200003], [-95.82616323999997, 41.24320135700003], [-95.82646552499995, 41.243385604000025], [-95.82659454099996, 41.243500305000055], [-95.82677960399997, 41.24368503200003], [-95.82722185499995, 41.244287701000076], [-95.82765659299997, 41.24482319200007], [-95.82778232199996, 41.244858057000044], [-95.82839501199999, 41.245651096000074], [-95.82856284399998, 41.245868329000075], [-95.82980226499996, 41.24739128500005], [-95.83015095699994, 41.247863306000056], [-95.83049340899998, 41.24842485500005], [-95.83157633799999, 41.25018737500005], [-95.83162603299996, 41.25026825300006], [-95.83168154399999, 41.25035470500006], [-95.83171016599994, 41.250399283000036], [-95.83174339799996, 41.25045103800005], [-95.83260505899995, 41.25179295500004], [-95.83290483499997, 41.252221278000036], [-95.83320461199997, 41.25264959500004], [-95.83329999699998, 41.25279782500007], [-95.83346812899998, 41.25312335900003], [-95.83385346499995, 41.25395221800005], [-95.83395917799999, 41.25417580100003], [-95.83418817799998, 41.25466012900006], [-95.83449481099996, 41.25530863100005], [-95.83460669399994, 41.255534615000045], [-95.83461749299994, 41.255556428000034], [-95.83469622899997, 41.25563705500008], [-95.83484676399996, 41.25573766100007], [-95.83544598599997, 41.256012128000066], [-95.83551171999994, 41.25604223600004], [-95.83645688299998, 41.256494805000045], [-95.83662403999995, 41.256567045000054], [-95.83696235999997, 41.25671325600007], [-95.83849024199998, 41.25716095200005], [-95.83893093699999, 41.25729133100003], [-95.83911372499995, 41.257366234000074], [-95.83921761199997, 41.257435946000044]]]}] | 
| 0000027774 | M164242015N | 0                                                               | 0.2362910000000000010356160373703460209071636199951171875 | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459778161         | 1463772950      | 1                    | NO ERROR |           | 2        | [null, 41.282045794000055, -95.83996264899997, null, false, {paths=[[[-95.83996264899997, 41.282045794000055], [-95.83994376199996, 41.28203359400004], [-95.83979496699999, 41.28198302200008], [-95.83955707499996, 41.281959319000066], [-95.83932982299996, 41.28196758100006], [-95.83914572499998, 41.28198925500004], [-95.83901937399997, 41.28203477300008], [-95.83890431299994, 41.28213012100008], [-95.83879352199995, 41.28234339000005], [-95.83874516699996, 41.28244809100005], [-95.83867669799997, 41.282521022000026], [-95.83856046999995, 41.28258420900005], [-95.83842925199997, 41.28262625100007], [-95.83821698599996, 41.28265565700008], [-95.83801919199999, 41.28269191800007], [-95.83788913699999, 41.28276611700005], [-95.83779775899995, 41.28286097600005], [-95.83774914099996, 41.28295853100008], [-95.83773705099998, 41.28314830900007], [-95.83774085099998, 41.28338424700007], [-95.83774522199997, 41.28376679300004], [-95.83777296799997, 41.28400938900006], [-95.83781223099999, 41.284204971000065]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | 
| 0000021435 | M164242035N | 0.00417799999999999942257300489245608332566916942596435546875   | 0.10981899999999999995026200849679298698902130126953125   | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459778159         | 1463772635      | 1                    | NO ERROR |           | 3        | [null, 41.237521643000036, -95.83791658299998, null, false, {paths=[[[-95.83791658299998, 41.237521643000036], [-95.83787493399996, 41.23755447100007], [-95.83778261399999, 41.23764296600007], [-95.83778108999996, 41.237644266000075], [-95.83766614799998, 41.23770409400004], [-95.83754629599997, 41.237736030000065], [-95.83751980499994, 41.23775659200004], [-95.83740201399996, 41.23784802700004], [-95.83740796099994, 41.23839007200007], [-95.83737671299997, 41.238551302000076], [-95.83736508299995, 41.23857431700003], [-95.83723088099998, 41.23883993700008]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | 
| 0000023942 | M164242090N | 0                                                               | 0.2419699999999999906474812405576813034713268280029296875 | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459778160         | 1463772950      | 1                    | NO ERROR |           | 4        | [null, 41.26392766400005, -95.83679448499998, null, false, {paths=[[[-95.83679448499998, 41.26392766400005], [-95.83630934699994, 41.26445331600007], [-95.83620008199995, 41.26457715200007], [-95.83610094899996, 41.264626788000044], [-95.83597663899997, 41.264689033000025], [-95.83533958399994, 41.26502756700006], [-95.83508927499997, 41.26515273900003], [-95.83420124899999, 41.26565891800004], [-95.83357959899996, 41.26598801200004], [-95.83326649899999, 41.26615375600005]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | 
| 0000021189 | M164242150N | 0                                                               | 0.14887899999999998357225194922648370265960693359375      | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459778159         | 1463771341      | 1                    | NO ERROR |           | 5        | [null, 41.255552272000045, -95.83420544699999, null, false, {paths=[[[-95.83420544699999, 41.255552272000045], [-95.83417474799995, 41.25560550000006], [-95.83395378599994, 41.255785271000036], [-95.83222020799997, 41.257100165000054]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | 
| 0000012942 | M164242350N | 0.0029699999999999999837629882648570855963043868541717529296875 | 0.1318939999999999834745523230594699271023273468017578125 | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459778154         | 1463771345      | 1                    | NO ERROR |           | 6        | [null, 41.27440332400005, -95.82579965099995, null, false, {paths=[[[-95.82579965099995, 41.27440332400005], [-95.82583338999996, 41.27445442100003], [-95.82591083399996, 41.27457171300006], [-95.82594427199996, 41.27471049300004], [-95.82592138799998, 41.27486473000005], [-95.82590621699995, 41.27491970300008], [-95.82563102199998, 41.27591684300006], [-95.82554732599999, 41.27622010400006]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | 
| 0000025509 | M164242350N | 0.55439599999999999990762944435118697583675384521484375         | 1.194822999999999968423480822821147739887237548828125     | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459778160         | 1463772325      | 1                    | NO ERROR |           | 7        | [null, 41.28210188700007, -95.82513284099997, null, false, {paths=[[[-95.82513284099997, 41.28210188700007], [-95.82519574999998, 41.28235703300004], [-95.82524268099996, 41.282738703000064], [-95.82527436899994, 41.28309207800004], [-95.82525778499996, 41.28342141200005], [-95.82521629899998, 41.28419946200006], [-95.82520968299997, 41.28432355100006], [-95.82514778499996, 41.28471102900005], [-95.82506551899996, 41.285059586000045], [-95.82504749399999, 41.285217300000056], [-95.82509141999998, 41.28543987300003], [-95.82511708399994, 41.28556990000004], [-95.82521048699994, 41.28592558500003], [-95.82522170899995, 41.28614593700007], [-95.82522668099995, 41.28624352000003], [-95.82519824099995, 41.287560073000066], [-95.82519200499996, 41.28778191300006], [-95.82515745099994, 41.28787559700004], [-95.82507948699998, 41.28794871400004], [-95.82497667699994, 41.287990156000035], [-95.82475439599995, 41.28800543800003], [-95.82280521399997, 41.28803577900004], [-95.82131345699997, 41.28805897800004], [-95.82060812899994, 41.28806994000007]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | 
| 0000034697 | M164242360N | 0                                                               | 0.336751999999999995782928863263805396854877471923828125  | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459778164         | 1463772025      | 1                    | NO ERROR |           | 8        | [null, 41.27841952800003, -95.82436289399999, null, false, {paths=[[[-95.82436289399999, 41.27841952800003], [-95.82422870199997, 41.27840747800008], [-95.82399250099996, 41.278430197000034], [-95.82374478999998, 41.278528247000054], [-95.82358285699996, 41.27863884300007], [-95.82346548299995, 41.27880216700004], [-95.82340572499999, 41.27898576700005], [-95.82341689199995, 41.279164337000054], [-95.82385196099995, 41.28097919100003], [-95.82400334299996, 41.28164828900003], [-95.82400416999997, 41.28165193900003], [-95.82406438099997, 41.28187599300003], [-95.82411483999994, 41.281960784000034], [-95.82418859699999, 41.28203436900003], [-95.82428027699996, 41.28207898000005], [-95.82440933699996, 41.282108519000076], [-95.82513284099997, 41.28210188700007]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | 
| 0000023602 | M164242410N | 0                                                               | 0.0545080000000000008952838470577262341976165771484375    | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459778160         | 1463772635      | 1                    | NO ERROR |           | 9        | [null, 41.28738360500006, -95.82089177499995, null, false, {paths=[[[-95.82089177499995, 41.28738360500006], [-95.82109947399994, 41.28749021400006], [-95.82118296599998, 41.28757075300007], [-95.82122510699998, 41.28768789900005], [-95.82131345699997, 41.28805897800004]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | 
| 0000026671 | M075046030E | 1.43427799999999994184918250539340078830718994140625            | 1.6463949999999998308197746155201457440853118896484375    | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459778161         | 1463772348      | 1                    | NO ERROR |           | 10       | [null, 42.056567192000045, -93.87830945499996, null, false, {paths=[[[-93.87830945499996, 42.056567192000045], [-93.87830999799996, 42.057457922000026], [-93.87831120699997, 42.057594951000056], [-93.87832024299996, 42.058619081000074], [-93.87832485899997, 42.05914232900005], [-93.87832636999997, 42.05964172800003]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |