units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
49 rows where MNG_AGENCY = 334 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LABEL_NAME
DES_TP 6
- Local Park 43
- Local Recreation Area 2
- None 1
- None 1
- None 1
- None 1
LAYER 2 ✖
- City 48
- Special District 1
MNG_AG_TYP 1
- City Agency 49
MNG_AGENCY 1
- Berkeley, City of · 49 ✖
ACCESS_TYP 1
- Open Access 49
Link | rowid | id | map | ACCESS_TYP | UNIT_ID ▼ | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8617 | 8617 | 8616 | {"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 | 13758 | Shorebird Park | 25420 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 6.277 | Shorebird Park | 0 | Local Park 2 | 4 | |
8613 | 8613 | 8612 | {"type": "Polygon", "coordinates": [[[-122.3248, 37.87452], [-122.32475, 37.8746], [-122.32465, 37.87464], [-122.32345, 37.87487], [-122.32323, 37.87495], [-122.32314, 37.87501], [-122.32284, 37.875], [-122.32202, 37.87519], [-122.32188, 37.87524], [-122.32182, 37.87531], [-122.32176, 37.87534], [-122.32168, 37.87533], [-122.32146, 37.87519], [-122.31855, 37.87583], [-122.3185, 37.87577], [-122.31846, 37.87578], [-122.31566, 37.87224], [-122.31516, 37.87171], [-122.31447, 37.87081], [-122.31486, 37.87076], [-122.31896, 37.87002], [-122.31897, 37.87], [-122.31883, 37.86975], [-122.31927, 37.86944], [-122.31988, 37.86913], [-122.32175, 37.871], [-122.32186, 37.87107], [-122.32227, 37.87158], [-122.3224, 37.87169], [-122.32325, 37.87279], [-122.32469, 37.87433], [-122.32477, 37.87443], [-122.3248, 37.87452]]]} | Open Access 1 | 13762 | Cesar Chavez Park | 17093 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 87.829 | Cesar Chavez Park | 0 | Local Park 2 | 4 | |
1816 | 1816 | 1815 | {"type": "Polygon", "coordinates": [[[-122.31766, 37.86493], [-122.31697, 37.86503], [-122.31682, 37.86456], [-122.31757, 37.86449], [-122.31766, 37.86493]]]} | Open Access 1 | 13767 | Horseshoe Park | 20098 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 0.825 | Horseshoe Park | 0 | Local Park 2 | 4 | |
1817 | 1817 | 1816 | {"type": "Polygon", "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]]]} | Open Access 1 | 13769 | Contra Costa Rock Park | 17607 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 0.629 | Contra Costa Rock Park | 0 | Local Park 2 | 4 | |
8619 | 8619 | 8618 | {"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 | 13771 | Frederick Mini-Park | 19079 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 0.227 | Frederick Mini-Park | 0 | Local Park 2 | 4 | |
8620 | 8620 | 8619 | {"type": "Polygon", "coordinates": [[[-122.27854, 37.89649], [-122.27855, 37.89655], [-122.27845, 37.89705], [-122.27818, 37.89702], [-122.27809, 37.8969], [-122.27795, 37.89685], [-122.27788, 37.89667], [-122.27802, 37.89653], [-122.2782, 37.89646], [-122.27843, 37.89645], [-122.27854, 37.89649]]]} | Open Access 1 | 13773 | Great Stoneface Park | 19458 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/Parks_Rec_Waterfront/Trees_Parks/Parks__Great_Stoneface_Park.aspx# | Alameda 17 | 0.695 | Great Stoneface Park | 0 | Local Park 2 | 4 |
8621 | 8621 | 8620 | {"type": "Polygon", "coordinates": [[[-122.27444, 37.89519], [-122.27417, 37.89538], [-122.27391, 37.89528], [-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.89511], [-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.27291, 37.89509], [-122.27289, 37.89513], [-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 | 13775 | John Hinkel Park | 20445 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 4.627 | John Hinkel Park | 0 | Local Park 2 | 4 | |
8622 | 8622 | 8621 | {"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 | 13777 | Mortar Rock Park | 22508 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 0.277 | Mortar Rock Park | 0 | Local Park 2 | 4 | |
8623 | 8623 | 8622 | {"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 | 13779 | Indian Rock Park | 20206 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 1.093 | Indian Rock Park | 0 | Local Park 2 | 4 | |
8624 | 8624 | 8623 | {"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.26323, 37.89219], [-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 | 13781 | Cragmont Rock Park | 17751 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 3.161 | Cragmont Rock Park | 0 | Local Park 2 | 4 | |
8564 | 8564 | 8563 | {"type": "Polygon", "coordinates": [[[-122.26908, 37.89341], [-122.26876, 37.89357], [-122.26864, 37.89341], [-122.26857, 37.89344], [-122.26853, 37.89338], [-122.26849, 37.8933], [-122.26852, 37.89327], [-122.2685, 37.89322], [-122.26881, 37.89306], [-122.26908, 37.89341]]]} | Open Access 1 | 13783 | Grotto Rock Park | 19531 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 0.39 | Grotto Rock Park | 0 | Local Park 2 | 4 | |
5063 | 5063 | 5062 | {"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 | 13785 | Solano-Peralta Park | 25595 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 0.168 | Solano-Peralta Park | 0 | Local Park 2 | 4 | |
8626 | 8626 | 8625 | {"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 | 13791 | Berkeley Rose Garden | 16023 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 3.772 | Berkeley Rose Garden | 0 | Local Park 2 | 4 | |
8627 | 8627 | 8626 | {"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 | 13793 | Codornices Park | 17472 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 8.165 | Codornices Park | 0 | Local Park 2 | 4 | |
8628 | 8628 | 8627 | {"type": "MultiPolygon", "coordinates": [[[[-122.27199, 37.87379], [-122.27177, 37.87382], [-122.27178, 37.8739], [-122.27164, 37.87392], [-122.27164, 37.87396], [-122.27136, 37.87399], [-122.27135, 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.87302], [-122.28011, 37.87305], [-122.28008, 37.87294], [-122.2799, 37.8729], [-122.27805, 37.87313], [-122.27804, 37.87303], [-122.27731, 37.87312], [-122.27732, 37.87323], [-122.27698, 37.87325], [-122.27696, 37.8733], [-122.27681, 37.87333], [-122.2768, 37.87329], [-122.27563, 37.87344], [-122.27539, 37.8734], [-122.27506, 37.87344], [-122.27506, 37.87354], [-122.2749, 37.87355], [-122.27489, 37.87359], [-122.27474, 37.8736], [-122.2747, 37.87356], [-122.27387, 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.28177, 37.87275], [-122.28202, 37.87272], [-122.28213, 37.87365]]]]} | Open Access 1 | 13795 | Ohlone Park | 23076 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 9.083 | Ohlone Park | 0 | Local Park 2 | 4 | |
8629 | 8629 | 8628 | {"type": "Polygon", "coordinates": [[[-122.27334, 37.85676], [-122.27149, 37.857], [-122.27139, 37.85619], [-122.27273, 37.856], [-122.27282, 37.85648], [-122.27328, 37.85643], [-122.27334, 37.85676]]]} | Open Access 1 | 13797 | Grove Park | 19532 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 3.136 | Grove Park | 0 | Local Park 2 | 4 | |
8630 | 8630 | 8629 | {"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 | 13799 | Willard Park | 27533 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 2.567 | Willard Park | 0 | Local Park 2 | 4 | |
8631 | 8631 | 8630 | {"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 | 13801 | Oak Park | 22996 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 0.22 | Oak Park | 0 | Local Park 2 | 4 | |
8632 | 8632 | 8631 | {"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 | 13803 | Halcyon Commons | 19600 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 0.219 | Halcyon Commons | None 722 | |||
8633 | 8633 | 8632 | {"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 | 13805 | 63rd Street Mini-Park | 15208 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 0.164 | 63rd Street Mini-Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);