units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
83 rows where MNG_AGENCY = 29
This data as json, copyable, CSV (advanced)
DES_TP 11
ACCESS_TYP 3
AGNCY_NAME 2 ✖
MNG_AG_TYP 1
- City Agency 43
MNG_AGENCY 1
- Santa Rosa, City of · 43 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4937 | 4937 | 4936 | {"type": "Polygon", "coordinates": [[[-122.70759, 38.41914], [-122.70759, 38.41914], [-122.70755, 38.42031], [-122.70739, 38.42027], [-122.70713, 38.42014], [-122.70689, 38.41994], [-122.70666, 38.41953], [-122.70667, 38.41945], [-122.7068, 38.41934], [-122.70705, 38.41921], [-122.70739, 38.41913], [-122.70759, 38.41914]]]} | Open Access 1 | 10522 | Colgan Creek Park | 17495 | 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.808 | Colgan Creek Park | 0 | Local Park 2 | 4 | |
5234 | 5234 | 5233 | {"type": "Polygon", "coordinates": [[[-122.75784, 38.4152], [-122.75778, 38.41523], [-122.75712, 38.41527], [-122.75706, 38.41524], [-122.75708, 38.41511], [-122.75706, 38.41495], [-122.757, 38.41477], [-122.75689, 38.41379], [-122.75695, 38.41376], [-122.75707, 38.41376], [-122.75772, 38.41379], [-122.75771, 38.41399], [-122.75778, 38.41411], [-122.75783, 38.41454], [-122.7578, 38.41467], [-122.75782, 38.4148], [-122.75781, 38.41494], [-122.75784, 38.4152]]]} | Open Access 1 | 48076 | Airfield Park | 32578 | 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/airfieldpark-48 | Sonoma 16 | 2.865 | Airfield Park | 0 | Local Park 2 | 4 |
5235 | 5235 | 5234 | {"type": "Polygon", "coordinates": [[[-122.70989, 38.41101], [-122.70989, 38.41114], [-122.70987, 38.41123], [-122.70984, 38.41123], [-122.70975, 38.41126], [-122.70879, 38.41127], [-122.70869, 38.41121], [-122.7087, 38.41106], [-122.70867, 38.41101], [-122.70861, 38.41098], [-122.70854, 38.41096], [-122.70844, 38.41098], [-122.70797, 38.41098], [-122.70789, 38.41091], [-122.70789, 38.41085], [-122.70785, 38.41077], [-122.70765, 38.41056], [-122.70764, 38.41052], [-122.70767, 38.41046], [-122.70773, 38.41044], [-122.70774, 38.41046], [-122.70896, 38.41046], [-122.70917, 38.41045], [-122.70938, 38.41041], [-122.70948, 38.41044], [-122.70962, 38.41064], [-122.70979, 38.4108], [-122.70986, 38.41091], [-122.70989, 38.41101]]]} | Open Access 1 | 48077 | Harvest Park | 32579 | 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/Harvest-Park-72 | Sonoma 16 | 3.195 | Harvest Park | 0 | Local Park 2 | 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 | |||
5634 | 5634 | 5633 | {"type": "Polygon", "coordinates": [[[-122.70518, 38.4452], [-122.70488, 38.44513], [-122.70485, 38.44509], [-122.70485, 38.44504], [-122.70498, 38.44494], [-122.70518, 38.4452]]]} | Open Access 1 | 29789 | College Triangle Park | 17513 | 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.094 | College Triangle Park | 0 | Local Park 2 | 4 | |
5635 | 5635 | 5634 | {"type": "Polygon", "coordinates": [[[-122.66692, 38.43193], [-122.66671, 38.43182], [-122.66654, 38.43177], [-122.66633, 38.43194], [-122.66629, 38.43208], [-122.66588, 38.43202], [-122.66588, 38.432], [-122.66552, 38.43187], [-122.66457, 38.43138], [-122.66443, 38.43128], [-122.66431, 38.43116], [-122.66448, 38.43109], [-122.66447, 38.43084], [-122.66505, 38.43084], [-122.66505, 38.43086], [-122.66692, 38.43176], [-122.66692, 38.43193]]]} | Open Access 1 | 29790 | Creekside Park | 17780 | 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.518 | Creekside Park | 0 | Local Park 2 | 4 | |
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 | |||
6728 | 6728 | 6727 | {"type": "Polygon", "coordinates": [[[-122.77657, 38.45983], [-122.77652, 38.46382], [-122.77654, 38.46708], [-122.77365, 38.46704], [-122.77363, 38.46452], [-122.77485, 38.46451], [-122.77481, 38.46288], [-122.76981, 38.46288], [-122.76979, 38.45982], [-122.77373, 38.45983], [-122.77317, 38.46023], [-122.77324, 38.46035], [-122.77396, 38.45983], [-122.77657, 38.45983]]]} | Open Access 1 | 5050 | Youth Community Park | 27795 | 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 | 73.321 | Youth Community Park | 0 | Local Park 2 | 4 | |
6783 | 6783 | 6782 | {"type": "Polygon", "coordinates": [[[-122.6718, 38.45488], [-122.6715, 38.45491], [-122.67052, 38.45514], [-122.66999, 38.45567], [-122.66937, 38.45577], [-122.664, 38.4564], [-122.66195, 38.4572], [-122.66201, 38.45754], [-122.66181, 38.45757], [-122.66059, 38.45805], [-122.66056, 38.45805], [-122.65974, 38.45828], [-122.65973, 38.45625], [-122.66091, 38.45519], [-122.66091, 38.45518], [-122.66088, 38.45517], [-122.66194, 38.45409], [-122.66192, 38.45408], [-122.66197, 38.45406], [-122.66737, 38.45035], [-122.66768, 38.44951], [-122.66805, 38.44909], [-122.6682, 38.44925], [-122.66856, 38.44969], [-122.66934, 38.45101], [-122.6718, 38.45488]]]} | Open Access 1 | 5275 | Howarth Park | 20122 | 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 | 111.543 | Howarth Park | 1970 | Local Park 2 | 4 | |
6786 | 6786 | 6785 | {"type": "Polygon", "coordinates": [[[-122.66368, 38.41889], [-122.66292, 38.41936], [-122.66115, 38.4199], [-122.65968, 38.41989], [-122.65968, 38.41787], [-122.65839, 38.41785], [-122.65799, 38.41691], [-122.6615, 38.41693], [-122.66368, 38.41889]]]} | Open Access 1 | 5283 | Galvin Park | 19183 | 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 | 24.137 | Galvin Park | 0 | Local Park 2 | 4 | |
6787 | 6787 | 6786 | {"type": "Polygon", "coordinates": [[[-122.71291, 38.46188], [-122.71241, 38.46199], [-122.71217, 38.46155], [-122.7115, 38.46172], [-122.70972, 38.46007], [-122.70965, 38.45995], [-122.71273, 38.45904], [-122.71291, 38.46188]]]} | Open Access 1 | 5286 | Franklin Park | 19066 | 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 | 13.313 | Franklin Park | 0 | Local Park 2 | 4 | |
6788 | 6788 | 6787 | {"type": "MultiPolygon", "coordinates": [[[[-122.63946, 38.46568], [-122.63954, 38.46598], [-122.63951, 38.46603], [-122.63858, 38.46611], [-122.63834, 38.46616], [-122.63805, 38.46624], [-122.6376, 38.46642], [-122.63681, 38.46685], [-122.63661, 38.46692], [-122.63643, 38.46696], [-122.63643, 38.46686], [-122.63665, 38.46672], [-122.63668, 38.46645], [-122.63634, 38.46638], [-122.6362, 38.46615], [-122.63593, 38.46593], [-122.63559, 38.46578], [-122.63463, 38.46566], [-122.63425, 38.46523], [-122.63429, 38.46511], [-122.63442, 38.46493], [-122.6345, 38.46476], [-122.63493, 38.46478], [-122.63594, 38.46493], [-122.63706, 38.465], [-122.63703, 38.46523], [-122.63786, 38.46587], [-122.63806, 38.46577], [-122.63854, 38.46578], [-122.63878, 38.4657], [-122.63925, 38.46571], [-122.63946, 38.46568]]], [[[-122.64276, 38.46243], [-122.64271, 38.46272], [-122.64274, 38.46295], [-122.6428, 38.46311], [-122.64314, 38.46368], [-122.64318, 38.46382], [-122.64319, 38.46396], [-122.64315, 38.46412], [-122.64293, 38.4645], [-122.64276, 38.46484], [-122.64272, 38.46497], [-122.64266, 38.46521], [-122.6426, 38.46533], [-122.64254, 38.46542], [-122.64243, 38.46553], [-122.64231, 38.46561], [-122.64217, 38.46568], [-122.64201, 38.46573], [-122.64172, 38.46575], [-122.64129, 38.4657], [-122.64097, 38.46571], [-122.64075, 38.46574], [-122.63988, 38.46596], [-122.63981, 38.46598], [-122.63975, 38.46596], [-122.63965, 38.46563], [-122.63995, 38.46556], [-122.64013, 38.46537], [-122.64026, 38.46537], [-122.64042, 38.46524], [-122.64067, 38.46524], [-122.64089, 38.46516], [-122.64121, 38.46519], [-122.64139, 38.46506], [-122.64174, 38.46493], [-122.64199, 38.46474], [-122.64222, 38.46476], [-122.64235, 38.46468], [-122.64246, 38.46458], [-122.64245, 38.46452], [-122.64251, 38.46452], [-122.64257, 38.46239], [-122.64276, 38.46243]]], [[[-122.64526, 38.46328], [-122.64495, 38.46371], [-122.6449, 38.46375], [-122.64459, 38.4638], [-122.64455, 38.46376], [-122.64435, 38.46376], [-122.64434, 38.46378], [-122.64374, 38.46374], [-122.64361, 38.46405], [-122.64352, 38.46402], [-122.64352, 38.46382], [-122.64349, 38.46368], [-122.64344, 38.46355], [-122.64335, 38.4634], [-122.64376, 38.46324], [-122.64409, 38.46328], [-122.64436, 38.46334], [-122.64439, 38.463], [-122.64526, 38.46328]]]]} | Open Access 1 | 5290 | Skyhawk Parks | 25535 | 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.996 | Skyhawk Parks | None 552 | |||
6792 | 6792 | 6791 | {"type": "Polygon", "coordinates": [[[-122.68098, 38.48165], [-122.68094, 38.48213], [-122.67952, 38.48214], [-122.67946, 38.48203], [-122.67932, 38.48196], [-122.67915, 38.48201], [-122.67893, 38.48202], [-122.67864, 38.48182], [-122.67844, 38.48158], [-122.678, 38.48132], [-122.67824, 38.48071], [-122.67829, 38.48031], [-122.67817, 38.47986], [-122.67832, 38.47949], [-122.67847, 38.4793], [-122.67921, 38.48004], [-122.6801, 38.48011], [-122.67997, 38.48159], [-122.68098, 38.48165]]]} | Open Access 1 | 5297 | Upper Brush Creek Park | 26726 | 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 | 10.432 | Upper Brush Creek Park | 0 | Local Park 2 | 4 | |
7222 | 7222 | 7221 | {"type": "Polygon", "coordinates": [[[-122.71034, 38.49485], [-122.71017, 38.49538], [-122.70934, 38.49527], [-122.70927, 38.49498], [-122.70966, 38.49491], [-122.71034, 38.49485]]]} | Open Access 1 | 10713 | Fir Ridge Park | 18907 | 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.975 | Fir Ridge Park | 0 | Local Park 2 | 4 | |
7922 | 7922 | 7921 | {"type": "Polygon", "coordinates": [[[-122.74875, 38.47854], [-122.74847, 38.4785], [-122.74774, 38.47848], [-122.74764, 38.47838], [-122.74756, 38.47836], [-122.74744, 38.47839], [-122.74717, 38.47833], [-122.74716, 38.47697], [-122.74722, 38.47692], [-122.7478, 38.47691], [-122.74855, 38.47695], [-122.74864, 38.47728], [-122.74879, 38.47755], [-122.74887, 38.47785], [-122.74887, 38.47811], [-122.74883, 38.47835], [-122.74875, 38.47854]]]} | Open Access 1 | 10695 | Coffey Park | 17476 | 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 | 5.869 | Coffey Park | 0 | Local Park 2 | 4 | |
7925 | 7925 | 7924 | {"type": "Polygon", "coordinates": [[[-122.74343, 38.44794], [-122.74343, 38.44831], [-122.74298, 38.44832], [-122.743, 38.44868], [-122.74102, 38.44879], [-122.74092, 38.44747], [-122.74293, 38.44734], [-122.74299, 38.44795], [-122.74343, 38.44794]]]} | Open Access 1 | 10652 | Jennings Park | 20390 | 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 | 6.805 | Jennings 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]);