# # ChangeLog for trunk/import/sichten.sql # # Generated by Trac 0.12.3 # 04/20/24 11:10:46 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