units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
42 rows where COUNTY = 5 and MNG_AGENCY = 13 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20 | 20 | 19 | {"type": "Polygon", "coordinates": [[[-121.7511, 36.90667], [-121.74954, 36.9078], [-121.74933, 36.90761], [-121.75087, 36.90647], [-121.7511, 36.90667]]]} | Open Access 1 | 76 | River Park | 24419 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 1.349 | River Park | 0 | Local Park 2 | 4 | |
5813 | 5813 | 5812 | {"type": "Polygon", "coordinates": [[[-121.75218, 36.90885], [-121.75199, 36.90899], [-121.75154, 36.90859], [-121.75172, 36.90846], [-121.75218, 36.90885]]]} | Open Access 1 | 86 | Riverside Mini Park | 24452 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.338 | Riverside MP | 0 | Local Park 2 | 4 | |
87 | 87 | 86 | {"type": "Polygon", "coordinates": [[[-121.74459, 36.92013], [-121.74445, 36.92037], [-121.74431, 36.92032], [-121.74415, 36.92034], [-121.744, 36.92028], [-121.74398, 36.92024], [-121.74411, 36.92], [-121.74416, 36.91997], [-121.7442, 36.91998], [-121.74459, 36.92013]]]} | Open Access 1 | 247 | Brentwood Park | 16362 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.377 | Brentwood Park | 0 | Local Park 2 | 4 | |
155 | 155 | 154 | {"type": "Polygon", "coordinates": [[[-121.7428, 36.9182], [-121.74279, 36.91824], [-121.7426, 36.9185], [-121.74256, 36.91853], [-121.7425, 36.91852], [-121.74237, 36.91846], [-121.74233, 36.91842], [-121.74234, 36.91838], [-121.74253, 36.91813], [-121.74258, 36.9181], [-121.74265, 36.9181], [-121.74277, 36.91816], [-121.7428, 36.9182]]]} | Open Access 1 | 417 | Bronte Park | 16417 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.287 | Bronte Park | 0 | Local Park 2 | 4 | |
281 | 281 | 280 | {"type": "Polygon", "coordinates": [[[-121.77782, 36.90425], [-121.77774, 36.90416], [-121.77761, 36.90412], [-121.77715, 36.90423], [-121.77705, 36.90428], [-121.77614, 36.9049], [-121.77607, 36.90497], [-121.77603, 36.90505], [-121.77603, 36.90513], [-121.77637, 36.90605], [-121.77639, 36.90628], [-121.77634, 36.9065], [-121.77621, 36.90671], [-121.77602, 36.90687], [-121.77579, 36.90699], [-121.77611, 36.90644], [-121.7747, 36.90471], [-121.77763, 36.90374], [-121.77782, 36.90425]]]} | Open Access 1 | 754 | Seaview Park | 25273 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 6.282 | Seaview Park | 0 | Local Park 2 | 4 | |
6103 | 6103 | 6102 | {"type": "Polygon", "coordinates": [[[-121.803, 36.93287], [-121.80054, 36.93485], [-121.80069, 36.93581], [-121.80042, 36.94027], [-121.79899, 36.9403], [-121.79906, 36.93611], [-121.79906, 36.93551], [-121.79912, 36.93392], [-121.80104, 36.93237], [-121.80218, 36.93152], [-121.80231, 36.93209], [-121.80248, 36.93249], [-121.803, 36.93287]]]} | Open Access 1 | 1018 | Buena Vista Park | 16497 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 35.267 | Buena Vista Park | 0 | Local Park 2 | 4 | |
6156 | 6156 | 6155 | {"type": "MultiPolygon", "coordinates": [[[[-121.78291, 36.91621], [-121.78256, 36.91719], [-121.78052, 36.91505], [-121.78046, 36.91505], [-121.78046, 36.91507], [-121.78205, 36.91673], [-121.7818, 36.91671], [-121.78152, 36.91672], [-121.78124, 36.91665], [-121.78115, 36.91624], [-121.78093, 36.91599], [-121.78049, 36.91589], [-121.78022, 36.9166], [-121.77992, 36.91692], [-121.78009, 36.91729], [-121.77988, 36.91746], [-121.77968, 36.91742], [-121.77949, 36.91735], [-121.77903, 36.91738], [-121.77991, 36.91507], [-121.7799, 36.91506], [-121.77903, 36.91506], [-121.77873, 36.91504], [-121.77879, 36.91477], [-121.77937, 36.91429], [-121.77963, 36.91378], [-121.77971, 36.91357], [-121.77975, 36.91322], [-121.77974, 36.9128], [-121.77975, 36.91269], [-121.77989, 36.91225], [-121.77985, 36.91009], [-121.77896, 36.91009], [-121.77856, 36.91033], [-121.77857, 36.91154], [-121.77852, 36.91173], [-121.77837, 36.91188], [-121.77817, 36.91197], [-121.77786, 36.91206], [-121.77758, 36.9122], [-121.7774, 36.91233], [-121.77715, 36.91221], [-121.77673, 36.91208], [-121.77722, 36.91156], [-121.77745, 36.91053], [-121.77591, 36.91037], [-121.77598, 36.91021], [-121.77805, 36.91048], [-121.77883, 36.90994], [-121.77934, 36.90977], [-121.7796, 36.90977], [-121.78003, 36.90997], [-121.78058, 36.90929], [-121.78185, 36.907], [-121.7823, 36.9077], [-121.78239, 36.90796], [-121.78242, 36.90824], [-121.78217, 36.90875], [-121.78208, 36.90927], [-121.7822, 36.90995], [-121.78191, 36.91045], [-121.78182, 36.91067], [-121.78188, 36.91089], [-121.78216, 36.91114], [-121.78196, 36.9113], [-121.78219, 36.91146], [-121.78236, 36.91136], [-121.78246, 36.91149], [-121.78202, 36.91206], [-121.7822, 36.91288], [-121.78242, 36.91344], [-121.78232, 36.91347], [-121.7823, 36.91365], [-121.78234, 36.9139], [-121.78209, 36.91426], [-121.78216, 36.91444], [-121.78204, 36.91461], [-121.78163, 36.91485], [-121.7812, 36.91487], [-121.7812, 36.91492], [-121.78121, 36.91493], [-121.78122, 36.91508], [-121.78205, 36.91593], [-121.78248, 36.91614], [-121.78291, 36.91621]], [[-121.78034, 36.91495], [-121.78035, 36.91493], [-121.78023, 36.91483], [-121.78019, 36.91496], [-121.78034, 36.91495]]], [[[-121.79241, 36.9166], [-121.79041, 36.91742], [-121.79014, 36.91691], [-121.7892, 36.91776], [-121.78899, 36.91741], [-121.78853, 36.91653], [-121.78866, 36.91621], [-121.78868, 36.91587], [-121.7886, 36.91553], [-121.78842, 36.91523], [-121.78815, 36.91497], [-121.78755, 36.91451], [-121.78726, 36.91412], [-121.78726, 36.91403], [-121.78733, 36.91397], [-121.78833, 36.91355], [-121.78831, 36.91349], [-121.7893, 36.91306], [-121.79027, 36.91424], [-121.7912, 36.9153], [-121.79144, 36.91551], [-121.79186, 36.91583], [-121.79198, 36.91594], [-121.79241, 36.9166]]], [[[-121.79536, 36.91187], [-121.79513, 36.91547], [-121.79465, 36.91567], [-121.79471, 36.91597], [-121.79454, 36.91611], [-121.79442, 36.91627], [-121.7944, 36.91634], [-121.79399, 36.91474], [-121.79383, 36.91475], [-121.79366, 36.91474], [-121.7935, 36.91467], [-121.79335, 36.91457], [-121.79305, 36.9141], [-121.79301, 36.91397], [-121.79295, 36.9137], [-121.79292, 36.91343], [-121.79291, 36.91315], [-121.79294, 36.91288], [-121.79309, 36.91235], [-121.79316, 36.91222], [-121.79337, 36.912], [-121.79355, 36.91177], [-121.7937, 36.91153], [-121.79374, 36.9114], [-121.79375, 36.91127], [-121.79364, 36.91115], [-121.79406, 36.91097], [-121.79536, 36.91187]]], [[[-121.79504, 36.91694], [-121.79497, 36.91818], [-121.79447, 36.91813], [-121.79454, 36.91704], [-121.79447, 36.91679], [-121.79469, 36.91689], [-121.79504, 36.91694]]]]} | Open Access 1 | 1166 | Struve Slough | 28148 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 105.317 | Struve Slough | 0 | Local Conservation Area 4 | 2 | |
418 | 418 | 417 | {"type": "MultiPolygon", "coordinates": [[[[-121.7791, 36.92112], [-121.77861, 36.92097], [-121.77814, 36.92117], [-121.77746, 36.9222], [-121.7769, 36.92436], [-121.77687, 36.92456], [-121.77667, 36.92366], [-121.77666, 36.92365], [-121.77613, 36.92561], [-121.77599, 36.92621], [-121.77601, 36.92699], [-121.77567, 36.92723], [-121.77534, 36.92621], [-121.77526, 36.92569], [-121.7753, 36.92516], [-121.77549, 36.92432], [-121.77552, 36.9241], [-121.77553, 36.92388], [-121.776, 36.92394], [-121.77606, 36.92283], [-121.77616, 36.92252], [-121.77623, 36.9219], [-121.77645, 36.92201], [-121.77717, 36.9225], [-121.77833, 36.91963], [-121.7791, 36.92112]]], [[[-121.77899, 36.91916], [-121.77866, 36.91936], [-121.77838, 36.91931], [-121.77842, 36.91897], [-121.77824, 36.91893], [-121.77848, 36.91836], [-121.77891, 36.91869], [-121.77899, 36.91916]]]]} | Open Access 1 | 1666 | Upper Struve Slough | 28147 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 15.625 | Upper Struve Slough | 0 | Local Conservation Area 4 | 2 | |
529 | 529 | 528 | {"type": "Polygon", "coordinates": [[[-121.74601, 36.9207], [-121.74537, 36.92053], [-121.74531, 36.92051], [-121.74535, 36.92045], [-121.74541, 36.92044], [-121.74598, 36.92066], [-121.74601, 36.9207]]]} | Open Access 1 | 1747 | Victorian Park | 27085 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.111 | Victorian Park | 0 | Local Park 2 | 4 | |
6358 | 6358 | 6357 | {"type": "Polygon", "coordinates": [[[-121.7604, 36.91664], [-121.75986, 36.918], [-121.75986, 36.918], [-121.75903, 36.91704], [-121.76019, 36.91639], [-121.7604, 36.91664]]]} | Open Access 1 | 1764 | Callaghan Park | 16732 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 2.53 | Callaghan Park | 0 | Local Park 2 | 4 | |
6985 | 6985 | 6984 | {"type": "Polygon", "coordinates": [[[-121.77997, 36.93361], [-121.77981, 36.9337], [-121.7796, 36.93345], [-121.77976, 36.93336], [-121.77997, 36.93361]]]} | Open Access 1 | 5908 | Cherry Blossom Pocket Park | 17165 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.151 | Cherry Blossom PP | 0 | Local Park 2 | 4 | |
7477 | 7477 | 7476 | {"type": "Polygon", "coordinates": [[[-121.75668, 36.91019], [-121.75601, 36.91068], [-121.75548, 36.91022], [-121.75616, 36.90974], [-121.75668, 36.91019]]]} | Open Access 1 | 6993 | City Plaza Park | 17345 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 1.381 | City Plaza Park | 0 | Local Park 2 | 4 | |
8022 | 8022 | 8021 | {"type": "Polygon", "coordinates": [[[-121.76021, 36.92854], [-121.75889, 36.92892], [-121.75862, 36.92828], [-121.75968, 36.92797], [-121.75973, 36.92797], [-121.75976, 36.92799], [-121.75992, 36.92823], [-121.76013, 36.92843], [-121.76021, 36.92854]]]} | Open Access 1 | 11355 | Crestview Park | 17813 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 2.145 | Crestview Park | 0 | Local Park 2 | 4 | |
8798 | 8798 | 8797 | {"type": "Polygon", "coordinates": [[[-121.76555, 36.93039], [-121.76552, 36.93052], [-121.76555, 36.93069], [-121.7655, 36.93072], [-121.76538, 36.93075], [-121.76533, 36.93074], [-121.76526, 36.93064], [-121.76515, 36.93064], [-121.76509, 36.93057], [-121.76509, 36.93054], [-121.76526, 36.93038], [-121.76549, 36.93037], [-121.76555, 36.93039]]]} | Open Access 1 | 14315 | Arista Park | 15585 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.301 | Arista Park | 0 | Local Park 2 | 4 | |
9341 | 9341 | 9340 | {"type": "Polygon", "coordinates": [[[-121.75749, 36.9143], [-121.75695, 36.9146], [-121.75683, 36.91447], [-121.75737, 36.91417], [-121.75749, 36.9143]]]} | Open Access 1 | 15609 | Emmett Courts Park | 18632 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.262 | Emmett Courts Park | 0 | Local Park 2 | 4 | |
5185 | 5185 | 5184 | {"type": "MultiPolygon", "coordinates": [[[[-121.75815, 36.92276], [-121.75776, 36.92297], [-121.75768, 36.92257], [-121.75788, 36.92246], [-121.75815, 36.92276]]], [[[-121.75848, 36.92319], [-121.75834, 36.92327], [-121.75787, 36.92353], [-121.75779, 36.92313], [-121.75822, 36.92289], [-121.75848, 36.92319]]]]} | Open Access 1 | 15866 | Flodberg Park | 18951 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.89 | Flodberg Park | 0 | Local Park 2 | 4 | |
9517 | 9517 | 9516 | {"type": "Polygon", "coordinates": [[[-121.74449, 36.92636], [-121.74449, 36.9264], [-121.74408, 36.92774], [-121.74406, 36.92788], [-121.74408, 36.92802], [-121.74191, 36.92759], [-121.74172, 36.92765], [-121.74168, 36.9276], [-121.74157, 36.92751], [-121.74143, 36.92745], [-121.74077, 36.92731], [-121.74115, 36.92581], [-121.74106, 36.92571], [-121.7411, 36.92569], [-121.74444, 36.92634], [-121.74449, 36.92636]]]} | Open Access 1 | 15972 | Franich Park | 19047 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 14.039 | Franich Park | 0 | Local Park 2 | 4 | |
9692 | 9692 | 9691 | {"type": "Polygon", "coordinates": [[[-121.82747, 36.9152], [-121.82607, 36.9168], [-121.82571, 36.91674], [-121.82537, 36.91664], [-121.82532, 36.91668], [-121.82468, 36.91634], [-121.82421, 36.91602], [-121.82368, 36.91571], [-121.82311, 36.91547], [-121.82248, 36.91531], [-121.82184, 36.91523], [-121.82145, 36.91524], [-121.82079, 36.91532], [-121.81964, 36.91555], [-121.81917, 36.91559], [-121.81862, 36.91557], [-121.81814, 36.91548], [-121.81777, 36.91537], [-121.81739, 36.91521], [-121.81705, 36.91502], [-121.81678, 36.91482], [-121.81457, 36.91299], [-121.8141, 36.91247], [-121.81373, 36.91189], [-121.81598, 36.91026], [-121.81956, 36.9132], [-121.82148, 36.91203], [-121.82242, 36.91172], [-121.82319, 36.91255], [-121.82441, 36.91278], [-121.82529, 36.91254], [-121.82747, 36.9152]]]} | Restricted Access 2 | 16377 | Gallighan Slough | 28151 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 98.834 | Gallighan Slough | 0 | Local Conservation Area 4 | 2 | |
1946 | 1946 | 1945 | {"type": "Polygon", "coordinates": [[[-121.76093, 36.91723], [-121.76076, 36.91733], [-121.76072, 36.91757], [-121.7608, 36.91771], [-121.76083, 36.91787], [-121.76082, 36.91797], [-121.76078, 36.91807], [-121.76066, 36.91822], [-121.76067, 36.91867], [-121.76061, 36.91868], [-121.76059, 36.91821], [-121.76052, 36.91809], [-121.7605, 36.91802], [-121.76049, 36.91789], [-121.7605, 36.91782], [-121.76055, 36.9177], [-121.76065, 36.91757], [-121.7607, 36.91729], [-121.76089, 36.91719], [-121.76093, 36.91723]]]} | Open Access 1 | 16647 | Gonzalez Pocket Park | 19401 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.54 | Gonzalez PP | 0 | Local Park 2 | 4 | |
2265 | 2265 | 2264 | {"type": "Polygon", "coordinates": [[[-121.80532, 36.92238], [-121.80509, 36.92259], [-121.80524, 36.92344], [-121.80501, 36.92403], [-121.80178, 36.92397], [-121.80168, 36.92488], [-121.80174, 36.92521], [-121.80015, 36.92537], [-121.7999, 36.92535], [-121.79967, 36.92527], [-121.79939, 36.92508], [-121.79917, 36.92485], [-121.79886, 36.92448], [-121.79865, 36.92435], [-121.79847, 36.92427], [-121.79754, 36.92367], [-121.79741, 36.92355], [-121.79735, 36.9234], [-121.79737, 36.92325], [-121.79743, 36.92324], [-121.79754, 36.92291], [-121.79743, 36.92286], [-121.79796, 36.92185], [-121.79855, 36.9219], [-121.80194, 36.92234], [-121.80196, 36.92219], [-121.80529, 36.92225], [-121.80532, 36.92238]]]} | Restricted Access 2 | 16755 | Harkins Slough | 28150 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 43.338 | Harkins Slough | 0 | Local Conservation Area 4 | 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]);