units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
49 rows where MNG_AGENCY = 334 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17011 | 17011 | 17010 | {"type": "Polygon", "coordinates": [[[-122.27265, 37.86963], [-122.27067, 37.86986], [-122.27054, 37.86916], [-122.27257, 37.86887], [-122.27265, 37.86963]], [[-122.2712, 37.86973], [-122.27121, 37.86971], [-122.27111, 37.86918], [-122.27062, 37.86925], [-122.27073, 37.86979], [-122.2712, 37.86973]]]} | Open Access 1 | 13855 | MLK Memorial Park (Civic Center) | 22335 | 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.955 | MLK Memorial Park (Civic Ctr.) | None 1423 | |||
16853 | 16853 | 16852 | {"type": "Polygon", "coordinates": [[[-122.31005, 37.87748], [-122.30815, 37.87787], [-122.30808, 37.87787], [-122.30785, 37.87763], [-122.30714, 37.87584], [-122.30661, 37.87435], [-122.30873, 37.87383], [-122.31005, 37.87748]]]} | Open Access 1 | 46003 | Tom Bates Regional Sports Complex | 29211 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/Mayor/Home/Recreation_in_Berkeley.aspx | Alameda 17 | 19.935 | Tom Bates Reg. Sports Complex | 0 | Local Recreation Area 3 | 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 | |
8653 | 8653 | 8652 | {"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 | 13876 | Peoples Park | 23591 | 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.749 | Peoples Park | 0 | Local Park 2 | 4 | |
8652 | 8652 | 8651 | {"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 | 13872 | Marina Mall | 21830 | 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.125 | Marina Mall | None 725 | |||
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 | |
8648 | 8648 | 8647 | {"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 | 13834 | James Kenney Park | 20346 | 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.73 | James Kenney 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 | |
8643 | 8643 | 8642 | {"type": "MultiPolygon", "coordinates": [[[[-122.2686, 37.88461], [-122.26813, 37.88468], [-122.26811, 37.88457], [-122.268, 37.88458], [-122.26798, 37.88448], [-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 | 13824 | Live Oak Park | 21367 | 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.888 | Live Oak Park | 0 | Local Park 2 | 4 | |
8642 | 8642 | 8641 | {"type": "Polygon", "coordinates": [[[-122.25586, 37.89036], [-122.2558, 37.89046], [-122.25581, 37.89051], [-122.25536, 37.89042], [-122.25548, 37.89021], [-122.25586, 37.89036]]]} | Open Access 1 | 13821 | Grizzly Peak Park | 19525 | 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.201 | Grizzly Peak Park | 0 | Local Park 2 | 4 | |
8641 | 8641 | 8640 | {"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.86694], [-122.28644, 37.8671], [-122.28631, 37.86711], [-122.2863, 37.86712], [-122.28641, 37.8675], [-122.28649, 37.8677], [-122.28655, 37.8677], [-122.28662, 37.86802], [-122.28668, 37.86802], [-122.28683, 37.86871]]]} | Open Access 1 | 13819 | Strawberry Creek Park | 25914 | 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.301 | Strawberry Creek 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 | |
8639 | 8639 | 8638 | {"type": "Polygon", "coordinates": [[[-122.25109, 37.88399], [-122.25098, 37.88402], [-122.25094, 37.88415], [-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.25056, 37.88393], [-122.25104, 37.88389], [-122.25109, 37.88399]]]} | Open Access 1 | 13816 | Terrace View Park | 26263 | 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.936 | Terrace View Park | 0 | Local Park 2 | 4 | |
8638 | 8638 | 8637 | {"type": "Polygon", "coordinates": [[[-122.26203, 37.89212], [-122.262, 37.89225], [-122.26141, 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 | 13814 | Remillard Park | 24288 | 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.744 | Remillard 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 | |
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 | |
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 | |
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 | |||
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 | |
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 |
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]);