geonames.orgDecember 4, 2008 posted by: joreg
in the series of webservices:
^The GeoNames geographical database is available for download free of charge under a creative commons attribution license. It contains over eight million geographical names and consists of 6.5 million unique features whereof 2.2 million populated places and 1.8 million alternate names.^ geonames.org
this is huge! the database includes fields like the name (of a place), latitude, longitude, country code, population count, elevation, timezone and more.
for ease of use in vvvv i see two options:
use the HTTP (Network Get) node node to access one of the webservices documented here.
download (scroll down for file-infos) a database dump and import it in your own local mysql database. (i’ve used the gui heidi-sql for the import as i am not really familiar with databases). then you can easily use vvvvs mysql nodes (((Database (MySQL Network) )), Select (MySQL) node, ..) to access the data. alternatively you could try to use Separate (String) node and/or RegExpr (String) node to retreive the data you’re interested in, but this could become quite a non-realtime approach with that large amount of data.
btw. when dealing with the latitude and longitude data the Polar (3d) node and Cartesian (3d) node nodes might come handy (also see the \girlpower\worldcities.v4p for a bad example. note to self: make that a good one for >beta19.1).
Comments are no longer accepted for this post.