I am working on a tutorial for those of us that are completely new to OpenStreetMap.
I remember searching and searching for as many resources as possible when I first started.
So here I am, giving back, so-to-speak.
I think all of us take our knowledge for granted and its important to step back/down sometimes
and help out the community where they sometimes need it most. I for one had a lot of trouble
implementing OSM data in my first project. There is certainly an information gap between those
that some background in database/programming and those who do not. All this talk about
PostgreSQL, PostGIS, osm2pgsql and pgadmin had me really confused.
So here it is, a tutorial that will take you from accessing and downloading your first bit of OSM
data, to implementing it in QGIS through the use of a local database.
Would like to write a few lines about Spatialite as well? Download a database from http://22.214.171.124/tiedostot/berlin_2011_08_25.zip , unzip and use the Add SpatiaLite layer tool. After that it just like with PostGIS. QGIS 1.8 is needed for queries, 1.7.0 have just the plain Add layer possibility. Very easy for the user if somebody provides the Spatialite files because then there would be no need to use osm2pgsql and PostgreSQL + PostGIS at all.