superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
48 rows where MNG_AGENCY = 334 and MNG_AG_TYP = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8395 | 8395 | 8394 | {"type": "Polygon", "coordinates": [[[-122.27936, 37.86825], [-122.27929, 37.86825], [-122.27918, 37.86821], [-122.27913, 37.86816], [-122.27913, 37.86811], [-122.27916, 37.86803], [-122.27934, 37.86801], [-122.27936, 37.86825]]]} | Open Access 1 | Presentation Mini-Park | 23986 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.107 | Presentation Mini-Park | ||
4954 | 4954 | 4953 | {"type": "Polygon", "coordinates": [[[-122.28378, 37.85123], [-122.28342, 37.85131], [-122.28339, 37.85118], [-122.28374, 37.8511], [-122.28378, 37.85123]]]} | Open Access 1 | Haskell-Mabel Mini-Park | 19730 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.121 | Haskell-Mabel Mini-Park | ||
6649 | 6649 | 6648 | {"type": "Polygon", "coordinates": [[[-122.31388, 37.86408], [-122.31367, 37.86412], [-122.31358, 37.8639], [-122.31381, 37.86386], [-122.31388, 37.86408]]]} | Open Access 1 | Marina Mall | 21830 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.124 | Marina Mall | ||
8399 | 8399 | 8398 | {"type": "Polygon", "coordinates": [[[-122.27535, 37.85238], [-122.27518, 37.8524], [-122.2751, 37.85204], [-122.27528, 37.85202], [-122.27535, 37.85238]]]} | Open Access 1 | Prince Street Mini-Park | 24009 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.155 | Prince Street Mini-Park | ||
1888 | 1888 | 1887 | {"type": "Polygon", "coordinates": [[[-122.27617, 37.86371], [-122.27573, 37.86377], [-122.27571, 37.86363], [-122.27616, 37.86357], [-122.27617, 37.86371]]]} | Open Access 1 | Becky Temko Tot Park | 15947 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.159 | Becky Temko Tot Park | ||
64 | 64 | 63 | {"type": "Polygon", "coordinates": [[[-122.27515, 37.84778], [-122.27496, 37.84781], [-122.27489, 37.84744], [-122.27507, 37.84741], [-122.27515, 37.84778]]]} | Open Access 1 | 63rd Street Mini-Park | 15208 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.164 | 63rd Street Mini-Park | ||
9758 | 9758 | 9757 | {"type": "Polygon", "coordinates": [[[-122.28567, 37.89136], [-122.28542, 37.8914], [-122.28541, 37.8911], [-122.28565, 37.8911], [-122.28567, 37.89136]]]} | Open Access 1 | Solano-Peralta Park | 25595 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.168 | Solano-Peralta Park | ||
4770 | 4770 | 4769 | {"type": "Polygon", "coordinates": [[[-122.25586, 37.89036], [-122.2558, 37.89045], [-122.25581, 37.89051], [-122.25536, 37.89042], [-122.25548, 37.89021], [-122.25586, 37.89036]]]} | Open Access 1 | Grizzly Peak Park | 19525 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.201 | Grizzly Peak Park | ||
2854 | 2854 | 2853 | {"type": "Polygon", "coordinates": [[[-122.28448, 37.86652], [-122.28395, 37.86659], [-122.28393, 37.86645], [-122.28427, 37.86641], [-122.28428, 37.86631], [-122.28444, 37.86629], [-122.28448, 37.86652]]]} | Open Access 1 | Charlie Dorr Mini-Park | 17145 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.215 | Charlie Dorr Mini-Park | ||
4838 | 4838 | 4837 | {"type": "Polygon", "coordinates": [[[-122.26108, 37.85436], [-122.26107, 37.85438], [-122.26102, 37.8544], [-122.26095, 37.85439], [-122.26093, 37.85437], [-122.26082, 37.85384], [-122.26094, 37.85381], [-122.26098, 37.85384], [-122.26108, 37.85436]]]} | Open Access 1 | Halcyon Commons | 19600 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.219 | Halcyon Commons | ||
7579 | 7579 | 7578 | {"type": "Polygon", "coordinates": [[[-122.24374, 37.85662], [-122.24374, 37.85706], [-122.24373, 37.85708], [-122.24362, 37.857], [-122.24337, 37.85676], [-122.24374, 37.85662]]]} | Open Access 1 | Oak Park | 22996 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.22 | Oak Park | ||
4390 | 4390 | 4389 | {"type": "Polygon", "coordinates": [[[-122.27571, 37.89517], [-122.27556, 37.89526], [-122.27538, 37.89532], [-122.27525, 37.89499], [-122.27526, 37.89494], [-122.2753, 37.89493], [-122.27538, 37.89495], [-122.27571, 37.89517]]]} | Open Access 1 | Frederick Mini-Park | 19079 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.227 | Frederick Mini-Park | ||
7226 | 7226 | 7225 | {"type": "Polygon", "coordinates": [[[-122.27253, 37.89338], [-122.27244, 37.89343], [-122.27237, 37.89343], [-122.2722, 37.89338], [-122.27214, 37.89329], [-122.27214, 37.89319], [-122.27223, 37.89311], [-122.2723, 37.89308], [-122.27245, 37.8931], [-122.2725, 37.89313], [-122.27256, 37.89321], [-122.27256, 37.89324], [-122.27253, 37.89338]]]} | Open Access 1 | Mortar Rock Park | 22508 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.277 | Mortar Rock Park | ||
1962 | 1962 | 1961 | {"type": "Polygon", "coordinates": [[[-122.28721, 37.87045], [-122.28672, 37.87051], [-122.28669, 37.87023], [-122.28717, 37.87016], [-122.28721, 37.87045]]]} | Open Access 1 | Berkeley Way Mini-Park | 16024 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.336 | Berkeley Way Mini-Park | ||
9346 | 9346 | 9345 | {"type": "Polygon", "coordinates": [[[-122.27852, 37.87529], [-122.27812, 37.87534], [-122.27807, 37.87497], [-122.27847, 37.87492], [-122.27852, 37.87529]]]} | Open Access 1 | Virginia-McGee Totland | 27153 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.364 | Virginia-McGee Totland | ||
4775 | 4775 | 4774 | {"type": "Polygon", "coordinates": [[[-122.26908, 37.89341], [-122.26876, 37.89357], [-122.26864, 37.89342], [-122.26857, 37.89344], [-122.26853, 37.89338], [-122.26849, 37.8933], [-122.26852, 37.89326], [-122.2685, 37.89322], [-122.26881, 37.89306], [-122.26908, 37.89341]]]} | Open Access 1 | Grotto Rock Park | 19531 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.39 | Grotto Rock Park | ||
7108 | 7108 | 7107 | {"type": "MultiPolygon", "coordinates": [[[[-122.24665, 37.86071], [-122.24596, 37.86076], [-122.24595, 37.86072], [-122.24664, 37.86068], [-122.24665, 37.86071]]], [[[-122.24725, 37.86105], [-122.24713, 37.86109], [-122.24707, 37.86114], [-122.24706, 37.86117], [-122.24708, 37.86119], [-122.247, 37.86116], [-122.24705, 37.86103], [-122.24704, 37.86097], [-122.24699, 37.86093], [-122.24689, 37.86093], [-122.24684, 37.86097], [-122.24683, 37.861], [-122.24684, 37.86106], [-122.24678, 37.86106], [-122.24675, 37.86089], [-122.24668, 37.86083], [-122.24676, 37.86078], [-122.24684, 37.86068], [-122.24711, 37.86066], [-122.24719, 37.8607], [-122.24722, 37.86075], [-122.24722, 37.86087], [-122.24718, 37.86094], [-122.24722, 37.86096], [-122.24725, 37.86105]]]]} | Open Access 1 | Monkey Island Park | 22370 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.449 | Monkey Island Park | ||
4714 | 4714 | 4713 | {"type": "Polygon", "coordinates": [[[-122.26995, 37.85041], [-122.26969, 37.85044], [-122.26974, 37.85071], [-122.26961, 37.85073], [-122.26955, 37.85047], [-122.26943, 37.85047], [-122.26938, 37.85024], [-122.26935, 37.85022], [-122.26929, 37.84994], [-122.26938, 37.84995], [-122.26945, 37.85022], [-122.2698, 37.85016], [-122.26982, 37.85021], [-122.26991, 37.85021], [-122.26995, 37.85041]]]} | Open Access 1 | Greg Brown Mini-Park | 19496 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.472 | Greg Brown Mini-Park | ||
4539 | 4539 | 4538 | {"type": "Polygon", "coordinates": [[[-122.2926, 37.86705], [-122.29215, 37.86714], [-122.29201, 37.86671], [-122.29246, 37.86662], [-122.2926, 37.86705]]]} | Open Access 1 | George Florence Park | 19264 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.498 | George Florence Park | ||
1800 | 1800 | 1799 | {"type": "Polygon", "coordinates": [[[-122.2576, 37.85453], [-122.25701, 37.8546], [-122.25693, 37.85425], [-122.25731, 37.8542], [-122.25728, 37.85399], [-122.25749, 37.85396], [-122.2576, 37.85453]]]} | Open Access 1 | Bateman Mall Park | http://www.ci.berkeley.ca.us/Parks_Rec_Waterfront/Trees_Parks/Parks__Bateman_Mall_Park.aspx | 15860 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.638 | Bateman Mall Park |
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]);