1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
|
#@on-error omit
plugin_register functions/h3
#@on-error default
table_create Data TABLE_HASH_KEY ShortText
column_create Data location COLUMN_SCALAR WGS84GeoPoint
load --table Data
[
{"_key": "ClearCode: 35.80460x139.45649", "location": "35.80460x139.45649"},
{"_key": "Shin Tokorozawa: 35.80747x139.45602", "location": "35.80747x139.45602"},
{"_key": "Koku koen: 35.79841x139.46573", "location": "35.79841x139.46573"}
]
select Data --filter 'h3_in_grid_disk(location, "35.80460x139.45649", 10, 3)'
|