gistfile1.sql

UPDATE zip_nyc o SET o.the_geom = n.the_geom\n                      FROM ( VALUES\n                      (ST_SetSRID(ST_GeomFromText('MULTIPOLYGON (((-60.22 -80.28584, -60.90862 -80.74834, -61.84389 -80.8364, -67.03195 -80.1664, -62.55 -80.2589, -60.69501 -79.61, -60.17361 -79.71167, -60.22 -80.28584)), ((162.15973 -79.06168, 161.94779 -79.03084, 161.92584 -78.98167, 162.15973 -79.06168)), ((-162.13336 -78.74112, -158.5325 -79.7139, -161.08585 -79.83528, -163.81641 -79.2075, -162.13336 -78.74112)), ((-39.9725 -78.55473, -37.45945 -78.64029, -41.93056 -78.59195, -39.9725 -78.55473)), ((-70.94556 -79.65001, -71.85529 -79.42029, -70.30417 -78.80528, -67.31723 -78.50362, -70.94556 -79.65001)), ((167.31555 -78.25362, 166.87164 -78.20808, 167.67749 -78.11752, 167.31555 -78.25362)), ((166.35221 -78.31363, 166.06555 -78.11475, 166.77417 -78.22112, 166.35221 -78.31363)), ((-44.11445 -78.6989, -45.57528 -78.85196, -43.79333 -79.00362, -44.58334 -79.33389, -43.46612 -79.47029, -43.35445 -79.77972, -44.5725 -80.09222, -44.06667 -80.25751, -44.28639 -80.33974, -52.05556 -80.90279, -54.90889 -80.71861, -50.66611 -79.58862, -50.18362 -78.65056, -48.27278 -78.05639, -44.84195 -78.10139, -43.89111 -78.36195, -44.11445 -78.6989)), ((-148.76114 -77.44223, -149.03528 -77.41695, -148.82947 -77.4014, -148.76114 -77.44223)), ((-150.20752 -77.37001, -151.19391 -77.27196, -150.07642 -77.34056, -150.20752 -77.37001)), ((-148.85861 -77.35474, -149.51947 -77.29085, -149.16168 -77.2589, -148.85861 -77.35474)), ((167.71695 -77.40584, 169.45111 -77.49669, 166.77664 -77.85779, 166.54776 -77.70668, 166.88251 -77.67195, 166.21335 -77.53864, 166.63165 -77.17281, 167.71695 -77.40584)), ((-147.25223 -77.16556, -147.53281 -77.15195, -147.0625 -77.17389, -147.25223 -77.16556)), ((-147.89697 -77.42973, -148.8642 -77.27084, -148.46445 -77.07056, -147.70889 -77.18945, -147.59085 -77.33168, -147.89697 -77.42973)), ((-147.63364 -77.10335, -147.8353 -77.03473, -147.65472 -77.04001, -147.63364 -77.10335)), ((-148.51169 -76.90779, -148.2067 -76.97806, -149.19473 -76.95056, -148.51169 -76.90779)), ((-149.47836 -76.89835, -149.07251 -77.10085, -150.73639 -76.95113, -149.47836 -76.89835)), ((-146.71085 -76.97917, -146.99167 -76.85139, -146.22336 -76.89751, -146.71085 -76.97917)), ((-148.53391 -76.7225, -148.15723 -76.76529, -149.16919 -76.73222, -148.53391 -76.7225)), ((-149.83197 -76.66446, -150.32086 -76.78168, -150.70142 -76.71945, -149.83197 -76.66446)), ((-148.40945 -76.68945, -148.77475 -76.65279, -148.61917 -76.61806, -148.40945 -76.68945)), ((-147.43362 -76.68861, -147.95419 -76.59112, -147.5914 -76.5939, -147.43362 -76.68861)), ((-146.77225 -76.71417, -147.2514 -76.57695, -146.76083 -76.57056, -146.77225 -76.71417)), ((-147.34723 -76.61389, -147.61807 -76.55695, -147.47473 -76.55751, -147.34723 -76.61389)), ((168.60333 -76.23279, 168.36109 -76.16251, 168.49082 -76.15862, 168.60333 -76.23279)), ((-146.58557 -76.30556, -147.27808 -76.11334, -146.77612 -76.08723, -146.57306 -76.22029, -146.58557 -76.30556)), ((-146.79056 -75.85583, -147.00363 -75.81946, -146.85947 -75.80556, -146.79056 -75.85583)), ((-145.1539 -75.73668, -145.86728 -75.60455, -145.57169 -75.55278, -145.1539 -75.73668)), ((-143.0014 -75.52612, -143.28085 -75.49167, -143.08224 -75.46529, -143.0014 -75.52612)), ((-132.37195 -74.46417, -132.66196 -74.41917, -132.20529 -74.3925, -132.37195 -74.46417)), ((-131.38974 -74.34695, -130.74475 -74.41501, -132.00778 -74.42917, -131.38974 -74.34695)), ((-127.39111 -74.58029, -128.16086 -74.25418, -127.03612 -74.39223, -127.39111 -74.58029)), ((-117.11418 -74.33417, -117.19833 -74.32834, -116.75168 -74.24722, -117.11418 -74.33417)), ((-20.4675 -74.33029, -20.11945 -74.85057, -21.60361 -74.45084, -20.36945 -74.12167, -20.4675 -74.33029)), ((-115.93028 -73.96194, -116.27362 -74.15362, -117.24112 -74.1875, -115.93028 -73.96194)), ((-122.14973 -73.61446, -118.54945 -73.92889, -122.13223 -74.36806, -122.63 -74.32085, -122.41446 -73.87056, -123.15939 -73.73404, -122.14973 -73.61446)), ((169.82443 -73.59558, 169.38803 -73.53308, 169.86859 -73.28917, 169.82443 -73.59558)), ((-78.04807 -73.44223, -78.34612 -73.25279, -77.6364 -73.3, -78.04807 -73.44223)), ((-126.11835 -73.24722, -125.13417 -73.71806, -124.23056 -73.68918, -123.72417 -74.10057, -125.25279 -74.0639, -127.3925 -73.41779, -126.11835 -73.24722)), ((-73.89111 -73.425, -74.06418 -73.32556, -73.4989 -73.15362, -73.89111 -73.425)), ((-104.86501 -73.23889, -105.24112 -73.05473, -104.55029 -73.18668, -104.86501 -73.23889)), ((-89.74501 -72.87556, -89.45668 -72.91362, -90.37946 -73.04779, -89.74501 -72.87556)), ((-74.22278 -72.97612, -74.46556 -73.64835, -76.09361 -73.20946, -75.39528 -73.06001, -75.72029 -72.94556, -75.38612 -72.81807, -74.22278 -72.97612)), ((-93.75945 -72.91167, -94.13806 -72.83917, -93.80585 -72.815, -93.75945 -72.91167)), ((-98.14806 -72.73001, -98.34361 -72.69945, -97.82529 -72.66335, -98.14806 -72.73001)), ((-99.74084 -72.62361, -98.93028 -72.67361, -100.85861 -72.66556, -99.74084 -72.62361)), ((-95.33139 -72.67195, -95.51834 -72.64944, -94.69676 -72.6142, -95.33139 -72.67195)), ((-91.33723 -73.15695, -91.61723 -72.60474, -90.80639 -72.59279, -91.33723 -73.15695)), ((-93.36528 -72.65445, -93.46143 -72.58452, -93.17029 -72.57556, -93.36528 -72.65445)), ((-61.03861 -72.55972, -61.135 -72.54501, -60.97 -72.52751, -61.03861 -72.55972)), ((-78.42001 -72.56778, -77.43918 -72.58862, -77.59445 -72.91, -78.80637 -73.18166, -79.42168 -72.96001, -78.84167 -72.77139, -79.4614 -72.56639, -79.24751 -72.40251, -78.42001 -72.56778)), ((-68.81612 -72.47446, -68.97751 -72.46056, -68.59807 -72.38583, -68.81612 -72.47446)), ((-60.33694 -72.25751, -60.50194 -72.19972, -60.34361 -72.19417, -60.33694 -72.25751)), ((68.48201 -72.27779, 68.69313 -72.08891, 68.82002 -72.16528, 68.48201 -72.27779)), ((69.79756 -72.03308, 69.77309 -71.92363, 69.95729 -71.91864, 69.79756 -72.03308)), ((-98.80307 -71.88667, -98.2975 -71.87195, -98.56056 -72.13112, -98.19667 -72.19917, -98.13631 -71.8929, -97.6864 -72.18195, -97.34946 -71.8625, -96.65056 -71.87334, -96.34264 -72.0022, -97.25806 -72.22223, -95.99515 -72.08, -95.82167 -72.18945, -96.59612 -72.28667, -95.67584 -72.36057, -98.61612 -72.56889, -102.56279 -72.12473, -100.41446 -71.88139, -100.06166 -71.93513, -100.51056 -72.02362, -100.235 -72.13084, -98.83307 -72.13139, -99.30751 -71.94389, -98.80307 -71.88667)), ((0.45203 -71.10059, 0.23981 -71.03362, 0.58673 -71.06445, 0.45203 -71.10059)), ((-60.53553 -71.05635, -60.95917 -70.94528, -60.62473 -70.88501, -60.53553 -71.05635)), ((-7.87944 -70.7339, -8.04361 -70.70001, -7.72528 -70.71028, -7.87944 -70.7339)), ((-2.39 -70.75195, -1.98278 -70.81639, -2.79639 -71.03973, -3.455 -70.69307, -2.39 -70.75195)), ((-73.68529 -70.68028, -74.30612 -71.01028, -76.63501 -71.06029, -73.68529 -70.68028)), ((2.05066 -70.69972, 1.89593 -70.64612, 2.21673 -70.6364, 2.05066 -70.69972)), ((-60.81945 -70.66223, -61.15917 -70.57584, -60.63139 -70.54834, -60.81945 -70.66223)), ((2.95758 -70.625, 2.61316 -70.50502, 3.32733 -70.46892, 2.95758 -70.625)), ((-6.04028 -70.57918, -6.37668 -70.47607, -5.96985 -70.41795, -6.04028 -70.57918)), ((-3.12806 -70.50418, -3.32972 -70.48334, -2.64417 -70.41528, -3.12806 -70.50418)), ((163.38614 -70.38057, 163.3053 -70.34918, 163.48334 -70.3539, 163.38614 -70.38057)), ((72.22701 -70.61308, 71.68813 -70.33835, 71.93007 -70.29417, 72.22701 -70.61308)), ((-1.79028 -70.23195, -1.97305 -70.18167, -1.89722 -70.1689, -1.79028 -70.23195)), ((13.10955 -70.05725, 13.22119 -70.13751, 12.48174 -70.11057, 13.10955 -70.05725)), ((15.99285 -70.17224, 15.36035 -70.0289, 16.36205 -70.01752, 15.99285 -70.17224)), ((-61.385 -70.01529, -61.52806 -69.96529, -61.2925 -69.93417, -61.385 -70.01529)), ((-74.84222 -69.81584, -74.45251 -70.02167, -75.86139 -70.05528, -74.84222 -69.81584)), ((38.23149 -69.67807, 38.05619 -69.63669, 38.23149 -69.64667, 38.23149 -69.67807)), ((-72.35529 -69.75751, -72.94528 -69.60085, -72.04445 -69.69307, -72.35529 -69.75751)), ((-62.04223 -69.72, -62.32722 -69.10751, -61.71556 -69.46861, -62.04223 -69.72)), ((155.87363 -69.15112, 155.52585 -69.00058, 155.8837 -69.05898, 155.87363 -69.15112)), ((155.20084 -69.04611, 154.95392 -69.01723, 155.3089 -68.98114, 155.20084 -69.04611)), ((-70.15695 -68.84862, -70.08417 -69.26363, -68.37723 -70.64944, -68.0714 -71.63834, -68.39168 -72.2339, -69.26001 -72.56418, -72.37611 -72.72778, -73.19446 -72.43139, -70.52196 -72.20778, -72.04501 -72.19446, -70.94724 -72.03889, -72.2675 -71.64612, -72.86667 -71.93417, -73.87918 -71.82056, -73.58112 -72.04723, -74.04333 -72.20889, -75.46612 -71.85112, -75.14195 -71.57779, -74.43584 -71.69307, -74.38918 -71.43417, -73.52917 -71.64334, -73.67917 -71.35806, -72.41196 -71.3364, -73.15973 -71.18501, -72.92639 -71.11584, -70.61389 -71.1664, -71.02084 -70.80334, -72.46085 -70.60196, -71.38918 -70.23001, -71.815 -69.98418, -71.64584 -69.5175, -72.25334 -69.20723, -70.15695 -68.84862)), ((-90.59445 -68.92584, -90.7514 -68.79918, -90.48695 -68.82779, -90.59445 -68.92584)), ((-63.44695 -68.85139, -63.62778 -68.79695, -63.41334 -68.83723, -63.44695 -68.85139)), ((-60.71806 -68.75473, -61.08167 -68.67946, -60.82973 -68.66112, -60.71806 -68.75473)), ((-67.50751 -67.81001, -67.81529 -67.68918, -67.08417 -67.63139, -67.50751 -67.81001)), ((47.67118 -67.58669, 47.89804 -67.59428, 47.40787 -67.62473, 47.67118 -67.58669)), ((59.35531 -67.33168, 59.26926 -67.29028, 59.41647 -67.32057, 59.35531 -67.33168)), ((164.78723 -67.59529, 164.56168 -67.27167, 164.84003 -67.42363, 164.78723 -67.59529)), ((58.64255 -67.12642, 58.52865 -67.1178, 58.67147 -67.12001, 58.64255 -67.12642)), ((58.86062 -67.12195, 58.77419 -67.10861, 58.8248 -67.10225, 58.86062 -67.12195)), ((50.34647 -67.11639, 50.13065 -67.07419, 50.25009 -67.06779, 50.34647 -67.11639)), ((48.79398 -66.75613, 48.39732 -66.89029, 48.29148 -66.82001, 48.79398 -66.75613)), ((86.06532 -67.00113, 85.37282 -66.74669, 85.87197 -66.7739, 86.1839 -66.92252, 86.06532 -67.00113)), ((86.4928 -66.77473, 86.3017 -66.71114, 86.73201 -66.71223, 86.4928 -66.77473)), ((-67.24417 -66.74779, -67.54195 -66.86974, -67.45973 -66.69724, -67.24417 -66.74779)), ((-68.10028 -67.39334, -68.565 -67.74806, -69.2289 -67.5414, -67.58556 -66.61389, -67.91084 -66.84889, -67.67473 -67.15918, -68.10028 -67.39334)), ((99.2945 -66.74861, 99.21588 -66.72307, 99.52088 -66.59003, 99.2945 -66.74861)), ((163.10697 -66.75613, 162.94919 -66.57224, 163.11835 -66.62306, 163.10697 -66.75613)), ((85.33284 -66.62862, 85.15199 -66.59029, 85.2842 -66.52029, 85.33284 -66.62862)), ((98.77197 -66.49197, 98.60199 -66.43333, 98.86279 -66.45447, 98.77197 -66.49197)), ((97.22919 -66.4664, 97.08838 -66.41528, 97.35311 -66.42389, 97.22919 -66.4664)), ((162.56809 -66.43503, 162.30029 -66.18892, 162.60141 -66.35059, 162.56809 -66.43503)), ((100.27307 -66.19279, 100.22974 -66.1489, 100.35168 -66.14363, 100.27307 -66.19279)), ((96.76752 -66.25974, 96.26001 -66.18892, 96.8478 -66.12169, 96.76752 -66.25974)), ((-66.73222 -66.31056, -66.74306 -66.11778, -66.57556 -66.08806, -66.73222 -66.31056)), ((100.55475 -66.14723, 100.61865 -66.04695, 100.75641 -66.07919, 100.55475 -66.14723)), ((100.82141 -66.02695, 100.77283 -66.01334, 100.81726 -65.99753, 100.82141 -66.02695)), ((100.92755 -66.00557, 100.84363 -65.98308, 100.95893 -65.96834, 100.92755 -66.00557)), ((100.77057 -65.86139, 100.70807 -65.83279, 100.99811 -65.80891, 100.77057 -65.86139)), ((92.69893 -65.79836, 92.26892 -65.76418, 92.49506 -65.67224, 92.69893 -65.79836)), ((-65.66695 -65.68723, -66.16112 -65.86889, -65.91833 -65.52972, -65.66695 -65.68723)), ((100.755 -65.67862, 100.24695 -65.58362, 101.25665 -65.50377, 100.755 -65.67862)), ((103.2428 -65.29584, 103.47253 -65.45001, 102.77394 -65.14029, 103.2428 -65.29584)), ((-59.43611 -65.25584, -59.81306 -65.10722, -59.53306 -65.10945, -59.43611 -65.25584)), ((-63.14417 -64.7814, -63.32445 -64.91196, -63.555 -64.89307, -63.14417 -64.7814)), ((-57.27917 -64.5525, -57.48862 -64.4964, -56.855 -64.33862, -57.27917 -64.5525)), ((-63.30667 -64.42862, -62.76028 -64.56029, -63.64001 -64.83389, -64.22057 -64.67334, -63.08945 -64.29668, -63.30667 -64.42862)), ((-56.815 -64.31696, -56.75834 -64.23779, -56.57556 -64.21973, -56.815 -64.31696)), ((-62.3 -64.43445, -62.70473 -64.46612, -62.48056 -64.04333, -62.01167 -64.21417, -62.3 -64.43445)), ((-57.81583 -63.9614, -57.03334 -64.1725, -57.91278 -64.44528, -58.23945 -64.32501, -58.08083 -64.08473, -58.42861 -64.11334, -57.81583 -63.9614)), ((-57.57056 -63.78778, -57.04556 -63.82278, -57.69473 -63.81639, -57.57056 -63.78778)), ((-60.73833 -63.86834, -60.76417 -63.66056, -60.53139 -63.65167, -60.73833 -63.86834)), ((-55.97667 -63.58139, -56.20556 -63.45278, -55.70778 -63.45251, -55.97667 -63.58139)), ((-62.15417 -63.32417, -62.26028 -63.25389, -61.94333 -63.28167, -62.15417 -63.32417)), ((-56.9464 -63.45056, -56.72139 -63.59473, -57.38 -63.46056, -58.60084 -63.94889, -58.77864 -64.53581, -59.49306 -64.31612, -59.50528 -64.53723, -59.91889 -64.41223, -61.95945 -65.18028, -62.08973 -65.44029, -61.68306 -65.53862, -62.45972 -65.90472, -61.87278 -66.17195, -60.5575 -65.94528, -60.93695 -66.26001, -61.41667 -66.12529, -61.71389 -66.46918, -62.18139 -66.18028, -62.88528 -66.26279, -62.44361 -66.43028, -62.60889 -66.72835, -63.67556 -66.21834, -64.19667 -66.72029, -63.74361 -66.89168, -64.83778 -66.9514, -64.77057 -67.31723, -65.61389 -67.55917, -65.29028 -67.67334, -65.61778 -67.88, -65.32918 -67.97473, -65.72362 -68.14806, -64.76834 -68.12279, -65.59668 -68.3475, -65.09167 -68.44196, -65.31334 -68.7114, -63.85778 -68.84279, -64.39001 -68.51334, -62.72834 -68.41, -63.97417 -68.53639, -63.21056 -68.78696, -63.70667 -68.74251, -63.36806 -69.05, -63.63889 -69.22723, -62.47584 -69.45306, -62.635 -69.85335, -61.94083 -70.22917, -62.49084 -70.38057, -61.48445 -70.52028, -62.12889 -70.86557, -61.38028 -70.81529, -60.9425 -71.15834, -61.92973 -71.6564, -60.90417 -71.73639, -62.5525 -72.0475, -60.86584 -72.00307, -61.07472 -72.16362, -60.8525 -72.3889, -61.54973 -72.42279, -61.27084 -72.70029, -60.61611 -72.64334, -60.61723 -73.02862, -59.77417 -72.90028, -59.84945 -73.23306, -60.59972 -73.36029, -61.91945 -73.14307, -61.43639 -73.34361, -61.83667 -73.36639, -61.60917 -73.54611, -60.58778 -73.70612, -61.7625 -73.91389, -61.03639 -74.09834, -61.75528 -74.30639, -61.8875 -74.83223, -62.53139 -74.98251, -63.24583 -74.60417, -63.05139 -74.89528, -63.98945 -75.00806, -63.09584 -75.13084, -64.44778 -75.29779, -63.09473 -75.32556, -63.42917 -75.45056, -69.38528 -76.29611, -70.47639 -76.70778, -75.44446 -76.5464, -76.38057 -76.065, -77.77167 -75.9189, -78.47667 -76.40723, -75.63278 -77.50862, -72.83974 -77.64001, -74.85335 -78.14111, -81.49695 -77.65779, -80.60556 -77.8864, -81.47 -77.89723, -77.4875 -78.52667, -78.9575 -78.81334, -84.10779 -78.36084, -80.63556 -79.61917, -80.20279 -79.2289, -77.02945 -79.27945, -76.08362 -79.64584, -77.32195 -80.0114, -79.84946 -79.95445, -76.08945 -80.19724, -74.69389 -80.69724, -59.64806 -82.4339, -58.78306 -82.645, -59.07973 -82.96584, -58.21084 -83.03334, -53.72584 -82.15028, -43.08445 -81.85139, -41.48889 -81.38335, -28.31945 -80.27695, -28.0625 -80.00473, -30.21056 -79.66667, -27.08556 -79.01334, -33.00111 -79.4539, -36.30278 -78.77917, -33.88612 -77.66057, -28.30528 -76.56529, -17.75806 -75.72974, -18.25639 -75.49583, -17.14722 -74.78473, -13.70472 -73.94196, -16.32611 -74.0639, -16.91917 -73.97612, -16.06917 -73.74751, -16.89889 -73.77306, -16.02361 -73.32028, -13.73111 -73.02084, -14.46917 -72.79668, -13.40611 -72.82306, -11.65778 -72.32695, -11.32583 -71.96501, -12.27695 -71.3775, -11.55651 -71.27882, -11.59278 -71.56195, -11.01945 -71.65723, -10.04861 -71.11139, -10.43 -70.98695, -9.87871 -70.90097, -8.93083 -71.23361, -8.36695 -71.82584, -7.33778 -71.69196, -7.72333 -71.42917, -6.02111 -70.69972, -5.44111 -70.88251, -6.10389 -71.14445, -6.00917 -71.4189, -2.26167 -71.17084, -2.09389 -71.48611, -1.05333 -71.27667, -0.77722 -71.38918, -0.92306 -71.58917, -0.2975 -71.65889, 2.80316 -70.84695, 6.69952 -70.5864, 7.55731 -70.16835, 8.48065 -70.47725, 9.09039 -70.31834, 8.68286 -70.07446, 11.27062 -70.71028, 12.04675 -70.71751, 12.74035 -70.28113, 14.16564 -70.15891, 15.70593 -70.27862, 18.03649 -69.96918, 23.24676 -70.54642, 31.08342 -69.7739, 32.90232 -69.27695, 33.44505 -68.95724, 33.42423 -68.65141, 34.14036 -68.48279, 36.41453 -69.31445, 36.12644 -69.53362, 36.72257 -69.72807, 37.91618 -69.25142, 37.85093 -69.53391, 37.14506 -69.66475, 38.23924 -69.9928, 38.56449 -69.50058, 38.65037 -69.98863, 39.70176 -69.64864, 39.76035 -68.95447, 41.10313 -68.5239, 46.30893 -67.64169, 46.24643 -67.35751, 46.55143 -67.27725, 47.44895 -67.4178, 47.0095 -67.55031, 47.39561 -67.72252, 48.21701 -67.63445, 49.16727 -67.38336, 48.26286 -67.16753, 49.16397 -66.86281, 49.1517 -67.08862, 50.68949 -67.18139, 50.16977 -66.74306, 50.41312 -66.44197, 53.77896 -65.84003, 55.61923 -66.00696, 57.31198 -66.56334, 56.72952 -66.90112, 59.11062 -67.41223, 69.64479 -67.75391, 70.10201 -68.5239, 69.29201 -69.10278, 69.74312 -69.36308, 68.87117 -69.37947, 69.34004 -69.63863, 69.20534 -69.86391, 68.09474 -69.87947, 67.64614 -70.3864, 68.59395 -70.77058, 68.8503 -70.53224, 68.6617 -70.3678, 69.14479 -70.33139, 69.24391 -70.67058, 67.6053 -71.58308, 67.90114 -71.64447, 67.33756 -72.06334, 68.93642 -72.425, 70.86495 -71.93015, 71.44979 -71.54611, 71.24813 -71.38945, 71.50447 -70.9539, 72.86312 -70.43279, 72.61562 -70.20361, 72.90114 -70.02196, 77.74727 -69.11697, 78.11641 -68.45973, 82.05727 -67.67224, 81.46974 -67.50529, 82.01448 -67.25168, 82.66504 -67.39389, 83.4034 -67.15668, 85.79169 -67.17778, 87.50252 -66.89474, 88.1095 -66.65253, 88.22724 -66.03639, 88.96723 -66.7614, 92.00531 -66.53391, 97.56446 -66.74057, 98.26196 -66.51611, 99.28308 -66.88084, 100.95392 -66.08084, 102.62616 -65.90112, 107.80478 -66.39836, 108.82422 -66.83113, 110.62976 -66.48668, 110.89173 -66.06363, 113.31534 -65.71335, 114.43143 -66.17947, 114.51836 -66.47278, 116.18004 -66.36668, 117.767 -66.98975, 122.18336 -66.54781, 125.19002 -66.73419, 126.35616 -66.27972, 126.98836 -66.45358, 126.92865 -66.83446, 128.83478 -67.14252, 130.35199 -66.22585, 134.2453 -66.20113, 134.4364 -66.00142, 134.10062 -65.12306, 134.43784 -64.92613, 135.27225 -65.4364, 134.94779 -66.09306, 142.56641 -66.99417, 143.40003 -66.85114, 144.58557 -67.24529, 145.40445 -67.01723, 145.87531 -67.19586, 145.315 -67.61334, 146.64279 -67.70946, 147.15085 -67.99086, 146.95334 -68.14169, 148.02945 -67.84447, 148.64807 -67.9892, 148.21723 -68.12724, 148.81336 -68.33528, 150.99253 -68.39085, 151.18503 -68.98003, 153.76862 -68.92224, 153.77835 -68.34363, 154.68585 -68.615, 154.28668 -68.86308, 154.85669 -69.10252, 156.33612 -69.24057, 157.23639 -68.94252, 160.9689 -70.25557, 162.75391 -70.2803, 163.52085 -70.675, 163.78528 -70.62807, 163.5539 -70.46529, 166.77167 -70.61168, 166.46305 -70.70195, 167.76752 -70.78084, 170.27225 -71.66002, 170.21527 -71.28279, 170.45304 -71.35167, 170.99445 -71.8642, 170.12998 -72.05141, 169.87164 -72.3792, 170.30417 -72.30084, 170.32224 -72.58031, 169.26642 -73.08391, 169.07916 -73.52753, 167.56168 -73.40335, 165.54859 -73.93251, 166.12915 -74.12724, 164.78086 -74.13696, 165.33331 -74.67281, 164.14252 -74.61612, 163.65668 -74.77446, 163.87168 -74.95335, 162.53974 -75.10892, 163.13696 -75.93668, 162.3378 -76.16724, 162.87558 -76.24779, 162.93225 -76.58308, 162.62363 -76.61946, 163.06973 -76.73085, 162.3328 -76.95142, 163.23834 -77.0414, 163.89697 -77.46669, 163.61084 -77.69612, 164.565 -77.73639, 164.2067 -78.14389, 165.54001 -78.00336, 165.6836 -78.39169, 167.26944 -78.65584, 164.49445 -78.56975, 160.49417 -79.02086, 160.04056 -79.15584, 160.73807 -79.45308, 159.09281 -79.97112, 160.52445 -80.0414, 158.05725 -80.28056, 160.89197 -80.3775, 159.75696 -80.56975, 161.17447 -80.63556, 160.01557 -80.7803, 160.8439 -80.89307, 160.50308 -80.95279, 160.83945 -81.07808, 160.62613 -81.20502, 162.19391 -81.29781, 160.39112 -81.52141, 162.27585 -81.66223, 163.85947 -82.17418, 163.44614 -82.26503, 168.69248 -83.14641, 167.46973 -83.43918, 169.25083 -83.33002, 172.31861 -83.59723, 171.90503 -83.8017, 180.0 -84.30225, 180.0 -90.0, -180.0 -90.0, -180.0 -84.30534, -157.48334 -85.44862, -150.23947 -85.46362, -148.13834 -85.09084, -139.66141 -85.24501, -138.58945 -84.98473, -149.29474 -84.56195, -153.05307 -84.01279, -153.00751 -83.08751, -151.79419 -82.57779, -154.89142 -81.90501, -153.9892 -81.62918, -154.20502 -81.55223, -156.96002 -81.25168, -154.92169 -81.00195, -148.41336 -81.35751, -145.52417 -80.46056, -146.81195 -79.88751, -155.9064 -78.71973, -153.75031 -78.30833, -157.91028 -78.00195, -158.17584 -77.85973, -157.69696 -77.5714, -157.75308 -77.10806, -156.48334 -77.35861, -155.86139 -77.08446, -153.79028 -77.17473, -153.08362 -77.28667, -153.10641 -77.49722, -152.06113 -77.32529, -149.66223 -77.76112, -149.08725 -77.69612, -149.41418 -77.57085, -148.73279 -77.62556, -148.58557 -77.59445, -148.58112 -77.50446, -147.5914 -77.42223, -147.49307 -77.29695, -147.07169 -77.37279, -147.03223 -77.22084, -146.26862 -77.4664, -145.87891 -77.30639, -146.22751 -77.16501, -145.8428 -77.11418, -146.30139 -76.99918, -145.29889 -77.02917, -146.10223 -76.84001, -145.45639 -76.76028, -146.93225 -76.45195, -149.50613 -76.38751, -148.10129 -76.09566, -146.49167 -76.36751, -145.47946 -76.44334, -146.29529 -76.03973, -134.30389 -74.53279, -133.26251 -74.84723, -121.47835 -74.74251, -118.53168 -74.61362, -117.74306 -74.30862, -117.39696 -74.53084, -114.69778 -74.46918, -114.81001 -74.10474, -114.00362 -73.88918, -113.1864 -74.1689, -113.43362 -74.47223, -112.93028 -74.455, -113.55556 -74.63445, -112.65417 -74.85861, -111.34306 -74.75945, -111.72446 -74.58723, -111.38583 -74.46223, -111.50389 -74.19168, -110.15471 -74.28418, -109.92889 -74.7614, -110.96167 -75.15779, -110.38306 -75.30612, -99.51028 -75.09251, -100.85167 -74.81473, -100.15112 -74.76083, -100.51556 -74.67111, -100.24806 -74.49084, -101.33195 -74.48056, -101.65834 -73.9989, -102.9014 -73.87584, -103.01334 -73.62918, -99.17557 -73.61917, -103.03612 -73.3264, -103.60335 -72.89195, -103.17612 -72.73334, -102.09917 -73.08473, -90.86111 -73.32668, -89.32112 -73.05417, -89.53723 -72.63362, -89.26112 -72.63945, -88.33585 -72.81612, -88.70917 -73.17946, -86.84084 -73.3364, -85.96667 -73.0414, -85.47084 -73.34973, -85.59973 -73.55833, -82.13417 -73.94334, -81.0414 -73.71556, -81.27528 -73.36945, -80.51918 -73.4464, -80.69556 -73.05057, -78.95889 -73.3925, -78.78973 -73.69307, -76.61835 -73.57668, -76.96278 -73.87306, -69.42834 -73.19724, -66.79723 -72.40779, -66.85918 -71.89557, -67.53723 -71.45473, -67.40028 -71.04001, -67.7039 -70.59306, -68.83806 -69.41724, -66.65779 -69.01779, -67.49445 -68.81557, -66.93224 -68.7739, -67.16556 -68.29333, -66.58974 -68.23807, -67.15723 -68.01056, -66.42723 -67.53334, -67.6239 -67.55362, -67.48584 -67.07722, -66.40472 -66.88556, -66.49722 -66.62251, -65.68973 -66.125, -64.45334 -65.98167, -64.65973 -65.74028, -63.71278 -65.5025, -64.05307 -65.42195, -63.87945 -65.01834, -63.09056 -65.1339, -62.93806 -64.7975, -62.31945 -64.8589, -62.61778 -64.755, -62.45361 -64.58917, -61.93528 -64.69057, -60.94195 -64.27751, -60.99167 -64.03584, -59.44584 -63.89306, -58.91084 -63.53306, -57.205 -63.20556, -56.9464 -63.45056)), ((-55.47 -63.14333, -55.00278 -63.28389, -56.54333 -63.36445, -55.47 -63.14333)), ((-56.26501 -63.16945, -56.58472 -63.035, -55.97084 -63.05445, -56.26501 -63.16945)), ((-60.47184 -62.9009, -60.58 -63.00806, -60.74248 -62.97399, -60.47184 -62.9009)), ((-62.69139 -63.095, -62.48945 -62.92111, -62.26056 -62.88167, -62.69139 -63.095)), ((-61.35861 -62.81361, -61.47917 -62.75389, -61.15056 -62.70862, -61.35861 -62.81361)), ((-60.51667 -62.55389, -59.81695 -62.61417, -61.1725 -62.575, -60.51667 -62.55389)), ((-59.66556 -62.55695, -59.97917 -62.45084, -59.54223 -62.49861, -59.66556 -62.55695)), ((-59.43917 -62.44723, -59.67834 -62.36389, -59.32751 -62.37139, -59.43917 -62.44723)), ((-58.9925 -62.34778, -59.20889 -62.28556, -58.81639 -62.29806, -58.9925 -62.34778)), ((-57.62195 -61.90973, -58.98639 -62.21445, -58.40028 -61.93861, -57.62195 -61.90973)), ((-55.09222 -61.09806, -54.64639 -61.09278, -55.49445 -61.12667, -55.09222 -61.09806)), ((-54.04695 -61.26945, -54.20056 -61.23611, -54.03223 -61.08806, -54.04695 -61.26945)), ((-44.42806 -60.72334, -44.78473 -60.73445, -44.53139 -60.67556, -44.42806 -60.72334)), ((-45.00528 -60.72528, -45.07111 -60.63111, -45.02584 -60.64194, -45.00528 -60.72528)), ((-45.55083 -60.54723, -45.14528 -60.76611, -46.02361 -60.61084, -45.55083 -60.54723)))'), 4326), 1),(ST_SetSRID(ST_GeomFromText('MULTIPOLYGON (((166.92914 -0.55222, 166.93054 -0.49333, 166.95859 -0.50639, 166.92914 -0.55222)))'), 4326), 2)\n                      ) AS n(the_geom, ogc_fid)\n                      WHERE o.ogc_fid = n.ogc_fid;