Skip to content

osmlu/csventrifuge

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

csventrifuge

A flexible csv filter/rewriter, built for Luxembourg's addresses and street lists, but should be adaptable for others.

Folder Description

  • sources -> obtain the values from anywhere you want
  • rules -> modify values
  • enhance -> add values, or replace based on another key
  • filter -> drop values

How to use

  • Execute the utility to produce the required .csv files. See run.sh for an example of how to do this.
  • Open luxembourg-addresses.csv in JOSM, right-click the layer, select Save As... and save it as csventrifuge-out.osm. Make sure to install the OpenData plugin in JOSM first.
  • Run the following command:
grep -vE "(luref|id_caclr_rue|commune|id_geoportail)" csventrifuge-out.osm | sed -e "s/localite/addr:city/; s/id_caclr_bat/ref:caclr/; s/'rue/'addr:street/; s/numero/addr:housenumber/; s/code_postal/addr:postcode/; s/action='modify' //;" >| $(date +%Y-%m-%d)-addresses.osm
  • That's it! You can now open 2018-09-10-addresses.osm in JOSM.

Another way of doing it if you don't need action=modify:

echo addr:street,addr:housenumber,addr:city,addr:postcode,ref:caclr,lat_wgs84,lon_wgs84,commune > $(date +%Y-%m-%d)-addresses.csv
cut -d , -f 2-5,7-9 luxembourg-addresses.csv | tail -n +2 >> $(date +%Y-%m-%d)-addresses.csv
open -a JOSM.app $(date +%Y-%m-%d)-addresses.csv

Notes

https://github.com/roelderickx/ogr2osm could be used to translate from csv to osm too.

Releases

No releases published

Packages

No packages published