units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where ACCESS_TYP = 1, DES_TP = 2 and MNG_AGENCY = 164
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
429 | 429 | 428 | {"type": "Polygon", "coordinates": [[[-117.49266, 34.11629], [-117.4928, 34.1163], [-117.49293, 34.11635], [-117.49305, 34.11641], [-117.49313, 34.11648], [-117.49322, 34.11658], [-117.49327, 34.11668], [-117.4933, 34.11678], [-117.4933, 34.11692], [-117.49327, 34.11701], [-117.49322, 34.11712], [-117.49313, 34.11722], [-117.49304, 34.11729], [-117.49292, 34.11736], [-117.4928, 34.11739], [-117.49267, 34.11741], [-117.49253, 34.11741], [-117.4923, 34.11734], [-117.49218, 34.11728], [-117.49209, 34.1172], [-117.49201, 34.1171], [-117.49197, 34.11701], [-117.49195, 34.11691], [-117.49195, 34.11678], [-117.49197, 34.11669], [-117.49202, 34.11659], [-117.49209, 34.1165], [-117.49219, 34.11642], [-117.49238, 34.11632], [-117.4925, 34.11629], [-117.49266, 34.11629]]]} | Open Access 1 | 1717 | Heritage Circle Park | 19833 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 3.008 | Heritage Circle Park | 0 | Local Park 2 | 4 | |
682 | 682 | 681 | {"type": "Polygon", "coordinates": [[[-117.43156, 34.13275], [-117.43156, 34.13439], [-117.43154, 34.13441], [-117.43154, 34.13377], [-117.43132, 34.13359], [-117.4311, 34.13357], [-117.4311, 34.13381], [-117.43107, 34.13382], [-117.43099, 34.13359], [-117.43081, 34.13363], [-117.43069, 34.13381], [-117.43052, 34.13367], [-117.43032, 34.1336], [-117.42996, 34.13361], [-117.42995, 34.13349], [-117.43025, 34.13349], [-117.43025, 34.13301], [-117.43027, 34.13289], [-117.43041, 34.13289], [-117.43041, 34.13265], [-117.43072, 34.13265], [-117.43068, 34.13304], [-117.43089, 34.13324], [-117.43116, 34.13327], [-117.43141, 34.13321], [-117.43154, 34.1331], [-117.43154, 34.13273], [-117.43156, 34.13275]]]} | Open Access 1 | 3665 | Cambria Park | 16748 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 2.176 | Cambria Park | 0 | Local Park 2 | 4 | |
703 | 703 | 702 | {"type": "Polygon", "coordinates": [[[-117.45142, 34.11234], [-117.45138, 34.11239], [-117.45135, 34.11245], [-117.45104, 34.11232], [-117.45073, 34.11232], [-117.45072, 34.11111], [-117.45108, 34.11111], [-117.45109, 34.11203], [-117.45136, 34.11204], [-117.45136, 34.11228], [-117.45142, 34.11234]]]} | Open Access 1 | 3856 | Northgate Park | 22871 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 1.363 | Northgate Park | 0 | Local Park 2 | 4 | |
719 | 719 | 718 | {"type": "Polygon", "coordinates": [[[-117.43128, 34.09033], [-117.43029, 34.09034], [-117.43029, 34.09206], [-117.42712, 34.09208], [-117.42712, 34.09035], [-117.42919, 34.09034], [-117.42919, 34.08853], [-117.43127, 34.08852], [-117.43128, 34.09033]]]} | Open Access 1 | 4257 | Veteran's Park | 27018 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 23.464 | Veteran's Park | 0 | Local Park 2 | 4 | |
867 | 867 | 866 | {"type": "MultiPolygon", "coordinates": [[[[-117.50174, 34.0463], [-117.4978, 34.04629], [-117.49778, 34.04569], [-117.50117, 34.0457], [-117.50118, 34.04427], [-117.50167, 34.04427], [-117.50171, 34.0443], [-117.50174, 34.0463]]], [[[-117.50233, 34.0463], [-117.50194, 34.0463], [-117.50193, 34.0457], [-117.50232, 34.0457], [-117.50233, 34.0463]]]]} | Open Access 1 | 5606 | Chaparral Park | 17128 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 8.61 | Chaparral Park | 0 | Local Park 2 | 4 | |
1292 | 1292 | 1291 | {"type": "Polygon", "coordinates": [[[-117.43451, 34.10096], [-117.43301, 34.10097], [-117.43284, 34.10095], [-117.43283, 34.09946], [-117.43395, 34.09946], [-117.43395, 34.1], [-117.43451, 34.1], [-117.43451, 34.10096]]]} | Open Access 1 | 5718 | Miller Park | 22242 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 5.604 | Miller Park | 0 | Local Park 2 | 4 | |
1343 | 1343 | 1342 | {"type": "Polygon", "coordinates": [[[-117.48634, 34.15655], [-117.48601, 34.15655], [-117.48202, 34.15653], [-117.48215, 34.15623], [-117.48235, 34.15589], [-117.4826, 34.15556], [-117.48281, 34.15535], [-117.48322, 34.15502], [-117.48435, 34.15431], [-117.4846, 34.15433], [-117.48566, 34.15525], [-117.48586, 34.15545], [-117.48606, 34.15571], [-117.4862, 34.15598], [-117.4863, 34.15629], [-117.48634, 34.15655]]]} | Open Access 1 | 11266 | San Sevaine Park | 24992 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 15.66 | San Sevaine Park | 0 | Local Park 2 | 4 | |
1655 | 1655 | 1654 | {"type": "Polygon", "coordinates": [[[-117.49797, 34.03513], [-117.49753, 34.03552], [-117.49749, 34.0355], [-117.497, 34.03594], [-117.49702, 34.03597], [-117.49689, 34.03608], [-117.49555, 34.03502], [-117.49576, 34.03499], [-117.49733, 34.03499], [-117.4976, 34.03502], [-117.49765, 34.03505], [-117.49769, 34.03511], [-117.49777, 34.03514], [-117.49786, 34.03514], [-117.49794, 34.0351], [-117.49797, 34.03513]]]} | Open Access 1 | 12527 | Oak Park | 22998 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 3.382 | Oak Park | 0 | Local Park 2 | 4 | |
3911 | 3911 | 3910 | {"type": "Polygon", "coordinates": [[[-117.48339, 34.15874], [-117.48338, 34.16039], [-117.48238, 34.16038], [-117.48236, 34.16004], [-117.48232, 34.15979], [-117.48208, 34.15873], [-117.48339, 34.15874]]]} | Open Access 1 | 2021 | Hunters Ridge Park | 20156 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 4.715 | Hunters Ridge Park | 0 | Local Park 2 | 4 | |
4944 | 4944 | 4943 | {"type": "Polygon", "coordinates": [[[-117.42263, 34.10852], [-117.4205, 34.10853], [-117.4205, 34.10758], [-117.42164, 34.10758], [-117.42165, 34.10759], [-117.42263, 34.10759], [-117.42263, 34.10852]]]} | Open Access 1 | 14657 | North Tamarind Park | 22862 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 5.049 | North Tamarind Park | 0 | Local Park 2 | 4 | |
5025 | 5025 | 5024 | {"type": "Polygon", "coordinates": [[[-117.4444, 34.10153], [-117.44026, 34.10155], [-117.44026, 34.10118], [-117.4444, 34.10117], [-117.4444, 34.10153]]]} | Open Access 1 | 12337 | Seville Park | 25329 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 3.795 | Seville Park | 0 | Local Park 2 | 4 | |
5278 | 5278 | 5277 | {"type": "Polygon", "coordinates": [[[-117.44432, 34.08121], [-117.44224, 34.08122], [-117.44224, 34.08207], [-117.44016, 34.08206], [-117.44015, 34.07941], [-117.44431, 34.0794], [-117.44432, 34.08121]]]} | Open Access 1 | 2640 | Jack Bulik Park | 20301 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 23.531 | Jack Bulik Park | 0 | Local Park 2 | 4 | |
5307 | 5307 | 5306 | {"type": "Polygon", "coordinates": [[[-117.43672, 34.09576], [-117.43589, 34.09576], [-117.43589, 34.09529], [-117.4367, 34.09527], [-117.43672, 34.09576]]]} | Open Access 1 | 5783 | Santa Fe Park | 25085 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 0.999 | Santa Fe Park | 0 | Local Park 2 | 4 | |
5983 | 5983 | 5982 | {"type": "Polygon", "coordinates": [[[-117.48692, 34.03902], [-117.48673, 34.03936], [-117.48657, 34.03971], [-117.48646, 34.04008], [-117.48641, 34.04033], [-117.48639, 34.04057], [-117.48636, 34.0406], [-117.48633, 34.04061], [-117.48525, 34.04061], [-117.48483, 34.04066], [-117.48456, 34.04071], [-117.48429, 34.04079], [-117.48402, 34.0409], [-117.48376, 34.04104], [-117.48371, 34.04104], [-117.48365, 34.04099], [-117.4836, 34.0409], [-117.48358, 34.04081], [-117.4836, 34.04069], [-117.48417, 34.03928], [-117.48421, 34.03923], [-117.48434, 34.03916], [-117.48438, 34.0391], [-117.48436, 34.03901], [-117.48429, 34.03895], [-117.4842, 34.03894], [-117.48411, 34.03897], [-117.48406, 34.03902], [-117.48295, 34.04178], [-117.48232, 34.04284], [-117.48249, 34.0423], [-117.48259, 34.04174], [-117.48262, 34.04118], [-117.48258, 34.04061], [-117.48249, 34.04015], [-117.48235, 34.03969], [-117.4819, 34.03861], [-117.48182, 34.03835], [-117.4818, 34.03816], [-117.48159, 34.03807], [-117.48165, 34.03797], [-117.48318, 34.03856], [-117.48519, 34.03858], [-117.48562, 34.03861], [-117.48596, 34.03867], [-117.48629, 34.03876], [-117.48654, 34.03884], [-117.48692, 34.03902]]]} | Open Access 1 | 576 | Southridge Park | 25694 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 24.807 | Southridge Park | 0 | Local Park 2 | 4 | |
6378 | 6378 | 6377 | {"type": "Polygon", "coordinates": [[[-117.44445, 34.11025], [-117.44445, 34.11116], [-117.44233, 34.11117], [-117.44233, 34.11207], [-117.44029, 34.11208], [-117.44029, 34.11061], [-117.44109, 34.1106], [-117.44109, 34.11026], [-117.44445, 34.11025]]]} | Open Access 1 | 5632 | Bill Martin Park | 16106 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 13.552 | Bill Martin Park | 0 | Local Park 2 | 4 | |
6388 | 6388 | 6387 | {"type": "Polygon", "coordinates": [[[-117.43803, 34.10064], [-117.43802, 34.10099], [-117.43591, 34.10101], [-117.43591, 34.10067], [-117.43803, 34.10064]]]} | Open Access 1 | 48898 | Fontana Memorial Rose Garden | 33615 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 1.861 | Fontana Memorial Rose Garden | 0 | Local Park 2 | 4 | |
6767 | 6767 | 6766 | {"type": "MultiPolygon", "coordinates": [[[[-117.49927, 34.12037], [-117.49925, 34.12135], [-117.49702, 34.12135], [-117.49702, 34.12124], [-117.49696, 34.1212], [-117.49698, 34.12087], [-117.49702, 34.12069], [-117.49709, 34.1205], [-117.49726, 34.12017], [-117.49741, 34.11995], [-117.49745, 34.11993], [-117.4975, 34.11992], [-117.49755, 34.11993], [-117.49828, 34.12035], [-117.49927, 34.12037]]], [[[-117.49927, 34.11885], [-117.49927, 34.12022], [-117.49845, 34.12022], [-117.49829, 34.12019], [-117.49814, 34.12011], [-117.49783, 34.11983], [-117.49771, 34.11975], [-117.49767, 34.11972], [-117.49767, 34.11968], [-117.49768, 34.11964], [-117.49786, 34.11947], [-117.49812, 34.11926], [-117.49837, 34.1191], [-117.49856, 34.11901], [-117.49878, 34.11894], [-117.49902, 34.11888], [-117.49927, 34.11885]]], [[[-117.50056, 34.10927], [-117.50052, 34.1096], [-117.50045, 34.10989], [-117.50037, 34.11016], [-117.50019, 34.11063], [-117.50013, 34.1107], [-117.50007, 34.11071], [-117.50001, 34.1107], [-117.49995, 34.11065], [-117.49987, 34.11045], [-117.49977, 34.11031], [-117.49973, 34.11021], [-117.49958, 34.10969], [-117.49951, 34.10929], [-117.50056, 34.10927]]], [[[-117.50044, 34.10899], [-117.49959, 34.109], [-117.49958, 34.10873], [-117.50043, 34.10871], [-117.50044, 34.10899]]], [[[-117.50056, 34.11327], [-117.50059, 34.11358], [-117.5006, 34.11382], [-117.50058, 34.11412], [-117.50053, 34.11442], [-117.50044, 34.11472], [-117.50027, 34.11515], [-117.50022, 34.11521], [-117.50013, 34.11522], [-117.50004, 34.11517], [-117.49995, 34.11496], [-117.49986, 34.11484], [-117.49982, 34.11474], [-117.49969, 34.11426], [-117.49964, 34.11378], [-117.49965, 34.11342], [-117.49971, 34.113], [-117.49978, 34.11276], [-117.49995, 34.11231], [-117.5, 34.11225], [-117.50006, 34.11224], [-117.50012, 34.11224], [-117.50017, 34.11226], [-117.50021, 34.11231], [-117.50029, 34.1125], [-117.50039, 34.11264], [-117.50042, 34.11272], [-117.50056, 34.11327]]], [[[-117.50073, 34.11845], [-117.49969, 34.11845], [-117.49973, 34.11789], [-117.49982, 34.11742], [-117.49991, 34.11707], [-117.50003, 34.1167], [-117.50006, 34.11665], [-117.50011, 34.11661], [-117.5002, 34.11661], [-117.50027, 34.11665], [-117.50036, 34.11687], [-117.50047, 34.11707], [-117.50064, 34.1178], [-117.50073, 34.11845]]], [[[-117.50016, 34.11216], [-117.50015, 34.11218], [-117.50001, 34.11218], [-117.49999, 34.11217], [-117.50003, 34.11194], [-117.50006, 34.11168], [-117.50007, 34.11168], [-117.50011, 34.11193], [-117.50016, 34.11216]]], [[[-117.50015, 34.11079], [-117.50011, 34.11099], [-117.50009, 34.11126], [-117.49999, 34.11078], [-117.50001, 34.11077], [-117.50014, 34.11077], [-117.50015, 34.11079]]], [[[-117.50023, 34.11532], [-117.50019, 34.11552], [-117.50018, 34.11574], [-117.50008, 34.11529], [-117.5001, 34.11528], [-117.50022, 34.11528], [-117.50023, 34.11532]]], [[[-117.50023, 34.1165], [-117.50024, 34.11653], [-117.50022, 34.11654], [-117.5001, 34.11654], [-117.50009, 34.11653], [-117.50012, 34.11634], [-117.50014, 34.1161], [-117.50023, 34.1165]]]]} | Open Access 1 | 5207 | McDermontt Sports Complex & McDermontt Park West | 22020 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 22.461 | McDermontt Sports Complex & McDermontt Park West | 0 | Local Park 2 | 4 | |
6919 | 6919 | 6918 | {"type": "Polygon", "coordinates": [[[-117.50592, 34.12164], [-117.50587, 34.12179], [-117.50569, 34.12196], [-117.50544, 34.12227], [-117.50497, 34.12308], [-117.50498, 34.12305], [-117.50494, 34.12303], [-117.50493, 34.123], [-117.50504, 34.12272], [-117.50508, 34.12247], [-117.50509, 34.12167], [-117.50514, 34.12164], [-117.50592, 34.12164]]]} | Open Access 1 | 5884 | North Heritage Park | 22821 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 1.343 | North Heritage Park | 0 | Local Park 2 | 4 | |
8177 | 8177 | 8176 | {"type": "Polygon", "coordinates": [[[-117.49514, 34.04543], [-117.49513, 34.04629], [-117.49346, 34.04629], [-117.49346, 34.04568], [-117.49412, 34.04568], [-117.49412, 34.04426], [-117.49495, 34.04426], [-117.49502, 34.04431], [-117.49502, 34.04512], [-117.49499, 34.04527], [-117.49504, 34.04537], [-117.49514, 34.04543]]]} | Open Access 1 | 12381 | Shadow Park | 25340 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 5.903 | Shadow Park | 0 | Local Park 2 | 4 | |
10830 | 10830 | 10829 | {"type": "MultiPolygon", "coordinates": [[[[-117.47469, 34.14318], [-117.47284, 34.14489], [-117.47226, 34.14447], [-117.47195, 34.14431], [-117.47176, 34.14425], [-117.47164, 34.14422], [-117.4716, 34.14415], [-117.47153, 34.14409], [-117.47091, 34.14402], [-117.47071, 34.14395], [-117.47041, 34.1438], [-117.47044, 34.14377], [-117.47042, 34.14369], [-117.47046, 34.14364], [-117.47055, 34.14358], [-117.47069, 34.14342], [-117.47072, 34.14332], [-117.47083, 34.14314], [-117.47093, 34.14294], [-117.47094, 34.14315], [-117.47469, 34.14318]]], [[[-117.47614, 34.14539], [-117.47552, 34.1459], [-117.47542, 34.14597], [-117.47535, 34.14597], [-117.47502, 34.14573], [-117.47492, 34.14561], [-117.47485, 34.14558], [-117.47476, 34.14557], [-117.47475, 34.14552], [-117.47442, 34.14528], [-117.47518, 34.14457], [-117.47555, 34.14484], [-117.47557, 34.14492], [-117.47561, 34.14497], [-117.47577, 34.14505], [-117.47614, 34.14532], [-117.47614, 34.14539]]]]} | Open Access 1 | 20542 | Rosena Park | 24625 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 13.578 | Rosena 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]);