units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
647 rows where COUNTY = 17
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Oakland, City of 119
- Hayward Area Recreation and Park District 82
- East Bay Regional Park District 74
- Fremont, City of 58
- Berkeley, City of 48
- Pleasanton, City of 42
- Union City, City of 34
- Livermore, City of 31
- Alameda, City of 27
- San Leandro, City of 21
- Dublin, City of 20
- Newark, City of 14
- Livermore Area Recreation and Park District 13
- Emeryville, City of 8
- Piedmont, City of 7
- Albany, City of 6
- California Department of Fish and Wildlife 4
- San Francisco - Public Utilities Commission, City and County of 2
- United States Fish and Wildlife Service 2
- California Department of Parks and Recreation 2
- University of California 2
- California Department of Water Resources 2
- Liberty Park Homeowners Association 1
- East Bay Municipal Utility District 1
- Tri-Valley Conservancy 1
- Alameda County Flood Control and Water Conservation District 1
- Private Landowner 1
- Marcella Renaissance Owners Association 1
- Lakeshore Homes Association 1
- Contra Costa Water District 1
- …
DES_TP >30
- Local Park 465
- Local Recreation Area 65
- Local Conservation Area 22
- Local Other or Unknown 10
- Local Historic or Cultural Area 8
- Private Recreation or Education 5
- State Recreation Area 3
- State Resource Management Area 3
- Local Resource Management Area 2
- National Wildlife Refuge 2
- State Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- Private Agricultural 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 11
ACCESS_TYP 3
- Open Access 572
- Restricted Access 30
- No Public Access 25
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1422 | 1422 | 1421 | {"type": "Polygon", "coordinates": [[[-122.0171, 37.59941], [-122.01689, 37.5995], [-122.0168, 37.59947], [-122.01672, 37.59947], [-122.01663, 37.59948], [-122.01658, 37.59951], [-122.01599, 37.59938], [-122.01595, 37.5994], [-122.01563, 37.59933], [-122.01576, 37.59887], [-122.01617, 37.5977], [-122.01742, 37.59798], [-122.01751, 37.59802], [-122.01754, 37.59812], [-122.0171, 37.59941]]]} | Open Access 1 | 12405 | Shorty Garcia Park | 25431 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 5.79 | Shorty Garcia Park | 0 | Local Park 2 | 4 | |
1434 | 1434 | 1433 | {"type": "Polygon", "coordinates": [[[-122.0272, 37.65621], [-122.02609, 37.65763], [-122.02388, 37.65638], [-122.02421, 37.65615], [-122.02448, 37.65581], [-122.02462, 37.65538], [-122.02478, 37.655], [-122.02503, 37.65468], [-122.02527, 37.65453], [-122.0272, 37.65621]]]} | Open Access 1 | 47699 | J.A. Lewis Park | 31435 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 12.57 | J.A. Lewis Park | 0 | Local Park 2 | 4 | |
1435 | 1435 | 1434 | {"type": "Polygon", "coordinates": [[[-122.13981, 37.67822], [-122.13977, 37.67831], [-122.13782, 37.6791], [-122.13753, 37.67864], [-122.13699, 37.67886], [-122.13613, 37.67751], [-122.13869, 37.67647], [-122.13981, 37.67822]]]} | Open Access 1 | 47700 | Mervin Morris Park | 31436 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 13.34 | Mervin Morris Park | 0 | Local Park 2 | 4 | |
1441 | 1441 | 1440 | {"type": "Polygon", "coordinates": [[[-122.07092, 37.58343], [-122.07086, 37.58345], [-122.07013, 37.5834], [-122.07006, 37.58342], [-122.07001, 37.58347], [-122.07, 37.5835], [-122.07009, 37.58351], [-122.07001, 37.5836], [-122.07041, 37.58428], [-122.06975, 37.58504], [-122.06972, 37.58506], [-122.06966, 37.58505], [-122.06838, 37.58434], [-122.06877, 37.5839], [-122.06833, 37.58365], [-122.06891, 37.58315], [-122.06911, 37.58292], [-122.06883, 37.58275], [-122.06911, 37.58244], [-122.06919, 37.58244], [-122.07066, 37.58326], [-122.07092, 37.58343]]]} | Open Access 1 | 12481 | Contempo Park | 17606 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 8.19 | Contempo Park | 0 | Local Park 2 | 4 | |
1451 | 1451 | 1450 | {"type": "Polygon", "coordinates": [[[-122.09749, 37.66354], [-122.09714, 37.66357], [-122.09618, 37.66266], [-122.09563, 37.66224], [-122.09518, 37.66185], [-122.0948, 37.66148], [-122.0965, 37.6607], [-122.09689, 37.66105], [-122.0972, 37.66164], [-122.09739, 37.66218], [-122.09747, 37.66261], [-122.09753, 37.66314], [-122.09749, 37.66354]]]} | Open Access 1 | 9747 | Centennial Park | 17031 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 9.492 | Centennial Park | 0 | Local Park 2 | 4 | |
1501 | 1501 | 1500 | {"type": "Polygon", "coordinates": [[[-122.01802, 37.53174], [-122.0169, 37.53312], [-122.01436, 37.53181], [-122.01549, 37.53039], [-122.01802, 37.53174]]]} | Open Access 1 | 12740 | Birch Grove Park | 16116 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 12.218 | Birch Grove Park | 1973 | Local Park 2 | 4 | |
1511 | 1511 | 1510 | {"type": "Polygon", "coordinates": [[[-122.05125, 37.54145], [-122.05097, 37.54229], [-122.05084, 37.54249], [-122.05067, 37.54266], [-122.04921, 37.54073], [-122.04898, 37.54054], [-122.04953, 37.54009], [-122.04957, 37.54009], [-122.04963, 37.54011], [-122.04965, 37.54009], [-122.05123, 37.5414], [-122.05125, 37.54145]]]} | Open Access 1 | 12752 | Mirabeau Park | 22280 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 6.07 | Mirabeau Park | 1973 | Local Park 2 | 4 | |
1518 | 1518 | 1517 | {"type": "Polygon", "coordinates": [[[-122.08221, 37.69769], [-122.08102, 37.69769], [-122.08099, 37.69634], [-122.08217, 37.69632], [-122.08221, 37.69769]]]} | Open Access 1 | 47719 | Adobe Park | 31505 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/facilities/facility/details/Adobe-Park-116 | Alameda 17 | 3.894 | Adobe Park | 0 | Local Park 2 | 4 |
1519 | 1519 | 1518 | {"type": "Polygon", "coordinates": [[[-122.06248, 37.57326], [-122.06228, 37.5735], [-122.06199, 37.57334], [-122.06219, 37.5731], [-122.06248, 37.57326]]]} | Open Access 1 | 47720 | Cerruti Park | 31508 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 0.246 | Cerruti Park | 0 | Local Park 2 | 4 | |
1545 | 1545 | 1544 | {"type": "Polygon", "coordinates": [[[-121.92081, 37.47824], [-121.92042, 37.47893], [-121.91967, 37.47868], [-121.91913, 37.47883], [-121.91902, 37.47896], [-121.91873, 37.47891], [-121.91828, 37.47906], [-121.91812, 37.47925], [-121.91824, 37.47946], [-121.91842, 37.47985], [-121.9173, 37.48026], [-121.91631, 37.47851], [-121.91682, 37.47833], [-121.9171, 37.47884], [-121.91744, 37.47892], [-121.91786, 37.47879], [-121.91967, 37.47812], [-121.92003, 37.47831], [-121.92062, 37.47809], [-121.92078, 37.47818], [-121.92081, 37.47821], [-121.92081, 37.47824]]]} | Open Access 1 | 12981 | Booster Park | 16273 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 8.178 | Booster Park | 1973 | Local Park 2 | 4 | |
1546 | 1546 | 1545 | {"type": "Polygon", "coordinates": [[[-121.94629, 37.55413], [-121.94553, 37.55481], [-121.94613, 37.55522], [-121.94594, 37.55538], [-121.94582, 37.55544], [-121.94486, 37.55627], [-121.9447, 37.55637], [-121.94463, 37.55636], [-121.94461, 37.55634], [-121.94456, 37.55617], [-121.94449, 37.55605], [-121.94437, 37.55591], [-121.94414, 37.55573], [-121.94412, 37.55571], [-121.94413, 37.55567], [-121.94596, 37.55405], [-121.94603, 37.55402], [-121.9461, 37.55402], [-121.94629, 37.55413]]]} | Open Access 1 | 12987 | Buena Vista Park | 16491 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 4.54 | Buena Vista Park | 1984 | Local Park 2 | 4 | |
1552 | 1552 | 1551 | {"type": "Polygon", "coordinates": [[[-122.05715, 37.57857], [-122.05566, 37.58029], [-122.05467, 37.57972], [-122.0569, 37.57843], [-122.05715, 37.57857]]]} | Open Access 1 | 13000 | David Jones Park | 17942 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 3.885 | David Jones Park | 0 | Local Park 2 | 4 | |
1554 | 1554 | 1553 | {"type": "Polygon", "coordinates": [[[-122.05699, 37.58393], [-122.05651, 37.58415], [-122.05648, 37.58423], [-122.05642, 37.58425], [-122.05594, 37.58447], [-122.0559, 37.5845], [-122.05587, 37.58454], [-122.05583, 37.58453], [-122.0556, 37.58464], [-122.05579, 37.58493], [-122.05587, 37.58502], [-122.05659, 37.58605], [-122.05675, 37.58613], [-122.05662, 37.5863], [-122.05654, 37.58626], [-122.05643, 37.58613], [-122.05582, 37.58528], [-122.05559, 37.58539], [-122.05554, 37.58546], [-122.05547, 37.58547], [-122.05496, 37.58571], [-122.05493, 37.58575], [-122.05491, 37.58581], [-122.055, 37.58594], [-122.05453, 37.58616], [-122.05448, 37.58628], [-122.05393, 37.58652], [-122.05385, 37.58647], [-122.05331, 37.5867], [-122.05325, 37.58662], [-122.05376, 37.5864], [-122.05378, 37.58634], [-122.05389, 37.58633], [-122.05395, 37.58628], [-122.05403, 37.58631], [-122.05429, 37.5862], [-122.05409, 37.58592], [-122.05422, 37.58586], [-122.05427, 37.58587], [-122.05434, 37.58586], [-122.05484, 37.58563], [-122.0549, 37.58557], [-122.0549, 37.5855], [-122.05513, 37.58539], [-122.05492, 37.58509], [-122.05515, 37.58498], [-122.05521, 37.58485], [-122.05531, 37.5848], [-122.05534, 37.58472], [-122.05529, 37.58464], [-122.05561, 37.58425], [-122.0556, 37.5842], [-122.05565, 37.58419], [-122.05571, 37.58415], [-122.05601, 37.58376], [-122.05602, 37.58369], [-122.0561, 37.58368], [-122.05622, 37.58352], [-122.05647, 37.58364], [-122.0566, 37.58347], [-122.05682, 37.58369], [-122.05699, 37.58393]]]} | Open Access 1 | 13018 | Lowry Park | 21570 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 5.11 | Lowry Park | 0 | Local Park 2 | 4 | |
1556 | 1556 | 1555 | {"type": "Polygon", "coordinates": [[[-122.28429, 37.8453], [-122.28401, 37.84534], [-122.28346, 37.84522], [-122.28281, 37.8452], [-122.28279, 37.84516], [-122.28227, 37.84523], [-122.28208, 37.84463], [-122.284, 37.8444], [-122.28429, 37.8453]]]} | Open Access 1 | 13055 | Golden Gate Recreation Center | 19360 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 3.496 | Golden Gate Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
1559 | 1559 | 1558 | {"type": "Polygon", "coordinates": [[[-121.79619, 37.68269], [-121.79494, 37.68274], [-121.79497, 37.68061], [-121.79535, 37.68032], [-121.79617, 37.6799], [-121.7962, 37.68042], [-121.79619, 37.68269]]]} | Open Access 1 | 11955 | Hagemann | 19593 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 7.49 | Hagemann | None 123 | |||
1561 | 1561 | 1560 | {"type": "Polygon", "coordinates": [[[-121.76382, 37.67746], [-121.76279, 37.67776], [-121.76246, 37.67699], [-121.76349, 37.67669], [-121.76382, 37.67746]]]} | Open Access 1 | 11728 | Bothwell Recreation Center | 16293 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 2.176 | Bothwell Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
1563 | 1563 | 1562 | {"type": "Polygon", "coordinates": [[[-121.73028, 37.70971], [-121.73028, 37.71001], [-121.73025, 37.71008], [-121.73028, 37.71017], [-121.73028, 37.7106], [-121.73024, 37.71068], [-121.73025, 37.71073], [-121.73028, 37.71077], [-121.73027, 37.71106], [-121.72938, 37.71104], [-121.72938, 37.71078], [-121.72931, 37.71071], [-121.72936, 37.71067], [-121.72938, 37.71062], [-121.72935, 37.71053], [-121.72935, 37.71011], [-121.72931, 37.70995], [-121.72932, 37.70991], [-121.72952, 37.70982], [-121.72967, 37.70984], [-121.72977, 37.70981], [-121.72981, 37.70977], [-121.72983, 37.70972], [-121.72982, 37.70966], [-121.7298, 37.70962], [-121.72994, 37.70956], [-121.72994, 37.70971], [-121.73028, 37.70971]]]} | Open Access 1 | 11799 | Bill Clark Park | 16103 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 2.877 | Bill Clark Park | 0 | Local Park 2 | 4 | |
1565 | 1565 | 1564 | {"type": "Polygon", "coordinates": [[[-121.72258, 37.71363], [-121.72258, 37.71376], [-121.72183, 37.71376], [-121.72183, 37.71365], [-121.7218, 37.71363], [-121.72077, 37.71362], [-121.72074, 37.71356], [-121.72062, 37.71339], [-121.72027, 37.7135], [-121.72016, 37.71334], [-121.72004, 37.71323], [-121.72008, 37.71319], [-121.72015, 37.71298], [-121.72009, 37.71296], [-121.71968, 37.71294], [-121.71958, 37.71288], [-121.7195, 37.71286], [-121.71934, 37.71265], [-121.71955, 37.71276], [-121.71974, 37.71281], [-121.72069, 37.71283], [-121.72079, 37.71284], [-121.72087, 37.71288], [-121.72188, 37.71351], [-121.72201, 37.71356], [-121.72219, 37.71361], [-121.72237, 37.71363], [-121.72258, 37.71363]]]} | Open Access 1 | 11809 | Northfront Park | 22869 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 2.748 | Northfront Park | 0 | Local Park 2 | 4 | |
1572 | 1572 | 1571 | {"type": "Polygon", "coordinates": [[[-121.80467, 37.66589], [-121.80441, 37.66607], [-121.80426, 37.66621], [-121.80388, 37.66612], [-121.80372, 37.66579], [-121.80323, 37.66563], [-121.80336, 37.66437], [-121.80455, 37.66433], [-121.80467, 37.66589]]]} | Open Access 1 | 12075 | Ida Holm | 20171 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 5.144 | Ida Holm | None 125 | |||
1576 | 1576 | 1575 | {"type": "Polygon", "coordinates": [[[-122.28067, 37.81793], [-122.28059, 37.81813], [-122.28026, 37.81805], [-122.28033, 37.81785], [-122.28067, 37.81793]]]} | Open Access 1 | 13449 | McClymonds Mini Park | 22003 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.176 | McClymonds MP | 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]);