https://kvwmap.de/wiki/index.php?action=history&feed=atom&title=GLE-Layer-FMK-Raumordnung 2026-04-21T18:08:12Z Versionsgeschichte dieser Seite in kvwmap MediaWiki 1.23.1 https://kvwmap.de/wiki/index.php?title=GLE-Layer-FMK-Raumordnung&diff=15140&oldid=prev 2023-09-07T09:19:36Z

<p>Die Seite wurde neu angelegt: „===SQL-Dump der in kvwmap für die Fachschale FMK benötigten Layer, Klassen, Attribute, Labels, Styles und Drucklayouts für die Raumordnung=== GLE-Fachscha…“</p> <p><b>Neue Seite</b></p><div>===SQL-Dump der in kvwmap für die Fachschale FMK benötigten Layer, Klassen, Attribute, Labels, Styles und Drucklayouts für die Raumordnung===<br /> [[GLE-Fachschalen#Fl.C3.A4chenmanagementkataster|zurück zur Fachschalenbeschreibung]]<br /> <br /> Folgende Anpassungen müssen vorgenommen werden<br /> * Anpassung der ID der Gruppe zu der der Layer der Raumordnung gehören soll<br /> * Anpassung der ID der Connection für den Zugang zur Postgre-Datenbank<br /> <br /> -- Layerdump aus kvwmap vom 07.09.2023 11:14:29<br /> -- Achtung: Die Datenbank in die der Dump eingespielt wird, sollte die gleiche Migrationsversion haben,<br /> -- wie die Datenbank aus der exportiert wurde! Anderenfalls kann es zu Fehlern bei der Ausführung des SQL kommen.<br /> SET @group_id = 1;<br /> SET @connection = '';<br /> SET @connection_id = '1';<br /> <br /> -- Layer 50<br /> INSERT INTO layer (`Name`, `alias`, `Datentyp`, `Gruppe`, `pfad`, `maintable`, `oid`, `Data`, `schema`, `document_path`, `tileindex`, `tileitem`, `labelangleitem`, `labelitem`, `labelmaxscale`, `labelminscale`, `labelrequires`, `connection`, `connection_id`, `printconnection`, `connectiontype`, `classitem`, `tolerance`, `toleranceunits`, `sizeunits`, `epsg_code`, `template`, `queryable`, `transparency`, `drawingorder`, `minscale`, `maxscale`, `offsite`, `ows_srs`, `wms_name`, `wms_server_version`, `wms_format`, `wms_connectiontimeout`, `wms_auth_username`, `wms_auth_password`, `wfs_geom`, `write_mapserver_templates`, `selectiontype`, `querymap`, `logconsume`, `processing`, `kurzbeschreibung`, `datasource`, `dataowner_name`, `dataowner_email`, `dataowner_tel`, `uptodateness`, `updatecycle`, `metalink`, `privileg`, `trigger_function`) VALUES ('Planungsräume', '', '2', @group_id, 'SELECT\r\n gid,\r\n plr,\r\n plr_ziffer,\r\n txt,\r\n the_geom\r\nFROM\r\n planungsraumflaechen\r\nWHERE\r\n true', 'planungsraumflaechen', 'gid', 'the_geom from (SELECT gid, txt, plr, the_geom FROM raumordnung.planungsraumflaechen) as foo using unique gid using srid=25832', 'raumordnung', '', '', '', '', 'txt', NULL, NULL, '', @connection, @connection_id, '', '6', 'plr', '3', 'pixels', NULL, '25832', '', '1', '60', '60', NULL, NULL, '', 'EPSG:4326', '', '1.0.0', 'image/png', '60', '', '', '', '', '', '1', '0', '', '', '9', '', '', '', '', '', '', '0', '');<br /> SET @last_layer_id50=LAST_INSERT_ID();<br /> <br /> -- Attribut gid des Layers 50<br /> INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id50, 'gid', 'gid', 'planungsraumflaechen', 'planungsraumflaechen', 'int4', '', 'PRIMARY KEY', '1', '0', '32', '0', '', 'Text', '', 'ID', '', '', '', '', '', '', '0', '0', NULL, '0', '-1', NULL, '1', '', '', '', '1', '0', '0');<br /> <br /> -- Attribut plr des Layers 50<br /> INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id50, 'plr', 'plr', 'planungsraumflaechen', 'planungsraumflaechen', 'int4', '', '', '1', '1', '32', '0', '', 'Text', '', 'Nummer', '', '', '', '', '', '', '0', '0', NULL, '0', '-1', NULL, '1', '', '', '', '19', '0', '0');<br /> <br /> -- Attribut plr_ziffer des Layers 50<br /> INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id50, 'plr_ziffer', 'plr_ziffer', 'planungsraumflaechen', 'planungsraumflaechen', 'varchar', '', '', '1', '1', NULL, NULL, '', 'Text', '', 'Ziffer', '', '', '', '', '', '', '0', '0', NULL, '0', '-1', NULL, '1', '', '', '', '17', '0', '0');<br /> <br /> -- Attribut the_geom des Layers 50<br /> INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id50, 'the_geom', 'the_geom', 'planungsraumflaechen', 'planungsraumflaechen', 'geometry', 'MULTIPOLYGON', '', '1', '1', NULL, NULL, '', 'Geometrie', '', '', '', '', '', '', '', '', '0', '0', NULL, '0', '-1', NULL, '1', '', '', '', '22', '0', '0');<br /> <br /> -- Attribut txt des Layers 50<br /> INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id50, 'txt', 'txt', 'planungsraumflaechen', 'planungsraumflaechen', 'varchar', '', '', '1', '1', NULL, NULL, '', 'Text', '', 'Bezeichnung', '', '', '', '', '', '', '0', '0', NULL, '0', '0', NULL, '1', '', '', '', '9', '0', '1');<br /> <br /> -- Class 198 des Layers 50<br /> INSERT INTO classes (`Name`, `Layer_ID`, `Expression`, `drawingorder`, `text`) VALUES (' ', @last_layer_id50, '', NULL, '');<br /> SET @last_class_id=LAST_INSERT_ID();<br /> <br /> -- Style 122 der Class 198<br /> INSERT INTO styles (`symbol`, `symbolname`, `size`, `color`, `backgroundcolor`, `outlinecolor`, `colorrange`, `datarange`, `rangeitem`, `opacity`, `minsize`, `maxsize`, `minscale`, `maxscale`, `angle`, `angleitem`, `width`, `minwidth`, `maxwidth`, `offsetx`, `offsety`, `polaroffset`, `pattern`, `geomtransform`, `gap`, `initialgap`, `linecap`, `linejoin`, `linejoinmaxsize`) VALUES (NULL, '', '1', '', '', '025 025 112', '', '', '', '50', '', '', NULL, NULL, '', '', '3', '2', '2', NULL, NULL, '', '', '', NULL, NULL, '', '', NULL);<br /> SET @last_style_id=LAST_INSERT_ID();<br /> -- Zuordnung Style 122 zu Class 198<br /> INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);<br /> <br /> -- Label 15 der Class 198<br /> INSERT INTO labels (`font`, `type`, `color`, `outlinecolor`, `shadowcolor`, `shadowsizex`, `shadowsizey`, `backgroundcolor`, `backgroundshadowcolor`, `backgroundshadowsizex`, `backgroundshadowsizey`, `size`, `minsize`, `maxsize`, `position`, `offsetx`, `offsety`, `angle`, `anglemode`, `buffer`, `minfeaturesize`, `maxfeaturesize`, `partials`, `wrap`, `the_force`) VALUES ('arial', NULL, '', '', '', NULL, NULL, '', '', NULL, NULL, '10', '6', '12', '6', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);<br /> SET @last_label_id=LAST_INSERT_ID();<br /> -- Zuordnung Label 15 zu Class 198<br /> INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);<br /> <br /> -- Replace attribute options for Layer 50<br /> UPDATE layer_attributes SET options = REPLACE(options, 'layer_id=50', CONCAT('layer_id=', @last_layer_id50)) WHERE layer_id IN (@last_layer_id50) AND form_element_type IN ('Autovervollständigungsfeld', 'Auswahlfeld', 'Link','dynamicLink');<br /> UPDATE layer_attributes SET options = REPLACE(options, '50,', CONCAT(@last_layer_id50, ',')) WHERE layer_id IN (@last_layer_id50) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');</div>

Pkorduan