superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
240 rows where MNG_AGENCY = 21 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
- Open Access 218
- Restricted Access 2
MNG_AG_TYP 1
- City Agency 220
MNG_AGENCY 1
- San Francisco, City and County of · 220 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1834 | 1834 | 1833 | {"type": "Polygon", "coordinates": [[[-122.39575, 37.71662], [-122.39566, 37.71671], [-122.39559, 37.71682], [-122.39554, 37.71692], [-122.3955, 37.71711], [-122.39546, 37.71717], [-122.39537, 37.71729], [-122.39521, 37.71739], [-122.39461, 37.71762], [-122.39453, 37.71768], [-122.39445, 37.71776], [-122.3944, 37.7179], [-122.39441, 37.71804], [-122.39449, 37.71817], [-122.39462, 37.71826], [-122.39442, 37.71849], [-122.39393, 37.71821], [-122.39396, 37.71817], [-122.39396, 37.71816], [-122.39334, 37.7178], [-122.3936, 37.71771], [-122.39361, 37.71769], [-122.39329, 37.71739], [-122.39333, 37.71736], [-122.39333, 37.71734], [-122.39278, 37.71682], [-122.39201, 37.71657], [-122.39125, 37.71612], [-122.39002, 37.7146], [-122.38947, 37.71408], [-122.38921, 37.71419], [-122.38904, 37.71395], [-122.3889, 37.7137], [-122.3888, 37.71349], [-122.38871, 37.71322], [-122.38904, 37.71326], [-122.38918, 37.7133], [-122.38933, 37.71337], [-122.38945, 37.71345], [-122.38955, 37.71355], [-122.38965, 37.71367], [-122.38973, 37.71384], [-122.38985, 37.71396], [-122.39002, 37.71405], [-122.39033, 37.71413], [-122.39049, 37.71423], [-122.39059, 37.71434], [-122.39082, 37.71473], [-122.3911, 37.71508], [-122.39132, 37.71543], [-122.39144, 37.71557], [-122.39157, 37.71566], [-122.39208, 37.71586], [-122.39215, 37.71579], [-122.39231, 37.71568], [-122.39242, 37.71557], [-122.3925, 37.71554], [-122.39303, 37.71564], [-122.39361, 37.71583], [-122.39418, 37.71592], [-122.39424, 37.71597], [-122.39419, 37.71601], [-122.39419, 37.71608], [-122.39412, 37.71631], [-122.39411, 37.71648], [-122.39415, 37.71661], [-122.39423, 37.71671], [-122.39452, 37.71701], [-122.39464, 37.71708], [-122.39482, 37.71715], [-122.39494, 37.71717], [-122.39509, 37.71717], [-122.39522, 37.71714], [-122.39533, 37.71709], [-122.39543, 37.71702], [-122.39549, 37.71695], [-122.39559, 37.71679], [-122.39567, 37.71663], [-122.39571, 37.71661], [-122.39575, 37.71662]]]} | Open Access 1 | Bay View Hill Park/open Space | 15883 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 15.907 | Bay View Hill Park/open Space | ||
1835 | 1835 | 1834 | {"type": "Polygon", "coordinates": [[[-122.39405, 37.7255], [-122.39347, 37.72679], [-122.39241, 37.72618], [-122.39337, 37.72511], [-122.39405, 37.7255]]]} | Open Access 1 | Bay View Playground | 15884 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3.402 | Bay View Playground | ||
1848 | 1848 | 1847 | {"type": "MultiPolygon", "coordinates": [[[[-122.3922, 37.71559], [-122.39216, 37.71564], [-122.39203, 37.71573], [-122.39196, 37.71582], [-122.39157, 37.71566], [-122.39149, 37.71561], [-122.39132, 37.71543], [-122.3911, 37.71508], [-122.39087, 37.71479], [-122.3906, 37.71435], [-122.39054, 37.71427], [-122.39045, 37.7142], [-122.39033, 37.71413], [-122.39002, 37.71405], [-122.38985, 37.71396], [-122.38975, 37.71387], [-122.38965, 37.71367], [-122.38954, 37.71354], [-122.38943, 37.71344], [-122.38929, 37.71335], [-122.38901, 37.71325], [-122.38871, 37.71322], [-122.38788, 37.71346], [-122.38782, 37.71323], [-122.38772, 37.7127], [-122.38766, 37.71252], [-122.38758, 37.71238], [-122.38748, 37.71225], [-122.38716, 37.71196], [-122.3877, 37.71161], [-122.38883, 37.71256], [-122.38931, 37.71267], [-122.38973, 37.71285], [-122.39008, 37.71307], [-122.39023, 37.71319], [-122.39047, 37.71342], [-122.39063, 37.71353], [-122.39074, 37.7136], [-122.39116, 37.71377], [-122.39105, 37.71375], [-122.39095, 37.71377], [-122.39087, 37.71383], [-122.39083, 37.71392], [-122.3908, 37.71408], [-122.3908, 37.71427], [-122.39084, 37.71445], [-122.39091, 37.71459], [-122.39144, 37.71537], [-122.3916, 37.71553], [-122.39168, 37.71558], [-122.3918, 37.71561], [-122.39191, 37.71561], [-122.39218, 37.71556], [-122.3922, 37.71559]]], [[[-122.39544, 37.71475], [-122.39542, 37.71483], [-122.39515, 37.71539], [-122.39505, 37.71539], [-122.39498, 37.71542], [-122.39492, 37.71549], [-122.39489, 37.71561], [-122.39442, 37.71586], [-122.39434, 37.71586], [-122.39417, 37.71579], [-122.39364, 37.71572], [-122.39313, 37.71555], [-122.39252, 37.71544], [-122.39229, 37.71543], [-122.39189, 37.7155], [-122.39181, 37.7155], [-122.39169, 37.71546], [-122.39159, 37.71535], [-122.39135, 37.71498], [-122.39106, 37.7146], [-122.39098, 37.71444], [-122.39094, 37.71429], [-122.39093, 37.71418], [-122.39094, 37.71403], [-122.39098, 37.7139], [-122.39102, 37.71387], [-122.39108, 37.71386], [-122.39128, 37.71394], [-122.39153, 37.71406], [-122.39171, 37.71413], [-122.39256, 37.7143], [-122.39306, 37.71438], [-122.39348, 37.71452], [-122.39369, 37.71454], [-122.39428, 37.71451], [-122.39441, 37.71452], [-122.39499, 37.71467], [-122.39544, 37.71475]]]]} | Open Access 1 | Bayview Park | 15903 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 20.372 | Bayview Park | ||
1908 | 1908 | 1907 | {"type": "Polygon", "coordinates": [[[-122.43873, 37.78243], [-122.43853, 37.78246], [-122.4385, 37.78234], [-122.43871, 37.78232], [-122.43873, 37.78243]]]} | Open Access 1 | Beideman/o'farrell Mini Park | 15958 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.059 | Beideman/o'farrell MP | ||
1963 | 1963 | 1962 | {"type": "Polygon", "coordinates": [[[-122.41317, 37.74214], [-122.41315, 37.74224], [-122.41294, 37.74222], [-122.41295, 37.74212], [-122.41317, 37.74214]]]} | Open Access 1 | Bernal Heights Community Garden | 16025 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.056 | Bernal Heights Community Garden | ||
1965 | 1965 | 1964 | {"type": "Polygon", "coordinates": [[[-122.41541, 37.74416], [-122.41424, 37.74386], [-122.4139, 37.74373], [-122.41308, 37.74338], [-122.41291, 37.74333], [-122.41277, 37.74333], [-122.41262, 37.74335], [-122.41236, 37.74347], [-122.41201, 37.74361], [-122.41188, 37.74363], [-122.41171, 37.74361], [-122.41023, 37.74309], [-122.41017, 37.74304], [-122.41012, 37.74297], [-122.4101, 37.74289], [-122.4101, 37.74281], [-122.41018, 37.74269], [-122.41031, 37.74257], [-122.41045, 37.74251], [-122.4106, 37.74249], [-122.41164, 37.74243], [-122.41251, 37.74231], [-122.41265, 37.7423], [-122.41416, 37.74251], [-122.41432, 37.74252], [-122.41446, 37.7425], [-122.41462, 37.74246], [-122.41479, 37.74238], [-122.41501, 37.74225], [-122.41512, 37.74222], [-122.4159, 37.74217], [-122.41629, 37.74208], [-122.41647, 37.74206], [-122.41669, 37.74209], [-122.41682, 37.74215], [-122.41689, 37.74222], [-122.41696, 37.74233], [-122.41699, 37.74242], [-122.41698, 37.74251], [-122.41693, 37.74261], [-122.4167, 37.74279], [-122.41662, 37.74291], [-122.41657, 37.74307], [-122.41659, 37.74328], [-122.41655, 37.74337], [-122.41647, 37.74345], [-122.4161, 37.74363], [-122.41597, 37.74372], [-122.41586, 37.74383], [-122.4158, 37.74393], [-122.41575, 37.74406], [-122.41568, 37.74413], [-122.41556, 37.74418], [-122.41541, 37.74416]], [[-122.41555, 37.74287], [-122.41477, 37.74286], [-122.41477, 37.74326], [-122.41555, 37.74326], [-122.41555, 37.74287]]]} | Open Access 1 | Bernal Heights Park | 16026 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 19.373 | Bernal Heights Park | ||
14658 | 14658 | 14657 | {"type": "MultiPolygon", "coordinates": [[[[-122.41073, 37.74232], [-122.41072, 37.74236], [-122.41059, 37.74237], [-122.41059, 37.74232], [-122.41073, 37.74232]]], [[[-122.41136, 37.74229], [-122.41136, 37.74233], [-122.41122, 37.74234], [-122.41122, 37.74228], [-122.41136, 37.74229]]], [[[-122.41197, 37.74224], [-122.41197, 37.74227], [-122.41183, 37.74229], [-122.41184, 37.74224], [-122.41197, 37.74224]]], [[[-122.41541, 37.74416], [-122.41541, 37.74426], [-122.41446, 37.74402], [-122.41445, 37.74403], [-122.41446, 37.74416], [-122.41343, 37.74422], [-122.4134, 37.7439], [-122.41331, 37.74382], [-122.41314, 37.74375], [-122.41265, 37.74369], [-122.41245, 37.74361], [-122.41242, 37.74356], [-122.41231, 37.74349], [-122.41256, 37.74337], [-122.41267, 37.74334], [-122.41284, 37.74333], [-122.41297, 37.74334], [-122.4139, 37.74373], [-122.41424, 37.74386], [-122.41541, 37.74416]]], [[[-122.4126, 37.74215], [-122.4126, 37.74218], [-122.41246, 37.74219], [-122.41246, 37.74214], [-122.4126, 37.74215]]], [[[-122.41382, 37.74229], [-122.41382, 37.74235], [-122.41368, 37.74233], [-122.41369, 37.74229], [-122.41382, 37.74229]]], [[[-122.41572, 37.74203], [-122.41572, 37.74207], [-122.41558, 37.74208], [-122.41558, 37.74202], [-122.41572, 37.74203]]], [[[-122.41635, 37.74194], [-122.41635, 37.74195], [-122.41621, 37.74198], [-122.41621, 37.74193], [-122.41635, 37.74194]]], [[[-122.41763, 37.74237], [-122.41719, 37.74304], [-122.41667, 37.74283], [-122.41694, 37.7426], [-122.41699, 37.74248], [-122.41698, 37.74238], [-122.41689, 37.74222], [-122.41676, 37.74212], [-122.41663, 37.74207], [-122.41642, 37.74206], [-122.41641, 37.74195], [-122.41658, 37.74196], [-122.41673, 37.742], [-122.41682, 37.74186], [-122.41705, 37.74186], [-122.41721, 37.74193], [-122.41718, 37.74202], [-122.41737, 37.7421], [-122.4173, 37.74223], [-122.41763, 37.74237]]]]} | Open Access 1 | Bernal Hts Open Space | 16027 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3.842 | Bernal Hts OS | ||
2024 | 2024 | 2023 | {"type": "Polygon", "coordinates": [[[-122.43465, 37.74209], [-122.43433, 37.7421], [-122.4343, 37.74179], [-122.43417, 37.74158], [-122.43411, 37.74157], [-122.43407, 37.74153], [-122.434, 37.7415], [-122.43392, 37.74151], [-122.43382, 37.74159], [-122.43355, 37.74167], [-122.43253, 37.74172], [-122.43239, 37.74168], [-122.43209, 37.74148], [-122.43227, 37.74138], [-122.43249, 37.74131], [-122.43221, 37.74099], [-122.43261, 37.74078], [-122.43282, 37.74088], [-122.43396, 37.74123], [-122.43413, 37.74133], [-122.43427, 37.74146], [-122.43465, 37.74209]]]} | Open Access 1 | Billy Goat Hill | 16115 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3.194 | Billy Goat Hill | ||
2108 | 2108 | 2107 | {"type": "Polygon", "coordinates": [[[-122.41585, 37.74445], [-122.41555, 37.74491], [-122.41512, 37.74474], [-122.4154, 37.74429], [-122.41561, 37.74437], [-122.41563, 37.74436], [-122.41585, 37.74445]]]} | Open Access 1 | Bocana St. Open Space | 16217 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.604 | Bocana St. OS | ||
2240 | 2240 | 2239 | {"type": "Polygon", "coordinates": [[[-122.40744, 37.74501], [-122.40737, 37.7452], [-122.40686, 37.74507], [-122.40694, 37.74488], [-122.40744, 37.74501]]]} | Open Access 1 | Brewster Cmmunity Garden | 16369 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.26 | Brewster Cmmunity Garden | ||
2268 | 2268 | 2267 | {"type": "Polygon", "coordinates": [[[-122.41296, 37.79709], [-122.41291, 37.7971], [-122.41288, 37.79701], [-122.41284, 37.797], [-122.41282, 37.79693], [-122.41292, 37.79692], [-122.41296, 37.79709]]]} | Open Access 1 | Broadway Tunnel east Mini Park | 16410 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.033 | Broadway Tunnel east MP | ||
2269 | 2269 | 2268 | {"type": "Polygon", "coordinates": [[[-122.41762, 37.79648], [-122.41725, 37.79653], [-122.41722, 37.79639], [-122.4176, 37.79634], [-122.41762, 37.79648]]]} | Open Access 1 | Broadway Tunnel West Mini Park | 16411 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.125 | Broadway Tunnel West MP | ||
2285 | 2285 | 2284 | {"type": "Polygon", "coordinates": [[[-122.46792, 37.71714], [-122.46758, 37.71715], [-122.46758, 37.71755], [-122.46724, 37.71756], [-122.46726, 37.71785], [-122.46669, 37.71784], [-122.46666, 37.71757], [-122.46635, 37.71757], [-122.46634, 37.71784], [-122.46613, 37.71785], [-122.46612, 37.71757], [-122.46578, 37.71757], [-122.46578, 37.71695], [-122.4661, 37.71695], [-122.46612, 37.71687], [-122.46792, 37.71687], [-122.46792, 37.71714]]]} | Open Access 1 | Brooks Park | 16429 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3.742 | Brooks Park | ||
1593 | 1593 | 1592 | {"type": "Polygon", "coordinates": [[[-122.47036, 37.7124], [-122.47027, 37.71248], [-122.47025, 37.71257], [-122.47006, 37.71256], [-122.46939, 37.71243], [-122.46939, 37.71226], [-122.47035, 37.71225], [-122.47036, 37.7124]]]} | Open Access 1 | Brotherhood & Chester Mini Park | 16441 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.59 | Brotherhood & Chester MP | ||
2323 | 2323 | 2322 | {"type": "MultiPolygon", "coordinates": [[[[-122.42838, 37.77801], [-122.42815, 37.77804], [-122.42806, 37.77759], [-122.42829, 37.77756], [-122.42838, 37.77801]]], [[[-122.42857, 37.77894], [-122.42834, 37.77897], [-122.42819, 37.77823], [-122.42842, 37.7782], [-122.42857, 37.77894]]], [[[-122.42876, 37.77987], [-122.42853, 37.7799], [-122.42838, 37.77916], [-122.42861, 37.77913], [-122.42876, 37.77987]]], [[[-122.42895, 37.78081], [-122.42872, 37.78084], [-122.42857, 37.78009], [-122.4288, 37.78006], [-122.42895, 37.78081]]], [[[-122.42907, 37.78141], [-122.42884, 37.78144], [-122.42875, 37.78102], [-122.42899, 37.78099], [-122.42907, 37.78141]]]]} | Open Access 1 | Buchanan Street Mall | 16470 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.812 | Buchanan Street Mall | ||
2343 | 2343 | 2342 | {"type": "Polygon", "coordinates": [[[-122.44374, 37.76757], [-122.4436, 37.76795], [-122.44361, 37.76797], [-122.44326, 37.76884], [-122.44222, 37.7695], [-122.44226, 37.76963], [-122.4424, 37.76978], [-122.44259, 37.76978], [-122.44281, 37.76981], [-122.44298, 37.76997], [-122.44309, 37.77012], [-122.44316, 37.77039], [-122.44062, 37.77072], [-122.43988, 37.77049], [-122.43983, 37.77049], [-122.43959, 37.77036], [-122.43939, 37.76998], [-122.43915, 37.7698], [-122.43906, 37.76971], [-122.43904, 37.7697], [-122.43845, 37.7691], [-122.43892, 37.76848], [-122.44026, 37.76782], [-122.44072, 37.76703], [-122.44207, 37.76601], [-122.4424, 37.76602], [-122.4427, 37.7661], [-122.44291, 37.76625], [-122.44295, 37.76637], [-122.44296, 37.76638], [-122.44298, 37.76649], [-122.44345, 37.76678], [-122.44363, 37.7671], [-122.44374, 37.76757]]]} | Open Access 1 | Buena Vista Park | 16492 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 36.125 | Buena Vista Park | ||
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 | ||
2176 | 2176 | 2175 | {"type": "MultiPolygon", "coordinates": [[[[-122.47637, 37.73917], [-122.47555, 37.73921], [-122.47543, 37.73756], [-122.47625, 37.73752], [-122.47637, 37.73917]]], [[[-122.4765, 37.74103], [-122.47568, 37.74107], [-122.47556, 37.73943], [-122.47639, 37.73939], [-122.4765, 37.74103]]]]} | Open Access 1 | Carl Larsen Park | 16853 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 6.583 | Carl Larsen Park | ||
2726 | 2726 | 2725 | {"type": "Polygon", "coordinates": [[[-122.43308, 37.73045], [-122.43291, 37.7305], [-122.4328, 37.73023], [-122.43296, 37.73017], [-122.43308, 37.73045]]]} | Open Access 1 | Cayuga & Lamartine Mini Park | 16985 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.126 | Cayuga & Lamartine MP | ||
2717 | 2717 | 2716 | {"type": "Polygon", "coordinates": [[[-122.45124, 37.71372], [-122.45007, 37.71466], [-122.44956, 37.71426], [-122.44988, 37.71398], [-122.44966, 37.71379], [-122.44963, 37.71374], [-122.45015, 37.7135], [-122.45062, 37.71323], [-122.45124, 37.71372]]]} | Open Access 1 | Cayuga Playground | 16986 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 2.921 | Cayuga 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]);