RAMS - HPMS Sample Sections

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.iowa.gov
Id csec-w5z4
Name RAMS - HPMS Sample Sections
Attribution Iowa Department of Transportation - Office of Research & Analytics
Category Transportation & Utilities
Tags iowa dot, iowa department of transportation, rams, hpms sample sections, asset, inventory
Created 2016-12-06T17:06:09Z
Publication Date 2016-12-06T17:08:10Z

Description

HPMS Sample Sections 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     | hpms_sample_id       | HPMS_SAMPLE_ID       | text       | text        |
| Yes      | numeric metric | peak_lanes           | PEAK_LANES           | number     | number      |
| Yes      | numeric metric | counter_peak_lanes   | COUNTER_PEAK_LANES   | number     | number      |
| Yes      | numeric metric | turn_lanes_r         | TURN_LANES_R         | number     | number      |
| Yes      | numeric metric | turn_lanes_l         | TURN_LANES_L         | number     | number      |
| Yes      | numeric metric | aadt_single_unit     | AADT_SINGLE_UNIT     | number     | number      |
| Yes      | numeric metric | pct_peak_single      | PCT_PEAK_SINGLE      | number     | number      |
| Yes      | numeric metric | aadt_combination     | AADT_COMBINATION     | number     | number      |
| Yes      | numeric metric | pct_peak_combination | PCT_PEAK_COMBINATION | number     | number      |
| Yes      | numeric metric | k_factor             | K_FACTOR             | number     | number      |
| Yes      | numeric metric | dir_factor           | DIR_FACTOR           | number     | number      |
| Yes      | numeric metric | future_aadt          | FUTURE_AADT          | number     | number      |
| No       |                | pct_green_time       | PCT_GREEN_TIME       | number     | number      |
| Yes      | numeric metric | number_signals       | NUMBER_SIGNALS       | number     | number      |
| Yes      | numeric metric | stop_signs           | STOP_SIGNS           | number     | number      |
| Yes      | numeric metric | at_grade_other       | AT_GRADE_OTHER       | number     | number      |
| Yes      | series tag     | signal_type          | SIGNAL_TYPE          | text       | number      |
| Yes      | numeric metric | lane_width           | LANE_WIDTH           | number     | number      |
| Yes      | numeric metric | pct_pass_sight       | PCT_PASS_SIGHT       | 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,pct_green_time,shape

Data Commands

series e:csec-w5z4 d:2016-01-01T06:00:00.000Z t:shape.longitude=-91.73482336999996 t:shape.needs_recoding=false t:route_id=C005746100E t:event_id=0000002340 t:user_create=MCLEMEN t:locerror="NO ERROR" t:user_mod=RAMS t:shape.latitude=41.905636995000066 t:objectid=1 t:hpms_sample_id=000000003845 t:signal_type=5 m:counter_peak_lanes=1 m:pct_peak_combination=0.017 m:from_measure=2.32772173 m:future_aadt=302 m:peak_lanes=1 m:number_signals=0 m:pct_peak_single=0.01 m:k_factor=19.7 m:turn_lanes_l=5 m:aadt_single_unit=6 m:lane_width=13 m:to_measure=3.28600345 m:dir_factor=70.10000000000001 m:turn_lanes_r=5 m:aadt_combination=7 m:stop_signs=0 m:at_grade_other=1

series e:csec-w5z4 d:2016-01-01T06:00:00.000Z t:shape.longitude=-91.70685827099999 t:shape.needs_recoding=false t:route_id=C005746825E t:event_id=0000000472 t:user_create=MCLEMEN t:locerror="NO ERROR" t:user_mod=RAMS t:shape.latitude=42.05891716200006 t:objectid=2 t:hpms_sample_id=000000127603 t:signal_type=5 m:counter_peak_lanes=1 m:pct_peak_combination=0.008 m:from_measure=2.8845983200000003 m:future_aadt=2689 m:peak_lanes=1 m:number_signals=0 m:pct_peak_single=0.006 m:k_factor=12.200000000000001 m:turn_lanes_l=5 m:aadt_single_unit=95 m:lane_width=12 m:to_measure=2.97008346 m:dir_factor=62 m:turn_lanes_r=5 m:aadt_combination=163 m:stop_signs=0 m:at_grade_other=1

