RAMS - Functional Class

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.iowa.gov
Id czu8-fwef
Name RAMS - Functional Class
Attribution Iowa Department of Transportation - Office of Research & Analytics
Category Transportation & Utilities
Tags iowa dot, iowa department of transportation, rams, functional classification
Created 2016-12-06T16:58:22Z
Publication Date 2016-12-06T17:01:21Z

Description

Functional Class 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 | fed_functional_class | FED_FUNCTIONAL_CLASS | 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:czu8-fwef d:2016-01-01T06:00:00.000Z t:shape.longitude=-95.98469024299999 t:shape.needs_recoding=false t:route_id=M640741050N t:event_id=0000071709 t:user_create=KBARRY t:locerror="NO ERROR" t:shape.latitude=42.80873221500008 t:user_mod=RAMS t:objectid=1 m:fed_functional_class=7 m:to_measure=0.050406 m:from_measure=0

series e:czu8-fwef d:2016-01-01T06:00:00.000Z t:shape.longitude=-96.17570085699998 t:shape.needs_recoding=false t:route_id=M654246110E t:event_id=0000072159 t:user_create=KBARRY t:locerror="NO ERROR" t:shape.latitude=43.422924892000026 t:user_mod=RAMS t:objectid=2 m:fed_functional_class=7 m:to_measure=0.393553 m:from_measure=0

series e:czu8-fwef d:2016-01-01T06:00:00.000Z t:shape.longitude=-95.36185804999997 t:shape.needs_recoding=false t:route_id=M696541740N t:event_id=0000073688 t:user_create=KBARRY t:locerror="NO ERROR" t:shape.latitude=40.753654804000064 t:user_mod=RAMS t:objectid=3 m:fed_functional_class=7 m:to_measure=0.180122 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:fed_functional_class p:integer l:FED_FUNCTIONAL_CLASS d:"Fed Func Class" t:dataTypeName=number

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

entity e:czu8-fwef l:"RAMS - Functional Class" t:attribution="Iowa Department of Transportation - Office of Research & Analytics" t:url=https://data.iowa.gov/api/views/czu8-fwef

property e:czu8-fwef t:meta.view v:id=czu8-fwef v:category="Transportation & Utilities" v:averageRating=0 v:name="RAMS - Functional Class" v:attribution="Iowa Department of Transportation - Office of Research & Analytics"

