Reputation
5,301
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 16 35
Newest
 Enlightened
Impact
~76k people reached

33m
reviewed Approve antimeridian tag wiki
33m
reviewed Approve antimeridian tag wiki excerpt
33m
reviewed Close Is GRACE satellite data freely available?
33m
comment Is GRACE satellite data freely available?
I'm voting to close this question as off-topic because it would better suited to opendata.stackexchange.com
36m
reviewed Reopen Generate ESRI grid with xllcenter/yllcenter in header
36m
reviewed Close geometric network connected links problem
37m
reviewed Close Methodology for Image Classification (beginner)
37m
reviewed Close GIS selection of dummy variable
7h
comment PostGIS query to get a list of points
Use something like Fiona or Shapely and get an array or points directly?
9h
reviewed Approve Krovak projection EPSG 5514: Correct data transfer between R and ArcGIS?
9h
reviewed Close City density in GIS
9h
reviewed Close Point cloud LiDAR
9h
reviewed Close Mobile Data collection options
9h
reviewed Close How to Geocode use GeoPy API combined with GDAL Python bindings?
11h
comment how to obtain one polygon result of the space between many polygons?
A diagram might help.
11h
reviewed Close how to obtain one polygon result of the space between many polygons?
12h
comment How to update polylines coordinates in postgis after editing in Leaflet
Sorry, what is the question exactly?
12h
comment Postgis spatial join performance (point on area)
If you look at the explain, you will discover that there is a full table scan on the points table (by definition, as you are updating every row of it). You could possibly try what Vince suggests and reverse it, possibly using ST_Intersects intstead, as clearly a point can not contain a polygon, but, basically, yes, this is the most efficient you can make it without parallelizing.
19h
reviewed Close count if a row value is within a dynamic range?
20h
reviewed Approve panoply tag wiki excerpt