units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
969 rows where ACCESS_TYP = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Fish and Wildlife 79
- East Bay Regional Park District 47
- Los Angeles, City of 32
- The Nature Conservancy 32
- Peninsula Open Space Trust 23
- Natomas Basin Conservancy 22
- Rivers and Lands Conservancy 22
- The Environmental Trust 21
- Las Virgenes Municipal Water District 21
- Torrance, City of 19
- Midpeninsula Regional Open Space District 19
- San Diego, City of 18
- Santa Clara Valley Open Space Authority 18
- United States Fish and Wildlife Service 16
- Mountains Restoration Trust 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
- Escondido, City of 10
- …
DES_TP >30
- Private Conservation 210
- Local Recreation Area 106
- Local Other or Unknown 94
- Local Conservation Area 77
- Local Park 75
- State Resource Management Area 64
- Private Other or Unknown 25
- State Conservation Area 22
- Private Recreation or Education 21
- State Other or Unknown 17
- 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
- …
AGNCY_TYP 21 ✖
- Non Profit - Land Trust 215
- City Agency 201
- State Agency 142
- Recreation/Parks District 94
- Flood District 58
- Water District 54
- Non Profit - Conservation 46
- Federal Agency 36
- County Agency 29
- Irrigation District 29
- Open Space District 17
- County Agency - Parks 17
- County Agency - Other 3
- Home Owners Association 1
- Sanitation District 1
- Commercial 1
- Utility 1
- Non Profit - Other 1
- Joint Powers Authority 1
- Mitigation Bank 1
- Transportation Agency 1
MNG_AG_TYP 20
- Non Profit - Land Trust 216
- City Agency 201
- State Agency 135
- Recreation/Parks District 106
- Flood District 58
- Water District 49
- Non Profit - Conservation 46
- 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
ACCESS_TYP 1
- No Public Access · 949 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6778 | 6778 | 6777 | {"type": "Polygon", "coordinates": [[[-122.25654, 38.2078], [-122.25633, 38.20788], [-122.2563, 38.20749], [-122.2564, 38.20753], [-122.25652, 38.20754], [-122.25654, 38.2078]]]} | No Public Access 3 | 5258 | Dept Of Transportation/Paul Kenny | 18103 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | Napa 11 | 0.163 | Dept Of Transportation/Paul Kenny | None 551 | |||
12482 | 12482 | 12481 | {"type": "Polygon", "coordinates": [[[-117.99345, 34.51866], [-117.9926, 34.51867], [-117.9926, 34.51859], [-117.99345, 34.51858], [-117.99345, 34.51866]]]} | No Public Access 3 | 12451 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.173 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
1138 | 1138 | 1137 | {"type": "Polygon", "coordinates": [[[-118.17117, 33.79377], [-118.1707, 33.79377], [-118.1707, 33.79348], [-118.17072, 33.79348], [-118.17117, 33.79377]]]} | No Public Access 3 | 6684 | Chittick Field | 29944 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.181 | Chittick Field | 2014 | Local Recreation Area 3 | 4 | |
12774 | 12774 | 12773 | {"type": "Polygon", "coordinates": [[[-118.36219, 33.85184], [-118.36169, 33.85181], [-118.36169, 33.85167], [-118.36213, 33.85167], [-118.36219, 33.85184]]]} | No Public Access 3 | 35837 | Entradero Swale 4 | 29148 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.181 | Entradero Swale 4 | None 1121 | |||
8153 | 8153 | 8152 | {"type": "Polygon", "coordinates": [[[-118.08451, 34.18147], [-118.08446, 34.18154], [-118.08433, 34.18161], [-118.08405, 34.18134], [-118.08424, 34.18129], [-118.08446, 34.18139], [-118.08451, 34.18147]]]} | No Public Access 3 | 12344 | Kinneloa Irrigation District Open Space | 20674 | 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.194 | Kinneloa Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
4536 | 4536 | 4535 | {"type": "Polygon", "coordinates": [[[-117.1276, 32.76738], [-117.12717, 32.76784], [-117.12705, 32.76778], [-117.12742, 32.76738], [-117.1276, 32.76738]]]} | No Public Access 3 | 19905 | Unnamed site - San Diego, City of | 31719 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.196 | 0 | Local Other or Unknown 14 | 4 | ||
9003 | 9003 | 9002 | {"type": "Polygon", "coordinates": [[[-117.98817, 34.54292], [-117.98816, 34.54299], [-117.98697, 34.54299], [-117.98701, 34.54293], [-117.98817, 34.54292]]]} | No Public Access 3 | 12439 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.2 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
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 | |||
12271 | 12271 | 12270 | {"type": "Polygon", "coordinates": [[[-118.2914, 33.95801], [-118.2914, 33.95822], [-118.291, 33.95822], [-118.29101, 33.95801], [-118.2914, 33.95801]]]} | No Public Access 3 | 46878 | Community Build Youth Center Expansion | 30356 | 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.207 | Community Build Youth Ctr. Expansion | None 1070 | |||
7312 | 7312 | 7311 | {"type": "Polygon", "coordinates": [[[-122.27901, 38.29895], [-122.27868, 38.299], [-122.27861, 38.29876], [-122.27894, 38.2987], [-122.27901, 38.29895]]]} | No Public Access 3 | 6623 | 575 Third St | 15206 | 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.21 | 575 Third St | None 604 | |||
16957 | 16957 | 16956 | {"type": "Polygon", "coordinates": [[[-118.77416, 34.04757], [-118.77403, 34.04762], [-118.77363, 34.04741], [-118.7737, 34.04729], [-118.77414, 34.04746], [-118.77416, 34.04757]]]} | No Public Access 3 | 12504 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.213 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
7447 | 7447 | 7446 | {"type": "MultiPolygon", "coordinates": [[[[-118.22877, 34.08683], [-118.22866, 34.08675], [-118.22875, 34.08668], [-118.22875, 34.08668], [-118.22877, 34.08683]]], [[[-118.22915, 34.08683], [-118.22891, 34.08704], [-118.22889, 34.08693], [-118.22882, 34.08688], [-118.22879, 34.08664], [-118.22885, 34.08659], [-118.22915, 34.08683]]]]} | No Public Access 3 | 6921 | Steelhead Park | 25823 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.219 | Steelhead Park | 0 | Local Park 2 | 4 | |
8209 | 8209 | 8208 | {"type": "Polygon", "coordinates": [[[-118.34266, 34.12073], [-118.34239, 34.12092], [-118.34236, 34.12088], [-118.34217, 34.12072], [-118.3424, 34.12055], [-118.34256, 34.12064], [-118.34266, 34.12073]]]} | No Public Access 3 | 12464 | Los Angeles Department of Water and Power | 21482 | 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.23 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
4749 | 4749 | 4748 | {"type": "Polygon", "coordinates": [[[-118.25828, 33.88611], [-118.25795, 33.88612], [-118.25789, 33.88584], [-118.25805, 33.88581], [-118.25821, 33.88581], [-118.25828, 33.88611]]]} | No Public Access 3 | 46441 | Unnamed site - Carson, City of | 29713 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | Los Angeles 6 | 0.248 | 0 | Local Other or Unknown 14 | 4 | ||
8207 | 8207 | 8206 | {"type": "Polygon", "coordinates": [[[-118.34724, 34.11998], [-118.34703, 34.11998], [-118.34699, 34.11995], [-118.34697, 34.11996], [-118.34677, 34.11971], [-118.34724, 34.1197], [-118.34724, 34.11998]]]} | No Public Access 3 | 12461 | Los Angeles Department of Water and Power | 21482 | 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.25 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
3427 | 3427 | 3426 | {"type": "Polygon", "coordinates": [[[-122.01238, 36.97053], [-122.01187, 36.97081], [-122.01185, 36.97079], [-122.01191, 36.97056], [-122.01223, 36.97036], [-122.01238, 36.97053]]]} | No Public Access 3 | 25174 | South Branciforte | 32313 | 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 | Santa Cruz 5 | 0.251 | South Branciforte | 0 | State Resource Management Area 55 | 3 | |
2461 | 2461 | 2460 | {"type": "Polygon", "coordinates": [[[-118.34315, 34.12036], [-118.34289, 34.12054], [-118.34274, 34.1204], [-118.34265, 34.12036], [-118.34296, 34.12013], [-118.34315, 34.12036]]]} | No Public Access 3 | 12465 | Los Angeles Department of Water and Power | 21482 | 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.255 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
5505 | 5505 | 5504 | {"type": "MultiPolygon", "coordinates": [[[[-118.66773, 34.17325], [-118.66736, 34.17323], [-118.66731, 34.17311], [-118.66769, 34.17301], [-118.66773, 34.17316], [-118.66773, 34.17325]]], [[[-118.70599, 34.16395], [-118.70581, 34.16401], [-118.70578, 34.16393], [-118.70589, 34.16376], [-118.70595, 34.16381], [-118.70594, 34.16384], [-118.70599, 34.16395]]]]} | No Public Access 3 | 12408 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.26 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
15805 | 15805 | 15804 | {"type": "Polygon", "coordinates": [[[-118.77383, 34.04565], [-118.77371, 34.04579], [-118.77369, 34.04597], [-118.77341, 34.04599], [-118.77339, 34.04567], [-118.77383, 34.04565]]]} | No Public Access 3 | 12523 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.266 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
4535 | 4535 | 4534 | {"type": "Polygon", "coordinates": [[[-117.23982, 32.87111], [-117.23981, 32.87152], [-117.23927, 32.87152], [-117.23951, 32.87136], [-117.23982, 32.87111]]]} | No Public Access 3 | 19896 | Unnamed site - San Diego, City of | 31719 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.273 | 0 | Local Other or Unknown 14 | 4 |
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]);