superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
238 rows where ACCESS_TYP = 1 and MNG_AGENCY = 21 sorted by SUID_NMA descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 238
MNG_AGENCY 1
- San Francisco, City and County of · 238 ✖
ACCESS_TYP 1
- Open Access · 238 ✖
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 | |
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. | |
15440 | 15440 | 15439 | {"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 | Tenderloin Recreation Center | http://sfrecpark.org/destination/tenderloin-rec-center-park/ | 30859 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.606 | Tenderloin Rec. Ctr. | |
15439 | 15439 | 15438 | {"type": "Polygon", "coordinates": [[[-122.40686, 37.77874], [-122.40669, 37.77888], [-122.40674, 37.77894], [-122.40655, 37.77909], [-122.40582, 37.7785], [-122.40619, 37.77821], [-122.40686, 37.77874]]]} | Open Access 1 | South of Market/ Gene Friend Recreation Center | http://www.sfparksalliance.org/our-parks/parks/south-market-gene-friend-recreation-center | 30858 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.02 | South of Market/ Gene Friend 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]);