GLE-Layer-ALB

Aus kvwmap
Wechseln zu: Navigation, Suche
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`) VALUES('Buchdaten - Buchung','2',@group_id,'SELECT gb, bezeichnung, bezirk, blatt, bvnr, erbbaurechtshinw, flurstkennz, grundbuch, grundstueck, eigentuemer, the_geom FROM alb_buchung WHERE (1=1)','the_geom from (select oid, oid as id, the_geom from alb_buchung) as foo using unique oid using srid=2398','','','','','','','500002','100','',@connection,'','6','oid','oid','15','pixels','2398','','1',NULL,NULL,'-1','-1','','EPSG:2398','Buchdaten Grundbuch-Buchung','1.1.0','image/png','60','','','','','1','');
 SET @last_layer_id7233=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_id7233,'bezeichnung','bezeichnung','alb_buchung','alb_buchung','varchar','','','1','50','Text','','Name GB-Bezirk','','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_id7233,'bezirk','bezirk','alb_buchung','alb_buchung','int4','','','1',NULL,'Text','','Grundbuchbezirk','','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_id7233,'blatt','blatt','alb_buchung','alb_buchung','text','','','1',NULL,'Text','','Blattnummer','','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_id7233,'bvnr','bvnr','alb_buchung','alb_buchung','varchar','','','1','4','Text','','BVNR','Bestandsverzeichnisnummer','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_id7233,'eigentuemer','eigentuemer','alb_buchung','alb_buchung','unknown','','','1',NULL,'SubFormEmbeddedPK','7235,bezirk,blatt,name1;embedded','Eigentümer','','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_id7233,'erbbaurechtshinw','erbbaurechtshinw','alb_buchung','alb_buchung','bpchar','','','1',NULL,'Auswahlfeld','select buchungsart as value, \'(\' || buchungsart || \') \' || bezeichnung  as output from alb_v_buchungsarten','Buchungsart','','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_id7233,'flurstkennz','flurstkennz','alb_buchung','alb_buchung','varchar','','','1','23','SubFormEmbeddedPK','7216,flurstkennz,flurstkennz;no_new_window','FST-Kennzeichen','','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_id7233,'gb','gb','alb_buchung','alb_buchung','text','','','1',NULL,'Text','','Grundbuch','','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_id7233,'grundbuch','grundbuch','alb_buchung','alb_buchung','unknown','','','1',NULL,'SubFormEmbeddedPK','7232,bezirk,blatt,gb;no_new_window','Grundbuch','','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_id7233,'grundstueck','grundstueck','alb_buchung','alb_buchung','unknown','','','1',NULL,'SubFormEmbeddedPK','7234,bezirk,blatt,bvnr,gst;no_new_window','Grundstück','','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_id7233,'the_geom','the_geom','alb_buchung','alb_buchung','geometry','MULTIPOLYGON','','1',NULL,'Geometrie','','','','10');
 
 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`) VALUES('Buchdaten - Eigentümer','5',@group_id,'SELECT gb, bezeichnung, bezirk, blatt, namensnr, eigentuemerart, anteilsverhaeltnis, name1, name2, name3, name4 FROM alb_eigentuemer WHERE (1=1)','','','','','','','','500002','100','',@connection,'','6','id','id','15','pixels','2398','','1',NULL,NULL,'-1','-1','','EPSG:2398','Buchdaten FST-Lage','1.1.0','image/png','60','','','','','0','');
 SET @last_layer_id7235=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_id7235,'anteilsverhaeltnis','anteilsverhaeltnis','alb_eigentuemer','alb_eigentuemer','varchar','','','1','25','Text','','Anteilsverhältnis','','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_id7235,'bezeichnung','bezeichnung','alb_eigentuemer','alb_eigentuemer','varchar','','','1','50','Text','','Name GB-Bezirk','','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_id7235,'bezirk','bezirk','alb_eigentuemer','alb_eigentuemer','int4','','','1',NULL,'Text','','Grundbuchbezirk','','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_id7235,'blatt','blatt','alb_eigentuemer','alb_eigentuemer','text','','','1',NULL,'Text','','Blattnummer','','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_id7235,'eigentuemerart','eigentuemerart','alb_eigentuemer','alb_eigentuemer','varchar','','','1','80','Auswahlfeld','select bezeichnung as value, bezeichnung as output from alb_v_eigentuemerarten order by bezeichnung','Eigentümerart','','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_id7235,'gb','gb','alb_eigentuemer','alb_eigentuemer','text','','','1',NULL,'SubFormPK','7233,bezirk,blatt;no_new_window','Grundbuch','','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_id7235,'name1','name1','alb_eigentuemer','alb_eigentuemer','text','','','1',NULL,'Text','','Name / Firmenname','','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_id7235,'name2','name2','alb_eigentuemer','alb_eigentuemer','text','','','1',NULL,'Text','','Geburtsname / Zusatz','','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_id7235,'name3','name3','alb_eigentuemer','alb_eigentuemer','varchar','','','1','52','Text','','Straße, Hausnummer','','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_id7235,'name4','name4','alb_eigentuemer','alb_eigentuemer','varchar','','','1','52','Text','','PLZ, Ort','','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_id7235,'namensnr','namensnr','alb_eigentuemer','alb_eigentuemer','varchar','','','1','16','Text','','Namensnummer','','4');
 
 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`) VALUES('Buchdaten - Flurstück','2',@group_id,'SELECT flurstkennz, gemkgname, gemkgschl,  flurnr, zaehler, nenner, pruefzeichen, status, entsteh, letzff, flaeche, aktunr, karte, baublock, forstamt, finanzamt, erbbau, grundbuch, adresse, lage, hinweis, verfahren, nutzung, vorgaenger, the_geom FROM  alb_flurstueck WHERE (1=1)','the_geom from (SELECT oid, oid as id, the_geom from alb_flurstueck) as foo using unique oid using srid=2398','','','','','','','500002','100','',@connection,'','6','id','id','15','pixels','2398','','1',NULL,NULL,'-1','-1','','EPSG:2398','Buchdaten FST','1.1.0','image/png','60','','','','','1','');
 SET @last_layer_id7216=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_id7216,'adresse','adresse','alb_flurstueck','alb_flurstueck','unknown','','','1',NULL,'SubFormEmbeddedPK','7229,flurstkennz,adresse;embedded','Flurstücksadresse','','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_id7216,'aktunr','aktunr','alb_flurstueck','alb_flurstueck','text','','','1',NULL,'Text','','Aktualitätsnummer','','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_id7216,'baublock','baublock','alb_flurstueck','alb_flurstueck','text','','','1',NULL,'Text','','Baublock','','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_id7216,'entsteh','entsteh','alb_flurstueck','alb_flurstueck','text','','','1',NULL,'Text','','Entstehung','','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_id7216,'erbbau','erbbau','alb_flurstueck','alb_flurstueck','text','','','1',NULL,'Text','','Erbbau','','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_id7216,'finanzamt','finanzamt','alb_flurstueck','alb_flurstueck','text','','','1',NULL,'Auswahlfeld','select name as value, name as output from alb_v_finanzaemter','Finanzamt','','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_id7216,'flaeche','flaeche','alb_flurstueck','alb_flurstueck','int4','','','1',NULL,'Text','','Fläche [m²]','','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_id7216,'flurnr','flurnr','alb_flurstueck','alb_flurstueck','text','','','1',NULL,'Text','','Flur','','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_id7216,'flurstkennz','flurstkennz','alb_flurstueck','alb_flurstueck','varchar','','','1','23','Text','','FST-Kennzeichen','','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_id7216,'forstamt','forstamt','alb_flurstueck','alb_flurstueck','varchar','','','1','78','Auswahlfeld','select name as value, name as output from alb_v_forstaemter','Forstamt','','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_id7216,'gemkgname','gemkgname','alb_flurstueck','alb_flurstueck','varchar','','','1','255','Text','','Gemarkungsname','','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_id7216,'gemkgschl','gemkgschl','alb_flurstueck','alb_flurstueck','int4','','','1',NULL,'Text','','Gemarkungsschlüssel','','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_id7216,'grundbuch','grundbuch','alb_flurstueck','alb_flurstueck','unknown','','','1',NULL,'SubFormEmbeddedPK','7233,flurstkennz,gb;no_new_window','Buchung','','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_id7216,'hinweis','hinweis','alb_flurstueck','alb_flurstueck','unknown','','','1',NULL,'SubFormEmbeddedPK','7230,flurstkennz,bezeichnung;embedded','Hinweis','','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_id7216,'karte','karte','alb_flurstueck','alb_flurstueck','text','','','1',NULL,'Text','','Karte','','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_id7216,'lage','lage','alb_flurstueck','alb_flurstueck','unknown','','','1',NULL,'SubFormEmbeddedPK','7228,flurstkennz,lagebezeichnung;embedded','Lagebezeichnung','','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_id7216,'letzff','letzff','alb_flurstueck','alb_flurstueck','text','','','1',NULL,'Text','','Letzte Fortführung','','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_id7216,'nenner','nenner','alb_flurstueck','alb_flurstueck','text','','','1',NULL,'Text','','FST-Nenner','','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_id7216,'nutzung','nutzung','alb_flurstueck','alb_flurstueck','unknown','','','1',NULL,'SubFormEmbeddedPK','7231,flurstkennz,bezeichnung;embedded','Tatsächliche Nutzung','','22');
 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_id7216,'pruefzeichen','pruefzeichen','alb_flurstueck','alb_flurstueck','text','','','1',NULL,'Auswahlfeld','\'0\',\'1\',\'2\',\'3\',\'4\',\'5\',\'6\',\'7\',\'8\',\'9\'','Prüfzeichen','','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_id7216,'status','status','alb_flurstueck','alb_flurstueck','text','','','1',NULL,'Auswahlfeld','\'0\',\'2\',\'H\'','Status','','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_id7216,'the_geom','the_geom','alb_flurstueck','alb_flurstueck','geometry','MULTIPOLYGON','','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_id7216,'verfahren','verfahren','alb_flurstueck','alb_flurstueck','unknown','','','1',NULL,'SubFormEmbeddedPK','7248,flurstkennz,ausfstellenr;embedded','Verfahren','','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_id7216,'vorgaenger','vorgaenger','alb_flurstueck','alb_flurstueck','unknown','','','1',NULL,'SubFormEmbeddedPK','7249,flurstkennz,vorgaenger;embedded','Vorgängerflurstücke','','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_id7216,'zaehler','zaehler','alb_flurstueck','alb_flurstueck','text','','','1',NULL,'Text','','FST-Zähler','','4');
 
 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`) VALUES('Buchdaten - Flurstücksadresse','5',@group_id,'SELECT flurstkennz, fst, adresse, gemeinde, gemeindename, strasse, hausnr FROM alb_adresse WHERE (1=1)','','','','','','','','500002','100','',@connection,'','6','id','id','15','pixels','2398','','1',NULL,NULL,'-1','-1','','EPSG:2398','Buchdaten FST-Lage','1.1.0','image/png','60','','','','','0','');
 SET @last_layer_id7229=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_id7229,'adresse','adresse','alb_adresse','alb_adresse','text','','','1',NULL,'Text','','Flurstücksadresse','','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_id7229,'flurstkennz','flurstkennz','alb_adresse','alb_adresse','varchar','','','1','23','Textfeld','','','','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_id7229,'fst','fst','alb_adresse','alb_adresse','varchar','','','1','23','SubFormFK','7216,flurstkennz;no_new_window','FST-Kennzeichen','','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_id7229,'gemeinde','gemeinde','alb_adresse','alb_adresse','int4','','','1',NULL,'Text','','Gemeindeschlüssel','','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_id7229,'gemeindename','gemeindename','alb_adresse','alb_adresse','varchar','','','1','26','Auswahlfeld','select gemeindename as value, gemeindename as output from alb_v_gemeinden','Gemeinde','','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_id7229,'hausnr','hausnr','alb_adresse','alb_adresse','text','','','1',NULL,'Text','','Hausnummer','','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_id7229,'strasse','strasse','alb_adresse','alb_adresse','text','','','1',NULL,'Text','','Strasse','','5');
 
 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`) VALUES('Buchdaten - Grundbuch','5',@group_id,'SELECT gb, bezeichnung, bezirk, blatt, pruefzeichen, aktualitaetsnr, zusatz_eigentuemer, bestandsflaeche, buchung, grundstueck, eigentuemer FROM alb_grundbuch WHERE (1=1)','','','','','','','','500002','100','',@connection,'','6','id','id','15','pixels','2398','','1',NULL,NULL,'-1','-1','','EPSG:2398','Buchdaten FST-Lage','1.1.0','image/png','60','','','','','0','');
 SET @last_layer_id7232=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_id7232,'aktualitaetsnr','aktualitaetsnr','alb_grundbuch','alb_grundbuch','text','','','1',NULL,'Text','','Aktualitätsnummer','','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_id7232,'bestandsflaeche','bestandsflaeche','alb_grundbuch','alb_grundbuch','int4','','','1',NULL,'Text','','Bestandsfläche [m²]','','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_id7232,'bezeichnung','bezeichnung','alb_grundbuch','alb_grundbuch','varchar','','','1','50','Text','','Name GB-Bezirk','','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_id7232,'bezirk','bezirk','alb_grundbuch','alb_grundbuch','int4','','','1',NULL,'Text','','Grundbuchbezirk','','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_id7232,'blatt','blatt','alb_grundbuch','alb_grundbuch','text','','','1',NULL,'Text','','Blattnummer','','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_id7232,'buchung','buchung','alb_grundbuch','alb_grundbuch','text','','','1',NULL,'SubFormEmbeddedPK','7233,bezirk,blatt,flurstkennz;no_new_window','Buchung','','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_id7232,'eigentuemer','eigentuemer','alb_grundbuch','alb_grundbuch','unknown','','','1',NULL,'SubFormEmbeddedPK','7235,bezirk,blatt,name1;embedded','Eigentümer','','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_id7232,'gb','gb','alb_grundbuch','alb_grundbuch','text','','','1',NULL,'Text','','Grundbuch','','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_id7232,'grundstueck','grundstueck','alb_grundbuch','alb_grundbuch','unknown','','','1',NULL,'SubFormEmbeddedPK','7234,bezirk,blatt,gst;no_new_window','Grundstück','','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_id7232,'pruefzeichen','pruefzeichen','alb_grundbuch','alb_grundbuch','bpchar','','','1',NULL,'Text','','Prüfzeichen','','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_id7232,'zusatz_eigentuemer','zusatz_eigentuemer','alb_grundbuch','alb_grundbuch','text','','','1',NULL,'Textfeld','','Zusatz Eigentümer','','6');
 
 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`) VALUES('Buchdaten - Grundstück','5',@group_id,'SELECT gst, bezeichnung, bezirk, blatt, bvnr, buchung, grundbuch, buchungsart, anteil, auftplannr, sondereigentum FROM alb_grundstueck WHERE (1=1)','','','','','','','','500002','100','',@connection,'','6','id','id','15','pixels','2398','','1',NULL,NULL,'-1','-1','','EPSG:2398','Buchdaten FST-Lage','1.1.0','image/png','60','','','','','0','');
 SET @last_layer_id7234=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_id7234,'anteil','anteil','alb_grundstueck','alb_grundstueck','varchar','','','1','24','Text','','Anteil','','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_id7234,'auftplannr','auftplannr','alb_grundstueck','alb_grundstueck','varchar','','','1','12','Text','','Aufteilungsplannummer','','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_id7234,'bezeichnung','bezeichnung','alb_grundstueck','alb_grundstueck','varchar','','','1','50','Text','','Name GB-Bezirk','','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_id7234,'bezirk','bezirk','alb_grundstueck','alb_grundstueck','int4','','','1',NULL,'Text','','Grundbuchbezirk','','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_id7234,'blatt','blatt','alb_grundstueck','alb_grundstueck','text','','','1',NULL,'Text','','Blattnummer','','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_id7234,'buchung','buchung','alb_grundstueck','alb_grundstueck','text','','','1',NULL,'SubFormFK','7233,bezirk,blatt,bvnr;no_new_window','Buchung','','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_id7234,'buchungsart','buchungsart','alb_grundstueck','alb_grundstueck','text','','','1',NULL,'Auswahlfeld','select buchungsart || \' - \' || bezeichnung as value, buchungsart || \' - \' || bezeichnung as output from alb_v_buchungsarten order by bezeichnung','Buchungsart','','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_id7234,'bvnr','bvnr','alb_grundstueck','alb_grundstueck','varchar','','','1','4','Text','','BVNR','','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_id7234,'grundbuch','grundbuch','alb_grundstueck','alb_grundstueck','unknown','','','1',NULL,'SubFormEmbeddedPK','7232,bezirk,blatt,gb;no_new_window','Grundbuch','','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_id7234,'gst','gst','alb_grundstueck','alb_grundstueck','text','','','1',NULL,'Text','','Grundstück','','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_id7234,'sondereigentum','sondereigentum','alb_grundstueck','alb_grundstueck','text','','','1',NULL,'Text','','Sondereigentum','','10');
 
 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`) VALUES('Buchdaten - Hinweise zum FST','5',@group_id,'SELECT flurstkennz, substring(flurstkennz from 1 for 6) as gemarkung, trim(leading \'0\' from substring(flurstkennz from 8 for 3)) as flur, trim(leading \'0\' from substring(flurstkennz from 12 for 5)) as zaehler, trim(leading \'0\' from substring(flurstkennz from 18 for 3)) as nenner, bezeichnung FROM alb_hinweise WHERE (1=1)','','','','','','','','500002','100','',@connection,'','6','id','id','15','pixels','2398','','1',NULL,NULL,'-1','-1','','EPSG:2398','Buchdaten FST-Lage','1.1.0','image/png','60','','','','','0','');
 SET @last_layer_id7230=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_id7230,'bezeichnung','bezeichnung','alb_hinweise','alb_hinweise','varchar','','','1','80','Auswahlfeld','select bezeichnung as value, bezeichnung as output from alb_v_hinweise order by bezeichnung','Hinweis','','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_id7230,'flur','flur','','','text','','',NULL,NULL,'Text','','Flur','','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_id7230,'flurstkennz','flurstkennz','alb_hinweise','alb_hinweise','varchar','','','1','23','Text','','FST-Kennzeichen','','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_id7230,'gemarkung','gemarkung','','','text','','',NULL,NULL,'Text','','Gemarkung','','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_id7230,'nenner','nenner','','','text','','',NULL,NULL,'Text','','FST Nenner','','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_id7230,'zaehler','zaehler','','','text','','',NULL,NULL,'Text','','FST Zähler','','3');
 
 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`) VALUES('Buchdaten - Lagebezeichnung','5',@group_id,'SELECT flurstkennz, lfdnr, lagebezeichnung FROM alb_f_lage WHERE (1=1) ORDER BY lfdnr','','','','','','','','500002','100','',@connection,'','6','id','id','15','pixels','2398','','1',NULL,NULL,'-1','-1','','EPSG:2398','Buchdaten FST-Lage','1.1.0','image/png','60','','','','','0','');
 SET @last_layer_id7228=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_id7228,'flurstkennz','flurstkennz','alb_f_lage','alb_f_lage','varchar','','','0','23','Text','','FST-Kennzeichen','','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_id7228,'lagebezeichnung','lagebezeichnung','alb_f_lage','alb_f_lage','varchar','','','1','30','Text','','Lagebezeichnung','','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_id7228,'lfdnr','lfdnr','alb_f_lage','alb_f_lage','bpchar','','','0',NULL,'Text','','lfd. Nummer','','1');
 
 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`) VALUES('Buchdaten - Tatsächliche Nutzung','5',@group_id,'SELECT flurstkennz, nutzungsart, bezeichnung, flaeche FROM alb_nutzungen WHERE (1=1)','','','','','','','','500002','100','',@connection,'','6','id','id','15','pixels','2398','','1',NULL,NULL,'-1','-1','','EPSG:2398','Buchdaten FST-Lage','1.1.0','image/png','60','','','','','0','');
 SET @last_layer_id7231=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_id7231,'bezeichnung','bezeichnung','alb_nutzungen','alb_nutzungen','varchar','','','1','90','Text','','Nutzungsart','','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_id7231,'flaeche','flaeche','alb_nutzungen','alb_nutzungen','int4','','','1',NULL,'Text','','Fläche [m²]','','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_id7231,'flurstkennz','flurstkennz','alb_nutzungen','alb_nutzungen','varchar','','','1','23','Text','','FST-Kennzeichen','','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_id7231,'nutzungsart','nutzungsart','alb_nutzungen','alb_nutzungen','bpchar','','','1',NULL,'Text','','Nutzungsartenschlüssel','','1');
 
 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`) VALUES('Buchdaten - Verfahren','5',@group_id,'SELECT flurstkennz, substring(flurstkennz from 1 for 6) as gemarkung, trim(leading \'0\' from substring(flurstkennz from 8 for 3)) as flur, trim(leading \'0\' from substring(flurstkennz from 12 for 5)) as zaehler, trim(leading \'0\' from substring(flurstkennz from 18 for 3)) as nenner, ausfstellenr, ausfstellename, verfnr, verfbez FROM alb_verfahren WHERE (1=1)','','','','','','','','500002','100','',@connection,'','6','id','id','15','pixels','2398','','1',NULL,NULL,'-1','-1','','EPSG:2398','Buchdaten FST-Lage','1.1.0','image/png','60','','','','','0','');
 SET @last_layer_id7248=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_id7248,'ausfstellename','ausfstellename','alb_verfahren','alb_verfahren','text','','','1',NULL,'Auswahlfeld','select name as value, substring(name from 1 for 50)||\' ...\' as output from alb_v_ausfuehrendestellen order by name','Ausführende Stelle','','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_id7248,'ausfstellenr','ausfstellenr','alb_verfahren','alb_verfahren','varchar','','','1','5','Auswahlfeld','select ausfstelle as value, ausfstelle as output from alb_v_ausfuehrendestellen order by ausfstelle','Nr. ausführende Stelle','','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_id7248,'flur','flur','','','text','','',NULL,NULL,'Text','','Flur','','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_id7248,'flurstkennz','flurstkennz','alb_verfahren','alb_verfahren','varchar','','','1','23','Text','','FST-Kennzeichen','','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_id7248,'gemarkung','gemarkung','','','text','','',NULL,NULL,'Text','','Gemarkung','','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_id7248,'nenner','nenner','','','text','','',NULL,NULL,'Text','','FST Nenner','','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_id7248,'verfbez','verfbez','alb_verfahren','alb_verfahren','text','','','1',NULL,'Auswahlfeld','select bezeichnung as value, bezeichnung || \' (\' || verfbem || \')\' as output from alb_v_bemerkgzumverfahren order by bezeichnung','Verfahrensbezeichnung','','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_id7248,'verfnr','verfnr','alb_verfahren','alb_verfahren','varchar','','','1','6','Text','','Verfahrensnummer','','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_id7248,'zaehler','zaehler','','','text','','',NULL,NULL,'Text','','FST Zähler','','3');
 
 UPDATE layer_attributes SET options = REPLACE(options, '7233', @last_layer_id7233) WHERE layer_id IN(@last_layer_id7233,@last_layer_id7235,@last_layer_id7216,@last_layer_id7229,@last_layer_id7232,@last_layer_id7234,@last_layer_id7230,@last_layer_id7228,@last_layer_id7231,@last_layer_id7248) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
 UPDATE layer_attributes SET options = REPLACE(options, '7235', @last_layer_id7235) WHERE layer_id IN(@last_layer_id7233,@last_layer_id7235,@last_layer_id7216,@last_layer_id7229,@last_layer_id7232,@last_layer_id7234,@last_layer_id7230,@last_layer_id7228,@last_layer_id7231,@last_layer_id7248) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
 UPDATE layer_attributes SET options = REPLACE(options, '7216', @last_layer_id7216) WHERE layer_id IN(@last_layer_id7233,@last_layer_id7235,@last_layer_id7216,@last_layer_id7229,@last_layer_id7232,@last_layer_id7234,@last_layer_id7230,@last_layer_id7228,@last_layer_id7231,@last_layer_id7248) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
 UPDATE layer_attributes SET options = REPLACE(options, '7229', @last_layer_id7229) WHERE layer_id IN(@last_layer_id7233,@last_layer_id7235,@last_layer_id7216,@last_layer_id7229,@last_layer_id7232,@last_layer_id7234,@last_layer_id7230,@last_layer_id7228,@last_layer_id7231,@last_layer_id7248) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
 UPDATE layer_attributes SET options = REPLACE(options, '7232', @last_layer_id7232) WHERE layer_id IN(@last_layer_id7233,@last_layer_id7235,@last_layer_id7216,@last_layer_id7229,@last_layer_id7232,@last_layer_id7234,@last_layer_id7230,@last_layer_id7228,@last_layer_id7231,@last_layer_id7248) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
 UPDATE layer_attributes SET options = REPLACE(options, '7234', @last_layer_id7234) WHERE layer_id IN(@last_layer_id7233,@last_layer_id7235,@last_layer_id7216,@last_layer_id7229,@last_layer_id7232,@last_layer_id7234,@last_layer_id7230,@last_layer_id7228,@last_layer_id7231,@last_layer_id7248) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
 UPDATE layer_attributes SET options = REPLACE(options, '7230', @last_layer_id7230) WHERE layer_id IN(@last_layer_id7233,@last_layer_id7235,@last_layer_id7216,@last_layer_id7229,@last_layer_id7232,@last_layer_id7234,@last_layer_id7230,@last_layer_id7228,@last_layer_id7231,@last_layer_id7248) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
 UPDATE layer_attributes SET options = REPLACE(options, '7228', @last_layer_id7228) WHERE layer_id IN(@last_layer_id7233,@last_layer_id7235,@last_layer_id7216,@last_layer_id7229,@last_layer_id7232,@last_layer_id7234,@last_layer_id7230,@last_layer_id7228,@last_layer_id7231,@last_layer_id7248) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
 UPDATE layer_attributes SET options = REPLACE(options, '7231', @last_layer_id7231) WHERE layer_id IN(@last_layer_id7233,@last_layer_id7235,@last_layer_id7216,@last_layer_id7229,@last_layer_id7232,@last_layer_id7234,@last_layer_id7230,@last_layer_id7228,@last_layer_id7231,@last_layer_id7248) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
 UPDATE layer_attributes SET options = REPLACE(options, '7248', @last_layer_id7248) WHERE layer_id IN(@last_layer_id7233,@last_layer_id7235,@last_layer_id7216,@last_layer_id7229,@last_layer_id7232,@last_layer_id7234,@last_layer_id7230,@last_layer_id7228,@last_layer_id7231,@last_layer_id7248) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');