tudelft3d / prepair

Automatic repair of single polygons (according to the OGC Simple Features / ISO19107 rules) using a constrained triangulation.
GNU General Public License v3.0
114 stars 23 forks source link

create an extension for PostgreSQL #3

Open bartvde opened 10 years ago

bartvde commented 10 years ago

Thanks for your presentation at #osgeonl today.

I talked to my colleague Paul Ramsey about how to integrate this into PostGIS, and he came up with an alternative. See below:

Their code could be an extension that consumes WKB and outputs WKB Requires no dependency on postgis at compile time And just has a couple SQL functions that take in geometry, output wkb, hand to the internal functions, etc Basically, that's how I did the pgpointcloud postgis integration Pointcloud has no compile-time dependency on postgis And all the interaction is via wkb in bytea structures Makes it easy to write add-ons without the overhead of getting into the postgis build

hugoledoux commented 10 years ago

That's a very good idea Bart, cheers! I had not thought of that, but indeed that's a simple and elegant solution.

I'll look into it when I have time--if you want to help, be my guest.

bartvde commented 10 years ago

hey @hugoledoux I'm afraid my programming skills are mostly on the javascript side of the spectrum ;-) so I won't be able to help much here unfortunately.