https://kvwmap.de/wiki/index.php?action=history&feed=atom&title=Layerdefinition_Kinderbetreuung 2026-05-12T21:11:34Z Versionsgeschichte dieser Seite in kvwmap MediaWiki 1.23.1 https://kvwmap.de/wiki/index.php?title=Layerdefinition_Kinderbetreuung&diff=6233&oldid=prev 2011-09-09T08:45:54Z

<p></p> <p><b>Neue Seite</b></p><div> &lt;nowiki&gt;<br /> SET @group_id = 1;<br /> SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';<br /> <br /> INSERT INTO layer (`Name`,`Datentyp`,`Gruppe`,`pfad`,`Data`,`schema`,`document_path`,`tileindex`,`tileitem`,`labelangleitem`,`labelitem`,`labelmaxscale`,`labelminscale`,`labelrequires`,`connection`,`printconnection`,`connectiontype`,`classitem`,`filteritem`,`tolerance`,`toleranceunits`,`epsg_code`,`template`,`queryable`,`transparency`,`drawingorder`,`minscale`,`maxscale`,`offsite`,`ows_srs`,`wms_name`,`wms_server_version`,`wms_format`,`wms_connectiontimeout`,`wms_auth_username`,`wms_auth_password`,`wfs_geom`,`selectiontype`,`querymap`,`logconsume`) VALUES('Kinderbetreuung','0',@group_id,'SELECT oid,* FROM fd_kitas WHERE 1=1','the_geom from fd_kitas as foo using unique oid using srid=2398','','/data/Bilder/kitas/','','','','',NULL,NULL,'',@connection,'','6','','id','3','pixels','2398','','0',NULL,NULL,NULL,NULL,'','EPSG:2398','','1.1.0','image/png','60','','','','','0','');<br /> SET @last_layer_id4550=LAST_INSERT_ID();<br /> INSERT 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_id4550,'amt','amt','fd_kitas','fd_kitas','text','','','1',NULL,'Text','','Amt','','18');<br /> INSERT 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_id4550,'angebote','angebote','fd_kitas','fd_kitas','varchar','','','1','150','Text','','Angebote','','7');<br /> INSERT 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_id4550,'ap','ap','fd_kitas','fd_kitas','text','','','1',NULL,'Text','','Ansprechpartner','','14');<br /> INSERT 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_id4550,'art','art','fd_kitas','fd_kitas','varchar','','','0','11','Auswahlfeld','\'Kita\',\'Tagespflege\',\'Hort\'','Art der Einrichtung','','10');<br /> INSERT 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_id4550,'art_traeger','art_traeger','fd_kitas','fd_kitas','varchar','','','1','50','Auswahlfeld','\'freier Träger\',\'kommunaler Träger\',\'privat\'','Art des Trägers','','8');<br /> INSERT 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_id4550,'bild','bild','fd_kitas','fd_kitas','varchar','','','1','255','Dokument','','Bild','','19');<br /> INSERT 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_id4550,'bilddatum','bilddatum','fd_kitas','fd_kitas','date','','','1',NULL,'Text','','Bilddatum','','22');<br /> INSERT 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_id4550,'copyright','copyright','fd_kitas','fd_kitas','varchar','','','1','50','Text','','Urheberrecht (Bild)','','21');<br /> INSERT 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_id4550,'email','email','fd_kitas','fd_kitas','text','','','1',NULL,'Text','','E-mail','','17');<br /> INSERT 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_id4550,'fax','fax','fd_kitas','fd_kitas','text','','','1',NULL,'Text','','Fax','','16');<br /> INSERT 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_id4550,'hort','hort','fd_kitas','fd_kitas','int4','','','1',NULL,'Text','','Hortplätze','','13');<br /> INSERT 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_id4550,'id','id','fd_kitas','fd_kitas','int4','','','1',NULL,'Text','','','','1');<br /> INSERT 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_id4550,'kindergarten','kindergarten','fd_kitas','fd_kitas','int4','','','1',NULL,'Text','','Kindergartenplätze','','12');<br /> INSERT 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_id4550,'krippe','krippe','fd_kitas','fd_kitas','int4','','','1',NULL,'Text','','Krippenplätze','','11');<br /> INSERT 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_id4550,'name','name','fd_kitas','fd_kitas','varchar','','','1','50','Text','','Name der Einrichtung','','2');<br /> INSERT 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_id4550,'oeffentlich','oeffentlich','fd_kitas','fd_kitas','varchar','','','0','4','Auswahlfeld','\'ja\',\'nein\'','Bild öffentlich','','20');<br /> INSERT 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_id4550,'oid','oid','','','oid','','',NULL,NULL,'Text','','','','0');<br /> INSERT 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_id4550,'open','open','fd_kitas','fd_kitas','varchar','','','1','50','Text','','Öffnungszeit','','6');<br /> INSERT 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_id4550,'plz_ort','plz_ort','fd_kitas','fd_kitas','varchar','','','1','50','Text','','PLZ/Ort','','4');<br /> INSERT 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_id4550,'portal_eintrag','portal_eintrag','fd_kitas','fd_kitas','varchar','','','0','4','Auswahlfeld','\'ja\',\'nein\'','Eintrag veröffentlichen?','','23');<br /> INSERT 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_id4550,'strasse','strasse','fd_kitas','fd_kitas','varchar','','','1','50','Text','','Straße','','3');<br /> INSERT 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_id4550,'tel','tel','fd_kitas','fd_kitas','text','','','1',NULL,'Text','','Telefon','','15');<br /> INSERT 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_id4550,'the_geom','the_geom','fd_kitas','fd_kitas','geometry','POINT','','1',NULL,'Geometrie','','','','9');<br /> INSERT 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_id4550,'traeger','traeger','fd_kitas','fd_kitas','varchar','','','1','50','Text','','Träger','','5');<br /> INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Kindertagesst.',@last_layer_id4550,'(\'[art]\' = \'Kita\')','0','');<br /> SET @last_class_id=LAST_INSERT_ID();<br /> INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'kita','25','','','0 0 0','10','30','0','',NULL,NULL,NULL,NULL,'');<br /> SET @last_style_id=LAST_INSERT_ID();<br /> INSERT INTO u_styles2classes (style_id, class_id) VALUES (@last_style_id, @last_class_id);<br /> INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Tagespflege',@last_layer_id4550,'(\'[art]\' = \'Tagespflege\')','0','');<br /> SET @last_class_id=LAST_INSERT_ID();<br /> INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'tagespflege','25','','','0 0 0','10','30','0','',NULL,NULL,NULL,NULL,'');<br /> SET @last_style_id=LAST_INSERT_ID();<br /> INSERT INTO u_styles2classes (style_id, class_id) VALUES (@last_style_id, @last_class_id);<br /> INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('Hort',@last_layer_id4550,'(\'[art]\' = \'Hort\')','0','');<br /> SET @last_class_id=LAST_INSERT_ID();<br /> INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'hort','20','','','0 0 0','3','35','0','',NULL,NULL,NULL,NULL,'');<br /> SET @last_style_id=LAST_INSERT_ID();<br /> INSERT INTO u_styles2classes (style_id, class_id) VALUES (@last_style_id, @last_class_id);<br /> <br /> UPDATE layer_attributes SET options = REPLACE(options, '4550', @last_layer_id4550) WHERE layer_id IN(4550) AND type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');<br /> <br /> &lt;/nowiki&gt;</div>

A.tower