# HG changeset patch # User Tom Gottfried # Date 1481203835 -3600 # Node ID 6f206d8eab7eed6add4df6f51212901785335086 # Parent f5bedfc7bcc662711beb84d03b8d795c41b6681e Remove obsolete redundant attributes. diff -r f5bedfc7bcc6 -r 6f206d8eab7e db_schema/stammdaten_data_ort.sql --- a/db_schema/stammdaten_data_ort.sql Thu Dec 08 11:09:02 2016 +0100 +++ b/db_schema/stammdaten_data_ort.sql Thu Dec 08 14:30:35 2016 +0100 @@ -25,41 +25,41 @@ -- Data for Name: ort; Type: TABLE DATA; Schema: stammdaten; Owner: lada -- -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, latitude, longitude, geom, shape, ort_typ, kurztext, berichtstext, zone, sektor, zustaendigkeit, mp_art, aktiv, anlage_id, oz_id) FROM stdin; -19 D T060014 WW Kassel 0 06611000 0 DE731 5 32531152 5684269 \N 2013-08-12 07:57:26.332873 51.308880000000002 9.44693000000000005 0101000020E6100000DB334B02D4E42240BA313D6189A74940 \N 1 T060014 \N \N \N \N \N \N \N \N -33 D T110001 WW Beelitzhof, Berlin 0 11000000 0 DE300 5 33390988 5821608 \N 2013-08-12 07:57:26.332873 52.5336399999999983 13.3928399999999996 0101000020E61000000C1F115322C92A4031EBC5504E444A40 \N 1 T110001 \N \N \N \N \N \N \N \N -51 D T060005 WW Eschollbruecken 0 06432018 0 DE716 5 32470178 5516260 \N 2013-08-12 07:57:26.332873 49.7980500000000035 8.58561000000000085 0101000020E6100000CF6BEC12D52B214052499D8026E64840 \N 1 T060005 \N \N \N \N \N \N \N \N -61 D M060003 (MVA) Kassel 0 06611000 0 DE731 5 32531152 5684269 \N 2013-08-12 07:57:26.332873 51.308880000000002 9.44693000000000005 0101000020E6100000DB334B02D4E42240BA313D6189A74940 \N 1 M060003 \N \N \N \N \N \N \N \N -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 50.1128100000000032 8.9139999999999997 0101000020E61000008716D9CEF7D32140B554DE8E700E4940 \N 1 FKI0005 \N \N \N \N \N \N \N \N -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 49.9155000000000015 8.38803000000000054 0101000020E6100000D8BB3FDEABC6204077BE9F1A2FF54840 \N 1 FSD0005 \N \N \N \N \N \N \N \N -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 52.5336399999999983 13.3928399999999996 0101000020E61000000C1F115322C92A4031EBC5504E444A40 \N 1 FSP0092 \N \N \N \N \N \N \N \N -190 06 D_ 00190 Reinheim 0 06432019 0 DE716 5 32487017 5519769 \N 2013-08-12 07:57:26.332873 49.830210000000001 8.81948000000000043 0101000020E6100000C173EFE192A32140F5673F5244EA4840 \N 1 D_ 00190 \N \N \N \N \N \N \N \N -156 D T060020 WW Wiesbaden-Schierstein 0 06414000 0 DE714 5 32447434 5548087 \N 2013-08-12 07:57:26.332873 50.0827200000000019 8.26525999999999961 0101000020E6100000B9DFA128D0872040D15CA791960A4940 \N 1 T060020 \N \N \N \N \N \N \N \N -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 52.5336399999999983 13.3928399999999996 0101000020E61000000C1F115322C92A4031EBC5504E444A40 \N 1 SMG1101 \N \N \N \N \N \N \N \N -168 D D060003 Uttershausen 0 06634025 0 DE735 5 32526698 5659112 \N 2013-08-12 07:57:26.332873 51.082889999999999 9.3811599999999995 0101000020E610000033164D6727C322402D95B7239C8A4940 \N 1 D060003 \N \N \N \N \N \N \N \N -173 D K060022 KLA Wiesbaden 0 06414000 0 DE714 5 32447434 5548087 \N 2013-08-12 07:57:26.332873 50.0827200000000019 8.26525999999999961 0101000020E6100000B9DFA128D0872040D15CA791960A4940 \N 1 K060022 \N \N \N \N \N \N \N \N -198 D M060001 (SEVA) Frankfurt/M. Sindlingen 0 06412000 0 DE712 5 32475476 5550676 \N 2013-08-12 07:57:26.332873 50.1078299999999999 8.65704000000000029 0101000020E6100000E353008C675021408BC3995FCD0D4940 \N 1 M060001 \N \N \N \N \N \N \N \N -218 D SMG1100 Müggelsee 0 11000000 0 DE300 5 33390988 5821608 \N 2013-08-12 07:57:26.332873 52.5336399999999983 13.3928399999999996 0101000020E61000000C1F115322C92A4031EBC5504E444A40 \N 1 SMG1100 \N \N \N \N \N \N \N \N -223 D T110015 Grundwasser Tempelhof ( Ringbahnstraße ) 0 11000000 0 DE300 5 33390988 5821608 \N 2013-08-12 07:57:26.332873 52.5336399999999983 13.3928399999999996 0101000020E61000000C1F115322C92A4031EBC5504E444A40 \N 1 T110015 \N \N \N \N \N \N \N \N -4 06 D_ 00004 Wabern 0 06634025 0 DE735 5 32526698 5659112 \N 2013-08-12 07:57:26.332873 51.082889999999999 9.3811599999999995 0101000020E610000033164D6727C322402D95B7239C8A4940 \N 1 D_ 00004 \N \N \N \N \N \N \N \N -5 06 D_ 00005 Hanau 0 06435014 0 DE719 5 32493851 5551177 \N 2013-08-12 07:57:26.332873 50.1128100000000032 8.9139999999999997 0101000020E61000008716D9CEF7D32140B554DE8E700E4940 \N 1 D_ 00005 \N \N \N \N \N \N \N \N -12 06 D_ 00012 Wiesbaden 0 06414000 0 DE714 5 32447434 5548087 \N 2013-08-12 07:57:26.332873 50.0827200000000019 8.26525999999999961 0101000020E6100000B9DFA128D0872040D15CA791960A4940 \N 1 D_ 00012 \N \N \N \N \N \N \N \N -23 06 D_ 00023 Melsungen 0 06634014 0 DE735 5 32541043 5665935 \N 2013-08-12 07:57:26.332873 51.1433999999999997 9.58671999999999969 0101000020E610000078D15790662C23408A1F63EE5A924940 \N 1 D_ 00023 \N \N \N \N \N \N \N \N -26 06 D_ 00026 Trebur 0 06433014 0 DE717 5 32456065 5529415 \N 2013-08-12 07:57:26.332873 49.9155000000000015 8.38803000000000054 0101000020E6100000D8BB3FDEABC6204077BE9F1A2FF54840 \N 1 D_ 00026 \N \N \N \N \N \N \N \N -29 06 D_ 00029 Frankfurt am Main 0 06412000 0 DE712 5 32475476 5550676 \N 2013-08-12 07:57:26.332873 50.1078299999999999 8.65704000000000029 0101000020E6100000E353008C675021408BC3995FCD0D4940 \N 1 D_ 00029 \N \N \N \N \N \N \N \N -42 12 D_ 00042 Uebigau-Wahrenbrück 0 12062500 0 DE407 5 33383584 5715754 \N 2013-08-12 07:57:26.332873 51.5808099999999996 13.31982 0101000020E6100000A4367172BFA32A404A9869FB57CA4940 \N 1 D_ 00042 \N \N \N \N \N \N \N \N -68 06 D_ 00068 Friedberg (Hessen) 0 06440008 0 DE71E 5 32484822 5574572 \N 2013-08-12 07:57:26.332873 50.3230500000000021 8.78678000000000026 0101000020E6100000344B02D4D4922140857CD0B359294940 \N 1 D_ 00068 \N \N \N \N \N \N \N \N -69 12 D_ 00069 Karstädt 0 12070173 0 DE40F 5 32681930 5894394 \N 2013-08-12 07:57:26.332873 53.1677699999999973 11.7217599999999997 0101000020E6100000361FD7868A712740FD9FC37C79954A40 \N 1 D_ 00069 \N \N \N \N \N \N \N \N -74 06 D_ 00074 Königstein im Taunus 0 06434005 0 DE718 5 32461213 5559884 \N 2013-08-12 07:57:26.332873 50.1898800000000023 8.45664000000000016 0101000020E61000004417D4B7CCE920400E15E3FC4D184940 \N 1 D_ 00074 \N \N \N \N \N \N \N \N -76 06 D_ 00076 Altenstadt 0 06440001 0 DE71E 5 32496205 5570655 \N 2013-08-12 07:57:26.332873 50.2880099999999999 8.94673000000000052 0101000020E6100000BF4868CBB9E42140E275FD82DD244940 \N 1 D_ 00076 \N \N \N \N \N \N \N \N -86 11 D_ 00086 Berlin 0 11000000 0 DE300 5 33390988 5821608 \N 2013-08-12 07:57:26.332873 52.5336399999999983 13.3928399999999996 0101000020E61000000C1F115322C92A4031EBC5504E444A40 \N 1 D_ 00086 \N \N \N \N \N \N \N \N -87 06 D_ 00087 Kassel 0 06611000 0 DE731 5 32531152 5684269 \N 2013-08-12 07:57:26.332873 51.308880000000002 9.44693000000000005 0101000020E6100000DB334B02D4E42240BA313D6189A74940 \N 1 D_ 00087 \N \N \N \N \N \N \N \N -97 12 D_ 00097 Frankfurt (Oder) 0 12053000 0 DE403 5 33465204 5796318 \N 2013-08-12 07:57:26.332873 52.3160900000000026 14.4895399999999999 0101000020E6100000ED2AA4FCA4FA2C40DC4B1AA375284A40 \N 1 D_ 00097 \N \N \N \N \N \N \N \N -102 06 D_ 00102 Körle 0 06634012 0 DE735 5 32536270 5669258 \N 2013-08-12 07:57:26.332873 51.1736000000000004 9.51882999999999946 0101000020E61000000B5EF415A4092340F54A598638964940 \N 1 D_ 00102 \N \N \N \N \N \N \N \N -127 06 D_ 00127 Weilburg 0 06533017 0 DE723 5 32447433 5593044 \N 2013-08-12 07:57:26.332873 50.4870200000000011 8.25899000000000072 0101000020E61000006AFB57569A842040BC3FDEAB563E4940 \N 1 D_ 00127 \N \N \N \N \N \N \N \N -129 06 D_ 00129 Calden 0 06633005 0 DE734 5 32522395 5698475 \N 2013-08-12 07:57:26.332873 51.43703 9.32219000000000086 0101000020E61000004D327216F6A4224079AF5A99F0B74940 \N 1 D_ 00129 \N \N \N \N \N \N \N \N -131 06 D_ 00131 Witzenhausen 0 06636016 0 DE737 5 32558542 5688717 \N 2013-08-12 07:57:26.332873 51.3467100000000016 9.84057999999999922 0101000020E6100000E657738060AE23401C9947FE60AC4940 \N 1 D_ 00131 \N \N \N \N \N \N \N \N -138 06 D_ 00138 Bad Schwalbach 0 06439002 0 DE71D 5 32432747 5554830 \N 2013-08-12 07:57:26.332873 50.1418800000000005 8.05880999999999936 0101000020E6100000035B25581C1E20406EFAB31F29124940 \N 1 D_ 00138 \N \N \N \N \N \N \N \N -161 06 D_ 00161 Pfungstadt 0 06432018 0 DE716 5 32470178 5516260 \N 2013-08-12 07:57:26.332873 49.7980500000000035 8.58561000000000085 0101000020E6100000CF6BEC12D52B214052499D8026E64840 \N 1 D_ 00161 \N \N \N \N \N \N \N \N -162 06 D_ 00162 Fulda 0 06631009 0 DE732 5 32546674 5604269 \N 2013-08-12 07:57:26.332873 50.5884599999999978 9.65934999999999988 0101000020E6100000363CBD5296512340888043A8524B4940 \N 1 D_ 00162 \N \N \N \N \N \N \N \N +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; +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 +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 \. diff -r f5bedfc7bcc6 -r 6f206d8eab7e db_schema/stammdaten_schema.sql --- a/db_schema/stammdaten_schema.sql Thu Dec 08 11:09:02 2016 +0100 +++ b/db_schema/stammdaten_schema.sql Thu Dec 08 14:30:35 2016 +0100 @@ -431,8 +431,6 @@ koord_y_extern character varying(22) NOT NULL, hoehe_land real, letzte_aenderung timestamp without time zone DEFAULT now(), - latitude double precision, - longitude double precision, geom public.geometry(Point,4326), shape public.geometry(MultiPolygon,4326), ort_typ smallint REFERENCES ort_typ,