-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathtravel.db
612 lines (612 loc) · 100 KB
/
travel.db
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
603
604
605
606
607
608
609
610
611
612
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "tags" (
`tag_id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
`name` TEXT NOT NULL,
`definition` TEXT
);
INSERT INTO tags VALUES(1,'Vacation','Vacation or trip destinations');
INSERT INTO tags VALUES(2,'Caribbean','Found somewhere in the Caribbean Islands');
INSERT INTO tags VALUES(3,'Pennsylvania','Destinations in Pennsylvania');
INSERT INTO tags VALUES(4,'State Park',NULL);
INSERT INTO tags VALUES(5,'National Historic Site',NULL);
INSERT INTO tags VALUES(6,'National Park',NULL);
INSERT INTO tags VALUES(7,'National Forest',NULL);
INSERT INTO tags VALUES(8,'Nationa Monument',NULL);
INSERT INTO tags VALUES(9,'National Historical Park',NULL);
INSERT INTO tags VALUES(10,'City Park',NULL);
INSERT INTO tags VALUES(11,'Loop Trail',NULL);
INSERT INTO tags VALUES(12,'Point-to-Point Trail',NULL);
INSERT INTO tags VALUES(13,'Ruins','Places, typically, trails leading to interesting ruins.');
INSERT INTO tags VALUES(14,'Long Loop','Multiday loop trails suitable for long backpacking trips');
INSERT INTO tags VALUES(15,'Adventure','Places that have some level of risk or ardor associated with getting there.');
INSERT INTO tags VALUES(16,'State Forest',NULL);
INSERT INTO tags VALUES(17,'National Recreation Area','');
INSERT INTO tags VALUES(18,'Waterfall',NULL);
INSERT INTO tags VALUES(19,'Delaware',NULL);
INSERT INTO tags VALUES(20,'Maryland',NULL);
INSERT INTO tags VALUES(21,'County Park','');
INSERT INTO tags VALUES(22,'Biking','Amenable to bike trips');
INSERT INTO tags VALUES(23,'National Recreation Area','https://en.wikipedia.org/wiki/National_Recreation_Area');
INSERT INTO tags VALUES(24,'Summer','');
INSERT INTO tags VALUES(25,'Philadelphia',NULL);
INSERT INTO tags VALUES(26,'Historical',NULL);
INSERT INTO tags VALUES(27,'Brunch',NULL);
INSERT INTO tags VALUES(28,'Best List','');
INSERT INTO tags VALUES(29,'Winter',NULL);
INSERT INTO tags VALUES(30,'Auroras','Northern or Southern Lights');
INSERT INTO tags VALUES(31,'New Jersey',NULL);
INSERT INTO tags VALUES(32,'New York',NULL);
INSERT INTO tags VALUES(33,'Abandoned Places','Buidings or Structures that are decaying, but cool');
INSERT INTO tags VALUES(34,'Museum',NULL);
INSERT INTO tags VALUES(35,'State Game Land','');
INSERT INTO tags VALUES(36,'On Route To Atlanta','Attractions and Camping along the route to Atlanta');
INSERT INTO tags VALUES(37,'Kayaking','Great destinations for kayaking');
INSERT INTO tags VALUES(38,'Van Life','Vanlife is a rapidly growing lifestyle where people all over the world are converting vans into rolling homes ');
INSERT INTO tags VALUES(39,'Water Trails','Canoeing and/or Kayaking Destinations');
INSERT INTO tags VALUES(40,'Poconos','Locale of interest');
INSERT INTO tags VALUES(41,'Sculpture Garden','Anything from megaliths to Rodin');
INSERT INTO tags VALUES(42,'Fall Colors',NULL);
INSERT INTO tags VALUES(43,'Rock Formations',NULL);
INSERT INTO tags VALUES(44,'Fossil Fuel','e.g. oil wells, fracking sites');
INSERT INTO tags VALUES(45,'Riparian','Follows along water');
INSERT INTO tags VALUES(46,'Road Trip','Describes a multi-stop trip in a car');
INSERT INTO tags VALUES(47,'Camp Elk Tannery','Destinations (mostly trails) close to Camp Elk Tannery. ');
INSERT INTO tags VALUES(48,'Free','No entrance fee to get in');
INSERT INTO tags VALUES(49,'Hunting Season Only','Roads to trailhead are only open during hunting season. ');
INSERT INTO tags VALUES(50,'Backpacking','Good places to backpack.');
INSERT INTO tags VALUES(51,'Beach','');
INSERT INTO tags VALUES(52,'Water Sports','Use when multiple water sports are involved');
INSERT INTO tags VALUES(53,'Tubing','');
INSERT INTO tags VALUES(54,'List','Links that are lists of destinations, like ''best of'' lists. ');
CREATE TABLE IF NOT EXISTS "trail_park_rel" (
`trail_id` INTEGER,
`park_id` INTEGER,
FOREIGN KEY(`park_id`) REFERENCES `park`(`park_id`),
FOREIGN KEY(`trail_id`) REFERENCES `trail`(`trail_id`)
);
INSERT INTO trail_park_rel VALUES(7,2);
INSERT INTO trail_park_rel VALUES(8,3);
INSERT INTO trail_park_rel VALUES(9,3);
INSERT INTO trail_park_rel VALUES(10,4);
INSERT INTO trail_park_rel VALUES(12,8);
INSERT INTO trail_park_rel VALUES(15,10);
INSERT INTO trail_park_rel VALUES(16,10);
INSERT INTO trail_park_rel VALUES(17,12);
INSERT INTO trail_park_rel VALUES(3,13);
INSERT INTO trail_park_rel VALUES(18,16);
INSERT INTO trail_park_rel VALUES(19,17);
INSERT INTO trail_park_rel VALUES(20,17);
INSERT INTO trail_park_rel VALUES(28,21);
INSERT INTO trail_park_rel VALUES(36,3);
INSERT INTO trail_park_rel VALUES(37,32);
INSERT INTO trail_park_rel VALUES(37,33);
INSERT INTO trail_park_rel VALUES(38,33);
INSERT INTO trail_park_rel VALUES(45,13);
INSERT INTO trail_park_rel VALUES(53,8);
CREATE TABLE IF NOT EXISTS "trail" (
`trail_id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
`name` TEXT NOT NULL UNIQUE,
`trail_length` NUMERIC,
`difficulty` INTEGER,
`url` TEXT,
`blaze` TEXT,
`loop_flag` INTEGER,
`map` TEXT,
`map_google` TEXT,
`alltrails` TEXT,
`rating` INTEGER,
`comment` TEXT
);
INSERT INTO trail VALUES(1,'Old Loggers Path',25,3,'http://www.pahikes.com/trails/old-loggers-path','orange',1,'http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_20027896.pdf',NULL,'https://www.alltrails.com/trail/us/pennsylvania/old-loggers-path',NULL,'I have trail map. Ben Barbash says, "yellow dog/Rock run campsite is an all time great...There are also two shelters on the trail which make for some easy nights while out there" Also, Brad Street says, "if you''re arriving on an afternoon hike counter clockwise, to camp near rock run first night. If arriving in morning, hike clockwise. Camp near rock run second night. Assuming that you are parking at Maston parking area and hiking 2 and 1/2 days. 2 "long" days (around 10 miles) and 1 shorter"');
INSERT INTO trail VALUES(2,'Appalachian',2190,5,'http://www.appalachiantrail.org/home/explore-the-trail','white',0,'https://nps.maps.arcgis.com/apps/webappviewer/index.html?id=6298c848ba2a490588b7f6d25453e4e0',NULL,NULL,NULL,NULL);
INSERT INTO trail VALUES(3,'Loyalsock',59,NULL,'https://alpineclubofwilliamsport.com/','yellow with either red LT or old ones with red line',1,'http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_002939.pdf','https://www.google.com/search?client=firefox-b-1-ab&q=loyalsock+trail&npsic=0&rflfq=1&rlha=0&rllag=41466699,-76575368,0&tbm=lcl&ved=0ahUKEwiusYKe1q3aAhXITd8KHZDuCO4QtgMIfw&tbs=lrf:!3sIAE,lf:1,lf_ui:1&rldoc=1','https://www.alltrails.com/trail/us/pennsylvania/loyalsock-trail',NULL,NULL);
INSERT INTO trail VALUES(4,'Switchback Railroad',18,NULL,'https://www.traillink.com/trail/switchback-railroad-trail/',NULL,1,'https://www.traillink.com/trail-maps/switchback-railroad-trail/',NULL,NULL,NULL,'Trail end points: E. Holland at Amidon St. (Summit Hill) and North Ave. nr. Pine Ave. and Center Ave. nr. Packer Hill Rd. (Jim Thorpe)');
INSERT INTO trail VALUES(5,'Stony Valley Rail-Trail',19,NULL,'http://www.stonyvalley.com/rail-trail.html',NULL,1,'http://www.stonyvalley.com/explore.html','https://www.google.com/maps/place/Stony+Valley+RR+Trail+Parking/@40.4060855,-76.8226969,16z/data=!4m5!3m4!1s0x89c8b62cf6182f27:0xb2f3cb78ab603eeb!8m2!3d40.4060855!4d-76.8183142','https://www.alltrails.com/trail/us/pennsylvania/stony-valley-rail-trail',NULL,replace('Links to gameland maps with trail on them are towards bottom of page. \nSaint Anthony''s Wilderness in along this trail. ','\n',char(10)));
INSERT INTO trail VALUES(6,'Delaware & Lehigh',165,NULL,'http://delawareandlehigh.org/',NULL,0,'http://delawareandlehigh.org/map/',NULL,NULL,NULL,'Camp Grounds along the trail < https://delawareandlehigh.org/blog/camping-in-the-corridor/ >.');
INSERT INTO trail VALUES(7,'Wissahickon-Yellow',7.9000000000000003552,2,'https://www.fow.org/','yellow',0,'https://www.fow.org/visit-the-park/maps/',NULL,NULL,NULL,'Longest Trail in Wissahickon Park, it goes from Lincoln Drive to Bell''s Mill Rd on the Roxborough side of the creek. ');
INSERT INTO trail VALUES(8,'Tracy Ridge Hiking',34,NULL,'https://www.fs.usda.gov/recarea/allegheny/recarea/?recid=6138',NULL,1,'https://www.fs.usda.gov/Internet/FSE_DOCUMENTS/stelprdb5052731.pdf',NULL,NULL,NULL,'Not as scenic as Morrison Trail');
INSERT INTO trail VALUES(9,'Morrison Hiking Trail',10.80000000000000071,NULL,'https://www.fs.usda.gov/recarea/allegheny/recarea/?recid=6094',NULL,1,'https://www.fs.usda.gov/Internet/FSE_DOCUMENTS/stelprdb5052727.pdf',NULL,'https://www.alltrails.com/trail/us/pennsylvania/morrison-trail',NULL,'Nicer than Tracy Ridge');
INSERT INTO trail VALUES(10,'Lehigh Gorge',26,NULL,'http://www.dcnr.pa.gov/StateParks/FindAPark/LehighGorgeStatePark/Pages/default.aspx',NULL,0,'http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_003769.pdf','https://www.google.com/maps/place/Lehigh+Gorge+Trail,+Pennsylvania/data=!4m2!3m1!1s0x89c5b2a1fdc77673:0xe2206dec5fa8f66?sa=X&ved=0ahUKEwiTle-x2qPaAhVxkeAKHaz3D-MQ8gEIKDAA','https://www.alltrails.com/parks/us/pennsylvania/lehigh-gorge-state-park',NULL,'It is part of the Delaware & Lehigh Trail (id = 6).');
INSERT INTO trail VALUES(11,'Yellow Springs Loop Trail',8,4,'https://www.trails.com/tcatalog_trail.aspx?trailid=HGN217-023',NULL,1,NULL,'https://www.google.com/maps/place/40%C2%B030''09.4%22N+76%C2%B039''14.8%22W/@40.5026092,-76.6716207,14z/data=!3m1!4b1!4m5!3m4!1s0x0:0x0!8m2!3d40.5026!4d-76.6541?hl=en',NULL,NULL,'It will lead you to the ruins of the former Yellow Springs Village as well as an old excavator. You''ll know you''ve arrived at the abandoned village when you see the sign announcing "Yellow Springs - Old Coal Mining Village." State Game Lands #211');
INSERT INTO trail VALUES(12,'Susquehannock Trail System',85,4,'http://www.stc-hike.org/','orange',1,'http://www.stc-hike.org/Trailheads.aspx','https://www.google.com/maps/place/Susquehannock+State+Forest/@41.513262,-77.6765184,15z/data=!4m5!3m4!1s0x0:0x6ae875e1e3a2d194!8m2!3d41.513262!4d-77.6765184',NULL,NULL,'It in the Susquehannock State Forest in Potter and Clinton counties in north-central Pennsylvania in the United States. Favorite on Backpacking and Hiking PA FB page');
INSERT INTO trail VALUES(13,'Horseshoe Trail',140,3,'http://www.hstrail.org/',NULL,0,'https://www.nps.gov/vafo/planyourvisit/upload/2014-VAFO-Trail-Map-Trails-only.PDF','https://www.google.com/maps/place/40%C2%B006''00.8%22N+75%C2%B027''41.2%22W/@40.1002395,-75.4702252,15z/data=!3m1!4b1!4m13!1m6!3m5!1s0x0:0x6eb82d50e6dad1fb!2sValley+Forge+National+Historical+Park!8m2!3d40.1017509!4d-75.4469224!3m5!1s0x0:0x0!7e2!8m2!3d40.1002245!4d-75.4614492',NULL,NULL,'Starts at Valley Forge National Park and ends at Appalachian Trail. ');
INSERT INTO trail VALUES(14,'Valley Creek Trail',1.5,1,'https://www.nps.gov/vafo/planyourvisit/trails.htm',NULL,0,'https://www.nps.gov/vafo/planyourvisit/upload/2014-VAFO-Trail-Map-Trails-only.PDF','https://www.google.com/maps/place/40%C2%B006''00.8%22N+75%C2%B027''41.2%22W/@40.1002395,-75.4702252,15z/data=!3m1!4b1!4m13!1m6!3m5!1s0x0:0x6eb82d50e6dad1fb!2sValley+Forge+National+Historical+Park!8m2!3d40.1017509!4d-75.4469224!3m5!1s0x0:0x0!7e2!8m2!3d40.1002245!4d-75.4614492',NULL,2,'Zack liked this trail when his was little. This is where he sang the mushy mushroom song capture on video. ');
INSERT INTO trail VALUES(15,'Sunset Rocks Trail',7.2999999999999998223,5,'https://www.visitcumberlandvalley.com/listing/sunset-rocks-trail/1163/',NULL,1,'https://res.cloudinary.com/simpleview/image/upload/v1466638247/clients/cumberland/sunset_rocks_map_c8841e2f-0179-9687-3b083ec1835344d2.pdf','https://www.google.com/maps/place/Sunset+Rocks+Trailhead/@40.0388508,-77.3274425,17z/data=!3m1!4b1!4m5!3m4!1s0x89c90449de0090f7:0xb79af96a97f9ae5f!8m2!3d40.0388467!4d-77.3252485','https://www.alltrails.com/trail/us/pennsylvania/sunset-rocks-trail',NULL,'Trail will lead you to the spectacular ruins of a POW camp during World War II. ');
INSERT INTO trail VALUES(16,'Flat Rock Trail System','',NULL,'http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_20031384.pdf',NULL,NULL,'http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_20031384.pdf',NULL,NULL,NULL,NULL);
INSERT INTO trail VALUES(17,'Tumbling Waters Trail',3,4,'https://www.nps.gov/dewa/planyourvisit/tumbling-waters-trail.htm','orange',1,'http://peec.org/pdfs/2011-tumblingwaterstrailguide.pdf','https://www.google.com/maps/place/41%C2%B010''16.6%22N+74%C2%B054''44.0%22W/@41.171273,-74.91221,16z/data=!4m5!3m4!1s0x0:0x0!8m2!3d41.171273!4d-74.91221?hl=en','https://www.alltrails.com/trail/us/pennsylvania/tumbling-waters-pike-county',NULL,'Trail will take you past spectacular scenery, including ruins, ponds, a waterfall, and a pine forest.');
INSERT INTO trail VALUES(18,'Kelly''s Run Loop Trail',3.7999999999999998223,NULL,'https://www.lancasterconservancy.org/preserve/kellys-run-pinnacle/',NULL,1,'https://www.lancasterconservancy.org/wp-content/uploads/2013/07/Kellys-Run-Pinnacle-1.pdf','https://www.google.com/maps/place/Kelly''s+Run+Nature+Preserve/@39.8407981,-76.3173044,15z/data=!4m5!3m4!1s0x0:0xbc4079e3ef5ed495!8m2!3d39.8407981!4d-76.3173044','https://www.alltrails.com/trail/us/pennsylvania/kellys-run-loop-trail',NULL,NULL);
INSERT INTO trail VALUES(19,'Elk Trail',15.80000000000000071,1,'http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_003251.pdf','yellow',0,'http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_003251.pdf','https://www.google.com/maps/dir/407+Wigard+Ave,+Philadelphia,+PA+19128,+USA/Elk+State+Forest,+Benezette+Township,+PA+15868/@40.7003408,-77.9438492,8z/data=!3m1!4b1!4m14!4m13!1m5!1m1!1s0x89c6b8d4002c73d1:0x2d5cbe20e70dfe61!2m2!1d-75.242097!2d40.044923!1m5!1m1!1s0x89cdcaa7a3871b71:0xee7e0e2c75614d8f!2m2!1d-78.2914009!2d41.3333946!3e0','https://www.alltrails.com/trail/us/pennsylvania/elk-trail',NULL,'Start this 16-mile backpack from the trailhead on PA 555 and tackle some of the country’s newest elk habitat. Go in October for bugling.');
INSERT INTO trail VALUES(20,'Quehanna Trail',73,3,'https://www.kta-hike.org/quehanna-trail.html',NULL,1,'http://www.dcnr.pa.gov/StateForests/FindAForest/Elk/Pages/Maps.aspx','https://www.google.com/maps/place/Quehanna+Wild+Area/@41.2742257,-78.274187,14z/data=!3m1!4b1!4m5!3m4!1s0x89cc35a8db83a64f:0x80b28b5af944206b!8m2!3d41.2742275!4d-78.2566774','https://www.alltrails.com/trail/us/pennsylvania/quehanna-trail',NULL,'Map is split into east and west sections, so the map URL goes to a map listing. Favorite on Backpacking and Hiking PA FB page. 20 mile loop can be done by using West Cross Connector when starting from Parker Dam. ');
INSERT INTO trail VALUES(21,'French Creek Trail',2.7999999999999998223,1,'http://www.eastpikeland.org/index.asp?Type=B_BASIC&SEC=%7B26794F70-D1CC-4B2E-9580-3F01B6E2DE87%7D','',0,'http://www.eastpikeland.org/vertical/Sites/%7B3F7567AD-BA35-41A6-9117-FD7892D5A0DA%7D/uploads/FCT_map_mini-2016.pdf','http://www.eastpikeland.org/index.asp?Type=B_BASIC&SEC=%7B26794F70-D1CC-4B2E-9580-3F01B6E2DE87%7D','https://www.alltrails.com/explore/trail/us/pennsylvania/french-creek-trail',NULL,NULL);
INSERT INTO trail VALUES(22,'Pennypack Trail - Montco',5.4000000000000003552,1,'https://www.montcopa.org/922/Pennypack-Trail',NULL,0,'https://www.montcopa.org/DocumentCenter/View/16976',NULL,NULL,NULL,NULL);
INSERT INTO trail VALUES(23,'Pennypack Trail -',10.699999999999999289,1,'http://pecpa.org/wp-content/uploads/10-Trail-Itineraroes-Brochure.pdf',NULL,0,'http://pecpa.org/wp-content/uploads/10-Trail-Itineraroes-Brochure.pdf','https://www.google.com/search?client=firefox-b-1-ab&q=Pennypack+Trail&npsic=0&rflfq=1&rlha=0&rllag=40085474,-75051333,4347&tbm=lcl&ved=0ahUKEwj9zojQ3LfaAhUQMt8KHdhiBVIQtgMIPA&tbs=lrf:!2m4!1e17!4m2!17m1!1e2!2m1!1e2!3sIAE,lf:1,lf_ui:1&rldoc=1#rlfi=hd:;si:;mv:!1m3!1d115036.07068462444!2d-75.11269000000001!3d40.0518721!2m3!1f0!2f0!3f0!3m2!1i136!2i226!4f13.1;tbs:lrf:!2m1!1e2!2m4!1e17!4m2!17m1!1e2!3sIAE,lf:1,lf_ui:1',NULL,NULL,'Philly part of this trail in Pennypack park from Delaware River to Montco section.');
INSERT INTO trail VALUES(24,'Fern Rock Trail',2.2999999999999998223,1,'http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_002943.pdf',NULL,1,'http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_002943.pdf',NULL,'http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_002943.pdf',NULL,NULL);
INSERT INTO trail VALUES(25,'Green Ribbon Trail',12.599999999999999644,NULL,'http://www.wvwa.org/greenribbontrail/','green',0,'http://www.wvwa.org/greenribbontrail/','https://maps.google.com/maps/ms?hl=en&ie=UTF8&msa=0&msid=208160228692492834309.000447f32cfa637a25f70&t=m&ll=40.190217,-75.263729&spn=0.050617,0.094585&source=embed',NULL,NULL,'Google maps are broken into north and south; see main url for links to both.');
INSERT INTO trail VALUES(26,'Flat Rock Trail',1.1000000000000000888,'','http://www.dcnr.pa.gov/StateParks/FindAPark/LinnRunStatePark/Pages/Hiking.aspx',NULL,0,'http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_003750.pdf','https://www.google.com/maps/place/Linn+Run+State+Park/@40.1709466,-79.2403881,16z/data=!4m5!3m4!1s0x0:0x2710a8b537513aa7!8m2!3d40.1734675!4d-79.2360322','https://www.alltrails.com/trail/us/pennsylvania/flat-rock-trail--2',NULL,NULL);
INSERT INTO trail VALUES(27,'Glen Onoko Trail',0.75,4,'https://uncoveringpa.com/hiking-glen-onoko','none',0,NULL,NULL,NULL,NULL,NULL);
INSERT INTO trail VALUES(28,'Shades of Death Trail',2.2000000000000001776,'',NULL,NULL,0,'',NULL,'https://www.alltrails.com/trail/us/pennsylvania/shades-of-death-trail',NULL,NULL);
INSERT INTO trail VALUES(29,'Thousand Steps',3.3999999999999999111,4,NULL,NULL,0,NULL,'https://www.google.com/maps/place/Thousand+Steps/@40.39142,-77.9133518,15z/data=!4m5!3m4!1s0x0:0x992d38b3dd5dba2f!8m2!3d40.39142!4d-77.9133518','https://www.alltrails.com/trail/us/pennsylvania/thousand-steps',NULL,'Steep climb at 3.5 hrs out.');
INSERT INTO trail VALUES(30,'Conestoga Trail',14.30000000000000071,3,'https://www.lancasterhikingclub.com/trail-guide','orange',0,'https://www.lancasterhikingclub.com/trail-guide',NULL,'https://www.alltrails.com/trail/us/pennsylvania/conestoga-trail-holtwood-to-pequea',NULL,'Backpacking FB advice: park at pequea or southern pinnacle');
INSERT INTO trail VALUES(31,'Kelly''s Run - Pinnacle Overlook',7,NULL,'http://www.midatlantichikes.com/id96.html',NULL,1,NULL,'https://www.google.com/maps?f=q&hl=en&q=39.8401,-76.3193&layer=&ie=UTF8&z=12&ll=39.850457,-76.319275&spn=0.114392,0.344009&om=1&iwloc=addr',NULL,NULL,'GPS: 39.974802,-76.3383224');
INSERT INTO trail VALUES(32,'West Rim Trail',30.499999999999999999,3,'http://www.pinecrk.com/westrimtrail/westrimtrail.html','orange',0,'http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_20029280.pdf',NULL,'https://www.alltrails.com/trail/us/pennsylvania/west-rim-trail',NULL,'Map in 2 parts, and this is southern: < http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_002046.pdf >/ Some sites say it is 26.5 miles in length.');
INSERT INTO trail VALUES(33,'Pine Creek Trail',62,1,'https://www.traillink.com/trail/pine-creek-rail-trail/','',0,'https://visitpottertioga.com/wp-content/uploads/2017/04/pine-creek-rail-trail-map.pdf','','https://www.alltrails.com/trail/us/pennsylvania/pine-creek-trail--2',NULL,'The DCNR maps for West Rim Trail also include a portion of this trail.');
INSERT INTO trail VALUES(34,'Mason-Dixon Trail',199,NULL,'http://masondixontrail.wixsite.com/mdts','blue, sky ',0,NULL,NULL,NULL,NULL,'GPS coordinates: 39.53899, -75.6673');
INSERT INTO trail VALUES(35,'Conewago Recreation Trail',5,1,'https://www.co.lancaster.pa.us/268/Conewago-Recreation-Trail',NULL,0,'https://www.co.lancaster.pa.us/DocumentCenter/View/454','https://www.co.lancaster.pa.us/DocumentCenter/View/454',NULL,NULL,'A Rail Trail.');
INSERT INTO trail VALUES(36,'Minister Creek Hiking Trail',6.5999999999999996447,NULL,'https://www.fs.usda.gov/recarea/allegheny/recreation/recarea?recid=6104&actid=29','gray diamonds',1,'See main web page',NULL,'https://www.alltrails.com/trail/us/pennsylvania/minister-creek-trail',NULL,'Map on main web page.');
INSERT INTO trail VALUES(37,'Rausch Gap Loop',10.599999999999999644,'','http://www.midatlantichikes.com/rauschgap.htm','',1,'http://mrhyker.tripod.com/maps/sgl211-rauschgap.jpg','https://www.google.com/maps/place/40%C2%B031''32.9%22N+76%C2%B032''18.6%22W/@40.52114,-76.550031,15z/data=!4m5!3m4!1s0x0:0x0!8m2!3d40.5258!4d-76.5385?hl=en','https://www.alltrails.com/explore/recording/rausch-gap-hike',NULL,'2 hours from home, 100 miles.');
INSERT INTO trail VALUES(38,'AT-Old Horse-Shoe Trail Loop',10,3,'http://www.midatlantichikes.com/at-horseshoe.htm',NULL,NULL,'http://mrhyker.tripod.com/maps/sgl211-at-horseshoe.jpg','https://www.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=40.4522,-76.7763&aq=&sll=40.492793,-76.675882&sspn=0.066187,0.181103&ie=UTF8&z=16',NULL,NULL,'2 hours from home, 100 miles');
INSERT INTO trail VALUES(39,'Tank Hollow Trail',3.5,1,'https://www.theoutbound.com/pennsylvania/hiking/hike-to-tank-hollow-vista',NULL,NULL,NULL,'https://www.google.com/search?q=Tank+Hollow+Vista&ie=utf-8&oe=utf-8&client=firefox-b-1-ab','https://www.alltrails.com/trail/us/pennsylvania/tank-hollow-trail',NULL,NULL);
INSERT INTO trail VALUES(40,'Barbour Rock Trail',0.69999999999999995559,1,'https://uncoveringpa.com/hiking-the-barbour-rock-trail',NULL,1,'http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_20029288.pdf','https://www.google.com/maps/place/Barbour+Rock+Trail,+Shippen+Township,+PA+16901/@41.721497,-77.4871409,13z/data=!4m5!3m4!1s0x89ce24bea2042b55:0x9feb633f44514b96!8m2!3d41.721493!4d-77.4521166','https://www.alltrails.com/trail/us/pennsylvania/barbour-rock-west-rim-trail',NULL,'The best, easily-accessible spot from which to view the PA Grand Canyon is on the Barbour Rock Trail. NOTE: Need to link to Colton Point State Park when that park is entered into the database. ');
INSERT INTO trail VALUES(41,'Hawk Rock via Appalachian Trail',1.6000000000000000888,3,'http://duncannonatc.org/hawk-rock-report/','',0,NULL,'https://www.google.com/maps/place/Appalachian+Trail+-+Hawk+Rock+Overlook/@40.3758069,-77.0409467,15z/data=!4m5!3m4!1s0x0:0x3b5dae417575b51f!8m2!3d40.3758069!4d-77.0409467','https://www.alltrails.com/trail/us/pennsylvania/hawk-rock-via-appalachian-trail',NULL,'In a recommendation for trails near Harrisburg.');
INSERT INTO trail VALUES(42,'Mount Minsi via Appalachian Trail',5.2999999999999998223,4,'https://www.njhiking.com/best-hikes-mt-minsi/',NULL,1,'https://www.google.com/maps/place/Mt.+Minsi+-+Appalachian+Trail+Parking/@40.9791242,-75.1748721,13z/data=!4m5!3m4!1s0x89c487c4d0a96745:0x7006ffd7aed196c4!8m2!3d40.9798378!4d-75.1421506','https://www.google.com/maps/place/Mt.+Minsi+-+Appalachian+Trail+Parking/@40.9791242,-75.1748721,13z/data=!4m5!3m4!1s0x89c487c4d0a96745:0x7006ffd7aed196c4!8m2!3d40.9798378!4d-75.1421506','https://www.alltrails.com/trail/us/pennsylvania/mount-minsi-via-appalachian-trail',NULL,'Sttep and rocky, but results in a great view. ');
INSERT INTO trail VALUES(43,'Golden Eagle Trail',10.599999999999999644,3,'http://www.docs.dcnr.pa.gov/forestry/recreation/hiking/stateforesttrails/goldeneagletrail/index.htm','',1,'http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_002041.pdf','http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_002041.pdf','https://www.alltrails.com/trail/us/pennsylvania/golden-eagle-trail','','On FB hiking group discussion, someone state it was the best day hike in PA. ');
INSERT INTO trail VALUES(44,'Pacific Coast Trail',2650,'','https://www.pcta.org/',NULL,0,NULL,NULL,NULL,NULL,NULL);
INSERT INTO trail VALUES(45,'Cold Run Extended Loop Trail',4.7000000000000001776,3,'https://endlessmountains.wordpress.com/2018/01/09/cold-run-trail-worlds-end-state-park/','yellow',1,NULL,NULL,'https://www.alltrails.com/trail/us/pennsylvania/cold-run-extended-loop-trail',NULL,NULL);
INSERT INTO trail VALUES(46,'Pinchot Trail System',23,3,'https://www.kta-hike.org/pinchot-trail.html','orange',1,'http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_002043.pdf','https://www.google.com/maps/place/Spruce+Swamp+Natural+Area,+Thornhurst+Township,+PA+18424/@41.2009396,-75.7591427,11z/data=!4m5!3m4!1s0x89c4e49d3e139737:0x63d2f14c1d7b5d72!8m2!3d41.2008849!4d-75.6193539','https://www.alltrails.com/trail/us/pennsylvania/pinchot-trail-full',NULL,'New maps, because parts were rerouted. For some details: https://endlessmountains.wordpress.com/2017/10/26/hiking-the-new-re-routes-of-the-pinchot-trail-south-loop/ . Also, here: https://www.facebook.com/165829503626553/photos/a.671747366368095/934606313415531/?type=3&theater');
INSERT INTO trail VALUES(47,'Sandy Bottom Vista-SGL 134',0.75,'','https://endlessmountains.wordpress.com/2018/10/24/sandy-bottom-vista-sgl-134/?fbclid=IwAR2uPK2hLF2mNJWdjSxkHTWhaolASFByTUvPllATwogquuqfK-G83FKOqrA',NULL,NULL,NULL,NULL,NULL,NULL,'No real trail, but explicit instructions in the link.');
INSERT INTO trail VALUES(48,'Treweryn Farm Trail',2.1000000000000000888,1,'https://www.facebook.com/pages/Treweryn-Farms-Trail/112970622202742',NULL,0,'https://www.lowergwynedd.org/media/5181/Treweryn-Farm-Trail.pdf','https://www.google.com/maps/place/Treweryn+Farm+Trail/@40.1933267,-75.239725,17z/data=!4m13!1m7!3m6!1s0x89c6a4364d80dd6d:0xb832f0c8e923116c!2s105+Potters+Way,+North+Wales,+PA+19454!3b1!8m2!3d40.2279004!4d-75.2097541!3m4!1s0x89c6a4984fda9bd1:0xc1a3762a84fff2de!8m2!3d40.1917279!4d-75.2383272','https://www.alltrails.com/trail/us/pennsylvania/treweryn-farm-trail',NULL,'Saw this driving back from Fox Loop Trail, and looked it up. ');
INSERT INTO trail VALUES(49,'Black Forest Trail',42,'','http://www.pahikes.com/trails/black-forest-trail',NULL,1,'http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_20032741.pdf',NULL,'https://www.alltrails.com/trail/us/pennsylvania/black-forest-north-loop-trail',NULL,'Favorite on Backpacking and Hiking PA FB page');
INSERT INTO trail VALUES(50,'PA Wilds Trail',171,'','https://endlessmountains.wordpress.com/2018/11/20/pa-wilds-trail/',NULL,0,'https://endlessmountains.wordpress.com/2018/11/20/pa-wilds-trail/','',NULL,NULL,'Not a single trail, but interconnected trails. See web site for components');
INSERT INTO trail VALUES(51,'Buttermilk Falls Trail',1.3999999999999999111,7,'https://www.nps.gov/dewa/planyourvisit/buttermilk-falls-trail.htm',NULL,0,'https://www.nps.gov/dewa/planyourvisit/maps.htm','https://www.google.com/maps/place/41%C2%B008''13.4%22N+74%C2%B053''20.7%22W/@41.137037,-74.889078,15z/data=!4m5!3m4!1s0x0:0x0!8m2!3d41.137042!4d-74.889084?hl=en',NULL,NULL,'Beautiful multi-step water fall');
INSERT INTO trail VALUES(52,'Trails in Delaware Water Gap','','','https://www.nps.gov/dewa/planyourvisit/trails.htm',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO trail VALUES(53,'Fairground Falls',1,'','https://endlessmountains.wordpress.com/2019/01/08/fairground-falls-loyalsock-state-forest/','off-trail route',0,NULL,'https://www.google.com/maps/place/41%C2%B029''13.8%22N+76%C2%B035''17.1%22W/@41.487172,-76.590274,17z/data=!3m1!4b1!4m5!3m4!1s0x0:0x0!8m2!3d41.487172!4d-76.58808',NULL,NULL,'New falls on the Endless Mountain blog. Simple map on the blog. Google map to the trailhead.');
INSERT INTO trail VALUES(54,'Standing Stone Trail',80,'','https://www.standingstonetrail.org/',NULL,0,'https://www.standingstonetrail.org/lessons-and-guides',NULL,'https://www.alltrails.com/trail/us/pennsylvania/standing-stone-trail--2',NULL,'There are several maps on Alltrails, so look before you go. ');
INSERT INTO trail VALUES(55,'North Pocono Trail System',7,NULL,'http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_20033796.pdf',NULL,1,'http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_20033796.pdf',NULL,NULL,NULL,NULL);
INSERT INTO trail VALUES(56,'Ketchum Run Gorge Loop-Loyalsock State Forest',7,'','https://endlessmountains.wordpress.com/2019/03/14/ketchum-run-gorge-loop-loyalsock-state-forest/',NULL,1,'','https://www.google.com/maps/place/41%C2%B026''16.5%22N+76%C2%B036''28.8%22W/@41.437902,-76.607993,17z/data=!3m1!4b1!4m5!3m4!1s0x0:0x0!8m2!3d41.437902!4d-76.607993','https://www.alltrails.com/trail/us/pennsylvania/ketchum-run-gorge',NULL,NULL);
INSERT INTO trail VALUES(57,'Red Brook Gorge Loop-SGL 57',5.5,'','https://endlessmountains.wordpress.com/2019/03/08/red-brook-gorge-loop-sgl-57/','none',1,'https://drive.google.com/file/d/18XCyYAVgkjwNPpte10GxqGkNH2GrHA2I/view','https://www.google.com/maps/place/41%C2%B028''00.6%22N+76%C2%B009''42.3%22W/@41.4668373,-76.163944,17z/data=!3m1!4b1!4m5!3m4!1s0x0:0x0!8m2!3d41.466841!4d-76.161737','N/A','About 50 mins drive from Camp Elk Tannery on opposite side of Ricketts Glen',NULL);
INSERT INTO trail VALUES(58,'Water Trail Guides Index - PA Fish and Game Commission',NULL,NULL,'https://pfbc.pa.gov/WaterTrail.htm','',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO trail VALUES(59,'Appalachian-NJ',72,'','https://thetrek.co/appalachian-trail/appalachian-trail-state-profile-new-jersey/','white',0,'',NULL,NULL,NULL,'This article just discusses the segment running through NJ, and gives the highlights. ');
INSERT INTO trail VALUES(60,'Blackberry Gorge','','','https://endlessmountains.wordpress.com/2018/11/27/exploring-blackberry-run-gorge-sgl-13/','none',1,'https://endlessmountains.wordpress.com/2018/11/27/exploring-blackberry-run-gorge-sgl-13/',NULL,NULL,NULL,'This is not an official trail, but there are old logging roads (look for trail-like depressions in the topo map in the article - may need to download and zoom to see clearly).');
INSERT INTO trail VALUES(61,'Old Loggers Path to Long Run Trail',16.699999999999999289,3,'https://www.alltrails.com/explore/trail/us/pennsylvania/old-loggers-path-to-long-run-trail',NULL,1,NULL,NULL,'https://www.alltrails.com/explore/trail/us/pennsylvania/old-loggers-path-to-long-run-trail',NULL,'This would be a good loop for an overnight backpacking trip. OLP, but wouldn''t take as long. ');
INSERT INTO trail VALUES(62,'West Rim and Bohen Trail Loop',8.1999999999999992894,'','https://uncoveringpa.com/bohen-falls-trail','',1,'','https://www.google.com/maps/place/Parking+Bohen+Run+Falls+Hike/@41.5563031,-77.3818149,15z/data=!4m5!3m4!1s0x0:0x5e81a41cc24c0b73!8m2!3d41.5563031!4d-77.3818149','https://www.alltrails.com/trail/us/pennsylvania/west-rim-bohen-trail-loop',NULL,'Pennsylvania Grand Canyon and Pine Creek. Waterfalls.');
INSERT INTO trail VALUES(63,'Stony Fork Loop-Mid State Trail',4.5,'','https://endlessmountains.wordpress.com/2019/11/25/stony-fork-loop-mid-state-trail/',NULL,1,'https://endlessmountains.wordpress.com/2019/11/25/stony-fork-loop-mid-state-trail/',replace('https://www.google.com/maps/search/41.596694,+-77.367806?sa=X&ved=2ahUKEwjN_6u4s5XmAhWql-AKHV2cAewQ8gEwAHoECAwQAQ\n','\n',char(10)),NULL,NULL,'Runs part of it on the Mid State Trail. ');
INSERT INTO trail VALUES(64,'Valley View-Ricketts Glen State Park',2,3,'https://endlessmountains.wordpress.com/2019/12/03/hike-to-valley-view-ricketts-glen-state-park/','yellow',0,'https://endlessmountains.wordpress.com/2019/12/03/hike-to-valley-view-ricketts-glen-state-park/','https://www.google.com/maps/place/Rt.+118+Trailhead+Parking,+Fairmount+Township,+PA+18656/@41.3027811,-76.2743817,16z/data=!4m8!1m2!2m1!1sglens+trailhead!3m4!1s0x89c56586c402a8b3:0x1c80607477849f08!8m2!3d41.3002377!4d-76.2723497',NULL,NULL,'New trail in Ricketts Glen not on state park maps or on Alltrails.com.');
INSERT INTO trail VALUES(65,'Mountain Springs and Cherry Run Loop-Ricketts Glen State Park',5.5,NULL,'https://endlessmountains.wordpress.com/2019/12/18/mountain-springs-and-cherry-run-loop-ricketts-glen-state-park/','red then yellow then red',1,NULL,'https://endlessmountains.wordpress.com/2019/12/18/mountain-springs-and-cherry-run-loop-ricketts-glen-state-park/',NULL,NULL,'Nice winter trail when Falls Trail has ice hiking requirements. ');
INSERT INTO trail VALUES(66,'Ghost Town Trail',46,'','https://www.indianacountyparks.org/trails/ghosttown_trail.aspx',NULL,0,'https://www.indianacountyparks.org/downloads/ghosttown-trail/ghost-town-trail-combined-maps.pdf','https://www.google.com/maps/search/https:%2F%2Fwww.alltrails.com%2Ftrail%2Fus%2Fpennsylvania%2Fghost-town-trail/@40.4849069,-78.942243,17z/data=!3m1!4b1','https://www.alltrails.com/trail/us/pennsylvania/ghost-town-trail',NULL,'2020 Trail of the Year < https://www.pennlive.com/life/2020/01/pennsylvanias-ghost-town-trail-named-2020-trail-of-the-year.html >. An estimated 80,000 users each year enjoy Ghost Town Trail , which was designated as a National Recreation Trail in June 2003 and was ranked seventh on the “Best Hiking Trails in the United States” list by American Towns Media in 2016.');
INSERT INTO trail VALUES(67,'Cold Run Trail',1.5,3,'https://uncoveringpa.com/cold-run-trail-worlds-end-state-park','yellow',1,'https://uncoveringpa.com/cold-run-trail-worlds-end-state-park','https://www.alltrails.com/explore/trail/us/pennsylvania/cold-run-extended-loop-trail?ref=sidebar-static-map','https://www.alltrails.com/explore/trail/us/pennsylvania/cold-run-extended-loop-trail?ref=sidebar-static-map',NULL,'This three-mile trail was completed in recent years and is so new that it doesn’t even appear on the park maps. ');
INSERT INTO trail VALUES(68,'North Country Trail',4600,'','https://northcountrytrail.org/trail/',NULL,0,'https://northcountrytrail.org/trail/maps/',NULL,NULL,NULL,NULL);
CREATE TABLE IF NOT EXISTS "park" (
`park_id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
`name` TEXT NOT NULL UNIQUE,
`address` TEXT,
`city` TEXT,
`state` TEXT,
`zip_code` INTEGER,
`phone` TEXT,
`url` TEXT,
`map_url` TEXT,
`map_google` TEXT,
`alltrails` TEXT,
`gps_lat` NUMERIC,
`gps_long` NUMERIC,
`police_1_id` INTEGER,
`police_2_id` INTEGER,
`medical_1_id` INTEGER,
`medical_2_id` INTEGER,
`drive_time` NUMERIC,
`drive_miles` INTEGER,
`rating` INTEGER,
`comment` TEXT
);
INSERT INTO park VALUES(1,'French Creek','843 Park Rd','Elverson','PA',19520,'610-582-9680','http://www.dcnr.pa.gov/StateParks/FindAPark/FrenchCreekStatePark/Pages/default.aspx','http://www.dcnr.pa.gov/StateParks/FindAPark/FrenchCreekStatePark/Pages/Maps.aspx','https://www.google.com/maps/place/French+Creek+State+Park/@40.198383,-75.7940178,17z/data=!3m1!4b1!4m5!3m4!1s0x89c663171f5b8949:0x7ee5dd07e455886c!8m2!3d40.1983789!4d-75.7918238',NULL,40.198399999999999466,-75.791799999999994951,911,NULL,911,'Reading Hospital',1,47,3,'Zack and I had our first campout here with PIC in a Group Camping site. It was also the fIrst state park that Zack and I used extensively when he was growing up. Favorite places included Miller''s Point and Hopewell Lake. ');
INSERT INTO park VALUES(2,'Fairmount-Wissahickon','','Philadelphia','PA',19128,'215-247-0417','https://www.fow.org/','https://www.fow.org/visit-the-park/maps/','https://www.google.com/maps/d/u/0/viewer?mid=13bnd0IRNwzTpI7VFPASNSWXC5yk&ll=40.04902385438254%2C-75.2114775&z=12',NULL,NULL,NULL,911,NULL,911,'Roxborough Hospital',0.080000000000000001665,1,5,'');
INSERT INTO park VALUES(3,'Allegheny National Forest','4 Farm Colony Drive','Warren','PA',16235,'814-723-5150','https://www.fs.usda.gov/main/allegheny/home','https://www.fs.usda.gov/detailfull/allegheny/maps-pubs/?cid=FSMRS_073013&width=full','https://www.google.com/maps/place/Allegheny+National+Forest/@41.6487867,-79.2863031,10z/data=!4m5!3m4!1s0x89cd23ea28582a9b:0xf07b8e42353dcfd3!8m2!3d41.6487827!4d-79.0061464',NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,300,NULL,NULL);
INSERT INTO park VALUES(4,'Lehigh Gorge - Rockport Access','See GPS','Rockport','PA',NULL,'570-443-0400','http://www.dcnr.pa.gov/StateParks/FindAPark/LehighGorgeStatePark/Pages/default.aspx','http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_003766.pdf','https://www.google.com/maps/place/Rockport,+Lehigh+Township,+PA+18255/data=!4m2!3m1!1s0x89c5ab9d1e0e97d7:0xd51c13164ae0c7f?sa=X&ved=0ahUKEwik4bKriaPaAhVSylMKHbtjCRMQ8gEIiAEwCg',NULL,40.966700000000002999,-75.755099999999998771,NULL,NULL,'Lehigh Valley Hospital-Hazleton',NULL,1.6999999999999999555,94,NULL,'Rockport is one of 3 entrances to the park. It is administered from nearby Hickory Run State Park.');
INSERT INTO park VALUES(5,'Hopewell Furnace','2 Mark Bird Lane ','Elverson','PA',19520,'610-582-8773','https://www.nps.gov/hofu/index.htm','https://www.nps.gov/hofu/planyourvisit/maps.htm','https://www.google.com/maps?ll=40.198611,-75.775556&q=40.198611,-75.775556&hl=en&t=m&z=14',NULL,40.20689999999999742,-75.77349999999999852,911,NULL,911,NULL,1,43,3,'Located in southeastern Berks County, near Elverson, Pennsylvania, is an example of an American 19th century rural "iron plantation". The buildings include a blast furnace, and auxiliary structures.');
INSERT INTO park VALUES(6,'Dead Man''s Hollow Conservation Area','Sceneridge Road, McKeesport, PA 15133','McKeesport','PA',15133,'412-741-2750','https://alleghenylandtrust.org/green-space/dead-mans-hollow/','https://alleghenylandtrust.org/wp-content/uploads/2017/05/2017-DMH-Trial-Map-UPDATES.jpg','https://www.google.com/maps/place/Dead+Man''s+Hollow+Conservation+Area/@40.3207147,-79.859266,17z/data=!3m1!4b1!4m5!3m4!1s0x8834e5ba0087f313:0x1cce73ddc3e0a78e!8m2!3d40.3133509!4d-79.84508',NULL,40.313350900000003208,-79.845079999999995835,NULL,NULL,NULL,NULL,5.0999999999999996447,300,NULL,'Maintained by Allegheny Land Trust. Several ruins on the trails. ');
INSERT INTO park VALUES(7,'State Game Lands 211','','Halifax','PA',17032,'717-787-4250','https://www.alltrails.com/parks/us/pennsylvania/state-game-lands-number-211','http://www.pgc.pa.gov/HuntTrap/StateGameLands/Documents/SGL%20Maps/SGL__211.pdf','https://www.google.com/maps/place/State+Game+Lands+No+211/@40.4744766,-76.6528225,15z/data=!4m2!3m1!1s0x0:0x17d00464251ccd60?sa=X&ved=0ahUKEwjok8OhvqjaAhUrrlkKHXWmDw0Q_BIIlwEwCg',NULL,40.474476600000002688,-76.652822499999999196,NULL,NULL,NULL,NULL,2,96,NULL,NULL);
INSERT INTO park VALUES(8,'Loyalsock State Forest','6735 Route 220','Dushore, PA 18614','PA',18614,'570-946-4049','http://www.dcnr.pa.gov/StateForests/FindAForest/Loyalsock/Pages/default.aspx','http://www.dcnr.pa.gov/StateForests/FindAForest/Loyalsock/Pages/Maps.aspx','http://www.dcnr.pa.gov/StateForests/FindAForest/Loyalsock/Pages/Maps.aspx','https://www.alltrails.com/parks/us/pennsylvania/loyalsock-state-forest',NULL,NULL,NULL,NULL,NULL,NULL,3.2999999999999998223,170,NULL,'Address is for Loyalsock District Office. See destination db, place_id 68 for a link about things to do here.');
INSERT INTO park VALUES(9,'Valley Forge','1400 N Outer Line Dr.','King of Prussia','PA',19406,'610-783-1000','https://www.nps.gov/vafo/index.htm',NULL,'http://www.hstrail.org/',NULL,NULL,NULL,911,NULL,911,NULL,0.5,16,NULL,NULL);
INSERT INTO park VALUES(10,'Michaux','10099 Lincoln Way East','Fayetteville','PA',17222,'717-352-2211','http://www.dcnr.pa.gov/StateForests/FindAForest/Michaux/Pages/default.aspx','http://www.dcnr.pa.gov/StateForests/FindAForest/Michaux/Pages/Maps.aspx','https://www.google.com/maps/place/Michaux+State+Forest/@39.9972172,-77.3670101,15z/data=!4m2!3m1!1s0x0:0x9d24777ad1cfd151?sa=X&ved=0ahUKEwj4477p_araAhXo4IMKHUKNBAsQ_BIIpQEwDg','https://www.alltrails.com/parks/us/maryland/michaux-state-forest',NULL,NULL,NULL,NULL,NULL,NULL,2.2999999999999998223,142,NULL,'Address is District Office.');
INSERT INTO park VALUES(11,'Pine Grove Furnace','1100 Pine Grove Road','Gardners','PA',17324,'717-486-7174','http://www.dcnr.pa.gov/StateParks/FindAPark/PineGroveFurnaceStatePark/Pages/default.aspx','http://www.dcnr.pa.gov/StateParks/FindAPark/PineGroveFurnaceStatePark/Pages/Maps.aspx','https://www.google.com/maps/place/Pine+Grove+Furnace+State+Park/@40.0327304,-77.2932641,15z/data=!4m2!3m1!1s0x0:0xff06e8ebff6f3fdb?sa=X&ved=0ahUKEwjJl9rtgKvaAhXo3YMKHWwmDrUQ_BIIxQEwCg','https://www.alltrails.com/parks/us/pennsylvania/pine-grove-furnace-state-park',40.031111000000002774,-77.306667000000004463,911,NULL,911,'UPMC Pinnacle Carlisle',2.2999999999999998223,130,NULL,'This 696-acre park features Laurel Lake, Fuller Lake, hiking, biking & the Appalachian Trail Museum. Park is surrounded by Michaux State Forest. Recommended Visits: Pole Steeple Vista at sunset, Sunset Rocks, Tumbling Run, and the AT Museum.');
INSERT INTO park VALUES(12,'Delaware Water Gap','1978 River Road ','Bushkill','PA',18324,'570-426-2452','https://www.nps.gov/dewa/index.htm','https://www.nps.gov/dewa/planyourvisit/maps.htm','https://www.google.com/maps/place/Delaware+Water+Gap+National+Recreation+Area/@41.1043946,-74.9442586,15z/data=!4m2!3m1!1s0x0:0xfd39a58f82825bf9?sa=X&ved=0ahUKEwiRh6_sk63aAhUsuVkKHYA2BQMQ_BIIsAEwCg','https://www.alltrails.com/parks/us/pennsylvania/delaware-water-gap-national-recreation-area',40.967500000000001136,-75.122221999999993615,NULL,NULL,NULL,NULL,2,100,NULL,'See also: https://www.nationalparks.org/explore-parks/delaware-water-gap-national-recreation-area');
INSERT INTO park VALUES(13,'Worlds End','215 East Water St','Muncy','PA',17756,'570-546-8282','http://www.dcnr.pa.gov/StateParks/FindAPark/WorldsEndStatePark/Pages/default.aspx','http://www.dcnr.pa.gov/StateParks/FindAPark/WorldsEndStatePark/Pages/Maps.aspx','https://www.google.com/maps/place/Worlds+End+State+Park/@41.4666991,-76.5753685,15z/data=!4m2!3m1!1s0x0:0x8818f0f94e3c87cb?sa=X&ved=0ahUKEwiKlqye2K3aAhUhVd8KHXpDA-YQ_BII3QEwDw','https://www.alltrails.com/parks/us/pennsylvania/worlds-end-state-park',41.471389000000002055,-76.568611000000004196,911,NULL,911,'UPMC Susquehanna Muncy Valley Hospital',2.8999999999999999111,154,4,'Zack and I have been here a few times. I have a picture of him fly fishing here. Local restaurants: High Knobb Inn, Forksville General Store, Forksville Inn, Hillsgrove Hotel, The Barn Tavern. Crestmont inn Eaglesmere, really good meals, a little bit more higher end but worth it. Also, see < https://uncoveringpa.com/things-to-do-in-worlds-end-state-park >. Also, look up Dushore in the ''destinations'' table for things to do in another close town.');
INSERT INTO park VALUES(14,'Rolling Hill Park','1301 Rose Glen Rd','Gladwyne','PA',19035,'610-645-6220','http://www.lowermerion.org/services/parks-and-recreation-department/township-parks/rolling-hill-park','https://www.phillydayhiker.com/destinations/rolling-hill-park/','https://www.google.com/maps/place/Rolling+Hill+Park/@40.0401988,-75.2662452,15z/data=!4m2!3m1!1s0x0:0xa5afcc74e72545?sa=X&ved=0ahUKEwi6mOW11q_aAhUi9YMKHf4gC_YQ_BIIlwEwCg',NULL,NULL,NULL,911,NULL,911,NULL,0.5,6,NULL,'Head out on the blue trail that leads to Mill Creek where you''ll find jaw dropping ruins that date back to the early 20th century. ');
INSERT INTO park VALUES(15,'Money Rocks County Park','936 Narvon Rd','Narvon','PA',17555,'717-299-8000','https://co.lancaster.pa.us/288/Money-Rocks-County-Park','https://co.lancaster.pa.us/DocumentCenter/Home/View/229','https://www.google.com/maps/dir/39.9460422,-75.1969678/Money+Rocks+County+Park,+936+Narvon+Rd,+Narvon,+PA+17555/@40.0151498,-76.1414347,9z/data=!3m1!4b1!4m17!1m6!3m5!1s0x0:0x67b72ce25f918ef1!2sMoney+Rocks+County+Park!8m2!3d40.0952958!4d-75.9819015!4m9!1m1!4e1!1m5!1m1!1s0x89c6420579ac7689:0x67b72ce25f918ef1!2m2!1d-75.9819015!2d40.0952958!3e0','https://www.alltrails.com/trail/us/pennsylvania/money-rocks-red-trail',40.095362000000001499,-75.981933999999995421,911,'',911,'',1.1000000000000000888,57,'','');
INSERT INTO park VALUES(16,'Kelly''s Run Nature Preserve','T397','Holtwood','PA',17532,'717) 669-5990','https://www.lancasterconservancy.org/preserve/kellys-run-pinnacle/','https://www.lancasterconservancy.org/wp-content/uploads/2013/07/Kellys-Run-Pinnacle-1.pdf','https://www.google.com/maps/place/Kelly''s+Run+Nature+Preserve/@39.8407981,-76.3173044,15z/data=!4m2!3m1!1s0x0:0xbc4079e3ef5ed495?sa=X&ved=0ahUKEwj3wuCkhrPaAhWHON8KHWAOCtAQ_BIIqgEwCg','https://www.alltrails.com/trail/us/pennsylvania/kellys-run-loop-trail',NULL,NULL,911,NULL,911,NULL,1.6999999999999999555,70,NULL,NULL);
INSERT INTO park VALUES(17,'Elk State Forest','258 Sizerville Road','Emporium','PA',15834,'814-486-3353','http://www.dcnr.pa.gov/StateForests/FindAForest/Elk/Pages/default.aspx','http://www.dcnr.pa.gov/StateForests/FindAForest/Elk/Pages/Maps.aspx','https://www.google.com/maps/dir/407+Wigard+Ave,+Philadelphia,+PA+19128,+USA/Elk+State+Forest,+Benezette+Township,+PA+15868/@40.7003408,-77.9438492,8z/data=!3m1!4b1!4m14!4m13!1m5!1m1!1s0x89c6b8d4002c73d1:0x2d5cbe20e70dfe61!2m2!1d-75.242097!2d40.044923!1m5!1m1!1s0x89cdcaa7a3871b71:0xee7e0e2c75614d8f!2m2!1d-78.2914009!2d41.3333946!3e0',NULL,'41.333333, -78.291389',-78.291388999999995236,NULL,NULL,NULL,NULL,4.5,258,NULL,'Start this 16-mile backpack from the trailhead on PA 555 and tackle some of the country’s newest elk habitat. Go in October for bugling.');
INSERT INTO park VALUES(18,'Pennypack Park','8500 Pine Road','Philadelphia','PA',19136,'215-934-PARK ','https://www.friendsofpennypackpark.org/','https://static1.squarespace.com/static/59776b35a5790a44ceb72a6a/t/59c98ebc03596ef6938529b1/1506381503507/greenwaybrochure.pdf','https://www.google.com/maps/place/Pennypack+Park/@40.0500184,-75.0297117,15z/data=!4m5!3m4!1s0x0:0xce867bf401f336a0!8m2!3d40.0500184!4d-75.0297117',NULL,40.057699999999996976,-75.023399999999995204,911,NULL,911,NULL,0.59999999999999997779,14,NULL,'');
INSERT INTO park VALUES(19,'Alapocas Run State Park','','Wilmington','DE','',NULL,'http://www.destateparks.com/activities/trails/locations/alapocas-run/index.asp',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO park VALUES(20,'Linn Run State Park','770 Linn Run Rd','Rector','PA',15677,'724-238-6623','http://www.dcnr.pa.gov/StateParks/FindAPark/LinnRunStatePark/Pages/default.aspx','http://www.dcnr.pa.gov/StateParks/FindAPark/LinnRunStatePark/Pages/Maps.aspx','https://www.google.com/maps/place/Linn+Run+State+Park/@40.1734675,-79.2360322,15z/data=!4m5!3m4!1s0x0:0x2710a8b537513aa7!8m2!3d40.1734675!4d-79.2360322','https://www.alltrails.com/parks/us/pennsylvania/linn-run-state-park',40.156388999999997222,-79.231110999999998512,911,NULL,911,'Excela Latrobe Hospital',4.2999999999999998223,243,NULL,'');
INSERT INTO park VALUES(21,'Hickory Run State Park','3613 State Route 534','White Haven','PA','18661-9712','570-443-0400','http://www.dcnr.pa.gov/StateParks/FindAPark/HickoryRunStatePark/Pages/default.aspx','http://www.dcnr.pa.gov/StateParks/FindAPark/HickoryRunStatePark/Pages/Maps.aspx','https://www.google.com/maps/place/Hickory+Run+State+Park/@41.0292873,-75.6766605,15z/data=!4m2!3m1!1s0x0:0xaa81a3e6eb01b888?sa=X&ved=0ahUKEwjymbCspMbaAhViw1kKHfZjDywQ_BII1AEwDg','https://www.alltrails.com/parks/us/pennsylvania/hickory-run-state-park',41.036110999999998228,-75.683888999999993528,911,NULL,911,'Lehigh Valley Hospital-Hazleton',1.5,79,4,'Boulder field is a great feature. Want to check out ''Shades of Death'' Trail. ');
INSERT INTO park VALUES(22,'Moosic Mountain','Lackawanna County, eight miles northeast from the city of Scranton, entrance off PA-247.','Scranton','PA','',NULL,'https://www.nature.org/ourinitiatives/regions/northamerica/unitedstates/pennsylvania/placesweprotect/moosic-mountain.xml','http://www.eastcoasthiker.com/wp-content/uploads/2016/03/moosic-bike-trails-34x34-final-lowres.pdf','https://www.google.com/maps/place/The+Nature+Conservancy''s+Dick+%26+Nancy+Eales+Preserve/@41.4475072,-75.5302749,15z/data=!4m2!3m1!1s0x0:0x7774713efaaef695?sa=X&ved=0ahUKEwi43_DAqcbaAhULr1kKHXlHBXcQ_BIIkgEwCg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2.2000000000000001776,122,NULL,'Nature Conservancy Preserve is one of the best locations in the northeastern U.S. for heath barrens.');
INSERT INTO park VALUES(23,'Green Lane Park','2144 Snyder Rd','Green Lane','PA',18054,'215-234-4528','https://www.montcopa.org/871/Green-Lane-Park','https://www.montcopa.org/DocumentCenter/View/6445','https://www.google.com/maps/place/Green+Lane+Park+-+Blue+Trail/@40.3570795,-75.5120624,17z/data=!3m1!4b1!4m5!3m4!1s0x89c69d5c80c9d19d:0xc8eaa4de40108123!8m2!3d40.3570754!4d-75.5098684','https://www.alltrails.com/trail/us/pennsylvania/green-lane-park-trail',NULL,NULL,911,NULL,911,NULL,1,30,NULL,NULL);
INSERT INTO park VALUES(24,'Tucquan Glen Nature Preserve','State Rte 3017','Holtwood','PA',17532,'717-392-7891','https://www.lancasterconservancy.org/preserve/tucquan-glen/','https://www.lancasterconservancy.org/wp-content/uploads/2013/07/Tucquan-Glen.pdf','https://www.lancasterconservancy.org/wp-content/uploads/2013/07/Tucquan-Glen.pdf','https://www.alltrails.com/trail/us/pennsylvania/tucquan-glen-loop-trail',39.864593999999996753,-76.339695000000006076,911,NULL,NULL,911,1.6000000000000000888,72,'',NULL);
INSERT INTO park VALUES(25,'Bombay Hook National Wildlife Refuge','Visitor Center, 2591 Whitehall Neck Road','Smyrna','DE',19977,'302-653-9345','https://www.fws.gov/refuge/Bombay_Hook/','https://www.fws.gov/refuge/Bombay_Hook/map.html','https://www.google.com/maps/place/Bombay+Hook+National+Wildlife+Refuge/@39.2583667,-75.4550812,15z/data=!4m5!3m4!1s0x0:0x314379e15fd4ecb9!8m2!3d39.2583667!4d-75.4550812',NULL,39.259472999999999842,-75.47435799999999517,911,NULL,911,NULL,1.5,82,'',NULL);
INSERT INTO park VALUES(26,'Gunpowder Falls State Park','7200 Graces Quarters Rd','Middle River','MD',21220,'410-592-2897','http://dnr.maryland.gov/publiclands/Pages/central/gunpowder.aspx','http://dnr.maryland.gov/publiclands/Pages/central/gunpowder.aspx','https://www.google.com/maps/place/Gunpowder+Falls+State+Park/@39.425937,-76.440488,15z/data=!4m2!3m1!1s0x0:0x68e5b9a6f4d913d1?hl=en-us&sa=X&ved=0ahUKEwifkIPr-9LaAhXyc98KHWRoCCQQ_BII0AEwDw','https://www.alltrails.com/parks/us/maryland/gunpowder-falls-state-park',39.362499999999997156,-76.342500000000001136,NULL,NULL,NULL,NULL,1.8000000000000000444,97,'','Maps at bottom of park home page.');
INSERT INTO park VALUES(27,'Lock Ridge Park and Furnace Museum','525 Franklin St','Alburtis','PA',18011,'610-435-1074','https://www.lehighcounty.org/Departments/Parks-And-Recreation/Our-Parks/Lock-Ridge-Park',NULL,'https://www.google.com/maps/place/Lock+Ridge+Park+and+Furnace+Museum/@40.508899,-75.5938577,15z/data=!4m2!3m1!1s0x0:0x14c37ac7fe66988b?sa=X&ved=0ahUKEwiW0YD1k9PaAhUMz1MKHQ_TC1kQ_BIIogEwCg',NULL,40.508479999999998711,-75.593879000000001157,911,NULL,911,'Lehigh Valley Hospital',1.1999999999999999555,47,NULL,NULL);
INSERT INTO park VALUES(28,'Leonard Harrison State Park','4797 Route 660','Wellsboro','PA','16901-8970 ','570-724-3061','http://www.dcnr.pa.gov/StateParks/FindAPark/LeonardHarrisonStatePark/Pages/default.aspx','http://www.dcnr.pa.gov/StateParks/FindAPark/LeonardHarrisonStatePark/Pages/Maps.aspx','Soldiers & Sailors Memorial Hospital','https://www.alltrails.com/parks/us/pennsylvania/leonard-harrison-state-park',41.696666999999997928,-77.454443999999995186,911,NULL,911,'Soldiers & Sailors Memorial Hospital',4,221,3,'East rim of the Grand Canyon of Pennsylvania, and across from park on west rim, Colton Point State Park.');
INSERT INTO park VALUES(29,'Watkins Glen','1009 N Franklin St','Watkins Glen','NY',14891,'607-535-4511','https://parks.ny.gov/parks/142/','https://parks.ny.gov/parks/142/details.aspx','https://www.google.com/maps/place/Watkins+Glen+State+Park/@42.3670667,-76.9016911,15z/data=!4m2!3m1!1s0x0:0x7f234172786716de?sa=X&ved=0ahUKEwiCoOqC99raAhXOtlkKHSlvCLwQ_BII-wEwGA','https://www.alltrails.com/parks/us/new-york/watkins-glen-state-park',42.375895999999997343,-76.871077999999997132,NULL,NULL,NULL,'Maps are accessed from the home page.',NULL,NULL,NULL,NULL);
INSERT INTO park VALUES(30,'Stokes State Forest','1 Coursen Rd','Branchville','NJ',7826,'973-948-3820','http://www.state.nj.us/dep/parksandforests/parks/stokes.html','http://www.state.nj.us/dep/parksandforests/parks/docs/stokes_guide.pdf','https://www.google.com/maps/place/1+Coursen+Rd,+Branchville,+NJ+07826/data=!4m2!3m1!1s0x89c367cb8f3566bb:0x6952341742f0cc97?sa=X&ved=0ahUKEwjatZ3vv9raAhUEhOAKHbD9D1kQ8gEIKDAA',NULL,NULL,NULL,911,'',911,'',2.3999999999999999111,111,NULL,NULL);
INSERT INTO park VALUES(31,'Seven Tubs Natural Area','900 Bear Creek Blvd','Wilkes-Barre','PA',18702,'570-675-1312','http://www.onlyinyourstate.com/pennsylvania/paradise-pa/',NULL,'https://www.google.com/maps/place/Seven+Tubs+Nature+Area/@41.2299598,-75.8214568,15z/data=!4m2!3m1!1s0x0:0xe470c07799ef05a3?sa=X&ved=0ahUKEwit3v6n-OnaAhWjwVkKHUxdCPAQ_BII3gEwEA','https://www.alltrails.com/trail/us/pennsylvania/seven-tubs-nature-area',41.234999999999999431,-75.813900000000003843,911,'',911,replace('\nWilkes-Barre General Hospital\n','\n',char(10)),1.8000000000000000444,110,NULL,'Map of trails not found, so use Alltrails map.');
INSERT INTO park VALUES(32,'Swatara State Park','1450 Suedburg Road','Pine Grove','PA',17963,'717-865-6470','http://www.dcnr.pa.gov/StateParks/FindAPark/SwataraStatePark/Pages/default.aspx','http://www.dcnr.pa.gov/StateParks/FindAPark/SwataraStatePark/Pages/Maps.aspx','https://www.google.com/maps/place/Swatara+State+Park/@40.4932415,-76.5347098,15z/data=!4m2!3m1!1s0x0:0x8762c1d45056d5e1?sa=X&ved=0ahUKEwiskejOvPjaAhWttVkKHcKcAbQQ_BIIyAEwDg','https://www.alltrails.com/trail/us/pennsylvania/swatara-state-park',40.497222000000000718,-76.53305600000000197,911,NULL,911,'WellSpan Good Samaritan Hospital',1.8000000000000000444,97,NULL,NULL);
INSERT INTO park VALUES(33,'State Game Lands No 211',NULL,'Halifax','PA',17032,'717-787-4250',NULL,'http://www.pgc.pa.gov/HuntTrap/StateGameLands/Documents/SGL%20Maps/SGL__211.pdf','https://www.google.com/maps/place/State+Game+Lands+No+211/@40.4744766,-76.6528225,15z/data=!4m2!3m1!1s0x0:0x17d00464251ccd60?sa=X&ved=0ahUKEwjw5uSfvvjaAhUMrlkKHRwnAyEQ_BIIpQEwEg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,100,'',NULL);
INSERT INTO park VALUES(34,'Ralph Stover State Park','150 Tory Rd','Pipersville','PA',18947,'610-982-5560','http://www.dcnr.pa.gov/StateParks/FindAPark/RalphStoverStatePark/Pages/default.aspx','http://www.dcnr.pa.gov/StateParks/FindAPark/RalphStoverStatePark/Pages/Maps.aspx','https://www.google.com/maps/place/Ralph+Stover/@40.4339984,-75.0989121,15z/data=!4m5!3m4!1s0x0:0xb3897003c866a0d7!8m2!3d40.4339984!4d-75.0989121','https://hikingguy.com/hiking-trails/hiking-near-philadelphia/ralph-stover-state-park-high-rocks-hike/',40.434510000000003062,-75.097930000000005178,911,NULL,911,'Doylestown Hospital',1,36,NULL,NULL);
INSERT INTO park VALUES(35,'Blue Marsh Lake National Recreation Area','1268 Palisades Drive','Leesport','PA','19533-9750','610-376-6337','http://www.nap.usace.army.mil/Missions/Civil-Works/Blue-Marsh-Lake/','http://www.nap.usace.army.mil/Portals/39/docs/Civil/Blue_Marsh/trail%20map.pdf','https://www.google.com/maps/place/Blue+Marsh+Lake,+Pennsylvania/data=!4m2!3m1!1s0x89c6752f563af0ab:0xc3dca3abac605627?sa=X&ved=0ahUKEwjTwqjrnLjbAhXFzlkKHW1eDd4Q8gEI5gEwFQ',NULL,'40.38, -76.031389',-76.031389000000004331,911,NULL,911,'Penn State Health St. Joseph Medical Center',1.25,66,NULL,NULL);
INSERT INTO park VALUES(36,'Bear Creek Preserve','47 Rabbit Run Lane','Wilkes-Barre, Bear Creek','PA',18702,'570-647-9175','https://natlands.org/bear-creek-preserve/','https://natlands.org/wp-content/uploads/2017/05/BearCreekBrochMap-2018-02-website.pdf','https://www.google.com/maps/place/Natural+Lands''+Bear+Creek+Preserve/@41.1797526,-75.713924,15z/data=!4m5!3m4!1s0x89c4fd6be189d187:0x8f545ce4e7c4267b!8m2!3d41.1797525!4d-75.7051639',NULL,41.180576000000002068,-75.711939000000000989,NULL,NULL,NULL,NULL,1.8999999999999999111,106,'',NULL);
INSERT INTO park VALUES(37,'Mount Mitchell State Park','2388 N.C. Rt. 128','Burnsville','NC',28714,'828-675-4611','https://www.ncparks.gov/mount-mitchell-state-park','https://files.nc.gov/ncparks/maps-and-brochures/mount_mitchell_park_map.pdf','https://www.google.com/maps/search/Mount+Mitchell+State+Park/@35.7631333,-82.2739471,15z/data=!3m1!4b1?hl=en-US','https://www.alltrails.com/parks/us/north-carolina/mount-mitchell-state-park','35.7528, -82.2737',-82.273700000000005161,NULL,NULL,NULL,NULL,10.199999999999999289,634,'','Check out the map with trails in the adjacent area, including Pisgah National Forest. ');
INSERT INTO park VALUES(38,replace('\nPilot Mountain State Park','\n',char(10)),'1792 Pilot Knob Park Road','Pinnacle','NC',27043,'336-325-2355','https://www.ncparks.gov/pilot-mountain-state-park','https://files.nc.gov/ncparks/maps-and-brochures/pilot-mountain-state-park-map-mountain-section.pdf','https://www.google.com/maps/search/Pilot+Mountain+State+Park/@36.3401549,-80.4830004,15z/data=!3m1!4b1?hl=en-US','https://www.alltrails.com/parks/us/north-carolina/pilot-mountain-state-park',36.341276000000000579,-80.46293000000000006,NULL,NULL,NULL,NULL,7.75,506,'','');
INSERT INTO park VALUES(39,'Seneca State Forest','10135 Browns Creek Road','Dunmore, WV 24934 ','WV 24934 ',24934,'304-799-6213 ','https://wvstateparks.com/park/seneca-state-forest/','https://wvstateparks.com/wp-content/uploads/2017/03/SenecaStateForest_brochure_map-1.pdf','https://www.google.com/maps?ll=38.296334,-79.929461&z=16&t=m&hl=en-US&gl=US&mapclient=embed&cid=15792337368172088159','N/A','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
CREATE TABLE IF NOT EXISTS "destination" (
`place_id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
`name` TEXT NOT NULL,
`locale` TEXT,
`state` TEXT,
`country` TEXT,
`url` TEXT,
`type` TEXT NOT NULL,
`comments` TEXT
);
INSERT INTO destination VALUES(1,'San Juan','San Juan','Puerto Rico','USA','https://www.nytimes.com/2018/03/20/travel/san-juan-puerto-rico-hurricane-52-places.html','vacation',NULL);
INSERT INTO destination VALUES(2,'Ai-Petri Bridges','Yalta','Crimea','Ukraine','https://www.atlasobscura.com/places/aipetri-bridges','adventure',NULL);
INSERT INTO destination VALUES(3,'Appalachian Trail Museum','Gardners','PA','USA','https://www.atmuseum.org/','museum',NULL);
INSERT INTO destination VALUES(4,'Best Trails in Pennsylvania','','PA','USA','https://www.alltrails.com/us/pennsylvania','outdoors',NULL);
INSERT INTO destination VALUES(5,'Pennsylvania State Park Directory','','PA','USA','http://www.dcnr.pa.gov/StateParks/FindAPark/Pages/default.aspx','outdoors',NULL);
INSERT INTO destination VALUES(6,'Pennsylvania Listing - National Park Service','','PA','USA','https://www.nps.gov/state/pa/list.htm?program=parks','national_parks',NULL);
INSERT INTO destination VALUES(7,'Pennsylvania',NULL,'PA','USA','http://www.onlyinyourstate.com/pennsylvania/hike-ruins-pa/','outdoors',NULL);
INSERT INTO destination VALUES(8,'5 Best Backpacking Trails in Pennsylvania ',NULL,'PA','USA','http://www.susquehannalife.com/2018/03/19/169310/5-best-backpacking-trails-in-pennsylvania','outdoors',NULL);
INSERT INTO destination VALUES(9,'8 Trails In Pennsylvania Will Lead You To Extraordinary Ruins',NULL,'PA','USA','http://www.onlyinyourstate.com/pennsylvania/hike-ruins-pa/','outdoors',NULL);
INSERT INTO destination VALUES(10,'Stone Arch Bridge','Philadelphia','PA','USA','https://philly.curbed.com/maps/fairmount-park-things-to-do-see/stone-arch-bridge-2','outdoors',NULL);
INSERT INTO destination VALUES(11,'Nomadlist: Find your best place to live, work, and play',NULL,NULL,'World','https://nomadlist.com/','adventure',NULL);
INSERT INTO destination VALUES(12,'Selin’s Grove Brewing Co.','Selinsgrove, 121 North Market Street, 17870','PA','USA','http://www.onlyinyourstate.com/pennsylvania/selins-grove-brewing-co-pa/','dining',NULL);
INSERT INTO destination VALUES(13,'Buddy’s Log Cabin Restaurant','Pine Grove, 97 Tremont Road, 17963','PA','USA','http://www.onlyinyourstate.com/pennsylvania/buddys-log-cabin-pa/','dining',NULL);
INSERT INTO destination VALUES(14,'Hector Falls','Allegheny National Forest, Ludlow, Warren County','PA','USA','http://www.interestingpennsylvania.com/2016/01/hector-falls-allegheny-national-forest.html','outdoors',NULL);
INSERT INTO destination VALUES(15,'Lausanne Ruins – Carbon County, PA','Jim Thorpe','PA','USA','http://www.onlyinyourstate.com/pennsylvania/lausanne-ghost-town-2/','outdoors',NULL);
INSERT INTO destination VALUES(16,'Pennsylvania Waterfalls Road Trip - The Ultimate ',NULL,'PA','USA','http://www.onlyinyourstate.com/pennsylvania/pa-road-trip-waterfalls/','outdoors',NULL);
INSERT INTO destination VALUES(17,'6 Lazy Rivers In Delaware That Are Perfect For Tubing On A Summer’s Day','','DE','USA','http://www.onlyinyourstate.com/delaware/tubing-in-delaware-de/','water sports',NULL);
INSERT INTO destination VALUES(18,'Barbour Rock ','Tioga County','PA','USA','http://www.docs.dcnr.pa.gov/cs/groups/public/documents/document/dcnr_20032556.pdf','outdoors',NULL);
INSERT INTO destination VALUES(19,'Trail Tracker - The Interactive Trails Map of NJ State Parks',NULL,'NJ','USA','https://njdep.maps.arcgis.com/apps/webappviewer/index.html?id=3a27819e5c724c8b97a3c9dd43fd3d9a','outdoors',NULL);
INSERT INTO destination VALUES(20,'Hallgrimskirkja','Reykjavik','','Iceland','https://www.atlasobscura.com/places/hallgrimskirkja','vacation','The tallest building in Iceland, and certainly one of the most visually impressive.');
INSERT INTO destination VALUES(21,'Svartifoss',NULL,NULL,'Iceland','https://www.atlasobscura.com/places/svartifoss','vacation','Unique waterfall in Iceland''s south features a backdrop of geometric lava columns.');
INSERT INTO destination VALUES(22,'Bike and Barge Tours in Holland and Europe','Europ','','Holland','https://boatbiketours.com/','vacation','8 day quality tours by bike and barge. Discover a unique combination of cycling and cruising. More than 70 bike and barge trips in 15 countries, from March until October. ');
INSERT INTO destination VALUES(23,'Marfa','Marfa','TX','USA','https://www.nytimes.com/2018/01/22/travel/marfa-texas-road-trip.html','vacation','Marfa is the artist hub in the middle of the West Texas desert.');
INSERT INTO destination VALUES(24,'The Ultimate Western Pennsylvania Waterfalls Road Trip Is Here','','PA','USA','http://www.onlyinyourstate.com/pennsylvania/western-waterfalls-road-trip-pa/','outdoors',NULL);
INSERT INTO destination VALUES(25,'St. Anthony’s Wilderness','Pine Grove','PA','USA','http://www.midatlantichikes.com/rauschgap.htm','outdoors','The wilderness is explained in this trail description. It''s an unofficial name.');
INSERT INTO destination VALUES(26,'US UNESCO Sites: World-class heritage — here in the U.S.','','','USA','https://www.washingtonpost.com/classic-apps/world-class-heritage--here-in-the-us/2018/05/01/33c26570-2c5f-11e8-b0b0-f706877db618_story.html','vacation',NULL);
INSERT INTO destination VALUES(27,'Tank Hollow Vista','Penn Forest Township','PA','USA','https://www.theoutbound.com/pennsylvania/hiking/hike-to-tank-hollow-vista','outdoors','Vista can be accessed by Tank Hollow Tral');
INSERT INTO destination VALUES(28,'Neuschwanstein Castle','Schwangau',NULL,'Germany','https://www.facebook.com/atlasobscura/photos/rpp.103921782727/10156473433332728/?type=3&theater','vacation',NULL);
INSERT INTO destination VALUES(29,'Bunkers of Alvira','Allenwood','PA','USA','https://www.atlasobscura.com/places/bunkers-of-alvira','outdoors',NULL);
INSERT INTO destination VALUES(30,'Rio Grande','','TX','USA','https://www.newyorker.com/magazine/2018/04/23/a-voyage-along-trumps-wall','outdoors',NULL);
INSERT INTO destination VALUES(31,'Nuclear waste bunkers, pyramids and a body farm: 31 things you didn''t know were in Pa.','','PA','USA','http://www.pennlive.com/life/2017/06/things_you_didnt_know_were_in_pa.html','day trip','31 unexpected places in pa');
INSERT INTO destination VALUES(32,'Bunkers Of Alvira','Allenwood','PA','USA','https://www.google.com/maps/dir/40.044947,-75.242506/Bunkers+Of+Alvira,+Alvira+Road,+Allenwood,+PA/@40.8838617,-76.9636532,9z/data=!4m10!4m9!1m1!4e1!1m5!1m1!1s0x89cf0900b732f767:0x3959a40513836507!2m2!1d-76.9591384!2d41.1360368!3e0','day trip','31 unexpected places in pa');
INSERT INTO destination VALUES(33,'French Azilum','Asylum Township','PA','USA','https://www.google.com/maps/dir/40.044947,-75.242506/French+Azilum,+469+Queens+Rd,+Asylum+Township,+PA+18848/@40.8870486,-76.9632352,8z/data=!3m1!4b1!4m17!1m6!3m5!1s0x89daaa9781faee69:0xe9b21453538d64fe!2sFrench+Azilum!8m2!3d41.735907!4d-76.3117419!4m9!1m1!4e1!1m5!1m1!1s0x89daaa9781faee69:0xe9b21453538d64fe!2m2!1d-76.3117419!2d41.735907!3e0','day trip','31 unexpected places in pa');
INSERT INTO destination VALUES(34,'Canoeing the Bronx River','Bronx','NY','USA','http://www.bronxriver.org/','outdoors',NULL);
INSERT INTO destination VALUES(35,'Vacation Finder - WaPol','','','','https://www.washingtonpost.com/graphics/2018/lifestyle/travel/vacation-finder/','vacation',NULL);
INSERT INTO destination VALUES(36,'Shenandoah National Park; 10 Must Do Hikes','','VA','USA','https://blog.virginia.org/2016/06/must-do-hikes/','outdoors',NULL);
INSERT INTO destination VALUES(37,'10 Must-Do Hikes near Atlanta, GA','Atlanta','GA','USA','https://www.outdoorproject.com/blog-news/10-must-do-hikes-near-atlanta-ga','outdoors',NULL);
INSERT INTO destination VALUES(38,'Acadia National Park: 3-Day Itinerary','Bar Harbor','ME','USA','https://www.outdoorproject.com/blog-news/3-day-itinerary-acadia-national-park','outdoors',NULL);
INSERT INTO destination VALUES(39,'Colorado State Parks: ',NULL,'CO','USA','https://www.outdoorproject.com/blog-news/10-incredible-colorado-state-parks','outdoors',NULL);
INSERT INTO destination VALUES(40,'Trough Creek State Park: Copperous Rock, Balanced Rock, and Rainbow Falls ','James Creek','PA','USA','http://www.interestingpennsylvania.com/2016/08/trough-creek-state-park.html','outdoors',NULL);
INSERT INTO destination VALUES(41,'15 Things to Do in Worlds End State Park: Waterfalls, Vistas, and Where to Eat','Forksville','PA','USA','https://uncoveringpa.com/things-to-do-in-worlds-end-state-park','outdoors',NULL);
INSERT INTO destination VALUES(42,'Where to go camping in Pennsylvania this summer ','','PA','USA','https://billypenn.com/2018/06/23/where-to-go-camping-in-pennsylvania-this-summer/','outdoors',NULL);
INSERT INTO destination VALUES(43,'7 Summer Bucket List Adventures In Eastern Pennsylvania ','','PA','USA','https://patch.com/pennsylvania/roxborough/s/ggbe4/7-summer-bucket-list-adventures-eastern-pennsylvania','outdoors',NULL);
INSERT INTO destination VALUES(44,'20+ Awesome Free Things to Do in Philadelphia’s Historic District','Philadelphia','PA','USA','https://www.visitphilly.com/articles/philadelphia/free-things-to-do-in-historic-philadelphia/?utm_source=facebook.com&utm_medium=referral&utm_campaign=VisitPhillyFacebook&utm_content=PaidVPFB_FreeHP-Local','in town',NULL);
INSERT INTO destination VALUES(45,'Mt. Marcy','Adirondacks','NY','USA','https://www.backpacker.com/stories/the-peak-mt-marcy-adirondacks-ny','outdoors',NULL);
INSERT INTO destination VALUES(46,'Trails at Wissahickon Valley Watershed Association','Ambler','PA','USA','http://www.wvwa.org/preserves/','outdoors',NULL);
INSERT INTO destination VALUES(47,'Campgrounds near Ricketts Glen - Recommendations','Benton','PA','USA','https://www.facebook.com/groups/427764640622680/permalink/2043121065753688/?__xts__[0]=68.ARC3kLcVKvewx1tT9OmW9VyUZvNh_RYZtNv5_49_42PBVn275SpOQWiGy5T0wm5RJRIvpP5SkpnF0siO1ZcHB5g8jbChSC9ZNCgGDucNrpY_qRN9WfVszlfagHkZTi-2WawHamAEU9Iu9bteU9mfLUvppkcybLgcShq3QVJlQxDF58JHFNYixgti7UsK3GGEdtGQ0rUj3YgKU2rnnaAAVgVA-TOCUK_UqqNacLDmkw&__tn__=-R','outdoors','FB recommendation');
INSERT INTO destination VALUES(48,'Green Mill Jazz Club','Chicago','IL','USA','https://www.atlasobscura.com/places/green-mill?utm_source=facebook.com&utm_medium=atlas-page','nightlife','Located in Chicago’s Uptown neighborhood, the Green Mill Lounge is home to more than 100 years of history, a century of world-famous musicians and American mobsters alike.');
INSERT INTO destination VALUES(49,'Appalachian Trail - Triple Crown HIke','','VA','USA','','outdoors','McAfee Knob, Tinkers cliffs and Dragontooth');
INSERT INTO destination VALUES(50,'Mt Davis','Elk Lick Township','PA','USA','https://www.google.com/maps/place/Mt+Davis/@39.7861899,-79.1846393,15z/data=!3m1!4b1!4m5!3m4!1s0x89cab86b6850d3e1:0x69e4c883fceaaa47!8m2!3d39.7861908!4d-79.1758631!5m1!1e4','outdoors','Mount Davis is the highest point in Pennsylvania. Located in the 5,685-acre Forbes State Forest near the hamlet of Markleton in Elk Lick Township, Somerset County, it lies on a gentle crest of a 30-mile ridge line extending from central Somerset County southward into Garrett County, Maryland known as Negro Mountain.');
INSERT INTO destination VALUES(51,'Monocacy Hill Ruins','Birdsboro','PA','USA','http://exploringnjandpa.com/index.php/2018/10/04/monocacy-hill-ruins-birdsboro-pa/','outdoors','t is worth hiking the main trail from the parking lot (Lower Trail to Monocacy Hill Trail) to see the lookout point. It’s beautiful!');
INSERT INTO destination VALUES(52,'Glenstone Museum','Potomac','MD','USA','https://www.glenstone.org/','museum','WaPo Article - https://www.washingtonpost.com/graphics/2018/lifestyle/glenstone-museum/');
INSERT INTO destination VALUES(53,'20 Trails in Pennsylvania That Will Leave You Breathless','','PA','USA','https://pahappythoughts.com/happy-articles/20-trails-pennsylvania-will-leave-you-breathless?utm_source=Facebook&utm_medium=Social_Media&utm_campaign=FY18_Fall&utm_content=Family_Outdoor_Adventures','outdoors','Hiking, Biking, Vistas, and Birding');
INSERT INTO destination VALUES(54,'Delaware River Water Trail','','PA','USA','http://delawareriverwatertrail.org/resources/my-trip-planner/','outdoors','Website is a trip planner. More general search from Google about canoe put ins in MIlford, PA found at: https://www.google.com/search?q=milford%2C+pa+canoe+put+in&ie=utf-8&oe=utf-8&client=firefox-b-1-ab');
INSERT INTO destination VALUES(55,'Jaw-dropping Scenic Fall Drives in Pennsylvania',NULL,'PA','USA','https://visitpa.com/articles/jaw-dropping-scenic-fall-drives-pennsylvania','vacation','');
INSERT INTO destination VALUES(56,'Fieldstone Farm Tank Creek Nature Preserve','Cresco','PA','USA','http://www.phlt.org/np-fieldstone-farm.html','outdoors','Preserve provides spring feed flow to the headwaters of Tank Creek, a high quality headwater to the Paradise Creek. It forms an ~1/2 mile boundary between the preserve and State Gamelands #221 (Devil''s Hole). It also has two freshwater ');
INSERT INTO destination VALUES(57,'Grand Junction-Moab trail',NULL,'CO','USA','https://www.nytimes.com/2018/10/15/travel/biking-the-open-road-in-colorado-with-a-few-bumps-along-the-way.html','biking','The newly opened Grand Junction-Moab trail, a 155-mile route linked by a network of backcountry huts, and accessible only two months a year, offers an almost irresistible challenge for bikers. ');
INSERT INTO destination VALUES(58,'Middle Eastern: Craig LaBan’s Ultimate Dining 2018','Philadelphia','PA','USA','http://www.philly.com/philly/columnists/craig_laban/best-middle-eastern-food-restaurants-philadelphia-philly-2018.html','restaurant',NULL);
INSERT INTO destination VALUES(59,'Binky Lee Preserve','Chester Springs','PA','USA','https://natlands.org/binky-lee-preserve/','outdoors',NULL);
INSERT INTO destination VALUES(60,'Here are 15 N.J. trails you need to explore this fall','','NJ','USA','https://www.nj.com/entertainment/index.ssf/2018/10/10_nj_trails_you_need_to_explore_this_fall.html','outdoors',NULL);
INSERT INTO destination VALUES(61,'Pennsbury Manor','Morrisville','PA','USA','http://www.pennsburymanor.org/','historical','The colonial estate of William Penn.');
INSERT INTO destination VALUES(62,'Dingmans Falls','Dingsman Falls','PA','USA','https://uncoveringpa.com/dingmans-falls','outdoors',NULL);
INSERT INTO destination VALUES(63,'Downtown Wellsboro','Wellsboro','PA','USA','https://uncoveringpa.com/visiting-wellsboro-pennsylvania','day trip','Nice, little town ');
INSERT INTO destination VALUES(64,'The One Place to Visit in each of Pennsylvania’s 67 Counties','','PA','USA','https://uncoveringpa.com/place-to-visit-in-each-pennsylvania-county','day trip',NULL);
INSERT INTO destination VALUES(65,'Abandoned PA Turnpike','Breezewood','PA','USA','https://uncoveringpa.com/abandoned-pa-turnpike','outdoors',NULL);
INSERT INTO destination VALUES(66,'7 Beautiful and Historic Churches in Philadelphia Worth Visiting','Philadelphia','PA','USA','https://uncoveringpa.com/historic-churches-in-philadelphia','historical',NULL);
INSERT INTO destination VALUES(67,'11 Best Pennsylvania State Parks for History Lovers','','PA','USA','https://uncoveringpa.com/best-pennsylvania-state-parks-for-history-lovers','historical',NULL);
INSERT INTO destination VALUES(68,'11 Best Brunch Places in Philadelphia','Philadelphia','PA','USA','https://www.cntraveler.com/gallery/best-brunch-places-in-philadelphia','restaurant',NULL);
INSERT INTO destination VALUES(69,'PA Grand Canyon Scenic Overlooks: Barbour Rock, Bradley Wales, & Lebo Vista ',NULL,'PA','USA','https://www.interestingpennsylvania.com/2018/04/PA-Grand-Canyon-barbour-rock-bradley-wales-lebo-vista.html','outdoors',NULL);
INSERT INTO destination VALUES(70,'15 Things to Do in Worlds End State Park: Waterfalls, Vistas, and Where to Eat','','PA','USA','https://uncoveringpa.com/things-to-do-in-worlds-end-state-park','outdoors',NULL);
INSERT INTO destination VALUES(71,'10 Enchanting Frozen Waterfalls Worth a Winter Hike',NULL,'PA','USA','https://visitpa.com/articles/10-enchanting-frozen-waterfalls-worth-winter-hike','outdoors','Winter hiking on water falls. ');
INSERT INTO destination VALUES(72,'10 Awesome Pennsylvania Waterfalls for People who Hate Hiking','','PA','USA','https://uncoveringpa.com/easy-to-reach-pennsylvania-waterfalls','outdoors','Several hikes for folks with limited mobility close to Camp Elk Tannery, including Dry Run Falls, Adams Falls, and Big Run Falls. ');
INSERT INTO destination VALUES(73,'The Falls of Heberly Run in State Game Lands 13','Jamison City','PA','USA','https://uncoveringpa.com/heberly-run-waterfalls-state-game-lands-13','outdoors','Near Camp Elk Tannery on State Game Lands 13.');
INSERT INTO destination VALUES(74,'Hiking in a Winter Wonderland: Frozen Waterfalls at Ricketts Glen State Park','Benton','PA','USA','https://uncoveringpa.com/frozen-waterfalls-ricketts-glen-state-park','outdoors','Both straight hiking and photography tours. ');
INSERT INTO destination VALUES(75,'Exploring the Hoover-Mason Trestle in Bethlehem: Pennsylvania’s Most Industrial Rail Trail','Bethlehem','PA','USA','https://uncoveringpa.com/hoover-mason-trestle-bethlehem','outdoors','Industrial trail');
INSERT INTO destination VALUES(76,'13 of Our Favorite Things to Do in Scranton, PA','Scranton','PA','USA','https://uncoveringpa.com/things-to-do-in-scranton-pa','day trip','Lackawanna Coal Mine Tour, several falls, Old Forge Pizza Crawl, and Archbald Pothole State Park, the largest glacial potholei in the world.');
INSERT INTO destination VALUES(77,'Bilger''s Rocks: A Labyrinth of Boulders, Clearfield County ','Bloom Township','PA','USA','http://www.interestingpennsylvania.com/2016/07/bilgers-rocks-labyrinth-of-boulders.html','outdoors','One of the funkiest geological formations in the state');
INSERT INTO destination VALUES(78,'Standing Stone Trail and the Thousand Steps: Great Hike with Stunning Vistas ','','PA','USA','http://www.interestingpennsylvania.com/2016/08/standing-stone-trail-and-thousand-steps.html','outdoors','2016 Trail of the Year by the Pennsylvania Department of Conservation and Natural Resources. ');
INSERT INTO destination VALUES(79,'Standing Stone Trail: Hiking to the Throne Room Scenic Overlook in Huntingdon County ','Cass Township','PA','USA','http://www.interestingpennsylvania.com/2018/04/standing-stone-trail-hiking-to-throne.html','outdoors','The Throne Room gives a tremendous view of the rugged Alleghenies from an impressive boulder field at the top of a ridge.');
INSERT INTO destination VALUES(80,'Visiting the Hidden Gems of Swatara State Park','','PA','USA','https://uncoveringpa.com/visiting-swatara-state-park','outdoors','');
INSERT INTO destination VALUES(81,'New York Waterfalls: Hector Falls near Watkins Glen','','NY','USA','https://uncoveringnewyork.com/hector-falls-near-watkins-glen/','outdoors','Roadside water falls near Watkins Glen');
INSERT INTO destination VALUES(82,'Pennsylvania Waterfalls',NULL,'PA','USA','https://uncoveringpa.com/pennsylvania-waterfalls','outdoors',NULL);
INSERT INTO destination VALUES(83,'The Ultimate List of Completely Free Things to do in Philadelphia','Philadelphia','PA','USA','https://uncoveringpa.com/free-things-to-do-in-philadelphia','day trip',NULL);
INSERT INTO destination VALUES(84,'7 Magical Places to View Auroras','','','World','https://www.nationalgeographic.com/travel/top-10/7-aurora-destinations/','vacation',NULL);
INSERT INTO destination VALUES(85,replace('The 15 Least-visited National Parks Have All the Beauty, and None of the Crowds\nthis link opens in a new tab\nthis link opens in a new tab\nthis link opens in a new tab\n','\n',char(10)),'','','USA','https://www.travelandleisure.com/trip-ideas/national-parks/least-visited-national-parks','vacation',NULL);
INSERT INTO destination VALUES(86,replace('11 Hikes Near Philadelphia With Waterfalls and Gorgeous Views\nRead more at https://www.phillymag.com/be-well-philly/2018/04/04/waterfall-view-hikes-philadelphia/#jaSyqE43WVsWFg2u.99','\n',char(10)),'Philadelphia','PA','USA','https://www.phillymag.com/be-well-philly/2018/04/04/waterfall-view-hikes-philadelphia/','outdoors','');
INSERT INTO destination VALUES(87,'Here are 15 N.J. trails you need to explore this fall','','NJ','USA','https://www.nj.com/entertainment/2018/10/10_nj_trails_you_need_to_explore_this_fall.html','outdoors',NULL);
INSERT INTO destination VALUES(88,'Hiking at Black Moshannon State Park in Centre County, PA','Philipsburg','PA','USA','https://uncoveringpa.com/black-moshannon-state-park','outdoors',NULL);
INSERT INTO destination VALUES(89,'11 Beautiful Ithaca Waterfalls Worth Exploring','Ithaca','NY','USA','https://uncoveringnewyork.com/ithaca-waterfalls/','outdoors',NULL);
INSERT INTO destination VALUES(90,'19 Free Waterfalls in the Poconos that Should be on Your Bucket List','Poconos','PA','USA','https://uncoveringpa.com/waterfalls-in-the-poconos','outdoors',NULL);
INSERT INTO destination VALUES(91,'The Abandoned Nuclear Jet Bunkers in the Quehanna Wild Area',' Cameron County','PA','USA','https://uncoveringpa.com/jet-bunkers-quehanna-wild-area','outdoors',NULL);
INSERT INTO destination VALUES(92,'Mercer Mile: Visiting Fonthill Castle: One of Pennsylvania’s Most Awe-Inspiring Buildings','Doylestown','PA','USA','https://uncoveringpa.com/visiting-fonthill-castle','day trip','Mercer MIle includes Fonthill Castle, Mercer Museum, and Moravian Pottery and Tile Works. ');
INSERT INTO destination VALUES(93,'Red Brook and Coalbed Swamp','SGL-57','PA','USA','https://endlessmountains.wordpress.com/2013/12/29/sgl-57-red-brook-and-coalbed-swamp/','outdoors',NULL);
INSERT INTO destination VALUES(94,'Harriman State Park','Ramapo','NY','USA','https://parks.ny.gov/parks/145','outdoors','AMC Harriman Outdoor Center is located here.');
INSERT INTO destination VALUES(95,'Mountain Biking on the Allegrippis Trails at Raystown Lake: The Perfect Destination for Riders of all Skill Levels','Huntingdon County ','PA','USA','https://uncoveringpa.com/allegrippis-trails-raystown-lake','outdoors','Known for mountain biking trails. ');
INSERT INTO destination VALUES(96,'Tips for Hiking the Falls Trail in Ricketts Glen State Park','Benton','PA','USA','https://uncoveringpa.com/hiking-falls-trail-ricketts-glen-state-park','outdoors','Nearby falls and hikes are linked to in the article');
INSERT INTO destination VALUES(97,'My Top Tips for Biking the Great Allegheny Passage','','PA','USA','https://uncoveringpa.com/tips-for-riding-the-great-allegheny-passage','outdoors','Biking trail that extends the C&O Canal Trail (DC to Maryland) to Pittsburgh.');
INSERT INTO destination VALUES(98,'Tips for Biking the Pine Creek Rail Trail Through the Pennsylvania Grand Canyon',NULL,'PA','USA','https://uncoveringpa.com/biking-pine-creek-rail-trail-pennsylvania','outdoors',NULL);
INSERT INTO destination VALUES(99,'17 Fun Things to do in Allentown, PA','Allentown','PA','USA','https://uncoveringpa.com/things-to-do-in-allentown-pa','day trip','Has outdoors and indoors sites, so this is why the type is ''day trip''.');
INSERT INTO destination VALUES(100,'Abandoned Turnpike Tunnels (Ray’s & Sideling Hill) – Breezewood, PA','Breezewood, PA','PA','USA','http://exploringnjandpa.com/index.php/2018/06/27/both-abandoned-turnpike-tunnels-rays-sideling-hill-breezewood-pa/','outdoors',NULL);
INSERT INTO destination VALUES(101,'National Forests in North Carolina',NULL,'NC','USA','https://www.fs.usda.gov/nfsnc','outdoors','Pisgah National Forest is along route to Atlanta.');
INSERT INTO destination VALUES(102,'10 gorgeous places to see in a kayak','','','','https://www.mnn.com/lifestyle/eco-tourism/photos/10-gorgeous-places-to-see-in-a-kayak/paddle-through-nature','outdoors','');
INSERT INTO destination VALUES(103,'Spend the Night on the Beaches of Hawaii in a Retro Volkswagen Campervan','Kauai','HI','USA','https://www.coastalliving.com/syndication/camp-beachside-with-hawaiian-island-kauai-camper-rental','vacation','#Van life #vanlife');
INSERT INTO destination VALUES(104,'Water Trail Guides Index - PA Fish and Game Commission',NULL,'PA','USA','https://pfbc.pa.gov/WaterTrail.htm','outdoors','Compendium of Water Trails in PA with links to more info');
INSERT INTO destination VALUES(105,'The Camino de Santiago - All You Need to Know',NULL,NULL,'Spain','https://stingynomads.com/camino-de-santiago-walking-guide/','outdoors','A walking guide to the trail. ');
INSERT INTO destination VALUES(106,'Shohola Falls: The Secret Waterfall In Pennsylvania That Most People Don’t Know About','Shohola','PA','USA','https://www.onlyinyourstate.com/pennsylvania/shohola-falls-secret-waterfall-pa/','outdoors','');
INSERT INTO destination VALUES(107,'Columcille Megalith Park: Land of Mysterious Rock Monuments in the Poconos ','Bango','PA','USA','http://www.interestingpennsylvania.com/2019/03/columcille-megalith-park.html','outdoors','The official website: http://www.columcille.org');
INSERT INTO destination VALUES(108,replace('Endangered destinations: Five forces that are changing the travel landscape \n','\n',char(10)),'',NULL,'World','https://www.washingtonpost.com/graphics/2019/lifestyle/travel/endangered-travel-destinations/','vacation','Tourist destinations that are being endangered by climate changes, erosion, poaching, deforestation, and gentrification. A WaPo article. ');
INSERT INTO destination VALUES(109,'Canoe & Kayak Trips in the Adirondack Mountains','Adirondacks','NY','USA','https://raquetteriveroutfitters.com/routes-and-trips/','outdoors',NULL);
INSERT INTO destination VALUES(110,'The Haines Shoe House in York: Pennsylvania’s Strangest Building','York','PA','USA','https://uncoveringpa.com/haines-shoe-house','day trip',NULL);
INSERT INTO destination VALUES(111,'How to Get to Alpine Falls in Loyalsock State Forest','Loyalsock State Forest','PA','USA','https://uncoveringpa.com/alpine-falls-loyalsock-state-forest','outdoors',NULL);
INSERT INTO destination VALUES(112,'Visiting Centralia: Pennsylvania’s Toxic Ghost Town','Centralia','PA','USA','https://uncoveringpa.com/visiting-centralia','outdoors',NULL);
INSERT INTO destination VALUES(113,'10 Insanely Beautiful Destinations for Fall Foliage in Pennsylvania',NULL,'PA','USA','https://uncoveringpa.com/destinations-for-fall-colors-pennsylvania','outdoors','');
INSERT INTO destination VALUES(114,'Allegheny Forest',NULL,'PA & NY','USA','http://www.bbc.com/travel/story/20160620-the-us-one-million-acre-secret','outdoors',NULL);
INSERT INTO destination VALUES(115,'Exploring Blackberry Run Gorge-SGL 13','Jamison City','PA','USA','https://endlessmountains.wordpress.com/2018/11/27/exploring-blackberry-run-gorge-sgl-13/','outdoors','');
INSERT INTO destination VALUES(116,'The Best Hike in Every National Park','','','USA','https://www.outsideonline.com/2401975/the-best-hike-in-every-national-park','outdoors','');
INSERT INTO destination VALUES(117,'Visiting Bilger’s Rocks: Pennsylvania’s Best Rock Outcropping','Grampian','PA','USA','https://uncoveringpa.com/visiting-bilgers-rocks','outdoors','Pennsylvania’s Best Rock Outcropping. "I won’t go so far as to say that it’s worth driving a long distance just to visit the rocks, but it’s definitely worth checking out if you are in the nearby area."');
INSERT INTO destination VALUES(118,'Waterfalls of Burgess Brook Gorge-SGL 57','SGL-57','PA','USA','https://endlessmountains.wordpress.com/2019/05/21/waterfalls-of-burgess-brook-gorge-sgl-57/','outdoors','"Endless Mountains Experience"');
INSERT INTO destination VALUES(119,'The Wonders of Frozen Run Gorge-Loyalsock State Forest','Loyalsock State Forest','PA','USA','https://endlessmountains.wordpress.com/2016/04/28/the-wonders-of-frozen-run-gorge-loyalsock-state-forest/','outdoors','Hike 55 in Hiking the Endless Mountains');
INSERT INTO destination VALUES(120,'Hike to Lost Falls-SGL 140','SGL-140','PA','USA','https://endlessmountains.wordpress.com/2019/11/15/hike-to-lost-falls-sgl-140/','outdoors','"In mid to late October, the beech trees explode with color, making it an ideal time to visit." About 1.5 hour drive from Camp Elk Tannery.');
INSERT INTO destination VALUES(121,'Hiking the Bohen Falls Trail in the PA Grand Canyon','Blackwell','PA','USA','https://uncoveringpa.com/bohen-falls-trail','outdoors','On Pine Creek Trail, Tioga County, in the Pennsylvania Grand Canyon.');
INSERT INTO destination VALUES(122,'St. Peters Village: Hiking and Exploring in Chester County, PA','St. Peters Village','PA','USA','https://uncoveringpa.com/st-peters-village','outdoors',NULL);
INSERT INTO destination VALUES(123,'SGL 57 – Becker Brook to the Waterfall Gorge','SGL-57','PA','USA','https://endlessmountains.wordpress.com/2015/04/27/sgl-57-becker-brook-to-the-waterfall-gorge/','outdoors',NULL);
INSERT INTO destination VALUES(124,'Visiting Bryn Athyn Cathedral: Pennsylvania’s European Cathedral','Bryn Athyn','PA','USA','https://uncoveringpa.com/visiting-bryn-athyn-cathedral','day trip',NULL);
INSERT INTO destination VALUES(125,'Scenic Road Trip Takes You To All 7 Wonders Of Pennsylvania','Numerous','PA','USA','https://www.onlyinyourstate.com/pennsylvania/7-wonders-road-trip-pa/','short trip','7 wonders of Pennsylvania, but could cut off Ringing Rocks and Ricketts Glen and make it a shorter trip. ');
INSERT INTO destination VALUES(126,'Gratitude Falls and Gorge-SGL 57','SGL-57','PA','USA','https://endlessmountains.wordpress.com/2018/02/23/gratitude-falls-and-gorge-sgl-57/','outdoors','This journey features deep, rugged gorges, waterfalls, and big rocks. It is virtually all off trail. ');
INSERT INTO destination VALUES(127,'Umbrella Rock and Devil’s Den-SGL 44','SGL-44','PA','USA','https://endlessmountains.wordpress.com/2017/01/10/first-day-hike-to-umbrella-rock-and-devils-den-sgl-44/','outdoors',NULL);
INSERT INTO destination VALUES(128,'Visiting the Amazing Ringing Rocks Park near Pottstown, PA','Pottsgrove','PA','USA','https://uncoveringpa.com/ringing-rocks-park-pottstown','outdoors','This is not the more famous one, which is Ringing Rocks County Park in Bucks County. ');
INSERT INTO destination VALUES(129,'Visiting Ringing Rocks County Park: Bucks County’s Oddest Destination','Bucks County','PA','USA','https://uncoveringpa.com/visiting-ringing-rocks-county-park','outdoors','Known officially as the Bridgeton Boulder Field, this seven-acre field is better known as the ringing rocks for the curious sound that many of the rocks make when struck by a hammer. ');
INSERT INTO destination VALUES(130,'Hike to Mythical Falls and Black Bear Falls-SGL 57','SGL-57','PA','USA','https://endlessmountains.wordpress.com/2020/01/14/hike-to-mythical-falls-and-black-bear-falls-sgl-57/','outdoors','Just north of Ricketts Glen SP, off of Rt 487. ');
INSERT INTO destination VALUES(131,'Why This One Tiny Town Is Secretly The Best Place In Pennsylvania; Dushore, PA','Dushore','PA','USA','https://www.onlyinyourstate.com/pennsylvania/dushore-pa/','day trip','Close to World''s End SP');
INSERT INTO destination VALUES(132,'7 Cool And Calming Hikes To Take In Pennsylvania To Help You Reflect On The Year Ahead',NULL,'PA','USA','https://www.onlyinyourstate.com/pennsylvania/cool-calm-hikes-pa/','outdoors','');
INSERT INTO destination VALUES(133,'National Scenic Trails: The Best 50 Miles','','','USA','https://www.backpacker.com/trips/the-best-50-miles-in-the-scenic-trail-system','outdoors','Includes sections of Arizona Trail, Appalachian Trail (NC, VA, NH), Pacific Northwest Trail, North Country Trail OH, MI), Pacific Crest Trail, Continental Divide Trail, New England Trail, Potomac Heritage Trail (VA), Natchez Trace Trail(TN), Florida Trail, and Ice Age Trail (WI).');
INSERT INTO destination VALUES(134,'Visiting the Edgar Allan Poe National Historic Site in Philadelphia','Philadelphia','PA','USA','https://uncoveringpa.com/visiting-edgar-allen-poe-national-historic-site-philadelphia','day trip','Entrance is free. ');
INSERT INTO destination VALUES(135,'Hike to Somer Brook Falls-SGL 57','SGL-57','PA','USA','https://endlessmountains.wordpress.com/2020/01/28/hike-to-somer-brook-falls-sgl-57/','outdoors','');
INSERT INTO destination VALUES(136,'Tips for Seeing PA’s Middle Creek Snow Geese Migration','Stevens','PA','USA','https://uncoveringpa.com/middle-creek-snow-geese-migration','outdoors',replace('Seasonal between mid-February and mid-March. Approx. 1.5 hours away, and have to be there by dawn. Google Map - https://www.google.com/maps/dir/407+Wigard+Ave,+Philadelphia,+PA+19128,+USA/40.280597,-76.241502/@40.2168916,-76.2190217,11z/data=!4m9!4m8!1m5!1m1!1s0x89c6b8d4002c73d1:0x2d5cbe20e70dfe61!2m2!1d-75.242097!2d40.044923!1m0!3e0\n','\n',char(10)));
INSERT INTO destination VALUES(137,'The 10 Most Memorable Hikes in North America',NULL,NULL,NULL,'https://www.backpacker.com/trips/perfect-10-north-america-s-10-most-memorable-hikes','outdoors','');
INSERT INTO destination VALUES(138,'Hidden Beach In Pennsylvania With Clear Waters That Rival The Caribbean','Penfield','PA','USA','https://www.onlyinyourstate.com/pennsylvania/parker-dam-park-hidden-beach-pa/','outdoors','');
INSERT INTO destination VALUES(139,'6 Long Trails That Are Perfect for Beginners','','','USA','https://thetrek.co/6-long-trails-perfect-beginners/','outdoors','');
CREATE TABLE IF NOT EXISTS "table2tags" (
`table2tag_id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
`table_id` INTEGER NOT NULL,
`tag_id` INTEGER NOT NULL,
`table_name` TEXT NOT NULL,
FOREIGN KEY(`table_name`) REFERENCES `tables_in_db`(`db_tables`)
);
INSERT INTO table2tags VALUES(1,1,3,'park');
INSERT INTO table2tags VALUES(2,2,3,'park');
INSERT INTO table2tags VALUES(3,3,3,'park');
INSERT INTO table2tags VALUES(4,4,3,'park');
INSERT INTO table2tags VALUES(5,5,3,'park');
INSERT INTO table2tags VALUES(6,1,4,'park');
INSERT INTO table2tags VALUES(7,4,4,'park');
INSERT INTO table2tags VALUES(8,5,5,'park');
INSERT INTO table2tags VALUES(9,2,10,'park');
INSERT INTO table2tags VALUES(10,1,1,'destination');
INSERT INTO table2tags VALUES(11,1,2,'destination');
INSERT INTO table2tags VALUES(12,6,13,'park');
INSERT INTO table2tags VALUES(13,11,13,'trail');
INSERT INTO table2tags VALUES(14,12,14,'trail');
INSERT INTO table2tags VALUES(15,9,3,'park');
INSERT INTO table2tags VALUES(16,13,3,'trail');
INSERT INTO table2tags VALUES(17,14,3,'trail');
INSERT INTO table2tags VALUES(18,2,15,'destination');
INSERT INTO table2tags VALUES(19,15,13,'trail');
INSERT INTO table2tags VALUES(20,10,16,'park');
INSERT INTO table2tags VALUES(21,10,3,'park');
INSERT INTO table2tags VALUES(22,11,3,'park');
INSERT INTO table2tags VALUES(23,11,4,'park');
INSERT INTO table2tags VALUES(24,10,13,'park');
INSERT INTO table2tags VALUES(25,17,13,'trail');
INSERT INTO table2tags VALUES(26,12,17,'park');
INSERT INTO table2tags VALUES(27,13,3,'park');
INSERT INTO table2tags VALUES(28,13,4,'park');
INSERT INTO table2tags VALUES(29,5,3,'destination');
INSERT INTO table2tags VALUES(30,5,4,'destination');
INSERT INTO table2tags VALUES(31,9,13,'destination');
INSERT INTO table2tags VALUES(32,20,3,'trail');
INSERT INTO table2tags VALUES(33,21,3,'trail');
INSERT INTO table2tags VALUES(34,22,3,'trail');
INSERT INTO table2tags VALUES(35,23,3,'trail');
INSERT INTO table2tags VALUES(36,14,3,'park');
INSERT INTO table2tags VALUES(37,15,3,'park');
INSERT INTO table2tags VALUES(38,16,3,'park');
INSERT INTO table2tags VALUES(39,17,3,'park');
INSERT INTO table2tags VALUES(40,18,3,'park');
INSERT INTO table2tags VALUES(41,23,3,'trail');
INSERT INTO table2tags VALUES(42,24,3,'trail');
INSERT INTO table2tags VALUES(43,20,13,'park');
INSERT INTO table2tags VALUES(44,20,3,'park');
INSERT INTO table2tags VALUES(45,26,13,'trail');
INSERT INTO table2tags VALUES(46,15,13,'destination');
INSERT INTO table2tags VALUES(47,15,3,'destination');
INSERT INTO table2tags VALUES(48,28,3,'trail');
INSERT INTO table2tags VALUES(49,20,3,'park');
INSERT INTO table2tags VALUES(50,16,3,'destination');
INSERT INTO table2tags VALUES(51,16,18,'destination');
INSERT INTO table2tags VALUES(52,25,19,'park');
INSERT INTO table2tags VALUES(53,26,4,'park');
INSERT INTO table2tags VALUES(54,26,20,'park');
INSERT INTO table2tags VALUES(55,27,13,'park');
INSERT INTO table2tags VALUES(56,27,21,'park');
INSERT INTO table2tags VALUES(57,27,3,'park');
INSERT INTO table2tags VALUES(58,32,3,'trail');
INSERT INTO table2tags VALUES(59,32,12,'trail');
INSERT INTO table2tags VALUES(60,33,3,'trail');
INSERT INTO table2tags VALUES(61,33,12,'trail');
INSERT INTO table2tags VALUES(62,33,22,'trail');
INSERT INTO table2tags VALUES(63,28,3,'park');
INSERT INTO table2tags VALUES(64,28,4,'park');
INSERT INTO table2tags VALUES(65,34,3,'trail');
INSERT INTO table2tags VALUES(66,34,20,'trail');
INSERT INTO table2tags VALUES(67,34,19,'trail');
INSERT INTO table2tags VALUES(68,24,3,'destination');
INSERT INTO table2tags VALUES(69,24,18,'destination');
INSERT INTO table2tags VALUES(70,18,3,'destination');
INSERT INTO table2tags VALUES(71,31,3,'park');
INSERT INTO table2tags VALUES(72,34,3,'park');
INSERT INTO table2tags VALUES(73,34,4,'park');
INSERT INTO table2tags VALUES(74,35,23,'park');
INSERT INTO table2tags VALUES(75,35,3,'park');
INSERT INTO table2tags VALUES(76,14,13,'park');
INSERT INTO table2tags VALUES(77,42,24,'destination');
INSERT INTO table2tags VALUES(78,43,24,'destination');
INSERT INTO table2tags VALUES(79,44,3,'destination');
INSERT INTO table2tags VALUES(80,44,25,'destination');
INSERT INTO table2tags VALUES(81,44,26,'destination');
INSERT INTO table2tags VALUES(82,51,13,'destination');
INSERT INTO table2tags VALUES(83,54,12,'destination');
INSERT INTO table2tags VALUES(84,68,27,'destination');
INSERT INTO table2tags VALUES(85,68,28,'destination');
INSERT INTO table2tags VALUES(86,67,28,'destination');
INSERT INTO table2tags VALUES(87,71,28,'destination');
INSERT INTO table2tags VALUES(88,71,18,'destination');
INSERT INTO table2tags VALUES(89,71,29,'destination');
INSERT INTO table2tags VALUES(90,84,30,'destination');
INSERT INTO table2tags VALUES(91,87,31,'destination');
INSERT INTO table2tags VALUES(92,89,18,'destination');
INSERT INTO table2tags VALUES(93,89,32,'destination');
INSERT INTO table2tags VALUES(94,90,18,'destination');
INSERT INTO table2tags VALUES(95,91,33,'destination');
INSERT INTO table2tags VALUES(96,65,33,'destination');
INSERT INTO table2tags VALUES(97,92,34,'destination');
INSERT INTO table2tags VALUES(98,93,35,'destination');
INSERT INTO table2tags VALUES(99,96,4,'destination');
INSERT INTO table2tags VALUES(100,96,18,'destination');
INSERT INTO table2tags VALUES(101,95,22,'destination');
INSERT INTO table2tags VALUES(102,97,22,'destination');
INSERT INTO table2tags VALUES(103,98,22,'destination');
INSERT INTO table2tags VALUES(104,99,3,'destination');
INSERT INTO table2tags VALUES(105,100,3,'destination');
INSERT INTO table2tags VALUES(106,100,33,'destination');
INSERT INTO table2tags VALUES(107,37,7,'park');
INSERT INTO table2tags VALUES(108,37,36,'park');
INSERT INTO table2tags VALUES(109,38,4,'park');
INSERT INTO table2tags VALUES(110,38,36,'park');
INSERT INTO table2tags VALUES(111,39,16,'park');
INSERT INTO table2tags VALUES(112,102,37,'destination');
INSERT INTO table2tags VALUES(113,102,28,'destination');
INSERT INTO table2tags VALUES(114,103,38,'destination');
INSERT INTO table2tags VALUES(115,104,39,'destination');
INSERT INTO table2tags VALUES(116,104,37,'destination');
INSERT INTO table2tags VALUES(117,58,39,'trail');
INSERT INTO table2tags VALUES(118,58,37,'trail');
INSERT INTO table2tags VALUES(119,106,18,'destination');
INSERT INTO table2tags VALUES(120,106,3,'destination');
INSERT INTO table2tags VALUES(121,107,3,'destination');
INSERT INTO table2tags VALUES(122,107,40,'destination');
INSERT INTO table2tags VALUES(123,107,41,'destination');
INSERT INTO table2tags VALUES(124,113,42,'destination');
INSERT INTO table2tags VALUES(125,111,18,'destination');
INSERT INTO table2tags VALUES(126,113,28,'destination');
INSERT INTO table2tags VALUES(127,114,7,'destination');
INSERT INTO table2tags VALUES(128,114,18,'destination');
INSERT INTO table2tags VALUES(129,114,42,'destination');
INSERT INTO table2tags VALUES(130,114,43,'destination');
INSERT INTO table2tags VALUES(131,114,44,'destination');
INSERT INTO table2tags VALUES(132,121,3,'destination');
INSERT INTO table2tags VALUES(133,121,12,'destination');
INSERT INTO table2tags VALUES(134,121,18,'destination');
INSERT INTO table2tags VALUES(135,62,18,'trail');
INSERT INTO table2tags VALUES(136,63,45,'trail');
INSERT INTO table2tags VALUES(137,125,46,'destination');
INSERT INTO table2tags VALUES(138,126,18,'destination');
INSERT INTO table2tags VALUES(139,126,35,'destination');
INSERT INTO table2tags VALUES(140,126,11,'destination');
INSERT INTO table2tags VALUES(141,126,45,'destination');
INSERT INTO table2tags VALUES(142,127,35,'destination');
INSERT INTO table2tags VALUES(143,127,43,'destination');
INSERT INTO table2tags VALUES(144,65,11,'trail');
INSERT INTO table2tags VALUES(145,65,45,'trail');
INSERT INTO table2tags VALUES(146,65,4,'trail');
INSERT INTO table2tags VALUES(147,128,43,'destination');
INSERT INTO table2tags VALUES(148,129,43,'destination');
INSERT INTO table2tags VALUES(149,129,21,'destination');
INSERT INTO table2tags VALUES(150,130,18,'destination');
INSERT INTO table2tags VALUES(151,130,35,'destination');
INSERT INTO table2tags VALUES(152,130,47,'destination');
INSERT INTO table2tags VALUES(153,126,47,'destination');
INSERT INTO table2tags VALUES(154,123,47,'destination');
INSERT INTO table2tags VALUES(155,118,47,'destination');
INSERT INTO table2tags VALUES(156,115,47,'destination');
INSERT INTO table2tags VALUES(157,96,47,'destination');
INSERT INTO table2tags VALUES(158,93,47,'destination');
INSERT INTO table2tags VALUES(159,73,47,'destination');
INSERT INTO table2tags VALUES(160,133,28,'destination');
INSERT INTO table2tags VALUES(161,133,12,'destination');
INSERT INTO table2tags VALUES(162,29,47,'destination');
INSERT INTO table2tags VALUES(163,32,47,'destination');
INSERT INTO table2tags VALUES(164,29,33,'destination');
INSERT INTO table2tags VALUES(165,32,33,'destination');
INSERT INTO table2tags VALUES(166,31,33,'destination');
INSERT INTO table2tags VALUES(167,134,48,'destination');
INSERT INTO table2tags VALUES(168,135,49,'destination');
INSERT INTO table2tags VALUES(169,135,47,'destination');
INSERT INTO table2tags VALUES(170,137,50,'destination');
INSERT INTO table2tags VALUES(171,137,1,'destination');
INSERT INTO table2tags VALUES(172,138,51,'destination');
INSERT INTO table2tags VALUES(173,17,52,'destination');
INSERT INTO table2tags VALUES(174,17,53,'destination');
INSERT INTO table2tags VALUES(175,138,52,'destination');
INSERT INTO table2tags VALUES(176,139,50,'');
INSERT INTO table2tags VALUES(177,8,54,'destination');
INSERT INTO table2tags VALUES(178,9,54,'destination');
INSERT INTO table2tags VALUES(179,17,54,'destination');
INSERT INTO table2tags VALUES(180,26,54,'destination');
INSERT INTO table2tags VALUES(181,31,54,'destination');
INSERT INTO table2tags VALUES(182,36,54,'destination');
INSERT INTO table2tags VALUES(183,37,54,'destination');
INSERT INTO table2tags VALUES(184,41,54,'destination');
INSERT INTO table2tags VALUES(185,43,54,'destination');
INSERT INTO table2tags VALUES(186,44,54,'destination');
INSERT INTO table2tags VALUES(187,60,54,'destination');
INSERT INTO table2tags VALUES(188,66,54,'destination');
INSERT INTO table2tags VALUES(189,67,54,'destination');
INSERT INTO table2tags VALUES(190,68,54,'destination');
INSERT INTO table2tags VALUES(191,70,54,'destination');
INSERT INTO table2tags VALUES(192,71,54,'destination');
INSERT INTO table2tags VALUES(193,72,54,'destination');
INSERT INTO table2tags VALUES(194,76,54,'destination');
INSERT INTO table2tags VALUES(195,82,54,'destination');
INSERT INTO table2tags VALUES(196,83,54,'destination');
INSERT INTO table2tags VALUES(197,84,54,'destination');
INSERT INTO table2tags VALUES(198,85,54,'destination');
INSERT INTO table2tags VALUES(199,86,54,'destination');
INSERT INTO table2tags VALUES(200,87,54,'destination');
INSERT INTO table2tags VALUES(201,89,54,'destination');
INSERT INTO table2tags VALUES(202,90,54,'destination');
INSERT INTO table2tags VALUES(203,99,54,'destination');
INSERT INTO table2tags VALUES(204,102,54,'destination');
INSERT INTO table2tags VALUES(205,113,54,'destination');
INSERT INTO table2tags VALUES(206,132,54,'destination');
INSERT INTO table2tags VALUES(207,133,54,'destination');
INSERT INTO table2tags VALUES(208,137,54,'destination');
CREATE TABLE IF NOT EXISTS "tables_in_db" (
`db_tables` TEXT,
PRIMARY KEY(`db_tables`)
);
INSERT INTO tables_in_db VALUES('destination');
INSERT INTO tables_in_db VALUES('park');
INSERT INTO tables_in_db VALUES('table2tags');
INSERT INTO tables_in_db VALUES('tags');
INSERT INTO tables_in_db VALUES('trail');
INSERT INTO tables_in_db VALUES('trail_park_rel');
INSERT INTO tables_in_db VALUES('');
DELETE FROM sqlite_sequence;
INSERT INTO sqlite_sequence VALUES('tags',54);
INSERT INTO sqlite_sequence VALUES('trail',68);
INSERT INTO sqlite_sequence VALUES('park',39);
INSERT INTO sqlite_sequence VALUES('destination',139);
INSERT INTO sqlite_sequence VALUES('table2tags',208);
COMMIT;