Skip to content

Adapt Natural Earth data to hstore all schema #1357

@nvkelso

Description

@nvkelso

When we import the data instead of using column store let's do the same as we do for OpenStreetMap and import using hstore to store arbitrary tags (keys, values).

This would then be paired with moving more property normalization logic out of the JINJA and into the layer YAML.

For example:

 jsonb_build_object(
    'name', name,
    'population', pop_max::text,
    'featurecla', featurecla,
    'scalerank', scalerank,
    'min_zoom', mz_places_min_zoom
  ) AS __places_properties__,

Most if not all of that can then be migrated to the YAML.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions