units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
485 rows where DES_TP = 4 sorted by COUNTY descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER, MNG_AG_LEV
MNG_AGENCY >30
- Midpeninsula Regional Open Space District 50
- East Bay Regional Park District 40
- San Diego, County of 37
- Marin County Open Space District 34
- Mountains Recreation and Conservation Authority 22
- Orange, County of 19
- Santa Clara Valley Open Space Authority 19
- Los Angeles, County of 15
- San Diego, City of 9
- Riverside County Habitat Conservation Agency 9
- Sonoma County Agricultural Preservation and Open Space District 8
- Burbank, City of 7
- Chico, City of 7
- Santa Barbara, County of 5
- San Luis Obispo, County of 5
- Watsonville, City of 5
- Glendora, City of 5
- Redlands, City of 5
- Riverside, County of 5
- Sonoma County Regional Parks Dept., County of 5
- Los Angeles, City of 4
- Monterey Peninsula Regional Park District 4
- Napa County Regional Park and Open Space District 4
- Marin County Parks Department, County of 4
- Palo Alto, City of 4
- Gilroy, City of 4
- Sacramento, County of 4
- Santa Cruz, County of 3
- Carlsbad, City of 3
- Riverside County Regional Park and Open Space District 3
- …
AGNCY_TYP 19 ✖
- Recreation/Parks District 165
- City Agency 149
- County Agency 98
- Open Space District 20
- County Agency - Parks 12
- Water District 9
- Federal Agency 5
- State Agency 5
- Flood District 4
- County Agency - Other 4
- Transportation Agency 3
- Port/Harbor District 2
- Joint Powers Authority 2
- Conservation District 2
- Non Profit - Land Trust 1
- Irrigation District 1
- Community Services District 1
- Utility 1
- Special District - Other 1
MNG_AG_TYP 15
- Recreation/Parks District 172
- City Agency 143
- County Agency 103
- Open Space District 35
- County Agency - Parks 12
- Water District 4
- Transportation Agency 3
- County Agency - Other 2
- Flood District 2
- Port/Harbor District 2
- Joint Powers Authority 2
- Conservation District 2
- Irrigation District 1
- Community Services District 1
- Special District - Other 1
ACCESS_TYP 4
- Open Access 350
- No Public Access 77
- Restricted Access 47
- Unknown Access 11
DES_TP 1
- Local Conservation Area · 485 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12214 | 12214 | 12213 | {"type": "MultiPolygon", "coordinates": [[[[-124.0922, 40.85233], [-124.09217, 40.85237], [-124.09208, 40.85261], [-124.09198, 40.85277], [-124.09195, 40.85289], [-124.09192, 40.85295], [-124.09191, 40.85305], [-124.09182, 40.85328], [-124.09181, 40.85336], [-124.09173, 40.85337], [-124.09169, 40.85341], [-124.09169, 40.85343], [-124.09173, 40.85348], [-124.09167, 40.85366], [-124.09157, 40.85371], [-124.09157, 40.85374], [-124.09162, 40.85379], [-124.09161, 40.85386], [-124.09154, 40.85392], [-124.09147, 40.85408], [-124.09139, 40.8543], [-124.09136, 40.85443], [-124.09125, 40.85461], [-124.09119, 40.85468], [-124.0911, 40.85476], [-124.09093, 40.85484], [-124.09088, 40.8549], [-124.09081, 40.8549], [-124.09077, 40.85493], [-124.09069, 40.85491], [-124.09058, 40.85492], [-124.08966, 40.8546], [-124.08891, 40.85519], [-124.08854, 40.85492], [-124.0858, 40.85304], [-124.08464, 40.85214], [-124.08416, 40.85171], [-124.08351, 40.85098], [-124.0832, 40.85056], [-124.08307, 40.85033], [-124.08348, 40.85033], [-124.08347, 40.85012], [-124.08388, 40.84935], [-124.08421, 40.84866], [-124.08428, 40.84847], [-124.08437, 40.84857], [-124.08442, 40.84867], [-124.08445, 40.84869], [-124.08445, 40.8488], [-124.0845, 40.84884], [-124.08457, 40.84887], [-124.08451, 40.84889], [-124.08454, 40.84892], [-124.08452, 40.84895], [-124.08462, 40.849], [-124.08463, 40.84906], [-124.08462, 40.8491], [-124.08468, 40.8492], [-124.0847, 40.8493], [-124.08472, 40.84932], [-124.08477, 40.84932], [-124.08488, 40.84929], [-124.08491, 40.8493], [-124.08493, 40.84933], [-124.08491, 40.84935], [-124.08487, 40.84935], [-124.08491, 40.84939], [-124.08488, 40.84946], [-124.0849, 40.84948], [-124.08499, 40.84946], [-124.08497, 40.8494], [-124.08498, 40.84938], [-124.085, 40.84942], [-124.08506, 40.84946], [-124.08527, 40.84947], [-124.0863, 40.84945], [-124.08703, 40.8494], [-124.08735, 40.84934], [-124.08737, 40.84938], [-124.08739, 40.84939], [-124.08747, 40.84932], [-124.08835, 40.84911], [-124.08866, 40.84906], [-124.08893, 40.84899], [-124.09039, 40.84871], [-124.09053, 40.84867], [-124.0906, 40.84866], [-124.09085, 40.84869], [-124.09104, 40.84876], [-124.09123, 40.84889], [-124.09137, 40.84909], [-124.09142, 40.8492], [-124.09144, 40.84928], [-124.09153, 40.84949], [-124.09164, 40.84995], [-124.09173, 40.85017], [-124.09176, 40.8503], [-124.09176, 40.85036], [-124.09182, 40.85046], [-124.09186, 40.85057], [-124.09196, 40.85099], [-124.09205, 40.85129], [-124.09213, 40.85139], [-124.09213, 40.85145], [-124.09218, 40.85155], [-124.09217, 40.85166], [-124.0922, 40.85178], [-124.09218, 40.85184], [-124.09223, 40.85202], [-124.09217, 40.85221], [-124.09217, 40.85225], [-124.09215, 40.85229], [-124.0922, 40.85233]]], [[[-124.09288, 40.86131], [-124.09233, 40.86198], [-124.08922, 40.86191], [-124.08921, 40.86125], [-124.08924, 40.86109], [-124.08936, 40.86058], [-124.08901, 40.8605], [-124.08951, 40.85919], [-124.08989, 40.85814], [-124.08992, 40.85752], [-124.0895, 40.85628], [-124.08941, 40.85607], [-124.08932, 40.8559], [-124.08918, 40.85571], [-124.08897, 40.85547], [-124.08919, 40.85561], [-124.0896, 40.85596], [-124.09038, 40.85673], [-124.09101, 40.85744], [-124.0915, 40.8581], [-124.09191, 40.85878], [-124.09215, 40.85924], [-124.09236, 40.85971], [-124.09243, 40.85988], [-124.09269, 40.8607], [-124.09277, 40.86087], [-124.09288, 40.86131]]], [[[-124.09302, 40.86339], [-124.09163, 40.863], [-124.09292, 40.86147], [-124.093, 40.86205], [-124.09303, 40.86246], [-124.09304, 40.86295], [-124.09302, 40.86339]]], [[[-124.10303, 40.86232], [-124.10334, 40.86264], [-124.10336, 40.8627], [-124.10336, 40.86281], [-124.1033, 40.86302], [-124.10326, 40.86308], [-124.10312, 40.86323], [-124.10288, 40.8634], [-124.1028, 40.86351], [-124.10277, 40.86358], [-124.10253, 40.86395], [-124.10204, 40.86408], [-124.10168, 40.86419], [-124.10189, 40.86465], [-124.10226, 40.86484], [-124.10237, 40.86492], [-124.10241, 40.86497], [-124.10243, 40.86513], [-124.10247, 40.8652], [-124.10292, 40.86556], [-124.10302, 40.86563], [-124.10308, 40.86571], [-124.10311, 40.8658], [-124.10309, 40.8659], [-124.10298, 40.86611], [-124.10292, 40.86618], [-124.10288, 40.86622], [-124.10275, 40.86627], [-124.10243, 40.86646], [-124.10239, 40.86695], [-124.10229, 40.86746], [-124.10181, 40.8675], [-124.10212, 40.86729], [-124.10215, 40.86708], [-124.10209, 40.86683], [-124.10224, 40.86614], [-124.10239, 40.86608], [-124.10246, 40.86575], [-124.10239, 40.86561], [-124.10216, 40.86535], [-124.10208, 40.86506], [-124.10164, 40.86479], [-124.09866, 40.86479], [-124.0984, 40.86542], [-124.0975, 40.86524], [-124.09736, 40.86557], [-124.09736, 40.86587], [-124.09543, 40.86547], [-124.09576, 40.86468], [-124.09314, 40.86393], [-124.09319, 40.86344], [-124.09322, 40.86268], [-124.09318, 40.86204], [-124.09306, 40.8613], [-124.09401, 40.86015], [-124.09505, 40.85893], [-124.0951, 40.85892], [-124.09517, 40.85895], [-124.09529, 40.85919], [-124.09541, 40.85934], [-124.09554, 40.85945], [-124.09574, 40.85955], [-124.09593, 40.85961], [-124.09638, 40.85966], [-124.09679, 40.85962], [-124.0968, 40.85961], [-124.09592, 40.85949], [-124.09568, 40.85939], [-124.09556, 40.85931], [-124.09543, 40.85916], [-124.0952, 40.85867], [-124.09512, 40.85863], [-124.09503, 40.85863], [-124.09496, 40.85867], [-124.09495, 40.8587], [-124.09495, 40.85883], [-124.09493, 40.85887], [-124.09387, 40.86011], [-124.09303, 40.86114], [-124.09295, 40.86086], [-124.09281, 40.86051], [-124.09262, 40.85988], [-124.09236, 40.85926], [-124.09209, 40.85874], [-124.09174, 40.85817], [-124.09137, 40.85765], [-124.09083, 40.85698], [-124.09047, 40.85659], [-124.09037, 40.85632], [-124.09158, 40.85532], [-124.09172, 40.8553], [-124.09178, 40.85527], [-124.09179, 40.85525], [-124.09178, 40.85521], [-124.0918, 40.85517], [-124.09191, 40.85507], [-124.09234, 40.85459], [-124.09283, 40.85414], [-124.09301, 40.85393], [-124.09315, 40.85381], [-124.09323, 40.85376], [-124.0934, 40.85372], [-124.0936, 40.85371], [-124.09385, 40.85375], [-124.09408, 40.85376], [-124.09499, 40.85403], [-124.09519, 40.85412], [-124.09576, 40.85429], [-124.09614, 40.85442], [-124.09623, 40.85447], [-124.09628, 40.85448], [-124.09634, 40.85452], [-124.09687, 40.8547], [-124.09726, 40.85486], [-124.09757, 40.85496], [-124.09828, 40.85524], [-124.09844, 40.85537], [-124.09857, 40.85553], [-124.09861, 40.85559], [-124.09862, 40.85579], [-124.09854, 40.85603], [-124.09843, 40.85622], [-124.09847, 40.85636], [-124.09846, 40.85643], [-124.09838, 40.85664], [-124.09823, 40.85662], [-124.09768, 40.85819], [-124.09827, 40.85834], [-124.09854, 40.85836], [-124.09888, 40.85836], [-124.09989, 40.85815], [-124.10004, 40.85815], [-124.10027, 40.85818], [-124.10047, 40.8583], [-124.10059, 40.8584], [-124.10061, 40.85846], [-124.09991, 40.8586], [-124.09982, 40.85879], [-124.09984, 40.85888], [-124.10008, 40.85926], [-124.1002, 40.8595], [-124.10025, 40.85956], [-124.10031, 40.8596], [-124.1004, 40.85964], [-124.10096, 40.85977], [-124.10103, 40.85981], [-124.10107, 40.85986], [-124.10074, 40.86022], [-124.10055, 40.86034], [-124.10046, 40.86045], [-124.10041, 40.86063], [-124.10041, 40.86091], [-124.10042, 40.86097], [-124.10088, 40.86186], [-124.10121, 40.86266], [-124.10134, 40.86277], [-124.10153, 40.86286], [-124.1017, 40.8629], [-124.10192, 40.8629], [-124.10223, 40.86276], [-124.10264, 40.8624], [-124.10272, 40.86234], [-124.10278, 40.86232], [-124.1029, 40.8623], [-124.10303, 40.86232]]]]} | Open Access 1 | 25405 | Arcata Marsh & Wildlife Sanctuary | 15570 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 316.49 | Arcata Marsh & Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 | |
14366 | 14366 | 14365 | {"type": "MultiPolygon", "coordinates": [[[[-124.0907, 40.87504], [-124.09043, 40.87498], [-124.09043, 40.87491], [-124.09035, 40.87489], [-124.0905, 40.87451], [-124.0907, 40.87504]]], [[[-124.09106, 40.87533], [-124.09096, 40.87542], [-124.09102, 40.87562], [-124.09096, 40.87576], [-124.09097, 40.87604], [-124.09089, 40.87657], [-124.09081, 40.8764], [-124.09075, 40.8762], [-124.09062, 40.87551], [-124.09044, 40.87505], [-124.09103, 40.87517], [-124.09106, 40.87533]]], [[[-124.09083, 40.87428], [-124.09074, 40.87443], [-124.09073, 40.87459], [-124.09067, 40.87467], [-124.09055, 40.87437], [-124.0906, 40.87423], [-124.09083, 40.87428]]]]} | Open Access 1 | 47025 | Dellanina Nature Preserve | 30674 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 1.331 | Dellanina Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
16781 | 16781 | 16780 | {"type": "Polygon", "coordinates": [[[-124.08173, 40.85366], [-124.08205, 40.85795], [-124.08204, 40.85906], [-124.08207, 40.86057], [-124.08202, 40.86085], [-124.08195, 40.86105], [-124.08189, 40.86114], [-124.08163, 40.8614], [-124.08149, 40.86151], [-124.0813, 40.86161], [-124.08108, 40.8617], [-124.08089, 40.86176], [-124.08045, 40.86184], [-124.08038, 40.85941], [-124.08034, 40.85885], [-124.0789, 40.85886], [-124.07895, 40.86166], [-124.07872, 40.86161], [-124.07846, 40.86153], [-124.07833, 40.86147], [-124.07833, 40.86145], [-124.07796, 40.86131], [-124.07763, 40.86114], [-124.07732, 40.86104], [-124.07701, 40.86099], [-124.07685, 40.86113], [-124.07634, 40.86087], [-124.07601, 40.86066], [-124.07575, 40.86044], [-124.07555, 40.86025], [-124.07351, 40.85798], [-124.07422, 40.85762], [-124.07362, 40.85567], [-124.07233, 40.85574], [-124.07226, 40.85358], [-124.07302, 40.85358], [-124.07299, 40.85048], [-124.07303, 40.84968], [-124.06907, 40.84969], [-124.06897, 40.84952], [-124.06746, 40.84753], [-124.07029, 40.84629], [-124.07029, 40.84627], [-124.06941, 40.8451], [-124.06943, 40.84508], [-124.06847, 40.8444], [-124.06704, 40.84256], [-124.0661, 40.84234], [-124.06497, 40.84145], [-124.06591, 40.84078], [-124.06643, 40.8412], [-124.06667, 40.84104], [-124.06696, 40.84128], [-124.06731, 40.84104], [-124.06894, 40.84233], [-124.07297, 40.8423], [-124.07297, 40.84018], [-124.07238, 40.84001], [-124.07216, 40.83988], [-124.07148, 40.83966], [-124.07063, 40.83907], [-124.07057, 40.83901], [-124.07033, 40.83899], [-124.07015, 40.83906], [-124.07008, 40.83903], [-124.07005, 40.83901], [-124.07005, 40.83896], [-124.07009, 40.83875], [-124.07015, 40.83869], [-124.07016, 40.83864], [-124.07016, 40.83859], [-124.07009, 40.83846], [-124.07041, 40.83803], [-124.07088, 40.8378], [-124.07057, 40.83747], [-124.07097, 40.83718], [-124.07299, 40.83865], [-124.07384, 40.83503], [-124.07993, 40.83507], [-124.08014, 40.83513], [-124.08081, 40.83521], [-124.08097, 40.83527], [-124.08109, 40.83536], [-124.08113, 40.83541], [-124.08122, 40.83563], [-124.08142, 40.83776], [-124.08153, 40.83871], [-124.08151, 40.84041], [-124.08148, 40.84617], [-124.0813, 40.84616], [-124.08129, 40.84617], [-124.0813, 40.84716], [-124.08128, 40.84882], [-124.08144, 40.8506], [-124.08146, 40.8506], [-124.08152, 40.85053], [-124.08161, 40.85091], [-124.08164, 40.85242], [-124.08173, 40.85366]], [[-124.07898, 40.84969], [-124.07899, 40.84968], [-124.07896, 40.8489], [-124.07788, 40.84904], [-124.07788, 40.8497], [-124.07898, 40.84969]]]} | Open Access 1 | 46882 | Jacoby Creek-Gannon Slough Wildlife Area | 30363 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 587.76 | Jacoby Creek-Gannon Slough Wildlife Area | 0 | Local Conservation Area 4 | 2 | |
4308 | 4308 | 4307 | {"type": "Polygon", "coordinates": [[[-121.82502, 39.78339], [-121.807, 39.78385], [-121.807, 39.78435], [-121.80343, 39.78447], [-121.79613, 39.77739], [-121.79301, 39.77069], [-121.79286, 39.77039], [-121.79359, 39.76989], [-121.79276, 39.76989], [-121.79367, 39.76932], [-121.79945, 39.76553], [-121.79947, 39.76534], [-121.79967, 39.76551], [-121.80032, 39.76508], [-121.80282, 39.76371], [-121.80419, 39.76528], [-121.80616, 39.76764], [-121.80643, 39.76788], [-121.80643, 39.76929], [-121.81444, 39.77536], [-121.81457, 39.77535], [-121.81481, 39.7754], [-121.81822, 39.77698], [-121.81752, 39.77771], [-121.82502, 39.78339]]]} | Open Access 1 | 45364 | Bidwell Ranch Preserve | 16070 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 756.644 | Bidwell Ranch Preserve | 0 | Local Conservation Area 4 | 2 | |
9455 | 9455 | 9454 | {"type": "MultiPolygon", "coordinates": [[[[-121.78112, 39.7262], [-121.77809, 39.72622], [-121.77808, 39.72462], [-121.77825, 39.72467], [-121.77875, 39.72424], [-121.77911, 39.72406], [-121.77947, 39.72361], [-121.77957, 39.72373], [-121.78071, 39.7244], [-121.78111, 39.72483], [-121.78125, 39.72528], [-121.78112, 39.7262]]], [[[-121.79536, 39.73944], [-121.79055, 39.73888], [-121.79053, 39.73776], [-121.79385, 39.73726], [-121.79534, 39.73763], [-121.79536, 39.73944]]]]} | Open Access 1 | 15827 | Preserve Areas | 2238 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 33.396 | Preserve Areas | 0 | Local Conservation Area 4 | 2 | |
13707 | 13707 | 13706 | {"type": "MultiPolygon", "coordinates": [[[[-121.77899, 39.72934], [-121.77873, 39.7295], [-121.77861, 39.72949], [-121.77845, 39.72935], [-121.77833, 39.72941], [-121.77802, 39.72945], [-121.77802, 39.72992], [-121.77386, 39.73195], [-121.77333, 39.73185], [-121.77331, 39.73068], [-121.77334, 39.73068], [-121.77335, 39.73104], [-121.774, 39.73102], [-121.774, 39.73091], [-121.77429, 39.73083], [-121.77467, 39.7308], [-121.77522, 39.73068], [-121.77551, 39.73065], [-121.7756, 39.73059], [-121.77563, 39.7305], [-121.77637, 39.7305], [-121.7766, 39.73038], [-121.77672, 39.73037], [-121.77679, 39.73031], [-121.77722, 39.73031], [-121.77722, 39.72916], [-121.77802, 39.72915], [-121.77816, 39.72911], [-121.77822, 39.72906], [-121.77828, 39.72898], [-121.77839, 39.72893], [-121.779, 39.72921], [-121.77902, 39.72924], [-121.77899, 39.72934]]], [[[-121.77943, 39.72965], [-121.77914, 39.72969], [-121.77906, 39.72935], [-121.77909, 39.72928], [-121.77916, 39.72927], [-121.77929, 39.72931], [-121.77934, 39.72935], [-121.77936, 39.72938], [-121.77938, 39.72952], [-121.77943, 39.72965]]], [[[-121.78023, 39.72944], [-121.78012, 39.72956], [-121.77961, 39.72963], [-121.77955, 39.72949], [-121.77953, 39.72935], [-121.77949, 39.72928], [-121.7794, 39.7292], [-121.77925, 39.72915], [-121.77922, 39.72911], [-121.77943, 39.72877], [-121.77961, 39.7286], [-121.77975, 39.72853], [-121.77987, 39.72849], [-121.7802, 39.72843], [-121.78028, 39.7287], [-121.7802, 39.72884], [-121.78021, 39.72903], [-121.78013, 39.72912], [-121.7799, 39.72917], [-121.77988, 39.72918], [-121.78023, 39.72944]]]]} | Open Access 1 | 36082 | Hillview Preserve | 19996 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 9.976 | Hillview Preserve | 0 | Local Conservation Area 4 | 2 | |
14696 | 14696 | 14695 | {"type": "Polygon", "coordinates": [[[-121.80841, 39.76956], [-121.80823, 39.76957], [-121.80746, 39.77005], [-121.80758, 39.77016], [-121.80642, 39.76929], [-121.80643, 39.76853], [-121.80708, 39.76853], [-121.80745, 39.7689], [-121.80751, 39.76892], [-121.80751, 39.76895], [-121.80767, 39.76908], [-121.80801, 39.76933], [-121.80841, 39.76956]]]} | Open Access 1 | 45026 | Eaton Road Preserve | 18413 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 3.753 | Eaton Road Preserve | 0 | Local Conservation Area 4 | 2 | |
14697 | 14697 | 14696 | {"type": "Polygon", "coordinates": [[[-121.80876, 39.76798], [-121.80871, 39.76806], [-121.80871, 39.76814], [-121.80873, 39.76815], [-121.80863, 39.76821], [-121.80864, 39.76851], [-121.80763, 39.76852], [-121.8071, 39.76788], [-121.80738, 39.76769], [-121.8079, 39.76741], [-121.8081, 39.76735], [-121.80827, 39.76733], [-121.80829, 39.76733], [-121.8083, 39.76746], [-121.80846, 39.76763], [-121.80856, 39.76768], [-121.80866, 39.76792], [-121.80876, 39.76798]]]} | Unknown Access 4 | 45027 | Wildwood Estate Preserve | 27518 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 3.11 | Wildwood Estate Preserve | 0 | Local Conservation Area 4 | 2 | |
14699 | 14699 | 14698 | {"type": "MultiPolygon", "coordinates": [[[[-121.83044, 39.77695], [-121.83031, 39.77695], [-121.8251, 39.7756], [-121.82359, 39.7757], [-121.82261, 39.77517], [-121.82066, 39.77577], [-121.82065, 39.77574], [-121.81709, 39.77645], [-121.81481, 39.7754], [-121.81457, 39.77535], [-121.81444, 39.77536], [-121.81278, 39.7741], [-121.81342, 39.77381], [-121.81435, 39.77381], [-121.81691, 39.77345], [-121.82053, 39.77457], [-121.82061, 39.77431], [-121.82061, 39.77428], [-121.82055, 39.77402], [-121.82044, 39.77378], [-121.82024, 39.7735], [-121.8196, 39.77287], [-121.81948, 39.77273], [-121.81933, 39.7725], [-121.81923, 39.77226], [-121.81999, 39.77238], [-121.8217, 39.77235], [-121.82365, 39.77212], [-121.82531, 39.77171], [-121.82533, 39.77173], [-121.82594, 39.77152], [-121.82643, 39.7714], [-121.82683, 39.77127], [-121.82732, 39.77195], [-121.82744, 39.7721], [-121.82762, 39.77226], [-121.82782, 39.77238], [-121.82809, 39.7725], [-121.82831, 39.77256], [-121.82859, 39.7726], [-121.82884, 39.7726], [-121.82906, 39.77257], [-121.82933, 39.77251], [-121.8299, 39.77228], [-121.83057, 39.77323], [-121.83074, 39.77352], [-121.83085, 39.77383], [-121.83092, 39.77419], [-121.83093, 39.77447], [-121.8309, 39.77479], [-121.83044, 39.77695]]], [[[-121.84008, 39.78068], [-121.83856, 39.78182], [-121.8374, 39.78209], [-121.83598, 39.7817], [-121.83437, 39.78158], [-121.82839, 39.78231], [-121.8284, 39.78334], [-121.82502, 39.78339], [-121.81752, 39.7777], [-121.81821, 39.77698], [-121.81753, 39.77666], [-121.81793, 39.7766], [-121.81832, 39.77643], [-121.81936, 39.7761], [-121.81986, 39.77606], [-121.82012, 39.77612], [-121.82073, 39.77609], [-121.82134, 39.77595], [-121.82176, 39.77584], [-121.82206, 39.77572], [-121.82229, 39.77568], [-121.82301, 39.77594], [-121.82336, 39.7761], [-121.82365, 39.77612], [-121.82535, 39.77608], [-121.82542, 39.77609], [-121.82608, 39.77626], [-121.8268, 39.77655], [-121.82945, 39.77718], [-121.82977, 39.7773], [-121.83007, 39.77735], [-121.83078, 39.77732], [-121.83128, 39.77734], [-121.83238, 39.77743], [-121.83271, 39.7774], [-121.83459, 39.77744], [-121.83528, 39.77772], [-121.83552, 39.77789], [-121.83625, 39.7785], [-121.83686, 39.77883], [-121.8377, 39.77907], [-121.83785, 39.77916], [-121.83851, 39.77939], [-121.83911, 39.77965], [-121.8392, 39.77971], [-121.83926, 39.78019], [-121.83928, 39.78023], [-121.83939, 39.78029], [-121.83979, 39.78032], [-121.84008, 39.78068]]]]} | Open Access 1 | 45028 | Foothill Preserve | 18982 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 362.463 | Foothill Preserve | 0 | Local Conservation Area 4 | 2 | |
14810 | 14810 | 14809 | {"type": "Polygon", "coordinates": [[[-121.79697, 39.74059], [-121.79119, 39.74076], [-121.7909, 39.74056], [-121.79051, 39.74037], [-121.7905, 39.73904], [-121.7966, 39.73971], [-121.79681, 39.73971], [-121.79697, 39.74059]]]} | Open Access 1 | 45363 | Meriam Park Preserve | 22169 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 19.101 | Meriam Park Preserve | 0 | Local Conservation Area 4 | 2 | |
2734 | 2734 | 2733 | {"type": "Polygon", "coordinates": [[[-121.33438, 38.34361], [-121.33319, 38.34464], [-121.33304, 38.34475], [-121.33156, 38.34376], [-121.32059, 38.34373], [-121.31587, 38.3413], [-121.31593, 38.33691], [-121.31584, 38.33662], [-121.33219, 38.33672], [-121.33217, 38.33698], [-121.33427, 38.34166], [-121.33351, 38.34218], [-121.33376, 38.3427], [-121.33414, 38.34327], [-121.33438, 38.34361]]]} | Restricted Access 2 | 21422 | Cosumnes River Preserve | 17679 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 286.086 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
2735 | 2735 | 2734 | {"type": "Polygon", "coordinates": [[[-121.37929, 38.26206], [-121.37925, 38.26667], [-121.36993, 38.26662], [-121.36997, 38.26204], [-121.37929, 38.26206]]]} | Restricted Access 2 | 21423 | Cosumnes River Preserve | 17679 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 102.78 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
3082 | 3082 | 3081 | {"type": "Polygon", "coordinates": [[[-121.50672, 38.66802], [-121.50672, 38.66802], [-121.50395, 38.66804], [-121.50412, 38.66774], [-121.50423, 38.66746], [-121.5043, 38.66714], [-121.50431, 38.66685], [-121.50529, 38.66685], [-121.50671, 38.66684], [-121.50672, 38.66802]]]} | Open Access 1 | 21265 | North Natomas Park Nature Area | 22833 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 7.099 | North Natomas Park Nature Area | 0 | Local Conservation Area 4 | 2 | |
3774 | 3774 | 3773 | {"type": "Polygon", "coordinates": [[[-121.27757, 38.6844], [-121.27735, 38.6846], [-121.27714, 38.68446], [-121.27711, 38.68447], [-121.2769, 38.68433], [-121.27643, 38.68417], [-121.27632, 38.68409], [-121.27631, 38.68391], [-121.27174, 38.68393], [-121.27173, 38.68226], [-121.27214, 38.68226], [-121.27215, 38.68233], [-121.2722, 38.68239], [-121.27221, 38.68272], [-121.27308, 38.68271], [-121.27344, 38.68278], [-121.27471, 38.68354], [-121.27632, 38.68353], [-121.27632, 38.68368], [-121.27663, 38.68395], [-121.27711, 38.68411], [-121.27733, 38.68427], [-121.27736, 38.68425], [-121.27757, 38.6844]]]} | Open Access 1 | 45019 | Arcade Creek Park Preserve Development | 15564 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 10.069 | Arcade Creek Park Preserve Development | 0 | Local Conservation Area 4 | 2 | |
11022 | 11022 | 11021 | {"type": "Polygon", "coordinates": [[[-121.50608, 38.60857], [-121.50599, 38.60901], [-121.50599, 38.60912], [-121.50602, 38.60919], [-121.50591, 38.60958], [-121.50573, 38.60985], [-121.50543, 38.61018], [-121.50549, 38.61022], [-121.50499, 38.61022], [-121.50473, 38.6102], [-121.50492, 38.60947], [-121.50493, 38.60813], [-121.50453, 38.60802], [-121.50453, 38.60744], [-121.50521, 38.60734], [-121.50479, 38.60784], [-121.5053, 38.60811], [-121.50575, 38.60838], [-121.50598, 38.60832], [-121.50608, 38.60857]]]} | Open Access 1 | 21107 | Bannon Creek Preserve | 15801 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 5.638 | Bannon Creek Preserve | 0 | Local Conservation Area 4 | 2 | |
11084 | 11084 | 11083 | {"type": "Polygon", "coordinates": [[[-121.4649, 38.3205], [-121.46195, 38.32051], [-121.44506, 38.32078], [-121.44502, 38.32049], [-121.44467, 38.32051], [-121.44283, 38.30486], [-121.46162, 38.30476], [-121.4649, 38.3205]]]} | Restricted Access 2 | 21325 | Cosumnes River Preserve | 17680 | 1097 | Elk Grove, City of 963 | City 2 | City Agency 2 | http://www.elkgrovecity.org/ | City 2 | 1097 | Elk Grove, City of 931 | City 2 | City Agency 2 | Sacramento 41 | 740.158 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
11133 | 11133 | 11132 | {"type": "Polygon", "coordinates": [[[-121.51691, 38.25947], [-121.50965, 38.26426], [-121.5083, 38.26215], [-121.50771, 38.26135], [-121.5073, 38.26083], [-121.50498, 38.25966], [-121.50269, 38.25821], [-121.5029, 38.25787], [-121.50312, 38.25794], [-121.50676, 38.25202], [-121.50862, 38.25131], [-121.50878, 38.25131], [-121.50893, 38.25149], [-121.50982, 38.25136], [-121.5103, 38.25196], [-121.51058, 38.25188], [-121.51111, 38.25283], [-121.51144, 38.25331], [-121.5121, 38.2541], [-121.51264, 38.25478], [-121.51317, 38.25533], [-121.51401, 38.25612], [-121.51486, 38.25683], [-121.51562, 38.2574], [-121.51648, 38.25796], [-121.51562, 38.25854], [-121.51691, 38.25947]]]} | Restricted Access 2 | 21424 | Cosumnes River Preserve | 17679 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 229.043 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
11421 | 11421 | 11420 | {"type": "Polygon", "coordinates": [[[-121.28865, 38.49607], [-121.27955, 38.49606], [-121.27946, 38.48155], [-121.28863, 38.48158], [-121.28865, 38.49607]]]} | Restricted Access 2 | 22240 | Vernal Pool Prairie Preserve Area | 27000 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 317.004 | Vernal Pool Prairie Preserve Area | 0 | Local Conservation Area 4 | 2 | |
11606 | 11606 | 11605 | {"type": "Polygon", "coordinates": [[[-121.39534, 38.61331], [-121.39524, 38.61346], [-121.39523, 38.61377], [-121.3953, 38.61409], [-121.39469, 38.61448], [-121.39334, 38.6141], [-121.39334, 38.61281], [-121.39398, 38.61283], [-121.394, 38.61331], [-121.39534, 38.61331]]]} | Open Access 1 | 23971 | Creekside Nature Area | 17769 | 2192 | Fulton - El Camino 984 | Special District 4 | Special District - Other 26 | http://www.fecrecpark.com/index.htm | Special District 4 | 2192 | Fulton - El Camino 948 | Special District 4 | Special District - Other 24 | Sacramento 41 | 5.27 | Creekside Nature Area | 0 | Local Conservation Area 4 | 2 | |
11621 | 11621 | 11620 | {"type": "Polygon", "coordinates": [[[-121.26212, 38.68889], [-121.26212, 38.68892], [-121.26177, 38.68897], [-121.26135, 38.6891], [-121.26129, 38.68913], [-121.26129, 38.68956], [-121.26014, 38.68957], [-121.25979, 38.68906], [-121.25915, 38.68886], [-121.25901, 38.68874], [-121.25871, 38.68871], [-121.25849, 38.68884], [-121.2581, 38.689], [-121.25809, 38.68917], [-121.25802, 38.68917], [-121.25802, 38.689], [-121.25767, 38.689], [-121.25759, 38.68872], [-121.25757, 38.68853], [-121.25749, 38.68838], [-121.25768, 38.68856], [-121.25794, 38.68867], [-121.25809, 38.6884], [-121.25827, 38.68844], [-121.25846, 38.68846], [-121.25862, 38.68844], [-121.25883, 38.68839], [-121.25894, 38.68857], [-121.25913, 38.68859], [-121.25926, 38.68854], [-121.25968, 38.6882], [-121.25974, 38.68796], [-121.25972, 38.68785], [-121.25986, 38.68785], [-121.26012, 38.68755], [-121.26018, 38.68757], [-121.26016, 38.68776], [-121.26041, 38.68801], [-121.26059, 38.6879], [-121.26115, 38.6879], [-121.26119, 38.68764], [-121.26125, 38.68765], [-121.26125, 38.68794], [-121.26146, 38.688], [-121.26174, 38.68788], [-121.26211, 38.68785], [-121.26208, 38.688], [-121.26208, 38.68818], [-121.26211, 38.68828], [-121.26209, 38.68847], [-121.26209, 38.68888], [-121.26212, 38.68889]]]} | Open Access 1 | 23902 | Sundance Park Natural Area | 25989 | 2248 | Orangevale Recreation and Park District 928 | Special District 4 | Recreation/Parks District 4 | http://www.orangevalecommunitycenter.com/ | Special District 4 | 2248 | Orangevale Recreation and Park District 901 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 10.407 | Sundance Park Natural Area | 0 | Local Conservation Area 4 | 2 |
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]);