units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
45 rows where MNG_AG_TYP = 20 sorted by MNG_AGENCY
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, YR_EST, GAP_STS
MNG_AGENCY 37
- San Francisco Parks Alliance 5
- Odd Fellows Sierra Recreation Association 3
- Santa Barbara Trust for Historic Preservation 2
- Nonprofit Organization - Unknown 2
- Sierra Historic Sites Association 1
- Tulare County Historical Society 1
- Boys and Girls Clubs of South County 1
- Redlands Conservancy 1
- The Collaborative Eagle Rock Beautiful 1
- Heal the Bay 1
- Mare Island Historic Park Foundation 1
- Mendocino Woodlands Camp Association 1
- San Diego Humane Society and SPCA 1
- Forestville Park Development District 1
- Kingsburg Historical Society 1
- Kare Youth League 1
- Montalvo Association 1
- San Jacinto Mountain Community Center 1
- Glendora Community Conservancy 1
- Huntington Library and Botanical Gardens 1
- Foundation for Preservation of Mt. Helix Nature Theatre 1
- San Diego Zoo Global 1
- La Verne Heritage Foundation 1
- Independent Order of Odd Fellows 1
- Mission Santa Ines 1
- Silver Dollar BMX 1
- Willits Kids Club 1
- Central Valley Community Sports Foundation 1
- Murrieta Valley PONY Baseball, Inc 1
- Lao Family Community Development, Inc. 1
- City Slicker Farms 1
- Los Angeles Neighborhood Initiative 1
- Watts Labor Community Action Committee 1
- Boy Scouts of America 1
- YMCA of Southeast - Rio Vista 1
- Rancho Santa Fe Community Foundation 1
- National Trust for Historic Preservation 1
DES_TP 20
- Private Recreation or Education 13
- Private Conservation 12
- Private Agricultural 2
- Private Other or Unknown 2
- State Park 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
COUNTY 19 ✖
- Los Angeles 10
- San Diego 7
- San Francisco 6
- Santa Barbara 3
- Fresno 2
- Riverside 2
- Mendocino 2
- Calaveras 2
- Monterey 1
- San Mateo 1
- Sonoma 1
- Alameda 1
- Santa Clara 1
- Tuolumne 1
- San Bernardino 1
- Solano 1
- Tulare 1
- Butte 1
- Madera 1
ACCESS_TYP 4
MNG_AG_TYP 1
- Non Profit - Other · 45 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1961 | 1961 | 1960 | {"type": "Polygon", "coordinates": [[[-119.64038, 37.32984], [-119.64037, 37.33056], [-119.6394, 37.33019], [-119.63911, 37.33026], [-119.63852, 37.33009], [-119.63833, 37.32985], [-119.63942, 37.32983], [-119.64038, 37.32984]]]} | Open Access 1 | 16718 | Fresno Flats Historic Park | 19111 | 3078 | Sierra Historic Sites Association 462 | Non Profit 6 | Non Profit - Other 22 | http://www.fresnoflatsmuseum.org/ | Non Governmental Organization 10 | 3078 | Sierra Historic Sites Association 455 | Non Profit 6 | Non Profit - Other 20 | Madera 48 | 2.12 | Fresno Flats Historic Park | 0 | Private Recreation or Education 65 | 4 | |
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 | ||
12592 | 12592 | 12591 | {"type": "Polygon", "coordinates": [[[-122.39117, 37.78541], [-122.39071, 37.78573], [-122.39028, 37.78609], [-122.39017, 37.78649], [-122.38985, 37.78623], [-122.39103, 37.78533], [-122.39117, 37.78541]]]} | Open Access 1 | 48777 | Rincon Hill Dog Park | 33503 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | https://www.rinconhilldogpark.org/about | San Francisco 13 | 0.621 | Rincon Hill Dog Park | 2007 | None 1091 | |
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 | ||
13918 | 13918 | 13917 | {"type": "Polygon", "coordinates": [[[-122.47779, 37.71752], [-122.47794, 37.71754], [-122.47824, 37.71766], [-122.47842, 37.71779], [-122.47855, 37.71794], [-122.47864, 37.71809], [-122.47866, 37.71822], [-122.47864, 37.7183], [-122.4786, 37.71838], [-122.47849, 37.71848], [-122.47836, 37.71855], [-122.47824, 37.71859], [-122.4781, 37.71859], [-122.47795, 37.71857], [-122.47777, 37.71849], [-122.47759, 37.71838], [-122.47748, 37.71829], [-122.47737, 37.71816], [-122.47731, 37.71806], [-122.47729, 37.71796], [-122.47729, 37.71787], [-122.47733, 37.71778], [-122.47742, 37.71767], [-122.47753, 37.71758], [-122.47763, 37.71754], [-122.47779, 37.71752]]]} | Open Access 1 | 48836 | Robert Pender Park | 33555 | 6134 | Parkmerced Owner LLC 1068 | Private 7 | Home Owners Association 16 | https://www.parkmerced.com/ | Private 14 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | https://www.sfparksalliance.org/our-parks/parks/robert-pender-park | San Francisco 13 | 2.548 | Robert Pender Park | 0 | Private Recreation or Education 65 | 4 |
3397 | 3397 | 3396 | {"type": "Polygon", "coordinates": [[[-119.08951, 36.35464], [-119.08945, 36.35822], [-119.08502, 36.3582], [-119.08507, 36.35461], [-119.08951, 36.35464]]]} | Open Access 1 | 35099 | Hog Wallow Preserve | 20024 | 3137 | Tulare County Historical Society 636 | Non Profit 6 | Non Profit - Other 22 | http://www.tularecountyhistoricalsociety.org/ | Non Governmental Organization 10 | 3137 | Tulare County Historical Society 625 | Non Profit 6 | Non Profit - Other 20 | Tulare 29 | 39.16 | Hog Wallow Preserve | 0 | Private Conservation 16 | 2 | |
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 | |||
3845 | 3845 | 3844 | {"type": "Polygon", "coordinates": [[[-118.18362, 34.14471], [-118.18351, 34.1448], [-118.18343, 34.14491], [-118.18336, 34.1451], [-118.18336, 34.1453], [-118.1834, 34.14542], [-118.18348, 34.14554], [-118.18357, 34.14564], [-118.18353, 34.1458], [-118.18343, 34.14596], [-118.1821, 34.14546], [-118.18217, 34.14478], [-118.18267, 34.14401], [-118.18325, 34.14443], [-118.18319, 34.14449], [-118.18324, 34.14457], [-118.18336, 34.14452], [-118.18362, 34.14471]]]} | Open Access 1 | 46810 | Eagle Rock Canyon Trail | 30271 | 3367 | The Collaborative Eagle Rock Beautiful 692 | Non Profit 6 | Non Profit - Other 22 | http://www.cerb.us/ | Non Governmental Organization 10 | 3367 | The Collaborative Eagle Rock Beautiful 682 | Non Profit 6 | Non Profit - Other 20 | http://www.cerb.us/ | Los Angeles 6 | 4.567 | Eagle Rock Canyon Trail | 0 | Private Recreation or Education 65 | 4 |
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 | ||
8965 | 8965 | 8964 | {"type": "MultiPolygon", "coordinates": [[[[-119.69816, 34.42266], [-119.69776, 34.42304], [-119.69749, 34.4229], [-119.69762, 34.42271], [-119.6973, 34.42248], [-119.69723, 34.42254], [-119.69702, 34.42239], [-119.69735, 34.42208], [-119.69816, 34.42266]]], [[[-119.69831, 34.4219], [-119.69791, 34.42227], [-119.69736, 34.42187], [-119.69751, 34.42172], [-119.69769, 34.42185], [-119.69793, 34.42163], [-119.69799, 34.42166], [-119.69805, 34.42158], [-119.69825, 34.42169], [-119.69815, 34.42178], [-119.69831, 34.4219]]], [[[-119.69897, 34.42326], [-119.69864, 34.42357], [-119.69857, 34.42352], [-119.69836, 34.42374], [-119.69813, 34.42358], [-119.69809, 34.42361], [-119.69771, 34.42334], [-119.69831, 34.42277], [-119.69897, 34.42326]]], [[[-119.69884, 34.42203], [-119.69859, 34.42227], [-119.69834, 34.4221], [-119.69845, 34.42199], [-119.69859, 34.42209], [-119.69873, 34.42195], [-119.69884, 34.42203]]], [[[-119.69995, 34.42208], [-119.69969, 34.42232], [-119.69984, 34.42244], [-119.69966, 34.42265], [-119.69937, 34.42247], [-119.6993, 34.42255], [-119.69935, 34.42259], [-119.69915, 34.42282], [-119.69916, 34.42285], [-119.69897, 34.42303], [-119.69844, 34.42265], [-119.69944, 34.42171], [-119.69995, 34.42208]]]]} | Open Access 1 | 14784 | El Presidio de Santa Barbara State Historic Park | 30636 | 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.parks.ca.gov/?page_id=608 | Santa Barbara 7 | 5.916 | El Presidio de Santa Barbara SHP | 1966 | State Historic or Cultural Area 132 | 4 |
4158 | 4158 | 4157 | {"type": "Polygon", "coordinates": [[[-118.26097, 33.95842], [-118.26096, 33.95916], [-118.26076, 33.95916], [-118.26076, 33.95842], [-118.26097, 33.95842]]]} | Open Access 1 | 45111 | WAYS Reading and Fitness Park | 28122 | 3352 | Heal the Bay 726 | Non Profit 6 | Non Profit - Other 22 | http://www.healthebay.org/ | Non Governmental Organization 10 | 3352 | Heal the Bay 711 | Non Profit 6 | Non Profit - Other 20 | Los Angeles 6 | 0.387 | WAYS Reading and Fitness Park | 0 | Private Recreation or Education 65 | 4 | |
4344 | 4344 | 4343 | {"type": "Polygon", "coordinates": [[[-122.27181, 38.09791], [-122.27075, 38.09848], [-122.27064, 38.0983], [-122.27039, 38.09693], [-122.26917, 38.09562], [-122.26946, 38.09542], [-122.26965, 38.09541], [-122.26971, 38.09524], [-122.26973, 38.09524], [-122.2697, 38.0956], [-122.27179, 38.09785], [-122.27181, 38.09791]]]} | Open Access 1 | 45605 | Mare Island Historic Park | 31265 | 3379 | Mare Island Historic Park Foundation 751 | Non Profit 6 | Non Profit - Other 22 | http://www.mareislandhpf.org/ | Non Governmental Organization 10 | 3379 | Mare Island Historic Park Foundation 737 | Non Profit 6 | Non Profit - Other 20 | http://www.mareislandhpf.org/index.html | Solano 26 | 4.996 | Mare Island Historic Park | 0 | Private Recreation or Education 65 | 4 |
4471 | 4471 | 4470 | {"type": "Polygon", "coordinates": [[[-116.62024, 32.8546], [-116.62023, 32.85532], [-116.61829, 32.85533], [-116.61829, 32.85491], [-116.618, 32.85491], [-116.61799, 32.85435], [-116.61875, 32.85434], [-116.61914, 32.85341], [-116.61924, 32.85343], [-116.6193, 32.85399], [-116.61991, 32.8542], [-116.6198, 32.85446], [-116.62024, 32.8546]]]} | Restricted Access 2 | 1199 | Unnamed site - Nonprofit Organization - Unknown | 28649 | 3048 | Nonprofit Organization - Unknown 765 | Non Profit 6 | Non Profit - Other 22 | Non Governmental Organization 10 | 3048 | Nonprofit Organization - Unknown 746 | Non Profit 6 | Non Profit - Other 20 | San Diego 4 | 6.306 | 0 | Private Other or Unknown 399 | 4 | |||
4472 | 4472 | 4471 | {"type": "Polygon", "coordinates": [[[-116.31558, 33.3251], [-116.31551, 33.33963], [-116.29816, 33.3395], [-116.29841, 33.32503], [-116.31558, 33.3251]]]} | Restricted Access 2 | 1208 | Unnamed site - Nonprofit Organization - Unknown | 28649 | 3048 | Nonprofit Organization - Unknown 765 | Non Profit 6 | Non Profit - Other 22 | Non Governmental Organization 10 | 3048 | Nonprofit Organization - Unknown 746 | Non Profit 6 | Non Profit - Other 20 | San Diego 4 | 638.799 | 0 | Private Other or Unknown 399 | 4 | |||
5042 | 5042 | 5041 | {"type": "MultiPolygon", "coordinates": [[[[-123.70756, 39.31534], [-123.70732, 39.32435], [-123.70281, 39.32434], [-123.70273, 39.3279], [-123.7025, 39.3425], [-123.69791, 39.34255], [-123.68153, 39.34249], [-123.68164, 39.3389], [-123.69333, 39.33887], [-123.69345, 39.33522], [-123.69803, 39.33521], [-123.69818, 39.32792], [-123.69856, 39.31365], [-123.70475, 39.31359], [-123.70436, 39.31314], [-123.70756, 39.31534]]], [[[-123.69822, 39.31365], [-123.69382, 39.31371], [-123.6938, 39.3109], [-123.69419, 39.31055], [-123.69429, 39.31043], [-123.69437, 39.31029], [-123.69446, 39.31008], [-123.69455, 39.30974], [-123.69464, 39.30901], [-123.69474, 39.30875], [-123.69489, 39.30843], [-123.69504, 39.30817], [-123.69517, 39.30802], [-123.69534, 39.30792], [-123.69559, 39.30783], [-123.69587, 39.30779], [-123.69613, 39.30778], [-123.69641, 39.30782], [-123.69686, 39.30795], [-123.69749, 39.30819], [-123.69783, 39.30836], [-123.6979, 39.30841], [-123.69794, 39.30848], [-123.69797, 39.30863], [-123.69798, 39.30885], [-123.69796, 39.30913], [-123.69789, 39.30968], [-123.69772, 39.31065], [-123.69747, 39.31136], [-123.69745, 39.31158], [-123.69749, 39.31212], [-123.69754, 39.31234], [-123.69771, 39.31269], [-123.69809, 39.31316], [-123.69821, 39.31328], [-123.69822, 39.31365]]]]} | Open Access 1 | 45367 | Mendocino Woodlands State Park | 30663 | 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 | 3373 | Mendocino Woodlands Camp Association 772 | Non Profit 6 | Non Profit - Other 20 | http://www.parks.ca.gov/?page_id=443 | Mendocino 24 | 650.541 | Mendocino Woodlands SP | 1977 | State Park 15 | 4 |
5266 | 5266 | 5265 | {"type": "Polygon", "coordinates": [[[-117.35459, 33.20901], [-117.35406, 33.21043], [-117.35407, 33.21045], [-117.35412, 33.21045], [-117.3539, 33.21053], [-117.35388, 33.21048], [-117.35389, 33.21042], [-117.35409, 33.20978], [-117.35417, 33.20964], [-117.35418, 33.20959], [-117.35417, 33.20953], [-117.35411, 33.20946], [-117.35404, 33.20943], [-117.35393, 33.20943], [-117.35337, 33.20918], [-117.35314, 33.20899], [-117.35395, 33.20875], [-117.35416, 33.20875], [-117.35447, 33.20877], [-117.35455, 33.20899], [-117.35459, 33.20901]]]} | Open Access 1 | 949 | North County Humane Society and SPCA Dog Park | 29112 | 3361 | San Diego Humane Society and SPCA 803 | Non Profit 6 | Non Profit - Other 22 | http://www.sdhumane.org/ | Non Governmental Organization 10 | 3361 | San Diego Humane Society and SPCA 783 | Non Profit 6 | Non Profit - Other 20 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/dogpark.asp | San Diego 4 | 2.32 | North County Humane Society and SPCA Dog Park | 0 | Private Recreation or Education 65 | 4 |
5618 | 5618 | 5617 | {"type": "Polygon", "coordinates": [[[-122.89472, 38.47891], [-122.89472, 38.48002], [-122.8932, 38.47999], [-122.8932, 38.48027], [-122.89244, 38.48027], [-122.89245, 38.47815], [-122.89323, 38.47814], [-122.89322, 38.4789], [-122.89472, 38.47891]]]} | No Public Access 3 | 29794 | Forestville Park Development District-Land Bank | 19000 | 3131 | Forestville Park Development District 812 | Non Profit 6 | Non Profit - Other 22 | http://www.forestvilleyouthpark.org/ | Non Governmental Organization 10 | 3131 | Forestville Park Development District 791 | Non Profit 6 | Non Profit - Other 20 | Sonoma 16 | 7.924 | Forestville Park Development District-Land Bank | 0 | Private Conservation 16 | 2 | |
5753 | 5753 | 5752 | {"type": "Polygon", "coordinates": [[[-119.54118, 36.51798], [-119.54116, 36.52003], [-119.54018, 36.52002], [-119.54021, 36.51798], [-119.54118, 36.51798]]]} | Restricted Access 2 | 3683 | Kingsburg Historical Park | 32675 | 3138 | Kingsburg Historical Society 817 | Non Profit 6 | Non Profit - Other 22 | http://www.kingsburghistoricalpark.org/ | Non Governmental Organization 10 | 3138 | Kingsburg Historical Society 795 | Non Profit 6 | Non Profit - Other 20 | http://kingsburghistoricalpark.org/ | Fresno 9 | 4.887 | Kingsburg Historical Park | 0 | Private Recreation or Education 65 | 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]);