[postgis-users] Query Help

chris brisendine cbriz882 at gmail.com
Tue Jan 13 07:56:58 PST 2009

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)


More information about the postgis-users mailing list