superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows sorted by ACRES
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
MNG_AG_TYP >30
- City Agency 10,195
- County Agency 1,100
- Recreation/Parks District 1,090
- State Agency 872
- Non Profit - Land Trust 511
- Federal Agency 289
- Open Space District 241
- County Agency - Parks 218
- Home Owners Association 200
- Community Services District 192
- Water District 187
- Non Profit - Conservation 119
- Flood District 93
- Cemetery District 61
- Non Profit - Other 44
- School District 38
- County Agency - Other 32
- Port/Harbor District 32
- Irrigation District 24
- Special District - Other 15
- Commercial 14
- Sanitation District 9
- Joint Powers Authority 8
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
LAYER 14 ✖
- City 10,195
- Special District 2,004
- County 1,350
- Non Governmental Organization 682
- California Department of Fish and Wildlife 394
- California Department of Parks and Recreation 276
- Private 226
- Other State 202
- Other Federal 90
- National Park Service 65
- US Fish and Wildlife Service 55
- US Forest Service 38
- US Bureau of Land Management 35
- US Military/Defense 6
ACCESS_TYP 4
- Open Access 13,492
- Restricted Access 1,118
- No Public Access 754
- Unknown Access 254
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2268 | 2268 | 2267 | {"type": "Polygon", "coordinates": [[[-122.41296, 37.79709], [-122.41291, 37.7971], [-122.41288, 37.79701], [-122.41284, 37.797], [-122.41282, 37.79693], [-122.41292, 37.79692], [-122.41296, 37.79709]]]} | Open Access 1 | Broadway Tunnel east Mini Park | 16410 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.033 | Broadway Tunnel east MP | ||
7143 | 7143 | 7142 | {"type": "Polygon", "coordinates": [[[-121.94543, 36.97873], [-121.9451, 36.97895], [-121.94502, 36.97897], [-121.94541, 36.9787], [-121.94543, 36.97873]]]} | Open Access 1 | Monterey Avenue Park Access | 22415 | 1044 | Capitola, City of 109 | City 2 | City Agency 2 | http://www.cityofcapitola.org/publicworks/page/parks | City 2 | 0.034 | Monterey Avenue Park Access | ||
9329 | 9329 | 9328 | {"type": "Polygon", "coordinates": [[[-120.44198, 34.91627], [-120.44198, 34.91649], [-120.44191, 34.91649], [-120.44191, 34.91632], [-120.44193, 34.91628], [-120.44198, 34.91627]]]} | Open Access 1 | Santa Maria holding 3 | 25107 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 0.034 | Santa Maria holding 3 | ||
10685 | 10685 | 10684 | {"type": "Polygon", "coordinates": [[[-119.1914, 34.28159], [-119.19124, 34.2816], [-119.1908, 34.28162], [-119.1912, 34.28156], [-119.1914, 34.28159]]]} | Open Access 1 | Ventura holding 107 | 26860 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.034 | Ventura holding 107 | ||
10730 | 10730 | 10729 | {"type": "Polygon", "coordinates": [[[-119.19432, 34.28316], [-119.19407, 34.28287], [-119.1938, 34.28262], [-119.19379, 34.28258], [-119.1938, 34.28256], [-119.19381, 34.28257], [-119.1938, 34.28259], [-119.19382, 34.28261], [-119.19402, 34.2828], [-119.19421, 34.283], [-119.19431, 34.28313], [-119.19432, 34.28316]]]} | Open Access 1 | Ventura holding 5 | 26929 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.034 | Ventura holding 5 | ||
11985 | 11985 | 11984 | {"type": "Polygon", "coordinates": [[[-118.46024, 33.99143], [-118.46013, 33.99159], [-118.46, 33.99153], [-118.46009, 33.99151], [-118.46013, 33.99147], [-118.46024, 33.99143]]]} | Open Access 1 | Marco Triangle | 28830 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.034 | Marco Triangle | ||
4922 | 4922 | 4921 | {"type": "Polygon", "coordinates": [[[-121.23657, 38.39513], [-121.23642, 38.3951], [-121.23642, 38.39505], [-121.23657, 38.39498], [-121.23657, 38.39513]]]} | Unknown Access 4 | Harrison Larry L/Tonya A | 19699 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 0.035 | Harrison Larry L/Tonya A | ||
10751 | 10751 | 10750 | {"type": "Polygon", "coordinates": [[[-119.19536, 34.28728], [-119.19535, 34.28728], [-119.1952, 34.28644], [-119.19521, 34.28644], [-119.19536, 34.28728]]]} | Open Access 1 | Ventura holding 70 | 26952 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.035 | Ventura holding 70 | ||
12638 | 12638 | 12637 | {"type": "Polygon", "coordinates": [[[-118.23978, 34.20471], [-118.23978, 34.2048], [-118.23976, 34.20488], [-118.23962, 34.20472], [-118.23978, 34.20471]]]} | Open Access 1 | Verdugo Mountains Open Space Preserve | 29734 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.036 | Verdugo Mtns. OSP | ||
10705 | 10705 | 10704 | {"type": "Polygon", "coordinates": [[[-119.15013, 34.27654], [-119.15013, 34.27655], [-119.15007, 34.27656], [-119.15004, 34.27659], [-119.14986, 34.27736], [-119.14985, 34.27734], [-119.15003, 34.27659], [-119.15007, 34.27654], [-119.15013, 34.27654]]]} | Open Access 1 | Ventura holding 125 | 26880 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.037 | Ventura holding 125 | ||
3786 | 3786 | 3785 | {"type": "Polygon", "coordinates": [[[-122.56097, 37.90679], [-122.56094, 37.90682], [-122.56065, 37.90675], [-122.56067, 37.90669], [-122.56095, 37.90677], [-122.56097, 37.90679]]]} | Open Access 1 | Earnscliffe Park | 18358 | 1204 | Mill Valley, City of 223 | City 2 | City Agency 2 | http://www.cityofmillvalley.org/Index.aspx?page=416 | City 2 | 0.038 | Earnscliffe Park | ||
12678 | 12678 | 12677 | {"type": "Polygon", "coordinates": [[[-118.13021, 34.02626], [-118.1301, 34.02634], [-118.13002, 34.02626], [-118.13013, 34.02617], [-118.13021, 34.02626]]]} | Open Access 1 | Dutcher Tot Lot | 29820 | 1211 | Montebello, City of 248 | City 2 | City Agency 2 | http://www.cityofmontebello.com/depts/parks/default.asp | City 2 | 0.039 | Dutcher Tot Lot | ||
2718 | 2718 | 2717 | {"type": "Polygon", "coordinates": [[[-122.48777, 37.85715], [-122.48774, 37.85721], [-122.48754, 37.8571], [-122.48753, 37.85703], [-122.48777, 37.85715]]]} | Open Access 1 | Cazneau Park | 16987 | 1327 | Sausalito, City of 439 | City 2 | City Agency 2 | http://www.ci.sausalito.ca.us/index.aspx?page=156 | City 2 | 0.04 | Cazneau Park | ||
8398 | 8398 | 8397 | {"type": "Polygon", "coordinates": [[[-122.412, 37.74019], [-122.41199, 37.74026], [-122.41175, 37.74024], [-122.41175, 37.74018], [-122.412, 37.74019]]]} | Open Access 1 | Prentiss Mini Park | 23985 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.04 | Prentiss MP | ||
9479 | 9479 | 9478 | {"type": "Polygon", "coordinates": [[[-121.75571, 36.90633], [-121.75551, 36.90647], [-121.75541, 36.90638], [-121.75541, 36.90638], [-121.75571, 36.90633]]]} | Open Access 1 | Watsonville holding 1 | 27309 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 0.04 | Watsonville holding 1 | ||
14889 | 14889 | 14888 | {"type": "Polygon", "coordinates": [[[-117.25989, 32.84535], [-117.25988, 32.84542], [-117.25976, 32.84547], [-117.25976, 32.84541], [-117.25979, 32.84531], [-117.25984, 32.84528], [-117.25985, 32.84529], [-117.25988, 32.84531], [-117.25989, 32.84535]]]} | Open Access 1 | Ludington Heights Open Space Park East | 21583 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.042 | Ludington Heights OS Park East | ||
11942 | 11942 | 11941 | {"type": "Polygon", "coordinates": [[[-118.22281, 34.0523], [-118.22263, 34.05242], [-118.22258, 34.05226], [-118.22258, 34.05226], [-118.22281, 34.0523]]]} | Open Access 1 | Aliso Triangle | 28745 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.043 | Aliso Triangle | ||
2637 | 2637 | 2636 | {"type": "Polygon", "coordinates": [[[-121.92514, 36.53043], [-121.92439, 36.53053], [-121.92438, 36.5305], [-121.92514, 36.53041], [-121.92514, 36.53043]]]} | Open Access 1 | Carmel River Lagoon & Wetlands Natural Preserve | 16874 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 0.044 | Carmel River Lagoon & Wetlands Natural Preserve | ||
4017 | 4017 | 4016 | {"type": "Polygon", "coordinates": [[[-117.24702, 33.0564], [-117.24692, 33.05685], [-117.24691, 33.05685], [-117.24689, 33.05683], [-117.2469, 33.05662], [-117.24702, 33.0564]]]} | Open Access 1 | Encinitas holding 36 | 18658 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 0.044 | Encinitas holding 36 | ||
7549 | 7549 | 7548 | {"type": "Polygon", "coordinates": [[[-118.446, 34.13918], [-118.44599, 34.13919], [-118.44597, 34.13919], [-118.44542, 34.13894], [-118.44542, 34.13891], [-118.446, 34.13918]]]} | Open Access 1 | Oak Forest West Access | 22965 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.044 | Oak Forest West Access |
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]);