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 ACRES
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Consumnes Community Services District · 72 ✖
DES_TP 1
- Local Park · 72 ✖
ACCESS_TYP 1
- Open Access 72
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
11791 | 11791 | 11790 | {"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.39943], [-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 | 24087 | Smedberg Park | 25564 | 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.725 | Smedberg 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 |
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 | |
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 |
11773 | 11773 | 11772 | {"type": "Polygon", "coordinates": [[[-121.42449, 38.41889], [-121.42368, 38.41943], [-121.42327, 38.41898], [-121.42324, 38.41869], [-121.42353, 38.41864], [-121.42368, 38.41859], [-121.42398, 38.41845], [-121.42415, 38.4184], [-121.42426, 38.41839], [-121.4243, 38.41842], [-121.42445, 38.41877], [-121.4245, 38.41885], [-121.42449, 38.41889]]]} | Open Access 1 | 24067 | Batey Park | 15861 | 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.845 | Batey 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 | |
11796 | 11796 | 11795 | {"type": "Polygon", "coordinates": [[[-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], [-121.3487, 38.39008], [-121.34845, 38.39049]]]} | Open Access 1 | 24092 | Berens Park | 16019 | 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.922 | Berens 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 | |
11767 | 11767 | 11766 | {"type": "Polygon", "coordinates": [[[-121.47885, 38.42529], [-121.47888, 38.42535], [-121.47879, 38.42573], [-121.47878, 38.42593], [-121.47875, 38.42596], [-121.47771, 38.42597], [-121.47764, 38.42594], [-121.47763, 38.42552], [-121.47762, 38.42534], [-121.47765, 38.42528], [-121.47798, 38.42524], [-121.47824, 38.42522], [-121.47848, 38.42524], [-121.47885, 38.42529]]]} | Open Access 1 | 24059 | Lawson Park | 21119 | 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.044 | Lawson Park | 0 | Local Park 2 | 4 | |
11755 | 11755 | 11754 | {"type": "Polygon", "coordinates": [[[-121.3936, 38.43618], [-121.39359, 38.43719], [-121.39325, 38.4371], [-121.39304, 38.4371], [-121.39283, 38.43713], [-121.39241, 38.43713], [-121.39262, 38.43683], [-121.39273, 38.43665], [-121.3928, 38.43643], [-121.39284, 38.43623], [-121.39287, 38.43619], [-121.3936, 38.43618]]]} | Open Access 1 | 24048 | Lombardi Park | 21412 | 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.047 | Lombardi Park | 0 | Local Park 2 | 4 | |
12562 | 12562 | 12561 | {"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.40643], [-121.34005, 38.40649]]]} | Open Access 1 | 29065 | Miles Park | 22219 | 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.079 | Miles Park | 0 | Local Park 2 | 4 | |
11787 | 11787 | 11786 | {"type": "Polygon", "coordinates": [[[-121.43175, 38.40455], [-121.43186, 38.4043], [-121.43191, 38.40429], [-121.43203, 38.40432], [-121.43219, 38.40438], [-121.43238, 38.40453], [-121.43252, 38.40471], [-121.43257, 38.40485], [-121.43258, 38.40499], [-121.43257, 38.4051], [-121.43253, 38.4052], [-121.43246, 38.40533], [-121.43235, 38.40544], [-121.43222, 38.40554], [-121.43206, 38.40561], [-121.43193, 38.40565], [-121.43188, 38.40564], [-121.43185, 38.40562], [-121.43176, 38.40541], [-121.43173, 38.40526], [-121.43172, 38.40475], [-121.43175, 38.40455]]]} | Open Access 1 | 24082 | Kramer Park | 20723 | 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.105 | Kramer 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 | |
2988 | 2988 | 2987 | {"type": "Polygon", "coordinates": [[[-121.43784, 38.40364], [-121.43781, 38.40446], [-121.43684, 38.40452], [-121.43668, 38.40452], [-121.43664, 38.40449], [-121.43665, 38.4038], [-121.43784, 38.40364]]]} | Open Access 1 | 24083 | Keema Park | 20570 | 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.195 | Keema 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 |
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 |
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 |
11769 | 11769 | 11768 | {"type": "Polygon", "coordinates": [[[-121.37703, 38.42161], [-121.377, 38.42169], [-121.37703, 38.42178], [-121.37703, 38.42262], [-121.37624, 38.42262], [-121.37623, 38.42127], [-121.37672, 38.42127], [-121.37672, 38.42145], [-121.37703, 38.42161]]]} | Open Access 1 | 24061 | Castello Park | 16948 | 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.382 | Castello 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 |
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]);