#
# ChangeLog for trunk/import/sichten.sql
# 
# Generated by Trac 0.12.3
# 06/02/24 02:22:37
 
Tue, 01 Mar 2016 15:53:57 GMT frank.jaeger [363]
	* trunk/import/sichten.sql (modified)

	Neuer View zur Fehlersuche in räumlich begrenzten NBA-Verfahren


Fri, 27 Mar 2015 12:18:38 GMT frank.jaeger [353]
	* trunk/import/alkis_PostNAS_schema.sql (modified)
	* trunk/import/datenbank_anlegen.sh (modified)
	* trunk/import/grant.sql (modified)
	* trunk/import/konv_batch.sh (modified)
	* trunk/import/nutzungsart_definition.sql (modified)
	* trunk/import/pp_praesentation_action.sql (modified)
	* trunk/import/sichten.sql (modified)
	* trunk/import/zip_ordner.sh (modified)
	* trunk/import/zipaus_ordner.sh (added)

	kleine Verbesserungen am Post-Processing


Tue, 30 Sep 2014 14:42:55 GMT frank.jaeger [339]
	* trunk/import/alkis_PostNAS_keytables.sql (modified)
	* trunk/import/keytable_umbenennung_2014-09.sql (added)
	* trunk/import/pp_laden.sql (modified)
	* trunk/import/sichten.sql (modified)
	* trunk/import/sichten_wms.sql (modified)
	* trunk/import/staedtische_FS_aus_ALKIS_rlp.sql (modified)
	* trunk/info/info/alkis/alkisausk.php (modified)
	* trunk/info/info/alkis/alkisbaurecht.php (modified)
	* trunk/info/info/alkis/alkisbestnw.php (modified)
	* trunk/info/info/alkis/alkisexport.php (modified)
	* trunk/info/info/alkis/alkisfkt.php (modified)
	* trunk/info/info/alkis/alkisfsnw.php (modified)
	* trunk/info/info/alkis/alkisgebaeudenw.php (modified)
	* trunk/info/info/alkis/alkishaus.php (modified)
	* trunk/info/info/alkis/alkisinlayausk.php (modified)
	* trunk/info/info/alkis/alkisinlaybaurecht.php (modified)
	* trunk/info/info/alkis/alkislage.php (modified)
	* trunk/info/info/alkis/alkisnamstruk.php (modified)
	* trunk/info/info/alkis/alkisrelationen.php (modified)
	* trunk/info/info/alkis/alkisstrasse.php (modified)
	* trunk/mapbender/http/nav/alkisnav_adr.php (modified)
	* trunk/mapbender/http/nav/alkisnav_eig.php (modified)
	* trunk/mapbender/http/nav/alkisnav_fkt.php (modified)
	* trunk/mapbender/http/nav/alkisnav_grd.php (modified)

	Rückbau von "substring(gml_id)" in Views und Programmen.
	Namensänderung ...


Fri, 26 Sep 2014 11:23:28 GMT frank.jaeger [338]
	* trunk/import/alkis-functions.sql (modified)
	* trunk/import/alkis_PostNAS_keytables.sql (modified)
	* trunk/import/alkis_PostNAS_schema.sql (modified)
	* trunk/import/konv_batch.sh (modified)
	* trunk/import/sichten.sql (modified)
	* trunk/import/von_hist_nach_kill.sql (added)

	Neuer Trigger ohne Historie. Anzahl Kontext-Operationen in import- ...


Mon, 22 Sep 2014 09:13:16 GMT frank.jaeger [337]
	* trunk/import/sichten.sql (modified)

	Sichten zur Suche nach Fehlern aus einem Historie-Trigger


Fri, 19 Sep 2014 11:52:07 GMT frank.jaeger [336]
	* trunk/import/alkis-functions.sql (modified)
	* trunk/import/alkis_PostNAS_schema.sql (modified)
	* trunk/import/konv_batch.sh (modified)
	* trunk/import/pp_laden.sql (modified)
	* trunk/import/sichten.sql (modified)
	* trunk/info/info/alkis/alkisstrasse.php (modified)

	Schema zurück auf 16stellige gml_id.
	Überarbeiten Trigger-Funktion ...


