RAMS - Right Shoulder Tied

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.iowa.gov
Id mmda-skkx
Name RAMS - Right Shoulder Tied
Attribution Iowa Department of Transportation - Office of Research & Analytics
Category Transportation & Utilities
Tags iowa dot, iowa department of transportation, rams, right shoulder tied, asset, inventory
Created 2016-12-06T19:40:24Z
Publication Date 2016-12-06T19:41:47Z

Description

Right Shoulder Tied data maintained inside the Roadway Asset Management System (RAMS).

Columns

| Included | Schema Type    | Field Name           | Name                 | Data Type  | Render Type |
| ======== | ============== | ==================== | ==================== | ========== | =========== |
| Yes      | series tag     | event_id             | EVENT_ID             | text       | text        |
| Yes      | series tag     | route_id             | ROUTE_ID             | text       | text        |
| Yes      | numeric metric | from_measure         | FROM_MEASURE         | number     | number      |
| Yes      | numeric metric | to_measure           | TO_MEASURE           | number     | number      |
| Yes      | time           | business_date        | BUSINESS_DATE        | date       | date        |
| No       |                | effective_start_date | EFFECTIVE_START_DATE | date       | date        |
| No       |                | effective_end_date   | EFFECTIVE_END_DATE   | date       | date        |
| Yes      | series tag     | user_create          | USER_CREATE          | text       | text        |
| Yes      | series tag     | user_mod             | USER_MOD             | text       | text        |
| No       |                | system_create_date   | SYSTEM_CREATE_DATE   | date       | date        |
| No       |                | system_mod_date      | SYSTEM_MOD_DATE      | date       | date        |
| Yes      | numeric metric | right_shoulder_tied  | RIGHT_SHOULDER_TIED  | 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:mmda-skkx d:2016-01-01T06:00:00.000Z t:shape.longitude=-92.84295972899997 t:shape.needs_recoding=false t:route_id=S001920030E t:event_id=0000000172 t:user_create=JRENFRO t:locerror="NO ERROR" t:shape.latitude=42.006751000000065 t:user_mod=RAMS t:objectid=1 m:right_shoulder_tied=1 m:to_measure=188.161304 m:from_measure=188.156808

series e:mmda-skkx d:2016-01-01T06:00:00.000Z t:shape.longitude=-91.80782881999994 t:shape.needs_recoding=false t:route_id=S001930002E t:event_id=0000000098 t:user_create=JRENFRO t:locerror="NO ERROR" t:shape.latitude=40.67546879300005 t:user_mod=RAMS t:objectid=2 m:right_shoulder_tied=1 m:to_measure=231.364606 m:from_measure=226.523238

series e:mmda-skkx d:2016-01-01T06:00:00.000Z t:shape.longitude=-92.96786588899994 t:shape.needs_recoding=false t:route_id=S001930003E t:event_id=0000000303 t:user_create=JRENFRO t:locerror="NO ERROR" t:shape.latitude=42.74493283600003 t:user_mod=RAMS t:objectid=3 m:right_shoulder_tied=1 m:to_measure=202.44271 m:from_measure=194.512342

Meta Commands

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

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

metric m:right_shoulder_tied p:integer l:RIGHT_SHOULDER_TIED d:"Right Shoulder Tied" t:dataTypeName=number

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

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

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

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

Top Records

