units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
27 rows where ACCESS_TYP = 1, DES_TP = 16 and MNG_AG_TYP = 12 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4322 | 4322 | 4321 | {"type": "Polygon", "coordinates": [[[-123.7274, 39.24845], [-123.72682, 39.2487], [-123.72662, 39.2486], [-123.72645, 39.24844], [-123.72609, 39.24815], [-123.72594, 39.24806], [-123.72562, 39.24794], [-123.72529, 39.24766], [-123.72488, 39.24741], [-123.72471, 39.24728], [-123.72437, 39.24658], [-123.72419, 39.2464], [-123.72412, 39.2462], [-123.72418, 39.24532], [-123.72483, 39.24527], [-123.72523, 39.24513], [-123.7251, 39.24577], [-123.72525, 39.24628], [-123.72568, 39.24692], [-123.72603, 39.24724], [-123.72638, 39.24732], [-123.72713, 39.24796], [-123.72724, 39.24812], [-123.72735, 39.24824], [-123.7274, 39.24845]]]} | Open Access 1 | 45424 | Albert Cattalini Conservancy | 28204 | 3353 | Friends of the Enchanted Meadow 744 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofenchantedmeadow.org/ | Non Governmental Organization 10 | 3353 | Friends of the Enchanted Meadow 730 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofenchantedmeadow.org/acc.html | Mendocino 24 | 9.326 | Albert Cattalini Conservancy | 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 | |
12627 | 12627 | 12626 | {"type": "Polygon", "coordinates": [[[-121.59056, 38.93189], [-121.5906, 38.93226], [-121.5905, 38.93257], [-121.58881, 38.9345], [-121.58881, 38.93507], [-121.58837, 38.93799], [-121.58941, 38.93802], [-121.58918, 38.93942], [-121.5886, 38.94166], [-121.58757, 38.94166], [-121.5872, 38.94279], [-121.58627, 38.94382], [-121.58599, 38.9453], [-121.58627, 38.94629], [-121.58627, 38.94645], [-121.58543, 38.95098], [-121.58543, 38.95121], [-121.58153, 38.95118], [-121.58154, 38.94959], [-121.5814, 38.94798], [-121.58105, 38.94658], [-121.58131, 38.94392], [-121.58114, 38.94224], [-121.58144, 38.94044], [-121.58217, 38.93847], [-121.5824, 38.93679], [-121.58241, 38.93581], [-121.58258, 38.93403], [-121.58245, 38.9327], [-121.58218, 38.93214], [-121.58228, 38.93118], [-121.58258, 38.92952], [-121.58295, 38.92734], [-121.58271, 38.92592], [-121.58192, 38.92389], [-121.58068, 38.92187], [-121.58329, 38.92253], [-121.58302, 38.92368], [-121.5833, 38.92433], [-121.58386, 38.92526], [-121.58628, 38.9281], [-121.58753, 38.92948], [-121.58931, 38.93031], [-121.58967, 38.93045], [-121.58962, 38.93068], [-121.58981, 38.9309], [-121.58977, 38.93102], [-121.59056, 38.93189]]]} | Open Access 1 | 29423 | Bobelaine Sanctuary | 7436 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://www.sacramentoaudubon.org/bobelainesanctuary.html | Sutter 47 | 353.691 | Bobelaine Sanctuary | 0 | Private Conservation 16 | 2 |
15167 | 15167 | 15166 | {"type": "Polygon", "coordinates": [[[-117.27449, 33.09512], [-117.27025, 33.09505], [-117.27019, 33.09492], [-117.27019, 33.09488], [-117.27023, 33.09483], [-117.27016, 33.09464], [-117.27011, 33.09465], [-117.27011, 33.09307], [-117.2703, 33.09301], [-117.27048, 33.09283], [-117.27071, 33.09282], [-117.27099, 33.09295], [-117.27164, 33.09308], [-117.2715, 33.09331], [-117.27151, 33.09332], [-117.27233, 33.09353], [-117.27312, 33.09348], [-117.27325, 33.09329], [-117.27351, 33.09329], [-117.27355, 33.09311], [-117.27415, 33.09307], [-117.27413, 33.09316], [-117.27439, 33.09325], [-117.27448, 33.09326], [-117.27449, 33.09512]]]} | Open Access 1 | 47291 | Cholla Point | 30996 | 3220 | Batiquitos Lagoon Foundation 1138 | Non Profit 6 | Non Profit - Conservation 12 | http://www.batiquitosfoundation.org/about/ | Non Governmental Organization 10 | 3220 | Batiquitos Lagoon Foundation 1093 | Non Profit 6 | Non Profit - Conservation 12 | http://www.batiquitosfoundation.org/category/visit/ | San Diego 4 | 20.824 | Cholla Point | 2011 | Private Conservation 16 | 2 |
7264 | 7264 | 7263 | {"type": "MultiPolygon", "coordinates": [[[[-118.65021, 34.08185], [-118.65013, 34.08198], [-118.65008, 34.08213], [-118.65006, 34.0823], [-118.65007, 34.08241], [-118.65009, 34.08246], [-118.65003, 34.08235], [-118.65002, 34.08197], [-118.65014, 34.08187], [-118.65021, 34.08185]]], [[[-118.65736, 34.08538], [-118.65734, 34.08544], [-118.65729, 34.08549], [-118.65726, 34.08542], [-118.65736, 34.08535], [-118.65736, 34.08538]]], [[[-118.65896, 34.08425], [-118.65895, 34.08591], [-118.65804, 34.08607], [-118.65786, 34.08607], [-118.65767, 34.08602], [-118.6575, 34.0859], [-118.65737, 34.08568], [-118.65749, 34.08557], [-118.65754, 34.08545], [-118.65755, 34.08537], [-118.65754, 34.08523], [-118.65896, 34.08425]]], [[[-118.66492, 34.08695], [-118.6649, 34.08702], [-118.66483, 34.08713], [-118.66363, 34.08819], [-118.6635, 34.08827], [-118.66334, 34.08832], [-118.66323, 34.08835], [-118.66224, 34.08836], [-118.66224, 34.0878], [-118.66072, 34.0878], [-118.66049, 34.08838], [-118.66037, 34.08836], [-118.65894, 34.08836], [-118.65895, 34.08608], [-118.65937, 34.08602], [-118.65981, 34.08601], [-118.6601, 34.08604], [-118.66349, 34.08682], [-118.66362, 34.08683], [-118.66385, 34.08681], [-118.66401, 34.08676], [-118.66441, 34.0866], [-118.66458, 34.08659], [-118.66471, 34.08662], [-118.66482, 34.08669], [-118.66491, 34.08683], [-118.66492, 34.08695]]], [[[-118.66233, 34.08853], [-118.66171, 34.08892], [-118.66067, 34.08891], [-118.66079, 34.08864], [-118.66085, 34.08855], [-118.66101, 34.08843], [-118.66119, 34.08837], [-118.66141, 34.08837], [-118.66184, 34.08849], [-118.66201, 34.08852], [-118.66233, 34.08853]]], [[[-118.68915, 34.09263], [-118.68772, 34.09262], [-118.68767, 34.08899], [-118.68912, 34.089], [-118.68915, 34.09263]]], [[[-118.66491, 34.09108], [-118.66491, 34.09257], [-118.66426, 34.09257], [-118.66426, 34.09108], [-118.66491, 34.09108]]], [[[-118.66333, 34.09256], [-118.66332, 34.09502], [-118.66215, 34.0959], [-118.66113, 34.09529], [-118.6611, 34.09257], [-118.66333, 34.09256]]], [[[-118.67966, 34.09259], [-118.6796, 34.09277], [-118.67948, 34.09301], [-118.67936, 34.09315], [-118.67907, 34.09335], [-118.67893, 34.0935], [-118.67888, 34.09358], [-118.67883, 34.09372], [-118.67881, 34.09383], [-118.67874, 34.09398], [-118.67849, 34.09425], [-118.6784, 34.0944], [-118.67837, 34.09458], [-118.67841, 34.09475], [-118.67843, 34.09487], [-118.67831, 34.09546], [-118.67828, 34.09555], [-118.67823, 34.09562], [-118.67805, 34.09574], [-118.67795, 34.09583], [-118.67778, 34.09602], [-118.67771, 34.09606], [-118.67763, 34.09605], [-118.6774, 34.0959], [-118.6773, 34.09587], [-118.67717, 34.09587], [-118.67655, 34.09603], [-118.67644, 34.09608], [-118.67632, 34.09618], [-118.67632, 34.09259], [-118.67966, 34.09259]]], [[[-118.6717, 34.09258], [-118.67167, 34.09519], [-118.67124, 34.0953], [-118.67106, 34.09561], [-118.67001, 34.09608], [-118.66975, 34.09731], [-118.66902, 34.09744], [-118.66843, 34.09618], [-118.66768, 34.09617], [-118.66774, 34.09258], [-118.66547, 34.09257], [-118.66545, 34.09076], [-118.66336, 34.09075], [-118.66338, 34.08893], [-118.66781, 34.08895], [-118.66774, 34.09257], [-118.6717, 34.09258]]], [[[-118.65894, 34.0962], [-118.65894, 34.09763], [-118.65757, 34.09764], [-118.65788, 34.09915], [-118.65767, 34.09918], [-118.65764, 34.09963], [-118.65781, 34.09996], [-118.65782, 34.10125], [-118.65596, 34.10138], [-118.65595, 34.10017], [-118.65399, 34.10017], [-118.65381, 34.09982], [-118.65372, 34.0995], [-118.6536, 34.09887], [-118.65347, 34.09858], [-118.65338, 34.09844], [-118.6532, 34.09824], [-118.6528, 34.09792], [-118.6526, 34.09773], [-118.65252, 34.09763], [-118.65241, 34.09747], [-118.65231, 34.09724], [-118.65224, 34.09694], [-118.65224, 34.09661], [-118.65228, 34.09642], [-118.65234, 34.09627], [-118.65894, 34.0962]]], [[[-118.65376, 34.10016], [-118.65023, 34.10257], [-118.65024, 34.10212], [-118.65027, 34.10211], [-118.65031, 34.10207], [-118.6504, 34.10191], [-118.65047, 34.1017], [-118.65048, 34.10161], [-118.65045, 34.10148], [-118.65033, 34.10133], [-118.65027, 34.10113], [-118.65026, 34.10113], [-118.65028, 34.10084], [-118.65022, 34.10073], [-118.65017, 34.09629], [-118.65214, 34.09627], [-118.65211, 34.09632], [-118.65206, 34.09653], [-118.65203, 34.09677], [-118.65203, 34.09689], [-118.65209, 34.09722], [-118.65218, 34.09746], [-118.65235, 34.09773], [-118.65253, 34.09792], [-118.653, 34.09831], [-118.65326, 34.0986], [-118.65335, 34.09876], [-118.6534, 34.09893], [-118.65358, 34.09974], [-118.65365, 34.09993], [-118.65376, 34.10016]]]]} | Open Access 1 | 6452 | Cold Creek Canyon Preserve | 7257 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 244.211 | Cold Creek Canyon Preserve | 0 | Private Conservation 16 | 2 | |
13193 | 13193 | 13192 | {"type": "Polygon", "coordinates": [[[-121.97332, 36.57802], [-121.97338, 36.57809], [-121.97338, 36.57814], [-121.97336, 36.57819], [-121.97331, 36.57824], [-121.97312, 36.57833], [-121.97302, 36.57843], [-121.97297, 36.57853], [-121.97293, 36.57871], [-121.97263, 36.57919], [-121.97258, 36.57922], [-121.97253, 36.57924], [-121.97246, 36.57923], [-121.97242, 36.57921], [-121.9721, 36.57881], [-121.97039, 36.57694], [-121.97018, 36.57673], [-121.97014, 36.57667], [-121.97012, 36.57657], [-121.97014, 36.57584], [-121.97018, 36.57573], [-121.97027, 36.57565], [-121.97038, 36.5756], [-121.97052, 36.57559], [-121.97066, 36.57564], [-121.97074, 36.57569], [-121.97096, 36.57594], [-121.97118, 36.57611], [-121.97227, 36.57678], [-121.97236, 36.57686], [-121.97251, 36.57711], [-121.97271, 36.57731], [-121.97281, 36.57755], [-121.97292, 36.57771], [-121.97307, 36.57787], [-121.97332, 36.57802]]]} | Open Access 1 | 35190 | Crocker Grove | 28538 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 12.522 | Crocker Grove | 0 | Private Conservation 16 | 2 | |
14773 | 14773 | 14772 | {"type": "MultiPolygon", "coordinates": [[[[-116.71619, 33.01052], [-116.71311, 33.01051], [-116.71298, 33.01087], [-116.71291, 33.01114], [-116.7129, 33.01123], [-116.71292, 33.01143], [-116.71288, 33.0116], [-116.71271, 33.01194], [-116.7126, 33.01224], [-116.71221, 33.01294], [-116.71213, 33.01311], [-116.71205, 33.01344], [-116.71198, 33.01388], [-116.71181, 33.0144], [-116.71154, 33.01493], [-116.71136, 33.01535], [-116.71112, 33.01578], [-116.71105, 33.01597], [-116.71105, 33.01621], [-116.71102, 33.01631], [-116.71096, 33.01641], [-116.71083, 33.01652], [-116.71013, 33.01699], [-116.71007, 33.01705], [-116.71002, 33.01713], [-116.71002, 33.01738], [-116.70999, 33.01765], [-116.71004, 33.01791], [-116.71005, 33.01811], [-116.71002, 33.01833], [-116.70993, 33.01854], [-116.70353, 33.01855], [-116.70349, 33.01762], [-116.69891, 33.01739], [-116.69463, 33.01713], [-116.69446, 33.01356], [-116.69883, 33.01382], [-116.69878, 33.01021], [-116.7032, 33.01041], [-116.7032, 33.01033], [-116.70323, 33.01035], [-116.70324, 33.01034], [-116.70312, 33.00677], [-116.70742, 33.00681], [-116.70744, 33.0068], [-116.70745, 33.00592], [-116.70753, 33.0034], [-116.71605, 33.00347], [-116.71604, 33.00691], [-116.71619, 33.01052]]], [[[-116.70372, 33.02414], [-116.70342, 33.02421], [-116.70329, 33.02425], [-116.70318, 33.02432], [-116.70301, 33.02447], [-116.70288, 33.02454], [-116.7019, 33.02486], [-116.70177, 33.02487], [-116.70164, 33.02486], [-116.70108, 33.02469], [-116.70083, 33.02465], [-116.7006, 33.02465], [-116.7004, 33.02467], [-116.70021, 33.02471], [-116.7, 33.02478], [-116.69967, 33.02492], [-116.69932, 33.02499], [-116.69919, 33.02096], [-116.70363, 33.02122], [-116.70372, 33.02414]]], [[[-116.69329, 33.03558], [-116.69433, 33.03561], [-116.69434, 33.03923], [-116.6944, 33.04285], [-116.68686, 33.04272], [-116.68681, 33.0391], [-116.69112, 33.03917], [-116.69107, 33.03554], [-116.69329, 33.03558]]]]} | Open Access 1 | 45148 | Eagle Peak Preserve | 29186 | 3206 | San Diego River Park Foundation 804 | Non Profit 6 | Non Profit - Conservation 12 | http://sandiegoriver.org/ | Non Governmental Organization 10 | 3206 | San Diego River Park Foundation 784 | Non Profit 6 | Non Profit - Conservation 12 | http://sandiegoriver.org/eagle_peak_preserve.html | San Diego 4 | 628.58 | Eagle Peak Preserve | 0 | Private Conservation 16 | 2 |
5396 | 5396 | 5395 | {"type": "Polygon", "coordinates": [[[-116.66936, 33.04929], [-116.66932, 33.05292], [-116.66506, 33.05292], [-116.6651, 33.04926], [-116.66936, 33.04929]]]} | Open Access 1 | 47901 | Eagle Peak Ranch | 31865 | 3206 | San Diego River Park Foundation 804 | Non Profit 6 | Non Profit - Conservation 12 | http://sandiegoriver.org/ | Non Governmental Organization 10 | 3206 | San Diego River Park Foundation 784 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 39.718 | Eagle Peak Ranch | 0 | Private Conservation 16 | 2 | |
9028 | 9028 | 9027 | {"type": "MultiPolygon", "coordinates": [[[[-119.74064, 34.41671], [-119.74031, 34.41686], [-119.73904, 34.41703], [-119.73839, 34.41663], [-119.73612, 34.41668], [-119.7352, 34.41626], [-119.73361, 34.41603], [-119.73287, 34.41495], [-119.73222, 34.41295], [-119.73218, 34.41275], [-119.73247, 34.4127], [-119.73248, 34.41269], [-119.73235, 34.41229], [-119.73203, 34.41235], [-119.73112, 34.40956], [-119.73153, 34.40876], [-119.73163, 34.4086], [-119.73319, 34.40542], [-119.73358, 34.4048], [-119.7358, 34.40549], [-119.73778, 34.40551], [-119.73808, 34.40569], [-119.7388, 34.40586], [-119.739, 34.4065], [-119.73876, 34.40687], [-119.73882, 34.40722], [-119.73942, 34.40787], [-119.73957, 34.40862], [-119.73951, 34.40901], [-119.73976, 34.40915], [-119.74007, 34.41042], [-119.74014, 34.4115], [-119.74007, 34.41242], [-119.7399, 34.41364], [-119.73996, 34.41482], [-119.74021, 34.41566], [-119.74052, 34.41646], [-119.74064, 34.41671]]], [[[-119.74137, 34.41009], [-119.74113, 34.41154], [-119.74095, 34.41195], [-119.74073, 34.4121], [-119.74118, 34.41239], [-119.74022, 34.41378], [-119.74028, 34.41316], [-119.74054, 34.4114], [-119.74052, 34.4107], [-119.74033, 34.40938], [-119.74137, 34.41009]]]]} | Open Access 1 | 14943 | Elings Park - Elings Park Foundation | 3471 | 3018 | Elings Park Foundation 901 | Non Profit 6 | Non Profit - Conservation 12 | http://www.elingspark.org/ | Non Governmental Organization 10 | 3018 | Elings Park Foundation 875 | Non Profit 6 | Non Profit - Conservation 12 | http://www.elingspark.org/ | Santa Barbara 7 | 217.263 | Elings Park - Elings Park Foundation | 0 | Private Conservation 16 | 2 |
11226 | 11226 | 11225 | {"type": "Polygon", "coordinates": [[[-121.20019, 38.71522], [-121.20005, 38.71565], [-121.19981, 38.71561], [-121.19954, 38.7156], [-121.19959, 38.71518], [-121.20019, 38.71522]]]} | Open Access 1 | 21564 | Elsami | 18603 | 3056 | Placer Legacy 969 | Non Profit 6 | Non Profit - Conservation 12 | http://www.placer.ca.gov/departments/communitydevelopment/planning/placerlegacy | Non Governmental Organization 10 | 3056 | Placer Legacy 935 | Non Profit 6 | Non Profit - Conservation 12 | Placer 35 | 0.573 | Elsami | 0 | Private Conservation 16 | 2 | |
9139 | 9139 | 9138 | {"type": "Polygon", "coordinates": [[[-123.64935, 38.84992], [-123.64931, 38.84997], [-123.64904, 38.85012], [-123.6491, 38.8502], [-123.64922, 38.8503], [-123.64935, 38.85043], [-123.64926, 38.85052], [-123.64925, 38.85081], [-123.64913, 38.85087], [-123.64879, 38.8509], [-123.6488, 38.85097], [-123.64889, 38.851], [-123.64926, 38.851], [-123.64932, 38.85103], [-123.64924, 38.85123], [-123.64905, 38.85129], [-123.64886, 38.85128], [-123.64865, 38.85135], [-123.64865, 38.8514], [-123.64859, 38.85151], [-123.64858, 38.8516], [-123.64874, 38.85164], [-123.64862, 38.8517], [-123.64861, 38.85178], [-123.6485, 38.85183], [-123.64834, 38.85186], [-123.64822, 38.85194], [-123.64778, 38.85177], [-123.6477, 38.85162], [-123.64757, 38.85111], [-123.64735, 38.85059], [-123.64703, 38.8501], [-123.64817, 38.84956], [-123.6482, 38.84968], [-123.64816, 38.84975], [-123.64816, 38.84981], [-123.64797, 38.84979], [-123.64779, 38.84979], [-123.64762, 38.85], [-123.64765, 38.85012], [-123.64778, 38.85034], [-123.64793, 38.85047], [-123.64806, 38.85051], [-123.64829, 38.85043], [-123.64844, 38.85027], [-123.64843, 38.85018], [-123.64865, 38.85004], [-123.64885, 38.84997], [-123.64907, 38.84994], [-123.64935, 38.84992]]]} | Open Access 1 | 48998 | Hearn Gulch | 33693 | 3303 | Redwood Coast Land Conservancy 904 | Non Profit 6 | Non Profit - Conservation 12 | http://www.rc-lc.org/ | Non Governmental Organization 10 | 3303 | Redwood Coast Land Conservancy 879 | Non Profit 6 | Non Profit - Conservation 12 | https://www.rclc.org/hearn-gulch/ | Mendocino 24 | 6.409 | Hearn Gulch | 2008 | 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 | |
8221 | 8221 | 8220 | {"type": "MultiPolygon", "coordinates": [[[[-118.79353, 34.10389], [-118.79325, 34.10389], [-118.79326, 34.10354], [-118.79331, 34.10363], [-118.79353, 34.10389]]], [[[-118.79327, 34.10281], [-118.79334, 34.10283], [-118.79337, 34.10289], [-118.79326, 34.10337], [-118.79327, 34.10281]]], [[[-118.79771, 34.10032], [-118.79768, 34.1021], [-118.79548, 34.10211], [-118.79546, 34.10387], [-118.79547, 34.10388], [-118.79766, 34.10387], [-118.7977, 34.11082], [-118.7945, 34.11083], [-118.7934, 34.11007], [-118.79339, 34.10939], [-118.7942, 34.10916], [-118.7942, 34.10881], [-118.79409, 34.1085], [-118.79443, 34.10813], [-118.79433, 34.10766], [-118.79444, 34.1074], [-118.79566, 34.10706], [-118.79561, 34.10691], [-118.79515, 34.10684], [-118.79483, 34.10643], [-118.79506, 34.1064], [-118.79517, 34.10621], [-118.79502, 34.10597], [-118.7951, 34.10593], [-118.79516, 34.10586], [-118.79521, 34.10579], [-118.79523, 34.1057], [-118.79525, 34.10497], [-118.79523, 34.10486], [-118.79516, 34.10476], [-118.79543, 34.10459], [-118.79534, 34.10451], [-118.79538, 34.1045], [-118.79538, 34.10447], [-118.79516, 34.10435], [-118.79501, 34.10437], [-118.79506, 34.10456], [-118.79517, 34.10455], [-118.7951, 34.10461], [-118.79513, 34.10473], [-118.79491, 34.1045], [-118.79476, 34.10439], [-118.79406, 34.10411], [-118.79397, 34.10405], [-118.79363, 34.10373], [-118.79347, 34.10353], [-118.79345, 34.10343], [-118.79357, 34.10288], [-118.79355, 34.10279], [-118.79348, 34.10272], [-118.79339, 34.10266], [-118.79328, 34.10264], [-118.79331, 34.10094], [-118.79344, 34.10085], [-118.79355, 34.1007], [-118.79359, 34.10067], [-118.79365, 34.10067], [-118.79391, 34.10071], [-118.79408, 34.10069], [-118.79418, 34.10065], [-118.79454, 34.10044], [-118.79479, 34.10034], [-118.79771, 34.10032]]]]} | Open Access 1 | 12511 | La Sierra Canyon Wetlands | 28951 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 83.34 | La Sierra Canyon Wetlands | 0 | Private Conservation 16 | 2 | |
9640 | 9640 | 9639 | {"type": "Polygon", "coordinates": [[[-122.4913, 37.96048], [-122.49049, 37.9606], [-122.48972, 37.96061], [-122.48972, 37.96425], [-122.48836, 37.96425], [-122.48826, 37.9606], [-122.48723, 37.96061], [-122.48721, 37.95839], [-122.49058, 37.95832], [-122.4913, 37.96048]]]} | Open Access 1 | 16223 | Marin Audubon Society | 30324 | 3039 | Marin Audubon Society 261 | Non Profit 6 | Non Profit - Conservation 12 | http://www.marinaudubon.org | Non Governmental Organization 10 | 3039 | Marin Audubon Society 257 | Non Profit 6 | Non Profit - Conservation 12 | Marin 23 | 32.569 | Marin Audubon Society | 0 | Private Conservation 16 | 2 | |
14822 | 14822 | 14821 | {"type": "Polygon", "coordinates": [[[-122.69118, 37.9329], [-122.68888, 37.93441], [-122.67482, 37.94751], [-122.66036, 37.93681], [-122.66163, 37.93601], [-122.66163, 37.93599], [-122.65724, 37.93353], [-122.65725, 37.9335], [-122.6572, 37.93347], [-122.65775, 37.93261], [-122.65787, 37.93201], [-122.66228, 37.92912], [-122.66557, 37.92719], [-122.66568, 37.92715], [-122.66657, 37.92673], [-122.66708, 37.92652], [-122.66955, 37.92521], [-122.67289, 37.92396], [-122.67443, 37.92344], [-122.67464, 37.92389], [-122.67503, 37.92435], [-122.67516, 37.9246], [-122.67551, 37.92494], [-122.67583, 37.92515], [-122.67596, 37.92522], [-122.67608, 37.92525], [-122.67657, 37.92529], [-122.677, 37.92529], [-122.67779, 37.9252], [-122.67879, 37.92521], [-122.67907, 37.92527], [-122.67913, 37.92531], [-122.67927, 37.92537], [-122.67975, 37.92569], [-122.6799, 37.92577], [-122.68007, 37.92582], [-122.6803, 37.92595], [-122.68035, 37.926], [-122.6804, 37.92609], [-122.68043, 37.92618], [-122.68043, 37.92635], [-122.68049, 37.92644], [-122.68101, 37.927], [-122.68148, 37.92737], [-122.68185, 37.92762], [-122.68199, 37.92778], [-122.68205, 37.92791], [-122.68208, 37.92809], [-122.68207, 37.92836], [-122.68203, 37.92864], [-122.682, 37.92902], [-122.68201, 37.92914], [-122.68206, 37.92934], [-122.68211, 37.92948], [-122.68223, 37.92966], [-122.68246, 37.92987], [-122.68274, 37.93004], [-122.68314, 37.93023], [-122.68387, 37.93053], [-122.68406, 37.93058], [-122.68427, 37.9306], [-122.68457, 37.93059], [-122.68522, 37.93045], [-122.68529, 37.93085], [-122.68565, 37.93107], [-122.68592, 37.93102], [-122.68642, 37.93039], [-122.68675, 37.93041], [-122.68792, 37.93056], [-122.68821, 37.93071], [-122.68836, 37.93086], [-122.68845, 37.931], [-122.68849, 37.93113], [-122.68851, 37.93133], [-122.68849, 37.93148], [-122.68841, 37.93167], [-122.68843, 37.93199], [-122.68855, 37.93222], [-122.68876, 37.93235], [-122.68919, 37.93253], [-122.68963, 37.93266], [-122.68999, 37.9327], [-122.69036, 37.93269], [-122.69081, 37.93262], [-122.69093, 37.93264], [-122.69104, 37.93271], [-122.69118, 37.9329]]]} | Open Access 1 | 45281 | Martin Griffin Preserve | 21904 | 3005 | Audubon Canyon Ranch 837 | Non Profit 6 | Non Profit - Conservation 12 | http://www.egret.org | Non Governmental Organization 10 | 3005 | Audubon Canyon Ranch 814 | Non Profit 6 | Non Profit - Conservation 12 | Marin 23 | 1010.785 | Martin Griffin Preserve | 0 | Private Conservation 16 | 2 | |
9658 | 9658 | 9657 | {"type": "Polygon", "coordinates": [[[-122.76949, 38.74085], [-122.76573, 38.73744], [-122.76241, 38.73972], [-122.7624, 38.73911], [-122.75779, 38.73936], [-122.7577, 38.73559], [-122.75417, 38.73553], [-122.75429, 38.73194], [-122.75071, 38.73192], [-122.75078, 38.72832], [-122.74803, 38.7283], [-122.74762, 38.72114], [-122.7511, 38.72112], [-122.7511, 38.71423], [-122.75872, 38.7141], [-122.75911, 38.70825], [-122.75919, 38.70742], [-122.7593, 38.69993], [-122.76654, 38.70011], [-122.76878, 38.70013], [-122.76879, 38.70105], [-122.76855, 38.70749], [-122.76741, 38.72074], [-122.76737, 38.72247], [-122.76682, 38.72313], [-122.76686, 38.72316], [-122.76696, 38.72317], [-122.76707, 38.72315], [-122.76729, 38.72306], [-122.76741, 38.72306], [-122.76753, 38.72308], [-122.76767, 38.72317], [-122.76773, 38.72325], [-122.76776, 38.72333], [-122.76782, 38.72339], [-122.7679, 38.72344], [-122.7681, 38.72349], [-122.76816, 38.72353], [-122.76823, 38.72361], [-122.76824, 38.72369], [-122.76821, 38.72384], [-122.76816, 38.72393], [-122.76783, 38.72437], [-122.76778, 38.72447], [-122.76776, 38.72456], [-122.76776, 38.72466], [-122.76784, 38.72482], [-122.76781, 38.72493], [-122.76774, 38.72498], [-122.76765, 38.725], [-122.76759, 38.72499], [-122.76735, 38.7249], [-122.76731, 38.72491], [-122.76703, 38.73525], [-122.76936, 38.73517], [-122.76949, 38.74085]]]} | Open Access 1 | 16287 | Modini Mayacamas Preserves | 383 | 3005 | Audubon Canyon Ranch 837 | Non Profit 6 | Non Profit - Conservation 12 | http://www.egret.org | Non Governmental Organization 10 | 3005 | Audubon Canyon Ranch 814 | Non Profit 6 | Non Profit - Conservation 12 | http://egret.org/visit_modini_mayacamas | Sonoma 16 | 1278.975 | Modini Mayacamas Preserves | 0 | Private Conservation 16 | 2 |
13186 | 13186 | 13185 | {"type": "Polygon", "coordinates": [[[-121.95578, 36.56241], [-121.95541, 36.5627], [-121.95521, 36.56252], [-121.9544, 36.56194], [-121.95423, 36.56185], [-121.95402, 36.56181], [-121.95408, 36.56142], [-121.95494, 36.56186], [-121.95578, 36.56241]]]} | Open Access 1 | 35176 | Pescadero Point and Hill Preserve | 28527 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 1.664 | Pescadero Point and Hill Preserve | 0 | Private Conservation 16 | 2 | |
13187 | 13187 | 13186 | {"type": "Polygon", "coordinates": [[[-121.95407, 36.56142], [-121.95402, 36.56181], [-121.95362, 36.56184], [-121.9532, 36.56194], [-121.9528, 36.56209], [-121.95254, 36.56226], [-121.95162, 36.56178], [-121.95157, 36.56134], [-121.95185, 36.56108], [-121.95365, 36.5612], [-121.95407, 36.56142]]]} | Open Access 1 | 35177 | Pescadero Point and Hill Preserve | 28527 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 4.86 | Pescadero Point and Hill Preserve | 0 | Private Conservation 16 | 2 | |
5886 | 5886 | 5885 | {"type": "MultiPolygon", "coordinates": [[[[-116.79405, 32.87017], [-116.79, 32.87024], [-116.78958, 32.86651], [-116.79032, 32.85859], [-116.79138, 32.85859], [-116.79107, 32.85376], [-116.79127, 32.85377], [-116.79143, 32.85379], [-116.79214, 32.85402], [-116.7931, 32.85439], [-116.79323, 32.85442], [-116.79339, 32.85441], [-116.79375, 32.85434], [-116.79399, 32.85864], [-116.79344, 32.85863], [-116.79343, 32.85864], [-116.79361, 32.86646], [-116.79405, 32.87017]]], [[[-116.79365, 32.85419], [-116.79333, 32.85425], [-116.7932, 32.85425], [-116.79222, 32.85387], [-116.79365, 32.85419]]]]} | Open Access 1 | 46781 | Peutz Creek Preserve | 31860 | 3206 | San Diego River Park Foundation 804 | Non Profit 6 | Non Profit - Conservation 12 | http://sandiegoriver.org/ | Non Governmental Organization 10 | 3206 | San Diego River Park Foundation 784 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 141.486 | Peutz Creek Preserve | 0 | Private Conservation 16 | 2 | |
4321 | 4321 | 4320 | {"type": "Polygon", "coordinates": [[[-123.72841, 39.25459], [-123.72836, 39.25477], [-123.72774, 39.25477], [-123.72734, 39.25423], [-123.72695, 39.2538], [-123.72614, 39.25278], [-123.72607, 39.25268], [-123.72573, 39.25242], [-123.7255, 39.25223], [-123.7254, 39.25204], [-123.72532, 39.25184], [-123.72532, 39.25161], [-123.72539, 39.25135], [-123.72509, 39.25077], [-123.72528, 39.25029], [-123.72534, 39.24985], [-123.72518, 39.24933], [-123.72499, 39.24893], [-123.72531, 39.24875], [-123.72585, 39.24829], [-123.72603, 39.24822], [-123.72628, 39.24841], [-123.72658, 39.24867], [-123.72676, 39.24878], [-123.72664, 39.24928], [-123.72705, 39.24987], [-123.7272, 39.25039], [-123.72728, 39.25059], [-123.72746, 39.25075], [-123.72761, 39.25109], [-123.7274, 39.25158], [-123.72737, 39.25191], [-123.7272, 39.2526], [-123.72734, 39.25285], [-123.72759, 39.25311], [-123.72813, 39.25374], [-123.72841, 39.25459]]]} | Open Access 1 | 45423 | Raven's Call | 28205 | 3353 | Friends of the Enchanted Meadow 744 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofenchantedmeadow.org/ | Non Governmental Organization 10 | 3353 | Friends of the Enchanted Meadow 730 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofenchantedmeadow.org/raven.html | Mendocino 24 | 23.564 | Raven's Call | 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]);