[Live-demo] Updating osm_dataset_overview

[Hamish]

Javi wrote:
> I've been trying to update osm_dataset_overview. I have
> noticed that feature_city data and PostGIS Databases must be
> included. I've already done it, but without description[1].
> I wonder if any of you can help to add short descriptions to
> them, just is case, this is already  done in any other
> document.

Hi,

I was responsible for creating all of those extracts, let me
know if you get stuck.

> On the other hand, I wonder if there may be other cases of
> OSM data included in any other kind of databases, like
> spatiallite, Rasdaman....

hopefully not, and we're all working from the same base dataset.

 
> [1]
> - Nottingham.osm.bz2:
>  A large extract of the greater city area as a BZip2
> compressed XML text file.
> 
> - Nottingham_CBD.osm.bz2:
>  A smaller subset covering just the central business
> district.

Right, the smaller CBD version was created for pgRouting to
keep performance high.

Nottingham was chosen as it will be the host of FOSS4G 2013
in September. Minneapolis (home of FOSS4g-NA 2013) is a much
bigger city & so much bigger dataset, but for this release I'm
thinking to maybe have the "View OSM online" menu entry point
to MN instead of Nottingham. (thoughts?)

I'd note that I haven't run a new Xapi/Overpass extract for
the data since Aug. 2012, but at this late stage in the release
cycle I'm a bit hesitant to touch it.
 (see http://download.osgeo.org/livedvd/data/osm/Nottingham/)

 
> - feature_city.osm.bz2
> - feature_city_CBD.osm.bz2

These are simply stable symlinks to the host city files. All
quickstarts and overviews should use these file/path names so
that they don't go stale and need to be updated every release.

> - feature_city_poi.db

this is a sqlite DB of "positions of interest" nodes extracted
from the above feature_city.osm.bz2. Contains pubs, fuel
stations, restaurants, etc. Technically the osm2poidb program
which creates it comes from OSM's code svn, but is currently
built as part of the GpsDrive package (which is a bit of an OSM
hybrid project with source code partially over at OSM's svn).


> OSM data imported into PostGIS Databases:
> - osm_local
> - osm_local_smerc

imported with osm2pgsql, they are the full feature_city.osm
datasets, one imported to lat/lon (epgs:4326), the other into
the infamous "Google spherical mercator" pseudo-projection for
generating Mapnik webtiles. Perhaps with some osm.xml magic
Mapnik could be trained to just use the osm_local db, but I
haven't tested that.


hope it helps,
Hamish