units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 1, AGNCY_NAME = 890 and MNG_AG_ID = 2220
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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]);