sqlalchemy.exc.DataError: (psycopg2.DataError) invalid input syntax for type double precision: "a"

Created by: hixi

https://sentry.njo.ch/geometalab/osmaxxstaging/issues/197/

DataError: (psycopg2.DataError) invalid input syntax for type double precision: "a"
 [SQL: 'INSERT INTO osmaxx.building_a\n  SELECT osm_id as osm_id,\n    osm_timestamp as lastchange ,\n    CASE\n     WHEN osm_id<0 THEN \'R\' -- R=Relation\n     ELSE \'W\'               -- W=Way\n     END AS geomtype,\n    ST_Multi(way) AS geom,\n    building as type,\n    name as name,\n    "name:en" as name_en,\n    "name:fr" as name_fr,\n    "name:es" as name_es,\n    "name:de" as name_de,\n    int_name as name_int,\n    case\n        when name is not null AND name = osml10n_translit(name) then name\n        when "name:en" is not null then "name:en"\n        when "name:fr" is not null then "name:fr"\n        when "name:es" is not null then "name:es"\n        when "name:de" is not null then "name:de"\n        when name is not null then osml10n_translit(name)\n        else NULL\n    end as label,\n    cast(tags as text) as tags,\n    cast(nullif(height,\'\') as float) as height\n  FROM osm_polygon\n  WHERE building is not null;\n']
(16 additional frame(s) were not displayed)
...
  File "osmaxx/conversion/converters/converter_gis/bootstrap/bootstrap.py", line 30, in bootstrap
    self._filter_data()
  File "osmaxx/conversion/converters/converter_gis/bootstrap/bootstrap.py", line 79, in _filter_data
    self._execute_sql_scripts_in_folder(script_folder_path)
  File "osmaxx/conversion/converters/converter_gis/bootstrap/bootstrap.py", line 106, in _execute_sql_scripts_in_folder
    self._postgres.execute_sql_file(script_path)
  File "osmaxx/conversion/converters/converter_gis/helper/postgres_wrapper.py", line 27, in execute_sql_file
    return self.execute_sql_command(psql_command_file.read())
  File "osmaxx/conversion/converters/converter_gis/helper/postgres_wrapper.py", line 35, in execute_sql_command
    result = connection.execute(sqlalchemy.text(sql))