GLE-Layer-Jagdkataster: Unterschied zwischen den Versionen

Aus kvwmap
Wechseln zu: Navigation, Suche
(→‎Gruppen für die Layer des Jagdkatasters)
 
(12 dazwischenliegende Versionen des gleichen Benutzers werden nicht angezeigt)
Zeile 1: Zeile 1:
  
−
== EJB Verdachtsflächen ==
+
 
 +
== Gruppen für die Layer des Jagdkatasters ==
 +
<nowiki>
 +
SET @order_abrundung = x;
 +
INSERT INTO u_groups(`Gruppenname`, `Gruppenname_low-german`, `Gruppenname_english`, `Gruppenname_polish`, `Gruppenname_vietnamese`, `obergruppe`, `order`) VALUES ('Abrundungsverfahren','Ofrunnungsverfohren','Rounding Treatment',NULL,NULL,NULL,@order_abrundung);
 +
SET @group_id_abrundung=LAST_INSERT_ID();
 +
 
 +
SET @order_jagdkataster = y;
 +
INSERT INTO u_groups(`Gruppenname`, `Gruppenname_low-german`, `Gruppenname_english`, `Gruppenname_polish`, `Gruppenname_vietnamese`, `obergruppe`, `order`) VALUES ('Jagdkataster','Jachtkataster','Hunting Register',NULL,NULL,NULL,@order_jagdkataster);
 +
SET @group_id_jagdkataster=LAST_INSERT_ID(); 
 +
</nowiki>
 +
 
 +
== GLE-Basislayer Jagdbezirke ==
 +
 
 +
Für Suchabfragen über die Fachschale und für die Darstellung von Suchergebnissen wird das Thema "Jagdbezirke" verwendet, das ansonsten unsichtbar für den Benutzer bleibt.
 +
 
 +
Der Datenherr hat Editierrechte auf alle Attribute außer oid. Alle Stellen außer dem Datenherrn haben nur Leserechte.
 +
<nowiki>
 +
SET @group_id = @group_id_jagdkataster;
 +
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('Jagdbezirke','','2',@group_id,'SELECT oid, * FROM jagdbezirke WHERE 1=1','jagdbezirke','the_geom from jagdkataster.jagdbezirke as foo using unique oid using srid=25833','jagdkataster','','','','','',NULL,NULL,'',@connection,'','6','id','id','1','pixels','25833','jagdkataster/view/jagdbezirke.php','1','50','101100','100','500000','','EPSG:25833','','1.1.0','image/png','60','','','','','1','1','','','untere Jagdbehörde','','0');
 +
