superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
89 rows where MNG_AGENCY = 7 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8281 | 8281 | 8280 | {"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.66184, 34.90635], [-120.67009, 34.90633]]]} | Open Access 1 | Point Sal Preserve | 23860 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 759.094 | Point Sal Preserve | ||
11638 | 11638 | 11637 | {"type": "Polygon", "coordinates": [[[-120.65717, 34.9522], [-120.65432, 34.95978], [-120.6519, 34.96646], [-120.65078, 34.97051], [-120.64878, 34.96944], [-120.64913, 34.96876], [-120.64889, 34.96826], [-120.64936, 34.96771], [-120.64677, 34.96656], [-120.64661, 34.96441], [-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.95771], [-120.63662, 34.95772], [-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.6336, 34.9566], [-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.64139, 34.95191], [-120.65717, 34.9522]]]} | Open Access 1 | Guadalupe-Nipomo Dunes Preserve Forest | https://www.countyofsb.org/parks/parks02.aspx?id=13422 | 28194 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 611.488 | Guadalupe-Nipomo Dunes Preserve Forest | |
13081 | 13081 | 13080 | {"type": "Polygon", "coordinates": [[[-120.64412, 34.90026], [-120.64204, 34.90058], [-120.64173, 34.89828], [-120.64218, 34.8982], [-120.64204, 34.89799], [-120.64214, 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.89939], [-120.64411, 34.89945], [-120.64412, 34.90026]]]} | Open Access 1 | Point Sal | http://cosb.countyofsb.org/parks/parks03.aspx?id=13402 | 30308 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 44.401 | Point Sal | |
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 | ||
799 | 799 | 798 | {"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 | Guadalupe Dunes County Park | https://www.countyofsb.org/parks/parks02.aspx?id=13422 | 11773 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 505.538 | Guadalupe Dunes County Park | |
5468 | 5468 | 5467 | {"type": "Polygon", "coordinates": [[[-120.5041, 34.51207], [-120.501, 34.51213], [-120.49956, 34.5122], [-120.49927, 34.5116], [-120.49962, 34.51149], [-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.49989, 34.50973], [-120.50073, 34.50985], [-120.50074, 34.50865], [-120.50101, 34.50799], [-120.5041, 34.51207]]]} | Open Access 1 | Jalama Beach County Park | 20338 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 26.639 | Jalama Beach County Park | ||
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 | ||
9287 | 9287 | 9286 | {"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 | Santa Barbara holding 11 | 25043 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.308 | Santa Barbara holding 11 | ||
6334 | 6334 | 6333 | {"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 | Lompoc Cemetery | 21418 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.518 | Lompoc Cemetery | ||
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 | ||
9391 | 9391 | 9390 | {"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.90175], [-120.43902, 34.89957], [-120.43913, 34.89955], [-120.43913, 34.89863], [-120.4392, 34.89829], [-120.43921, 34.89813], [-120.43919, 34.89613], [-120.4391, 34.8956], [-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 | Waller Park | 27221 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 154.452 | Waller Park | ||
8757 | 8757 | 8756 | {"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.43204, 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.42989, 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.65675], [-120.44007, 34.65751]]]} | Open Access 1 | River Park | 24416 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 123.432 | River Park | ||
438 | 438 | 437 | {"type": "Polygon", "coordinates": [[[-120.42216, 34.84972], [-120.42192, 34.85046], [-120.42153, 34.85093], [-120.42161, 34.85109], [-120.42151, 34.85123], [-120.42113, 34.8513], [-120.42097, 34.852], [-120.4202, 34.85238], [-120.42045, 34.85272], [-120.42027, 34.85283], [-120.41992, 34.85247], [-120.41927, 34.85288], [-120.41925, 34.85304], [-120.41877, 34.85301], [-120.4185, 34.85298], [-120.41851, 34.85295], [-120.41877, 34.85272], [-120.41876, 34.85243], [-120.41873, 34.85237], [-120.41785, 34.85177], [-120.41792, 34.8515], [-120.41769, 34.85134], [-120.41774, 34.85092], [-120.4174, 34.85061], [-120.41773, 34.85046], [-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 | Orcutt Community Park | https://www.countyofsb.org/parks/asset.c/581 | 33496 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 26.029 | Orcutt Community Park | |
10240 | 10240 | 10239 | {"type": "Polygon", "coordinates": [[[-120.4206, 34.85883], [-120.42009, 34.85944], [-120.41983, 34.85913], [-120.41982, 34.85851], [-120.42033, 34.85851], [-120.42034, 34.85866], [-120.4206, 34.85883]]]} | Open Access 1 | Domino Open Space | http://cosb.countyofsb.org/parks/parks03.aspx?id=13428 | 28582 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.162 | Domino OS | |
14307 | 14307 | 14306 | {"type": "Polygon", "coordinates": [[[-120.41847, 34.87892], [-120.41847, 34.87914], [-120.41845, 34.87917], [-120.41794, 34.87923], [-120.41794, 34.87885], [-120.418, 34.87884], [-120.41807, 34.8788], [-120.41847, 34.87892]]]} | No Public Access 3 | Unnamed site - Santa Barbara, County of | 28691 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.465 | |||
9340 | 9340 | 9339 | {"type": "Polygon", "coordinates": [[[-120.30735, 34.60822], [-120.30677, 34.60853], [-120.30678, 34.60893], [-120.3056, 34.60813], [-120.30556, 34.6074], [-120.30189, 34.60528], [-120.30097, 34.60541], [-120.30098, 34.60492], [-120.30091, 34.60467], [-120.30062, 34.60438], [-120.30091, 34.60411], [-120.29992, 34.60337], [-120.29883, 34.60341], [-120.29874, 34.60326], [-120.29916, 34.60305], [-120.30016, 34.60306], [-120.301, 34.60348], [-120.30152, 34.60338], [-120.30129, 34.60386], [-120.30172, 34.60416], [-120.30208, 34.60463], [-120.30257, 34.60484], [-120.30301, 34.60488], [-120.30316, 34.60512], [-120.30339, 34.60529], [-120.30363, 34.60552], [-120.30404, 34.60552], [-120.30465, 34.60545], [-120.30514, 34.60554], [-120.30564, 34.6055], [-120.30565, 34.60574], [-120.306, 34.60603], [-120.30666, 34.60682], [-120.30735, 34.60822]]]} | Open Access 1 | Santa Rosa Park | 25134 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 24.347 | Santa Rosa Park | ||
6384 | 6384 | 6383 | {"type": "Polygon", "coordinates": [[[-120.28032, 34.72943], [-120.27999, 34.73522], [-120.27985, 34.73547], [-120.27962, 34.73577], [-120.27927, 34.73609], [-120.27919, 34.7362], [-120.27913, 34.73638], [-120.27913, 34.73661], [-120.27911, 34.73676], [-120.27899, 34.737], [-120.27896, 34.73714], [-120.27897, 34.73734], [-120.27902, 34.73747], [-120.27907, 34.73756], [-120.27918, 34.73766], [-120.27946, 34.73785], [-120.27655, 34.73782], [-120.27684, 34.73708], [-120.27732, 34.7367], [-120.27772, 34.73627], [-120.27788, 34.7359], [-120.2781, 34.73554], [-120.27827, 34.7354], [-120.27869, 34.73489], [-120.27876, 34.7347], [-120.2786, 34.73459], [-120.27812, 34.7342], [-120.27848, 34.7338], [-120.27922, 34.73374], [-120.27939, 34.73358], [-120.27945, 34.73338], [-120.27947, 34.73311], [-120.27926, 34.73286], [-120.27885, 34.73253], [-120.27534, 34.73122], [-120.27619, 34.73006], [-120.27721, 34.72949], [-120.27919, 34.72923], [-120.28032, 34.72943]]]} | Open Access 1 | Los Alamos Park | 21472 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 49.944 | Los Alamos Park | ||
7409 | 7409 | 7408 | {"type": "Polygon", "coordinates": [[[-120.1819, 34.5326], [-120.18188, 34.5355], [-120.18164, 34.53547], [-120.17751, 34.53436], [-120.17561, 34.53522], [-120.1757, 34.53333], [-120.1755, 34.53184], [-120.17499, 34.53056], [-120.17342, 34.52986], [-120.17345, 34.52719], [-120.17782, 34.5272], [-120.17762, 34.53253], [-120.1819, 34.5326]]]} | Open Access 1 | Nojoqui Falls County Park | 22783 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 83.52 | Nojoqui Falls County Park | ||
3913 | 3913 | 3912 | {"type": "Polygon", "coordinates": [[[-120.14736, 34.60188], [-120.14677, 34.60214], [-120.14634, 34.60186], [-120.1463, 34.60186], [-120.1463, 34.60182], [-120.14633, 34.60183], [-120.14664, 34.6018], [-120.14665, 34.60173], [-120.14672, 34.60171], [-120.14701, 34.60175], [-120.14726, 34.60186], [-120.14736, 34.60188]]]} | Open Access 1 | Hans Christian Andersen Park | 19646 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.567 | Hans Christian Andersen Park | ||
1303 | 1303 | 1302 | {"type": "Polygon", "coordinates": [[[-120.139, 34.47533], [-120.13874, 34.47578], [-120.13834, 34.47593], [-120.13726, 34.47647], [-120.13701, 34.47663], [-120.13575, 34.47664], [-120.13529, 34.4764], [-120.13519, 34.47569], [-120.13353, 34.47565], [-120.13333, 34.47662], [-120.13281, 34.47665], [-120.13211, 34.47987], [-120.13233, 34.4803], [-120.13243, 34.48148], [-120.13257, 34.48377], [-120.13332, 34.48756], [-120.13483, 34.48757], [-120.13523, 34.49414], [-120.12192, 34.49407], [-120.12187, 34.49777], [-120.1298, 34.49773], [-120.12979, 34.50135], [-120.12175, 34.50142], [-120.1217, 34.50899], [-120.11298, 34.50877], [-120.11306, 34.49754], [-120.11776, 34.49756], [-120.11772, 34.49404], [-120.11041, 34.49398], [-120.1106, 34.49106], [-120.10782, 34.48822], [-120.10804, 34.48675], [-120.1078, 34.48532], [-120.10794, 34.48476], [-120.10872, 34.48406], [-120.10652, 34.48118], [-120.10556, 34.48052], [-120.10581, 34.4787], [-120.10635, 34.4787], [-120.10813, 34.47852], [-120.10865, 34.47825], [-120.10941, 34.47801], [-120.11068, 34.47773], [-120.11126, 34.47744], [-120.11182, 34.47746], [-120.11236, 34.47725], [-120.11413, 34.47684], [-120.11422, 34.4757], [-120.11478, 34.47524], [-120.11515, 34.47359], [-120.11537, 34.47273], [-120.1143, 34.47244], [-120.11397, 34.47217], [-120.11481, 34.47098], [-120.11608, 34.47182], [-120.11868, 34.47319], [-120.11934, 34.47326], [-120.1204, 34.47302], [-120.12345, 34.47313], [-120.12319, 34.4745], [-120.12348, 34.47573], [-120.12309, 34.4771], [-120.12311, 34.4772], [-120.12753, 34.47723], [-120.12768, 34.47334], [-120.13109, 34.47379], [-120.13395, 34.4744], [-120.1343, 34.47461], [-120.13512, 34.47472], [-120.13549, 34.47463], [-120.139, 34.47533]]]} | Open Access 1 | Baron Ranch | 15827 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1594.343 | Baron 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]);