gsql=‘select w.fclass,w.geom,w.name from (select geom as cgeom from 市 where 市=‘淮北市’ or 市=‘铜陵市’ ) as c,gis_osm_buildings_a_free_1 as w where ST_Intersects(c.cgeom,w.geom)’
wresult=gpd.read_postgis(gsql,geom_col=‘geom’,con=engine,crs=4326)
print(wresult[[‘fclass’,‘name’]])



