superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
44 rows where MNG_AG_TYP = 20 sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Francisco Parks Alliance 5
- Odd Fellows Sierra Recreation Association 3
- Santa Barbara Trust for Historic Preservation 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
- Nonprofit Organization - Unknown 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
- …
ACCESS_TYP 4
MNG_AG_TYP 1
- Non Profit - Other · 44 ✖
Link | rowid ▲ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15613 | 15613 | 15612 | {"type": "Polygon", "coordinates": [[[-116.71662, 33.74341], [-116.71529, 33.74392], [-116.71542, 33.7442], [-116.71505, 33.74429], [-116.71457, 33.7435], [-116.71464, 33.7433], [-116.71463, 33.7428], [-116.71464, 33.74276], [-116.71524, 33.74258], [-116.71632, 33.74263], [-116.71628, 33.74276], [-116.71662, 33.74341]]]} | Open Access 1 | Idyllwild Community Center | https://www.idyllwildcommunitycenter.org/faq | 33128 | 3387 | San Jacinto Mountain Community Center 831 | Non Profit 6 | Non Profit - Other 20 | https://www.idyllwildcommunitycenter.org/faq | Non Governmental Organization 10 | 5.567 | Idyllwild Community Ctr. | 2019 |
15462 | 15462 | 15461 | {"type": "Polygon", "coordinates": [[[-120.54486, 38.22673], [-120.54487, 38.22707], [-120.54477, 38.22764], [-120.54471, 38.22788], [-120.54459, 38.22809], [-120.54345, 38.22879], [-120.54334, 38.22869], [-120.5434, 38.2279], [-120.54309, 38.22772], [-120.54359, 38.22728], [-120.54486, 38.22673]]]} | Open Access 1 | Mountain Ranch Community Park | 22546 | 3050 | Odd Fellows Sierra Recreation Association 799 | Non Profit 6 | Non Profit - Other 20 | http://ofsraparkmgt.wix.com/home | Non Governmental Organization 10 | 4.681 | Mtn. Ranch Community Park | ||
14059 | 14059 | 14058 | {"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.00277, 33.10523], [-117.00281, 33.1053], [-116.99808, 33.10533], [-116.99803, 33.10898], [-116.98097, 33.10899], [-116.98095, 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.9661, 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.97857, 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.00233, 33.09448], [-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 | San Diego Safari Park | http://sdzsafaripark.org/ | 31513 | 7020 | San Diego Zoo Global 858 | Non Profit 6 | Non Profit - Other 20 | http://www.sandiegozooglobal.org | Non Governmental Organization 10 | 1700.054 | San Diego Safari Park | |
14055 | 14055 | 14054 | {"type": "Polygon", "coordinates": [[[-117.12444, 32.57552], [-117.12422, 32.57553], [-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 | Imperial Beach Sports Park | http://www.bgcscounty.org/portal/home | 31474 | 7018 | Boys and Girls Clubs of South County 649 | Non Profit 6 | Non Profit - Other 20 | http://www.bgcscounty.org/portal/164 | Non Governmental Organization 10 | 8.989 | Imperial Beach Sports Park | |
14028 | 14028 | 14027 | {"type": "Polygon", "coordinates": [[[-123.35819, 39.40016], [-123.35815, 39.40029], [-123.35809, 39.40029], [-123.35808, 39.40035], [-123.35769, 39.40036], [-123.35769, 39.40074], [-123.35748, 39.40075], [-123.35748, 39.40086], [-123.35711, 39.40086], [-123.35709, 39.40016], [-123.35819, 39.40016]]]} | Open Access 1 | Willits Kids Club Discovery Park and Playground | 32597 | 3383 | Willits Kids Club 941 | Non Profit 6 | Non Profit - Other 20 | http://www.willitskidsclub.org/about | Non Governmental Organization 10 | 1.123 | Willits Kids Club Discovery Park and Playground | ||
13982 | 13982 | 13981 | {"type": "MultiPolygon", "coordinates": [[[[-118.30836, 33.98193], [-118.30825, 33.98197], [-118.30786, 33.98212], [-118.30786, 33.98191], [-118.30833, 33.98191], [-118.30836, 33.98193]]], [[[-118.30883, 33.98208], [-118.30883, 33.98228], [-118.30824, 33.98228], [-118.3082, 33.98226], [-118.30823, 33.98223], [-118.30862, 33.98208], [-118.30883, 33.98208]]], [[[-118.30873, 33.9818], [-118.30853, 33.98187], [-118.30843, 33.98187], [-118.30843, 33.9818], [-118.30873, 33.9818]]]]} | Open Access 1 | Western Gage Park | 32566 | 3368 | Los Angeles Neighborhood Initiative 1074 | Non Profit 6 | Non Profit - Other 20 | http://lani.org/ | Non Governmental Organization 10 | 0.428 | Western Gage Park | ||
13754 | 13754 | 13753 | {"type": "Polygon", "coordinates": [[[-122.27181, 38.09791], [-122.27075, 38.09848], [-122.27064, 38.0983], [-122.27038, 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 | Mare Island Historic Park | http://www.mareislandhpf.org/index.html | 31265 | 3379 | Mare Island Historic Park Foundation 737 | Non Profit 6 | Non Profit - Other 20 | http://www.mareislandhpf.org/ | Non Governmental Organization 10 | 4.999 | Mare Island Historic Park | |
13650 | 13650 | 13649 | {"type": "Polygon", "coordinates": [[[-119.75209, 36.7914], [-119.75208, 36.79222], [-119.74984, 36.79221], [-119.74986, 36.79016], [-119.74979, 36.79014], [-119.74979, 36.78996], [-119.74993, 36.78994], [-119.74995, 36.78796], [-119.75026, 36.78784], [-119.75059, 36.78776], [-119.75151, 36.78761], [-119.7515, 36.78918], [-119.75146, 36.7892], [-119.75145, 36.79075], [-119.75161, 36.79077], [-119.75161, 36.79139], [-119.75209, 36.7914]]]} | Open Access 1 | Granite Park Sports Complex | https://www.graniteparkfresno.com/about-us | 33452 | 3396 | Central Valley Community Sports Foundation 947 | Non Profit 6 | Non Profit - Other 20 | https://www.graniteparkfresno.com/about-us | Non Governmental Organization 10 | 18.776 | Granite Park Sports Complex | |
13335 | 13335 | 13334 | {"type": "MultiPolygon", "coordinates": [[[[-123.70756, 39.31534], [-123.70732, 39.32435], [-123.70281, 39.32435], [-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.69802, 39.33521], [-123.69818, 39.32792], [-123.69856, 39.31365], [-123.70474, 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.69748, 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.31135], [-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 | Mendocino Woodlands State Park | http://www.parks.ca.gov/?page_id=443 | 30663 | 3373 | Mendocino Woodlands Camp Association 772 | Non Profit 6 | Non Profit - Other 20 | http://mendocinowoodlands.org/ | Non Governmental Organization 10 | 650.676 | Mendocino Woodlands SP | 1977 |
13278 | 13278 | 13277 | {"type": "Polygon", "coordinates": [[[-121.81078, 39.71922], [-121.81078, 39.71922], [-121.8073, 39.71927], [-121.80736, 39.71921], [-121.80878, 39.71918], [-121.80878, 39.71845], [-121.81077, 39.71844], [-121.81078, 39.71922]]]} | Restricted Access 2 | Silver Dollar BMX | https://www.usabmx.com/tracks/1344/about | 33416 | 3395 | Silver Dollar BMX 929 | Non Profit 6 | Non Profit - Other 20 | https://www.usabmx.com/tracks/1344/about | Non Governmental Organization 10 | 3.943 | Silver Dollar BMX | |
12635 | 12635 | 12634 | {"type": "Polygon", "coordinates": [[[-118.1787, 33.98749], [-118.1785, 33.98885], [-118.17811, 33.98882], [-118.17817, 33.98838], [-118.17812, 33.98837], [-118.17792, 33.98851], [-118.17774, 33.98834], [-118.17784, 33.98769], [-118.17797, 33.98768], [-118.178, 33.98742], [-118.1787, 33.98749]]]} | Open Access 1 | Maywood Activity Center | http://www.cityofmaywood.com/index.php?option=com_content&view=article&id=162&Itemid=69 | 29736 | 3366 | YMCA of Southeast - Rio Vista 1098 | Non Profit 6 | Non Profit - Other 20 | http://www.ymcala.org/southeast-rio-vista/ | Non Governmental Organization 10 | 2.401 | Maywood Activity Ctr. | |
12254 | 12254 | 12253 | {"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.59606], [-120.1268, 34.59601], [-120.12734, 34.59501], [-120.12844, 34.59417], [-120.12826, 34.59379], [-120.1283, 34.59233], [-120.13295, 34.59237]]]} | Restricted Access 2 | Santa Ines Mission Mill | http://www.sbthp.org/ | 30693 | 3372 | Santa Barbara Trust for Historic Preservation 706 | Non Profit 6 | Non Profit - Other 20 | http://www.sbthp.org/ | Non Governmental Organization 10 | 40.04 | Santa Ines Mission Mill | |
12226 | 12226 | 12225 | {"type": "MultiPolygon", "coordinates": [[[[-119.69816, 34.42266], [-119.69776, 34.42304], [-119.69749, 34.4229], [-119.69761, 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.69816, 34.42178], [-119.69831, 34.4219]]], [[[-119.69897, 34.42326], [-119.69864, 34.42356], [-119.69857, 34.42353], [-119.69836, 34.42374], [-119.69814, 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.42208], [-119.69873, 34.42195], [-119.69884, 34.42203]]], [[[-119.69995, 34.42208], [-119.6997, 34.42231], [-119.69984, 34.42244], [-119.69966, 34.42265], [-119.69937, 34.42248], [-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 | El Presidio de Santa Barbara State Historic Park | http://www.parks.ca.gov/?page_id=608 | 30636 | 3372 | Santa Barbara Trust for Historic Preservation 706 | Non Profit 6 | Non Profit - Other 20 | http://www.sbthp.org/ | Non Governmental Organization 10 | 5.929 | El Presidio de Santa Barbara SHP | 1966 |
12143 | 12143 | 12142 | {"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.3541, 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.35454, 33.20899], [-117.35459, 33.20901]]]} | Open Access 1 | North County Humane Society and SPCA Dog Park | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/dogpark.asp | 29112 | 3361 | San Diego Humane Society and SPCA 783 | Non Profit 6 | Non Profit - Other 20 | http://www.sdhumane.org/ | Non Governmental Organization 10 | 2.32 | North County Humane Society and SPCA Dog Park | |
12096 | 12096 | 12095 | {"type": "Polygon", "coordinates": [[[-117.98619, 34.17245], [-117.98605, 34.1798], [-117.9775, 34.17979], [-117.97751, 34.17245], [-117.98619, 34.17245]]]} | Open Access 1 | Canyon Park, Boy Scouts of America | 29062 | 3360 | Boy Scouts of America 1092 | Non Profit 6 | Non Profit - Other 20 | http://www.scouting.org/ | Non Governmental Organization 10 | 159.845 | Canyon Park, Boy Scouts of America | ||
11594 | 11594 | 11593 | {"type": "Polygon", "coordinates": [[[-122.28644, 37.82262], [-122.286, 37.82271], [-122.28596, 37.82264], [-122.28553, 37.82273], [-122.28539, 37.82229], [-122.28607, 37.82144], [-122.28644, 37.82262]]]} | Open Access 1 | West Oakland Park and Urban Farm | 28126 | 3350 | City Slicker Farms 1005 | Non Profit 6 | Non Profit - Other 20 | http://www.cityslickerfarms.org | Non Governmental Organization 10 | 1.868 | West Oakland Park and Urban Farm | 2016 | |
11593 | 11593 | 11592 | {"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 | WAYS Reading and Fitness Park | 28122 | 3352 | Heal the Bay 711 | Non Profit 6 | Non Profit - Other 20 | http://www.healthebay.org/ | Non Governmental Organization 10 | 0.387 | WAYS Reading and Fitness Park | ||
11577 | 11577 | 11576 | {"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.14456], [-118.18336, 34.14452], [-118.18362, 34.14471]]]} | Open Access 1 | Eagle Rock Canyon Trail | http://www.cerb.us/ | 30271 | 3367 | The Collaborative Eagle Rock Beautiful 682 | Non Profit 6 | Non Profit - Other 20 | http://www.cerb.us/ | Non Governmental Organization 10 | 4.568 | Eagle Rock Canyon Trail | |
11567 | 11567 | 11566 | {"type": "Polygon", "coordinates": [[[-118.23665, 33.94382], [-118.23662, 33.94385], [-118.23513, 33.94385], [-118.23512, 33.94321], [-118.2366, 33.94322], [-118.23664, 33.94324], [-118.23665, 33.94382]]]} | Open Access 1 | MudTown Farms | 28055 | 3351 | Watts Labor Community Action Committee 1077 | Non Profit 6 | Non Profit - Other 20 | http://www.wlcac.org/ | Non Governmental Organization 10 | 2.45 | MudTown Farms | ||
11423 | 11423 | 11422 | {"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.40322, 37.78483], [-122.40341, 37.78499]]]} | Open Access 1 | Yerba Buena Gardens | 27769 | 6095 | Lao Family Community Development, Inc. 1001 | Non Profit 6 | Non Profit - Other 20 | http://www.lfcd.org/ | Non Governmental Organization 10 | 2.695 | Yerba Buena Gardens |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);