New mapping file for OSM import, includes infrastructure elements

mapping-1.yaml

tags:
  load_all: true
tables:
  power:
    columns:
    - name: osm_id
      type: id
    - name: geometry
      type: geometry
    - key: name
      name: name
      type: string
    - name: type
      type: mapping_value
    - key: voltage
      name: voltage
      type: string
    - key: cables
      name: cables
      type: integer
    - key: circuits
      name: circuits
      type: integer
    - key: operator
      name: operator
      type: string
    - key: wires
      name: wires
      type: string
    - key: frequency
      name: frequency
      type: string
    - key: addr:housenumber
      name: addr:housenumber
      type: string
    - key: addr:street
      name: addr:street
      type: string
    - key: addr:city
      name: addr:city
      type: string
    - key: addr:state
      name: addr:state
      type: string
    - key: addr:country
      name: addr:country
      type: string
    - key: addr:postcode
      name: addr:postcode
      type: string
    - key: attribution
      name: attribution
      type: string
    - key: comment
      name: comment
      type: string
    - key: contact:email
      name: contact:email
      type: string
    - key: contact:phone
      name: contact:phone
      type: string
    - key: contact:website
      name: contact:website
      type: string
    - key: description
      name: description
      type: string
    - key: email
      name: email
      type: string
    - key: fixme
      name: fixme
      type: string
    - key: phone
      name: phone
      type: string
    - key: source
      name: source
      type: string
    - key: source:geometry
      name: source:geometry
      type: string
    - key: source_ref
      name: source_ref
      type: string
    - key: url
      name: url
      type: string
    - key: website
      name: website
      type: string
    - key: wikipedia
      name: wikipedia
      type: string
    mapping:
      power: [__any__]
    type: polygon
  power_lines:
    columns:
    - name: osm_id
      type: id
    - name: geometry
      type: geometry
    - key: name
      name: name
      type: string
    - name: type
      type: mapping_value
    - key: voltage
      name: voltage
      type: string
    - key: cables
      name: cables
      type: integer
    - key: circuits
      name: circuits
      type: integer
    - key: operator
      name: operator
      type: string
    - key: wires
      name: wires
      type: string
    - key: frequency
      name: frequency
      type: string
    - key: addr:housenumber
      name: addr:housenumber
      type: string
    - key: addr:street
      name: addr:street
      type: string
    - key: addr:city
      name: addr:city
      type: string
    - key: addr:state
      name: addr:state
      type: string
    - key: addr:country
      name: addr:country
      type: string
    - key: addr:postcode
      name: addr:postcode
      type: string
    - key: attribution
      name: attribution
      type: string
    - key: comment
      name: comment
      type: string
    - key: contact:email
      name: contact:email
      type: string
    - key: contact:phone
      name: contact:phone
      type: string
    - key: contact:website
      name: contact:website
      type: string
    - key: description
      name: description
      type: string
    - key: email
      name: email
      type: string
    - key: fixme
      name: fixme
      type: string
    - key: phone
      name: phone
      type: string
    - key: source
      name: source
      type: string
    - key: source:geometry
      name: source:geometry
      type: string
    - key: source_ref
      name: source_ref
      type: string
    - key: url
      name: url
      type: string
    - key: website
      name: website
      type: string
    - key: wikipedia
      name: wikipedia
      type: string
    mapping:
      line: [__any__]
    type: linestring