units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
59 rows where ACCESS_TYP = 2 and MNG_AG_TYP = 3 sorted by DES_TP descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, COUNTY, YR_EST, GAP_STS
DES_TP 18
- Local Recreation Area 21
- Local Conservation Area 12
- Local Park 6
- Local Other or Unknown 6
- National Recreation Area 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
MNG_AGENCY 15
- Sacramento, County of 23
- Los Angeles, County of 14
- Orange, County of 5
- San Diego, County of 3
- Santa Cruz, County of 2
- San Luis Obispo, County of 2
- Ventura, County of 2
- Monterey, County of 1
- Tulare, County of 1
- Riverside, County of 1
- Placer, County of 1
- Fresno, County of 1
- Kern, County of 1
- Humboldt, County of 1
- Shasta, County of 1
MNG_AG_TYP 1
- County Agency · 59 ✖
ACCESS_TYP 1
- Restricted Access · 59 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11419 | 11419 | 11418 | {"type": "MultiPolygon", "coordinates": [[[[-121.17476, 38.47876], [-121.1741, 38.47839], [-121.17414, 38.47832], [-121.17425, 38.47823], [-121.1744, 38.47819], [-121.17462, 38.47819], [-121.1747, 38.47821], [-121.17479, 38.47825], [-121.17487, 38.47832], [-121.17491, 38.47838], [-121.17494, 38.47845], [-121.17494, 38.47852], [-121.17492, 38.47859], [-121.17488, 38.47866], [-121.17476, 38.47876]]], [[[-121.18136, 38.48039], [-121.17757, 38.48451], [-121.17626, 38.48377], [-121.17616, 38.48373], [-121.1764, 38.48358], [-121.17654, 38.48355], [-121.1767, 38.48368], [-121.17694, 38.48382], [-121.17721, 38.48387], [-121.17772, 38.48405], [-121.17783, 38.48404], [-121.17789, 38.4839], [-121.17787, 38.48367], [-121.17769, 38.48322], [-121.1774, 38.48282], [-121.17692, 38.48233], [-121.17676, 38.48229], [-121.17665, 38.4824], [-121.17654, 38.48285], [-121.17645, 38.48293], [-121.17635, 38.4829], [-121.17613, 38.48274], [-121.17599, 38.48253], [-121.17581, 38.48233], [-121.17552, 38.48218], [-121.17543, 38.48206], [-121.17538, 38.48181], [-121.17528, 38.48159], [-121.17534, 38.48144], [-121.17562, 38.48154], [-121.17575, 38.4815], [-121.17586, 38.4815], [-121.17602, 38.48147], [-121.17606, 38.48133], [-121.1764, 38.48101], [-121.17652, 38.48078], [-121.17658, 38.48057], [-121.17699, 38.48017], [-121.17716, 38.47992], [-121.17721, 38.47974], [-121.17708, 38.47969], [-121.17694, 38.47958], [-121.1769, 38.47949], [-121.17689, 38.47938], [-121.17685, 38.47928], [-121.17671, 38.4792], [-121.17666, 38.47914], [-121.17662, 38.47906], [-121.17661, 38.47899], [-121.17662, 38.47891], [-121.17666, 38.47882], [-121.17673, 38.47874], [-121.17688, 38.47867], [-121.17704, 38.47866], [-121.17717, 38.4787], [-121.17727, 38.47877], [-121.1774, 38.47883], [-121.17747, 38.4789], [-121.17752, 38.47901], [-121.17769, 38.47923], [-121.17773, 38.47937], [-121.17772, 38.47949], [-121.17809, 38.47959], [-121.17837, 38.47932], [-121.17837, 38.47916], [-121.17828, 38.479], [-121.17802, 38.47876], [-121.1773, 38.47844], [-121.1772, 38.47833], [-121.17719, 38.47824], [-121.17704, 38.47828], [-121.1768, 38.47827], [-121.17663, 38.47821], [-121.1765, 38.47812], [-121.17641, 38.47801], [-121.17635, 38.47791], [-121.17632, 38.47778], [-121.17632, 38.47771], [-121.17635, 38.47764], [-121.17648, 38.47752], [-121.17741, 38.47806], [-121.17733, 38.47817], [-121.1774, 38.47817], [-121.17763, 38.47827], [-121.18136, 38.48039]]]]} | Restricted Access 2 | 22235 | Silva Et Al | 25480 | 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 | 41.21 | Silva Et Al | None 1011 | |||
11418 | 11418 | 11417 | {"type": "Polygon", "coordinates": [[[-121.20133, 38.43685], [-121.20134, 38.43694], [-121.20132, 38.43704], [-121.20014, 38.43829], [-121.20013, 38.4383], [-121.20006, 38.4383], [-121.20003, 38.43827], [-121.20001, 38.43824], [-121.20036, 38.4379], [-121.20048, 38.43773], [-121.20071, 38.43749], [-121.20119, 38.43684], [-121.20129, 38.43682], [-121.20133, 38.43685]]]} | Restricted Access 2 | 22230 | John H Friend | 20444 | 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 | 0.684 | John H Friend | None 1010 | |||
11410 | 11410 | 11409 | {"type": "Polygon", "coordinates": [[[-121.45132, 38.38301], [-121.45064, 38.38333], [-121.45063, 38.38332], [-121.45032, 38.38293], [-121.44997, 38.38258], [-121.44967, 38.38233], [-121.44924, 38.38204], [-121.44983, 38.3814], [-121.45112, 38.3813], [-121.45132, 38.38301]]]} | Restricted Access 2 | 22247 | Kenneth Way Drainage | 20610 | 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 | 6.273 | Kenneth Way Drainage | None 1008 | |||
11376 | 11376 | 11375 | {"type": "Polygon", "coordinates": [[[-121.39798, 38.71663], [-121.39679, 38.71662], [-121.39676, 38.71656], [-121.39668, 38.71625], [-121.39666, 38.71594], [-121.39669, 38.71563], [-121.39678, 38.71532], [-121.39678, 38.71519], [-121.39741, 38.71519], [-121.39736, 38.71531], [-121.39736, 38.71543], [-121.39743, 38.71553], [-121.39768, 38.71574], [-121.39785, 38.71583], [-121.39795, 38.71602], [-121.39798, 38.71663]]]} | Restricted Access 2 | 22186 | Atreule Et Al Community Plan | 15676 | 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 | 3.539 | Atreule Et Al Community Plan | None 1000 | |||
11202 | 11202 | 11201 | {"type": "Polygon", "coordinates": [[[-121.48774, 38.4088], [-121.48772, 38.40888], [-121.48765, 38.40901], [-121.48756, 38.4091], [-121.48745, 38.40917], [-121.48727, 38.40925], [-121.48678, 38.40939], [-121.48637, 38.40956], [-121.48599, 38.40978], [-121.48562, 38.41006], [-121.48533, 38.41036], [-121.48511, 38.41068], [-121.48492, 38.41107], [-121.48483, 38.4114], [-121.48435, 38.4089], [-121.48598, 38.40887], [-121.48656, 38.40882], [-121.48774, 38.4088]]]} | Restricted Access 2 | 21496 | Stone Lakes | 25873 | 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 | 7.901 | Stone Lakes | None 977 | |||
11194 | 11194 | 11193 | {"type": "Polygon", "coordinates": [[[-121.35327, 38.45636], [-121.35322, 38.45992], [-121.35131, 38.45992], [-121.3513, 38.45977], [-121.35097, 38.45977], [-121.35102, 38.45972], [-121.35104, 38.45966], [-121.35101, 38.45955], [-121.35101, 38.45909], [-121.35105, 38.45881], [-121.35101, 38.45853], [-121.35101, 38.45828], [-121.35103, 38.45815], [-121.35115, 38.45772], [-121.35118, 38.45754], [-121.35122, 38.45751], [-121.35151, 38.45747], [-121.35171, 38.4574], [-121.3519, 38.45729], [-121.35207, 38.45714], [-121.35219, 38.45698], [-121.35227, 38.45677], [-121.35228, 38.45663], [-121.35226, 38.45636], [-121.35327, 38.45636]]]} | Restricted Access 2 | 21470 | D R Horton Inc Sacramento | 17889 | 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 | 15.774 | D R Horton Inc Sacramento | None 976 | |||
11174 | 11174 | 11173 | {"type": "Polygon", "coordinates": [[[-121.20529, 38.35592], [-121.20528, 38.35682], [-121.20307, 38.35681], [-121.20308, 38.3559], [-121.20529, 38.35592]]]} | Restricted Access 2 | 22245 | Terry Parker Et Al | 26269 | 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 | 4.819 | Terry Parker Et Al | None 975 | |||
11141 | 11141 | 11140 | {"type": "Polygon", "coordinates": [[[-121.2683, 38.7177], [-121.26769, 38.71781], [-121.26746, 38.71783], [-121.26736, 38.71789], [-121.26714, 38.71792], [-121.26714, 38.71772], [-121.26729, 38.71769], [-121.26752, 38.71753], [-121.2683, 38.71752], [-121.2683, 38.7177]]]} | Restricted Access 2 | 21443 | Nevinshire | 22705 | 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 | 0.662 | Nevinshire | None 973 | |||
11134 | 11134 | 11133 | {"type": "MultiPolygon", "coordinates": [[[[-121.35455, 38.51709], [-121.3545, 38.51715], [-121.35442, 38.51718], [-121.35373, 38.5172], [-121.35298, 38.51727], [-121.35225, 38.5174], [-121.35179, 38.51751], [-121.3517, 38.51748], [-121.35166, 38.51743], [-121.35166, 38.51736], [-121.35171, 38.51731], [-121.35187, 38.51726], [-121.35204, 38.51726], [-121.35228, 38.51719], [-121.35251, 38.5171], [-121.35272, 38.51697], [-121.35284, 38.51691], [-121.35299, 38.5169], [-121.35312, 38.51694], [-121.35328, 38.517], [-121.35345, 38.51702], [-121.35362, 38.51698], [-121.35365, 38.51696], [-121.35399, 38.51694], [-121.35409, 38.51692], [-121.35441, 38.51693], [-121.3545, 38.51696], [-121.35455, 38.51702], [-121.35455, 38.51709]]], [[[-121.35432, 38.51553], [-121.35427, 38.5156], [-121.3541, 38.51566], [-121.35309, 38.51629], [-121.35292, 38.51649], [-121.35269, 38.51664], [-121.3522, 38.51683], [-121.35209, 38.51683], [-121.35195, 38.51683], [-121.35186, 38.51678], [-121.35182, 38.5167], [-121.35182, 38.51662], [-121.35187, 38.51655], [-121.35249, 38.51617], [-121.35256, 38.51606], [-121.35255, 38.51596], [-121.35248, 38.51586], [-121.35236, 38.5158], [-121.35222, 38.51579], [-121.35213, 38.51583], [-121.35197, 38.51584], [-121.35189, 38.51584], [-121.35181, 38.5158], [-121.35177, 38.51574], [-121.35178, 38.51566], [-121.35183, 38.5156], [-121.35279, 38.51544], [-121.35358, 38.51537], [-121.35418, 38.51535], [-121.35427, 38.51538], [-121.35432, 38.51545], [-121.35432, 38.51553]]], [[[-121.35456, 38.51613], [-121.35451, 38.51619], [-121.35443, 38.51622], [-121.35412, 38.51626], [-121.35381, 38.51634], [-121.35353, 38.51646], [-121.3535, 38.51646], [-121.35367, 38.51628], [-121.35388, 38.51614], [-121.35413, 38.51605], [-121.3544, 38.51601], [-121.35449, 38.51602], [-121.35455, 38.51607], [-121.35456, 38.51613]]], [[[-121.35835, 38.5161], [-121.35832, 38.51617], [-121.35824, 38.51623], [-121.35814, 38.51625], [-121.35804, 38.51623], [-121.35786, 38.51611], [-121.35774, 38.51607], [-121.35751, 38.51606], [-121.35743, 38.5161], [-121.35739, 38.51617], [-121.35749, 38.51636], [-121.35747, 38.51643], [-121.3574, 38.51646], [-121.35734, 38.51646], [-121.35719, 38.51634], [-121.35708, 38.51618], [-121.3567, 38.51597], [-121.35641, 38.51587], [-121.35611, 38.5158], [-121.35601, 38.51579], [-121.35592, 38.51574], [-121.35587, 38.51567], [-121.35588, 38.51558], [-121.35594, 38.51551], [-121.35603, 38.51547], [-121.35614, 38.51548], [-121.35672, 38.51557], [-121.35748, 38.51574], [-121.3582, 38.51595], [-121.35828, 38.51601], [-121.35835, 38.5161]]], [[[-121.35658, 38.51631], [-121.35641, 38.51634], [-121.35628, 38.51633], [-121.35605, 38.51625], [-121.35599, 38.51617], [-121.35599, 38.51608], [-121.35617, 38.51607], [-121.35634, 38.5161], [-121.35649, 38.51619], [-121.35658, 38.51631]]], [[[-121.35831, 38.51766], [-121.35829, 38.51774], [-121.35821, 38.5178], [-121.35813, 38.5178], [-121.35742, 38.51758], [-121.3567, 38.5174], [-121.35624, 38.51732], [-121.35615, 38.51727], [-121.35611, 38.51719], [-121.35613, 38.51711], [-121.35621, 38.51705], [-121.35632, 38.51704], [-121.35648, 38.51708], [-121.35658, 38.51714], [-121.35674, 38.5172], [-121.35709, 38.51725], [-121.35718, 38.51723], [-121.35723, 38.51718], [-121.35723, 38.5171], [-121.35688, 38.51665], [-121.35686, 38.51659], [-121.35686, 38.51657], [-121.35689, 38.51655], [-121.35702, 38.51655], [-121.35718, 38.51665], [-121.35723, 38.51679], [-121.35737, 38.51698], [-121.35747, 38.51717], [-121.35798, 38.51748], [-121.35826, 38.51759], [-121.35831, 38.51766]]]]} | Restricted Access 2 | 21428 | Morrison Creek Mining | 22496 | 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 | 10.801 | Morrison Creek Mining | None 972 | |||
7368 | 7368 | 7367 | {"type": "Polygon", "coordinates": [[[-118.05801, 33.90814], [-118.05748, 33.90772], [-118.0555, 33.90773], [-118.05549, 33.906], [-118.05799, 33.90598], [-118.05801, 33.90814]]]} | Restricted Access 2 | 6773 | Don Knabe Golf Center and Junior Academy | 32519 | 1225 | Norwalk, City of 239 | City 2 | City Agency 2 | http://www.ci.norwalk.ca.us/city-hall/departments/recreation-park-services | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | https://www.playknabegolf.com/ | Los Angeles 6 | 11.277 | Don Knabe Golf Ctr. and Junior Academy | None 610 | ||
3224 | 3224 | 3223 | {"type": "Polygon", "coordinates": [[[-121.45044, 38.37471], [-121.44978, 38.3747], [-121.44966, 38.37342], [-121.45028, 38.37338], [-121.45044, 38.37471]]]} | Restricted Access 2 | 22246 | Hood-Franklin Drainage | 20071 | 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 | 2.025 | Hood-Franklin Drainage | None 266 | |||
3118 | 3118 | 3117 | {"type": "Polygon", "coordinates": [[[-121.45011, 38.40646], [-121.45004, 38.40688], [-121.4499, 38.40688], [-121.44976, 38.40685], [-121.44963, 38.40679], [-121.44953, 38.40671], [-121.44945, 38.40661], [-121.44942, 38.40654], [-121.44941, 38.40643], [-121.44944, 38.40612], [-121.44612, 38.40611], [-121.44612, 38.40534], [-121.44083, 38.40532], [-121.44083, 38.405], [-121.44983, 38.40499], [-121.44995, 38.40507], [-121.45002, 38.40514], [-121.4501, 38.40525], [-121.45014, 38.40538], [-121.45014, 38.40551], [-121.45, 38.40639], [-121.45004, 38.40645], [-121.45011, 38.40646]]]} | Restricted Access 2 | 21488 | Laguna Lake Drainage | 20858 | 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 | 15.913 | Laguna Lake Drainage | None 255 | |||
2877 | 2877 | 2876 | {"type": "Polygon", "coordinates": [[[-121.2872, 38.42303], [-121.28685, 38.42315], [-121.28643, 38.42337], [-121.28619, 38.42353], [-121.2858, 38.42385], [-121.28542, 38.42359], [-121.28471, 38.42421], [-121.28261, 38.42406], [-121.28154, 38.42496], [-121.28143, 38.42489], [-121.28175, 38.42462], [-121.28187, 38.42447], [-121.28205, 38.42431], [-121.28253, 38.42403], [-121.28272, 38.42397], [-121.28303, 38.42393], [-121.28323, 38.42385], [-121.28393, 38.42367], [-121.28429, 38.4236], [-121.28452, 38.42349], [-121.28487, 38.42338], [-121.28505, 38.42325], [-121.28543, 38.42302], [-121.286, 38.42263], [-121.28628, 38.42252], [-121.28663, 38.42231], [-121.2872, 38.42303]]]} | Restricted Access 2 | 22244 | Preston Hanford | 23996 | 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 | 6.909 | Preston Hanford | None 241 | |||
6056 | 6056 | 6055 | {"type": "Polygon", "coordinates": [[[-118.65875, 34.07333], [-118.65821, 34.07334], [-118.6582, 34.07327], [-118.65765, 34.07327], [-118.65765, 34.07272], [-118.65786, 34.07272], [-118.65786, 34.0725], [-118.65875, 34.07256], [-118.65875, 34.07333]]]} | Restricted Access 2 | 12780 | Santa Monica Mountains National Recreation Area | 29657 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://www.nps.gov/samo/index.htm | Los Angeles 6 | 2.045 | Santa Monica Mtns. NRA | 0 | National Recreation Area 54 | 3 |
4679 | 4679 | 4678 | {"type": "Polygon", "coordinates": [[[-121.3533, 38.45594], [-121.35327, 38.45595], [-121.35327, 38.45636], [-121.35226, 38.45636], [-121.35227, 38.45624], [-121.3523, 38.45613], [-121.35236, 38.456], [-121.35243, 38.45591], [-121.35251, 38.45582], [-121.35281, 38.45567], [-121.35311, 38.4556], [-121.35318, 38.45561], [-121.35321, 38.45564], [-121.3533, 38.45594]]]} | Restricted Access 2 | 43001 | Unnamed site - Sacramento, County of | 28659 | 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 | 1.452 | 0 | Local Other or Unknown 14 | 4 | ||
4694 | 4694 | 4693 | {"type": "Polygon", "coordinates": [[[-117.90308, 34.64234], [-117.90298, 34.64592], [-117.89442, 34.64592], [-117.89406, 34.64594], [-117.89415, 34.64234], [-117.89864, 34.64232], [-117.90308, 34.64234]]]} | Restricted Access 2 | 45942 | Unnamed site - Los Angeles, County of | 29046 | 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 | Los Angeles 6 | 80.519 | 0 | Local Other or Unknown 14 | 4 | ||
4758 | 4758 | 4757 | {"type": "Polygon", "coordinates": [[[-123.96182, 40.47601], [-123.96157, 40.47625], [-123.96067, 40.47662], [-123.95893, 40.478], [-123.95764, 40.47896], [-123.95666, 40.48], [-123.95668, 40.4767], [-123.95728, 40.4765], [-123.95804, 40.47633], [-123.9587, 40.47616], [-123.95966, 40.47599], [-123.96182, 40.47601]]]} | Restricted Access 2 | 46661 | Unnamed site - Humboldt, County of | 29996 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | Humboldt 45 | 19.487 | 0 | Local Other or Unknown 14 | 4 | ||
11138 | 11138 | 11137 | {"type": "Polygon", "coordinates": [[[-121.29786, 38.49822], [-121.29733, 38.49802], [-121.2969, 38.49796], [-121.29661, 38.49799], [-121.29634, 38.49832], [-121.29629, 38.49874], [-121.29647, 38.49922], [-121.29644, 38.49953], [-121.29651, 38.49982], [-121.29676, 38.49992], [-121.29701, 38.49988], [-121.29784, 38.49901], [-121.29783, 38.50332], [-121.29735, 38.50321], [-121.29714, 38.50313], [-121.29689, 38.50305], [-121.29688, 38.50306], [-121.29691, 38.50315], [-121.29703, 38.50326], [-121.29748, 38.50354], [-121.29428, 38.50352], [-121.29385, 38.50329], [-121.29323, 38.50315], [-121.29275, 38.50326], [-121.29239, 38.50351], [-121.28867, 38.50348], [-121.28869, 38.50214], [-121.2923, 38.50215], [-121.29546, 38.49847], [-121.29544, 38.49627], [-121.29762, 38.49629], [-121.29774, 38.49637], [-121.29785, 38.49753], [-121.29786, 38.49822]], [[-121.29624, 38.50255], [-121.29625, 38.50254], [-121.29618, 38.50232], [-121.29606, 38.50211], [-121.29588, 38.50192], [-121.29566, 38.50176], [-121.29541, 38.50164], [-121.29512, 38.50157], [-121.29483, 38.50154], [-121.29453, 38.50156], [-121.29425, 38.50162], [-121.29398, 38.50173], [-121.29374, 38.50176], [-121.29351, 38.50182], [-121.2933, 38.50192], [-121.29313, 38.50205], [-121.293, 38.50219], [-121.29301, 38.5022], [-121.29326, 38.50215], [-121.29354, 38.50213], [-121.29382, 38.50215], [-121.29409, 38.50221], [-121.29464, 38.50225], [-121.29519, 38.50231], [-121.29572, 38.50242], [-121.29624, 38.50255]]]} | Restricted Access 2 | 21429 | Arroyo Seco (florin Mitigation Bank) | 15628 | 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 | 66.229 | Arroyo Seco (florin Mitigation Bank) | 0 | Local Other or Unknown 14 | 4 | |
11411 | 11411 | 11410 | {"type": "Polygon", "coordinates": [[[-121.44882, 38.38398], [-121.44574, 38.38469], [-121.44561, 38.38473], [-121.44549, 38.38479], [-121.44535, 38.38492], [-121.44535, 38.38427], [-121.44879, 38.38348], [-121.44879, 38.38397], [-121.44882, 38.38398]]]} | Restricted Access 2 | 22248 | Lotus Pond Drainage | 21545 | 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 | 4.291 | Lotus Pond Drainage | 0 | Local Other or Unknown 14 | 4 | |
11416 | 11416 | 11415 | {"type": "MultiPolygon", "coordinates": [[[[-121.21771, 38.43508], [-121.21767, 38.43514], [-121.21731, 38.43503], [-121.21701, 38.43503], [-121.21678, 38.43513], [-121.21658, 38.43516], [-121.21642, 38.43515], [-121.21609, 38.43504], [-121.21579, 38.43498], [-121.21541, 38.43495], [-121.21521, 38.43491], [-121.21521, 38.43479], [-121.2153, 38.43448], [-121.21529, 38.43433], [-121.2152, 38.43412], [-121.21522, 38.43402], [-121.2154, 38.43378], [-121.21556, 38.43335], [-121.21562, 38.43316], [-121.21558, 38.433], [-121.21538, 38.43274], [-121.21497, 38.43244], [-121.2147, 38.4323], [-121.21424, 38.43218], [-121.21361, 38.43208], [-121.21335, 38.43213], [-121.21298, 38.43228], [-121.21241, 38.43242], [-121.21216, 38.43255], [-121.21175, 38.43286], [-121.21165, 38.43299], [-121.21163, 38.4332], [-121.21162, 38.43355], [-121.21155, 38.43361], [-121.21145, 38.4336], [-121.21134, 38.43357], [-121.21111, 38.43335], [-121.21093, 38.43326], [-121.21068, 38.43323], [-121.21074, 38.43315], [-121.21279, 38.43099], [-121.2167, 38.43328], [-121.21655, 38.43334], [-121.21649, 38.43335], [-121.2163, 38.43348], [-121.21623, 38.43364], [-121.21624, 38.43385], [-121.21637, 38.43403], [-121.21673, 38.43437], [-121.21706, 38.43464], [-121.21766, 38.43499], [-121.21771, 38.43508]]], [[[-121.22965, 38.44085], [-121.22946, 38.44104], [-121.22924, 38.44124], [-121.22905, 38.44133], [-121.2284, 38.4414], [-121.22792, 38.44165], [-121.22743, 38.44203], [-121.22713, 38.44222], [-121.22653, 38.44252], [-121.22623, 38.44284], [-121.226, 38.443], [-121.22581, 38.44318], [-121.22536, 38.44373], [-121.22511, 38.44393], [-121.22441, 38.44463], [-121.22389, 38.44499], [-121.22347, 38.44513], [-121.22277, 38.44533], [-121.22211, 38.44582], [-121.22187, 38.44601], [-121.22168, 38.4462], [-121.22097, 38.44668], [-121.22032, 38.44693], [-121.21922, 38.44722], [-121.21851, 38.44722], [-121.21769, 38.44713], [-121.21696, 38.447], [-121.21555, 38.44658], [-121.21532, 38.44655], [-121.21717, 38.44459], [-121.21532, 38.4435], [-121.21808, 38.44059], [-121.21514, 38.43887], [-121.2152, 38.43879], [-121.21524, 38.43868], [-121.21537, 38.43863], [-121.2156, 38.43866], [-121.21601, 38.43877], [-121.21619, 38.4388], [-121.21635, 38.43874], [-121.21674, 38.43846], [-121.2169, 38.43837], [-121.21706, 38.43839], [-121.21718, 38.43847], [-121.21725, 38.43882], [-121.21726, 38.43969], [-121.2173, 38.43983], [-121.21742, 38.43991], [-121.2176, 38.43996], [-121.21794, 38.43998], [-121.21845, 38.44009], [-121.21868, 38.44008], [-121.21886, 38.43998], [-121.21899, 38.43996], [-121.21917, 38.44006], [-121.21933, 38.44013], [-121.21959, 38.44017], [-121.21986, 38.44018], [-121.21998, 38.44033], [-121.21998, 38.44046], [-121.21989, 38.44088], [-121.2199, 38.44104], [-121.21996, 38.44117], [-121.22011, 38.44136], [-121.22013, 38.44145], [-121.22008, 38.44158], [-121.22009, 38.44168], [-121.22019, 38.44185], [-121.22041, 38.44203], [-121.22087, 38.44236], [-121.22103, 38.44243], [-121.2212, 38.44241], [-121.22138, 38.44231], [-121.22142, 38.44216], [-121.22142, 38.442], [-121.22139, 38.44196], [-121.22139, 38.44201], [-121.22138, 38.44206], [-121.22133, 38.44208], [-121.22124, 38.44202], [-121.22115, 38.44202], [-121.22114, 38.44194], [-121.22118, 38.44188], [-121.22124, 38.44183], [-121.2213, 38.44186], [-121.22137, 38.44194], [-121.22139, 38.44193], [-121.22125, 38.44166], [-121.22108, 38.44122], [-121.22086, 38.44092], [-121.22063, 38.44071], [-121.22042, 38.44048], [-121.22025, 38.44006], [-121.21964, 38.43942], [-121.21954, 38.43924], [-121.21951, 38.43898], [-121.21963, 38.43889], [-121.21975, 38.43889], [-121.21991, 38.43898], [-121.22013, 38.43921], [-121.22054, 38.43948], [-121.22075, 38.43968], [-121.22107, 38.44003], [-121.22131, 38.44023], [-121.2215, 38.44033], [-121.22166, 38.44034], [-121.22211, 38.44031], [-121.22236, 38.44034], [-121.22272, 38.44034], [-121.22306, 38.4403], [-121.22328, 38.44022], [-121.22356, 38.44006], [-121.2241, 38.43986], [-121.22413, 38.43978], [-121.22409, 38.4397], [-121.224, 38.43964], [-121.22367, 38.43955], [-121.22339, 38.43955], [-121.22304, 38.43959], [-121.22272, 38.4396], [-121.22234, 38.43955], [-121.22181, 38.43943], [-121.22165, 38.43931], [-121.22141, 38.43903], [-121.22119, 38.43864], [-121.22098, 38.43849], [-121.22077, 38.43842], [-121.22022, 38.43828], [-121.22, 38.43813], [-121.21952, 38.43768], [-121.21906, 38.43738], [-121.21873, 38.43708], [-121.21861, 38.43684], [-121.21863, 38.43653], [-121.21878, 38.43618], [-121.21908, 38.43587], [-121.21941, 38.43558], [-121.21998, 38.4353], [-121.22005, 38.43525], [-121.22004, 38.43523], [-121.22007, 38.43523], [-121.22007, 38.43525], [-121.22965, 38.44085]]]]} | Restricted Access 2 | 22225 | Nelson Family Ranch | 22696 | 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 | 208.842 | Nelson Family Ranch | 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]);