Fri, 12 Sep 2014 12:07:11 GMT frank.jaeger [332]
	* trunk/import/alkis_PostNAS_schema.sql (modified)
	* trunk/import/patch_2014-09-12.sql (added)
	* trunk/import/pp_definition.sql (modified)
	* trunk/import/sichten.sql (modified)
	* trunk/info/info/alkis/alkisbestnw.php (modified)
	* trunk/info/info/alkis/alkisfkt.php (modified)

	Zwischen-Stand vor Wochenende


Thu, 11 Sep 2014 15:23:54 GMT frank.jaeger [331]
	* trunk/import/alkis-functions.sql (modified)
	* trunk/import/alkis-trigger-hist.sql (modified)
	* trunk/import/alkis_PostNAS_schema.sql (modified)
	* trunk/import/konv_batch.sh (modified)
	* trunk/import/sichten.sql (modified)
	* trunk/import/umschalten_trigger_historie.sh (added)
	* trunk/import/umschalten_trigger_kill.sh (added)
	* trunk/mapbender/conf/alkisnav_conf.php (modified)

	Kleinere Korrekturen an den Import-Scripten.


Wed, 10 Sep 2014 10:08:18 GMT frank.jaeger [330]
	* trunk/import/alkis-functions.sql (modified)
	* trunk/import/alkis-trigger-kill.sql (modified)
	* trunk/import/alkis_PostNAS_schema.sql (modified)
	* trunk/import/alkis_PostNAS_schema_ohneHist.sql (modified)
	* trunk/import/alkis_db_patch_2014-08.sql (deleted)
	* trunk/import/datenbank_anlegen.sh (modified)
	* trunk/import/grant.sql (modified)
	* trunk/import/konv_batch.sh (modified)
	* trunk/import/konv_nachverarbeitung.sh (added)
	* trunk/import/nutzungsart_definition.sql (modified)
	* trunk/import/ordner_konvertieren.sh (modified)
	* trunk/import/pp_definition.sql (modified)
	* trunk/import/pp_laden.sql (modified)
	* trunk/import/pp_praesentation_action.sql (modified)
	* trunk/import/sichten.sql (modified)
	* trunk/import/sichten_wms.sql (modified)
	* trunk/import/staedtische_FS_aus_ALKIS_rlp.sql (modified)
	* trunk/info/conf/alkis_www_conf.php (modified)
	* trunk/info/info/alkis/alkisausk.php (modified)
	* trunk/info/info/alkis/alkisauszug.css (modified)
	* trunk/info/info/alkis/alkisbaurecht.php (modified)
	* trunk/info/info/alkis/alkisbestnw.php (modified)
	* trunk/info/info/alkis/alkisexport.php (modified)
	* trunk/info/info/alkis/alkisfkt.php (modified)
	* trunk/info/info/alkis/alkisfshist.php (modified)
	* trunk/info/info/alkis/alkisfsnw.php (modified)
	* trunk/info/info/alkis/alkisgebaeudenw.php (modified)
	* trunk/info/info/alkis/alkishaus.php (modified)
	* trunk/info/info/alkis/alkisinlayausk.php (modified)
	* trunk/info/info/alkis/alkisinlaybaurecht.php (modified)
	* trunk/info/info/alkis/alkislage.php (modified)
	* trunk/info/info/alkis/alkisnamstruk.php (modified)
	* trunk/info/info/alkis/alkisrelationen.php (modified)
	* trunk/info/info/alkis/alkisstrasse.php (modified)
	* trunk/mapbender/conf/alkisnav_conf.php (modified)
	* trunk/mapbender/http/nav/alkisnav_adr.php (modified)
	* trunk/mapbender/http/nav/alkisnav_eig.php (modified)
	* trunk/mapbender/http/nav/alkisnav_fkt.php (modified)
	* trunk/mapbender/http/nav/alkisnav_fls.php (modified)
	* trunk/mapbender/http/nav/alkisnav_grd.php (modified)
	* trunk/umn/alkis/alkis_muster.map (modified)
	* trunk/umn/alkis/alkis_muster_4.map (modified)
	* trunk/umn/alkis/alkis_muster_entw.map (modified)
	* trunk/umn/alkis/alkis_muster_entw_4.map (modified)

	Umstellung von PostNAS 0.7 auf PostNAS 0.8, ohne Tabelle ...


