Mercurial > lada > lada-server

annotate db_schema/stammdaten_data_ort.sql @ 1290:14876c62f692

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Push down refreshing of persisted objects deeper into the stack. There are more places besides creation of Probe objects where it is useful to return within the response what has been really written to the database (including modifications by the database itself) instead of merely the request data, e.g. creation of Ort objects, which includes database generated ort_ids.
author Tom Gottfried <tom@intevation.de>
date Wed, 08 Feb 2017 18:02:05 +0100
parents 6f206d8eab7e
children 739ad8e78fca
rev   line source
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
1 \set ON_ERROR_STOP on
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
2
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
3 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
4 -- PostgreSQL database dump
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
5 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
6
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
7 -- Dumped from database version 9.5.1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
8 -- Dumped by pg_dump version 9.5.0
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
9
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
10 -- Started on 2016-03-31 11:38:13
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
11
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
12 SET statement_timeout = 0;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
13 SET lock_timeout = 0;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
14 SET client_encoding = 'UTF8';
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
15 SET standard_conforming_strings = on;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
16 SET check_function_bodies = false;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
17 SET client_min_messages = warning;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
18
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
19 SET search_path = stammdaten, pg_catalog;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
20
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
21
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
22 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
23 -- TOC entry 4704 (class 0 OID 535789)
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
24 -- Dependencies: 270
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
25 -- Data for Name: ort; Type: TABLE DATA; Schema: stammdaten; Owner: lada
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
26 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
27
1212
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
28 COPY ort (id, netzbetreiber_id, ort_id, langtext, staat_id, gem_id, unscharf, nuts_code, kda_id, koord_x_extern, koord_y_extern, hoehe_land, letzte_aenderung, geom, shape, ort_typ, kurztext, berichtstext, zone, sektor, zustaendigkeit, mp_art, aktiv, anlage_id, oz_id) FROM stdin;
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
29 19 D T060014 WW Kassel 0 06611000 0 DE731 5 32531152 5684269 \N 2013-08-12 07:57:26.332873 0101000020E6100000DB334B02D4E42240BA313D6189A74940 \N 1 T060014 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
30 33 D T110001 WW Beelitzhof, Berlin 0 11000000 0 DE300 5 33390988 5821608 \N 2013-08-12 07:57:26.332873 0101000020E61000000C1F115322C92A4031EBC5504E444A40 \N 1 T110001 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
31 51 D T060005 WW Eschollbruecken 0 06432018 0 DE716 5 32470178 5516260 \N 2013-08-12 07:57:26.332873 0101000020E6100000CF6BEC12D52B214052499D8026E64840 \N 1 T060005 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
32 61 D M060003 (MVA) Kassel 0 06611000 0 DE731 5 32531152 5684269 \N 2013-08-12 07:57:26.332873 0101000020E6100000DB334B02D4E42240BA313D6189A74940 \N 1 M060003 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
33 64 D FKI0005 Kinzig; Hanau; PE-Stelle kurz vor Mündung in Main 0 06435014 0 DE719 5 32493851 5551177 \N 2013-08-12 07:57:26.332873 0101000020E61000008716D9CEF7D32140B554DE8E700E4940 \N 1 FKI0005 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
34 85 D FSD0005 Schwarzbach/Hessen; Trebur; PE-Ort Trebur-Astheim 0 06433014 0 DE717 5 32456065 5529415 \N 2013-08-12 07:57:26.332873 0101000020E6100000D8BB3FDEABC6204077BE9F1A2FF54840 \N 1 FSD0005 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
35 140 D FSP0092 Spree km 9.20; PE-Stelle Nr. 11002, Einmündung Landwehrkanal 0 11000000 0 DE300 5 33390988 5821608 \N 2013-08-12 07:57:26.332873 0101000020E61000000C1F115322C92A4031EBC5504E444A40 \N 1 FSP0092 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
36 190 06 D_ 00190 Reinheim 0 06432019 0 DE716 5 32487017 5519769 \N 2013-08-12 07:57:26.332873 0101000020E6100000C173EFE192A32140F5673F5244EA4840 \N 1 D_ 00190 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
37 156 D T060020 WW Wiesbaden-Schierstein 0 06414000 0 DE714 5 32447434 5548087 \N 2013-08-12 07:57:26.332873 0101000020E6100000B9DFA128D0872040D15CA791960A4940 \N 1 T060020 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
38 165 D SMG1101 Müggelsee; Berlin; PE-Stelle Nr. 41035 0 11000000 0 DE300 5 33390988 5821608 \N 2013-08-12 07:57:26.332873 0101000020E61000000C1F115322C92A4031EBC5504E444A40 \N 1 SMG1101 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
39 168 D D060003 Uttershausen 0 06634025 0 DE735 5 32526698 5659112 \N 2013-08-12 07:57:26.332873 0101000020E610000033164D6727C322402D95B7239C8A4940 \N 1 D060003 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
40 173 D K060022 KLA Wiesbaden 0 06414000 0 DE714 5 32447434 5548087 \N 2013-08-12 07:57:26.332873 0101000020E6100000B9DFA128D0872040D15CA791960A4940 \N 1 K060022 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
41 198 D M060001 (SEVA) Frankfurt/M. Sindlingen 0 06412000 0 DE712 5 32475476 5550676 \N 2013-08-12 07:57:26.332873 0101000020E6100000E353008C675021408BC3995FCD0D4940 \N 1 M060001 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
42 218 D SMG1100 Müggelsee 0 11000000 0 DE300 5 33390988 5821608 \N 2013-08-12 07:57:26.332873 0101000020E61000000C1F115322C92A4031EBC5504E444A40 \N 1 SMG1100 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
43 223 D T110015 Grundwasser Tempelhof ( Ringbahnstraße ) 0 11000000 0 DE300 5 33390988 5821608 \N 2013-08-12 07:57:26.332873 0101000020E61000000C1F115322C92A4031EBC5504E444A40 \N 1 T110015 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
44 4 06 D_ 00004 Wabern 0 06634025 0 DE735 5 32526698 5659112 \N 2013-08-12 07:57:26.332873 0101000020E610000033164D6727C322402D95B7239C8A4940 \N 1 D_ 00004 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
45 5 06 D_ 00005 Hanau 0 06435014 0 DE719 5 32493851 5551177 \N 2013-08-12 07:57:26.332873 0101000020E61000008716D9CEF7D32140B554DE8E700E4940 \N 1 D_ 00005 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
46 12 06 D_ 00012 Wiesbaden 0 06414000 0 DE714 5 32447434 5548087 \N 2013-08-12 07:57:26.332873 0101000020E6100000B9DFA128D0872040D15CA791960A4940 \N 1 D_ 00012 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
47 23 06 D_ 00023 Melsungen 0 06634014 0 DE735 5 32541043 5665935 \N 2013-08-12 07:57:26.332873 0101000020E610000078D15790662C23408A1F63EE5A924940 \N 1 D_ 00023 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
48 26 06 D_ 00026 Trebur 0 06433014 0 DE717 5 32456065 5529415 \N 2013-08-12 07:57:26.332873 0101000020E6100000D8BB3FDEABC6204077BE9F1A2FF54840 \N 1 D_ 00026 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
49 29 06 D_ 00029 Frankfurt am Main 0 06412000 0 DE712 5 32475476 5550676 \N 2013-08-12 07:57:26.332873 0101000020E6100000E353008C675021408BC3995FCD0D4940 \N 1 D_ 00029 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
50 42 12 D_ 00042 Uebigau-Wahrenbrück 0 12062500 0 DE407 5 33383584 5715754 \N 2013-08-12 07:57:26.332873 0101000020E6100000A4367172BFA32A404A9869FB57CA4940 \N 1 D_ 00042 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
51 68 06 D_ 00068 Friedberg (Hessen) 0 06440008 0 DE71E 5 32484822 5574572 \N 2013-08-12 07:57:26.332873 0101000020E6100000344B02D4D4922140857CD0B359294940 \N 1 D_ 00068 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
52 69 12 D_ 00069 Karstädt 0 12070173 0 DE40F 5 32681930 5894394 \N 2013-08-12 07:57:26.332873 0101000020E6100000361FD7868A712740FD9FC37C79954A40 \N 1 D_ 00069 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
53 74 06 D_ 00074 Königstein im Taunus 0 06434005 0 DE718 5 32461213 5559884 \N 2013-08-12 07:57:26.332873 0101000020E61000004417D4B7CCE920400E15E3FC4D184940 \N 1 D_ 00074 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
54 76 06 D_ 00076 Altenstadt 0 06440001 0 DE71E 5 32496205 5570655 \N 2013-08-12 07:57:26.332873 0101000020E6100000BF4868CBB9E42140E275FD82DD244940 \N 1 D_ 00076 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
55 86 11 D_ 00086 Berlin 0 11000000 0 DE300 5 33390988 5821608 \N 2013-08-12 07:57:26.332873 0101000020E61000000C1F115322C92A4031EBC5504E444A40 \N 1 D_ 00086 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
56 87 06 D_ 00087 Kassel 0 06611000 0 DE731 5 32531152 5684269 \N 2013-08-12 07:57:26.332873 0101000020E6100000DB334B02D4E42240BA313D6189A74940 \N 1 D_ 00087 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
57 97 12 D_ 00097 Frankfurt (Oder) 0 12053000 0 DE403 5 33465204 5796318 \N 2013-08-12 07:57:26.332873 0101000020E6100000ED2AA4FCA4FA2C40DC4B1AA375284A40 \N 1 D_ 00097 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
58 102 06 D_ 00102 Körle 0 06634012 0 DE735 5 32536270 5669258 \N 2013-08-12 07:57:26.332873 0101000020E61000000B5EF415A4092340F54A598638964940 \N 1 D_ 00102 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
59 127 06 D_ 00127 Weilburg 0 06533017 0 DE723 5 32447433 5593044 \N 2013-08-12 07:57:26.332873 0101000020E61000006AFB57569A842040BC3FDEAB563E4940 \N 1 D_ 00127 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
60 129 06 D_ 00129 Calden 0 06633005 0 DE734 5 32522395 5698475 \N 2013-08-12 07:57:26.332873 0101000020E61000004D327216F6A4224079AF5A99F0B74940 \N 1 D_ 00129 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
61 131 06 D_ 00131 Witzenhausen 0 06636016 0 DE737 5 32558542 5688717 \N 2013-08-12 07:57:26.332873 0101000020E6100000E657738060AE23401C9947FE60AC4940 \N 1 D_ 00131 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
62 138 06 D_ 00138 Bad Schwalbach 0 06439002 0 DE71D 5 32432747 5554830 \N 2013-08-12 07:57:26.332873 0101000020E6100000035B25581C1E20406EFAB31F29124940 \N 1 D_ 00138 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
63 161 06 D_ 00161 Pfungstadt 0 06432018 0 DE716 5 32470178 5516260 \N 2013-08-12 07:57:26.332873 0101000020E6100000CF6BEC12D52B214052499D8026E64840 \N 1 D_ 00161 \N \N \N \N \N \N \N \N
6f206d8eab7e Remove obsolete redundant attributes.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
64 162 06 D_ 00162 Fulda 0 06631009 0 DE732 5 32546674 5604269 \N 2013-08-12 07:57:26.332873 0101000020E6100000363CBD5296512340888043A8524B4940 \N 1 D_ 00162 \N \N \N \N \N \N \N \N
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
65 \.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)