Return to Answer

Enable syntax highlighting.

edit approved Jul 18, 2015 at 12:00

1.6k
3
18
31

You just need "KDhh_survey".* in your Select

SELECT "KDhh_survey".* FROM public."KDhh_survey", public."ur_pilot_survey" WHERE ST_contains(public."ur_pilot_survey".the_geom, public."KDhh_survey".the_geom);

SELECT "KDhh_survey".* FROM public."KDhh_survey", public."ur_pilot_survey" WHERE ST_contains(public."ur_pilot_survey".the_geom, public."KDhh_survey".the_geom);

You just need "KDhh_survey".* in your Select

SELECT "KDhh_survey".* FROM public."KDhh_survey", public."ur_pilot_survey" WHERE ST_contains(public."ur_pilot_survey".the_geom, public."KDhh_survey".the_geom);

You just need "KDhh_survey".* in your Select

SELECT "KDhh_survey".* FROM public."KDhh_survey", public."ur_pilot_survey" WHERE ST_contains(public."ur_pilot_survey".the_geom, public."KDhh_survey".the_geom);

Source Link

answered Aug 14, 2013 at 23:46

Nathan W

35.1k
5
100
148

You just need "KDhh_survey".* in your Select

SELECT "KDhh_survey".* FROM public."KDhh_survey", public."ur_pilot_survey" WHERE ST_contains(public."ur_pilot_survey".the_geom, public."KDhh_survey".the_geom);