xplanetFX renders high quality wallpapers of mother earth on your desktop. An extensive GUI (GTK) provides a lot of features and settings. Various templates place the planet inside different scenes and make shure your desktop never gets boring again. With realtime light, shadows and clouds!

traGtor is a graphical user interface for the awesome conversion tool ffmpeg. With multi streams, presets, multi language and a lot of other features traGtor is a handy tool for converting all audio and video formats through ffmpeg. traGtor is based on GTK and Python.

Calf studiogear is an extensive and high quality plugin pack for professional audio production under Linux. It provides a lot of synthesizers, effects and signal processing for the use with LV2 audio production suites (like Ardour) or as stand-alone through JACK.

Calf with all of its new features and processors isn't officially released by now so you have to grab the GIT-repository from sourceforge.net until we are ready for a stable release.

» calf.sourceforge.net

guess is a tool to launch (and kill) different setups of programs. It was invented to startup all needed synthesizers, audio suites, MIDI sequencers and stuff with the correct source files on the right desktop for a single audio production with just one click.

xplanetFX - series: Mit xplanetFX ganze Bilderserien erstellen

oRainge Theme: GTK-, GDM-, Metacity-, Icons-Theme

oRainge gDesklets: Sprechende Uhren, Kalender, System-Widgets (manual)

photogen:c SVG-Icons: Diverse High-Quality-Icons im SVG-Format

traffick: Serverumgebungen testen. Durch skalierbares Threading erzeugt traffick Unmengen an Suchanfragen und Webseitenaufrufen, um ein hohes Maß an Vorratsdaten Netzwerkauslastung zu simulieren.

GIMP Plug-In “Moderated Blur” for Tilt Shift and Depth-Of-Field Effects

stuff (de) guess calf traGtor xplanetFX

MySQL Databases with Countries, Borders and Cities

Actually I’m coding some web apps for my new employer and I needed a couple of geo information to build on. Since it took some time to create the database from different sources I would like to share them with the rest of the world. (Click on the header for download)

Database: countries

ID | name | code_2 | code_3 | code_num | area | population | region | subregion | latitude | longitude

  • „code_2“ is a two char country code
  • „code_3“ is a three char country code
  • „code_num“ is the numerical UN code
  • „area“ is the expanse of the country
  • „population“ is from 2005
  • „region“ is the UN region code – mainly the continent
  • „subregion“ is the UN subregion code

Table: cities

ID | latitude | longitude | name | country

  • „country“ is the ID of the corresponding country
There may be some „minor“ cities in this database because of my special scope.

Table: coords

ID | country | coords | coords2

  • „country“ is the ID of the corresponding country
  • „coords“ is a comma and whitespace separated list of lat/lon for generating polygons (e.g. to create imagemaps in HTML) with up to 16 digits
  • „coords2“ is like coords but with reduced accuracy with only 3 digits max

The sources are mainly „free4all“ except the border coordinates, they’re from thematicmapping.com which means that the table „coords“ is released under CC-SA. Everything else is released under the DO WHAT THE FUCK YOU WANT TO LICENSE

  1. 2 comments on “MySQL Databases with Countries, Borders and Cities”

  2. Aleksa

    Hi, I need your help, because you have already worked with these databases I think that you can help me, if you want. What I need is simple, I need a PHP program that have 2 variables (longitude and latitude), then it checks databases and it finds to which country does the cordinates belong and then it prints the name of the country. I would be very thankful if you could write that program.
    Thanks in advance

  3. Markus Schmidt

    Hey Aleksa,

    probably you want to use this tool:


    Cheers, Markus.

Write a comment / Schreibe einen Kommentar (MySQL Databases with Countries, Borders and Cities)

Please note that comments are moderated and don't appear immediately. If you're reporting a problem or a bug I'll publish them when I started processing your request.

Bitte beachte: Kommentare sind moderiert und erscheinen nicht sofort. Ich veröffentliche Bugreports und Hilferequests erst, sobald ich mich eines Problems oder Bugs angenommen habe.

You're reporting a bug? click here!

Thank you very much!! You're doing an essential job for the development of open source software! The following points aren't meant as dogmas but as a clue, decide for yourself what you think could be useful in troubleshooting.

  • Please...
  • ...state name and version of your operating system / desktop environment
  • ...state the version of the program you're using
  • ...be detailed in what is happening and what you expected to happen
  • ...try to provide some deeper information (like xplanetFX logs or the output of the program when started in a terminal window)
  • ...speak to me as a human being, don't think I'm a bot.

Du möchtest einen Fehler melden? klick hier!

Herzlichen Dank!! Fehlerberichte sind essentiell für die Entwicklung von Open-Source-Software! Die folgenden Punkte sind keine Dogmen, sondern sollen eher Anhaltspunkte darstellen; entscheide selbst, ob sie für die Fehlersuche hilfreich sein könnten.

  • Bitte...
  • ...nenne den Namen und die Version Deines Betriebssystems / Deiner Desktopumgebung
  • ...nenne die Version des von Dir benutzten Programms
  • ...beschreibe möglichst genau, was passiert und was Du erwartest, was passieren sollte
  • ...stelle möglichst tiefergehende Informationen zur Verfügung (xplanetFX Logs oder die Ausgabe des Programms im Terminalfenster)
  • ...sprich mit mir, wie mit einem Menschen, ich bin kein Automat.

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>