units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
80 rows where DES_TP = 3 and MNG_AGENCY = 21 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: COUNTY, YR_EST
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 80
MNG_AGENCY 1
- San Francisco, City and County of · 80 ✖
DES_TP 1
- Local Recreation Area · 80 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
7326 | 7326 | 7325 | {"type": "Polygon", "coordinates": [[[-122.44504, 37.7974], [-122.44466, 37.79745], [-122.44464, 37.79736], [-122.44471, 37.79735], [-122.44469, 37.79727], [-122.44502, 37.79723], [-122.44504, 37.7974]]]} | Open Access 1 | 6639 | Cow Hollow Playground | 17727 | 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.151 | Cow Hollow Playground | 0 | Local Recreation Area 3 | 4 | |
15832 | 15832 | 15831 | {"type": "Polygon", "coordinates": [[[-122.42184, 37.75933], [-122.4215, 37.75935], [-122.42147, 37.75906], [-122.42181, 37.75904], [-122.42184, 37.75933]]]} | Open Access 1 | 5687 | Valencia & Cunningham Open Space | 26758 | 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.241 | Valencia & Cunningham OS | 0 | Local Recreation Area 3 | 4 | |
9377 | 9377 | 9376 | {"type": "Polygon", "coordinates": [[[-122.40426, 37.71229], [-122.4041, 37.71254], [-122.40372, 37.71239], [-122.40387, 37.71214], [-122.40426, 37.71229]]]} | Open Access 1 | 15674 | Vis Valley Community Center | 27160 | 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.287 | Vis Valley Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
934 | 934 | 933 | {"type": "Polygon", "coordinates": [[[-122.41717, 37.80125], [-122.4167, 37.80131], [-122.41663, 37.80094], [-122.4171, 37.80088], [-122.41717, 37.80125]]]} | Open Access 1 | 6469 | Michelangelo Playground | 22199 | 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.436 | Michelangelo Playground | 0 | Local Recreation Area 3 | 4 | |
2214 | 2214 | 2213 | {"type": "Polygon", "coordinates": [[[-122.44987, 37.78863], [-122.4494, 37.78869], [-122.44932, 37.78831], [-122.44979, 37.78825], [-122.44987, 37.78863]]]} | Open Access 1 | 6133 | Presidio Hts Playground | 23992 | 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.438 | Presidio Hts Playground | 0 | Local Recreation Area 3 | 4 | |
15674 | 15674 | 15673 | {"type": "Polygon", "coordinates": [[[-122.4337, 37.74613], [-122.43304, 37.74617], [-122.43304, 37.7461], [-122.43312, 37.74608], [-122.4331, 37.74577], [-122.43345, 37.74575], [-122.43369, 37.74571], [-122.4337, 37.74613]]]} | Open Access 1 | 5551 | Duncan/Castro Street Open Space | 18299 | 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.579 | Duncan/Castro Street OS | 0 | Local Recreation Area 3 | 4 | |
16032 | 16032 | 16031 | {"type": "Polygon", "coordinates": [[[-122.41585, 37.74445], [-122.41555, 37.74491], [-122.41512, 37.74474], [-122.4154, 37.74429], [-122.41562, 37.74437], [-122.41563, 37.74436], [-122.41585, 37.74445]]]} | Open Access 1 | 5528 | Bocana St. Open Space | 16217 | 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.604 | Bocana St. OS | 0 | Local Recreation Area 3 | 4 | |
4090 | 4090 | 4089 | {"type": "Polygon", "coordinates": [[[-122.41577, 37.78497], [-122.41511, 37.78505], [-122.41504, 37.78468], [-122.41569, 37.78459], [-122.41577, 37.78497]]]} | Open Access 1 | 47170 | Tenderloin Recreation Center | 30859 | 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/tenderloin-rec-center-park/ | San Francisco 13 | 0.606 | Tenderloin Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
9862 | 9862 | 9861 | {"type": "Polygon", "coordinates": [[[-122.42778, 37.77617], [-122.42702, 37.77627], [-122.42696, 37.77595], [-122.42771, 37.77585], [-122.42778, 37.77617]]]} | Open Access 1 | 16886 | Hayes Valley Community Center | 30367 | 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.61 | Hayes Valley Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
1038 | 1038 | 1037 | {"type": "Polygon", "coordinates": [[[-122.40755, 37.79404], [-122.40749, 37.79404], [-122.40745, 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.79346], [-122.40742, 37.79345], [-122.40755, 37.79404]]]} | Open Access 1 | 6352 | Chinese Playground | 17205 | 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.615 | Chinese Playground | 0 | Local Recreation Area 3 | 4 | |
10254 | 10254 | 10253 | {"type": "Polygon", "coordinates": [[[-122.41343, 37.75828], [-122.41259, 37.75833], [-122.41255, 37.75792], [-122.41297, 37.75789], [-122.41299, 37.7581], [-122.41341, 37.75807], [-122.41343, 37.75828]]]} | Open Access 1 | 17938 | Mission Recreation Center | 30902 | 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/mission-rec-center/ | San Francisco 13 | 0.632 | Mission Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
15775 | 15775 | 15774 | {"type": "Polygon", "coordinates": [[[-122.47273, 37.75508], [-122.47255, 37.75526], [-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 | 5588 | Grand View Pk. Open Space | 19427 | 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.642 | Grand View Pk. OS | 0 | Local Recreation Area 3 | 4 | |
16229 | 16229 | 16228 | {"type": "Polygon", "coordinates": [[[-122.41218, 37.79435], [-122.41147, 37.79444], [-122.41139, 37.79407], [-122.4121, 37.79398], [-122.41218, 37.79435]]]} | Open Access 1 | 47172 | Betty Ong Recreation Center | 30863 | 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/betty-ong-rec-center/ | San Francisco 13 | 0.653 | Betty Ong Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
14827 | 14827 | 14826 | {"type": "Polygon", "coordinates": [[[-122.42157, 37.77045], [-122.42131, 37.77037], [-122.4213, 37.77034], [-122.42116, 37.77034], [-122.4207, 37.77027], [-122.42032, 37.77026], [-122.42031, 37.77011], [-122.42153, 37.77003], [-122.42157, 37.77045]]]} | Open Access 1 | 47234 | SoMa West Skate Park | 30945 | 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.741 | SoMa West Skate Park | 0 | Local Recreation Area 3 | 4 | |
6874 | 6874 | 6873 | {"type": "Polygon", "coordinates": [[[-122.41643, 37.73815], [-122.41637, 37.73878], [-122.41588, 37.73874], [-122.41594, 37.73812], [-122.41643, 37.73815]]]} | Open Access 1 | 5524 | Bernal Heights Recreation Center | 30906 | 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/bernal-heights-rec-center/ | San Francisco 13 | 0.745 | Bernal Heights Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
1065 | 1065 | 1064 | {"type": "Polygon", "coordinates": [[[-122.41556, 37.75767], [-122.41515, 37.75769], [-122.41515, 37.75778], [-122.41473, 37.7578], [-122.41469, 37.75738], [-122.41553, 37.75733], [-122.41556, 37.75767]]]} | Open Access 1 | 5658 | Coronado Playground | 17650 | 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.783 | Coronado Playground | 0 | Local Recreation Area 3 | 4 | |
7217 | 7217 | 7216 | {"type": "Polygon", "coordinates": [[[-122.42116, 37.79591], [-122.42021, 37.79598], [-122.42014, 37.79566], [-122.42108, 37.79554], [-122.42116, 37.79591]]]} | Open Access 1 | 6424 | Helen Wills Playground | 19802 | 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.793 | Helen Wills Playground | 0 | Local Recreation Area 3 | 4 | |
9501 | 9501 | 9500 | {"type": "Polygon", "coordinates": [[[-122.44471, 37.74683], [-122.4447, 37.74687], [-122.44467, 37.7469], [-122.44451, 37.74695], [-122.44426, 37.74709], [-122.44415, 37.74719], [-122.44401, 37.74738], [-122.44342, 37.74741], [-122.44391, 37.74694], [-122.44406, 37.74685], [-122.44409, 37.74683], [-122.44413, 37.74684], [-122.44415, 37.74681], [-122.44447, 37.74677], [-122.44465, 37.74678], [-122.44468, 37.7468], [-122.44471, 37.74683]]]} | Open Access 1 | 15912 | Portola Open Space | 23909 | 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.814 | Portola OS | 0 | Local Recreation Area 3 | 4 | |
6422 | 6422 | 6421 | {"type": "Polygon", "coordinates": [[[-122.47813, 37.7796], [-122.4773, 37.77964], [-122.47727, 37.77923], [-122.4781, 37.77919], [-122.47813, 37.7796]]]} | Open Access 1 | 6160 | Argonne Playground | 15583 | 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.819 | Argonne Playground | 0 | Local Recreation Area 3 | 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]);