Tag Info

New answers tagged


If you want a unique id per row it will be easiest to use the row number. SELECT (row_number() OVER())-1 AS id, way, (...) That way you'll get incrementing id starting from 0 and won't have to worry about collision.


I found a simple workaround that seems to work ok. Make a PostGIS layer with an extra column like this: (SELECT way,.... osm_id % 65500 AS tinyid FROM planet_osm_point) p Then set tinyid as the layer's "Unique key field". That is, take the actual osm_id modulo 65500 to always produce a value in the range 0-65500. This will occasionally cause errors if ...

Top 50 recent answers are included