[PostNAS Suite] ALKIS NAS xml-File CRS wechseln
Der Laie
dezentech at web.de
Fr Sep 6 07:06:43 PDT 2024
Hallo Jürgen,
danke, dass ich Dir auch persönlich schreiben kann, ohne über die
PostNAS-Liste zu gehen! Dort hatte ich ja bereits am 19. Aug. auf Deinen
Post vom 22. Jul. geantwortet.
Wie gestern telefonisch besprochen, sende ich Dir anbei die
Protokoll-Datei, die das ALKIS-Import-Tool ausgibt, wenn ich das von Dir
entworfene preprocessing.d/1_transform.sql mit durchlaufen lasse. Leider
endet das Protokoll mit einer Fehlermeldung.
Auf meiner Postgis-Datenbank sind im Schema 'alkis_import' bereits
NAS-Daten mit EPSG:25833 aus Brandenburg und Mecklenburg-Vorpommern
enthalten. Nun sollen NAS-Daten mit EPSG:25832 aus Sachsen-Anhalt
hinzugefügt werden, die ohne ein vorheriges 'st_transform' mit Deinem
Trigger-Script logischerweise weiter östlich irgendwo in Polen liegen.
Es würde mich sehr freuen, wenn Du Dir das einmal angucken könntest und
mir eine Rückmeldung gibst.
Vielen Herzlichen Dank sagt
Der Micha
Am 22.07.24 um 18:17 schrieb Jürgen E. Fischer via NAS:
> Moin Micha,
>
> On Mon, 22. Jul 2024 at 17:32:34 +0200, Der Laie via NAS wrote:
>> Am 22.07.24 um 17:16 schrieb Jürgen E. Fischer via NAS:
>>> Im ALKIS-Import ist es nur nicht vorgesehen Daten aus anderen
>>> Koordinatensystemen als denen der Datenbank zu importieren.
>> Ah, verstehe, Jürgen,
>>
>> es scheint also zwei Möglichkeiten zu geben:
>>
>> 1. ALKIS-Import umbauen
>> Am 21.07.24 um 18:24 schrieb Jürgen E. Fischer via NAS:
>>> Ich würde das über einen Trigger (ähnlich wie bei "Duplikate ignorieren")
>>> regeln, der die Geometrie der Bundesländer, die vom Koordinatensystem der
>>> Datenbank abweichen darauf transformieren.
> Ein SQL-Skript preprocessing.d/1_transform.sql zu ergänzen, würde ich nicht als
> "umbauen" bezeichnen:
>
> SET search_path TO :"alkis_schema",public;
>
> CREATE OR REPLACE FUNCTION inplace_transform() RETURNS TRIGGER LANGUAGE plpgsql AS $$
> BEGIN
> IF substr(NEW.gml_id, 3, 2) IN ('BW','BY','HB','HE','HH','NI','NW','RP','SH','SL','ST','TH') THEN
> NEW.wkb_geometry := st_transform(st_setsrid(NEW.wkb_geometry, 25832), 25833);
> END IF;
> RETURN NEW;
> END;
> $$ SET search_path TO :"alkis_schema";
>
> SELECT format(E'DROP TRIGGER IF EXISTS %I ON %I.%I;\nCREATE TRIGGER %I BEFORE INSERT ON %I.%I FOR EACH ROW EXECUTE PROCEDURE inplace_transform();',
> a.table_name || '_transform', a.table_schema, a.table_name,
> a.table_name || '_transform', a.table_schema, a.table_name)
> FROM information_schema.columns a
> JOIN information_schema.columns b ON a.table_schema=b.table_schema AND a.table_name=b.table_name AND b.column_name='wkb_geometry'
> WHERE a.table_schema=:'alkis_schema'
> AND substr(a.table_name,1,3) IN ('ax_','ap_','ln_','lb_','au_','aa_')
> AND a.column_name='gml_id';
> \gexec
>
> Setzt voraus, dass die Datenbank in 25833 ist und tranformiert die Daten aus
> "anderen" Bundesländern dorthin. Getestet habe ich das allerdings nicht.
>
>> oder
>> 2. die xml-Dateien mit ogr2ogr in ein anderes CRS umzuwandeln
>
>> richtig?
>> Und meine Frage ist dann zu 2.: wie lautet der Konsolenbefehl, denn bei
>> mir hat folgender nicht geklappt:
>>
>> |ogr2ogr -f "GML"output_file.xml input_file.xml -s_srs EPSG:25832 -t_srs
>> EPSG:25833 ERROR 1: No schema information loaded Der Micha |
> So einfach geht das wahrscheinlich nicht - OGR bricht die GML-Daten ja erstmal
> auf Layer und Attribute herunter und müßte die GML-Datei daraus wieder
> aufbauen. Ich würde daher nicht erwarte, dass dabei nur die Geometrien
> verändert werden.
>
> Dafür müßte man den ogr2ogr-Aufruf in ALKIS-Import modifizieren.
>
>
> Jürgen
>
>
> _______________________________________________
> NAS mailing list
> NAS at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/nas
-------------- nächster Teil --------------
2024-09-06T14:51:58 Import-Version: unbekannt
2024-09-06T14:51:58 Datenbank-Version: PostgreSQL 15.8 (Debian 15.8-0+deb12u1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-09-06T14:51:58 PostGIS-Version: POSTGIS="3.3.2 4975da8" [EXTENSION] PGSQL="150" GEOS="3.11.1-CAPI-1.17.1" PROJ="9.1.1" LIBXML="2.9.14" LIBJSON="0.16" LIBPROTOBUF="1.4.1" WAGYU="0.5.0 (Internal)" TOPOLOGY
2024-09-06T14:51:58 Import von Client: 192.168.178.28
2024-09-06T14:51:58 > GDAL 3.6.2, released 2023/01/02|
2024-09-06T14:51:58 > psql (PostgreSQL) 16.4 (Debian 16.4-1.pgdg120+1)|
2024-09-06T14:51:58 Gesamtgröße des Imports: 1022kiB
2024-09-06T14:51:58 > Aktuelles Schema alkis_import.|
2024-09-06T14:51:58 > psql:alkis-update.sql:17170: NOTICE: ALKIS-Schema-Version: 19|
2024-09-06T14:51:58 > psql:alkis-update.sql:17170: NOTICE: ALKIS-PO-Schema-Version 4|
2024-09-06T14:51:58 > psql:postupdate.d/nas2alb.sql:101: NOTICE: ALB-Schema-Version 4|
2024-09-06T14:51:58 postupdate.d/nas2alb.sql ausgeführt.
2024-09-06T14:51:59 > Lade Signaturen...|
2024-09-06T14:52:04 preprocessing.d/0_alkis-signaturen.sql ausgeführt.
2024-09-06T14:52:04 preprocessing.d/1_ignore-duplicates.sql ausgeführt.
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_flurstueck_transform ON alkis_import.ax_flurstueck; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_flurstueck_transform BEFORE INSERT ON alkis_import.ax_flurstueck FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ap_kpo_3d_transform ON alkis_import.ap_kpo_3d; +|
2024-09-06T14:52:05 > CREATE TRIGGER ap_kpo_3d_transform BEFORE INSERT ON alkis_import.ap_kpo_3d FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ap_lpo_transform ON alkis_import.ap_lpo; +|
2024-09-06T14:52:05 > CREATE TRIGGER ap_lpo_transform BEFORE INSERT ON alkis_import.ap_lpo FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ap_lto_transform ON alkis_import.ap_lto; +|
2024-09-06T14:52:05 > CREATE TRIGGER ap_lto_transform BEFORE INSERT ON alkis_import.ap_lto FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ap_ppo_transform ON alkis_import.ap_ppo; +|
2024-09-06T14:52:05 > CREATE TRIGGER ap_ppo_transform BEFORE INSERT ON alkis_import.ap_ppo FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ap_pto_transform ON alkis_import.ap_pto; +|
2024-09-06T14:52:05 > CREATE TRIGGER ap_pto_transform BEFORE INSERT ON alkis_import.ap_pto FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS au_geometrieobjekt_3d_transform ON alkis_import.au_geometrieobjekt_3d; +|
2024-09-06T14:52:05 > CREATE TRIGGER au_geometrieobjekt_3d_transform BEFORE INSERT ON alkis_import.au_geometrieobjekt_3d FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS au_koerperobjekt_3d_transform ON alkis_import.au_koerperobjekt_3d; +|
2024-09-06T14:52:05 > CREATE TRIGGER au_koerperobjekt_3d_transform BEFORE INSERT ON alkis_import.au_koerperobjekt_3d FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS au_mehrfachflaechenobjekt_3d_transform ON alkis_import.au_mehrfachflaechenobjekt_3d; +|
2024-09-06T14:52:05 > CREATE TRIGGER au_mehrfachflaechenobjekt_3d_transform BEFORE INSERT ON alkis_import.au_mehrfachflaechenobjekt_3d FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS au_mehrfachlinienobjekt_3d_transform ON alkis_import.au_mehrfachlinienobjekt_3d; +|
2024-09-06T14:52:05 > CREATE TRIGGER au_mehrfachlinienobjekt_3d_transform BEFORE INSERT ON alkis_import.au_mehrfachlinienobjekt_3d FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ap_fpo_transform ON alkis_import.ap_fpo; +|
2024-09-06T14:52:05 > CREATE TRIGGER ap_fpo_transform BEFORE INSERT ON alkis_import.ap_fpo FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS au_umringobjekt_3d_transform ON alkis_import.au_umringobjekt_3d; +|
2024-09-06T14:52:05 > CREATE TRIGGER au_umringobjekt_3d_transform BEFORE INSERT ON alkis_import.au_umringobjekt_3d FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_abgeleitetehoehenlinie_transform ON alkis_import.ax_abgeleitetehoehenlinie; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_abgeleitetehoehenlinie_transform BEFORE INSERT ON alkis_import.ax_abgeleitetehoehenlinie FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_abschnitt_transform ON alkis_import.ax_abschnitt; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_abschnitt_transform BEFORE INSERT ON alkis_import.ax_abschnitt FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_anderefestlegungnachstrassenrecht_transform ON alkis_import.ax_anderefestlegungnachstrassenrecht; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_anderefestlegungnachstrassenrecht_transform BEFORE INSERT ON alkis_import.ax_anderefestlegungnachstrassenrecht FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_anderefestlegungnachwasserrecht_transform ON alkis_import.ax_anderefestlegungnachwasserrecht; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_anderefestlegungnachwasserrecht_transform BEFORE INSERT ON alkis_import.ax_anderefestlegungnachwasserrecht FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_ast_transform ON alkis_import.ax_ast; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_ast_transform BEFORE INSERT ON alkis_import.ax_ast FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS au_trianguliertesoberflaechenobjekt_3d_transform ON alkis_import.au_trianguliertesoberflaechenobjekt_3d; +|
2024-09-06T14:52:05 > CREATE TRIGGER au_trianguliertesoberflaechenobjekt_3d_transform BEFORE INSERT ON alkis_import.au_trianguliertesoberflaechenobjekt_3d FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_denkmalschutzrecht_transform ON alkis_import.ax_denkmalschutzrecht; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_denkmalschutzrecht_transform BEFORE INSERT ON alkis_import.ax_denkmalschutzrecht FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_forstrecht_transform ON alkis_import.ax_forstrecht; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_forstrecht_transform BEFORE INSERT ON alkis_import.ax_forstrecht FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_klassifizierungnachstrassenrecht_transform ON alkis_import.ax_klassifizierungnachstrassenrecht; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_klassifizierungnachstrassenrecht_transform BEFORE INSERT ON alkis_import.ax_klassifizierungnachstrassenrecht FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_klassifizierungnachwasserrecht_transform ON alkis_import.ax_klassifizierungnachwasserrecht; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_klassifizierungnachwasserrecht_transform BEFORE INSERT ON alkis_import.ax_klassifizierungnachwasserrecht FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_naturumweltoderbodenschutzrecht_transform ON alkis_import.ax_naturumweltoderbodenschutzrecht; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_naturumweltoderbodenschutzrecht_transform BEFORE INSERT ON alkis_import.ax_naturumweltoderbodenschutzrecht FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_sonstigesrecht_transform ON alkis_import.ax_sonstigesrecht; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_sonstigesrecht_transform BEFORE INSERT ON alkis_import.ax_sonstigesrecht FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_ausfuehrendestellen_transform ON alkis_import.ax_ausfuehrendestellen; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_ausfuehrendestellen_transform BEFORE INSERT ON alkis_import.ax_ausfuehrendestellen FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_bahnstrecke_transform ON alkis_import.ax_bahnstrecke; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_bahnstrecke_transform BEFORE INSERT ON alkis_import.ax_bahnstrecke FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_bahnverkehr_transform ON alkis_import.ax_bahnverkehr; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_bahnverkehr_transform BEFORE INSERT ON alkis_import.ax_bahnverkehr FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_bahnverkehrsanlage_transform ON alkis_import.ax_bahnverkehrsanlage; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_bahnverkehrsanlage_transform BEFORE INSERT ON alkis_import.ax_bahnverkehrsanlage FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_bauraumoderbodenordnungsrecht_transform ON alkis_import.ax_bauraumoderbodenordnungsrecht; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_bauraumoderbodenordnungsrecht_transform BEFORE INSERT ON alkis_import.ax_bauraumoderbodenordnungsrecht FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_aussparungsflaeche_transform ON alkis_import.ax_aussparungsflaeche; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_aussparungsflaeche_transform BEFORE INSERT ON alkis_import.ax_aussparungsflaeche FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_bauwerkimgewaesserbereich_transform ON alkis_import.ax_bauwerkimgewaesserbereich; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_bauwerkimgewaesserbereich_transform BEFORE INSERT ON alkis_import.ax_bauwerkimgewaesserbereich FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_bauwerkimverkehrsbereich_transform ON alkis_import.ax_bauwerkimverkehrsbereich; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_bauwerkimverkehrsbereich_transform BEFORE INSERT ON alkis_import.ax_bauwerkimverkehrsbereich FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_bauwerkoderanlagefuerindustrieundgewerbe_transform ON alkis_import.ax_bauwerkoderanlagefuerindustrieundgewerbe; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_bauwerkoderanlagefuerindustrieundgewerbe_transform BEFORE INSERT ON alkis_import.ax_bauwerkoderanlagefuerindustrieundgewerbe FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_bauwerkoderanlagefuersportfreizeitunderholung_transform ON alkis_import.ax_bauwerkoderanlagefuersportfreizeitunderholung; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_bauwerkoderanlagefuersportfreizeitunderholung_transform BEFORE INSERT ON alkis_import.ax_bauwerkoderanlagefuersportfreizeitunderholung FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_bergbaubetrieb_transform ON alkis_import.ax_bergbaubetrieb; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_bergbaubetrieb_transform BEFORE INSERT ON alkis_import.ax_bergbaubetrieb FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_baublock_transform ON alkis_import.ax_baublock; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_baublock_transform BEFORE INSERT ON alkis_import.ax_baublock FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_bauteil_transform ON alkis_import.ax_bauteil; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_bauteil_transform BEFORE INSERT ON alkis_import.ax_bauteil FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_besondererhoehenpunkt_transform ON alkis_import.ax_besondererhoehenpunkt; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_besondererhoehenpunkt_transform BEFORE INSERT ON alkis_import.ax_besondererhoehenpunkt FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_bewertung_transform ON alkis_import.ax_bewertung; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_bewertung_transform BEFORE INSERT ON alkis_import.ax_bewertung FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_bodenschaetzung_transform ON alkis_import.ax_bodenschaetzung; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_bodenschaetzung_transform BEFORE INSERT ON alkis_import.ax_bodenschaetzung FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_boeschungsflaeche_transform ON alkis_import.ax_boeschungsflaeche; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_boeschungsflaeche_transform BEFORE INSERT ON alkis_import.ax_boeschungsflaeche FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_besondereflurstuecksgrenze_transform ON alkis_import.ax_besondereflurstuecksgrenze; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_besondereflurstuecksgrenze_transform BEFORE INSERT ON alkis_import.ax_besondereflurstuecksgrenze FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_besonderegebaeudelinie_transform ON alkis_import.ax_besonderegebaeudelinie; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_besonderegebaeudelinie_transform BEFORE INSERT ON alkis_import.ax_besonderegebaeudelinie FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_duene_transform ON alkis_import.ax_duene; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_duene_transform BEFORE INSERT ON alkis_import.ax_duene FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_einrichtungenfuerdenschiffsverkehr_transform ON alkis_import.ax_einrichtungenfuerdenschiffsverkehr; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_einrichtungenfuerdenschiffsverkehr_transform BEFORE INSERT ON alkis_import.ax_einrichtungenfuerdenschiffsverkehr FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_einrichtunginoeffentlichenbereichen_transform ON alkis_import.ax_einrichtunginoeffentlichenbereichen; +|
2024-09-06T14:52:05 > CREATE TRIGGER ax_einrichtunginoeffentlichenbereichen_transform BEFORE INSERT ON alkis_import.ax_einrichtunginoeffentlichenbereichen FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:05 > DROP TRIGGER IF EXISTS ax_dammwalldeich_transform ON alkis_import.ax_dammwalldeich; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_dammwalldeich_transform BEFORE INSERT ON alkis_import.ax_dammwalldeich FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_fahrwegachse_transform ON alkis_import.ax_fahrwegachse; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_fahrwegachse_transform BEFORE INSERT ON alkis_import.ax_fahrwegachse FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_felsenfelsblockfelsnadel_transform ON alkis_import.ax_felsenfelsblockfelsnadel; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_felsenfelsblockfelsnadel_transform BEFORE INSERT ON alkis_import.ax_felsenfelsblockfelsnadel FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_firstlinie_transform ON alkis_import.ax_firstlinie; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_firstlinie_transform BEFORE INSERT ON alkis_import.ax_firstlinie FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_flaechebesondererfunktionalerpraegung_transform ON alkis_import.ax_flaechebesondererfunktionalerpraegung; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_flaechebesondererfunktionalerpraegung_transform BEFORE INSERT ON alkis_import.ax_flaechebesondererfunktionalerpraegung FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_flaechegemischternutzung_transform ON alkis_import.ax_flaechegemischternutzung; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_flaechegemischternutzung_transform BEFORE INSERT ON alkis_import.ax_flaechegemischternutzung FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_flaechezurzeitunbestimmbar_transform ON alkis_import.ax_flaechezurzeitunbestimmbar; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_flaechezurzeitunbestimmbar_transform BEFORE INSERT ON alkis_import.ax_flaechezurzeitunbestimmbar FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_fliessgewaesser_transform ON alkis_import.ax_fliessgewaesser; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_fliessgewaesser_transform BEFORE INSERT ON alkis_import.ax_fliessgewaesser FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_flugverkehr_transform ON alkis_import.ax_flugverkehr; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_flugverkehr_transform BEFORE INSERT ON alkis_import.ax_flugverkehr FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_flugverkehrsanlage_transform ON alkis_import.ax_flugverkehrsanlage; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_flugverkehrsanlage_transform BEFORE INSERT ON alkis_import.ax_flugverkehrsanlage FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_einschnitt_transform ON alkis_import.ax_einschnitt; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_einschnitt_transform BEFORE INSERT ON alkis_import.ax_einschnitt FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_fahrbahnachse_transform ON alkis_import.ax_fahrbahnachse; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_fahrbahnachse_transform BEFORE INSERT ON alkis_import.ax_fahrbahnachse FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_gebaeude_transform ON alkis_import.ax_gebaeude; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_gebaeude_transform BEFORE INSERT ON alkis_import.ax_gebaeude FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_gebaeudeausgestaltung_transform ON alkis_import.ax_gebaeudeausgestaltung; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_gebaeudeausgestaltung_transform BEFORE INSERT ON alkis_import.ax_gebaeudeausgestaltung FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_gebiet_bundesland_transform ON alkis_import.ax_gebiet_bundesland; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_gebiet_bundesland_transform BEFORE INSERT ON alkis_import.ax_gebiet_bundesland FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_gebiet_kreis_transform ON alkis_import.ax_gebiet_kreis; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_gebiet_kreis_transform BEFORE INSERT ON alkis_import.ax_gebiet_kreis FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_friedhof_transform ON alkis_import.ax_friedhof; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_friedhof_transform BEFORE INSERT ON alkis_import.ax_friedhof FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_gebiet_verwaltungsgemeinschaft_transform ON alkis_import.ax_gebiet_verwaltungsgemeinschaft; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_gebiet_verwaltungsgemeinschaft_transform BEFORE INSERT ON alkis_import.ax_gebiet_verwaltungsgemeinschaft FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_gebietsgrenze_transform ON alkis_import.ax_gebietsgrenze; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_gebietsgrenze_transform BEFORE INSERT ON alkis_import.ax_gebietsgrenze FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_gehoelz_transform ON alkis_import.ax_gehoelz; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_gehoelz_transform BEFORE INSERT ON alkis_import.ax_gehoelz FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_gelaendekante_transform ON alkis_import.ax_gelaendekante; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_gelaendekante_transform BEFORE INSERT ON alkis_import.ax_gelaendekante FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_georeferenziertegebaeudeadresse_transform ON alkis_import.ax_georeferenziertegebaeudeadresse; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_georeferenziertegebaeudeadresse_transform BEFORE INSERT ON alkis_import.ax_georeferenziertegebaeudeadresse FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_gebiet_nationalstaat_transform ON alkis_import.ax_gebiet_nationalstaat; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_gebiet_nationalstaat_transform BEFORE INSERT ON alkis_import.ax_gebiet_nationalstaat FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_gebiet_regierungsbezirk_transform ON alkis_import.ax_gebiet_regierungsbezirk; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_gebiet_regierungsbezirk_transform BEFORE INSERT ON alkis_import.ax_gebiet_regierungsbezirk FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_gewaesserbegrenzung_transform ON alkis_import.ax_gewaesserbegrenzung; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_gewaesserbegrenzung_transform BEFORE INSERT ON alkis_import.ax_gewaesserbegrenzung FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_gewaessermerkmal_transform ON alkis_import.ax_gewaessermerkmal; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_gewaessermerkmal_transform BEFORE INSERT ON alkis_import.ax_gewaessermerkmal FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_gewaesserstationierungsachse_transform ON alkis_import.ax_gewaesserstationierungsachse; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_gewaesserstationierungsachse_transform BEFORE INSERT ON alkis_import.ax_gewaesserstationierungsachse FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_gewann_transform ON alkis_import.ax_gewann; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_gewann_transform BEFORE INSERT ON alkis_import.ax_gewann FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_gleis_transform ON alkis_import.ax_gleis; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_gleis_transform BEFORE INSERT ON alkis_import.ax_gleis FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_grablochderbodenschaetzung_transform ON alkis_import.ax_grablochderbodenschaetzung; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_grablochderbodenschaetzung_transform BEFORE INSERT ON alkis_import.ax_grablochderbodenschaetzung FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_grenzuebergang_transform ON alkis_import.ax_grenzuebergang; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_grenzuebergang_transform BEFORE INSERT ON alkis_import.ax_grenzuebergang FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_hafen_transform ON alkis_import.ax_hafen; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_hafen_transform BEFORE INSERT ON alkis_import.ax_hafen FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_geripplinie_transform ON alkis_import.ax_geripplinie; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_geripplinie_transform BEFORE INSERT ON alkis_import.ax_geripplinie FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_gewaesserachse_transform ON alkis_import.ax_gewaesserachse; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_gewaesserachse_transform BEFORE INSERT ON alkis_import.ax_gewaesserachse FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_heide_transform ON alkis_import.ax_heide; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_heide_transform BEFORE INSERT ON alkis_import.ax_heide FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_heilquellegasquelle_transform ON alkis_import.ax_heilquellegasquelle; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_heilquellegasquelle_transform BEFORE INSERT ON alkis_import.ax_heilquellegasquelle FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_historischesbauwerkoderhistorischeeinrichtung_transform ON alkis_import.ax_historischesbauwerkoderhistorischeeinrichtung; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_historischesbauwerkoderhistorischeeinrichtung_transform BEFORE INSERT ON alkis_import.ax_historischesbauwerkoderhistorischeeinrichtung FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_historischesflurstueck_transform ON alkis_import.ax_historischesflurstueck; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_historischesflurstueck_transform BEFORE INSERT ON alkis_import.ax_historischesflurstueck FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_hoehenlinie_transform ON alkis_import.ax_hoehenlinie; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_hoehenlinie_transform BEFORE INSERT ON alkis_import.ax_hoehenlinie FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_hoehleneingang_transform ON alkis_import.ax_hoehleneingang; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_hoehleneingang_transform BEFORE INSERT ON alkis_import.ax_hoehleneingang FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_hafenbecken_transform ON alkis_import.ax_hafenbecken; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_hafenbecken_transform BEFORE INSERT ON alkis_import.ax_hafenbecken FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_halde_transform ON alkis_import.ax_halde; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_halde_transform BEFORE INSERT ON alkis_import.ax_halde FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_kleinraeumigerlandschaftsteil_transform ON alkis_import.ax_kleinraeumigerlandschaftsteil; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_kleinraeumigerlandschaftsteil_transform BEFORE INSERT ON alkis_import.ax_kleinraeumigerlandschaftsteil FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_klassifizierung_transform ON alkis_import.ax_klassifizierung; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_klassifizierung_transform BEFORE INSERT ON alkis_import.ax_klassifizierung FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_kommunalesgebiet_transform ON alkis_import.ax_kommunalesgebiet; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_kommunalesgebiet_transform BEFORE INSERT ON alkis_import.ax_kommunalesgebiet FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_kondominium_transform ON alkis_import.ax_kondominium; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_kondominium_transform BEFORE INSERT ON alkis_import.ax_kondominium FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_insel_transform ON alkis_import.ax_insel; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_insel_transform BEFORE INSERT ON alkis_import.ax_insel FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_landwirtschaft_transform ON alkis_import.ax_landwirtschaft; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_landwirtschaft_transform BEFORE INSERT ON alkis_import.ax_landwirtschaft FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_leitung_transform ON alkis_import.ax_leitung; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_leitung_transform BEFORE INSERT ON alkis_import.ax_leitung FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_markantergelaendepunkt_transform ON alkis_import.ax_markantergelaendepunkt; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_markantergelaendepunkt_transform BEFORE INSERT ON alkis_import.ax_markantergelaendepunkt FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_meer_transform ON alkis_import.ax_meer; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_meer_transform BEFORE INSERT ON alkis_import.ax_meer FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_musterlandesmusterundvergleichsstueck_transform ON alkis_import.ax_musterlandesmusterundvergleichsstueck; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_musterlandesmusterundvergleichsstueck_transform BEFORE INSERT ON alkis_import.ax_musterlandesmusterundvergleichsstueck FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_nullpunkt_transform ON alkis_import.ax_nullpunkt; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_nullpunkt_transform BEFORE INSERT ON alkis_import.ax_nullpunkt FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_ortslage_transform ON alkis_import.ax_ortslage; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_ortslage_transform BEFORE INSERT ON alkis_import.ax_ortslage FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_platz_transform ON alkis_import.ax_platz; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_platz_transform BEFORE INSERT ON alkis_import.ax_platz FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_polder_transform ON alkis_import.ax_polder; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_polder_transform BEFORE INSERT ON alkis_import.ax_polder FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_punktortau_transform ON alkis_import.ax_punktortau; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_punktortau_transform BEFORE INSERT ON alkis_import.ax_punktortau FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_punktortta_transform ON alkis_import.ax_punktortta; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_punktortta_transform BEFORE INSERT ON alkis_import.ax_punktortta FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_schifffahrtsliniefaehrverkehr_transform ON alkis_import.ax_schifffahrtsliniefaehrverkehr; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_schifffahrtsliniefaehrverkehr_transform BEFORE INSERT ON alkis_import.ax_schifffahrtsliniefaehrverkehr FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_schiffsverkehr_transform ON alkis_import.ax_schiffsverkehr; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_schiffsverkehr_transform BEFORE INSERT ON alkis_import.ax_schiffsverkehr FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_punktortag_transform ON alkis_import.ax_punktortag; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_punktortag_transform BEFORE INSERT ON alkis_import.ax_punktortag FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_seilbahnschwebebahn_transform ON alkis_import.ax_seilbahnschwebebahn; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_seilbahnschwebebahn_transform BEFORE INSERT ON alkis_import.ax_seilbahnschwebebahn FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_sickerstrecke_transform ON alkis_import.ax_sickerstrecke; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_sickerstrecke_transform BEFORE INSERT ON alkis_import.ax_sickerstrecke FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_siedlungsflaeche_transform ON alkis_import.ax_siedlungsflaeche; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_siedlungsflaeche_transform BEFORE INSERT ON alkis_import.ax_siedlungsflaeche FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_schleuse_transform ON alkis_import.ax_schleuse; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_schleuse_transform BEFORE INSERT ON alkis_import.ax_schleuse FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_schutzzone_transform ON alkis_import.ax_schutzzone; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_schutzzone_transform BEFORE INSERT ON alkis_import.ax_schutzzone FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_sportfreizeitunderholungsflaeche_transform ON alkis_import.ax_sportfreizeitunderholungsflaeche; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_sportfreizeitunderholungsflaeche_transform BEFORE INSERT ON alkis_import.ax_sportfreizeitunderholungsflaeche FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_stehendesgewaesser_transform ON alkis_import.ax_stehendesgewaesser; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_stehendesgewaesser_transform BEFORE INSERT ON alkis_import.ax_stehendesgewaesser FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_strassenachse_transform ON alkis_import.ax_strassenachse; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_strassenachse_transform BEFORE INSERT ON alkis_import.ax_strassenachse FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_strassenverkehr_transform ON alkis_import.ax_strassenverkehr; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_strassenverkehr_transform BEFORE INSERT ON alkis_import.ax_strassenverkehr FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_strassenverkehrsanlage_transform ON alkis_import.ax_strassenverkehrsanlage; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_strassenverkehrsanlage_transform BEFORE INSERT ON alkis_import.ax_strassenverkehrsanlage FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_strukturierterfasstegelaendepunkte_transform ON alkis_import.ax_strukturierterfasstegelaendepunkte; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_strukturierterfasstegelaendepunkte_transform BEFORE INSERT ON alkis_import.ax_strukturierterfasstegelaendepunkte FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_sumpf_transform ON alkis_import.ax_sumpf; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_sumpf_transform BEFORE INSERT ON alkis_import.ax_sumpf FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_soll_transform ON alkis_import.ax_soll; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_soll_transform BEFORE INSERT ON alkis_import.ax_soll FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:06 > DROP TRIGGER IF EXISTS ax_sonstigesbauwerkodersonstigeeinrichtung_transform ON alkis_import.ax_sonstigesbauwerkodersonstigeeinrichtung; +|
2024-09-06T14:52:06 > CREATE TRIGGER ax_sonstigesbauwerkodersonstigeeinrichtung_transform BEFORE INSERT ON alkis_import.ax_sonstigesbauwerkodersonstigeeinrichtung FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS ax_testgelaende_transform ON alkis_import.ax_testgelaende; +|
2024-09-06T14:52:07 > CREATE TRIGGER ax_testgelaende_transform BEFORE INSERT ON alkis_import.ax_testgelaende FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS ax_untergeordnetesgewaesser_transform ON alkis_import.ax_untergeordnetesgewaesser; +|
2024-09-06T14:52:07 > CREATE TRIGGER ax_untergeordnetesgewaesser_transform BEFORE INSERT ON alkis_import.ax_untergeordnetesgewaesser FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS ax_weg_transform ON alkis_import.ax_weg; +|
2024-09-06T14:52:07 > CREATE TRIGGER ax_weg_transform BEFORE INSERT ON alkis_import.ax_weg FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS ax_wohnbauflaeche_transform ON alkis_import.ax_wohnbauflaeche; +|
2024-09-06T14:52:07 > CREATE TRIGGER ax_wohnbauflaeche_transform BEFORE INSERT ON alkis_import.ax_wohnbauflaeche FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS ax_tatsaechlichenutzung_transform ON alkis_import.ax_tatsaechlichenutzung; +|
2024-09-06T14:52:07 > CREATE TRIGGER ax_tatsaechlichenutzung_transform BEFORE INSERT ON alkis_import.ax_tatsaechlichenutzung FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS ax_topographischelinie_transform ON alkis_import.ax_topographischelinie; +|
2024-09-06T14:52:07 > CREATE TRIGGER ax_topographischelinie_transform BEFORE INSERT ON alkis_import.ax_topographischelinie FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS ax_transportanlage_transform ON alkis_import.ax_transportanlage; +|
2024-09-06T14:52:07 > CREATE TRIGGER ax_transportanlage_transform BEFORE INSERT ON alkis_import.ax_transportanlage FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS ax_turm_transform ON alkis_import.ax_turm; +|
2024-09-06T14:52:07 > CREATE TRIGGER ax_turm_transform BEFORE INSERT ON alkis_import.ax_turm FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS ax_unlandvegetationsloseflaeche_transform ON alkis_import.ax_unlandvegetationsloseflaeche; +|
2024-09-06T14:52:07 > CREATE TRIGGER ax_unlandvegetationsloseflaeche_transform BEFORE INSERT ON alkis_import.ax_unlandvegetationsloseflaeche FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS ax_wald_transform ON alkis_import.ax_wald; +|
2024-09-06T14:52:07 > CREATE TRIGGER ax_wald_transform BEFORE INSERT ON alkis_import.ax_wald FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS ax_tagebaugrubesteinbruch_transform ON alkis_import.ax_tagebaugrubesteinbruch; +|
2024-09-06T14:52:07 > CREATE TRIGGER ax_tagebaugrubesteinbruch_transform BEFORE INSERT ON alkis_import.ax_tagebaugrubesteinbruch FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS ax_tagesabschnitt_transform ON alkis_import.ax_tagesabschnitt; +|
2024-09-06T14:52:07 > CREATE TRIGGER ax_tagesabschnitt_transform BEFORE INSERT ON alkis_import.ax_tagesabschnitt FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS ax_wasserspiegelhoehe_transform ON alkis_import.ax_wasserspiegelhoehe; +|
2024-09-06T14:52:07 > CREATE TRIGGER ax_wasserspiegelhoehe_transform BEFORE INSERT ON alkis_import.ax_wasserspiegelhoehe FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS ax_wegpfadsteig_transform ON alkis_import.ax_wegpfadsteig; +|
2024-09-06T14:52:07 > CREATE TRIGGER ax_wegpfadsteig_transform BEFORE INSERT ON alkis_import.ax_wegpfadsteig FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS ax_vorratsbehaelterspeicherbauwerk_transform ON alkis_import.ax_vorratsbehaelterspeicherbauwerk; +|
2024-09-06T14:52:07 > CREATE TRIGGER ax_vorratsbehaelterspeicherbauwerk_transform BEFORE INSERT ON alkis_import.ax_vorratsbehaelterspeicherbauwerk FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS ax_wohnplatz_transform ON alkis_import.ax_wohnplatz; +|
2024-09-06T14:52:07 > CREATE TRIGGER ax_wohnplatz_transform BEFORE INSERT ON alkis_import.ax_wohnplatz FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS aa_antragsgebiet_transform ON alkis_import.aa_antragsgebiet; +|
2024-09-06T14:52:07 > CREATE TRIGGER aa_antragsgebiet_transform BEFORE INSERT ON alkis_import.aa_antragsgebiet FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS au_punkthaufenobjekt_3d_transform ON alkis_import.au_punkthaufenobjekt_3d; +|
2024-09-06T14:52:07 > CREATE TRIGGER au_punkthaufenobjekt_3d_transform BEFORE INSERT ON alkis_import.au_punkthaufenobjekt_3d FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS ax_industrieundgewerbeflaeche_transform ON alkis_import.ax_industrieundgewerbeflaeche; +|
2024-09-06T14:52:07 > CREATE TRIGGER ax_industrieundgewerbeflaeche_transform BEFORE INSERT ON alkis_import.ax_industrieundgewerbeflaeche FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS ax_landschaft_transform ON alkis_import.ax_landschaft; +|
2024-09-06T14:52:07 > CREATE TRIGGER ax_landschaft_transform BEFORE INSERT ON alkis_import.ax_landschaft FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS ax_moor_transform ON alkis_import.ax_moor; +|
2024-09-06T14:52:07 > CREATE TRIGGER ax_moor_transform BEFORE INSERT ON alkis_import.ax_moor FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > DROP TRIGGER IF EXISTS ax_vegetationsmerkmal_transform ON alkis_import.ax_vegetationsmerkmal; +|
2024-09-06T14:52:07 > CREATE TRIGGER ax_vegetationsmerkmal_transform BEFORE INSERT ON alkis_import.ax_vegetationsmerkmal FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > psql:preprocessing.d/1_transform.sql:23: NOTICE: trigger "ax_ausfuehrendestellen_transform" for relation "alkis_import.ax_ausfuehrendestellen" does not exist, skipping|
2024-09-06T14:52:07 > psql:preprocessing.d/1_transform.sql:23: ERROR: "ax_ausfuehrendestellen" is a view|
2024-09-06T14:52:07 > DETAIL: Views cannot have row-level BEFORE or AFTER triggers.|
2024-09-06T14:52:07 > psql:preprocessing.d/1_transform.sql:23: ANWEISUNG: DROP TRIGGER IF EXISTS ax_ausfuehrendestellen_transform ON alkis_import.ax_ausfuehrendestellen;|
2024-09-06T14:52:07 > CREATE TRIGGER ax_ausfuehrendestellen_transform BEFORE INSERT ON alkis_import.ax_ausfuehrendestellen FOR EACH ROW EXECUTE PROCEDURE inplace_transform();|
2024-09-06T14:52:07 > psql:preprocessing.d/1_transform.sql:23: ANWEISUNG: SELECT format(E'DROP TRIGGER IF EXISTS %I ON %I.%I;\nCREATE TRIGGER %I BEFORE INSERT ON %I.%I FOR EACH ROW EXECUTE PROCEDURE inplace_transform();',|
2024-09-06T14:52:07 > a.table_name || '_transform', a.table_schema, a.table_name,|
2024-09-06T14:52:07 > a.table_name || '_transform', a.table_schema, a.table_name)|
2024-09-06T14:52:07 > FROM information_schema.columns a|
2024-09-06T14:52:07 > JOIN information_schema.columns b ON a.table_schema=b.table_schema AND a.table_name=b.table_name AND b.column_name='wkb_geometry'|
2024-09-06T14:52:07 > WHERE a.table_schema='alkis_import'|
2024-09-06T14:52:07 > AND substr(a.table_name,1,3) IN ('ax_','ap_','ln_','lb_','au_','aa_')|
2024-09-06T14:52:07 > AND a.column_name='gml_id';|
2024-09-06T14:52:07 Fehler bei Prozeß: 3
2024-09-06T14:52:07 preprocessing.d/1_transform.sql gescheitert.
2024-09-06T14:52:07 Preprocessing schlug fehl.
Mehr Informationen über die Mailingliste NAS