[Mapbender-commits] r3061 - in branches/2.5/resources/db: mysql/utf8 postgresql/utf8

Tue Sep 30 10:42:26 EDT 2008

Author: christoph
Date: 2008-09-30 10:42:25 -0400 (Tue, 30 Sep 2008)
New Revision: 3061

Modified:
   branches/2.5/resources/db/mysql/utf8/mysql_data.sql
   branches/2.5/resources/db/postgresql/utf8/pgsql_data.sql
Log:
replaced faulty characters similar to 

http://trac.osgeo.org/mapbender/ticket/264

Modified: branches/2.5/resources/db/mysql/utf8/mysql_data.sql
===================================================================

--- branches/2.5/resources/db/mysql/utf8/mysql_data.sql	2008-09-30 13:30:38 UTC (rev 3060)
+++ branches/2.5/resources/db/mysql/utf8/mysql_data.sql	2008-09-30 14:42:25 UTC (rev 3061)
@@ -50,7 +50,7 @@
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('wms_worldwide', 'body', 1, 1, 'obligatory body', NULL, 'body', '', '', 0, 0, 0, 0, 0, '', '', 'body', '', '', '', '', NULL);
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('wms_africa', 'content', 2, 1, 'text', NULL, 'div', '', '', 10, 50, 500, 30, 2, 'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;', 'This GUI is an OGC service catalog container and does not provide a map user interface. Please use the  (<a href=\\''javascript:history.back()\\''>back</a>) link to select another GUI form your list or log off to log on using another account (identity).<br><br>Diese GUI ist ein OGC Service Katalog Beh&auml;lter (Eimer, Container, nimm was Du meinst) und beinhaltet keine Kartenoberfl&auml;che. Verwenden Sie diesen (<a href=\\''javascript:history.back()\\''>back</a>)  Verweis, um aus der Liste eine andere GUI auszuw&auml;hlen oder melden Sie sich ab, um sich mit einer anderen Kennung anzumelden. ', 'div', '', '', '', '', NULL);
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('wms_australia', 'logout', 2, 1, 'Logout', NULL, 'img', '../img/button_gray/logout_off.png', 'onClick="window.location.href=''../php/mod_logout.php?sessionID''" border=''0''onmouseover=''this.src="../img/button_gray/logout_over.png"''onmouseout=''this.src="../img/button_gray/logout_off.png"'' title="Logout"', 5, 5, 24, 24, 1, '', '', '', '', '', '', '', 'http://www.mapbender.org/index.php/logout');
-INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('wms_australia', 'content', 2, 1, 'text', NULL, 'div', '', '', 10, 50, 500, 30, 2, 'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;', 'This GUI is an OGC service catalog container and does not provide a map user interface. Please use the  (<a href=''javascript:history.back()''>back</a>) link to select another GUI form your list or log off to log on using another account (identity).<br><br>Diese GUI ist ein OGC Service Katalog BehÃƒÆ’Ã‚Â¤lter (Eimer, Container, nimm was Du meinst) und beinhaltet keine KartenoberflÃƒÆ’Ã‚Â¤che. Verwenden Sie diesen (<a href=''javascript:history.back()''>back</a>)  Verweis, um aus der Liste eine andere GUI auszuwählen oder melden Sie sich ab, um sich mit einer anderen Kennung anzumelden. ', 'div', '', '', '', '', '');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('wms_australia', 'content', 2, 1, 'text', NULL, 'div', '', '', 10, 50, 500, 30, 2, 'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;', 'This GUI is an OGC service catalog container and does not provide a map user interface. Please use the  (<a href=''javascript:history.back()''>back</a>) link to select another GUI form your list or log off to log on using another account (identity).<br><br>Diese GUI ist ein OGC Service Katalog Behaelter (Eimer, Container, nimm was Du meinst) und beinhaltet keine Kartenoberflaeche. Verwenden Sie diesen (<a href=''javascript:history.back()''>back</a>)  Verweis, um aus der Liste eine andere GUI auszuwählen oder melden Sie sich ab, um sich mit einer anderen Kennung anzumelden. ', 'div', '', '', '', '', '');
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('wms_australia', 'body', 1, 1, 'obligatory body', NULL, 'body', '', '', 0, 0, NULL, NULL, NULL, '', '', 'body', '', '', '', '', '');
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('wms_europe', 'logout', 2, 1, 'Logout', NULL, 'img', '../img/button_gray/logout_off.png', 'onClick="window.location.href=''../php/mod_logout.php?sessionID''" border=''0''onmouseover=''this.src="../img/button_gray/logout_over.png"''onmouseout=''this.src="../img/button_gray/logout_off.png"'' title="Logout"', 5, 5, 24, 24, 1, '', '', '', '', '', '', '', 'http://www.mapbender.org/index.php/logout');
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('wms_europe', 'body', 1, 1, 'obligatory body', NULL, 'body', '', '', 0, 0, NULL, NULL, NULL, '', '', 'body', '', '', '', '', '');
@@ -382,7 +382,7 @@
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('admin1', 'user_gui', 2, 1, 'allocate guis to user', '', 'a', '', 'href = "../php/mod_user_gui.php?sessionID&e_id_css=user_gui" target = "AdminFrame" ', 10, 370, 200, 20, 0, 'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;', 'USER -> GUI ', 'a', '', '', '', 'AdminFrame', '');
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('admin1', 'wfs_conf', 2, 1, 'create and edit a gazetteer module', 'Configure WFS', 'a', '', 'href="../php/mod_wfs_conf.php?sessionID"'' target="AdminFrame"', 10, 870, 200, 20, NULL, 'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;', 'WFS CONF', 'a', '', '', '', 'AdminFrame', '');
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('admin1', 'wfs_gui', 2, 1, 'edit wfs settings', 'Assign WFS conf to gui', 'a', '', 'href = "../javascripts/mod_wfs_client.html" target="AdminFrame"', 10, 1000, 250, 20, NULL, 'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;', 'asign WFS conf to gui', 'a', '', '', '', 'AdminFrame', '');
-INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('admin2_de', 'AdminFrame', 2, 1, 'Bereich fÃ¼r Administrationsmodule', '', 'iframe', '', 'frameborder = "0"', 200, 20, 980, 800, NULL, '', '', 'iframe', '', '', '', '', '');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('admin2_de', 'AdminFrame', 2, 1, 'Bereich fuer Administrationsmodule', '', 'iframe', '', 'frameborder = "0"', 200, 20, 980, 800, NULL, '', '', 'iframe', '', '', '', '', '');
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('admin2_de', 'CreateTreeGDE', 2, 1, 'Ordnerbaum konfigurieren', 'Create treeGDE', 'a', '', 'href = "../php/nestedSets.php?sessionID" target = "AdminFrame" ', 8, 280, 190, 20, 5, '', 'Ordnerbaum konfigurieren', 'a', '', '', '', 'AdminFrame', 'http://www.mapbender.org/index.php/ConfTreeGde');
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('admin2_de', 'body', 1, 1, 'Navigation', '', 'body', '', 'onload=''mod_adminNavigation_init()''', 0, 0, 180, 20, 0, '', '', '', 'mod_adminNavigation.js', '', '', '', '');
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('admin2_de', 'deleteWMS', 2, 1, '!Vollständig löschen!', 'Delete WMS completely', 'a', '', 'href = "../php/mod_deleteWMS.php?sessionID" target = "AdminFrame" ', 8, 100, 190, 20, 5, '', '!Vollständig löschen!', 'a', '', '', '', 'AdminFrame', 'http://www.mapbender.org/index.php/DeleteWMS');
@@ -2695,8 +2695,8 @@
 INSERT INTO keyword (keyword_id, keyword) VALUES (41, 'GIS');
 INSERT INTO keyword (keyword_id, keyword) VALUES (42, 'GDI NRW');
 INSERT INTO keyword (keyword_id, keyword) VALUES (43, 'NWSIB');
-INSERT INTO keyword (keyword_id, keyword) VALUES (44, 'klassifiziertes StraÃƒÆ’Ã…Â¸ennetz');
-INSERT INTO keyword (keyword_id, keyword) VALUES (45, 'Anweisung StraÃƒÆ’Ã…Â¸eninformationsbank ASB');
+INSERT INTO keyword (keyword_id, keyword) VALUES (44, 'klassifiziertes Strassennetz');
+INSERT INTO keyword (keyword_id, keyword) VALUES (45, 'Anweisung Strasseninformationsbank ASB');
 INSERT INTO keyword (keyword_id, keyword) VALUES (46, 'Netzknoten-Stationierungssystem');
 INSERT INTO keyword (keyword_id, keyword) VALUES (47, 'birds');
 INSERT INTO keyword (keyword_id, keyword) VALUES (48, 'distribution');
@@ -2714,8 +2714,8 @@
 INSERT INTO keyword (keyword_id, keyword) VALUES (60, 'volunteers');
 INSERT INTO keyword (keyword_id, keyword) VALUES (61, 'cbc');
 INSERT INTO keyword (keyword_id, keyword) VALUES (62, 'christmas');
-INSERT INTO keyword (keyword_id, keyword) VALUES (63, 'SÃƒâ€¦Ã¢â‚¬Å¡ubfurt');
-INSERT INTO keyword (keyword_id, keyword) VALUES (64, 'SÃƒâ€¦Ã¢â‚¬Å¡ubice');
+INSERT INTO keyword (keyword_id, keyword) VALUES (63, 'Slubfurt');
+INSERT INTO keyword (keyword_id, keyword) VALUES (64, 'Slubice');
 INSERT INTO keyword (keyword_id, keyword) VALUES (65, 'Frankfurt (Oder)');
 INSERT INTO keyword (keyword_id, keyword) VALUES (66, 'topophilia');
 INSERT INTO keyword (keyword_id, keyword) VALUES (67, 'mental maps');
