superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
240 rows where MNG_AGENCY = 21 sorted by MNG_AG_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1414 | 1414 | 1413 | {"type": "Polygon", "coordinates": [[[-122.38674, 37.76527], [-122.38641, 37.76569], [-122.38597, 37.76658], [-122.38587, 37.76659], [-122.38593, 37.76636], [-122.38592, 37.76628], [-122.38629, 37.76569], [-122.38652, 37.76541], [-122.38654, 37.7653], [-122.38647, 37.76528], [-122.38646, 37.76523], [-122.38674, 37.76527]]]} | Open Access 1 | Agua Vista Park | 15295 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.47 | Agua Vista Park | ||
1460 | 1460 | 1459 | {"type": "Polygon", "coordinates": [[[-122.43935, 37.79177], [-122.4363, 37.79215], [-122.43599, 37.79058], [-122.43904, 37.79019], [-122.43935, 37.79177]]]} | Open Access 1 | Alta Plaza | 15419 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 11.904 | Alta Plaza | ||
1502 | 1502 | 1501 | {"type": "MultiPolygon", "coordinates": [[[[-122.45856, 37.77926], [-122.45682, 37.77948], [-122.45662, 37.77952], [-122.45657, 37.77952], [-122.45653, 37.77948], [-122.45628, 37.77823], [-122.45689, 37.77815], [-122.45692, 37.7782], [-122.45697, 37.77824], [-122.4571, 37.77827], [-122.45847, 37.7781], [-122.45856, 37.77926]]], [[[-122.45804, 37.77801], [-122.45765, 37.77806], [-122.45759, 37.77775], [-122.45798, 37.7777], [-122.45804, 37.77801]]]]} | Open Access 1 | Angelo J Rossi Playground | 15497 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 6.473 | Angelo J Rossi Playground | ||
1527 | 1527 | 1526 | {"type": "Polygon", "coordinates": [[[-122.46755, 37.72831], [-122.46726, 37.72858], [-122.46698, 37.72888], [-122.46678, 37.72914], [-122.46657, 37.72944], [-122.46548, 37.72903], [-122.46575, 37.72864], [-122.46609, 37.72822], [-122.4664, 37.72789], [-122.46684, 37.72753], [-122.46709, 37.72775], [-122.46726, 37.72793], [-122.46755, 37.72831]]]} | Open Access 1 | Aptos Playground | 15546 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 4.792 | Aptos Playground | ||
1550 | 1550 | 1549 | {"type": "Polygon", "coordinates": [[[-122.47813, 37.7796], [-122.4773, 37.77964], [-122.47727, 37.77923], [-122.4781, 37.77919], [-122.47813, 37.7796]]]} | Open Access 1 | Argonne Playground | 15583 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.818 | Argonne Playground | ||
1565 | 1565 | 1564 | {"type": "Polygon", "coordinates": [[[-122.39829, 37.75743], [-122.39812, 37.75744], [-122.3981, 37.75726], [-122.39827, 37.75725], [-122.39829, 37.75743]]]} | Open Access 1 | Arkansas Friendship Garden | 15586 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.075 | Arkansas Friendship Garden | ||
1566 | 1566 | 1565 | {"type": "Polygon", "coordinates": [[[-122.42661, 37.73695], [-122.42617, 37.73724], [-122.42612, 37.73719], [-122.42652, 37.73686], [-122.42661, 37.73695]]]} | Open Access 1 | Arlington Community Garden | 15587 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.129 | Arlington Community Garden | ||
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 | ||
1736 | 1736 | 1735 | {"type": "Polygon", "coordinates": [[[-122.4469, 37.72308], [-122.44688, 37.72368], [-122.44681, 37.72389], [-122.44654, 37.72452], [-122.44566, 37.72454], [-122.44567, 37.72507], [-122.44619, 37.72507], [-122.44619, 37.7251], [-122.44621, 37.72511], [-122.44606, 37.7253], [-122.44587, 37.72532], [-122.4454, 37.726], [-122.44534, 37.72599], [-122.445, 37.72648], [-122.44499, 37.72652], [-122.44503, 37.72655], [-122.44496, 37.72665], [-122.44181, 37.72667], [-122.44482, 37.72306], [-122.44674, 37.72306], [-122.4469, 37.72308]]]} | Open Access 1 | Balboa Park & Pool | 15772 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 23.784 | Balboa Park & Pool | ||
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 | ||
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 | ||
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 | ||
2133 | 2133 | 2132 | {"type": "Polygon", "coordinates": [[[-122.40755, 37.79404], [-122.40749, 37.79404], [-122.40744, 37.79384], [-122.40727, 37.79386], [-122.40725, 37.79379], [-122.40715, 37.7938], [-122.40711, 37.79364], [-122.40679, 37.79368], [-122.40676, 37.79356], [-122.40689, 37.79353], [-122.40686, 37.79335], [-122.40727, 37.7933], [-122.40731, 37.79345], [-122.40742, 37.79345], [-122.40755, 37.79404]]]} | Open Access 1 | Chinese Playground | 17205 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.62 | Chinese 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 |
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]);