421 reputation
1613
bio website
location
age
visits member for 3 years, 2 months
seen 3 hours ago

Jun
4
awarded  Yearling
May
21
comment Running spatial query on huge table
You're a lifesaver. The planner indeed thought it was unnecessary. The query now works rather quickly. Still not lightning fast, but hej ~9.9 milion rows; what would you expect :)
May
21
accepted Running spatial query on huge table
May
8
comment Running spatial query on huge table
The number of vertices of the big polygon averages around 10k (4k~18k)
May
8
comment Running spatial query on huge table
Using the &&-operator instead of the ST_within the number differ from 300k to 1.5m. Query takes as low as 10seconds to run. So it might be better to first create a subset of the big table and to use that with the ST_within function? The big polygon indeed has much vertices.
May
8
comment Running spatial query on huge table
I don't know the number of rows wihtin the region. That's the reason why I want to run this query :). Probably it's around 750.000. Does it matter that there is a ST_transform on one of the spatially indexed columns?
May
8
comment Running spatial query on huge table
I do have a spatial index on geovlak; but I don't have one on the bigger polygon. Is the latter one needed?
May
8
revised Running spatial query on huge table
added 110 characters in body
May
8
asked Running spatial query on huge table
Jan
23
awarded  Notable Question
Jan
17
comment Leaflet HTTP.Get bad request; not loading tiles
Actually it's not a wonder ;) See me updated answer.
Jan
17
answered Leaflet HTTP.Get bad request; not loading tiles
Nov
6
accepted Spatial query to make view
Nov
5
comment Spatial query to make view
It works! If you make an answer I'll accept it!
Nov
5
comment Spatial query to make view
Maybe I'm now trying the query's :)
Nov
5
comment Spatial query to make view
There is no need to be able to update the table's. It's just a view. So the query you give should also be possible. There is indeed no common field between the two tables, except for the spatial 'common' field.
Nov
5
asked Spatial query to make view
Aug
22
revised Display a link in a popup with Leaflet
removed *leaflet* from header, replaced it
Aug
22
suggested approved edit on Display a link in a popup with Leaflet
Jul
30
awarded  Notable Question