The current SQL format restricts how the data can be processed: in PostgrSQL only. Nominatim is currently moving in a direction where the data might be preprocessed in Python before being added to the database. Therefore I would like to move to a simple CSV output format with the following columns:
from
to
interpolation
street
city
state (as a two-letter abbreviation)
postcode
geometry (as a WKT)
I'll start with a converter from the existing SQL to this CSV format but eventually the TIGER conversion script needs to be changed to emit CSV natively.
The current SQL format restricts how the data can be processed: in PostgrSQL only. Nominatim is currently moving in a direction where the data might be preprocessed in Python before being added to the database. Therefore I would like to move to a simple CSV output format with the following columns:
I'll start with a converter from the existing SQL to this CSV format but eventually the TIGER conversion script needs to be changed to emit CSV natively.