Abfrage von Daten im Umring: Unterschied zwischen den Versionen

Version vom 9. Juli 2013, 12:06 Uhr

--HolgerR 13:02, 21. Sep 2012 (CEST) Um Daten im Umring abzufragen werden 2 Layer benötigt. Einen Layer zum Abspeichern des Umringes und einen für die Abfragedefinition. Der Layer mit der Abfragedefinition weist in der DATA-Definition auf den Umringslayer. Im PFAD-Statement wird der Umringslayer mit den gewünschten Sachinformationen über ein intersects-Aufruf verknüpft. Dies kann auch über ein View in PostgreSQL erfolgen

Das Vorgehen soll am Beispiel zur Abfrage der ALB-Daten im Umkreis eines UKO-Umringes dargestellt werden.
Voraussetzung:

1. Tabelle uko_polygon in PostgreSQL

 CREATE TABLE uko_polygon
 (
   id serial NOT NULL,
   username character varying(25),
   userid integer,
   dateiname character varying(50)
 )
 WITH OIDS;
 SELECT AddGeometryColumn ('public','uko_polygon','the_geom',2398,'GEOMETRY',2);  -- oder 2399

2. View für den Abfragelayer erstellen

CREATE OR REPLACE VIEW alb_umring AS 
 SELECT alko.oid, alkf.flurstkennz, "substring"(alkf.flurstkennz::text, 8, 3) AS flurnr, 'template_erforderlich'::text AS entsteh, 'template_erforderlich'::text AS letzff, 'template_erforderlich'::text AS status, 'template_erforderlich'::text AS flaeche, 'template_erforderlich'::text AS karte, 'template_erforderlich'::text AS kreisid, 'template_erforderlich'::text AS kreisname, alkf.gemkgschl, 'template_erforderlich'::text AS gemkgname, 'template_erforderlich'::text AS gemeinde, 'template_erforderlich'::text AS gemeindename, 'template_erforderlich'::text AS finanzamt, 'template erforderlich'::text AS finanzamtname, 'template_erforderlich'::text AS forstschluessel, 'template_erforderlich'::text AS forstname, 'template_erforderlich'::text AS lagebezeichnung, 'template erforderlich'::text AS nutzung, 'template erforderlich'::text AS ausfstelle, 'template erforderlich'::text AS verfahren, 'template erforderlich'::text AS vorgaenger, 'template erforderlich'::text AS nachfolger, 'template erforderlich'::text AS bestandsnr, 'template erforderlich'::text AS eigentuemer, 'template erforderlich'::text AS freitext, 'template erforderlich'::text AS hinweis, 'template erforderlich'::text AS baulasten, 'template erforderlich'::text AS amtsgerichtname, 'template erforderlich'::text AS amtsgerichtnr, 'template erforderlich'::text AS grundbuchbezirkname, 'template erforderlich'::text AS grundbuchbezirkschl, 'template erforderlich'::text AS klassifizierung, b.the_geom
   FROM alknflst alkf, alkobj_e_fla alko, uko_polygon b
  WHERE alko.folie::text = '001'::text AND alko.objnr::text = alkf.objnr::text AND intersects(alko.the_geom, b.the_geom)
  ORDER BY alkf.flurstkennz;

3. Layer für die Umringspolygone anlegen

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

INSERT INTO layer (`Name`,`Datentyp`,`Gruppe`,`pfad`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`epsg_code`,`template`,`queryable`,`transparency`,`drawingorder`,`minscale`,`maxscale`,`offsite`,`ows_srs`,`wms_name`,`wms_server_version`,`wms_format`,`wms_connectiontimeout`,`wms_auth_username`,`wms_auth_password`,`wfs_geom`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`) 
  VALUES('Umring','2',@group_id,'SELECT oid, id, username, userid, dateiname, the_geom FROM uko_polygon WHERE 1=1','the_geom from (Select oid,username, userid, dateiname, the_geom FROM uko_polygon)as foo using unique oid using srid=2398','','','','','','username','5000','0','',@connection,'','6','oid','','3','pixels','2398','','1','50','4000',NULL,NULL,'','EPSG:2398','','1.1.0','image/png','60','','','','','1','0','','','');
SET @last_layer_id555=LAST_INSERT_ID();

INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id555,'id','id','uko_polygon','uko_polygon','int4','','','1',NULL,'Text','','','','1');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id555,'oid','oid','uko_polygon','uko_polygon','oid','','',NULL,NULL,'Text','','','','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id555,'the_geom','the_geom','uko_polygon','uko_polygon','geometry','MULTIPOLYGON','','1',NULL,'Geometrie','','','','4');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id555,'username','username','uko_polygon','uko_polygon','varchar','','','1','25','User','','','','2');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`)
  VALUES(@last_layer_id555,'userid','userid','uko_polygon','uko_polygon','int4','','','1','32','UserID','','User-ID','','3');

INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) 
  VALUES('',@last_layer_id555,'','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('9','','2','-1 -1 -1','','255 0 0','4','8','360','',NULL,NULL,NULL,NULL,'');
SET @last_style_id=LAST_INSERT_ID();

INSERT INTO u_styles2classes (style_id, class_id, drawingorder) 
  VALUES (@last_style_id, @last_class_id, 0);

INSERT INTO labels (`font`,`type`,`color`,`outlinecolor`,`shadowcolor`,`shadowsizex`,`shadowsizey`,`backgroundcolor`,`backgroundshadowcolor`,`backgroundshadowsizex`,`backgroundshadowsizey`,`size`,`minsize`,`maxsize`,`position`,`offsetx`,`offsety`,`angle`,`autoangle`,`buffer`,`antialias`,`minfeaturesize`,`maxfeaturesize`,`partials`,`wrap`,`the_force`) 
  VALUES('arial',NULL,'185 23 0','255 255 255','',NULL,NULL,'','',NULL,NULL,'8','6','10',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
SET @last_label_id=LAST_INSERT_ID();

INSERT INTO u_labels2classes (label_id, class_id) 
  VALUES (@last_label_id, @last_class_id);

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

4. Abfrage-Layer erstellen

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

INSERT INTO layer (`Name`,`Datentyp`,`Gruppe`,`pfad`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`epsg_code`,`template`,`queryable`,`transparency`,`drawingorder`,`minscale`,`maxscale`,`offsite`,`ows_srs`,`wms_name`,`wms_server_version`,`wms_format`,`wms_connectiontimeout`,`wms_auth_username`,`wms_auth_password`,`wfs_geom`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`) 
  VALUES('ALB im Umring','2',@group_id,'SELECT * from alb_umring where 1=1','the_geom from (Select oid,username,the_geom FROM uko_polygon)as foo using unique oid using srid=2398','','','','','','username','5000','0','',@connection,'','6','oid','','3','pixels','2398','Flurstuecke_custom_mit_Eigentuemer.php','1','50','4000',NULL,NULL,'','EPSG:2398','','1.1.0','image/png','60','','','','','1','0','','','');
SET @last_layer_id558=LAST_INSERT_ID();

INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'amtsgerichtname','amtsgerichtname','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','29');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'amtsgerichtnr','amtsgerichtnr','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','30');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'ausfstelle','ausfstelle','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','20');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'baulasten','baulasten','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','28');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'bestandsnr','bestandsnr','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','24');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'eigentuemer','eigentuemer','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','25');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'entsteh','entsteh','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','3');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'finanzamt','finanzamt','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','14');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'finanzamtname','finanzamtname','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','15');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'flaeche','flaeche','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','6');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'flurnr','flurnr','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','2');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'flurstkennz','flurstkennz','alb_umring','alb_umring','varchar','','','1','27','Text','','','','1');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'forstname','forstname','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','17');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'forstschluessel','forstschluessel','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','16');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'freitext','freitext','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','26');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'gemeinde','gemeinde','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','12');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'gemeindename','gemeindename','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','13');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'gemkgname','gemkgname','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','11');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'gemkgschl','gemkgschl','alb_umring','alb_umring','varchar','','','1','6','Text','','','','10');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'grundbuchbezirkname','grundbuchbezirkname','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','31');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) VALUES
  (@last_layer_id558,'grundbuchbezirkschl','grundbuchbezirkschl','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','32');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'hinweis','hinweis','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','27');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'karte','karte','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','7');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'klassifizierung','klassifizierung','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','33');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'kreisid','kreisid','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','8');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'kreisname','kreisname','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','9');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'lagebezeichnung','lagebezeichnung','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','18');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'letzff','letzff','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','4');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'nachfolger','nachfolger','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','23');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'nutzung','nutzung','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','19');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'oid','oid','alb_umring','alb_umring','oid','','','1',NULL,'Text','','','','0');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'status','status','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','5');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'the_geom','the_geom','alb_umring','alb_umring','geometry','MULTIPOLYGON','','1',NULL,'Text','','','','34');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'verfahren','verfahren','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','21');
INSERT INTO layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`) 
  VALUES(@last_layer_id558,'vorgaenger','vorgaenger','alb_umring','alb_umring','text','','','1',NULL,'Text','','','','22');

INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) 
  VALUES('',@last_layer_id558,'','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('9','','2','-1 -1 -1','','255 0 0','4','8','360','',NULL,NULL,NULL,NULL,'');
SET @last_style_id=LAST_INSERT_ID();

INSERT INTO u_styles2classes (style_id, class_id, drawingorder) 
  VALUES (@last_style_id, @last_class_id, 0);

INSERT INTO labels (`font`,`type`,`color`,`outlinecolor`,`shadowcolor`,`shadowsizex`,`shadowsizey`,`backgroundcolor`,`backgroundshadowcolor`,`backgroundshadowsizex`,`backgroundshadowsizey`,`size`,`minsize`,`maxsize`,`position`,`offsetx`,`offsety`,`angle`,`autoangle`,`buffer`,`antialias`,`minfeaturesize`,`maxfeaturesize`,`partials`,`wrap`,`the_force`) 
  VALUES('arial',NULL,'185 23 0','255 255 255','',NULL,NULL,'','',NULL,NULL,'8','6','10',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
SET @last_label_id=LAST_INSERT_ID();

INSERT INTO u_labels2classes (label_id, class_id) 
  VALUES (@last_label_id, @last_class_id);

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

5. Menue (z.B. Umring_Import) mit go-Variable UKO_Import

Bedienung:

1. UKO mit Menue UKO_Import einlesen
2. Layer 'ALB im Umring' aktiv und abfragbar setzen
3. Informationsabfrage mit Klick in den Umringspolygon starten
4. Abfrageergebnisse erhalten

Hinweise:

• geladene Umringspolygone zeitnah löschen
• auch für andere Layer anwendbar --> View für den Abfragelayer muss entsprechend erstellt werden