units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
261 rows where ACCESS_TYP = 3 and AGNCY_LEV = 4 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL, COUNTY, GAP_STS
MNG_AGENCY >30
- East Bay Regional Park District 41
- Las Virgenes Municipal Water District 28
- Natomas Basin Conservancy 22
- Midpeninsula Regional Open Space District 18
- Santa Clara Valley Open Space Authority 17
- Fresno Metropolitan Flood Control District 16
- Los Angeles County Flood Control District 13
- Kinneloa Irrigation District 13
- Littlerock Creek Irrigation District 13
- Sonoma County Agricultural Preservation and Open Space District 11
- Riverside County Habitat Conservation Agency 8
- Mountains Recreation and Conservation Authority 7
- Napa County Regional Park and Open Space District 7
- Metropolitan Water District of Southern California 6
- East Bay Municipal Utility District 6
- Santa Barbara Flood Control and Water Conserv. District 3
- San Bernardino County Flood Control District 3
- Monterey Peninsula Regional Park District 2
- San Marcos, City of 2
- Conejo Open Space Conservation Agency 2
- Valley Center Water District 2
- Olivenhain Municipal Water District 2
- San Diego County Water Authority 2
- La Verne, City of 1
- La Canada Irrigation District 1
- Livermore Area Recreation and Park District 1
- Sanitation Districts of Los Angeles County 1
- Montecito Water District 1
- North Coast Water District 1
- Yuima Municipal Water District 1
- …
DES_TP >30
MNG_AG_TYP 7
ACCESS_TYP 1
- No Public Access · 261 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1033 | 1033 | 1032 | {"type": "Polygon", "coordinates": [[[-118.51157, 34.07731], [-118.51143, 34.07746], [-118.5104, 34.07684], [-118.5101, 34.07613], [-118.50988, 34.07539], [-118.50872, 34.07481], [-118.50845, 34.0745], [-118.50826, 34.07401], [-118.50761, 34.07364], [-118.50763, 34.07328], [-118.50737, 34.07296], [-118.50731, 34.07284], [-118.50737, 34.07275], [-118.50746, 34.07269], [-118.50778, 34.07276], [-118.50866, 34.0734], [-118.50892, 34.0734], [-118.50898, 34.07385], [-118.50974, 34.07406], [-118.50989, 34.07443], [-118.50989, 34.07475], [-118.51067, 34.07526], [-118.51068, 34.07637], [-118.51099, 34.07669], [-118.51107, 34.07682], [-118.5113, 34.07702], [-118.51157, 34.07731]]]} | No Public Access 3 | 6378 | Sullivan Canyon Creek & Dam | 25948 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 10.67 | Sullivan Canyon Creek & Dam | None 93 | |||
1115 | 1115 | 1114 | {"type": "Polygon", "coordinates": [[[-117.8843, 33.96567], [-117.88426, 33.96587], [-117.88394, 33.96616], [-117.88344, 33.96606], [-117.88359, 33.96552], [-117.8843, 33.96567]]]} | No Public Access 3 | 6558 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.931 | Roland Area County Water District Land | None 101 | |||
1708 | 1708 | 1707 | {"type": "Polygon", "coordinates": [[[-117.93744, 33.98131], [-117.93677, 33.98161], [-117.93629, 33.98086], [-117.93696, 33.98056], [-117.93744, 33.98131]]]} | No Public Access 3 | 6551 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 1.632 | Roland Area County Water District Land | None 136 | |||
1759 | 1759 | 1758 | {"type": "Polygon", "coordinates": [[[-117.93234, 33.9866], [-117.93168, 33.98689], [-117.93158, 33.98688], [-117.93166, 33.98615], [-117.93219, 33.9861], [-117.93223, 33.98635], [-117.93234, 33.9866]]]} | No Public Access 3 | 6552 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 1.052 | Roland Area County Water District Land | None 137 | |||
1760 | 1760 | 1759 | {"type": "Polygon", "coordinates": [[[-117.91753, 33.96603], [-117.91639, 33.96877], [-117.91516, 33.96861], [-117.91523, 33.96842], [-117.91541, 33.96808], [-117.91555, 33.96763], [-117.91605, 33.96696], [-117.91648, 33.9667], [-117.91691, 33.96636], [-117.91753, 33.96603]]]} | No Public Access 3 | 6553 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 6.905 | Roland Area County Water District Land | None 138 | |||
1761 | 1761 | 1760 | {"type": "Polygon", "coordinates": [[[-117.92305, 33.97679], [-117.92297, 33.97736], [-117.92178, 33.97689], [-117.92181, 33.97667], [-117.92244, 33.97672], [-117.92249, 33.97669], [-117.92258, 33.97673], [-117.92265, 33.97671], [-117.92276, 33.97676], [-117.92305, 33.97679]]]} | No Public Access 3 | 6554 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 1.271 | Roland Area County Water District Land | None 139 | |||
1762 | 1762 | 1761 | {"type": "Polygon", "coordinates": [[[-117.90135, 33.9591], [-117.90114, 33.95933], [-117.90097, 33.95918], [-117.90029, 33.95921], [-117.90038, 33.95914], [-117.90053, 33.95907], [-117.89969, 33.95857], [-117.89885, 33.95773], [-117.89826, 33.95783], [-117.89766, 33.95753], [-117.89771, 33.95684], [-117.89761, 33.9564], [-117.89643, 33.95562], [-117.89634, 33.95554], [-117.89624, 33.95542], [-117.89618, 33.95531], [-117.89616, 33.9552], [-117.89626, 33.95518], [-117.89661, 33.95555], [-117.89745, 33.95579], [-117.89819, 33.95616], [-117.89868, 33.95697], [-117.89953, 33.95806], [-117.90094, 33.959], [-117.90126, 33.95894], [-117.90135, 33.9591]]]} | No Public Access 3 | 6555 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 7.601 | Roland Area County Water District Land | None 140 | |||
2236 | 2236 | 2235 | {"type": "Polygon", "coordinates": [[[-118.34876, 33.79283], [-118.34853, 33.79307], [-118.3421, 33.78766], [-118.34362, 33.78659], [-118.34783, 33.79015], [-118.34783, 33.79205], [-118.34876, 33.79283]]]} | No Public Access 3 | 5918 | South Coast Park/former Palos Verdes Landfill site | 29032 | 2139 | Sanitation Districts of Los Angeles County 290 | Special District 4 | Sanitation District 18 | http://www.lacsd.org/ | Special District 4 | 2139 | Sanitation Districts of Los Angeles County 490 | Special District 4 | Sanitation District 19 | http://www.lacsd.org/solidwaste/swfacilities/landfills/palos_verdes/ | Los Angeles 6 | 30.5 | South Coast Park/former Palos Verdes Landfill site | None 184 | ||
2329 | 2329 | 2328 | {"type": "Polygon", "coordinates": [[[-119.51345, 34.48686], [-119.51326, 34.49394], [-119.4989, 34.49389], [-119.49892, 34.49041], [-119.49005, 34.49037], [-119.49007, 34.4868], [-119.49489, 34.48683], [-119.51345, 34.48686]]]} | No Public Access 3 | 17019 | Jameson Lake | 20355 | 2082 | Montecito Water District 513 | Special District 4 | Water District 13 | http://www.montecitowater.com/ | Special District 4 | 2082 | Montecito Water District 506 | Special District 4 | Water District 13 | Santa Barbara 7 | 336.515 | Jameson Lake | None 196 | |||
2565 | 2565 | 2564 | {"type": "Polygon", "coordinates": [[[-117.90918, 33.95983], [-117.90918, 33.95986], [-117.90916, 33.95988], [-117.90863, 33.95999], [-117.90848, 33.95973], [-117.90893, 33.95954], [-117.90906, 33.95966], [-117.90914, 33.95975], [-117.90918, 33.95983]]]} | No Public Access 3 | 6556 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.487 | Roland Area County Water District Land | None 210 | |||
2593 | 2593 | 2592 | {"type": "Polygon", "coordinates": [[[-117.89197, 33.96438], [-117.89183, 33.96505], [-117.89141, 33.96512], [-117.8911, 33.96526], [-117.89075, 33.96497], [-117.89062, 33.96475], [-117.89062, 33.96444], [-117.89119, 33.96426], [-117.89197, 33.96438]]]} | No Public Access 3 | 6557 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 2.479 | Roland Area County Water District Land | None 214 | |||
2686 | 2686 | 2685 | {"type": "Polygon", "coordinates": [[[-122.47796, 37.56987], [-122.46847, 37.57003], [-122.46834, 37.56631], [-122.47791, 37.56619], [-122.47796, 37.56987]]]} | No Public Access 3 | 18237 | North Coast Water Dist | 22815 | 2093 | North Coast Water District 544 | Special District 4 | Water District 13 | http://www.nccwd.com | Special District 4 | 2093 | North Coast Water District 537 | Special District 4 | Water District 13 | San Mateo 15 | 85.384 | North Coast Water Dist | None 220 | |||
3385 | 3385 | 3384 | {"type": "Polygon", "coordinates": [[[-121.55826, 38.7289], [-121.54862, 38.72895], [-121.5486, 38.7219], [-121.55823, 38.72189], [-121.55826, 38.7289]]]} | No Public Access 3 | 35038 | Natomas Basin Conservancy | 22668 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sacramento 41 | 161.591 | Natomas Basin Conservancy | None 279 | |||
3393 | 3393 | 3392 | {"type": "MultiPolygon", "coordinates": [[[[-120.88206, 38.22962], [-120.88189, 38.22982], [-120.88159, 38.23048], [-120.88159, 38.23065], [-120.88161, 38.23075], [-120.88169, 38.23091], [-120.88173, 38.23116], [-120.8817, 38.23131], [-120.88166, 38.23143], [-120.88152, 38.2317], [-120.88139, 38.23188], [-120.88135, 38.23191], [-120.88132, 38.23191], [-120.88121, 38.23184], [-120.88112, 38.23181], [-120.88099, 38.2318], [-120.88089, 38.23185], [-120.88088, 38.23187], [-120.88089, 38.23197], [-120.88095, 38.232], [-120.88106, 38.23199], [-120.88113, 38.23201], [-120.88115, 38.23205], [-120.88115, 38.23208], [-120.88108, 38.23215], [-120.88066, 38.23229], [-120.88046, 38.23239], [-120.88038, 38.2325], [-120.88038, 38.23276], [-120.88036, 38.23281], [-120.88032, 38.23287], [-120.88015, 38.23306], [-120.88013, 38.23322], [-120.88003, 38.23342], [-120.88007, 38.23367], [-120.88013, 38.23382], [-120.88032, 38.23409], [-120.88035, 38.23419], [-120.88033, 38.2345], [-120.88028, 38.2347], [-120.88019, 38.23483], [-120.87992, 38.23514], [-120.87985, 38.23528], [-120.87983, 38.23543], [-120.87972, 38.23557], [-120.87969, 38.23566], [-120.8797, 38.23574], [-120.87973, 38.2358], [-120.87982, 38.23588], [-120.87992, 38.23616], [-120.87995, 38.23634], [-120.88001, 38.23643], [-120.88003, 38.23667], [-120.88015, 38.23674], [-120.88024, 38.2369], [-120.88025, 38.23697], [-120.87983, 38.23695], [-120.87977, 38.23661], [-120.87962, 38.23641], [-120.87951, 38.23616], [-120.87941, 38.23589], [-120.87939, 38.2356], [-120.8795, 38.23533], [-120.87978, 38.23483], [-120.87985, 38.23449], [-120.87982, 38.23416], [-120.87983, 38.23386], [-120.87975, 38.23364], [-120.87958, 38.2334], [-120.87903, 38.23321], [-120.87825, 38.23309], [-120.87706, 38.23294], [-120.87671, 38.23265], [-120.87842, 38.23189], [-120.87843, 38.23187], [-120.87341, 38.22535], [-120.87204, 38.22503], [-120.87203, 38.22504], [-120.87195, 38.22581], [-120.87185, 38.22579], [-120.86743, 38.2259], [-120.86741, 38.2291], [-120.86743, 38.22969], [-120.86627, 38.22967], [-120.86558, 38.22968], [-120.8603, 38.2333], [-120.85937, 38.2333], [-120.86518, 38.22927], [-120.86511, 38.22496], [-120.86509, 38.22495], [-120.86027, 38.22871], [-120.85803, 38.23052], [-120.85065, 38.23681], [-120.84976, 38.2368], [-120.858, 38.22975], [-120.85967, 38.22835], [-120.86401, 38.22497], [-120.86521, 38.22393], [-120.8652, 38.22214], [-120.86748, 38.22214], [-120.87285, 38.22217], [-120.87216, 38.22368], [-120.87396, 38.22439], [-120.87577, 38.22762], [-120.87615, 38.22832], [-120.87628, 38.22852], [-120.8766, 38.22888], [-120.87679, 38.22907], [-120.87704, 38.2292], [-120.87729, 38.22928], [-120.8778, 38.22939], [-120.87823, 38.22945], [-120.88003, 38.22959], [-120.88206, 38.22962]]], [[[-120.85787, 38.23417], [-120.85785, 38.23462], [-120.85433, 38.23687], [-120.85366, 38.23686], [-120.85787, 38.23417]]], [[[-120.91315, 38.21032], [-120.91298, 38.21043], [-120.91128, 38.21116], [-120.90986, 38.21173], [-120.908, 38.21251], [-120.90585, 38.21345], [-120.90347, 38.21452], [-120.90325, 38.21464], [-120.90253, 38.21465], [-120.90408, 38.21398], [-120.90642, 38.21293], [-120.9077, 38.21238], [-120.9082, 38.21214], [-120.91193, 38.21058], [-120.91275, 38.21022], [-120.91315, 38.20991], [-120.91315, 38.21032]]], [[[-120.93525, 38.19678], [-120.93371, 38.19753], [-120.93183, 38.19851], [-120.93183, 38.19816], [-120.93487, 38.19669], [-120.93525, 38.19678]]], [[[-120.9649, 38.18209], [-120.96374, 38.18268], [-120.95624, 38.18595], [-120.94558, 38.19119], [-120.94558, 38.19252], [-120.94527, 38.19255], [-120.94301, 38.19248], [-120.93813, 38.19519], [-120.93656, 38.196], [-120.93552, 38.19663], [-120.93514, 38.19654], [-120.93624, 38.19583], [-120.93847, 38.19465], [-120.93948, 38.19405], [-120.94079, 38.19333], [-120.94193, 38.19268], [-120.94543, 38.19079], [-120.95544, 38.18586], [-120.96448, 38.18193], [-120.9649, 38.18209]]], [[[-120.97586, 38.17794], [-120.96785, 38.18071], [-120.9655, 38.18181], [-120.96533, 38.18196], [-120.96523, 38.18197], [-120.9648, 38.1818], [-120.96512, 38.18165], [-120.96673, 38.18082], [-120.96792, 38.18037], [-120.96917, 38.17985], [-120.97185, 38.17901], [-120.97553, 38.17762], [-120.97552, 38.17761], [-120.9746, 38.1776], [-120.97333, 38.17764], [-120.97544, 38.17692], [-120.97586, 38.17794]]]]} | No Public Access 3 | 35086 | EBMUD | 18417 | 2031 | East Bay Municipal Utility District 433 | Special District 4 | Water District 13 | http://www.ebmud.com/ | Special District 4 | 2031 | East Bay Municipal Utility District 427 | Special District 4 | Water District 13 | Calaveras 53 | 231.042 | EBMUD | None 280 | |||
3642 | 3642 | 3641 | {"type": "Polygon", "coordinates": [[[-121.55976, 38.81045], [-121.55308, 38.81447], [-121.5516, 38.81536], [-121.55163, 38.80843], [-121.55929, 38.80831], [-121.5588, 38.8086], [-121.55869, 38.80876], [-121.55872, 38.80892], [-121.55888, 38.80918], [-121.55948, 38.80966], [-121.55948, 38.80977], [-121.5595, 38.80998], [-121.55976, 38.81045]]]} | No Public Access 3 | 29722 | Frazer | 19069 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 85.165 | Frazer | None 303 | |||
3821 | 3821 | 3820 | {"type": "MultiPolygon", "coordinates": [[[[-116.37096, 33.91459], [-116.37095, 33.91825], [-116.36879, 33.91825], [-116.36881, 33.9146], [-116.37096, 33.91459]]], [[[-116.75455, 33.48392], [-116.75058, 33.48397], [-116.75043, 33.48095], [-116.75448, 33.4809], [-116.75455, 33.48392]]]]} | No Public Access 3 | 35202 | Riverside County Habitat Conservation Agency 4 | 24448 | 2122 | Riverside County Habitat Conservation Agency 570 | Special District 4 | Open Space District 6 | http://www.skrplan.org/ | Special District 4 | 2122 | Riverside County Habitat Conservation Agency 562 | Special District 4 | Open Space District 6 | Riverside 10 | 50.849 | Riverside County Habitat Conservation Agency 4 | None 321 | |||
5448 | 5448 | 5447 | {"type": "Polygon", "coordinates": [[[-114.81367, 33.47735], [-114.79638, 33.47756], [-114.79635, 33.47757], [-114.79652, 33.49207], [-114.79165, 33.4923], [-114.78819, 33.4923], [-114.78802, 33.48436], [-114.77732, 33.48443], [-114.7774, 33.48827], [-114.77408, 33.4885], [-114.77397, 33.48142], [-114.7791, 33.48136], [-114.77898, 33.47792], [-114.75254, 33.47803], [-114.75242, 33.47458], [-114.74844, 33.47459], [-114.74847, 33.47067], [-114.74437, 33.47057], [-114.74437, 33.44131], [-114.74824, 33.4414], [-114.7483, 33.43375], [-114.79625, 33.43377], [-114.79621, 33.45528], [-114.81352, 33.45524], [-114.81365, 33.46296], [-114.81369, 33.472], [-114.81367, 33.47735]]]} | No Public Access 3 | 11970 | SDG&E, Desert Land Ranch, 6,640 acres | 25223 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 2078 | Metropolitan Water District of Southern California 407 | Special District 4 | Water District 13 | Riverside 10 | 7163.793 | SDG&E, Desert Land Ranch, 6,640 acres | None 440 | |||
6748 | 6748 | 6747 | {"type": "Polygon", "coordinates": [[[-122.70495, 38.54002], [-122.69591, 38.53995], [-122.69585, 38.53722], [-122.69581, 38.54015], [-122.69108, 38.54018], [-122.69113, 38.54204], [-122.69183, 38.54277], [-122.69244, 38.5437], [-122.69284, 38.54396], [-122.69307, 38.54474], [-122.69338, 38.54514], [-122.69313, 38.54524], [-122.69313, 38.54525], [-122.69393, 38.5458], [-122.69471, 38.54586], [-122.69553, 38.54629], [-122.69585, 38.54631], [-122.69602, 38.54627], [-122.6961, 38.55067], [-122.69333, 38.55066], [-122.69332, 38.5508], [-122.68703, 38.55091], [-122.68702, 38.54893], [-122.6868, 38.54892], [-122.6867, 38.54889], [-122.68631, 38.54853], [-122.68614, 38.54826], [-122.68595, 38.54804], [-122.68554, 38.54749], [-122.68546, 38.54725], [-122.68013, 38.54639], [-122.68015, 38.54353], [-122.67559, 38.54342], [-122.67577, 38.53648], [-122.6851, 38.5365], [-122.6852, 38.53294], [-122.69814, 38.53302], [-122.70492, 38.5362], [-122.70495, 38.54002]]]} | No Public Access 3 | 5106 | McCoullough | 22009 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 718.017 | McCoullough | None 547 | |||
7507 | 7507 | 7506 | {"type": "MultiPolygon", "coordinates": [[[[-118.76984, 34.13463], [-118.76979, 34.14307], [-118.76879, 34.14306], [-118.76756, 34.14353], [-118.76664, 34.14329], [-118.76421, 34.14197], [-118.76402, 34.14081], [-118.76074, 34.13944], [-118.76063, 34.1394], [-118.76039, 34.13904], [-118.76984, 34.13463]]], [[[-118.78434, 34.14415], [-118.78301, 34.14387], [-118.78264, 34.14342], [-118.78207, 34.14297], [-118.78149, 34.14303], [-118.78095, 34.14403], [-118.78032, 34.14421], [-118.7804, 34.13564], [-118.78432, 34.13601], [-118.78434, 34.14415]]], [[[-118.78946, 34.14068], [-118.78571, 34.14064], [-118.78567, 34.13615], [-118.78741, 34.13631], [-118.78945, 34.13679], [-118.78946, 34.14068]]]]} | No Public Access 3 | 7088 | Ladyface Mountain | 29854 | 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 | 237.912 | Ladyface Mtn. | None 623 | |||
7600 | 7600 | 7599 | {"type": "MultiPolygon", "coordinates": [[[[-117.14622, 33.06563], [-117.14613, 33.06566], [-117.14588, 33.06585], [-117.14528, 33.06607], [-117.14395, 33.06651], [-117.14403, 33.07291], [-117.1354, 33.07289], [-117.13529, 33.06938], [-117.13397, 33.06938], [-117.13526, 33.06843], [-117.13522, 33.06723], [-117.13565, 33.06722], [-117.13627, 33.06627], [-117.13698, 33.06604], [-117.13697, 33.0657], [-117.13751, 33.0657], [-117.13751, 33.06452], [-117.13871, 33.06451], [-117.13873, 33.06569], [-117.13792, 33.06571], [-117.13792, 33.06788], [-117.1387, 33.06788], [-117.13956, 33.06701], [-117.14139, 33.06701], [-117.14343, 33.06567], [-117.14394, 33.06566], [-117.14474, 33.0654], [-117.14511, 33.06555], [-117.14583, 33.06531], [-117.14593, 33.06542], [-117.14622, 33.06563]], [[-117.1405, 33.06924], [-117.13933, 33.06837], [-117.1387, 33.06896], [-117.14006, 33.06987], [-117.14072, 33.06942], [-117.1405, 33.06924]]], [[[-117.15278, 33.06829], [-117.15233, 33.06861], [-117.15156, 33.06775], [-117.15135, 33.06683], [-117.1491, 33.06683], [-117.1486, 33.06657], [-117.1484, 33.06641], [-117.14826, 33.06634], [-117.14797, 33.06626], [-117.14766, 33.06624], [-117.14749, 33.06621], [-117.14727, 33.06613], [-117.1463, 33.06547], [-117.14695, 33.06537], [-117.14755, 33.06577], [-117.14788, 33.0658], [-117.14829, 33.06591], [-117.14858, 33.06605], [-117.14921, 33.06644], [-117.15176, 33.06643], [-117.15202, 33.06758], [-117.15242, 33.06802], [-117.15277, 33.06777], [-117.15278, 33.06829]]], [[[-117.15278, 33.06896], [-117.15241, 33.0692], [-117.15221, 33.06918], [-117.15201, 33.06897], [-117.1524, 33.06871], [-117.15278, 33.06843], [-117.15278, 33.06896]]]]} | No Public Access 3 | 7312 | Olivenhain Dam | 23133 | 2102 | Olivenhain Municipal Water District 871 | Special District 4 | Water District 13 | http://www.olivenhain.com/ | Special District 4 | 2102 | Olivenhain Municipal Water District 849 | Special District 4 | Water District 13 | San Diego 4 | 153.269 | Olivenhain Dam | None 632 |
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]);