ALKIS-Layerdefinitionen - Versionsgeschichte

Giese am 15. Mai 2014 um 05:36 Uhr

2014-05-15T05:36:06Z

Giese am 15. Mai 2014 um 05:19 Uhr

2014-05-15T05:19:37Z

Änderungen zeigen

Giese am 15. Mai 2014 um 05:00 Uhr

2014-05-15T05:00:04Z

Änderungen zeigen

Rahn am 7. Mai 2014 um 15:06 Uhr

2014-05-07T15:06:47Z

Rahn am 7. Mai 2014 um 15:05 Uhr

2014-05-07T15:05:10Z

Rahn am 24. Juli 2013 um 08:12 Uhr

2013-07-24T08:12:32Z

Rahn am 24. Juli 2013 um 08:11 Uhr

2013-07-24T08:11:38Z

Rahn am 7. Mai 2013 um 07:43 Uhr

2013-05-07T07:43:04Z

Änderungen zeigen

Rahn am 6. Mai 2013 um 10:16 Uhr

2013-05-06T10:16:59Z

Änderungen zeigen

@@ Zeile 182: / Zeile 182: @@
 UPDATE layer_attributes SET options = REPLACE(options, '1149', @last_layer_id1149) WHERE layer_id IN(@last_layer_id1147, @last_layer_id1151, @last_layer_id1146, @last_layer_id1145, @last_layer_id1149, @last_layer_id1148, @last_layer_id1150) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
 UPDATE layer_attributes SET options = REPLACE(options, '1148', @last_layer_id1148) WHERE layer_id IN(@last_layer_id1147, @last_layer_id1151, @last_layer_id1146, @last_layer_id1145, @last_layer_id1149, @last_layer_id1148, @last_layer_id1150) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
-UPDATE layer_attributes SET options = REPLACE(options, '1150', @last_layer_id1150) WHERE layer_id IN(@last_layer_id1147, @last_layer_id1151, @last_layer_id1146, @last_layer_id1145, @last_layer_id1149, @last_layer_id1148, @last_layer_id1150) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');
+UPDATE layer_attributes SET options = REPLACE(options, '1150', @last_layer_id1150) WHERE layer_id IN(@last_layer_id1147, @last_layer_id1151, @last_layer_id1146, @last_layer_id1145, @last_layer_id1149, @last_layer_id1148, @last_layer_id1150) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');</nowiki>
 '''Anlegen eines Gebäudelayers'''
@@ Zeile 217: / Zeile 217: @@
 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);
+INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);</nowiki>
@@ Zeile 240: / Zeile 240: @@
 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);
+INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);</nowiki>
@@ Zeile 271: / Zeile 271: @@
 INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','1','-1 -1 -1','','106 0 235',NULL,'1','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 u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);</nowiki>
 '''Anlegen von Layern für die Bodenschätzung'''

@@ Zeile 183: / Zeile 183: @@
 SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';
-INSERT INTO layer (`Name`,`Datentyp`,`Gruppe`,`pfad`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`epsg_code`,`template`,`queryable`,`transparency`,`drawingorder`,`minscale`,`maxscale`,`offsite`,`ows_srs`,`wms_name`,`wms_server_version`,`wms_format`,`wms_connectiontimeout`,`wms_auth_username`,`wms_auth_password`,`wfs_geom`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`) VALUES('Alkis Gebäude','2',@group_id,'SELECT * FROM lk_gebaeude WHERE 1=1','the_geom from (select 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,'30000695','1','100000','','EPSG:25833','ALK-Flure','1.1.0','image/png','60','','','','','1','0','','Gebäude in ALKIS','Vermessungs- und Geoinformationsbehörde LWL-PCH');
+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 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,'30000695','1','100000','','EPSG:25833','ALK-Flure','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`) VALUES(@last_layer_id1152,'ax_datenerhebung','ax_datenerhebung','lk_gebaeude','lk_gebaeude','int4','','','1','32','Text','','','','14');

@@ Zeile 5: / Zeile 5: @@
 SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';
-INSERT INTO layer (`Name`,`Datentyp`,`Gruppe`,`pfad`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`epsg_code`,`template`,`queryable`,`transparency`,`drawingorder`,`minscale`,`maxscale`,`offsite`,`ows_srs`,`wms_name`,`wms_server_version`,`wms_format`,`wms_connectiontimeout`,`wms_auth_username`,`wms_auth_password`,`wfs_geom`,`selectiontype`,`querymap`,`logconsume`,`processing`,`kurzbeschreibung`,`datenherr`) VALUES('Flurstuecke_Alkis','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','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','','','');
+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','');

@@ Zeile 151: / Zeile 151: @@
 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,'30 30 30','255 255 255','',NULL,NULL,'','',NULL,NULL,'7','7','18','9',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);</nowiki>

@@ Zeile 185: / Zeile 185: @@
   SET @last_label_id=LAST_INSERT_ID();
 INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);</nowiki>
 '''Anlegen eines Nutzungsartenlayers'''