Geograph Channel Islands Data Dumps

Creative
Commons Licence [Some Rights Reserved]

All datasets on this page © Copyright Geograph Project Limited
and licensed for reuse under this Creative Commons Licence.

You are free:
to Share _{- to copy, distribute and transmit the work}
to Remix _{- to adapt the work}
under the following conditions:
Attribution _{- You must attribute the work in
the manner specified by the author or licensor}
Share Alike _{- If you alter, transform, or build upon this
work, you may distribute the resulting work only under the same or similar license to this one.}

samples.txt	3,512 bytes	2016-02-10 12:42
category_stat.tsv.gz	6,030 bytes	2024-07-27 03:45
gridimage_base.tsv.gz	62,606 bytes	2024-07-04 15:01
gridimage_extra.tsv.gz	24,402 bytes	2024-07-04 15:01
gridimage_geo.tsv.gz	32,555 bytes	2024-07-04 15:01
gridimage_text.tsv.gz	107,250 bytes	2024-07-04 15:01
user_stat.tsv.gz	841 bytes	2024-07-27 03:45
category_stat.mysql.gz	6,899 bytes	2024-07-27 03:45
gridimage_base.mysql.gz	65,084 bytes	2024-07-04 15:01
gridimage_extra.mysql.gz	25,996 bytes	2024-07-04 15:01
gridimage_funny.mysql.gz	1,788 bytes	2024-07-27 04:15
gridimage_geo.mysql.gz	36,076 bytes	2024-07-04 15:01
gridimage_search.mysql.gz	287,284 bytes	2024-07-04 15:01
gridimage_size.mysql.gz	20 bytes	2023-02-18 04:15
gridimage_text.mysql.gz	109,831 bytes	2024-07-04 15:01
gridprefix.mysql.gz	20 bytes	2023-02-18 04:15
gridsquare.mysql.gz	7,579 bytes	2024-07-27 03:45
hectad_complete.mysql.gz	680 bytes	2024-07-26 22:24
user_dev.mysql.gz	1,711 bytes	2024-07-26 18:31
user_stat.mysql.gz	1,469 bytes	2024-07-27 03:45
vision_results.mysql.gz	20 bytes	2023-02-18 04:15
photos000.tar.gz	129,658,434 bytes	2022-10-10 04:15
photos001.tar.gz	77,688,024 bytes	2023-09-29 04:15
photos002.tar.gz	37,805,634 bytes	2024-07-07 04:15

These dumps are modelled after the ones available for Geograph Britain and Ireland,
see http://data.geograph.org.uk/dumps/ for how to use the dump files.

(If unsure which file to use, first try the gridimage_search table. That contains the potentially the most common data all in one table, a few columns are missing, but for many uses it might be enough. Technically is a materialized view, used thoughout the code as a easy way to get data about images.)