[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Getting the bounding box of a feature
From: Stephen Woodbridge <woodbri () swoodbridge ! com>
Date: 2005-03-30 21:44:55
Message-ID: 424B1DD7.1030704 () swoodbridge ! com
[Download RAW message or body]
Kurt,
Change you query to:
$extent_sql = "SELECT AsText(EXTENT(public.nmranch04.the_geom)) FROM
public.nmranch04 WHERE (public.nmranch04.ranch_name = ".$ranch.")";
An then you will have to parse the text.
-Steve W.
Menke, Kurt wrote:
> Hello,
>
> I’m developing a client in using PHP 4.3.4, Mapserver 4.4.1, and PostGIS
> 1.0.0 (PostgreSQL 7.4.1).
>
>
>
> I need to programmatically access the bounding box of a selected polygon
> in a PostGIS feature class so that I can use Mapscript to zoom to it.
> I’ve tested the SQL below in PostgreSQL and it returns: BOX3D(560748.25
> 3881950 0,568816.25 3890818.75 0). However, when I try to dump the
> results into a PHP variable I can’t seem to access the results. When I
> try to echo the results out to the page I get “Resource ID #68.
>
>
>
> I’m not familiar with the BOX3D format. Is there any info on BOX3D out
> there? Does this get returned as a string or an array or something
> else? If there’s a better way to do this I would very much appreciate
> that info as well.
>
>
>
> $extent_sql = "SELECT EXTENT(public.nmranch04.the_geom)FROM
> public.nmranch04 WHERE (public.nmranch04.ranch_name = ".$ranch.")";
>
>
>
> Thanks
>
> Kurt
>
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~
>
> Kurt A. Menke
>
> GIS Analyst/Programmer
>
>
>
> _Mailing Address ___
>
> Earth Data Analysis Center
>
> MSC01 1110
>
> 1 University of New Mexico
>
> Albuquerque, New Mexico 87131-0001
>
>
>
> _Street Address___
>
> University of New Mexico
>
> Bandelier West, Room 123
>
> Albuquerque, NM 87131
>
>
>
> Phone: (505) 277-3622 (ext. 239)
>
> FAX: (505) 277-3614
>
> email: kmenke@edac.unm.edu
>
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic