units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
268 rows where ACCESS_TYP = 3 and MNG_AG_LEV = 6 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER, PARK_URL, YR_EST, GAP_STS
MNG_AGENCY >30
- The Nature Conservancy 32
- Peninsula Open Space Trust 24
- Rivers and Lands Conservancy 22
- The Environmental Trust 21
- Mountains Restoration Trust 20
- Endangered Habitats Conservancy 14
- American River Conservancy 13
- Save Mount Diablo 13
- Sonoma Land Trust 11
- Center for Natural Lands Management 8
- Elkhorn Slough Foundation 8
- Marin Audubon Society 7
- Wilderness Land Trust 6
- Land Trust of Santa Cruz County 5
- Big Sur Land Trust 4
- Land Conservancy of San Luis Obispo County 4
- Pacific Forest Trust 4
- The Conservation Fund - California 4
- Bear Yuba Land Trust 3
- John Muir Land Trust 3
- Fallbrook Land Conservancy 3
- San Dieguito River Valley Land Conservancy 3
- Placer Land Trust 3
- Save the Redwoods League 2
- Sequoia Riverlands Trust 2
- Land Trust of Napa County 2
- Escondido Creek Conservancy 2
- Solano Land Trust 2
- National Audubon Society 2
- Mojave Desert Land Trust 2
- …
DES_TP 8
MNG_AG_TYP 3
ACCESS_TYP 1
- No Public Access · 268 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
154 | 154 | 153 | {"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.73814, 33.18041], [-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 | 416 | Ewing Oak Preserve | 18771 | 3091 | The Nature Conservancy 63 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 45.451 | Ewing Oak Preserve | 0 | Private Conservation 16 | 2 | |
6088 | 6088 | 6087 | {"type": "MultiPolygon", "coordinates": [[[[-118.76566, 36.21897], [-118.76561, 36.21935], [-118.76554, 36.21939], [-118.76553, 36.21897], [-118.76566, 36.21897]]], [[[-118.80359, 36.20734], [-118.80355, 36.20742], [-118.80349, 36.20775], [-118.80348, 36.20781], [-118.8035, 36.20789], [-118.80349, 36.20795], [-118.80341, 36.20808], [-118.80334, 36.20828], [-118.80335, 36.20835], [-118.8032, 36.20866], [-118.80308, 36.2088], [-118.80303, 36.20897], [-118.8029, 36.20911], [-118.80283, 36.20927], [-118.80272, 36.20942], [-118.80253, 36.20973], [-118.8023, 36.21002], [-118.80221, 36.21018], [-118.80166, 36.21092], [-118.80137, 36.21142], [-118.80119, 36.21183], [-118.79768, 36.21183], [-118.79707, 36.21184], [-118.79709, 36.21574], [-118.79715, 36.21897], [-118.79705, 36.21911], [-118.79693, 36.21941], [-118.78843, 36.21938], [-118.78839, 36.22305], [-118.77009, 36.22297], [-118.7656, 36.22293], [-118.76555, 36.21961], [-118.7658, 36.21943], [-118.76587, 36.21898], [-118.77952, 36.21909], [-118.77933, 36.20853], [-118.77975, 36.20849], [-118.78019, 36.20853], [-118.78076, 36.20854], [-118.78141, 36.20837], [-118.78173, 36.20826], [-118.78219, 36.20796], [-118.78266, 36.2075], [-118.78303, 36.20689], [-118.78341, 36.20642], [-118.78376, 36.20622], [-118.78433, 36.20598], [-118.78483, 36.20553], [-118.78512, 36.20513], [-118.8033, 36.20504], [-118.8033, 36.2051], [-118.80333, 36.20575], [-118.80336, 36.2059], [-118.8034, 36.20595], [-118.80342, 36.20602], [-118.80345, 36.20608], [-118.80348, 36.20621], [-118.80346, 36.20627], [-118.80353, 36.2066], [-118.80358, 36.20667], [-118.8036, 36.20721], [-118.80359, 36.20734]]], [[[-118.78102, 36.20829], [-118.78073, 36.20836], [-118.78021, 36.20835], [-118.77976, 36.20831], [-118.77933, 36.20835], [-118.77933, 36.20827], [-118.78102, 36.20829]]]]} | No Public Access 3 | 898 | Dennison Ditch Co | 18093 | 3076 | Sequoia Riverlands Trust 109 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sequoiariverlands.org | Non Governmental Organization 10 | 3076 | Sequoia Riverlands Trust 106 | Non Profit 6 | Non Profit - Land Trust 10 | Tulare 29 | 901.367 | Dennison Ditch Co | 0 | Private Conservation 16 | 2 | |
6095 | 6095 | 6094 | {"type": "Polygon", "coordinates": [[[-122.17522, 37.2796], [-122.17085, 37.27955], [-122.17074, 37.27583], [-122.17513, 37.27588], [-122.17522, 37.2796]]]} | No Public Access 3 | 979 | Sonntag | 25605 | 3054 | Peninsula Open Space Trust 338 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 39.667 | Sonntag | 0 | Private Conservation 16 | 2 | |
6138 | 6138 | 6137 | {"type": "MultiPolygon", "coordinates": [[[[-119.81139, 36.85174], [-119.80965, 36.85279], [-119.80958, 36.85524], [-119.80919, 36.85524], [-119.80918, 36.85525], [-119.80934, 36.85555], [-119.80965, 36.85584], [-119.8098, 36.85603], [-119.81001, 36.8564], [-119.81053, 36.85718], [-119.81052, 36.85757], [-119.81058, 36.85775], [-119.81056, 36.85798], [-119.81032, 36.8589], [-119.81027, 36.85962], [-119.8101, 36.86002], [-119.80955, 36.8605], [-119.80919, 36.86204], [-119.80844, 36.86293], [-119.80636, 36.86382], [-119.80577, 36.8641], [-119.8056, 36.86425], [-119.80474, 36.86484], [-119.80363, 36.8651], [-119.80253, 36.86561], [-119.80219, 36.86584], [-119.80205, 36.86614], [-119.80199, 36.86632], [-119.80175, 36.86632], [-119.80176, 36.86678], [-119.80174, 36.86702], [-119.80158, 36.86727], [-119.80115, 36.86778], [-119.80104, 36.86782], [-119.8008, 36.86795], [-119.80046, 36.86824], [-119.8003, 36.86851], [-119.80023, 36.86891], [-119.8002, 36.86931], [-119.80015, 36.86954], [-119.79995, 36.86991], [-119.79971, 36.87027], [-119.79948, 36.87058], [-119.79916, 36.87082], [-119.79884, 36.87118], [-119.7985, 36.87152], [-119.79837, 36.87158], [-119.79807, 36.8718], [-119.79783, 36.87189], [-119.79749, 36.87211], [-119.79717, 36.87237], [-119.79685, 36.8726], [-119.79671, 36.87276], [-119.7966, 36.87282], [-119.7962, 36.87288], [-119.79596, 36.87301], [-119.79588, 36.87324], [-119.79577, 36.87342], [-119.79537, 36.87362], [-119.79509, 36.87385], [-119.79479, 36.87406], [-119.79409, 36.87471], [-119.79402, 36.8741], [-119.79381, 36.86984], [-119.79435, 36.86947], [-119.79484, 36.86895], [-119.79528, 36.86836], [-119.79634, 36.86631], [-119.79728, 36.86631], [-119.79729, 36.86374], [-119.79741, 36.86334], [-119.79812, 36.86223], [-119.79822, 36.86156], [-119.79828, 36.86147], [-119.79838, 36.86148], [-119.79846, 36.86137], [-119.79916, 36.86075], [-119.79957, 36.86022], [-119.79979, 36.85985], [-119.80008, 36.85919], [-119.80056, 36.85848], [-119.80065, 36.85813], [-119.80064, 36.85809], [-119.80081, 36.85745], [-119.8008, 36.85741], [-119.80117, 36.85692], [-119.80182, 36.85633], [-119.80242, 36.85586], [-119.80241, 36.85583], [-119.80253, 36.85578], [-119.8026, 36.85572], [-119.80321, 36.85532], [-119.80371, 36.85506], [-119.80397, 36.85494], [-119.80419, 36.85478], [-119.80453, 36.85434], [-119.80485, 36.85465], [-119.80484, 36.85469], [-119.80507, 36.85479], [-119.80512, 36.8547], [-119.80511, 36.85464], [-119.80503, 36.85452], [-119.80472, 36.85422], [-119.80545, 36.85374], [-119.80631, 36.85323], [-119.80719, 36.85267], [-119.80743, 36.85307], [-119.80951, 36.85256], [-119.81014, 36.85204], [-119.81072, 36.85175], [-119.81139, 36.85174]]], [[[-119.81549, 36.85967], [-119.81481, 36.86091], [-119.81419, 36.8616], [-119.8121, 36.86351], [-119.81095, 36.86565], [-119.81041, 36.86422], [-119.80935, 36.86353], [-119.81125, 36.85939], [-119.81234, 36.85837], [-119.81252, 36.85743], [-119.81541, 36.8596], [-119.81545, 36.85967], [-119.81549, 36.85967]]]]} | No Public Access 3 | 1129 | Spano River Ranch | 25715 | 233 | San Joaquin River Conservancy 827 | State 5 | State Agency 5 | http://sjrc.ca.gov/ | Other State 5 | 3069 | San Joaquin River Parkway and Conservation Trust 491 | Non Profit 6 | Non Profit - Land Trust 10 | Fresno 9 | 412.564 | Spano River Ranch | 0 | State Other or Unknown 104 | 4 | |
6475 | 6475 | 6474 | {"type": "Polygon", "coordinates": [[[-121.89617, 38.24991], [-121.89615, 38.24998], [-121.87929, 38.26469], [-121.87398, 38.27128], [-121.87387, 38.27167], [-121.86064, 38.27158], [-121.84224, 38.27129], [-121.8423, 38.26401], [-121.85159, 38.26407], [-121.85163, 38.25686], [-121.86065, 38.25686], [-121.87945, 38.25708], [-121.87968, 38.24283], [-121.88134, 38.24278], [-121.88895, 38.24283], [-121.88894, 38.24989], [-121.89617, 38.24991]]]} | No Public Access 3 | 2063 | Wilcox Ranch | 27495 | 3081 | Solano Land Trust 361 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/ | Non Governmental Organization 10 | 3081 | Solano Land Trust 358 | Non Profit 6 | Non Profit - Land Trust 10 | Solano 26 | 1547.196 | Wilcox Ranch | 0 | Private Conservation 16 | 2 | |
6485 | 6485 | 6484 | {"type": "Polygon", "coordinates": [[[-122.42915, 37.4505], [-122.42441, 37.45111], [-122.4237, 37.44771], [-122.42139, 37.44799], [-122.42207, 37.45138], [-122.4212, 37.45156], [-122.42026, 37.45163], [-122.41984, 37.45193], [-122.41916, 37.452], [-122.41923, 37.45223], [-122.41992, 37.45214], [-122.42031, 37.45205], [-122.42084, 37.45209], [-122.42128, 37.4518], [-122.42193, 37.45165], [-122.4223, 37.45195], [-122.42254, 37.45206], [-122.4228, 37.45208], [-122.42311, 37.45277], [-122.42398, 37.45264], [-122.42399, 37.45263], [-122.42372, 37.4514], [-122.42444, 37.4513], [-122.42444, 37.45125], [-122.42633, 37.45099], [-122.42851, 37.45072], [-122.42907, 37.45498], [-122.42591, 37.45537], [-122.42568, 37.45538], [-122.42558, 37.45561], [-122.42569, 37.45571], [-122.42605, 37.45582], [-122.42616, 37.45584], [-122.42625, 37.45595], [-122.42609, 37.45635], [-122.42603, 37.45668], [-122.41578, 37.4606], [-122.408, 37.46048], [-122.40801, 37.45877], [-122.40418, 37.45874], [-122.40414, 37.45875], [-122.40427, 37.45048], [-122.4043, 37.44593], [-122.40543, 37.44648], [-122.40559, 37.44648], [-122.40784, 37.44778], [-122.4083, 37.4482], [-122.40899, 37.44868], [-122.40932, 37.44881], [-122.41017, 37.44867], [-122.4107, 37.44888], [-122.41093, 37.44901], [-122.41267, 37.44709], [-122.41194, 37.44597], [-122.41278, 37.44544], [-122.41639, 37.44072], [-122.4184, 37.44079], [-122.41862, 37.44125], [-122.4204, 37.44107], [-122.42062, 37.44148], [-122.42765, 37.44089], [-122.42869, 37.44843], [-122.42885, 37.44915], [-122.42904, 37.44987], [-122.42915, 37.4505]]]} | No Public Access 3 | 2314 | Johnston Ranch | 20484 | 3054 | Peninsula Open Space Trust 338 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 868.418 | Johnston Ranch | 0 | Private Conservation 16 | 2 | |
535 | 535 | 534 | {"type": "Polygon", "coordinates": [[[-121.91117, 36.50829], [-121.9087, 36.50828], [-121.9087, 36.50744], [-121.9081, 36.50743], [-121.90839, 36.50686], [-121.90839, 36.50628], [-121.90807, 36.50595], [-121.90715, 36.50527], [-121.90671, 36.50464], [-121.91113, 36.50468], [-121.91117, 36.50829]]]} | No Public Access 3 | 2572 | Canavarro | 16797 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 27.752 | Canavarro | 0 | Private Conservation 16 | 2 | |
6413 | 6413 | 6412 | {"type": "Polygon", "coordinates": [[[-121.93361, 36.54372], [-121.93342, 36.54391], [-121.9333, 36.54419], [-121.93338, 36.54444], [-121.93337, 36.54452], [-121.93334, 36.54453], [-121.93305, 36.54443], [-121.93288, 36.54441], [-121.93264, 36.54448], [-121.9325, 36.54447], [-121.93239, 36.54448], [-121.93237, 36.54438], [-121.93252, 36.54434], [-121.93284, 36.54436], [-121.93292, 36.54428], [-121.9331, 36.54428], [-121.93338, 36.54376], [-121.93361, 36.54372]]]} | No Public Access 3 | 3340 | Carmel Point | 16873 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 0.545 | Carmel Point | 0 | Private Conservation 16 | 2 | |
6583 | 6583 | 6582 | {"type": "Polygon", "coordinates": [[[-116.4581, 33.88588], [-116.45809, 33.88852], [-116.44949, 33.88855], [-116.44946, 33.88418], [-116.45197, 33.88413], [-116.45236, 33.88407], [-116.45273, 33.88394], [-116.45288, 33.88386], [-116.45302, 33.88378], [-116.45327, 33.88357], [-116.45338, 33.88346], [-116.45357, 33.88321], [-116.45371, 33.88285], [-116.45372, 33.88278], [-116.45374, 33.88679], [-116.45483, 33.88678], [-116.45484, 33.88588], [-116.4581, 33.88588]]]} | No Public Access 3 | 3932 | Edom Hill-Willow Hole Preserve | 18455 | 3025 | Friends of the Desert Mountains 281 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.desertmountains.org/ | Non Governmental Organization 10 | 3025 | Friends of the Desert Mountains 277 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 75.777 | Edom Hill-Willow Hole Preserve | 0 | Private Conservation 16 | 2 | |
5077 | 5077 | 5076 | {"type": "Polygon", "coordinates": [[[-122.94271, 38.43691], [-122.9404, 38.43688], [-122.94039, 38.43541], [-122.94271, 38.43541], [-122.94271, 38.43691]]]} | No Public Access 3 | 4286 | Wild Turkey Hill | 27499 | 3082 | Sonoma Land Trust 245 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 8.25 | Wild Turkey Hill | 0 | Private Conservation 16 | 2 | |
6627 | 6627 | 6626 | {"type": "MultiPolygon", "coordinates": [[[[-123.0685, 38.44179], [-123.06721, 38.44226], [-123.06775, 38.44199], [-123.06805, 38.44185], [-123.06826, 38.44173], [-123.06735, 38.44129], [-123.06652, 38.44187], [-123.06614, 38.44206], [-123.06608, 38.44199], [-123.06594, 38.44205], [-123.06594, 38.44206], [-123.066, 38.44215], [-123.06574, 38.44228], [-123.06514, 38.4424], [-123.06467, 38.44263], [-123.06462, 38.44256], [-123.0641, 38.4427], [-123.06371, 38.44302], [-123.06396, 38.44322], [-123.06383, 38.44332], [-123.06363, 38.44339], [-123.0635, 38.44313], [-123.06282, 38.44334], [-123.06264, 38.44344], [-123.06282, 38.44366], [-123.0618, 38.44418], [-123.0616, 38.44396], [-123.06132, 38.4441], [-123.06132, 38.44411], [-123.0615, 38.44433], [-123.0612, 38.44449], [-123.061, 38.44453], [-123.06037, 38.44473], [-123.06021, 38.44449], [-123.05908, 38.44491], [-123.05828, 38.44528], [-123.0572, 38.44541], [-123.05547, 38.44661], [-123.05497, 38.44715], [-123.05379, 38.44788], [-123.05336, 38.44802], [-123.05349, 38.44828], [-123.05317, 38.44838], [-123.05304, 38.44813], [-123.05287, 38.44819], [-123.05272, 38.44826], [-123.05288, 38.44849], [-123.05257, 38.44863], [-123.0524, 38.44839], [-123.052, 38.44857], [-123.05186, 38.44859], [-123.05192, 38.44886], [-123.05157, 38.44892], [-123.05071, 38.44917], [-123.05014, 38.44906], [-123.04966, 38.4489], [-123.04948, 38.44895], [-123.049, 38.44869], [-123.0484, 38.44852], [-123.04563, 38.4493], [-123.04533, 38.44933], [-123.04525, 38.44932], [-123.06353, 38.44115], [-123.06541, 38.44033], [-123.0685, 38.44179]]], [[[-123.05256, 38.449], [-123.0513, 38.44936], [-123.05075, 38.44929], [-123.05082, 38.44927], [-123.05123, 38.44933], [-123.05142, 38.44921], [-123.05138, 38.44909], [-123.05161, 38.44902], [-123.05216, 38.44894], [-123.05243, 38.44882], [-123.05256, 38.449]]], [[[-123.0603, 38.44521], [-123.05985, 38.44546], [-123.05775, 38.44646], [-123.0559, 38.44732], [-123.05454, 38.4481], [-123.05361, 38.44851], [-123.05284, 38.44889], [-123.05296, 38.44879], [-123.05286, 38.44863], [-123.05308, 38.44853], [-123.05373, 38.44831], [-123.05379, 38.4484], [-123.05441, 38.44813], [-123.05465, 38.44801], [-123.05486, 38.44786], [-123.05525, 38.44764], [-123.05545, 38.4475], [-123.05563, 38.44742], [-123.0557, 38.44734], [-123.056, 38.44716], [-123.05616, 38.4471], [-123.05629, 38.44701], [-123.05645, 38.44694], [-123.05663, 38.4469], [-123.05678, 38.44682], [-123.05712, 38.44671], [-123.05725, 38.44663], [-123.05757, 38.4465], [-123.05769, 38.44641], [-123.05775, 38.44632], [-123.05801, 38.44616], [-123.05856, 38.44589], [-123.05963, 38.4455], [-123.05978, 38.44541], [-123.05995, 38.44538], [-123.0603, 38.44521]]], [[[-123.06203, 38.44435], [-123.0618, 38.44444], [-123.06172, 38.44435], [-123.06194, 38.44424], [-123.06203, 38.44435]]], [[[-123.06332, 38.44375], [-123.06268, 38.44402], [-123.06247, 38.44411], [-123.06292, 38.44389], [-123.06332, 38.44375]]], [[[-123.06581, 38.44282], [-123.06581, 38.44282], [-123.06508, 38.4431], [-123.06541, 38.44291], [-123.06581, 38.44282]]], [[[-123.06651, 38.44255], [-123.06628, 38.44264], [-123.06611, 38.44271], [-123.06625, 38.44264], [-123.06651, 38.44255]]]]} | No Public Access 3 | 4313 | Freezeout Redwoods | 19095 | 3082 | Sonoma Land Trust 245 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 90.373 | Freezeout Redwoods | 0 | Private Conservation 16 | 2 | |
6631 | 6631 | 6630 | {"type": "Polygon", "coordinates": [[[-122.55345, 38.40221], [-122.55342, 38.40221], [-122.55339, 38.40241], [-122.55334, 38.40261], [-122.5533, 38.4027], [-122.55328, 38.4027], [-122.55302, 38.40335], [-122.5529, 38.40379], [-122.55285, 38.40389], [-122.55273, 38.40398], [-122.55259, 38.40403], [-122.55217, 38.40408], [-122.55197, 38.40413], [-122.55139, 38.40441], [-122.55123, 38.40451], [-122.55114, 38.40465], [-122.55105, 38.40484], [-122.55103, 38.405], [-122.55083, 38.40493], [-122.55088, 38.40472], [-122.55094, 38.40461], [-122.55106, 38.40447], [-122.55121, 38.40434], [-122.5516, 38.40414], [-122.5516, 38.40413], [-122.55188, 38.40399], [-122.55214, 38.40394], [-122.55215, 38.40392], [-122.55253, 38.40387], [-122.55263, 38.40384], [-122.5527, 38.40377], [-122.55274, 38.40369], [-122.55286, 38.40326], [-122.55313, 38.40259], [-122.55315, 38.40258], [-122.55323, 38.40229], [-122.55325, 38.40214], [-122.55327, 38.40213], [-122.55327, 38.40197], [-122.55321, 38.40156], [-122.5528, 38.40071], [-122.55261, 38.40048], [-122.55248, 38.40036], [-122.55232, 38.40025], [-122.55216, 38.40016], [-122.55176, 38.39998], [-122.55175, 38.39995], [-122.55175, 38.39974], [-122.55218, 38.40001], [-122.55243, 38.40014], [-122.5526, 38.40026], [-122.55275, 38.40039], [-122.55288, 38.40054], [-122.55298, 38.4007], [-122.55313, 38.40102], [-122.55308, 38.40105], [-122.55324, 38.4014], [-122.55329, 38.40139], [-122.55336, 38.40156], [-122.55344, 38.40188], [-122.55345, 38.40221]]]} | No Public Access 3 | 4368 | Sonoma Creek | 25610 | 3082 | Sonoma Land Trust 245 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 2.815 | Sonoma Creek | 0 | Private Conservation 16 | 2 | |
6623 | 6623 | 6622 | {"type": "Polygon", "coordinates": [[[-122.49158, 38.37294], [-122.48674, 38.37294], [-122.48673, 38.37656], [-122.48236, 38.37662], [-122.47299, 38.37632], [-122.47319, 38.37272], [-122.47777, 38.37286], [-122.47772, 38.3675], [-122.48226, 38.3676], [-122.48224, 38.3657], [-122.49147, 38.36576], [-122.49158, 38.37294]]]} | No Public Access 3 | 4390 | Secret Pasture | 25280 | 3082 | Sonoma Land Trust 245 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 336.926 | Secret Pasture | 0 | Private Conservation 16 | 2 | |
722 | 722 | 721 | {"type": "Polygon", "coordinates": [[[-122.83574, 38.70857], [-122.83404, 38.71439], [-122.83246, 38.71428], [-122.83195, 38.71361], [-122.83141, 38.71316], [-122.83003, 38.71381], [-122.82919, 38.71302], [-122.82746, 38.71228], [-122.83039, 38.70765], [-122.83203, 38.70502], [-122.83218, 38.70502], [-122.83233, 38.70496], [-122.8323, 38.70537], [-122.83227, 38.70615], [-122.8323, 38.7063], [-122.83238, 38.70645], [-122.83245, 38.70654], [-122.83257, 38.70664], [-122.83314, 38.70693], [-122.83334, 38.70706], [-122.83352, 38.70722], [-122.83367, 38.70739], [-122.83381, 38.7076], [-122.83389, 38.70777], [-122.83393, 38.70792], [-122.83402, 38.7081], [-122.83426, 38.70838], [-122.83441, 38.7085], [-122.83459, 38.7086], [-122.83473, 38.70865], [-122.83492, 38.70869], [-122.83514, 38.70871], [-122.83533, 38.7087], [-122.83555, 38.70865], [-122.83574, 38.70857]]]} | No Public Access 3 | 4458 | White Rock Preserve | 27465 | 3082 | Sonoma Land Trust 245 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 96.596 | White Rock Preserve | 0 | Private Conservation 16 | 2 | |
6733 | 6733 | 6732 | {"type": "Polygon", "coordinates": [[[-122.26297, 37.36581], [-122.26293, 37.36582], [-122.26294, 37.36592], [-122.26289, 37.366], [-122.26272, 37.36607], [-122.26276, 37.36619], [-122.26253, 37.3663], [-122.26254, 37.36633], [-122.26196, 37.3666], [-122.26183, 37.36669], [-122.26172, 37.36682], [-122.26162, 37.36681], [-122.26152, 37.36705], [-122.26144, 37.36742], [-122.26114, 37.36769], [-122.26095, 37.36784], [-122.25955, 37.36619], [-122.25746, 37.36678], [-122.25731, 37.36693], [-122.25716, 37.36693], [-122.25676, 37.36685], [-122.25656, 37.36685], [-122.25591, 37.36707], [-122.25591, 37.36709], [-122.25754, 37.36708], [-122.25735, 37.36729], [-122.25712, 37.36737], [-122.25659, 37.36747], [-122.25607, 37.3679], [-122.25625, 37.36822], [-122.25641, 37.36838], [-122.25649, 37.36878], [-122.25633, 37.36893], [-122.25575, 37.36932], [-122.25549, 37.36961], [-122.25449, 37.36977], [-122.2546, 37.37023], [-122.25415, 37.37047], [-122.25367, 37.37042], [-122.25352, 37.37051], [-122.25348, 37.37056], [-122.25198, 37.37054], [-122.25143, 37.37084], [-122.24809, 37.36765], [-122.24793, 37.36745], [-122.24782, 37.36723], [-122.24778, 37.36702], [-122.24778, 37.36678], [-122.24781, 37.36661], [-122.24803, 37.36597], [-122.24807, 37.36582], [-122.2481, 37.36551], [-122.24807, 37.36515], [-122.24799, 37.36485], [-122.24783, 37.36452], [-122.24767, 37.36428], [-122.24738, 37.36395], [-122.24723, 37.3637], [-122.24712, 37.36339], [-122.24709, 37.36316], [-122.2471, 37.36294], [-122.24714, 37.36277], [-122.2478, 37.36071], [-122.24787, 37.36035], [-122.24788, 37.35992], [-122.24784, 37.35955], [-122.24775, 37.35918], [-122.24758, 37.35877], [-122.2474, 37.35843], [-122.24716, 37.35811], [-122.24689, 37.35781], [-122.24663, 37.35758], [-122.24617, 37.35725], [-122.24499, 37.35659], [-122.24474, 37.35643], [-122.24434, 37.35615], [-122.24404, 37.35589], [-122.24309, 37.35486], [-122.24322, 37.35412], [-122.24159, 37.35276], [-122.24157, 37.3532], [-122.24052, 37.35199], [-122.24016, 37.35169], [-122.23978, 37.3514], [-122.23934, 37.35112], [-122.23684, 37.34972], [-122.23632, 37.3495], [-122.23577, 37.34935], [-122.23539, 37.34929], [-122.23472, 37.34923], [-122.23411, 37.34915], [-122.23331, 37.34901], [-122.23297, 37.34892], [-122.23255, 37.34879], [-122.23216, 37.34863], [-122.23184, 37.34848], [-122.23141, 37.34823], [-122.23091, 37.34787], [-122.23063, 37.34762], [-122.23043, 37.34741], [-122.23016, 37.34707], [-122.22922, 37.34553], [-122.22907, 37.34532], [-122.22892, 37.34515], [-122.22871, 37.34496], [-122.22832, 37.34469], [-122.22793, 37.3445], [-122.22718, 37.34426], [-122.22658, 37.344], [-122.22617, 37.34379], [-122.22553, 37.34334], [-122.22507, 37.34306], [-122.2247, 37.34286], [-122.2242, 37.34263], [-122.22021, 37.34108], [-122.22031, 37.34095], [-122.22084, 37.3407], [-122.22131, 37.34038], [-122.22208, 37.33983], [-122.22255, 37.33933], [-122.22275, 37.33916], [-122.22312, 37.33907], [-122.22346, 37.33901], [-122.22384, 37.33882], [-122.2241, 37.33836], [-122.22439, 37.33817], [-122.23254, 37.34143], [-122.23255, 37.34137], [-122.23257, 37.33717], [-122.23272, 37.33733], [-122.23292, 37.33764], [-122.23299, 37.33771], [-122.23315, 37.33784], [-122.23331, 37.33794], [-122.23378, 37.33815], [-122.2345, 37.33833], [-122.23478, 37.33847], [-122.23506, 37.33859], [-122.23528, 37.33862], [-122.23581, 37.33858], [-122.23624, 37.33858], [-122.2369, 37.3385], [-122.23723, 37.33848], [-122.23756, 37.3385], [-122.23787, 37.33858], [-122.23834, 37.3388], [-122.23871, 37.339], [-122.23895, 37.33917], [-122.23925, 37.33942], [-122.23996, 37.33994], [-122.24023, 37.34007], [-122.24044, 37.34011], [-122.24066, 37.34013], [-122.24098, 37.34011], [-122.24151, 37.34004], [-122.24164, 37.34006], [-122.24165, 37.34002], [-122.2423, 37.33997], [-122.24265, 37.33987], [-122.24311, 37.34], [-122.24378, 37.3401], [-122.24469, 37.34028], [-122.24808, 37.34109], [-122.24816, 37.34126], [-122.24853, 37.34139], [-122.24874, 37.34137], [-122.24905, 37.34148], [-122.24943, 37.3415], [-122.24971, 37.34147], [-122.24999, 37.34154], [-122.25041, 37.34133], [-122.25051, 37.34144], [-122.25065, 37.34142], [-122.25066, 37.34157], [-122.2594, 37.34161], [-122.25934, 37.34519], [-122.25864, 37.34713], [-122.25656, 37.34655], [-122.25414, 37.3493], [-122.25066, 37.35067], [-122.25064, 37.35264], [-122.25062, 37.3599], [-122.25309, 37.35989], [-122.25303, 37.35994], [-122.25305, 37.36007], [-122.25364, 37.36022], [-122.25401, 37.36053], [-122.25434, 37.36088], [-122.25431, 37.36107], [-122.25349, 37.36171], [-122.25318, 37.36187], [-122.25304, 37.36212], [-122.25312, 37.36237], [-122.25301, 37.3625], [-122.25264, 37.36259], [-122.252, 37.36294], [-122.25208, 37.36308], [-122.25254, 37.36305], [-122.25296, 37.36313], [-122.25341, 37.36297], [-122.25397, 37.36309], [-122.2542, 37.36333], [-122.25427, 37.36359], [-122.25452, 37.36351], [-122.25467, 37.36309], [-122.25502, 37.36297], [-122.25569, 37.36291], [-122.25656, 37.363], [-122.25673, 37.36349], [-122.25668, 37.36381], [-122.25697, 37.36404], [-122.25706, 37.36388], [-122.25925, 37.36259], [-122.25961, 37.36297], [-122.25971, 37.36312], [-122.25991, 37.36308], [-122.26002, 37.36302], [-122.26008, 37.36294], [-122.26015, 37.36277], [-122.26028, 37.36266], [-122.26044, 37.3626], [-122.26061, 37.36259], [-122.26043, 37.36268], [-122.26031, 37.36277], [-122.26021, 37.36289], [-122.26015, 37.36301], [-122.26012, 37.36314], [-122.26012, 37.36329], [-122.26016, 37.36344], [-122.26024, 37.36357], [-122.26034, 37.36367], [-122.26046, 37.36376], [-122.26112, 37.36408], [-122.26113, 37.36413], [-122.26126, 37.3642], [-122.2616, 37.36431], [-122.26212, 37.3644], [-122.26225, 37.36445], [-122.26238, 37.36453], [-122.26252, 37.36467], [-122.26294, 37.3656], [-122.2629, 37.36562], [-122.26297, 37.36581]]]} | No Public Access 3 | 5065 | Audubon Society | 15704 | 3075 | Sequoia Audubon Society 844 | Non Profit 6 | Non Profit - Conservation 12 | http://www.sequoia-audubon.org/ | Non Governmental Organization 10 | 3075 | Sequoia Audubon Society 821 | Non Profit 6 | Non Profit - Conservation 12 | San Mateo 15 | 1126.809 | Audubon Society | 2001 | Private Conservation 16 | 2 | |
6758 | 6758 | 6757 | {"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.85819], [-122.58066, 37.85798], [-122.58082, 37.85776], [-122.581, 37.85765], [-122.58118, 37.85765], [-122.5813, 37.8577], [-122.58138, 37.85771], [-122.58154, 37.85766], [-122.58159, 37.85762], [-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.85743], [-122.58256, 37.85746], [-122.58261, 37.85753]]]} | No Public Access 3 | 5139 | Spindrift Preserve | 30615 | 3091 | The Nature Conservancy 63 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | Marin 23 | 4.223 | Spindrift Preserve | 0 | Private Conservation 16 | 2 | |
799 | 799 | 798 | {"type": "MultiPolygon", "coordinates": [[[[-122.49991, 37.92691], [-122.49942, 37.92654], [-122.49818, 37.92572], [-122.49764, 37.92506], [-122.49509, 37.9251], [-122.49504, 37.92293], [-122.49312, 37.92144], [-122.49266, 37.92106], [-122.49265, 37.92043], [-122.49443, 37.92114], [-122.4948, 37.92124], [-122.49531, 37.9213], [-122.49545, 37.92131], [-122.49582, 37.92128], [-122.49619, 37.92123], [-122.49656, 37.92115], [-122.49691, 37.92104], [-122.4973, 37.92089], [-122.49736, 37.92428], [-122.49981, 37.92613], [-122.49991, 37.92691]]], [[[-122.50704, 37.92484], [-122.50678, 37.92501], [-122.50662, 37.92499], [-122.50631, 37.92523], [-122.5058, 37.92533], [-122.50532, 37.92522], [-122.50562, 37.92509], [-122.50587, 37.92491], [-122.50632, 37.9244], [-122.50704, 37.92484]]]]} | No Public Access 3 | 5189 | Triangle Marsh | 26529 | 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 | 33.876 | Triangle Marsh | 1999 | Private Conservation 16 | 2 | |
15947 | 15947 | 15946 | {"type": "Polygon", "coordinates": [[[-122.49954, 37.89424], [-122.49884, 37.89498], [-122.49752, 37.89514], [-122.49729, 37.89525], [-122.49639, 37.89483], [-122.49647, 37.89479], [-122.49673, 37.89397], [-122.49747, 37.89359], [-122.49821, 37.89349], [-122.49911, 37.89369], [-122.49954, 37.89424]]]} | No Public Access 3 | 5202 | Audubon Society Lyford House Open Space Area | 15705 | 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 | Marin 23 | 9.091 | Audubon Society Lyford House OS Area | 0 | Private Conservation 16 | 2 | |
6800 | 6800 | 6799 | {"type": "Polygon", "coordinates": [[[-116.32668, 33.22441], [-116.32666, 33.22675], [-116.32578, 33.22675], [-116.32579, 33.22442], [-116.32668, 33.22441]]]} | No Public Access 3 | 5312 | Mesquite Bosque | 28286 | 3004 | Anza-Borrego Foundation 836 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.theabf.org/ | Non Governmental Organization 10 | 3004 | Anza-Borrego Foundation 822 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 5.285 | Mesquite Bosque | 0 | Private Conservation 16 | 2 | |
6810 | 6810 | 6809 | {"type": "MultiPolygon", "coordinates": [[[[-122.65173, 37.90384], [-122.65158, 37.90401], [-122.65115, 37.90382], [-122.65129, 37.90362], [-122.65173, 37.90384]]], [[[-122.81765, 38.06146], [-122.81754, 38.06146], [-122.81245, 38.06286], [-122.81194, 38.06173], [-122.81125, 38.0612], [-122.81059, 38.06056], [-122.81039, 38.06027], [-122.81315, 38.06025], [-122.812, 38.0582], [-122.81371, 38.05837], [-122.81468, 38.05828], [-122.81566, 38.05855], [-122.81608, 38.05902], [-122.81638, 38.05949], [-122.81568, 38.05977], [-122.8158, 38.06056], [-122.81601, 38.06082], [-122.8167, 38.06063], [-122.81701, 38.06047], [-122.81765, 38.06146]]], [[[-122.84113, 38.10518], [-122.84095, 38.10548], [-122.84078, 38.10549], [-122.84085, 38.1053], [-122.84071, 38.10517], [-122.8379, 38.10183], [-122.83231, 38.09736], [-122.8317, 38.09725], [-122.83173, 38.09716], [-122.83238, 38.09725], [-122.83803, 38.10165], [-122.84015, 38.10423], [-122.84113, 38.10518]]], [[[-122.83548, 38.08171], [-122.8341, 38.08231], [-122.83189, 38.08006], [-122.83318, 38.07953], [-122.83486, 38.08077], [-122.83548, 38.08171]]], [[[-122.84228, 38.08864], [-122.84103, 38.08934], [-122.84025, 38.08854], [-122.8415, 38.08785], [-122.84196, 38.08828], [-122.84228, 38.08864]]], [[[-122.85899, 38.10407], [-122.85845, 38.10455], [-122.85783, 38.10436], [-122.85849, 38.10377], [-122.85899, 38.10407]]], [[[-122.88891, 38.15011], [-122.88843, 38.15017], [-122.88843, 38.15004], [-122.88809, 38.14962], [-122.88773, 38.14911], [-122.88745, 38.14878], [-122.8871, 38.14862], [-122.88702, 38.1485], [-122.88743, 38.14817], [-122.88891, 38.15011]]], [[[-122.90414, 38.17203], [-122.90388, 38.1729], [-122.90099, 38.17342], [-122.90073, 38.17342], [-122.90071, 38.17341], [-122.90057, 38.17348], [-122.89968, 38.17359], [-122.89957, 38.17346], [-122.89817, 38.17223], [-122.89797, 38.1721], [-122.89788, 38.17201], [-122.8981, 38.17137], [-122.89817, 38.17107], [-122.89817, 38.17075], [-122.89666, 38.16946], [-122.89646, 38.16909], [-122.89614, 38.16871], [-122.89591, 38.16839], [-122.89553, 38.16803], [-122.89503, 38.16771], [-122.89481, 38.16759], [-122.89522, 38.16725], [-122.89567, 38.16713], [-122.89675, 38.16701], [-122.89643, 38.16566], [-122.89875, 38.16535], [-122.89916, 38.16474], [-122.89978, 38.16476], [-122.89978, 38.16475], [-122.89764, 38.16335], [-122.8959, 38.16296], [-122.89509, 38.16292], [-122.89436, 38.16304], [-122.89316, 38.16389], [-122.89236, 38.16462], [-122.89211, 38.16516], [-122.89186, 38.16501], [-122.89146, 38.16489], [-122.89135, 38.16483], [-122.89129, 38.16478], [-122.89125, 38.16471], [-122.89124, 38.1646], [-122.89127, 38.16448], [-122.89132, 38.16436], [-122.8914, 38.16425], [-122.8915, 38.16416], [-122.89186, 38.1639], [-122.89328, 38.16265], [-122.89357, 38.16257], [-122.89441, 38.16289], [-122.8947, 38.16257], [-122.89613, 38.16248], [-122.89614, 38.16233], [-122.89659, 38.16232], [-122.89876, 38.16323], [-122.89926, 38.16406], [-122.8998, 38.16436], [-122.8998, 38.16438], [-122.9005, 38.16468], [-122.90055, 38.16467], [-122.9016, 38.16537], [-122.90178, 38.16563], [-122.90182, 38.16565], [-122.90374, 38.16866], [-122.90376, 38.17108], [-122.90414, 38.17203]]], [[[-122.8953, 38.15984], [-122.89499, 38.16023], [-122.89451, 38.16011], [-122.89461, 38.15988], [-122.89466, 38.15964], [-122.89466, 38.15951], [-122.89463, 38.15927], [-122.89519, 38.15913], [-122.89532, 38.15957], [-122.8953, 38.15984]]], [[[-122.9089, 38.17946], [-122.90852, 38.17959], [-122.90767, 38.17868], [-122.90822, 38.1784], [-122.90889, 38.17903], [-122.9089, 38.17946]]], [[[-122.91023, 38.18131], [-122.90988, 38.18144], [-122.90983, 38.18128], [-122.90925, 38.18048], [-122.9092, 38.18027], [-122.90917, 38.18024], [-122.90944, 38.18015], [-122.90968, 38.18042], [-122.91023, 38.18131]]], [[[-122.9139, 38.18884], [-122.91364, 38.18905], [-122.91333, 38.18876], [-122.91308, 38.18846], [-122.91357, 38.18817], [-122.91378, 38.18817], [-122.9139, 38.18884]]], [[[-122.9214, 38.19643], [-122.9201, 38.19691], [-122.91995, 38.19678], [-122.9198, 38.19668], [-122.91973, 38.1966], [-122.91967, 38.1965], [-122.91962, 38.19635], [-122.91961, 38.19605], [-122.91957, 38.19585], [-122.91937, 38.19542], [-122.91927, 38.19517], [-122.92039, 38.19433], [-122.92138, 38.19633], [-122.9214, 38.19643]]], [[[-122.93386, 38.21111], [-122.9338, 38.21165], [-122.93265, 38.21197], [-122.93186, 38.21209], [-122.93142, 38.21286], [-122.92912, 38.21517], [-122.92848, 38.21643], [-122.9281, 38.21748], [-122.9263, 38.21878], [-122.92671, 38.21776], [-122.92653, 38.21229], [-122.92681, 38.20867], [-122.92772, 38.20701], [-122.92895, 38.20698], [-122.92999, 38.20915], [-122.93386, 38.21111]]], [[[-122.95406, 38.21874], [-122.95301, 38.22084], [-122.95266, 38.22165], [-122.95101, 38.22065], [-122.94925, 38.22001], [-122.94862, 38.21989], [-122.94773, 38.22016], [-122.94698, 38.21992], [-122.94759, 38.21871], [-122.94857, 38.21768], [-122.94896, 38.21746], [-122.94924, 38.2168], [-122.95, 38.21597], [-122.94996, 38.21568], [-122.95169, 38.21495], [-122.95283, 38.21445], [-122.95303, 38.21456], [-122.9531, 38.21482], [-122.95354, 38.21541], [-122.95386, 38.21699], [-122.95364, 38.2184], [-122.95369, 38.21852], [-122.95406, 38.21874]]]]} | No Public Access 3 | 5363 | Audubon Canyon Ranch | 15702 | 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 | 380.201 | Audubon Canyon Ranch | 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]);