[postgis-users] How to select the highest y-value within all stored objects

Hi, I have a table storing polygon objects and I'm looking for a way to get the highest y-coordinate within all these objects. I know which polygon contains this value but I'm wondering whether there is a way to build a query which delivers only coordinates and not the polygon itself.

[postgis-users] Why no support for polyhedral surfaces?

Hi, I'm wondering why there is no support for polyhedral surfaces in postgis as for me it seems that this datatpye belongs to the simple features specification. Cheers, Simon ___ postgis-users mailing list postgis-users@postgis.refractions.net

Re: [postgis-users] Making one out of several connected polygons?

/2008, Simon Schneider [EMAIL PROTECTED] wrote: Hi, I've several polygons wich are all connected by at least one line and I'm looking for a way to make one big polygon which contains all the others. In other words the shape of the polygoncluster. I've been locking around for quite a while but I

Re: [postgis-users] Making one out of several connected polygons?

) HTH Nicolas On 01/02/2008, Simon Schneider [EMAIL PROTECTED] wrote: Hi, I've several polygons wich are all connected by at least one line and I'm looking for a way to make one big polygon which contains all the others. In other words the shape of the polygoncluster. I've been locking around

[postgis-users] 3D data became 2d auf insertion?

Hi, I have the following table... _ create table objects ( name varchar(15) not null primary key, parent varchar(15), type varchar(15) not null ); select addgeometrycolumn('objects','geom',-1,'POLYGON',3); _

Re: [postgis-users] 3D data became 2d auf insertion?

Thx, your tip worked. My original query was select Astext(geom3d) from objects. With select AsEWKT(geom3d) from objects everythin worked fine. Bye, Simon ___ postgis-users mailing list postgis-users@postgis.refractions.net

[postgis-users] How do multipolygons work?

Hi, I've a table with a multigeometry geometry column with only one object inserted: insert into test(name, geom) values('Main', GeomFromEWKT('MULTIPOLYGON(((0 0 0, 40 0 0, 40 50 0, 0 50 0, 0 0 0),(40 0 0, 50 0 0, 50 50 0, 40 50 0, 40 0 0)))')); And now I wanted to check whether a

Re: [postgis-users] How do multipolygons work?

is nondeterministic. Since the input is still invalid, you may not get this same result in future releases. Hope this clarify things, Cheers, Kevin Simon Schneider wrote: Hi, I've a table with a multigeometry geometry column with only one object inserted: insert into test(name

[postgis-users] row number error on distance operation

I found out that an error in PostGIS caused the problem. Cause as I switched to version 1.3.1 everything works fine now. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

[postgis-users] row number error on distance operation

Hi, I'd like to check whether a certain point lies within a polygon but I always get the error row number -1 is out of range 0..-1. My query: SELECT objects.name FROM objects WHERE distance(GeomFromText('POINT(500 500)',-1), objects.geom3d)=0; thx in advance, Simon