Reputation
9,034
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 17 34
Newest
 postgresql
Impact
~356k people reached

50m
answered Postgis spatial join performance (point on area)
1d
revised Optimizing PostGIS k-nearest neighbour function for large amount of polygons?
added 43 characters in body
1d
answered Optimizing PostGIS k-nearest neighbour function for large amount of polygons?
2d
comment Can I set up a PostGIS store/connection in GeoServer without user password for database?
Yes I guess you are right. I guess GeoServer is using jdbc which, according to this answer seems to not support local connection via unix socket: stackoverflow.com/questions/4562471/…
2d
answered Can I set up a PostGIS store/connection in GeoServer without user password for database?
Apr
27
awarded  postgresql
Apr
26
comment St_ClosestPoint within St_MakeLine Query problem
The syntax geom(geometry,4326) doesn't set the srid.what it does is like adding a constraint on srid 4326 on the geometry. To set the srid use st_setsrid, to change srid use st_transform
Apr
26
answered St_ClosestPoint within St_MakeLine Query problem
Apr
23
comment Leveraging capabilities of PostGIS for large (ish) tables in PostgreSQL?
I think this is the right place, but not in this shape. The question should actually seems to be more of a beginners question about how to make PostGIS work as expected. Not a comparission about different software. So, relevant questons to @haff is:you don't mention indeximg the polygons, why? What is your query? What is the result of explain query?
Apr
17
awarded  Enlightened
Apr
17
awarded  Nice Answer
Jan
30
comment Feature selection of one vector layer based on another vector layer: Any advice for using PostGIS or Python with PostGIS together?
For point 2 you can also use ST_ClosestPoint
Jan
30
comment Feature selection of one vector layer based on another vector layer: Any advice for using PostGIS or Python with PostGIS together?
Why not just use the closest road? That is what you want, isn't it?
Jan
29
comment Feature selection of one vector layer based on another vector layer: Any advice for using PostGIS or Python with PostGIS together?
In PostGIS you should think in terms of ST_DWithin (measuring distances) instead of intersecting buffers. And as said before. 50000 points is a small dataset. That is good news, isn't it :-)
Jan
29
comment Feature selection of one vector layer based on another vector layer: Any advice for using PostGIS or Python with PostGIS together?
I don't understand what you mean by "otherwise the system searches within 50 m buffer".
Jan
7
answered Simplify/generalize Polygons and keep topology of different layers PostGIS/QGIS
Dec
24
answered Use Postgis to convert wkb_geometry data type to geom datatype
Dec
22
awarded  Nice Answer
Dec
2
awarded  Nice Answer
Nov
9
awarded  Nice Answer