Gruppen und Themen für ALKIS

Wichtige Hinweise

Die ALKIS-Komponenten von kvwmap basieren auf dem NAS-Datenbank-Schema von NorBIT. Verknüpfungen zwischen Objekttabellen in Abfragen müssen über die Beziehungsfelder in den Objekttabellen erfolgen, nicht über die Tabelle alkis_beziehungen.

kvwmap unterstützt außerdem die Vollhistorisierung der NAS-Daten, weshalb alle Abfragen mit einem zeitlichen Filter versehen werden müssen. In den SQL-Abfragen "data" und "query" der Layerdefinitionen kann das Schlüsselwort $hist_timestamp verwendet werden. $hist_timestamp wird von kvwmap zur Laufzeit durch den vom Nutzer frei einstellbaren Zeitpunkt ersetzt. Für einen simplen Flurstückslayer sehen "query" und "data" folgendermaßen aus:

query:

SELECT * FROM ax_flurstueck WHERE CASE WHEN '$hist_timestamp' = '' THEN endet IS NULL ELSE beginnt <= '$hist_timestamp' and ('$hist_timestamp' <= endet or endet IS NULL) END

data:

wkb_geometry from (select wkb_geometry, ogc_fid from alkis.ax_flurstueck where CASE WHEN '$hist_timestamp' = '' THEN endet IS NULL ELSE beginnt <= '$hist_timestamp' and ('$hist_timestamp' <= endet or endet IS NULL) END) as foo using unique ogc_fid using srid=25833

ALKIS-Basisthemen

Angaben zum Flurstück

LUP

Flurstück

SET @group_id = 1;
SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';

INSERT INTO layer (`Name`,`alias`,`Datentyp`,`Gruppe`,`pfad`,`maintable`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`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`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`,`metalink`,`privileg`) VALUES('Flurstuecke','','2',@group_id,'SELECT wkb_geometry, f.flurstueckskennzeichen as flurstkennz, \'\' as flurnr, \'\' AS entsteh, \'\' AS letzff, \'\' AS status, \'\' AS flaeche, \'\' AS karte, \'\' AS kreisid, \'\' AS kreisname, \'\' as gemkgschl, \'\' AS gemkgname, \'\' AS gemeinde, \'\' AS gemeindename,\'\' AS finanzamt,\'\' AS finanzamtname, \'\' AS forstschluessel, \'\' AS forstname, \'\' AS lagebezeichnung, \'\' AS nutzung, \'\' AS ausfstelle,\'\' AS verfahren, \'\' AS vorgaenger, \'\' AS nachfolger, \'\' AS bestandsnr,\'\' AS eigentuemer, \'\' AS freitext, \'\' AS hinweis,\'\' AS baulasten, \'\' AS amtsgerichtname, \'\' AS amtsgerichtnr,\'\' AS grundbuchbezirkname, \'\' AS grundbuchbezirkschl, \'\' AS klassifizierung FROM ax_flurstueck AS f WHERE 1=1','ax_flurstueck','the_geom from (select wkb_geometry as the_geom, ogc_fid from alkis.ax_flurstueck) as foo using unique ogc_fid using srid=25833','alkis','','','','','',NULL,NULL,'',@connection,'','6','ogc_fid','ogc_fid','3','pixels','25833','Flurstuecke_customALKIS.php','1',NULL,'1000',NULL,NULL,'','EPSG:25833','ALK-Flurstücke','1.1.0','image/png','60','','','','','1','0','','','','','0');

SET @last_layer_id582=LAST_INSERT_ID();
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('alle',@last_layer_id582,'','0','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','1','-1 -1 -1','  ','0 0 0',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'');
SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);

Flurstücksnummer

mit Zuordnungspfeilen

SET @group_id = 1;
SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';

INSERT INTO layer (`Name`,`Datentyp`,`Gruppe`,`pfad`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`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`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`,`metalink`,`privileg`) VALUES('ALKIS (Flurstnr)','3',@group_id,'','','','','','','','',NULL,NULL,'','http://localhost/cgi-bin/mapserv?map=/home/fgs/fgs/www/wms/alkis/alkis-07.map&service=wms&VERSION=1.1.1&REQUEST=GetMap&TRANSPARENT=true&FORMAT=image/png&LAYERS=ag_t_flurstueck,ag_l_flurstueck,sk2004_zuordnungspfeil_spitze,ag_p_flurstueck&','','7','','','3','pixels','25833','','0','65','30000994','1','10000','','EPSG:25833','','1.1.1','image/png','60','','','','','0','0','','ALKIS - Test (WMS)','Vermessungs- und Geoinformationsbehörde LWL-PCH','','0');
SET @last_layer_id1260=LAST_INSERT_ID();
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('',@last_layer_id1260,'','1','');
SET @last_class_id=LAST_INSERT_ID();

UPDATE layer_attributes SET options = REPLACE(options, '1260', @last_layer_id1260) WHERE layer_id IN(@last_layer_id1260) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');

Grenzpunkt

SET @group_id = 1;
SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';

