units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
26 rows where COUNTY = 16 and DES_TP = 3
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, AGNCY_ID, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, LABEL_NAME, YR_EST
MNG_AGENCY 11
- Rohnert Park, City of 6
- Petaluma, City of 5
- Santa Rosa, City of 3
- Sonoma County Regional Parks Dept., County of 3
- Healdsburg, City of 3
- Sonoma County Water Agency 1
- Windsor, Town of 1
- Cotati, City of 1
- Cloverdale, City of 1
- Monte Rio Recreation and Park District 1
- Russian River Recreation and Park District 1
MNG_AG_TYP 4
ACCESS_TYP 3
DES_TP 1
- Local Recreation Area · 26 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1472 | 1472 | 1471 | {"type": "Polygon", "coordinates": [[[-122.62727, 38.24423], [-122.62614, 38.24562], [-122.62614, 38.24564], [-122.62491, 38.24476], [-122.62415, 38.24407], [-122.6233, 38.24296], [-122.62246, 38.24147], [-122.62271, 38.24132], [-122.62324, 38.24158], [-122.62375, 38.24187], [-122.62435, 38.24203], [-122.62705, 38.24364], [-122.62685, 38.24396], [-122.62727, 38.24423]]]} | Open Access 1 | 10010 | Kenilworth Athletic Fields | 20596 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 20.13 | Kenilworth Athletic Fields | 0 | Local Recreation Area 3 | 4 | |
3216 | 3216 | 3215 | {"type": "Polygon", "coordinates": [[[-122.69706, 38.34239], [-122.69676, 38.3424], [-122.69675, 38.34203], [-122.69679, 38.34203], [-122.69684, 38.34205], [-122.69706, 38.34239]]]} | Open Access 1 | 28195 | Carlita Circle Tot Lot | 16858 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.163 | Carlita Circle Tot Lot | 0 | Local Recreation Area 3 | 4 | |
3217 | 3217 | 3216 | {"type": "Polygon", "coordinates": [[[-122.69549, 38.34679], [-122.69543, 38.34722], [-122.69517, 38.34718], [-122.69523, 38.34676], [-122.69549, 38.34679]]]} | Open Access 1 | 28197 | Civic Center Tot Lot | 17370 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.273 | Civic Ctr. Tot Lot | 0 | Local Recreation Area 3 | 4 | |
3550 | 3550 | 3549 | {"type": "Polygon", "coordinates": [[[-122.79598, 38.68638], [-122.79593, 38.68645], [-122.79587, 38.68663], [-122.79584, 38.68702], [-122.79582, 38.68712], [-122.79577, 38.68724], [-122.79549, 38.68779], [-122.79545, 38.68786], [-122.79501, 38.68816], [-122.79483, 38.68832], [-122.79478, 38.68849], [-122.79478, 38.68903], [-122.79483, 38.68923], [-122.79486, 38.68944], [-122.79482, 38.68962], [-122.79478, 38.68969], [-122.79471, 38.68978], [-122.79457, 38.68984], [-122.79425, 38.68987], [-122.79372, 38.68983], [-122.79362, 38.68984], [-122.79311, 38.68994], [-122.79276, 38.69005], [-122.79265, 38.69012], [-122.79244, 38.6902], [-122.79194, 38.69034], [-122.79182, 38.69038], [-122.79175, 38.69043], [-122.79171, 38.6905], [-122.79168, 38.69063], [-122.79137, 38.69088], [-122.79073, 38.69135], [-122.79069, 38.69141], [-122.79067, 38.69148], [-122.7907, 38.6916], [-122.79102, 38.69195], [-122.79109, 38.69208], [-122.79115, 38.69228], [-122.79115, 38.69241], [-122.79113, 38.69252], [-122.79101, 38.69282], [-122.79094, 38.6929], [-122.79085, 38.69297], [-122.79052, 38.69312], [-122.79023, 38.69322], [-122.79012, 38.69328], [-122.78934, 38.69224], [-122.78925, 38.6893], [-122.78809, 38.68905], [-122.7847, 38.68871], [-122.78467, 38.68598], [-122.79598, 38.68638]]]} | No Public Access 3 | 28288 | Bear Canyon | 15921 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 98.229 | Bear Canyon | 0 | Local Recreation Area 3 | 4 | |
4336 | 4336 | 4335 | {"type": "Polygon", "coordinates": [[[-122.71107, 38.3234], [-122.71084, 38.32403], [-122.71063, 38.32398], [-122.71059, 38.3241], [-122.7104, 38.32405], [-122.71029, 38.32437], [-122.70936, 38.32406], [-122.7094, 38.32375], [-122.7102, 38.32358], [-122.70955, 38.32271], [-122.71002, 38.32241], [-122.71082, 38.32344], [-122.71107, 38.3234]]]} | Open Access 1 | 45501 | Civic Center | 28334 | 1072 | Cotati, City of 356 | City 2 | City Agency 2 | http://www.ci.cotati.ca.us/ | City 2 | 1072 | Cotati, City of 353 | City 2 | City Agency 2 | Sonoma 16 | 3.743 | Civic Ctr. | 0 | Local Recreation Area 3 | 4 | |
6468 | 6468 | 6467 | {"type": "MultiPolygon", "coordinates": [[[[-122.74142, 38.38883], [-122.74142, 38.38912], [-122.74052, 38.38931], [-122.74025, 38.38942], [-122.74005, 38.38956], [-122.74005, 38.38978], [-122.73976, 38.38978], [-122.73911, 38.39028], [-122.73899, 38.39041], [-122.73891, 38.39054], [-122.73887, 38.39067], [-122.73886, 38.39079], [-122.73887, 38.39437], [-122.73885, 38.39455], [-122.73879, 38.39469], [-122.73872, 38.39481], [-122.7386, 38.39494], [-122.73848, 38.39503], [-122.7382, 38.39515], [-122.73799, 38.3952], [-122.73777, 38.39522], [-122.73765, 38.39526], [-122.7375, 38.39537], [-122.7374, 38.39552], [-122.73738, 38.39562], [-122.73734, 38.39998], [-122.73682, 38.40138], [-122.73675, 38.4015], [-122.73664, 38.40163], [-122.73664, 38.40176], [-122.73591, 38.40176], [-122.73591, 38.40166], [-122.73629, 38.40145], [-122.73637, 38.40139], [-122.73644, 38.40129], [-122.73694, 38.39994], [-122.73698, 38.39577], [-122.73702, 38.39553], [-122.73715, 38.39531], [-122.73726, 38.39519], [-122.73737, 38.3951], [-122.73755, 38.395], [-122.73775, 38.39492], [-122.73785, 38.3949], [-122.73805, 38.39489], [-122.73822, 38.39483], [-122.73833, 38.39476], [-122.73839, 38.3947], [-122.73847, 38.39455], [-122.73847, 38.39449], [-122.73846, 38.39084], [-122.73847, 38.39068], [-122.73845, 38.39046], [-122.73845, 38.38979], [-122.73923, 38.38978], [-122.7399, 38.38926], [-122.74015, 38.38912], [-122.74045, 38.38902], [-122.74142, 38.38883]]], [[[-122.79439, 38.41096], [-122.79362, 38.41148], [-122.79274, 38.41262], [-122.77349, 38.42377], [-122.77304, 38.42401], [-122.77254, 38.42422], [-122.77202, 38.42438], [-122.77147, 38.4245], [-122.77137, 38.42451], [-122.77149, 38.42432], [-122.77187, 38.42425], [-122.7723, 38.42413], [-122.77263, 38.42401], [-122.77314, 38.42377], [-122.77698, 38.42154], [-122.79231, 38.41266], [-122.79347, 38.41134], [-122.79382, 38.41106], [-122.79419, 38.41084], [-122.79429, 38.41082], [-122.79439, 38.41096]]], [[[-122.82205, 38.40048], [-122.82103, 38.4002], [-122.82066, 38.40014], [-122.81959, 38.40004], [-122.8193, 38.40005], [-122.81872, 38.40014], [-122.81818, 38.40034], [-122.81817, 38.40037], [-122.81794, 38.40048], [-122.81787, 38.40049], [-122.81783, 38.40059], [-122.81641, 38.40121], [-122.81613, 38.40122], [-122.81322, 38.40262], [-122.81108, 38.40358], [-122.80996, 38.40406], [-122.80995, 38.40408], [-122.81004, 38.40422], [-122.80805, 38.40508], [-122.80696, 38.40559], [-122.80685, 38.40547], [-122.80115, 38.40793], [-122.79977, 38.40866], [-122.79921, 38.40902], [-122.79523, 38.41068], [-122.79523, 38.4107], [-122.79528, 38.41073], [-122.7947, 38.41105], [-122.79446, 38.41071], [-122.79601, 38.41007], [-122.79838, 38.40919], [-122.79906, 38.40885], [-122.80001, 38.40832], [-122.8008, 38.40792], [-122.80102, 38.40784], [-122.80424, 38.40644], [-122.80551, 38.40586], [-122.81088, 38.40348], [-122.81587, 38.40123], [-122.81592, 38.40123], [-122.81747, 38.40052], [-122.81749, 38.40055], [-122.81767, 38.40043], [-122.8179, 38.40032], [-122.8184, 38.40014], [-122.81907, 38.39994], [-122.82013, 38.39995], [-122.82107, 38.40003], [-122.82127, 38.40006], [-122.82169, 38.40018], [-122.82191, 38.4001], [-122.82205, 38.40048]]], [[[-122.84334, 38.41328], [-122.84326, 38.41327], [-122.84285, 38.41308], [-122.84222, 38.41295], [-122.84067, 38.41273], [-122.83947, 38.41259], [-122.83806, 38.4124], [-122.83767, 38.41231], [-122.83712, 38.41204], [-122.8369, 38.41187], [-122.8367, 38.4117], [-122.83626, 38.41117], [-122.83523, 38.40958], [-122.83446, 38.40831], [-122.83404, 38.40772], [-122.83366, 38.40735], [-122.83344, 38.4072], [-122.8332, 38.40706], [-122.83268, 38.40684], [-122.83255, 38.40681], [-122.83222, 38.4068], [-122.83172, 38.40681], [-122.82991, 38.40702], [-122.82933, 38.40711], [-122.82867, 38.40715], [-122.82838, 38.40714], [-122.82795, 38.40704], [-122.82748, 38.40684], [-122.82744, 38.40684], [-122.82732, 38.40688], [-122.8273, 38.40684], [-122.82743, 38.4068], [-122.82749, 38.40681], [-122.82796, 38.40701], [-122.82838, 38.4071], [-122.82867, 38.40711], [-122.82932, 38.40707], [-122.8299, 38.40699], [-122.83171, 38.40677], [-122.83222, 38.40676], [-122.83256, 38.40678], [-122.8327, 38.40681], [-122.83323, 38.40703], [-122.83347, 38.40717], [-122.83369, 38.40732], [-122.83408, 38.4077], [-122.8345, 38.4083], [-122.83527, 38.40956], [-122.8363, 38.41115], [-122.83673, 38.41168], [-122.83693, 38.41185], [-122.83715, 38.41201], [-122.83769, 38.41227], [-122.83807, 38.41236], [-122.83948, 38.41255], [-122.84068, 38.4127], [-122.84223, 38.41292], [-122.84287, 38.41305], [-122.8433, 38.41324], [-122.84334, 38.41328]]], [[[-122.86975, 38.4327], [-122.86971, 38.43273], [-122.86969, 38.43271], [-122.86956, 38.43239], [-122.86937, 38.43182], [-122.86855, 38.42999], [-122.86735, 38.4271], [-122.86715, 38.42673], [-122.86689, 38.42633], [-122.86548, 38.42441], [-122.86532, 38.42421], [-122.86503, 38.42399], [-122.86473, 38.42379], [-122.86439, 38.42362], [-122.86401, 38.4235], [-122.86407, 38.42349], [-122.86441, 38.42359], [-122.86476, 38.42376], [-122.86506, 38.42396], [-122.86535, 38.42418], [-122.86552, 38.42439], [-122.86693, 38.42632], [-122.86719, 38.42672], [-122.86739, 38.42709], [-122.86859, 38.42998], [-122.86942, 38.43181], [-122.8696, 38.43238], [-122.86973, 38.43269], [-122.86975, 38.4327]]]]} | Open Access 1 | 2004 | West County Trail | 27354 | 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 | 43.048 | West County Trail | 2001 | Local Recreation Area 3 | 4 | |
6814 | 6814 | 6813 | {"type": "Polygon", "coordinates": [[[-123.46324, 38.71823], [-123.46307, 38.71844], [-123.46268, 38.71853], [-123.462, 38.7182], [-123.46154, 38.718], [-123.46092, 38.71756], [-123.46035, 38.71794], [-123.46014, 38.71771], [-123.46062, 38.71733], [-123.46034, 38.71712], [-123.46072, 38.7168], [-123.4604, 38.71654], [-123.45998, 38.71683], [-123.45938, 38.71635], [-123.459, 38.71634], [-123.45842, 38.71686], [-123.45836, 38.71741], [-123.45924, 38.71795], [-123.45973, 38.71755], [-123.46009, 38.71788], [-123.45959, 38.71821], [-123.46124, 38.71936], [-123.46154, 38.71944], [-123.46112, 38.71959], [-123.45775, 38.71717], [-123.45965, 38.71544], [-123.45979, 38.71563], [-123.46029, 38.71609], [-123.46042, 38.71632], [-123.46077, 38.71656], [-123.46122, 38.71694], [-123.46083, 38.71715], [-123.46083, 38.71716], [-123.46142, 38.7175], [-123.46185, 38.7175], [-123.4625, 38.71806], [-123.46311, 38.71809], [-123.46324, 38.71823]]]} | Open Access 1 | 5386 | Sea Ranch Trail Access | 25235 | 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 | 10.372 | Sea Ranch Trail Access | 0 | Local Recreation Area 3 | 4 | |
7752 | 7752 | 7751 | {"type": "Polygon", "coordinates": [[[-122.80614, 38.53533], [-122.80383, 38.53537], [-122.80381, 38.53476], [-122.80379, 38.53466], [-122.80367, 38.53444], [-122.80294, 38.53361], [-122.80285, 38.53341], [-122.80282, 38.53316], [-122.80287, 38.5331], [-122.80298, 38.53308], [-122.80418, 38.53305], [-122.80593, 38.53511], [-122.80614, 38.53533]]]} | Open Access 1 | 8327 | Wilson Ranch Soccer Park | 27614 | 1382 | Windsor, Town of 331 | City 2 | City Agency 2 | http://www.ci.windsor.ca.us/index.aspx?nid=171 | City 2 | 1382 | Windsor, Town of 328 | City 2 | City Agency 2 | Sonoma 16 | 9.673 | Wilson Ranch Soccer Park | 0 | Local Recreation Area 3 | 4 | |
8368 | 8368 | 8367 | {"type": "MultiPolygon", "coordinates": [[[[-122.8819, 38.50978], [-122.88186, 38.51002], [-122.88176, 38.51014], [-122.88162, 38.5104], [-122.88159, 38.51054], [-122.88151, 38.51067], [-122.88141, 38.51077], [-122.88126, 38.51086], [-122.88088, 38.51061], [-122.8812, 38.5103], [-122.88169, 38.50992], [-122.8819, 38.50978]]], [[[-122.88531, 38.50783], [-122.88512, 38.50832], [-122.88477, 38.50976], [-122.88456, 38.5105], [-122.88513, 38.51092], [-122.88478, 38.5112], [-122.88451, 38.51099], [-122.88443, 38.51103], [-122.88179, 38.51059], [-122.88182, 38.51042], [-122.88196, 38.51017], [-122.88206, 38.51004], [-122.88209, 38.50993], [-122.88231, 38.508], [-122.8826, 38.50756], [-122.88267, 38.50742], [-122.8843, 38.50766], [-122.88531, 38.50783]]], [[[-122.88492, 38.50302], [-122.88409, 38.50576], [-122.88457, 38.50732], [-122.88475, 38.50759], [-122.88305, 38.50733], [-122.88265, 38.50728], [-122.88271, 38.50674], [-122.88302, 38.50668], [-122.88412, 38.50303], [-122.88492, 38.50302]]]]} | Open Access 1 | 5385 | Wohler Bridge Fishing Access | 27669 | 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 | 33.446 | Wohler Bridge FA | 0 | Local Recreation Area 3 | 4 | |
9576 | 9576 | 9575 | {"type": "Polygon", "coordinates": [[[-122.61166, 38.265], [-122.61098, 38.26576], [-122.60488, 38.26235], [-122.6057, 38.26144], [-122.60662, 38.26161], [-122.60843, 38.26232], [-122.60952, 38.26339], [-122.61136, 38.26423], [-122.61166, 38.265]]]} | Open Access 1 | 47844 | Petaluma Community Sports Fields | 31786 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/parks-pages/petaluma-comm-sport-fields.html | Sonoma 16 | 24.892 | Petaluma Community Sports Fields | 2015 | Local Recreation Area 3 | 4 |
10343 | 10343 | 10342 | {"type": "Polygon", "coordinates": [[[-122.66467, 38.42516], [-122.66241, 38.42639], [-122.66227, 38.4263], [-122.66226, 38.42719], [-122.65949, 38.42718], [-122.65908, 38.42721], [-122.65845, 38.42668], [-122.65832, 38.42654], [-122.65644, 38.4244], [-122.65601, 38.42344], [-122.65578, 38.42204], [-122.65565, 38.42202], [-122.65546, 38.42204], [-122.65549, 38.4217], [-122.65548, 38.42103], [-122.65551, 38.41987], [-122.65565, 38.41987], [-122.65588, 38.4191], [-122.65722, 38.41788], [-122.65756, 38.41741], [-122.6573, 38.4169], [-122.65799, 38.41691], [-122.6584, 38.41785], [-122.65968, 38.41786], [-122.65969, 38.41989], [-122.66115, 38.4199], [-122.66231, 38.41954], [-122.66239, 38.41954], [-122.66292, 38.41936], [-122.66368, 38.41889], [-122.66412, 38.4193], [-122.6643, 38.41953], [-122.66441, 38.4197], [-122.66452, 38.41991], [-122.66463, 38.42017], [-122.66468, 38.42039], [-122.66472, 38.42062], [-122.66473, 38.42089], [-122.66471, 38.42112], [-122.6646, 38.42152], [-122.66438, 38.42201], [-122.66428, 38.42228], [-122.66368, 38.42219], [-122.66363, 38.42242], [-122.6636, 38.42265], [-122.66358, 38.42288], [-122.6636, 38.42317], [-122.66364, 38.42345], [-122.66372, 38.42373], [-122.66392, 38.42421], [-122.66406, 38.42445], [-122.66427, 38.42473], [-122.66467, 38.42516]]]} | Restricted Access 2 | 29799 | Bennett Valley Municipal Golf Course | 33093 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 150.922 | Bennett Valley Municipal GC | 0 | Local Recreation Area 3 | 4 | |
11108 | 11108 | 11107 | {"type": "Polygon", "coordinates": [[[-122.6879, 38.32193], [-122.6879, 38.32224], [-122.6877, 38.32225], [-122.6877, 38.32193], [-122.6879, 38.32193]]]} | Open Access 1 | 28203 | Lilac Way Tot Lot | 21233 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.156 | Lilac Way Tot Lot | 0 | Local Recreation Area 3 | 4 | |
11252 | 11252 | 11251 | {"type": "Polygon", "coordinates": [[[-122.86822, 38.62425], [-122.86384, 38.62426], [-122.86382, 38.62265], [-122.86822, 38.62269], [-122.86822, 38.62425]]]} | Open Access 1 | 23635 | Healdsburg Municipal Pool | 19771 | 1131 | Healdsburg, City of 374 | City 2 | City Agency 2 | http://www.ci.healdsburg.ca.us/index.aspx?page=94 | City 2 | 1131 | Healdsburg, City of 369 | City 2 | City Agency 2 | Sonoma 16 | 16.657 | Healdsburg Municipal Pool | 0 | Local Recreation Area 3 | 4 | |
11494 | 11494 | 11493 | {"type": "Polygon", "coordinates": [[[-122.63742, 38.22602], [-122.63723, 38.22633], [-122.63703, 38.22625], [-122.63725, 38.22589], [-122.63737, 38.22594], [-122.63735, 38.22599], [-122.63742, 38.22602]]]} | Open Access 1 | 23637 | Cavanaugh Pool | 16981 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 0.205 | Cavanaugh Pool | 0 | Local Recreation Area 3 | 4 | |
12353 | 12353 | 12352 | {"type": "MultiPolygon", "coordinates": [[[[-123.01059, 38.48345], [-123.01015, 38.48391], [-123.00931, 38.48364], [-123.00931, 38.48303], [-123.01059, 38.48345]]], [[[-123.01075, 38.48424], [-123.01068, 38.48437], [-123.01059, 38.48435], [-123.01053, 38.48446], [-123.01034, 38.4843], [-123.01049, 38.48402], [-123.01075, 38.48424]]], [[[-123.01166, 38.4834], [-123.01106, 38.48346], [-123.01091, 38.48354], [-123.01092, 38.48356], [-123.01119, 38.48364], [-123.01093, 38.48417], [-123.01056, 38.48386], [-123.01054, 38.48387], [-123.01049, 38.48383], [-123.01078, 38.48354], [-123.01103, 38.48341], [-123.01165, 38.48335], [-123.01166, 38.4834]]]]} | Open Access 1 | 26077 | Vacation Beach Playground | 26752 | 2254 | Russian River Recreation and Park District 1020 | Special District 4 | Recreation/Parks District 4 | http://russianriverrecpark.org/ | Special District 4 | 2254 | Russian River Recreation and Park District 982 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 2.431 | Vacation Beach Playground | 0 | Local Recreation Area 3 | 4 | |
12468 | 12468 | 12467 | {"type": "Polygon", "coordinates": [[[-122.68291, 38.34386], [-122.68267, 38.34386], [-122.68266, 38.34356], [-122.6829, 38.34357], [-122.68291, 38.34386]]]} | Open Access 1 | 28196 | Foot Hills Mini Park / Jasmine Tot Lot | 18974 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.171 | Foot Hills MP / Jasmine Tot Lot | 0 | Local Recreation Area 3 | 4 | |
12475 | 12475 | 12474 | {"type": "Polygon", "coordinates": [[[-123.01051, 38.46415], [-123.0105, 38.46416], [-123.0102, 38.46403], [-123.01009, 38.46418], [-123.00969, 38.46411], [-123.00947, 38.46411], [-123.00923, 38.46412], [-123.00899, 38.46416], [-123.00876, 38.46422], [-123.00858, 38.46429], [-123.0084, 38.46439], [-123.00833, 38.46398], [-123.00833, 38.46379], [-123.00835, 38.4636], [-123.00844, 38.46333], [-123.00849, 38.46321], [-123.00877, 38.46319], [-123.00949, 38.46353], [-123.00979, 38.46345], [-123.00989, 38.46339], [-123.01042, 38.4637], [-123.01021, 38.46402], [-123.01051, 38.46415]]]} | Open Access 1 | 28246 | Amphitheater Park / Youth Center | 15462 | 2241 | Monte Rio Recreation and Park District 573 | Special District 4 | Recreation/Parks District 4 | http://www.mrrpd.org/ | Special District 4 | 2241 | Monte Rio Recreation and Park District 565 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 3.656 | Amphitheater Park / Youth Ctr. | 0 | Local Recreation Area 3 | 4 | |
12478 | 12478 | 12477 | {"type": "Polygon", "coordinates": [[[-122.70081, 38.32988], [-122.70061, 38.32996], [-122.70041, 38.32967], [-122.7006, 38.32959], [-122.70081, 38.32988]]]} | Open Access 1 | 28199 | Burton Avenue Tot Lot | 16528 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.17 | Burton Avenue Tot Lot | 0 | Local Recreation Area 3 | 4 | |
12756 | 12756 | 12755 | {"type": "Polygon", "coordinates": [[[-122.71297, 38.43721], [-122.7128, 38.43723], [-122.71289, 38.43736], [-122.71246, 38.4374], [-122.71245, 38.43726], [-122.71248, 38.43725], [-122.71247, 38.43715], [-122.71295, 38.43713], [-122.71297, 38.43721]]]} | Open Access 1 | 29787 | Prince Memorial Greenway | 24005 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 0.243 | Prince Memorial Greenway | 0 | Local Recreation Area 3 | 4 | |
13173 | 13173 | 13172 | {"type": "MultiPolygon", "coordinates": [[[[-122.58307, 38.22933], [-122.58238, 38.23007], [-122.57621, 38.22666], [-122.57633, 38.22647], [-122.57659, 38.22629], [-122.57685, 38.22617], [-122.5772, 38.22588], [-122.57777, 38.22573], [-122.57799, 38.2256], [-122.57872, 38.22483], [-122.57915, 38.22443], [-122.58083, 38.22535], [-122.58089, 38.22576], [-122.5804, 38.22629], [-122.58131, 38.22682], [-122.58105, 38.22709], [-122.58105, 38.22711], [-122.5828, 38.22811], [-122.58307, 38.22933]]], [[[-122.59172, 38.21766], [-122.59033, 38.21764], [-122.58878, 38.21814], [-122.58712, 38.21833], [-122.58596, 38.21827], [-122.58479, 38.21783], [-122.58391, 38.21714], [-122.58327, 38.21602], [-122.58331, 38.21486], [-122.58381, 38.21407], [-122.58571, 38.2127], [-122.58639, 38.21185], [-122.58784, 38.2134], [-122.59172, 38.21766]]]]} | No Public Access 3 | 35157 | Petaluma Marsh Acquisition, Enhancement and Access | 28158 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 112.939 | Petaluma Marsh Acquisition, Enhancement and Access | 0 | Local Recreation Area 3 | 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]);