GLE-Layer-Reichsbodenschätzung

Aus kvwmap
Wechseln zu: Navigation, Suche

Layer Klassifizierte Bodenwertzahlen der Schätzungsflächen

Je ein Layer für Acker- und Grünland, außerdem je ein Layer für Acker-Grünland-Wechselland sowie Grünland-Acker-Wechselland. 

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('Bodenwertzahlen (A)',,'2',@group_id,,'lkvr_schaetzungsflaechen','geometrie from (SELECT id as oid, ackerzahlodergruenlandzahl, kulturart_kurz, geometrie FROM alkis.lkvr_schaetzungsflaechen WHERE kulturart_kurz = \'A\') as foo using unique oid using srid=25833','alkis',,,,,,NULL,NULL,,@connection,,'6','ackerzahlodergruenlandzahl','ackerzahlodergruenlandzahl','3','pixels','25833',,'0','100','28808','49','1000001',,'EPSG:25833',,'1.1.0','image/png','60',,,,,'1','0',,'Farbige Darstellung der BWZ für Acker','Breede',,'0');
SET @last_layer_id50303599=LAST_INSERT_ID();
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('1-20',@last_layer_id50303599,'([ackerzahlodergruenlandzahl] >= 1 AND [ackerzahlodergruenlandzahl] < 21)','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,,,'255 250 179',,'255 250 179',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('21-30',@last_layer_id50303599,'([ackerzahlodergruenlandzahl] >= 21 AND [ackerzahlodergruenlandzahl] < 31)','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,,,'224 208 143',,'224 208 143',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('31-40',@last_layer_id50303599,'([ackerzahlodergruenlandzahl] >= 31 AND [ackerzahlodergruenlandzahl] < 41)','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,,,'193 166 107',,'193 166 107',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('41-50',@last_layer_id50303599,'([ackerzahlodergruenlandzahl] >= 41 AND [ackerzahlodergruenlandzahl] < 51)','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,,,'162 124 72',,'162 124 72',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('51-60',@last_layer_id50303599,'([ackerzahlodergruenlandzahl] >= 51 AND [ackerzahlodergruenlandzahl] < 61)','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,,,'131 82 36',,'131 82 36',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('61-75',@last_layer_id50303599,'([ackerzahlodergruenlandzahl] >= 61 AND [ackerzahlodergruenlandzahl] < 75)','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,,,'101 40 1',,'101 40 1',NULL,'1','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 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('Bodenwertzahlen (AGr)',,'2',@group_id,,'lkvr_schaetzungsflaechen','geometrie from (SELECT id as oid, ackerzahlodergruenlandzahl, kulturart_kurz, geometrie FROM alkis.lkvr_schaetzungsflaechen WHERE kulturart_kurz = \'AGr\') as foo using unique oid using srid=25833','alkis',,,,,,NULL,NULL,,@connection,,'6','ackerzahlodergruenlandzahl','ackerzahlodergruenlandzahl','3','pixels','25833',,'0','100','28806','49','1000001',,'EPSG:25833',,'1.1.0','image/png','60',,,,,'1','0',,'Farbige Darstellung der BWZ für Acker-/Grünland','Breede',,'0');
SET @last_layer_id50303601=LAST_INSERT_ID();
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('1-20',@last_layer_id50303601,'([ackerzahlodergruenlandzahl] >= 1 AND [ackerzahlodergruenlandzahl] < 21)','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,,,'204 255 252',,'204 255 252',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('21-30',@last_layer_id50303601,'([ackerzahlodergruenlandzahl] >= 21 AND [ackerzahlodergruenlandzahl] < 31)','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,,,'170 226 222',,'170 226 222',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('31-40',@last_layer_id50303601,'([ackerzahlodergruenlandzahl] >= 31 AND [ackerzahlodergruenlandzahl] < 41)','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,,,'137 197 193',,'137 197 193',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('41-50',@last_layer_id50303601,'([ackerzahlodergruenlandzahl] >= 41 AND [ackerzahlodergruenlandzahl] < 51)','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,,,'103 168 164',,'103 168 164',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('51-60',@last_layer_id50303601,'([ackerzahlodergruenlandzahl] >= 51 AND [ackerzahlodergruenlandzahl] < 61)','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,,,'70 139 135',,'70 139 135',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('61-70',@last_layer_id50303601,'([ackerzahlodergruenlandzahl] >= 61 AND [ackerzahlodergruenlandzahl] < 71)','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,,,'37 111 106',,'37 111 106',NULL,'1','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 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('Bodenwertzahlen (Gr)',,'2',@group_id,,'lkvr_schaetzungsflaechen','geometrie from (SELECT id as oid, ackerzahlodergruenlandzahl, kulturart_kurz, geometrie FROM alkis.lkvr_schaetzungsflaechen WHERE kulturart_kurz = \'Gr\') as foo using unique oid using srid=25833','alkis',,,,,,NULL,NULL,,@connection,,'6','ackerzahlodergruenlandzahl','ackerzahlodergruenlandzahl','3','pixels','25833',,'0','100','28807','49','1000001',,'EPSG:25833',,'1.1.0','image/png','60',,,,,'1','0',,'Farbige Darstellung der BWZ für Grünland','Breede',,'0');
SET @last_layer_id50303600=LAST_INSERT_ID();
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('1-20',@last_layer_id50303600,'([ackerzahlodergruenlandzahl] >= 1 AND [ackerzahlodergruenlandzahl] < 21)','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,,,'237 255 179',,'237 255 179',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('21-30',@last_layer_id50303600,'([ackerzahlodergruenlandzahl] >= 21 AND [ackerzahlodergruenlandzahl] < 31)','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,,,'193 225 143',,'193 225 143',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('31-40',@last_layer_id50303600,'([ackerzahlodergruenlandzahl] >= 31 AND [ackerzahlodergruenlandzahl] < 41)','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,,,'149 195 108',,'149 195 108',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('41-50',@last_layer_id50303600,'([ackerzahlodergruenlandzahl] >= 41 AND [ackerzahlodergruenlandzahl] < 51)','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,,,'105 165 72',,'105 165 72',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('51-60',@last_layer_id50303600,'([ackerzahlodergruenlandzahl] >= 51 AND [ackerzahlodergruenlandzahl] < 61)','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,,,'61 135 37',,'61 135 37',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('61-70',@last_layer_id50303600,'([ackerzahlodergruenlandzahl] >= 61 AND [ackerzahlodergruenlandzahl] < 71)','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,,,'18 105 2',,'18 105 2',NULL,'1','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 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('Bodenwertzahlen (GrA)',,'2',@group_id,,'lkvr_schaetzungsflaechen','geometrie from (SELECT id as oid, ackerzahlodergruenlandzahl, kulturart_kurz, geometrie FROM alkis.lkvr_schaetzungsflaechen WHERE kulturart_kurz = \'GrA\') as foo using unique oid using srid=25833','alkis',,,,,,NULL,NULL,,@connection,,'6','ackerzahlodergruenlandzahl','ackerzahlodergruenlandzahl','3','pixels','25833',,'0','100','28805','49','1000001',,'EPSG:25833',,'1.1.0','image/png','60',,,,,'1','0',,'Farbige Darstellung der BWZ für Grün-/Ackerland','Breede',,'0');
SET @last_layer_id50303602=LAST_INSERT_ID();
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('1-20',@last_layer_id50303602,'([ackerzahlodergruenlandzahl] >= 1 AND [ackerzahlodergruenlandzahl] < 21)','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,,,'255 204 241',,'255 204 241',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('21-30',@last_layer_id50303602,'([ackerzahlodergruenlandzahl] >= 21 AND [ackerzahlodergruenlandzahl] < 31)','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,,,'222 167 217',,'222 167 217',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('31-40',@last_layer_id50303602,'([ackerzahlodergruenlandzahl] >= 31 AND [ackerzahlodergruenlandzahl] < 41)','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,,,'189 130 193',,'189 130 193',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('41-50',@last_layer_id50303602,'([ackerzahlodergruenlandzahl] >= 41 AND [ackerzahlodergruenlandzahl] < 51)','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,,,'157 94 169',,'157 94 169',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('51-60',@last_layer_id50303602,'([ackerzahlodergruenlandzahl] >= 51 AND [ackerzahlodergruenlandzahl] < 61)','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,,,'124 57 145',,'124 57 145',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('61-70',@last_layer_id50303602,'([ackerzahlodergruenlandzahl] >= 61 AND [ackerzahlodergruenlandzahl] < 71)','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,,,'92 21 121',,'92 21 121',NULL,'1','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, '50303599', @last_layer_id50303599) WHERE layer_id IN(@last_layer_id50303599, @last_layer_id50303601, @last_layer_id50303600, @last_layer_id50303602) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK', 'Autovervollständigungsfeld', 'Auswahlfeld');
UPDATE layer_attributes SET options = REPLACE(options, '50303601', @last_layer_id50303601) WHERE layer_id IN(@last_layer_id50303599, @last_layer_id50303601, @last_layer_id50303600, @last_layer_id50303602) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK', 'Autovervollständigungsfeld', 'Auswahlfeld');
UPDATE layer_attributes SET options = REPLACE(options, '50303600', @last_layer_id50303600) WHERE layer_id IN(@last_layer_id50303599, @last_layer_id50303601, @last_layer_id50303600, @last_layer_id50303602) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK', 'Autovervollständigungsfeld', 'Auswahlfeld');
UPDATE layer_attributes SET options = REPLACE(options, '50303602', @last_layer_id50303602) WHERE layer_id IN(@last_layer_id50303599, @last_layer_id50303601, @last_layer_id50303600, @last_layer_id50303602) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK', 'Autovervollständigungsfeld', 'Auswahlfeld');

Layer Klassifizierte Bodenwertzahlen pro Flurstück

Je ein Layer für Acker- und Grünland, außerdem je ein Layer für Acker-Grünland-Wechselland sowie Grünland-Acker-Wechselland. 

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('Bodenwertzahlen je Flurstück (A)',,'2',@group_id,,'lkvr_schaetzungsflaechen_flurstueck','wkb_geometry from (SELECT s.fsgml_id as oid, s.a_bwz_gesamt, f.wkb_geometry FROM alkis.lkvr_schaetzungsflaechen_flurstueck s, alkis.ax_flurstueck f WHERE s.fsgml_id = f.gml_id) as foo using unique oid using srid=25833','alkis',,,,,,NULL,NULL,,@connection,,'6','a_bwz_gesamt','a_bwz_gesamt','3','pixels','25833',,'0','100','28804','49','1000001',,'EPSG:25833',,'1.1.0','image/png','60',,,,,'1','0',,'Farbige Darstellung der BWZ für Acker','Breede',,'0');
SET @last_layer_id50303590=LAST_INSERT_ID();
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('1-20',@last_layer_id50303590,'([a_bwz_gesamt] >= 1 AND [a_bwz_gesamt] < 21)','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,,,'255 250 179',,'255 250 179',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('21-30',@last_layer_id50303590,'([a_bwz_gesamt] >= 21 AND [a_bwz_gesamt] < 31)','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,,,'224 208 143',,'224 208 143',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('31-40',@last_layer_id50303590,'([a_bwz_gesamt] >= 31 AND [a_bwz_gesamt] < 41)','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,,,'193 166 107',,'193 166 107',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('41-50',@last_layer_id50303590,'([a_bwz_gesamt] >= 41 AND [a_bwz_gesamt] < 51)','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,,,'162 124 72',,'162 124 72',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('51-60',@last_layer_id50303590,'([a_bwz_gesamt] >= 51 AND [a_bwz_gesamt] < 61)','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,,,'131 82 36',,'131 82 36',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('61-70',@last_layer_id50303590,'([a_bwz_gesamt] >= 61 AND [a_bwz_gesamt] < 71)','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,,,'101 40 1',,'101 40 1',NULL,'1','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 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('Bodenwertzahlen je Flurstück (AGr)',,'2',@group_id,,'lkvr_schaetzungsflaechen_flurstueck','wkb_geometry from (SELECT s.fsgml_id as oid, s.agr_bwz_gesamt, f.wkb_geometry FROM alkis.lkvr_schaetzungsflaechen_flurstueck s, alkis.ax_flurstueck f WHERE s.fsgml_id = f.gml_id) as foo using unique oid using srid=25833','alkis',,,,,,NULL,NULL,,@connection,,'6','agr_bwz_gesamt','agr_bwz_gesamt','3','pixels','25833',,'0','100','28802','49','1000001',,'EPSG:25833',,'1.1.0','image/png','60',,,,,'1','0',,'Farbige Darstellung der BWZ für Acker-/Grünland','Breede',,'0');
SET @last_layer_id50303594=LAST_INSERT_ID();
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('1-20',@last_layer_id50303594,'([agr_bwz_gesamt] >= 1 AND [agr_bwz_gesamt] < 21)','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,,,'204 255 252',,'204 255 252',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('21-30',@last_layer_id50303594,'([agr_bwz_gesamt] >= 21 AND [agr_bwz_gesamt] < 31)','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,,,'170 226 222',,'170 226 222',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('31-40',@last_layer_id50303594,'([agr_bwz_gesamt] >= 31 AND [agr_bwz_gesamt] < 41)','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,,,'137 197 193',,'137 197 193',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('41-50',@last_layer_id50303594,'([agr_bwz_gesamt] >= 41 AND [agr_bwz_gesamt] < 51)','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,,,'103 168 164',,'103 168 164',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('51-60',@last_layer_id50303594,'([agr_bwz_gesamt] >= 51 AND [agr_bwz_gesamt] < 61)','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,,,'70 139 135',,'70 139 135',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('61-70',@last_layer_id50303594,'([agr_bwz_gesamt] >= 61 AND [agr_bwz_gesamt] < 71)','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,,,'37 111 106',,'37 111 106',NULL,'1','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 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('Bodenwertzahlen je Flurstück (Gr)',,'2',@group_id,,'lkvr_schaetzungsflaechen_flurstueck','wkb_geometry from (SELECT s.fsgml_id as oid, s.gr_bwz_gesamt, f.wkb_geometry FROM alkis.lkvr_schaetzungsflaechen_flurstueck s, alkis.ax_flurstueck f WHERE s.fsgml_id = f.gml_id) as foo using unique oid using srid=25833','alkis',,,,,,NULL,NULL,,@connection,,'6','gr_bwz_gesamt','gr_bwz_gesamt','3','pixels','25833',,'0','100','28803','49','1000001',,'EPSG:25833',,'1.1.0','image/png','60',,,,,'1','0',,'Farbige Darstellung der BWZ für Grünland','Breede',,'0');
SET @last_layer_id50303592=LAST_INSERT_ID();
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('1-20',@last_layer_id50303592,'([gr_bwz_gesamt] >= 1 AND [gr_bwz_gesamt] < 21)','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,,,'237 255 179',,'237 255 179',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('21-30',@last_layer_id50303592,'([gr_bwz_gesamt] >= 21 AND [gr_bwz_gesamt] < 31)','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,,,'193 225 143',,'193 225 143',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('31-40',@last_layer_id50303592,'([gr_bwz_gesamt] >= 31 AND [gr_bwz_gesamt] < 41)','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,,,'149 195 108',,'149 195 108',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('41-50',@last_layer_id50303592,'([gr_bwz_gesamt] >= 41 AND [gr_bwz_gesamt] < 51)','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,,,'105 165 72',,'105 165 72',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('51-60',@last_layer_id50303592,'([gr_bwz_gesamt] >= 51 AND [gr_bwz_gesamt] < 61)','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,,,'61 135 37',,'61 135 37',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('61-70',@last_layer_id50303592,'([gr_bwz_gesamt] >= 61 AND [gr_bwz_gesamt] < 71)','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,,,'18 105 2',,'18 105 2',NULL,'1','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 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('Bodenwertzahlen je Flurstück (GrA)',,'2',@group_id,,'lkvr_schaetzungsflaechen_flurstueck','wkb_geometry from (SELECT s.fsgml_id as oid, s.gra_bwz_gesamt, f.wkb_geometry FROM alkis.lkvr_schaetzungsflaechen_flurstueck s, alkis.ax_flurstueck f WHERE s.fsgml_id = f.gml_id) as foo using unique oid using srid=25833','alkis',,,,,,NULL,NULL,,@connection,,'6','gra_bwz_gesamt','gra_bwz_gesamt','3','pixels','25833',,'0','100','28801','49','1000001',,'EPSG:25833',,'1.1.0','image/png','60',,,,,'1','0',,'Farbige Darstellung der BWZ für Grün-/Ackerland','Breede',,'0');
SET @last_layer_id50303596=LAST_INSERT_ID();
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('1-20',@last_layer_id50303596,'([gra_bwz_gesamt] >= 1 AND [gra_bwz_gesamt] < 21)','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,,,'255 204 241',,'255 204 241',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('21-30',@last_layer_id50303596,'([gra_bwz_gesamt] >= 21 AND [gra_bwz_gesamt] < 31)','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,,,'222 167 217',,'222 167 217',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('31-40',@last_layer_id50303596,'([gra_bwz_gesamt] >= 31 AND [gra_bwz_gesamt] < 41)','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,,,'189 130 193',,'189 130 193',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('41-50',@last_layer_id50303596,'([gra_bwz_gesamt] >= 41 AND [gra_bwz_gesamt] < 51)','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,,,'157 94 169',,'157 94 169',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('51-60',@last_layer_id50303596,'([gra_bwz_gesamt] >= 51 AND [gra_bwz_gesamt] < 61)','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,,,'124 57 145',,'124 57 145',NULL,'1','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('61-70',@last_layer_id50303596,'([gra_bwz_gesamt] >= 61 AND [gra_bwz_gesamt] < 71)','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,,,'92 21 121',,'92 21 121',NULL,'1','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, '50303590', @last_layer_id50303590) WHERE layer_id IN(@last_layer_id50303590, @last_layer_id50303594, @last_layer_id50303592, @last_layer_id50303596) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK', 'Autovervollständigungsfeld', 'Auswahlfeld');
UPDATE layer_attributes SET options = REPLACE(options, '50303594', @last_layer_id50303594) WHERE layer_id IN(@last_layer_id50303590, @last_layer_id50303594, @last_layer_id50303592, @last_layer_id50303596) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK', 'Autovervollständigungsfeld', 'Auswahlfeld');
UPDATE layer_attributes SET options = REPLACE(options, '50303592', @last_layer_id50303592) WHERE layer_id IN(@last_layer_id50303590, @last_layer_id50303594, @last_layer_id50303592, @last_layer_id50303596) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK', 'Autovervollständigungsfeld', 'Auswahlfeld');
UPDATE layer_attributes SET options = REPLACE(options, '50303596', @last_layer_id50303596) WHERE layer_id IN(@last_layer_id50303590, @last_layer_id50303594, @last_layer_id50303592, @last_layer_id50303596) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK', 'Autovervollständigungsfeld', 'Auswahlfeld');
Von „https://kvwmap.de/wiki/index.php?title=GLE-Layer-Reichsbodenschätzung&oldid=9260“