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 map 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 ✖
MNG_AG_LEV 1 ✖
- Non Profit 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
4313 | 4313 | 4312 | {"type": "Polygon", "coordinates": [[[-122.89472, 38.47891], [-122.89472, 38.48002], [-122.89321, 38.47999], [-122.8932, 38.48027], [-122.89244, 38.48027], [-122.89245, 38.47815], [-122.89323, 38.47814], [-122.89323, 38.4789], [-122.89472, 38.47891]]]} | No Public Access 3 | Forestville Park Development District-Land Bank | 19000 | 3131 | Forestville Park Development District 791 | Non Profit 6 | Non Profit - Other 20 | http://www.forestvilleyouthpark.org/ | Non Governmental Organization 10 | 7.934 | Forestville Park Development District-Land Bank | ||
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 | |
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 | ||
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 |
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 | |
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 | |
4234 | 4234 | 4233 | {"type": "Polygon", "coordinates": [[[-122.33796, 37.45405], [-122.33784, 37.45482], [-122.3369, 37.45579], [-122.33616, 37.45669], [-122.33589, 37.45776], [-122.33615, 37.45885], [-122.33668, 37.45965], [-122.31809, 37.47368], [-122.31806, 37.47368], [-122.3133, 37.47728], [-122.30701, 37.47208], [-122.30872, 37.47077], [-122.30803, 37.46999], [-122.30845, 37.46868], [-122.30961, 37.46678], [-122.31148, 37.46868], [-122.31435, 37.46651], [-122.3146, 37.46658], [-122.31482, 37.46659], [-122.31542, 37.46654], [-122.3156, 37.46558], [-122.33576, 37.45033], [-122.33575, 37.45149], [-122.33668, 37.45179], [-122.33796, 37.45405]]]} | Restricted Access 2 | Filoli Center | 18900 | 3047 | National Trust for Historic Preservation 1122 | Non Profit 6 | Non Profit - Other 20 | http://www.preservationnation.org/ | Non Governmental Organization 10 | 657.366 | Filoli Ctr. | 1975 | |
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 | |
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 | |
10886 | 10886 | 10885 | {"type": "Polygon", "coordinates": [[[-122.03659, 37.24213], [-122.03656, 37.24226], [-122.03614, 37.24251], [-122.03601, 37.24284], [-122.03596, 37.24285], [-122.03584, 37.24306], [-122.03584, 37.24313], [-122.03565, 37.24361], [-122.03505, 37.24416], [-122.03482, 37.24449], [-122.03472, 37.24469], [-122.0349, 37.24502], [-122.03444, 37.24515], [-122.03294, 37.24597], [-122.0323, 37.24568], [-122.03164, 37.24542], [-122.03126, 37.24543], [-122.03128, 37.24541], [-122.03126, 37.24514], [-122.03074, 37.24453], [-122.03067, 37.24456], [-122.03066, 37.24457], [-122.03116, 37.24517], [-122.03117, 37.24539], [-122.0311, 37.24547], [-122.03048, 37.24587], [-122.03042, 37.24594], [-122.03038, 37.24604], [-122.03035, 37.24666], [-122.02997, 37.24667], [-122.02985, 37.24671], [-122.02975, 37.24677], [-122.02876, 37.24793], [-122.02872, 37.24801], [-122.0287, 37.2481], [-122.02869, 37.2471], [-122.02818, 37.24671], [-122.0283, 37.24665], [-122.02852, 37.24611], [-122.02868, 37.24581], [-122.02884, 37.24559], [-122.02898, 37.24529], [-122.02865, 37.24516], [-122.02864, 37.2449], [-122.02885, 37.24453], [-122.029, 37.24436], [-122.02904, 37.24415], [-122.029, 37.24393], [-122.02906, 37.24287], [-122.02722, 37.24287], [-122.0271, 37.23559], [-122.03129, 37.23551], [-122.03137, 37.23925], [-122.03652, 37.23927], [-122.03612, 37.24107], [-122.03659, 37.24159], [-122.03652, 37.242], [-122.03659, 37.24213]]]} | Open Access 1 | Villa Montalvo Arboretum | 27101 | 3041 | Montalvo Association 812 | Non Profit 6 | Non Profit - Other 20 | http://montalvoarts.org/ | Non Governmental Organization 10 | 166.472 | Villa Montalvo Arboretum | 1939 | |
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 | |
4486 | 4486 | 4485 | {"type": "Polygon", "coordinates": [[[-121.6411, 36.65494], [-121.64106, 36.65632], [-121.641, 36.65661], [-121.6406, 36.65768], [-121.64034, 36.65763], [-121.63984, 36.65855], [-121.63922, 36.65869], [-121.638, 36.65816], [-121.63756, 36.65787], [-121.63698, 36.65755], [-121.63948, 36.65383], [-121.64101, 36.65449], [-121.64084, 36.65478], [-121.64083, 36.65491], [-121.6411, 36.65494]]]} | Unknown Access 4 | Garden of Memories Memorial Park | 19198 | 3031 | Independent Order of Odd Fellows 894 | Non Profit 6 | Non Profit - Other 20 | http://www.ioof.org/ | Non Governmental Organization 10 | 29.53 | Garden of Memories Memorial Park | ||
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 | ||
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 | ||
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 | |
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 | |
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 | ||
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]);