superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
72 rows where ACCESS_TYP = 1 and MNG_AGENCY = 29 sorted by rowid descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, YR_EST
MNG_AG_TYP 1
- City Agency 72
ACCESS_TYP 1
- Open Access · 72 ✖
Link | rowid ▲ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14009 | 14009 | 14008 | {"type": "Polygon", "coordinates": [[[-122.70989, 38.41101], [-122.70989, 38.41114], [-122.70987, 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.70775, 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 | Harvest Park | https://srcity.org/facilities/facility/details/Harvest-Park-72 | 32579 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 3.197 | Harvest Park | |
14007 | 14007 | 14006 | {"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.41496], [-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 | Airfield Park | https://srcity.org/facilities/facility/details/airfieldpark-48 | 32578 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 2.865 | Airfield Park | |
13892 | 13892 | 13891 | {"type": "Polygon", "coordinates": [[[-122.72799, 38.42185], [-122.72623, 38.4222], [-122.72621, 38.42201], [-122.72615, 38.42201], [-122.72601, 38.42086], [-122.7278, 38.42042], [-122.72799, 38.42185]]]} | Open Access 1 | Bayer Neighborhood Park and Gardens | 32509 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 6.16 | Bayer Neighborhood Park and Gardens | 2017 | |
13579 | 13579 | 13578 | {"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 | Finali Park | https://srcity.org/Facilities/Facility/Details/Finali-Park-66 | 31030 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 2.767 | Finali Park | 2016 |
11447 | 11447 | 11446 | {"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.46289], [-122.76981, 38.46288], [-122.76979, 38.45982], [-122.77373, 38.45983], [-122.77318, 38.46023], [-122.77324, 38.46034], [-122.77396, 38.45983], [-122.77657, 38.45983]]]} | Open Access 1 | Youth Community Park | 27795 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 73.37 | Youth Community Park | ||
10895 | 10895 | 10894 | {"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 | Village Green Park | 27116 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1.837 | Village Green Park | ||
10577 | 10577 | 10576 | {"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.48072], [-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.67998, 38.48159], [-122.68098, 38.48165]]]} | Open Access 1 | Upper Brush Creek Park | 26726 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 10.444 | Upper Brush Creek Park | ||
10440 | 10440 | 10439 | {"type": "Polygon", "coordinates": [[[-122.66792, 38.46122], [-122.66782, 38.46129], [-122.66773, 38.46132], [-122.66731, 38.46157], [-122.66726, 38.46163], [-122.66714, 38.4613], [-122.66776, 38.46098], [-122.66792, 38.46122]]]} | Open Access 1 | Trailhead Park | 26509 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 0.533 | Trailhead Park | ||
10222 | 10222 | 10221 | {"type": "Polygon", "coordinates": [[[-122.66242, 38.47114], [-122.66213, 38.47116], [-122.66213, 38.47141], [-122.66207, 38.47141], [-122.66205, 38.47119], [-122.66201, 38.47116], [-122.66181, 38.47119], [-122.66165, 38.47124], [-122.66158, 38.47128], [-122.66148, 38.47136], [-122.66139, 38.47148], [-122.66134, 38.47158], [-122.66138, 38.47161], [-122.66165, 38.47167], [-122.66163, 38.47172], [-122.66121, 38.47167], [-122.66055, 38.47169], [-122.66082, 38.47198], [-122.66076, 38.47205], [-122.66041, 38.472], [-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.47196], [-122.65973, 38.47217], [-122.65968, 38.47221], [-122.65941, 38.47206], [-122.6593, 38.47218], [-122.6593, 38.47224], [-122.65895, 38.47225], [-122.65893, 38.47227], [-122.65897, 38.47249], [-122.65891, 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.6577, 38.47289], [-122.65823, 38.47383], [-122.65798, 38.47392], [-122.65784, 38.47368], [-122.65768, 38.47373], [-122.65754, 38.47274], [-122.65752, 38.47272], [-122.65748, 38.47249], [-122.65713, 38.47243], [-122.65711, 38.4723], [-122.65747, 38.47227], [-122.65765, 38.47233], [-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.66105, 38.47127], [-122.66098, 38.47103], [-122.66125, 38.4708], [-122.66134, 38.47078], [-122.66153, 38.47076], [-122.66159, 38.4708], [-122.6616, 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 | Tanglewood Park | 26180 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 7.794 | Tanglewood Park | ||
10021 | 10021 | 10020 | {"type": "Polygon", "coordinates": [[[-122.66325, 38.43481], [-122.66313, 38.43483], [-122.66294, 38.43482], [-122.66279, 38.43441], [-122.66268, 38.43428], [-122.66239, 38.43408], [-122.66209, 38.43431], [-122.66145, 38.43386], [-122.66126, 38.43385], [-122.66119, 38.4338], [-122.66084, 38.43381], [-122.66107, 38.4331], [-122.66125, 38.43277], [-122.66103, 38.43254], [-122.66094, 38.43234], [-122.66074, 38.43231], [-122.66046, 38.43221], [-122.66054, 38.43203], [-122.66093, 38.43212], [-122.66114, 38.4322], [-122.66121, 38.43233], [-122.66144, 38.43253], [-122.66168, 38.4325], [-122.66175, 38.43255], [-122.66164, 38.43256], [-122.66163, 38.43258], [-122.66183, 38.43275], [-122.66187, 38.43282], [-122.66187, 38.43315], [-122.66195, 38.43331], [-122.66209, 38.43341], [-122.6624, 38.43352], [-122.66254, 38.43363], [-122.66264, 38.43378], [-122.66295, 38.43402], [-122.66313, 38.43412], [-122.66315, 38.43419], [-122.6632, 38.43424], [-122.66317, 38.43453], [-122.66325, 38.43481]]]} | Open Access 1 | Strawberry Park | 25916 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 5.37 | Strawberry Park | ||
9946 | 9946 | 9945 | {"type": "Polygon", "coordinates": [[[-122.72177, 38.46293], [-122.72145, 38.46299], [-122.7202, 38.46372], [-122.72001, 38.46259], [-122.72027, 38.46258], [-122.72039, 38.46262], [-122.72047, 38.46267], [-122.72052, 38.46279], [-122.72174, 38.46266], [-122.72177, 38.46293]]]} | Open Access 1 | Steele Lane Park | 25820 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 2.384 | Steele Lane Park | ||
9837 | 9837 | 9836 | {"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 | Southwest Community Park | 25702 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 19.939 | Southwest Community Park | 2000 | |
9797 | 9797 | 9796 | {"type": "Polygon", "coordinates": [[[-122.71576, 38.42959], [-122.71543, 38.42962], [-122.71528, 38.42723], [-122.71532, 38.42722], [-122.71576, 38.42959]]]} | Open Access 1 | South Davis Park | 25647 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1.081 | South Davis Park | ||
9765 | 9765 | 9764 | {"type": "Polygon", "coordinates": [[[-122.71147, 38.43682], [-122.71061, 38.43738], [-122.7094, 38.43825], [-122.7091, 38.43839], [-122.70903, 38.43829], [-122.70954, 38.43791], [-122.70968, 38.43784], [-122.70976, 38.43784], [-122.70988, 38.43779], [-122.71003, 38.43765], [-122.70999, 38.43739], [-122.71051, 38.43731], [-122.71145, 38.43674], [-122.71147, 38.43682]]]} | Open Access 1 | Sonoma Avenue Park | 25606 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1.01 | Sonoma Avenue Park | ||
9716 | 9716 | 9715 | {"type": "MultiPolygon", "coordinates": [[[[-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.63667, 38.46645], [-122.63634, 38.46638], [-122.6362, 38.46615], [-122.63593, 38.46594], [-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.63954, 38.46598]]], [[[-122.64276, 38.46243], [-122.64271, 38.46272], [-122.64274, 38.46295], [-122.6428, 38.46311], [-122.64314, 38.46368], [-122.64318, 38.46381], [-122.64319, 38.46396], [-122.64315, 38.46412], [-122.64293, 38.46449], [-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.46475], [-122.64235, 38.46468], [-122.64246, 38.46458], [-122.64245, 38.46452], [-122.64251, 38.46451], [-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.64454, 38.46376], [-122.64436, 38.46376], [-122.64434, 38.46378], [-122.64375, 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.64435, 38.46334], [-122.64439, 38.463], [-122.64526, 38.46328]]]]} | Open Access 1 | Skyhawk Parks | 25535 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 20.009 | Skyhawk Parks | ||
8714 | 8714 | 8713 | {"type": "Polygon", "coordinates": [[[-122.67494, 38.46701], [-122.67483, 38.46705], [-122.67479, 38.46712], [-122.6748, 38.4672], [-122.67489, 38.46727], [-122.67491, 38.46731], [-122.6741, 38.46748], [-122.67319, 38.4677], [-122.67352, 38.46749], [-122.67365, 38.46738], [-122.67374, 38.46724], [-122.67378, 38.46711], [-122.67402, 38.46693], [-122.67454, 38.46643], [-122.67469, 38.46656], [-122.67479, 38.46669], [-122.6749, 38.46689], [-122.67494, 38.46701]]]} | Open Access 1 | Rinconada Park | 24373 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 2.022 | Rinconada Park | ||
8712 | 8712 | 8711 | {"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.48192], [-122.66259, 38.48191], [-122.66235, 38.48147], [-122.66342, 38.48127], [-122.66343, 38.48125], [-122.66201, 38.47875], [-122.6625, 38.47876], [-122.66282, 38.47874], [-122.66322, 38.4787], [-122.66362, 38.47862], [-122.6647, 38.48057], [-122.66503, 38.48047]]]} | Open Access 1 | Rincon Valley Community Park | 24371 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 18.755 | Rincon Valley Community Park | ||
8711 | 8711 | 8710 | {"type": "Polygon", "coordinates": [[[-122.69381, 38.48999], [-122.69379, 38.49004], [-122.69375, 38.49006], [-122.69343, 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.48939], [-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.48824], [-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 | Rincon Ridge Park | 24370 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 7.265 | Rincon Ridge Park | ||
8576 | 8576 | 8575 | {"type": "Polygon", "coordinates": [[[-122.71082, 38.40228], [-122.71082, 38.40279], [-122.7105, 38.40279], [-122.7105, 38.40224], [-122.71077, 38.40224], [-122.71082, 38.40228]]]} | Open Access 1 | Red Hawk Park | 24222 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 0.419 | Red Hawk Park | ||
8461 | 8461 | 8460 | {"type": "Polygon", "coordinates": [[[-122.7096, 38.43788], [-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 | Rae Park | 24071 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 0.788 | Rae Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);