superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
79 rows where MNG_AGENCY = 29 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9985 | 9985 | 9984 | {"type": "Polygon", "coordinates": [[[-122.8297, 38.43042], [-122.82594, 38.43042], [-122.82593, 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.82498, 38.42959], [-122.82517, 38.42953], [-122.82525, 38.42956], [-122.82525, 38.42923], [-122.82513, 38.42923], [-122.8249, 38.42929], [-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.8205, 38.42385], [-122.82826, 38.42594], [-122.82825, 38.42605], [-122.82941, 38.42635], [-122.82931, 38.42976], [-122.82941, 38.43012], [-122.8297, 38.43042]]]} | No Public Access 3 | Stone Farm | 25869 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 111.836 | Stone Farm | ||
5694 | 5694 | 5693 | {"type": "Polygon", "coordinates": [[[-122.81259, 38.40564], [-122.81258, 38.40688], [-122.81096, 38.40685], [-122.81095, 38.40686], [-122.81097, 38.4091], [-122.81254, 38.40914], [-122.81254, 38.4196], [-122.81121, 38.41961], [-122.81123, 38.42122], [-122.81049, 38.42125], [-122.81052, 38.42267], [-122.80968, 38.42267], [-122.80969, 38.42059], [-122.80968, 38.42058], [-122.80889, 38.4206], [-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.80679, 38.40816], [-122.80709, 38.40804], [-122.80708, 38.40732], [-122.80753, 38.40716], [-122.80756, 38.4078], [-122.80855, 38.40771], [-122.81022, 38.40712], [-122.81024, 38.4062], [-122.81245, 38.40541], [-122.81259, 38.40564]]]} | No Public Access 3 | Kelly Farm | 20586 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 369.086 | Kelly Farm | ||
1864 | 1864 | 1863 | {"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.6885], [-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.79183, 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 | Bear Canyon | 15921 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 98.24 | Bear Canyon | ||
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 | ||
6296 | 6296 | 6295 | {"type": "Polygon", "coordinates": [[[-122.76936, 38.43528], [-122.7686, 38.43533], [-122.76804, 38.43541], [-122.76769, 38.43551], [-122.76768, 38.4354], [-122.76753, 38.43421], [-122.76921, 38.43412], [-122.76936, 38.43528]]]} | Open Access 1 | Live Oak Park | 21370 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 4.841 | Live Oak Park | ||
190 | 190 | 189 | {"type": "Polygon", "coordinates": [[[-122.76777, 38.44155], [-122.76294, 38.44149], [-122.76245, 38.44143], [-122.75839, 38.44082], [-122.75793, 38.44072], [-122.75784, 38.43796], [-122.75939, 38.43796], [-122.75992, 38.4382], [-122.76024, 38.43812], [-122.76023, 38.43774], [-122.7607, 38.43792], [-122.76121, 38.43805], [-122.76187, 38.43812], [-122.76776, 38.43816], [-122.76777, 38.44155]]]} | Open Access 1 | A Place to Play Park | 15224 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 76.452 | A Place to Play Park | ||
8115 | 8115 | 8114 | {"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.4577], [-122.76613, 38.45742], [-122.76629, 38.45731]]]} | Open Access 1 | Peterson Lane Park | 23632 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 4.051 | Peterson Lane Park | ||
8196 | 8196 | 8195 | {"type": "Polygon", "coordinates": [[[-122.76263, 38.46944], [-122.76261, 38.46948], [-122.76218, 38.46953], [-122.76187, 38.46955], [-122.76156, 38.46954], [-122.76094, 38.46948], [-122.76048, 38.46948], [-122.76047, 38.46866], [-122.76257, 38.46867], [-122.76262, 38.4687], [-122.76263, 38.46944]]]} | Open Access 1 | Pioneer Park | 23734 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 4.352 | Pioneer 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 | ||
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 | |
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 | ||
7490 | 7490 | 7489 | {"type": "Polygon", "coordinates": [[[-122.75088, 38.45585], [-122.75084, 38.45588], [-122.75076, 38.45647], [-122.75075, 38.45755], [-122.74783, 38.45898], [-122.74765, 38.45912], [-122.74747, 38.45933], [-122.74741, 38.45951], [-122.74739, 38.45969], [-122.74536, 38.45968], [-122.74536, 38.45837], [-122.74552, 38.45829], [-122.74565, 38.45773], [-122.74604, 38.45735], [-122.74659, 38.45735], [-122.74655, 38.45765], [-122.7475, 38.45765], [-122.74779, 38.45762], [-122.74779, 38.45737], [-122.74839, 38.45732], [-122.74838, 38.45653], [-122.74829, 38.45649], [-122.74831, 38.45648], [-122.74831, 38.45585], [-122.74823, 38.45583], [-122.74823, 38.45502], [-122.75085, 38.45501], [-122.75088, 38.45585]]]} | Open Access 1 | Northwest Community Park | 22896 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 32.079 | Northwest Community Park | ||
12698 | 12698 | 12697 | {"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 | J.X. Wilson Park | 31385 | 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.235 | J.X. Wilson Park | ||
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 | ||
3058 | 3058 | 3057 | {"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 | Coffey Park | 17476 | 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.869 | Coffey Park | ||
3155 | 3155 | 3154 | {"type": "Polygon", "coordinates": [[[-122.74784, 38.42357], [-122.74779, 38.42358], [-122.74773, 38.42348], [-122.74765, 38.42339], [-122.74745, 38.42324], [-122.74732, 38.42319], [-122.7472, 38.42314], [-122.74692, 38.42311], [-122.74678, 38.42311], [-122.74658, 38.42315], [-122.74658, 38.42303], [-122.74772, 38.42294], [-122.74777, 38.42298], [-122.74784, 38.42357]]]} | Open Access 1 | Cook Park | 17617 | 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.672 | Cook 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 | ||
5514 | 5514 | 5513 | {"type": "Polygon", "coordinates": [[[-122.74343, 38.44794], [-122.74343, 38.44831], [-122.74298, 38.44833], [-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 | Jennings Park | 20390 | 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.811 | Jennings 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 | ||
1935 | 1935 | 1934 | {"type": "Polygon", "coordinates": [[[-122.73927, 38.40898], [-122.73867, 38.40899], [-122.738, 38.40906], [-122.73765, 38.40913], [-122.73678, 38.40934], [-122.73673, 38.40907], [-122.73673, 38.40862], [-122.73676, 38.40856], [-122.73679, 38.40856], [-122.73922, 38.40855], [-122.73926, 38.40859], [-122.73927, 38.40898]]]} | Open Access 1 | Bellevue Ranch | 15988 | 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.291 | Bellevue Ranch |
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]);