superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
48 rows where MNG_AGENCY = 189 and MNG_AG_LEV = 3
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15071 | 15071 | 15070 | {"type": "Polygon", "coordinates": [[[-122.8705, 38.51272], [-122.86999, 38.51343], [-122.86999, 38.51352], [-122.86958, 38.51497], [-122.86767, 38.5152], [-122.86677, 38.51544], [-122.86557, 38.51623], [-122.86497, 38.5169], [-122.8643, 38.51739], [-122.8634, 38.51778], [-122.86351, 38.51797], [-122.86269, 38.51847], [-122.86229, 38.51951], [-122.86256, 38.52195], [-122.86282, 38.52291], [-122.86362, 38.52421], [-122.86363, 38.52487], [-122.8633, 38.52519], [-122.85421, 38.52524], [-122.85416, 38.52163], [-122.8496, 38.52163], [-122.84971, 38.52152], [-122.85392, 38.52152], [-122.85396, 38.5213], [-122.85407, 38.52128], [-122.85444, 38.51889], [-122.85439, 38.51879], [-122.85422, 38.51753], [-122.8557, 38.51605], [-122.85844, 38.51605], [-122.85921, 38.51599], [-122.85978, 38.5149], [-122.85935, 38.51436], [-122.85969, 38.51363], [-122.86151, 38.51259], [-122.86207, 38.51214], [-122.86286, 38.51144], [-122.86357, 38.51125], [-122.86546, 38.51071], [-122.86641, 38.51052], [-122.86697, 38.51046], [-122.86753, 38.51048], [-122.86818, 38.51062], [-122.86936, 38.5111], [-122.86951, 38.51122], [-122.86987, 38.5114], [-122.86995, 38.51158], [-122.87045, 38.51217], [-122.87046, 38.5125], [-122.8705, 38.51272]]]} | Open Access 1 | Riverfront Regional Park | http://parks.sonomacounty.ca.gov/Get_Outdoors/Parks/Riverfront_Regional_Park.aspx | 12628 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 303.987 | Riverfront RP | |
15085 | 15085 | 15084 | {"type": "MultiPolygon", "coordinates": [[[[-123.03513, 38.31417], [-123.03357, 38.31511], [-123.03504, 38.31709], [-123.03421, 38.31713], [-123.0338, 38.31748], [-123.03355, 38.31704], [-123.03326, 38.31662], [-123.03289, 38.3165], [-123.03214, 38.31519], [-123.03237, 38.31444], [-123.03432, 38.31398], [-123.0351, 38.31413], [-123.03513, 38.31417]]], [[[-123.05308, 38.30992], [-123.05115, 38.31187], [-123.0469, 38.31329], [-123.04469, 38.31382], [-123.04432, 38.31298], [-123.04776, 38.31195], [-123.05076, 38.31098], [-123.05308, 38.30992]]]]} | Open Access 1 | Doran Regional Park | 18217 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 31.417 | Doran RP | ||
15096 | 15096 | 15095 | {"type": "Polygon", "coordinates": [[[-122.48498, 38.29995], [-122.48499, 38.30014], [-122.48496, 38.30023], [-122.48485, 38.30037], [-122.48477, 38.3005], [-122.48441, 38.3008], [-122.48396, 38.30112], [-122.48388, 38.30121], [-122.48383, 38.30135], [-122.48383, 38.30148], [-122.48385, 38.30158], [-122.48421, 38.30244], [-122.4842, 38.30251], [-122.48418, 38.30255], [-122.48383, 38.30261], [-122.48128, 38.30272], [-122.47925, 38.30275], [-122.47887, 38.30272], [-122.47774, 38.30275], [-122.47743, 38.30274], [-122.47727, 38.30269], [-122.477, 38.30259], [-122.47674, 38.30254], [-122.47651, 38.30253], [-122.4762, 38.30256], [-122.47609, 38.30253], [-122.47519, 38.30158], [-122.4751, 38.30145], [-122.47504, 38.30133], [-122.47498, 38.30114], [-122.47497, 38.30102], [-122.47497, 38.30081], [-122.47498, 38.30077], [-122.475, 38.30076], [-122.47502, 38.30064], [-122.47766, 38.3009], [-122.47746, 38.29989], [-122.47693, 38.29884], [-122.48185, 38.29845], [-122.48143, 38.29788], [-122.48128, 38.29748], [-122.48071, 38.29723], [-122.47973, 38.29729], [-122.48056, 38.29647], [-122.48135, 38.29698], [-122.48158, 38.29719], [-122.48184, 38.29757], [-122.48191, 38.29782], [-122.48197, 38.29812], [-122.48204, 38.29832], [-122.48217, 38.29852], [-122.48241, 38.29867], [-122.48329, 38.29884], [-122.48353, 38.2989], [-122.48374, 38.299], [-122.48401, 38.29914], [-122.48442, 38.2994], [-122.48468, 38.2996], [-122.48498, 38.29995]]]} | Open Access 1 | Maxwell Farms Regional Park | 21969 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 78.903 | Maxwell Farms RP | ||
15110 | 15110 | 15109 | {"type": "MultiPolygon", "coordinates": [[[[-123.2971, 38.55168], [-123.29264, 38.55173], [-123.29262, 38.55843], [-123.28328, 38.55849], [-123.28324, 38.5588], [-123.28203, 38.55872], [-123.28205, 38.55823], [-123.28235, 38.55804], [-123.28292, 38.55782], [-123.28372, 38.55733], [-123.2853, 38.55673], [-123.28611, 38.5564], [-123.28811, 38.55486], [-123.29113, 38.55358], [-123.29117, 38.5534], [-123.29166, 38.55277], [-123.29145, 38.55238], [-123.29123, 38.55135], [-123.29096, 38.54937], [-123.28987, 38.54927], [-123.28913, 38.54911], [-123.28964, 38.54806], [-123.29264, 38.54812], [-123.29265, 38.54421], [-123.29341, 38.54512], [-123.2938, 38.54526], [-123.29444, 38.54533], [-123.29515, 38.54533], [-123.29578, 38.54563], [-123.29663, 38.54618], [-123.29678, 38.54645], [-123.29676, 38.54688], [-123.2963, 38.54718], [-123.29621, 38.54728], [-123.29626, 38.54808], [-123.29654, 38.54829], [-123.29661, 38.5483], [-123.29599, 38.54857], [-123.29624, 38.54911], [-123.2953, 38.54977], [-123.29616, 38.5508], [-123.2971, 38.55168]]], [[[-123.30629, 38.55168], [-123.30627, 38.5517], [-123.30174, 38.55165], [-123.30195, 38.55122], [-123.30205, 38.55041], [-123.30185, 38.54967], [-123.30112, 38.54842], [-123.30016, 38.54783], [-123.29916, 38.54729], [-123.29811, 38.54732], [-123.29749, 38.54736], [-123.29702, 38.54762], [-123.2968, 38.54808], [-123.29655, 38.54807], [-123.29644, 38.54784], [-123.29644, 38.54724], [-123.29693, 38.54699], [-123.29709, 38.54673], [-123.2971, 38.54638], [-123.29696, 38.54622], [-123.29792, 38.54586], [-123.29788, 38.54592], [-123.29782, 38.54652], [-123.29766, 38.5468], [-123.29789, 38.54701], [-123.29801, 38.54699], [-123.29886, 38.54705], [-123.29917, 38.54674], [-123.29972, 38.5468], [-123.3005, 38.54665], [-123.30071, 38.54693], [-123.30094, 38.54687], [-123.3012, 38.54696], [-123.30142, 38.54694], [-123.30182, 38.54708], [-123.30147, 38.54729], [-123.30146, 38.54744], [-123.30185, 38.54745], [-123.30185, 38.54759], [-123.302, 38.54776], [-123.30221, 38.54784], [-123.30222, 38.54783], [-123.30222, 38.54763], [-123.30249, 38.54753], [-123.30266, 38.54767], [-123.3025, 38.54798], [-123.30269, 38.54809], [-123.30331, 38.54749], [-123.30378, 38.54739], [-123.30388, 38.54774], [-123.30428, 38.54785], [-123.30443, 38.54798], [-123.30436, 38.54818], [-123.30442, 38.54838], [-123.3047, 38.54874], [-123.30484, 38.54929], [-123.3051, 38.54952], [-123.30526, 38.54962], [-123.30526, 38.54966], [-123.30521, 38.54981], [-123.30552, 38.54973], [-123.30556, 38.54986], [-123.30553, 38.54998], [-123.30553, 38.55034], [-123.30539, 38.55053], [-123.30543, 38.55066], [-123.30549, 38.55069], [-123.30623, 38.55072], [-123.30627, 38.55082], [-123.30568, 38.55124], [-123.30587, 38.55154], [-123.30629, 38.55168]]]]} | Open Access 1 | Stillwater Cove Regional Park | http://parks.sonomacounty.ca.gov/Get_Outdoors/Parks/Stillwater_Cove_Regional_Park.aspx | 27895 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 197.77 | Stillwater Cove RP | |
15112 | 15112 | 15111 | {"type": "MultiPolygon", "coordinates": [[[[-122.66092, 38.45518], [-122.65973, 38.45626], [-122.65975, 38.45936], [-122.65617, 38.45995], [-122.65546, 38.4601], [-122.65464, 38.46042], [-122.65457, 38.46055], [-122.65418, 38.46074], [-122.65383, 38.46066], [-122.65373, 38.46078], [-122.6537, 38.46089], [-122.65372, 38.46161], [-122.6533, 38.46124], [-122.65302, 38.46095], [-122.65167, 38.45939], [-122.65137, 38.45911], [-122.65106, 38.45885], [-122.65078, 38.45866], [-122.65049, 38.45849], [-122.64994, 38.45822], [-122.64936, 38.45801], [-122.64866, 38.45784], [-122.64862, 38.45782], [-122.64859, 38.45775], [-122.64865, 38.4575], [-122.64865, 38.45735], [-122.64848, 38.45642], [-122.64841, 38.45632], [-122.64833, 38.45627], [-122.6482, 38.45626], [-122.64716, 38.45652], [-122.64707, 38.45652], [-122.64701, 38.45649], [-122.64697, 38.45644], [-122.64698, 38.45638], [-122.64733, 38.45561], [-122.6486, 38.45566], [-122.64968, 38.455], [-122.64989, 38.45454], [-122.64988, 38.45453], [-122.649, 38.45479], [-122.64871, 38.45495], [-122.64857, 38.45477], [-122.64836, 38.45463], [-122.64792, 38.45453], [-122.64786, 38.45448], [-122.64826, 38.45363], [-122.64812, 38.45357], [-122.64854, 38.45273], [-122.64847, 38.45267], [-122.64836, 38.45234], [-122.64825, 38.4523], [-122.64799, 38.45235], [-122.64736, 38.45268], [-122.64702, 38.45284], [-122.64642, 38.45304], [-122.64597, 38.4531], [-122.64534, 38.4531], [-122.64489, 38.45307], [-122.64496, 38.45367], [-122.64267, 38.45431], [-122.6435, 38.45134], [-122.64456, 38.45143], [-122.6482, 38.44901], [-122.64782, 38.44614], [-122.64767, 38.44586], [-122.6476, 38.44565], [-122.64757, 38.44542], [-122.6476, 38.44518], [-122.64766, 38.44493], [-122.64761, 38.44458], [-122.64765, 38.44392], [-122.64764, 38.44359], [-122.64786, 38.44383], [-122.6481, 38.44392], [-122.64837, 38.44417], [-122.64868, 38.44435], [-122.6494, 38.44444], [-122.64969, 38.4444], [-122.64989, 38.44433], [-122.65007, 38.44418], [-122.65083, 38.44306], [-122.65083, 38.44301], [-122.65156, 38.44273], [-122.65161, 38.44288], [-122.65162, 38.44308], [-122.65159, 38.44324], [-122.6515, 38.44346], [-122.65093, 38.44418], [-122.65108, 38.44567], [-122.65145, 38.44877], [-122.65288, 38.44828], [-122.65288, 38.44824], [-122.65402, 38.44754], [-122.65408, 38.44758], [-122.65441, 38.44738], [-122.65481, 38.44829], [-122.65664, 38.44869], [-122.65663, 38.44906], [-122.6567, 38.44962], [-122.6572, 38.44987], [-122.65844, 38.45468], [-122.66092, 38.45518]]], [[[-122.64843, 38.45767], [-122.64835, 38.45774], [-122.64824, 38.45775], [-122.6469, 38.45746], [-122.64388, 38.45708], [-122.64438, 38.45707], [-122.64506, 38.45703], [-122.64608, 38.45691], [-122.64721, 38.45669], [-122.64823, 38.45644], [-122.64828, 38.45644], [-122.64831, 38.45647], [-122.64848, 38.45735], [-122.64843, 38.45767]]]]} | Open Access 1 | Spring Lake Regional Park | http://parks.sonomacounty.ca.gov/Get_Outdoors/Parks/Spring_Lake_Regional_Park.aspx | 28940 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 352.406 | Spring Lake RP | 1970 |
15113 | 15113 | 15112 | {"type": "Polygon", "coordinates": [[[-122.79808, 38.56412], [-122.79667, 38.56421], [-122.79669, 38.56469], [-122.79808, 38.56462], [-122.79807, 38.56591], [-122.78366, 38.56593], [-122.78385, 38.56311], [-122.78471, 38.56232], [-122.7847, 38.5621], [-122.78223, 38.5621], [-122.78219, 38.55891], [-122.78692, 38.55886], [-122.78693, 38.55796], [-122.78804, 38.55718], [-122.78882, 38.55718], [-122.78861, 38.55728], [-122.78852, 38.55742], [-122.78848, 38.55791], [-122.78829, 38.55829], [-122.78866, 38.55892], [-122.7888, 38.55985], [-122.78932, 38.56006], [-122.78976, 38.56008], [-122.79011, 38.56016], [-122.7907, 38.56055], [-122.79184, 38.56065], [-122.79262, 38.56091], [-122.79305, 38.56089], [-122.79358, 38.56122], [-122.79379, 38.56121], [-122.79439, 38.56132], [-122.79454, 38.56149], [-122.79463, 38.56152], [-122.79517, 38.56143], [-122.79545, 38.56148], [-122.79605, 38.56151], [-122.79634, 38.56144], [-122.79652, 38.56132], [-122.79721, 38.56098], [-122.79763, 38.56062], [-122.79784, 38.56068], [-122.79807, 38.56119], [-122.79809, 38.56396], [-122.79808, 38.56412]]]} | Open Access 1 | Foothill Regional Park | http://parks.sonomacounty.ca.gov/Get_Outdoors/Parks/Foothill_Regional_Park.aspx | 29216 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 210.595 | Foothill RP | |
15525 | 15525 | 15524 | {"type": "Polygon", "coordinates": [[[-122.58359, 38.35396], [-122.57359, 38.35409], [-122.5738, 38.34345], [-122.57706, 38.34341], [-122.57744, 38.34409], [-122.58133, 38.33978], [-122.58349, 38.33977], [-122.58359, 38.35396]]]} | No Public Access 3 | North Sonoma Mountain Regional Park and Open Space Preserve | http://parks.sonomacounty.ca.gov/uploadedFiles/Parks/Get_Outdoors/Parks/North-Slope-Sonoma-Mountain-Map.pdf | 31062 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 283.158 | North Sonoma Mtn. RP and OSP | |
15571 | 15571 | 15570 | {"type": "Polygon", "coordinates": [[[-122.58874, 38.46739], [-122.57456, 38.46741], [-122.57459, 38.47462], [-122.57935, 38.47459], [-122.57982, 38.48188], [-122.57969, 38.48187], [-122.57967, 38.48188], [-122.5753, 38.48181], [-122.57329, 38.48206], [-122.57255, 38.48575], [-122.57349, 38.48565], [-122.57394, 38.48565], [-122.57555, 38.4854], [-122.57566, 38.48664], [-122.575, 38.48674], [-122.5731, 38.48691], [-122.57311, 38.48938], [-122.57291, 38.48941], [-122.57094, 38.48959], [-122.5709, 38.48817], [-122.57066, 38.48773], [-122.57096, 38.48716], [-122.57098, 38.4857], [-122.57095, 38.48534], [-122.57095, 38.48496], [-122.57101, 38.48469], [-122.57104, 38.48421], [-122.57102, 38.48404], [-122.57107, 38.48361], [-122.57126, 38.4831], [-122.5722, 38.48216], [-122.57192, 38.48137], [-122.57194, 38.48087], [-122.57024, 38.47879], [-122.56995, 38.4752], [-122.56086, 38.47629], [-122.56102, 38.47197], [-122.5567, 38.47182], [-122.55699, 38.46681], [-122.55275, 38.46659], [-122.55303, 38.46245], [-122.54012, 38.46228], [-122.54025, 38.45857], [-122.54461, 38.45846], [-122.5446, 38.45829], [-122.54458, 38.45828], [-122.54369, 38.44399], [-122.54459, 38.444], [-122.54461, 38.44399], [-122.55309, 38.44393], [-122.55318, 38.44754], [-122.55758, 38.44748], [-122.55773, 38.44741], [-122.55775, 38.4439], [-122.56222, 38.44386], [-122.56223, 38.44389], [-122.5623, 38.44386], [-122.56255, 38.44386], [-122.5625, 38.44785], [-122.56247, 38.45493], [-122.56723, 38.45524], [-122.57088, 38.45577], [-122.57103, 38.45582], [-122.57115, 38.45617], [-122.57135, 38.45652], [-122.57082, 38.45677], [-122.5703, 38.45689], [-122.56974, 38.4574], [-122.57, 38.45786], [-122.56999, 38.45828], [-122.57118, 38.45832], [-122.57118, 38.4583], [-122.57108, 38.45816], [-122.5716, 38.45786], [-122.57231, 38.45767], [-122.57262, 38.45741], [-122.57312, 38.45707], [-122.57321, 38.45678], [-122.57361, 38.4566], [-122.57382, 38.45642], [-122.57437, 38.4566], [-122.5746, 38.45675], [-122.57472, 38.45676], [-122.57487, 38.45669], [-122.57512, 38.45656], [-122.57522, 38.45624], [-122.57529, 38.4561], [-122.57546, 38.45589], [-122.57543, 38.45571], [-122.57524, 38.45549], [-122.57508, 38.4547], [-122.57511, 38.45443], [-122.57493, 38.45423], [-122.57462, 38.45395], [-122.57451, 38.45388], [-122.57436, 38.45383], [-122.57419, 38.4538], [-122.5739, 38.45369], [-122.57383, 38.45356], [-122.5735, 38.45343], [-122.57344, 38.45313], [-122.57353, 38.45308], [-122.57353, 38.45304], [-122.57384, 38.45266], [-122.57376, 38.45229], [-122.57406, 38.4519], [-122.57396, 38.4512], [-122.57405, 38.45123], [-122.57409, 38.45129], [-122.57423, 38.45163], [-122.57429, 38.45187], [-122.57445, 38.45274], [-122.57442, 38.45292], [-122.57426, 38.45323], [-122.57394, 38.45348], [-122.57394, 38.4535], [-122.57473, 38.45362], [-122.57695, 38.45361], [-122.57686, 38.46012], [-122.57945, 38.46013], [-122.57949, 38.46376], [-122.58857, 38.46375], [-122.58874, 38.46739]], [[-122.57553, 38.45834], [-122.57554, 38.45833], [-122.5751, 38.45694], [-122.57482, 38.45718], [-122.57473, 38.45735], [-122.57383, 38.45766], [-122.5738, 38.45769], [-122.57377, 38.45771], [-122.57356, 38.45797], [-122.57357, 38.45799], [-122.57553, 38.45834]]]} | Open Access 1 | Hood Mountain Regional Park and Open Space Preserve | http://parks.sonomacounty.ca.gov/Get_Outdoors/Parks/Hood_Mountain_Regional_Park_Open_Space_Preserve.aspx | 33694 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 1946.494 | Hood Mtn. RP and OSP | 2000 |
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]);