Rahn am 20. September 2019 um 07:52 Uhr

2019-09-20T07:52:54Z

Rahn am 12. September 2019 um 08:03 Uhr

2019-09-12T08:03:42Z

Rahn am 12. September 2019 um 07:23 Uhr

2019-09-12T07:23:23Z

Rahn am 26. August 2019 um 10:52 Uhr

2019-08-26T10:52:12Z

Rahn: Die Seite wurde neu angelegt: „ -- -- PostgreSQL database dump -- -- Dumped from database version 9.4.10 -- Dumped by pg_dump version 9.4.10 -- Started on 2019-08-26 10:34:09 UTC S…“

2019-08-26T10:48:39Z

Die Seite wurde neu angelegt: „ <nowiki>-- -- PostgreSQL database dump -- -- Dumped from database version 9.4.10 -- Dumped by pg_dump version 9.4.10 -- Started on 2019-08-26 10:34:09 UTC S…“

Änderungen zeigen

← Nächstältere Version		Version vom 20. September 2019, 07:52 Uhr
Zeile 28:		Zeile 28:

	CREATE SCHEMA grunddaten;		CREATE SCHEMA grunddaten;
		+
		+	CREATE TABLE grunddaten.kundencenter
		+	(
		+	id integer NOT NULL,
		+	name character varying NOT NULL,
		+	zustaendig_fuer character varying,
		+	strasse character(1),
		+	plz character(1),
		+	ort character(1),
		+	tel character(1),
		+	"e-mail" character varying,
		+	CONSTRAINT id PRIMARY KEY (id)
		+	)
		+	WITH (
		+	OIDS=true
		+	);

	CREATE TABLE grunddaten.abteilungen		CREATE TABLE grunddaten.abteilungen

@@ Zeile 18: / Zeile 18: @@
 -- Name: baumkataster; Type: SCHEMA; Schema: -; Owner: -
 --
 CREATE SCHEMA grunddaten;

@@ Zeile 18: / Zeile 18: @@
 -- Name: baumkataster; Type: SCHEMA; Schema: -; Owner: -
 --
 CREATE SCHEMA baumkataster;

@@ Zeile 374: / Zeile 374: @@
 INSERT INTO baumarten VALUES ('Blumen-Esche', 'Fraxinus ornus', 74);
 INSERT INTO baumarten VALUES ('Blut-Buche', 'Fagus sylvatica purpurea', 32);
-INSERT INTO baumarten VALUES ('Crataegus prunifolia', 'PflaumenblÃ¤ttriger WeiÃŸdorn', 118);
+INSERT INTO baumarten VALUES ('Crataegus prunifolia', 'Pflaumenblättriger Weißdorn', 118);
-INSERT INTO baumarten VALUES ('Crataegus prunifolia ', 'PflaumenblÃ¤ttriger WeiÃŸdorn', 119);
+INSERT INTO baumarten VALUES ('Crataegus prunifolia ', 'Pflaumenblättriger Weißdorn', 119);
 INSERT INTO baumarten VALUES ('Douglasie', 'Pseudotsuga menziesii', 44);
 INSERT INTO baumarten VALUES ('Eberesche, Vogelbeere', 'Sorbus aucuparia', 17);
@@ Zeile 386: / Zeile 386: @@
 INSERT INTO baumarten VALUES ('Eschen-Ahorn', 'Acer negundo', 81);
 INSERT INTO baumarten VALUES ('Essigbaum', 'Rhus typhina', 46);
-INSERT INTO baumarten VALUES ('EuropÃ¤ische LÃ¤rche', 'Larix decidua', 23);
+INSERT INTO baumarten VALUES ('Europäische Lärche', 'Larix decidua', 23);
-INSERT INTO baumarten VALUES ('FÃ¤cher-Ahorn', 'Acer palmatum', 106);
+INSERT INTO baumarten VALUES ('Fächer-Ahorn', 'Acer palmatum', 106);
 INSERT INTO baumarten VALUES ('Faulbaum', 'Frangula alnus', 56);
 INSERT INTO baumarten VALUES ('Feld-Ahorn', 'Acer campestre', 83);
