units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
240 rows where MNG_AGENCY = 21 sorted by PARK_URL descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, COUNTY, YR_EST, GAP_STS
DES_TP >30
LAYER 3 ✖
- City 238
- County 1
- Special District 1
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 | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11163 | 11163 | 11162 | {"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 | 48006 | Ella Hill Hutch Center | 32433 | 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://www.sfparksalliance.org/our-parks/parks/ella-hill-hutch-center | San Francisco 13 | 2.344 | Ella Hill Hutch Ctr. | 0 | Local Recreation Area 3 | 4 |
15692 | 15692 | 15691 | {"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.78639], [-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 | 17379 | Lincoln Park Golf Course | 33132 | 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://sfrecpark.org/destination/lincoln-park/ | San Francisco 13 | 112.07 | Lincoln Park GC | 1909 | Local Recreation Area 3 | 4 |
880 | 880 | 879 | {"type": "Polygon", "coordinates": [[[-122.41257, 37.78442], [-122.41192, 37.7845], [-122.41199, 37.78487], [-122.41171, 37.78491], [-122.41163, 37.78454], [-122.4118, 37.78451], [-122.41173, 37.78414], [-122.4125, 37.78405], [-122.41257, 37.78442]]]} | Open Access 1 | 6294 | Father Alfred E. Boeddeker Park | 32514 | 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://sfrecpark.org/destination/father-alfred-e-boeddeker-park/ | San Francisco 13 | 0.974 | Father Alfred E. Boeddeker Park | 0 | Local Park 2 | 4 |
1116 | 1116 | 1115 | {"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 | 6560 | Bush & Broderick Mini Park | 33394 | 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://sfrecpark.org/destination/bush-broderick-mini-park/ | San Francisco 13 | 0.182 | Bush & Broderick MP | 0 | Local Park 2 | 4 |
3592 | 3592 | 3591 | {"type": "Polygon", "coordinates": [[[-122.39224, 37.7649], [-122.39054, 37.76501], [-122.39054, 37.76501], [-122.39057, 37.76489], [-122.39068, 37.7646], [-122.3907, 37.76449], [-122.39068, 37.76432], [-122.39218, 37.76423], [-122.39224, 37.7649]]]} | Open Access 1 | 48778 | Mariposa Park | 33504 | 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://missionbayparks.com/mariposa-park/ | San Francisco 13 | 2.58 | Mariposa Park | 0 | Local Park 2 | 4 |
3595 | 3595 | 3594 | {"type": "Polygon", "coordinates": [[[-122.39332, 37.77186], [-122.39223, 37.77272], [-122.39223, 37.77272], [-122.39215, 37.77193], [-122.39332, 37.77186]]]} | Open Access 1 | 48779 | Kids' Park | 33505 | 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://missionbayparks.com/childrens-park/ | San Francisco 13 | 1.121 | Kids' Park | 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 |
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 |
14511 | 14511 | 14510 | {"type": "Polygon", "coordinates": [[[-122.40686, 37.77874], [-122.40669, 37.77888], [-122.40674, 37.77894], [-122.40655, 37.77909], [-122.40582, 37.7785], [-122.40619, 37.77821], [-122.40686, 37.77874]]]} | Open Access 1 | 47169 | South of Market/ Gene Friend Recreation Center | 30858 | 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://www.sfparksalliance.org/our-parks/parks/south-market-gene-friend-recreation-center | San Francisco 13 | 1.019 | South of Market/ Gene Friend Rec. Ctr. | 0 | Local Recreation Area 3 | 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 |
5427 | 5427 | 5426 | {"type": "MultiPolygon", "coordinates": [[[[-122.44577, 37.77293], [-122.44108, 37.77352], [-122.44092, 37.77277], [-122.44562, 37.77218], [-122.44577, 37.77293]]], [[[-122.51084, 37.77123], [-122.51082, 37.77125], [-122.46524, 37.77333], [-122.46492, 37.77336], [-122.45479, 37.77465], [-122.45476, 37.77464], [-122.45474, 37.77462], [-122.45417, 37.77186], [-122.446, 37.7729], [-122.44585, 37.77215], [-122.45402, 37.77111], [-122.454, 37.7709], [-122.45398, 37.77089], [-122.45365, 37.76926], [-122.45362, 37.76924], [-122.45359, 37.76908], [-122.45361, 37.76905], [-122.45324, 37.7672], [-122.45358, 37.76716], [-122.45359, 37.76715], [-122.45351, 37.76675], [-122.45315, 37.76677], [-122.45308, 37.76646], [-122.45319, 37.76644], [-122.45323, 37.76659], [-122.454, 37.76656], [-122.45401, 37.76655], [-122.45397, 37.76634], [-122.45449, 37.76628], [-122.45455, 37.76654], [-122.45478, 37.76653], [-122.45473, 37.76625], [-122.45677, 37.76598], [-122.45701, 37.76598], [-122.45721, 37.76599], [-122.45745, 37.76603], [-122.45764, 37.76608], [-122.45768, 37.76644], [-122.45788, 37.76644], [-122.45859, 37.76637], [-122.46049, 37.76628], [-122.51017, 37.76409], [-122.51021, 37.7641], [-122.51024, 37.76413], [-122.51025, 37.7645], [-122.51017, 37.76568], [-122.51018, 37.76647], [-122.51024, 37.76719], [-122.5103, 37.76771], [-122.51033, 37.76774], [-122.51042, 37.76819], [-122.51042, 37.76835], [-122.51047, 37.7686], [-122.51052, 37.76864], [-122.51063, 37.76917], [-122.51078, 37.77029], [-122.51076, 37.77035], [-122.5107, 37.77037], [-122.51069, 37.77049], [-122.51077, 37.77052], [-122.5108, 37.77056], [-122.51083, 37.77082], [-122.5108, 37.77092], [-122.51084, 37.77123]], [[-122.45534, 37.76755], [-122.45501, 37.76749], [-122.45487, 37.76756], [-122.45487, 37.76808], [-122.45516, 37.76805], [-122.45565, 37.76794], [-122.45563, 37.76789], [-122.45534, 37.76755]], [[-122.4691, 37.7719], [-122.46926, 37.772], [-122.46979, 37.77162], [-122.46885, 37.77083], [-122.46791, 37.77153], [-122.4686, 37.7722], [-122.4691, 37.7719]]]]} | Open Access 1 | 16720 | Golden Gate Park | 10900 | 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/parks-open-spaces/golden-gate-park-guide/ | San Francisco 13 | 1022.15 | Golden Gate Park | 2000 | Local Park 2 | 4 |
7156 | 7156 | 7155 | {"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 | 6253 | Victoria Manalo Draves Park | 27077 | 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/victoria-manalo-draves-park/ | San Francisco 13 | 2.516 | Victoria Manalo Draves Park | 0 | Local Park 2 | 4 |
6720 | 6720 | 6719 | {"type": "Polygon", "coordinates": [[[-122.42865, 37.74269], [-122.42692, 37.74279], [-122.42689, 37.74247], [-122.42706, 37.74246], [-122.42703, 37.74215], [-122.42859, 37.74206], [-122.42865, 37.74269]]]} | Open Access 1 | 5498 | Upper Noe Recreation Center | 30854 | 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/upper-noe-rec-center/ | San Francisco 13 | 2.511 | Upper Noe Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
4090 | 4090 | 4089 | {"type": "Polygon", "coordinates": [[[-122.41577, 37.78497], [-122.41511, 37.78505], [-122.41504, 37.78468], [-122.41569, 37.78459], [-122.41577, 37.78497]]]} | Open Access 1 | 47170 | Tenderloin Recreation Center | 30859 | 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/tenderloin-rec-center-park/ | San Francisco 13 | 0.606 | Tenderloin Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
5058 | 5058 | 5057 | {"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 | 1309 | Sunset Recreation Center | 30853 | 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/sunset-rec-center-park/ | San Francisco 13 | 3.286 | Sunset Rec. Ctr. | 1940 | Local Recreation Area 3 | 4 |
9510 | 9510 | 9509 | {"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 | 15939 | Patricia's Green | 30368 | 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/patricias-green-in-hayes-valley/ | San Francisco 13 | 0.436 | Patricia's Green | 0 | Local Park 2 | 4 |
14539 | 14539 | 14538 | {"type": "Polygon", "coordinates": [[[-122.41088, 37.72963], [-122.40911, 37.7301], [-122.40868, 37.72905], [-122.41045, 37.72859], [-122.41088, 37.72963]]]} | Open Access 1 | 47202 | Palega Recreation Center | 30903 | 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/palega-rec-center/ | San Francisco 13 | 4.966 | Palega Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
10254 | 10254 | 10253 | {"type": "Polygon", "coordinates": [[[-122.41343, 37.75828], [-122.41259, 37.75833], [-122.41255, 37.75792], [-122.41297, 37.75789], [-122.41299, 37.7581], [-122.41341, 37.75807], [-122.41343, 37.75828]]]} | Open Access 1 | 17938 | Mission Recreation Center | 30902 | 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/mission-rec-center/ | San Francisco 13 | 0.632 | Mission Rec. Ctr. | 0 | Local Recreation Area 3 | 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 |
7026 | 7026 | 7025 | {"type": "Polygon", "coordinates": [[[-122.39017, 37.73464], [-122.38977, 37.73509], [-122.38872, 37.73449], [-122.38891, 37.73427], [-122.38877, 37.73418], [-122.38898, 37.73396], [-122.39017, 37.73464]]]} | Open Access 1 | 5967 | Joseph Lee Recreation Center | 30856 | 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/joseph-lee-rec-center/ | San Francisco 13 | 1.855 | Joseph Lee Rec. Ctr. | 0 | Local Recreation Area 3 | 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]);