units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
66 rows where MNG_AGENCY = 22 and MNG_AG_TYP = 2 sorted by DES_TP descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST, GAP_STS
DES_TP 16
- Local Recreation Area 26
- Local Park 21
- Local Other or Unknown 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
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency · 66 ✖
MNG_AGENCY 1
- San Luis Obispo, City of · 66 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10578 | 10578 | 10577 | {"type": "Polygon", "coordinates": [[[-120.70209, 35.27008], [-120.70097, 35.27111], [-120.69991, 35.27204], [-120.69691, 35.27003], [-120.69534, 35.26892], [-120.69334, 35.26759], [-120.69446, 35.26668], [-120.69602, 35.26799], [-120.69736, 35.26693], [-120.69751, 35.26701], [-120.69768, 35.26715], [-120.69782, 35.26731], [-120.698, 35.26746], [-120.69866, 35.26782], [-120.699, 35.26729], [-120.69983, 35.26729], [-120.69963, 35.2678], [-120.69988, 35.268], [-120.7002, 35.26858], [-120.70054, 35.26884], [-120.70101, 35.26886], [-120.70209, 35.27008]]]} | Open Access 1 | 18837 | Priolo-Martin Park - Laguna Lake | 24011 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 50.992 | Priolo-Martin Park - Laguna Lake | 0 | None 930 | ||
9661 | 9661 | 9660 | {"type": "MultiPolygon", "coordinates": [[[[-120.64348, 35.26058], [-120.64327, 35.26067], [-120.6434, 35.26084], [-120.64332, 35.26088], [-120.64332, 35.26132], [-120.64289, 35.26132], [-120.64288, 35.26051], [-120.64329, 35.26034], [-120.64348, 35.26058]]], [[[-120.64408, 35.26132], [-120.64356, 35.26132], [-120.64355, 35.26077], [-120.64362, 35.26075], [-120.64408, 35.26132]]]]} | Open Access 1 | 16290 | Future Ocutt/Bullock Alignment | 19157 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1.469 | Future Ocutt/Bullock Alignment | 0 | None 825 | ||
9387 | 9387 | 9386 | {"type": "Polygon", "coordinates": [[[-120.66218, 35.26785], [-120.66213, 35.26785], [-120.66206, 35.26787], [-120.66202, 35.26791], [-120.662, 35.26796], [-120.66032, 35.268], [-120.6603, 35.26772], [-120.65908, 35.26754], [-120.65941, 35.26724], [-120.65983, 35.26735], [-120.66207, 35.26735], [-120.66208, 35.26705], [-120.66214, 35.26705], [-120.66214, 35.26735], [-120.66218, 35.26785]]]} | Open Access 1 | 15744 | Exposition Park (1) | 18777 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 3.823 | Exposition Park (1) | None 772 | |||
7998 | 7998 | 7997 | {"type": "MultiPolygon", "coordinates": [[[[-120.63572, 35.24436], [-120.63555, 35.24438], [-120.63528, 35.24446], [-120.63511, 35.24448], [-120.63487, 35.24442], [-120.6347, 35.24431], [-120.63467, 35.24433], [-120.63416, 35.24422], [-120.6339, 35.24428], [-120.63382, 35.24434], [-120.63378, 35.2444], [-120.633, 35.24412], [-120.63374, 35.24413], [-120.63401, 35.24404], [-120.6346, 35.24405], [-120.63476, 35.2441], [-120.63508, 35.24423], [-120.63534, 35.244], [-120.63564, 35.244], [-120.63567, 35.24401], [-120.63569, 35.24404], [-120.63572, 35.24436]]], [[[-120.63656, 35.24442], [-120.63639, 35.24445], [-120.63612, 35.24445], [-120.63596, 35.24441], [-120.63591, 35.24438], [-120.63589, 35.24417], [-120.63613, 35.24422], [-120.63638, 35.24416], [-120.63656, 35.24442]]]]} | Open Access 1 | 11114 | Creek dedication | 17762 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1.954 | Creek dedication | None 667 | |||
7801 | 7801 | 7800 | {"type": "Polygon", "coordinates": [[[-120.66948, 35.27794], [-120.66942, 35.27805], [-120.66924, 35.27827], [-120.66871, 35.27798], [-120.66901, 35.27765], [-120.66948, 35.27794]]]} | Open Access 1 | 12682 | Dana Adobe | 17907 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.62 | Dana Adobe | None 649 | |||
6240 | 6240 | 6239 | {"type": "Polygon", "coordinates": [[[-120.65048, 35.27232], [-120.65015, 35.27225], [-120.65007, 35.27225], [-120.64975, 35.27174], [-120.65003, 35.2716], [-120.65004, 35.27181], [-120.65022, 35.27208], [-120.65028, 35.27205], [-120.65048, 35.27232]]]} | Open Access 1 | 1314 | Terrace Hill Water Tank | 26258 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.442 | Terrace Hill Water Tank | None 505 | |||
6230 | 6230 | 6229 | {"type": "Polygon", "coordinates": [[[-120.65301, 35.27273], [-120.65302, 35.27286], [-120.65292, 35.27335], [-120.65296, 35.27363], [-120.65296, 35.27399], [-120.65274, 35.27434], [-120.65179, 35.27497], [-120.65146, 35.27512], [-120.65131, 35.27486], [-120.6508, 35.27482], [-120.65055, 35.27474], [-120.65017, 35.27428], [-120.6495, 35.27385], [-120.6491, 35.27349], [-120.64888, 35.27307], [-120.64864, 35.27283], [-120.64972, 35.27171], [-120.65008, 35.27225], [-120.65014, 35.27225], [-120.65047, 35.27231], [-120.65047, 35.2723], [-120.65028, 35.27205], [-120.65068, 35.27182], [-120.65079, 35.27194], [-120.65086, 35.27196], [-120.65118, 35.27228], [-120.65214, 35.27228], [-120.65229, 35.27221], [-120.65242, 35.27234], [-120.65242, 35.27242], [-120.65246, 35.27246], [-120.65286, 35.27262], [-120.65301, 35.27273]]]} | Open Access 1 | 1310 | Terrace Hill | 26257 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 22.731 | Terrace Hill | None 503 | |||
2747 | 2747 | 2746 | {"type": "Polygon", "coordinates": [[[-120.66515, 35.26775], [-120.66469, 35.26776], [-120.66468, 35.26753], [-120.66465, 35.26734], [-120.66515, 35.26732], [-120.66515, 35.26775]]]} | Open Access 1 | 18428 | Part of Exposition Park (3) | 23484 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.506 | Part of Exposition Park (3) | None 228 | |||
2079 | 2079 | 2078 | {"type": "Polygon", "coordinates": [[[-120.66448, 35.26777], [-120.66415, 35.26777], [-120.66395, 35.26795], [-120.66233, 35.26798], [-120.66229, 35.26789], [-120.66218, 35.26785], [-120.66214, 35.26735], [-120.66359, 35.26735], [-120.6644, 35.26719], [-120.66447, 35.26747], [-120.66448, 35.26777]]]} | Open Access 1 | 15748 | Exposition Park (2) | 18778 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 3.478 | Exposition Park (2) | None 166 | |||
1631 | 1631 | 1630 | {"type": "Polygon", "coordinates": [[[-120.68013, 35.26112], [-120.67995, 35.26126], [-120.67904, 35.26056], [-120.67918, 35.26044], [-120.68006, 35.26111], [-120.68013, 35.26112]]]} | Open Access 1 | 12445 | Dalidio | 17897 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.516 | Dalidio | None 131 | |||
4580 | 4580 | 4579 | {"type": "Polygon", "coordinates": [[[-120.65368, 35.25981], [-120.65355, 35.25973], [-120.65336, 35.25938], [-120.65327, 35.25852], [-120.65304, 35.25837], [-120.65297, 35.25826], [-120.65294, 35.25809], [-120.653, 35.2577], [-120.65339, 35.25769], [-120.65368, 35.25981]]]} | Open Access 1 | 35313 | Unnamed site - San Luis Obispo, City of | 28661 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1.637 | 0 | Local Other or Unknown 14 | 4 | ||
4581 | 4581 | 4580 | {"type": "Polygon", "coordinates": [[[-120.68305, 35.25007], [-120.68298, 35.25011], [-120.68277, 35.25009], [-120.68274, 35.25012], [-120.68269, 35.25007], [-120.68285, 35.24982], [-120.68305, 35.25007]]]} | Open Access 1 | 35336 | Unnamed site - San Luis Obispo, City of | 28661 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.137 | 0 | Local Other or Unknown 14 | 4 | ||
4656 | 4656 | 4655 | {"type": "Polygon", "coordinates": [[[-120.65374, 35.27663], [-120.65364, 35.27676], [-120.65352, 35.27662], [-120.65365, 35.27654], [-120.65374, 35.27663]]]} | Open Access 1 | 36580 | Unnamed site - San Luis Obispo, City of | 28661 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.06 | 0 | Local Other or Unknown 14 | 4 | ||
5516 | 5516 | 5515 | {"type": "MultiPolygon", "coordinates": [[[[-120.69549, 35.26127], [-120.69548, 35.26128], [-120.69541, 35.26128], [-120.69525, 35.26141], [-120.69521, 35.26138], [-120.69516, 35.26142], [-120.69512, 35.26139], [-120.69469, 35.26174], [-120.69444, 35.2619], [-120.69428, 35.26211], [-120.69453, 35.26232], [-120.69428, 35.26244], [-120.69411, 35.2625], [-120.69402, 35.26226], [-120.69374, 35.26222], [-120.69335, 35.26231], [-120.69301, 35.26246], [-120.6928, 35.26259], [-120.69256, 35.2624], [-120.6928, 35.26223], [-120.6933, 35.26193], [-120.69392, 35.26169], [-120.69501, 35.26115], [-120.69505, 35.2609], [-120.69549, 35.26127]]], [[[-120.70148, 35.25778], [-120.70136, 35.25781], [-120.70118, 35.25801], [-120.7008, 35.25828], [-120.70044, 35.25829], [-120.69958, 35.25844], [-120.69948, 35.2583], [-120.69956, 35.2583], [-120.69968, 35.25822], [-120.69974, 35.25827], [-120.70009, 35.25821], [-120.70024, 35.25809], [-120.70039, 35.25812], [-120.70056, 35.25786], [-120.7006, 35.25786], [-120.70047, 35.25809], [-120.70048, 35.25812], [-120.7008, 35.25812], [-120.70097, 35.25799], [-120.70118, 35.25774], [-120.70127, 35.25768], [-120.70133, 35.25754], [-120.70146, 35.25757], [-120.70144, 35.25765], [-120.70148, 35.25778]]]]} | Open Access 1 | 18808 | Prefumo Creek | 23980 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 4.164 | Prefumo Creek | 0 | Local Other or Unknown 14 | 4 | |
13335 | 13335 | 13334 | {"type": "Polygon", "coordinates": [[[-120.67302, 35.2668], [-120.67283, 35.26847], [-120.6727, 35.26922], [-120.67258, 35.26972], [-120.67213, 35.26967], [-120.67165, 35.26873], [-120.6726, 35.26791], [-120.67217, 35.26714], [-120.67277, 35.26669], [-120.67286, 35.26668], [-120.67294, 35.2667], [-120.67299, 35.26674], [-120.67302, 35.2668]]]} | Open Access 1 | 35412 | San Luis Obispo holding 1 | 24934 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 5.051 | San Luis Obispo holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13894 | 13894 | 13893 | {"type": "Polygon", "coordinates": [[[-120.63621, 35.2961], [-120.63574, 35.29718], [-120.63513, 35.29735], [-120.63415, 35.29709], [-120.63289, 35.29573], [-120.63328, 35.29565], [-120.6337, 35.2956], [-120.63476, 35.29554], [-120.63607, 35.29587], [-120.63621, 35.2961]]]} | Open Access 1 | 36499 | San Luis Obispo holding 6 | 24935 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 9.747 | San Luis Obispo holding 6 | 0 | Local Other or Unknown 14 | 4 | |
72 | 72 | 71 | {"type": "Polygon", "coordinates": [[[-120.63097, 35.24673], [-120.63073, 35.24675], [-120.63063, 35.24673], [-120.63043, 35.24674], [-120.6303, 35.24677], [-120.63025, 35.24681], [-120.63016, 35.24683], [-120.63008, 35.24682], [-120.62998, 35.24677], [-120.62994, 35.2467], [-120.62993, 35.24662], [-120.63, 35.24651], [-120.63004, 35.24648], [-120.63007, 35.24644], [-120.63012, 35.24628], [-120.6301, 35.24623], [-120.63011, 35.24615], [-120.63017, 35.2461], [-120.63019, 35.24606], [-120.63018, 35.24601], [-120.63013, 35.24596], [-120.63051, 35.24609], [-120.63065, 35.24616], [-120.63074, 35.24623], [-120.63083, 35.24633], [-120.63089, 35.24643], [-120.63095, 35.2466], [-120.63097, 35.24673]]]} | Open Access 1 | 167 | Rodriguez Adobe | 24553 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1.39 | Rodriguez Adobe | None 10 | |||
40 | 40 | 39 | {"type": "Polygon", "coordinates": [[[-120.6535, 35.26278], [-120.65337, 35.26287], [-120.65316, 35.26262], [-120.6533, 35.26255], [-120.6535, 35.26278]]]} | Open Access 1 | 127 | Rockview Right-of-Way | 24536 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.123 | Rockview Right-of-Way | None 7 | |||
9899 | 9899 | 9898 | {"type": "Polygon", "coordinates": [[[-120.72276, 35.25881], [-120.71907, 35.26446], [-120.7187, 35.26439], [-120.7184, 35.26437], [-120.7182, 35.26433], [-120.71795, 35.26437], [-120.71781, 35.26438], [-120.7174, 35.26431], [-120.717, 35.26417], [-120.71696, 35.26413], [-120.71694, 35.26405], [-120.71691, 35.26402], [-120.71641, 35.26375], [-120.71619, 35.26367], [-120.71597, 35.26365], [-120.71528, 35.26367], [-120.71505, 35.26365], [-120.71472, 35.26357], [-120.71461, 35.26352], [-120.71453, 35.26346], [-120.71449, 35.26339], [-120.7144, 35.26319], [-120.71426, 35.26307], [-120.71422, 35.26297], [-120.71416, 35.26293], [-120.71394, 35.26283], [-120.71384, 35.2628], [-120.71307, 35.26274], [-120.71294, 35.26272], [-120.71281, 35.26268], [-120.71241, 35.26246], [-120.71226, 35.26241], [-120.71206, 35.26239], [-120.71124, 35.2624], [-120.711, 35.26243], [-120.7107, 35.26239], [-120.71031, 35.26247], [-120.71011, 35.26249], [-120.7099, 35.26247], [-120.70968, 35.26243], [-120.70916, 35.26224], [-120.70862, 35.26202], [-120.70911, 35.26118], [-120.70911, 35.26117], [-120.70799, 35.26061], [-120.70769, 35.2605], [-120.70728, 35.2604], [-120.70668, 35.26032], [-120.70363, 35.25931], [-120.71036, 35.25391], [-120.71036, 35.25389], [-120.70875, 35.2538], [-120.70699, 35.25338], [-120.70607, 35.25308], [-120.70512, 35.25297], [-120.70459, 35.25516], [-120.70331, 35.25593], [-120.70128, 35.25617], [-120.70009, 35.25634], [-120.69821, 35.25504], [-120.6978, 35.2545], [-120.69644, 35.25431], [-120.69612, 35.25393], [-120.69564, 35.25421], [-120.69543, 35.25404], [-120.69481, 35.25328], [-120.69227, 35.25114], [-120.69221, 35.25083], [-120.69199, 35.25009], [-120.69178, 35.24991], [-120.69144, 35.24969], [-120.6908, 35.24962], [-120.69007, 35.24946], [-120.68975, 35.2495], [-120.6889, 35.24852], [-120.68574, 35.25036], [-120.68455, 35.24895], [-120.68459, 35.2489], [-120.68344, 35.24726], [-120.6832, 35.24588], [-120.68342, 35.24564], [-120.68334, 35.24548], [-120.68704, 35.24348], [-120.69259, 35.2393], [-120.6958, 35.24208], [-120.70089, 35.2396], [-120.70424, 35.24254], [-120.70425, 35.24253], [-120.70441, 35.24041], [-120.71387, 35.24015], [-120.71391, 35.24413], [-120.7063, 35.24433], [-120.70629, 35.24434], [-120.72276, 35.25881]]]} | Open Access 1 | 16977 | Irish Hills Natural Reserve | 20233 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1138.739 | Irish Hills Natural Reserve | 0 | Local Conservation Area 4 | 2 | |
147 | 147 | 146 | {"type": "Polygon", "coordinates": [[[-120.67593, 35.28455], [-120.67267, 35.28527], [-120.67227, 35.28492], [-120.67159, 35.28308], [-120.67151, 35.28307], [-120.67145, 35.27945], [-120.67281, 35.27944], [-120.67281, 35.27961], [-120.67591, 35.28176], [-120.67593, 35.28455]]]} | Open Access 1 | 383 | San Luis Mountain Open Space | 24932 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 49.053 | San Luis Mtn. OS | 0 | 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]);