units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
214 rows where DES_TP = 14 and MNG_AG_TYP = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY 23
- Butte, County of 40
- Santa Barbara, County of 35
- Lake, County of 34
- Orange, County of 20
- Monterey, County of 17
- Los Angeles, County of 11
- Sacramento, County of 6
- Ventura, County of 5
- Santa Cruz, County of 4
- San Diego, County of 4
- Tulare, County of 3
- Riverside, County of 3
- Merced, County of 2
- Placer, County of 1
- Imperial, County of 1
- San Bernardino, County of 1
- Napa, County of 1
- Yolo, County of 1
- Humboldt, County of 1
- Tehama, County of 1
- Trinity, County of 1
- Marin, County of 1
- Solano, County of 1
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency · 194 ✖
DES_TP 1
- Local Other or Unknown · 194 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13594 | 13594 | 13593 | {"type": "Polygon", "coordinates": [[[-121.53726, 39.64644], [-121.53646, 39.64655], [-121.53638, 39.64653], [-121.53648, 39.6463], [-121.53726, 39.64644]]]} | Open Access 1 | 35930 | Butte holding 10 | 16553 | 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.247 | Butte holding 10 | 0 | Local Other or Unknown 14 | 4 | |
4820 | 4820 | 4819 | {"type": "Polygon", "coordinates": [[[-119.31269, 36.05787], [-119.31226, 36.05793], [-119.31221, 36.0577], [-119.31261, 36.05762], [-119.31269, 36.05787]]]} | Open Access 1 | 48894 | Unknown park - Tulare, County of | 33611 | 330 | Tulare, County of 96 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | Tulare 29 | 0.259 | 0 | Local Other or Unknown 14 | 4 | ||
3968 | 3968 | 3967 | {"type": "Polygon", "coordinates": [[[-122.7831, 39.06946], [-122.78298, 39.06985], [-122.78268, 39.06984], [-122.78283, 39.06946], [-122.7831, 39.06946]]]} | Open Access 1 | 36680 | Lake holding 30 | 20918 | 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.262 | Lake holding 30 | 0 | Local Other or Unknown 14 | 4 | |
10361 | 10361 | 10360 | {"type": "Polygon", "coordinates": [[[-120.11686, 34.66391], [-120.11686, 34.66443], [-120.11666, 34.66443], [-120.11667, 34.6639], [-120.11686, 34.66391]]]} | Open Access 1 | 18384 | Alamo Pintado Creek | 15318 | 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.262 | Alamo Pintado Creek | 0 | Local Other or Unknown 14 | 4 | |
3939 | 3939 | 3938 | {"type": "Polygon", "coordinates": [[[-121.62744, 39.74865], [-121.62744, 39.74881], [-121.62673, 39.74875], [-121.62673, 39.74859], [-121.62744, 39.74865]]]} | Open Access 1 | 36311 | Butte holding 14 | 16557 | 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.271 | Butte holding 14 | 0 | Local Other or Unknown 14 | 4 | |
14138 | 14138 | 14137 | {"type": "Polygon", "coordinates": [[[-121.80908, 39.70888], [-121.80893, 39.70884], [-121.80835, 39.70799], [-121.80846, 39.70795], [-121.80908, 39.70888]]]} | Open Access 1 | 43006 | Butte holding 31 | 16575 | 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.275 | Butte holding 31 | 0 | Local Other or Unknown 14 | 4 | |
13586 | 13586 | 13585 | {"type": "Polygon", "coordinates": [[[-121.57946, 39.50391], [-121.57904, 39.50395], [-121.57906, 39.50363], [-121.57941, 39.5036], [-121.57946, 39.50391]]]} | Open Access 1 | 35945 | Butte holding 51 | 16596 | 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.284 | Butte holding 51 | 0 | Local Other or Unknown 14 | 4 | |
884 | 884 | 883 | {"type": "Polygon", "coordinates": [[[-122.78298, 39.06985], [-122.78285, 39.07024], [-122.78253, 39.07024], [-122.78268, 39.06984], [-122.78298, 39.06985]]]} | Open Access 1 | 35936 | Lake holding 49 | 20938 | 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.292 | Lake holding 49 | 0 | Local Other or Unknown 14 | 4 | |
13593 | 13593 | 13592 | {"type": "Polygon", "coordinates": [[[-121.81614, 39.72758], [-121.81561, 39.72764], [-121.8156, 39.7274], [-121.81609, 39.72734], [-121.81614, 39.72758]]]} | Open Access 1 | 35929 | Butte holding 9 | 16603 | 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.296 | Butte holding 9 | 0 | Local Other or Unknown 14 | 4 | |
15474 | 15474 | 15473 | {"type": "Polygon", "coordinates": [[[-120.18167, 34.61167], [-120.18058, 34.61182], [-120.18055, 34.61172], [-120.18165, 34.61156], [-120.18167, 34.61167]]]} | Open Access 1 | 36578 | 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.307 | 0 | Local Other or Unknown 14 | 4 | ||
4000 | 4000 | 3999 | {"type": "Polygon", "coordinates": [[[-121.7975, 39.63935], [-121.79716, 39.63942], [-121.797, 39.63897], [-121.79721, 39.63893], [-121.79729, 39.63902], [-121.7975, 39.63935]]]} | Open Access 1 | 43010 | Butte holding 29 | 16573 | 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.324 | Butte holding 29 | 0 | Local Other or Unknown 14 | 4 | |
4573 | 4573 | 4572 | {"type": "Polygon", "coordinates": [[[-121.68761, 36.61869], [-121.68717, 36.61899], [-121.68712, 36.61905], [-121.687, 36.61903], [-121.68706, 36.61882], [-121.68721, 36.61854], [-121.68761, 36.61869]]]} | Open Access 1 | 35223 | Unnamed site - Monterey, County of | 28641 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 0.347 | 0 | Local Other or Unknown 14 | 4 | ||
4642 | 4642 | 4641 | {"type": "Polygon", "coordinates": [[[-119.78178, 34.43221], [-119.78161, 34.43233], [-119.78143, 34.43249], [-119.78137, 34.43253], [-119.78129, 34.43254], [-119.78124, 34.43252], [-119.78118, 34.43247], [-119.78115, 34.43241], [-119.78114, 34.43234], [-119.78116, 34.43228], [-119.7812, 34.43223], [-119.78127, 34.4322], [-119.78176, 34.43218], [-119.78178, 34.43221]]]} | Open Access 1 | 36491 | 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.349 | 0 | Local Other or Unknown 14 | 4 | ||
13578 | 13578 | 13577 | {"type": "Polygon", "coordinates": [[[-121.16103, 39.53302], [-121.16075, 39.53306], [-121.16074, 39.53253], [-121.16102, 39.53249], [-121.16103, 39.53302]]]} | Open Access 1 | 35944 | Butte holding 46 | 16590 | 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.356 | Butte holding 46 | 0 | Local Other or Unknown 14 | 4 | |
927 | 927 | 926 | {"type": "Polygon", "coordinates": [[[-122.84377, 39.00039], [-122.84353, 39.00038], [-122.84353, 38.99972], [-122.84377, 38.99973], [-122.84377, 39.00039]]]} | Open Access 1 | 35937 | Lake holding 33 | 20921 | 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.38 | Lake holding 33 | 0 | Local Other or Unknown 14 | 4 | |
13796 | 13796 | 13795 | {"type": "Polygon", "coordinates": [[[-121.85077, 39.77573], [-121.85049, 39.77573], [-121.84981, 39.77506], [-121.84994, 39.77497], [-121.85039, 39.77543], [-121.85077, 39.77573]]]} | Open Access 1 | 36364 | Butte holding 19 | 16562 | 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.384 | Butte holding 19 | 0 | Local Other or Unknown 14 | 4 | |
4003 | 4003 | 4002 | {"type": "Polygon", "coordinates": [[[-121.74737, 39.49534], [-121.74694, 39.49534], [-121.74694, 39.49496], [-121.74736, 39.49496], [-121.74737, 39.49534]]]} | Open Access 1 | 43013 | Butte holding 23 | 16567 | 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.385 | Butte holding 23 | 0 | Local Other or Unknown 14 | 4 | |
4657 | 4657 | 4656 | {"type": "Polygon", "coordinates": [[[-118.65926, 34.28468], [-118.65925, 34.28475], [-118.65918, 34.28484], [-118.65918, 34.28491], [-118.65916, 34.28495], [-118.65909, 34.28501], [-118.65903, 34.28503], [-118.65866, 34.28502], [-118.65824, 34.28486], [-118.65827, 34.28481], [-118.65866, 34.28496], [-118.659, 34.28498], [-118.65901, 34.28497], [-118.65901, 34.28485], [-118.65893, 34.28478], [-118.6589, 34.28472], [-118.6589, 34.28466], [-118.65893, 34.28461], [-118.65902, 34.28455], [-118.65913, 34.28455], [-118.65922, 34.28459], [-118.65926, 34.28468]]]} | Open Access 1 | 36586 | Unnamed site - Ventura, County of | 28674 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 0.389 | 0 | Local Other or Unknown 14 | 4 | ||
4652 | 4652 | 4651 | {"type": "Polygon", "coordinates": [[[-120.41955, 34.86001], [-120.41894, 34.86], [-120.41895, 34.85937], [-120.4194, 34.85991], [-120.41955, 34.86001]]]} | Open Access 1 | 36565 | 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.425 | 0 | Local Other or Unknown 14 | 4 | ||
13632 | 13632 | 13631 | {"type": "Polygon", "coordinates": [[[-122.59666, 39.07534], [-122.59641, 39.07554], [-122.59618, 39.07535], [-122.59606, 39.07511], [-122.59631, 39.07494], [-122.59666, 39.07534]]]} | Open Access 1 | 35984 | Lake holding 41 | 20930 | 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.441 | Lake holding 41 | 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]);