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 AGNCY_WEB descending
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL, YR_EST
MNG_AGENCY >30
- Consumnes Community Services District 92
- El Dorado Hills Community Service District 24
- Jurupa Community Services District 10
- Cameron Park Community Services District 8
- Mountain House Community Services District 7
- McKinleyville Community Services District 4
- Tamalpais Community Services District 4
- Brooktrails Community Services District 3
- Marinwood Community Service District 3
- Rossmore Community Services District 2
- Twain Harte Community Services District 2
- Groveland Community Services District 2
- Manila Community Services District 2
- Indian Valley Community Services District 2
- Helendale Community Services District 2
- Pajaro 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
- 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
- Golden Hills Community Service District 1
- Happy Camp Community Services District 1
- McCloud Community Services District 1
- …
ACCESS_TYP 2
- Open Access 190
- Restricted Access 3
MNG_AG_TYP 1
- Community Services District · 193 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6686 | 6686 | 6685 | {"type": "Polygon", "coordinates": [[[-121.61579, 37.90931], [-121.61435, 37.90927], [-121.61438, 37.90837], [-121.61578, 37.90838], [-121.61579, 37.90931]]]} | Open Access 1 | Ravenswood Park | 33651 | 2439 | Discovery Bay Community Service District 311 | Special District 4 | Community Services District 17 | https://www.todb.ca.gov/district-services | Special District 4 | 3.14 | Ravenswood Park | ||
767 | 767 | 766 | {"type": "Polygon", "coordinates": [[[-117.32813, 34.76673], [-117.32803, 34.7693], [-117.32577, 34.76927], [-117.32577, 34.76773], [-117.32645, 34.76704], [-117.32646, 34.76671], [-117.32813, 34.76673]]]} | Open Access 1 | Helendale Community Park | https://www.helendalecsd.org/parks_facilities.html | 32710 | 2424 | Helendale Community Services District 943 | Special District 4 | Community Services District 17 | https://www.helendalecsd.org/parks_facilities.html | Special District 4 | 13.717 | Helendale Community Park | 2017 |
768 | 768 | 767 | {"type": "Polygon", "coordinates": [[[-117.32919, 34.76299], [-117.32823, 34.76319], [-117.32818, 34.76317], [-117.32818, 34.76226], [-117.32889, 34.76227], [-117.32893, 34.76248], [-117.32907, 34.76281], [-117.32919, 34.76299]]]} | Open Access 1 | Helendale Dog Park | https://helendalecsd.recdesk.com/Community/Page?pageId=18185 | 32711 | 2424 | Helendale Community Services District 943 | Special District 4 | Community Services District 17 | https://www.helendalecsd.org/parks_facilities.html | Special District 4 | 1.769 | Helendale Dog Park | |
11678 | 11678 | 11677 | {"type": "MultiPolygon", "coordinates": [[[[-118.49465, 35.14436], [-118.49464, 35.14953], [-118.4946, 35.14955], [-118.4946, 35.1501], [-118.49463, 35.15012], [-118.49463, 35.15082], [-118.49403, 35.15081], [-118.49371, 35.15099], [-118.49364, 35.1511], [-118.49376, 35.15121], [-118.49424, 35.15122], [-118.49428, 35.15128], [-118.49437, 35.15135], [-118.49439, 35.15143], [-118.49413, 35.15151], [-118.49412, 35.15165], [-118.49324, 35.15248], [-118.49221, 35.152], [-118.49212, 35.1516], [-118.49201, 35.15146], [-118.4917, 35.15129], [-118.49146, 35.15154], [-118.49123, 35.15154], [-118.49069, 35.15129], [-118.4906, 35.15105], [-118.48981, 35.15079], [-118.48982, 35.15074], [-118.48987, 35.15064], [-118.48985, 35.15056], [-118.49001, 35.15029], [-118.48969, 35.15002], [-118.48945, 35.15024], [-118.48833, 35.14962], [-118.48757, 35.14975], [-118.48742, 35.14914], [-118.48597, 35.14879], [-118.48547, 35.14913], [-118.48536, 35.14981], [-118.48559, 35.15087], [-118.48445, 35.15093], [-118.48392, 35.14882], [-118.48408, 35.14877], [-118.48423, 35.14868], [-118.48468, 35.14865], [-118.48541, 35.14831], [-118.48576, 35.14821], [-118.48646, 35.14814], [-118.48696, 35.148], [-118.48735, 35.14785], [-118.48746, 35.14751], [-118.48767, 35.14737], [-118.48789, 35.14714], [-118.48866, 35.14723], [-118.48934, 35.14698], [-118.48944, 35.14675], [-118.49, 35.14684], [-118.49151, 35.14623], [-118.49161, 35.14606], [-118.49204, 35.14609], [-118.4926, 35.14578], [-118.49255, 35.14549], [-118.49326, 35.14507], [-118.49306, 35.14473], [-118.49343, 35.14455], [-118.49382, 35.14443], [-118.49423, 35.14437], [-118.49465, 35.14436]]], [[[-118.50459, 35.15048], [-118.50449, 35.15062], [-118.50417, 35.15091], [-118.50397, 35.15101], [-118.50195, 35.15175], [-118.50156, 35.15166], [-118.5, 35.15174], [-118.49928, 35.15268], [-118.49845, 35.15359], [-118.49712, 35.1536], [-118.49712, 35.15332], [-118.49893, 35.15114], [-118.49762, 35.15063], [-118.49594, 35.15361], [-118.49471, 35.15362], [-118.49475, 35.15209], [-118.49519, 35.15113], [-118.49631, 35.15001], [-118.49574, 35.14969], [-118.49483, 35.14993], [-118.49485, 35.1491], [-118.49482, 35.14909], [-118.49483, 35.1486], [-118.49536, 35.1486], [-118.49576, 35.14866], [-118.49604, 35.14869], [-118.49678, 35.14869], [-118.49682, 35.14895], [-118.4973, 35.14906], [-118.49891, 35.14982], [-118.49932, 35.14965], [-118.4994, 35.14934], [-118.50001, 35.14961], [-118.50008, 35.15029], [-118.50063, 35.1505], [-118.502, 35.15003], [-118.50325, 35.15009], [-118.50383, 35.15025], [-118.50451, 35.15036], [-118.50457, 35.15036], [-118.50459, 35.15048]]]]} | Open Access 1 | Golden Hills Nature Park | https://ghcsd.com/wp-content/uploads/eastside-kiosk-map.pdf | 33317 | 2432 | Golden Hills Community Service District 923 | Special District 4 | Community Services District 17 | https://ghcsd.com/ | Special District 4 | 155.468 | Golden Hills Nature Park | |
1231 | 1231 | 1230 | {"type": "Polygon", "coordinates": [[[-121.36943, 38.44722], [-121.36911, 38.4473], [-121.36882, 38.44745], [-121.36862, 38.44752], [-121.36844, 38.44754], [-121.36794, 38.44755], [-121.36772, 38.44758], [-121.3677, 38.44537], [-121.36942, 38.44537], [-121.36943, 38.44722]]]} | Open Access 1 | Amundson Park | 15463 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 8.563 | Amundson Park | ||
1715 | 1715 | 1714 | {"type": "Polygon", "coordinates": [[[-121.43142, 38.3814], [-121.43141, 38.38145], [-121.42914, 38.38144], [-121.42914, 38.38117], [-121.42912, 38.38115], [-121.42916, 38.38111], [-121.42917, 38.38105], [-121.42914, 38.38095], [-121.42914, 38.38006], [-121.42917, 38.37995], [-121.42916, 38.3799], [-121.42912, 38.37986], [-121.42914, 38.37984], [-121.42914, 38.37947], [-121.43132, 38.37946], [-121.43138, 38.37948], [-121.4314, 38.37952], [-121.43142, 38.3814]]]} | Open Access 1 | Backer Park | 15752 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 10.773 | Backer Park | ||
1733 | 1733 | 1732 | {"type": "Polygon", "coordinates": [[[-121.37654, 38.40796], [-121.37501, 38.40797], [-121.37498, 38.40782], [-121.37335, 38.40783], [-121.37335, 38.40729], [-121.37456, 38.40729], [-121.37505, 38.40699], [-121.37572, 38.407], [-121.37574, 38.40698], [-121.37585, 38.40696], [-121.37625, 38.40696], [-121.37626, 38.40752], [-121.37654, 38.40774], [-121.37654, 38.40796]]]} | Open Access 1 | Baker Park | 15767 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 5.456 | Baker Park | ||
1783 | 1783 | 1782 | {"type": "Polygon", "coordinates": [[[-121.47122, 38.42207], [-121.47055, 38.42258], [-121.4703, 38.42258], [-121.4702, 38.42264], [-121.47006, 38.42265], [-121.46996, 38.42263], [-121.46986, 38.42258], [-121.46961, 38.42257], [-121.46898, 38.42208], [-121.46899, 38.42179], [-121.46917, 38.42176], [-121.46916, 38.42083], [-121.469, 38.42082], [-121.469, 38.42054], [-121.46908, 38.42052], [-121.46914, 38.42049], [-121.47034, 38.42048], [-121.47105, 38.4199], [-121.47111, 38.41993], [-121.47118, 38.41994], [-121.47118, 38.4208], [-121.47102, 38.42082], [-121.47103, 38.42175], [-121.47121, 38.42177], [-121.47122, 38.42207]]]} | Open Access 1 | Bartholomew Park | 15841 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 10.249 | Bartholomew Park | ||
1801 | 1801 | 1800 | {"type": "Polygon", "coordinates": [[[-121.4245, 38.41885], [-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]]]} | Open Access 1 | Batey Park | 15861 | 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.845 | Batey Park | ||
1898 | 1898 | 1897 | {"type": "Polygon", "coordinates": [[[-121.37535, 38.41303], [-121.37525, 38.41307], [-121.37525, 38.41445], [-121.37472, 38.41457], [-121.37452, 38.41458], [-121.37452, 38.41431], [-121.37455, 38.41429], [-121.37454, 38.41261], [-121.37525, 38.41261], [-121.37525, 38.41292], [-121.37535, 38.41296], [-121.37535, 38.41303]]]} | Open Access 1 | Beeman Park | 15953 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 3.28 | Beeman Park | ||
1958 | 1958 | 1957 | {"type": "Polygon", "coordinates": [[[-121.3487, 38.39004], [-121.3487, 38.39008], [-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]]]} | Open Access 1 | Berens Park | 16019 | 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.922 | Berens Park | ||
1984 | 1984 | 1983 | {"type": "MultiPolygon", "coordinates": [[[[-121.44049, 38.4306], [-121.44003, 38.4306], [-121.43918, 38.43156], [-121.43899, 38.43148], [-121.43873, 38.43143], [-121.43846, 38.43139], [-121.43708, 38.43138], [-121.43685, 38.43139], [-121.43667, 38.43144], [-121.43645, 38.43151], [-121.43619, 38.43155], [-121.43418, 38.43163], [-121.43414, 38.43161], [-121.43412, 38.43158], [-121.43412, 38.43064], [-121.43409, 38.43062], [-121.43409, 38.43039], [-121.4341, 38.43035], [-121.43413, 38.43034], [-121.43492, 38.43033], [-121.43494, 38.43062], [-121.43971, 38.4306], [-121.43973, 38.43003], [-121.43984, 38.43003], [-121.44029, 38.43008], [-121.44049, 38.43016], [-121.44049, 38.4306]]], [[[-121.43856, 38.4322], [-121.43773, 38.43316], [-121.43751, 38.43309], [-121.4383, 38.43218], [-121.43841, 38.43218], [-121.43856, 38.4322]]]]} | Open Access 1 | Betschart Park | 16049 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 13.848 | Betschart 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 | ||
2681 | 2681 | 2680 | {"type": "Polygon", "coordinates": [[[-121.43638, 38.42801], [-121.43638, 38.42805], [-121.43624, 38.42824], [-121.43613, 38.42847], [-121.43607, 38.42869], [-121.43432, 38.42814], [-121.43436, 38.42786], [-121.43441, 38.42782], [-121.43443, 38.42776], [-121.43441, 38.42771], [-121.43437, 38.42767], [-121.43431, 38.42739], [-121.4343, 38.42709], [-121.43435, 38.42705], [-121.43437, 38.427], [-121.43435, 38.42695], [-121.43431, 38.42691], [-121.43437, 38.42684], [-121.43486, 38.42685], [-121.4349, 38.42692], [-121.43498, 38.42697], [-121.43509, 38.42698], [-121.43543, 38.42709], [-121.43582, 38.42713], [-121.43586, 38.42715], [-121.43588, 38.42718], [-121.43594, 38.42742], [-121.43602, 38.42757], [-121.43611, 38.4277], [-121.43638, 38.42801]]]} | Open Access 1 | Case Park | 16942 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 6.081 | Case Park | ||
2686 | 2686 | 2685 | {"type": "Polygon", "coordinates": [[[-121.37703, 38.42161], [-121.377, 38.42169], [-121.37703, 38.42179], [-121.37703, 38.42262], [-121.37624, 38.42262], [-121.37623, 38.42127], [-121.37672, 38.42127], [-121.37673, 38.42145], [-121.37703, 38.42161]]]} | Open Access 1 | Castello Park | 16948 | 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.382 | Castello 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 | ||
2800 | 2800 | 2799 | {"type": "Polygon", "coordinates": [[[-121.3714, 38.4211], [-121.3709, 38.4211], [-121.37034, 38.42063], [-121.3714, 38.42063], [-121.3714, 38.4211]]]} | Open Access 1 | Del Meyer Park | 18039 | 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.885 | Del Meyer Park | ||
3117 | 3117 | 3116 | {"type": "Polygon", "coordinates": [[[-121.3967, 38.41621], [-121.3967, 38.4165], [-121.39663, 38.41653], [-121.39659, 38.4166], [-121.3966, 38.41664], [-121.39664, 38.41669], [-121.39661, 38.41672], [-121.3966, 38.41708], [-121.39662, 38.41712], [-121.39653, 38.41715], [-121.39646, 38.41702], [-121.39609, 38.41661], [-121.3958, 38.41635], [-121.39532, 38.41598], [-121.39514, 38.4158], [-121.39498, 38.4156], [-121.39551, 38.41544], [-121.3958, 38.41544], [-121.39586, 38.41553], [-121.39603, 38.4157], [-121.3962, 38.41581], [-121.3962, 38.4162], [-121.3967, 38.41621]]]} | Open Access 1 | Colton Park | 17545 | 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.685 | Colton Park | ||
3343 | 3343 | 3342 | {"type": "Polygon", "coordinates": [[[-121.45444, 38.42969], [-121.45442, 38.43075], [-121.45442, 38.43083], [-121.45439, 38.43086], [-121.45317, 38.43087], [-121.45288, 38.43085], [-121.45288, 38.42967], [-121.45444, 38.42969]]]} | Open Access 1 | Fite Park | 18926 | 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.4 | Fite 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 |
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]);