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 UNIT_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
108 | 108 | 107 | {"type": "Polygon", "coordinates": [[[-119.80165, 34.44381], [-119.80106, 34.44387], [-119.79957, 34.44402], [-119.79959, 34.44377], [-119.80161, 34.44357], [-119.80165, 34.44381]]]} | Unknown Access 4 | 295 | San Antonio Creek | 24829 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 1.291 | San Antonio Creek | 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 | |
3770 | 3770 | 3769 | {"type": "Polygon", "coordinates": [[[-121.40978, 39.0321], [-121.40886, 39.03318], [-121.40825, 39.0338], [-121.40801, 39.03396], [-121.40738, 39.03562], [-121.40691, 39.03607], [-121.40665, 39.03623], [-121.40644, 39.03625], [-121.40543, 39.03614], [-121.40505, 39.03582], [-121.40453, 39.0351], [-121.40393, 39.0349], [-121.40344, 39.03488], [-121.40287, 39.03514], [-121.4026, 39.03562], [-121.40242, 39.03625], [-121.40184, 39.0353], [-121.40342, 39.03459], [-121.40368, 39.03458], [-121.40502, 39.03496], [-121.40768, 39.03386], [-121.40806, 39.03357], [-121.40923, 39.03229], [-121.40961, 39.0318], [-121.40978, 39.0321]]]} | Unknown Access 4 | 472 | Dry Creek | 18279 | 2127 | Sacramento and San Joaquin Drainage District 681 | Special District 4 | Flood District 8 | Special District 4 | 2127 | Sacramento and San Joaquin Drainage District 671 | Special District 4 | Flood District 9 | Yuba 25 | 15.587 | Dry Creek | 0 | Local Other or Unknown 14 | 4 | ||
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 | |
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 | |
6620 | 6620 | 6619 | {"type": "MultiPolygon", "coordinates": [[[[-119.50852, 34.39516], [-119.50697, 34.39588], [-119.50689, 34.39577], [-119.5075, 34.3955], [-119.50841, 34.395], [-119.50852, 34.39516]]], [[[-119.50986, 34.39487], [-119.50965, 34.39489], [-119.50944, 34.39484], [-119.50927, 34.39472], [-119.50912, 34.39453], [-119.50904, 34.39446], [-119.50888, 34.39438], [-119.50873, 34.39436], [-119.5086, 34.39437], [-119.50821, 34.39482], [-119.50804, 34.39483], [-119.50784, 34.39456], [-119.50791, 34.39452], [-119.50809, 34.39429], [-119.50817, 34.39415], [-119.50814, 34.39411], [-119.50831, 34.39392], [-119.50859, 34.39368], [-119.50859, 34.3931], [-119.50876, 34.39344], [-119.50894, 34.39363], [-119.50974, 34.39478], [-119.5098, 34.39476], [-119.50986, 34.39487]]]]} | Unknown Access 4 | 4305 | Carpinteria Creek | 16896 | 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.634 | Carpinteria Creek | 0 | Local Other or Unknown 14 | 4 | |
4482 | 4482 | 4481 | {"type": "Polygon", "coordinates": [[[-118.82809, 34.1109], [-118.82374, 34.11089], [-118.82373, 34.10731], [-118.82808, 34.10728], [-118.82809, 34.1109]]]} | Unknown Access 4 | 4333 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 39.614 | 0 | Local Other or Unknown 14 | 4 | ||
4483 | 4483 | 4482 | {"type": "Polygon", "coordinates": [[[-118.83243, 34.10717], [-118.83243, 34.10853], [-118.82873, 34.10863], [-118.82809, 34.10863], [-118.82808, 34.10727], [-118.82875, 34.10727], [-118.83243, 34.10717]]]} | Unknown Access 4 | 4342 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 14.94 | 0 | Local Other or Unknown 14 | 4 | ||
6625 | 6625 | 6624 | {"type": "Polygon", "coordinates": [[[-119.50841, 34.395], [-119.5075, 34.3955], [-119.50689, 34.39577], [-119.50682, 34.39566], [-119.50722, 34.39559], [-119.50754, 34.39538], [-119.50776, 34.39528], [-119.50804, 34.39502], [-119.50825, 34.39477], [-119.50841, 34.395]]]} | Unknown Access 4 | 4393 | Carpinteria Creek | 16898 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 0.458 | Carpinteria Creek | 0 | Local Other or Unknown 14 | 4 | |
4487 | 4487 | 4486 | {"type": "Polygon", "coordinates": [[[-117.65095, 33.91007], [-117.65019, 33.91006], [-117.64981, 33.90897], [-117.65009, 33.9089], [-117.65007, 33.90881], [-117.65045, 33.90848], [-117.65044, 33.90828], [-117.64965, 33.9076], [-117.64926, 33.90648], [-117.65093, 33.90642], [-117.65095, 33.91007]]]} | Unknown Access 4 | 4844 | Unnamed site - Orange County Water District | 28653 | 2105 | Orange County Water District 768 | Special District 4 | Water District 13 | http://www.ocwd.com/ | Special District 4 | 2105 | Orange County Water District 749 | Special District 4 | Water District 13 | Riverside 10 | 9.715 | 0 | Local Other or Unknown 14 | 4 | ||
4489 | 4489 | 4488 | {"type": "MultiPolygon", "coordinates": [[[[-118.21759, 34.10846], [-118.21735, 34.1085], [-118.21726, 34.10813], [-118.21751, 34.10809], [-118.21759, 34.10846]]], [[[-118.21918, 34.10822], [-118.21901, 34.10857], [-118.21832, 34.10834], [-118.21784, 34.10842], [-118.21775, 34.10805], [-118.21837, 34.10795], [-118.21918, 34.10822]]]]} | Unknown Access 4 | 4922 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 1.517 | 0 | Local Other or Unknown 14 | 4 | ||
15589 | 15589 | 15588 | {"type": "Polygon", "coordinates": [[[-118.00977, 34.00681], [-118.00047, 34.02256], [-117.99322, 34.01961], [-117.99553, 34.01569], [-117.99582, 34.0158], [-117.99633, 34.01493], [-117.99605, 34.0148], [-118.00515, 33.99931], [-118.00592, 33.99969], [-118.00608, 33.99979], [-118.00624, 33.99992], [-118.00635, 34.00003], [-118.00702, 34.00098], [-118.00716, 34.00115], [-118.00742, 34.00135], [-118.00767, 34.00147], [-118.0079, 34.00193], [-118.00888, 34.00585], [-118.00977, 34.00681]]]} | Unknown Access 4 | 6546 | Hacienda Hills Open Space - Sanitation District | 29676 | 2139 | Sanitation Districts of Los Angeles County 290 | Special District 4 | Sanitation District 18 | http://www.lacsd.org/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 419.341 | Hacienda Hills OS - Sanitation District | 0 | Local Other or Unknown 14 | 4 | |
4504 | 4504 | 4503 | {"type": "MultiPolygon", "coordinates": [[[[-118.27189, 34.25899], [-118.2716, 34.25922], [-118.2716, 34.25779], [-118.27178, 34.25778], [-118.27189, 34.25756], [-118.27189, 34.25899]]], [[[-118.27237, 34.25554], [-118.27236, 34.25643], [-118.27206, 34.25642], [-118.27207, 34.25578], [-118.27217, 34.25566], [-118.27237, 34.25554]]], [[[-118.27285, 34.2587], [-118.27285, 34.25987], [-118.27263, 34.25987], [-118.27263, 34.25887], [-118.27285, 34.2587]]], [[[-118.27406, 34.25636], [-118.27354, 34.2563], [-118.27351, 34.25638], [-118.27362, 34.25645], [-118.27348, 34.25653], [-118.27348, 34.25563], [-118.27335, 34.25554], [-118.27335, 34.25468], [-118.27359, 34.25468], [-118.27359, 34.25569], [-118.27369, 34.25576], [-118.27406, 34.25565], [-118.27406, 34.25636]]]]} | Unknown Access 4 | 6855 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 3.721 | 0 | Local Other or Unknown 14 | 4 | ||
4507 | 4507 | 4506 | {"type": "Polygon", "coordinates": [[[-118.37116, 34.12047], [-118.37096, 34.12061], [-118.37088, 34.12062], [-118.37083, 34.12058], [-118.37088, 34.12031], [-118.37103, 34.12024], [-118.37116, 34.12047]]]} | Unknown Access 4 | 6890 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.191 | 0 | Local Other or Unknown 14 | 4 | ||
7204 | 7204 | 7203 | {"type": "Polygon", "coordinates": [[[-118.36759, 34.13349], [-118.36743, 34.13395], [-118.36738, 34.13394], [-118.36736, 34.13386], [-118.36729, 34.13382], [-118.36698, 34.13377], [-118.3668, 34.13377], [-118.36673, 34.13381], [-118.36668, 34.1337], [-118.36679, 34.13361], [-118.36681, 34.13361], [-118.36697, 34.1335], [-118.36722, 34.13344], [-118.36717, 34.13334], [-118.36759, 34.13349]]]} | Unknown Access 4 | 6892 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.681 | 0 | Local Other or Unknown 14 | 4 | ||
4511 | 4511 | 4510 | {"type": "Polygon", "coordinates": [[[-118.75427, 34.16206], [-118.7528, 34.16289], [-118.75305, 34.16324], [-118.75218, 34.16381], [-118.75052, 34.1638], [-118.75016, 34.1634], [-118.74922, 34.16397], [-118.74932, 34.16485], [-118.74577, 34.16484], [-118.74578, 34.15444], [-118.75019, 34.15445], [-118.75017, 34.15687], [-118.75077, 34.15683], [-118.75171, 34.15863], [-118.75245, 34.15924], [-118.75258, 34.15956], [-118.75315, 34.16008], [-118.75269, 34.16057], [-118.75282, 34.16118], [-118.75304, 34.16161], [-118.75416, 34.1616], [-118.75427, 34.16206]]]} | Unknown Access 4 | 7093 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 154.044 | 0 | Local Other or Unknown 14 | 4 | ||
7291 | 7291 | 7290 | {"type": "Polygon", "coordinates": [[[-118.44137, 34.09262], [-118.44135, 34.09273], [-118.44123, 34.09285], [-118.44109, 34.09258], [-118.44137, 34.09262]]]} | Unknown Access 4 | 7131 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.106 | 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]);