docs/0.9.8/data/SJ.sqlpp

/*
 * Copyright by The Regents of the University of California
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * you may obtain a copy of the License from
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

drop  dataverse SJTest if exists;
create  dataverse SJTest;

use SJTest;

CREATE TYPE StateType AS {
  id : int,
  name: string,
  boundary : geometry
};

CREATE DATASET States (StateType) PRIMARY KEY id;

CREATE TYPE POIType AS {
  id : int,
  longitude : double,
  latitude : double
};

CREATE DATASET POIS (POIType) PRIMARY KEY id;


// ----------- Insert data into states

use SJTest;

INSERT INTO States ([
{"id": 1, "name": "Nebraska", "boundary": st_geom_from_text("POLYGON ((-104.05341854507101 41.1705389679833, -104.053028 43.000586999999996, -98.49855 42.99856, -98.01304599999999 42.762299, -97.306677 42.867604, -96.38600699999999 42.474495, -96.06487899999999 41.79623, -96.09200799999999 41.53391, -95.87468899999999 41.307097, -95.88534899999999 40.721092999999996, -95.30829 39.999998, -102.051744 40.003077999999995, -102.051614 41.002376999999996, -104.053249 41.001405999999996, -104.05341854507101 41.1705389679833))") },
{"id": 2, "name": "Washington", "boundary": st_geom_from_text("MULTIPOLYGON (((-124.732755385025 48.165328947686795, -124.676262 48.391371, -123.981032 48.164761, -123.10189199999999 48.184951999999996, -122.871992 47.993493, -122.75413 48.1447, -122.610341 47.887343, -122.784553 47.686561, -122.864651 47.804669, -123.157948 47.356235999999996, -122.874586 47.413874, -123.119681 47.385532, -122.525329 47.912335999999996, -122.54636949132416 47.317877648507704, -122.324833 47.348521, -122.43694099999999 47.661719, -122.218982 48.020275999999996, -122.383911 48.227486, -122.47892813788141 48.175746487177165, -122.388048 48.30083, -122.57760827271139 48.38291646865838, -122.505828 48.297677, -122.732358 48.226144, -122.3773 47.905941, -122.769939 48.227548, -122.60660653630984 48.395473767832804, -122.674158 48.424726, -122.425271 48.599522, -122.535803 48.776128, -122.673472 48.733081999999996, -122.75802 49.002356999999996, -117.032351 48.999188, -117.062748 46.353623999999996, -116.915989 45.995413, -118.987129 45.999855, -121.145534 45.607886, -121.533106 45.726541, -122.266701 45.543841, -122.67500799999999 45.618038999999996, -123.004233 46.133823, -124.07776799999999 46.272324, -124.06905 46.647258, -123.953699 46.378845, -123.829356 46.713356, -124.092176 46.741623999999995, -124.138225 46.905533999999996, -123.83890000000001 46.953950999999996, -124.122057 47.04165, -124.173877 46.927234999999996, -124.425195 47.738434, -124.732755385025 48.165328947686795), (-122.56199279209496 47.29381043649037, -122.683943 47.365154999999994, -122.76539771783851 47.18116187703539, -122.678476 47.102742, -122.56199279209496 47.29381043649037), (-122.77734484602688 47.19194045282469, -122.82666 47.405806999999996, -122.871472 47.276861, -122.77734484602688 47.19194045282469)), ((-122.4789801236288 48.17567493623048, -122.358963 48.054851, -122.510562 48.132207, -122.4789801236288 48.17567493623048)), ((-122.526031 47.358906, -122.457246 47.505848, -122.373627 47.388718, -122.526031 47.358906)))") },
{"id": 3, "name": "New Mexico", "boundary": st_geom_from_text("POLYGON ((-109.050173 31.480003999999997, -109.045223 36.999083999999996, -103.002199 37.000104, -103.064423 32.000518, -106.618486 32.000495, -106.528242 31.783147999999997, -108.208394 31.783599, -108.208573 31.333395, -109.050044 31.332501999999998, -109.050173 31.480003999999997))") },
{"id": 4, "name": "South Dakota", "boundary": st_geom_from_text("POLYGON ((-104.057698 44.997431, -104.045443 45.94531, -96.563672 45.935238999999996, -96.857751 45.605962, -96.45306699999999 45.298114999999996, -96.45326 43.500389999999996, -96.60285999999999 43.450907, -96.436589 43.120841999999996, -96.639704 42.737071, -96.44550799999999 42.490629999999996, -97.23786799999999 42.853139, -98.035034 42.764205, -98.49855 42.99856, -104.053028 43.000586999999996, -104.057698 44.997431))") },
{"id": 5, "name": "Kentucky", "boundary": st_geom_from_text("POLYGON ((-89.405654 36.528165, -89.15908 36.666351999999996, -89.08652599999999 37.165602, -88.45894799999999 37.073796, -88.476592 37.386874999999996, -88.067844 37.485867, -88.15937199999999 37.661847, -87.904789 37.924892, -87.635806 37.827014999999996, -87.585916 37.975442, -87.111133 37.782512, -86.820071 37.999392, -86.63826499999999 37.842718, -86.360377 38.198796, -86.03818799999999 37.95935, -85.42307699999999 38.531580999999996, -85.43406499999999 38.729455, -84.812877 38.786086999999995, -84.897364 39.057378, -84.750749 39.147358, -84.449793 39.117754, -84.212904 38.805707, -83.679484 38.630036, -82.879492 38.751476, -82.604089 38.459841, -82.501862 37.9332, -81.96497099999999 37.543026, -83.136395 36.743088, -83.690714 36.582581, -88.070532 36.678118, -88.05320499999999 36.497129, -89.405654 36.528165))") },
{"id": 6, "name": "Georgia", "boundary": st_geom_from_text("POLYGON ((-85.605165 34.984677999999995, -83.10286699999999 34.997257, -83.34261699999999 34.682991, -82.858837 34.45522, -82.55683499999999 33.945353, -81.49225299999999 33.009342, -81.117234 32.117605, -80.841127 32.023522, -81.203572 31.719448, -81.26955199999999 31.258740999999997, -81.493651 30.977528, -81.444124 30.709713999999998, -81.949787 30.827492999999997, -82.036825 30.377883999999998, -82.161757 30.357851, -82.214839 30.568590999999998, -84.913522 30.752291, -85.10751599999999 31.186450999999998, -85.141831 31.839260999999997, -84.88907999999999 32.260911, -85.18440000000001 32.861317, -85.605165 34.984677999999995))") },
{"id": 7, "name": "Arkansas", "boundary": st_geom_from_text("POLYGON ((-94.6178329666013 36.4994141203285, -90.152481 36.497952, -90.06398 36.303038, -90.37789 35.995683, -89.644395 35.894782, -89.956254 35.733385999999996, -89.909022 35.520548, -90.179265 35.385194, -90.065392 35.137691, -90.29559599999999 35.040093, -90.307384 34.846195, -90.479872 34.883264, -90.571145 34.420319, -90.92901499999999 34.244541, -90.810884 34.155902999999995, -91.087921 33.975335, -90.988466 33.78453, -91.14661799999999 33.732456, -91.03146 33.678142, -91.22901499999999 33.677543, -91.208113 33.402007, -91.057621 33.445341, -91.166073 33.004106, -94.042964 33.019219, -94.04344999999999 33.552253, -94.485875 33.637867, -94.430662 35.392478, -94.6178329666013 36.4994141203285))") },
{"id": 8, "name": "Pennsylvania", "boundary": st_geom_from_text("POLYGON ((-80.519891 40.906661, -80.519425 41.977523, -79.761951 42.26986, -79.76137399999999 41.999067, -75.359579 41.999445, -75.072172 41.813731999999995, -74.983341 41.480894, -74.689516 41.363842999999996, -75.130575 40.991093, -75.051029 40.865662, -75.20392 40.691497999999996, -74.724304 40.14701, -75.773786 39.7222, -80.519342 39.721402999999995, -80.519891 40.906661))") },
{"id": 9, "name": "Mississippi", "boundary": st_geom_from_text("POLYGON ((-91.65500899999999 31.251814999999997, -91.472465 31.371326, -91.403915 31.589765999999997, -91.51233599999999 31.634722, -91.005006 32.142852, -91.164171 32.196888, -90.875631 32.372434, -91.116008 32.48314, -90.987202 32.495663, -91.153556 32.626180999999995, -91.08680199999999 32.976265999999995, -91.213972 32.927198, -91.057621 33.445341, -91.208113 33.402007, -91.22901499999999 33.677543, -91.034565 33.673018, -91.14661799999999 33.732456, -90.988466 33.78453, -91.087921 33.975335, -90.810884 34.155902999999995, -90.92901499999999 34.244541, -90.571145 34.420319, -90.479872 34.883264, -90.307384 34.846195, -90.309297 34.995694, -88.200064 34.995633999999995, -88.097888 34.892202, -88.473227 31.893856, -88.390746 30.352075, -89.335942 30.374015999999997, -89.570154 30.180297, -89.852263 30.662934, -89.729616 31.003926999999997, -91.63694199999999 30.999416, -91.65500899999999 31.251814999999997))") },
{"id": 10, "name": "Colorado", "boundary": st_geom_from_text("POLYGON ((-109.060253 38.599328, -109.050076 41.000659, -102.051614 41.002376999999996, -102.042089 36.993016, -109.045223 36.999083999999996, -109.060253 38.599328))") },
{"id": 11, "name": "Utah", "boundary": st_geom_from_text("POLYGON ((-114.052962 37.592783, -114.041723 41.993719999999996, -111.046689 42.001567, -111.046723 40.997959, -109.050076 41.000659, -109.045223 36.999083999999996, -114.0506 37.000395999999995, -114.052962 37.592783))") },
{"id": 12, "name": "Tennessee", "boundary": st_geom_from_text("POLYGON ((-90.31029799999999 35.004295, -90.065392 35.137691, -90.179265 35.385194, -89.909022 35.520548, -89.956254 35.733385999999996, -89.64534599999999 35.891419, -89.705328 36.239898, -89.534745 36.252576, -89.539232 36.497934, -88.05320499999999 36.497129, -88.070532 36.678118, -81.6469 36.611917999999996, -81.707438 36.335170999999995, -82.033141 36.120422, -82.557874 35.953901, -82.637165 36.065805, -82.992053 35.773948, -83.880074 35.518744999999996, -84.052612 35.269982, -84.29024 35.225572, -84.32186899999999 34.988408, -90.31029799999999 35.004295))") },
{"id": 13, "name": "Wyoming", "boundary": st_geom_from_text("POLYGON ((-111.056888 44.866658, -111.055199 45.001321, -104.057698 44.997431, -104.053249 41.001405999999996, -111.046723 40.997959, -111.056888 44.866658))") },
{"id": 14, "name": "Indiana", "boundary": st_geom_from_text("POLYGON ((-88.09776 37.904026, -87.911428 38.16174, -87.987618 38.257380999999995, -87.496494 38.742728, -87.658745 39.135996999999996, -87.531204 39.355104, -87.52404399999999 41.708335, -84.805883 41.760216, -84.812877 38.786086999999995, -85.43406499999999 38.729455, -85.42307699999999 38.531580999999996, -86.042354 37.958017999999996, -86.360377 38.198796, -86.63826499999999 37.842718, -86.820071 37.999392, -87.111133 37.782512, -87.589816 37.976042, -87.615399 37.831973999999995, -87.898062 37.927513999999995, -87.95259 37.771741999999996, -88.09776 37.904026))") },
{"id": 15, "name": "Nevada", "boundary": st_geom_from_text("POLYGON ((-120.005743 39.228663999999995, -119.999168 41.99454, -114.041723 41.993719999999996, -114.043944 36.193349999999995, -114.152795 36.023694, -114.753196 36.089513, -114.633487 35.001857, -120.001014 38.999573999999996, -120.005743 39.228663999999995))") },
{"id": 16, "name": "Illinois", "boundary": st_geom_from_text("POLYGON ((-91.512974 40.181062, -91.40524099999999 40.554641, -90.96291599999999 40.924957, -91.04589 41.414085, -90.461432 41.523533, -90.180954 41.809354, -90.16289499999999 42.116718, -90.642843 42.508480999999996, -87.80209099999999 42.492576, -87.828569 42.269922, -87.524141 41.72399, -87.531204 39.355104, -87.658745 39.135996999999996, -87.496494 38.742728, -87.987618 38.257380999999995, -88.160187 37.657592, -88.067844 37.485867, -88.470224 37.396255, -88.45894799999999 37.073796, -88.974711 37.229707999999995, -89.132685 36.9822, -89.378277 37.039605, -89.51425499999999 37.689923, -90.35955899999999 38.224525, -90.10940699999999 38.843548, -90.628485 38.891617, -90.72995999999999 39.255894, -91.367753 39.729029, -91.512974 40.181062))") },
{"id": 17, "name": "Vermont", "boundary": st_geom_from_text("POLYGON ((-73.43773999999999 44.045006, -73.293855 44.437556, -73.343124 45.010839999999995, -71.46455499999999 45.013636999999996, -71.631883 44.752463, -71.577643 44.502691999999996, -72.033136 44.320364999999995, -72.030182 44.079682999999996, -72.37944 43.574069, -72.556214 42.866949999999996, -72.458519 42.726853, -73.276421 42.746019, -73.24158899999999 43.534973, -73.430947 43.587036, -73.43773999999999 44.045006))") },
{"id": 18, "name": "Montana", "boundary": st_geom_from_text("POLYGON ((-116.04966720193102 48.4403221865285, -116.049193 49.000912, -104.048736 48.999877, -104.039138 44.99852, -111.055199 45.001321, -111.048974 44.474072, -111.381665 44.754405, -111.467804 44.53902, -112.286187 44.568472, -112.855395 44.359975, -113.131453 44.772836999999996, -113.454858 44.865572, -113.935505 45.694646999999996, -114.333218 45.459316, -114.564691 45.558026999999996, -114.566172 45.773863999999996, -114.388243 45.88234, -114.527096 46.146218, -114.320665 46.646963, -114.76689 46.696901, -115.321032 47.256105, -115.759233 47.423471, -115.62910000000001 47.47672, -116.04885 47.977185999999996, -116.04966720193102 48.4403221865285))") },
{"id": 19, "name": "Iowa", "boundary": st_geom_from_text("POLYGON ((-96.639704 42.737071, -96.436589 43.120841999999996, -96.598928 43.500457, -91.21770599999999 43.50055, -91.057918 43.255365999999995, -91.179457 43.067426999999995, -91.06468 42.750913999999995, -90.70630299999999 42.634169, -90.140613 41.995999, -90.343228 41.587832999999996, -91.04589 41.414085, -91.113648 41.241400999999996, -90.95223299999999 40.954046999999996, -91.12392799999999 40.669152, -91.40524099999999 40.554641, -91.38835999999999 40.384929, -91.729115 40.61364, -95.76564499999999 40.585208, -96.129505 41.971672999999996, -96.639704 42.737071))") },
{"id": 20, "name": "South Carolina", "boundary": st_geom_from_text("POLYGON ((-83.35391 34.699219, -83.108606 35.000659, -82.39292999999999 35.215402, -81.04362499999999 35.149877, -80.79754299999999 34.819786, -79.675299 34.804744, -78.54203 33.851924, -78.938076 33.639826, -79.362292 33.009087, -80.472068 32.496964, -80.452956 32.322494, -80.733637 32.319469, -80.66916599999999 32.216783, -80.917845 32.037575, -81.117234 32.117605, -81.49225299999999 33.009342, -82.55683499999999 33.945353, -82.858837 34.45522, -83.35391 34.699219))") },
{"id": 21, "name": "Arizona", "boundary": st_geom_from_text("POLYGON ((-114.816294 32.508038, -114.468971 32.845155, -114.731223 33.302434, -114.524599 33.552231, -114.535478 33.934650999999995, -114.131211 34.26273, -114.635176 34.875003, -114.754798 36.084703999999995, -114.14762999999999 36.025186, -114.0506 37.000395999999995, -109.045223 36.999083999999996, -109.050044 31.332501999999998, -111.074825 31.332238999999998, -114.816294 32.508038))") },
{"id": 22, "name": "Ohio", "boundary": st_geom_from_text("POLYGON ((-84.82015899999999 39.227225, -84.805972 41.696118, -83.45383199999999 41.732647, -82.71093499999999 41.536648, -82.9422 41.419754, -82.481214 41.381342, -81.738755 41.48855, -80.519425 41.977523, -80.518991 40.638801, -80.667957 40.582496, -80.59989499999999 40.317668999999995, -80.83187099999999 39.705655, -81.217315 39.387589999999996, -81.689483 39.266042999999996, -81.762659 38.924121, -82.035963 39.025478, -82.33033499999999 38.444500000000005, -82.578999 38.407782999999995, -82.88919299999999 38.756076, -83.29419299999999 38.596588, -83.76509 38.652881, -84.212904 38.805707, -84.455342 39.12036, -84.820157 39.10548, -84.82015899999999 39.227225))") },
{"id": 23, "name": "Alabama", "boundary": st_geom_from_text("POLYGON ((-88.473227 31.893856, -88.097888 34.892202, -88.20295899999999 35.008027999999996, -85.605165 34.984677999999995, -85.18440000000001 32.861317, -84.88907999999999 32.260911, -85.140731 31.857460999999997, -85.002499 31.000681999999998, -87.598928 30.997456999999997, -87.368191 30.433407, -87.452378 30.300200999999998, -88.027678 30.223644999999998, -87.755314 30.280071999999997, -87.985559 30.677508999999997, -88.138576 30.311988, -88.395023 30.369425, -88.473227 31.893856))") },
{"id": 24, "name": "Wisconsin", "boundary": st_geom_from_text("POLYGON ((-92.888114 45.628377, -92.712503 45.891704999999995, -92.294033 46.074377, -92.291292 46.668141999999996, -90.855874 46.962232, -90.751031 46.887963, -90.94506299999999 46.588974, -90.784425 46.729375, -90.12048899999999 46.336852, -88.18978899999999 45.952208, -87.80586699999999 45.706841, -87.888052 45.354696999999994, -87.657349 45.368752, -87.736509 45.173389, -87.575283 45.070454, -87.839028 44.931718, -88.008702 44.541714, -87.578305 44.853383, -87.385547 44.831137, -87.236997 45.169449, -86.983355 45.295367999999996, -87.736178 43.880421, -87.91178699999999 43.250406, -87.80209099999999 42.492576, -90.642843 42.508480999999996, -91.053733 42.738237999999996, -91.179457 43.067426999999995, -91.057918 43.255365999999995, -91.21477 43.365874, -91.284138 43.847065, -92.807317 44.750364, -92.646602 45.441635, -92.888114 45.628377))") },
{"id": 25, "name": "Oregon", "boundary": st_geom_from_text("POLYGON ((-124.564595 42.840876, -124.150267 43.910849999999996, -123.962887 45.280218, -124.01263399999999 46.23685, -123.115904 46.185268, -122.813998 45.960983999999996, -122.76381 45.657137999999996, -122.294901 45.543541, -121.811304 45.706761, -120.40396 45.699248999999995, -118.941242 46.000574, -116.915989 45.995413, -116.463504 45.615784999999995, -117.24267499999999 44.396547999999996, -116.894083 44.160191, -117.032881 43.830025, -117.026197 41.99989, -124.21160499999999 41.99846, -124.564595 42.840876))") },
{"id": 26, "name": "Missouri", "boundary": st_geom_from_text("POLYGON ((-95.773549 40.578205, -91.729115 40.61364, -91.419422 40.378264, -91.510322 40.127994, -91.370009 39.732524, -90.72995999999999 39.255894, -90.657254 38.920269999999995, -90.10940699999999 38.843548, -90.35955899999999 38.224525, -89.51425499999999 37.689923, -89.38393699999999 37.046441, -89.099594 36.964543, -89.15908 36.666351999999996, -89.464153 36.457189, -89.56318499999999 36.568749, -89.534745 36.252576, -89.70351099999999 36.243412, -89.591605 36.144096, -89.706932 36.000980999999996, -90.37789 35.995683, -90.06398 36.303038, -90.152481 36.497952, -94.617919 36.499414, -94.588413 39.149868999999995, -95.109304 39.542285, -94.862943 39.742993999999996, -94.929574 39.888754, -95.40726 40.033111999999996, -95.773549 40.578205))") },
{"id": 27, "name": "North Carolina", "boundary": st_geom_from_text("MULTIPOLYGON (((-75.52756300011173 35.26974874385652, -75.52344599999999 35.773568, -75.521782 35.271777, -75.52756300011173 35.26974874385652)), ((-84.31749939310801 35.0217784890312, -84.29024 35.225572, -84.052612 35.269982, -83.880074 35.518744999999996, -82.992053 35.773948, -82.637165 36.065805, -82.557874 35.953901, -82.033141 36.120422, -81.707438 36.335170999999995, -81.67753499999999 36.588117, -75.86704399999999 36.550754, -75.533012 35.787377, -76.00262599999999 36.537113999999995, -75.79397399999999 36.071709999999996, -76.185401 36.301099, -76.064224 36.143775, -76.45469299999999 36.192799, -76.30400399999999 36.094527, -76.58042499999999 36.010554, -76.699978 36.285391, -76.726598 35.943234, -76.05396499999999 35.987095, -76.03804 35.645765, -75.836283 35.970501, -75.73476099999999 35.625675, -76.157355 35.327019, -76.53217599999999 35.401254, -76.46538799999999 35.558414, -76.63794399999999 35.512962, -76.577558 35.387575999999996, -77.05317 35.535208, -76.468909 35.281483, -76.79060055335052 34.97612606557105, -76.246961 34.987347, -76.512686 34.720333, -77.125863 34.685241999999995, -77.582323 34.400506, -77.96279299999999 33.842316, -78.54203 33.851924, -79.675299 34.804744, -80.79754299999999 34.819786, -81.04362499999999 35.149877, -82.39292999999999 35.215402, -83.108606 35.000659, -84.31749939310801 35.0217784890312), (-76.82001743959837 34.97551888945656, -77.05958799999999 35.146865999999996, -76.935756 34.97313, -76.82001743959837 34.97551888945656)))") },
{"id": 28, "name": "Oklahoma", "boundary": st_geom_from_text("POLYGON ((-103.002565 36.526588, -103.002199 37.000104, -94.617964 36.998905, -94.430662 35.392478, -94.48751399999999 33.628938999999995, -95.21763299999999 33.962646, -96.348306 33.686378999999995, -96.981337 33.956378, -97.12610199999999 33.716941, -97.210921 33.916064, -97.967777 33.88243, -98.109462 34.154111, -98.486328 34.062598, -99.189511 34.214312, -99.36961 34.458698999999996, -99.69497 34.378333, -100.000381 34.560508999999996, -100.000406 36.499702, -103.002565 36.526588))") },
{"id": 29, "name": "Virginia", "boundary": st_geom_from_text("MULTIPOLYGON (((-76.02479943943091 37.2626855899573, -75.756897 37.901553, -75.242266 38.027209, -75.832004 37.174974999999996, -75.971876 37.085376, -76.02479943943091 37.2626855899573)), ((-83.675395 36.600784, -83.136395 36.743088, -81.968012 37.538035, -81.67820999999999 37.201482999999996, -80.309331 37.50288, -79.649075 38.591515, -79.282971 38.418095, -78.998171 38.847353, -78.869276 38.762991, -78.403697 39.167451, -78.347087 39.466012, -77.82815699999999 39.132329, -77.56659599999999 39.306121, -77.51992899999999 39.120925, -77.040599 38.871212, -77.31728799999999 38.383576, -77.041524 38.400186, -76.962311 38.214075, -76.23672499999999 37.889174, -76.361887 37.609017, -76.927185 37.984978, -76.29803199999999 37.559867, -76.276214 37.310829, -76.412893 37.418079999999996, -76.354554 37.272331, -76.509035 37.239478999999996, -76.304272 37.001377999999995, -76.63641318866935 37.11849077871624, -76.48336499999999 36.878153999999995, -75.996252 36.922047, -75.86704399999999 36.550754, -83.675395 36.600784)))") },
{"id": 30, "name": "West Virginia", "boundary": st_geom_from_text("POLYGON ((-82.6431981036679 38.1690897960737, -82.59348 38.421821, -82.177267 38.603784, -82.221566 38.787186999999996, -82.035963 39.025478, -81.762659 38.924121, -81.683627 39.270939, -80.88036 39.620706, -80.59989499999999 40.317668999999995, -80.62717099999999 40.619935999999996, -80.518991 40.638801, -80.519342 39.721402999999995, -79.47666199999999 39.721078, -79.486873 39.205960999999995, -78.76584 39.648486999999996, -78.471166 39.516103, -78.107834 39.682137, -77.833568 39.602936, -77.736409 39.392683999999996, -77.82815699999999 39.132329, -78.347087 39.466012, -78.403697 39.167451, -78.869276 38.762991, -78.998171 38.847353, -79.282971 38.418095, -79.649075 38.591515, -80.29978899999999 37.508271, -80.947896 37.295871999999996, -81.849949 37.285227, -82.6431981036679 38.1690897960737))") },
{"id": 31, "name": "Louisiana", "boundary": st_geom_from_text("MULTIPOLYGON (((-94.04314699999999 32.693031, -94.042964 33.019219, -91.09693 32.986412, -91.15131799999999 32.615919, -91.014286 32.640482, -90.987202 32.495663, -91.116008 32.48314, -90.875631 32.372434, -91.164171 32.196888, -91.004106 32.146152, -91.345714 31.842861, -91.26340599999999 31.754468, -91.515462 31.630371999999998, -91.40541499999999 31.576466, -91.654027 31.255753, -91.63694199999999 30.999416, -89.729616 31.003926999999997, -89.851889 30.661199, -89.524504 30.180753, -89.852312 29.977649999999997, -89.650027 29.862143999999997, -89.48442299999999 30.078833, -89.370063 29.892128, -89.24784799999999 29.997328, -89.385702 29.835486999999997, -89.285742 29.763391, -89.683455 29.549266, -89.187834 29.342029999999998, -89.066617 29.090714, -89.417901 28.928608999999998, -89.29502699999999 29.198867, -89.842641 29.318823, -89.59545399999999 29.356015, -89.85197 29.475734, -90.222869 29.087069, -90.440227 29.349375, -90.836107 29.066063, -91.288324 29.255743, -91.12629 29.333420999999998, -91.54137999999999 29.526327, -91.62789599999999 29.741079, -91.88074999999999 29.710839, -91.83080799999999 29.829269999999998, -92.203312 29.753401999999998, -92.008896 29.612944, -92.323465 29.531496999999998, -93.21344099999999 29.775622, -93.837971 29.690618999999998, -93.92799199999999 29.809639999999998, -93.699396 30.05925, -93.740253 30.539569, -93.508292 31.032352, -94.041833 31.992402, -94.04314699999999 32.693031)), ((-89.342163 30.059172, -89.185715 30.157000999999998, -89.201584 30.001428999999998, -89.342163 30.059172)))") },
{"id": 32, "name": "Michigan", "boundary": st_geom_from_text("MULTIPOLYGON (((-86.824828 41.760239999999996, -86.247078 42.490969, -86.220582 42.955791, -86.53849699999999 43.617501, -86.514702 44.058119, -86.066745 44.905685, -85.540748 45.210906, -85.652355 44.849092, -85.474937 44.991721, -85.527192 44.7475, -85.36141099999999 45.287095, -84.914543 45.395623, -85.108848 45.518485, -84.94052599999999 45.721832, -85.049835 45.769605999999996, -84.72886 45.788145, -83.385104 45.274195, -83.260657 45.025894, -83.455535 45.025082, -83.270288 44.70878, -83.333708 44.336579, -83.952642 43.749567, -83.674404 43.587222999999994, -83.402535 43.916968999999995, -82.963861 44.068266, -82.738992 43.989506, -82.415937 43.005555, -82.523337 42.607486, -82.679059 42.52221, -82.63085099999999 42.673341, -82.80560899999999 42.648765, -83.45383199999999 41.732647, -86.824828 41.760239999999996)), ((-83.88286699999999 45.975452999999995, -83.70011099999999 46.103867, -83.473221 45.984421, -83.88286699999999 45.975452999999995)), ((-90.41813599999999 46.566094, -88.972802 47.002095999999995, -88.218153 47.449521, -87.80118399999999 47.473301, -87.71242099999999 47.4014, -88.349952 47.076377, -88.496479 46.756493999999996, -88.14295399999999 46.966902999999995, -88.283423 46.822987, -87.816794 46.891154, -87.35941 46.503451999999996, -86.644706 46.410801, -86.161681 46.669475, -84.956248 46.771893999999996, -85.015211 46.479712, -84.128925 46.530119, -84.097766 46.256512, -84.273018 46.201451, -83.89546399999999 45.986436, -84.656567 46.052654, -84.751987 45.839605, -85.50621 46.096393, -86.275768 45.943551, -86.614266 45.600121, -86.717512 45.680291, -86.535206 45.885805, -86.967855 45.668261, -86.977941 45.905623, -87.592041 45.094252, -87.736509 45.173389, -87.657349 45.368752, -87.888052 45.354696999999994, -87.782226 45.683053, -88.12946099999999 45.809287999999995, -88.102908 45.921869, -90.12048899999999 46.336852, -90.41813599999999 46.566094)), ((-85.628221 45.601745, -85.501267 45.754414999999995, -85.491727 45.607527, -85.628221 45.601745)), ((-89.2628 47.869864, -88.418244 48.180369999999996, -88.911665 47.891344, -89.2628 47.869864)))") },
{"id": 33, "name": "Massachusetts", "boundary": st_geom_from_text("MULTIPOLYGON (((-73.50814199999999 42.086256999999996, -73.264957 42.74594, -71.29420499999999 42.69699, -70.902768 42.88653, -70.591469 42.639821, -71.041333 42.302926, -70.76633799999999 42.254742, -70.412476 41.744397, -70.008462 41.800785999999995, -70.245385 42.063733, -70.082624 42.054657, -69.928393 41.708449, -70.003861 41.540551, -70.014211 41.671971, -70.65662499999999 41.514779, -70.718739 41.73574, -71.03836199999999 41.481105, -71.381401 42.018798, -73.50814199999999 42.086256999999996)), ((-70.234054 41.285652999999996, -70.049053 41.391701999999995, -69.96018099999999 41.264545999999996, -70.234054 41.285652999999996)), ((-70.838777 41.347209, -70.603555 41.482383999999996, -70.44623299999999 41.39648, -70.838777 41.347209)))") },
{"id": 34, "name": "Idaho", "boundary": st_geom_from_text("POLYGON ((-117.24267499999999 44.396547999999996, -116.463635 45.602785, -116.85979499999999 45.907264, -117.06263 46.352522, -117.032351 48.999188, -116.049193 49.000912, -116.04885 47.977185999999996, -115.722626 47.694894, -115.62910000000001 47.47672, -115.759233 47.423471, -115.321032 47.256105, -114.76689 46.696901, -114.320665 46.646963, -114.527096 46.146218, -114.388243 45.88234, -114.566172 45.773863999999996, -114.564691 45.558026999999996, -114.333218 45.459316, -113.935505 45.694646999999996, -113.454858 44.865572, -113.131453 44.772836999999996, -112.855395 44.359975, -112.286187 44.568472, -111.467804 44.53902, -111.381665 44.754405, -111.048974 44.474072, -111.046689 42.001567, -117.026197 41.99989, -117.032881 43.830025, -116.894083 44.160191, -117.24267499999999 44.396547999999996))") },
{"id": 35, "name": "Florida", "boundary": st_geom_from_text("MULTIPOLYGON (((-87.6348442887866 30.866109347267003, -87.598928 30.997456999999997, -85.0019 31.000681, -84.864693 30.711541999999998, -82.214839 30.568590999999998, -82.161757 30.357851, -82.036825 30.377883999999998, -81.949787 30.827492999999997, -81.42584599999999 30.700452, -81.253877 29.776851999999998, -80.57424 28.585338999999998, -80.571995 28.111594, -80.031362 26.796339, -80.130697 25.764269, -80.306682 25.612786, -80.358183 25.153228, -80.65769499999999 24.897354, -80.465501 25.211755, -81.087927 25.116170999999998, -81.290328 25.687506, -81.729489 25.909408, -81.868983 26.378648, -82.183813 26.687796, -82.08208599999999 26.653601, -82.05380199999999 26.939798999999997, -82.261941 26.717084999999997, -82.74574799999999 27.538833999999998, -82.393383 27.837519, -82.68674299999999 28.030200999999998, -82.58694799999999 27.819616999999997, -82.73499199999999 27.610839, -82.849126 27.863200000000003, -82.696013 28.930820999999998, -82.813902 29.162502, -83.056542 29.129908999999998, -83.680791 29.921574, -84.20558899999999 30.114323, -84.437597 29.988129999999998, -84.349066 29.896811999999997, -85.351514 29.666669, -85.405052 29.938487, -86.188741 30.334187999999997, -87.51832399999999 30.280434999999997, -87.396177 30.650454, -87.6348442887866 30.866109347267003)), ((-81.815793 24.562739, -81.44351 24.813364, -81.29689499999999 24.655382, -81.815793 24.562739)))") },
{"id": 36, "name": "Kansas", "boundary": st_geom_from_text("POLYGON ((-102.051744 40.003077999999995, -94.943867 39.898129999999995, -94.862943 39.742993999999996, -95.109304 39.542285, -94.588413 39.149868999999995, -94.617964 36.998905, -102.042089 36.993016, -102.051744 40.003077999999995))") },
{"id": 37, "name": "New Hampshire", "boundary": st_geom_from_text("POLYGON ((-72.55724699999999 42.853018999999996, -72.065434 44.277235, -71.577643 44.502691999999996, -71.443365 45.237724, -71.083924 45.305451, -70.98764899999999 43.389520999999995, -70.712085 43.043724999999995, -71.29420499999999 42.69699, -72.458519 42.726853, -72.55724699999999 42.853018999999996))") },
{"id": 38, "name": "Delaware", "boundary": st_geom_from_text("POLYGON ((-75.78865590755069 39.659333499406, -75.66282199999999 39.821149999999996, -75.405414 39.796396, -75.59232899999999 39.467577999999996, -75.30407799999999 38.91316, -75.09201399999999 38.803902, -75.04893899999999 38.451263, -75.69367 38.46008, -75.78865590755069 39.659333499406))") },
{"id": 39, "name": "Texas", "boundary": st_geom_from_text("MULTIPOLYGON (((-106.645479 31.89867, -106.618486 32.000495, -103.064423 32.000518, -103.041924 36.500439, -100.000406 36.499702, -100.000381 34.560508999999996, -99.69497 34.378333, -99.36961 34.458698999999996, -99.189511 34.214312, -98.486328 34.062598, -98.109462 34.154111, -97.967777 33.88243, -97.210921 33.916064, -97.12610199999999 33.716941, -96.981337 33.956378, -96.348306 33.686378999999995, -95.21763299999999 33.962646, -94.38608599999999 33.544923, -94.056598 33.567825, -94.041833 31.992402, -93.50846 31.029441, -93.740253 30.539569, -93.699396 30.05925, -93.92799199999999 29.809639999999998, -93.83772499999999 29.679024, -94.778691 29.361483, -94.47070199999999 29.556582, -94.778992 29.530157, -94.754808 29.781122999999997, -94.99906399999999 29.709049, -94.86436599999999 29.370510999999997, -95.38368299999999 28.87, -96.342483 28.418716, -97.04607999999999 27.839539, -96.880061 28.131072, -96.416348 28.413871, -96.66519799999999 28.30961, -96.815055 28.475209, -96.785226 28.22954, -97.22283 28.077347999999997, -97.024962 28.113307, -97.075077 27.919354, -97.51854 27.86545, -97.243544 27.689227, -97.414436 27.321568, -97.70880199999999 27.385638, -97.74011399999999 27.267542, -97.42259299999999 27.262045, -97.445708 26.609361999999997, -97.29427199999999 26.105843, -97.14966199999999 26.064135999999998, -97.40525 25.837728, -97.662728 26.038078, -98.193985 26.053324, -99.085126 26.398781999999997, -99.446086 27.023338, -99.512219 27.568094, -100.291397 28.275396999999998, -100.674656 29.099777, -101.400884 29.770069, -102.315389 29.87992, -102.673997 29.744574, -102.86846800000001 29.222879, -103.283457 28.976944999999997, -104.509025 29.633281999999998, -104.922935 30.603848, -106.645479 31.89867)), ((-97.398388 26.867894, -97.36182099999999 27.35906, -97.05682999999999 27.841994, -97.365386 27.199887, -97.276173 26.565462999999998, -97.398388 26.867894)))") },
{"id": 40, "name": "Minnesota", "boundary": st_geom_from_text("POLYGON ((-97.239209 48.968683999999996, -95.153711 48.998903, -95.153314 49.384358, -94.957465 49.370186, -94.816222 49.320986999999995, -94.645387 48.744079, -93.794454 48.516020999999995, -92.954876 48.631493, -92.634931 48.542873, -92.71256199999999 48.463013, -92.45632499999999 48.414204, -92.369174 48.220268, -92.055228 48.359213, -91.56725399999999 48.043718999999996, -90.88548 48.245784, -90.75160799999999 48.090968, -89.491739 48.005212, -90.777003 47.60623, -92.08534 46.795767, -92.01529 46.706469, -92.291292 46.668141999999996, -92.294033 46.074377, -92.869193 45.717568, -92.883749 45.575483, -92.646602 45.441635, -92.807317 44.750364, -91.43252199999999 43.996826999999996, -91.21770599999999 43.50055, -96.45326 43.500389999999996, -96.45306699999999 45.298114999999996, -96.857751 45.605962, -96.583085 45.820024, -96.554507 46.083977999999995, -96.797941 46.629113, -96.851051 47.59794, -97.146667 48.143203, -97.090328 48.684512, -97.239209 48.968683999999996))") },
{"id": 41, "name": "Connecticut", "boundary": st_geom_from_text("POLYGON ((-73.727775 41.100696, -73.482709 41.212759999999996, -73.487314 42.049638, -71.80064999999999 42.023568999999995, -71.857458 41.320789, -72.91308699999999 41.296737, -73.657336 40.985171, -73.727775 41.100696))") },
{"id": 42, "name": "New Jersey", "boundary": st_geom_from_text("POLYGON ((-75.559102 39.629056, -74.72260399999999 40.150009999999995, -75.20181199999999 40.617188, -75.051029 40.865662, -75.130575 40.991093, -74.79504 41.320406999999996, -73.893979 40.997197, -74.27269 40.488405, -73.982855 40.448569, -74.10334399999999 39.751646, -74.792723 38.991991, -74.967274 38.933413, -74.88716699999999 39.158825, -75.151405 39.189996, -75.559102 39.629056))") },
{"id": 43, "name": "North Dakota", "boundary": st_geom_from_text("POLYGON ((-104.048652 48.865733999999996, -104.048736 48.999877, -97.22872199999999 49.000561999999995, -97.090328 48.684512, -97.146667 48.143203, -96.851051 47.59794, -96.797941 46.629113, -96.562525 45.937087, -104.045443 45.94531, -104.048652 48.865733999999996))") },
{"id": 44, "name": "Maryland", "boundary": st_geom_from_text("POLYGON ((-79.48764992808078 39.2799539963283, -79.47666199999999 39.721078, -75.788596 39.722198999999996, -75.69367 38.46008, -75.054591 38.414829999999995, -75.242266 38.027209, -75.885032 37.911716999999996, -75.85027199999999 38.366394, -75.97026 38.233806, -76.011419 38.37683, -76.032044 38.216684, -76.226376 38.309988, -76.286102 38.625656, -76.026512 38.56682, -76.22461799999999 38.760387, -76.339709 38.670642, -76.255016 38.862268, -76.155334 38.77234, -76.21000000000001 38.946314, -76.368195 38.836124999999996, -76.361727 38.939175, -76.163988 38.999541, -76.274637 39.16549, -75.948909 39.593177, -76.281747 39.299659999999996, -76.357124 39.394079, -76.442482 39.195408, -76.586485 39.261337, -76.394498 39.012684, -76.560011 38.762626, -76.322158 38.037901999999995, -77.01637099999999 38.445572, -77.25017199999999 38.382781, -76.909395 38.892812, -77.46145 39.075151, -77.838008 39.606125, -78.176625 39.695966999999996, -78.565929 39.519444, -78.76584 39.648486999999996, -79.48764992808078 39.2799539963283))") },
{"id": 45, "name": "Maine", "boundary": st_geom_from_text("POLYGON ((-71.08000299999999 45.306987, -70.85704199999999 45.22916, -70.798028 45.426705999999996, -70.634661 45.383607999999995, -70.72284499999999 45.512772, -70.259117 45.890755, -70.29273599999999 46.191599, -69.997086 46.695229999999995, -69.22442 47.459686, -68.90008499999999 47.177718999999996, -68.23460399999999 47.355035, -67.790515 47.067921, -67.817892 45.693705, -67.429716 45.583773, -67.489333 45.281282, -67.15791899999999 45.161004, -66.949895 44.817419, -67.564718 44.532067999999995, -67.847776 44.563, -68.049334 44.330729999999996, -68.211426 44.52014, -68.36568 44.435345, -68.17449599999999 44.345181, -68.333831 44.221286, -68.425338 44.498275, -68.522786 44.228099, -68.827197 44.31216, -68.805863 44.524291999999996, -68.998384 44.425585999999996, -69.125281 43.977914999999996, -69.43773399999999 43.975750999999995, -69.655611 43.781039, -69.677078 43.926984, -69.836799 43.699735, -70.045006 43.736667999999995, -69.950647 43.86327, -70.19426899999999 43.768601, -70.196911 43.565146, -70.703819 43.059825, -70.98764899999999 43.389520999999995, -71.08000299999999 45.306987))") },
{"id": 46, "name": "Rhode Island", "boundary": st_geom_from_text("MULTIPOLYGON (((-71.19951625965957 41.60319584997731, -71.132888 41.660101999999995, -71.12057 41.497448, -71.19951625965957 41.60319584997731)), ((-71.8626677422346 41.310863612697, -71.79924199999999 42.008064999999995, -71.381401 42.018798, -71.23844199999999 41.665565, -71.390557 41.783708, -71.480875 41.360248, -71.8626677422346 41.310863612697)))") },
{"id": 47, "name": "California", "boundary": st_geom_from_text("POLYGON ((-124.408601 40.443200999999995, -124.111756 41.026883, -124.21160499999999 41.99846, -119.999168 41.99454, -120.001014 38.999573999999996, -114.633487 35.001857, -114.386699 34.457910999999996, -114.131211 34.26273, -114.434181 34.087379, -114.524599 33.552231, -114.72528199999999 33.405048, -114.706488 33.08816, -114.469039 32.972294999999995, -114.526856 32.757093999999995, -117.12486200000001 32.534155999999996, -117.46979400000001 33.296417, -118.132698 33.753217, -118.411211 33.741985, -118.519514 34.027509, -119.129252 34.10084, -119.563986 34.41532, -120.63672199999999 34.560967, -120.644311 35.139616, -121.902729 36.306379, -121.862266 36.931551999999996, -122.405073 37.195791, -122.478083 37.810828, -122.044771 37.457249, -122.430087 37.963114999999995, -122.282824 38.082889, -122.489974 38.112013999999995, -122.527399 37.814947, -123.024066 37.994878, -122.977082 38.267902, -123.727976 38.919429, -123.851714 39.832041, -124.408601 40.443200999999995))") },
{"id": 48, "name": "New York", "boundary": st_geom_from_text("POLYGON ((-79.762152 42.243054, -78.853455 42.783958, -79.070469 43.262454, -76.787949 43.311309, -76.209853 43.560136, -76.297392 43.855925, -76.059062 43.9857, -76.20164 44.079038999999995, -76.280677 43.959683, -76.312647 44.199044, -75.283136 44.849156, -74.826578 45.01585, -73.343124 45.010839999999995, -73.431229 43.588285, -73.24158899999999 43.534973, -73.264957 42.74594, -73.50814199999999 42.086256999999996, -73.482709 41.212759999999996, -73.727775 41.100696, -73.65597199999999 40.979597, -73.81520499999999 40.831075, -72.278789 41.158722, -72.11618064373404 41.00478221051866, -73.940591 40.542896, -74.042412 40.624846999999995, -73.893979 40.997197, -74.983341 41.480894, -75.072172 41.813731999999995, -75.359579 41.999445, -79.76137399999999 41.999067, -79.762152 42.243054))") },
{"id": 49, "name": "District of Columbia", "boundary": st_geom_from_text("POLYGON ((-77.119759 38.934343, -76.909395 38.892812, -77.039006 38.791644999999995, -77.119759 38.934343))") }
]);

// ----------- Insert data into POIS

use SJTest;

INSERT INTO POIS ([
{"id": 477940459990302720, "latitude": 39.60127691, "longitude": -75.08210896 },
{"id": 477790131575730177, "latitude": 40.1514752, "longitude": -74.81236042 },
{"id": 477710471814848512, "latitude": 33.43804694, "longitude": -95.68763757 },
{"id": 477985242800996353, "latitude": 41.48453081, "longitude": -81.52077033 },
{"id": 478030228334198784, "latitude": 41.39446897, "longitude": -81.77584306 },
{"id": 477924841790922752, "latitude": 36.07628074, "longitude": -79.79048387 },
{"id": 477970695121432576, "latitude": 41.53870828, "longitude": -74.08805952 },
{"id": 477862757627592704, "latitude": 35.7346058, "longitude": -81.30704639 },
{"id": 478023082238816256, "latitude": 35.3657508, "longitude": -119.0102226 },
{"id": 477903515004993536, "latitude": 41.22221807, "longitude": -73.19275067 },
{"id": 477938785984843776, "latitude": 36.24723439, "longitude": -115.05323046 },
{"id": 477993123273252864, "latitude": 35.14151039, "longitude": -90.03867381 },
{"id": 477951332804861952, "latitude": 33.87416095, "longitude": -118.35009287 },
{"id": 477893925420957697, "latitude": 41.78922283, "longitude": -71.510315 },
{"id": 477800021468151808, "latitude": 39.9847605, "longitude": -75.1554912 },
{"id": 477976590979063809, "latitude": 31.3646508, "longitude": -110.95371188 },
{"id": 477934575625043968, "latitude": 38.6834504, "longitude": -121.2700596 },
{"id": 477895250854154240, "latitude": 34.31816446, "longitude": -118.48024392 },
{"id": 477693917203165184, "latitude": 33.03928163, "longitude": -96.88638643 },
{"id": 477987651723612161, "latitude": 36.9600352, "longitude": -120.0363063 },
{"id": 477784297613430785, "latitude": 36.42884804, "longitude": -76.36722257 },
{"id": 478001570689216512, "latitude": 41.63920715, "longitude": -87.56199455 },
{"id": 477708824313204737, "latitude": 34.03503475, "longitude": -118.3755469 },
{"id": 477697371217068033, "latitude": 40.69421039, "longitude": -73.70531126 },
{"id": 477712027977150465, "latitude": 30.8511237, "longitude": -93.2950018 },
{"id": 477893366458228736, "latitude": 37.62058509, "longitude": -109.47617019 },
{"id": 478028298979536897, "latitude": 33.87267676, "longitude": -117.74513179 },
{"id": 477985347683364864, "latitude": 33.84093782, "longitude": -118.39112049 },
{"id": 477890422337847296, "latitude": 45.5816052, "longitude": -122.3602295 },
{"id": 478015380498022401, "latitude": 39.28363031, "longitude": -76.62181533 },
{"id": 477745839117721600, "latitude": 31.36526636, "longitude": -89.29842984 },
{"id": 477816226769801216, "latitude": 40.06843354, "longitude": -74.86433339 },
{"id": 477872171566391300, "latitude": 30.9128876, "longitude": -83.2392699 },
{"id": 477866362866774016, "latitude": 38.9064913, "longitude": -77.0416139 },
{"id": 477913033713659905, "latitude": 45.5057, "longitude": -73.5608 },
{"id": 477721488758276096, "latitude": 34.1109045, "longitude": -117.3457078 },
{"id": 477868622904172545, "latitude": 33.25337717, "longitude": -81.94603765 },
{"id": 477838810013638656, "latitude": 33.89785895, "longitude": -118.31028598 },
{"id": 477933599845810176, "latitude": 43.20424045, "longitude": -79.84003499 },
{"id": 478007349232160768, "latitude": 30.49127254, "longitude": -90.4802828 },
{"id": 477817866981371905, "latitude": 49.7371959, "longitude": -96.87045848 },
{"id": 477987831831597057, "latitude": 40.05282192, "longitude": -75.13428426 },
{"id": 477714409964331008, "latitude": 33.42498148, "longitude": -86.62742911 },
{"id": 477997717017608192, "latitude": 39.56420777, "longitude": -76.99351121 },
{"id": 477806861245091840, "latitude": 33.22548108, "longitude": -82.5657175 },
{"id": 477931439271706625, "latitude": 40.261022, "longitude": -76.79750594 },
{"id": 478040747015696384, "latitude": 37.3259826, "longitude": -77.4417275 },
{"id": 477972909109936128, "latitude": 34.00351798, "longitude": -118.48500139 },
{"id": 478021564642783232, "latitude": 33.92465156, "longitude": -118.13826456 },
{"id": 477823067670847488, "latitude": 38.9824508, "longitude": -76.4949692 },
{"id": 477990849377497089, "latitude": 41.52279668, "longitude": -81.62979662 },
{"id": 477946764641964032, "latitude": 34.05945275, "longitude": -84.08681443 },
{"id": 477942878690234369, "latitude": 33.88460724, "longitude": -117.49207187 },
{"id": 477902253169184768, "latitude": 38.7696517, "longitude": -89.9656719 },
{"id": 478021172173733888, "latitude": 39.0642047, "longitude": -84.4711534 },
{"id": 478025089892372480, "latitude": 38.16958174, "longitude": -85.87278843 },
{"id": 477806769431797761, "latitude": 33.94027909, "longitude": -118.40648334 },
{"id": 477717169103331329, "latitude": 34.01226862, "longitude": -118.09915817 },
{"id": 478014983616618497, "latitude": 39.60295926, "longitude": -105.02260514 },
{"id": 477729349500563456, "latitude": 37.99818121, "longitude": -84.21115136 },
{"id": 477685246914465792, "latitude": 40.09554088, "longitude": -82.95717482 },
{"id": 477865432121348096, "latitude": 39.76031722, "longitude": -86.1575784 },
{"id": 477689754977181696, "latitude": 47.23433434, "longitude": -122.15083003 },
{"id": 477955520066617345, "latitude": 33.30739744, "longitude": -111.97886346 },
{"id": 478031251405021184, "latitude": 40.33253123, "longitude": -76.80739109 },
{"id": 477878662235435008, "latitude": 39.0890013, "longitude": -95.6884688 },
{"id": 477807102228836353, "latitude": 34.74548518, "longitude": -81.94682579 },
{"id": 477886749923094528, "latitude": 40.82511353, "longitude": -73.85390859 },
{"id": 477864102120161280, "latitude": 35.8529023, "longitude": -95.42135767 },
{"id": 477688305509597184, "latitude": 39.73074608, "longitude": -74.90067266 },
{"id": 477844975372476416, "latitude": 39.32013315, "longitude": -84.54873581 },
{"id": 478019144693329920, "latitude": 41.21432831, "longitude": -80.54341614 },
{"id": 477963661403619329, "latitude": 33.6433111, "longitude": -112.118585 },
{"id": 477969815672328194, "latitude": 33.72222418, "longitude": -92.64973803 },
{"id": 477841342911885312, "latitude": 39.28065676, "longitude": -76.56681334 },
{"id": 477889624178581506, "latitude": 36.95340629, "longitude": -120.06700063 },
{"id": 477940249486565376, "latitude": 36.34748719, "longitude": -94.21057687 },
{"id": 477933871195901952, "latitude": 35.58765105, "longitude": -78.35785957 },
{"id": 477682766164000768, "latitude": 40.6634903, "longitude": -74.1110378 },
{"id": 477958125048180736, "latitude": 40.79365954, "longitude": -77.85999475 },
{"id": 477960384885051393, "latitude": 43.74163153, "longitude": -79.55500957 },
{"id": 478018844431511552, "latitude": 40.85231804, "longitude": -73.97942773 },
{"id": 477935367392620544, "latitude": 41.80048501, "longitude": -71.8879753 },
{"id": 477798558406414336, "latitude": 43.5698948, "longitude": -79.6691208 },
{"id": 478003401713025024, "latitude": 43.62132814, "longitude": -116.34896264 },
{"id": 477679655206813696, "latitude": 40.74323463, "longitude": -73.98569682 },
{"id": 477812331200913408, "latitude": 31.2783036, "longitude": -92.4307188 },
{"id": 477968197203664896, "latitude": 33.04786211, "longitude": -117.29755178 },
{"id": 477952606695088128, "latitude": 43.65619562, "longitude": -79.3805137 },
{"id": 478021704476655616, "latitude": 37.6368882, "longitude": -122.0984205 },
{"id": 477702943513534465, "latitude": 40.79229131, "longitude": -74.32971485 },
{"id": 477860289577488384, "latitude": 42.43418214, "longitude": -83.04946121 },
{"id": 477810175772856320, "latitude": 35.10625596, "longitude": -77.04778736 },
{"id": 477780073995464704, "latitude": 43.6928174, "longitude": -87.7125278 },
{"id": 477875035651457026, "latitude": 40.87373665, "longitude": -74.17612931 },
{"id": 477833996580040705, "latitude": 32.4191746, "longitude": -81.7869042 },
{"id": 477901252748001280, "latitude": 42.6607329, "longitude": -71.3024034 },
{"id": 477993581190598656, "latitude": 34.61968507, "longitude": -79.00082282 },
{"id": 477918999255474176, "latitude": 31.20446667, "longitude": -87.602705 },
{"id": 478001129473597440, "latitude": 33.66173133, "longitude": -117.99760789 },
{"id": 477741840129462272, "latitude": 41.72580357, "longitude": -83.60777901 },
{"id": 478022065073946625, "latitude": 41.89967688, "longitude": -87.76559374 },
{"id": 477899807814877184, "latitude": 42.2539919, "longitude": -71.82697122 },
{"id": 477867002460401664, "latitude": 38.90826031, "longitude": -77.04231262 },
{"id": 477714969463496705, "latitude": 32.59926679, "longitude": -96.76870759 },
{"id": 478022159198326784, "latitude": 41.88569827, "longitude": -87.61582761 },
{"id": 477871658762387456, "latitude": 41.59578485, "longitude": -93.66029367 },
{"id": 477812649544417280, "latitude": 40.77836073, "longitude": -73.51308269 },
{"id": 478016151213965312, "latitude": 35.6259867, "longitude": -105.9808948 },
{"id": 477955249861173250, "latitude": 38.6633284, "longitude": -121.49791509 },
{"id": 478018657273249792, "latitude": 41.10775421, "longitude": -85.05600725 },
{"id": 478033837243772928, "latitude": 32.72854627, "longitude": -117.22587121 },
{"id": 477939053807955969, "latitude": 42.74245328, "longitude": -84.39348084 },
{"id": 477732786380365824, "latitude": 38.96133218, "longitude": -95.31464709 },
{"id": 478008443056717825, "latitude": 39.96700038, "longitude": -74.26460732 },
{"id": 477972538111188992, "latitude": 35.3887115, "longitude": -119.1309104 },
{"id": 477962976960315392, "latitude": 33.8754065, "longitude": -117.7533813 },
{"id": 477789249195225088, "latitude": 38.20716416, "longitude": -84.81514522 },
{"id": 477802144251531264, "latitude": 37.44351927, "longitude": -77.66935801 },
{"id": 477909725905174529, "latitude": 47.66852744, "longitude": -122.38511719 },
{"id": 477891111860449280, "latitude": 32.90800808, "longitude": -117.13767925 },
{"id": 477898631903973376, "latitude": 30.53614936, "longitude": -90.47798467 },
{"id": 477943243775045632, "latitude": 36.15965854, "longitude": -115.24152072 },
{"id": 477722811058778112, "latitude": 38.6748329, "longitude": -121.5338647 },
{"id": 477709178467655680, "latitude": 38.88810024, "longitude": -121.31877659 },
{"id": 477966296764542976, "latitude": 32.95175169, "longitude": -96.61296843 },
{"id": 478000266617552897, "latitude": 36.02849819, "longitude": -115.0692286 },
{"id": 477880874927931393, "latitude": 40.5444743, "longitude": -74.1574014 },
{"id": 478028311302795264, "latitude": 40.551354, "longitude": -74.1802795 },
{"id": 477950147872038915, "latitude": 39.84905545, "longitude": -75.4374292 },
{"id": 477907262560694272, "latitude": 42.36665316, "longitude": -71.06260883 },
{"id": 477869023099887616, "latitude": 39.96663803, "longitude": -75.12878428 },
{"id": 478019511153487872, "latitude": 34.1518669, "longitude": -118.4227387 },
{"id": 477924570469371904, "latitude": 41.28260956, "longitude": -96.16403055 },
{"id": 477850569672261635, "latitude": 34.7919172, "longitude": -86.7285245 },
{"id": 477684266776539136, "latitude": 32.6644321, "longitude": -116.96162864 },
{"id": 477854131801972738, "latitude": 42.98238002, "longitude": -88.2592917 },
{"id": 477991260201164801, "latitude": 45.18785731, "longitude": -93.33917043 },
{"id": 477922136296681472, "latitude": 40.99099099, "longitude": -79.10798206 },
{"id": 477866271548379136, "latitude": 42.1006064, "longitude": -80.09492712 },
{"id": 477693328704540672, "latitude": 33.9731721, "longitude": -118.2353379 },
{"id": 478032616969367552, "latitude": 33.0902049, "longitude": -81.9617307 },
{"id": 477990464235122688, "latitude": 34.16036746, "longitude": -118.53782801 },
{"id": 477890625056931841, "latitude": 36.85581682, "longitude": -119.67278405 },
{"id": 477998138829987840, "latitude": 37.81051453, "longitude": -85.4503716 },
{"id": 477833117374611456, "latitude": 44.11614436, "longitude": -103.06577797 },
{"id": 478013367010209792, "latitude": 40.78099404, "longitude": -77.85107683 },
{"id": 477846708165279744, "latitude": 41.06365442, "longitude": -80.055738 },
{"id": 477990927747674112, "latitude": 34.0200987, "longitude": -118.3250881 },
{"id": 477716262395867136, "latitude": 39.31396817, "longitude": -76.67261942 },
{"id": 477958377176182784, "latitude": 32.20618574, "longitude": -110.90207834 },
{"id": 477911776831369216, "latitude": 43.34336886, "longitude": -72.48533459 },
{"id": 478011971321991169, "latitude": 40.8305601, "longitude": -73.93521622 },
{"id": 477904525836046337, "latitude": 32.8397361, "longitude": -97.0111221 },
{"id": 477917202776330241, "latitude": 40.78331945, "longitude": -73.21867713 },
{"id": 477996255675576320, "latitude": 32.20294, "longitude": -98.2399004 },
{"id": 477923101528043520, "latitude": 40.71424858, "longitude": -73.95375967 },
{"id": 477809256251793408, "latitude": 33.94389398, "longitude": -118.40502262 },
{"id": 478017662329823232, "latitude": 40.9444786, "longitude": -73.88956896 },
{"id": 477836726254063616, "latitude": 33.53821433, "longitude": -84.56882506 },
{"id": 478035545424019457, "latitude": 34.03297096, "longitude": -118.4859452 },
{"id": 477867896610123776, "latitude": 41.50693914, "longitude": -82.94852757 },
{"id": 478017597758136322, "latitude": 45.16530905, "longitude": -93.23935113 },
{"id": 477967996007104512, "latitude": 41.2941292, "longitude": -72.9562981 },
{"id": 477924929136906241, "latitude": 30.193654, "longitude": -97.7663298 },
{"id": 477964119467757568, "latitude": 42.3404497, "longitude": -83.205684 },
{"id": 478032297955168256, "latitude": 40.8503476, "longitude": -73.9401381 },
{"id": 477859620191760384, "latitude": 32.23433126, "longitude": -110.79989419 },
{"id": 477964238627958784, "latitude": 36.64489682, "longitude": -77.86652518 },
{"id": 477783354054815744, "latitude": 42.9476236, "longitude": -78.8207316 },
{"id": 477689514463211520, "latitude": 38.5300082, "longitude": -121.4826188 },
{"id": 478005025185464320, "latitude": 42.86847305, "longitude": -78.79903624 },
{"id": 477986693471952897, "latitude": 31.75989014, "longitude": -106.31561299 },
{"id": 477957785909735424, "latitude": 39.81871193, "longitude": -75.53023171 },
{"id": 477890178640384001, "latitude": 37.5688636, "longitude": -77.4540628 },
{"id": 478004308827717632, "latitude": 39.14933024, "longitude": -84.43623134 },
{"id": 478029048799846401, "latitude": 40.3030824, "longitude": -121.228368 },
{"id": 477918605024428032, "latitude": 41.3849, "longitude": -71.8324 },
{"id": 477704344804917248, "latitude": 34.04481618, "longitude": -117.64472726 },
{"id": 478017044638474240, "latitude": 38.2475201, "longitude": -121.3203015 },
{"id": 477858541366415360, "latitude": 39.9505, "longitude": -75.1665 },
{"id": 478040810793861121, "latitude": 37.7854956, "longitude": -122.4156964 },
{"id": 477699581149343746, "latitude": 34.14515531, "longitude": -118.10567066 },
{"id": 477683342683676672, "latitude": 41.47743349, "longitude": -90.56032738 },
{"id": 477692432629260288, "latitude": 34.2438489, "longitude": -77.896849 },
{"id": 477793948002308096, "latitude": 32.219705, "longitude": -106.71692 },
{"id": 477804456218984448, "latitude": 38.5387125, "longitude": -75.05452752 },
{"id": 477911363524644864, "latitude": 34.178989, "longitude": -118.5970172 },
{"id": 477878260219777024, "latitude": 40.74851475, "longitude": -73.04856675 },
{"id": 477831827236073472, "latitude": 40.69118179, "longitude": -74.01678085 },
{"id": 477962480053149697, "latitude": 41.52291792, "longitude": -73.9371046 },
{"id": 477686459692883969, "latitude": 34.02691118, "longitude": -118.27842855 },
{"id": 477935614818398208, "latitude": 32.6797551, "longitude": -117.0694914 },
{"id": 478033494506209280, "latitude": 43.42099013, "longitude": -70.61556979 },
{"id": 477966082389471233, "latitude": 31.8765154, "longitude": -102.3162344 },
{"id": 477985210265763841, "latitude": 34.16597277, "longitude": -118.58611045 },
{"id": 478039363477987328, "latitude": 33.07497432, "longitude": -96.72300287 },
{"id": 477926631617478656, "latitude": 33.36047754, "longitude": -111.88298489 },
{"id": 477893937122668544, "latitude": 30.47940996, "longitude": -84.16244847 },
{"id": 477931754834386944, "latitude": 41.86256496, "longitude": -80.55896709 },
{"id": 477908713605300224, "latitude": 42.14364648, "longitude": -72.49528381 },
{"id": 477916962819829760, "latitude": 34.34233036, "longitude": -78.69287931 },
{"id": 477704963724828672, "latitude": 38.30213214, "longitude": -122.31423652 },
{"id": 478037978233966593, "latitude": 40.70936438, "longitude": -73.93719625 },
{"id": 477689651637940224, "latitude": 32.51559582, "longitude": -96.37546796 },
{"id": 478037659471056896, "latitude": 40.76366855, "longitude": -73.98612947 },
{"id": 477871126472040448, "latitude": 45.3971171, "longitude": -75.8488709 },
{"id": 477852612054634496, "latitude": 30.3019185, "longitude": -97.692977 },
{"id": 477863043632619521, "latitude": 42.6427867, "longitude": -71.2991179 },
{"id": 477885901591560192, "latitude": 32.62953799, "longitude": -83.66239552 },
{"id": 477998671141679105, "latitude": 33.5644901, "longitude": -86.7190393 },
{"id": 477681555175788544, "latitude": 35.43671433, "longitude": -80.73635268 },
{"id": 477936827597193216, "latitude": 33.95645024, "longitude": -117.23417698 },
{"id": 477871895246036992, "latitude": 43.25049676, "longitude": -83.77933309 },
{"id": 477960076796252162, "latitude": 38.4268189, "longitude": -76.4814515 },
{"id": 477949120313704448, "latitude": 43.7233751, "longitude": -79.668652 },
{"id": 477960961555300352, "latitude": 36.71289148, "longitude": -121.62034351 },
{"id": 477881528337190912, "latitude": 35.97806149, "longitude": -86.56547779 },
{"id": 477940766870761473, "latitude": 40.03622527, "longitude": -76.31628094 },
{"id": 478029034325311488, "latitude": 39.28700945, "longitude": -76.73488088 },
{"id": 477989075082022912, "latitude": 41.7648877, "longitude": -87.8062973 },
{"id": 477808000292233216, "latitude": 32.40897032, "longitude": -97.76105025 },
{"id": 477828719420399616, "latitude": 37.98200177, "longitude": -87.63579244 },
{"id": 477737856010440705, "latitude": 34.02855818, "longitude": -117.63851157 },
{"id": 477889079963435008, "latitude": 32.91214498, "longitude": -96.98220881 },
{"id": 477914081425244160, "latitude": 47.14988004, "longitude": -91.45364942 },
{"id": 477901638854651904, "latitude": 39.64296332, "longitude": -106.38823919 },
{"id": 477808001420906496, "latitude": 30.10967478, "longitude": -93.74674875 },
{"id": 477916586230030336, "latitude": 35.08500927, "longitude": -80.63319144 },
{"id": 477884640330788864, "latitude": 41.85938228, "longitude": -88.07347735 },
{"id": 477708778998341632, "latitude": 36.28222236, "longitude": -115.28191601 },
{"id": 478017816306925568, "latitude": 39.43706326, "longitude": -74.51741 },
{"id": 477815334171598848, "latitude": 42.82934794, "longitude": -86.06309999 },
{"id": 478023453639852032, "latitude": 38.64903476, "longitude": -85.32328796 },
{"id": 477869761255469056, "latitude": 36.1290158, "longitude": -115.2039619 },
{"id": 477961053658030081, "latitude": 33.63903871, "longitude": -111.97120395 },
{"id": 477728353068544000, "latitude": 35.58133872, "longitude": -97.52597323 },
{"id": 477814781617774592, "latitude": 30.3800325, "longitude": -97.6586255 },
{"id": 477880679393263616, "latitude": 33.99768365, "longitude": -117.81735398 },
{"id": 477864520723857409, "latitude": 40.4862157, "longitude": -74.4518188 },
{"id": 477978576126758912, "latitude": 43.58957788, "longitude": -89.7833777 },
{"id": 477886101089435648, "latitude": 41.5882, "longitude": -93.618 },
{"id": 477991631627370498, "latitude": 33.848431, "longitude": -118.2463685 },
{"id": 477885219609903104, "latitude": 32.4897064, "longitude": -117.0136619 },
{"id": 478027685638471680, "latitude": 38.96354105, "longitude": -76.92634514 },
{"id": 477694229112557568, "latitude": 33.47165251, "longitude": -112.20569405 },
{"id": 478024512710385664, "latitude": 43.68755429, "longitude": -116.50153714 },
{"id": 477747973481172992, "latitude": 36.78027399, "longitude": -119.8180974 },
{"id": 477960059607998464, "latitude": 43.88204911, "longitude": -78.87653078 },
{"id": 477955234455490560, "latitude": 42.5750374, "longitude": -87.8708912 },
{"id": 478029562719113216, "latitude": 42.52663914, "longitude": -89.00081445 },
{"id": 477881374448156672, "latitude": 42.1268789, "longitude": -71.0327824 },
{"id": 478020628604149760, "latitude": 49.18901966, "longitude": -122.80202127 },
{"id": 477718935035338752, "latitude": 33.87307559, "longitude": -118.33737052 },
{"id": 478006089540067328, "latitude": 37.73652416, "longitude": -92.13005704 },
{"id": 477946928043266048, "latitude": 38.6605063, "longitude": -121.5250138 },
{"id": 477679903953805312, "latitude": 42.31194193, "longitude": -89.65558919 },
{"id": 477910847822372864, "latitude": 40.73670468, "longitude": -74.17601316 },
{"id": 477817401862397952, "latitude": 40.150897, "longitude": -79.894714 },
{"id": 478015581082648576, "latitude": 40.73899742, "longitude": -73.6696815 },
{"id": 478012257704480768, "latitude": 47.21223346, "longitude": -122.33665738 },
{"id": 477938305670324224, "latitude": 32.3855, "longitude": -111.0466 },
{"id": 477940480378810368, "latitude": 45.48674588, "longitude": -122.40913865 },
{"id": 477895062404096002, "latitude": 33.50478853, "longitude": -86.70687112 },
{"id": 478024163622264832, "latitude": 47.52106365, "longitude": -122.37185796 },
{"id": 477841460553736192, "latitude": 35.0816837, "longitude": -78.9869528 },
{"id": 477683062763831296, "latitude": 32.86618361, "longitude": -96.61647096 },
{"id": 477922673616781312, "latitude": 36.7057576, "longitude": -76.3243453 },
{"id": 477679237822808065, "latitude": 39.94075903, "longitude": -75.12939813 },
{"id": 477874666712084480, "latitude": 30.44173236, "longitude": -81.6804043 },
{"id": 477980125913694208, "latitude": 37.32848401, "longitude": -92.90783981 },
{"id": 477823838739513344, "latitude": 33.82483429, "longitude": -118.24761714 },
{"id": 477684417167515648, "latitude": 41.69814072, "longitude": -96.88632899 },
{"id": 478007609312550912, "latitude": 40.70376663, "longitude": -82.17407774 },
{"id": 477872254022582272, "latitude": 43.02719906, "longitude": -86.21020662 },
{"id": 477916881102176257, "latitude": 34.42728759, "longitude": -117.37805184 },
{"id": 477833128745385985, "latitude": 42.12772081, "longitude": -80.0672699 },
{"id": 478015574547505152, "latitude": 30.0007518, "longitude": -90.217556 },
{"id": 477971501677699072, "latitude": 43.02911891, "longitude": -87.97134476 },
{"id": 477951280607166464, "latitude": 43.65606148, "longitude": -79.38195362 },
{"id": 477999708829655041, "latitude": 40.7149536, "longitude": -74.0453423 },
{"id": 477924226322956288, "latitude": 36.0158683, "longitude": -115.2972531 },
{"id": 477847809715347457, "latitude": 37.75060823, "longitude": -80.48052168 },
{"id": 477989669922435073, "latitude": 42.8669016, "longitude": -97.4728847 },
{"id": 477846095716823042, "latitude": 30.21276451, "longitude": -85.69263827 },
{"id": 477966887934902272, "latitude": 47.65861153, "longitude": -122.29909985 },
{"id": 478038541537398784, "latitude": 35.20701204, "longitude": -101.88164148 },
{"id": 478037318792925184, "latitude": 37.90198479, "longitude": -88.90947425 },
{"id": 477944624179212289, "latitude": 37.97198685, "longitude": -121.32616046 },
{"id": 477859473764016128, "latitude": 41.54484094, "longitude": -73.08943819 },
{"id": 478039474820362241, "latitude": 39.2442511, "longitude": -84.7950769 },
{"id": 477930677032058880, "latitude": 41.77537712, "longitude": -96.51016546 },
{"id": 477906070375903233, "latitude": 33.4642541, "longitude": -81.858114 },
{"id": 478014494703362048, "latitude": 38.76565397, "longitude": -77.61999165 },
{"id": 477679191379292161, "latitude": 38.89951723, "longitude": -76.94373268 },
{"id": 477857109627764736, "latitude": 35.93967971, "longitude": -77.81812104 },
{"id": 477702281974910977, "latitude": 33.8708481, "longitude": -84.2592263 },
{"id": 477708653127286784, "latitude": 42.2900927, "longitude": -71.115806 },
{"id": 477967544435752960, "latitude": 38.93534126, "longitude": -94.66083593 },
{"id": 477806076851916800, "latitude": 36.96689778, "longitude": -76.28720994 },
{"id": 477923329069051904, "latitude": 40.6650153, "longitude": -74.2083941 },
{"id": 478021449945718786, "latitude": 37.3259858, "longitude": -77.4416771 },
{"id": 477835408584105984, "latitude": 35.4670096, "longitude": -86.04341405 },
{"id": 477700960332939265, "latitude": 36.9881388, "longitude": -86.4781627 },
{"id": 477696717539008512, "latitude": 45.519154, "longitude": -122.49645 },
{"id": 477721971031949312, "latitude": 36.1070567, "longitude": -119.5711719 },
{"id": 478012599649714176, "latitude": 41.70133207, "longitude": -88.11422568 },
{"id": 477987657637560320, "latitude": 46.47830059, "longitude": -84.39180655 },
{"id": 477875364107018240, "latitude": 32.36933551, "longitude": -99.77232272 },
{"id": 477686220302991361, "latitude": 40.42093252, "longitude": -86.88332247 },
{"id": 477887449600131073, "latitude": 40.57814206, "longitude": -75.5314676 },
{"id": 478027760091553793, "latitude": 36.82417816, "longitude": -76.34214668 },
{"id": 477842972419977216, "latitude": 32.525376, "longitude": -92.6474791 },
{"id": 477973536825286656, "latitude": 34.6681647, "longitude": -82.7973042 },
{"id": 478016419091599360, "latitude": 39.94987668, "longitude": -75.16192627 },
{"id": 477984741216759808, "latitude": 37.71247565, "longitude": -97.44235258 },
{"id": 477715971440791552, "latitude": 34.40640852, "longitude": -118.4558852 },
{"id": 477953705749143552, "latitude": 37.73936105, "longitude": -122.47090816 },
{"id": 477977501135015936, "latitude": 38.89622565, "longitude": -77.02710089 },
{"id": 477922679081533440, "latitude": 34.0692007, "longitude": -117.1638077 },
{"id": 477940900006334464, "latitude": 37.7463808, "longitude": -97.2505981 },
{"id": 477802539425857536, "latitude": 42.18297032, "longitude": -71.22980197 },
{"id": 477933301169000449, "latitude": 42.54147457, "longitude": -82.95565193 },
{"id": 477943923617595397, "latitude": 40.52876834, "longitude": -79.91823689 },
{"id": 477962491817783296, "latitude": 43.7771782, "longitude": -79.3229375 },
{"id": 477701543886479361, "latitude": 38.36181239, "longitude": -75.08291012 },
{"id": 477889349422297088, "latitude": 41.15297682, "longitude": -81.33378674 },
{"id": 478026106399109120, "latitude": 41.5916251, "longitude": -81.5438 },
{"id": 477920624904777728, "latitude": 39.1827483, "longitude": -84.2735235 },
{"id": 478013550049247232, "latitude": 34.184408, "longitude": -118.6097329 },
{"id": 477894254334050304, "latitude": 40.52618265, "longitude": -74.26938183 },
{"id": 477910977766117376, "latitude": 30.359091, "longitude": -97.6832213 },
{"id": 477989992061751296, "latitude": 32.95903647, "longitude": -80.17978705 },
{"id": 477683852891025408, "latitude": 33.60219383, "longitude": -117.09650995 },
{"id": 477895846122360832, "latitude": 32.69790599, "longitude": -95.10131946 },
{"id": 477865794332684288, "latitude": 41.40713658, "longitude": -73.41789354 },
{"id": 477715332476309504, "latitude": 45.0189949, "longitude": -85.6293453 },
{"id": 477891425015980032, "latitude": 40.50608209, "longitude": -74.48621007 },
{"id": 477740274676797441, "latitude": 40.03450759, "longitude": -75.10988387 },
{"id": 477923380520161280, "latitude": 32.87843258, "longitude": -96.77219664 },
{"id": 477937296453693440, "latitude": 42.074832, "longitude": -76.8014393 },
{"id": 477959018078806017, "latitude": 40.77892456, "longitude": -73.20423195 },
{"id": 478031294979260417, "latitude": 31.63027507, "longitude": -94.65266814 },
{"id": 478018226123980800, "latitude": 39.59079377, "longitude": -77.65006762 },
{"id": 477812515456704513, "latitude": 38.74031462, "longitude": -77.45205249 },
{"id": 477949972286300160, "latitude": 33.75940171, "longitude": -84.39260365 },
{"id": 477833044405915649, "latitude": 34.0647469, "longitude": -118.2960192 },
{"id": 477710580308922368, "latitude": 49.1272886, "longitude": -125.8929667 },
{"id": 477915909881729024, "latitude": 39.92360248, "longitude": -75.17068578 },
{"id": 477804154220326912, "latitude": 39.31917015, "longitude": -76.56109658 },
{"id": 477987885749403648, "latitude": 30.16022865, "longitude": -81.8395121 },
{"id": 477949357421916160, "latitude": 43.86372963, "longitude": -79.01990986 },
{"id": 478039843415810048, "latitude": 43.54679215, "longitude": -116.27268833 },
{"id": 477820700083118080, "latitude": 38.46800746, "longitude": -77.40823852 },
{"id": 477841919154728961, "latitude": 37.47434778, "longitude": -121.15318998 },
{"id": 478006306104950786, "latitude": 41.36053392, "longitude": -72.11628047 },
{"id": 477915536051810304, "latitude": 33.86704179, "longitude": -117.45907674 },
{"id": 477700221951279104, "latitude": 37.30572696, "longitude": -79.97569383 },
{"id": 477853463628771330, "latitude": 42.25562863, "longitude": -71.79026453 },
{"id": 478033061599526912, "latitude": 36.07474708, "longitude": -91.91118264 },
{"id": 477928443309355009, "latitude": 40.75664227, "longitude": -73.84577442 },
{"id": 477840034188374017, "latitude": 43.1828623, "longitude": -86.2178809 },
{"id": 478035831039733760, "latitude": 40.976158, "longitude": -78.5494174 },
{"id": 477925041238073345, "latitude": 31.343054, "longitude": -110.9306708 },
{"id": 477879667559395328, "latitude": 33.2068828, "longitude": -97.1441011 },
{"id": 478031287563726848, "latitude": 32.7805712, "longitude": -96.8013638 },
{"id": 477953389243138048, "latitude": 43.657183, "longitude": -79.4048378 },
{"id": 477923509394366464, "latitude": 32.78399561, "longitude": -96.78645948 },
{"id": 478026951266152448, "latitude": 36.95598761, "longitude": -78.96751297 },
{"id": 478034571888304129, "latitude": 34.20523713, "longitude": -118.46686103 },
{"id": 477849977520017409, "latitude": 40.8938323, "longitude": -74.1534622 },
{"id": 477704957844398080, "latitude": 45.4481055, "longitude": -122.8030394 },
{"id": 478013302510223361, "latitude": 39.99449054, "longitude": -83.00707676 },
{"id": 477693051306250240, "latitude": 33.51003026, "longitude": -117.66815791 },
{"id": 478006104094289921, "latitude": 35.25699106, "longitude": -81.04538179 },
{"id": 477959740371120128, "latitude": 39.86039966, "longitude": -104.66651148 },
{"id": 477737777425948672, "latitude": 36.13212297, "longitude": -115.20877856 },
{"id": 477793105693769730, "latitude": 38.63529486, "longitude": -77.28855702 },
{"id": 477834692268265472, "latitude": 44.89255, "longitude": -93.560317 },
{"id": 478041279411281923, "latitude": 35.6151194, "longitude": -95.8587043 },
{"id": 477931004557271041, "latitude": 38.83187312, "longitude": -77.20031518 },
{"id": 477851224583049217, "latitude": 32.603274, "longitude": -82.1726845 },
{"id": 477833345288523779, "latitude": 37.3909263, "longitude": -79.1511182 },
{"id": 477881790594842624, "latitude": 35.91243722, "longitude": -81.5342698 },
{"id": 477847264317431808, "latitude": 42.56238644, "longitude": -70.93504692 },
{"id": 477681137700315136, "latitude": 34.75278481, "longitude": -77.37944689 },
{"id": 478005539256164353, "latitude": 33.64044148, "longitude": -84.21523372 },
{"id": 477720222481133568, "latitude": 32.73694721, "longitude": -117.18815526 },
{"id": 477929756495589377, "latitude": 37.5482697, "longitude": -121.9885719 },
{"id": 478014124442804224, "latitude": 35.4573321, "longitude": -97.6897606 },
{"id": 478037377621843968, "latitude": 37.40124077, "longitude": -121.88260612 },
{"id": 477689490903818240, "latitude": 34.01702946, "longitude": -117.70389905 },
{"id": 477978053738758144, "latitude": 40.83293194, "longitude": -89.61476044 },
{"id": 477876360883757056, "latitude": 40.81168398, "longitude": -77.89093791 },
{"id": 478038216365203457, "latitude": 43.1005535, "longitude": -87.9765008 },
{"id": 477922498940383232, "latitude": 41.29872066, "longitude": -86.10756881 },
{"id": 477981779119587328, "latitude": 41.96992555, "longitude": -88.11481077 },
{"id": 477869030083031040, "latitude": 35.6105322, "longitude": -87.1188455 },
{"id": 477906243512983552, "latitude": 38.10951926, "longitude": -85.66456668 },
{"id": 478011577271349248, "latitude": 39.01555629, "longitude": -84.44549088 },
{"id": 477824714555924480, "latitude": 42.41110249, "longitude": -82.96886977 },
{"id": 477844535293521920, "latitude": 40.75501062, "longitude": -72.87116395 },
{"id": 478040453196300288, "latitude": 33.42546641, "longitude": -93.94259811 },
{"id": 478021027218604032, "latitude": 42.00710863, "longitude": -88.376404 },
{"id": 477969951924711425, "latitude": 36.84423907, "longitude": -76.02972834 },
{"id": 478015268997070848, "latitude": 42.91019458, "longitude": -71.93817455 },
{"id": 477872648941092865, "latitude": 31.83119168, "longitude": -106.4522023 },
{"id": 477839945948598272, "latitude": 41.523705, "longitude": -88.0621931 },
{"id": 477738578647474176, "latitude": 45.5239424, "longitude": -122.4934875 },
{"id": 477804574137282560, "latitude": 35.85695515, "longitude": -86.45832902 },
{"id": 477912240134172672, "latitude": 34.42363667, "longitude": -118.5700607 },
{"id": 478023475656146944, "latitude": 42.11965623, "longitude": -83.21522175 },
{"id": 477833462162796545, "latitude": 42.81293909, "longitude": -83.62068722 },
{"id": 477994175926128641, "latitude": 39.9766276, "longitude": -82.8323485 },
{"id": 477833593410957312, "latitude": 35.0029031, "longitude": -109.8994866 },
{"id": 477909903764623361, "latitude": 46.999543, "longitude": -122.9154661 },
{"id": 477977383757443073, "latitude": 32.94489976, "longitude": -96.71110036 },
{"id": 477921634242682880, "latitude": 45.0715679, "longitude": -122.7956733 },
{"id": 478039054777196545, "latitude": 38.8888726, "longitude": -121.3303283 },
{"id": 477730927368355841, "latitude": 33.9552782, "longitude": -118.2408319 },
{"id": 477819605260726273, "latitude": 39.35694782, "longitude": -74.43962706 },
{"id": 478032564079190016, "latitude": 38.4482793, "longitude": -121.4077054 },
{"id": 477681306726187009, "latitude": 33.5735512, "longitude": -92.8597276 },
{"id": 477884541479055360, "latitude": 44.998804, "longitude": -93.3691498 },
{"id": 478006814244876288, "latitude": 40.9059708, "longitude": -72.6504527 },
{"id": 477870333102686212, "latitude": 40.85433896, "longitude": -73.96549076 },
{"id": 477863486761209856, "latitude": 40.80429434, "longitude": -73.51790909 },
{"id": 477720889057083392, "latitude": 41.88218853, "longitude": -71.35800177 },
{"id": 478025907870113792, "latitude": 30.31159092, "longitude": -81.40721603 },
{"id": 477701642171600896, "latitude": 35.42502865, "longitude": -78.06728159 },
{"id": 477899848537366529, "latitude": 40.27521492, "longitude": -75.31873602 },
{"id": 477955854990204928, "latitude": 30.59461799, "longitude": -81.4443254 },
{"id": 477813748410089472, "latitude": 41.07650509, "longitude": -73.47121227 },
{"id": 477967832891031553, "latitude": 39.88944784, "longitude": -75.05843529 },
{"id": 477681877440925696, "latitude": 42.28811608, "longitude": -71.08818083 },
{"id": 477892535227277312, "latitude": 30.10121455, "longitude": -81.71418034 },
{"id": 477932514959302656, "latitude": 40.61480581, "longitude": -74.12057337 },
{"id": 477830405140127744, "latitude": 39.16547145, "longitude": -74.68362831 },
{"id": 478019244714893312, "latitude": 35.4877422, "longitude": -97.52519488 },
{"id": 477721002646855680, "latitude": 33.0363669, "longitude": -96.58739288 },
{"id": 477885357070229504, "latitude": 34.02587356, "longitude": -118.51587228 },
{"id": 477688558275145730, "latitude": 33.03915996, "longitude": -86.06779662 },
{"id": 478003749085265920, "latitude": 41.5750104, "longitude": -85.41041474 },
{"id": 477807072944209920, "latitude": 39.7400441, "longitude": -104.9130089 },
{"id": 477706138020892672, "latitude": 33.94631089, "longitude": -118.4043573 },
{"id": 478006693155340289, "latitude": 41.05890327, "longitude": -111.91771414 },
{"id": 477689569958051842, "latitude": 32.2389299, "longitude": -82.4742658 },
{"id": 477975131432955904, "latitude": 40.272784, "longitude": -76.4388682 },
{"id": 477685984440483842, "latitude": 43.0258155, "longitude": -63.95460103 },
{"id": 478008926407888896, "latitude": 38.77914746, "longitude": -90.84552906 },
{"id": 477905139823439872, "latitude": 33.68180385, "longitude": -83.70442416 },
{"id": 477974987848945664, "latitude": 42.53526925, "longitude": -89.00805836 },
{"id": 477926503598915584, "latitude": 34.13708715, "longitude": -118.19883757 },
{"id": 477912631861600256, "latitude": 33.42076929, "longitude": -111.89644197 },
{"id": 477931221280759808, "latitude": 37.80407791, "longitude": -97.42378542 },
{"id": 477995918466494465, "latitude": 34.78536, "longitude": -84.29049214 },
{"id": 477917785687744513, "latitude": 42.49227535, "longitude": -83.06498246 },
{"id": 477848521379688448, "latitude": 39.95729031, "longitude": -82.87729983 },
{"id": 477884092592037888, "latitude": 41.1029498, "longitude": -96.2632202 },
{"id": 478004543964577792, "latitude": 35.3584555, "longitude": -118.9419798 },
{"id": 477782571338575872, "latitude": 40.75262931, "longitude": -73.96454583 },
{"id": 477703025273085952, "latitude": 40.73406911, "longitude": -73.98913616 },
{"id": 477850385218957313, "latitude": 36.02145973, "longitude": -115.04584417 },
{"id": 477696804117438464, "latitude": 36.82008078, "longitude": -79.35815811 },
{"id": 478014221868101632, "latitude": 42.30332615, "longitude": -71.06604786 },
{"id": 477987540532989954, "latitude": 40.9985147, "longitude": -73.6625676 },
{"id": 477997038190469120, "latitude": 35.74327395, "longitude": -78.80894506 },
{"id": 477927598212009984, "latitude": 33.97777343, "longitude": -117.63978576 },
{"id": 477901135986978816, "latitude": 30.2804815, "longitude": -97.5916354 },
{"id": 477825076641808385, "latitude": 41.6633483, "longitude": -72.7970243 },
{"id": 477963020488818688, "latitude": 34.0279153, "longitude": -81.0495523 },
{"id": 477962006050660352, "latitude": 42.2760525, "longitude": -83.7371931 },
{"id": 477886472654049280, "latitude": 45.45785305, "longitude": -73.88391371 },
{"id": 477941241405923328, "latitude": 36.3252727, "longitude": -119.2853102 },
{"id": 477821395896770561, "latitude": 42.06442604, "longitude": -72.51375533 },
{"id": 478000173617266688, "latitude": 41.90213216, "longitude": -87.68941599 },
{"id": 478030516365828096, "latitude": 45.01114859, "longitude": -93.17993584 },
{"id": 477892295128526848, "latitude": 31.9802205, "longitude": -81.1282672 },
{"id": 477722149050789888, "latitude": 40.5788972, "longitude": -124.1531515 },
{"id": 478036872804184064, "latitude": 41.53978015, "longitude": -82.74496501 },
{"id": 477857985562042368, "latitude": 34.05129333, "longitude": -118.44551518 },
{"id": 477956309493370880, "latitude": 40.44131579, "longitude": -79.75252542 },
{"id": 477999944020684801, "latitude": 31.565754, "longitude": -93.4679604 },
{"id": 477855636978671616, "latitude": 40.8290351, "longitude": -73.8708547 },
{"id": 477875705225547779, "latitude": 43.59498378, "longitude": -79.63495071 },
{"id": 477826739012648960, "latitude": 45.36749268, "longitude": -63.26566511 },
{"id": 477852569922842624, "latitude": 38.90377527, "longitude": -95.07549802 },
{"id": 477900745233424385, "latitude": 38.9375421, "longitude": -76.8653582 },
{"id": 477960113756848128, "latitude": 41.7241626, "longitude": -86.2862621 },
{"id": 478035142091743232, "latitude": 39.66848403, "longitude": -74.97448465 },
{"id": 477937643569704960, "latitude": 42.7612236, "longitude": -84.6011455 },
{"id": 477981869167112192, "latitude": 39.41689477, "longitude": -112.04119633 },
{"id": 477932452292624384, "latitude": 40.8016407, "longitude": -73.96458146 },
{"id": 477828413516820480, "latitude": 32.446395, "longitude": -81.79521189 },
{"id": 478005197550010368, "latitude": 42.66080952, "longitude": -83.01093682 },
{"id": 477862458233593857, "latitude": 33.62701309, "longitude": -116.19609073 },
{"id": 478025850244190209, "latitude": 38.0249385, "longitude": -121.2692275 },
{"id": 478015907525320704, "latitude": 36.00296147, "longitude": -84.05465191 },
{"id": 477868388467740672, "latitude": 39.27877864, "longitude": -76.5540912 },
{"id": 478008669427093504, "latitude": 40.92022351, "longitude": -81.11319998 },
{"id": 477836954583580673, "latitude": 40.02967814, "longitude": -105.28528816 },
{"id": 477892977935659010, "latitude": 30.13274593, "longitude": -85.21059028 },
{"id": 477819758856138752, "latitude": 35.8654932, "longitude": -80.83020725 },
{"id": 477970567337742336, "latitude": 42.1209816, "longitude": -86.4448199 },
{"id": 478011502298157056, "latitude": 41.35714627, "longitude": -71.82063027 },
{"id": 477967178713415681, "latitude": 38.9184209, "longitude": -75.4320446 },
{"id": 477939969709715456, "latitude": 40.28459332, "longitude": -73.98832278 },
{"id": 478013412983595009, "latitude": 33.6649998, "longitude": -117.98332926 },
{"id": 477692062188699648, "latitude": 40.77465125, "longitude": -81.44462724 },
{"id": 477841690909491200, "latitude": 40.66033578, "longitude": -74.21891073 },
{"id": 477931242001031169, "latitude": 40.94763417, "longitude": -74.01744001 },
{"id": 477689097222250496, "latitude": 38.42465473, "longitude": -78.86788293 },
{"id": 477948871570886657, "latitude": 43.2239656, "longitude": -70.64082961 },
{"id": 477986275245719552, "latitude": 39.62006841, "longitude": -74.62283981 },
{"id": 478023135451951104, "latitude": 30.07024112, "longitude": -82.18488372 },
{"id": 477921674612858880, "latitude": 32.7876578, "longitude": -97.2927821 },
{"id": 477984868434202624, "latitude": 30.3703089, "longitude": -87.17656047 },
{"id": 477992914044583939, "latitude": 41.43183868, "longitude": -81.88434938 },
{"id": 478004192091848704, "latitude": 40.72297742, "longitude": -73.62874718 },
{"id": 477860801240260609, "latitude": 40.60311741, "longitude": -74.1164178 },
{"id": 477908448575635457, "latitude": 38.90723, "longitude": -77.03646 },
{"id": 477750610884710400, "latitude": 36.21981122, "longitude": -115.27830704 },
{"id": 477849506508070912, "latitude": 47.67013065, "longitude": -117.21192836 },
{"id": 477810694029844480, "latitude": 39.18793704, "longitude": -77.2360181 },
{"id": 477804335342968832, "latitude": 40.75797231, "longitude": -84.14871152 },
{"id": 477762134231625728, "latitude": 38.56389577, "longitude": -90.23932911 },
{"id": 477861457233580033, "latitude": 41.7607942, "longitude": -72.5786939 },
{"id": 477863164609314816, "latitude": 39.98330946, "longitude": -74.90191153 },
{"id": 477892492201693184, "latitude": 38.8991, "longitude": -77.029 },
{"id": 477885272273977344, "latitude": 33.44147661, "longitude": -112.32643786 },
{"id": 478029728470007808, "latitude": 45.42561567, "longitude": -122.63202214 },
{"id": 477819673858174980, "latitude": 30.51889661, "longitude": -97.86986855 },
{"id": 477911583423602688, "latitude": 45.57933146, "longitude": -122.11746066 },
{"id": 478015512384110592, "latitude": 41.2123398, "longitude": -95.9605852 },
{"id": 477697263058157569, "latitude": 35.27988499, "longitude": -106.6787443 },
{"id": 477885770657566721, "latitude": 37.43760221, "longitude": -122.16855565 },
{"id": 478032820376330240, "latitude": 41.58117395, "longitude": -87.43612762 },
{"id": 477880676998733824, "latitude": 40.87303975, "longitude": -74.09579514 },
{"id": 477693276544180225, "latitude": 30.90952018, "longitude": -95.28666623 },
{"id": 478030723258286081, "latitude": 40.76852168, "longitude": -73.48983425 },
{"id": 477804919169118209, "latitude": 33.8783047, "longitude": -84.3049567 },
{"id": 477863507812032512, "latitude": 41.41113422, "longitude": -81.71346126 },
{"id": 477941768063700992, "latitude": 47.62774309, "longitude": -122.15105284 },
{"id": 478033930763792384, "latitude": 34.12235321, "longitude": -118.15340892 },
{"id": 477973543112568832, "latitude": 39.42576236, "longitude": -76.93263529 },
{"id": 477932768891244544, "latitude": 36.15721616, "longitude": -86.77653507 },
{"id": 477960791329501184, "latitude": 32.70511077, "longitude": -80.87004475 },
{"id": 477821007948812289, "latitude": 35.38283769, "longitude": -80.31561322 },
{"id": 478020227348037632, "latitude": 35.4705269, "longitude": -78.60037993 },
{"id": 477707911418744833, "latitude": 32.9195773, "longitude": -96.6785502 },
{"id": 477941510550216704, "latitude": 40.33157069, "longitude": -74.59944787 },
{"id": 477825651987062784, "latitude": 43.59777, "longitude": -79.62502 },
{"id": 477796926084382720, "latitude": 30.36764925, "longitude": -81.49484334 },
{"id": 477863819684106241, "latitude": 43.1242853, "longitude": -75.2157009 },
{"id": 477975783395581952, "latitude": 43.47977147, "longitude": -80.52413855 },
{"id": 477934425078894592, "latitude": 32.8546197, "longitude": -79.9748103 },
{"id": 478038123885391872, "latitude": 34.9873433, "longitude": -79.09165991 },
{"id": 477731655101075457, "latitude": 37.50232746, "longitude": -122.48263792 },
{"id": 477998751806533632, "latitude": 37.1835168, "longitude": -93.303003 },
{"id": 477862315287912449, "latitude": 41.1821897, "longitude": -73.1355297 },
{"id": 478030812701806592, "latitude": 32.077289, "longitude": -96.4898988 },
{"id": 477708916223000576, "latitude": 37.82562238, "longitude": -120.94786414 },
{"id": 477990233620086784, "latitude": 38.57201579, "longitude": -77.33096931 },
{"id": 478015341961166848, "latitude": 41.11509823, "longitude": -81.57664167 },
{"id": 477903259316027392, "latitude": 40.42165692, "longitude": -86.74859656 },
{"id": 477990401891377152, "latitude": 40.91099694, "longitude": -73.10071349 },
{"id": 477788380873633792, "latitude": 40.82240336, "longitude": -73.95443214 },
{"id": 478013152572211200, "latitude": 40.6813, "longitude": -73.9772 },
{"id": 478005085646364673, "latitude": 30.21870724, "longitude": -81.5149449 },
{"id": 477989136813817857, "latitude": 32.39123373, "longitude": -99.77180217 },
{"id": 477889579865743360, "latitude": 33.81061287, "longitude": -118.07017612 },
{"id": 477968103448801280, "latitude": 42.33012517, "longitude": -71.03232922 },
{"id": 478011808897593344, "latitude": 37.2640163, "longitude": -121.8688395 },
{"id": 477758509040144385, "latitude": 38.72438176, "longitude": -77.0773421 },
{"id": 477713114411335680, "latitude": 40.2420244, "longitude": -74.77220717 },
{"id": 478016024915099649, "latitude": 37.81640718, "longitude": -122.44062774 },
{"id": 477933552948891648, "latitude": 30.47023882, "longitude": -97.80704132 },
{"id": 477901679845588993, "latitude": 43.02468285, "longitude": -81.27731053 },
{"id": 477991212830318593, "latitude": 32.9091537, "longitude": -117.1731764 },
{"id": 478005940546183168, "latitude": 42.12469128, "longitude": -83.54129517 },
{"id": 477767496796090368, "latitude": 41.95549963, "longitude": -87.70617485 },
{"id": 477968094292238336, "latitude": 35.22967308, "longitude": -78.80528796 },
{"id": 477957278054637568, "latitude": 40.64573715, "longitude": -89.57805924 },
{"id": 477972195344265218, "latitude": 34.04119593, "longitude": -118.44737881 },
{"id": 477714057063968769, "latitude": 33.930932, "longitude": -118.0913633 },
{"id": 477737891519815680, "latitude": 38.47514735, "longitude": -121.34138185 },
{"id": 477882778688978944, "latitude": 35.31220342, "longitude": -80.72476877 },
{"id": 477845223918559232, "latitude": 41.4588129, "longitude": -71.44074403 },
{"id": 477996774209359872, "latitude": 33.2612596, "longitude": -93.306991 },
{"id": 477737627559272449, "latitude": 33.81986675, "longitude": -116.47563254 },
{"id": 477738480446238721, "latitude": 41.9436127, "longitude": -87.83394444 },
{"id": 477889879473262592, "latitude": 45.5382178, "longitude": -122.86769019 },
{"id": 477904181789859840, "latitude": 41.010881, "longitude": -92.8801369 },
{"id": 477696617244422144, "latitude": 30.217992, "longitude": -92.0194673 },
{"id": 478008342619914241, "latitude": 37.83817496, "longitude": -79.37187071 },
{"id": 477717547949641728, "latitude": 34.0433939, "longitude": -117.72152543 },
{"id": 477879088984502273, "latitude": 31.11159351, "longitude": -97.88321212 },
{"id": 478017561192574976, "latitude": 40.2521209, "longitude": -75.6058146 },
{"id": 477950322816466944, "latitude": 41.69450051, "longitude": -87.70955401 },
{"id": 477982616617250816, "latitude": 43.175325, "longitude": -79.2541103 },
{"id": 477944187170455552, "latitude": 35.1338855, "longitude": -117.941223 },
{"id": 477886190566141952, "latitude": 42.0123734, "longitude": -88.07639936 },
{"id": 477928693785198592, "latitude": 37.6141639, "longitude": -97.3670183 },
{"id": 477853453075902465, "latitude": 38.90873821, "longitude": -76.99758732 },
{"id": 477962970899546112, "latitude": 45.28657677, "longitude": -75.66564241 },
{"id": 477814423705645056, "latitude": 45.3998637, "longitude": -75.66678805 },
{"id": 477740444278095872, "latitude": 41.88214094, "longitude": -71.34648912 },
{"id": 478022723990745088, "latitude": 44.07194139, "longitude": -103.13581644 },
{"id": 477995647409610757, "latitude": 43.03833982, "longitude": -81.22934064 },
{"id": 477691017135542274, "latitude": 41.4306693, "longitude": -81.630174 },
{"id": 477924963878313984, "latitude": 37.0237967, "longitude": -100.9201474 },
{"id": 477850520213012480, "latitude": 41.4378804, "longitude": -72.22860553 },
{"id": 478031952168366081, "latitude": 43.03706829, "longitude": -87.96871257 },
{"id": 477857551615545344, "latitude": 32.7387327, "longitude": -117.0228189 },
{"id": 477916119332683776, "latitude": 32.51694447, "longitude": -117.11921814 },
{"id": 477853786761740290, "latitude": 40.72220649, "longitude": -73.9862584 },
{"id": 477935814576709632, "latitude": 32.14172888, "longitude": -110.93639367 },
{"id": 477854655574069248, "latitude": 33.7396304, "longitude": -118.2950553 },
{"id": 477683703771299840, "latitude": 33.48867669, "longitude": -112.00146217 },
{"id": 478003477835427841, "latitude": 40.70954468, "longitude": -74.07359789 },
{"id": 477854185648439296, "latitude": 41.38155478, "longitude": -72.89586907 },
{"id": 477882954698350592, "latitude": 43.636833, "longitude": -116.6081985 },
{"id": 477951531950424064, "latitude": 34.15367199, "longitude": -80.76188721 },
{"id": 477790307791409152, "latitude": 38.87639503, "longitude": -99.31503737 },
{"id": 477944770296164353, "latitude": 34.0173164, "longitude": -117.6820219 },
{"id": 477977320452419587, "latitude": 41.7005385, "longitude": -87.6606778 },
{"id": 477979783847227393, "latitude": 33.89193915, "longitude": -96.6522511 },
{"id": 477923446249500673, "latitude": 41.1753127, "longitude": -81.41732027 },
{"id": 477887439504412673, "latitude": 38.04439954, "longitude": -78.78617274 },
{"id": 478025282834952192, "latitude": 33.5942266, "longitude": -84.2738243 },
{"id": 478011246433017856, "latitude": 42.87697485, "longitude": -78.70296103 },
{"id": 477868623671721985, "latitude": 42.77767135, "longitude": -71.42280545 },
{"id": 477810941762228224, "latitude": 40.65748915, "longitude": -80.57481911 },
{"id": 477747449801363457, "latitude": 39.913157, "longitude": -104.9288839 },
{"id": 477986092466319360, "latitude": 43.93554472, "longitude": -78.87971814 },
{"id": 477860058873602048, "latitude": 35.66694346, "longitude": -80.56478172 },
{"id": 477942380424097794, "latitude": 40.83317205, "longitude": -73.85393995 },
{"id": 478026614555824128, "latitude": 40.1309557, "longitude": -74.9037905 },
{"id": 477964393276506112, "latitude": 32.7608, "longitude": -117.121 },
{"id": 477696199349125120, "latitude": 42.47716315, "longitude": -92.34704179 },
{"id": 477771163406319616, "latitude": 35.16295649, "longitude": -78.9732162 },
{"id": 477840693138698242, "latitude": 41.03906524, "longitude": -80.66457544 },
{"id": 478019806164422656, "latitude": 32.96934105, "longitude": -96.74958262 },
{"id": 477849680492384256, "latitude": 43.52657332, "longitude": -79.64547903 },
{"id": 477716495447756800, "latitude": 34.6813581, "longitude": -118.1055898 },
{"id": 477687590980964352, "latitude": 35.35639627, "longitude": -79.00794888 },
{"id": 477819300443463680, "latitude": 39.9684619, "longitude": -83.00041402 },
{"id": 477702458953584640, "latitude": 32.2013375, "longitude": -110.827568 },
{"id": 477816653929910275, "latitude": 34.19162767, "longitude": -118.44020981 },
{"id": 478010715010510848, "latitude": 34.74220988, "longitude": -86.7669327 },
{"id": 477883834776559616, "latitude": 39.3468812, "longitude": -76.5596071 },
{"id": 478037581695709184, "latitude": 33.65758858, "longitude": -118.00276822 },
{"id": 478041281038274560, "latitude": 48.45309628, "longitude": -123.36459617 },
{"id": 477736172538441729, "latitude": 42.8651071, "longitude": -85.6528495 },
{"id": 478016209212805120, "latitude": 30.5759031, "longitude": -91.20427019 },
{"id": 477853444930142209, "latitude": 37.76998675, "longitude": -97.4647456 },
{"id": 478024996791795712, "latitude": 42.76627488, "longitude": -78.60814929 },
{"id": 478038169221615616, "latitude": 41.77156029, "longitude": -87.62571596 },
{"id": 477685727468077057, "latitude": 45.40471588, "longitude": -122.49310428 },
{"id": 477916455078752256, "latitude": 41.31517201, "longitude": -74.12678395 },
{"id": 477679511803162626, "latitude": 38.57482443, "longitude": -76.08221595 },
{"id": 477866470173851650, "latitude": 41.54514269, "longitude": -72.04034147 },
{"id": 477887299942756352, "latitude": 34.11466223, "longitude": -81.19090891 },
{"id": 477912464169127937, "latitude": 41.75951836, "longitude": -87.57176657 },
{"id": 477990295108194304, "latitude": 37.69884034, "longitude": -121.93238089 },
{"id": 478016400326684672, "latitude": 40.69624563, "longitude": -73.30107922 },
{"id": 477924283625115648, "latitude": 47.00681646, "longitude": -124.17239897 },
{"id": 477936624827768833, "latitude": 42.03617491, "longitude": -87.67042538 },
{"id": 477871360312487936, "latitude": 34.1027228, "longitude": -118.1995752 },
{"id": 477691158873636864, "latitude": 36.1510926, "longitude": -115.2004735 },
{"id": 477893139605508096, "latitude": 41.50286778, "longitude": -74.02146667 },
{"id": 477917510285529088, "latitude": 44.79724076, "longitude": -122.78914221 },
{"id": 477923185749278720, "latitude": 42.48401275, "longitude": -76.49159806 },
{"id": 478039857370238976, "latitude": 35.87047468, "longitude": -80.08365866 },
{"id": 477682971533520898, "latitude": 38.08044418, "longitude": -89.3167345 },
{"id": 477870233882202113, "latitude": 43.041164, "longitude": -83.5834399 },
{"id": 477925631892549632, "latitude": 42.76294535, "longitude": -71.22246003 },
{"id": 477858304018751489, "latitude": 33.9615135, "longitude": -118.2883809 },
{"id": 477916047711154176, "latitude": 36.20008818, "longitude": -115.17241909 },
{"id": 477909862450343936, "latitude": 32.44381525, "longitude": -93.71638399 },
{"id": 478030819336802304, "latitude": 30.39736192, "longitude": -91.17470813 },
{"id": 477881840905121793, "latitude": 33.03875631, "longitude": -97.39374513 },
{"id": 477754937590300672, "latitude": 34.05206397, "longitude": -118.2616448 },
{"id": 477966891915677696, "latitude": 35.5667838, "longitude": -82.54394575 },
{"id": 478013844078333955, "latitude": 41.9831109, "longitude": -91.59026341 },
{"id": 477993642477760512, "latitude": 40.59777, "longitude": -74.69226215 },
{"id": 477687347060817924, "latitude": 33.8977067, "longitude": -98.5042951 },
{"id": 477823914920259584, "latitude": 41.26016555, "longitude": -72.79953241 },
{"id": 477995019698454528, "latitude": 42.737329, "longitude": -92.4881123 },
{"id": 477800972102541314, "latitude": 40.6233333, "longitude": -74.6011111 },
{"id": 477962680221704192, "latitude": 34.23598105, "longitude": -77.85883579 },
{"id": 477767820676452353, "latitude": 38.17036629, "longitude": -85.63743532 },
{"id": 478008619729190914, "latitude": 41.50861365, "longitude": -72.98477451 },
{"id": 477716576754360320, "latitude": 37.2415966, "longitude": -121.8484689 },
{"id": 477840701577650176, "latitude": 39.4521242, "longitude": -75.0488449 },
{"id": 478005517974253568, "latitude": 33.4171003, "longitude": -111.6210955 },
{"id": 478009964649119745, "latitude": 33.91826951, "longitude": -117.88256493 },
{"id": 477965746770042880, "latitude": 39.09991245, "longitude": -94.60176018 },
{"id": 477857351861403648, "latitude": 44.94000487, "longitude": -92.93281722 },
{"id": 477952241912254464, "latitude": 32.42628203, "longitude": -86.20760908 },
{"id": 478024331701026816, "latitude": 39.08744548, "longitude": -76.86650128 },
{"id": 477770132857835520, "latitude": 41.75770794, "longitude": -71.42729137 },
{"id": 477924786283106304, "latitude": 46.86711921, "longitude": -96.84652896 },
{"id": 477843614903447552, "latitude": 42.80845281, "longitude": -78.76962461 },
{"id": 477708258740674560, "latitude": 41.89273784, "longitude": -87.72024488 },
{"id": 477914770344267777, "latitude": 39.15904173, "longitude": -77.20414722 },
{"id": 477964851130548224, "latitude": 31.71240828, "longitude": -106.4482849 },
{"id": 477937141024952320, "latitude": 42.45694495, "longitude": -89.22906465 },
{"id": 478015216501145601, "latitude": 33.57948145, "longitude": -85.10373398 },
{"id": 477985687099408384, "latitude": 39.79673501, "longitude": -86.00981519 },
{"id": 477860109234606080, "latitude": 35.52395005, "longitude": -97.56630309 },
{"id": 477747057327738881, "latitude": 33.84282846, "longitude": -117.94108201 },
{"id": 478023553292705792, "latitude": 34.04695248, "longitude": -90.02603705 },
{"id": 477955056038207489, "latitude": 33.87835954, "longitude": -117.83692958 },
{"id": 478041277632905216, "latitude": 34.28390473, "longitude": -118.51120491 },
{"id": 477910848749305856, "latitude": 41.34215356, "longitude": -72.10550796 },
{"id": 477995958198755328, "latitude": 38.79301084, "longitude": -121.23871074 },
{"id": 477706808501338114, "latitude": 30.47900985, "longitude": -92.90025115 },
{"id": 478030357892456448, "latitude": 37.69917668, "longitude": -97.47653894 },
{"id": 478023027176009728, "latitude": 40.74186868, "longitude": -74.04647727 },
{"id": 477963219399479296, "latitude": 39.26622863, "longitude": -77.1584765 },
{"id": 477998036061147136, "latitude": 32.88563459, "longitude": -97.33560839 },
{"id": 477912981884657664, "latitude": 33.74022641, "longitude": -84.70629068 },
{"id": 478027407992324097, "latitude": 41.108509, "longitude": -83.347116 },
{"id": 478041162864136192, "latitude": 32.65148959, "longitude": -115.4999187 },
{"id": 477957656829632512, "latitude": 45.5086699, "longitude": -73.5539925 },
{"id": 477856046514720768, "latitude": 45.5098431, "longitude": -122.68378924 },
{"id": 478004514914844673, "latitude": 39.0902299, "longitude": -77.103741 },
{"id": 477860001621352448, "latitude": 40.15338078, "longitude": -74.60297452 },
{"id": 477711793427447810, "latitude": 32.4194548, "longitude": -96.8513628 },
{"id": 477952550662991872, "latitude": 32.43543331, "longitude": -94.79776416 },
{"id": 477959975524773889, "latitude": 47.10445093, "longitude": -122.29391904 },
{"id": 477700164438982656, "latitude": 40.72243155, "longitude": -73.98623118 },
{"id": 477743620389634048, "latitude": 37.274956, "longitude": -79.9637634 },
{"id": 477679442089607169, "latitude": 40.50911374, "longitude": -111.84612086 },
{"id": 478021184765063168, "latitude": 38.8303016, "longitude": -97.61020658 },
{"id": 477858561721376769, "latitude": 39.7424454, "longitude": -104.99491802 },
{"id": 477911797539028993, "latitude": 40.13503728, "longitude": -74.9131684 },
{"id": 477889891510939648, "latitude": 43.00628767, "longitude": -83.73350996 },
{"id": 477720496893870080, "latitude": 33.65960136, "longitude": -84.43571303 },
{"id": 477917667769061376, "latitude": 34.45822821, "longitude": -118.50055438 },
{"id": 478024704318787584, "latitude": 33.7664847, "longitude": -84.7595124 },
{"id": 477732570759589888, "latitude": 34.43249778, "longitude": -118.42297553 },
{"id": 478010941204746240, "latitude": 32.77298747, "longitude": -96.98846972 },
{"id": 477868392469106688, "latitude": 41.95114492, "longitude": -87.88181458 },
{"id": 477966865994506240, "latitude": 41.5512921, "longitude": -88.2806752 },
{"id": 477976831485038592, "latitude": 33.62748856, "longitude": -78.9526619 },
{"id": 477684294773522432, "latitude": 36.6986593, "longitude": -121.6025838 },
{"id": 478008781897732097, "latitude": 32.843048, "longitude": -96.8272482 },
{"id": 477954250115260416, "latitude": 40.70244742, "longitude": -75.27373431 },
{"id": 478033040091152384, "latitude": 39.75692511, "longitude": -81.53793859 },
{"id": 477728979927842817, "latitude": 45.52719744, "longitude": -122.94230431 },
{"id": 477819040644096001, "latitude": 39.29668573, "longitude": -76.58678646 },
{"id": 477844382117134336, "latitude": 33.44276078, "longitude": -84.57155756 },
{"id": 477924519592464384, "latitude": 37.7726402, "longitude": -122.4099154 },
{"id": 477940923746484225, "latitude": 40.8214923, "longitude": -81.3899254 },
{"id": 477698358543257601, "latitude": 32.41622572, "longitude": -94.84791267 },
{"id": 477876950808002561, "latitude": 34.1194691, "longitude": -117.35745563 },
{"id": 477909274358976512, "latitude": 42.8017377, "longitude": -78.75619718 },
{"id": 477963468776439809, "latitude": 42.96423859, "longitude": -85.90598739 },
{"id": 477960784002048001, "latitude": 30.0947594, "longitude": -91.00207245 },
{"id": 477873129964838912, "latitude": 47.04139972, "longitude": -122.75340633 },
{"id": 477991720098209792, "latitude": 42.3502948, "longitude": -83.0432386 },
{"id": 478036007682445312, "latitude": 30.06969858, "longitude": -95.41653706 },
{"id": 477856328455430145, "latitude": 42.3636786, "longitude": -71.0825397 },
{"id": 478032275263610880, "latitude": 47.40179034, "longitude": -120.30655878 },
{"id": 477933223486300160, "latitude": 32.5167246, "longitude": -91.99739536 },
{"id": 477946181080059904, "latitude": 43.0710258, "longitude": -87.9487872 },
{"id": 477926910694281216, "latitude": 40.82611802, "longitude": -73.90181919 },
{"id": 477990376356462592, "latitude": 39.6334668, "longitude": -77.7348643 },
{"id": 477973887506849792, "latitude": 41.1217245, "longitude": -84.90149592 },
{"id": 477948867657605120, "latitude": 34.49973776, "longitude": -79.30923652 },
{"id": 477834556171505664, "latitude": 36.0020179, "longitude": -95.67961404 },
{"id": 477865199177699329, "latitude": 35.22621056, "longitude": -81.11057606 },
{"id": 477983507780608000, "latitude": 42.606919, "longitude": -113.1684622 },
{"id": 477975492713144321, "latitude": 42.19833512, "longitude": -71.06179655 },
{"id": 477888701801197568, "latitude": 33.4424075, "longitude": -117.61417128 },
{"id": 477720011398590464, "latitude": 39.7814417, "longitude": -105.0225835 },
{"id": 477891592972288000, "latitude": 40.02603788, "longitude": -75.05705919 },
{"id": 477697557435801600, "latitude": 40.15909351, "longitude": -74.05171512 },
{"id": 477975657683877888, "latitude": 47.22563807, "longitude": -122.35665939 },
{"id": 478002488873078785, "latitude": 40.11960513, "longitude": -80.70100693 },
{"id": 477983023804469248, "latitude": 40.64577187, "longitude": -73.71330374 },
{"id": 477714883832594432, "latitude": 32.80656637, "longitude": -96.65052571 },
{"id": 477871405040541697, "latitude": 42.99716276, "longitude": -88.05263353 },
{"id": 477926044104933376, "latitude": 41.82953787, "longitude": -71.40081526 },
{"id": 477871086722621440, "latitude": 42.31362257, "longitude": -71.20639926 },
{"id": 477961246054944768, "latitude": 40.73896145, "longitude": -73.05441199 },
{"id": 477983102372167680, "latitude": 40.67926549, "longitude": -73.92797102 },
{"id": 478002474323038209, "latitude": 40.4374619, "longitude": -74.5494219 },
{"id": 477994938345340929, "latitude": 33.60248588, "longitude": -112.34146812 },
{"id": 477801517228240896, "latitude": 35.24043842, "longitude": -81.03893988 },
{"id": 477973721362489344, "latitude": 44.96280289, "longitude": -93.23324585 },
{"id": 477990537069613056, "latitude": 43.24215108, "longitude": -79.81596828 },
{"id": 478002927010062336, "latitude": 35.61324251, "longitude": -82.31902975 },
{"id": 478012769501859841, "latitude": 35.89629587, "longitude": -86.88264498 },
{"id": 478025408907317248, "latitude": 37.9653027, "longitude": -87.5516888 },
{"id": 477807251693264896, "latitude": 40.63413534, "longitude": -73.90717847 },
{"id": 477859458891018240, "latitude": 40.5253497, "longitude": -91.4328378 },
{"id": 478006701913018368, "latitude": 40.14677329, "longitude": -74.93967039 },
{"id": 477840434669318144, "latitude": 33.55755365, "longitude": -81.71889561 },
{"id": 477854415232040960, "latitude": 33.18732265, "longitude": -97.1065687 },
{"id": 477954491971428352, "latitude": 41.6914339, "longitude": -87.53504017 },
{"id": 477806120350666752, "latitude": 42.44354127, "longitude": -83.31779831 },
{"id": 477783357825110016, "latitude": 40.2080235, "longitude": -111.6255726 },
{"id": 478008050272731138, "latitude": 34.8192, "longitude": -82.388 },
{"id": 477938688924450816, "latitude": 42.4165811, "longitude": -83.3101361 },
{"id": 478034095050858496, "latitude": 41.75987336, "longitude": -111.84427139 },
{"id": 477723591794884608, "latitude": 34.0653631, "longitude": -117.2532082 },
{"id": 477811111149178880, "latitude": 30.32773106, "longitude": -81.48687364 },
{"id": 477895351873966080, "latitude": 41.24210627, "longitude": -95.8219624 },
{"id": 477996740415881217, "latitude": 41.80071839, "longitude": -72.55130558 },
{"id": 477940500021133312, "latitude": 44.17862722, "longitude": -77.41224383 },
{"id": 477724116602986499, "latitude": 41.0927125, "longitude": -85.4343322 },
{"id": 477887499453595648, "latitude": 38.91615253, "longitude": -75.89677619 },
{"id": 477968687430107136, "latitude": 41.84982196, "longitude": -71.40216124 },
{"id": 477925793470099457, "latitude": 33.58646392, "longitude": -84.39121322 },
{"id": 477898035230691328, "latitude": 40.6049826, "longitude": -79.1846658 },
{"id": 477835240111890432, "latitude": 40.7011283, "longitude": -90.0089104 },
{"id": 477815141296119809, "latitude": 38.63838031, "longitude": -121.2712777 },
{"id": 478005500210974722, "latitude": 34.03253355, "longitude": -118.4896273 },
{"id": 477958633594957824, "latitude": 41.39304201, "longitude": -72.9136892 },
{"id": 477838145921515521, "latitude": 40.76320209, "longitude": -74.17583584 },
{"id": 478004679692279810, "latitude": 33.6401662, "longitude": -84.3372063 },
{"id": 477819837368893440, "latitude": 33.4583179, "longitude": -82.0681424 },
{"id": 477844257227567106, "latitude": 35.03626327, "longitude": -118.97661477 },
{"id": 477882675303174144, "latitude": 39.77915782, "longitude": -104.9859512 },
{"id": 477906480222720000, "latitude": 37.01337632, "longitude": -76.37305118 },
{"id": 477829276793053184, "latitude": 42.01377447, "longitude": -87.66851933 },
{"id": 477925715225362432, "latitude": 39.65587234, "longitude": -79.77051998 },
{"id": 477784793560535041, "latitude": 42.58400455, "longitude": -71.98178703 },
{"id": 477702252757389312, "latitude": 33.48361571, "longitude": -112.07901583 },
{"id": 478008266971025408, "latitude": 33.88478306, "longitude": -117.51252243 },
{"id": 477843028682764288, "latitude": 32.8295, "longitude": -79.8238 },
{"id": 477719445989629952, "latitude": 39.13642633, "longitude": -121.62002665 },
{"id": 478028170835554304, "latitude": 34.23172432, "longitude": -118.40395544 },
{"id": 477953530020392961, "latitude": 42.14138336, "longitude": -72.56764529 },
{"id": 478007826972172288, "latitude": 39.09499641, "longitude": -77.07362917 },
{"id": 477977897870053376, "latitude": 39.41825322, "longitude": -84.47142944 },
{"id": 477954762592120832, "latitude": 32.9090117, "longitude": -96.8523687 },
{"id": 477927083444674560, "latitude": 30.32986394, "longitude": -91.769592 },
{"id": 478036451980886016, "latitude": 32.68202073, "longitude": -97.39411541 },
{"id": 477973586712330240, "latitude": 41.92864493, "longitude": -71.92469909 },
{"id": 478041131222327296, "latitude": 34.12048335, "longitude": -117.98989152 },
{"id": 477967274209337345, "latitude": 32.6880722, "longitude": -96.7976064 },
{"id": 477703727394979842, "latitude": 34.14178794, "longitude": -118.67441005 },
{"id": 477906800998502400, "latitude": 34.03123283, "longitude": -117.79037458 },
{"id": 477970674544562176, "latitude": 34.26844206, "longitude": -119.27291036 },
{"id": 477873142254166016, "latitude": 30.10688223, "longitude": -90.94209893 },
{"id": 478011481858912256, "latitude": 30.10497337, "longitude": -97.30787269 },
{"id": 477917886875316224, "latitude": 30.50160009, "longitude": -97.73208464 },
{"id": 477926403858395136, "latitude": 32.74026482, "longitude": -117.21180668 },
{"id": 477822634558636032, "latitude": 30.18794223, "longitude": -85.69237506 },
{"id": 477957132927524864, "latitude": 45.53165125, "longitude": -122.69481906 },
{"id": 477694208933765121, "latitude": 40.41708476, "longitude": -80.1853684 },
{"id": 477696484549226496, "latitude": 34.03418203, "longitude": -117.49746506 },
{"id": 477980577417920512, "latitude": 39.7197945, "longitude": -104.9521158 },
{"id": 477888410330222592, "latitude": 40.4376735, "longitude": -79.2165495 },
{"id": 477697126273540097, "latitude": 33.938555, "longitude": -117.2319921 },
{"id": 477689447668920320, "latitude": 38.727564, "longitude": -75.1298873 },
{"id": 477905828755034112, "latitude": 40.7397292, "longitude": -81.3666992 },
{"id": 477941128931852288, "latitude": 33.7361958, "longitude": -84.3887742 },
{"id": 477753835423662080, "latitude": 40.38952284, "longitude": -90.16216108 },
{"id": 477967126079475713, "latitude": 40.83688459, "longitude": -74.11455852 },
{"id": 477716779125329920, "latitude": 40.7495269, "longitude": -73.9712674 },
{"id": 477791726942175232, "latitude": 32.7074448, "longitude": -96.7870214 },
{"id": 477711858862813184, "latitude": 46.5978252, "longitude": -120.576959 },
{"id": 477892270515965953, "latitude": 34.0268538, "longitude": -117.3384829 },
{"id": 477783612226420736, "latitude": 39.44644772, "longitude": -91.04822899 },
{"id": 477831426318942209, "latitude": 35.28009677, "longitude": -107.98213935 },
{"id": 478041225162141696, "latitude": 34.47871388, "longitude": -86.89536778 },
{"id": 477988571304169473, "latitude": 40.75040383, "longitude": -74.40576215 },
{"id": 477855872459104256, "latitude": 38.92446732, "longitude": -77.05472959 },
{"id": 477984863732367361, "latitude": 30.5197895, "longitude": -96.7094647 },
{"id": 477689131200294913, "latitude": 33.62165248, "longitude": -112.11514998 },
{"id": 477912062031446016, "latitude": 36.08939892, "longitude": -115.17462273 },
{"id": 477901235841142785, "latitude": 33.10726278, "longitude": -83.24583053 },
{"id": 477844275795742720, "latitude": 30.5150136, "longitude": -81.6355519 },
{"id": 477887332159213568, "latitude": 42.1335245, "longitude": -72.7850529 },
{"id": 477855918592237568, "latitude": 45.5019451, "longitude": -122.4853043 },
{"id": 477851789362864129, "latitude": 32.82051881, "longitude": -96.86759971 },
{"id": 477994057319587840, "latitude": 43.0753188, "longitude": -89.51751349 },
{"id": 478005623448428544, "latitude": 34.75272293, "longitude": -92.23983077 },
{"id": 477872114859798531, "latitude": 40.65796667, "longitude": -74.27705191 },
{"id": 477924070890037248, "latitude": 33.85588318, "longitude": -118.00228986 },
{"id": 477935310454947840, "latitude": 33.59552389, "longitude": -84.09271642 },
{"id": 477861992695611392, "latitude": 43.73021231, "longitude": -79.40181142 },
{"id": 478025276304007168, "latitude": 34.11130425, "longitude": -117.64576051 },
{"id": 477810914922471424, "latitude": 41.82315735, "longitude": -72.52744732 },
{"id": 477843859485900800, "latitude": 41.45753493, "longitude": -83.36714118 },
{"id": 478021090082820096, "latitude": 35.99637568, "longitude": -79.99050989 },
{"id": 477980374044540930, "latitude": 38.944052, "longitude": -78.465815 },
{"id": 477682314131288064, "latitude": 40.80077946, "longitude": -73.41087178 },
{"id": 477833283036672000, "latitude": 39.1136334, "longitude": -94.6369857 },
{"id": 477949820611461122, "latitude": 33.88167628, "longitude": -117.8960245 },
{"id": 478011817072263168, "latitude": 39.28281407, "longitude": -76.59813163 },
{"id": 477851194849636352, "latitude": 35.39877529, "longitude": -118.9684969 },
{"id": 477997898701864960, "latitude": 36.0129276, "longitude": -86.6807238 },
{"id": 477720493584158721, "latitude": 41.13093839, "longitude": -81.81031667 },
{"id": 477906146012176384, "latitude": 44.6621051, "longitude": -74.9784274 },
{"id": 477920544290271233, "latitude": 40.8623029, "longitude": -73.0332399 },
{"id": 478004379803725824, "latitude": 33.37761959, "longitude": -84.71721249 },
{"id": 477793226112634880, "latitude": 36.6564542, "longitude": -88.3010575 },
{"id": 478013038117666817, "latitude": 33.62878737, "longitude": -111.93749333 },
{"id": 477836074363133952, "latitude": 45.5025344, "longitude": -73.5708159 },
{"id": 478022542629040128, "latitude": 34.8789039, "longitude": -82.4430189 },
{"id": 477898419466682368, "latitude": 42.11699562, "longitude": -83.19813159 },
{"id": 477873989617197056, "latitude": 41.31619857, "longitude": -81.44647921 },
{"id": 477969499602554880, "latitude": 43.64605975, "longitude": -79.3797935 },
{"id": 477973853738516480, "latitude": 35.5234805, "longitude": -84.38886032 },
{"id": 478024849835950080, "latitude": 40.45316773, "longitude": -80.21897715 },
{"id": 477680233374420992, "latitude": 34.74291954, "longitude": -87.64059694 },
{"id": 477823275440287745, "latitude": 43.228417, "longitude": -79.85119742 },
{"id": 478027773068718081, "latitude": 49.25255586, "longitude": -123.07894142 },
{"id": 477934186381058050, "latitude": 33.8654823, "longitude": -117.2111045 },
{"id": 477857964414357505, "latitude": 41.88229886, "longitude": -87.90562197 },
{"id": 477994394813857792, "latitude": 32.74188459, "longitude": -117.09981393 },
{"id": 477793630397026304, "latitude": 41.4419019, "longitude": -81.7435831 },
{"id": 477986871302447104, "latitude": 39.95852396, "longitude": -75.27872297 },
{"id": 478026948023574529, "latitude": 39.83968504, "longitude": -99.9001437 },
{"id": 477916959712235520, "latitude": 40.0088029, "longitude": -82.7768254 },
{"id": 478013684841988096, "latitude": 37.37141468, "longitude": -121.92255526 },
{"id": 477908431010267138, "latitude": 38.89468451, "longitude": -77.45109956 },
{"id": 478032577807134720, "latitude": 37.70018133, "longitude": -121.44848855 },
{"id": 477805900095582209, "latitude": 40.11039718, "longitude": -74.06970781 },
{"id": 478012775974055936, "latitude": 41.61943017, "longitude": -88.14623056 },
{"id": 477953238474309632, "latitude": 41.99041229, "longitude": -87.69814926 },
{"id": 477806316656660481, "latitude": 38.30754116, "longitude": -77.51818604 },
{"id": 477860735578435585, "latitude": 35.55063937, "longitude": -97.58282271 },
{"id": 477942762483228672, "latitude": 40.8396522, "longitude": -73.93923139 },
{"id": 477714135522615296, "latitude": 36.73053603, "longitude": -119.80986192 },
{"id": 478037506349608960, "latitude": 37.7251852, "longitude": -88.9384973 },
{"id": 477952816695103488, "latitude": 42.76152052, "longitude": -71.08420894 },
{"id": 477854562578362368, "latitude": 40.68058839, "longitude": -75.24127435 },
{"id": 477984993197977600, "latitude": 33.75762427, "longitude": -84.3964286 },
{"id": 477939743108251648, "latitude": 36.63098019, "longitude": -79.38030797 },
{"id": 477954217907613696, "latitude": 38.93184447, "longitude": -74.92381211 },
{"id": 477803926255710208, "latitude": 38.5969689, "longitude": -90.2731818 },
{"id": 477967556586659840, "latitude": 33.92608706, "longitude": -98.51359251 },
{"id": 477970234021019648, "latitude": 40.68637425, "longitude": -73.90854918 },
{"id": 477843735225438208, "latitude": 31.84989614, "longitude": -106.45189301 },
{"id": 477752054488641536, "latitude": 30.30301411, "longitude": -87.42596473 },
{"id": 478026144474607617, "latitude": 41.8827041, "longitude": -87.7715596 },
{"id": 477682604641361920, "latitude": 34.9987219, "longitude": -82.42219454 },
{"id": 477695238212182016, "latitude": 42.2244245, "longitude": -83.61281745 },
{"id": 477894607175307264, "latitude": 36.33875623, "longitude": -88.86574467 },
{"id": 477804307698290690, "latitude": 43.6608713, "longitude": -79.3659713 },
{"id": 477871744934760450, "latitude": 40.8852769, "longitude": -74.67702735 },
{"id": 477684267950960643, "latitude": 33.43275104, "longitude": -112.3261626 },
{"id": 477892037283680256, "latitude": 40.97347298, "longitude": -75.2618311 },
{"id": 478029780928180224, "latitude": 42.9708326, "longitude": -75.0126497 },
{"id": 477949881198608384, "latitude": 43.18174345, "longitude": -77.591468 },
{"id": 477943278826819585, "latitude": 43.7137289, "longitude": -79.5555322 },
{"id": 477946972528050177, "latitude": 41.58564898, "longitude": -87.6023239 },
{"id": 477940846596091904, "latitude": 36.7336596, "longitude": -79.3059087 },
{"id": 477719049434968064, "latitude": 33.6495332, "longitude": -117.96801701 },
{"id": 477967500144283648, "latitude": 40.84373164, "longitude": -74.09780695 },
{"id": 477946332976394241, "latitude": 41.23336131, "longitude": -95.8790523 },
{"id": 478008454247100416, "latitude": 41.7617374, "longitude": -88.293187 },
{"id": 477954034519642113, "latitude": 41.26713079, "longitude": -95.93170381 },
{"id": 477889770832396288, "latitude": 49.27676626, "longitude": -123.1326484 },
{"id": 477685614783893504, "latitude": 40.3044062, "longitude": -75.1276489 },
{"id": 477919715914821632, "latitude": 30.4786801, "longitude": -87.3227319 },
{"id": 477850362846937089, "latitude": 33.58379679, "longitude": -84.45362401 },
{"id": 477941774317395968, "latitude": 33.80483188, "longitude": -117.91881316 },
{"id": 478014367326535681, "latitude": 36.17812821, "longitude": -115.32341822 },
{"id": 477875100574679040, "latitude": 37.36012256, "longitude": -121.9757628 },
{"id": 478025741482094592, "latitude": 42.64122123, "longitude": -83.46136668 },
{"id": 477855769728393217, "latitude": 30.18438814, "longitude": -81.73379097 },
{"id": 477994122393837568, "latitude": 30.15434874, "longitude": -95.60582036 },
{"id": 477959765834739712, "latitude": 38.31544291, "longitude": -122.30854237 },
{"id": 477723331223764992, "latitude": 38.27284239, "longitude": -121.29270564 },
{"id": 477788639951220736, "latitude": 32.96598732, "longitude": -96.80743613 },
{"id": 478004281325273088, "latitude": 34.4871683, "longitude": -97.1922675 },
{"id": 477708480204525568, "latitude": 44.03792567, "longitude": -75.82617412 },
{"id": 478008199933865985, "latitude": 34.39983983, "longitude": -87.7525427 },
{"id": 477883273939787776, "latitude": 38.98202363, "longitude": -84.52590887 },
{"id": 477828565460078592, "latitude": 39.2526838, "longitude": -84.6098216 },
{"id": 477865378777796608, "latitude": 33.64324854, "longitude": -117.80347672 },
{"id": 477955362469842944, "latitude": 44.90860924, "longitude": -93.72830423 },
{"id": 478000187361988608, "latitude": 39.2054555, "longitude": -76.6535671 },
{"id": 477778253315596288, "latitude": 42.18900695, "longitude": -70.93179448 },
{"id": 477986871143067648, "latitude": 36.00283739, "longitude": -75.66161066 },
{"id": 477931410368376832, "latitude": 45.5318, "longitude": -122.896 },
{"id": 477781295372967937, "latitude": 35.01579945, "longitude": -86.56565164 },
{"id": 478038660558757888, "latitude": 34.01759414, "longitude": -118.30016276 },
{"id": 477949836688236544, "latitude": 33.9344579, "longitude": -118.1881266 },
{"id": 477977623604514816, "latitude": 36.11835959, "longitude": -115.17045021 },
{"id": 478026078015873024, "latitude": 41.90258434, "longitude": -87.62852383 },
{"id": 477964431234985984, "latitude": 38.4805033, "longitude": -78.0207609 },
{"id": 477690680941109248, "latitude": 33.82966035, "longitude": -98.67529942 },
{"id": 477845578064211968, "latitude": 33.76055869, "longitude": -118.13591499 },
{"id": 477695600469630976, "latitude": 35.307094, "longitude": -80.7062965 },
{"id": 477830707088474112, "latitude": 38.6541194, "longitude": -77.27384458 },
{"id": 477992147501973504, "latitude": 39.52879318, "longitude": -119.81734248 },
{"id": 477700243199238144, "latitude": 34.174836, "longitude": -118.2732806 },
{"id": 477975893936066561, "latitude": 33.04736756, "longitude": -96.74070298 },
{"id": 477987295061344256, "latitude": 41.41786502, "longitude": -81.57343118 },
{"id": 477892902677676032, "latitude": 40.84411022, "longitude": -73.85532408 },
{"id": 477697601945341952, "latitude": 36.82010193, "longitude": -79.35816579 }
]);

// --------- Run the spatial join query

use SJTest;

SELECT States.name, POIS.id
FROM States, POIS
WHERE st_contains(States.boundary, st_make_point(POIS.longitude, POIS.latitude));