units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
240 rows where MNG_AGENCY = 21 sorted by map descending
This data as json, copyable, CSV (advanced)
DES_TP >30
ACCESS_TYP 2
- Open Access 219
- Restricted Access 1
MNG_AG_TYP 1
- City Agency 220
MNG_AGENCY 1
- San Francisco, City and County of · 220 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16809 | 16809 | 16808 | {"type": "Polygon", "coordinates": [[[-122.47841, 37.78346], [-122.47758, 37.78349], [-122.47755, 37.78308], [-122.47838, 37.78305], [-122.47841, 37.78346]]]} | Open Access 1 | 15961 | Richmond Recreation Center | 24343 | 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.825 | Richmond Rec. Ctr. | 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 | |
1902 | 1902 | 1901 | {"type": "Polygon", "coordinates": [[[-122.4742, 37.72523], [-122.47387, 37.72523], [-122.4735, 37.72527], [-122.47349, 37.72487], [-122.47322, 37.72486], [-122.47322, 37.7248], [-122.47411, 37.72426], [-122.47414, 37.72425], [-122.47416, 37.72427], [-122.47426, 37.72486], [-122.4742, 37.72523]]]} | Open Access 1 | 16307 | Junipero Serra Playground | 20533 | 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.545 | Junipero Serra Playground | 2000 | Local Recreation Area 3 | 4 | |
6953 | 6953 | 6952 | {"type": "Polygon", "coordinates": [[[-122.47276, 37.75963], [-122.47241, 37.75965], [-122.47242, 37.75992], [-122.47229, 37.75993], [-122.47227, 37.75965], [-122.47186, 37.75967], [-122.47184, 37.75949], [-122.47225, 37.75947], [-122.47223, 37.75917], [-122.47237, 37.75919], [-122.4724, 37.75955], [-122.47275, 37.75954], [-122.47276, 37.75963]]]} | Open Access 1 | 5859 | 15th Avenue Steps | 15174 | 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.516 | 15th Avenue Steps | None 568 | |||
15775 | 15775 | 15774 | {"type": "Polygon", "coordinates": [[[-122.47273, 37.75508], [-122.47255, 37.75526], [-122.47257, 37.75529], [-122.47226, 37.75545], [-122.47219, 37.75536], [-122.47216, 37.75526], [-122.47213, 37.75504], [-122.47212, 37.75467], [-122.47216, 37.75465], [-122.4722, 37.75466], [-122.47236, 37.75482], [-122.47273, 37.75508]]]} | Open Access 1 | 5588 | Grand View Pk. Open Space | 19427 | 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.642 | Grand View Pk. OS | 0 | Local Recreation Area 3 | 4 | |
2259 | 2259 | 2258 | {"type": "Polygon", "coordinates": [[[-122.4722, 37.75635], [-122.47194, 37.75665], [-122.4718, 37.75686], [-122.47157, 37.75675], [-122.47149, 37.75665], [-122.47146, 37.75655], [-122.47149, 37.75606], [-122.47155, 37.75595], [-122.47157, 37.75583], [-122.47177, 37.75593], [-122.47194, 37.75605], [-122.47205, 37.75617], [-122.4722, 37.75635]]]} | Open Access 1 | 16745 | Grand View Park | 19426 | 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.115 | Grand View Park | 0 | Local Park 2 | 4 | |
5317 | 5317 | 5316 | {"type": "Polygon", "coordinates": [[[-122.47094, 37.7547], [-122.4709, 37.75473], [-122.47059, 37.75472], [-122.47062, 37.75435], [-122.47054, 37.75434], [-122.47078, 37.75371], [-122.47082, 37.75334], [-122.47061, 37.75298], [-122.47089, 37.75284], [-122.47106, 37.7533], [-122.4711, 37.75353], [-122.47108, 37.75374], [-122.47096, 37.75406], [-122.47093, 37.75418], [-122.47096, 37.75451], [-122.47094, 37.7547]]]} | Open Access 1 | 5590 | Rock Outcropping | 24511 | 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.4 | Rock Outcropping | None 429 | |||
9667 | 9667 | 9666 | {"type": "Polygon", "coordinates": [[[-122.47063, 37.71782], [-122.46994, 37.71782], [-122.46993, 37.7172], [-122.47062, 37.7172], [-122.47063, 37.71782]]]} | Open Access 1 | 16309 | Merced Heights Playground | 22160 | 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.027 | Merced Heights Playground | 0 | Local Recreation Area 3 | 4 | |
9378 | 9378 | 9377 | {"type": "Polygon", "coordinates": [[[-122.47036, 37.7124], [-122.47027, 37.71248], [-122.47025, 37.71257], [-122.47006, 37.71256], [-122.46939, 37.71243], [-122.46939, 37.71226], [-122.47035, 37.71225], [-122.47036, 37.7124]]]} | Open Access 1 | 15676 | Brotherhood & Chester Mini Park | 16441 | 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.59 | Brotherhood & Chester MP | 0 | Local Park 2 | 4 | |
5312 | 5312 | 5311 | {"type": "Polygon", "coordinates": [[[-122.47017, 37.74701], [-122.46994, 37.74702], [-122.46993, 37.74705], [-122.46994, 37.74711], [-122.46989, 37.74716], [-122.46955, 37.74717], [-122.46952, 37.74707], [-122.46946, 37.74704], [-122.46939, 37.74704], [-122.46935, 37.74706], [-122.46933, 37.74713], [-122.46935, 37.74718], [-122.46892, 37.7472], [-122.46889, 37.74678], [-122.46846, 37.74672], [-122.46709, 37.74679], [-122.46707, 37.74656], [-122.46717, 37.74655], [-122.46717, 37.74647], [-122.46742, 37.74645], [-122.46742, 37.7464], [-122.46739, 37.74639], [-122.46739, 37.74612], [-122.46761, 37.74618], [-122.46795, 37.74616], [-122.46802, 37.74609], [-122.46892, 37.74615], [-122.46962, 37.74611], [-122.46966, 37.74667], [-122.47015, 37.74665], [-122.47017, 37.74701]]]} | Open Access 1 | 5584 | Hawk Hill Open Space | 19745 | 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.836 | Hawk Hill OS | 0 | Local Recreation Area 3 | 4 | |
2267 | 2267 | 2266 | {"type": "Polygon", "coordinates": [[[-122.46871, 37.75071], [-122.46863, 37.75066], [-122.46858, 37.7506], [-122.4685, 37.75044], [-122.46845, 37.75026], [-122.46847, 37.74986], [-122.46844, 37.7497], [-122.4684, 37.74959], [-122.4684, 37.74951], [-122.46844, 37.74939], [-122.46856, 37.74928], [-122.46867, 37.74925], [-122.46886, 37.74927], [-122.469, 37.7493], [-122.46927, 37.74943], [-122.46944, 37.74949], [-122.4696, 37.74951], [-122.4699, 37.74951], [-122.47004, 37.74953], [-122.47016, 37.74958], [-122.47025, 37.74964], [-122.47035, 37.74973], [-122.4704, 37.74982], [-122.47044, 37.74994], [-122.47045, 37.75002], [-122.47044, 37.75012], [-122.4704, 37.75021], [-122.47022, 37.75044], [-122.47001, 37.7506], [-122.46986, 37.75066], [-122.4697, 37.75069], [-122.46886, 37.75074], [-122.46871, 37.75071]]]} | Open Access 1 | 16728 | Golden Heights Park | 19362 | 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.623 | Golden Heights Park | 0 | Local Park 2 | 4 | |
7979 | 7979 | 7978 | {"type": "Polygon", "coordinates": [[[-122.46853, 37.78203], [-122.4677, 37.78207], [-122.46767, 37.78166], [-122.4685, 37.78162], [-122.46853, 37.78203]], [[-122.4682, 37.78188], [-122.46824, 37.78188], [-122.46824, 37.78181], [-122.46819, 37.7818], [-122.46818, 37.78172], [-122.46796, 37.78173], [-122.46798, 37.78197], [-122.4682, 37.78197], [-122.4682, 37.78188]]]} | Open Access 1 | 15960 | 10th Ave & Clement Mini Park | 15169 | 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.684 | 10th Ave & Clement MP | 0 | Local Park 2 | 4 | |
3160 | 3160 | 3159 | {"type": "Polygon", "coordinates": [[[-122.46792, 37.71714], [-122.46758, 37.71714], [-122.46758, 37.71755], [-122.46724, 37.71756], [-122.46726, 37.71785], [-122.46669, 37.71784], [-122.46667, 37.71757], [-122.46634, 37.71757], [-122.46634, 37.71784], [-122.46613, 37.71785], [-122.46612, 37.71756], [-122.46578, 37.71757], [-122.46578, 37.71695], [-122.46611, 37.71695], [-122.46612, 37.71687], [-122.46792, 37.71687], [-122.46792, 37.71714]]]} | Open Access 1 | 21835 | Brooks Park | 16429 | 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.73 | Brooks Park | 0 | Local Park 2 | 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 | |
863 | 863 | 862 | {"type": "Polygon", "coordinates": [[[-122.46596, 37.74109], [-122.46493, 37.74236], [-122.4645, 37.74212], [-122.46556, 37.74086], [-122.46583, 37.74099], [-122.46595, 37.74107], [-122.46596, 37.74109]]]} | Open Access 1 | 5574 | West Portal Playground | 27374 | 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.893 | West Portal Playground | 0 | Local Recreation Area 3 | 4 | |
5319 | 5319 | 5318 | {"type": "Polygon", "coordinates": [[[-122.46536, 37.75213], [-122.46453, 37.75217], [-122.46452, 37.75212], [-122.46486, 37.75138], [-122.46531, 37.75136], [-122.46536, 37.75213]]]} | Open Access 1 | 5593 | John P. Murphy Playground | 20461 | 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.226 | John P. Murphy Playground | 0 | Local Recreation Area 3 | 4 | |
1525 | 1525 | 1524 | {"type": "Polygon", "coordinates": [[[-122.46518, 37.78019], [-122.46486, 37.7802], [-122.46483, 37.77994], [-122.46516, 37.77993], [-122.46518, 37.78019]]]} | Open Access 1 | 15947 | Muriel Leff Mini Park | 22604 | 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.206 | Muriel Leff MP | 0 | Local Park 2 | 4 | |
9379 | 9379 | 9378 | {"type": "Polygon", "coordinates": [[[-122.46465, 37.71273], [-122.46449, 37.71287], [-122.46428, 37.71287], [-122.46371, 37.71242], [-122.46428, 37.71242], [-122.46465, 37.71273]]]} | Open Access 1 | 15678 | Head & Brotherhood Mini Park | 19766 | 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.551 | Head & Brotherhood MP | 0 | Local Park 2 | 4 | |
9380 | 9380 | 9379 | {"type": "Polygon", "coordinates": [[[-122.46378, 37.71461], [-122.46361, 37.71462], [-122.46361, 37.71441], [-122.46378, 37.71441], [-122.46378, 37.71461]]]} | Open Access 1 | 15680 | Randolph & Bright Mini Park | 24184 | 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.087 | Randolph & Bright MP | 0 | Local Park 2 | 4 | |
6950 | 6950 | 6949 | {"type": "Polygon", "coordinates": [[[-122.46373, 37.75952], [-122.46335, 37.75953], [-122.4635, 37.75925], [-122.46352, 37.75901], [-122.46337, 37.75867], [-122.46367, 37.75865], [-122.46373, 37.75952]]]} | Open Access 1 | 5849 | Slug's Garden For The Environment | 25560 | 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.507 | Slug's Garden For The Environment | None 567 |
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]);