superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
240 rows where MNG_AGENCY = 21
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
- Open Access 198
- Restricted Access 2
MNG_AG_TYP 1
- City Agency 200
MNG_AGENCY 1
- San Francisco, City and County of · 200 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2240 | 2240 | 2239 | {"type": "Polygon", "coordinates": [[[-122.40744, 37.74501], [-122.40737, 37.7452], [-122.40686, 37.74507], [-122.40694, 37.74488], [-122.40744, 37.74501]]]} | Open Access 1 | Brewster Cmmunity Garden | 16369 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.26 | Brewster Cmmunity Garden | ||
2268 | 2268 | 2267 | {"type": "Polygon", "coordinates": [[[-122.41296, 37.79709], [-122.41291, 37.7971], [-122.41288, 37.79701], [-122.41284, 37.797], [-122.41282, 37.79693], [-122.41292, 37.79692], [-122.41296, 37.79709]]]} | Open Access 1 | Broadway Tunnel east Mini Park | 16410 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.033 | Broadway Tunnel east MP | ||
2269 | 2269 | 2268 | {"type": "Polygon", "coordinates": [[[-122.41762, 37.79648], [-122.41725, 37.79653], [-122.41722, 37.79639], [-122.4176, 37.79634], [-122.41762, 37.79648]]]} | Open Access 1 | Broadway Tunnel West Mini Park | 16411 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.125 | Broadway Tunnel West MP | ||
2285 | 2285 | 2284 | {"type": "Polygon", "coordinates": [[[-122.46792, 37.71714], [-122.46758, 37.71715], [-122.46758, 37.71755], [-122.46724, 37.71756], [-122.46726, 37.71785], [-122.46669, 37.71784], [-122.46666, 37.71757], [-122.46635, 37.71757], [-122.46634, 37.71784], [-122.46613, 37.71785], [-122.46612, 37.71757], [-122.46578, 37.71757], [-122.46578, 37.71695], [-122.4661, 37.71695], [-122.46612, 37.71687], [-122.46792, 37.71687], [-122.46792, 37.71714]]]} | Open Access 1 | Brooks Park | 16429 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3.742 | Brooks Park | ||
2323 | 2323 | 2322 | {"type": "MultiPolygon", "coordinates": [[[[-122.42838, 37.77801], [-122.42815, 37.77804], [-122.42806, 37.77759], [-122.42829, 37.77756], [-122.42838, 37.77801]]], [[[-122.42857, 37.77894], [-122.42834, 37.77897], [-122.42819, 37.77823], [-122.42842, 37.7782], [-122.42857, 37.77894]]], [[[-122.42876, 37.77987], [-122.42853, 37.7799], [-122.42838, 37.77916], [-122.42861, 37.77913], [-122.42876, 37.77987]]], [[[-122.42895, 37.78081], [-122.42872, 37.78084], [-122.42857, 37.78009], [-122.4288, 37.78006], [-122.42895, 37.78081]]], [[[-122.42907, 37.78141], [-122.42884, 37.78144], [-122.42875, 37.78102], [-122.42899, 37.78099], [-122.42907, 37.78141]]]]} | Open Access 1 | Buchanan Street Mall | 16470 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.812 | Buchanan Street Mall | ||
2343 | 2343 | 2342 | {"type": "Polygon", "coordinates": [[[-122.44374, 37.76757], [-122.4436, 37.76795], [-122.44361, 37.76797], [-122.44326, 37.76884], [-122.44222, 37.7695], [-122.44226, 37.76963], [-122.4424, 37.76978], [-122.44259, 37.76978], [-122.44281, 37.76981], [-122.44298, 37.76997], [-122.44309, 37.77012], [-122.44316, 37.77039], [-122.44062, 37.77072], [-122.43988, 37.77049], [-122.43983, 37.77049], [-122.43959, 37.77036], [-122.43939, 37.76998], [-122.43915, 37.7698], [-122.43906, 37.76971], [-122.43904, 37.7697], [-122.43845, 37.7691], [-122.43892, 37.76848], [-122.44026, 37.76782], [-122.44072, 37.76703], [-122.44207, 37.76601], [-122.4424, 37.76602], [-122.4427, 37.7661], [-122.44291, 37.76625], [-122.44295, 37.76637], [-122.44296, 37.76638], [-122.44298, 37.76649], [-122.44345, 37.76678], [-122.44363, 37.7671], [-122.44374, 37.76757]]]} | Open Access 1 | Buena Vista Park | 16492 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 36.125 | Buena Vista Park | ||
2434 | 2434 | 2433 | {"type": "Polygon", "coordinates": [[[-122.41252, 37.7925], [-122.41194, 37.79257], [-122.41179, 37.79183], [-122.41237, 37.79176], [-122.41252, 37.7925]]]} | Open Access 1 | Collins P. Huntington Park | 17522 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.069 | Collins P. Huntington Park | ||
2471 | 2471 | 2470 | {"type": "Polygon", "coordinates": [[[-122.39784, 37.75746], [-122.39715, 37.7575], [-122.39713, 37.75732], [-122.39782, 37.75728], [-122.39784, 37.75746]]]} | Open Access 1 | Connecticut Friendship Garden | 17590 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.302 | Connecticut Friendship Garden | ||
2514 | 2514 | 2513 | {"type": "Polygon", "coordinates": [[[-122.41556, 37.75767], [-122.41516, 37.75769], [-122.41515, 37.75777], [-122.41473, 37.7578], [-122.41469, 37.75738], [-122.41553, 37.75733], [-122.41556, 37.75767]]]} | Open Access 1 | Coronado Playground | 17650 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.784 | Coronado Playground | ||
2526 | 2526 | 2525 | {"type": "Polygon", "coordinates": [[[-122.43912, 37.75734], [-122.43895, 37.75734], [-122.43893, 37.75709], [-122.43911, 37.75715], [-122.43912, 37.75734]]]} | Open Access 1 | Corwin Community Garden | 17668 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.092 | Corwin Community Garden | ||
2717 | 2717 | 2716 | {"type": "Polygon", "coordinates": [[[-122.45124, 37.71372], [-122.45007, 37.71466], [-122.44956, 37.71426], [-122.44988, 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 | Cayuga Playground | 16986 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 2.921 | Cayuga Playground | ||
2726 | 2726 | 2725 | {"type": "Polygon", "coordinates": [[[-122.43308, 37.73045], [-122.43291, 37.7305], [-122.4328, 37.73023], [-122.43296, 37.73017], [-122.43308, 37.73045]]]} | Open Access 1 | Cayuga & Lamartine Mini Park | 16985 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.126 | Cayuga & Lamartine MP | ||
2884 | 2884 | 2883 | {"type": "Polygon", "coordinates": [[[-122.43454, 37.73883], [-122.43413, 37.73884], [-122.43411, 37.73877], [-122.43447, 37.73876], [-122.43454, 37.73883]]]} | Open Access 1 | Diamond & Farnum Open Space | 18138 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.069 | Diamond & Farnum OS | ||
2897 | 2897 | 2896 | {"type": "Polygon", "coordinates": [[[-122.40734, 37.80463], [-122.40687, 37.80468], [-122.40687, 37.80464], [-122.40733, 37.80459], [-122.40734, 37.80463]]]} | Open Access 1 | Chesnut/kearny Mini Park | 17178 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.047 | Chesnut/kearny MP | ||
2925 | 2925 | 2924 | {"type": "MultiPolygon", "coordinates": [[[[-122.43655, 37.74183], [-122.43609, 37.74212], [-122.43591, 37.74177], [-122.43576, 37.74145], [-122.43637, 37.74138], [-122.43643, 37.74159], [-122.43655, 37.74183]]], [[[-122.44184, 37.74352], [-122.44069, 37.74385], [-122.44059, 37.7446], [-122.44084, 37.74464], [-122.44076, 37.74518], [-122.4407, 37.74518], [-122.44075, 37.74468], [-122.44026, 37.74463], [-122.44002, 37.74493], [-122.43977, 37.74469], [-122.43946, 37.74449], [-122.43998, 37.74454], [-122.44011, 37.74356], [-122.43989, 37.74352], [-122.43991, 37.74317], [-122.43935, 37.74312], [-122.43933, 37.74316], [-122.43896, 37.74314], [-122.43797, 37.74339], [-122.43798, 37.74332], [-122.43824, 37.74325], [-122.43822, 37.74317], [-122.43911, 37.74297], [-122.44001, 37.74296], [-122.44081, 37.74269], [-122.4411, 37.7425], [-122.44124, 37.74231], [-122.44147, 37.74247], [-122.44184, 37.74352]]], [[[-122.44096, 37.7415], [-122.44084, 37.74172], [-122.44057, 37.74162], [-122.44062, 37.74158], [-122.44063, 37.74154], [-122.44062, 37.74148], [-122.44059, 37.74145], [-122.44054, 37.74143], [-122.44044, 37.74142], [-122.44033, 37.74136], [-122.44056, 37.74112], [-122.44065, 37.74117], [-122.44096, 37.7415]]]]} | Open Access 1 | Christopher Playground | 17234 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 8.108 | Christopher Playground | ||
3025 | 3025 | 3024 | {"type": "Polygon", "coordinates": [[[-122.44339, 37.74797], [-122.44285, 37.74806], [-122.44281, 37.74805], [-122.44331, 37.74755], [-122.44337, 37.74755], [-122.44339, 37.74797]]]} | Open Access 1 | Clipper Terrace Community Garden | 17430 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.341 | Clipper Terrace Community Garden | ||
3085 | 3085 | 3084 | {"type": "Polygon", "coordinates": [[[-122.41995, 37.74444], [-122.41985, 37.74459], [-122.41939, 37.7444], [-122.41948, 37.74426], [-122.41995, 37.74444]]]} | Open Access 1 | Coleridge Mini Park | 17494 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.207 | Coleridge MP | ||
3190 | 3190 | 3189 | {"type": "Polygon", "coordinates": [[[-122.44103, 37.7653], [-122.44099, 37.76535], [-122.44043, 37.76533], [-122.43933, 37.76616], [-122.43843, 37.76591], [-122.4383, 37.76616], [-122.43775, 37.766], [-122.43785, 37.76574], [-122.43735, 37.76559], [-122.43727, 37.76546], [-122.43697, 37.76555], [-122.43688, 37.76537], [-122.43716, 37.76528], [-122.43712, 37.76518], [-122.43724, 37.76513], [-122.43676, 37.76425], [-122.43715, 37.76409], [-122.43731, 37.76407], [-122.43735, 37.76382], [-122.43764, 37.76378], [-122.43795, 37.76371], [-122.43826, 37.76361], [-122.43856, 37.76345], [-122.43912, 37.76354], [-122.43883, 37.76392], [-122.43888, 37.76396], [-122.43884, 37.76402], [-122.43888, 37.7641], [-122.43893, 37.76412], [-122.43907, 37.76412], [-122.4392, 37.76415], [-122.43992, 37.76449], [-122.44061, 37.76483], [-122.44071, 37.7649], [-122.44079, 37.76497], [-122.441, 37.76521], [-122.44103, 37.7653]]]} | Open Access 1 | Corona Hts. & Randall Museum | 17642 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 15.821 | Corona Hts. & Randall Museum | ||
3207 | 3207 | 3206 | {"type": "Polygon", "coordinates": [[[-122.4154, 37.74429], [-122.41519, 37.74462], [-122.41503, 37.74455], [-122.41523, 37.74423], [-122.4154, 37.74429]]]} | Open Access 1 | Coso St (vacated Portion) | 17671 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.157 | Coso St (vacated Portion) | ||
3213 | 3213 | 3212 | {"type": "Polygon", "coordinates": [[[-122.41826, 37.74659], [-122.41791, 37.74603], [-122.41793, 37.74602], [-122.4182, 37.74613], [-122.41826, 37.74659]]]} | Open Access 1 | Coso & Precita Mini Park | 17670 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.161 | Coso & Precita MP |
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]);