SET @last_layer_id10007215=LAST_INSERT_ID();
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'art','art','jagdbezirke','jagdbezirke','varchar','','','1','15',NULL,'','Text','','','','','','','','',NULL,NULL,'2','0','0');
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'concode','concode','jagdbezirke','jagdbezirke','varchar','','','1','5',NULL,'','Text','','','','','','','','',NULL,NULL,'5','0','0');
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'conname','conname','jagdbezirke','jagdbezirke','varchar','','','1','40',NULL,'','Text','','','','','','','','',NULL,NULL,'6','0','0');
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'flaeche','flaeche','jagdbezirke','jagdbezirke','numeric','','','1',NULL,NULL,'','Zahl','','','','','','','','',NULL,NULL,'3','0','0');
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'id','id','jagdbezirke','jagdbezirke','varchar','','','1','10',NULL,'','Text','','','','','','','','',NULL,NULL,'1','0','0');
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'jb_zuordnung','jb_zuordnung','jagdbezirke','jagdbezirke','varchar','','','1','10',NULL,'','Text','','','','','','','','',NULL,NULL,'7','0','0');
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'name','name','jagdbezirke','jagdbezirke','varchar','','','1','50',NULL,'','Text','','','','','','','','',NULL,NULL,'4','0','0');
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'oid','oid','','','oid','','',NULL,NULL,NULL,'','Text','','','','','','','','',NULL,NULL,'0','0','0');
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'status','status','jagdbezirke','jagdbezirke','bool','','','1',NULL,NULL,'','Text','','','','','','','','',NULL,NULL,'8','0','0');
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'the_geom','the_geom','jagdbezirke','jagdbezirke','geometry','MULTIPOLYGON','','1',NULL,NULL,'','Geometrie','','','','','','','','',NULL,NULL,'10','0','0');
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'verzicht','verzicht','jagdbezirke','jagdbezirke','bool','','','0',NULL,NULL,'SELECT false','Text','','','','','','','','',NULL,NULL,'9','0','0');
 +
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('EJB vor Abrundung',@last_layer_id10007215,'(\'[art]\' eq \'ejb\' and \'[verzicht]\' eq \'f\')','10','');
 +
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','240 240 120','','-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,'','','-1 -1 -1','','0 235 0',NULL,NULL,'','',NULL,'4','2','7','');
 +
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('EJB mit Verzicht',@last_layer_id10007215,'(\'[art]\' eq \'ejb\' and \'[verzicht]\' eq \'t\')','20','');
 +
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,'cross','15','240 240 120','','-1 -1 -1','15','15','0','',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,'','','-1 -1 -1','','0 235 0',NULL,NULL,'','',NULL,'4','2','7','');
 +
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Angliederung',@last_layer_id10007215,'(\'[art]\' eq \'agf\')','30','');
 +
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,'cross','9','0 0 0','255 120 12','-1 -1 -1','30','30','','',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,'','','-1 -1 -1','','130 0 0',NULL,NULL,'','',NULL,'3','2','5','');
 +
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('jagdbezirksfrei',@last_layer_id10007215,'(\'[art]\' eq \'jbf\')','40','');
 +
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,'cross','9','0 0 0','22 94 255','-1 -1 -1','30','30','','',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,'','','-1 -1 -1','','130 0 0',NULL,NULL,'','',NULL,'3','2','5','');
 +
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Enklave',@last_layer_id10007215,'(\'[art]\' eq \'jbe\')','50','');
 +
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,'cross','9','0 0 0','255 0 0','-1 -1 -1','30','30','','',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,'','','-1 -1 -1','','130 0 0',NULL,NULL,'','',NULL,'3','2','5','');
 +
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Abtrennung',@last_layer_id10007215,'(\'[art]\' eq \'atf\')','60','');
 +
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,'cross','9','0 0 0','80 190 80','-1 -1 -1','30','30','','',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,'','','-1 -1 -1','','130 0 0',NULL,NULL,'','',NULL,'3','2','5','');
 +
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Anpachtfläche',@last_layer_id10007215,'(\'[art]\' eq \'apf\')','70','');
 +
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,'cross','9','0 0 0','255 215 0','-1 -1 -1','30','30','0','',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,'','','-1 -1 -1','','130 0 0',NULL,NULL,'','',NULL,'3','2','5','');
 +
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Abtrennung nach §3',@last_layer_id10007215,'(\'[art]\' eq \'atv\')','80','');
 +
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,'cross','15','0 65 0','','-1 -1 -1','15','15','180','',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,'','','-1 -1 -1','','0 65 0',NULL,NULL,'','',NULL,'4','2','5','');
 +
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('EJB abgerundet',@last_layer_id10007215,'(\'[art]\' eq \'ajb\' and \'[verzicht]\' eq \'f\')','90','');
 +
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','164 173 135','','-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,'','','-1 -1 -1','','0 65 0',NULL,NULL,'','',NULL,'4','2','5','');
 +
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('EJB abger. mit Verzicht',@last_layer_id10007215,'(\'[art]\' eq \'ajb\' and \'[verzicht]\' eq \'t\')','100','');
 +
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,'cross','15','221 255 113','','-1 -1 -1','15','15','175','',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,'','','-1 -1 -1','','0 65 0',NULL,NULL,'','',NULL,'4','2','5','');
 +
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Exklave',@last_layer_id10007215,'(\'[art]\' eq \'jex\')','110','');
 +
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,'cross','9','0 0 0','119 139 203','-1 -1 -1','30','30','','',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,'','','-1 -1 -1','','130 0 0',NULL,NULL,'','',NULL,'3','2','5','');
 +
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Teiljagdbezirk',@last_layer_id10007215,'(\'[art]\' eq \'tjb\')','120','');
 +
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,'cross','15','90 90 90','','90 90 90','15','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Gemein. Jagdbezirk',@last_layer_id10007215,'(\'[art]\' eq \'gjb\')','130','');
 +
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','250 205 150','','-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,'','','-1 -1 -1','','0 65 0',NULL,NULL,'','',NULL,'4','2','5','');
 +
  SET @last_style_id=LAST_INSERT_ID();
 +
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 1);
 +
 +
UPDATE layer_attributes SET options = REPLACE(options, '10007215', @last_layer_id10007215) WHERE layer_id IN(@last_layer_id10007215) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK', 'Autovervollständigungsfeld', 'Auswahlfeld');
 +
</nowiki>
 +
 
 +
== Themen in der Abrundung eines Eigenjagdbezirks ==
 +
Diese Themen werden in der Regel nur den Mitarbeitern der unteren Jagdbehörde zur Verfügung gestellt, die mit der Abrundung befasst sind.
 +
 
 +
=== EJB Verdachtsflächen ===
 +
 
 +
Dieses Thema hat nur Leserechte.
 
  <nowiki>
 
  <nowiki>
−
  SET @group_id = 1;
+
  SET @group_id = @group_id_abrundung;
 
  SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';
 
  SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';
 
   
 
   
Zeile 24: Zeile 168:
  
  
−
== Abgerundete EJB ==
+
== Amtliches Jagdkataster ==
 +
