units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
969 rows where ACCESS_TYP = 3 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, MNG_AG_LEV
MNG_AGENCY >30
- California Department of Fish and Wildlife 79
- East Bay Regional Park District 47
- Los Angeles, City of 36
- The Nature Conservancy 32
- Las Virgenes Municipal Water District 28
- Peninsula Open Space Trust 24
- Natomas Basin Conservancy 22
- Rivers and Lands Conservancy 22
- The Environmental Trust 21
- Torrance, City of 20
- Mountains Restoration Trust 20
- San Diego, City of 19
- Midpeninsula Regional Open Space District 19
- Santa Clara Valley Open Space Authority 18
- United States Fish and Wildlife Service 16
- Fresno Metropolitan Flood Control District 16
- California Department of Parks and Recreation 15
- Endangered Habitats Conservancy 14
- San Diego, County of 14
- Los Angeles County Flood Control District 13
- Kinneloa Irrigation District 13
- Santa Clara County Parks and Recreation Dept., County of 13
- American River Conservancy 13
- Save Mount Diablo 13
- Littlerock Creek Irrigation District 13
- Napa, City of 12
- Sonoma Land Trust 11
- Sonoma County Agricultural Preservation and Open Space District 11
- California Department of Water Resources 11
- California Department of General Services 10
- …
DES_TP >30
- Private Conservation 211
- Local Recreation Area 113
- Local Other or Unknown 96
- Local Park 77
- Local Conservation Area 77
- State Resource Management Area 64
- Private Recreation or Education 25
- Private Other or Unknown 25
- State Conservation Area 22
- State Other or Unknown 19
- National Wildlife Refuge 14
- Local Resource Management Area 8
- State Park 5
- Private Agricultural 5
- Resource Management Area 4
- Conservation Area 3
- Federal Other or Unknown 3
- State Historic or Cultural Area 3
- National Public Lands 2
- National Monument or Landmark 2
- None 1
- None 1
- State Recreation Area 1
- Recreation Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 20
- Non Profit - Land Trust 217
- City Agency 207
- State Agency 137
- Recreation/Parks District 106
- Flood District 58
- Water District 56
- Non Profit - Conservation 50
- Federal Agency 33
- Irrigation District 29
- County Agency 26
- Open Space District 22
- County Agency - Parks 18
- County Agency - Other 3
- Home Owners Association 1
- Commercial 1
- Sanitation District 1
- Non Profit - Other 1
- Joint Powers Authority 1
- Other 1
- Mitigation Bank 1
LAYER 12 ✖
ACCESS_TYP 1
- No Public Access · 969 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25 | 25 | 24 | {"type": "Polygon", "coordinates": [[[-122.27747, 38.29885], [-122.27706, 38.29891], [-122.27702, 38.29871], [-122.27743, 38.29865], [-122.27747, 38.29885]]]} | No Public Access 3 | 64 | Real Estate Services Division | 24211 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 0.203 | Real Estate Services Division | None 6 | |||
228 | 228 | 227 | {"type": "Polygon", "coordinates": [[[-122.33028, 41.31414], [-122.32908, 41.31415], [-122.32909, 41.31022], [-122.32966, 41.31067], [-122.33018, 41.31094], [-122.33021, 41.31196], [-122.33028, 41.31197], [-122.33028, 41.31414]]]} | No Public Access 3 | 621 | Elsa Rupp Natural Area | 32160 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Siskiyou 28 | 9.475 | Elsa Rupp Natural Area | None 26 | |||
565 | 565 | 564 | {"type": "Polygon", "coordinates": [[[-121.91485, 37.97467], [-121.91485, 37.97489], [-121.91456, 37.9751], [-121.91431, 37.97535], [-121.9141, 37.97553], [-121.91345, 37.97542], [-121.91287, 37.97544], [-121.91255, 37.97534], [-121.91197, 37.97514], [-121.91169, 37.9751], [-121.9116, 37.97515], [-121.91148, 37.97518], [-121.91136, 37.97514], [-121.91103, 37.97515], [-121.9109, 37.97496], [-121.91122, 37.97496], [-121.91189, 37.97489], [-121.91232, 37.9749], [-121.91233, 37.97492], [-121.91345, 37.97494], [-121.91408, 37.97484], [-121.91485, 37.97467]]]} | No Public Access 3 | 47528 | Alaimo | 31233 | 379 | Contra Costa Department of Conservation and Development, County of 209 | County 3 | County Agency - Other 9 | http://www.cccounty.us/dcd | County 3 | 379 | Contra Costa Department of Conservation and Development, County of 205 | County 3 | County Agency - Other 8 | Contra Costa 12 | 3.763 | Alaimo | None 56 | |||
710 | 710 | 709 | {"type": "Polygon", "coordinates": [[[-122.49778, 38.11503], [-122.49513, 38.11705], [-122.49391, 38.11801], [-122.49231, 38.1192], [-122.49241, 38.1189], [-122.49275, 38.11856], [-122.49311, 38.11825], [-122.49339, 38.11787], [-122.49376, 38.11735], [-122.49389, 38.11699], [-122.49396, 38.11668], [-122.49396, 38.11519], [-122.49778, 38.11503]]]} | No Public Access 3 | 4004 | Sonoma Baylands | 25607 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Sonoma 16 | 14.555 | Sonoma Baylands | None 66 | |||
723 | 723 | 722 | {"type": "Polygon", "coordinates": [[[-122.8297, 38.43042], [-122.82526, 38.43042], [-122.82525, 38.42579], [-122.8253, 38.42547], [-122.82624, 38.42547], [-122.82716, 38.42577], [-122.82941, 38.42635], [-122.82931, 38.42976], [-122.82941, 38.43012], [-122.8297, 38.43042]]]} | No Public Access 3 | 4499 | Stone Farm | 25869 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 45.409 | Stone Farm | None 67 | |||
1033 | 1033 | 1032 | {"type": "Polygon", "coordinates": [[[-118.51157, 34.07731], [-118.51143, 34.07746], [-118.5104, 34.07684], [-118.5101, 34.07613], [-118.50988, 34.07539], [-118.50872, 34.07481], [-118.50845, 34.0745], [-118.50826, 34.07401], [-118.50761, 34.07364], [-118.50763, 34.07328], [-118.50737, 34.07296], [-118.50731, 34.07284], [-118.50737, 34.07275], [-118.50746, 34.07269], [-118.50778, 34.07276], [-118.50866, 34.0734], [-118.50892, 34.0734], [-118.50898, 34.07385], [-118.50974, 34.07406], [-118.50989, 34.07443], [-118.50989, 34.07475], [-118.51067, 34.07526], [-118.51068, 34.07637], [-118.51099, 34.07669], [-118.51107, 34.07682], [-118.5113, 34.07702], [-118.51157, 34.07731]]]} | No Public Access 3 | 6378 | Sullivan Canyon Creek & Dam | 25948 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 10.67 | Sullivan Canyon Creek & Dam | None 93 | |||
1115 | 1115 | 1114 | {"type": "Polygon", "coordinates": [[[-117.8843, 33.96567], [-117.88426, 33.96587], [-117.88394, 33.96616], [-117.88344, 33.96606], [-117.88359, 33.96552], [-117.8843, 33.96567]]]} | No Public Access 3 | 6558 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.931 | Roland Area County Water District Land | None 101 | |||
1316 | 1316 | 1315 | {"type": "Polygon", "coordinates": [[[-116.74116, 32.57636], [-116.74114, 32.58363], [-116.73714, 32.58342], [-116.73291, 32.5834], [-116.73278, 32.58732], [-116.72047, 32.58718], [-116.72045, 32.58913], [-116.70751, 32.5894], [-116.69094, 32.5893], [-116.69082, 32.58084], [-116.69077, 32.57124], [-116.73696, 32.56738], [-116.73704, 32.56906], [-116.74116, 32.5691], [-116.74116, 32.5727], [-116.73707, 32.57263], [-116.73709, 32.57623], [-116.74116, 32.57636]]]} | No Public Access 3 | 7399 | Kuchamaa Experimental Forest | 20729 | 202 | California Department of Forestry and Fire Protection 346 | State 5 | State Agency 5 | http://www.fire.ca.gov/ | Other State 5 | 202 | California Department of Forestry and Fire Protection 343 | State 5 | State Agency 5 | San Diego 4 | 2363.684 | Kuchamaa Experimental Forest | 0 | None 113 | ||
1573 | 1573 | 1572 | {"type": "Polygon", "coordinates": [[[-122.6827, 38.37594], [-122.67746, 38.37597], [-122.67742, 38.37485], [-122.67626, 38.37485], [-122.67625, 38.37486], [-122.67626, 38.37627], [-122.67517, 38.37592], [-122.67173, 38.37464], [-122.67171, 38.3738], [-122.67535, 38.37375], [-122.67531, 38.37112], [-122.67644, 38.37111], [-122.67646, 38.37237], [-122.68263, 38.37226], [-122.6827, 38.37594]]]} | No Public Access 3 | 47544 | Oken | 31257 | 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 | 77.773 | Oken | 1998 | None 126 | ||
1708 | 1708 | 1707 | {"type": "Polygon", "coordinates": [[[-117.93744, 33.98131], [-117.93677, 33.98161], [-117.93629, 33.98086], [-117.93696, 33.98056], [-117.93744, 33.98131]]]} | No Public Access 3 | 6551 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 1.632 | Roland Area County Water District Land | None 136 | |||
1759 | 1759 | 1758 | {"type": "Polygon", "coordinates": [[[-117.93234, 33.9866], [-117.93168, 33.98689], [-117.93158, 33.98688], [-117.93166, 33.98615], [-117.93219, 33.9861], [-117.93223, 33.98635], [-117.93234, 33.9866]]]} | No Public Access 3 | 6552 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 1.052 | Roland Area County Water District Land | None 137 | |||
1760 | 1760 | 1759 | {"type": "Polygon", "coordinates": [[[-117.91753, 33.96603], [-117.91639, 33.96877], [-117.91516, 33.96861], [-117.91523, 33.96842], [-117.91541, 33.96808], [-117.91555, 33.96763], [-117.91605, 33.96696], [-117.91648, 33.9667], [-117.91691, 33.96636], [-117.91753, 33.96603]]]} | No Public Access 3 | 6553 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 6.905 | Roland Area County Water District Land | None 138 | |||
1761 | 1761 | 1760 | {"type": "Polygon", "coordinates": [[[-117.92305, 33.97679], [-117.92297, 33.97736], [-117.92178, 33.97689], [-117.92181, 33.97667], [-117.92244, 33.97672], [-117.92249, 33.97669], [-117.92258, 33.97673], [-117.92265, 33.97671], [-117.92276, 33.97676], [-117.92305, 33.97679]]]} | No Public Access 3 | 6554 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 1.271 | Roland Area County Water District Land | None 139 | |||
1762 | 1762 | 1761 | {"type": "Polygon", "coordinates": [[[-117.90135, 33.9591], [-117.90114, 33.95933], [-117.90097, 33.95918], [-117.90029, 33.95921], [-117.90038, 33.95914], [-117.90053, 33.95907], [-117.89969, 33.95857], [-117.89885, 33.95773], [-117.89826, 33.95783], [-117.89766, 33.95753], [-117.89771, 33.95684], [-117.89761, 33.9564], [-117.89643, 33.95562], [-117.89634, 33.95554], [-117.89624, 33.95542], [-117.89618, 33.95531], [-117.89616, 33.9552], [-117.89626, 33.95518], [-117.89661, 33.95555], [-117.89745, 33.95579], [-117.89819, 33.95616], [-117.89868, 33.95697], [-117.89953, 33.95806], [-117.90094, 33.959], [-117.90126, 33.95894], [-117.90135, 33.9591]]]} | No Public Access 3 | 6555 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 7.601 | Roland Area County Water District Land | None 140 | |||
2236 | 2236 | 2235 | {"type": "Polygon", "coordinates": [[[-118.34876, 33.79283], [-118.34853, 33.79307], [-118.3421, 33.78766], [-118.34362, 33.78659], [-118.34783, 33.79015], [-118.34783, 33.79205], [-118.34876, 33.79283]]]} | No Public Access 3 | 5918 | South Coast Park/former Palos Verdes Landfill site | 29032 | 2139 | Sanitation Districts of Los Angeles County 290 | Special District 4 | Sanitation District 18 | http://www.lacsd.org/ | Special District 4 | 2139 | Sanitation Districts of Los Angeles County 490 | Special District 4 | Sanitation District 19 | http://www.lacsd.org/solidwaste/swfacilities/landfills/palos_verdes/ | Los Angeles 6 | 30.5 | South Coast Park/former Palos Verdes Landfill site | None 184 | ||
2329 | 2329 | 2328 | {"type": "Polygon", "coordinates": [[[-119.51345, 34.48686], [-119.51326, 34.49394], [-119.4989, 34.49389], [-119.49892, 34.49041], [-119.49005, 34.49037], [-119.49007, 34.4868], [-119.49489, 34.48683], [-119.51345, 34.48686]]]} | No Public Access 3 | 17019 | Jameson Lake | 20355 | 2082 | Montecito Water District 513 | Special District 4 | Water District 13 | http://www.montecitowater.com/ | Special District 4 | 2082 | Montecito Water District 506 | Special District 4 | Water District 13 | Santa Barbara 7 | 336.515 | Jameson Lake | None 196 | |||
2565 | 2565 | 2564 | {"type": "Polygon", "coordinates": [[[-117.90918, 33.95983], [-117.90918, 33.95986], [-117.90916, 33.95988], [-117.90863, 33.95999], [-117.90848, 33.95973], [-117.90893, 33.95954], [-117.90906, 33.95966], [-117.90914, 33.95975], [-117.90918, 33.95983]]]} | No Public Access 3 | 6556 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.487 | Roland Area County Water District Land | None 210 | |||
2593 | 2593 | 2592 | {"type": "Polygon", "coordinates": [[[-117.89197, 33.96438], [-117.89183, 33.96505], [-117.89141, 33.96512], [-117.8911, 33.96526], [-117.89075, 33.96497], [-117.89062, 33.96475], [-117.89062, 33.96444], [-117.89119, 33.96426], [-117.89197, 33.96438]]]} | No Public Access 3 | 6557 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 2.479 | Roland Area County Water District Land | None 214 | |||
2686 | 2686 | 2685 | {"type": "Polygon", "coordinates": [[[-122.47796, 37.56987], [-122.46847, 37.57003], [-122.46834, 37.56631], [-122.47791, 37.56619], [-122.47796, 37.56987]]]} | No Public Access 3 | 18237 | North Coast Water Dist | 22815 | 2093 | North Coast Water District 544 | Special District 4 | Water District 13 | http://www.nccwd.com | Special District 4 | 2093 | North Coast Water District 537 | Special District 4 | Water District 13 | San Mateo 15 | 85.384 | North Coast Water Dist | None 220 | |||
3155 | 3155 | 3154 | {"type": "Polygon", "coordinates": [[[-121.52015, 38.36105], [-121.52, 38.36138], [-121.51988, 38.36172], [-121.51976, 38.36228], [-121.51967, 38.36299], [-121.51968, 38.36374], [-121.51983, 38.36443], [-121.51986, 38.3652], [-121.51994, 38.36596], [-121.52002, 38.3666], [-121.51995, 38.36694], [-121.51977, 38.3671], [-121.51892, 38.36686], [-121.51857, 38.36669], [-121.51813, 38.36655], [-121.51157, 38.3651], [-121.51168, 38.35783], [-121.51938, 38.36011], [-121.51901, 38.36077], [-121.52015, 38.36105]]]} | No Public Access 3 | 21762 | Hood Test Facilities | 30565 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Sacramento 41 | 136.958 | Hood Test Facilities | None 257 |
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]);