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)
Suggested facets: AGNCY_LEV, LAYER, MNG_AG_LEV, GAP_STS
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
- …
AGNCY_TYP 21 ✖
- Non Profit - Land Trust 216
- City Agency 207
- State Agency 144
- Recreation/Parks District 94
- Water District 61
- Flood District 58
- Non Profit - Conservation 50
- 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 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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9013 | 9013 | 9012 | {"type": "Polygon", "coordinates": [[[-118.65507, 34.12838], [-118.65499, 34.12848], [-118.65493, 34.12846], [-118.65501, 34.12835], [-118.65507, 34.12838]]]} | No Public Access 3 | 12414 | 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.022 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
9463 | 9463 | 9462 | {"type": "Polygon", "coordinates": [[[-118.7507, 34.16758], [-118.75065, 34.16768], [-118.75057, 34.16764], [-118.75062, 34.16755], [-118.7507, 34.16758]]]} | No Public Access 3 | 12424 | 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.027 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
5497 | 5497 | 5496 | {"type": "Polygon", "coordinates": [[[-118.39276, 34.11874], [-118.39267, 34.11881], [-118.3926, 34.11875], [-118.39271, 34.11867], [-118.39276, 34.11874]]]} | No Public Access 3 | 12821 | Los Angeles City Water Resource Parkland | 21477 | 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.028 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
1629 | 1629 | 1628 | {"type": "Polygon", "coordinates": [[[-118.63073, 34.13978], [-118.63062, 34.1398], [-118.63058, 34.13967], [-118.63066, 34.13966], [-118.63073, 34.13978]]]} | No Public Access 3 | 12421 | 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.034 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
4537 | 4537 | 4536 | {"type": "Polygon", "coordinates": [[[-117.10461, 32.76969], [-117.10445, 32.76969], [-117.10461, 32.76951], [-117.10461, 32.76969], [-117.10461, 32.76969]]]} | No Public Access 3 | 19907 | 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.035 | 0 | Local Other or Unknown 14 | 4 | ||
2539 | 2539 | 2538 | {"type": "Polygon", "coordinates": [[[-118.6218, 34.10061], [-118.62167, 34.10067], [-118.6216, 34.10059], [-118.62174, 34.10053], [-118.6218, 34.10061]]]} | No Public Access 3 | 12510 | 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.038 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
2800 | 2800 | 2799 | {"type": "Polygon", "coordinates": [[[-118.62165, 34.10163], [-118.62148, 34.10166], [-118.62143, 34.10159], [-118.62157, 34.10153], [-118.62165, 34.10163]]]} | No Public Access 3 | 12515 | 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.042 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
9404 | 9404 | 9403 | {"type": "Polygon", "coordinates": [[[-118.67423, 34.13343], [-118.67408, 34.13345], [-118.67407, 34.13332], [-118.67422, 34.13331], [-118.67423, 34.13343]]]} | No Public Access 3 | 12423 | 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.05 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
4092 | 4092 | 4091 | {"type": "Polygon", "coordinates": [[[-118.518, 34.05167], [-118.51753, 34.05174], [-118.51751, 34.0517], [-118.51798, 34.05163], [-118.518, 34.05167]]]} | No Public Access 3 | 47493 | Chautauqua Blvd Access to Will Rogers State Historic Preserve | 31212 | 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.053 | Chautauqua Blvd Access to Will Rogers SHPr | None 355 | |||
16958 | 16958 | 16957 | {"type": "Polygon", "coordinates": [[[-118.62162, 34.10069], [-118.62138, 34.1008], [-118.62131, 34.10072], [-118.62156, 34.10061], [-118.62162, 34.10069]]]} | No Public Access 3 | 12507 | 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.069 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
4625 | 4625 | 4624 | {"type": "Polygon", "coordinates": [[[-122.30619, 38.31262], [-122.30611, 38.31263], [-122.30598, 38.31222], [-122.30605, 38.3122], [-122.30619, 38.31262]]]} | No Public Access 3 | 36253 | Unnamed site - California Department of General Services | 28625 | 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.081 | 0 | State Other or Unknown 104 | 4 | ||
4231 | 4231 | 4230 | {"type": "Polygon", "coordinates": [[[-122.31412, 37.26649], [-122.31377, 37.26649], [-122.31369, 37.26638], [-122.31401, 37.26638], [-122.31412, 37.26649]]]} | No Public Access 3 | 29758 | Kraynick | 20724 | 3054 | Peninsula Open Space Trust 338 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.092 | Kraynick | 0 | Private Conservation 16 | 2 | |
2066 | 2066 | 2065 | {"type": "Polygon", "coordinates": [[[-118.67437, 34.13917], [-118.67424, 34.13936], [-118.67408, 34.13928], [-118.67422, 34.13909], [-118.67437, 34.13917]]]} | No Public Access 3 | 12422 | 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.103 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
2462 | 2462 | 2461 | {"type": "Polygon", "coordinates": [[[-118.35722, 34.10552], [-118.35702, 34.10564], [-118.35703, 34.10532], [-118.35722, 34.10533], [-118.35722, 34.10552]]]} | No Public Access 3 | 12466 | 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.129 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
4622 | 4622 | 4621 | {"type": "Polygon", "coordinates": [[[-122.57831, 38.57459], [-122.57825, 38.5747], [-122.57785, 38.57457], [-122.57792, 38.57445], [-122.57831, 38.57459]]]} | No Public Access 3 | 36169 | Unnamed site - California Department of General Services | 28625 | 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.134 | 0 | State Other or Unknown 104 | 4 | ||
9467 | 9467 | 9466 | {"type": "Polygon", "coordinates": [[[-118.79539, 34.10451], [-118.79505, 34.10457], [-118.79501, 34.10437], [-118.79516, 34.10434], [-118.79538, 34.10447], [-118.79539, 34.10451]]]} | No Public Access 3 | 12425 | 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.136 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
8361 | 8361 | 8360 | {"type": "MultiPolygon", "coordinates": [[[[-118.66634, 34.17078], [-118.66625, 34.17093], [-118.66609, 34.17094], [-118.66606, 34.17068], [-118.66634, 34.17078]]], [[[-118.741, 34.15444], [-118.74093, 34.15454], [-118.74084, 34.15445], [-118.74084, 34.15444], [-118.741, 34.15444]]]]} | No Public Access 3 | 12409 | 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.141 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
16970 | 16970 | 16969 | {"type": "Polygon", "coordinates": [[[-118.62222, 34.10346], [-118.62187, 34.10346], [-118.62175, 34.10335], [-118.62193, 34.10321], [-118.62222, 34.10346]]]} | No Public Access 3 | 12502 | 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.156 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
13528 | 13528 | 13527 | {"type": "Polygon", "coordinates": [[[-118.36681, 33.81599], [-118.36674, 33.81603], [-118.36641, 33.81553], [-118.36652, 33.81548], [-118.36669, 33.81573], [-118.36665, 33.81575], [-118.36681, 33.81599]]]} | No Public Access 3 | 35826 | Greenbelt SE Bindewald SE Calle Mayor | 29168 | 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.158 | Greenbelt SE Bindewald SE Calle Mayor | None 1164 | |||
1340 | 1340 | 1339 | {"type": "Polygon", "coordinates": [[[-118.38142, 34.10854], [-118.38114, 34.10871], [-118.38103, 34.10855], [-118.38131, 34.10838], [-118.38142, 34.10854]]]} | No Public Access 3 | 12809 | Los Angeles City Water Resource Parkland | 21477 | 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.163 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 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]);