superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
254 rows where ACCESS_TYP = 4
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Yuba County Water Agency 46
- Mountains Recreation and Conservation Authority 17
- National Audubon Society 13
- Save the Redwoods League 4
- Los Angeles, County of 3
- Northcoast Regional Land Trust 3
- Santa Barbara, County of 2
- Los Angeles, City of 2
- United States Fish and Wildlife Service 2
- California Department of Transportation 2
- San Diego, City of 1
- Monterey, County of 1
- United States National Park Service 1
- California State Lands Commission 1
- Center for Natural Lands Management 1
- San Diego, County of 1
- Other State 1
- Dana Point, City of 1
- Marina, City of 1
- The Wildlands Conservancy 1
- Other Federal 1
- The Habitat Trust 1
- Chico, City of 1
- San Joaquin River Parkway and Conservation Trust 1
- Mendocino Land Trust 1
- Arcata, City of 1
- Wilderness Land Trust 1
- Rio Dell, City of 1
- California Wildlife Conservation Board 1
- Helix Water District 1
- …
MNG_AG_TYP 10
ACCESS_TYP 1
- Unknown Access · 117 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10978 | 10978 | 10977 | {"type": "Polygon", "coordinates": [[[-119.71821, 36.9953], [-119.71722, 36.99589], [-119.71659, 36.99671], [-119.71588, 36.99675], [-119.7158, 36.99679], [-119.71468, 36.9959], [-119.71464, 36.9959], [-119.71464, 36.99591], [-119.71575, 36.9968], [-119.71547, 36.9969], [-119.71513, 36.99758], [-119.71582, 36.99857], [-119.71483, 36.99866], [-119.71447, 36.99918], [-119.71168, 37.00082], [-119.71099, 37.00163], [-119.70974, 37.00139], [-119.70892, 37.00087], [-119.70902, 36.99762], [-119.71017, 36.99591], [-119.71022, 36.9959], [-119.71069, 36.99548], [-119.71091, 36.99527], [-119.71103, 36.99513], [-119.7143, 36.99202], [-119.71821, 36.9953]]]} | Unknown Access 4 | Wagner | 27208 | 3069 | San Joaquin River Parkway and Conservation Trust 491 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.riverparkway.org | Non Governmental Organization 10 | 110.705 | Wagner | ||
11214 | 11214 | 11213 | {"type": "MultiPolygon", "coordinates": [[[[-115.41747, 34.16754], [-115.41528, 34.16754], [-115.41526, 34.16572], [-115.41745, 34.16572], [-115.41747, 34.16754]]], [[[-116.10126, 34.74073], [-116.10125, 34.74791], [-116.09285, 34.74777], [-116.09283, 34.74063], [-116.10126, 34.74073]]], [[[-117.90111, 35.49943], [-117.89655, 35.49938], [-117.89647, 35.49577], [-117.90107, 35.49582], [-117.90111, 35.49943]]], [[[-118.84904, 38.00675], [-118.84899, 38.01037], [-118.8444, 38.01038], [-118.84445, 38.00676], [-118.84904, 38.00675]]]]} | Unknown Access 4 | Wilderness Land Trust | 27510 | 3097 | Wilderness Land Trust 592 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildernesslandtrust.org/ | Non Governmental Organization 10 | 242.392 | Wilderness Land Trust | ||
11218 | 11218 | 11217 | {"type": "Polygon", "coordinates": [[[-121.67529, 38.41572], [-121.65678, 38.41581], [-121.64757, 38.41579], [-121.64759, 38.40116], [-121.65692, 38.40119], [-121.66608, 38.40119], [-121.66604, 38.40427], [-121.66602, 38.40849], [-121.67528, 38.40846], [-121.67529, 38.41572]]]} | Unknown Access 4 | Wildlands Inc | 27516 | 6067 | Wildlands Inc 789 | Private 7 | Mitigation Bank 28 | http://www.wildlandsinc.com/ | Private 14 | 807.493 | Wildlands Inc | ||
11219 | 11219 | 11218 | {"type": "Polygon", "coordinates": [[[-121.80876, 39.76798], [-121.80871, 39.76806], [-121.80871, 39.76814], [-121.80873, 39.76815], [-121.80863, 39.76821], [-121.80864, 39.76851], [-121.80763, 39.76852], [-121.8071, 39.76788], [-121.80738, 39.76769], [-121.8079, 39.76741], [-121.8081, 39.76735], [-121.80827, 39.76733], [-121.80829, 39.76733], [-121.8083, 39.76746], [-121.80846, 39.76763], [-121.80856, 39.76768], [-121.80866, 39.76792], [-121.80876, 39.76798]]]} | Unknown Access 4 | Wildwood Estate Preserve | 27518 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 3.111 | Wildwood Estate Preserve | ||
11428 | 11428 | 11427 | {"type": "Polygon", "coordinates": [[[-121.27748, 39.49831], [-121.27736, 39.49848], [-121.27711, 39.49873], [-121.27626, 39.49834], [-121.27659, 39.49789], [-121.27748, 39.49831]]]} | Unknown Access 4 | Yuba County Water Agency 14 | 27802 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.259 | Yuba County Water Agency 14 | ||
11429 | 11429 | 11428 | {"type": "Polygon", "coordinates": [[[-121.27862, 39.49732], [-121.27862, 39.49732], [-121.27803, 39.49771], [-121.27838, 39.49725], [-121.27858, 39.49713], [-121.27862, 39.49732]]]} | Unknown Access 4 | Yuba County Water Agency 15 | 27803 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.215 | Yuba County Water Agency 15 | ||
11430 | 11430 | 11429 | {"type": "Polygon", "coordinates": [[[-121.26491, 39.48036], [-121.25891, 39.48036], [-121.25891, 39.47936], [-121.25891, 39.47936], [-121.26491, 39.48036]]]} | Unknown Access 4 | Yuba County Water Agency 16 | 27804 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 7.055 | Yuba County Water Agency 16 | ||
11431 | 11431 | 11430 | {"type": "Polygon", "coordinates": [[[-121.46836, 39.02634], [-121.46836, 39.02634], [-121.46513, 39.02109], [-121.46532, 39.02102], [-121.46835, 39.02597], [-121.46836, 39.02634]]]} | Unknown Access 4 | Yuba County Water Agency 17 | 27805 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2.743 | Yuba County Water Agency 17 | ||
11443 | 11443 | 11442 | {"type": "Polygon", "coordinates": [[[-121.28772, 39.49953], [-121.28629, 39.49959], [-121.28627, 39.49819], [-121.28769, 39.49815], [-121.28772, 39.49953]]]} | Unknown Access 4 | Yuba County Water Agency 18 | 27806 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 4.675 | Yuba County Water Agency 18 | ||
11452 | 11452 | 11451 | {"type": "Polygon", "coordinates": [[[-121.26373, 39.48345], [-121.26077, 39.48344], [-121.26057, 39.48328], [-121.25903, 39.48255], [-121.26008, 39.48202], [-121.26034, 39.4819], [-121.26043, 39.48155], [-121.26023, 39.48131], [-121.2599, 39.48119], [-121.25891, 39.48101], [-121.25891, 39.48036], [-121.26368, 39.48036], [-121.26373, 39.48345]]]} | Unknown Access 4 | Yuba County Water Agency 1 | 27797 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 29.015 | Yuba County Water Agency 1 | ||
11453 | 11453 | 11452 | {"type": "Polygon", "coordinates": [[[-121.47367, 39.03416], [-121.47326, 39.03431], [-121.46836, 39.02634], [-121.46836, 39.02597], [-121.4706, 39.0296], [-121.47089, 39.02975], [-121.47107, 39.02997], [-121.47103, 39.03029], [-121.47317, 39.03388], [-121.47367, 39.03416]]]} | Unknown Access 4 | Yuba County Water Agency 10 | 27798 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 4.608 | Yuba County Water Agency 10 | ||
11454 | 11454 | 11453 | {"type": "Polygon", "coordinates": [[[-121.19523, 39.33117], [-121.19468, 39.33535], [-121.19452, 39.33532], [-121.19433, 39.33535], [-121.19414, 39.33548], [-121.194, 39.33561], [-121.19383, 39.33565], [-121.19363, 39.3356], [-121.1937, 39.33544], [-121.19369, 39.3352], [-121.19358, 39.33483], [-121.19334, 39.33452], [-121.19295, 39.33364], [-121.19253, 39.33317], [-121.19246, 39.33298], [-121.19256, 39.33309], [-121.19277, 39.33325], [-121.19307, 39.33344], [-121.19345, 39.33358], [-121.19372, 39.33364], [-121.1939, 39.3336], [-121.19393, 39.33358], [-121.19399, 39.33347], [-121.194, 39.33342], [-121.19396, 39.33326], [-121.1937, 39.33285], [-121.19363, 39.33258], [-121.19357, 39.33229], [-121.19356, 39.33191], [-121.19352, 39.33154], [-121.19355, 39.33136], [-121.19361, 39.33129], [-121.1938, 39.33122], [-121.19407, 39.33119], [-121.19452, 39.33108], [-121.19489, 39.33111], [-121.19523, 39.33117]]]} | Unknown Access 4 | Yuba County Water Agency 11 | 27799 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 14.691 | Yuba County Water Agency 11 | ||
11455 | 11455 | 11454 | {"type": "Polygon", "coordinates": [[[-121.27315, 39.48143], [-121.27314, 39.48349], [-121.26373, 39.48345], [-121.2637, 39.48142], [-121.27315, 39.48143]]]} | Unknown Access 4 | Yuba County Water Agency 13 | 27801 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 45.631 | Yuba County Water Agency 13 | ||
11456 | 11456 | 11455 | {"type": "Polygon", "coordinates": [[[-121.29311, 39.25371], [-121.29294, 39.2539], [-121.29268, 39.25388], [-121.29234, 39.2538], [-121.292, 39.25364], [-121.29171, 39.25346], [-121.29143, 39.25326], [-121.29142, 39.25285], [-121.29189, 39.25325], [-121.29211, 39.25341], [-121.29257, 39.25363], [-121.29289, 39.2537], [-121.29311, 39.25371]]]} | Unknown Access 4 | Yuba County Water Agency 19 | 27807 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 1.079 | Yuba County Water Agency 19 | ||
11457 | 11457 | 11456 | {"type": "Polygon", "coordinates": [[[-121.33233, 39.44338], [-121.33233, 39.44361], [-121.3318, 39.44361], [-121.3318, 39.44338], [-121.33233, 39.44338]]]} | Unknown Access 4 | Yuba County Water Agency 2 | 27808 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.291 | Yuba County Water Agency 2 | ||
11458 | 11458 | 11457 | {"type": "Polygon", "coordinates": [[[-121.19527, 39.33087], [-121.19525, 39.331], [-121.19493, 39.33095], [-121.19451, 39.33091], [-121.19403, 39.33103], [-121.19375, 39.33106], [-121.19348, 39.33116], [-121.19335, 39.3313], [-121.19331, 39.33152], [-121.19335, 39.33192], [-121.19336, 39.3323], [-121.19349, 39.3329], [-121.19377, 39.33332], [-121.19379, 39.33342], [-121.19376, 39.33347], [-121.19354, 39.33343], [-121.19317, 39.3333], [-121.19292, 39.33314], [-121.19273, 39.33299], [-121.19259, 39.33284], [-121.19234, 39.3328], [-121.19228, 39.33282], [-121.19225, 39.33288], [-121.19225, 39.333], [-121.19234, 39.33325], [-121.19276, 39.33371], [-121.19314, 39.33458], [-121.19338, 39.33489], [-121.19348, 39.33521], [-121.19349, 39.33542], [-121.19339, 39.33563], [-121.19339, 39.33567], [-121.19341, 39.33571], [-121.19345, 39.33573], [-121.19385, 39.33582], [-121.19412, 39.33575], [-121.19442, 39.3355], [-121.19452, 39.33549], [-121.19466, 39.33552], [-121.19451, 39.33671], [-121.19418, 39.33677], [-121.19405, 39.33696], [-121.19377, 39.33714], [-121.19349, 39.33708], [-121.19303, 39.33702], [-121.19255, 39.3368], [-121.19204, 39.33663], [-121.19169, 39.33661], [-121.1914, 39.33671], [-121.19105, 39.33663], [-121.19067, 39.33218], [-121.19163, 39.33225], [-121.19187, 39.33099], [-121.19192, 39.33103], [-121.19198, 39.33104], [-121.19242, 39.33099], [-121.19268, 39.33086], [-121.193, 39.33073], [-121.19342, 39.33066], [-121.1939, 39.33064], [-121.19427, 39.33064], [-121.19476, 39.33074], [-121.19527, 39.33087]]]} | Unknown Access 4 | Yuba County Water Agency 20 | 27809 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 35.235 | Yuba County Water Agency 20 | ||
11459 | 11459 | 11458 | {"type": "Polygon", "coordinates": [[[-121.2633, 39.4399], [-121.26298, 39.44032], [-121.26282, 39.44033], [-121.26271, 39.44023], [-121.26276, 39.43992], [-121.2633, 39.4399]]]} | Unknown Access 4 | Yuba County Water Agency 21 | 27810 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.391 | Yuba County Water Agency 21 | ||
11460 | 11460 | 11459 | {"type": "Polygon", "coordinates": [[[-121.27856, 39.49702], [-121.27829, 39.49721], [-121.2775, 39.49687], [-121.27778, 39.49658], [-121.27854, 39.49693], [-121.27856, 39.49702]]]} | Unknown Access 4 | Yuba County Water Agency 22 | 27811 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.771 | Yuba County Water Agency 22 | ||
11461 | 11461 | 11460 | {"type": "Polygon", "coordinates": [[[-121.26021, 39.48175], [-121.26013, 39.48186], [-121.25966, 39.48201], [-121.25908, 39.48231], [-121.25893, 39.48241], [-121.25892, 39.48267], [-121.25837, 39.48299], [-121.25892, 39.48344], [-121.25524, 39.48339], [-121.25431, 39.48275], [-121.25488, 39.48191], [-121.25549, 39.48189], [-121.25594, 39.48185], [-121.25652, 39.48174], [-121.256, 39.48003], [-121.25695, 39.47864], [-121.2589, 39.47905], [-121.25891, 39.48113], [-121.26003, 39.48142], [-121.26014, 39.48149], [-121.2602, 39.48164], [-121.26021, 39.48175]]]} | Unknown Access 4 | Yuba County Water Agency 23 | 27812 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 35.849 | Yuba County Water Agency 23 | ||
11462 | 11462 | 11461 | {"type": "Polygon", "coordinates": [[[-121.27764, 39.49673], [-121.27738, 39.49699], [-121.2765, 39.49656], [-121.27672, 39.49629], [-121.27764, 39.49673]]]} | Unknown Access 4 | Yuba County Water Agency 24 | 27813 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.816 | Yuba County Water Agency 24 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);