[OSM-dev] ClearTables: Another way to use OSM data for rendering and analysis

[Paul Norman]

Osm2pgsql has the ability to take a set of transforms[1] to convert 
OpenStreetMap data to a fairly arbitrary set of tables, allowing the use 
of complex logic written in Lua, a lightweight programming language 
often used in embedded applications. Doing this logic in Lua avoids what 
can be complex SQL statements, replacing them with Lua functions which 
can be unit tested in isolation.

I have been working on a set of these, called ClearTables: 
https://github.com/pnorman/ClearTables. Their goal is to simplify use of 
the resulting database for rendering and analysis.

- The audience for this is not really this mailing list. A more typical 
target would be those who ask questions on gis.stackexchange.com

- The latest release (0.88.1) of osm2pgsql should mostly work, but it's 
being developed against 0.89.0-dev.

- There are plenty of features which are not processed yet, and are 
being tracked in issues. If there's something that needs adding, opening 
a new issue is the best way to provide feedback: 
https://github.com/pnorman/ClearTables/issues

- I'm interested in other needs and use cases

- I can pg_dump or provide shapefiles for an area if someone is 
interested and is in an environment where they can't build osm2pgsql


[1]: https://github.com/openstreetmap/osm2pgsql/blob/master/docs/multi.md