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 UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: COUNTY, ACRES, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
134 | 134 | 133 | {"type": "Polygon", "coordinates": [[[-122.42226, 37.73435], [-122.42174, 37.73471], [-122.42177, 37.73475], [-122.42174, 37.73506], [-122.42008, 37.73497], [-122.42016, 37.73405], [-122.41919, 37.734], [-122.41925, 37.73328], [-122.41931, 37.73301], [-122.41929, 37.733], [-122.41929, 37.73252], [-122.41954, 37.73252], [-122.41956, 37.73231], [-122.42009, 37.7323], [-122.4201, 37.73232], [-122.42027, 37.73232], [-122.42079, 37.73229], [-122.42084, 37.73243], [-122.42096, 37.7324], [-122.42091, 37.73226], [-122.421, 37.73225], [-122.42145, 37.7331], [-122.4217, 37.73332], [-122.42178, 37.73343], [-122.4221, 37.73413], [-122.42226, 37.73435]]]} | Open Access 1 | 342 | Saint Mary's Playground | 24791 | 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 | 13.777 | Saint Mary's Playground | 0 | Local Recreation Area 3 | 4 | |
5058 | 5058 | 5057 | {"type": "Polygon", "coordinates": [[[-122.48732, 37.75739], [-122.48649, 37.75743], [-122.48638, 37.75579], [-122.4872, 37.75575], [-122.48732, 37.75739]]]} | Open Access 1 | 1309 | Sunset Recreation Center | 30853 | 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/sunset-rec-center-park/ | San Francisco 13 | 3.286 | Sunset Rec. Ctr. | 1940 | Local Recreation Area 3 | 4 |
6487 | 6487 | 6486 | {"type": "Polygon", "coordinates": [[[-122.38603, 37.73925], [-122.38546, 37.73987], [-122.38325, 37.73861], [-122.3832, 37.73817], [-122.38362, 37.73814], [-122.38358, 37.73766], [-122.38403, 37.73764], [-122.38454, 37.73806], [-122.38435, 37.73829], [-122.38603, 37.73925]]]} | Open Access 1 | 2339 | Youngblood-Coleman Playground | 27790 | 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.153 | Youngblood-Coleman 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 | |
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 | |
6831 | 6831 | 6830 | {"type": "Polygon", "coordinates": [[[-122.43383, 37.72008], [-122.4332, 37.72091], [-122.43261, 37.72063], [-122.43324, 37.7198], [-122.43383, 37.72008]]]} | Open Access 1 | 5438 | Excelsior Playground | 18772 | 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.612 | Excelsior Playground | 0 | Local Recreation Area 3 | 4 | |
5827 | 5827 | 5826 | {"type": "Polygon", "coordinates": [[[-122.40969, 37.71204], [-122.40927, 37.71298], [-122.40848, 37.71277], [-122.4089, 37.71182], [-122.40969, 37.71204]]]} | Open Access 1 | 5440 | Visitacion Valley Playground | 27163 | 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.053 | Visitacion Valley Playground | 0 | Local Recreation Area 3 | 4 | |
6834 | 6834 | 6833 | {"type": "MultiPolygon", "coordinates": [[[[-122.38909, 37.71702], [-122.38813, 37.71809], [-122.387, 37.71745], [-122.3879, 37.71646], [-122.38796, 37.71642], [-122.38806, 37.71643], [-122.38909, 37.71702]]], [[[-122.38859, 37.71548], [-122.38852, 37.71556], [-122.38854, 37.71568], [-122.38853, 37.71575], [-122.3884, 37.71602], [-122.38832, 37.71612], [-122.38849, 37.71638], [-122.38857, 37.71643], [-122.38856, 37.71644], [-122.38841, 37.71636], [-122.38834, 37.71628], [-122.38804, 37.71536], [-122.38827, 37.7151], [-122.3884, 37.71518], [-122.38859, 37.71548]]]]} | Open Access 1 | 5455 | Gilman Playground | 19297 | 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.205 | Gilman Playground | 0 | Local Recreation Area 3 | 4 | |
6837 | 6837 | 6836 | {"type": "Polygon", "coordinates": [[[-122.49841, 37.74932], [-122.49761, 37.74935], [-122.4976, 37.74941], [-122.49561, 37.7495], [-122.4956, 37.74928], [-122.49643, 37.74925], [-122.49633, 37.74786], [-122.49834, 37.74777], [-122.49841, 37.74932]]]} | Open Access 1 | 5460 | Sunset West Playground | 26071 | 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.05 | Sunset West Playground | 0 | Local Recreation Area 3 | 4 | |
838 | 838 | 837 | {"type": "Polygon", "coordinates": [[[-122.44984, 37.73813], [-122.44957, 37.73918], [-122.44952, 37.73922], [-122.44945, 37.73923], [-122.44886, 37.73921], [-122.44882, 37.7392], [-122.4488, 37.73916], [-122.44882, 37.73902], [-122.44896, 37.73851], [-122.44902, 37.7381], [-122.44907, 37.73808], [-122.44945, 37.73809], [-122.44971, 37.73804], [-122.44978, 37.73805], [-122.44983, 37.73809], [-122.44984, 37.73813]]]} | Open Access 1 | 5466 | Miraloma Playground | 22285 | 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.208 | Miraloma Playground | 0 | Local Recreation Area 3 | 4 | |
6853 | 6853 | 6852 | {"type": "Polygon", "coordinates": [[[-122.44843, 37.73378], [-122.44838, 37.73378], [-122.44838, 37.73391], [-122.44828, 37.73392], [-122.44828, 37.73401], [-122.44811, 37.73401], [-122.44809, 37.73391], [-122.44667, 37.73395], [-122.44652, 37.73385], [-122.44657, 37.73374], [-122.44656, 37.73317], [-122.4467, 37.73317], [-122.44671, 37.73345], [-122.44696, 37.73345], [-122.44833, 37.73344], [-122.44834, 37.73317], [-122.44842, 37.73317], [-122.44843, 37.73378]]]} | Open Access 1 | 5480 | Sunnyside Playground | 26011 | 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.372 | Sunnyside Playground | 0 | Local Recreation Area 3 | 4 | |
6856 | 6856 | 6855 | {"type": "Polygon", "coordinates": [[[-122.44001, 37.74634], [-122.44, 37.7465], [-122.44, 37.74662], [-122.4394, 37.7473], [-122.43943, 37.74853], [-122.43834, 37.74853], [-122.43812, 37.74631], [-122.43913, 37.74626], [-122.43924, 37.74629], [-122.43932, 37.74625], [-122.43936, 37.74618], [-122.44001, 37.74634]]]} | Open Access 1 | 5489 | Douglass Playground | 18248 | 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 | 7.451 | Douglass Playground | 0 | Local Recreation Area 3 | 4 | |
6720 | 6720 | 6719 | {"type": "Polygon", "coordinates": [[[-122.42865, 37.74269], [-122.42692, 37.74279], [-122.42689, 37.74247], [-122.42706, 37.74246], [-122.42703, 37.74215], [-122.42859, 37.74206], [-122.42865, 37.74269]]]} | Open Access 1 | 5498 | Upper Noe Recreation Center | 30854 | 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/upper-noe-rec-center/ | San Francisco 13 | 2.511 | Upper Noe Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
6866 | 6866 | 6865 | {"type": "Polygon", "coordinates": [[[-122.43563, 37.74024], [-122.43562, 37.74029], [-122.43553, 37.74043], [-122.43545, 37.74059], [-122.43539, 37.74077], [-122.43537, 37.7409], [-122.43485, 37.74091], [-122.43415, 37.74117], [-122.43393, 37.74107], [-122.43302, 37.74079], [-122.43317, 37.74047], [-122.43363, 37.74022], [-122.43549, 37.74013], [-122.43558, 37.74017], [-122.43563, 37.74024]]]} | Open Access 1 | 5520 | Walter Haas Playground | 27246 | 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.406 | Walter Haas 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 | |
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 | |
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 | |
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 | |
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 |
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]);