@@ -2892,7 +2892,7 @@
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (10174, 640, 13, '0', 'huemapped_srtm', 'SRTM derived global elevation, 3 arc-second, hue mapped', 0, 90198, 0, '', '', ' An SRTM derived elevation dataset, where elevation is mapped to hue, resulting a color image');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (10175, 640, 14, '0', 'srtmplus', 'Global 1km elevation, seamless SRTM land elevation and ocean depth', 0, 1002199, 0, '', '', ' 	The SRTM30 Plus dataset, a 30 arc-second seamless combination of GTOPO30, SRTM derived land elevation and UCSD Sandwell bathymetry data.  The default style is scaled to 8 bit, non-linear.  It is possible to request the elevation data in meters by the short_int tyle and requesting PNG format.  The resulting PNG file will be a unsigned 16 bit per pixel image. The values are then the elevation in meters.  Values are signed 16 bit integers, but PNG will present them as unsigned, any values larger than 32767 should be interpreted as negative numbers.  For elevation values in feet, request PNG format with the style feet_short_int.       ');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (10176, 640, 15, '0', 'worldwind_dem', 'SRTM derived global elevation, 3 arc-second', 0, 90198, 0, '', '', ' 	A global elevation model, prepared from the 3 arc-second SRTM dataset by filling some of the problem areas. Prepared by the NASA Learning Technologies. 	The default style is scaled to 8 bit, non-linear. 	It is possible to request the elevation data in meters by the short_int tyle and requesting PNG format. The resulting PNG file will be a unsigned 16 bit per pixel image. The values are then the elevation in meters. 	Values are signed 16 bit integers, but PNG will present them as unsigned, leading to a few areas with very large values (65000+) 	For elevation values in feet, request PNG format with the style feet_short_int.       ');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19255, 828, 7, '0', 'Puntos_geodÃƒÆ’Ã‚Â©sicos', 'Puntos_geodÃƒÆ’Ã‚Â©sicos', 1, 0, 0, '', '', '');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19255, 828, 7, '0', 'Puntos_geodesicos', 'Puntos_geodesicos', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19176, 250, 0, '', 'Demis World Map', 'Demis World Map', 0, 0, 0, '', '', 'None');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (2713, 250, 1, '0', 'Bathymetry', 'Bathymetry', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (2714, 250, 2, '0', 'Countries', 'Countries', 1, 0, 0, '', '', '');
@@ -3069,17 +3069,17 @@
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19241, 789, 18, '0', 'tk10', 'TK 10', 0, 94, 4691, '', '', 'FREETK:MS:FREETK:');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19242, 789, 19, '18', 'tk10w', 'TK 10 - Gewaesser', 0, 0, 0, '', '', 'FREETK:MS:FREETK:RASTER TK10GEW');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19243, 789, 20, '18', 'tk10i', 'TK 10 - Hoehenlinien', 0, 0, 0, '', '', 'FREETK:MS:FREETK:RASTER TK10ISO');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19190, 328, 0, '', 'verfÃƒÆ’Ã‚Â¼gbare Layer', 'verfÃƒÆ’Ã‚Â¼gbare Layer', 0, 0, 0, '', '', 'Web Map Service auf Basis des Smallworld GIS');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19190, 328, 0, '', 'verfuegbare Layer', 'verfuegbare Layer', 0, 0, 0, '', '', 'Web Map Service auf Basis des Smallworld GIS');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3385, 328, 1, '0', 'Autobahn', 'Autobahn', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3386, 328, 2, '0', 'Bundesstr.', 'Bundesstr.', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3387, 328, 3, '0', 'Landesstr.', 'Landesstr.', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3388, 328, 4, '0', 'Kreisstr.', 'Kreisstr.', 1, 0, 0, '', '', '');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3393, 328, 5, '0', 'Aeste', 'ÃƒÆ’Ã¢â‚¬Å¾ste', 1, 0, 0, '', '', '');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3393, 328, 5, '0', 'Aeste', 'Aeste', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19191, 328, 6, '0', 'Netzknoten', 'Netzknoten', 1, 0, 68150, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19192, 328, 7, '0', 'Nullpunkte', 'Nullpunkte', 1, 0, 50110, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19193, 328, 8, '0', 'AS-Nummern', 'AS-Nummern', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19194, 328, 9, '0', 'AS-Namen', 'AS-Namen', 1, 0, 68150, '', '', '');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19195, 328, 10, '0', 'Strassenbez.', 'StraÃƒÆ’Ã…Â¸enbez.', 1, 0, 0, '', '', '');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19195, 328, 10, '0', 'Strassenbez.', 'Strassenbez.', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19196, 328, 11, '0', 'Abschnittsnr.', 'Abschnittsnr.', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3391, 328, 12, '0', 'Bauwerke', 'Bauwerke', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19197, 328, 13, '12', 'Bauwerkslage', 'Bauwerkslage', 1, 0, 50110, '', '', '');
@@ -3090,7 +3090,7 @@
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19202, 328, 18, '15', 'Kreise_/_kreisfreie_Staedte', 'Kreise / kreisfreie Städte', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19203, 328, 19, '15', 'Gemeinden', 'Gemeinden', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19204, 328, 20, '0', 'Rasterkarten', 'Rasterkarten', 0, 0, 0, '', '', '');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19205, 328, 21, '20', 'Strassenkarte', 'StraÃƒÆ’Ã…Â¸enkarte', 0, 0, 0, '', '', '');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19205, 328, 21, '20', 'Strassenkarte', 'Strassenkarte', 0, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (7523, 584, 6, '0', 'OBBA_SQUARE', 'Ontario Breeding Bird Atlas 10 km Squares', 1, 0, 0, '', '', 'A sampling unit used by the Ontario Breeding Bird Atlas to collect breeding evidence data for all bird species within the Province of Ontario.  Squares are based upon the Universal Transverse Mercator (UTM) grid system, NAD83, and measure 10Km by 10Km except near UTM zone boundaries, where they are smaller.');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (7524, 584, 7, '0', 'OBBA_REGION', 'Ontario Breeding Bird Atlas Administrative Regions', 1, 0, 0, '', '', 'An administrative unit that is used for local bird atlas co-ordination, which is based on bioregions and access.  Each region is assigned a Regional Coordinator who administers bird surveys within their region.');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (7525, 584, 8, '0', 'OBBA_BLOCK', 'Ontario Breeding Bird Atlas 100 km Blocks', 1, 0, 0, '', '', 'A sampling unit used by the Ontario Breeding Bird Atlas to collect breeding evidence data for all bird species within the Province of Ontario.  Blocks are based upon the Universal Transverse Mercator (UTM) grid system, NAD83, and measure 100Km by 100Km except near UTM zone boundaries, where they are smaller.');
@@ -3098,9 +3098,9 @@
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (7527, 584, 10, '0', 'BBS_PT', 'Breeding Bird Survey Route Start Points', 1, 0, 0, '', '', 'The Breeding Bird Survey, initiated in 1966, is one of the oldest surveys of breeding birds in North America. It is conducted primarily by volunteers, who follow a predetermined, roadside route each year at the height of the breeding season.  This layer portrays the start point for each BBS route in Canada.');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19228, 834, 0, '', 'DE_aerial02', 'DE_aerial02', 0, 0, 0, '', '', 'The Delaware 2002 Aerial Imagery Map Service serves statewide orthophotography as captured in 2002. The State of Delaware contracted with EarthData International to develop 0.25-meter resolution color infrared digital ortho-photos for the entire state. Map scale of the photography is approximately 1:2,400. Airphotos were taken in March and April, 2002, digitized and georeferenced to Delaware State Plane NAD83 meters. This data is available as an ArcIMS map service, a WMS map service, original 1-meter raw data files. ');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19246, 828, 0, '', 'CAPAS', 'CAPAS', 0, 0, 0, '', '', 'IDERIOJA Gobierno de La Rioja OGC WMS');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19247, 828, 1, '0', 'Elementos_hidrogrÃƒÆ’Ã‚Â¡ficos', 'Elementos_hidrogrÃƒÆ’Ã‚Â¡ficos', 1, 0, 0, '', '', '');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19248, 828, 2, '0', 'Hojas_cartogrÃƒÆ’Ã‚Â¡ficas_1-5000', 'Hojas_cartogrÃƒÆ’Ã‚Â¡ficas_1-5000', 1, 0, 0, '', '', '');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19249, 828, 3, '0', 'Manzanas_de_los_nÃƒÆ’Ã‚Âºcleos_urbanos', 'Manzanas_de_los_nÃƒÆ’Ã‚Âºcleos_urbanos', 1, 0, 0, '', '', '');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19247, 828, 1, '0', 'Elementos_hidrograficos', 'Elementos_hidrograficos', 1, 0, 0, '', '', '');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19248, 828, 2, '0', 'Hojas_cartograficas_1-5000', 'Hojas_cartograficas_1-5000', 1, 0, 0, '', '', '');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19249, 828, 3, '0', 'Manzanas_de_los_nucleos_urbanos', 'Manzanas_de_los_nucleos_urbanos', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (10106, 634, 0, '', 'Location', 'Point locations', 0, 0, 0, '', '', 'This service provides approximate point locations for various     themes.   ');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (10107, 634, 1, '0', 'city_austral', 'Australasian Cities', 0, 0, 0, '', '', '           Location of cities in the Australasian region.         ');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (10108, 634, 2, '0', 'capital_aus', 'Australian Capital Cities', 0, 0, 0, '', '', '           Location of capital cities in Australia.         ');
@@ -3160,7 +3160,7 @@
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19006, 893, 0, '', 'Germany', 'Germany', 0, 1, 0, '', '', 'Germany');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19007, 893, 1, '0', 'Topographie', 'topography', 0, 0, 0, 'http://www.mapbender.de/', 'http://www.mapbender.de/', 'Topographie,Landschaft');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (7519, 584, 2, '0', 'CBC_PT', 'Canadian Christmas Bird Count Locations', 1, 0, 0, '', '', 'A winter survey of bird populations conducted during the Christmas period - December 14 to January 5th inclusive.  More than 1800 counts are conducted each year across Canada, the United States and Latin America.  On a selected day within the count period, local birders count as many birds as possible within a 24 km (15 mile) diameter circle.  The Christmas Bird Count had long been organized on the continental scale by the New York-based National Audubon Society. In 2000, Audubon finalized an agreement with Bird Studies Canada that would see BSC partner with Audubon to coordinate CBCs in Canada.  This layer represents the centre point of all the Christmas Bird Counts conducted in Canada.  An accompanying layer (CBC_PY) contains the 24 km circles.');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19170, 908, 0, '', 'NRW', 'NRW', 0, 0, 140316, '', '', 'Nutzungsbedingungen: Sämtliche Rechte an diesem Produkt liegen beim Landesvermessungsamt NRW. Die Nutzung ist bis auf Widerruf kostenfrei. Der Nutzer muss sich vor jeder Nutzung beim Landesvermessungsamt NRW identifizieren und seine spezielle Nutzung mit Angabe des Verwendungszwecks und Umfang der Nutzung anmelden (KontaktmÃƒÆ’Ã‚Â¶glichkeiten zum Landesvermessungsamt NRW siehe unten). Die Nutzung ist ausschlieÃƒÆ’Ã…Â¸lich fÃƒÆ’Ã‚Â¼r Testzwecke und im Rahmen von GDI-Projekten zulässig; die Nutzung fÃƒÆ’Ã‚Â¼r kommerzielle Anwendungen ist ausdrÃƒÆ’Ã‚Â¼cklich ausgeschlossen. Die mittelbare oder unmittelbare Weitergabe der Daten an Dritte ist auch in Verbindung mit weiteren Daten ohne ausdrÃƒÆ’Ã‚Â¼ckliche Genehmigung durch das Landesvermessungsamt NRW nicht zulässig. Der Nutzer ist verpflichtet, einen deutlichen Copyright-Hinweis auf das Landesvermessungsamt NRW als DateneigentÃƒÆ’Ã‚Â¼mer bei Visualisierungen jeder Art anzubringen.');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19170, 908, 0, '', 'NRW', 'NRW', 0, 0, 140316, '', '', 'Nutzungsbedingungen: Sämtliche Rechte an diesem Produkt liegen beim Landesvermessungsamt NRW. Die Nutzung ist bis auf Widerruf kostenfrei. Der Nutzer muss sich vor jeder Nutzung beim Landesvermessungsamt NRW identifizieren und seine spezielle Nutzung mit Angabe des Verwendungszwecks und Umfang der Nutzung anmelden (Kontaktmoeglichkeiten zum Landesvermessungsamt NRW siehe unten). Die Nutzung ist ausschliesslich fuer Testzwecke und im Rahmen von GDI-Projekten zulässig; die Nutzung fuer kommerzielle Anwendungen ist ausdruecklich ausgeschlossen. Die mittelbare oder unmittelbare Weitergabe der Daten an Dritte ist auch in Verbindung mit weiteren Daten ohne ausdrueckliche Genehmigung durch das Landesvermessungsamt NRW nicht zulässig. Der Nutzer ist verpflichtet, einen deutlichen Copyright-Hinweis auf das Landesvermessungsamt NRW als Dateneigentuemer bei Visualisierungen jeder Art anzubringen.');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19171, 908, 1, '0', 'Raster:TK100_KMF:Farbkombination', 'Farbkombination', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19226, 789, 0, '', 'Topographische Karten', 'Topographische Karten', 0, 0, 0, '', '', 'SICAD Internet Suite V6.0A05 at http://www.landesvermessung.sachsen.de/sims/sicad-');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19008, 893, 2, '0', 'Grenze', 'border', 0, 750000, 0, 'http://www.mapbender.de/', 'http://www.mapbender.de/', 'Grenzen, border');
@@ -3334,12 +3334,12 @@
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19113, 902, 3, '0', 'ozen', 'Oberzentren', 0, 25001, 2000000, '', '', 'Oberzentren, TYP = 0');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19114, 902, 4, '0', 'mzen', 'Mittelzentren', 0, 25001, 600000, '', '', 'Mittelzentren, TYP = 1');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19115, 902, 5, '0', 'uzen', 'Unterzentren', 0, 25001, 200000, '', '', 'Unterzentren, TYP = 2');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19116, 902, 6, '0', 'lwas', 'FlÃƒÆ’Ã‚Â¼sse und Kanäle', 0, 25001, 150000, '', '', 'FlÃƒÆ’Ã‚Â¼sse und Kanäle');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19116, 902, 6, '0', 'lwas', 'Fluesse und Kanäle', 0, 25001, 150000, '', '', 'Fluesse und Kanäle');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19117, 902, 7, '0', 'fwas', 'Seen', 0, 25001, 250001, '', '', 'Seen');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19118, 902, 8, '0', 'ebahn', 'Eisenbahnen', 0, 25001, 250001, '', '', 'Eisenbahnen');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19119, 902, 9, '0', 'kstr', 'KreisstraÃƒÆ’Ã…Â¸en', 0, 25001, 100000, '', '', 'KreisstraÃƒÆ’Ã…Â¸en');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19120, 902, 10, '0', 'lstr', 'LandesstraÃƒÆ’Ã…Â¸en', 0, 25001, 250001, '', '', 'LandesstraÃƒÆ’Ã…Â¸en');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19121, 902, 11, '0', 'bstr', 'BundesstraÃƒÆ’Ã…Â¸en', 0, 25001, 749999, '', '', 'BundesstraÃƒÆ’Ã…Â¸en');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19119, 902, 9, '0', 'kstr', 'Kreisstrassen', 0, 25001, 100000, '', '', 'Kreisstrassen');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19120, 902, 10, '0', 'lstr', 'Landesstrassen', 0, 25001, 250001, '', '', 'Landesstrassen');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19121, 902, 11, '0', 'bstr', 'Bundesstrassen', 0, 25001, 749999, '', '', 'Bundesstrassen');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19122, 902, 12, '0', 'astr', 'Autobahnen', 0, 25001, 0, '', '', 'Autobahnen');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19123, 902, 13, '0', 'nfwas', 'Namen der Seen', 0, 25001, 100000, '', '', 'Namen der Seen');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19124, 902, 14, '0', 'kfz', 'Kfz-Zeichen', 0, 2000000, 0, '', '', 'Kfz-Zeichen');
@@ -4282,7 +4282,7 @@
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19140, 904, 2, '0', 'orte', 'Zentren', 0, 200000, 1000000, '', '', 'Zentren, TYP = 0');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19141, 904, 3, '0', 'korte', 'Orte', 0, 200000, 749999, '', '', 'Orte, TYP = 0');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3404, 329, 3, '0', 'dgk5dbr', 'DGK5', 0, 1, 3900, '', '', 'DGK5');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19142, 904, 4, '0', 'lwas', 'FlÃƒÆ’Ã‚Â¼sse und Kanäle', 0, 200000, 749999, '', '', 'FlÃƒÆ’Ã‚Â¼sse und Kanäle');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19142, 904, 4, '0', 'lwas', 'Fluesse und Kanäle', 0, 200000, 749999, '', '', 'Fluesse und Kanäle');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3405, 329, 4, '0', 'Stadtgrundkarte', 'Stadtgrundkarte', 0, 0, 0, '', '', 'Stadtgrundkarte');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19143, 904, 5, '0', 'fwas', 'Seen', 0, 200000, 749999, '', '', 'Seen');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3406, 329, 5, '4', 'flst', 'Flurstuecke', 0, 1, 2500, '', '', '');
@@ -4291,21 +4291,21 @@
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3407, 329, 6, '4', 'gebaeude', 'Gebaeude', 0, 1, 2500, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3408, 329, 7, '4', 'linien', 'Topographie', 0, 1, 2500, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3409, 329, 8, '4', 'texte', 'Beschriftung', 0, 1, 2500, '', '', '');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19145, 904, 7, '0', 'lstr', 'LandesstraÃƒÆ’Ã…Â¸en', 0, 200000, 400000, '', '', 'LandesstraÃƒÆ’Ã…Â¸en');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19146, 904, 8, '0', 'bstr', 'BundesstraÃƒÆ’Ã…Â¸en', 0, 200000, 1000000, '', '', 'BundesstraÃƒÆ’Ã…Â¸en');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19145, 904, 7, '0', 'lstr', 'Landesstrassen', 0, 200000, 400000, '', '', 'Landesstrassen');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19146, 904, 8, '0', 'bstr', 'Bundesstrassen', 0, 200000, 1000000, '', '', 'Bundesstrassen');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19147, 904, 9, '0', 'astr', 'Autobahnen', 0, 200000, 0, '', '', 'Autobahnen');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19148, 904, 10, '0', 'kfz', 'Kfz-Zeichen', 0, 1000000, 0, '', '', 'Kfz-Zeichen');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19156, 906, 1, '0', 'berlin', 'Berliner Bezirke', 0, 50000, 1000000, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19157, 906, 2, '0', 'geme', 'Gemeinde', 1, 50000, 1000000, '', '', 'digitaliert aus DTK 1:100.000');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19158, 906, 3, '0', 'kamt', 'Amtsfreie Gemeinde', 1, 50000, 1000000, '', '', '');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19159, 906, 4, '0', 'amt', 'ÃƒÆ’Ã¢â‚¬Å¾mter', 1, 50000, 1000000, '', '', '');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19159, 906, 4, '0', 'amt', 'Aemter', 1, 50000, 1000000, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19160, 906, 5, '0', 'stadt', 'Kreisfreie Städte', 1, 50000, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19161, 906, 6, '0', 'kreis', 'Landkreise', 1, 50000, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19162, 906, 7, '0', 'land', 'Land', 0, 50000, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19163, 906, 8, '0', 'staat', 'Deutschland', 0, 50000, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19164, 906, 9, '0', 'ngeme', 'Namen der Gemeinden', 0, 50000, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19165, 906, 10, '0', 'nkamt', 'Namen der amtfreien Gemeinden', 0, 50000, 0, '', '', '');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19166, 906, 11, '0', 'namt', 'Namen der ÃƒÆ’Ã¢â‚¬Å¾mter', 0, 50000, 0, '', '', '');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19166, 906, 11, '0', 'namt', 'Namen der Aemter', 0, 50000, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19167, 906, 12, '0', 'nkreis', 'KFZ Kennzeichen der Kreise', 0, 50000, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19233, 706, 0, '', 'WA_Atlas_GN_WMS', 'WA_Atlas_GN_WMS', 0, 0, 0, '', '', 'WMS Map Server');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (11542, 706, 1, '0', 'Australia Base Map', 'Australia Base Map', 0, 0, 0, '', '', '');
@@ -4318,13 +4318,13 @@
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19126, 903, 1, '0', 'land', 'Landkreise und kreisfreie Städte', 0, 100, 50000, '', '', 'digitalisiert und generalisiert aus DTK 1:100.000');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19127, 903, 2, '0', 'ort', 'Ortschaften', 1, 1000, 50000, '', '', 'digitaliert aus DTK 1:100.000');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19128, 903, 3, '0', 'wald', 'Waldflächen', 0, 1000, 50000, '', '', 'aus Basis-DLM');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19129, 903, 4, '0', 'gruen', 'GrÃƒÆ’Ã‚Â¼nflächen', 0, 1000, 50000, '', '', 'GrÃƒÆ’Ã‚Â¼nflächen aus Basis-DLM');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19130, 903, 5, '0', 'lwas', 'FlÃƒÆ’Ã‚Â¼sse und Kanäle', 0, 1000, 50000, '', '', 'aus Basis-DLM');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19129, 903, 4, '0', 'gruen', 'Gruenflächen', 0, 1000, 50000, '', '', 'Gruenflächen aus Basis-DLM');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19130, 903, 5, '0', 'lwas', 'Fluesse und Kanäle', 0, 1000, 50000, '', '', 'aus Basis-DLM');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19131, 903, 6, '0', 'fwas', 'Seen, Teiche', 0, 1000, 50000, '', '', 'aus Basis-DLM');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19132, 903, 7, '0', 'kgrnz', 'Kreisgrenze', 0, 1000, 50000, '', '', 'generalisiert aus 1:100.000');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19133, 903, 8, '0', 'flug', 'Internationale Flughäfen', 0, 1000, 29999, '', '', 'aus Basis-DLM');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19134, 903, 9, '0', 'ebahn', 'Eisenbahnverbindungen', 0, 1000, 50000, '', '', 'aus Basis-DLM');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19135, 903, 10, '0', 'str', 'StraÃƒÆ’Ã…Â¸en', 0, 1000, 50000, '', '', 'aus Basis-DLM');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19135, 903, 10, '0', 'str', 'Strassen', 0, 1000, 50000, '', '', 'aus Basis-DLM');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19136, 903, 11, '0', 'haus', 'Gebäude', 0, 1000, 50000, '', '', 'aus Basis-DLM');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19137, 903, 12, '0', 'nfwas', 'Namen der Seen, Teiche', 0, 1000, 50000, '', '', 'aus Basis-DLM');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (20102, 910, 0, '', 'IGME5000', 'IGME5000 preliminary release', 0, 0, 0, NULL, NULL, 'The 1 : 5 Million International Geological Map of Europe and Adjacent Areas (IGME 5000).');
@@ -7693,17 +7693,17 @@
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10175, 'default', 'Default Elevation Style, scaled to 8 bit using a non-linear function', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10175, 'short_int', 'short int elevation values when format is image/png, identical to default for jpeg', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10175, 'feet_short_int', 'short int elevation values in feet when format is image/png ', '', '');
-INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19247, 'Default', 'Default', 'http://wms.larioja.org/Legends/Elementos_hidrogrÃƒÆ’Ã‚Â¡ficos_Default.png', 'image/png');
+INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19247, 'Default', 'Default', 'http://wms.larioja.org/Legends/Elementos_hidrograficos_Default.png', 'image/png');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10176, 'default', 'Default Elevation Style, scaled to 8 bit using a non-linear function', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10176, 'short_int', 'short int elevation values when format is image/png', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10176, 'feet_short_int', 'short int elevation values in feet when format is image/png', '', '');
-INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19248, 'Default', 'Default', 'http://wms.larioja.org/Legends/Hojas_cartogrÃƒÆ’Ã‚Â¡ficas_1-5000_Default.png', 'image/png');
+INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19248, 'Default', 'Default', 'http://wms.larioja.org/Legends/Hojas_cartograficas_1-5000_Default.png', 'image/png');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10177, 'default', 'Default Elevation', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10177, 'short_int', 'short int signed elevation values when format is image/png or tiff', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10177, 'feet_short_int', 'short int elevation values in feet when format is image/png or image/tiff', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10177, 'real', 'DEM real numbers, in floating point format, meters, when used with image/tiff', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10177, 'feet_real', 'DEM in real numbers, in floating point format, feet, when used with image/tiff', '', '');
-INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19249, 'Default', 'Default', 'http://wms.larioja.org/Legends/Manzanas_de_los_nÃƒÆ’Ã‚Âºcleos_urbanos_Default.png', 'image/png');
+INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19249, 'Default', 'Default', 'http://wms.larioja.org/Legends/Manzanas_de_los_nucleos_urbanos_Default.png', 'image/png');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10178, 'default', 'Default Elevation', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10178, 'short_int', 'short int elevation values when format is image/png', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10178, 'feet_short_int', 'short int elevation values in feet when format is image/png', '', '');
@@ -7803,7 +7803,7 @@
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19240, 'Feb', 'February', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19240, 'Mar', 'March', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19240, 'Apr', 'April', '', '');
-INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19255, 'Default', 'Default', 'http://wms.larioja.org/Legends/Puntos_geodÃƒÆ’Ã‚Â©sicos_Default.png', 'image/png');
+INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19255, 'Default', 'Default', 'http://wms.larioja.org/Legends/Puntos_geodesicos_Default.png', 'image/png');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19256, 'Default', 'Default', 'http://wms.larioja.org/Legends/Tramos_de_carreteras_Default.png', 'image/png');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19257, 'Default', 'Default', 'http://wms.larioja.org/Legends/Tramos_de_ferrocarril_Default.png', 'image/png');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (14843, 'Default', 'Default', 'http://maps1.intergraph.com/wms/world/Legends/GLOBEImage_Default.png', 'image/png');
@@ -8033,7 +8033,7 @@
 INSERT INTO md_topic_category (md_topic_category_id, md_topic_category_code_en, md_topic_category_code_de) VALUES (3, 'boundaries', 'Grenzen');
 INSERT INTO md_topic_category (md_topic_category_id, md_topic_category_code_en, md_topic_category_code_de) VALUES (4, 'climatologyMeteorologyAtmosphere', 'Wetterkunde');
 INSERT INTO md_topic_category (md_topic_category_id, md_topic_category_code_en, md_topic_category_code_de) VALUES (5, 'economy', 'Wirtschaft');
-INSERT INTO md_topic_category (md_topic_category_id, md_topic_category_code_en, md_topic_category_code_de) VALUES (6, 'elevation', 'HÃƒÆ’Ã‚Â¶hendaten');
+INSERT INTO md_topic_category (md_topic_category_id, md_topic_category_code_en, md_topic_category_code_de) VALUES (6, 'elevation', 'Hoehendaten');
 INSERT INTO md_topic_category (md_topic_category_id, md_topic_category_code_en, md_topic_category_code_de) VALUES (7, 'environment', 'Umwelt');
 INSERT INTO md_topic_category (md_topic_category_id, md_topic_category_code_en, md_topic_category_code_de) VALUES (8, 'geoscientificInformation', 'Geowissenschaft');
 INSERT INTO md_topic_category (md_topic_category_id, md_topic_category_code_en, md_topic_category_code_de) VALUES (9, 'health', 'Gesundheit');
@@ -12581,8 +12581,8 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>gruen</Name>
-        <Title>GrÃƒÆ’Ã‚Â¼nflächen</Title>
-        <Abstract>GrÃƒÆ’Ã‚Â¼nflächen aus Basis-DLM</Abstract>
+        <Title>Gruenflächen</Title>
+        <Abstract>Gruenflächen aus Basis-DLM</Abstract>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.2339" miny="51.3128" maxx="14.7662" maxy="53.5648" />
         <BoundingBox SRS="EPSG:25833"
@@ -12591,7 +12591,7 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>lwas</Name>
-        <Title>FlÃƒÆ’Ã‚Â¼sse und Kanäle</Title>
+        <Title>Fluesse und Kanäle</Title>
         <Abstract>aus Basis-DLM</Abstract>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.253" miny="51.3161" maxx="14.7408" maxy="53.5563" />
@@ -12641,7 +12641,7 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>str</Name>
-        <Title>StraÃƒÆ’Ã…Â¸en</Title>
+        <Title>Strassen</Title>
         <Abstract>aus Basis-DLM</Abstract>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.2382" miny="51.3129" maxx="14.7649" maxy="53.5635" />
