units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
33 rows where COUNTY = 34 and MNG_AG_TYP = 17 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, PARK_URL
DES_TP 5
- Local Park 27
- Local Recreation Area 3
- None 1
- None 1
- None 1
MNG_AGENCY 2
MNG_AG_TYP 1
- Community Services District · 33 ✖
ACCESS_TYP 1
- Open Access 33
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8335 | 8335 | 8334 | {"type": "Polygon", "coordinates": [[[-121.07801, 38.69279], [-121.07777, 38.69282], [-121.07777, 38.69263], [-121.07784, 38.69262], [-121.07786, 38.69264], [-121.07792, 38.69263], [-121.07799, 38.69273], [-121.07801, 38.69279]]]} | Open Access 1 | 47800 | New York Creek Nature Trail | 30318 | 2220 | El Dorado Irrigation District 890 | Special District 4 | Irrigation District 17 | http://www.eid.org/ | Special District 4 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | http://www.eldoradohillscsd.org/images/park_detail_popups/new-york-creek/index.html | El Dorado 34 | 0.089 | New York Creek Nature Trail | 0 | Local Recreation Area 3 | 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 | |
11811 | 11811 | 11810 | {"type": "Polygon", "coordinates": [[[-121.08312, 38.72492], [-121.0827, 38.72511], [-121.08247, 38.72512], [-121.08193, 38.72491], [-121.08218, 38.7245], [-121.08229, 38.72445], [-121.08292, 38.72473], [-121.08302, 38.7248], [-121.08312, 38.72492]]]} | Open Access 1 | 24115 | Waterford Park | 27301 | 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 | 1.124 | Waterford Park | 0 | Local Park 2 | 4 | |
11823 | 11823 | 11822 | {"type": "Polygon", "coordinates": [[[-121.08134, 38.6789], [-121.08127, 38.67928], [-121.08123, 38.67938], [-121.08117, 38.6794], [-121.08087, 38.67935], [-121.08077, 38.67935], [-121.08013, 38.679], [-121.08033, 38.67879], [-121.08048, 38.67884], [-121.08055, 38.67877], [-121.08134, 38.6789]]]} | Open Access 1 | 24129 | Parkview Heights Park | 23453 | 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 | 1.189 | Parkview Heights Park | 0 | Local Park 2 | 4 | |
11813 | 11813 | 11812 | {"type": "Polygon", "coordinates": [[[-121.08054, 38.71563], [-121.08029, 38.71595], [-121.0802, 38.71616], [-121.0794, 38.71598], [-121.07939, 38.71593], [-121.07934, 38.71588], [-121.07936, 38.71581], [-121.07947, 38.71572], [-121.07949, 38.71566], [-121.08005, 38.71544], [-121.08054, 38.71563]]]} | Open Access 1 | 24117 | Overlook Park | 23274 | 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 | 1.228 | Overlook Park | 0 | Local Park 2 | 4 | |
11817 | 11817 | 11816 | {"type": "Polygon", "coordinates": [[[-121.08312, 38.70091], [-121.08287, 38.70141], [-121.08273, 38.70162], [-121.08237, 38.70232], [-121.08226, 38.70235], [-121.08189, 38.70233], [-121.08201, 38.70199], [-121.08207, 38.7019], [-121.08293, 38.70099], [-121.08302, 38.70094], [-121.08305, 38.7009], [-121.08312, 38.70091]]]} | Open Access 1 | 24121 | William C. "Bill" McCabe Park | 30311 | 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 | 1.289 | William C. "Bill" McCabe Park | 0 | Local Park 2 | 4 | |
4199 | 4199 | 4198 | {"type": "Polygon", "coordinates": [[[-121.0866, 38.7185], [-121.08687, 38.71847], [-121.08692, 38.71849], [-121.08695, 38.71853], [-121.08696, 38.71876], [-121.08689, 38.71901], [-121.08671, 38.71933], [-121.08654, 38.71952], [-121.08646, 38.71954], [-121.08591, 38.71931], [-121.08598, 38.7192], [-121.08625, 38.71901], [-121.0866, 38.7185]]]} | Open Access 1 | 44915 | Windsor Point Park | 27639 | 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 | 1.408 | Windsor Point Park | 0 | Local Park 2 | 4 | |
14653 | 14653 | 14652 | {"type": "Polygon", "coordinates": [[[-121.01514, 38.66851], [-121.01406, 38.66856], [-121.01397, 38.6684], [-121.01397, 38.66777], [-121.01416, 38.66778], [-121.01435, 38.66781], [-121.01455, 38.66787], [-121.01474, 38.66797], [-121.01488, 38.66808], [-121.015, 38.66821], [-121.01509, 38.66836], [-121.01514, 38.66851]]]} | Open Access 1 | 44913 | Laurel Oaks Park | 21097 | 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 | 1.627 | Laurel Oaks Park | 0 | Local Park 2 | 4 | |
16426 | 16426 | 16425 | {"type": "Polygon", "coordinates": [[[-121.09169, 38.69101], [-121.09086, 38.69117], [-121.09074, 38.69053], [-121.09067, 38.69035], [-121.09169, 38.69017], [-121.09169, 38.69101]]]} | Open Access 1 | 45332 | Regional Park | 24275 | 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 | 1.86 | RP | 0 | Local Park 2 | 4 | |
11821 | 11821 | 11820 | {"type": "Polygon", "coordinates": [[[-121.08212, 38.68281], [-121.08198, 38.68301], [-121.08203, 38.68353], [-121.08195, 38.68374], [-121.08166, 38.68369], [-121.08134, 38.68369], [-121.08131, 38.68368], [-121.08129, 38.68365], [-121.08118, 38.68262], [-121.08156, 38.68261], [-121.08186, 38.68273], [-121.08212, 38.68281]]]} | Open Access 1 | 24127 | Governor's Park | 30313 | 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 | http://www.eldoradohillscsd.org/images/park_detail_popups/governors/index.html | El Dorado 34 | 1.921 | Governor's Park | 0 | Local Park 2 | 4 |
4331 | 4331 | 4330 | {"type": "Polygon", "coordinates": [[[-120.97333, 38.67984], [-120.97344, 38.67985], [-120.97355, 38.67989], [-120.97363, 38.67997], [-120.97367, 38.68004], [-120.97367, 38.68086], [-120.97365, 38.68088], [-120.97361, 38.68089], [-120.97303, 38.68087], [-120.97276, 38.68084], [-120.97273, 38.68079], [-120.97279, 38.68048], [-120.9728, 38.67987], [-120.97286, 38.67984], [-120.97333, 38.67984]]]} | Open Access 1 | 45512 | Eastwood Park | 28346 | 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 | 2.155 | Eastwood Park | 0 | Local Park 2 | 4 | |
11822 | 11822 | 11821 | {"type": "Polygon", "coordinates": [[[-121.01135, 38.68107], [-121.0111, 38.68112], [-121.01067, 38.68124], [-121.00999, 38.68139], [-121.00996, 38.68138], [-121.00993, 38.68134], [-121.00968, 38.68065], [-121.01065, 38.68045], [-121.01076, 38.6805], [-121.01089, 38.68053], [-121.01103, 38.68053], [-121.01121, 38.6805], [-121.01135, 38.68107]]]} | Open Access 1 | 24128 | Oak Knoll Park | 22984 | 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 | 2.585 | Oak Knoll Park | 0 | Local Park 2 | 4 | |
11829 | 11829 | 11828 | {"type": "Polygon", "coordinates": [[[-121.00711, 38.65544], [-121.00546, 38.65556], [-121.00537, 38.65489], [-121.0066, 38.65449], [-121.00711, 38.65544]]]} | Open Access 1 | 24136 | Dave West Park | 17937 | 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 | 2.985 | Dave West Park | 0 | Local Park 2 | 4 | |
12151 | 12151 | 12150 | {"type": "Polygon", "coordinates": [[[-121.06525, 38.64755], [-121.06521, 38.64759], [-121.06334, 38.64831], [-121.06334, 38.64702], [-121.06368, 38.64696], [-121.06368, 38.64703], [-121.06373, 38.64709], [-121.06385, 38.64714], [-121.06401, 38.64713], [-121.06507, 38.64717], [-121.06511, 38.6472], [-121.06515, 38.64733], [-121.06525, 38.64751], [-121.06525, 38.64755]]]} | Open Access 1 | 25186 | Creekside Greens Park | 17768 | 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.69 | Creekside Greens Park | 0 | Local Park 2 | 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 | |
11815 | 11815 | 11814 | {"type": "Polygon", "coordinates": [[[-121.07765, 38.70194], [-121.07763, 38.70294], [-121.07756, 38.70315], [-121.07742, 38.70337], [-121.07664, 38.70416], [-121.07655, 38.70403], [-121.07645, 38.70406], [-121.0764, 38.70397], [-121.07654, 38.70354], [-121.07666, 38.70356], [-121.07671, 38.7034], [-121.07675, 38.70231], [-121.07662, 38.70208], [-121.07721, 38.70193], [-121.07765, 38.70194]]]} | Open Access 1 | 24119 | Fairchild Park | 18792 | 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.892 | Fairchild Park | 0 | Local Park 2 | 4 | |
11814 | 11814 | 11813 | {"type": "Polygon", "coordinates": [[[-121.06721, 38.70733], [-121.06473, 38.70733], [-121.06458, 38.70688], [-121.06461, 38.70684], [-121.06463, 38.70684], [-121.06503, 38.70678], [-121.06551, 38.70666], [-121.06595, 38.7065], [-121.06639, 38.70628], [-121.06644, 38.70628], [-121.06649, 38.70632], [-121.06656, 38.70644], [-121.06665, 38.70677], [-121.06671, 38.70682], [-121.06678, 38.70685], [-121.06693, 38.70684], [-121.06721, 38.70733]]]} | Open Access 1 | 24118 | Murray Homestead Park | 22611 | 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 | 4.025 | Murray Homestead Park | 0 | Local Park 2 | 4 | |
2993 | 2993 | 2992 | {"type": "Polygon", "coordinates": [[[-121.08061, 38.70247], [-121.08014, 38.70268], [-121.07972, 38.70295], [-121.07911, 38.70345], [-121.07912, 38.70276], [-121.07907, 38.70225], [-121.07913, 38.70177], [-121.07908, 38.70147], [-121.07996, 38.7012], [-121.08061, 38.70247]]]} | Open Access 1 | 24120 | Weisberg Park | 27333 | 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 | 4.833 | Weisberg Park | 0 | Local Park 2 | 4 | |
11818 | 11818 | 11817 | {"type": "Polygon", "coordinates": [[[-120.99851, 38.687], [-120.99798, 38.68699], [-120.99664, 38.68697], [-120.99692, 38.68616], [-120.99728, 38.68594], [-120.9979, 38.68595], [-120.99791, 38.68554], [-120.99829, 38.6853], [-120.99851, 38.68553], [-120.99851, 38.687]]]} | Open Access 1 | 24124 | Cameron Park Lake | 16763 | 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 | 4.891 | Cameron Park Lake | None 1040 | |||
11827 | 11827 | 11826 | {"type": "Polygon", "coordinates": [[[-120.97689, 38.66644], [-120.97663, 38.66629], [-120.97415, 38.66658], [-120.9732, 38.66697], [-120.97297, 38.66712], [-120.97286, 38.6669], [-120.97405, 38.6665], [-120.97542, 38.66632], [-120.97556, 38.66598], [-120.97435, 38.66468], [-120.9748, 38.6645], [-120.97485, 38.66452], [-120.9763, 38.66567], [-120.97663, 38.66601], [-120.97682, 38.66628], [-120.97689, 38.66644]]]} | Open Access 1 | 24132 | Hacienda Park | 19590 | 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 | 4.93 | Hacienda 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]);