日本国内のジオタグが付いたCommons上の新規ファイル

This query is marked as a draft This query has been published by 軽快.

SQL

use commonswiki_p;
select *
from geo_tags/*
where
((gt_lat between 139.131 and 146.030) and (gt_lon between 20.879 and 45.737)) or
((gt_lat between 131.199 and 139.131) and (gt_lon between 18.229 and 38.668)) or
((gt_lat between 129.023 and 131.199) and (gt_lon between 21.657 and 34.913)) or
 ((gt_lat between 122.739 and 129.023) and (gt_lon between 21.821 and 33.073))*/
where (CONVERT(gt_lat USING decimal) = 44.3409996 and CONVERT(gt_lon USING decimal) = 8.55650043)
limit 1

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...