INSERT INTO layer (`Name`,`alias`,`Datentyp`,`Gruppe`,`pfad`,`maintable`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`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`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`,`metalink`,`privileg`) VALUES('Alkis Grenzpunkte','','0',@group_id,'select * from lk_grenzpunkte where 1 = 1','lk_grenzpunkte','the_geom from (select oid, gml_id, ax_datenerhebung_punktort,punktkennung, wkb_geometry as the_geom from alkis.lk_grenzpunkte) as foo using unique oid using srid=25833','alkis','','','','','punktkennung','1000','50','',@connection,'','6','','','3','pixels','25833','','1',NULL,'30000790','1','30005','255 255 255','EPSG:2398','','1.1.0','image/png','60','','','','','0','0','','Qualität der Grenzpunkte','Vermessungs- und Geoinformationsbehörde LWL-PCH','','0');
SET @last_layer_id1145=LAST_INSERT_ID();
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1145,'abmarkung_marke','abmarkung_marke','lk_grenzpunkte','lk_grenzpunkte','int4','','','1','32','Text','','','','4','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1145,'ax_datenerhebung_punktort','ax_datenerhebung_punktort','lk_grenzpunkte','lk_grenzpunkte','int4','','','1','32','Text','','','','6','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1145,'bemerkungzurabmarkung','bemerkungzurabmarkung','lk_grenzpunkte','lk_grenzpunkte','int4','','','1','32','Text','','','','10','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1145,'bem_bedeutung','bem_bedeutung','lk_grenzpunkte','lk_grenzpunkte','varchar','','','1','100','Text','','','','11','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1145,'bezeichner','bezeichner','lk_grenzpunkte','lk_grenzpunkte','varchar','','','1',NULL,'Text','','','','7','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1145,'bezeichner2','bezeichner2','lk_grenzpunkte','lk_grenzpunkte','varchar','','','1',NULL,'Text','','','','8','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1145,'genauigkeitsstufe','genauigkeitsstufe','lk_grenzpunkte','lk_grenzpunkte','int4','','','1','32','Text','','','','12','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1145,'gml_id','gml_id','lk_grenzpunkte','lk_grenzpunkte','bpchar','','','1','16','Text','','','','1','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1145,'koord','koord','lk_grenzpunkte','lk_grenzpunkte','text','','','1',NULL,'Text','','','','16','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1145,'oid','oid','lk_grenzpunkte','lk_grenzpunkte','oid','','','1',NULL,'Text','','','','0','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1145,'punktgenauigkeit','punktgenauigkeit','lk_grenzpunkte','lk_grenzpunkte','varchar','','','1','50','Text','','Punktgenauigkeit','','13','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1145,'punktkennung','punktkennung','lk_grenzpunkte','lk_grenzpunkte','varchar','','','1',NULL,'Text','','Pkt. Nummer','','2','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1145,'punktvertrauenswuerdigkeit','punktvertrauenswuerdigkeit','lk_grenzpunkte','lk_grenzpunkte','varchar','','','1','200','Text','','Punktzuverlässigkeit','','15','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1145,'sonstigeeigenschaft','sonstigeeigenschaft','lk_grenzpunkte','lk_grenzpunkte','_varchar','','','1',NULL,'Text','','','','3','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1145,'verm_bedeutung','verm_bedeutung','lk_grenzpunkte','lk_grenzpunkte','varchar','','','1','100','Text','','Vermarkung','','5','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1145,'vertrauenswuerdigkeit','vertrauenswuerdigkeit','lk_grenzpunkte','lk_grenzpunkte','int4','','','1','32','Text','','','','14','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1145,'wkb_geometry','wkb_geometry','lk_grenzpunkte','lk_grenzpunkte','geometry','POINT','','1',NULL,'Geometrie','','','','9','0');
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('GP berechnet',@last_layer_id1145,'(\'[ax_datenerhebung_punktort]\'<\'1801\')','1','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES('25','','30','0 255 0','','0 255 0','7','8','','',NULL,NULL,NULL,NULL,'');
 SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO labels (`font`,`type`,`color`,`outlinecolor`,`shadowcolor`,`shadowsizex`,`shadowsizey`,`backgroundcolor`,`backgroundshadowcolor`,`backgroundshadowsizex`,`backgroundshadowsizey`,`size`,`minsize`,`maxsize`,`position`,`offsetx`,`offsety`,`angle`,`autoangle`,`buffer`,`antialias`,`minfeaturesize`,`maxfeaturesize`,`partials`,`wrap`,`the_force`) VALUES('arial',NULL,'8 16 0','255 255 255','',NULL,NULL,'255 255 255','',NULL,NULL,'7','7','12','6',NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1',NULL,NULL);
 SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('GP digitalisiert',@last_layer_id1145,'(\'[ax_datenerhebung_punktort]\'>\'1899\')','2','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES('25','','30','227 70 0','','227 70 0','7','8','','',NULL,NULL,NULL,NULL,'');
 SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);

UPDATE layer_attributes SET options = REPLACE(options, '1145', @last_layer_id1145) WHERE layer_id IN(@last_layer_id1145) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');

besondere Flurstücksgrenze

Strittige Grenze

SET @group_id = 1;
SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';

INSERT INTO layer (`Name`,`alias`,`Datentyp`,`Gruppe`,`pfad`,`maintable`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`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`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`,`metalink`,`privileg`) VALUES('Alkis strittige Grenze','','1',@group_id,'','ax_besondereflurstuecksgrenze','the_geom from  (SELECT ogc_fid as oid, gml_id, identifier, beginnt, endet, advstandardmodell, 
       anlass, artderflurstuecksgrenze, wkb_geometry as the_geom
  FROM alkis.ax_besondereflurstuecksgrenze fg
WHERE (1000 = ANY (fg.artderflurstuecksgrenze)) AND fg.advstandardmodell::text ~~ \'DLKM\'::text)
as foo using unique oid using srid=25833','alkis','','','','','','2000','1','',@connection,'','6','','','3','pixels','25833','','0','100','20250994','1','200010','','EPSG:25833','','1.1.0','image/png','60','','','','','1','0','','Strittige Grenzen im Landkreis Ludwigslust-Parchim','Vermessungs- und Geoinformationsbehörde LWL-PCH','','0');
SET @last_layer_id11424=LAST_INSERT_ID();
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('strittige Grenze',@last_layer_id11424,'','0','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES('25','','3','64 0 181','','0 51 0','7','15','','',NULL,NULL,NULL,NULL,'');
 SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO labels (`font`,`type`,`color`,`outlinecolor`,`shadowcolor`,`shadowsizex`,`shadowsizey`,`backgroundcolor`,`backgroundshadowcolor`,`backgroundshadowsizex`,`backgroundshadowsizey`,`size`,`minsize`,`maxsize`,`position`,`offsetx`,`offsety`,`angle`,`autoangle`,`buffer`,`antialias`,`minfeaturesize`,`maxfeaturesize`,`partials`,`wrap`,`the_force`) VALUES('arial',NULL,'0 0 0','255 204 51','',NULL,NULL,'255 204 51','',NULL,NULL,'11','11','24',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1','35',NULL);
 SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);

UPDATE layer_attributes SET options = REPLACE(options, '11424', @last_layer_id11424) WHERE layer_id IN(@last_layer_id11424) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');

Angaben zum Netzpunkt

LUP

Aufnahmepunkt

SET @group_id = 1;
SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';

INSERT INTO layer (`Name`,`Datentyp`,`Gruppe`,`pfad`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`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`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`,`metalink`,`privileg`) VALUES('Alkis AP','0',@group_id,'select * from lk_ap where 1 = 1','the_geom from (select oid, punktkennung, wkb_geometry as the_geom from alkis.lk_ap) as foo using unique oid using srid=25833','alkis','','','','','punktkennung','1000','50','',@connection,'','6','','','3','pixels','25833','','1',NULL,'30000786','0','25001','255 255 255','EPSG:2398','','1.1.0','image/png','60','','','','','0','0','','Qualität der Grenz- und Gebäudepunkte. Ableitung aus der ALK.','Vermessungs- und Geoinformationsbehörde LWL-PCH','','0');
SET @last_layer_id1147=LAST_INSERT_ID();
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1147,'bedeutung','bedeutung','lk_ap','lk_ap','varchar','','','1','200','Text','','','','8','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1147,'bemerkung','bemerkung','lk_ap','lk_ap','varchar','','','1','200','Text','','','','9','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1147,'genauigkeitsstufe','genauigkeitsstufe','lk_ap','lk_ap','int4','','','1','32','Text','','','','5','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1147,'koord','koord','lk_ap','lk_ap','text','','','1',NULL,'Text','','','','11','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1147,'oid','oid','lk_ap','lk_ap','oid','','','1',NULL,'Text','','','','0','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1147,'punktgenauigkeit','punktgenauigkeit','lk_ap','lk_ap','varchar','','','1','50','Text','','','','6','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1147,'punktkennung','punktkennung','lk_ap','lk_ap','varchar','','','1',NULL,'Text','','','','1','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1147,'sonstigeeigenschaft','sonstigeeigenschaft','lk_ap','lk_ap','_varchar','','','1',NULL,'Text','','','','2','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1147,'vermarkung_marke','vermarkung_marke','lk_ap','lk_ap','int4','','','1','32','Text','','','','3','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1147,'verm_bedeutung','verm_bedeutung','lk_ap','lk_ap','varchar','','','1','100','Text','','','','4','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1147,'vertrauenswuerdigkeit','vertrauenswuerdigkeit','lk_ap','lk_ap','int4','','','1','32','Text','','','','7','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1147,'wkb_geometry','wkb_geometry','lk_ap','lk_ap','geometry','POINT','','1',NULL,'Text','','','','10','0');
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('AP',@last_layer_id1147,'','1','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES('34','','30','93 0 149','','0 255 0','7','8',NULL,'',NULL,NULL,NULL,NULL,'');
 SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO labels (`font`,`type`,`color`,`outlinecolor`,`shadowcolor`,`shadowsizex`,`shadowsizey`,`backgroundcolor`,`backgroundshadowcolor`,`backgroundshadowsizex`,`backgroundshadowsizey`,`size`,`minsize`,`maxsize`,`position`,`offsetx`,`offsety`,`angle`,`autoangle`,`buffer`,`antialias`,`minfeaturesize`,`maxfeaturesize`,`partials`,`wrap`,`the_force`) VALUES('arial',NULL,'8 16 0','255 255 255','',NULL,NULL,'255 255 255','',NULL,NULL,'7','7','12','6',NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1',NULL,NULL);
 SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);

UPDATE layer_attributes SET options = REPLACE(options, '1147', @last_layer_id1147) WHERE layer_id IN(@last_layer_id1147) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');


 

Sicherungspunkt

SET @group_id = 1;
SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';

INSERT INTO layer (`Name`,`Datentyp`,`Gruppe`,`pfad`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`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`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`,`metalink`,`privileg`) VALUES('Alkis SP','0',@group_id,'select * from lk_sp where 1 = 1','the_geom from (select oid, punktkennung, wkb_geometry as the_geom from alkis.lk_sp) as foo using unique oid using srid=25833','alkis','','','','','punktkennung','1000','50','',@connection,'','6','','','3','pixels','25833','','1',NULL,'30000784','1','25001','255 255 255','EPSG:2398','','1.1.0','image/png','60','','','','','0','0','','Qualität der Grenz- und Gebäudepunkte. Ableitung aus der ALK.','Vermessungs- und Geoinformationsbehörde LWL-PCH','','0');
SET @last_layer_id1148=LAST_INSERT_ID();
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1148,'bedeutung','bedeutung','lk_sp','lk_sp','varchar','','','1','200','Text','','','','8','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1148,'bemerkung','bemerkung','lk_sp','lk_sp','varchar','','','1','200','Text','','','','9','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1148,'genauigkeitsstufe','genauigkeitsstufe','lk_sp','lk_sp','int4','','','1','32','Text','','','','5','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1148,'koord','koord','lk_sp','lk_sp','text','','','1',NULL,'Text','','','','11','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1148,'oid','oid','lk_sp','lk_sp','oid','','','1',NULL,'Text','','','','0','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1148,'punktgenauigkeit','punktgenauigkeit','lk_sp','lk_sp','varchar','','','1','50','Text','','','','6','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1148,'punktkennung','punktkennung','lk_sp','lk_sp','varchar','','','1',NULL,'Text','','','','1','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1148,'sonstigeeigenschaft','sonstigeeigenschaft','lk_sp','lk_sp','varchar','','','1',NULL,'Text','','','','2','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1148,'vermarkung_marke','vermarkung_marke','lk_sp','lk_sp','int4','','','1','32','Text','','','','3','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1148,'verm_bedeutung','verm_bedeutung','lk_sp','lk_sp','varchar','','','1','100','Text','','','','4','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1148,'vertrauenswuerdigkeit','vertrauenswuerdigkeit','lk_sp','lk_sp','int4','','','1','32','Text','','','','7','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1148,'wkb_geometry','wkb_geometry','lk_sp','lk_sp','geometry','POINT','','1',NULL,'Text','','','','10','0');
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('SP',@last_layer_id1148,'','1','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES('35','','30','164 152 255','','0 255 0','7','8',NULL,'',NULL,NULL,NULL,NULL,'');
 SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO labels (`font`,`type`,`color`,`outlinecolor`,`shadowcolor`,`shadowsizex`,`shadowsizey`,`backgroundcolor`,`backgroundshadowcolor`,`backgroundshadowsizex`,`backgroundshadowsizey`,`size`,`minsize`,`maxsize`,`position`,`offsetx`,`offsety`,`angle`,`autoangle`,`buffer`,`antialias`,`minfeaturesize`,`maxfeaturesize`,`partials`,`wrap`,`the_force`) VALUES('arial',NULL,'8 16 0','255 255 255','',NULL,NULL,'255 255 255','',NULL,NULL,'7','7','12','6',NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1',NULL,NULL);
 SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);

UPDATE layer_attributes SET options = REPLACE(options, '1148', @last_layer_id1148) WHERE layer_id IN(@last_layer_id1148) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');


 

sonst. Vermessungspunkt

SET @group_id = 1;
SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';

INSERT INTO layer (`Name`,`Datentyp`,`Gruppe`,`pfad`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`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`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`,`metalink`,`privileg`) VALUES('Alkis sonstiger Verm_PKT','0',@group_id,'select * from lk_so_punkte where 1 = 1','the_geom from (select oid, punktkennung, wkb_geometry as the_geom from alkis.lk_so_punkte) as foo using unique oid using srid=25833','alkis','','','','','punktkennung','1000','50','',@connection,'','6','','','3','pixels','25833','','1',NULL,'30000782','1','25001','255 255 255','EPSG:2398','','1.1.0','image/png','60','','','','','0','0','','Qualität der Grenz- und Gebäudepunkte. Ableitung aus der ALK.','Vermessungs- und Geoinformationsbehörde LWL-PCH','','0');
SET @last_layer_id1149=LAST_INSERT_ID();
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1149,'bedeutung','bedeutung','lk_so_punkte','lk_so_punkte','varchar','','','1','200','Text','','','','8','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1149,'bemerkung','bemerkung','lk_so_punkte','lk_so_punkte','varchar','','','1','200','Text','','','','9','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1149,'genauigkeitsstufe','genauigkeitsstufe','lk_so_punkte','lk_so_punkte','int4','','','1','32','Text','','','','5','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1149,'koord','koord','lk_so_punkte','lk_so_punkte','text','','','1',NULL,'Text','','','','11','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1149,'oid','oid','lk_so_punkte','lk_so_punkte','oid','','','1',NULL,'Text','','','','0','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1149,'punktgenauigkeit','punktgenauigkeit','lk_so_punkte','lk_so_punkte','varchar','','','1','50','Text','','','','6','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1149,'punktkennung','punktkennung','lk_so_punkte','lk_so_punkte','varchar','','','1',NULL,'Text','','','','1','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1149,'sonstigeeigenschaft','sonstigeeigenschaft','lk_so_punkte','lk_so_punkte','_varchar','','','1',NULL,'Text','','','','2','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1149,'vermarkung_marke','vermarkung_marke','lk_so_punkte','lk_so_punkte','int4','','','1','32','Text','','','','3','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1149,'verm_bedeutung','verm_bedeutung','lk_so_punkte','lk_so_punkte','varchar','','','1','100','Text','','','','4','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1149,'vertrauenswuerdigkeit','vertrauenswuerdigkeit','lk_so_punkte','lk_so_punkte','int4','','','1','32','Text','','','','7','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1149,'wkb_geometry','wkb_geometry','lk_so_punkte','lk_so_punkte','geometry','POINT','','1',NULL,'Text','','','','10','0');
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('sonst.PKT',@last_layer_id1149,'','1','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES('25','','30','255 0 0','','0 255 0','7','8',NULL,'',NULL,NULL,NULL,NULL,'');
 SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO labels (`font`,`type`,`color`,`outlinecolor`,`shadowcolor`,`shadowsizex`,`shadowsizey`,`backgroundcolor`,`backgroundshadowcolor`,`backgroundshadowsizex`,`backgroundshadowsizey`,`size`,`minsize`,`maxsize`,`position`,`offsetx`,`offsety`,`angle`,`autoangle`,`buffer`,`antialias`,`minfeaturesize`,`maxfeaturesize`,`partials`,`wrap`,`the_force`) VALUES('arial',NULL,'8 16 0','255 255 255','',NULL,NULL,'255 255 255','',NULL,NULL,'7','7','12','6',NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1',NULL,NULL);
 SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);

UPDATE layer_attributes SET options = REPLACE(options, '1149', @last_layer_id1149) WHERE layer_id IN(@last_layer_id1149) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');

 

Gebäude

LUP

Gebäude

SET @group_id = 1;
SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';

INSERT INTO layer (`Name`,`alias`,`Datentyp`,`Gruppe`,`pfad`,`maintable`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`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`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`,`metalink`,`privileg`) VALUES('Alkis Gebäude','','2',@group_id,'SELECT * FROM lk_gebaeude WHERE 1=1','lk_gebaeude','the_geom from (select ogc_fid as oid, wkb_geometry as the_geom from alkis.lk_gebaeude) as foo using unique oid using srid=25833','alkis','','','','','',NULL,NULL,'',@connection,'','6','','','3','pixels','25833','','1',NULL,'30000765','1','100000','','EPSG:25833','','1.1.0','image/png','60','','','','','1','0','','Gebäude in ALKIS','Vermessungs- und Geoinformationsbehörde LWL-PCH','','0');
SET @last_layer_id1152=LAST_INSERT_ID();
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1152,'ax_datenerhebung','ax_datenerhebung','lk_gebaeude','lk_gebaeude','int4','','','1','32','Text','','','','15','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1152,'bezeichner','bezeichner','lk_gebaeude','lk_gebaeude','varchar','','','1',NULL,'Text','','','','4','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1152,'dachform','dachform','lk_gebaeude','lk_gebaeude','int4','','','1','32','Text','','','','12','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1152,'dach_bezeichner','dach_bezeichner','lk_gebaeude','lk_gebaeude','varchar','','','1',NULL,'Text','','','','13','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1152,'gebaeudefunktion','gebaeudefunktion','lk_gebaeude','lk_gebaeude','int4','','','1','32','Text','','','','3','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1152,'gebaeudezustand','gebaeudezustand','lk_gebaeude','lk_gebaeude','varchar','','','1',NULL,'Text','','','','9','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1152,'gml_id','gml_id','lk_gebaeude','lk_gebaeude','bpchar','','','1','16','Text','','','','2','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1152,'herkunft','herkunft','lk_gebaeude','lk_gebaeude','varchar','','','1',NULL,'Text','','','','16','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1152,'hochhaus','hochhaus','lk_gebaeude','lk_gebaeude','varchar','','','1',NULL,'Text','','','','14','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1152,'lagezurerdoberflaeche','lagezurerdoberflaeche','lk_gebaeude','lk_gebaeude','int4','','','1','32','Text','','','','11','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1152,'name','name','lk_gebaeude','lk_gebaeude','_varchar','','','1',NULL,'Text','','','','5','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1152,'objekthoehe','objekthoehe','lk_gebaeude','lk_gebaeude','int4','','','1','32','Text','','','','10','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1152,'ogc_fid','ogc_fid','lk_gebaeude','lk_gebaeude','int4','','','1','32','Text','','','','1','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1152,'oid','oid','lk_gebaeude','lk_gebaeude','oid','','','1',NULL,'Text','','','','0','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1152,'weiterefunktion_bezeich','weiterefunktion_bezeich','lk_gebaeude','lk_gebaeude','varchar','','','1',NULL,'Text','','','','7','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1152,'weiterefunktion_wert','weiterefunktion_wert','lk_gebaeude','lk_gebaeude','int4','','','1','32','Text','','','','6','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1152,'wkb_geometry','wkb_geometry','lk_gebaeude','lk_gebaeude','geometry','POLYGON','','1',NULL,'Text','','','','17','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1152,'zustand','zustand','lk_gebaeude','lk_gebaeude','int4','','','1','32','Text','','','','8','0');
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('alle',@last_layer_id1152,'','0','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','1','-1 -1 -1','  ','0 0 0',NULL,NULL,'','',NULL,NULL,NULL,NULL,'');
 SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO labels (`font`,`type`,`color`,`outlinecolor`,`shadowcolor`,`shadowsizex`,`shadowsizey`,`backgroundcolor`,`backgroundshadowcolor`,`backgroundshadowsizex`,`backgroundshadowsizey`,`size`,`minsize`,`maxsize`,`position`,`offsetx`,`offsety`,`angle`,`autoangle`,`buffer`,`antialias`,`minfeaturesize`,`maxfeaturesize`,`partials`,`wrap`,`the_force`) VALUES('arial',NULL,'240 0 19','255 255 255','',NULL,NULL,'255 255 255','',NULL,NULL,'8','6','10',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1',NULL,NULL);
 SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);

UPDATE layer_attributes SET options = REPLACE(options, '1152', @last_layer_id1152) WHERE layer_id IN(@last_layer_id1152) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');

gebäudebez. Bauwerke

SET @group_id = 1;
SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';

INSERT INTO layer (`Name`,`alias`,`Datentyp`,`Gruppe`,`pfad`,`maintable`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`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`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`,`metalink`,`privileg`) VALUES('Alkis gebäudebez. Bauwerke','','2',@group_id,'SELECT * FROM lk_bes_gebaeude WHERE bauwerksfunktion < 1700','lk_bes_gebaeude','the_geom from (select ogc_fid as oid, bezeichner, bauwerksfunktion, wkb_geometry, wkb_geometry as the_geom from alkis.lk_bes_gebaeude) as foo using unique oid using srid=25833','alkis','','','','','bezeichner','505','1','',@connection,'','6','','','3','pixels','25833','','1',NULL,'30000765','1','100000','','EPSG:25833','','1.1.0','image/png','60','','','','','1','0','','Gebäude in ALKIS','Vermessungs- und Geoinformationsbehörde LWL-PCH','','0');
SET @last_layer_id1274=LAST_INSERT_ID();
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1274,'bauwerksfunktion','bauwerksfunktion','lk_bes_gebaeude','lk_bes_gebaeude','int4','','','1','32','Text','','','','3','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1274,'bezeichner','bezeichner','lk_bes_gebaeude','lk_bes_gebaeude','varchar','','','1',NULL,'Text','','','','4','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1274,'gml_id','gml_id','lk_bes_gebaeude','lk_bes_gebaeude','bpchar','','','1','16','Text','','','','2','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1274,'ogc_fid','ogc_fid','lk_bes_gebaeude','lk_bes_gebaeude','int4','','','1','32','Text','','','','1','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1274,'oid','oid','lk_bes_gebaeude','lk_bes_gebaeude','oid','','','1',NULL,'Text','','','','0','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id1274,'wkb_geometry','wkb_geometry','lk_bes_gebaeude','lk_bes_gebaeude','geometry','POLYGON','','1',NULL,'Text','','','','5','0');
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('alle',@last_layer_id1274,'(\'[bauwerksfunktion]\'<\'1700\')','0','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','2','-1 -1 -1','  ','23 0 108','2','2','','',NULL,NULL,NULL,NULL,'');
 SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO labels (`font`,`type`,`color`,`outlinecolor`,`shadowcolor`,`shadowsizex`,`shadowsizey`,`backgroundcolor`,`backgroundshadowcolor`,`backgroundshadowsizex`,`backgroundshadowsizey`,`size`,`minsize`,`maxsize`,`position`,`offsetx`,`offsety`,`angle`,`autoangle`,`buffer`,`antialias`,`minfeaturesize`,`maxfeaturesize`,`partials`,`wrap`,`the_force`) VALUES('arial',NULL,'240 0 19','255 255 255','',NULL,NULL,'255 255 255','',NULL,NULL,'4','4','6',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1',NULL,NULL);
 SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);

UPDATE layer_attributes SET options = REPLACE(options, '1274', @last_layer_id1274) WHERE layer_id IN(@last_layer_id1274) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');

Bauwerke

LRO

Tatsächliche Nutzung

LRO

Relief

MSE

Festlegungen

MSE

Bodenschätzung

VR

Bodenschätzung

SET @group_id = 1;
SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';

INSERT INTO layer (`Name`,`Datentyp`,`Gruppe`,`pfad`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`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`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`,`metalink`,`privileg`) VALUES('ALKIS_Bodenschätzung','2',@group_id,'select * from ax_bodenschaetzung where 1=1','the_geom from (select a.oid, c.kurz||d.kurz as label, b.kurz,
bodenzahlodergruenlandgrundzahl,ackerzahlodergruenlandzahl, a.wkb_geometry as the_geom 
FROM alkis.ax_bodenschaetzung as a, alkis.ax_bodenschaetzung_kulturart as b, 
alkis.ax_bodenschaetzung_bodenart as c, alkis.ax_bodenschaetzung_zustandsstufe as d
WHERE a.kulturart=b.wert 
AND a.bodenart=c.wert
AND a.zustandsstufeoderbodenstufe = d.wert) as foo using unique oid using srid=25833','alkis','','','','','label','5001','49','',@connection,'','6','','oid','3','pixels','25833','','1','50','94010','49','5001','','EPSG:25833','','1.1.0','image/png','60','','','','','1','0','','Reichsbodenschätzung aus ALKIS','Fachdienst Kataster und Vermessung','','0');
SET @last_layer_id50303347=LAST_INSERT_ID();
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303347,'ackerzahlodergruenlandzahl','ackerzahlodergruenlandzahl','ax_bodenschaetzung','ax_bodenschaetzung','int4','','','1','32','Text','','','','12','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303347,'advstandardmodell','advstandardmodell','ax_bodenschaetzung','ax_bodenschaetzung','varchar','','','1',NULL,'Text','','','','5','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303347,'anlass','anlass','ax_bodenschaetzung','ax_bodenschaetzung','varchar','','','1',NULL,'Text','','','','6','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303347,'beginnt','beginnt','ax_bodenschaetzung','ax_bodenschaetzung','bpchar','','','1','20','Text','','','','3','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303347,'bodenart','bodenart','ax_bodenschaetzung','ax_bodenschaetzung','int4','','','1','32','Text','','','','8','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303347,'bodenzahlodergruenlandgrundzahl','bodenzahlodergruenlandgrundzahl','ax_bodenschaetzung','ax_bodenschaetzung','int4','','','1','32','Text','','','','11','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303347,'endet','endet','ax_bodenschaetzung','ax_bodenschaetzung','bpchar','','','1','20','Text','','','','4','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303347,'entstehungsartoderklimastufewasserverhaeltnisse','entstehungsartoderklimastufewasserverhaeltnisse','ax_bodenschaetzung','ax_bodenschaetzung','_int4','','','1',NULL,'Text','','','','10','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303347,'gml_id','gml_id','ax_bodenschaetzung','ax_bodenschaetzung','bpchar','','','1','16','Text','','','','1','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303347,'identifier','identifier','ax_bodenschaetzung','ax_bodenschaetzung','bpchar','','','1','44','Text','','','','2','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303347,'jahreszahl','jahreszahl','ax_bodenschaetzung','ax_bodenschaetzung','int4','','','1','32','Text','','','','14','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303347,'kulturart','kulturart','ax_bodenschaetzung','ax_bodenschaetzung','int4','','','1','32','Text','','','','7','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303347,'ogc_fid','ogc_fid','ax_bodenschaetzung','ax_bodenschaetzung','int4','','PRIMARY KEY','1','32','Text','','','','0','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303347,'sonstigeangaben','sonstigeangaben','ax_bodenschaetzung','ax_bodenschaetzung','_int4','','','1',NULL,'Text','','','','13','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303347,'wkb_geometry','wkb_geometry','ax_bodenschaetzung','ax_bodenschaetzung','geometry','POLYGON','','1',NULL,'Text','','','','15','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303347,'zustandsstufeoderbodenstufe','zustandsstufeoderbodenstufe','ax_bodenschaetzung','ax_bodenschaetzung','int4','','','1','32','Text','','','','9','0');
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Grünland-Acker',@last_layer_id50303347,'(\'[kurz]\' = \'GrA\')','4','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','3','22 154 0','','-1 -1 -1',NULL,NULL,'','',NULL,NULL,NULL,NULL,'');
 SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'punkt','4','-1 -1 -1','','0 98 3','4','6','','',NULL,NULL,NULL,NULL,'');
 SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 1);
INSERT INTO labels (`font`,`type`,`color`,`outlinecolor`,`shadowcolor`,`shadowsizex`,`shadowsizey`,`backgroundcolor`,`backgroundshadowcolor`,`backgroundshadowsizex`,`backgroundshadowsizey`,`size`,`minsize`,`maxsize`,`position`,`offsetx`,`offsety`,`angle`,`autoangle`,`buffer`,`antialias`,`minfeaturesize`,`maxfeaturesize`,`partials`,`wrap`,`the_force`) VALUES('verdana',NULL,'0 59 31','255 255 255','',NULL,NULL,'','',NULL,NULL,'8','6','10',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1','126','1');
 SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Ackerland',@last_layer_id50303347,'(\'[kurz]\' = \'A\')','1','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','3','205 116 40','','-1 -1 -1',NULL,NULL,'','',NULL,NULL,NULL,NULL,'');
 SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'punkt','4','-1 -1 -1','','0 98 3','4','6','','',NULL,NULL,NULL,NULL,'');
 SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 1);
