units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
12 rows where COUNTY = 30, DES_TP = 16 and MNG_AGENCY = 663
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Truckee Donner Land Trust · 12 ✖
DES_TP 1
- Private Conservation · 12 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3727 | 3727 | 3726 | {"type": "Polygon", "coordinates": [[[-120.32345, 39.33671], [-120.3234, 39.34127], [-120.32299, 39.34101], [-120.32265, 39.34077], [-120.32228, 39.34045], [-120.32201, 39.34015], [-120.32153, 39.34008], [-120.32093, 39.34003], [-120.32032, 39.34001], [-120.31971, 39.34004], [-120.31923, 39.3401], [-120.31863, 39.3402], [-120.31805, 39.34034], [-120.31771, 39.34045], [-120.31717, 39.34065], [-120.31668, 39.34088], [-120.31619, 39.34104], [-120.31568, 39.34116], [-120.31508, 39.34124], [-120.31477, 39.34125], [-120.31439, 39.34124], [-120.31401, 39.34121], [-120.31363, 39.34115], [-120.31327, 39.34106], [-120.31298, 39.34097], [-120.31264, 39.34084], [-120.31231, 39.34069], [-120.31194, 39.34048], [-120.31154, 39.3402], [-120.30974, 39.33861], [-120.30976, 39.32935], [-120.30374, 39.32937], [-120.30257, 39.32779], [-120.30047, 39.327], [-120.3005, 39.32477], [-120.30262, 39.32573], [-120.30275, 39.32582], [-120.30359, 39.32655], [-120.30369, 39.32662], [-120.30385, 39.32668], [-120.30398, 39.32683], [-120.30532, 39.32712], [-120.30547, 39.32718], [-120.30564, 39.32721], [-120.30582, 39.32721], [-120.30698, 39.32728], [-120.30714, 39.32733], [-120.30729, 39.32734], [-120.30773, 39.32733], [-120.30793, 39.32728], [-120.30813, 39.32716], [-120.30826, 39.327], [-120.3083, 39.32687], [-120.30834, 39.32652], [-120.30839, 39.32651], [-120.30858, 39.32595], [-120.30977, 39.32581], [-120.30977, 39.32935], [-120.31894, 39.32949], [-120.31887, 39.3367], [-120.32345, 39.33671]]]} | Open Access 1 | 44733 | Billy Mack Canyon | 13404 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | Nevada 30 | 332.597 | Billy Mack Canyon | 0 | Private Conservation 16 | 2 | |
3827 | 3827 | 3826 | {"type": "Polygon", "coordinates": [[[-120.17654, 39.32492], [-120.17487, 39.32491], [-120.17493, 39.3262], [-120.17455, 39.3262], [-120.17317, 39.32605], [-120.17283, 39.32595], [-120.17234, 39.32577], [-120.1711, 39.32519], [-120.1711, 39.32516], [-120.17155, 39.32517], [-120.17157, 39.32479], [-120.17144, 39.32478], [-120.17146, 39.32437], [-120.17653, 39.32487], [-120.17654, 39.32492]]]} | Open Access 1 | 45265 | Wintercreek Wetland | 27653 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | Nevada 30 | 11.926 | Wintercreek Wetland | 0 | Private Conservation 16 | 2 | |
4157 | 4157 | 4156 | {"type": "Polygon", "coordinates": [[[-120.34514, 39.41737], [-120.34421, 39.41677], [-120.34406, 39.41676], [-120.32896, 39.41732], [-120.32908, 39.42472], [-120.32436, 39.42465], [-120.31983, 39.42454], [-120.32004, 39.43169], [-120.31949, 39.4321], [-120.3108, 39.43208], [-120.31057, 39.41725], [-120.32895, 39.41731], [-120.32887, 39.41663], [-120.32874, 39.40288], [-120.34493, 39.40292], [-120.34514, 39.41737]]]} | Open Access 1 | 44725 | Independence Lake - Carpenter Ridge | 13411 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | http://tdlandtrust.org/trails-maps | Nevada 30 | 1023.517 | Independence Lake - Carpenter Ridge | 0 | Private Conservation 16 | 2 |
7840 | 7840 | 7839 | {"type": "Polygon", "coordinates": [[[-120.31439, 39.32589], [-120.30989, 39.32587], [-120.30989, 39.32587], [-120.3099, 39.32575], [-120.31057, 39.32566], [-120.31114, 39.3258], [-120.31114, 39.32582], [-120.31118, 39.32583], [-120.31147, 39.32585], [-120.31172, 39.32584], [-120.31196, 39.32579], [-120.31214, 39.32573], [-120.31231, 39.32565], [-120.31253, 39.3255], [-120.31271, 39.32531], [-120.31278, 39.32519], [-120.31276, 39.32517], [-120.31284, 39.32496], [-120.31289, 39.32477], [-120.31291, 39.32449], [-120.31283, 39.32391], [-120.31283, 39.32376], [-120.31286, 39.3236], [-120.31293, 39.32342], [-120.31302, 39.32328], [-120.3132, 39.32309], [-120.31345, 39.32296], [-120.31387, 39.32282], [-120.31401, 39.32274], [-120.31418, 39.3226], [-120.31432, 39.3224], [-120.31439, 39.32589]]]} | Open Access 1 | 48983 | Black Wall | 33678 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.truckeedonnerlandtrust.org/ | Nevada 30 | 11.753 | Black Wall | 0 | Private Conservation 16 | 2 |
7895 | 7895 | 7894 | {"type": "Polygon", "coordinates": [[[-120.29922, 39.32203], [-120.29646, 39.32199], [-120.29619, 39.32189], [-120.29604, 39.32171], [-120.29531, 39.32159], [-120.29539, 39.32128], [-120.29584, 39.32142], [-120.2959, 39.32131], [-120.29584, 39.32107], [-120.29593, 39.32107], [-120.296, 39.32135], [-120.29622, 39.32136], [-120.29622, 39.32149], [-120.2965, 39.32167], [-120.29679, 39.32181], [-120.29709, 39.32187], [-120.29719, 39.32187], [-120.29746, 39.32194], [-120.29812, 39.32159], [-120.29922, 39.32203]]]} | Open Access 1 | 48985 | Creekside Woods | 33680 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.truckeedonnerlandtrust.org/ | Nevada 30 | 2.295 | Creekside Woods | 0 | Private Conservation 16 | 2 |
8040 | 8040 | 8039 | {"type": "MultiPolygon", "coordinates": [[[[-120.41385, 39.31655], [-120.41384, 39.31921], [-120.41343, 39.31919], [-120.41282, 39.31875], [-120.41271, 39.31852], [-120.41259, 39.3185], [-120.41233, 39.31836], [-120.412, 39.31825], [-120.41182, 39.31811], [-120.41133, 39.31805], [-120.41101, 39.31794], [-120.41066, 39.3175], [-120.4103, 39.31718], [-120.40992, 39.317], [-120.40933, 39.31679], [-120.40872, 39.31671], [-120.40787, 39.31671], [-120.40744, 39.31683], [-120.40687, 39.3169], [-120.40612, 39.3169], [-120.40579, 39.31706], [-120.40456, 39.31715], [-120.40394, 39.31713], [-120.40334, 39.31705], [-120.40231, 39.31658], [-120.40209, 39.31651], [-120.40189, 39.31648], [-120.40153, 39.31647], [-120.40118, 39.31648], [-120.40085, 39.31661], [-120.4007, 39.31678], [-120.40012, 39.31706], [-120.39978, 39.31717], [-120.39977, 39.31629], [-120.41385, 39.31655]]], [[[-120.4117, 39.31863], [-120.41116, 39.31866], [-120.41086, 39.31879], [-120.4098, 39.31934], [-120.4091, 39.3195], [-120.40852, 39.31953], [-120.40761, 39.31939], [-120.40694, 39.31937], [-120.40597, 39.31958], [-120.40564, 39.3197], [-120.40535, 39.31977], [-120.40522, 39.31978], [-120.40482, 39.31977], [-120.40444, 39.31971], [-120.40431, 39.31968], [-120.40369, 39.31941], [-120.40314, 39.31933], [-120.40241, 39.31927], [-120.40115, 39.31902], [-120.40052, 39.31907], [-120.39978, 39.31934], [-120.39978, 39.31737], [-120.39992, 39.31755], [-120.40026, 39.31782], [-120.40048, 39.31823], [-120.40077, 39.31846], [-120.40164, 39.31848], [-120.40219, 39.31826], [-120.40327, 39.31838], [-120.40413, 39.31853], [-120.40459, 39.3189], [-120.40572, 39.31895], [-120.40642, 39.31906], [-120.407, 39.3191], [-120.40768, 39.31884], [-120.40809, 39.3185], [-120.40851, 39.31836], [-120.40912, 39.31812], [-120.41036, 39.31813], [-120.41111, 39.31851], [-120.4117, 39.31863]]], [[[-120.41384, 39.31927], [-120.41384, 39.31982], [-120.40913, 39.31988], [-120.39979, 39.31996], [-120.39978, 39.31941], [-120.40055, 39.31913], [-120.40118, 39.31909], [-120.4024, 39.31933], [-120.40313, 39.31938], [-120.40365, 39.31948], [-120.40432, 39.31974], [-120.40483, 39.31983], [-120.40535, 39.31983], [-120.40599, 39.31964], [-120.40698, 39.31943], [-120.40758, 39.31944], [-120.40854, 39.31959], [-120.40914, 39.31954], [-120.40985, 39.31939], [-120.41121, 39.31871], [-120.41184, 39.31868], [-120.41211, 39.31876], [-120.41278, 39.3188], [-120.41338, 39.31924], [-120.41384, 39.31927]]], [[[-120.41275, 39.31875], [-120.41208, 39.31869], [-120.41183, 39.31858], [-120.41117, 39.31846], [-120.41043, 39.31809], [-120.40998, 39.31805], [-120.40912, 39.31807], [-120.40806, 39.31843], [-120.40764, 39.3188], [-120.40701, 39.31904], [-120.40641, 39.319], [-120.40571, 39.31887], [-120.40464, 39.31883], [-120.40416, 39.31847], [-120.40307, 39.31828], [-120.40213, 39.3182], [-120.40164, 39.31843], [-120.40078, 39.31839], [-120.40056, 39.31821], [-120.4003, 39.31777], [-120.40002, 39.31752], [-120.39983, 39.31727], [-120.39984, 39.31723], [-120.39986, 39.3172], [-120.40016, 39.31712], [-120.40075, 39.31682], [-120.40091, 39.31666], [-120.4012, 39.31656], [-120.40153, 39.31654], [-120.40191, 39.31656], [-120.40209, 39.31659], [-120.4023, 39.31666], [-120.40258, 39.31677], [-120.40336, 39.3171], [-120.40395, 39.3172], [-120.40494, 39.3172], [-120.40583, 39.31711], [-120.40615, 39.31696], [-120.40689, 39.31695], [-120.40749, 39.3169], [-120.40788, 39.31677], [-120.40871, 39.31677], [-120.4093, 39.31686], [-120.41017, 39.3172], [-120.41034, 39.31732], [-120.41058, 39.31755], [-120.41078, 39.31782], [-120.41096, 39.31799], [-120.41136, 39.31811], [-120.41179, 39.31816], [-120.41199, 39.3183], [-120.41232, 39.31844], [-120.41253, 39.31856], [-120.41266, 39.31857], [-120.41275, 39.31875]]]]} | Open Access 1 | 48987 | Royal Gorge | 13417 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | http://tdlandtrust.org/royal-gorge | Nevada 30 | 109.491 | Royal Gorge | 0 | Private Conservation 16 | 2 |
8068 | 8068 | 8067 | {"type": "Polygon", "coordinates": [[[-120.1983, 39.31826], [-120.19732, 39.31893], [-120.19724, 39.31898], [-120.19794, 39.3181], [-120.1983, 39.31826]]]} | Open Access 1 | 48988 | Hoseit | 33682 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.truckeedonnerlandtrust.org/ | Nevada 30 | 0.508 | Hoseit | 0 | Private Conservation 16 | 2 |
11171 | 11171 | 11170 | {"type": "Polygon", "coordinates": [[[-120.28244, 39.40266], [-120.28231, 39.40268], [-120.28233, 39.40632], [-120.27294, 39.40633], [-120.2729, 39.40267], [-120.2683, 39.40265], [-120.26824, 39.3989], [-120.2589, 39.39888], [-120.25877, 39.39522], [-120.25396, 39.39525], [-120.25388, 39.3879], [-120.25851, 39.38786], [-120.25866, 39.39153], [-120.26352, 39.3915], [-120.26339, 39.38783], [-120.27272, 39.38778], [-120.27276, 39.39143], [-120.27129, 39.39145], [-120.27079, 39.39143], [-120.26353, 39.3915], [-120.26365, 39.39517], [-120.27279, 39.39517], [-120.2728, 39.39515], [-120.27279, 39.39492], [-120.27492, 39.39514], [-120.27539, 39.39516], [-120.28214, 39.39514], [-120.28228, 39.40185], [-120.28244, 39.40266]]]} | Open Access 1 | 48008 | Lower Carpenter Valley | 32437 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | http://tdlandtrust.org/carpenter-valley-0 | Nevada 30 | 617.118 | Lower Carpenter Valley | 0 | Private Conservation 16 | 2 |
14008 | 14008 | 14007 | {"type": "Polygon", "coordinates": [[[-120.45497, 39.44576], [-120.43752, 39.44578], [-120.43748, 39.43272], [-120.44146, 39.43275], [-120.44212, 39.43272], [-120.44281, 39.43275], [-120.45473, 39.43272], [-120.45489, 39.44426], [-120.45497, 39.44576]]]} | Restricted Access 2 | 37009 | Webber Lake and Lacey Meadows | 27324 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | Nevada 30 | 533.587 | Webber Lake and Lacey Meadows | 0 | Private Conservation 16 | 2 | |
14584 | 14584 | 14583 | {"type": "Polygon", "coordinates": [[[-120.32338, 39.34317], [-120.32337, 39.34391], [-120.30973, 39.34397], [-120.30044, 39.34397], [-120.30043, 39.34032], [-120.29116, 39.34034], [-120.29115, 39.34396], [-120.28206, 39.3438], [-120.28198, 39.33642], [-120.27966, 39.33639], [-120.27965, 39.33476], [-120.28196, 39.33477], [-120.28191, 39.33037], [-120.2869, 39.33201], [-120.28798, 39.33307], [-120.28812, 39.33318], [-120.28832, 39.33329], [-120.28851, 39.33336], [-120.28871, 39.3334], [-120.28896, 39.33341], [-120.2892, 39.33338], [-120.28943, 39.33331], [-120.28967, 39.33319], [-120.28981, 39.33307], [-120.28994, 39.33291], [-120.29003, 39.33273], [-120.29006, 39.3326], [-120.29007, 39.3324], [-120.29163, 39.33241], [-120.2958, 39.32982], [-120.2958, 39.33668], [-120.30043, 39.33667], [-120.30044, 39.33031], [-120.30249, 39.3316], [-120.30448, 39.33444], [-120.30612, 39.33836], [-120.30973, 39.34078], [-120.31011, 39.34112], [-120.31043, 39.34138], [-120.31078, 39.34162], [-120.31114, 39.34184], [-120.31153, 39.34204], [-120.31193, 39.34222], [-120.31235, 39.34237], [-120.31288, 39.34253], [-120.31344, 39.34266], [-120.31389, 39.34273], [-120.31435, 39.34278], [-120.31481, 39.3428], [-120.31527, 39.34279], [-120.31573, 39.34277], [-120.31619, 39.34271], [-120.31663, 39.34263], [-120.31729, 39.34247], [-120.3183, 39.34214], [-120.31859, 39.34207], [-120.31895, 39.34201], [-120.31924, 39.34197], [-120.31962, 39.34196], [-120.31999, 39.34196], [-120.32028, 39.34199], [-120.32072, 39.34205], [-120.32101, 39.34212], [-120.32163, 39.34232], [-120.32195, 39.34246], [-120.32238, 39.3427], [-120.3226, 39.34285], [-120.32291, 39.3431], [-120.32338, 39.34317]]]} | Open Access 1 | 44734 | Johnson Canyon | 29289 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | http://tdlandtrust.org/johnson-canyon | Nevada 30 | 641.093 | Johnson Canyon | 0 | Private Conservation 16 | 2 |
14585 | 14585 | 14584 | {"type": "Polygon", "coordinates": [[[-120.1985, 39.341], [-120.19845, 39.34424], [-120.17943, 39.34455], [-120.17943, 39.34424], [-120.17969, 39.34396], [-120.18014, 39.34412], [-120.18061, 39.34426], [-120.18171, 39.34424], [-120.18247, 39.3438], [-120.18272, 39.34372], [-120.18366, 39.34372], [-120.18416, 39.34369], [-120.18476, 39.34353], [-120.18527, 39.34319], [-120.18572, 39.34264], [-120.18598, 39.34247], [-120.18628, 39.34233], [-120.18721, 39.34214], [-120.18769, 39.34188], [-120.18792, 39.34173], [-120.18805, 39.34153], [-120.1888, 39.34074], [-120.18939, 39.3409], [-120.18979, 39.34087], [-120.19005, 39.34078], [-120.19057, 39.34047], [-120.19082, 39.33998], [-120.19107, 39.33982], [-120.19121, 39.33957], [-120.19121, 39.33919], [-120.19116, 39.33854], [-120.19179, 39.33851], [-120.1985, 39.341]]]} | Open Access 1 | 44735 | Pineforest | 23688 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | Nevada 30 | 129.963 | Pineforest | 0 | Private Conservation 16 | 2 | |
14586 | 14586 | 14585 | {"type": "Polygon", "coordinates": [[[-120.14177, 39.35025], [-120.14174, 39.35296], [-120.14057, 39.35297], [-120.14057, 39.35477], [-120.14173, 39.35477], [-120.14171, 39.35785], [-120.14068, 39.35831], [-120.1396, 39.35873], [-120.13963, 39.35209], [-120.13046, 39.35212], [-120.13046, 39.35028], [-120.13276, 39.35026], [-120.13814, 39.35026], [-120.13815, 39.35083], [-120.13887, 39.35083], [-120.13888, 39.35026], [-120.14177, 39.35025]], [[-120.13668, 39.35083], [-120.13667, 39.3514], [-120.1374, 39.3514], [-120.1374, 39.35083], [-120.13668, 39.35083]], [[-120.14103, 39.35141], [-120.14029, 39.3514], [-120.14029, 39.35197], [-120.14102, 39.35197], [-120.14103, 39.35141]]]} | Open Access 1 | 44737 | Airport Flats | 15301 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | Nevada 30 | 72.37 | Airport Flats | 0 | Private Conservation 16 | 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]);