units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
119 rows where MNG_AGENCY = 7 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, YR_EST, GAP_STS
DES_TP 19
- Local Park 40
- Local Other or Unknown 39
- Local Recreation Area 19
- Local Conservation Area 5
- Local Historic or Cultural Area 2
- National Forest 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
- Open Access 105
- Unknown Access 13
- No Public Access 1
MNG_AG_TYP 1
- County Agency 119
MNG_AGENCY 1
- Santa Barbara, County of · 119 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10246 | 10246 | 10245 | {"type": "Polygon", "coordinates": [[[-120.67009, 34.90633], [-120.6671, 34.91364], [-120.66438, 34.92044], [-120.66391, 34.92673], [-120.655, 34.91725], [-120.64527, 34.90698], [-120.64528, 34.90274], [-120.65299, 34.90277], [-120.66179, 34.90273], [-120.66183, 34.90636], [-120.67009, 34.90633]]]} | Open Access 1 | 18725 | Point Sal Preserve | 23860 | 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 | 759.061 | Point Sal Preserve | 0 | Local Conservation Area 4 | 2 | |
9798 | 9798 | 9797 | {"type": "Polygon", "coordinates": [[[-120.65717, 34.9522], [-120.65432, 34.95978], [-120.6519, 34.96646], [-120.65078, 34.97051], [-120.64878, 34.96944], [-120.64914, 34.96875], [-120.64889, 34.96826], [-120.64937, 34.96772], [-120.64677, 34.96656], [-120.64661, 34.96442], [-120.64568, 34.96166], [-120.64502, 34.96078], [-120.64471, 34.96016], [-120.64403, 34.95965], [-120.64345, 34.95932], [-120.64321, 34.9592], [-120.64235, 34.95893], [-120.64056, 34.95849], [-120.64021, 34.95863], [-120.63876, 34.95838], [-120.63834, 34.95875], [-120.6378, 34.9583], [-120.63663, 34.9577], [-120.63662, 34.95771], [-120.63659, 34.95879], [-120.63347, 34.95834], [-120.63251, 34.95793], [-120.63144, 34.95778], [-120.63125, 34.95708], [-120.6326, 34.95643], [-120.63361, 34.95661], [-120.63361, 34.95605], [-120.63038, 34.95437], [-120.63021, 34.95408], [-120.63031, 34.95324], [-120.62935, 34.95269], [-120.62838, 34.95091], [-120.6414, 34.95112], [-120.64138, 34.95191], [-120.65717, 34.9522]]]} | Open Access 1 | 16704 | Guadalupe-Nipomo Dunes Preserve Forest | 28194 | 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 | https://www.countyofsb.org/parks/parks02.aspx?id=13422 | Santa Barbara 7 | 611.44 | Guadalupe-Nipomo Dunes Preserve Forest | 0 | Local Conservation Area 4 | 2 |
10534 | 10534 | 10533 | {"type": "Polygon", "coordinates": [[[-120.64412, 34.90026], [-120.64204, 34.90058], [-120.64173, 34.89828], [-120.64219, 34.8982], [-120.64204, 34.89799], [-120.64215, 34.89777], [-120.64198, 34.89745], [-120.64183, 34.89732], [-120.64137, 34.89716], [-120.64138, 34.89665], [-120.6409, 34.8964], [-120.64063, 34.89541], [-120.64012, 34.89522], [-120.64029, 34.89485], [-120.63925, 34.89369], [-120.6401, 34.89205], [-120.64001, 34.89015], [-120.64053, 34.89152], [-120.6419, 34.89213], [-120.64356, 34.8994], [-120.64411, 34.89945], [-120.64412, 34.90026]]]} | Open Access 1 | 18744 | Point Sal | 30308 | 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=13402 | Santa Barbara 7 | 44.382 | Point Sal | None 923 | ||
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 | |||
9797 | 9797 | 9796 | {"type": "Polygon", "coordinates": [[[-120.62079, 34.9228], [-120.61833, 34.92572], [-120.61614, 34.92667], [-120.61284, 34.92723], [-120.61082, 34.9285], [-120.60801, 34.92843], [-120.60579, 34.92913], [-120.60323, 34.92864], [-120.6034, 34.92007], [-120.60505, 34.91213], [-120.60601, 34.91131], [-120.61581, 34.91629], [-120.61728, 34.9197], [-120.62079, 34.9228]]]} | Open Access 1 | 16700 | Guadalupe Dunes County Park | 11773 | 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 | https://www.countyofsb.org/parks/parks02.aspx?id=13422 | Santa Barbara 7 | 505.539 | Guadalupe Dunes County Park | 0 | Local Park 2 | 4 |
9284 | 9284 | 9283 | {"type": "Polygon", "coordinates": [[[-120.5041, 34.51207], [-120.501, 34.51213], [-120.49956, 34.5122], [-120.49927, 34.5116], [-120.49962, 34.5115], [-120.49953, 34.51118], [-120.49947, 34.51085], [-120.49943, 34.51052], [-120.49942, 34.51018], [-120.49944, 34.50985], [-120.4995, 34.50952], [-120.49989, 34.50953], [-120.49988, 34.50973], [-120.50074, 34.50986], [-120.50074, 34.50865], [-120.50101, 34.50799], [-120.5041, 34.51207]]]} | Open Access 1 | 17015 | Jalama Beach County Park | 20338 | 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 | 26.626 | Jalama Beach County Park | 0 | Local Park 2 | 4 | |
5597 | 5597 | 5596 | {"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 | 631 | Santa Ynez River | 25145 | 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.884 | Santa Ynez River | None 451 | |||
2555 | 2555 | 2554 | {"type": "Polygon", "coordinates": [[[-120.47151, 34.59209], [-120.4715, 34.59302], [-120.4694, 34.59376], [-120.46933, 34.59299], [-120.47003, 34.59241], [-120.47066, 34.59232], [-120.47151, 34.59209]]]} | Open Access 1 | 17819 | Miguelito County Park | 22211 | 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 | 5.367 | Miguelito County Park | 0 | Local Park 2 | 4 | |
13271 | 13271 | 13270 | {"type": "Polygon", "coordinates": [[[-120.45861, 34.63105], [-120.4586, 34.6313], [-120.45841, 34.63139], [-120.45828, 34.63142], [-120.45798, 34.63146], [-120.45797, 34.63153], [-120.45768, 34.63151], [-120.45734, 34.63146], [-120.45735, 34.63104], [-120.45861, 34.63105]]]} | Unknown Access 4 | 35320 | Santa Barbara holding 11 | 25043 | 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.308 | Santa Barbara holding 11 | 0 | Local Other or Unknown 14 | 4 | |
9587 | 9587 | 9586 | {"type": "Polygon", "coordinates": [[[-120.45155, 34.63055], [-120.45154, 34.63089], [-120.45128, 34.63077], [-120.45087, 34.63037], [-120.45125, 34.63029], [-120.45155, 34.63055]]]} | Open Access 1 | 17395 | Lompoc Cemetery | 21418 | 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 | 0.518 | Lompoc Cemetery | 0 | Local Historic or Cultural Area 19 | 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 | |
4181 | 4181 | 4180 | {"type": "Polygon", "coordinates": [[[-120.44516, 34.8993], [-120.44515, 34.90526], [-120.43668, 34.90529], [-120.43648, 34.90517], [-120.43631, 34.9047], [-120.43632, 34.90177], [-120.43902, 34.90176], [-120.43902, 34.89957], [-120.43913, 34.89956], [-120.43913, 34.89863], [-120.4392, 34.89828], [-120.43921, 34.89813], [-120.43919, 34.89613], [-120.4391, 34.89559], [-120.43902, 34.89558], [-120.43906, 34.89471], [-120.43963, 34.89485], [-120.44023, 34.89505], [-120.44093, 34.89552], [-120.44516, 34.8993]]]} | Open Access 1 | 1794 | Waller Park | 27221 | 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 | 154.426 | Waller Park | 0 | Local Park 2 | 4 | |
31 | 31 | 30 | {"type": "Polygon", "coordinates": [[[-120.44007, 34.65751], [-120.44003, 34.66064], [-120.4377, 34.66062], [-120.43735, 34.65839], [-120.43399, 34.65557], [-120.43409, 34.64948], [-120.43349, 34.64835], [-120.43323, 34.648], [-120.4329, 34.64769], [-120.43272, 34.64755], [-120.43252, 34.64742], [-120.43202, 34.64716], [-120.43205, 34.64698], [-120.43156, 34.64672], [-120.4313, 34.64654], [-120.43107, 34.64633], [-120.43086, 34.64611], [-120.43007, 34.64516], [-120.42988, 34.64496], [-120.42986, 34.6449], [-120.42988, 34.64483], [-120.43012, 34.64467], [-120.43121, 34.64405], [-120.43128, 34.64412], [-120.43217, 34.6436], [-120.43226, 34.6436], [-120.43589, 34.64992], [-120.4396, 34.65676], [-120.44007, 34.65751]]]} | Open Access 1 | 80 | River Park | 24416 | 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 | 123.418 | River Park | 0 | Local Park 2 | 4 | |
4645 | 4645 | 4644 | {"type": "Polygon", "coordinates": [[[-120.43198, 34.86241], [-120.43198, 34.86322], [-120.4285, 34.86322], [-120.42752, 34.86223], [-120.42776, 34.86205], [-120.42838, 34.8625], [-120.42864, 34.86265], [-120.42893, 34.86274], [-120.43007, 34.86289], [-120.4306, 34.86289], [-120.43156, 34.86279], [-120.43198, 34.86241]]]} | Open Access 1 | 36496 | 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 | 4.83 | 0 | Local Other or Unknown 14 | 4 | ||
15459 | 15459 | 15458 | {"type": "Polygon", "coordinates": [[[-120.42776, 34.86205], [-120.42752, 34.86223], [-120.4262, 34.86092], [-120.42656, 34.86071], [-120.42734, 34.86163], [-120.42742, 34.8617], [-120.42755, 34.86174], [-120.42752, 34.86183], [-120.42776, 34.86205]]]} | Open Access 1 | 36549 | 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.547 | 0 | Local Other or Unknown 14 | 4 | ||
4653 | 4653 | 4652 | {"type": "Polygon", "coordinates": [[[-120.42656, 34.86071], [-120.4262, 34.86092], [-120.42568, 34.86014], [-120.42602, 34.86015], [-120.42622, 34.86031], [-120.42656, 34.86071]]]} | Open Access 1 | 36566 | 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 | 0.748 | 0 | Local Other or Unknown 14 | 4 | ||
4654 | 4654 | 4653 | {"type": "Polygon", "coordinates": [[[-120.42629, 34.86984], [-120.42629, 34.87058], [-120.42539, 34.87059], [-120.42539, 34.86983], [-120.42629, 34.86984]]]} | Open Access 1 | 36567 | 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 | 1.686 | 0 | Local Other or Unknown 14 | 4 | ||
4644 | 4644 | 4643 | {"type": "Polygon", "coordinates": [[[-120.42602, 34.86014], [-120.42568, 34.86014], [-120.42519, 34.85941], [-120.42519, 34.85919], [-120.4253, 34.85927], [-120.42583, 34.85995], [-120.42602, 34.86014]]]} | Open Access 1 | 36495 | 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 | 0.558 | 0 | Local Other or Unknown 14 | 4 | ||
3487 | 3487 | 3486 | {"type": "Polygon", "coordinates": [[[-120.42216, 34.84972], [-120.42192, 34.85046], [-120.42153, 34.85094], [-120.42161, 34.85109], [-120.42151, 34.85123], [-120.42113, 34.85129], [-120.42097, 34.852], [-120.4202, 34.85238], [-120.42045, 34.85272], [-120.42027, 34.85283], [-120.41993, 34.85247], [-120.41927, 34.85288], [-120.41925, 34.85304], [-120.41877, 34.85301], [-120.4185, 34.85298], [-120.41851, 34.85295], [-120.41878, 34.85272], [-120.41876, 34.85243], [-120.41873, 34.85237], [-120.41785, 34.85177], [-120.41792, 34.85149], [-120.41769, 34.85134], [-120.41774, 34.85092], [-120.4174, 34.85061], [-120.41773, 34.85045], [-120.41787, 34.85016], [-120.41891, 34.85012], [-120.41919, 34.84959], [-120.4196, 34.84947], [-120.42048, 34.84963], [-120.42153, 34.84925], [-120.422, 34.8495], [-120.42216, 34.84972]]]} | Open Access 1 | 48769 | Orcutt Community Park | 33496 | 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 | https://www.countyofsb.org/parks/asset.c/581 | Santa Barbara 7 | 26.01 | Orcutt Community Park | 0 | Local Park 2 | 4 |
4651 | 4651 | 4650 | {"type": "Polygon", "coordinates": [[[-120.42212, 34.86173], [-120.42211, 34.86232], [-120.41957, 34.86066], [-120.41894, 34.86066], [-120.41894, 34.86], [-120.41957, 34.86001], [-120.41994, 34.86023], [-120.42093, 34.86118], [-120.42212, 34.86173]]]} | Open Access 1 | 36564 | 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 | 4.39 | 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]);