Thanks Simon, I did mean the coordinates of the MBR for each MULTIPOLYGON, but honestly I just need a place on the map to stick a push pin so I can show a user where the polygon is. Basically this is a bunch of parcel data that was a shapefile and now it is a table in Postgres. I have a client application that allows the user to sort by several attributes in the table and I need to be able to show the results of where the data actually is on a map.
On Mon, Nov 23, 2009 at 5:39 PM, Simon Greener <[email protected]> wrote: > Robert, > > What do you mean by "corner coordinates"? > > Do you mean the 4 corners of the MBR of each MULTIPOLYGON or do you mean > that each MULTIPOLYGON is some sort of a collection of rectangular polygons > and you want the corners of each of the rectangles? > > regards > SImon > On Tue, 24 Nov 2009 05:53:33 +1100, Robert Hicks <[email protected]> wrote: > >> Hi all, I have a table full of MULTIPOLYGON features and I am looking >> for a way to parse the geometry from a given row and get back the >> corner coordinates in decimal degrees. Is there a stored procedure for >> this? >> >> Thanks! >> > > > -- > SpatialDB Advice and Design, Solutions Architecture and Programming, > Oracle Database 10g Administrator Certified Associate; Oracle Database 10g > SQL Certified Professional > Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, > Radius Topology and Studio Specialist. > 39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia. > Website: www.spatialdbadvisor.com > Email: [email protected] > Voice: +61 362 396397 > Mobile: +61 418 396391 > Skype: sggreener > Longitude: 147.20515 (147° 12' 18" E) > Latitude: -43.01530 (43° 00' 55" S) > GeoHash: r22em9r98wg > NAC:W80CK 7SWP3 > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- web http://www.hyxspace.com aim hyx1138 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
