Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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

share|improve this question
What software are you using and can you provide a code snippet of what you have tried so far? Please do this by editing your question rather than as a comment. –  PolyGeo Jul 13 '13 at 20:59
Any reason why you can't just find the min/max of your bounding box extent? –  BradHards Jul 14 '13 at 0:43
What database? PostGIS? Sql Server? –  Russell at ISC Jul 15 '13 at 13:04

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.