[postgis-users] Corner coordinates from Geometry

[Paul Ramsey]

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