RAMS - Surface Width

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.iowa.gov
Id 6h43-35jm
Name RAMS - Surface Width
Attribution Iowa Department of Transportation - Office of Research & Analytics
Category Transportation & Utilities
Tags iowa dot, iowa department of transportation, rams, surface width, asset, inventory
Created 2016-12-06T20:39:30Z
Publication Date 2016-12-06T20:41:12Z

Description

Surface Width 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 | surface_width        | SURFACE_WIDTH        | 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:6h43-35jm d:2016-01-01T06:00:00.000Z t:shape.longitude=-93.86789715499998 t:shape.needs_recoding=false t:route_id=M817741420N t:event_id=0000119457 t:user_create=JDENKER t:locerror="NO ERROR" t:shape.latitude=41.58571011200007 t:user_mod=RAMS t:objectid=1 m:to_measure=0.213305 m:from_measure=0 m:surface_width=29

series e:6h43-35jm d:2016-01-01T06:00:00.000Z t:shape.longitude=-92.33622215699995 t:shape.needs_recoding=false t:route_id=M815542595N t:event_id=0000087497 t:user_create=JDENKER t:locerror="NO ERROR" t:shape.latitude=42.49282018500003 t:user_mod=RAMS t:objectid=2 m:to_measure=1.086242 m:from_measure=1.032873 m:surface_width=48

series e:6h43-35jm d:2016-01-01T06:00:00.000Z t:shape.longitude=-93.85286109499998 t:shape.needs_recoding=false t:route_id=M817741890N t:event_id=0000051662 t:user_create=JDENKER t:locerror="NO ERROR" t:shape.latitude=41.623567983000044 t:user_mod=RAMS t:objectid=3 m:to_measure=1.608898 m:from_measure=1.605899 m:surface_width=24

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:surface_width p:integer l:SURFACE_WIDTH d:"Surface Width" t:dataTypeName=number

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

entity e:6h43-35jm l:"RAMS - Surface Width" t:attribution="Iowa Department of Transportation - Office of Research & Analytics" t:url=https://data.iowa.gov/api/views/6h43-35jm

property e:6h43-35jm t:meta.view v:id=6h43-35jm v:category="Transportation & Utilities" v:averageRating=0 v:name="RAMS - Surface Width" v:attribution="Iowa Department of Transportation - Office of Research & Analytics"

property e:6h43-35jm 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:6h43-35jm 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 | surface_width | locerror | shape_len | objectid | shape                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | 
| ========== | =========== | ================================================================== | =========================================================== | ============= | ==================== | ================== | =========== | ======== | ================== | =============== | ============= | ======== | ========= | ======== | ============================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================= | 
| 0000119457 | M817741420N | 0                                                                  | 0.2133049999999999946087569924202398397028446197509765625   | 1451628000    | 1451606401           |                    | JDENKER     | RAMS     | 1459765135         | 1464275410      | 29            | NO ERROR |           | 1        | [null, 41.58571011200007, -93.86789715499998, null, false, {paths=[[[-93.86789715499998, 41.58571011200007], [-93.86802354399998, 41.58594532600006], [-93.86814228499998, 41.58612902200008], [-93.86819908799998, 41.586200630000064], [-93.86832986699994, 41.58634563000004], [-93.86856644999995, 41.586573556000076], [-93.86876844299996, 41.58671973400004], [-93.86894313699997, 41.586825936000025], [-93.86921364099999, 41.586964960000046], [-93.86949381699998, 41.587080024000045], [-93.86985483999996, 41.58718377800005], [-93.87001441099994, 41.58721823500008], [-93.87029173399998, 41.58726335600005], [-93.87043652999995, 41.58728681600007], [-93.87061307299996, 41.587288081000054], [-93.87107894599995, 41.587290249000034]]]}] | 
| 0000087497 | M815542595N | 1.032872999999999930054173091775737702846527099609375              | 1.086241999999999929826799416332505643367767333984375       | 1451628000    | 1451606401           |                    | JDENKER     | RAMS     | 1459765124         | 1464275408      | 48            | NO ERROR |           | 2        | [null, 42.49282018500003, -92.33622215699995, null, false, {paths=[[[-92.33622215699995, 42.49282018500003], [-92.33656051899999, 42.49304489000008], [-92.33700003799999, 42.49333677200008]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 
| 0000051662 | M817741890N | 1.60589899999999996538235791376791894435882568359375               | 1.608897999999999939291228656657040119171142578125          | 1451628000    | 1451606401           |                    | JDENKER     | RAMS     | 1459765109         | 1464275408      | 24            | NO ERROR |           | 3        | [null, 41.623567983000044, -93.85286109499998, null, false, {paths=[[[-93.85286109499998, 41.623567983000044], [-93.85286252199995, 41.62361144000005]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 
| 0000051330 | M819041840N | 0.1068179999999999962856378488140762783586978912353515625          | 0.1542599999999999804689565507942461408674716949462890625   | 1451628000    | 1451606401           |                    | JDENKER     | RAMS     | 1459765109         | 1464275408      | 28            | NO ERROR |           | 4        | [null, 42.73047819000004, -92.45817508399995, null, false, {paths=[[[-92.45817508399995, 42.73047819000004], [-92.45826187099999, 42.73048537600005], [-92.45835692299994, 42.73051826100004], [-92.45845610299995, 42.730563999000026], [-92.45854654799996, 42.73061285800003], [-92.45866755799995, 42.73065238200007], [-92.45880207599998, 42.73066320300006], [-92.45904547499998, 42.73065897500004]]]}]                                                                                                                                                                                                                                                                                                                                               | 
| 0000055498 | M825046060E | 0.1849819999999999797779537402675487101078033447265625             | 0.248491999999999990667021165791084058582782745361328125    | 1451628000    | 1451606401           |                    | JDENKER     | RAMS     | 1459765111         | 1464275408      | 32            | NO ERROR |           | 5        | [null, 42.956057256000065, -94.44643695799994, null, false, {paths=[[[-94.44643695799994, 42.956057256000065], [-94.44518407299995, 42.95605131600007]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 
| 0000030938 | M826043220N | 0.0002339999999999999957638052716646370754460804164409637451171875 | 0.042245999999999998830713110464785131625831127166748046875 | 1451628000    | 1451606401           |                    | JDENKER     | RAMS     | 1459765101         | 1464275408      | 24            | NO ERROR |           | 6        | [null, 41.503282123000076, -93.73293341699997, null, false, {paths=[[[-93.73293341699997, 41.503282123000076], [-93.73282563299995, 41.50344073500003], [-93.73273424699994, 41.50361616400005], [-93.73270510699996, 41.50385765100003]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | 
| 0000108165 | M826047380E | 1.5139229999999999076720769153325818479061126708984375             | 1.6351459999999999883613099882495589554309844970703125      | 1451628000    | 1451606401           |                    | JDENKER     | RAMS     | 1459765131         | 1464275408      | 28            | NO ERROR |           | 7        | [null, 41.57925112500004, -93.77459806699994, null, false, {paths=[[[-93.77459806699994, 41.57925112500004], [-93.77441172999994, 41.579344572000025], [-93.77401159599998, 41.579553899000075], [-93.77388810799994, 41.57961272700004], [-93.77376913499995, 41.57965605100003], [-93.77362254599996, 41.57967189800007], [-93.77302678399997, 41.57967676900006], [-93.77273803399999, 41.57967229600007], [-93.77255908899997, 41.57962279700007], [-93.77245647499996, 41.579567104000034]]]}]                                                                                                                                                                                                                                                           | 
| 0000043882 | M827541170N | 0.07394399999999999584243681738371378742158412933349609375         | 0.5333799999999999652544602213311009109020233154296875      | 1451628000    | 1451606401           |                    | JDENKER     | RAMS     | 1459765106         | 1464275405      | 26            | NO ERROR |           | 8        | [null, 41.568391708000036, -91.25764516599997, null, false, {paths=[[[-91.25764516599997, 41.568391708000036], [-91.25763000799998, 41.56860247000003], [-91.25761310899998, 41.569482625000035], [-91.25760860599996, 41.56991693000003], [-91.25760102299995, 41.570648135000056], [-91.25759077899994, 41.57102867300006], [-91.25756117599997, 41.57212814800005], [-91.25755110299997, 41.57250224200004], [-91.25754088599996, 41.57321840100008], [-91.25752616299997, 41.57425038400004], [-91.25751815399997, 41.57481163600005], [-91.25752280099994, 41.57505050300006]]]}]                                                                                                                                                                        | 
| 0000031435 | M842741010N | 0                                                                  | 0.2248449999999999893152136110074934549629688262939453125   | 1451628000    | 1451606401           |                    | JDENKER     | RAMS     | 1459765102         | 1464275405      | 22            | NO ERROR |           | 9        | [null, 41.65921475700003, -92.03446254999994, null, false, {paths=[[[-92.03446254999994, 41.65921475700003], [-92.03446562899995, 41.65945082300004], [-92.03447509699998, 41.65997905300003], [-92.03447187799998, 41.66038950300003], [-92.03446871299997, 41.66079765100005], [-92.03447212199995, 41.66091761500007], [-92.03446871399996, 41.66147104300006], [-92.03447558199997, 41.66197848200005], [-92.03446427499995, 41.662473781000074]]]}]                                                                                                                                                                                                                                                                                                      | 
| 0000182712 | M863741000N | 0.373266999999999959936047844166751019656658172607421875           | 0.398745999999999989338306249919696711003780364990234375    | 1451628000    | 1451606401           |                    | JDENKER     | RAMS     | 1459765157         | 1464275405      | 0             | NO ERROR |           | 10       | [null, 42.298964848000026, -90.68783570399995, null, false, {paths=[[[-90.68783570399995, 42.298964848000026], [-90.68781640899994, 42.29920380900006], [-90.68779821399994, 42.299333011000044]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |