superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
238 rows where ACCESS_TYP = 1, MNG_AGENCY = 21 and MNG_AG_TYP = 2 sorted by YR_EST
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 238 ✖
MNG_AGENCY 1
- San Francisco, City and County of · 238 ✖
ACCESS_TYP 1
- Open Access · 238 ✖
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
100 | 100 | 99 | {"type": "Polygon", "coordinates": [[[-122.47273, 37.75508], [-122.47256, 37.75525], [-122.47257, 37.75529], [-122.47226, 37.75545], [-122.47219, 37.75536], [-122.47216, 37.75526], [-122.47213, 37.75504], [-122.47212, 37.75467], [-122.47216, 37.75465], [-122.4722, 37.75466], [-122.47236, 37.75482], [-122.47273, 37.75508]]]} | Open Access 1 | Grand View Pk. Open Space | 19427 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.642 | Grand View Pk. OS | ||
110 | 110 | 109 | {"type": "Polygon", "coordinates": [[[-122.47017, 37.74701], [-122.46995, 37.74702], [-122.46993, 37.74705], [-122.46994, 37.74711], [-122.46989, 37.74716], [-122.46955, 37.74717], [-122.46952, 37.74707], [-122.46946, 37.74704], [-122.46939, 37.74704], [-122.46935, 37.74706], [-122.46933, 37.74712], [-122.46935, 37.74718], [-122.46892, 37.7472], [-122.46888, 37.74678], [-122.46845, 37.74672], [-122.46709, 37.74679], [-122.46707, 37.74656], [-122.46717, 37.74654], [-122.46717, 37.74647], [-122.46742, 37.74645], [-122.46742, 37.74641], [-122.46739, 37.74639], [-122.46739, 37.74612], [-122.46761, 37.74618], [-122.46795, 37.74616], [-122.46802, 37.74609], [-122.46892, 37.74615], [-122.46962, 37.74611], [-122.46966, 37.74667], [-122.47015, 37.74665], [-122.47017, 37.74701]]]} | Open Access 1 | Hawk Hill Open Space | 19745 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 4.845 | Hawk Hill OS | ||
465 | 465 | 464 | {"type": "Polygon", "coordinates": [[[-122.39224, 37.7649], [-122.39224, 37.7649], [-122.39054, 37.76501], [-122.39057, 37.76489], [-122.39068, 37.7646], [-122.3907, 37.76448], [-122.39068, 37.76432], [-122.39218, 37.76423], [-122.39224, 37.7649]]]} | Open Access 1 | Mariposa Park | https://missionbayparks.com/mariposa-park/ | 33504 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 2.58 | Mariposa Park | |
473 | 473 | 472 | {"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 | Kids' Park | https://missionbayparks.com/childrens-park/ | 33505 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.121 | Kids' Park | |
482 | 482 | 481 | {"type": "Polygon", "coordinates": [[[-122.42215, 37.74582], [-122.42193, 37.74583], [-122.42211, 37.74534], [-122.42211, 37.74534], [-122.42215, 37.74582]]]} | Open Access 1 | San Jose Guerrero Park | https://groundplaysf.org/projects/san-jose-guerrero-park/ | 33506 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.126 | San Jose Guerrero Park | |
700 | 700 | 699 | {"type": "Polygon", "coordinates": [[[-122.41343, 37.75828], [-122.41259, 37.75833], [-122.41255, 37.75792], [-122.41297, 37.75789], [-122.413, 37.7581], [-122.41341, 37.75807], [-122.41343, 37.75828]]]} | Open Access 1 | Mission Recreation Center | http://sfrecpark.org/destination/mission-rec-center/ | 30902 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.633 | Mission Rec. Ctr. | |
722 | 722 | 721 | {"type": "Polygon", "coordinates": [[[-122.39604, 37.71764], [-122.39553, 37.71819], [-122.39529, 37.71804], [-122.39582, 37.71752], [-122.39604, 37.71764]]]} | Open Access 1 | Le Conte Mini Park | 21123 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.474 | Le Conte MP | ||
803 | 803 | 802 | {"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 | Naples Green | https://groundplaysf.org/projects/naples-green/ | 33554 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.132 | Naples Green | |
984 | 984 | 983 | {"type": "Polygon", "coordinates": [[[-122.42725, 37.71489], [-122.42703, 37.7156], [-122.42711, 37.71564], [-122.42656, 37.71707], [-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.42506, 37.71688], [-122.42291, 37.71824], [-122.42325, 37.71871], [-122.42334, 37.71887], [-122.42337, 37.719], [-122.42338, 37.71914], [-122.42336, 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.71997], [-122.42482, 37.72016], [-122.42532, 37.72032], [-122.42535, 37.72029], [-122.42553, 37.72036], [-122.42437, 37.7219], [-122.42519, 37.72232], [-122.4248, 37.72283], [-122.42481, 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.72342], [-122.41846, 37.72367], [-122.41796, 37.72247], [-122.41697, 37.72272], [-122.41663, 37.72195], [-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.71681], [-122.40832, 37.71687], [-122.40799, 37.71678], [-122.40813, 37.71645], [-122.40845, 37.71654], [-122.40854, 37.71635], [-122.40934, 37.71657], [-122.40939, 37.71651], [-122.40971, 37.71659], [-122.4097, 37.71666], [-122.40984, 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.41317, 37.71646], [-122.41318, 37.71631], [-122.41366, 37.7163], [-122.41404, 37.71619], [-122.41405, 37.71596], [-122.41434, 37.71529], [-122.41547, 37.71559], [-122.41547, 37.71438], [-122.41544, 37.71436], [-122.41566, 37.71385], [-122.41531, 37.71374], [-122.41584, 37.71252], [-122.42175, 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.71438], [-122.42725, 37.71489]], [[-122.41279, 37.71696], [-122.4128, 37.71699], [-122.41319, 37.71698], [-122.41318, 37.71659], [-122.41285, 37.71669], [-122.41257, 37.71675], [-122.41236, 37.71683], [-122.41279, 37.71696]]]} | Open Access 1 | McLaren Park | http://sfrecpark.org/destination/john-mclaren-park/ | 10942 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 333.496 | McLaren Park | |
1099 | 1099 | 1098 | {"type": "Polygon", "coordinates": [[[-122.44734, 37.70991], [-122.44625, 37.71028], [-122.44596, 37.70975], [-122.44705, 37.70937], [-122.44734, 37.70991]]]} | Open Access 1 | Alice Chalmers Playground | 15359 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.678 | Alice Chalmers Playground | ||
1139 | 1139 | 1138 | {"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 | Alioto Mini Park | 15366 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.161 | Alioto MP | ||
1262 | 1262 | 1261 | {"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 | Allyne Park | 15385 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.751 | Allyne Park | ||
1367 | 1367 | 1366 | {"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 | 24th & York Mini Park | 15185 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.119 | 24th & York MP | ||
1376 | 1376 | 1375 | {"type": "Polygon", "coordinates": [[[-122.44016, 37.74009], [-122.43987, 37.7401], [-122.43978, 37.73989], [-122.43976, 37.7398], [-122.43976, 37.73972], [-122.43982, 37.73946], [-122.43984, 37.73932], [-122.43982, 37.73917], [-122.43978, 37.73898], [-122.44007, 37.73898], [-122.44016, 37.74009]]]} | Open Access 1 | 298 Berkeley Way Open Space | 15190 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.83 | 298 Berkeley Way OS | ||
1387 | 1387 | 1386 | {"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.78187], [-122.46824, 37.78181], [-122.46819, 37.7818], [-122.46818, 37.78172], [-122.46796, 37.78173], [-122.46798, 37.78197], [-122.46819, 37.78197], [-122.4682, 37.78188]]]} | Open Access 1 | 10th Ave & Clement Mini Park | 15169 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.689 | 10th Ave & Clement MP | ||
1389 | 1389 | 1388 | {"type": "Polygon", "coordinates": [[[-122.47276, 37.75963], [-122.47242, 37.75965], [-122.47242, 37.75992], [-122.47229, 37.75993], [-122.47226, 37.75966], [-122.47186, 37.75967], [-122.47184, 37.75949], [-122.47225, 37.75947], [-122.47223, 37.75917], [-122.47237, 37.75919], [-122.47241, 37.75955], [-122.47275, 37.75954], [-122.47276, 37.75963]]]} | Open Access 1 | 15th Avenue Steps | 15174 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.525 | 15th Avenue Steps | ||
1409 | 1409 | 1408 | {"type": "MultiPolygon", "coordinates": [[[[-122.38471, 37.73094], [-122.38443, 37.73124], [-122.38438, 37.73135], [-122.38425, 37.73143], [-122.38424, 37.73146], [-122.38417, 37.73151], [-122.38412, 37.73152], [-122.38406, 37.73146], [-122.38407, 37.73144], [-122.38396, 37.73132], [-122.38366, 37.73149], [-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.38341, 37.73076], [-122.38352, 37.73068], [-122.38354, 37.73064], [-122.38352, 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 | Adam Rogers Park | 15256 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 2.813 | Adam Rogers Park | ||
1414 | 1414 | 1413 | {"type": "Polygon", "coordinates": [[[-122.38674, 37.76527], [-122.38641, 37.76569], [-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.7653], [-122.38647, 37.76528], [-122.38646, 37.76523], [-122.38674, 37.76527]]]} | Open Access 1 | Agua Vista Park | 15295 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.47 | Agua Vista Park | ||
1460 | 1460 | 1459 | {"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 | Alta Plaza | 15419 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 11.904 | Alta Plaza | ||
1502 | 1502 | 1501 | {"type": "MultiPolygon", "coordinates": [[[[-122.45856, 37.77926], [-122.45682, 37.77948], [-122.45662, 37.77952], [-122.45657, 37.77952], [-122.45653, 37.77948], [-122.45628, 37.77823], [-122.45689, 37.77815], [-122.45692, 37.7782], [-122.45697, 37.77824], [-122.4571, 37.77827], [-122.45847, 37.7781], [-122.45856, 37.77926]]], [[[-122.45804, 37.77801], [-122.45765, 37.77806], [-122.45759, 37.77775], [-122.45798, 37.7777], [-122.45804, 37.77801]]]]} | Open Access 1 | Angelo J Rossi Playground | 15497 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 6.473 | Angelo J Rossi Playground |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);