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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
4776 | 4776 | 4775 | {"type": "Polygon", "coordinates": [[[-122.27334, 37.85676], [-122.27149, 37.857], [-122.27139, 37.85619], [-122.27273, 37.856], [-122.27282, 37.85647], [-122.27328, 37.85643], [-122.27334, 37.85676]]]} | Open Access 1 | Grove Park | 19532 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 3.138 | Grove 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 | ||
4923 | 4923 | 4922 | {"type": "Polygon", "coordinates": [[[-122.30547, 37.88206], [-122.30345, 37.88227], [-122.30303, 37.88106], [-122.30406, 37.88082], [-122.30423, 37.88128], [-122.30516, 37.88112], [-122.30547, 37.88206]]]} | Open Access 1 | Harrison Park | 19701 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 5.586 | Harrison 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 | ||
5344 | 5344 | 5343 | {"type": "MultiPolygon", "coordinates": [[[[-122.27271, 37.89249], [-122.2725, 37.89253], [-122.27234, 37.89249], [-122.27219, 37.8924], [-122.2721, 37.89229], [-122.27206, 37.89218], [-122.27214, 37.89191], [-122.27236, 37.8919], [-122.27267, 37.89224], [-122.27272, 37.89238], [-122.27271, 37.89249]]], [[[-122.27326, 37.89212], [-122.27318, 37.89227], [-122.27304, 37.89239], [-122.27295, 37.89243], [-122.27288, 37.89239], [-122.27287, 37.89228], [-122.27276, 37.89208], [-122.27256, 37.89188], [-122.27258, 37.89186], [-122.27281, 37.89195], [-122.27298, 37.89199], [-122.27317, 37.89201], [-122.27324, 37.89206], [-122.27326, 37.89212]]]]} | Open Access 1 | Indian Rock Park | 20206 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1.092 | Indian Rock Park | ||
5475 | 5475 | 5474 | {"type": "Polygon", "coordinates": [[[-122.2979, 37.87249], [-122.29699, 37.87267], [-122.29647, 37.87108], [-122.29739, 37.8709], [-122.2979, 37.87249]]]} | Open Access 1 | James Kenney Park | 20346 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 3.73 | James Kenney Park | ||
5559 | 5559 | 5558 | {"type": "Polygon", "coordinates": [[[-122.27444, 37.89519], [-122.27417, 37.89538], [-122.27391, 37.89529], [-122.2737, 37.89563], [-122.27328, 37.89562], [-122.27322, 37.89555], [-122.27314, 37.89555], [-122.27307, 37.89558], [-122.27303, 37.89563], [-122.27288, 37.89568], [-122.2723, 37.89578], [-122.27221, 37.89577], [-122.27216, 37.89568], [-122.27238, 37.89533], [-122.27247, 37.89512], [-122.27246, 37.89494], [-122.27243, 37.89486], [-122.27231, 37.89469], [-122.27177, 37.89431], [-122.27166, 37.89417], [-122.27164, 37.89411], [-122.27165, 37.89403], [-122.27209, 37.89415], [-122.27226, 37.89424], [-122.27231, 37.89432], [-122.2728, 37.8945], [-122.27305, 37.89474], [-122.273, 37.89482], [-122.27301, 37.89505], [-122.27292, 37.89509], [-122.27289, 37.89512], [-122.27291, 37.89517], [-122.27296, 37.89521], [-122.27305, 37.89517], [-122.27308, 37.8951], [-122.2731, 37.89487], [-122.27317, 37.89479], [-122.27361, 37.89479], [-122.2737, 37.89472], [-122.27397, 37.89471], [-122.27409, 37.89486], [-122.27444, 37.89519]]]} | Open Access 1 | John Hinkel Park | 20445 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 4.63 | John Hinkel Park | ||
6293 | 6293 | 6292 | {"type": "MultiPolygon", "coordinates": [[[[-122.2686, 37.88461], [-122.26813, 37.88468], [-122.26811, 37.88457], [-122.268, 37.88458], [-122.26798, 37.88449], [-122.26764, 37.88453], [-122.26763, 37.88441], [-122.26774, 37.88417], [-122.26853, 37.88408], [-122.2686, 37.88461]]], [[[-122.26976, 37.88488], [-122.26883, 37.88501], [-122.26864, 37.88323], [-122.26914, 37.88318], [-122.26916, 37.88333], [-122.2696, 37.88328], [-122.26976, 37.88488]]]]} | Open Access 1 | Live Oak Park | 21367 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 4.891 | Live Oak 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 | ||
6862 | 6862 | 6861 | {"type": "Polygon", "coordinates": [[[-122.25797, 37.86601], [-122.25644, 37.86621], [-122.25629, 37.86549], [-122.25782, 37.86528], [-122.25797, 37.86601]]]} | Open Access 1 | Peoples Park | 23591 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 2.748 | Peoples 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 | ||
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 | ||
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 | ||
7641 | 7641 | 7640 | {"type": "MultiPolygon", "coordinates": [[[[-122.27199, 37.87379], [-122.27177, 37.87382], [-122.27178, 37.8739], [-122.27165, 37.87392], [-122.27164, 37.87396], [-122.27136, 37.87399], [-122.27134, 37.87394], [-122.27122, 37.87395], [-122.27119, 37.87391], [-122.27107, 37.87392], [-122.27103, 37.87367], [-122.27198, 37.87355], [-122.27199, 37.87379]]], [[[-122.28213, 37.87365], [-122.28187, 37.87366], [-122.28185, 37.87357], [-122.28146, 37.87361], [-122.2814, 37.87309], [-122.28045, 37.87319], [-122.28041, 37.87303], [-122.28011, 37.87305], [-122.28008, 37.87294], [-122.2799, 37.8729], [-122.27805, 37.87313], [-122.27803, 37.87303], [-122.27732, 37.87312], [-122.27732, 37.87323], [-122.27698, 37.87325], [-122.27696, 37.8733], [-122.27681, 37.87333], [-122.27679, 37.87329], [-122.27563, 37.87344], [-122.27539, 37.8734], [-122.27507, 37.87344], [-122.27506, 37.87354], [-122.27491, 37.87355], [-122.27489, 37.87359], [-122.27474, 37.8736], [-122.2747, 37.87356], [-122.27388, 37.87367], [-122.27387, 37.87377], [-122.27372, 37.87378], [-122.27369, 37.87358], [-122.27334, 37.87363], [-122.2733, 37.87337], [-122.27981, 37.87255], [-122.28015, 37.87262], [-122.2804, 37.87258], [-122.28044, 37.87266], [-122.28078, 37.8728], [-122.28173, 37.87265], [-122.28178, 37.87275], [-122.28202, 37.87272], [-122.28213, 37.87365]]]]} | Open Access 1 | Ohlone Park | 23076 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 9.1 | Ohlone Park | ||
7825 | 7825 | 7824 | {"type": "Polygon", "coordinates": [[[-122.28504, 37.85717], [-122.28351, 37.85736], [-122.28295, 37.85454], [-122.28305, 37.85439], [-122.28423, 37.85419], [-122.28441, 37.85427], [-122.28451, 37.85437], [-122.28504, 37.85717]]]} | Open Access 1 | San Pablo Park | 24969 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 11.359 | San Pablo Park | ||
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 | ||
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 | ||
8636 | 8636 | 8635 | {"type": "Polygon", "coordinates": [[[-122.26203, 37.89212], [-122.262, 37.89225], [-122.26142, 37.89218], [-122.26142, 37.89247], [-122.26129, 37.89255], [-122.26122, 37.89246], [-122.26101, 37.89238], [-122.26084, 37.89239], [-122.26057, 37.8925], [-122.26054, 37.8925], [-122.26023, 37.8921], [-122.2609, 37.89179], [-122.26128, 37.89144], [-122.26134, 37.89148], [-122.26112, 37.89169], [-122.26125, 37.89195], [-122.26139, 37.89201], [-122.26203, 37.89212]]]} | Open Access 1 | Remillard Park | 24288 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1.749 | Remillard 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]);