units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
651 rows where DES_TP = 2 and MNG_AG_TYP = 3 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 94
- San Diego, County of 67
- Orange, County of 43
- El Dorado, County of 42
- Santa Barbara, County of 40
- Kern, County of 37
- Santa Cruz, County of 33
- Stanislaus, County of 22
- San Luis Obispo, County of 20
- Riverside, County of 19
- Placer, County of 19
- Lake, County of 18
- San Joaquin, County of 18
- Monterey, County of 17
- Ventura, County of 15
- San Bernardino, County of 12
- Merced, County of 12
- Yolo, County of 12
- Tulare, County of 11
- Humboldt, County of 10
- Sacramento, County of 7
- Fresno, County of 6
- Tehama, County of 6
- Mendocino, County of 6
- Lassen, County of 6
- Mariposa, County of 5
- Mono, County of 5
- Imperial, County of 4
- Yuba, County of 4
- San Benito, County of 3
- …
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency · 642 ✖
DES_TP 1
- Local Park · 642 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7097 | 7097 | 7096 | {"type": "Polygon", "coordinates": [[[-119.69078, 36.4277], [-119.69074, 36.4293], [-119.69071, 36.42972], [-119.68743, 36.42975], [-119.6875, 36.42902], [-119.68794, 36.42907], [-119.68852, 36.42919], [-119.68938, 36.42931], [-119.6907, 36.42946], [-119.69073, 36.42931], [-119.6894, 36.42913], [-119.68851, 36.42901], [-119.68797, 36.42891], [-119.68748, 36.4288], [-119.68631, 36.42839], [-119.68641, 36.4269], [-119.68728, 36.42697], [-119.68779, 36.42691], [-119.68874, 36.42707], [-119.68941, 36.42695], [-119.69078, 36.4277]]]} | Open Access 1 | 6148 | Laton-Kingston Park | 21081 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 24.247 | Laton-Kingston Park | 0 | Local Park 2 | 4 | |
7225 | 7225 | 7224 | {"type": "Polygon", "coordinates": [[[-120.3761, 36.7807], [-120.37597, 36.7808], [-120.37571, 36.78105], [-120.37517, 36.78076], [-120.37455, 36.7806], [-120.37395, 36.78049], [-120.37328, 36.78048], [-120.37283, 36.78069], [-120.37245, 36.78082], [-120.3733, 36.78465], [-120.37121, 36.78454], [-120.37122, 36.78516], [-120.37026, 36.78491], [-120.36982, 36.78438], [-120.36952, 36.78374], [-120.36934, 36.78279], [-120.36939, 36.7821], [-120.36868, 36.78201], [-120.36858, 36.78167], [-120.36872, 36.78118], [-120.36855, 36.78059], [-120.36844, 36.78032], [-120.3689, 36.77975], [-120.36951, 36.7788], [-120.37032, 36.77791], [-120.37101, 36.77764], [-120.37204, 36.77738], [-120.37287, 36.77708], [-120.37248, 36.77796], [-120.37307, 36.77821], [-120.37357, 36.77857], [-120.37421, 36.77948], [-120.3754, 36.78023], [-120.3761, 36.7807]]]} | Open Access 1 | 6388 | Mendota Pool Park | 22152 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 72.242 | Mendota Pool Park | 0 | Local Park 2 | 4 | |
9453 | 9453 | 9452 | {"type": "MultiPolygon", "coordinates": [[[[-119.38326, 36.8181], [-119.3831, 36.81856], [-119.38303, 36.81856], [-119.38264, 36.81984], [-119.38193, 36.81963], [-119.38133, 36.8194], [-119.38067, 36.81912], [-119.38007, 36.81881], [-119.38007, 36.81813], [-119.38326, 36.8181]]], [[[-119.38697, 36.81641], [-119.38629, 36.81792], [-119.38469, 36.81923], [-119.38468, 36.81946], [-119.38457, 36.81953], [-119.38444, 36.81959], [-119.38406, 36.81964], [-119.38379, 36.81979], [-119.38354, 36.81989], [-119.38327, 36.81994], [-119.38307, 36.81994], [-119.38345, 36.81865], [-119.3834, 36.81863], [-119.38358, 36.8181], [-119.38367, 36.81809], [-119.38365, 36.81762], [-119.38373, 36.81712], [-119.38422, 36.81613], [-119.38451, 36.81438], [-119.38454, 36.81437], [-119.38449, 36.81163], [-119.38529, 36.81486], [-119.38697, 36.81641]]]]} | Open Access 1 | 15812 | Winton Park | 27659 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 37.979 | Winton Park | 0 | Local Park 2 | 4 | |
12296 | 12296 | 12295 | {"type": "Polygon", "coordinates": [[[-119.50625, 36.72095], [-119.50623, 36.7228], [-119.50624, 36.72462], [-119.50195, 36.72458], [-119.50192, 36.72283], [-119.50197, 36.72277], [-119.50198, 36.7227], [-119.50194, 36.72262], [-119.50188, 36.72258], [-119.5018, 36.72256], [-119.50169, 36.72257], [-119.50161, 36.72263], [-119.50158, 36.72271], [-119.5016, 36.72279], [-119.50166, 36.72285], [-119.5017, 36.72766], [-119.50164, 36.72783], [-119.50148, 36.72797], [-119.50134, 36.72816], [-119.49746, 36.72813], [-119.49741, 36.72098], [-119.50625, 36.72095]]]} | Open Access 1 | 25952 | China Creek Park | 17202 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 113.797 | China Creek Park | 0 | Local Park 2 | 4 | |
12297 | 12297 | 12296 | {"type": "Polygon", "coordinates": [[[-119.36499, 36.82156], [-119.36484, 36.82167], [-119.36465, 36.82269], [-119.3645, 36.82277], [-119.36352, 36.82264], [-119.36305, 36.8226], [-119.36273, 36.82261], [-119.36239, 36.82267], [-119.36177, 36.82273], [-119.36155, 36.82272], [-119.36075, 36.8225], [-119.36008, 36.82242], [-119.35953, 36.82239], [-119.35875, 36.82224], [-119.35845, 36.82216], [-119.35795, 36.82194], [-119.35762, 36.82183], [-119.35627, 36.82122], [-119.35558, 36.82116], [-119.35494, 36.82132], [-119.35425, 36.82166], [-119.3521, 36.82457], [-119.35158, 36.82517], [-119.3513, 36.82527], [-119.3507, 36.82524], [-119.35047, 36.82532], [-119.35029, 36.82541], [-119.34938, 36.82674], [-119.3481, 36.82793], [-119.34605, 36.82777], [-119.34969, 36.8246], [-119.35288, 36.82118], [-119.35294, 36.8202], [-119.354, 36.81915], [-119.35626, 36.81834], [-119.35729, 36.81815], [-119.35755, 36.81813], [-119.36022, 36.81832], [-119.36486, 36.81775], [-119.36499, 36.82156]]]} | Open Access 1 | 25953 | Choinumni Park | 17214 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 140.591 | Choinumni Park | 0 | Local Park 2 | 4 | |
12299 | 12299 | 12298 | {"type": "Polygon", "coordinates": [[[-119.44789, 36.74967], [-119.44787, 36.75316], [-119.44786, 36.75324], [-119.44785, 36.75402], [-119.44543, 36.75484], [-119.44438, 36.75684], [-119.44384, 36.75753], [-119.44321, 36.75812], [-119.4432, 36.75928], [-119.44317, 36.76005], [-119.44202, 36.76162], [-119.44126, 36.76044], [-119.43947, 36.76041], [-119.43884, 36.75948], [-119.43886, 36.75681], [-119.43707, 36.75679], [-119.43755, 36.7563], [-119.43776, 36.7561], [-119.43831, 36.75579], [-119.43972, 36.75506], [-119.4399, 36.75496], [-119.44006, 36.75484], [-119.44026, 36.75466], [-119.44042, 36.75443], [-119.44053, 36.75416], [-119.4406, 36.75388], [-119.44062, 36.75264], [-119.44234, 36.75208], [-119.44351, 36.75166], [-119.44407, 36.75142], [-119.44732, 36.74965], [-119.44789, 36.74967]]]} | Open Access 1 | 25954 | Kings River Green Belt Park | 20662 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 136.461 | Kings River Green Belt Park | 0 | Local Park 2 | 4 | |
1333 | 1333 | 1332 | {"type": "Polygon", "coordinates": [[[-114.72616, 33.40354], [-114.72479, 33.40354], [-114.72438, 33.40263], [-114.72394, 33.40197], [-114.72359, 33.40161], [-114.72338, 33.40102], [-114.72304, 33.4002], [-114.72212, 33.39886], [-114.72184, 33.39858], [-114.72184, 33.39738], [-114.72616, 33.40354]]]} | Open Access 1 | 7580 | Palo Verde County Park | 23359 | 302 | Imperial, County of 348 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | Imperial 20 | 13.919 | Palo Verde County Park | 0 | Local Park 2 | 4 | |
5232 | 5232 | 5231 | {"type": "Polygon", "coordinates": [[[-115.67682, 32.77663], [-115.67556, 32.77481], [-115.67435, 32.77444], [-115.67435, 32.77433], [-115.67607, 32.77424], [-115.67688, 32.77433], [-115.67741, 32.77427], [-115.68059, 32.77846], [-115.68065, 32.77892], [-115.68081, 32.77894], [-115.68079, 32.77953], [-115.68244, 32.77946], [-115.69028, 32.77921], [-115.69029, 32.78595], [-115.68677, 32.78484], [-115.68075, 32.78206], [-115.68075, 32.78136], [-115.68028, 32.78091], [-115.67977, 32.7807], [-115.67682, 32.77663]], [[-115.68079, 32.78028], [-115.68077, 32.78028], [-115.68076, 32.78078], [-115.68079, 32.78081], [-115.68079, 32.78028]]]} | Open Access 1 | 48074 | Sunbeam Lake Park | 32576 | 302 | Imperial, County of 348 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | https://www.co.imperial.ca.us/publicwork/index.asp?fileinc=parksunbeam | Imperial 20 | 154.391 | Sunbeam Lake Park | 0 | Local Park 2 | 4 |
5233 | 5233 | 5232 | {"type": "Polygon", "coordinates": [[[-115.69473, 32.7933], [-115.69278, 32.7933], [-115.69278, 32.79285], [-115.69341, 32.79284], [-115.69339, 32.79247], [-115.69472, 32.79247], [-115.69473, 32.7933]]]} | Open Access 1 | 48075 | Robert Bates Memorial Park | 32577 | 302 | Imperial, County of 348 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | http://www.seeleywaterdistrict.com/updates/robert-bates-memorial-park-upgrades | Imperial 20 | 3.525 | Robert Bates Memorial Park | 0 | Local Park 2 | 4 |
14960 | 14960 | 14959 | {"type": "Polygon", "coordinates": [[[-116.01947, 32.74748], [-116.01802, 32.74819], [-116.01696, 32.74871], [-116.01696, 32.74748], [-116.01947, 32.74748]]]} | Open Access 1 | 45623 | Ocotillo Community Park | 28449 | 302 | Imperial, County of 348 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | Imperial 20 | 3.974 | Ocotillo Community Park | 2007 | Local Park 2 | 4 | |
1932 | 1932 | 1931 | {"type": "Polygon", "coordinates": [[[-118.22001, 35.69046], [-118.21999, 35.69219], [-118.21919, 35.69218], [-118.21924, 35.69048], [-118.22001, 35.69046]]]} | Open Access 1 | 16545 | Scodie Park | 25200 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 3.31 | Scodie Park | 0 | Local Park 2 | 4 | |
2182 | 2182 | 2181 | {"type": "Polygon", "coordinates": [[[-118.99863, 35.33938], [-118.99644, 35.33938], [-118.99643, 35.33765], [-118.99862, 35.33765], [-118.99863, 35.33938]]]} | Open Access 1 | 16359 | Casa Loma County Park | 16930 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 9.443 | Casa Loma County Park | 0 | Local Park 2 | 4 | |
2188 | 2188 | 2187 | {"type": "Polygon", "coordinates": [[[-119.54923, 35.17866], [-119.54877, 35.17941], [-119.54719, 35.17942], [-119.54835, 35.1779], [-119.54872, 35.17789], [-119.54923, 35.17866]]]} | Open Access 1 | 16387 | Fellows Park | 18868 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 4.609 | Fellows Park | 0 | Local Park 2 | 4 | |
2190 | 2190 | 2189 | {"type": "Polygon", "coordinates": [[[-119.02436, 35.2737], [-119.0237, 35.27402], [-119.02322, 35.27401], [-119.02321, 35.27397], [-119.0215, 35.27396], [-119.02143, 35.2739], [-119.02143, 35.27309], [-119.02204, 35.27309], [-119.02204, 35.27227], [-119.02398, 35.27227], [-119.02436, 35.2737]]]} | Open Access 1 | 16448 | Kern Delta Park | 20628 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 10.326 | Kern Delta Park | 0 | Local Park 2 | 4 | |
2193 | 2193 | 2192 | {"type": "Polygon", "coordinates": [[[-118.97016, 35.38673], [-118.97014, 35.38783], [-118.96981, 35.38881], [-118.96979, 35.38931], [-118.96948, 35.39011], [-118.96765, 35.39012], [-118.96763, 35.38674], [-118.97016, 35.38673]]]} | Open Access 1 | 16430 | Heritage Park | 19841 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 19.25 | Heritage Park | 0 | Local Park 2 | 4 | |
2200 | 2200 | 2199 | {"type": "Polygon", "coordinates": [[[-118.91208, 35.25613], [-118.91208, 35.2578], [-118.90988, 35.25781], [-118.90989, 35.25614], [-118.91208, 35.25613]]]} | Open Access 1 | 16470 | Lamont Park | 20994 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 9.169 | Lamont Park | 0 | Local Park 2 | 4 | |
2204 | 2204 | 2203 | {"type": "Polygon", "coordinates": [[[-118.16724, 35.04691], [-118.16723, 35.04813], [-118.16709, 35.04816], [-118.1671, 35.04939], [-118.16668, 35.04939], [-118.16667, 35.04886], [-118.16569, 35.04886], [-118.16566, 35.04657], [-118.16724, 35.04691]]]} | Open Access 1 | 16500 | Mojave East Park | 22351 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 8.564 | Mojave East Park | 0 | Local Park 2 | 4 | |
2205 | 2205 | 2204 | {"type": "Polygon", "coordinates": [[[-119.00277, 35.40197], [-119.00276, 35.40298], [-119.00203, 35.40325], [-119.00138, 35.40357], [-119.0005, 35.40394], [-119.00016, 35.40412], [-118.99991, 35.40409], [-118.99977, 35.40441], [-118.999, 35.40483], [-118.9986, 35.40483], [-118.9986, 35.40507], [-118.99724, 35.40578], [-118.99686, 35.40581], [-118.99665, 35.40603], [-118.99636, 35.40609], [-118.99562, 35.40651], [-118.99558, 35.40669], [-118.99545, 35.40663], [-118.99528, 35.40671], [-118.99528, 35.40673], [-118.99552, 35.40695], [-118.99546, 35.4072], [-118.99501, 35.40745], [-118.99485, 35.40763], [-118.99485, 35.40765], [-118.99571, 35.40735], [-118.9961, 35.40689], [-118.99639, 35.40686], [-118.99628, 35.4071], [-118.99605, 35.40731], [-118.99612, 35.40752], [-118.99573, 35.40792], [-118.99544, 35.40799], [-118.99524, 35.40817], [-118.99522, 35.40846], [-118.99474, 35.40865], [-118.99475, 35.40889], [-118.99432, 35.40934], [-118.99402, 35.40968], [-118.99274, 35.40959], [-118.99233, 35.40968], [-118.99188, 35.4095], [-118.99158, 35.40909], [-118.99113, 35.4088], [-118.99057, 35.40903], [-118.99096, 35.40919], [-118.99097, 35.40959], [-118.99076, 35.40981], [-118.99079, 35.41005], [-118.99066, 35.41014], [-118.99016, 35.40945], [-118.98971, 35.40926], [-118.98942, 35.40926], [-118.98921, 35.40947], [-118.98837, 35.40934], [-118.9878, 35.40931], [-118.98706, 35.40935], [-118.98639, 35.40945], [-118.98596, 35.40962], [-118.98536, 35.40921], [-118.98804, 35.40916], [-118.98887, 35.40908], [-118.98934, 35.409], [-118.99003, 35.40883], [-118.99203, 35.40819], [-118.99235, 35.40806], [-118.99298, 35.40777], [-119.00172, 35.40303], [-119.00191, 35.4029], [-119.00214, 35.40272], [-119.00246, 35.40241], [-119.00272, 35.40207], [-119.00277, 35.40197]]]} | Open Access 1 | 16517 | Panorama Park | 23390 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 30.643 | Panorama Park | 0 | Local Park 2 | 4 | |
2206 | 2206 | 2205 | {"type": "Polygon", "coordinates": [[[-118.92977, 35.36702], [-118.92976, 35.3687], [-118.92755, 35.36872], [-118.92755, 35.36704], [-118.92977, 35.36702]]]} | Open Access 1 | 16521 | Pioneer Park | 23713 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 9.264 | Pioneer Park | 0 | Local Park 2 | 4 | |
2220 | 2220 | 2219 | {"type": "MultiPolygon", "coordinates": [[[[-118.98711, 35.39927], [-118.98684, 35.3994], [-118.98655, 35.39957], [-118.98635, 35.39972], [-118.98615, 35.39992], [-118.98585, 35.40027], [-118.98555, 35.40075], [-118.9855, 35.40088], [-118.98539, 35.40101], [-118.98536, 35.40068], [-118.98556, 35.40034], [-118.98569, 35.40016], [-118.98608, 35.39972], [-118.98632, 35.39951], [-118.98672, 35.39927], [-118.98687, 35.3992], [-118.98711, 35.39927]]], [[[-118.98751, 35.39909], [-118.98751, 35.39909], [-118.9873, 35.39905], [-118.98737, 35.39902], [-118.98751, 35.39901], [-118.98751, 35.39909]]], [[[-118.98934, 35.39916], [-118.98906, 35.39912], [-118.9887, 35.39911], [-118.98774, 35.3991], [-118.98773, 35.39899], [-118.98864, 35.39891], [-118.98896, 35.39886], [-118.98915, 35.39881], [-118.98931, 35.39906], [-118.98934, 35.39916]]]]} | Open Access 1 | 16571 | Wilkins Park | 27527 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 1.875 | Wilkins Park | 0 | Local Park 2 | 4 |
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]);