@@ -12769,8 +12769,8 @@
 ', NULL, 'http://deutschlandviewer.bayern.de/ogc/getogc.cgi?REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.1', 'none', 'none', '', '', '', '', '', '', '', '', '', '', '', NULL, 1, 1173698124, NULL, NULL, NULL, NULL);
 INSERT INTO wms (wms_id, wms_version, wms_title, wms_abstract, wms_getcapabilities, wms_getmap, wms_getfeatureinfo, wms_getlegendurl, wms_filter, wms_getcapabilities_doc, wms_owsproxy, wms_upload_url, fees, accessconstraints, contactperson, contactposition, contactorganization, address, city, stateorprovince, postcode, country, contactvoicetelephone, contactfacsimiletelephone, contactelectronicmailaddress, wms_mb_getcapabilities_doc, wms_owner, wms_timestamp, wms_supportsld, wms_userlayer, wms_userstyle, wms_remotewfs) VALUES (828, '1.1.1', 'IDERIOJA Gobierno de La Rioja OGC WMS', 'IDERIOJA Gobierno de La Rioja OGC WMS', 'http://wms.larioja.org/request.asp', 'http://wms.larioja.org/request.asp', 'http://wms.larioja.org/request.asp', '', '', '<?xml version="1.0"?>
 <!DOCTYPE WMT_MS_Capabilities SYSTEM "http://wms.larioja.org/Capabilities/capabilities_1_1_1.dtd" [ <!ELEMENT VendorSpecificCapabilities EMPTY>]>
-<WMT_MS_Capabilities version="1.1.1"><Service><Name>OGC:WMS</Name><!--Human-readable title for pick lists--><Title>IDERIOJA Gobierno de La Rioja OGC WMS</Title><!--Narrative description providing additional information--><Abstract>IDERIOJA Gobierno de La Rioja OGC WMS</Abstract><KeywordList><Keyword>WMS</Keyword><Keyword>OGC</Keyword><Keyword> La Rioja</Keyword><Keyword>Cartografia</Keyword><Keyword> Mapas </Keyword></KeywordList><!--Top-level address of service or service provider--><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://www.larioja.org" xlink:type="simple"/><ContactInformation><ContactPersonPrimary><ContactPerson>Gonzalo LÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â³pez GarcÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Âa</ContactPerson><ContactOrganization>ConsejerÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Âa de Turismo, Medio Ambiente y PolÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Âtica Territorial</ContactOrganization></ContactPersonPrimary><ContactPosition>Jefe de SecciÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â³n de Sistemas de InformaciÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â³n GeogrÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â¡fica y CartografÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Âa</ContactPosition><ContactAddress><AddressType>postal</AddressType><Address>Prado Viejo, 62 bis</Address><City>LogroÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â±o</City><StateOrProvince>La Rioja</StateOrProvince><PostCode>26071</PostCode><Country></Country></ContactAddress><ContactVoiceTelephone></ContactVoiceTelephone><ContactElectronicMailAddress></ContactElectronicMailAddress></ContactInformation><Fees>none</Fees><AccessConstraints>none</AccessConstraints></Service><Capability><Request><GetCapabilities><Format>application/vnd.ogc.wms_xml</Format><DCPType><HTTP><Get><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/request.asp" xlink:type="simple"/></Get></HTTP></DCPType></GetCapabilities><GetMap><Format>image/png</Format><Format>image/jpeg</Format><DCPType><HTTP><Get><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/request.asp" xlink:type="simple"/></Get></HTTP></DCPType></GetMap><GetFeatureInfo><Format>text/html</Format><DCPType><HTTP><Get><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/request.asp" xlink:type="simple"/></Get></HTTP></DCPType></GetFeatureInfo></Request><Exception><Format>application/vnd.ogc.se_inimage</Format><Format>application/vnd.ogc.se_xml</Format></Exception><Layer><Title>CAPAS</Title><SRS>EPSG:4326</SRS><SRS>EPSG:23030</SRS><SRS>EPSG:25830</SRS><LatLonBoundingBox minx="-3.2623" miny="41.8509" maxx="-1.5416" maxy="42.7473"/><!--BoundingBox is inheritable, we define at root, inherited by all--><BoundingBox SRS="EPSG:23030" minx="478621.4999" miny="4634401.5" maxx="619671.5001" maxy="4733511.3584"/><BoundingBox SRS="EPSG:25830" minx="478517.3309" miny="4634188.7848" maxx="619566.8081" maxy="4733298.3072"/><BoundingBox SRS="EPSG:4326" minx="-3.2623" miny="41.8509" maxx="-1.5416" maxy="42.7473"/><Layer queryable="1" opaque="0" noSubsets="0"><Name>Elementos_hidrogrÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â¡ficos</Name><Title>Elementos_hidrogrÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â¡ficos</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Elementos_hidrogrÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â¡ficos_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Hojas_cartogrÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â¡ficas_1-5000</Name><Title>Hojas_cartogrÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â¡ficas_1-5000</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Hojas_cartogrÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â¡ficas_1-5000_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Manzanas_de_los_nÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Âºcleos_urbanos</Name><Title>Manzanas_de_los_nÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Âºcleos_urbanos</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Manzanas_de_los_nÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Âºcleos_urbanos_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Masas_de_agua</Name><Title>Masas_de_agua</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Masas_de_agua_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Municipios</Name><Title>Municipios</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Municipios_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="0" opaque="0" noSubsets="0"><Name>Ortofoto_2004</Name><Title>Ortofoto_2004</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Ortofoto_2004_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Puntos_geodÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â©sicos</Name><Title>Puntos_geodÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â©sicos</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Puntos_geodÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â©sicos_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Tramos_de_carreteras</Name><Title>Tramos_de_carreteras</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Tramos_de_carreteras_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Tramos_de_ferrocarril</Name><Title>Tramos_de_ferrocarril</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Tramos_de_ferrocarril_Default.png" xlink:type="simple"/></LegendURL></Style></Layer></Layer></Capability></WMT_MS_Capabilities>
-', NULL, 'http://wms.larioja.org/request.asp?REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.1', 'none', 'none', 'Gonzalo LÃƒÆ’Ã‚Â³pez GarcÃƒÆ’Ã‚Âa', 'Jefe de SecciÃƒÆ’Ã‚Â³n de Sistemas de InformaciÃƒÆ’Ã‚Â³n GeogrÃƒÆ’Ã‚Â¡fica y CartografÃƒÆ’Ã‚Âa', 'ConsejerÃƒÆ’Ã‚Âa de Turismo, Medio Ambiente y PolÃƒÆ’Ã‚Âtica Territorial', 'Prado Viejo, 62 bis', 'LogroÃƒÆ’Ã‚Â±o', 'La Rioja', '26071', '', '', '', '', NULL, 1, 1173698127, NULL, NULL, NULL, NULL);
+<WMT_MS_Capabilities version="1.1.1"><Service><Name>OGC:WMS</Name><!--Human-readable title for pick lists--><Title>IDERIOJA Gobierno de La Rioja OGC WMS</Title><!--Narrative description providing additional information--><Abstract>IDERIOJA Gobierno de La Rioja OGC WMS</Abstract><KeywordList><Keyword>WMS</Keyword><Keyword>OGC</Keyword><Keyword> La Rioja</Keyword><Keyword>Cartografia</Keyword><Keyword> Mapas </Keyword></KeywordList><!--Top-level address of service or service provider--><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://www.larioja.org" xlink:type="simple"/><ContactInformation><ContactPersonPrimary><ContactPerson>Gonzalo Lopez Garcia</ContactPerson><ContactOrganization>Consejeria de Turismo, Medio Ambiente y Politica Territorial</ContactOrganization></ContactPersonPrimary><ContactPosition>Jefe de Seccion de Sistemas de Informacion Geografica y Cartografia</ContactPosition><ContactAddress><AddressType>postal</AddressType><Address>Prado Viejo, 62 bis</Address><City>Logrono</City><StateOrProvince>La Rioja</StateOrProvince><PostCode>26071</PostCode><Country></Country></ContactAddress><ContactVoiceTelephone></ContactVoiceTelephone><ContactElectronicMailAddress></ContactElectronicMailAddress></ContactInformation><Fees>none</Fees><AccessConstraints>none</AccessConstraints></Service><Capability><Request><GetCapabilities><Format>application/vnd.ogc.wms_xml</Format><DCPType><HTTP><Get><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/request.asp" xlink:type="simple"/></Get></HTTP></DCPType></GetCapabilities><GetMap><Format>image/png</Format><Format>image/jpeg</Format><DCPType><HTTP><Get><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/request.asp" xlink:type="simple"/></Get></HTTP></DCPType></GetMap><GetFeatureInfo><Format>text/html</Format><DCPType><HTTP><Get><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/request.asp" xlink:type="simple"/></Get></HTTP></DCPType></GetFeatureInfo></Request><Exception><Format>application/vnd.ogc.se_inimage</Format><Format>application/vnd.ogc.se_xml</Format></Exception><Layer><Title>CAPAS</Title><SRS>EPSG:4326</SRS><SRS>EPSG:23030</SRS><SRS>EPSG:25830</SRS><LatLonBoundingBox minx="-3.2623" miny="41.8509" maxx="-1.5416" maxy="42.7473"/><!--BoundingBox is inheritable, we define at root, inherited by all--><BoundingBox SRS="EPSG:23030" minx="478621.4999" miny="4634401.5" maxx="619671.5001" maxy="4733511.3584"/><BoundingBox SRS="EPSG:25830" minx="478517.3309" miny="4634188.7848" maxx="619566.8081" maxy="4733298.3072"/><BoundingBox SRS="EPSG:4326" minx="-3.2623" miny="41.8509" maxx="-1.5416" maxy="42.7473"/><Layer queryable="1" opaque="0" noSubsets="0"><Name>Elementos_hidrograficos</Name><Title>Elementos_hidrograficos</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Elementos_hidrograficos_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Hojas_cartograficas_1-5000</Name><Title>Hojas_cartograficas_1-5000</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Hojas_cartograficas_1-5000_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Manzanas_de_los_nucleos_urbanos</Name><Title>Manzanas_de_los_nucleos_urbanos</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Manzanas_de_los_nucleos_urbanos_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Masas_de_agua</Name><Title>Masas_de_agua</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Masas_de_agua_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Municipios</Name><Title>Municipios</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Municipios_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="0" opaque="0" noSubsets="0"><Name>Ortofoto_2004</Name><Title>Ortofoto_2004</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Ortofoto_2004_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Puntos_geodesicos</Name><Title>Puntos_geodesicos</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Puntos_geodesicos_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Tramos_de_carreteras</Name><Title>Tramos_de_carreteras</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Tramos_de_carreteras_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Tramos_de_ferrocarril</Name><Title>Tramos_de_ferrocarril</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Tramos_de_ferrocarril_Default.png" xlink:type="simple"/></LegendURL></Style></Layer></Layer></Capability></WMT_MS_Capabilities>
+', NULL, 'http://wms.larioja.org/request.asp?REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.1', 'none', 'none', 'Gonzalo Lopez Garcia', 'Jefe de Seccion de Sistemas de Informacion Geografica y Cartografia', 'Consejeria de Turismo, Medio Ambiente y Politica Territorial', 'Prado Viejo, 62 bis', 'Logrono', 'La Rioja', '26071', '', '', '', '', NULL, 1, 1173698127, NULL, NULL, NULL, NULL);
 INSERT INTO wms (wms_id, wms_version, wms_title, wms_abstract, wms_getcapabilities, wms_getmap, wms_getfeatureinfo, wms_getlegendurl, wms_filter, wms_getcapabilities_doc, wms_owsproxy, wms_upload_url, fees, accessconstraints, contactperson, contactposition, contactorganization, address, city, stateorprovince, postcode, country, contactvoicetelephone, contactfacsimiletelephone, contactelectronicmailaddress, wms_mb_getcapabilities_doc, wms_owner, wms_timestamp, wms_supportsld, wms_userlayer, wms_userstyle, wms_remotewfs) VALUES (86, '1.1.1', 'World Map', 'World Map in WGS84 Reference System', 'http://wms1.ccgis.de/cgi-bin/mapserv?map=/data/umn/world/world_map.map&', 'http://wms1.ccgis.de/cgi-bin/mapserv?map=/data/umn/world/world_map.map&', 'http://wms1.ccgis.de/cgi-bin/mapserv?map=/data/umn/world/world_map.map&', 'http://wms1.ccgis.de/cgi-bin/mapserv?map=/data/umn/world/world_map.map&', '', '<?xml version=''1.0'' encoding="ISO-8859-1" standalone="no" ?>
 <!DOCTYPE WMT_MS_Capabilities SYSTEM "http://schemas.opengeospatial.net/wms/1.1.1/WMS_MS_Capabilities.dtd"
  [
@@ -12934,8 +12934,8 @@
 		<Abstract>Web Map Service auf Basis des Smallworld GIS</Abstract>
 		<KeywordList>
 			<Keyword>NWSIB</Keyword>
-			<Keyword>klassifiziertes StraÃƒÆ’Ã…Â¸ennetz</Keyword>
-			<Keyword>Anweisung StraÃƒÆ’Ã…Â¸eninformationsbank ASB</Keyword>
+			<Keyword>klassifiziertes Strassennetz</Keyword>
+			<Keyword>Anweisung Strasseninformationsbank ASB</Keyword>
 			<Keyword>Netzknoten-Stationierungssystem</Keyword>
 		</KeywordList>
 		<OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.gis-consult.de"/>
@@ -12944,7 +12944,7 @@
 				<ContactPerson>Christian Vogt</ContactPerson>
 				<ContactOrganization>GIS Consult GmbH</ContactOrganization>
 			</ContactPersonPrimary>
-			<ContactPosition>GeschäftsfÃƒÆ’Ã‚Â¼hrer</ContactPosition>
+			<ContactPosition>Geschäftsfuehrer</ContactPosition>
 			<ContactAddress>
 				<AddressType>postal</AddressType>
 				<Address>Schultenbusch 3</Address>
@@ -12958,7 +12958,7 @@
 			<ContactElectronicMailAddress>vogt at gis-consult.de</ContactElectronicMailAddress>
 		</ContactInformation>
 		<Fees>none</Fees>
-		<AccessConstraints>Die StraÃƒÆ’Ã…Â¸endaten wurden freundlicherweise vom Landesbetrieb StraÃƒÆ’Ã…Â¸enbau NRW zur VerfÃƒÆ’Ã‚Â¼gung gestellt. Es handelt sich hierbei um einen unvollständigen Datenauszug, der nicht dem aktuellen Stand der NWSIB entspricht.</AccessConstraints>
+		<AccessConstraints>Die Strassendaten wurden freundlicherweise vom Landesbetrieb Strassenbau NRW zur Verfuegung gestellt. Es handelt sich hierbei um einen unvollständigen Datenauszug, der nicht dem aktuellen Stand der NWSIB entspricht.</AccessConstraints>
 	</Service>
 	<Capability>
 		<Request>
@@ -13007,7 +13007,7 @@
 			<Format>application/vnd.ogc.se_xml</Format>
 		</Exception>
 		<Layer queryable="0">
-			<Title>verfÃƒÆ’Ã‚Â¼gbare Layer</Title>
+			<Title>verfuegbare Layer</Title>
 			<SRS>EPSG:31466 EPSG:31467 EPSG:31468 EPSG:31469 EPSG:4326</SRS>
 			<LatLonBoundingBox minx="5.65296386" miny="50.31247805" maxx="9.61606634" maxy="52.54258946"/>
 			<BoundingBox SRS="EPSG:31466" minx="2475321.110" miny="5575227.309" maxx="2745328.607" maxy="5829431.962" resx="1" resy="1"/>
@@ -13033,7 +13033,7 @@
 			</Layer>
 			<Layer queryable="1" opaque="0">
 				<Name>Aeste</Name>
-				<Title>ÃƒÆ’Ã¢â‚¬Å¾ste</Title>
+				<Title>Aeste</Title>
 			</Layer>
 			<Layer queryable="1" opaque="0">
 				<Name>Netzknoten</Name>
@@ -13056,7 +13056,7 @@
 			</Layer>
 			<Layer queryable="1" opaque="0">
 				<Name>Strassenbez.</Name>
-				<Title>StraÃƒÆ’Ã…Â¸enbez.</Title>
+				<Title>Strassenbez.</Title>
 			</Layer>
 			<Layer queryable="1" opaque="0">
 				<Name>Abschnittsnr.</Name>
@@ -13100,12 +13100,12 @@
 				<Title>Rasterkarten</Title>
 				<Layer queryable="0" opaque="1">
 					<Name>Strassenkarte</Name>
-					<Title>StraÃƒÆ’Ã…Â¸enkarte</Title>
+					<Title>Strassenkarte</Title>
 				</Layer>
 			</Layer>
 		</Layer>
 	</Capability>
-</WMT_MS_Capabilities>', NULL, 'http://services.gis-consult.de/NWSIB-online/GCGisService?REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.0', 'none', 'Die StraÃƒÆ’Ã…Â¸endaten wurden freundlicherweise vom Landesbetrieb StraÃƒÆ’Ã…Â¸enbau NRW zur VerfÃƒÆ’Ã‚Â¼gung gestellt. Es handelt sich hierbei um einen unvollständigen Datenauszug, der nicht dem aktuellen Stand der NWSIB entspricht.', 'Christian Vogt', 'GeschäftsfÃƒÆ’Ã‚Â¼hrer', 'GIS Consult GmbH', 'Schultenbusch 3', 'Haltern am See', 'D', '45721', 'Germany', '+49 2364 9218-31', '+49 2364 9218-72', 'vogt at gis-consult.de', NULL, 1, 1173698122, NULL, NULL, NULL, NULL);
+</WMT_MS_Capabilities>', NULL, 'http://services.gis-consult.de/NWSIB-online/GCGisService?REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.0', 'none', 'Die Strassendaten wurden freundlicherweise vom Landesbetrieb Strassenbau NRW zur Verfuegung gestellt. Es handelt sich hierbei um einen unvollständigen Datenauszug, der nicht dem aktuellen Stand der NWSIB entspricht.', 'Christian Vogt', 'Geschäftsfuehrer', 'GIS Consult GmbH', 'Schultenbusch 3', 'Haltern am See', 'D', '45721', 'Germany', '+49 2364 9218-31', '+49 2364 9218-72', 'vogt at gis-consult.de', NULL, 1, 1173698122, NULL, NULL, NULL, NULL);
 INSERT INTO wms (wms_id, wms_version, wms_title, wms_abstract, wms_getcapabilities, wms_getmap, wms_getfeatureinfo, wms_getlegendurl, wms_filter, wms_getcapabilities_doc, wms_owsproxy, wms_upload_url, fees, accessconstraints, contactperson, contactposition, contactorganization, address, city, stateorprovince, postcode, country, contactvoicetelephone, contactfacsimiletelephone, contactelectronicmailaddress, wms_mb_getcapabilities_doc, wms_owner, wms_timestamp, wms_supportsld, wms_userlayer, wms_userstyle, wms_remotewfs) VALUES (671, '1.1.0', 'Wasserschutzgebiete NRW', 'This is an OGC compliant MapService served By ESRI. The engine used to serve this MapService is ArcIMS', 'http://www.gis2.nrw.de/wmsconnector/wms/wsg?', 'http://www.gis2.nrw.de/wmsconnector/wms/wsg?', 'http://www.gis2.nrw.de/wmsconnector/wms/wsg?', '', '', '<?xml version="1.0" encoding="UTF-8"?>
 <!DOCTYPE WMT_MS_Capabilities SYSTEM "http://www.gis2.nrw.de/wmsconnector/schema/wms/1.1.0/capabilities_1_1_0.dtd" [
 <!-- Vendor-specific elements are defined here if needed. -->
@@ -16780,7 +16780,7 @@
 <!ELEMENT VendorSpecificCapabilities EMPTY>
 ]>
 <WMT_MS_Capabilities  version="1.1.1" updateSequence="1.1.0"><Service><Name>OGC:WMS</Name><Title>WMS-Thueringen</Title><Abstract>wms reference implementation</Abstract><KeywordList><Keyword>deegree</Keyword><Keyword>wms</Keyword></KeywordList><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms"/><ContactInformation><ContactPersonPrimary><ContactPerson>F. Engel</ContactPerson><ContactOrganization>Geoinformationszentrum</ContactOrganization></ContactPersonPrimary><ContactPosition>Consultant</ContactPosition><ContactAddress><AddressType/><Address>Hohenwindenstrasse 13a</Address><City>Erfurt</City><StateOrProvince>Thueringen</StateOrProvince><PostCode>99096</PostCode><Country/></ContactAddress><ContactElectronicMailAddress>f.engel at tlverma.thueringen.de</ContactElectronicMailAddress></ContactInformation><Fees>none</Fees><AccessConstraints>none</AccessConstraints></Service><Capability><Request><GetCapabilities><Format>application/vnd.ogc.wms_xml</Format><DCPType><HTTP><Get><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/wms?"/></Get></HTTP></DCPType></GetCapabilities><GetMap><Format>image/png</Format><Format>image/jpeg</Format><Format>image/tif</Format><Format>image/svg+xml</Format><Format>image/bmp</Format><Format>image/gif</Format><Format>image/jpg</Format><DCPType><HTTP><Get><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/wms?"/></Get><Post><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/wms?"/></Post></HTTP></DCPType></GetMap><GetFeatureInfo><Format>text/html</Format><Format>application/vnd.ogc.gml</Format><Format>text/plain</Format><DCPType><HTTP><Get><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/wms?"/></Get></HTTP></DCPType></GetFeatureInfo></Request><Exception><Format>application/vnd.ogc.se_xml</Format><Format>application/vnd.ogc.se_inimage</Format><Format>application/vnd.ogc.se_blank</Format></Exception><Layer queryable="0" cascaded="0" opaque="0" noSubsets="0"><Title>TKVV</Title><Abstract>the top-level-layer of the deegree demo-CD</Abstract><KeywordList><Keyword>deegree</Keyword><Keyword>demo-CD</Keyword><Keyword>layer</Keyword></KeywordList><SRS>EPSG:31468</SRS><LatLonBoundingBox minx="-180.0" miny="-90.0" maxx="180.0" maxy="90.0"/><BoundingBox SRS="EPSG:31468" minx="4500038.056252609" miny="-1.0000959949100513E7" maxx="4500018.656164683" maxy="1.000096364770234E7"/><ScaleHint max="100.0" min="0.1"/><Layer queryable="0" opaque="0" noSubsets="0"><Name>Thueringer_Orthofotos</Name><Title>Thueringer_Orthofotos</Title><Abstract>cascaded WMS layers remote WFS and remote WCS examples</Abstract><LatLonBoundingBox minx="-180.0" miny="-90.0" maxx="180.0" maxy="90.0"/><Style><Name>default:Thueringer_Orthofotos</Name><Title>default:Thueringer_Orthofotos</Title><LegendURL width="20" height="20"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/legend/default_Thueringer_Orthofotos.png"/></LegendURL></Style><ScaleHint max="1.7976931348623157E308" min="0.0"/><Layer queryable="0" opaque="0" noSubsets="0" fixedWidth="0" fixedHeight="0"><Name>Orthophotos_TH-2m</Name><Title>Orthophotos_TH-2m</Title><LatLonBoundingBox minx="-180.0" miny="-90.0" maxx="180.0" maxy="90.0"/><Style><Name>default:Orthophotos_TH-2m</Name><Title>default:Orthophotos_TH-2m</Title><LegendURL width="20" height="20"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/legend/default_Orthophotos_TH-2m.png"/></LegendURL></Style><ScaleHint max="1.7976931348623157E308" min="0.0"/></Layer></Layer><Layer queryable="0" opaque="0" noSubsets="0"><Name>TK50</Name><Title>TK50</Title><Abstract>cascaded WMS layers remote WFS and remote WCS examples</Abstract><LatLonBoundingBox minx="-180.0" miny="-90.0" maxx="180.0" maxy="90.0"/><Style><Name>default:TK50</Name><Title>default:TK50</Title><LegendURL width="20" height="20"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/legend/default_TK50.png"/></LegendURL></Style><ScaleHint max="1.7976931348623157E308" min="0.0"/><Layer queryable="0" opaque="0" noSubsets="0" fixedWidth="0" fixedHeight="0"><Name>Top.Karte_50_gesamt</Name><Title>Top.Karte_50_gesamt</Title><LatLonBoundingBox minx="-180.0" miny="-90.0" maxx="180.0" maxy="90.0"/><Style><Name>default:Top.Karte_50_gesamt</Name><Title>default:Top.Karte_50_gesamt</Title><LegendURL width="20" height="20"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/legend/default_Top.Karte_50_gesamt.png"/></LegendURL></Style><ScaleHint max="1.7976931348623157E308" min="0.0"/></Layer><Layer queryable="0" opaque="0" noSubsets="0" fixedWidth="0" fixedHeight="0"><Name>Grundriss</Name><Title>Grundriss</Title><LatLonBoundingBox minx="-180.0" miny="-90.0" maxx="180.0" maxy="90.0"/><Style><Name>default:Grundriss</Name><Title>default:Grundriss</Title><LegendURL width="20" height="20"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/legend/default_Grundriss.png"/></LegendURL></Style><ScaleHint max="1.7976931348623157E308" min="0.0"/></Layer><Layer queryable="0" opaque="0" noSubsets="0" fixedWidth="0" fixedHeight="0"><Name>Gewaesser</Name><Title>Gewaesser</Title><LatLonBoundingBox minx="-180.0" miny="-90.0" maxx="180.0" maxy="90.0"/><Style><Name>default:Gewaesser</Name><Title>default:Gewaesser</Title><LegendURL width="20" height="20"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/legend/default_Gewaesser.png"/></LegendURL></Style><ScaleHint max="1.7976931348623157E308" min="0.0"/></Layer><Layer queryable="0" opaque="0" noSubsets="0" fixedWidth="0" fixedHeight="0"><Name>Hoehenschichten</Name><Title>Hoehenschichten</Title><LatLonBoundingBox minx="-180.0" miny="-90.0" maxx="180.0" maxy="90.0"/><Style><Name>default:Hoehenschichten</Name><Title>default:Hoehenschichten</Title><LegendURL width="20" height="20"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/legend/default_Hoehenschichten.png"/></LegendURL></Style><ScaleHint max="1.7976931348623157E308" min="0.0"/></Layer><Layer queryable="0" opaque="0" noSubsets="0" fixedWidth="0" fixedHeight="0"><Name>Strassen</Name><Title>Strassen</Title><LatLonBoundingBox minx="-180.0" miny="-90.0" maxx="180.0" maxy="90.0"/><Style><Name>default:Strassen</Name><Title>default:Strassen</Title><LegendURL width="20" height="20"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/legend/default_Strassen.png"/></LegendURL></Style><ScaleHint max="1.7976931348623157E308" min="0.0"/></Layer><Layer queryable="0" opaque="0" noSubsets="0" fixedWidth="0" fixedHeight="0"><Name>Wald</Name><Title>Wald</Title><LatLonBoundingBox minx="-180.0" miny="-90.0" maxx="180.0" maxy="90.0"/><Style><Name>default:Wald</Name><Title>default:Wald</Title><LegendURL width="20" height="20"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/legend/default_Wald.png"/></LegendURL></Style><ScaleHint max="1.7976931348623157E308" min="0.0"/></Layer></Layer></Layer></Capability></WMT_MS_Capabilities>', NULL, 'http://www.webmap-test.thueringen.de/deegreewms/wms?REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.1', 'none', 'none', 'F. Engel', 'Consultant', 'Geoinformationszentrum', 'Hohenwindenstrasse 13a', 'Erfurt', 'Thueringen', '99096', '', '', '', 'f.engel at tlverma.thueringen.de', NULL, 1, 1173698125, NULL, NULL, NULL, NULL);
-INSERT INTO wms (wms_id, wms_version, wms_title, wms_abstract, wms_getcapabilities, wms_getmap, wms_getfeatureinfo, wms_getlegendurl, wms_filter, wms_getcapabilities_doc, wms_owsproxy, wms_upload_url, fees, accessconstraints, contactperson, contactposition, contactorganization, address, city, stateorprovince, postcode, country, contactvoicetelephone, contactfacsimiletelephone, contactelectronicmailaddress, wms_mb_getcapabilities_doc, wms_owner, wms_timestamp, wms_supportsld, wms_userlayer, wms_userstyle, wms_remotewfs) VALUES (908, '1.1.0', 'NRW: TK100 Farbe', 'Nutzungsbedingungen: Sämtliche Rechte an diesem Produkt liegen beim Landesvermessungsamt NRW. Die Nutzung ist bis auf Widerruf kostenfrei. Der Nutzer muss sich vor jeder Nutzung beim Landesvermessungsamt NRW identifizieren und seine spezielle Nutzung mit Angabe des Verwendungszwecks und Umfang der Nutzung anmelden (KontaktmÃƒÆ’Ã‚Â¶glichkeiten zum Landesvermessungsamt NRW siehe unten). Die Nutzung ist ausschlieÃƒÆ’Ã…Â¸lich fÃƒÆ’Ã‚Â¼r Testzwecke und im Rahmen von GDI-Projekten zulässig; die Nutzung fÃƒÆ’Ã‚Â¼r kommerzielle Anwendungen ist ausdrÃƒÆ’Ã‚Â¼cklich ausgeschlossen. Die mittelbare oder unmittelbare Weitergabe der Daten an Dritte ist auch in Verbindung mit weiteren Daten ohne ausdrÃƒÆ’Ã‚Â¼ckliche Genehmigung durch das Landesvermessungsamt NRW nicht zulässig. Der Nutzer ist verpflichtet, einen deutlichen Copyright-Hinweis auf das Landesvermessungsamt NRW als DateneigentÃƒÆ’Ã‚Â¼mer bei Visualisierungen jeder Art anzubringen.', 'http://www.geoserver.nrw.de:80/GeoOgcWms1.3/servlet/TK100', 'http://www.geoserver.nrw.de:80/GeoOgcWms1.3/servlet/TK100', 'http://www.geoserver.nrw.de:80/GeoOgcWms1.3/servlet/TK100', '', NULL, '<?xml version=''1.0'' encoding="ISO-8859-1" standalone="no" ?> 
+INSERT INTO wms (wms_id, wms_version, wms_title, wms_abstract, wms_getcapabilities, wms_getmap, wms_getfeatureinfo, wms_getlegendurl, wms_filter, wms_getcapabilities_doc, wms_owsproxy, wms_upload_url, fees, accessconstraints, contactperson, contactposition, contactorganization, address, city, stateorprovince, postcode, country, contactvoicetelephone, contactfacsimiletelephone, contactelectronicmailaddress, wms_mb_getcapabilities_doc, wms_owner, wms_timestamp, wms_supportsld, wms_userlayer, wms_userstyle, wms_remotewfs) VALUES (908, '1.1.0', 'NRW: TK100 Farbe', 'Nutzungsbedingungen: Sämtliche Rechte an diesem Produkt liegen beim Landesvermessungsamt NRW. Die Nutzung ist bis auf Widerruf kostenfrei. Der Nutzer muss sich vor jeder Nutzung beim Landesvermessungsamt NRW identifizieren und seine spezielle Nutzung mit Angabe des Verwendungszwecks und Umfang der Nutzung anmelden (Kontaktmoeglichkeiten zum Landesvermessungsamt NRW siehe unten). Die Nutzung ist ausschliesslich fuer Testzwecke und im Rahmen von GDI-Projekten zulässig; die Nutzung fuer kommerzielle Anwendungen ist ausdruecklich ausgeschlossen. Die mittelbare oder unmittelbare Weitergabe der Daten an Dritte ist auch in Verbindung mit weiteren Daten ohne ausdrueckliche Genehmigung durch das Landesvermessungsamt NRW nicht zulässig. Der Nutzer ist verpflichtet, einen deutlichen Copyright-Hinweis auf das Landesvermessungsamt NRW als Dateneigentuemer bei Visualisierungen jeder Art anzubringen.', 'http://www.geoserver.nrw.de:80/GeoOgcWms1.3/servlet/TK100', 'http://www.geoserver.nrw.de:80/GeoOgcWms1.3/servlet/TK100', 'http://www.geoserver.nrw.de:80/GeoOgcWms1.3/servlet/TK100', '', NULL, '<?xml version=''1.0'' encoding="ISO-8859-1" standalone="no" ?> 
 <!-- The DTD (Document Type Definition) given here must correspond to the version number declared in the WMT_MS_Capabilities element below. -->
 <!DOCTYPE WMT_MS_Capabilities SYSTEM 
   "http://www.geoserver.nrw.de/wmt/xml/capabilities_1_1_0.dtd"
@@ -16799,7 +16799,7 @@
   <!-- Human-readable title for pick lists -->
   <Title>NRW: TK100 Farbe</Title>
   <!-- Narrative description providing additional information -->
-      <Abstract>Nutzungsbedingungen: Sämtliche Rechte an diesem Produkt liegen beim Landesvermessungsamt NRW. Die Nutzung ist bis auf Widerruf kostenfrei. Der Nutzer muss sich vor jeder Nutzung beim Landesvermessungsamt NRW identifizieren und seine spezielle Nutzung mit Angabe des Verwendungszwecks und Umfang der Nutzung anmelden (KontaktmÃƒÆ’Ã‚Â¶glichkeiten zum Landesvermessungsamt NRW siehe unten). Die Nutzung ist ausschlieÃƒÆ’Ã…Â¸lich fÃƒÆ’Ã‚Â¼r Testzwecke und im Rahmen von GDI-Projekten zulässig; die Nutzung fÃƒÆ’Ã‚Â¼r kommerzielle Anwendungen ist ausdrÃƒÆ’Ã‚Â¼cklich ausgeschlossen. Die mittelbare oder unmittelbare Weitergabe der Daten an Dritte ist auch in Verbindung mit weiteren Daten ohne ausdrÃƒÆ’Ã‚Â¼ckliche Genehmigung durch das Landesvermessungsamt NRW nicht zulässig. Der Nutzer ist verpflichtet, einen deutlichen Copyright-Hinweis auf das Landesvermessungsamt NRW als DateneigentÃƒÆ’Ã‚Â¼mer bei Visualisierungen jeder Art anzubringen.</Abstract>
+      <Abstract>Nutzungsbedingungen: Sämtliche Rechte an diesem Produkt liegen beim Landesvermessungsamt NRW. Die Nutzung ist bis auf Widerruf kostenfrei. Der Nutzer muss sich vor jeder Nutzung beim Landesvermessungsamt NRW identifizieren und seine spezielle Nutzung mit Angabe des Verwendungszwecks und Umfang der Nutzung anmelden (Kontaktmoeglichkeiten zum Landesvermessungsamt NRW siehe unten). Die Nutzung ist ausschliesslich fuer Testzwecke und im Rahmen von GDI-Projekten zulässig; die Nutzung fuer kommerzielle Anwendungen ist ausdruecklich ausgeschlossen. Die mittelbare oder unmittelbare Weitergabe der Daten an Dritte ist auch in Verbindung mit weiteren Daten ohne ausdrueckliche Genehmigung durch das Landesvermessungsamt NRW nicht zulässig. Der Nutzer ist verpflichtet, einen deutlichen Copyright-Hinweis auf das Landesvermessungsamt NRW als Dateneigentuemer bei Visualisierungen jeder Art anzubringen.</Abstract>
       <!-- Top-level web address of service or service provider.  See also OnlineResource
   elements under <DCPType>. -->
       
@@ -18987,8 +18987,8 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>lwas</Name>
-        <Title>FlÃƒÆ’Ã‚Â¼sse und Kanäle</Title>
-        <Abstract>FlÃƒÆ’Ã‚Â¼sse und Kanäle</Abstract>
+        <Title>Fluesse und Kanäle</Title>
+        <Abstract>Fluesse und Kanäle</Abstract>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.2394" miny="51.3212" maxx="14.7654" maxy="53.5254" />
         <BoundingBox SRS="EPSG:25833"
@@ -19017,8 +19017,8 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>kstr</Name>
-        <Title>KreisstraÃƒÆ’Ã…Â¸en</Title>
-        <Abstract>KreisstraÃƒÆ’Ã…Â¸en</Abstract>
+        <Title>Kreisstrassen</Title>
+        <Abstract>Kreisstrassen</Abstract>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.2393" miny="51.3127" maxx="14.7641" maxy="53.5593" />
         <BoundingBox SRS="EPSG:25833"
@@ -19027,8 +19027,8 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>lstr</Name>
-        <Title>LandesstraÃƒÆ’Ã…Â¸en</Title>
-        <Abstract>LandesstraÃƒÆ’Ã…Â¸en</Abstract>
+        <Title>Landesstrassen</Title>
+        <Abstract>Landesstrassen</Abstract>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.3238" miny="51.3172" maxx="14.7548" maxy="53.5632" />
         <BoundingBox SRS="EPSG:25833"
@@ -19037,8 +19037,8 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>bstr</Name>
-        <Title>BundesstraÃƒÆ’Ã…Â¸en</Title>
-        <Abstract>BundesstraÃƒÆ’Ã…Â¸en</Abstract>
+        <Title>Bundesstrassen</Title>
+        <Abstract>Bundesstrassen</Abstract>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.2459" miny="51.3585" maxx="14.7403" maxy="53.4965" />
         <BoundingBox SRS="EPSG:25833"
@@ -20758,8 +20758,8 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>lwas</Name>
-        <Title>FlÃƒÆ’Ã‚Â¼sse und Kanäle</Title>
-        <Abstract>FlÃƒÆ’Ã‚Â¼sse und Kanäle</Abstract>
+        <Title>Fluesse und Kanäle</Title>
+        <Abstract>Fluesse und Kanäle</Abstract>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.3337" miny="51.3295" maxx="14.6826" maxy="53.4539" />
         <BoundingBox SRS="EPSG:25833"
@@ -20788,8 +20788,8 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>lstr</Name>
-        <Title>LandesstraÃƒÆ’Ã…Â¸en</Title>
-        <Abstract>LandesstraÃƒÆ’Ã…Â¸en</Abstract>
+        <Title>Landesstrassen</Title>
+        <Abstract>Landesstrassen</Abstract>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.3234" miny="51.318" maxx="14.7561" maxy="53.5644" />
         <BoundingBox SRS="EPSG:25833"
@@ -20798,8 +20798,8 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>bstr</Name>
-        <Title>BundesstraÃƒÆ’Ã…Â¸en</Title>
-        <Abstract>BundesstraÃƒÆ’Ã…Â¸en</Abstract>
+        <Title>Bundesstrassen</Title>
+        <Abstract>Bundesstrassen</Abstract>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.2485" miny="51.3577" maxx="14.747" maxy="53.4523" />
         <BoundingBox SRS="EPSG:25833"
@@ -20853,7 +20853,7 @@
     <ContactAddress>
         <AddressType></AddressType>
         <Address>Albersloher Weg 33</Address>
-        <City>MÃƒÆ’Ã‚Â¼nster</City>
+        <City>Muenster</City>
         <StateOrProvince></StateOrProvince>
         <PostCode>48155</PostCode>
         <Country>Germany</Country>
@@ -20999,7 +20999,7 @@
   </Layer>
 </Capability>
 </WMT_MS_Capabilities>
-', NULL, 'http://geo.stadt-muenster.de/cgi-bin/geobasis?REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.0', 'none', 'none', 'Norbert Dephoff', '', 'Vermessungs- und Katasteramt', 'Albersloher Weg 33', 'MÃƒÆ’Ã‚Â¼nster', '', '48155', 'Germany', '', '', 'dephoffn at stadt-muenster.de', NULL, 1, 1173698462, NULL, NULL, NULL, NULL);
+', NULL, 'http://geo.stadt-muenster.de/cgi-bin/geobasis?REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.0', 'none', 'none', 'Norbert Dephoff', '', 'Vermessungs- und Katasteramt', 'Albersloher Weg 33', 'Muenster', '', '48155', 'Germany', '', '', 'dephoffn at stadt-muenster.de', NULL, 1, 1173698462, NULL, NULL, NULL, NULL);
 INSERT INTO wms (wms_id, wms_version, wms_title, wms_abstract, wms_getcapabilities, wms_getmap, wms_getfeatureinfo, wms_getlegendurl, wms_filter, wms_getcapabilities_doc, wms_owsproxy, wms_upload_url, fees, accessconstraints, contactperson, contactposition, contactorganization, address, city, stateorprovince, postcode, country, contactvoicetelephone, contactfacsimiletelephone, contactelectronicmailaddress, wms_mb_getcapabilities_doc, wms_owner, wms_timestamp, wms_supportsld, wms_userlayer, wms_userstyle, wms_remotewfs) VALUES (906, '1.1.0', 'DNM VG', 'Digitales Navigationsmodell Verwaltungsgrenzen als Basisnavigationsdaten der Brandenburger Landesvermessung', 'http://geoservice.geobasis-bb.de/cgi-bin/proxy?USER_ID=GAST12345678&map=wms/DNMVG.map&', 'http://geoservice.geobasis-bb.de/cgi-bin/proxy?USER_ID=GAST12345678&map=wms/DNMVG.map&', 'http://geoservice.geobasis-bb.de/cgi-bin/proxy?USER_ID=GAST12345678&map=wms/DNMVG.map&', '', NULL, '<?xml version=''1.0'' encoding="ISO-8859-1" standalone="no" ?>
 <!DOCTYPE WMT_MS_Capabilities SYSTEM "http://www.digitalearth.gov/wmt/xml/capabilities_1_1_0.dtd"
  [
@@ -21107,7 +21107,7 @@
     </Layer>
     <Layer queryable="1" opaque="0" cascaded="0">
         <Name>amt</Name>
-        <Title>ÃƒÆ’Ã¢â‚¬Å¾mter</Title>
+        <Title>Aemter</Title>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.2423" miny="51.3099" maxx="14.7656" maxy="53.4443" />
         <BoundingBox SRS="EPSG:25833"
@@ -21170,7 +21170,7 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>namt</Name>
-        <Title>Namen der ÃƒÆ’Ã¢â‚¬Å¾mter</Title>
+        <Title>Namen der Aemter</Title>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.2423" miny="51.3099" maxx="14.7656" maxy="53.4443" />
         <BoundingBox SRS="EPSG:25833"

Modified: branches/2.5/resources/db/postgresql/utf8/pgsql_data.sql
===================================================================
--- branches/2.5/resources/db/postgresql/utf8/pgsql_data.sql	2008-09-30 13:30:38 UTC (rev 3060)
+++ branches/2.5/resources/db/postgresql/utf8/pgsql_data.sql	2008-09-30 14:42:25 UTC (rev 3061)
@@ -50,7 +50,7 @@
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('wms_worldwide', 'body', 1, 1, 'obligatory body', NULL, 'body', '', '', 0, 0, 0, 0, 0, '', '', 'body', '', '', '', '', NULL);
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('wms_africa', 'content', 2, 1, 'text', NULL, 'div', '', '', 10, 50, 500, 30, 2, 'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;', E'This GUI is an OGC service catalog container and does not provide a map user interface. Please use the  (<a href=\\''javascript:history.back()\\''>back</a>) link to select another GUI form your list or log off to log on using another account (identity).<br><br>Diese GUI ist ein OGC Service Katalog Beh&auml;lter (Eimer, Container, nimm was Du meinst) und beinhaltet keine Kartenoberfl&auml;che. Verwenden Sie diesen (<a href=\\''javascript:history.back()\\''>back</a>)  Verweis, um aus der Liste eine andere GUI auszuw&auml;hlen oder melden Sie sich ab, um sich mit einer anderen Kennung anzumelden. ', 'div', '', '', '', '', NULL);
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('wms_australia', 'logout', 2, 1, 'Logout', NULL, 'img', '../img/button_gray/logout_off.png', 'onClick="window.location.href=''../php/mod_logout.php?sessionID''" border=''0''onmouseover=''this.src="../img/button_gray/logout_over.png"''onmouseout=''this.src="../img/button_gray/logout_off.png"'' title="Logout"', 5, 5, 24, 24, 1, '', '', '', '', '', '', '', 'http://www.mapbender.org/index.php/logout');
-INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('wms_australia', 'content', 2, 1, 'text', NULL, 'div', '', '', 10, 50, 500, 30, 2, 'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;', 'This GUI is an OGC service catalog container and does not provide a map user interface. Please use the  (<a href=''javascript:history.back()''>back</a>) link to select another GUI form your list or log off to log on using another account (identity).<br><br>Diese GUI ist ein OGC Service Katalog BehÃƒÆ’Ã‚Â¤lter (Eimer, Container, nimm was Du meinst) und beinhaltet keine KartenoberflÃƒÆ’Ã‚Â¤che. Verwenden Sie diesen (<a href=''javascript:history.back()''>back</a>)  Verweis, um aus der Liste eine andere GUI auszuwählen oder melden Sie sich ab, um sich mit einer anderen Kennung anzumelden. ', 'div', '', '', '', '', '');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('wms_australia', 'content', 2, 1, 'text', NULL, 'div', '', '', 10, 50, 500, 30, 2, 'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;', 'This GUI is an OGC service catalog container and does not provide a map user interface. Please use the  (<a href=''javascript:history.back()''>back</a>) link to select another GUI form your list or log off to log on using another account (identity).<br><br>Diese GUI ist ein OGC Service Katalog Behaelter (Eimer, Container, nimm was Du meinst) und beinhaltet keine Kartenoberflaeche. Verwenden Sie diesen (<a href=''javascript:history.back()''>back</a>)  Verweis, um aus der Liste eine andere GUI auszuwählen oder melden Sie sich ab, um sich mit einer anderen Kennung anzumelden. ', 'div', '', '', '', '', '');
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('wms_australia', 'body', 1, 1, 'obligatory body', NULL, 'body', '', '', 0, 0, NULL, NULL, NULL, '', '', 'body', '', '', '', '', '');
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('wms_europe', 'logout', 2, 1, 'Logout', NULL, 'img', '../img/button_gray/logout_off.png', 'onClick="window.location.href=''../php/mod_logout.php?sessionID''" border=''0''onmouseover=''this.src="../img/button_gray/logout_over.png"''onmouseout=''this.src="../img/button_gray/logout_off.png"'' title="Logout"', 5, 5, 24, 24, 1, '', '', '', '', '', '', '', 'http://www.mapbender.org/index.php/logout');
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('wms_europe', 'body', 1, 1, 'obligatory body', NULL, 'body', '', '', 0, 0, NULL, NULL, NULL, '', '', 'body', '', '', '', '', '');
@@ -382,7 +382,7 @@
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('admin1', 'user_gui', 2, 1, 'allocate guis to user', '', 'a', '', 'href = "../php/mod_user_gui.php?sessionID&e_id_css=user_gui" target = "AdminFrame" ', 10, 370, 200, 20, 0, 'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;', 'USER -> GUI ', 'a', '', '', '', 'AdminFrame', '');
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('admin1', 'wfs_conf', 2, 1, 'create and edit a gazetteer module', 'Configure WFS', 'a', '', 'href="../php/mod_wfs_conf.php?sessionID"'' target="AdminFrame"', 10, 870, 200, 20, NULL, 'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;', 'WFS CONF', 'a', '', '', '', 'AdminFrame', '');
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('admin1', 'wfs_gui', 2, 1, 'edit wfs settings', 'Assign WFS conf to gui', 'a', '', 'href = "../javascripts/mod_wfs_client.html" target="AdminFrame"', 10, 1000, 250, 20, NULL, 'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;', 'asign WFS conf to gui', 'a', '', '', '', 'AdminFrame', '');
-INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('admin2_de', 'AdminFrame', 2, 1, 'Bereich fÃ¼r Administrationsmodule', '', 'iframe', '', 'frameborder = "0"', 200, 20, 980, 800, NULL, '', '', 'iframe', '', '', '', '', '');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('admin2_de', 'AdminFrame', 2, 1, 'Bereich fuer Administrationsmodule', '', 'iframe', '', 'frameborder = "0"', 200, 20, 980, 800, NULL, '', '', 'iframe', '', '', '', '', '');
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('admin2_de', 'CreateTreeGDE', 2, 1, 'Ordnerbaum konfigurieren', 'Create treeGDE', 'a', '', 'href = "../php/nestedSets.php?sessionID" target = "AdminFrame" ', 8, 280, 190, 20, 5, '', 'Ordnerbaum konfigurieren', 'a', '', '', '', 'AdminFrame', 'http://www.mapbender.org/index.php/ConfTreeGde');
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('admin2_de', 'body', 1, 1, 'Navigation', '', 'body', '', 'onload=''mod_adminNavigation_init()''', 0, 0, 180, 20, 0, '', '', '', 'mod_adminNavigation.js', '', '', '', '');
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES ('admin2_de', 'deleteWMS', 2, 1, '!Vollständig löschen!', 'Delete WMS completely', 'a', '', 'href = "../php/mod_deleteWMS.php?sessionID" target = "AdminFrame" ', 8, 100, 190, 20, 5, '', '!Vollständig löschen!', 'a', '', '', '', 'AdminFrame', 'http://www.mapbender.org/index.php/DeleteWMS');
@@ -2694,8 +2694,8 @@
 INSERT INTO keyword (keyword_id, keyword) VALUES (41, 'GIS');
 INSERT INTO keyword (keyword_id, keyword) VALUES (42, 'GDI NRW');
 INSERT INTO keyword (keyword_id, keyword) VALUES (43, 'NWSIB');
-INSERT INTO keyword (keyword_id, keyword) VALUES (44, 'klassifiziertes StraÃƒÆ’Ã…Â¸ennetz');
-INSERT INTO keyword (keyword_id, keyword) VALUES (45, 'Anweisung StraÃƒÆ’Ã…Â¸eninformationsbank ASB');
+INSERT INTO keyword (keyword_id, keyword) VALUES (44, 'klassifiziertes Strassennetz');
+INSERT INTO keyword (keyword_id, keyword) VALUES (45, 'Anweisung Strasseninformationsbank ASB');
 INSERT INTO keyword (keyword_id, keyword) VALUES (46, 'Netzknoten-Stationierungssystem');
 INSERT INTO keyword (keyword_id, keyword) VALUES (47, 'birds');
 INSERT INTO keyword (keyword_id, keyword) VALUES (48, 'distribution');
@@ -2713,8 +2713,8 @@
 INSERT INTO keyword (keyword_id, keyword) VALUES (60, 'volunteers');
 INSERT INTO keyword (keyword_id, keyword) VALUES (61, 'cbc');
 INSERT INTO keyword (keyword_id, keyword) VALUES (62, 'christmas');
-INSERT INTO keyword (keyword_id, keyword) VALUES (63, 'SÃƒâ€¦Ã¢â‚¬Å¡ubfurt');
-INSERT INTO keyword (keyword_id, keyword) VALUES (64, 'SÃƒâ€¦Ã¢â‚¬Å¡ubice');
+INSERT INTO keyword (keyword_id, keyword) VALUES (63, 'Slubfurt');
+INSERT INTO keyword (keyword_id, keyword) VALUES (64, 'Slubice');
 INSERT INTO keyword (keyword_id, keyword) VALUES (65, 'Frankfurt (Oder)');
 INSERT INTO keyword (keyword_id, keyword) VALUES (66, 'topophilia');
 INSERT INTO keyword (keyword_id, keyword) VALUES (67, 'mental maps');
@@ -2891,7 +2891,7 @@
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (10174, 640, 13, '0', 'huemapped_srtm', 'SRTM derived global elevation, 3 arc-second, hue mapped', 0, 90198, 0, '', '', ' An SRTM derived elevation dataset, where elevation is mapped to hue, resulting a color image');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (10175, 640, 14, '0', 'srtmplus', 'Global 1km elevation, seamless SRTM land elevation and ocean depth', 0, 1002199, 0, '', '', ' 	The SRTM30 Plus dataset, a 30 arc-second seamless combination of GTOPO30, SRTM derived land elevation and UCSD Sandwell bathymetry data.  The default style is scaled to 8 bit, non-linear.  It is possible to request the elevation data in meters by the short_int tyle and requesting PNG format.  The resulting PNG file will be a unsigned 16 bit per pixel image. The values are then the elevation in meters.  Values are signed 16 bit integers, but PNG will present them as unsigned, any values larger than 32767 should be interpreted as negative numbers.  For elevation values in feet, request PNG format with the style feet_short_int.       ');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (10176, 640, 15, '0', 'worldwind_dem', 'SRTM derived global elevation, 3 arc-second', 0, 90198, 0, '', '', ' 	A global elevation model, prepared from the 3 arc-second SRTM dataset by filling some of the problem areas. Prepared by the NASA Learning Technologies. 	The default style is scaled to 8 bit, non-linear. 	It is possible to request the elevation data in meters by the short_int tyle and requesting PNG format. The resulting PNG file will be a unsigned 16 bit per pixel image. The values are then the elevation in meters. 	Values are signed 16 bit integers, but PNG will present them as unsigned, leading to a few areas with very large values (65000+) 	For elevation values in feet, request PNG format with the style feet_short_int.       ');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19255, 828, 7, '0', 'Puntos_geodÃƒÆ’Ã‚Â©sicos', 'Puntos_geodÃƒÆ’Ã‚Â©sicos', 1, 0, 0, '', '', '');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19255, 828, 7, '0', 'Puntos_geodesicos', 'Puntos_geodesicos', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19176, 250, 0, '', 'Demis World Map', 'Demis World Map', 0, 0, 0, '', '', 'None');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (2713, 250, 1, '0', 'Bathymetry', 'Bathymetry', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (2714, 250, 2, '0', 'Countries', 'Countries', 1, 0, 0, '', '', '');
@@ -3068,17 +3068,17 @@
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19241, 789, 18, '0', 'tk10', 'TK 10', 0, 94, 4691, '', '', 'FREETK:MS:FREETK:');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19242, 789, 19, '18', 'tk10w', 'TK 10 - Gewaesser', 0, 0, 0, '', '', 'FREETK:MS:FREETK:RASTER TK10GEW');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19243, 789, 20, '18', 'tk10i', 'TK 10 - Hoehenlinien', 0, 0, 0, '', '', 'FREETK:MS:FREETK:RASTER TK10ISO');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19190, 328, 0, '', 'verfÃƒÆ’Ã‚Â¼gbare Layer', 'verfÃƒÆ’Ã‚Â¼gbare Layer', 0, 0, 0, '', '', 'Web Map Service auf Basis des Smallworld GIS');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19190, 328, 0, '', 'verfuegbare Layer', 'verfuegbare Layer', 0, 0, 0, '', '', 'Web Map Service auf Basis des Smallworld GIS');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3385, 328, 1, '0', 'Autobahn', 'Autobahn', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3386, 328, 2, '0', 'Bundesstr.', 'Bundesstr.', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3387, 328, 3, '0', 'Landesstr.', 'Landesstr.', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3388, 328, 4, '0', 'Kreisstr.', 'Kreisstr.', 1, 0, 0, '', '', '');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3393, 328, 5, '0', 'Aeste', 'ÃƒÆ’Ã¢â‚¬Å¾ste', 1, 0, 0, '', '', '');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3393, 328, 5, '0', 'Aeste', 'Aeste', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19191, 328, 6, '0', 'Netzknoten', 'Netzknoten', 1, 0, 68150, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19192, 328, 7, '0', 'Nullpunkte', 'Nullpunkte', 1, 0, 50110, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19193, 328, 8, '0', 'AS-Nummern', 'AS-Nummern', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19194, 328, 9, '0', 'AS-Namen', 'AS-Namen', 1, 0, 68150, '', '', '');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19195, 328, 10, '0', 'Strassenbez.', 'StraÃƒÆ’Ã…Â¸enbez.', 1, 0, 0, '', '', '');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19195, 328, 10, '0', 'Strassenbez.', 'Strassenbez.', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19196, 328, 11, '0', 'Abschnittsnr.', 'Abschnittsnr.', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3391, 328, 12, '0', 'Bauwerke', 'Bauwerke', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19197, 328, 13, '12', 'Bauwerkslage', 'Bauwerkslage', 1, 0, 50110, '', '', '');
@@ -3089,7 +3089,7 @@
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19202, 328, 18, '15', 'Kreise_/_kreisfreie_Staedte', 'Kreise / kreisfreie Städte', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19203, 328, 19, '15', 'Gemeinden', 'Gemeinden', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19204, 328, 20, '0', 'Rasterkarten', 'Rasterkarten', 0, 0, 0, '', '', '');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19205, 328, 21, '20', 'Strassenkarte', 'StraÃƒÆ’Ã…Â¸enkarte', 0, 0, 0, '', '', '');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19205, 328, 21, '20', 'Strassenkarte', 'Strassenkarte', 0, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (7523, 584, 6, '0', 'OBBA_SQUARE', 'Ontario Breeding Bird Atlas 10 km Squares', 1, 0, 0, '', '', 'A sampling unit used by the Ontario Breeding Bird Atlas to collect breeding evidence data for all bird species within the Province of Ontario.  Squares are based upon the Universal Transverse Mercator (UTM) grid system, NAD83, and measure 10Km by 10Km except near UTM zone boundaries, where they are smaller.');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (7524, 584, 7, '0', 'OBBA_REGION', 'Ontario Breeding Bird Atlas Administrative Regions', 1, 0, 0, '', '', 'An administrative unit that is used for local bird atlas co-ordination, which is based on bioregions and access.  Each region is assigned a Regional Coordinator who administers bird surveys within their region.');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (7525, 584, 8, '0', 'OBBA_BLOCK', 'Ontario Breeding Bird Atlas 100 km Blocks', 1, 0, 0, '', '', 'A sampling unit used by the Ontario Breeding Bird Atlas to collect breeding evidence data for all bird species within the Province of Ontario.  Blocks are based upon the Universal Transverse Mercator (UTM) grid system, NAD83, and measure 100Km by 100Km except near UTM zone boundaries, where they are smaller.');
@@ -3097,9 +3097,9 @@
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (7527, 584, 10, '0', 'BBS_PT', 'Breeding Bird Survey Route Start Points', 1, 0, 0, '', '', 'The Breeding Bird Survey, initiated in 1966, is one of the oldest surveys of breeding birds in North America. It is conducted primarily by volunteers, who follow a predetermined, roadside route each year at the height of the breeding season.  This layer portrays the start point for each BBS route in Canada.');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19228, 834, 0, '', 'DE_aerial02', 'DE_aerial02', 0, 0, 0, '', '', 'The Delaware 2002 Aerial Imagery Map Service serves statewide orthophotography as captured in 2002. The State of Delaware contracted with EarthData International to develop 0.25-meter resolution color infrared digital ortho-photos for the entire state. Map scale of the photography is approximately 1:2,400. Airphotos were taken in March and April, 2002, digitized and georeferenced to Delaware State Plane NAD83 meters. This data is available as an ArcIMS map service, a WMS map service, original 1-meter raw data files. ');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19246, 828, 0, '', 'CAPAS', 'CAPAS', 0, 0, 0, '', '', 'IDERIOJA Gobierno de La Rioja OGC WMS');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19247, 828, 1, '0', 'Elementos_hidrogrÃƒÆ’Ã‚Â¡ficos', 'Elementos_hidrogrÃƒÆ’Ã‚Â¡ficos', 1, 0, 0, '', '', '');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19248, 828, 2, '0', 'Hojas_cartogrÃƒÆ’Ã‚Â¡ficas_1-5000', 'Hojas_cartogrÃƒÆ’Ã‚Â¡ficas_1-5000', 1, 0, 0, '', '', '');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19249, 828, 3, '0', 'Manzanas_de_los_nÃƒÆ’Ã‚Âºcleos_urbanos', 'Manzanas_de_los_nÃƒÆ’Ã‚Âºcleos_urbanos', 1, 0, 0, '', '', '');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19247, 828, 1, '0', 'Elementos_hidrograficos', 'Elementos_hidrograficos', 1, 0, 0, '', '', '');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19248, 828, 2, '0', 'Hojas_cartograficas_1-5000', 'Hojas_cartograficas_1-5000', 1, 0, 0, '', '', '');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19249, 828, 3, '0', 'Manzanas_de_los_nucleos_urbanos', 'Manzanas_de_los_nucleos_urbanos', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (10106, 634, 0, '', 'Location', 'Point locations', 0, 0, 0, '', '', 'This service provides approximate point locations for various     themes.   ');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (10107, 634, 1, '0', 'city_austral', 'Australasian Cities', 0, 0, 0, '', '', '           Location of cities in the Australasian region.         ');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (10108, 634, 2, '0', 'capital_aus', 'Australian Capital Cities', 0, 0, 0, '', '', '           Location of capital cities in Australia.         ');
@@ -3159,7 +3159,7 @@
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19006, 893, 0, '', 'Germany', 'Germany', 0, 1, 0, '', '', 'Germany');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19007, 893, 1, '0', 'Topographie', 'topography', 0, 0, 0, 'http://www.mapbender.de/', 'http://www.mapbender.de/', 'Topographie,Landschaft');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (7519, 584, 2, '0', 'CBC_PT', 'Canadian Christmas Bird Count Locations', 1, 0, 0, '', '', 'A winter survey of bird populations conducted during the Christmas period - December 14 to January 5th inclusive.  More than 1800 counts are conducted each year across Canada, the United States and Latin America.  On a selected day within the count period, local birders count as many birds as possible within a 24 km (15 mile) diameter circle.  The Christmas Bird Count had long been organized on the continental scale by the New York-based National Audubon Society. In 2000, Audubon finalized an agreement with Bird Studies Canada that would see BSC partner with Audubon to coordinate CBCs in Canada.  This layer represents the centre point of all the Christmas Bird Counts conducted in Canada.  An accompanying layer (CBC_PY) contains the 24 km circles.');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19170, 908, 0, '', 'NRW', 'NRW', 0, 0, 140316, '', '', 'Nutzungsbedingungen: Sämtliche Rechte an diesem Produkt liegen beim Landesvermessungsamt NRW. Die Nutzung ist bis auf Widerruf kostenfrei. Der Nutzer muss sich vor jeder Nutzung beim Landesvermessungsamt NRW identifizieren und seine spezielle Nutzung mit Angabe des Verwendungszwecks und Umfang der Nutzung anmelden (KontaktmÃƒÆ’Ã‚Â¶glichkeiten zum Landesvermessungsamt NRW siehe unten). Die Nutzung ist ausschlieÃƒÆ’Ã…Â¸lich fÃƒÆ’Ã‚Â¼r Testzwecke und im Rahmen von GDI-Projekten zulässig; die Nutzung fÃƒÆ’Ã‚Â¼r kommerzielle Anwendungen ist ausdrÃƒÆ’Ã‚Â¼cklich ausgeschlossen. Die mittelbare oder unmittelbare Weitergabe der Daten an Dritte ist auch in Verbindung mit weiteren Daten ohne ausdrÃƒÆ’Ã‚Â¼ckliche Genehmigung durch das Landesvermessungsamt NRW nicht zulässig. Der Nutzer ist verpflichtet, einen deutlichen Copyright-Hinweis auf das Landesvermessungsamt NRW als DateneigentÃƒÆ’Ã‚Â¼mer bei Visualisierungen jeder Art anzubringen.');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19170, 908, 0, '', 'NRW', 'NRW', 0, 0, 140316, '', '', 'Nutzungsbedingungen: Sämtliche Rechte an diesem Produkt liegen beim Landesvermessungsamt NRW. Die Nutzung ist bis auf Widerruf kostenfrei. Der Nutzer muss sich vor jeder Nutzung beim Landesvermessungsamt NRW identifizieren und seine spezielle Nutzung mit Angabe des Verwendungszwecks und Umfang der Nutzung anmelden (Kontaktmoeglichkeiten zum Landesvermessungsamt NRW siehe unten). Die Nutzung ist ausschliesslich fuer Testzwecke und im Rahmen von GDI-Projekten zulässig; die Nutzung fuer kommerzielle Anwendungen ist ausdruecklich ausgeschlossen. Die mittelbare oder unmittelbare Weitergabe der Daten an Dritte ist auch in Verbindung mit weiteren Daten ohne ausdrueckliche Genehmigung durch das Landesvermessungsamt NRW nicht zulässig. Der Nutzer ist verpflichtet, einen deutlichen Copyright-Hinweis auf das Landesvermessungsamt NRW als Dateneigentuemer bei Visualisierungen jeder Art anzubringen.');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19171, 908, 1, '0', 'Raster:TK100_KMF:Farbkombination', 'Farbkombination', 1, 0, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19226, 789, 0, '', 'Topographische Karten', 'Topographische Karten', 0, 0, 0, '', '', 'SICAD Internet Suite V6.0A05 at http://www.landesvermessung.sachsen.de/sims/sicad-');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19008, 893, 2, '0', 'Grenze', 'border', 0, 750000, 0, 'http://www.mapbender.de/', 'http://www.mapbender.de/', 'Grenzen, border');
@@ -3333,12 +3333,12 @@
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19113, 902, 3, '0', 'ozen', 'Oberzentren', 0, 25001, 2000000, '', '', 'Oberzentren, TYP = 0');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19114, 902, 4, '0', 'mzen', 'Mittelzentren', 0, 25001, 600000, '', '', 'Mittelzentren, TYP = 1');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19115, 902, 5, '0', 'uzen', 'Unterzentren', 0, 25001, 200000, '', '', 'Unterzentren, TYP = 2');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19116, 902, 6, '0', 'lwas', 'FlÃƒÆ’Ã‚Â¼sse und Kanäle', 0, 25001, 150000, '', '', 'FlÃƒÆ’Ã‚Â¼sse und Kanäle');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19116, 902, 6, '0', 'lwas', 'Fluesse und Kanäle', 0, 25001, 150000, '', '', 'Fluesse und Kanäle');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19117, 902, 7, '0', 'fwas', 'Seen', 0, 25001, 250001, '', '', 'Seen');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19118, 902, 8, '0', 'ebahn', 'Eisenbahnen', 0, 25001, 250001, '', '', 'Eisenbahnen');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19119, 902, 9, '0', 'kstr', 'KreisstraÃƒÆ’Ã…Â¸en', 0, 25001, 100000, '', '', 'KreisstraÃƒÆ’Ã…Â¸en');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19120, 902, 10, '0', 'lstr', 'LandesstraÃƒÆ’Ã…Â¸en', 0, 25001, 250001, '', '', 'LandesstraÃƒÆ’Ã…Â¸en');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19121, 902, 11, '0', 'bstr', 'BundesstraÃƒÆ’Ã…Â¸en', 0, 25001, 749999, '', '', 'BundesstraÃƒÆ’Ã…Â¸en');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19119, 902, 9, '0', 'kstr', 'Kreisstrassen', 0, 25001, 100000, '', '', 'Kreisstrassen');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19120, 902, 10, '0', 'lstr', 'Landesstrassen', 0, 25001, 250001, '', '', 'Landesstrassen');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19121, 902, 11, '0', 'bstr', 'Bundesstrassen', 0, 25001, 749999, '', '', 'Bundesstrassen');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19122, 902, 12, '0', 'astr', 'Autobahnen', 0, 25001, 0, '', '', 'Autobahnen');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19123, 902, 13, '0', 'nfwas', 'Namen der Seen', 0, 25001, 100000, '', '', 'Namen der Seen');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19124, 902, 14, '0', 'kfz', 'Kfz-Zeichen', 0, 2000000, 0, '', '', 'Kfz-Zeichen');
@@ -4281,7 +4281,7 @@
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19140, 904, 2, '0', 'orte', 'Zentren', 0, 200000, 1000000, '', '', 'Zentren, TYP = 0');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19141, 904, 3, '0', 'korte', 'Orte', 0, 200000, 749999, '', '', 'Orte, TYP = 0');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3404, 329, 3, '0', 'dgk5dbr', 'DGK5', 0, 1, 3900, '', '', 'DGK5');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19142, 904, 4, '0', 'lwas', 'FlÃƒÆ’Ã‚Â¼sse und Kanäle', 0, 200000, 749999, '', '', 'FlÃƒÆ’Ã‚Â¼sse und Kanäle');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19142, 904, 4, '0', 'lwas', 'Fluesse und Kanäle', 0, 200000, 749999, '', '', 'Fluesse und Kanäle');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3405, 329, 4, '0', 'Stadtgrundkarte', 'Stadtgrundkarte', 0, 0, 0, '', '', 'Stadtgrundkarte');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19143, 904, 5, '0', 'fwas', 'Seen', 0, 200000, 749999, '', '', 'Seen');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3406, 329, 5, '4', 'flst', 'Flurstuecke', 0, 1, 2500, '', '', '');
@@ -4290,21 +4290,21 @@
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3407, 329, 6, '4', 'gebaeude', 'Gebaeude', 0, 1, 2500, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3408, 329, 7, '4', 'linien', 'Topographie', 0, 1, 2500, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (3409, 329, 8, '4', 'texte', 'Beschriftung', 0, 1, 2500, '', '', '');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19145, 904, 7, '0', 'lstr', 'LandesstraÃƒÆ’Ã…Â¸en', 0, 200000, 400000, '', '', 'LandesstraÃƒÆ’Ã…Â¸en');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19146, 904, 8, '0', 'bstr', 'BundesstraÃƒÆ’Ã…Â¸en', 0, 200000, 1000000, '', '', 'BundesstraÃƒÆ’Ã…Â¸en');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19145, 904, 7, '0', 'lstr', 'Landesstrassen', 0, 200000, 400000, '', '', 'Landesstrassen');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19146, 904, 8, '0', 'bstr', 'Bundesstrassen', 0, 200000, 1000000, '', '', 'Bundesstrassen');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19147, 904, 9, '0', 'astr', 'Autobahnen', 0, 200000, 0, '', '', 'Autobahnen');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19148, 904, 10, '0', 'kfz', 'Kfz-Zeichen', 0, 1000000, 0, '', '', 'Kfz-Zeichen');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19156, 906, 1, '0', 'berlin', 'Berliner Bezirke', 0, 50000, 1000000, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19157, 906, 2, '0', 'geme', 'Gemeinde', 1, 50000, 1000000, '', '', 'digitaliert aus DTK 1:100.000');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19158, 906, 3, '0', 'kamt', 'Amtsfreie Gemeinde', 1, 50000, 1000000, '', '', '');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19159, 906, 4, '0', 'amt', 'ÃƒÆ’Ã¢â‚¬Å¾mter', 1, 50000, 1000000, '', '', '');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19159, 906, 4, '0', 'amt', 'Aemter', 1, 50000, 1000000, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19160, 906, 5, '0', 'stadt', 'Kreisfreie Städte', 1, 50000, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19161, 906, 6, '0', 'kreis', 'Landkreise', 1, 50000, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19162, 906, 7, '0', 'land', 'Land', 0, 50000, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19163, 906, 8, '0', 'staat', 'Deutschland', 0, 50000, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19164, 906, 9, '0', 'ngeme', 'Namen der Gemeinden', 0, 50000, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19165, 906, 10, '0', 'nkamt', 'Namen der amtfreien Gemeinden', 0, 50000, 0, '', '', '');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19166, 906, 11, '0', 'namt', 'Namen der ÃƒÆ’Ã¢â‚¬Å¾mter', 0, 50000, 0, '', '', '');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19166, 906, 11, '0', 'namt', 'Namen der Aemter', 0, 50000, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19167, 906, 12, '0', 'nkreis', 'KFZ Kennzeichen der Kreise', 0, 50000, 0, '', '', '');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19233, 706, 0, '', 'WA_Atlas_GN_WMS', 'WA_Atlas_GN_WMS', 0, 0, 0, '', '', 'WMS Map Server');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (11542, 706, 1, '0', 'Australia Base Map', 'Australia Base Map', 0, 0, 0, '', '', '');
@@ -4317,13 +4317,13 @@
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19126, 903, 1, '0', 'land', 'Landkreise und kreisfreie Städte', 0, 100, 50000, '', '', 'digitalisiert und generalisiert aus DTK 1:100.000');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19127, 903, 2, '0', 'ort', 'Ortschaften', 1, 1000, 50000, '', '', 'digitaliert aus DTK 1:100.000');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19128, 903, 3, '0', 'wald', 'Waldflächen', 0, 1000, 50000, '', '', 'aus Basis-DLM');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19129, 903, 4, '0', 'gruen', 'GrÃƒÆ’Ã‚Â¼nflächen', 0, 1000, 50000, '', '', 'GrÃƒÆ’Ã‚Â¼nflächen aus Basis-DLM');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19130, 903, 5, '0', 'lwas', 'FlÃƒÆ’Ã‚Â¼sse und Kanäle', 0, 1000, 50000, '', '', 'aus Basis-DLM');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19129, 903, 4, '0', 'gruen', 'Gruenflächen', 0, 1000, 50000, '', '', 'Gruenflächen aus Basis-DLM');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19130, 903, 5, '0', 'lwas', 'Fluesse und Kanäle', 0, 1000, 50000, '', '', 'aus Basis-DLM');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19131, 903, 6, '0', 'fwas', 'Seen, Teiche', 0, 1000, 50000, '', '', 'aus Basis-DLM');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19132, 903, 7, '0', 'kgrnz', 'Kreisgrenze', 0, 1000, 50000, '', '', 'generalisiert aus 1:100.000');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19133, 903, 8, '0', 'flug', 'Internationale Flughäfen', 0, 1000, 29999, '', '', 'aus Basis-DLM');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19134, 903, 9, '0', 'ebahn', 'Eisenbahnverbindungen', 0, 1000, 50000, '', '', 'aus Basis-DLM');
-INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19135, 903, 10, '0', 'str', 'StraÃƒÆ’Ã…Â¸en', 0, 1000, 50000, '', '', 'aus Basis-DLM');
+INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19135, 903, 10, '0', 'str', 'Strassen', 0, 1000, 50000, '', '', 'aus Basis-DLM');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19136, 903, 11, '0', 'haus', 'Gebäude', 0, 1000, 50000, '', '', 'aus Basis-DLM');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (19137, 903, 12, '0', 'nfwas', 'Namen der Seen, Teiche', 0, 1000, 50000, '', '', 'aus Basis-DLM');
 INSERT INTO layer (layer_id, fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_queryable, layer_minscale, layer_maxscale, layer_dataurl, layer_metadataurl, layer_abstract) VALUES (20102, 910, 0, '', 'IGME5000', 'IGME5000 preliminary release', 0, 0, 0, NULL, NULL, 'The 1 : 5 Million International Geological Map of Europe and Adjacent Areas (IGME 5000).');
