superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
79 rows where MNG_AGENCY = 29 sorted by ACRES
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2223 | 2223 | 2222 | {"type": "Polygon", "coordinates": [[[-122.7493, 38.45103], [-122.74879, 38.45105], [-122.74793, 38.45105], [-122.74799, 38.45086], [-122.74798, 38.45076], [-122.74856, 38.45077], [-122.74855, 38.45051], [-122.74885, 38.45051], [-122.74889, 38.45078], [-122.74929, 38.45078], [-122.7493, 38.45103]]]} | Open Access 1 | Brendon Park | 16349 | 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.075 | Brendon Park | ||
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 | ||
2843 | 2843 | 2842 | {"type": "Polygon", "coordinates": [[[-122.72736, 38.43806], [-122.72694, 38.43821], [-122.72682, 38.43805], [-122.7265, 38.43817], [-122.72622, 38.43778], [-122.72694, 38.43746], [-122.72736, 38.43806]]]} | Open Access 1 | DeMeo Park | 18080 | 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.141 | DeMeo Park | ||
4412 | 4412 | 4411 | {"type": "Polygon", "coordinates": [[[-122.70955, 38.4434], [-122.70874, 38.44377], [-122.70831, 38.44322], [-122.70831, 38.44319], [-122.70912, 38.4428], [-122.70955, 38.4434]]]} | Open Access 1 | Fremont Park | 19102 | 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.548 | Fremont Park | 2000 | |
8112 | 8112 | 8111 | {"type": "Polygon", "coordinates": [[[-122.66983, 38.44622], [-122.66942, 38.44646], [-122.66856, 38.44559], [-122.66887, 38.44549], [-122.66888, 38.44548], [-122.66836, 38.44493], [-122.66851, 38.44486], [-122.66983, 38.44622]]]} | Open Access 1 | Peter Springs Park | 23629 | 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.6 | Peter Springs Park | ||
3083 | 3083 | 3082 | {"type": "Polygon", "coordinates": [[[-122.727, 38.40276], [-122.72699, 38.40298], [-122.72678, 38.40342], [-122.72676, 38.40361], [-122.7267, 38.40366], [-122.72629, 38.40366], [-122.72613, 38.40368], [-122.72613, 38.40277], [-122.727, 38.40276]]]} | Open Access 1 | Colgan Creek Park and Preserve | 17496 | 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.602 | Colgan Creek Park and Preserve | ||
1245 | 1245 | 1244 | {"type": "Polygon", "coordinates": [[[-122.71434, 38.4402], [-122.71349, 38.44058], [-122.71304, 38.43997], [-122.71388, 38.43959], [-122.71434, 38.4402]]]} | Open Access 1 | Old Courthouse Square | 32918 | 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.67 | Old Courthouse Square | ||
3082 | 3082 | 3081 | {"type": "Polygon", "coordinates": [[[-122.70759, 38.41914], [-122.70755, 38.42031], [-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 | Colgan Creek Park | 17495 | 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.807 | Colgan Creek 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 | ||
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 | ||
2358 | 2358 | 2357 | {"type": "Polygon", "coordinates": [[[-122.71212, 38.43656], [-122.7117, 38.43671], [-122.71147, 38.43682], [-122.71142, 38.43649], [-122.71151, 38.43656], [-122.71162, 38.43657], [-122.71167, 38.43655], [-122.71171, 38.43652], [-122.71172, 38.43645], [-122.71168, 38.43638], [-122.71161, 38.43636], [-122.71132, 38.43638], [-122.71122, 38.43594], [-122.71127, 38.43591], [-122.7112, 38.43553], [-122.71192, 38.43544], [-122.7121, 38.43627], [-122.71212, 38.43656]]]} | Open Access 1 | Burbank Home & Gardens | 16508 | 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.036 | Burbank Home & Gardens | ||
2287 | 2287 | 2286 | {"type": "Polygon", "coordinates": [[[-122.68198, 38.46239], [-122.68133, 38.4633], [-122.68079, 38.46269], [-122.68076, 38.46258], [-122.68051, 38.46228], [-122.68082, 38.46212], [-122.68198, 38.46239]]]} | Open Access 1 | Brush Creek Park | 16453 | 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.058 | Brush Creek Park | ||
1046 | 1046 | 1045 | {"type": "Polygon", "coordinates": [[[-122.69406, 38.42745], [-122.69385, 38.42747], [-122.69367, 38.42746], [-122.69323, 38.42733], [-122.69295, 38.42728], [-122.69276, 38.42728], [-122.69252, 38.42729], [-122.6925, 38.42728], [-122.69245, 38.42715], [-122.69226, 38.4268], [-122.6925, 38.4267], [-122.69262, 38.42662], [-122.69273, 38.42651], [-122.6928, 38.42637], [-122.69306, 38.42644], [-122.69312, 38.42649], [-122.69314, 38.42658], [-122.69322, 38.42669], [-122.69329, 38.42675], [-122.69343, 38.42681], [-122.69351, 38.42687], [-122.69368, 38.42704], [-122.69378, 38.42716], [-122.69384, 38.42728], [-122.694, 38.42736], [-122.69406, 38.42745]]]} | Open Access 1 | Dauenhauer Park | https://srcity.org/Facilities/Facility/Details/Dauenhauer-Park-59 | 32822 | 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.291 | Dauenhauer 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 | ||
3745 | 3745 | 3744 | {"type": "Polygon", "coordinates": [[[-122.75772, 38.44893], [-122.7573, 38.44893], [-122.75729, 38.44902], [-122.75694, 38.44937], [-122.75684, 38.44945], [-122.75679, 38.44945], [-122.75677, 38.44898], [-122.75653, 38.44897], [-122.75653, 38.44894], [-122.75665, 38.44883], [-122.75672, 38.44873], [-122.75676, 38.44856], [-122.75672, 38.44824], [-122.75672, 38.44809], [-122.75668, 38.44793], [-122.75733, 38.44794], [-122.75737, 38.44818], [-122.75768, 38.44868], [-122.75771, 38.44882], [-122.75772, 38.44893]]]} | Open Access 1 | Dutch Flohr Park | 18318 | 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.392 | Dutch Flohr Park | ||
1247 | 1247 | 1246 | {"type": "Polygon", "coordinates": [[[-122.74197, 38.43694], [-122.74187, 38.43693], [-122.74179, 38.43719], [-122.74176, 38.43718], [-122.74182, 38.43691], [-122.74053, 38.43668], [-122.74052, 38.43665], [-122.74049, 38.43665], [-122.74046, 38.43647], [-122.74041, 38.43638], [-122.74036, 38.43634], [-122.74029, 38.43618], [-122.74134, 38.43611], [-122.74131, 38.43586], [-122.74135, 38.43587], [-122.7414, 38.43611], [-122.74185, 38.43607], [-122.74197, 38.43694]]]} | Open Access 1 | Westgate Park | 32920 | 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.461 | Westgate Park | ||
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 |
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 | |
8045 | 8045 | 8044 | {"type": "Polygon", "coordinates": [[[-122.74779, 38.41384], [-122.74776, 38.41392], [-122.74768, 38.41398], [-122.74755, 38.41404], [-122.74741, 38.41408], [-122.74658, 38.41414], [-122.74636, 38.41413], [-122.74616, 38.41406], [-122.74611, 38.41399], [-122.74614, 38.41383], [-122.7461, 38.41346], [-122.74617, 38.41339], [-122.74759, 38.41329], [-122.74767, 38.41334], [-122.74771, 38.41366], [-122.74779, 38.41384]]]} | Open Access 1 | Pear Blossom Park | 23546 | 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.869 | Pear Blossom Park | ||
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 |
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]);