superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
193 rows where MNG_AG_TYP = 17
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Consumnes Community Services District 77
- El Dorado Hills Community Service District 21
- Cameron Park Community Services District 6
- Jurupa Community Services District 5
- McKinleyville Community Services District 4
- Tamalpais Community Services District 4
- Brooktrails Community Services District 3
- Mountain House Community Services District 3
- Rossmore Community Services District 2
- Groveland Community Services District 2
- Indian Valley 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
- Twain Harte Community Services District 1
- Manila Community Services District 1
- Truckee Tahoe Airport District 1
- Cambria Community Services District 1
- Aromona Community Services District 1
- Rosamond Community Services District 1
- Los Alamos Community Services District 1
- Marinwood Community Service District 1
- Golden Hills Community Service District 1
- Pajaro Community Services District 1
- Happy Camp Community Services District 1
- McCloud Community Services District 1
- Concord Landscaping and Lighting Maintenance District No. 3 1
- Tomales Village Community Services District 1
- Bolinas Community Public Utility District 1
- …
ACCESS_TYP 2
- Open Access 150
- Restricted Access 3
MNG_AG_TYP 1
- Community Services District · 153 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3450 | 3450 | 3449 | {"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 | Dave West Park | 17937 | 2212 | Cameron Park Community Services District 604 | Special District 4 | Community Services District 17 | http://www.cameronpark.org/parks_and_facilities.html | Special District 4 | 2.985 | Dave West Park | ||
3461 | 3461 | 3460 | {"type": "Polygon", "coordinates": [[[-121.42939, 38.43453], [-121.42935, 38.43456], [-121.42833, 38.43455], [-121.42829, 38.43454], [-121.42826, 38.43451], [-121.42826, 38.43426], [-121.42828, 38.43405], [-121.42867, 38.43409], [-121.42881, 38.43413], [-121.42894, 38.43423], [-121.42903, 38.43435], [-121.42936, 38.43427], [-121.42939, 38.43439], [-121.4294, 38.4345], [-121.42939, 38.43453]]]} | Open Access 1 | Davis Park | 17953 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 0.997 | Davis Park | ||
3585 | 3585 | 3584 | {"type": "Polygon", "coordinates": [[[-116.04381, 33.39702], [-116.04133, 33.39703], [-116.0414, 33.39595], [-116.04174, 33.39592], [-116.04355, 33.39591], [-116.04381, 33.39702]]]} | Open Access 1 | Desert Shores Community Park | 18115 | 2256 | Salton Community Services District 960 | Special District 4 | Community Services District 17 | http://www.saltoncsd.ca.gov/ | Special District 4 | 6.525 | Desert Shores Community Park | ||
3818 | 3818 | 3817 | {"type": "Polygon", "coordinates": [[[-122.54672, 37.88164], [-122.54632, 37.88222], [-122.54589, 37.88254], [-122.54547, 37.88191], [-122.54505, 37.88169], [-122.54439, 37.88158], [-122.54375, 37.88128], [-122.54384, 37.88108], [-122.54411, 37.88099], [-122.54487, 37.88104], [-122.54549, 37.88137], [-122.54632, 37.88105], [-122.54637, 37.88107], [-122.54665, 37.88126], [-122.54672, 37.88164]]]} | Open Access 1 | Eastwood Park | 18405 | 2261 | Tamalpais Community Services District 708 | Special District 4 | Community Services District 17 | http://www.tcsd.us/ | Special District 4 | 5.017 | Eastwood Park | ||
3858 | 3858 | 3857 | {"type": "Polygon", "coordinates": [[[-121.07928, 38.68615], [-121.07845, 38.68653], [-121.07832, 38.68668], [-121.07853, 38.68683], [-121.07853, 38.68689], [-121.07838, 38.68697], [-121.07784, 38.68651], [-121.07652, 38.68617], [-121.07596, 38.68613], [-121.07538, 38.68614], [-121.0746, 38.68624], [-121.07391, 38.68547], [-121.07383, 38.68545], [-121.07385, 38.68538], [-121.07382, 38.68531], [-121.07378, 38.68528], [-121.07385, 38.68519], [-121.07372, 38.68482], [-121.07338, 38.68436], [-121.076, 38.68331], [-121.07628, 38.68371], [-121.07675, 38.68419], [-121.07723, 38.68452], [-121.07795, 38.68496], [-121.07845, 38.68531], [-121.07902, 38.68582], [-121.07928, 38.68615]]]} | Open Access 1 | EDH Community Park | 18443 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | http://www.edhcsd.org/ | Special District 4 | 25.02 | EDH Community Park | ||
3874 | 3874 | 3873 | {"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.44864, 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 | Ehrhardt Oaks Park | 18470 | 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.749 | Ehrhardt Oaks Park | ||
3891 | 3891 | 3890 | {"type": "Polygon", "coordinates": [[[-121.09069, 38.6912], [-121.08762, 38.69179], [-121.08736, 38.69099], [-121.09049, 38.69039], [-121.09059, 38.69061], [-121.09069, 38.6912]]]} | Open Access 1 | El Dorado Hills Community Service District 1 | 18501 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | http://www.edhcsd.org/ | Special District 4 | 6.377 | El Dorado Hills Community Service District 1 | ||
3939 | 3939 | 3938 | {"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 | Elk Grove Park | 18562 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 123.144 | Elk Grove Park | ||
4109 | 4109 | 4108 | {"type": "Polygon", "coordinates": [[[-120.69928, 35.55395], [-120.69932, 35.55471], [-120.69929, 35.55506], [-120.69913, 35.5555], [-120.69877, 35.55592], [-120.69793, 35.5567], [-120.69731, 35.5564], [-120.69876, 35.55393], [-120.69928, 35.55395]]]} | Open Access 1 | Evers Park | 18770 | 2289 | Templeton Community Services District 1000 | Special District 4 | Community Services District 17 | http://templetoncsd.org | Special District 4 | 6.748 | Evers Park | ||
4129 | 4129 | 4128 | {"type": "Polygon", "coordinates": [[[-121.07765, 38.70194], [-121.07763, 38.70294], [-121.07756, 38.70315], [-121.07742, 38.70337], [-121.07664, 38.70416], [-121.07656, 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 | Fairchild Park | 18792 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | http://www.edhcsd.org/ | Special District 4 | 3.894 | Fairchild 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 | ||
4190 | 4190 | 4189 | {"type": "Polygon", "coordinates": [[[-120.28014, 34.74428], [-120.28011, 34.74478], [-120.27969, 34.74476], [-120.27972, 34.74426], [-120.28014, 34.74428]]]} | Open Access 1 | Ferini Park | 18873 | 2065 | Los Alamos Community Services District 887 | Special District 4 | Community Services District 17 | http://www.losalamoscsd.com/ | Special District 4 | 0.526 | Ferini Park | ||
4198 | 4198 | 4197 | {"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 | Feickert Park | 18864 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 4.177 | Feickert Park | ||
4257 | 4257 | 4256 | {"type": "Polygon", "coordinates": [[[-121.33921, 38.42094], [-121.33921, 38.42132], [-121.33772, 38.42183], [-121.33772, 38.4211], [-121.33809, 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 | Fleming Park | 18945 | 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.992 | Fleming Park | ||
4293 | 4293 | 4292 | {"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 | Foulks Park | 19017 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 4.879 | Foulks Park | ||
4463 | 4463 | 4462 | {"type": "Polygon", "coordinates": [[[-121.3732, 38.44851], [-121.37316, 38.44859], [-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 | Gage Park | 19170 | 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.148 | Gage Park | ||
4465 | 4465 | 4464 | {"type": "Polygon", "coordinates": [[[-123.37488, 41.79526], [-123.37479, 41.79527], [-123.37464, 41.79551], [-123.37252, 41.79546], [-123.37205, 41.79325], [-123.3725, 41.79301], [-123.37448, 41.79406], [-123.37488, 41.79526]]]} | Open Access 1 | Gale Zinc Memorial Park | 19173 | 2226 | Happy Camp Community Services District 958 | Special District 4 | Community Services District 17 | Special District 4 | 10.657 | Gale Zinc Memorial Park | |||
4517 | 4517 | 4516 | {"type": "Polygon", "coordinates": [[[-121.34956, 38.40229], [-121.34941, 38.40396], [-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 | Gates Park | 19233 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2.445 | Gates Park | ||
4525 | 4525 | 4524 | {"type": "Polygon", "coordinates": [[[-121.00447, 38.69485], [-121.00424, 38.69495], [-121.00409, 38.6946], [-121.00391, 38.69442], [-121.00361, 38.69429], [-121.00345, 38.69439], [-121.00337, 38.69431], [-121.00352, 38.69419], [-121.00328, 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.69022], [-121.00147, 38.69024], [-121.00115, 38.68933], [-121.00361, 38.68935], [-121.00284, 38.69011], [-121.00321, 38.69093], [-121.00333, 38.69132], [-121.00341, 38.69159], [-121.00351, 38.6923], [-121.00395, 38.69379], [-121.00443, 38.69404], [-121.00427, 38.6946], [-121.00447, 38.69485]]]} | Open Access 1 | Gateway Park | 19240 | 2212 | Cameron Park Community Services District 604 | Special District 4 | Community Services District 17 | http://www.cameronpark.org/parks_and_facilities.html | Special District 4 | 13.441 | Gateway Park | ||
4803 | 4803 | 4802 | {"type": "Polygon", "coordinates": [[[-124.10901, 40.47901], [-124.10855, 40.47903], [-124.10832, 40.47893], [-124.10793, 40.47776], [-124.10611, 40.47501], [-124.10671, 40.47476], [-124.10793, 40.47525], [-124.1085, 40.47611], [-124.10879, 40.47677], [-124.10904, 40.47753], [-124.10909, 40.47838], [-124.10901, 40.47901]]]} | Open Access 1 | Scotia Fireman's Park | http://scotiacsd.com/parks-recreation/ | 33638 | 2438 | Scotia Community Services District 362 | Special District 4 | Community Services District 17 | http://scotiacsd.com/ | Special District 4 | 12.732 | Scotia Fireman's 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]);