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 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER
MNG_AG_TYP 1
MNG_AGENCY 1
- Santa Barbara, County of · 40 ✖
DES_TP 1
- Local Park · 40 ✖
ACCESS_TYP 1
- Open Access 40
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
9921 | 9921 | 9920 | {"type": "Polygon", "coordinates": [[[-120.139, 34.47533], [-120.13874, 34.47578], [-120.13835, 34.47593], [-120.13726, 34.47647], [-120.13701, 34.47663], [-120.13575, 34.47664], [-120.13529, 34.4764], [-120.1352, 34.47569], [-120.13353, 34.47565], [-120.13333, 34.47662], [-120.13281, 34.47665], [-120.13211, 34.47987], [-120.13233, 34.4803], [-120.13242, 34.48148], [-120.13257, 34.48377], [-120.13332, 34.48757], [-120.13483, 34.48757], [-120.13523, 34.49414], [-120.12191, 34.49406], [-120.12186, 34.49777], [-120.1298, 34.49773], [-120.12979, 34.50135], [-120.12174, 34.50142], [-120.1217, 34.50899], [-120.11298, 34.50877], [-120.11306, 34.49754], [-120.11776, 34.49756], [-120.11772, 34.49403], [-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.48407], [-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.11414, 34.47684], [-120.11422, 34.4757], [-120.11478, 34.47524], [-120.11515, 34.47359], [-120.11537, 34.47272], [-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.12039, 34.47302], [-120.12345, 34.47313], [-120.12319, 34.4745], [-120.12348, 34.47573], [-120.12308, 34.4771], [-120.1231, 34.4772], [-120.12753, 34.47724], [-120.12768, 34.47334], [-120.13109, 34.47379], [-120.13395, 34.4744], [-120.13429, 34.47461], [-120.13512, 34.47472], [-120.13549, 34.47463], [-120.139, 34.47533]]]} | Open Access 1 | 17083 | Baron Ranch | 15827 | 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 | 1593.936 | Baron Ranch | 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 | |
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 | |
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 |
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 | |
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 | |
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 | |
9965 | 9965 | 9964 | {"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.83441, 34.45314], [-119.83465, 34.45311], [-119.8348, 34.45306]]], [[[-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.83461, 34.45187], [-119.83496, 34.45206], [-119.83491, 34.45218], [-119.83488, 34.45234], [-119.83492, 34.4525], [-119.83504, 34.45277], [-119.83504, 34.45279], [-119.83502, 34.45281]]], [[[-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 | 17138 | La Goleta Park | 20757 | 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 | 6.108 | La Goleta Park | 0 | Local Park 2 | 4 | |
2465 | 2465 | 2464 | {"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.60257, 34.42054], [-119.60186, 34.42055], [-119.60192, 34.42063], [-119.60149, 34.42059], [-119.6015, 34.42054], [-119.60119, 34.42046], [-119.60115, 34.42057], [-119.60107, 34.42054], [-119.6011, 34.42044], [-119.60054, 34.42031], [-119.60027, 34.41974], [-119.59999, 34.41968], [-119.6, 34.4196], [-119.59979, 34.41952], [-119.5994, 34.41953], [-119.59921, 34.41946], [-119.5993, 34.41913], [-119.60007, 34.41924], [-119.60003, 34.4195], [-119.60215, 34.41991], [-119.60216, 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 | 17402 | Lookout Park and Beach | 21461 | 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 | 6.582 | Lookout Park and Beach | 0 | Local Park 2 | 4 | |
2133 | 2133 | 2132 | {"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.73748], [-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.27877, 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 | 17411 | Los Alamos Park | 21472 | 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 | 49.94 | Los Alamos Park | 0 | Local Park 2 | 4 | |
2498 | 2498 | 2497 | {"type": "MultiPolygon", "coordinates": [[[[-119.63205, 34.43527], [-119.631, 34.43526], [-119.63141, 34.43312], [-119.63141, 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.63336, 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 | 17533 | Manning Park | 21754 | 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 | 11.812 | Manning Park | 0 | Local Park 2 | 4 | |
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 | |
12077 | 12077 | 12076 | {"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]]]]} | Open Access 1 | 24847 | 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 | 1.082 | Miguelito 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 | |
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 | |
10288 | 10288 | 10287 | {"type": "Polygon", "coordinates": [[[-119.59152, 34.42005], [-119.5914, 34.42049], [-119.59123, 34.42047], [-119.59109, 34.42098], [-119.59149, 34.42106], [-119.59139, 34.42142], [-119.59146, 34.42144], [-119.59133, 34.42188], [-119.59085, 34.42179], [-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 | 18250 | Ocean View Park | 23057 | 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 | 8.037 | Ocean View Park | 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]);