Gruppen und Themen für ALKIS
Aus kvwmap
Version vom 17. September 2014, 11:39 Uhr von Wirsi (Diskussion | Beiträge)
Inhaltsverzeichnis
- 1 Wichtige Hinweise
- 2 ALKIS-Basisthemen
- 3 andere Themen mit ALKIS-Bezug
Wichtige Hinweise
Die ALKIS-Komponenten von kvwmap basieren auf dem NAS-Datenbank-Schema von NorBIT. Verknüpfungen zwischen Objekttabellen in Abfragen müssen über die Beziehungsfelder in den Objekttabellen erfolgen, nicht über die Tabelle alkis_beziehungen.
kvwmap unterstützt außerdem die Vollhistorisierung der NAS-Daten, weshalb alle Abfragen mit einem zeitlichen Filter versehen werden müssen. In den SQL-Abfragen "data" und "query" der Layerdefinitionen kann das Schlüsselwort $hist_timestamp verwendet werden. $hist_timestamp wird von kvwmap zur Laufzeit durch den vom Nutzer frei einstellbaren Zeitpunkt ersetzt. Für einen simplen Flurstückslayer sehen "query" und "data" folgendermaßen aus:
query:
SELECT * FROM ax_flurstueck WHERE CASE WHEN '$hist_timestamp' = '' THEN endet IS NULL ELSE beginnt <= '$hist_timestamp' and ('$hist_timestamp' <= endet or endet IS NULL) END
data:
wkb_geometry from (select wkb_geometry, ogc_fid from alkis.ax_flurstueck where CASE WHEN '$hist_timestamp' = '' THEN endet IS NULL ELSE beginnt <= '$hist_timestamp' and ('$hist_timestamp' <= endet or endet IS NULL) END) as foo using unique ogc_fid using srid=25833
ALKIS-Basisthemen
Angaben zum Flurstück
LUP
Flurstück
SET @group_id = 1;
SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';
INSERT INTO layer (`Name`,`alias`,`Datentyp`,`Gruppe`,`pfad`,`maintable`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`epsg_code`,`template`,`queryable`,`transparency`,`drawingorder`,`minscale`,`maxscale`,`offsite`,`ows_srs`,`wms_name`,`wms_server_version`,`wms_format`,`wms_connectiontimeout`,`wms_auth_username`,`wms_auth_password`,`wfs_geom`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`,`metalink`,`privileg`) VALUES('Flurstuecke','','2',@group_id,'SELECT wkb_geometry, f.flurstueckskennzeichen as flurstkennz, \'\' as flurnr, \'\' AS entsteh, \'\' AS letzff, \'\' AS status, \'\' AS flaeche, \'\' AS karte, \'\' AS kreisid, \'\' AS kreisname, \'\' as gemkgschl, \'\' AS gemkgname, \'\' AS gemeinde, \'\' AS gemeindename,\'\' AS finanzamt,\'\' AS finanzamtname, \'\' AS forstschluessel, \'\' AS forstname, \'\' AS lagebezeichnung, \'\' AS nutzung, \'\' AS ausfstelle,\'\' AS verfahren, \'\' AS vorgaenger, \'\' AS nachfolger, \'\' AS bestandsnr,\'\' AS eigentuemer, \'\' AS freitext, \'\' AS hinweis,\'\' AS baulasten, \'\' AS amtsgerichtname, \'\' AS amtsgerichtnr,\'\' AS grundbuchbezirkname, \'\' AS grundbuchbezirkschl, \'\' AS klassifizierung FROM ax_flurstueck AS f WHERE 1=1','ax_flurstueck','the_geom from (select wkb_geometry as the_geom, ogc_fid from alkis.ax_flurstueck) as foo using unique ogc_fid using srid=25833','alkis','','','','','',NULL,NULL,'',@connection,'','6','ogc_fid','ogc_fid','3','pixels','25833','Flurstuecke_customALKIS.php','1',NULL,'1000',NULL,NULL,'','EPSG:25833','ALK-Flurstücke','1.1.0','image/png','60','','','','','1','0','','','','','0');
SET @last_layer_id582=LAST_INSERT_ID();
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('alle',@last_layer_id582,'','0','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','1','-1 -1 -1',' ','0 0 0',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'');
SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
Flurstücksnummer
mit Zuordnungspfeilen
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`,`metalink`,`privileg`) VALUES('ALKIS (Flurstnr)','3',@group_id,'','','','','','','','',NULL,NULL,'','http://localhost/cgi-bin/mapserv?map=/home/fgs/fgs/www/wms/alkis/alkis-07.map&service=wms&VERSION=1.1.1&REQUEST=GetMap&TRANSPARENT=true&FORMAT=image/png&LAYERS=ag_t_flurstueck,ag_l_flurstueck,sk2004_zuordnungspfeil_spitze,ag_p_flurstueck&','','7','','','3','pixels','25833','','0','65','30000994','1','10000','','EPSG:25833','','1.1.1','image/png','60','','','','','0','0','','ALKIS - Test (WMS)','Vermessungs- und Geoinformationsbehörde LWL-PCH','','0');
SET @last_layer_id1260=LAST_INSERT_ID();
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('',@last_layer_id1260,'','1','');
SET @last_class_id=LAST_INSERT_ID();
UPDATE layer_attributes SET options = REPLACE(options, '1260', @last_layer_id1260) WHERE layer_id IN(@last_layer_id1260) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
Grenzpunkt
SET @group_id = 1;
SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';
INSERT INTO layer (`Name`,`alias`,`Datentyp`,`Gruppe`,`pfad`,`maintable`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`epsg_code`,`template`,`queryable`,`transparency`,`drawingorder`,`minscale`,`maxscale`,`offsite`,`ows_srs`,`wms_name`,`wms_server_version`,`wms_format`,`wms_connectiontimeout`,`wms_auth_username`,`wms_auth_password`,`wfs_geom`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`,`metalink`,`privileg`) VALUES('Alkis Grenzpunkte','','0',@group_id,'select * from lk_grenzpunkte where 1 = 1','lk_grenzpunkte','the_geom from (select oid, gml_id, ax_datenerhebung_punktort,punktkennung, wkb_geometry as the_geom from alkis.lk_grenzpunkte) as foo using unique oid using srid=25833','alkis','','','','','punktkennung','1000','50','',@connection,'','6','','','3','pixels','25833','','1',NULL,'30000790','1','30005','255 255 255','EPSG:2398','','1.1.0','image/png','60','','','','','0','0','','Qualität der Grenzpunkte','Vermessungs- und Geoinformationsbehörde LWL-PCH','','0');
SET @last_layer_id1145=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`,`privileg`) VALUES(@last_layer_id1145,'abmarkung_marke','abmarkung_marke','lk_grenzpunkte','lk_grenzpunkte','int4','','','1','32','Text','','','','4','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`,`privileg`) VALUES(@last_layer_id1145,'ax_datenerhebung_punktort','ax_datenerhebung_punktort','lk_grenzpunkte','lk_grenzpunkte','int4','','','1','32','Text','','','','6','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`,`privileg`) VALUES(@last_layer_id1145,'bemerkungzurabmarkung','bemerkungzurabmarkung','lk_grenzpunkte','lk_grenzpunkte','int4','','','1','32','Text','','','','10','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`,`privileg`) VALUES(@last_layer_id1145,'bem_bedeutung','bem_bedeutung','lk_grenzpunkte','lk_grenzpunkte','varchar','','','1','100','Text','','','','11','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`,`privileg`) VALUES(@last_layer_id1145,'bezeichner','bezeichner','lk_grenzpunkte','lk_grenzpunkte','varchar','','','1',NULL,'Text','','','','7','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`,`privileg`) VALUES(@last_layer_id1145,'bezeichner2','bezeichner2','lk_grenzpunkte','lk_grenzpunkte','varchar','','','1',NULL,'Text','','','','8','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`,`privileg`) VALUES(@last_layer_id1145,'genauigkeitsstufe','genauigkeitsstufe','lk_grenzpunkte','lk_grenzpunkte','int4','','','1','32','Text','','','','12','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`,`privileg`) VALUES(@last_layer_id1145,'gml_id','gml_id','lk_grenzpunkte','lk_grenzpunkte','bpchar','','','1','16','Text','','','','1','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`,`privileg`) VALUES(@last_layer_id1145,'koord','koord','lk_grenzpunkte','lk_grenzpunkte','text','','','1',NULL,'Text','','','','16','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`,`privileg`) VALUES(@last_layer_id1145,'oid','oid','lk_grenzpunkte','lk_grenzpunkte','oid','','','1',NULL,'Text','','','','0','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`,`privileg`) VALUES(@last_layer_id1145,'punktgenauigkeit','punktgenauigkeit','lk_grenzpunkte','lk_grenzpunkte','varchar','','','1','50','Text','','Punktgenauigkeit','','13','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`,`privileg`) VALUES(@last_layer_id1145,'punktkennung','punktkennung','lk_grenzpunkte','lk_grenzpunkte','varchar','','','1',NULL,'Text','','Pkt. Nummer','','2','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`,`privileg`) VALUES(@last_layer_id1145,'punktvertrauenswuerdigkeit','punktvertrauenswuerdigkeit','lk_grenzpunkte','lk_grenzpunkte','varchar','','','1','200','Text','','Punktzuverlässigkeit','','15','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`,`privileg`) VALUES(@last_layer_id1145,'sonstigeeigenschaft','sonstigeeigenschaft','lk_grenzpunkte','lk_grenzpunkte','_varchar','','','1',NULL,'Text','','','','3','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`,`privileg`) VALUES(@last_layer_id1145,'verm_bedeutung','verm_bedeutung','lk_grenzpunkte','lk_grenzpunkte','varchar','','','1','100','Text','','Vermarkung','','5','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`,`privileg`) VALUES(@last_layer_id1145,'vertrauenswuerdigkeit','vertrauenswuerdigkeit','lk_grenzpunkte','lk_grenzpunkte','int4','','','1','32','Text','','','','14','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`,`privileg`) VALUES(@last_layer_id1145,'wkb_geometry','wkb_geometry','lk_grenzpunkte','lk_grenzpunkte','geometry','POINT','','1',NULL,'Geometrie','','','','9','0');
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('GP berechnet',@last_layer_id1145,'(\'[ax_datenerhebung_punktort]\'<\'1801\')','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('25','','30','0 255 0','','0 255 0','7','8','','',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,'8 16 0','255 255 255','',NULL,NULL,'255 255 255','',NULL,NULL,'7','7','12','6',NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1',NULL,NULL);
SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('GP digitalisiert',@last_layer_id1145,'(\'[ax_datenerhebung_punktort]\'>\'1899\')','2','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES('25','','30','227 70 0','','227 70 0','7','8','','',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);
UPDATE layer_attributes SET options = REPLACE(options, '1145', @last_layer_id1145) WHERE layer_id IN(@last_layer_id1145) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
besondere Flurstücksgrenze
Strittige Grenze
SET @group_id = 1;
SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';
INSERT INTO layer (`Name`,`alias`,`Datentyp`,`Gruppe`,`pfad`,`maintable`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`epsg_code`,`template`,`queryable`,`transparency`,`drawingorder`,`minscale`,`maxscale`,`offsite`,`ows_srs`,`wms_name`,`wms_server_version`,`wms_format`,`wms_connectiontimeout`,`wms_auth_username`,`wms_auth_password`,`wfs_geom`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`,`metalink`,`privileg`) VALUES('Alkis strittige Grenze','','1',@group_id,'','ax_besondereflurstuecksgrenze','the_geom from (SELECT ogc_fid as oid, gml_id, identifier, beginnt, endet, advstandardmodell,
anlass, artderflurstuecksgrenze, wkb_geometry as the_geom
FROM alkis.ax_besondereflurstuecksgrenze fg
WHERE (1000 = ANY (fg.artderflurstuecksgrenze)) AND fg.advstandardmodell::text ~~ \'DLKM\'::text)
as foo using unique oid using srid=25833','alkis','','','','','','2000','1','',@connection,'','6','','','3','pixels','25833','','0','100','20250994','1','200010','','EPSG:25833','','1.1.0','image/png','60','','','','','1','0','','Strittige Grenzen im Landkreis Ludwigslust-Parchim','Vermessungs- und Geoinformationsbehörde LWL-PCH','','0');
SET @last_layer_id11424=LAST_INSERT_ID();
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('strittige Grenze',@last_layer_id11424,'','0','');
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('25','','3','64 0 181','','0 51 0','7','15','','',NULL,NULL,NULL,NULL,'');
SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO 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,'0 0 0','255 204 51','',NULL,NULL,'255 204 51','',NULL,NULL,'11','11','24',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1','35',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, '11424', @last_layer_id11424) WHERE layer_id IN(@last_layer_id11424) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
Angaben zum Netzpunkt
LUP
Aufnahmepunkt
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`,`metalink`,`privileg`) VALUES('Alkis AP','0',@group_id,'select * from lk_ap where 1 = 1','the_geom from (select oid, punktkennung, wkb_geometry as the_geom from alkis.lk_ap) as foo using unique oid using srid=25833','alkis','','','','','punktkennung','1000','50','',@connection,'','6','','','3','pixels','25833','','1',NULL,'30000786','0','25001','255 255 255','EPSG:2398','','1.1.0','image/png','60','','','','','0','0','','Qualität der Grenz- und Gebäudepunkte. Ableitung aus der ALK.','Vermessungs- und Geoinformationsbehörde LWL-PCH','','0');
SET @last_layer_id1147=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`,`privileg`) VALUES(@last_layer_id1147,'bedeutung','bedeutung','lk_ap','lk_ap','varchar','','','1','200','Text','','','','8','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`,`privileg`) VALUES(@last_layer_id1147,'bemerkung','bemerkung','lk_ap','lk_ap','varchar','','','1','200','Text','','','','9','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`,`privileg`) VALUES(@last_layer_id1147,'genauigkeitsstufe','genauigkeitsstufe','lk_ap','lk_ap','int4','','','1','32','Text','','','','5','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`,`privileg`) VALUES(@last_layer_id1147,'koord','koord','lk_ap','lk_ap','text','','','1',NULL,'Text','','','','11','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`,`privileg`) VALUES(@last_layer_id1147,'oid','oid','lk_ap','lk_ap','oid','','','1',NULL,'Text','','','','0','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`,`privileg`) VALUES(@last_layer_id1147,'punktgenauigkeit','punktgenauigkeit','lk_ap','lk_ap','varchar','','','1','50','Text','','','','6','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`,`privileg`) VALUES(@last_layer_id1147,'punktkennung','punktkennung','lk_ap','lk_ap','varchar','','','1',NULL,'Text','','','','1','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`,`privileg`) VALUES(@last_layer_id1147,'sonstigeeigenschaft','sonstigeeigenschaft','lk_ap','lk_ap','_varchar','','','1',NULL,'Text','','','','2','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`,`privileg`) VALUES(@last_layer_id1147,'vermarkung_marke','vermarkung_marke','lk_ap','lk_ap','int4','','','1','32','Text','','','','3','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`,`privileg`) VALUES(@last_layer_id1147,'verm_bedeutung','verm_bedeutung','lk_ap','lk_ap','varchar','','','1','100','Text','','','','4','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`,`privileg`) VALUES(@last_layer_id1147,'vertrauenswuerdigkeit','vertrauenswuerdigkeit','lk_ap','lk_ap','int4','','','1','32','Text','','','','7','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`,`privileg`) VALUES(@last_layer_id1147,'wkb_geometry','wkb_geometry','lk_ap','lk_ap','geometry','POINT','','1',NULL,'Text','','','','10','0');
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('AP',@last_layer_id1147,'','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('34','','30','93 0 149','','0 255 0','7','8',NULL,'',NULL,NULL,NULL,NULL,'');
SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO 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,'8 16 0','255 255 255','',NULL,NULL,'255 255 255','',NULL,NULL,'7','7','12','6',NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1',NULL,NULL);
SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);
UPDATE layer_attributes SET options = REPLACE(options, '1147', @last_layer_id1147) WHERE layer_id IN(@last_layer_id1147) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
Sicherungspunkt
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`,`metalink`,`privileg`) VALUES('Alkis SP','0',@group_id,'select * from lk_sp where 1 = 1','the_geom from (select oid, punktkennung, wkb_geometry as the_geom from alkis.lk_sp) as foo using unique oid using srid=25833','alkis','','','','','punktkennung','1000','50','',@connection,'','6','','','3','pixels','25833','','1',NULL,'30000784','1','25001','255 255 255','EPSG:2398','','1.1.0','image/png','60','','','','','0','0','','Qualität der Grenz- und Gebäudepunkte. Ableitung aus der ALK.','Vermessungs- und Geoinformationsbehörde LWL-PCH','','0');
SET @last_layer_id1148=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`,`privileg`) VALUES(@last_layer_id1148,'bedeutung','bedeutung','lk_sp','lk_sp','varchar','','','1','200','Text','','','','8','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`,`privileg`) VALUES(@last_layer_id1148,'bemerkung','bemerkung','lk_sp','lk_sp','varchar','','','1','200','Text','','','','9','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`,`privileg`) VALUES(@last_layer_id1148,'genauigkeitsstufe','genauigkeitsstufe','lk_sp','lk_sp','int4','','','1','32','Text','','','','5','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`,`privileg`) VALUES(@last_layer_id1148,'koord','koord','lk_sp','lk_sp','text','','','1',NULL,'Text','','','','11','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`,`privileg`) VALUES(@last_layer_id1148,'oid','oid','lk_sp','lk_sp','oid','','','1',NULL,'Text','','','','0','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`,`privileg`) VALUES(@last_layer_id1148,'punktgenauigkeit','punktgenauigkeit','lk_sp','lk_sp','varchar','','','1','50','Text','','','','6','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`,`privileg`) VALUES(@last_layer_id1148,'punktkennung','punktkennung','lk_sp','lk_sp','varchar','','','1',NULL,'Text','','','','1','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`,`privileg`) VALUES(@last_layer_id1148,'sonstigeeigenschaft','sonstigeeigenschaft','lk_sp','lk_sp','varchar','','','1',NULL,'Text','','','','2','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`,`privileg`) VALUES(@last_layer_id1148,'vermarkung_marke','vermarkung_marke','lk_sp','lk_sp','int4','','','1','32','Text','','','','3','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`,`privileg`) VALUES(@last_layer_id1148,'verm_bedeutung','verm_bedeutung','lk_sp','lk_sp','varchar','','','1','100','Text','','','','4','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`,`privileg`) VALUES(@last_layer_id1148,'vertrauenswuerdigkeit','vertrauenswuerdigkeit','lk_sp','lk_sp','int4','','','1','32','Text','','','','7','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`,`privileg`) VALUES(@last_layer_id1148,'wkb_geometry','wkb_geometry','lk_sp','lk_sp','geometry','POINT','','1',NULL,'Text','','','','10','0');
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('SP',@last_layer_id1148,'','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('35','','30','164 152 255','','0 255 0','7','8',NULL,'',NULL,NULL,NULL,NULL,'');
SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO 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,'8 16 0','255 255 255','',NULL,NULL,'255 255 255','',NULL,NULL,'7','7','12','6',NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1',NULL,NULL);
SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);
UPDATE layer_attributes SET options = REPLACE(options, '1148', @last_layer_id1148) WHERE layer_id IN(@last_layer_id1148) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
sonst. Vermessungspunkt
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`,`metalink`,`privileg`) VALUES('Alkis sonstiger Verm_PKT','0',@group_id,'select * from lk_so_punkte where 1 = 1','the_geom from (select oid, punktkennung, wkb_geometry as the_geom from alkis.lk_so_punkte) as foo using unique oid using srid=25833','alkis','','','','','punktkennung','1000','50','',@connection,'','6','','','3','pixels','25833','','1',NULL,'30000782','1','25001','255 255 255','EPSG:2398','','1.1.0','image/png','60','','','','','0','0','','Qualität der Grenz- und Gebäudepunkte. Ableitung aus der ALK.','Vermessungs- und Geoinformationsbehörde LWL-PCH','','0');
SET @last_layer_id1149=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`,`privileg`) VALUES(@last_layer_id1149,'bedeutung','bedeutung','lk_so_punkte','lk_so_punkte','varchar','','','1','200','Text','','','','8','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`,`privileg`) VALUES(@last_layer_id1149,'bemerkung','bemerkung','lk_so_punkte','lk_so_punkte','varchar','','','1','200','Text','','','','9','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`,`privileg`) VALUES(@last_layer_id1149,'genauigkeitsstufe','genauigkeitsstufe','lk_so_punkte','lk_so_punkte','int4','','','1','32','Text','','','','5','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`,`privileg`) VALUES(@last_layer_id1149,'koord','koord','lk_so_punkte','lk_so_punkte','text','','','1',NULL,'Text','','','','11','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`,`privileg`) VALUES(@last_layer_id1149,'oid','oid','lk_so_punkte','lk_so_punkte','oid','','','1',NULL,'Text','','','','0','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`,`privileg`) VALUES(@last_layer_id1149,'punktgenauigkeit','punktgenauigkeit','lk_so_punkte','lk_so_punkte','varchar','','','1','50','Text','','','','6','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`,`privileg`) VALUES(@last_layer_id1149,'punktkennung','punktkennung','lk_so_punkte','lk_so_punkte','varchar','','','1',NULL,'Text','','','','1','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`,`privileg`) VALUES(@last_layer_id1149,'sonstigeeigenschaft','sonstigeeigenschaft','lk_so_punkte','lk_so_punkte','_varchar','','','1',NULL,'Text','','','','2','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`,`privileg`) VALUES(@last_layer_id1149,'vermarkung_marke','vermarkung_marke','lk_so_punkte','lk_so_punkte','int4','','','1','32','Text','','','','3','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`,`privileg`) VALUES(@last_layer_id1149,'verm_bedeutung','verm_bedeutung','lk_so_punkte','lk_so_punkte','varchar','','','1','100','Text','','','','4','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`,`privileg`) VALUES(@last_layer_id1149,'vertrauenswuerdigkeit','vertrauenswuerdigkeit','lk_so_punkte','lk_so_punkte','int4','','','1','32','Text','','','','7','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`,`privileg`) VALUES(@last_layer_id1149,'wkb_geometry','wkb_geometry','lk_so_punkte','lk_so_punkte','geometry','POINT','','1',NULL,'Text','','','','10','0');
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('sonst.PKT',@last_layer_id1149,'','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('25','','30','255 0 0','','0 255 0','7','8',NULL,'',NULL,NULL,NULL,NULL,'');
SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO 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,'8 16 0','255 255 255','',NULL,NULL,'255 255 255','',NULL,NULL,'7','7','12','6',NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1',NULL,NULL);
SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);
UPDATE layer_attributes SET options = REPLACE(options, '1149', @last_layer_id1149) WHERE layer_id IN(@last_layer_id1149) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
Gebäude
LUP
Gebäude
SET @group_id = 1;
SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';
INSERT INTO layer (`Name`,`alias`,`Datentyp`,`Gruppe`,`pfad`,`maintable`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`epsg_code`,`template`,`queryable`,`transparency`,`drawingorder`,`minscale`,`maxscale`,`offsite`,`ows_srs`,`wms_name`,`wms_server_version`,`wms_format`,`wms_connectiontimeout`,`wms_auth_username`,`wms_auth_password`,`wfs_geom`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`,`metalink`,`privileg`) VALUES('Alkis Gebäude','','2',@group_id,'SELECT * FROM lk_gebaeude WHERE 1=1','lk_gebaeude','the_geom from (select ogc_fid as oid, wkb_geometry as the_geom from alkis.lk_gebaeude) as foo using unique oid using srid=25833','alkis','','','','','',NULL,NULL,'',@connection,'','6','','','3','pixels','25833','','1',NULL,'30000765','1','100000','','EPSG:25833','','1.1.0','image/png','60','','','','','1','0','','Gebäude in ALKIS','Vermessungs- und Geoinformationsbehörde LWL-PCH','','0');
SET @last_layer_id1152=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`,`privileg`) VALUES(@last_layer_id1152,'ax_datenerhebung','ax_datenerhebung','lk_gebaeude','lk_gebaeude','int4','','','1','32','Text','','','','15','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`,`privileg`) VALUES(@last_layer_id1152,'bezeichner','bezeichner','lk_gebaeude','lk_gebaeude','varchar','','','1',NULL,'Text','','','','4','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`,`privileg`) VALUES(@last_layer_id1152,'dachform','dachform','lk_gebaeude','lk_gebaeude','int4','','','1','32','Text','','','','12','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`,`privileg`) VALUES(@last_layer_id1152,'dach_bezeichner','dach_bezeichner','lk_gebaeude','lk_gebaeude','varchar','','','1',NULL,'Text','','','','13','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`,`privileg`) VALUES(@last_layer_id1152,'gebaeudefunktion','gebaeudefunktion','lk_gebaeude','lk_gebaeude','int4','','','1','32','Text','','','','3','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`,`privileg`) VALUES(@last_layer_id1152,'gebaeudezustand','gebaeudezustand','lk_gebaeude','lk_gebaeude','varchar','','','1',NULL,'Text','','','','9','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`,`privileg`) VALUES(@last_layer_id1152,'gml_id','gml_id','lk_gebaeude','lk_gebaeude','bpchar','','','1','16','Text','','','','2','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`,`privileg`) VALUES(@last_layer_id1152,'herkunft','herkunft','lk_gebaeude','lk_gebaeude','varchar','','','1',NULL,'Text','','','','16','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`,`privileg`) VALUES(@last_layer_id1152,'hochhaus','hochhaus','lk_gebaeude','lk_gebaeude','varchar','','','1',NULL,'Text','','','','14','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`,`privileg`) VALUES(@last_layer_id1152,'lagezurerdoberflaeche','lagezurerdoberflaeche','lk_gebaeude','lk_gebaeude','int4','','','1','32','Text','','','','11','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`,`privileg`) VALUES(@last_layer_id1152,'name','name','lk_gebaeude','lk_gebaeude','_varchar','','','1',NULL,'Text','','','','5','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`,`privileg`) VALUES(@last_layer_id1152,'objekthoehe','objekthoehe','lk_gebaeude','lk_gebaeude','int4','','','1','32','Text','','','','10','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`,`privileg`) VALUES(@last_layer_id1152,'ogc_fid','ogc_fid','lk_gebaeude','lk_gebaeude','int4','','','1','32','Text','','','','1','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`,`privileg`) VALUES(@last_layer_id1152,'oid','oid','lk_gebaeude','lk_gebaeude','oid','','','1',NULL,'Text','','','','0','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`,`privileg`) VALUES(@last_layer_id1152,'weiterefunktion_bezeich','weiterefunktion_bezeich','lk_gebaeude','lk_gebaeude','varchar','','','1',NULL,'Text','','','','7','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`,`privileg`) VALUES(@last_layer_id1152,'weiterefunktion_wert','weiterefunktion_wert','lk_gebaeude','lk_gebaeude','int4','','','1','32','Text','','','','6','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`,`privileg`) VALUES(@last_layer_id1152,'wkb_geometry','wkb_geometry','lk_gebaeude','lk_gebaeude','geometry','POLYGON','','1',NULL,'Text','','','','17','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`,`privileg`) VALUES(@last_layer_id1152,'zustand','zustand','lk_gebaeude','lk_gebaeude','int4','','','1','32','Text','','','','8','0');
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('alle',@last_layer_id1152,'','0','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','1','-1 -1 -1',' ','0 0 0',NULL,NULL,'','',NULL,NULL,NULL,NULL,'');
SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO 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,'240 0 19','255 255 255','',NULL,NULL,'255 255 255','',NULL,NULL,'8','6','10',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1',NULL,NULL);
SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);
UPDATE layer_attributes SET options = REPLACE(options, '1152', @last_layer_id1152) WHERE layer_id IN(@last_layer_id1152) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
gebäudebez. Bauwerke
SET @group_id = 1;
SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';
INSERT INTO layer (`Name`,`alias`,`Datentyp`,`Gruppe`,`pfad`,`maintable`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`epsg_code`,`template`,`queryable`,`transparency`,`drawingorder`,`minscale`,`maxscale`,`offsite`,`ows_srs`,`wms_name`,`wms_server_version`,`wms_format`,`wms_connectiontimeout`,`wms_auth_username`,`wms_auth_password`,`wfs_geom`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`,`metalink`,`privileg`) VALUES('Alkis gebäudebez. Bauwerke','','2',@group_id,'SELECT * FROM lk_bes_gebaeude WHERE bauwerksfunktion < 1700','lk_bes_gebaeude','the_geom from (select ogc_fid as oid, bezeichner, bauwerksfunktion, wkb_geometry, wkb_geometry as the_geom from alkis.lk_bes_gebaeude) as foo using unique oid using srid=25833','alkis','','','','','bezeichner','505','1','',@connection,'','6','','','3','pixels','25833','','1',NULL,'30000765','1','100000','','EPSG:25833','','1.1.0','image/png','60','','','','','1','0','','Gebäude in ALKIS','Vermessungs- und Geoinformationsbehörde LWL-PCH','','0');
SET @last_layer_id1274=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`,`privileg`) VALUES(@last_layer_id1274,'bauwerksfunktion','bauwerksfunktion','lk_bes_gebaeude','lk_bes_gebaeude','int4','','','1','32','Text','','','','3','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`,`privileg`) VALUES(@last_layer_id1274,'bezeichner','bezeichner','lk_bes_gebaeude','lk_bes_gebaeude','varchar','','','1',NULL,'Text','','','','4','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`,`privileg`) VALUES(@last_layer_id1274,'gml_id','gml_id','lk_bes_gebaeude','lk_bes_gebaeude','bpchar','','','1','16','Text','','','','2','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`,`privileg`) VALUES(@last_layer_id1274,'ogc_fid','ogc_fid','lk_bes_gebaeude','lk_bes_gebaeude','int4','','','1','32','Text','','','','1','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`,`privileg`) VALUES(@last_layer_id1274,'oid','oid','lk_bes_gebaeude','lk_bes_gebaeude','oid','','','1',NULL,'Text','','','','0','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`,`privileg`) VALUES(@last_layer_id1274,'wkb_geometry','wkb_geometry','lk_bes_gebaeude','lk_bes_gebaeude','geometry','POLYGON','','1',NULL,'Text','','','','5','0');
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('alle',@last_layer_id1274,'(\'[bauwerksfunktion]\'<\'1700\')','0','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','2','-1 -1 -1',' ','23 0 108','2','2','','',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,'240 0 19','255 255 255','',NULL,NULL,'255 255 255','',NULL,NULL,'4','4','6',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1',NULL,NULL);
SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);
UPDATE layer_attributes SET options = REPLACE(options, '1274', @last_layer_id1274) WHERE layer_id IN(@last_layer_id1274) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
Bauwerke
LRO
flächenförmige Bauwerke
linienförmige Bauwerke
punktförmige Bauwerke
Tatsächliche Nutzung
LRO
Nutzung gesamt
Siedlung
Verkehr
Vegetation
Gewässer
Relief
MSE
flächenförmige Reliefformen
Böschungen
SET @group_id = 1; SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp'; INSERT INTO layer (`Name`,`alias`,`Datentyp`,`Gruppe`,`pfad`,`maintable`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`epsg_code`,`template`,`queryable`,`transparency`,`drawingorder`,`minscale`,`maxscale`,`offsite`,`ows_srs`,`wms_name`,`wms_server_version`,`wms_format`,`wms_connectiontimeout`,`wms_auth_username`,`wms_auth_password`,`wfs_geom`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`,`metalink`,`privileg`) VALUES('Böschung_ALKIS','','2',@group_id,'SELECT * FROM ax_boeschungsflaeche WHERE endet IS NULL','ax_boeschungsflaeche','the_geom from (select ogc_fid as oid, wkb_geometry as the_geom from alkis.ax_boeschungsflaeche WHERE endet IS NULL) as foo using unique oid using srid=25833','alkis','','','','','',NULL,NULL,'',@connection,'','6','','','3','pixels','25833','','1','80','19000','1','100000','','EPSG:25833','','1.1.0','image/png','60','','','','','1','0','','Böschungen in ALKIS','Vermessungs- und Geoinformationsbehörde im LK MSE','','0');
SET @last_layer_id29100=LAST_INSERT_ID();
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Böschung',@last_layer_id29100,'','0','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','1','-1 -1 -1','','0 255 10',NULL,NULL,'0','',NULL,NULL,NULL,NULL,'');
SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
Damm Wall Deich
Wenn die Spalten art und Name in der Tabelle ax_dammwalldeich mit Werten gefüllt sind, kann die Darstellung noch klassifiziert bzw. gelabelt werden.
SET @group_id = 1; SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';
INSERT INTO layer (`Name`,`alias`,`Datentyp`,`Gruppe`,`pfad`,`maintable`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`epsg_code`,`template`,`queryable`,`transparency`,`drawingorder`,`minscale`,`maxscale`,`offsite`,`ows_srs`,`wms_name`,`wms_server_version`,`wms_format`,`wms_connectiontimeout`,`wms_auth_username`,`wms_auth_password`,`wfs_geom`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`,`metalink`,`privileg`) VALUES('DammWallDeich_ALKIS','','2',@group_id,'SELECT * FROM ax_dammwalldeich WHERE endet IS NULL','ax_dammwalldeich','the_geom from (select ogc_fid as oid, wkb_geometry as the_geom from alkis.ax_dammwalldeich WHERE endet IS NULL) as foo using unique oid using srid=25833','alkis','','','','','',NULL,NULL,'',@connection,'','6','','','3','pixels','25833','','1','80','19000','1','100000','','EPSG:25833','','1.1.0','image/png','60','','','','','1','0','','Damm, Wall oder Deich in ALKIS','Vermessungs- und Geoinformationsbehörde im LK MSE','','0');
SET @last_layer_id29110=LAST_INSERT_ID();
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('DammWallDeich',@last_layer_id29110,'','0','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','15','-1 -1 -1','','255 103 124','1',NULL,'','',NULL,NULL,NULL,NULL,'');
SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0); UPDATE layer_attributes SET options = REPLACE(options, '29110', @last_layer_id29110) WHERE layer_id IN(@last_layer_id29110) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
linienförmige Reliefformen
punktförmige Reliefformen
Festlegungen
MSE
Strassenrecht
SET @group_id = 1; SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';
INSERT INTO layer (`Name`,`alias`,`Datentyp`,`Gruppe`,`pfad`,`maintable`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`epsg_code`,`template`,`queryable`,`transparency`,`drawingorder`,`minscale`,`maxscale`,`offsite`,`ows_srs`,`wms_name`,`wms_server_version`,`wms_format`,`wms_connectiontimeout`,`wms_auth_username`,`wms_auth_password`,`wfs_geom`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`,`metalink`,`privileg`) VALUES('Strassenrecht_ALKIS','','2',@group_id,'SELECT a.ogc_fid as oid,a.gml_id,b.wert,b.bezeichner,a.wkb_geometry as the_geom FROM ax_klassifizierungnachstrassenrecht a,ax_klassifizierungnachstrassenrecht_artdf b WHERE a.artderfestlegung=b.wert AND a.endet IS NULL','ax_klassifizierung nachstrassenrecht','the_geom from (SELECT a.ogc_fid as oid,a.gml_id,b.wert,b.bezeichner,a.wkb_geometry as the_geom FROM alkis.ax_klassifizierungnachstrassenrecht a,alkis.ax_klassifizierungnachstrassenrecht_artdf b WHERE a.artderfestlegung=b.wert AND a.endet IS NULL) as foo using unique oid using srid=25833','alkis','','','','','',NULL,NULL,'',@connection,'','6','','','3','pixels','25833','','1','80','19000','1','100000','','EPSG:25833','','1.1.0','image/png','60','','','','','1','0','','Böschungen in ALKIS','Vermessungs- und Geoinformationsbehörde im LK MSE','','0');
SET @last_layer_id29200=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`,`privileg`) VALUES(@last_layer_id29200,'bezeichner','bezeichner','ax_klassifizierungnachstrassenrecht_artdf','b','varchar','','','1',NULL,'Text','','','','3','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`,`privileg`) VALUES(@last_layer_id29200,'gml_id','gml_id','ax_klassifizierungnachstrassenrecht','a','varchar','','','0',NULL,'Text','','','','1','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`,`privileg`) VALUES(@last_layer_id29200,'oid','ogc_fid','ax_klassifizierungnachstrassenrecht','a','int4','','','1','32','Text','','','','0','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`,`privileg`) VALUES(@last_layer_id29200,'the_geom','wkb_geometry','ax_klassifizierungnachstrassenrecht','a','geometry','GEOMETRY','','1',NULL,'Text','','','','4','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`,`privileg`) VALUES(@last_layer_id29200,'wert','wert','ax_klassifizierungnachstrassenrecht_artdf','b','int4','','','1','32','Text','','','','2','0');
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Bundes- oder Landesstraßengesetz',@last_layer_id29200,'([wert] = 1100)','0','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','1','230 50 50','','',NULL,NULL,'0','',NULL,NULL,NULL,NULL,''); SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Bundesautobahn',@last_layer_id29200,'([wert] = 1110)','0',''); SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','1','170 0 84','','',NULL,NULL,'0','',NULL,NULL,NULL,NULL,''); SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Bundesstraße',@last_layer_id29200,'([wert] = 1120)','0',''); SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','1','255 0 0','','',NULL,NULL,'0','',NULL,NULL,NULL,NULL,''); SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Landes- oder Staatsstraße',@last_layer_id29200,'([wert] = 1130)','0',''); SET @last_class_id=LAST_INSERT_ID(); INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','1','65 199 0','','',NULL,NULL,'0','',NULL,NULL,NULL,NULL,''); SET @last_style_id=LAST_INSERT_ID(); INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0); INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Kreisstraße',@last_layer_id29200,'([wert] = 1140)','0',''); SET @last_class_id=LAST_INSERT_ID(); INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','1','209 0 82','','',NULL,NULL,'0','',NULL,NULL,NULL,NULL,''); SET @last_style_id=LAST_INSERT_ID(); INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0); INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Gemeindestraße',@last_layer_id29200,'([wert] = 1150)','0',''); SET @last_class_id=LAST_INSERT_ID(); INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','1','108 0 65','','',NULL,NULL,'0','',NULL,NULL,NULL,NULL,''); SET @last_style_id=LAST_INSERT_ID(); INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0); INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Ortsstraße',@last_layer_id29200,'([wert] = 1160)','0',''); SET @last_class_id=LAST_INSERT_ID(); INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','1','127 0 239','','',NULL,NULL,'0','',NULL,NULL,NULL,NULL,''); SET @last_style_id=LAST_INSERT_ID(); INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0); INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Gemeindeverbindungsstraße',@last_layer_id29200,'([wert] = 1170)','0',''); SET @last_class_id=LAST_INSERT_ID(); INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','1','108 0 65','','',NULL,NULL,'0','',NULL,NULL,NULL,NULL,''); SET @last_style_id=LAST_INSERT_ID(); INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0); INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('sonst. öff. Straße',@last_layer_id29200,'([wert] = 1180)','0',''); SET @last_class_id=LAST_INSERT_ID(); INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','1','230 50 50','','',NULL,NULL,'0','',NULL,NULL,NULL,NULL,''); SET @last_style_id=LAST_INSERT_ID(); INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0); INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Privatstraße',@last_layer_id29200,'([wert] = 1190)','0',''); SET @last_class_id=LAST_INSERT_ID(); INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','1','255 196 49','','',NULL,NULL,'0','',NULL,NULL,NULL,NULL,''); SET @last_style_id=LAST_INSERT_ID(); INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0); UPDATE layer_attributes SET options = REPLACE(options, '29200', @last_layer_id29200) WHERE layer_id IN(@last_layer_id29200) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
Wasserrecht
Natur-Umwelt-Bodenschutzrecht
Bodenordnungsrecht
Denkmalschutzrecht
Forstrecht
sonstiges Recht
Schutzzone
Bodenschätzung
VR
Bodenschätzung
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`,`metalink`,`privileg`) VALUES('ALKIS_Bodenschätzung','2',@group_id,'select * from ax_bodenschaetzung where 1=1','the_geom from (select a.oid, c.kurz||d.kurz as label, b.kurz,
bodenzahlodergruenlandgrundzahl,ackerzahlodergruenlandzahl, a.wkb_geometry as the_geom
FROM alkis.ax_bodenschaetzung as a, alkis.ax_bodenschaetzung_kulturart as b,
alkis.ax_bodenschaetzung_bodenart as c, alkis.ax_bodenschaetzung_zustandsstufe as d
WHERE a.kulturart=b.wert
AND a.bodenart=c.wert
AND a.zustandsstufeoderbodenstufe = d.wert) as foo using unique oid using srid=25833','alkis','','','','','label','5001','49','',@connection,'','6','','oid','3','pixels','25833','','1','50','94010','49','5001','','EPSG:25833','','1.1.0','image/png','60','','','','','1','0','','Reichsbodenschätzung aus ALKIS','Fachdienst Kataster und Vermessung','','0');
SET @last_layer_id50303347=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`,`privileg`) VALUES(@last_layer_id50303347,'ackerzahlodergruenlandzahl','ackerzahlodergruenlandzahl','ax_bodenschaetzung','ax_bodenschaetzung','int4','','','1','32','Text','','','','12','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`,`privileg`) VALUES(@last_layer_id50303347,'advstandardmodell','advstandardmodell','ax_bodenschaetzung','ax_bodenschaetzung','varchar','','','1',NULL,'Text','','','','5','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`,`privileg`) VALUES(@last_layer_id50303347,'anlass','anlass','ax_bodenschaetzung','ax_bodenschaetzung','varchar','','','1',NULL,'Text','','','','6','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`,`privileg`) VALUES(@last_layer_id50303347,'beginnt','beginnt','ax_bodenschaetzung','ax_bodenschaetzung','bpchar','','','1','20','Text','','','','3','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`,`privileg`) VALUES(@last_layer_id50303347,'bodenart','bodenart','ax_bodenschaetzung','ax_bodenschaetzung','int4','','','1','32','Text','','','','8','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`,`privileg`) VALUES(@last_layer_id50303347,'bodenzahlodergruenlandgrundzahl','bodenzahlodergruenlandgrundzahl','ax_bodenschaetzung','ax_bodenschaetzung','int4','','','1','32','Text','','','','11','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`,`privileg`) VALUES(@last_layer_id50303347,'endet','endet','ax_bodenschaetzung','ax_bodenschaetzung','bpchar','','','1','20','Text','','','','4','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`,`privileg`) VALUES(@last_layer_id50303347,'entstehungsartoderklimastufewasserverhaeltnisse','entstehungsartoderklimastufewasserverhaeltnisse','ax_bodenschaetzung','ax_bodenschaetzung','_int4','','','1',NULL,'Text','','','','10','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`,`privileg`) VALUES(@last_layer_id50303347,'gml_id','gml_id','ax_bodenschaetzung','ax_bodenschaetzung','bpchar','','','1','16','Text','','','','1','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`,`privileg`) VALUES(@last_layer_id50303347,'identifier','identifier','ax_bodenschaetzung','ax_bodenschaetzung','bpchar','','','1','44','Text','','','','2','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`,`privileg`) VALUES(@last_layer_id50303347,'jahreszahl','jahreszahl','ax_bodenschaetzung','ax_bodenschaetzung','int4','','','1','32','Text','','','','14','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`,`privileg`) VALUES(@last_layer_id50303347,'kulturart','kulturart','ax_bodenschaetzung','ax_bodenschaetzung','int4','','','1','32','Text','','','','7','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`,`privileg`) VALUES(@last_layer_id50303347,'ogc_fid','ogc_fid','ax_bodenschaetzung','ax_bodenschaetzung','int4','','PRIMARY KEY','1','32','Text','','','','0','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`,`privileg`) VALUES(@last_layer_id50303347,'sonstigeangaben','sonstigeangaben','ax_bodenschaetzung','ax_bodenschaetzung','_int4','','','1',NULL,'Text','','','','13','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`,`privileg`) VALUES(@last_layer_id50303347,'wkb_geometry','wkb_geometry','ax_bodenschaetzung','ax_bodenschaetzung','geometry','POLYGON','','1',NULL,'Text','','','','15','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`,`privileg`) VALUES(@last_layer_id50303347,'zustandsstufeoderbodenstufe','zustandsstufeoderbodenstufe','ax_bodenschaetzung','ax_bodenschaetzung','int4','','','1','32','Text','','','','9','0');
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Grünland-Acker',@last_layer_id50303347,'(\'[kurz]\' = \'GrA\')','4','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','3','22 154 0','','-1 -1 -1',NULL,NULL,'','',NULL,NULL,NULL,NULL,'');
SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'punkt','4','-1 -1 -1','','0 98 3','4','6','','',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, 1);
INSERT INTO labels (`font`,`type`,`color`,`outlinecolor`,`shadowcolor`,`shadowsizex`,`shadowsizey`,`backgroundcolor`,`backgroundshadowcolor`,`backgroundshadowsizex`,`backgroundshadowsizey`,`size`,`minsize`,`maxsize`,`position`,`offsetx`,`offsety`,`angle`,`autoangle`,`buffer`,`antialias`,`minfeaturesize`,`maxfeaturesize`,`partials`,`wrap`,`the_force`) VALUES('verdana',NULL,'0 59 31','255 255 255','',NULL,NULL,'','',NULL,NULL,'8','6','10',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1','126','1');
SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Ackerland',@last_layer_id50303347,'(\'[kurz]\' = \'A\')','1','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','3','205 116 40','','-1 -1 -1',NULL,NULL,'','',NULL,NULL,NULL,NULL,'');
SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'punkt','4','-1 -1 -1','','0 98 3','4','6','','',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, 1);
INSERT INTO labels (`font`,`type`,`color`,`outlinecolor`,`shadowcolor`,`shadowsizex`,`shadowsizey`,`backgroundcolor`,`backgroundshadowcolor`,`backgroundshadowsizex`,`backgroundshadowsizey`,`size`,`minsize`,`maxsize`,`position`,`offsetx`,`offsety`,`angle`,`autoangle`,`buffer`,`antialias`,`minfeaturesize`,`maxfeaturesize`,`partials`,`wrap`,`the_force`) VALUES('verdana',NULL,'89 39 0','255 255 255','',NULL,NULL,'','',NULL,NULL,'8','6','10',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1','126','1');
SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Grünland',@last_layer_id50303347,'(\'[kurz]\' = \'Gr\')','3','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','3','143 249 44','','-1 -1 -1',NULL,NULL,'','',NULL,NULL,NULL,NULL,'');
SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'punkt','4','-1 -1 -1','','0 98 3','4','6','','',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, 1);
INSERT INTO labels (`font`,`type`,`color`,`outlinecolor`,`shadowcolor`,`shadowsizex`,`shadowsizey`,`backgroundcolor`,`backgroundshadowcolor`,`backgroundshadowsizex`,`backgroundshadowsizey`,`size`,`minsize`,`maxsize`,`position`,`offsetx`,`offsety`,`angle`,`autoangle`,`buffer`,`antialias`,`minfeaturesize`,`maxfeaturesize`,`partials`,`wrap`,`the_force`) VALUES('verdana',NULL,'0 59 31','255 255 255','',NULL,NULL,'','',NULL,NULL,'8','6','10',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1','126','1');
SET @last_label_id=LAST_INSERT_ID();
INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Acker-Grünland',@last_layer_id50303347,'(\'[kurz]\' = \'AGr\')','2','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','3','231 168 0','','-1 -1 -1',NULL,NULL,'','',NULL,NULL,NULL,NULL,'');
SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'punkt','4','-1 -1 -1','','0 98 3','4','6','','',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, 1);
INSERT INTO labels (`font`,`type`,`color`,`outlinecolor`,`shadowcolor`,`shadowsizex`,`shadowsizey`,`backgroundcolor`,`backgroundshadowcolor`,`backgroundshadowsizex`,`backgroundshadowsizey`,`size`,`minsize`,`maxsize`,`position`,`offsetx`,`offsety`,`angle`,`autoangle`,`buffer`,`antialias`,`minfeaturesize`,`maxfeaturesize`,`partials`,`wrap`,`the_force`) VALUES('verdana',NULL,'89 39 0','255 255 255','',NULL,NULL,'','',NULL,NULL,'8','6','10',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'1','126','1');
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, '50303347', @last_layer_id50303347) WHERE layer_id IN(@last_layer_id50303347) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
Musterstück
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`,`metalink`,`privileg`) VALUES('ALKIS_Musterstücke','1',@group_id,'select ogc_fid, gruppe||\' Nr. \'||nummer as bezeichnung, kultur, bezeichner, zustand_bodenstufe, entstehung, bodenzahlodergruenlandgrundzahl, ackerzahlodergruenlandzahl, the_geom from lk_muster_vergleichsstuecke where merkmal < 3000','the_geom FROM (SELECT oid, gruppe||\' Nr. \'||nummer as bezeichnung, merkmal, the_geom FROM alkis.lk_muster_vergleichsstuecke where merkmal < 3000) as foo using unique oid using srid=25833','alkis','','','','','bezeichnung','10001','49','',@connection,'','6','','','3','pixels','25833','','1',NULL,'100000','49','50001','','EPSG:25833','','1.1.0','image/png','60','','','','','1','0','','Musterstücke und Landesmusterstücke der Reichsbodenschätzung aus ALKIS','Fachdienst Kataster und Vermessung','','0');
SET @last_layer_id50303344=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`,`privileg`) VALUES(@last_layer_id50303344,'ackerzahlodergruenlandzahl','ackerzahlodergruenlandzahl','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','int4','','','1','32','Text','','Acker-/ Grünlandzahl','','7','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`,`privileg`) VALUES(@last_layer_id50303344,'bezeichner','bezeichner','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','varchar','','','1',NULL,'Text','','Bodenart','','3','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`,`privileg`) VALUES(@last_layer_id50303344,'bezeichnung','gruppe','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','not_saveable','','','1',NULL,'Text','','Bezeichnung','','1','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`,`privileg`) VALUES(@last_layer_id50303344,'bodenzahlodergruenlandgrundzahl','bodenzahlodergruenlandgrundzahl','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','int4','','','1','32','Text','','Bodenzahl / Grünlandgrundzahl','','6','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`,`privileg`) VALUES(@last_layer_id50303344,'entstehung','entstehung','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','varchar','','','1',NULL,'Text','','Entstehung','','5','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`,`privileg`) VALUES(@last_layer_id50303344,'kultur','kultur','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','varchar','','','1',NULL,'Text','','Kulturart','','2','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`,`privileg`) VALUES(@last_layer_id50303344,'ogc_fid','ogc_fid','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','int4','','','1','32','Text','','Datenbank-ID','','0','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`,`privileg`) VALUES(@last_layer_id50303344,'the_geom','the_geom','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','geometry','POINT','','1',NULL,'Geometrie','','Geometrie','','8','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`,`privileg`) VALUES(@last_layer_id50303344,'zustand_bodenstufe','zustand_bodenstufe','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','varchar','','','1',NULL,'Text','','Zustand Bodenstufe','','4','0');
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Musterstück',@last_layer_id50303344,'([merkmal] = 1000)','1','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'punkt','4','171 4 0','','','3','4','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,'0 20 8','255 255 255','',NULL,NULL,'','',NULL,NULL,'8','6','10','6',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);
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Landesmusterstück',@last_layer_id50303344,'([merkmal] = 2000)','2','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'punkt','4','230 0 160','','','3','4','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);
UPDATE layer_attributes SET options = REPLACE(options, '50303344', @last_layer_id50303344) WHERE layer_id IN(@last_layer_id50303344) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
Vergleichsstück
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`,`metalink`,`privileg`) VALUES('ALKIS_Vergleichsstücke','0',@group_id,'select ogc_fid, gruppe||\' Nr. \'||nummer as bezeichnung, kultur, bezeichner, zustand_bodenstufe, entstehung, bodenzahlodergruenlandgrundzahl, ackerzahlodergruenlandzahl, the_geom from lk_muster_vergleichsstuecke where merkmal = 3000','the_geom FROM (SELECT oid, gruppe||\' Nr. \'||nummer as bezeichnung, merkmal, the_geom FROM alkis.lk_muster_vergleichsstuecke where merkmal = 3000) as foo using unique oid using srid=25833','alkis','','','','','bezeichnung','10001','49','',@connection,'','6','','','3','pixels','25833','','1',NULL,'100000','49','50001','','EPSG:25833','','1.1.0','image/png','60','','','','','1','0','','Vergleichsstücke der Reichsbodenschätzung aus ALKIS','Fachdienst Kataster und Vermessung','','0');
SET @last_layer_id50303316=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`,`privileg`) VALUES(@last_layer_id50303316,'ackerzahlodergruenlandzahl','ackerzahlodergruenlandzahl','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','int4','','','1','32','Text','','Acker-/ Grünlandzahl','','7','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`,`privileg`) VALUES(@last_layer_id50303316,'bezeichner','bezeichner','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','varchar','','','1',NULL,'Text','','Bodenart','','3','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`,`privileg`) VALUES(@last_layer_id50303316,'bezeichnung','gruppe','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','not_saveable','','','1',NULL,'Text','','Name','','1','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`,`privileg`) VALUES(@last_layer_id50303316,'bodenzahlodergruenlandgrundzahl','bodenzahlodergruenlandgrundzahl','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','int4','','','1','32','Text','','Bodenzahl / Grünlandgrundzahl','','6','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`,`privileg`) VALUES(@last_layer_id50303316,'entstehung','entstehung','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','varchar','','','1',NULL,'Text','','Entstehung','','5','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`,`privileg`) VALUES(@last_layer_id50303316,'kultur','kultur','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','varchar','','','1',NULL,'Text','','Kulturart','','2','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`,`privileg`) VALUES(@last_layer_id50303316,'ogc_fid','ogc_fid','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','int4','','','1','32','Text','','Datenbank-ID','','0','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`,`privileg`) VALUES(@last_layer_id50303316,'the_geom','the_geom','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','geometry','POINT','','1',NULL,'Geometrie','','Geometrie','','8','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`,`privileg`) VALUES(@last_layer_id50303316,'zustand_bodenstufe','zustand_bodenstufe','lk_muster_vergleichsstuecke','lk_muster_vergleichsstuecke','varchar','','','1',NULL,'Text','','Zustand Bodenstufe','','4','0');
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Vergleichsstück',@last_layer_id50303316,'([merkmal] = 3000)','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('25','','12','171 4 0','','255 255 255','7','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,'0 20 8','255 255 255','',NULL,NULL,'','',NULL,NULL,'8','6','10','6',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, '50303316', @last_layer_id50303316) WHERE layer_id IN(@last_layer_id50303316) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
Grabloch
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`,`metalink`,`privileg`) VALUES('ALKIS_Grablöcher','0',@group_id,'select oid, bezeichner, nummerdesgrablochs, the_geom from lk_grabloch','the_geom from (select oid, bedeutung, nummerdesgrablochs, the_geom from alkis.lk_grabloch) as foo using unique oid using srid=25833','alkis','','','','','nummerdesgrablochs','5001','49','',@connection,'','6','','','3','pixels','25833','','1',NULL,'30000730','1','5001','255 255 255','EPSG:2398','','1.1.0','image/png','60','','','','','0','0','','Grablöcher der Reichsbodenschätzung aus ALKIS.','Fachdienst Kataster und Vermessung','','0');
SET @last_layer_id50303314=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`,`privileg`) VALUES(@last_layer_id50303314,'bezeichner','bezeichner','lk_grabloch','lk_grabloch','varchar','','','1',NULL,'Text','','Bezeichnung','','1','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`,`privileg`) VALUES(@last_layer_id50303314,'nummerdesgrablochs','nummerdesgrablochs','lk_grabloch','lk_grabloch','varchar','','','1',NULL,'Text','','Nummer','','2','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`,`privileg`) VALUES(@last_layer_id50303314,'oid','oid','lk_grabloch','lk_grabloch','oid','','','1',NULL,'Text','','Datenbank-ID','','0','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`,`privileg`) VALUES(@last_layer_id50303314,'the_geom','the_geom','lk_grabloch','lk_grabloch','geometry','POINT','','1',NULL,'Geometrie','','Geometrie','','3','0');
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('nicht bestimmendes Grabloch',@last_layer_id50303314,'(\'[bedeutung]\' = \'{3000}\')','2','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'gekreuzt-schraeg','6','255 0 255','','0 0 0','7','9','0','',NULL,NULL,NULL,NULL,'');
SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO 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_underline_1',NULL,'255 0 255','-1 -1 -1','',NULL,NULL,'','',NULL,NULL,'8','8','10','8','13','-5',NULL,NULL,NULL,'1',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);
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('bestimmendes Grabloch',@last_layer_id50303314,'(\'[bedeutung]\' = \'{1100}\')','1','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'gekreuzt-schraeg','6','255 0 0','','0 0 0','7','9','0','',NULL,NULL,NULL,NULL,'');
SET @last_style_id=LAST_INSERT_ID();
INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
INSERT INTO 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_underline_1',NULL,'255 0 0','-1 -1 -1','',NULL,NULL,'','',NULL,NULL,'8','8','10','8','13','-5',NULL,NULL,NULL,'1',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, '50303314', @last_layer_id50303314) WHERE layer_id IN(@last_layer_id50303314) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
Bewertung
Tagesabschnitt
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`,`metalink`,`privileg`) VALUES('ALKIS_Tagesabschnitte','2',@group_id,'','the_geom from (select ogc_fid as oid, tagesabschnittsnummer, wkb_geometry as the_geom from alkis.ax_tagesabschnitt) as foo using unique oid using srid=25833','alkis','','','','','tagesabschnittsnummer','50000','50','',@connection,'','6','','','3','pixels','25833','','0',NULL,'350000','1','25001','','EPSG:2398','','1.1.0','image/png','60','','','','','0','0','','Tagesabschnitte der Reichsbodenschätzung aus ALKIS.','Fachdienst Kataster und Vermessung','','0');
SET @last_layer_id50303315=LAST_INSERT_ID();
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Tagesabschnitt',@last_layer_id50303315,'','1','');
SET @last_class_id=LAST_INSERT_ID();
INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'punkt','4','-1 -1 -1','','0 204 204','3','4','','',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,'0 204 204','255 255 255','',NULL,NULL,'255 255 255','',NULL,NULL,'12','12','18',NULL,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, '50303315', @last_layer_id50303315) WHERE layer_id IN(@last_layer_id50303315) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
Verwaltungseinheiten
VR
Kreis
Amtsverwaltungen
Gemeinden v
Gemeindeteil
Gemarkungen v
Fluren v
geographische Gebietseinheiten
VG
kleinräumiger Landschaftsteil
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`,`metalink`,`privileg`) VALUES('Landschaftsteil','0',@group_id,'','the_geom from (SELECT oid, landschaftstyp, name, wkb_geometry AS the_geom FROM alkis.ax_kleinraeumigerlandschaftsteil WHERE endet IS NULL) as foo using unique oid using srid=25833','alkis','','','','','name','50010','99','',@connection,'','6','','oid','5','pixels','25833','','0',NULL,'86340','99','50010','','EPSG:25833','landschaftsteil','1.1.1','image/png','60','','','','','0','0','','','','','0');
SET @last_layer_id206001=LAST_INSERT_ID();
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Bezeichnung',@last_layer_id206001,'','1','');
SET @last_class_id=LAST_INSERT_ID();
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,'0 0 0','255 255 255','',NULL,NULL,'','',NULL,NULL,'9','8','10',NULL,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, '206001', @last_layer_id206001) WHERE layer_id IN(@last_layer_id206001) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
Wohnplatz
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`,`metalink`,`privileg`) VALUES('Wohnplatz','0',@group_id,'','the_geom from (SELECT oid, name, wkb_geometry AS the_geom FROM alkis.ax_wohnplatz WHERE endet IS NULL) as foo using unique oid using srid=25833','alkis','','','','','name','50010','99','',@connection,'','6','','oid','5','pixels','25833','','0',NULL,'86320','99','50010','','EPSG:25833','wohnplatz','1.1.1','image/png','60','','','','','0','0','','','','','0');
SET @last_layer_id206002=LAST_INSERT_ID();
INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Bezeichnung',@last_layer_id206002,'','1','');
SET @last_class_id=LAST_INSERT_ID();
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,'0 0 0','255 255 255','',NULL,NULL,'','',NULL,NULL,'9','8','10',NULL,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, '206002', @last_layer_id206002) WHERE layer_id IN(@last_layer_id206002) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
sonstige Angaben
VG
Vegetationsmerkmale
Gewässermerkmale
untergeordnetes Gewässer
andere Themen mit ALKIS-Bezug
alle
