GLE-Layer-Jagdkataster: Unterschied zwischen den Versionen

Aus kvwmap
Wechseln zu: Navigation, Suche
(→‎Abgerundete EJB)
Zeile 86: Zeile 86:
 
   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 = 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('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','','','untere Jagdbehörde','','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>
 
  </nowiki>

Version vom 29. Februar 2016, 17:20 Uhr

EJB Verdachtsflächen

Dieses Thema hat nur Leserechte. 

 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('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');

Abgerundete EJB

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 = 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('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 = 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('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','','','untere Jagdbehörde','','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');
Von „https://kvwmap.de/wiki/index.php?title=GLE-Layer-Jagdkataster&oldid=9934“