[postgis-users] Troubleshooting topology exception errors in large datasets

ASTER The geometries that fail are probably very tiny slivers if that helps with a diagnosis. Thanks, THX1138 Example table structure: CREATE TABLE features( feature_id serial primary key, feature_geom geometr

[postgis-users] ST_UNION function severely broken in Postgis 2.0.1

Hello, I am trying to perform a function similar to ArcGIS erase in postgis where the geometry of all polygons from one table are erased from all of the polygons in another. I have used to the following query to dump all multipart geometries to single part geometries and repaired any issues. I th

Re: [postgis-users] Severe shapefile upload issues

ntation as, while it makes sense once you get used to it, someone new to schemas, such as myself, assumes their postgis install itself is corrupt. Thanks for helping me solve this issue! THX1138 -- View this message in context: http://postgis.17.n6.nabble.com/Severe-shapefile-upload-issues-tp

Re: [postgis-users] Severe shapefile upload issues

th I get back: "{"search_path=public, postgis"}" When I reset the role it simply deletes the entry again and processes begin to fail. Is there a way to permanently set the database search path without changing the user's search path? Thanks, THX1138 -- View this mes

Re: [postgis-users] Severe shapefile upload issues

My postgis full version is as follows: "POSTGIS="2.0.0 r9605" GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.0, released 2011/12/29" LIBXML="2.7.8" LIBJSON="UNKNOWN" RASTER" My install (on Ubuntu-64 bit) could not be dirty because I created a new virtual machine and built

[postgis-users] Severe shapefile upload issues

does this already (in a fast efficient manner)please let me know! Otherwise, I will just write one in python. As a side note, I noticed that the gui shapefile uploader no longer has the srid convert option, so I am wondering if this feature has been deprecated since it does not work and the documenta

[postgis-users] How to set the parent schema of postgis 2.0 to "postgis" instead of "public"

ns. Another problem might be that I have legacy functions installed in the public schema and that they somehow conflict with postgis 2.0 being installed in the postgis schema. If this is the case, is it possible to import those functions into the postgis schema as well (or their own schema)? Than

Re: [postgis-users] Installing a fully functional PostGIS 2.0 on

I finally figured it out, I just did: sudo ldconfig su - root echo '/home/zonability3/gis/FileGDB_API/lib' >> /etc/ld.so.conf sudo ldconfig gdal, with file geodatabase support now functions correctly as far as I can tell. I am confused as to how to correctly build postgis 2.0 with extensions fo

Re: [postgis-users] Installing a fully functional PostGIS 2.0 on

Can you post an example of what you mean? I didn't quite understand that. -- View this message in context: http://postgis.17.n6.nabble.com/Installing-a-fully-functional-PostGIS-2-0-on-Ubuntu-Linux-GEOS-GDAL-issues-tp3566227p4373173.html Sent from the PostGIS - User mailing list archive at Nabble.

Re: [postgis-users] Installing a fully functional PostGIS 2.0 on

I get exactly the same error, and it did find some files on the first try. zoa3@ZB3:~/gis/gdal$ locate libFileGDBAPI.so zoa3@ZB3:~/gis/gdal$ sudo locate libFileGDBAPI.so zoa3@ZB3:~/gis/gdal$ /sbin/ldconfig -p | grep gdal libgdal.so.1 (libc6,x86-64) => /usr/local/lib/libgdal.so.1 l

Re: [postgis-users] Installing a fully functional PostGIS 2.0 on

Nearly two months later I still have not yet figured out how to get everything working. I have managed to install postgis 2.0 and get it working but without topology and raster support which is most of the new functionality. GDAL simply will not cease to produce errors about being unable to locate

Re: [postgis-users] Installing a fully functional PostGIS 2.0 on

Thank you for this excellent guide, this is exactly what I needed! I have a few questions though: First of all I am wondering why you chose 9.0 over 9.1.2? Are there issues with using a postgres version above 9.0? Secondly, when you refer to the "missing development headers" for postgres 9.0, a

Re: [postgis-users] Installing a fully functional PostGIS 2.0 on

So I add these bindings after configuring/building/installing gdal but they must be installed before configuring/building/installing postgis? Martin Spott wrote: > > THX1138 wrote: > > Very few, but if you're building GDAL with Python bindings, you'll get >

Re: [postgis-users] Installing a fully functional PostGIS 2.0 on Ubuntu Linux GEOS/GDAL issues

I do: ./configure --prefix=/opt/gdal make sudo make install and expect postgis to be able to deal with it without any errors? Sandro Santilli wrote: > > On Sun, Dec 25, 2011 at 10:53:14AM -0800, THX1138 wrote: > > No mess here building GDAL, btw. It's even helpful as there&#x

Re: [postgis-users] Installing a fully functional PostGIS 2.0 on Ubuntu Linux GEOS/GDAL issues

Santilli wrote: > > On Sat, Dec 24, 2011 at 09:12:28PM -0800, THX1138 wrote: > >> -- Dependencies -- >> GEOS config: /usr/local/bin/geos-config >> GEOS version: 3.3.1 > ... >> -L/usr/lib >> -lgdal1.8.0 -L/

[postgis-users] Installing a fully functional PostGIS 2.0 on Ubuntu Linux GEOS/GDAL issues

I am new to linux, postgresql and postgis. I have been working on getting postgis 2.0 up and running on an ubuntu-maverick-amd64 linux server for about a week now. I am going for raster and topology support. I used the following to configure: sudo ./configure --with-raster --with-topology --with