Re: [postgis-users] ST_Unioning invalid multipolygons

David Jantzen a écrit : Hi again, I'm trying to ST_Union multipolygons from the Zillow neighborhood data. When I do this I occasionally see: NOTICE: TopologyException: found non-noded intersection between -73.812 This appears to be due to invalid geometries, as the following query returns

[postgis-users] ST_Unioning invalid multipolygons

Hi again, I'm trying to ST_Union multipolygons from the Zillow neighborhood data. When I do this I occasionally see: NOTICE: TopologyException: found non-noded intersection between -73.812 This appears to be due to invalid geometries, as the following query returns over a hundred rows: sel

[postgis-users] pl/python query variables

Hello, I'm using pl/python with postgis 1.3.3. I'm using plpy.prepare to query my db and I'd like to be able to use values in my db tables to determine which table to query. I'd like to do something like this: plpy.prepare("select a.info from $1 a where a.value=$2", ["text", "integer"]) I've b

Re: [postgis-users] AddGeometryColumn error

Thank you very much for all. Now everything is OK. I load PostGIS functions with 'lwpostgis.sql' into my DB, and all it's OK. Now, I have created a geometric column and using geometryfromtext I have introduced all the POINTS. Thanks again... Javier Estévez > ¡Hola Javier! > > Maybe you did not