units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
386 rows where ACCESS_TYP = 4 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER, PARK_URL, YR_EST, GAP_STS
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 149
- Yuba County Water Agency 48
- National Audubon Society 23
- California Department of Transportation 15
- Santa Barbara, County of 13
- Santa Barbara, City of 12
- Save the Redwoods League 10
- San Joaquin River Parkway and Conservation Trust 8
- California State Lands Commission 7
- Sacramento, County of 7
- Riverside, County of 6
- Santa Barbara Flood Control and Water Conserv. District 4
- Wilderness Land Trust 4
- California Wildlife Conservation Board 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
- Ramona Municipal Water District 2
- San Diego, City of 1
- Fresno, City of 1
- United States Forest Service 1
- …
DES_TP >30
- Local Other or Unknown 204
- Private Conservation 52
- State Other or Unknown 18
- Local Recreation Area 16
- Local Conservation Area 11
- Private Other or Unknown 10
- State Resource Management Area 7
- Local Park 5
- National Monument or Landmark 3
- Recreation Management Area 1
- Private Recreation or Education 1
- Local Resource Management Area 1
- Federal Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
AGNCY_TYP 18 ✖
- Open Space District 135
- Water District 59
- State Agency 40
- County Agency 36
- Non Profit - Land Trust 36
- City Agency 29
- Non Profit - Conservation 23
- Flood District 7
- Federal Agency 6
- Transportation Agency 4
- Mitigation Bank 3
- Recreation/Parks District 2
- County Agency - Parks 1
- Irrigation District 1
- Sanitation District 1
- Commercial 1
- Non Profit - Other 1
- Conservation District 1
MNG_AG_TYP 15
- Open Space District 151
- Water District 55
- Non Profit - Land Trust 40
- County Agency 36
- City Agency 29
- State Agency 28
- Non Profit - Conservation 23
- 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
MNG_AG_LEV 7 ✖
- Special District 219
- Non Profit 64
- County 37
- City 29
- State 28
- Federal 6
- Private 3
ACCESS_TYP 1
- Unknown Access · 386 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1273 | 1273 | 1272 | {"type": "Polygon", "coordinates": [[[-118.21161, 34.50894], [-118.21051, 34.50893], [-118.21051, 34.50802], [-118.2116, 34.50803], [-118.21161, 34.50894]]]} | Unknown Access 4 | 9563 | Red Rover Mine TaxDef | 24228 | 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.509 | Red Rover Mine TaxDef | None 110 | |||
1584 | 1584 | 1583 | {"type": "Polygon", "coordinates": [[[-117.09349, 33.56898], [-117.0926, 33.57066], [-117.08388, 33.57076], [-117.08394, 33.56909], [-117.09349, 33.56898]]]} | Unknown Access 4 | 12140 | French Valley Conservation Area, Expansion 1 | 19108 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 38.849 | French Valley Conservation Area, Expansion 1 | None 128 | |||
1681 | 1681 | 1680 | {"type": "Polygon", "coordinates": [[[-117.56495, 33.66821], [-117.5606, 33.66822], [-117.56061, 33.67181], [-117.55625, 33.67183], [-117.55624, 33.66465], [-117.56493, 33.66461], [-117.56495, 33.66821]]]} | Unknown Access 4 | 12688 | Trabuco Canyon Water District lands | 26502 | 2166 | Trabuco Canyon Water District 406 | Special District 4 | Water District 13 | http://www.tcwd.ca.gov/ | Special District 4 | 2166 | Trabuco Canyon Water District 400 | Special District 4 | Water District 13 | Orange 3 | 119.276 | Trabuco Canyon Water District lands | None 135 | |||
1986 | 1986 | 1985 | {"type": "Polygon", "coordinates": [[[-119.79036, 36.76947], [-119.78888, 36.76947], [-119.78887, 36.7687], [-119.78891, 36.76869], [-119.78909, 36.7686], [-119.79, 36.76854], [-119.79001, 36.76798], [-119.79035, 36.76797], [-119.79036, 36.76947]]]} | Unknown Access 4 | 15187 | Ratcliffe Stadium | 24192 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 3.753 | Ratcliffe Stadium | None 158 | |||
2134 | 2134 | 2133 | {"type": "Polygon", "coordinates": [[[-121.32208, 36.402], [-121.32178, 36.40221], [-121.32097, 36.40256], [-121.31938, 36.40316], [-121.31871, 36.40382], [-121.31838, 36.40545], [-121.318, 36.40469], [-121.31752, 36.40383], [-121.31755, 36.40364], [-121.31762, 36.40347], [-121.31775, 36.40326], [-121.31788, 36.40313], [-121.3181, 36.40297], [-121.31862, 36.40285], [-121.31927, 36.40262], [-121.31975, 36.40242], [-121.32168, 36.40147], [-121.32188, 36.40139], [-121.32208, 36.402]]]} | Unknown Access 4 | 17419 | Los Coches Adobe | 21512 | 1336 | Soledad, City of 485 | City 2 | City Agency 2 | http://www.cityofsoledad.com/ | City 2 | 1336 | Soledad, City of 476 | City 2 | City Agency 2 | Monterey 14 | 10.355 | Los Coches Adobe | None 173 | |||
2239 | 2239 | 2238 | {"type": "Polygon", "coordinates": [[[-119.81102, 36.87326], [-119.80959, 36.87329], [-119.8096, 36.87351], [-119.81007, 36.87379], [-119.81022, 36.87384], [-119.81101, 36.87381], [-119.81092, 36.88017], [-119.80915, 36.88029], [-119.80178, 36.8809], [-119.79911, 36.88089], [-119.80337, 36.87899], [-119.80477, 36.87934], [-119.80542, 36.8792], [-119.8063, 36.87931], [-119.8063, 36.8783], [-119.80622, 36.87802], [-119.80565, 36.87825], [-119.80549, 36.8785], [-119.80516, 36.87785], [-119.79392, 36.8778], [-119.79337, 36.87782], [-119.79334, 36.87681], [-119.79332, 36.8768], [-119.7933, 36.87682], [-119.79325, 36.87549], [-119.79577, 36.8744], [-119.80082, 36.87025], [-119.80215, 36.86845], [-119.80261, 36.86797], [-119.80445, 36.86616], [-119.80599, 36.86497], [-119.80929, 36.86355], [-119.80935, 36.86353], [-119.81041, 36.86422], [-119.81111, 36.86607], [-119.81102, 36.87326]]]} | Unknown Access 4 | 16693 | Van Buren Unit | 26820 | 2345 | Tehachapi-Cummings County Water District 499 | Special District 4 | Water District 13 | http://tccwd.com/ | Special District 4 | 3069 | San Joaquin River Parkway and Conservation Trust 491 | Non Profit 6 | Non Profit - Land Trust 10 | Madera 48 | 433.198 | Van Buren Unit | None 186 | |||
2752 | 2752 | 2751 | {"type": "Polygon", "coordinates": [[[-121.26584, 38.41176], [-121.26406, 38.41179], [-121.26392, 38.41155], [-121.26373, 38.41107], [-121.26365, 38.41082], [-121.2645, 38.41003], [-121.26465, 38.41], [-121.26491, 38.41005], [-121.26516, 38.4102], [-121.26531, 38.41033], [-121.2654, 38.41046], [-121.26549, 38.41072], [-121.26554, 38.41094], [-121.26582, 38.41152], [-121.26584, 38.41165], [-121.26584, 38.41176]]]} | Unknown Access 4 | 21481 | Green Rd Subdivision Map | 19466 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 6.621 | Green Rd Subdivision Map | None 230 | |||
2876 | 2876 | 2875 | {"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 | 22243 | Schnabel Tentative Parcel Map | 25185 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.366 | Schnabel Tentative Parcel Map | None 240 | |||
3158 | 3158 | 3157 | {"type": "Polygon", "coordinates": [[[-121.08887, 38.32906], [-121.08872, 38.32997], [-121.0886, 38.33024], [-121.08831, 38.33059], [-121.08712, 38.33171], [-121.0868, 38.33162], [-121.08621, 38.33112], [-121.08608, 38.33088], [-121.08604, 38.33063], [-121.08614, 38.33054], [-121.08636, 38.33047], [-121.08658, 38.3303], [-121.08671, 38.33014], [-121.08694, 38.32905], [-121.08887, 38.32906]]]} | Unknown Access 4 | 21825 | Smud | 25577 | 2129 | Sacramento Municipal Utility District 591 | Special District 4 | Water District 13 | http://www.smud.org/ | Special District 4 | 2129 | Sacramento Municipal Utility District 581 | Special District 4 | Water District 13 | Sacramento 41 | 10.95 | Smud | None 258 | |||
3753 | 3753 | 3752 | {"type": "Polygon", "coordinates": [[[-119.69543, 34.43397], [-119.69509, 34.43541], [-119.69424, 34.43536], [-119.69419, 34.43629], [-119.69257, 34.4363], [-119.69256, 34.43377], [-119.69278, 34.4335], [-119.6928, 34.43343], [-119.69302, 34.43324], [-119.69368, 34.43246], [-119.69391, 34.43263], [-119.69364, 34.43294], [-119.69351, 34.43319], [-119.69331, 34.43328], [-119.69335, 34.43335], [-119.69344, 34.43332], [-119.69346, 34.43333], [-119.69364, 34.43368], [-119.69373, 34.43372], [-119.69382, 34.43371], [-119.69382, 34.43374], [-119.69527, 34.43376], [-119.69515, 34.43396], [-119.69543, 34.43397]]]} | Unknown Access 4 | 467 | Santa Barbara Bowl | 25038 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 16.55 | Santa Barbara Bowl | None 315 | |||
3783 | 3783 | 3782 | {"type": "Polygon", "coordinates": [[[-121.75364, 36.487], [-121.75279, 36.48783], [-121.7518, 36.48836], [-121.75076, 36.4881], [-121.75052, 36.48825], [-121.75067, 36.48844], [-121.7499, 36.48882], [-121.74643, 36.48407], [-121.74641, 36.484], [-121.74643, 36.48389], [-121.74641, 36.48383], [-121.74632, 36.48377], [-121.74621, 36.48377], [-121.74493, 36.48202], [-121.74586, 36.48073], [-121.75297, 36.48553], [-121.75243, 36.48657], [-121.75263, 36.48678], [-121.75293, 36.48659], [-121.75364, 36.487]]]} | Unknown Access 4 | 8686 | Condon | 17579 | 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 | 70.591 | Condon | None 317 | |||
3955 | 3955 | 3954 | {"type": "Polygon", "coordinates": [[[-118.26969, 34.25985], [-118.2653, 34.25981], [-118.26529, 34.25816], [-118.26968, 34.25821], [-118.26969, 34.25985]]]} | Unknown Access 4 | 46417 | Haines Canyon | 29694 | 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 | 18.279 | Haines Canyon | None 341 | |||
4291 | 4291 | 4290 | {"type": "Polygon", "coordinates": [[[-117.96399, 33.63508], [-117.96237, 33.63687], [-117.96074, 33.63584], [-117.95743, 33.63372], [-117.958, 33.63182], [-117.96399, 33.63508]]]} | Unknown Access 4 | 14646 | Talbert Marsh | 26170 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 34.691 | Talbert Marsh | None 375 | |||
4309 | 4309 | 4308 | {"type": "Polygon", "coordinates": [[[-118.6329, 34.27478], [-118.63179, 34.27479], [-118.63171, 34.27158], [-118.63223, 34.2712], [-118.63279, 34.2712], [-118.6329, 34.27478]]]} | Unknown Access 4 | 10272 | Rocky Peak Adj. Tax Default | 24544 | 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 | 9.687 | Rocky Peak Adj. Tax Default | None 381 | |||
4370 | 4370 | 4369 | {"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 | 45826 | San Juan Garage | 28845 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.124 | San Juan Garage | None 386 | |||
4371 | 4371 | 4370 | {"type": "MultiPolygon", "coordinates": [[[[-118.24124, 33.92765], [-118.24116, 33.9276], [-118.24085, 33.92733], [-118.24124, 33.92733], [-118.24124, 33.92765]]], [[[-118.24433, 33.92779], [-118.24433, 33.92814], [-118.24389, 33.92811], [-118.2427, 33.92796], [-118.24172, 33.92781], [-118.24433, 33.92779]]], [[[-118.24465, 33.92779], [-118.24465, 33.92817], [-118.24449, 33.92815], [-118.24449, 33.92779], [-118.24465, 33.92779]]], [[[-118.24611, 33.9282], [-118.24572, 33.9282], [-118.24571, 33.92817], [-118.24482, 33.92817], [-118.24482, 33.92779], [-118.24607, 33.92779], [-118.24611, 33.92784], [-118.24611, 33.9282]]]]} | Unknown Access 4 | 45850 | 117th and Compton | 28898 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 2.884 | 117th and Compton | None 387 | |||
4961 | 4961 | 4960 | {"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 | 3659 | 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 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.186 | Las Casas - Grenola | None 411 | |||
5162 | 5162 | 5161 | {"type": "Polygon", "coordinates": [[[-120.28838, 34.6322], [-120.28819, 34.63214], [-120.28749, 34.63204], [-120.28601, 34.6281], [-120.2848, 34.626], [-120.2853, 34.62489], [-120.28414, 34.61969], [-120.28535, 34.61953], [-120.28645, 34.62558], [-120.28607, 34.62652], [-120.28748, 34.62894], [-120.28838, 34.6322]]]} | Unknown Access 4 | 17 | RHR, Santa Rosa Creek | 24314 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | Santa Barbara 7 | 34.432 | RHR, Santa Rosa Creek | None 418 | |||
5327 | 5327 | 5326 | {"type": "Polygon", "coordinates": [[[-118.54192, 34.34956], [-118.5414, 34.34944], [-118.54058, 34.34899], [-118.54043, 34.34858], [-118.53937, 34.348], [-118.54132, 34.348], [-118.5413, 34.34712], [-118.54183, 34.34712], [-118.54192, 34.34956]]]} | Unknown Access 4 | 5651 | Newhall Pass | 22727 | 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 | 6.619 | Newhall Pass | None 432 | |||
5339 | 5339 | 5338 | {"type": "Polygon", "coordinates": [[[-121.76487, 36.22671], [-121.76455, 36.22693], [-121.76407, 36.227], [-121.76385, 36.22719], [-121.76369, 36.22707], [-121.76348, 36.22697], [-121.76368, 36.22607], [-121.76441, 36.22592], [-121.76478, 36.22637], [-121.76487, 36.22671]]]} | Unknown Access 4 | 15853 | First Growth | 18915 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 2.843 | First Growth | None 434 |
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]);