units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
86 rows where MNG_AGENCY = 73 sorted by ACCESS_TYP
This data as json, copyable, CSV (advanced)
ACCESS_TYP 4
DES_TP 2
MNG_AG_TYP 1
- State Agency 66
MNG_AGENCY 1
- California State Lands Commission · 66 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10779 | 10779 | 10778 | {"type": "MultiPolygon", "coordinates": [[[[-122.80581, 40.67638], [-122.78632, 40.67559], [-122.78636, 40.67208], [-122.80557, 40.67282], [-122.80581, 40.67638]]], [[[-122.83024, 40.67951], [-122.8257, 40.6766], [-122.8257, 40.67656], [-122.82609, 40.67658], [-122.83023, 40.67923], [-122.83024, 40.67951]]], [[[-122.91609, 40.73102], [-122.9161, 40.73443], [-122.91608, 40.73806], [-122.91359, 40.73803], [-122.9067, 40.73817], [-122.90682, 40.73445], [-122.90143, 40.7345], [-122.90228, 40.73062], [-122.90236, 40.72698], [-122.91156, 40.72706], [-122.91136, 40.73073], [-122.91609, 40.73102]]], [[[-122.96609, 40.54363], [-122.9614, 40.54362], [-122.96132, 40.53685], [-122.96595, 40.53686], [-122.96609, 40.54363]]], [[[-122.96699, 40.93183], [-122.96486, 40.93187], [-122.96485, 40.92817], [-122.96697, 40.92815], [-122.96699, 40.93183]]], [[[-123.11931, 40.78596], [-123.11673, 40.80306], [-123.11639, 40.80517], [-123.10821, 40.80369], [-123.10734, 40.8034], [-123.10909, 40.79131], [-123.11363, 40.79122], [-123.11367, 40.79094], [-123.11369, 40.79093], [-123.11436, 40.78648], [-123.11931, 40.78596]]], [[[-123.34911, 39.98158], [-123.34905, 39.98522], [-123.34426, 39.98532], [-123.34431, 39.98174], [-123.34438, 39.98165], [-123.34911, 39.98158]]]]} | Open Access 1 | 23453 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Trinity 46 | 913.572 | SLC | 0 | State Resource Management Area 55 | 3 | |
11218 | 11218 | 11217 | {"type": "MultiPolygon", "coordinates": [[[[-120.15811, 38.6645], [-120.15778, 38.67173], [-120.14871, 38.67204], [-120.14897, 38.66843], [-120.15345, 38.66827], [-120.15367, 38.66465], [-120.15811, 38.6645]]], [[[-120.75259, 38.79792], [-120.75256, 38.79835], [-120.75144, 38.79968], [-120.75107, 38.79963], [-120.75082, 38.79955], [-120.75079, 38.79887], [-120.75044, 38.79879], [-120.74936, 38.79877], [-120.74903, 38.79884], [-120.74868, 38.79906], [-120.74836, 38.79945], [-120.74801, 38.79969], [-120.74748, 38.79971], [-120.74705, 38.79952], [-120.74684, 38.79907], [-120.74742, 38.79818], [-120.74848, 38.79813], [-120.74883, 38.79806], [-120.74953, 38.79765], [-120.75032, 38.79701], [-120.75107, 38.7968], [-120.75151, 38.79687], [-120.752, 38.79723], [-120.75259, 38.79792]]]]} | Open Access 1 | 21547 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | El Dorado 34 | 137.473 | SLC | 0 | State Resource Management Area 55 | 3 | |
11242 | 11242 | 11241 | {"type": "MultiPolygon", "coordinates": [[[[-122.26313, 41.6087], [-122.263, 41.62322], [-122.244, 41.6232], [-122.24399, 41.62302], [-122.2437, 41.62303], [-122.24374, 41.60872], [-122.26313, 41.6087]]], [[[-122.7345, 41.87651], [-122.73344, 41.8872], [-122.72901, 41.88721], [-122.72948, 41.88009], [-122.72483, 41.88007], [-122.72456, 41.88722], [-122.72009, 41.88722], [-122.7202, 41.87272], [-122.72509, 41.87276], [-122.72997, 41.87283], [-122.72973, 41.87646], [-122.7345, 41.87651]]], [[[-123.01096, 41.33145], [-123.01076, 41.3351], [-123.00557, 41.33523], [-123.00561, 41.33157], [-123.01096, 41.33145]]], [[[-123.08699, 41.20564], [-123.07726, 41.20574], [-123.07748, 41.20213], [-123.08229, 41.20201], [-123.08234, 41.19849], [-123.08692, 41.19841], [-123.08699, 41.20564]]], [[[-123.23721, 41.40186], [-123.23716, 41.40911], [-123.23243, 41.40908], [-123.23246, 41.40187], [-123.23721, 41.40186]]]]} | Open Access 1 | 21645 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Siskiyou 28 | 1229.602 | SLC | 0 | State Resource Management Area 55 | 3 | |
11548 | 11548 | 11547 | {"type": "Polygon", "coordinates": [[[-121.01476, 41.91316], [-121.01476, 41.9204], [-121.00504, 41.92032], [-121.00501, 41.91672], [-120.99031, 41.91664], [-120.99007, 41.91308], [-121.00499, 41.91311], [-121.00502, 41.91671], [-121.00986, 41.91674], [-121.00987, 41.91673], [-121.00986, 41.91312], [-121.01476, 41.91316]]]} | Open Access 1 | 23627 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Modoc 56 | 241.472 | SLC | 0 | State Resource Management Area 55 | 3 | |
11562 | 11562 | 11561 | {"type": "Polygon", "coordinates": [[[-120.16674, 38.50827], [-120.15343, 38.50783], [-120.1532, 38.50427], [-120.16663, 38.5047], [-120.16674, 38.50827]]]} | Open Access 1 | 23576 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Amador 52 | 113.944 | SLC | 0 | State Resource Management Area 55 | 3 | |
11563 | 11563 | 11562 | {"type": "Polygon", "coordinates": [[[-122.064, 36.98385], [-122.06366, 36.98401], [-122.06267, 36.98408], [-122.06257, 36.98463], [-122.06235, 36.98486], [-122.06189, 36.98495], [-122.06155, 36.98351], [-122.06155, 36.98317], [-122.06189, 36.98305], [-122.06343, 36.98349], [-122.06394, 36.98377], [-122.064, 36.98385]]]} | Open Access 1 | 23588 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Santa Cruz 5 | 5.72 | SLC | 0 | State Resource Management Area 55 | 3 | |
12983 | 12983 | 12982 | {"type": "Polygon", "coordinates": [[[-119.01902, 36.735], [-119.019, 36.73858], [-119.01004, 36.73851], [-119.01008, 36.73493], [-119.01902, 36.735]]]} | Open Access 1 | 44769 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Fresno 9 | 78.552 | SLC | 0 | State Resource Management Area 55 | 3 | |
14331 | 14331 | 14330 | {"type": "Polygon", "coordinates": [[[-115.76535, 35.61555], [-115.74758, 35.61563], [-115.74758, 35.60112], [-115.76532, 35.60093], [-115.76535, 35.61555]]]} | Open Access 1 | 44321 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | San Bernardino 22 | 642.434 | SLC | 0 | State Resource Management Area 55 | 3 | |
14332 | 14332 | 14331 | {"type": "Polygon", "coordinates": [[[-115.00291, 34.87591], [-114.9853, 34.87592], [-114.98527, 34.86141], [-115.0029, 34.8614], [-115.00291, 34.87591]]]} | Open Access 1 | 44323 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | San Bernardino 22 | 640.775 | SLC | 0 | State Resource Management Area 55 | 3 | |
14371 | 14371 | 14370 | {"type": "Polygon", "coordinates": [[[-115.26829, 34.55721], [-115.26828, 34.57171], [-115.25094, 34.57173], [-115.25091, 34.5681], [-115.2509, 34.55723], [-115.26056, 34.55721], [-115.26829, 34.55721]]]} | Open Access 1 | 44455 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | San Bernardino 22 | 633.958 | SLC | 0 | State Resource Management Area 55 | 3 | |
14574 | 14574 | 14573 | {"type": "MultiPolygon", "coordinates": [[[[-115.27382, 35.21487], [-115.25611, 35.21492], [-115.2561, 35.21221], [-115.25612, 35.20769], [-115.25612, 35.20045], [-115.2738, 35.2004], [-115.27382, 35.21487]]], [[[-115.60685, 35.11645], [-115.60683, 35.13095], [-115.58867, 35.13096], [-115.58869, 35.11646], [-115.60685, 35.11645]]], [[[-115.7169, 35.21831], [-115.69787, 35.21826], [-115.69773, 35.20367], [-115.71685, 35.2037], [-115.7169, 35.21831]]], [[[-115.77179, 35.33564], [-115.77167, 35.34969], [-115.75363, 35.3497], [-115.75389, 35.33585], [-115.77179, 35.33564]]], [[[-115.93462, 35.13209], [-115.91697, 35.13165], [-115.9169, 35.1244], [-115.9168, 35.11715], [-115.93444, 35.11754], [-115.93462, 35.13209]]]]} | Open Access 1 | 44745 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | San Bernardino 22 | 3258.082 | SLC | 0 | State Resource Management Area 55 | 3 | |
14581 | 14581 | 14580 | {"type": "MultiPolygon", "coordinates": [[[[-120.03471, 41.86345], [-120.01526, 41.8635], [-120.01527, 41.85244], [-120.02011, 41.85252], [-120.02022, 41.8488], [-120.03463, 41.84892], [-120.03471, 41.86345]]], [[[-120.04633, 41.6883], [-120.02696, 41.68821], [-120.0269, 41.67368], [-120.04619, 41.67391], [-120.04633, 41.6883]]], [[[-120.04675, 41.51419], [-120.02739, 41.51418], [-120.02743, 41.49983], [-120.04672, 41.49973], [-120.04675, 41.51419]]], [[[-120.04814, 41.77623], [-120.02874, 41.77636], [-120.0287, 41.76148], [-120.0481, 41.76138], [-120.04814, 41.77623]]], [[[-120.09123, 41.72831], [-120.08644, 41.72823], [-120.08643, 41.71744], [-120.0887, 41.71744], [-120.08886, 41.71797], [-120.0892, 41.71888], [-120.08922, 41.71902], [-120.08925, 41.71998], [-120.08923, 41.72034], [-120.08926, 41.72061], [-120.08939, 41.72088], [-120.08953, 41.72106], [-120.08969, 41.7212], [-120.08974, 41.72128], [-120.08981, 41.7216], [-120.09006, 41.72374], [-120.09027, 41.72515], [-120.09095, 41.72658], [-120.09099, 41.72671], [-120.09097, 41.72719], [-120.09104, 41.72734], [-120.09123, 41.72764], [-120.09123, 41.72831]]], [[[-120.10578, 41.72154], [-120.10462, 41.72327], [-120.10182, 41.72432], [-120.10022, 41.72568], [-120.10096, 41.73181], [-120.09612, 41.73181], [-120.09623, 41.72839], [-120.09134, 41.72831], [-120.09134, 41.72762], [-120.0913, 41.72753], [-120.09114, 41.72731], [-120.09108, 41.72717], [-120.0911, 41.7267], [-120.09106, 41.72656], [-120.09038, 41.72513], [-120.09017, 41.72373], [-120.08992, 41.72159], [-120.08984, 41.72126], [-120.08979, 41.72116], [-120.08955, 41.72093], [-120.08949, 41.72084], [-120.08936, 41.72059], [-120.08934, 41.72034], [-120.08936, 41.71998], [-120.08933, 41.71901], [-120.08931, 41.71887], [-120.08897, 41.71795], [-120.08881, 41.71744], [-120.09616, 41.71744], [-120.10577, 41.71734], [-120.10578, 41.72154]]], [[[-120.1481, 41.60023], [-120.14805, 41.60233], [-120.1432, 41.60226], [-120.14321, 41.59826], [-120.14458, 41.60079], [-120.1481, 41.60023]]], [[[-120.25835, 41.94328], [-120.25353, 41.94324], [-120.25343, 41.93598], [-120.25829, 41.93597], [-120.25835, 41.94328]]], [[[-120.48647, 41.66042], [-120.4668, 41.6606], [-120.46683, 41.64603], [-120.48635, 41.64594], [-120.48647, 41.66042]]], [[[-120.87697, 41.93055], [-120.87697, 41.93417], [-120.87334, 41.93416], [-120.87331, 41.93054], [-120.87697, 41.93055]]], [[[-120.95282, 41.68619], [-120.94791, 41.68629], [-120.94313, 41.68636], [-120.94296, 41.67901], [-120.9474, 41.67906], [-120.95235, 41.679], [-120.95282, 41.68619]]], [[[-120.95369, 41.823], [-120.95368, 41.82662], [-120.94875, 41.82658], [-120.94881, 41.82296], [-120.94398, 41.82292], [-120.94403, 41.81941], [-120.94887, 41.8194], [-120.94881, 41.82296], [-120.95369, 41.823]]], [[[-121.16915, 41.74891], [-121.16424, 41.74888], [-121.16422, 41.74528], [-121.16913, 41.74531], [-121.16915, 41.74891]]], [[[-121.30003, 41.99731], [-121.29512, 41.99737], [-121.29506, 41.99424], [-121.29995, 41.9943], [-121.30003, 41.99731]]]]} | Open Access 1 | 44718 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Modoc 56 | 4096.771 | SLC | 0 | State Resource Management Area 55 | 3 | |
14803 | 14803 | 14802 | {"type": "MultiPolygon", "coordinates": [[[[-116.17464, 32.69733], [-116.15733, 32.69758], [-116.15691, 32.68285], [-116.17365, 32.68294], [-116.17464, 32.69733]]], [[[-116.67842, 32.77602], [-116.67832, 32.78694], [-116.67406, 32.78701], [-116.67408, 32.77962], [-116.67412, 32.77604], [-116.67842, 32.77602]]]]} | Open Access 1 | 45219 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | San Diego 4 | 757.572 | SLC | 0 | State Resource Management Area 55 | 3 | |
15513 | 15513 | 15512 | {"type": "Polygon", "coordinates": [[[-121.03855, 39.55161], [-121.03816, 39.55198], [-121.0378, 39.55215], [-121.03733, 39.55232], [-121.03708, 39.55244], [-121.03705, 39.55083], [-121.03851, 39.55084], [-121.03849, 39.55098], [-121.0385, 39.5513], [-121.03855, 39.55161]]]} | Open Access 1 | 44776 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Sierra 58 | 4.373 | SLC | 0 | State Resource Management Area 55 | 3 | |
15765 | 15765 | 15764 | {"type": "MultiPolygon", "coordinates": [[[[-115.41577, 33.9071], [-115.41501, 33.90797], [-115.41501, 33.90797], [-115.41501, 33.90709], [-115.41577, 33.9071]]], [[[-115.42113, 33.90913], [-115.42096, 33.90966], [-115.42064, 33.90959], [-115.418, 33.91076], [-115.41661, 33.91075], [-115.42056, 33.909], [-115.42113, 33.90913]]], [[[-115.42044, 33.90739], [-115.41978, 33.90743], [-115.41945, 33.9035], [-115.42011, 33.90351], [-115.42044, 33.90739]]]]} | Open Access 1 | 44795 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Riverside 10 | 13.226 | SLC | 0 | State Resource Management Area 55 | 3 | |
16332 | 16332 | 16331 | {"type": "Polygon", "coordinates": [[[-120.85499, 39.14173], [-120.85496, 39.14255], [-120.85496, 39.14519], [-120.85489, 39.1452], [-120.8549, 39.14874], [-120.84548, 39.1481], [-120.84538, 39.14426], [-120.85019, 39.1447], [-120.85017, 39.14118], [-120.85499, 39.14173]]]} | Open Access 1 | 44761 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Placer 35 | 122.823 | SLC | 0 | State Resource Management Area 55 | 3 | |
16352 | 16352 | 16351 | {"type": "Polygon", "coordinates": [[[-117.3542, 33.60498], [-117.34984, 33.60488], [-117.34984, 33.60123], [-117.34548, 33.60113], [-117.3455, 33.59749], [-117.35419, 33.59768], [-117.3542, 33.60498]]]} | Open Access 1 | 44762 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Riverside 10 | 121.181 | SLC | 0 | State Resource Management Area 55 | 3 | |
16357 | 16357 | 16356 | {"type": "MultiPolygon", "coordinates": [[[[-119.40892, 37.09687], [-119.40888, 37.10414], [-119.40433, 37.10414], [-119.40438, 37.09688], [-119.40892, 37.09687]]], [[[-119.41801, 37.10775], [-119.41344, 37.10776], [-119.41343, 37.11139], [-119.40885, 37.1114], [-119.40887, 37.10777], [-119.41344, 37.10776], [-119.41346, 37.09687], [-119.418, 37.09686], [-119.41801, 37.10775]]]]} | Open Access 1 | 44763 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Fresno 9 | 242.067 | SLC | 0 | State Resource Management Area 55 | 3 | |
16362 | 16362 | 16361 | {"type": "Polygon", "coordinates": [[[-119.89135, 38.76567], [-119.89129, 38.77295], [-119.88657, 38.7729], [-119.88658, 38.76567], [-119.89135, 38.76567]]]} | Open Access 1 | 44766 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Alpine 51 | 82.078 | SLC | 0 | State Resource Management Area 55 | 3 | |
16424 | 16424 | 16423 | {"type": "Polygon", "coordinates": [[[-120.75625, 39.34502], [-120.75579, 39.34604], [-120.74658, 39.34587], [-120.74638, 39.34242], [-120.75565, 39.34249], [-120.7561, 39.34484], [-120.75625, 39.34502]]]} | Open Access 1 | 44772 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Nevada 30 | 78.319 | SLC | 0 | State Resource Management Area 55 | 3 |
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]);