superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
92 rows where MNG_AGENCY = 559 sorted by SUID_NMA
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3874 | 3874 | 3873 | {"type": "Polygon", "coordinates": [[[-121.44981, 38.40281], [-121.44976, 38.40285], [-121.44971, 38.40321], [-121.44966, 38.40335], [-121.44964, 38.40338], [-121.44958, 38.40339], [-121.44926, 38.40328], [-121.44895, 38.40314], [-121.44877, 38.40304], [-121.44846, 38.40281], [-121.44838, 38.40279], [-121.44864, 38.40261], [-121.44859, 38.40249], [-121.44886, 38.40233], [-121.44896, 38.40244], [-121.44915, 38.40258], [-121.44941, 38.40274], [-121.44981, 38.40281]]]} | Open Access 1 | Ehrhardt Oaks Park | 18470 | 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.749 | Ehrhardt Oaks Park | ||
3939 | 3939 | 3938 | {"type": "Polygon", "coordinates": [[[-121.38042, 38.39718], [-121.37979, 38.39739], [-121.3716, 38.39746], [-121.37156, 38.38687], [-121.37157, 38.38683], [-121.37159, 38.3868], [-121.37166, 38.38678], [-121.37171, 38.3868], [-121.37191, 38.387], [-121.3731, 38.38823], [-121.37592, 38.39121], [-121.37624, 38.39157], [-121.37632, 38.39172], [-121.37658, 38.39199], [-121.37933, 38.39571], [-121.37925, 38.39598], [-121.37939, 38.39617], [-121.37984, 38.3964], [-121.38042, 38.39718]]]} | Open Access 1 | Elk Grove Park | 18562 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 123.144 | Elk Grove Park | ||
4168 | 4168 | 4167 | {"type": "Polygon", "coordinates": [[[-121.40167, 38.45148], [-121.40135, 38.45173], [-121.40124, 38.45177], [-121.40111, 38.45176], [-121.40101, 38.45171], [-121.40065, 38.45143], [-121.4006, 38.45134], [-121.4006, 38.45127], [-121.40065, 38.45118], [-121.40095, 38.45093], [-121.4011, 38.45103], [-121.40167, 38.45148]]]} | Open Access 1 | Fales Park | 18830 | 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.212 | Fales Park | ||
4198 | 4198 | 4197 | {"type": "Polygon", "coordinates": [[[-121.38669, 38.41831], [-121.38668, 38.41952], [-121.38566, 38.41969], [-121.38543, 38.4197], [-121.38524, 38.41969], [-121.3854, 38.41902], [-121.3854, 38.41831], [-121.38669, 38.41831]]]} | Open Access 1 | Feickert Park | 18864 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 4.177 | Feickert Park | ||
3343 | 3343 | 3342 | {"type": "Polygon", "coordinates": [[[-121.45444, 38.42969], [-121.45442, 38.43075], [-121.45442, 38.43083], [-121.45439, 38.43086], [-121.45317, 38.43087], [-121.45288, 38.43085], [-121.45288, 38.42967], [-121.45444, 38.42969]]]} | Open Access 1 | Fite Park | 18926 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 4.4 | Fite 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 | ||
4293 | 4293 | 4292 | {"type": "Polygon", "coordinates": [[[-121.41121, 38.41686], [-121.41113, 38.41689], [-121.41094, 38.41704], [-121.41074, 38.41722], [-121.40884, 38.41677], [-121.40884, 38.41614], [-121.40911, 38.41612], [-121.4092, 38.41608], [-121.40925, 38.41612], [-121.40933, 38.41614], [-121.4094, 38.41614], [-121.40949, 38.41611], [-121.40979, 38.41609], [-121.41012, 38.41609], [-121.41024, 38.41612], [-121.4103, 38.41611], [-121.41038, 38.41606], [-121.41041, 38.41602], [-121.41084, 38.41602], [-121.41121, 38.41686]]]} | Open Access 1 | Foulks Park | 19017 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 4.879 | Foulks Park | ||
4463 | 4463 | 4462 | {"type": "Polygon", "coordinates": [[[-121.3732, 38.44851], [-121.37316, 38.44859], [-121.37318, 38.44904], [-121.37268, 38.44903], [-121.37246, 38.44899], [-121.37241, 38.44896], [-121.37244, 38.44875], [-121.37243, 38.44837], [-121.37309, 38.44836], [-121.37309, 38.44841], [-121.37312, 38.44846], [-121.3732, 38.44851]]]} | Open Access 1 | Gage Park | 19170 | 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.148 | Gage 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 | ||
4808 | 4808 | 4807 | {"type": "Polygon", "coordinates": [[[-121.40841, 38.42928], [-121.40823, 38.42936], [-121.40817, 38.42942], [-121.40814, 38.42949], [-121.40814, 38.42959], [-121.40833, 38.42983], [-121.40831, 38.43019], [-121.408, 38.43026], [-121.40767, 38.4304], [-121.40752, 38.4305], [-121.40738, 38.43061], [-121.40717, 38.43085], [-121.40692, 38.43073], [-121.40671, 38.43065], [-121.40651, 38.43059], [-121.40622, 38.43053], [-121.40622, 38.43039], [-121.40629, 38.43032], [-121.40632, 38.43021], [-121.40647, 38.43004], [-121.40665, 38.42992], [-121.40813, 38.42927], [-121.40824, 38.42925], [-121.40832, 38.42921], [-121.40841, 38.42928]]]} | Open Access 1 | Guttridge Park | 19575 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 4.174 | Guttridge Park | ||
4974 | 4974 | 4973 | {"type": "Polygon", "coordinates": [[[-121.48326, 38.42133], [-121.48259, 38.42144], [-121.48254, 38.42137], [-121.48225, 38.42115], [-121.48194, 38.42098], [-121.48157, 38.42093], [-121.48161, 38.42058], [-121.4816, 38.42011], [-121.48167, 38.42007], [-121.48196, 38.42004], [-121.48254, 38.41994], [-121.48293, 38.41993], [-121.48298, 38.41994], [-121.483, 38.41997], [-121.48303, 38.42014], [-121.48326, 38.42133]]]} | Open Access 1 | Hawkins Park | 19748 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 4.455 | Hawkins Park | ||
5027 | 5027 | 5026 | {"type": "Polygon", "coordinates": [[[-121.4788, 38.39746], [-121.47839, 38.39752], [-121.47822, 38.39759], [-121.47807, 38.39769], [-121.47801, 38.39769], [-121.4777, 38.39753], [-121.47736, 38.39742], [-121.47734, 38.3974], [-121.47733, 38.39728], [-121.47727, 38.39701], [-121.47866, 38.39681], [-121.4788, 38.39746]]]} | Open Access 1 | Henderson Park | 19814 | 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.184 | Henderson Park | ||
5042 | 5042 | 5041 | {"type": "Polygon", "coordinates": [[[-121.42469, 38.4338], [-121.42405, 38.4338], [-121.42403, 38.43382], [-121.42397, 38.43381], [-121.42389, 38.43382], [-121.42386, 38.4338], [-121.42355, 38.4338], [-121.42354, 38.43312], [-121.42461, 38.43311], [-121.42466, 38.43313], [-121.42468, 38.43315], [-121.42469, 38.4338]]]} | Open Access 1 | Herburger Park | 19831 | 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.877 | Herburger Park | ||
5262 | 5262 | 5261 | {"type": "Polygon", "coordinates": [[[-121.47382, 38.40385], [-121.47375, 38.40384], [-121.47335, 38.40363], [-121.47346, 38.40347], [-121.47351, 38.40335], [-121.47354, 38.4032], [-121.47352, 38.40304], [-121.47347, 38.40288], [-121.47337, 38.40274], [-121.47329, 38.40265], [-121.47313, 38.40253], [-121.47297, 38.40245], [-121.47273, 38.40239], [-121.47252, 38.40237], [-121.47233, 38.40238], [-121.47214, 38.40243], [-121.47195, 38.40251], [-121.4718, 38.4026], [-121.47167, 38.40273], [-121.47127, 38.40251], [-121.47125, 38.40247], [-121.47125, 38.40245], [-121.47145, 38.40227], [-121.47169, 38.40212], [-121.47196, 38.40202], [-121.47225, 38.40196], [-121.47252, 38.40194], [-121.47285, 38.40197], [-121.47314, 38.40204], [-121.4734, 38.40215], [-121.47367, 38.40233], [-121.47381, 38.40247], [-121.47397, 38.40271], [-121.47404, 38.40288], [-121.47407, 38.40303], [-121.47408, 38.40322], [-121.47406, 38.40339], [-121.47401, 38.40356], [-121.47394, 38.4037], [-121.47382, 38.40385]]]} | Open Access 1 | Houde Park | 20106 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 4.211 | Houde Park | ||
5280 | 5280 | 5279 | {"type": "Polygon", "coordinates": [[[-121.37676, 38.44496], [-121.37635, 38.44544], [-121.37599, 38.44529], [-121.37572, 38.44522], [-121.37544, 38.44519], [-121.37541, 38.44517], [-121.37539, 38.44514], [-121.3754, 38.44476], [-121.376, 38.44477], [-121.37675, 38.4449], [-121.37676, 38.44496]]]} | Open Access 1 | Hrepich Park | 20128 | 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.488 | Hrepich Park | ||
5594 | 5594 | 5593 | {"type": "Polygon", "coordinates": [[[-121.46737, 38.41069], [-121.46712, 38.411], [-121.46714, 38.41105], [-121.46708, 38.4111], [-121.46704, 38.41118], [-121.46677, 38.4115], [-121.46666, 38.41164], [-121.46649, 38.41191], [-121.46641, 38.41199], [-121.46639, 38.41203], [-121.46641, 38.4121], [-121.46647, 38.41215], [-121.46655, 38.41218], [-121.46632, 38.41249], [-121.46603, 38.41238], [-121.46601, 38.4124], [-121.46576, 38.41234], [-121.4654, 38.41229], [-121.46506, 38.41229], [-121.46445, 38.41235], [-121.4642, 38.41234], [-121.46363, 38.41227], [-121.46295, 38.41227], [-121.46279, 38.41039], [-121.46315, 38.41028], [-121.4637, 38.41003], [-121.46402, 38.40995], [-121.46416, 38.40993], [-121.46448, 38.40992], [-121.46474, 38.40994], [-121.46641, 38.41032], [-121.46696, 38.4105], [-121.46737, 38.41069]]]} | Open Access 1 | Johnson Park | 20480 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 20.882 | Johnson Park | ||
5597 | 5597 | 5596 | {"type": "Polygon", "coordinates": [[[-121.42481, 38.39717], [-121.42442, 38.39732], [-121.42282, 38.39738], [-121.42284, 38.39714], [-121.42281, 38.3967], [-121.42283, 38.39667], [-121.42287, 38.39666], [-121.42363, 38.39662], [-121.42379, 38.39665], [-121.4239, 38.39661], [-121.42395, 38.39665], [-121.42427, 38.39675], [-121.42479, 38.39675], [-121.42481, 38.39717]]]} | Open Access 1 | Johnston Park | 20483 | 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.076 | Johnston Park | ||
5601 | 5601 | 5600 | {"type": "Polygon", "coordinates": [[[-121.38127, 38.44688], [-121.38109, 38.44689], [-121.38072, 38.44681], [-121.38046, 38.44671], [-121.38028, 38.44651], [-121.3786, 38.44655], [-121.37749, 38.44354], [-121.37773, 38.44368], [-121.37803, 38.44394], [-121.37839, 38.44386], [-121.3793, 38.44356], [-121.37947, 38.44357], [-121.37965, 38.44373], [-121.37987, 38.44385], [-121.38036, 38.44409], [-121.38083, 38.44426], [-121.38085, 38.44425], [-121.38085, 38.44392], [-121.38115, 38.44405], [-121.38143, 38.44426], [-121.38162, 38.44448], [-121.38176, 38.44473], [-121.38183, 38.44504], [-121.38182, 38.44521], [-121.38178, 38.4454], [-121.38169, 38.44562], [-121.38141, 38.446], [-121.3813, 38.44623], [-121.38126, 38.44637], [-121.38123, 38.44655], [-121.38124, 38.44674], [-121.38127, 38.44688]]]} | Open Access 1 | Jones Park | 20487 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 22.686 | Jones Park | ||
5633 | 5633 | 5632 | {"type": "Polygon", "coordinates": [[[-121.4427, 38.40131], [-121.44268, 38.40277], [-121.44262, 38.40274], [-121.44099, 38.40274], [-121.44093, 38.40271], [-121.44092, 38.40269], [-121.4409, 38.40131], [-121.4427, 38.40131]]]} | Open Access 1 | Jungkeit Park | 20524 | 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.107 | Jungkeit Park | ||
5654 | 5654 | 5653 | {"type": "Polygon", "coordinates": [[[-121.38958, 38.44284], [-121.38952, 38.44286], [-121.38879, 38.44286], [-121.38879, 38.44208], [-121.38952, 38.44207], [-121.38957, 38.44209], [-121.38959, 38.44213], [-121.38959, 38.4428], [-121.38958, 38.44284]]]} | Open Access 1 | Karamanos Park | 20552 | 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.498 | Karamanos 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]);