units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
52 rows where ACCESS_TYP = 4 and DES_TP = 16 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV, COUNTY, YR_EST
MNG_AGENCY 14
- National Audubon Society 23
- Save the Redwoods League 4
- San Joaquin River Parkway and Conservation Trust 4
- Wilderness Land Trust 4
- Sierra Foothill Conservancy 3
- Wildlands Inc 3
- Northcoast Regional Land Trust 3
- Back Country Land Trust 2
- Mendocino Land Trust 1
- American River Conservancy 1
- Mojave Desert Land Trust 1
- Native American Land Conservancy 1
- Rivers and Lands Conservancy 1
- Sacramento Valley Conservancy 1
MNG_AG_TYP 3
LAYER 2 ✖
DES_TP 1
- Private Conservation · 52 ✖
ACCESS_TYP 1
- Unknown Access · 52 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16616 | 16616 | 16615 | {"type": "MultiPolygon", "coordinates": [[[[-118.29226, 35.67424], [-118.29028, 35.67426], [-118.29026, 35.67365], [-118.29076, 35.67366], [-118.29168, 35.67375], [-118.29226, 35.67408], [-118.29226, 35.67424]]], [[[-118.29062, 35.67315], [-118.29038, 35.67314], [-118.29037, 35.67301], [-118.29037, 35.67301], [-118.29062, 35.67315]]]]} | Unknown Access 4 | 43064 | National Audubon Society 20 | 22650 | 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 | Kern 36 | 2.496 | Nat. Audubon Society 20 | 0 | Private Conservation 16 | 2 | |
16380 | 16380 | 16379 | {"type": "Polygon", "coordinates": [[[-118.2968, 35.69602], [-118.29474, 35.69602], [-118.29474, 35.69437], [-118.29674, 35.69595], [-118.2968, 35.69602]]]} | Unknown Access 4 | 43028 | National Audubon Society 17 | 22646 | 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 | Kern 36 | 4.294 | Nat. Audubon Society 17 | 0 | Private Conservation 16 | 2 | |
5894 | 5894 | 5893 | {"type": "Polygon", "coordinates": [[[-124.04065, 41.3174], [-124.03951, 41.32033], [-124.03923, 41.32036], [-124.03889, 41.32062], [-124.03874, 41.32109], [-124.03872, 41.32125], [-124.03832, 41.32127], [-124.03852, 41.32073], [-124.03931, 41.31984], [-124.03934, 41.31945], [-124.03918, 41.31876], [-124.03895, 41.31814], [-124.03895, 41.31789], [-124.03916, 41.31755], [-124.04065, 41.3174]]]} | Unknown Access 4 | 46787 | Berry Glen Trail Connection | 30241 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | Humboldt 45 | 6.789 | Berry Glen Trail Connection | 0 | Private Conservation 16 | 2 | |
12260 | 12260 | 12259 | {"type": "Polygon", "coordinates": [[[-115.41747, 34.16754], [-115.41528, 34.16754], [-115.41526, 34.16572], [-115.41745, 34.16572], [-115.41747, 34.16754]]]} | Unknown Access 4 | 25832 | Wilderness Land Trust | 27510 | 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 | 10.084 | Wilderness Land Trust | 0 | Private Conservation 16 | 2 | |
12276 | 12276 | 12275 | {"type": "Polygon", "coordinates": [[[-119.90876, 36.84585], [-119.90533, 36.84896], [-119.90287, 36.84725], [-119.9036, 36.84715], [-119.90433, 36.84704], [-119.90505, 36.8469], [-119.90576, 36.84675], [-119.90647, 36.84658], [-119.90717, 36.84638], [-119.90786, 36.84617], [-119.90876, 36.84585]]]} | Unknown Access 4 | 25926 | Riverside Restoration Area | 24459 | 3069 | San Joaquin River Parkway and Conservation Trust 649 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.riverparkway.org | Non Governmental Organization 10 | 3069 | San Joaquin River Parkway and Conservation Trust 491 | Non Profit 6 | Non Profit - Land Trust 10 | Fresno 9 | 14.792 | Riverside Restoration Area | 0 | Private Conservation 16 | 2 | |
3511 | 3511 | 3510 | {"type": "Polygon", "coordinates": [[[-118.29463, 35.66527], [-118.29017, 35.6658], [-118.29016, 35.66338], [-118.29462, 35.66337], [-118.29463, 35.66527]]]} | Unknown Access 4 | 36102 | National Audubon Society 4 | 22654 | 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 | Kern 36 | 23.993 | Nat. Audubon Society 4 | 0 | Private Conservation 16 | 2 | |
12400 | 12400 | 12399 | {"type": "Polygon", "coordinates": [[[-118.29464, 35.6701], [-118.29249, 35.6701], [-118.29247, 35.66885], [-118.29016, 35.66927], [-118.29017, 35.66773], [-118.29266, 35.66777], [-118.29252, 35.6669], [-118.2944, 35.66666], [-118.29414, 35.6655], [-118.29463, 35.66544], [-118.29464, 35.6701]]]} | Unknown Access 4 | 27001 | Vig, Heflin and Alexander | 27096 | 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 | Kern 36 | 26.231 | Vig, Heflin and Alexander | 0 | Private Conservation 16 | 2 | |
13726 | 13726 | 13725 | {"type": "Polygon", "coordinates": [[[-118.29017, 35.66553], [-118.29, 35.66553], [-118.29, 35.66582], [-118.28548, 35.66634], [-118.28553, 35.66335], [-118.29016, 35.66338], [-118.29017, 35.66553]]]} | Unknown Access 4 | 36141 | National Audubon Society 13 | 22642 | 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 | Kern 36 | 31.155 | Nat. Audubon Society 13 | 0 | Private Conservation 16 | 2 | |
12406 | 12406 | 12405 | {"type": "Polygon", "coordinates": [[[-118.18291, 35.72885], [-118.18268, 35.73232], [-118.17866, 35.73247], [-118.17877, 35.72896], [-118.18291, 35.72885]]]} | Unknown Access 4 | 36168 | National Audubon Society 8 | 22658 | 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 | Kern 36 | 35.32 | Nat. Audubon Society 8 | 0 | Private Conservation 16 | 2 | |
13725 | 13725 | 13724 | {"type": "Polygon", "coordinates": [[[-118.1829, 35.73595], [-118.17869, 35.7361], [-118.17866, 35.73247], [-118.18268, 35.73233], [-118.1829, 35.73595]]]} | Unknown Access 4 | 36140 | National Audubon Society 23 | 22652 | 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 | Kern 36 | 37.086 | Nat. Audubon Society 23 | 0 | Private Conservation 16 | 2 | |
4150 | 4150 | 4149 | {"type": "Polygon", "coordinates": [[[-119.95114, 37.60758], [-119.95049, 37.61465], [-119.94827, 37.61467], [-119.94891, 37.60766], [-119.95114, 37.60758]]]} | Unknown Access 4 | 44690 | Feliciana Mountain Preserve | 18865 | 3077 | Sierra Foothill Conservancy 323 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sierrafoothill.org/ | Non Governmental Organization 10 | 3077 | Sierra Foothill Conservancy 320 | Non Profit 6 | Non Profit - Land Trust 10 | Mariposa 31 | 37.919 | Feliciana Mtn. Preserve | 0 | Private Conservation 16 | 2 | |
3480 | 3480 | 3479 | {"type": "Polygon", "coordinates": [[[-118.84904, 38.00675], [-118.84899, 38.01037], [-118.8444, 38.01038], [-118.84445, 38.00676], [-118.84904, 38.00675]]]} | Unknown Access 4 | 25838 | Wilderness Land Trust | 27510 | 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 | Mono 32 | 40.043 | Wilderness Land Trust | 0 | Private Conservation 16 | 2 | |
13640 | 13640 | 13639 | {"type": "Polygon", "coordinates": [[[-121.01127, 38.77623], [-121.01126, 38.77986], [-121.01124, 38.77991], [-121.01121, 38.77993], [-121.00677, 38.77985], [-121.00661, 38.77987], [-121.00662, 38.77616], [-121.01127, 38.77623]]]} | Unknown Access 4 | 36003 | Boulder Glen | 16295 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | El Dorado 34 | 40.914 | Boulder Glen | 0 | Private Conservation 16 | 2 | |
12262 | 12262 | 12261 | {"type": "Polygon", "coordinates": [[[-117.90111, 35.49943], [-117.89655, 35.49938], [-117.89647, 35.49577], [-117.90107, 35.49582], [-117.90111, 35.49943]]]} | Unknown Access 4 | 25836 | Wilderness Land Trust | 27510 | 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 | 41.08 | Wilderness Land Trust | 0 | Private Conservation 16 | 2 | |
5898 | 5898 | 5897 | {"type": "Polygon", "coordinates": [[[-124.18306, 40.75177], [-124.18271, 40.75197], [-124.18253, 40.75214], [-124.18242, 40.75249], [-124.18125, 40.75249], [-124.18016, 40.75287], [-124.17956, 40.75286], [-124.17939, 40.75284], [-124.17933, 40.75296], [-124.17898, 40.75279], [-124.17838, 40.7527], [-124.17813, 40.7527], [-124.1781, 40.7529], [-124.17788, 40.75289], [-124.17787, 40.75291], [-124.17827, 40.75381], [-124.1766, 40.7538], [-124.17659, 40.75401], [-124.17628, 40.75401], [-124.17628, 40.7538], [-124.17427, 40.75379], [-124.17328, 40.75483], [-124.17331, 40.75172], [-124.17589, 40.75172], [-124.17592, 40.75152], [-124.17591, 40.75105], [-124.17625, 40.75064], [-124.1765, 40.75041], [-124.17694, 40.75024], [-124.17736, 40.75018], [-124.17754, 40.7502], [-124.17786, 40.75028], [-124.17804, 40.75038], [-124.1782, 40.75052], [-124.17821, 40.75174], [-124.18306, 40.75177]]]} | Unknown Access 4 | 46791 | Martin Slough | 30246 | 3294 | Northcoast Regional Land Trust 819 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.ncrlt.org/ | Non Governmental Organization 10 | 3294 | Northcoast Regional Land Trust 797 | Non Profit 6 | Non Profit - Land Trust 10 | Humboldt 45 | 41.186 | Martin Slough | 0 | Private Conservation 16 | 2 | |
17004 | 17004 | 17003 | {"type": "MultiPolygon", "coordinates": [[[[-118.29467, 35.67377], [-118.29419, 35.67362], [-118.29189, 35.67317], [-118.29062, 35.67315], [-118.29037, 35.67301], [-118.29034, 35.67178], [-118.2902, 35.67177], [-118.29016, 35.66927], [-118.29248, 35.66885], [-118.29249, 35.67009], [-118.29464, 35.6701], [-118.29467, 35.67377]]], [[[-118.29434, 35.67423], [-118.29226, 35.67424], [-118.29226, 35.67408], [-118.29168, 35.67375], [-118.29272, 35.67385], [-118.29434, 35.67423]]]]} | Unknown Access 4 | 36101 | National Audubon Society 3 | 22653 | 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 | Kern 36 | 42.725 | Nat. Audubon Society 3 | 0 | Private Conservation 16 | 2 | |
13729 | 13729 | 13728 | {"type": "MultiPolygon", "coordinates": [[[[-118.32506, 35.67338], [-118.32384, 35.674], [-118.32283, 35.67419], [-118.32277, 35.67419], [-118.32279, 35.67326], [-118.32286, 35.67325], [-118.32367, 35.67324], [-118.32441, 35.67334], [-118.32506, 35.67338]]], [[[-118.32559, 35.67153], [-118.32554, 35.67299], [-118.3248, 35.67294], [-118.32373, 35.67272], [-118.3228, 35.67274], [-118.32288, 35.66874], [-118.32302, 35.66909], [-118.32324, 35.6695], [-118.32351, 35.66989], [-118.32383, 35.67025], [-118.32419, 35.67059], [-118.32452, 35.67085], [-118.32559, 35.67153]]], [[[-118.32574, 35.66363], [-118.32571, 35.66683], [-118.32559, 35.67132], [-118.3246, 35.67068], [-118.32428, 35.67043], [-118.324, 35.67016], [-118.32369, 35.66981], [-118.32343, 35.66944], [-118.32325, 35.66911], [-118.32307, 35.6687], [-118.32297, 35.66835], [-118.32289, 35.66792], [-118.32293, 35.66363], [-118.32574, 35.66363]]]]} | Unknown Access 4 | 36167 | National Audubon Society 7 | 22657 | 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 | Kern 36 | 65.106 | Nat. Audubon Society 7 | 0 | Private Conservation 16 | 2 | |
5900 | 5900 | 5899 | {"type": "Polygon", "coordinates": [[[-124.10154, 40.78543], [-124.09837, 40.78644], [-124.09699, 40.78702], [-124.09651, 40.78736], [-124.09547, 40.78733], [-124.09421, 40.78637], [-124.09389, 40.78634], [-124.0936, 40.78639], [-124.09263, 40.78672], [-124.09247, 40.78675], [-124.09223, 40.78675], [-124.09194, 40.78672], [-124.09156, 40.78664], [-124.09121, 40.78653], [-124.09109, 40.78639], [-124.09099, 40.78622], [-124.0909, 40.78602], [-124.09073, 40.7858], [-124.09059, 40.78568], [-124.09047, 40.78561], [-124.08992, 40.78549], [-124.0895, 40.78533], [-124.08937, 40.78525], [-124.08908, 40.78492], [-124.08893, 40.78461], [-124.08855, 40.784], [-124.08832, 40.78382], [-124.08816, 40.78381], [-124.0881, 40.78368], [-124.09263, 40.78369], [-124.09692, 40.78363], [-124.09748, 40.78367], [-124.09845, 40.78402], [-124.09916, 40.78435], [-124.10076, 40.78497], [-124.10114, 40.78505], [-124.10152, 40.78511], [-124.10154, 40.78543]]]} | Unknown Access 4 | 46792 | Freshwater Farms Reserve | 30247 | 3294 | Northcoast Regional Land Trust 819 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.ncrlt.org/ | Non Governmental Organization 10 | 3294 | Northcoast Regional Land Trust 797 | Non Profit 6 | Non Profit - Land Trust 10 | Humboldt 45 | 71.838 | Freshwater Farms Reserve | 0 | Private Conservation 16 | 2 | |
3494 | 3494 | 3493 | {"type": "Polygon", "coordinates": [[[-119.92013, 36.84814], [-119.9201, 36.84889], [-119.91933, 36.84892], [-119.91621, 36.84954], [-119.91557, 36.84957], [-119.91467, 36.84879], [-119.91115, 36.8488], [-119.91115, 36.85122], [-119.91068, 36.85129], [-119.91054, 36.85133], [-119.90847, 36.8513], [-119.90649, 36.85002], [-119.90733, 36.84921], [-119.90775, 36.84888], [-119.90795, 36.84855], [-119.90816, 36.84837], [-119.90879, 36.848], [-119.90911, 36.84784], [-119.90954, 36.8475], [-119.90997, 36.84724], [-119.91042, 36.84702], [-119.91072, 36.84679], [-119.91172, 36.8464], [-119.91209, 36.84619], [-119.91244, 36.84606], [-119.91285, 36.84585], [-119.91314, 36.84576], [-119.91372, 36.84572], [-119.91435, 36.84574], [-119.91473, 36.84573], [-119.91559, 36.84561], [-119.91563, 36.84814], [-119.92013, 36.84814]]]} | Unknown Access 4 | 25925 | Schneider Property | 25187 | 3069 | San Joaquin River Parkway and Conservation Trust 649 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.riverparkway.org | Non Governmental Organization 10 | 3069 | San Joaquin River Parkway and Conservation Trust 491 | Non Profit 6 | Non Profit - Land Trust 10 | Madera 48 | 77.528 | Schneider Property | 0 | Private Conservation 16 | 2 | |
12399 | 12399 | 12398 | {"type": "Polygon", "coordinates": [[[-118.2991, 35.66701], [-118.29904, 35.67422], [-118.29611, 35.67423], [-118.29467, 35.67377], [-118.29464, 35.66699], [-118.2991, 35.66701]]]} | Unknown Access 4 | 27000 | Vig, Heflin and Alexander | 27096 | 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 | Kern 36 | 78.449 | Vig, Heflin and Alexander | 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]);