Getting skeletron_routes table?

[brookstalley]

I've got the entire OSM/Terrain toolchain and dataset going... except "make" failes in Terrain/mapnik because it's looking for a "skeletron_routes" table in the database.

make
cascadenik-compile.py style.mml style.xml
output file: style.xml /data/Terrain/mapnik
/usr/lib/python2.6/site-packages/cascadenik-1.1.2-py2.6.egg/cascadenik/output.py:46: DeprecationWarning: 'Filter' is deprecated and will be removed in Mapnik 2.0.1, use 'Expression' instead
  rul.filter = rule.filter and mapnik.Filter(rule.filter.text) or rul.filter
Traceback (most recent call last):
  File "/usr/bin/cascadenik-compile.py", line 5, in <module>
    pkg_resources.run_script('cascadenik==1.1.2', 'cascadenik-compile.py')
  File "/usr/lib/python2.6/site-packages/pkg_resources.py", line 461, in run_script
    self.require(requires)[0].run_script(script_name, ns)
  File "/usr/lib/python2.6/site-packages/pkg_resources.py", line 1194, in run_script
    execfile(script_filename, namespace, namespace)
  File "/usr/lib/python2.6/site-packages/cascadenik-1.1.2-py2.6.egg/EGG-INFO/scripts/cascadenik-compile.py", line 93, in <module>
    sys.exit(main(layersfile, outputfile, **options.__dict__))
  File "/usr/lib/python2.6/site-packages/cascadenik-1.1.2-py2.6.egg/EGG-INFO/scripts/cascadenik-compile.py", line 34, in main
    cascadenik.load_map(mmap, src_file, dirname(realpath(dest_file)), **load_kwargs)
  File "/usr/lib/python2.6/site-packages/cascadenik-1.1.2-py2.6.egg/cascadenik/__init__.py", line 65, in load_map
    compile(src_file, dirs, verbose, datasources_cfg=datasources_cfg).to_mapnik(map, dirs)
  File "/usr/lib/python2.6/site-packages/cascadenik-1.1.2-py2.6.egg/cascadenik/output.py", line 62, in to_mapnik
    lay.datasource = layer.datasource.to_mapnik()
  File "/usr/lib/python2.6/site-packages/cascadenik-1.1.2-py2.6.egg/cascadenik/output.py", line 131, in to_mapnik
return mapnik.Datasource(**self.parameters)

File "/usr/lib64/python2.6/site-packages/mapnik/__init__.py", line 296, in Datasource
    return CreateDatasource(keywords)
RuntimeError: Postgis Plugin: PSQL error:
ERROR:  relation "skeletron_routes" does not exist
LINE 6:                      FROM skeletron_routes

I see the Skeletron project, but browsing through its source it doesn't look like it stuffs data into postgis. Any advice on how to get / generate that table?

[brookstalley]

PS: I did find the CountiesOSM repository, and skeletron-routes.sh looks promising... but I'm kind of at a loss for what to do with it. I already have a full planet OSM import done, and running make in CountiesOSM seems to want to pull down state pbf's.

Many thanks for all of your excellent work and for sharing this source -- I'm hoping to have some cool stuff to contribute back once I get this up and running.

[ejsarge]

I, too, am interested in this issue. CountiesOSM does pull in the state pbfs and processes them. I have it running now.
However, my reading of the script is that the output will be tables with names like roadswashington and routeswashington. I'm not finding any scripts or views for combining this data.

[ejsarge]

See my pull request 6 on this repo.