superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
89 rows where MNG_AGENCY = 7 sorted by ACRES
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
- Open Access 58
- Unknown Access 11
MNG_AG_TYP 1
MNG_AGENCY 1
- Santa Barbara, County of · 69 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10057 | 10057 | 10056 | {"type": "Polygon", "coordinates": [[[-119.5898, 34.42352], [-119.58906, 34.42428], [-119.5885, 34.42388], [-119.58922, 34.42315], [-119.5898, 34.42352]]]} | Open Access 1 | Summerland Greenwell Preserve | 25961 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.774 | Summerland Greenwell Preserve | ||
11874 | 11874 | 11873 | {"type": "Polygon", "coordinates": [[[-119.79733, 34.4284], [-119.79733, 34.42843], [-119.79699, 34.42842], [-119.79697, 34.42853], [-119.79653, 34.42852], [-119.79651, 34.42886], [-119.79611, 34.42884], [-119.79604, 34.4287], [-119.7958, 34.4284], [-119.79693, 34.42778], [-119.79699, 34.42786], [-119.79698, 34.42838], [-119.79733, 34.4284]]]} | Open Access 1 | Rhoads Open Space | 28548 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.776 | Rhoads OS | ||
7950 | 7950 | 7949 | {"type": "Polygon", "coordinates": [[[-120.49458, 34.67098], [-120.49431, 34.67124], [-120.49306, 34.67174], [-120.493, 34.6711], [-120.49457, 34.67081], [-120.49458, 34.67098]]]} | Unknown Access 4 | Santa Ynez River | 25145 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.883 | Santa Ynez River | ||
14970 | 14970 | 14969 | {"type": "Polygon", "coordinates": [[[-119.80649, 34.43933], [-119.80639, 34.43966], [-119.80611, 34.44014], [-119.80558, 34.44021], [-119.80538, 34.44045], [-119.80531, 34.44096], [-119.80503, 34.44096], [-119.80508, 34.4404], [-119.80517, 34.44035], [-119.80527, 34.44028], [-119.80564, 34.43983], [-119.80575, 34.43961], [-119.8058, 34.43946], [-119.80581, 34.4393], [-119.80649, 34.43933]]]} | Open Access 1 | Lassen Open Space | http://cosb.countyofsb.org/parks/parks03.aspx?id=13252 | 28547 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 2.025 | Lassen OS | |
2205 | 2205 | 2204 | {"type": "Polygon", "coordinates": [[[-119.89151, 34.43413], [-119.89122, 34.43427], [-119.8914, 34.43453], [-119.89147, 34.43483], [-119.89136, 34.43502], [-119.89074, 34.43377], [-119.8905, 34.43295], [-119.89037, 34.43294], [-119.89009, 34.43279], [-119.89018, 34.43279], [-119.89036, 34.43289], [-119.89048, 34.43289], [-119.89051, 34.43294], [-119.89083, 34.43292], [-119.891, 34.43284], [-119.89098, 34.43312], [-119.891, 34.43328], [-119.89106, 34.43344], [-119.89113, 34.43357], [-119.89151, 34.43413]]]} | Open Access 1 | Brandon Park | 16330 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 2.078 | Brandon Park | ||
11316 | 11316 | 11315 | {"type": "Polygon", "coordinates": [[[-119.8955, 34.43359], [-119.89489, 34.4336], [-119.89507, 34.4334], [-119.89518, 34.43316], [-119.89501, 34.43276], [-119.89396, 34.43277], [-119.89349, 34.43308], [-119.89327, 34.43291], [-119.89312, 34.43283], [-119.89296, 34.43279], [-119.89279, 34.43277], [-119.89158, 34.43278], [-119.89147, 34.43278], [-119.89124, 34.43274], [-119.89246, 34.43273], [-119.89311, 34.43267], [-119.89548, 34.43263], [-119.8955, 34.43359]]]} | Open Access 1 | Winchester I Open Space | 27618 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 2.195 | Winchester I OS | ||
2565 | 2565 | 2564 | {"type": "Polygon", "coordinates": [[[-119.89231, 34.42456], [-119.89194, 34.42456], [-119.89112, 34.4248], [-119.89092, 34.42448], [-119.89071, 34.42428], [-119.8899, 34.42429], [-119.89004, 34.4238], [-119.89106, 34.42379], [-119.89102, 34.42385], [-119.89106, 34.42414], [-119.89131, 34.42436], [-119.89168, 34.4244], [-119.89195, 34.42437], [-119.8923, 34.42437], [-119.89231, 34.42456]]]} | Open Access 1 | Campus Glen | 16786 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 2.426 | Campus Glen | ||
14862 | 14862 | 14861 | {"type": "Polygon", "coordinates": [[[-119.82494, 34.44682], [-119.82494, 34.44687], [-119.82461, 34.44687], [-119.82461, 34.4471], [-119.82386, 34.4471], [-119.82384, 34.44677], [-119.82334, 34.44673], [-119.82347, 34.44642], [-119.82407, 34.44613], [-119.82404, 34.44586], [-119.82411, 34.44586], [-119.82415, 34.44614], [-119.82474, 34.44618], [-119.82457, 34.44679], [-119.82494, 34.44682]]]} | Open Access 1 | Emerald Terrace Open Space | 18619 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 2.439 | Emerald Terrace OS | ||
1174 | 1174 | 1173 | {"type": "Polygon", "coordinates": [[[-119.82469, 34.45032], [-119.82467, 34.45037], [-119.82431, 34.45031], [-119.82425, 34.45076], [-119.82392, 34.45074], [-119.8239, 34.45101], [-119.82372, 34.451], [-119.82372, 34.45072], [-119.82337, 34.45073], [-119.8231, 34.45076], [-119.8231, 34.45046], [-119.82295, 34.45043], [-119.82295, 34.45038], [-119.8231, 34.45033], [-119.8231, 34.45002], [-119.82389, 34.45001], [-119.8239, 34.44994], [-119.82433, 34.44998], [-119.82431, 34.45024], [-119.82469, 34.45032]]]} | Open Access 1 | Andamar Park | 15472 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 2.458 | Andamar Park | ||
14946 | 14946 | 14945 | {"type": "Polygon", "coordinates": [[[-119.84074, 34.4486], [-119.84062, 34.44862], [-119.84007, 34.44831], [-119.83956, 34.44809], [-119.83937, 34.44757], [-119.83959, 34.4473], [-119.83992, 34.44739], [-119.84009, 34.44716], [-119.84018, 34.44719], [-119.8403, 34.4472], [-119.84054, 34.44726], [-119.84032, 34.44792], [-119.84042, 34.44822], [-119.84063, 34.4483], [-119.84069, 34.44831], [-119.84074, 34.4486]]]} | Open Access 1 | Stow Canyon Open Space | 25904 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 2.599 | Stow Canyon OS | ||
9989 | 9989 | 9988 | {"type": "Polygon", "coordinates": [[[-119.84133, 34.45093], [-119.84062, 34.45098], [-119.84059, 34.45044], [-119.84067, 34.45043], [-119.84073, 34.45041], [-119.84077, 34.45036], [-119.84079, 34.4503], [-119.84075, 34.4497], [-119.84072, 34.44964], [-119.84067, 34.4496], [-119.84055, 34.44958], [-119.84054, 34.44941], [-119.84028, 34.44897], [-119.84057, 34.44897], [-119.84115, 34.44969], [-119.84132, 34.44997], [-119.84133, 34.45093]]]} | Open Access 1 | Stonebridge | 25878 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 2.613 | Stonebridge | ||
9997 | 9997 | 9996 | {"type": "Polygon", "coordinates": [[[-120.44562, 34.87516], [-120.4456, 34.87591], [-120.44401, 34.87591], [-120.44401, 34.87511], [-120.44418, 34.87512], [-120.44458, 34.87515], [-120.44562, 34.87516]]]} | Open Access 1 | Stonebrook Open Space | 25882 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 3.08 | Stonebrook OS | ||
9342 | 9342 | 9341 | {"type": "MultiPolygon", "coordinates": [[[[-120.08509, 34.61217], [-120.08486, 34.61225], [-120.08464, 34.61234], [-120.08421, 34.61266], [-120.08416, 34.61268], [-120.08416, 34.61217], [-120.08509, 34.61217]]], [[[-120.08517, 34.61149], [-120.08516, 34.61204], [-120.0845, 34.61203], [-120.08451, 34.61148], [-120.08517, 34.61149]]], [[[-120.08606, 34.6115], [-120.08594, 34.61162], [-120.08572, 34.61198], [-120.08555, 34.61204], [-120.08543, 34.61204], [-120.08543, 34.61149], [-120.08606, 34.6115]]], [[[-120.08723, 34.61005], [-120.08718, 34.61013], [-120.08634, 34.61118], [-120.08635, 34.6112], [-120.08626, 34.61128], [-120.08554, 34.61129], [-120.08554, 34.61123], [-120.08561, 34.61111], [-120.0859, 34.61112], [-120.08608, 34.61102], [-120.08626, 34.6111], [-120.08632, 34.61104], [-120.08622, 34.61074], [-120.08647, 34.61044], [-120.0867, 34.61044], [-120.08691, 34.61018], [-120.08706, 34.61005], [-120.08723, 34.61005]]]]} | Open Access 1 | Santa Ynez Park | 25143 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 3.198 | Santa Ynez Park | ||
5415 | 5415 | 5414 | {"type": "MultiPolygon", "coordinates": [[[[-119.86379, 34.40971], [-119.86363, 34.40971], [-119.86363, 34.40905], [-119.86379, 34.40904], [-119.86379, 34.40971]]], [[[-119.86421, 34.40971], [-119.86396, 34.40971], [-119.86396, 34.40902], [-119.8642, 34.40901], [-119.86421, 34.40971]]], [[[-119.8647, 34.40971], [-119.86462, 34.40971], [-119.86462, 34.40897], [-119.8647, 34.40897], [-119.8647, 34.40971]]], [[[-119.86943, 34.40918], [-119.86943, 34.40945], [-119.86919, 34.40944], [-119.86913, 34.40981], [-119.86907, 34.4098], [-119.86911, 34.40942], [-119.86808, 34.40933], [-119.86802, 34.40971], [-119.86798, 34.40971], [-119.86797, 34.40933], [-119.86772, 34.40933], [-119.86772, 34.40971], [-119.86759, 34.40971], [-119.86758, 34.40933], [-119.86719, 34.40933], [-119.86666, 34.40933], [-119.86666, 34.40971], [-119.86649, 34.40971], [-119.8665, 34.40896], [-119.86943, 34.40918]]]]} | Open Access 1 | Isla Vista Beach | 20277 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 3.462 | Isla Vista Beach | ||
8519 | 8519 | 8518 | {"type": "Polygon", "coordinates": [[[-120.63883, 34.95912], [-120.63659, 34.95879], [-120.63662, 34.9577], [-120.6378, 34.9583], [-120.63834, 34.95875], [-120.63883, 34.95912]]]} | Open Access 1 | Rancho Guadalupe Dunes | 24146 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 3.498 | Rancho Guadalupe Dunes | ||
1929 | 1929 | 1928 | {"type": "Polygon", "coordinates": [[[-119.88428, 34.43726], [-119.88429, 34.43764], [-119.88422, 34.43784], [-119.8841, 34.4383], [-119.8841, 34.43883], [-119.88322, 34.43885], [-119.88319, 34.43884], [-119.88317, 34.43881], [-119.88317, 34.43831], [-119.88319, 34.43814], [-119.88326, 34.4379], [-119.8834, 34.43768], [-119.88348, 34.4375], [-119.88353, 34.4373], [-119.88357, 34.43727], [-119.88428, 34.43726]]]} | Open Access 1 | Bella Vista I & II | 15977 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 3.564 | Bella Vista I & II | ||
2648 | 2648 | 2647 | {"type": "MultiPolygon", "coordinates": [[[[-119.50852, 34.39516], [-119.50697, 34.39588], [-119.50689, 34.39577], [-119.5075, 34.3955], [-119.50841, 34.395], [-119.50852, 34.39516]]], [[[-119.50986, 34.39487], [-119.50965, 34.39489], [-119.50944, 34.39484], [-119.50927, 34.39472], [-119.50912, 34.39454], [-119.50904, 34.39446], [-119.50888, 34.39438], [-119.50873, 34.39436], [-119.5086, 34.39437], [-119.50821, 34.39482], [-119.50804, 34.39483], [-119.50784, 34.39456], [-119.50791, 34.39452], [-119.50809, 34.39428], [-119.50817, 34.39415], [-119.50814, 34.39411], [-119.50831, 34.39392], [-119.50859, 34.39368], [-119.50859, 34.3931], [-119.50876, 34.39344], [-119.50894, 34.39363], [-119.50973, 34.39477], [-119.5098, 34.39476], [-119.50986, 34.39487]]]]} | Unknown Access 4 | Carpinteria Creek | 16896 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 3.636 | Carpinteria Creek | ||
9710 | 9710 | 9709 | {"type": "Polygon", "coordinates": [[[-119.69311, 34.46023], [-119.69221, 34.46094], [-119.69162, 34.46037], [-119.6916, 34.46001], [-119.69199, 34.45915], [-119.69235, 34.45915], [-119.69311, 34.46023]]]} | Open Access 1 | Skofield Park | 25529 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 4.076 | Skofield Park | ||
4862 | 4862 | 4861 | {"type": "Polygon", "coordinates": [[[-119.63709, 34.41583], [-119.63704, 34.41641], [-119.63642, 34.41654], [-119.63646, 34.41695], [-119.63641, 34.41723], [-119.63631, 34.41757], [-119.63611, 34.41758], [-119.63581, 34.41763], [-119.63571, 34.41761], [-119.63562, 34.41754], [-119.6355, 34.41737], [-119.6354, 34.4173], [-119.63519, 34.41724], [-119.63496, 34.41724], [-119.63485, 34.41687], [-119.6343, 34.41697], [-119.6338, 34.41711], [-119.63385, 34.41696], [-119.63423, 34.41679], [-119.635, 34.41663], [-119.63563, 34.41644], [-119.63623, 34.4162], [-119.6365, 34.41604], [-119.63678, 34.4159], [-119.63709, 34.41583]]]} | Unknown Access 4 | Hammond's Meadow | 19627 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 5.374 | Hammond's Meadow | ||
14838 | 14838 | 14837 | {"type": "MultiPolygon", "coordinates": [[[[-119.90372, 34.44055], [-119.90337, 34.44064], [-119.90304, 34.44075], [-119.90228, 34.44082], [-119.90212, 34.44081], [-119.9019, 34.44074], [-119.9018, 34.44071], [-119.90159, 34.44073], [-119.90141, 34.44081], [-119.90103, 34.44128], [-119.90044, 34.44129], [-119.90044, 34.44119], [-119.90054, 34.44119], [-119.90067, 34.44116], [-119.90084, 34.44107], [-119.90091, 34.441], [-119.90125, 34.44054], [-119.9014, 34.44043], [-119.90154, 34.44038], [-119.90164, 34.44037], [-119.90178, 34.44039], [-119.90217, 34.44055], [-119.90229, 34.44058], [-119.90243, 34.44059], [-119.90262, 34.44056], [-119.90312, 34.44039], [-119.90321, 34.44038], [-119.90344, 34.44039], [-119.90363, 34.44036], [-119.90367, 34.44038], [-119.90372, 34.44055]]], [[[-119.90635, 34.43896], [-119.90632, 34.43909], [-119.90622, 34.43924], [-119.90594, 34.43954], [-119.90539, 34.43967], [-119.90513, 34.43993], [-119.90497, 34.4404], [-119.90466, 34.44068], [-119.90455, 34.44101], [-119.90449, 34.44101], [-119.90448, 34.44078], [-119.90438, 34.44049], [-119.90389, 34.44046], [-119.90385, 34.44036], [-119.90389, 34.44031], [-119.90399, 34.44031], [-119.90417, 34.44034], [-119.90427, 34.44034], [-119.90442, 34.4403], [-119.90455, 34.44022], [-119.90469, 34.44007], [-119.90481, 34.43981], [-119.90508, 34.4395], [-119.90518, 34.43942], [-119.90535, 34.43934], [-119.90543, 34.43927], [-119.90548, 34.43918], [-119.90549, 34.43905], [-119.90547, 34.43895], [-119.90539, 34.43885], [-119.90549, 34.43857], [-119.90613, 34.43873], [-119.9063, 34.43887], [-119.90635, 34.43896]]]]} | Open Access 1 | San Miguel Open Space | 24956 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 5.812 | San Miguel OS |
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]);