units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where AGNCY_TYP = 1, MNG_AG_TYP = 1 and YR_EST = 1961
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15817 | 15817 | 15816 | {"type": "MultiPolygon", "coordinates": [[[[-120.55429, 41.47581], [-120.55354, 41.47624], [-120.55341, 41.4763], [-120.55194, 41.47629], [-120.55188, 41.47621], [-120.55176, 41.47615], [-120.55156, 41.47611], [-120.55135, 41.47614], [-120.55122, 41.47621], [-120.55108, 41.47635], [-120.55093, 41.47655], [-120.53813, 41.47641], [-120.53784, 41.47637], [-120.53755, 41.47632], [-120.53708, 41.47618], [-120.53665, 41.47599], [-120.53642, 41.47585], [-120.53621, 41.47569], [-120.53591, 41.47539], [-120.53581, 41.47526], [-120.53568, 41.47505], [-120.53612, 41.47276], [-120.5363, 41.47275], [-120.5363, 41.46839], [-120.53559, 41.46838], [-120.53564, 41.46464], [-120.53532, 41.46393], [-120.53497, 41.46252], [-120.53463, 41.46192], [-120.53442, 41.46166], [-120.53483, 41.46143], [-120.53482, 41.46133], [-120.53469, 41.46123], [-120.53417, 41.46104], [-120.53394, 41.46082], [-120.53365, 41.46045], [-120.53333, 41.45972], [-120.53242, 41.45865], [-120.53182, 41.45767], [-120.53148, 41.45725], [-120.53094, 41.45689], [-120.52969, 41.45618], [-120.52948, 41.45593], [-120.52826, 41.45458], [-120.52767, 41.45381], [-120.5267, 41.45251], [-120.52627, 41.45153], [-120.52606, 41.45028], [-120.5261, 41.44501], [-120.52608, 41.43654], [-120.5261, 41.43291], [-120.52582, 41.42782], [-120.526, 41.4257], [-120.52615, 41.42569], [-120.52618, 41.4252], [-120.52625, 41.4247], [-120.52639, 41.42422], [-120.52651, 41.42389], [-120.5268, 41.4232], [-120.52695, 41.4229], [-120.52717, 41.42254], [-120.52735, 41.42227], [-120.5278, 41.42173], [-120.52977, 41.41968], [-120.5308, 41.41864], [-120.53121, 41.41811], [-120.53128, 41.41811], [-120.53148, 41.41787], [-120.53217, 41.417], [-120.53262, 41.41635], [-120.53312, 41.41553], [-120.53382, 41.41428], [-120.53411, 41.41383], [-120.53513, 41.41212], [-120.5353, 41.41158], [-120.53526, 41.40724], [-120.54198, 41.40699], [-120.54251, 41.41088], [-120.54323, 41.41221], [-120.54893, 41.45453], [-120.5497, 41.45453], [-120.54966, 41.45818], [-120.54966, 41.4655], [-120.55133, 41.46551], [-120.55155, 41.46702], [-120.55162, 41.46774], [-120.55315, 41.46814], [-120.55354, 41.46939], [-120.55401, 41.47002], [-120.55429, 41.47581]], [[-120.53061, 41.41949], [-120.53059, 41.41949], [-120.53048, 41.4257], [-120.53049, 41.42571], [-120.53062, 41.4257], [-120.5307, 41.42207], [-120.53061, 41.41949]]], [[[-120.58338, 41.4726], [-120.58337, 41.48006], [-120.57183, 41.48008], [-120.56886, 41.47506], [-120.56414, 41.47509], [-120.56414, 41.47647], [-120.55932, 41.47646], [-120.55931, 41.47365], [-120.56003, 41.47342], [-120.56011, 41.47323], [-120.56038, 41.47102], [-120.5593, 41.47093], [-120.55929, 41.467], [-120.55948, 41.46687], [-120.56409, 41.4656], [-120.56894, 41.46451], [-120.56897, 41.46914], [-120.57376, 41.46906], [-120.57376, 41.47272], [-120.58338, 41.4726]]], [[[-120.53511, 41.47819], [-120.53405, 41.47818], [-120.53404, 41.47811], [-120.53361, 41.47849], [-120.5336, 41.47992], [-120.53404, 41.47993], [-120.53404, 41.48002], [-120.53156, 41.48], [-120.53155, 41.47987], [-120.53133, 41.47985], [-120.53115, 41.4798], [-120.53095, 41.47972], [-120.53078, 41.47961], [-120.53066, 41.4795], [-120.53057, 41.47937], [-120.53051, 41.47921], [-120.53048, 41.47904], [-120.53031, 41.47903], [-120.53028, 41.47999], [-120.52547, 41.47995], [-120.5255, 41.48742], [-120.51074, 41.48731], [-120.50595, 41.48735], [-120.50593, 41.48356], [-120.50595, 41.47986], [-120.50945, 41.47974], [-120.51002, 41.47926], [-120.51152, 41.47892], [-120.51157, 41.47257], [-120.51561, 41.4726], [-120.51563, 41.46943], [-120.50598, 41.46934], [-120.50599, 41.46543], [-120.50602, 41.4654], [-120.50619, 41.46543], [-120.5062, 41.46542], [-120.50624, 41.4618], [-120.50632, 41.46145], [-120.50556, 41.46114], [-120.50534, 41.46114], [-120.50509, 41.46119], [-120.5043, 41.4614], [-120.50402, 41.46142], [-120.50345, 41.46142], [-120.50317, 41.46139], [-120.50284, 41.46133], [-120.50254, 41.46123], [-120.50217, 41.46105], [-120.50197, 41.46093], [-120.50168, 41.46069], [-120.5015, 41.46048], [-120.50131, 41.46019], [-120.50121, 41.45989], [-120.50121, 41.45889], [-120.50132, 41.4585], [-120.50141, 41.45825], [-120.50299, 41.45452], [-120.49626, 41.4545], [-120.4866, 41.4545], [-120.48661, 41.45085], [-120.48167, 41.45079], [-120.48153, 41.44718], [-120.48162, 41.44353], [-120.48168, 41.44183], [-120.48407, 41.44181], [-120.484, 41.43997], [-120.50108, 41.44008], [-120.50109, 41.44369], [-120.50582, 41.44374], [-120.50583, 41.44373], [-120.50584, 41.4401], [-120.51553, 41.44014], [-120.51551, 41.44377], [-120.52567, 41.4438], [-120.52564, 41.44755], [-120.52565, 41.45018], [-120.52543, 41.45042], [-120.52566, 41.45139], [-120.52663, 41.4534], [-120.52746, 41.45438], [-120.53089, 41.45808], [-120.53116, 41.45832], [-120.53258, 41.46015], [-120.5332, 41.46263], [-120.53066, 41.4626], [-120.53062, 41.4655], [-120.53371, 41.46549], [-120.53418, 41.46804], [-120.5342, 41.46862], [-120.53418, 41.46879], [-120.53413, 41.46895], [-120.53407, 41.46911], [-120.53398, 41.46926], [-120.53379, 41.4695], [-120.5335, 41.46974], [-120.53321, 41.46991], [-120.53295, 41.47002], [-120.5326, 41.47011], [-120.53217, 41.47016], [-120.53137, 41.47029], [-120.53138, 41.46923], [-120.53062, 41.46922], [-120.53061, 41.47068], [-120.53218, 41.47044], [-120.53278, 41.47044], [-120.5335, 41.47062], [-120.53392, 41.47082], [-120.53426, 41.47111], [-120.53456, 41.47158], [-120.53514, 41.4733], [-120.53511, 41.47819]], [[-120.52546, 41.47994], [-120.52554, 41.47592], [-120.52338, 41.47591], [-120.5233, 41.47993], [-120.52546, 41.47994]]], [[[-120.49574, 41.47996], [-120.49352, 41.48076], [-120.49051, 41.48202], [-120.48966, 41.4825], [-120.48887, 41.48354], [-120.48888, 41.48355], [-120.49119, 41.48355], [-120.4912, 41.49023], [-120.49144, 41.4909], [-120.49155, 41.49127], [-120.49153, 41.49178], [-120.49141, 41.49212], [-120.4912, 41.49262], [-120.4912, 41.4945], [-120.48632, 41.49446], [-120.48632, 41.49478], [-120.48184, 41.49548], [-120.47788, 41.49615], [-120.4764, 41.49635], [-120.47497, 41.49668], [-120.47156, 41.4985], [-120.47145, 41.49055], [-120.47142, 41.4905], [-120.47145, 41.49051], [-120.47146, 41.4905], [-120.47143, 41.48691], [-120.46649, 41.48681], [-120.46656, 41.47957], [-120.47151, 41.47965], [-120.47155, 41.47233], [-120.4765, 41.47237], [-120.47641, 41.48335], [-120.48626, 41.48355], [-120.48628, 41.47986], [-120.49574, 41.47996]]]]} | Restricted Access 2 | 8934 | Modoc National Wildlife Refuge | 22345 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Modoc 56 | 7101.15 | Modoc NWR | 1961 | National Wildlife Refuge 105 | 2 | |
17015 | 17015 | 17014 | {"type": "MultiPolygon", "coordinates": [[[[-116.48381, 32.96218], [-116.46708, 32.96157], [-116.45862, 32.96147], [-116.45983, 32.97277], [-116.4557, 32.97273], [-116.4561, 32.97629], [-116.44754, 32.97614], [-116.44738, 32.98004], [-116.4387, 32.97977], [-116.43911, 32.97615], [-116.42886, 32.97602], [-116.42886, 32.97595], [-116.41453, 32.97592], [-116.41186, 32.97465], [-116.41187, 32.97222], [-116.42271, 32.97232], [-116.42189, 32.96497], [-116.41691, 32.9649], [-116.41671, 32.96121], [-116.39822, 32.96131], [-116.38099, 32.96109], [-116.38143, 32.94679], [-116.36206, 32.94652], [-116.36205, 32.94653], [-116.36298, 32.95401], [-116.36393, 32.96156], [-116.35884, 32.96111], [-116.35886, 32.96935], [-116.34707, 32.9697], [-116.34728, 32.97328], [-116.34552, 32.97326], [-116.3431, 32.97327], [-116.3422, 32.97269], [-116.34153, 32.96955], [-116.33717, 32.96942], [-116.33502, 32.95939], [-116.32758, 32.96131], [-116.32757, 32.94544], [-116.32877, 32.9297], [-116.32681, 32.91591], [-116.30079, 32.9181], [-116.29276, 32.91723], [-116.27701, 32.91733], [-116.26046, 32.91766], [-116.24985, 32.91791], [-116.24846, 32.91396], [-116.2496, 32.91395], [-116.2503, 32.9159], [-116.25132, 32.91591], [-116.25133, 32.9159], [-116.25003, 32.91204], [-116.24896, 32.9088], [-116.24874, 32.90811], [-116.25098, 32.90812], [-116.25034, 32.90614], [-116.25142, 32.90613], [-116.25082, 32.90417], [-116.25192, 32.90417], [-116.25164, 32.90321], [-116.25392, 32.9032], [-116.25361, 32.90223], [-116.25386, 32.90135], [-116.25576, 32.90135], [-116.2564, 32.89865], [-116.25624, 32.89865], [-116.25241, 32.89876], [-116.25186, 32.90049], [-116.25072, 32.90048], [-116.2502, 32.90222], [-116.24565, 32.90219], [-116.24631, 32.90054], [-116.24631, 32.90053], [-116.24431, 32.90053], [-116.24332, 32.90055], [-116.24432, 32.89903], [-116.24326, 32.89904], [-116.24258, 32.89906], [-116.2432, 32.89834], [-116.24319, 32.89832], [-116.24145, 32.8984], [-116.24364, 32.89624], [-116.24307, 32.88895], [-116.25937, 32.88771], [-116.26766, 32.88771], [-116.26769, 32.88035], [-116.27647, 32.88034], [-116.27662, 32.87291], [-116.28467, 32.87296], [-116.2849, 32.86581], [-116.29333, 32.86583], [-116.29345, 32.85844], [-116.3098, 32.85835], [-116.30973, 32.87302], [-116.31816, 32.87309], [-116.31817, 32.867], [-116.31815, 32.8585], [-116.32221, 32.85857], [-116.32221, 32.85492], [-116.32649, 32.855], [-116.32647, 32.85145], [-116.32647, 32.85134], [-116.32648, 32.85133], [-116.33485, 32.85122], [-116.33475, 32.84395], [-116.33475, 32.83514], [-116.33478, 32.82959], [-116.32643, 32.82955], [-116.32638, 32.82191], [-116.32638, 32.82083], [-116.32624, 32.81499], [-116.32632, 32.81498], [-116.32632, 32.81133], [-116.33045, 32.81132], [-116.33045, 32.80785], [-116.33048, 32.80459], [-116.33048, 32.80011], [-116.33465, 32.80012], [-116.33477, 32.79654], [-116.3305, 32.79647], [-116.32634, 32.79643], [-116.31786, 32.79652], [-116.31781, 32.80012], [-116.30945, 32.80013], [-116.30906, 32.78484], [-116.309, 32.78189], [-116.29596, 32.78184], [-116.29604, 32.78534], [-116.29173, 32.7853], [-116.29173, 32.79643], [-116.29602, 32.79642], [-116.29602, 32.80007], [-116.30504, 32.80012], [-116.30509, 32.8068], [-116.30512, 32.80759], [-116.30959, 32.80762], [-116.30952, 32.80388], [-116.3142, 32.80388], [-116.31787, 32.80387], [-116.31792, 32.80767], [-116.31804, 32.81498], [-116.31805, 32.81501], [-116.31119, 32.81504], [-116.31117, 32.81503], [-116.30975, 32.81504], [-116.30984, 32.82205], [-116.30995, 32.82949], [-116.29178, 32.82945], [-116.27388, 32.82934], [-116.26512, 32.82922], [-116.25591, 32.8292], [-116.23785, 32.82939], [-116.21986, 32.82994], [-116.21963, 32.81437], [-116.21996, 32.80879], [-116.22002, 32.80739], [-116.22047, 32.79961], [-116.22098, 32.78493], [-116.22101, 32.78367], [-116.22143, 32.77193], [-116.22218, 32.75548], [-116.22271, 32.74096], [-116.2228, 32.72635], [-116.22279, 32.72634], [-116.20879, 32.72661], [-116.20818, 32.71903], [-116.20772, 32.71218], [-116.20914, 32.69754], [-116.20816, 32.68279], [-116.20837, 32.66849], [-116.22577, 32.66803], [-116.22572, 32.6643], [-116.23619, 32.66435], [-116.2427, 32.6644], [-116.24274, 32.66648], [-116.24269, 32.66816], [-116.23847, 32.66812], [-116.23842, 32.67171], [-116.2297, 32.67166], [-116.22961, 32.67522], [-116.23837, 32.6753], [-116.23834, 32.67891], [-116.24236, 32.67887], [-116.24223, 32.68251], [-116.2428, 32.68893], [-116.24759, 32.68892], [-116.24761, 32.68987], [-116.25117, 32.68988], [-116.25564, 32.68994], [-116.2557, 32.69353], [-116.2596, 32.69355], [-116.25959, 32.69716], [-116.25975, 32.69717], [-116.25973, 32.70118], [-116.25972, 32.7117], [-116.26004, 32.72231], [-116.26404, 32.72234], [-116.26372, 32.712], [-116.2638, 32.70148], [-116.26787, 32.7015], [-116.26779, 32.71231], [-116.27583, 32.7129], [-116.2845, 32.71346], [-116.28447, 32.70619], [-116.28892, 32.70644], [-116.28902, 32.72087], [-116.29304, 32.72127], [-116.29372, 32.72392], [-116.28948, 32.72369], [-116.29001, 32.72632], [-116.28772, 32.72628], [-116.28753, 32.74113], [-116.28323, 32.74111], [-116.28319, 32.74482], [-116.28746, 32.74486], [-116.28748, 32.74858], [-116.29181, 32.74862], [-116.29176, 32.7524], [-116.28735, 32.75239], [-116.28726, 32.75969], [-116.28294, 32.75966], [-116.28289, 32.76331], [-116.28719, 32.76337], [-116.28715, 32.76705], [-116.29146, 32.76707], [-116.29577, 32.76712], [-116.29602, 32.75234], [-116.30028, 32.75239], [-116.30037, 32.74871], [-116.30468, 32.74874], [-116.3046, 32.75237], [-116.309, 32.75241], [-116.30886, 32.75608], [-116.30888, 32.7598], [-116.30448, 32.7598], [-116.30445, 32.76346], [-116.30889, 32.76351], [-116.30888, 32.76388], [-116.30882, 32.77045], [-116.31762, 32.77043], [-116.31764, 32.77081], [-116.32646, 32.77077], [-116.34367, 32.77083], [-116.34519, 32.77085], [-116.36094, 32.77096], [-116.36111, 32.78557], [-116.37719, 32.78545], [-116.37713, 32.80027], [-116.37719, 32.80388], [-116.37731, 32.80389], [-116.37731, 32.80393], [-116.3774, 32.81499], [-116.35951, 32.81488], [-116.35965, 32.82361], [-116.35966, 32.82567], [-116.35973, 32.8296], [-116.35965, 32.84386], [-116.35996, 32.85259], [-116.36009, 32.85588], [-116.36018, 32.85848], [-116.3638, 32.85848], [-116.37737, 32.85851], [-116.37761, 32.86577], [-116.38628, 32.86576], [-116.40816, 32.86569], [-116.40837, 32.88016], [-116.40847, 32.88017], [-116.40849, 32.8804], [-116.41275, 32.88044], [-116.41288, 32.88743], [-116.41289, 32.89068], [-116.41305, 32.90203], [-116.41254, 32.91668], [-116.43015, 32.91675], [-116.43099, 32.90197], [-116.448, 32.90176], [-116.44737, 32.91795], [-116.44708, 32.92354], [-116.44681, 32.93173], [-116.44683, 32.93183], [-116.46435, 32.93191], [-116.46564, 32.94673], [-116.48246, 32.94679], [-116.48381, 32.96218]], [[-116.26998, 32.75208], [-116.27009, 32.74863], [-116.27023, 32.74098], [-116.26592, 32.74092], [-116.26637, 32.72597], [-116.26013, 32.72587], [-116.24232, 32.72634], [-116.24226, 32.72267], [-116.23362, 32.7227], [-116.23364, 32.72636], [-116.23996, 32.7264], [-116.23994, 32.72997], [-116.24932, 32.72986], [-116.25764, 32.72966], [-116.26192, 32.7297], [-116.2615, 32.74087], [-116.26143, 32.74462], [-116.26577, 32.74471], [-116.26563, 32.75202], [-116.26998, 32.75208]], [[-116.25858, 32.78321], [-116.25857, 32.7832], [-116.25759, 32.78319], [-116.25636, 32.7832], [-116.25631, 32.78499], [-116.25842, 32.785], [-116.25849, 32.78499], [-116.25858, 32.78321]], [[-116.25862, 32.78138], [-116.25869, 32.77955], [-116.25647, 32.77955], [-116.25641, 32.78137], [-116.25862, 32.78138]], [[-116.27229, 32.89313], [-116.27759, 32.89311], [-116.27813, 32.88959], [-116.26988, 32.88961], [-116.26982, 32.88997], [-116.26938, 32.89313], [-116.25782, 32.89313], [-116.25679, 32.89314], [-116.25689, 32.8951], [-116.25699, 32.89623], [-116.25786, 32.89625], [-116.26532, 32.89625], [-116.27181, 32.89624], [-116.27229, 32.89313]], [[-116.27173, 32.77782], [-116.26871, 32.77778], [-116.2609, 32.77773], [-116.26084, 32.77892], [-116.26068, 32.78319], [-116.26152, 32.7832], [-116.26285, 32.78319], [-116.26297, 32.77954], [-116.27165, 32.77957], [-116.27173, 32.77782]], [[-116.26758, 32.77231], [-116.26763, 32.77053], [-116.26547, 32.77051], [-116.26539, 32.77232], [-116.26756, 32.77235], [-116.26758, 32.77231]], [[-116.2693, 32.78496], [-116.26931, 32.78498], [-116.27147, 32.78495], [-116.2715, 32.78442], [-116.27153, 32.78319], [-116.26936, 32.78319], [-116.2693, 32.78496]], [[-116.27407, 32.77243], [-116.27413, 32.7706], [-116.26981, 32.77055], [-116.26968, 32.77416], [-116.27184, 32.77419], [-116.27191, 32.7724], [-116.27407, 32.77243]], [[-116.27173, 32.7778], [-116.27174, 32.77781], [-116.27389, 32.77782], [-116.27396, 32.77636], [-116.27396, 32.77602], [-116.27179, 32.776], [-116.27173, 32.7778]], [[-116.30961, 32.80762], [-116.3096, 32.80763], [-116.30961, 32.80847], [-116.30968, 32.81136], [-116.31385, 32.81136], [-116.31377, 32.80764], [-116.30961, 32.80762]], [[-116.34805, 32.77823], [-116.35256, 32.77828], [-116.35249, 32.7746], [-116.34372, 32.77443], [-116.34386, 32.78559], [-116.34829, 32.78571], [-116.34805, 32.77823]], [[-116.44707, 32.93406], [-116.4468, 32.93174], [-116.43823, 32.93171], [-116.43839, 32.92768], [-116.43852, 32.92422], [-116.43429, 32.92421], [-116.43418, 32.928], [-116.42981, 32.92795], [-116.43004, 32.92049], [-116.42563, 32.92047], [-116.42549, 32.92796], [-116.42112, 32.92792], [-116.42108, 32.93167], [-116.4297, 32.93169], [-116.42999, 32.939], [-116.43878, 32.93907], [-116.43852, 32.93531], [-116.44721, 32.93536], [-116.44707, 32.93406]]], [[[-116.26229, 32.6829], [-116.25995, 32.68265], [-116.25998, 32.68037], [-116.2618, 32.68229], [-116.26204, 32.68256], [-116.26229, 32.6829]]], [[[-116.27244, 32.68032], [-116.27221, 32.68399], [-116.26253, 32.68292], [-116.26228, 32.68258], [-116.26199, 32.68222], [-116.25997, 32.6801], [-116.26, 32.67533], [-116.26843, 32.6761], [-116.26827, 32.67985], [-116.27244, 32.68032]]], [[[-116.28465, 32.69528], [-116.28446, 32.69894], [-116.28446, 32.70247], [-116.27996, 32.70243], [-116.28006, 32.69879], [-116.2803, 32.69523], [-116.28465, 32.69528]]], [[[-116.30488, 32.79272], [-116.29605, 32.7927], [-116.29605, 32.78908], [-116.30038, 32.78907], [-116.3004, 32.7854], [-116.30475, 32.78546], [-116.30488, 32.79272]]], [[[-116.32631, 32.80758], [-116.32208, 32.80759], [-116.32206, 32.80386], [-116.32631, 32.80387], [-116.32631, 32.80758]]]]} | Open Access 1 | 12485 | McCain Valley National Cooperative Land and Wildlife Management Area | 32363 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | San Diego 4 | 75811.419 | McCain Valley Nat. Cooperative Land and WMA | 1961 | Conservation Area 13 | 2 |
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]);