units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
212 rows where ACCESS_TYP = 1 and DES_TP = 16 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 212 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
222 | 222 | 221 | {"type": "MultiPolygon", "coordinates": [[[[-121.8673, 36.95006], [-121.86712, 36.95048], [-121.86682, 36.95042], [-121.86651, 36.95041], [-121.8673, 36.95006]], [[-121.86709, 36.95029], [-121.86695, 36.95026], [-121.86691, 36.95037], [-121.8671, 36.95041], [-121.86715, 36.95031], [-121.86709, 36.95029]]], [[[-121.86797, 36.95053], [-121.8677, 36.95077], [-121.86751, 36.95064], [-121.86733, 36.95055], [-121.86756, 36.95019], [-121.86775, 36.95036], [-121.86797, 36.95053]]], [[[-121.86937, 36.95145], [-121.86934, 36.95153], [-121.86929, 36.95158], [-121.86921, 36.95159], [-121.86891, 36.95152], [-121.86896, 36.95137], [-121.86937, 36.95145]]]]} | Open Access 1 | 732 | Seascape Uplands Preserve | 25249 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 0.859 | Seascape Uplands Preserve | 0 | Private Conservation 16 | 2 | |
296 | 296 | 295 | {"type": "Polygon", "coordinates": [[[-122.08006, 37.03997], [-122.08006, 37.04024], [-122.07996, 37.04025], [-122.07993, 37.04002], [-122.08006, 37.03997]]]} | Open Access 1 | 795 | Shinglemill Creek | 28175 | 3036 | Land Trust of Santa Cruz County 121 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.landtrustsantacruz.org/ | Non Governmental Organization 10 | 3036 | Land Trust of Santa Cruz County 118 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 0.071 | Shinglemill Creek | 0 | Private Conservation 16 | 2 | |
373 | 373 | 372 | {"type": "Polygon", "coordinates": [[[-116.60471, 32.647], [-116.60365, 32.64701], [-116.60374, 32.65066], [-116.60273, 32.65066], [-116.60285, 32.65426], [-116.59867, 32.65421], [-116.59854, 32.65064], [-116.59431, 32.65062], [-116.594, 32.64348], [-116.60462, 32.64364], [-116.60471, 32.647]], [[-116.60259, 32.64699], [-116.6026, 32.64698], [-116.60254, 32.64525], [-116.60039, 32.64526], [-116.60045, 32.64697], [-116.60259, 32.64699]]]} | Open Access 1 | 1332 | Hauser Mountain Wilderness Area | 19739 | 3007 | Back Country Land Trust 152 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bclt.org/ | Non Governmental Organization 10 | 3007 | Back Country Land Trust 148 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 211.322 | Hauser Mtn. Wilderness Area | 0 | Private Conservation 16 | 2 | |
642 | 642 | 641 | {"type": "Polygon", "coordinates": [[[-116.71987, 34.0913], [-116.71976, 34.10633], [-116.71018, 34.10612], [-116.70251, 34.10579], [-116.70264, 34.09125], [-116.71987, 34.0913]]]} | Open Access 1 | 2751 | San Gorgonio Wilderness | 13189 | 3092 | The Wildlands Conservancy 228 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildlandsconservancy.org/ | Non Governmental Organization 10 | 3092 | The Wildlands Conservancy 224 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 646.722 | San Gorgonio Wilderness | 0 | Private Conservation 16 | 2 | |
658 | 658 | 657 | {"type": "Polygon", "coordinates": [[[-122.1718, 37.99251], [-122.16269, 37.99253], [-122.16267, 37.98898], [-122.16654, 37.98899], [-122.16655, 37.98895], [-122.17178, 37.98893], [-122.1718, 37.99251]]]} | Open Access 1 | 3251 | Gustin | 19572 | 3045 | John Muir Land Trust 108 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.jmlt.org/ | Non Governmental Organization 10 | 3045 | John Muir Land Trust 105 | Non Profit 6 | Non Profit - Land Trust 10 | Contra Costa 12 | 78.179 | Gustin | 2000 | Private Conservation 16 | 2 | |
707 | 707 | 706 | {"type": "Polygon", "coordinates": [[[-122.48085, 38.56982], [-122.46762, 38.57004], [-122.46756, 38.56696], [-122.48078, 38.56638], [-122.48085, 38.56982]]]} | Open Access 1 | 3979 | Bruchman Cheyney Preserve | 16448 | 3035 | Land Trust of Napa County 140 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.napalandtrust.org/ | Non Governmental Organization 10 | 3035 | Land Trust of Napa County 137 | Non Profit 6 | Non Profit - Land Trust 10 | Napa 11 | 103.06 | Bruchman Cheyney Preserve | 0 | Private Conservation 16 | 2 | |
1281 | 1281 | 1280 | {"type": "Polygon", "coordinates": [[[-117.5581, 34.18262], [-117.55072, 34.18265], [-117.5507, 34.17938], [-117.55806, 34.1794], [-117.5581, 34.18262]]]} | Open Access 1 | 9910 | Richland Mitigation | 24337 | 3089 | The Habitat Trust 340 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3089 | The Habitat Trust 337 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 60.516 | Richland Mitigation | 0 | Private Conservation 16 | 2 | ||
2004 | 2004 | 2003 | {"type": "Polygon", "coordinates": [[[-120.83864, 35.3316], [-120.83864, 35.33176], [-120.83843, 35.33176], [-120.83823, 35.33167], [-120.83823, 35.33139], [-120.83864, 35.3316]]]} | Open Access 1 | 16907 | Audubon Overlook | 15703 | 3043 | Morro Coast Audubon Society 468 | Non Profit 6 | Non Profit - Conservation 12 | http://www.morrocoastaudubon.org/ | Non Governmental Organization 10 | 3043 | Morro Coast Audubon Society 461 | Non Profit 6 | Non Profit - Conservation 12 | San Luis Obispo 1 | 0.256 | Audubon Overlook | 0 | Private Conservation 16 | 2 | |
2300 | 2300 | 2299 | {"type": "Polygon", "coordinates": [[[-119.71423, 34.41147], [-119.71286, 34.41261], [-119.71211, 34.41205], [-119.71252, 34.41167], [-119.71232, 34.41149], [-119.71267, 34.41116], [-119.7132, 34.41071], [-119.71401, 34.41104], [-119.71423, 34.41147]]]} | Open Access 1 | 16932 | Honda Valley Park - Community Environmental Council | 20066 | 3015 | Community Environmental Council 508 | Non Profit 6 | Non Profit - Conservation 12 | http://www.communityenvironmentalcouncil.org/ | Non Governmental Organization 10 | 3015 | Community Environmental Council 500 | Non Profit 6 | Non Profit - Conservation 12 | Santa Barbara 7 | 5.43 | Honda Valley Park - Community Environmental Council | 0 | Private Conservation 16 | 2 | |
3238 | 3238 | 3237 | {"type": "Polygon", "coordinates": [[[-117.38418, 35.31678], [-117.38418, 35.33147], [-117.36716, 35.33147], [-117.36717, 35.31677], [-117.38418, 35.31678]]]} | Open Access 1 | 29084 | The Wildlands Conservancy | 13191 | 3092 | The Wildlands Conservancy 228 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildlandsconservancy.org/ | Non Governmental Organization 10 | 3092 | The Wildlands Conservancy 224 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 623.3 | The Wildlands Conservancy | 0 | Private Conservation 16 | 2 | |
3239 | 3239 | 3238 | {"type": "MultiPolygon", "coordinates": [[[[-118.07831, 35.73372], [-118.07746, 35.73373], [-118.07736, 35.73199], [-118.07729, 35.73024], [-118.07772, 35.73024], [-118.07792, 35.73066], [-118.07842, 35.7317], [-118.0786, 35.73222], [-118.07864, 35.73276], [-118.07855, 35.73326], [-118.07831, 35.73372]]], [[[-118.08187, 35.73369], [-118.07852, 35.73372], [-118.07873, 35.73331], [-118.07883, 35.73277], [-118.07879, 35.7322], [-118.07861, 35.73165], [-118.0781, 35.73061], [-118.07794, 35.73024], [-118.08182, 35.73018], [-118.08187, 35.73369]]]]} | Open Access 1 | 29086 | Wilderness Land Trust | 27509 | 3097 | Wilderness Land Trust 603 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildernesslandtrust.org/ | Non Governmental Organization 10 | 3097 | Wilderness Land Trust 592 | Non Profit 6 | Non Profit - Land Trust 10 | Kern 36 | 37.142 | Wilderness Land Trust | 0 | Private Conservation 16 | 2 | |
3397 | 3397 | 3396 | {"type": "Polygon", "coordinates": [[[-119.08951, 36.35464], [-119.08945, 36.35822], [-119.08502, 36.3582], [-119.08507, 36.35461], [-119.08951, 36.35464]]]} | Open Access 1 | 35099 | Hog Wallow Preserve | 20024 | 3137 | Tulare County Historical Society 636 | Non Profit 6 | Non Profit - Other 22 | http://www.tularecountyhistoricalsociety.org/ | Non Governmental Organization 10 | 3137 | Tulare County Historical Society 625 | Non Profit 6 | Non Profit - Other 20 | Tulare 29 | 39.16 | Hog Wallow Preserve | 0 | Private Conservation 16 | 2 | |
3481 | 3481 | 3480 | {"type": "Polygon", "coordinates": [[[-114.68408, 34.95295], [-114.68408, 34.95462], [-114.68316, 34.95462], [-114.68316, 34.95294], [-114.68408, 34.95295]]]} | Open Access 1 | 25849 | Wilderness Land Trust | 27509 | 3097 | Wilderness Land Trust 603 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildernesslandtrust.org/ | Non Governmental Organization 10 | 3097 | Wilderness Land Trust 592 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 3.872 | Wilderness Land Trust | 0 | Private Conservation 16 | 2 | |
3726 | 3726 | 3725 | {"type": "Polygon", "coordinates": [[[-120.49309, 39.22971], [-120.49301, 39.24425], [-120.47413, 39.24417], [-120.47436, 39.2297], [-120.49309, 39.22971]]]} | Open Access 1 | 44723 | Snow Mountain | 13418 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | Placer 35 | 646.107 | Snow Mtn. | 0 | Private Conservation 16 | 2 | |
3727 | 3727 | 3726 | {"type": "Polygon", "coordinates": [[[-120.32345, 39.33671], [-120.3234, 39.34127], [-120.32299, 39.34101], [-120.32265, 39.34077], [-120.32228, 39.34045], [-120.32201, 39.34015], [-120.32153, 39.34008], [-120.32093, 39.34003], [-120.32032, 39.34001], [-120.31971, 39.34004], [-120.31923, 39.3401], [-120.31863, 39.3402], [-120.31805, 39.34034], [-120.31771, 39.34045], [-120.31717, 39.34065], [-120.31668, 39.34088], [-120.31619, 39.34104], [-120.31568, 39.34116], [-120.31508, 39.34124], [-120.31477, 39.34125], [-120.31439, 39.34124], [-120.31401, 39.34121], [-120.31363, 39.34115], [-120.31327, 39.34106], [-120.31298, 39.34097], [-120.31264, 39.34084], [-120.31231, 39.34069], [-120.31194, 39.34048], [-120.31154, 39.3402], [-120.30974, 39.33861], [-120.30976, 39.32935], [-120.30374, 39.32937], [-120.30257, 39.32779], [-120.30047, 39.327], [-120.3005, 39.32477], [-120.30262, 39.32573], [-120.30275, 39.32582], [-120.30359, 39.32655], [-120.30369, 39.32662], [-120.30385, 39.32668], [-120.30398, 39.32683], [-120.30532, 39.32712], [-120.30547, 39.32718], [-120.30564, 39.32721], [-120.30582, 39.32721], [-120.30698, 39.32728], [-120.30714, 39.32733], [-120.30729, 39.32734], [-120.30773, 39.32733], [-120.30793, 39.32728], [-120.30813, 39.32716], [-120.30826, 39.327], [-120.3083, 39.32687], [-120.30834, 39.32652], [-120.30839, 39.32651], [-120.30858, 39.32595], [-120.30977, 39.32581], [-120.30977, 39.32935], [-120.31894, 39.32949], [-120.31887, 39.3367], [-120.32345, 39.33671]]]} | Open Access 1 | 44733 | Billy Mack Canyon | 13404 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | Nevada 30 | 332.597 | Billy Mack Canyon | 0 | Private Conservation 16 | 2 | |
3745 | 3745 | 3744 | {"type": "Polygon", "coordinates": [[[-121.75675, 37.21742], [-121.7553, 37.21865], [-121.75122, 37.22049], [-121.748, 37.22162], [-121.74813, 37.22148], [-121.74816, 37.22112], [-121.74795, 37.22061], [-121.74763, 37.22024], [-121.74748, 37.22002], [-121.74732, 37.21961], [-121.74724, 37.21882], [-121.74695, 37.21839], [-121.7466, 37.21806], [-121.74565, 37.21747], [-121.74544, 37.21728], [-121.74529, 37.21703], [-121.74527, 37.21685], [-121.74529, 37.2168], [-121.7452, 37.21672], [-121.74531, 37.21653], [-121.74608, 37.21559], [-121.74681, 37.21488], [-121.74709, 37.21504], [-121.74773, 37.21479], [-121.74862, 37.21468], [-121.74959, 37.21442], [-121.7511, 37.21422], [-121.75148, 37.21427], [-121.75296, 37.21532], [-121.75481, 37.21627], [-121.75671, 37.21733], [-121.75675, 37.21742]]]} | Open Access 1 | 31207 | Tulare Hill | 26565 | 3136 | Land Trust of Santa Clara Valley 676 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.siliconvalleylc.org/ | Non Governmental Organization 10 | 3136 | Land Trust of Santa Clara Valley 666 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Clara 19 | 117.577 | Tulare Hill | 0 | Private Conservation 16 | 2 | |
3751 | 3751 | 3750 | {"type": "Polygon", "coordinates": [[[-122.43183, 37.44426], [-122.43175, 37.44427], [-122.43168, 37.44373], [-122.43176, 37.44372], [-122.43183, 37.44426]]]} | Open Access 1 | 34834 | Coastside Land Trust | 17467 | 3029 | Coastside Land Trust 678 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.coastsidelandtrust.org | Non Governmental Organization 10 | 3029 | Coastside Land Trust 668 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.114 | Coastside Land Trust | 0 | Private Conservation 16 | 2 | |
3827 | 3827 | 3826 | {"type": "Polygon", "coordinates": [[[-120.17654, 39.32492], [-120.17487, 39.32491], [-120.17493, 39.3262], [-120.17455, 39.3262], [-120.17317, 39.32605], [-120.17283, 39.32595], [-120.17234, 39.32577], [-120.1711, 39.32519], [-120.1711, 39.32516], [-120.17155, 39.32517], [-120.17157, 39.32479], [-120.17144, 39.32478], [-120.17146, 39.32437], [-120.17653, 39.32487], [-120.17654, 39.32492]]]} | Open Access 1 | 45265 | Wintercreek Wetland | 27653 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | Nevada 30 | 11.926 | Wintercreek Wetland | 0 | Private Conservation 16 | 2 | |
3834 | 3834 | 3833 | {"type": "Polygon", "coordinates": [[[-124.12251, 41.04406], [-124.12176, 41.04463], [-124.12151, 41.04441], [-124.12099, 41.04406], [-124.12081, 41.04391], [-124.12065, 41.04375], [-124.12044, 41.04348], [-124.12027, 41.04316], [-124.1202, 41.04307], [-124.12117, 41.04308], [-124.12124, 41.04322], [-124.12149, 41.04344], [-124.1218, 41.0436], [-124.1221, 41.04381], [-124.12227, 41.04396], [-124.12251, 41.04406]]]} | Open Access 1 | 45380 | North Luffenholtz Beach | 27913 | 3203 | Trinidad Coastal Land Trust 690 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trinidadcoastallandtrust.org/ | Non Governmental Organization 10 | 3203 | Trinidad Coastal Land Trust 680 | Non Profit 6 | Non Profit - Land Trust 10 | Humboldt 45 | 3.699 | North Luffenholtz Beach | 0 | Private Conservation 16 | 2 | |
4058 | 4058 | 4057 | {"type": "Polygon", "coordinates": [[[-124.12861, 41.05046], [-124.12855, 41.05211], [-124.1267, 41.05095], [-124.12658, 41.05085], [-124.12646, 41.05069], [-124.12641, 41.05057], [-124.1264, 41.05039], [-124.12632, 41.05022], [-124.12623, 41.0501], [-124.12612, 41.04998], [-124.12577, 41.04975], [-124.12539, 41.04958], [-124.12508, 41.04939], [-124.12488, 41.04924], [-124.1247, 41.04907], [-124.12446, 41.0488], [-124.12435, 41.04863], [-124.12413, 41.04824], [-124.124, 41.04793], [-124.12393, 41.04771], [-124.12392, 41.0476], [-124.12482, 41.04671], [-124.12503, 41.04672], [-124.1253, 41.04675], [-124.1256, 41.04687], [-124.12574, 41.04699], [-124.12573, 41.04731], [-124.12526, 41.04767], [-124.12525, 41.04806], [-124.12541, 41.04821], [-124.12542, 41.04847], [-124.12546, 41.04863], [-124.1256, 41.04881], [-124.12591, 41.04914], [-124.12659, 41.04937], [-124.12769, 41.04967], [-124.128, 41.04977], [-124.1282, 41.05019], [-124.1285, 41.05033], [-124.12861, 41.05046]]]} | Open Access 1 | 44399 | Baker Beach | 15766 | 3203 | Trinidad Coastal Land Trust 690 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trinidadcoastallandtrust.org/ | Non Governmental Organization 10 | 3203 | Trinidad Coastal Land Trust 680 | Non Profit 6 | Non Profit - Land Trust 10 | Humboldt 45 | 17.458 | Baker Beach | 0 | Private Conservation 16 | 2 |
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]);