GC73TD0 SQL-imination (Unknown Cache) in Southern England, United Kingdom created by Oxford Stone

This cache has been archived.

Oxford Stone: Time to go

GC73TD0 ▼

A cache by Oxford Stone Message this owner

Hidden : 4/11/2017

Difficulty:

Terrain:

Size: Size: small (small)

Join now to view geocache location details. It's free!

Watch

How Geocaching Works

Related Web Page

Please note Use of geocaching.com services is subject to the terms and conditions in our disclaimer.

Geocache Description:

Follow the logic of the SQL query applied to the data in the file to be found on the Related Web Page link, and you should be left with the correct coordinates.

SELECT [LAT]
where VESSEL TYPE != 'General Cargo'
and VESSEL TYPE not like '%passenger%'
and LENGTH >140
and WIDTH <30
and DRAUGHT >6
and COURSE <180
and HEADING >160
and TIMESTAMP between '2016-08-11 00:00' and '2016-08-16 23:59'
and SPEED <15

SELECT [LON]
WHERE VESSEL TYPE NOT LIKE ‘%cargo%'
and LENGTH <130
and WIDTH <15
and DRAUGHT <6
and COURSE <180
and HEADING >100
and TIMESTAMP between '2016-08-11 00:00' and '2016-08-16 23:59'
and SPEED >4.9

You can check your answers for this puzzle on GeoChecker.com.

Additional Hints (Decrypt)

Crrc oruvaq gur cvcr. Npprff sebz rnfg fvqr.

Decryption Key

A|B|C|D|E|F|G|H|I|J|K|L|M
-------------------------
N|O|P|Q|R|S|T|U|V|W|X|Y|Z

(letter above equals below, and vice versa)

This cache has been archived.

Watch

Geocache Description:

Attributes

Inventory

Bookmark Lists

SQL-imination Mystery Cache

This cache has been archived.

Watch

Geocache Description:

Attributes

Inventory

Bookmark Lists

Treasures