create part of joinfunction that has "overlap" ability based on this SQL:
Select mdc_parcels_camp_draft.folio, ST_AREA(ST_INTERSECTION(mdc_parcels_camp_draft.geom_local,mdc_water_polygons.geom_local)), mdc_parcels_camp_draft.geom FROM mdc_parcels_camp_draft, mdc_water_polygons WHERE ST_Intersects(mdc_parcels_camp_draft.geom_local,mdc_water_polygons.geom_local) AND ST_AREA(ST_INTERSECTION(mdc_parcels_camp_draft.geom_local,mdc_water_polygons.geom_local))/ST_AREA(mdc_parcels_camp_draft.geom_local) > 0.50;
[x] get the above SQL working in PGAdmin
[x] make sure to pull from tools repo before beginning ...
[x] Construct some code to build the string: '
WHERE ST_Intersects(mdc_parcels_camp_draft.geom_local,mdc_water_polygons.geom_local)
AND ST_AREA(ST_INTERSECTION(mdc_parcels_camp_draft.geom_local,mdc_water_polygons.geom_local))/ST_AREA(mdc_parcels_camp_draft.geom_local) > 0.50;
'
tibbben
commented
5 months ago
create part of joinfunction that has "overlap" ability based on this SQL:
Select mdc_parcels_camp_draft.folio, ST_AREA(ST_INTERSECTION(mdc_parcels_camp_draft.geom_local,mdc_water_polygons.geom_local)), mdc_parcels_camp_draft.geom FROM mdc_parcels_camp_draft, mdc_water_polygons WHERE ST_Intersects(mdc_parcels_camp_draft.geom_local,mdc_water_polygons.geom_local) AND ST_AREA(ST_INTERSECTION(mdc_parcels_camp_draft.geom_local,mdc_water_polygons.geom_local))/ST_AREA(mdc_parcels_camp_draft.geom_local) > 0.50;