Yesterday I worked with my colleague Martijn on making openstreetmap data available through a WFS. First he put the data in a PostGIS database (see the post on his blog). After that it was quite easy to make the data available in Deegree WFS.
It appeared the import tool om OSM did not add primary keys, so they were made by adding a serial type column to all OSM tables and making it the primary key.
After running a java tool to create the Deegree WFS datastore XML for OSM and adding some lines to make the OSM features visible and queryable the Deegree WFS was up and running.
So now we have a WFS 1.1 service supplying OSM data in GML 3.1.1 format.
Nice result in a few hours, but I still want to do some things, namely:
- Change the default app namespace into an osm namespace. Actually this is done in 5 seconds…
- Try to output GML SF. The OSM tables are very simple and flat, so SF should be more than enough.