[postgis-users] PostgreSQL, PostGIS and spatial data

iheanyi Okeh simflex at hotmail.com
Mon Mar 29 08:47:59 PST 2004

Can you please then explain to me if you don't mind,
how the arguments in the where predicate are generated?

   WHERE the_geom && 'BOX3D(90900 190900, 100100 200100)'::box3d
   AND distance( the_geom( 'POINT(2227284.1963667543 1435389.6730164126)',
-1 ) ) < 100
ORDER BY dist limit 1

So far, the arguments in the BOX3D(...), I entered here are the same as the 
x/y coordinate point in the select statement and I am pretty sure it isn't 
I also think that the arguments in distance = distance( the_geom( 
'POINT(2227284.1963667543 1435389.6730164126)' are probably not correct 

>From: Tyler Mitchell <TMitchell at lignum.com>
>Reply-To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
>To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
>Subject: Re: [postgis-users] PostgreSQL, PostGIS and spatial data
>Date: Mon, 29 Mar 2004 08:39:06 -0800
> > I don't know if I am getting this right. I need your confirmation:
> > PostgreSQL has already the geometric data types and some functions to
> > handle with this spatial data, but PostGIS adds lots of others
> > metatables, etc, in order to make PostgreSQL compatible with SFS/OGC
> > and more powerful.
>I'd say you're pretty close, though with postgres having "geometric data
>types" doesn't really make it spatial in the sense you are probably
>thinking. In other words, it's VERY limited without postgis.
> > So PostgreSQL has some basic spatial capability
>Less than basic (?)
> > and PostGIS makes PostgreSQL
> > a database to support a real GIS.
>Oh yeah!  From an analysts perspective, it IS the GIS!
>postgis-users mailing list
>postgis-users at postgis.refractions.net

Is your PC infected? Get a FREE online computer virus scan from McAfee® 
Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

More information about the postgis-users mailing list