[postgis-users] Corner coordinates from Geometry

[Simon Greener]

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 <robhyx at gmail.com> 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: simon at spatialdbadvisor.com
   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