INSERT INTO labels (`font`,`type`,`color`,`outlinecolor`,`shadowcolor`,`shadowsizex`,`shadowsizey`,`backgroundcolor`,`backgroundshadowcolor`,`backgroundshadowsizex`,`backgroundshadowsizey`,`size`,`minsize`,`maxsize`,`position`,`offsetx`,`offsety`,`angle`,`autoangle`,`buffer`,`antialias`,`minfeaturesize`,`maxfeaturesize`,`partials`,`wrap`,`the_force`) VALUES('verdana',NULL,'89 39 0','255 255 255','',NULL,NULL,'','',NULL,NULL,'8','6','10',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1','126','1');
 SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Grünland',@last_layer_id50303347,'(\'[kurz]\' = \'Gr\')','3','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','3','143 249 44','','-1 -1 -1',NULL,NULL,'','',NULL,NULL,NULL,NULL,'');
 SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'punkt','4','-1 -1 -1','','0 98 3','4','6','','',NULL,NULL,NULL,NULL,'');
 SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 1);
INSERT INTO labels (`font`,`type`,`color`,`outlinecolor`,`shadowcolor`,`shadowsizex`,`shadowsizey`,`backgroundcolor`,`backgroundshadowcolor`,`backgroundshadowsizex`,`backgroundshadowsizey`,`size`,`minsize`,`maxsize`,`position`,`offsetx`,`offsety`,`angle`,`autoangle`,`buffer`,`antialias`,`minfeaturesize`,`maxfeaturesize`,`partials`,`wrap`,`the_force`) VALUES('verdana',NULL,'0 59 31','255 255 255','',NULL,NULL,'','',NULL,NULL,'8','6','10',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1','126','1');
 SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Acker-Grünland',@last_layer_id50303347,'(\'[kurz]\' = \'AGr\')','2','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','3','231 168 0','','-1 -1 -1',NULL,NULL,'','',NULL,NULL,NULL,NULL,'');
 SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'punkt','4','-1 -1 -1','','0 98 3','4','6','','',NULL,NULL,NULL,NULL,'');
 SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 1);
