units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
90 rows where ACCESS_TYP = 2 and AGNCY_TYP = 1 sorted by DES_TP
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_WEB, LAYER, MNG_AG_ID, PARK_URL, COUNTY, YR_EST, GAP_STS
DES_TP 22
- National Wildlife Refuge 34
- National Public Lands 9
- Recreation Management Area 9
- State Conservation Area 6
- Federal Other or Unknown 6
- Conservation Area 5
- National Park 4
- National Recreation Area 2
- Resource Management Area 2
- Local Recreation Area 1
- None 1
- Wilderness Area 1
- National Monument or Landmark 1
- Research or Educational Area 1
- None 1
- None 1
- None 1
- Area of Critical Environmental Concern 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 15
- United States Fish and Wildlife Service 39
- United States Bureau of Land Management 12
- United States National Park Service 8
- United States Army Corps of Engineers 6
- United States Bureau of Reclamation 6
- California Department of Fish and Wildlife 3
- University of California 3
- United States Coast Guard 3
- Other Federal 2
- San Diego State University 2
- United States Department of Defense 2
- Los Angeles, County of 1
- United States Forest Service 1
- Needles, City of 1
- Palos Verdes Peninsula Land Conservancy 1
MNG_AG_TYP 5
ACCESS_TYP 1
- Restricted Access · 90 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3760 | 3760 | 3759 | {"type": "Polygon", "coordinates": [[[-122.95962, 40.7165], [-122.95894, 40.72369], [-122.9584, 40.7272], [-122.95072, 40.72738], [-122.95056, 40.72704], [-122.94975, 40.72649], [-122.94961, 40.72632], [-122.94959, 40.72551], [-122.94491, 40.7255], [-122.94491, 40.72367], [-122.94258, 40.72366], [-122.94259, 40.72273], [-122.94025, 40.72272], [-122.94025, 40.72217], [-122.93902, 40.7227], [-122.939, 40.72267], [-122.93668, 40.72369], [-122.93688, 40.71878], [-122.93878, 40.71586], [-122.93907, 40.71613], [-122.94039, 40.71613], [-122.94432, 40.7162], [-122.95236, 40.71632], [-122.95962, 40.7165]]]} | Restricted Access 2 | 34904 | BLM | 16163 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Trinity 46 | 463.82 | BLM | 1963 | National Public Lands 1 | 3 | |
3763 | 3763 | 3762 | {"type": "Polygon", "coordinates": [[[-117.39664, 35.73738], [-117.39548, 35.74101], [-117.39454, 35.74102], [-117.39455, 35.74394], [-117.39429, 35.74463], [-117.39234, 35.74464], [-117.39228, 35.74751], [-117.39124, 35.74826], [-117.39002, 35.74841], [-117.38789, 35.74939], [-117.38787, 35.74825], [-117.38344, 35.74826], [-117.38344, 35.75187], [-117.37899, 35.75187], [-117.37899, 35.74464], [-117.38353, 35.74464], [-117.38353, 35.74102], [-117.38788, 35.74101], [-117.38788, 35.73739], [-117.39664, 35.73738]]]} | Restricted Access 2 | 34925 | BLM | 16163 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | San Bernardino 22 | 334.438 | BLM | 1963 | National Public Lands 1 | 3 | |
4144 | 4144 | 4143 | {"type": "Polygon", "coordinates": [[[-122.46384, 39.38383], [-122.45881, 39.38384], [-122.4585, 39.38043], [-122.46379, 39.38038], [-122.46384, 39.38383]]]} | Restricted Access 2 | 47499 | BLM | 16163 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Colusa 49 | 41.777 | BLM | 1963 | National Public Lands 1 | 3 | |
5580 | 5580 | 5579 | {"type": "Polygon", "coordinates": [[[-121.95567, 37.92322], [-121.95099, 37.92324], [-121.9509, 37.91961], [-121.95562, 37.91959], [-121.95567, 37.92322]]]} | Restricted Access 2 | 29557 | BLM | 16163 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Contra Costa 12 | 41.201 | BLM | 1963 | National Public Lands 1 | 3 | |
11182 | 11182 | 11181 | {"type": "MultiPolygon", "coordinates": [[[[-122.1646, 39.75799], [-122.16445, 39.7616], [-122.16182, 39.76157], [-122.15957, 39.76157], [-122.15966, 39.75983], [-122.15944, 39.75788], [-122.16324, 39.75792], [-122.1646, 39.75799]]], [[[-122.22022, 39.77673], [-122.22017, 39.78034], [-122.21557, 39.78029], [-122.21553, 39.77668], [-122.22022, 39.77673]]], [[[-122.32796, 39.39913], [-122.3233, 39.39915], [-122.32318, 39.39219], [-122.32786, 39.39215], [-122.32796, 39.39913]]], [[[-122.44682, 39.49066], [-122.44201, 39.49066], [-122.44196, 39.48701], [-122.44676, 39.48701], [-122.44682, 39.49066]]], [[[-122.47449, 39.41647], [-122.47428, 39.42005], [-122.47423, 39.43573], [-122.47424, 39.44169], [-122.46972, 39.44165], [-122.46954, 39.44148], [-122.4696, 39.43437], [-122.46016, 39.43508], [-122.45966, 39.42802], [-122.45902, 39.42438], [-122.45382, 39.42443], [-122.45339, 39.42079], [-122.4591, 39.42054], [-122.45911, 39.41686], [-122.4591, 39.41685], [-122.45347, 39.41699], [-122.45338, 39.40587], [-122.45331, 39.40583], [-122.45328, 39.4024], [-122.45183, 39.4023], [-122.45182, 39.40231], [-122.44821, 39.40234], [-122.44808, 39.39874], [-122.44355, 39.39869], [-122.44372, 39.39139], [-122.44692, 39.39142], [-122.44725, 39.38407], [-122.4473, 39.38406], [-122.4472, 39.38393], [-122.45099, 39.38399], [-122.45882, 39.38397], [-122.45881, 39.38384], [-122.46383, 39.38383], [-122.46406, 39.40553], [-122.46415, 39.40913], [-122.46969, 39.40894], [-122.46969, 39.40931], [-122.4697, 39.40944], [-122.4697, 39.41637], [-122.47423, 39.41644], [-122.47424, 39.41646], [-122.47449, 39.41647]]], [[[-122.47411, 39.44842], [-122.47408, 39.44843], [-122.47409, 39.44854], [-122.47395, 39.44888], [-122.4739, 39.45054], [-122.4696, 39.45055], [-122.46956, 39.44879], [-122.46954, 39.44511], [-122.47411, 39.44517], [-122.47411, 39.44842]]], [[[-122.47452, 39.39851], [-122.47451, 39.40208], [-122.4701, 39.40204], [-122.46977, 39.40208], [-122.46984, 39.39842], [-122.47014, 39.39845], [-122.47452, 39.39851]]], [[[-122.49255, 39.43829], [-122.49251, 39.44913], [-122.48796, 39.44909], [-122.48801, 39.4461], [-122.48818, 39.4461], [-122.48821, 39.43911], [-122.48969, 39.4385], [-122.49057, 39.43796], [-122.49208, 39.43782], [-122.49248, 39.43757], [-122.49248, 39.43828], [-122.49255, 39.43829]]], [[[-122.49248, 39.43738], [-122.49205, 39.43768], [-122.49185, 39.43768], [-122.49049, 39.4378], [-122.48954, 39.43838], [-122.48895, 39.43868], [-122.48827, 39.43892], [-122.4884, 39.43469], [-122.49247, 39.43476], [-122.49248, 39.43738]]], [[[-122.49535, 39.52955], [-122.49043, 39.52997], [-122.48854, 39.5234], [-122.49324, 39.5231], [-122.49535, 39.52955]]], [[[-122.50277, 39.57036], [-122.50165, 39.5704], [-122.50164, 39.57042], [-122.49808, 39.57047], [-122.49799, 39.56647], [-122.50263, 39.56654], [-122.50277, 39.57036]]], [[[-122.5029, 39.58858], [-122.49833, 39.5886], [-122.4983, 39.58502], [-122.50284, 39.58495], [-122.5029, 39.58858]]], [[[-122.50742, 39.57752], [-122.50741, 39.58113], [-122.50291, 39.58118], [-122.50279, 39.57764], [-122.50742, 39.57752]]], [[[-122.51816, 39.43183], [-122.51808, 39.43541], [-122.51028, 39.43512], [-122.51031, 39.42805], [-122.51419, 39.42803], [-122.51423, 39.43163], [-122.51816, 39.43183]]], [[[-122.51655, 39.60657], [-122.5119, 39.6066], [-122.51172, 39.60295], [-122.51645, 39.60292], [-122.51655, 39.60657]]], [[[-122.51977, 39.41379], [-122.51972, 39.421], [-122.51571, 39.42085], [-122.51572, 39.41366], [-122.51977, 39.41379]]], [[[-122.51987, 39.39939], [-122.5158, 39.39919], [-122.51584, 39.39176], [-122.51982, 39.39197], [-122.51987, 39.39939]]], [[[-122.5628, 39.51771], [-122.55827, 39.5177], [-122.55822, 39.51056], [-122.56266, 39.51055], [-122.5628, 39.51771]]], [[[-122.56321, 39.55891], [-122.5632, 39.56262], [-122.55855, 39.5626], [-122.55856, 39.55893], [-122.56321, 39.55891]]], [[[-122.56775, 39.55532], [-122.56306, 39.55536], [-122.56303, 39.55173], [-122.56771, 39.55169], [-122.56775, 39.55532]]], [[[-122.58225, 39.53707], [-122.58223, 39.53753], [-122.58221, 39.5407], [-122.57748, 39.54075], [-122.57751, 39.53712], [-122.57266, 39.53719], [-122.57282, 39.53705], [-122.5728, 39.5366], [-122.57274, 39.5364], [-122.57262, 39.53617], [-122.57282, 39.53601], [-122.57294, 39.53585], [-122.57298, 39.53577], [-122.5768, 39.53609], [-122.58162, 39.53613], [-122.58224, 39.53706], [-122.58225, 39.53707]]], [[[-122.57746, 39.54441], [-122.57744, 39.54796], [-122.5727, 39.548], [-122.57273, 39.54439], [-122.57746, 39.54441]]], [[[-122.59174, 39.71995], [-122.58962, 39.71997], [-122.58981, 39.72721], [-122.58736, 39.72723], [-122.58776, 39.74186], [-122.58786, 39.75022], [-122.58801, 39.7561], [-122.57835, 39.75612], [-122.5779, 39.74174], [-122.5735, 39.74169], [-122.57363, 39.73446], [-122.57837, 39.73452], [-122.57833, 39.73094], [-122.57369, 39.73089], [-122.57369, 39.72982], [-122.57362, 39.72364], [-122.5783, 39.72366], [-122.57828, 39.71992], [-122.58276, 39.71993], [-122.58281, 39.71263], [-122.58324, 39.71262], [-122.58347, 39.70429], [-122.58806, 39.70369], [-122.58849, 39.68822], [-122.5901, 39.68813], [-122.59012, 39.69564], [-122.58999, 39.70345], [-122.58989, 39.7126], [-122.5899, 39.71261], [-122.59154, 39.71261], [-122.59174, 39.71995]]], [[[-122.5874, 39.59871], [-122.58738, 39.60237], [-122.58257, 39.60241], [-122.5825, 39.59877], [-122.5874, 39.59871]]], [[[-122.58919, 39.62838], [-122.58286, 39.62841], [-122.58281, 39.62486], [-122.5879, 39.62486], [-122.58915, 39.62483], [-122.58919, 39.62838]]], [[[-122.5901, 39.66765], [-122.58977, 39.66765], [-122.58976, 39.66766], [-122.58984, 39.67119], [-122.58988, 39.6712], [-122.58986, 39.67448], [-122.5899, 39.67454], [-122.58993, 39.67481], [-122.59002, 39.67481], [-122.58996, 39.67484], [-122.58999, 39.67829], [-122.58996, 39.6783], [-122.59006, 39.68178], [-122.59008, 39.68513], [-122.58855, 39.6854], [-122.58835, 39.66767], [-122.58999, 39.66759], [-122.5901, 39.66765]]], [[[-122.61522, 39.53729], [-122.6152, 39.54066], [-122.61027, 39.54064], [-122.61038, 39.53729], [-122.61522, 39.53729]]]]} | Restricted Access 2 | 21454 | BLM | 16163 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Glenn 55 | 4738.203 | BLM | 1963 | National Public Lands 1 | 3 | |
13036 | 13036 | 13035 | {"type": "MultiPolygon", "coordinates": [[[[-120.89266, 38.89126], [-120.89257, 38.89479], [-120.89056, 38.89479], [-120.89053, 38.89645], [-120.89055, 38.8965], [-120.89052, 38.89651], [-120.89051, 38.89665], [-120.89026, 38.89606], [-120.88994, 38.89557], [-120.8897, 38.89539], [-120.8902, 38.89507], [-120.8902, 38.89505], [-120.88701, 38.89192], [-120.8863, 38.89232], [-120.88538, 38.89288], [-120.88669, 38.89416], [-120.88634, 38.89408], [-120.88574, 38.89398], [-120.88504, 38.89384], [-120.88368, 38.89339], [-120.88316, 38.89325], [-120.88272, 38.89324], [-120.88239, 38.89325], [-120.88173, 38.89342], [-120.88175, 38.89109], [-120.88161, 38.88749], [-120.88598, 38.88758], [-120.88601, 38.88811], [-120.88448, 38.8884], [-120.88543, 38.89022], [-120.88525, 38.89116], [-120.88723, 38.89118], [-120.8875, 38.89026], [-120.89055, 38.89032], [-120.89056, 38.89124], [-120.89266, 38.89126]]], [[[-120.89052, 38.89708], [-120.8905, 38.89832], [-120.88629, 38.89826], [-120.88628, 38.8948], [-120.88172, 38.89471], [-120.88173, 38.89359], [-120.88261, 38.89353], [-120.88289, 38.89353], [-120.88321, 38.89357], [-120.88468, 38.89404], [-120.88557, 38.89425], [-120.88708, 38.89452], [-120.88862, 38.89603], [-120.88939, 38.89557], [-120.88966, 38.89576], [-120.89001, 38.89629], [-120.89025, 38.8967], [-120.89052, 38.89708]]], [[[-120.90802, 38.89769], [-120.90801, 38.8995], [-120.90421, 38.90102], [-120.90182, 38.89809], [-120.89949, 38.89818], [-120.89948, 38.89819], [-120.90211, 38.9014], [-120.90057, 38.90137], [-120.89993, 38.90132], [-120.89957, 38.90128], [-120.8991, 38.90119], [-120.89758, 38.90074], [-120.89596, 38.90018], [-120.89767, 38.90006], [-120.89943, 38.89996], [-120.89948, 38.89911], [-120.89947, 38.89808], [-120.90172, 38.89795], [-120.90373, 38.89788], [-120.90802, 38.89769]]], [[[-120.908, 38.89979], [-120.90797, 38.90135], [-120.90794, 38.90478], [-120.90656, 38.90475], [-120.90316, 38.90188], [-120.90172, 38.90292], [-120.90342, 38.90439], [-120.90344, 38.90474], [-120.90345, 38.90756], [-120.90024, 38.90617], [-120.89942, 38.90698], [-120.89945, 38.90553], [-120.89607, 38.90576], [-120.89515, 38.90581], [-120.89522, 38.90208], [-120.89524, 38.90015], [-120.89592, 38.90046], [-120.89747, 38.90106], [-120.89842, 38.90136], [-120.89937, 38.90157], [-120.90043, 38.90171], [-120.90143, 38.90177], [-120.90226, 38.90178], [-120.90291, 38.90174], [-120.90321, 38.90174], [-120.90373, 38.90161], [-120.90439, 38.90138], [-120.90532, 38.90099], [-120.90561, 38.90082], [-120.908, 38.89979]]]]} | Restricted Access 2 | 34872 | BLM | 16163 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | El Dorado 34 | 313.299 | BLM | 1963 | National Public Lands 1 | 3 | |
13037 | 13037 | 13036 | {"type": "MultiPolygon", "coordinates": [[[[-120.91216, 38.91541], [-120.91209, 38.91725], [-120.90299, 38.9179], [-120.90314, 38.91614], [-120.91216, 38.91541]]], [[[-120.91554, 38.91278], [-120.91489, 38.9134], [-120.91489, 38.91518], [-120.91293, 38.91536], [-120.9126, 38.91537], [-120.91264, 38.91385], [-120.91256, 38.91389], [-120.90898, 38.91085], [-120.908, 38.91025], [-120.90805, 38.90805], [-120.91228, 38.90808], [-120.9148, 38.90807], [-120.91488, 38.91165], [-120.91488, 38.91253], [-120.9149, 38.91254], [-120.91511, 38.91239], [-120.91554, 38.91278]]]]} | Restricted Access 2 | 34873 | BLM | 16163 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | El Dorado 34 | 121.211 | BLM | 1963 | National Public Lands 1 | 3 | |
13054 | 13054 | 13053 | {"type": "Polygon", "coordinates": [[[-122.17843, 39.75789], [-122.17369, 39.75785], [-122.17368, 39.75452], [-122.17834, 39.75457], [-122.17843, 39.75789]]]} | Restricted Access 2 | 34910 | BLM | 16163 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Glenn 55 | 36.703 | BLM | 1963 | National Public Lands 1 | 3 | |
13056 | 13056 | 13055 | {"type": "Polygon", "coordinates": [[[-116.45767, 33.96133], [-116.44054, 33.96104], [-116.44043, 33.94685], [-116.44884, 33.94684], [-116.44926, 33.95001], [-116.45349, 33.95007], [-116.45355, 33.94677], [-116.45738, 33.94676], [-116.45767, 33.96133]]]} | Restricted Access 2 | 34913 | BLM | 16163 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Riverside 10 | 583.754 | BLM | 1963 | National Public Lands 1 | 3 | |
10390 | 10390 | 10389 | {"type": "MultiPolygon", "coordinates": [[[[-114.59933, 34.8403], [-114.59817, 34.8403], [-114.59816, 34.8402], [-114.5974, 34.8402], [-114.59631, 34.83958], [-114.5963, 34.83674], [-114.59756, 34.83674], [-114.59859, 34.8376], [-114.59933, 34.83869], [-114.59933, 34.8403]]], [[[-114.60795, 34.84404], [-114.60512, 34.84402], [-114.60511, 34.84467], [-114.60415, 34.8444], [-114.60324, 34.84401], [-114.60287, 34.84401], [-114.60287, 34.84392], [-114.6039, 34.84392], [-114.6039, 34.84287], [-114.60365, 34.84287], [-114.60365, 34.84339], [-114.60348, 34.84339], [-114.60348, 34.84286], [-114.6026, 34.84286], [-114.6026, 34.84339], [-114.60251, 34.84339], [-114.60251, 34.84286], [-114.60171, 34.84285], [-114.60171, 34.8423], [-114.60114, 34.84229], [-114.60113, 34.84294], [-114.60104, 34.84294], [-114.60104, 34.84285], [-114.60095, 34.84285], [-114.60095, 34.84276], [-114.60071, 34.84255], [-114.60071, 34.84219], [-114.6002, 34.84219], [-114.6002, 34.84197], [-114.60003, 34.84197], [-114.60003, 34.84164], [-114.59969, 34.84163], [-114.59969, 34.84108], [-114.59892, 34.84108], [-114.59891, 34.841], [-114.59885, 34.841], [-114.59885, 34.84052], [-114.59986, 34.84052], [-114.59987, 34.84029], [-114.60042, 34.84029], [-114.60048, 34.84038], [-114.60071, 34.84038], [-114.60071, 34.84051], [-114.6002, 34.84053], [-114.6002, 34.84107], [-114.60054, 34.84107], [-114.60055, 34.8417], [-114.60312, 34.84171], [-114.60701, 34.84358], [-114.60702, 34.84394], [-114.60717, 34.84394], [-114.60718, 34.84366], [-114.60795, 34.84404]], [[-114.60449, 34.84342], [-114.60448, 34.84392], [-114.60464, 34.84393], [-114.60465, 34.84343], [-114.60449, 34.84342]]], [[[-114.60513, 34.84766], [-114.60318, 34.84764], [-114.60299, 34.84743], [-114.60187, 34.84686], [-114.60072, 34.84634], [-114.60071, 34.844], [-114.60242, 34.84401], [-114.60412, 34.84467], [-114.60511, 34.84523], [-114.60513, 34.84766]]]]} | Restricted Access 2 | 49071 | River's Edge Golf Course | 33774 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 1220 | Needles, City of 276 | City 2 | City Agency 2 | http://cityofneedles.com/services/rivers-edge-golf-course/ | San Bernardino 22 | 77.93 | River's Edge GC | 0 | Local Recreation Area 3 | 4 |
3589 | 3589 | 3588 | {"type": "Polygon", "coordinates": [[[-121.4409, 38.26568], [-121.4405, 38.26654], [-121.43893, 38.26623], [-121.43872, 38.26566], [-121.43905, 38.26515], [-121.43899, 38.26457], [-121.44061, 38.26555], [-121.4409, 38.26568]]]} | Restricted Access 2 | 29176 | Cosumnes River Ecological Reserve | 17675 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Cosumnes-River-ER | Sacramento 41 | 5.742 | Cosumnes River ER | 2003 | State Conservation Area 8 | 2 |
3591 | 3591 | 3590 | {"type": "Polygon", "coordinates": [[[-124.14742, 40.69347], [-124.14559, 40.69346], [-124.14538, 40.69323], [-124.14529, 40.69315], [-124.1453, 40.6929], [-124.14528, 40.69266], [-124.14516, 40.69246], [-124.14439, 40.69244], [-124.14425, 40.69237], [-124.14377, 40.69258], [-124.14337, 40.6929], [-124.14227, 40.69323], [-124.14201, 40.69328], [-124.14184, 40.69325], [-124.14175, 40.69317], [-124.14175, 40.69315], [-124.1408, 40.6924], [-124.14079, 40.6925], [-124.14074, 40.69274], [-124.14083, 40.69303], [-124.14104, 40.69323], [-124.14057, 40.69342], [-124.14053, 40.69198], [-124.13941, 40.69246], [-124.1312, 40.69009], [-124.13037, 40.68982], [-124.1215, 40.68448], [-124.12146, 40.68269], [-124.11355, 40.68077], [-124.10809, 40.6787], [-124.10786, 40.6787], [-124.10721, 40.67735], [-124.0988, 40.67462], [-124.09604, 40.67387], [-124.09406, 40.67463], [-124.09347, 40.67584], [-124.08834, 40.67698], [-124.08359, 40.67528], [-124.08359, 40.67524], [-124.07786, 40.67485], [-124.07651, 40.67401], [-124.07441, 40.67364], [-124.07124, 40.6721], [-124.06831, 40.6679], [-124.06471, 40.66617], [-124.0647, 40.66617], [-124.0647, 40.6662], [-124.06468, 40.66621], [-124.06319, 40.6653], [-124.05956, 40.66442], [-124.05778, 40.66229], [-124.05384, 40.65824], [-124.05365, 40.65509], [-124.05002, 40.6541], [-124.04946, 40.65278], [-124.04812, 40.65258], [-124.0477, 40.65187], [-124.04497, 40.65101], [-124.04491, 40.6495], [-124.04189, 40.64952], [-124.04106, 40.64851], [-124.04073, 40.64823], [-124.03978, 40.648], [-124.03632, 40.64835], [-124.02927, 40.64745], [-124.03058, 40.63728], [-124.02908, 40.63553], [-124.02749, 40.63464], [-124.02498, 40.63367], [-124.02012, 40.63067], [-124.02289, 40.62734], [-124.02636, 40.62391], [-124.02952, 40.6237], [-124.03035, 40.62414], [-124.0314, 40.62386], [-124.03149, 40.62163], [-124.03431, 40.62178], [-124.0349, 40.62231], [-124.03653, 40.62122], [-124.03747, 40.6213], [-124.03813, 40.6188], [-124.04011, 40.61761], [-124.04263, 40.61339], [-124.04458, 40.61226], [-124.04459, 40.6127], [-124.0446, 40.61271], [-124.05363, 40.61225], [-124.05809, 40.6085], [-124.05947, 40.60912], [-124.06172, 40.60889], [-124.06364, 40.60903], [-124.06361, 40.60599], [-124.06804, 40.60592], [-124.06818, 40.60858], [-124.06892, 40.60908], [-124.06935, 40.61206], [-124.07123, 40.61266], [-124.07203, 40.6147], [-124.07427, 40.6156], [-124.07464, 40.61645], [-124.07765, 40.61879], [-124.08288, 40.61806], [-124.08893, 40.61992], [-124.09223, 40.62186], [-124.09333, 40.62235], [-124.09552, 40.62446], [-124.09889, 40.62474], [-124.10109, 40.62456], [-124.10608, 40.62589], [-124.11182, 40.62545], [-124.11188, 40.6276], [-124.11191, 40.62761], [-124.11131, 40.64262], [-124.10174, 40.64225], [-124.10166, 40.64898], [-124.10191, 40.65658], [-124.10231, 40.66392], [-124.10343, 40.67117], [-124.10615, 40.6712], [-124.10602, 40.67272], [-124.1088, 40.67387], [-124.11149, 40.67583], [-124.11218, 40.67742], [-124.11561, 40.67875], [-124.11596, 40.67875], [-124.11815, 40.67964], [-124.1214, 40.68025], [-124.12141, 40.68024], [-124.12138, 40.67879], [-124.13117, 40.68583], [-124.13949, 40.68965], [-124.14155, 40.68971], [-124.14739, 40.69182], [-124.14742, 40.69347]], [[-124.09275, 40.67312], [-124.09494, 40.67244], [-124.09639, 40.67249], [-124.0964, 40.67248], [-124.08994, 40.66756], [-124.08528, 40.66692], [-124.08296, 40.66327], [-124.08295, 40.66294], [-124.08063, 40.65854], [-124.07603, 40.65701], [-124.06997, 40.65189], [-124.06773, 40.64819], [-124.06452, 40.64798], [-124.06454, 40.64939], [-124.064, 40.64939], [-124.05629, 40.64394], [-124.04659, 40.64056], [-124.04485, 40.63975], [-124.04491, 40.64863], [-124.05539, 40.65476], [-124.05584, 40.65772], [-124.06019, 40.66206], [-124.06478, 40.66376], [-124.06478, 40.66394], [-124.06676, 40.66461], [-124.07068, 40.66745], [-124.07235, 40.67098], [-124.07617, 40.67265], [-124.07829, 40.67329], [-124.0835, 40.67367], [-124.08351, 40.67365], [-124.08626, 40.67453], [-124.08786, 40.67522], [-124.09141, 40.67419], [-124.09275, 40.67312]]]} | Restricted Access 2 | 29210 | Headwaters Forest Reserve | 29960 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | http://www.blm.gov/ca/st/en/prog/nlcs/Headwaters_ForestReserve.html | Humboldt 45 | 7609.194 | Headwaters Forest Reserve | 0 | State Conservation Area 8 | 2 |
6676 | 6676 | 6675 | {"type": "Polygon", "coordinates": [[[-117.1779, 33.42839], [-117.1779, 33.43232], [-117.17339, 33.43239], [-117.17327, 33.42847], [-117.1779, 33.42839]]]} | Restricted Access 2 | 5517 | Santa Margarita Ecological Reserve | 33342 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | San Diego 4 | 45.762 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
8388 | 8388 | 8387 | {"type": "MultiPolygon", "coordinates": [[[[-122.15612, 38.5114], [-122.15602, 38.51461], [-122.13849, 38.5146], [-122.13848, 38.51219], [-122.13854, 38.50977], [-122.13865, 38.50359], [-122.15197, 38.50368], [-122.15222, 38.50001], [-122.15555, 38.49999], [-122.1556, 38.50362], [-122.15219, 38.50368], [-122.15195, 38.5111], [-122.15604, 38.51137], [-122.15612, 38.5114]]], [[[-122.14395, 38.48911], [-122.13942, 38.48915], [-122.13932, 38.48613], [-122.13918, 38.48221], [-122.14358, 38.48228], [-122.14395, 38.48911]]], [[[-122.15728, 38.48585], [-122.15276, 38.48591], [-122.15247, 38.48241], [-122.15699, 38.48233], [-122.15728, 38.48585]]]]} | Restricted Access 2 | 48483 | Quail Ridge Reserve | 33192 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 217 | University of California 51 | State 5 | State Agency 5 | https://ucnrs.org/reserves/quail-ridge-reserve/ | Napa 11 | 529.199 | Quail Ridge Reserve | 0 | State Conservation Area 8 | 2 |
15052 | 15052 | 15051 | {"type": "MultiPolygon", "coordinates": [[[[-117.25255, 33.80464], [-117.24993, 33.80461], [-117.24825, 33.80463], [-117.24827, 33.80108], [-117.25252, 33.80114], [-117.25255, 33.80464]]], [[[-117.26585, 33.81556], [-117.26585, 33.81919], [-117.26149, 33.81923], [-117.26146, 33.81559], [-117.26585, 33.81556]]]]} | Restricted Access 2 | 48493 | Motte Rimrock Reserve | 22519 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 217 | University of California 51 | State 5 | State Agency 5 | https://ucnrs.org/reserves/motte-rimrock-reserve/ | Riverside 10 | 78.529 | Motte Rimrock Reserve | 0 | State Conservation Area 8 | 2 |
15568 | 15568 | 15567 | {"type": "MultiPolygon", "coordinates": [[[[-117.15855, 33.46486], [-117.15421, 33.46507], [-117.14524, 33.46588], [-117.14538, 33.46928], [-117.14494, 33.46886], [-117.14213, 33.46585], [-117.13783, 33.46151], [-117.1408, 33.46153], [-117.14069, 33.45434], [-117.13656, 33.45432], [-117.13646, 33.45406], [-117.13637, 33.45348], [-117.1363, 33.45254], [-117.13632, 33.44932], [-117.13637, 33.4487], [-117.13646, 33.448], [-117.13653, 33.44776], [-117.13676, 33.44716], [-117.15344, 33.4472], [-117.15396, 33.4616], [-117.1584, 33.46141], [-117.15855, 33.46486]]], [[[-117.20649, 33.43578], [-117.20644, 33.44303], [-117.19756, 33.44297], [-117.1975, 33.44657], [-117.19305, 33.44653], [-117.19309, 33.44294], [-117.18865, 33.44291], [-117.18876, 33.43575], [-117.19321, 33.43576], [-117.19316, 33.43934], [-117.19759, 33.43937], [-117.19765, 33.43577], [-117.20649, 33.43578]]]]} | Restricted Access 2 | 5509 | Santa Margarita Ecological Reserve | 33342 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | Riverside 10 | 1078.683 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
5067 | 5067 | 5066 | {"type": "MultiPolygon", "coordinates": [[[[-121.92364, 39.61375], [-121.91546, 39.61369], [-121.91009, 39.61404], [-121.90974, 39.58565], [-121.91651, 39.58595], [-121.91905, 39.59054], [-121.92027, 39.59046], [-121.92226, 39.60293], [-121.92315, 39.6032], [-121.92361, 39.6051], [-121.92364, 39.61375]]], [[[-121.95697, 39.57561], [-121.95661, 39.58172], [-121.95673, 39.58306], [-121.95538, 39.58764], [-121.9527, 39.59123], [-121.94897, 39.59451], [-121.94637, 39.59764], [-121.9452, 39.59967], [-121.94368, 39.60103], [-121.93282, 39.60012], [-121.93297, 39.5959], [-121.93329, 39.58805], [-121.93354, 39.58402], [-121.93359, 39.57597], [-121.94034, 39.5756], [-121.94131, 39.57612], [-121.95697, 39.57561]]]]} | Restricted Access 2 | 9050 | North Central Valley Wildlife Management Area | 22810 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Butte 42 | 1915.19 | North Central Valley WMA | 0 | Conservation Area 13 | 2 | |
12172 | 12172 | 12171 | {"type": "MultiPolygon", "coordinates": [[[[-122.0023, 39.55714], [-122.00067, 39.55738], [-122.00004, 39.55733], [-121.99786, 39.55722], [-121.9962, 39.55706], [-121.99474, 39.55668], [-121.99225, 39.55686], [-121.99091, 39.55726], [-121.99068, 39.55729], [-121.99098, 39.55403], [-121.99099, 39.55127], [-121.99048, 39.54485], [-121.98916, 39.54105], [-121.98522, 39.53903], [-121.9855, 39.53688], [-121.9834, 39.53577], [-121.98269, 39.53511], [-121.98042, 39.53448], [-121.9785, 39.53391], [-121.97608, 39.53414], [-121.97452, 39.53396], [-121.9725, 39.53286], [-121.97036, 39.53075], [-121.97013, 39.53024], [-121.97103, 39.53], [-121.97405, 39.52928], [-121.97381, 39.52965], [-121.9734, 39.53036], [-121.97335, 39.53079], [-121.97343, 39.53115], [-121.97367, 39.5314], [-121.9739, 39.53157], [-121.97541, 39.53246], [-121.97657, 39.53298], [-121.97737, 39.53321], [-121.97795, 39.53328], [-121.9787, 39.5333], [-121.97964, 39.53321], [-121.98059, 39.53305], [-121.98156, 39.53294], [-121.98245, 39.53293], [-121.98298, 39.53304], [-121.98325, 39.53318], [-121.9842, 39.5333], [-121.98464, 39.53314], [-121.9849, 39.53293], [-121.98493, 39.53272], [-121.9849, 39.53229], [-121.98511, 39.53188], [-121.98573, 39.53154], [-121.9862, 39.53149], [-121.98676, 39.53169], [-121.98777, 39.53231], [-121.98854, 39.53256], [-121.98931, 39.53279], [-121.99005, 39.53316], [-121.99155, 39.53382], [-121.99238, 39.53423], [-121.99333, 39.53491], [-121.99387, 39.53547], [-121.995, 39.5373], [-121.99688, 39.54166], [-121.99885, 39.54825], [-122.0023, 39.55714]]], [[[-122.00208, 39.55937], [-122.00124, 39.56031], [-121.99906, 39.56057], [-121.99884, 39.5608], [-121.99772, 39.56184], [-121.99751, 39.56216], [-121.99678, 39.56214], [-121.99612, 39.56208], [-121.99553, 39.56205], [-121.99479, 39.56198], [-121.99405, 39.56205], [-121.99334, 39.56225], [-121.99307, 39.56201], [-121.99299, 39.5624], [-121.99267, 39.56255], [-121.99254, 39.56256], [-121.99223, 39.56206], [-121.99223, 39.56278], [-121.99202, 39.5629], [-121.99105, 39.56295], [-121.99048, 39.56269], [-121.99049, 39.56174], [-121.99005, 39.56026], [-121.99016, 39.55991], [-121.99107, 39.55867], [-121.99143, 39.55837], [-121.99224, 39.55796], [-121.99316, 39.55774], [-121.99448, 39.55786], [-121.99569, 39.55781], [-121.99659, 39.55806], [-121.99659, 39.55849], [-121.99763, 39.5587], [-121.99784, 39.55903], [-121.99897, 39.55913], [-121.99977, 39.55929], [-122.00167, 39.5595], [-122.00208, 39.55937]]]]} | Restricted Access 2 | 25275 | Butte Sink Wildlife Management Area | 16605 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Butte 42 | 655.167 | Butte Sink WMA | 1980 | Conservation Area 13 | 2 | |
16397 | 16397 | 16396 | {"type": "Polygon", "coordinates": [[[-121.84941, 36.95765], [-121.84932, 36.95782], [-121.84903, 36.95804], [-121.84861, 36.95819], [-121.84853, 36.95827], [-121.84855, 36.95846], [-121.84801, 36.95847], [-121.84779, 36.95855], [-121.84752, 36.95899], [-121.84755, 36.9599], [-121.84699, 36.96071], [-121.84698, 36.96089], [-121.84729, 36.9623], [-121.84754, 36.96307], [-121.84617, 36.96314], [-121.84616, 36.96255], [-121.84619, 36.96183], [-121.84626, 36.96086], [-121.84627, 36.96017], [-121.84642, 36.95971], [-121.84642, 36.95919], [-121.84636, 36.95864], [-121.8462, 36.95828], [-121.84591, 36.95775], [-121.84515, 36.95702], [-121.84454, 36.9566], [-121.8446, 36.95623], [-121.8467, 36.95564], [-121.84709, 36.95597], [-121.84741, 36.9562], [-121.84775, 36.95682], [-121.8479, 36.95696], [-121.84802, 36.95701], [-121.84854, 36.95701], [-121.84879, 36.95719], [-121.84941, 36.95751], [-121.84941, 36.95765]]]} | Restricted Access 2 | 1387 | Ellicott Slough National Wildlife Area | 18587 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Santa Cruz 5 | 31.059 | Ellicott Slough Nat. Wildlife Area | 0 | Conservation Area 13 | 2 | |
16776 | 16776 | 16775 | {"type": "MultiPolygon", "coordinates": [[[[-121.98913, 39.63463], [-121.98831, 39.63516], [-121.98797, 39.6354], [-121.98776, 39.63558], [-121.98765, 39.63558], [-121.98749, 39.6358], [-121.98755, 39.63615], [-121.98734, 39.63669], [-121.98688, 39.63727], [-121.9863, 39.63822], [-121.98608, 39.63885], [-121.98592, 39.63988], [-121.98601, 39.64065], [-121.98631, 39.6418], [-121.98624, 39.64203], [-121.98624, 39.64253], [-121.98601, 39.64333], [-121.98612, 39.64348], [-121.98607, 39.64397], [-121.98652, 39.64403], [-121.98688, 39.6436], [-121.98761, 39.64346], [-121.98865, 39.64425], [-121.98794, 39.64442], [-121.98673, 39.64509], [-121.98542, 39.64584], [-121.98493, 39.64621], [-121.98419, 39.64662], [-121.98339, 39.64702], [-121.9828, 39.64725], [-121.98205, 39.64712], [-121.98178, 39.64703], [-121.98158, 39.64694], [-121.98098, 39.64676], [-121.98063, 39.64671], [-121.98033, 39.64664], [-121.97991, 39.64649], [-121.97959, 39.64641], [-121.97929, 39.64631], [-121.97908, 39.64626], [-121.97838, 39.64628], [-121.9781, 39.64627], [-121.97779, 39.64631], [-121.97737, 39.64639], [-121.97718, 39.64637], [-121.97465, 39.64655], [-121.97397, 39.64654], [-121.9728, 39.64632], [-121.97186, 39.64627], [-121.97155, 39.64611], [-121.97104, 39.64611], [-121.97061, 39.64618], [-121.97054, 39.64621], [-121.9702, 39.64641], [-121.96981, 39.64641], [-121.96931, 39.64637], [-121.95954, 39.63596], [-121.94593, 39.6374], [-121.94593, 39.63729], [-121.96613, 39.63515], [-121.97408, 39.63512], [-121.98913, 39.63463]]], [[[-121.99123, 39.75232], [-121.99, 39.75229], [-121.98999, 39.75234], [-121.98506, 39.75224], [-121.98404, 39.75224], [-121.98309, 39.75228], [-121.97719, 39.75269], [-121.97711, 39.75211], [-121.9764, 39.75237], [-121.97545, 39.7526], [-121.97547, 39.75281], [-121.97116, 39.75311], [-121.971, 39.75288], [-121.97049, 39.7526], [-121.97054, 39.75137], [-121.9704, 39.75094], [-121.96994, 39.7503], [-121.9693, 39.74961], [-121.96879, 39.74862], [-121.96846, 39.7478], [-121.96795, 39.74694], [-121.96753, 39.74646], [-121.9668, 39.74587], [-121.96646, 39.74517], [-121.96496, 39.74394], [-121.96459, 39.74317], [-121.96501, 39.74308], [-121.96556, 39.74391], [-121.96597, 39.74414], [-121.96624, 39.74453], [-121.96704, 39.74499], [-121.9671, 39.74545], [-121.96732, 39.74577], [-121.96763, 39.74605], [-121.96783, 39.74617], [-121.9683, 39.74667], [-121.96866, 39.74703], [-121.96905, 39.74725], [-121.96987, 39.747], [-121.97061, 39.74684], [-121.97208, 39.74673], [-121.97208, 39.74672], [-121.97032, 39.74409], [-121.97098, 39.74429], [-121.97197, 39.74384], [-121.972, 39.74316], [-121.97183, 39.74314], [-121.97049, 39.74113], [-121.97132, 39.74041], [-121.97284, 39.73962], [-121.97339, 39.74061], [-121.97416, 39.74024], [-121.97586, 39.73968], [-121.97714, 39.73933], [-121.97804, 39.73881], [-121.98153, 39.73829], [-121.98383, 39.73861], [-121.98411, 39.73877], [-121.98426, 39.73892], [-121.98435, 39.73919], [-121.98518, 39.74006], [-121.9855, 39.74045], [-121.98572, 39.74075], [-121.98578, 39.7408], [-121.98585, 39.74081], [-121.98589, 39.74085], [-121.98586, 39.74091], [-121.98636, 39.74153], [-121.98678, 39.74197], [-121.98577, 39.7422], [-121.98576, 39.74221], [-121.98689, 39.74383], [-121.98885, 39.74673], [-121.98861, 39.74682], [-121.98861, 39.74683], [-121.99123, 39.75232]]], [[[-121.97773, 39.64853], [-121.97603, 39.64885], [-121.97523, 39.64892], [-121.97472, 39.64892], [-121.97359, 39.64858], [-121.97173, 39.64826], [-121.97128, 39.64822], [-121.97152, 39.64786], [-121.97218, 39.64738], [-121.97261, 39.64717], [-121.97322, 39.64712], [-121.97362, 39.64721], [-121.97413, 39.64739], [-121.97509, 39.6476], [-121.97548, 39.64763], [-121.97617, 39.64778], [-121.97666, 39.64795], [-121.97728, 39.64824], [-121.97773, 39.64853]]], [[[-121.99226, 39.63886], [-121.99217, 39.6388], [-121.99202, 39.63862], [-121.99216, 39.63863], [-121.99226, 39.63886]]], [[[-122.03253, 39.7796], [-122.03181, 39.78056], [-122.03077, 39.78182], [-122.03027, 39.78147], [-122.02994, 39.78126], [-122.02965, 39.78102], [-122.02921, 39.78045], [-122.02898, 39.78008], [-122.02888, 39.77978], [-122.02882, 39.77941], [-122.02881, 39.7791], [-122.02883, 39.77883], [-122.02887, 39.77872], [-122.02892, 39.77865], [-122.02899, 39.77864], [-122.02913, 39.77872], [-122.02917, 39.77871], [-122.02936, 39.77803], [-122.02952, 39.77773], [-122.02973, 39.77756], [-122.0315, 39.77754], [-122.03199, 39.7782], [-122.03253, 39.7796]]]]} | Restricted Access 2 | 8354 | Butte Sink Wildlife Management Area | 16605 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Butte 42 | 1202.727 | Butte Sink WMA | 1980 | Conservation Area 13 | 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]);