[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Corner coordinates from Geometry
From:       "Simon Greener" <simon () spatialdbadvisor ! com>
Date:       2009-11-25 1:23:14
Message-ID: op.u3xfg0yjzbn0g9 () spdba
[Download RAW message or body]

I see others have quickly answered your question now you have supplied the detail \
they needed. All the best.
Simon
On Wed, 25 Nov 2009 00:33:43 +1100, Robert Hicks <robhyx@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@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@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@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@postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > 
> 
> 
> 


-- 
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@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@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]