superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
43 rows where MNG_AGENCY = 61 and MNG_AG_TYP = 10 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11627 | 11627 | 11626 | {"type": "Polygon", "coordinates": [[[-122.57517, 38.37016], [-122.57515, 38.37071], [-122.57458, 38.37071], [-122.57457, 38.37015], [-122.57517, 38.37016]]]} | No Public Access 3 | Bunnell Vernal Pool | 28171 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 0.778 | Bunnell Vernal Pool | ||
12133 | 12133 | 12132 | {"type": "Polygon", "coordinates": [[[-116.89141, 34.24771], [-116.89139, 34.24775], [-116.89092, 34.24766], [-116.89067, 34.24764], [-116.89021, 34.24767], [-116.89012, 34.24725], [-116.89068, 34.24717], [-116.89141, 34.24771]]]} | No Public Access 3 | Big Bear Eagle Point | 30588 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 1.036 | Big Bear Eagle Point | ||
13288 | 13288 | 13287 | {"type": "Polygon", "coordinates": [[[-122.58261, 37.85753], [-122.58259, 37.8576], [-122.58251, 37.85765], [-122.58238, 37.85766], [-122.58222, 37.85781], [-122.58223, 37.85789], [-122.5822, 37.85802], [-122.58207, 37.85822], [-122.58182, 37.85825], [-122.58184, 37.85843], [-122.58135, 37.85849], [-122.58134, 37.85841], [-122.58127, 37.85842], [-122.58132, 37.85872], [-122.58066, 37.85877], [-122.58048, 37.85852], [-122.58056, 37.8582], [-122.58066, 37.85798], [-122.58082, 37.85776], [-122.581, 37.85765], [-122.58118, 37.85765], [-122.58129, 37.8577], [-122.58138, 37.85771], [-122.58154, 37.85766], [-122.58164, 37.85754], [-122.58173, 37.85747], [-122.5818, 37.85734], [-122.5818, 37.85728], [-122.582, 37.85714], [-122.58207, 37.85711], [-122.58216, 37.85712], [-122.58229, 37.85715], [-122.5824, 37.8572], [-122.58246, 37.85725], [-122.58247, 37.85738], [-122.5825, 37.85742], [-122.58256, 37.85746], [-122.58261, 37.85753]]]} | No Public Access 3 | Spindrift Preserve | 30615 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 4.229 | Spindrift Preserve | ||
12156 | 12156 | 12155 | {"type": "Polygon", "coordinates": [[[-120.72191, 40.04586], [-120.7219, 40.04862], [-120.71704, 40.04853], [-120.71704, 40.04809], [-120.71755, 40.0478], [-120.71842, 40.04765], [-120.71943, 40.04742], [-120.71969, 40.04726], [-120.72004, 40.04693], [-120.72052, 40.04616], [-120.72097, 40.04583], [-120.72128, 40.04579], [-120.7217, 40.04581], [-120.72191, 40.04586]]]} | No Public Access 3 | Heart K Ranch | 30599 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 17.963 | Heart K Ranch | ||
13251 | 13251 | 13250 | {"type": "Polygon", "coordinates": [[[-119.92048, 35.24895], [-119.9167, 35.24893], [-119.91667, 35.24586], [-119.92046, 35.24588], [-119.92048, 35.24895]]]} | No Public Access 3 | Carrizo Plains | 30593 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 29.054 | Carrizo Plains | 1988 | |
13247 | 13247 | 13246 | {"type": "Polygon", "coordinates": [[[-119.86364, 35.18945], [-119.86137, 35.18943], [-119.86133, 35.19036], [-119.85911, 35.19035], [-119.85909, 35.18697], [-119.86363, 35.187], [-119.86364, 35.18945]]]} | Restricted Access 2 | Carrizo Plains | 30592 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 32.944 | Carrizo Plains | 1988 | |
3376 | 3376 | 3375 | {"type": "Polygon", "coordinates": [[[-121.99562, 39.7515], [-121.99443, 39.75196], [-121.99393, 39.75211], [-121.9935, 39.75227], [-121.99296, 39.75235], [-121.99226, 39.75242], [-121.9914, 39.7524], [-121.99124, 39.75232], [-121.98861, 39.74682], [-121.98935, 39.74655], [-121.98963, 39.7472], [-121.99013, 39.74792], [-121.99059, 39.74829], [-121.99115, 39.74861], [-121.99158, 39.74873], [-121.99259, 39.74926], [-121.99323, 39.74964], [-121.99365, 39.75], [-121.99432, 39.75045], [-121.99562, 39.7515]]]} | Open Access 1 | Cummings | 17857 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 35.635 | Cummings | ||
2943 | 2943 | 2942 | {"type": "MultiPolygon", "coordinates": [[[[-115.81338, 33.507], [-115.81269, 33.50699], [-115.81269, 33.50672], [-115.81301, 33.50684], [-115.81338, 33.507]]], [[[-115.81707, 33.50334], [-115.81705, 33.507], [-115.81411, 33.507], [-115.81316, 33.50659], [-115.81269, 33.50642], [-115.81271, 33.50334], [-115.81707, 33.50334]]]]} | Restricted Access 2 | Dos Palmas Preserve | 18227 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 39.789 | Dos Palmas Preserve | ||
4928 | 4928 | 4927 | {"type": "Polygon", "coordinates": [[[-121.59811, 36.07501], [-121.59802, 36.07863], [-121.59354, 36.07864], [-121.59363, 36.07502], [-121.59811, 36.07501]]]} | Restricted Access 2 | Landels-Hill Big Creek Reserve | 21004 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 40.061 | Landels-Hill Big Creek Reserve | ||
13263 | 13263 | 13262 | {"type": "Polygon", "coordinates": [[[-116.23969, 35.87745], [-116.23514, 35.87746], [-116.23508, 35.87383], [-116.23969, 35.87383], [-116.23969, 35.87745]]]} | No Public Access 3 | Amargosa River Preserve | 30585 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 41.109 | Amargosa River Preserve | ||
4110 | 4110 | 4109 | {"type": "Polygon", "coordinates": [[[-116.74026, 33.1805], [-116.73988, 33.18051], [-116.73975, 33.18053], [-116.73967, 33.18056], [-116.7395, 33.18056], [-116.73938, 33.18052], [-116.73921, 33.18041], [-116.73815, 33.18042], [-116.73818, 33.18262], [-116.73708, 33.18261], [-116.73375, 33.18275], [-116.73377, 33.17923], [-116.74025, 33.17921], [-116.74026, 33.1805]]]} | No Public Access 3 | Ewing Oak Preserve | 18771 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 45.462 | Ewing Oak Preserve | ||
13291 | 13291 | 13290 | {"type": "Polygon", "coordinates": [[[-122.02874, 39.35556], [-122.02821, 39.35642], [-122.0278, 39.35699], [-122.02758, 39.35719], [-122.02736, 39.35729], [-122.02692, 39.35734], [-122.02644, 39.35741], [-122.0258, 39.35759], [-122.02524, 39.35796], [-122.02451, 39.3584], [-122.02427, 39.35856], [-122.02389, 39.35895], [-122.02357, 39.35918], [-122.02323, 39.35936], [-122.02288, 39.3595], [-122.02173, 39.36005], [-122.02148, 39.36012], [-122.02126, 39.36016], [-122.02101, 39.36018], [-122.02093, 39.36017], [-122.02072, 39.36014], [-122.02033, 39.36005], [-122.01949, 39.35979], [-122.01898, 39.3597], [-122.0185, 39.35966], [-122.01806, 39.35966], [-122.0177, 39.35973], [-122.01646, 39.36017], [-122.01512, 39.3607], [-122.01454, 39.36091], [-122.01431, 39.36107], [-122.01421, 39.36121], [-122.01438, 39.36209], [-122.01443, 39.36247], [-122.01395, 39.36247], [-122.01383, 39.36111], [-122.01395, 39.36101], [-122.01788, 39.35938], [-122.01844, 39.35939], [-122.01881, 39.35871], [-122.01981, 39.35804], [-122.02043, 39.35758], [-122.02217, 39.3566], [-122.02339, 39.35558], [-122.02359, 39.35551], [-122.02874, 39.35556]]]} | No Public Access 3 | Thousand Acre Ranch | 30619 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 59.708 | Thousand Acre Ranch | ||
13289 | 13289 | 13288 | {"type": "Polygon", "coordinates": [[[-123.31833, 41.86782], [-123.31415, 41.86785], [-123.31371, 41.86487], [-123.31346, 41.86473], [-123.31368, 41.86449], [-123.31278, 41.86376], [-123.31828, 41.86079], [-123.31833, 41.86782]]]} | No Public Access 3 | Thompson Creek | 30618 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 60.952 | Thompson Creek | ||
13287 | 13287 | 13286 | {"type": "MultiPolygon", "coordinates": [[[[-122.37606, 37.71341], [-122.37566, 37.71386], [-122.37538, 37.7137], [-122.37578, 37.71325], [-122.37606, 37.71341]]], [[[-122.45576, 37.89472], [-122.45293, 37.89479], [-122.45231, 37.89416], [-122.45169, 37.89423], [-122.45168, 37.8937], [-122.45266, 37.89369], [-122.45295, 37.89409], [-122.45345, 37.89438], [-122.45452, 37.89417], [-122.45468, 37.89396], [-122.45574, 37.89393], [-122.45576, 37.89472]]], [[[-122.46017, 37.89527], [-122.45946, 37.89587], [-122.45918, 37.89564], [-122.45968, 37.895], [-122.46017, 37.89527]]], [[[-122.47661, 37.90785], [-122.47475, 37.90788], [-122.47215, 37.90788], [-122.47196, 37.90748], [-122.47638, 37.90741], [-122.47651, 37.90744], [-122.47659, 37.90755], [-122.47658, 37.90778], [-122.47661, 37.90785]]], [[[-122.47665, 37.97435], [-122.47648, 37.97451], [-122.4762, 37.97431], [-122.47636, 37.97414], [-122.47665, 37.97435]]], [[[-122.48836, 37.96425], [-122.48582, 37.96425], [-122.48578, 37.96063], [-122.48826, 37.96059], [-122.48836, 37.96425]]], [[[-122.48789, 37.95198], [-122.48589, 37.9507], [-122.48589, 37.94931], [-122.48702, 37.94931], [-122.48789, 37.95198]]], [[[-122.49986, 37.93227], [-122.49757, 37.93231], [-122.49748, 37.92869], [-122.49976, 37.92865], [-122.49986, 37.93227]]], [[[-122.50282, 37.93222], [-122.50215, 37.93224], [-122.50213, 37.93158], [-122.50221, 37.93178], [-122.50282, 37.93222]]]]} | No Public Access 3 | San Francisco Bay Tidelands | 30614 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 61.759 | San Francisco Bay Tidelands | ||
13262 | 13262 | 13261 | {"type": "Polygon", "coordinates": [[[-116.21873, 35.80415], [-116.20983, 35.80412], [-116.20983, 35.80049], [-116.21873, 35.80053], [-116.21873, 35.80415]]]} | Restricted Access 2 | Amargosa River Preserve | 30584 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 80.037 | Amargosa River Preserve | ||
12174 | 12174 | 12173 | {"type": "Polygon", "coordinates": [[[-120.72157, 40.15179], [-120.72088, 40.15924], [-120.71598, 40.15917], [-120.7167, 40.15153], [-120.72157, 40.15179]]]} | Restricted Access 2 | Taylor Lake | 30617 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 86.431 | Taylor Lake | ||
11600 | 11600 | 11599 | {"type": "Polygon", "coordinates": [[[-121.50388, 36.97423], [-121.49381, 36.97987], [-121.49263, 36.98059], [-121.49332, 36.98142], [-121.4935, 36.98161], [-121.49377, 36.98195], [-121.48591, 36.98642], [-121.48466, 36.98592], [-121.48745, 36.98306], [-121.48758, 36.9831], [-121.48771, 36.98296], [-121.48823, 36.98239], [-121.49949, 36.97035], [-121.50388, 36.97423]]]} | No Public Access 3 | Gonzales Farm | 28146 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 170.473 | Gonzales Farm | ||
13268 | 13268 | 13267 | {"type": "Polygon", "coordinates": [[[-122.86382, 38.08218], [-122.8637, 38.0827], [-122.86336, 38.08297], [-122.86329, 38.08312], [-122.86332, 38.08324], [-122.86356, 38.08338], [-122.86323, 38.08365], [-122.86293, 38.08385], [-122.86274, 38.08404], [-122.86266, 38.08421], [-122.86257, 38.08451], [-122.86262, 38.08502], [-122.86112, 38.08696], [-122.86082, 38.08722], [-122.86069, 38.08758], [-122.86064, 38.08817], [-122.86058, 38.08838], [-122.86346, 38.09161], [-122.86066, 38.09307], [-122.85991, 38.09201], [-122.85923, 38.09236], [-122.85873, 38.09161], [-122.85764, 38.09062], [-122.85679, 38.09072], [-122.85607, 38.09068], [-122.85555, 38.09091], [-122.85504, 38.09078], [-122.8548, 38.09064], [-122.85438, 38.09051], [-122.85336, 38.09032], [-122.85256, 38.09034], [-122.85204, 38.09039], [-122.85122, 38.09053], [-122.85077, 38.09064], [-122.85011, 38.09092], [-122.84985, 38.08879], [-122.85136, 38.08874], [-122.85147, 38.08871], [-122.85156, 38.08867], [-122.8517, 38.08852], [-122.85184, 38.08821], [-122.85194, 38.08811], [-122.85231, 38.08792], [-122.85275, 38.08773], [-122.85306, 38.08753], [-122.85363, 38.08794], [-122.85495, 38.08756], [-122.85723, 38.08182], [-122.85527, 38.07934], [-122.8578, 38.08059], [-122.85826, 38.08063], [-122.85857, 38.08054], [-122.85906, 38.08061], [-122.85972, 38.08039], [-122.86019, 38.08028], [-122.86109, 38.08026], [-122.86169, 38.08045], [-122.86277, 38.08147], [-122.86351, 38.0819], [-122.86382, 38.08218]], [[-122.85634, 38.08902], [-122.85606, 38.08879], [-122.85548, 38.0888], [-122.85517, 38.08925], [-122.85498, 38.08965], [-122.85603, 38.09036], [-122.85675, 38.09015], [-122.85663, 38.08958], [-122.85634, 38.08902]]]} | Restricted Access 2 | Bishop Pine Preserve | 30589 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 200.705 | Bishop Pine Preserve | 1967 | |
7752 | 7752 | 7751 | {"type": "Polygon", "coordinates": [[[-119.18218, 34.14024], [-119.18214, 34.14291], [-119.17988, 34.14289], [-119.17936, 34.14362], [-119.17849, 34.14464], [-119.18209, 34.14469], [-119.18209, 34.14483], [-119.17928, 34.14481], [-119.17886, 34.14485], [-119.17839, 34.14495], [-119.17805, 34.14506], [-119.17773, 34.1452], [-119.17616, 34.14602], [-119.17571, 34.14629], [-119.17524, 34.14663], [-119.1753, 34.14027], [-119.17556, 34.14027], [-119.17558, 34.14025], [-119.17621, 34.1402], [-119.17662, 34.14019], [-119.17663, 34.14009], [-119.17541, 34.14008], [-119.17538, 34.14015], [-119.1753, 34.14015], [-119.17529, 34.14005], [-119.16685, 34.13998], [-119.16689, 34.13639], [-119.16898, 34.13642], [-119.16901, 34.13275], [-119.17536, 34.1328], [-119.17538, 34.13201], [-119.17635, 34.13277], [-119.17813, 34.13402], [-119.17813, 34.13439], [-119.17929, 34.13521], [-119.17923, 34.14011], [-119.1818, 34.14014], [-119.18181, 34.14021], [-119.18214, 34.14021], [-119.18215, 34.14024], [-119.18218, 34.14024]]]} | No Public Access 3 | Ormond Beach | 23206 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 275.844 | Ormond Beach | 2005 | |
13264 | 13264 | 13263 | {"type": "MultiPolygon", "coordinates": [[[[-118.2017, 34.44342], [-118.20168, 34.44514], [-118.20111, 34.44514], [-118.19955, 34.44368], [-118.19954, 34.44332], [-118.19915, 34.44331], [-118.19741, 34.44168], [-118.19741, 34.44147], [-118.19719, 34.44147], [-118.19321, 34.43773], [-118.19314, 34.43773], [-118.19312, 34.43784], [-118.197, 34.44146], [-118.19311, 34.44144], [-118.19311, 34.43816], [-118.19295, 34.43774], [-118.19202, 34.43772], [-118.192, 34.43687], [-118.19093, 34.43692], [-118.19081, 34.43178], [-118.18641, 34.43179], [-118.18636, 34.43068], [-118.18431, 34.43069], [-118.18424, 34.42721], [-118.19295, 34.42713], [-118.19301, 34.43065], [-118.19741, 34.43064], [-118.19744, 34.43777], [-118.19919, 34.43781], [-118.19904, 34.43791], [-118.19892, 34.43806], [-118.19885, 34.43823], [-118.19884, 34.43839], [-118.19885, 34.43856], [-118.1989, 34.43877], [-118.19905, 34.43912], [-118.19915, 34.43929], [-118.1992, 34.43949], [-118.1992, 34.43971], [-118.19911, 34.43997], [-118.19909, 34.44017], [-118.1991, 34.44036], [-118.19917, 34.44056], [-118.19931, 34.44078], [-118.19962, 34.44108], [-118.2017, 34.44342]]], [[[-118.19898, 34.44331], [-118.1974, 34.44331], [-118.19741, 34.44185], [-118.19741, 34.44185], [-118.19898, 34.44331]]], [[[-118.20094, 34.44515], [-118.19953, 34.44515], [-118.19954, 34.44384], [-118.19954, 34.44384], [-118.20094, 34.44515]]]]} | No Public Access 3 | Arrastre Canyon | 30586 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 283.154 | Arrastre Canyon |
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]);