Python|Python Scraping ———10.15.2017

Select region from posgresql database

SELECT stationid FROM tbl_APP_eachstations WHERE tbl_APP_eachstations.location && ST_MakeEnvelope(minlng, minlat, maxlng, maxlat, 4326)
【Python|Python Scraping ———10.15.2017】*This is provided to extract data where location is stored as Geometry POINT object
**4326 representing the SRID

    推荐阅读