code used to update site records that had missing elevations in BETYdb

update_sites_elevations.sql

update sites set geometry=ST_SetSRID(ST_MakePoint(44.28,  -96.68,  495), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  12;
update sites set geometry=ST_SetSRID(ST_MakePoint(29.72,  -95.4,  22), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  100;
update sites set geometry=ST_SetSRID(ST_MakePoint(47.17,  -122.17,  167), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  156;
update sites set geometry=ST_SetSRID(ST_MakePoint(50.63,  -3.45,  3), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  186;
update sites set geometry=ST_SetSRID(ST_MakePoint(52.42,  0.11,  -1), 4326), notes = 'experimental site; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  199;
update sites set geometry=ST_SetSRID(ST_MakePoint(52.79,  7.09,  13), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  200;
update sites set geometry=ST_SetSRID(ST_MakePoint(52.42,  0.1,  -1), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  208;
update sites set geometry=ST_SetSRID(ST_MakePoint(52.13,  -2.64,  76), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  209;
update sites set geometry=ST_SetSRID(ST_MakePoint(53.34,  -6.25,  11), 4326), notes = 'experimental site; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  216;
update sites set geometry=ST_SetSRID(ST_MakePoint(53.33,  -6.23,  3), 4326), notes = 'experimental site; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  217;
update sites set geometry=ST_SetSRID(ST_MakePoint(52.21,  6.84,  30), 4326), notes = 'experimental site; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  223;
update sites set geometry=ST_SetSRID(ST_MakePoint(52.26,  10.52,  73), 4326), notes = 'experimental site
Hamburg University :Bundesforschungsanstalt Forst- und Holzwirtschaft: Insitiut fur Forstgenetik; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  224;
update sites set geometry=ST_SetSRID(ST_MakePoint(50.13,  8.86,  104), 4326), notes = 'experimental site; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  225;
update sites set geometry=ST_SetSRID(ST_MakePoint(53.66,  10.28,  52), 4326), notes = 'experimental site; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  226;
update sites set geometry=ST_SetSRID(ST_MakePoint(50.85,  4.35,  28), 4326), notes = 'experimental site; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  227;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.18,  16.57,  186), 4326), notes = 'experimental site; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  228;
update sites set geometry=ST_SetSRID(ST_MakePoint(44.17,  11.09,  712), 4326), notes = 'experimental site; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  229;
update sites set geometry=ST_SetSRID(ST_MakePoint(49.89,  -97.21,  234), 4326), notes = 'greenhouse; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  254;
update sites set geometry=ST_SetSRID(ST_MakePoint(53.23,  -1.11,  64), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  271;
update sites set geometry=ST_SetSRID(ST_MakePoint(38.17,  20.57,  525), 4326), notes = 'experimental field; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  281;
update sites set geometry=ST_SetSRID(ST_MakePoint(51.4,  21.95,  117), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  283;
update sites set geometry=ST_SetSRID(ST_MakePoint(31.317222,  -81.3125,  0), 4326), notes = 'interstitial salinity: 15-31%; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  285;
update sites set geometry=ST_SetSRID(ST_MakePoint(31.33,  -81.366667,  0), 4326), notes = 'interstitial salinity: 2-14%; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  286;
update sites set geometry=ST_SetSRID(ST_MakePoint(-25.416667,  -48.483333,  19), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  287;
update sites set geometry=ST_SetSRID(ST_MakePoint(31.397417,  -81.280078,  6), 4326), notes = 'near the University of Georgia Marine Institution facilities; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  288;
update sites set geometry=ST_SetSRID(ST_MakePoint(41.625767,  -71.320383,  3), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  289;
update sites set geometry=ST_SetSRID(ST_MakePoint(51.88,  0.55,  73), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  290;
update sites set geometry=ST_SetSRID(ST_MakePoint(51.89,  0.9,  35), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  291;
update sites set geometry=ST_SetSRID(ST_MakePoint(58.45,  26.77,  54), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  292;
update sites set geometry=ST_SetSRID(ST_MakePoint(32.58,  -110.85,  1190), 4326), notes = 'Intensively-managed Forest Mesocosm (IFM); elevation queried using lat lon in Google Earth', updated_at = now() where id=  293;
update sites set geometry=ST_SetSRID(ST_MakePoint(39.74,  -105.16,  1737), 4326), notes = 'elevation queried using lat lon in Google Earth', updated_at = now() where id=  294;
update sites set geometry=ST_SetSRID(ST_MakePoint(32.603385,  -85.486128,  212), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  295;
update sites set geometry=ST_SetSRID(ST_MakePoint(53,  6.67,  7), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  297;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.18,  -93.5,  318), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  299;
update sites set geometry=ST_SetSRID(ST_MakePoint(36.02,  -78.48,  130), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  302;
update sites set geometry=ST_SetSRID(ST_MakePoint(35.71,  -83.59,  1028), 4326), notes = 'Great Smoky Mountains National Park; elevation queried using lat lon in Google Earth', updated_at = now() where id=  308;
update sites set geometry=ST_SetSRID(ST_MakePoint(35.71,  -83.44,  691), 4326), notes = 'Great Smoky Mountains national park; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  309;
update sites set geometry=ST_SetSRID(ST_MakePoint(43.077455,  -89.423525,  265), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  311;
update sites set geometry=ST_SetSRID(ST_MakePoint(46.56,  -88.53,  507), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  316;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.79,  -77.86,  355), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  317;
update sites set geometry=ST_SetSRID(ST_MakePoint(51.14,  -0.84,  76), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  320;
update sites set geometry=ST_SetSRID(ST_MakePoint(29.24,  -90.66,  2), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  321;
update sites set geometry=ST_SetSRID(ST_MakePoint(49.15,  15.01,  478), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  324;
update sites set geometry=ST_SetSRID(ST_MakePoint(53.52,  -113.52,  680), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  325;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.42,  -75.69,  73), 4326), notes = 'grown in a lathhouse with climate control; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  329;
update sites set geometry=ST_SetSRID(ST_MakePoint(33.19,  -91.79,  55), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  330;
update sites set geometry=ST_SetSRID(ST_MakePoint(29.400173,  -82.929978,  22), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  331;
update sites set geometry=ST_SetSRID(ST_MakePoint(44.57,  -123.26,  71), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  332;
update sites set geometry=ST_SetSRID(ST_MakePoint(68.633132,  -149.605322,  3), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  333;
update sites set geometry=ST_SetSRID(ST_MakePoint(51.22,  4.41,  12), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  337;
update sites set geometry=ST_SetSRID(ST_MakePoint(35.994758,  -78.898373,  124), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  339;
update sites set geometry=ST_SetSRID(ST_MakePoint(41.310347,  -72.928476,  19), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  340;
update sites set geometry=ST_SetSRID(ST_MakePoint(36.012811,  -84.269314,  273), 4326), notes = 'growth chambers; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  341;
update sites set geometry=ST_SetSRID(ST_MakePoint(39.6,  -75.83,  5), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  342;
update sites set geometry=ST_SetSRID(ST_MakePoint(41.68,  -86.25,  215), 4326), notes = 'Seedlings; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  343;
update sites set geometry=ST_SetSRID(ST_MakePoint(46.73,  -117,  785), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  346;
update sites set geometry=ST_SetSRID(ST_MakePoint(43.559996,  -71.449748,  157), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  348;
update sites set geometry=ST_SetSRID(ST_MakePoint(33.95,  -117.39,  259), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  349;
update sites set geometry=ST_SetSRID(ST_MakePoint(36.196356,  -84.067726,  332), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  350;
update sites set geometry=ST_SetSRID(ST_MakePoint(32.44,  -85.9,  64), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  351;
update sites set geometry=ST_SetSRID(ST_MakePoint(32.83,  -85.65,  197), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  352;
update sites set geometry=ST_SetSRID(ST_MakePoint(35.933333,  -88.716667,  134), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  353;
update sites set geometry=ST_SetSRID(ST_MakePoint(36.310047,  138.21,  695), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  355;
update sites set geometry=ST_SetSRID(ST_MakePoint(64.85,  -147.717,  136), 4326), notes = 'Samples were obtained from a permafrost-dominated bog. Elevation 305 meters.; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  356;
update sites set geometry=ST_SetSRID(ST_MakePoint(33.86,  -83.41,  229), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  357;
update sites set geometry=ST_SetSRID(ST_MakePoint(35.86,  139.61,  7), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  358;
update sites set geometry=ST_SetSRID(ST_MakePoint(-7.96,  -37.63,  598), 4326), notes = 'plants grown in pots in a garden, Facultad de Agronomia, University of Buenos Aires ; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  359;
update sites set geometry=ST_SetSRID(ST_MakePoint(35.67,  -97.31,  295), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  360;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.33,  -84.51,  255), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  361;
update sites set geometry=ST_SetSRID(ST_MakePoint(-23.63,  -46.63,  761), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  362;
update sites set geometry=ST_SetSRID(ST_MakePoint(68.07,  -149.75,  936), 4326), notes = 'The main study was conducted at Material Site (MS) 117 for the TAPS Road, located within the Imnavait Creek watershed.
 There was an INTERWATER TRACK and a WTER TRACK. ; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  363;
update sites set geometry=ST_SetSRID(ST_MakePoint(30.86,  114.65,  31), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  365;
update sites set geometry=ST_SetSRID(ST_MakePoint(-37.93,  144.43,  212), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  366;
update sites set geometry=ST_SetSRID(ST_MakePoint(-37.82,  144.75,  44), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  367;
update sites set geometry=ST_SetSRID(ST_MakePoint(51.41,  16.13,  160), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  370;
update sites set geometry=ST_SetSRID(ST_MakePoint(59.48,  16.07,  3), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  371;
update sites set geometry=ST_SetSRID(ST_MakePoint(7,  80,  31), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  372;
update sites set geometry=ST_SetSRID(ST_MakePoint(7.27,  80.69,  448), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  373;
update sites set geometry=ST_SetSRID(ST_MakePoint(68.07,  -149.75,  936), 4326), notes = 'consisted of a level hilltop area with tussock tundra of
 similar species composition as at MS 117
; see Chapin and Shaver [1985b] for a detailed description of the site Ecology 66:564-576; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  374;
update sites set geometry=ST_SetSRID(ST_MakePoint(48.26,  16.63,  149), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  375;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.6,  14,  89), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  376;
update sites set geometry=ST_SetSRID(ST_MakePoint(56.5,  9.58,  33), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  377;
update sites set geometry=ST_SetSRID(ST_MakePoint(51.8,  0.35,  60), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  378;
update sites set geometry=ST_SetSRID(ST_MakePoint(48.67,  9,  487), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  379;
update sites set geometry=ST_SetSRID(ST_MakePoint(33.67,  -93.58,  107), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  380;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.61,  -8.64,  76), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  381;
update sites set geometry=ST_SetSRID(ST_MakePoint(39.14,  -96.64,  317), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  382;
update sites set geometry=ST_SetSRID(ST_MakePoint(64.85,  -147.717,  136), 4326), notes = 'It is located 4 km south of Goldstream Valley.; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  383;
update sites set geometry=ST_SetSRID(ST_MakePoint(-17.94,  145.93,  19), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  385;
update sites set geometry=ST_SetSRID(ST_MakePoint(52.25,  5.78,  33), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  386;
update sites set geometry=ST_SetSRID(ST_MakePoint(52.08,  5.83,  36), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  387;
update sites set geometry=ST_SetSRID(ST_MakePoint(60.45,  22.26,  10), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  388;
update sites set geometry=ST_SetSRID(ST_MakePoint(68.333333,  19,  606), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  389;
update sites set geometry=ST_SetSRID(ST_MakePoint(51.03,  3.72,  10), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  398;
update sites set geometry=ST_SetSRID(ST_MakePoint(43.78,  -88.78,  303), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  400;
update sites set geometry=ST_SetSRID(ST_MakePoint(43.78,  -88.78,  303), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  401;
update sites set geometry=ST_SetSRID(ST_MakePoint(52.93,  -73.54,  433), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  402;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.99,  -77.42,  184), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  403;
update sites set geometry=ST_SetSRID(ST_MakePoint(33.13,  119.32,  3), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  404;
update sites set geometry=ST_SetSRID(ST_MakePoint(38.82,  -76.75,  9), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  405;
update sites set geometry=ST_SetSRID(ST_MakePoint(60.5,  22.75,  41), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  406;
update sites set geometry=ST_SetSRID(ST_MakePoint(41.29,  -76.37,  312), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  407;
update sites set geometry=ST_SetSRID(ST_MakePoint(51.43,  -2.65,  19), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  408;
update sites set geometry=ST_SetSRID(ST_MakePoint(52.61,  0.88,  63), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  409;
update sites set geometry=ST_SetSRID(ST_MakePoint(51.12,  -0.83,  94), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  410;
update sites set geometry=ST_SetSRID(ST_MakePoint(49.53,  16.25,  562), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  411;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.47,  8.79,  112), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  413;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.05,  8.68,  88), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  415;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.18,  9.26,  71), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  416;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.21,  9.28,  0), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  417;
update sites set geometry=ST_SetSRID(ST_MakePoint(44.98,  11.47,  4), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  418;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.19,  9.27,  71), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  419;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.16,  9.27,  74), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  420;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.87,  10.87,  62), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  421;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.52,  10.08,  125), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  422;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.4,  10.01,  83), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  423;
update sites set geometry=ST_SetSRID(ST_MakePoint(41.03,  15.05,  700), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  424;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.58,  12.68,  1), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  425;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.59,  12.87,  0), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  426;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.22,  11.93,  1), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  427;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.23,  11.87,  5), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  428;
update sites set geometry=ST_SetSRID(ST_MakePoint(47.9,  1.9,  108), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  430;
update sites set geometry=ST_SetSRID(ST_MakePoint(48.94,  12.04,  343), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  431;
update sites set geometry=ST_SetSRID(ST_MakePoint(51.4,  8.92,  345), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  432;
update sites set geometry=ST_SetSRID(ST_MakePoint(52.89,  8.43,  30), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  433;
update sites set geometry=ST_SetSRID(ST_MakePoint(47.28,  -123.3,  184), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  435;
update sites set geometry=ST_SetSRID(ST_MakePoint(43.13,  -70.77,  12), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  436;
update sites set geometry=ST_SetSRID(ST_MakePoint(47,  -79.3,  269), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  437;
update sites set geometry=ST_SetSRID(ST_MakePoint(48.58,  -78.08,  321), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  438;
update sites set geometry=ST_SetSRID(ST_MakePoint(48.83,  2.33,  70), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  440;
update sites set geometry=ST_SetSRID(ST_MakePoint(47.9,  -95.78,  352), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  441;
update sites set geometry=ST_SetSRID(ST_MakePoint(29.05,  79.33,  223), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  442;
update sites set geometry=ST_SetSRID(ST_MakePoint(51.97,  -3.15,  730), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  443;
update sites set geometry=ST_SetSRID(ST_MakePoint(52.17,  0.08,  14), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  444;
update sites set geometry=ST_SetSRID(ST_MakePoint(52.14,  13.22,  53), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  445;
update sites set geometry=ST_SetSRID(ST_MakePoint(51.71,  -1.97,  123), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  446;
update sites set geometry=ST_SetSRID(ST_MakePoint(53.8,  -1.55,  49), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  447;
update sites set geometry=ST_SetSRID(ST_MakePoint(52.01,  -0.42,  62), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  448;
update sites set geometry=ST_SetSRID(ST_MakePoint(47.77,  1.87,  113), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  449;
update sites set geometry=ST_SetSRID(ST_MakePoint(44.7,  7.67,  284), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  450;
update sites set geometry=ST_SetSRID(ST_MakePoint(51.12,  -0.83,  94), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  451;
update sites set geometry=ST_SetSRID(ST_MakePoint(53.9,  -116.6,  1255), 4326), notes = 'elevation queried using lat lon in Google Earth', updated_at = now() where id=  453;
update sites set geometry=ST_SetSRID(ST_MakePoint(46,  -90,  500), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  454;
update sites set geometry=ST_SetSRID(ST_MakePoint(53.2289,  -4.1301,  56), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  460;
update sites set geometry=ST_SetSRID(ST_MakePoint(56.41,  -4.63,  265), 4326), notes = 'plants were collected from two seminatural grazed grasslands; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  461;
update sites set geometry=ST_SetSRID(ST_MakePoint(56.11,  -3.46,  172), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  462;
update sites set geometry=ST_SetSRID(ST_MakePoint(65.43333,  -145.5,  783), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  463;
update sites set geometry=ST_SetSRID(ST_MakePoint(68.35,  18.63,  1046), 4326), notes = '380 m above sea level; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  464;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.5,  -97,  205), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  465;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.5,  -97,  205), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  466;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.5,  -97,  205), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  467;
update sites set geometry=ST_SetSRID(ST_MakePoint(68.35,  18.65,  971), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  468;
update sites set geometry=ST_SetSRID(ST_MakePoint(68.35,  18.67,  1023), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  469;
update sites set geometry=ST_SetSRID(ST_MakePoint(65.166667,  -145.5,  689), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  470;
update sites set geometry=ST_SetSRID(ST_MakePoint(30.25,  78.416,  1677), 4326), notes = 'Mixed forest; elevation queried using lat lon in Google Earth', updated_at = now() where id=  471;
update sites set geometry=ST_SetSRID(ST_MakePoint(70.45,  -157.916667,  15), 4326), notes = '23 m elevation; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  472;
update sites set geometry=ST_SetSRID(ST_MakePoint(68.633333,  -149.56667,  762), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  473;
update sites set geometry=ST_SetSRID(ST_MakePoint(68.35,  18.81667,  396), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  474;
update sites set geometry=ST_SetSRID(ST_MakePoint(68.633333,  -149.56667,  762), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  475;
update sites set geometry=ST_SetSRID(ST_MakePoint(68.633333,  -149.56667,  762), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  476;
update sites set geometry=ST_SetSRID(ST_MakePoint(49.55,  18.533333,  759), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  477;
update sites set geometry=ST_SetSRID(ST_MakePoint(41.465,  -101.83,  1141), 4326), notes = 'estimated from text, websoilsurvey.nrcs.usda.gov and map from http://cedarpoint.unl.edu/images/facilities/arapaho_soil_map.jpg; elevation queried using lat lon in Google Earth', updated_at = now() where id=  478;
update sites set geometry=ST_SetSRID(ST_MakePoint(41.12,  -101.71,  977), 4326), notes = 'Site location estimated from text, historical soil map http://cedarpoint.unl.edu/images/facilities/arapaho_soil_map.jpg
 and usgs websoilsurvey.nrcs.usda.gov 
 Paper states soil as -3% slope, Dodge and Dunday loamy fine sand, arapaho_soil_map places this along and just southeast of of the pre 1939 blowouts and ravine washouts in section 32 of the map; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  479;
update sites set geometry=ST_SetSRID(ST_MakePoint(41.4734,  -101.8189,  1102), 4326), notes = 'location estimated from text, usgs websoilsurvey.nrcs.usda.gov, and arapaho soil map http://cedarpoint.unl.edu/images/facilities/arapaho_soil_map.jpg; elevation queried using lat lon in Google Earth', updated_at = now() where id=  480;
update sites set geometry=ST_SetSRID(ST_MakePoint(47.11,  11.31,  979), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  482;
update sites set geometry=ST_SetSRID(ST_MakePoint(46.83,  11.28,  1575), 4326), notes = 'elevation queried using lat lon in Google Earth', updated_at = now() where id=  483;
update sites set geometry=ST_SetSRID(ST_MakePoint(46.02,  11.01,  1290), 4326), notes = 'elevation queried using lat lon in Google Earth', updated_at = now() where id=  484;
update sites set geometry=ST_SetSRID(ST_MakePoint(30.833,  -87.183,  80), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  485;
update sites set geometry=ST_SetSRID(ST_MakePoint(53.333,  -113.5,  699), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  486;
update sites set geometry=ST_SetSRID(ST_MakePoint(35.083,  -93.983,  153), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  488;
update sites set geometry=ST_SetSRID(ST_MakePoint(37.35,  -80.683,  574), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  489;
update sites set geometry=ST_SetSRID(ST_MakePoint(36.583,  -76.466,  27), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  490;
update sites set geometry=ST_SetSRID(ST_MakePoint(59.617,  16.667,  40), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  492;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.94,  -3.16,  88), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  493;
update sites set geometry=ST_SetSRID(ST_MakePoint(68.633333,  -149.566667,  762), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  494;
update sites set geometry=ST_SetSRID(ST_MakePoint(68.45,  -149.36667,  803), 4326), notes = 'Our wet site was located on limestone parent material in a former floodplain of the Atigun River; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  495;
update sites set geometry=ST_SetSRID(ST_MakePoint(68.633333,  -149.566667,  762), 4326), notes = 'The shrub site was located on a well-drained, gentle slope (<50) between two small streams that drained the tussock tundra surrounding
 Toolik Lake.; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  496;
update sites set geometry=ST_SetSRID(ST_MakePoint(68.633333,  -149.566667,  762), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  497;
update sites set geometry=ST_SetSRID(ST_MakePoint(41.424,  -72.905,  36), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  498;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.78,  -77.85,  344), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  499;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.44,  -89.62,  473), 4326), notes = '  ; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  500;
update sites set geometry=ST_SetSRID(ST_MakePoint(21.687,  -158.0282,  5), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  501;
update sites set geometry=ST_SetSRID(ST_MakePoint(20.652161,  -156.050251,  35), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  502;
update sites set geometry=ST_SetSRID(ST_MakePoint(22,  -159.3353,  18), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  503;
update sites set geometry=ST_SetSRID(ST_MakePoint(43.91,  -90.92,  228), 4326), notes = 'There are two other sites related to this location.; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  507;
update sites set geometry=ST_SetSRID(ST_MakePoint(43.91,  -90.92,  228), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  508;
update sites set geometry=ST_SetSRID(ST_MakePoint(43.91,  -90.92,  228), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  509;
update sites set geometry=ST_SetSRID(ST_MakePoint(43.97,  -91.03,  335), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  510;
update sites set geometry=ST_SetSRID(ST_MakePoint(-18.858889,  146.191389,  19), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  511;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.2,  -76.54,  313), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  512;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.96,  -76.75,  124), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  513;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.37,  -76.73,  402), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  515;
update sites set geometry=ST_SetSRID(ST_MakePoint(37.36,  -77.25,  0), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  520;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.54,  -76.61,  236), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  521;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.19,  -76.49,  456), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  522;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.36,  -76.38,  544), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  523;
update sites set geometry=ST_SetSRID(ST_MakePoint(38.72,  -78.56,  751), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  524;
update sites set geometry=ST_SetSRID(ST_MakePoint(37.57,  127,  35), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  525;
update sites set geometry=ST_SetSRID(ST_MakePoint(37.77,  -83.65,  301), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  526;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.2,  -74.3,  778), 4326), notes = 'Samples of each species taken from multiple sites within 20km of Diamond Notch site; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  527;
update sites set geometry=ST_SetSRID(ST_MakePoint(46.04,  -87.52,  316), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  528;
update sites set geometry=ST_SetSRID(ST_MakePoint(46.17,  -86.67,  249), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  529;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.44,  -76.49,  167), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  530;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.789,  -77.856,  339), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  531;
update sites set geometry=ST_SetSRID(ST_MakePoint(41.84,  -79.14,  363), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  550;
update sites set geometry=ST_SetSRID(ST_MakePoint(41.4,  -74.02,  390), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  551;
update sites set geometry=ST_SetSRID(ST_MakePoint(37.47,  127.05,  51), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  552;
update sites set geometry=ST_SetSRID(ST_MakePoint(37.57,  126.59,  5), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  553;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.92,  -78.02,  714), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  554;
update sites set geometry=ST_SetSRID(ST_MakePoint(34.68,  -82.84,  217), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  555;
update sites set geometry=ST_SetSRID(ST_MakePoint(41.2261,  96.4883,  1990), 4326), notes = 'Singsaas study, data marked as grown under greenhouse or growth chamber. Detailed information can be tracked down through references listed in the data tables.
 study was conducted Meads, NE
 and Ames, IA; elevation queried using lat lon in Google Earth', updated_at = now() where id=  558;
update sites set geometry=ST_SetSRID(ST_MakePoint(53.92,  -106.38,  676), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  560;
update sites set geometry=ST_SetSRID(ST_MakePoint(-26.79,  153.09,  16), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  562;
update sites set geometry=ST_SetSRID(ST_MakePoint(53.93,  -116.57,  1295), 4326), notes = 'elevation queried using lat lon in Google Earth', updated_at = now() where id=  563;
update sites set geometry=ST_SetSRID(ST_MakePoint(-22.35,  -47.38,  609), 4326), notes = 'elevation of 617m; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  564;
update sites set geometry=ST_SetSRID(ST_MakePoint(34.68,  -82.84,  217), 4326), notes = 'No information on the soil used but it is in a greenhouse.; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  567;
update sites set geometry=ST_SetSRID(ST_MakePoint(33.383,  -81.667,  121), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  569;
update sites set geometry=ST_SetSRID(ST_MakePoint(-23.083,  -52.43,  447), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  571;
update sites set geometry=ST_SetSRID(ST_MakePoint(51.77,  -1.333,  160), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  572;
update sites set geometry=ST_SetSRID(ST_MakePoint(53.38,  -113.75,  699), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  573;
update sites set geometry=ST_SetSRID(ST_MakePoint(53.2,  -105.75,  429), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  574;
update sites set geometry=ST_SetSRID(ST_MakePoint(53.35,  -104.01,  370), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  575;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.74,  -97.85,  209), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  576;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.58,  22.96,  60), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  577;
update sites set geometry=ST_SetSRID(ST_MakePoint(59.85,  17.63,  28), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  578;
update sites set geometry=ST_SetSRID(ST_MakePoint(68.14,  -165.97,  0), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  580;
update sites set geometry=ST_SetSRID(ST_MakePoint(-19.5,  147.3,  6), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  583;
update sites set geometry=ST_SetSRID(ST_MakePoint(53.92,  -122.77,  588), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  588;
update sites set geometry=ST_SetSRID(ST_MakePoint(68.6167,  -149.6,  742), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  591;
update sites set geometry=ST_SetSRID(ST_MakePoint(25.7586,  -80.3771,  7), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  594;
update sites set geometry=ST_SetSRID(ST_MakePoint(31.313,  -84.3357,  48), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  596;
update sites set geometry=ST_SetSRID(ST_MakePoint(39.03,  -76.93,  35), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  599;
update sites set geometry=ST_SetSRID(ST_MakePoint(34.4,  -82.5,  237), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  600;
update sites set geometry=ST_SetSRID(ST_MakePoint(36.39,  -87.46,  225), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  601;
update sites set geometry=ST_SetSRID(ST_MakePoint(35.9,  -84.1,  325), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  605;
update sites set geometry=ST_SetSRID(ST_MakePoint(39.328125,  -82.441822,  286), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  606;
update sites set geometry=ST_SetSRID(ST_MakePoint(51.463,  -2.65,  96), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  607;
update sites set geometry=ST_SetSRID(ST_MakePoint(78.64,  18.16,  490), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  608;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.08,  -72.02,  155), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  609;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.655393,  -77.916746,  293), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  611;
update sites set geometry=ST_SetSRID(ST_MakePoint(41.257333,  -76.802893,  246), 4326), notes = '1 year of measurements for the Pinus species (P virginiana and P strobus), which was done in 1997 on private property in Hughesville, PA (Muncy Town- ship, Lycoming County).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  612;
update sites set geometry=ST_SetSRID(ST_MakePoint(33.383,  -81.667,  121), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  613;
update sites set geometry=ST_SetSRID(ST_MakePoint(43.11,  141.24,  75), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  614;
update sites set geometry=ST_SetSRID(ST_MakePoint(31.01,  -84.81,  46), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  616;
update sites set geometry=ST_SetSRID(ST_MakePoint(63.83,  20.25,  16), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  617;
update sites set geometry=ST_SetSRID(ST_MakePoint(52.12,  19,  118), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  618;
update sites set geometry=ST_SetSRID(ST_MakePoint(38.951892,  -86.357952,  232), 4326), notes = 'Multiple ecological land type phases (ELTP) were selected from the same general area inside the Pleasant Run part of the Hoosier National Forest.; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  619;
update sites set geometry=ST_SetSRID(ST_MakePoint(54.3,  -7.5,  64), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  620;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.25,  -127.64,  266), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  623;
update sites set geometry=ST_SetSRID(ST_MakePoint(44.98,  -93.18,  272), 4326), notes = 'For Tjoelker 1999: Trees placed in 6 equal sized growth chambers, with 10-15 saplings of all 5 species grown in each chamber.; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  624;
update sites set geometry=ST_SetSRID(ST_MakePoint(43.52,  -91.51,  331), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  631;
update sites set geometry=ST_SetSRID(ST_MakePoint(46.135,  -90.579,  462), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  632;
update sites set geometry=ST_SetSRID(ST_MakePoint(-37.78,  175.31,  46), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  633;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.5,  -73.55,  4), 4326), notes = 'Its actual address is Hinchinbrooke
, Le Haut-Saint-Laurent Regional County Municipality, Quebec, Canada from the Official website from Government of Quebec http://www.mddep.gouv.qc.ca/biodiversite/reserves/boise_muir/res_53.htm; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  634;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.37,  -71.11,  19), 4326), notes = 'Nondescript location in Cambridge, MA.; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  635;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.702785,  -84.484091,  259), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  636;
update sites set geometry=ST_SetSRID(ST_MakePoint(58.15,  26.45,  88), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  638;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.8,  -90.116667,  520), 4326), notes = 'Near Willow Creek; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  639;
update sites set geometry=ST_SetSRID(ST_MakePoint(43.663349,  -79.394532,  111), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  641;
update sites set geometry=ST_SetSRID(ST_MakePoint(58.2,  26.7,  115), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  643;
update sites set geometry=ST_SetSRID(ST_MakePoint(58.5,  22.6,  24), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  645;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.5,  -72.15,  323), 4326), notes = 'Curtis 2007(#727)- The vegetation assemblage is transitional hardwood, primarily red oak (Quercus rubra L.), black oak, and red maple, together with some hemlock (Tsuga canadensis L.) stands, white pine (Pinus strobus L.), and red pine (Pinus resinosa Aiton.) plantations. The relatively sparse understory contains saplings of the dominant trees plus woody shrubs such as blueberry (Vaccinium spp.), Viburnum spp., and witch hazel (Hamamelis virginiana L.).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  646;
update sites set geometry=ST_SetSRID(ST_MakePoint(59.82,  17.67,  9), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  648;
update sites set geometry=ST_SetSRID(ST_MakePoint(-21.160721,  -47.819366,  543), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  649;
update sites set geometry=ST_SetSRID(ST_MakePoint(59.85,  17.63,  28), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  650;
update sites set geometry=ST_SetSRID(ST_MakePoint(52.26,  10.53,  79), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  651;
update sites set geometry=ST_SetSRID(ST_MakePoint(39.952,  -75.164,  44), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  652;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.71,  -74.01,  41), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  653;
update sites set geometry=ST_SetSRID(ST_MakePoint(39.96,  -74.78,  13), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  654;
update sites set geometry=ST_SetSRID(ST_MakePoint(36.67,  -77.1,  27), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  655;
update sites set geometry=ST_SetSRID(ST_MakePoint(36.11,  -84.19,  283), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  656;
update sites set geometry=ST_SetSRID(ST_MakePoint(34.72,  -81.61,  188), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  657;
update sites set geometry=ST_SetSRID(ST_MakePoint(34.27,  -81.59,  177), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  658;
update sites set geometry=ST_SetSRID(ST_MakePoint(33.95,  -83.38,  205), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  659;
update sites set geometry=ST_SetSRID(ST_MakePoint(31.89,  -95.19,  111), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  661;
update sites set geometry=ST_SetSRID(ST_MakePoint(31.29,  -94.67,  90), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  662;
update sites set geometry=ST_SetSRID(ST_MakePoint(30.79,  -89.13,  39), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  663;
update sites set geometry=ST_SetSRID(ST_MakePoint(35.55,  -77.05,  5), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  664;
update sites set geometry=ST_SetSRID(ST_MakePoint(35.68,  -85.77,  296), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  665;
update sites set geometry=ST_SetSRID(ST_MakePoint(35.93,  -84.31,  243), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  666;
update sites set geometry=ST_SetSRID(ST_MakePoint(-29.7,  31,  125), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  668;
update sites set geometry=ST_SetSRID(ST_MakePoint(35.9,  -84.33,  239), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  669;
update sites set geometry=ST_SetSRID(ST_MakePoint(36.02,  -84.25,  280), 4326), notes = 'Aquic
 Hapludult and consists of alluvium washed from upland soils; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  670;
update sites set geometry=ST_SetSRID(ST_MakePoint(34.21,  133.8,  67), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  671;
update sites set geometry=ST_SetSRID(ST_MakePoint(64.82,  -147.87,  135), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  674;
update sites set geometry=ST_SetSRID(ST_MakePoint(-27.3,  31.6,  294), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  675;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.43,  -84.02,  272), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  680;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.4,  -71.11,  14), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  683;
update sites set geometry=ST_SetSRID(ST_MakePoint(64.83,  -147.71,  135), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  684;
update sites set geometry=ST_SetSRID(ST_MakePoint(64.83,  -147.71,  135), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  685;
update sites set geometry=ST_SetSRID(ST_MakePoint(64.8,  -147.867,  130), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  686;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.85,  -98.03,  227), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  688;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.01,  -105.26,  1624), 4326), notes = 'At each site plants were maintained outdoors for three growing seasons in the soil characteristic of the site (Chapin and Chapin 1981); elevation queried using lat lon in Google Earth', updated_at = now() where id=  690;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.01,  -105.26,  1624), 4326), notes = 'At each site plants were maintained outdoors for three growing seasons in the soil characteristic of the site (Chapin and Chapin 1981); elevation queried using lat lon in Google Earth', updated_at = now() where id=  691;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.01,  -105.26,  1624), 4326), notes = 'At each site plants were maintained outdoors for three growing seasons in the soil characteristic of the site (Chapin and Chapin 1981); elevation queried using lat lon in Google Earth', updated_at = now() where id=  692;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.01,  -105.26,  1624), 4326), notes = 'At each site plants were maintained outdoors for three growing seasons in the soil characteristic of the site (Chapin and Chapin 1981); elevation queried using lat lon in Google Earth', updated_at = now() where id=  693;
update sites set geometry=ST_SetSRID(ST_MakePoint(64.8,  -147.87,  132), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  695;
update sites set geometry=ST_SetSRID(ST_MakePoint(53.75,  -105.24,  505), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  696;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.81,  126.53,  117), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  697;
update sites set geometry=ST_SetSRID(ST_MakePoint(46.867,  -88.883,  382), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  698;
update sites set geometry=ST_SetSRID(ST_MakePoint(60.083,  17.5,  57), 4326), notes = 'This site is a combination of three sites in citation 457 (Widen and Majdi 2001). Root respiration rates were not combined across sites.; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  699;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.55,  -84.85,  272), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  702;
update sites set geometry=ST_SetSRID(ST_MakePoint(44.383,  -84.833,  344), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  703;
update sites set geometry=ST_SetSRID(ST_MakePoint(43.667,  -86.15,  264), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  704;
update sites set geometry=ST_SetSRID(ST_MakePoint(36.22,  137.433,  1562), 4326), notes = 'elevation queried using lat lon in Google Earth', updated_at = now() where id=  705;
update sites set geometry=ST_SetSRID(ST_MakePoint(29.733,  -82.15,  41), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  710;
update sites set geometry=ST_SetSRID(ST_MakePoint(61.85,  24.28333,  168), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  712;
update sites set geometry=ST_SetSRID(ST_MakePoint(30.2,  -92.8,  6), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  714;
update sites set geometry=ST_SetSRID(ST_MakePoint(64.83,  -147.71,  135), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  716;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.5,  -72.15,  323), 4326), notes = 'three different types of N applied as either ammonium sulfate, ammonium nitrate,or potassium nitrate. They were added at one of following two rates of N addition; 25 kg*ha-1*yr-1 or 50 kg*ha-1*yr-1.; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  725;
update sites set geometry=ST_SetSRID(ST_MakePoint(29.65,  -82.32,  37), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  726;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.037449,  -90.970234,  224), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  781;
update sites set geometry=ST_SetSRID(ST_MakePoint(44.8386,  0.5783,  50), 4326), notes = 'The study was carried out on mature maritime pine trees
 (Pinus pinaster Ait.) growing near Bordeaux, south-west
France. Measurements were made
 approximately every 2 months between July 1999 and
 October 2000. Details of measurements are given in
Table 1. Measurements commenced in Le Pavillon, a
stand of 29-year-old trees. Unfortunately, this stand was
destroyed in the December 1999 windstorm, so measure-
ments were continued in a neighbouring stand St Albans
of 18-year-old trees. Both sites are flat and have a sandy,
well-drained substrate. Both stands were genetic trials. The
first stand was established to study the phenotypical
expression of various characters (Guyon & Kremer 1982),
whereas the second consists of hybrid trees resulting from the first, established with the aim of comparing the perfor-
mances of the hybrids (Harfouche & Kremer 2000). Only
non-hybridized trees were used for this study. The two
stands had similar leaf area indices of 2-3 m2 mˆ2 (B.E.M.,
personal observation) and comparable needle nitrogen
concentrations (see later).
The two provenances chosen for study were Landes,
originating locally, and Tamjout, originating in the moun-
tains of Morocco. The local climate has mean winter mini-
mum temperatures of 1 degree C, with regular frosts, and mean
summer maxima of 25 degree C, with extremes up to 38 degrees C. The
climate in the region of origin of the Moroccan provenance
is drier, with similar winter temperatures, but higher sum-
mer temperatures.
; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  801;
update sites set geometry=ST_SetSRID(ST_MakePoint(44.8386,  0.5783,  50), 4326), notes = 'The study was carried out on mature maritime pine trees
(Pinus pinaster Ait.) growing near Bordeaux, south-west
France (56°37′ N, 3°38′ E). Measurements were made
approximately every 2 months between July 1999 and
October 2000. Details of measurements are given in
Table 1. Measurements commenced in ‘Le Pavillon’, a
stand of 29-year-old trees. Unfortunately, this stand was
destroyed in the December 1999 windstorm, so measure-
ments were continued in a neighbouring stand ‘St Albans’
of 18-year-old trees. Both sites are flat and have a sandy,
well-drained substrate. Both stands were genetic trials. The
first stand was established to study the phenotypical
expression of various characters (Guyon & Kremer 1982),
whereas the second consists of hybrid trees resulting from the first, established with the aim of comparing the perfor-
mances of the hybrids (Harfouche & Kremer 2000). Only
non-hybridized trees were used for this study. The two
stands had similar leaf area indices of 2–3 m2 m−2 (B.E.M.,
personal observation) and comparable needle nitrogen
concentrations (see later).
The two provenances chosen for study were Landes,
originating locally, and Tamjout, originating in the moun-
tains of Morocco. The local climate has mean winter mini-
mum temperatures of 1 °C, with regular frosts, and mean
summer maxima of 25 °C, with extremes up to 38 °C. The
climate in the region of origin of the Moroccan provenance
is drier, with similar winter temperatures, but higher sum-
mer temperatures.

; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  802;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.58,  -105.08,  1528), 4326), notes = 'elevation queried using lat lon in Google Earth', updated_at = now() where id=  804;
update sites set geometry=ST_SetSRID(ST_MakePoint(38.54,  -121.75,  18), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  805;
update sites set geometry=ST_SetSRID(ST_MakePoint(63.92,  -145.73,  455), 4326), notes = 'The regional climate is cold and dry. Mean
monthly temperatures range from 20  C in January to 16 C in July. July is the wettest month, with an average of 690mm rain. Winter months are driest, with averages of 80mm precipitation per month, mostly as snow (http://weather.noaa.gov/). The growing season lasts from mid-May to early September. .; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  806;
update sites set geometry=ST_SetSRID(ST_MakePoint(63.92,  -145.73,  455), 4326), notes = 'The vegetation un- derstory is dominated by mosses, lichens, and the ericoid shrubs Vaccinium uliginosum, V. vitis-idaea, Ledum groenlandicum, and Empetrum nigrum, as well as the ectomycorrhizal shrub Betula glandulosa (Treseder et al., 2004). The growing season begins with bud break in mid-May and extends until leaf senescence in mid- September.; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  807;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.9,  -72.3,  195), 4326), notes = 'Dominant tree species include paper birch (Betula papyrifera Marsh.), red maple (Acer rubrum L.), black oak (Quercus velutina Lam.), and striped maple (Acer pennsylvanicum L.)
; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  808;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.47,  -72.17,  313), 4326), notes = 'an even-aged, mixed de- ciduous forest in central Massachusetts (42° 28′ N, 72° 10′ W). It is dominated by Quercus rubra and Quercus velutina (42% of basal area) and Acer rubrum (29%) with lesser components of Fraxinus americana (11%) and occurs on soils of the Canton series. As in an earlier, smaller (6 × 6 m) soil-warming study nearby (18), we used buried resistance cables to heat the soil. In large (30 × 30 m) heated and control (unheated) areas, we carried out a set of biogeochemical and plant phenology and growth measurements.
see paper for NEP.; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  812;
update sites set geometry=ST_SetSRID(ST_MakePoint(33.3779,  -116.2314,  956), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  819;
update sites set geometry=ST_SetSRID(ST_MakePoint(34.411842,  -118.919453,  142), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  821;
update sites set geometry=ST_SetSRID(ST_MakePoint(54.591941,  -5.951676,  5), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  822;
update sites set geometry=ST_SetSRID(ST_MakePoint(-26.187664,  152.667556,  82), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  826;
update sites set geometry=ST_SetSRID(ST_MakePoint(36.003156,  -78.944153,  109), 4326), notes = '3.5 dm^3 pots ; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  830;
update sites set geometry=ST_SetSRID(ST_MakePoint(-35.282244,  149.128757,  580), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  832;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.937935,  -3.1675,  76), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  835;
update sites set geometry=ST_SetSRID(ST_MakePoint(59.844886,  17.637172,  34), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  836;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.343679,  11.603618,  33), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  837;
update sites set geometry=ST_SetSRID(ST_MakePoint(56.06234,  12.262798,  54), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  838;
update sites set geometry=ST_SetSRID(ST_MakePoint(35.9,  -84.33,  239), 4326), notes = 'The mean length of growing season is 185 days. 
The chambers were 3.0 m in diameter and 2.4 m high. An additional 1.2-m panel was installed at the beginning of the third growing season (1996) to accommodate the height growth of the seedlings. The chambers were modified to operate at either ambient or 4 ° C above ambient air temperature, in combination with ambient or elevated (+300 p.p.m.) atmospheric CO 2 concentration.
Soil temperature at 10 cm depth was increased by 1.2 C by the warmer air in the elevated temperature chambers; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  840;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.88,  -98.33,  256), 4326), notes = 'Black spruce trees were initially hand sown in greenhouses in 1992 then transplanted and planted at 2m-2m spacing in 1994.
Before the establish- ment of the warming experiment, competitor woody species were removed annually to normalize competi- tive growth constraints, but all vegetation was allowed to establish and grow after the experiment was started.; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  841;
update sites set geometry=ST_SetSRID(ST_MakePoint(63.92,  -145.73,  455), 4326), notes = '7-9 years post-fire, dominant vegetation is herbaceous perennials, deciduous trees, and shrubs; major plant taxa included Betula, Calamagrostis, Festuca, Ledum, Lupinus, Populus, Salix, and Vaccinium as described by Mack et al. (2008); elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  842;
update sites set geometry=ST_SetSRID(ST_MakePoint(38.490524,  -120.888752,  330), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  843;
update sites set geometry=ST_SetSRID(ST_MakePoint(43.631953,  3.814998,  47), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  845;
update sites set geometry=ST_SetSRID(ST_MakePoint(39,  -84,  290), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  848;
update sites set geometry=ST_SetSRID(ST_MakePoint(36,  -78.94,  125), 4326), notes = 'The forest at this site is an even-aged stand of loblolly pine (Pinus taeda L.), planted in 1983 after the harvest of similar vegetation.The pines were ;14 m tall at the beginning of our study and comprise 98% of the total basal area. Because the plantation has not been managed since the planting of this pine cohort, a diversity of deciduous species has invaded, and a few of these individuals also reach the canopy. Topography of the 90-ha site is relatively flat, with an elevational gradient of 15 m between the highest and lowest plots.; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  850;
update sites set geometry=ST_SetSRID(ST_MakePoint(50.927554,  11.590057,  149), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  851;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.667,  -89.6167,  492), 4326), notes = 'Growing season, days = 150
Peak leaf area index, m 2.m -2 = 2.7-3.4
 in KING2004called FACTS-II; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  852;
update sites set geometry=ST_SetSRID(ST_MakePoint(35.9,  -84.33,  239), 4326), notes = 'Growing season, days = 190
Peak leaf area index, m 2.m -2 = 5.5; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  854;
update sites set geometry=ST_SetSRID(ST_MakePoint(34.915049,  135.639949,  363), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  859;
update sites set geometry=ST_SetSRID(ST_MakePoint(54.042137,  -2.798428,  37), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  860;
update sites set geometry=ST_SetSRID(ST_MakePoint(39.555786,  -96.337056,  416), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  861;
update sites set geometry=ST_SetSRID(ST_MakePoint(-40.348268,  175.618511,  38), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  863;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.116917,  -88.121685,  210), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  864;
update sites set geometry=ST_SetSRID(ST_MakePoint(39.496997,  -119.820332,  1410), 4326), notes = 'elevation queried using lat lon in Google Earth', updated_at = now() where id=  866;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.326423,  -75.842061,  81), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  867;
update sites set geometry=ST_SetSRID(ST_MakePoint(38.590956,  -8.080449,  322), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  868;
update sites set geometry=ST_SetSRID(ST_MakePoint(51.615333,  0.628276,  25), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  869;
update sites set geometry=ST_SetSRID(ST_MakePoint(52.100898,  0.963359,  77), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  870;
update sites set geometry=ST_SetSRID(ST_MakePoint(13.473978,  144.844953,  124), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  871;
update sites set geometry=ST_SetSRID(ST_MakePoint(38.88954,  -76.5136,  4), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  872;
update sites set geometry=ST_SetSRID(ST_MakePoint(9.894929,  -83.682179,  674), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  873;
update sites set geometry=ST_SetSRID(ST_MakePoint(37.532983,  -122.28127,  4), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  874;
update sites set geometry=ST_SetSRID(ST_MakePoint(43.086294,  12.394634,  360), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  875;
update sites set geometry=ST_SetSRID(ST_MakePoint(50.82,  -0.15,  82), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  876;
update sites set geometry=ST_SetSRID(ST_MakePoint(33.593291,  130.419384,  10), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  877;
update sites set geometry=ST_SetSRID(ST_MakePoint(63.812412,  20.269084,  2), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  878;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.722214,  -84.476885,  260), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  879;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.782907,  11.896472,  511), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  880;
update sites set geometry=ST_SetSRID(ST_MakePoint(37.043901,  -7.972152,  21), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  881;
update sites set geometry=ST_SetSRID(ST_MakePoint(47.341,  -94.207,  402), 4326), notes = 'Most stands were locatedwithinanareaof;30330km,withthemajority of stands located within a 5 km radius of one another. Red pine was the dominant overstory species, representing 86% of the total basal area across all stands, with eastern white pine (Pinus strobus L.), paper birch (Betula papyrifera Marsh.), jack pine (Pinus banksiana Lamb.), balsam fir (Abies balsamea L.), and northern red oak (Quercus rubra L.) each representing 1–4% of the remaining basal area.; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  882;
update sites set geometry=ST_SetSRID(ST_MakePoint(46.734207,  -117.14838,  795), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  884;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.898,  -98.216,  244), 4326), notes = 'The UCI and UW sites were located in the same burn scars and were no more than 3 km apart
area of the BOReal Ecosystem Atmosphere Study (BOREAS) Northern Study Area 
Rapidly developing herbaceous layer of wild rose (Rosa spp.), fireweed (Epilobium angustifolium L.), grass, Labrador tea (Ledum groenlandicum Oeder), alder (Alnus crispa), willow (Salix spp.), poplar, and aspen (Populus tremuloides Michx). Many 2–4cm tall black spruce (Picea mariana) and jack pine (Pinus banksiana Lamb.) seedlings. Almost all of the black spruce trees killed in the 2003 fire were still standing
; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  885;
update sites set geometry=ST_SetSRID(ST_MakePoint(56.636,  -99.948,  273), 4326), notes = 'Thick, patchy layer of fireweed, wild rose, grass, Labrador tea, alder, and patchy firemoss. Many 10–25cm tall black spruce. Almost all of the black spruce trees killed in the 1998 fire were still standing
The UCI andUW sites were located in the same burn scars and were no more than 3 km apart.
area of the BOReal Ecosystem– Atmosphere Study (BOREAS) Northern Study Area
; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  886;
update sites set geometry=ST_SetSRID(ST_MakePoint(56.628,  -99.942,  292), 4326), notes = '3km south of UCI-1998. Wetter with more sphagnum moss than UCI-1998
The UCI andUW sites were located in the same burn scars and were no more than 3 km apart
area of the BOReal Ecosystem– Atmosphere Study (BOREAS) Northern Study Area ; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  887;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.917,  -98.964,  271), 4326), notes = 'The UCI andUW sites were located in the same burn scars and were no more than 3 km apart.
area of the BOReal Ecosystem– Atmosphere Study (BOREAS) Northern Study Area
Thick layer of wild rose, grass, Labrador tea, fireweed, alder, and willow. Extensive firemoss with patches of sphagnum (Sphagnum spp.) and feather (Ptilium, Pleurozium,or Hylocomium spp.) moss. Many 20–100cm tall black spruce, 100–200cm tall jack pine, and 50–400cm aspen. Most black spruce trees killed by the 1989 fire fell from 2000 to 2005; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  888;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.906,  -98.979,  269), 4326), notes = 'The UCI andUW sites were located in the same burn scars and were no more than 3 km apart. 
area of the BOReal Ecosystem– Atmosphere Study (BOREAS) Northern Study Area
1.5km southwest of UCI-1989. Similar vegetation, steeper and more southerly aspect than UCI- 1989; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  889;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.863,  -98.485,  263), 4326), notes = 'The UCI andUW sites were located in the same burn scars and were no more than 3 km apart. 
area of the BOReal Ecosystem– Atmosphere Study (BOREAS) Northern Study Area 
Dense stand of 500cm tall jack pine with scattered 500cm tall aspen. Many 100–200cm tall black spruce. Continuous ground cover of grass, Labrador tea, willow, and wild rose. Mix of sphagnum and feather moss, Most black spruce trees killed by the 1981 fire had fallen before 2000; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  890;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.864,  -98.483,  265), 4326), notes = 'The UCI andUW sites were located in the same burn scars and were no more than 3 km apart. 
area of the BOReal Ecosystem– Atmosphere Study (BOREAS) Northern Study Area
75m east of UCI-1981. Similar to UCI-1981; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  891;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.912,  -98.382,  258), 4326), notes = 'The UCI andUW sites were located in the same burn scars and were no more than 3 km apart. 
area of the BOReal Ecosystem– Atmosphere Study (BOREAS) Northern Study Area
Moderately dense stand of 500–700cm tall jack pine and aspen, with significant mortality and thinning. Many 200–600cm tall black spruce. Ground cover of feather moss with sparse grass; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  892;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.92,  -98.656,  275), 4326), notes = 'The UCI andUW sites were located in the same burn scars and were no more than 3 km apart. 
area of the BOReal Ecosystem– Atmosphere Study (BOREAS) Northern Study Area
1.5km northwest of UCI-1964. More deciduous, larger trees than UCI-1964; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  893;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.906,  -98.525,  272), 4326), notes = 'The UCI andUW sites were located in the same burn scars and were no more than 3 km apart. 
area of the BOReal Ecosystem– Atmosphere Study (BOREAS) Northern Study Area
Closed canopy of 12–20mtall black spruce, with a few senescent jack pine and aspen. Nearly 100% feather moss cover. Significant shrub layer of alder, willow, and Labrador tea; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  894;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.908,  -98.519,  271), 4326), notes = 'The UCI andUW sites were located in the same burn scars and were no more than 3 km apart. 
area of the BOReal Ecosystem– Atmosphere Study (BOREAS) Northern Study Area
500m northeast of UCI-1930. Similar to UCI-1930; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  895;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.879,  -98.484,  267), 4326), notes = 'The UCI andUW sites were located in the same burn scars and were no more than 3 km apart.
 area of the BOReal Ecosystem– Atmosphere Study (BOREAS) Northern Study Area
Closed canopy of 14–18mtall black spruce. Nearly 100% feather moss cover.Open understory with a few alders, Labrador tea, and willow. Tower is centered in awell-drained, slightly upland area; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  896;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.879,  -98.48,  264), 4326), notes = 'The UCI andUW sites were located in the same burn scars and were no more than 3 km apart. 
area of the BOReal Ecosystem– Atmosphere Study (BOREAS) Northern Study Area
400m east of UCI-1850. Similar to UCI-1850; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  897;
update sites set geometry=ST_SetSRID(ST_MakePoint(55.879,  -98.48,  264), 4326), notes = 'The UCI andUW sites were located in the same burn scars and were no more than 3 km apart 
area of the BOReal Ecosystem– Atmosphere Study (BOREAS) Northern Study Area
NOBS tower is 400m east of UCI-1850 tower. NOBS tower samples both well- and poorly drained areas; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  898;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.918056,  -90.118889,  483), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  909;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.816667,  -90.1675,  476), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  910;
update sites set geometry=ST_SetSRID(ST_MakePoint(47.33,  -94.5,  424), 4326), notes = 'Site descriptions & disturbance history in source paper are poor.  More information may be available in govenment reports (citied in source paper).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  911;
update sites set geometry=ST_SetSRID(ST_MakePoint(47.33,  -94.5,  424), 4326), notes = 'Site descriptions & disturbance history in source paper are poor.  More information may be available in govenment reports (citied in source paper).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  912;
update sites set geometry=ST_SetSRID(ST_MakePoint(47.33,  -94.5,  424), 4326), notes = 'Site descriptions & disturbance history in source paper are poor.  More information may be available in govenment reports (citied in source paper).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  913;
update sites set geometry=ST_SetSRID(ST_MakePoint(47.33,  -94.5,  424), 4326), notes = 'Site descriptions & disturbance history in source paper are poor.  More information may be available in govenment reports (citied in source paper).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  914;
update sites set geometry=ST_SetSRID(ST_MakePoint(47.33,  -94.5,  424), 4326), notes = 'Site descriptions & disturbance history in source paper are poor.  More information may be available in govenment reports (citied in source paper).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  915;
update sites set geometry=ST_SetSRID(ST_MakePoint(47.33,  -94.5,  424), 4326), notes = 'Site descriptions & disturbance history in source paper are poor.  More information may be available in govenment reports (citied in source paper).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  916;
update sites set geometry=ST_SetSRID(ST_MakePoint(46.85,  -89.32,  191), 4326), notes = 'Site descriptions & disturbance history in source paper are poor.  More information may be available in govenment reports (citied in source paper).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  917;
update sites set geometry=ST_SetSRID(ST_MakePoint(64,  -148,  1196), 4326), notes = 'Site type: naturally regenerating
; Disturbance Type: basic
; Vegetation Type: gymnosperm-dominated; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  918;
update sites set geometry=ST_SetSRID(ST_MakePoint(56,  12,  13), 4326), notes = 'Vegetation Type: angiosperm-dominated
Site type: naturally regenerating; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  919;
update sites set geometry=ST_SetSRID(ST_MakePoint(52,  39,  176), 4326), notes = 'Vegetation Type: Mixed
Site Type: naturally regenerating
; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  920;
update sites set geometry=ST_SetSRID(ST_MakePoint(52,  10,  196), 4326), notes = 'Vegetation Type: angiosperm-dominated
Site Type: naturally regenerating
Disturbance Type: basic
; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  921;
update sites set geometry=ST_SetSRID(ST_MakePoint(48,  -68,  300), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  922;
update sites set geometry=ST_SetSRID(ST_MakePoint(48,  -92,  493), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  923;
update sites set geometry=ST_SetSRID(ST_MakePoint(47,  -122,  487), 4326), notes = 'Vegetation Type:gymnosperm-dominated
Site Type: Naturally regenerating
Disturbance Type: Basic; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  924;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.5,  -85,  262), 4326), notes = 'Vegetation Type: Mixed
Site Type: Naturally regenerating
Disturbance Type: Basic
		; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  925;
update sites set geometry=ST_SetSRID(ST_MakePoint(44,  -71,  139), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  926;
update sites set geometry=ST_SetSRID(ST_MakePoint(64.117,  19.45,  300), 4326), notes = 'For further details about treatments and stand properties, see Linder (1995) and Bergh and others (1999).
The mean annual air temperature is 2.3 C, and mean monthly temperature varies from )7.3 C in February to 14.6 C in July (mean for the period 1990-2004). Mean annual rainfall is 600 mm, with approximately one-third falling as snow, which usually covers the frozen ground from mid-October to early May. The length of the growing season (daily mean temperature above +5- C) is 140 days (Slaney and others 2007).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  927;
update sites set geometry=ST_SetSRID(ST_MakePoint(36,  -78.94,  125), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  928;
update sites set geometry=ST_SetSRID(ST_MakePoint(40,  -98,  467), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  952;
update sites set geometry=ST_SetSRID(ST_MakePoint(43.54,  4.48,  -1), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  955;
update sites set geometry=ST_SetSRID(ST_MakePoint(43.125,  -92.25,  370), 4326), notes = 'Central point of midwest US region (49.75° N to 36.50° N; 80.25° W to 104.25° W) from VanLoocke et al simulations https://www.betydb.org/citations/618; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  956;
update sites set geometry=ST_SetSRID(ST_MakePoint(37.8722,  102.8472,  1550), 4326), notes = 'This area is in the eastern part of the Hexi corridor of Gansu province, located at the typical continental temperate arid zone, with an average annual sunshine duration of more than 3010h, annual accumulated tem- perature above 10â—¦C ofmore than 2985.4 â—¦C. The frost-free period is 160–180days, mean annual precipitation of 110mm (the pre- cipitation during June–September account for 60% of the annual precipitation) and a mean annual evaporation from a free water surface of 2644mm. The ground water table depth is consistently below 14–18 m.; elevation queried using lat lon in Google Earth', updated_at = now() where id=  959;
update sites set geometry=ST_SetSRID(ST_MakePoint(17.92444,  73.66,  1373), 4326), notes = 'elevation queried using lat lon in Google Earth', updated_at = now() where id=  960;
update sites set geometry=ST_SetSRID(ST_MakePoint(35.0167,  114.4,  75), 4326), notes = 'The annual precipitation in the area is approximately 615 mm, 60–90% of which occurs from May to October, and the average annual temperature in the area is 13.9 °C. ; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  961;
update sites set geometry=ST_SetSRID(ST_MakePoint(41,  16.910833,  153), 4326), notes = 'manuscript says latitude = 17.9, based on site description (), it is more likely 16.9: http://goo.gl/maps/iHTQk ; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  962;
update sites set geometry=ST_SetSRID(ST_MakePoint(37.8833,  114.6833,  56), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  966;
update sites set geometry=ST_SetSRID(ST_MakePoint(36.1719,  117.1508,  127), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  967;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.148,  26.408,  10), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  968;
update sites set geometry=ST_SetSRID(ST_MakePoint(37.9899,  -100.8153,  881), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  969;
update sites set geometry=ST_SetSRID(ST_MakePoint(33,  -88,  94), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  975;
update sites set geometry=ST_SetSRID(ST_MakePoint(36.65,  116.05,  36), 4326), notes = 'Winter wheat and summer maize are the two predominant crops and are cultivated in rotation. The growing season of winter wheat is from mid-October to late May, while maize is planted in late June and harvested in early October. June and October are the intermittent months for the two crops; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  987;
update sites set geometry=ST_SetSRID(ST_MakePoint(39.2,  100.1,  1420), 4326), notes = 'elevation queried using lat lon in Google Earth', updated_at = now() where id=  989;
update sites set geometry=ST_SetSRID(ST_MakePoint(39.08,  -96.58,  402), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  993;
update sites set geometry=ST_SetSRID(ST_MakePoint(32.353692,  -106.417012,  1199), 4326), notes = 'elevation queried using lat lon in Google Earth', updated_at = now() where id=  994;
update sites set geometry=ST_SetSRID(ST_MakePoint(40,  89,  806), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  995;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.011,  -94.746,  355), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  997;
update sites set geometry=ST_SetSRID(ST_MakePoint(41.168056,  -96.466111,  354), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  999;
update sites set geometry=ST_SetSRID(ST_MakePoint(26.8,  111.9,  141), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1000;
update sites set geometry=ST_SetSRID(ST_MakePoint(47.467,  7.5,  584), 4326), notes = 'The dominant species are Fagus sylvatica (3), Quercus petraea (3) and Carpinus betulus (3), and the sub-dominant species are Tilia platyphylla (1), Acer campestre (1) and Prunus avium (1; number of canopy size, i.e. 32-35 m high individuals in the CO2
enriched zone)
Stem basal area of all trees >10 cm diameter is 46 m2 ha-1 and leaf area
index is 5. By forestry standards, the forest is fast growing and of good quality (S3, Fig. S1). The average height increment of the canopy across species is ca. 15 cm per year, but is larger in leading shoots, particularly in Fagus. The regional wet nitrogen deposition of ca. 30 kg N ha-1 a-1 may add
to this vigor.
Disturbance History Unknown
Site is mature: the forest is 95-100 years old
In Bader 2009 FRR, fine root C & N are also measured. ; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1004;
update sites set geometry=ST_SetSRID(ST_MakePoint(41.098962,  -77.243858,  366), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1008;
update sites set geometry=ST_SetSRID(ST_MakePoint(46.8667,  19.4167,  109), 4326), notes = 'The Pannonian sand forest-steppe is part of the transitional biome between the temperate deciduous forest and the steppe zones in Europe, and appears as large-scale mosaic of various formations like shortgrass grasslands (Festucion vaginatae, Festucion rupicolae), xerothermic sand oak- woods (Iridi variegatae – Quercetum roboris, Populo canes- centis – Quercetum roboris), mixed juniper-poplar wood- lands and shrublands (Junipero – Populetumalbae) (Borhidi and Sántha 1999). The sandy soil (Calcaric arenosol, FAO) is very poor (%) in organic matter, and has extreme heat and water regimes (Kovács-Láng et al. 2000). Soil humus content in 0-10 cm depth at the spots where soil respiration was measured varied between 0.40 and 0.65%, corresponding to 0.23 and 0.37% carbon, according to our measurements. In; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1009;
update sites set geometry=ST_SetSRID(ST_MakePoint(54.43,  16.4,  -3), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1010;
update sites set geometry=ST_SetSRID(ST_MakePoint(31.683,  103.883,  2059), 4326), notes = 'elevation queried using lat lon in Google Earth', updated_at = now() where id=  1012;
update sites set geometry=ST_SetSRID(ST_MakePoint(59,  16,  81), 4326), notes = 'DELETE ME; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1013;
update sites set geometry=ST_SetSRID(ST_MakePoint(31.583,  102.583,  4168), 4326), notes = 'The mean annual temperature is 6 C, with a maximum monthly mean air temperature of 12.6 C in July and a minimum of
-8 C in January. The frozen ground is covered with snow from early November to mid-May, with a maxi-
mum snow depth of ca. 30 cm. Mean annual precipita- tion ranges from 600 mm to 1,100 mm.

adjacent forest openings
In 2000, some areas of the 60-year plantation were clearly felled for timber and formed the forest openings.; elevation queried using lat lon in Google Earth', updated_at = now() where id=  1014;
update sites set geometry=ST_SetSRID(ST_MakePoint(39.81,  -90.82,  202), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1016;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.3,  -89.94,  152), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1017;
update sites set geometry=ST_SetSRID(ST_MakePoint(38.38,  -88.39,  133), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1018;
update sites set geometry=ST_SetSRID(ST_MakePoint(38.95,  -88.96,  178), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1020;
update sites set geometry=ST_SetSRID(ST_MakePoint(-29.426,  153.241,  5), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1038;
update sites set geometry=ST_SetSRID(ST_MakePoint(-15.51,  128.68,  64), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1040;
update sites set geometry=ST_SetSRID(ST_MakePoint(-29.35,  31.07,  456), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1041;
update sites set geometry=ST_SetSRID(ST_MakePoint(-24.79,  152.37,  4), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1043;
update sites set geometry=ST_SetSRID(ST_MakePoint(59.62,  18.08,  22), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1046;
update sites set geometry=ST_SetSRID(ST_MakePoint(32.88,  -82.21,  76), 4326), notes = 'Exact site not specified in Arundale citation.; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1047;
update sites set geometry=ST_SetSRID(ST_MakePoint(38.13,  -84.5,  279), 4326), notes = 'Exact site for Arundale citation not specified.; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1048;
update sites set geometry=ST_SetSRID(ST_MakePoint(30.41,  -91.1,  16), 4326), notes = 'Exact site for Arundale citation not specified.; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1049;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.39,  -85.37,  286), 4326), notes = 'Exact site for Arundale citation not specified; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1050;
update sites set geometry=ST_SetSRID(ST_MakePoint(33.42,  -88.8,  108), 4326), notes = 'Exact site for Arundale citation not specified; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1051;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.46,  -74.43,  15), 4326), notes = 'Exact site not listed, but may be the New Jersey Agricultural Experiment Station, Rutgers School of Environmental and Biological Sciences, Department of Agricultural, Food, and Resource Economics; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1052;
update sites set geometry=ST_SetSRID(ST_MakePoint(35.99,  -97.05,  283), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1053;
update sites set geometry=ST_SetSRID(ST_MakePoint(43.64,  -80.41,  371), 4326), notes = 'Website: http://www.uoguelph.ca/plant/stations/elora/; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1054;
update sites set geometry=ST_SetSRID(ST_MakePoint(44.37,  -96.79,  519), 4326), notes = 'One mile north of USDA station headquarters; SW corner of 471st and 57th intersection. http://www.ars.usda.gov/main/site_main.htm?modecode=54-47-05-00; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1055;
update sites set geometry=ST_SetSRID(ST_MakePoint(25.42,  -101,  1604), 4326), notes = 'elevation queried using lat lon in Google Earth', updated_at = now() where id=  1060;
update sites set geometry=ST_SetSRID(ST_MakePoint(58,  26,  60), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1081;
update sites set geometry=ST_SetSRID(ST_MakePoint(53.987,  -105.117,  593), 4326), notes = 'Stand age in 2006: 123; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1086;
update sites set geometry=ST_SetSRID(ST_MakePoint(-2.75,  29.83,  1572), 4326), notes = '(Mlingano, Tanganyika)
Tanganyika from 1962 to 1964 the Republic of Tanganyika, was a sovereign state in East Africa.
eventually becoming known as modern-day Rwanda and Burundi.; elevation queried using lat lon in Google Earth', updated_at = now() where id=  1088;
update sites set geometry=ST_SetSRID(ST_MakePoint(-37.5667,  149.15,  97), 4326), notes = 'The study site is located 5 km southeast of Cann River,
Victoria, Australia. Cann River receives an average annual rainfall of 1009 mm and has mean daily minimum and maximum temperatures of 7.8 and 20.5 8C, respectively. The soil is a yellow Podzolic with a high content of coarse sand (Stace et al., 1968). Initial soilNconcentration was 1.10 g kg?1 (0–5 cm depth) and Bray I-P (Bray and Kurtz, 1945) concentration was 1.6 mg kg?1 (0–5 cm depth). Prior to trial establishment the site vegetation was a dry sclerophyll forest dominated by Eucalyptus sieberi (L. Johnson). E. globulus ssp. pseudoglobulus and A. mearnsii were planted in monocultures (100% E. globulus: 100%E; 100% A. mearnsii: 100%A) and in mixed-species plots that contained 50% E. globulus +50% A. mearnsii (50%E:50%A). ; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1093;
update sites set geometry=ST_SetSRID(ST_MakePoint(-5.2,  38.5,  302), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1095;
update sites set geometry=ST_SetSRID(ST_MakePoint(-3.4,  36.7,  1315), 4326), notes = 'elevation queried using lat lon in Google Earth', updated_at = now() where id=  1096;
update sites set geometry=ST_SetSRID(ST_MakePoint(-3.4,  36.6,  1370), 4326), notes = 'elevation queried using lat lon in Google Earth', updated_at = now() where id=  1097;
update sites set geometry=ST_SetSRID(ST_MakePoint(35.5,  80,  5883), 4326), notes = 'elevation queried using lat lon in Google Earth', updated_at = now() where id=  1101;
update sites set geometry=ST_SetSRID(ST_MakePoint(37.4,  -122.225,  176), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1103;
update sites set geometry=ST_SetSRID(ST_MakePoint(39.883,  -86.416,  279), 4326), notes = 'The region is covered primarily by late sec- ondary successional broadleaf forests located within the maple-beech to oak-hickory transition zone of the eastern deciduous forest. Twenty-nine tree species oc- cur in MMSF; dominant species (about 75% of total basal area) are sugar maple, yellow poplar, sassafras (Sassafras albidum Nutt.), white oak, and black oak (Quercus velutina Lam.). Common understory species include pawpaw (Asimina triloba L.), spicebush (Lin- dera benzoin L.), and sweet cicley (Osmorhiza clay- tonii Michx.), as well as seedlings and saplings of the dominant tree species; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1106;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.583,  -84.7,  214), 4326), notes = 'Bigtooth aspen (Populus grandidentata Michx.) and trembling aspen (Populus tremuloides Michx.) dominate within a 1km radius of the eddy-covariance tower, but with significant representation by red oak, beech (Fagus grandifolia Ehrh.), sugar maple, white pine, and hemlock as well. The understory is dominated by bracken fern (Pterid- ium aquilinum L.) and saplings of red maple, red oak, beech, and white pine. The presettlement white pine, red pine, hemlock forest was cut around 1880, and the area disturbed repeatedly by fire until 1923.; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1107;
update sites set geometry=ST_SetSRID(ST_MakePoint(45.783,  -90.083,  525), 4326), notes = 'The surrounding region is a mix of upland forests
and and wetlands, with aspen (Populus spp.) and northern hardwoods the most common upland types. The study site is occupied by an uneven-aged, closed-canopy forest dominated by sugar maple with significant American basswood (Tilia americana L.), green ash (Fraxinus pennsylvanica Marsh.), and red oak. The understory consists primarily of a mix of herba- ceous species, including P. aquilinum, with scattered seedlings and saplings of the overstory species.; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1108;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.8636,  -73.8783,  42), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1110;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.8978,  -73.8839,  40), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1111;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.8656,  -73.8083,  14), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1112;
update sites set geometry=ST_SetSRID(ST_MakePoint(40.982921,  -73.758563,  62), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1113;
update sites set geometry=ST_SetSRID(ST_MakePoint(41.307678,  -73.568024,  225), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1114;
update sites set geometry=ST_SetSRID(ST_MakePoint(41.8167,  -73.2833,  365), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1115;
update sites set geometry=ST_SetSRID(ST_MakePoint(41.9161,  -73.3091,  372), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1116;
update sites set geometry=ST_SetSRID(ST_MakePoint(0,  0,  0), 4326), notes = 'A generic site for the world, used, e.g., for inputs and outputs of global runs; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1118;
update sites set geometry=ST_SetSRID(ST_MakePoint(46.86,  -113.98,  1028), 4326), notes = 'elevation queried using lat lon in Google Earth', updated_at = now() where id=  1119;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.3331,  -85.3483,  246), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1120;
update sites set geometry=ST_SetSRID(ST_MakePoint(44.0776,  93.5075,  1303), 4326), notes = 'elevation queried using lat lon in Google Earth', updated_at = now() where id=  1122;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.531453,  -72.188896,  334), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1126;
update sites set geometry=ST_SetSRID(ST_MakePoint(40,  86,  946), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1127;
update sites set geometry=ST_SetSRID(ST_MakePoint(32.832802,  -83.637618,  134), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1128;
update sites set geometry=ST_SetSRID(ST_MakePoint(43.55,  -80.25,  325), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1130;
update sites set geometry=ST_SetSRID(ST_MakePoint(1.9333,  -67.05,  101), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1133;
update sites set geometry=ST_SetSRID(ST_MakePoint(-2.96,  -47.36,  137), 4326), notes = 'Paragominas is about 1750 mm with a distinct dry season from June to November; rainfall during the drier period is about 40 mm per month (Empresa Brasileira de Pesquisa Agropecuaria; rainfall data from town of Paragominas, 1973-82).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1136;
update sites set geometry=ST_SetSRID(ST_MakePoint(-2.96,  -47.36,  137), 4326), notes = 'Paragominas is about 1750 mm with a distinct dry season from June to November; rainfall during the drier period is about 40 mm per month (Empresa Brasileira de Pesquisa Agropecuaria; rainfall data from town of Paragominas, 1973-82).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1137;
update sites set geometry=ST_SetSRID(ST_MakePoint(-2.96,  -47.36,  137), 4326), notes = 'Paragominas is about 1750 mm with a distinct dry season from June to November; rainfall during the drier period is about 40 mm per month (Empresa Brasileira de Pesquisa Agropecuaria; rainfall data from town of Paragominas, 1973-82).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1138;
update sites set geometry=ST_SetSRID(ST_MakePoint(-2.96,  -47.36,  137), 4326), notes = 'Paragominas is about 1750 mm with a distinct dry season from June to November; rainfall during the drier period is about 40 mm per month (Empresa Brasileira de Pesquisa Agropecuaria; rainfall data from town of Paragominas, 1973-82).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1139;
update sites set geometry=ST_SetSRID(ST_MakePoint(-2.96,  -47.36,  137), 4326), notes = 'Paragominas is about 1750 mm with a distinct dry season from June to November; rainfall during the drier period is about 40 mm per month (Empresa Brasileira de Pesquisa Agropecuaria; rainfall data from town of Paragominas, 1973-82).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1140;
update sites set geometry=ST_SetSRID(ST_MakePoint(-2.96,  -47.36,  137), 4326), notes = 'Paragominas is about 1750 mm with a distinct dry season from June to November; rainfall during the drier period is about 40 mm per month (Empresa Brasileira de Pesquisa Agropecuaria; rainfall data from town of Paragominas, 1973-82).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1141;
update sites set geometry=ST_SetSRID(ST_MakePoint(-2.96,  -47.36,  137), 4326), notes = 'Paragominas is about 1750 mm with a distinct dry season from June to November; rainfall during the drier period is about 40 mm per month (Empresa Brasileira de Pesquisa Agropecuaria; rainfall data from town of Paragominas, 1973-82).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1142;
update sites set geometry=ST_SetSRID(ST_MakePoint(-2.96,  -47.36,  137), 4326), notes = 'Paragominas is about 1750 mm with a distinct dry season from June to November; rainfall during the drier period is about 40 mm per month (Empresa Brasileira de Pesquisa Agropecuaria; rainfall data from town of Paragominas, 1973-82).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1143;
update sites set geometry=ST_SetSRID(ST_MakePoint(-2.96,  -47.36,  137), 4326), notes = 'Paragominas is about 1750 mm with a distinct dry season from June to November; rainfall during the drier period is about 40 mm per month (Empresa Brasileira de Pesquisa Agropecuaria; rainfall data from town of Paragominas, 1973-82).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1144;
update sites set geometry=ST_SetSRID(ST_MakePoint(-2.96,  -47.36,  137), 4326), notes = 'Paragominas is about 1750 mm with a distinct dry season from June to November; rainfall during the drier period is about 40 mm per month (Empresa Brasileira de Pesquisa Agropecuaria; rainfall data from town of Paragominas, 1973-82).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1145;
update sites set geometry=ST_SetSRID(ST_MakePoint(-2.96,  -47.36,  137), 4326), notes = 'Paragominas is about 1750 mm with a distinct dry season from June to November; rainfall during the drier period is about 40 mm per month (Empresa Brasileira de Pesquisa Agropecuaria; rainfall data from town of Paragominas, 1973-82).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1146;
update sites set geometry=ST_SetSRID(ST_MakePoint(-2.96,  -47.36,  137), 4326), notes = 'Paragominas is about 1750 mm with a distinct dry season from June to November; rainfall during the drier period is about 40 mm per month (Empresa Brasileira de Pesquisa Agropecuaria; rainfall data from town of Paragominas, 1973-82).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1147;
update sites set geometry=ST_SetSRID(ST_MakePoint(-2.96,  -47.36,  137), 4326), notes = 'Paragominas is about 1750 mm with a distinct dry season from June to November; rainfall during the drier period is about 40 mm per month (Empresa Brasileira de Pesquisa Agropecuaria; rainfall data from town of Paragominas, 1973-82).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1148;
update sites set geometry=ST_SetSRID(ST_MakePoint(-2.96,  -47.36,  137), 4326), notes = 'Paragominas is about 1750 mm with a distinct dry season from June to November; rainfall during the drier period is about 40 mm per month (Empresa Brasileira de Pesquisa Agropecuaria; rainfall data from town of Paragominas, 1973-82).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1149;
update sites set geometry=ST_SetSRID(ST_MakePoint(-2.96,  -47.36,  137), 4326), notes = 'Paragominas is about 1750 mm with a distinct dry season from June to November; rainfall during the drier period is about 40 mm per month (Empresa Brasileira de Pesquisa Agropecuaria; rainfall data from town of Paragominas, 1973-82).; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1150;
update sites set geometry=ST_SetSRID(ST_MakePoint(-7.8,  -35.25,  105), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1155;
update sites set geometry=ST_SetSRID(ST_MakePoint(-9.5,  -53.81,  335), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1156;
update sites set geometry=ST_SetSRID(ST_MakePoint(-21.8,  -48.6,  495), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1157;
update sites set geometry=ST_SetSRID(ST_MakePoint(-20.1,  -51,  323), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1158;
update sites set geometry=ST_SetSRID(ST_MakePoint(-22.9,  -48.4,  791), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1159;
update sites set geometry=ST_SetSRID(ST_MakePoint(0,  0,  0), 4326), notes = 'This site represents the the whole world - the entire earth surface. The land surface is site 1118 (https://www.betydb.org/sites/1118) ; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1160;
update sites set geometry=ST_SetSRID(ST_MakePoint(-16.5,  145.4,  23), 4326), notes = 'Coordinates are for the city Mossman. ; elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1162;
update sites set geometry=ST_SetSRID(ST_MakePoint(-16.39,  145.38,  10), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1163;
update sites set geometry=ST_SetSRID(ST_MakePoint(21.38,  -157.928,  33), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1176;
update sites set geometry=ST_SetSRID(ST_MakePoint(-21.141,  149.186,  11), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1177;
update sites set geometry=ST_SetSRID(ST_MakePoint(27.034664,  88.262787,  2160), 4326), notes = 'elevation queried using lat lon in Google Earth', updated_at = now() where id=  1179;
update sites set geometry=ST_SetSRID(ST_MakePoint(-33.880449,  151.188354,  32), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1180;
update sites set geometry=ST_SetSRID(ST_MakePoint(26.25,  127.77,  128), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1181;
update sites set geometry=ST_SetSRID(ST_MakePoint(21.389,  -157.914,  177), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1182;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.47,  -76.07,  454), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1185;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.47,  -76.07,  454), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1186;
update sites set geometry=ST_SetSRID(ST_MakePoint(42.47,  -76.07,  454), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1187;
update sites set geometry=ST_SetSRID(ST_MakePoint(26.91,  -80.61,  8), 4326), notes = 'elevation queried from lat lon using R geonames::GNstrm3', updated_at = now() where id=  1189;

update_sites_switch_latlon.sql

update sites set geometry=ST_SetSRID(ST_MakePoint(-96.68, 44.28,   495), 4326),  updated_at = now() where id=  12;
update sites set geometry=ST_SetSRID(ST_MakePoint(-95.4, 29.72,   22), 4326),  updated_at = now() where id=  100;
update sites set geometry=ST_SetSRID(ST_MakePoint(-122.17, 47.17,   167), 4326),  updated_at = now() where id=  156;
update sites set geometry=ST_SetSRID(ST_MakePoint(-3.45, 50.63,   3), 4326),  updated_at = now() where id=  186;
update sites set geometry=ST_SetSRID(ST_MakePoint(0.11, 52.42,   -1), 4326),  updated_at = now() where id=  199;
update sites set geometry=ST_SetSRID(ST_MakePoint(7.09, 52.79,   13), 4326),  updated_at = now() where id=  200;
update sites set geometry=ST_SetSRID(ST_MakePoint(0.1, 52.42,   -1), 4326),  updated_at = now() where id=  208;
update sites set geometry=ST_SetSRID(ST_MakePoint(-2.64, 52.13,   76), 4326),  updated_at = now() where id=  209;
update sites set geometry=ST_SetSRID(ST_MakePoint(-6.25, 53.34,   11), 4326),  updated_at = now() where id=  216;
update sites set geometry=ST_SetSRID(ST_MakePoint(-6.23, 53.33,   3), 4326),  updated_at = now() where id=  217;
update sites set geometry=ST_SetSRID(ST_MakePoint(10.52, 52.26,   73), 4326),  updated_at = now() where id=  223;
update sites set geometry=ST_SetSRID(ST_MakePoint(6.84, 52.21,   30), 4326),  updated_at = now() where id=  224;
update sites set geometry=ST_SetSRID(ST_MakePoint(8.86, 50.13,   104), 4326),  updated_at = now() where id=  225;
update sites set geometry=ST_SetSRID(ST_MakePoint(10.28, 53.66,   52), 4326),  updated_at = now() where id=  226;
update sites set geometry=ST_SetSRID(ST_MakePoint(4.35, 50.85,   28), 4326),  updated_at = now() where id=  227;
update sites set geometry=ST_SetSRID(ST_MakePoint(16.57, 40.18,   186), 4326),  updated_at = now() where id=  228;
update sites set geometry=ST_SetSRID(ST_MakePoint(11.09, 44.17,   712), 4326),  updated_at = now() where id=  229;
update sites set geometry=ST_SetSRID(ST_MakePoint(-97.21, 49.89,   234), 4326),  updated_at = now() where id=  254;
update sites set geometry=ST_SetSRID(ST_MakePoint(-1.11, 53.23,   64), 4326),  updated_at = now() where id=  271;
update sites set geometry=ST_SetSRID(ST_MakePoint(20.57, 38.17,   525), 4326),  updated_at = now() where id=  281;
update sites set geometry=ST_SetSRID(ST_MakePoint(21.95, 51.4,   117), 4326),  updated_at = now() where id=  283;
update sites set geometry=ST_SetSRID(ST_MakePoint(-81.3125, 31.317222,   0), 4326),  updated_at = now() where id=  285;
update sites set geometry=ST_SetSRID(ST_MakePoint(-81.366667, 31.33,   0), 4326),  updated_at = now() where id=  286;
update sites set geometry=ST_SetSRID(ST_MakePoint(-48.483333, -25.416667,   19), 4326),  updated_at = now() where id=  287;
update sites set geometry=ST_SetSRID(ST_MakePoint(-81.280078, 31.397417,   6), 4326),  updated_at = now() where id=  288;
update sites set geometry=ST_SetSRID(ST_MakePoint(-71.320383, 41.625767,   3), 4326),  updated_at = now() where id=  289;
update sites set geometry=ST_SetSRID(ST_MakePoint(0.55, 51.88,   73), 4326),  updated_at = now() where id=  290;
update sites set geometry=ST_SetSRID(ST_MakePoint(0.9, 51.89,   35), 4326),  updated_at = now() where id=  291;
update sites set geometry=ST_SetSRID(ST_MakePoint(26.77, 58.45,   54), 4326),  updated_at = now() where id=  292;
update sites set geometry=ST_SetSRID(ST_MakePoint(-110.85, 32.58,   1190), 4326),  updated_at = now() where id=  293;
update sites set geometry=ST_SetSRID(ST_MakePoint(-105.16, 39.74,   1737), 4326),  updated_at = now() where id=  294;
update sites set geometry=ST_SetSRID(ST_MakePoint(-85.486128, 32.603385,   212), 4326),  updated_at = now() where id=  295;
update sites set geometry=ST_SetSRID(ST_MakePoint(6.67, 53,   7), 4326),  updated_at = now() where id=  297;
update sites set geometry=ST_SetSRID(ST_MakePoint(-93.5, 42.18,   318), 4326),  updated_at = now() where id=  299;
update sites set geometry=ST_SetSRID(ST_MakePoint(-78.48, 36.02,   130), 4326),  updated_at = now() where id=  302;
update sites set geometry=ST_SetSRID(ST_MakePoint(-83.59, 35.71,   1028), 4326),  updated_at = now() where id=  308;
update sites set geometry=ST_SetSRID(ST_MakePoint(-83.44, 35.71,   691), 4326),  updated_at = now() where id=  309;
update sites set geometry=ST_SetSRID(ST_MakePoint(-89.423525, 43.077455,   265), 4326),  updated_at = now() where id=  311;
update sites set geometry=ST_SetSRID(ST_MakePoint(-88.53, 46.56,   507), 4326),  updated_at = now() where id=  316;
update sites set geometry=ST_SetSRID(ST_MakePoint(-77.86, 40.79,   355), 4326),  updated_at = now() where id=  317;
update sites set geometry=ST_SetSRID(ST_MakePoint(-0.84, 51.14,   76), 4326),  updated_at = now() where id=  320;
update sites set geometry=ST_SetSRID(ST_MakePoint(-90.66, 29.24,   2), 4326),  updated_at = now() where id=  321;
update sites set geometry=ST_SetSRID(ST_MakePoint(15.01, 49.15,   478), 4326),  updated_at = now() where id=  324;
update sites set geometry=ST_SetSRID(ST_MakePoint(-113.52, 53.52,   680), 4326),  updated_at = now() where id=  325;
update sites set geometry=ST_SetSRID(ST_MakePoint(-75.69, 45.42,   73), 4326),  updated_at = now() where id=  329;
update sites set geometry=ST_SetSRID(ST_MakePoint(-91.79, 33.19,   55), 4326),  updated_at = now() where id=  330;
update sites set geometry=ST_SetSRID(ST_MakePoint(-82.929978, 29.400173,   22), 4326),  updated_at = now() where id=  331;
update sites set geometry=ST_SetSRID(ST_MakePoint(-123.26, 44.57,   71), 4326),  updated_at = now() where id=  332;
update sites set geometry=ST_SetSRID(ST_MakePoint(-149.605322, 68.633132,   3), 4326),  updated_at = now() where id=  333;
update sites set geometry=ST_SetSRID(ST_MakePoint(4.41, 51.22,   12), 4326),  updated_at = now() where id=  337;
update sites set geometry=ST_SetSRID(ST_MakePoint(-78.898373, 35.994758,   124), 4326),  updated_at = now() where id=  339;
update sites set geometry=ST_SetSRID(ST_MakePoint(-72.928476, 41.310347,   19), 4326),  updated_at = now() where id=  340;
update sites set geometry=ST_SetSRID(ST_MakePoint(-84.269314, 36.012811,   273), 4326),  updated_at = now() where id=  341;
update sites set geometry=ST_SetSRID(ST_MakePoint(-75.83, 39.6,   5), 4326),  updated_at = now() where id=  342;
update sites set geometry=ST_SetSRID(ST_MakePoint(-86.25, 41.68,   215), 4326),  updated_at = now() where id=  343;
update sites set geometry=ST_SetSRID(ST_MakePoint(-117, 46.73,   785), 4326),  updated_at = now() where id=  346;
update sites set geometry=ST_SetSRID(ST_MakePoint(-71.449748, 43.559996,   157), 4326),  updated_at = now() where id=  348;
update sites set geometry=ST_SetSRID(ST_MakePoint(-117.39, 33.95,   259), 4326),  updated_at = now() where id=  349;
update sites set geometry=ST_SetSRID(ST_MakePoint(-84.067726, 36.196356,   332), 4326),  updated_at = now() where id=  350;
update sites set geometry=ST_SetSRID(ST_MakePoint(-85.9, 32.44,   64), 4326),  updated_at = now() where id=  351;
update sites set geometry=ST_SetSRID(ST_MakePoint(-85.65, 32.83,   197), 4326),  updated_at = now() where id=  352;
update sites set geometry=ST_SetSRID(ST_MakePoint(-88.716667, 35.933333,   134), 4326),  updated_at = now() where id=  353;
update sites set geometry=ST_SetSRID(ST_MakePoint(138.21, 36.310047,   695), 4326),  updated_at = now() where id=  355;
update sites set geometry=ST_SetSRID(ST_MakePoint(-147.717, 64.85,   136), 4326),  updated_at = now() where id=  356;
update sites set geometry=ST_SetSRID(ST_MakePoint(-83.41, 33.86,   229), 4326),  updated_at = now() where id=  357;
update sites set geometry=ST_SetSRID(ST_MakePoint(139.61, 35.86,   7), 4326),  updated_at = now() where id=  358;
update sites set geometry=ST_SetSRID(ST_MakePoint(-37.63, -7.96,   598), 4326),  updated_at = now() where id=  359;
update sites set geometry=ST_SetSRID(ST_MakePoint(-97.31, 35.67,   295), 4326),  updated_at = now() where id=  360;
update sites set geometry=ST_SetSRID(ST_MakePoint(-84.51, 45.33,   255), 4326),  updated_at = now() where id=  361;
update sites set geometry=ST_SetSRID(ST_MakePoint(-46.63, -23.63,   761), 4326),  updated_at = now() where id=  362;
update sites set geometry=ST_SetSRID(ST_MakePoint(-149.75, 68.07,   936), 4326),  updated_at = now() where id=  363;
update sites set geometry=ST_SetSRID(ST_MakePoint(114.65, 30.86,   31), 4326),  updated_at = now() where id=  365;
update sites set geometry=ST_SetSRID(ST_MakePoint(144.43, -37.93,   212), 4326),  updated_at = now() where id=  366;
update sites set geometry=ST_SetSRID(ST_MakePoint(144.75, -37.82,   44), 4326),  updated_at = now() where id=  367;
update sites set geometry=ST_SetSRID(ST_MakePoint(16.13, 51.41,   160), 4326),  updated_at = now() where id=  370;
update sites set geometry=ST_SetSRID(ST_MakePoint(16.07, 59.48,   3), 4326),  updated_at = now() where id=  371;
update sites set geometry=ST_SetSRID(ST_MakePoint(80, 7,   31), 4326),  updated_at = now() where id=  372;
update sites set geometry=ST_SetSRID(ST_MakePoint(80.69, 7.27,   448), 4326),  updated_at = now() where id=  373;
update sites set geometry=ST_SetSRID(ST_MakePoint(-149.75, 68.07,   936), 4326),  updated_at = now() where id=  374;
update sites set geometry=ST_SetSRID(ST_MakePoint(16.63, 48.26,   149), 4326),  updated_at = now() where id=  375;
update sites set geometry=ST_SetSRID(ST_MakePoint(14, 55.6,   89), 4326),  updated_at = now() where id=  376;
update sites set geometry=ST_SetSRID(ST_MakePoint(9.58, 56.5,   33), 4326),  updated_at = now() where id=  377;
update sites set geometry=ST_SetSRID(ST_MakePoint(0.35, 51.8,   60), 4326),  updated_at = now() where id=  378;
update sites set geometry=ST_SetSRID(ST_MakePoint(9, 48.67,   487), 4326),  updated_at = now() where id=  379;
update sites set geometry=ST_SetSRID(ST_MakePoint(-93.58, 33.67,   107), 4326),  updated_at = now() where id=  380;
update sites set geometry=ST_SetSRID(ST_MakePoint(-8.64, 42.61,   76), 4326),  updated_at = now() where id=  381;
update sites set geometry=ST_SetSRID(ST_MakePoint(-96.64, 39.14,   317), 4326),  updated_at = now() where id=  382;
update sites set geometry=ST_SetSRID(ST_MakePoint(-147.717, 64.85,   136), 4326),  updated_at = now() where id=  383;
update sites set geometry=ST_SetSRID(ST_MakePoint(145.93, -17.94,   19), 4326),  updated_at = now() where id=  385;
update sites set geometry=ST_SetSRID(ST_MakePoint(5.78, 52.25,   33), 4326),  updated_at = now() where id=  386;
update sites set geometry=ST_SetSRID(ST_MakePoint(5.83, 52.08,   36), 4326),  updated_at = now() where id=  387;
update sites set geometry=ST_SetSRID(ST_MakePoint(22.26, 60.45,   10), 4326),  updated_at = now() where id=  388;
update sites set geometry=ST_SetSRID(ST_MakePoint(19, 68.333333,   606), 4326),  updated_at = now() where id=  389;
update sites set geometry=ST_SetSRID(ST_MakePoint(3.72, 51.03,   10), 4326),  updated_at = now() where id=  398;
update sites set geometry=ST_SetSRID(ST_MakePoint(-88.78, 43.78,   303), 4326),  updated_at = now() where id=  400;
update sites set geometry=ST_SetSRID(ST_MakePoint(-88.78, 43.78,   303), 4326),  updated_at = now() where id=  401;
update sites set geometry=ST_SetSRID(ST_MakePoint(-73.54, 52.93,   433), 4326),  updated_at = now() where id=  402;
update sites set geometry=ST_SetSRID(ST_MakePoint(-77.42, 45.99,   184), 4326),  updated_at = now() where id=  403;
update sites set geometry=ST_SetSRID(ST_MakePoint(119.32, 33.13,   3), 4326),  updated_at = now() where id=  404;
update sites set geometry=ST_SetSRID(ST_MakePoint(-76.75, 38.82,   9), 4326),  updated_at = now() where id=  405;
update sites set geometry=ST_SetSRID(ST_MakePoint(22.75, 60.5,   41), 4326),  updated_at = now() where id=  406;
update sites set geometry=ST_SetSRID(ST_MakePoint(-76.37, 41.29,   312), 4326),  updated_at = now() where id=  407;
update sites set geometry=ST_SetSRID(ST_MakePoint(-2.65, 51.43,   19), 4326),  updated_at = now() where id=  408;
update sites set geometry=ST_SetSRID(ST_MakePoint(0.88, 52.61,   63), 4326),  updated_at = now() where id=  409;
update sites set geometry=ST_SetSRID(ST_MakePoint(-0.83, 51.12,   94), 4326),  updated_at = now() where id=  410;
update sites set geometry=ST_SetSRID(ST_MakePoint(16.25, 49.53,   562), 4326),  updated_at = now() where id=  411;
update sites set geometry=ST_SetSRID(ST_MakePoint(8.79, 45.47,   112), 4326),  updated_at = now() where id=  413;
update sites set geometry=ST_SetSRID(ST_MakePoint(8.68, 45.05,   88), 4326),  updated_at = now() where id=  415;
update sites set geometry=ST_SetSRID(ST_MakePoint(9.26, 45.18,   71), 4326),  updated_at = now() where id=  416;
update sites set geometry=ST_SetSRID(ST_MakePoint(9.28, 45.21,   0), 4326),  updated_at = now() where id=  417;
update sites set geometry=ST_SetSRID(ST_MakePoint(11.47, 44.98,   4), 4326),  updated_at = now() where id=  418;
update sites set geometry=ST_SetSRID(ST_MakePoint(9.27, 45.19,   71), 4326),  updated_at = now() where id=  419;
update sites set geometry=ST_SetSRID(ST_MakePoint(9.27, 45.16,   74), 4326),  updated_at = now() where id=  420;
update sites set geometry=ST_SetSRID(ST_MakePoint(10.87, 45.87,   62), 4326),  updated_at = now() where id=  421;
update sites set geometry=ST_SetSRID(ST_MakePoint(10.08, 45.52,   125), 4326),  updated_at = now() where id=  422;
update sites set geometry=ST_SetSRID(ST_MakePoint(10.01, 45.4,   83), 4326),  updated_at = now() where id=  423;
update sites set geometry=ST_SetSRID(ST_MakePoint(15.05, 41.03,   700), 4326),  updated_at = now() where id=  424;
update sites set geometry=ST_SetSRID(ST_MakePoint(12.68, 45.58,   1), 4326),  updated_at = now() where id=  425;
update sites set geometry=ST_SetSRID(ST_MakePoint(12.87, 45.59,   0), 4326),  updated_at = now() where id=  426;
update sites set geometry=ST_SetSRID(ST_MakePoint(11.93, 45.22,   1), 4326),  updated_at = now() where id=  427;
update sites set geometry=ST_SetSRID(ST_MakePoint(11.87, 45.23,   5), 4326),  updated_at = now() where id=  428;
update sites set geometry=ST_SetSRID(ST_MakePoint(1.9, 47.9,   108), 4326),  updated_at = now() where id=  430;
update sites set geometry=ST_SetSRID(ST_MakePoint(12.04, 48.94,   343), 4326),  updated_at = now() where id=  431;
update sites set geometry=ST_SetSRID(ST_MakePoint(8.92, 51.4,   345), 4326),  updated_at = now() where id=  432;
update sites set geometry=ST_SetSRID(ST_MakePoint(8.43, 52.89,   30), 4326),  updated_at = now() where id=  433;
update sites set geometry=ST_SetSRID(ST_MakePoint(-123.3, 47.28,   184), 4326),  updated_at = now() where id=  435;
update sites set geometry=ST_SetSRID(ST_MakePoint(-70.77, 43.13,   12), 4326),  updated_at = now() where id=  436;
update sites set geometry=ST_SetSRID(ST_MakePoint(-79.3, 47,   269), 4326),  updated_at = now() where id=  437;
update sites set geometry=ST_SetSRID(ST_MakePoint(-78.08, 48.58,   321), 4326),  updated_at = now() where id=  438;
update sites set geometry=ST_SetSRID(ST_MakePoint(2.33, 48.83,   70), 4326),  updated_at = now() where id=  440;
update sites set geometry=ST_SetSRID(ST_MakePoint(-95.78, 47.9,   352), 4326),  updated_at = now() where id=  441;
update sites set geometry=ST_SetSRID(ST_MakePoint(79.33, 29.05,   223), 4326),  updated_at = now() where id=  442;
update sites set geometry=ST_SetSRID(ST_MakePoint(-3.15, 51.97,   730), 4326),  updated_at = now() where id=  443;
update sites set geometry=ST_SetSRID(ST_MakePoint(0.08, 52.17,   14), 4326),  updated_at = now() where id=  444;
update sites set geometry=ST_SetSRID(ST_MakePoint(13.22, 52.14,   53), 4326),  updated_at = now() where id=  445;
update sites set geometry=ST_SetSRID(ST_MakePoint(-1.97, 51.71,   123), 4326),  updated_at = now() where id=  446;
update sites set geometry=ST_SetSRID(ST_MakePoint(-1.55, 53.8,   49), 4326),  updated_at = now() where id=  447;
update sites set geometry=ST_SetSRID(ST_MakePoint(-0.42, 52.01,   62), 4326),  updated_at = now() where id=  448;
update sites set geometry=ST_SetSRID(ST_MakePoint(1.87, 47.77,   113), 4326),  updated_at = now() where id=  449;
update sites set geometry=ST_SetSRID(ST_MakePoint(7.67, 44.7,   284), 4326),  updated_at = now() where id=  450;
update sites set geometry=ST_SetSRID(ST_MakePoint(-0.83, 51.12,   94), 4326),  updated_at = now() where id=  451;
update sites set geometry=ST_SetSRID(ST_MakePoint(-116.6, 53.9,   1255), 4326),  updated_at = now() where id=  453;
update sites set geometry=ST_SetSRID(ST_MakePoint(-90, 46,   500), 4326),  updated_at = now() where id=  454;
update sites set geometry=ST_SetSRID(ST_MakePoint(-4.1301, 53.2289,   56), 4326),  updated_at = now() where id=  460;
update sites set geometry=ST_SetSRID(ST_MakePoint(-4.63, 56.41,   265), 4326),  updated_at = now() where id=  461;
update sites set geometry=ST_SetSRID(ST_MakePoint(-3.46, 56.11,   172), 4326),  updated_at = now() where id=  462;
update sites set geometry=ST_SetSRID(ST_MakePoint(-145.5, 65.43333,   783), 4326),  updated_at = now() where id=  463;
update sites set geometry=ST_SetSRID(ST_MakePoint(18.63, 68.35,   1046), 4326),  updated_at = now() where id=  464;
update sites set geometry=ST_SetSRID(ST_MakePoint(-97, 55.5,   205), 4326),  updated_at = now() where id=  465;
update sites set geometry=ST_SetSRID(ST_MakePoint(-97, 55.5,   205), 4326),  updated_at = now() where id=  466;
update sites set geometry=ST_SetSRID(ST_MakePoint(-97, 55.5,   205), 4326),  updated_at = now() where id=  467;
update sites set geometry=ST_SetSRID(ST_MakePoint(18.65, 68.35,   971), 4326),  updated_at = now() where id=  468;
update sites set geometry=ST_SetSRID(ST_MakePoint(18.67, 68.35,   1023), 4326),  updated_at = now() where id=  469;
update sites set geometry=ST_SetSRID(ST_MakePoint(-145.5, 65.166667,   689), 4326),  updated_at = now() where id=  470;
update sites set geometry=ST_SetSRID(ST_MakePoint(78.416, 30.25,   1677), 4326),  updated_at = now() where id=  471;
update sites set geometry=ST_SetSRID(ST_MakePoint(-157.916667, 70.45,   15), 4326),  updated_at = now() where id=  472;
update sites set geometry=ST_SetSRID(ST_MakePoint(-149.56667, 68.633333,   762), 4326),  updated_at = now() where id=  473;
update sites set geometry=ST_SetSRID(ST_MakePoint(18.81667, 68.35,   396), 4326),  updated_at = now() where id=  474;
update sites set geometry=ST_SetSRID(ST_MakePoint(-149.56667, 68.633333,   762), 4326),  updated_at = now() where id=  475;
update sites set geometry=ST_SetSRID(ST_MakePoint(-149.56667, 68.633333,   762), 4326),  updated_at = now() where id=  476;
update sites set geometry=ST_SetSRID(ST_MakePoint(18.533333, 49.55,   759), 4326),  updated_at = now() where id=  477;
update sites set geometry=ST_SetSRID(ST_MakePoint(-101.83, 41.465,   1141), 4326),  updated_at = now() where id=  478;
update sites set geometry=ST_SetSRID(ST_MakePoint(-101.71, 41.12,   977), 4326),  updated_at = now() where id=  479;
update sites set geometry=ST_SetSRID(ST_MakePoint(-101.8189, 41.4734,   1102), 4326),  updated_at = now() where id=  480;
update sites set geometry=ST_SetSRID(ST_MakePoint(11.31, 47.11,   979), 4326),  updated_at = now() where id=  482;
update sites set geometry=ST_SetSRID(ST_MakePoint(11.28, 46.83,   1575), 4326),  updated_at = now() where id=  483;
update sites set geometry=ST_SetSRID(ST_MakePoint(11.01, 46.02,   1290), 4326),  updated_at = now() where id=  484;
update sites set geometry=ST_SetSRID(ST_MakePoint(-87.183, 30.833,   80), 4326),  updated_at = now() where id=  485;
update sites set geometry=ST_SetSRID(ST_MakePoint(-113.5, 53.333,   699), 4326),  updated_at = now() where id=  486;
update sites set geometry=ST_SetSRID(ST_MakePoint(-93.983, 35.083,   153), 4326),  updated_at = now() where id=  488;
update sites set geometry=ST_SetSRID(ST_MakePoint(-80.683, 37.35,   574), 4326),  updated_at = now() where id=  489;
update sites set geometry=ST_SetSRID(ST_MakePoint(-76.466, 36.583,   27), 4326),  updated_at = now() where id=  490;
update sites set geometry=ST_SetSRID(ST_MakePoint(16.667, 59.617,   40), 4326),  updated_at = now() where id=  492;
update sites set geometry=ST_SetSRID(ST_MakePoint(-3.16, 55.94,   88), 4326),  updated_at = now() where id=  493;
update sites set geometry=ST_SetSRID(ST_MakePoint(-149.566667, 68.633333,   762), 4326),  updated_at = now() where id=  494;
update sites set geometry=ST_SetSRID(ST_MakePoint(-149.36667, 68.45,   803), 4326),  updated_at = now() where id=  495;
update sites set geometry=ST_SetSRID(ST_MakePoint(-149.566667, 68.633333,   762), 4326),  updated_at = now() where id=  496;
update sites set geometry=ST_SetSRID(ST_MakePoint(-149.566667, 68.633333,   762), 4326),  updated_at = now() where id=  497;
update sites set geometry=ST_SetSRID(ST_MakePoint(-72.905, 41.424,   36), 4326),  updated_at = now() where id=  498;
update sites set geometry=ST_SetSRID(ST_MakePoint(-77.85, 40.78,   344), 4326),  updated_at = now() where id=  499;
update sites set geometry=ST_SetSRID(ST_MakePoint(-89.62, 45.44,   473), 4326),  updated_at = now() where id=  500;
update sites set geometry=ST_SetSRID(ST_MakePoint(-158.0282, 21.687,   5), 4326),  updated_at = now() where id=  501;
update sites set geometry=ST_SetSRID(ST_MakePoint(-156.050251, 20.652161,   35), 4326),  updated_at = now() where id=  502;
update sites set geometry=ST_SetSRID(ST_MakePoint(-159.3353, 22,   18), 4326),  updated_at = now() where id=  503;
update sites set geometry=ST_SetSRID(ST_MakePoint(-90.92, 43.91,   228), 4326),  updated_at = now() where id=  507;
update sites set geometry=ST_SetSRID(ST_MakePoint(-90.92, 43.91,   228), 4326),  updated_at = now() where id=  508;
update sites set geometry=ST_SetSRID(ST_MakePoint(-90.92, 43.91,   228), 4326),  updated_at = now() where id=  509;
update sites set geometry=ST_SetSRID(ST_MakePoint(-91.03, 43.97,   335), 4326),  updated_at = now() where id=  510;
update sites set geometry=ST_SetSRID(ST_MakePoint(146.191389, -18.858889,   19), 4326),  updated_at = now() where id=  511;
update sites set geometry=ST_SetSRID(ST_MakePoint(-76.54, 42.2,   313), 4326),  updated_at = now() where id=  512;
update sites set geometry=ST_SetSRID(ST_MakePoint(-76.75, 42.96,   124), 4326),  updated_at = now() where id=  513;
update sites set geometry=ST_SetSRID(ST_MakePoint(-76.73, 42.37,   402), 4326),  updated_at = now() where id=  515;
update sites set geometry=ST_SetSRID(ST_MakePoint(-77.25, 37.36,   0), 4326),  updated_at = now() where id=  520;
update sites set geometry=ST_SetSRID(ST_MakePoint(-76.61, 42.54,   236), 4326),  updated_at = now() where id=  521;
update sites set geometry=ST_SetSRID(ST_MakePoint(-76.49, 42.19,   456), 4326),  updated_at = now() where id=  522;
update sites set geometry=ST_SetSRID(ST_MakePoint(-76.38, 42.36,   544), 4326),  updated_at = now() where id=  523;
update sites set geometry=ST_SetSRID(ST_MakePoint(-78.56, 38.72,   751), 4326),  updated_at = now() where id=  524;
update sites set geometry=ST_SetSRID(ST_MakePoint(127, 37.57,   35), 4326),  updated_at = now() where id=  525;
update sites set geometry=ST_SetSRID(ST_MakePoint(-83.65, 37.77,   301), 4326),  updated_at = now() where id=  526;
update sites set geometry=ST_SetSRID(ST_MakePoint(-74.3, 42.2,   778), 4326),  updated_at = now() where id=  527;
update sites set geometry=ST_SetSRID(ST_MakePoint(-87.52, 46.04,   316), 4326),  updated_at = now() where id=  528;
update sites set geometry=ST_SetSRID(ST_MakePoint(-86.67, 46.17,   249), 4326),  updated_at = now() where id=  529;
update sites set geometry=ST_SetSRID(ST_MakePoint(-76.49, 42.44,   167), 4326),  updated_at = now() where id=  530;
update sites set geometry=ST_SetSRID(ST_MakePoint(-77.856, 40.789,   339), 4326),  updated_at = now() where id=  531;
update sites set geometry=ST_SetSRID(ST_MakePoint(-79.14, 41.84,   363), 4326),  updated_at = now() where id=  550;
update sites set geometry=ST_SetSRID(ST_MakePoint(-74.02, 41.4,   390), 4326),  updated_at = now() where id=  551;
update sites set geometry=ST_SetSRID(ST_MakePoint(127.05, 37.47,   51), 4326),  updated_at = now() where id=  552;
update sites set geometry=ST_SetSRID(ST_MakePoint(126.59, 37.57,   5), 4326),  updated_at = now() where id=  553;
update sites set geometry=ST_SetSRID(ST_MakePoint(-78.02, 40.92,   714), 4326),  updated_at = now() where id=  554;
update sites set geometry=ST_SetSRID(ST_MakePoint(-82.84, 34.68,   217), 4326),  updated_at = now() where id=  555;
update sites set geometry=ST_SetSRID(ST_MakePoint(96.4883, 41.2261,   1990), 4326),  updated_at = now() where id=  558;
update sites set geometry=ST_SetSRID(ST_MakePoint(-106.38, 53.92,   676), 4326),  updated_at = now() where id=  560;
update sites set geometry=ST_SetSRID(ST_MakePoint(153.09, -26.79,   16), 4326),  updated_at = now() where id=  562;
update sites set geometry=ST_SetSRID(ST_MakePoint(-116.57, 53.93,   1295), 4326),  updated_at = now() where id=  563;
update sites set geometry=ST_SetSRID(ST_MakePoint(-47.38, -22.35,   609), 4326),  updated_at = now() where id=  564;
update sites set geometry=ST_SetSRID(ST_MakePoint(-82.84, 34.68,   217), 4326),  updated_at = now() where id=  567;
update sites set geometry=ST_SetSRID(ST_MakePoint(-81.667, 33.383,   121), 4326),  updated_at = now() where id=  569;
update sites set geometry=ST_SetSRID(ST_MakePoint(-52.43, -23.083,   447), 4326),  updated_at = now() where id=  571;
update sites set geometry=ST_SetSRID(ST_MakePoint(-1.333, 51.77,   160), 4326),  updated_at = now() where id=  572;
update sites set geometry=ST_SetSRID(ST_MakePoint(-113.75, 53.38,   699), 4326),  updated_at = now() where id=  573;
update sites set geometry=ST_SetSRID(ST_MakePoint(-105.75, 53.2,   429), 4326),  updated_at = now() where id=  574;
update sites set geometry=ST_SetSRID(ST_MakePoint(-104.01, 53.35,   370), 4326),  updated_at = now() where id=  575;
update sites set geometry=ST_SetSRID(ST_MakePoint(-97.85, 55.74,   209), 4326),  updated_at = now() where id=  576;
update sites set geometry=ST_SetSRID(ST_MakePoint(22.96, 40.58,   60), 4326),  updated_at = now() where id=  577;
update sites set geometry=ST_SetSRID(ST_MakePoint(17.63, 59.85,   28), 4326),  updated_at = now() where id=  578;
update sites set geometry=ST_SetSRID(ST_MakePoint(-165.97, 68.14,   0), 4326),  updated_at = now() where id=  580;
update sites set geometry=ST_SetSRID(ST_MakePoint(147.3, -19.5,   6), 4326),  updated_at = now() where id=  583;
update sites set geometry=ST_SetSRID(ST_MakePoint(-122.77, 53.92,   588), 4326),  updated_at = now() where id=  588;
update sites set geometry=ST_SetSRID(ST_MakePoint(-149.6, 68.6167,   742), 4326),  updated_at = now() where id=  591;
update sites set geometry=ST_SetSRID(ST_MakePoint(-80.3771, 25.7586,   7), 4326),  updated_at = now() where id=  594;
update sites set geometry=ST_SetSRID(ST_MakePoint(-84.3357, 31.313,   48), 4326),  updated_at = now() where id=  596;
update sites set geometry=ST_SetSRID(ST_MakePoint(-76.93, 39.03,   35), 4326),  updated_at = now() where id=  599;
update sites set geometry=ST_SetSRID(ST_MakePoint(-82.5, 34.4,   237), 4326),  updated_at = now() where id=  600;
update sites set geometry=ST_SetSRID(ST_MakePoint(-87.46, 36.39,   225), 4326),  updated_at = now() where id=  601;
update sites set geometry=ST_SetSRID(ST_MakePoint(-84.1, 35.9,   325), 4326),  updated_at = now() where id=  605;
update sites set geometry=ST_SetSRID(ST_MakePoint(-82.441822, 39.328125,   286), 4326),  updated_at = now() where id=  606;
update sites set geometry=ST_SetSRID(ST_MakePoint(-2.65, 51.463,   96), 4326),  updated_at = now() where id=  607;
update sites set geometry=ST_SetSRID(ST_MakePoint(18.16, 78.64,   490), 4326),  updated_at = now() where id=  608;
update sites set geometry=ST_SetSRID(ST_MakePoint(-72.02, 42.08,   155), 4326),  updated_at = now() where id=  609;
update sites set geometry=ST_SetSRID(ST_MakePoint(-77.916746, 40.655393,   293), 4326),  updated_at = now() where id=  611;
update sites set geometry=ST_SetSRID(ST_MakePoint(-76.802893, 41.257333,   246), 4326),  updated_at = now() where id=  612;
update sites set geometry=ST_SetSRID(ST_MakePoint(-81.667, 33.383,   121), 4326),  updated_at = now() where id=  613;
update sites set geometry=ST_SetSRID(ST_MakePoint(141.24, 43.11,   75), 4326),  updated_at = now() where id=  614;
update sites set geometry=ST_SetSRID(ST_MakePoint(-84.81, 31.01,   46), 4326),  updated_at = now() where id=  616;
update sites set geometry=ST_SetSRID(ST_MakePoint(20.25, 63.83,   16), 4326),  updated_at = now() where id=  617;
update sites set geometry=ST_SetSRID(ST_MakePoint(19, 52.12,   118), 4326),  updated_at = now() where id=  618;
update sites set geometry=ST_SetSRID(ST_MakePoint(-86.357952, 38.951892,   232), 4326),  updated_at = now() where id=  619;
update sites set geometry=ST_SetSRID(ST_MakePoint(-7.5, 54.3,   64), 4326),  updated_at = now() where id=  620;
update sites set geometry=ST_SetSRID(ST_MakePoint(-127.64, 55.25,   266), 4326),  updated_at = now() where id=  623;
update sites set geometry=ST_SetSRID(ST_MakePoint(-93.18, 44.98,   272), 4326),  updated_at = now() where id=  624;
update sites set geometry=ST_SetSRID(ST_MakePoint(-91.51, 43.52,   331), 4326),  updated_at = now() where id=  631;
update sites set geometry=ST_SetSRID(ST_MakePoint(-90.579, 46.135,   462), 4326),  updated_at = now() where id=  632;
update sites set geometry=ST_SetSRID(ST_MakePoint(175.31, -37.78,   46), 4326),  updated_at = now() where id=  633;
update sites set geometry=ST_SetSRID(ST_MakePoint(-73.55, 45.5,   4), 4326),  updated_at = now() where id=  634;
update sites set geometry=ST_SetSRID(ST_MakePoint(-71.11, 42.37,   19), 4326),  updated_at = now() where id=  635;
update sites set geometry=ST_SetSRID(ST_MakePoint(-84.484091, 42.702785,   259), 4326),  updated_at = now() where id=  636;
update sites set geometry=ST_SetSRID(ST_MakePoint(26.45, 58.15,   88), 4326),  updated_at = now() where id=  638;
update sites set geometry=ST_SetSRID(ST_MakePoint(-90.116667, 45.8,   520), 4326),  updated_at = now() where id=  639;
update sites set geometry=ST_SetSRID(ST_MakePoint(-79.394532, 43.663349,   111), 4326),  updated_at = now() where id=  641;
update sites set geometry=ST_SetSRID(ST_MakePoint(26.7, 58.2,   115), 4326),  updated_at = now() where id=  643;
update sites set geometry=ST_SetSRID(ST_MakePoint(22.6, 58.5,   24), 4326),  updated_at = now() where id=  645;
update sites set geometry=ST_SetSRID(ST_MakePoint(-72.15, 42.5,   323), 4326),  updated_at = now() where id=  646;
update sites set geometry=ST_SetSRID(ST_MakePoint(17.67, 59.82,   9), 4326),  updated_at = now() where id=  648;
update sites set geometry=ST_SetSRID(ST_MakePoint(-47.819366, -21.160721,   543), 4326),  updated_at = now() where id=  649;
update sites set geometry=ST_SetSRID(ST_MakePoint(17.63, 59.85,   28), 4326),  updated_at = now() where id=  650;
update sites set geometry=ST_SetSRID(ST_MakePoint(10.53, 52.26,   79), 4326),  updated_at = now() where id=  651;
update sites set geometry=ST_SetSRID(ST_MakePoint(-75.164, 39.952,   44), 4326),  updated_at = now() where id=  652;
update sites set geometry=ST_SetSRID(ST_MakePoint(-74.01, 40.71,   41), 4326),  updated_at = now() where id=  653;
update sites set geometry=ST_SetSRID(ST_MakePoint(-74.78, 39.96,   13), 4326),  updated_at = now() where id=  654;
update sites set geometry=ST_SetSRID(ST_MakePoint(-77.1, 36.67,   27), 4326),  updated_at = now() where id=  655;
update sites set geometry=ST_SetSRID(ST_MakePoint(-84.19, 36.11,   283), 4326),  updated_at = now() where id=  656;
update sites set geometry=ST_SetSRID(ST_MakePoint(-81.61, 34.72,   188), 4326),  updated_at = now() where id=  657;
update sites set geometry=ST_SetSRID(ST_MakePoint(-81.59, 34.27,   177), 4326),  updated_at = now() where id=  658;
update sites set geometry=ST_SetSRID(ST_MakePoint(-83.38, 33.95,   205), 4326),  updated_at = now() where id=  659;
update sites set geometry=ST_SetSRID(ST_MakePoint(-95.19, 31.89,   111), 4326),  updated_at = now() where id=  661;
update sites set geometry=ST_SetSRID(ST_MakePoint(-94.67, 31.29,   90), 4326),  updated_at = now() where id=  662;
update sites set geometry=ST_SetSRID(ST_MakePoint(-89.13, 30.79,   39), 4326),  updated_at = now() where id=  663;
update sites set geometry=ST_SetSRID(ST_MakePoint(-77.05, 35.55,   5), 4326),  updated_at = now() where id=  664;
update sites set geometry=ST_SetSRID(ST_MakePoint(-85.77, 35.68,   296), 4326),  updated_at = now() where id=  665;
update sites set geometry=ST_SetSRID(ST_MakePoint(-84.31, 35.93,   243), 4326),  updated_at = now() where id=  666;
update sites set geometry=ST_SetSRID(ST_MakePoint(31, -29.7,   125), 4326),  updated_at = now() where id=  668;
update sites set geometry=ST_SetSRID(ST_MakePoint(-84.33, 35.9,   239), 4326),  updated_at = now() where id=  669;
update sites set geometry=ST_SetSRID(ST_MakePoint(-84.25, 36.02,   280), 4326),  updated_at = now() where id=  670;
update sites set geometry=ST_SetSRID(ST_MakePoint(133.8, 34.21,   67), 4326),  updated_at = now() where id=  671;
update sites set geometry=ST_SetSRID(ST_MakePoint(-147.87, 64.82,   135), 4326),  updated_at = now() where id=  674;
update sites set geometry=ST_SetSRID(ST_MakePoint(31.6, -27.3,   294), 4326),  updated_at = now() where id=  675;
update sites set geometry=ST_SetSRID(ST_MakePoint(-84.02, 42.43,   272), 4326),  updated_at = now() where id=  680;
update sites set geometry=ST_SetSRID(ST_MakePoint(-71.11, 42.4,   14), 4326),  updated_at = now() where id=  683;
update sites set geometry=ST_SetSRID(ST_MakePoint(-147.71, 64.83,   135), 4326),  updated_at = now() where id=  684;
update sites set geometry=ST_SetSRID(ST_MakePoint(-147.71, 64.83,   135), 4326),  updated_at = now() where id=  685;
update sites set geometry=ST_SetSRID(ST_MakePoint(-147.867, 64.8,   130), 4326),  updated_at = now() where id=  686;
update sites set geometry=ST_SetSRID(ST_MakePoint(-98.03, 55.85,   227), 4326),  updated_at = now() where id=  688;
update sites set geometry=ST_SetSRID(ST_MakePoint(-105.26, 40.01,   1624), 4326),  updated_at = now() where id=  690;
update sites set geometry=ST_SetSRID(ST_MakePoint(-105.26, 40.01,   1624), 4326),  updated_at = now() where id=  691;
update sites set geometry=ST_SetSRID(ST_MakePoint(-105.26, 40.01,   1624), 4326),  updated_at = now() where id=  692;
update sites set geometry=ST_SetSRID(ST_MakePoint(-105.26, 40.01,   1624), 4326),  updated_at = now() where id=  693;
update sites set geometry=ST_SetSRID(ST_MakePoint(-147.87, 64.8,   132), 4326),  updated_at = now() where id=  695;
update sites set geometry=ST_SetSRID(ST_MakePoint(-105.24, 53.75,   505), 4326),  updated_at = now() where id=  696;
update sites set geometry=ST_SetSRID(ST_MakePoint(126.53, 45.81,   117), 4326),  updated_at = now() where id=  697;
update sites set geometry=ST_SetSRID(ST_MakePoint(-88.883, 46.867,   382), 4326),  updated_at = now() where id=  698;
update sites set geometry=ST_SetSRID(ST_MakePoint(17.5, 60.083,   57), 4326),  updated_at = now() where id=  699;
update sites set geometry=ST_SetSRID(ST_MakePoint(-84.85, 45.55,   272), 4326),  updated_at = now() where id=  702;
update sites set geometry=ST_SetSRID(ST_MakePoint(-84.833, 44.383,   344), 4326),  updated_at = now() where id=  703;
update sites set geometry=ST_SetSRID(ST_MakePoint(-86.15, 43.667,   264), 4326),  updated_at = now() where id=  704;
update sites set geometry=ST_SetSRID(ST_MakePoint(137.433, 36.22,   1562), 4326),  updated_at = now() where id=  705;
update sites set geometry=ST_SetSRID(ST_MakePoint(-82.15, 29.733,   41), 4326),  updated_at = now() where id=  710;
update sites set geometry=ST_SetSRID(ST_MakePoint(24.28333, 61.85,   168), 4326),  updated_at = now() where id=  712;
update sites set geometry=ST_SetSRID(ST_MakePoint(-92.8, 30.2,   6), 4326),  updated_at = now() where id=  714;
update sites set geometry=ST_SetSRID(ST_MakePoint(-147.71, 64.83,   135), 4326),  updated_at = now() where id=  716;
update sites set geometry=ST_SetSRID(ST_MakePoint(-72.15, 42.5,   323), 4326),  updated_at = now() where id=  725;
update sites set geometry=ST_SetSRID(ST_MakePoint(-82.32, 29.65,   37), 4326),  updated_at = now() where id=  726;
update sites set geometry=ST_SetSRID(ST_MakePoint(-90.970234, 40.037449,   224), 4326),  updated_at = now() where id=  781;
update sites set geometry=ST_SetSRID(ST_MakePoint(0.5783, 44.8386,   50), 4326),  updated_at = now() where id=  802;
update sites set geometry=ST_SetSRID(ST_MakePoint(-105.08, 40.58,   1528), 4326),  updated_at = now() where id=  804;
update sites set geometry=ST_SetSRID(ST_MakePoint(-121.75, 38.54,   18), 4326),  updated_at = now() where id=  805;
update sites set geometry=ST_SetSRID(ST_MakePoint(-145.73, 63.92,   455), 4326),  updated_at = now() where id=  806;
update sites set geometry=ST_SetSRID(ST_MakePoint(-145.73, 63.92,   455), 4326),  updated_at = now() where id=  807;
update sites set geometry=ST_SetSRID(ST_MakePoint(-72.3, 42.9,   195), 4326),  updated_at = now() where id=  808;
update sites set geometry=ST_SetSRID(ST_MakePoint(-72.17, 42.47,   313), 4326),  updated_at = now() where id=  812;
update sites set geometry=ST_SetSRID(ST_MakePoint(-116.2314, 33.3779,   956), 4326),  updated_at = now() where id=  819;
update sites set geometry=ST_SetSRID(ST_MakePoint(-118.919453, 34.411842,   142), 4326),  updated_at = now() where id=  821;
update sites set geometry=ST_SetSRID(ST_MakePoint(-5.951676, 54.591941,   5), 4326),  updated_at = now() where id=  822;
update sites set geometry=ST_SetSRID(ST_MakePoint(152.667556, -26.187664,   82), 4326),  updated_at = now() where id=  826;
update sites set geometry=ST_SetSRID(ST_MakePoint(-78.944153, 36.003156,   109), 4326),  updated_at = now() where id=  830;
update sites set geometry=ST_SetSRID(ST_MakePoint(149.128757, -35.282244,   580), 4326),  updated_at = now() where id=  832;
update sites set geometry=ST_SetSRID(ST_MakePoint(-3.1675, 55.937935,   76), 4326),  updated_at = now() where id=  835;
update sites set geometry=ST_SetSRID(ST_MakePoint(17.637172, 59.844886,   34), 4326),  updated_at = now() where id=  836;
update sites set geometry=ST_SetSRID(ST_MakePoint(11.603618, 42.343679,   33), 4326),  updated_at = now() where id=  837;
update sites set geometry=ST_SetSRID(ST_MakePoint(12.262798, 56.06234,   54), 4326),  updated_at = now() where id=  838;
update sites set geometry=ST_SetSRID(ST_MakePoint(-84.33, 35.9,   239), 4326),  updated_at = now() where id=  840;
update sites set geometry=ST_SetSRID(ST_MakePoint(-98.33, 55.88,   256), 4326),  updated_at = now() where id=  841;
update sites set geometry=ST_SetSRID(ST_MakePoint(-145.73, 63.92,   455), 4326),  updated_at = now() where id=  842;
update sites set geometry=ST_SetSRID(ST_MakePoint(-120.888752, 38.490524,   330), 4326),  updated_at = now() where id=  843;
update sites set geometry=ST_SetSRID(ST_MakePoint(3.814998, 43.631953,   47), 4326),  updated_at = now() where id=  845;
update sites set geometry=ST_SetSRID(ST_MakePoint(-84, 39,   290), 4326),  updated_at = now() where id=  848;
update sites set geometry=ST_SetSRID(ST_MakePoint(-78.94, 36,   125), 4326),  updated_at = now() where id=  850;
update sites set geometry=ST_SetSRID(ST_MakePoint(11.590057, 50.927554,   149), 4326),  updated_at = now() where id=  851;
update sites set geometry=ST_SetSRID(ST_MakePoint(-89.6167, 45.667,   492), 4326),  updated_at = now() where id=  852;
update sites set geometry=ST_SetSRID(ST_MakePoint(-84.33, 35.9,   239), 4326),  updated_at = now() where id=  854;
update sites set geometry=ST_SetSRID(ST_MakePoint(135.639949, 34.915049,   363), 4326),  updated_at = now() where id=  859;
update sites set geometry=ST_SetSRID(ST_MakePoint(-2.798428, 54.042137,   37), 4326),  updated_at = now() where id=  860;
update sites set geometry=ST_SetSRID(ST_MakePoint(-96.337056, 39.555786,   416), 4326),  updated_at = now() where id=  861;
update sites set geometry=ST_SetSRID(ST_MakePoint(175.618511, -40.348268,   38), 4326),  updated_at = now() where id=  863;
update sites set geometry=ST_SetSRID(ST_MakePoint(-88.121685, 40.116917,   210), 4326),  updated_at = now() where id=  864;
update sites set geometry=ST_SetSRID(ST_MakePoint(-119.820332, 39.496997,   1410), 4326),  updated_at = now() where id=  866;
update sites set geometry=ST_SetSRID(ST_MakePoint(-75.842061, 45.326423,   81), 4326),  updated_at = now() where id=  867;
update sites set geometry=ST_SetSRID(ST_MakePoint(-8.080449, 38.590956,   322), 4326),  updated_at = now() where id=  868;
update sites set geometry=ST_SetSRID(ST_MakePoint(0.628276, 51.615333,   25), 4326),  updated_at = now() where id=  869;
update sites set geometry=ST_SetSRID(ST_MakePoint(0.963359, 52.100898,   77), 4326),  updated_at = now() where id=  870;
update sites set geometry=ST_SetSRID(ST_MakePoint(144.844953, 13.473978,   124), 4326),  updated_at = now() where id=  871;
update sites set geometry=ST_SetSRID(ST_MakePoint(-76.5136, 38.88954,   4), 4326),  updated_at = now() where id=  872;
update sites set geometry=ST_SetSRID(ST_MakePoint(-83.682179, 9.894929,   674), 4326),  updated_at = now() where id=  873;
update sites set geometry=ST_SetSRID(ST_MakePoint(-122.28127, 37.532983,   4), 4326),  updated_at = now() where id=  874;
update sites set geometry=ST_SetSRID(ST_MakePoint(12.394634, 43.086294,   360), 4326),  updated_at = now() where id=  875;
update sites set geometry=ST_SetSRID(ST_MakePoint(-0.15, 50.82,   82), 4326),  updated_at = now() where id=  876;
update sites set geometry=ST_SetSRID(ST_MakePoint(130.419384, 33.593291,   10), 4326),  updated_at = now() where id=  877;
update sites set geometry=ST_SetSRID(ST_MakePoint(20.269084, 63.812412,   2), 4326),  updated_at = now() where id=  878;
update sites set geometry=ST_SetSRID(ST_MakePoint(-84.476885, 42.722214,   260), 4326),  updated_at = now() where id=  879;
update sites set geometry=ST_SetSRID(ST_MakePoint(11.896472, 42.782907,   511), 4326),  updated_at = now() where id=  880;
update sites set geometry=ST_SetSRID(ST_MakePoint(-7.972152, 37.043901,   21), 4326),  updated_at = now() where id=  881;
update sites set geometry=ST_SetSRID(ST_MakePoint(-94.207, 47.341,   402), 4326),  updated_at = now() where id=  882;
update sites set geometry=ST_SetSRID(ST_MakePoint(-117.14838, 46.734207,   795), 4326),  updated_at = now() where id=  884;
update sites set geometry=ST_SetSRID(ST_MakePoint(-98.216, 55.898,   244), 4326),  updated_at = now() where id=  885;
update sites set geometry=ST_SetSRID(ST_MakePoint(-99.948, 56.636,   273), 4326),  updated_at = now() where id=  886;
update sites set geometry=ST_SetSRID(ST_MakePoint(-99.942, 56.628,   292), 4326),  updated_at = now() where id=  887;
update sites set geometry=ST_SetSRID(ST_MakePoint(-98.964, 55.917,   271), 4326),  updated_at = now() where id=  888;
update sites set geometry=ST_SetSRID(ST_MakePoint(-98.979, 55.906,   269), 4326),  updated_at = now() where id=  889;
update sites set geometry=ST_SetSRID(ST_MakePoint(-98.485, 55.863,   263), 4326),  updated_at = now() where id=  890;
update sites set geometry=ST_SetSRID(ST_MakePoint(-98.483, 55.864,   265), 4326),  updated_at = now() where id=  891;
update sites set geometry=ST_SetSRID(ST_MakePoint(-98.382, 55.912,   258), 4326),  updated_at = now() where id=  892;
update sites set geometry=ST_SetSRID(ST_MakePoint(-98.656, 55.92,   275), 4326),  updated_at = now() where id=  893;
update sites set geometry=ST_SetSRID(ST_MakePoint(-98.525, 55.906,   272), 4326),  updated_at = now() where id=  894;
update sites set geometry=ST_SetSRID(ST_MakePoint(-98.519, 55.908,   271), 4326),  updated_at = now() where id=  895;
update sites set geometry=ST_SetSRID(ST_MakePoint(-98.484, 55.879,   267), 4326),  updated_at = now() where id=  896;
update sites set geometry=ST_SetSRID(ST_MakePoint(-98.48, 55.879,   264), 4326),  updated_at = now() where id=  897;
update sites set geometry=ST_SetSRID(ST_MakePoint(-98.48, 55.879,   264), 4326),  updated_at = now() where id=  898;
update sites set geometry=ST_SetSRID(ST_MakePoint(-90.118889, 45.918056,   483), 4326),  updated_at = now() where id=  909;
update sites set geometry=ST_SetSRID(ST_MakePoint(-90.1675, 45.816667,   476), 4326),  updated_at = now() where id=  910;
update sites set geometry=ST_SetSRID(ST_MakePoint(-94.5, 47.33,   424), 4326),  updated_at = now() where id=  911;
update sites set geometry=ST_SetSRID(ST_MakePoint(-94.5, 47.33,   424), 4326),  updated_at = now() where id=  912;
update sites set geometry=ST_SetSRID(ST_MakePoint(-94.5, 47.33,   424), 4326),  updated_at = now() where id=  913;
update sites set geometry=ST_SetSRID(ST_MakePoint(-94.5, 47.33,   424), 4326),  updated_at = now() where id=  914;
update sites set geometry=ST_SetSRID(ST_MakePoint(-94.5, 47.33,   424), 4326),  updated_at = now() where id=  915;
update sites set geometry=ST_SetSRID(ST_MakePoint(-94.5, 47.33,   424), 4326),  updated_at = now() where id=  916;
update sites set geometry=ST_SetSRID(ST_MakePoint(-89.32, 46.85,   191), 4326),  updated_at = now() where id=  917;
update sites set geometry=ST_SetSRID(ST_MakePoint(-148, 64,   1196), 4326),  updated_at = now() where id=  918;
update sites set geometry=ST_SetSRID(ST_MakePoint(12, 56,   13), 4326),  updated_at = now() where id=  919;
update sites set geometry=ST_SetSRID(ST_MakePoint(39, 52,   176), 4326),  updated_at = now() where id=  920;
update sites set geometry=ST_SetSRID(ST_MakePoint(10, 52,   196), 4326),  updated_at = now() where id=  921;
update sites set geometry=ST_SetSRID(ST_MakePoint(-68, 48,   300), 4326),  updated_at = now() where id=  922;
update sites set geometry=ST_SetSRID(ST_MakePoint(-92, 48,   493), 4326),  updated_at = now() where id=  923;
update sites set geometry=ST_SetSRID(ST_MakePoint(-122, 47,   487), 4326),  updated_at = now() where id=  924;
update sites set geometry=ST_SetSRID(ST_MakePoint(-85, 45.5,   262), 4326),  updated_at = now() where id=  925;
update sites set geometry=ST_SetSRID(ST_MakePoint(-71, 44,   139), 4326),  updated_at = now() where id=  926;
update sites set geometry=ST_SetSRID(ST_MakePoint(19.45, 64.117,   300), 4326),  updated_at = now() where id=  927;
update sites set geometry=ST_SetSRID(ST_MakePoint(-78.94, 36,   125), 4326),  updated_at = now() where id=  928;
update sites set geometry=ST_SetSRID(ST_MakePoint(-98, 40,   467), 4326),  updated_at = now() where id=  952;
update sites set geometry=ST_SetSRID(ST_MakePoint(4.48, 43.54,   -1), 4326),  updated_at = now() where id=  955;
update sites set geometry=ST_SetSRID(ST_MakePoint(-92.25, 43.125,   370), 4326),  updated_at = now() where id=  956;
update sites set geometry=ST_SetSRID(ST_MakePoint(102.8472, 37.8722,   1550), 4326),  updated_at = now() where id=  959;
update sites set geometry=ST_SetSRID(ST_MakePoint(73.66, 17.92444,   1373), 4326),  updated_at = now() where id=  960;
update sites set geometry=ST_SetSRID(ST_MakePoint(114.4, 35.0167,   75), 4326),  updated_at = now() where id=  961;
update sites set geometry=ST_SetSRID(ST_MakePoint(16.910833, 41,   153), 4326),  updated_at = now() where id=  962;
update sites set geometry=ST_SetSRID(ST_MakePoint(114.6833, 37.8833,   56), 4326),  updated_at = now() where id=  966;
update sites set geometry=ST_SetSRID(ST_MakePoint(117.1508, 36.1719,   127), 4326),  updated_at = now() where id=  967;
update sites set geometry=ST_SetSRID(ST_MakePoint(26.408, 40.148,   10), 4326),  updated_at = now() where id=  968;
update sites set geometry=ST_SetSRID(ST_MakePoint(-100.8153, 37.9899,   881), 4326),  updated_at = now() where id=  969;
update sites set geometry=ST_SetSRID(ST_MakePoint(-88, 33,   94), 4326),  updated_at = now() where id=  975;
update sites set geometry=ST_SetSRID(ST_MakePoint(116.05, 36.65,   36), 4326),  updated_at = now() where id=  987;
update sites set geometry=ST_SetSRID(ST_MakePoint(100.1, 39.2,   1420), 4326),  updated_at = now() where id=  989;
update sites set geometry=ST_SetSRID(ST_MakePoint(-96.58, 39.08,   402), 4326),  updated_at = now() where id=  993;
update sites set geometry=ST_SetSRID(ST_MakePoint(-106.417012, 32.353692,   1199), 4326),  updated_at = now() where id=  994;
update sites set geometry=ST_SetSRID(ST_MakePoint(89, 40,   806), 4326),  updated_at = now() where id=  995;
update sites set geometry=ST_SetSRID(ST_MakePoint(-94.746, 42.011,   355), 4326),  updated_at = now() where id=  997;
update sites set geometry=ST_SetSRID(ST_MakePoint(-96.466111, 41.168056,   354), 4326),  updated_at = now() where id=  999;
update sites set geometry=ST_SetSRID(ST_MakePoint(111.9, 26.8,   141), 4326),  updated_at = now() where id=  1000;
update sites set geometry=ST_SetSRID(ST_MakePoint(7.5, 47.467,   584), 4326),  updated_at = now() where id=  1004;
update sites set geometry=ST_SetSRID(ST_MakePoint(-77.243858, 41.098962,   366), 4326),  updated_at = now() where id=  1008;
update sites set geometry=ST_SetSRID(ST_MakePoint(19.4167, 46.8667,   109), 4326),  updated_at = now() where id=  1009;
update sites set geometry=ST_SetSRID(ST_MakePoint(16.4, 54.43,   -3), 4326),  updated_at = now() where id=  1010;
update sites set geometry=ST_SetSRID(ST_MakePoint(103.883, 31.683,   2059), 4326),  updated_at = now() where id=  1012;
update sites set geometry=ST_SetSRID(ST_MakePoint(16, 59,   81), 4326),  updated_at = now() where id=  1013;
update sites set geometry=ST_SetSRID(ST_MakePoint(102.583, 31.583,   4168), 4326),  updated_at = now() where id=  1014;
update sites set geometry=ST_SetSRID(ST_MakePoint(-90.82, 39.81,   202), 4326),  updated_at = now() where id=  1016;
update sites set geometry=ST_SetSRID(ST_MakePoint(-89.94, 40.3,   152), 4326),  updated_at = now() where id=  1017;
update sites set geometry=ST_SetSRID(ST_MakePoint(-88.39, 38.38,   133), 4326),  updated_at = now() where id=  1018;
update sites set geometry=ST_SetSRID(ST_MakePoint(-88.96, 38.95,   178), 4326),  updated_at = now() where id=  1020;
update sites set geometry=ST_SetSRID(ST_MakePoint(153.241, -29.426,   5), 4326),  updated_at = now() where id=  1038;
update sites set geometry=ST_SetSRID(ST_MakePoint(128.68, -15.51,   64), 4326),  updated_at = now() where id=  1040;
update sites set geometry=ST_SetSRID(ST_MakePoint(31.07, -29.35,   456), 4326),  updated_at = now() where id=  1041;
update sites set geometry=ST_SetSRID(ST_MakePoint(152.37, -24.79,   4), 4326),  updated_at = now() where id=  1043;
update sites set geometry=ST_SetSRID(ST_MakePoint(18.08, 59.62,   22), 4326),  updated_at = now() where id=  1046;
update sites set geometry=ST_SetSRID(ST_MakePoint(-82.21, 32.88,   76), 4326),  updated_at = now() where id=  1047;
update sites set geometry=ST_SetSRID(ST_MakePoint(-84.5, 38.13,   279), 4326),  updated_at = now() where id=  1048;
update sites set geometry=ST_SetSRID(ST_MakePoint(-91.1, 30.41,   16), 4326),  updated_at = now() where id=  1049;
update sites set geometry=ST_SetSRID(ST_MakePoint(-85.37, 42.39,   286), 4326),  updated_at = now() where id=  1050;
update sites set geometry=ST_SetSRID(ST_MakePoint(-88.8, 33.42,   108), 4326),  updated_at = now() where id=  1051;
update sites set geometry=ST_SetSRID(ST_MakePoint(-74.43, 40.46,   15), 4326),  updated_at = now() where id=  1052;
update sites set geometry=ST_SetSRID(ST_MakePoint(-97.05, 35.99,   283), 4326),  updated_at = now() where id=  1053;
update sites set geometry=ST_SetSRID(ST_MakePoint(-80.41, 43.64,   371), 4326),  updated_at = now() where id=  1054;
update sites set geometry=ST_SetSRID(ST_MakePoint(-96.79, 44.37,   519), 4326),  updated_at = now() where id=  1055;
update sites set geometry=ST_SetSRID(ST_MakePoint(-101, 25.42,   1604), 4326),  updated_at = now() where id=  1060;
update sites set geometry=ST_SetSRID(ST_MakePoint(26, 58,   60), 4326),  updated_at = now() where id=  1081;
update sites set geometry=ST_SetSRID(ST_MakePoint(-105.117, 53.987,   593), 4326),  updated_at = now() where id=  1086;
update sites set geometry=ST_SetSRID(ST_MakePoint(29.83, -2.75,   1572), 4326),  updated_at = now() where id=  1088;
update sites set geometry=ST_SetSRID(ST_MakePoint(149.15, -37.5667,   97), 4326),  updated_at = now() where id=  1093;
update sites set geometry=ST_SetSRID(ST_MakePoint(38.5, -5.2,   302), 4326),  updated_at = now() where id=  1095;
update sites set geometry=ST_SetSRID(ST_MakePoint(36.7, -3.4,   1315), 4326),  updated_at = now() where id=  1096;
update sites set geometry=ST_SetSRID(ST_MakePoint(36.6, -3.4,   1370), 4326),  updated_at = now() where id=  1097;
update sites set geometry=ST_SetSRID(ST_MakePoint(80, 35.5,   5883), 4326),  updated_at = now() where id=  1101;
update sites set geometry=ST_SetSRID(ST_MakePoint(-122.225, 37.4,   176), 4326),  updated_at = now() where id=  1103;
update sites set geometry=ST_SetSRID(ST_MakePoint(-86.416, 39.883,   279), 4326),  updated_at = now() where id=  1106;
update sites set geometry=ST_SetSRID(ST_MakePoint(-84.7, 45.583,   214), 4326),  updated_at = now() where id=  1107;
update sites set geometry=ST_SetSRID(ST_MakePoint(-90.083, 45.783,   525), 4326),  updated_at = now() where id=  1108;
update sites set geometry=ST_SetSRID(ST_MakePoint(-73.8783, 40.8636,   42), 4326),  updated_at = now() where id=  1110;
update sites set geometry=ST_SetSRID(ST_MakePoint(-73.8839, 40.8978,   40), 4326),  updated_at = now() where id=  1111;
update sites set geometry=ST_SetSRID(ST_MakePoint(-73.8083, 40.8656,   14), 4326),  updated_at = now() where id=  1112;
update sites set geometry=ST_SetSRID(ST_MakePoint(-73.758563, 40.982921,   62), 4326),  updated_at = now() where id=  1113;
update sites set geometry=ST_SetSRID(ST_MakePoint(-73.568024, 41.307678,   225), 4326),  updated_at = now() where id=  1114;
update sites set geometry=ST_SetSRID(ST_MakePoint(-73.2833, 41.8167,   365), 4326),  updated_at = now() where id=  1115;
update sites set geometry=ST_SetSRID(ST_MakePoint(-73.3091, 41.9161,   372), 4326),  updated_at = now() where id=  1116;
update sites set geometry=ST_SetSRID(ST_MakePoint(0, 0,   0), 4326),  updated_at = now() where id=  1118;
update sites set geometry=ST_SetSRID(ST_MakePoint(-113.98, 46.86,   1028), 4326),  updated_at = now() where id=  1119;
update sites set geometry=ST_SetSRID(ST_MakePoint(-85.3483, 42.3331,   246), 4326),  updated_at = now() where id=  1120;
update sites set geometry=ST_SetSRID(ST_MakePoint(93.5075, 44.0776,   1303), 4326),  updated_at = now() where id=  1122;
update sites set geometry=ST_SetSRID(ST_MakePoint(-72.188896, 42.531453,   334), 4326),  updated_at = now() where id=  1126;
update sites set geometry=ST_SetSRID(ST_MakePoint(86, 40,   946), 4326),  updated_at = now() where id=  1127;
update sites set geometry=ST_SetSRID(ST_MakePoint(-83.637618, 32.832802,   134), 4326),  updated_at = now() where id=  1128;
update sites set geometry=ST_SetSRID(ST_MakePoint(-80.25, 43.55,   325), 4326),  updated_at = now() where id=  1130;
update sites set geometry=ST_SetSRID(ST_MakePoint(-67.05, 1.9333,   101), 4326),  updated_at = now() where id=  1133;
update sites set geometry=ST_SetSRID(ST_MakePoint(-35.25, -7.8,   105), 4326),  updated_at = now() where id=  1155;
update sites set geometry=ST_SetSRID(ST_MakePoint(-53.81, -9.5,   335), 4326),  updated_at = now() where id=  1156;
update sites set geometry=ST_SetSRID(ST_MakePoint(-48.6, -21.8,   495), 4326),  updated_at = now() where id=  1157;
update sites set geometry=ST_SetSRID(ST_MakePoint(-51, -20.1,   323), 4326),  updated_at = now() where id=  1158;
update sites set geometry=ST_SetSRID(ST_MakePoint(-48.4, -22.9,   791), 4326),  updated_at = now() where id=  1159;
update sites set geometry=ST_SetSRID(ST_MakePoint(0, 0,   0), 4326),  updated_at = now() where id=  1160;
update sites set geometry=ST_SetSRID(ST_MakePoint(145.4, -16.5,   23), 4326),  updated_at = now() where id=  1162;
update sites set geometry=ST_SetSRID(ST_MakePoint(145.38, -16.39,   10), 4326),  updated_at = now() where id=  1163;
update sites set geometry=ST_SetSRID(ST_MakePoint(-157.928, 21.38,   33), 4326),  updated_at = now() where id=  1176;
update sites set geometry=ST_SetSRID(ST_MakePoint(149.186, -21.141,   11), 4326),  updated_at = now() where id=  1177;
update sites set geometry=ST_SetSRID(ST_MakePoint(88.262787, 27.034664,   2160), 4326),  updated_at = now() where id=  1179;
update sites set geometry=ST_SetSRID(ST_MakePoint(151.188354, -33.880449,   32), 4326),  updated_at = now() where id=  1180;
update sites set geometry=ST_SetSRID(ST_MakePoint(127.77, 26.25,   128), 4326),  updated_at = now() where id=  1181;
update sites set geometry=ST_SetSRID(ST_MakePoint(-157.914, 21.389,   177), 4326),  updated_at = now() where id=  1182;
update sites set geometry=ST_SetSRID(ST_MakePoint(-76.07, 42.47,   454), 4326),  updated_at = now() where id=  1185;
update sites set geometry=ST_SetSRID(ST_MakePoint(-76.07, 42.47,   454), 4326),  updated_at = now() where id=  1186;
update sites set geometry=ST_SetSRID(ST_MakePoint(-76.07, 42.47,   454), 4326),  updated_at = now() where id=  1187;
update sites set geometry=ST_SetSRID(ST_MakePoint(-80.61, 26.91,   8), 4326),  updated_at = now() where id=  1189;
update sites set geometry=ST_SetSRID(ST_MakePoint(-47.36, -2.96,   137), 4326), updated_at = now() where id=  1136;
update sites set geometry=ST_SetSRID(ST_MakePoint(-47.36, -2.96,   137), 4326), updated_at = now() where id=  1137;
update sites set geometry=ST_SetSRID(ST_MakePoint(-47.36, -2.96,   137), 4326), updated_at = now() where id=  1138;
update sites set geometry=ST_SetSRID(ST_MakePoint(-47.36, -2.96,   137), 4326), updated_at = now() where id=  1139;
update sites set geometry=ST_SetSRID(ST_MakePoint(-47.36, -2.96,   137), 4326), updated_at = now() where id=  1140;
update sites set geometry=ST_SetSRID(ST_MakePoint(-47.36, -2.96,   137), 4326), updated_at = now() where id=  1141;
update sites set geometry=ST_SetSRID(ST_MakePoint(-47.36, -2.96,   137), 4326), updated_at = now() where id=  1142;
update sites set geometry=ST_SetSRID(ST_MakePoint(-47.36, -2.96,   137), 4326), updated_at = now() where id=  1143;
update sites set geometry=ST_SetSRID(ST_MakePoint(-47.36, -2.96,   137), 4326), updated_at = now() where id=  1144;
update sites set geometry=ST_SetSRID(ST_MakePoint(-47.36, -2.96,   137), 4326), updated_at = now() where id=  1145;
update sites set geometry=ST_SetSRID(ST_MakePoint(-47.36, -2.96,   137), 4326), updated_at = now() where id=  1146;
update sites set geometry=ST_SetSRID(ST_MakePoint(-47.36, -2.96,   137), 4326), updated_at = now() where id=  1147;
update sites set geometry=ST_SetSRID(ST_MakePoint(-47.36, -2.96,   137), 4326), updated_at = now() where id=  1148;
update sites set geometry=ST_SetSRID(ST_MakePoint(-47.36, -2.96,   137), 4326), updated_at = now() where id=  1149;
update sites set geometry=ST_SetSRID(ST_MakePoint(-47.36, -2.96,   137), 4326), updated_at = now() where id=  1150;