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 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
add comment

2 Answers

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
add comment

Judging from its website at https://sourceforge.net/projects/gisgraphy/ 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 http://www.postgis.org/documentation/manual-2.0/reference.html, where you can check all the syntax details.

share|improve this answer
add comment

Your Answer

 
discard

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.