I'm a database administrator who's working with a new client who'd like to use a "search" or "filter" application with GIS. For example, he would like to search within his area of properties that are over 30 acres, have this elevation, etc.

Is there a way to search in that system or to create a search/filter system?

closed as too broad by PolyGeo Feb 4 at 13:16

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.


You could surely use a GIS for that, but since you are coming from a database background I would suggest you look into PostgreSQL with a PostGIS extension. That would enable you to use all of the usual SQL plus a good amount of functions that are solely related to spatial data. Depending on how complex your client's queries would be that would surely be a better option than any "real" GIS. Since you have a good understanding of databases it would also most likely be the easiest for you to set up for your client.

Would your client desire to also visualize the results then you could hook up PostgreSQL to a GIS software, like QGIS. QGIS is open source, you can download it for free, and it is very easy to set up a connection to PostgreSQL. I actually showed how to do that in an earlier post today.


An alternative light weight option would be to use SQLite/spatiallite and QGIS as @BritishSteel mentioned as the client viewer.

QGIS Query Builder

Not the answer you're looking for? Browse other questions tagged or ask your own question.