superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
254 rows where ACCESS_TYP = 4 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Yuba County Water Agency 45
- Mountains Recreation and Conservation Authority 30
- National Audubon Society 22
- California Department of Transportation 15
- Santa Barbara, County of 13
- San Joaquin River Parkway and Conservation Trust 8
- Santa Barbara, City of 7
- Riverside, County of 6
- Save the Redwoods League 5
- Sacramento, County of 5
- Santa Barbara Flood Control and Water Conserv. District 4
- North County Transit District 4
- Monterey, County of 3
- United States Fish and Wildlife Service 3
- Sierra Foothill Conservancy 3
- Sacramento and San Joaquin Drainage District 3
- Wildlands Inc 3
- Northcoast Regional Land Trust 3
- Los Angeles, County of 2
- Los Angeles, City of 2
- Carpinteria, City of 2
- Orange, County of 2
- Back Country Land Trust 2
- California Wildlife Conservation Board 2
- San Diego, City of 1
- Fresno, City of 1
- United States Forest Service 1
- Monterey Peninsula Regional Park District 1
- United States National Park Service 1
- California State Lands Commission 1
- …
MNG_AG_TYP 15
- Water District 50
- County Agency 33
- Open Space District 32
- Non Profit - Land Trust 32
- Non Profit - Conservation 22
- City Agency 21
- State Agency 20
- Flood District 7
- Federal Agency 6
- Transportation Agency 4
- Mitigation Bank 3
- Recreation/Parks District 1
- County Agency - Parks 1
- Irrigation District 1
- Non Profit - Other 1
PARK_URL 4 ✖
ACCESS_TYP 1
- Unknown Access · 234 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2650 | 2650 | 2649 | {"type": "Polygon", "coordinates": [[[-119.50841, 34.395], [-119.5075, 34.3955], [-119.50689, 34.39577], [-119.50682, 34.39566], [-119.50722, 34.39559], [-119.50754, 34.39538], [-119.50776, 34.39528], [-119.50804, 34.39502], [-119.50825, 34.39477], [-119.50841, 34.395]]]} | Unknown Access 4 | Carpinteria Creek | 16898 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 0.458 | Carpinteria Creek | ||
9256 | 9256 | 9255 | {"type": "Polygon", "coordinates": [[[-119.74246, 34.44054], [-119.74244, 34.44072], [-119.74241, 34.44073], [-119.74215, 34.44091], [-119.74194, 34.44113], [-119.74168, 34.44129], [-119.74157, 34.44128], [-119.7414, 34.44128], [-119.74181, 34.44101], [-119.74204, 34.44079], [-119.74227, 34.44062], [-119.74234, 34.44054], [-119.74246, 34.44054]]]} | Unknown Access 4 | San Roque Creek | 24990 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.477 | San Roque Creek | ||
9334 | 9334 | 9333 | {"type": "Polygon", "coordinates": [[[-119.52773, 34.40703], [-119.52713, 34.40837], [-119.52698, 34.40879], [-119.52686, 34.40923], [-119.52678, 34.40968], [-119.52672, 34.40966], [-119.52675, 34.4094], [-119.52682, 34.40907], [-119.52689, 34.40883], [-119.52701, 34.40848], [-119.52766, 34.40701], [-119.52773, 34.40703]]]} | Unknown Access 4 | Santa Monica Creek | 25117 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 0.489 | Santa Monica Creek | ||
1628 | 1628 | 1627 | {"type": "Polygon", "coordinates": [[[-117.35743, 33.16745], [-117.35654, 33.16659], [-117.35654, 33.16659], [-117.35663, 33.16654], [-117.35665, 33.16649], [-117.35674, 33.16649], [-117.35696, 33.16667], [-117.35697, 33.1667], [-117.35728, 33.16704], [-117.35725, 33.16707], [-117.35727, 33.1671], [-117.35726, 33.16716], [-117.35728, 33.16723], [-117.3574, 33.16736], [-117.35743, 33.16745]]]} | Unknown Access 4 | Buena Vista Lagoon Ecological Reserve | 16489 | 2323 | North County Transit District 1006 | Special District 4 | Transportation Agency 34 | http://www.gonctd.com/ | Special District 4 | 0.498 | Buena Vista Lagoon ER | 1968 | |
12515 | 12515 | 12514 | {"type": "Polygon", "coordinates": [[[-118.60349, 34.03929], [-118.60304, 34.03933], [-118.60253, 34.03932], [-118.60254, 34.03911], [-118.60277, 34.03913], [-118.60296, 34.03912], [-118.60331, 34.03908], [-118.60345, 34.03903], [-118.60349, 34.03929]]]} | Unknown Access 4 | Las Tunas Beach | 29634 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.511 | Las Tunas Beach | ||
11471 | 11471 | 11470 | {"type": "Polygon", "coordinates": [[[-121.27655, 39.4991], [-121.2759, 39.49956], [-121.27563, 39.49942], [-121.27589, 39.49889], [-121.27615, 39.49905], [-121.27655, 39.4991]]]} | Unknown Access 4 | Yuba County Water Agency 34 | 27823 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.673 | Yuba County Water Agency 34 | ||
3043 | 3043 | 3042 | {"type": "Polygon", "coordinates": [[[-119.7272, 34.4336], [-119.72698, 34.43445], [-119.72664, 34.43545], [-119.72639, 34.43526], [-119.72657, 34.43483], [-119.72679, 34.43463], [-119.72695, 34.43445], [-119.72702, 34.43417], [-119.72681, 34.43413], [-119.72683, 34.43397], [-119.72706, 34.43399], [-119.72716, 34.43359], [-119.7272, 34.4336]]]} | Unknown Access 4 | El Mission Creek | 18514 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 0.723 | El Mission Creek | ||
11460 | 11460 | 11459 | {"type": "Polygon", "coordinates": [[[-121.27856, 39.49702], [-121.27829, 39.49721], [-121.2775, 39.49687], [-121.27778, 39.49658], [-121.27854, 39.49693], [-121.27856, 39.49702]]]} | Unknown Access 4 | Yuba County Water Agency 22 | 27811 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.771 | Yuba County Water Agency 22 | ||
11474 | 11474 | 11473 | {"type": "Polygon", "coordinates": [[[-121.27768, 39.49802], [-121.27748, 39.49831], [-121.27659, 39.49789], [-121.27678, 39.49762], [-121.27768, 39.49802]]]} | Unknown Access 4 | Yuba County Water Agency 37 | 27826 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.771 | Yuba County Water Agency 37 | ||
11462 | 11462 | 11461 | {"type": "Polygon", "coordinates": [[[-121.27764, 39.49673], [-121.27738, 39.49699], [-121.2765, 39.49656], [-121.27672, 39.49629], [-121.27764, 39.49673]]]} | Unknown Access 4 | Yuba County Water Agency 24 | 27813 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.816 | Yuba County Water Agency 24 | ||
11486 | 11486 | 11485 | {"type": "Polygon", "coordinates": [[[-121.27671, 39.49771], [-121.2765, 39.49801], [-121.27567, 39.49769], [-121.27565, 39.49761], [-121.27587, 39.49734], [-121.27671, 39.49771]]]} | Unknown Access 4 | Yuba County Water Agency 48 | 27838 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.844 | Yuba County Water Agency 48 | ||
3901 | 3901 | 3900 | {"type": "Polygon", "coordinates": [[[-119.72189, 34.42619], [-119.72175, 34.42632], [-119.72033, 34.42628], [-119.72017, 34.42625], [-119.72001, 34.4262], [-119.71978, 34.42606], [-119.71997, 34.42593], [-119.72024, 34.42605], [-119.72189, 34.42619]]]} | Unknown Access 4 | El Mission Creek | 18515 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 0.939 | El Mission Creek | ||
11469 | 11469 | 11468 | {"type": "Polygon", "coordinates": [[[-121.277, 39.49738], [-121.27682, 39.49756], [-121.27671, 39.49771], [-121.27587, 39.49733], [-121.27617, 39.49697], [-121.277, 39.49738]]]} | Unknown Access 4 | Yuba County Water Agency 32 | 27821 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.95 | Yuba County Water Agency 32 | ||
11485 | 11485 | 11484 | {"type": "Polygon", "coordinates": [[[-121.27854, 39.49693], [-121.27778, 39.49658], [-121.27854, 39.4958], [-121.27851, 39.49654], [-121.27854, 39.49693]]]} | Unknown Access 4 | Yuba County Water Agency 47 | 27837 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.973 | Yuba County Water Agency 47 | ||
11487 | 11487 | 11486 | {"type": "Polygon", "coordinates": [[[-121.27711, 39.49874], [-121.27703, 39.49881], [-121.27655, 39.499], [-121.27626, 39.49896], [-121.27605, 39.49886], [-121.27594, 39.49879], [-121.27626, 39.49835], [-121.27711, 39.49874]]]} | Unknown Access 4 | Yuba County Water Agency 49 | 27839 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.0 | Yuba County Water Agency 49 | ||
11473 | 11473 | 11472 | {"type": "Polygon", "coordinates": [[[-121.2765, 39.49801], [-121.27626, 39.49834], [-121.27594, 39.49879], [-121.27582, 39.49848], [-121.27576, 39.49805], [-121.27567, 39.49769], [-121.2765, 39.49801]]]} | Unknown Access 4 | Yuba County Water Agency 36 | 27825 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.008 | Yuba County Water Agency 36 | ||
11468 | 11468 | 11467 | {"type": "Polygon", "coordinates": [[[-121.27829, 39.49721], [-121.27799, 39.49761], [-121.27712, 39.49725], [-121.2775, 39.49687], [-121.27829, 39.49721]]]} | Unknown Access 4 | Yuba County Water Agency 31 | 27820 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.044 | Yuba County Water Agency 31 | ||
11456 | 11456 | 11455 | {"type": "Polygon", "coordinates": [[[-121.29311, 39.25371], [-121.29294, 39.2539], [-121.29268, 39.25388], [-121.29234, 39.2538], [-121.292, 39.25364], [-121.29171, 39.25346], [-121.29143, 39.25326], [-121.29142, 39.25285], [-121.29189, 39.25325], [-121.29211, 39.25341], [-121.29257, 39.25363], [-121.29289, 39.2537], [-121.29311, 39.25371]]]} | Unknown Access 4 | Yuba County Water Agency 19 | 27807 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.079 | Yuba County Water Agency 19 | ||
11470 | 11470 | 11469 | {"type": "Polygon", "coordinates": [[[-121.27799, 39.49761], [-121.27768, 39.49802], [-121.27678, 39.49762], [-121.27712, 39.49725], [-121.27799, 39.49761]]]} | Unknown Access 4 | Yuba County Water Agency 33 | 27822 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.114 | Yuba County Water Agency 33 | ||
11489 | 11489 | 11488 | {"type": "Polygon", "coordinates": [[[-121.27797, 39.49638], [-121.27764, 39.49672], [-121.27672, 39.49629], [-121.27702, 39.49592], [-121.27797, 39.49638]]]} | Unknown Access 4 | Yuba County Water Agency 6 | 27841 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.136 | Yuba County Water Agency 6 |
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]);