units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where DES_TP = 49 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, PARK_URL, COUNTY
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES ▼ | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16806 | 16806 | 16805 | {"type": "Polygon", "coordinates": [[[-119.29135, 36.90366], [-119.29138, 36.90381], [-119.29133, 36.904], [-119.29126, 36.90411], [-119.29101, 36.904], [-119.29089, 36.90383], [-119.29093, 36.90363], [-119.29103, 36.90354], [-119.29125, 36.90356], [-119.29135, 36.90366]]]} | Open Access 1 | 15864 | Trimmer Recreation Area | 26537 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Fresno 9 | 0.497 | Trimmer Rec. Area | 0 | Recreation Management Area 49 | 4 | |
5413 | 5413 | 5412 | {"type": "MultiPolygon", "coordinates": [[[[-118.22858, 33.88759], [-118.22857, 33.88759], [-118.22835, 33.88727], [-118.22846, 33.88739], [-118.22858, 33.88759]]], [[[-118.24226, 33.90419], [-118.24209, 33.90423], [-118.24193, 33.90397], [-118.24191, 33.9036], [-118.24216, 33.90405], [-118.24226, 33.90419]]], [[[-118.24858, 33.91176], [-118.24841, 33.91176], [-118.24735, 33.91049], [-118.24755, 33.9105], [-118.24857, 33.91171], [-118.24858, 33.91176]]]]} | Open Access 1 | 7202 | Compton Creek & Bike Path | 17571 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 0.849 | Compton Creek & Bike Path | 0 | Recreation Management Area 49 | 4 | |
10040 | 10040 | 10039 | {"type": "Polygon", "coordinates": [[[-119.49172, 34.40088], [-119.49129, 34.40263], [-119.49129, 34.40263], [-119.49072, 34.40237], [-119.49092, 34.40127], [-119.49172, 34.40088]]]} | Open Access 1 | 17367 | Lions Park | 21316 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Santa Barbara 7 | 2.41 | Lions Park | 0 | Recreation Management Area 49 | 4 | ||
4135 | 4135 | 4134 | {"type": "Polygon", "coordinates": [[[-122.52305, 38.05524], [-122.52194, 38.05549], [-122.52181, 38.05532], [-122.52157, 38.05523], [-122.52156, 38.0552], [-122.52157, 38.05504], [-122.52156, 38.05494], [-122.52152, 38.05472], [-122.52145, 38.05448], [-122.52158, 38.05436], [-122.52177, 38.05425], [-122.52233, 38.05409], [-122.52305, 38.05524]]]} | Restricted Access 2 | 47183 | United States Coast Guard Park | 30875 | 104 | United States Coast Guard 511 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 104 | United States Coast Guard 503 | Federal 1 | Federal Agency 1 | Marin 23 | 3.383 | United States Coast Guard Park | 0 | Recreation Management Area 49 | 4 | |
12084 | 12084 | 12083 | {"type": "Polygon", "coordinates": [[[-117.24699, 34.22787], [-117.24641, 34.2278], [-117.24625, 34.22776], [-117.24604, 34.22767], [-117.24588, 34.22753], [-117.24579, 34.22741], [-117.24574, 34.2273], [-117.24558, 34.22653], [-117.24552, 34.22637], [-117.24544, 34.22621], [-117.24695, 34.22622], [-117.24699, 34.22787]]]} | Open Access 1 | 24892 | Baylis Park Picnic Area | 15888 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | San Bernardino 22 | 5.039 | Baylis Park Picnic Area | 0 | Recreation Management Area 49 | 4 | |
16770 | 16770 | 16769 | {"type": "Polygon", "coordinates": [[[-120.73227, 37.78935], [-120.73205, 37.79003], [-120.73166, 37.79035], [-120.73108, 37.7907], [-120.7305, 37.79113], [-120.73019, 37.79132], [-120.7301, 37.79127], [-120.72956, 37.79192], [-120.72909, 37.79271], [-120.72888, 37.79387], [-120.72864, 37.79446], [-120.72771, 37.79518], [-120.72674, 37.79679], [-120.72645, 37.79737], [-120.72624, 37.79731], [-120.72646, 37.79704], [-120.72657, 37.79678], [-120.72669, 37.79637], [-120.72674, 37.79631], [-120.72681, 37.79631], [-120.7269, 37.79627], [-120.72699, 37.79605], [-120.72711, 37.79591], [-120.72719, 37.79568], [-120.72751, 37.79517], [-120.72788, 37.79479], [-120.72808, 37.79468], [-120.72816, 37.79453], [-120.72827, 37.79445], [-120.72845, 37.79439], [-120.72864, 37.79417], [-120.72878, 37.79375], [-120.7288, 37.79336], [-120.7286, 37.79303], [-120.7286, 37.79274], [-120.72882, 37.79248], [-120.7289, 37.79217], [-120.72907, 37.79182], [-120.72931, 37.79148], [-120.72949, 37.79131], [-120.72962, 37.79107], [-120.7298, 37.79097], [-120.73005, 37.79063], [-120.73065, 37.79035], [-120.731, 37.79008], [-120.73128, 37.7895], [-120.73148, 37.78893], [-120.73204, 37.78857], [-120.73209, 37.78884], [-120.73227, 37.78935]]]} | Open Access 1 | 44371 | Honolulu Bar Recreation Area | 20069 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Stanislaus 2 | 10.135 | Honolulu Bar Rec. Area | 0 | Recreation Management Area 49 | 4 | |
8231 | 8231 | 8230 | {"type": "Polygon", "coordinates": [[[-118.77876, 34.11244], [-118.77774, 34.11333], [-118.77749, 34.11315], [-118.77722, 34.11301], [-118.77658, 34.11278], [-118.77649, 34.11274], [-118.77632, 34.1126], [-118.77602, 34.11226], [-118.77585, 34.11215], [-118.77572, 34.11211], [-118.7755, 34.1121], [-118.77301, 34.1124], [-118.7749, 34.11069], [-118.77876, 34.11244]]]} | Open Access 1 | 12558 | Peter Strauss Ranch | 14262 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/samo/planyourvisit/straussranch.htm | Los Angeles 6 | 14.272 | Peter Strauss Ranch | 0 | Recreation Management Area 49 | 4 |
465 | 465 | 464 | {"type": "Polygon", "coordinates": [[[-118.48671, 34.16591], [-118.48664, 34.16649], [-118.48663, 34.16717], [-118.48664, 34.16724], [-118.48669, 34.16733], [-118.48656, 34.1675], [-118.48638, 34.16753], [-118.48622, 34.16759], [-118.48616, 34.16766], [-118.48614, 34.16773], [-118.4862, 34.16804], [-118.48623, 34.16809], [-118.48628, 34.16811], [-118.48608, 34.16815], [-118.4861, 34.1681], [-118.48604, 34.16774], [-118.48591, 34.16777], [-118.48581, 34.1677], [-118.48557, 34.16772], [-118.48516, 34.16783], [-118.48494, 34.16787], [-118.48445, 34.16789], [-118.48418, 34.16787], [-118.48385, 34.1678], [-118.48369, 34.16772], [-118.48359, 34.1676], [-118.48357, 34.16755], [-118.48351, 34.1671], [-118.48355, 34.16638], [-118.48357, 34.16623], [-118.48362, 34.16609], [-118.48368, 34.16599], [-118.48374, 34.16594], [-118.48387, 34.1659], [-118.4853, 34.16589], [-118.48633, 34.16583], [-118.48634, 34.16591], [-118.48639, 34.16594], [-118.48671, 34.16591]]]} | Open Access 1 | 1861 | Hjelte Sports Center | 20010 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 14.721 | Hjelte Sports Ctr. | 0 | Recreation Management Area 49 | 4 | |
14320 | 14320 | 14319 | {"type": "Polygon", "coordinates": [[[-118.71107, 34.10391], [-118.71093, 34.10397], [-118.71061, 34.10414], [-118.71032, 34.10426], [-118.70981, 34.10444], [-118.70927, 34.1046], [-118.70646, 34.10285], [-118.707, 34.10227], [-118.70735, 34.10227], [-118.70735, 34.10256], [-118.70733, 34.10264], [-118.7075, 34.10269], [-118.70754, 34.10261], [-118.70867, 34.10291], [-118.71101, 34.10229], [-118.71099, 34.10357], [-118.71107, 34.10363], [-118.71107, 34.10391]]]} | Open Access 1 | 44376 | King Gillette Ranch | 14239 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/samo/planyourvisit/kinggilletteranch.htm | Los Angeles 6 | 15.376 | King Gillette Ranch | 0 | Recreation Management Area 49 | 4 |
9903 | 9903 | 9902 | {"type": "Polygon", "coordinates": [[[-120.7739, 37.7927], [-120.77322, 37.79285], [-120.77164, 37.79236], [-120.76957, 37.7921], [-120.76865, 37.79188], [-120.76749, 37.79128], [-120.76755, 37.79123], [-120.76755, 37.79122], [-120.76728, 37.79108], [-120.76722, 37.79113], [-120.767, 37.79101], [-120.76646, 37.79083], [-120.76346, 37.79052], [-120.76278, 37.79031], [-120.7628, 37.79023], [-120.7623, 37.79007], [-120.76196, 37.78989], [-120.76187, 37.78981], [-120.7618, 37.78973], [-120.76168, 37.78963], [-120.76164, 37.78954], [-120.76156, 37.78946], [-120.76149, 37.78928], [-120.76187, 37.78901], [-120.76279, 37.78841], [-120.76306, 37.7888], [-120.76333, 37.78906], [-120.76406, 37.78952], [-120.76436, 37.78977], [-120.76462, 37.79011], [-120.76495, 37.7903], [-120.76532, 37.79038], [-120.76563, 37.79056], [-120.76598, 37.79061], [-120.7663, 37.79063], [-120.76685, 37.79076], [-120.76706, 37.79086], [-120.76727, 37.79091], [-120.76769, 37.79094], [-120.76799, 37.79105], [-120.76824, 37.79119], [-120.76868, 37.79131], [-120.76899, 37.79142], [-120.76932, 37.79152], [-120.76973, 37.79158], [-120.77008, 37.79175], [-120.77082, 37.79188], [-120.77112, 37.79192], [-120.77182, 37.79208], [-120.77211, 37.79209], [-120.77259, 37.7922], [-120.77319, 37.79236], [-120.77374, 37.79233], [-120.7739, 37.7927]]]} | Open Access 1 | 18350 | Orange Blossom Recreation Area | 23150 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Stanislaus 2 | 17.472 | Orange Blossom Rec. Area | 0 | Recreation Management Area 49 | 4 | |
7269 | 7269 | 7268 | {"type": "Polygon", "coordinates": [[[-118.70012, 34.09988], [-118.69791, 34.09987], [-118.69791, 34.09626], [-118.69892, 34.09625], [-118.7001, 34.0973], [-118.70012, 34.09988]]]} | Restricted Access 2 | 6493 | Diamond X Ranch | 29655 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 18.578 | Diamond X Ranch | 0 | Recreation Management Area 49 | 4 | |
4053 | 4053 | 4052 | {"type": "Polygon", "coordinates": [[[-120.63426, 37.85934], [-120.63377, 37.86008], [-120.63222, 37.86096], [-120.63246, 37.86129], [-120.63243, 37.86133], [-120.63134, 37.86171], [-120.63, 37.86242], [-120.62992, 37.8625], [-120.6297, 37.8621], [-120.62844, 37.86263], [-120.62838, 37.86143], [-120.62837, 37.86142], [-120.62757, 37.86181], [-120.627, 37.86214], [-120.62667, 37.86238], [-120.62626, 37.86279], [-120.62597, 37.86317], [-120.62588, 37.86306], [-120.62646, 37.86246], [-120.62671, 37.86225], [-120.62838, 37.86135], [-120.62883, 37.86124], [-120.62922, 37.86146], [-120.62971, 37.86134], [-120.63001, 37.86097], [-120.63166, 37.86028], [-120.6323, 37.85981], [-120.63255, 37.85869], [-120.63325, 37.85868], [-120.63426, 37.85934]]]} | Open Access 1 | 44370 | Goodwin Dam Recreation Area | 19404 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Tuolumne 21 | 18.684 | Goodwin Dam Rec. Area | 0 | Recreation Management Area 49 | 4 | |
939 | 939 | 938 | {"type": "Polygon", "coordinates": [[[-118.69354, 34.09988], [-118.69132, 34.09987], [-118.6913, 34.09626], [-118.69353, 34.09626], [-118.69354, 34.09988]]]} | Unknown Access 4 | 6492 | Triffon Open Space | 29659 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 20.369 | Triffon OS | 0 | Recreation Management Area 49 | 4 | |
10059 | 10059 | 10058 | {"type": "Polygon", "coordinates": [[[-118.49219, 34.16366], [-118.49127, 34.1647], [-118.49126, 34.16484], [-118.48809, 34.16482], [-118.48809, 34.16062], [-118.48813, 34.16046], [-118.48931, 34.16046], [-118.48932, 34.1631], [-118.49219, 34.16311], [-118.49219, 34.16366]]]} | Open Access 1 | 17417 | Libbit Park | 21202 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 24.58 | Libbit Park | 0 | Recreation Management Area 49 | 4 | |
16750 | 16750 | 16749 | {"type": "Polygon", "coordinates": [[[-120.80656, 37.78696], [-120.80405, 37.78649], [-120.80405, 37.78871], [-120.80384, 37.78865], [-120.80383, 37.78687], [-120.80275, 37.78665], [-120.80274, 37.78629], [-120.80111, 37.7865], [-120.79955, 37.78698], [-120.79955, 37.78605], [-120.79971, 37.78594], [-120.80213, 37.78523], [-120.80283, 37.78506], [-120.80399, 37.78493], [-120.80505, 37.78492], [-120.8056, 37.78499], [-120.80612, 37.78511], [-120.80655, 37.7853], [-120.80656, 37.78696]]]} | Open Access 1 | 48840 | Valley Oak Recreation Area | 33560 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | https://stanislausriver.com/parks/valley-oak-recration-area/ | Stanislaus 2 | 24.963 | Valley Oak Rec. Area | 0 | Recreation Management Area 49 | 4 |
7058 | 7058 | 7057 | {"type": "Polygon", "coordinates": [[[-118.06181, 34.02017], [-118.06089, 34.02054], [-118.06107, 34.02082], [-118.06117, 34.02082], [-118.06121, 34.02141], [-118.05671, 34.02154], [-118.0577, 34.02122], [-118.05703, 34.01992], [-118.05747, 34.01907], [-118.05897, 34.01802], [-118.06078, 34.01739], [-118.06033, 34.01796], [-118.05961, 34.01857], [-118.0607, 34.02026], [-118.06181, 34.02017]]]} | Restricted Access 2 | 6569 | Pico Rivera Golf Course | 33017 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 26.31 | Pico Rivera GC | 0 | Recreation Management Area 49 | 4 | |
1128 | 1128 | 1127 | {"type": "MultiPolygon", "coordinates": [[[[-118.65001, 34.07927], [-118.64902, 34.07928], [-118.6491, 34.07916], [-118.64914, 34.07903], [-118.64913, 34.07888], [-118.64909, 34.07874], [-118.64901, 34.07862], [-118.64888, 34.07851], [-118.64873, 34.07843], [-118.64854, 34.07839], [-118.64834, 34.07839], [-118.64815, 34.07844], [-118.64681, 34.07901], [-118.64666, 34.07901], [-118.64638, 34.07905], [-118.64564, 34.07927], [-118.64543, 34.07928], [-118.64496, 34.07925], [-118.64461, 34.07919], [-118.64334, 34.07882], [-118.64322, 34.07877], [-118.64307, 34.07863], [-118.64299, 34.07846], [-118.64299, 34.07832], [-118.64303, 34.0782], [-118.64313, 34.07807], [-118.64333, 34.0779], [-118.64352, 34.07783], [-118.64373, 34.07769], [-118.64454, 34.07796], [-118.6449, 34.0779], [-118.64493, 34.0781], [-118.6456, 34.07833], [-118.65, 34.07832], [-118.65001, 34.07927]]], [[[-118.64879, 34.07893], [-118.64876, 34.079], [-118.64867, 34.07908], [-118.64557, 34.08106], [-118.64541, 34.08113], [-118.64518, 34.08114], [-118.64488, 34.08105], [-118.64479, 34.08105], [-118.64464, 34.08108], [-118.64452, 34.08114], [-118.64397, 34.08117], [-118.64382, 34.08117], [-118.64366, 34.08083], [-118.64334, 34.08006], [-118.64335, 34.08001], [-118.64344, 34.08002], [-118.64352, 34.08], [-118.64361, 34.07994], [-118.64367, 34.07987], [-118.6438, 34.0792], [-118.64493, 34.07943], [-118.6452, 34.07946], [-118.64544, 34.07946], [-118.64594, 34.07942], [-118.64631, 34.07935], [-118.64668, 34.07924], [-118.64684, 34.07918], [-118.64743, 34.07918], [-118.64762, 34.07915], [-118.64778, 34.07909], [-118.64793, 34.07901], [-118.64809, 34.07888], [-118.64829, 34.07866], [-118.6484, 34.07862], [-118.64858, 34.07862], [-118.64871, 34.07869], [-118.64877, 34.07878], [-118.64879, 34.07893]]], [[[-118.64799, 34.07869], [-118.64782, 34.07887], [-118.64765, 34.07896], [-118.64747, 34.07901], [-118.64723, 34.07901], [-118.64799, 34.07869]]], [[[-118.64889, 34.07913], [-118.64884, 34.07921], [-118.64877, 34.07927], [-118.64851, 34.0794], [-118.64883, 34.0792], [-118.64889, 34.07913]]]]} | Open Access 1 | 7215 | Hepatic Gulch Open Space | 14226 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 29.855 | Hepatic Gulch OS | 0 | Recreation Management Area 49 | 4 | |
1667 | 1667 | 1666 | {"type": "Polygon", "coordinates": [[[-118.80701, 34.07087], [-118.80686, 34.07462], [-118.80435, 34.07459], [-118.80451, 34.07274], [-118.8025, 34.07272], [-118.80266, 34.07087], [-118.80701, 34.07087]]]} | Open Access 1 | 12586 | SMMNRA - Backbone Trail | 14272 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/samo/planyourvisit/backbonetrail.htm | Los Angeles 6 | 32.43 | SMMNRA - Backbone Trail | 0 | Recreation Management Area 49 | 4 |
13149 | 13149 | 13148 | {"type": "Polygon", "coordinates": [[[-122.42687, 37.8088], [-122.42684, 37.80881], [-122.42683, 37.80906], [-122.4268, 37.8093], [-122.42674, 37.80949], [-122.42667, 37.80967], [-122.42657, 37.80986], [-122.42642, 37.81007], [-122.42629, 37.81021], [-122.42615, 37.81034], [-122.42596, 37.81048], [-122.42576, 37.81058], [-122.42552, 37.81068], [-122.42532, 37.81074], [-122.42511, 37.81078], [-122.4249, 37.8108], [-122.42466, 37.81079], [-122.42446, 37.81075], [-122.42432, 37.81066], [-122.42427, 37.81059], [-122.42427, 37.81054], [-122.4243, 37.81048], [-122.42439, 37.81041], [-122.42449, 37.8104], [-122.4246, 37.81043], [-122.42466, 37.81049], [-122.42469, 37.81059], [-122.42474, 37.81063], [-122.42506, 37.81062], [-122.42535, 37.81056], [-122.42559, 37.81047], [-122.42582, 37.81035], [-122.42604, 37.81019], [-122.4262, 37.81003], [-122.42631, 37.80989], [-122.42649, 37.80957], [-122.42657, 37.80936], [-122.42661, 37.80919], [-122.42663, 37.80901], [-122.42663, 37.80883], [-122.42445, 37.8091], [-122.42439, 37.80887], [-122.42208, 37.80883], [-122.42194, 37.80818], [-122.42192, 37.80817], [-122.42162, 37.80788], [-122.42154, 37.80749], [-122.42086, 37.80757], [-122.4207, 37.80673], [-122.42249, 37.8065], [-122.42259, 37.80647], [-122.42486, 37.80619], [-122.42485, 37.80609], [-122.4257, 37.80598], [-122.4267, 37.80795], [-122.42687, 37.8088]]]} | Open Access 1 | 35096 | Aquatic Park | 14191 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/safr/planyourvisit/aquaticparkcove.htm | San Francisco 13 | 33.068 | Aquatic Park | 1972 | Recreation Management Area 49 | 4 |
6482 | 6482 | 6481 | {"type": "Polygon", "coordinates": [[[-117.49208, 34.25165], [-117.49191, 34.25249], [-117.49152, 34.25285], [-117.49137, 34.25324], [-117.49132, 34.25361], [-117.49123, 34.25396], [-117.49105, 34.25424], [-117.49036, 34.25487], [-117.4893, 34.25482], [-117.48921, 34.25572], [-117.48903, 34.25595], [-117.48918, 34.25659], [-117.48857, 34.25675], [-117.48821, 34.25693], [-117.48831, 34.25044], [-117.48889, 34.25065], [-117.48902, 34.25061], [-117.48981, 34.25022], [-117.49014, 34.24998], [-117.49082, 34.249], [-117.49174, 34.24937], [-117.49085, 34.25064], [-117.49156, 34.25086], [-117.49165, 34.25102], [-117.49152, 34.25158], [-117.49208, 34.25165]], [[-117.49013, 34.25218], [-117.48925, 34.25195], [-117.48893, 34.25197], [-117.48878, 34.25203], [-117.48864, 34.25212], [-117.48854, 34.25234], [-117.4886, 34.25252], [-117.48868, 34.25264], [-117.48886, 34.25268], [-117.49103, 34.25281], [-117.49118, 34.2523], [-117.49087, 34.25222], [-117.49059, 34.25219], [-117.49013, 34.25218]], [[-117.49121, 34.25106], [-117.491, 34.25096], [-117.49079, 34.25096], [-117.49009, 34.25081], [-117.48986, 34.25081], [-117.48975, 34.25092], [-117.48964, 34.2511], [-117.48964, 34.25126], [-117.48972, 34.25137], [-117.48993, 34.25146], [-117.49091, 34.25163], [-117.49119, 34.25161], [-117.49123, 34.25158], [-117.49126, 34.25121], [-117.49121, 34.25106]]]} | Open Access 1 | 2304 | Applewhite Campground | 15543 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | San Bernardino 22 | 36.645 | Applewhite Campground | 0 | Recreation Management Area 49 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);