Diese Themen werden in der Regel allen Stellen zur Verfügung stehen, die amtliche Informationen der unteren Jagdbehörde benötigen.
 +
 
 +
=== Abgerundete Eigenjagdbezirke ===  
 +
 
 +
Der Datenherr hat Editierrechte auf die Attribute
 +
* name
 +
* concode
 +
* verzicht
 +
* datum_beschluss
 +
* datum_bestandskraft
 +
* the_geom
 +
Alle Stellen außer dem Datenherrn haben keine Rechte auf die Attribute
 +
* concode
 +
* datum_erfassung
 
  <nowiki>
 
  <nowiki>
−
  SET @group_id = 1;
+
  SET @group_id = @group_id_jagdkataster;
 
  SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';
 
  SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';
 
   
 
   
Zeile 74: Zeile 232:
 
   SET @last_label_id=LAST_INSERT_ID();
 
   SET @last_label_id=LAST_INSERT_ID();
 
  INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);
 
  INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);
 +
</nowiki>
 +
 +
=== Befriedete Bezirke ===
 +
 +
Der Datenherr hat Editierrechte auf die Attribute
 +
* name
 +
* zu_gjb
 +
* the_geom
 +
Alle anderen Stellen haben nur Leserechte.
 +
<nowiki>
 +
SET @group_id = @group_id_jagdkataster;
 +
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('Befriedete Bezirke','','2',@group_id,'SELECT name, zu_gjb, the_geom FROM befriedete_bezirke WHERE 1=1','befriedete_bezirke','the_geom from jagdkataster.befriedete_bezirke as foo using unique oid using srid=25833','jagdkataster','','','','','name','20001','99','',@connection,'','6','id','id','3','pixels','25833','','1','80',NULL,'99','50001','','EPSG:25833','','1.1.0','image/png','60','','','','','1','1','','','','','0');
 +
SET @last_layer_id50303065=LAST_INSERT_ID();
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303065,'name','name','befriedete_bezirke','befriedete_bezirke','varchar','','','1','50',NULL,'','Text','','Name','','','','','','',NULL,NULL,'0','0','1');
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303065,'the_geom','the_geom','befriedete_bezirke','befriedete_bezirke','geometry','MULTIPOLYGON','','1',NULL,NULL,'','Geometrie','','','','','','','','',NULL,NULL,'2','0','0');
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303065,'zu_gjb','zu_gjb','befriedete_bezirke','befriedete_bezirke','varchar','','','1','50',NULL,'','Text','','zu gemeinschaftl. Jagdbezirk','','','','','Zuständigkeit','',NULL,NULL,'1','0','0');
 +
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES(' ',@last_layer_id50303065,'','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,'','1','214 238 244','','-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,'','','-1 -1 -1','','124 144 152',NULL,NULL,'360','',NULL,'3','1','5','');
 +
  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('ubuntu-medium',NULL,'81 97 104','255 255 255','',NULL,NULL,'','',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, '50303065', @last_layer_id50303065) WHERE layer_id IN(@last_layer_id50303065) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK', 'Autovervollständigungsfeld', 'Auswahlfeld');
 +
</nowiki>
 +
 +
 +
=== Befriedete Bezirke Flurstücke/Nutzungen ===
 +
 +
Dieses Thema hat nur Leserechte.
 +
<nowiki>
 +
SET @group_id = @group_id_jagdkataster;
 +
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('Befriedete Bezirke - Nutzungen','','5',@group_id,'select * from befriedete_bezirke_flurstuecke WHERE 1=1','befriedete_bezirke_flurstuecke','','jagdkataster','','','','','',NULL,NULL,'',@connection,'','6','id','id','3','pixels','25833','','1',NULL,NULL,'-1','-1','','EPSG:25833','','1.1.0','image/png','60','','','','','0','1','','','untere Jagdbehörde','','0');
 +