@@ -7692,17 +7692,17 @@
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10175, 'default', 'Default Elevation Style, scaled to 8 bit using a non-linear function', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10175, 'short_int', 'short int elevation values when format is image/png, identical to default for jpeg', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10175, 'feet_short_int', 'short int elevation values in feet when format is image/png ', '', '');
-INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19247, 'Default', 'Default', 'http://wms.larioja.org/Legends/Elementos_hidrogrÃƒÆ’Ã‚Â¡ficos_Default.png', 'image/png');
+INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19247, 'Default', 'Default', 'http://wms.larioja.org/Legends/Elementos_hidrograficos_Default.png', 'image/png');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10176, 'default', 'Default Elevation Style, scaled to 8 bit using a non-linear function', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10176, 'short_int', 'short int elevation values when format is image/png', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10176, 'feet_short_int', 'short int elevation values in feet when format is image/png', '', '');
-INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19248, 'Default', 'Default', 'http://wms.larioja.org/Legends/Hojas_cartogrÃƒÆ’Ã‚Â¡ficas_1-5000_Default.png', 'image/png');
+INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19248, 'Default', 'Default', 'http://wms.larioja.org/Legends/Hojas_cartograficas_1-5000_Default.png', 'image/png');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10177, 'default', 'Default Elevation', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10177, 'short_int', 'short int signed elevation values when format is image/png or tiff', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10177, 'feet_short_int', 'short int elevation values in feet when format is image/png or image/tiff', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10177, 'real', 'DEM real numbers, in floating point format, meters, when used with image/tiff', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10177, 'feet_real', 'DEM in real numbers, in floating point format, feet, when used with image/tiff', '', '');
-INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19249, 'Default', 'Default', 'http://wms.larioja.org/Legends/Manzanas_de_los_nÃƒÆ’Ã‚Âºcleos_urbanos_Default.png', 'image/png');
+INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19249, 'Default', 'Default', 'http://wms.larioja.org/Legends/Manzanas_de_los_nucleos_urbanos_Default.png', 'image/png');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10178, 'default', 'Default Elevation', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10178, 'short_int', 'short int elevation values when format is image/png', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (10178, 'feet_short_int', 'short int elevation values in feet when format is image/png', '', '');
@@ -7802,7 +7802,7 @@
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19240, 'Feb', 'February', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19240, 'Mar', 'March', '', '');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19240, 'Apr', 'April', '', '');
-INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19255, 'Default', 'Default', 'http://wms.larioja.org/Legends/Puntos_geodÃƒÆ’Ã‚Â©sicos_Default.png', 'image/png');
+INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19255, 'Default', 'Default', 'http://wms.larioja.org/Legends/Puntos_geodesicos_Default.png', 'image/png');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19256, 'Default', 'Default', 'http://wms.larioja.org/Legends/Tramos_de_carreteras_Default.png', 'image/png');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (19257, 'Default', 'Default', 'http://wms.larioja.org/Legends/Tramos_de_ferrocarril_Default.png', 'image/png');
 INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) VALUES (14843, 'Default', 'Default', 'http://maps1.intergraph.com/wms/world/Legends/GLOBEImage_Default.png', 'image/png');
