CREATE table t_intersect AS SELECT hp.gid, hp.st_address, hp.city, hp.st_num, hp.the_geom FROM public.housepoints as hp WHERE NOT EXISTS( SELECT * From public.parcel as par WHERE ST_Intersects(hp.the_geom,par.the_geom))
Carl Sena Afenu
- 91
- 1
- 2