SET @last_layer_id50303068=LAST_INSERT_ID();
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303068,'amtlicheflaeche','amtlicheflaeche','befriedete_bezirke_flurstuecke','befriedete_bezirke_flurstuecke','float8','','','1','53',NULL,'','Text','','Amtliche Fläche [m²]','','','','','','Flurstück',NULL,NULL,'2','0','0');
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303068,'flurstueckskennzeichen','flurstueckskennzeichen','befriedete_bezirke_flurstuecke','befriedete_bezirke_flurstuecke','bpchar','','','1','20',NULL,'','Text','','Flurstückskennzeichen','','','','','','Flurstück',NULL,NULL,'1','0','0');
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303068,'fst_teilflaeche_abs','fst_teilflaeche_abs','befriedete_bezirke_flurstuecke','befriedete_bezirke_flurstuecke','numeric','','','1',NULL,NULL,'','Text','','Fläche im Bezirk [m²]','','','','','','Flurstück',NULL,NULL,'3','0','0');
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303068,'fst_teilflaeche_proz','fst_teilflaeche_proz','befriedete_bezirke_flurstuecke','befriedete_bezirke_flurstuecke','numeric','','','1',NULL,NULL,'','Text','','Fläche im Bezirk [%]','','','','','','Flurstück',NULL,NULL,'4','0','0');
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303068,'id','id','befriedete_bezirke_flurstuecke','befriedete_bezirke_flurstuecke','int4','','','1','32','0','','Text','','ID Bezirk','','','','','','Flurstück',NULL,NULL,'0','0','0');
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303068,'naschluessel','naschluessel','befriedete_bezirke_flurstuecke','befriedete_bezirke_flurstuecke','text','','','1',NULL,NULL,'','Text','','Nutzungsartenschlüssel','','','','','','Nutzung',NULL,NULL,'5','0','0');
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303068,'na_teilflaeche_abs','na_teilflaeche_abs','befriedete_bezirke_flurstuecke','befriedete_bezirke_flurstuecke','numeric','','','1',NULL,NULL,'','Text','','NA Fläche im Bezirk [m²]','','','','','','Nutzung',NULL,NULL,'7','0','0');
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303068,'na_teilflaeche_proz','na_teilflaeche_proz','befriedete_bezirke_flurstuecke','befriedete_bezirke_flurstuecke','numeric','','','1',NULL,NULL,'','Text','','NA Fläche im Bezirk [%]','','','','','','Nutzung',NULL,NULL,'8','0','0');
 +
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303068,'nutzung','nutzung','befriedete_bezirke_flurstuecke','befriedete_bezirke_flurstuecke','varchar','','','1',NULL,NULL,'','Text','','Nutzungsbezeichnung','','','','','','Nutzung',NULL,NULL,'6','0','0');
 +
 +
UPDATE layer_attributes SET options = REPLACE(options, '50303068', @last_layer_id50303068) WHERE layer_id IN(@last_layer_id50303068) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK', 'Autovervollständigungsfeld', 'Auswahlfeld');
 +
 
  </nowiki>
 
  </nowiki>

Aktuelle Version vom 19. April 2016, 14:13 Uhr


Gruppen für die Layer des Jagdkatasters

 SET @order_abrundung = x;
 INSERT INTO u_groups(`Gruppenname`, `Gruppenname_low-german`, `Gruppenname_english`, `Gruppenname_polish`, `Gruppenname_vietnamese`, `obergruppe`, `order`) VALUES ('Abrundungsverfahren','Ofrunnungsverfohren','Rounding Treatment',NULL,NULL,NULL,@order_abrundung);
 SET @group_id_abrundung=LAST_INSERT_ID();

 SET @order_jagdkataster = y;
 INSERT INTO u_groups(`Gruppenname`, `Gruppenname_low-german`, `Gruppenname_english`, `Gruppenname_polish`, `Gruppenname_vietnamese`, `obergruppe`, `order`) VALUES ('Jagdkataster','Jachtkataster','Hunting Register',NULL,NULL,NULL,@order_jagdkataster);
 SET @group_id_jagdkataster=LAST_INSERT_ID();

GLE-Basislayer Jagdbezirke

Für Suchabfragen über die Fachschale und für die Darstellung von Suchergebnissen wird das Thema "Jagdbezirke" verwendet, das ansonsten unsichtbar für den Benutzer bleibt.

