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.
4
-
stackoverflow.com/questions/1023229/spatial-data-in-postgresqlVinit Prajapati– Vinit Prajapati2013-09-20 07:52:54 +00:00Commented Sep 20, 2013 at 7:52
-
and is there a downloadable database that contains all places in the world together with their coordinates in the globe?Erwin Macale– Erwin Macale2013-09-20 08:37:42 +00:00Commented Sep 20, 2013 at 8:37
-
1Maxmind has free world Geo database.Cybercartel– Cybercartel2013-09-20 08:45:02 +00:00Commented Sep 20, 2013 at 8:45
-
1If you want to just query for the name and return coordinates you don't need PostGIS for that.Jakub Kania– Jakub Kania2013-09-20 14:42:47 +00:00Commented Sep 20, 2013 at 14:42
Add a comment
|
1 Answer
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.
