units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
92 rows where DES_TP = 2 and MNG_AGENCY = 559 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER
MNG_AG_TYP 1
MNG_AGENCY 1
- Consumnes Community Services District · 92 ✖
DES_TP 1
- Local Park · 92 ✖
ACCESS_TYP 1
- Open Access 92
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14484 | 14484 | 14483 | {"type": "Polygon", "coordinates": [[[-121.34161, 38.40181], [-121.34162, 38.40199], [-121.34165, 38.40214], [-121.34162, 38.40219], [-121.34122, 38.40229], [-121.34088, 38.40239], [-121.34038, 38.40259], [-121.34008, 38.40276], [-121.33979, 38.40294], [-121.33953, 38.40315], [-121.33926, 38.40339], [-121.33919, 38.40339], [-121.33885, 38.40322], [-121.33865, 38.40314], [-121.33833, 38.40307], [-121.33811, 38.40306], [-121.33791, 38.40307], [-121.33739, 38.40315], [-121.33738, 38.40318], [-121.33718, 38.40319], [-121.33692, 38.40319], [-121.33687, 38.40317], [-121.33685, 38.40314], [-121.33686, 38.40252], [-121.33696, 38.40237], [-121.33696, 38.40234], [-121.33693, 38.40229], [-121.33703, 38.40223], [-121.33703, 38.40179], [-121.34161, 38.40181]]]} | Open Access 1 | 47139 | Derr-Okamoto Park | 30816 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/590/Derr-Okamoto-Park | Sacramento 41 | 12.378 | Derr-Okamoto Park | 0 | Local Park 2 | 4 |
14483 | 14483 | 14482 | {"type": "Polygon", "coordinates": [[[-121.38091, 38.42364], [-121.38089, 38.42712], [-121.37995, 38.42794], [-121.37993, 38.42791], [-121.37994, 38.42787], [-121.3803, 38.42755], [-121.3804, 38.42743], [-121.38049, 38.42726], [-121.38053, 38.42709], [-121.38051, 38.42689], [-121.38048, 38.42677], [-121.38042, 38.42667], [-121.38027, 38.42648], [-121.38006, 38.42633], [-121.37988, 38.42625], [-121.37968, 38.4262], [-121.37949, 38.42618], [-121.3793, 38.42618], [-121.37851, 38.42554], [-121.37825, 38.42573], [-121.37824, 38.42591], [-121.3782, 38.42596], [-121.37803, 38.42594], [-121.37783, 38.42625], [-121.37768, 38.42655], [-121.37773, 38.42659], [-121.37769, 38.42664], [-121.37769, 38.4267], [-121.37759, 38.42673], [-121.37744, 38.42733], [-121.3774, 38.42733], [-121.37733, 38.4273], [-121.37726, 38.42724], [-121.37723, 38.42717], [-121.37722, 38.4271], [-121.37764, 38.42617], [-121.37768, 38.42597], [-121.37768, 38.42575], [-121.37763, 38.42553], [-121.37751, 38.42529], [-121.37735, 38.42508], [-121.37717, 38.42493], [-121.37687, 38.42474], [-121.37671, 38.42466], [-121.37645, 38.42456], [-121.37621, 38.42452], [-121.37592, 38.42451], [-121.37563, 38.42454], [-121.37539, 38.4246], [-121.37511, 38.42472], [-121.37481, 38.42451], [-121.37455, 38.42455], [-121.37367, 38.42449], [-121.37368, 38.42362], [-121.3741, 38.42362], [-121.37519, 38.4237], [-121.37598, 38.4237], [-121.3767, 38.42365], [-121.3783, 38.42363], [-121.38091, 38.42364]]]} | Open Access 1 | 47138 | Underwood Park | 30815 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/646/Underwood-Park | Sacramento 41 | 30.458 | Underwood Park | 0 | Local Park 2 | 4 |
14482 | 14482 | 14481 | {"type": "Polygon", "coordinates": [[[-121.41372, 38.3969], [-121.413, 38.3969], [-121.41289, 38.39639], [-121.41285, 38.39595], [-121.41278, 38.39567], [-121.41277, 38.395], [-121.41268, 38.39489], [-121.41259, 38.39483], [-121.41242, 38.39477], [-121.4123, 38.39476], [-121.41288, 38.39476], [-121.41314, 38.39496], [-121.41369, 38.39496], [-121.4136, 38.39504], [-121.41353, 38.39518], [-121.41351, 38.39527], [-121.41351, 38.3956], [-121.41354, 38.39587], [-121.41372, 38.3969]]]} | Open Access 1 | 47137 | Promenade Park | 30814 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/621/Promenade-Park | Sacramento 41 | 3.631 | Promenade Park | 0 | Local Park 2 | 4 |
14481 | 14481 | 14480 | {"type": "Polygon", "coordinates": [[[-121.4142, 38.3979], [-121.41422, 38.39797], [-121.41419, 38.39807], [-121.41414, 38.39816], [-121.41406, 38.39824], [-121.41396, 38.39831], [-121.41384, 38.39835], [-121.41365, 38.39839], [-121.41344, 38.39836], [-121.41326, 38.39828], [-121.41313, 38.39816], [-121.41307, 38.39807], [-121.41304, 38.39796], [-121.41306, 38.3979], [-121.41333, 38.39793], [-121.41363, 38.39795], [-121.41394, 38.39793], [-121.4142, 38.3979]]]} | Open Access 1 | 47136 | Rose Garden Park | 30813 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/624/Rose-Garden-Park | Sacramento 41 | 0.996 | Rose Garden Park | 0 | Local Park 2 | 4 |
14479 | 14479 | 14478 | {"type": "Polygon", "coordinates": [[[-121.40288, 38.397], [-121.40292, 38.39684], [-121.40298, 38.39674], [-121.40307, 38.39665], [-121.40318, 38.39659], [-121.40331, 38.39654], [-121.40351, 38.39651], [-121.40372, 38.39654], [-121.40385, 38.39659], [-121.40396, 38.39666], [-121.40408, 38.39679], [-121.40412, 38.3969], [-121.40414, 38.39701], [-121.4041, 38.39717], [-121.40404, 38.39727], [-121.40395, 38.39736], [-121.40384, 38.39743], [-121.40371, 38.39747], [-121.40351, 38.3975], [-121.4033, 38.39747], [-121.40317, 38.39742], [-121.40306, 38.39735], [-121.40294, 38.39722], [-121.4029, 38.39711], [-121.40288, 38.397]]]} | Open Access 1 | 47134 | Island Park | 30811 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/631/Island-Park | Sacramento 41 | 2.307 | Island Park | 0 | Local Park 2 | 4 |
14474 | 14474 | 14473 | {"type": "Polygon", "coordinates": [[[-121.40937, 38.39491], [-121.40933, 38.39492], [-121.40931, 38.39494], [-121.40931, 38.39518], [-121.40915, 38.39516], [-121.40907, 38.39518], [-121.40901, 38.39524], [-121.409, 38.39531], [-121.40903, 38.39538], [-121.40903, 38.39545], [-121.40856, 38.39544], [-121.40857, 38.39481], [-121.40908, 38.39481], [-121.40937, 38.39491]]]} | Open Access 1 | 47132 | Bridgeview Park | 30809 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/595/Bridgeview-Park | Sacramento 41 | 0.925 | Bridgeview Park | 0 | Local Park 2 | 4 |
14473 | 14473 | 14472 | {"type": "Polygon", "coordinates": [[[-121.40982, 38.39728], [-121.40982, 38.39787], [-121.40853, 38.39786], [-121.40854, 38.39727], [-121.40982, 38.39728]]]} | Open Access 1 | 47131 | Storybook Woods Park | 30808 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/639/Storybook-Woods-Park | Sacramento 41 | 1.816 | Storybook Woods Park | 0 | Local Park 2 | 4 |
4122 | 4122 | 4121 | {"type": "Polygon", "coordinates": [[[-121.45166, 38.42828], [-121.45123, 38.42827], [-121.45104, 38.42799], [-121.45153, 38.428], [-121.45166, 38.42828]]]} | Open Access 1 | 47130 | Harris Ranch Park | 30807 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 0.311 | Harris Ranch Park | 0 | Local Park 2 | 4 | |
4121 | 4121 | 4120 | {"type": "Polygon", "coordinates": [[[-121.41262, 38.4028], [-121.41282, 38.40283], [-121.41295, 38.40288], [-121.41306, 38.40295], [-121.41315, 38.40303], [-121.41321, 38.40313], [-121.41324, 38.4033], [-121.41322, 38.40341], [-121.41318, 38.40351], [-121.41305, 38.40365], [-121.41294, 38.40371], [-121.41282, 38.40376], [-121.41261, 38.40379], [-121.4124, 38.40376], [-121.41228, 38.40371], [-121.41217, 38.40364], [-121.41208, 38.40355], [-121.41202, 38.40345], [-121.41199, 38.40329], [-121.412, 38.40318], [-121.41205, 38.40308], [-121.41217, 38.40294], [-121.41228, 38.40287], [-121.41241, 38.40283], [-121.41262, 38.4028]]]} | Open Access 1 | 47129 | Constellation Park | 30806 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/586/Constellation-Park | Sacramento 41 | 2.307 | Constellation Park | 0 | Local Park 2 | 4 |
4120 | 4120 | 4119 | {"type": "Polygon", "coordinates": [[[-121.34852, 38.45076], [-121.34777, 38.45075], [-121.34771, 38.45079], [-121.34766, 38.45076], [-121.34759, 38.45076], [-121.3475, 38.4508], [-121.34748, 38.45083], [-121.34747, 38.45088], [-121.34728, 38.45088], [-121.34721, 38.45087], [-121.3474, 38.45018], [-121.34742, 38.45018], [-121.34742, 38.45023], [-121.34746, 38.45028], [-121.34757, 38.45031], [-121.34765, 38.45028], [-121.34774, 38.4502], [-121.34787, 38.45017], [-121.34809, 38.45015], [-121.34854, 38.45016], [-121.34857, 38.4502], [-121.34854, 38.45042], [-121.34852, 38.45076]]]} | Open Access 1 | 47128 | Jordan Family Park | 30805 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/604/Jordan-Family-Park | Sacramento 41 | 1.741 | Jordan Family Park | 0 | Local Park 2 | 4 |
4119 | 4119 | 4118 | {"type": "Polygon", "coordinates": [[[-121.44987, 38.38318], [-121.44957, 38.38321], [-121.44957, 38.38325], [-121.44874, 38.38344], [-121.44865, 38.38316], [-121.44852, 38.38313], [-121.44851, 38.38306], [-121.44844, 38.38301], [-121.44847, 38.38295], [-121.44837, 38.38269], [-121.44834, 38.38265], [-121.44897, 38.38231], [-121.44906, 38.38231], [-121.44938, 38.38266], [-121.44936, 38.38267], [-121.44938, 38.3827], [-121.44941, 38.38269], [-121.44987, 38.38318]]]} | Open Access 1 | 47127 | Buscher Park | 30804 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/566/Buscher-Park | Sacramento 41 | 2.298 | Buscher Park | 0 | Local Park 2 | 4 |
4113 | 4113 | 4112 | {"type": "Polygon", "coordinates": [[[-121.35944, 38.41534], [-121.35944, 38.41627], [-121.35395, 38.4163], [-121.35405, 38.41543], [-121.35476, 38.41527], [-121.35481, 38.41533], [-121.35488, 38.41536], [-121.35506, 38.41534], [-121.35521, 38.41534], [-121.35561, 38.41539], [-121.35677, 38.41575], [-121.35699, 38.4158], [-121.35723, 38.41581], [-121.35761, 38.41578], [-121.35793, 38.41569], [-121.35821, 38.41554], [-121.35845, 38.41534], [-121.35944, 38.41534]]]} | Open Access 1 | 47113 | Hill Park | 30784 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 10.163 | Hill Park | 0 | Local Park 2 | 4 | |
14470 | 14470 | 14469 | {"type": "Polygon", "coordinates": [[[-121.42642, 38.41883], [-121.42666, 38.41894], [-121.42668, 38.41897], [-121.42668, 38.419], [-121.42651, 38.4192], [-121.4264, 38.41936], [-121.42482, 38.42184], [-121.42471, 38.4221], [-121.42464, 38.42236], [-121.42462, 38.42256], [-121.4246, 38.42314], [-121.42434, 38.42314], [-121.42434, 38.42289], [-121.42429, 38.42284], [-121.42432, 38.4228], [-121.42434, 38.42274], [-121.42428, 38.42267], [-121.42434, 38.42261], [-121.42436, 38.42235], [-121.42441, 38.42214], [-121.42439, 38.4221], [-121.42444, 38.42207], [-121.42447, 38.42201], [-121.42446, 38.42197], [-121.42443, 38.42193], [-121.4245, 38.42189], [-121.4246, 38.42168], [-121.42474, 38.42145], [-121.42473, 38.42139], [-121.42479, 38.42137], [-121.42483, 38.42133], [-121.42484, 38.42128], [-121.42483, 38.42123], [-121.4249, 38.4212], [-121.42642, 38.41883]]]} | Open Access 1 | 47112 | Green Belt Park | 30783 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 3.174 | Green Belt Park | 0 | Local Park 2 | 4 | |
14251 | 14251 | 14250 | {"type": "Polygon", "coordinates": [[[-121.42746, 38.41856], [-121.42711, 38.41877], [-121.42686, 38.41896], [-121.42672, 38.41887], [-121.42648, 38.41876], [-121.42649, 38.41867], [-121.4262, 38.41859], [-121.42594, 38.41855], [-121.42562, 38.41854], [-121.42533, 38.41857], [-121.42511, 38.41862], [-121.4248, 38.41873], [-121.42474, 38.41873], [-121.4247, 38.41871], [-121.42453, 38.41851], [-121.42447, 38.41837], [-121.42479, 38.41839], [-121.42512, 38.41828], [-121.42529, 38.41827], [-121.42576, 38.41831], [-121.42592, 38.41809], [-121.42598, 38.41807], [-121.42603, 38.41803], [-121.42605, 38.41798], [-121.42602, 38.41792], [-121.42644, 38.41746], [-121.42644, 38.41728], [-121.42651, 38.4173], [-121.42661, 38.41729], [-121.42667, 38.41726], [-121.42671, 38.41721], [-121.42671, 38.41714], [-121.42668, 38.41706], [-121.42668, 38.4167], [-121.42671, 38.41658], [-121.42669, 38.41652], [-121.42663, 38.41647], [-121.42668, 38.41641], [-121.42668, 38.41619], [-121.4271, 38.41619], [-121.42711, 38.41661], [-121.42724, 38.41698], [-121.42714, 38.41703], [-121.42715, 38.41802], [-121.42718, 38.41815], [-121.42724, 38.41828], [-121.42746, 38.41856]]]} | Open Access 1 | 44169 | Lichtenberger Park | 21225 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 6.116 | Lichtenberger Park | 0 | Local Park 2 | 4 | |
12569 | 12569 | 12568 | {"type": "Polygon", "coordinates": [[[-121.43142, 38.3814], [-121.43141, 38.38145], [-121.42914, 38.38144], [-121.42914, 38.38116], [-121.42912, 38.38115], [-121.42916, 38.38111], [-121.42917, 38.38105], [-121.42914, 38.38095], [-121.42914, 38.38006], [-121.42917, 38.37995], [-121.42916, 38.3799], [-121.42912, 38.37986], [-121.42914, 38.37985], [-121.42914, 38.37947], [-121.43132, 38.37946], [-121.43138, 38.37948], [-121.4314, 38.37952], [-121.43142, 38.3814]]]} | Open Access 1 | 29078 | Backer Park | 15752 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 10.773 | Backer Park | 0 | Local Park 2 | 4 | |
12566 | 12566 | 12565 | {"type": "Polygon", "coordinates": [[[-121.44068, 38.38442], [-121.44068, 38.38618], [-121.43872, 38.38619], [-121.43867, 38.38613], [-121.43874, 38.38606], [-121.43872, 38.38599], [-121.43868, 38.38595], [-121.43856, 38.38589], [-121.43844, 38.38577], [-121.43872, 38.38561], [-121.43878, 38.38497], [-121.43899, 38.38496], [-121.43965, 38.38488], [-121.43981, 38.38482], [-121.43996, 38.38474], [-121.44015, 38.38459], [-121.44027, 38.38451], [-121.4405, 38.38444], [-121.44068, 38.38442]]]} | Open Access 1 | 29070 | Stephenson Park | 25832 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 6.751 | Stephenson Park | 0 | Local Park 2 | 4 | |
12565 | 12565 | 12564 | {"type": "Polygon", "coordinates": [[[-121.40872, 38.43284], [-121.40871, 38.43409], [-121.40753, 38.43393], [-121.40724, 38.43386], [-121.40699, 38.43377], [-121.40678, 38.43365], [-121.40658, 38.43351], [-121.40647, 38.4334], [-121.40713, 38.43241], [-121.4074, 38.43258], [-121.40771, 38.4327], [-121.40795, 38.43275], [-121.40872, 38.43284]]]} | Open Access 1 | 29069 | Pinkerton Park | 23696 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 6.013 | Pinkerton Park | 0 | Local Park 2 | 4 | |
3573 | 3573 | 3572 | {"type": "Polygon", "coordinates": [[[-121.47927, 38.41104], [-121.47989, 38.41113], [-121.48031, 38.41123], [-121.48033, 38.41127], [-121.48024, 38.4115], [-121.48019, 38.41184], [-121.48013, 38.41186], [-121.47927, 38.41181], [-121.4793, 38.41153], [-121.47923, 38.41133], [-121.47927, 38.41104]]]} | Open Access 1 | 29068 | Perez Park | 23609 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 1.695 | Perez Park | 0 | Local Park 2 | 4 | |
12564 | 12564 | 12563 | {"type": "Polygon", "coordinates": [[[-121.44361, 38.42043], [-121.4435, 38.42057], [-121.44344, 38.42059], [-121.44303, 38.42046], [-121.44273, 38.42041], [-121.44254, 38.42039], [-121.4383, 38.4204], [-121.43826, 38.42039], [-121.43823, 38.42035], [-121.43819, 38.42004], [-121.43809, 38.41972], [-121.43811, 38.41969], [-121.43824, 38.41961], [-121.43853, 38.41993], [-121.43913, 38.41993], [-121.43918, 38.41998], [-121.43925, 38.42], [-121.43934, 38.41998], [-121.4394, 38.41993], [-121.44016, 38.41993], [-121.44023, 38.41998], [-121.44029, 38.42], [-121.44037, 38.41998], [-121.44042, 38.41993], [-121.44118, 38.41993], [-121.44124, 38.41999], [-121.44132, 38.42], [-121.44142, 38.41997], [-121.44145, 38.41992], [-121.44145, 38.41986], [-121.44297, 38.42022], [-121.4433, 38.4202], [-121.44361, 38.42043]]]} | Open Access 1 | 29067 | Pedersen Park | 23559 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 5.457 | Pedersen Park | 0 | Local Park 2 | 4 | |
12563 | 12563 | 12562 | {"type": "Polygon", "coordinates": [[[-121.43902, 38.39825], [-121.43798, 38.399], [-121.43748, 38.39925], [-121.43709, 38.39938], [-121.43671, 38.39946], [-121.43626, 38.39949], [-121.43469, 38.39949], [-121.43426, 38.39944], [-121.43423, 38.39943], [-121.43421, 38.39939], [-121.43432, 38.39906], [-121.43434, 38.39878], [-121.43432, 38.39861], [-121.43423, 38.39818], [-121.43415, 38.39795], [-121.43402, 38.39768], [-121.43391, 38.3975], [-121.43369, 38.39724], [-121.43416, 38.39686], [-121.43433, 38.3967], [-121.43462, 38.39625], [-121.43474, 38.39619], [-121.43536, 38.39618], [-121.43557, 38.39622], [-121.43612, 38.39618], [-121.43613, 38.3962], [-121.43653, 38.3962], [-121.43656, 38.39618], [-121.43671, 38.39632], [-121.43889, 38.39811], [-121.439, 38.39821], [-121.43902, 38.39825]]]} | Open Access 1 | 29066 | Morse Park | 22507 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 29.259 | Morse Park | 0 | Local Park 2 | 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]);