7,738 reputation
11327
bio website blog.jordogskog.no
location Hedmark, Norway
age
visits member for 4 years
seen 6 hours ago

Oct
18
revised Postgis: Point-in-polygon check + feature attributes inheritance
fix formatting that was messed up when writing from phone
Oct
18
revised Postgis: Point-in-polygon check + feature attributes inheritance
added 18 characters in body
Oct
18
answered Postgis: Point-in-polygon check + feature attributes inheritance
Oct
16
awarded  Nice Answer
Oct
14
comment ST spatial queries to select multi-level location
Your query will not work because the query compares all rows to all rows which means that when the point intersect 1 point it also disjoint at least most of the polygons in table 2. So you need to work with a subquery in some way. There are many options.
Oct
13
answered ST spatial queries to select multi-level location
Oct
6
awarded  Yearling
Sep
30
awarded  Explainer
Sep
28
comment Extract longitude latitude and radius from POSTGIS column
How different value? About radius you can use st_maxdistanse and divide by 2 but it will not give you an exact value either. That is because the buffer is just an appriximation of a circle built of a limited number of points.
Sep
22
comment PostGIS: Get closest point between geometry and Multipoint
No ST_ClosestPoint, ST_ShortestLine and ST_Distance all behave the same. For a collection they iterate all vertexpoints and test against both the vertex points and the line between the points. In some cases it takes a shortcut but the result is the same.
Sep
19
comment PostGIS: Get closest point between geometry and Multipoint
Collecting all geometries from table 2 is a way to compare a geometry in table 1 with all geomeries in table 2. Another way is ordering by distance and using distinct.
Sep
19
answered PostGIS: Get closest point between geometry and Multipoint
Sep
5
awarded  Nice Answer
Sep
2
answered Postgres Performance with Radius Searches
Aug
27
revised Is there a PostGIS function to get a tangent and normal line?
added 2 characters in body
Aug
27
answered Is there a PostGIS function to get a tangent and normal line?
Aug
11
awarded  Caucus
Aug
5
comment C# geometry hex decoder
Do you mean that you have no control over the actual query? That seems like making things hard. What you have is wkb as hex values. So you need to read wkb and make that readable for whatever you are going to feed it into.
Aug
4
answered postGIS: what is more efficient: single or two-point search
Jul
20
answered What is the internal format of PostGIS?