Der Datenherr hat Editierrechte auf alle Attribute außer oid. Alle Stellen außer dem Datenherrn haben nur Leserechte. 

 SET @group_id = @group_id_jagdkataster;
 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('Jagdbezirke','','2',@group_id,'SELECT oid, * FROM jagdbezirke WHERE 1=1','jagdbezirke','the_geom from jagdkataster.jagdbezirke as foo using unique oid using srid=25833','jagdkataster','','','','','',NULL,NULL,'',@connection,'','6','id','id','1','pixels','25833','jagdkataster/view/jagdbezirke.php','1','50','101100','100','500000','','EPSG:25833','','1.1.0','image/png','60','','','','','1','1','','','untere Jagdbehörde','','0');
 SET @last_layer_id10007215=LAST_INSERT_ID();
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'art','art','jagdbezirke','jagdbezirke','varchar','','','1','15',NULL,'','Text','','','','','','','','',NULL,NULL,'2','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'concode','concode','jagdbezirke','jagdbezirke','varchar','','','1','5',NULL,'','Text','','','','','','','','',NULL,NULL,'5','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'conname','conname','jagdbezirke','jagdbezirke','varchar','','','1','40',NULL,'','Text','','','','','','','','',NULL,NULL,'6','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'flaeche','flaeche','jagdbezirke','jagdbezirke','numeric','','','1',NULL,NULL,'','Zahl','','','','','','','','',NULL,NULL,'3','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'id','id','jagdbezirke','jagdbezirke','varchar','','','1','10',NULL,'','Text','','','','','','','','',NULL,NULL,'1','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'jb_zuordnung','jb_zuordnung','jagdbezirke','jagdbezirke','varchar','','','1','10',NULL,'','Text','','','','','','','','',NULL,NULL,'7','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'name','name','jagdbezirke','jagdbezirke','varchar','','','1','50',NULL,'','Text','','','','','','','','',NULL,NULL,'4','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'oid','oid','','','oid','','',NULL,NULL,NULL,'','Text','','','','','','','','',NULL,NULL,'0','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'status','status','jagdbezirke','jagdbezirke','bool','','','1',NULL,NULL,'','Text','','','','','','','','',NULL,NULL,'8','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'the_geom','the_geom','jagdbezirke','jagdbezirke','geometry','MULTIPOLYGON','','1',NULL,NULL,'','Geometrie','','','','','','','','',NULL,NULL,'10','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id10007215,'verzicht','verzicht','jagdbezirke','jagdbezirke','bool','','','0',NULL,NULL,'SELECT false','Text','','','','','','','','',NULL,NULL,'9','0','0');
 INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('EJB vor Abrundung',@last_layer_id10007215,'(\'[art]\' eq \'ejb\' and \'[verzicht]\' eq \'f\')','10','');
 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','240 240 120','','-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,'','','-1 -1 -1','','0 235 0',NULL,NULL,'','',NULL,'4','2','7','');
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('EJB mit Verzicht',@last_layer_id10007215,'(\'[art]\' eq \'ejb\' and \'[verzicht]\' eq \'t\')','20','');
 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,'cross','15','240 240 120','','-1 -1 -1','15','15','0','',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,'','','-1 -1 -1','','0 235 0',NULL,NULL,'','',NULL,'4','2','7','');
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Angliederung',@last_layer_id10007215,'(\'[art]\' eq \'agf\')','30','');
 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,'cross','9','0 0 0','255 120 12','-1 -1 -1','30','30','','',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,'','','-1 -1 -1','','130 0 0',NULL,NULL,'','',NULL,'3','2','5','');
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('jagdbezirksfrei',@last_layer_id10007215,'(\'[art]\' eq \'jbf\')','40','');
 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,'cross','9','0 0 0','22 94 255','-1 -1 -1','30','30','','',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,'','','-1 -1 -1','','130 0 0',NULL,NULL,'','',NULL,'3','2','5','');
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Enklave',@last_layer_id10007215,'(\'[art]\' eq \'jbe\')','50','');
 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,'cross','9','0 0 0','255 0 0','-1 -1 -1','30','30','','',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,'','','-1 -1 -1','','130 0 0',NULL,NULL,'','',NULL,'3','2','5','');
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Abtrennung',@last_layer_id10007215,'(\'[art]\' eq \'atf\')','60','');
 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,'cross','9','0 0 0','80 190 80','-1 -1 -1','30','30','','',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,'','','-1 -1 -1','','130 0 0',NULL,NULL,'','',NULL,'3','2','5','');
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Anpachtfläche',@last_layer_id10007215,'(\'[art]\' eq \'apf\')','70','');
 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,'cross','9','0 0 0','255 215 0','-1 -1 -1','30','30','0','',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,'','','-1 -1 -1','','130 0 0',NULL,NULL,'','',NULL,'3','2','5','');
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Abtrennung nach §3',@last_layer_id10007215,'(\'[art]\' eq \'atv\')','80','');
 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,'cross','15','0 65 0','','-1 -1 -1','15','15','180','',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,'','','-1 -1 -1','','0 65 0',NULL,NULL,'','',NULL,'4','2','5','');
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('EJB abgerundet',@last_layer_id10007215,'(\'[art]\' eq \'ajb\' and \'[verzicht]\' eq \'f\')','90','');
 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','164 173 135','','-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,'','','-1 -1 -1','','0 65 0',NULL,NULL,'','',NULL,'4','2','5','');
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('EJB abger. mit Verzicht',@last_layer_id10007215,'(\'[art]\' eq \'ajb\' and \'[verzicht]\' eq \'t\')','100','');
 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,'cross','15','221 255 113','','-1 -1 -1','15','15','175','',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,'','','-1 -1 -1','','0 65 0',NULL,NULL,'','',NULL,'4','2','5','');
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Exklave',@last_layer_id10007215,'(\'[art]\' eq \'jex\')','110','');
 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,'cross','9','0 0 0','119 139 203','-1 -1 -1','30','30','','',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,'','','-1 -1 -1','','130 0 0',NULL,NULL,'','',NULL,'3','2','5','');
  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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Teiljagdbezirk',@last_layer_id10007215,'(\'[art]\' eq \'tjb\')','120','');
 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,'cross','15','90 90 90','','90 90 90','15','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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Gemein. Jagdbezirk',@last_layer_id10007215,'(\'[art]\' eq \'gjb\')','130','');
 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','250 205 150','','-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,'','','-1 -1 -1','','0 65 0',NULL,NULL,'','',NULL,'4','2','5','');
  SET @last_style_id=LAST_INSERT_ID();
 INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 1);
 
 UPDATE layer_attributes SET options = REPLACE(options, '10007215', @last_layer_id10007215) WHERE layer_id IN(@last_layer_id10007215) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK', 'Autovervollständigungsfeld', 'Auswahlfeld');

