units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
969 rows where ACCESS_TYP = 3 sorted by YR_EST
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Fish and Wildlife 78
- East Bay Regional Park District 47
- Los Angeles, City of 36
- The Nature Conservancy 32
- Las Virgenes Municipal Water District 28
- Peninsula Open Space Trust 24
- Natomas Basin Conservancy 22
- Rivers and Lands Conservancy 22
- The Environmental Trust 21
- Torrance, City of 20
- Mountains Restoration Trust 20
- San Diego, City of 19
- Midpeninsula Regional Open Space District 19
- Santa Clara Valley Open Space Authority 18
- United States Fish and Wildlife Service 16
- Fresno Metropolitan Flood Control District 16
- California Department of Parks and Recreation 15
- Endangered Habitats Conservancy 14
- San Diego, County of 14
- Los Angeles County Flood Control District 13
- Kinneloa Irrigation District 13
- Santa Clara County Parks and Recreation Dept., County of 13
- American River Conservancy 13
- Save Mount Diablo 13
- Littlerock Creek Irrigation District 13
- Napa, City of 12
- Sonoma Land Trust 11
- Sonoma County Agricultural Preservation and Open Space District 11
- California Department of Water Resources 11
- Escondido, City of 10
- …
DES_TP >30
- Private Conservation 211
- Local Recreation Area 113
- Local Other or Unknown 96
- Local Park 77
- Local Conservation Area 77
- State Resource Management Area 64
- Private Recreation or Education 25
- Private Other or Unknown 25
- State Conservation Area 22
- State Other or Unknown 19
- National Wildlife Refuge 14
- Local Resource Management Area 8
- State Park 5
- Private Agricultural 5
- Resource Management Area 4
- Conservation Area 3
- Federal Other or Unknown 3
- State Historic or Cultural Area 3
- National Public Lands 2
- National Monument or Landmark 2
- State Recreation Area 1
- Recreation Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 20
- Non Profit - Land Trust 217
- City Agency 207
- State Agency 135
- Recreation/Parks District 106
- Flood District 58
- Water District 56
- Non Profit - Conservation 50
- Federal Agency 33
- Irrigation District 29
- County Agency 26
- Open Space District 22
- County Agency - Parks 18
- County Agency - Other 3
- Home Owners Association 1
- Commercial 1
- Sanitation District 1
- Non Profit - Other 1
- Joint Powers Authority 1
- Other 1
- Mitigation Bank 1
MNG_AG_LEV 8 ✖
- Special District 272
- Non Profit 268
- City 207
- State 135
- County 47
- Federal 33
- Private 4
- Joint 1
ACCESS_TYP 1
- No Public Access · 967 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
565 | 565 | 564 | {"type": "Polygon", "coordinates": [[[-121.91485, 37.97467], [-121.91485, 37.97489], [-121.91456, 37.9751], [-121.91431, 37.97535], [-121.9141, 37.97553], [-121.91345, 37.97542], [-121.91287, 37.97544], [-121.91255, 37.97534], [-121.91197, 37.97514], [-121.91169, 37.9751], [-121.9116, 37.97515], [-121.91148, 37.97518], [-121.91136, 37.97514], [-121.91103, 37.97515], [-121.9109, 37.97496], [-121.91122, 37.97496], [-121.91189, 37.97489], [-121.91232, 37.9749], [-121.91233, 37.97492], [-121.91345, 37.97494], [-121.91408, 37.97484], [-121.91485, 37.97467]]]} | No Public Access 3 | 47528 | Alaimo | 31233 | 379 | Contra Costa Department of Conservation and Development, County of 209 | County 3 | County Agency - Other 9 | http://www.cccounty.us/dcd | County 3 | 379 | Contra Costa Department of Conservation and Development, County of 205 | County 3 | County Agency - Other 8 | Contra Costa 12 | 3.763 | Alaimo | None 56 | |||
710 | 710 | 709 | {"type": "Polygon", "coordinates": [[[-122.49778, 38.11503], [-122.49513, 38.11705], [-122.49391, 38.11801], [-122.49231, 38.1192], [-122.49241, 38.1189], [-122.49275, 38.11856], [-122.49311, 38.11825], [-122.49339, 38.11787], [-122.49376, 38.11735], [-122.49389, 38.11699], [-122.49396, 38.11668], [-122.49396, 38.11519], [-122.49778, 38.11503]]]} | No Public Access 3 | 4004 | Sonoma Baylands | 25607 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Sonoma 16 | 14.555 | Sonoma Baylands | None 66 | |||
723 | 723 | 722 | {"type": "Polygon", "coordinates": [[[-122.8297, 38.43042], [-122.82526, 38.43042], [-122.82525, 38.42579], [-122.8253, 38.42547], [-122.82624, 38.42547], [-122.82716, 38.42577], [-122.82941, 38.42635], [-122.82931, 38.42976], [-122.82941, 38.43012], [-122.8297, 38.43042]]]} | No Public Access 3 | 4499 | Stone Farm | 25869 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 45.409 | Stone Farm | None 67 | |||
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 | |||
3155 | 3155 | 3154 | {"type": "Polygon", "coordinates": [[[-121.52015, 38.36105], [-121.52, 38.36138], [-121.51988, 38.36172], [-121.51976, 38.36228], [-121.51967, 38.36299], [-121.51968, 38.36374], [-121.51983, 38.36443], [-121.51986, 38.3652], [-121.51994, 38.36596], [-121.52002, 38.3666], [-121.51995, 38.36694], [-121.51977, 38.3671], [-121.51892, 38.36686], [-121.51857, 38.36669], [-121.51813, 38.36655], [-121.51157, 38.3651], [-121.51168, 38.35783], [-121.51938, 38.36011], [-121.51901, 38.36077], [-121.52015, 38.36105]]]} | No Public Access 3 | 21762 | Hood Test Facilities | 30565 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Sacramento 41 | 136.958 | Hood Test Facilities | None 257 | |||
3159 | 3159 | 3158 | {"type": "Polygon", "coordinates": [[[-121.50125, 38.31704], [-121.50005, 38.31773], [-121.49878, 38.31973], [-121.49852, 38.31959], [-121.4985, 38.3196], [-121.49847, 38.31958], [-121.4946, 38.31753], [-121.49279, 38.31453], [-121.50082, 38.31445], [-121.50125, 38.31704]]]} | No Public Access 3 | 21834 | Stone Lakes | 25871 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Sacramento 41 | 68.284 | Stone Lakes | None 259 | ||||
3312 | 3312 | 3311 | {"type": "Polygon", "coordinates": [[[-117.05061, 34.06564], [-117.05016, 34.06761], [-117.04942, 34.06795], [-117.04771, 34.06692], [-117.04766, 34.06428], [-117.04902, 34.06452], [-117.05061, 34.06564]]]} | No Public Access 3 | 29659 | Crafton Hills Reservoir | 17748 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | San Bernardino 22 | 19.391 | Crafton Hills Reservoir | None 270 | |||
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 |
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]);