Abfrage von Daten im Umring - Versionsgeschichte

Markus Hentschel am 10. Juli 2013 um 08:44 Uhr

2013-07-10T08:44:15Z

Markus Hentschel am 10. Juli 2013 um 08:41 Uhr

2013-07-10T08:41:17Z

Markus Hentschel am 9. Juli 2013 um 10:12 Uhr

2013-07-09T10:12:38Z

Markus Hentschel am 9. Juli 2013 um 10:11 Uhr

2013-07-09T10:11:57Z

Markus Hentschel am 9. Juli 2013 um 10:06 Uhr

2013-07-09T10:06:24Z

Markus Hentschel am 9. Juli 2013 um 10:04 Uhr

2013-07-09T10:04:50Z

Markus Hentschel am 9. Juli 2013 um 09:19 Uhr

2013-07-09T09:19:58Z

HolgerR am 21. September 2012 um 11:02 Uhr

2012-09-21T11:02:28Z

Neue Seite

--[[Benutzer:HolgerR|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

<pre> CREATE TABLE uko_polygon
(
id serial NOT NULL,
username character varying(25),
dateiname character varying(50)
)
WITH OIDS;
SELECT AddGeometryColumn ('public','uko_polygon','the_geom',2398,'GEOMETRY',2); -- oder 2399
</pre>
:2. View für den Abfragelayer erstellen
<pre>
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;

</pre>
:3. Layer für die Umringspolygone anlegen
<pre>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,the_geom FROM uko_polygon 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','','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','','','','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_id555,'username','username','uko_polygon','uko_polygon','varchar','','','1','25','User','','','','2');

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');
</pre>
:4. Abfrage-Layer erstellen
<pre>
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');
</pre>
:5. Menue (z.B. Umring_Import) mit go-Variable UKO_Import
 
'''Bedienung:''' 
#UKO mit Menue UKO_Import einlesen
#Layer 'ALB im Umring' aktiv und abfragbar setzen
#Informationsabfrage mit Klick in den Umringspolygon starten
#Abfrageergebnisse erhalten
 
'''Hinweise:''' 
*geladene Umringspolygone zeitnah löschen
*auch für andere Layer anwendbar --> View für den Abfragelayer muss entsprechend erstellt werden

@@ Zeile 61: / Zeile 61: @@
 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');
 Die Layerattributrechte sind sinnvollerweise alle lesend, mit Ausnahme der editierbaren Geometrie. Der Layer sollte das Recht Löschen beinhalten.
@@ Zeile 66: / Zeile 67: @@
 Das Attribut userid kann (ab Version 1.12) vom Typ UserID sein. In der Filterverwaltung kann dann (ebenfalls ab Version 1.12) für dieses Attribut der Wert "$userid" eingetragen werden. Der Nutzer sieht dann nur noch seine UKO-Importe.
-</pre>
 :4. Abfrage-Layer erstellen
 <pre>

@@ Zeile 168: / Zeile 168: @@
 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');
 </pre>
 :5. Menue (z.B. Umring_Import) mit go-Variable UKO_Import
 <br/>
 '''Bedienung:'''<br/>

@@ Zeile 17: / Zeile 17: @@
 <pre>
 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
+  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.username, b.userid, b.dateiname, 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)

@@ Zeile 36: / Zeile 36: @@
    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','','','','3');
+   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 layer_attributes (`layer_id`,`name`,`real_name`,`tablename`,`table_alias_name`,`type`,`geometrytype`,`constraints`,`nullable`,`length`,`form_element_type`,`options`,`alias`,`tooltip`,`order`)
 INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`)

@@ Zeile 8: / Zeile 8: @@
     id serial NOT NULL,
     username character varying(25),
     dateiname character varying(50)
+  )
@@ Zeile 27: / Zeile 28: @@
 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, dateiname, the_geom FROM uko_polygon WHERE 1=1','the_geom from (Select oid,username, 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','','','');
+   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();
@@ Zeile 38: / Zeile 39: @@
 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 classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`)