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
