superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
79 rows where MNG_AGENCY = 29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
2300 | 2300 | 2299 | {"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.80079, 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.7948, 38.41029], [-122.79468, 38.41014], [-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.79166, 38.40561], [-122.7905, 38.40387], [-122.79017, 38.40336], [-122.79016, 38.40336], [-122.79016, 38.40341], [-122.79022, 38.40352], [-122.7916, 38.40558], [-122.79165, 38.40562], [-122.79166, 38.40561]], [[-122.79449, 38.40987], [-122.7939, 38.40892], [-122.7932, 38.40791], [-122.79289, 38.40741], [-122.79266, 38.40708], [-122.79264, 38.40708], [-122.79309, 38.40795], [-122.79429, 38.41005], [-122.79431, 38.41005], [-122.79449, 38.40987]]], [[[-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.80164, 38.40818], [-122.80555, 38.4068], [-122.80919, 38.40545], [-122.81178, 38.40453], [-122.81178, 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 | Brown Farm | 16443 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 468.353 | Brown Farm | ||
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 | ||
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 | ||
2990 | 2990 | 2989 | {"type": "Polygon", "coordinates": [[[-122.69702, 38.44707], [-122.69667, 38.44712], [-122.69664, 38.44728], [-122.69643, 38.44733], [-122.69631, 38.4472], [-122.69599, 38.44727], [-122.69594, 38.44715], [-122.69636, 38.44706], [-122.69699, 38.44694], [-122.69702, 38.44707]]]} | Open Access 1 | Eastside Park | 18400 | 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.421 | Eastside 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 | ||
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 | ||
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 | ||
3099 | 3099 | 3098 | {"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 | College Triangle Park | 17513 | 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.094 | College Triangle 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 | ||
3265 | 3265 | 3264 | {"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.66587, 38.432], [-122.66551, 38.43187], [-122.66457, 38.43138], [-122.66443, 38.43128], [-122.66431, 38.43116], [-122.66448, 38.43108], [-122.66447, 38.43084], [-122.66505, 38.43084], [-122.66506, 38.43086], [-122.66692, 38.43176], [-122.66692, 38.43193]]]} | Open Access 1 | Creekside Park | 17780 | 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.52 | Creekside Park | ||
3496 | 3496 | 3495 | {"type": "Polygon", "coordinates": [[[-122.71291, 38.46188], [-122.71241, 38.46199], [-122.71216, 38.46156], [-122.7115, 38.46172], [-122.70972, 38.46007], [-122.70965, 38.45995], [-122.71273, 38.45904], [-122.71291, 38.46188]]]} | Open Access 1 | Franklin Park | 19066 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 13.315 | Franklin Park | ||
3590 | 3590 | 3589 | {"type": "Polygon", "coordinates": [[[-122.72547, 38.44105], [-122.72507, 38.44108], [-122.72464, 38.44045], [-122.72539, 38.44038], [-122.72547, 38.44105]]]} | Open Access 1 | DeTurk Park | 18123 | 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.923 | DeTurk Park | ||
3697 | 3697 | 3696 | {"type": "Polygon", "coordinates": [[[-122.69985, 38.43896], [-122.69973, 38.43922], [-122.69957, 38.43929], [-122.69935, 38.43966], [-122.69914, 38.43967], [-122.69902, 38.43988], [-122.69885, 38.43999], [-122.69873, 38.43998], [-122.69789, 38.44012], [-122.69763, 38.44002], [-122.69723, 38.44004], [-122.69707, 38.44015], [-122.69663, 38.44035], [-122.69639, 38.44033], [-122.69625, 38.44048], [-122.69587, 38.44045], [-122.69574, 38.44049], [-122.69535, 38.44019], [-122.69525, 38.44048], [-122.69476, 38.44073], [-122.69456, 38.44078], [-122.6943, 38.44094], [-122.69388, 38.44108], [-122.69412, 38.4409], [-122.69326, 38.44], [-122.69282, 38.43949], [-122.69287, 38.43943], [-122.69297, 38.43927], [-122.69313, 38.43917], [-122.69333, 38.43912], [-122.69332, 38.43909], [-122.69351, 38.43888], [-122.69374, 38.43867], [-122.69372, 38.43861], [-122.6941, 38.43834], [-122.69447, 38.43846], [-122.69494, 38.43873], [-122.69546, 38.43892], [-122.69586, 38.43913], [-122.69611, 38.43929], [-122.6965, 38.43937], [-122.69668, 38.43929], [-122.6971, 38.43881], [-122.69765, 38.43904], [-122.69809, 38.43902], [-122.69859, 38.43876], [-122.69924, 38.43896], [-122.69985, 38.43896]]]} | Open Access 1 | Doyle Park | 18260 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 21.6 | Doyle 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 | ||
4229 | 4229 | 4228 | {"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 | Fir Ridge Park | 18907 | 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.974 | Fir Ridge Park | ||
4246 | 4246 | 4245 | {"type": "Polygon", "coordinates": [[[-122.67816, 38.4529], [-122.67762, 38.45386], [-122.67755, 38.45412], [-122.67671, 38.4539], [-122.67688, 38.45341], [-122.67693, 38.45318], [-122.6772, 38.45246], [-122.67816, 38.4529]]]} | Open Access 1 | Flat Rock Park | 18940 | 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.264 | Flat Rock Park | ||
4341 | 4341 | 4340 | {"type": "Polygon", "coordinates": [[[-122.71874, 38.48454], [-122.71869, 38.48464], [-122.71849, 38.48473], [-122.71825, 38.48472], [-122.71701, 38.48418], [-122.71617, 38.48412], [-122.71608, 38.48403], [-122.71597, 38.48385], [-122.71598, 38.48356], [-122.71586, 38.48337], [-122.71585, 38.48324], [-122.71575, 38.48311], [-122.71563, 38.48271], [-122.71578, 38.48242], [-122.71645, 38.48208], [-122.71813, 38.48189], [-122.71837, 38.48227], [-122.71839, 38.48241], [-122.71821, 38.48312], [-122.7183, 38.48367], [-122.71853, 38.48395], [-122.71869, 38.48423], [-122.71869, 38.4844], [-122.71874, 38.48454]]]} | Open Access 1 | Fountain Grove Park | 19021 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 14.017 | Fountain Grove 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 | |
4473 | 4473 | 4472 | {"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 | Galvin Park | 19183 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 24.146 | Galvin 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]);