units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,490 rows where MNG_AG_LEV = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 174
- San Diego, County of 123
- Santa Barbara, County of 116
- Orange, County of 95
- Los Angeles - Department of Parks and Recreation, County of 64
- Lake, County of 55
- Santa Clara County Parks and Recreation Dept., County of 55
- Sacramento, County of 55
- Santa Cruz, County of 50
- Sonoma County Regional Parks Dept., County of 50
- Butte, County of 48
- Kern, County of 47
- Monterey, County of 44
- El Dorado, County of 42
- Riverside, County of 39
- Marin County Parks Department, County of 34
- San Luis Obispo, County of 31
- Placer, County of 28
- San Mateo County Parks and Recreation Dept., County of 25
- Ventura, County of 24
- Stanislaus, County of 24
- San Joaquin, County of 21
- San Bernardino, County of 20
- Fresno, County of 17
- Yolo, County of 17
- Merced, County of 16
- Tulare, County of 15
- San Francisco - Public Utilities Commission, City and County of 13
- Humboldt, County of 12
- Contra Costa County Public Works Dept., County of 10
- …
DES_TP >30
- Local Park 806
- Local Other or Unknown 211
- Local Recreation Area 157
- Local Conservation Area 116
- Local Historic or Cultural Area 21
- Local Resource Management Area 8
- National Recreation Area 3
- National Forest 2
- National Monument or Landmark 2
- 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
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 1,306
- Restricted Access 81
- No Public Access 47
- Unknown Access 36
MNG_AG_TYP 3
- County Agency 1,202
- County Agency - Parks 235
- County Agency - Other 33
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13597 | 13597 | 13596 | {"type": "Polygon", "coordinates": [[[-121.58711, 39.81342], [-121.58621, 39.81385], [-121.58619, 39.81385], [-121.58633, 39.81373], [-121.58677, 39.81349], [-121.58711, 39.81342]]]} | Open Access 1 | 35933 | Butte holding 21 | 16565 | 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.131 | Butte holding 21 | 0 | Local Other or Unknown 14 | 4 | |
15092 | 15092 | 15091 | {"type": "Polygon", "coordinates": [[[-118.23999, 33.92472], [-118.23998, 33.92479], [-118.23922, 33.9248], [-118.23925, 33.92475], [-118.2393, 33.92473], [-118.23999, 33.92472]]]} | Open Access 1 | 45876 | Martin Luther King Jr. Fitness Garden | 28949 | 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 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Martin_Luther_King_Jr_Fitness_Park | Los Angeles 6 | 0.133 | Martin Luther King Jr. Fitness Garden | 0 | Local Park 2 | 4 |
9554 | 9554 | 9553 | {"type": "Polygon", "coordinates": [[[-122.51744, 38.01193], [-122.51734, 38.01202], [-122.51708, 38.01218], [-122.51696, 38.01205], [-122.51738, 38.01189], [-122.51744, 38.01193]]]} | Open Access 1 | 16105 | Candy's Park | 16799 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 0.134 | Candy's Park | 0 | Local Park 2 | 4 | |
12451 | 12451 | 12450 | {"type": "Polygon", "coordinates": [[[-121.85893, 37.37941], [-121.85873, 37.3795], [-121.85851, 37.37957], [-121.8585, 37.37936], [-121.85856, 37.37933], [-121.85893, 37.37941]]]} | Open Access 1 | 28092 | Penitencia Creek Park | 23582 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 0.135 | Penitencia Creek Park | 1872 | Local Park 2 | 4 | |
10113 | 10113 | 10112 | {"type": "Polygon", "coordinates": [[[-121.85358, 36.92094], [-121.85322, 36.92159], [-121.85317, 36.92157], [-121.85338, 36.92118], [-121.85334, 36.92115], [-121.85347, 36.92092], [-121.85358, 36.92094]]]} | Open Access 1 | 17544 | Manresa State Beach Access | 21760 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.parks.ca.gov/?page_id=545 | Santa Cruz 5 | 0.136 | Manresa SB Access | 0 | Local Recreation Area 3 | 4 |
13786 | 13786 | 13785 | {"type": "Polygon", "coordinates": [[[-121.62648, 39.76336], [-121.62653, 39.76339], [-121.62657, 39.76346], [-121.6266, 39.76354], [-121.62661, 39.76365], [-121.6266, 39.76373], [-121.62657, 39.76383], [-121.62646, 39.76397], [-121.62648, 39.76336]]]} | Open Access 1 | 36344 | Butte holding 15 | 16558 | 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.139 | Butte holding 15 | 0 | Local Other or Unknown 14 | 4 | |
11446 | 11446 | 11445 | {"type": "Polygon", "coordinates": [[[-118.49983, 34.28887], [-118.49978, 34.28895], [-118.49972, 34.28892], [-118.49959, 34.28878], [-118.49971, 34.28866], [-118.49975, 34.28864], [-118.49983, 34.28865], [-118.49987, 34.28867], [-118.49989, 34.28871], [-118.49989, 34.28876], [-118.49983, 34.28885], [-118.49983, 34.28887]]]} | Open Access 1 | 48139 | Knollwood Pool | 32669 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/knollwood-pool/ | Los Angeles 6 | 0.141 | Knollwood Pool | 0 | Local Recreation Area 3 | 4 |
254 | 254 | 253 | {"type": "Polygon", "coordinates": [[[-117.30173, 33.05629], [-117.30148, 33.05638], [-117.3014, 33.05627], [-117.30138, 33.05619], [-117.30167, 33.05611], [-117.30173, 33.05629]]]} | Open Access 1 | 704 | Seaside Gardens County Park | 25250 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 0.15 | Seaside Gardens County Park | 0 | Local Park 2 | 4 | |
13616 | 13616 | 13615 | {"type": "Polygon", "coordinates": [[[-121.79721, 39.63893], [-121.797, 39.63897], [-121.79677, 39.63834], [-121.79719, 39.6389], [-121.79721, 39.63893]]]} | Open Access 1 | 35962 | Butte holding 40 | 16585 | 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.167 | Butte holding 40 | 0 | Local Other or Unknown 14 | 4 | |
4342 | 4342 | 4341 | {"type": "Polygon", "coordinates": [[[-120.74524, 40.43205], [-120.7452, 40.43213], [-120.74515, 40.43217], [-120.74508, 40.43219], [-120.74501, 40.43218], [-120.74495, 40.43216], [-120.7449, 40.43211], [-120.74489, 40.43206], [-120.7449, 40.432], [-120.74494, 40.43195], [-120.745, 40.43192], [-120.74507, 40.43191], [-120.74514, 40.43193], [-120.7452, 40.43197], [-120.74524, 40.43205]]]} | Open Access 1 | 45592 | Lake Forest Park | 28418 | 354 | Lassen, County of 750 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | Lassen 54 | 0.17 | Lake Forest Park | 0 | Local Park 2 | 4 | |
13628 | 13628 | 13627 | {"type": "Polygon", "coordinates": [[[-121.60388, 39.85695], [-121.60384, 39.85697], [-121.60383, 39.857], [-121.60382, 39.85735], [-121.60364, 39.85735], [-121.60365, 39.857], [-121.60362, 39.85695], [-121.60388, 39.85695]]]} | Open Access 1 | 35974 | Butte holding 22 | 16566 | 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.177 | Butte holding 22 | 0 | Local Other or Unknown 14 | 4 | |
4302 | 4302 | 4301 | {"type": "Polygon", "coordinates": [[[-118.1262, 34.18898], [-118.12621, 34.18904], [-118.12603, 34.18933], [-118.12602, 34.18935], [-118.12595, 34.18934], [-118.12593, 34.18924], [-118.12595, 34.18897], [-118.12609, 34.18896], [-118.1262, 34.18898]]]} | Open Access 1 | 48153 | Ganesha Park | 32689 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.181 | Ganesha Park | 0 | Local Park 2 | 4 | |
4648 | 4648 | 4647 | {"type": "Polygon", "coordinates": [[[-119.88526, 34.44186], [-119.88488, 34.44185], [-119.88421, 34.44177], [-119.88526, 34.44175], [-119.88526, 34.44186]]]} | Open Access 1 | 36547 | Unnamed site - Santa Barbara, County of | 28662 | 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 | 0.183 | 0 | Local Other or Unknown 14 | 4 | ||
13759 | 13759 | 13758 | {"type": "Polygon", "coordinates": [[[-121.60142, 39.85063], [-121.60119, 39.85063], [-121.60122, 39.85058], [-121.60124, 39.85016], [-121.60141, 39.85016], [-121.6014, 39.85058], [-121.60142, 39.85063]]]} | Open Access 1 | 36277 | Butte holding 43 | 16588 | 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.199 | Butte holding 43 | 0 | Local Other or Unknown 14 | 4 | |
13755 | 13755 | 13754 | {"type": "Polygon", "coordinates": [[[-122.84342, 38.97848], [-122.84318, 38.97845], [-122.843, 38.97792], [-122.84307, 38.97802], [-122.84329, 38.97819], [-122.84336, 38.97826], [-122.84341, 38.97837], [-122.84342, 38.97848]]]} | Open Access 1 | 36267 | Lake holding 45 | 20934 | 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.214 | Lake holding 45 | 0 | Local Other or Unknown 14 | 4 | |
13596 | 13596 | 13595 | {"type": "Polygon", "coordinates": [[[-121.80054, 39.64365], [-121.8001, 39.64376], [-121.80003, 39.64358], [-121.80048, 39.64347], [-121.80054, 39.64365]]]} | Open Access 1 | 35932 | Butte holding 11 | 16554 | 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.215 | Butte holding 11 | 0 | Local Other or Unknown 14 | 4 | |
15085 | 15085 | 15084 | {"type": "MultiPolygon", "coordinates": [[[[-118.15916, 34.01883], [-118.15918, 34.01884], [-118.15919, 34.01886], [-118.15904, 34.01936], [-118.15896, 34.01951], [-118.15899, 34.0193], [-118.15913, 34.01885], [-118.15916, 34.01883]]], [[[-118.15947, 34.01784], [-118.15947, 34.01795], [-118.15928, 34.01858], [-118.15923, 34.0186], [-118.15921, 34.01856], [-118.1594, 34.01795], [-118.15947, 34.01784]]]]} | Open Access 1 | 45867 | Woods Avenue Park | 28914 | 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 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Woods_Avenue_Park | Los Angeles 6 | 0.218 | Woods Avenue Park | 0 | Local Park 2 | 4 |
15470 | 15470 | 15469 | {"type": "Polygon", "coordinates": [[[-120.18038, 34.61185], [-120.17973, 34.61194], [-120.17955, 34.61197], [-120.17963, 34.61185], [-120.18036, 34.61174], [-120.18038, 34.61185]]]} | Open Access 1 | 36571 | Unnamed site - Santa Barbara, County of | 28662 | 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 | 0.219 | 0 | Local Other or Unknown 14 | 4 | ||
14869 | 14869 | 14868 | {"type": "Polygon", "coordinates": [[[-118.23121, 34.21905], [-118.23088, 34.21936], [-118.23059, 34.21958], [-118.23052, 34.21953], [-118.23111, 34.21899], [-118.23121, 34.21905]]]} | Open Access 1 | 45388 | Pickens Canyon Park | 32497 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Pickens_Canyon_Park | Los Angeles 6 | 0.22 | Pickens Canyon Park | 0 | Local Park 2 | 4 |
13626 | 13626 | 13625 | {"type": "Polygon", "coordinates": [[[-121.54043, 39.47302], [-121.54011, 39.47302], [-121.54015, 39.47297], [-121.54015, 39.47262], [-121.54037, 39.47262], [-121.54038, 39.47297], [-121.54043, 39.47302]]]} | Open Access 1 | 35972 | Butte holding 33 | 16577 | 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.222 | Butte holding 33 | 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]);