Create a tool to manage the dataset

As Maite I want a tool to properly manage the dataset

Excel in combination with editing the CSV's doesn't cut it. It removes trailing zeroes etc.

Step 1: replace Excel

For now, we could switch from Excel to something like Tablecruncher.

Step 2: proper tool

I think we want an on-line tool which essentially looks like the excel editor in Google Drive. This should then have good integration with our git repo. You should log in here, commit on save etc.

Step 3: make it fancy (UN/LOCODE specific)

Once we have our own version, we could add UN/LOCODE specific features to it. For example

• Previews of coordinates
• "spell check" for regions: get a yellow underline if you use a code which doesn't exist in the subdivisions.csv
• Autocomplete for regions
• Auto-updating of nameWithoutDiacritics
• Get an error when you try to add a UN/LOCODE which already exists
• Auto-sorting the CSV so any new entries will be at a logical place
• Layout fancyness like a light red background for coordinates slated to be deleted next release.

Step 4: make it really fancy (integrate with the rest)

• Integrate it with DMRs
• Add a way to review PRs

I think this should be fairly doable and I think this is the way to go. Famous last words, but I think a tool which does 1 and 2 shouldn't be too much effort to make.

Thoughts? Anyone knows what Maite would like? She will be the end user after all.