I have large points data and also a small bounding boxes. I want all the points present within this bounding boxes.
With the extent of the
bbox, I want to get all the points within this
With the help of the below code I was able to query and also write it to a
- The geometry column has non-geometric type variables when comparing the geometry column of the Queried_values and Original_values.
Required Output : get correct geometry values in the SQL queried data
This is my code below :
conn = MySQLdb.connect(host="", port=, user="", passwd="", db="db1", charset="") cur = conn.cursor() cur.execute("""SELECT * FROM db1.table1 where (latitude >=4.139916666666666 and latitude <=52.96272222222222) and (longitude >=5.000083333333333 and longitude <=51.999944444444445)""") set1 = cur.fetchall() with open("point.csv", 'w', newline='') as f_handle: writer = csv.writer(f_handle) header = ['latitude','longitude','geometry'] writer.writerow(header) for row in set1: writer.writerow(row)
Queried_values : This is the output I get after SQL querying.
Original_values : But I would like get the geometry as in this original file.