units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
57 rows where COUNTY = 4 and MNG_AGENCY = 42 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, YR_EST, GAP_STS
DES_TP 14
- Local Other or Unknown 21
- Local Park 19
- Local Recreation Area 6
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 57
MNG_AGENCY 1
- Encinitas, City of · 57 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
104 | 104 | 103 | {"type": "MultiPolygon", "coordinates": [[[[-117.28007, 33.05439], [-117.27998, 33.05619], [-117.27973, 33.05623], [-117.27961, 33.05627], [-117.27947, 33.05637], [-117.27933, 33.05643], [-117.27924, 33.05645], [-117.27918, 33.05644], [-117.27916, 33.05641], [-117.27907, 33.05602], [-117.279, 33.05546], [-117.279, 33.05499], [-117.27903, 33.05437], [-117.28007, 33.05439]]], [[[-117.28063, 33.05635], [-117.28056, 33.05752], [-117.28062, 33.05796], [-117.27972, 33.05795], [-117.27929, 33.05682], [-117.27923, 33.05664], [-117.27929, 33.0566], [-117.27948, 33.05654], [-117.27971, 33.0564], [-117.27986, 33.05635], [-117.28063, 33.05635]]]]} | Open Access 1 | 288 | Encinitas Ranch Community Use Site | 18665 | 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 | 9.497 | Encinitas Ranch Community Use Site | None 12 | |||
266 | 266 | 265 | {"type": "Polygon", "coordinates": [[[-117.28081, 33.05885], [-117.28072, 33.06063], [-117.27954, 33.06063], [-117.27953, 33.06014], [-117.27857, 33.06014], [-117.27858, 33.05993], [-117.27819, 33.05883], [-117.28081, 33.05885]]]} | Open Access 1 | 744 | Quail Gardens Undeveloped Park | 24040 | 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 | 9.379 | Quail Gardens Undeveloped Park | 0 | Local Park 2 | 4 | |
604 | 604 | 603 | {"type": "Polygon", "coordinates": [[[-117.28533, 33.07516], [-117.2853, 33.07521], [-117.28527, 33.07522], [-117.28497, 33.07519], [-117.28477, 33.07514], [-117.28457, 33.07503], [-117.28437, 33.07495], [-117.28396, 33.07485], [-117.28367, 33.07484], [-117.28329, 33.07488], [-117.28306, 33.07494], [-117.28302, 33.07497], [-117.28297, 33.07497], [-117.2828, 33.07505], [-117.28249, 33.07525], [-117.28238, 33.07536], [-117.28222, 33.07554], [-117.28212, 33.07569], [-117.28206, 33.07584], [-117.28172, 33.07682], [-117.28167, 33.07691], [-117.28158, 33.07705], [-117.28148, 33.07716], [-117.2814, 33.07724], [-117.28127, 33.07733], [-117.2805, 33.07234], [-117.28049, 33.07122], [-117.2805, 33.07054], [-117.28494, 33.07056], [-117.28494, 33.07238], [-117.28533, 33.07516]]]} | Open Access 1 | 2084 | Indian Head Canyon | 20201 | 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 | 55.677 | Indian Head Canyon | 0 | Local Recreation Area 3 | 4 | |
1921 | 1921 | 1920 | {"type": "Polygon", "coordinates": [[[-117.25318, 33.05161], [-117.253, 33.05162], [-117.25266, 33.05167], [-117.25237, 33.05103], [-117.2519, 33.05104], [-117.2519, 33.05092], [-117.25227, 33.05079], [-117.24994, 33.04553], [-117.25052, 33.04565], [-117.25318, 33.05161]]]} | Open Access 1 | 14888 | Undeveloped Community Park | 26652 | 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 | 8.458 | Undeveloped Community Park | 0 | Local Park 2 | 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 | ||
4932 | 4932 | 4931 | {"type": "Polygon", "coordinates": [[[-117.25556, 33.02003], [-117.25123, 33.02002], [-117.25123, 33.0188], [-117.25221, 33.01809], [-117.2555, 33.01812], [-117.25556, 33.02003]]]} | Open Access 1 | 730 | San Elijo Lagoon Ecological Reserve | 24879 | 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 | 20.255 | San Elijo Lagoon ER | 1983 | Local Conservation Area 4 | 2 | |
7621 | 7621 | 7620 | {"type": "Polygon", "coordinates": [[[-117.28518, 33.02562], [-117.28529, 33.02578], [-117.28529, 33.02582], [-117.28512, 33.0259], [-117.28506, 33.02592], [-117.28492, 33.02592], [-117.28455, 33.02589], [-117.28394, 33.02578], [-117.28407, 33.02539], [-117.28421, 33.02491], [-117.28411, 33.02487], [-117.28368, 33.02416], [-117.2841, 33.02397], [-117.28416, 33.02397], [-117.28518, 33.02562]]]} | Restricted Access 2 | 47635 | George Berkich Park | 31614 | 2412 | Cardiff School District 875 | Special District 4 | School District 14 | http://cardiffschools.com/ | Special District 4 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 3.697 | George Berkich Park | 0 | Local Park 2 | 4 | |
8379 | 8379 | 8378 | {"type": "Polygon", "coordinates": [[[-117.29408, 33.07322], [-117.2938, 33.07333], [-117.29357, 33.07338], [-117.2929, 33.0736], [-117.29243, 33.0734], [-117.29146, 33.07338], [-117.29145, 33.07319], [-117.29139, 33.07298], [-117.29241, 33.07275], [-117.29248, 33.07295], [-117.29268, 33.07316], [-117.29396, 33.07285], [-117.29408, 33.07322]]]} | Open Access 1 | 12973 | Standard Pacific Park Site | 25781 | 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.163 | Standard Pacific Park Site | 0 | Local Park 2 | 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 | |
13506 | 13506 | 13505 | {"type": "Polygon", "coordinates": [[[-117.2513, 33.02732], [-117.25128, 33.02869], [-117.25071, 33.02869], [-117.25069, 33.02867], [-117.25069, 33.02864], [-117.25071, 33.02859], [-117.25095, 33.02831], [-117.25101, 33.0282], [-117.25103, 33.02811], [-117.251, 33.02801], [-117.25087, 33.02786], [-117.25082, 33.02777], [-117.25085, 33.02767], [-117.25083, 33.02746], [-117.25096, 33.0274], [-117.2513, 33.02732]]]} | Open Access 1 | 35789 | Encinitas holding 11 | 18646 | 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.401 | Encinitas holding 11 | 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]);