Themen in der Abrundung eines Eigenjagdbezirks

Diese Themen werden in der Regel nur den Mitarbeitern der unteren Jagdbehörde zur Verfügung gestellt, die mit der Abrundung befasst sind.

EJB Verdachtsflächen

Dieses Thema hat nur Leserechte. 

 SET @group_id = @group_id_abrundung;
 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('EJB Verdachtsflächen','','2',@group_id,'SELECT eigentuemer, flaeche, the_geom FROM lk_ejb_verdachtsflaechen WHERE 1=1','lk_ejb_verdachtsflaechen','the_geom from alkis.lk_ejb_verdachtsflaechen using unique oid using srid=25833','alkis','','','','','','100001','399','',@connection,'','6','oid','oid','3','pixels','25833','','1','70','30091','99','600001','','EPSG:25833','','1.1.0','image/png','60','','','','','1','1','','','untere Jagdbehörde','','0');
 SET @last_layer_id50303096=LAST_INSERT_ID();
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303096,'eigentuemer','eigentuemer','lk_ejb_verdachtsflaechen','lk_ejb_verdachtsflaechen','text','','','1',NULL,NULL,'','Textfeld','','Eigentümer','','','','','','',NULL,NULL,'1','0','1');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303096,'flaeche','flaeche','lk_ejb_verdachtsflaechen','lk_ejb_verdachtsflaechen','float8','','','1','53',NULL,'','Zahl','','Fläche (ca.) [m²]','','','','','','',NULL,NULL,'2','0','1');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303096,'the_geom','the_geom','lk_ejb_verdachtsflaechen','lk_ejb_verdachtsflaechen','geometry','POLYGON','','1',NULL,NULL,'','Geometrie','','','','','','','','',NULL,NULL,'3','0','0');
 INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('',@last_layer_id50303096,'','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,'','5','196 215 241','','-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,'','','-1 -1 -1','','255 73 46',NULL,NULL,'','',NULL,'4','1','6','');
  SET @last_style_id=LAST_INSERT_ID();
 INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 1);
 
 UPDATE layer_attributes SET options = REPLACE(options, '50303058', @last_layer_id50303058) WHERE layer_id IN(@last_layer_id50303058, @last_layer_id50303096) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK', 'Autovervollständigungsfeld', 'Auswahlfeld');
 UPDATE layer_attributes SET options = REPLACE(options, '50303096', @last_layer_id50303096) WHERE layer_id IN(@last_layer_id50303058, @last_layer_id50303096) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK', 'Autovervollständigungsfeld', 'Auswahlfeld');


Amtliches Jagdkataster

Diese Themen werden in der Regel allen Stellen zur Verfügung stehen, die amtliche Informationen der unteren Jagdbehörde benötigen.

Abgerundete Eigenjagdbezirke

Der Datenherr hat Editierrechte auf die Attribute

  • name
  • concode
  • verzicht
  • datum_beschluss
  • datum_bestandskraft
  • the_geom

