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)
Suggested facets: PARK_URL, MNG_AG_LEV, LAYER, YR_EST
MNG_AGENCY >30
- Yuba County Water Agency 48
- Mountains Recreation and Conservation Authority 35
- National Audubon Society 22
- California Department of Transportation 15
- Santa Barbara, County of 13
- Santa Barbara, City of 12
- San Joaquin River Parkway and Conservation Trust 8
- Sacramento, County of 7
- Riverside, County of 6
- Save the Redwoods League 5
- Santa Barbara Flood Control and Water Conserv. District 4
- North County Transit District 4
- Los Angeles, County of 3
- Monterey, County of 3
- Los Angeles, City 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
- 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 54
- Open Space District 37
- County Agency 36
- Non Profit - Land Trust 32
- City Agency 29
- Non Profit - Conservation 22
- 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
ACCESS_TYP 1
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
11999 | 11999 | 11998 | {"type": "Polygon", "coordinates": [[[-118.47207, 33.99034], [-118.47192, 33.99044], [-118.47173, 33.99025], [-118.47189, 33.99014], [-118.47207, 33.99034]]]} | Unknown Access 4 | San Juan Garage | 28845 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.124 | San Juan Garage | ||
9291 | 9291 | 9290 | {"type": "Polygon", "coordinates": [[[-119.7228, 34.40994], [-119.7227, 34.41018], [-119.72251, 34.41013], [-119.72261, 34.40986], [-119.72277, 34.4099], [-119.7228, 34.40994]]]} | Unknown Access 4 | Santa Barbara holding 5 | 25047 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 0.148 | Santa Barbara holding 5 | ||
9293 | 9293 | 9292 | {"type": "Polygon", "coordinates": [[[-119.72232, 34.41009], [-119.72219, 34.41042], [-119.722, 34.41037], [-119.72213, 34.41004], [-119.72232, 34.41009]]]} | Unknown Access 4 | Santa Barbara holding 7 | 25049 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 0.176 | Santa Barbara holding 7 | ||
6011 | 6011 | 6010 | {"type": "Polygon", "coordinates": [[[-118.54326, 34.04416], [-118.54305, 34.04417], [-118.54302, 34.0442], [-118.54286, 34.04405], [-118.54306, 34.04392], [-118.54313, 34.04389], [-118.54316, 34.04389], [-118.54323, 34.04403], [-118.54326, 34.04416]]]} | Unknown Access 4 | Las Casas - Grenola | 21045 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.186 | Las Casas - Grenola | ||
4792 | 4792 | 4791 | {"type": "Polygon", "coordinates": [[[-120.57752, 34.96378], [-120.57752, 34.96399], [-120.57714, 34.96399], [-120.57714, 34.96377], [-120.57752, 34.96378]]]} | Unknown Access 4 | Guadalupe holding 9 | 19554 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.205 | Guadalupe holding 9 | |||
11429 | 11429 | 11428 | {"type": "Polygon", "coordinates": [[[-121.27862, 39.49732], [-121.27862, 39.49732], [-121.27803, 39.49771], [-121.27838, 39.49725], [-121.27858, 39.49713], [-121.27862, 39.49732]]]} | Unknown Access 4 | Yuba County Water Agency 15 | 27803 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.215 | Yuba County Water Agency 15 | ||
12087 | 12087 | 12086 | {"type": "Polygon", "coordinates": [[[-124.10344, 40.4928], [-124.10326, 40.49301], [-124.10325, 40.49313], [-124.10297, 40.49313], [-124.10296, 40.49296], [-124.103, 40.49297], [-124.10313, 40.4928], [-124.10344, 40.4928]]]} | Unknown Access 4 | Unnamed site - Rio Dell, City of | 30545 | 1435 | Rio Dell, City of 632 | City 2 | City Agency 2 | http://www.riodellcity.com/ | City 2 | 0.236 | |||
6312 | 6312 | 6311 | {"type": "Polygon", "coordinates": [[[-118.6131, 34.15759], [-118.61284, 34.15773], [-118.61261, 34.15756], [-118.61257, 34.1575], [-118.61278, 34.15736], [-118.6131, 34.15759]]]} | Unknown Access 4 | Llano | 21388 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.253 | Llano | ||
9401 | 9401 | 9400 | {"type": "Polygon", "coordinates": [[[-118.5607, 34.04133], [-118.56059, 34.04153], [-118.56053, 34.04148], [-118.56016, 34.04145], [-118.5602, 34.04121], [-118.56031, 34.04121], [-118.56046, 34.04127], [-118.5607, 34.04133]]]} | Unknown Access 4 | Schwartz Property | 25197 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.267 | Schwartz Property | ||
9292 | 9292 | 9291 | {"type": "Polygon", "coordinates": [[[-119.72261, 34.40986], [-119.72251, 34.41013], [-119.72213, 34.41004], [-119.72223, 34.40976], [-119.72261, 34.40986]]]} | Unknown Access 4 | Santa Barbara holding 6 | 25048 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 0.289 | Santa Barbara holding 6 | ||
11457 | 11457 | 11456 | {"type": "Polygon", "coordinates": [[[-121.33233, 39.44338], [-121.33233, 39.44361], [-121.3318, 39.44361], [-121.3318, 39.44338], [-121.33233, 39.44338]]]} | Unknown Access 4 | Yuba County Water Agency 2 | 27808 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.291 | Yuba County Water Agency 2 | ||
1118 | 1118 | 1117 | {"type": "Polygon", "coordinates": [[[-120.11817, 34.66507], [-120.11816, 34.66546], [-120.11783, 34.66545], [-120.11784, 34.66507], [-120.11817, 34.66507]]]} | Unknown Access 4 | Alamo Pintado Creek | 15319 | 2147 | Santa Ynez River Water Conservation District 925 | Special District 4 | Water District 13 | Special District 4 | 0.321 | Alamo Pintado Creek | |||
9288 | 9288 | 9287 | {"type": "Polygon", "coordinates": [[[-119.7227, 34.41018], [-119.72259, 34.41048], [-119.72256, 34.4105], [-119.72219, 34.41042], [-119.72232, 34.41009], [-119.7227, 34.41018]]]} | Unknown Access 4 | Santa Barbara holding 2 | 25044 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 0.342 | Santa Barbara holding 2 | ||
12025 | 12025 | 12024 | {"type": "Polygon", "coordinates": [[[-118.19408, 33.89118], [-118.19324, 33.89119], [-118.19323, 33.89102], [-118.19407, 33.89102], [-118.19408, 33.89118]]]} | Unknown Access 4 | Washington Ave Park | 28912 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.359 | Washington Ave Park | ||
9393 | 9393 | 9392 | {"type": "Polygon", "coordinates": [[[-121.25202, 38.40904], [-121.25157, 38.40901], [-121.25157, 38.40891], [-121.25154, 38.40884], [-121.25164, 38.40866], [-121.25175, 38.40863], [-121.25192, 38.40869], [-121.25202, 38.40883], [-121.25202, 38.40904]]]} | Unknown Access 4 | Schnabel Tentative Parcel Map | 25185 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 0.365 | Schnabel Tentative Parcel Map | ||
6966 | 6966 | 6965 | {"type": "Polygon", "coordinates": [[[-118.57899, 34.14891], [-118.57845, 34.14895], [-118.57849, 34.14866], [-118.57892, 34.14859], [-118.57899, 34.14891]]]} | Unknown Access 4 | MGP Entrance | 22194 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.379 | MGP Entrance | ||
12473 | 12473 | 12472 | {"type": "Polygon", "coordinates": [[[-118.62073, 34.19735], [-118.62041, 34.19737], [-118.6201, 34.19741], [-118.6198, 34.19749], [-118.6194, 34.19763], [-118.6194, 34.1975], [-118.6193, 34.19749], [-118.6193, 34.19744], [-118.61926, 34.19743], [-118.61925, 34.19737], [-118.6188, 34.19737], [-118.6188, 34.19735], [-118.62073, 34.19735]]]} | Unknown Access 4 | Bell Creek Park | 29516 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.385 | Bell Creek Park | ||
11459 | 11459 | 11458 | {"type": "Polygon", "coordinates": [[[-121.2633, 39.4399], [-121.26298, 39.44032], [-121.26282, 39.44033], [-121.26271, 39.44023], [-121.26276, 39.43992], [-121.2633, 39.4399]]]} | Unknown Access 4 | Yuba County Water Agency 21 | 27810 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.391 | Yuba County Water Agency 21 | ||
10172 | 10172 | 10171 | {"type": "Polygon", "coordinates": [[[-119.67342, 34.42333], [-119.67318, 34.42356], [-119.67274, 34.42324], [-119.67299, 34.42301], [-119.67342, 34.42333]]]} | Unknown Access 4 | Sycamore Creek | 26121 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 0.446 | Sycamore Creek |
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]);