Im just wondering if one can make an spatial database using postgres + postGIS wherein the user can query each city in the world then get the their real coordinates(latitude&longitude) in the resulting set.
Asked
Active
Viewed 804 times
0
-
http://stackoverflow.com/questions/1023229/spatial-data-in-postgresql – Vinit Prajapati Sep 20 '13 at 07:52
-
and is there a downloadable database that contains all places in the world together with their coordinates in the globe? – Erwin Macale Sep 20 '13 at 08:37
-
1Maxmind has free world Geo database. – Micromega Sep 20 '13 at 08:45
-
1If you want to just query for the name and return coordinates you don't need PostGIS for that. – Jakub Kania Sep 20 '13 at 14:42
1 Answers
1
There's a bunch of available data sets out there.
I would assume, that GeoNames is most appropriate here. This project extracts all objects from Wikipedia, that has coordinates specified. And of course, it is quite possible to query cities.
If you need more detailed info, then all depends on a particular country. Say, Netherlands state authorities can provide you extracts of the state estate database, which includes all buildings, inhabited places, living boats and some more.
I assume that building a complete list of cities will be a costy project.
vyegorov
- 21,787
- 7
- 59
- 73
-
-
@jawr, Something [here](https://www.gov.uk/government/statistical-data-sets), perhaps... – vyegorov Aug 18 '14 at 18:50