Paul Norman
Paul Norman
http://www.openstreetmap.org/images/hidden_note_marker.png is missing. Used on note browse pages for notes that have been hidden by a moderator.
Steps to reproduce 1. View a changeset page (e.g. http://www.openstreetmap.org/changeset/19353688#map=2/24.5/19.7  2. Pan so that the changeset bbox is partially offscreen  3. Wait a few seconds 4. Pan back...
We've merged the moderator branch, so people can now report issues that need to make it to the DWG. People with the moderator flag (DWG and admins) can see the...
I was trying to pass a DWG case to another DWG member today. All of my correspondence with the user involved has been by osm.org message. Unfortunately, there's no easy...
Many transforms need additional indexes to be used. Currently this is commonly done as a .sql file distributed alongside the transforms, but this is not ideal for a few reasons...
Since PostGIS 2.5 and PostgreSQL 11, spgist indexes are available for 2d and 3d geometries. PostGIS performance testing [indicates they are beneficial with many overlapping objects.](https://postgis.net/docs/using_postgis_dbmanagement.html#spgist_indexes) This is the situation...
Currently osm2pgsql always creates geometry indexes and orders the tables by geometry, essentially clustering them. There are cases where this is not desirable. 1. Benchmarking of other parts. 2. Analysis...
Any complex lua transform should have tests to check expected behavior against actual behavior. For the pgsql backend an example is [OpenStreetMap Carto's tests](https://github.com/gravitystorm/openstreetmap-carto/blob/master/scripts/lua/test.lua). For the multi-backend, an example is...
It's been said that you could almost use /dev/null for a flat-nodes file if you have a large enough -C value and don't plan to update the database. An option...
With in-memory pending, the middle tables are only read from once processing is finished. This allows us to build indexes right away, including the GIN index on planet_osm_ways.nodes, which is...