units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
118 rows where DES_TP = 2 and MNG_AGENCY = 21 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
MNG_AG_TYP 1
- City Agency 118
MNG_AGENCY 1
- San Francisco, City and County of · 118 ✖
DES_TP 1
- Local Park · 118 ✖
ACCESS_TYP 1
- Open Access 118
Link | rowid ▲ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14780 | 14780 | 14779 | {"type": "Polygon", "coordinates": [[[-122.42232, 37.77085], [-122.42202, 37.77067], [-122.4217, 37.77052], [-122.42166, 37.7701], [-122.422, 37.77024], [-122.42227, 37.77039], [-122.42232, 37.77085]]]} | Open Access 1 | 47235 | SoMa West Dog Park | 30946 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.617 | SoMa West Dog Park | 0 | Local Park 2 | 4 | |
14691 | 14691 | 14690 | {"type": "Polygon", "coordinates": [[[-122.41621, 37.76434], [-122.41587, 37.76436], [-122.41587, 37.76447], [-122.41537, 37.7645], [-122.41531, 37.76377], [-122.41615, 37.76372], [-122.41621, 37.76434]]]} | Open Access 1 | 45018 | In Chan Kaajal Park | 31768 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/project/proposed-park-site-at-17th-and-folsom/ | San Francisco 13 | 1.398 | In Chan Kaajal Park | 2017 | Local Park 2 | 4 |
13810 | 13810 | 13809 | {"type": "Polygon", "coordinates": [[[-122.43668, 37.71365], [-122.43644, 37.714], [-122.43632, 37.71395], [-122.43656, 37.7136], [-122.43668, 37.71365]]]} | Open Access 1 | 48835 | Naples Green | 33554 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | https://groundplaysf.org/projects/naples-green/ | San Francisco 13 | 0.132 | Naples Green | 0 | Local Park 2 | 4 |
12607 | 12607 | 12606 | {"type": "Polygon", "coordinates": [[[-122.42215, 37.74582], [-122.42193, 37.74583], [-122.42211, 37.74534], [-122.42215, 37.74582], [-122.42215, 37.74582]]]} | Open Access 1 | 48780 | San Jose Guerrero Park | 33506 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | https://groundplaysf.org/projects/san-jose-guerrero-park/ | San Francisco 13 | 0.127 | San Jose Guerrero Park | 0 | Local Park 2 | 4 |
10586 | 10586 | 10585 | {"type": "Polygon", "coordinates": [[[-122.39782, 37.75728], [-122.39617, 37.75738], [-122.39594, 37.755], [-122.3976, 37.7549], [-122.39782, 37.75728]]]} | Open Access 1 | 18855 | Potrero Hill Park | 23925 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 9.555 | Potrero Hill Park | 0 | Local Park 2 | 4 | |
10399 | 10399 | 10398 | {"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.71253], [-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.3919, 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.71451], [-122.39369, 37.71454], [-122.39428, 37.71451], [-122.39441, 37.71452], [-122.39499, 37.71467], [-122.39544, 37.71475]]]]} | Open Access 1 | 18378 | Bayview Park | 15903 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 20.37 | Bayview Park | 0 | Local Park 2 | 4 | |
10248 | 10248 | 10247 | {"type": "Polygon", "coordinates": [[[-122.4282, 37.76121], [-122.42628, 37.76133], [-122.42598, 37.7583], [-122.42792, 37.75819], [-122.4282, 37.76121]]]} | Open Access 1 | 17942 | Mission Dolores Park | 22296 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 14.198 | Mission Dolores Park | 0 | Local Park 2 | 4 | |
10191 | 10191 | 10190 | {"type": "Polygon", "coordinates": [[[-122.42725, 37.71489], [-122.42702, 37.71561], [-122.42711, 37.71564], [-122.42656, 37.71708], [-122.42665, 37.71713], [-122.42622, 37.71825], [-122.42583, 37.71806], [-122.42574, 37.71799], [-122.42564, 37.71789], [-122.42557, 37.71779], [-122.42507, 37.71688], [-122.4229, 37.71824], [-122.42325, 37.71871], [-122.42334, 37.71887], [-122.42337, 37.719], [-122.42338, 37.71914], [-122.42337, 37.71927], [-122.42332, 37.71943], [-122.42331, 37.71956], [-122.42337, 37.71972], [-122.42347, 37.71983], [-122.42359, 37.71991], [-122.42375, 37.71996], [-122.42482, 37.72016], [-122.42533, 37.72032], [-122.42535, 37.72029], [-122.42553, 37.72036], [-122.42436, 37.72191], [-122.42519, 37.72232], [-122.4248, 37.72284], [-122.4248, 37.72285], [-122.42485, 37.72287], [-122.42436, 37.72352], [-122.42433, 37.72351], [-122.42415, 37.72351], [-122.41994, 37.72461], [-122.41944, 37.72341], [-122.41846, 37.72367], [-122.41796, 37.72247], [-122.41697, 37.72272], [-122.41664, 37.72194], [-122.41547, 37.72225], [-122.41579, 37.72303], [-122.41304, 37.72375], [-122.41097, 37.71877], [-122.40899, 37.71928], [-122.40884, 37.71891], [-122.40875, 37.71888], [-122.40898, 37.71837], [-122.4083, 37.71818], [-122.40883, 37.71694], [-122.40836, 37.7168], [-122.40832, 37.71687], [-122.40799, 37.71678], [-122.40813, 37.71645], [-122.40846, 37.71654], [-122.40854, 37.71635], [-122.40935, 37.71657], [-122.40939, 37.71651], [-122.40971, 37.71659], [-122.40969, 37.71666], [-122.40985, 37.7167], [-122.40991, 37.71657], [-122.41023, 37.71666], [-122.41032, 37.71647], [-122.41048, 37.71651], [-122.41055, 37.71635], [-122.41219, 37.7168], [-122.41246, 37.71668], [-122.41318, 37.71646], [-122.41318, 37.71631], [-122.41366, 37.7163], [-122.41405, 37.71619], [-122.41405, 37.71596], [-122.41434, 37.71529], [-122.41547, 37.71559], [-122.41547, 37.71437], [-122.41544, 37.71436], [-122.41567, 37.71385], [-122.41531, 37.71374], [-122.41584, 37.71252], [-122.42176, 37.7142], [-122.42201, 37.71369], [-122.42368, 37.71416], [-122.42426, 37.71274], [-122.42264, 37.71227], [-122.42319, 37.71113], [-122.42257, 37.71091], [-122.42264, 37.71083], [-122.42297, 37.71091], [-122.42309, 37.71079], [-122.42325, 37.71071], [-122.42397, 37.71068], [-122.42396, 37.71035], [-122.42445, 37.71054], [-122.42441, 37.71063], [-122.42455, 37.71073], [-122.42527, 37.7111], [-122.42564, 37.71124], [-122.42604, 37.71137], [-122.42659, 37.71159], [-122.42531, 37.71439], [-122.42725, 37.71489]], [[-122.41279, 37.71696], [-122.41279, 37.71699], [-122.41319, 37.71698], [-122.41318, 37.71659], [-122.41285, 37.71669], [-122.41256, 37.71675], [-122.41236, 37.71683], [-122.41236, 37.71684], [-122.41279, 37.71696]]]} | Open Access 1 | 17818 | McLaren Park | 10942 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/destination/john-mclaren-park/ | San Francisco 13 | 333.305 | McLaren Park | 0 | Local Park 2 | 4 |
10189 | 10189 | 10188 | {"type": "MultiPolygon", "coordinates": [[[[-122.40553, 37.75997], [-122.40516, 37.75999], [-122.40512, 37.75959], [-122.40499, 37.75949], [-122.40485, 37.75946], [-122.40421, 37.75949], [-122.40414, 37.75946], [-122.40403, 37.75837], [-122.40425, 37.75836], [-122.40511, 37.75898], [-122.40538, 37.75939], [-122.40543, 37.75957], [-122.40546, 37.75984], [-122.40553, 37.75997]]], [[[-122.40601, 37.75871], [-122.40601, 37.75871], [-122.40529, 37.75811], [-122.40595, 37.75806], [-122.40601, 37.75871]]]]} | Open Access 1 | 17814 | McKinley Square | 22050 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 3.24 | McKinley Square | 0 | Local Park 2 | 4 | |
10184 | 10184 | 10183 | {"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 | 17777 | McCoppin Square | 22006 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 7.247 | McCoppin Square | 0 | Local Park 2 | 4 | |
10143 | 10143 | 10142 | {"type": "MultiPolygon", "coordinates": [[[[-122.39908, 37.79586], [-122.39906, 37.79588], [-122.39908, 37.79596], [-122.39825, 37.79607], [-122.39812, 37.79541], [-122.39895, 37.79531], [-122.39896, 37.79539], [-122.39899, 37.7954], [-122.39908, 37.79586]], [[-122.39868, 37.79596], [-122.39869, 37.79595], [-122.39858, 37.79541], [-122.39837, 37.79543], [-122.3984, 37.79559], [-122.39826, 37.79561], [-122.3983, 37.79584], [-122.39845, 37.79583], [-122.39848, 37.79598], [-122.39868, 37.79596]]], [[[-122.40035, 37.7958], [-122.39951, 37.79591], [-122.39949, 37.79582], [-122.39946, 37.79582], [-122.39937, 37.79535], [-122.39939, 37.79534], [-122.39937, 37.79525], [-122.40022, 37.79514], [-122.40035, 37.7958]], [[-122.40017, 37.79562], [-122.40018, 37.79561], [-122.40012, 37.79535], [-122.39998, 37.79537], [-122.39995, 37.79524], [-122.39974, 37.79526], [-122.39985, 37.79581], [-122.40006, 37.79578], [-122.40003, 37.79564], [-122.40017, 37.79562]]]]} | Open Access 1 | 17664 | Maritime Plaza | 21869 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 2.03 | Maritime Plaza | 0 | Local Park 2 | 4 | |
10015 | 10015 | 10014 | {"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.48535, 37.70841], [-122.48507, 37.70877], [-122.48499, 37.70894], [-122.48496, 37.70911], [-122.48497, 37.70935], [-122.48514, 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.48365, 37.71435], [-122.48368, 37.71353], [-122.4837, 37.71353], [-122.48388, 37.71328], [-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.48428, 37.70833], [-122.48465, 37.70894], [-122.4848, 37.70885], [-122.48483, 37.70885], [-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.49093, 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.48624, 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.71497], [-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.71292], [-122.48976, 37.71286], [-122.48972, 37.71282], [-122.48961, 37.71285]]], [[[-122.49472, 37.71582], [-122.49411, 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.48928, 37.71188], [-122.48913, 37.71173], [-122.489, 37.71157], [-122.48878, 37.71115], [-122.48821, 37.70991], [-122.48793, 37.70937], [-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 | 17255 | Lake Merced Park | 29234 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/destination/lake-merced-park/ | San Francisco 13 | 620.08 | Lake Merced Park | 0 | Local Park 2 | 4 |
9978 | 9978 | 9977 | {"type": "Polygon", "coordinates": [[[-122.41394, 37.7085], [-122.41372, 37.70896], [-122.41238, 37.70859], [-122.41248, 37.70833], [-122.41259, 37.70812], [-122.41328, 37.70833], [-122.41394, 37.7085]]]} | Open Access 1 | 17170 | Kelloch-Velasco Park | 20578 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.688 | Kelloch-Velasco Park | 0 | Local Park 2 | 4 | |
9879 | 9879 | 9878 | {"type": "Polygon", "coordinates": [[[-122.42011, 37.73625], [-122.42034, 37.73626], [-122.42054, 37.73633], [-122.42073, 37.73645], [-122.42087, 37.7366], [-122.42095, 37.73674], [-122.42099, 37.73696], [-122.42098, 37.7372], [-122.42092, 37.73741], [-122.42081, 37.7376], [-122.42067, 37.73775], [-122.42047, 37.73793], [-122.42024, 37.73806], [-122.42, 37.73814], [-122.4198, 37.73817], [-122.41958, 37.73816], [-122.41936, 37.7381], [-122.41921, 37.73802], [-122.4191, 37.73794], [-122.419, 37.73783], [-122.41894, 37.73771], [-122.41889, 37.73752], [-122.41889, 37.73737], [-122.41891, 37.73722], [-122.41896, 37.73705], [-122.41906, 37.73686], [-122.41915, 37.73672], [-122.41929, 37.73658], [-122.41945, 37.73645], [-122.4196, 37.73637], [-122.41976, 37.73631], [-122.41991, 37.73627], [-122.42011, 37.73625]]]} | Open Access 1 | 16968 | Holly Park | 20045 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 7.522 | Holly Park | 0 | Local Park 2 | 4 | |
9793 | 9793 | 9792 | {"type": "Polygon", "coordinates": [[[-122.44931, 37.74305], [-122.4467, 37.74321], [-122.44619, 37.74395], [-122.44637, 37.74471], [-122.44708, 37.74561], [-122.44714, 37.74575], [-122.44677, 37.74543], [-122.4461, 37.74456], [-122.44591, 37.74366], [-122.44546, 37.74339], [-122.44405, 37.74291], [-122.44353, 37.74306], [-122.44257, 37.74365], [-122.44228, 37.74399], [-122.44188, 37.74361], [-122.44148, 37.74247], [-122.44072, 37.74197], [-122.44095, 37.74149], [-122.44065, 37.74117], [-122.43992, 37.74079], [-122.44007, 37.74035], [-122.43975, 37.74036], [-122.43982, 37.74031], [-122.43986, 37.74025], [-122.43988, 37.74018], [-122.43987, 37.7401], [-122.44016, 37.74008], [-122.44006, 37.73881], [-122.4397, 37.73883], [-122.43969, 37.73878], [-122.4398, 37.73876], [-122.43993, 37.73871], [-122.44009, 37.73859], [-122.44016, 37.7385], [-122.44023, 37.73837], [-122.44028, 37.73825], [-122.44029, 37.73816], [-122.44028, 37.73804], [-122.44024, 37.73793], [-122.44, 37.73765], [-122.43991, 37.73748], [-122.43987, 37.7373], [-122.4399, 37.73707], [-122.43976, 37.73706], [-122.43981, 37.73558], [-122.43989, 37.73521], [-122.44001, 37.73495], [-122.44064, 37.7351], [-122.44068, 37.73514], [-122.44102, 37.73567], [-122.44134, 37.7359], [-122.44181, 37.73605], [-122.44182, 37.73613], [-122.4418, 37.73622], [-122.44158, 37.73651], [-122.4415, 37.7367], [-122.44146, 37.73685], [-122.44162, 37.73687], [-122.44173, 37.73662], [-122.44242, 37.73661], [-122.44242, 37.73608], [-122.44199, 37.73608], [-122.44314, 37.73575], [-122.44328, 37.73573], [-122.44349, 37.73575], [-122.44363, 37.73582], [-122.44376, 37.73592], [-122.44376, 37.73619], [-122.44371, 37.73634], [-122.4425, 37.73708], [-122.44238, 37.73722], [-122.44229, 37.73739], [-122.44226, 37.73754], [-122.44228, 37.7377], [-122.44234, 37.73792], [-122.4425, 37.73832], [-122.44248, 37.73861], [-122.4424, 37.73904], [-122.44234, 37.73924], [-122.44235, 37.73938], [-122.4424, 37.73951], [-122.44255, 37.7397], [-122.4427, 37.73982], [-122.44287, 37.7399], [-122.4435, 37.74004], [-122.44376, 37.74016], [-122.44398, 37.74032], [-122.44419, 37.74059], [-122.44431, 37.7407], [-122.44447, 37.74082], [-122.44463, 37.7409], [-122.44493, 37.741], [-122.44557, 37.74109], [-122.44568, 37.74113], [-122.4458, 37.7412], [-122.44592, 37.74132], [-122.44599, 37.74146], [-122.44602, 37.74155], [-122.44606, 37.74196], [-122.44612, 37.74215], [-122.4462, 37.74226], [-122.44631, 37.74238], [-122.44655, 37.74253], [-122.44681, 37.74263], [-122.44709, 37.74269], [-122.44842, 37.74282], [-122.44844, 37.74294], [-122.44863, 37.74295], [-122.44863, 37.74284], [-122.44885, 37.74287], [-122.44913, 37.74296], [-122.44931, 37.74305]]]} | Open Access 1 | 16695 | Glen Canyon Park | 30708 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 70.267 | Glen Canyon Park | 0 | Local Park 2 | 4 | |
9670 | 9670 | 9669 | {"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 | 16316 | Carl Larsen Park | 16853 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 6.585 | Carl Larsen Park | 0 | Local Park 2 | 4 | |
9666 | 9666 | 9665 | {"type": "Polygon", "coordinates": [[[-122.42113, 37.73994], [-122.42098, 37.74018], [-122.42082, 37.74011], [-122.42098, 37.73987], [-122.42113, 37.73994]]]} | Open Access 1 | 16298 | Good Prospect Community Garden | 19402 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.114 | Good Prospect Community Garden | 0 | Local Park 2 | 4 | |
9665 | 9665 | 9664 | {"type": "Polygon", "coordinates": [[[-122.48495, 37.73879], [-122.48305, 37.73888], [-122.48298, 37.73792], [-122.48286, 37.73791], [-122.4828, 37.73713], [-122.48482, 37.73704], [-122.48495, 37.73879]]]} | Open Access 1 | 16296 | Parkside Square | 23452 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 8.31 | Parkside Square | 0 | Local Park 2 | 4 | |
9523 | 9523 | 9522 | {"type": "Polygon", "coordinates": [[[-122.41826, 37.74659], [-122.41791, 37.74603], [-122.41793, 37.74602], [-122.4182, 37.74613], [-122.41826, 37.74659]]]} | Open Access 1 | 15959 | Coso & Precita Mini Park | 17670 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.161 | Coso & Precita MP | 0 | Local Park 2 | 4 | |
9522 | 9522 | 9521 | {"type": "Polygon", "coordinates": [[[-122.41296, 37.79709], [-122.41291, 37.7971], [-122.41288, 37.797], [-122.41284, 37.797], [-122.41282, 37.79693], [-122.41292, 37.79692], [-122.41296, 37.79709]]]} | Open Access 1 | 15958 | Broadway Tunnel east Mini Park | 16410 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.033 | Broadway Tunnel east MP | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);