units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
83 rows where MNG_AGENCY = 29 sorted by ACCESS_TYP descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST, GAP_STS
DES_TP 14
- Local Park 68
- Local Recreation Area 3
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 83
MNG_AGENCY 1
- Santa Rosa, City of · 83 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
723 | 723 | 722 | {"type": "Polygon", "coordinates": [[[-122.8297, 38.43042], [-122.82526, 38.43042], [-122.82525, 38.42579], [-122.8253, 38.42547], [-122.82624, 38.42547], [-122.82716, 38.42577], [-122.82941, 38.42635], [-122.82931, 38.42976], [-122.82941, 38.43012], [-122.8297, 38.43042]]]} | No Public Access 3 | 4499 | Stone Farm | 25869 | 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 | 45.409 | Stone Farm | None 67 | |||
3463 | 3463 | 3462 | {"type": "Polygon", "coordinates": [[[-122.81258, 38.40688], [-122.81095, 38.40685], [-122.81097, 38.4091], [-122.81254, 38.40914], [-122.81254, 38.4196], [-122.81121, 38.4196], [-122.81123, 38.42122], [-122.81049, 38.42124], [-122.81052, 38.42267], [-122.80968, 38.42267], [-122.80969, 38.42059], [-122.80968, 38.42058], [-122.80889, 38.42059], [-122.80889, 38.42267], [-122.80642, 38.42269], [-122.80108, 38.42268], [-122.79501, 38.42272], [-122.79499, 38.41973], [-122.80359, 38.4197], [-122.80349, 38.41056], [-122.80349, 38.4086], [-122.80676, 38.40743], [-122.80677, 38.40815], [-122.80678, 38.40816], [-122.80709, 38.40804], [-122.80708, 38.40732], [-122.80753, 38.40716], [-122.80755, 38.40779], [-122.80756, 38.4078], [-122.80855, 38.40771], [-122.81023, 38.40712], [-122.81024, 38.4062], [-122.81245, 38.40541], [-122.81259, 38.40564], [-122.81258, 38.40688]]]} | No Public Access 3 | 25346 | Kelly Farm | 20586 | 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 | 368.971 | Kelly Farm | None 288 | |||
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 | |
5297 | 5297 | 5296 | {"type": "Polygon", "coordinates": [[[-122.82593, 38.43055], [-122.82443, 38.43055], [-122.82444, 38.42965], [-122.82498, 38.42959], [-122.82517, 38.42953], [-122.82526, 38.42956], [-122.82526, 38.43042], [-122.82593, 38.43042], [-122.82593, 38.43055]]]} | No Public Access 3 | 4510 | Stone Farm | 25869 | 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 | 2.101 | Stone Farm | None 427 | |||
6589 | 6589 | 6588 | {"type": "Polygon", "coordinates": [[[-122.82826, 38.42594], [-122.82824, 38.42604], [-122.82716, 38.42577], [-122.82624, 38.42547], [-122.8253, 38.42548], [-122.82525, 38.42579], [-122.82526, 38.42923], [-122.82514, 38.42923], [-122.8249, 38.42929], [-122.82445, 38.42934], [-122.82442, 38.42666], [-122.82442, 38.42578], [-122.82445, 38.42544], [-122.82216, 38.42482], [-122.82049, 38.42439], [-122.8205, 38.42385], [-122.82826, 38.42594]]]} | No Public Access 3 | 4475 | Stone Farm | 25869 | 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 | 14.35 | Stone Farm | None 530 | |||
6593 | 6593 | 6592 | {"type": "Polygon", "coordinates": [[[-122.82446, 38.42544], [-122.82442, 38.42578], [-122.82442, 38.42666], [-122.82445, 38.42934], [-122.8235, 38.42949], [-122.82314, 38.42952], [-122.82295, 38.42956], [-122.82253, 38.42973], [-122.82216, 38.43], [-122.82202, 38.43006], [-122.82193, 38.43014], [-122.82177, 38.43018], [-122.82162, 38.43024], [-122.82125, 38.43031], [-122.82113, 38.43037], [-122.82108, 38.43037], [-122.82099, 38.43033], [-122.82089, 38.43032], [-122.82052, 38.43008], [-122.82053, 38.42921], [-122.82048, 38.4251], [-122.82049, 38.42439], [-122.82216, 38.42482], [-122.82446, 38.42544]]]} | No Public Access 3 | 4022 | Stone Farm | 25869 | 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 | 46.388 | Stone Farm | None 531 | |||
6597 | 6597 | 6596 | {"type": "MultiPolygon", "coordinates": [[[[-122.81587, 38.40123], [-122.81272, 38.40264], [-122.81266, 38.4026], [-122.81259, 38.40252], [-122.81251, 38.40232], [-122.8125, 38.40212], [-122.81253, 38.40196], [-122.81251, 38.40187], [-122.81245, 38.40185], [-122.81236, 38.40191], [-122.81224, 38.40206], [-122.81216, 38.4022], [-122.81215, 38.40227], [-122.8122, 38.40247], [-122.81207, 38.40279], [-122.81206, 38.40286], [-122.8121, 38.40292], [-122.80774, 38.40488], [-122.80551, 38.40586], [-122.80424, 38.40644], [-122.80102, 38.40784], [-122.8008, 38.40792], [-122.80001, 38.40832], [-122.79906, 38.40885], [-122.79838, 38.40919], [-122.79601, 38.41007], [-122.79446, 38.41071], [-122.79431, 38.4105], [-122.7948, 38.41031], [-122.79481, 38.4103], [-122.79469, 38.41013], [-122.79451, 38.41029], [-122.79424, 38.4104], [-122.79317, 38.40885], [-122.79019, 38.40445], [-122.79012, 38.40432], [-122.78868, 38.40221], [-122.7934, 38.40115], [-122.81277, 38.39668], [-122.81331, 38.39672], [-122.81342, 38.39753], [-122.81363, 38.39754], [-122.81382, 38.39773], [-122.81484, 38.39865], [-122.81524, 38.39907], [-122.8155, 38.39927], [-122.8156, 38.39953], [-122.81568, 38.40008], [-122.81565, 38.40089], [-122.81569, 38.40107], [-122.81573, 38.40118], [-122.81584, 38.40118], [-122.81587, 38.40123]], [[-122.79167, 38.40561], [-122.7905, 38.40387], [-122.79017, 38.40335], [-122.79015, 38.40335], [-122.79016, 38.40341], [-122.79022, 38.40352], [-122.79161, 38.40558], [-122.79166, 38.40564], [-122.79167, 38.40561]], [[-122.79449, 38.40986], [-122.7939, 38.40892], [-122.79355, 38.40842], [-122.7932, 38.40791], [-122.79289, 38.40741], [-122.79257, 38.40696], [-122.79309, 38.40795], [-122.79429, 38.41005], [-122.7943, 38.41005], [-122.79449, 38.40986]]], [[[-122.81641, 38.40121], [-122.81554, 38.4016], [-122.81554, 38.40315], [-122.81577, 38.40353], [-122.8131, 38.40439], [-122.80605, 38.40685], [-122.79987, 38.40907], [-122.79972, 38.40883], [-122.80116, 38.40807], [-122.80147, 38.40794], [-122.80163, 38.40819], [-122.80555, 38.4068], [-122.80919, 38.40545], [-122.81179, 38.40453], [-122.81179, 38.40451], [-122.81153, 38.40448], [-122.81074, 38.40427], [-122.81033, 38.40411], [-122.81012, 38.40399], [-122.81108, 38.40358], [-122.81322, 38.40262], [-122.81613, 38.40122], [-122.81641, 38.40121]]]]} | No Public Access 3 | 4034 | Brown Farm | 16443 | 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 | 468.322 | Brown Farm | None 532 | |||
6615 | 6615 | 6614 | {"type": "MultiPolygon", "coordinates": [[[[-122.77242, 38.38856], [-122.77237, 38.38856], [-122.77228, 38.38852], [-122.77236, 38.38852], [-122.77242, 38.38856]]], [[[-122.78653, 38.39443], [-122.78225, 38.39597], [-122.77744, 38.39197], [-122.77726, 38.39206], [-122.77695, 38.39211], [-122.77686, 38.39216], [-122.77651, 38.39193], [-122.77658, 38.39187], [-122.77677, 38.39178], [-122.77708, 38.3917], [-122.77709, 38.39169], [-122.77328, 38.38856], [-122.77867, 38.38851], [-122.77897, 38.38833], [-122.77912, 38.38832], [-122.77993, 38.38786], [-122.78653, 38.39443]]], [[[-122.79813, 38.3852], [-122.79796, 38.38596], [-122.7971, 38.38672], [-122.79711, 38.38673], [-122.79756, 38.38673], [-122.79756, 38.38825], [-122.79762, 38.38827], [-122.79761, 38.38881], [-122.7974, 38.38973], [-122.79746, 38.39027], [-122.79521, 38.39118], [-122.79444, 38.39148], [-122.78668, 38.39437], [-122.78491, 38.39263], [-122.78087, 38.38859], [-122.78007, 38.38777], [-122.7815, 38.38698], [-122.78783, 38.38684], [-122.78778, 38.38578], [-122.78764, 38.38578], [-122.78757, 38.38314], [-122.79463, 38.38229], [-122.79484, 38.38244], [-122.79564, 38.38276], [-122.79618, 38.38313], [-122.79632, 38.38369], [-122.79703, 38.38415], [-122.79707, 38.38419], [-122.79708, 38.38423], [-122.79813, 38.3852]]]]} | No Public Access 3 | 4205 | Alpha Farm | 15405 | 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 | 410.901 | Alpha Farm | None 534 | |||
6630 | 6630 | 6629 | {"type": "Polygon", "coordinates": [[[-122.82444, 38.42965], [-122.82442, 38.43055], [-122.8217, 38.43054], [-122.82214, 38.4304], [-122.82226, 38.43033], [-122.8223, 38.43029], [-122.8224, 38.43024], [-122.82275, 38.42998], [-122.82309, 38.42985], [-122.82395, 38.42972], [-122.82411, 38.42971], [-122.82444, 38.42965]]]} | No Public Access 3 | 4490 | Stone Farm | 25869 | 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 | 3.658 | Stone Farm | None 536 | |||
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 | |
14159 | 14159 | 14158 | {"type": "Polygon", "coordinates": [[[-122.75048, 38.43421], [-122.74811, 38.43393], [-122.74801, 38.43312], [-122.75043, 38.43316], [-122.75037, 38.43323], [-122.75048, 38.43421]]]} | Restricted Access 2 | 44115 | J.X. Wilson Park | 31385 | 2307 | Wright Elementary School District 1089 | Special District 4 | School District 14 | http://www.wrightesd.org/site/default.aspx?PageID=1 | Special District 4 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 5.235 | J.X. Wilson Park | 0 | Local Park 2 | 4 | |
62 | 62 | 61 | {"type": "Polygon", "coordinates": [[[-122.66503, 38.48047], [-122.66507, 38.48062], [-122.66507, 38.48074], [-122.66505, 38.48087], [-122.66498, 38.48107], [-122.66496, 38.48119], [-122.66497, 38.48269], [-122.66322, 38.483], [-122.66293, 38.48249], [-122.66263, 38.48191], [-122.66259, 38.48191], [-122.66235, 38.48147], [-122.66342, 38.48127], [-122.66343, 38.48126], [-122.66201, 38.47875], [-122.6625, 38.47876], [-122.66282, 38.47874], [-122.66322, 38.4787], [-122.66362, 38.47862], [-122.6647, 38.48058], [-122.66503, 38.48047]]]} | Open Access 1 | 151 | Rincon Valley Community Park | 24371 | 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 | 18.752 | Rincon Valley Community Park | 0 | Local Park 2 | 4 | |
200 | 200 | 199 | {"type": "Polygon", "coordinates": [[[-122.73156, 38.45287], [-122.73152, 38.45293], [-122.7309, 38.45305], [-122.73084, 38.45292], [-122.73075, 38.45281], [-122.73039, 38.4517], [-122.73106, 38.45137], [-122.73117, 38.4516], [-122.73156, 38.45287]]]} | Open Access 1 | 47323 | Finali Park | 31030 | 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 | https://srcity.org/Facilities/Facility/Details/Finali-Park-66 | Sonoma 16 | 2.768 | Finali Park | 2016 | Local Park 2 | 4 |
302 | 302 | 301 | {"type": "Polygon", "coordinates": [[[-122.73498, 38.41334], [-122.73206, 38.41414], [-122.732, 38.41029], [-122.73412, 38.41036], [-122.73414, 38.41144], [-122.73498, 38.41334]]]} | Open Access 1 | 1039 | Southwest Community Park | 25702 | 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 | 19.939 | Southwest Community Park | 2000 | Local Park 2 | 4 | |
446 | 446 | 445 | {"type": "Polygon", "coordinates": [[[-122.66242, 38.47114], [-122.66213, 38.47116], [-122.66213, 38.47141], [-122.66207, 38.47141], [-122.66205, 38.47119], [-122.662, 38.47116], [-122.66181, 38.47119], [-122.66165, 38.47124], [-122.66159, 38.47128], [-122.66148, 38.47136], [-122.66139, 38.47148], [-122.66134, 38.47158], [-122.66137, 38.47161], [-122.66165, 38.47167], [-122.66163, 38.47172], [-122.66122, 38.47168], [-122.66121, 38.47167], [-122.66054, 38.47168], [-122.66082, 38.47198], [-122.66076, 38.47205], [-122.6604, 38.47199], [-122.6607, 38.47278], [-122.66079, 38.47294], [-122.66069, 38.47298], [-122.66028, 38.47227], [-122.66019, 38.47203], [-122.66005, 38.47195], [-122.65984, 38.4719], [-122.65972, 38.47189], [-122.65961, 38.47193], [-122.65961, 38.47195], [-122.65973, 38.47217], [-122.65968, 38.47221], [-122.65941, 38.47206], [-122.6593, 38.47218], [-122.6593, 38.47224], [-122.65895, 38.47224], [-122.65893, 38.47227], [-122.65897, 38.47249], [-122.6589, 38.47252], [-122.65871, 38.47234], [-122.65847, 38.47254], [-122.65823, 38.47252], [-122.65819, 38.47273], [-122.65811, 38.47274], [-122.65799, 38.47254], [-122.65781, 38.4726], [-122.65772, 38.47271], [-122.65769, 38.47289], [-122.65823, 38.47383], [-122.65798, 38.47392], [-122.65784, 38.47368], [-122.65768, 38.47373], [-122.65754, 38.47273], [-122.65752, 38.47273], [-122.65748, 38.47249], [-122.65713, 38.47243], [-122.65711, 38.4723], [-122.65747, 38.47227], [-122.65765, 38.47233], [-122.65769, 38.47231], [-122.65833, 38.47224], [-122.65853, 38.47206], [-122.65851, 38.4719], [-122.65872, 38.47188], [-122.6587, 38.47167], [-122.65881, 38.47168], [-122.6589, 38.47164], [-122.65894, 38.47156], [-122.65892, 38.47146], [-122.66106, 38.47127], [-122.66098, 38.47103], [-122.66125, 38.4708], [-122.66134, 38.47078], [-122.66153, 38.47076], [-122.66159, 38.4708], [-122.66159, 38.47083], [-122.66166, 38.47084], [-122.66172, 38.47081], [-122.66174, 38.47076], [-122.66234, 38.47095], [-122.66242, 38.47114]]]} | Open Access 1 | 1405 | Tanglewood Park | 26180 | 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 | 7.775 | Tanglewood Park | 0 | Local Park 2 | 4 | |
1302 | 1302 | 1301 | {"type": "Polygon", "coordinates": [[[-122.7616, 38.42519], [-122.7609, 38.42525], [-122.76082, 38.42464], [-122.76085, 38.4246], [-122.76086, 38.42454], [-122.76083, 38.42446], [-122.7608, 38.42413], [-122.76146, 38.42409], [-122.7616, 38.42519]]]} | Open Access 1 | 10458 | Village Green Park | 27116 | 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 | 1.837 | Village Green Park | 0 | Local Park 2 | 4 | |
1325 | 1325 | 1324 | {"type": "Polygon", "coordinates": [[[-122.70256, 38.47544], [-122.70255, 38.47547], [-122.70224, 38.47541], [-122.70162, 38.47624], [-122.70157, 38.47671], [-122.7013, 38.47657], [-122.70121, 38.4765], [-122.70093, 38.47617], [-122.70076, 38.47599], [-122.70056, 38.47583], [-122.69975, 38.47539], [-122.6998, 38.47531], [-122.69915, 38.47498], [-122.69895, 38.47484], [-122.69885, 38.47467], [-122.70244, 38.47464], [-122.7023, 38.47517], [-122.70221, 38.47536], [-122.70256, 38.47544]]]} | Open Access 1 | 10821 | Hidden Valley Park | 19920 | 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 | 8.794 | Hidden Valley Park | 0 | Local Park 2 | 4 | |
1327 | 1327 | 1326 | {"type": "Polygon", "coordinates": [[[-122.69381, 38.48999], [-122.69379, 38.49004], [-122.69375, 38.49006], [-122.69344, 38.49011], [-122.69317, 38.49012], [-122.69239, 38.49008], [-122.69236, 38.49005], [-122.69238, 38.4897], [-122.69237, 38.48951], [-122.69231, 38.48938], [-122.69218, 38.48923], [-122.69204, 38.48914], [-122.69189, 38.48908], [-122.69146, 38.489], [-122.69126, 38.48894], [-122.69096, 38.48877], [-122.69078, 38.48865], [-122.69125, 38.48827], [-122.69152, 38.48843], [-122.69216, 38.48858], [-122.69245, 38.48857], [-122.69273, 38.48852], [-122.69314, 38.48835], [-122.69317, 38.48825], [-122.69296, 38.48806], [-122.69306, 38.48799], [-122.69316, 38.48795], [-122.69332, 38.48792], [-122.69337, 38.48793], [-122.6934, 38.48797], [-122.69343, 38.48816], [-122.6935, 38.48892], [-122.69361, 38.48938], [-122.69369, 38.48967], [-122.69381, 38.48999]]]} | Open Access 1 | 10830 | Rincon Ridge Park | 24370 | 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 | 7.263 | Rincon Ridge Park | 0 | Local Park 2 | 4 | |
1487 | 1487 | 1486 | {"type": "Polygon", "coordinates": [[[-122.76629, 38.45731], [-122.76628, 38.45882], [-122.76465, 38.45882], [-122.76464, 38.45793], [-122.76534, 38.45792], [-122.76553, 38.45789], [-122.76572, 38.4578], [-122.76589, 38.45769], [-122.76613, 38.45742], [-122.76629, 38.45731]]]} | Open Access 1 | 10402 | Peterson Lane Park | 23632 | 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 | 4.051 | Peterson Lane Park | 0 | Local Park 2 | 4 | |
1491 | 1491 | 1490 | {"type": "Polygon", "coordinates": [[[-122.7096, 38.43788], [-122.70954, 38.43791], [-122.70929, 38.4381], [-122.70925, 38.43795], [-122.70895, 38.43799], [-122.70876, 38.43769], [-122.70873, 38.43762], [-122.70874, 38.4376], [-122.7088, 38.43759], [-122.70951, 38.4375], [-122.7096, 38.43788]]]} | Open Access 1 | 10579 | Rae Park | 24071 | 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.782 | Rae Park | 0 | 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]);