Tue, 09 Sep 2014 06:15:55 GMT frank.jaeger [328]
	* trunk/import/datenbank_anlegen.sh (modified)
	* trunk/import/grant.sql (modified)
	* trunk/import/konv_batch.sh (modified)
	* trunk/import/pp_definition.sql (modified)
	* trunk/import/sichten.sql (modified)
	* trunk/import/sichten_wms.sql (modified)

	Letzte kleine Korrekturen an Import für PostNAS Version 0.7 vor
	Wechsel ...


Wed, 30 Jul 2014 13:33:34 GMT astrid.emde [320]
	* trunk/import/grant.sql (modified)
	* trunk/import/sichten.sql (modified)

	GRANT auskommentiert und in grant.sql uebertragen


Thu, 06 Feb 2014 15:40:10 GMT frank.jaeger [315]
	* trunk/import/pp_laden.sql (modified)
	* trunk/import/sichten.sql (modified)
	* trunk/info/info/alkis/alkisbestnw.php (modified)
	* trunk/info/info/alkis/alkisfkt.php (modified)
	* trunk/info/info/alkis/alkisfshist.php (modified)
	* trunk/info/info/alkis/alkisfsnw.php (modified)
	* trunk/info/info/alkis/alkisgebaeudenw.php (modified)
	* trunk/info/info/alkis/alkishaus.php (modified)
	* trunk/info/info/alkis/alkisnamstruk.php (modified)
	* trunk/info/info/alkis/alkisstrasse.php (modified)
	* trunk/mapbender/http/nav/alkisnav.css (modified)
	* trunk/mapbender/http/nav/alkisnav_eig.php (modified)
	* trunk/mapbender/http/nav/alkisnav_fkt.php (modified)
	* trunk/mapbender/http/nav/img/tab_bg_grau.gif (modified)
	* trunk/mapbender/http/nav/img/tab_bg_grau_dezent.gif (added)
	* trunk/mapbender/http/nav/img/tab_bg_rot.gif (modified)
	* trunk/mapbender/http/nav/img/tab_bg_rot_dezent.gif (added)

	Feinschliff und Korrektur an Auskunft und Navigation


Mon, 03 Feb 2014 17:41:17 GMT frank.jaeger [314]
	* trunk/import/alkis-functions.sql (modified)
	* trunk/import/alkis-trigger-kill.sql (modified)
	* trunk/import/alkis_PostNAS_schema.sql (modified)
	* trunk/import/alkis_PostNAS_schema_ohneHist.sql (added)
	* trunk/import/datenbank_anlegen.sh (modified)
	* trunk/import/konv_batch.sh (modified)
	* trunk/import/nutzungsart_definition.sql (modified)
	* trunk/import/sichten.sql (modified)

	Trigger ohne Historie (kill) umgestellt auf Import-ID als Merkmal
	fuer ...


Wed, 29 Jan 2014 10:40:29 GMT frank.jaeger [311]
	* trunk/import/sichten.sql (modified)

	2 neue Views zur Fehlersuche Straßenname als Gewannenbezeichnung


Mon, 27 Jan 2014 16:55:54 GMT frank.jaeger [308]
	* trunk/import/sichten.sql (modified)
	* trunk/info/info/alkis/alkisauszug.css (modified)
	* trunk/info/info/alkis/alkisexport.php (modified)
	* trunk/info/info/alkis/alkisstrasse.php (modified)

	CSV-Export aller Flurstücke an einer Straße.


Tue, 21 Jan 2014 16:14:52 GMT frank.jaeger [305]
	* trunk/import/sichten.sql (modified)
	* trunk/info/info/alkis/alkisexport.php (modified)

	Verbesserung CSV-Export: Rechtsgemeinschaft in Namenszeile.


Mon, 20 Jan 2014 13:51:46 GMT frank.jaeger [303]
	* trunk/import/sichten.sql (modified)
	* trunk/info/info/alkis/alkisexport.php (modified)




