superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
48 rows where MNG_AGENCY = 334 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15582 | 15582 | 15581 | {"type": "Polygon", "coordinates": [[[-122.27265, 37.86963], [-122.27067, 37.86986], [-122.27054, 37.86916], [-122.27257, 37.86887], [-122.27265, 37.86963]], [[-122.27119, 37.86973], [-122.27121, 37.86971], [-122.27111, 37.86918], [-122.27062, 37.86925], [-122.27073, 37.86978], [-122.27119, 37.86973]]]} | Open Access 1 | MLK Memorial Park (Civic Center) | 22335 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 2.966 | MLK Memorial Park (Civic Ctr.) | ||
12230 | 12230 | 12229 | {"type": "Polygon", "coordinates": [[[-122.31005, 37.87748], [-122.30815, 37.87787], [-122.30808, 37.87786], [-122.30785, 37.87763], [-122.30714, 37.87584], [-122.30661, 37.87435], [-122.30873, 37.87383], [-122.31005, 37.87748]]]} | Open Access 1 | Tom Bates Regional Sports Complex | http://www.ci.berkeley.ca.us/Mayor/Home/Recreation_in_Berkeley.aspx | 29211 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 19.934 | Tom Bates Reg. Sports Complex | |
11231 | 11231 | 11230 | {"type": "Polygon", "coordinates": [[[-122.25709, 37.86151], [-122.25606, 37.86156], [-122.25599, 37.86047], [-122.2565, 37.86041], [-122.25652, 37.86056], [-122.25701, 37.86054], [-122.25709, 37.86151]]]} | Open Access 1 | Willard Park | 27533 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 2.568 | Willard Park | ||
10292 | 10292 | 10291 | {"type": "Polygon", "coordinates": [[[-122.25109, 37.88399], [-122.25098, 37.88403], [-122.25095, 37.88414], [-122.25102, 37.88425], [-122.25074, 37.8844], [-122.25034, 37.88441], [-122.25018, 37.88419], [-122.25017, 37.8839], [-122.25055, 37.88386], [-122.25057, 37.88393], [-122.25104, 37.88389], [-122.25109, 37.88399]]]} | Open Access 1 | Terrace View Park | 26263 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.937 | Terrace View Park | ||
10019 | 10019 | 10018 | {"type": "Polygon", "coordinates": [[[-122.28683, 37.86871], [-122.28622, 37.86879], [-122.28586, 37.86533], [-122.28611, 37.8653], [-122.28644, 37.86693], [-122.28642, 37.86695], [-122.28644, 37.8671], [-122.28631, 37.86711], [-122.2863, 37.86713], [-122.28641, 37.86749], [-122.28649, 37.86769], [-122.28655, 37.8677], [-122.28662, 37.86801], [-122.28668, 37.86802], [-122.28683, 37.86871]]]} | Open Access 1 | Strawberry Creek Park | 25914 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 3.301 | Strawberry Creek 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 | ||
9610 | 9610 | 9609 | {"type": "Polygon", "coordinates": [[[-122.31711, 37.86278], [-122.3171, 37.86281], [-122.31611, 37.86324], [-122.31507, 37.86344], [-122.3148, 37.86274], [-122.31527, 37.86254], [-122.31554, 37.86225], [-122.3156, 37.86207], [-122.31596, 37.86155], [-122.31683, 37.86173], [-122.31711, 37.86278]]]} | Open Access 1 | Shorebird Park | 25420 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 6.277 | Shorebird 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);