units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
119 rows where MNG_AGENCY = 7 sorted by ACRES
This data as json, copyable, CSV (advanced)
DES_TP 15
- Local Park 31
- Local Other or Unknown 19
- Local Recreation Area 15
- Local Conservation Area 3
- National Forest 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
- Open Access 69
- Unknown Access 10
MNG_AG_TYP 1
MNG_AGENCY 1
- Santa Barbara, County of · 79 ✖
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES ▼ | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15436 | 15436 | 15435 | {"type": "Polygon", "coordinates": [[[-119.71104, 34.46218], [-119.70997, 34.4622], [-119.71005, 34.46101], [-119.71021, 34.46101], [-119.71049, 34.46161], [-119.71092, 34.46166], [-119.71104, 34.46218]]]} | Open Access 1 | 36550 | Unnamed site - Santa Barbara, County of | 28662 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 1.9 | 0 | Local Other or Unknown 14 | 4 | ||
10201 | 10201 | 10200 | {"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.43982], [-119.80575, 34.43961], [-119.8058, 34.43946], [-119.80581, 34.4393], [-119.80649, 34.43933]]]} | Open Access 1 | 35229 | Lassen Open Space | 28547 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/parks03.aspx?id=13252 | Santa Barbara 7 | 2.024 | Lassen OS | 0 | Local Recreation Area 3 | 4 |
5814 | 5814 | 5813 | {"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.8905, 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 | 123 | Brandon Park | 16330 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.073 | Brandon Park | 0 | Local Park 2 | 4 | |
15462 | 15462 | 15461 | {"type": "Polygon", "coordinates": [[[-119.7985, 34.44828], [-119.79829, 34.44848], [-119.79825, 34.44887], [-119.79785, 34.44906], [-119.79743, 34.4492], [-119.79721, 34.44922], [-119.79721, 34.44845], [-119.7972, 34.44828], [-119.7985, 34.44828]]]} | Open Access 1 | 36552 | Unknown park - Santa Barbara, County of | 28663 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.181 | 0 | Local Other or Unknown 14 | 4 | ||
2864 | 2864 | 2863 | {"type": "Polygon", "coordinates": [[[-119.8955, 34.43359], [-119.89489, 34.4336], [-119.89507, 34.4334], [-119.89518, 34.43315], [-119.89502, 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 | 1923 | Winchester I Open Space | 27618 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.191 | Winchester I OS | 0 | Local Recreation Area 3 | 4 | |
6484 | 6484 | 6483 | {"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.42384], [-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 | 2366 | Campus Glen | 16786 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.424 | Campus Glen | None 523 | |||
9316 | 9316 | 9315 | {"type": "Polygon", "coordinates": [[[-119.82494, 34.44682], [-119.82494, 34.44687], [-119.82461, 34.44687], [-119.82461, 34.4471], [-119.82386, 34.4471], [-119.82385, 34.44677], [-119.82334, 34.44673], [-119.82347, 34.44642], [-119.82408, 34.44613], [-119.82404, 34.44586], [-119.82411, 34.44586], [-119.82415, 34.44614], [-119.82474, 34.44618], [-119.82457, 34.4468], [-119.82494, 34.44682]]]} | Open Access 1 | 15524 | Emerald Terrace Open Space | 18619 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.426 | Emerald Terrace OS | 0 | Local Recreation Area 3 | 4 | |
7691 | 7691 | 7690 | {"type": "Polygon", "coordinates": [[[-119.82469, 34.45032], [-119.82467, 34.45037], [-119.8243, 34.45031], [-119.82425, 34.45076], [-119.82391, 34.45073], [-119.8239, 34.45101], [-119.82372, 34.451], [-119.82373, 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.45025], [-119.82469, 34.45032]]]} | Open Access 1 | 7682 | Andamar Park | 15472 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.445 | Andamar Park | 0 | Local Park 2 | 4 | |
15467 | 15467 | 15466 | {"type": "Polygon", "coordinates": [[[-119.71114, 34.46263], [-119.7109, 34.46311], [-119.70995, 34.46314], [-119.70997, 34.46221], [-119.71104, 34.46218], [-119.71114, 34.46263]]]} | Open Access 1 | 36559 | Unnamed site - Santa Barbara, County of | 28662 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.578 | 0 | Local Other or Unknown 14 | 4 | ||
15835 | 15835 | 15834 | {"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.44831], [-119.84069, 34.44831], [-119.84074, 34.4486]]]} | Open Access 1 | 1150 | Stow Canyon Open Space | 25904 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.596 | Stow Canyon OS | 0 | Local Recreation Area 3 | 4 | |
4845 | 4845 | 4844 | {"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 | 1110 | Stonebridge | 25878 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.613 | Stonebridge | None 406 | |||
4649 | 4649 | 4648 | {"type": "Polygon", "coordinates": [[[-120.41141, 34.87986], [-120.41097, 34.87998], [-120.41078, 34.88006], [-120.41065, 34.88015], [-120.41051, 34.88028], [-120.41044, 34.88037], [-120.41039, 34.88048], [-120.41036, 34.88065], [-120.41036, 34.88075], [-120.4104, 34.88096], [-120.41046, 34.88113], [-120.41054, 34.8813], [-120.41141, 34.88251], [-120.40984, 34.88064], [-120.40981, 34.87972], [-120.41134, 34.87967], [-120.41141, 34.87986]]]} | Open Access 1 | 36561 | Unnamed site - Santa Barbara, County of | 28662 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.987 | 0 | Local Other or Unknown 14 | 4 | ||
15463 | 15463 | 15462 | {"type": "Polygon", "coordinates": [[[-119.79849, 34.44828], [-119.79718, 34.44828], [-119.79717, 34.44776], [-119.79691, 34.44741], [-119.79692, 34.44733], [-119.79713, 34.44713], [-119.79773, 34.44715], [-119.79804, 34.44701], [-119.79807, 34.44705], [-119.79777, 34.4472], [-119.79849, 34.44828]]]} | Open Access 1 | 36555 | Unknown park - Santa Barbara, County of | 28663 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.992 | 0 | Local Other or Unknown 14 | 4 | ||
5504 | 5504 | 5503 | {"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 | 1135 | Stonebrook Open Space | 25882 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 3.08 | Stonebrook OS | 0 | Local Recreation Area 3 | 4 | |
3849 | 3849 | 3848 | {"type": "MultiPolygon", "coordinates": [[[[-120.08509, 34.61217], [-120.08485, 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.08625, 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 | 626 | Santa Ynez Park | 25143 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 3.195 | Santa Ynez Park | 0 | Local Park 2 | 4 | |
9900 | 9900 | 9899 | {"type": "MultiPolygon", "coordinates": [[[[-119.8647, 34.40971], [-119.86462, 34.40971], [-119.86462, 34.40897], [-119.8647, 34.40897], [-119.8647, 34.40971]]], [[[-119.86421, 34.40971], [-119.86396, 34.40971], [-119.86396, 34.40902], [-119.8642, 34.40901], [-119.86421, 34.40971]]], [[[-119.86379, 34.40971], [-119.86363, 34.40971], [-119.86363, 34.40905], [-119.86379, 34.40904], [-119.86379, 34.40971]]], [[[-119.86943, 34.40918], [-119.86943, 34.40945], [-119.86919, 34.40943], [-119.86913, 34.40981], [-119.86907, 34.4098], [-119.86911, 34.40942], [-119.86807, 34.40933], [-119.86802, 34.40971], [-119.86798, 34.40971], [-119.86798, 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 | 16980 | Isla Vista Beach | 20277 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 3.442 | Isla Vista Beach | 0 | Local Park 2 | 4 | |
13276 | 13276 | 13275 | {"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 | 45324 | Rancho Guadalupe Dunes | 24146 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 3.499 | Rancho Guadalupe Dunes | None 1151 | |||
10076 | 10076 | 10075 | {"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 | 17722 | Bella Vista I & II | 15977 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 3.564 | Bella Vista I & II | None 871 | |||
6620 | 6620 | 6619 | {"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.39453], [-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.39429], [-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.50974, 34.39478], [-119.5098, 34.39476], [-119.50986, 34.39487]]]]} | Unknown Access 4 | 4305 | Carpinteria Creek | 16896 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 3.634 | Carpinteria Creek | 0 | Local Other or Unknown 14 | 4 | |
4646 | 4646 | 4645 | {"type": "Polygon", "coordinates": [[[-119.89022, 34.44448], [-119.88862, 34.44371], [-119.88866, 34.44361], [-119.88926, 34.44355], [-119.88954, 34.44276], [-119.89019, 34.44276], [-119.89019, 34.44417], [-119.89022, 34.44448]]]} | Open Access 1 | 36501 | Unnamed site - Santa Barbara, County of | 28662 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 3.642 | 0 | Local Other or Unknown 14 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);