superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
240 rows where MNG_AGENCY = 21 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
8398 | 8398 | 8397 | {"type": "Polygon", "coordinates": [[[-122.412, 37.74019], [-122.41199, 37.74026], [-122.41175, 37.74024], [-122.41175, 37.74018], [-122.412, 37.74019]]]} | Open Access 1 | Prentiss Mini Park | 23985 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.04 | Prentiss MP | ||
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 | ||
7954 | 7954 | 7953 | {"type": "Polygon", "coordinates": [[[-122.42592, 37.73641], [-122.42567, 37.73661], [-122.42567, 37.73661], [-122.42574, 37.7364], [-122.42592, 37.73641]]]} | Open Access 1 | Park St. Garden | 23439 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.047 | Park St. Garden | ||
11359 | 11359 | 11358 | {"type": "Polygon", "coordinates": [[[-122.40673, 37.74516], [-122.40672, 37.74526], [-122.4065, 37.74539], [-122.40645, 37.74534], [-122.40673, 37.74516]]]} | Open Access 1 | Wolfe Lane Community Garden | 27672 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.054 | Wolfe Lane Community Garden | ||
1963 | 1963 | 1962 | {"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 | Bernal Heights Community Garden | 16025 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.056 | Bernal Heights Community Garden | ||
5242 | 5242 | 5241 | {"type": "Polygon", "coordinates": [[[-122.41041, 37.79043], [-122.40994, 37.79049], [-122.40993, 37.79044], [-122.4104, 37.79038], [-122.41041, 37.79043]]]} | Open Access 1 | Hooker Alley Community Garden | 20075 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.056 | Hooker Alley Community Garden | ||
1908 | 1908 | 1907 | {"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 | Beideman/o'farrell Mini Park | 15958 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.059 | Beideman/o'farrell MP | ||
6325 | 6325 | 6324 | {"type": "Polygon", "coordinates": [[[-122.43359, 37.76495], [-122.43331, 37.76497], [-122.43331, 37.76488], [-122.43358, 37.76486], [-122.43359, 37.76495]]]} | Open Access 1 | Noe & Beaver Mini Park | 22781 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.059 | Noe & Beaver MP | ||
6680 | 6680 | 6679 | {"type": "Polygon", "coordinates": [[[-122.41078, 37.80057], [-122.4105, 37.80037], [-122.4105, 37.80037], [-122.41073, 37.80035], [-122.41078, 37.80057]]]} | Open Access 1 | Marini Plaza | 21858 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.066 | Marini Plaza | ||
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 | ||
1565 | 1565 | 1564 | {"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 | Arkansas Friendship Garden | 15586 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.075 | Arkansas Friendship Garden | ||
4622 | 4622 | 4621 | {"type": "Polygon", "coordinates": [[[-122.43354, 37.77968], [-122.43341, 37.7797], [-122.43336, 37.77948], [-122.4335, 37.77946], [-122.43354, 37.77968]]]} | Open Access 1 | Golden Gate & Steiner Mini Park | 19359 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.075 | Golden Gate & Steiner MP | ||
7854 | 7854 | 7853 | {"type": "Polygon", "coordinates": [[[-122.42819, 37.77378], [-122.42809, 37.77379], [-122.42807, 37.77378], [-122.42802, 37.77347], [-122.42812, 37.77346], [-122.42819, 37.77378]]]} | Open Access 1 | Page Street Community Garden | 23316 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.082 | Page Street Community Garden | ||
5614 | 5614 | 5613 | {"type": "Polygon", "coordinates": [[[-122.41928, 37.80672], [-122.41901, 37.80676], [-122.41895, 37.8065], [-122.41895, 37.8065], [-122.41928, 37.80672]]]} | Open Access 1 | Joseph Conrad Mini Park | 20494 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.087 | Joseph Conrad MP | ||
8551 | 8551 | 8550 | {"type": "Polygon", "coordinates": [[[-122.46378, 37.71461], [-122.46361, 37.71462], [-122.46361, 37.71441], [-122.46378, 37.71441], [-122.46378, 37.71461]]]} | Open Access 1 | Randolph & Bright Mini Park | 24184 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.087 | Randolph & Bright MP | ||
10593 | 10593 | 10592 | {"type": "Polygon", "coordinates": [[[-122.41555, 37.74491], [-122.41552, 37.74496], [-122.41507, 37.74482], [-122.41512, 37.74474], [-122.41555, 37.74491]]]} | Open Access 1 | Vacated Portion Of Bocana St | 26751 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.089 | Vacated Portion Of Bocana St | ||
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 | ||
9377 | 9377 | 9376 | {"type": "Polygon", "coordinates": [[[-122.44079, 37.76271], [-122.44033, 37.76274], [-122.44032, 37.76266], [-122.44079, 37.76263], [-122.44079, 37.76271]]]} | Open Access 1 | Saturn St.steps | 25168 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.097 | Saturn St.steps | ||
5315 | 5315 | 5314 | {"type": "Polygon", "coordinates": [[[-122.41934, 37.79765], [-122.41887, 37.79771], [-122.41885, 37.79763], [-122.41932, 37.79756], [-122.41934, 37.79765]]]} | Open Access 1 | Hyde / Vallejo Mini Park | 20164 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.102 | Hyde / Vallejo MP |
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]);