calands: units_with_maps: 17 rows where ACCESS_TYP = 3, AGNCY_NAME = 4, MNG_AGENCY = 4 and YR

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

17 rows where ACCESS_TYP = 3, AGNCY_NAME = 4, MNG_AGENCY = 4 and YR_EST = 0

Search:

descending

This data as json, copyable, CSV (advanced)

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	DES_TP	GAP_STS
1339	1339	1338	{"type": "Polygon", "coordinates": [[[-116.73714, 32.58342], [-116.74114, 32.58362], [-116.74116, 32.57636], [-116.73709, 32.57624], [-116.73707, 32.57262], [-116.74115, 32.5727], [-116.74116, 32.5691], [-116.73703, 32.56906], [-116.73696, 32.56738], [-116.75384, 32.56596], [-116.75385, 32.56579], [-116.80114, 32.56182], [-116.80119, 32.56352], [-116.79687, 32.56361], [-116.79696, 32.56738], [-116.78817, 32.56748], [-116.78397, 32.56787], [-116.78402, 32.57978], [-116.77099, 32.58015], [-116.76217, 32.58046], [-116.76212, 32.58426], [-116.75374, 32.58427], [-116.75371, 32.58796], [-116.75367, 32.59538], [-116.74509, 32.59534], [-116.74513, 32.59151], [-116.72846, 32.59121], [-116.72857, 32.58727], [-116.73278, 32.58732], [-116.7329, 32.5834], [-116.73714, 32.58342]]]}	No Public Access 3	7398	Marron Valley Mitigation Bank	21885	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	2644.0	Marron Valley Mitigation Bank	Local Other or Unknown 14	4
3846	3846	3845	{"type": "Polygon", "coordinates": [[[-117.22388, 32.93759], [-117.22376, 32.93764], [-117.22348, 32.9376], [-117.22333, 32.93761], [-117.22215, 32.93794], [-117.22194, 32.93802], [-117.22151, 32.93822], [-117.22151, 32.93456], [-117.22388, 32.93457], [-117.22388, 32.93759]]]}	No Public Access 3	46811	Neighborhood 8 Neighborhood Park	30272	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	19.773	Neighborhood 8 Neighborhood Park	Local Park 2	4
4196	4196	4195	{"type": "Polygon", "coordinates": [[[-116.88012, 33.16121], [-116.87559, 33.16121], [-116.87567, 33.15391], [-116.88007, 33.1539], [-116.88011, 33.15824], [-116.88012, 33.16121]]]}	No Public Access 3	47685	Pamo Watershed	31421	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	83.475	Pamo Watershed	Local Resource Management Area 83	3
4532	4532	4531	{"type": "MultiPolygon", "coordinates": [[[[-117.21241, 32.80723], [-117.21239, 32.80731], [-117.21232, 32.80734], [-117.2111, 32.80742], [-117.21111, 32.80697], [-117.21157, 32.80696], [-117.21172, 32.80698], [-117.21219, 32.80709], [-117.21237, 32.80716], [-117.21241, 32.80723]]], [[[-117.21219, 32.80689], [-117.21219, 32.80695], [-117.21195, 32.80689], [-117.21219, 32.80689], [-117.21219, 32.80689]]]]}	No Public Access 3	18410	Unnamed site - San Diego, City of	31719	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	1.217		Local Other or Unknown 14	4
4535	4535	4534	{"type": "Polygon", "coordinates": [[[-117.23982, 32.87111], [-117.23981, 32.87152], [-117.23927, 32.87152], [-117.23951, 32.87136], [-117.23982, 32.87111]]]}	No Public Access 3	19896	Unnamed site - San Diego, City of	31719	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	0.273		Local Other or Unknown 14	4
4536	4536	4535	{"type": "Polygon", "coordinates": [[[-117.1276, 32.76738], [-117.12717, 32.76784], [-117.12705, 32.76778], [-117.12742, 32.76738], [-117.1276, 32.76738]]]}	No Public Access 3	19905	Unnamed site - San Diego, City of	31719	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	0.196		Local Other or Unknown 14	4
4537	4537	4536	{"type": "Polygon", "coordinates": [[[-117.10461, 32.76969], [-117.10445, 32.76969], [-117.10461, 32.76951], [-117.10461, 32.76969], [-117.10461, 32.76969]]]}	No Public Access 3	19907	Unnamed site - San Diego, City of	31719	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	0.035		Local Other or Unknown 14	4
4785	4785	4784	{"type": "Polygon", "coordinates": [[[-117.23137, 32.88833], [-117.22878, 32.89057], [-117.22879, 32.89385], [-117.22675, 32.89645], [-117.22675, 32.89619], [-117.22726, 32.89551], [-117.22708, 32.8954], [-117.22721, 32.89514], [-117.22753, 32.89435], [-117.22772, 32.89381], [-117.22795, 32.89294], [-117.22797, 32.89271], [-117.22797, 32.89157], [-117.22795, 32.89107], [-117.22798, 32.89083], [-117.22816, 32.89009], [-117.22833, 32.89009], [-117.22872, 32.88902], [-117.22917, 32.88808], [-117.22989, 32.8883], [-117.23011, 32.88786], [-117.23073, 32.88808], [-117.23137, 32.88833]]]}	No Public Access 3	47655	Unnamed site - San Diego, City of	31719	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	20.801		Local Other or Unknown 14	4
4786	4786	4785	{"type": "MultiPolygon", "coordinates": [[[[-116.87263, 32.64332], [-116.87061, 32.64522], [-116.87029, 32.64505], [-116.87093, 32.64366], [-116.87252, 32.64297], [-116.87263, 32.64332]]], [[[-116.87285, 32.64414], [-116.87285, 32.64414], [-116.87206, 32.64428], [-116.87271, 32.64366], [-116.87285, 32.64414]]]]}	No Public Access 3	47661	Unnamed site - San Diego, City of	31719	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	5.302		Local Other or Unknown 14	4
5384	5384	5383	{"type": "MultiPolygon", "coordinates": [[[[-116.68414, 32.63592], [-116.68408, 32.63754], [-116.68186, 32.63754], [-116.68193, 32.63587], [-116.68414, 32.63592]]], [[[-116.73738, 32.62107], [-116.72053, 32.62112], [-116.72052, 32.62207], [-116.72052, 32.62295], [-116.7117, 32.62354], [-116.71149, 32.62647], [-116.70719, 32.6268], [-116.70737, 32.63295], [-116.69486, 32.63301], [-116.6948, 32.63927], [-116.69518, 32.64285], [-116.69112, 32.64286], [-116.69177, 32.64642], [-116.68717, 32.64646], [-116.68654, 32.64172], [-116.68619, 32.63925], [-116.68626, 32.63596], [-116.68515, 32.63593], [-116.6852, 32.63414], [-116.68522, 32.63386], [-116.68629, 32.63392], [-116.68627, 32.63595], [-116.69052, 32.63602], [-116.6907, 32.62656], [-116.69491, 32.62661], [-116.69487, 32.61949], [-116.69897, 32.61962], [-116.69898, 32.61612], [-116.70769, 32.61631], [-116.71809, 32.61565], [-116.71841, 32.61579], [-116.71976, 32.61606], [-116.72042, 32.61573], [-116.72048, 32.61573], [-116.7205, 32.61766], [-116.72724, 32.61758], [-116.72721, 32.61799], [-116.72733, 32.61851], [-116.72734, 32.61863], [-116.7274, 32.6188], [-116.72749, 32.61894], [-116.7276, 32.61905], [-116.72772, 32.61914], [-116.72798, 32.61926], [-116.72822, 32.61931], [-116.72844, 32.61931], [-116.72863, 32.61927], [-116.72879, 32.61922], [-116.72899, 32.6191], [-116.72916, 32.61894], [-116.72964, 32.61831], [-116.73109, 32.61792], [-116.73167, 32.61772], [-116.73243, 32.61755], [-116.73313, 32.61755], [-116.73314, 32.61739], [-116.73495, 32.61697], [-116.73551, 32.61686], [-116.73599, 32.6168], [-116.73648, 32.61676], [-116.737, 32.61675], [-116.73737, 32.61677], [-116.73738, 32.62107]]], [[[-116.73102, 32.61755], [-116.72988, 32.61781], [-116.72962, 32.6179], [-116.72943, 32.61801], [-116.72935, 32.61808], [-116.72835, 32.61869], [-116.72789, 32.61859], [-116.72763, 32.61823], [-116.72768, 32.61763], [-116.72773, 32.61758], [-116.73102, 32.61755]]], [[[-116.73736, 32.61645], [-116.73617, 32.61654], [-116.73521, 32.61659], [-116.73314, 32.61707], [-116.73303, 32.61407], [-116.73736, 32.61399], [-116.73736, 32.61645]]]]}	No Public Access 3	7400	MSCP Open Space Preserve Land	22572	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	1276.75	MSCP OSP Land	Local Conservation Area 4	2
6608	6608	6607	{"type": "Polygon", "coordinates": [[[-117.03964, 32.5565], [-117.03952, 32.55674], [-117.03854, 32.5569], [-117.03824, 32.55697], [-117.03804, 32.55697], [-117.03763, 32.55706], [-117.03762, 32.55704], [-117.03717, 32.55717], [-117.03738, 32.55766], [-117.03743, 32.55783], [-117.03746, 32.55795], [-117.03747, 32.55822], [-117.03369, 32.55819], [-117.03357, 32.55452], [-117.03776, 32.55454], [-117.03928, 32.55638], [-117.03964, 32.5565]]]}	No Public Access 3	4168	Beyer Community Park	30224	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	43.828	Beyer Community Park	Local Park 2	4
7953	7953	7952	{"type": "MultiPolygon", "coordinates": [[[[-116.95582, 33.09367], [-116.95482, 33.09407], [-116.95304, 33.09459], [-116.95185, 33.09475], [-116.95079, 33.09468], [-116.94644, 33.09467], [-116.94635, 33.09069], [-116.95067, 33.09066], [-116.95146, 33.09064], [-116.95215, 33.09074], [-116.95268, 33.09087], [-116.95322, 33.09107], [-116.95366, 33.09136], [-116.95423, 33.09182], [-116.95582, 33.09367]]], [[[-116.96354, 33.09], [-116.96328, 33.0901], [-116.96266, 33.09026], [-116.96248, 33.09039], [-116.96176, 33.09047], [-116.96159, 33.09052], [-116.96148, 33.09059], [-116.96126, 33.09065], [-116.96084, 33.09068], [-116.9606, 33.09061], [-116.96027, 33.09065], [-116.95962, 33.09077], [-116.95925, 33.09081], [-116.95875, 33.0907], [-116.95847, 33.09082], [-116.95834, 33.09099], [-116.95834, 33.09114], [-116.95816, 33.09119], [-116.95783, 33.09142], [-116.95655, 33.09153], [-116.95586, 33.09154], [-116.95554, 33.09157], [-116.95504, 33.09156], [-116.95511, 33.09141], [-116.95514, 33.09127], [-116.95509, 33.08796], [-116.95505, 33.08774], [-116.95503, 33.08773], [-116.95502, 33.08757], [-116.95499, 33.08605], [-116.95502, 33.08596], [-116.9551, 33.08587], [-116.95544, 33.08564], [-116.95577, 33.08548], [-116.95587, 33.08545], [-116.95736, 33.08523], [-116.96048, 33.08484], [-116.96078, 33.08475], [-116.96235, 33.08411], [-116.96281, 33.08397], [-116.9634, 33.08386], [-116.96354, 33.09]]], [[[-117.02348, 33.08538], [-117.02157, 33.08742], [-117.02158, 33.08743], [-117.02264, 33.08743], [-117.02206, 33.08791], [-117.02174, 33.08824], [-117.02153, 33.08848], [-117.02053, 33.08982], [-117.02044, 33.09001], [-117.02038, 33.09019], [-117.02034, 33.09042], [-117.02035, 33.09063], [-117.0116, 33.09079], [-117.0116, 33.09094], [-117.01156, 33.09095], [-117.01158, 33.09175], [-117.01257, 33.09174], [-117.01255, 33.09092], [-117.01578, 33.09088], [-117.02036, 33.09079], [-117.02093, 33.09749], [-117.01991, 33.09827], [-117.01977, 33.09836], [-117.01938, 33.09855], [-117.01901, 33.09866], [-117.01878, 33.09871], [-117.01757, 33.09878], [-117.01756, 33.09866], [-117.01585, 33.09866], [-117.01584, 33.09821], [-117.01414, 33.09824], [-117.01388, 33.09797], [-117.01286, 33.09673], [-117.01275, 33.09663], [-117.01257, 33.09647], [-117.01226, 33.09626], [-117.01195, 33.09609], [-117.01165, 33.09596], [-117.01115, 33.09581], [-117.01065, 33.09572], [-117.0102, 33.0957], [-117.00977, 33.09572], [-117.00692, 33.09541], [-117.00447, 33.09477], [-116.99519, 33.09143], [-116.99507, 33.09161], [-116.99469, 33.09146], [-116.99422, 33.09121], [-116.99378, 33.09095], [-116.99262, 33.09003], [-116.99214, 33.08948], [-116.99193, 33.08891], [-116.99171, 33.08772], [-116.99157, 33.08724], [-116.9913, 33.08679], [-116.99107, 33.08645], [-116.99085, 33.08621], [-116.99067, 33.08606], [-116.99029, 33.0859], [-116.99001, 33.08583], [-116.98977, 33.08579], [-116.9897, 33.08577], [-116.98927, 33.08577], [-116.98878, 33.0858], [-116.98836, 33.08591], [-116.98818, 33.08598], [-116.98706, 33.08657], [-116.98639, 33.08686], [-116.98418, 33.08765], [-116.98363, 33.08788], [-116.98249, 33.0883], [-116.98225, 33.08836], [-116.98176, 33.08844], [-116.981, 33.08851], [-116.98052, 33.0886], [-116.97455, 33.09021], [-116.97207, 33.09097], [-116.97147, 33.09108], [-116.96921, 33.09146], [-116.96875, 33.09156], [-116.96831, 33.09172], [-116.96602, 33.09259], [-116.96559, 33.09271], [-116.96443, 33.09296], [-116.96415, 33.09304], [-116.96378, 33.0932], [-116.96371, 33.0913], [-116.96365, 33.084], [-116.96374, 33.08388], [-116.96792, 33.08311], [-116.9694, 33.08286], [-116.97034, 33.08223], [-116.97079, 33.08174], [-116.97174, 33.08094], [-116.97235, 33.08027], [-116.97262, 33.08004], [-116.97365, 33.07856], [-116.97394, 33.07792], [-116.97407, 33.07751], [-116.97438, 33.07592], [-116.97443, 33.07579], [-116.97455, 33.07551], [-116.97467, 33.07534], [-116.97491, 33.07512], [-116.97515, 33.07497], [-116.97774, 33.07378], [-116.97812, 33.07362], [-116.97826, 33.07361], [-116.97841, 33.0737], [-116.9786, 33.07378], [-116.97881, 33.07407], [-116.97921, 33.07418], [-116.97937, 33.07439], [-116.97951, 33.07453], [-116.97976, 33.07462], [-116.97994, 33.0747], [-116.98001, 33.07477], [-116.98008, 33.07494], [-116.98024, 33.07506], [-116.9804, 33.07511], [-116.98055, 33.07519], [-116.98062, 33.07528], [-116.98066, 33.07535], [-116.98078, 33.07546], [-116.98108, 33.07554], [-116.98122, 33.0756], [-116.98136, 33.07578], [-116.98162, 33.07593], [-116.9817, 33.07605], [-116.98183, 33.07617], [-116.98216, 33.0763], [-116.98226, 33.07636], [-116.98236, 33.07647], [-116.98249, 33.07656], [-116.98264, 33.07661], [-116.98283, 33.07669], [-116.983, 33.07678], [-116.98317, 33.07691], [-116.9833, 33.07696], [-116.9836, 33.07695], [-116.98371, 33.07709], [-116.98393, 33.07715], [-116.98413, 33.07722], [-116.98429, 33.07734], [-116.98463, 33.07768], [-116.9849, 33.07774], [-116.98502, 33.07782], [-116.98518, 33.07787], [-116.98533, 33.07787], [-116.98568, 33.07779], [-116.98582, 33.07784], [-116.98623, 33.07783], [-116.98639, 33.07788], [-116.98656, 33.0779], [-116.98673, 33.07786], [-116.98678, 33.07773], [-116.98671, 33.07765], [-116.98672, 33.07752], [-116.9868, 33.07746], [-116.98706, 33.07735], [-116.98754, 33.07724], [-116.98767, 33.07725], [-116.98781, 33.07721], [-116.99018, 33.0768], [-116.99224, 33.0764], [-116.99598, 33.07552], [-116.99606, 33.07634], [-116.9963, 33.07624], [-116.99652, 33.07647], [-116.9968, 33.07652], [-116.99702, 33.07647], [-116.99718, 33.07663], [-116.9974, 33.07698], [-116.99742, 33.07707], [-116.99744, 33.0771], [-116.99757, 33.07712], [-116.99761, 33.07716], [-116.9976, 33.07724], [-116.99764, 33.07727], [-116.99768, 33.07728], [-116.9978, 33.07724], [-116.99797, 33.07726], [-116.99801, 33.07723], [-116.99802, 33.07719], [-116.99795, 33.0771], [-116.99797, 33.07704], [-116.998, 33.07702], [-116.99803, 33.07701], [-116.99815, 33.07703], [-116.99818, 33.077], [-116.99818, 33.07697], [-116.9982, 33.07695], [-116.99823, 33.07695], [-116.99826, 33.077], [-116.9983, 33.07701], [-116.99833, 33.07699], [-116.99836, 33.07694], [-116.99837, 33.07657], [-116.99841, 33.07652], [-116.99844, 33.07652], [-116.99856, 33.07657], [-116.99869, 33.07658], [-116.99873, 33.0766], [-116.99876, 33.07663], [-116.99882, 33.07676], [-116.99887, 33.07679], [-116.99925, 33.07673], [-116.99938, 33.07678], [-116.99953, 33.07675], [-116.99962, 33.0768], [-116.99978, 33.07683], [-116.99993, 33.07682], [-117.00003, 33.07679], [-117.00036, 33.07661], [-117.00039, 33.07648], [-117.0005, 33.07635], [-117.00052, 33.0763], [-117.00051, 33.07621], [-117.00046, 33.07615], [-117.00056, 33.07613], [-117.00056, 33.07611], [-117.00059, 33.0761], [-117.0007, 33.07609], [-117.00085, 33.07602], [-117.0009, 33.07601], [-117.00108, 33.07605], [-117.00114, 33.07604], [-117.00125, 33.07598], [-117.0013, 33.07597], [-117.00136, 33.07599], [-117.00154, 33.07612], [-117.00156, 33.07616], [-117.00154, 33.07622], [-117.0016, 33.07641], [-117.0016, 33.07651], [-117.00163, 33.07656], [-117.0019, 33.0766], [-117.00199, 33.07661], [-117.00207, 33.07658], [-117.00214, 33.07654], [-117.00219, 33.07648], [-117.00263, 33.07638], [-117.00267, 33.0764], [-117.0027, 33.07647], [-117.00273, 33.07649], [-117.00277, 33.07651], [-117.00285, 33.07652], [-117.00296, 33.07633], [-117.0031, 33.07626], [-117.00323, 33.07624], [-117.00362, 33.07603], [-117.00365, 33.076], [-117.00365, 33.07593], [-117.00367, 33.07591], [-117.00371, 33.0759], [-117.0044, 33.07587], [-117.00451, 33.07589], [-117.00453, 33.07592], [-117.00455, 33.07598], [-117.00504, 33.07626], [-117.00516, 33.07636], [-117.00554, 33.07643], [-117.00577, 33.07652], [-117.0059, 33.07653], [-117.00603, 33.07649], [-117.00612, 33.07649], [-117.00618, 33.07647], [-117.00639, 33.07648], [-117.00646, 33.07647], [-117.0066, 33.07637], [-117.00664, 33.07637], [-117.00676, 33.07641], [-117.00686, 33.07642], [-117.00697, 33.07641], [-117.00723, 33.07651], [-117.00734, 33.07649], [-117.00739, 33.07649], [-117.00747, 33.07656], [-117.00768, 33.07666], [-117.00787, 33.07679], [-117.00798, 33.0769], [-117.00804, 33.07692], [-117.00811, 33.0769], [-117.00817, 33.07679], [-117.00821, 33.07676], [-117.00824, 33.07677], [-117.00827, 33.0768], [-117.00826, 33.07693], [-117.00828, 33.077], [-117.00833, 33.07702], [-117.00853, 33.07703], [-117.00857, 33.07705], [-117.00864, 33.07713], [-117.00873, 33.07716], [-117.00873, 33.0772], [-117.00878, 33.07724], [-117.00899, 33.07725], [-117.00905, 33.07721], [-117.00909, 33.07721], [-117.00928, 33.07731], [-117.00956, 33.07739], [-117.00983, 33.07751], [-117.01021, 33.07771], [-117.01029, 33.07778], [-117.01069, 33.07796], [-117.01107, 33.07807], [-117.01126, 33.07814], [-117.01151, 33.07816], [-117.01157, 33.07822], [-117.01169, 33.07836], [-117.01186, 33.07847], [-117.01196, 33.0785], [-117.01205, 33.0785], [-117.01229, 33.0786], [-117.01257, 33.07864], [-117.0126, 33.07868], [-117.01263, 33.07892], [-117.01272, 33.07911], [-117.01282, 33.07923], [-117.01294, 33.0793], [-117.01306, 33.07942], [-117.01315, 33.07961], [-117.01321, 33.07969], [-117.01327, 33.07983], [-117.01353, 33.08011], [-117.01361, 33.08027], [-117.01375, 33.08043], [-117.01381, 33.08047], [-117.01385, 33.08067], [-117.01387, 33.08074], [-117.01426, 33.0812], [-117.01444, 33.08131], [-117.01466, 33.08137], [-117.01473, 33.08142], [-117.01486, 33.08146], [-117.01514, 33.0815], [-117.01517, 33.08153], [-117.01513, 33.0816], [-117.01512, 33.08217], [-117.01516, 33.08228], [-117.0153, 33.08243], [-117.01535, 33.08251], [-117.01554, 33.08265], [-117.01568, 33.08269], [-117.01595, 33.08279], [-117.01696, 33.08292], [-117.01708, 33.08292], [-117.01715, 33.08304], [-117.01722, 33.0831], [-117.01771, 33.08323], [-117.018, 33.08346], [-117.0183, 33.08373], [-117.01871, 33.08401], [-117.01906, 33.08415], [-117.01915, 33.08416], [-117.01925, 33.08415], [-117.01937, 33.0841], [-117.01964, 33.08382], [-117.02348, 33.08538]]], [[[-117.04573, 33.05118], [-117.04474, 33.05152], [-117.04308, 33.05231], [-117.04264, 33.05248], [-117.04235, 33.05247], [-117.04168, 33.0524], [-117.04068, 33.05248], [-117.03994, 33.05259], [-117.03939, 33.05276], [-117.03893, 33.05306], [-117.03777, 33.05392], [-117.03596, 33.05543], [-117.03554, 33.05592], [-117.03532, 33.05631], [-117.03461, 33.05664], [-117.03313, 33.05669], [-117.03288, 33.05676], [-117.03146, 33.05755], [-117.03104, 33.05785], [-117.03071, 33.05826], [-117.03042, 33.05879], [-117.0303, 33.05931], [-117.03009, 33.06176], [-117.02991, 33.06209], [-117.02961, 33.06223], [-117.0289, 33.06216], [-117.02787, 33.0621], [-117.02767, 33.06227], [-117.02746, 33.06242], [-117.02506, 33.06248], [-117.02505, 33.0624], [-117.02479, 33.06227], [-117.02487, 33.06213], [-117.02472, 33.06195], [-117.0244, 33.06179], [-117.02414, 33.06155], [-117.02314, 33.06163], [-117.02315, 33.05985], [-117.02333, 33.0597], [-117.02364, 33.05989], [-117.02443, 33.05987], [-117.02456, 33.05975], [-117.0244, 33.05901], [-117.02419, 33.05874], [-117.02449, 33.05856], [-117.02518, 33.05849], [-117.02568, 33.05815], [-117.02604, 33.05765], [-117.02602, 33.05749], [-117.0262, 33.05753], [-117.0265, 33.05739], [-117.02634, 33.05727], [-117.02661, 33.05718], [-117.02686, 33.05741], [-117.02742, 33.05708], [-117.0277, 33.05679], [-117.02843, 33.05665], [-117.02954, 33.05553], [-117.02958, 33.05524], [-117.0301, 33.0548], [-117.03009, 33.05449], [-117.0299, 33.05429], [-117.03015, 33.05422], [-117.03029, 33.05385], [-117.02996, 33.05366], [-117.03029, 33.05355], [-117.03004, 33.0532], [-117.02984, 33.0532], [-117.02993, 33.05302], [-117.02977, 33.05283], [-117.02965, 33.05276], [-117.02974, 33.05267], [-117.0298, 33.0525], [-117.03005, 33.05247], [-117.03018, 33.05235], [-117.0302, 33.05221], [-117.03078, 33.05199], [-117.03082, 33.05168], [-117.03101, 33.05176], [-117.03118, 33.0519], [-117.03121, 33.05205], [-117.03142, 33.05222], [-117.03152, 33.05235], [-117.03161, 33.05254], [-117.03172, 33.0526], [-117.0317, 33.05276], [-117.0319, 33.05323], [-117.0322, 33.05358], [-117.03251, 33.05366], [-117.033, 33.0536], [-117.0332, 33.0535], [-117.03354, 33.05395], [-117.03372, 33.05402], [-117.03405, 33.05399], [-117.03449, 33.05379], [-117.03491, 33.05349], [-117.03525, 33.05341], [-117.03546, 33.0533], [-117.03564, 33.05294], [-117.03564, 33.05265], [-117.03535, 33.05209], [-117.03485, 33.05208], [-117.03535, 33.05196], [-117.03535, 33.05175], [-117.03524, 33.05167], [-117.03551, 33.05159], [-117.03641, 33.0508], [-117.03686, 33.05007], [-117.03774, 33.05005], [-117.03825, 33.04912], [-117.03828, 33.04894], [-117.03825, 33.0486], [-117.03806, 33.04819], [-117.03781, 33.04825], [-117.03778, 33.04815], [-117.0377, 33.04817], [-117.03771, 33.04806], [-117.03789, 33.048], [-117.03797, 33.04745], [-117.03783, 33.04722], [-117.03758, 33.04699], [-117.03792, 33.04698], [-117.03823, 33.04682], [-117.03827, 33.04668], [-117.03818, 33.04641], [-117.03828, 33.04624], [-117.03836, 33.04591], [-117.03826, 33.04578], [-117.03812, 33.04572], [-117.03844, 33.04562], [-117.03865, 33.04535], [-117.03859, 33.04512], [-117.03841, 33.04514], [-117.03845, 33.04501], [-117.03888, 33.04486], [-117.03937, 33.04445], [-117.03971, 33.04401], [-117.04105, 33.04401], [-117.04157, 33.04309], [-117.04233, 33.04332], [-117.04263, 33.04361], [-117.04274, 33.04392], [-117.04283, 33.0445], [-117.04287, 33.04508], [-117.04275, 33.04535], [-117.0423, 33.04567], [-117.04217, 33.04582], [-117.04212, 33.04608], [-117.04216, 33.04637], [-117.04233, 33.04665], [-117.04244, 33.04696], [-117.04253, 33.04747], [-117.04249, 33.04797], [-117.04251, 33.04826], [-117.04266, 33.04849], [-117.04288, 33.04872], [-117.04303, 33.04893], [-117.04315, 33.04923], [-117.04325, 33.04936], [-117.04357, 33.04962], [-117.04393, 33.05005], [-117.04408, 33.0502], [-117.04493, 33.05066], [-117.04573, 33.05118]]], [[[-117.05859, 33.05956], [-117.05757, 33.06226], [-117.05563, 33.06168], [-117.0535, 33.06157], [-117.05357, 33.06152], [-117.05377, 33.0612], [-117.05441, 33.06034], [-117.05446, 33.06023], [-117.05125, 33.05968], [-117.05065, 33.05914], [-117.05014, 33.05897], [-117.04971, 33.05899], [-117.04874, 33.05944], [-117.04812, 33.05927], [-117.04759, 33.05946], [-117.04664, 33.05961], [-117.04531, 33.05939], [-117.04494, 33.05966], [-117.04454, 33.05944], [-117.04367, 33.05998], [-117.04365, 33.06001], [-117.04331, 33.06018], [-117.04328, 33.06016], [-117.043, 33.0603], [-117.04262, 33.06128], [-117.0418, 33.06111], [-117.04125, 33.06103], [-117.04012, 33.06164], [-117.04003, 33.06213], [-117.03961, 33.06241], [-117.04003, 33.06278], [-117.03928, 33.06259], [-117.03881, 33.0629], [-117.03852, 33.06421], [-117.03838, 33.06427], [-117.0381, 33.06477], [-117.03821, 33.0651], [-117.03838, 33.06525], [-117.03895, 33.06536], [-117.03958, 33.06568], [-117.03956, 33.06579], [-117.03915, 33.06596], [-117.0391, 33.06614], [-117.03922, 33.06632], [-117.04003, 33.06676], [-117.04116, 33.06729], [-117.04118, 33.06744], [-117.04717, 33.06795], [-117.04656, 33.06986], [-117.04698, 33.07029], [-117.04731, 33.07026], [-117.04765, 33.07057], [-117.04808, 33.07081], [-117.0489, 33.07108], [-117.0484, 33.0721], [-117.04609, 33.07141], [-117.04559, 33.07145], [-117.04311, 33.07185], [-117.04282, 33.07192], [-117.04218, 33.07216], [-117.03988, 33.07309], [-117.0393, 33.0733], [-117.03849, 33.07364], [-117.03832, 33.07374], [-117.03798, 33.07398], [-117.03586, 33.07557], [-117.03566, 33.0758], [-117.03504, 33.07661], [-117.0352, 33.0767], [-117.03512, 33.07682], [-117.03516, 33.07693], [-117.03535, 33.07726], [-117.03542, 33.07733], [-117.03554, 33.07738], [-117.0355, 33.07751], [-117.0355, 33.07756], [-117.03553, 33.07762], [-117.03551, 33.07768], [-117.03545, 33.07771], [-117.03541, 33.07778], [-117.03544, 33.07788], [-117.03536, 33.07784], [-117.03526, 33.07784], [-117.03518, 33.07789], [-117.03511, 33.07797], [-117.03508, 33.07809], [-117.03507, 33.07821], [-117.03505, 33.07826], [-117.03505, 33.07835], [-117.03507, 33.07853], [-117.03511, 33.07866], [-117.03518, 33.0788], [-117.0353, 33.07897], [-117.03551, 33.07909], [-117.03671, 33.07938], [-117.03669, 33.07955], [-117.0364, 33.07966], [-117.03621, 33.07981], [-117.03613, 33.0799], [-117.03606, 33.08003], [-117.03598, 33.0803], [-117.03592, 33.0806], [-117.0359, 33.0807], [-117.03591, 33.08082], [-117.03588, 33.08115], [-117.03592, 33.08134], [-117.03598, 33.08151], [-117.03611, 33.08165], [-117.03607, 33.08182], [-117.03605, 33.08195], [-117.03595, 33.08188], [-117.03581, 33.08194], [-117.03566, 33.08205], [-117.03559, 33.08214], [-117.03554, 33.08223], [-117.03551, 33.08249], [-117.03552, 33.08265], [-117.03545, 33.08273], [-117.03542, 33.08286], [-117.03536, 33.08295], [-117.03533, 33.08304], [-117.03534, 33.0831], [-117.03539, 33.08318], [-117.03548, 33.08323], [-117.03519, 33.0833], [-117.03482, 33.08344], [-117.03475, 33.08342], [-117.03467, 33.08325], [-117.03454, 33.08311], [-117.03444, 33.08303], [-117.03422, 33.08293], [-117.03405, 33.08289], [-117.03387, 33.08288], [-117.03335, 33.08297], [-117.03322, 33.08303], [-117.0332, 33.08306], [-117.03271, 33.08334], [-117.03236, 33.08361], [-117.03172, 33.08418], [-117.03152, 33.08445], [-117.03139, 33.0848], [-117.0313, 33.08498], [-117.03127, 33.08518], [-117.03084, 33.08578], [-117.03053, 33.08602], [-117.03046, 33.0863], [-117.03055, 33.0865], [-117.03028, 33.08685], [-117.03019, 33.08718], [-117.03027, 33.08737], [-117.0305, 33.08756], [-117.03043, 33.08769], [-117.03023, 33.08768], [-117.03001, 33.08774], [-117.02998, 33.08767], [-117.03006, 33.08758], [-117.03001, 33.08742], [-117.02979, 33.08737], [-117.02966, 33.08696], [-117.02952, 33.08681], [-117.02916, 33.0867], [-117.02892, 33.08655], [-117.02873, 33.08647], [-117.02874, 33.08631], [-117.02848, 33.086], [-117.02844, 33.08585], [-117.02831, 33.08574], [-117.02899, 33.08572], [-117.02925, 33.08569], [-117.02957, 33.08556], [-117.02979, 33.08542], [-117.03139, 33.08398], [-117.03158, 33.08379], [-117.03169, 33.08363], [-117.03178, 33.08349], [-117.03207, 33.08293], [-117.03247, 33.08224], [-117.03246, 33.08223], [-117.03215, 33.08223], [-117.03207, 33.08235], [-117.03131, 33.08381], [-117.03044, 33.08458], [-117.02963, 33.08533], [-117.02935, 33.08548], [-117.02901, 33.08556], [-117.02709, 33.08556], [-117.02673, 33.08561], [-117.0266, 33.08559], [-117.02638, 33.08541], [-117.02638, 33.08503], [-117.0261, 33.08468], [-117.02623, 33.08433], [-117.02624, 33.08403], [-117.02618, 33.08386], [-117.02608, 33.08387], [-117.02551, 33.08449], [-117.02538, 33.08494], [-117.02522, 33.08509], [-117.02595, 33.08277], [-117.02682, 33.08186], [-117.02721, 33.08219], [-117.02802, 33.08213], [-117.02841, 33.08182], [-117.02851, 33.08092], [-117.03037, 33.0801], [-117.0322, 33.07908], [-117.03352, 33.07734], [-117.03439, 33.07544], [-117.03481, 33.0738], [-117.03515, 33.07233], [-117.03469, 33.07098], [-117.03403, 33.06897], [-117.03427, 33.06795], [-117.03566, 33.06463], [-117.0371, 33.06203], [-117.03735, 33.06144], [-117.03801, 33.06062], [-117.03923, 33.06013], [-117.04084, 33.0588], [-117.04282, 33.05782], [-117.04736, 33.05696], [-117.05139, 33.05688], [-117.05425, 33.05741], [-117.05782, 33.05908], [-117.05859, 33.05956]]], [[[-117.06694, 33.05289], [-117.06691, 33.05291], [-117.06677, 33.05292], [-117.06622, 33.05292], [-117.0659, 33.05294], [-117.06563, 33.053], [-117.06537, 33.05315], [-117.06499, 33.05345], [-117.06476, 33.05359], [-117.06456, 33.05368], [-117.06416, 33.05379], [-117.06221, 33.05389], [-117.06179, 33.0539], [-117.06119, 33.05386], [-117.06016, 33.05373], [-117.05927, 33.05359], [-117.05868, 33.0535], [-117.0581, 33.05337], [-117.05782, 33.05328], [-117.05745, 33.05312], [-117.05767, 33.05277], [-117.05793, 33.05268], [-117.05823, 33.05251], [-117.05831, 33.05226], [-117.05831, 33.05219], [-117.05819, 33.05207], [-117.0583, 33.05195], [-117.0583, 33.05177], [-117.05823, 33.05162], [-117.05834, 33.05158], [-117.05873, 33.05165], [-117.05897, 33.05159], [-117.05916, 33.0514], [-117.05926, 33.05112], [-117.05928, 33.05101], [-117.05946, 33.05074], [-117.05944, 33.05067], [-117.05962, 33.05044], [-117.05968, 33.05029], [-117.05968, 33.05012], [-117.05961, 33.05], [-117.0597, 33.0499], [-117.05974, 33.04936], [-117.05962, 33.0492], [-117.05972, 33.04909], [-117.05976, 33.0488], [-117.05964, 33.04865], [-117.05965, 33.04848], [-117.05958, 33.0481], [-117.05946, 33.04772], [-117.05929, 33.04755], [-117.05954, 33.04765], [-117.05968, 33.04775], [-117.05988, 33.04804], [-117.05987, 33.04825], [-117.05992, 33.04837], [-117.06015, 33.04848], [-117.06015, 33.0487], [-117.06023, 33.04891], [-117.06032, 33.04896], [-117.06035, 33.04912], [-117.06051, 33.04918], [-117.0604, 33.04926], [-117.06044, 33.04972], [-117.06061, 33.05026], [-117.06082, 33.05075], [-117.06091, 33.05092], [-117.061, 33.051], [-117.06095, 33.05113], [-117.06101, 33.05129], [-117.0614, 33.05154], [-117.06145, 33.05169], [-117.0616, 33.05194], [-117.06213, 33.05231], [-117.0627, 33.05257], [-117.06307, 33.05289], [-117.06388, 33.05308], [-117.06427, 33.0531], [-117.06452, 33.05306], [-117.06477, 33.05297], [-117.06496, 33.05285], [-117.06536, 33.05234], [-117.0655, 33.05227], [-117.06584, 33.05222], [-117.06627, 33.05225], [-117.06644, 33.05202], [-117.06694, 33.05289]]]]}	No Public Access 3	47724	San Pasqual Valley Agricultural and Open Space Preserve	31512	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sdrp.org/wordpress/	San Diego 4	3061.554	San Pasqual Valley Agricultural and OSP	Local Conservation Area 4	2
9993	9993	9992	{"type": "Polygon", "coordinates": [[[-117.00987, 32.55768], [-117.00557, 32.5576], [-117.00555, 32.56025], [-117.00128, 32.56018], [-117.00126, 32.55751], [-116.99834, 32.55745], [-116.99769, 32.55743], [-116.99699, 32.55743], [-116.99699, 32.55385], [-116.99614, 32.55382], [-116.99588, 32.55353], [-116.99536, 32.55264], [-116.99513, 32.55248], [-116.99481, 32.55243], [-116.99449, 32.55257], [-116.99356, 32.55323], [-116.993, 32.55322], [-116.99287, 32.55313], [-116.99284, 32.55268], [-116.99337, 32.55212], [-116.99346, 32.55187], [-116.99337, 32.55162], [-116.99317, 32.55135], [-116.9927, 32.55115], [-116.99269, 32.55005], [-116.99912, 32.55022], [-116.99914, 32.55328], [-116.99985, 32.5533], [-116.99986, 32.55391], [-117.00986, 32.55413], [-117.00985, 32.55619], [-117.00987, 32.55768]]]}	No Public Access 3	47971	Otay Mitigation Site	32285	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	200.028	Otay Mitigation Site	Local Other or Unknown 14	4
10000	10000	9999	{"type": "Polygon", "coordinates": [[[-117.00123, 32.56466], [-117.00121, 32.56728], [-117.00107, 32.56728], [-117.00106, 32.56732], [-117.00068, 32.56736], [-117.00055, 32.56745], [-117.00053, 32.56778], [-117.00042, 32.56807], [-116.99905, 32.56804], [-116.99908, 32.56463], [-117.00123, 32.56466]]]}	No Public Access 3	47970	Otay Mesa Open Space	32281	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	17.649	Otay Mesa OS	Local Recreation Area 3	4
10005	10005	10004	{"type": "Polygon", "coordinates": [[[-117.13531, 32.80963], [-117.13296, 32.80967], [-117.13295, 32.80886], [-117.13279, 32.80885], [-117.13274, 32.80882], [-117.13263, 32.8087], [-117.13257, 32.80854], [-117.13257, 32.80843], [-117.13265, 32.80791], [-117.13264, 32.80786], [-117.1326, 32.8078], [-117.13254, 32.80778], [-117.13225, 32.80775], [-117.13215, 32.80763], [-117.13295, 32.80762], [-117.13296, 32.80837], [-117.13529, 32.80833], [-117.13531, 32.80963]]]}	No Public Access 3	47974	City of San Diego Open Space	32304	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	9.034	City of San Diego OS	Local Recreation Area 3	4
15451	15451	15450	{"type": "Polygon", "coordinates": [[[-117.10104, 32.96786], [-117.0991, 32.9694], [-117.09768, 32.96813], [-117.0991, 32.96695], [-117.0996, 32.96659], [-117.10104, 32.96786]]]}	No Public Access 3	46721	Penasquitos Village Neighborhood Park	30267	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	12.044	Penasquitos Village Neighborhood Park	Local Park 2	4
16087	16087	16086	{"type": "MultiPolygon", "coordinates": [[[[-116.90152, 33.10587], [-116.89724, 33.10587], [-116.89719, 33.10206], [-116.89513, 33.10205], [-116.89508, 33.10392], [-116.89076, 33.10399], [-116.89074, 33.10215], [-116.89295, 33.10209], [-116.89298, 33.09483], [-116.89275, 33.08392], [-116.90146, 33.08384], [-116.90148, 33.08369], [-116.90146, 33.08771], [-116.89987, 33.08735], [-116.8997, 33.08734], [-116.89919, 33.08738], [-116.89898, 33.08738], [-116.89802, 33.08726], [-116.89789, 33.08727], [-116.89777, 33.0873], [-116.89716, 33.08761], [-116.89689, 33.08767], [-116.89679, 33.08771], [-116.8967, 33.08775], [-116.89665, 33.08781], [-116.89661, 33.08793], [-116.89663, 33.08808], [-116.89657, 33.08829], [-116.89633, 33.08876], [-116.89605, 33.08912], [-116.89595, 33.08934], [-116.89596, 33.08943], [-116.89612, 33.08973], [-116.89632, 33.08999], [-116.89646, 33.09033], [-116.89664, 33.09052], [-116.8967, 33.09062], [-116.89672, 33.09068], [-116.89672, 33.09073], [-116.89656, 33.09103], [-116.89643, 33.09145], [-116.89626, 33.09176], [-116.896, 33.09212], [-116.89594, 33.09225], [-116.89588, 33.09244], [-116.89584, 33.09273], [-116.89577, 33.09306], [-116.89575, 33.09322], [-116.89565, 33.0938], [-116.89555, 33.09451], [-116.8955, 33.09464], [-116.89534, 33.09481], [-116.8955, 33.09482], [-116.8956, 33.09471], [-116.89567, 33.0946], [-116.89578, 33.09376], [-116.89588, 33.09326], [-116.89589, 33.09313], [-116.89607, 33.09227], [-116.89614, 33.09212], [-116.89637, 33.09182], [-116.89654, 33.09153], [-116.89666, 33.09113], [-116.89684, 33.09077], [-116.89685, 33.09067], [-116.89684, 33.09059], [-116.89674, 33.09046], [-116.89664, 33.09036], [-116.89658, 33.09028], [-116.89643, 33.08994], [-116.89626, 33.08971], [-116.89609, 33.0894], [-116.89609, 33.08935], [-116.89617, 33.08916], [-116.89644, 33.08879], [-116.89669, 33.08833], [-116.89675, 33.08817], [-116.89675, 33.0879], [-116.89678, 33.08784], [-116.89693, 33.08777], [-116.89718, 33.08773], [-116.89783, 33.0874], [-116.89791, 33.08737], [-116.89801, 33.08737], [-116.89902, 33.08748], [-116.89923, 33.08748], [-116.89969, 33.08745], [-116.89986, 33.08746], [-116.90146, 33.08783], [-116.90149, 33.09135], [-116.90152, 33.10587]]], [[[-116.91016, 33.11349], [-116.90585, 33.11346], [-116.90585, 33.12475], [-116.89299, 33.12481], [-116.89298, 33.12095], [-116.90158, 33.12097], [-116.90154, 33.11025], [-116.91014, 33.11012], [-116.91016, 33.11349]]]]}	No Public Access 3	47726	San Pasqual Trails Open Space	31514	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2	https://www.sandiego.gov/park-and-recreation/parks/osp/sanpasqual	San Diego 4	738.003	San Pasqual Trails OS	Local Recreation Area 3	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]);