Changeset 352 for trunk/import


Ignore:
Timestamp:
03/10/15 17:59:48 (9 years ago)
Author:
frank.jaeger
Message:

Probleme mit "ST_CurvePolygon" in "nutzung". Einschränkung Geometrietyp rausnehmen.

Location:
trunk/import
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • trunk/import/nutzungsart_definition.sql

    r346 r352  
    1616-- Stand  
    1717 
    18 --  2012-02-10 PostNAS 07, Umbenennung 
     18--  2012-02-10 PostNAS 0.7, Umbenennung 
    1919--  2013-11-15 In nutzung_class.class können NULL-Werte auftreten. 
    2020--  2013-11-26 NULL wird durch Zahl "0" ersetzt, "NOT NULL" wieder aktivieren 
    2121--  2014-08-26 erweiterte gml_id (wie in den primÀren Tabellen) 
    2222--  2014-11-25 Version geaendert auf 0.8, EPSG Übergabe in Tabelle Nutzung 
     23--  2015-03-10 Massenhaft "ST_CurvePolygon" in "nutzung". 
     24--             Quick 'n dirty: EinschrÀnkung des geometry-Typ löschen. 
     25 
    2326 
    2427SET client_encoding = 'UTF-8'; 
     
    7679SELECT AddGeometryColumn('nutzung','wkb_geometry',:alkis_epsg,'POLYGON',2); 
    7780-- Vereinzelt auch vorkommende MULTIPOLYGON 
     81-- 2015-03-10: Massenhaft "ST_CurvePolygon" ! 
     82 
     83-- Quick 'n dirty: 
     84ALTER TABLE nutzung DROP CONSTRAINT enforce_geotype_wkb_geometry; 
     85 
    7886 
    7987-- 'class' ist nur innerhalb einer Gruppe ein sinvoller Index 
  • trunk/import/nutzungsart_laden.sql

    r298 r352  
    2222--               Fehlende Werte aus konvertierten Daten ergÀnzen. Wenn dies in der Praxis wirklich  
    2323--               vorkommt, sollte das Lade-Script "nutzungsart_metadaten.sql" ergÀnzt werden. 
    24  
     24--  2015-03-10 Korrektur: bei ax_TagebauGrubeSteinbruch ist nutz_id = 5 
     25--             EinschrÀnkung " AND st_geometrytype(wkb_geometry) = 'ST_Polygon' " deaktivieren, denn 
     26--             es ist ein neuer Geometrietyp "ST_CurvePolygon" aufgetaucht. 
    2527 
    2628SET client_encoding = 'UTF-8'; 
     
    4850  FROM ax_wohnbauflaeche 
    4951  WHERE endet IS NULL 
    50     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
    51  
     52--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     53  ; 
    5254 
    5355-- 02 REO: ax_IndustrieUndGewerbeflaeche 
     
    5759  FROM ax_industrieundgewerbeflaeche 
    5860  WHERE endet IS NULL 
    59     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     61--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     62  ; 
    6063 
    6164 
     
    6669  FROM ax_halde 
    6770  WHERE endet IS NULL 
    68     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     71--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     72  ; 
    6973 
    7074 
     
    7579  FROM ax_bergbaubetrieb 
    7680  WHERE endet IS NULL 
    77     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     81--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     82  ; 
    7883 
    7984 
     
    8287INSERT INTO nutzung (gml_id, beginnt, nutz_id, class,                 info, zustand, name, bezeichnung, wkb_geometry) 
    8388  SELECT             gml_id, beginnt, 5,       coalesce(abbaugut, 0), null, zustand, name, null,        wkb_geometry  
    84   FROM ax_tagebaugrubesteinbruch 
    85   WHERE endet IS NULL 
    86     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     89  FROM ax_bergbaubetrieb 
     90  WHERE endet IS NULL 
     91--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     92  ; 
    8793 
    8894 
     
    9399  FROM ax_flaechegemischternutzung 
    94100  WHERE endet IS NULL 
    95     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     101--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     102  ; 
    96103 
    97104 
     
    102109  FROM ax_flaechebesondererfunktionalerpraegung 
    103110  WHERE endet IS NULL 
    104     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     111--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     112  ; 
    105113 
    106114 
     
    111119  FROM ax_sportfreizeitunderholungsflaeche 
    112120  WHERE endet IS NULL 
    113     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     121--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     122  ; 
    114123-- weiteres Feld: name char(20)? 
    115124 
     
    121130  FROM ax_friedhof 
    122131  WHERE endet IS NULL 
    123     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     132--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     133  ; 
    124134 
    125135 
     
    132142  FROM ax_strassenverkehr 
    133143  WHERE endet IS NULL 
    134     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     144--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     145  ; 
    135146 
    136147 
     
    149160  FROM ax_platz 
    150161  WHERE endet IS NULL 
    151     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     162--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     163  ; 
    152164 
    153165 
     
    158170  FROM ax_bahnverkehr 
    159171  WHERE endet IS NULL 
    160     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     172--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     173  ; 
    161174-- bahnkategorie ist alternativ ein geeignetes class-Feld 
    162175 
     
    168181  FROM ax_flugverkehr 
    169182  WHERE endet IS NULL 
    170     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     183--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     184  ; 
    171185 
    172186 
     
    177191  FROM ax_schiffsverkehr 
    178192  WHERE endet IS NULL 
    179     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     193--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     194  ; 
    180195 
    181196 
     
    188203  FROM ax_landwirtschaft 
    189204  WHERE endet IS NULL 
    190     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     205--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     206  ; 
    191207 
    192208 
     
    197213  FROM ax_wald 
    198214  WHERE endet IS NULL 
    199     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     215--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     216  ; 
    200217 
    201218 
     
    206223  FROM ax_gehoelz 
    207224  WHERE endet IS NULL 
    208     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     225--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     226  ; 
    209227 
    210228 
     
    215233  FROM ax_heide 
    216234  WHERE endet IS NULL 
    217     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     235--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     236  ; 
    218237 
    219238 
     
    224243  FROM ax_moor 
    225244  WHERE endet IS NULL 
    226     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     245--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     246  ; 
    227247 
    228248 
     
    233253  FROM ax_sumpf 
    234254  WHERE endet IS NULL 
    235     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     255--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     256  ; 
    236257 
    237258 
     
    242263  FROM ax_unlandvegetationsloseflaeche 
    243264  WHERE endet IS NULL 
    244     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     265--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     266  ; 
    245267 
    246268-- (23 NummerierungslÃŒcke) 
     
    254276  FROM ax_fliessgewaesser 
    255277  WHERE endet IS NULL 
    256     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     278--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     279  ; 
    257280 
    258281 
     
    263286  FROM ax_hafenbecken 
    264287  WHERE endet IS NULL 
    265     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     288--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     289  ; 
    266290 
    267291 
     
    272296  FROM ax_stehendesgewaesser 
    273297  WHERE endet IS NULL 
    274     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     298--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     299  ; 
    275300 
    276301 
     
    281306  FROM ax_meer 
    282307  WHERE endet IS NULL 
    283     AND st_geometrytype(wkb_geometry) = 'ST_Polygon'; 
     308--  AND st_geometrytype(wkb_geometry) = 'ST_Polygon' 
     309  ; 
    284310 
    285311 
Note: See TracChangeset for help on using the changeset viewer.