@@ Zeile 399: / Zeile 399: @@
 INSERT INTO baumarten VALUES ('Gleditschie', 'Gleditsia', 34);
 INSERT INTO baumarten VALUES ('Goldregen', 'Laburnum anagyroides', 37);
-INSERT INTO baumarten VALUES ('GÃ¶tterbaum', 'Ailanthus altissima', 3);
+INSERT INTO baumarten VALUES ('Götterbaum', 'Ailanthus altissima', 3);
 INSERT INTO baumarten VALUES ('Grau-Erle', 'Alnus incana', 93);
-INSERT INTO baumarten VALUES ('Hahnensporn-WeiÃŸdorn', 'Crataegus crus-galli', 91);
+INSERT INTO baumarten VALUES ('Hahnensporn-Weißdorn', 'Crataegus crus-galli', 91);
 INSERT INTO baumarten VALUES ('Hainbuche', 'Carpinus betulus', 6);
 INSERT INTO baumarten VALUES ('Hartriegel', 'Cornus spec.', 29);
@@ Zeile 413: / Zeile 413: @@
 INSERT INTO baumarten VALUES ('Johannisbeere', 'Ribes ssp.', 108);
 INSERT INTO baumarten VALUES ('Judasbaum', 'Cercis', 89);
-INSERT INTO baumarten VALUES ('Kaukasische FlÃ¼gelnuss', 'Pterocarya fraxinifolia', 61);
+INSERT INTO baumarten VALUES ('Kaukasische Flügelnuss', 'Pterocarya fraxinifolia', 61);
 INSERT INTO baumarten VALUES ('Kiefer', 'Pinus spec.', 24);
 INSERT INTO baumarten VALUES ('Kirschpflaume', 'Prunus cerasifera', 69);
 INSERT INTO baumarten VALUES ('Kreuzdorn', 'Rhamnus', 85);
-INSERT INTO baumarten VALUES ('LÃ¤rche', 'Larix', 75);
+INSERT INTO baumarten VALUES ('Lärche', 'Larix', 75);
 INSERT INTO baumarten VALUES ('Lebensbaum', 'Thuja spec.', 25);
 INSERT INTO baumarten VALUES ('Liguster', 'Ligustrum', 110);
@@ Zeile 424: / Zeile 424: @@
 INSERT INTO baumarten VALUES ('Magnolie', 'Magnolia spec.', 39);
 INSERT INTO baumarten VALUES ('Mammutbaum', 'Metasequoia glyptostroboides', 97);
-INSERT INTO baumarten VALUES ('MandelbÃ¤umchen', 'Prunus triloba', 43);
+INSERT INTO baumarten VALUES ('Mandelbäumchen', 'Prunus triloba', 43);
 INSERT INTO baumarten VALUES ('Maulbeere', 'Broussonetia ssp.', 94);
 INSERT INTO baumarten VALUES ('Mehlbeere', 'Sorbus spec.', 122);
 INSERT INTO baumarten VALUES ('Mispel', 'Mespilus germanica', 42);
-INSERT INTO baumarten VALUES ('Ã–lweide', 'Eleagnus angustifolia', 92);
+INSERT INTO baumarten VALUES ('Öweide', 'Eleagnus angustifolia', 92);
 INSERT INTO baumarten VALUES ('Pappel', 'Populus spec.', 12);
-INSERT INTO baumarten VALUES ('PerÃ¼ckenstrauch', 'Cotinus', 102);
+INSERT INTO baumarten VALUES ('Perückenstrauch', 'Cotinus', 102);
-INSERT INTO baumarten VALUES ('PfaffenhÃ¼tchen', 'Euonymus europaeus', 103);
+INSERT INTO baumarten VALUES ('Pfaffenhütchen', 'Euonymus europaeus', 103);
 INSERT INTO baumarten VALUES ('Pfeifenstrauch', 'Philadelphius', 109);
 INSERT INTO baumarten VALUES ('Pfirsich', 'Prunus persica', 55);
 INSERT INTO baumarten VALUES ('Pflaume', 'Prunus spec.', 63);
