locations.sql

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            1,
            'Holocaust-Mahnmal',
            st_geomfromtext('POINT(13.378701975948216 52.51404529831979)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            2,
            'Berliner Dom',
            st_geomfromtext('POINT(13.400960063143167 52.519325345875124)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            3,
            'Berliner Fernsehturm',
            st_geomfromtext('POINT(13.409411707854149 52.52082449251492)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            4,
            'St.-Michael-Kirche',
            st_geomfromtext('POINT(13.419351657463123 52.50749006741388)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            5,
            'Schloss Charlottenburg',
            st_geomfromtext('POINT(13.295362740207302 52.52157410771644)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            6,
            'Sowjetisches Ehrenmal',
            st_geomfromtext('POINT(13.471700152538357 52.486557544070195)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            7,
            'Stasimuseum',
            st_geomfromtext('POINT(13.487353690260543 52.51460060417056)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            8,
            'Schloss Babelsberg',
            st_geomfromtext('POINT(13.09330549624625 52.40776173475853)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            9,
            'Olympiastadion Berlin',
            st_geomfromtext('POINT(13.239477246457783 52.514781938593515)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            10,
            'Zitadelle Spandau',
            st_geomfromtext('POINT(13.21245708237107 52.54163745998027)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            11,
            'Waldbühne Berlin',
            st_geomfromtext('POINT(13.229290611117538 52.51559549513888)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            12,
            'Checkpoint Charlie',
            st_geomfromtext('POINT(13.390356806857138 52.50751916571093)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            13,
            'Charité',
            st_geomfromtext('POINT(13.376241416814793 52.526398932335994)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            14,
            'Stadion Union Berlin',
            st_geomfromtext('POINT(13.56818097852705 52.457533269658164)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            15,
            'Bundeskanzleramt',
            st_geomfromtext('POINT(13.36925035286844 52.52055361413992)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            16,
            'KulturBrauerei',
            st_geomfromtext('POINT(13.41274739530306 52.53878938608822)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            17,
            'Aquarium Berlin',
            st_geomfromtext('POINT(13.340730304977056 52.506103094582116)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            18,
            'DDR Museum',
            st_geomfromtext('POINT(13.402721758577513 52.51968531610953)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            19,
            'Rotes Rathaus',
            st_geomfromtext('POINT(13.408643404761339 52.51833932246615)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            20,
            'Berliner Stadtmauer',
            st_geomfromtext('POINT(13.413651936635981 52.517861045918686)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            21,
            'Oberbaumbrücke',
            st_geomfromtext('POINT(13.445678759651335 52.50180311177181)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            22,
            'Jüdisches Museum',
            st_geomfromtext('POINT(13.395441731610548 52.502349460124755)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            23,
            'Deutsches Technikmuseum',
            st_geomfromtext('POINT(13.377822343983418 52.498836842881545)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            24,
            'Molecule Man',
            st_geomfromtext('POINT(13.459023672429623 52.497046519106604)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            25,
            'Kaiser-Wilhelm-Gedächtnis-Kirche',
            st_geomfromtext('POINT(13.335230127392673 52.504844309053546)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            26,
            'Humboldt-Universität zu Berlin',
            st_geomfromtext('POINT(13.393676567871424 52.5180853473113)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            27,
            'Botschaft Rumänien',
            st_geomfromtext('POINT(13.386411348045504 52.51874335872148)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            28,
            'Madame Tussauds',
            st_geomfromtext('POINT(13.381594681633366 52.51705278017636)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            29,
            'Grunewaldturm',
            st_geomfromtext('POINT(13.196429815297726 52.479340154020996)', 4326)
           );

INSERT INTO public."PUBLIC" (id, name, geom)
    VALUES (
            30,
            'Museum für Naturkunde',
            st_geomfromtext('POINT(13.379153434402076 52.530921291340476)', 4326)
           );