superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
48 rows where MNG_AGENCY = 334 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
3170 | 3170 | 3169 | {"type": "MultiPolygon", "coordinates": [[[[-122.27596, 37.89354], [-122.27586, 37.89366], [-122.27584, 37.89371], [-122.27585, 37.89377], [-122.27511, 37.89387], [-122.27507, 37.89372], [-122.27511, 37.89363], [-122.27563, 37.89339], [-122.27596, 37.89354]]], [[[-122.27628, 37.89224], [-122.2759, 37.8923], [-122.27586, 37.89215], [-122.2762, 37.89203], [-122.27628, 37.89224]]]]} | Open Access 1 | Contra Costa Rock Park | 17607 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.797 | Contra Costa Rock Park | ||
2724 | 2724 | 2723 | {"type": "MultiPolygon", "coordinates": [[[[-122.28752, 37.87599], [-122.28725, 37.87605], [-122.28715, 37.87596], [-122.28713, 37.87572], [-122.28682, 37.87573], [-122.28678, 37.87537], [-122.2871, 37.87534], [-122.28729, 37.87529], [-122.28748, 37.87597], [-122.28752, 37.87599]]], [[[-122.28896, 37.87675], [-122.28834, 37.87683], [-122.28753, 37.87713], [-122.28735, 37.87669], [-122.28731, 37.87669], [-122.28728, 37.87658], [-122.28701, 37.87625], [-122.28795, 37.87613], [-122.2887, 37.87599], [-122.28896, 37.87675]]], [[[-122.28849, 37.87805], [-122.28832, 37.87815], [-122.28786, 37.8772], [-122.28808, 37.87712], [-122.28849, 37.87805]]]]} | Open Access 1 | Cedar-Rose Park | 16993 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 4.39 | Cedar-Rose 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 | ||
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 | ||
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 | ||
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 | ||
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 | |
4596 | 4596 | 4595 | {"type": "Polygon", "coordinates": [[[-122.25774, 37.88464], [-122.25726, 37.88493], [-122.25739, 37.88519], [-122.25691, 37.88549], [-122.25685, 37.88573], [-122.25643, 37.8857], [-122.25602, 37.88557], [-122.25569, 37.88579], [-122.25532, 37.88598], [-122.25516, 37.88565], [-122.25496, 37.88537], [-122.25538, 37.88519], [-122.25545, 37.88514], [-122.25551, 37.88502], [-122.25603, 37.88507], [-122.25599, 37.88491], [-122.25603, 37.88484], [-122.25616, 37.88472], [-122.2561, 37.88432], [-122.25625, 37.88422], [-122.25663, 37.88411], [-122.25673, 37.88439], [-122.25731, 37.88446], [-122.25737, 37.88452], [-122.25744, 37.88455], [-122.25774, 37.88464]]]} | Open Access 1 | Glendale-La Loma Park | 19328 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 5.562 | Glendale-La Loma 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 | ||
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 | ||
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 | ||
3068 | 3068 | 3067 | {"type": "Polygon", "coordinates": [[[-122.26258, 37.88547], [-122.26237, 37.8863], [-122.26221, 37.88666], [-122.26143, 37.88675], [-122.25973, 37.88486], [-122.26012, 37.88438], [-122.26035, 37.88448], [-122.26057, 37.88454], [-122.26107, 37.88455], [-122.26117, 37.88485], [-122.26152, 37.88524], [-122.26258, 37.88547]]]} | Open Access 1 | Codornices Park | 17472 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 8.166 | Codornices Park | ||
1961 | 1961 | 1960 | {"type": "Polygon", "coordinates": [[[-122.26391, 37.88599], [-122.26266, 37.88616], [-122.2625, 37.8864], [-122.26289, 37.88481], [-122.26282, 37.88437], [-122.26317, 37.88425], [-122.2638, 37.88541], [-122.26391, 37.88599]]]} | Open Access 1 | Berkeley Rose Garden | 16023 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 3.773 | Berkeley Rose Garden | ||
3281 | 3281 | 3280 | {"type": "Polygon", "coordinates": [[[-122.26432, 37.89274], [-122.26374, 37.89276], [-122.26368, 37.89267], [-122.26357, 37.89259], [-122.26342, 37.89257], [-122.2632, 37.89261], [-122.26308, 37.89222], [-122.26322, 37.89218], [-122.26319, 37.89206], [-122.26363, 37.8914], [-122.26382, 37.89131], [-122.26419, 37.89143], [-122.26426, 37.89149], [-122.26433, 37.89244], [-122.26432, 37.89274]]]} | Open Access 1 | Cragmont Rock Park | 17751 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 3.161 | Cragmont Rock 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 | ||
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 |
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]);