units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
70 rows where ACCESS_TYP = 1, COUNTY = 4 and DES_TP = 14 sorted by AGNCY_NAME
This data as json, copyable, CSV (advanced)
MNG_AGENCY 7
MNG_AG_TYP 1
- City Agency 70
DES_TP 1
- Local Other or Unknown · 70 ✖
ACCESS_TYP 1
- Open Access · 70 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4469 | 4469 | 4468 | {"type": "Polygon", "coordinates": [[[-117.06249, 32.75242], [-117.06211, 32.75251], [-117.06106, 32.75279], [-117.06087, 32.75234], [-117.0624, 32.75219], [-117.06249, 32.75242]]]} | Open Access 1 | 94 | Unnamed site - San Diego, City of | 28704 | 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.367 | 0 | Local Other or Unknown 14 | 4 | ||
4533 | 4533 | 4532 | {"type": "Polygon", "coordinates": [[[-117.20364, 32.79871], [-117.20168, 32.7987], [-117.2017, 32.79679], [-117.20364, 32.79871], [-117.20364, 32.79871]]]} | Open Access 1 | 18603 | Unnamed site - San Diego, City of | 28704 | 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 | 4.797 | 0 | Local Other or Unknown 14 | 4 | ||
4538 | 4538 | 4537 | {"type": "Polygon", "coordinates": [[[-117.05883, 32.72129], [-117.05851, 32.72137], [-117.05826, 32.72054], [-117.05856, 32.72042], [-117.05883, 32.72129]]]} | Open Access 1 | 19925 | Unnamed site - San Diego, City of | 28704 | 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.747 | 0 | Local Other or Unknown 14 | 4 | ||
4539 | 4539 | 4538 | {"type": "Polygon", "coordinates": [[[-117.06411, 32.71928], [-117.06404, 32.71934], [-117.06249, 32.71803], [-117.0625, 32.71793], [-117.06411, 32.71928]]]} | Open Access 1 | 19932 | Unnamed site - San Diego, City of | 28704 | 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.466 | 0 | Local Other or Unknown 14 | 4 | ||
5966 | 5966 | 5965 | {"type": "Polygon", "coordinates": [[[-116.99908, 32.56479], [-116.99905, 32.56803], [-116.99907, 32.56804], [-116.99876, 32.56801], [-116.99722, 32.568], [-116.99712, 32.56796], [-116.99709, 32.56789], [-116.99699, 32.56788], [-116.99702, 32.56465], [-116.99704, 32.5646], [-116.99907, 32.56465], [-116.99908, 32.56479]]]} | Open Access 1 | 1051 | Otay Mitigation Site | 23242 | 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.892 | Otay Mitigation Site | 0 | Local Other or Unknown 14 | 4 | |
7775 | 7775 | 7774 | {"type": "Polygon", "coordinates": [[[-117.16118, 32.95396], [-117.15486, 32.95409], [-117.15484, 32.9525], [-117.16113, 32.95233], [-117.16118, 32.95396]]]} | Open Access 1 | 47658 | North City Mitigation | 31400 | 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 | 26.041 | North City Mitigation | 0 | Local Other or Unknown 14 | 4 | |
10489 | 10489 | 10488 | {"type": "MultiPolygon", "coordinates": [[[[-117.12268, 32.69609], [-117.12268, 32.69614], [-117.12249, 32.69637], [-117.12228, 32.69652], [-117.12228, 32.69653], [-117.12235, 32.69653], [-117.12235, 32.6967], [-117.12219, 32.69671], [-117.12219, 32.69676], [-117.12202, 32.69676], [-117.12186, 32.6969], [-117.12186, 32.69698], [-117.12172, 32.69714], [-117.12162, 32.69733], [-117.12157, 32.69751], [-117.12156, 32.69763], [-117.12157, 32.69774], [-117.12147, 32.69775], [-117.12133, 32.6969], [-117.12148, 32.69689], [-117.12178, 32.69653], [-117.12199, 32.69636], [-117.12216, 32.69609], [-117.12268, 32.69609]]], [[[-117.12309, 32.69586], [-117.12232, 32.69587], [-117.12232, 32.69552], [-117.12236, 32.69548], [-117.12309, 32.69548], [-117.12309, 32.69586]]], [[[-117.12309, 32.69542], [-117.12291, 32.69542], [-117.12291, 32.69504], [-117.12308, 32.69505], [-117.12309, 32.69542]]]]} | Open Access 1 | 18586 | Chollas Creek | 17217 | 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 | 2.599 | Chollas Creek | 0 | Local Other or Unknown 14 | 4 | |
6117 | 6117 | 6116 | {"type": "MultiPolygon", "coordinates": [[[[-116.98689, 32.83198], [-116.98676, 32.83215], [-116.98688, 32.83237], [-116.98633, 32.83237], [-116.98582, 32.83156], [-116.98607, 32.83162], [-116.98636, 32.83172], [-116.9866, 32.83182], [-116.98689, 32.83198]]], [[[-116.99272, 32.83496], [-116.99251, 32.8352], [-116.9923, 32.83491], [-116.99218, 32.83479], [-116.99185, 32.83455], [-116.99147, 32.83438], [-116.99132, 32.83434], [-116.991, 32.83429], [-116.99099, 32.8343], [-116.99099, 32.83449], [-116.98958, 32.83452], [-116.98958, 32.8339], [-116.99016, 32.83389], [-116.9907, 32.83397], [-116.99102, 32.83397], [-116.9914, 32.83405], [-116.99156, 32.8341], [-116.99173, 32.83417], [-116.99207, 32.83433], [-116.99246, 32.83464], [-116.99265, 32.83484], [-116.99272, 32.83496]]], [[[-116.99677, 32.83852], [-116.9964, 32.83852], [-116.99615, 32.83825], [-116.99592, 32.83806], [-116.99576, 32.83797], [-116.99506, 32.83768], [-116.99402, 32.83703], [-116.99377, 32.83685], [-116.99347, 32.83648], [-116.99315, 32.83603], [-116.99263, 32.83534], [-116.99283, 32.83511], [-116.99289, 32.83516], [-116.99337, 32.83577], [-116.99379, 32.83635], [-116.99416, 32.83677], [-116.99457, 32.83705], [-116.99512, 32.8374], [-116.99599, 32.83778], [-116.99626, 32.83795], [-116.99647, 32.83814], [-116.99668, 32.83838], [-116.99677, 32.83852]]]]} | Open Access 1 | 1086 | Forrester Creek | 19002 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | San Diego 4 | 8.757 | Forrester Creek | 0 | Local Other or Unknown 14 | 4 | |
4596 | 4596 | 4595 | {"type": "Polygon", "coordinates": [[[-117.28319, 33.04494], [-117.28317, 33.045], [-117.28306, 33.045], [-117.28307, 33.04496], [-117.28304, 33.04495], [-117.28303, 33.04494], [-117.28298, 33.04494], [-117.28297, 33.04495], [-117.28295, 33.04495], [-117.28294, 33.045], [-117.2829, 33.04497], [-117.28291, 33.04454], [-117.28293, 33.04452], [-117.28296, 33.04453], [-117.28319, 33.04492], [-117.28319, 33.04494]]]} | Open Access 1 | 35531 | Unknown park - Encinitas, City of | 28635 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.21 | 0 | Local Other or Unknown 14 | 4 | ||
13416 | 13416 | 13415 | {"type": "Polygon", "coordinates": [[[-117.28517, 33.08411], [-117.28517, 33.08713], [-117.28478, 33.08714], [-117.28429, 33.08718], [-117.28299, 33.08738], [-117.28297, 33.08412], [-117.28517, 33.08411]]]} | Open Access 1 | 35528 | Encinitas holding 29 | 18656 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 17.436 | Encinitas holding 29 | 0 | Local Other or Unknown 14 | 4 | |
13417 | 13417 | 13416 | {"type": "Polygon", "coordinates": [[[-117.28529, 33.07544], [-117.2852, 33.07638], [-117.2851, 33.07638], [-117.28509, 33.07542], [-117.28506, 33.07538], [-117.28525, 33.0754], [-117.28529, 33.07544]]]} | Open Access 1 | 35529 | Encinitas holding 31 | 18657 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.384 | Encinitas holding 31 | 0 | Local Other or Unknown 14 | 4 | |
13419 | 13419 | 13418 | {"type": "Polygon", "coordinates": [[[-117.24702, 33.0564], [-117.24692, 33.05685], [-117.24691, 33.05685], [-117.24689, 33.05683], [-117.2469, 33.05662], [-117.24702, 33.0564]]]} | Open Access 1 | 35537 | Encinitas holding 36 | 18658 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.044 | Encinitas holding 36 | 0 | Local Other or Unknown 14 | 4 | |
13420 | 13420 | 13419 | {"type": "Polygon", "coordinates": [[[-117.25554, 33.03255], [-117.25419, 33.03259], [-117.25425, 33.03238], [-117.25435, 33.0322], [-117.25409, 33.03203], [-117.25412, 33.03199], [-117.25439, 33.03213], [-117.25449, 33.03195], [-117.25455, 33.03175], [-117.25454, 33.03156], [-117.2545, 33.03127], [-117.25453, 33.03099], [-117.25448, 33.03085], [-117.2544, 33.03057], [-117.25438, 33.03034], [-117.25454, 33.03041], [-117.25463, 33.03047], [-117.25474, 33.03058], [-117.25485, 33.03073], [-117.25491, 33.03087], [-117.25502, 33.03152], [-117.25508, 33.03166], [-117.25522, 33.0318], [-117.2553, 33.03184], [-117.25546, 33.03189], [-117.25554, 33.03189], [-117.25554, 33.03255]]]} | Open Access 1 | 35538 | Encinitas holding 12 | 18647 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 3.895 | Encinitas holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13421 | 13421 | 13420 | {"type": "Polygon", "coordinates": [[[-117.25119, 33.02892], [-117.25116, 33.02906], [-117.24968, 33.02909], [-117.24971, 33.02907], [-117.24974, 33.02897], [-117.24991, 33.02881], [-117.24992, 33.02878], [-117.24992, 33.02865], [-117.24995, 33.02859], [-117.25001, 33.02853], [-117.25075, 33.02804], [-117.25081, 33.02804], [-117.25084, 33.02805], [-117.25088, 33.0281], [-117.25089, 33.02815], [-117.25081, 33.02827], [-117.25054, 33.02853], [-117.2505, 33.02861], [-117.25049, 33.02867], [-117.25051, 33.02876], [-117.25055, 33.0288], [-117.25063, 33.02884], [-117.2508, 33.02884], [-117.25102, 33.02881], [-117.25113, 33.02882], [-117.25118, 33.02885], [-117.25119, 33.02892]]]} | Open Access 1 | 35539 | Encinitas holding 47 | 18663 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 1.83 | Encinitas holding 47 | 0 | Local Other or Unknown 14 | 4 | |
13423 | 13423 | 13422 | {"type": "Polygon", "coordinates": [[[-117.25097, 33.02595], [-117.25082, 33.02602], [-117.25066, 33.02604], [-117.25034, 33.02612], [-117.24989, 33.02611], [-117.24982, 33.02614], [-117.24939, 33.02641], [-117.24938, 33.02662], [-117.24941, 33.02672], [-117.24949, 33.02681], [-117.24953, 33.02685], [-117.24963, 33.02688], [-117.24997, 33.02692], [-117.24915, 33.02722], [-117.24916, 33.0291], [-117.24825, 33.02912], [-117.24825, 33.02901], [-117.24853, 33.02901], [-117.24852, 33.02874], [-117.24826, 33.02831], [-117.24789, 33.0283], [-117.24788, 33.02811], [-117.24859, 33.02811], [-117.24858, 33.02777], [-117.24844, 33.02778], [-117.24805, 33.0273], [-117.2485, 33.02721], [-117.24848, 33.02711], [-117.2487, 33.02709], [-117.2487, 33.02682], [-117.24777, 33.02649], [-117.24794, 33.02643], [-117.24793, 33.02623], [-117.24817, 33.02577], [-117.24817, 33.02571], [-117.24807, 33.02552], [-117.24913, 33.02551], [-117.24913, 33.02413], [-117.24932, 33.02414], [-117.24939, 33.02417], [-117.24926, 33.02429], [-117.24928, 33.02435], [-117.24945, 33.02447], [-117.24962, 33.02456], [-117.24966, 33.02456], [-117.24973, 33.02449], [-117.24978, 33.02449], [-117.24999, 33.02457], [-117.25006, 33.02469], [-117.25007, 33.02474], [-117.2501, 33.02514], [-117.25033, 33.02515], [-117.25038, 33.02475], [-117.25075, 33.02474], [-117.25077, 33.02476], [-117.25076, 33.02488], [-117.25073, 33.02495], [-117.25067, 33.02503], [-117.25052, 33.02515], [-117.2505, 33.0252], [-117.25053, 33.02524], [-117.25088, 33.02547], [-117.25094, 33.02554], [-117.25097, 33.02574], [-117.25097, 33.02595]]]} | Open Access 1 | 35540 | Encinitas holding 41 | 18661 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 15.302 | Encinitas holding 41 | 0 | Local Other or Unknown 14 | 4 | |
13424 | 13424 | 13423 | {"type": "Polygon", "coordinates": [[[-117.25303, 33.03045], [-117.25301, 33.031], [-117.25251, 33.03099], [-117.25221, 33.03096], [-117.25225, 33.0308], [-117.25224, 33.03072], [-117.25259, 33.0307], [-117.25258, 33.03044], [-117.25299, 33.03041], [-117.25303, 33.03045]]]} | Open Access 1 | 35543 | Encinitas holding 40 | 18660 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.88 | Encinitas holding 40 | 0 | Local Other or Unknown 14 | 4 | |
13427 | 13427 | 13426 | {"type": "Polygon", "coordinates": [[[-117.25343, 33.02661], [-117.25336, 33.02656], [-117.2531, 33.02647], [-117.25296, 33.02647], [-117.25283, 33.0265], [-117.25274, 33.02655], [-117.25272, 33.0266], [-117.25209, 33.0266], [-117.25196, 33.02644], [-117.25185, 33.02624], [-117.25185, 33.02612], [-117.25194, 33.02595], [-117.25198, 33.02582], [-117.25197, 33.02575], [-117.25188, 33.02556], [-117.25181, 33.02549], [-117.2517, 33.02546], [-117.25128, 33.02546], [-117.25121, 33.02543], [-117.25113, 33.02537], [-117.25112, 33.02528], [-117.25114, 33.02519], [-117.25114, 33.02506], [-117.2511, 33.02499], [-117.25105, 33.02485], [-117.25097, 33.02475], [-117.25096, 33.02471], [-117.25104, 33.02463], [-117.25107, 33.02457], [-117.25116, 33.02445], [-117.25121, 33.02433], [-117.25121, 33.02425], [-117.25113, 33.02409], [-117.25124, 33.02378], [-117.25119, 33.02362], [-117.25121, 33.02353], [-117.25123, 33.02351], [-117.25127, 33.0235], [-117.25127, 33.02542], [-117.25342, 33.02542], [-117.25343, 33.02661]]]} | Open Access 1 | 35544 | Encinitas holding 37 | 18659 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 5.06 | Encinitas holding 37 | 0 | Local Other or Unknown 14 | 4 | |
13428 | 13428 | 13427 | {"type": "Polygon", "coordinates": [[[-117.25127, 33.02194], [-117.25127, 33.02345], [-117.25103, 33.02344], [-117.2509, 33.02335], [-117.2507, 33.0233], [-117.25061, 33.02326], [-117.25046, 33.02314], [-117.25039, 33.02299], [-117.25041, 33.02262], [-117.25034, 33.02248], [-117.25025, 33.02238], [-117.2504, 33.02227], [-117.25071, 33.0221], [-117.25109, 33.02196], [-117.25123, 33.02192], [-117.25126, 33.02192], [-117.25127, 33.02194]]]} | Open Access 1 | 35546 | Encinitas holding 42 | 18662 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 2.872 | Encinitas holding 42 | 0 | Local Other or Unknown 14 | 4 | |
13429 | 13429 | 13428 | {"type": "Polygon", "coordinates": [[[-117.26321, 33.06745], [-117.26292, 33.06743], [-117.26291, 33.06741], [-117.26254, 33.06741], [-117.26246, 33.06737], [-117.26249, 33.06552], [-117.26252, 33.0653], [-117.26255, 33.06527], [-117.26304, 33.06525], [-117.26303, 33.06536], [-117.26294, 33.06558], [-117.26288, 33.06689], [-117.26294, 33.0671], [-117.26302, 33.06728], [-117.26306, 33.06732], [-117.26317, 33.06736], [-117.26321, 33.06745]]]} | Open Access 1 | 35548 | Encinitas holding 1 | 18645 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 2.584 | Encinitas holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13504 | 13504 | 13503 | {"type": "Polygon", "coordinates": [[[-117.2641, 33.06086], [-117.26391, 33.06092], [-117.26379, 33.06074], [-117.26377, 33.06074], [-117.26372, 33.06078], [-117.26368, 33.06086], [-117.26368, 33.06107], [-117.26343, 33.06107], [-117.26332, 33.06135], [-117.26335, 33.06149], [-117.2635, 33.06179], [-117.26317, 33.06286], [-117.2632, 33.0629], [-117.2632, 33.06304], [-117.26311, 33.0635], [-117.26312, 33.06388], [-117.2631, 33.064], [-117.2631, 33.0642], [-117.26314, 33.06445], [-117.26328, 33.06493], [-117.26308, 33.06497], [-117.26266, 33.06499], [-117.2626, 33.06493], [-117.26263, 33.06455], [-117.2629, 33.0626], [-117.26296, 33.06202], [-117.26296, 33.05866], [-117.26298, 33.05863], [-117.26301, 33.05861], [-117.26329, 33.05861], [-117.26358, 33.05865], [-117.26386, 33.05873], [-117.26404, 33.05881], [-117.26382, 33.05976], [-117.2641, 33.06086]]]} | Open Access 1 | 35817 | Encinitas holding 20 | 18651 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 10.231 | Encinitas holding 20 | 0 | Local Other or Unknown 14 | 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]);