Changeset 118 for trunk/data


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

Bugfixes

Location:
trunk/data/konvert/postnas_0.6/atkis_rp_rendering/processing/sql
Files:
2 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; 
  • trunk/data/konvert/postnas_0.6/atkis_rp_rendering/processing/sql/stehendesgewaesser_prep.sql

    r114 r118  
    55SELECT  
    66wkb_geometry, 
    7 NULL::text AS widmung 
     7widmung 
    88INTO map_stehendesgewaesser_g0  
    99 
    1010FROM ( 
    11         SELECT (ST_Dump( ST_Union( ax_stehendesgewaesser.wkb_geometry ))).geom AS wkb_geometry 
    12         FROM ax_stehendesgewaesser 
     11        SELECT (ST_Dump( ST_Union( ax_stehendesgewaesser.wkb_geometry ))).geom AS wkb_geometry, unverschluesselt as widmung  
     12        FROM ax_stehendesgewaesser GROUP BY widmung  
    1313) AS wrapper;  
    1414-- 
Note: See TracChangeset for help on using the changeset viewer.