series e:csec-w5z4 d:2016-01-01T06:00:00.000Z t:shape.longitude=-93.19743104899999 t:shape.needs_recoding=false t:route_id=C005946600E t:event_id=0000002406 t:user_create=MCLEMEN t:locerror="NO ERROR" t:user_mod=RAMS t:shape.latitude=41.04400040200005 t:objectid=3 t:hpms_sample_id=000000128600 m:pct_pass_sight=100 m:counter_peak_lanes=1 m:pct_peak_combination=0.017 m:from_measure=5.32821075 m:future_aadt=548 m:peak_lanes=1 m:number_signals=0 m:pct_peak_single=0.01 m:k_factor=19.7 m:aadt_single_unit=11 m:lane_width=11 m:to_measure=5.50752682 m:dir_factor=70.10000000000001 m:aadt_combination=13 m:stop_signs=0 m:at_grade_other=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:peak_lanes p:integer l:PEAK_LANES d:"Peak Lanes" t:dataTypeName=number

metric m:counter_peak_lanes p:integer l:COUNTER_PEAK_LANES d:"Counter Peak Lanes" t:dataTypeName=number

metric m:turn_lanes_r p:integer l:TURN_LANES_R d:"Right Turn Lanes" t:dataTypeName=number

metric m:turn_lanes_l p:integer l:TURN_LANES_L d:"Left Turn Lanes" t:dataTypeName=number

metric m:aadt_single_unit p:integer l:AADT_SINGLE_UNIT d:"AADT Single Unit" t:dataTypeName=number

metric m:pct_peak_single p:float l:PCT_PEAK_SINGLE d:"PCT Peak Single" t:dataTypeName=number

metric m:aadt_combination p:integer l:AADT_COMBINATION d:"AADT Combination" t:dataTypeName=number

metric m:pct_peak_combination p:float l:PCT_PEAK_COMBINATION d:"PCT Peak Combination" t:dataTypeName=number

metric m:k_factor p:float l:K_FACTOR d:"K Factor" t:dataTypeName=number

metric m:dir_factor p:double l:DIR_FACTOR d:"Direction Factor" t:dataTypeName=number

metric m:future_aadt p:integer l:FUTURE_AADT d:"Future AADT" t:dataTypeName=number

metric m:number_signals p:integer l:NUMBER_SIGNALS d:"Number Signals" t:dataTypeName=number

metric m:stop_signs p:integer l:STOP_SIGNS d:"Stop Signs" t:dataTypeName=number

metric m:at_grade_other p:integer l:AT_GRADE_OTHER d:"At Grade Other" t:dataTypeName=number

metric m:lane_width p:integer l:LANE_WIDTH d:"Lane Width" t:dataTypeName=number

metric m:pct_pass_sight p:integer l:PCT_PASS_SIGHT d:"PCT Pass Sight" t:dataTypeName=number

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

entity e:csec-w5z4 l:"RAMS - HPMS Sample Sections" t:attribution="Iowa Department of Transportation - Office of Research & Analytics" t:url=https://data.iowa.gov/api/views/csec-w5z4

property e:csec-w5z4 t:meta.view v:id=csec-w5z4 v:category="Transportation & Utilities" v:averageRating=0 v:name="RAMS - HPMS Sample Sections" v:attribution="Iowa Department of Transportation - Office of Research & Analytics"

