Reputation
8,859
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 16 32
Newest
 Nice Answer
Impact
~335k people reached

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
Oct
21
comment How do I find points that are NOT within a list of polygons using MS SQL?
Interesting. I haven't done any testing about performance in MS Sql. But some years ago I found the "not in" method slower in PostGIS. I might try it with the same data set in PostGIS and MS sql if I find time.
Oct
21
comment How do I find points that are NOT within a list of polygons using MS SQL?
@mapBaker, I have added an example in my answer
Oct
21
revised How do I find points that are NOT within a list of polygons using MS SQL?
add an example
Oct
17
comment How do I find points that are NOT within a list of polygons using MS SQL?
@mapBaker, But in this case you will be joining on those actually intersecting, and then finding the ones that doesn't intersect any polygon at all because they don't get any polygon id in the join but instead just null. I will try it when I get to a SQL Server installation.
Oct
16
comment How do I find points that are NOT within a list of polygons using MS SQL?
@mapBaker Interesting. Is it only right join that has limitations like this in Sql Server? Or is it all outer joins? Do you have a link about it?
Oct
16
comment Identifying overlapping time intervals with two more criteria in R?
I am not sure I understand fully, but it seems like a task that is fairly straight forward in PostgreSQL. There is functions for time ranges. As I have understood it should be easy to share data between PostgreSQL and R.
Oct
16
answered Finding vertex in comon with most polygons in PostGIS?
Oct
14
answered How do I find points that are NOT within a list of polygons using MS SQL?
Oct
11
comment Difference between Envelope and BoundingBox
at least in PostGIS there as a box3d ...
Oct
6
awarded  Yearling
Sep
29
comment point returned from ST_LineLocatePoint returns false in ST_Contains
you are right that it is about rounding errors, but st_Closestpoint will not help. You get the same error problem. Actually there is many points along a line that cannot be described with a finite number of decimals. So use st_dwithin for exampke with a small tolerance instead of st_contains.