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 SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
7979 | 7979 | 7978 | {"type": "Polygon", "coordinates": [[[-122.46853, 37.78203], [-122.4677, 37.78207], [-122.46767, 37.78166], [-122.4685, 37.78162], [-122.46853, 37.78203]], [[-122.4682, 37.78188], [-122.46824, 37.78188], [-122.46824, 37.78181], [-122.46819, 37.7818], [-122.46818, 37.78172], [-122.46796, 37.78173], [-122.46798, 37.78197], [-122.4682, 37.78197], [-122.4682, 37.78188]]]} | Open Access 1 | 15960 | 10th Ave & Clement Mini Park | 15169 | 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.684 | 10th Ave & Clement MP | 0 | Local Park 2 | 4 | |
6891 | 6891 | 6890 | {"type": "Polygon", "coordinates": [[[-122.40867, 37.7532], [-122.4085, 37.75321], [-122.40848, 37.75292], [-122.40865, 37.75291], [-122.40867, 37.7532]]]} | Open Access 1 | 5720 | 24th & York Mini Park | 15185 | 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.119 | 24th & York MP | 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 | |
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 | |
714 | 714 | 713 | {"type": "Polygon", "coordinates": [[[-122.43637, 37.77699], [-122.43332, 37.77738], [-122.43298, 37.7757], [-122.43603, 37.77532], [-122.43637, 37.77699]]]} | Open Access 1 | 4091 | Alamo Square | 15322 | 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.698 | Alamo Square | 2000 | Local Park 2 | 4 | |
887 | 887 | 886 | {"type": "Polygon", "coordinates": [[[-122.41836, 37.75902], [-122.4181, 37.75904], [-122.41808, 37.75878], [-122.41833, 37.75876], [-122.41836, 37.75902]]]} | Open Access 1 | 5743 | Alioto Mini Park | 15366 | 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 | Alioto MP | 0 | Local Park 2 | 4 | |
7244 | 7244 | 7243 | {"type": "Polygon", "coordinates": [[[-122.42798, 37.79764], [-122.42731, 37.79773], [-122.42722, 37.79728], [-122.42789, 37.79719], [-122.42798, 37.79764]]]} | Open Access 1 | 6447 | Allyne Park | 15385 | 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.752 | Allyne Park | 0 | Local Park 2 | 4 | |
1722 | 1722 | 1721 | {"type": "Polygon", "coordinates": [[[-122.43935, 37.79177], [-122.4363, 37.79215], [-122.43599, 37.79058], [-122.43904, 37.79019], [-122.43935, 37.79177]]]} | Open Access 1 | 14881 | Alta Plaza | 15419 | 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 | 11.905 | Alta Plaza | 0 | Local Park 2 | 4 | |
2124 | 2124 | 2123 | {"type": "Polygon", "coordinates": [[[-122.39829, 37.75743], [-122.39812, 37.75744], [-122.3981, 37.75726], [-122.39827, 37.75725], [-122.39829, 37.75743]]]} | Open Access 1 | 15934 | Arkansas Friendship Garden | 15586 | 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.075 | Arkansas Friendship Garden | 0 | Local Park 2 | 4 | |
9497 | 9497 | 9496 | {"type": "Polygon", "coordinates": [[[-122.42661, 37.73695], [-122.42617, 37.73724], [-122.42612, 37.73719], [-122.42652, 37.73686], [-122.42661, 37.73695]]]} | Open Access 1 | 15906 | Arlington Community Garden | 15587 | 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.129 | Arlington Community Garden | 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 | |
7082 | 7082 | 7081 | {"type": "Polygon", "coordinates": [[[-122.43873, 37.78243], [-122.43853, 37.78246], [-122.4385, 37.78234], [-122.43871, 37.78232], [-122.43873, 37.78243]]]} | Open Access 1 | 6099 | Beideman/o'farrell Mini Park | 15958 | 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.059 | Beideman/o'farrell MP | 0 | Local Park 2 | 4 | |
2056 | 2056 | 2055 | {"type": "Polygon", "coordinates": [[[-122.41317, 37.74214], [-122.41315, 37.74224], [-122.41294, 37.74222], [-122.41295, 37.74212], [-122.41317, 37.74214]]]} | Open Access 1 | 15690 | Bernal Heights Community Garden | 16025 | 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.056 | Bernal Heights Community Garden | 0 | Local Park 2 | 4 | |
39 | 39 | 38 | {"type": "Polygon", "coordinates": [[[-122.41541, 37.74416], [-122.41424, 37.74386], [-122.4139, 37.74373], [-122.41307, 37.74338], [-122.41292, 37.74333], [-122.41277, 37.74333], [-122.41262, 37.74335], [-122.41236, 37.74347], [-122.41201, 37.74361], [-122.41188, 37.74363], [-122.41171, 37.74361], [-122.41023, 37.74309], [-122.41017, 37.74304], [-122.41012, 37.74297], [-122.4101, 37.74289], [-122.4101, 37.74281], [-122.41018, 37.74269], [-122.41031, 37.74257], [-122.41045, 37.74251], [-122.4106, 37.74249], [-122.41164, 37.74243], [-122.41251, 37.7423], [-122.41265, 37.7423], [-122.41416, 37.74251], [-122.41432, 37.74252], [-122.41446, 37.7425], [-122.41461, 37.74246], [-122.41479, 37.74238], [-122.41501, 37.74225], [-122.41512, 37.74222], [-122.4159, 37.74217], [-122.41629, 37.74208], [-122.41647, 37.74206], [-122.41669, 37.74209], [-122.41682, 37.74216], [-122.41689, 37.74222], [-122.41696, 37.74233], [-122.41699, 37.74242], [-122.41698, 37.74251], [-122.41693, 37.74261], [-122.4167, 37.74279], [-122.41662, 37.74291], [-122.41657, 37.74307], [-122.41659, 37.74328], [-122.41655, 37.74337], [-122.41647, 37.74345], [-122.4161, 37.74363], [-122.41597, 37.74372], [-122.41586, 37.74383], [-122.4158, 37.74393], [-122.41575, 37.74406], [-122.41568, 37.74413], [-122.41556, 37.74418], [-122.41541, 37.74416]], [[-122.41555, 37.74286], [-122.41477, 37.74286], [-122.41477, 37.74327], [-122.41556, 37.74326], [-122.41555, 37.74286]]]} | Open Access 1 | 122 | Bernal Heights Park | 16026 | 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 | 19.35 | Bernal Heights Park | 0 | Local Park 2 | 4 | |
3944 | 3944 | 3943 | {"type": "Polygon", "coordinates": [[[-122.40744, 37.74501], [-122.40737, 37.7452], [-122.40686, 37.74507], [-122.40694, 37.74488], [-122.40744, 37.74501]]]} | Open Access 1 | 5731 | Brewster Cmmunity Garden | 16369 | 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.26 | Brewster Cmmunity Garden | 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 | |
7974 | 7974 | 7973 | {"type": "Polygon", "coordinates": [[[-122.41762, 37.79648], [-122.41725, 37.79653], [-122.41722, 37.79639], [-122.4176, 37.79634], [-122.41762, 37.79648]]]} | Open Access 1 | 15950 | Broadway Tunnel West Mini Park | 16411 | 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.125 | Broadway Tunnel West MP | 0 | Local Park 2 | 4 | |
3160 | 3160 | 3159 | {"type": "Polygon", "coordinates": [[[-122.46792, 37.71714], [-122.46758, 37.71714], [-122.46758, 37.71755], [-122.46724, 37.71756], [-122.46726, 37.71785], [-122.46669, 37.71784], [-122.46667, 37.71757], [-122.46634, 37.71757], [-122.46634, 37.71784], [-122.46613, 37.71785], [-122.46612, 37.71756], [-122.46578, 37.71757], [-122.46578, 37.71695], [-122.46611, 37.71695], [-122.46612, 37.71687], [-122.46792, 37.71687], [-122.46792, 37.71714]]]} | Open Access 1 | 21835 | Brooks Park | 16429 | 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.73 | Brooks Park | 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]);