units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
802 rows where MNG_AG_LEV = 6 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, GAP_STS
MNG_AGENCY >30
- The Nature Conservancy 51
- National Audubon Society 32
- Mountains Restoration Trust 30
- Rivers and Lands Conservancy 28
- Peninsula Open Space Trust 27
- Center for Natural Lands Management 25
- Sonoma Land Trust 25
- The Wildlands Conservancy 24
- Truckee Donner Land Trust 24
- Big Sur Land Trust 21
- The Environmental Trust 21
- American River Conservancy 20
- Save the Redwoods League 18
- Land Trust of Napa County 18
- Sempervirens Fund 18
- Save Mount Diablo 17
- Land Trust of Santa Cruz County 16
- Fallbrook Land Conservancy 15
- Endangered Habitats Conservancy 14
- Wilderness Land Trust 14
- San Joaquin River Parkway and Conservation Trust 12
- Bear Yuba Land Trust 10
- Friends of the Desert Mountains 10
- Del Monte Forest Foundation 10
- Mojave Desert Land Trust 10
- Marin Audubon Society 9
- Elkhorn Slough Foundation 9
- The Conservation Fund - California 9
- John Muir Land Trust 8
- Solano Land Trust 8
- …
DES_TP >30
- Private Conservation 613
- Private Recreation or Education 76
- Private Other or Unknown 51
- Private Agricultural 12
- National Monument or Landmark 4
- Private Historic or Cultural 4
- State Conservation Area 1
- State Park 1
- State Recreation Area 1
- State Other or Unknown 1
- National Wildlife Refuge 1
- State Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
LAYER 9 ✖
MNG_AG_TYP 5
ACCESS_TYP 4
- Open Access 302
- No Public Access 268
- Restricted Access 168
- Unknown Access 64
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2239 | 2239 | 2238 | {"type": "Polygon", "coordinates": [[[-119.81102, 36.87326], [-119.80959, 36.87329], [-119.8096, 36.87351], [-119.81007, 36.87379], [-119.81022, 36.87384], [-119.81101, 36.87381], [-119.81092, 36.88017], [-119.80915, 36.88029], [-119.80178, 36.8809], [-119.79911, 36.88089], [-119.80337, 36.87899], [-119.80477, 36.87934], [-119.80542, 36.8792], [-119.8063, 36.87931], [-119.8063, 36.8783], [-119.80622, 36.87802], [-119.80565, 36.87825], [-119.80549, 36.8785], [-119.80516, 36.87785], [-119.79392, 36.8778], [-119.79337, 36.87782], [-119.79334, 36.87681], [-119.79332, 36.8768], [-119.7933, 36.87682], [-119.79325, 36.87549], [-119.79577, 36.8744], [-119.80082, 36.87025], [-119.80215, 36.86845], [-119.80261, 36.86797], [-119.80445, 36.86616], [-119.80599, 36.86497], [-119.80929, 36.86355], [-119.80935, 36.86353], [-119.81041, 36.86422], [-119.81111, 36.86607], [-119.81102, 36.87326]]]} | Unknown Access 4 | 16693 | Van Buren Unit | 26820 | 2345 | Tehachapi-Cummings County Water District 499 | Special District 4 | Water District 13 | http://tccwd.com/ | Special District 4 | 3069 | San Joaquin River Parkway and Conservation Trust 491 | Non Profit 6 | Non Profit - Land Trust 10 | Madera 48 | 433.198 | Van Buren Unit | None 186 | |||
2489 | 2489 | 2488 | {"type": "Polygon", "coordinates": [[[-122.44958, 37.76633], [-122.44898, 37.76641], [-122.44881, 37.76647], [-122.44849, 37.76654], [-122.44848, 37.76657], [-122.44806, 37.76662], [-122.44802, 37.76642], [-122.44844, 37.76637], [-122.44846, 37.7664], [-122.44872, 37.76635], [-122.44892, 37.76627], [-122.44902, 37.7662], [-122.44899, 37.76602], [-122.4495, 37.76595], [-122.44958, 37.76633]]]} | Open Access 1 | 48909 | Richard Gamble Memorial Park | 33627 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | https://www.sfparksalliance.org/our-parks/parks/gamble-memorial-park | San Francisco 13 | 0.912 | Richard Gamble Memorial Park | None 205 | ||
3034 | 3034 | 3033 | {"type": "Polygon", "coordinates": [[[-122.39104, 37.75772], [-122.39035, 37.75777], [-122.39033, 37.7576], [-122.39101, 37.75756], [-122.39104, 37.75772]]]} | Open Access 1 | 48833 | Woods Yard | 33552 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | https://www.sfparksalliance.org/our-parks/parks/woods-yard | San Francisco 13 | 0.275 | Woods Yard | None 249 | ||
3568 | 3568 | 3567 | {"type": "Polygon", "coordinates": [[[-117.12444, 32.57552], [-117.12422, 32.57552], [-117.12425, 32.57652], [-117.12305, 32.57652], [-117.12307, 32.5737], [-117.12357, 32.57366], [-117.12388, 32.57374], [-117.12399, 32.57387], [-117.12401, 32.57408], [-117.12442, 32.57408], [-117.12444, 32.57552]]]} | Open Access 1 | 439 | Imperial Beach Sports Park | 31474 | 1143 | Imperial Beach, City of 630 | City 2 | City Agency 2 | http://www.imperialbeachca.gov/index.asp?Type=B_BASIC&SEC={9F232DF8-5366-4BA2-A4B8-8795196F6D81} | City 2 | 7018 | Boys and Girls Clubs of South County 649 | Non Profit 6 | Non Profit - Other 20 | http://www.bgcscounty.org/portal/home | San Diego 4 | 8.985 | Imperial Beach Sports Park | None 298 | ||
3710 | 3710 | 3709 | {"type": "Polygon", "coordinates": [[[-117.12997, 34.00757], [-117.12565, 34.00736], [-117.12569, 34.01105], [-117.12135, 34.01083], [-117.12136, 34.0124], [-117.11672, 34.01318], [-117.11671, 34.01471], [-117.11253, 34.01494], [-117.11247, 34.01855], [-117.11191, 34.01851], [-117.1119, 34.01823], [-117.11177, 34.01822], [-117.1117, 34.01827], [-117.11153, 34.01825], [-117.11138, 34.01805], [-117.11128, 34.01822], [-117.11086, 34.01823], [-117.10962, 34.01775], [-117.10954, 34.01781], [-117.10954, 34.01786], [-117.10942, 34.01774], [-117.10934, 34.01772], [-117.10927, 34.01772], [-117.10918, 34.01753], [-117.10925, 34.01752], [-117.10915, 34.01654], [-117.10816, 34.01601], [-117.10719, 34.01448], [-117.10708, 34.0126], [-117.10573, 34.01116], [-117.10685, 34.01022], [-117.10756, 34.01071], [-117.11261, 34.01028], [-117.1126, 34.01067], [-117.11262, 34.01068], [-117.11494, 34.0093], [-117.1164, 34.00859], [-117.11749, 34.00742], [-117.11913, 34.0066], [-117.11913, 34.00658], [-117.11825, 34.00577], [-117.11884, 34.00524], [-117.11984, 34.00498], [-117.12059, 34.00429], [-117.12243, 34.00429], [-117.12244, 34.00434], [-117.12273, 34.00488], [-117.12362, 34.00456], [-117.12395, 34.00465], [-117.12397, 34.00461], [-117.12449, 34.00464], [-117.12498, 34.0043], [-117.12991, 34.0043], [-117.12997, 34.00757]]]} | Open Access 1 | 48815 | Live Oak Canyon Open Space | 33535 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 3302 | Redlands Conservancy 660 | Non Profit 6 | Non Profit - Other 20 | San Bernardino 22 | 338.281 | Live Oak Canyon OS | None 309 | |||
4103 | 4103 | 4102 | {"type": "Polygon", "coordinates": [[[-120.13295, 34.59237], [-120.13291, 34.59524], [-120.12773, 34.5952], [-120.12768, 34.59802], [-120.12682, 34.59784], [-120.12694, 34.59711], [-120.12699, 34.59605], [-120.1268, 34.59601], [-120.12734, 34.59501], [-120.12845, 34.59417], [-120.12826, 34.59379], [-120.1283, 34.59233], [-120.13295, 34.59237]]]} | Restricted Access 2 | 47041 | Santa Ines Mission Mill | 30693 | 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 | 3372 | Santa Barbara Trust for Historic Preservation 706 | Non Profit 6 | Non Profit - Other 20 | http://www.sbthp.org/ | Santa Barbara 7 | 40.009 | Santa Ines Mission Mill | None 356 | ||
4297 | 4297 | 4296 | {"type": "Polygon", "coordinates": [[[-118.29942, 33.77494], [-118.29942, 33.77696], [-118.29939, 33.77872], [-118.29927, 33.77873], [-118.2993, 33.77912], [-118.29933, 33.77926], [-118.29899, 33.77937], [-118.29847, 33.77958], [-118.29817, 33.77974], [-118.29789, 33.77991], [-118.29756, 33.78016], [-118.29733, 33.78036], [-118.29719, 33.7805], [-118.29689, 33.78086], [-118.29653, 33.78039], [-118.29642, 33.78022], [-118.29629, 33.77995], [-118.2962, 33.77972], [-118.29612, 33.77939], [-118.29609, 33.77919], [-118.29609, 33.77886], [-118.29607, 33.77885], [-118.2962, 33.77664], [-118.29621, 33.77606], [-118.29618, 33.77577], [-118.29613, 33.77548], [-118.29607, 33.77519], [-118.296, 33.77494], [-118.29942, 33.77494]]]} | Restricted Access 2 | 45339 | Defense Fuel Supply Point (DFSP) - Hab. Restoration | 18014 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 3052 | Palos Verdes Peninsula Land Conservancy 727 | Non Profit 6 | Non Profit - Land Trust 10 | Los Angeles 6 | 41.501 | Defense Fuel Supply Point (DFSP) - Hab. Restoration | None 377 | ||||
5442 | 5442 | 5441 | {"type": "Polygon", "coordinates": [[[-124.12175, 41.85473], [-124.12022, 41.8547], [-124.12029, 41.85451], [-124.12039, 41.85336], [-124.12051, 41.85288], [-124.12086, 41.85203], [-124.12082, 41.85183], [-124.1206, 41.85116], [-124.12052, 41.85103], [-124.11957, 41.84978], [-124.11897, 41.84931], [-124.11887, 41.84921], [-124.11873, 41.84904], [-124.11853, 41.84866], [-124.11837, 41.84841], [-124.11816, 41.84818], [-124.11785, 41.84791], [-124.11786, 41.84746], [-124.11787, 41.84745], [-124.11789, 41.844], [-124.11857, 41.84418], [-124.11873, 41.84427], [-124.11878, 41.84428], [-124.11892, 41.8444], [-124.11931, 41.84468], [-124.11935, 41.84475], [-124.1195, 41.84487], [-124.11963, 41.84504], [-124.11963, 41.84517], [-124.1196, 41.8453], [-124.11931, 41.84591], [-124.1192, 41.84639], [-124.11922, 41.84657], [-124.11919, 41.84694], [-124.11925, 41.8474], [-124.11925, 41.84746], [-124.11923, 41.84747], [-124.11922, 41.84771], [-124.11927, 41.8479], [-124.11933, 41.84838], [-124.11951, 41.8488], [-124.1196, 41.84896], [-124.11967, 41.84915], [-124.11975, 41.84929], [-124.1202, 41.84969], [-124.12029, 41.84987], [-124.12034, 41.85003], [-124.12035, 41.85018], [-124.12044, 41.85039], [-124.12052, 41.85067], [-124.12103, 41.85116], [-124.12122, 41.85138], [-124.12141, 41.85169], [-124.1216, 41.85199], [-124.12187, 41.85262], [-124.12197, 41.85302], [-124.12195, 41.85363], [-124.12196, 41.85398], [-124.12188, 41.85421], [-124.12175, 41.85473]]]} | Open Access 1 | 47734 | Ruby Van Deventer County Park | 31536 | 347 | Del Norte County Parks, County of 672 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.savetheredwoods.org/park/ruby-van-deventer-county-park/ | Del Norte 50 | 27.24 | Ruby Van Deventer County Park | None 439 | ||
5615 | 5615 | 5614 | {"type": "Polygon", "coordinates": [[[-117.76036, 33.6333], [-117.76003, 33.63457], [-117.75946, 33.63534], [-117.75959, 33.6366], [-117.75799, 33.63627], [-117.75777, 33.63505], [-117.75816, 33.6341], [-117.75829, 33.63301], [-117.75797, 33.63238], [-117.75941, 33.63136], [-117.7596, 33.63046], [-117.75905, 33.62932], [-117.75748, 33.62811], [-117.75568, 33.62795], [-117.75455, 33.62681], [-117.75287, 33.62703], [-117.75232, 33.62772], [-117.75125, 33.62754], [-117.75066, 33.62795], [-117.75052, 33.62877], [-117.75004, 33.62956], [-117.75011, 33.62997], [-117.75038, 33.63063], [-117.75039, 33.63152], [-117.75084, 33.63193], [-117.75088, 33.63311], [-117.75252, 33.63418], [-117.75221, 33.63484], [-117.75027, 33.63452], [-117.74936, 33.63421], [-117.7489, 33.63359], [-117.74782, 33.63285], [-117.74759, 33.63246], [-117.74669, 33.63253], [-117.74542, 33.63182], [-117.74514, 33.63121], [-117.74443, 33.63138], [-117.74373, 33.6308], [-117.74323, 33.63067], [-117.74136, 33.63063], [-117.74312, 33.6255], [-117.74522, 33.62259], [-117.74536, 33.6226], [-117.74545, 33.62255], [-117.7455, 33.6224], [-117.74551, 33.62219], [-117.74782, 33.61898], [-117.75092, 33.62051], [-117.75177, 33.62228], [-117.75343, 33.62336], [-117.75265, 33.62571], [-117.75349, 33.62666], [-117.75634, 33.62553], [-117.75672, 33.6262], [-117.75716, 33.62638], [-117.75796, 33.62735], [-117.75843, 33.62773], [-117.76007, 33.62971], [-117.76009, 33.62994], [-117.76033, 33.63064], [-117.75978, 33.63132], [-117.75978, 33.63168], [-117.75996, 33.63186], [-117.75977, 33.63245], [-117.76002, 33.63296], [-117.76036, 33.6333]]]} | No Public Access 3 | 47477 | Veeh Creek | 31199 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 3257 | Irvine Ranch Conservancy 790 | Non Profit 6 | Non Profit - Conservation 12 | Orange 3 | 309.589 | Veeh Creek | None 452 | |||
7480 | 7480 | 7479 | {"type": "Polygon", "coordinates": [[[-118.12811, 34.11951], [-118.12805, 34.11968], [-118.1278, 34.11974], [-118.12742, 34.11973], [-118.1274, 34.11975], [-118.12724, 34.11968], [-118.12728, 34.11907], [-118.1277, 34.11898], [-118.1279, 34.1189], [-118.12811, 34.11951]]]} | Open Access 1 | 7004 | The Old Mill | 28251 | 1309 | San Marino, City of 335 | City 2 | City Agency 2 | http://www.cityofsanmarino.org/275/Parks | City 2 | 3354 | The Old Mill Foundation 845 | Non Profit 6 | Non Profit - Conservation 12 | http://www.old-mill.org/ | Los Angeles 6 | 1.424 | The Old Mill | None 621 | ||
7564 | 7564 | 7563 | {"type": "Polygon", "coordinates": [[[-117.23847, 33.42888], [-117.2383, 33.42892], [-117.23814, 33.42891], [-117.23796, 33.42885], [-117.23784, 33.42878], [-117.23755, 33.42869], [-117.23723, 33.42713], [-117.23723, 33.42663], [-117.2379, 33.42694], [-117.23799, 33.427], [-117.23802, 33.42704], [-117.23804, 33.42711], [-117.23807, 33.42759], [-117.23817, 33.4276], [-117.23825, 33.42826], [-117.23847, 33.42888]]]} | Open Access 1 | 7252 | Santa Margarita River Lands | 3669 | 2034 | Fallbrook Public Utility District 870 | Special District 4 | Water District 13 | https://www.fpud.com/ | Special District 4 | 3022 | Fallbrook Land Conservancy 336 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/santa-margarita-river-trail.html | San Diego 4 | 4.166 | Santa Margarita River Lands | None 628 | ||
7950 | 7950 | 7949 | {"type": "Polygon", "coordinates": [[[-117.01166, 33.09834], [-117.00724, 33.09846], [-117.00721, 33.10173], [-117.00292, 33.10171], [-117.00293, 33.1048], [-117.00284, 33.10489], [-117.00279, 33.10502], [-117.00276, 33.10523], [-117.00281, 33.1053], [-116.99808, 33.10533], [-116.99803, 33.10898], [-116.98097, 33.10899], [-116.98096, 33.10543], [-116.96332, 33.10566], [-116.96371, 33.09511], [-116.96367, 33.09348], [-116.96393, 33.09332], [-116.96428, 33.09317], [-116.96446, 33.09312], [-116.96564, 33.09286], [-116.96609, 33.09274], [-116.96856, 33.0918], [-116.96876, 33.09173], [-116.96925, 33.09162], [-116.97152, 33.09125], [-116.97191, 33.09117], [-116.97461, 33.09036], [-116.97866, 33.08928], [-116.97854, 33.08932], [-116.97856, 33.09035], [-116.98186, 33.09031], [-116.99163, 33.08849], [-116.99171, 33.08887], [-116.99197, 33.08955], [-116.99249, 33.09015], [-116.99317, 33.09071], [-116.99366, 33.09108], [-116.99411, 33.09135], [-116.99459, 33.0916], [-116.99501, 33.09177], [-116.99945, 33.09342], [-117.00223, 33.09441], [-117.00239, 33.09428], [-117.00232, 33.09447], [-117.00438, 33.09522], [-117.00503, 33.09542], [-117.00567, 33.09558], [-117.00623, 33.09569], [-117.00687, 33.09579], [-117.01086, 33.09625], [-117.01126, 33.09635], [-117.01148, 33.09642], [-117.01165, 33.0965], [-117.01166, 33.09834]]]} | Open Access 1 | 47725 | San Diego Safari Park | 31513 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 7020 | San Diego Zoo Global 858 | Non Profit 6 | Non Profit - Other 20 | http://sdzsafaripark.org/ | San Diego 4 | 1699.918 | San Diego Safari Park | None 662 | ||
9507 | 9507 | 9506 | {"type": "Polygon", "coordinates": [[[-117.77532, 34.12952], [-117.77504, 34.12945], [-117.77433, 34.1294], [-117.77405, 34.12932], [-117.77412, 34.12916], [-117.77405, 34.12898], [-117.77414, 34.12894], [-117.77431, 34.1287], [-117.77434, 34.12868], [-117.77432, 34.1286], [-117.7742, 34.12857], [-117.77402, 34.12834], [-117.77396, 34.12824], [-117.77394, 34.12812], [-117.77421, 34.12799], [-117.77383, 34.12742], [-117.774, 34.1274], [-117.77418, 34.12741], [-117.77492, 34.12751], [-117.77483, 34.12784], [-117.77483, 34.12796], [-117.77491, 34.12831], [-117.77504, 34.12875], [-117.77512, 34.12876], [-117.77516, 34.12873], [-117.77532, 34.12952]]]} | Restricted Access 2 | 47831 | La Verne Heritage Foundation | 31773 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 3382 | La Verne Heritage Foundation 888 | Non Profit 6 | Non Profit - Other 20 | Los Angeles 6 | 4.634 | La Verne Heritage Foundation | None 788 | |||
10925 | 10925 | 10924 | {"type": "Polygon", "coordinates": [[[-121.81078, 39.71922], [-121.81078, 39.71922], [-121.8073, 39.71927], [-121.80736, 39.71921], [-121.80879, 39.71919], [-121.80878, 39.71845], [-121.81077, 39.71844], [-121.81078, 39.71922]]]} | Restricted Access 2 | 48675 | Silver Dollar BMX | 33416 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 3395 | Silver Dollar BMX 929 | Non Profit 6 | Non Profit - Other 20 | https://www.usabmx.com/tracks/1344/about | Butte 42 | 3.937 | Silver Dollar BMX | None 953 | ||
11525 | 11525 | 11524 | {"type": "Polygon", "coordinates": [[[-119.75209, 36.7914], [-119.75208, 36.79222], [-119.74984, 36.79221], [-119.74986, 36.79015], [-119.74979, 36.79014], [-119.74979, 36.78996], [-119.74993, 36.78995], [-119.74995, 36.78796], [-119.75026, 36.78784], [-119.75059, 36.78776], [-119.75151, 36.78761], [-119.7515, 36.78918], [-119.75146, 36.78919], [-119.75145, 36.79076], [-119.75161, 36.79077], [-119.75161, 36.79139], [-119.75209, 36.7914]]]} | Open Access 1 | 48727 | Granite Park Sports Complex | 33452 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 3396 | Central Valley Community Sports Foundation 947 | Non Profit 6 | Non Profit - Other 20 | https://www.graniteparkfresno.com/about-us | Fresno 9 | 18.769 | Granite Park Sports Complex | None 1028 | ||
12278 | 12278 | 12277 | {"type": "Polygon", "coordinates": [[[-119.78962, 36.87116], [-119.78961, 36.87514], [-119.7888, 36.87513], [-119.78692, 36.87644], [-119.78681, 36.87677], [-119.78705, 36.8769], [-119.78541, 36.87809], [-119.78512, 36.87927], [-119.78487, 36.87971], [-119.78457, 36.881], [-119.78394, 36.88274], [-119.78388, 36.88428], [-119.78173, 36.88414], [-119.78184, 36.88337], [-119.78096, 36.88318], [-119.78133, 36.88304], [-119.78185, 36.88225], [-119.78144, 36.88101], [-119.78012, 36.88101], [-119.77975, 36.88045], [-119.77959, 36.88014], [-119.77944, 36.87982], [-119.77925, 36.87928], [-119.77903, 36.87851], [-119.77897, 36.87821], [-119.7789, 36.87772], [-119.77889, 36.87732], [-119.77926, 36.87568], [-119.77982, 36.87412], [-119.77986, 36.87363], [-119.78108, 36.87363], [-119.78149, 36.87337], [-119.78262, 36.87323], [-119.78317, 36.87293], [-119.78336, 36.8725], [-119.78321, 36.87199], [-119.78472, 36.87079], [-119.78507, 36.87095], [-119.78655, 36.87182], [-119.78764, 36.8717], [-119.78948, 36.87117], [-119.78962, 36.87116]]]} | Unknown Access 4 | 25927 | Jenson River Ranch | 20397 | 2345 | Tehachapi-Cummings County Water District 499 | Special District 4 | Water District 13 | http://tccwd.com/ | Special District 4 | 3069 | San Joaquin River Parkway and Conservation Trust 491 | Non Profit 6 | Non Profit - Land Trust 10 | Fresno 9 | 189.23 | Jenson River Ranch | None 1071 | |||
12279 | 12279 | 12278 | {"type": "Polygon", "coordinates": [[[-119.74413, 36.95238], [-119.73643, 36.95242], [-119.73532, 36.95037], [-119.73417, 36.94855], [-119.73385, 36.94778], [-119.73382, 36.94705], [-119.73448, 36.94596], [-119.73557, 36.94502], [-119.73691, 36.94458], [-119.738, 36.94429], [-119.73914, 36.94436], [-119.7401, 36.94453], [-119.74133, 36.94424], [-119.74239, 36.94352], [-119.7435, 36.94216], [-119.74386, 36.94241], [-119.74413, 36.95238]]]} | Unknown Access 4 | 25928 | Ledger Island | 21130 | 2345 | Tehachapi-Cummings County Water District 499 | Special District 4 | Water District 13 | http://tccwd.com/ | Special District 4 | 3069 | San Joaquin River Parkway and Conservation Trust 491 | Non Profit 6 | Non Profit - Land Trust 10 | Madera 48 | 184.827 | Ledger Island | None 1072 | |||
13049 | 13049 | 13048 | {"type": "Polygon", "coordinates": [[[-122.40341, 37.78499], [-122.40282, 37.78546], [-122.40271, 37.78538], [-122.40252, 37.7855], [-122.40177, 37.78492], [-122.40254, 37.78429], [-122.40265, 37.78437], [-122.40289, 37.78441], [-122.403, 37.78445], [-122.40309, 37.78451], [-122.40319, 37.78463], [-122.40321, 37.78473], [-122.40321, 37.78483], [-122.40341, 37.78499]]]} | Open Access 1 | 34902 | Yerba Buena Gardens | 27769 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 6095 | Lao Family Community Development, Inc. 1001 | Non Profit 6 | Non Profit - Other 20 | San Francisco 13 | 2.694 | Yerba Buena Gardens | None 1130 | |||
13114 | 13114 | 13113 | {"type": "Polygon", "coordinates": [[[-118.24324, 33.90596], [-118.243, 33.90596], [-118.24296, 33.90579], [-118.2428, 33.90555], [-118.24267, 33.90547], [-118.24228, 33.90547], [-118.24206, 33.90556], [-118.24174, 33.90563], [-118.24154, 33.90508], [-118.24172, 33.90504], [-118.24174, 33.90502], [-118.24165, 33.90478], [-118.24133, 33.90457], [-118.24197, 33.90439], [-118.24199, 33.9044], [-118.24323, 33.90582], [-118.24324, 33.90596]]]} | Open Access 1 | 45034 | Compton Creek-Washington Elementary | 27986 | 2341 | Compton Unified School District 1043 | Special District 4 | School District 14 | http://web.compton.k12.ca.us/index.aspx | Special District 4 | 3384 | Los Angeles Conservation Corps 1004 | Non Profit 6 | Non Profit - Conservation 12 | https://mrca.ca.gov/parks/park-listing/compton-creek-natural-park-at-george-washington-elementary/ | Los Angeles 6 | 2.729 | Compton Creek-Washington Elementary | None 1137 | ||
13784 | 13784 | 13783 | {"type": "Polygon", "coordinates": [[[-122.39106, 37.77842], [-122.38914, 37.77988], [-122.38862, 37.78032], [-122.38843, 37.78055], [-122.38828, 37.78079], [-122.38819, 37.78101], [-122.38806, 37.78144], [-122.388, 37.78149], [-122.38791, 37.78151], [-122.38783, 37.7815], [-122.38776, 37.78145], [-122.38774, 37.78141], [-122.38768, 37.7806], [-122.38752, 37.77914], [-122.38746, 37.77826], [-122.38762, 37.77821], [-122.38757, 37.77824], [-122.38779, 37.78026], [-122.38849, 37.78024], [-122.38856, 37.78029], [-122.391, 37.77836], [-122.39106, 37.77842]]]} | Open Access 1 | 48834 | South Beach Park | 33553 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | https://www.sfparksalliance.org/our-parks/parks/south-beach-park | San Francisco 13 | 2.826 | South Beach Park | None 1186 |
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]);