units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
70 rows where DES_TP = 104 sorted by AGNCY_WEB descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, COUNTY
MNG_AGENCY 13
- California Department of Transportation 21
- California Department of General Services 11
- California Department of Fish and Wildlife 10
- Other State 9
- California Department of Parks and Recreation 5
- California Wildlife Conservation Board 4
- California Department of Water Resources 2
- California State University 2
- California Tahoe Conservancy 2
- University of California 1
- California State Lands Commission 1
- San Joaquin River Parkway and Conservation Trust 1
- Coachella Valley Mountains Conservancy 1
ACCESS_TYP 4
MNG_AG_TYP 2
DES_TP 1
- State Other or Unknown · 70 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3676 | 3676 | 3675 | {"type": "Polygon", "coordinates": [[[-123.9944, 40.85728], [-123.98793, 40.85729], [-123.98823, 40.85355], [-123.99083, 40.85359], [-123.991, 40.85206], [-123.99205, 40.85205], [-123.99208, 40.8536], [-123.99105, 40.85359], [-123.99104, 40.8536], [-123.99158, 40.85448], [-123.99209, 40.85481], [-123.99433, 40.85721], [-123.9944, 40.85728]]]} | Open Access 1 | 44354 | Mad River Fish Hatchery | 32212 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Humboldt 45 | 43.3 | Mad River Fish Hatchery | 0 | State Other or Unknown 104 | 4 | |
3679 | 3679 | 3678 | {"type": "Polygon", "coordinates": [[[-118.88648, 34.3927], [-118.88616, 34.39362], [-118.88606, 34.39361], [-118.88569, 34.39465], [-118.88193, 34.39395], [-118.88215, 34.39142], [-118.88648, 34.3927]]]} | Open Access 1 | 44358 | Fillmore Fish Hatchery | 32165 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Ventura 8 | 24.109 | Fillmore Fish Hatchery | 0 | State Other or Unknown 104 | 4 | |
3680 | 3680 | 3679 | {"type": "Polygon", "coordinates": [[[-117.26286, 34.48019], [-117.26032, 34.48127], [-117.25982, 34.48047], [-117.25985, 34.47881], [-117.25943, 34.47781], [-117.26087, 34.47739], [-117.26169, 34.47931], [-117.26221, 34.47915], [-117.26286, 34.48019]]]} | Open Access 1 | 44360 | Mojave River Fish Hatchery | 32227 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 17.666 | Mojave River Fish Hatchery | 0 | State Other or Unknown 104 | 4 | |
4771 | 4771 | 4770 | {"type": "Polygon", "coordinates": [[[-124.09931, 40.49321], [-124.09822, 40.4937], [-124.09816, 40.49283], [-124.09855, 40.49302], [-124.09884, 40.49286], [-124.09931, 40.49321]]]} | Open Access 1 | 46932 | Unnamed site - California Department of Fish and Wildlife | 30559 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Humboldt 45 | 1.271 | 0 | State Other or Unknown 104 | 4 | ||
6495 | 6495 | 6494 | {"type": "Polygon", "coordinates": [[[-122.3326, 41.30589], [-122.33249, 41.3062], [-122.33207, 41.30637], [-122.33217, 41.30672], [-122.33166, 41.30715], [-122.33116, 41.30804], [-122.33115, 41.30819], [-122.33034, 41.30844], [-122.33029, 41.30956], [-122.33025, 41.30957], [-122.33012, 41.30987], [-122.32975, 41.31021], [-122.32973, 41.31055], [-122.32915, 41.3101], [-122.32887, 41.30992], [-122.32817, 41.30958], [-122.32679, 41.30908], [-122.32659, 41.30891], [-122.32846, 41.30749], [-122.32846, 41.30626], [-122.33044, 41.30579], [-122.33046, 41.30533], [-122.33252, 41.30536], [-122.33252, 41.30566], [-122.3326, 41.30589]]]} | Open Access 1 | 2367 | Mount Shasta Fish Hatchery | 32233 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Siskiyou 28 | 32.759 | Mount Shasta Fish Hatchery | 0 | State Other or Unknown 104 | 4 | |
6906 | 6906 | 6905 | {"type": "Polygon", "coordinates": [[[-121.85532, 36.96849], [-121.8553, 36.97036], [-121.85531, 36.97247], [-121.8493, 36.97206], [-121.84933, 36.97197], [-121.84969, 36.9715], [-121.84967, 36.97143], [-121.85036, 36.97084], [-121.85035, 36.97049], [-121.85054, 36.97015], [-121.85084, 36.97007], [-121.85123, 36.96986], [-121.85152, 36.96938], [-121.85532, 36.96849]]]} | No Public Access 3 | 47542 | San Andreas Creek - King Property | 31250 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Santa Cruz 5 | 39.619 | San Andreas Creek - King Property | 0 | State Other or Unknown 104 | 4 | |
7566 | 7566 | 7565 | {"type": "MultiPolygon", "coordinates": [[[[-118.79086, 34.75249], [-118.7905, 34.75269], [-118.78995, 34.75282], [-118.78833, 34.75304], [-118.7856, 34.75305], [-118.78493, 34.75343], [-118.7845, 34.75351], [-118.78357, 34.75316], [-118.78272, 34.7538], [-118.78126, 34.75417], [-118.78017, 34.75394], [-118.77903, 34.75547], [-118.77894, 34.75664], [-118.77779, 34.75756], [-118.77848, 34.758], [-118.77841, 34.75986], [-118.77886, 34.75987], [-118.77913, 34.76202], [-118.77761, 34.76518], [-118.77755, 34.76574], [-118.77634, 34.76582], [-118.77522, 34.7637], [-118.77346, 34.76262], [-118.77195, 34.76241], [-118.77418, 34.76093], [-118.7718, 34.76016], [-118.7718, 34.75988], [-118.77251, 34.75988], [-118.77253, 34.75986], [-118.77541, 34.75987], [-118.77538, 34.75716], [-118.76641, 34.75721], [-118.76641, 34.7563], [-118.76211, 34.75628], [-118.76217, 34.75101], [-118.76215, 34.74996], [-118.76216, 34.74903], [-118.74905, 34.74906], [-118.74903, 34.74547], [-118.74904, 34.73837], [-118.75789, 34.73825], [-118.75783, 34.7453], [-118.75784, 34.74543], [-118.76664, 34.74538], [-118.76648, 34.75269], [-118.78437, 34.75246], [-118.79086, 34.75249]]], [[[-118.81161, 34.69934], [-118.80281, 34.69927], [-118.80282, 34.70238], [-118.80001, 34.70204], [-118.79731, 34.7014], [-118.79715, 34.70135], [-118.79688, 34.70122], [-118.79659, 34.70101], [-118.79636, 34.70072], [-118.79535, 34.69892], [-118.79396, 34.69519], [-118.79373, 34.69386], [-118.79362, 34.6936], [-118.79348, 34.69334], [-118.7933, 34.69308], [-118.7926, 34.69251], [-118.79179, 34.69207], [-118.79171, 34.69193], [-118.79408, 34.69176], [-118.80275, 34.69201], [-118.80714, 34.69205], [-118.80718, 34.69567], [-118.81157, 34.69571], [-118.81161, 34.69934]]], [[[-118.7954, 34.74528], [-118.79529, 34.74598], [-118.79517, 34.74694], [-118.79477, 34.7469], [-118.79447, 34.74857], [-118.79437, 34.74895], [-118.79362, 34.75118], [-118.79356, 34.75131], [-118.79347, 34.75144], [-118.79333, 34.75159], [-118.79322, 34.75168], [-118.79317, 34.74518], [-118.7953, 34.74521], [-118.7954, 34.74528]]]]} | No Public Access 3 | 7259 | DWR Mitigation -- L.A. Property | 32152 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Los Angeles 6 | 999.598 | DWR Mitigation -- L.A. Property | 0 | State Other or Unknown 104 | 4 | |
7674 | 7674 | 7673 | {"type": "Polygon", "coordinates": [[[-119.72154, 36.98342], [-119.72124, 36.98436], [-119.72043, 36.98505], [-119.72041, 36.98576], [-119.72081, 36.98612], [-119.71504, 36.98955], [-119.71421, 36.98877], [-119.71461, 36.98852], [-119.71382, 36.98803], [-119.71385, 36.98732], [-119.71406, 36.98693], [-119.71412, 36.9868], [-119.71485, 36.98589], [-119.7156, 36.98567], [-119.71653, 36.98603], [-119.71687, 36.98603], [-119.71851, 36.98504], [-119.7193, 36.98381], [-119.72074, 36.98281], [-119.72122, 36.98286], [-119.72154, 36.98342]]]} | Open Access 1 | 7583 | San Joaquin Fish Hatchery | 32294 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Fresno 9 | 49.554 | San Joaquin Fish Hatchery | 0 | State Other or Unknown 104 | 4 | |
10013 | 10013 | 10012 | {"type": "Polygon", "coordinates": [[[-121.0344, 37.04936], [-121.02559, 37.04938], [-121.02568, 37.04211], [-121.02537, 37.0413], [-121.02528, 37.04058], [-121.02522, 37.04034], [-121.03435, 37.04041], [-121.03434, 37.04218], [-121.0344, 37.04936]]]} | No Public Access 3 | 17275 | Jasper Sears Mitigation Parcel | 32192 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Merced 37 | 192.527 | Jasper Sears Mitigation Parcel | 0 | State Other or Unknown 104 | 4 | |
14336 | 14336 | 14335 | {"type": "Polygon", "coordinates": [[[-122.00031, 40.43185], [-122.00029, 40.43226], [-121.99983, 40.4321], [-121.99906, 40.4325], [-121.99844, 40.43331], [-121.99657, 40.43358], [-121.99441, 40.43303], [-121.99419, 40.433], [-121.9926, 40.43265], [-121.99119, 40.43195], [-121.99124, 40.42927], [-121.99732, 40.42914], [-121.99734, 40.42833], [-122.00029, 40.42825], [-122.00031, 40.43185]]]} | Open Access 1 | 44352 | Darrah Springs Fish Hatchery | 32144 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Shasta 27 | 85.045 | Darrah Springs Fish Hatchery | 0 | State Other or Unknown 104 | 4 | |
4478 | 4478 | 4477 | {"type": "Polygon", "coordinates": [[[-116.49292, 33.88852], [-116.49291, 33.8894], [-116.48878, 33.88856], [-116.49198, 33.88852], [-116.49292, 33.88852]]]} | Unknown Access 4 | 3751 | Unnamed site - California Wildlife Conservation Board | 28678 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | Riverside 10 | 4.66 | 0 | State Other or Unknown 104 | 4 | ||
4479 | 4479 | 4478 | {"type": "Polygon", "coordinates": [[[-116.49291, 33.88957], [-116.4929, 33.89588], [-116.48423, 33.89587], [-116.48427, 33.8886], [-116.48805, 33.88856], [-116.49291, 33.88957]]]} | Unknown Access 4 | 3752 | Unnamed site - California Wildlife Conservation Board | 28678 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | Riverside 10 | 154.196 | 0 | State Other or Unknown 104 | 4 | ||
4486 | 4486 | 4485 | {"type": "Polygon", "coordinates": [[[-116.24853, 33.84567], [-116.24851, 33.84812], [-116.24644, 33.84703], [-116.24644, 33.84565], [-116.24853, 33.84567]]]} | Unknown Access 4 | 4473 | Unnamed site - California Wildlife Conservation Board | 28678 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | Riverside 10 | 10.124 | 0 | State Other or Unknown 104 | 4 | ||
4531 | 4531 | 4530 | {"type": "Polygon", "coordinates": [[[-117.08544, 34.21542], [-117.08542, 34.22251], [-117.08407, 34.22245], [-117.08415, 34.22223], [-117.08413, 34.22191], [-117.0839, 34.22174], [-117.08329, 34.22154], [-117.08268, 34.22152], [-117.08221, 34.22141], [-117.08181, 34.22089], [-117.08145, 34.22017], [-117.08127, 34.21946], [-117.08113, 34.21914], [-117.08087, 34.21887], [-117.08049, 34.2187], [-117.08027, 34.21843], [-117.08021, 34.21815], [-117.0801, 34.21792], [-117.07994, 34.21776], [-117.07952, 34.21768], [-117.07906, 34.2178], [-117.07588, 34.219], [-117.07557, 34.21902], [-117.07495, 34.21901], [-117.07449, 34.21893], [-117.07394, 34.21892], [-117.07325, 34.21894], [-117.07251, 34.21904], [-117.07197, 34.21922], [-117.07435, 34.21745], [-117.07487, 34.21718], [-117.0755, 34.21664], [-117.07606, 34.21615], [-117.07698, 34.2154], [-117.07709, 34.21533], [-117.08106, 34.21533], [-117.08107, 34.21539], [-117.08544, 34.21542]]]} | Open Access 1 | 18388 | Unnamed site - California Wildlife Conservation Board | 28679 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | San Bernardino 22 | 117.167 | 0 | State Other or Unknown 104 | 4 | ||
2095 | 2095 | 2094 | {"type": "Polygon", "coordinates": [[[-121.70681, 38.27679], [-121.69559, 38.279], [-121.69594, 38.27864], [-121.69605, 38.27822], [-121.69594, 38.27776], [-121.69591, 38.27776], [-121.69526, 38.27319], [-121.69496, 38.27168], [-121.6945, 38.26631], [-121.69503, 38.266], [-121.69541, 38.26585], [-121.69632, 38.26585], [-121.69693, 38.26661], [-121.69714, 38.2671], [-121.69799, 38.2678], [-121.69895, 38.26831], [-121.69965, 38.26846], [-121.69988, 38.26865], [-121.70056, 38.26926], [-121.70453, 38.27349], [-121.70503, 38.27408], [-121.70574, 38.27512], [-121.70586, 38.27551], [-121.70622, 38.27614], [-121.70681, 38.27679]]]} | No Public Access 3 | 15834 | DWR Mitigation | 18327 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Solano 26 | 213.26 | DWR Mitigation | 0 | State Other or Unknown 104 | 4 | |
4832 | 4832 | 4831 | {"type": "Polygon", "coordinates": [[[-120.98197, 36.98324], [-120.98213, 36.97644], [-120.98853, 36.97639], [-120.98853, 36.97728], [-120.98854, 36.97729], [-120.99081, 36.97728], [-120.99083, 36.97637], [-120.99972, 36.9763], [-120.99974, 36.96892], [-121.00106, 36.96895], [-121.00407, 36.96895], [-121.00406, 36.96511], [-121.00864, 36.96512], [-121.00866, 36.96896], [-121.0127, 36.96898], [-121.01274, 36.98375], [-121.0096, 36.98369], [-121.00985, 36.99054], [-120.99991, 36.99067], [-120.99095, 36.99055], [-120.98203, 36.9904], [-120.98197, 36.98324]]]} | Open Access 1 | 49077 | Unnamed Site - California Department of Water Resources | 33776 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Merced 37 | 1286.898 | 0 | State Other or Unknown 104 | 4 | ||
4773 | 4773 | 4772 | {"type": "MultiPolygon", "coordinates": [[[[-124.24021, 40.69417], [-124.23559, 40.69411], [-124.23559, 40.69168], [-124.23695, 40.69223], [-124.23917, 40.69269], [-124.23992, 40.69296], [-124.24019, 40.69317], [-124.24021, 40.69417]]], [[[-124.24508, 40.7334], [-124.24498, 40.73418], [-124.24133, 40.73757], [-124.24139, 40.73806], [-124.24119, 40.73823], [-124.24034, 40.73821], [-124.24066, 40.73756], [-124.24062, 40.73631], [-124.24108, 40.73545], [-124.24262, 40.73463], [-124.24508, 40.7334]]]]} | Open Access 1 | 46934 | Unnamed site - California State Lands Commission | 30557 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Humboldt 45 | 35.708 | 0 | State Other or Unknown 104 | 4 | ||
1169 | 1169 | 1168 | {"type": "MultiPolygon", "coordinates": [[[[-118.27708, 34.23336], [-118.2746, 34.23281], [-118.27449, 34.23274], [-118.27367, 34.23255], [-118.26859, 34.23141], [-118.268, 34.23107], [-118.26755, 34.23097], [-118.26718, 34.23078], [-118.26693, 34.23072], [-118.2668, 34.23061], [-118.26718, 34.23041], [-118.26682, 34.22994], [-118.26683, 34.22784], [-118.26967, 34.22964], [-118.27167, 34.23046], [-118.27708, 34.23336]]], [[[-118.27981, 34.23393], [-118.27925, 34.23386], [-118.27867, 34.23373], [-118.27191, 34.2301], [-118.26993, 34.22928], [-118.26683, 34.22733], [-118.26687, 34.22185], [-118.27531, 34.22179], [-118.27539, 34.2291], [-118.27975, 34.22907], [-118.27981, 34.23393]]]]} | Open Access 1 | 6828 | Verdugo Mountains Park Property | 1781 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=635 | Los Angeles 6 | 252.47 | Verdugo Mtns. Park Property | 1984 | State Other or Unknown 104 | 4 |
2979 | 2979 | 2978 | {"type": "Polygon", "coordinates": [[[-120.17147, 39.1305], [-120.17145, 39.13637], [-120.1712, 39.13638], [-120.17094, 39.1367], [-120.17066, 39.13676], [-120.17037, 39.13686], [-120.16983, 39.13691], [-120.16953, 39.1369], [-120.16901, 39.1366], [-120.16873, 39.13657], [-120.16812, 39.13666], [-120.16724, 39.13647], [-120.16687, 39.13649], [-120.1665, 39.13654], [-120.16616, 39.13643], [-120.16584, 39.1362], [-120.16563, 39.1361], [-120.16571, 39.13591], [-120.1652, 39.13575], [-120.16498, 39.13614], [-120.16475, 39.13622], [-120.16449, 39.13598], [-120.16342, 39.13584], [-120.16284, 39.13583], [-120.1626, 39.13559], [-120.16205, 39.13522], [-120.16162, 39.13528], [-120.16163, 39.13525], [-120.16143, 39.13496], [-120.16121, 39.13469], [-120.16081, 39.13411], [-120.16023, 39.13417], [-120.16027, 39.13409], [-120.15972, 39.13392], [-120.15967, 39.134], [-120.15941, 39.13389], [-120.15925, 39.13375], [-120.15847, 39.13314], [-120.15794, 39.13293], [-120.15793, 39.1329], [-120.15754, 39.13275], [-120.16017, 39.13035], [-120.16115, 39.12938], [-120.16136, 39.12912], [-120.16153, 39.12885], [-120.16198, 39.12785], [-120.16434, 39.1285], [-120.16376, 39.12982], [-120.16458, 39.13004], [-120.16447, 39.13029], [-120.16447, 39.13031], [-120.16653, 39.13089], [-120.16723, 39.12932], [-120.17147, 39.1305]]]} | Open Access 1 | 20528 | Ward Creek Property | 1782 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=513 | Placer 35 | 183.198 | Ward Creek Property | 1978 | State Other or Unknown 104 | 4 |
4776 | 4776 | 4775 | {"type": "MultiPolygon", "coordinates": [[[[-123.78094, 40.04105], [-123.77631, 40.04038], [-123.77621, 40.03407], [-123.77658, 40.03481], [-123.77778, 40.03667], [-123.77813, 40.03737], [-123.77819, 40.03767], [-123.7784, 40.03788], [-123.77868, 40.0386], [-123.77936, 40.03934], [-123.78039, 40.0401], [-123.78085, 40.0399], [-123.78089, 40.03991], [-123.78086, 40.03993], [-123.78094, 40.04105]]], [[[-124.15793, 40.54867], [-124.15215, 40.54859], [-124.15399, 40.54211], [-124.15466, 40.54314], [-124.15526, 40.54451], [-124.15583, 40.5456], [-124.15629, 40.54623], [-124.157, 40.54706], [-124.15756, 40.54776], [-124.15793, 40.54867]]], [[[-124.15905, 40.56405], [-124.15698, 40.56404], [-124.15638, 40.56307], [-124.15904, 40.5631], [-124.15905, 40.56405]]], [[[-124.17889, 40.59558], [-124.17889, 40.59558], [-124.17622, 40.59879], [-124.17608, 40.59791], [-124.17668, 40.59502], [-124.17645, 40.59463], [-124.17889, 40.59558]]]]} | Open Access 1 | 46941 | Unnamed site - California Department of Parks and Recreation | 30566 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | Humboldt 45 | 91.244 | 0 | State Other or Unknown 104 | 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]);