units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
49 rows where MNG_AGENCY = 334 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, 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
AGNCY_LEV 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1621 | 1621 | 1620 | {"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 | 13842 | Virginia-McGee Totland | 27153 | 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.365 | Virginia-McGee Totland | None 130 | |||
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 | |||
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 | |||
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 | |||
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 | |
1619 | 1619 | 1618 | {"type": "Polygon", "coordinates": [[[-122.28378, 37.85123], [-122.28342, 37.85131], [-122.28339, 37.85118], [-122.28374, 37.8511], [-122.28378, 37.85123]]]} | Open Access 1 | 13838 | Haskell-Mabel Mini-Park | 19730 | 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.121 | Haskell-Mabel Mini-Park | 0 | Local Park 2 | 4 | |
1620 | 1620 | 1619 | {"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 | 13840 | San Pablo Park | 24969 | 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 | 11.36 | San Pablo Park | 0 | Local Park 2 | 4 | |
1622 | 1622 | 1621 | {"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 | 13844 | Presentation Mini-Park | 23986 | 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.107 | Presentation Mini-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 | |
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 | |
1822 | 1822 | 1821 | {"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.24706, 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.86095], [-122.24722, 37.86096], [-122.24725, 37.86105]]]]} | Open Access 1 | 13865 | Monkey Island Park | 22370 | 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.448 | Monkey Island 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 |
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 | |
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 | |
5085 | 5085 | 5084 | {"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 | 13848 | Prince Street Mini-Park | 24009 | 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.155 | Prince Street Mini-Park | 0 | Local Park 2 | 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 | |
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 | |
5088 | 5088 | 5087 | {"type": "Polygon", "coordinates": [[[-122.30547, 37.88206], [-122.30345, 37.88227], [-122.30303, 37.88106], [-122.30406, 37.88082], [-122.30422, 37.88128], [-122.30516, 37.88112], [-122.30547, 37.88206]]]} | Open Access 1 | 13853 | Harrison Park | 19701 | 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.583 | Harrison 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 |
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]);