Mercurial > gemma
view schema/geonames-import/import-geonames.sql @ 1947:4235fa8f59d7
clien: pdf-gen: load logo externally; add prepare step
* Change the way how the logo to be placed in the pdf is loaded:
It can be configured in the `.env.local´ file, otherwise a placeholder
will be loaded from the static assets. The placeholder has not been
placed in `assets` because it won't be needed if a real logo has
been specified and thus should not compiled in by default.
* Add a mechanism to do asynchronous preparations before rendering.
This is needed for the completeion of the Image() loading, but it also
shows how asynchronous preparational step can be added in principle.
* Disable the start button when the current rendering is in progress.
author | Bernhard Reiter <bernhard@intevation.de> |
---|---|
date | Tue, 22 Jan 2019 10:01:08 +0100 |
parents | 74a75a5ce770 |
children | a26d2afe0c01 |
line wrap: on
line source
-- This is Free Software under GNU Affero General Public License v >= 3.0 -- without warranty, see README.md and license for details. -- SPDX-License-Identifier: AGPL-3.0-or-later -- License-Filename: LICENSES/AGPL-3.0.txt -- Copyright (C) 2018 by via donau -- – Österreichische Wasserstraßen-Gesellschaft mbH -- Software engineering by Intevation GmbH -- Author(s): -- * Sascha Wilde <wilde@intevation.de> CREATE TEMP TABLE geonames_import_tmp ( geonameid int PRIMARY KEY, name varchar(200) NOT NULL, asciiname varchar(200), alternatenames varchar(10000), lat float NOT NULL, lon float NOT NULL, feature_class char(1), feature_code varchar(10), country_code char(2), cc2 varchar(200), admin1_code varchar(20), admin2_code varchar(80), admin3_code varchar(20), admin4_code varchar(20), population text, elevation text, dem text, timezone varchar(40), modification_date timestamp ); COPY geonames_import_tmp FROM :'filename' WITH NULL ''; INSERT INTO waterway.geonames SELECT geonameid, name, asciiname, alternatenames, ST_MakePoint(lon,lat), feature_class, feature_code, country_code, cc2, admin1_code, admin2_code, admin3_code, admin4_code, population::int, elevation::int, dem::int, timezone, modification_date FROM geonames_import_tmp;