RAMS - Right Shoulder Curbed

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.iowa.gov
Id rq8p-pukd
Name RAMS - Right Shoulder Curbed
Attribution Iowa Department of Transportation - Office of Research & Analytics
Category Transportation & Utilities
Tags iowa dot, iowa department of transportation, rams, right shoulder curbed, asset, inventory
Created 2016-12-06T19:20:40Z
Publication Date 2016-12-06T19:22:16Z

Description

Right 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 | right_shoulder_curbed | RIGHT_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:rq8p-pukd d:2016-01-01T06:00:00.000Z t:shape.longitude=-92.46524135999994 t:shape.needs_recoding=false t:route_id=M118541730N t:event_id=0000013735 t:user_create=JRENFRO t:locerror="NO ERROR" t:shape.latitude=42.48354406900006 t:user_mod=RAMS t:objectid=1 m:to_measure=5.069751 m:from_measure=1.3211309999999998 m:right_shoulder_curbed=1

series e:rq8p-pukd d:2016-01-01T06:00:00.000Z t:shape.longitude=-92.46645849099997 t:shape.needs_recoding=false t:route_id=M118546250E t:event_id=0000022354 t:user_create=JRENFRO t:locerror="NO ERROR" t:shape.latitude=42.50638025600006 t:user_mod=RAMS t:objectid=2 m:to_measure=5.288587 m:from_measure=1.921571 m:right_shoulder_curbed=1

series e:rq8p-pukd d:2016-01-01T06:00:00.000Z t:shape.longitude=-90.67891613199998 t:shape.needs_recoding=false t:route_id=M210042870N t:event_id=0000006621 t:user_create=JRENFRO t:locerror="NO ERROR" t:shape.latitude=42.44754199400006 t:user_mod=RAMS t:objectid=3 m:to_measure=0.0018189999999999999 m:from_measure=0 m:right_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:right_shoulder_curbed p:integer l:RIGHT_SHOULDER_CURBED d:"Right Shoulder Curbed" t:dataTypeName=number

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

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

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

