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 MNG_AG_LEV
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 60
MNG_AGENCY 1
- San Francisco, City and County of · 60 ✖
DES_TP 1
- Local Recreation Area · 60 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2229 | 2229 | 2228 | {"type": "Polygon", "coordinates": [[[-122.41273, 37.75089], [-122.41188, 37.75094], [-122.41174, 37.74952], [-122.41259, 37.74946], [-122.41273, 37.75089]]]} | Open Access 1 | 16629 | Garfield Center | 19212 | 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.931 | Garfield Ctr. | 0 | Local Recreation Area 3 | 4 | |
2550 | 2550 | 2549 | {"type": "Polygon", "coordinates": [[[-122.4469, 37.72308], [-122.44688, 37.72368], [-122.44681, 37.72389], [-122.44654, 37.72452], [-122.44566, 37.72454], [-122.44567, 37.72508], [-122.44619, 37.72507], [-122.44618, 37.7251], [-122.44621, 37.72511], [-122.44606, 37.7253], [-122.44588, 37.72531], [-122.4454, 37.726], [-122.44534, 37.72599], [-122.445, 37.72648], [-122.44499, 37.72653], [-122.44503, 37.72655], [-122.44496, 37.72665], [-122.44181, 37.72667], [-122.44482, 37.72306], [-122.44674, 37.72306], [-122.4469, 37.72308]]]} | Open Access 1 | 17801 | Balboa Park & Pool | 15772 | 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 | 23.774 | Balboa Park & Pool | 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 |
4899 | 4899 | 4898 | {"type": "MultiPolygon", "coordinates": [[[[-122.47227, 37.75682], [-122.47215, 37.75701], [-122.47202, 37.75727], [-122.47195, 37.75729], [-122.47141, 37.75706], [-122.47129, 37.75698], [-122.4712, 37.7569], [-122.47111, 37.75678], [-122.47106, 37.75665], [-122.47105, 37.75655], [-122.47106, 37.75638], [-122.47147, 37.75639], [-122.47146, 37.75656], [-122.47151, 37.75669], [-122.47162, 37.75678], [-122.47179, 37.75685], [-122.47194, 37.75665], [-122.47227, 37.75682]]], [[[-122.47149, 37.75605], [-122.47147, 37.75632], [-122.47108, 37.75631], [-122.47109, 37.75604], [-122.47149, 37.75605]]], [[[-122.47257, 37.75623], [-122.47259, 37.75633], [-122.47257, 37.75647], [-122.47252, 37.75655], [-122.47232, 37.75676], [-122.47199, 37.75659], [-122.47219, 37.75636], [-122.4722, 37.75634], [-122.47197, 37.75608], [-122.47171, 37.7559], [-122.47192, 37.75563], [-122.47207, 37.75572], [-122.47224, 37.75585], [-122.47238, 37.756], [-122.47257, 37.75623]]]]} | Open Access 1 | 5586 | 14th & 15th Avenue Open Space | 15172 | 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.665 | 14th & 15th Avenue OS | 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 |
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 | |
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 | |
5372 | 5372 | 5371 | {"type": "Polygon", "coordinates": [[[-122.40691, 37.75001], [-122.40661, 37.75019], [-122.40662, 37.75036], [-122.40641, 37.75037], [-122.40626, 37.75063], [-122.40623, 37.75064], [-122.40551, 37.74928], [-122.40551, 37.74924], [-122.40555, 37.74921], [-122.40567, 37.74917], [-122.40642, 37.74905], [-122.4069, 37.74994], [-122.40691, 37.75001]]]} | Open Access 1 | 5698 | James Rolph Jr Playground | 20351 | 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.93 | James Rolph Jr 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 | |
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 | |
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 | |
6683 | 6683 | 6682 | {"type": "Polygon", "coordinates": [[[-122.44221, 37.75785], [-122.44216, 37.75851], [-122.44212, 37.75885], [-122.44209, 37.75891], [-122.44181, 37.75894], [-122.4418, 37.7589], [-122.44174, 37.7589], [-122.44172, 37.75871], [-122.4412, 37.75874], [-122.44119, 37.75863], [-122.44101, 37.75864], [-122.44097, 37.75825], [-122.44092, 37.75821], [-122.44121, 37.75818], [-122.44112, 37.75803], [-122.44123, 37.75795], [-122.44128, 37.75795], [-122.44133, 37.75792], [-122.44136, 37.75788], [-122.44136, 37.75784], [-122.44145, 37.75784], [-122.44148, 37.75754], [-122.44151, 37.75747], [-122.44166, 37.75749], [-122.44167, 37.75747], [-122.44221, 37.75785]]]} | Open Access 1 | 5597 | Kite Hill Open Space | 20679 | 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.896 | Kite Hill OS | 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 |
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 | |
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 | |
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 |
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]);