units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
240 rows where MNG_AGENCY = 21 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, COUNTY, YR_EST, GAP_STS
DES_TP >30
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 | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13810 | 13810 | 13809 | {"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 | 48835 | Naples Green | 33554 | 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://groundplaysf.org/projects/naples-green/ | San Francisco 13 | 0.132 | Naples Green | 0 | Local Park 2 | 4 |
12607 | 12607 | 12606 | {"type": "Polygon", "coordinates": [[[-122.42215, 37.74582], [-122.42193, 37.74583], [-122.42211, 37.74534], [-122.42215, 37.74582], [-122.42215, 37.74582]]]} | Open Access 1 | 48780 | San Jose Guerrero Park | 33506 | 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://groundplaysf.org/projects/san-jose-guerrero-park/ | San Francisco 13 | 0.127 | San Jose Guerrero Park | 0 | Local Park 2 | 4 |
3595 | 3595 | 3594 | {"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 | 48779 | Kids' Park | 33505 | 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://missionbayparks.com/childrens-park/ | San Francisco 13 | 1.121 | Kids' Park | 0 | Local Park 2 | 4 |
3592 | 3592 | 3591 | {"type": "Polygon", "coordinates": [[[-122.39224, 37.7649], [-122.39054, 37.76501], [-122.39054, 37.76501], [-122.39057, 37.76489], [-122.39068, 37.7646], [-122.3907, 37.76449], [-122.39068, 37.76432], [-122.39218, 37.76423], [-122.39224, 37.7649]]]} | Open Access 1 | 48778 | Mariposa Park | 33504 | 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://missionbayparks.com/mariposa-park/ | San Francisco 13 | 2.58 | Mariposa Park | 0 | Local Park 2 | 4 |
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 |
7829 | 7829 | 7828 | {"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 | 47708 | Playland at 43rd Avenue | 31457 | 2414 | San Francisco Unified School District 881 | Special District 4 | School District 14 | http://www.sfusd.edu/ | Special District 4 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.382 | Playland at 43rd Avenue | 2016 | None 654 | ||
3950 | 3950 | 3949 | {"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 | 47543 | India Basin Waterfront Park | 31251 | 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.262 | India Basin Waterfront Park | 0 | Local Park 2 | 4 | |
14780 | 14780 | 14779 | {"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 | 47235 | SoMa West Dog Park | 30946 | 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.617 | SoMa West Dog Park | 0 | Local Park 2 | 4 | |
14827 | 14827 | 14826 | {"type": "Polygon", "coordinates": [[[-122.42157, 37.77045], [-122.42131, 37.77037], [-122.4213, 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 | 47234 | SoMa West Skate Park | 30945 | 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.741 | SoMa West Skate Park | 0 | Local Recreation Area 3 | 4 | |
14539 | 14539 | 14538 | {"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 | 47202 | Palega Recreation Center | 30903 | 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/palega-rec-center/ | San Francisco 13 | 4.966 | Palega Rec. Ctr. | 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 |
4090 | 4090 | 4089 | {"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 | 47170 | Tenderloin Recreation Center | 30859 | 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/tenderloin-rec-center-park/ | San Francisco 13 | 0.606 | Tenderloin Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
14511 | 14511 | 14510 | {"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 | 47169 | South of Market/ Gene Friend Recreation Center | 30858 | 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://www.sfparksalliance.org/our-parks/parks/south-market-gene-friend-recreation-center | San Francisco 13 | 1.019 | South of Market/ Gene Friend Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
4272 | 4272 | 4271 | {"type": "Polygon", "coordinates": [[[-122.38404, 37.75453], [-122.38349, 37.75473], [-122.38319, 37.75463], [-122.38303, 37.7544], [-122.38296, 37.75433], [-122.38291, 37.75389], [-122.38294, 37.75343], [-122.38306, 37.75332], [-122.38311, 37.75341], [-122.38316, 37.75418], [-122.38321, 37.75428], [-122.38326, 37.7543], [-122.38401, 37.75423], [-122.38404, 37.75453]]]} | Open Access 1 | 45362 | Warm Water Cove | 27262 | 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.343 | Warm Water Cove | None 373 | |||
14691 | 14691 | 14690 | {"type": "Polygon", "coordinates": [[[-122.41621, 37.76434], [-122.41587, 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 | 45018 | In Chan Kaajal Park | 31768 | 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/project/proposed-park-site-at-17th-and-folsom/ | San Francisco 13 | 1.398 | In Chan Kaajal Park | 2017 | Local Park 2 | 4 |
4647 | 4647 | 4646 | {"type": "Polygon", "coordinates": [[[-122.38148, 37.73182], [-122.38122, 37.73211], [-122.38122, 37.73223], [-122.38105, 37.73214], [-122.38098, 37.73216], [-122.3807, 37.73205], [-122.38067, 37.73203], [-122.38065, 37.73199], [-122.38066, 37.73194], [-122.38081, 37.73176], [-122.38103, 37.73152], [-122.38108, 37.7315], [-122.38114, 37.7315], [-122.38118, 37.73152], [-122.38134, 37.73167], [-122.38138, 37.73177], [-122.38148, 37.73182]]]} | Open Access 1 | 36528 | Unnamed site - San Francisco, City of | 28697 | 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.816 | 0 | Local Other or Unknown 14 | 4 | ||
13804 | 13804 | 13803 | {"type": "Polygon", "coordinates": [[[-122.45304, 37.74201], [-122.45079, 37.74215], [-122.45075, 37.74211], [-122.45073, 37.74181], [-122.45102, 37.74129], [-122.45105, 37.74127], [-122.45148, 37.74137], [-122.45196, 37.74143], [-122.45225, 37.74143], [-122.45298, 37.74139], [-122.45304, 37.74201]]]} | Open Access 1 | 36375 | San Francisco, City and County of 1 | 24891 | 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.693 | San Francisco, City and County of 1 | None 1188 | |||
3536 | 3536 | 3535 | {"type": "Polygon", "coordinates": [[[-122.41521, 37.74427], [-122.41503, 37.74455], [-122.41497, 37.74456], [-122.41494, 37.74427], [-122.41521, 37.74427]]]} | Open Access 1 | 36361 | San Francisco, City and County of 2 | 24892 | 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.114 | San Francisco, City and County of 2 | None 295 | |||
5453 | 5453 | 5452 | {"type": "MultiPolygon", "coordinates": [[[[-122.42159, 37.80398], [-122.42017, 37.80418], [-122.42001, 37.80338], [-122.42145, 37.80319], [-122.42159, 37.80398]]], [[[-122.42169, 37.80449], [-122.42028, 37.80468], [-122.42019, 37.80426], [-122.42161, 37.80406], [-122.42169, 37.80449]]]]} | Open Access 1 | 24971 | Russian Hill Park | 24745 | 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.324 | Russian Hill Park | 0 | Local Park 2 | 4 | |
16902 | 16902 | 16901 | {"type": "Polygon", "coordinates": [[[-122.37691, 37.72997], [-122.37659, 37.73005], [-122.37631, 37.73007], [-122.376, 37.73004], [-122.37574, 37.72998], [-122.37573, 37.72996], [-122.37596, 37.72969], [-122.37631, 37.72937], [-122.37639, 37.72939], [-122.37665, 37.72955], [-122.37687, 37.72986], [-122.37691, 37.72997]]]} | Open Access 1 | 24970 | Milton Myer Recreation Center | 22256 | 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.224 | Milton Myer 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]);