superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
189 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 7 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
MNG_AGENCY 7
- Los Angeles - Department of Parks and Recreation, County of 55
- Sonoma County Regional Parks Dept., County of 45
- Marin County Parks Department, County of 32
- Santa Clara County Parks and Recreation Dept., County of 28
- San Mateo County Parks and Recreation Dept., County of 23
- Del Norte County Parks, County of 5
- Yolo County Parks, County of 1
ACCESS_TYP 1
- Open Access · 189 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
577 | 577 | 576 | {"type": "Polygon", "coordinates": [[[-122.51646, 38.01272], [-122.51615, 38.01311], [-122.51571, 38.01298], [-122.51567, 38.01286], [-122.5156, 38.01274], [-122.51562, 38.0127], [-122.51608, 38.01244], [-122.51646, 38.01272]]]} | Open Access 1 | Adrian Rosall Park | 15275 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 0.826 | Adrian Rosall Park | ||
588 | 588 | 587 | {"type": "Polygon", "coordinates": [[[-118.12621, 34.18904], [-118.12602, 34.18935], [-118.12595, 34.18934], [-118.12593, 34.18924], [-118.12595, 34.18897], [-118.12609, 34.18896], [-118.1262, 34.18898], [-118.12621, 34.18904]]]} | Open Access 1 | Ganesha Park | 32689 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 0.18 | Ganesha Park | ||
688 | 688 | 687 | {"type": "MultiPolygon", "coordinates": [[[[-122.71352, 37.90015], [-122.71308, 37.9004], [-122.71226, 37.89978], [-122.71205, 37.89957], [-122.71193, 37.89942], [-122.7113, 37.8982], [-122.71119, 37.89809], [-122.71103, 37.89801], [-122.71091, 37.89799], [-122.71077, 37.89799], [-122.71061, 37.89803], [-122.7105, 37.89808], [-122.71041, 37.89816], [-122.71024, 37.8984], [-122.71022, 37.89851], [-122.71026, 37.89864], [-122.70995, 37.89874], [-122.71006, 37.89899], [-122.71012, 37.89919], [-122.71009, 37.8992], [-122.71, 37.89905], [-122.70983, 37.89892], [-122.70962, 37.89883], [-122.70944, 37.8988], [-122.70946, 37.89864], [-122.70969, 37.89854], [-122.70981, 37.89845], [-122.70995, 37.89832], [-122.71006, 37.89814], [-122.71013, 37.89794], [-122.71013, 37.89779], [-122.7101, 37.89764], [-122.71005, 37.8975], [-122.70991, 37.89733], [-122.70955, 37.89753], [-122.70938, 37.89742], [-122.70905, 37.89729], [-122.70883, 37.89717], [-122.70862, 37.89699], [-122.70807, 37.89619], [-122.70791, 37.89605], [-122.70774, 37.89593], [-122.70819, 37.89543], [-122.70925, 37.89589], [-122.71022, 37.89622], [-122.71056, 37.89674], [-122.71082, 37.89717], [-122.71098, 37.89748], [-122.71124, 37.89769], [-122.71126, 37.89779], [-122.71136, 37.89796], [-122.71136, 37.89802], [-122.71147, 37.89821], [-122.71194, 37.89883], [-122.71208, 37.89908], [-122.71235, 37.89934], [-122.71258, 37.89954], [-122.71285, 37.89969], [-122.71345, 37.90008], [-122.71352, 37.90015]]], [[[-122.71035, 37.90018], [-122.71029, 37.90026], [-122.71004, 37.90051], [-122.70995, 37.90066], [-122.70992, 37.90061], [-122.70991, 37.90044], [-122.70986, 37.9003], [-122.7098, 37.90028], [-122.71004, 37.8995], [-122.71008, 37.89957], [-122.71007, 37.89976], [-122.70999, 37.90011], [-122.71002, 37.90025], [-122.71035, 37.90018]]]]} | Open Access 1 | Agate Beach | 15284 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 13.709 | Agate Beach | ||
841 | 841 | 840 | {"type": "Polygon", "coordinates": [[[-121.98203, 37.43042], [-121.98105, 37.43131], [-121.97771, 37.43133], [-121.97771, 37.42933], [-121.97891, 37.42954], [-121.97905, 37.42954], [-121.97906, 37.42935], [-121.9793, 37.42934], [-121.9793, 37.42902], [-121.97948, 37.42912], [-121.98028, 37.42912], [-121.98049, 37.42923], [-121.98075, 37.42895], [-121.98063, 37.4288], [-121.98075, 37.42879], [-121.98078, 37.42875], [-121.98092, 37.42871], [-121.98125, 37.4288], [-121.98135, 37.42886], [-121.98139, 37.42894], [-121.98159, 37.42911], [-121.98171, 37.42928], [-121.98175, 37.42931], [-121.98175, 37.42938], [-121.98168, 37.42954], [-121.98155, 37.42969], [-121.98151, 37.42971], [-121.98144, 37.42971], [-121.98117, 37.42967], [-121.98068, 37.42956], [-121.98059, 37.42971], [-121.98146, 37.43009], [-121.98165, 37.42994], [-121.98203, 37.43042]]]} | Open Access 1 | Alviso Marina | 15431 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 19.789 | Alviso Marina | 1964 | |
1176 | 1176 | 1175 | {"type": "Polygon", "coordinates": [[[-123.01417, 38.82042], [-123.0134, 38.82108], [-123.01282, 38.82135], [-123.01201, 38.81951], [-123.01148, 38.82068], [-123.0119, 38.82141], [-123.01075, 38.82218], [-123.01038, 38.82201], [-123.01106, 38.81947], [-123.01124, 38.81872], [-123.01154, 38.81652], [-123.01282, 38.81658], [-123.01291, 38.81682], [-123.01369, 38.81914], [-123.0138, 38.81913], [-123.01417, 38.82042]]]} | Open Access 1 | Andersen | 15475 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 26.056 | Andersen | ||
1440 | 1440 | 1439 | {"type": "Polygon", "coordinates": [[[-122.5538, 38.41058], [-122.55368, 38.41107], [-122.5537, 38.41226], [-122.55207, 38.41085], [-122.55355, 38.40986], [-122.5538, 38.41058]]]} | Open Access 1 | Alder Park | 15346 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 4.856 | Alder Park | 1968 | |
1583 | 1583 | 1582 | {"type": "Polygon", "coordinates": [[[-122.45793, 38.29742], [-122.45765, 38.29926], [-122.45762, 38.29937], [-122.45758, 38.29944], [-122.45669, 38.29951], [-122.45533, 38.29937], [-122.45551, 38.29826], [-122.45577, 38.29826], [-122.45582, 38.29787], [-122.45582, 38.29775], [-122.45579, 38.29751], [-122.45582, 38.29721], [-122.45793, 38.29742]]]} | Open Access 1 | Arnold Park | 15603 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 11.313 | Arnold Park | 1978 | |
2048 | 2048 | 2047 | {"type": "MultiPolygon", "coordinates": [[[[-122.50735, 38.11473], [-122.50721, 38.11477], [-122.50708, 38.11492], [-122.50687, 38.11486], [-122.50673, 38.11476], [-122.50645, 38.11496], [-122.50608, 38.11467], [-122.50597, 38.11454], [-122.50619, 38.11445], [-122.50605, 38.11434], [-122.50643, 38.11419], [-122.50655, 38.11334], [-122.50673, 38.11403], [-122.50669, 38.11407], [-122.50674, 38.11407], [-122.50688, 38.11442], [-122.5068, 38.1145], [-122.50683, 38.11454], [-122.50703, 38.11464], [-122.50716, 38.11469], [-122.50735, 38.11473]]], [[[-122.50745, 38.11324], [-122.50723, 38.11345], [-122.50724, 38.11346], [-122.50737, 38.11346], [-122.50737, 38.11352], [-122.50703, 38.11382], [-122.50688, 38.11383], [-122.50682, 38.11385], [-122.50685, 38.11358], [-122.50677, 38.11331], [-122.50745, 38.11324]]]]} | Open Access 1 | Black Point Boat Launch | 16137 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 2.264 | Black Point Boat Launch | ||
2051 | 2051 | 2050 | {"type": "Polygon", "coordinates": [[[-122.50888, 38.09899], [-122.50871, 38.099], [-122.5085, 38.09905], [-122.50826, 38.09925], [-122.50786, 38.09951], [-122.50741, 38.09972], [-122.50722, 38.09988], [-122.507, 38.10019], [-122.50678, 38.10039], [-122.50646, 38.10046], [-122.50609, 38.10074], [-122.506, 38.10101], [-122.50578, 38.1012], [-122.50544, 38.10155], [-122.50526, 38.10172], [-122.50514, 38.10178], [-122.50479, 38.10182], [-122.50467, 38.10193], [-122.50445, 38.10201], [-122.5043, 38.1022], [-122.50424, 38.10236], [-122.50407, 38.10253], [-122.50405, 38.1026], [-122.50353, 38.10297], [-122.50333, 38.10292], [-122.50317, 38.10266], [-122.50298, 38.10263], [-122.50242, 38.10286], [-122.50204, 38.10327], [-122.5019, 38.10358], [-122.50182, 38.1037], [-122.5015, 38.104], [-122.50125, 38.10471], [-122.50129, 38.10487], [-122.50121, 38.10506], [-122.50107, 38.10528], [-122.501, 38.10549], [-122.50101, 38.10563], [-122.50082, 38.10593], [-122.50125, 38.10145], [-122.50145, 38.09994], [-122.5016, 38.09897], [-122.50179, 38.09877], [-122.50743, 38.09739], [-122.50883, 38.09753], [-122.50879, 38.09767], [-122.50858, 38.09767], [-122.50839, 38.09784], [-122.50833, 38.09811], [-122.50865, 38.09854], [-122.50882, 38.09864], [-122.50888, 38.09899]]]} | Open Access 1 | Black Point Nature Preserve | 16138 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 64.211 | Black Point Nature Preserve | ||
2174 | 2174 | 2173 | {"type": "Polygon", "coordinates": [[[-122.51009, 38.36459], [-122.51009, 38.36459], [-122.5059, 38.36725], [-122.50542, 38.36613], [-122.50569, 38.36589], [-122.50569, 38.36502], [-122.50624, 38.36485], [-122.50574, 38.36403], [-122.50846, 38.36297], [-122.51009, 38.36459]]]} | Open Access 1 | Bouverie Wildflower Preserve | 16304 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 24.51 | Bouverie Wildflower Preserve | 1970 | |
2581 | 2581 | 2580 | {"type": "Polygon", "coordinates": [[[-122.51744, 38.01193], [-122.51734, 38.01202], [-122.51708, 38.01218], [-122.51696, 38.01205], [-122.51738, 38.01189], [-122.51744, 38.01193]]]} | Open Access 1 | Candy's Park | 16799 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 0.134 | Candy's Park | ||
2614 | 2614 | 2613 | {"type": "Polygon", "coordinates": [[[-122.54231, 37.94808], [-122.54155, 37.94882], [-122.54046, 37.94983], [-122.53924, 37.95103], [-122.53771, 37.94999], [-122.538, 37.94977], [-122.53804, 37.94969], [-122.53802, 37.9496], [-122.53796, 37.94953], [-122.53722, 37.94901], [-122.53706, 37.94881], [-122.53707, 37.94876], [-122.53722, 37.94865], [-122.53744, 37.94845], [-122.53761, 37.94821], [-122.53773, 37.94796], [-122.5378, 37.94769], [-122.5378, 37.94741], [-122.53774, 37.94715], [-122.53748, 37.94649], [-122.53743, 37.94632], [-122.53741, 37.94612], [-122.53743, 37.94592], [-122.53746, 37.94582], [-122.53772, 37.94558], [-122.53775, 37.94561], [-122.53778, 37.94567], [-122.53792, 37.94586], [-122.53796, 37.94596], [-122.53802, 37.94601], [-122.53809, 37.94619], [-122.53816, 37.94631], [-122.53828, 37.94664], [-122.53836, 37.94679], [-122.53851, 37.94699], [-122.53869, 37.94718], [-122.53892, 37.94736], [-122.53921, 37.94753], [-122.53939, 37.94762], [-122.53978, 37.94775], [-122.54013, 37.94782], [-122.54231, 37.94808]]]} | Open Access 1 | Creekside Park | 17770 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 27.416 | Creekside Park | ||
2697 | 2697 | 2696 | {"type": "Polygon", "coordinates": [[[-122.52552, 38.01157], [-122.52518, 38.01194], [-122.5243, 38.01226], [-122.52403, 38.01202], [-122.52393, 38.01186], [-122.52379, 38.01175], [-122.52359, 38.01165], [-122.52362, 38.01157], [-122.52384, 38.01164], [-122.52431, 38.0117], [-122.52484, 38.01171], [-122.52507, 38.01169], [-122.52552, 38.01157]]]} | Open Access 1 | Castro Park | 16961 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 1.427 | Castro Park | ||
2883 | 2883 | 2882 | {"type": "Polygon", "coordinates": [[[-124.20362, 41.75891], [-124.20165, 41.7589], [-124.20165, 41.75859], [-124.20151, 41.75858], [-124.20151, 41.75823], [-124.20234, 41.75823], [-124.20182, 41.75767], [-124.20212, 41.75756], [-124.20212, 41.75755], [-124.20205, 41.75746], [-124.2025, 41.7572], [-124.20347, 41.75822], [-124.2035, 41.75824], [-124.20362, 41.75824], [-124.20362, 41.75891]]]} | Open Access 1 | Pyke Field | 32981 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 5.197 | Pyke Field | ||
2895 | 2895 | 2894 | {"type": "Polygon", "coordinates": [[[-122.86561, 38.11011], [-122.86537, 38.1102], [-122.8655, 38.11065], [-122.86521, 38.11023], [-122.86378, 38.10914], [-122.86257, 38.1082], [-122.86335, 38.10757], [-122.86353, 38.10773], [-122.86438, 38.10863], [-122.86484, 38.10905], [-122.8653, 38.1094], [-122.86545, 38.10948], [-122.8656, 38.10952], [-122.86549, 38.1097], [-122.86561, 38.11011]]]} | Open Access 1 | Chicken Ranch Beach | 17190 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 6.464 | Chicken Ranch Beach | ||
2907 | 2907 | 2906 | {"type": "Polygon", "coordinates": [[[-121.6577, 37.03112], [-121.65699, 37.03135], [-121.65694, 37.03126], [-121.65648, 37.03066], [-121.65631, 37.03016], [-121.65656, 37.02986], [-121.65659, 37.02975], [-121.65715, 37.02966], [-121.6577, 37.03112]]]} | Open Access 1 | Chitactac-Adams County Park | 17210 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 3.445 | Chitactac-Adams County Park | ||
2921 | 2921 | 2920 | {"type": "Polygon", "coordinates": [[[-121.58753, 36.99436], [-121.58738, 36.99554], [-121.58732, 36.99577], [-121.58721, 36.996], [-121.58706, 36.99622], [-121.58583, 36.9976], [-121.58544, 36.99808], [-121.58541, 36.99807], [-121.58494, 36.99871], [-121.58458, 36.99926], [-121.58332, 36.99837], [-121.58303, 36.99813], [-121.58286, 36.99795], [-121.58272, 36.99776], [-121.58257, 36.99752], [-121.58236, 36.9971], [-121.58221, 36.99689], [-121.58205, 36.9967], [-121.58183, 36.99649], [-121.58133, 36.99607], [-121.58054, 36.99548], [-121.58128, 36.99477], [-121.58177, 36.99424], [-121.58184, 36.99425], [-121.58305, 36.99325], [-121.58319, 36.99311], [-121.58336, 36.99293], [-121.58354, 36.9927], [-121.58371, 36.99244], [-121.58384, 36.99218], [-121.58548, 36.99277], [-121.587, 36.99287], [-121.58713, 36.99346], [-121.58753, 36.99436]]]} | Open Access 1 | Christmas Hill Park | 17228 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 68.848 | Christmas Hill Park | ||
3039 | 3039 | 3038 | {"type": "Polygon", "coordinates": [[[-123.01254, 38.82071], [-123.01186, 38.82152], [-123.01112, 38.82235], [-123.01076, 38.82218], [-123.0119, 38.82141], [-123.01148, 38.82068], [-123.01202, 38.81948], [-123.01254, 38.82071]]]} | Open Access 1 | Cloverdale River Park | 17444 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 3.116 | Cloverdale River Park | ||
3198 | 3198 | 3197 | {"type": "Polygon", "coordinates": [[[-122.52894, 37.92555], [-122.5287, 37.92554], [-122.52852, 37.9251], [-122.52838, 37.92462], [-122.52834, 37.92435], [-122.52836, 37.92395], [-122.52835, 37.92375], [-122.52841, 37.9233], [-122.52841, 37.92304], [-122.52834, 37.9227], [-122.52806, 37.92203], [-122.52792, 37.92202], [-122.52785, 37.92191], [-122.52791, 37.92188], [-122.52742, 37.92066], [-122.52722, 37.92036], [-122.52676, 37.91949], [-122.52677, 37.91915], [-122.52682, 37.91931], [-122.52704, 37.91928], [-122.52728, 37.91946], [-122.52764, 37.92033], [-122.52817, 37.92153], [-122.5281, 37.92158], [-122.52821, 37.92186], [-122.52833, 37.92208], [-122.52845, 37.92237], [-122.52851, 37.92255], [-122.52861, 37.92306], [-122.52855, 37.92425], [-122.5286, 37.92467], [-122.52873, 37.92511], [-122.52882, 37.92534], [-122.52894, 37.92555]]]} | Open Access 1 | Corte Madera Bike Path | 17658 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 4.523 | Corte Madera Bike Path | ||
3285 | 3285 | 3284 | {"type": "Polygon", "coordinates": [[[-122.65202, 38.35073], [-122.64218, 38.35079], [-122.64218, 38.35016], [-122.64159, 38.34812], [-122.64149, 38.34804], [-122.64161, 38.34773], [-122.64163, 38.34714], [-122.64171, 38.3467], [-122.64214, 38.34583], [-122.64266, 38.34517], [-122.64337, 38.34455], [-122.64507, 38.34235], [-122.64514, 38.34205], [-122.64511, 38.34177], [-122.64494, 38.3412], [-122.6448, 38.34093], [-122.64492, 38.34076], [-122.64516, 38.34051], [-122.64545, 38.34014], [-122.64715, 38.34466], [-122.65121, 38.34968], [-122.65166, 38.34996], [-122.65202, 38.35073]]]} | Open Access 1 | Crane Creek | 17756 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 130.001 | Crane Creek | 1974 |
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]);