calands: draw_to_find

Custom SQL query (hide)

select
    AsGeoJSON(geometry), *
from
    CPAD_2020a_SuperUnits
where
    Intersects(GeomFromGeoJSON(:freedraw), geometry) = 1
    and CPAD_2020a_SuperUnits.rowid in (
        select
            rowid
        from
            SpatialIndex
        where
            f_table_name = 'CPAD_2020a_SuperUnits'
            and search_frame = GeomFromGeoJSON(:freedraw)
    )
limit 10

Query parameters

freedraw