units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,190 rows where DES_TP = 14 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, MNG_AG_LEV, YR_EST
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 152
- Ventura, City of 106
- Butte, County of 52
- Yuba County Water Agency 48
- Roseville, City of 46
- Santa Barbara, County of 39
- Lake, County of 36
- Poway, City of 35
- Irvine, City of 29
- Los Angeles, City of 26
- California City, City of 25
- Encinitas, City of 21
- Orange, County of 21
- Napa, City of 21
- Monterey, County of 18
- Rocklin, City of 17
- Seaside, City of 16
- San Diego, City of 15
- Lompoc, City of 14
- Los Angeles County Flood Control District 13
- Santa Cruz, City of 12
- Santa Barbara Flood Control and Water Conserv. District 12
- Oroville, City of 12
- Los Angeles, County of 11
- Santa Barbara, City of 11
- Mammoth Lakes, Town of 11
- Auburn, City of 11
- Guadalupe, City of 10
- Santa Maria, City of 9
- Escondido, City of 9
- …
MNG_AG_TYP 15
- City Agency 663
- County Agency 214
- Open Space District 155
- Water District 78
- Flood District 32
- Recreation/Parks District 28
- County Agency - Other 6
- Irrigation District 4
- Sanitation District 3
- Community Services District 2
- County Agency - Parks 1
- Special District - Other 1
- Metropolitan Planning Organization 1
- Conservation District 1
- Transportation Agency 1
PARK_URL 8 ✖
- http://wsoweb.ladwp.com/Aqueduct/recuses/recreationindex.htm 2
- http://www.cityofvista.com/services/parks-and-facilities 2
- http://dpw.lacounty.gov/wrd/Projects/BTWMA/index.cfm 1
- http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#9 1
- http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=2445 1
- http://www.cvag.org 1
- http://www.lakecountyca.gov/Government/Directory/Parks/Parks/Search/Keeling_County_Park.htm 1
- http://www.riodellcity.com/planning-pdf/Rio%20Dell%20Zoning%20Map.pdf 1
ACCESS_TYP 4
- Open Access 859
- Unknown Access 204
- No Public Access 96
- Restricted Access 31
DES_TP 1
- Local Other or Unknown · 1,190 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4727 | 4727 | 4726 | {"type": "Polygon", "coordinates": [[[-118.50367, 34.09732], [-118.50364, 34.09732], [-118.50363, 34.09721], [-118.50366, 34.09721], [-118.50367, 34.09732]]]} | Unknown Access 4 | 46347 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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.009 | 0 | Local Other or Unknown 14 | 4 | ||
5711 | 5711 | 5710 | {"type": "Polygon", "coordinates": [[[-118.46109, 33.99128], [-118.46109, 33.99132], [-118.46107, 33.99134], [-118.46103, 33.99134], [-118.461, 33.99132], [-118.461, 33.99129], [-118.46103, 33.99127], [-118.46106, 33.99127], [-118.46109, 33.99128]]]} | Open Access 1 | 45791 | Crescent Place Triangle | 28810 | 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.015 | Crescent Place Triangle | 0 | Local Other or Unknown 14 | 4 | |
13220 | 13220 | 13219 | {"type": "Polygon", "coordinates": [[[-119.19521, 34.28644], [-119.19519, 34.28644], [-119.19511, 34.28596], [-119.19513, 34.28596], [-119.19521, 34.28644]]]} | Open Access 1 | 35264 | Ventura holding 58 | 26938 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.019 | Ventura holding 58 | 0 | Local Other or Unknown 14 | 4 | |
13576 | 13576 | 13575 | {"type": "Polygon", "coordinates": [[[-118.88253, 34.28657], [-118.88237, 34.28657], [-118.88234, 34.28652], [-118.88242, 34.28649], [-118.88245, 34.28654], [-118.88247, 34.28653], [-118.88253, 34.28657]]]} | Open Access 1 | 35905 | Moorpark holding 2 | 22464 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 0.02 | Moorpark holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13317 | 13317 | 13316 | {"type": "Polygon", "coordinates": [[[-119.19475, 34.28398], [-119.19474, 34.28399], [-119.19465, 34.28374], [-119.19455, 34.28353], [-119.19455, 34.2835], [-119.19456, 34.28346], [-119.19456, 34.2835], [-119.19469, 34.28379], [-119.19475, 34.28398]]]} | Open Access 1 | 35384 | Ventura holding 22 | 26899 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.021 | Ventura holding 22 | 0 | Local Other or Unknown 14 | 4 | |
13228 | 13228 | 13227 | {"type": "Polygon", "coordinates": [[[-119.1911, 34.28234], [-119.19107, 34.28236], [-119.19083, 34.28244], [-119.19075, 34.28238], [-119.19073, 34.28229], [-119.19076, 34.28229], [-119.19078, 34.28238], [-119.19083, 34.28242], [-119.1911, 34.28234]]]} | Open Access 1 | 35269 | Ventura holding 60 | 26941 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.022 | Ventura holding 60 | 0 | Local Other or Unknown 14 | 4 | |
13346 | 13346 | 13345 | {"type": "Polygon", "coordinates": [[[-121.82508, 36.6128], [-121.82474, 36.61287], [-121.82474, 36.61287], [-121.82474, 36.61284], [-121.82507, 36.61277], [-121.82508, 36.6128]]]} | Open Access 1 | 35425 | Seaside holding 7 | 25263 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.023 | Seaside holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13754 | 13754 | 13753 | {"type": "Polygon", "coordinates": [[[-122.87408, 39.00329], [-122.87407, 39.0034], [-122.87395, 39.0034], [-122.874, 39.00329], [-122.87408, 39.00329]]]} | Open Access 1 | 36266 | Lake holding 44 | 20933 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 0.025 | Lake holding 44 | 0 | Local Other or Unknown 14 | 4 | |
13321 | 13321 | 13320 | {"type": "Polygon", "coordinates": [[[-119.17309, 34.26527], [-119.17306, 34.26529], [-119.17283, 34.26503], [-119.17286, 34.26501], [-119.17309, 34.26527]]]} | Open Access 1 | 35388 | Ventura holding 20 | 26897 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.027 | Ventura holding 20 | 0 | Local Other or Unknown 14 | 4 | |
15001 | 15001 | 15000 | {"type": "Polygon", "coordinates": [[[-118.45909, 33.99185], [-118.45903, 33.99195], [-118.45894, 33.99191], [-118.45901, 33.99181], [-118.45909, 33.99185]]]} | Open Access 1 | 45786 | Amoroso Triangle | 28805 | 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.027 | Amoroso Triangle | 0 | Local Other or Unknown 14 | 4 | |
15056 | 15056 | 15055 | {"type": "Polygon", "coordinates": [[[-118.46102, 33.99278], [-118.46095, 33.99287], [-118.46087, 33.99283], [-118.46093, 33.99274], [-118.46102, 33.99278]]]} | Open Access 1 | 45814 | Nowita Triangle | 28834 | 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.027 | Nowita Triangle | 0 | Local Other or Unknown 14 | 4 | |
13625 | 13625 | 13624 | {"type": "Polygon", "coordinates": [[[-121.53081, 39.5272], [-121.53065, 39.5272], [-121.53066, 39.52703], [-121.53072, 39.5271], [-121.53081, 39.5272]]]} | Open Access 1 | 35971 | Butte holding 35 | 16579 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.031 | Butte holding 35 | 0 | Local Other or Unknown 14 | 4 | |
4366 | 4366 | 4365 | {"type": "Polygon", "coordinates": [[[-118.46024, 33.99143], [-118.46013, 33.99159], [-118.46, 33.99153], [-118.46009, 33.99151], [-118.46013, 33.99147], [-118.46024, 33.99143]]]} | Open Access 1 | 45810 | Marco Triangle | 28830 | 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.034 | Marco Triangle | 0 | Local Other or Unknown 14 | 4 | |
12427 | 12427 | 12426 | {"type": "Polygon", "coordinates": [[[-119.1914, 34.28159], [-119.19124, 34.2816], [-119.1908, 34.28162], [-119.1912, 34.28156], [-119.1914, 34.28159]]]} | Open Access 1 | 35321 | Ventura holding 107 | 26860 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.034 | Ventura holding 107 | 0 | Local Other or Unknown 14 | 4 | |
13295 | 13295 | 13294 | {"type": "Polygon", "coordinates": [[[-119.19432, 34.28316], [-119.19407, 34.28287], [-119.1938, 34.28262], [-119.19379, 34.28258], [-119.1938, 34.28256], [-119.19381, 34.28257], [-119.1938, 34.28258], [-119.19381, 34.28261], [-119.19402, 34.2828], [-119.19421, 34.283], [-119.19431, 34.28313], [-119.19432, 34.28316]]]} | Open Access 1 | 35349 | Ventura holding 5 | 26929 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.034 | Ventura holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13336 | 13336 | 13335 | {"type": "Polygon", "coordinates": [[[-120.44198, 34.91627], [-120.44198, 34.91649], [-120.44191, 34.91649], [-120.44191, 34.91632], [-120.44193, 34.91628], [-120.44198, 34.91627]]]} | Open Access 1 | 35413 | Santa Maria holding 3 | 25107 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 0.034 | Santa Maria holding 3 | 0 | Local Other or Unknown 14 | 4 | |
15489 | 15489 | 15488 | {"type": "Polygon", "coordinates": [[[-118.32033, 34.23499], [-118.32019, 34.2351], [-118.32013, 34.23505], [-118.32027, 34.23494], [-118.32033, 34.23499]]]} | Unknown Access 4 | 46153 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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.034 | 0 | Local Other or Unknown 14 | 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 | ||
7777 | 7777 | 7776 | {"type": "Polygon", "coordinates": [[[-119.19536, 34.28728], [-119.19535, 34.28728], [-119.1952, 34.28644], [-119.19521, 34.28644], [-119.19536, 34.28728]]]} | Open Access 1 | 35437 | Ventura holding 70 | 26952 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.035 | Ventura holding 70 | 0 | Local Other or Unknown 14 | 4 | |
13934 | 13934 | 13933 | {"type": "Polygon", "coordinates": [[[-119.15013, 34.27654], [-119.15013, 34.27655], [-119.15007, 34.27656], [-119.15004, 34.27659], [-119.14986, 34.27736], [-119.14985, 34.27734], [-119.15003, 34.27659], [-119.15007, 34.27654], [-119.15013, 34.27654]]]} | Open Access 1 | 36540 | Ventura holding 125 | 26880 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.036 | Ventura holding 125 | 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]);