-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathbootstrap.py
602 lines (594 loc) · 52.5 KB
/
bootstrap.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
from __future__ import print_function
from flask import Flask
import psycopg2
import psycopg2.extras
table_sql = """
CREATE TABLE points_of_interest
(
gid SERIAL NOT NULL,
name CHARACTER VARYING(240),
the_geom GEOMETRY,
CONSTRAINT points_of_interest_pkey PRIMARY KEY (gid),
CONSTRAINT enforce_dims_geom CHECK (st_ndims(the_geom) = 2),
CONSTRAINT enforce_geotype_geom CHECK (geometrytype(the_geom) = 'POINT'::TEXT OR the_geom IS NULL),
CONSTRAINT enforce_srid_geom CHECK (st_srid(the_geom) = 4326)
)
WITH (
OIDS=FALSE
);
CREATE INDEX points_of_interest_geom_gist
ON points_of_interest
USING GIST
(the_geom);
"""
def bootstrap():
app = Flask(__name__)
app.config.from_pyfile('config.cfg')
pg_host = app.config['PG_DB_HOST']
pg_port = app.config['PG_DB_PORT']
pg_name = app.config['PG_DB_NAME']
pg_username = app.config['PG_DB_USERNAME']
pg_password = app.config['PG_DB_PASSWORD']
conn = psycopg2.connect(host=pg_host, port=pg_port, database=pg_name, user=pg_username, password=pg_password)
cur = conn.cursor()
try:
cur.execute("CREATE EXTENSION postgis;")
cur.execute(table_sql)
for d in insert_data:
cur.execute("INSERT INTO points_of_interest (name, the_geom) VALUES (" + d + ")")
conn.commit()
finally:
cur.close()
conn.close()
print("Finished bootstrapping")
insert_data = [
"'Abraham Lincoln Birthplace National Historical Park', ST_GeomFromText('POINT(-85.7302 37.5332)', 4326)",
"'Abraham Lincoln National Cemetery', ST_GeomFromText('POINT(-88.12595 41.3896)', 4326)",
"'Acadia National Park', ST_GeomFromText('POINT(-68.04902 44.454)', 4326)",
"'Adams National Historical Park', ST_GeomFromText('POINT(-71.01119 42.25639)', 4326)",
"'Admiralty Island National Monument', ST_GeomFromText('POINT(-134.16105 57.61806)', 4326)",
"'African American Civil War Memorial', ST_GeomFromText('POINT(-77.02569 38.91639)', 4326)",
"'African Burial Ground National Monument', ST_GeomFromText('POINT(-73.99364 40.71367)', 4326)",
"'Agate Fossil Beds National Monument', ST_GeomFromText('POINT(-103.75492 42.42428)', 4326)",
"'Agua Fria National Monument', ST_GeomFromText('POINT(-112.07633 34.15417)', 4326)",
"'AIDS Memorial Grove', ST_GeomFromText('POINT(-122.46122 37.77)', 4326)",
"'Ala Kahakai National Historic Trail', ST_GeomFromText('POINT(-155.68106 18.91111)', 4326)",
"'Alagnak River', ST_GeomFromText('POINT(-156.79582 59.01063)', 4326)",
"'Aleutian World War II National Historic Area', ST_GeomFromText('POINT(-166.52692 53.88889)', 4326)",
"'Alibates Flint Quarries National Monument', ST_GeomFromText('POINT(-101.66722 35.57139)', 4326)",
"'Allegheny Portage Railroad', ST_GeomFromText('POINT(-78.5401 40.45417)', 4326)",
"'American Memorial Park', ST_GeomFromText('POINT(145.71691 15.2181)', 4326)",
"'Amistad National Recreation Area', ST_GeomFromText('POINT(-101.04972 29.43667)', 4326)",
"'Anacostia Park', ST_GeomFromText('POINT(-76.89998 38.8)', 4326)",
"'Andersonville National Cemetery', ST_GeomFromText('POINT(-84.13093 32.20358)', 4326)",
"'Andersonville National Historic Site', ST_GeomFromText('POINT(-84.12686 32.19759)', 4326)",
"'Andrew Johnson National Cemetery', ST_GeomFromText('POINT(-82.83763 36.15527)', 4326)",
"'Andrew Johnson National Historic Site', ST_GeomFromText('POINT(-82.83482 36.15833)', 4326)",
"'Aniakchak National Monument and Preserve', ST_GeomFromText('POINT(-158.14972 56.9)', 4326)",
"'Antietam National Battlefield', ST_GeomFromText('POINT(-77.73945 39.4803)', 4326)",
"'Antietam National Cemetery', ST_GeomFromText('POINT(-77.73904 39.47914)', 4326)",
"'Apostle Islands National Lakeshore', ST_GeomFromText('POINT(-90.66402 46.96528)', 4326)",
"'Appomattox Court House National Historical Park', ST_GeomFromText('POINT(-78.80083 37.37845)', 4326)",
"'Arches National Park', ST_GeomFromText('POINT(-109.56462 38.77)', 4326)",
"'Arkansas Post National Memorial', ST_GeomFromText('POINT(-91.34347 34.02361)', 4326)",
"'Arlington House The Robert E. Lee Memorial', ST_GeomFromText('POINT(-77.07389 38.88275)', 4326)",
"'Arlington National Cemetery', ST_GeomFromText('POINT(-77.07122 38.87657)', 4326)",
"'Assateague Island National Seashore', ST_GeomFromText('POINT(-75.20818 38.08332)', 4326)",
"'Aulavik National Park', ST_GeomFromText('POINT(-119.74092 74.02249)', 4326)",
"'Auyuittuq National Park', ST_GeomFromText('POINT(-65.01638 67.88333)', 4326)",
"'Aztec Ruins National Monument', ST_GeomFromText('POINT(-107.99782 36.83583)', 4326)",
"'Badlands National Park', ST_GeomFromText('POINT(-102.43392 43.6504)', 4326)",
"'Bandelier National Monument', ST_GeomFromText('POINT(-106.32082 35.77888)', 4326)",
"'Banff National Park', ST_GeomFromText('POINT(-115.54962 51.16666)', 4326)",
"'Battleground National Cemetery', ST_GeomFromText('POINT(-73.96286 40.81333)', 4326)",
"'Benjamin Franklin National Memorial', ST_GeomFromText('POINT(-75.17286 39.95832)', 4326)",
"'Bent''s Old Fort National Historic Site', ST_GeomFromText('POINT(-103.42502 38.04045)', 4326)",
"'Bering Land Bridge National Preserve', ST_GeomFromText('POINT(-164.80842 66.05595)', 4326)",
"'Big Bend National Park', ST_GeomFromText('POINT(-103.06042 29.81874)', 4326)",
"'Big Cypress National Preserve', ST_GeomFromText('POINT(-81.0337 25.85889)', 4326)",
"'Big Hole National Battlefield', ST_GeomFromText('POINT(-113.64332 45.6375)', 4326)",
"'Big South Fork National River and Recreation Area', ST_GeomFromText('POINT(-84.69835 36.4865)', 4326)",
"'Big Thicket National Preserve', ST_GeomFromText('POINT(-94.41082 30.27567)', 4326)",
"'Bighorn Canyon National Recreation Area', ST_GeomFromText('POINT(-108.13032 45.19444)', 4326)",
"'Biscayne National Park', ST_GeomFromText('POINT(-80.26162 25.442)', 4326)",
"'Black Canyon of the Gunnison National Park', ST_GeomFromText('POINT(-107.72792 38.58491)', 4326)",
"'Blue Ridge Parkway', ST_GeomFromText('POINT(-80.93578 36.51861)', 4326)",
"'Bluestone National Scenic River', ST_GeomFromText('POINT(-80.99901 37.54167)', 4326)",
"'Booker T. Washington National Monument', ST_GeomFromText('POINT(-79.76564 37.12333)', 4326)",
"'Boston African American National Historic Site', ST_GeomFromText('POINT(-71.06454 42.36)', 4326)",
"'Boston Harbor Islands National Recreation Area', ST_GeomFromText('POINT(-70.94565 42.31861)', 4326)",
"'Boston National Historical Park', ST_GeomFromText('POINT(-71.05617 42.36)', 4326)",
"'Brices Cross Roads National Battlefield Site', ST_GeomFromText('POINT(-88.7284 34.50672)', 4326)",
"'Brown v. Board of Education National Historic Site', ST_GeomFromText('POINT(-95.67621 39.03806)', 4326)",
"'Bruce Peninsula National Park', ST_GeomFromText('POINT(-81.61388 45.23888)', 4326)",
"'Bryce Canyon National Park', ST_GeomFromText('POINT(-112.19632 37.5548)', 4326)",
"'Buck Island Reef National Monument', ST_GeomFromText('POINT(-64.61897 17.78694)', 4326)",
"'Buffalo National River', ST_GeomFromText('POINT(-92.42606 36.17806)', 4326)",
"'Cabrillo National Monument', ST_GeomFromText('POINT(-117.24202 32.67352)', 4326)",
"'California Coastal National Monument', ST_GeomFromText('POINT(-122.17994 36.89)', 4326)",
"'Canaveral National Seashore', ST_GeomFromText('POINT(-80.77679 28.7675)', 4326)",
"'Cane River Creole National Historical Park', ST_GeomFromText('POINT(-93.00343 31.66684)', 4326)",
"'Canyon de Chelly National Monument', ST_GeomFromText('POINT(-109.46912 36.1336)', 4326)",
"'Canyonlands National Park', ST_GeomFromText('POINT(-109.88072 38.261)', 4326)",
"'Canyons of the Ancients National Monument', ST_GeomFromText('POINT(-108.99994 37.37)', 4326)",
"'Cape Breton Highlands National Park', ST_GeomFromText('POINT(-60.8111 46.81611)', 4326)",
"'Cape Cod National Seashore', ST_GeomFromText('POINT(-70.20513 42.07389)', 4326)",
"'Cape Hatteras National Seashore', ST_GeomFromText('POINT(-75.51123 35.30361)', 4326)",
"'Cape Henry Memorial', ST_GeomFromText('POINT(-76.00819 36.92806)', 4326)",
"'Cape Krusenstern National Monument', ST_GeomFromText('POINT(-163.50002 67.41333)', 4326)",
"'Cape Lookout National Seashore', ST_GeomFromText('POINT(-76.53624 34.60528)', 4326)",
"'Capitol Reef National Park', ST_GeomFromText('POINT(-111.23862 38.27617)', 4326)",
"'Captain John Smith Chesapeake National Historic Trail', ST_GeomFromText('POINT(-75.99995 38)', 4326)",
"'Capulin Volcano National Monument', ST_GeomFromText('POINT(-103.96972 36.78222)', 4326)",
"'Carl Sandburg Home National Historic Site', ST_GeomFromText('POINT(-82.45149 35.26778)', 4326)",
"'Carlsbad Caverns National Park', ST_GeomFromText('POINT(-104.40902 32.1648)', 4326)",
"'Carrizo Plain', ST_GeomFromText('POINT(-119.74994 35.16)', 4326)",
"'Carter G. Woodson Home National Historic Site', ST_GeomFromText('POINT(-77.02399 38.90999)', 4326)",
"'Casa Grande Ruins National Monument', ST_GeomFromText('POINT(-111.53162 32.99517)', 4326)",
"'Cascade-Siskiyou National Monument', ST_GeomFromText('POINT(-122.46105 42.07778)', 4326)",
"'Castillo de San Marcos National Monument', ST_GeomFromText('POINT(-81.31153 29.89775)', 4326)",
"'Castle Clinton National Monument', ST_GeomFromText('POINT(-74.01674 40.7036)', 4326)",
"'Catoctin Mountain Park', ST_GeomFromText('POINT(-77.46665 39.64833)', 4326)",
"'Cedar Breaks National Monument', ST_GeomFromText('POINT(-112.84612 37.64519)', 4326)",
"'Cedar Creek and Belle Grove National Historical Park', ST_GeomFromText('POINT(-78.30063 39.16749)', 4326)",
"'Chaco Culture National Historical Park', ST_GeomFromText('POINT(-107.95862 36.05833)', 4326)",
"'Chalmette National Cemetery', ST_GeomFromText('POINT(-89.98648 29.94417)', 4326)",
"'Chamizal National Memorial', ST_GeomFromText('POINT(-106.45402 31.76778)', 4326)",
"'Channel Islands National Park', ST_GeomFromText('POINT(-119.74212 34.0394)', 4326)",
"'Charles Pinckney National Historic Site', ST_GeomFromText('POINT(-79.82454 32.84611)', 4326)",
"'Chattahoochee River National Recreation Area', ST_GeomFromText('POINT(-84.32454 33.98722)', 4326)",
"'Chesapeake and Ohio Canal National Historical Park', ST_GeomFromText('POINT(-77.05744 38.89972)', 4326)",
"'Chicago Portage National Historic Site', ST_GeomFromText('POINT(-87.80676 41.80556)', 4326)",
"'Chickamauga and Chattanooga National Military Park', ST_GeomFromText('POINT(-85.25984 34.94)', 4326)",
"'Chickasaw National Recreation Area', ST_GeomFromText('POINT(-96.97204 34.50056)', 4326)",
"'Chimney Rock National Historic Site', ST_GeomFromText('POINT(-103.34792 41.70368)', 4326)",
"'Chiricahua National Monument', ST_GeomFromText('POINT(-109.34802 32.01778)', 4326)",
"'Christiansted National Historic Site', ST_GeomFromText('POINT(-64.70204 17.74693)', 4326)",
"'City of Rocks National Reserve', ST_GeomFromText('POINT(-113.70366 42.07727)', 4326)",
"'Clara Barton National Historic Site', ST_GeomFromText('POINT(-77.14065 38.96694)', 4326)",
"'Colonial National Historical Park', ST_GeomFromText('POINT(-76.5084 37.21926)', 4326)",
"'Colonial Parkway', ST_GeomFromText('POINT(-76.71576 37.21557)', 4326)",
"'Colorado National Monument', ST_GeomFromText('POINT(-108.68582 39.04249)', 4326)",
"'Congaree National Park', ST_GeomFromText('POINT(-80.78308 33.78333)', 4326)",
"'Coronado National Memorial', ST_GeomFromText('POINT(-110.25602 31.3455)', 4326)",
"'Cowpens National Battlefield', ST_GeomFromText('POINT(-81.8179 35.13667)', 4326)",
"'Crater Lake National Park', ST_GeomFromText('POINT(-122.10872 42.943)', 4326)",
"'Craters of the Moon National Monument and Preserve', ST_GeomFromText('POINT(-113.51642 43.41667)', 4326)",
"'Cumberland Gap National Historical Park', ST_GeomFromText('POINT(-83.68703 36.60417)', 4326)",
"'Cumberland Island National Seashore', ST_GeomFromText('POINT(-81.44985 30.83333)', 4326)",
"'Curecanti National Recreation Area', ST_GeomFromText('POINT(-107.32672 38.45472)', 4326)",
"'Custer National Cemetery', ST_GeomFromText('POINT(-107.43165 45.56953)', 4326)",
"'Cuyahoga Valley National Park', ST_GeomFromText('POINT(-81.55677 41.20906)', 4326)",
"'David Berger National Memorial', ST_GeomFromText('POINT(-81.49236 41.47472)', 4326)",
"'Dayton Aviation Heritage National Historical Park', ST_GeomFromText('POINT(-84.0887 39.79472)', 4326)",
"'De Soto National Memorial', ST_GeomFromText('POINT(-82.64429 27.52389)', 4326)",
"'Death Valley National Park', ST_GeomFromText('POINT(-117.09872 36.524)', 4326)",
"'Delaware Water Gap National Recreation Area', ST_GeomFromText('POINT(-75.01726 41.08232)', 4326)",
"'Delaware Water Gap National Recreation Area', ST_GeomFromText('POINT(-75.00416 41.08996)', 4326)",
"'Delaware Water Gap National Recreation Area', ST_GeomFromText('POINT(-74.89562 41.14625)', 4326)",
"'Delaware Water Gap National Recreation Area', ST_GeomFromText('POINT(-74.80594 41.30989)', 4326)",
"'Delaware Water Gap National Recreation Area Boat Launch', ST_GeomFromText('POINT(-74.98472 41.10718)', 4326)",
"'Delaware Water Gap NRA Store & Campground', ST_GeomFromText('POINT(-74.87387 41.21144)', 4326)",
"'Denali National Park', ST_GeomFromText('POINT(-149.98632 63.54357)', 4326)",
"'Denali National Park and Preserve', ST_GeomFromText('POINT(-150.49972 63.33333)', 4326)",
"'Devils Postpile National Monument', ST_GeomFromText('POINT(-119.08412 37.62444)', 4326)",
"'Devils Tower National Monument', ST_GeomFromText('POINT(-104.71502 44.59028)', 4326)",
"'Dinosaur National Monument', ST_GeomFromText('POINT(-108.98302 40.53333)', 4326)",
"'Dry Tortugas National Park', ST_GeomFromText('POINT(-81.7859 24.6384)', 4326)",
"'East Potomac Park', ST_GeomFromText('POINT(-77.0259 38.87)', 4326)",
"'Ebey''s Landing National Historical Reserve', ST_GeomFromText('POINT(-122.68951 48.21341)', 4326)",
"'Edgar Allan Poe National Historic Site', ST_GeomFromText('POINT(-75.15011 39.96167)', 4326)",
"'Effigy Mounds National Monument', ST_GeomFromText('POINT(-91.18537 43.08861)', 4326)",
"'Eisenhower National Historic Site', ST_GeomFromText('POINT(-77.26316 39.79332)', 4326)",
"'El Malpais National Monument', ST_GeomFromText('POINT(-107.95752 34.87635)', 4326)",
"'El Morro National Monument', ST_GeomFromText('POINT(-108.35302 35.03833)', 4326)",
"'Eleanor Roosevelt National Historic Site', ST_GeomFromText('POINT(-73.93511 41.78582)', 4326)",
"'Elk Island National Park', ST_GeomFromText('POINT(-112.87042 53.59277)', 4326)",
"'Ellis Island National Monument', ST_GeomFromText('POINT(-74.03937 40.69956)', 4326)",
"'Eugene O''Neill National Historic Site', ST_GeomFromText('POINT(-122.02942 37.82444)', 4326)",
"'Everglades National Park', ST_GeomFromText('POINT(-80.79976 25.36)', 4326)",
"'Father Marquette National Memorial', ST_GeomFromText('POINT(-84.71708 45.85167)', 4326)",
"'Federal Hall', ST_GeomFromText('POINT(-74.01014 40.70722)', 4326)",
"'Fire Island National Seashore', ST_GeomFromText('POINT(-72.98263 40.69639)', 4326)",
"'First Ladies National Historic Site', ST_GeomFromText('POINT(-81.37511 40.79667)', 4326)",
"'Flight 93 National Memorial', ST_GeomFromText('POINT(-78.9076 40.05615)', 4326)",
"'Florissant Fossil Beds National Monument', ST_GeomFromText('POINT(-105.26744 38.91806)', 4326)",
"'Ford''s Theatre National Historic Site', ST_GeomFromText('POINT(-77.02563 38.89667)', 4326)",
"'Forillon National Park', ST_GeomFromText('POINT(-64.29027 48.82388)', 4326)",
"'Fort Bowie National Historic Site', ST_GeomFromText('POINT(-109.43542 32.14611)', 4326)",
"'Fort Caroline National Memorial', ST_GeomFromText('POINT(-81.50042 30.38694)', 4326)",
"'Fort Davis National Historic Site', ST_GeomFromText('POINT(-103.92562 30.59583)', 4326)",
"'Fort Donelson National Battlefield', ST_GeomFromText('POINT(-87.85736 36.48438)', 4326)",
"'Fort Donelson National Cemetery', ST_GeomFromText('POINT(-87.84766 36.48525)', 4326)",
"'Fort Dupont Park', ST_GeomFromText('POINT(-76.94947 38.8766)', 4326)",
"'Fort Foote Park', ST_GeomFromText('POINT(-77.02778 38.7667)', 4326)",
"'Fort Frederica National Monument', ST_GeomFromText('POINT(-81.39313 31.22389)', 4326)",
"'Fort Laramie National Historic Site', ST_GeomFromText('POINT(-104.53562 42.20917)', 4326)",
"'Fort Larned National Historic Site', ST_GeomFromText('POINT(-99.2265 38.15667)', 4326)",
"'Fort Matanzas National Monument', ST_GeomFromText('POINT(-81.23898 29.71528)', 4326)",
"'Fort McHenry National Monument and Historic Shrine', ST_GeomFromText('POINT(-76.57981 39.26306)', 4326)",
"'Fort Necessity National Battlefield', ST_GeomFromText('POINT(-79.59956 39.81667)', 4326)",
"'Fort Point National Historic Site', ST_GeomFromText('POINT(-122.47692 37.81056)', 4326)",
"'Fort Pulaski National Monument', ST_GeomFromText('POINT(-80.89008 32.02722)', 4326)",
"'Fort Raleigh National Historic Site', ST_GeomFromText('POINT(-75.70872 35.93833)', 4326)",
"'Fort Scott National Historic Site', ST_GeomFromText('POINT(-94.70455 37.84389)', 4326)",
"'Fort Smith National Historic Site', ST_GeomFromText('POINT(-94.42261 35.34333)', 4326)",
"'Fort Stanwix National Monument', ST_GeomFromText('POINT(-75.45506 43.21056)', 4326)",
"'Fort Sumter National Monument', ST_GeomFromText('POINT(-79.87453 32.75222)', 4326)",
"'Fort Union National Monument', ST_GeomFromText('POINT(-105.01802 35.90722)', 4326)",
"'Fort Union Trading Post National Historic Site', ST_GeomFromText('POINT(-104.04032 47.99944)', 4326)",
"'Fort Vancouver National Historic Site', ST_GeomFromText('POINT(-122.65792 45.6254)', 4326)",
"'Fort Washington National Park', ST_GeomFromText('POINT(-77.03304 38.71083)', 4326)",
"'Fossil Butte National Monument', ST_GeomFromText('POINT(-110.76762 41.85875)', 4326)",
"'Franklin Delano Roosevelt Memorial', ST_GeomFromText('POINT(-77.0443 38.88389)', 4326)",
"'Frederick Douglass National Historic Site', ST_GeomFromText('POINT(-76.98511 38.86333)', 4326)",
"'Frederick Law Olmsted National Historic Site', ST_GeomFromText('POINT(-71.13205 42.325)', 4326)",
"'Fredericksburg and Spotsylvania National Military Park', ST_GeomFromText('POINT(-77.46901 38.29305)', 4326)",
"'Fredericksburg National Cemetery', ST_GeomFromText('POINT(-77.46884 38.29307)', 4326)",
"'Friendship Hill National Historic Site', ST_GeomFromText('POINT(-79.92899 39.77778)', 4326)",
"'Fundy National Park', ST_GeomFromText('POINT(-64.9536 45.59527)', 4326)",
"'Gates of the Arctic National Park and Preserve', ST_GeomFromText('POINT(-153.29972 67.78333)', 4326)",
"'Gateway National Recreation Area - Breezy Point', ST_GeomFromText('POINT(-73.92607 40.5565)', 4326)",
"'Gateway National Recreation Area - Floyd Bennett Field', ST_GeomFromText('POINT(-73.89082 40.591)', 4326)",
"'Gateway National Recreation Area - Fort Hancock', ST_GeomFromText('POINT(-74.00259 40.46389)', 4326)",
"'Gateway National Recreation Area - Fort Tilden', ST_GeomFromText('POINT(-73.89093 40.56389)', 4326)",
"'Gateway National Recreation Area - Fort Wadsworth', ST_GeomFromText('POINT(-74.06232 40.60833)', 4326)",
"'Gateway National Recreation Area - Great Kills Park', ST_GeomFromText('POINT(-74.12715 40.55542)', 4326)",
"'Gateway National Recreation Area - Jacob Riis Park', ST_GeomFromText('POINT(-73.87395 40.56702)', 4326)",
"'Gateway National Recreation Area - Jamaica Bay', ST_GeomFromText('POINT(-73.84231 40.61778)', 4326)",
"'Gateway National Recreation Area - Miller Field', ST_GeomFromText('POINT(-74.09538 40.56416)', 4326)",
"'Gateway National Recreation Area - Sandy Hook', ST_GeomFromText('POINT(-73.99506 40.45288)', 4326)",
"'Gauley River National Recreation Area', ST_GeomFromText('POINT(-80.88982 38.22)', 4326)",
"'General Grant National Memorial', ST_GeomFromText('POINT(-73.96285 40.81333)', 4326)",
"'George Mason Memorial', ST_GeomFromText('POINT(-77.03903 38.87944)', 4326)",
"'George Rogers Clark National Historical Park', ST_GeomFromText('POINT(-87.5354 38.67919)', 4326)",
"'George Washington Birthplace National Monument', ST_GeomFromText('POINT(-76.93036 38.18611)', 4326)",
"'George Washington Carver National Monument', ST_GeomFromText('POINT(-94.354 36.98636)', 4326)",
"'George Washington Memorial Parkway', ST_GeomFromText('POINT(-77.10217 38.91111)', 4326)",
"'Georgian Bay Islands National Park', ST_GeomFromText('POINT(-79.87444 44.87777)', 4326)",
"'Gettysburg National Cemetery', ST_GeomFromText('POINT(-77.23124 39.82027)', 4326)",
"'Gettysburg National Military Park', ST_GeomFromText('POINT(-77.24615 39.81206)', 4326)",
"'Giant Sequoia National Monument', ST_GeomFromText('POINT(-118.50438 36.04)', 4326)",
"'Gila Cliff Dwellings National Monument', ST_GeomFromText('POINT(-108.27192 33.22722)', 4326)",
"'Glacier Bay National Park', ST_GeomFromText('POINT(-135.75552 58.41543)', 4326)",
"'Glacier Bay National Park and Preserve', ST_GeomFromText('POINT(-136.99996 58.5)', 4326)",
"'Glacier National Park', ST_GeomFromText('POINT(-113.77572 48.692)', 4326)",
"'Glen Canyon National Recreation Area', ST_GeomFromText('POINT(-111.48672 36.9936)', 4326)",
"'Gloria Dei (Old Swedes'') Church', ST_GeomFromText('POINT(-75.14342 39.93444)', 4326)",
"'Golden Gate National Recreation Area', ST_GeomFromText('POINT(-122.46652 37.78333)', 4326)",
"'Golden Gate National Recreation Area-Alcatraz Island', ST_GeomFromText('POINT(-122.42322 37.82667)', 4326)",
"'Golden Gate National Recreation Area-Presidio', ST_GeomFromText('POINT(-122.46572 37.79806)', 4326)",
"'Golden Spike National Historic Site', ST_GeomFromText('POINT(-112.54722 41.62048)', 4326)",
"'Governors Island National Monument', ST_GeomFromText('POINT(-74.01589 40.69139)', 4326)",
"'Grand Canyon', ST_GeomFromText('POINT(-112.13722 36.05749)', 4326)",
"'Grand Canyon - North Rim', ST_GeomFromText('POINT(-113.19712 36)', 4326)",
"'Grand Canyon - South Rim National Park', ST_GeomFromText('POINT(-112.11732 36.06501)', 4326)",
"'Grand Canyon National Park', ST_GeomFromText('POINT(-112.13745 36.0575)', 4326)",
"'Grand Canyon West Airport', ST_GeomFromText('POINT(-113.81612 35.99038)', 4326)",
"'Grand Canyon-Parashant National Monument', ST_GeomFromText('POINT(-113.69972 36.4)', 4326)",
"'Grand Portage National Monument', ST_GeomFromText('POINT(-89.74898 47.98528)', 4326)",
"'Grand Staircase-Escalante National Monument', ST_GeomFromText('POINT(-111.68327 37.4)', 4326)",
"'Grand Teton National Park', ST_GeomFromText('POINT(-110.78822 43.7403)', 4326)",
"'Grant-Kohrs Ranch National Historic Site', ST_GeomFromText('POINT(-112.73922 46.40833)', 4326)",
"'Grasslands National Park', ST_GeomFromText('POINT(-107.42542 49.17694)', 4326)",
"'Great Basin National Park', ST_GeomFromText('POINT(-114.26082 38.93873)', 4326)",
"'Great Egg Harbor Scenic and Recreational River', ST_GeomFromText('POINT(-74.64957 39.30417)', 4326)",
"'Great Sand Dunes National Park', ST_GeomFromText('POINT(-105.54172 37.7539)', 4326)",
"'Great Sand Dunes National Park and Preserve', ST_GeomFromText('POINT(-105.51182 37.73287)', 4326)",
"'Great Smoky Mountains National Park', ST_GeomFromText('POINT(-83.16773 35.72715)', 4326)",
"'Greenbelt Park', ST_GeomFromText('POINT(-76.89831 38.98917)', 4326)",
"'Gros Morne National Park', ST_GeomFromText('POINT(-57.78305 49.5)', 4326)",
"'Guadalupe Mountains National Park', ST_GeomFromText('POINT(-104.85962 31.916)', 4326)",
"'Guilford Courthouse National Military Park', ST_GeomFromText('POINT(-79.84623 36.13139)', 4326)",
"'Gulf Islands National Park Reserve', ST_GeomFromText('POINT(-123.44732 48.85055)', 4326)",
"'Gulf Islands National Seashore', ST_GeomFromText('POINT(-86.96735 30.36444)', 4326)",
"'Gwaii Haanas Park Reserve and Haida Heritage Site', ST_GeomFromText('POINT(-131.47072 52.38916)', 4326)",
"'Hagerman Fossil Beds National Monument', ST_GeomFromText('POINT(-114.94502 42.79028)', 4326)",
"'Haleakala National Park', ST_GeomFromText('POINT(-156.21002 20.71062)', 4326)",
"'Hamilton Grange National Memorial', ST_GeomFromText('POINT(-73.94815 40.82238)', 4326)",
"'Hampton National Historic Site', ST_GeomFromText('POINT(-76.58734 39.41611)', 4326)",
"'Hanford Reach National Monument', ST_GeomFromText('POINT(-119.51661 46.58333)', 4326)",
"'Harmony Hall Fort Washington Maryland', ST_GeomFromText('POINT(-77.00304 38.74583)', 4326)",
"'Harpers Ferry National Historical Park', ST_GeomFromText('POINT(-77.72952 39.32278)', 4326)",
"'Harry S. Truman National Historic Site', ST_GeomFromText('POINT(-94.53209 38.90211)', 4326)",
"'Hawaii Volcanoes National Park', ST_GeomFromText('POINT(-155.29962 19.39999)', 4326)",
"'Herbert Hoover National Historic Site', ST_GeomFromText('POINT(-91.3479 41.66861)', 4326)",
"'Historic Camden Revolutionary War Site', ST_GeomFromText('POINT(-80.60317 34.23389)', 4326)",
"'Historic Jamestowne', ST_GeomFromText('POINT(-76.77873 37.20971)', 4326)",
"'Hohokam Pima National Monument', ST_GeomFromText('POINT(-111.92642 33.15444)', 4326)",
"'Home of Franklin D. Roosevelt National Historic Site', ST_GeomFromText('POINT(-73.93539 41.76721)', 4326)",
"'Homestead National Monument of America', ST_GeomFromText('POINT(-96.82172 40.28525)', 4326)",
"'Honokohau National Historical Park', ST_GeomFromText('POINT(-156.02172 19.6787)', 4326)",
"'Hopewell Culture National Historical Park', ST_GeomFromText('POINT(-83.0062 39.37583)', 4326)",
"'Hopewell Furnace National Historic Site', ST_GeomFromText('POINT(-75.7754 40.19861)', 4326)",
"'Horseshoe Bend National Military Park', ST_GeomFromText('POINT(-85.73817 32.97083)', 4326)",
"'Hot Springs National Park', ST_GeomFromText('POINT(-92.95843 34.52684)', 4326)",
"'Hovenweep National Monument', ST_GeomFromText('POINT(-109.07702 37.38388)', 4326)",
"'Hubbell Trading Post National Historic Site', ST_GeomFromText('POINT(-109.59312 35.72556)', 4326)",
"'Independence Hall', ST_GeomFromText('POINT(-75.1498 39.94889)', 4326)",
"'Independence National Historical Park', ST_GeomFromText('POINT(-75.14787 39.94778)', 4326)",
"'Indiana Dunes National Lakeshore', ST_GeomFromText('POINT(-87.10791 41.64806)', 4326)",
"'International Peace Garden', ST_GeomFromText('POINT(-100.06432 48.99098)', 4326)",
"'Inupiat Heritage Center', ST_GeomFromText('POINT(-156.75331 71.29861)', 4326)",
"'Ironwood Forest National Monument', ST_GeomFromText('POINT(-111.56673 32.45896)', 4326)",
"'Isle Royale National Park', ST_GeomFromText('POINT(-88.89144 47.9624)', 4326)",
"'Ivvavik National Park', ST_GeomFromText('POINT(-139.52462 69.51972)', 4326)",
"'James A. Garfield National Historic Site', ST_GeomFromText('POINT(-81.34706 41.66222)', 4326)",
"'Jasper National Park', ST_GeomFromText('POINT(-118.08182 52.87305)', 4326)",
"'Jean Lafitte National Historical Park and Preserve', ST_GeomFromText('POINT(-89.99398 29.9425)', 4326)",
"'Jefferson National Expansion Memorial', ST_GeomFromText('POINT(-90.18483 38.6246)', 4326)",
"'Jewel Cave National Monument', ST_GeomFromText('POINT(-103.82912 43.72944)', 4326)",
"'Jimmy Carter National Historic Site', ST_GeomFromText('POINT(-84.39984 32.03389)', 4326)",
"'John D. Rockefeller Jr. Memorial Parkway', ST_GeomFromText('POINT(-110.69273 44.10472)', 4326)",
"'John Day Fossil Beds National Monument', ST_GeomFromText('POINT(-119.63412 44.54987)', 4326)",
"'John Ericsson National Memorial', ST_GeomFromText('POINT(-77.05014 38.88667)', 4326)",
"'John Fitzgerald Kennedy National Historic Site', ST_GeomFromText('POINT(-71.12428 42.34583)', 4326)",
"'John Muir National Historic Site', ST_GeomFromText('POINT(-122.13302 37.99131)', 4326)",
"'Johnstown Flood National Memorial', ST_GeomFromText('POINT(-78.77847 40.34556)', 4326)",
"'Joshua Tree National Park', ST_GeomFromText('POINT(-115.82762 33.843)', 4326)",
"'Kalaupapa Leprosy Settlement and National Historical Park', ST_GeomFromText('POINT(-156.95972 21.17778)', 4326)",
"'Kasha-Katuwe Tent Rocks National Monument', ST_GeomFromText('POINT(-106.41912 35.6736)', 4326)",
"'Kate Mullany National Historic Site', ST_GeomFromText('POINT(-73.68163 42.7399)', 4326)",
"'Katmai National Park', ST_GeomFromText('POINT(-154.88652 58.58305)', 4326)",
"'Katmai National Park and Preserve', ST_GeomFromText('POINT(-154.99972 58.5)', 4326)",
"'Kejimkujik National Park', ST_GeomFromText('POINT(-65.21805 44.39916)', 4326)",
"'Kenai Fjords National Park', ST_GeomFromText('POINT(-149.64982 59.91666)', 4326)",
"'Kenilworth Park and Aquatic Gardens', ST_GeomFromText('POINT(-76.94771 38.90833)', 4326)",
"'Kennesaw Mountain National Battlefield Park', ST_GeomFromText('POINT(-84.5779 33.98306)', 4326)",
"'Keweenaw National Historical Park', ST_GeomFromText('POINT(-88.4537 47.24667)', 4326)",
"'Kings Canyon National Park', ST_GeomFromText('POINT(-118.64062 36.81199)', 4326)",
"'Kings Mountain National Military Park', ST_GeomFromText('POINT(-81.38928 35.13778)', 4326)",
"'Klondike Gold Rush National Historical Park', ST_GeomFromText('POINT(-135.31162 59.45639)', 4326)",
"'Kluane National Park and Reserve', ST_GeomFromText('POINT(-137.50982 60.75305)', 4326)",
"'Knife River Indian Villages National Historic Site', ST_GeomFromText('POINT(-101.38562 47.35417)', 4326)",
"'Kobuk Valley National Park', ST_GeomFromText('POINT(-159.13662 67.34408)', 4326)",
"'Kootenay National Park', ST_GeomFromText('POINT(-116.04872 50.88305)', 4326)",
"'Korean War Veterans Memorial', ST_GeomFromText('POINT(-77.047 38.88778)', 4326)",
"'Kouchibouguac National Park', ST_GeomFromText('POINT(-64.96666 46.84972)', 4326)",
"'La Mauricie National Park', ST_GeomFromText('POINT(-72.85583 46.80805)', 4326)",
"'Lake Chelan National Recreation Area', ST_GeomFromText('POINT(-120.67802 48.32194)', 4326)",
"'Lake Clark National Park', ST_GeomFromText('POINT(-154.32362 60.19943)', 4326)",
"'Lake Clark National Park and Preserve', ST_GeomFromText('POINT(-153.41642 60.96667)', 4326)",
"'Lake Mead National Recreation Area', ST_GeomFromText('POINT(-113.69972 36.4)', 4326)",
"'Lake Mead National Recreation Area', ST_GeomFromText('POINT(-114.79642 36.00972)', 4326)",
"'Lake Meredith National Recreation Area', ST_GeomFromText('POINT(-101.55252 35.71472)', 4326)",
"'Lake Roosevelt National Recreation Area', ST_GeomFromText('POINT(-118.98032 47.95611)', 4326)",
"'Lassen Volcanic National Park', ST_GeomFromText('POINT(-121.41452 40.48297)', 4326)",
"'Lava Beds National Monument', ST_GeomFromText('POINT(-121.50802 41.71389)', 4326)",
"'Lewis and Clark National and State Historical Parks', ST_GeomFromText('POINT(-123.87722 46.13361)', 4326)",
"'Lewis and Clark National Historic Trail', ST_GeomFromText('POINT(-108.00939 46.00361)', 4326)",
"'Liberty Memorial', ST_GeomFromText('POINT(-94.58606 39.08044)', 4326)",
"'Lincoln Boyhood National Memorial', ST_GeomFromText('POINT(-86.9968 38.11833)', 4326)",
"'Lincoln Home National Historic Site', ST_GeomFromText('POINT(-89.64484 39.79722)', 4326)",
"'Lincoln Memorial', ST_GeomFromText('POINT(-77.04992 38.8893)', 4326)",
"'Little Bighorn Battlefield National Monument', ST_GeomFromText('POINT(-107.42722 45.57028)', 4326)",
"'Little River Canyon National Preserve', ST_GeomFromText('POINT(-85.59536 34.44056)', 4326)",
"'Little Rock Central High School National Historic Site', ST_GeomFromText('POINT(-92.29845 34.73666)', 4326)",
"'Longfellow National Historic Site', ST_GeomFromText('POINT(-71.12623 42.37667)', 4326)",
"'Lowell National Historical Park', ST_GeomFromText('POINT(-71.31008 42.64667)', 4326)",
"'Lower East Side Tenement National Historic Site', ST_GeomFromText('POINT(-73.98997 40.7185)', 4326)",
"'Lyndon B. Johnson National Historical Park', ST_GeomFromText('POINT(-98.62398 30.24083)', 4326)",
"'Lyndon Baines Johnson Memorial Grove on the Potomac', ST_GeomFromText('POINT(-77.05125 38.87861)', 4326)",
"'Maggie L. Walker National Historic Site', ST_GeomFromText('POINT(-77.4379 37.54778)', 4326)",
"'Mammoth Cave National Park', ST_GeomFromText('POINT(-86.11403 37.1841)', 4326)",
"'Manassas National Battlefield Park', ST_GeomFromText('POINT(-77.52151 38.81277)', 4326)",
"'Manzanar National Historic Site', ST_GeomFromText('POINT(-118.15422 36.72833)', 4326)",
"'Marianas Trench Marine National Monument', ST_GeomFromText('POINT(145 20)', 4326)",
"'Marsh-Billings-Rockefeller National Historical Park', ST_GeomFromText('POINT(-72.52917 43.63125)', 4326)",
"'Martin Luther King Jr National Memorial', ST_GeomFromText('POINT(-77.045124 38.885926)', 4326)",
"'Martin Luther King Jr. National Historic Site', ST_GeomFromText('POINT(-84.37211 33.755)', 4326)",
"'Martin Van Buren National Historic Site', ST_GeomFromText('POINT(-73.70405 42.36971)', 4326)",
"'Mary McLeod Bethune Council House National Historic Site', ST_GeomFromText('POINT(-77.03012 38.90778)', 4326)",
"'Meridian Hill Park', ST_GeomFromText('POINT(-77.03559 38.92124)', 4326)",
"'Mesa Verde National Park', ST_GeomFromText('POINT(-108.50862 37.3192)', 4326)",
"'Middle Delaware National Scenic River', ST_GeomFromText('POINT(-74.89984 41.15)', 4326)",
"'Mingan Archipelago National Park Reserve', ST_GeomFromText('POINT(-63.57638 50.25472)', 4326)",
"'Minidoka National Historic Site', ST_GeomFromText('POINT(-114.23202 42.63694)', 4326)",
"'Minute Man National Historical Park', ST_GeomFromText('POINT(-71.29842 42.45306)', 4326)",
"'Minuteman Missile National Historic Site', ST_GeomFromText('POINT(-102.16032 43.93111)', 4326)",
"'Missouri National Recreational River', ST_GeomFromText('POINT(-97.39263 42.8625)', 4326)",
"'Misty Fiords National Monument', ST_GeomFromText('POINT(-130.60716 55.62167)', 4326)",
"'Mojave National Preserve', ST_GeomFromText('POINT(-115.71642 34.88333)', 4326)",
"'Monocacy National Battlefield', ST_GeomFromText('POINT(-77.39192 39.37115)', 4326)",
"'Montezuma Castle National Monument', ST_GeomFromText('POINT(-111.83972 34.61305)', 4326)",
"'Moores Creek National Battlefield', ST_GeomFromText('POINT(-78.10928 34.45806)', 4326)",
"'Morristown National Historical Park', ST_GeomFromText('POINT(-74.52842 40.76694)', 4326)",
"'Mount Rainier National Park', ST_GeomFromText('POINT(-121.74982 46.85)', 4326)",
"'Mount Revelstoke National Park', ST_GeomFromText('POINT(-118.06512 51.08583)', 4326)",
"'Mount Rushmore National Memorial', ST_GeomFromText('POINT(-103.45952 43.87895)', 4326)",
"'Mount St. Helens National Volcanic Monument', ST_GeomFromText('POINT(-122.18422 46.23317)', 4326)",
"'Muir Woods National Monument', ST_GeomFromText('POINT(-122.58362 37.89889)', 4326)",
"'Nahanni National Park Reserve', ST_GeomFromText('POINT(-123.59962 61.08333)', 4326)",
"'Natchez National Historical Park', ST_GeomFromText('POINT(-91.38287 31.54333)', 4326)",
"'Natchez Trace Trail', ST_GeomFromText('POINT(-88.08826 34.66772)', 4326)",
"'National Constitution Center', ST_GeomFromText('POINT(-75.14876 39.95341)', 4326)",
"'National Japanese Am. Memorial To Patriotism During WW II', ST_GeomFromText('POINT(-77.01034 38.89452)', 4326)",
"'National Mall', ST_GeomFromText('POINT(-77.02339 38.89)', 4326)",
"'National Park of American Samoa', ST_GeomFromText('POINT(-170.68512 -14.25708)', 4326)",
"'National World War II Memorial', ST_GeomFromText('POINT(-77.04029 38.8894)', 4326)",
"'Natural Bridges National Monument', ST_GeomFromText('POINT(-110.01342 37.60138)', 4326)",
"'Navajo National Monument', ST_GeomFromText('POINT(-110.53442 36.68417)', 4326)",
"'New Bedford Whaling National Historical Park', ST_GeomFromText('POINT(-70.92314 41.63556)', 4326)",
"'New Jersey Pinelands National Reserve', ST_GeomFromText('POINT(-74.74985 39.75)', 4326)",
"'New Orleans Jazz National Historical Park', ST_GeomFromText('POINT(-90.06784 29.96306)', 4326)",
"'New River Gorge National River', ST_GeomFromText('POINT(-81.08152 37.96083)', 4326)",
"'Newberry National Volcanic Monument', ST_GeomFromText('POINT(-121.25188 43.69417)', 4326)",
"'Nez Perce National Historical Park', ST_GeomFromText('POINT(-116.35912 46.14194)', 4326)",
"'Nicodemus National Historic Site', ST_GeomFromText('POINT(-99.61734 39.39083)', 4326)",
"'Ninety Six National Historic Site', ST_GeomFromText('POINT(-82.02428 34.14694)', 4326)",
"'Niobrara National Scenic River', ST_GeomFromText('POINT(-100.31642 42.88333)', 4326)",
"'Noatak National Preserve', ST_GeomFromText('POINT(-161.19972 68)', 4326)",
"'North Cascades National Park', ST_GeomFromText('POINT(-121.18952 48.70643)', 4326)",
"'Ocmulgee National Monument', ST_GeomFromText('POINT(-83.60814 32.83667)', 4326)",
"'Oklahoma City National Memorial', ST_GeomFromText('POINT(-97.51708 35.47278)', 4326)",
"'Old Post Office Pavilion', ST_GeomFromText('POINT(-77.02788 38.89398)', 4326)",
"'Old Stone House', ST_GeomFromText('POINT(-77.06054 38.90556)', 4326)",
"'Olympic National Park', ST_GeomFromText('POINT(-123.52162 47.799)', 4326)",
"'Oregon Caves National Monument', ST_GeomFromText('POINT(-123.40692 42.09806)', 4326)",
"'Organ Pipe Cactus National Park', ST_GeomFromText('POINT(-112.85752 32.04444)', 4326)",
"'Oxon Cove Park and Oxon Hill Farm', ST_GeomFromText('POINT(-78.31665 37.08806)', 4326)",
"'Ozark National Scenic Riverways', ST_GeomFromText('POINT(-91.27615 37.1907)', 4326)",
"'Pacific Rim National Park Reserve', ST_GeomFromText('POINT(-124.76872 48.63611)', 4326)",
"'Padre Island National Seashore', ST_GeomFromText('POINT(-97.36846 26.98444)', 4326)",
"'Palo Alto Battlefield National Historical Park', ST_GeomFromText('POINT(-97.48037 26.02139)', 4326)",
"'Papah?naumoku?kea Marine National Monument', ST_GeomFromText('POINT(-171.73327 25.7)', 4326)",
"'Pea Ridge National Military Park', ST_GeomFromText('POINT(-94.03401 36.45444)', 4326)",
"'Pecos National Historical Park', ST_GeomFromText('POINT(-105.68912 35.54999)', 4326)",
"'Peirce Mill', ST_GeomFromText('POINT(-77.05192 38.94028)', 4326)",
"'Pennsylvania Avenue National Historic Site', ST_GeomFromText('POINT(-77.02373 38.89361)', 4326)",
"'Perry''s Victory and International Peace Memorial', ST_GeomFromText('POINT(-82.81124 41.65417)', 4326)",
"'Petersburg National Battlefield', ST_GeomFromText('POINT(-77.36123 37.21944)', 4326)",
"'Petrified Forest National Park', ST_GeomFromText('POINT(-109.78332 35.06274)', 4326)",
"'Petroglyph National Monument', ST_GeomFromText('POINT(-106.76162 35.13583)', 4326)",
"'Pictured Rocks National Lakeshore', ST_GeomFromText('POINT(-86.31235 46.56222)', 4326)",
"'Pinnacles National Monument', ST_GeomFromText('POINT(-121.16662 36.48693)', 4326)",
"'Pipe Spring National Monument', ST_GeomFromText('POINT(-112.73692 36.86193)', 4326)",
"'Pipestone National Monument', ST_GeomFromText('POINT(-96.32481 44.01333)', 4326)",
"'Piscataway Park', ST_GeomFromText('POINT(-77.09276 38.67861)', 4326)",
"'Point Pelee National Park', ST_GeomFromText('POINT(-82.51749 41.96416)', 4326)",
"'Point Reyes National Seashore', ST_GeomFromText('POINT(-122.88502 38.06)', 4326)",
"'Pompeys Pillar National Monument', ST_GeomFromText('POINT(-108.00577 45.99528)', 4326)",
"'Poplar Grove National Cemetery', ST_GeomFromText('POINT(-77.42845 37.16028)', 4326)",
"'Port Chicago Naval Magazine National Memorial', ST_GeomFromText('POINT(-122.02952 38.05749)', 4326)",
"'Poverty Point National Monument', ST_GeomFromText('POINT(-91.40763 32.63904)', 4326)",
"'Prehistoric Trackways National Monument', ST_GeomFromText('POINT(-106.89972 32.35)', 4326)",
"'President Lincoln''s Cottage at the Soldiers'' Home', ST_GeomFromText('POINT(-77.01161 38.94167)', 4326)",
"'President''s Park (White House)', ST_GeomFromText('POINT(-77.03674 38.89417)', 4326)",
"'Prince Albert National Park', ST_GeomFromText('POINT(-106.23322 53.99583)', 4326)",
"'Prince Edward Island National Park', ST_GeomFromText('POINT(-63.07472 46.41666)', 4326)",
"'Prince William Forest Park', ST_GeomFromText('POINT(-77.3797 38.58528)', 4326)",
"'Pu''uhonua o Honaunau National Historical Park', ST_GeomFromText('POINT(-155.91002 19.42194)', 4326)",
"'Pu''ukohola Heiau National Historic Site', ST_GeomFromText('POINT(-155.81972 20.02667)', 4326)",
"'Pukaskwa National Park', ST_GeomFromText('POINT(-85.9161 48.03361)', 4326)",
"'Quttinirpaaq National Park', ST_GeomFromText('POINT(-68.4211 81.56388)', 4326)",
"'Rainbow Bridge National Monument', ST_GeomFromText('POINT(-110.96382 37.07721)', 4326)",
"'Red Hill Patrick Henry National Memorial', ST_GeomFromText('POINT(-78.89792 37.03222)', 4326)",
"'Redwood National Park', ST_GeomFromText('POINT(-123.94482 41.4771)', 4326)",
"'Richmond National Battlefield Park', ST_GeomFromText('POINT(-77.37345 37.42917)', 4326)",
"'Riding Mountain National Park', ST_GeomFromText('POINT(-100.03572 50.86388)', 4326)",
"'River Raisin National Battlefield Park', ST_GeomFromText('POINT(-83.37817 41.91361)', 4326)",
"'Rock Creek and Potomac Parkway', ST_GeomFromText('POINT(-77.05439 38.91306)', 4326)",
"'Rock Creek Park', ST_GeomFromText('POINT(-77.04498 38.9575)', 4326)",
"'Rocky Mountain National Park', ST_GeomFromText('POINT(-105.68962 40.414)', 4326)",
"'Roger Williams National Memorial', ST_GeomFromText('POINT(-71.41075 41.83038)', 4326)",
"'Roosevelt Campobello International Park', ST_GeomFromText('POINT(-66.95915 44.87583)', 4326)",
"'Rose Atoll Marine National Monument', ST_GeomFromText('POINT(-168.14994 -14.50994)', 4326)",
"'Ross Lake National Recreation Area', ST_GeomFromText('POINT(-121.24502 48.67306)', 4326)",
"'Russell Cave National Monument', ST_GeomFromText('POINT(-85.80314 34.97417)', 4326)",
"'Sagamore Hill National Historic Site', ST_GeomFromText('POINT(-73.49734 40.88556)', 4326)",
"'Saguaro National Park', ST_GeomFromText('POINT(-111.13052 32.2432)', 4326)",
"'Saint Croix Island International Historic Site', ST_GeomFromText('POINT(-67.13317 45.12833)', 4326)",
"'Saint Croix National Scenic Riverway', ST_GeomFromText('POINT(-92.65735 45.38917)', 4326)",
"'Saint Paul''s Church National Historic Site', ST_GeomFromText('POINT(-73.82566 40.89278)', 4326)",
"'Saint-Gaudens National Historic Site', ST_GeomFromText('POINT(-72.36848 43.4959)', 4326)",
"'Salem Maritime National Historic Site', ST_GeomFromText('POINT(-70.88706 42.52056)', 4326)",
"'Salinas Pueblo Missions National Monument', ST_GeomFromText('POINT(-106.09002 34.25972)', 4326)",
"'Salt River Bay National Historical Park', ST_GeomFromText('POINT(-64.7587 17.77889)', 4326)",
"'San Antonio Missions National Historical Park', ST_GeomFromText('POINT(-98.48008 29.36167)', 4326)",
"'San Francisco Maritime National Historical Park', ST_GeomFromText('POINT(-122.42332 37.80639)', 4326)",
"'San Juan Island National Historical Park', ST_GeomFromText('POINT(-122.98532 48.45583)', 4326)",
"'San Juan National Historic Site', ST_GeomFromText('POINT(-66.11012 18.4675)', 4326)",
"'Sand Creek Massacre National Historic Site', ST_GeomFromText('POINT(-102.52832 38.54083)', 4326)",
"'Santa Monica Mountains National Recreation Area', ST_GeomFromText('POINT(-118.60222 34.10389)', 4326)",
"'Santa Rosa and San Jacinto Mountains National Monument', ST_GeomFromText('POINT(-116.7055 33.80083)', 4326)",
"'Saratoga National Historical Park', ST_GeomFromText('POINT(-73.63728 42.99889)', 4326)",
"'Saugus Iron Works National Historic Site', ST_GeomFromText('POINT(-71.00873 42.46778)', 4326)",
"'Scotts Bluff National Monument', ST_GeomFromText('POINT(-103.70052 41.83556)', 4326)",
"'Sequoia National Park', ST_GeomFromText('POINT(-118.72242 36.36444)', 4326)",
"'Sewall-Belmont House National Historic Site', ST_GeomFromText('POINT(-77.00344 38.89194)', 4326)",
"'Shenandoah National Park', ST_GeomFromText('POINT(-78.30072 38.72)', 4326)",
"'Shiloh National Cemetery', ST_GeomFromText('POINT(-88.32007 35.15041)', 4326)",
"'Shiloh National Military Park', ST_GeomFromText('POINT(-88.32981 35.15188)', 4326)",
"'Sirmilik National Park', ST_GeomFromText('POINT(-78.43416 72.34054)', 4326)",
"'Sitka National Historical Park', ST_GeomFromText('POINT(-135.31362 57.04694)', 4326)",
"'Sleeping Bear Dunes National Lakeshore', ST_GeomFromText('POINT(-86.02013 44.91306)', 4326)",
"'Sonoran Desert National Monument', ST_GeomFromText('POINT(-112.45494 33.00167)', 4326)",
"'Springfield Armory National Historic Site', ST_GeomFromText('POINT(-72.58151 42.10806)', 4326)",
"'St. Lawrence Islands National Park', ST_GeomFromText('POINT(-75.87276 44.41444)', 4326)",
"'Star-Spangled Banner National Historic Trail', ST_GeomFromText('POINT(-76.57995 39.26306)', 4326)",
"'Statue Of Liberty National Monument', ST_GeomFromText('POINT(-74.04477 40.68968)', 4326)",
"'Steamtown National Historic Site', ST_GeomFromText('POINT(-75.67116 41.40733)', 4326)",
"'Stones River National Battlefield', ST_GeomFromText('POINT(-86.43639 35.87629)', 4326)",
"'Stones River National Cemetery', ST_GeomFromText('POINT(-86.436 35.87639)', 4326)",
"'Suitland Parkway', ST_GeomFromText('POINT(-76.96801 38.84694)', 4326)",
"'Sunset Crater Volcano National Monument', ST_GeomFromText('POINT(-111.50042 35.36558)', 4326)",
"'Tallgrass Prairie National Preserve', ST_GeomFromText('POINT(-96.55869 38.43278)', 4326)",
"'Terra Nova National Park', ST_GeomFromText('POINT(-53.99583 48.51194)', 4326)",
"'Thaddeus Kosciuszko National Memorial', ST_GeomFromText('POINT(-75.14732 39.94333)', 4326)",
"'Theodore Roosevelt Birthplace National Historic Site', ST_GeomFromText('POINT(-73.98956 40.73889)', 4326)",
"'Theodore Roosevelt Inaugural National Historic Site', ST_GeomFromText('POINT(-78.87226 42.90148)', 4326)",
"'Theodore Roosevelt Island', ST_GeomFromText('POINT(-77.06402 38.89721)', 4326)",
"'Theodore Roosevelt National Park', ST_GeomFromText('POINT(-103.24872 47.3352)', 4326)",
"'Thomas Cole National Historic Site', ST_GeomFromText('POINT(-73.86178 42.22583)', 4326)",
"'Thomas Edison National Historical Park', ST_GeomFromText('POINT(-74.23759 40.78694)', 4326)",
"'Thomas Jefferson Memorial', ST_GeomFromText('POINT(-77.03647 38.88139)', 4326)",
"'Thomas Stone National Historic Site', ST_GeomFromText('POINT(-77.03595 38.53139)', 4326)",
"'Timpanogos Cave National Monument', ST_GeomFromText('POINT(-111.70912 40.44056)', 4326)",
"'Tomb of the Unknowns', ST_GeomFromText('POINT(-77.07206 38.87638)', 4326)",
"'Tonto National Monument', ST_GeomFromText('POINT(-111.09412 33.65694)', 4326)",
"'Torngat Mountains National Park Reserve', ST_GeomFromText('POINT(-63.10027 58.67222)', 4326)",
"'Touro Synagogue National Historic Site', ST_GeomFromText('POINT(-71.31178 41.48944)', 4326)",
"'Tuktut Nogait National Park', ST_GeomFromText('POINT(-123.01622 69.28333)', 4326)",
"'Tumac-cori National Historical Park', ST_GeomFromText('POINT(-111.05052 31.5675)', 4326)",
"'Tupelo National Battlefield', ST_GeomFromText('POINT(-88.73706 34.25528)', 4326)",
"'Tuskegee Airmen National Historic Site', ST_GeomFromText('POINT(-85.67984 32.45722)', 4326)",
"'Tuskegee Institute National Historic Site', ST_GeomFromText('POINT(-85.70762 32.43028)', 4326)",
"'Tuzigoot National Monument', ST_GeomFromText('POINT(-112.02572 34.77085)', 4326)",
"'U.S. Air Force Memorial', ST_GeomFromText('POINT(-77.06606 38.86865)', 4326)",
"'Ukkusiksalik National Park', ST_GeomFromText('POINT(-87.30527 65.34166)', 4326)",
"'Ulysses S. Grant National Historic Site', ST_GeomFromText('POINT(-90.35178 38.55111)', 4326)",
"'United States Marine Corps War Memorial', ST_GeomFromText('POINT(-77.06946 38.89047)', 4326)",
"'United States Navy Memorial', ST_GeomFromText('POINT(-77.02286 38.89417)', 4326)",
"'Upper Missouri River Breaks National Monument', ST_GeomFromText('POINT(-109.02133 47.78333)', 4326)",
"'USS Arizona Memorial', ST_GeomFromText('POINT(-157.94972 21.365)', 4326)",
"'USS Utah Memorial', ST_GeomFromText('POINT(-157.96244 21.36889)', 4326)",
"'Valley Forge National Historical Park', ST_GeomFromText('POINT(-75.43869 40.09693)', 4326)",
"'Vanderbilt Mansion National Historic Site', ST_GeomFromText('POINT(-73.94174 41.79611)', 4326)",
"'Vermilion Cliffs National Monument', ST_GeomFromText('POINT(-111.74105 36.80639)', 4326)",
"'Vicksburg National Cemetery', ST_GeomFromText('POINT(-90.84959 32.34886)', 4326)",
"'Vicksburg National Military Park', ST_GeomFromText('POINT(-90.84963 32.34879)', 4326)",
"'Vietnam Veterans Memorial', ST_GeomFromText('POINT(-77.04756 38.8911)', 4326)",
"'Vietnam Women''s Memorial', ST_GeomFromText('POINT(-77.04679 38.8904)', 4326)",
"'Virgin Islands Coral Reef National Monument', ST_GeomFromText('POINT(-64.72675 18.30611)', 4326)",
"'Virgin Islands National Park', ST_GeomFromText('POINT(-64.73323 18.33333)', 4326)",
"'Voyageurs National Park', ST_GeomFromText('POINT(-93.01663 48.0996)', 4326)",
"'Vuntut National Park', ST_GeomFromText('POINT(-140.04712 68.30694)', 4326)",
"'Walnut Canyon National Monument', ST_GeomFromText('POINT(-111.50942 35.17167)', 4326)",
"'Wapusk National Park', ST_GeomFromText('POINT(-92.66999 57.24638)', 4326)",
"'War in the Pacific National Historical Park', ST_GeomFromText('POINT(144.66694 13.3)', 4326)",
"'Washington Monument', ST_GeomFromText('POINT(-77.03504 38.88947)', 4326)",
"'Washita Battlefield National Historic Site', ST_GeomFromText('POINT(-99.70012 36.6175)', 4326)",
"'Waterton Lakes National Park', ST_GeomFromText('POINT(-113.91482 49.04583)', 4326)",
"'Weir Farm National Historic Site', ST_GeomFromText('POINT(-73.45455 41.25806)', 4326)",
"'West Potomac Park', ST_GeomFromText('POINT(-77.0469 38.886)', 4326)",
"'Whiskeytown-Shasta-Trinity National Recreation Area', ST_GeomFromText('POINT(-122.94172 40.73528)', 4326)",
"'White House', ST_GeomFromText('POINT(-77.03634 38.89767)', 4326)",
"'White Sands National Monument', ST_GeomFromText('POINT(-106.17142 32.77971)', 4326)",
"'Whitman Mission National Historic Site', ST_GeomFromText('POINT(-118.46112 46.04)', 4326)",
"'William Howard Taft National Historic Site', ST_GeomFromText('POINT(-84.50845 39.11972)', 4326)",
"'William J Clinton Birthplace Home National Historic Site', ST_GeomFromText('POINT(-93.5964 33.66717)', 4326)",
"'Wilson''s Creek National Battlefield', ST_GeomFromText('POINT(-93.41984 37.11556)', 4326)",
"'Wind Cave National Park', ST_GeomFromText('POINT(-103.43302 43.5909)', 4326)",
"'Wolf Trap National Park for the Performing Arts', ST_GeomFromText('POINT(-77.26184 38.93694)', 4326)",
"'Women''s Rights National Historical Park', ST_GeomFromText('POINT(-76.8012 42.91083)', 4326)",
"'Wood Buffalo National Park', ST_GeomFromText('POINT(-112.98592 59.39083)', 4326)",
"'World War II Home Front National Historical Park', ST_GeomFromText('POINT(-122.36442 37.90619)', 4326)",
"'Wrangell-St. Elias National Park', ST_GeomFromText('POINT(-143.21622 61.24284)', 4326)",
"'Wrangell-St. Elias National Park and Preserve', ST_GeomFromText('POINT(-141.99972 61)', 4326)",
"'Wright Brothers National Memorial', ST_GeomFromText('POINT(-75.66792 36.01417)', 4326)",
"'Wupatki National Monument', ST_GeomFromText('POINT(-111.38662 35.56556)', 4326)",
"'WW II Valor in the Pacific National Monument Atka Island', ST_GeomFromText('POINT(-174.44522 52.13806)', 4326)",
"'WW II Valor in the Pacific National Monument Attu Island', ST_GeomFromText('POINT(172.90944 52.9025)', 4326)",
"'WW II Valor in the Pacific National Monument Ford Island', ST_GeomFromText('POINT(-157.96022 21.36389)', 4326)",
"'WW II Valor in the Pacific National Monument Kiska', ST_GeomFromText('POINT(177.46 51.96417)', 4326)",
"'WW II Valor in the Pacific Tule Lake Relocation Center', ST_GeomFromText('POINT(-121.37466 41.88944)', 4326)",
"'Yellowstone National Park', ST_GeomFromText('POINT(-110.61342 44.79573)', 4326)",
"'Yoho National Park', ST_GeomFromText('POINT(-116.48622 51.39527)', 4326)",
"'Yorktown National Cemetery', ST_GeomFromText('POINT(-76.50624 37.22493)', 4326)",
"'Yosemite National Park', ST_GeomFromText('POINT(-119.69432 37.6379)', 4326)",
"'Yucca House National Monument', ST_GeomFromText('POINT(-108.68612 37.25027)', 4326)",
"'Yukon-Charley Rivers National Preserve', ST_GeomFromText('POINT(-142.79972 65)', 4326)",
"'Zion National Park', ST_GeomFromText('POINT(-112.68142 37.22299)', 4326)"
]
if __name__ == '__main__':
bootstrap()