@@ -8032,7 +8032,7 @@
 INSERT INTO md_topic_category (md_topic_category_id, md_topic_category_code_en, md_topic_category_code_de) VALUES (3, 'boundaries', 'Grenzen');
 INSERT INTO md_topic_category (md_topic_category_id, md_topic_category_code_en, md_topic_category_code_de) VALUES (4, 'climatologyMeteorologyAtmosphere', 'Wetterkunde');
 INSERT INTO md_topic_category (md_topic_category_id, md_topic_category_code_en, md_topic_category_code_de) VALUES (5, 'economy', 'Wirtschaft');
-INSERT INTO md_topic_category (md_topic_category_id, md_topic_category_code_en, md_topic_category_code_de) VALUES (6, 'elevation', 'HÃƒÆ’Ã‚Â¶hendaten');
+INSERT INTO md_topic_category (md_topic_category_id, md_topic_category_code_en, md_topic_category_code_de) VALUES (6, 'elevation', 'Hoehendaten');
 INSERT INTO md_topic_category (md_topic_category_id, md_topic_category_code_en, md_topic_category_code_de) VALUES (7, 'environment', 'Umwelt');
 INSERT INTO md_topic_category (md_topic_category_id, md_topic_category_code_en, md_topic_category_code_de) VALUES (8, 'geoscientificInformation', 'Geowissenschaft');
 INSERT INTO md_topic_category (md_topic_category_id, md_topic_category_code_en, md_topic_category_code_de) VALUES (9, 'health', 'Gesundheit');