property e:czu8-fwef 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:czu8-fwef 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 | fed_functional_class | locerror | shape_len | objectid | shape                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | 
| ========== | =========== | ============ | =========================================================== | ============= | ==================== | ================== | =========== | ======== | ================== | =============== | ==================== | ======== | ========= | ======== | ================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================ | 
| 0000071709 | M640741050N | 0            | 0.050405999999999999416910867466867784969508647918701171875 | 1451628000    | 1451606401           |                    | KBARRY      | RAMS     | 1462151260         | 1464283513      | 7                    | NO ERROR |           | 1        | [null, 42.80873221500008, -95.98469024299999, null, false, {paths=[[[-95.98469024299999, 42.80873221500008], [-95.98469324099995, 42.80880638800005], [-95.98466406699998, 42.80892856600008], [-95.98466146999999, 42.80898582700007], [-95.98469683899998, 42.80902082100005], [-95.98476532599994, 42.80903365900008], [-95.98482853799999, 42.809035882000046], [-95.98487634799994, 42.80901698400004], [-95.98489947999997, 42.80898788800005], [-95.98490264299994, 42.808944919000055], [-95.98489609899997, 42.808902156000045], [-95.98488329699995, 42.80882377700004], [-95.98488440499995, 42.80872981400006]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | 
| 0000072159 | M654246110E | 0            | 0.393552999999999986169285648429649882018566131591796875    | 1451628000    | 1451606401           |                    | KBARRY      | RAMS     | 1462151260         | 1464283513      | 7                    | NO ERROR |           | 2        | [null, 43.422924892000026, -96.17570085699998, null, false, {paths=[[[-96.17570085699998, 43.422924892000026], [-96.17492159699998, 43.42291224000007], [-96.17464582699995, 43.42290776100003], [-96.17413868099999, 43.422905367000055], [-96.17379968999995, 43.42290376500006], [-96.17263896699995, 43.42289827400003], [-96.17133804599996, 43.42289210400003], [-96.17109713299999, 43.42288810000008], [-96.17062567299996, 43.422880262000035], [-96.17024863199998, 43.422873991000074], [-96.17015707399997, 43.422903131000055]], [[-96.16828983899995, 43.42290433800008], [-96.16710385199997, 43.422879333000026], [-96.16602153099996, 43.42285650200006]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 
| 0000073688 | M696541740N | 0            | 0.18012200000000000432720526077901013195514678955078125     | 1451628000    | 1451606401           |                    | KBARRY      | RAMS     | 1462151262         | 1464283513      | 7                    | NO ERROR |           | 3        | [null, 40.753654804000064, -95.36185804999997, null, false, {paths=[[[-95.36185804999997, 40.753654804000064], [-95.36183416399996, 40.75369072400008], [-95.36183702699998, 40.75395524900006], [-95.36187512999999, 40.754698838000024], [-95.36191152499998, 40.755409163000024], [-95.36188404499995, 40.75559910900006], [-95.36184931199995, 40.755699793000076], [-95.36177177199994, 40.75578330600007], [-95.36136499999998, 40.75611504600005]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 
| 0000074271 | M705741630N | 0            | 0.1974149999999999793853788787600933574140071868896484375   | 1451628000    | 1451606401           |                    | KBARRY      | RAMS     | 1462151263         | 1464283513      | 7                    | NO ERROR |           | 4        | [null, 42.517434467000044, -96.41303754199998, null, false, {paths=[[[-96.41303754199998, 42.517434467000044], [-96.41295441799997, 42.51750053600006], [-96.41293331499998, 42.51758912400004], [-96.41296711399997, 42.517627221000055], [-96.41297985799997, 42.51780470700004], [-96.41297189799997, 42.51793021900005], [-96.41295840199996, 42.51808465700003], [-96.41291809199998, 42.51825332000004], [-96.41285013699996, 42.51836848800008], [-96.41276951199995, 42.518456194000066], [-96.41266662199996, 42.51850886600005], [-96.41251374999996, 42.518548476000035], [-96.41229679099996, 42.51856109100004], [-96.41209316999999, 42.51854833500005], [-96.41189854799995, 42.51852105000006], [-96.41187970699997, 42.51851444500005], [-96.41174623199998, 42.51846766300008], [-96.41160823699994, 42.51841034300003], [-96.41130416799996, 42.51821058000007], [-96.41092806599994, 42.51791607300004], [-96.41087183199994, 42.51784954300007], [-96.41085724599998, 42.51777339300003]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | 
| 0000074533 | M705742535N | 0            | 0.4463369999999999837569930605241097509860992431640625      | 1451628000    | 1451606401           |                    | KBARRY      | RAMS     | 1462151263         | 1464283513      | 7                    | NO ERROR |           | 5        | [null, 42.50094958500006, -96.36160348099997, null, false, {paths=[[[-96.36160348099997, 42.50094958500006], [-96.36160929499994, 42.502355883000064], [-96.36160909499995, 42.50438352200007], [-96.36163968999995, 42.50452580800004], [-96.36166926699997, 42.504556370000046], [-96.36169038799994, 42.50457819500008], [-96.36173787199999, 42.50466642200007], [-96.36174576599996, 42.50473417200004], [-96.36174219899999, 42.50477731600006], [-96.36171138699996, 42.50514984700004], [-96.36173570299997, 42.50526010300007], [-96.36176773599999, 42.505327255000054], [-96.36178794899996, 42.50540158300004], [-96.36179092199995, 42.50541250900005], [-96.36180301299999, 42.50557313100006], [-96.36179908099996, 42.50591402500004], [-96.36179355999997, 42.50639281600007], [-96.36182482999999, 42.50733917000008], [-96.36185106599999, 42.507385010000064]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | 
| 0000074645 | M705742930N | 0            | 0.5990249999999999186428567554685287177562713623046875      | 1451628000    | 1451606401           |                    | KBARRY      | RAMS     | 1462151263         | 1464283513      | 7                    | NO ERROR |           | 6        | [null, 42.45707643000003, -96.33402599699997, null, false, {paths=[[[-96.33402599699997, 42.45707643000003], [-96.33405171499999, 42.457111559000055], [-96.33404781899998, 42.45724039400005], [-96.33404297499999, 42.45796895400008], [-96.33403906599995, 42.45855660900003], [-96.33401852099996, 42.458886419000066], [-96.33401095499994, 42.45900788400007], [-96.33400667199999, 42.45934414100003], [-96.33400083199996, 42.45973120600007], [-96.33398807099996, 42.46057686700004], [-96.33398108399996, 42.46103983200004], [-96.33395861999998, 42.46168799800006], [-96.33395156299997, 42.461891663000074], [-96.33394314799995, 42.46277798500006], [-96.33393379899996, 42.463762390000056], [-96.33393501499995, 42.46398049100003], [-96.33393654599996, 42.46425582100005], [-96.33391124099995, 42.46575230000008]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 
| 0000077598 | M787542230N | 0            | 1.027517000000000013670842236024327576160430908203125       | 1451628000    | 1451606401           |                    | KBARRY      | RAMS     | 1462151267         | 1464283513      | 7                    | NO ERROR |           | 7        | [null, 41.63939939200003, -93.73650681399994, null, false, {paths=[[[-93.73650681399994, 41.63939939200003], [-93.73577608799997, 41.63939091100008], [-93.73546175999996, 41.639391560000035], [-93.73526421499997, 41.639379441000074], [-93.73511116399999, 41.63936305300007], [-93.73488235199994, 41.639321764000044], [-93.73299316099997, 41.63889553200005], [-93.73272594099996, 41.638845968000055], [-93.73246544899996, 41.63881100400005], [-93.73220396099998, 41.63880736100003], [-93.73196201799999, 41.63882455600003], [-93.73167566299998, 41.63886689800006], [-93.73133214399996, 41.63894902200008], [-93.73076796599997, 41.639087964000055], [-93.73058731399999, 41.639132172000075], [-93.73037006899995, 41.63919255600007], [-93.73014722599999, 41.639279213000066], [-93.72989226099997, 41.63939147200006], [-93.72971461599997, 41.63949831000008], [-93.72960920499997, 41.639579954000055], [-93.72945941099994, 41.63969717400005], [-93.72934570699994, 41.639793447000045], [-93.72922655099995, 41.63992104500005], [-93.72911576899997, 41.64005698200003], [-93.72899410399998, 41.640262678000056], [-93.72891133299999, 41.64045284000008], [-93.72885083399996, 41.64064922400007], [-93.72881530299998, 41.64082676400005], [-93.72880682699997, 41.64157049100004], [-93.72880737799994, 41.642505870000036], [-93.72880942299997, 41.64386028700005], [-93.72871566299995, 41.64399918500004], [-93.72870437799997, 41.644399716000066], [-93.72879934799994, 41.64447429000006], [-93.72884604199999, 41.645304553000074], [-93.72888193999995, 41.64547135500004], [-93.72911185599997, 41.64612999700006], [-93.72941324299995, 41.64698230100004], [-93.72954132599995, 41.647367676000044], [-93.72961014399999, 41.64765043800003], [-93.72965944999999, 41.64788450300006], [-93.72969259299998, 41.64819064000005], [-93.72969362799995, 41.64847989500004], [-93.72968930499997, 41.64875400200003]]]}] | 
| 0000077607 | M787542310N | 0            | 0.24607699999999999018740481915301643311977386474609375     | 1451628000    | 1451606401           |                    | KBARRY      | RAMS     | 1462151267         | 1464283513      | 7                    | NO ERROR |           | 8        | [null, 41.62609815500008, -93.73166653299995, null, false, {paths=[[[-93.73166653299995, 41.62609815500008], [-93.73139984199997, 41.62621769100008], [-93.73132308999999, 41.626267014000064], [-93.73125239799998, 41.626321199000074], [-93.73118831499994, 41.62637982800004], [-93.73113133399994, 41.62644244900008], [-93.73108189499999, 41.62650858000006], [-93.73104037699994, 41.62657771100004], [-93.73100710599994, 41.62664930500006], [-93.73098233099995, 41.62672281700003], [-93.73096624999994, 41.626797673000056], [-93.73095897999997, 41.626873301000046], [-93.73096058499999, 41.62694911600005], [-93.73097104599998, 41.62702453300005], [-93.73099028599995, 41.62709897000008], [-93.73101815699994, 41.62717185300005], [-93.73105444199996, 41.62724262100005], [-93.73109886199995, 41.627310729000044], [-93.73141949299998, 41.62770981600005], [-93.73178424699995, 41.62817299300008], [-93.73188405399998, 41.62830427100005], [-93.73195769799997, 41.62842971600003], [-93.73199995199997, 41.62854737500004], [-93.73203177199997, 41.62867290400004], [-93.73203747999997, 41.62880273900004], [-93.73204008199997, 41.62891771000005], [-93.73205233999994, 41.62916732300005], [-93.73205647399999, 41.62925151500008]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 
| 0000079019 | M815542025N | 0            | 0.296501999999999987789323085962678305804729461669921875    | 1451628000    | 1451606401           |                    | KBARRY      | RAMS     | 1462151268         | 1464283513      | 7                    | NO ERROR |           | 9        | [null, 42.45839160100007, -92.36458930999999, null, false, {paths=[[[-92.36458930999999, 42.45839160100007], [-92.36459050799994, 42.45931453700007], [-92.36459257499996, 42.46090446300008], [-92.36458479599997, 42.46268885400008]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | 
| 0000079729 | M815547320E | 0            | 0.128259999999999985131893254219903610646724700927734375    | 1451628000    | 1451606401           |                    | KBARRY      | RAMS     | 1462151269         | 1464283513      | 7                    | NO ERROR |           | 10       | [null, 42.504084754000075, -92.32525214399999, null, false, {paths=[[[-92.32525214399999, 42.504084754000075], [-92.32440638099996, 42.504081015000054], [-92.32400091199997, 42.50407917800004], [-92.32399606999996, 42.504079156000046], [-92.32309394899994, 42.50406690800003], [-92.32274017399999, 42.504060870000046]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |