How retreive locations (lat,lon) from a rectangle area?

[SpongeB0B (SpongeBOB)]

Hi everyone,

I have some locations(lat, lon) (decimal degree) that are DB stored.

I would like to retrieve those that intersect a rectangle Result based on map view. · Leaflet/Leaflet · Discussion #9040 · GitHub

What would be a nice Pytonic way to do so ?

Thanks

[Rosuav (Chris Angelico)]

@SpongeB0B

I have some locations(lat, lon) (decimal degree) that are DB stored.

What DB? If it’s PostgreSQL, you can probably retrieve the ones you want using an SQL query.

[SpongeB0B (SpongeBOB)]

Thanks @Rosuav

Yes it’s one that SQL compatible ( SQLite )

Indeed I could query with a between function.

but is there a faster way to do so ?