superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
240 rows where MNG_AGENCY = 21 sorted by rowid descending
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
- Open Access 219
- Restricted Access 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13192 | 13192 | 13191 | {"type": "Polygon", "coordinates": [[[-122.44267, 37.78575], [-122.44248, 37.78578], [-122.4424, 37.7854], [-122.4426, 37.78538], [-122.44267, 37.78575]]]} | Open Access 1 | Bush & Broderick Mini Park | https://sfrecpark.org/destination/bush-broderick-mini-park/ | 33394 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.181 | Bush & Broderick MP | |
13142 | 13142 | 13141 | {"type": "Polygon", "coordinates": [[[-122.42865, 37.74268], [-122.42692, 37.74279], [-122.42689, 37.74247], [-122.42706, 37.74245], [-122.42703, 37.74215], [-122.42859, 37.74206], [-122.42865, 37.74268]]]} | Open Access 1 | Upper Noe Recreation Center | http://sfrecpark.org/destination/upper-noe-rec-center/ | 30854 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 2.511 | Upper Noe Rec. Ctr. | |
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 |
13019 | 13019 | 13018 | {"type": "Polygon", "coordinates": [[[-122.42461, 37.77658], [-122.42455, 37.77662], [-122.42442, 37.77664], [-122.42438, 37.77661], [-122.42424, 37.77584], [-122.42446, 37.77582], [-122.42461, 37.77658]]]} | Open Access 1 | Patricia's Green | http://sfrecpark.org/destination/patricias-green-in-hayes-valley/ | 30368 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.435 | Patricia's Green | |
13014 | 13014 | 13013 | {"type": "Polygon", "coordinates": [[[-122.42778, 37.77617], [-122.42702, 37.77627], [-122.42696, 37.77595], [-122.42771, 37.77585], [-122.42778, 37.77617]]]} | Open Access 1 | Hayes Valley Community Center | 30367 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.61 | Hayes Valley Community Ctr. | ||
12481 | 12481 | 12480 | {"type": "Polygon", "coordinates": [[[-122.43003, 37.77971], [-122.42876, 37.77987], [-122.42861, 37.77913], [-122.42988, 37.77897], [-122.43003, 37.77971]]]} | Open Access 1 | Ella Hill Hutch Center | https://www.sfparksalliance.org/our-parks/parks/ella-hill-hutch-center | 32433 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 2.343 | Ella Hill Hutch Ctr. | |
12383 | 12383 | 12382 | {"type": "Polygon", "coordinates": [[[-122.42157, 37.77045], [-122.42131, 37.77037], [-122.42129, 37.77034], [-122.42116, 37.77034], [-122.4207, 37.77027], [-122.42032, 37.77026], [-122.42031, 37.77011], [-122.42153, 37.77003], [-122.42157, 37.77045]]]} | Open Access 1 | SoMa West Skate Park | 30945 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.741 | SoMa West Skate Park | ||
12250 | 12250 | 12249 | {"type": "MultiPolygon", "coordinates": [[[[-122.47151, 37.71188], [-122.47141, 37.71171], [-122.47136, 37.7115], [-122.47133, 37.70821], [-122.47147, 37.70821], [-122.47151, 37.71188]]], [[[-122.48553, 37.70815], [-122.48534, 37.70842], [-122.48507, 37.70878], [-122.48499, 37.70894], [-122.48496, 37.70911], [-122.48497, 37.70935], [-122.48513, 37.70997], [-122.48523, 37.71051], [-122.48506, 37.71433], [-122.48501, 37.71444], [-122.48492, 37.7145], [-122.48479, 37.71453], [-122.47919, 37.71434], [-122.47797, 37.71434], [-122.47717, 37.71437], [-122.4767, 37.71435], [-122.47627, 37.71426], [-122.47546, 37.71396], [-122.47452, 37.71345], [-122.47387, 37.71313], [-122.47392, 37.71303], [-122.47589, 37.71399], [-122.47635, 37.71414], [-122.47682, 37.71423], [-122.47736, 37.71426], [-122.47771, 37.71424], [-122.47893, 37.71423], [-122.48364, 37.71435], [-122.48368, 37.71353], [-122.4837, 37.71352], [-122.48388, 37.71327], [-122.48438, 37.7119], [-122.48451, 37.71016], [-122.48414, 37.7094], [-122.48415, 37.70915], [-122.48404, 37.70841], [-122.48381, 37.7082], [-122.48353, 37.70817], [-122.48427, 37.70816], [-122.48434, 37.70825], [-122.48429, 37.70828], [-122.48429, 37.70833], [-122.48465, 37.70894], [-122.4848, 37.70885], [-122.48484, 37.70884], [-122.48497, 37.70861], [-122.48536, 37.70815], [-122.48553, 37.70815]]], [[[-122.50028, 37.72063], [-122.50032, 37.72073], [-122.50046, 37.72096], [-122.5007, 37.7213], [-122.50202, 37.72273], [-122.5023, 37.72311], [-122.50249, 37.72342], [-122.5027, 37.72382], [-122.50281, 37.72419], [-122.50287, 37.72463], [-122.50288, 37.72488], [-122.50286, 37.72513], [-122.5028, 37.72547], [-122.50272, 37.72576], [-122.50178, 37.72806], [-122.50164, 37.72836], [-122.50141, 37.72875], [-122.50106, 37.72925], [-122.5006, 37.7298], [-122.49916, 37.7312], [-122.49908, 37.73126], [-122.49891, 37.73133], [-122.49869, 37.73135], [-122.49848, 37.7313], [-122.4983, 37.73119], [-122.49823, 37.73109], [-122.49746, 37.72951], [-122.49739, 37.72942], [-122.4972, 37.72923], [-122.49698, 37.72908], [-122.49672, 37.72897], [-122.49643, 37.7289], [-122.49614, 37.72887], [-122.49579, 37.72889], [-122.49404, 37.72931], [-122.49378, 37.72934], [-122.49356, 37.72932], [-122.49337, 37.72926], [-122.49277, 37.72895], [-122.49233, 37.72877], [-122.49215, 37.72873], [-122.49197, 37.72872], [-122.49157, 37.72878], [-122.4912, 37.72889], [-122.49092, 37.72906], [-122.49068, 37.72929], [-122.49019, 37.72982], [-122.49004, 37.72997], [-122.48991, 37.73007], [-122.4898, 37.73013], [-122.48963, 37.7302], [-122.48945, 37.73023], [-122.48928, 37.73025], [-122.4891, 37.73024], [-122.48895, 37.73021], [-122.4872, 37.72967], [-122.48615, 37.72938], [-122.48588, 37.72926], [-122.48567, 37.72913], [-122.48551, 37.72897], [-122.48431, 37.72756], [-122.48421, 37.7274], [-122.48415, 37.72724], [-122.48411, 37.72709], [-122.48409, 37.72693], [-122.48411, 37.7267], [-122.48514, 37.72426], [-122.48521, 37.72403], [-122.48524, 37.72379], [-122.48526, 37.7208], [-122.48524, 37.7183], [-122.48525, 37.71693], [-122.48529, 37.71624], [-122.48547, 37.71546], [-122.48555, 37.71523], [-122.48558, 37.71494], [-122.48542, 37.71338], [-122.48556, 37.71048], [-122.48554, 37.71025], [-122.4855, 37.70994], [-122.48542, 37.70964], [-122.48532, 37.70935], [-122.48529, 37.7092], [-122.48533, 37.70901], [-122.48544, 37.70881], [-122.48558, 37.70868], [-122.4858, 37.70857], [-122.486, 37.70852], [-122.48625, 37.70852], [-122.48646, 37.70858], [-122.48674, 37.70871], [-122.48713, 37.70893], [-122.48734, 37.70909], [-122.48752, 37.70926], [-122.48768, 37.70947], [-122.48796, 37.70999], [-122.48861, 37.71139], [-122.48875, 37.71166], [-122.48892, 37.71188], [-122.48909, 37.71205], [-122.48928, 37.7122], [-122.49063, 37.71307], [-122.49115, 37.71348], [-122.49153, 37.71392], [-122.49192, 37.71448], [-122.49203, 37.71459], [-122.49243, 37.71498], [-122.49289, 37.71531], [-122.49308, 37.71543], [-122.49337, 37.71557], [-122.49401, 37.71584], [-122.49735, 37.71683], [-122.4974, 37.71685], [-122.49742, 37.71684], [-122.49744, 37.71686], [-122.4978, 37.717], [-122.49812, 37.71715], [-122.49842, 37.71733], [-122.49865, 37.7175], [-122.49897, 37.71779], [-122.49933, 37.71825], [-122.49922, 37.71832], [-122.49883, 37.71905], [-122.49874, 37.71944], [-122.49883, 37.7199], [-122.49939, 37.72055], [-122.49962, 37.72072], [-122.49992, 37.72071], [-122.50028, 37.72063]], [[-122.48961, 37.71285], [-122.48961, 37.71287], [-122.48975, 37.71291], [-122.48976, 37.71286], [-122.48972, 37.71282], [-122.48961, 37.71285]]], [[[-122.49472, 37.71582], [-122.49412, 37.71563], [-122.49371, 37.71547], [-122.49324, 37.71525], [-122.4929, 37.71503], [-122.49254, 37.71475], [-122.49217, 37.71438], [-122.49137, 37.71334], [-122.49089, 37.71296], [-122.48957, 37.71211], [-122.48927, 37.71188], [-122.48913, 37.71173], [-122.489, 37.71157], [-122.48878, 37.71115], [-122.48821, 37.70991], [-122.48793, 37.70938], [-122.4878, 37.70919], [-122.4876, 37.70898], [-122.48733, 37.70878], [-122.48685, 37.7085], [-122.48639, 37.70827], [-122.48623, 37.70815], [-122.48759, 37.70879], [-122.48788, 37.70898], [-122.48809, 37.7092], [-122.48823, 37.70939], [-122.48835, 37.70964], [-122.48854, 37.71041], [-122.48909, 37.71154], [-122.4892, 37.71168], [-122.4893, 37.71174], [-122.48944, 37.7118], [-122.49016, 37.71188], [-122.49031, 37.71193], [-122.49042, 37.71199], [-122.49052, 37.71209], [-122.49221, 37.7142], [-122.4923, 37.71429], [-122.49382, 37.71534], [-122.49398, 37.71538], [-122.49445, 37.71538], [-122.49472, 37.71582]]]]} | Open Access 1 | Lake Merced Park | http://sfrecpark.org/destination/lake-merced-park/ | 29234 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 620.103 | Lake Merced Park | |
11442 | 11442 | 11441 | {"type": "Polygon", "coordinates": [[[-122.38603, 37.73925], [-122.38546, 37.73987], [-122.38325, 37.73861], [-122.3832, 37.73817], [-122.38362, 37.73814], [-122.38358, 37.73766], [-122.38403, 37.73764], [-122.38454, 37.73806], [-122.38436, 37.7383], [-122.38603, 37.73925]]]} | Open Access 1 | Youngblood-Coleman Playground | 27790 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 6.159 | Youngblood-Coleman Playground | ||
11359 | 11359 | 11358 | {"type": "Polygon", "coordinates": [[[-122.40673, 37.74516], [-122.40672, 37.74526], [-122.4065, 37.74539], [-122.40645, 37.74534], [-122.40673, 37.74516]]]} | Open Access 1 | Wolfe Lane Community Garden | 27672 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.054 | Wolfe Lane Community Garden | ||
11355 | 11355 | 11354 | {"type": "Polygon", "coordinates": [[[-122.41064, 37.79593], [-122.4101, 37.796], [-122.41003, 37.79567], [-122.41042, 37.79562], [-122.41045, 37.79578], [-122.41061, 37.79577], [-122.41064, 37.79593]]]} | Open Access 1 | Woh Hei Yuen Park | 27668 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.388 | Woh Hei Yuen Park | ||
11179 | 11179 | 11178 | {"type": "Polygon", "coordinates": [[[-122.46369, 37.75845], [-122.46366, 37.75848], [-122.46324, 37.75849], [-122.46319, 37.75848], [-122.46317, 37.75845], [-122.46283, 37.75709], [-122.46288, 37.75693], [-122.46307, 37.75677], [-122.46352, 37.75675], [-122.46357, 37.75678], [-122.46369, 37.75845]]]} | Open Access 1 | White Crane Spring | 27459 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 2.671 | White Crane Spring | ||
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 | ||
11113 | 11113 | 11112 | {"type": "Polygon", "coordinates": [[[-122.46596, 37.74109], [-122.46493, 37.74236], [-122.4645, 37.74212], [-122.46556, 37.74086], [-122.46583, 37.74099], [-122.46595, 37.74107], [-122.46596, 37.74109]]]} | Open Access 1 | West Portal Playground | 27374 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.892 | West Portal Playground | ||
11040 | 11040 | 11039 | {"type": "Polygon", "coordinates": [[[-122.41087, 37.80109], [-122.40947, 37.80126], [-122.40931, 37.80052], [-122.41014, 37.80042], [-122.41084, 37.8009], [-122.41087, 37.80109]]]} | Open Access 1 | Washington Park | 27280 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 2.193 | Washington Park | ||
11025 | 11025 | 11024 | {"type": "Polygon", "coordinates": [[[-122.38404, 37.75453], [-122.38349, 37.75473], [-122.38319, 37.75463], [-122.38303, 37.7544], [-122.38296, 37.75433], [-122.38291, 37.75389], [-122.38294, 37.75343], [-122.38306, 37.75332], [-122.38311, 37.75341], [-122.38316, 37.75418], [-122.38321, 37.75428], [-122.38327, 37.7543], [-122.38401, 37.75423], [-122.38404, 37.75453]]]} | Open Access 1 | Warm Water Cove | 27262 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.343 | Warm Water Cove | ||
11014 | 11014 | 11013 | {"type": "Polygon", "coordinates": [[[-122.43563, 37.74024], [-122.43562, 37.74029], [-122.43553, 37.74043], [-122.43545, 37.74059], [-122.43539, 37.74077], [-122.43537, 37.7409], [-122.43485, 37.74091], [-122.43415, 37.74117], [-122.43393, 37.74107], [-122.43302, 37.74079], [-122.43317, 37.74047], [-122.43363, 37.74022], [-122.43548, 37.74013], [-122.43558, 37.74017], [-122.43563, 37.74024]]]} | Open Access 1 | Walter Haas Playground | 27246 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 4.406 | Walter Haas Playground | ||
10946 | 10946 | 10945 | {"type": "Polygon", "coordinates": [[[-122.40426, 37.71229], [-122.4041, 37.71254], [-122.40372, 37.71239], [-122.40387, 37.71214], [-122.40426, 37.71229]]]} | Open Access 1 | Vis Valley Community Center | 27160 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.287 | Vis Valley Community Ctr. | ||
10941 | 10941 | 10940 | {"type": "Polygon", "coordinates": [[[-122.40969, 37.71204], [-122.40927, 37.71298], [-122.40848, 37.71277], [-122.4089, 37.71182], [-122.40969, 37.71204]]]} | Open Access 1 | Visitacion Valley Playground | 27163 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 2.053 | Visitacion Valley Playground | ||
10860 | 10860 | 10859 | {"type": "Polygon", "coordinates": [[[-122.40687, 37.77735], [-122.40638, 37.77774], [-122.40504, 37.77667], [-122.40553, 37.77628], [-122.40687, 37.77735]]]} | Open Access 1 | Victoria Manalo Draves Park | http://sfrecpark.org/destination/victoria-manalo-draves-park/ | 27077 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 2.515 | Victoria Manalo Draves 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]);