units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
94 rows where MNG_AGENCY = 559 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Consumnes Community Services District · 74 ✖
DES_TP 1
- Local Park 74
ACCESS_TYP 1
- Open Access 74
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12548 | 12548 | 12547 | {"type": "Polygon", "coordinates": [[[-121.3714, 38.4211], [-121.3709, 38.4211], [-121.37034, 38.42063], [-121.3714, 38.42063], [-121.3714, 38.4211]]]} | Open Access 1 | 29052 | Del Meyer Park | 18039 | 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.886 | Del Meyer Park | 0 | Local Park 2 | 4 | |
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 |
12550 | 12550 | 12549 | {"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.44865, 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 | 29053 | Ehrhardt Oaks Park | 18470 | 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.748 | Ehrhardt Oaks Park | 0 | Local Park 2 | 4 | |
12551 | 12551 | 12550 | {"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 | 29054 | Elk Grove Park | 18562 | 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 | 123.144 | Elk Grove Park | 0 | Local Park 2 | 4 | |
12552 | 12552 | 12551 | {"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 | 29055 | Fales Park | 18830 | 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.212 | Fales Park | 0 | Local Park 2 | 4 | |
11772 | 11772 | 11771 | {"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 | 24065 | Feickert Park | 18864 | 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 | 4.177 | Feickert Park | 0 | Local Park 2 | 4 | |
11761 | 11761 | 11760 | {"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 | 24054 | Fite Park | 18926 | 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 | 4.401 | Fite Park | 0 | Local Park 2 | 4 | |
11770 | 11770 | 11769 | {"type": "Polygon", "coordinates": [[[-121.33921, 38.42094], [-121.33921, 38.42132], [-121.33772, 38.42183], [-121.33772, 38.4211], [-121.3381, 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 | 24062 | Fleming Park | 18945 | 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.992 | Fleming Park | 0 | Local Park 2 | 4 | |
12553 | 12553 | 12552 | {"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 | 29056 | Foulks Park | 19017 | 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 | 4.879 | Foulks Park | 0 | Local Park 2 | 4 | |
11750 | 11750 | 11749 | {"type": "Polygon", "coordinates": [[[-121.3732, 38.44851], [-121.37316, 38.44858], [-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 | 24043 | Gage Park | 19170 | 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.148 | Gage Park | 0 | Local Park 2 | 4 | |
11788 | 11788 | 11787 | {"type": "Polygon", "coordinates": [[[-121.34956, 38.40229], [-121.34956, 38.40229], [-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 | 24084 | Gates Park | 19233 | 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 | 2.445 | Gates 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 | |
11760 | 11760 | 11759 | {"type": "Polygon", "coordinates": [[[-121.40841, 38.42928], [-121.40823, 38.42936], [-121.40818, 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.40672, 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 | 24053 | Guttridge Park | 19575 | 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 | 4.174 | Guttridge 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 | |
11771 | 11771 | 11770 | {"type": "Polygon", "coordinates": [[[-121.48326, 38.42133], [-121.48259, 38.42144], [-121.48254, 38.42137], [-121.48225, 38.42115], [-121.48194, 38.42097], [-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 | 24064 | Hawkins Park | 19748 | 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 | 4.455 | Hawkins Park | 0 | Local Park 2 | 4 | |
11792 | 11792 | 11791 | {"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 | 24088 | Henderson Park | 19814 | 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 | 2.184 | Henderson Park | 0 | Local Park 2 | 4 | |
11758 | 11758 | 11757 | {"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 | 24051 | Herburger Park | 19831 | 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.877 | Herburger 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 | |
11789 | 11789 | 11788 | {"type": "Polygon", "coordinates": [[[-121.47335, 38.40363], [-121.47346, 38.40347], [-121.47351, 38.40335], [-121.47354, 38.4032], [-121.47352, 38.40304], [-121.47347, 38.40289], [-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.47391, 38.4026], [-121.47397, 38.40271], [-121.47404, 38.40288], [-121.47407, 38.40303], [-121.47409, 38.40322], [-121.47406, 38.40339], [-121.47401, 38.40356], [-121.47394, 38.4037], [-121.47382, 38.40385], [-121.47375, 38.40385], [-121.47335, 38.40363]]]} | Open Access 1 | 24085 | Houde Park | 20106 | 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 | 4.214 | Houde Park | 0 | Local Park 2 | 4 | |
11752 | 11752 | 11751 | {"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 | 24045 | Hrepich Park | 20128 | 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.488 | Hrepich 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]);