I would like to use SQL to create a virtual layer in QGIS by clipping information from a large data set using a bounding box around my study area.
I have two questions. Is this an efficient way to work with large data sets (i.e., more efficient than just loading a large shapefile)?
How do I write the query? for it? I don't really know what I am doing, so far my query looks like this:
Select F* Where ST_Intersects(F.geometry,C.geometry)
At the moment, I keep crashing my computer with my queries. I will post back if I figure this out.