units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
271 rows where COUNTY = 13 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV, YR_EST, GAP_STS
DES_TP >30
- Local Park 121
- Local Recreation Area 79
- National Recreation Area 7
- Local Other or Unknown 5
- State Recreation Area 2
- Local Conservation Area 1
- State Conservation Area 1
- Private Conservation 1
- Recreation Management Area 1
- Private Recreation or Education 1
- None 1
- None 1
- None 1
- None 1
- National Monument or Landmark 1
- None 1
- None 1
- None 1
- None 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- Historic or Cultural Area 1
- None 1
- …
MNG_AGENCY 14
- San Francisco, City and County of 239
- United States National Park Service 9
- San Francisco - Public Utilities Commission, City and County of 5
- San Francisco Parks Alliance 5
- California Department of Parks and Recreation 2
- MJM Management Group 2
- San Francisco, Port of 2
- United States Bureau of Land Management 1
- United States Fish and Wildlife Service 1
- University of California 1
- The Nature Conservancy 1
- California Department of Transportation 1
- San Francisco, City and County of, Redevelopment Agency 1
- Lao Family Community Development, Inc. 1
LAYER 10 ✖
MNG_AG_TYP 8
ACCESS_TYP 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
2059 | 2059 | 2058 | {"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 | 15688 | Prentiss Mini Park | 23985 | 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.04 | Prentiss MP | 0 | Local Park 2 | 4 | |
7954 | 7954 | 7953 | {"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 | 6593 | Chesnut/kearny Mini Park | 17178 | 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.047 | Chesnut/kearny MP | 0 | Local Park 2 | 4 | |
9500 | 9500 | 9499 | {"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 | 15907 | Park St. Garden | 23439 | 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.047 | Park St. Garden | 0 | Local Park 2 | 4 | |
2122 | 2122 | 2121 | {"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 | 15925 | Wolfe Lane Community Garden | 27672 | 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.055 | Wolfe Lane Community Garden | 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 | |
2130 | 2130 | 2129 | {"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 | 15957 | Hooker Alley Community Garden | 20075 | 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 | Hooker Alley Community Garden | 0 | Local Park 2 | 4 | |
6843 | 6843 | 6842 | {"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 | 15927 | Noe & Beaver Mini Park | 22781 | 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 | Noe & Beaver MP | 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 | |
7311 | 7311 | 7310 | {"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 | 6604 | Marini Plaza | 21858 | 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.066 | Marini Plaza | 0 | Local Park 2 | 4 | |
16122 | 16122 | 16121 | {"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 | 15929 | Diamond & Farnum Open Space | 18138 | 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.069 | Diamond & Farnum OS | 0 | Local Recreation Area 3 | 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 | |
7247 | 7247 | 7246 | {"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 | 6526 | Golden Gate & Steiner Mini Park | 19359 | 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 | Golden Gate & Steiner MP | 0 | Local Park 2 | 4 | |
6913 | 6913 | 6912 | {"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 | 5798 | Page Street Community Garden | 23316 | 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.082 | Page Street Community Garden | 0 | Local Park 2 | 4 | |
5766 | 5766 | 5765 | {"type": "Polygon", "coordinates": [[[-122.41928, 37.80672], [-122.41901, 37.80676], [-122.41895, 37.8065], [-122.41928, 37.80672], [-122.41928, 37.80672]]]} | Open Access 1 | 6615 | Joseph Conrad Mini Park | 20494 | 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.087 | Joseph Conrad MP | 0 | Local Park 2 | 4 | |
9380 | 9380 | 9379 | {"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 | 15680 | Randolph & Bright Mini Park | 24184 | 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.087 | Randolph & Bright MP | 0 | Local Park 2 | 4 | |
861 | 861 | 860 | {"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 | 5535 | Vacated Portion Of Bocana St | 26751 | 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.089 | Vacated Portion Of Bocana St | None 78 | |||
2119 | 2119 | 2118 | {"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 | 15928 | Corwin Community Garden | 17668 | 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.092 | Corwin Community Garden | 0 | Local Park 2 | 4 | |
6928 | 6928 | 6927 | {"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 | 5823 | Saturn St.steps | 25168 | 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.097 | Saturn St.steps | None 565 | |||
6992 | 6992 | 6991 | {"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 | 6435 | Hyde / Vallejo Mini Park | 20164 | 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.102 | Hyde / Vallejo 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]);