Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sfcgal]

SFCGAL is a C++ wrapper library around Computational Geometry Algorithms Library (CGAL) with the aim of supporting ISO 19107:2013 and OGC Simple Features Access 1.2 for 3D operations. SFCGAL provides standard compliant geometry types and operations, that can be accessed from its C or C++ APIs. PostGIS uses the C API, to expose some SFCGAL's functions in spatial databases

3
votes
1answer
77 views

Use ST_ApproximateMedialAxis with 3D geometries

It is written in docs that ST_ApproximateMedialAxis doesn't drop z-index or third coordinate, but in practice it does drop z-index and returns 2D geometry. I pass 3D geometry into ...
3
votes
0answers
51 views

ST_IsPlanar returns true even for invalid 3D polygons

We are trying to find a way to validate 3D polygons with arbitrary rotation. It seems like you should be able to do this with the function ST_IsPlanar, because it claims to "not drop the z index", but ...
2
votes
0answers
48 views

How can I use the SFCGAL version of ST_Union?

I'm trying to combine a bunch of geometry boundaries to get the linework of their borders, but I'm getting an error with the default, GEOS-based ST_Union: SELECT ST_Union(ST_Boundary(geom)) FROM ...
2
votes
0answers
158 views

PostGIS queries result in “Symbol not found: __ZN5boost6system15system_categoryEv”

I seem to have lost the ability to use basic postgis queries. Normal postgres queries are unaffected. Using Mac (High Sierra), using postgres 10.5 / postgis 2.4 (probably) The same error happens ...
1
vote
0answers
29 views

Select nearest 3D point with sfcgal

The Data Two sets of 1000 points A.geom and B.geom in PostGIS The Problem From Set A take the first point and find its nearest neighbour in Set B Calculate the 3D distance between these two points ...
4
votes
0answers
55 views

ST_3DIntersects says 'no' despite geometries intersecting

Considering the following query I expect both geomb and geomc to 3D Intersect with geoma. According to postgis, only geomc intersects. Unfortunately I can't come up with a more simplified polygon as ...
1
vote
1answer
20 views

How to Turn Off SFCGAL Geometry Validation?

SFCGAL documentation (https://oslandia.github.io/SFCGAL/documentation.html) states that all geometry processing algorithms by default check the validity of input geometries, but also come in a second ...
3
votes
0answers
49 views

Apollonius Graphs (Delaunay Graphs of Disks) in sfcgal or PostGIS?

I was wondering if there is support for Delaunay Graphs of Disks (a.k.a. Apollonius Graphs) in PostGIS/sfcgal? A CGAL function seems to exist for this. But I can't seem to find it in the PostGIS ...
1
vote
1answer
47 views

sfcgal ST_Volume Issue

ST_Volume works with shape data pasted into the query in this form: SELECT (abs(ST_Volume(design)) - abs(ST_Volume(ST_3DIntersection(design,scan)))) FROM (SELECT (ST_MakeSolid('...
1
vote
0answers
57 views

Invalid Polygons from ST_MakeSolid(ST_ConvexHull(…))

The aim: a TINZ has been derived from at least two lidar scans with the results stitched together into a single mesh. The original scans are unavailable, and the stitched mesh is rejected by sfcgal ...
3
votes
2answers
79 views

How to Fix Inconsistent Data Conversions in SFCGAL Expressions

I need to compound several sfcgal expressions to create the overall effect of: SELECT ST_Volume( ST_MakeValid( ST_MakeSolid( ST_3DDifference( ...
2
votes
1answer
151 views

Can sfcgal be Installed on Amazon Web Services

We're trying to set up a cloud-based repository using postgresql, postgis and sfcgal. While I have these installed and running on my laptop, it looks like AWS RDS does not support sfcgal. Is this so? ...
4
votes
2answers
431 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 ...
1
vote
0answers
95 views

Intersection between two 3D planar rectangles

I am doing research in roof reconstruction from different data sources. After previous steps I receive a (plane) 3D rectangle by roof-part, stored with a 2D polygon, a 3D centroid point and a normal ...
0
votes
1answer
441 views

ST_MakeSolid() creating an invalid solid from closed polyhedralsurfaceZ

I am trying to turn a polyhedralsurface object into solid using ST_MakeSolid() SFCGAL function in PostGIS. SELECT ST_Volume(ST_MakeSolid(ST_GeomFromEWKT('SRID=4326;PolyhedralSurface( ((-1....
0
votes
2answers
328 views

lwgeom_to_geojson: 'PolyhedralSurface' geometry type not supported

I am using PostGIS (PostGIS 2.2.0 with SFCGAL extension) and I have data in postgres which is loaded using citygml2psql tool and it contains polyhedralSurface geometry. But when i run query : ...
2
votes
1answer
332 views

SFCGAL compilation: How to specify CGAL path?

I'm a Linux newbie but nevertheless I want to install SFCGAL on OSGeoLive Virtual Machine (this is Ubuntu 14.04.4. LTS trusty). So first of all I had to get the dependencies, e.g. CGAL. Unfortunately ...
2
votes
1answer
212 views

Can't upgrade to PostGIS 2.2

I am running on MAC OSX El Capitan. My version of postgres is 9.4.5.0. My PostGIS version is 2.1.7. I cannot upgrade to PostGIS 2.2, because when I am trying to do, it pops "PostGIS requires SFCGAL >= ...
3
votes
3answers
5k views

How to enable SFCGAL in PostGIS?

I have the problem with the enabling extension SFCGAL. CREATE EXTENSION postgis_sfcgal; doesn't work for me even I have the PostGIS v2.2. When I do that, it throws an error ERROR: could not ...
0
votes
1answer
234 views

Using ST_Extrude in PostgreSQL with PostGIS?

I'm trying to use the function ST_Extrude() in Postgres 9.2. I enabled the PostGIS 2.2.0 extension and the PostGIS_SFCGAL extension (which carries the ST_Extrude function). I can see the function in ...
0
votes
1answer
764 views

Install Postgresql / Postgis with SFCGAL

I need to access ST_StraightSkeleton() function. At the moment i have a Postgresql instalation PostgreSQL 9.3.4 compiled by Visual C++ build 1600, 64-bit installed via EDB with Postgis 2.1.7 on a ...
0
votes
1answer
258 views

Configuring SFCGAL to PostGIS Db in Windows

I have installed a PostgreSQL 9.3.5 64-bit on a Windows Server 2012 machine and added Postgis 2.1.3 extension. I need to use the ST_StraightSkeleton function and after some search on the web I found ...
4
votes
3answers
2k views

Configuring SFCGAL to PostGIS Db

I was using PostgreSQL with PostGIS and Pgrouting. Recently I needed to install SFCGAL for some extra functions for my PostGIS db. After installing SFCGAL, now I don't know how to update my PostGIS db ...
0
votes
1answer
155 views

Postgis make error on MacOS

I could compile it with the following command on Macbook mavericks. ./configure --with-sfcgal=/usr/local/Cellar/sfcgal/1.0.4/bin Then, I receive following results along with lists: PostGIS is now ...
0
votes
2answers
411 views

Building PostGIS with SFCGAL from source fails

I'm trying to build latest PostGIS (2.2dev) with SFCGAL. SFCGAL is installed in /usr/local/lib, and includes are in /usr/local/include/SFCGAL I've run configure as: ./configure --with-sfcgal=/usr/...