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 rowid descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 62
MNG_AGENCY 1
- San Francisco, City and County of · 62 ✖
DES_TP 1
- Local Recreation Area · 62 ✖
ACCESS_TYP 1
- Open Access 62
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11163 | 11163 | 11162 | {"type": "Polygon", "coordinates": [[[-122.43003, 37.77971], [-122.42876, 37.77987], [-122.42861, 37.77913], [-122.42988, 37.77897], [-122.43003, 37.77971]]]} | Open Access 1 | 48006 | Ella Hill Hutch Center | 32433 | 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 | https://www.sfparksalliance.org/our-parks/parks/ella-hill-hutch-center | San Francisco 13 | 2.344 | Ella Hill Hutch Ctr. | 0 | Local Recreation Area 3 | 4 |
10280 | 10280 | 10279 | {"type": "Polygon", "coordinates": [[[-122.43483, 37.80273], [-122.43184, 37.80311], [-122.43179, 37.8031], [-122.43175, 37.80306], [-122.43145, 37.80152], [-122.4345, 37.80113], [-122.43483, 37.80273]]]} | Open Access 1 | 18048 | Moscone Playground | 22509 | 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 | 12.071 | Moscone 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 |
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 | |
9673 | 9673 | 9672 | {"type": "Polygon", "coordinates": [[[-122.46755, 37.72831], [-122.46726, 37.72858], [-122.46699, 37.72888], [-122.46678, 37.72914], [-122.46657, 37.72944], [-122.46548, 37.72903], [-122.46575, 37.72864], [-122.46609, 37.72822], [-122.4664, 37.72789], [-122.46684, 37.72753], [-122.46709, 37.72775], [-122.46726, 37.72793], [-122.46755, 37.72831]]]} | Open Access 1 | 16319 | Aptos Playground | 15546 | 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 | 4.793 | Aptos Playground | 0 | Local Recreation Area 3 | 4 | |
9669 | 9669 | 9668 | {"type": "Polygon", "coordinates": [[[-122.49967, 37.74962], [-122.4986, 37.74966], [-122.49872, 37.75128], [-122.49774, 37.75132], [-122.4976, 37.74935], [-122.49841, 37.74931], [-122.49834, 37.74777], [-122.49847, 37.74777], [-122.49849, 37.74797], [-122.49956, 37.74794], [-122.49967, 37.74962]], [[-122.49802, 37.75084], [-122.49803, 37.75115], [-122.4985, 37.75113], [-122.49848, 37.75082], [-122.49802, 37.75084]]]} | Open Access 1 | 16314 | West Sunset Playground | 27376 | 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 | 9.247 | West Sunset Playground | 0 | Local Recreation Area 3 | 4 | |
9667 | 9667 | 9666 | {"type": "Polygon", "coordinates": [[[-122.47063, 37.71782], [-122.46994, 37.71782], [-122.46993, 37.7172], [-122.47062, 37.7172], [-122.47063, 37.71782]]]} | Open Access 1 | 16309 | Merced Heights Playground | 22160 | 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 | 1.027 | Merced Heights 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 | |
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 | |
9078 | 9078 | 9077 | {"type": "Polygon", "coordinates": [[[-122.43354, 37.71325], [-122.43274, 37.71437], [-122.43269, 37.71436], [-122.43108, 37.7165], [-122.42702, 37.71562], [-122.42725, 37.71489], [-122.42531, 37.71439], [-122.42656, 37.71166], [-122.42746, 37.71192], [-122.42758, 37.71168], [-122.42855, 37.71212], [-122.42929, 37.71238], [-122.43354, 37.71325]]]} | Open Access 1 | 15030 | Crocker Amazon Playground | 17822 | 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 | 56.457 | Crocker Amazon Playground | 0 | Local Recreation Area 3 | 4 | |
7344 | 7344 | 7343 | {"type": "Polygon", "coordinates": [[[-122.45598, 37.79153], [-122.45339, 37.79222], [-122.45287, 37.79205], [-122.4521, 37.79218], [-122.45194, 37.79104], [-122.45569, 37.7903], [-122.45598, 37.79153]]]} | Open Access 1 | 6663 | Julius Kahn Playground | 20521 | 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 | 12.262 | Julius Kahn Playground | 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 | |
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 | |
7115 | 7115 | 7114 | {"type": "Polygon", "coordinates": [[[-122.49126, 37.78287], [-122.49044, 37.78291], [-122.49041, 37.7825], [-122.49123, 37.78246], [-122.49126, 37.78287]]]} | Open Access 1 | 6196 | Dupont Tennis Courts | 18310 | 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.823 | Dupont Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
7075 | 7075 | 7074 | {"type": "Polygon", "coordinates": [[[-122.43589, 37.78298], [-122.4357, 37.78302], [-122.43584, 37.78375], [-122.43479, 37.78389], [-122.43476, 37.78377], [-122.43461, 37.78378], [-122.4343, 37.78223], [-122.4357, 37.78205], [-122.43589, 37.78298]]]} | Open Access 1 | 6111 | Raymond Kimbell Playground | 24205 | 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 | 5.429 | Raymond Kimbell Playground | 0 | Local Recreation Area 3 | 4 | |
7026 | 7026 | 7025 | {"type": "Polygon", "coordinates": [[[-122.39017, 37.73464], [-122.38977, 37.73509], [-122.38872, 37.73449], [-122.38891, 37.73427], [-122.38877, 37.73418], [-122.38898, 37.73396], [-122.39017, 37.73464]]]} | Open Access 1 | 5967 | Joseph Lee Recreation Center | 30856 | 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/joseph-lee-rec-center/ | San Francisco 13 | 1.855 | Joseph Lee Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
6945 | 6945 | 6944 | {"type": "Polygon", "coordinates": [[[-122.39405, 37.7255], [-122.39347, 37.72679], [-122.39241, 37.72618], [-122.39337, 37.72511], [-122.39405, 37.7255]]]} | Open Access 1 | 5921 | Bay View Playground | 15884 | 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 | 3.402 | Bay View Playground | 0 | Local Recreation Area 3 | 4 | |
6940 | 6940 | 6939 | {"type": "Polygon", "coordinates": [[[-122.4521, 37.76279], [-122.45096, 37.76293], [-122.45085, 37.7624], [-122.45199, 37.76225], [-122.4521, 37.76279]]]} | Open Access 1 | 5841 | Grattan Playground | 19450 | 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 | 1.519 | Grattan Playground | 0 | Local Recreation Area 3 | 4 | |
6922 | 6922 | 6921 | {"type": "Polygon", "coordinates": [[[-122.43856, 37.76345], [-122.43825, 37.76361], [-122.43795, 37.76371], [-122.43764, 37.76378], [-122.43735, 37.76381], [-122.43733, 37.76371], [-122.43717, 37.76371], [-122.43714, 37.76342], [-122.43803, 37.76336], [-122.43856, 37.76345]]]} | Open Access 1 | 5816 | States St. Playground | 25813 | 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.997 | States St. Playground | 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 |
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]);