Ignore:
Timestamp:
11/02/11 16:21:26 (10 years ago)
Author:
tobias.dick
Message:

Bugfixes

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/data/konvert/postnas_0.6/atkis_rp_rendering/processing/sql/baeche_full.sql

    r114 r118  
     1DROP TABLE IF EXISTS ax_gewaesserachse_merged; 
     2-- 
     3SELECT ax_gewaesserachse.wkb_geometry, ax_wasserlauf.name_ as widmung into ax_gewaesserachse_merged from ax_wasserlauf INNER JOIN alkis_beziehungen ON (alkis_beziehungen.beziehung_zu = ax_wasserlauf.gml_id) INNER JOIN ax_gewaesserachse ON  
     4(ax_gewaesserachse.gml_id=alkis_beziehungen.beziehung_von); 
     5-- 
    16DROP TABLE IF EXISTS map_baeche_g0; 
    27-- 
    38SELECT (ST_Dump(ST_Linemerge(ST_Collect(ST_SimplifyPreserveTopology( wkb_geometry, 2.5 ))))).geom AS wkb_geometry, 
    4 NULL::text AS widmung 
     9widmung 
    510INTO map_baeche_g0  
    6 FROM ax_gewaesserachse; 
     11FROM ax_gewaesserachse_merged GROUP BY ax_gewaesserachse_merged.widmung; 
    712-- 
    813DROP SEQUENCE IF EXISTS map_baeche_g0_gid_seq; 
Note: See TracChangeset for help on using the changeset viewer.