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 LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: COUNTY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4899 | 4899 | 4898 | {"type": "MultiPolygon", "coordinates": [[[[-122.47227, 37.75682], [-122.47215, 37.75701], [-122.47202, 37.75727], [-122.47195, 37.75729], [-122.47141, 37.75706], [-122.47129, 37.75698], [-122.4712, 37.7569], [-122.47111, 37.75678], [-122.47106, 37.75665], [-122.47105, 37.75655], [-122.47106, 37.75638], [-122.47147, 37.75639], [-122.47146, 37.75656], [-122.47151, 37.75669], [-122.47162, 37.75678], [-122.47179, 37.75685], [-122.47194, 37.75665], [-122.47227, 37.75682]]], [[[-122.47149, 37.75605], [-122.47147, 37.75632], [-122.47108, 37.75631], [-122.47109, 37.75604], [-122.47149, 37.75605]]], [[[-122.47257, 37.75623], [-122.47259, 37.75633], [-122.47257, 37.75647], [-122.47252, 37.75655], [-122.47232, 37.75676], [-122.47199, 37.75659], [-122.47219, 37.75636], [-122.4722, 37.75634], [-122.47197, 37.75608], [-122.47171, 37.7559], [-122.47192, 37.75563], [-122.47207, 37.75572], [-122.47224, 37.75585], [-122.47238, 37.756], [-122.47257, 37.75623]]]]} | Open Access 1 | 5586 | 14th & 15th Avenue Open Space | 15172 | 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 | 2.665 | 14th & 15th Avenue OS | 0 | Local Recreation Area 3 | 4 | |
15709 | 15709 | 15708 | {"type": "Polygon", "coordinates": [[[-122.44016, 37.74009], [-122.43987, 37.7401], [-122.43978, 37.73989], [-122.43976, 37.7398], [-122.43976, 37.73971], [-122.43982, 37.73946], [-122.43984, 37.73932], [-122.43982, 37.73917], [-122.43978, 37.73898], [-122.44007, 37.73898], [-122.44016, 37.74009]]]} | Open Access 1 | 5549 | 298 Berkeley Way Open Space | 15190 | 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.831 | 298 Berkeley Way OS | 0 | Local Recreation Area 3 | 4 | |
6827 | 6827 | 6826 | {"type": "Polygon", "coordinates": [[[-122.44734, 37.70991], [-122.44625, 37.71028], [-122.44596, 37.70975], [-122.44705, 37.70937], [-122.44734, 37.70991]]]} | Open Access 1 | 5435 | Alice Chalmers Playground | 15359 | 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.678 | Alice Chalmers Playground | 0 | Local Recreation Area 3 | 4 | |
1972 | 1972 | 1971 | {"type": "MultiPolygon", "coordinates": [[[[-122.45856, 37.77926], [-122.45682, 37.77948], [-122.45662, 37.77952], [-122.45657, 37.77952], [-122.45653, 37.77948], [-122.45628, 37.77823], [-122.45689, 37.77815], [-122.45692, 37.7782], [-122.45697, 37.77824], [-122.4571, 37.77827], [-122.45847, 37.7781], [-122.45856, 37.77926]]], [[[-122.45804, 37.77801], [-122.45765, 37.77806], [-122.45759, 37.77775], [-122.45798, 37.7777], [-122.45804, 37.77801]]]]} | Open Access 1 | 6076 | Angelo J Rossi Playground | 15497 | 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 | 6.474 | Angelo J Rossi Playground | 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 | |
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 | |
2550 | 2550 | 2549 | {"type": "Polygon", "coordinates": [[[-122.4469, 37.72308], [-122.44688, 37.72368], [-122.44681, 37.72389], [-122.44654, 37.72452], [-122.44566, 37.72454], [-122.44567, 37.72508], [-122.44619, 37.72507], [-122.44618, 37.7251], [-122.44621, 37.72511], [-122.44606, 37.7253], [-122.44588, 37.72531], [-122.4454, 37.726], [-122.44534, 37.72599], [-122.445, 37.72648], [-122.44499, 37.72653], [-122.44503, 37.72655], [-122.44496, 37.72665], [-122.44181, 37.72667], [-122.44482, 37.72306], [-122.44674, 37.72306], [-122.4469, 37.72308]]]} | Open Access 1 | 17801 | Balboa Park & Pool | 15772 | 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 | 23.774 | Balboa Park & Pool | 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 | |
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 |
16031 | 16031 | 16030 | {"type": "MultiPolygon", "coordinates": [[[[-122.41073, 37.74232], [-122.41072, 37.74236], [-122.41059, 37.74237], [-122.41059, 37.74232], [-122.41073, 37.74232]]], [[[-122.41136, 37.74229], [-122.41136, 37.74233], [-122.41122, 37.74234], [-122.41122, 37.74228], [-122.41136, 37.74229]]], [[[-122.41197, 37.74224], [-122.41197, 37.74227], [-122.41183, 37.74229], [-122.41184, 37.74224], [-122.41197, 37.74224]]], [[[-122.41541, 37.74416], [-122.41541, 37.74426], [-122.41446, 37.74402], [-122.41445, 37.74403], [-122.41446, 37.74416], [-122.41343, 37.74422], [-122.4134, 37.7439], [-122.41331, 37.74382], [-122.41315, 37.74375], [-122.41265, 37.7437], [-122.41245, 37.74361], [-122.41242, 37.74356], [-122.41231, 37.74349], [-122.41256, 37.74337], [-122.41267, 37.74334], [-122.41284, 37.74333], [-122.41297, 37.74334], [-122.4139, 37.74373], [-122.41424, 37.74386], [-122.41541, 37.74416]]], [[[-122.4126, 37.74215], [-122.4126, 37.74218], [-122.41246, 37.74219], [-122.41246, 37.74214], [-122.4126, 37.74215]]], [[[-122.41382, 37.74229], [-122.41382, 37.74235], [-122.41368, 37.74233], [-122.41369, 37.74229], [-122.41382, 37.74229]]], [[[-122.41572, 37.74203], [-122.41572, 37.74207], [-122.41558, 37.74208], [-122.41558, 37.74202], [-122.41572, 37.74203]]], [[[-122.41635, 37.74194], [-122.41635, 37.74195], [-122.41621, 37.74198], [-122.41621, 37.74193], [-122.41635, 37.74194]]], [[[-122.41763, 37.74237], [-122.41719, 37.74304], [-122.41667, 37.74283], [-122.41694, 37.7426], [-122.41699, 37.74248], [-122.41698, 37.74238], [-122.41689, 37.74222], [-122.41676, 37.74212], [-122.41663, 37.74207], [-122.41642, 37.74206], [-122.41641, 37.74195], [-122.41658, 37.74196], [-122.41674, 37.742], [-122.41682, 37.74186], [-122.41705, 37.74186], [-122.41721, 37.74193], [-122.41717, 37.74202], [-122.41737, 37.7421], [-122.41729, 37.74223], [-122.41763, 37.74237]]]]} | Open Access 1 | 5526 | Bernal Hts Open Space | 16027 | 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.838 | Bernal Hts 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 |
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 | |
997 | 997 | 996 | {"type": "Polygon", "coordinates": [[[-122.49914, 37.77303], [-122.49874, 37.77305], [-122.49874, 37.77312], [-122.49832, 37.77314], [-122.49829, 37.77266], [-122.49911, 37.77262], [-122.49914, 37.77303]]]} | Open Access 1 | 6208 | Cabrillo Playground | 16643 | 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.894 | Cabrillo Playground | 0 | Local Recreation Area 3 | 4 | |
6826 | 6826 | 6825 | {"type": "Polygon", "coordinates": [[[-122.45124, 37.71372], [-122.45007, 37.71466], [-122.44956, 37.71426], [-122.44989, 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 | 5431 | Cayuga Playground | 16986 | 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 | 2.918 | Cayuga Playground | 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 | |
6870 | 6870 | 6869 | {"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.74461], [-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.74455], [-122.44012, 37.74356], [-122.43989, 37.74352], [-122.43992, 37.74317], [-122.43934, 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 | 5548 | Christopher Playground | 17234 | 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 | 8.082 | Christopher Playground | 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 | |
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 | |
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 | |
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 |
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]);