Alle Stellen außer dem Datenherrn haben keine Rechte auf die Attribute

  • concode
  • datum_erfassung 
 SET @group_id = @group_id_jagdkataster;
 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('EJB abgerundet','','2',@group_id,'SELECT id, name, case when datum_bestandskraft > now() then 'vor Bestandskraft' else 'Bestandskraft' end as status_abrundung, flaeche, concode, verzicht, datum_beschluss, datum_bestandskraft, datum_erfassung, the_geom FROM jagdbezirke_abgerundet WHERE 1=1','jagdbezirke_abgerundet','the_geom from jagdkataster.jagdbezirke_abgerundet as foo using unique oid using srid=25833','jagdkataster','','','','','name','100001','399','',@connection,'','6','','','3','pixels','25833','','1','40','30092','100','500000','','EPSG:25833','','1.1.0','image/png','60','','','','','1','1','','','','','0');
 SET @last_layer_id50303058=LAST_INSERT_ID();
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303058,'concode','concode','jagdbezirke_abgerundet','jagdbezirke_abgerundet','varchar','','','1','5',NULL,'','Text','','Condition','','','','','','',NULL,NULL,'4',NULL,'0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303058,'datum_beschluss','datum_beschluss','jagdbezirke_abgerundet','jagdbezirke_abgerundet','date','','','1',NULL,NULL,'','Text','','Datum Beschluss','','','','','','',NULL,NULL,'6','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303058,'datum_bestandskraft','datum_bestandskraft','jagdbezirke_abgerundet','jagdbezirke_abgerundet','date','','','1',NULL,NULL,'','Text','','Datum Bestandskraft','','','','','','',NULL,NULL,'7','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303058,'datum_erfassung','datum_erfassung','jagdbezirke_abgerundet','jagdbezirke_abgerundet','date','','','1',NULL,NULL,'','Text','','Datum der Erfassung','','','','','','',NULL,NULL,'8',NULL,'0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303058,'flaeche','flaeche','jagdbezirke_abgerundet','jagdbezirke_abgerundet','numeric','','','1',NULL,NULL,'','Fläche','','Fläche [ha]','','','','','','',NULL,NULL,'3','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303058,'id','id','jagdbezirke_abgerundet','jagdbezirke_abgerundet','varchar','','','0','10',NULL,'','Text','','lfd. Nr.','','','','','lfd. Nr. der unteren Jagdbehörde','',NULL,NULL,'0','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303058,'name','name','jagdbezirke_abgerundet','jagdbezirke_abgerundet','varchar','','','1','50',NULL,'','Text','','Name','','','','','','',NULL,NULL,'1','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303058,'status_abrundung','status_abrundung','jagdbezirke_abgerundet','jagdbezirke_abgerundet','varchar','','','1','20',NULL,'','Text','','Status der Abrundung','','','','','Der EJB ist noch nicht bestandskräftig, wenn Bescheide erlassen wurden, Widerspruchsfristen aber noch laufen oder Verfahren noch anhängig sind.','',NULL,NULL,'2','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303058,'the_geom','the_geom','jagdbezirke_abgerundet','jagdbezirke_abgerundet','geometry','MULTIPOLYGON','','1',NULL,NULL,'','Geometrie','','','','','','','','',NULL,NULL,'9','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303058,'verzicht','verzicht','jagdbezirke_abgerundet','jagdbezirke_abgerundet','bool','','','1',NULL,NULL,'','Checkbox','','Verzicht','','','','','Verzicht gemäß §3 LJagdG','',NULL,NULL,'5','0','0');
 INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('vor Bestandskraft',@last_layer_id50303058,'(\'[verzicht]\' eq \'f\' AND \'[status_abrundung]\' eq \'vor Bestandskraft\')','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,'','1','164 173 135','','-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,'','','-1 -1 -1','','0 65 0',NULL,NULL,'','',NULL,'4','2','5','');
  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('ubuntu-medium',NULL,'114 138 35','242 246 228','',NULL,NULL,'242 246 228','',NULL,NULL,'9','8','12','1',NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1',NULL,'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('Bestandskraft',@last_layer_id50303058,'(\'[verzicht]\' eq \'f\' AND \'[status_abrundung]\' eq \'Bestandskraft\')','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,'','','221 255 113','','-1 -1 -1',NULL,NULL,'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 styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','','-1 -1 -1','','0 65 0',NULL,NULL,'','',NULL,'4','2','5','');
  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('ubuntu-medium',NULL,'114 138 35','242 246 228','',NULL,NULL,'242 246 228','',NULL,NULL,'9','8','12','1',NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1',NULL,'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('Verzicht gem. §3 LJagdG',@last_layer_id50303058,'(\'[verzicht]\' eq \'t\')','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,'cross','15','0 65 0','','-1 -1 -1','15','15','180','',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,'','','-1 -1 -1','','0 65 0',NULL,NULL,'','',NULL,'4','2','5','');
  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('ubuntu',NULL,'114 138 35','242 246 228','',NULL,NULL,'','',NULL,NULL,'6','5','9','1',NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'0',NULL,'1');
  SET @last_label_id=LAST_INSERT_ID();
 INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);

Befriedete Bezirke

Der Datenherr hat Editierrechte auf die Attribute

  • name
  • zu_gjb
  • the_geom

Alle anderen Stellen haben nur Leserechte. 

 SET @group_id = @group_id_jagdkataster;
 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('Befriedete Bezirke','','2',@group_id,'SELECT name, zu_gjb, the_geom FROM befriedete_bezirke WHERE 1=1','befriedete_bezirke','the_geom from jagdkataster.befriedete_bezirke as foo using unique oid using srid=25833','jagdkataster','','','','','name','20001','99','',@connection,'','6','id','id','3','pixels','25833','','1','80',NULL,'99','50001','','EPSG:25833','','1.1.0','image/png','60','','','','','1','1','','','','','0');
 SET @last_layer_id50303065=LAST_INSERT_ID();
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303065,'name','name','befriedete_bezirke','befriedete_bezirke','varchar','','','1','50',NULL,'','Text','','Name','','','','','','',NULL,NULL,'0','0','1');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303065,'the_geom','the_geom','befriedete_bezirke','befriedete_bezirke','geometry','MULTIPOLYGON','','1',NULL,NULL,'','Geometrie','','','','','','','','',NULL,NULL,'2','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303065,'zu_gjb','zu_gjb','befriedete_bezirke','befriedete_bezirke','varchar','','','1','50',NULL,'','Text','','zu gemeinschaftl. Jagdbezirk','','','','','Zuständigkeit','',NULL,NULL,'1','0','0');
 INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES(' ',@last_layer_id50303065,'','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,'','1','214 238 244','','-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,'','','-1 -1 -1','','124 144 152',NULL,NULL,'360','',NULL,'3','1','5','');
  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('ubuntu-medium',NULL,'81 97 104','255 255 255','',NULL,NULL,'','',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, '50303065', @last_layer_id50303065) WHERE layer_id IN(@last_layer_id50303065) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK', 'Autovervollständigungsfeld', 'Auswahlfeld');


Befriedete Bezirke Flurstücke/Nutzungen

Dieses Thema hat nur Leserechte. 

 SET @group_id = @group_id_jagdkataster;
 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('Befriedete Bezirke - Nutzungen','','5',@group_id,'select * from befriedete_bezirke_flurstuecke WHERE 1=1','befriedete_bezirke_flurstuecke','','jagdkataster','','','','','',NULL,NULL,'',@connection,'','6','id','id','3','pixels','25833','','1',NULL,NULL,'-1','-1','','EPSG:25833','','1.1.0','image/png','60','','','','','0','1','','','untere Jagdbehörde','','0');
SET @last_layer_id50303068=LAST_INSERT_ID();
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303068,'amtlicheflaeche','amtlicheflaeche','befriedete_bezirke_flurstuecke','befriedete_bezirke_flurstuecke','float8','','','1','53',NULL,'','Text','','Amtliche Fläche [m²]','','','','','','Flurstück',NULL,NULL,'2','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303068,'flurstueckskennzeichen','flurstueckskennzeichen','befriedete_bezirke_flurstuecke','befriedete_bezirke_flurstuecke','bpchar','','','1','20',NULL,'','Text','','Flurstückskennzeichen','','','','','','Flurstück',NULL,NULL,'1','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303068,'fst_teilflaeche_abs','fst_teilflaeche_abs','befriedete_bezirke_flurstuecke','befriedete_bezirke_flurstuecke','numeric','','','1',NULL,NULL,'','Text','','Fläche im Bezirk [m²]','','','','','','Flurstück',NULL,NULL,'3','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303068,'fst_teilflaeche_proz','fst_teilflaeche_proz','befriedete_bezirke_flurstuecke','befriedete_bezirke_flurstuecke','numeric','','','1',NULL,NULL,'','Text','','Fläche im Bezirk [%]','','','','','','Flurstück',NULL,NULL,'4','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303068,'id','id','befriedete_bezirke_flurstuecke','befriedete_bezirke_flurstuecke','int4','','','1','32','0','','Text','','ID Bezirk','','','','','','Flurstück',NULL,NULL,'0','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303068,'naschluessel','naschluessel','befriedete_bezirke_flurstuecke','befriedete_bezirke_flurstuecke','text','','','1',NULL,NULL,'','Text','','Nutzungsartenschlüssel','','','','','','Nutzung',NULL,NULL,'5','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303068,'na_teilflaeche_abs','na_teilflaeche_abs','befriedete_bezirke_flurstuecke','befriedete_bezirke_flurstuecke','numeric','','','1',NULL,NULL,'','Text','','NA Fläche im Bezirk [m²]','','','','','','Nutzung',NULL,NULL,'7','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303068,'na_teilflaeche_proz','na_teilflaeche_proz','befriedete_bezirke_flurstuecke','befriedete_bezirke_flurstuecke','numeric','','','1',NULL,NULL,'','Text','','NA Fläche im Bezirk [%]','','','','','','Nutzung',NULL,NULL,'8','0','0');
 INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`decimal_length`,`default`,`form_element_type`,`options`,`alias`,`alias_low-german`,`alias_english`,`alias_polish`,`alias_vietnamese`,`tooltip`,`group`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303068,'nutzung','nutzung','befriedete_bezirke_flurstuecke','befriedete_bezirke_flurstuecke','varchar','','','1',NULL,NULL,'','Text','','Nutzungsbezeichnung','','','','','','Nutzung',NULL,NULL,'6','0','0');
 
 UPDATE layer_attributes SET options = REPLACE(options, '50303068', @last_layer_id50303068) WHERE layer_id IN(@last_layer_id50303068) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK', 'Autovervollständigungsfeld', 'Auswahlfeld');
Von „https://kvwmap.de/wiki/index.php?title=GLE-Layer-Jagdkataster&oldid=10108“