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 MNG_AG_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY 22
- San Francisco Parks Alliance 2
- Santa Barbara Trust for Historic Preservation 2
- Boys and Girls Clubs of South County 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
- Kare Youth League 1
- San Jacinto Mountain Community Center 1
- San Diego Zoo Global 1
- La Verne Heritage Foundation 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
ACCESS_TYP 2
MNG_AG_TYP 1
- Non Profit - Other · 24 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
819 | 819 | 818 | {"type": "Polygon", "coordinates": [[[-122.47779, 37.71752], [-122.47794, 37.71754], [-122.47824, 37.71766], [-122.47841, 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.47837, 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.4773, 37.71787], [-122.47733, 37.71778], [-122.47742, 37.71767], [-122.47753, 37.71758], [-122.47764, 37.71754], [-122.47779, 37.71752]]]} | Open Access 1 | Robert Pender Park | https://www.sfparksalliance.org/our-parks/parks/robert-pender-park | 33555 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | http://www.sfparksalliance.org/ | Non Governmental Organization 10 | 2.547 | Robert Pender Park | |
4028 | 4028 | 4027 | {"type": "Polygon", "coordinates": [[[-122.44958, 37.76633], [-122.44898, 37.7664], [-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.44847, 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 | Richard Gamble Memorial Park | https://www.sfparksalliance.org/our-parks/parks/gamble-memorial-park | 33627 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | http://www.sfparksalliance.org/ | Non Governmental Organization 10 | 0.913 | Richard Gamble Memorial Park | |
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 | |
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 | ||
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 | ||
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 | ||
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 | |
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. | |
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 | |
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 | ||
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 |
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 | |
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 |
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 | |
55 | 55 | 54 | {"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.77434, 34.12867], [-117.77432, 34.1286], [-117.7742, 34.12857], [-117.77402, 34.12834], [-117.77396, 34.12824], [-117.77394, 34.12812], [-117.77421, 34.12798], [-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.12874], [-117.77512, 34.12876], [-117.77516, 34.12873], [-117.77532, 34.12952]]]} | Restricted Access 2 | La Verne Heritage Foundation | 31773 | 3382 | La Verne Heritage Foundation 888 | Non Profit 6 | Non Profit - Other 20 | https://www.laverneheritage.org/ | Non Governmental Organization 10 | 4.636 | La Verne Heritage Foundation | ||
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 | ||
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 |
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 | |
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 | |
440 | 440 | 439 | {"type": "Polygon", "coordinates": [[[-117.18941, 33.5381], [-117.18772, 33.53937], [-117.1867, 33.53844], [-117.18884, 33.53681], [-117.1892, 33.53738], [-117.18941, 33.5381]]]} | Restricted Access 2 | Murrieta Valley Pony Baseball | https://www.mvpb.org/ | 33498 | 3397 | Murrieta Valley PONY Baseball, Inc 992 | Non Profit 6 | Non Profit - Other 20 | https://www.mvpb.org/ | Non Governmental Organization 10 | 8.518 | Murrieta Valley Pony Baseball |
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]);