geonames.org

December 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:

Comments are no longer accepted for this post.

Contact


Imprint

vvvv - Dießl & Gregor GbR
Oranienstrasse 10
10997 Berlin/Germany
VAT: DE275566955

groupӘvvvv.org

Follow us

Sign up for our Newsletter

Your subscription could not be saved. Please try again.
Your subscription has been successful.