superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
89 rows where MNG_AGENCY = 7 sorted by ACCESS_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4647 | 4647 | 4646 | {"type": "MultiPolygon", "coordinates": [[[[-119.78067, 34.4404], [-119.78035, 34.4404], [-119.78034, 34.44016], [-119.78067, 34.44016], [-119.78067, 34.4404]]], [[[-119.78168, 34.43949], [-119.78168, 34.4396], [-119.78068, 34.4396], [-119.78068, 34.43949], [-119.78168, 34.43949]]]]} | Open Access 1 | Goleta Cemetery | 19380 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.486 | Goleta Cemetery | ||
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 | ||
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 | ||
5809 | 5809 | 5808 | {"type": "MultiPolygon", "coordinates": [[[[-119.8348, 34.45306], [-119.83472, 34.45336], [-119.83473, 34.45393], [-119.83358, 34.45393], [-119.83346, 34.45366], [-119.83327, 34.45366], [-119.83316, 34.45389], [-119.83241, 34.45389], [-119.83209, 34.45412], [-119.83206, 34.45426], [-119.8319, 34.45426], [-119.83184, 34.45381], [-119.83212, 34.45376], [-119.83261, 34.45358], [-119.83287, 34.45353], [-119.83313, 34.45353], [-119.83355, 34.4536], [-119.83367, 34.45359], [-119.83379, 34.45357], [-119.83391, 34.45352], [-119.83401, 34.45346], [-119.83426, 34.45322], [-119.83432, 34.45318], [-119.83442, 34.45314], [-119.83465, 34.45311], [-119.8348, 34.45306]]], [[[-119.83504, 34.45277], [-119.83504, 34.45279], [-119.83502, 34.45281], [-119.83464, 34.45297], [-119.83442, 34.45301], [-119.83435, 34.45301], [-119.83432, 34.45299], [-119.83419, 34.45248], [-119.83415, 34.45237], [-119.83409, 34.45227], [-119.83398, 34.45214], [-119.83388, 34.45207], [-119.83372, 34.452], [-119.83358, 34.45198], [-119.83366, 34.45161], [-119.83475, 34.45158], [-119.83462, 34.45187], [-119.83496, 34.45206], [-119.83491, 34.45218], [-119.83488, 34.45234], [-119.83492, 34.4525], [-119.83504, 34.45277]]], [[[-119.83411, 34.45306], [-119.83392, 34.45326], [-119.83383, 34.45332], [-119.83372, 34.45336], [-119.8337, 34.45333], [-119.83385, 34.45324], [-119.83397, 34.45312], [-119.83407, 34.45305], [-119.83409, 34.45301], [-119.83411, 34.45306]]]]} | Open Access 1 | La Goleta Park | 20757 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 6.114 | La Goleta Park | ||
5940 | 5940 | 5939 | {"type": "Polygon", "coordinates": [[[-119.85366, 34.44306], [-119.85277, 34.44347], [-119.85337, 34.44455], [-119.8527, 34.44481], [-119.84965, 34.4455], [-119.84954, 34.44511], [-119.84907, 34.44512], [-119.8486, 34.44517], [-119.84766, 34.44503], [-119.8476, 34.4451], [-119.84732, 34.44499], [-119.84702, 34.44491], [-119.84672, 34.44486], [-119.84642, 34.44483], [-119.84611, 34.44482], [-119.84581, 34.44485], [-119.84551, 34.4449], [-119.84502, 34.44504], [-119.84435, 34.44329], [-119.84429, 34.443], [-119.84425, 34.44272], [-119.84423, 34.44243], [-119.84423, 34.44189], [-119.84417, 34.44156], [-119.84321, 34.44012], [-119.84296, 34.4393], [-119.84304, 34.4392], [-119.84742, 34.43854], [-119.84918, 34.43857], [-119.84948, 34.43861], [-119.84978, 34.43869], [-119.85005, 34.43883], [-119.85018, 34.43891], [-119.85041, 34.43912], [-119.85121, 34.4401], [-119.85133, 34.44022], [-119.85148, 34.44031], [-119.85164, 34.44038], [-119.85184, 34.44042], [-119.85204, 34.44044], [-119.85207, 34.44067], [-119.8523, 34.44083], [-119.85269, 34.4408], [-119.85279, 34.44126], [-119.85293, 34.44172], [-119.85303, 34.442], [-119.85315, 34.44223], [-119.85339, 34.44266], [-119.85366, 34.44306]]]} | Open Access 1 | Lake Los Carneros Natural and Historical Preserve | 20949 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 133.561 | Lake Los Carneros Natural and Historical Preserve | ||
6245 | 6245 | 6244 | {"type": "Polygon", "coordinates": [[[-119.82652, 34.43735], [-119.82651, 34.43749], [-119.82615, 34.43748], [-119.82615, 34.43734], [-119.82652, 34.43735]]]} | Open Access 1 | Nectarine Mini Park | 22682 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.13 | Nectarine MP | ||
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 | ||
6370 | 6370 | 6369 | {"type": "Polygon", "coordinates": [[[-119.60451, 34.42018], [-119.60401, 34.42022], [-119.60381, 34.42025], [-119.6035, 34.42034], [-119.60326, 34.42037], [-119.60294, 34.42044], [-119.60259, 34.42056], [-119.60256, 34.42054], [-119.60188, 34.42055], [-119.60187, 34.42057], [-119.60192, 34.42063], [-119.60149, 34.42059], [-119.60149, 34.42053], [-119.6012, 34.42046], [-119.60115, 34.42057], [-119.60107, 34.42054], [-119.60109, 34.42044], [-119.60054, 34.42031], [-119.60026, 34.41974], [-119.59999, 34.41968], [-119.59999, 34.4196], [-119.59979, 34.41952], [-119.5994, 34.41953], [-119.59921, 34.41946], [-119.5993, 34.41913], [-119.60007, 34.41924], [-119.60004, 34.4195], [-119.60215, 34.41991], [-119.60217, 34.42013], [-119.60228, 34.42012], [-119.60228, 34.41991], [-119.60362, 34.41996], [-119.60381, 34.41998], [-119.60451, 34.41995], [-119.60451, 34.42018]]]} | Open Access 1 | Lookout Park and Beach | 21461 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 6.594 | Lookout Park and Beach | ||
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 | ||
6585 | 6585 | 6584 | {"type": "MultiPolygon", "coordinates": [[[[-119.63205, 34.43527], [-119.631, 34.43526], [-119.63141, 34.43312], [-119.6314, 34.43311], [-119.63134, 34.4331], [-119.63134, 34.43283], [-119.63179, 34.43283], [-119.6318, 34.43303], [-119.63183, 34.43323], [-119.63201, 34.43386], [-119.63205, 34.43527]]], [[[-119.63427, 34.43281], [-119.63426, 34.43526], [-119.63224, 34.43526], [-119.63225, 34.43427], [-119.63335, 34.43427], [-119.63339, 34.43368], [-119.63328, 34.43339], [-119.63369, 34.43334], [-119.63417, 34.43334], [-119.63418, 34.43281], [-119.63427, 34.43281]]]]} | Open Access 1 | Manning Park | 21754 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 11.82 | Manning Park | ||
6978 | 6978 | 6977 | {"type": "MultiPolygon", "coordinates": [[[[-120.46427, 34.59959], [-120.46406, 34.60047], [-120.46387, 34.60048], [-120.46389, 34.60024], [-120.46393, 34.60008], [-120.46404, 34.59976], [-120.46412, 34.59961], [-120.46427, 34.59959]]], [[[-120.46586, 34.59723], [-120.46532, 34.59812], [-120.46507, 34.59806], [-120.46561, 34.59718], [-120.46586, 34.59723]]], [[[-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 | Miguelito County Park | 22211 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 6.448 | Miguelito County 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 | ||
7615 | 7615 | 7614 | {"type": "MultiPolygon", "coordinates": [[[[-120.60154, 34.69034], [-120.60044, 34.69224], [-120.59668, 34.69152], [-120.59741, 34.68786], [-120.60038, 34.68829], [-120.60154, 34.69034]]], [[[-120.60536, 34.68376], [-120.60493, 34.6845], [-120.60463, 34.68438], [-120.60507, 34.68364], [-120.60536, 34.68376]]]]} | Open Access 1 | Ocean Beach Park | 23051 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 38.917 | Ocean Beach Park | ||
7623 | 7623 | 7622 | {"type": "Polygon", "coordinates": [[[-119.59152, 34.42005], [-119.5914, 34.42049], [-119.59123, 34.42048], [-119.59109, 34.42097], [-119.59149, 34.42106], [-119.59139, 34.42141], [-119.59146, 34.42144], [-119.59133, 34.42188], [-119.59085, 34.4218], [-119.59074, 34.42219], [-119.58939, 34.42193], [-119.58987, 34.42067], [-119.5899, 34.42066], [-119.59047, 34.41985], [-119.59152, 34.42005]]]} | Open Access 1 | Ocean View Park | 23057 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 8.046 | Ocean View Park | ||
7758 | 7758 | 7757 | {"type": "MultiPolygon", "coordinates": [[[[-119.82397, 34.45496], [-119.82392, 34.45498], [-119.82394, 34.45538], [-119.82378, 34.45558], [-119.82369, 34.45581], [-119.82347, 34.45604], [-119.82351, 34.45614], [-119.82364, 34.45625], [-119.82374, 34.45636], [-119.82376, 34.45652], [-119.82369, 34.45676], [-119.82367, 34.45697], [-119.82357, 34.45723], [-119.82346, 34.45737], [-119.82369, 34.45756], [-119.82344, 34.45767], [-119.82325, 34.4581], [-119.82325, 34.45838], [-119.82322, 34.45844], [-119.82309, 34.45845], [-119.82311, 34.45784], [-119.82326, 34.45725], [-119.82355, 34.45682], [-119.82331, 34.45625], [-119.82331, 34.45601], [-119.8239, 34.45464], [-119.82388, 34.4536], [-119.82323, 34.45372], [-119.82271, 34.45436], [-119.82251, 34.45444], [-119.82248, 34.45482], [-119.82173, 34.455], [-119.82111, 34.45499], [-119.82099, 34.455], [-119.82099, 34.45492], [-119.82177, 34.45493], [-119.82216, 34.45444], [-119.82242, 34.45432], [-119.8226, 34.45383], [-119.82286, 34.4536], [-119.82319, 34.45339], [-119.82365, 34.45304], [-119.82395, 34.45304], [-119.82397, 34.45496]]], [[[-119.82218, 34.45596], [-119.82169, 34.45592], [-119.82106, 34.45592], [-119.82106, 34.45542], [-119.82103, 34.45521], [-119.82103, 34.45517], [-119.82106, 34.45515], [-119.82112, 34.45514], [-119.82174, 34.45515], [-119.82207, 34.45508], [-119.82215, 34.45529], [-119.82218, 34.45596]]]]} | Open Access 1 | Oro Verde Park | 23208 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 7.481 | Oro Verde Park | ||
7917 | 7917 | 7916 | {"type": "Polygon", "coordinates": [[[-119.52661, 34.41577], [-119.52628, 34.41577], [-119.52622, 34.41481], [-119.52623, 34.41435], [-119.5263, 34.41401], [-119.52657, 34.41394], [-119.52646, 34.41475], [-119.52646, 34.41518], [-119.52661, 34.41577]]]} | Open Access 1 | Santa Monica Creek | 25116 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.173 | Santa Monica Creek | ||
8068 | 8068 | 8067 | {"type": "Polygon", "coordinates": [[[-119.85595, 34.4093], [-119.85537, 34.40921], [-119.85537, 34.40853], [-119.85595, 34.40862], [-119.85595, 34.4093]]]} | Open Access 1 | Pelican Park | 23568 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.002 | Pelican Park | ||
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 | ||
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 | ||
8674 | 8674 | 8673 | {"type": "MultiPolygon", "coordinates": [[[[-119.68559, 34.94647], [-119.68554, 34.94654], [-119.68549, 34.94659], [-119.6854, 34.94662], [-119.68533, 34.94663], [-119.68495, 34.94653], [-119.6826, 34.94613], [-119.68251, 34.94609], [-119.68247, 34.94604], [-119.68244, 34.94597], [-119.68247, 34.94518], [-119.68244, 34.94507], [-119.68239, 34.94497], [-119.68169, 34.94424], [-119.68175, 34.94421], [-119.68175, 34.94419], [-119.67961, 34.942], [-119.68031, 34.942], [-119.68109, 34.94277], [-119.6808, 34.94298], [-119.6808, 34.943], [-119.68093, 34.94308], [-119.68118, 34.9429], [-119.68197, 34.94366], [-119.68211, 34.94375], [-119.68223, 34.94381], [-119.6824, 34.94387], [-119.68252, 34.94389], [-119.68346, 34.94392], [-119.68416, 34.94401], [-119.68383, 34.94527], [-119.68465, 34.9461], [-119.68467, 34.9462], [-119.68475, 34.94628], [-119.68484, 34.94629], [-119.68493, 34.94626], [-119.68498, 34.94626], [-119.68555, 34.9464], [-119.68558, 34.94642], [-119.68559, 34.94647]]], [[[-119.68623, 34.94653], [-119.68609, 34.94679], [-119.68602, 34.94683], [-119.68596, 34.94683], [-119.6859, 34.94681], [-119.68585, 34.94676], [-119.68583, 34.94666], [-119.68595, 34.94641], [-119.686, 34.94637], [-119.68606, 34.94635], [-119.68612, 34.94636], [-119.68619, 34.9464], [-119.68622, 34.94646], [-119.68623, 34.94653]]]]} | Open Access 1 | Richardson County Park | 24331 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 15.672 | Richardson County 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]);