0.1.5

PgOSM-Flex 0.1.5 Release Notes

Data related

• Add postcode column, multiple layers #106
• Update address to include postcode, multiple layers #106
• Add historic tag to POI layer #105, #107
• Add relations to POI layer #107
• Fix POI to exclude buildings with empty string (side effect from change in helpers.lua) #107

Backend related

• Improve quality control queries RE missing features #106
• Swapped JSON implementation to supported project, improved tags import performance was bonus #88

0.1.4

New

• PGOSM_LANGUAGE environment variable to set preferred language for name columns (#93)

Updated

• Building layer includes osm_subtype column #97 / #99
• Building layer includes Address-only objects (#97)
• Add missing osm_type column to vbuilding_all (#98)
• Documentation improvements (#96)

0.1.3

New

• Docker script auto builds nested polygon data w/ env var to override (#91)

Updated

• Moved address calculation to helpers.lua - Greatly improved quality of final address (#92, #95)
• Fixed typos in comments (#94)

0.1.2

Updated

• Shop layer includes additional amenity features #84
• Improved documentation & comments #81, #84
• Move address concatenation to generated column #82
• Docker script checks for Postgres service ready #86

New

• Docker run script handles OSM file dates (#85/#80)
• POI layer via Mat view (#63/#89)

0.1.1

Fixed

• Improved relations in unitable #75
• Improved nested place polygon matching #73
• Restructured project code - Lua/SQL layer files in style/ and sql/ subdirectories #67

New

• Add region tracking to meta data #77
• Improve Docker runtime customizations #76

0.1.0

General improvements

• Calculate methods of travel for roads #18
• Remove env var PGOSM_SCHEMA #65
• New run option #66
• Meta information tracking #64
• Add missing relations #70

0.0.8

General improvements

• Documentation and comment improvements
• #54 Improve admin_level handling --- ⚠️ Data type change - Now INT ⚠️
• #52 Include additional features in nested polygon data
• Docker improvements

0.0.7

General improvements

• Add comments on DB objects (tables, columns, etc) - #45
• QGIS style for Landuse - #47
• Meta table tracks pgosm-flex version, commit hash and osm2pgsql versions #51

New layers

N/A

Improved Layers

• Traffic includes noexit #33
• Improve nested polygons #50

0.0.6

General improvements

• Initial Docker image converted from PgOSM legacy, improved logging, updates for Flex #44
• Add osm.tags.osm_url to link to appropriate node/way/relation page on openstreetmap.org
• Table osm.pgosm_flex to track PgOSM meta about version

New layers

• Road point layer #34
• Nested admin boundaries track admin poly inside other admin poly #37

Improved Layers

• Improve Road line columns #30
• View osm.vplace_polygon removes member polygons duplication containing relation
• Helper get_name() parses single name from multiple columns #38

0.0.5

Improving use of helpers.lua. Documentation improvements, added first quality control query.

New layers

• Landuse #24
• Leisure #23

Improved Layers

• Road #27
• Amenity #20, #29
• Building (including building:part)