units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
584 rows where AGNCY_LEV = 1 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV
MNG_AGENCY >30
- United States Bureau of Land Management 120
- United States Forest Service 111
- United States National Park Service 89
- United States Fish and Wildlife Service 78
- United States Army Corps of Engineers 52
- United States Bureau of Reclamation 29
- California Department of Parks and Recreation 27
- Other Federal 19
- California Department of Fish and Wildlife 14
- United States Coast Guard 8
- United States Department of Defense 5
- Los Angeles, County of 3
- University of California 3
- San Diego, County of 3
- East Bay Regional Park District 2
- Needles, City of 2
- San Bernardino, County of 2
- San Diego State University 2
- Riverside County Habitat Conservation Agency 2
- San Diego, City of 1
- Santa Barbara, County of 1
- Monterey, City of 1
- Sonoma Land Trust 1
- Los Angeles - Department of Parks and Recreation, County of 1
- Pico Rivera, City of 1
- Auburn Area Recreation and Park District 1
- Conejo Open Space Conservation Agency 1
- Port San Luis Harbor District 1
- Merced Irrigation District 1
- Palos Verdes Peninsula Land Conservancy 1
- …
DES_TP >30
- National Forest 96
- National Public Lands 75
- National Wildlife Refuge 69
- Recreation Management Area 61
- National Recreation Area 37
- National Park 26
- Resource Management Area 26
- Federal Other or Unknown 24
- National Monument or Landmark 23
- State Conservation Area 17
- State Recreation Area 17
- Conservation Area 14
- Local Park 8
- Wilderness Area 7
- Area of Critical Environmental Concern 7
- Local Recreation Area 6
- State Park 6
- Local Conservation Area 5
- Historic or Cultural Area 5
- Research or Educational Area 3
- None 1
- None 1
- State Historic or Cultural Area 1
- None 1
- None 1
- National Lakeshore or Seashore 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 11
ACCESS_TYP 4
- Open Access 452
- Restricted Access 90
- No Public Access 36
- Unknown Access 6
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3755 | 3755 | 3754 | {"type": "Polygon", "coordinates": [[[-122.43372, 38.14591], [-122.43337, 38.1458], [-122.43311, 38.14563], [-122.4322, 38.14524], [-122.43246, 38.1453], [-122.43352, 38.14575], [-122.43372, 38.14591]]]} | Open Access 1 | 461 | San Pablo Bay National Wildlife Refuge | 24963 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Sonoma 16 | 0.21 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
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 | |
10429 | 10429 | 10428 | {"type": "MultiPolygon", "coordinates": [[[[-122.50952, 37.78622], [-122.50946, 37.78624], [-122.50942, 37.78624], [-122.5094, 37.78621], [-122.5094, 37.78617], [-122.50943, 37.78614], [-122.50947, 37.78613], [-122.50952, 37.78618], [-122.50952, 37.78622]]], [[[-122.50967, 37.78577], [-122.50964, 37.78591], [-122.50955, 37.78593], [-122.5095, 37.78587], [-122.50949, 37.78581], [-122.50952, 37.78571], [-122.50956, 37.78569], [-122.50967, 37.78577]]], [[[-122.51005, 37.79251], [-122.50996, 37.79259], [-122.50989, 37.79258], [-122.50985, 37.79254], [-122.50986, 37.79246], [-122.50996, 37.79242], [-122.51003, 37.79245], [-122.51005, 37.79251]]], [[[-122.51015, 37.78577], [-122.51015, 37.78581], [-122.51012, 37.78585], [-122.51007, 37.78584], [-122.51004, 37.78581], [-122.51006, 37.78574], [-122.51009, 37.78573], [-122.51015, 37.78577]]], [[[-122.51065, 37.7927], [-122.51064, 37.79277], [-122.51057, 37.79283], [-122.51043, 37.79288], [-122.51032, 37.79285], [-122.51026, 37.79282], [-122.51022, 37.79277], [-122.51022, 37.79266], [-122.51024, 37.79261], [-122.51029, 37.79258], [-122.51043, 37.79253], [-122.51051, 37.79255], [-122.51058, 37.7926], [-122.51065, 37.7927]]], [[[-122.51076, 37.78721], [-122.51058, 37.78729], [-122.51047, 37.78729], [-122.51042, 37.78724], [-122.51067, 37.78714], [-122.51074, 37.78716], [-122.51076, 37.78721]]], [[[-122.51366, 37.78341], [-122.51355, 37.7835], [-122.51351, 37.78345], [-122.5135, 37.78334], [-122.51351, 37.78328], [-122.51358, 37.78326], [-122.51362, 37.78328], [-122.51366, 37.78335], [-122.51366, 37.78341]]], [[[-122.5141, 37.78274], [-122.514, 37.78273], [-122.51389, 37.78266], [-122.51387, 37.78262], [-122.51392, 37.78256], [-122.51398, 37.78256], [-122.51409, 37.78265], [-122.5141, 37.78274]]], [[[-122.514, 37.78294], [-122.514, 37.78296], [-122.51395, 37.78297], [-122.51389, 37.78295], [-122.51387, 37.7829], [-122.51388, 37.78288], [-122.51394, 37.78287], [-122.514, 37.78294]]], [[[-122.51433, 37.78268], [-122.51431, 37.78272], [-122.51425, 37.78272], [-122.51421, 37.78267], [-122.51425, 37.7826], [-122.51429, 37.78261], [-122.51433, 37.78268]]]]} | Open Access 1 | 21478 | California Coastal National Monument | 16715 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | San Francisco 13 | 0.695 | California Coastal NM | 2000 | National Monument or Landmark 80 | 3 | |
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 | |
5184 | 5184 | 5183 | {"type": "Polygon", "coordinates": [[[-122.00444, 36.96745], [-122.00387, 36.96749], [-122.00391, 36.96788], [-122.00368, 36.96786], [-122.00366, 36.96704], [-122.004, 36.96702], [-122.00401, 36.96714], [-122.00434, 36.96712], [-122.00444, 36.96745]]]} | Open Access 1 | 1479 | Twin Lakes - USA | 26615 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Santa Cruz 5 | 0.895 | Twin Lakes - USA | 0 | Federal Other or Unknown 87 | 4 | ||
9904 | 9904 | 9903 | {"type": "Polygon", "coordinates": [[[-120.98125, 37.06945], [-120.98076, 37.06939], [-120.98053, 37.06916], [-120.9804, 37.069], [-120.98041, 37.06827], [-120.9806, 37.06846], [-120.98083, 37.06901], [-120.98125, 37.06945]]]} | Open Access 1 | 16996 | United States Bureau of Reclamation | 13858 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Merced 37 | 0.907 | United States Bureau of Reclamation | 0 | Federal Other or Unknown 87 | 4 | |
6000 | 6000 | 5999 | {"type": "MultiPolygon", "coordinates": [[[[-119.90427, 38.00765], [-119.90155, 38.00769], [-119.90426, 38.00764], [-119.90417, 37.99681], [-119.89503, 37.99692], [-119.90419, 37.9968], [-119.9043, 38.00737], [-119.90427, 38.00765]]], [[[-119.89967, 38.00773], [-119.89967, 38.00761], [-119.89962, 38.00049], [-119.89963, 38.00049], [-119.89967, 38.00773]]], [[[-119.91335, 38.00029], [-119.90878, 38.00036], [-119.90882, 38.00455], [-119.90877, 38.00035], [-119.91335, 38.00029]]], [[[-119.91747, 38.00745], [-119.91346, 38.00751], [-119.91346, 38.00751], [-119.91346, 38.00751], [-119.91747, 38.00745]]], [[[-119.91643, 38.00385], [-119.91643, 38.00385], [-119.91388, 38.00389], [-119.91641, 38.00384], [-119.91643, 38.00385]]]]} | Open Access 1 | 647 | Hetch Hetchy Water and Power | 19887 | 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 | Tuolumne 21 | 1.045 | Hetch Hetchy Water and Power | None 483 | |||
2811 | 2811 | 2810 | {"type": "Polygon", "coordinates": [[[-119.14865, 35.67453], [-119.1475, 35.67452], [-119.1475, 35.67402], [-119.14865, 35.67402], [-119.14865, 35.67453]]]} | Open Access 1 | 14786 | United States Bureau of Reclamation | 13858 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Kern 36 | 1.453 | United States Bureau of Reclamation | 0 | Federal Other or Unknown 87 | 4 | |
911 | 911 | 910 | {"type": "Polygon", "coordinates": [[[-118.51445, 34.12995], [-118.51442, 34.13004], [-118.51434, 34.1301], [-118.51426, 34.13013], [-118.51414, 34.13012], [-118.51299, 34.12951], [-118.51312, 34.12943], [-118.5133, 34.12937], [-118.51381, 34.12933], [-118.51442, 34.12983], [-118.51445, 34.12991], [-118.51445, 34.12995]]]} | No Public Access 3 | 6367 | Encino Reservoir - Federal | 18670 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 1.48 | Encino Reservoir - Federal | 0 | Resource Management Area 82 | 3 | ||
10394 | 10394 | 10393 | {"type": "MultiPolygon", "coordinates": [[[[-117.53635, 34.18242], [-117.53635, 34.18254], [-117.53248, 34.18227], [-117.53248, 34.18202], [-117.53635, 34.18242]]], [[[-117.54058, 34.18647], [-117.53731, 34.18614], [-117.53731, 34.18611], [-117.54058, 34.18645], [-117.54058, 34.18647]]]]} | Open Access 1 | 18373 | Day Canyon Preserve | 17959 | 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 | 1.963 | Day Canyon Preserve | None 909 | |||
6056 | 6056 | 6055 | {"type": "Polygon", "coordinates": [[[-118.65875, 34.07333], [-118.65821, 34.07334], [-118.6582, 34.07327], [-118.65765, 34.07327], [-118.65765, 34.07272], [-118.65786, 34.07272], [-118.65786, 34.0725], [-118.65875, 34.07256], [-118.65875, 34.07333]]]} | Restricted Access 2 | 12780 | Santa Monica Mountains National Recreation Area | 29657 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://www.nps.gov/samo/index.htm | Los Angeles 6 | 2.045 | Santa Monica Mtns. NRA | 0 | National Recreation Area 54 | 3 |
15055 | 15055 | 15054 | {"type": "Polygon", "coordinates": [[[-120.75792, 35.15968], [-120.75792, 35.16019], [-120.75773, 35.16026], [-120.75658, 35.16025], [-120.75652, 35.16021], [-120.75651, 35.16016], [-120.75654, 35.15984], [-120.75647, 35.15959], [-120.75648, 35.15954], [-120.75651, 35.15949], [-120.75663, 35.15949], [-120.75677, 35.15953], [-120.75692, 35.15961], [-120.75725, 35.15965], [-120.75753, 35.15962], [-120.75792, 35.15968]]]} | Open Access 1 | 48515 | Point San Luis Lighthouse Public Access | 33227 | 104 | United States Coast Guard 511 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 2114 | Port San Luis Harbor District 501 | Special District 4 | Port/Harbor District 14 | http://pointsanluislighthouse.org/ | San Luis Obispo 1 | 2.258 | Point San Luis Lighthouse PA | 0 | Local Recreation Area 3 | 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 | ||
2892 | 2892 | 2891 | {"type": "Polygon", "coordinates": [[[-122.3644, 38.14004], [-122.36438, 38.1412], [-122.36339, 38.14077], [-122.36341, 38.13972], [-122.36362, 38.13981], [-122.3644, 38.14004]]]} | Open Access 1 | 23003 | San Pablo Bay National Wildlife Refuge | 24963 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Solano 26 | 2.6 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
7012 | 7012 | 7011 | {"type": "Polygon", "coordinates": [[[-118.29494, 33.706], [-118.29474, 33.70626], [-118.29296, 33.7054], [-118.29347, 33.70526], [-118.2937, 33.70507], [-118.29383, 33.7049], [-118.29412, 33.70493], [-118.29436, 33.70513], [-118.29437, 33.70542], [-118.29462, 33.70546], [-118.29464, 33.70561], [-118.29494, 33.706]]]} | Open Access 1 | 5950 | Point Fermin Lighthouse | 23849 | 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 | Los Angeles 6 | 2.92 | Point Fermin Lighthouse | None 572 | |||
16978 | 16978 | 16977 | {"type": "MultiPolygon", "coordinates": [[[[-118.58004, 34.11729], [-118.57961, 34.11728], [-118.57962, 34.1172], [-118.57942, 34.11719], [-118.57942, 34.11703], [-118.57963, 34.11702], [-118.57964, 34.11711], [-118.57997, 34.11712], [-118.57999, 34.11721], [-118.58004, 34.11729]]], [[[-118.58026, 34.11707], [-118.57996, 34.11707], [-118.57993, 34.11699], [-118.58026, 34.11699], [-118.58026, 34.11707]]], [[[-118.59209, 34.11758], [-118.59199, 34.11758], [-118.592, 34.11732], [-118.59205, 34.11731], [-118.59209, 34.11758]]], [[[-118.59243, 34.11621], [-118.59243, 34.11664], [-118.59225, 34.11664], [-118.5922, 34.1162], [-118.59243, 34.11621]]], [[[-118.60509, 34.13834], [-118.60509, 34.1393], [-118.60406, 34.13931], [-118.60406, 34.13835], [-118.60509, 34.13834]]]]} | Open Access 1 | 12672 | Santa Monica Mountains National Recreation Area | 32641 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.nps.gov/samo/index.htm | Los Angeles 6 | 3.089 | Santa Monica Mtns. NRA | 0 | National Recreation Area 54 | 3 |
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 | |
537 | 537 | 536 | {"type": "Polygon", "coordinates": [[[-118.93025, 34.14501], [-118.92997, 34.14499], [-118.92993, 34.14464], [-118.92975, 34.14379], [-118.92957, 34.14348], [-118.92948, 34.14328], [-118.92886, 34.14266], [-118.92864, 34.14235], [-118.92848, 34.14201], [-118.9283, 34.14173], [-118.92811, 34.14159], [-118.92784, 34.14148], [-118.9272, 34.14139], [-118.92693, 34.14128], [-118.92682, 34.1412], [-118.92674, 34.14104], [-118.9261, 34.14091], [-118.92611, 34.14077], [-118.92675, 34.14087], [-118.92687, 34.14075], [-118.92704, 34.14075], [-118.92725, 34.14084], [-118.92746, 34.14096], [-118.92768, 34.14103], [-118.92786, 34.14092], [-118.92801, 34.14071], [-118.92812, 34.14063], [-118.92829, 34.14063], [-118.92846, 34.14068], [-118.92868, 34.14092], [-118.92874, 34.14116], [-118.92841, 34.14085], [-118.92825, 34.14077], [-118.92811, 34.1408], [-118.92804, 34.14095], [-118.92794, 34.14107], [-118.92778, 34.14115], [-118.92765, 34.14115], [-118.92743, 34.14108], [-118.92726, 34.141], [-118.92709, 34.1409], [-118.92693, 34.14089], [-118.92688, 34.14102], [-118.92701, 34.14117], [-118.92717, 34.14123], [-118.92802, 34.14142], [-118.92829, 34.14151], [-118.92846, 34.14169], [-118.92862, 34.14194], [-118.92882, 34.14232], [-118.92903, 34.14264], [-118.92965, 34.14322], [-118.92974, 34.14342], [-118.92986, 34.14361], [-118.9301, 34.14436], [-118.93025, 34.14501]]]} | Open Access 1 | 2651 | Canilla Corp. | 14196 | 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 | Ventura 8 | 3.474 | Canilla Corp. | 0 | National Recreation Area 54 | 3 | |
17003 | 17003 | 17002 | {"type": "Polygon", "coordinates": [[[-124.07864, 40.04562], [-124.07862, 40.04581], [-124.07864, 40.04624], [-124.07861, 40.04664], [-124.07799, 40.04665], [-124.07798, 40.04646], [-124.07763, 40.04638], [-124.07767, 40.04611], [-124.07732, 40.04585], [-124.07662, 40.04552], [-124.07668, 40.04548], [-124.07683, 40.0453], [-124.07689, 40.04525], [-124.07694, 40.04522], [-124.07711, 40.0453], [-124.07735, 40.04533], [-124.07791, 40.04538], [-124.07818, 40.04533], [-124.07837, 40.04536], [-124.07855, 40.04545], [-124.07864, 40.04562]]]} | Open Access 1 | 46939 | King Range National Conservation Area | 30563 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/ca/st/en/prog/nlcs/King_Range_NCA/recreation/trails.html | Humboldt 45 | 3.788 | King Range Nat. Conservation Area | 0 | Conservation Area 13 | 2 |
12958 | 12958 | 12957 | {"type": "Polygon", "coordinates": [[[-114.60317, 34.84764], [-114.60145, 34.84762], [-114.60072, 34.84705], [-114.60071, 34.84633], [-114.60186, 34.84686], [-114.60298, 34.84742], [-114.60317, 34.84764]]]} | Open Access 1 | 30413 | Manny Morris Beach Side Park | 33661 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 1220 | Needles, City of 276 | City 2 | City Agency 2 | http://cityofneedles.com/manny-morris-beach-side-park/ | San Bernardino 22 | 3.852 | Manny Morris Beach Side Park | 0 | Local Park 2 | 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]);