Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have the entire gisgraphy database inside my server. Is it possible to use PostGIS on it to query such as "get locations within 10 miles from this coordinate"?

I tried reading about spatial queries and PostGIS but I am not sure if I could directly use the tables in gisgraphy to obtain results.

share|improve this question
Not familiar with the database, but the difference between "possible" / "can query" and "works at acceptable speed" is usually a spatial index. As for lynxlynxlynx's answer below, more reading of the docs may help. – BradHards Feb 18 '13 at 6:47
up vote 2 down vote accepted

Find places around 10 miles is possible with the find nearby webservice. Find some examples on the free access page

The only thing you have to be aware is that gisgraphy use meter not miles (you have to do the conversion)

share|improve this answer

Judging from its website at it does support PostGIS and since you say you already made the import, querying should be a breeze. It doesn't sound like gisgraphy provides an extra interface for that, so you may need to do it on the postgres server directly.

The query itself is one of the most common ones, so please search this site for answers to that. Another very useful resource is the PostGIS reference at, where you can check all the syntax details.

share|improve this answer

Your Answer


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

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