OpenGeoDb, modified, German data, Austrian data, Switzerland data
geoDb for Germany, Austria and Switzerland
I´ve extracted some basic data from OpenGeoDb to make the usage more comfortable.
The db consists of the plz, cities (inkl. latitude and longitude), states and countries for Germany, Austria and Switzerland. It´s really easy to use: There are only 4 tables which are related by city-,state- and country-id. Also the db size is fairly small, only 10.7 mb (compared to the full OpenGeoDb dump, which has over 180 mb).
Overview of the tables and fields:
Fields: id, name
Fields: id, name, country_id
Fields: id, city, state_id, country_id, lat, long
Fields: plz, city_id
It´s based on the data provided by OpenGeoDb from October 2012.