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 map
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_WEB, LAYER, YR_EST
AGNCY_TYP 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7032 | 7032 | 7031 | {"type": "MultiPolygon", "coordinates": [[[[-122.37444, 37.73233], [-122.37423, 37.73255], [-122.37391, 37.7327], [-122.37367, 37.73284], [-122.37351, 37.73296], [-122.3734, 37.73312], [-122.37285, 37.73361], [-122.37263, 37.73387], [-122.37249, 37.73406], [-122.37234, 37.73415], [-122.3722, 37.73418], [-122.37208, 37.73417], [-122.37192, 37.7341], [-122.37168, 37.73392], [-122.37134, 37.73362], [-122.37103, 37.73337], [-122.37024, 37.73281], [-122.36977, 37.73251], [-122.36999, 37.73227], [-122.3706, 37.73242], [-122.37071, 37.73248], [-122.37079, 37.73258], [-122.37169, 37.7331], [-122.37174, 37.73322], [-122.37179, 37.73326], [-122.37186, 37.73329], [-122.37194, 37.73329], [-122.37203, 37.73328], [-122.3723, 37.73343], [-122.37263, 37.73319], [-122.37295, 37.7331], [-122.37325, 37.73272], [-122.37405, 37.73228], [-122.37416, 37.73217], [-122.37444, 37.73233]], [[-122.37211, 37.73352], [-122.37219, 37.73343], [-122.37205, 37.73334], [-122.37196, 37.73344], [-122.37211, 37.73352]]], [[[-122.37676, 37.73425], [-122.37671, 37.73431], [-122.3767, 37.73438], [-122.37652, 37.73437], [-122.37643, 37.73438], [-122.37588, 37.73505], [-122.37583, 37.73509], [-122.37573, 37.73512], [-122.3757, 37.73518], [-122.37557, 37.73524], [-122.3755, 37.73533], [-122.37536, 37.7354], [-122.37536, 37.73542], [-122.37517, 37.73534], [-122.37517, 37.73533], [-122.37507, 37.73525], [-122.37452, 37.73494], [-122.37492, 37.73449], [-122.37506, 37.73457], [-122.37501, 37.73467], [-122.37501, 37.73469], [-122.3751, 37.73463], [-122.37512, 37.73459], [-122.37514, 37.73456], [-122.37513, 37.73452], [-122.37504, 37.73445], [-122.37498, 37.73443], [-122.37494, 37.73442], [-122.37491, 37.73443], [-122.37489, 37.73442], [-122.37491, 37.73436], [-122.37486, 37.73418], [-122.37452, 37.73399], [-122.37472, 37.73377], [-122.37486, 37.73385], [-122.37506, 37.73363], [-122.37521, 37.73372], [-122.37526, 37.73356], [-122.37558, 37.73365], [-122.37598, 37.7332], [-122.3767, 37.73361], [-122.37668, 37.73366], [-122.37673, 37.73393], [-122.37643, 37.73384], [-122.37642, 37.73385], [-122.37645, 37.73392], [-122.37632, 37.73407], [-122.37668, 37.73423], [-122.37676, 37.73421], [-122.37676, 37.73425]]]]} | Open Access 1 | 6002 | India Basin Shoreline Park | 20197 | 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 | 12.79 | India Basin Shoreline Park | 0 | Local Park 2 | 4 | |
1919 | 1919 | 1918 | {"type": "MultiPolygon", "coordinates": [[[[-122.38471, 37.73094], [-122.38443, 37.73124], [-122.38438, 37.73135], [-122.38424, 37.73144], [-122.38424, 37.73146], [-122.38417, 37.73151], [-122.38412, 37.73152], [-122.38406, 37.73146], [-122.38408, 37.73144], [-122.38396, 37.73131], [-122.38365, 37.7315], [-122.38384, 37.7317], [-122.38371, 37.73178], [-122.38341, 37.73147], [-122.38319, 37.73141], [-122.38328, 37.73126], [-122.38329, 37.73111], [-122.38319, 37.73087], [-122.38332, 37.73074], [-122.38337, 37.73076], [-122.38341, 37.73076], [-122.38352, 37.73068], [-122.38354, 37.73064], [-122.38353, 37.7306], [-122.38345, 37.73054], [-122.38342, 37.73053], [-122.38361, 37.73031], [-122.38471, 37.73094]]], [[[-122.38538, 37.73098], [-122.38518, 37.7312], [-122.38511, 37.73116], [-122.38531, 37.73094], [-122.38538, 37.73098]]]]} | Open Access 1 | 5932 | Adam Rogers Park | 15256 | 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.806 | Adam Rogers 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 | |
7292 | 7292 | 7291 | {"type": "MultiPolygon", "coordinates": [[[[-122.39678, 37.7962], [-122.39676, 37.79625], [-122.39672, 37.79629], [-122.39642, 37.79637], [-122.39569, 37.79646], [-122.39559, 37.79643], [-122.39549, 37.79636], [-122.39539, 37.79625], [-122.39511, 37.79605], [-122.39507, 37.79597], [-122.39504, 37.79575], [-122.39664, 37.79555], [-122.39678, 37.7962]]], [[[-122.39801, 37.79614], [-122.39756, 37.7962], [-122.39752, 37.79607], [-122.39728, 37.79599], [-122.39703, 37.79601], [-122.39695, 37.79553], [-122.39786, 37.79541], [-122.39801, 37.79614]]]]} | Open Access 1 | 6571 | Ferry Park | 18887 | 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 | 4.177 | Ferry Park | 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 | |
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 | |
5453 | 5453 | 5452 | {"type": "MultiPolygon", "coordinates": [[[[-122.42159, 37.80398], [-122.42017, 37.80418], [-122.42001, 37.80338], [-122.42145, 37.80319], [-122.42159, 37.80398]]], [[[-122.42169, 37.80449], [-122.42028, 37.80468], [-122.42019, 37.80426], [-122.42161, 37.80406], [-122.42169, 37.80449]]]]} | Open Access 1 | 24971 | Russian Hill Park | 24745 | 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 | 4.324 | Russian Hill Park | 0 | 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 |
6373 | 6373 | 6372 | {"type": "MultiPolygon", "coordinates": [[[[-122.45074, 37.74608], [-122.4507, 37.74612], [-122.45044, 37.74614], [-122.45019, 37.74618], [-122.45, 37.74625], [-122.4494, 37.74656], [-122.44927, 37.74665], [-122.44916, 37.74677], [-122.44903, 37.74697], [-122.44867, 37.74783], [-122.44835, 37.74834], [-122.44773, 37.7494], [-122.44768, 37.74944], [-122.44761, 37.74947], [-122.44754, 37.74946], [-122.44731, 37.74938], [-122.44719, 37.74931], [-122.44658, 37.74886], [-122.44642, 37.74878], [-122.44625, 37.74872], [-122.44611, 37.74869], [-122.4459, 37.74871], [-122.4457, 37.7488], [-122.44561, 37.74888], [-122.44558, 37.74901], [-122.4456, 37.74914], [-122.44568, 37.74926], [-122.44579, 37.74935], [-122.44659, 37.74984], [-122.44678, 37.74994], [-122.44708, 37.75005], [-122.44793, 37.7503], [-122.44811, 37.7503], [-122.4482, 37.75027], [-122.44828, 37.75022], [-122.44897, 37.74931], [-122.44909, 37.74922], [-122.44924, 37.74915], [-122.44933, 37.74914], [-122.44942, 37.74916], [-122.44948, 37.74919], [-122.44956, 37.74928], [-122.4496, 37.74935], [-122.44962, 37.74945], [-122.44963, 37.74972], [-122.44961, 37.74982], [-122.44938, 37.75036], [-122.4493, 37.75047], [-122.44918, 37.75058], [-122.44883, 37.75078], [-122.44867, 37.75082], [-122.44848, 37.75083], [-122.44796, 37.75076], [-122.44783, 37.75077], [-122.44772, 37.75081], [-122.4476, 37.75088], [-122.44752, 37.75095], [-122.44706, 37.75146], [-122.44698, 37.75161], [-122.44697, 37.75175], [-122.447, 37.75187], [-122.44706, 37.75197], [-122.44733, 37.75228], [-122.44736, 37.75236], [-122.44738, 37.75247], [-122.44735, 37.7526], [-122.44729, 37.75272], [-122.44672, 37.75322], [-122.44667, 37.75335], [-122.44666, 37.7535], [-122.44671, 37.75363], [-122.44684, 37.7538], [-122.44703, 37.75398], [-122.44704, 37.75406], [-122.44701, 37.7541], [-122.44671, 37.75427], [-122.44638, 37.75434], [-122.44631, 37.75448], [-122.44622, 37.7545], [-122.44621, 37.75456], [-122.44626, 37.75463], [-122.44632, 37.75476], [-122.44643, 37.75485], [-122.44646, 37.7549], [-122.44654, 37.75496], [-122.44663, 37.75499], [-122.44671, 37.75499], [-122.4468, 37.75496], [-122.44685, 37.75497], [-122.44716, 37.75508], [-122.44726, 37.7551], [-122.44734, 37.75511], [-122.44748, 37.75508], [-122.44751, 37.75502], [-122.44751, 37.75497], [-122.44746, 37.7549], [-122.44747, 37.75487], [-122.44729, 37.7546], [-122.44713, 37.75424], [-122.44715, 37.75419], [-122.4472, 37.75416], [-122.44727, 37.75418], [-122.44731, 37.75421], [-122.44765, 37.75485], [-122.44791, 37.75561], [-122.4479, 37.75566], [-122.4478, 37.75577], [-122.4477, 37.75582], [-122.44758, 37.75579], [-122.44698, 37.75536], [-122.44684, 37.75531], [-122.44657, 37.75529], [-122.44606, 37.75545], [-122.4458, 37.75545], [-122.44534, 37.75558], [-122.44522, 37.75566], [-122.44517, 37.75574], [-122.44518, 37.75585], [-122.44524, 37.75595], [-122.44535, 37.75601], [-122.4455, 37.75602], [-122.44595, 37.75588], [-122.44608, 37.75587], [-122.4462, 37.75589], [-122.44634, 37.75598], [-122.44637, 37.75607], [-122.44654, 37.75621], [-122.44672, 37.75633], [-122.44678, 37.75639], [-122.44671, 37.75646], [-122.44608, 37.75637], [-122.44589, 37.75637], [-122.44568, 37.75639], [-122.44521, 37.75655], [-122.44508, 37.75655], [-122.44494, 37.75654], [-122.44477, 37.7565], [-122.44464, 37.75643], [-122.4445, 37.75628], [-122.44439, 37.75613], [-122.4443, 37.75591], [-122.44427, 37.75569], [-122.44431, 37.75561], [-122.44439, 37.75554], [-122.44451, 37.75549], [-122.44462, 37.75542], [-122.44474, 37.7553], [-122.44484, 37.75516], [-122.44491, 37.75502], [-122.44494, 37.75486], [-122.44495, 37.75458], [-122.44502, 37.7544], [-122.4451, 37.75438], [-122.44518, 37.75424], [-122.44568, 37.75377], [-122.44575, 37.75367], [-122.44584, 37.75343], [-122.44592, 37.75327], [-122.44607, 37.75306], [-122.44619, 37.75294], [-122.44655, 37.75268], [-122.44664, 37.75257], [-122.44669, 37.75246], [-122.44669, 37.75232], [-122.44665, 37.75223], [-122.44634, 37.75169], [-122.44631, 37.75155], [-122.44633, 37.75142], [-122.44673, 37.75149], [-122.44689, 37.7512], [-122.44717, 37.75089], [-122.44723, 37.75056], [-122.44735, 37.75023], [-122.44729, 37.7502], [-122.44694, 37.75013], [-122.44675, 37.75005], [-122.44559, 37.74938], [-122.44545, 37.74924], [-122.4454, 37.74914], [-122.44539, 37.74897], [-122.44542, 37.74886], [-122.44545, 37.7488], [-122.44552, 37.74871], [-122.44559, 37.74866], [-122.44569, 37.74861], [-122.4458, 37.74857], [-122.44607, 37.74854], [-122.44639, 37.74858], [-122.44676, 37.74877], [-122.44694, 37.74888], [-122.4474, 37.74923], [-122.44759, 37.74931], [-122.44798, 37.74863], [-122.44807, 37.74863], [-122.44853, 37.74665], [-122.4486, 37.74665], [-122.44868, 37.74663], [-122.44875, 37.74658], [-122.44879, 37.7465], [-122.44903, 37.74636], [-122.44927, 37.74626], [-122.44956, 37.74617], [-122.44982, 37.74611], [-122.45065, 37.74601], [-122.45072, 37.74603], [-122.45074, 37.74608]]], [[[-122.45001, 37.7503], [-122.44952, 37.75121], [-122.4494, 37.75115], [-122.44928, 37.75132], [-122.44923, 37.75143], [-122.44912, 37.75199], [-122.44845, 37.75229], [-122.4482, 37.75254], [-122.4482, 37.7528], [-122.4486, 37.75327], [-122.44894, 37.75382], [-122.44893, 37.75402], [-122.44862, 37.75412], [-122.44842, 37.75423], [-122.44829, 37.75436], [-122.44821, 37.75452], [-122.44819, 37.7547], [-122.44822, 37.75487], [-122.4483, 37.755], [-122.44849, 37.75522], [-122.44921, 37.75572], [-122.44944, 37.75561], [-122.44951, 37.75606], [-122.44947, 37.75621], [-122.44952, 37.75637], [-122.44968, 37.7565], [-122.44979, 37.75654], [-122.44996, 37.75663], [-122.44998, 37.75668], [-122.44717, 37.75683], [-122.44704, 37.75658], [-122.44685, 37.7563], [-122.44639, 37.75589], [-122.44622, 37.75579], [-122.44599, 37.75578], [-122.44544, 37.75593], [-122.4453, 37.75584], [-122.44536, 37.75567], [-122.44589, 37.75553], [-122.44605, 37.75553], [-122.44654, 37.7554], [-122.44687, 37.75543], [-122.4475, 37.75586], [-122.44773, 37.75592], [-122.44787, 37.75588], [-122.44796, 37.75579], [-122.44801, 37.75565], [-122.44794, 37.75534], [-122.44774, 37.75479], [-122.4475, 37.75433], [-122.4475, 37.75393], [-122.44754, 37.75388], [-122.44763, 37.75383], [-122.44791, 37.75377], [-122.44805, 37.75371], [-122.44816, 37.75358], [-122.44819, 37.75351], [-122.4482, 37.75341], [-122.44815, 37.75327], [-122.44794, 37.75301], [-122.44771, 37.75259], [-122.44768, 37.75251], [-122.44769, 37.75243], [-122.44777, 37.75233], [-122.4483, 37.75202], [-122.44843, 37.75189], [-122.4485, 37.75174], [-122.44854, 37.7515], [-122.44858, 37.75135], [-122.44871, 37.75104], [-122.44885, 37.75088], [-122.44925, 37.75066], [-122.44937, 37.75055], [-122.44946, 37.75045], [-122.44955, 37.7503], [-122.44975, 37.74982], [-122.44976, 37.7497], [-122.44974, 37.74944], [-122.4497, 37.74931], [-122.44964, 37.74922], [-122.44955, 37.74914], [-122.44942, 37.74907], [-122.44934, 37.74906], [-122.44923, 37.74907], [-122.44905, 37.74915], [-122.4489, 37.74926], [-122.4482, 37.75016], [-122.44808, 37.75022], [-122.44795, 37.75022], [-122.44749, 37.75003], [-122.44735, 37.74999], [-122.44705, 37.74996], [-122.44685, 37.74988], [-122.44581, 37.74924], [-122.44575, 37.74917], [-122.4457, 37.74908], [-122.44569, 37.74897], [-122.44572, 37.74891], [-122.44585, 37.74883], [-122.44598, 37.74879], [-122.4461, 37.74878], [-122.44626, 37.74881], [-122.44651, 37.74893], [-122.44718, 37.74941], [-122.44734, 37.74949], [-122.44751, 37.74956], [-122.44764, 37.74957], [-122.44776, 37.74955], [-122.44788, 37.74951], [-122.44798, 37.74943], [-122.44767, 37.74994], [-122.44799, 37.75008], [-122.44806, 37.75006], [-122.44819, 37.74992], [-122.44863, 37.74932], [-122.44875, 37.7492], [-122.4489, 37.74906], [-122.44906, 37.74897], [-122.4492, 37.74892], [-122.44936, 37.74891], [-122.44952, 37.74894], [-122.44967, 37.74902], [-122.44977, 37.74911], [-122.44986, 37.74922], [-122.44992, 37.74935], [-122.44998, 37.74967], [-122.45001, 37.7503]]], [[[-122.44769, 37.75275], [-122.44788, 37.7531], [-122.44808, 37.75333], [-122.4481, 37.75342], [-122.44808, 37.75353], [-122.448, 37.75362], [-122.44791, 37.75368], [-122.44758, 37.75375], [-122.44748, 37.7538], [-122.44735, 37.75392], [-122.4473, 37.75395], [-122.44722, 37.75396], [-122.44716, 37.75395], [-122.44697, 37.75379], [-122.44681, 37.75359], [-122.44678, 37.75347], [-122.44679, 37.75334], [-122.44684, 37.75326], [-122.44733, 37.75282], [-122.44744, 37.75269], [-122.44751, 37.75267], [-122.44758, 37.75267], [-122.44764, 37.7527], [-122.44769, 37.75275]]], [[[-122.44859, 37.75101], [-122.44855, 37.75115], [-122.44845, 37.7514], [-122.44839, 37.75176], [-122.44832, 37.75187], [-122.44822, 37.75196], [-122.44771, 37.75226], [-122.44763, 37.7523], [-122.44756, 37.75231], [-122.4475, 37.75229], [-122.44746, 37.75226], [-122.44713, 37.75188], [-122.4471, 37.75179], [-122.44709, 37.75171], [-122.4471, 37.75164], [-122.44713, 37.75155], [-122.44762, 37.75099], [-122.44773, 37.7509], [-122.44782, 37.75086], [-122.44792, 37.75085], [-122.44818, 37.75087], [-122.44849, 37.75091], [-122.44856, 37.75095], [-122.44859, 37.75101]]]]} | Open Access 1 | 1736 | Twin Peaks Park | 26621 | 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 | 54.551 | Twin Peaks Park | 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 |
5426 | 5426 | 5425 | {"type": "MultiPolygon", "coordinates": [[[[-122.47242, 37.78647], [-122.4723, 37.78697], [-122.47214, 37.78743], [-122.471, 37.78765], [-122.471, 37.78725], [-122.47099, 37.78724], [-122.46639, 37.78816], [-122.4663, 37.78691], [-122.47232, 37.78664], [-122.47231, 37.78644], [-122.47239, 37.78644], [-122.47242, 37.78647]]], [[[-122.4732, 37.78722], [-122.47257, 37.78734], [-122.4727, 37.78693], [-122.47281, 37.78642], [-122.47314, 37.7864], [-122.4732, 37.78722]]]]} | Open Access 1 | 18073 | Mountain Lake Park | 22542 | 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 | 13.741 | Mtn. Lake 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 | |
3950 | 3950 | 3949 | {"type": "Polygon", "coordinates": [[[-122.37598, 37.7332], [-122.37557, 37.73365], [-122.3748, 37.73321], [-122.3752, 37.73276], [-122.37598, 37.7332]]]} | Open Access 1 | 47543 | India Basin Waterfront Park | 31251 | 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.262 | India Basin Waterfront Park | 0 | Local Park 2 | 4 | |
935 | 935 | 934 | {"type": "Polygon", "coordinates": [[[-122.3848, 37.73307], [-122.38477, 37.73311], [-122.38459, 37.73327], [-122.3845, 37.73331], [-122.38444, 37.7333], [-122.38415, 37.73321], [-122.38387, 37.73315], [-122.38363, 37.73314], [-122.3834, 37.73315], [-122.38273, 37.7333], [-122.3826, 37.73335], [-122.38234, 37.73347], [-122.38224, 37.73345], [-122.38213, 37.73334], [-122.3825, 37.73305], [-122.3832, 37.73228], [-122.38385, 37.73254], [-122.38426, 37.73273], [-122.38476, 37.733], [-122.38479, 37.73303], [-122.3848, 37.73307]]]} | Open Access 1 | 5943 | Hilltop Park | 19990 | 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.456 | Hilltop Park | 0 | Local Park 2 | 4 | |
5452 | 5452 | 5451 | {"type": "Polygon", "coordinates": [[[-122.38674, 37.76527], [-122.38641, 37.76568], [-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.76529], [-122.38647, 37.76528], [-122.38646, 37.76523], [-122.38674, 37.76527]]]} | Open Access 1 | 24968 | Agua Vista Park | 15295 | 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.469 | Agua Vista Park | 0 | Local Park 2 | 4 | |
891 | 891 | 890 | {"type": "Polygon", "coordinates": [[[-122.39139, 37.76151], [-122.3907, 37.76155], [-122.3906, 37.76046], [-122.39128, 37.76042], [-122.39131, 37.76095], [-122.39137, 37.76124], [-122.39139, 37.76151]]]} | Open Access 1 | 5752 | Esprit Park | 18718 | 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.814 | Esprit Park | 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 |
6104 | 6104 | 6103 | {"type": "Polygon", "coordinates": [[[-122.3946, 37.78122], [-122.39403, 37.78161], [-122.39339, 37.7821], [-122.39323, 37.78208], [-122.3932, 37.78198], [-122.39385, 37.78147], [-122.39436, 37.78105], [-122.39447, 37.781], [-122.3946, 37.78105], [-122.3946, 37.78122]]]} | Open Access 1 | 1023 | South Park | 25673 | 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.926 | South Park | 0 | Local Park 2 | 4 | |
7868 | 7868 | 7867 | {"type": "Polygon", "coordinates": [[[-122.39569, 37.73564], [-122.39563, 37.73571], [-122.39564, 37.73573], [-122.39537, 37.73603], [-122.39551, 37.73612], [-122.39528, 37.73635], [-122.39467, 37.736], [-122.39488, 37.73577], [-122.3947, 37.73565], [-122.39489, 37.73543], [-122.39476, 37.73535], [-122.39455, 37.73557], [-122.39336, 37.73489], [-122.39356, 37.73467], [-122.39454, 37.73523], [-122.39468, 37.73509], [-122.39569, 37.73564]]]} | Open Access 1 | 5979 | Paluo Phelps Mini Park | 23375 | 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.644 | Paluo Phelps 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]);