» geonames.org
This site relies heavily on Javascript. You should enable it if you want the full experience. Learn more.

geonames.org

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:

  • 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), ..) to access the data. alternatively you could try to use Separate (String) and/or RegExpr (String) 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) and Cartesian (3d) 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).

joreg, Thursday, Dec 4th 2008 Digg | Tweet | Delicious 0 comments  
  • 1

anonymous user login

Shoutbox

~2d ago

joreg: @mediadog they are here: workshop-videotracking-node10

~3d ago

mediadog: Hmmm slides for node10 video tracking cannot be found: workshop-videotracking-slides

~4d ago

joreg: @mediadog thanks for the pointer, links are updated

~5d ago

mediadog: Where are the 50beta42 offline instalers? The offline installers are still linked to 41, not 42.

~8d ago

id144: thanks @gegenlicht & @bjoern, i hope the festival sorted it.

~10d ago

Patxi7: @joreg done

~11d ago

joreg: @neuston @u7angel can you please start a forum thread describing the problem you're having with a few more words?

~11d ago

u7angel: @neutron, same here