property e:csec-w5z4 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:csec-w5z4 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 | hpms_sample_id | peak_lanes | counter_peak_lanes | turn_lanes_r | turn_lanes_l | aadt_single_unit | pct_peak_single                                               | aadt_combination | pct_peak_combination                                        | k_factor                                             | dir_factor                                        | future_aadt | pct_green_time | number_signals | stop_signs | at_grade_other | signal_type | lane_width | pct_pass_sight | locerror | shape_len | objectid | shape                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | 
| ========== | =========== | ======================================================= | ====================================================== | ============= | ==================== | ================== | =========== | ======== | ================== | =============== | ============== | ========== | ================== | ============ | ============ | ================ | ============================================================= | ================ | =========================================================== | ==================================================== | ================================================= | =========== | ============== | ============== | ========== | ============== | =========== | ========== | ============== | ======== | ========= | ======== | =========================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================== | 
| 0000002340 | C005746100E | 2.327721729999999933369281279738061130046844482421875   | 3.28600344999999993689243638073094189167022705078125   | 1451628000    | 1451606401           |                    | MCLEMEN     | RAMS     | 1462454000         | 1464874008      | 000000003845   | 1          | 1                  | 5            | 5            | 6                | 0.01000000000000000020816681711721685132943093776702880859375 | 7                | 0.01700000000000000122124532708767219446599483489990234375  | 19.699999999999999289457264239899814128875732421875  | 70.1000000000000085265128291212022304534912109375 | 302         |                | 0              | 0          | 1              | 5           | 13         |                | NO ERROR |           | 1        | [null, 41.905636995000066, -91.73482336999996, null, false, {paths=[[[-91.73482336999996, 41.905636995000066], [-91.73364600699995, 41.905639276000045], [-91.73074468599998, 41.90567317600005], [-91.72632212699995, 41.905679889000055], [-91.72349315899999, 41.90569327400004], [-91.72153548199998, 41.90569866000004], [-91.71925199199995, 41.90571682900003], [-91.71622980199999, 41.90573670600003]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 
| 0000000472 | C005746825E | 2.8845983200000002710794433369301259517669677734375     | 2.970083460000000119549667942919768393039703369140625  | 1451628000    | 1451606401           |                    | MCLEMEN     | RAMS     | 1462454000         | 1464874006      | 000000127603   | 1          | 1                  | 5            | 5            | 95               | 0.00600000000000000012490009027033011079765856266021728515625 | 163              | 0.008000000000000000166533453693773481063544750213623046875 | 12.2000000000000010658141036401502788066864013671875 | 62                                                | 2689        | 41             | 0              | 0          | 1              | 5           | 12         |                | NO ERROR |           | 2        | [null, 42.05891716200006, -91.70685827099999, null, false, {paths=[[[-91.70685827099999, 42.05891716200006], [-91.70603857799995, 42.058911849000026], [-91.70546291299996, 42.058910009000044], [-91.70519573099995, 42.05890355100007]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | 
| 0000002406 | C005946600E | 5.328210750000000217596607399173080921173095703125      | 5.50752681999999982309645929490216076374053955078125   | 1451628000    | 1451606401           |                    | MCLEMEN     | RAMS     | 1462454001         | 1464874006      | 000000128600   | 1          | 1                  |              |              | 11               | 0.01000000000000000020816681711721685132943093776702880859375 | 13               | 0.01700000000000000122124532708767219446599483489990234375  | 19.699999999999999289457264239899814128875732421875  | 70.1000000000000085265128291212022304534912109375 | 548         |                | 0              | 0          | 0              |             | 11         | 100            | NO ERROR |           | 3        | [null, 41.04400040200005, -93.19743104899999, null, false, {paths=[[[-93.19743104899999, 41.04400040200005], [-93.19660013199996, 41.04401589400004], [-93.19457923099998, 41.044035475000044], [-93.19399844099996, 41.04404463100008]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | 
| 0000000005 | C006242650N | 0.85639553000000001592439957676106132566928863525390625 | 1.3159628999999999354741930801537819206714630126953125 | 1451628000    | 1451606401           |                    | MCLEMEN     | RAMS     | 1462453999         | 1464874005      | 000000130230   | 1          | 1                  |              |              | 10               | 0.01000000000000000020816681711721685132943093776702880859375 | 12               | 0.01700000000000000122124532708767219446599483489990234375  | 19.699999999999999289457264239899814128875732421875  | 70.1000000000000085265128291212022304534912109375 | 408         |                | 0              | 0          | 1              |             | 12         | 100            | NO ERROR |           | 4        | [null, 41.40128015300007, -92.59425216499994, null, false, {paths=[[[-92.59425216499994, 41.40128015300007], [-92.59417220799997, 41.40133909800005], [-92.59409195299997, 41.40141484800006], [-92.59401909599995, 41.40149472600007], [-92.59395401099994, 41.401578319000066], [-92.59389702599998, 41.40166520100007], [-92.59384843799995, 41.40175492900005], [-92.59380849399997, 41.40184704300003], [-92.59377739599995, 41.40194106900003], [-92.59375530499995, 41.40203653100008], [-92.59374233499994, 41.40213293700003], [-92.59374237999998, 41.40280501800004], [-92.59376400999997, 41.40396822500003], [-92.59379982399997, 41.40569876100005], [-92.59382805799999, 41.40684295400007], [-92.59381686899997, 41.40693023400007], [-92.59379813899994, 41.407016776000034], [-92.59377194399997, 41.40710221300003], [-92.59373839499995, 41.40718618200003], [-92.59369763599994, 41.40726832000007], [-92.59364984299998, 41.407348282000044], [-92.59359521799996, 41.40742572200003], [-92.59353399299994, 41.40750031300007], [-92.59346642999998, 41.40757173600008], [-92.59328748999997, 41.407727098000066]]]}] | 
| 0000000675 | C006641060N | 12.937334570000000866230038809590041637420654296875     | 13.944213919999999262699930113740265369415283203125    | 1451628000    | 1451606401           |                    | MCLEMEN     | RAMS     | 1462454000         | 1464874008      | 000000132343   | 1          | 1                  |              |              | 16               | 0.01000000000000000020816681711721685132943093776702880859375 | 20               | 0.01700000000000000122124532708767219446599483489990234375  | 19.699999999999999289457264239899814128875732421875  | 70.1000000000000085265128291212022304534912109375 | 388         |                | 0              | 0          | 1              |             | 11         | 100            | NO ERROR |           | 5        | [null, 43.429115195000065, -92.98519175199999, null, false, {paths=[[[-92.98519175199999, 43.429115195000065], [-92.98520753099996, 43.431305053000074], [-92.98525553599995, 43.434399118000044], [-92.98529754399999, 43.43703229100004], [-92.98533684499995, 43.43999412200003], [-92.98536745399997, 43.442227108000054], [-92.98539614999999, 43.443700711000076]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | 
| 0000001516 | C006746010E | 3.49069744999999986845296007231809198856353759765625    | 3.58806606000000005707306627300567924976348876953125   | 1451628000    | 1451606401           |                    | MCLEMEN     | RAMS     | 1462454000         | 1464874006      | 000000132490   | 1          | 1                  |              |              | 4                | 0.01000000000000000020816681711721685132943093776702880859375 | 5                | 0.01700000000000000122124532708767219446599483489990234375  | 19.699999999999999289457264239899814128875732421875  | 70.1000000000000085265128291212022304534912109375 | 98          |                | 0              | 0          | 0              |             | 11         | 100            | NO ERROR |           | 6        | [null, 41.92094232300008, -96.02189170699995, null, false, {paths=[[[-96.02189170699995, 41.92094232300008], [-96.02169415099996, 41.920780113000035], [-96.02153443399999, 41.92061554800006], [-96.02137865799995, 41.92042944100007], [-96.02129211199997, 41.920299028000045], [-96.02120387799994, 41.92012574100005], [-96.02114519299994, 41.91997325900007], [-96.02106736399998, 41.91969960900008]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | 
| 0000001157 | C006846650E | 7.31836138999999974430465954355895519256591796875       | 7.369506460000000203081071958877146244049072265625     | 1451628000    | 1451606401           |                    | MCLEMEN     | RAMS     | 1462454000         | 1464874006      | 000000133205   | 1          | 1                  |              |              | 18               | 0.01000000000000000020816681711721685132943093776702880859375 | 22               | 0.01700000000000000122124532708767219446599483489990234375  | 19.699999999999999289457264239899814128875732421875  | 70.1000000000000085265128291212022304534912109375 | 759         |                | 0              | 1          | 0              |             | 11         | 100            | NO ERROR |           | 7        | [null, 41.063524476000055, -92.71872969899994, null, false, {paths=[[[-92.71872969899994, 41.063524476000055], [-92.71868943899995, 41.06352618500006], [-92.71775024799996, 41.063526696000054]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | 
| 0000001520 | C006847130E | 11.958945310000000716854628990404307842254638671875     | 12.090384820000000587469912716187536716461181640625    | 1451628000    | 1451606401           |                    | MCLEMEN     | RAMS     | 1462454000         | 1464874008      | 000000001892   | 1          | 1                  |              |              | 2                | 0.01000000000000000020816681711721685132943093776702880859375 | 3                | 0.01700000000000000122124532708767219446599483489990234375  | 19.699999999999999289457264239899814128875732421875  | 70.1000000000000085265128291212022304534912109375 | 61          |                | 0              | 0          | 0              |             | 12         | 100            | NO ERROR |           | 8        | [null, 41.14738138200005, -92.73859090399998, null, false, {paths=[[[-92.73859090399998, 41.14738138200005], [-92.73841787499998, 41.14738933800004], [-92.73813351399997, 41.147441048000076], [-92.73789170999999, 41.147493042000065], [-92.73765919699997, 41.147559398000055], [-92.73727468599998, 41.14768192900004], [-92.73703250299997, 41.14776609300003], [-92.73688557099996, 41.14779370200006], [-92.73665841599995, 41.147806469000045], [-92.73640314199997, 41.14779759800007], [-92.73616991699998, 41.147769209000046]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 
| 0000001288 | C006847130E | 12.090384820000000587469912716187536716461181640625     | 12.3566353200000005330139174475334584712982177734375   | 1451628000    | 1451606401           |                    | MCLEMEN     | RAMS     | 1462454000         | 1464874008      | 000000133341   | 1          | 1                  |              |              | 2                | 0.01000000000000000020816681711721685132943093776702880859375 | 3                | 0.01700000000000000122124532708767219446599483489990234375  | 19.699999999999999289457264239899814128875732421875  | 70.1000000000000085265128291212022304534912109375 | 61          |                | 0              | 0          | 0              |             | 12         | 100            | NO ERROR |           | 9        | [null, 41.147769209000046, -92.73616991699998, null, false, {paths=[[[-92.73616991699998, 41.147769209000046], [-92.73603006699994, 41.14775218600005], [-92.73539238999996, 41.14768711000005], [-92.73464151499996, 41.147596243000066], [-92.73399906799995, 41.147534703000076], [-92.73305891599995, 41.147453272000064], [-92.73234038699997, 41.147426954000025], [-92.73132875599998, 41.14739149400003], [-92.73109462199994, 41.147387122000055]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 
| 0000000646 | C007346040E | 4.03831995999999993074425219674594700336456298828125    | 5.037747650000000021464074961841106414794921875        | 1451628000    | 1451606401           |                    | MCLEMEN     | RAMS     | 1462454000         | 1464874006      | 000000135081   | 1          | 1                  |              |              | 11               | 0.01000000000000000020816681711721685132943093776702880859375 | 13               | 0.01700000000000000122124532708767219446599483489990234375  | 19.699999999999999289457264239899814128875732421875  | 70.1000000000000085265128291212022304534912109375 | 270         |                | 0              | 0          | 2              |             | 11         | 100            | NO ERROR |           | 10       | [null, 40.59652964700007, -95.29710291299995, null, false, {paths=[[[-95.29710291299995, 40.59652964700007], [-95.29606468499998, 40.596522133000065], [-95.29497626399996, 40.59651093400004], [-95.29262127699997, 40.59649134800003], [-95.29036952599995, 40.59647364400007], [-95.28787750999999, 40.59641681800008], [-95.28571844699997, 40.596358217000045], [-95.28515997899996, 40.59634564600003], [-95.28355587399994, 40.59634253300004], [-95.28147329399997, 40.59633626300007], [-95.27979876899997, 40.59633063600006], [-95.27836812299995, 40.596324700000025], [-95.27810248599997, 40.59632467100005]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |