units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 414, LAYER = 5, MNG_AG_LEV = 5 and MNG_AG_TYP = 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4997 | 4997 | 4996 | {"type": "MultiPolygon", "coordinates": [[[[-121.75097, 38.02973], [-121.75096, 38.02988], [-121.75091, 38.02999], [-121.7508, 38.03011], [-121.75067, 38.03021], [-121.75066, 38.03348], [-121.75049, 38.03373], [-121.75057, 38.03399], [-121.75066, 38.0345], [-121.75057, 38.03485], [-121.75042, 38.03525], [-121.75026, 38.03557], [-121.75002, 38.03593], [-121.74656, 38.0404], [-121.7461, 38.04058], [-121.74559, 38.04097], [-121.74501, 38.04152], [-121.74449, 38.04205], [-121.74346, 38.04297], [-121.74298, 38.04337], [-121.74281, 38.04355], [-121.74204, 38.04416], [-121.74186, 38.04425], [-121.73988, 38.04576], [-121.73894, 38.04643], [-121.7379, 38.04731], [-121.73753, 38.04778], [-121.73726, 38.04824], [-121.73706, 38.04872], [-121.73702, 38.04908], [-121.73702, 38.04932], [-121.73707, 38.04961], [-121.73724, 38.04981], [-121.73741, 38.0499], [-121.73743, 38.04996], [-121.73779, 38.05011], [-121.73799, 38.04995], [-121.73886, 38.04963], [-121.73922, 38.04953], [-121.73953, 38.04947], [-121.73916, 38.04998], [-121.73891, 38.05038], [-121.7386, 38.051], [-121.73844, 38.05143], [-121.73831, 38.05186], [-121.73822, 38.05231], [-121.73816, 38.05275], [-121.73814, 38.05344], [-121.73788, 38.05344], [-121.73767, 38.05363], [-121.7378, 38.05375], [-121.73792, 38.05388], [-121.73805, 38.0541], [-121.73811, 38.05434], [-121.73811, 38.05494], [-121.73825, 38.05494], [-121.73825, 38.05799], [-121.73816, 38.05853], [-121.73841, 38.05872], [-121.73807, 38.05932], [-121.73721, 38.06113], [-121.73259, 38.07805], [-121.73245, 38.07843], [-121.73224, 38.07878], [-121.73196, 38.07909], [-121.73173, 38.07929], [-121.73136, 38.07953], [-121.73108, 38.07967], [-121.72021, 38.07867], [-121.71656, 38.07513], [-121.71372, 38.07532], [-121.71361, 38.08124], [-121.71069, 38.08124], [-121.71068, 38.08379], [-121.71044, 38.0839], [-121.70998, 38.08416], [-121.70968, 38.08435], [-121.70937, 38.0846], [-121.70892, 38.08505], [-121.70865, 38.08537], [-121.70844, 38.08575], [-121.70806, 38.08617], [-121.70793, 38.08641], [-121.70767, 38.08675], [-121.70736, 38.08729], [-121.70728, 38.08746], [-121.70724, 38.08777], [-121.70699, 38.08838], [-121.70697, 38.08857], [-121.70687, 38.08892], [-121.70673, 38.08912], [-121.70658, 38.08936], [-121.70651, 38.08979], [-121.70643, 38.0901], [-121.70639, 38.09101], [-121.70638, 38.0929], [-121.70493, 38.0929], [-121.70492, 38.09425], [-121.70516, 38.09425], [-121.70516, 38.09497], [-121.70638, 38.09498], [-121.70638, 38.09524], [-121.70643, 38.09554], [-121.70642, 38.09646], [-121.7064, 38.09694], [-121.70641, 38.09761], [-121.70653, 38.09918], [-121.70652, 38.09959], [-121.70629, 38.09956], [-121.70634, 38.09807], [-121.70627, 38.09806], [-121.70633, 38.09752], [-121.70632, 38.09682], [-121.70603, 38.09684], [-121.70603, 38.09754], [-121.70599, 38.09792], [-121.70592, 38.09829], [-121.70368, 38.09802], [-121.70362, 38.09925], [-121.70546, 38.09947], [-121.70514, 38.09997], [-121.70289, 38.10309], [-121.70043, 38.1031], [-121.70034, 38.10497], [-121.70017, 38.10487], [-121.69922, 38.10449], [-121.6986, 38.10431], [-121.69775, 38.10415], [-121.69723, 38.10409], [-121.69694, 38.10408], [-121.69613, 38.10412], [-121.69572, 38.10425], [-121.69528, 38.10441], [-121.69511, 38.10424], [-121.69417, 38.10424], [-121.69485, 38.10104], [-121.69699, 38.09521], [-121.68982, 38.09513], [-121.68989, 38.09282], [-121.68676, 38.0928], [-121.68675, 38.09213], [-121.68677, 38.09161], [-121.68676, 38.09107], [-121.68675, 38.09087], [-121.68669, 38.09043], [-121.68668, 38.09024], [-121.68673, 38.08974], [-121.68675, 38.0892], [-121.68673, 38.08897], [-121.68676, 38.08854], [-121.6867, 38.08832], [-121.6867, 38.08786], [-121.68674, 38.08761], [-121.68674, 38.08721], [-121.6867, 38.08699], [-121.68668, 38.08675], [-121.68663, 38.08652], [-121.68652, 38.08613], [-121.68628, 38.08551], [-121.68828, 38.08552], [-121.68829, 38.08551], [-121.68557, 38.08016], [-121.68513, 38.07479], [-121.68361, 38.07478], [-121.68365, 38.07467], [-121.68367, 38.07432], [-121.68365, 38.07369], [-121.68352, 38.07232], [-121.68338, 38.0712], [-121.68336, 38.07081], [-121.68331, 38.07045], [-121.68327, 38.07001], [-121.68321, 38.06969], [-121.68305, 38.0681], [-121.68292, 38.06711], [-121.68292, 38.06708], [-121.68467, 38.06738], [-121.68551, 38.06563], [-121.68669, 38.06415], [-121.68771, 38.0628], [-121.68899, 38.06169], [-121.68899, 38.06168], [-121.68638, 38.06103], [-121.6878, 38.05985], [-121.68915, 38.05893], [-121.68977, 38.05854], [-121.69028, 38.05819], [-121.69106, 38.05756], [-121.69278, 38.05839], [-121.69445, 38.05699], [-121.69313, 38.05592], [-121.69428, 38.05498], [-121.69539, 38.05387], [-121.69598, 38.05331], [-121.69675, 38.05266], [-121.69717, 38.05235], [-121.69778, 38.05195], [-121.69879, 38.05122], [-121.69941, 38.05256], [-121.7018, 38.05183], [-121.70182, 38.05005], [-121.7024, 38.05], [-121.70344, 38.04993], [-121.70369, 38.04987], [-121.70409, 38.04973], [-121.70451, 38.04953], [-121.70566, 38.04868], [-121.70639, 38.04817], [-121.70694, 38.04786], [-121.70746, 38.04752], [-121.70808, 38.04719], [-121.70883, 38.04686], [-121.70959, 38.04657], [-121.70958, 38.0486], [-121.71085, 38.04861], [-121.71088, 38.04614], [-121.71197, 38.04568], [-121.71292, 38.04533], [-121.71368, 38.04506], [-121.71489, 38.04471], [-121.71556, 38.04449], [-121.71681, 38.04411], [-121.71801, 38.04364], [-121.71846, 38.04344], [-121.71847, 38.0441], [-121.72007, 38.0441], [-121.72007, 38.04444], [-121.72075, 38.04445], [-121.72077, 38.04222], [-121.72141, 38.0419], [-121.72237, 38.04149], [-121.7225, 38.0414], [-121.72267, 38.04131], [-121.72348, 38.041], [-121.72391, 38.04076], [-121.72416, 38.0406], [-121.72468, 38.04016], [-121.72469, 38.04025], [-121.72597, 38.04026], [-121.72598, 38.04008], [-121.72613, 38.04006], [-121.72624, 38.03963], [-121.72617, 38.03923], [-121.72641, 38.03906], [-121.72691, 38.03875], [-121.72691, 38.03853], [-121.72712, 38.03844], [-121.72806, 38.03787], [-121.72843, 38.03766], [-121.72906, 38.03722], [-121.72985, 38.03676], [-121.73036, 38.0365], [-121.73025, 38.05199], [-121.73027, 38.052], [-121.73033, 38.05197], [-121.73055, 38.03639], [-121.73147, 38.03584], [-121.73265, 38.03525], [-121.7334, 38.03495], [-121.73381, 38.03471], [-121.73439, 38.03442], [-121.73438, 38.0365], [-121.73611, 38.03651], [-121.73601, 38.04899], [-121.735, 38.04918], [-121.73499, 38.04986], [-121.73481, 38.04981], [-121.7337, 38.05019], [-121.7337, 38.05043], [-121.73371, 38.05043], [-121.73475, 38.04996], [-121.73619, 38.05009], [-121.73632, 38.03515], [-121.74491, 38.03218], [-121.74492, 38.0305], [-121.7452, 38.0304], [-121.7462, 38.03032], [-121.74657, 38.03032], [-121.74687, 38.0303], [-121.74726, 38.03023], [-121.74832, 38.03015], [-121.74865, 38.03011], [-121.7492, 38.02999], [-121.74976, 38.02994], [-121.75006, 38.02987], [-121.7505, 38.0298], [-121.75097, 38.02973]], [[-121.70718, 38.08676], [-121.70717, 38.08675], [-121.70696, 38.08668], [-121.70656, 38.08697], [-121.7065, 38.08708], [-121.70692, 38.08723], [-121.70718, 38.08676]], [[-121.73709, 38.05029], [-121.73688, 38.05021], [-121.7362, 38.0502], [-121.73619, 38.05055], [-121.73736, 38.05056], [-121.73737, 38.05029], [-121.73709, 38.05029]]], [[[-121.78398, 38.05752], [-121.78397, 38.06143], [-121.78055, 38.06307], [-121.7793, 38.0636], [-121.77906, 38.06366], [-121.77868, 38.0638], [-121.77587, 38.06499], [-121.77514, 38.06531], [-121.77454, 38.06563], [-121.7717, 38.067], [-121.7706, 38.06756], [-121.76971, 38.06809], [-121.76876, 38.06871], [-121.768, 38.06928], [-121.7677, 38.06955], [-121.76709, 38.0702], [-121.76608, 38.07105], [-121.76589, 38.07117], [-121.76565, 38.07033], [-121.76281, 38.07112], [-121.76286, 38.07203], [-121.76334, 38.07226], [-121.76321, 38.07227], [-121.76253, 38.07238], [-121.76267, 38.07204], [-121.76261, 38.07118], [-121.75933, 38.07209], [-121.75933, 38.07182], [-121.75932, 38.07181], [-121.75793, 38.07243], [-121.75759, 38.07197], [-121.7574, 38.07207], [-121.75772, 38.07253], [-121.75751, 38.07262], [-121.75718, 38.07218], [-121.75699, 38.07228], [-121.7573, 38.07271], [-121.75625, 38.07318], [-121.75597, 38.0728], [-121.7527, 38.07449], [-121.75189, 38.07138], [-121.75188, 38.07137], [-121.75175, 38.07149], [-121.75285, 38.07574], [-121.74713, 38.07856], [-121.7403, 38.0824], [-121.73591, 38.07985], [-121.7359, 38.07973], [-121.73571, 38.07972], [-121.73564, 38.08233], [-121.73558, 38.0823], [-121.73558, 38.07961], [-121.73262, 38.0796], [-121.73264, 38.07949], [-121.73264, 38.07938], [-121.73259, 38.07928], [-121.73251, 38.07916], [-121.73251, 38.07912], [-121.73278, 38.07877], [-121.73298, 38.07841], [-121.73312, 38.07804], [-121.73332, 38.07729], [-121.73353, 38.07732], [-121.73558, 38.06981], [-121.73604, 38.06988], [-121.73633, 38.06882], [-121.73587, 38.06874], [-121.73849, 38.05915], [-121.73888, 38.05851], [-121.73918, 38.05811], [-121.73952, 38.05772], [-121.74007, 38.05716], [-121.74068, 38.05664], [-121.74111, 38.05633], [-121.74156, 38.05603], [-121.74553, 38.05371], [-121.74605, 38.05337], [-121.74653, 38.05302], [-121.74698, 38.05268], [-121.74741, 38.05232], [-121.74741, 38.05243], [-121.74743, 38.05243], [-121.74788, 38.05203], [-121.74842, 38.05149], [-121.74892, 38.05093], [-121.74939, 38.05035], [-121.74982, 38.04975], [-121.75021, 38.04913], [-121.75056, 38.0485], [-121.75086, 38.04785], [-121.75112, 38.04719], [-121.75134, 38.04652], [-121.75146, 38.04607], [-121.75156, 38.04562], [-121.75167, 38.04494], [-121.75173, 38.04448], [-121.75175, 38.04402], [-121.75177, 38.04264], [-121.75119, 38.04265], [-121.75117, 38.04394], [-121.75114, 38.04438], [-121.75107, 38.04504], [-121.75099, 38.04548], [-121.75084, 38.04614], [-121.75065, 38.04679], [-121.75042, 38.04742], [-121.75014, 38.04805], [-121.74971, 38.04887], [-121.74921, 38.04966], [-121.74879, 38.05024], [-121.74833, 38.05079], [-121.748, 38.05116], [-121.74741, 38.05174], [-121.74741, 38.05196], [-121.74692, 38.05239], [-121.7464, 38.0528], [-121.74586, 38.05319], [-121.74534, 38.05353], [-121.74481, 38.05385], [-121.74162, 38.0557], [-121.74092, 38.05614], [-121.74048, 38.05647], [-121.73986, 38.05699], [-121.73929, 38.05756], [-121.73894, 38.05797], [-121.73845, 38.05772], [-121.73844, 38.05494], [-121.73858, 38.05493], [-121.73858, 38.05433], [-121.73855, 38.05416], [-121.73855, 38.0532], [-121.73858, 38.05277], [-121.73867, 38.05214], [-121.73878, 38.05172], [-121.73891, 38.05131], [-121.73918, 38.05071], [-121.73953, 38.05014], [-121.74005, 38.04944], [-121.74021, 38.04943], [-121.74071, 38.04945], [-121.74144, 38.04953], [-121.74203, 38.04961], [-121.74257, 38.04977], [-121.74287, 38.04993], [-121.74316, 38.05023], [-121.74329, 38.05045], [-121.74332, 38.05065], [-121.74326, 38.05101], [-121.74313, 38.05144], [-121.743, 38.05175], [-121.74282, 38.052], [-121.74265, 38.05213], [-121.7424, 38.05225], [-121.74184, 38.05242], [-121.74054, 38.05264], [-121.73993, 38.05269], [-121.73926, 38.05281], [-121.73904, 38.05287], [-121.73889, 38.05297], [-121.73879, 38.05312], [-121.73878, 38.0532], [-121.73891, 38.05319], [-121.739, 38.05304], [-121.73911, 38.05297], [-121.7393, 38.05292], [-121.73995, 38.0528], [-121.74056, 38.05275], [-121.74188, 38.05252], [-121.74246, 38.05235], [-121.74274, 38.05222], [-121.74293, 38.05206], [-121.74313, 38.05179], [-121.74326, 38.05147], [-121.7434, 38.05103], [-121.74346, 38.05065], [-121.74342, 38.05042], [-121.74328, 38.05018], [-121.74297, 38.04985], [-121.74264, 38.04968], [-121.74206, 38.04951], [-121.74146, 38.04942], [-121.74072, 38.04934], [-121.74014, 38.04932], [-121.74727, 38.04012], [-121.74727, 38.04003], [-121.74735, 38.03992], [-121.74814, 38.03992], [-121.74834, 38.03996], [-121.74864, 38.03996], [-121.7488, 38.03998], [-121.74918, 38.03997], [-121.74934, 38.04], [-121.74972, 38.04001], [-121.75061, 38.0401], [-121.75132, 38.04015], [-121.75136, 38.04024], [-121.75255, 38.0403], [-121.75324, 38.04042], [-121.75505, 38.0405], [-121.75565, 38.04051], [-121.75679, 38.04021], [-121.75754, 38.04025], [-121.75901, 38.04064], [-121.75938, 38.04087], [-121.75997, 38.04118], [-121.76039, 38.04161], [-121.76086, 38.04204], [-121.76128, 38.04252], [-121.76194, 38.04303], [-121.76246, 38.04346], [-121.76264, 38.04357], [-121.76259, 38.05329], [-121.76269, 38.05328], [-121.76275, 38.04351], [-121.76505, 38.04494], [-121.76606, 38.04549], [-121.76884, 38.04711], [-121.77018, 38.04783], [-121.77185, 38.04882], [-121.77331, 38.04963], [-121.77569, 38.05065], [-121.77675, 38.05134], [-121.77787, 38.05222], [-121.779, 38.05282], [-121.78043, 38.05324], [-121.78112, 38.0531], [-121.78113, 38.05744], [-121.78398, 38.05752]]], [[[-121.74639, 38.04062], [-121.73962, 38.04935], [-121.73951, 38.04936], [-121.73918, 38.04943], [-121.7388, 38.04953], [-121.73815, 38.04978], [-121.73799, 38.0498], [-121.73766, 38.04977], [-121.73747, 38.04974], [-121.73739, 38.0497], [-121.73727, 38.04955], [-121.73723, 38.04931], [-121.73723, 38.04909], [-121.73727, 38.04876], [-121.73746, 38.0483], [-121.73771, 38.04786], [-121.73806, 38.04742], [-121.73909, 38.04655], [-121.74002, 38.04588], [-121.74144, 38.0448], [-121.74195, 38.04434], [-121.74213, 38.04424], [-121.74291, 38.04363], [-121.74308, 38.04344], [-121.74356, 38.04304], [-121.7446, 38.04212], [-121.74511, 38.04159], [-121.74569, 38.04105], [-121.74618, 38.04067], [-121.74625, 38.04064], [-121.74639, 38.04062]]], [[[-121.75161, 38.02968], [-121.75157, 38.03314], [-121.75143, 38.03951], [-121.75125, 38.03946], [-121.75088, 38.03945], [-121.75047, 38.03941], [-121.74926, 38.03938], [-121.7489, 38.03935], [-121.74849, 38.03928], [-121.74835, 38.03927], [-121.74824, 38.03932], [-121.74808, 38.03942], [-121.74806, 38.03949], [-121.74808, 38.03963], [-121.74819, 38.03979], [-121.74801, 38.03986], [-121.74746, 38.03986], [-121.75038, 38.0361], [-121.75064, 38.0357], [-121.75088, 38.03522], [-121.75102, 38.03479], [-121.75117, 38.03411], [-121.75134, 38.03386], [-121.75134, 38.03373], [-121.75118, 38.03349], [-121.75119, 38.02971], [-121.75161, 38.02968]]], [[[-121.78448, 38.0395], [-121.78211, 38.04102], [-121.78376, 38.04636], [-121.78383, 38.04714], [-121.78037, 38.04977], [-121.78037, 38.04979], [-121.78067, 38.05004], [-121.7804, 38.05028], [-121.78006, 38.05001], [-121.77783, 38.0517], [-121.77717, 38.05116], [-121.77638, 38.05056], [-121.7749, 38.04988], [-121.77353, 38.04911], [-121.77176, 38.04825], [-121.77011, 38.04728], [-121.76864, 38.0464], [-121.76674, 38.04544], [-121.76611, 38.04508], [-121.76522, 38.04465], [-121.76385, 38.04385], [-121.76352, 38.04364], [-121.76333, 38.04346], [-121.76235, 38.04266], [-121.76072, 38.04105], [-121.76013, 38.04066], [-121.75956, 38.04035], [-121.75838, 38.03997], [-121.75701, 38.03985], [-121.75636, 38.03988], [-121.75507, 38.03977], [-121.75352, 38.03971], [-121.75333, 38.03969], [-121.75368, 38.02963], [-121.75475, 38.02963], [-121.75508, 38.0296], [-121.75597, 38.0296], [-121.75691, 38.02974], [-121.75736, 38.02976], [-121.75762, 38.02981], [-121.75789, 38.02983], [-121.75817, 38.02985], [-121.75842, 38.02982], [-121.75858, 38.02982], [-121.75928, 38.0299], [-121.75953, 38.0299], [-121.76003, 38.02996], [-121.76026, 38.02997], [-121.76044, 38.03], [-121.76086, 38.03015], [-121.76117, 38.03022], [-121.76151, 38.03032], [-121.76199, 38.0305], [-121.76227, 38.03064], [-121.76261, 38.03074], [-121.76269, 38.03085], [-121.76275, 38.03113], [-121.76288, 38.03125], [-121.76288, 38.03131], [-121.76281, 38.03144], [-121.76278, 38.03176], [-121.76273, 38.03181], [-121.76272, 38.03192], [-121.76281, 38.03196], [-121.76281, 38.03206], [-121.76293, 38.03224], [-121.76314, 38.03245], [-121.76335, 38.03259], [-121.76352, 38.03266], [-121.76378, 38.03281], [-121.76419, 38.03294], [-121.76471, 38.03306], [-121.76568, 38.03311], [-121.76651, 38.03311], [-121.7676, 38.03306], [-121.76851, 38.03294], [-121.76923, 38.03282], [-121.77002, 38.03261], [-121.77168, 38.03221], [-121.77202, 38.03214], [-121.77255, 38.03206], [-121.77271, 38.03211], [-121.77286, 38.0322], [-121.77299, 38.03234], [-121.77311, 38.03256], [-121.7733, 38.033], [-121.77356, 38.03339], [-121.77369, 38.03364], [-121.77438, 38.03428], [-121.7749, 38.03469], [-121.77575, 38.03532], [-121.77685, 38.0361], [-121.77927, 38.03746], [-121.78166, 38.03816], [-121.78238, 38.03842], [-121.78367, 38.03892], [-121.78424, 38.0392], [-121.78448, 38.0395]]]]} | No Public Access 3 | 21753 | Sherman Island | 25396 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Sacramento 41 | 9160.25 | Sherman Island | None 414 |
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]);