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 ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
789 | 789 | 788 | {"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 | Woods Yard | https://www.sfparksalliance.org/our-parks/parks/woods-yard | 33552 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | http://www.sfparksalliance.org/ | Non Governmental Organization 10 | 0.275 | Woods Yard | |
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 | ||
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 | ||
463 | 463 | 462 | {"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 | Rincon Hill Dog Park | https://www.rinconhilldogpark.org/about | 33503 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | http://www.sfparksalliance.org/ | Non Governmental Organization 10 | 0.621 | Rincon Hill Dog Park | 2007 |
7334 | 7334 | 7333 | {"type": "Polygon", "coordinates": [[[-120.68035, 38.19748], [-120.68032, 38.19764], [-120.68019, 38.19787], [-120.68017, 38.19785], [-120.67998, 38.1978], [-120.68, 38.19774], [-120.67974, 38.19755], [-120.67986, 38.19742], [-120.6797, 38.19732], [-120.67973, 38.19727], [-120.67949, 38.1971], [-120.67965, 38.19699], [-120.67991, 38.19725], [-120.68002, 38.19734], [-120.68035, 38.19748]]]} | Open Access 1 | Neilsen Park | 22689 | 3050 | Odd Fellows Sierra Recreation Association 799 | Non Profit 6 | Non Profit - Other 20 | http://ofsraparkmgt.wix.com/home | Non Governmental Organization 10 | 0.654 | Neilsen 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 | |
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 | ||
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 | |
4418 | 4418 | 4417 | {"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 | Fresno Flats Historic Park | 19111 | 3078 | Sierra Historic Sites Association 455 | Non Profit 6 | Non Profit - Other 20 | http://www.fresnoflatsmuseum.org/ | Non Governmental Organization 10 | 2.12 | Fresno Flats Historic Park | ||
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. | |
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 | ||
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 | |
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 | ||
802 | 802 | 801 | {"type": "Polygon", "coordinates": [[[-122.39106, 37.77842], [-122.38914, 37.77987], [-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.77825], [-122.3878, 37.78026], [-122.38849, 37.78024], [-122.38857, 37.78028], [-122.391, 37.77836], [-122.39106, 37.77842]]]} | Open Access 1 | South Beach Park | https://www.sfparksalliance.org/our-parks/parks/south-beach-park | 33553 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | http://www.sfparksalliance.org/ | Non Governmental Organization 10 | 2.85 | South Beach Park | |
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 | |
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 | |
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 | ||
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 | ||
572 | 572 | 571 | {"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 | Kingsburg Historical Park | http://kingsburghistoricalpark.org/ | 32675 | 3138 | Kingsburg Historical Society 795 | Non Profit 6 | Non Profit - Other 20 | http://www.kingsburghistoricalpark.org/ | Non Governmental Organization 10 | 4.887 | Kingsburg Historical Park |
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]);