superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 9,575
- County Agency 997
- Recreation/Parks District 990
- State Agency 672
- Non Profit - Land Trust 463
- Open Space District 211
- Federal Agency 200
- County Agency - Parks 192
- Community Services District 184
- Water District 167
- Home Owners Association 155
- Non Profit - Conservation 107
- Flood District 91
- Cemetery District 61
- Non Profit - Other 33
- Port/Harbor District 32
- County Agency - Other 28
- Irrigation District 16
- School District 13
- Special District - Other 12
- Commercial 10
- Sanitation District 9
- Joint Powers Authority 5
- Other 5
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- Los Angeles, City of 427
- San Diego, City of 401
- California Department of Fish and Wildlife 323
- San Jose, City of 240
- San Francisco, City and County of 223
- Sacramento, City of 208
- California Department of Parks and Recreation 166
- Mountains Recreation and Conservation Authority 163
- Los Angeles, County of 159
- Ventura, City of 149
- Long Beach, City of 139
- Roseville, City of 121
- San Diego, County of 116
- East Bay Regional Park District 115
- Oakland, City of 111
- Irvine, City of 96
- Fresno, City of 92
- Consumnes Community Services District 91
- Santa Barbara, County of 79
- Hayward Area Recreation and Park District 79
- Stockton, City of 79
- Modesto, City of 79
- Huntington Beach, City of 76
- Orange, County of 73
- Torrance, City of 72
- Tracy, City of 70
- Santa Rosa, City of 69
- Santa Cruz, City of 68
- Chula Vista, City of 66
- Newport Beach, City of 64
- …
ACCESS_TYP 4
- Open Access 12,354
- Restricted Access 957
- No Public Access 695
- Unknown Access 249
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1384 | 1384 | 1383 | {"type": "Polygon", "coordinates": [[[-116.9995, 34.04903], [-116.99943, 34.06273], [-116.99495, 34.06294], [-116.99063, 34.06317], [-116.98635, 34.06342], [-116.98636, 34.05627], [-116.99075, 34.05601], [-116.99075, 34.05284], [-116.99567, 34.0507], [-116.99568, 34.05225], [-116.99773, 34.05245], [-116.99774, 34.0498], [-116.9995, 34.04903]]]} | Open Access 1 | El Dorado Ranch Park | 15122 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 333.169 | El Dorado Ranch Park | ||
1385 | 1385 | 1384 | {"type": "Polygon", "coordinates": [[[-117.64341, 34.11057], [-117.64175, 34.11057], [-117.6417, 34.11053], [-117.6417, 34.11008], [-117.64338, 34.11007], [-117.64341, 34.11011], [-117.64341, 34.11057]]]} | Open Access 1 | 13th Street Reservoir Park | 15171 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 2.128 | 13th Street Reservoir Park | ||
1386 | 1386 | 1385 | {"type": "MultiPolygon", "coordinates": [[[[-118.19093, 33.78373], [-118.19093, 33.78389], [-118.19012, 33.78389], [-118.19012, 33.78373], [-118.19093, 33.78373]]], [[[-118.19225, 33.78389], [-118.1912, 33.78389], [-118.1912, 33.78373], [-118.19225, 33.78373], [-118.19225, 33.78389]]], [[[-118.19492, 33.78372], [-118.19492, 33.78389], [-118.19388, 33.78389], [-118.19388, 33.78372], [-118.19492, 33.78372]]], [[[-118.19623, 33.78372], [-118.19623, 33.78389], [-118.19519, 33.78389], [-118.19519, 33.78372], [-118.19623, 33.78372]]]]} | Open Access 1 | 14th Street Park and Playground | 15173 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.66 | 14th Street Park and Playground | ||
1387 | 1387 | 1386 | {"type": "Polygon", "coordinates": [[[-122.46853, 37.78203], [-122.4677, 37.78207], [-122.46767, 37.78166], [-122.4685, 37.78162], [-122.46853, 37.78203]], [[-122.4682, 37.78188], [-122.46824, 37.78187], [-122.46824, 37.78181], [-122.46819, 37.7818], [-122.46818, 37.78172], [-122.46796, 37.78173], [-122.46798, 37.78197], [-122.46819, 37.78197], [-122.4682, 37.78188]]]} | Open Access 1 | 10th Ave & Clement Mini Park | 15169 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.689 | 10th Ave & Clement MP | ||
1388 | 1388 | 1387 | {"type": "Polygon", "coordinates": [[[-118.24932, 33.93589], [-118.24931, 33.93673], [-118.24783, 33.93674], [-118.24784, 33.93589], [-118.24932, 33.93589]]]} | Open Access 1 | 109th Street Recreation Center | 15168 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.183 | 109th Street Rec. Ctr. | ||
1389 | 1389 | 1388 | {"type": "Polygon", "coordinates": [[[-122.47276, 37.75963], [-122.47242, 37.75965], [-122.47242, 37.75992], [-122.47229, 37.75993], [-122.47226, 37.75966], [-122.47186, 37.75967], [-122.47184, 37.75949], [-122.47225, 37.75947], [-122.47223, 37.75917], [-122.47237, 37.75919], [-122.47241, 37.75955], [-122.47275, 37.75954], [-122.47276, 37.75963]]]} | Open Access 1 | 15th Avenue Steps | 15174 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.525 | 15th Avenue Steps | ||
1390 | 1390 | 1389 | {"type": "Polygon", "coordinates": [[[-121.54003, 36.84451], [-121.5399, 36.84466], [-121.53964, 36.84472], [-121.53932, 36.84481], [-121.53923, 36.84481], [-121.53906, 36.84477], [-121.53856, 36.84446], [-121.5391, 36.84392], [-121.54003, 36.84451]]]} | Open Access 1 | Abbe Park | 15235 | 1304 | San Juan Bautista, City of 834 | City 2 | City Agency 2 | http://www.san-juan-bautista.ca.us/ | City 2 | 1.743 | Abbe Park | ||
1391 | 1391 | 1390 | {"type": "Polygon", "coordinates": [[[-121.79774, 37.31556], [-121.79746, 37.31561], [-121.79725, 37.31561], [-121.79713, 37.31564], [-121.79701, 37.31563], [-121.7968, 37.31557], [-121.79672, 37.31551], [-121.7966, 37.31539], [-121.79659, 37.31526], [-121.7967, 37.31504], [-121.79674, 37.315], [-121.79682, 37.31496], [-121.79681, 37.31491], [-121.79679, 37.31489], [-121.79665, 37.31485], [-121.79646, 37.31485], [-121.79638, 37.31484], [-121.79623, 37.31479], [-121.79599, 37.31458], [-121.79592, 37.31449], [-121.79585, 37.31445], [-121.79573, 37.31442], [-121.79558, 37.31434], [-121.7955, 37.31427], [-121.79544, 37.31418], [-121.79539, 37.31414], [-121.79533, 37.31412], [-121.79512, 37.3141], [-121.79508, 37.31409], [-121.79505, 37.31404], [-121.79506, 37.31394], [-121.79502, 37.31388], [-121.79496, 37.31382], [-121.7948, 37.31374], [-121.79475, 37.31367], [-121.79543, 37.31358], [-121.79546, 37.31378], [-121.79614, 37.31418], [-121.79694, 37.31401], [-121.79722, 37.31397], [-121.79711, 37.31413], [-121.79706, 37.31424], [-121.79703, 37.31441], [-121.79705, 37.31456], [-121.79709, 37.31465], [-121.79742, 37.31517], [-121.79763, 37.31546], [-121.79774, 37.31556]]]} | Open Access 1 | Aborn Park | 15237 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 4.604 | Aborn Park | 2000 | |
1392 | 1392 | 1391 | {"type": "Polygon", "coordinates": [[[-122.3226, 37.92415], [-122.32259, 37.92453], [-122.32253, 37.92457], [-122.32213, 37.92457], [-122.32209, 37.92453], [-122.32209, 37.92415], [-122.32215, 37.9241], [-122.32254, 37.9241], [-122.3226, 37.92415]]]} | Open Access 1 | Abraham Braxton Park | 15238 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 0.568 | Abraham Braxton Park | ||
1393 | 1393 | 1392 | {"type": "Polygon", "coordinates": [[[-120.98531, 37.64901], [-120.98463, 37.64903], [-120.98465, 37.65], [-120.98013, 37.65001], [-120.98011, 37.64965], [-120.97954, 37.64967], [-120.97858, 37.64965], [-120.97844, 37.64819], [-120.9788, 37.64804], [-120.97888, 37.64799], [-120.97931, 37.64775], [-120.97965, 37.6476], [-120.98014, 37.64747], [-120.98097, 37.64734], [-120.98437, 37.6473], [-120.98461, 37.64722], [-120.98472, 37.64719], [-120.98498, 37.64709], [-120.98508, 37.64706], [-120.98517, 37.64708], [-120.98524, 37.64712], [-120.98528, 37.6472], [-120.98531, 37.64901]]]} | Open Access 1 | Acacia Memorial Park Cemeteries | 15242 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 39.547 | Acacia Memorial Park Cemeteries | ||
1394 | 1394 | 1393 | {"type": "Polygon", "coordinates": [[[-118.42321, 33.93034], [-118.42276, 33.93034], [-118.42276, 33.92986], [-118.4232, 33.92986], [-118.42321, 33.93034]]]} | Open Access 1 | Acacia Park | 15243 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 0.538 | Acacia Park | ||
1395 | 1395 | 1394 | {"type": "Polygon", "coordinates": [[[-123.9944, 40.85728], [-123.98793, 40.85729], [-123.98823, 40.85355], [-123.99082, 40.85359], [-123.991, 40.85206], [-123.99205, 40.85205], [-123.99208, 40.8536], [-123.99106, 40.85359], [-123.99105, 40.85361], [-123.99158, 40.85448], [-123.99209, 40.85481], [-123.99433, 40.85721], [-123.9944, 40.85728]]]} | Open Access 1 | Mad River Fish Hatchery | 32212 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 43.311 | Mad River Fish Hatchery | ||
1396 | 1396 | 1395 | {"type": "Polygon", "coordinates": [[[-117.58063, 33.90172], [-117.58031, 33.90181], [-117.57957, 33.90195], [-117.57948, 33.90164], [-117.57942, 33.90164], [-117.57931, 33.9014], [-117.57926, 33.90133], [-117.57932, 33.90128], [-117.57934, 33.9012], [-117.57948, 33.90119], [-117.5797, 33.90089], [-117.57996, 33.90104], [-117.58024, 33.90127], [-117.58051, 33.90157], [-117.58063, 33.90172]]]} | Open Access 1 | Aburndale Recreation Center | 15241 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 2.025 | Aburndale Rec. Ctr. | ||
1397 | 1397 | 1396 | {"type": "Polygon", "coordinates": [[[-117.89644, 33.88277], [-117.89637, 33.88279], [-117.89628, 33.88283], [-117.89623, 33.88291], [-117.89625, 33.88327], [-117.89626, 33.88408], [-117.89611, 33.88409], [-117.89606, 33.88412], [-117.89496, 33.88413], [-117.89485, 33.88415], [-117.89369, 33.88447], [-117.89359, 33.88452], [-117.89353, 33.88459], [-117.89351, 33.88466], [-117.89352, 33.88472], [-117.89365, 33.8849], [-117.89386, 33.88528], [-117.8939, 33.88543], [-117.89391, 33.88553], [-117.8938, 33.88607], [-117.89338, 33.88584], [-117.89344, 33.88574], [-117.89349, 33.88562], [-117.8935, 33.88549], [-117.89347, 33.88533], [-117.8932, 33.88483], [-117.89313, 33.88452], [-117.8931, 33.88445], [-117.89301, 33.88432], [-117.89297, 33.88427], [-117.89321, 33.88385], [-117.89337, 33.88391], [-117.89356, 33.88368], [-117.89393, 33.88339], [-117.89406, 33.88333], [-117.89456, 33.88315], [-117.89485, 33.88297], [-117.89509, 33.8828], [-117.89644, 33.88277]]]} | Open Access 1 | Acacia Park | 15244 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 10.396 | Acacia Park | ||
1398 | 1398 | 1397 | {"type": "Polygon", "coordinates": [[[-120.8521, 35.36149], [-120.85186, 35.36149], [-120.85183, 35.36146], [-120.85128, 35.36146], [-120.85126, 35.36012], [-120.85143, 35.36012], [-120.85163, 35.36043], [-120.85188, 35.36091], [-120.85199, 35.36116], [-120.8521, 35.36149]]]} | Open Access 1 | Anchor Street Park | 15471 | 1453 | Morro Bay, City of 638 | City 2 | City Agency 2 | http://www.morro-bay.ca.us/index.aspx?nid=292 | City 2 | 1.792 | Anchor Street Park | ||
1399 | 1399 | 1398 | {"type": "Polygon", "coordinates": [[[-122.0624, 37.57825], [-122.06239, 37.57829], [-122.06149, 37.57931], [-122.06113, 37.57754], [-122.06116, 37.57752], [-122.06102, 37.57685], [-122.0621, 37.57746], [-122.06224, 37.57808], [-122.06228, 37.57814], [-122.06238, 37.57821], [-122.0624, 37.57825]]]} | Open Access 1 | Accinelli Park | 15247 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 4.1 | Accinelli Park | ||
1400 | 1400 | 1399 | {"type": "Polygon", "coordinates": [[[-117.73647, 33.57611], [-117.73593, 33.5772], [-117.73522, 33.57626], [-117.73566, 33.57542], [-117.7358, 33.57549], [-117.73619, 33.57575], [-117.73646, 33.57601], [-117.73647, 33.57611]]]} | Open Access 1 | Acorn Park | 15249 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 3.041 | Acorn Park | ||
1401 | 1401 | 1400 | {"type": "Polygon", "coordinates": [[[-117.65747, 33.47102], [-117.65702, 33.47091], [-117.65653, 33.47084], [-117.65637, 33.47091], [-117.65617, 33.47091], [-117.65611, 33.47088], [-117.65603, 33.47082], [-117.65576, 33.47071], [-117.65435, 33.47072], [-117.6544, 33.47021], [-117.65505, 33.47026], [-117.65569, 33.47024], [-117.65711, 33.47005], [-117.6572, 33.47011], [-117.65723, 33.47025], [-117.65746, 33.4706], [-117.65735, 33.47067], [-117.65747, 33.47102]]]} | Open Access 1 | Acu Canyon Park | 15252 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 4.693 | Acu Canyon Park | ||
1402 | 1402 | 1401 | {"type": "Polygon", "coordinates": [[[-118.11706, 34.02141], [-118.11655, 34.02308], [-118.11557, 34.02288], [-118.11585, 34.02192], [-118.11517, 34.02177], [-118.11511, 34.02168], [-118.11503, 34.02159], [-118.11491, 34.02152], [-118.11479, 34.02148], [-118.1148, 34.02139], [-118.11388, 34.0212], [-118.11386, 34.02117], [-118.11395, 34.02088], [-118.114, 34.02085], [-118.11596, 34.02126], [-118.116, 34.02118], [-118.11706, 34.02141]]]} | Open Access 1 | Acuna Park | 15253 | 1211 | Montebello, City of 248 | City 2 | City Agency 2 | http://www.cityofmontebello.com/depts/parks/default.asp | City 2 | 7.154 | Acuna Park | ||
1403 | 1403 | 1402 | {"type": "Polygon", "coordinates": [[[-120.45419, 37.30635], [-120.45368, 37.30715], [-120.45136, 37.30715], [-120.45137, 37.30635], [-120.45419, 37.30635]]]} | Open Access 1 | Ada Givens Park | 15254 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 4.994 | Ada Givens Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);