[postgis-users] Dimension of PolyhedralSurface

Hi, I notice the add of the Polyhedral Surface to GML. It is very interesting. But I have a little question: see-ing the code I notice the srsDimension of posList is =2. I will think the correct value was 3. Certainly the value of coordinate used are of a 2D dimension. But I don't understand why

Re: [postgis-users] Dimension of PolyhedralSurface

On Aug 11, 2010, at 9:02 AM, Andrea Peri wrote: Hi Andrea, I notice the add of the Polyhedral Surface to GML. It is very interesting. Yeap that's sound promising :) But I have a little question: see-ing the code I notice the srsDimension of posList is =2. I will think the correct value

Re: [postgis-users] pgsql2shp error

Thanks for the replies, the most promising command so far is: pgsql2shp -f [path] -h [myhost] -p [port] -u [user] -P [password] [database] SELECT * FROM table1 WHERE 'ID' '20' Which has the output: Preparing table for user query... Done. Initializing... WARNING: Cannot determine spatial

Re: [postgis-users] pgsql2shp error

Did you verify that the data in the shapefile is correct when you run the command with just the table name? Hang on a second... WHERE 'ID' '20' is never true. That's why you're getting an empty table. 'ID' is a string, as is '20'. I think you mean to say where your ID column value is less

[postgis-users] st_transform, irreversible?

Hello Postgis Users! This is my first post on this list so I will start by asking a simple (and probably stupid) question. :) While using ST_AsKml() to produce an overlay for Google Earth I noticed that all my geometries where shifted slightly south-east. I figured this had something to do with

Re: [postgis-users] st_transform, irreversible?

Seems to be an underlying problem with proj4: echo 59 21 | proj +init=epsg:3021 | invproj +init=epsg:3021 58d49'47.733E 21d2'54.745N And that's without doing the datum shift part. P On Wed, Aug 11, 2010 at 1:10 PM, Erik Rehn e...@slagkryssaren.com wrote: Hello Postgis Users! This is my

Re: [postgis-users] st_transform, irreversible?

Removing the EPSG lookup from the equation changes nothing: echo 59 21 | proj +proj=tmerc +lat_0=0 +lon_0=15.808278 +k=1 +x_0=150 +y_0=0 +ellps=bessel +units=m +no_defs | invproj +proj=tmerc +lat_0=0 +lon_0=15.808278 +k=1 +x_0=150 +y_0=0 +ellps=bessel +units=m +no_defs

[postgis-users] making polygons from center + vertex

I found this really neat Google Maps example where you can draw polygons using 2 points: the center and one vertex. See http://www.barnabu.co.uk/geapi/polyplot/ Is there a POST GIS function to create the corresponding polygon? regards, -- Arnaud Sahuguet

Re: [postgis-users] making polygons from center + vertex

Sure is, check out the ST_Buffer function http://postgis.refractions.net/docs/ST_Buffer.html ST_Buffer(geometry g1, float radius_of_buffer); If you give it a point as g1, and the radius of the circle it will calculate a pseduo-circular polygon for you. If you have two points g1 and g2 you

Re: [postgis-users] making polygons from center + vertex

thanks. Arnaud On Wed, Aug 11, 2010 at 10:04 PM, Francis Markham fmark...@gmail.comwrote: Sure is, check out the ST_Buffer function http://postgis.refractions.net/docs/ST_Buffer.html ST_Buffer(geometry g1, float radius_of_buffer); If you give it a point as g1, and the radius of the