units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
148 rows where MNG_AG_TYP = 12 sorted by AGNCY_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, COUNTY, GAP_STS
MNG_AGENCY >30
- National Audubon Society 32
- Mountains Restoration Trust 30
- Endangered Habitats Conservancy 14
- Del Monte Forest Foundation 10
- Marin Audubon Society 9
- San Diego River Park Foundation 7
- Audubon Canyon Ranch 5
- Irvine Ranch Conservancy 4
- Trust for Public Land 3
- Morro Coast Audubon Society 2
- Community Environmental Council 2
- Friends of the Enchanted Meadow 2
- California Biological Field Studies Association 1
- California Academy of Sciences 1
- Friends of the Dunes 1
- North Star Historic Conservancy 1
- Serra Cross Conservancy 1
- Westport Village Society 1
- Friends of Palm Springs Mountains 1
- San Diego Audubon Society 1
- Sequoia Audubon Society 1
- The Living Desert 1
- The Old Mill Foundation 1
- North Fork Association 1
- Elings Park Foundation 1
- Moat Creek Managing Agency 1
- Redwood Coast Land Conservancy 1
- Trust for Hidden Villa 1
- Friends of the Tuolumne 1
- Palo Cerdo Community Park Association 1
- …
DES_TP 17
- Private Conservation 92
- Private Recreation or Education 35
- Private Other or Unknown 7
- State Recreation Area 1
- National Monument or Landmark 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 4
- Open Access 55
- No Public Access 50
- Unknown Access 23
- Restricted Access 20
MNG_AG_TYP 1
- Non Profit - Conservation · 148 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16810 | 16810 | 16809 | {"type": "Polygon", "coordinates": [[[-123.53176, 38.79603], [-123.52979, 38.79762], [-123.52905, 38.79637], [-123.52785, 38.79494], [-123.52811, 38.79484], [-123.52838, 38.79482], [-123.5285, 38.79482], [-123.52897, 38.79489], [-123.52942, 38.79536], [-123.53153, 38.79567], [-123.53176, 38.79603]]]} | Open Access 1 | 48503 | Redwood Coast Recreation Center | 33212 | 3389 | Redwood Coast Recreation Center 1176 | Non Profit 6 | Non Profit - Conservation 12 | http://rcrcpool.org/#about | Non Governmental Organization 10 | 3389 | Redwood Coast Recreation Center 1116 | Non Profit 6 | Non Profit - Conservation 12 | http://rcrcpool.org/ | Mendocino 24 | 11.148 | Redwood Coast Rec. Ctr. | 1999 | 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 |
14355 | 14355 | 14354 | {"type": "Polygon", "coordinates": [[[-121.17744, 37.60579], [-121.17736, 37.60597], [-121.17728, 37.60603], [-121.17707, 37.60609], [-121.17683, 37.60609], [-121.17638, 37.60601], [-121.17508, 37.60553], [-121.17465, 37.60545], [-121.17401, 37.60516], [-121.17283, 37.60475], [-121.17251, 37.60448], [-121.17234, 37.6044], [-121.17206, 37.60435], [-121.17177, 37.60439], [-121.17086, 37.60473], [-121.17049, 37.6049], [-121.17019, 37.60519], [-121.16969, 37.60581], [-121.1695, 37.60618], [-121.16863, 37.60742], [-121.16844, 37.6078], [-121.16796, 37.60817], [-121.16769, 37.60844], [-121.16758, 37.60865], [-121.16732, 37.60892], [-121.16726, 37.60907], [-121.16728, 37.60932], [-121.1673, 37.60955], [-121.16742, 37.60995], [-121.16742, 37.61022], [-121.16763, 37.61074], [-121.16786, 37.61118], [-121.1679, 37.61136], [-121.16788, 37.61154], [-121.16771, 37.61217], [-121.16759, 37.61235], [-121.16688, 37.61303], [-121.16643, 37.61334], [-121.16539, 37.61363], [-121.16516, 37.61373], [-121.16448, 37.61394], [-121.16402, 37.61399], [-121.16278, 37.61398], [-121.1619, 37.61413], [-121.16134, 37.61416], [-121.16111, 37.61414], [-121.16066, 37.61425], [-121.15967, 37.61467], [-121.15928, 37.61479], [-121.15911, 37.61486], [-121.15837, 37.61491], [-121.15756, 37.61477], [-121.15682, 37.61452], [-121.15635, 37.61428], [-121.15595, 37.61386], [-121.15585, 37.61372], [-121.15568, 37.61321], [-121.15546, 37.61282], [-121.15547, 37.61239], [-121.15558, 37.61194], [-121.15581, 37.6115], [-121.15604, 37.61123], [-121.15614, 37.61105], [-121.15635, 37.61048], [-121.15635, 37.61003], [-121.15628, 37.6096], [-121.15597, 37.60913], [-121.15557, 37.60884], [-121.15536, 37.60874], [-121.15464, 37.60861], [-121.15396, 37.60852], [-121.15295, 37.60827], [-121.15273, 37.60819], [-121.15192, 37.608], [-121.15154, 37.60787], [-121.15092, 37.60758], [-121.15053, 37.60732], [-121.15018, 37.60695], [-121.14939, 37.60647], [-121.14898, 37.60628], [-121.14848, 37.60623], [-121.14793, 37.60619], [-121.14748, 37.60626], [-121.1461, 37.60659], [-121.14503, 37.60678], [-121.14455, 37.60704], [-121.14432, 37.60712], [-121.14397, 37.60717], [-121.14341, 37.60717], [-121.14319, 37.60704], [-121.14287, 37.60673], [-121.14288, 37.60613], [-121.1427, 37.6056], [-121.14267, 37.6047], [-121.14276, 37.60462], [-121.14265, 37.60447], [-121.14223, 37.60327], [-121.14179, 37.60253], [-121.14155, 37.60185], [-121.14132, 37.60157], [-121.14117, 37.60149], [-121.14161, 37.60116], [-121.14239, 37.60117], [-121.14285, 37.60069], [-121.14466, 37.60018], [-121.14498, 37.59964], [-121.14542, 37.59926], [-121.14584, 37.59841], [-121.14576, 37.59774], [-121.14606, 37.59758], [-121.14585, 37.597], [-121.14515, 37.59634], [-121.14305, 37.59483], [-121.1465, 37.59484], [-121.1467, 37.59413], [-121.14689, 37.59386], [-121.14728, 37.5919], [-121.1472, 37.5908], [-121.1471, 37.58988], [-121.14712, 37.58915], [-121.14673, 37.58759], [-121.17067, 37.58736], [-121.17111, 37.58795], [-121.17124, 37.5883], [-121.1713, 37.58952], [-121.17113, 37.59029], [-121.17109, 37.59083], [-121.17103, 37.59088], [-121.17117, 37.59159], [-121.17141, 37.59209], [-121.17147, 37.59236], [-121.17164, 37.59278], [-121.17214, 37.5932], [-121.17245, 37.59326], [-121.1729, 37.59326], [-121.17347, 37.59336], [-121.17421, 37.59337], [-121.17562, 37.59347], [-121.17577, 37.59351], [-121.17612, 37.59381], [-121.17626, 37.59399], [-121.17636, 37.59417], [-121.17641, 37.59435], [-121.17641, 37.59444], [-121.17627, 37.59513], [-121.17565, 37.59593], [-121.17544, 37.59606], [-121.17464, 37.59642], [-121.17385, 37.59664], [-121.17304, 37.59675], [-121.17214, 37.59681], [-121.17191, 37.59686], [-121.17131, 37.59692], [-121.17056, 37.59717], [-121.17016, 37.59742], [-121.17, 37.59761], [-121.16988, 37.59779], [-121.16976, 37.59812], [-121.16975, 37.59851], [-121.16983, 37.59886], [-121.17021, 37.59941], [-121.1704, 37.59958], [-121.17061, 37.59971], [-121.17139, 37.60008], [-121.17162, 37.60015], [-121.17224, 37.60024], [-121.1725, 37.60025], [-121.17309, 37.6001], [-121.17366, 37.60001], [-121.1739, 37.59991], [-121.17469, 37.59949], [-121.17526, 37.59914], [-121.17637, 37.5983], [-121.17671, 37.59814], [-121.17688, 37.59809], [-121.17726, 37.59809], [-121.17781, 37.59825], [-121.17798, 37.59833], [-121.17849, 37.59868], [-121.17862, 37.59885], [-121.17887, 37.59931], [-121.17888, 37.59949], [-121.17886, 37.59958], [-121.17875, 37.59975], [-121.17855, 37.59991], [-121.17805, 37.60022], [-121.17728, 37.60091], [-121.1769, 37.60131], [-121.17668, 37.60147], [-121.17653, 37.60163], [-121.17608, 37.60243], [-121.17604, 37.60261], [-121.17607, 37.60298], [-121.17602, 37.60302], [-121.17608, 37.6031], [-121.17598, 37.60346], [-121.17623, 37.60417], [-121.17632, 37.60435], [-121.17687, 37.60511], [-121.17725, 37.60551], [-121.17739, 37.60555], [-121.17736, 37.60561], [-121.17744, 37.60579]]]} | Restricted Access 2 | 44406 | Dos Rios Ranch | 18230 | 3205 | River Partners 1110 | Non Profit 6 | Non Profit - Conservation 12 | http://riverpartners.org/ | Non Governmental Organization 10 | 3205 | River Partners 1064 | Non Profit 6 | Non Profit - Conservation 12 | Stanislaus 2 | 1563.144 | Dos Rios Ranch | 0 | Private Conservation 16 | 2 | |
14122 | 14122 | 14121 | {"type": "Polygon", "coordinates": [[[-122.13412, 37.04584], [-122.12416, 37.04584], [-122.12374, 37.03804], [-122.12409, 37.03802], [-122.12439, 37.03056], [-122.12933, 37.03038], [-122.13387, 37.03032], [-122.13403, 37.04029], [-122.13408, 37.0403], [-122.13412, 37.04584]]]} | No Public Access 3 | 42000 | Big Basin Cemex | 16072 | 3200 | Living Landscape Initiative Partners 1073 | Non Profit 6 | Non Profit - Conservation 12 | http://www.livinglandscapeinitiative.org/ | Non Governmental Organization 10 | 3200 | Living Landscape Initiative Partners 1029 | Non Profit 6 | Non Profit - Conservation 12 | Santa Cruz 5 | 372.993 | Big Basin Cemex | 0 | Private Conservation 16 | 2 | |
13114 | 13114 | 13113 | {"type": "Polygon", "coordinates": [[[-118.24324, 33.90596], [-118.243, 33.90596], [-118.24296, 33.90579], [-118.2428, 33.90555], [-118.24267, 33.90547], [-118.24228, 33.90547], [-118.24206, 33.90556], [-118.24174, 33.90563], [-118.24154, 33.90508], [-118.24172, 33.90504], [-118.24174, 33.90502], [-118.24165, 33.90478], [-118.24133, 33.90457], [-118.24197, 33.90439], [-118.24199, 33.9044], [-118.24323, 33.90582], [-118.24324, 33.90596]]]} | Open Access 1 | 45034 | Compton Creek-Washington Elementary | 27986 | 2341 | Compton Unified School District 1043 | Special District 4 | School District 14 | http://web.compton.k12.ca.us/index.aspx | Special District 4 | 3384 | Los Angeles Conservation Corps 1004 | Non Profit 6 | Non Profit - Conservation 12 | https://mrca.ca.gov/parks/park-listing/compton-creek-natural-park-at-george-washington-elementary/ | Los Angeles 6 | 2.729 | Compton Creek-Washington Elementary | None 1137 | ||
12734 | 12734 | 12733 | {"type": "Polygon", "coordinates": [[[-122.47026, 38.03457], [-122.47026, 38.03457], [-122.46444, 38.03432], [-122.46746, 38.02948], [-122.47021, 38.02945], [-122.47026, 38.03457]]]} | Open Access 1 | 29764 | Water Lots | 27295 | 3130 | Marin Conservation League 1035 | Non Profit 6 | Non Profit - Conservation 12 | http://www.marinconservationleague.org/ | Non Governmental Organization 10 | 3130 | Marin Conservation League 997 | Non Profit 6 | Non Profit - Conservation 12 | Marin 23 | 51.863 | Water Lots | 0 | Private Conservation 16 | 2 | |
14677 | 14677 | 14676 | {"type": "MultiPolygon", "coordinates": [[[[-122.49119, 37.8781], [-122.48776, 37.88368], [-122.48737, 37.88444], [-122.48336, 37.88288], [-122.48238, 37.8846], [-122.48632, 37.88604], [-122.4838, 37.89047], [-122.48247, 37.88939], [-122.48215, 37.88917], [-122.48181, 37.88898], [-122.48152, 37.88884], [-122.47989, 37.88823], [-122.47913, 37.88787], [-122.48029, 37.8859], [-122.48068, 37.88606], [-122.4814, 37.88629], [-122.48237, 37.8846], [-122.48122, 37.88414], [-122.48609, 37.87599], [-122.48677, 37.87623], [-122.49119, 37.8781]]], [[[-122.48654, 37.88697], [-122.49182, 37.87837], [-122.49434, 37.87888], [-122.49609, 37.88349], [-122.4939, 37.88719], [-122.49252, 37.88934], [-122.48979, 37.89388], [-122.48955, 37.89379], [-122.4886, 37.89402], [-122.48778, 37.89409], [-122.48771, 37.89414], [-122.4843, 37.8909], [-122.48654, 37.88697]]]]} | Restricted Access 2 | 44955 | Richardson Bay Audubon Center & Sanctuary | 24330 | 353 | Marin, County of 1034 | County 3 | County Agency 3 | http://www.marincounty.org/recreation/parks-in-marin | County 3 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Marin 23 | 382.054 | Richardson Bay Audubon Ctr. & Sanctuary | 0 | None 1253 | ||
12493 | 12493 | 12492 | {"type": "Polygon", "coordinates": [[[-121.77745, 36.91053], [-121.77722, 36.91156], [-121.77673, 36.91208], [-121.77635, 36.91196], [-121.77603, 36.91181], [-121.77584, 36.91168], [-121.7757, 36.91157], [-121.77547, 36.91132], [-121.77591, 36.91037], [-121.77745, 36.91053]]]} | Open Access 1 | 28302 | Tarplant Hill | 26191 | 3118 | Watsonville Wetlands Watch 1028 | Non Profit 6 | Non Profit - Conservation 12 | http://www.watsonvillewetlandswatch.org/ | Non Governmental Organization 10 | 3118 | Watsonville Wetlands Watch 989 | Non Profit 6 | Non Profit - Conservation 12 | Santa Cruz 5 | 5.694 | Tarplant Hill | 0 | Private Conservation 16 | 2 | |
12370 | 12370 | 12369 | {"type": "MultiPolygon", "coordinates": [[[[-122.99606, 38.50153], [-122.99573, 38.50173], [-122.99551, 38.50189], [-122.99444, 38.50252], [-122.99426, 38.50269], [-122.99358, 38.50215], [-122.99512, 38.50083], [-122.99561, 38.50114], [-122.99561, 38.50132], [-122.99606, 38.50153]]], [[[-122.99562, 38.5004], [-122.99561, 38.50099], [-122.99561, 38.50099], [-122.99523, 38.50073], [-122.99562, 38.5004]]]]} | No Public Access 3 | 26073 | Riverkeeper Park | 24442 | 3132 | Russian Riverkeeper 1021 | Non Profit 6 | Non Profit - Conservation 12 | http://www.russianriverkeeper.org/ | Non Governmental Organization 10 | 3132 | Russian Riverkeeper 983 | Non Profit 6 | Non Profit - Conservation 12 | Sonoma 16 | 5.046 | Riverkeeper Park | 0 | Private Recreation or Education 65 | 4 | |
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 | |
10363 | 10363 | 10362 | {"type": "Polygon", "coordinates": [[[-122.23717, 40.56026], [-122.2369, 40.56056], [-122.23549, 40.56201], [-122.23102, 40.56204], [-122.2313, 40.56082], [-122.23339, 40.56082], [-122.23339, 40.56028], [-122.23717, 40.56026]]]} | Open Access 1 | 48567 | Palo Cedro Community Park | 33316 | 3394 | Palo Cerdo Community Park Association 950 | Non Profit 6 | Non Profit - Conservation 12 | https://pcpark.org/ | Non Governmental Organization 10 | 3394 | Palo Cerdo Community Park Association 922 | Non Profit 6 | Non Profit - Conservation 12 | Shasta 27 | 18.256 | Palo Cedro Community Park | 2006 | Private Recreation or Education 65 | 4 | |
10342 | 10342 | 10341 | {"type": "Polygon", "coordinates": [[[-120.57202, 37.62727], [-120.57198, 37.62916], [-120.56928, 37.6295], [-120.56863, 37.63018], [-120.56928, 37.63226], [-120.56871, 37.633], [-120.56806, 37.63368], [-120.56624, 37.63436], [-120.56413, 37.63468], [-120.56335, 37.63476], [-120.56189, 37.63452], [-120.56149, 37.63442], [-120.56023, 37.63381], [-120.55943, 37.63315], [-120.5586, 37.63254], [-120.55856, 37.63213], [-120.55757, 37.6314], [-120.55568, 37.63142], [-120.55362, 37.63294], [-120.54986, 37.63346], [-120.5458, 37.6323], [-120.54181, 37.632], [-120.5384, 37.63133], [-120.53578, 37.6313], [-120.53577, 37.62815], [-120.53664, 37.62825], [-120.53986, 37.62737], [-120.54071, 37.62764], [-120.54226, 37.62771], [-120.54354, 37.62769], [-120.54359, 37.62723], [-120.54357, 37.62637], [-120.54507, 37.62495], [-120.54887, 37.62484], [-120.54891, 37.62363], [-120.56284, 37.62365], [-120.56284, 37.62717], [-120.57202, 37.62727]]]} | Restricted Access 2 | 18243 | Bobcat Flat | 16214 | 3026 | Friends of the Tuolumne 948 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofthetuolumne.org | Non Governmental Organization 10 | 3026 | Friends of the Tuolumne 920 | Non Profit 6 | Non Profit - Conservation 12 | Stanislaus 2 | 601.538 | Bobcat Flat | 0 | Private Conservation 16 | 2 | |
9876 | 9876 | 9875 | {"type": "Polygon", "coordinates": [[[-122.17241, 37.33079], [-122.17235, 37.3308], [-122.17235, 37.33446], [-122.16832, 37.33421], [-122.1683, 37.33438], [-122.16716, 37.33439], [-122.16717, 37.33822], [-122.17235, 37.33809], [-122.17206, 37.34613], [-122.17225, 37.35279], [-122.15952, 37.35407], [-122.15898, 37.35422], [-122.15771, 37.35417], [-122.15738, 37.3542], [-122.15695, 37.3543], [-122.1568, 37.3543], [-122.15627, 37.35425], [-122.15542, 37.35424], [-122.15514, 37.35426], [-122.15427, 37.35437], [-122.15415, 37.35434], [-122.15405, 37.3543], [-122.15304, 37.35373], [-122.15243, 37.35333], [-122.15194, 37.35306], [-122.15151, 37.35274], [-122.15122, 37.35254], [-122.15102, 37.35243], [-122.15081, 37.35234], [-122.1508, 37.35037], [-122.15078, 37.34885], [-122.1507, 37.34594], [-122.14674, 37.34599], [-122.14609, 37.33104], [-122.14611, 37.33103], [-122.14611, 37.32785], [-122.15014, 37.3278], [-122.15021, 37.32355], [-122.16012, 37.32344], [-122.16008, 37.33088], [-122.16714, 37.33079], [-122.16707, 37.32727], [-122.17228, 37.32714], [-122.1723, 37.32766], [-122.17164, 37.32804], [-122.17165, 37.32841], [-122.17233, 37.32841], [-122.17241, 37.33079]]]} | Restricted Access 2 | 16945 | Hidden Villa (Duveneck Ranch) | 19921 | 3093 | Trust for Hidden Villa 936 | Non Profit 6 | Non Profit - Conservation 12 | http://www.hiddenvilla.org | Non Governmental Organization 10 | 3093 | Trust for Hidden Villa 909 | Non Profit 6 | Non Profit - Conservation 12 | Santa Clara 19 | 1553.247 | Hidden Villa (Duveneck Ranch) | 1982 | 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 |
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 |
8446 | 8446 | 8445 | {"type": "Polygon", "coordinates": [[[-120.40934, 39.2476], [-120.40929, 39.25121], [-120.40457, 39.25119], [-120.39984, 39.25119], [-120.39973, 39.25845], [-120.39016, 39.25874], [-120.38539, 39.25886], [-120.38067, 39.25907], [-120.38068, 39.26615], [-120.37146, 39.26632], [-120.37179, 39.27379], [-120.3624, 39.27407], [-120.3577, 39.27389], [-120.35727, 39.26279], [-120.35269, 39.26267], [-120.35259, 39.25909], [-120.34416, 39.25882], [-120.3441, 39.26084], [-120.34209, 39.26083], [-120.34205, 39.26443], [-120.33749, 39.26436], [-120.33748, 39.26615], [-120.3352, 39.26611], [-120.33519, 39.2697], [-120.33292, 39.26965], [-120.33292, 39.27144], [-120.32839, 39.27133], [-120.32816, 39.28612], [-120.31906, 39.28596], [-120.31909, 39.28409], [-120.31569, 39.28402], [-120.31573, 39.28215], [-120.31233, 39.28207], [-120.31241, 39.27834], [-120.31015, 39.27828], [-120.31031, 39.27083], [-120.31708, 39.27102], [-120.31706, 39.26924], [-120.32157, 39.26936], [-120.32156, 39.26758], [-120.32382, 39.26763], [-120.32381, 39.26587], [-120.32608, 39.26592], [-120.32607, 39.26415], [-120.32835, 39.2642], [-120.32796, 39.25719], [-120.31893, 39.25721], [-120.3188, 39.24999], [-120.32391, 39.25004], [-120.32851, 39.25012], [-120.32812, 39.24272], [-120.32858, 39.22862], [-120.31001, 39.22797], [-120.30937, 39.21405], [-120.32839, 39.21429], [-120.32858, 39.22861], [-120.34426, 39.22825], [-120.34426, 39.22975], [-120.34431, 39.23197], [-120.34419, 39.24435], [-120.36133, 39.2447], [-120.36157, 39.25303], [-120.38077, 39.25265], [-120.38079, 39.25174], [-120.38064, 39.2443], [-120.39759, 39.244], [-120.39998, 39.24394], [-120.39991, 39.24757], [-120.40934, 39.2476]]]} | Restricted Access 2 | 48490 | Chickering American River Reserve | 33201 | 3388 | North Fork Association 894 | Non Profit 6 | Non Profit - Conservation 12 | Non Governmental Organization 10 | 3388 | North Fork Association 868 | Non Profit 6 | Non Profit - Conservation 12 | https://ucnrs.org/reserves/chickering-american-river-reserve/ | Placer 35 | 5210.359 | Chickering American River Reserve | 0 | Private Conservation 16 | 2 | |
6912 | 6912 | 6911 | {"type": "Polygon", "coordinates": [[[-116.46015, 33.62703], [-116.46015, 33.6416], [-116.44281, 33.6416], [-116.4428, 33.62706], [-116.46015, 33.62703]]]} | Open Access 1 | 5786 | Santa Rosa and San Jacinto Mountains National Monument | 13072 | 3090 | The Living Desert 845 | Non Profit 6 | Non Profit - Conservation 12 | http://www.livingdesert.org/ | Non Governmental Organization 10 | 3090 | The Living Desert 823 | Non Profit 6 | Non Profit - Conservation 12 | Riverside 10 | 641.789 | Santa Rosa and San Jacinto Mtns. NM | 2000 | National Monument or Landmark 80 | 3 | |
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 | |
6535 | 6535 | 6534 | {"type": "Polygon", "coordinates": [[[-122.51383, 38.36841], [-122.50814, 38.36943], [-122.50109, 38.36935], [-122.50067, 38.3693], [-122.50062, 38.37298], [-122.49612, 38.37301], [-122.49619, 38.38388], [-122.49155, 38.38386], [-122.49153, 38.38309], [-122.49061, 38.38253], [-122.48896, 38.38256], [-122.48894, 38.38236], [-122.48691, 38.3824], [-122.48686, 38.38021], [-122.4822, 38.38028], [-122.48217, 38.37661], [-122.48672, 38.37655], [-122.48672, 38.37492], [-122.48674, 38.37294], [-122.49158, 38.37294], [-122.49147, 38.36576], [-122.50061, 38.36569], [-122.50092, 38.36636], [-122.50569, 38.36502], [-122.50569, 38.36589], [-122.50542, 38.36613], [-122.50591, 38.36725], [-122.51009, 38.36459], [-122.51073, 38.36522], [-122.5103, 38.36548], [-122.51046, 38.36566], [-122.51001, 38.36593], [-122.51001, 38.36594], [-122.51145, 38.36594], [-122.51318, 38.36769], [-122.51383, 38.36841]]]} | Restricted Access 2 | 3227 | Bouverie Wildflower Preserve | 16305 | 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 | Sonoma 16 | 527.836 | Bouverie Wildflower Preserve | 1979 | 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]);