units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
204 rows where ACCESS_TYP = 4 and DES_TP = 14 sorted by LAYER
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, COUNTY
MNG_AGENCY 19
- Mountains Recreation and Conservation Authority 118
- Yuba County Water Agency 48
- Santa Barbara, City of 9
- Santa Barbara, County of 8
- Santa Barbara Flood Control and Water Conserv. District 4
- Los Angeles, City of 2
- Carpinteria, City of 2
- Ramona Municipal Water District 2
- San Diego, County of 1
- Clovis, City of 1
- Guadalupe, City of 1
- Sacramento, County of 1
- Rio Dell, City of 1
- Sacramento and San Joaquin Drainage District 1
- Orange County Water District 1
- Helix Water District 1
- Santa Ynez River Water Conservation District 1
- Western Riverside County Regional Conservation Authority 1
- North County Transit District 1
MNG_AG_TYP 6
DES_TP 1
- Local Other or Unknown · 204 ✖
ACCESS_TYP 1
- Unknown Access · 204 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
185 | 185 | 184 | {"type": "Polygon", "coordinates": [[[-119.52773, 34.40703], [-119.52713, 34.40837], [-119.52698, 34.40879], [-119.52686, 34.40923], [-119.52678, 34.40968], [-119.52672, 34.40966], [-119.52675, 34.4094], [-119.52682, 34.40907], [-119.52689, 34.40883], [-119.52701, 34.40848], [-119.52766, 34.40701], [-119.52773, 34.40703]]]} | Unknown Access 4 | 592 | Santa Monica Creek | 25117 | 1047 | Carpinteria, City of 72 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | Santa Barbara 7 | 0.489 | Santa Monica Creek | 0 | Local Other or Unknown 14 | 4 | |
364 | 364 | 363 | {"type": "Polygon", "coordinates": [[[-119.67342, 34.42333], [-119.67318, 34.42356], [-119.67274, 34.42324], [-119.67299, 34.42301], [-119.67342, 34.42333]]]} | Unknown Access 4 | 1276 | Sycamore Creek | 26121 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 0.446 | Sycamore Creek | 0 | Local Other or Unknown 14 | 4 | |
1412 | 1412 | 1411 | {"type": "Polygon", "coordinates": [[[-119.67034, 34.43903], [-119.67034, 34.4395], [-119.66917, 34.4395], [-119.66941, 34.43903], [-119.67034, 34.43903]]]} | Unknown Access 4 | 36486 | Santa Barbara holding 9 | 25051 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 1.234 | Santa Barbara holding 9 | 0 | Local Other or Unknown 14 | 4 | |
3896 | 3896 | 3895 | {"type": "Polygon", "coordinates": [[[-118.57142, 34.12782], [-118.57142, 34.12931], [-118.56528, 34.12931], [-118.5662, 34.12783], [-118.57142, 34.12782]]]} | Unknown Access 4 | 45829 | Steers Property | 28848 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 21.351 | Steers Property | 0 | Local Other or Unknown 14 | 4 | |
4718 | 4718 | 4717 | {"type": "Polygon", "coordinates": [[[-118.28418, 34.23377], [-118.28386, 34.23376], [-118.28045, 34.23393], [-118.27981, 34.23393], [-118.27976, 34.22908], [-118.27539, 34.22911], [-118.27538, 34.22816], [-118.28411, 34.2281], [-118.28418, 34.23377]]]} | Unknown Access 4 | 46522 | Unnamed site - Los Angeles, City of | 29809 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 73.646 | 0 | Local Other or Unknown 14 | 4 | ||
4769 | 4769 | 4768 | {"type": "Polygon", "coordinates": [[[-124.10344, 40.4928], [-124.10326, 40.49301], [-124.10325, 40.49313], [-124.10297, 40.49314], [-124.10296, 40.49296], [-124.103, 40.49297], [-124.10313, 40.4928], [-124.10344, 40.4928]]]} | Unknown Access 4 | 46929 | Unnamed site - Rio Dell, City of | 30545 | 1435 | Rio Dell, City of 642 | City 2 | City Agency 2 | http://www.riodellcity.com/ | City 2 | 1435 | Rio Dell, City of 632 | City 2 | City Agency 2 | Humboldt 45 | 0.236 | 0 | Local Other or Unknown 14 | 4 | ||
4946 | 4946 | 4945 | {"type": "Polygon", "coordinates": [[[-119.7272, 34.4336], [-119.72698, 34.43445], [-119.72664, 34.43545], [-119.72639, 34.43526], [-119.72657, 34.43483], [-119.72679, 34.43462], [-119.72695, 34.43445], [-119.72702, 34.43416], [-119.72681, 34.43413], [-119.72683, 34.43397], [-119.72706, 34.43399], [-119.72716, 34.43359], [-119.7272, 34.4336]]]} | Unknown Access 4 | 14659 | El Mission Creek | 18514 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 0.719 | El Mission Creek | 0 | Local Other or Unknown 14 | 4 | |
5005 | 5005 | 5004 | {"type": "Polygon", "coordinates": [[[-119.70199, 36.84945], [-119.70166, 36.8492], [-119.6998, 36.84806], [-119.69973, 36.84801], [-119.69944, 36.8476], [-119.69939, 36.84721], [-119.69943, 36.84702], [-119.69958, 36.84682], [-119.70058, 36.84598], [-119.70076, 36.8457], [-119.70083, 36.84536], [-119.7008, 36.84483], [-119.70149, 36.84483], [-119.70172, 36.84527], [-119.70192, 36.84589], [-119.70196, 36.8461], [-119.702, 36.84659], [-119.70199, 36.84693], [-119.70201, 36.848], [-119.70199, 36.84945]]]} | Unknown Access 4 | 17221 | Dry Creek | 18278 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 17.89 | Dry Creek | 0 | Local Other or Unknown 14 | 4 | |
6601 | 6601 | 6600 | {"type": "MultiPolygon", "coordinates": [[[[-119.50722, 34.39559], [-119.50661, 34.3957], [-119.50574, 34.39635], [-119.5055, 34.39636], [-119.50526, 34.39632], [-119.50526, 34.39623], [-119.50539, 34.39622], [-119.50563, 34.39619], [-119.50586, 34.39611], [-119.50597, 34.39606], [-119.50676, 34.39552], [-119.50722, 34.39559]]], [[[-119.51198, 34.39382], [-119.51152, 34.39386], [-119.51141, 34.39389], [-119.51064, 34.3943], [-119.51039, 34.39448], [-119.51014, 34.39416], [-119.51121, 34.39348], [-119.51144, 34.3934], [-119.51198, 34.39382]]]]} | Unknown Access 4 | 4238 | Carpinteria Creek | 16897 | 1047 | Carpinteria, City of 72 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | Santa Barbara 7 | 2.293 | Carpinteria Creek | 0 | Local Other or Unknown 14 | 4 | |
12995 | 12995 | 12994 | {"type": "Polygon", "coordinates": [[[-119.69167, 34.45419], [-119.69138, 34.45435], [-119.691, 34.45433], [-119.69056, 34.45403], [-119.69059, 34.45371], [-119.69063, 34.45361], [-119.69071, 34.45352], [-119.69083, 34.45346], [-119.6913, 34.45343], [-119.69167, 34.45419]]]} | Unknown Access 4 | 35356 | Santa Barbara holding 1 | 25042 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 1.835 | Santa Barbara holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13234 | 13234 | 13233 | {"type": "Polygon", "coordinates": [[[-120.57752, 34.96378], [-120.57752, 34.96399], [-120.57714, 34.96399], [-120.57714, 34.96377], [-120.57752, 34.96378]]]} | Unknown Access 4 | 35278 | Guadalupe holding 9 | 19554 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.206 | Guadalupe holding 9 | 0 | Local Other or Unknown 14 | 4 | ||
13328 | 13328 | 13327 | {"type": "Polygon", "coordinates": [[[-119.7227, 34.41018], [-119.72259, 34.41048], [-119.72256, 34.4105], [-119.72219, 34.41042], [-119.72232, 34.41009], [-119.7227, 34.41018]]]} | Unknown Access 4 | 35396 | Santa Barbara holding 2 | 25044 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 0.342 | Santa Barbara holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13943 | 13943 | 13942 | {"type": "Polygon", "coordinates": [[[-119.67454, 34.43385], [-119.6741, 34.43428], [-119.67275, 34.43326], [-119.67318, 34.43286], [-119.67454, 34.43385]]]} | Unknown Access 4 | 36569 | Santa Barbara holding 8 | 25050 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 2.52 | Santa Barbara holding 8 | 0 | Local Other or Unknown 14 | 4 | |
13944 | 13944 | 13943 | {"type": "Polygon", "coordinates": [[[-119.7227, 34.41018], [-119.72251, 34.41013], [-119.72261, 34.40986], [-119.72277, 34.4099], [-119.7228, 34.40994], [-119.7227, 34.41018]]]} | Unknown Access 4 | 36570 | Santa Barbara holding 5 | 25047 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 0.148 | Santa Barbara holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13945 | 13945 | 13944 | {"type": "Polygon", "coordinates": [[[-119.72232, 34.41009], [-119.72219, 34.41042], [-119.722, 34.41037], [-119.72213, 34.41004], [-119.72232, 34.41009]]]} | Unknown Access 4 | 36575 | Santa Barbara holding 7 | 25049 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 0.176 | Santa Barbara holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13946 | 13946 | 13945 | {"type": "Polygon", "coordinates": [[[-119.72261, 34.40986], [-119.72251, 34.41013], [-119.72213, 34.41004], [-119.72223, 34.40976], [-119.72261, 34.40986]]]} | Unknown Access 4 | 36576 | Santa Barbara holding 6 | 25048 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 0.289 | Santa Barbara holding 6 | 0 | Local Other or Unknown 14 | 4 | |
133 | 133 | 132 | {"type": "Polygon", "coordinates": [[[-119.74246, 34.44054], [-119.74244, 34.44072], [-119.74241, 34.44073], [-119.74215, 34.44091], [-119.74194, 34.44113], [-119.74168, 34.44129], [-119.74157, 34.44128], [-119.7414, 34.44128], [-119.74181, 34.44101], [-119.74204, 34.44079], [-119.74227, 34.44062], [-119.74234, 34.44054], [-119.74246, 34.44054]]]} | Unknown Access 4 | 414 | San Roque Creek | 24990 | 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.477 | San Roque Creek | 0 | Local Other or Unknown 14 | 4 | |
4863 | 4863 | 4862 | {"type": "MultiPolygon", "coordinates": [[[[-119.70446, 34.41592], [-119.70424, 34.41613], [-119.70413, 34.41605], [-119.70419, 34.41599], [-119.70419, 34.41598], [-119.70404, 34.41596], [-119.70425, 34.41577], [-119.70446, 34.41592]]], [[[-119.70685, 34.41659], [-119.70669, 34.41678], [-119.7063, 34.4165], [-119.70614, 34.41646], [-119.70575, 34.41648], [-119.70547, 34.41645], [-119.70524, 34.41628], [-119.70536, 34.41617], [-119.70546, 34.41624], [-119.70567, 34.4163], [-119.70578, 34.41631], [-119.70609, 34.4163], [-119.70614, 34.41611], [-119.70651, 34.41638], [-119.70658, 34.4164], [-119.70685, 34.41659]]], [[[-119.70983, 34.41818], [-119.70962, 34.41838], [-119.70935, 34.41819], [-119.70897, 34.41794], [-119.70718, 34.41712], [-119.70694, 34.41694], [-119.70715, 34.41674], [-119.70759, 34.41702], [-119.70878, 34.41758], [-119.70922, 34.41781], [-119.70983, 34.41818]]], [[[-119.71422, 34.42244], [-119.71392, 34.42193], [-119.71369, 34.42125], [-119.71359, 34.42118], [-119.7136, 34.42116], [-119.71335, 34.42103], [-119.71095, 34.41928], [-119.71092, 34.41929], [-119.71027, 34.41881], [-119.71045, 34.41863], [-119.71376, 34.42102], [-119.71375, 34.42104], [-119.71445, 34.42169], [-119.71451, 34.42176], [-119.71457, 34.42188], [-119.71459, 34.422], [-119.71458, 34.42209], [-119.71452, 34.42226], [-119.71422, 34.42244]]], [[[-119.71602, 34.42306], [-119.71596, 34.42311], [-119.71571, 34.42293], [-119.71503, 34.42272], [-119.71492, 34.42281], [-119.71462, 34.42268], [-119.7148, 34.42245], [-119.71508, 34.42266], [-119.71527, 34.42272], [-119.71547, 34.42272], [-119.71565, 34.42277], [-119.71602, 34.42306]]], [[[-119.71871, 34.4248], [-119.71859, 34.42481], [-119.71853, 34.42497], [-119.7185, 34.42501], [-119.7185, 34.42485], [-119.71848, 34.42476], [-119.7184, 34.42456], [-119.71827, 34.42439], [-119.71817, 34.42433], [-119.71797, 34.4243], [-119.71792, 34.42426], [-119.71803, 34.42416], [-119.71837, 34.42443], [-119.71871, 34.4248]]], [[[-119.71973, 34.42579], [-119.71956, 34.42597], [-119.71905, 34.42559], [-119.71906, 34.42556], [-119.71868, 34.42528], [-119.71893, 34.42505], [-119.71881, 34.42495], [-119.71886, 34.42491], [-119.71973, 34.42579]]], [[[-119.72436, 34.42678], [-119.72408, 34.42674], [-119.7239, 34.42666], [-119.72379, 34.42667], [-119.72365, 34.42666], [-119.72345, 34.42659], [-119.72288, 34.42652], [-119.72194, 34.42634], [-119.72175, 34.42632], [-119.72189, 34.42619], [-119.72247, 34.42632], [-119.72345, 34.42645], [-119.7239, 34.42657], [-119.72436, 34.42678]]]]} | Unknown Access 4 | 14691 | El Mission Creek | 18513 | 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 | 9.467 | El Mission Creek | 0 | Local Other or Unknown 14 | 4 | |
5832 | 5832 | 5831 | {"type": "MultiPolygon", "coordinates": [[[[-120.50973, 34.63798], [-120.51286, 34.63889], [-120.51323, 34.63901], [-120.51359, 34.63917], [-120.51515, 34.64001], [-120.51622, 34.64005], [-120.51655, 34.6402], [-120.51656, 34.64047], [-120.51688, 34.64047], [-120.51753, 34.64052], [-120.51833, 34.64072], [-120.52173, 34.64176], [-120.52245, 34.64197], [-120.52267, 34.64203], [-120.52322, 34.64208], [-120.52367, 34.64208], [-120.52411, 34.642], [-120.52453, 34.64184], [-120.52473, 34.64174], [-120.52491, 34.64162], [-120.52509, 34.64148], [-120.52526, 34.64133], [-120.5254, 34.64117], [-120.52499, 34.64091], [-120.52532, 34.64066], [-120.52591, 34.641], [-120.52569, 34.64131], [-120.52561, 34.64127], [-120.52529, 34.64159], [-120.5251, 34.64174], [-120.5249, 34.64187], [-120.52468, 34.64198], [-120.52446, 34.64208], [-120.52423, 34.64216], [-120.524, 34.64221], [-120.52376, 34.64225], [-120.52326, 34.64226], [-120.52306, 34.64225], [-120.52266, 34.64219], [-120.52244, 34.64213], [-120.5177, 34.64076], [-120.51683, 34.64065], [-120.51662, 34.64071], [-120.51561, 34.64118], [-120.51546, 34.64157], [-120.51524, 34.64229], [-120.51503, 34.64383], [-120.51517, 34.64385], [-120.51518, 34.64407], [-120.51465, 34.64397], [-120.51466, 34.64381], [-120.51481, 34.64378], [-120.515, 34.64223], [-120.5152, 34.64136], [-120.5152, 34.64105], [-120.51524, 34.64024], [-120.51359, 34.63934], [-120.5132, 34.63917], [-120.51278, 34.63903], [-120.50968, 34.63817], [-120.50816, 34.6378], [-120.50809, 34.63772], [-120.50496, 34.63692], [-120.50458, 34.63679], [-120.5044, 34.63671], [-120.50407, 34.63649], [-120.50378, 34.63623], [-120.50366, 34.63607], [-120.50355, 34.63591], [-120.50337, 34.63556], [-120.50306, 34.63472], [-120.50291, 34.63448], [-120.50259, 34.63415], [-120.50216, 34.63439], [-120.50154, 34.63387], [-120.50279, 34.63315], [-120.50329, 34.63373], [-120.50277, 34.63406], [-120.50309, 34.63452], [-120.50321, 34.63473], [-120.50355, 34.63565], [-120.50374, 34.63597], [-120.50398, 34.63625], [-120.50427, 34.63649], [-120.50459, 34.63667], [-120.50494, 34.6368], [-120.50702, 34.63734], [-120.5071, 34.63728], [-120.50758, 34.63739], [-120.50763, 34.63748], [-120.50973, 34.63798]]], [[[-120.51511, 34.64666], [-120.51511, 34.6469], [-120.51439, 34.64689], [-120.51439, 34.64665], [-120.51459, 34.64664], [-120.51462, 34.64418], [-120.51492, 34.64425], [-120.51488, 34.64664], [-120.51511, 34.64666]]], [[[-120.5152, 34.64717], [-120.51519, 34.64736], [-120.51495, 34.64736], [-120.5148, 34.66139], [-120.51441, 34.66139], [-120.51444, 34.65983], [-120.5145, 34.65944], [-120.51456, 34.65417], [-120.51455, 34.64736], [-120.51434, 34.64735], [-120.51434, 34.64716], [-120.5152, 34.64717]]], [[[-120.51427, 34.66507], [-120.5144, 34.66155], [-120.5148, 34.66156], [-120.51468, 34.66508], [-120.51458, 34.66933], [-120.51472, 34.66934], [-120.51467, 34.67235], [-120.5146, 34.67337], [-120.51462, 34.67357], [-120.51469, 34.67382], [-120.51479, 34.67405], [-120.51525, 34.67468], [-120.51541, 34.67475], [-120.51554, 34.67482], [-120.51677, 34.67601], [-120.5155, 34.67603], [-120.51524, 34.67584], [-120.51453, 34.67574], [-120.51455, 34.67434], [-120.51437, 34.67417], [-120.51427, 34.67403], [-120.5142, 34.67387], [-120.51415, 34.6737], [-120.51414, 34.67333], [-120.51419, 34.6687], [-120.51427, 34.66507]]]]} | Unknown Access 4 | 159 | Rodeo-San Pascual Flood Control Channel | 24548 | 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 | 53.121 | Rodeo-San Pascual Flood Control Channel | 0 | Local Other or Unknown 14 | 4 | |
5884 | 5884 | 5883 | {"type": "MultiPolygon", "coordinates": [[[[-119.79426, 34.4463], [-119.79411, 34.44637], [-119.79361, 34.44738], [-119.79382, 34.4476], [-119.7938, 34.44786], [-119.79343, 34.44803], [-119.79298, 34.44802], [-119.79241, 34.44812], [-119.79224, 34.44837], [-119.79212, 34.44829], [-119.79226, 34.44801], [-119.7925, 34.44786], [-119.79254, 34.44769], [-119.79277, 34.44765], [-119.79284, 34.44779], [-119.79309, 34.44778], [-119.79324, 34.44775], [-119.79335, 34.44763], [-119.79341, 34.44749], [-119.79326, 34.44738], [-119.79339, 34.44722], [-119.79373, 34.44669], [-119.79374, 34.44663], [-119.79372, 34.44657], [-119.79404, 34.44609], [-119.79426, 34.4463]]], [[[-119.79691, 34.446], [-119.79567, 34.446], [-119.79525, 34.44612], [-119.79527, 34.44646], [-119.79515, 34.44653], [-119.79497, 34.44665], [-119.79437, 34.44639], [-119.79559, 34.44572], [-119.79691, 34.44574], [-119.79691, 34.446]]], [[[-119.80544, 34.44219], [-119.80546, 34.44288], [-119.80541, 34.44301], [-119.8053, 34.44297], [-119.80522, 34.44319], [-119.805, 34.44321], [-119.80514, 34.44286], [-119.80505, 34.44237], [-119.80464, 34.44245], [-119.80463, 34.44244], [-119.80339, 34.4427], [-119.80252, 34.44299], [-119.80242, 34.443], [-119.80218, 34.44295], [-119.80205, 34.44296], [-119.80193, 34.44301], [-119.80184, 34.4431], [-119.80166, 34.44341], [-119.80163, 34.44356], [-119.79959, 34.44377], [-119.79958, 34.44402], [-119.80165, 34.44381], [-119.80166, 34.44387], [-119.80164, 34.4439], [-119.80152, 34.444], [-119.80123, 34.44433], [-119.79955, 34.44431], [-119.79955, 34.44426], [-119.79932, 34.44426], [-119.79926, 34.44428], [-119.79891, 34.44452], [-119.79893, 34.44461], [-119.79879, 34.44464], [-119.79864, 34.44471], [-119.79829, 34.44493], [-119.79811, 34.44503], [-119.79791, 34.4451], [-119.7977, 34.44513], [-119.79719, 34.4451], [-119.79715, 34.44507], [-119.79716, 34.44489], [-119.79744, 34.44489], [-119.79768, 34.44487], [-119.79791, 34.44481], [-119.79813, 34.44471], [-119.79833, 34.44457], [-119.79906, 34.44389], [-119.79918, 34.44383], [-119.79934, 34.44379], [-119.79935, 34.44374], [-119.80041, 34.44361], [-119.8009, 34.44357], [-119.80091, 34.44337], [-119.80083, 34.44331], [-119.80078, 34.44324], [-119.80077, 34.44317], [-119.80078, 34.44304], [-119.80079, 34.44298], [-119.80084, 34.44291], [-119.80095, 34.44281], [-119.80101, 34.44277], [-119.8013, 34.44273], [-119.80157, 34.44261], [-119.80241, 34.44243], [-119.8022, 34.44256], [-119.80194, 34.44281], [-119.80286, 34.44279], [-119.80297, 34.44269], [-119.80544, 34.44219]]]]} | Unknown Access 4 | 290 | San Antonio Creek | 24828 | 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 | 12.836 | San Antonio Creek | 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]);