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,013 bytes2024-03-28 03:45
gridimage_base.tsv.gz62,538 bytes2024-02-20 08:11
gridimage_extra.tsv.gz24,345 bytes2024-02-20 08:11
gridimage_geo.tsv.gz32,526 bytes2024-02-20 08:11
gridimage_text.tsv.gz106,959 bytes2024-02-20 08:11
user_stat.tsv.gz837 bytes2024-03-28 03:45
category_stat.mysql.gz6,911 bytes2024-03-28 03:45
gridimage_base.mysql.gz65,014 bytes2024-02-20 08:11
gridimage_extra.mysql.gz25,936 bytes2024-02-20 08:11
gridimage_funny.mysql.gz1,788 bytes2024-03-28 04:15
gridimage_geo.mysql.gz36,048 bytes2024-02-20 08:11
gridimage_search.mysql.gz287,042 bytes2024-02-20 08:11
gridimage_size.mysql.gz20 bytes2023-02-18 04:15
gridimage_text.mysql.gz109,527 bytes2024-02-20 08:11
gridprefix.mysql.gz20 bytes2023-02-18 04:15
gridsquare.mysql.gz7,443 bytes2024-03-28 03:45
hectad_complete.mysql.gz680 bytes2024-03-27 12:24
user_dev.mysql.gz1,711 bytes2024-03-08 10:21
user_stat.mysql.gz1,465 bytes2024-03-28 03:45
vision_results.mysql.gz20 bytes2023-02-18 04:15
photos000.tar.gz129,658,434 bytes2022-10-10 04:15
photos001.tar.gz77,688,024 bytes2023-09-29 04:15
photos002.tar.gz37,463,628 bytes2023-10-30 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.)