units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
49 rows where MNG_AGENCY = 334 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, LABEL_NAME
DES_TP 6
- Local Park 43
- Local Recreation Area 2
- None 1
- None 1
- None 1
- None 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
9653 | 9653 | 9652 | {"type": "Polygon", "coordinates": [[[-122.31492, 37.86324], [-122.31414, 37.86342], [-122.31398, 37.86302], [-122.31476, 37.86281], [-122.31492, 37.86324]]]} | Open Access 1 | 16277 | Adventure Playground | 15278 | 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.854 | Adventure Playground | 0 | Local Recreation Area 3 | 4 | |
5086 | 5086 | 5085 | {"type": "Polygon", "coordinates": [[[-122.30286, 37.86614], [-122.30236, 37.86614], [-122.30202, 37.86561], [-122.3004, 37.8625], [-122.29983, 37.86124], [-122.29973, 37.86108], [-122.29966, 37.86103], [-122.29913, 37.86113], [-122.29594, 37.85074], [-122.29569, 37.84987], [-122.29844, 37.84982], [-122.29876, 37.85021], [-122.29926, 37.85166], [-122.30224, 37.86236], [-122.30272, 37.86423], [-122.3029, 37.86508], [-122.30293, 37.86557], [-122.30286, 37.86614]]]} | Open Access 1 | 13850 | Aquatic Park | 15548 | 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 | 97.574 | Aquatic Park | 0 | Local Park 2 | 4 | |
1823 | 1823 | 1822 | {"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 | 13868 | Bateman Mall Park | 15860 | 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__Bateman_Mall_Park.aspx | Alameda 17 | 0.636 | Bateman Mall Park | 0 | Local Park 2 | 4 |
8649 | 8649 | 8648 | {"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 | 13846 | Becky Temko Tot Park | 15947 | 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.159 | Becky Temko Tot 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 | |
1824 | 1824 | 1823 | {"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 | 13870 | Berkeley Way Mini-Park | 16024 | 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.337 | Berkeley Way Mini-Park | 0 | Local Park 2 | 4 | |
8640 | 8640 | 8639 | {"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.87598], [-122.28752, 37.87599]]], [[[-122.28896, 37.87675], [-122.28834, 37.87683], [-122.28753, 37.87713], [-122.28735, 37.87668], [-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 | 13818 | Cedar-Rose Park | 16993 | 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.388 | Cedar-Rose 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 | |
1819 | 1819 | 1818 | {"type": "Polygon", "coordinates": [[[-122.28448, 37.86652], [-122.28395, 37.86659], [-122.28393, 37.86645], [-122.28428, 37.86641], [-122.28428, 37.86631], [-122.28444, 37.86629], [-122.28448, 37.86652]]]} | Open Access 1 | 13830 | Charlie Dorr Mini-Park | 17145 | 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.214 | Charlie Dorr Mini-Park | 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 | |
1246 | 1246 | 1245 | {"type": "Polygon", "coordinates": [[[-122.27628, 37.89224], [-122.2759, 37.8923], [-122.27586, 37.89215], [-122.2762, 37.89203], [-122.27628, 37.89224]]]} | Open Access 1 | 44896 | 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.169 | Contra Costa Rock 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 | |
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 | |
8635 | 8635 | 8634 | {"type": "Polygon", "coordinates": [[[-122.27064, 37.90131], [-122.27015, 37.9015], [-122.26976, 37.90154], [-122.26967, 37.90149], [-122.26967, 37.90134], [-122.27008, 37.90083], [-122.27047, 37.90104], [-122.27064, 37.90131]]]} | Open Access 1 | 13809 | Dorothy Bolte Park | 18222 | 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.981 | Dorothy Bolte 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 | |
5087 | 5087 | 5086 | {"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 | 13852 | George Florence Park | 19264 | 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.498 | George Florence Park | 0 | Local Park 2 | 4 | |
8647 | 8647 | 8646 | {"type": "Polygon", "coordinates": [[[-122.25774, 37.88464], [-122.25726, 37.88493], [-122.25739, 37.88519], [-122.25691, 37.88549], [-122.25685, 37.88573], [-122.25644, 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.25604, 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 | 13827 | Glendale-La Loma Park | 19328 | 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 | 5.552 | Glendale-La Loma 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 |
8634 | 8634 | 8633 | {"type": "Polygon", "coordinates": [[[-122.26995, 37.85041], [-122.26969, 37.85044], [-122.26974, 37.85071], [-122.26961, 37.85073], [-122.26955, 37.85046], [-122.26943, 37.85047], [-122.26938, 37.85023], [-122.26935, 37.85022], [-122.26929, 37.84994], [-122.26938, 37.84995], [-122.26944, 37.85022], [-122.2698, 37.85016], [-122.26982, 37.85022], [-122.26991, 37.85021], [-122.26995, 37.85041]]]} | Open Access 1 | 13807 | Greg Brown Mini-Park | 19496 | 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.466 | Greg Brown 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]);