INSERT INTO labels (`font`,`type`,`color`,`outlinecolor`,`shadowcolor`,`shadowsizex`,`shadowsizey`,`backgroundcolor`,`backgroundshadowcolor`,`backgroundshadowsizex`,`backgroundshadowsizey`,`size`,`minsize`,`maxsize`,`position`,`offsetx`,`offsety`,`angle`,`autoangle`,`buffer`,`antialias`,`minfeaturesize`,`maxfeaturesize`,`partials`,`wrap`,`the_force`) VALUES('verdana',NULL,'89 39 0','255 255 255','',NULL,NULL,'','',NULL,NULL,'8','6','10',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1','126','1');
 SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);

UPDATE layer_attributes SET options = REPLACE(options, '50303347', @last_layer_id50303347) WHERE layer_id IN(@last_layer_id50303347) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');


 

Musterstück v

SET @group_id = 1;
SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';

INSERT INTO layer (`Name`,`Datentyp`,`Gruppe`,`pfad`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`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`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`,`metalink`,`privileg`) VALUES('ALKIS_Musterstücke','1',@group_id,'select ogc_fid,  gruppe||\' Nr. \'||nummer as bezeichnung, kultur, bezeichner, zustand_bodenstufe, entstehung, bodenzahlodergruenlandgrundzahl, ackerzahlodergruenlandzahl, the_geom from lk_muster_vergleichsstuecke where merkmal < 3000','the_geom FROM (SELECT oid, gruppe||\' Nr. \'||nummer as bezeichnung, merkmal, the_geom FROM alkis.lk_muster_vergleichsstuecke where merkmal < 3000) as foo using unique oid using srid=25833','alkis','','','','','bezeichnung','10001','49','',@connection,'','6','','','3','pixels','25833','','1',NULL,'100000','49','50001','','EPSG:25833','','1.1.0','image/png','60','','','','','1','0','','Musterstücke und Landesmusterstücke der Reichsbodenschätzung aus ALKIS','Fachdienst Kataster und Vermessung','','0');
SET @last_layer_id50303344=LAST_INSERT_ID();
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303344,'ackerzahlodergruenlandzahl','ackerzahlodergruenlandzahl','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','int4','','','1','32','Text','','Acker-/ Grünlandzahl','','7','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303344,'bezeichner','bezeichner','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','varchar','','','1',NULL,'Text','','Bodenart','','3','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303344,'bezeichnung','gruppe','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','not_saveable','','','1',NULL,'Text','','Bezeichnung','','1','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303344,'bodenzahlodergruenlandgrundzahl','bodenzahlodergruenlandgrundzahl','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','int4','','','1','32','Text','','Bodenzahl / Grünlandgrundzahl','','6','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303344,'entstehung','entstehung','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','varchar','','','1',NULL,'Text','','Entstehung','','5','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303344,'kultur','kultur','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','varchar','','','1',NULL,'Text','','Kulturart','','2','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303344,'ogc_fid','ogc_fid','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','int4','','','1','32','Text','','Datenbank-ID','','0','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303344,'the_geom','the_geom','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','geometry','POINT','','1',NULL,'Geometrie','','Geometrie','','8','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`,`privileg`) VALUES(@last_layer_id50303344,'zustand_bodenstufe','zustand_bodenstufe','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','varchar','','','1',NULL,'Text','','Zustand Bodenstufe','','4','0');
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Musterstück',@last_layer_id50303344,'([merkmal] = 1000)','1','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'punkt','4','171 4 0','','','3','4','360','',NULL,NULL,NULL,NULL,'');
 SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO labels (`font`,`type`,`color`,`outlinecolor`,`shadowcolor`,`shadowsizex`,`shadowsizey`,`backgroundcolor`,`backgroundshadowcolor`,`backgroundshadowsizex`,`backgroundshadowsizey`,`size`,`minsize`,`maxsize`,`position`,`offsetx`,`offsety`,`angle`,`autoangle`,`buffer`,`antialias`,`minfeaturesize`,`maxfeaturesize`,`partials`,`wrap`,`the_force`) VALUES('arial',NULL,'0 20 8','255 255 255','',NULL,NULL,'','',NULL,NULL,'8','6','10','6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
 SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Landesmusterstück',@last_layer_id50303344,'([merkmal] = 2000)','2','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'punkt','4','230 0 160','','','3','4','360','',NULL,NULL,NULL,NULL,'');
 SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);

UPDATE layer_attributes SET options = REPLACE(options, '50303344', @last_layer_id50303344) WHERE layer_id IN(@last_layer_id50303344) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');

 

Verwaltungseinheiten

VR

geographische Gebietseinheiten

VG

sonstige Angaben

VG

andere Themen mit ALKIS-Bezug

alle