Use ST_Centroid() then. It's just the mid-point of the bbox, so it's fast to calculate.
P On Tue, Nov 24, 2009 at 5:33 AM, Robert Hicks <[email protected]> wrote: > 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 > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
