superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
240 rows where MNG_AGENCY = 21 sorted by SUID_NMA descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
ACCESS_TYP 2
- Open Access 238
- Restricted Access 2
MNG_AG_TYP 1
- City Agency 240
MNG_AGENCY 1
- San Francisco, City and County of · 240 ✖
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA ▲ | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
803 | 803 | 802 | {"type": "Polygon", "coordinates": [[[-122.43668, 37.71365], [-122.43644, 37.714], [-122.43632, 37.71395], [-122.43656, 37.7136], [-122.43668, 37.71365]]]} | Open Access 1 | Naples Green | https://groundplaysf.org/projects/naples-green/ | 33554 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.132 | Naples Green | |
482 | 482 | 481 | {"type": "Polygon", "coordinates": [[[-122.42215, 37.74582], [-122.42193, 37.74583], [-122.42211, 37.74534], [-122.42211, 37.74534], [-122.42215, 37.74582]]]} | Open Access 1 | San Jose Guerrero Park | https://groundplaysf.org/projects/san-jose-guerrero-park/ | 33506 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.126 | San Jose Guerrero Park | |
473 | 473 | 472 | {"type": "Polygon", "coordinates": [[[-122.39332, 37.77186], [-122.39223, 37.77272], [-122.39223, 37.77272], [-122.39215, 37.77193], [-122.39332, 37.77186]]]} | Open Access 1 | Kids' Park | https://missionbayparks.com/childrens-park/ | 33505 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.121 | Kids' Park | |
465 | 465 | 464 | {"type": "Polygon", "coordinates": [[[-122.39224, 37.7649], [-122.39224, 37.7649], [-122.39054, 37.76501], [-122.39057, 37.76489], [-122.39068, 37.7646], [-122.3907, 37.76448], [-122.39068, 37.76432], [-122.39218, 37.76423], [-122.39224, 37.7649]]]} | Open Access 1 | Mariposa Park | https://missionbayparks.com/mariposa-park/ | 33504 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 2.58 | Mariposa Park | |
13192 | 13192 | 13191 | {"type": "Polygon", "coordinates": [[[-122.44267, 37.78575], [-122.44248, 37.78578], [-122.4424, 37.7854], [-122.4426, 37.78538], [-122.44267, 37.78575]]]} | Open Access 1 | Bush & Broderick Mini Park | https://sfrecpark.org/destination/bush-broderick-mini-park/ | 33394 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.181 | Bush & Broderick MP | |
10149 | 10149 | 10148 | {"type": "Polygon", "coordinates": [[[-122.50507, 37.78524], [-122.50351, 37.78602], [-122.50335, 37.78648], [-122.5024, 37.78704], [-122.5018, 37.78719], [-122.50116, 37.78701], [-122.50101, 37.78639], [-122.5006, 37.7861], [-122.50017, 37.78596], [-122.49951, 37.78644], [-122.49933, 37.78655], [-122.49895, 37.78658], [-122.49859, 37.78658], [-122.49822, 37.78655], [-122.49786, 37.78647], [-122.49731, 37.7863], [-122.49707, 37.78646], [-122.49677, 37.78646], [-122.49596, 37.78658], [-122.49573, 37.78666], [-122.49514, 37.7867], [-122.49423, 37.78648], [-122.49416, 37.7864], [-122.49405, 37.78653], [-122.49392, 37.78679], [-122.49379, 37.78689], [-122.4937, 37.78691], [-122.49333, 37.78174], [-122.5011, 37.78139], [-122.50133, 37.78414], [-122.50414, 37.78401], [-122.50507, 37.78524]]]} | Restricted Access 2 | Lincoln Park Golf Course | https://sfrecpark.org/destination/lincoln-park/ | 33132 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 112.095 | Lincoln Park GC | 1909 |
14593 | 14593 | 14592 | {"type": "MultiPolygon", "coordinates": [[[[-122.48702, 37.6263], [-122.48655, 37.62658], [-122.48643, 37.62662], [-122.48629, 37.62664], [-122.48616, 37.62664], [-122.48603, 37.62661], [-122.48592, 37.62657], [-122.48575, 37.62645], [-122.48565, 37.62631], [-122.48562, 37.6262], [-122.48558, 37.62569], [-122.48554, 37.6255], [-122.48541, 37.62524], [-122.48522, 37.62504], [-122.48501, 37.6249], [-122.48476, 37.62481], [-122.48384, 37.62463], [-122.48351, 37.62461], [-122.48332, 37.62463], [-122.48314, 37.62466], [-122.48161, 37.62511], [-122.48145, 37.62518], [-122.4813, 37.62526], [-122.4811, 37.62542], [-122.48093, 37.62562], [-122.48076, 37.62597], [-122.48052, 37.62649], [-122.48042, 37.62664], [-122.4803, 37.62675], [-122.48014, 37.62685], [-122.47997, 37.62693], [-122.47977, 37.62698], [-122.47875, 37.62705], [-122.47843, 37.6271], [-122.4688, 37.62708], [-122.46426, 37.62116], [-122.48041, 37.62146], [-122.48416, 37.62155], [-122.4842, 37.62157], [-122.48433, 37.62181], [-122.48449, 37.62195], [-122.48455, 37.62202], [-122.48465, 37.62231], [-122.48478, 37.62296], [-122.48492, 37.62338], [-122.48502, 37.6247], [-122.48516, 37.62476], [-122.48526, 37.62484], [-122.48533, 37.62493], [-122.48539, 37.62505], [-122.48659, 37.62582], [-122.48702, 37.6263]]], [[[-122.48741, 37.62712], [-122.48228, 37.62711], [-122.48228, 37.62601], [-122.48127, 37.62601], [-122.48125, 37.62656], [-122.48099, 37.62657], [-122.48098, 37.6271], [-122.48003, 37.6271], [-122.48021, 37.62703], [-122.48036, 37.62694], [-122.4805, 37.62682], [-122.48061, 37.62671], [-122.48073, 37.62652], [-122.48111, 37.62571], [-122.48124, 37.62553], [-122.48141, 37.6254], [-122.48169, 37.62527], [-122.48319, 37.62482], [-122.48338, 37.62478], [-122.48358, 37.62477], [-122.48382, 37.62479], [-122.48471, 37.62497], [-122.48493, 37.62506], [-122.4851, 37.62517], [-122.48524, 37.62533], [-122.4853, 37.62544], [-122.48535, 37.62557], [-122.48537, 37.6257], [-122.48541, 37.62622], [-122.48545, 37.62635], [-122.48556, 37.62653], [-122.48574, 37.62667], [-122.4859, 37.62675], [-122.48606, 37.62679], [-122.48625, 37.62681], [-122.48642, 37.62679], [-122.48666, 37.62672], [-122.48715, 37.62643], [-122.48726, 37.62655], [-122.48727, 37.62691], [-122.48741, 37.62712]]], [[[-122.49707, 37.62106], [-122.49634, 37.62138], [-122.49633, 37.62144], [-122.49668, 37.62221], [-122.49506, 37.62934], [-122.49503, 37.62979], [-122.49502, 37.62963], [-122.49501, 37.62962], [-122.49458, 37.62988], [-122.49433, 37.63], [-122.49411, 37.63001], [-122.49408, 37.62982], [-122.49222, 37.62982], [-122.49189, 37.62978], [-122.49148, 37.62965], [-122.49127, 37.62955], [-122.49115, 37.62947], [-122.49101, 37.62934], [-122.49083, 37.62911], [-122.49076, 37.62898], [-122.49068, 37.62876], [-122.49065, 37.62864], [-122.49057, 37.62721], [-122.48958, 37.62723], [-122.48938, 37.62671], [-122.48924, 37.62643], [-122.48908, 37.6262], [-122.48887, 37.62595], [-122.4887, 37.62578], [-122.48815, 37.62535], [-122.48786, 37.62507], [-122.48618, 37.62321], [-122.48574, 37.62275], [-122.48556, 37.62251], [-122.48553, 37.62225], [-122.48562, 37.62203], [-122.48591, 37.62164], [-122.49151, 37.62174], [-122.49152, 37.62169], [-122.49159, 37.62173], [-122.49343, 37.62181], [-122.4931, 37.62054], [-122.49707, 37.62106]]]]} | Restricted Access 2 | Sharp Park Golf Course | 33048 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 407.391 | Sharp Park GC | 1972 | |
13920 | 13920 | 13919 | {"type": "Polygon", "coordinates": [[[-122.41257, 37.78442], [-122.41193, 37.7845], [-122.41199, 37.78487], [-122.41171, 37.78491], [-122.41163, 37.78454], [-122.4118, 37.7845], [-122.41173, 37.78414], [-122.4125, 37.78405], [-122.41257, 37.78442]]]} | Open Access 1 | Father Alfred E. Boeddeker Park | https://sfrecpark.org/destination/father-alfred-e-boeddeker-park/ | 32514 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.979 | Father Alfred E. Boeddeker Park | |
12481 | 12481 | 12480 | {"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 | Ella Hill Hutch Center | https://www.sfparksalliance.org/our-parks/parks/ella-hill-hutch-center | 32433 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 2.343 | Ella Hill Hutch Ctr. | |
52 | 52 | 51 | {"type": "Polygon", "coordinates": [[[-122.41621, 37.76434], [-122.41588, 37.76436], [-122.41587, 37.76447], [-122.41537, 37.7645], [-122.41531, 37.76377], [-122.41615, 37.76372], [-122.41621, 37.76434]]]} | Open Access 1 | In Chan Kaajal Park | http://sfrecpark.org/project/proposed-park-site-at-17th-and-folsom/ | 31768 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.398 | In Chan Kaajal Park | 2017 |
14193 | 14193 | 14192 | {"type": "Polygon", "coordinates": [[[-122.41835, 37.78009], [-122.41831, 37.78014], [-122.41724, 37.78028], [-122.41712, 37.78022], [-122.41685, 37.77889], [-122.41694, 37.77881], [-122.41801, 37.77868], [-122.41807, 37.77871], [-122.41835, 37.78009]]]} | Open Access 1 | Helen Diller Civic Center Playgrounds | 31697 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 4.432 | Helen Diller Civic Ctr. Playgrounds | 2018 | |
14002 | 14002 | 14001 | {"type": "Polygon", "coordinates": [[[-122.50267, 37.76171], [-122.50184, 37.76175], [-122.50179, 37.76106], [-122.50262, 37.76102], [-122.50267, 37.76171]]]} | Open Access 1 | Playland at 43rd Avenue | 31457 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.381 | Playland at 43rd Avenue | 2016 | |
13743 | 13743 | 13742 | {"type": "Polygon", "coordinates": [[[-122.37598, 37.7332], [-122.37557, 37.73365], [-122.3748, 37.73321], [-122.3752, 37.73276], [-122.37598, 37.7332]]]} | Open Access 1 | India Basin Waterfront Park | 31251 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.262 | India Basin Waterfront Park | ||
13539 | 13539 | 13538 | {"type": "Polygon", "coordinates": [[[-122.42232, 37.77085], [-122.42202, 37.77067], [-122.4217, 37.77052], [-122.42166, 37.7701], [-122.422, 37.77024], [-122.42227, 37.77039], [-122.42232, 37.77085]]]} | Open Access 1 | SoMa West Dog Park | 30946 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.617 | SoMa West Dog Park | ||
12383 | 12383 | 12382 | {"type": "Polygon", "coordinates": [[[-122.42157, 37.77045], [-122.42131, 37.77037], [-122.42129, 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 | SoMa West Skate Park | 30945 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.741 | SoMa West Skate Park | ||
13493 | 13493 | 13492 | {"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 | Bernal Heights Recreation Center | http://sfrecpark.org/destination/bernal-heights-rec-center/ | 30906 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.745 | Bernal Heights Rec. Ctr. | |
15309 | 15309 | 15308 | {"type": "Polygon", "coordinates": [[[-122.41088, 37.72963], [-122.40911, 37.7301], [-122.40868, 37.72905], [-122.41045, 37.72859], [-122.41088, 37.72963]]]} | Open Access 1 | Palega Recreation Center | http://sfrecpark.org/destination/palega-rec-center/ | 30903 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 4.966 | Palega Rec. Ctr. | |
700 | 700 | 699 | {"type": "Polygon", "coordinates": [[[-122.41343, 37.75828], [-122.41259, 37.75833], [-122.41255, 37.75792], [-122.41297, 37.75789], [-122.413, 37.7581], [-122.41341, 37.75807], [-122.41343, 37.75828]]]} | Open Access 1 | Mission Recreation Center | http://sfrecpark.org/destination/mission-rec-center/ | 30902 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.633 | Mission Rec. Ctr. | |
13475 | 13475 | 13474 | {"type": "Polygon", "coordinates": [[[-122.43699, 37.75986], [-122.43657, 37.7599], [-122.43662, 37.7605], [-122.43619, 37.76052], [-122.43607, 37.7593], [-122.43694, 37.75925], [-122.43699, 37.75986]]]} | Open Access 1 | Eureka Valley Recreation Center | http://sfrecpark.org/destination/eureka-valley-rec-center/ | 30885 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.936 | Eureka Valley Rec. Ctr. | |
15441 | 15441 | 15440 | {"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 | Betty Ong Recreation Center | http://sfrecpark.org/destination/betty-ong-rec-center/ | 30863 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.653 | Betty Ong Rec. Ctr. |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);