units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
51 rows where DES_TP = 399 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
MNG_AGENCY 10
- Rivers and Lands Conservancy 13
- Save the Redwoods League 6
- Del Monte Forest Foundation 4
- Mojave Desert Land Trust 2
- Center for Natural Lands Management 1
- Sequoia Riverlands Trust 1
- Community Environmental Council 1
- Friends of Palm Springs Mountains 1
- Anza-Borrego Foundation 1
- Jacoby Creek Land Trust 1
ACCESS_TYP 4
MNG_AG_TYP 2
DES_TP 1
- Private Other or Unknown · 31 ✖
AGNCY_LEV 1 ✖
- Non Profit 31
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4601 | 4601 | 4600 | {"type": "Polygon", "coordinates": [[[-115.21015, 34.59172], [-115.21015, 34.59353], [-115.20906, 34.59354], [-115.20905, 34.59173], [-115.21015, 34.59172]]]} | No Public Access 3 | 35670 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 4.993 | 0 | Private Other or Unknown 399 | 4 | ||
4602 | 4602 | 4601 | {"type": "Polygon", "coordinates": [[[-115.6625, 33.59841], [-115.66249, 33.60022], [-115.66023, 33.60022], [-115.66024, 33.59841], [-115.6625, 33.59841]]]} | No Public Access 3 | 35673 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 10.421 | 0 | Private Other or Unknown 399 | 4 | ||
4603 | 4603 | 4602 | {"type": "Polygon", "coordinates": [[[-115.1219, 35.05811], [-115.12021, 35.06118], [-115.12025, 35.06121], [-115.12025, 35.06123], [-115.12096, 35.06162], [-115.11666, 35.06371], [-115.1155, 35.06308], [-115.11549, 35.06284], [-115.11505, 35.06283], [-115.11502, 35.06281], [-115.11527, 35.06281], [-115.11933, 35.06074], [-115.11932, 35.06072], [-115.11916, 35.06063], [-115.11916, 35.06061], [-115.11857, 35.06028], [-115.12025, 35.05724], [-115.12021, 35.0572], [-115.12022, 35.05718], [-115.1219, 35.05811]]]} | No Public Access 3 | 35700 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 33.803 | 0 | Private Other or Unknown 399 | 4 | ||
4606 | 4606 | 4605 | {"type": "Polygon", "coordinates": [[[-115.15033, 33.86963], [-115.15032, 33.87144], [-115.14923, 33.87145], [-115.14924, 33.86963], [-115.15033, 33.86963]]]} | No Public Access 3 | 35719 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 5.031 | 0 | Private Other or Unknown 399 | 4 | ||
4607 | 4607 | 4606 | {"type": "Polygon", "coordinates": [[[-115.25346, 33.94901], [-115.25345, 33.95266], [-115.24906, 33.95262], [-115.24907, 33.94897], [-115.25346, 33.94901]]]} | No Public Access 3 | 35721 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 40.642 | 0 | Private Other or Unknown 399 | 4 | ||
4608 | 4608 | 4607 | {"type": "Polygon", "coordinates": [[[-115.24832, 35.12435], [-115.24832, 35.12797], [-115.24722, 35.12797], [-115.24721, 35.12435], [-115.24832, 35.12435]]]} | No Public Access 3 | 35722 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 9.985 | 0 | Private Other or Unknown 399 | 4 | ||
4609 | 4609 | 4608 | {"type": "Polygon", "coordinates": [[[-115.21197, 35.21131], [-115.21197, 35.21493], [-115.20756, 35.21493], [-115.20756, 35.21131], [-115.21197, 35.21131]]]} | No Public Access 3 | 35743 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 39.846 | 0 | Private Other or Unknown 399 | 4 | ||
4610 | 4610 | 4609 | {"type": "Polygon", "coordinates": [[[-115.28271, 35.38007], [-115.28048, 35.38004], [-115.28047, 35.37823], [-115.2827, 35.37826], [-115.28271, 35.38007]]]} | No Public Access 3 | 35744 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 10.033 | 0 | Private Other or Unknown 399 | 4 | ||
4623 | 4623 | 4622 | {"type": "Polygon", "coordinates": [[[-115.19514, 35.20071], [-115.19305, 35.20073], [-115.193, 35.19347], [-115.19506, 35.19347], [-115.19514, 35.20071]]]} | No Public Access 3 | 36257 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 37.697 | 0 | Private Other or Unknown 399 | 4 | ||
4629 | 4629 | 4628 | {"type": "Polygon", "coordinates": [[[-115.21542, 34.61892], [-115.21541, 34.62072], [-115.2134, 34.62072], [-115.2134, 34.61892], [-115.21542, 34.61892]]]} | No Public Access 3 | 36262 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 9.135 | 0 | Private Other or Unknown 399 | 4 | ||
4674 | 4674 | 4673 | {"type": "Polygon", "coordinates": [[[-115.23841, 35.10623], [-115.2384, 35.11349], [-115.23579, 35.11348], [-115.2358, 35.10623], [-115.23841, 35.10623]]]} | No Public Access 3 | 36647 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 47.37 | 0 | Private Other or Unknown 399 | 4 | ||
4677 | 4677 | 4676 | {"type": "Polygon", "coordinates": [[[-115.25785, 33.94904], [-115.25784, 33.9527], [-115.25345, 33.95266], [-115.25346, 33.94901], [-115.25785, 33.94904]]]} | No Public Access 3 | 36662 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 40.688 | 0 | Private Other or Unknown 399 | 4 | ||
4685 | 4685 | 4684 | {"type": "Polygon", "coordinates": [[[-119.72173, 34.41045], [-119.72161, 34.41166], [-119.72134, 34.41164], [-119.72147, 34.41038], [-119.72173, 34.41045]]]} | Open Access 1 | 43089 | Unnamed site - Community Environmental Council | 28696 | 3015 | Community Environmental Council 508 | Non Profit 6 | Non Profit - Conservation 12 | http://www.communityenvironmentalcouncil.org/ | Non Governmental Organization 10 | 3015 | Community Environmental Council 500 | Non Profit 6 | Non Profit - Conservation 12 | Santa Barbara 7 | 0.838 | 0 | Private Other or Unknown 399 | 4 | ||
5650 | 5650 | 5649 | {"type": "Polygon", "coordinates": [[[-121.91973, 36.57135], [-121.91927, 36.57204], [-121.91913, 36.57218], [-121.91899, 36.57228], [-121.9188, 36.57237], [-121.91865, 36.57242], [-121.91734, 36.57272], [-121.91712, 36.57281], [-121.91691, 36.57295], [-121.91673, 36.57312], [-121.91662, 36.57329], [-121.91656, 36.57344], [-121.91651, 36.57366], [-121.91641, 36.57382], [-121.91592, 36.57423], [-121.91582, 36.57434], [-121.91426, 36.57282], [-121.91371, 36.572], [-121.91315, 36.57044], [-121.91344, 36.5697], [-121.91321, 36.569], [-121.91335, 36.56903], [-121.91351, 36.56904], [-121.91351, 36.56926], [-121.9144, 36.57029], [-121.91474, 36.57044], [-121.91522, 36.57083], [-121.91546, 36.57079], [-121.91582, 36.57063], [-121.91625, 36.57039], [-121.91654, 36.57045], [-121.91675, 36.57035], [-121.91716, 36.57037], [-121.91973, 36.57135]]]} | Open Access 1 | 35182 | Unnamed site - Del Monte Forest Foundation | 28634 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 37.011 | 0 | Private Other or Unknown 399 | 4 | ||
12217 | 12217 | 12216 | {"type": "Polygon", "coordinates": [[[-115.28714, 35.38373], [-115.28272, 35.3837], [-115.28272, 35.38188], [-115.28714, 35.38193], [-115.28714, 35.38373]]]} | No Public Access 3 | 35701 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 19.95 | 0 | Private Other or Unknown 399 | 4 | ||
14118 | 14118 | 14117 | {"type": "MultiPolygon", "coordinates": [[[[-124.03502, 40.80993], [-124.03498, 40.81172], [-124.03246, 40.81177], [-124.03248, 40.81705], [-124.02927, 40.8171], [-124.02926, 40.81711], [-124.02992, 40.8179], [-124.03317, 40.82081], [-124.03489, 40.822], [-124.03491, 40.82314], [-124.0345, 40.82247], [-124.03312, 40.82178], [-124.03296, 40.82168], [-124.02823, 40.82176], [-124.02824, 40.82087], [-124.02836, 40.81711], [-124.02895, 40.8171], [-124.02881, 40.81654], [-124.02839, 40.81594], [-124.02798, 40.81568], [-124.02707, 40.8152], [-124.02645, 40.81468], [-124.02631, 40.81455], [-124.0261, 40.8141], [-124.0262, 40.81377], [-124.02613, 40.81335], [-124.02589, 40.81297], [-124.02556, 40.81266], [-124.02527, 40.81232], [-124.02447, 40.81117], [-124.02409, 40.81086], [-124.02396, 40.81062], [-124.0239, 40.81002], [-124.02352, 40.80855], [-124.02346, 40.80814], [-124.02564, 40.80819], [-124.02561, 40.81005], [-124.03502, 40.80993]]], [[[-124.04434, 40.82678], [-124.04426, 40.82918], [-124.04221, 40.82917], [-124.04219, 40.82908], [-124.04223, 40.82879], [-124.04169, 40.82846], [-124.04067, 40.82843], [-124.0405, 40.82846], [-124.04036, 40.82856], [-124.03973, 40.82756], [-124.03983, 40.82704], [-124.03977, 40.8268], [-124.04013, 40.82673], [-124.04434, 40.82678]]], [[[-124.05768, 40.8335], [-124.05768, 40.83357], [-124.05758, 40.83375], [-124.05737, 40.83393], [-124.05725, 40.8342], [-124.05728, 40.83437], [-124.05736, 40.83451], [-124.0574, 40.83454], [-124.05702, 40.83465], [-124.05688, 40.83687], [-124.05618, 40.83864], [-124.05609, 40.83871], [-124.05475, 40.83809], [-124.05509, 40.83359], [-124.05526, 40.83358], [-124.05592, 40.83345], [-124.05625, 40.83344], [-124.05636, 40.8335], [-124.0566, 40.83349], [-124.05699, 40.83336], [-124.05719, 40.83333], [-124.0574, 40.83333], [-124.05753, 40.83335], [-124.05766, 40.83344], [-124.05768, 40.8335]]], [[[-124.07009, 40.83765], [-124.0679, 40.83919], [-124.06747, 40.83885], [-124.06692, 40.83922], [-124.06663, 40.83902], [-124.06593, 40.83952], [-124.06344, 40.83745], [-124.06343, 40.83657], [-124.05867, 40.83659], [-124.05867, 40.8347], [-124.06281, 40.83472], [-124.06288, 40.83478], [-124.06298, 40.83472], [-124.06301, 40.83472], [-124.06303, 40.83523], [-124.06343, 40.83522], [-124.06343, 40.83497], [-124.06488, 40.83499], [-124.06557, 40.83532], [-124.06597, 40.83578], [-124.06597, 40.83587], [-124.06601, 40.83598], [-124.06608, 40.83605], [-124.06619, 40.83612], [-124.06629, 40.83616], [-124.0664, 40.83618], [-124.06718, 40.83656], [-124.06763, 40.83681], [-124.06893, 40.83725], [-124.06923, 40.83733], [-124.06978, 40.83708], [-124.07009, 40.83765]]]]} | Unknown Access 4 | 46794 | Unnamed site - Jacoby Creek Land Trust | 30249 | 6085 | Jacoby Creek Land Trust 1072 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.jclandtrust.org/ | Non Governmental Organization 10 | 6085 | Jacoby Creek Land Trust 1028 | Non Profit 6 | Non Profit - Land Trust 10 | Humboldt 45 | 262.805 | 0 | Private Other or Unknown 399 | 4 | ||
15454 | 15454 | 15453 | {"type": "Polygon", "coordinates": [[[-116.36903, 33.83109], [-116.36896, 33.83837], [-116.36677, 33.83836], [-116.36686, 33.83109], [-116.36903, 33.83109]]]} | Unknown Access 4 | 3769 | Unnamed site - Center for Natural Lands Management | 28629 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 40.197 | 0 | Private Other or Unknown 399 | 4 | ||
15455 | 15455 | 15454 | {"type": "Polygon", "coordinates": [[[-121.92654, 36.55993], [-121.92639, 36.56001], [-121.92627, 36.56009], [-121.92593, 36.5604], [-121.92586, 36.56052], [-121.92584, 36.56072], [-121.9258, 36.56082], [-121.92535, 36.56122], [-121.92524, 36.56139], [-121.92521, 36.56155], [-121.92522, 36.56169], [-121.92527, 36.56181], [-121.92548, 36.56213], [-121.9255, 36.56223], [-121.9255, 36.5623], [-121.92531, 36.56285], [-121.9253, 36.56346], [-121.92527, 36.56357], [-121.92521, 36.56369], [-121.92503, 36.56395], [-121.92494, 36.56423], [-121.92488, 36.56435], [-121.92364, 36.56601], [-121.92339, 36.5663], [-121.92263, 36.56706], [-121.92253, 36.56721], [-121.92229, 36.56781], [-121.9215, 36.56899], [-121.92037, 36.57038], [-121.91973, 36.57135], [-121.9174, 36.57047], [-121.91788, 36.57038], [-121.91798, 36.57033], [-121.91806, 36.57027], [-121.91812, 36.57016], [-121.91814, 36.57004], [-121.91814, 36.56987], [-121.9181, 36.56969], [-121.91852, 36.56965], [-121.91856, 36.5695], [-121.91863, 36.5694], [-121.91908, 36.56966], [-121.91949, 36.5694], [-121.91981, 36.56917], [-121.92027, 36.56865], [-121.92032, 36.56821], [-121.91981, 36.56826], [-121.91938, 36.56839], [-121.91933, 36.56832], [-121.91974, 36.56816], [-121.9197, 36.56792], [-121.92011, 36.56765], [-121.92071, 36.56744], [-121.92063, 36.56718], [-121.92068, 36.56711], [-121.9207, 36.56705], [-121.92069, 36.56697], [-121.92066, 36.56691], [-121.92055, 36.56682], [-121.92021, 36.56676], [-121.92018, 36.56674], [-121.92018, 36.56671], [-121.92025, 36.56654], [-121.9203, 36.56634], [-121.92033, 36.5663], [-121.92052, 36.56619], [-121.92061, 36.56608], [-121.92064, 36.56598], [-121.92065, 36.56577], [-121.92069, 36.56566], [-121.92074, 36.5656], [-121.92079, 36.56558], [-121.92083, 36.56559], [-121.92123, 36.56582], [-121.92138, 36.56588], [-121.92156, 36.5659], [-121.92174, 36.56589], [-121.92193, 36.56583], [-121.9225, 36.56551], [-121.92266, 36.5653], [-121.92316, 36.56553], [-121.92356, 36.56515], [-121.92407, 36.56498], [-121.92359, 36.56459], [-121.92364, 36.56458], [-121.92411, 36.56494], [-121.9244, 36.5646], [-121.92459, 36.56419], [-121.92475, 36.56316], [-121.92474, 36.56315], [-121.92413, 36.5632], [-121.92413, 36.56317], [-121.92476, 36.56311], [-121.92476, 36.56234], [-121.92442, 36.56176], [-121.92466, 36.56167], [-121.92466, 36.56142], [-121.92486, 36.56142], [-121.92486, 36.56128], [-121.92498, 36.56112], [-121.92508, 36.56103], [-121.92507, 36.56041], [-121.92531, 36.56034], [-121.92639, 36.55982], [-121.92654, 36.55993]]]} | Open Access 1 | 35191 | Unnamed site - Del Monte Forest Foundation | 28634 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 38.319 | 0 | Private Other or Unknown 399 | 4 | ||
15456 | 15456 | 15455 | {"type": "Polygon", "coordinates": [[[-121.93147, 36.56365], [-121.93048, 36.56454], [-121.93017, 36.56492], [-121.92926, 36.56425], [-121.93065, 36.56304], [-121.93147, 36.56365]]]} | Open Access 1 | 35193 | Unnamed site - Del Monte Forest Foundation | 28634 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 4.643 | 0 | Private Other or Unknown 399 | 4 | ||
15484 | 15484 | 15483 | {"type": "Polygon", "coordinates": [[[-121.96137, 36.58829], [-121.96126, 36.5894], [-121.96019, 36.58938], [-121.9593, 36.58896], [-121.95808, 36.58933], [-121.95723, 36.58925], [-121.95638, 36.58921], [-121.95543, 36.58899], [-121.95365, 36.58957], [-121.95329, 36.58964], [-121.953, 36.58949], [-121.95272, 36.58928], [-121.95237, 36.58925], [-121.9525, 36.58896], [-121.95323, 36.58923], [-121.95342, 36.58928], [-121.95368, 36.58932], [-121.95394, 36.58932], [-121.9542, 36.58931], [-121.95445, 36.58926], [-121.95475, 36.58916], [-121.95495, 36.58906], [-121.95511, 36.58897], [-121.95577, 36.58843], [-121.95587, 36.58828], [-121.95593, 36.58806], [-121.956, 36.58793], [-121.9561, 36.58779], [-121.95621, 36.58768], [-121.95638, 36.58758], [-121.95672, 36.58744], [-121.95702, 36.58735], [-121.95723, 36.58732], [-121.95762, 36.5873], [-121.95783, 36.58732], [-121.95808, 36.58736], [-121.96137, 36.58829]]]} | Open Access 1 | 43084 | Unnamed site - Del Monte Forest Foundation | 28634 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 22.917 | 0 | Private Other or Unknown 399 | 4 |
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]);