[postgis-users] Corner coordinates from Geometry

[Robert Hicks]

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
<simon at spatialdbadvisor.com> 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 <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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
web http://www.hyxspace.com
aim hyx1138