I'm new to this list. Where do I post questions regarding setting up Rails and PostGIS. I have questions regarding users, create DB, permissions, etc.
Dave van Bakergem St. Louis -----Original Message----- From: [email protected] on behalf of Paul Ramsey Sent: Tue 1/13/2009 10:07 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] Query Help SELECT o.name, o.id, s.name FROM offenders o, schools s WHERE ST_DWithing(o.the_geom, s.the_geom, 500) AND o.status = 'TRUE'; On Tue, Jan 13, 2009 at 7:56 AM, chris brisendine <[email protected]> wrote: > I am trying to do a query where I have two point tables one is > offenders and the other is schools I want to out put the list of > offenders by offender name and offender id within 500 meters of any > school but I don't think my query is correct. Can someone please help > me with this query > > field's are offender.status(Witch would be true),offender.name, offender.id > > SELECT offenders, school_name > FROM schools > WHERE st_dwithin(the_geom, 'OFFENDER=TRUE',500) > > > Thanks, > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
<<winmail.dat>>
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