property e:rq8p-pukd 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:rq8p-pukd 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 | right_shoulder_curbed | locerror                         | shape_len | objectid | shape                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | 
| ========== | =========== | ========================================================== | =============================================================== | ============= | ==================== | ================== | =========== | ======== | ================== | =============== | ===================== | ================================ | ========= | ======== | ========================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================== | 
| 0000013735 | M118541730N | 1.321130999999999833249830771819688379764556884765625      | 5.069751000000000118461684905923902988433837890625              | 1451628000    | 1451606401           |                    | JRENFRO     | RAMS     | 1459776294         | 1463754209      | 1                     | NO ERROR                         |           | 1        | [null, 42.48354406900006, -92.46524135999994, null, false, {paths=[[[-92.46524135999994, 42.48354406900006], [-92.46524185399994, 42.48355673200007], [-92.46525486299998, 42.48394288000003], [-92.46526031399998, 42.484090801000036], [-92.46528832599995, 42.48485106600003], [-92.46531109599994, 42.48552682400003], [-92.46537977299994, 42.48723598000004], [-92.46542855599995, 42.48898070100006], [-92.46543757099994, 42.49020321000006], [-92.46543577299997, 42.49093562400003], [-92.46543329699995, 42.491943881000054], [-92.46542530199997, 42.49331013300008], [-92.46542460899997, 42.49342796800005], [-92.46542250199997, 42.49378815000006], [-92.46541463799997, 42.49515705300007], [-92.46540959899994, 42.49582592200005], [-92.46540222199997, 42.49680471500005], [-92.46537840899998, 42.49826283400006], [-92.46536970699998, 42.49879570500008], [-92.46535342899995, 42.49979243000007], [-92.46535132399998, 42.50082911800007], [-92.46535068499998, 42.50114350400003], [-92.46535985999998, 42.50265195900005], [-92.46536377699994, 42.50276463100005], [-92.46538943599995, 42.50350291500007], [-92.46544119599997, 42.504178927000055], [-92.46545078299994, 42.504479256000025], [-92.46545887799994, 42.50465447300007], [-92.46546862699995, 42.504865445000064], [-92.46548354299995, 42.50572699200006], [-92.46549676399997, 42.50669218000007], [-92.46549615099997, 42.50688576600004], [-92.46549576599995, 42.50700698600008], [-92.46549438699998, 42.50744280300006], [-92.46549327699995, 42.50779304400004], [-92.46549056499998, 42.50855077700004], [-92.46549128099997, 42.50939432600006], [-92.46549082899998, 42.50961705700007], [-92.46548853699994, 42.51074539800004], [-92.46548456999994, 42.51217151800006], [-92.46549773399994, 42.51314027800004], [-92.46550045499998, 42.51491052500006], [-92.46549593099996, 42.51678345200003], [-92.46549590399997, 42.51679393900008], [-92.46549374399996, 42.51768771400003], [-92.46548776699996, 42.51818463500007], [-92.46548024599997, 42.51880992800005], [-92.46549354399997, 42.52065796900007], [-92.46549921599996, 42.52142632400006], [-92.46549955899997, 42.52147296800007], [-92.46549836599996, 42.522236588000055], [-92.46549836099996, 42.52224142100005], [-92.46549649599996, 42.52343523900004], [-92.46549274499995, 42.523960629000044], [-92.46546686599999, 42.524657389000026], [-92.46546399399995, 42.52496625900005], [-92.46546048799996, 42.52534359900005], [-92.46546165299998, 42.52544716800003], [-92.46546836999994, 42.52604423400004], [-92.46546402199994, 42.52690202900004], [-92.46548936599999, 42.52769283500004], [-92.46551203299998, 42.52840009300007], [-92.46552487999998, 42.528796956000065], [-92.46552689299995, 42.52892090200004], [-92.46553451699998, 42.52939037700003], [-92.46551384399999, 42.53148737400005], [-92.46551246199994, 42.531627695000054], [-92.46548907999994, 42.53239139400006], [-92.46548885999994, 42.53239853900004], [-92.46543992299996, 42.53399680900003], [-92.46539540699996, 42.534937006000064], [-92.46538088499995, 42.53524371000003], [-92.46536862299996, 42.53599410800007], [-92.46536552599997, 42.53618361400004], [-92.46535841699995, 42.536322949000066], [-92.46529295099998, 42.53677987400005], [-92.46528477799995, 42.53691825200008], [-92.46527290599994, 42.537119252000025], [-92.46525290199997, 42.53775172500008], [-92.46531079099998, 42.537854596000045]]]}]                                                                                                                                       | 
| 0000022354 | M118546250E | 1.9215709999999999180175791479996405541896820068359375     | 5.28858699999999970486896927468478679656982421875               | 1451628000    | 1451606401           |                    | JRENFRO     | RAMS     | 1459776298         | 1463754209      | 1                     | NO ERROR                         |           | 2        | [null, 42.50638025600006, -92.46645849099997, null, false, {paths=[[[-92.46645849099997, 42.50638025600006], [-92.46645349099998, 42.506382615000064], [-92.46619031199998, 42.50652093700006], [-92.46564096299994, 42.506809658000066], [-92.46549615099997, 42.50688576600004], [-92.46485525599996, 42.50722259400004], [-92.46431037599996, 42.50753654600004], [-92.46333863999996, 42.50817122500007], [-92.46263477399998, 42.50867247100007], [-92.46142871299998, 42.50953487900006], [-92.46113894599995, 42.50974207300004], [-92.45991680099996, 42.51061752800007], [-92.45945693299996, 42.51094709500006], [-92.45938771799996, 42.51099669800004], [-92.45861639599997, 42.51154945600007], [-92.45804923699995, 42.51195897300005], [-92.45767770699996, 42.51222370200003], [-92.45741862799997, 42.51240723400008], [-92.45725745299995, 42.51251301100007], [-92.45707218499996, 42.51261499700007], [-92.45689693099996, 42.51269562700003], [-92.45667330999999, 42.51277939400006], [-92.45638182699997, 42.512876848000076], [-92.45599861799997, 42.51296989800005], [-92.45581268799998, 42.512995309000075], [-92.45563060799998, 42.513020193000045], [-92.45534518999995, 42.51304263600008], [-92.45421447199999, 42.51305387000008], [-92.45342086499994, 42.51305318900006], [-92.45203073799996, 42.51305198400007], [-92.45084044099997, 42.51304599200006], [-92.44848000399998, 42.51303407200004], [-92.44590682099994, 42.51303268500004], [-92.44577208799996, 42.513028520000034], [-92.44556621699996, 42.513022156000034], [-92.44403744499994, 42.513032278000026], [-92.44337549199997, 42.513036654000075], [-92.44323162399996, 42.51303760400003], [-92.44306813899999, 42.513038685000026], [-92.44265694199999, 42.513037076000046], [-92.44101495399997, 42.51303063700004], [-92.43985758199995, 42.51302497800003], [-92.43850286199995, 42.513018343000056], [-92.43758027599995, 42.513006301000075], [-92.43681795699996, 42.51300877800003], [-92.43585539299994, 42.51301189900005], [-92.43330800299998, 42.513012841000034], [-92.43286960199998, 42.51301299800008], [-92.42966142399996, 42.513022686000056], [-92.42889410399994, 42.51301194600006], [-92.42740088899995, 42.51299103000008], [-92.42722209699997, 42.51299294900008], [-92.42710157499994, 42.512977533000026], [-92.42694214099998, 42.512941786000056], [-92.42678396699995, 42.51290310200005], [-92.42662280899998, 42.512864026000045], [-92.42646427999995, 42.512819457000035], [-92.42630871999995, 42.512769486000025], [-92.42615646399997, 42.51271422700006], [-92.42600784099994, 42.51265379500006], [-92.42586317299998, 42.51258832100007], [-92.42572277199997, 42.51251794900003], [-92.42546954099998, 42.51235117700003], [-92.42420328699995, 42.51157766800003], [-92.42326520299997, 42.51100460300006], [-92.42254340599999, 42.510551091000025], [-92.42149601499995, 42.50992654600003], [-92.42122800999994, 42.50977749800006], [-92.42100037899996, 42.50967938900004], [-92.42086352399997, 42.50962040300004], [-92.42075816999994, 42.50956580600007], [-92.42054709699994, 42.509478053000066], [-92.42025415299997, 42.50937523700003], [-92.41981220299994, 42.509228138000026], [-92.41892298899995, 42.50896248000004], [-92.41713004499996, 42.50842188400003], [-92.41582776899997, 42.50802920800004], [-92.41302103699996, 42.50718077300007], [-92.41122147599998, 42.506663392000064], [-92.41048723399996, 42.50647781400005], [-92.40930340399996, 42.50621288000008], [-92.40807109799994, 42.505958201000055], [-92.40640024899994, 42.50562507400008]]]}] | 
| 0000006621 | M210042870N | 0                                                          | 0.0018189999999999998704647286018598606460727751255035400390625 | 1451628000    | 1451606401           |                    | JRENFRO     | RAMS     | 1459776291         | 1463754212      | 1                     | NO ERROR                         |           | 3        | [null, 42.44754199400006, -90.67891613199998, null, false, {paths=[[[-90.67891613199998, 42.44754199400006], [-90.67891151799995, 42.447568140000044]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | 
| 0000003370 | M239541290N | 0.24474099999999998633626319133327342569828033447265625    | 0.49901099999999998235722387107671238481998443603515625         | 1451628000    | 1451606401           |                    | JRENFRO     | RAMS     | 1459776290         | 1463754212      | 1                     | NO ERROR                         |           | 4        | [null, 43.11201440700006, -94.67270128199999, null, false, {paths=[[[-94.67270128199999, 43.11201440700006], [-94.67268533799995, 43.11296943100007], [-94.67268530199999, 43.11297156300003], [-94.67268526599997, 43.112973698000076], [-94.67269517099999, 43.11380532700008], [-94.67266605699996, 43.11387902000007], [-94.67262996999995, 43.11397036200003], [-94.67262468799998, 43.11551416300006], [-94.67262315499994, 43.115691722000065]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | 
| 0000019615 | M477542290N | 0.09545099999999999418331952938387985341250896453857421875 | 0.29260099999999999997868371792719699442386627197265625         | 1451628000    | 1451606401           |                    | JRENFRO     | RAMS     | 1459776296         | 1463754211      | 1                     | NO ERROR                         |           | 5        | [null, 42.033304120000025, -91.59045442999997, null, false, {paths=[[[-91.59045442999997, 42.033304120000025], [-91.59046102499997, 42.03389072300007], [-91.59046664999994, 42.03418474700004], [-91.59047224799997, 42.03447727300005], [-91.59047358299995, 42.03491349300003], [-91.59048647099996, 42.03498243800004], [-91.59049838999994, 42.03504619600005], [-91.59050547999999, 42.03545033200004], [-91.59050834799996, 42.03616035600004]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | 
| 0000027615 | M477542330N | 0                                                          | 0.1343689999999999884483514733801712282001972198486328125       | 1451628000    | 1451606401           |                    | JRENFRO     | RAMS     | 1459776300         | 1463754211      | 1                     | NO ERROR                         |           | 6        | [null, 42.06575968300007, -91.58890447099998, null, false, {paths=[[[-91.58890447099998, 42.06575968300007], [-91.58886999199996, 42.06590767800003], [-91.58886802799998, 42.06606435500004], [-91.58902447099996, 42.067497692000074], [-91.58904846899998, 42.06769957400007]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | 
| 0000033648 | M592741070S | 0.07697099999999999775379677657838328741490840911865234375 | 0.361107000000000011308287639621994458138942718505859375        | 1451628000    | 1451606401           |                    | JRENFRO     | RAMS     | 1459776302         | 1463754215      | 1                     | PARTIAL MATCH FOR THE TO-MEASURE |           | 7        | [null, 42.985123016000045, -95.68785153099998, null, false, {paths=[[[-95.68785153099998, 42.985123016000045], [-95.68792627199997, 42.98503224800004], [-95.68789115699997, 42.98400799600006], [-95.68788455099997, 42.98381536000005], [-95.68785620899996, 42.98275387800004], [-95.68783454799996, 42.981942737000054], [-95.68781990899998, 42.98113797900004], [-95.68775442299994, 42.98107457500004]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 
| 0000021615 | M806541010N | 0                                                          | 0.251780999999999977045916921269963495433330535888671875        | 1451628000    | 1451606401           |                    | JRENFRO     | RAMS     | 1459776297         | 1463754216      | 1                     | NO ERROR                         |           | 8        | [null, 42.268287351000026, -95.09715671399994, null, false, {paths=[[[-95.09715671399994, 42.268287351000026], [-95.09714088399994, 42.269403545000046], [-95.09713697999996, 42.269678690000035], [-95.09712947999998, 42.27039132200008], [-95.09711850499997, 42.271434241000065], [-95.09710324599996, 42.271784797000066], [-95.09708116099995, 42.27186375100007], [-95.09699968399997, 42.27190064900003]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | 
| 0000016607 | M815542765N | 0                                                          | 0.369396000000000002128075493601500056684017181396484375        | 1451628000    | 1451606401           |                    | JRENFRO     | RAMS     | 1459776295         | 1463754216      | 1                     | NO ERROR                         |           | 9        | [null, 42.49809114100003, -92.33813190099994, null, false, {paths=[[[-92.33813190099994, 42.49809114100003], [-92.33787716599994, 42.49828969400005], [-92.33705387099997, 42.49897113700007], [-92.33610245399996, 42.499758600000064], [-92.33516634199998, 42.500533371000074], [-92.33516413799998, 42.500535168000056], [-92.33421414799994, 42.501308814000026], [-92.33328487999995, 42.50206556300003]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | 
| 0000017779 | M815542840N | 0                                                          | 0.247568999999999983518961244044476188719272613525390625        | 1451628000    | 1451606401           |                    | JRENFRO     | RAMS     | 1459776296         | 1463754216      | 1                     | NO ERROR                         |           | 10       | [null, 42.51055729500007, -92.33471286099996, null, false, {paths=[[[-92.33471286099996, 42.51055729500007], [-92.33475484099995, 42.51061266600004], [-92.33478257199994, 42.51068085900005], [-92.33480031499994, 42.51076682200005], [-92.33481713899994, 42.51090282100006], [-92.33480943399996, 42.51132165700005], [-92.33479130599994, 42.51230704500006], [-92.33478492399996, 42.512653949000025], [-92.33478359399999, 42.51323714000006], [-92.33478154999995, 42.51413244400004]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |