RAMS - Maintenance District

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.iowa.gov
Id tyzc-tyap
Name RAMS - Maintenance District
Attribution Iowa Department of Transportation - Office of Research & Analytics
Category Transportation & Utilities
Tags iowa dot, iowa department of transportation, rams, maintenance district, asset, inventory
Created 2016-12-06T17:56:50Z
Publication Date 2016-12-06T17:58:17Z

Description

Maintenance District 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      | series tag     | maintenance_district | MAINTENANCE_DISTRICT | text       | 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:tyzc-tyap d:2016-01-01T06:00:00.000Z t:shape.longitude=-92.92545080599996 t:maintenance_district=1 t:shape.needs_recoding=false t:route_id=S001920020W6165 t:event_id=0000002593 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=42.46359157200004 t:user_mod=RAMS t:objectid=1 m:to_measure=0.322695 m:from_measure=0

series e:tyzc-tyap d:2016-01-01T06:00:00.000Z t:shape.longitude=-92.29784922199997 t:maintenance_district=2 t:shape.needs_recoding=false t:route_id=S001920020W6665 t:event_id=0000001750 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=42.46060437600005 t:user_mod=RAMS t:objectid=2 m:to_measure=0.273121 m:from_measure=0

series e:tyzc-tyap d:2016-01-01T06:00:00.000Z t:shape.longitude=-92.05555855599994 t:maintenance_district=6 t:shape.needs_recoding=false t:route_id=S001920020W6815 t:event_id=0000001349 t:user_create=RWYLLIE t:locerror="NO ERROR" t:shape.latitude=42.45085129900008 t:user_mod=RAMS t:objectid=3 m:to_measure=0.46252099999999996 m:from_measure=0

Meta Commands

metric m:from_measure p:decimal l:FROM_MEASURE d:"From Measure" t:dataTypeName=number

metric m:to_measure p:decimal l:TO_MEASURE d:"To Measure" t:dataTypeName=number

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

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

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

property e:tyzc-tyap 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:tyzc-tyap t:meta.view.tableauthor v:id=2cmj-63jw v:profileImageUrlMedium=/api/users/2cmj-63jw/profile_images/THUMB v:profileImageUrlLarge=/api/users/2cmj-63jw/profile_images/LARGE v:screenName="Iowa Department of Transportation" v:profileImageUrlSmall=/api/users/2cmj-63jw/profile_images/TINY v:roleName=administrator v:displayName="Iowa Department of Transportation"

Top Records

| event_id   | route_id        | from_measure                                                | to_measure                                               | business_date | effective_start_date | effective_end_date | user_create | user_mod | system_create_date | system_mod_date | maintenance_district | locerror | shape_len | objectid | shape                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | 
| ========== | =============== | =========================================================== | ======================================================== | ============= | ==================== | ================== | =========== | ======== | ================== | =============== | ==================== | ======== | ========= | ======== | ================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================ | 
| 0000002593 | S001920020W6165 | 0                                                           | 0.322695000000000009610090501155355013906955718994140625 | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459767298         | 1463760677      | 1                    | NO ERROR |           | 1        | [null, 42.46359157200004, -92.92545080599996, null, false, {paths=[[[-92.92545080599996, 42.46359157200004], [-92.92683408599999, 42.463519940000026], [-92.92749772699995, 42.46346673900007], [-92.92813225999998, 42.46338731900005], [-92.92971915099997, 42.463125751000064], [-92.93031287099996, 42.463015701000074], [-92.93167484499997, 42.46284622600007]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | 
| 0000001750 | S001920020W6665 | 0                                                           | 0.273121000000000002660982545421575196087360382080078125 | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459767297         | 1463760677      | 2                    | NO ERROR |           | 2        | [null, 42.46060437600005, -92.29784922199997, null, false, {paths=[[[-92.29784922199997, 42.46060437600005], [-92.29790772999996, 42.46020407000003], [-92.29792039699998, 42.46012865300003], [-92.29794242399998, 42.46005442500007], [-92.29797362699998, 42.459982023000066], [-92.29801373299995, 42.45991206600007], [-92.29806240299996, 42.45984515500004], [-92.29811921699996, 42.45978186200006], [-92.29818369299994, 42.45972273000007], [-92.29832477599996, 42.45961566600005], [-92.29855698899996, 42.45945945900007], [-92.29911253799997, 42.45909789800004], [-92.29962616899996, 42.45876651300006], [-92.30001004099995, 42.45853952300007], [-92.30032512099996, 42.45837304100007], [-92.30067020299998, 42.45820965400003], [-92.30118155599996, 42.45799789700004], [-92.30140776299999, 42.45788453700004]]]}]                                                                                                                                                                                                                                                                                                                                                                                        | 
| 0000001349 | S001920020W6815 | 0                                                           | 0.4625209999999999599396005578455515205860137939453125   | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459767297         | 1463760677      | 6                    | NO ERROR |           | 3        | [null, 42.45085129900008, -92.05555855599994, null, false, {paths=[[[-92.05555855599994, 42.45085129900008], [-92.05559998099994, 42.45084924400004], [-92.05568917899996, 42.45083817900007], [-92.05577646599994, 42.45082063600006], [-92.05586097999998, 42.45079678600007], [-92.05597294499995, 42.450755290000075], [-92.05693349899997, 42.450331178000056], [-92.05766963099995, 42.45001149900003], [-92.05806954799993, 42.449830606000035], [-92.05825233799999, 42.44975311800005], [-92.05843943299999, 42.44968147900005], [-92.05863048099997, 42.44961581900003], [-92.05882514199999, 42.449556259000076], [-92.05902305599994, 42.44950290400004], [-92.05917625599994, 42.449462666000045], [-92.05933201999994, 42.449428245000036], [-92.05948994399995, 42.449399733000064], [-92.05964962099995, 42.44937720300004], [-92.05981063599995, 42.44936071200004], [-92.05997257899998, 42.44935030400006], [-92.06017565099995, 42.449334960000044], [-92.06076459899998, 42.44933157100007], [-92.06155171299997, 42.449316347000035], [-92.06411557099995, 42.44927650000005]]]}]                                                                                                                          | 
| 0000001480 | S001920020W6915 | 0                                                           | 0.374633999999999967034369774410151876509189605712890625 | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459767297         | 1463760677      | 6                    | NO ERROR |           | 4        | [null, 42.44939828200006, -91.89033249899995, null, false, {paths=[[[-91.89033249899995, 42.44939828200006], [-91.89039452199995, 42.44939819700005], [-91.89045606999997, 42.449403887000074], [-91.89058798299999, 42.44938606200003], [-91.89117623799996, 42.44928980100008], [-91.89260231499998, 42.44908658600008], [-91.89421734699994, 42.448861977000035], [-91.89458812399994, 42.44881563100006], [-91.89496960099996, 42.448776413000076], [-91.89540098899994, 42.44874789200003], [-91.89587872299995, 42.44873006600005], [-91.89757972399997, 42.44867049000004]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | 
| 0000002055 | S001920020W7160 | 0                                                           | 0.385201999999999988855137189602828584611415863037109375 | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459767298         | 1463760677      | 6                    | NO ERROR |           | 5        | [null, 42.47016310400005, -91.33780019299996, null, false, {paths=[[[-91.33780019299996, 42.47016310400005], [-91.34015750399999, 42.47016825600008], [-91.34071723799997, 42.470186082000055], [-91.34100245399998, 42.47020747400006], [-91.34130905999996, 42.470243125000025], [-91.34152297199995, 42.47027164700006], [-91.34173331799997, 42.47030373200005], [-91.34200783599994, 42.470360776000064], [-91.34224313999994, 42.47041425500004], [-91.34244635599998, 42.47046773300008], [-91.34282426499999, 42.47058181800003], [-91.34344104299998, 42.47079573000008], [-91.34407208099998, 42.471009640000034], [-91.34462468699996, 42.471202161000065], [-91.34473394399998, 42.47122442800003], [-91.34484513799998, 42.47124061300008], [-91.34495765199995, 42.47125062600003], [-91.34507085599995, 42.47125441600008]]]}]                                                                                                                                                                                                                                                                                                                                                                                    | 
| 0000001673 | S001920030E6300 | 0.043342999999999999583000231950791203416883945465087890625 | 0.12904199999999999004529627200099639594554901123046875  | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459767297         | 1463760677      | 1                    | NO ERROR |           | 6        | [null, 41.99218788700006, -92.61350896799996, null, false, {paths=[[[-92.61350896799996, 41.99218788700006], [-92.61332450999998, 41.99248311900004], [-92.61298361699994, 41.992675965000046], [-92.61221286799997, 41.99283776200008]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | 
| 0000002634 | S001920034E5855 | 0                                                           | 0.290953999999999990411225780917447991669178009033203125 | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459767298         | 1463760677      | 5                    | NO ERROR |           | 7        | [null, 40.99736547700007, -92.23686426299997, null, false, {paths=[[[-92.23686426299997, 40.99736547700007], [-92.23353794899998, 40.99681946800007], [-92.23281768499999, 40.996680637000054], [-92.23145586799995, 40.99637631500008]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | 
| 0000002195 | S001920034E5905 | 0                                                           | 0.359085999999999960774488272363669238984584808349609375 | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459767298         | 1463760677      | 5                    | NO ERROR |           | 8        | [null, 41.00299121200004, -92.16298063999994, null, false, {paths=[[[-92.16298063999994, 41.00299121200004], [-92.16244274099995, 41.002990401000034], [-92.15840500599995, 41.00314226100005], [-92.15740623099998, 41.003176763000056], [-92.15611661999998, 41.00320719800004]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | 
| 0000001122 | S001920034E6655 | 0.00975399999999999878230738659112830646336078643798828125  | 0.55914900000000000712674363967380486428737640380859375  | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459767297         | 1463760677      | 5                    | NO ERROR |           | 9        | [null, 40.82633773600003, -91.19087671199998, null, false, {paths=[[[-91.19087671199998, 40.82633773600003], [-91.19087461499998, 40.825349827000025], [-91.19088463199995, 40.82493523800008], [-91.19089039299996, 40.824856530000034], [-91.19088826299998, 40.82477771500004], [-91.19087825399998, 40.82469925200007], [-91.19086042599997, 40.824621594000064], [-91.19083487699999, 40.82454518900005], [-91.19080175999994, 40.82447048100005], [-91.19076126699997, 40.824397900000065], [-91.19071362799997, 40.82432786500004], [-91.19065911999996, 40.824260785000035], [-91.19028241599995, 40.82395367000004], [-91.19004630199998, 40.82381521600007], [-91.18936361199997, 40.82346070600005], [-91.18917537899995, 40.823389493000036], [-91.18882535799997, 40.82326181900004], [-91.18839205399996, 40.82311471500003], [-91.18786664599997, 40.822933824000074], [-91.18738748199996, 40.82276451100006], [-91.18706594199995, 40.82262324100003], [-91.18658539799998, 40.82236175400004], [-91.18619796699994, 40.82210572200006], [-91.18576152699995, 40.82178488900007], [-91.18524672599995, 40.82143763600004], [-91.18475397799995, 40.82112627400005], [-91.18439754599996, 40.82093887800005]]]}] | 
| 0000001021 | S001920034W5560 | 0                                                           | 0.194674999999999986943777230408159084618091583251953125 | 1451628000    | 1451606401           |                    | RWYLLIE     | RAMS     | 1459767297         | 1463760677      | 5                    | NO ERROR |           | 10       | [null, 41.01171111600007, -92.41646886399997, null, false, {paths=[[[-92.41646886399997, 41.01171111600007], [-92.41659551699996, 41.01179294600007], [-92.41667699099997, 41.01181279300005], [-92.41689489199996, 41.01195311200007], [-92.41697653099999, 41.01200489300004], [-92.41706342299995, 41.01205151900007], [-92.41715499699995, 41.01209268200006], [-92.41725065499998, 41.012128113000074], [-92.41776355199994, 41.01231415400008], [-92.41850789599994, 41.012583438000036], [-92.41903920099998, 41.012798248000024], [-92.41967377599997, 41.013122689000056]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |