units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where DES_TP = 2, MNG_AGENCY = 189 and MNG_AG_TYP = 7 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, YR_EST
ACCESS_TYP 3
MNG_AG_TYP 1
- County Agency - Parks · 34 ✖
MNG_AGENCY 1
- Sonoma County Regional Parks Dept., County of · 34 ✖
DES_TP 1
- Local Park · 34 ✖
Link | rowid | id | map | ACCESS_TYP | UNIT_ID ▼ | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6032 | 6032 | 6031 | {"type": "Polygon", "coordinates": [[[-122.55176, 38.41643], [-122.55043, 38.4173], [-122.54968, 38.41667], [-122.55088, 38.41584], [-122.55139, 38.41623], [-122.55147, 38.4162], [-122.55176, 38.41643]]]} | Open Access 1 | 726 | Shaw Park | 25376 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 3.508 | Shaw Park | 1951 | Local Park 2 | 4 | |
16279 | 16279 | 16278 | {"type": "Polygon", "coordinates": [[[-122.76325, 38.52529], [-122.76321, 38.52535], [-122.76317, 38.52534], [-122.76221, 38.52687], [-122.76287, 38.52797], [-122.7617, 38.52844], [-122.76152, 38.52871], [-122.76074, 38.52912], [-122.76031, 38.52925], [-122.75963, 38.52928], [-122.75759, 38.53011], [-122.75772, 38.53224], [-122.75741, 38.53247], [-122.75702, 38.53281], [-122.75696, 38.53282], [-122.75332, 38.5356], [-122.75247, 38.53564], [-122.75147, 38.53441], [-122.75058, 38.53484], [-122.75034, 38.5356], [-122.75166, 38.53629], [-122.75262, 38.53636], [-122.75226, 38.53656], [-122.75159, 38.53671], [-122.75149, 38.53692], [-122.75121, 38.53703], [-122.75108, 38.53722], [-122.75063, 38.53737], [-122.75063, 38.53784], [-122.75009, 38.53794], [-122.74977, 38.53806], [-122.7497, 38.53835], [-122.74938, 38.5385], [-122.74879, 38.5386], [-122.74697, 38.53929], [-122.74598, 38.53893], [-122.74513, 38.53843], [-122.74354, 38.53772], [-122.74167, 38.5375], [-122.74117, 38.5373], [-122.73981, 38.53663], [-122.74273, 38.53517], [-122.74277, 38.53471], [-122.742, 38.53225], [-122.74256, 38.53261], [-122.74287, 38.5323], [-122.74283, 38.53192], [-122.742, 38.53197], [-122.74256, 38.52835], [-122.74218, 38.52713], [-122.7406, 38.52132], [-122.73573, 38.51875], [-122.7351, 38.51851], [-122.73405, 38.51876], [-122.73098, 38.51855], [-122.73104, 38.51932], [-122.72968, 38.51999], [-122.72982, 38.52201], [-122.72983, 38.52248], [-122.72899, 38.52553], [-122.72951, 38.52734], [-122.72967, 38.52754], [-122.72998, 38.52782], [-122.73038, 38.52801], [-122.73074, 38.52823], [-122.7311, 38.52861], [-122.7312, 38.52902], [-122.73092, 38.52952], [-122.7281, 38.53117], [-122.72812, 38.53051], [-122.72841, 38.53041], [-122.72907, 38.53005], [-122.7294, 38.52973], [-122.72977, 38.52947], [-122.73025, 38.52923], [-122.73046, 38.52891], [-122.7299, 38.52848], [-122.72942, 38.52829], [-122.72905, 38.528], [-122.72899, 38.52769], [-122.7285, 38.52718], [-122.72841, 38.52713], [-122.72822, 38.52691], [-122.72788, 38.52666], [-122.72773, 38.52644], [-122.72768, 38.52633], [-122.72766, 38.52624], [-122.72798, 38.52624], [-122.72817, 38.52563], [-122.72815, 38.51827], [-122.73256, 38.51819], [-122.73968, 38.51821], [-122.74216, 38.51822], [-122.74689, 38.51833], [-122.7513, 38.51837], [-122.75583, 38.51837], [-122.7577, 38.51839], [-122.75757, 38.51859], [-122.75754, 38.51856], [-122.75681, 38.51874], [-122.75657, 38.51872], [-122.75619, 38.51907], [-122.75588, 38.5195], [-122.75601, 38.51958], [-122.75809, 38.52169], [-122.759, 38.52186], [-122.75947, 38.5216], [-122.76249, 38.52478], [-122.76285, 38.52506], [-122.76325, 38.52529]]]} | Open Access 1 | 750 | Shiloh Ranch Regional Park | 31718 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/Get_Outdoors/Parks/Shiloh_Ranch_Regional_Park.aspx | Sonoma 16 | 843.329 | Shiloh Ranch RP | 0 | Local Park 2 | 4 |
16282 | 16282 | 16281 | {"type": "Polygon", "coordinates": [[[-122.52557, 38.35429], [-122.52529, 38.35427], [-122.5248, 38.35462], [-122.52536, 38.35545], [-122.52539, 38.35575], [-122.52503, 38.35602], [-122.52486, 38.35606], [-122.52475, 38.35616], [-122.52477, 38.35651], [-122.52474, 38.35681], [-122.52468, 38.35709], [-122.52456, 38.35736], [-122.52425, 38.35777], [-122.52421, 38.35787], [-122.52416, 38.35806], [-122.52425, 38.35824], [-122.52281, 38.35888], [-122.52259, 38.35915], [-122.52234, 38.35954], [-122.52236, 38.35965], [-122.52336, 38.35959], [-122.5236, 38.36051], [-122.52408, 38.36046], [-122.52412, 38.3607], [-122.52367, 38.36077], [-122.52378, 38.36121], [-122.52254, 38.36143], [-122.5227, 38.36212], [-122.5213, 38.36288], [-122.52164, 38.3638], [-122.52138, 38.36391], [-122.5212, 38.36404], [-122.52104, 38.36425], [-122.52107, 38.36436], [-122.52115, 38.36446], [-122.52119, 38.36447], [-122.52126, 38.36458], [-122.52072, 38.36467], [-122.51872, 38.36549], [-122.51876, 38.36587], [-122.51774, 38.3664], [-122.51711, 38.36563], [-122.514, 38.36719], [-122.51335, 38.36655], [-122.51271, 38.36695], [-122.51234, 38.36659], [-122.51065, 38.36488], [-122.51199, 38.36403], [-122.51199, 38.36401], [-122.51098, 38.36304], [-122.50966, 38.36392], [-122.50786, 38.36203], [-122.50409, 38.35769], [-122.5035, 38.35687], [-122.50362, 38.35661], [-122.50486, 38.35638], [-122.50626, 38.35783], [-122.50884, 38.36008], [-122.5115, 38.36128], [-122.51253, 38.36145], [-122.51698, 38.36], [-122.51733, 38.35999], [-122.52143, 38.35607], [-122.52185, 38.35259], [-122.52229, 38.35282], [-122.52313, 38.35341], [-122.52273, 38.35355], [-122.52312, 38.35407], [-122.52331, 38.35389], [-122.52472, 38.35344], [-122.52557, 38.35429]]]} | Open Access 1 | 1008 | Sonoma Valley Regional Park | 25619 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 254.384 | Sonoma Valley RP | 1978 | Local Park 2 | 4 | |
16306 | 16306 | 16305 | {"type": "MultiPolygon", "coordinates": [[[[-122.64607, 38.45736], [-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], [-122.64835, 38.45774], [-122.64824, 38.45775], [-122.6469, 38.45746], [-122.64607, 38.45736]]], [[[-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.46065], [-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.65138, 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.45749], [-122.64865, 38.45735], [-122.64848, 38.45642], [-122.64841, 38.45632], [-122.64833, 38.45627], [-122.64821, 38.45626], [-122.64716, 38.45652], [-122.64707, 38.45652], [-122.64701, 38.45649], [-122.64697, 38.45644], [-122.64697, 38.45638], [-122.64733, 38.45561], [-122.64859, 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.45478], [-122.64836, 38.45463], [-122.64792, 38.45453], [-122.64786, 38.45448], [-122.64827, 38.45362], [-122.64812, 38.45357], [-122.64859, 38.45262], [-122.64857, 38.45182], [-122.64782, 38.44613], [-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.44305], [-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.65289, 38.44828], [-122.65288, 38.44824], [-122.65402, 38.44754], [-122.65408, 38.44759], [-122.65441, 38.44738], [-122.6548, 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]]]]} | Open Access 1 | 1079 | Spring Lake Regional Park | 28940 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/Get_Outdoors/Parks/Spring_Lake_Regional_Park.aspx | Sonoma 16 | 317.518 | Spring Lake RP | 1970 | Local Park 2 | 4 |
6176 | 6176 | 6175 | {"type": "MultiPolygon", "coordinates": [[[[-123.2971, 38.55168], [-123.29264, 38.55172], [-123.29262, 38.55843], [-123.28327, 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.29114, 38.55358], [-123.29117, 38.5534], [-123.29166, 38.55278], [-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.54727], [-123.29626, 38.54808], [-123.29655, 38.54829], [-123.29661, 38.5483], [-123.29598, 38.54857], [-123.29624, 38.54911], [-123.29529, 38.54976], [-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.54637], [-123.29696, 38.54622], [-123.29792, 38.54586], [-123.29788, 38.54592], [-123.29782, 38.54652], [-123.29766, 38.54681], [-123.29788, 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.5473], [-123.30145, 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.54799], [-123.3027, 38.5481], [-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.3052, 38.54982], [-123.30552, 38.54973], [-123.30556, 38.54986], [-123.30553, 38.54997], [-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.55123], [-123.30587, 38.55154], [-123.30629, 38.55168]]]]} | Open Access 1 | 1200 | Stillwater Cove Regional Park | 27895 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/Get_Outdoors/Parks/Stillwater_Cove_Regional_Park.aspx | Sonoma 16 | 197.641 | Stillwater Cove RP | 0 | Local Park 2 | 4 |
509 | 509 | 508 | {"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 | 1700 | Cloverdale River Park | 17444 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 3.11 | Cloverdale River Park | 0 | Local Park 2 | 4 | |
3915 | 3915 | 3914 | {"type": "Polygon", "coordinates": [[[-123.05717, 38.323], [-123.05659, 38.32356], [-123.05543, 38.32636], [-123.05548, 38.31987], [-123.05563, 38.32022], [-123.05684, 38.32104], [-123.05715, 38.32178], [-123.05717, 38.323]]]} | Open Access 1 | 2027 | Westside Park | 27424 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 14.966 | Westside Park | 0 | Local Park 2 | 4 | |
6669 | 6669 | 6668 | {"type": "Polygon", "coordinates": [[[-122.93357, 38.50331], [-122.93325, 38.50346], [-122.93298, 38.5036], [-122.93239, 38.5041], [-122.931, 38.50576], [-122.93081, 38.50605], [-122.93028, 38.50578], [-122.92985, 38.50562], [-122.92885, 38.50603], [-122.92903, 38.50549], [-122.92937, 38.50469], [-122.92999, 38.50409], [-122.9304, 38.5034], [-122.93119, 38.50257], [-122.93355, 38.50257], [-122.93357, 38.50331]]]} | Open Access 1 | 4802 | Sunset Beach | 26041 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 19.635 | Sunset Beach | 0 | Local Park 2 | 4 | |
16309 | 16309 | 16308 | {"type": "Polygon", "coordinates": [[[-122.8705, 38.51272], [-122.86999, 38.51343], [-122.86999, 38.51352], [-122.86958, 38.51497], [-122.86766, 38.5152], [-122.86677, 38.51544], [-122.86557, 38.51623], [-122.86497, 38.5169], [-122.8643, 38.51739], [-122.86339, 38.51778], [-122.86351, 38.51797], [-122.86269, 38.51846], [-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.52129], [-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.85979, 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 | 5369 | Riverfront Regional Park | 12628 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/Get_Outdoors/Parks/Riverfront_Regional_Park.aspx | Sonoma 16 | 303.937 | Riverfront RP | 0 | Local Park 2 | 4 |
6817 | 6817 | 6816 | {"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.29827], [-122.45582, 38.29787], [-122.45582, 38.29775], [-122.45579, 38.29751], [-122.45582, 38.29721], [-122.45793, 38.29742]]]} | Open Access 1 | 5388 | Arnold Park | 15603 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 11.311 | Arnold Park | 1978 | Local Park 2 | 4 | |
16342 | 16342 | 16341 | {"type": "Polygon", "coordinates": [[[-122.52762, 38.20438], [-122.52325, 38.20854], [-122.52325, 38.20856], [-122.52512, 38.2094], [-122.51982, 38.21673], [-122.51958, 38.21647], [-122.51926, 38.21618], [-122.51815, 38.21741], [-122.51667, 38.21364], [-122.51098, 38.21317], [-122.50883, 38.2148], [-122.50824, 38.21367], [-122.50585, 38.21091], [-122.50337, 38.21308], [-122.50291, 38.21352], [-122.50207, 38.2126], [-122.50144, 38.21335], [-122.50422, 38.21553], [-122.50528, 38.21642], [-122.50179, 38.21996], [-122.50108, 38.21932], [-122.4997, 38.21796], [-122.49899, 38.21761], [-122.49727, 38.21635], [-122.49355, 38.21056], [-122.49168, 38.20981], [-122.49141, 38.20911], [-122.49104, 38.20866], [-122.49079, 38.20864], [-122.49065, 38.20851], [-122.48982, 38.20798], [-122.48954, 38.20759], [-122.48867, 38.20715], [-122.48661, 38.20644], [-122.48646, 38.20407], [-122.48661, 38.20199], [-122.48829, 38.20128], [-122.49001, 38.20127], [-122.49121, 38.20014], [-122.49131, 38.20017], [-122.49296, 38.20041], [-122.49345, 38.20052], [-122.49471, 38.20059], [-122.49535, 38.20044], [-122.49584, 38.19983], [-122.49615, 38.19923], [-122.49699, 38.19896], [-122.49788, 38.19934], [-122.50009, 38.19971], [-122.50075, 38.19966], [-122.50117, 38.19909], [-122.50102, 38.19718], [-122.49859, 38.19435], [-122.49774, 38.19403], [-122.49642, 38.19371], [-122.49675, 38.19327], [-122.49749, 38.19298], [-122.49792, 38.19256], [-122.4978, 38.1924], [-122.49726, 38.19196], [-122.49721, 38.19188], [-122.4972, 38.19182], [-122.49723, 38.19179], [-122.49721, 38.19176], [-122.49722, 38.19166], [-122.4979, 38.1917], [-122.49852, 38.19165], [-122.49856, 38.19169], [-122.49855, 38.19173], [-122.49868, 38.1918], [-122.49954, 38.19151], [-122.50035, 38.19151], [-122.50035, 38.19147], [-122.50063, 38.19144], [-122.50129, 38.1908], [-122.50154, 38.19038], [-122.50157, 38.1901], [-122.50168, 38.18995], [-122.50186, 38.18985], [-122.50224, 38.18976], [-122.50272, 38.18956], [-122.50343, 38.18921], [-122.50568, 38.18696], [-122.50996, 38.18359], [-122.51644, 38.18887], [-122.51587, 38.18959], [-122.51482, 38.19013], [-122.51436, 38.19038], [-122.51165, 38.19146], [-122.51164, 38.19148], [-122.51377, 38.19288], [-122.51577, 38.19418], [-122.51921, 38.19581], [-122.52091, 38.19654], [-122.5191, 38.19805], [-122.5242, 38.20139], [-122.52424, 38.20149], [-122.52762, 38.20438]]]} | Open Access 1 | 9819 | Tolay Lake Regional Park | 33777 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 1760.959 | Tolay Lake RP | 0 | Local Park 2 | 4 | |
1463 | 1463 | 1462 | {"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 | 9872 | Alder Park | 15346 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 4.856 | Alder Park | 1968 | Local Park 2 | 4 | |
9420 | 9420 | 9419 | {"type": "Polygon", "coordinates": [[[-123.05536, 38.30749], [-123.05526, 38.30881], [-123.05482, 38.3093], [-123.05449, 38.30985], [-123.05389, 38.3106], [-123.05381, 38.31073], [-123.05336, 38.31099], [-123.05271, 38.31085], [-123.05204, 38.31209], [-123.05247, 38.31223], [-123.05211, 38.31252], [-123.05146, 38.31243], [-123.05089, 38.31263], [-123.05089, 38.31305], [-123.05159, 38.3135], [-123.05176, 38.31343], [-123.05197, 38.31398], [-123.05153, 38.3146], [-123.04908, 38.3153], [-123.04772, 38.31479], [-123.04535, 38.31581], [-123.04405, 38.31605], [-123.04358, 38.31544], [-123.03792, 38.31534], [-123.03715, 38.31488], [-123.03658, 38.31479], [-123.03543, 38.31464], [-123.0351, 38.31413], [-123.03432, 38.31398], [-123.03237, 38.31444], [-123.03214, 38.31519], [-123.03289, 38.31649], [-123.03326, 38.31662], [-123.03355, 38.31704], [-123.0338, 38.31748], [-123.0342, 38.31713], [-123.03716, 38.31699], [-123.03812, 38.31779], [-123.03826, 38.31904], [-123.03901, 38.31955], [-123.0386, 38.3206], [-123.03665, 38.32206], [-123.03545, 38.32075], [-123.03477, 38.32007], [-123.03538, 38.31965], [-123.03564, 38.31963], [-123.03614, 38.31913], [-123.03616, 38.31802], [-123.03411, 38.31802], [-123.03459, 38.3185], [-123.03456, 38.31932], [-123.03478, 38.3195], [-123.03459, 38.31992], [-123.03388, 38.31903], [-123.03378, 38.31836], [-123.03266, 38.31667], [-123.03265, 38.31668], [-123.03263, 38.31679], [-123.03245, 38.31704], [-123.03214, 38.31721], [-123.03169, 38.31732], [-123.03143, 38.31736], [-123.03125, 38.31741], [-123.0311, 38.31735], [-123.03111, 38.31724], [-123.03179, 38.31724], [-123.03234, 38.31701], [-123.03253, 38.31669], [-123.03251, 38.31646], [-123.03158, 38.31477], [-123.03329, 38.31344], [-123.03431, 38.31372], [-123.03501, 38.31376], [-123.0353, 38.31268], [-123.03559, 38.31271], [-123.03806, 38.31313], [-123.04117, 38.31311], [-123.04334, 38.31293], [-123.04432, 38.31298], [-123.04469, 38.31382], [-123.0469, 38.31329], [-123.05115, 38.31187], [-123.05304, 38.30996], [-123.05304, 38.30994], [-123.05076, 38.31098], [-123.04776, 38.31195], [-123.05147, 38.31046], [-123.05324, 38.30831], [-123.05338, 38.30651], [-123.05313, 38.30599], [-123.05033, 38.30576], [-123.05341, 38.30563], [-123.05465, 38.30624], [-123.05536, 38.30749]]]} | Open Access 1 | 15747 | Doran Park | 18216 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 161.452 | Doran Park | 0 | Local Park 2 | 4 | |
9605 | 9605 | 9604 | {"type": "Polygon", "coordinates": [[[-122.49053, 38.30297], [-122.49039, 38.30284], [-122.49011, 38.30262], [-122.48963, 38.30238], [-122.48939, 38.30214], [-122.48932, 38.30204], [-122.4892, 38.30194], [-122.4891, 38.30188], [-122.48889, 38.30184], [-122.48857, 38.30189], [-122.48751, 38.30222], [-122.48744, 38.30222], [-122.48741, 38.3022], [-122.48739, 38.30215], [-122.48778, 38.30202], [-122.48781, 38.30207], [-122.4896, 38.3014], [-122.48976, 38.30169], [-122.48999, 38.30208], [-122.49019, 38.30247], [-122.49053, 38.30297]]]} | Open Access 1 | 16158 | Ernie Smith Community Park | 18699 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 2.099 | Ernie Smith Community Park | 0 | Local Park 2 | 4 | |
16354 | 16354 | 16353 | {"type": "Polygon", "coordinates": [[[-122.66029, 38.21986], [-122.66026, 38.22123], [-122.65864, 38.2212], [-122.65548, 38.2198], [-122.6538, 38.21978], [-122.65369, 38.21958], [-122.65329, 38.21977], [-122.65311, 38.2196], [-122.65234, 38.21908], [-122.6527, 38.21875], [-122.65269, 38.21873], [-122.65166, 38.21821], [-122.65107, 38.21856], [-122.65112, 38.21616], [-122.6557, 38.21616], [-122.6557, 38.21981], [-122.66029, 38.21986]]]} | Open Access 1 | 16320 | Helen Putnam Regional Park | 19801 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 45.192 | Helen Putnam RP | 1975 | Local Park 2 | 4 | |
16359 | 16359 | 16358 | {"type": "Polygon", "coordinates": [[[-122.79808, 38.56412], [-122.79667, 38.5642], [-122.79668, 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.56209], [-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.55743], [-122.78848, 38.55791], [-122.78828, 38.55829], [-122.78866, 38.55892], [-122.7888, 38.55986], [-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.79806, 38.56119], [-122.79809, 38.56396], [-122.79808, 38.56412]]]} | Open Access 1 | 16477 | Foothill Regional Park | 29216 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/Get_Outdoors/Parks/Foothill_Regional_Park.aspx | Sonoma 16 | 210.538 | Foothill RP | 0 | Local Park 2 | 4 |
9864 | 9864 | 9863 | {"type": "Polygon", "coordinates": [[[-122.86089, 38.60384], [-122.85952, 38.60399], [-122.85916, 38.60402], [-122.85886, 38.60401], [-122.8585, 38.60396], [-122.8582, 38.60389], [-122.85746, 38.60366], [-122.85744, 38.60272], [-122.85745, 38.60242], [-122.85911, 38.60249], [-122.85889, 38.60257], [-122.8589, 38.60259], [-122.86002, 38.60241], [-122.86001, 38.60233], [-122.85989, 38.60215], [-122.8603, 38.60215], [-122.8604, 38.60242], [-122.86034, 38.60245], [-122.86039, 38.60261], [-122.86064, 38.60261], [-122.86089, 38.60384]]]} | Open Access 1 | 16898 | Healdsburg Beach | 19769 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 11.608 | Healdsburg Beach | 0 | Local Park 2 | 4 | |
9228 | 9228 | 9227 | {"type": "Polygon", "coordinates": [[[-122.66499, 38.21258], [-122.66493, 38.21342], [-122.66496, 38.21991], [-122.65569, 38.21981], [-122.65572, 38.21288], [-122.65887, 38.21287], [-122.65922, 38.2125], [-122.66047, 38.21133], [-122.66499, 38.21258]]]} | Open Access 1 | 16914 | Helen Putnam Park | 19799 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 168.099 | Helen Putnam Park | 1978 | Local Park 2 | 4 | |
9981 | 9981 | 9980 | {"type": "Polygon", "coordinates": [[[-122.54867, 38.41193], [-122.54776, 38.4126], [-122.54691, 38.41186], [-122.54758, 38.41137], [-122.54782, 38.41122], [-122.54824, 38.41153], [-122.54867, 38.41193]]]} | Open Access 1 | 17178 | Kenwood Plaza Park | 20624 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 2.982 | Kenwood Plaza Park | 1951 | Local Park 2 | 4 | |
5466 | 5466 | 5465 | {"type": "Polygon", "coordinates": [[[-122.49033, 38.31713], [-122.48955, 38.31716], [-122.4894, 38.31763], [-122.48924, 38.3178], [-122.48702, 38.3187], [-122.48673, 38.31831], [-122.48645, 38.31798], [-122.48724, 38.31765], [-122.48849, 38.317], [-122.48879, 38.31681], [-122.48949, 38.31649], [-122.48954, 38.31627], [-122.48958, 38.31644], [-122.48957, 38.31649], [-122.48962, 38.31662], [-122.48984, 38.31689], [-122.49033, 38.31713]]]} | Open Access 1 | 17295 | Larson Park | 21037 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 7.602 | Larson Park | 1987 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);