superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
21 rows where ACCESS_TYP = 2, AGNCY_WEB = "http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx" and MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
| Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1229 | 1229 | 1228 | {"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.49981], [-121.29676, 38.49992], [-121.29701, 38.49988], [-121.29784, 38.49901], [-121.29783, 38.50332], [-121.29735, 38.50321], [-121.29689, 38.50305], [-121.29688, 38.50306], [-121.29691, 38.50315], [-121.29703, 38.50325], [-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.29623, 38.50255], [-121.29625, 38.50253], [-121.29618, 38.50232], [-121.29606, 38.50211], [-121.29589, 38.50192], [-121.29566, 38.50176], [-121.2954, 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.29301, 38.50218], [-121.29302, 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.29623, 38.50255]]]} | Restricted Access 2 | Arroyo Seco (florin Mitigation Bank) | 15628 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 66.257 | Arroyo Seco (florin Mitigation Bank) | ||
| 1651 | 1651 | 1650 | {"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.71542], [-121.39743, 38.71553], [-121.39768, 38.71574], [-121.39785, 38.71583], [-121.39795, 38.71602], [-121.39798, 38.71663]]]} | Restricted Access 2 | Atreule Et Al Community Plan | 15676 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 3.539 | Atreule Et Al Community Plan | ||
| 3217 | 3217 | 3216 | {"type": "MultiPolygon", "coordinates": [[[[-121.09148, 38.49227], [-121.09125, 38.49243], [-121.09091, 38.49263], [-121.09073, 38.49271], [-121.09048, 38.49267], [-121.09013, 38.49268], [-121.0895, 38.49277], [-121.08916, 38.49278], [-121.08856, 38.49271], [-121.08839, 38.49288], [-121.08806, 38.49299], [-121.08776, 38.49324], [-121.08758, 38.49346], [-121.08736, 38.49369], [-121.08706, 38.49389], [-121.08685, 38.49411], [-121.08668, 38.49447], [-121.08635, 38.49468], [-121.08587, 38.4948], [-121.08548, 38.49497], [-121.08494, 38.49507], [-121.08444, 38.49513], [-121.08401, 38.49522], [-121.08368, 38.4954], [-121.08321, 38.49533], [-121.08263, 38.4952], [-121.08218, 38.49516], [-121.08186, 38.49517], [-121.08155, 38.49514], [-121.08119, 38.49514], [-121.08085, 38.49518], [-121.08048, 38.49518], [-121.07954, 38.49521], [-121.07918, 38.4953], [-121.07885, 38.49527], [-121.07803, 38.49512], [-121.07721, 38.49518], [-121.07672, 38.49507], [-121.07642, 38.49489], [-121.07601, 38.49485], [-121.07561, 38.49479], [-121.07507, 38.49468], [-121.0745, 38.49467], [-121.07387, 38.49457], [-121.07313, 38.4944], [-121.07188, 38.49433], [-121.07136, 38.49445], [-121.07091, 38.49468], [-121.07057, 38.49491], [-121.07008, 38.49571], [-121.06978, 38.49606], [-121.06879, 38.4965], [-121.0684, 38.49662], [-121.06787, 38.4969], [-121.06772, 38.49747], [-121.06745, 38.49789], [-121.06741, 38.4964], [-121.0678, 38.49625], [-121.06829, 38.49619], [-121.0692, 38.4956], [-121.06938, 38.4953], [-121.06934, 38.49511], [-121.06944, 38.49477], [-121.06956, 38.4945], [-121.07004, 38.4941], [-121.07124, 38.49356], [-121.07312, 38.49317], [-121.07514, 38.49348], [-121.07693, 38.49402], [-121.08244, 38.49408], [-121.08246, 38.49418], [-121.08279, 38.49418], [-121.08281, 38.49409], [-121.083, 38.49409], [-121.08466, 38.49399], [-121.08601, 38.4936], [-121.08706, 38.49299], [-121.08714, 38.49306], [-121.08756, 38.49279], [-121.08806, 38.49236], [-121.08926, 38.49218], [-121.0898, 38.49205], [-121.09063, 38.49184], [-121.09106, 38.49171], [-121.09128, 38.49189], [-121.09128, 38.49191], [-121.09133, 38.49195], [-121.09148, 38.49227]]], [[[-121.11462, 38.48233], [-121.11316, 38.48204], [-121.10939, 38.48209], [-121.10861, 38.48241], [-121.10763, 38.483], [-121.10532, 38.48394], [-121.10435, 38.48511], [-121.10083, 38.48719], [-121.10067, 38.48782], [-121.09652, 38.49026], [-121.09674, 38.49053], [-121.09379, 38.49339], [-121.09281, 38.49263], [-121.09319, 38.49205], [-121.09333, 38.49171], [-121.09343, 38.49155], [-121.09393, 38.48993], [-121.09485, 38.48922], [-121.09593, 38.48921], [-121.09595, 38.48641], [-121.09858, 38.48505], [-121.09983, 38.48505], [-121.09985, 38.48438], [-121.10456, 38.4818], [-121.11192, 38.48073], [-121.1122, 38.4807], [-121.1146, 38.48154], [-121.11462, 38.48233]]]]} | Restricted Access 2 | Cosumnes River Parkway | 17677 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 188.715 | Cosumnes River Parkway | ||
| 3219 | 3219 | 3218 | {"type": "MultiPolygon", "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]]], [[[-121.37929, 38.26206], [-121.37925, 38.26667], [-121.36993, 38.26662], [-121.36997, 38.26204], [-121.37929, 38.26206]]], [[[-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.50313, 38.25794], [-121.50676, 38.25202], [-121.50862, 38.25131], [-121.50878, 38.25131], [-121.50893, 38.25149], [-121.50982, 38.25136], [-121.51029, 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.25741], [-121.51648, 38.25796], [-121.51562, 38.25855], [-121.51691, 38.25947]]]]} | Restricted Access 2 | Cosumnes River Preserve | 17679 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 617.926 | Cosumnes River Preserve | ||
| 3401 | 3401 | 3400 | {"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 | D R Horton Inc Sacramento | 17889 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 15.775 | D R Horton Inc Sacramento | ||
| 5232 | 5232 | 5231 | {"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 | Hood-Franklin Drainage | 20071 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 2.024 | Hood-Franklin Drainage | ||
| 5558 | 5558 | 5557 | {"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.43683], [-121.20133, 38.43685]]]} | Restricted Access 2 | John H Friend | 20444 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 0.684 | John H Friend | ||
| 5709 | 5709 | 5708 | {"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 | Kenneth Way Drainage | 20610 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 6.272 | Kenneth Way Drainage | ||
| 5882 | 5882 | 5881 | {"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.44943, 38.40612], [-121.44612, 38.40611], [-121.44611, 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 | Laguna Lake Drainage | 20858 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 15.925 | Laguna Lake Drainage | ||
| 6427 | 6427 | 6426 | {"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 | Lotus Pond Drainage | 21545 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 4.29 | Lotus Pond Drainage | ||
| 7218 | 7218 | 7217 | {"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.35409, 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.51595], [-121.35249, 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.35411, 38.51626], [-121.35382, 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.3574, 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.51617], [-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.35642, 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.51717], [-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 | Morrison Creek Mining | 22496 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 10.802 | Morrison Creek Mining | ||
| 7336 | 7336 | 7335 | {"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.21641, 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.43403], [-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.43285], [-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.43349], [-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.44141], [-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.21716, 38.4446], [-121.21532, 38.4435], [-121.21807, 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.21741, 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.21916, 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.22104, 38.44243], [-121.2212, 38.44241], [-121.22138, 38.44231], [-121.22142, 38.44216], [-121.22142, 38.442], [-121.2214, 38.44198], [-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.44193], [-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.22271, 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.22399, 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.21997, 38.4353], [-121.22004, 38.43525], [-121.22004, 38.43523], [-121.22007, 38.43523], [-121.22008, 38.43525], [-121.22965, 38.44085]]]]} | Restricted Access 2 | Nelson Family Ranch | 22696 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 208.905 | Nelson Family Ranch | ||
| 7342 | 7342 | 7341 | {"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 | Nevinshire | 22705 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 0.662 | Nevinshire | ||
| 8404 | 8404 | 8403 | {"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.4236], [-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 | Preston Hanford | 23996 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 6.915 | Preston Hanford | ||
| 9667 | 9667 | 9666 | {"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.48366], [-121.17768, 38.48322], [-121.1774, 38.48282], [-121.17692, 38.48233], [-121.17676, 38.4823], [-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.48182], [-121.17528, 38.48159], [-121.17534, 38.48144], [-121.17562, 38.48154], [-121.17575, 38.4815], [-121.17586, 38.4815], [-121.17601, 38.48146], [-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.47901], [-121.17802, 38.47876], [-121.1773, 38.47844], [-121.1772, 38.47833], [-121.17718, 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.47792], [-121.17632, 38.47778], [-121.17632, 38.47771], [-121.17635, 38.47764], [-121.17648, 38.47752], [-121.17741, 38.47806], [-121.17735, 38.47817], [-121.1774, 38.47817], [-121.17763, 38.47827], [-121.18136, 38.48039]]]]} | Restricted Access 2 | Silva Et Al | 25480 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 41.219 | Silva Et Al | ||
| 9987 | 9987 | 9986 | {"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.48534, 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 | Stone Lakes | 25873 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 7.901 | Stone Lakes | ||
| 10113 | 10113 | 10112 | {"type": "MultiPolygon", "coordinates": [[[[-121.24893, 38.67172], [-121.2489, 38.67173], [-121.24889, 38.67164], [-121.24884, 38.67156], [-121.2486, 38.67133], [-121.24893, 38.67133], [-121.24893, 38.67172]]], [[[-121.25125, 38.67334], [-121.25049, 38.67337], [-121.25043, 38.67336], [-121.24934, 38.67255], [-121.24894, 38.67232], [-121.24893, 38.67184], [-121.24905, 38.67183], [-121.24903, 38.67201], [-121.24906, 38.67206], [-121.24937, 38.67222], [-121.24962, 38.67238], [-121.25057, 38.67308], [-121.25063, 38.67309], [-121.25112, 38.67306], [-121.25117, 38.67304], [-121.25125, 38.67298], [-121.25125, 38.67334]]]]} | Restricted Access 2 | Sunrise Recreation/parks District | 26038 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 2.065 | Sunrise Rec./parks District | ||
| 10296 | 10296 | 10295 | {"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 | Terry Parker Et Al | 26269 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 4.818 | Terry Parker Et Al | ||
| 10790 | 10790 | 10789 | {"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 | Vernal Pool Prairie Preserve Area | 27000 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316.995 | Vernal Pool Prairie Preserve Area | ||
| 14273 | 14273 | 14272 | {"type": "Polygon", "coordinates": [[[-121.3533, 38.45594], [-121.35327, 38.45596], [-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 | Unnamed site - Sacramento, County of | 28659 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 1.452 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps(
id INT,
map,
ACCESS_TYP INT,
PARK_NAME TEXT,
PARK_URL TEXT,
SUID_NMA INT,
MNG_AG_ID INT,
MNG_AGENCY INT,
MNG_AG_LEV INT,
MNG_AG_TYP INT,
AGNCY_WEB TEXT,
LAYER INT,
ACRES REAL,
LABEL_NAME TEXT,
YR_EST INT,
FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
ON [superunits_with_maps] ([ACCESS_TYP]);