refactor: municipality name matching in queries - Githubissues

statistikZH / statbotData

MIT License

0 stars 1 forks source link

refactor: municipality name matching in queries #102

Closed cmdoret closed 12 months ago

cmdoret commented 12 months ago

Does the following for cantonal datasets A21 - A26

More flexible municipality name matching in queries
Fix quoting for postgres compatibility (single quote for values)
Upload tables to postgres and set status in dataset list

In addition, the table name for A21 had to be truncated to fit in postgres' 63 bytes limit for table names.