@@ -12580,8 +12580,8 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>gruen</Name>
-        <Title>GrÃƒÆ’Ã‚Â¼nflächen</Title>
-        <Abstract>GrÃƒÆ’Ã‚Â¼nflächen aus Basis-DLM</Abstract>
+        <Title>Gruenflächen</Title>
+        <Abstract>Gruenflächen aus Basis-DLM</Abstract>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.2339" miny="51.3128" maxx="14.7662" maxy="53.5648" />
         <BoundingBox SRS="EPSG:25833"
@@ -12590,7 +12590,7 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>lwas</Name>
-        <Title>FlÃƒÆ’Ã‚Â¼sse und Kanäle</Title>
+        <Title>Fluesse und Kanäle</Title>
         <Abstract>aus Basis-DLM</Abstract>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.253" miny="51.3161" maxx="14.7408" maxy="53.5563" />
@@ -12640,7 +12640,7 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>str</Name>
-        <Title>StraÃƒÆ’Ã…Â¸en</Title>
+        <Title>Strassen</Title>
         <Abstract>aus Basis-DLM</Abstract>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.2382" miny="51.3129" maxx="14.7649" maxy="53.5635" />
@@ -12768,8 +12768,8 @@
 ', NULL, 'http://deutschlandviewer.bayern.de/ogc/getogc.cgi?REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.1', 'none', 'none', '', '', '', '', '', '', '', '', '', '', '', NULL, 1, 1173698124, NULL, NULL, NULL, NULL);
 INSERT INTO wms (wms_id, wms_version, wms_title, wms_abstract, wms_getcapabilities, wms_getmap, wms_getfeatureinfo, wms_getlegendurl, wms_filter, wms_getcapabilities_doc, wms_owsproxy, wms_upload_url, fees, accessconstraints, contactperson, contactposition, contactorganization, address, city, stateorprovince, postcode, country, contactvoicetelephone, contactfacsimiletelephone, contactelectronicmailaddress, wms_mb_getcapabilities_doc, wms_owner, wms_timestamp, wms_supportsld, wms_userlayer, wms_userstyle, wms_remotewfs) VALUES (828, '1.1.1', 'IDERIOJA Gobierno de La Rioja OGC WMS', 'IDERIOJA Gobierno de La Rioja OGC WMS', 'http://wms.larioja.org/request.asp', 'http://wms.larioja.org/request.asp', 'http://wms.larioja.org/request.asp', '', '', '<?xml version="1.0"?>
 <!DOCTYPE WMT_MS_Capabilities SYSTEM "http://wms.larioja.org/Capabilities/capabilities_1_1_1.dtd" [ <!ELEMENT VendorSpecificCapabilities EMPTY>]>
-<WMT_MS_Capabilities version="1.1.1"><Service><Name>OGC:WMS</Name><!--Human-readable title for pick lists--><Title>IDERIOJA Gobierno de La Rioja OGC WMS</Title><!--Narrative description providing additional information--><Abstract>IDERIOJA Gobierno de La Rioja OGC WMS</Abstract><KeywordList><Keyword>WMS</Keyword><Keyword>OGC</Keyword><Keyword> La Rioja</Keyword><Keyword>Cartografia</Keyword><Keyword> Mapas </Keyword></KeywordList><!--Top-level address of service or service provider--><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://www.larioja.org" xlink:type="simple"/><ContactInformation><ContactPersonPrimary><ContactPerson>Gonzalo LÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â³pez GarcÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Âa</ContactPerson><ContactOrganization>ConsejerÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Âa de Turismo, Medio Ambiente y PolÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Âtica Territorial</ContactOrganization></ContactPersonPrimary><ContactPosition>Jefe de SecciÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â³n de Sistemas de InformaciÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â³n GeogrÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â¡fica y CartografÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Âa</ContactPosition><ContactAddress><AddressType>postal</AddressType><Address>Prado Viejo, 62 bis</Address><City>LogroÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â±o</City><StateOrProvince>La Rioja</StateOrProvince><PostCode>26071</PostCode><Country></Country></ContactAddress><ContactVoiceTelephone></ContactVoiceTelephone><ContactElectronicMailAddress></ContactElectronicMailAddress></ContactInformation><Fees>none</Fees><AccessConstraints>none</AccessConstraints></Service><Capability><Request><GetCapabilities><Format>application/vnd.ogc.wms_xml</Format><DCPType><HTTP><Get><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/request.asp" xlink:type="simple"/></Get></HTTP></DCPType></GetCapabilities><GetMap><Format>image/png</Format><Format>image/jpeg</Format><DCPType><HTTP><Get><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/request.asp" xlink:type="simple"/></Get></HTTP></DCPType></GetMap><GetFeatureInfo><Format>text/html</Format><DCPType><HTTP><Get><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/request.asp" xlink:type="simple"/></Get></HTTP></DCPType></GetFeatureInfo></Request><Exception><Format>application/vnd.ogc.se_inimage</Format><Format>application/vnd.ogc.se_xml</Format></Exception><Layer><Title>CAPAS</Title><SRS>EPSG:4326</SRS><SRS>EPSG:23030</SRS><SRS>EPSG:25830</SRS><LatLonBoundingBox minx="-3.2623" miny="41.8509" maxx="-1.5416" maxy="42.7473"/><!--BoundingBox is inheritable, we define at root, inherited by all--><BoundingBox SRS="EPSG:23030" minx="478621.4999" miny="4634401.5" maxx="619671.5001" maxy="4733511.3584"/><BoundingBox SRS="EPSG:25830" minx="478517.3309" miny="4634188.7848" maxx="619566.8081" maxy="4733298.3072"/><BoundingBox SRS="EPSG:4326" minx="-3.2623" miny="41.8509" maxx="-1.5416" maxy="42.7473"/><Layer queryable="1" opaque="0" noSubsets="0"><Name>Elementos_hidrogrÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â¡ficos</Name><Title>Elementos_hidrogrÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â¡ficos</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Elementos_hidrogrÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â¡ficos_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Hojas_cartogrÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â¡ficas_1-5000</Name><Title>Hojas_cartogrÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â¡ficas_1-5000</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Hojas_cartogrÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â¡ficas_1-5000_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Manzanas_de_los_nÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Âºcleos_urbanos</Name><Title>Manzanas_de_los_nÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Âºcleos_urbanos</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Manzanas_de_los_nÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Âºcleos_urbanos_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Masas_de_agua</Name><Title>Masas_de_agua</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Masas_de_agua_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Municipios</Name><Title>Municipios</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Municipios_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="0" opaque="0" noSubsets="0"><Name>Ortofoto_2004</Name><Title>Ortofoto_2004</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Ortofoto_2004_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Puntos_geodÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â©sicos</Name><Title>Puntos_geodÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â©sicos</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Puntos_geodÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â©sicos_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Tramos_de_carreteras</Name><Title>Tramos_de_carreteras</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Tramos_de_carreteras_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Tramos_de_ferrocarril</Name><Title>Tramos_de_ferrocarril</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Tramos_de_ferrocarril_Default.png" xlink:type="simple"/></LegendURL></Style></Layer></Layer></Capability></WMT_MS_Capabilities>
-', NULL, 'http://wms.larioja.org/request.asp?REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.1', 'none', 'none', 'Gonzalo LÃƒÆ’Ã‚Â³pez GarcÃƒÆ’Ã‚Âa', 'Jefe de SecciÃƒÆ’Ã‚Â³n de Sistemas de InformaciÃƒÆ’Ã‚Â³n GeogrÃƒÆ’Ã‚Â¡fica y CartografÃƒÆ’Ã‚Âa', 'ConsejerÃƒÆ’Ã‚Âa de Turismo, Medio Ambiente y PolÃƒÆ’Ã‚Âtica Territorial', 'Prado Viejo, 62 bis', 'LogroÃƒÆ’Ã‚Â±o', 'La Rioja', '26071', '', '', '', '', NULL, 1, 1173698127, NULL, NULL, NULL, NULL);
+<WMT_MS_Capabilities version="1.1.1"><Service><Name>OGC:WMS</Name><!--Human-readable title for pick lists--><Title>IDERIOJA Gobierno de La Rioja OGC WMS</Title><!--Narrative description providing additional information--><Abstract>IDERIOJA Gobierno de La Rioja OGC WMS</Abstract><KeywordList><Keyword>WMS</Keyword><Keyword>OGC</Keyword><Keyword> La Rioja</Keyword><Keyword>Cartografia</Keyword><Keyword> Mapas </Keyword></KeywordList><!--Top-level address of service or service provider--><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://www.larioja.org" xlink:type="simple"/><ContactInformation><ContactPersonPrimary><ContactPerson>Gonzalo Lopez Garcia</ContactPerson><ContactOrganization>Consejeria de Turismo, Medio Ambiente y Politica Territorial</ContactOrganization></ContactPersonPrimary><ContactPosition>Jefe de Seccion de Sistemas de Informacion Geografica y Cartografia</ContactPosition><ContactAddress><AddressType>postal</AddressType><Address>Prado Viejo, 62 bis</Address><City>Logrono</City><StateOrProvince>La Rioja</StateOrProvince><PostCode>26071</PostCode><Country></Country></ContactAddress><ContactVoiceTelephone></ContactVoiceTelephone><ContactElectronicMailAddress></ContactElectronicMailAddress></ContactInformation><Fees>none</Fees><AccessConstraints>none</AccessConstraints></Service><Capability><Request><GetCapabilities><Format>application/vnd.ogc.wms_xml</Format><DCPType><HTTP><Get><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/request.asp" xlink:type="simple"/></Get></HTTP></DCPType></GetCapabilities><GetMap><Format>image/png</Format><Format>image/jpeg</Format><DCPType><HTTP><Get><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/request.asp" xlink:type="simple"/></Get></HTTP></DCPType></GetMap><GetFeatureInfo><Format>text/html</Format><DCPType><HTTP><Get><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/request.asp" xlink:type="simple"/></Get></HTTP></DCPType></GetFeatureInfo></Request><Exception><Format>application/vnd.ogc.se_inimage</Format><Format>application/vnd.ogc.se_xml</Format></Exception><Layer><Title>CAPAS</Title><SRS>EPSG:4326</SRS><SRS>EPSG:23030</SRS><SRS>EPSG:25830</SRS><LatLonBoundingBox minx="-3.2623" miny="41.8509" maxx="-1.5416" maxy="42.7473"/><!--BoundingBox is inheritable, we define at root, inherited by all--><BoundingBox SRS="EPSG:23030" minx="478621.4999" miny="4634401.5" maxx="619671.5001" maxy="4733511.3584"/><BoundingBox SRS="EPSG:25830" minx="478517.3309" miny="4634188.7848" maxx="619566.8081" maxy="4733298.3072"/><BoundingBox SRS="EPSG:4326" minx="-3.2623" miny="41.8509" maxx="-1.5416" maxy="42.7473"/><Layer queryable="1" opaque="0" noSubsets="0"><Name>Elementos_hidrograficos</Name><Title>Elementos_hidrograficos</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Elementos_hidrograficos_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Hojas_cartograficas_1-5000</Name><Title>Hojas_cartograficas_1-5000</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Hojas_cartograficas_1-5000_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Manzanas_de_los_nucleos_urbanos</Name><Title>Manzanas_de_los_nucleos_urbanos</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Manzanas_de_los_nucleos_urbanos_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Masas_de_agua</Name><Title>Masas_de_agua</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Masas_de_agua_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Municipios</Name><Title>Municipios</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Municipios_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="0" opaque="0" noSubsets="0"><Name>Ortofoto_2004</Name><Title>Ortofoto_2004</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Ortofoto_2004_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Puntos_geodesicos</Name><Title>Puntos_geodesicos</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Puntos_geodesicos_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Tramos_de_carreteras</Name><Title>Tramos_de_carreteras</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Tramos_de_carreteras_Default.png" xlink:type="simple"/></LegendURL></Style></Layer><Layer queryable="1" opaque="0" noSubsets="0"><Name>Tramos_de_ferrocarril</Name><Title>Tramos_de_ferrocarril</Title><Style><Name>Default</Name><Title>Default</Title><LegendURL width="20" height="15"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://wms.larioja.org/Legends/Tramos_de_ferrocarril_Default.png" xlink:type="simple"/></LegendURL></Style></Layer></Layer></Capability></WMT_MS_Capabilities>
+', NULL, 'http://wms.larioja.org/request.asp?REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.1', 'none', 'none', 'Gonzalo Lopez Garcia', 'Jefe de Seccion de Sistemas de Informacion Geografica y Cartografia', 'Consejeria de Turismo, Medio Ambiente y Politica Territorial', 'Prado Viejo, 62 bis', 'Logrono', 'La Rioja', '26071', '', '', '', '', NULL, 1, 1173698127, NULL, NULL, NULL, NULL);
 INSERT INTO wms (wms_id, wms_version, wms_title, wms_abstract, wms_getcapabilities, wms_getmap, wms_getfeatureinfo, wms_getlegendurl, wms_filter, wms_getcapabilities_doc, wms_owsproxy, wms_upload_url, fees, accessconstraints, contactperson, contactposition, contactorganization, address, city, stateorprovince, postcode, country, contactvoicetelephone, contactfacsimiletelephone, contactelectronicmailaddress, wms_mb_getcapabilities_doc, wms_owner, wms_timestamp, wms_supportsld, wms_userlayer, wms_userstyle, wms_remotewfs) VALUES (86, '1.1.1', 'World Map', 'World Map in WGS84 Reference System', 'http://wms1.ccgis.de/cgi-bin/mapserv?map=/data/umn/world/world_map.map&', 'http://wms1.ccgis.de/cgi-bin/mapserv?map=/data/umn/world/world_map.map&', 'http://wms1.ccgis.de/cgi-bin/mapserv?map=/data/umn/world/world_map.map&', 'http://wms1.ccgis.de/cgi-bin/mapserv?map=/data/umn/world/world_map.map&', '', '<?xml version=''1.0'' encoding="ISO-8859-1" standalone="no" ?>
 <!DOCTYPE WMT_MS_Capabilities SYSTEM "http://schemas.opengeospatial.net/wms/1.1.1/WMS_MS_Capabilities.dtd"
  [
@@ -12933,8 +12933,8 @@
 		<Abstract>Web Map Service auf Basis des Smallworld GIS</Abstract>
 		<KeywordList>
 			<Keyword>NWSIB</Keyword>
-			<Keyword>klassifiziertes StraÃƒÆ’Ã…Â¸ennetz</Keyword>
-			<Keyword>Anweisung StraÃƒÆ’Ã…Â¸eninformationsbank ASB</Keyword>
+			<Keyword>klassifiziertes Strassennetz</Keyword>
+			<Keyword>Anweisung Strasseninformationsbank ASB</Keyword>
 			<Keyword>Netzknoten-Stationierungssystem</Keyword>
 		</KeywordList>
 		<OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.gis-consult.de"/>
@@ -12943,7 +12943,7 @@
 				<ContactPerson>Christian Vogt</ContactPerson>
 				<ContactOrganization>GIS Consult GmbH</ContactOrganization>
 			</ContactPersonPrimary>
-			<ContactPosition>GeschäftsfÃƒÆ’Ã‚Â¼hrer</ContactPosition>
+			<ContactPosition>Geschäftsfuehrer</ContactPosition>
 			<ContactAddress>
 				<AddressType>postal</AddressType>
 				<Address>Schultenbusch 3</Address>
@@ -12957,7 +12957,7 @@
 			<ContactElectronicMailAddress>vogt at gis-consult.de</ContactElectronicMailAddress>
 		</ContactInformation>
 		<Fees>none</Fees>
-		<AccessConstraints>Die StraÃƒÆ’Ã…Â¸endaten wurden freundlicherweise vom Landesbetrieb StraÃƒÆ’Ã…Â¸enbau NRW zur VerfÃƒÆ’Ã‚Â¼gung gestellt. Es handelt sich hierbei um einen unvollständigen Datenauszug, der nicht dem aktuellen Stand der NWSIB entspricht.</AccessConstraints>
+		<AccessConstraints>Die Strassendaten wurden freundlicherweise vom Landesbetrieb Strassenbau NRW zur Verfuegung gestellt. Es handelt sich hierbei um einen unvollständigen Datenauszug, der nicht dem aktuellen Stand der NWSIB entspricht.</AccessConstraints>
 	</Service>
 	<Capability>
 		<Request>
@@ -13006,7 +13006,7 @@
 			<Format>application/vnd.ogc.se_xml</Format>
 		</Exception>
 		<Layer queryable="0">
-			<Title>verfÃƒÆ’Ã‚Â¼gbare Layer</Title>
+			<Title>verfuegbare Layer</Title>
 			<SRS>EPSG:31466 EPSG:31467 EPSG:31468 EPSG:31469 EPSG:4326</SRS>
 			<LatLonBoundingBox minx="5.65296386" miny="50.31247805" maxx="9.61606634" maxy="52.54258946"/>
 			<BoundingBox SRS="EPSG:31466" minx="2475321.110" miny="5575227.309" maxx="2745328.607" maxy="5829431.962" resx="1" resy="1"/>
@@ -13032,7 +13032,7 @@
 			</Layer>
 			<Layer queryable="1" opaque="0">
 				<Name>Aeste</Name>
-				<Title>ÃƒÆ’Ã¢â‚¬Å¾ste</Title>
+				<Title>Aeste</Title>
 			</Layer>
 			<Layer queryable="1" opaque="0">
 				<Name>Netzknoten</Name>
@@ -13055,7 +13055,7 @@
 			</Layer>
 			<Layer queryable="1" opaque="0">
 				<Name>Strassenbez.</Name>
-				<Title>StraÃƒÆ’Ã…Â¸enbez.</Title>
+				<Title>Strassenbez.</Title>
 			</Layer>
 			<Layer queryable="1" opaque="0">
 				<Name>Abschnittsnr.</Name>
@@ -13099,12 +13099,12 @@
 				<Title>Rasterkarten</Title>
 				<Layer queryable="0" opaque="1">
 					<Name>Strassenkarte</Name>
-					<Title>StraÃƒÆ’Ã…Â¸enkarte</Title>
+					<Title>Strassenkarte</Title>
 				</Layer>
 			</Layer>
 		</Layer>
 	</Capability>
-</WMT_MS_Capabilities>', NULL, 'http://services.gis-consult.de/NWSIB-online/GCGisService?REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.0', 'none', 'Die StraÃƒÆ’Ã…Â¸endaten wurden freundlicherweise vom Landesbetrieb StraÃƒÆ’Ã…Â¸enbau NRW zur VerfÃƒÆ’Ã‚Â¼gung gestellt. Es handelt sich hierbei um einen unvollständigen Datenauszug, der nicht dem aktuellen Stand der NWSIB entspricht.', 'Christian Vogt', 'GeschäftsfÃƒÆ’Ã‚Â¼hrer', 'GIS Consult GmbH', 'Schultenbusch 3', 'Haltern am See', 'D', '45721', 'Germany', '+49 2364 9218-31', '+49 2364 9218-72', 'vogt at gis-consult.de', NULL, 1, 1173698122, NULL, NULL, NULL, NULL);
+</WMT_MS_Capabilities>', NULL, 'http://services.gis-consult.de/NWSIB-online/GCGisService?REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.0', 'none', 'Die Strassendaten wurden freundlicherweise vom Landesbetrieb Strassenbau NRW zur Verfuegung gestellt. Es handelt sich hierbei um einen unvollständigen Datenauszug, der nicht dem aktuellen Stand der NWSIB entspricht.', 'Christian Vogt', 'Geschäftsfuehrer', 'GIS Consult GmbH', 'Schultenbusch 3', 'Haltern am See', 'D', '45721', 'Germany', '+49 2364 9218-31', '+49 2364 9218-72', 'vogt at gis-consult.de', NULL, 1, 1173698122, NULL, NULL, NULL, NULL);
 INSERT INTO wms (wms_id, wms_version, wms_title, wms_abstract, wms_getcapabilities, wms_getmap, wms_getfeatureinfo, wms_getlegendurl, wms_filter, wms_getcapabilities_doc, wms_owsproxy, wms_upload_url, fees, accessconstraints, contactperson, contactposition, contactorganization, address, city, stateorprovince, postcode, country, contactvoicetelephone, contactfacsimiletelephone, contactelectronicmailaddress, wms_mb_getcapabilities_doc, wms_owner, wms_timestamp, wms_supportsld, wms_userlayer, wms_userstyle, wms_remotewfs) VALUES (671, '1.1.0', 'Wasserschutzgebiete NRW', 'This is an OGC compliant MapService served By ESRI. The engine used to serve this MapService is ArcIMS', 'http://www.gis2.nrw.de/wmsconnector/wms/wsg?', 'http://www.gis2.nrw.de/wmsconnector/wms/wsg?', 'http://www.gis2.nrw.de/wmsconnector/wms/wsg?', '', '', '<?xml version="1.0" encoding="UTF-8"?>
 <!DOCTYPE WMT_MS_Capabilities SYSTEM "http://www.gis2.nrw.de/wmsconnector/schema/wms/1.1.0/capabilities_1_1_0.dtd" [
 <!-- Vendor-specific elements are defined here if needed. -->
@@ -16779,7 +16779,7 @@
 <!ELEMENT VendorSpecificCapabilities EMPTY>
 ]>
 <WMT_MS_Capabilities  version="1.1.1" updateSequence="1.1.0"><Service><Name>OGC:WMS</Name><Title>WMS-Thueringen</Title><Abstract>wms reference implementation</Abstract><KeywordList><Keyword>deegree</Keyword><Keyword>wms</Keyword></KeywordList><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms"/><ContactInformation><ContactPersonPrimary><ContactPerson>F. Engel</ContactPerson><ContactOrganization>Geoinformationszentrum</ContactOrganization></ContactPersonPrimary><ContactPosition>Consultant</ContactPosition><ContactAddress><AddressType/><Address>Hohenwindenstrasse 13a</Address><City>Erfurt</City><StateOrProvince>Thueringen</StateOrProvince><PostCode>99096</PostCode><Country/></ContactAddress><ContactElectronicMailAddress>f.engel at tlverma.thueringen.de</ContactElectronicMailAddress></ContactInformation><Fees>none</Fees><AccessConstraints>none</AccessConstraints></Service><Capability><Request><GetCapabilities><Format>application/vnd.ogc.wms_xml</Format><DCPType><HTTP><Get><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/wms?"/></Get></HTTP></DCPType></GetCapabilities><GetMap><Format>image/png</Format><Format>image/jpeg</Format><Format>image/tif</Format><Format>image/svg+xml</Format><Format>image/bmp</Format><Format>image/gif</Format><Format>image/jpg</Format><DCPType><HTTP><Get><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/wms?"/></Get><Post><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/wms?"/></Post></HTTP></DCPType></GetMap><GetFeatureInfo><Format>text/html</Format><Format>application/vnd.ogc.gml</Format><Format>text/plain</Format><DCPType><HTTP><Get><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/wms?"/></Get></HTTP></DCPType></GetFeatureInfo></Request><Exception><Format>application/vnd.ogc.se_xml</Format><Format>application/vnd.ogc.se_inimage</Format><Format>application/vnd.ogc.se_blank</Format></Exception><Layer queryable="0" cascaded="0" opaque="0" noSubsets="0"><Title>TKVV</Title><Abstract>the top-level-layer of the deegree demo-CD</Abstract><KeywordList><Keyword>deegree</Keyword><Keyword>demo-CD</Keyword><Keyword>layer</Keyword></KeywordList><SRS>EPSG:31468</SRS><LatLonBoundingBox minx="-180.0" miny="-90.0" maxx="180.0" maxy="90.0"/><BoundingBox SRS="EPSG:31468" minx="4500038.056252609" miny="-1.0000959949100513E7" maxx="4500018.656164683" maxy="1.000096364770234E7"/><ScaleHint max="100.0" min="0.1"/><Layer queryable="0" opaque="0" noSubsets="0"><Name>Thueringer_Orthofotos</Name><Title>Thueringer_Orthofotos</Title><Abstract>cascaded WMS layers remote WFS and remote WCS examples</Abstract><LatLonBoundingBox minx="-180.0" miny="-90.0" maxx="180.0" maxy="90.0"/><Style><Name>default:Thueringer_Orthofotos</Name><Title>default:Thueringer_Orthofotos</Title><LegendURL width="20" height="20"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/legend/default_Thueringer_Orthofotos.png"/></LegendURL></Style><ScaleHint max="1.7976931348623157E308" min="0.0"/><Layer queryable="0" opaque="0" noSubsets="0" fixedWidth="0" fixedHeight="0"><Name>Orthophotos_TH-2m</Name><Title>Orthophotos_TH-2m</Title><LatLonBoundingBox minx="-180.0" miny="-90.0" maxx="180.0" maxy="90.0"/><Style><Name>default:Orthophotos_TH-2m</Name><Title>default:Orthophotos_TH-2m</Title><LegendURL width="20" height="20"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/legend/default_Orthophotos_TH-2m.png"/></LegendURL></Style><ScaleHint max="1.7976931348623157E308" min="0.0"/></Layer></Layer><Layer queryable="0" opaque="0" noSubsets="0"><Name>TK50</Name><Title>TK50</Title><Abstract>cascaded WMS layers remote WFS and remote WCS examples</Abstract><LatLonBoundingBox minx="-180.0" miny="-90.0" maxx="180.0" maxy="90.0"/><Style><Name>default:TK50</Name><Title>default:TK50</Title><LegendURL width="20" height="20"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/legend/default_TK50.png"/></LegendURL></Style><ScaleHint max="1.7976931348623157E308" min="0.0"/><Layer queryable="0" opaque="0" noSubsets="0" fixedWidth="0" fixedHeight="0"><Name>Top.Karte_50_gesamt</Name><Title>Top.Karte_50_gesamt</Title><LatLonBoundingBox minx="-180.0" miny="-90.0" maxx="180.0" maxy="90.0"/><Style><Name>default:Top.Karte_50_gesamt</Name><Title>default:Top.Karte_50_gesamt</Title><LegendURL width="20" height="20"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/legend/default_Top.Karte_50_gesamt.png"/></LegendURL></Style><ScaleHint max="1.7976931348623157E308" min="0.0"/></Layer><Layer queryable="0" opaque="0" noSubsets="0" fixedWidth="0" fixedHeight="0"><Name>Grundriss</Name><Title>Grundriss</Title><LatLonBoundingBox minx="-180.0" miny="-90.0" maxx="180.0" maxy="90.0"/><Style><Name>default:Grundriss</Name><Title>default:Grundriss</Title><LegendURL width="20" height="20"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/legend/default_Grundriss.png"/></LegendURL></Style><ScaleHint max="1.7976931348623157E308" min="0.0"/></Layer><Layer queryable="0" opaque="0" noSubsets="0" fixedWidth="0" fixedHeight="0"><Name>Gewaesser</Name><Title>Gewaesser</Title><LatLonBoundingBox minx="-180.0" miny="-90.0" maxx="180.0" maxy="90.0"/><Style><Name>default:Gewaesser</Name><Title>default:Gewaesser</Title><LegendURL width="20" height="20"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/legend/default_Gewaesser.png"/></LegendURL></Style><ScaleHint max="1.7976931348623157E308" min="0.0"/></Layer><Layer queryable="0" opaque="0" noSubsets="0" fixedWidth="0" fixedHeight="0"><Name>Hoehenschichten</Name><Title>Hoehenschichten</Title><LatLonBoundingBox minx="-180.0" miny="-90.0" maxx="180.0" maxy="90.0"/><Style><Name>default:Hoehenschichten</Name><Title>default:Hoehenschichten</Title><LegendURL width="20" height="20"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/legend/default_Hoehenschichten.png"/></LegendURL></Style><ScaleHint max="1.7976931348623157E308" min="0.0"/></Layer><Layer queryable="0" opaque="0" noSubsets="0" fixedWidth="0" fixedHeight="0"><Name>Strassen</Name><Title>Strassen</Title><LatLonBoundingBox minx="-180.0" miny="-90.0" maxx="180.0" maxy="90.0"/><Style><Name>default:Strassen</Name><Title>default:Strassen</Title><LegendURL width="20" height="20"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/legend/default_Strassen.png"/></LegendURL></Style><ScaleHint max="1.7976931348623157E308" min="0.0"/></Layer><Layer queryable="0" opaque="0" noSubsets="0" fixedWidth="0" fixedHeight="0"><Name>Wald</Name><Title>Wald</Title><LatLonBoundingBox minx="-180.0" miny="-90.0" maxx="180.0" maxy="90.0"/><Style><Name>default:Wald</Name><Title>default:Wald</Title><LegendURL width="20" height="20"><Format>image/png</Format><OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple" xlink:href="http://www.webmap-test.thueringen.de/deegreewms/legend/default_Wald.png"/></LegendURL></Style><ScaleHint max="1.7976931348623157E308" min="0.0"/></Layer></Layer></Layer></Capability></WMT_MS_Capabilities>', NULL, 'http://www.webmap-test.thueringen.de/deegreewms/wms?REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.1', 'none', 'none', 'F. Engel', 'Consultant', 'Geoinformationszentrum', 'Hohenwindenstrasse 13a', 'Erfurt', 'Thueringen', '99096', '', '', '', 'f.engel at tlverma.thueringen.de', NULL, 1, 1173698125, NULL, NULL, NULL, NULL);
-INSERT INTO wms (wms_id, wms_version, wms_title, wms_abstract, wms_getcapabilities, wms_getmap, wms_getfeatureinfo, wms_getlegendurl, wms_filter, wms_getcapabilities_doc, wms_owsproxy, wms_upload_url, fees, accessconstraints, contactperson, contactposition, contactorganization, address, city, stateorprovince, postcode, country, contactvoicetelephone, contactfacsimiletelephone, contactelectronicmailaddress, wms_mb_getcapabilities_doc, wms_owner, wms_timestamp, wms_supportsld, wms_userlayer, wms_userstyle, wms_remotewfs) VALUES (908, '1.1.0', 'NRW: TK100 Farbe', 'Nutzungsbedingungen: Sämtliche Rechte an diesem Produkt liegen beim Landesvermessungsamt NRW. Die Nutzung ist bis auf Widerruf kostenfrei. Der Nutzer muss sich vor jeder Nutzung beim Landesvermessungsamt NRW identifizieren und seine spezielle Nutzung mit Angabe des Verwendungszwecks und Umfang der Nutzung anmelden (KontaktmÃƒÆ’Ã‚Â¶glichkeiten zum Landesvermessungsamt NRW siehe unten). Die Nutzung ist ausschlieÃƒÆ’Ã…Â¸lich fÃƒÆ’Ã‚Â¼r Testzwecke und im Rahmen von GDI-Projekten zulässig; die Nutzung fÃƒÆ’Ã‚Â¼r kommerzielle Anwendungen ist ausdrÃƒÆ’Ã‚Â¼cklich ausgeschlossen. Die mittelbare oder unmittelbare Weitergabe der Daten an Dritte ist auch in Verbindung mit weiteren Daten ohne ausdrÃƒÆ’Ã‚Â¼ckliche Genehmigung durch das Landesvermessungsamt NRW nicht zulässig. Der Nutzer ist verpflichtet, einen deutlichen Copyright-Hinweis auf das Landesvermessungsamt NRW als DateneigentÃƒÆ’Ã‚Â¼mer bei Visualisierungen jeder Art anzubringen.', 'http://www.geoserver.nrw.de:80/GeoOgcWms1.3/servlet/TK100', 'http://www.geoserver.nrw.de:80/GeoOgcWms1.3/servlet/TK100', 'http://www.geoserver.nrw.de:80/GeoOgcWms1.3/servlet/TK100', '', NULL, '<?xml version=''1.0'' encoding="ISO-8859-1" standalone="no" ?> 
+INSERT INTO wms (wms_id, wms_version, wms_title, wms_abstract, wms_getcapabilities, wms_getmap, wms_getfeatureinfo, wms_getlegendurl, wms_filter, wms_getcapabilities_doc, wms_owsproxy, wms_upload_url, fees, accessconstraints, contactperson, contactposition, contactorganization, address, city, stateorprovince, postcode, country, contactvoicetelephone, contactfacsimiletelephone, contactelectronicmailaddress, wms_mb_getcapabilities_doc, wms_owner, wms_timestamp, wms_supportsld, wms_userlayer, wms_userstyle, wms_remotewfs) VALUES (908, '1.1.0', 'NRW: TK100 Farbe', 'Nutzungsbedingungen: Sämtliche Rechte an diesem Produkt liegen beim Landesvermessungsamt NRW. Die Nutzung ist bis auf Widerruf kostenfrei. Der Nutzer muss sich vor jeder Nutzung beim Landesvermessungsamt NRW identifizieren und seine spezielle Nutzung mit Angabe des Verwendungszwecks und Umfang der Nutzung anmelden (Kontaktmoeglichkeiten zum Landesvermessungsamt NRW siehe unten). Die Nutzung ist ausschliesslich fuer Testzwecke und im Rahmen von GDI-Projekten zulässig; die Nutzung fuer kommerzielle Anwendungen ist ausdruecklich ausgeschlossen. Die mittelbare oder unmittelbare Weitergabe der Daten an Dritte ist auch in Verbindung mit weiteren Daten ohne ausdrueckliche Genehmigung durch das Landesvermessungsamt NRW nicht zulässig. Der Nutzer ist verpflichtet, einen deutlichen Copyright-Hinweis auf das Landesvermessungsamt NRW als Dateneigentuemer bei Visualisierungen jeder Art anzubringen.', 'http://www.geoserver.nrw.de:80/GeoOgcWms1.3/servlet/TK100', 'http://www.geoserver.nrw.de:80/GeoOgcWms1.3/servlet/TK100', 'http://www.geoserver.nrw.de:80/GeoOgcWms1.3/servlet/TK100', '', NULL, '<?xml version=''1.0'' encoding="ISO-8859-1" standalone="no" ?> 
 <!-- The DTD (Document Type Definition) given here must correspond to the version number declared in the WMT_MS_Capabilities element below. -->
 <!DOCTYPE WMT_MS_Capabilities SYSTEM 
   "http://www.geoserver.nrw.de/wmt/xml/capabilities_1_1_0.dtd"
@@ -16798,7 +16798,7 @@
   <!-- Human-readable title for pick lists -->
   <Title>NRW: TK100 Farbe</Title>
   <!-- Narrative description providing additional information -->
-      <Abstract>Nutzungsbedingungen: Sämtliche Rechte an diesem Produkt liegen beim Landesvermessungsamt NRW. Die Nutzung ist bis auf Widerruf kostenfrei. Der Nutzer muss sich vor jeder Nutzung beim Landesvermessungsamt NRW identifizieren und seine spezielle Nutzung mit Angabe des Verwendungszwecks und Umfang der Nutzung anmelden (KontaktmÃƒÆ’Ã‚Â¶glichkeiten zum Landesvermessungsamt NRW siehe unten). Die Nutzung ist ausschlieÃƒÆ’Ã…Â¸lich fÃƒÆ’Ã‚Â¼r Testzwecke und im Rahmen von GDI-Projekten zulässig; die Nutzung fÃƒÆ’Ã‚Â¼r kommerzielle Anwendungen ist ausdrÃƒÆ’Ã‚Â¼cklich ausgeschlossen. Die mittelbare oder unmittelbare Weitergabe der Daten an Dritte ist auch in Verbindung mit weiteren Daten ohne ausdrÃƒÆ’Ã‚Â¼ckliche Genehmigung durch das Landesvermessungsamt NRW nicht zulässig. Der Nutzer ist verpflichtet, einen deutlichen Copyright-Hinweis auf das Landesvermessungsamt NRW als DateneigentÃƒÆ’Ã‚Â¼mer bei Visualisierungen jeder Art anzubringen.</Abstract>
+      <Abstract>Nutzungsbedingungen: Sämtliche Rechte an diesem Produkt liegen beim Landesvermessungsamt NRW. Die Nutzung ist bis auf Widerruf kostenfrei. Der Nutzer muss sich vor jeder Nutzung beim Landesvermessungsamt NRW identifizieren und seine spezielle Nutzung mit Angabe des Verwendungszwecks und Umfang der Nutzung anmelden (Kontaktmoeglichkeiten zum Landesvermessungsamt NRW siehe unten). Die Nutzung ist ausschliesslich fuer Testzwecke und im Rahmen von GDI-Projekten zulässig; die Nutzung fuer kommerzielle Anwendungen ist ausdruecklich ausgeschlossen. Die mittelbare oder unmittelbare Weitergabe der Daten an Dritte ist auch in Verbindung mit weiteren Daten ohne ausdrueckliche Genehmigung durch das Landesvermessungsamt NRW nicht zulässig. Der Nutzer ist verpflichtet, einen deutlichen Copyright-Hinweis auf das Landesvermessungsamt NRW als Dateneigentuemer bei Visualisierungen jeder Art anzubringen.</Abstract>
       <!-- Top-level web address of service or service provider.  See also OnlineResource
   elements under <DCPType>. -->
       
@@ -18986,8 +18986,8 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>lwas</Name>
-        <Title>FlÃƒÆ’Ã‚Â¼sse und Kanäle</Title>
-        <Abstract>FlÃƒÆ’Ã‚Â¼sse und Kanäle</Abstract>
+        <Title>Fluesse und Kanäle</Title>
+        <Abstract>Fluesse und Kanäle</Abstract>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.2394" miny="51.3212" maxx="14.7654" maxy="53.5254" />
         <BoundingBox SRS="EPSG:25833"
@@ -19016,8 +19016,8 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>kstr</Name>
-        <Title>KreisstraÃƒÆ’Ã…Â¸en</Title>
-        <Abstract>KreisstraÃƒÆ’Ã…Â¸en</Abstract>
+        <Title>Kreisstrassen</Title>
+        <Abstract>Kreisstrassen</Abstract>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.2393" miny="51.3127" maxx="14.7641" maxy="53.5593" />
         <BoundingBox SRS="EPSG:25833"
@@ -19026,8 +19026,8 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>lstr</Name>
-        <Title>LandesstraÃƒÆ’Ã…Â¸en</Title>
-        <Abstract>LandesstraÃƒÆ’Ã…Â¸en</Abstract>
+        <Title>Landesstrassen</Title>
+        <Abstract>Landesstrassen</Abstract>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.3238" miny="51.3172" maxx="14.7548" maxy="53.5632" />
         <BoundingBox SRS="EPSG:25833"
@@ -19036,8 +19036,8 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>bstr</Name>
-        <Title>BundesstraÃƒÆ’Ã…Â¸en</Title>
-        <Abstract>BundesstraÃƒÆ’Ã…Â¸en</Abstract>
+        <Title>Bundesstrassen</Title>
+        <Abstract>Bundesstrassen</Abstract>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.2459" miny="51.3585" maxx="14.7403" maxy="53.4965" />
         <BoundingBox SRS="EPSG:25833"
@@ -20757,8 +20757,8 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>lwas</Name>
-        <Title>FlÃƒÆ’Ã‚Â¼sse und Kanäle</Title>
-        <Abstract>FlÃƒÆ’Ã‚Â¼sse und Kanäle</Abstract>
+        <Title>Fluesse und Kanäle</Title>
+        <Abstract>Fluesse und Kanäle</Abstract>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.3337" miny="51.3295" maxx="14.6826" maxy="53.4539" />
         <BoundingBox SRS="EPSG:25833"
@@ -20787,8 +20787,8 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>lstr</Name>
-        <Title>LandesstraÃƒÆ’Ã…Â¸en</Title>
-        <Abstract>LandesstraÃƒÆ’Ã…Â¸en</Abstract>
+        <Title>Landesstrassen</Title>
+        <Abstract>Landesstrassen</Abstract>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.3234" miny="51.318" maxx="14.7561" maxy="53.5644" />
         <BoundingBox SRS="EPSG:25833"
@@ -20797,8 +20797,8 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>bstr</Name>
-        <Title>BundesstraÃƒÆ’Ã…Â¸en</Title>
-        <Abstract>BundesstraÃƒÆ’Ã…Â¸en</Abstract>
+        <Title>Bundesstrassen</Title>
+        <Abstract>Bundesstrassen</Abstract>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.2485" miny="51.3577" maxx="14.747" maxy="53.4523" />
         <BoundingBox SRS="EPSG:25833"
@@ -20852,7 +20852,7 @@
     <ContactAddress>
         <AddressType></AddressType>
         <Address>Albersloher Weg 33</Address>
-        <City>MÃƒÆ’Ã‚Â¼nster</City>
+        <City>Muenster</City>
         <StateOrProvince></StateOrProvince>
         <PostCode>48155</PostCode>
         <Country>Germany</Country>
@@ -20998,7 +20998,7 @@
   </Layer>
 </Capability>
 </WMT_MS_Capabilities>
-', NULL, 'http://geo.stadt-muenster.de/cgi-bin/geobasis?REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.0', 'none', 'none', 'Norbert Dephoff', '', 'Vermessungs- und Katasteramt', 'Albersloher Weg 33', 'MÃƒÆ’Ã‚Â¼nster', '', '48155', 'Germany', '', '', 'dephoffn at stadt-muenster.de', NULL, 1, 1173698462, NULL, NULL, NULL, NULL);
+', NULL, 'http://geo.stadt-muenster.de/cgi-bin/geobasis?REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.0', 'none', 'none', 'Norbert Dephoff', '', 'Vermessungs- und Katasteramt', 'Albersloher Weg 33', 'Muenster', '', '48155', 'Germany', '', '', 'dephoffn at stadt-muenster.de', NULL, 1, 1173698462, NULL, NULL, NULL, NULL);
 INSERT INTO wms (wms_id, wms_version, wms_title, wms_abstract, wms_getcapabilities, wms_getmap, wms_getfeatureinfo, wms_getlegendurl, wms_filter, wms_getcapabilities_doc, wms_owsproxy, wms_upload_url, fees, accessconstraints, contactperson, contactposition, contactorganization, address, city, stateorprovince, postcode, country, contactvoicetelephone, contactfacsimiletelephone, contactelectronicmailaddress, wms_mb_getcapabilities_doc, wms_owner, wms_timestamp, wms_supportsld, wms_userlayer, wms_userstyle, wms_remotewfs) VALUES (906, '1.1.0', 'DNM VG', 'Digitales Navigationsmodell Verwaltungsgrenzen als Basisnavigationsdaten der Brandenburger Landesvermessung', 'http://geoservice.geobasis-bb.de/cgi-bin/proxy?USER_ID=GAST12345678&map=wms/DNMVG.map&', 'http://geoservice.geobasis-bb.de/cgi-bin/proxy?USER_ID=GAST12345678&map=wms/DNMVG.map&', 'http://geoservice.geobasis-bb.de/cgi-bin/proxy?USER_ID=GAST12345678&map=wms/DNMVG.map&', '', NULL, '<?xml version=''1.0'' encoding="ISO-8859-1" standalone="no" ?>
 <!DOCTYPE WMT_MS_Capabilities SYSTEM "http://www.digitalearth.gov/wmt/xml/capabilities_1_1_0.dtd"
  [
@@ -21106,7 +21106,7 @@
     </Layer>
     <Layer queryable="1" opaque="0" cascaded="0">
         <Name>amt</Name>
-        <Title>ÃƒÆ’Ã¢â‚¬Å¾mter</Title>
+        <Title>Aemter</Title>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.2423" miny="51.3099" maxx="14.7656" maxy="53.4443" />
         <BoundingBox SRS="EPSG:25833"
@@ -21169,7 +21169,7 @@
     </Layer>
     <Layer queryable="0" opaque="0" cascaded="0">
         <Name>namt</Name>
-        <Title>Namen der ÃƒÆ’Ã¢â‚¬Å¾mter</Title>
+        <Title>Namen der Aemter</Title>
         <SRS>EPSG:25833</SRS>
         <LatLonBoundingBox minx="11.2423" miny="51.3099" maxx="14.7656" maxy="53.4443" />
         <BoundingBox SRS="EPSG:25833"

