[postgis-users] Re: problem with BOX3D query

[Randy George]

Hi,

Pdf http://postgis.refractions.net/docs/postgis.pdf

"The most common spatial query will probably be a "frame-based" query, used
by client software, like data browsers
and web mappers, to grab a "map frame" worth of data for display. Using a
"BOX3D" object for the frame, such a
query looks like this:
SELECT
AsText(GEOM) AS GEOM
FROM ROADS_GEOM
WHERE
GEOM && GeomFromText('BOX3D(191232 243117,191232 243119)'::box3d,-1);
Note the use of the SRID, to specify the projection of the BOX3D. The value
-1 is used to indicate no specified SRID."

Html http://postgis.refractions.net/docs/ 

"The most common spatial query will probably be a "frame-based" query, used
by client software, like data browsers and web mappers, to grab a "map
frame" worth of data for display. Using a "BOX3D" object for the frame, such
a query looks like this:

SELECT 
  AsText(GEOM) AS GEOM 
FROM ROADS_GEOM 
WHERE 
  GEOM && SetSRID('BOX3D(191232 243117,191232 243119)'::box3d,-1);
Note the use of the SRID, to specify the projection of the BOX3D. The value
-1 is used to indicate no specified SRID.

4.4.2. Using the Dumper"

Thanks
Randy

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
strk at refractions.net
Sent: Tuesday, May 09, 2006 8:06 AM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] Re: problem with BOX3D query

On Tue, May 09, 2006 at 07:52:19AM -0600, Randy George wrote:
> Hi,
> 
> 	It looks like the pdf manual p21 4.4.1 should be updated to synch
> with the html manual.

The PDF manual and the HTML manual are both generated from
the same XML source. Where are the different versions published ?

--strk;
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users