home / cryptids

Find cryptids with range encompassing a lat/lon

Custom SQL query

select
    id, name, description,
    wikipedia_url, additional_url,
    first_sighted, last_sighted
from
    cryptids
where
    within(GeomFromText('POINT(' || :longitude || ' ' || :latitude || ')'), cryptids.geom)
    and rowid in (
        SELECT pkid FROM idx_cryptids_geom
        where xmin < :longitude
        and xmax > :longitude
        and ymin < :latitude
        and ymax > :latitude
    )

Query parameters

Powered by Datasette · Query took 2.161ms