superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
240 rows where MNG_AGENCY = 21 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
ACCESS_TYP 2
- Open Access 238
- Restricted Access 2
MNG_AG_TYP 1
- City Agency 240
MNG_AGENCY 1
- San Francisco, City and County of · 240 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4675 | 4675 | 4674 | {"type": "Polygon", "coordinates": [[[-122.51189, 37.77681], [-122.51151, 37.77685], [-122.5112, 37.77653], [-122.51112, 37.77641], [-122.51112, 37.77625], [-122.51093, 37.77611], [-122.51078, 37.77588], [-122.51061, 37.77568], [-122.51028, 37.77523], [-122.51108, 37.7752], [-122.51109, 37.77541], [-122.51113, 37.77564], [-122.5112, 37.77588], [-122.51128, 37.77607], [-122.51149, 37.7764], [-122.51189, 37.77681]]]} | Open Access 1 | Gr.hwy/balboa Natural Area | 19412 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.868 | Gr.hwy/balboa Natural Area | ||
4716 | 4716 | 4715 | {"type": "Polygon", "coordinates": [[[-122.5102, 37.76386], [-122.51015, 37.76391], [-122.50991, 37.76392], [-122.50965, 37.76173], [-122.5094, 37.76], [-122.50939, 37.75986], [-122.50915, 37.75796], [-122.5089, 37.75583], [-122.50812, 37.74987], [-122.50801, 37.74921], [-122.50784, 37.74785], [-122.50751, 37.74548], [-122.50732, 37.74382], [-122.50701, 37.74162], [-122.50621, 37.73567], [-122.50639, 37.73562], [-122.5066, 37.73566], [-122.50669, 37.73655], [-122.50685, 37.73786], [-122.50696, 37.73856], [-122.50711, 37.7399], [-122.50738, 37.7419], [-122.50741, 37.74201], [-122.50764, 37.74391], [-122.50785, 37.74543], [-122.5079, 37.74592], [-122.50815, 37.74792], [-122.50936, 37.75713], [-122.50955, 37.75874], [-122.50978, 37.76031], [-122.5099, 37.76152], [-122.5102, 37.76386]]]} | Open Access 1 | Great Highway | 19456 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 21.499 | Great Highway | ||
9533 | 9533 | 9532 | {"type": "Polygon", "coordinates": [[[-122.50745, 37.73032], [-122.5071, 37.73036], [-122.50732, 37.73155], [-122.50744, 37.73229], [-122.50743, 37.73279], [-122.50736, 37.73318], [-122.50715, 37.73403], [-122.50703, 37.7347], [-122.50704, 37.73498], [-122.50708, 37.73521], [-122.50703, 37.73524], [-122.50707, 37.73557], [-122.50664, 37.73558], [-122.5066, 37.73547], [-122.50653, 37.73539], [-122.50643, 37.73533], [-122.50628, 37.73529], [-122.50264, 37.73529], [-122.50207, 37.73524], [-122.50147, 37.73513], [-122.50101, 37.735], [-122.50063, 37.73486], [-122.50018, 37.73464], [-122.4993, 37.73417], [-122.49883, 37.73398], [-122.49856, 37.7339], [-122.49871, 37.73357], [-122.49863, 37.73354], [-122.49843, 37.73352], [-122.4957, 37.73364], [-122.49598, 37.73359], [-122.49621, 37.73354], [-122.4966, 37.7334], [-122.49693, 37.73322], [-122.49729, 37.73296], [-122.49764, 37.73261], [-122.49783, 37.73236], [-122.49793, 37.73217], [-122.49798, 37.732], [-122.49802, 37.73182], [-122.49803, 37.73164], [-122.49821, 37.73172], [-122.49842, 37.73176], [-122.49862, 37.73174], [-122.49892, 37.73175], [-122.49921, 37.7317], [-122.49936, 37.73166], [-122.50243, 37.73044], [-122.50267, 37.73042], [-122.50296, 37.73045], [-122.50294, 37.73026], [-122.50272, 37.73005], [-122.50255, 37.72988], [-122.50239, 37.72965], [-122.50227, 37.72945], [-122.50216, 37.72921], [-122.5021, 37.72904], [-122.50205, 37.72882], [-122.50203, 37.72861], [-122.50203, 37.7283], [-122.50207, 37.72807], [-122.50273, 37.72648], [-122.50721, 37.72649], [-122.50734, 37.72869], [-122.50745, 37.73032]], [[-122.50303, 37.72841], [-122.50406, 37.72865], [-122.50461, 37.72724], [-122.50277, 37.72696], [-122.50238, 37.728], [-122.5023, 37.72831], [-122.50228, 37.72851], [-122.50229, 37.72874], [-122.50232, 37.72897], [-122.50238, 37.72919], [-122.50294, 37.72922], [-122.50303, 37.72841]]]} | Open Access 1 | SF Zoological Gardens | 25332 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 134.43 | SF Zoological Gardens | ||
10149 | 10149 | 10148 | {"type": "Polygon", "coordinates": [[[-122.50507, 37.78524], [-122.50351, 37.78602], [-122.50335, 37.78648], [-122.5024, 37.78704], [-122.5018, 37.78719], [-122.50116, 37.78701], [-122.50101, 37.78639], [-122.5006, 37.7861], [-122.50017, 37.78596], [-122.49951, 37.78644], [-122.49933, 37.78655], [-122.49895, 37.78658], [-122.49859, 37.78658], [-122.49822, 37.78655], [-122.49786, 37.78647], [-122.49731, 37.7863], [-122.49707, 37.78646], [-122.49677, 37.78646], [-122.49596, 37.78658], [-122.49573, 37.78666], [-122.49514, 37.7867], [-122.49423, 37.78648], [-122.49416, 37.7864], [-122.49405, 37.78653], [-122.49392, 37.78679], [-122.49379, 37.78689], [-122.4937, 37.78691], [-122.49333, 37.78174], [-122.5011, 37.78139], [-122.50133, 37.78414], [-122.50414, 37.78401], [-122.50507, 37.78524]]]} | Restricted Access 2 | Lincoln Park Golf Course | https://sfrecpark.org/destination/lincoln-park/ | 33132 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 112.095 | Lincoln Park GC | 1909 |
14002 | 14002 | 14001 | {"type": "Polygon", "coordinates": [[[-122.50267, 37.76171], [-122.50184, 37.76175], [-122.50179, 37.76106], [-122.50262, 37.76102], [-122.50267, 37.76171]]]} | Open Access 1 | Playland at 43rd Avenue | 31457 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.381 | Playland at 43rd Avenue | 2016 | |
11115 | 11115 | 11114 | {"type": "Polygon", "coordinates": [[[-122.49967, 37.74962], [-122.4986, 37.74966], [-122.49872, 37.75128], [-122.49774, 37.75132], [-122.4976, 37.74935], [-122.49841, 37.74931], [-122.49834, 37.74777], [-122.49847, 37.74777], [-122.49849, 37.74797], [-122.49956, 37.74794], [-122.49967, 37.74962]], [[-122.49803, 37.75084], [-122.49803, 37.75115], [-122.4985, 37.75112], [-122.49847, 37.75082], [-122.49803, 37.75084]]]} | Open Access 1 | West Sunset Playground | 27376 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 9.279 | West Sunset Playground | ||
7957 | 7957 | 7956 | {"type": "Polygon", "coordinates": [[[-122.49956, 37.74793], [-122.49848, 37.74797], [-122.49847, 37.74777], [-122.49954, 37.74772], [-122.49956, 37.74793]]]} | Open Access 1 | Parking Area | 23443 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.541 | Parking Area | ||
1738 | 1738 | 1737 | {"type": "Polygon", "coordinates": [[[-122.49914, 37.77303], [-122.49875, 37.77305], [-122.49873, 37.77312], [-122.49832, 37.77314], [-122.49829, 37.77266], [-122.49911, 37.77262], [-122.49914, 37.77303]]]} | Open Access 1 | Cabrillo Playground | 16643 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.894 | Cabrillo Playground | ||
9819 | 9819 | 9818 | {"type": "Polygon", "coordinates": [[[-122.49902, 37.73817], [-122.49804, 37.73822], [-122.49793, 37.73657], [-122.49883, 37.73653], [-122.49891, 37.73762], [-122.49898, 37.73763], [-122.49902, 37.73817]]]} | Open Access 1 | South Sunset Playground | 25681 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3.724 | South Sunset Playground | ||
10139 | 10139 | 10138 | {"type": "Polygon", "coordinates": [[[-122.49841, 37.74932], [-122.49762, 37.74935], [-122.4976, 37.74941], [-122.49561, 37.7495], [-122.4956, 37.74928], [-122.49642, 37.74925], [-122.49633, 37.74786], [-122.49834, 37.74777], [-122.49841, 37.74932]]]} | Open Access 1 | Sunset West Playground | 26071 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 8.056 | Sunset West Playground | ||
3742 | 3742 | 3741 | {"type": "Polygon", "coordinates": [[[-122.49126, 37.78287], [-122.49044, 37.78291], [-122.49041, 37.7825], [-122.49123, 37.78246], [-122.49126, 37.78287]]]} | Open Access 1 | Dupont Tennis Courts | 18310 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.822 | Dupont Tennis Courts | ||
8148 | 8148 | 8147 | {"type": "Polygon", "coordinates": [[[-122.49106, 37.73721], [-122.49106, 37.73724], [-122.491, 37.73735], [-122.49086, 37.73752], [-122.49059, 37.73768], [-122.49044, 37.73775], [-122.49028, 37.73779], [-122.49008, 37.7378], [-122.4899, 37.73778], [-122.48968, 37.73772], [-122.48973, 37.73758], [-122.4897, 37.73749], [-122.48953, 37.73734], [-122.48929, 37.737], [-122.48919, 37.73693], [-122.48907, 37.73688], [-122.48872, 37.73677], [-122.4885, 37.73673], [-122.4878, 37.7367], [-122.4872, 37.73663], [-122.48676, 37.73661], [-122.48632, 37.7365], [-122.48597, 37.73648], [-122.48547, 37.73654], [-122.48524, 37.73662], [-122.48504, 37.73677], [-122.48505, 37.73699], [-122.48497, 37.73703], [-122.48487, 37.73704], [-122.48282, 37.73713], [-122.48282, 37.73742], [-122.48253, 37.73742], [-122.48225, 37.73738], [-122.48204, 37.73731], [-122.48185, 37.73721], [-122.48167, 37.73707], [-122.48165, 37.73646], [-122.48177, 37.73644], [-122.48187, 37.73567], [-122.48229, 37.73574], [-122.48238, 37.73549], [-122.48267, 37.73553], [-122.48295, 37.73554], [-122.48347, 37.73552], [-122.48376, 37.73547], [-122.4846, 37.73524], [-122.48514, 37.73516], [-122.48518, 37.73535], [-122.48578, 37.73529], [-122.48581, 37.73542], [-122.48611, 37.73541], [-122.4865, 37.73541], [-122.48688, 37.73545], [-122.48741, 37.73553], [-122.4878, 37.73556], [-122.4887, 37.73556], [-122.48897, 37.7356], [-122.48936, 37.73569], [-122.48967, 37.73585], [-122.48981, 37.73596], [-122.4899, 37.73605], [-122.49007, 37.73629], [-122.49018, 37.73655], [-122.4903, 37.73675], [-122.49065, 37.73721], [-122.49102, 37.73714], [-122.49106, 37.73721]]]} | Open Access 1 | Pine Lake Park | 23682 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 30.295 | Pine Lake Park | ||
3531 | 3531 | 3530 | {"type": "Polygon", "coordinates": [[[-122.48736, 37.77357], [-122.48654, 37.77361], [-122.48651, 37.7732], [-122.48733, 37.77316], [-122.48736, 37.77357]]]} | Open Access 1 | Fulton Playground | 19149 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.819 | Fulton Playground | ||
13128 | 13128 | 13127 | {"type": "Polygon", "coordinates": [[[-122.48732, 37.75739], [-122.48649, 37.75743], [-122.48638, 37.75579], [-122.4872, 37.75575], [-122.48732, 37.75739]]]} | Open Access 1 | Sunset Recreation Center | http://sfrecpark.org/destination/sunset-rec-center-park/ | 30853 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3.285 | Sunset Rec. Ctr. | 1940 |
8842 | 8842 | 8841 | {"type": "Polygon", "coordinates": [[[-122.48497, 37.78502], [-122.48414, 37.78506], [-122.48411, 37.78465], [-122.48494, 37.78462], [-122.48497, 37.78502]]]} | Open Access 1 | Rochambeau Playground | 24507 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.825 | Rochambeau Playground | ||
7963 | 7963 | 7962 | {"type": "Polygon", "coordinates": [[[-122.48495, 37.73879], [-122.48305, 37.73888], [-122.48298, 37.73793], [-122.48286, 37.73791], [-122.4828, 37.73713], [-122.48482, 37.73704], [-122.48495, 37.73879]]]} | Open Access 1 | Parkside Square | 23452 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 8.309 | Parkside Square | ||
9662 | 9662 | 9661 | {"type": "Polygon", "coordinates": [[[-122.48187, 37.73567], [-122.48177, 37.73645], [-122.48165, 37.73648], [-122.48167, 37.73706], [-122.47545, 37.73734], [-122.4753, 37.73486], [-122.47533, 37.73482], [-122.4761, 37.73484], [-122.47852, 37.73477], [-122.48187, 37.73567]]]} | Open Access 1 | Sigmund Stern Grove | 25474 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 33.804 | Sigmund Stern Grove | ||
8921 | 8921 | 8920 | {"type": "Polygon", "coordinates": [[[-122.4813, 37.73044], [-122.48094, 37.73047], [-122.48094, 37.73108], [-122.47952, 37.73106], [-122.47952, 37.73057], [-122.47964, 37.73056], [-122.47999, 37.73047], [-122.48041, 37.73011], [-122.48105, 37.72997], [-122.48129, 37.73025], [-122.4813, 37.73044]]]} | Open Access 1 | Rolph-Nicole Park | 24585 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3.051 | Rolph-Nicole Park | ||
6802 | 6802 | 6801 | {"type": "Polygon", "coordinates": [[[-122.48105, 37.74458], [-122.47915, 37.74466], [-122.47905, 37.7433], [-122.47956, 37.74328], [-122.47955, 37.74299], [-122.48094, 37.74293], [-122.48105, 37.74458]]]} | Open Access 1 | McCoppin Square | 22006 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 7.248 | McCoppin Square | ||
8685 | 8685 | 8684 | {"type": "Polygon", "coordinates": [[[-122.47854, 37.78532], [-122.47771, 37.78535], [-122.47768, 37.78494], [-122.47851, 37.78491], [-122.47854, 37.78532]]]} | Open Access 1 | Richmond Playground | 24342 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.824 | Richmond Playground |
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]);