Fri, 17 Jan 2014 08:51:00 GMT frank.jaeger [301]
	* trunk/import/sichten.sql (modified)
	* trunk/info/info/alkis/alkisbestnw.php (modified)
	* trunk/info/info/alkis/alkisexport.php (added)
	* trunk/info/info/alkis/alkisfsexp.php (deleted)
	* trunk/info/info/alkis/alkisfsgbexp.php (deleted)
	* trunk/info/info/alkis/alkisfsnw.php (modified)
	* trunk/info/info/alkis/alkisgbexp.php (deleted)
	* trunk/info/info/alkis/alkisgbfsexp.php (deleted)
	* trunk/info/info/alkis/alkisnamstruk.php (modified)




Tue, 26 Nov 2013 15:10:24 GMT frank.jaeger [298]
	* trunk/import/nutzungsart_definition.sql (modified)
	* trunk/import/nutzungsart_laden.sql (modified)
	* trunk/import/nutzungsart_metadaten.sql (modified)
	* trunk/import/sichten.sql (modified)
	* trunk/import/staedtische_FS_aus_ALKIS_rlp.sql (added)
	* trunk/info/info/alkis/alkisnamstruk.php (modified)
	* trunk/umn/alkis/fskomrlp.map (added)
	* trunk/umn/alkis/fskomrlp_4.map (added)

	Metadatentabelle zu Nutzungsarten bekommt 0-Inhalte. Neue Views.
	Neuer ...


Thu, 24 Oct 2013 12:45:52 GMT frank.jaeger [295]
	* trunk/import/sichten.sql (modified)

	PostProcesssing Straßen-Namen, Tab pp_strassenname ersetzt
	ap_pto_stra


Fri, 26 Apr 2013 11:52:56 GMT frank.jaeger [278]
	* trunk/import/alkis_Patch.sql (modified)
	* trunk/import/alkis_PostNAS_keytables.sql (modified)
	* trunk/import/alkis_PostNAS_schema.sql (modified)
	* trunk/import/pp_definition.sql (modified)
	* trunk/import/pp_laden.sql (modified)
	* trunk/import/sichten.sql (modified)
	* trunk/import/sichten_wms.sql (modified)
	* trunk/mapbender/conf/alkisnav_conf.php (modified)
	* trunk/mapbender/http/nav/alkisnav.css (modified)
	* trunk/mapbender/http/nav/alkisnav.htm (modified)
	* trunk/mapbender/http/nav/alkisnav_adr.php (modified)
	* trunk/mapbender/http/nav/alkisnav_eig.php (modified)
	* trunk/mapbender/http/nav/alkisnav_fkt.php (added)
	* trunk/mapbender/http/nav/alkisnav_fls.php (modified)
	* trunk/mapbender/http/nav/alkisnav_grd.php (modified)
	* trunk/mapbender/http/nav/blank_eig.html (modified)
	* trunk/mapbender/http/nav/ico/zurueck.ico (added)
	* trunk/umn/alkis/fonts/fonts_alkis.fnt (modified)
	* trunk/umn/alkis/templates/alkisbodensch.html (added)
	* trunk/umn/alkis/templates/alkisbodenschh.html (added)
	* trunk/umn/alkis/templates/footerp.html (added)

	Mapbender-Navigation mit ALKIS-Daten komplett überarbeitet.


Tue, 16 Apr 2013 15:56:10 GMT frank.jaeger [276]
	* trunk/import/alkis_Patch.sql (added)
	* trunk/import/alkis_PostNAS_keytables.sql (modified)
	* trunk/import/alkis_PostNAS_schema.sql (modified)
	* trunk/import/datenbank_anlegen.sh (modified)
	* trunk/import/grant.sql (modified)
	* trunk/import/sichten.sql (modified)
	* trunk/import/sichten_wms.sql (added)
	* trunk/mapbender/http/nav/alkisnav_adr.php (modified)
	* trunk/mapbender/http/nav/alkisnav_eig.php (modified)
	* trunk/mapbender/http/nav/alkisnav_fls.php (modified)
	* trunk/mapbender/http/nav/alkisnav_grd.php (modified)

	Views um Thema "Bodenschätzung" erweitert, Mapbender-Nav korrigiert, ...