| event_id   | route_id    | from_measure                                           | to_measure                                          | business_date | effective_start_date | effective_end_date | user_create | user_mod | system_create_date | system_mod_date | right_shoulder_tied | locerror | shape_len | objectid | shape                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | 
| ========== | =========== | ====================================================== | =================================================== | ============= | ==================== | ================== | =========== | ======== | ================== | =============== | =================== | ======== | ========= | ======== | ===================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================== | 
| 0000000172 | S001920030E | 188.15680800000001227090251632034778594970703125       | 188.161304000000001224179868586361408233642578125   | 1451628000    | 1451606401           |                    | JRENFRO     | RAMS     | 1459776491         | 1463753965      | 1                   | NO ERROR |           | 1        | [null, 42.006751000000065, -92.84295972899997, null, false, {paths=[[[-92.84295972899997, 42.006751000000065], [-92.84287235799997, 42.006751644000076]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 
| 0000000098 | S001930002E | 226.523237999999992098310030996799468994140625         | 231.364606000000009089490049518644809722900390625   | 1451628000    | 1451606401           |                    | JRENFRO     | RAMS     | 1459776491         | 1463753965      | 1                   | NO ERROR |           | 2        | [null, 40.67546879300005, -91.80782881999994, null, false, {paths=[[[-91.80782881999994, 40.67546879300005], [-91.80735628099995, 40.675495098000056], [-91.80679602499998, 40.67552425000008], [-91.80671679999995, 40.67552837200003], [-91.80634203299996, 40.675494126000046], [-91.80599304199995, 40.675431667000055], [-91.80584074599994, 40.675392454000075], [-91.80569136699995, 40.67534720300006], [-91.80554531399997, 40.67529604300006], [-91.80540299499995, 40.67523911500007], [-91.80526479599996, 40.675176571000065], [-91.80513110399994, 40.67510858900005], [-91.80500228799997, 40.67503535600008], [-91.80487869999996, 40.67495707100005], [-91.80476068299998, 40.67487395200004], [-91.80464856299994, 40.67478623100004], [-91.80454264999997, 40.67469414300007], [-91.80444323499995, 40.67459795100007], [-91.80435069799995, 40.674488730000064], [-91.80426564799996, 40.67437603500008], [-91.80418831299994, 40.67426016300004], [-91.80411889499999, 40.67414142000007], [-91.80405757699998, 40.67402012000008], [-91.80396339299995, 40.67378989300005], [-91.80388555299999, 40.67344921000006], [-91.80388470599996, 40.673445497000046], [-91.80388687899995, 40.67312138700004], [-91.80392549199996, 40.67235928300005], [-91.80390901599998, 40.67203012700003], [-91.80391850399997, 40.67142488700006], [-91.80395748999996, 40.67064848800004], [-91.80398599799997, 40.67003400200008], [-91.80398130099996, 40.66925217900007], [-91.80399494499994, 40.66824659200006], [-91.80406621299994, 40.66695110100005], [-91.80408530399995, 40.66621730400004], [-91.80415935999997, 40.66457388100008], [-91.80418786599995, 40.66395939700004], [-91.80424989899996, 40.66229672600008], [-91.80435591999998, 40.65990540300004], [-91.80439526799995, 40.65863326600004], [-91.80438705899996, 40.65847981500008], [-91.80437039599997, 40.65832676200006], [-91.80434531099996, 40.65817437700008], [-91.80431184599996, 40.65802292800004], [-91.80427005799999, 40.65787268200006], [-91.80422002499995, 40.65772390700005], [-91.80416183399996, 40.65757686200004], [-91.80409558499997, 40.65743180700008], [-91.80402139799997, 40.65728899800007], [-91.80393940299996, 40.65714868800006], [-91.80354096599996, 40.65658496200007], [-91.80220092499997, 40.65492496000007], [-91.80107520899998, 40.65344931800007], [-91.80085668499999, 40.65318860900004], [-91.80068985099996, 40.652981115000046], [-91.80037170599996, 40.652585430000045], [-91.80011664499995, 40.65228603200006], [-91.79972655599994, 40.65188449000004], [-91.79955988299997, 40.65172735200008], [-91.79938659999999, 40.65157441800005], [-91.79920689099998, 40.65142584900008], [-91.79902094499994, 40.65128180100004], [-91.79882895999998, 40.651142425000046], [-91.79863113399995, 40.65100787000006], [-91.79842768099996, 40.650878275000025], [-91.79821881299995, 40.650753777000034], [-91.79800474799998, 40.65063451000003], [-91.79778571499997, 40.650520595000046], [-91.79756194199996, 40.65041215700006], [-91.79733670799999, 40.65031116800003], [-91.79710738899996, 40.65021565500007], [-91.79687422199999, 40.65012571600005], [-91.79663743299994, 40.65004144300008], [-91.79639726299996, 40.64996291700004], [-91.79615395199994, 40.649890216000074], [-91.79590774299999, 40.649823414000025], [-91.79565888499997, 40.64976258000007], [-91.79540761999993, 40.64970777100007], [-91.79515420799999, 40.64965904500008], [-91.79489889699994, 40.64961645000005], [-91.79464194799993, 40.64958002900005], [-91.79438361199999, 40.649549818000025], [-91.79412414999996, 40.649525846000074], [-91.79389127299999, 40.64950807500003], [-91.79365771399995, 40.64949661800006], [-91.79342376799997, 40.64949149000006], [-91.79318972999994, 40.64949269400006], [-91.79295589599997, 40.64950023400007], [-91.79272255899997, 40.649514099000044], [-91.79076019199994, 40.64964634200004], [-91.78991689199995, 40.64970475200005], [-91.78867231799995, 40.64979094300003], [-91.78712332999999, 40.64991035000003], [-91.78638336799997, 40.64996580600007], [-91.78593205799996, 40.64999229000006], [-91.78570684099998, 40.64998885500006], [-91.78550219499994, 40.64998350700006], [-91.78527438299994, 40.64997755100006], [-91.78526904599994, 40.649977412000055], [-91.78504433099994, 40.64995491500008], [-91.78469524599996, 40.64990192100004], [-91.78452908899999, 40.64986660400007], [-91.78436521099997, 40.64982556600006], [-91.78420395599994, 40.649778893000075], [-91.78404565499994, 40.64972668100006], [-91.78389063599997, 40.64966903900006], [-91.78373922199995, 40.64960608600006], [-91.78288005599995, 40.64919732000004], [-91.78229365099997, 40.64888805100003], [-91.78033003599995, 40.647880831000066], [-91.77909509599993, 40.64724701200004], [-91.77787882299998, 40.64661823200004], [-91.77669947799995, 40.64601384000008], [-91.77567427399998, 40.645497601000045], [-91.77518663699999, 40.645242246000066], [-91.77494464599994, 40.645128499000066], [-91.77469843199998, 40.64502013500004], [-91.77444820599999, 40.64491724800007], [-91.77419417299996, 40.64481991900004], [-91.77393654799994, 40.644728230000055], [-91.77367554899996, 40.64464226200005], [-91.77231620299995, 40.64422096200008], [-91.77045448299998, 40.64362984400003], [-91.76833209899996, 40.64295841000006], [-91.76763707399994, 40.642737958000055], [-91.76704112099998, 40.64255716500003], [-91.76678067899996, 40.642467346000046], [-91.76659498199996, 40.64240732900004], [-91.76640601899999, 40.64235355300008], [-91.76621414999994, 40.64230612000006], [-91.76601974299996, 40.642265122000026], [-91.76582316699995, 40.64223063600008], [-91.76562480099994, 40.642202731000054], [-91.76542502399997, 40.64218145800004], [-91.76522421599998, 40.64216685700006], [-91.76465536899997, 40.64214377500008], [-91.76356670399997, 40.64213649100003], [-91.76262765699994, 40.64215057800004], [-91.76242146299995, 40.642143668000074], [-91.76221576999995, 40.642130705000056], [-91.76201088699997, 40.64211170300007], [-91.76180712099995, 40.642086696000035], [-91.76160476999996, 40.64205571900004], [-91.76140414099996, 40.642018816000075], [-91.76120553099997, 40.64197604700007], [-91.75883629099997, 40.641415014000074], [-91.75608820499997, 40.64074795100004], [-91.75369441799995, 40.64017212600004], [-91.75209293099994, 40.63978227700005], [-91.75091176799998, 40.63949205400007], [-91.75062250599996, 40.63944187100003], [-91.75031009399999, 40.63939484000008], [-91.74992776499994, 40.639374830000065], [-91.74974351799995, 40.639364933000024], [-91.74929569299997, 40.63937904100004], [-91.74861524999994, 40.639466827000035], [-91.74792378799998, 40.63962120200006], [-91.74761278599999, 40.63971103600005], [-91.74725434099997, 40.639814571000045], [-91.74689377699997, 40.63993007000005]]]}] | 
| 0000000303 | S001930003E | 194.512341999999989639036357402801513671875            | 202.442710000000005265974323265254497528076171875   | 1451628000    | 1451606401           |                    | JRENFRO     | RAMS     | 1459776491         | 1463753965      | 1                   | NO ERROR |           | 3        | [null, 42.74493283600003, -92.96786588899994, null, false, {paths=[[[-92.96786588899994, 42.74493283600003], [-92.96676480599996, 42.74492978200004], [-92.96630012899999, 42.74492969800008], [-92.95947219299995, 42.744928239000046], [-92.95646640399997, 42.744922829000075], [-92.95199057999997, 42.74491462800006], [-92.94896500699997, 42.74490388800007], [-92.94882492599999, 42.744902265000064], [-92.94753026699999, 42.74488725700007], [-92.94687537499999, 42.74487966100003], [-92.94674221999998, 42.74487987500004], [-92.94351024599996, 42.74488503100008], [-92.93794355499995, 42.74491183500004], [-92.93695765899997, 42.744910479000055], [-92.93278931599997, 42.74490465000008], [-92.92941467899999, 42.74488812200008], [-92.92362556599994, 42.74484524700006], [-92.91992605499996, 42.744812479000075], [-92.91945181199998, 42.74480826900003], [-92.91809835299995, 42.74479624500003], [-92.90916750099996, 42.74472257100007], [-92.90597214499996, 42.74472057000003], [-92.90374302399994, 42.74475627000004], [-92.90106923599996, 42.74479903500003], [-92.89658831299994, 42.74486161600004], [-92.89253416499997, 42.744915536000065], [-92.89015291199996, 42.74496381300003], [-92.88894848899997, 42.744968535000055], [-92.88781567899997, 42.74497296200008], [-92.88566767599997, 42.744968769000025], [-92.88285531399998, 42.74497173100008], [-92.87969385099996, 42.74497276000005], [-92.87792895899997, 42.744963322000046], [-92.87490311599998, 42.744979242000056], [-92.87276014099996, 42.74495696900004], [-92.87076718999998, 42.74496405900004], [-92.86925805399994, 42.74496729100008], [-92.86746019599997, 42.744971114000066], [-92.86549647899994, 42.74496397900003], [-92.86031785699998, 42.74496774000005], [-92.85399988799998, 42.74495779200004], [-92.85292609299995, 42.74496865300006], [-92.85263746299995, 42.744971571000065], [-92.85240444699997, 42.74497392600006], [-92.84949196599996, 42.74494770200005], [-92.84822026199998, 42.74493622700004], [-92.84400680799996, 42.74491608300008], [-92.83912428699995, 42.74488840600003], [-92.83328186799997, 42.74484429600005], [-92.82980526199998, 42.74483563500007], [-92.82561601399999, 42.74482506000004], [-92.81849809299996, 42.74480496000007], [-92.81194778199995, 42.74479417100008]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | 
| 0000000410 | S001930003E | 1.4788259999999999738662381787435151636600494384765625 | 6.2143660000000000565023583476431667804718017578125 | 1451628000    | 1451606401           |                    | JRENFRO     | RAMS     | 1459776491         | 1463753965      | 1                   | NO ERROR |           | 4        | [null, 42.76161344500008, -96.60355621299999, null, false, {paths=[[[-96.60355621299999, 42.76161344500008], [-96.60319927299997, 42.76254561400003], [-96.60278580899995, 42.76361160600004], [-96.60261480299994, 42.764051779000056], [-96.60247134199994, 42.76442104700004], [-96.60241322499996, 42.764572833000045], [-96.60224001799997, 42.76502519200005], [-96.60183911499996, 42.76607220200003], [-96.60135181299995, 42.767315386000064], [-96.60113323499996, 42.76790412200006], [-96.60061601199999, 42.769230349000054], [-96.60039186799997, 42.76980492600006], [-96.60024099699996, 42.77019159200006], [-96.60010133099996, 42.77051001400008], [-96.59992340899998, 42.770840186000044], [-96.59974513499998, 42.77116321300008], [-96.59940772699997, 42.771705051000026], [-96.59841071199997, 42.77334445400004], [-96.59766027499995, 42.774569599000074], [-96.59718827399996, 42.77533673200003], [-96.59637032999996, 42.77667095000004], [-96.59603409199997, 42.77723777700004], [-96.59528770899999, 42.77844849000007], [-96.59490922199996, 42.77904504700007], [-96.59460818999997, 42.77951033900007], [-96.59453019899996, 42.779630886000064], [-96.59397949699996, 42.78037864300006], [-96.59359362099997, 42.78082519700007], [-96.59282425199996, 42.781668171000035], [-96.59239315199994, 42.78208373900003], [-96.59175104399998, 42.78265153900003], [-96.59066220499994, 42.783613855000056], [-96.58960032499999, 42.784532530000035], [-96.58845498399995, 42.785532086000046], [-96.58691892999997, 42.78688173200004], [-96.58602141299997, 42.78766675700007], [-96.58535458699998, 42.788249989000064], [-96.58463721899994, 42.78886980500005], [-96.58356668799996, 42.789813681000055], [-96.58272481999995, 42.79056910200006], [-96.58231158799998, 42.79095554700007], [-96.58185872799999, 42.791425289000074], [-96.58138475599998, 42.79195995500004], [-96.58104616699995, 42.792383751000045], [-96.58067537399995, 42.792844159000026], [-96.58025786499996, 42.793441693000034], [-96.58003809799999, 42.79379065200004], [-96.57984331699998, 42.794099938000045], [-96.57944142399998, 42.79481863700005], [-96.57905406999998, 42.79553694900005], [-96.57872989199996, 42.79615703400003], [-96.57827571099995, 42.79699869700005], [-96.57760393799998, 42.798257360000036], [-96.57716357799995, 42.799084349000054], [-96.57646510399996, 42.80039377300005], [-96.57603301999995, 42.80119192900003], [-96.57538781799997, 42.802399808000075], [-96.57485824099996, 42.80339006300005], [-96.57442646199996, 42.80419535300007], [-96.57374138199998, 42.80548294600004], [-96.57334489299996, 42.80621577800008], [-96.57237441799998, 42.80802584700007], [-96.57211422899996, 42.808504431000074], [-96.57191088699994, 42.808878452000044], [-96.57130657199997, 42.810031579000054], [-96.57078154099997, 42.811018114000035], [-96.57026930699999, 42.81196854900003], [-96.56941503299998, 42.81357526100004], [-96.56880438799999, 42.814699930000074], [-96.56841246199997, 42.81542904500003], [-96.56778965899997, 42.816604090000055], [-96.56765674399998, 42.81684600800003], [-96.56741485499998, 42.81728625900007], [-96.56670333499994, 42.81863528500003], [-96.56640957199994, 42.819186579000075], [-96.56600902799994, 42.819927059000065], [-96.56566976999994, 42.820554220000076], [-96.56525525199999, 42.82131967400005], [-96.56474612599999, 42.82213768400004], [-96.56452550499995, 42.82249380600007], [-96.56447869999994, 42.82256935600003], [-96.56439030099995, 42.82271206200005], [-96.56413967099996, 42.82311918000005]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | 
| 0000000102 | S001930004N | 118.398367000000007465132512152194976806640625         | 129.1791259999999965657480061054229736328125        | 1451628000    | 1451606401           |                    | JRENFRO     | RAMS     | 1459776491         | 1463753965      | 1                   | NO ERROR |           | 5        | [null, 43.13196388800003, -94.75785370599999, null, false, {paths=[[[-94.75785370599999, 43.13196388800003], [-94.75783894499995, 43.13290929400006], [-94.75784507999998, 43.13491753900007], [-94.75781613099997, 43.13687970500007], [-94.75778682999999, 43.13858100500005], [-94.75778664799998, 43.140517844000044], [-94.75777696299997, 43.14113959600007], [-94.75775892199994, 43.14229774000006], [-94.75773102799997, 43.14504248000003], [-94.75770881499994, 43.14709747300003], [-94.75769572199994, 43.148877208000044], [-94.75767616299999, 43.15082139000003], [-94.75766808299994, 43.15285121000005], [-94.75764062799999, 43.154888381000035], [-94.75763245799999, 43.15564045900004], [-94.75761833699994, 43.15693979200006], [-94.75761585399994, 43.15900527900004], [-94.75759262899999, 43.16101024000005], [-94.75758504699996, 43.16306505600005], [-94.75758206099994, 43.16510553000006], [-94.75759001699998, 43.168907588000025], [-94.75758926199995, 43.169187245000046], [-94.75758480399998, 43.17083730300004], [-94.75757312999997, 43.172931462000065], [-94.75754802999995, 43.175086511000075], [-94.75752357199997, 43.177273710000065], [-94.75749811399999, 43.17916789900005], [-94.75746884899996, 43.181115729000055], [-94.75744733299996, 43.183206408000046], [-94.75746266399995, 43.18360417400004], [-94.75752884399998, 43.18532099200007], [-94.75760591899996, 43.18697107700007], [-94.75761873799996, 43.18723588700004], [-94.75770603999996, 43.18903900200007], [-94.75781212299995, 43.19116046200003], [-94.75791419499996, 43.19332484300003], [-94.75799796199999, 43.19530717500004], [-94.75805839799995, 43.19734335800007], [-94.75811488499994, 43.199426035000045], [-94.75819019199997, 43.201472773000035], [-94.75821256799998, 43.20217378500007], [-94.75821587499996, 43.20227737100004], [-94.75825609599997, 43.203537477000054], [-94.75830735499994, 43.20560233400005], [-94.75830675999998, 43.20751766600006], [-94.75830465599995, 43.209600962000025], [-94.75831648699995, 43.21164837100008], [-94.75831467599994, 43.212537731000054], [-94.75831244199998, 43.213635201000045], [-94.75831773699997, 43.215600488000064], [-94.75831448499997, 43.21762661300005], [-94.75831259599994, 43.21972061500003], [-94.75830955799995, 43.22175745100003], [-94.75831937699996, 43.223947802000055], [-94.75832100899999, 43.22597386500007], [-94.75832282599998, 43.227191305000076], [-94.75832414799999, 43.22807494800003], [-94.75832707299998, 43.23016531300004], [-94.75832698099998, 43.23073702200003], [-94.75832676599998, 43.23209490900007], [-94.75832508999997, 43.234199611000065], [-94.75832527899996, 43.234368879000044], [-94.75832736899997, 43.236257815000045], [-94.75832003599999, 43.23662237100007], [-94.75832292999996, 43.23694763200007], [-94.75832391299997, 43.23705827400005], [-94.75830766899998, 43.237465806000046], [-94.75827845599997, 43.23787083600007], [-94.75826562599997, 43.238048707000075], [-94.75824226799995, 43.23834554300004], [-94.75820091999998, 43.23879705600007], [-94.75817413499999, 43.23908952200003], [-94.75812291599999, 43.23972259400006], [-94.75810758299997, 43.23991209700006], [-94.75804035799996, 43.240611596000065], [-94.75799035899996, 43.24113185500005], [-94.75795088599995, 43.24170858600007], [-94.75792990799994, 43.24201510800003], [-94.75787348599994, 43.242612456000074], [-94.75778348999995, 43.24372829200007], [-94.75760924599996, 43.24575979400004], [-94.75760801899997, 43.24594204500005], [-94.75760449199998, 43.24625295800007], [-94.75761116899997, 43.24658520200006], [-94.75763099899996, 43.246842266000044], [-94.75767231499998, 43.24719557800006], [-94.75772333699996, 43.24754521300008], [-94.75777205899999, 43.24778052700003], [-94.75781934499997, 43.24794439000004], [-94.75787727099998, 43.248151019000034], [-94.75792491699997, 43.24833274500003], [-94.75799771799996, 43.24854993400004], [-94.75809610499994, 43.24882402000003], [-94.75818392999997, 43.249058912000066], [-94.75828116899999, 43.24927584000005], [-94.75838322299995, 43.24948914000004], [-94.75848535299997, 43.249706013000036], [-94.75864799799996, 43.25001513900003], [-94.75877449199999, 43.25022817800004], [-94.75897171099996, 43.25055480100008], [-94.75918833699996, 43.25087406700004], [-94.75940431899994, 43.25116118100004], [-94.75966026399999, 43.251490742000044], [-94.76100831699995, 43.25313066600006], [-94.76127419899996, 43.25346726500004], [-94.76203627799998, 43.25440954700008], [-94.76272123699994, 43.255258076000075], [-94.76349571399999, 43.25617354500008], [-94.76439427299994, 43.25728976200003], [-94.76585632699994, 43.25908848600005], [-94.76693430499995, 43.260413234000055], [-94.76860938999994, 43.26248904000005], [-94.76954288099995, 43.263647889000026], [-94.76958450799998, 43.26369918100005], [-94.76959036099998, 43.26370627500006], [-94.76963282799994, 43.26375775400004], [-94.77033936899994, 43.26461425000008], [-94.77100622699999, 43.265428867000026], [-94.77222479399995, 43.26692355600005], [-94.77357401799998, 43.26858832700003], [-94.77455979899997, 43.26981708500006], [-94.77523910399998, 43.270631982000054], [-94.77606151099997, 43.27163425700007], [-94.77675879899994, 43.27249496100006], [-94.77760161299994, 43.273536310000054], [-94.77817860999994, 43.274251811000056], [-94.77871100199997, 43.27491512100005], [-94.77876536499997, 43.27498209100003], [-94.77882191499998, 43.27505128300004], [-94.77887699199994, 43.275118676000034], [-94.77972876599995, 43.27616086900008], [-94.78030128799998, 43.276874502000055], [-94.78105350299995, 43.27780438000008], [-94.78232239899995, 43.27934486000004], [-94.78317021299995, 43.280382538000026], [-94.78385222099996, 43.28120405900006], [-94.78438959099998, 43.281888751000054], [-94.78509127499996, 43.282749961000036]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 
| 0000000182 | S001930004N | 23.712892999999997556415110011585056781768798828125    | 24.0031359999999978072082740254700183868408203125   | 1451628000    | 1451606401           |                    | JRENFRO     | RAMS     | 1459776491         | 1463753965      | 1                   | NO ERROR |           | 6        | [null, 42.030235884000035, -94.37778874699995, null, false, {paths=[[[-94.37778874699995, 42.030235884000035], [-94.37783109799994, 42.03165152100007], [-94.37784771799994, 42.03219973200004], [-94.37785203899995, 42.03234228100007], [-94.37791420899998, 42.03321314300007], [-94.37791817499999, 42.03326868900007], [-94.37798150699996, 42.03399419500005], [-94.37798135999998, 42.034155799000075], [-94.37798110399996, 42.03443951600008]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | 
| 0000000283 | S001930005N | 78.2640310000000027912392397411167621612548828125      | 78.5662310000000019272192730568349361419677734375   | 1451628000    | 1451606401           |                    | JRENFRO     | RAMS     | 1459776491         | 1463753965      | 1                   | NO ERROR |           | 7        | [null, 41.43728810600004, -93.32997661999997, null, false, {paths=[[[-93.32997661999997, 41.43728810600004], [-93.33017334499999, 41.437372269000036], [-93.33064349299997, 41.43756155400007], [-93.33110760699998, 41.437723230000074], [-93.33148629299995, 41.43782958200006], [-93.33187106899999, 41.437945142000046], [-93.33225811299997, 41.43801982200006], [-93.33253979899996, 41.438084580000066], [-93.33283731699998, 41.438151746000074], [-93.33309686699994, 41.43820455600007], [-93.33335960899996, 41.43824783900004], [-93.33364454299999, 41.438281620000055], [-93.33398332299998, 41.43831309600006], [-93.33474638499996, 41.43837855000004], [-93.33553250699998, 41.43844765500006]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | 
| 0000000114 | S001930330N | 29.33388899999999921419657766819000244140625           | 34.4667239999999992505763657391071319580078125      | 1451628000    | 1451606401           |                    | JRENFRO     | RAMS     | 1459776491         | 1463753966      | 1                   | NO ERROR |           | 8        | [null, 41.955226234000065, -93.09761297899996, null, false, {paths=[[[-93.09761297899996, 41.955226234000065], [-93.09645218899999, 41.956034629000044], [-93.09484040899997, 41.957166621000056], [-93.09242035999995, 41.95886955900005], [-93.09015337499994, 41.96038282600006], [-93.08789060399994, 41.961919419000026], [-93.08574014999994, 41.96335294700003], [-93.08424944499995, 41.964368456000045], [-93.08193715299996, 41.96591476000003], [-93.07962461699998, 41.96748103500005], [-93.07802424999994, 41.96855764600008], [-93.07741981099997, 41.968964252000035], [-93.07509811299997, 41.97053040000003], [-93.07314257699994, 41.97183731000007], [-93.07293357899994, 41.97197698100007], [-93.07074182899999, 41.97346679200007], [-93.06825808599996, 41.97514563000004], [-93.06588657699996, 41.97673809500003], [-93.06380705299995, 41.978114763000065], [-93.06164184399995, 41.979584482000064], [-93.05973248199996, 41.98089833800003], [-93.05961481099996, 41.98097527500005], [-93.05923978399994, 41.98122047600003], [-93.05870924599998, 41.981567347000066], [-93.05757644499994, 41.98230796400003], [-93.05545112399994, 41.98378772900003], [-93.05362269799997, 41.98500171000006], [-93.05139825799995, 41.98656108500006], [-93.04937627999999, 41.98793104400005], [-93.04690953699998, 41.98957612500004], [-93.04454597499995, 41.99115817100005], [-93.04249225799998, 41.99254790100008], [-93.04115663199997, 41.993450316000065], [-93.04025869999998, 41.99405698100003], [-93.03849676699997, 41.99523472900006], [-93.03801616299995, 41.995555972000034], [-93.03639821399997, 41.996640410000055], [-93.03420491299994, 41.998109499000066], [-93.03184074499995, 41.99968794400007], [-93.02940487099994, 42.00126938500006], [-93.02713993099997, 42.00270468300005], [-93.02538681099998, 42.00387181600007], [-93.02454888999995, 42.00446204200006], [-93.02388942899995, 42.00492654900006], [-93.02365478799999, 42.005118991000074]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | 
| 0000000418 | S001930346E | 12.05039599999999921919879852794110774993896484375     | 12.3648290000000002919477992691099643707275390625   | 1451628000    | 1451606401           |                    | JRENFRO     | RAMS     | 1459776491         | 1463753966      | 1                   | NO ERROR |           | 9        | [null, 42.965311815000064, -92.32593299199999, null, false, {paths=[[[-92.32593299199999, 42.965311815000064], [-92.32526037699995, 42.96530946900003], [-92.32461796099994, 42.96531371400005], [-92.32432726099995, 42.965323081000065], [-92.32403698699994, 42.965337961000046], [-92.32374733199998, 42.96535834300005], [-92.32345849299998, 42.96538421400004], [-92.32264391799998, 42.96548677700008], [-92.32241029399995, 42.96552001900005], [-92.32217523599996, 42.96554727000006], [-92.32193902799997, 42.96556849900003], [-92.32170195899994, 42.96558367800003], [-92.32146431399997, 42.96559279100006], [-92.32100079399999, 42.96561364300004], [-92.31999341199997, 42.96561774400004], [-92.31975651699997, 42.96562056500005]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | 
| 0000000327 | S001920059N | 94.9957399999999978490450303070247173309326171875      | 99.8770710000000008221832104027271270751953125      | 1451628000    | 1451606401           |                    | JRENFRO     | RAMS     | 1459776491         | 1463753965      | 1                   | NO ERROR |           | 10       | [null, 41.92224116700004, -95.34421710099997, null, false, {paths=[[[-95.34421710099997, 41.92224116700004], [-95.34422572099999, 41.92355226900003], [-95.34421871199999, 41.925300752000055], [-95.34418680099998, 41.927181923000035], [-95.34414963099994, 41.92888083400004], [-95.34412583099999, 41.93037930700007], [-95.34410955499999, 41.932138664000036], [-95.34407681299996, 41.93399124300004], [-95.34405372999998, 41.93551473100007], [-95.34402477799995, 41.93653751700003], [-95.34400867299996, 41.93710650500003], [-95.34393561499996, 41.93872375600006], [-95.34384922599997, 41.94037697600004], [-95.34378244999999, 41.94221222300007], [-95.34372652599995, 41.94392573300007], [-95.34367059999994, 41.94563924100004], [-95.34362836899999, 41.94749554500004], [-95.34358772399997, 41.94924098600006], [-95.34355155899999, 41.95097562800004], [-95.34349392499996, 41.95279642400004], [-95.34344063799995, 41.95393782600007], [-95.34344175399997, 41.95408831300006], [-95.34344395199997, 41.954384696000034], [-95.34349570099994, 41.95468419700006], [-95.34356057499997, 41.95494058100007], [-95.34364336499999, 41.955153772000074], [-95.34369514599996, 41.955253334000076], [-95.34380564599996, 41.955465796000055], [-95.34401060699997, 41.95576283400004], [-95.34435668099997, 41.95613625800007], [-95.34456313299995, 41.95631885800003], [-95.34510103599996, 41.95669992200004], [-95.34584354499998, 41.95719925100008], [-95.34644432499994, 41.95760075100003], [-95.34673290299997, 41.95780705100003], [-95.34713532499995, 41.95814023100007], [-95.34756468799998, 41.95857666300003], [-95.34792774599998, 41.95903918800008], [-95.34827362399994, 41.95956992200007], [-95.34862209199997, 41.96018999800003], [-95.34891000499994, 41.96070378700006], [-95.34962726199996, 41.96198293500004], [-95.35053654599994, 41.96360579200007], [-95.35086434999994, 41.964172563000034], [-95.35126201899999, 41.96467027400007], [-95.35167547699996, 41.96508767700004], [-95.35170123599994, 41.96511368200004], [-95.35200661499994, 41.96540193300007], [-95.35358505799996, 41.96696748100004], [-95.35419556199997, 41.96755566400003], [-95.35426027899996, 41.96761801300005], [-95.35495019299998, 41.968279031000066], [-95.35540716399998, 41.96867208300006], [-95.35609762899998, 41.96918649300005], [-95.35630252799996, 41.96934710200003], [-95.35675458899999, 41.96970144100004], [-95.35767534699994, 41.97039088500003], [-95.35809303299999, 41.97073154900005], [-95.35845207899996, 41.97105109200004], [-95.35872347299994, 41.97132200000004], [-95.35914311399995, 41.971747820000076], [-95.35956442299994, 41.97223081800007], [-95.35984831799999, 41.97260163200008], [-95.36015896999999, 41.97306854500005], [-95.36049357299999, 41.973535070000025], [-95.36074197799996, 41.97383852400003], [-95.36131396299999, 41.97455862400005], [-95.36182385399997, 41.97511613200004], [-95.36193122699996, 41.975233529000036], [-95.36207117899994, 41.97538655000005], [-95.36280426199994, 41.976207713000065], [-95.36349758699998, 41.97697946100004], [-95.36431099999999, 41.977880146000075], [-95.36473549599998, 41.978350172000034], [-95.36501809099997, 41.97867451500008], [-95.36639403699996, 41.98017525100005], [-95.36660026699997, 41.980420708000054], [-95.36697488699997, 41.98086657700003], [-95.36719024199994, 41.98118485700007], [-95.36742257899994, 41.98159224500006], [-95.36763774699995, 41.98206784400003], [-95.36774930399997, 41.98244144300003], [-95.36782431799998, 41.982876419000036], [-95.36786195799999, 41.983344181000064], [-95.36789127599997, 41.984838215000025], [-95.36792063199994, 41.986661182000034], [-95.36793671199996, 41.98726618500007]]]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |