All Questions
4 questions
1
vote
1
answer
265
views
3D centroid in PostGIS
How could I find the 3D centroid of this feature in PostGIS:
SELECT
ST_AsText(
ST_GeomFromText('POLYGON Z ((0 0 0, 1 0 0, 1 0 1, 1 1 1, 0 1 1, 0 0 1, 0 0 0 ))')
) geom;
...
- 10.9k
4
votes
1
answer
277
views
Why is this polygon not planar for PostGIS
Why is the following Polygon Z not planar for PostGIS 3.4.0dev (3.3.0rc2-335-gae95dd219)?
SELECT ST_IsPlanar(
ST_GeomFromText(
'POLYGON Z ((
3021241.9043000005 2037823.3759000003 262....
- 10.9k
3
votes
1
answer
315
views
PostGIS sfcgal ST_3DArea
I want to compute surface areas of a large CityGML data set. However, I ran into some issues, which I could not resolve or fully understand.
The error message is the following:
Polygon is invalid : ...
- 30.9k
3
votes
2
answers
904
views
Postgis exact geometry from text
I have some geometry in cgal that I would like to export to postgis. The kernel I'm using is the same as what sfcgal uses (exact predicate exact construction), but I'm encountering some errors in ...
- 13.2k