units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where DES_TP = 2 and MNG_AGENCY = 7
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Santa Barbara, County of · 28 ✖
DES_TP 1
- Local Park · 28 ✖
ACCESS_TYP 1
- Open Access 28
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2653 | 2653 | 2652 | {"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.53254], [-120.1819, 34.5326]]]} | Open Access 1 | 18125 | Nojoqui Falls County Park | 22783 | 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 | 83.478 | Nojoqui Falls County Park | 0 | Local Park 2 | 4 | |
2687 | 2687 | 2686 | {"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 | 18238 | Ocean Beach Park | 23051 | 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 | 38.919 | Ocean Beach Park | 0 | Local Park 2 | 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 |
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 | |
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 | |
5778 | 5778 | 5777 | {"type": "MultiPolygon", "coordinates": [[[[-119.68465, 34.9461], [-119.68467, 34.9462], [-119.68476, 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.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.9442], [-119.68175, 34.94419], [-119.67961, 34.942], [-119.68031, 34.942], [-119.68109, 34.94277], [-119.68079, 34.94299], [-119.68079, 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.68382, 34.94527], [-119.68465, 34.9461]]], [[[-119.68606, 34.94635], [-119.68613, 34.94636], [-119.68619, 34.9464], [-119.68623, 34.94646], [-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]]]]} | Open Access 1 | 33 | Richardson County Park | 24331 | 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 | 15.665 | Richardson County Park | 0 | Local Park 2 | 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 | |
5828 | 5828 | 5827 | {"type": "Polygon", "coordinates": [[[-119.71329, 34.44128], [-119.71313, 34.44136], [-119.71295, 34.44147], [-119.71282, 34.44151], [-119.71266, 34.44153], [-119.71245, 34.44158], [-119.71245, 34.44287], [-119.71164, 34.44308], [-119.71164, 34.4437], [-119.71066, 34.44371], [-119.71066, 34.44653], [-119.71063, 34.44653], [-119.7105, 34.44672], [-119.71016, 34.44668], [-119.71007, 34.4467], [-119.71016, 34.44658], [-119.71031, 34.44611], [-119.71034, 34.44557], [-119.70985, 34.44546], [-119.71031, 34.44459], [-119.70909, 34.44465], [-119.70909, 34.44366], [-119.70929, 34.44354], [-119.70944, 34.44331], [-119.7096, 34.4432], [-119.70973, 34.44302], [-119.70994, 34.44291], [-119.71007, 34.44279], [-119.71024, 34.44249], [-119.71044, 34.44241], [-119.71062, 34.44227], [-119.71067, 34.4423], [-119.71086, 34.44233], [-119.71111, 34.44215], [-119.71177, 34.44203], [-119.71206, 34.44137], [-119.71215, 34.4408], [-119.71243, 34.44063], [-119.71244, 34.44033], [-119.7126, 34.44032], [-119.7126, 34.44071], [-119.71329, 34.44128]], [[-119.71065, 34.4436], [-119.71066, 34.44319], [-119.71046, 34.44304], [-119.70999, 34.44353], [-119.71, 34.4436], [-119.71065, 34.4436]]]} | Open Access 1 | 142 | Rocky Nook Park | 24542 | 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 | 16.986 | Rocky Nook Park | 0 | Local Park 2 | 4 | |
6017 | 6017 | 6016 | {"type": "Polygon", "coordinates": [[[-119.86649, 34.40896], [-119.86649, 34.40971], [-119.86582, 34.40971], [-119.86582, 34.40896], [-119.86649, 34.40896]]]} | Open Access 1 | 696 | Sea Lookout Park | 25234 | 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.288 | Sea Lookout Park | 0 | Local Park 2 | 4 | |
6131 | 6131 | 6130 | {"type": "MultiPolygon", "coordinates": [[[[-119.8405, 34.44897], [-119.84028, 34.44897], [-119.84023, 34.44897], [-119.84042, 34.44887], [-119.8405, 34.44897]]], [[[-119.84221, 34.45083], [-119.84133, 34.45085], [-119.84133, 34.45014], [-119.84133, 34.45014], [-119.84221, 34.45083]]]]} | Open Access 1 | 1119 | Stonebridge Park | 25879 | 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.819 | Stonebridge Park | 0 | Local Park 2 | 4 | |
6302 | 6302 | 6301 | {"type": "MultiPolygon", "coordinates": [[[[-119.77498, 34.46477], [-119.77385, 34.46839], [-119.7732, 34.46839], [-119.7732, 34.46911], [-119.77251, 34.46862], [-119.77253, 34.4683], [-119.77206, 34.46758], [-119.77217, 34.46752], [-119.77276, 34.46791], [-119.77295, 34.46775], [-119.77232, 34.46728], [-119.77183, 34.46712], [-119.77177, 34.46676], [-119.77187, 34.46645], [-119.77169, 34.46605], [-119.77173, 34.46528], [-119.7717, 34.46476], [-119.77498, 34.46477]]], [[[-119.79223, 34.45174], [-119.79173, 34.45211], [-119.79155, 34.45239], [-119.79156, 34.45359], [-119.78801, 34.45358], [-119.78801, 34.45266], [-119.78748, 34.45287], [-119.78717, 34.4529], [-119.78634, 34.45255], [-119.78598, 34.45255], [-119.78535, 34.4528], [-119.78534, 34.45312], [-119.78542, 34.45332], [-119.78467, 34.45356], [-119.78361, 34.45418], [-119.78415, 34.45508], [-119.7842, 34.4555], [-119.78334, 34.45629], [-119.78311, 34.4564], [-119.78266, 34.45669], [-119.78256, 34.45746], [-119.78194, 34.45821], [-119.78088, 34.45805], [-119.78023, 34.45787], [-119.77977, 34.45846], [-119.77982, 34.45869], [-119.77911, 34.4591], [-119.77894, 34.45964], [-119.77866, 34.46029], [-119.77817, 34.46051], [-119.7779, 34.46108], [-119.77607, 34.4611], [-119.77626, 34.46179], [-119.77563, 34.46273], [-119.77529, 34.46339], [-119.77525, 34.46378], [-119.7736, 34.46379], [-119.77361, 34.46204], [-119.77403, 34.46191], [-119.77527, 34.46129], [-119.77528, 34.46109], [-119.77689, 34.46017], [-119.77698, 34.45946], [-119.77737, 34.45886], [-119.77807, 34.45828], [-119.77827, 34.458], [-119.7784, 34.45778], [-119.77877, 34.45691], [-119.77871, 34.45682], [-119.77868, 34.45673], [-119.77881, 34.45668], [-119.77931, 34.45642], [-119.77997, 34.45631], [-119.7799, 34.45591], [-119.78001, 34.45558], [-119.78025, 34.45532], [-119.78111, 34.4551], [-119.78262, 34.45501], [-119.78226, 34.45446], [-119.78221, 34.45401], [-119.78235, 34.45374], [-119.78277, 34.45323], [-119.78296, 34.45324], [-119.7834, 34.45314], [-119.78403, 34.45269], [-119.78538, 34.45218], [-119.78598, 34.45216], [-119.78802, 34.45231], [-119.78803, 34.45225], [-119.78817, 34.4522], [-119.78839, 34.45202], [-119.78885, 34.45196], [-119.78908, 34.45179], [-119.78916, 34.45158], [-119.78939, 34.45148], [-119.78985, 34.45147], [-119.79014, 34.45164], [-119.79023, 34.45147], [-119.79094, 34.45169], [-119.79135, 34.45177], [-119.79223, 34.45174]]]]} | Open Access 1 | 1434 | Tuckers Grove Park | 26558 | 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 | 111.447 | Tuckers Grove Park | 0 | Local Park 2 | 4 | |
7640 | 7640 | 7639 | {"type": "Polygon", "coordinates": [[[-119.49018, 34.38353], [-119.48938, 34.38524], [-119.48884, 34.38506], [-119.48848, 34.3849], [-119.48734, 34.38447], [-119.48698, 34.3843], [-119.48681, 34.38419], [-119.4865, 34.38393], [-119.48637, 34.38378], [-119.48607, 34.38336], [-119.48592, 34.38322], [-119.48576, 34.38309], [-119.48558, 34.38297], [-119.48538, 34.38288], [-119.48517, 34.38281], [-119.4849, 34.38276], [-119.48494, 34.3819], [-119.48505, 34.38194], [-119.48533, 34.38197], [-119.48547, 34.38191], [-119.48584, 34.38197], [-119.48585, 34.38181], [-119.48869, 34.38297], [-119.48873, 34.38294], [-119.49018, 34.38353]]]} | Open Access 1 | 48965 | Rincon Beach Park | 24367 | 3033 | Land Trust for Santa Barbara County 269 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sblandtrust.org | Non Governmental Organization 10 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 21.667 | Rincon Beach Park | 0 | Local Park 2 | 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 | |
8900 | 8900 | 8899 | {"type": "Polygon", "coordinates": [[[-119.87867, 34.42332], [-119.87847, 34.42368], [-119.87808, 34.42365], [-119.87803, 34.42368], [-119.87799, 34.42375], [-119.878, 34.42402], [-119.87795, 34.42403], [-119.87793, 34.42372], [-119.87812, 34.42327], [-119.87829, 34.42335], [-119.87847, 34.42349], [-119.87865, 34.42326], [-119.87867, 34.42332]]]} | Open Access 1 | 14564 | Armstrong Mini Park | 15594 | 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.463 | Armstrong MP | 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 | |
9300 | 9300 | 9299 | {"type": "Polygon", "coordinates": [[[-119.74515, 34.40323], [-119.74476, 34.40436], [-119.74399, 34.40382], [-119.7439, 34.40379], [-119.74377, 34.4038], [-119.74365, 34.40385], [-119.74357, 34.40392], [-119.74349, 34.4035], [-119.74345, 34.40311], [-119.74339, 34.40313], [-119.74343, 34.40351], [-119.74352, 34.40399], [-119.74332, 34.40425], [-119.74318, 34.40435], [-119.74305, 34.40439], [-119.74231, 34.40436], [-119.74274, 34.40423], [-119.74327, 34.40268], [-119.74515, 34.40323]]]} | Open Access 1 | 15495 | Arroyo Burro Beach County Park | 15610 | 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.986 | Arroyo Burro Beach County Park | 0 | Local Park 2 | 4 | |
9756 | 9756 | 9755 | {"type": "Polygon", "coordinates": [[[-119.83596, 34.41586], [-119.8358, 34.41596], [-119.83468, 34.41644], [-119.83424, 34.41646], [-119.83272, 34.4173], [-119.83189, 34.41727], [-119.83151, 34.41736], [-119.83148, 34.41725], [-119.83159, 34.4172], [-119.83158, 34.41718], [-119.83094, 34.41734], [-119.83095, 34.41736], [-119.83107, 34.41736], [-119.83111, 34.41744], [-119.83068, 34.41755], [-119.83001, 34.41757], [-119.8288, 34.41714], [-119.82795, 34.41727], [-119.82739, 34.41713], [-119.82659, 34.41729], [-119.82647, 34.41689], [-119.82442, 34.4168], [-119.82137, 34.41633], [-119.82037, 34.41636], [-119.81918, 34.41647], [-119.81924, 34.41601], [-119.82586, 34.41634], [-119.82882, 34.41633], [-119.83086, 34.41618], [-119.83315, 34.41578], [-119.83569, 34.41509], [-119.83596, 34.41586]]]} | Open Access 1 | 16598 | Goleta Beach County Park | 19379 | 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 | 33.143 | Goleta Beach County Park | 0 | Local Park 2 | 4 | |
9791 | 9791 | 9790 | {"type": "Polygon", "coordinates": [[[-120.14736, 34.60188], [-120.14677, 34.60214], [-120.14633, 34.60186], [-120.1463, 34.60186], [-120.1463, 34.60182], [-120.14633, 34.60183], [-120.14665, 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 | 16735 | Hans Christian Andersen Park | 19646 | 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.566 | Hans Christian Andersen Park | 0 | Local Park 2 | 4 | |
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 |
9804 | 9804 | 9803 | {"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 | 18096 | Nectarine Mini Park | 22682 | 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.13 | Nectarine MP | 0 | Local Park 2 | 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]);