units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
225 rows where DES_TP = 4 and MNG_AG_LEV = 4 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, COUNTY
MNG_AGENCY >30
- Midpeninsula Regional Open Space District 50
- East Bay Regional Park District 40
- Marin County Open Space District 34
- Mountains Recreation and Conservation Authority 22
- Santa Clara Valley Open Space Authority 19
- Riverside County Habitat Conservation Agency 9
- Sonoma County Agricultural Preservation and Open Space District 8
- Monterey Peninsula Regional Park District 4
- Napa County Regional Park and Open Space District 4
- Riverside County Regional Park and Open Space District 3
- Livermore Area Recreation and Park District 3
- Conejo Open Space Conservation Agency 3
- North County Transit District 3
- Santa Barbara Flood Control and Water Conserv. District 2
- Greater Vallejo Recreation and Park District 2
- Sunrise Recreation and Park District 2
- Watershed Conservation Authority 2
- Los Cerritos Wetland Authority 2
- San Diego Unified Port District 1
- Carmichael Recreation and Park District 1
- Kaweah Delta Water Conservation District 1
- Arcade Creek Recreation and Park District 1
- Santa Clara Valley Water District 1
- Cambria Community Services District 1
- Fallbrook Public Utility District 1
- Moss Landing Harbor District 1
- Coachella Valley Water District 1
- Mariposa Public Utility District 1
- Orangevale Recreation and Park District 1
- Western Riverside County Regional Conservation Authority 1
- …
MNG_AG_TYP 11
ACCESS_TYP 4
- Open Access 135
- No Public Access 61
- Restricted Access 23
- Unknown Access 6
DES_TP 1
- Local Conservation Area · 225 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15921 | 15921 | 15920 | {"type": "Polygon", "coordinates": [[[-122.34943, 37.42376], [-122.34901, 37.4238], [-122.34867, 37.42379], [-122.34867, 37.42379], [-122.34943, 37.42376]]]} | Open Access 1 | 17888 | Purisima Creek Redwoods Open Space Preserve | 6528 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_purisima.asp | San Mateo 15 | 0.029 | Purisima Creek Redwoods OSP | 1982 | Local Conservation Area 4 | 2 |
16990 | 16990 | 16989 | {"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 | 46460 | 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 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.036 | Verdugo Mtns. OSP | 0 | Local Conservation Area 4 | 2 | |
4940 | 4940 | 4939 | {"type": "Polygon", "coordinates": [[[-122.02404, 37.66917], [-122.02383, 37.66911], [-122.02395, 37.66891], [-122.02396, 37.66892], [-122.02404, 37.66917]]]} | Restricted Access 2 | 10715 | Chabot - Garin Trail Corridor | 17108 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 0.064 | Chabot - Garin Trail Corridor | 0 | Local Conservation Area 4 | 2 | |
6062 | 6062 | 6061 | {"type": "MultiPolygon", "coordinates": [[[[-122.20757, 37.85174], [-122.20746, 37.85172], [-122.20671, 37.85161], [-122.20702, 37.85157], [-122.20719, 37.85158], [-122.20729, 37.85161], [-122.20757, 37.85174]]], [[[-122.20889, 37.85194], [-122.20883, 37.85193], [-122.20798, 37.8518], [-122.20816, 37.85178], [-122.2088, 37.85167], [-122.20889, 37.85194]]]]} | Open Access 1 | 776 | Sibley Volcanic Regional Preserve | 3318 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/sibley | Alameda 17 | 0.39 | Sibley Volcanic RPr | 1936 | Local Conservation Area 4 | 2 |
13166 | 13166 | 13165 | {"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.16668], [-117.35696, 33.1667], [-117.35728, 33.16704], [-117.35724, 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 | 45147 | Buena Vista Lagoon Ecological Reserve | 16489 | 2323 | North County Transit District 1046 | Special District 4 | Transportation Agency 32 | http://www.gonctd.com/ | Special District 4 | 2323 | North County Transit District 1006 | Special District 4 | Transportation Agency 34 | San Diego 4 | 0.497 | Buena Vista Lagoon ER | 1968 | Local Conservation Area 4 | 2 | |
5089 | 5089 | 5088 | {"type": "Polygon", "coordinates": [[[-119.73541, 34.4041], [-119.73541, 34.40426], [-119.73437, 34.40428], [-119.73407, 34.4042], [-119.73417, 34.40413], [-119.73405, 34.40365], [-119.73466, 34.40398], [-119.73541, 34.4041]]]} | Open Access 1 | 13858 | Douglas Family Reserve | 18244 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 1.023 | Douglas Family Reserve | 0 | Local Conservation Area 4 | 2 | |
7232 | 7232 | 7231 | {"type": "Polygon", "coordinates": [[[-118.44646, 34.13576], [-118.44628, 34.13615], [-118.44605, 34.13646], [-118.44587, 34.13678], [-118.44548, 34.13674], [-118.44557, 34.13626], [-118.44578, 34.13618], [-118.44599, 34.13604], [-118.44613, 34.13585], [-118.44621, 34.13569], [-118.44646, 34.13576]]]} | Open Access 1 | 6404 | Oak Forest Canyon Natural Area | 22963 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 1.136 | Oak Forest Canyon Natural Area | 0 | Local Conservation Area 4 | 2 | |
11852 | 11852 | 11851 | {"type": "Polygon", "coordinates": [[[-121.3458, 38.65498], [-121.34511, 38.65498], [-121.3451, 38.65518], [-121.34476, 38.65518], [-121.34476, 38.65451], [-121.34502, 38.6545], [-121.3458, 38.65451], [-121.3458, 38.65498]]]} | Open Access 1 | 24287 | Holyoke Nature Area | 20058 | 2201 | Arcade Creek Recreation and Park District 739 | Special District 4 | Recreation/Parks District 4 | http://www.acrpd.com/ | Special District 4 | 2201 | Arcade Creek Recreation and Park District 724 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 1.344 | Holyoke Nature Area | 0 | Local Conservation Area 4 | 2 | |
14768 | 14768 | 14767 | {"type": "Polygon", "coordinates": [[[-117.31758, 33.10576], [-117.31739, 33.10582], [-117.31597, 33.10271], [-117.3161, 33.10265], [-117.31758, 33.10576]]]} | Unknown Access 4 | 45154 | Poinsettia Lane Vernal Pools | 23843 | 2323 | North County Transit District 1046 | Special District 4 | Transportation Agency 32 | http://www.gonctd.com/ | Special District 4 | 2323 | North County Transit District 1006 | Special District 4 | Transportation Agency 34 | San Diego 4 | 1.476 | Poinsettia Lane Vernal Pools | 0 | Local Conservation Area 4 | 2 | |
14182 | 14182 | 14181 | {"type": "Polygon", "coordinates": [[[-122.3732, 37.97143], [-122.37282, 37.97158], [-122.37227, 37.97224], [-122.37225, 37.97251], [-122.37217, 37.97255], [-122.37148, 37.97255], [-122.37238, 37.97143], [-122.3732, 37.97143]]]} | No Public Access 3 | 43103 | North Richmond Wetlands | 22856 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 1.61 | North Richmond Wetlands | 0 | Local Conservation Area 4 | 2 | |
7268 | 7268 | 7267 | {"type": "Polygon", "coordinates": [[[-118.66547, 34.09257], [-118.66492, 34.09257], [-118.66491, 34.09075], [-118.66545, 34.09076], [-118.66547, 34.09257]]]} | Restricted Access 2 | 6488 | Cold Creek Canyon Preserve | 17481 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 2.52 | Cold Creek Canyon Preserve | 0 | Local Conservation Area 4 | 2 | |
3558 | 3558 | 3557 | {"type": "Polygon", "coordinates": [[[-122.34141, 37.899], [-122.33912, 37.89903], [-122.33911, 37.89846], [-122.3414, 37.89842], [-122.34141, 37.899]]]} | No Public Access 3 | 15364 | Brooks Island Regional Preserve | 31524 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 3.177 | Brooks Island RPr | 0 | Local Conservation Area 4 | 2 | |
3617 | 3617 | 3616 | {"type": "Polygon", "coordinates": [[[-122.74565, 38.48914], [-122.74561, 38.49073], [-122.74474, 38.49073], [-122.74477, 38.48913], [-122.74565, 38.48914]]]} | Restricted Access 2 | 29390 | Dogbane Preserve | 18185 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 3.337 | Dogbane Preserve | 1997 | Local Conservation Area 4 | 2 | |
2068 | 2068 | 2067 | {"type": "Polygon", "coordinates": [[[-121.93333, 36.50126], [-121.93326, 36.50153], [-121.93266, 36.50142], [-121.93222, 36.50144], [-121.93206, 36.50171], [-121.93202, 36.50193], [-121.93202, 36.50211], [-121.93237, 36.50231], [-121.93186, 36.50242], [-121.93146, 36.50254], [-121.93119, 36.50253], [-121.93114, 36.50254], [-121.93127, 36.50272], [-121.93136, 36.50297], [-121.93161, 36.5032], [-121.93153, 36.50331], [-121.93128, 36.50335], [-121.93096, 36.50323], [-121.93074, 36.50311], [-121.93058, 36.50294], [-121.93043, 36.50283], [-121.93107, 36.50243], [-121.93107, 36.50242], [-121.93099, 36.50237], [-121.93084, 36.50218], [-121.93118, 36.50214], [-121.9312, 36.50217], [-121.9315, 36.50207], [-121.93171, 36.50176], [-121.93173, 36.50144], [-121.93207, 36.50111], [-121.9323, 36.50095], [-121.93268, 36.50063], [-121.93302, 36.50082], [-121.93284, 36.50113], [-121.93333, 36.50126]]]} | Restricted Access 2 | 17207 | Laidlaw-Apte Pine Forest Reserve | 20872 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 4.771 | Laidlaw-Apte Pine Forest Reserve | 0 | Local Conservation Area 4 | 2 | |
9975 | 9975 | 9974 | {"type": "Polygon", "coordinates": [[[-122.11034, 37.25814], [-122.1099, 37.25831], [-122.10963, 37.25848], [-122.10956, 37.25855], [-122.10952, 37.25863], [-122.10951, 37.25873], [-122.10953, 37.25882], [-122.10846, 37.25883], [-122.10844, 37.25755], [-122.11032, 37.25756], [-122.11034, 37.25814]]]} | No Public Access 3 | 47967 | Saratoga Gap Open Space Preserve | 31468 | 373 | Santa Clara, County of 941 | County 3 | County Agency 3 | http://www.sccgov.org/sites/scc/Pages/default.aspx | County 3 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_saratoga_gap.asp | Santa Clara 19 | 4.827 | Saratoga Gap OSP | 2006 | Local Conservation Area 4 | 2 |
6661 | 6661 | 6660 | {"type": "MultiPolygon", "coordinates": [[[[-119.52905, 34.3961], [-119.52846, 34.39735], [-119.52762, 34.39923], [-119.52766, 34.39927], [-119.52741, 34.39995], [-119.5269, 34.39971], [-119.52637, 34.39941], [-119.52672, 34.39929], [-119.52671, 34.39926], [-119.52674, 34.39925], [-119.52683, 34.39932], [-119.52708, 34.39925], [-119.52717, 34.39921], [-119.52737, 34.39902], [-119.52739, 34.39902], [-119.5288, 34.39601], [-119.52905, 34.3961]]], [[[-119.53027, 34.40061], [-119.5299, 34.40115], [-119.52919, 34.40081], [-119.52943, 34.40021], [-119.53027, 34.40061]]]]} | Restricted Access 2 | 4718 | Carpinteria Salt Marsh Reserve | 16900 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 5.152 | Carpinteria Salt Marsh Reserve | 0 | Local Conservation Area 4 | 2 | |
11975 | 11975 | 11974 | {"type": "Polygon", "coordinates": [[[-122.21029, 37.33464], [-122.21012, 37.33619], [-122.20954, 37.33542], [-122.20931, 37.3353], [-122.20907, 37.33507], [-122.20787, 37.33496], [-122.20832, 37.3339], [-122.20853, 37.33408], [-122.20943, 37.33451], [-122.21029, 37.33464]]]} | No Public Access 3 | 35055 | Coal Creek Open Space Preserve | 31502 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_coal_creek.asp | San Mateo 15 | 5.246 | Coal Creek OSP | 0 | Local Conservation Area 4 | 2 |
11606 | 11606 | 11605 | {"type": "Polygon", "coordinates": [[[-121.39534, 38.61331], [-121.39524, 38.61346], [-121.39523, 38.61377], [-121.3953, 38.61409], [-121.39469, 38.61448], [-121.39334, 38.6141], [-121.39334, 38.61281], [-121.39398, 38.61283], [-121.394, 38.61331], [-121.39534, 38.61331]]]} | Open Access 1 | 23971 | Creekside Nature Area | 17769 | 2192 | Fulton - El Camino 984 | Special District 4 | Special District - Other 26 | http://www.fecrecpark.com/index.htm | Special District 4 | 2192 | Fulton - El Camino 948 | Special District 4 | Special District - Other 24 | Sacramento 41 | 5.27 | Creekside Nature Area | 0 | Local Conservation Area 4 | 2 | |
16287 | 16287 | 16286 | {"type": "Polygon", "coordinates": [[[-122.22124, 37.86457], [-122.22068, 37.86515], [-122.21997, 37.86481], [-122.21728, 37.86206], [-122.21756, 37.8619], [-122.21817, 37.86235], [-122.21846, 37.86264], [-122.21904, 37.86315], [-122.21933, 37.86325], [-122.21963, 37.86351], [-122.22001, 37.86389], [-122.22037, 37.86416], [-122.22067, 37.86434], [-122.22124, 37.86457]]]} | Open Access 1 | 22015 | Claremont Canyon Regional Preserve | 17381 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 6.337 | Claremont Canyon RPr | 1985 | Local Conservation Area 4 | 2 | |
14222 | 14222 | 14221 | {"type": "Polygon", "coordinates": [[[-122.20351, 38.11873], [-122.20328, 38.11883], [-122.20313, 38.11904], [-122.20284, 38.11927], [-122.20219, 38.11961], [-122.20174, 38.11972], [-122.20122, 38.12015], [-122.20077, 38.1204], [-122.20056, 38.12044], [-122.20036, 38.12056], [-122.20022, 38.12088], [-122.19972, 38.12162], [-122.19969, 38.12201], [-122.19851, 38.12033], [-122.19912, 38.12062], [-122.20048, 38.12015], [-122.2031, 38.11852], [-122.20351, 38.11873]]]} | Open Access 1 | 44102 | Blue Rock Springs Corridor | 16188 | 2224 | Greater Vallejo Recreation and Park District 341 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | Solano 26 | 6.569 | Blue Rock Springs Corridor | 0 | Local Conservation Area 4 | 2 |
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]);