superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
92 rows where MNG_AGENCY = 559 and MNG_AG_TYP = 17 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: ACRES
MNG_AG_TYP 1
- Community Services District · 92 ✖
MNG_AGENCY 1
- Consumnes Community Services District · 92 ✖
ACCESS_TYP 1
- Open Access 92
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13426 | 13426 | 13425 | {"type": "MultiPolygon", "coordinates": [[[[-121.38001, 38.42816], [-121.37938, 38.42865], [-121.37942, 38.42872], [-121.37935, 38.42879], [-121.37911, 38.42882], [-121.3788, 38.42929], [-121.37901, 38.4298], [-121.37887, 38.4299], [-121.37871, 38.43006], [-121.37863, 38.43019], [-121.37857, 38.43039], [-121.37809, 38.43057], [-121.37771, 38.43082], [-121.37771, 38.43096], [-121.37765, 38.43099], [-121.37762, 38.43106], [-121.37752, 38.43106], [-121.37721, 38.43117], [-121.37673, 38.43052], [-121.37715, 38.43014], [-121.37735, 38.43014], [-121.37763, 38.43007], [-121.3778, 38.43], [-121.37802, 38.42985], [-121.37813, 38.42972], [-121.37824, 38.42951], [-121.37828, 38.42936], [-121.37826, 38.42913], [-121.37862, 38.42897], [-121.37891, 38.42875], [-121.3789, 38.42863], [-121.37897, 38.4286], [-121.37902, 38.42855], [-121.37918, 38.42859], [-121.37977, 38.42801], [-121.38001, 38.42816]]], [[[-121.38539, 38.42712], [-121.38534, 38.43073], [-121.38522, 38.43073], [-121.38521, 38.43017], [-121.3849, 38.42994], [-121.38457, 38.42966], [-121.38434, 38.4295], [-121.3842, 38.42927], [-121.38387, 38.42925], [-121.38382, 38.4291], [-121.38373, 38.42893], [-121.38362, 38.4288], [-121.38347, 38.42868], [-121.38328, 38.42857], [-121.38271, 38.42832], [-121.38256, 38.42826], [-121.38238, 38.42822], [-121.38237, 38.42792], [-121.38168, 38.42783], [-121.38149, 38.42747], [-121.38117, 38.4276], [-121.38116, 38.42771], [-121.38108, 38.42771], [-121.38102, 38.42776], [-121.38085, 38.42771], [-121.38048, 38.42788], [-121.38022, 38.42812], [-121.37995, 38.42794], [-121.3809, 38.42712], [-121.38539, 38.42712]]]]} | Open Access 1 | Camden Park Greenbelt | http://www.yourcsd.com/569/Camden-Park | 30810 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 23.195 | Camden Park Greenbelt | |
1984 | 1984 | 1983 | {"type": "MultiPolygon", "coordinates": [[[[-121.44049, 38.4306], [-121.44003, 38.4306], [-121.43918, 38.43156], [-121.43899, 38.43148], [-121.43873, 38.43143], [-121.43846, 38.43139], [-121.43708, 38.43138], [-121.43685, 38.43139], [-121.43667, 38.43144], [-121.43645, 38.43151], [-121.43619, 38.43155], [-121.43418, 38.43163], [-121.43414, 38.43161], [-121.43412, 38.43158], [-121.43412, 38.43064], [-121.43409, 38.43062], [-121.43409, 38.43039], [-121.4341, 38.43035], [-121.43413, 38.43034], [-121.43492, 38.43033], [-121.43494, 38.43062], [-121.43971, 38.4306], [-121.43973, 38.43003], [-121.43984, 38.43003], [-121.44029, 38.43008], [-121.44049, 38.43016], [-121.44049, 38.4306]]], [[[-121.43856, 38.4322], [-121.43773, 38.43316], [-121.43751, 38.43309], [-121.4383, 38.43218], [-121.43841, 38.43218], [-121.43856, 38.4322]]]]} | Open Access 1 | Betschart Park | 16049 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 13.848 | Betschart Park | ||
4257 | 4257 | 4256 | {"type": "Polygon", "coordinates": [[[-121.33921, 38.42094], [-121.33921, 38.42132], [-121.33772, 38.42183], [-121.33772, 38.4211], [-121.33809, 38.4211], [-121.3382, 38.42113], [-121.33828, 38.42112], [-121.33835, 38.42109], [-121.33839, 38.42105], [-121.33841, 38.42099], [-121.3384, 38.42094], [-121.33921, 38.42094]]]} | Open Access 1 | Fleming Park | 18945 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 1.992 | Fleming Park | ||
6982 | 6982 | 6981 | {"type": "Polygon", "coordinates": [[[-121.34005, 38.40649], [-121.34, 38.40655], [-121.33999, 38.40659], [-121.33972, 38.40652], [-121.33899, 38.40664], [-121.3388, 38.40594], [-121.33881, 38.40591], [-121.33884, 38.40588], [-121.33955, 38.40578], [-121.34003, 38.40575], [-121.33998, 38.40611], [-121.33999, 38.40642], [-121.34005, 38.40649]]]} | Open Access 1 | Miles Park | 22219 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2.079 | Miles Park | ||
9696 | 9696 | 9695 | {"type": "Polygon", "coordinates": [[[-121.34151, 38.41629], [-121.34151, 38.4166], [-121.34146, 38.41658], [-121.34098, 38.41669], [-121.34063, 38.41672], [-121.34056, 38.41663], [-121.33983, 38.41663], [-121.33987, 38.41658], [-121.33987, 38.41538], [-121.33983, 38.4153], [-121.33988, 38.41525], [-121.33991, 38.41495], [-121.33991, 38.41465], [-121.3402, 38.41468], [-121.34047, 38.41469], [-121.34049, 38.4147], [-121.3415, 38.4147], [-121.3415, 38.41628], [-121.34151, 38.41629]]]} | Open Access 1 | Simpson Park | 25514 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 7.629 | Simpson Park | ||
13432 | 13432 | 13431 | {"type": "Polygon", "coordinates": [[[-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.33866, 38.40314], [-121.33833, 38.40307], [-121.33812, 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.33702, 38.40223], [-121.33703, 38.40179], [-121.34161, 38.40181], [-121.34162, 38.40199], [-121.34165, 38.40214]]]} | Open Access 1 | Derr-Okamoto Park | http://www.yourcsd.com/590/Derr-Okamoto-Park | 30816 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 12.379 | Derr-Okamoto Park | |
13418 | 13418 | 13417 | {"type": "Polygon", "coordinates": [[[-121.34857, 38.4502], [-121.34854, 38.45042], [-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.34756, 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]]]} | Open Access 1 | Jordan Family Park | http://www.yourcsd.com/604/Jordan-Family-Park | 30805 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 1.741 | Jordan Family Park | |
1958 | 1958 | 1957 | {"type": "Polygon", "coordinates": [[[-121.3487, 38.39004], [-121.3487, 38.39008], [-121.34845, 38.39049], [-121.3479, 38.39027], [-121.34783, 38.39028], [-121.34779, 38.39023], [-121.34774, 38.39021], [-121.34763, 38.39021], [-121.3476, 38.39016], [-121.34705, 38.38994], [-121.34715, 38.38984], [-121.34735, 38.38953], [-121.34739, 38.38951], [-121.34747, 38.38951], [-121.34868, 38.39], [-121.3487, 38.39004]]]} | Open Access 1 | Berens Park | 16019 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 1.922 | Berens Park | ||
6136 | 6136 | 6135 | {"type": "Polygon", "coordinates": [[[-121.34909, 38.40796], [-121.34912, 38.40816], [-121.3491, 38.40839], [-121.34906, 38.40852], [-121.34895, 38.40866], [-121.34886, 38.40872], [-121.34847, 38.40891], [-121.34829, 38.40895], [-121.34738, 38.40896], [-121.34738, 38.4088], [-121.34746, 38.40848], [-121.34783, 38.40857], [-121.34786, 38.40856], [-121.34794, 38.4086], [-121.34803, 38.40859], [-121.34808, 38.40856], [-121.34811, 38.40852], [-121.3481, 38.4084], [-121.34813, 38.40832], [-121.34822, 38.40822], [-121.34835, 38.40813], [-121.34852, 38.40804], [-121.34876, 38.40797], [-121.34902, 38.40793], [-121.34909, 38.40796]]]} | Open Access 1 | Lewis Park | 21195 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2.502 | Lewis Park | ||
4517 | 4517 | 4516 | {"type": "Polygon", "coordinates": [[[-121.34956, 38.40229], [-121.34941, 38.40396], [-121.34941, 38.40396], [-121.34939, 38.40367], [-121.34934, 38.40354], [-121.34925, 38.4034], [-121.34915, 38.40328], [-121.34904, 38.40318], [-121.34866, 38.40295], [-121.34848, 38.40278], [-121.3484, 38.40268], [-121.34832, 38.40255], [-121.34825, 38.40231], [-121.34827, 38.40227], [-121.34832, 38.40226], [-121.34882, 38.40229], [-121.34956, 38.40229]]]} | Open Access 1 | Gates Park | 19233 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2.445 | Gates Park | ||
11401 | 11401 | 11400 | {"type": "Polygon", "coordinates": [[[-121.35043, 38.41776], [-121.34967, 38.41781], [-121.34936, 38.41779], [-121.34944, 38.41754], [-121.34946, 38.41741], [-121.34947, 38.4172], [-121.34946, 38.41706], [-121.34934, 38.41649], [-121.34933, 38.4163], [-121.35026, 38.4163], [-121.35043, 38.41776]]]} | Open Access 1 | Wright Park | 27759 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 3.348 | Wright Park | ||
10033 | 10033 | 10032 | {"type": "Polygon", "coordinates": [[[-121.35083, 38.4122], [-121.34976, 38.41217], [-121.34973, 38.41215], [-121.34971, 38.41212], [-121.34971, 38.41181], [-121.34974, 38.41174], [-121.34974, 38.41169], [-121.34969, 38.41161], [-121.34958, 38.41157], [-121.34904, 38.41157], [-121.34861, 38.41154], [-121.34825, 38.41148], [-121.34784, 38.41136], [-121.34765, 38.41128], [-121.34797, 38.41092], [-121.34779, 38.41085], [-121.34771, 38.41086], [-121.34763, 38.41085], [-121.34767, 38.41081], [-121.34776, 38.4108], [-121.34783, 38.41077], [-121.34821, 38.41037], [-121.34832, 38.41021], [-121.34874, 38.4095], [-121.34881, 38.40942], [-121.34892, 38.40934], [-121.3492, 38.40919], [-121.34933, 38.40915], [-121.3508, 38.40913], [-121.35083, 38.4122]]]} | Open Access 1 | Strong Park | 25929 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 16.285 | Strong Park | ||
8099 | 8099 | 8098 | {"type": "Polygon", "coordinates": [[[-121.35789, 38.44863], [-121.35783, 38.44864], [-121.35668, 38.44864], [-121.35664, 38.4486], [-121.35664, 38.44812], [-121.35783, 38.44803], [-121.35789, 38.44863]]]} | Open Access 1 | Perry Park | 23615 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 1.657 | Perry Park | ||
13277 | 13277 | 13276 | {"type": "Polygon", "coordinates": [[[-121.35944, 38.41534], [-121.35944, 38.41627], [-121.35395, 38.4163], [-121.35405, 38.41543], [-121.35475, 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.35792, 38.41569], [-121.3582, 38.41554], [-121.35845, 38.41534], [-121.35944, 38.41534]]]} | Open Access 1 | Hill Park | 30784 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 10.162 | Hill Park | ||
9070 | 9070 | 9069 | {"type": "Polygon", "coordinates": [[[-121.36093, 38.40781], [-121.36092, 38.40783], [-121.36087, 38.40785], [-121.36024, 38.40785], [-121.36023, 38.4072], [-121.36073, 38.4072], [-121.36073, 38.40729], [-121.36076, 38.40741], [-121.3609, 38.40767], [-121.36093, 38.40781]]]} | Open Access 1 | Russell Park | 24740 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 0.931 | Russell Park | ||
10654 | 10654 | 10653 | {"type": "Polygon", "coordinates": [[[-121.3624, 38.41993], [-121.3624, 38.42089], [-121.36205, 38.4209], [-121.36201, 38.42086], [-121.36188, 38.42039], [-121.36186, 38.4202], [-121.36186, 38.41995], [-121.3624, 38.41993]]]} | Open Access 1 | Van Doren Park | 26826 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 1.114 | Van Doren Park | ||
6801 | 6801 | 6800 | {"type": "Polygon", "coordinates": [[[-121.36241, 38.39034], [-121.36242, 38.39166], [-121.36239, 38.39192], [-121.36231, 38.39217], [-121.36219, 38.39242], [-121.36203, 38.39263], [-121.36198, 38.39266], [-121.36194, 38.39266], [-121.36167, 38.39248], [-121.36152, 38.39234], [-121.3614, 38.39219], [-121.36129, 38.39198], [-121.36105, 38.39134], [-121.36109, 38.39132], [-121.36105, 38.39117], [-121.36102, 38.39099], [-121.36102, 38.39083], [-121.36105, 38.39064], [-121.36109, 38.39048], [-121.36117, 38.39031], [-121.36127, 38.39014], [-121.36138, 38.39001], [-121.36241, 38.39034]]]} | Open Access 1 | McConnel Park | 22005 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 6.778 | McConnel Park | ||
9740 | 9740 | 9739 | {"type": "Polygon", "coordinates": [[[-121.36685, 38.40006], [-121.36645, 38.40006], [-121.36639, 38.40002], [-121.36631, 38.40001], [-121.36571, 38.40001], [-121.36567, 38.39997], [-121.36567, 38.39945], [-121.36572, 38.39942], [-121.36602, 38.39942], [-121.36619, 38.39942], [-121.36635, 38.39945], [-121.36642, 38.39943], [-121.36647, 38.39939], [-121.36685, 38.39939], [-121.36685, 38.40006]]]} | Open Access 1 | Smedberg Park | 25564 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 1.724 | Smedberg Park | ||
6942 | 6942 | 6941 | {"type": "Polygon", "coordinates": [[[-121.36833, 38.41587], [-121.36808, 38.41626], [-121.36736, 38.41626], [-121.36722, 38.41588], [-121.36764, 38.41547], [-121.3682, 38.41581], [-121.36833, 38.41587]]]} | Open Access 1 | Mendoza Park | 22154 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 1.363 | Mendoza Park | ||
1231 | 1231 | 1230 | {"type": "Polygon", "coordinates": [[[-121.36943, 38.44722], [-121.36911, 38.4473], [-121.36882, 38.44745], [-121.36862, 38.44752], [-121.36844, 38.44754], [-121.36794, 38.44755], [-121.36772, 38.44758], [-121.3677, 38.44537], [-121.36942, 38.44537], [-121.36943, 38.44722]]]} | Open Access 1 | Amundson Park | 15463 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 8.563 | Amundson Park |
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]);