I have a feature data which is based on lat/long. To show on the map, I convert them to east/nort. When dealing with Bounding box, I am getting co-ords is east/north, so I am converting from east/north to latlong. Left/Top, Right/Bottom pairs. But the issue is that after the conversion to lat/long, bounding box may not a rectangle.
With east/north, I can use simple SQL clause to filter out features. What clause should i make for handling filetring based on lat/long.
When dealing with feature data based on east/north, i use a simple where clause Lat < high && Lat > Low && Long > high && Long < Low. But when dealing with lat/long I cannot go with that. I need to do something addition to this. I am using SQL server/Oracle