Mon, 15 Apr 2013 09:55:47 GMT frank.jaeger [275]
	* trunk/import/alkis_PostNAS_schema.sql (modified)
	* trunk/import/sichten.sql (modified)
	* trunk/info/info/alkis/alkisausk.php (modified)
	* trunk/info/info/alkis/alkisbestnw.php (modified)
	* trunk/info/info/alkis/alkisfsexp.php (modified)
	* trunk/info/info/alkis/alkisfsgbexp.php (modified)
	* trunk/info/info/alkis/alkisfshist.php (modified)
	* trunk/info/info/alkis/alkisfsnw.php (modified)
	* trunk/info/info/alkis/alkisgbexp.php (modified)
	* trunk/info/info/alkis/alkisgbfsexp.php (modified)
	* trunk/info/info/alkis/alkisgebaeudenw.php (modified)
	* trunk/info/info/alkis/alkishaus.php (modified)
	* trunk/info/info/alkis/alkisinlayausk.php (modified)
	* trunk/info/info/alkis/alkisinlaybaurecht.php (modified)
	* trunk/info/info/alkis/alkislage.php (modified)
	* trunk/info/info/alkis/alkisnamstruk.php (modified)
	* trunk/info/info/alkis/alkisrelationen.php (modified)

	Buchauskunft: deprecated "import_request_variables" ersetzt. In ...


Tue, 12 Mar 2013 10:30:05 GMT frank.jaeger [269]
	* trunk/import/sichten.sql (modified)
	* trunk/umn/alkis/alkis_muster_entw.map (modified)
	* trunk/umn/alkis/alkis_muster_entw_4.map (modified)

	ALKIS-Mapfile: Neuer Layer "ax_gebaeude_txt" (Funktion und Name des ...


Wed, 06 Mar 2013 15:27:37 GMT frank.jaeger [268]
	* trunk/import/sichten.sql (modified)

	View "ap_pto_stra" schrittweise verbessert um mehrfache Darstellung
	von ...


Wed, 06 Mar 2013 08:08:49 GMT frank.jaeger [266]
	* trunk/import/sichten.sql (modified)
	* trunk/mapproxy/base.yaml (modified)
	* trunk/mapproxy/projects/alkisrlp.yaml (modified)
	* trunk/umn/alkis/alkis_muster_entw.map (added)
	* trunk/umn/alkis/alkis_muster_entw_4.map (added)

	Arbeiten am ALKIS-Mapfile als Entwicklerversion _entw.map zusätzlich ...


Thu, 21 Feb 2013 12:56:16 GMT frank.jaeger [265]
	* trunk/import/pp_laden.sql (modified)
	* trunk/import/sichten.sql (modified)

	View zum Suchen und SQL-Befehl zum Löschen alter Versionen der ALKIS- ...


Mon, 28 Jan 2013 08:13:18 GMT astrid.emde [215]
	* trunk/import/alkis-functions.sql (moved)
	* trunk/import/alkis-trigger-hist-oracle.sql (moved)
	* trunk/import/alkis-trigger-hist.sql (moved)
	* trunk/import/alkis-trigger-kill-oracle.sql (moved)
	* trunk/import/alkis-trigger-kill.sql (moved)
	* trunk/import/alkis_PostNAS_ORACLE_schema.sql (moved)
	* trunk/import/alkis_PostNAS_keytables.sql (moved)
	* trunk/import/alkis_PostNAS_schema.sql (moved)
	* trunk/import/datenbank_anlegen.sh (moved)
	* trunk/import/grant.sql (moved)
	* trunk/import/konv_batch.sh (moved)
	* trunk/import/konvertierung_kommandos_beispiele.txt (moved)
	* trunk/import/nutzungsart_definition.sql (moved)
	* trunk/import/nutzungsart_laden.sql (moved)
	* trunk/import/nutzungsart_metadaten.sql (moved)
	* trunk/import/ordner_konvertieren.sh (moved)
	* trunk/import/pg-to-oci.pl (moved)
	* trunk/import/pp_definition.sql (moved)
	* trunk/import/pp_laden.sql (moved)
	* trunk/import/sichten.sql (moved)
	* trunk/import/zip_ordner.sh (moved)

	Dateien in das neue Verzeichnis /import für die Importskripte ...


Mon, 14 Jan 2013 18:41:34 GMT astrid.emde [195]
	* trunk/data/konvert/postnas_0.7/sichten.sql (modified)

	-- ap_lpo.signaturnummer = '2004' ist in 0.7 schema nun ein varchar


