units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

21 rows where DES_TP = 14, MNG_AGENCY = 42 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 21 ✖

MNG_AGENCY 1

  • Encinitas, City of · 21 ✖

DES_TP 1

  • Local Other or Unknown · 21 ✖

ACCESS_TYP 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
4596 4596 4595 {"type": "Polygon", "coordinates": [[[-117.28319, 33.04494], [-117.28317, 33.045], [-117.28306, 33.045], [-117.28307, 33.04496], [-117.28304, 33.04495], [-117.28303, 33.04494], [-117.28298, 33.04494], [-117.28297, 33.04495], [-117.28295, 33.04495], [-117.28294, 33.045], [-117.2829, 33.04497], [-117.28291, 33.04454], [-117.28293, 33.04452], [-117.28296, 33.04453], [-117.28319, 33.04492], [-117.28319, 33.04494]]]} Open Access 1 35531 Unknown park - Encinitas, City of 28635 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 0.21   0 Local Other or Unknown 14 4
13416 13416 13415 {"type": "Polygon", "coordinates": [[[-117.28517, 33.08411], [-117.28517, 33.08713], [-117.28478, 33.08714], [-117.28429, 33.08718], [-117.28299, 33.08738], [-117.28297, 33.08412], [-117.28517, 33.08411]]]} Open Access 1 35528 Encinitas holding 29 18656 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 17.436 Encinitas holding 29 0 Local Other or Unknown 14 4
13417 13417 13416 {"type": "Polygon", "coordinates": [[[-117.28529, 33.07544], [-117.2852, 33.07638], [-117.2851, 33.07638], [-117.28509, 33.07542], [-117.28506, 33.07538], [-117.28525, 33.0754], [-117.28529, 33.07544]]]} Open Access 1 35529 Encinitas holding 31 18657 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 0.384 Encinitas holding 31 0 Local Other or Unknown 14 4
13419 13419 13418 {"type": "Polygon", "coordinates": [[[-117.24702, 33.0564], [-117.24692, 33.05685], [-117.24691, 33.05685], [-117.24689, 33.05683], [-117.2469, 33.05662], [-117.24702, 33.0564]]]} Open Access 1 35537 Encinitas holding 36 18658 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 0.044 Encinitas holding 36 0 Local Other or Unknown 14 4
13420 13420 13419 {"type": "Polygon", "coordinates": [[[-117.25554, 33.03255], [-117.25419, 33.03259], [-117.25425, 33.03238], [-117.25435, 33.0322], [-117.25409, 33.03203], [-117.25412, 33.03199], [-117.25439, 33.03213], [-117.25449, 33.03195], [-117.25455, 33.03175], [-117.25454, 33.03156], [-117.2545, 33.03127], [-117.25453, 33.03099], [-117.25448, 33.03085], [-117.2544, 33.03057], [-117.25438, 33.03034], [-117.25454, 33.03041], [-117.25463, 33.03047], [-117.25474, 33.03058], [-117.25485, 33.03073], [-117.25491, 33.03087], [-117.25502, 33.03152], [-117.25508, 33.03166], [-117.25522, 33.0318], [-117.2553, 33.03184], [-117.25546, 33.03189], [-117.25554, 33.03189], [-117.25554, 33.03255]]]} Open Access 1 35538 Encinitas holding 12 18647 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 3.895 Encinitas holding 12 0 Local Other or Unknown 14 4
13421 13421 13420 {"type": "Polygon", "coordinates": [[[-117.25119, 33.02892], [-117.25116, 33.02906], [-117.24968, 33.02909], [-117.24971, 33.02907], [-117.24974, 33.02897], [-117.24991, 33.02881], [-117.24992, 33.02878], [-117.24992, 33.02865], [-117.24995, 33.02859], [-117.25001, 33.02853], [-117.25075, 33.02804], [-117.25081, 33.02804], [-117.25084, 33.02805], [-117.25088, 33.0281], [-117.25089, 33.02815], [-117.25081, 33.02827], [-117.25054, 33.02853], [-117.2505, 33.02861], [-117.25049, 33.02867], [-117.25051, 33.02876], [-117.25055, 33.0288], [-117.25063, 33.02884], [-117.2508, 33.02884], [-117.25102, 33.02881], [-117.25113, 33.02882], [-117.25118, 33.02885], [-117.25119, 33.02892]]]} Open Access 1 35539 Encinitas holding 47 18663 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 1.83 Encinitas holding 47 0 Local Other or Unknown 14 4
13423 13423 13422 {"type": "Polygon", "coordinates": [[[-117.25097, 33.02595], [-117.25082, 33.02602], [-117.25066, 33.02604], [-117.25034, 33.02612], [-117.24989, 33.02611], [-117.24982, 33.02614], [-117.24939, 33.02641], [-117.24938, 33.02662], [-117.24941, 33.02672], [-117.24949, 33.02681], [-117.24953, 33.02685], [-117.24963, 33.02688], [-117.24997, 33.02692], [-117.24915, 33.02722], [-117.24916, 33.0291], [-117.24825, 33.02912], [-117.24825, 33.02901], [-117.24853, 33.02901], [-117.24852, 33.02874], [-117.24826, 33.02831], [-117.24789, 33.0283], [-117.24788, 33.02811], [-117.24859, 33.02811], [-117.24858, 33.02777], [-117.24844, 33.02778], [-117.24805, 33.0273], [-117.2485, 33.02721], [-117.24848, 33.02711], [-117.2487, 33.02709], [-117.2487, 33.02682], [-117.24777, 33.02649], [-117.24794, 33.02643], [-117.24793, 33.02623], [-117.24817, 33.02577], [-117.24817, 33.02571], [-117.24807, 33.02552], [-117.24913, 33.02551], [-117.24913, 33.02413], [-117.24932, 33.02414], [-117.24939, 33.02417], [-117.24926, 33.02429], [-117.24928, 33.02435], [-117.24945, 33.02447], [-117.24962, 33.02456], [-117.24966, 33.02456], [-117.24973, 33.02449], [-117.24978, 33.02449], [-117.24999, 33.02457], [-117.25006, 33.02469], [-117.25007, 33.02474], [-117.2501, 33.02514], [-117.25033, 33.02515], [-117.25038, 33.02475], [-117.25075, 33.02474], [-117.25077, 33.02476], [-117.25076, 33.02488], [-117.25073, 33.02495], [-117.25067, 33.02503], [-117.25052, 33.02515], [-117.2505, 33.0252], [-117.25053, 33.02524], [-117.25088, 33.02547], [-117.25094, 33.02554], [-117.25097, 33.02574], [-117.25097, 33.02595]]]} Open Access 1 35540 Encinitas holding 41 18661 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 15.302 Encinitas holding 41 0 Local Other or Unknown 14 4
13424 13424 13423 {"type": "Polygon", "coordinates": [[[-117.25303, 33.03045], [-117.25301, 33.031], [-117.25251, 33.03099], [-117.25221, 33.03096], [-117.25225, 33.0308], [-117.25224, 33.03072], [-117.25259, 33.0307], [-117.25258, 33.03044], [-117.25299, 33.03041], [-117.25303, 33.03045]]]} Open Access 1 35543 Encinitas holding 40 18660 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 0.88 Encinitas holding 40 0 Local Other or Unknown 14 4
13427 13427 13426 {"type": "Polygon", "coordinates": [[[-117.25343, 33.02661], [-117.25336, 33.02656], [-117.2531, 33.02647], [-117.25296, 33.02647], [-117.25283, 33.0265], [-117.25274, 33.02655], [-117.25272, 33.0266], [-117.25209, 33.0266], [-117.25196, 33.02644], [-117.25185, 33.02624], [-117.25185, 33.02612], [-117.25194, 33.02595], [-117.25198, 33.02582], [-117.25197, 33.02575], [-117.25188, 33.02556], [-117.25181, 33.02549], [-117.2517, 33.02546], [-117.25128, 33.02546], [-117.25121, 33.02543], [-117.25113, 33.02537], [-117.25112, 33.02528], [-117.25114, 33.02519], [-117.25114, 33.02506], [-117.2511, 33.02499], [-117.25105, 33.02485], [-117.25097, 33.02475], [-117.25096, 33.02471], [-117.25104, 33.02463], [-117.25107, 33.02457], [-117.25116, 33.02445], [-117.25121, 33.02433], [-117.25121, 33.02425], [-117.25113, 33.02409], [-117.25124, 33.02378], [-117.25119, 33.02362], [-117.25121, 33.02353], [-117.25123, 33.02351], [-117.25127, 33.0235], [-117.25127, 33.02542], [-117.25342, 33.02542], [-117.25343, 33.02661]]]} Open Access 1 35544 Encinitas holding 37 18659 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 5.06 Encinitas holding 37 0 Local Other or Unknown 14 4
13428 13428 13427 {"type": "Polygon", "coordinates": [[[-117.25127, 33.02194], [-117.25127, 33.02345], [-117.25103, 33.02344], [-117.2509, 33.02335], [-117.2507, 33.0233], [-117.25061, 33.02326], [-117.25046, 33.02314], [-117.25039, 33.02299], [-117.25041, 33.02262], [-117.25034, 33.02248], [-117.25025, 33.02238], [-117.2504, 33.02227], [-117.25071, 33.0221], [-117.25109, 33.02196], [-117.25123, 33.02192], [-117.25126, 33.02192], [-117.25127, 33.02194]]]} Open Access 1 35546 Encinitas holding 42 18662 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 2.872 Encinitas holding 42 0 Local Other or Unknown 14 4
13429 13429 13428 {"type": "Polygon", "coordinates": [[[-117.26321, 33.06745], [-117.26292, 33.06743], [-117.26291, 33.06741], [-117.26254, 33.06741], [-117.26246, 33.06737], [-117.26249, 33.06552], [-117.26252, 33.0653], [-117.26255, 33.06527], [-117.26304, 33.06525], [-117.26303, 33.06536], [-117.26294, 33.06558], [-117.26288, 33.06689], [-117.26294, 33.0671], [-117.26302, 33.06728], [-117.26306, 33.06732], [-117.26317, 33.06736], [-117.26321, 33.06745]]]} Open Access 1 35548 Encinitas holding 1 18645 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 2.584 Encinitas holding 1 0 Local Other or Unknown 14 4
13504 13504 13503 {"type": "Polygon", "coordinates": [[[-117.2641, 33.06086], [-117.26391, 33.06092], [-117.26379, 33.06074], [-117.26377, 33.06074], [-117.26372, 33.06078], [-117.26368, 33.06086], [-117.26368, 33.06107], [-117.26343, 33.06107], [-117.26332, 33.06135], [-117.26335, 33.06149], [-117.2635, 33.06179], [-117.26317, 33.06286], [-117.2632, 33.0629], [-117.2632, 33.06304], [-117.26311, 33.0635], [-117.26312, 33.06388], [-117.2631, 33.064], [-117.2631, 33.0642], [-117.26314, 33.06445], [-117.26328, 33.06493], [-117.26308, 33.06497], [-117.26266, 33.06499], [-117.2626, 33.06493], [-117.26263, 33.06455], [-117.2629, 33.0626], [-117.26296, 33.06202], [-117.26296, 33.05866], [-117.26298, 33.05863], [-117.26301, 33.05861], [-117.26329, 33.05861], [-117.26358, 33.05865], [-117.26386, 33.05873], [-117.26404, 33.05881], [-117.26382, 33.05976], [-117.2641, 33.06086]]]} Open Access 1 35817 Encinitas holding 20 18651 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 10.231 Encinitas holding 20 0 Local Other or Unknown 14 4
13506 13506 13505 {"type": "Polygon", "coordinates": [[[-117.2513, 33.02732], [-117.25128, 33.02869], [-117.25071, 33.02869], [-117.25069, 33.02867], [-117.25069, 33.02864], [-117.25071, 33.02859], [-117.25095, 33.02831], [-117.25101, 33.0282], [-117.25103, 33.02811], [-117.251, 33.02801], [-117.25087, 33.02786], [-117.25082, 33.02777], [-117.25085, 33.02767], [-117.25083, 33.02746], [-117.25096, 33.0274], [-117.2513, 33.02732]]]} Open Access 1 35789 Encinitas holding 11 18646 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 1.401 Encinitas holding 11 0 Local Other or Unknown 14 4
13517 13517 13516 {"type": "Polygon", "coordinates": [[[-117.2873, 33.08409], [-117.28675, 33.08409], [-117.28637, 33.08148], [-117.28631, 33.08126], [-117.28621, 33.08103], [-117.28589, 33.08046], [-117.28723, 33.08045], [-117.2873, 33.08409]]]} Open Access 1 35810 Encinitas holding 25 18652 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 7.638 Encinitas holding 25 0 Local Other or Unknown 14 4
13519 13519 13518 {"type": "Polygon", "coordinates": [[[-117.25555, 33.03156], [-117.25554, 33.03171], [-117.25551, 33.03172], [-117.25538, 33.03169], [-117.25524, 33.03157], [-117.25521, 33.03149], [-117.25511, 33.03088], [-117.25506, 33.03072], [-117.25492, 33.03051], [-117.25482, 33.0304], [-117.25463, 33.03026], [-117.25451, 33.03021], [-117.2546, 33.03006], [-117.25456, 33.02982], [-117.25446, 33.02964], [-117.25431, 33.0296], [-117.2542, 33.02922], [-117.25408, 33.02918], [-117.25351, 33.02933], [-117.25342, 33.02945], [-117.25328, 33.02972], [-117.25344, 33.02987], [-117.25345, 33.0299], [-117.25259, 33.02999], [-117.25136, 33.03006], [-117.25134, 33.03033], [-117.25132, 33.03033], [-117.25131, 33.03042], [-117.25128, 33.02906], [-117.25534, 33.02898], [-117.25534, 33.02966], [-117.25539, 33.03042], [-117.25547, 33.03115], [-117.25555, 33.03156]]]} Open Access 1 35814 Encinitas holding 26 18653 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 10.133 Encinitas holding 26 0 Local Other or Unknown 14 4
13520 13520 13519 {"type": "Polygon", "coordinates": [[[-117.25124, 33.02661], [-117.2512, 33.02671], [-117.25099, 33.02698], [-117.25086, 33.02705], [-117.25075, 33.02708], [-117.25046, 33.02687], [-117.25028, 33.0268], [-117.25038, 33.0265], [-117.25079, 33.02648], [-117.2509, 33.02644], [-117.25108, 33.02634], [-117.25123, 33.02631], [-117.25125, 33.02646], [-117.25124, 33.02661]]]} Open Access 1 35815 Encinitas holding 27 18654 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 1.158 Encinitas holding 27 0 Local Other or Unknown 14 4
13521 13521 13520 {"type": "Polygon", "coordinates": [[[-117.25009, 33.02695], [-117.24992, 33.02756], [-117.24973, 33.02758], [-117.24966, 33.0277], [-117.2497, 33.02792], [-117.24915, 33.02826], [-117.24915, 33.02722], [-117.24995, 33.02692], [-117.25009, 33.02695]]]} Open Access 1 35818 Encinitas holding 28 18655 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 1.842 Encinitas holding 28 0 Local Other or Unknown 14 4
13539 13539 13538 {"type": "Polygon", "coordinates": [[[-117.25535, 33.02689], [-117.25534, 33.02898], [-117.25128, 33.02906], [-117.2513, 33.02725], [-117.25342, 33.02724], [-117.25342, 33.0256], [-117.254, 33.02648], [-117.25474, 33.0268], [-117.25483, 33.02681], [-117.25471, 33.02689], [-117.2546, 33.02701], [-117.25456, 33.02725], [-117.25397, 33.02765], [-117.25373, 33.02775], [-117.25324, 33.02793], [-117.25311, 33.02796], [-117.25294, 33.02798], [-117.25266, 33.02794], [-117.25253, 33.02801], [-117.25239, 33.02798], [-117.25232, 33.028], [-117.25207, 33.02796], [-117.25171, 33.02806], [-117.25159, 33.0282], [-117.25156, 33.02832], [-117.25161, 33.02851], [-117.25164, 33.02857], [-117.25179, 33.02864], [-117.25193, 33.02864], [-117.25228, 33.02858], [-117.25241, 33.02857], [-117.25275, 33.02876], [-117.25302, 33.02883], [-117.25333, 33.02882], [-117.25358, 33.02876], [-117.25375, 33.0287], [-117.25448, 33.02862], [-117.25459, 33.0287], [-117.25478, 33.0287], [-117.25495, 33.02852], [-117.25504, 33.02837], [-117.25503, 33.02795], [-117.25505, 33.02785], [-117.25508, 33.02733], [-117.25508, 33.02708], [-117.25506, 33.02703], [-117.25506, 33.02696], [-117.25512, 33.02692], [-117.25517, 33.02685], [-117.25531, 33.02685], [-117.25533, 33.02685], [-117.25535, 33.02689]]]} Open Access 1 35847 Encinitas holding 5 18664 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 13.377 Encinitas holding 5 0 Local Other or Unknown 14 4
13551 13551 13550 {"type": "Polygon", "coordinates": [[[-117.25536, 33.02438], [-117.25535, 33.02541], [-117.25342, 33.02542], [-117.25342, 33.02439], [-117.25362, 33.02439], [-117.25363, 33.02473], [-117.25402, 33.02473], [-117.2542, 33.02486], [-117.25429, 33.02485], [-117.25449, 33.02468], [-117.25468, 33.02484], [-117.25469, 33.02535], [-117.25502, 33.02536], [-117.25504, 33.02527], [-117.2549, 33.0252], [-117.25481, 33.02506], [-117.25478, 33.02493], [-117.25484, 33.02488], [-117.255, 33.02488], [-117.25511, 33.02493], [-117.25512, 33.02466], [-117.25501, 33.02445], [-117.25501, 33.02442], [-117.25504, 33.02438], [-117.25536, 33.02438]]]} Open Access 1 35867 Encinitas holding 19 18650 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 3.335 Encinitas holding 19 0 Local Other or Unknown 14 4
13552 13552 13551 {"type": "Polygon", "coordinates": [[[-117.28549, 33.07638], [-117.28536, 33.07638], [-117.28543, 33.07582], [-117.28549, 33.07638], [-117.28549, 33.07638]]]} Open Access 1 35868 Encinitas holding 17 18648 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 0.092 Encinitas holding 17 0 Local Other or Unknown 14 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);