-INSERT INTO baumarten VALUES ('PflaumenblÃ¤ttriger WeiÃŸdorn', 'Crataegus prunifolia ', 120);
+INSERT INTO baumarten VALUES ('Pflaumenblättriger Weißdorn', 'Crataegus prunifolia ', 120);
 INSERT INTO baumarten VALUES ('Platane', 'Platanus x Hybrida', 11);
 INSERT INTO baumarten VALUES ('Rhododendron', 'Rhododendron spec.', 45);
@@ Zeile 448: / Zeile 448: @@
 INSERT INTO baumarten VALUES ('Scheinzypresse', 'Chamaecyparis', 64);
 INSERT INTO baumarten VALUES ('Schlehe', 'Prunus spinosa', 76);
-INSERT INTO baumarten VALUES ('SchmalblÃ¤ttrige Ã–lweide', 'Elaeagnus angustifolia', 117);
+INSERT INTO baumarten VALUES ('Schmalblättrige Öweide', 'Elaeagnus angustifolia', 117);
 INSERT INTO baumarten VALUES ('Schmucktanne', 'Araucaria', 100);
 INSERT INTO baumarten VALUES ('Schneeball', 'Viburnum spec.', 104);
@@ Zeile 455: / Zeile 455: @@
 INSERT INTO baumarten VALUES ('Silber-Ahorn', 'Acer saccharinum', 88);
 INSERT INTO baumarten VALUES ('Silber-Linde', 'Tilia tomentosa', 87);
-INSERT INTO baumarten VALUES ('SpÃ¤hts-Erle', 'Alnus x spaethii', 95);
+INSERT INTO baumarten VALUES ('Spähts-Erle', 'Alnus x spaethii', 95);
 INSERT INTO baumarten VALUES ('Speierling', 'Sorbus domestica', 48);
 INSERT INTO baumarten VALUES ('Spindelbaum', 'Euonymus europaeus', 121);
@@ Zeile 471: / Zeile 471: @@
 INSERT INTO baumarten VALUES ('Walnuss', 'Juglans regia', 26);
 INSERT INTO baumarten VALUES ('Weide', 'Salix spec.', 16);
-INSERT INTO baumarten VALUES ('WeiÃŸdorn', 'Crataegus spec.', 8);
+INSERT INTO baumarten VALUES ('Weißdorn', 'Crataegus spec.', 8);
-INSERT INTO baumarten VALUES ('WeiÃŸdorn Hybride', 'Crataegus crus-galli', 96);
+INSERT INTO baumarten VALUES ('Weißdorn Hybride', 'Crataegus crus-galli', 96);
 INSERT INTO baumarten VALUES ('Winterlinde', 'Tilia cordata', 116);
 INSERT INTO baumarten VALUES ('Zeder', 'Cedrus spec.', 28);
@@ Zeile 479: / Zeile 479: @@
 INSERT INTO baumarten VALUES ('Amerikanische Linde', 'Tilia americana', 125);
 INSERT INTO baumarten VALUES ('Kirsche', 'Prunus spec.', 62);
-INSERT INTO baumarten VALUES ('Japanische BlÃ¼tenkirsche', 'Prunus serrulata', 126);
+INSERT INTO baumarten VALUES ('Japanische Blütenkirsche', 'Prunus serrulata', 126);
 INSERT INTO baumarten VALUES ('Ahorn', 'Acer spec.', 1);
 INSERT INTO baumarten VALUES ('Akazie', 'Acacia', 20);

GLE-Postgis-Baumkataster-WIRO - Versionsgeschichte

Rahn am 20. September 2019 um 07:52 Uhr

Rahn am 12. September 2019 um 08:03 Uhr

Rahn am 12. September 2019 um 07:23 Uhr

Rahn am 26. August 2019 um 10:52 Uhr

Rahn: Die Seite wurde neu angelegt: „ -- -- PostgreSQL database dump -- -- Dumped from database version 9.4.10 -- Dumped by pg_dump version 9.4.10 -- Started on 2019-08-26 10:34:09 UTC S…“