spatial data filtering without GIS?

Question

I have access to a database here (description of the columns are also available) containing spatial data in text format and with WGS84-EPSG:4326 coordinates.

I would like to only select data in my country (Czech Republic) and save them to our database. Is there any easy way to do this without need to import it to spatial DB and then filter it out?

I am thinking about very simple calculation using simple conditions etc. Is there a better solution than to draw a rectangle in QGIS covering whole country and then use it to define range for longitude and latitude and use it as condition for filtering?

Thanks

Answer 1

On a simple level, if you define a bounding box for the Czech Republic you can construct an SQL query to test if the X and Y coordinates are within the maximum and minimum coordinates of the bounding box.

The query would be something like:

SELECT * FROM [TABLE] WHERE 
[X_FIELD] BETWEEN [BOUND_XMIN] AND [BOUND_XMAX] 
AND
[Y_FIELD] BETWEEN [BOUND_YMIN] AND [BOUND_YMAX]

Of course this will result in some data outwith the Czech Republic, as the country is not a perfect rectangle.