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.txt3,512 bytes2016-02-10 12:42
category_stat.tsv.gz6,030 bytes2025-02-10 04:45
gridimage_base.tsv.gz62,606 bytes2025-01-30 00:09
gridimage_extra.tsv.gz24,402 bytes2025-01-30 00:09
gridimage_geo.tsv.gz32,555 bytes2025-01-30 00:09
gridimage_text.tsv.gz107,250 bytes2025-01-30 00:09
user_stat.tsv.gz841 bytes2025-02-11 02:45
category_stat.mysql.gz6,962 bytes2025-02-10 04:45
gridimage_base.mysql.gz65,135 bytes2025-01-30 00:09
gridimage_extra.mysql.gz26,059 bytes2025-01-30 00:09
gridimage_funny.mysql.gz1,838 bytes2025-02-11 04:15
gridimage_geo.mysql.gz36,142 bytes2025-01-30 00:09
gridimage_search.mysql.gz287,356 bytes2025-01-30 00:09
gridimage_size.mysql.gz787 bytes2025-01-30 00:09
gridimage_text.mysql.gz109,879 bytes2025-01-30 00:09
gridprefix.mysql.gz864 bytes2025-01-30 00:09
gridsquare.mysql.gz8,806 bytes2025-02-10 04:45
hectad_complete.mysql.gz723 bytes2025-02-10 02:58
user_dev.mysql.gz1,771 bytes2025-02-11 02:59
user_stat.mysql.gz1,520 bytes2025-02-11 02:45
vision_results.mysql.gz254,067 bytes2025-01-30 00:11
photos000.tar.gz129,658,434 bytes2022-10-10 04:15
photos001.tar.gz77,688,024 bytes2023-09-29 04:15
photos002.tar.gz37,805,634 bytes2024-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.)