meta user
network profile
| bio | website | |
|---|---|---|
| location | Estonia | |
| age | 24 | |
| visits | member for | 4 months |
| seen | Mar 8 at 10:52 | |
| stats | profile views | 4 |
|
Feb 8 |
accepted | PostGIS algorithm to unite points of two geometries that are within specified radius |
|
Feb 8 |
comment |
PostGIS algorithm to unite points of two geometries that are within specified radius I will still accept Your answer as being best, because it is closest to my original intent that I have found. |
|
Feb 8 |
comment |
PostGIS algorithm to unite points of two geometries that are within specified radius Very interesting. However, ST_ConcaveHull will connect the two geometries even if they are farer from each other, than tolerance apart. Of course, I could first check the distance of two geometries and then connect them if they are less than tolerance apart. Needs thinking. Other problem, ST_ConcaveHull may insert discrepancies on the sides that are not being connected. See my first post - blue geometry gets some extra "area". But I guess if target_precent is sufficiently low, it should do the trick. But then I need to know the target_precent in advance for my application :) |
|
Feb 5 |
revised |
PostGIS algorithm to unite points of two geometries that are within specified radius New variant using mitre-limit |
|
Feb 5 |
revised |
PostGIS algorithm to unite points of two geometries that are within specified radius Added more test cases. |
|
Feb 5 |
revised |
PostGIS algorithm to unite points of two geometries that are within specified radius Tested some more. |
|
Feb 5 |
comment |
Merge polygons in postgis You're welcome :) |
|
Feb 5 |
answered | Merge polygons in postgis |
|
Feb 5 |
comment |
Merge polygons in postgis Then You need help with forming the SQL of finding union of two geometries, provided You know the IDs of both geometries? |
|
Feb 5 |
answered | Merge polygons in postgis |
|
Feb 5 |
awarded | Teacher |
|
Feb 5 |
answered | PostGIS algorithm to unite points of two geometries that are within specified radius |
|
Feb 5 |
awarded | Editor |
|
Feb 5 |
revised |
Geometry valid in PostGIS turns out to be not valid in Oracle Added parameters to function |
|
Feb 1 |
asked | PostGIS algorithm to unite points of two geometries that are within specified radius |
|
Feb 1 |
awarded | Benefactor |
|
Feb 1 |
awarded | Scholar |
|
Feb 1 |
accepted | Geometry valid in PostGIS turns out to be not valid in Oracle |
|
Jan 30 |
comment |
Geometry valid in PostGIS turns out to be not valid in Oracle OK, I will try this approach too. I will wait until tomorrow to see if someone else comments; if not, I will accept Your answer and follow up later whether these ideas worked. Thank You for Your time! |
|
Jan 28 |
comment |
Geometry valid in PostGIS turns out to be not valid in Oracle You said "Try 32 SDO_UTIL Package". I asked for an algorithm that I could use in PostgreSQL. How could I run Oracle package in PostgreSQL? I know that it is possible to run C code in PostgreSQL, but how to run this package? What processing do You mean in "processing in postgresql database"? What would exporting as shapefile change, compared to exporting as GML? Error would still occur only after importing to Oracle. |
