superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
193 rows where MNG_AG_TYP = 17 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Consumnes Community Services District 84
- El Dorado Hills Community Service District 22
- Jurupa Community Services District 10
- Cameron Park Community Services District 8
- Mountain House Community Services District 7
- Brooktrails Community Services District 3
- McKinleyville Community Services District 3
- Marinwood Community Service District 3
- Rossmore Community Services District 2
- Groveland Community Services District 2
- Manila Community Services District 2
- Tamalpais Community Services District 2
- Helendale Community Services District 2
- Salton Community Services District 2
- Templeton Community Services District 2
- Discovery Bay Community Service District 1
- Scotia Community Services District 1
- Bear Valley Springs Community Services District 1
- Morongo Valley Community Services District 1
- Twain Harte Community Services District 1
- Truckee Tahoe Airport District 1
- Cambria Community Services District 1
- Aromona Community Services District 1
- Rosamond Community Services District 1
- Golden Hills Community Service District 1
- Pajaro Community Services District 1
- Happy Camp Community Services District 1
- McCloud Community Services District 1
- Lake Shastina Community Services District 1
- Concord Landscaping and Lighting Maintenance District No. 3 1
- …
ACCESS_TYP 2
- Open Access 170
- Restricted Access 3
MNG_AG_TYP 1
- Community Services District · 173 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15501 | 15501 | 15500 | {"type": "Polygon", "coordinates": [[[-121.55275, 37.77019], [-121.55274, 37.77025], [-121.55235, 37.77066], [-121.55227, 37.77066], [-121.55182, 37.77042], [-121.55178, 37.77039], [-121.55175, 37.77033], [-121.55176, 37.77027], [-121.55198, 37.76992], [-121.55207, 37.76988], [-121.55216, 37.76989], [-121.55236, 37.76998], [-121.55275, 37.77019]]]} | Open Access 1 | Mountain House Community Services District 1 | 22541 | 2288 | Mountain House Community Services District 690 | Special District 4 | Community Services District 17 | http://www.mhcsd.com/ | Special District 4 | 1.157 | Mtn. House Community Services District 1 | ||
7964 | 7964 | 7963 | {"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 | Parkview Heights Park | 23453 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | http://www.edhcsd.org/ | Special District 4 | 1.189 | Parkview Heights Park | ||
8945 | 8945 | 8944 | {"type": "Polygon", "coordinates": [[[-121.43863, 38.43772], [-121.43838, 38.43792], [-121.43823, 38.43809], [-121.43811, 38.43825], [-121.43804, 38.43825], [-121.43772, 38.43819], [-121.43758, 38.43818], [-121.43758, 38.43792], [-121.4376, 38.43791], [-121.4376, 38.43763], [-121.43808, 38.43762], [-121.43828, 38.43757], [-121.43842, 38.4375], [-121.43863, 38.43772]]]} | Open Access 1 | Rose Park | 24615 | 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.189 | Rose 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 | ||
7821 | 7821 | 7820 | {"type": "Polygon", "coordinates": [[[-121.08054, 38.71563], [-121.08029, 38.71594], [-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 | Overlook Park | 23274 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | http://www.edhcsd.org/ | Special District 4 | 1.228 | Overlook Park | ||
13083 | 13083 | 13082 | {"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 | William C. "Bill" McCabe Park | 30311 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | http://www.edhcsd.org/ | Special District 4 | 1.289 | William C. "Bill" McCabe Park | ||
9381 | 9381 | 9380 | {"type": "Polygon", "coordinates": [[[-121.42725, 38.38731], [-121.42685, 38.38738], [-121.42634, 38.38715], [-121.42628, 38.3868], [-121.42631, 38.38663], [-121.42635, 38.3866], [-121.42638, 38.3866], [-121.42673, 38.38667], [-121.42716, 38.38672], [-121.42718, 38.38676], [-121.42719, 38.38706], [-121.42725, 38.38725], [-121.42725, 38.38731]]]} | Open Access 1 | Schauer Park | 25180 | 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.345 | Schauer Park | ||
6942 | 6942 | 6941 | {"type": "Polygon", "coordinates": [[[-121.36833, 38.41587], [-121.36808, 38.41626], [-121.36736, 38.41626], [-121.36722, 38.41588], [-121.36764, 38.41547], [-121.3682, 38.41581], [-121.36833, 38.41587]]]} | Open Access 1 | Mendoza Park | 22154 | 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.363 | Mendoza Park | ||
11331 | 11331 | 11330 | {"type": "Polygon", "coordinates": [[[-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], [-121.08687, 38.71847], [-121.08692, 38.71849], [-121.08695, 38.71853]]]} | Open Access 1 | Windsor Point Park | 27639 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | http://www.edhcsd.org/ | Special District 4 | 1.408 | Windsor Point 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 | ||
6265 | 6265 | 6264 | {"type": "Polygon", "coordinates": [[[-121.46779, 38.42567], [-121.4669, 38.42567], [-121.4669, 38.42497], [-121.46779, 38.42497], [-121.46779, 38.42567]]]} | Open Access 1 | Lippincott Park | 21330 | 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.494 | Lippincott 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 | ||
2705 | 2705 | 2704 | {"type": "Polygon", "coordinates": [[[-121.45641, 38.41232], [-121.45637, 38.41234], [-121.45607, 38.41261], [-121.45601, 38.41264], [-121.45598, 38.41269], [-121.45598, 38.41275], [-121.45568, 38.41281], [-121.45527, 38.41284], [-121.4552, 38.41222], [-121.45618, 38.41213], [-121.45635, 38.41206], [-121.45638, 38.41206], [-121.45641, 38.41232]]]} | Open Access 1 | Caterino Park | 16972 | 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.507 | Caterino Park | ||
2200 | 2200 | 2199 | {"type": "Polygon", "coordinates": [[[-121.44595, 38.39725], [-121.44596, 38.39751], [-121.44588, 38.39779], [-121.44581, 38.39779], [-121.44572, 38.39782], [-121.44567, 38.39787], [-121.44566, 38.39795], [-121.44533, 38.39799], [-121.445, 38.39799], [-121.44499, 38.39769], [-121.44494, 38.39755], [-121.44486, 38.39741], [-121.44485, 38.39738], [-121.44487, 38.39736], [-121.44495, 38.39732], [-121.44509, 38.39729], [-121.44595, 38.39725]]]} | Open Access 1 | Bradford Park | 16325 | 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.547 | Bradford Park | ||
7690 | 7690 | 7689 | {"type": "Polygon", "coordinates": [[[-121.40107, 38.41322], [-121.401, 38.41338], [-121.40095, 38.41356], [-121.39933, 38.41331], [-121.39933, 38.41265], [-121.39966, 38.41265], [-121.39971, 38.41282], [-121.39981, 38.41296], [-121.39995, 38.41307], [-121.40013, 38.41315], [-121.40034, 38.4132], [-121.40068, 38.4132], [-121.40084, 38.41325], [-121.40091, 38.41324], [-121.40099, 38.41319], [-121.40107, 38.41322]]]} | Open Access 1 | Oneto Park | 23144 | 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.614 | Oneto Park | ||
6044 | 6044 | 6043 | {"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.01473, 38.66797], [-121.01488, 38.66808], [-121.015, 38.66821], [-121.01509, 38.66836], [-121.01514, 38.66851]]]} | Open Access 1 | Laurel Oaks Park | 21097 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | http://www.edhcsd.org/ | Special District 4 | 1.626 | Laurel Oaks Park | ||
8099 | 8099 | 8098 | {"type": "Polygon", "coordinates": [[[-121.35789, 38.44863], [-121.35783, 38.44864], [-121.35668, 38.44864], [-121.35664, 38.4486], [-121.35664, 38.44812], [-121.35783, 38.44803], [-121.35789, 38.44863]]]} | Open Access 1 | Perry Park | 23615 | 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.657 | Perry Park | ||
8092 | 8092 | 8091 | {"type": "Polygon", "coordinates": [[[-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], [-121.47989, 38.41113], [-121.48031, 38.41123], [-121.48033, 38.41127]]]} | Open Access 1 | Perez Park | 23609 | 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.695 | Perez Park | ||
9740 | 9740 | 9739 | {"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.39942], [-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 | Smedberg Park | 25564 | 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.724 | Smedberg Park | ||
13418 | 13418 | 13417 | {"type": "Polygon", "coordinates": [[[-121.34857, 38.4502], [-121.34854, 38.45042], [-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.34756, 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]]]} | Open Access 1 | Jordan Family Park | http://www.yourcsd.com/604/Jordan-Family-Park | 30805 | 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.741 | Jordan Family 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]);