units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
198 rows where MNG_AG_TYP = 17 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
MNG_AGENCY 29
- Consumnes Community Services District 93
- El Dorado Hills Community Service District 22
- Jurupa Community Services District 10
- Cameron Park Community Services District 7
- Mountain House Community Services District 6
- McKinleyville Community Services District 4
- Tamalpais Community Services District 3
- Marinwood Community Service District 3
- Groveland Community Services District 2
- Manila Community Services District 2
- Truckee Tahoe Airport District 2
- Indian Valley Community Services District 2
- Aromona Community Services District 2
- Helendale Community Services District 2
- Pajaro Community Services District 2
- Salton Community Services District 2
- Templeton Community Services District 2
- Brooktrails Community Services District 1
- Twain Harte Community Services District 1
- Rosamond Community Services District 1
- Los Alamos Community Services District 1
- Golden Hills Community Service District 1
- Happy Camp Community Services District 1
- McCloud Community Services District 1
- Concord Landscaping and Lighting Maintenance District No. 3 1
- Bolinas Community Public Utility District 1
- Bel Marin Keys Community Services District 1
- Willow Creek Community Services District 1
- Home Garden Community Services District 1
LAYER 3 ✖
- Special District 175
- County 2
- City 1
DES_TP 3
ACCESS_TYP 2
- Open Access 174
- Restricted Access 4
MNG_AG_TYP 1
- Community Services District · 178 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3018 | 3018 | 3017 | {"type": "Polygon", "coordinates": [[[-120.22896, 37.8407], [-120.22786, 37.84097], [-120.22634, 37.84146], [-120.22619, 37.84109], [-120.22604, 37.84066], [-120.22665, 37.8405], [-120.22662, 37.83992], [-120.22722, 37.83984], [-120.22824, 37.83973], [-120.22836, 37.84012], [-120.22861, 37.84009], [-120.22869, 37.84028], [-120.22896, 37.8407]]]} | Open Access 1 | 24323 | Mary Laveroni Community Park | 21935 | 2225 | Groveland Community Services District 575 | Special District 4 | Community Services District 19 | http://gcsd.org/ | Special District 4 | 2225 | Groveland Community Services District 567 | Special District 4 | Community Services District 17 | Tuolumne 21 | 6.919 | Mary Laveroni Community Park | 0 | Local Park 2 | 4 | |
3019 | 3019 | 3018 | {"type": "Polygon", "coordinates": [[[-120.23769, 38.03201], [-120.23715, 38.03226], [-120.237, 38.03217], [-120.23668, 38.03234], [-120.2365, 38.03222], [-120.23722, 38.03183], [-120.23702, 38.03158], [-120.23769, 38.03201]]]} | Open Access 1 | 24324 | Twain Harte Tennis Courts | 26608 | 2264 | Twain Harte Community Services District 574 | Special District 4 | Community Services District 19 | http://www.twainhartecsd.com/ | Special District 4 | 2264 | Twain Harte Community Services District 566 | Special District 4 | Community Services District 17 | Tuolumne 21 | 0.715 | Twain Harte Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
3094 | 3094 | 3093 | {"type": "Polygon", "coordinates": [[[-121.0891, 38.67807], [-121.08906, 38.67816], [-121.08906, 38.6783], [-121.0891, 38.67836], [-121.08909, 38.67867], [-121.08902, 38.67878], [-121.0889, 38.67884], [-121.08828, 38.67885], [-121.08817, 38.67887], [-121.08799, 38.67895], [-121.08788, 38.67891], [-121.08782, 38.67886], [-121.08764, 38.6788], [-121.08755, 38.6788], [-121.08693, 38.67865], [-121.08692, 38.67807], [-121.0891, 38.67807]]]} | Open Access 1 | 25179 | Kalithea Park | 20547 | 2197 | El Dorado Hills Community Service District 568 | Special District 4 | Community Services District 19 | http://www.edhcsd.org/ | Special District 4 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | El Dorado 34 | 3.826 | Kalithea Park | 0 | Local Park 2 | 4 | |
3095 | 3095 | 3094 | {"type": "Polygon", "coordinates": [[[-121.08995, 38.67612], [-121.08966, 38.67632], [-121.08929, 38.67632], [-121.08942, 38.67575], [-121.08946, 38.67572], [-121.0895, 38.67571], [-121.08958, 38.67574], [-121.08977, 38.67585], [-121.08987, 38.67597], [-121.08995, 38.67612]]]} | Open Access 1 | 25180 | Ridgeview 7 Park | 24357 | 2197 | El Dorado Hills Community Service District 568 | Special District 4 | Community Services District 19 | http://www.edhcsd.org/ | Special District 4 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | El Dorado 34 | 0.632 | Ridgeview 7 Park | 0 | Local Park 2 | 4 | |
3311 | 3311 | 3310 | {"type": "Polygon", "coordinates": [[[-121.00447, 38.69485], [-121.00424, 38.69495], [-121.00409, 38.6946], [-121.00391, 38.69442], [-121.0036, 38.69429], [-121.00345, 38.69439], [-121.00337, 38.69431], [-121.00353, 38.69419], [-121.00327, 38.69372], [-121.00274, 38.6933], [-121.00269, 38.693], [-121.00275, 38.69254], [-121.00265, 38.6919], [-121.0022, 38.69097], [-121.00192, 38.6906], [-121.0019, 38.69021], [-121.00147, 38.69024], [-121.00115, 38.68933], [-121.00361, 38.68935], [-121.00284, 38.6901], [-121.00321, 38.69093], [-121.00333, 38.69132], [-121.00341, 38.69159], [-121.00351, 38.6923], [-121.00395, 38.6938], [-121.00443, 38.69404], [-121.00427, 38.6946], [-121.00447, 38.69485]]]} | Open Access 1 | 29639 | Gateway Park | 19240 | 2212 | Cameron Park Community Services District 615 | Special District 4 | Community Services District 19 | http://www.cameronpark.org/parks_and_facilities.html | Special District 4 | 2212 | Cameron Park Community Services District 604 | Special District 4 | Community Services District 17 | El Dorado 34 | 13.424 | Gateway Park | 0 | Local Park 2 | 4 | |
3319 | 3319 | 3318 | {"type": "MultiPolygon", "coordinates": [[[[-124.16824, 40.85924], [-124.16709, 40.86133], [-124.16528, 40.86127], [-124.15926, 40.86121], [-124.15927, 40.86055], [-124.16009, 40.8591], [-124.16824, 40.85924]]], [[[-124.17983, 40.83876], [-124.17625, 40.84479], [-124.17547, 40.84606], [-124.17116, 40.85399], [-124.16888, 40.85808], [-124.16438, 40.85809], [-124.16426, 40.85767], [-124.16325, 40.85769], [-124.16253, 40.8578], [-124.16234, 40.85708], [-124.16173, 40.85708], [-124.16171, 40.85701], [-124.16406, 40.857], [-124.164, 40.85397], [-124.16796, 40.85399], [-124.16798, 40.84978], [-124.16822, 40.84977], [-124.16816, 40.84801], [-124.16989, 40.84799], [-124.1699, 40.84788], [-124.17062, 40.84787], [-124.17056, 40.84614], [-124.17287, 40.84609], [-124.17275, 40.84247], [-124.17293, 40.84245], [-124.17281, 40.83882], [-124.17788, 40.83876], [-124.17983, 40.83876]]]]} | Open Access 1 | 29677 | Manila Dunes Recreation Area | 6209 | 2319 | Manila Community Services District 618 | Special District 4 | Community Services District 19 | http://www.manilacsd.com/ | Special District 4 | 2319 | Manila Community Services District 607 | Special District 4 | Community Services District 17 | http://www.friendsofthedunes.org/resources/ | Humboldt 45 | 265.033 | Manila Dunes Rec. Area | 0 | Local Recreation Area 3 | 4 |
3321 | 3321 | 3320 | {"type": "Polygon", "coordinates": [[[-124.16247, 40.85177], [-124.16166, 40.85293], [-124.16151, 40.85317], [-124.15946, 40.85236], [-124.15859, 40.852], [-124.15866, 40.85177], [-124.15859, 40.8514], [-124.15856, 40.85106], [-124.15866, 40.85071], [-124.15889, 40.85049], [-124.15943, 40.85029], [-124.16022, 40.85014], [-124.16032, 40.85011], [-124.16004, 40.85044], [-124.16002, 40.85068], [-124.16191, 40.85144], [-124.162, 40.85158], [-124.16247, 40.85177]]]} | Open Access 1 | 29679 | Manila Community Park | 21749 | 2319 | Manila Community Services District 618 | Special District 4 | Community Services District 19 | http://www.manilacsd.com/ | Special District 4 | 2319 | Manila Community Services District 607 | Special District 4 | Community Services District 17 | Humboldt 45 | 15.038 | Manila Community Park | 0 | Local Park 2 | 4 | |
3345 | 3345 | 3344 | {"type": "Polygon", "coordinates": [[[-121.10145, 38.69128], [-121.10119, 38.69131], [-121.10095, 38.69131], [-121.1009, 38.6913], [-121.10073, 38.69131], [-121.1003, 38.69125], [-121.09981, 38.6911], [-121.0995, 38.69094], [-121.09923, 38.69073], [-121.09909, 38.69062], [-121.09902, 38.69053], [-121.09887, 38.69061], [-121.09794, 38.69096], [-121.09783, 38.69073], [-121.09782, 38.69058], [-121.09788, 38.69043], [-121.09815, 38.69016], [-121.09851, 38.68988], [-121.0986, 38.68968], [-121.10131, 38.68916], [-121.10149, 38.68991], [-121.10145, 38.69128]]]} | Open Access 1 | 24122 | Promontory Community Park | 24016 | 2197 | El Dorado Hills Community Service District 568 | Special District 4 | Community Services District 19 | http://www.edhcsd.org/ | Special District 4 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | El Dorado 34 | 12.49 | Promontory Community Park | 0 | Local Park 2 | 4 | |
3346 | 3346 | 3345 | {"type": "Polygon", "coordinates": [[[-120.98121, 38.68838], [-120.9796, 38.68963], [-120.97944, 38.6898], [-120.97775, 38.68919], [-120.98018, 38.68729], [-120.98102, 38.6879], [-120.98092, 38.68806], [-120.9809, 38.68811], [-120.98121, 38.68838]]]} | Open Access 1 | 24123 | Rasmussen Park | 24190 | 2212 | Cameron Park Community Services District 615 | Special District 4 | Community Services District 19 | http://www.cameronpark.org/parks_and_facilities.html | Special District 4 | 2212 | Cameron Park Community Services District 604 | Special District 4 | Community Services District 17 | El Dorado 34 | 9.847 | Rasmussen Park | 0 | Local Park 2 | 4 | |
3352 | 3352 | 3351 | {"type": "Polygon", "coordinates": [[[-124.10338, 40.95518], [-124.10286, 40.95518], [-124.10286, 40.95491], [-124.10338, 40.95491], [-124.10338, 40.95518]]]} | Open Access 1 | 24241 | Larissa Park | 21027 | 2238 | McKinleyville Community Services District 624 | Special District 4 | Community Services District 19 | http://mckinleyvillecsd.com/ | Special District 4 | 2238 | McKinleyville Community Services District 613 | Special District 4 | Community Services District 17 | Humboldt 45 | 0.324 | Larissa Park | 0 | Local Park 2 | 4 | |
3368 | 3368 | 3367 | {"type": "Polygon", "coordinates": [[[-120.22752, 37.84921], [-120.22678, 37.84949], [-120.22674, 37.84968], [-120.22664, 37.85002], [-120.22645, 37.85003], [-120.22647, 37.84962], [-120.22639, 37.84956], [-120.22598, 37.84877], [-120.22683, 37.84863], [-120.22716, 37.84872], [-120.22752, 37.84921]]]} | Open Access 1 | 24325 | Leon Rose Ball Park | 21170 | 2225 | Groveland Community Services District 575 | Special District 4 | Community Services District 19 | http://gcsd.org/ | Special District 4 | 2225 | Groveland Community Services District 567 | Special District 4 | Community Services District 17 | Tuolumne 21 | 2.504 | Leon Rose Ball Park | 0 | Local Recreation Area 3 | 4 | |
3559 | 3559 | 3558 | {"type": "Polygon", "coordinates": [[[-121.37535, 38.41303], [-121.37525, 38.41306], [-121.37525, 38.41445], [-121.37472, 38.41457], [-121.37452, 38.41458], [-121.37452, 38.41431], [-121.37455, 38.4143], [-121.37454, 38.41261], [-121.37525, 38.41261], [-121.37525, 38.41292], [-121.37535, 38.41296], [-121.37535, 38.41303]]]} | Open Access 1 | 28336 | Beeman Park | 15953 | 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.279 | Beeman 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 | |
3586 | 3586 | 3585 | {"type": "Polygon", "coordinates": [[[-120.11203, 39.33019], [-120.08116, 39.33018], [-120.08102, 39.32357], [-120.08615, 39.32375], [-120.08611, 39.31645], [-120.10961, 39.31639], [-120.10962, 39.32423], [-120.10845, 39.3243], [-120.10845, 39.32716], [-120.11194, 39.32719], [-120.11203, 39.33019]]]} | Restricted Access 2 | 37007 | Waddle Ranch | 27205 | 2329 | Truckee Tahoe Airport District 663 | Special District 4 | Community Services District 19 | http://www.truckeetahoeairport.com/ | Special District 4 | 2329 | Truckee Tahoe Airport District 651 | Special District 4 | Community Services District 17 | Nevada 30 | 851.88 | Waddle Ranch | 0 | Local Other or Unknown 14 | 4 | |
3746 | 3746 | 3745 | {"type": "Polygon", "coordinates": [[[-117.57139, 33.96796], [-117.57095, 33.96793], [-117.57034, 33.96782], [-117.56983, 33.96767], [-117.56909, 33.96739], [-117.56852, 33.96724], [-117.56786, 33.96714], [-117.56726, 33.96712], [-117.56721, 33.96707], [-117.5672, 33.9647], [-117.57139, 33.9647], [-117.57139, 33.96796]]]} | Open Access 1 | 44902 | Harada Heritage Park | 19658 | 2331 | Jurupa Community Services District 677 | Special District 4 | Community Services District 19 | http://parks.jcsd.us/ | Special District 4 | 2331 | Jurupa Community Services District 667 | Special District 4 | Community Services District 17 | Riverside 10 | 29.71 | Harada Heritage 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 | |
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 |
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 |
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 |
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 |
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]);