search

mroswell / datasette-resources

0 stars 0 forks source link

Markers don't display #14

Open mroswell opened 10 months ago

mroswell commented 10 months ago

Bypass the issue with the following, when datasette-cluster-map is installed:

SELECT *,
    JSON_EXTRACT(geometry, '$.coordinates[1]') AS latitude,
    JSON_EXTRACT(geometry, '$.coordinates[0]') AS longitude 
FROM vacant_bldg_rehabs;

See also: https://github.com/eyeseast/datasette-geojson-map/issues/26