superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
240 rows where MNG_AGENCY = 21
This data as json, copyable, CSV (advanced)
PARK_URL 17 ✖
- http://sfrecpark.org/destination/bernal-heights-rec-center/ 1
- http://sfrecpark.org/destination/betty-ong-rec-center/ 1
- http://sfrecpark.org/destination/eureka-valley-rec-center/ 1
- http://sfrecpark.org/destination/hamilton-rec-center/ 1
- http://sfrecpark.org/destination/joseph-lee-rec-center/ 1
- http://sfrecpark.org/destination/lake-merced-park/ 1
- http://sfrecpark.org/destination/palega-rec-center/ 1
- http://sfrecpark.org/destination/patricias-green-in-hayes-valley/ 1
- http://sfrecpark.org/destination/sunset-rec-center-park/ 1
- http://sfrecpark.org/destination/tenderloin-rec-center-park/ 1
- http://sfrecpark.org/destination/upper-noe-rec-center/ 1
- http://sfrecpark.org/destination/victoria-manalo-draves-park/ 1
- http://www.sfparksalliance.org/our-parks/parks/south-market-gene-friend-recreation-center 1
- https://sfrecpark.org/destination/bush-broderick-mini-park/ 1
- https://sfrecpark.org/destination/father-alfred-e-boeddeker-park/ 1
- https://sfrecpark.org/destination/lincoln-park/ 1
- https://www.sfparksalliance.org/our-parks/parks/ella-hill-hutch-center 1
ACCESS_TYP 2
- Open Access 202
- Restricted Access 2
MNG_AG_TYP 1
- City Agency 204
MNG_AGENCY 1
- San Francisco, City and County of · 204 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2024 | 2024 | 2023 | {"type": "Polygon", "coordinates": [[[-122.43465, 37.74209], [-122.43433, 37.7421], [-122.4343, 37.74179], [-122.43417, 37.74158], [-122.43411, 37.74157], [-122.43407, 37.74153], [-122.434, 37.7415], [-122.43392, 37.74151], [-122.43382, 37.74159], [-122.43355, 37.74167], [-122.43253, 37.74172], [-122.43239, 37.74168], [-122.43209, 37.74148], [-122.43227, 37.74138], [-122.43249, 37.74131], [-122.43221, 37.74099], [-122.43261, 37.74078], [-122.43282, 37.74088], [-122.43396, 37.74123], [-122.43413, 37.74133], [-122.43427, 37.74146], [-122.43465, 37.74209]]]} | Open Access 1 | Billy Goat Hill | 16115 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3.194 | Billy Goat Hill | ||
2108 | 2108 | 2107 | {"type": "Polygon", "coordinates": [[[-122.41585, 37.74445], [-122.41555, 37.74491], [-122.41512, 37.74474], [-122.4154, 37.74429], [-122.41561, 37.74437], [-122.41563, 37.74436], [-122.41585, 37.74445]]]} | Open Access 1 | Bocana St. Open Space | 16217 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.604 | Bocana St. OS | ||
2133 | 2133 | 2132 | {"type": "Polygon", "coordinates": [[[-122.40755, 37.79404], [-122.40749, 37.79404], [-122.40744, 37.79384], [-122.40727, 37.79386], [-122.40725, 37.79379], [-122.40715, 37.7938], [-122.40711, 37.79364], [-122.40679, 37.79368], [-122.40676, 37.79356], [-122.40689, 37.79353], [-122.40686, 37.79335], [-122.40727, 37.7933], [-122.40731, 37.79345], [-122.40742, 37.79345], [-122.40755, 37.79404]]]} | Open Access 1 | Chinese Playground | 17205 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.62 | Chinese Playground | ||
2176 | 2176 | 2175 | {"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 | Carl Larsen Park | 16853 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 6.583 | Carl Larsen Park | ||
2240 | 2240 | 2239 | {"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 | Brewster Cmmunity Garden | 16369 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.26 | Brewster Cmmunity Garden | ||
2268 | 2268 | 2267 | {"type": "Polygon", "coordinates": [[[-122.41296, 37.79709], [-122.41291, 37.7971], [-122.41288, 37.79701], [-122.41284, 37.797], [-122.41282, 37.79693], [-122.41292, 37.79692], [-122.41296, 37.79709]]]} | Open Access 1 | Broadway Tunnel east Mini Park | 16410 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.033 | Broadway Tunnel east MP | ||
2269 | 2269 | 2268 | {"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 | Broadway Tunnel West Mini Park | 16411 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.125 | Broadway Tunnel West MP | ||
2285 | 2285 | 2284 | {"type": "Polygon", "coordinates": [[[-122.46792, 37.71714], [-122.46758, 37.71715], [-122.46758, 37.71755], [-122.46724, 37.71756], [-122.46726, 37.71785], [-122.46669, 37.71784], [-122.46666, 37.71757], [-122.46635, 37.71757], [-122.46634, 37.71784], [-122.46613, 37.71785], [-122.46612, 37.71757], [-122.46578, 37.71757], [-122.46578, 37.71695], [-122.4661, 37.71695], [-122.46612, 37.71687], [-122.46792, 37.71687], [-122.46792, 37.71714]]]} | Open Access 1 | Brooks Park | 16429 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3.742 | Brooks Park | ||
2323 | 2323 | 2322 | {"type": "MultiPolygon", "coordinates": [[[[-122.42838, 37.77801], [-122.42815, 37.77804], [-122.42806, 37.77759], [-122.42829, 37.77756], [-122.42838, 37.77801]]], [[[-122.42857, 37.77894], [-122.42834, 37.77897], [-122.42819, 37.77823], [-122.42842, 37.7782], [-122.42857, 37.77894]]], [[[-122.42876, 37.77987], [-122.42853, 37.7799], [-122.42838, 37.77916], [-122.42861, 37.77913], [-122.42876, 37.77987]]], [[[-122.42895, 37.78081], [-122.42872, 37.78084], [-122.42857, 37.78009], [-122.4288, 37.78006], [-122.42895, 37.78081]]], [[[-122.42907, 37.78141], [-122.42884, 37.78144], [-122.42875, 37.78102], [-122.42899, 37.78099], [-122.42907, 37.78141]]]]} | Open Access 1 | Buchanan Street Mall | 16470 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.812 | Buchanan Street Mall | ||
2343 | 2343 | 2342 | {"type": "Polygon", "coordinates": [[[-122.44374, 37.76757], [-122.4436, 37.76795], [-122.44361, 37.76797], [-122.44326, 37.76884], [-122.44222, 37.7695], [-122.44226, 37.76963], [-122.4424, 37.76978], [-122.44259, 37.76978], [-122.44281, 37.76981], [-122.44298, 37.76997], [-122.44309, 37.77012], [-122.44316, 37.77039], [-122.44062, 37.77072], [-122.43988, 37.77049], [-122.43983, 37.77049], [-122.43959, 37.77036], [-122.43939, 37.76998], [-122.43915, 37.7698], [-122.43906, 37.76971], [-122.43904, 37.7697], [-122.43845, 37.7691], [-122.43892, 37.76848], [-122.44026, 37.76782], [-122.44072, 37.76703], [-122.44207, 37.76601], [-122.4424, 37.76602], [-122.4427, 37.7661], [-122.44291, 37.76625], [-122.44295, 37.76637], [-122.44296, 37.76638], [-122.44298, 37.76649], [-122.44345, 37.76678], [-122.44363, 37.7671], [-122.44374, 37.76757]]]} | Open Access 1 | Buena Vista Park | 16492 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 36.125 | Buena Vista Park | ||
2434 | 2434 | 2433 | {"type": "Polygon", "coordinates": [[[-122.41252, 37.7925], [-122.41194, 37.79257], [-122.41179, 37.79183], [-122.41237, 37.79176], [-122.41252, 37.7925]]]} | Open Access 1 | Collins P. Huntington Park | 17522 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.069 | Collins P. Huntington Park | ||
2471 | 2471 | 2470 | {"type": "Polygon", "coordinates": [[[-122.39784, 37.75746], [-122.39715, 37.7575], [-122.39713, 37.75732], [-122.39782, 37.75728], [-122.39784, 37.75746]]]} | Open Access 1 | Connecticut Friendship Garden | 17590 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.302 | Connecticut Friendship Garden | ||
2514 | 2514 | 2513 | {"type": "Polygon", "coordinates": [[[-122.41556, 37.75767], [-122.41516, 37.75769], [-122.41515, 37.75777], [-122.41473, 37.7578], [-122.41469, 37.75738], [-122.41553, 37.75733], [-122.41556, 37.75767]]]} | Open Access 1 | Coronado Playground | 17650 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.784 | Coronado Playground | ||
2526 | 2526 | 2525 | {"type": "Polygon", "coordinates": [[[-122.43912, 37.75734], [-122.43895, 37.75734], [-122.43893, 37.75709], [-122.43911, 37.75715], [-122.43912, 37.75734]]]} | Open Access 1 | Corwin Community Garden | 17668 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.092 | Corwin Community Garden | ||
2717 | 2717 | 2716 | {"type": "Polygon", "coordinates": [[[-122.45124, 37.71372], [-122.45007, 37.71466], [-122.44956, 37.71426], [-122.44988, 37.71398], [-122.44966, 37.71379], [-122.44963, 37.71374], [-122.45015, 37.7135], [-122.45062, 37.71323], [-122.45124, 37.71372]]]} | Open Access 1 | Cayuga Playground | 16986 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 2.921 | Cayuga Playground | ||
2726 | 2726 | 2725 | {"type": "Polygon", "coordinates": [[[-122.43308, 37.73045], [-122.43291, 37.7305], [-122.4328, 37.73023], [-122.43296, 37.73017], [-122.43308, 37.73045]]]} | Open Access 1 | Cayuga & Lamartine Mini Park | 16985 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.126 | Cayuga & Lamartine MP | ||
2884 | 2884 | 2883 | {"type": "Polygon", "coordinates": [[[-122.43454, 37.73883], [-122.43413, 37.73884], [-122.43411, 37.73877], [-122.43447, 37.73876], [-122.43454, 37.73883]]]} | Open Access 1 | Diamond & Farnum Open Space | 18138 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.069 | Diamond & Farnum OS | ||
2897 | 2897 | 2896 | {"type": "Polygon", "coordinates": [[[-122.40734, 37.80463], [-122.40687, 37.80468], [-122.40687, 37.80464], [-122.40733, 37.80459], [-122.40734, 37.80463]]]} | Open Access 1 | Chesnut/kearny Mini Park | 17178 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.047 | Chesnut/kearny MP | ||
2925 | 2925 | 2924 | {"type": "MultiPolygon", "coordinates": [[[[-122.43655, 37.74183], [-122.43609, 37.74212], [-122.43591, 37.74177], [-122.43576, 37.74145], [-122.43637, 37.74138], [-122.43643, 37.74159], [-122.43655, 37.74183]]], [[[-122.44184, 37.74352], [-122.44069, 37.74385], [-122.44059, 37.7446], [-122.44084, 37.74464], [-122.44076, 37.74518], [-122.4407, 37.74518], [-122.44075, 37.74468], [-122.44026, 37.74463], [-122.44002, 37.74493], [-122.43977, 37.74469], [-122.43946, 37.74449], [-122.43998, 37.74454], [-122.44011, 37.74356], [-122.43989, 37.74352], [-122.43991, 37.74317], [-122.43935, 37.74312], [-122.43933, 37.74316], [-122.43896, 37.74314], [-122.43797, 37.74339], [-122.43798, 37.74332], [-122.43824, 37.74325], [-122.43822, 37.74317], [-122.43911, 37.74297], [-122.44001, 37.74296], [-122.44081, 37.74269], [-122.4411, 37.7425], [-122.44124, 37.74231], [-122.44147, 37.74247], [-122.44184, 37.74352]]], [[[-122.44096, 37.7415], [-122.44084, 37.74172], [-122.44057, 37.74162], [-122.44062, 37.74158], [-122.44063, 37.74154], [-122.44062, 37.74148], [-122.44059, 37.74145], [-122.44054, 37.74143], [-122.44044, 37.74142], [-122.44033, 37.74136], [-122.44056, 37.74112], [-122.44065, 37.74117], [-122.44096, 37.7415]]]]} | Open Access 1 | Christopher Playground | 17234 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 8.108 | Christopher Playground | ||
3025 | 3025 | 3024 | {"type": "Polygon", "coordinates": [[[-122.44339, 37.74797], [-122.44285, 37.74806], [-122.44281, 37.74805], [-122.44331, 37.74755], [-122.44337, 37.74755], [-122.44339, 37.74797]]]} | Open Access 1 | Clipper Terrace Community Garden | 17430 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.341 | Clipper Terrace Community Garden |
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]);