units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
50 rows where MNG_AG_TYP = 16 sorted by AGNCY_NAME
This data as json, copyable, CSV (advanced)
DES_TP 13
- Local Recreation Area 17
- Local Other or Unknown 2
- Local Park 1
- Local Conservation Area 1
- Local Resource Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 10
- Littlerock Creek Irrigation District 13
- Nevada Irrigation District 5
- El Dorado Irrigation District 4
- Modesto Irrigation District 2
- Merced Irrigation District 1
- Kaweah Delta Water Conservation District 1
- Santa Fe Irrigation District 1
- Turlock Irrigation District 1
- Madera Irrigation District 1
- Browns Valley Irrigation District 1
ACCESS_TYP 4
MNG_AG_TYP 1
- Irrigation District · 30 ✖
AGNCY_LEV 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7761 | 7761 | 7760 | {"type": "Polygon", "coordinates": [[[-120.31895, 37.52502], [-120.31852, 37.52527], [-120.31803, 37.52517], [-120.31679, 37.525], [-120.31626, 37.5249], [-120.31569, 37.52483], [-120.31548, 37.52484], [-120.31468, 37.52498], [-120.31412, 37.52505], [-120.31379, 37.52505], [-120.31337, 37.52502], [-120.31309, 37.52495], [-120.31281, 37.52486], [-120.312, 37.52441], [-120.31077, 37.52366], [-120.30206, 37.5239], [-120.29728, 37.52385], [-120.29724, 37.52346], [-120.29606, 37.52324], [-120.2955, 37.52344], [-120.29558, 37.5236], [-120.29312, 37.52441], [-120.29203, 37.52461], [-120.29178, 37.52469], [-120.29147, 37.52483], [-120.29125, 37.52499], [-120.29044, 37.52582], [-120.2902, 37.52596], [-120.29006, 37.52585], [-120.2899, 37.52596], [-120.28979, 37.52594], [-120.28916, 37.52642], [-120.28887, 37.52661], [-120.28841, 37.52716], [-120.28844, 37.52726], [-120.28717, 37.5286], [-120.28707, 37.5286], [-120.28673, 37.52917], [-120.28658, 37.52955], [-120.28637, 37.53062], [-120.28636, 37.53126], [-120.28607, 37.53165], [-120.28549, 37.53229], [-120.28538, 37.53254], [-120.2853, 37.53301], [-120.28518, 37.53352], [-120.28513, 37.53367], [-120.28479, 37.53413], [-120.2846, 37.53431], [-120.28419, 37.53456], [-120.28375, 37.5348], [-120.28334, 37.5352], [-120.28311, 37.5355], [-120.28292, 37.53581], [-120.28275, 37.53658], [-120.28, 37.53667], [-120.28098, 37.53383], [-120.28102, 37.5312], [-120.28117, 37.52988], [-120.28182, 37.53], [-120.28321, 37.52909], [-120.28389, 37.52827], [-120.28464, 37.52741], [-120.28466, 37.5271], [-120.28501, 37.52659], [-120.28531, 37.52646], [-120.28587, 37.52577], [-120.28469, 37.52417], [-120.28479, 37.52371], [-120.28398, 37.52336], [-120.28302, 37.52404], [-120.28336, 37.52307], [-120.28422, 37.52264], [-120.28565, 37.52313], [-120.28597, 37.52384], [-120.28673, 37.52421], [-120.28765, 37.52339], [-120.28696, 37.52268], [-120.28806, 37.5226], [-120.28906, 37.52155], [-120.28839, 37.52087], [-120.2886, 37.52031], [-120.29, 37.52076], [-120.29197, 37.51909], [-120.29196, 37.51836], [-120.29121, 37.51803], [-120.29114, 37.51784], [-120.28969, 37.51818], [-120.28899, 37.51815], [-120.28959, 37.51765], [-120.29126, 37.51697], [-120.2917, 37.51558], [-120.29153, 37.51491], [-120.29221, 37.51322], [-120.29221, 37.51299], [-120.29285, 37.51207], [-120.29369, 37.51202], [-120.29339, 37.513], [-120.29377, 37.51341], [-120.29308, 37.51455], [-120.29252, 37.51477], [-120.29252, 37.51478], [-120.29303, 37.51534], [-120.29384, 37.51508], [-120.29389, 37.51435], [-120.29444, 37.51458], [-120.29468, 37.51399], [-120.29519, 37.51393], [-120.29506, 37.51514], [-120.29598, 37.51471], [-120.29534, 37.51566], [-120.2955, 37.51645], [-120.29641, 37.51672], [-120.29786, 37.51661], [-120.29865, 37.51672], [-120.29904, 37.51678], [-120.29933, 37.51653], [-120.30248, 37.51675], [-120.30326, 37.51675], [-120.30351, 37.51636], [-120.30361, 37.51564], [-120.30444, 37.51585], [-120.30482, 37.51623], [-120.30501, 37.51679], [-120.3066, 37.51626], [-120.30794, 37.51748], [-120.30832, 37.51674], [-120.309, 37.51656], [-120.31143, 37.51626], [-120.31199, 37.51621], [-120.31464, 37.51928], [-120.31649, 37.52163], [-120.31743, 37.52286], [-120.31532, 37.52453], [-120.31532, 37.52454], [-120.31543, 37.52453], [-120.31652, 37.52463], [-120.31895, 37.52502]]]} | Restricted Access 2 | 48467 | Lake McClure | 33177 | 2240 | Merced Irrigation District 631 | Special District 4 | Irrigation District 17 | http://www.lakemcclure.com/ | Special District 4 | 2240 | Merced Irrigation District 620 | Special District 4 | Irrigation District 16 | http://www.lakemcclure.com/ | Mariposa 31 | 626.209 | Lake McClure | None 643 | ||
3551 | 3551 | 3550 | {"type": "Polygon", "coordinates": [[[-117.98918, 34.51959], [-117.98917, 34.52033], [-117.98818, 34.52034], [-117.98817, 34.51959], [-117.98918, 34.51959]]]} | No Public Access 3 | 12453 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 1.865 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
5568 | 5568 | 5567 | {"type": "Polygon", "coordinates": [[[-117.98819, 34.51876], [-117.98807, 34.51874], [-117.98806, 34.51756], [-117.98818, 34.51757], [-117.98819, 34.51876]]]} | No Public Access 3 | 12452 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.356 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
7357 | 7357 | 7356 | {"type": "MultiPolygon", "coordinates": [[[[-118.02763, 34.50795], [-118.02763, 34.50822], [-118.02325, 34.50828], [-118.02326, 34.508], [-118.02763, 34.50795]]], [[[-118.02654, 34.50915], [-118.02654, 34.50999], [-118.02544, 34.51001], [-118.02544, 34.51093], [-118.02324, 34.51097], [-118.02324, 34.51373], [-118.00514, 34.51378], [-118.00508, 34.51374], [-118.00416, 34.51343], [-118.00236, 34.51343], [-118.00235, 34.51063], [-118.00105, 34.51062], [-118.00105, 34.51057], [-118.00564, 34.51018], [-118.00565, 34.51015], [-118.01886, 34.51011], [-118.02324, 34.51004], [-118.02325, 34.50919], [-118.02654, 34.50915]], [[-118.00565, 34.51222], [-118.00566, 34.51221], [-118.00566, 34.51197], [-118.00481, 34.51198], [-118.00482, 34.51199], [-118.00511, 34.51206], [-118.00565, 34.51222]]], [[[-118.00572, 34.52102], [-118.0025, 34.52103], [-118.0025, 34.51922], [-118.00233, 34.51921], [-118.00232, 34.51436], [-118.00261, 34.51433], [-118.00446, 34.51493], [-118.00467, 34.51559], [-118.00568, 34.516], [-118.00572, 34.52102]]], [[[-117.9969, 34.52998], [-117.9969, 34.52998], [-117.9963, 34.531], [-117.9963, 34.5301], [-117.99657, 34.53009], [-117.99657, 34.52938], [-117.9969, 34.52938], [-117.9969, 34.52998]]], [[[-117.98816, 34.54299], [-117.98815, 34.54466], [-117.98593, 34.54468], [-117.98697, 34.54299], [-117.98816, 34.54299]]], [[[-117.97925, 34.55142], [-117.97924, 34.55397], [-117.9775, 34.55397], [-117.97784, 34.55335], [-117.97825, 34.55334], [-117.97826, 34.55196], [-117.97892, 34.55197], [-117.97893, 34.55142], [-117.97925, 34.55142]]], [[[-117.97703, 34.55398], [-117.97702, 34.55468], [-117.97674, 34.55468], [-117.97674, 34.55398], [-117.97703, 34.55398]]], [[[-117.97762, 34.55779], [-117.9766, 34.55961], [-117.97615, 34.55961], [-117.97612, 34.55779], [-117.97762, 34.55779]]], [[[-117.98274, 34.56873], [-117.98274, 34.57055], [-117.98057, 34.57055], [-117.98056, 34.56872], [-117.98274, 34.56873]]], [[[-117.9937, 34.58516], [-117.99369, 34.58699], [-117.99143, 34.58701], [-117.99144, 34.58518], [-117.9937, 34.58516]]]]} | No Public Access 3 | 6714 | Little Rock Wash | 21356 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 293.656 | Little Rock Wash | 0 | None 609 | ||
7827 | 7827 | 7826 | {"type": "Polygon", "coordinates": [[[-117.97928, 34.51891], [-117.97908, 34.51905], [-117.97879, 34.51923], [-117.97862, 34.51929], [-117.97826, 34.51953], [-117.97804, 34.51962], [-117.97781, 34.51968], [-117.97733, 34.51992], [-117.97708, 34.51998], [-117.97707, 34.51981], [-117.97662, 34.5198], [-117.97662, 34.52021], [-117.97538, 34.5207], [-117.97538, 34.52106], [-117.97504, 34.52106], [-117.97505, 34.52051], [-117.97508, 34.5205], [-117.97507, 34.52017], [-117.97516, 34.51847], [-117.97592, 34.5181], [-117.97708, 34.51764], [-117.97708, 34.51974], [-117.97726, 34.51971], [-117.97739, 34.51962], [-117.9777, 34.51949], [-117.97794, 34.51942], [-117.9781, 34.51934], [-117.97834, 34.51917], [-117.97866, 34.51903], [-117.97892, 34.51888], [-117.97927, 34.5186], [-117.97928, 34.51891]]]} | No Public Access 3 | 12441 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 13.15 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
9003 | 9003 | 9002 | {"type": "Polygon", "coordinates": [[[-117.98817, 34.54292], [-117.98816, 34.54299], [-117.98697, 34.54299], [-117.98701, 34.54293], [-117.98817, 34.54292]]]} | No Public Access 3 | 12439 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.2 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
10063 | 10063 | 10062 | {"type": "Polygon", "coordinates": [[[-118.01442, 34.52901], [-118.01285, 34.529], [-118.0123, 34.52821], [-118.01441, 34.52821], [-118.01442, 34.52901]]]} | No Public Access 3 | 12436 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 3.676 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
12277 | 12277 | 12276 | {"type": "Polygon", "coordinates": [[[-118.01951, 34.5391], [-118.01951, 34.54001], [-118.01887, 34.54001], [-118.01886, 34.5391], [-118.01951, 34.5391]]]} | No Public Access 3 | 12440 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 1.461 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
12281 | 12281 | 12280 | {"type": "MultiPolygon", "coordinates": [[[[-118.00126, 34.51466], [-118.00113, 34.51482], [-117.99999, 34.51573], [-117.99964, 34.51601], [-117.99931, 34.51622], [-117.999, 34.51647], [-117.99793, 34.51699], [-117.99728, 34.51737], [-117.99687, 34.51738], [-117.99687, 34.51762], [-117.99619, 34.51803], [-117.99619, 34.51812], [-117.99539, 34.51812], [-117.99567, 34.51801], [-117.9959, 34.51784], [-117.99623, 34.51736], [-117.99694, 34.51726], [-117.99844, 34.5166], [-118.00119, 34.51443], [-118.00126, 34.51442], [-118.00126, 34.51466]]], [[[-117.99538, 34.51812], [-117.99538, 34.51838], [-117.99482, 34.51855], [-117.99466, 34.51856], [-117.99466, 34.51864], [-117.99422, 34.51864], [-117.99421, 34.51856], [-117.99351, 34.51857], [-117.99421, 34.51848], [-117.99422, 34.51836], [-117.99455, 34.51835], [-117.99471, 34.51832], [-117.99538, 34.51812]]]]} | No Public Access 3 | 12437 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 5.22 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
12287 | 12287 | 12286 | {"type": "Polygon", "coordinates": [[[-117.94266, 34.53928], [-117.94156, 34.53928], [-117.94155, 34.53746], [-117.94265, 34.53746], [-117.94266, 34.53928]]]} | No Public Access 3 | 12438 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 5.019 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
12431 | 12431 | 12430 | {"type": "Polygon", "coordinates": [[[-117.90871, 34.53918], [-117.90871, 34.54011], [-117.9086, 34.54081], [-117.90748, 34.54082], [-117.90748, 34.53918], [-117.90871, 34.53918]]]} | No Public Access 3 | 12448 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 4.981 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
12432 | 12432 | 12431 | {"type": "Polygon", "coordinates": [[[-117.976, 34.50296], [-117.97599, 34.50478], [-117.9749, 34.50478], [-117.97491, 34.50296], [-117.976, 34.50296]]]} | No Public Access 3 | 12449 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 5.018 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
12439 | 12439 | 12438 | {"type": "Polygon", "coordinates": [[[-117.96331, 34.54305], [-117.96331, 34.54385], [-117.96252, 34.54385], [-117.96253, 34.54305], [-117.96331, 34.54305]]]} | No Public Access 3 | 12450 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 1.576 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
12482 | 12482 | 12481 | {"type": "Polygon", "coordinates": [[[-117.99345, 34.51866], [-117.9926, 34.51867], [-117.9926, 34.51859], [-117.99345, 34.51858], [-117.99345, 34.51866]]]} | No Public Access 3 | 12451 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.173 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
3801 | 3801 | 3800 | {"type": "Polygon", "coordinates": [[[-119.00087, 36.48581], [-119.00073, 36.50019], [-118.9888, 36.50036], [-118.98849, 36.5075], [-118.98438, 36.50756], [-118.98422, 36.51497], [-118.95056, 36.51478], [-118.95017, 36.48653], [-118.95887, 36.48654], [-118.95883, 36.48389], [-118.95011, 36.48385], [-118.95008, 36.48653], [-118.94129, 36.48652], [-118.94106, 36.47196], [-118.95863, 36.47197], [-118.95841, 36.45769], [-118.96306, 36.45867], [-118.96313, 36.46251], [-118.97128, 36.46422], [-118.97135, 36.47198], [-118.9759, 36.47199], [-118.97604, 36.48655], [-118.98065, 36.48656], [-118.98063, 36.48423], [-118.98403, 36.48421], [-118.99295, 36.4837], [-118.99301, 36.48616], [-119.00087, 36.48581]]]} | No Public Access 3 | 35098 | Mitigation Preserve | 22327 | 2302 | Kaweah Delta Water Conservation District 685 | Special District 4 | Irrigation District 17 | http://www.kdwcd.com/ | Special District 4 | 2302 | Kaweah Delta Water Conservation District 676 | Special District 4 | Irrigation District 16 | Tulare 29 | 4599.64 | Mitigation Preserve | 0 | Local Conservation Area 4 | 2 | |
4243 | 4243 | 4242 | {"type": "Polygon", "coordinates": [[[-117.1979, 33.04077], [-117.19691, 33.04146], [-117.19687, 33.04157], [-117.1967, 33.04154], [-117.19651, 33.04157], [-117.1957, 33.04195], [-117.19532, 33.04206], [-117.19501, 33.04209], [-117.19426, 33.04208], [-117.19394, 33.0421], [-117.19364, 33.04218], [-117.19207, 33.04311], [-117.19167, 33.0434], [-117.19148, 33.04349], [-117.19123, 33.04353], [-117.18912, 33.04351], [-117.18921, 33.04308], [-117.18939, 33.04261], [-117.18944, 33.04243], [-117.18945, 33.04226], [-117.1894, 33.0419], [-117.18942, 33.04177], [-117.18946, 33.04165], [-117.1895, 33.04157], [-117.19034, 33.04037], [-117.19045, 33.04017], [-117.19048, 33.04001], [-117.19048, 33.0398], [-117.19043, 33.03942], [-117.19038, 33.03925], [-117.19029, 33.03911], [-117.19018, 33.039], [-117.19005, 33.03891], [-117.18986, 33.0388], [-117.18981, 33.03875], [-117.18978, 33.0387], [-117.18977, 33.03864], [-117.18979, 33.03853], [-117.18991, 33.03839], [-117.19003, 33.03828], [-117.19028, 33.0381], [-117.19187, 33.03732], [-117.1922, 33.03718], [-117.19291, 33.0369], [-117.19326, 33.0367], [-117.19356, 33.03648], [-117.19382, 33.0362], [-117.19396, 33.036], [-117.19401, 33.03592], [-117.19403, 33.03581], [-117.19403, 33.03562], [-117.19395, 33.03525], [-117.19394, 33.03517], [-117.19396, 33.03508], [-117.19399, 33.03501], [-117.19404, 33.03495], [-117.1941, 33.03491], [-117.19417, 33.03491], [-117.19421, 33.03495], [-117.19432, 33.03563], [-117.19438, 33.03587], [-117.19445, 33.03604], [-117.19458, 33.0362], [-117.19475, 33.03633], [-117.19521, 33.03655], [-117.19544, 33.0367], [-117.19561, 33.03687], [-117.19579, 33.03712], [-117.19594, 33.0373], [-117.19613, 33.03745], [-117.19651, 33.03765], [-117.19669, 33.03769], [-117.19684, 33.03771], [-117.19678, 33.03841], [-117.19692, 33.03855], [-117.19732, 33.03888], [-117.19715, 33.04072], [-117.1979, 33.04077]]]} | Unknown Access 4 | 45146 | San Dieguito Reservoir Watershed | 24868 | 2322 | Santa Fe Irrigation District 738 | Special District 4 | Irrigation District 17 | http://www.sfidwater.org/ | Special District 4 | 2322 | Santa Fe Irrigation District 722 | Special District 4 | Irrigation District 16 | San Diego 4 | 102.408 | San Dieguito Reservoir Watershed | 0 | Local Resource Management Area 83 | 3 | |
11893 | 11893 | 11892 | {"type": "Polygon", "coordinates": [[[-120.0809, 38.84539], [-120.0794, 38.84631], [-120.07878, 38.84651], [-120.07824, 38.84641], [-120.07751, 38.84605], [-120.07698, 38.84606], [-120.07673, 38.84595], [-120.07609, 38.84541], [-120.07605, 38.84536], [-120.07617, 38.84536], [-120.07617, 38.84534], [-120.07589, 38.84498], [-120.07573, 38.84494], [-120.07558, 38.84502], [-120.07542, 38.84503], [-120.07526, 38.84494], [-120.075, 38.84462], [-120.07483, 38.84437], [-120.07463, 38.84428], [-120.07425, 38.84435], [-120.07407, 38.84449], [-120.07393, 38.84448], [-120.07289, 38.84347], [-120.07245, 38.84316], [-120.07216, 38.84289], [-120.0722, 38.84252], [-120.07185, 38.84229], [-120.07145, 38.84215], [-120.07119, 38.84195], [-120.07098, 38.84176], [-120.07086, 38.8417], [-120.07057, 38.84173], [-120.07037, 38.84165], [-120.07029, 38.84146], [-120.07011, 38.84123], [-120.06972, 38.84097], [-120.06954, 38.84082], [-120.06923, 38.84075], [-120.06852, 38.84046], [-120.06834, 38.8405], [-120.06807, 38.84071], [-120.06797, 38.84094], [-120.06794, 38.84169], [-120.06803, 38.84228], [-120.06805, 38.84262], [-120.0679, 38.84305], [-120.06782, 38.84335], [-120.06761, 38.84343], [-120.06723, 38.84336], [-120.06696, 38.84348], [-120.06694, 38.84368], [-120.06669, 38.84377], [-120.06645, 38.8437], [-120.06618, 38.84344], [-120.06593, 38.84345], [-120.06573, 38.84367], [-120.06549, 38.84385], [-120.06515, 38.84398], [-120.06467, 38.8443], [-120.06426, 38.84446], [-120.0636, 38.84447], [-120.06318, 38.8445], [-120.06261, 38.84448], [-120.06207, 38.84424], [-120.06164, 38.84418], [-120.06137, 38.84418], [-120.06084, 38.84388], [-120.06001, 38.84362], [-120.06, 38.84363], [-120.05999, 38.84371], [-120.05978, 38.84372], [-120.05961, 38.84358], [-120.05959, 38.84348], [-120.0587, 38.84307], [-120.05807, 38.84281], [-120.05738, 38.84262], [-120.05676, 38.84251], [-120.05651, 38.8425], [-120.0564, 38.84247], [-120.05612, 38.8423], [-120.05511, 38.84157], [-120.05476, 38.84126], [-120.0542, 38.84072], [-120.05347, 38.84015], [-120.05291, 38.83959], [-120.05267, 38.8394], [-120.05248, 38.83919], [-120.05229, 38.83902], [-120.05211, 38.83868], [-120.05178, 38.83835], [-120.05104, 38.83774], [-120.05039, 38.83729], [-120.04988, 38.83702], [-120.04936, 38.83691], [-120.04896, 38.83688], [-120.04876, 38.83689], [-120.04866, 38.83681], [-120.04823, 38.83661], [-120.04797, 38.83653], [-120.04777, 38.83651], [-120.04735, 38.83643], [-120.04646, 38.83611], [-120.04626, 38.83597], [-120.04601, 38.83584], [-120.04573, 38.83563], [-120.04508, 38.83539], [-120.04484, 38.83534], [-120.04482, 38.83524], [-120.04483, 38.83496], [-120.04492, 38.83477], [-120.04518, 38.83467], [-120.04526, 38.83459], [-120.04539, 38.83439], [-120.04593, 38.83429], [-120.04643, 38.83417], [-120.04757, 38.83421], [-120.04783, 38.83424], [-120.04801, 38.83418], [-120.04871, 38.8342], [-120.04953, 38.83433], [-120.05029, 38.83455], [-120.05112, 38.83466], [-120.05156, 38.83464], [-120.05198, 38.83477], [-120.05238, 38.83487], [-120.05308, 38.83491], [-120.0536, 38.83492], [-120.05386, 38.83495], [-120.05405, 38.83515], [-120.05441, 38.83526], [-120.05471, 38.83528], [-120.05538, 38.83554], [-120.05607, 38.83588], [-120.05657, 38.83616], [-120.05767, 38.8364], [-120.05799, 38.8365], [-120.05839, 38.83701], [-120.06033, 38.83774], [-120.0621, 38.83807], [-120.06219, 38.83807], [-120.06233, 38.83819], [-120.06247, 38.83824], [-120.0625, 38.83826], [-120.06255, 38.83848], [-120.06268, 38.83861], [-120.06308, 38.83878], [-120.06377, 38.83893], [-120.0643, 38.83907], [-120.0648, 38.8391], [-120.06513, 38.83916], [-120.06562, 38.83919], [-120.06596, 38.83926], [-120.06669, 38.83927], [-120.06689, 38.83937], [-120.06841, 38.83997], [-120.0694, 38.84058], [-120.07007, 38.84058], [-120.07046, 38.84047], [-120.07037, 38.84027], [-120.07019, 38.84007], [-120.07043, 38.83989], [-120.07065, 38.83985], [-120.07085, 38.83999], [-120.07103, 38.84003], [-120.07119, 38.84002], [-120.07164, 38.84029], [-120.07192, 38.84037], [-120.0721, 38.84035], [-120.07257, 38.84016], [-120.07279, 38.84017], [-120.07294, 38.84029], [-120.07326, 38.8406], [-120.07379, 38.84124], [-120.07407, 38.84134], [-120.07444, 38.84144], [-120.0746, 38.84173], [-120.07479, 38.84184], [-120.07563, 38.84183], [-120.07619, 38.84185], [-120.07642, 38.84188], [-120.0766, 38.842], [-120.0768, 38.84202], [-120.07718, 38.84194], [-120.07757, 38.84203], [-120.07807, 38.84228], [-120.07849, 38.84217], [-120.0786, 38.84225], [-120.0787, 38.84239], [-120.07874, 38.84253], [-120.07939, 38.84267], [-120.0798, 38.84251], [-120.08035, 38.84306], [-120.08027, 38.84396], [-120.07997, 38.84406], [-120.08006, 38.84433], [-120.07998, 38.84459], [-120.08014, 38.84474], [-120.08045, 38.84485], [-120.08066, 38.84507], [-120.08073, 38.84534], [-120.0809, 38.84539]], [[-120.07582, 38.84282], [-120.07618, 38.84298], [-120.07619, 38.84298], [-120.07621, 38.8429], [-120.07583, 38.84227], [-120.07542, 38.84208], [-120.07549, 38.84236], [-120.07561, 38.84261], [-120.07582, 38.84282]], [[-120.07625, 38.84416], [-120.07655, 38.84427], [-120.07658, 38.84423], [-120.07628, 38.84371], [-120.07609, 38.84353], [-120.07594, 38.84368], [-120.07614, 38.84409], [-120.07625, 38.84416]], [[-120.07674, 38.84419], [-120.07691, 38.84424], [-120.07694, 38.8441], [-120.0769, 38.84382], [-120.07658, 38.84359], [-120.07648, 38.84362], [-120.07674, 38.84419]], [[-120.07668, 38.84476], [-120.07696, 38.84494], [-120.07702, 38.84475], [-120.07678, 38.84447], [-120.07668, 38.84476]], [[-120.0771, 38.84474], [-120.07723, 38.84485], [-120.07743, 38.84474], [-120.07723, 38.84453], [-120.07711, 38.84456], [-120.0771, 38.84474]]]} | Open Access 1 | 24342 | Echo Lake | 3402 | 2220 | El Dorado Irrigation District 890 | Special District 4 | Irrigation District 17 | http://www.eid.org/ | Special District 4 | 2220 | El Dorado Irrigation District 965 | Special District 4 | Irrigation District 16 | El Dorado 34 | 325.47 | Echo Lake | None 1046 | |||
11894 | 11894 | 11893 | {"type": "Polygon", "coordinates": [[[-120.12824, 38.64367], [-120.12745, 38.64502], [-120.12745, 38.64534], [-120.12754, 38.64544], [-120.12754, 38.64592], [-120.12698, 38.64679], [-120.12687, 38.64752], [-120.12602, 38.64905], [-120.12536, 38.64986], [-120.12533, 38.65022], [-120.12477, 38.65066], [-120.12428, 38.65143], [-120.12428, 38.65184], [-120.1244, 38.652], [-120.12469, 38.65274], [-120.12469, 38.65299], [-120.12431, 38.65329], [-120.12408, 38.65434], [-120.12408, 38.65528], [-120.12378, 38.65628], [-120.12355, 38.6566], [-120.12346, 38.65717], [-120.1232, 38.658], [-120.12283, 38.65868], [-120.12326, 38.65908], [-120.1232, 38.65942], [-120.12256, 38.65988], [-120.12233, 38.66033], [-120.12224, 38.66088], [-120.1223, 38.66154], [-120.12277, 38.662], [-120.12312, 38.66212], [-120.12376, 38.6622], [-120.12411, 38.66248], [-120.12513, 38.66278], [-120.12522, 38.66294], [-120.12467, 38.66328], [-120.12353, 38.66442], [-120.12347, 38.66461], [-120.12268, 38.66502], [-120.12184, 38.66626], [-120.12134, 38.66635], [-120.12123, 38.66683], [-120.12169, 38.6671], [-120.12166, 38.66751], [-120.12152, 38.66815], [-120.12073, 38.66866], [-120.11986, 38.6688], [-120.11983, 38.66866], [-120.12044, 38.66824], [-120.12046, 38.66806], [-120.12006, 38.668], [-120.11901, 38.66841], [-120.11857, 38.66877], [-120.11816, 38.66898], [-120.1179, 38.66898], [-120.11746, 38.66875], [-120.11685, 38.66854], [-120.11636, 38.66854], [-120.11617, 38.66864], [-120.11608, 38.66863], [-120.11572, 38.66887], [-120.11496, 38.66925], [-120.11473, 38.66954], [-120.11466, 38.66958], [-120.11437, 38.66997], [-120.11388, 38.67037], [-120.11329, 38.67047], [-120.11325, 38.67044], [-120.1131, 38.66996], [-120.11305, 38.66991], [-120.11335, 38.66935], [-120.11335, 38.66914], [-120.11262, 38.66884], [-120.11213, 38.66853], [-120.11183, 38.668], [-120.11168, 38.66783], [-120.1116, 38.66732], [-120.11127, 38.66715], [-120.11122, 38.66699], [-120.11045, 38.66634], [-120.11029, 38.66607], [-120.11018, 38.66606], [-120.11008, 38.66589], [-120.10967, 38.66576], [-120.10938, 38.66546], [-120.10909, 38.66489], [-120.10908, 38.66444], [-120.10921, 38.6641], [-120.11021, 38.66299], [-120.11085, 38.66285], [-120.11112, 38.66235], [-120.1115, 38.66192], [-120.11177, 38.66178], [-120.11174, 38.66147], [-120.11229, 38.66129], [-120.11209, 38.66013], [-120.11165, 38.65937], [-120.11162, 38.65915], [-120.11186, 38.6589], [-120.112, 38.65775], [-120.11226, 38.65736], [-120.11334, 38.65725], [-120.11372, 38.65745], [-120.11425, 38.65711], [-120.11471, 38.65697], [-120.11541, 38.65702], [-120.11591, 38.65674], [-120.11617, 38.6564], [-120.11635, 38.65462], [-120.11675, 38.65326], [-120.11678, 38.65221], [-120.11766, 38.65082], [-120.11824, 38.65036], [-120.11876, 38.64968], [-120.11961, 38.64919], [-120.12005, 38.64878], [-120.12034, 38.64833], [-120.12127, 38.64762], [-120.12171, 38.64679], [-120.12255, 38.64601], [-120.12319, 38.64583], [-120.1234, 38.64512], [-120.12366, 38.64473], [-120.12378, 38.64416], [-120.12372, 38.64251], [-120.12404, 38.64203], [-120.12433, 38.64205], [-120.12497, 38.64185], [-120.1257, 38.6418], [-120.12603, 38.64187], [-120.12716, 38.64223], [-120.12763, 38.64262], [-120.12809, 38.64322], [-120.12824, 38.64367]], [[-120.12168, 38.64997], [-120.12142, 38.6499], [-120.12023, 38.64997], [-120.11996, 38.6502], [-120.11958, 38.65141], [-120.11947, 38.65212], [-120.11944, 38.65342], [-120.11958, 38.65409], [-120.12005, 38.65514], [-120.12069, 38.6556], [-120.12104, 38.65569], [-120.12148, 38.6556], [-120.12189, 38.6551], [-120.12203, 38.65475], [-120.1223, 38.65436], [-120.1225, 38.65292], [-120.12291, 38.65148], [-120.1227, 38.65077], [-120.12215, 38.65022], [-120.12168, 38.64997]]]} | Open Access 1 | 24343 | Silver Lake | 3403 | 2220 | El Dorado Irrigation District 890 | Special District 4 | Irrigation District 17 | http://www.eid.org/ | Special District 4 | 2220 | El Dorado Irrigation District 965 | Special District 4 | Irrigation District 16 | Amador 52 | 514.385 | Silver Lake | None 1047 | |||
12170 | 12170 | 12169 | {"type": "Polygon", "coordinates": [[[-120.57384, 38.71826], [-120.5733, 38.72189], [-120.5698, 38.72419], [-120.56747, 38.72602], [-120.56457, 38.72921], [-120.56281, 38.73059], [-120.56045, 38.73016], [-120.55627, 38.72702], [-120.5538, 38.72719], [-120.55358, 38.72781], [-120.54746, 38.72982], [-120.54154, 38.73847], [-120.53874, 38.7385], [-120.53515, 38.7367], [-120.53225, 38.7381], [-120.53164, 38.73675], [-120.5363, 38.73263], [-120.53715, 38.73196], [-120.53761, 38.73195], [-120.53823, 38.73095], [-120.5389, 38.73017], [-120.54058, 38.72807], [-120.54176, 38.72674], [-120.54208, 38.72632], [-120.54364, 38.72659], [-120.54526, 38.72648], [-120.54575, 38.72586], [-120.5472, 38.72468], [-120.54849, 38.72304], [-120.54862, 38.72231], [-120.54895, 38.72116], [-120.54914, 38.72023], [-120.55071, 38.71823], [-120.553, 38.71668], [-120.55496, 38.71563], [-120.55641, 38.71528], [-120.55882, 38.71503], [-120.5609, 38.71485], [-120.56223, 38.716], [-120.57147, 38.71737], [-120.57384, 38.71826]]]} | Open Access 1 | 25276 | Jenkinson Lake | 13813 | 2220 | El Dorado Irrigation District 890 | Special District 4 | Irrigation District 17 | http://www.eid.org/ | Special District 4 | 2220 | El Dorado Irrigation District 965 | Special District 4 | Irrigation District 16 | http://www.edcgov.us/Living/Stories/Sly_Park/Jenkinson_Lake.aspx | El Dorado 34 | 903.136 | Jenkinson Lake | None 1062 | ||
12254 | 12254 | 12253 | {"type": "Polygon", "coordinates": [[[-120.0648, 38.70268], [-120.06474, 38.70307], [-120.06469, 38.70323], [-120.06428, 38.7033], [-120.06177, 38.70296], [-120.06147, 38.70282], [-120.0604, 38.70314], [-120.05964, 38.70323], [-120.05733, 38.70323], [-120.05572, 38.70307], [-120.05298, 38.70321], [-120.05202, 38.70337], [-120.05132, 38.70318], [-120.05071, 38.7032], [-120.05053, 38.70337], [-120.05056, 38.70439], [-120.05035, 38.70476], [-120.0496, 38.70495], [-120.04965, 38.70517], [-120.05006, 38.70554], [-120.05006, 38.70588], [-120.04927, 38.70748], [-120.04854, 38.70828], [-120.04822, 38.70833], [-120.04557, 38.70723], [-120.04484, 38.70673], [-120.04405, 38.70572], [-120.04373, 38.70503], [-120.04349, 38.70485], [-120.04323, 38.70478], [-120.04404, 38.70478], [-120.04404, 38.70476], [-120.04264, 38.70463], [-120.04238, 38.70457], [-120.04194, 38.70431], [-120.04101, 38.70398], [-120.0407, 38.70379], [-120.04049, 38.70358], [-120.04034, 38.70335], [-120.04015, 38.70313], [-120.0399, 38.70301], [-120.03989, 38.70324], [-120.039, 38.70261], [-120.03725, 38.70162], [-120.03618, 38.70114], [-120.03634, 38.70113], [-120.03599, 38.7009], [-120.03577, 38.70081], [-120.03562, 38.7007], [-120.03544, 38.70041], [-120.03533, 38.70029], [-120.03512, 38.70019], [-120.0351, 38.70024], [-120.03445, 38.7], [-120.03395, 38.69954], [-120.03384, 38.69924], [-120.03349, 38.69886], [-120.03343, 38.6986], [-120.03314, 38.69828], [-120.03317, 38.6975], [-120.03327, 38.6975], [-120.03332, 38.69738], [-120.03334, 38.69715], [-120.03332, 38.697], [-120.03337, 38.69696], [-120.03353, 38.697], [-120.03359, 38.697], [-120.03368, 38.69696], [-120.03374, 38.69691], [-120.0338, 38.69667], [-120.0338, 38.69645], [-120.03369, 38.69637], [-120.03367, 38.69632], [-120.03374, 38.69617], [-120.03375, 38.6961], [-120.03372, 38.69603], [-120.03375, 38.6959], [-120.03382, 38.6959], [-120.03388, 38.69589], [-120.03391, 38.69584], [-120.03391, 38.69579], [-120.03385, 38.69571], [-120.03361, 38.69561], [-120.03353, 38.69549], [-120.03352, 38.69544], [-120.03359, 38.6953], [-120.03357, 38.69522], [-120.0335, 38.69511], [-120.03351, 38.69506], [-120.03353, 38.695], [-120.03359, 38.69498], [-120.03368, 38.69501], [-120.03376, 38.69507], [-120.03386, 38.69521], [-120.03391, 38.69524], [-120.03398, 38.69521], [-120.03407, 38.69509], [-120.03411, 38.69497], [-120.03411, 38.69478], [-120.03413, 38.69464], [-120.03417, 38.69459], [-120.03424, 38.69457], [-120.03428, 38.69459], [-120.03435, 38.69471], [-120.03439, 38.69473], [-120.03443, 38.69468], [-120.03446, 38.69456], [-120.03451, 38.69453], [-120.03457, 38.69456], [-120.03459, 38.69469], [-120.03465, 38.69471], [-120.03472, 38.69467], [-120.03492, 38.69437], [-120.03494, 38.69432], [-120.03498, 38.6943], [-120.0355, 38.69428], [-120.03612, 38.69389], [-120.0367, 38.69376], [-120.03682, 38.69357], [-120.03752, 38.69353], [-120.03777, 38.69346], [-120.03769, 38.69298], [-120.03836, 38.69188], [-120.03845, 38.69067], [-120.03836, 38.69028], [-120.03833, 38.6895], [-120.03822, 38.68932], [-120.03822, 38.68864], [-120.03813, 38.68842], [-120.03743, 38.68785], [-120.03726, 38.68753], [-120.03717, 38.68696], [-120.03678, 38.68651], [-120.03757, 38.68651], [-120.03759, 38.68647], [-120.03759, 38.68628], [-120.03755, 38.6861], [-120.03714, 38.6847], [-120.03713, 38.68452], [-120.03716, 38.68445], [-120.03722, 38.68441], [-120.03733, 38.68439], [-120.03759, 38.68438], [-120.03816, 38.68446], [-120.03829, 38.68453], [-120.03875, 38.68454], [-120.03882, 38.6846], [-120.03891, 38.68472], [-120.03904, 38.685], [-120.03907, 38.68502], [-120.03918, 38.68521], [-120.03938, 38.68539], [-120.03949, 38.68542], [-120.03955, 38.68535], [-120.03959, 38.68522], [-120.03963, 38.68517], [-120.03983, 38.6852], [-120.03999, 38.68529], [-120.04034, 38.68558], [-120.04037, 38.68591], [-120.04036, 38.68627], [-120.04033, 38.68649], [-120.04028, 38.68651], [-120.04009, 38.6865], [-120.03992, 38.68646], [-120.03978, 38.68639], [-120.03966, 38.68637], [-120.03956, 38.68639], [-120.03952, 38.68641], [-120.03951, 38.68644], [-120.03955, 38.68653], [-120.03973, 38.68655], [-120.0397, 38.68658], [-120.03949, 38.68666], [-120.03946, 38.68668], [-120.03946, 38.68672], [-120.03952, 38.68678], [-120.03981, 38.68678], [-120.03983, 38.68688], [-120.04023, 38.68719], [-120.04034, 38.68752], [-120.0404, 38.68783], [-120.04044, 38.68792], [-120.04054, 38.68799], [-120.04064, 38.68801], [-120.04094, 38.68821], [-120.04106, 38.68836], [-120.04146, 38.68903], [-120.04199, 38.69013], [-120.04219, 38.69028], [-120.04283, 38.69035], [-120.04391, 38.69165], [-120.04432, 38.69232], [-120.04469, 38.69259], [-120.04507, 38.69321], [-120.04516, 38.69365], [-120.04878, 38.69362], [-120.04855, 38.69723], [-120.04871, 38.69709], [-120.04887, 38.69703], [-120.04933, 38.69697], [-120.04992, 38.69694], [-120.05176, 38.69731], [-120.05374, 38.69806], [-120.05526, 38.69854], [-120.05859, 38.69993], [-120.05996, 38.70037], [-120.06191, 38.70087], [-120.0632, 38.70154], [-120.0648, 38.70268]], [[-120.04117, 38.69014], [-120.04128, 38.69053], [-120.04151, 38.69076], [-120.04175, 38.69074], [-120.04177, 38.69044], [-120.04131, 38.69001], [-120.04117, 38.69014]], [[-120.0509, 38.70162], [-120.05126, 38.70195], [-120.05267, 38.70223], [-120.05345, 38.70224], [-120.05343, 38.6999], [-120.05167, 38.70045], [-120.05053, 38.70028], [-120.04873, 38.70105], [-120.04766, 38.69951], [-120.04828, 38.69917], [-120.04845, 38.69887], [-120.04809, 38.69834], [-120.04661, 38.6972], [-120.04558, 38.69678], [-120.04281, 38.69842], [-120.04282, 38.70224], [-120.04353, 38.70241], [-120.04498, 38.70242], [-120.04552, 38.70297], [-120.0465, 38.70323], [-120.04678, 38.70375], [-120.04718, 38.7037], [-120.04752, 38.70329], [-120.04823, 38.70277], [-120.04882, 38.70257], [-120.04973, 38.70185], [-120.0509, 38.70162]], [[-120.04917, 38.70394], [-120.0491, 38.70423], [-120.0493, 38.70437], [-120.04983, 38.70437], [-120.04992, 38.7043], [-120.04991, 38.70414], [-120.04942, 38.70394], [-120.04917, 38.70394]]]} | Open Access 1 | 25794 | Caples Lake | 3401 | 2220 | El Dorado Irrigation District 890 | Special District 4 | Irrigation District 17 | http://www.eid.org/ | Special District 4 | 2220 | El Dorado Irrigation District 965 | Special District 4 | Irrigation District 16 | Alpine 51 | 531.982 | Caples Lake | None 1068 |
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]);