units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where DES_TP = 39, LAYER = 9, MNG_AGENCY = 47 and YR_EST = 1956
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, PARK_URL, LABEL_NAME
MNG_AG_TYP 1
MNG_AGENCY 1
- California Department of Parks and Recreation · 5 ✖
DES_TP 1
- State Recreation Area · 5 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10666 | 10666 | 10665 | {"type": "MultiPolygon", "coordinates": [[[[-121.09721, 38.82242], [-121.09715, 38.82352], [-121.09709, 38.82595], [-121.09038, 38.82605], [-121.09039, 38.82425], [-121.08923, 38.82422], [-121.08925, 38.82332], [-121.0881, 38.8233], [-121.08811, 38.82149], [-121.08695, 38.82147], [-121.087, 38.81965], [-121.08931, 38.81961], [-121.08934, 38.81881], [-121.08969, 38.81884], [-121.09044, 38.81871], [-121.09188, 38.81908], [-121.09272, 38.82054], [-121.0917, 38.8209], [-121.09128, 38.82157], [-121.0916, 38.82214], [-121.09237, 38.82254], [-121.09721, 38.82242]]], [[[-121.14399, 38.7673], [-121.14366, 38.76819], [-121.14311, 38.76953], [-121.14221, 38.77244], [-121.14072, 38.77245], [-121.14028, 38.7723], [-121.13917, 38.77236], [-121.13704, 38.77199], [-121.13684, 38.77212], [-121.13688, 38.7732], [-121.13668, 38.77374], [-121.1362, 38.77426], [-121.13787, 38.77581], [-121.13786, 38.777], [-121.13765, 38.77812], [-121.13771, 38.78076], [-121.13866, 38.78416], [-121.13925, 38.78482], [-121.13923, 38.78569], [-121.13935, 38.78604], [-121.14056, 38.78711], [-121.14119, 38.78724], [-121.14098, 38.78809], [-121.14065, 38.78802], [-121.13874, 38.78635], [-121.13856, 38.78581], [-121.13858, 38.78495], [-121.13799, 38.78431], [-121.13703, 38.78088], [-121.13697, 38.77816], [-121.13719, 38.77701], [-121.1372, 38.77594], [-121.13596, 38.77476], [-121.13381, 38.77281], [-121.13383, 38.7728], [-121.13413, 38.77177], [-121.13438, 38.77098], [-121.13408, 38.76986], [-121.13415, 38.76945], [-121.13495, 38.77141], [-121.13452, 38.77274], [-121.13574, 38.77385], [-121.13576, 38.77384], [-121.1356, 38.77093], [-121.13614, 38.77017], [-121.13614, 38.76924], [-121.13409, 38.76931], [-121.13292, 38.768], [-121.13254, 38.76784], [-121.1323, 38.76744], [-121.1322, 38.76669], [-121.13305, 38.76664], [-121.13348, 38.76592], [-121.13329, 38.76529], [-121.13403, 38.76459], [-121.1331, 38.76335], [-121.13404, 38.76291], [-121.13467, 38.76296], [-121.13618, 38.76232], [-121.13613, 38.76742], [-121.14399, 38.7673]]]]} | Open Access 1 | 23066 | Folsom Lake State Recreation Area | 13811 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=500 | Placer 35 | 263.272 | Folsom Lake SRA | 1956 | State Recreation Area 39 | 4 |
11224 | 11224 | 11223 | {"type": "Polygon", "coordinates": [[[-121.15174, 38.74317], [-121.1517, 38.75056], [-121.14979, 38.75065], [-121.15051, 38.74707], [-121.14962, 38.74339], [-121.15045, 38.74338], [-121.15083, 38.74335], [-121.15126, 38.74317], [-121.15174, 38.74317]]]} | Open Access 1 | 21562 | Folsom Lake State Recreation Area | 13811 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=500 | Placer 35 | 28.035 | Folsom Lake SRA | 1956 | State Recreation Area 39 | 4 |
16653 | 16653 | 16652 | {"type": "MultiPolygon", "coordinates": [[[[-121.07357, 38.75072], [-121.07316, 38.75109], [-121.07115, 38.75108], [-121.07114, 38.75245], [-121.06996, 38.75245], [-121.06995, 38.75382], [-121.06877, 38.75381], [-121.06877, 38.75243], [-121.06348, 38.7524], [-121.06334, 38.75103], [-121.05891, 38.75099], [-121.05894, 38.74897], [-121.05931, 38.74849], [-121.05948, 38.74818], [-121.05952, 38.74802], [-121.05953, 38.74777], [-121.05952, 38.74763], [-121.05939, 38.74698], [-121.05937, 38.74666], [-121.06088, 38.74669], [-121.06144, 38.74629], [-121.06374, 38.74637], [-121.06569, 38.74685], [-121.06699, 38.74685], [-121.0671, 38.74777], [-121.06837, 38.74831], [-121.06894, 38.74909], [-121.07043, 38.74986], [-121.07126, 38.74973], [-121.07177, 38.74903], [-121.07255, 38.7496], [-121.07266, 38.75017], [-121.07357, 38.75072]]], [[[-121.11914, 38.75092], [-121.11741, 38.75149], [-121.11624, 38.75091], [-121.11526, 38.75097], [-121.11488, 38.75122], [-121.11454, 38.75203], [-121.11367, 38.75255], [-121.11349, 38.75326], [-121.11324, 38.75399], [-121.11333, 38.75468], [-121.11299, 38.75519], [-121.11316, 38.75575], [-121.11296, 38.75732], [-121.11321, 38.75779], [-121.11226, 38.75885], [-121.1131, 38.76039], [-121.11151, 38.7604], [-121.11068, 38.75953], [-121.10923, 38.75891], [-121.1082, 38.75949], [-121.10836, 38.76059], [-121.10848, 38.76556], [-121.10847, 38.766], [-121.11205, 38.76593], [-121.11216, 38.76864], [-121.10849, 38.76873], [-121.10852, 38.77225], [-121.10763, 38.77228], [-121.10775, 38.7751], [-121.10511, 38.77517], [-121.10486, 38.77216], [-121.10438, 38.7711], [-121.10227, 38.77114], [-121.10217, 38.76936], [-121.10091, 38.76946], [-121.09937, 38.76943], [-121.0992, 38.75358], [-121.0962, 38.75365], [-121.0962, 38.7535], [-121.09668, 38.75323], [-121.09674, 38.75245], [-121.09621, 38.75184], [-121.09558, 38.75095], [-121.09576, 38.74978], [-121.09512, 38.74944], [-121.09619, 38.749], [-121.09634, 38.74839], [-121.09549, 38.74709], [-121.09493, 38.74505], [-121.09438, 38.74473], [-121.09495, 38.74432], [-121.09583, 38.74484], [-121.09752, 38.74468], [-121.09808, 38.74427], [-121.09805, 38.74366], [-121.09754, 38.74296], [-121.0985, 38.74223], [-121.09784, 38.74102], [-121.09812, 38.73996], [-121.09834, 38.73862], [-121.09867, 38.73853], [-121.09894, 38.73904], [-121.10063, 38.73967], [-121.1017, 38.73993], [-121.10228, 38.74174], [-121.10374, 38.74179], [-121.10444, 38.74016], [-121.10546, 38.74108], [-121.1063, 38.74151], [-121.10631, 38.7422], [-121.10685, 38.74263], [-121.10715, 38.74368], [-121.10735, 38.74404], [-121.10673, 38.74517], [-121.10776, 38.74573], [-121.10816, 38.74632], [-121.10832, 38.74748], [-121.10971, 38.74752], [-121.11022, 38.74781], [-121.11045, 38.74846], [-121.11233, 38.74888], [-121.11315, 38.74802], [-121.11224, 38.74623], [-121.11313, 38.74608], [-121.11373, 38.74531], [-121.11314, 38.74445], [-121.11409, 38.74458], [-121.11483, 38.74395], [-121.11486, 38.74727], [-121.1166, 38.74732], [-121.11553, 38.74827], [-121.11566, 38.74874], [-121.11619, 38.7485], [-121.11679, 38.74895], [-121.11713, 38.74972], [-121.11818, 38.7499], [-121.11914, 38.75092]]], [[[-121.10739, 38.71214], [-121.10687, 38.71244], [-121.10626, 38.71233], [-121.10565, 38.71247], [-121.10517, 38.71296], [-121.10528, 38.7134], [-121.10627, 38.71421], [-121.10629, 38.71456], [-121.10576, 38.71455], [-121.10517, 38.71388], [-121.10465, 38.71382], [-121.10388, 38.71308], [-121.1031, 38.713], [-121.10229, 38.71311], [-121.1017, 38.71222], [-121.10106, 38.71189], [-121.10027, 38.71212], [-121.09643, 38.70715], [-121.10569, 38.7072], [-121.10572, 38.71085], [-121.10739, 38.71214]]], [[[-121.10533, 38.79138], [-121.10547, 38.79151], [-121.10552, 38.79165], [-121.10552, 38.79182], [-121.10544, 38.79201], [-121.10525, 38.79223], [-121.105, 38.79232], [-121.10478, 38.79229], [-121.10457, 38.79225], [-121.10442, 38.79224], [-121.10428, 38.79226], [-121.10417, 38.79235], [-121.10396, 38.79243], [-121.10374, 38.79248], [-121.10308, 38.79255], [-121.10234, 38.79257], [-121.10195, 38.79243], [-121.10181, 38.79231], [-121.10175, 38.79218], [-121.10179, 38.79202], [-121.10196, 38.79192], [-121.10236, 38.79185], [-121.10283, 38.79168], [-121.10287, 38.7916], [-121.10287, 38.79149], [-121.10282, 38.79133], [-121.10281, 38.79114], [-121.10283, 38.79095], [-121.10291, 38.79083], [-121.10309, 38.79076], [-121.10345, 38.79072], [-121.10378, 38.79064], [-121.10394, 38.79064], [-121.10413, 38.79069], [-121.1043, 38.79077], [-121.10453, 38.79104], [-121.10464, 38.79122], [-121.10478, 38.79131], [-121.10518, 38.79134], [-121.10533, 38.79138]]]]} | Open Access 1 | 16940 | Folsom Lake State Recreation Area | 13811 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=500 | El Dorado 34 | 1211.166 | Folsom Lake SRA | 1956 | State Recreation Area 39 | 4 |
16667 | 16667 | 16666 | {"type": "MultiPolygon", "coordinates": [[[[-121.1698, 38.70497], [-121.16978, 38.70507], [-121.16924, 38.70508], [-121.16689, 38.70505], [-121.16686, 38.70492], [-121.1698, 38.70497]]], [[[-121.173, 38.69208], [-121.17296, 38.69266], [-121.17242, 38.69351], [-121.1729, 38.69377], [-121.17158, 38.69666], [-121.17143, 38.69704], [-121.17134, 38.69733], [-121.17126, 38.69765], [-121.17084, 38.69967], [-121.16935, 38.69983], [-121.16931, 38.70134], [-121.16853, 38.7012], [-121.16886, 38.7004], [-121.16885, 38.69983], [-121.16888, 38.69857], [-121.16941, 38.69856], [-121.16946, 38.69624], [-121.16938, 38.69204], [-121.17174, 38.69206], [-121.17174, 38.69205], [-121.17149, 38.69154], [-121.17194, 38.69145], [-121.17216, 38.69143], [-121.17221, 38.69144], [-121.17237, 38.69166], [-121.17248, 38.69207], [-121.173, 38.69208]]], [[[-121.17211, 38.6913], [-121.17185, 38.69132], [-121.17143, 38.69141], [-121.17128, 38.69105], [-121.17104, 38.69064], [-121.17143, 38.69067], [-121.17151, 38.69049], [-121.17211, 38.6913]]], [[[-121.1785, 38.67917], [-121.17826, 38.67951], [-121.17826, 38.67951], [-121.17816, 38.67937], [-121.1785, 38.67917]]], [[[-121.19307, 38.6779], [-121.1929, 38.6779], [-121.19289, 38.67805], [-121.1929, 38.67824], [-121.19293, 38.67839], [-121.19306, 38.67869], [-121.18927, 38.68094], [-121.18844, 38.68141], [-121.18773, 38.68178], [-121.18701, 38.68213], [-121.18601, 38.6826], [-121.18542, 38.68283], [-121.18482, 38.68303], [-121.18366, 38.68334], [-121.18297, 38.68356], [-121.18246, 38.68374], [-121.18154, 38.68414], [-121.18128, 38.68424], [-121.18096, 38.68432], [-121.18058, 38.68436], [-121.1802, 38.68435], [-121.17987, 38.6843], [-121.17892, 38.68399], [-121.1785, 38.68313], [-121.19281, 38.67623], [-121.19307, 38.6779]]], [[[-121.1892, 38.65824], [-121.18859, 38.6598], [-121.18752, 38.66387], [-121.18698, 38.66733], [-121.18633, 38.6687], [-121.18659, 38.67011], [-121.18532, 38.66875], [-121.18494, 38.66868], [-121.18481, 38.6687], [-121.18431, 38.66957], [-121.18393, 38.6708], [-121.18271, 38.67151], [-121.1824, 38.67118], [-121.18233, 38.67122], [-121.18217, 38.67105], [-121.1839, 38.66462], [-121.18401, 38.66406], [-121.18408, 38.66347], [-121.18409, 38.66305], [-121.18407, 38.66262], [-121.18403, 38.6622], [-121.18395, 38.66177], [-121.18382, 38.66123], [-121.1832, 38.65917], [-121.18321, 38.65914], [-121.1892, 38.65824]]], [[[-121.19716, 38.64278], [-121.19498, 38.64378], [-121.19422, 38.64429], [-121.19329, 38.64536], [-121.19267, 38.64575], [-121.19189, 38.64605], [-121.19189, 38.64626], [-121.1925, 38.6465], [-121.19262, 38.64662], [-121.19259, 38.6471], [-121.19226, 38.64783], [-121.19197, 38.64886], [-121.19148, 38.64952], [-121.19125, 38.64953], [-121.19022, 38.64905], [-121.18932, 38.64877], [-121.18915, 38.64879], [-121.18897, 38.64868], [-121.18879, 38.64865], [-121.18609, 38.64927], [-121.18535, 38.64864], [-121.19435, 38.64217], [-121.19516, 38.64155], [-121.19544, 38.64132], [-121.19716, 38.64278]]], [[[-121.19795, 38.66782], [-121.19783, 38.66782], [-121.19783, 38.66803], [-121.19729, 38.66803], [-121.19729, 38.66842], [-121.19668, 38.66843], [-121.19668, 38.66856], [-121.1958, 38.66857], [-121.19582, 38.66963], [-121.19631, 38.67072], [-121.19641, 38.67073], [-121.19643, 38.67087], [-121.19619, 38.67089], [-121.19611, 38.67054], [-121.19534, 38.66995], [-121.1948, 38.66966], [-121.19413, 38.66968], [-121.19314, 38.67044], [-121.19296, 38.67063], [-121.19287, 38.67112], [-121.19269, 38.67109], [-121.19262, 38.67091], [-121.19246, 38.67065], [-121.19246, 38.6704], [-121.19266, 38.67046], [-121.193, 38.67013], [-121.19311, 38.66992], [-121.19298, 38.66964], [-121.19343, 38.66928], [-121.19358, 38.66905], [-121.19359, 38.66865], [-121.19345, 38.66827], [-121.19313, 38.668], [-121.19292, 38.66769], [-121.19311, 38.66757], [-121.19264, 38.66688], [-121.19238, 38.66674], [-121.19195, 38.66697], [-121.19168, 38.66697], [-121.19167, 38.66617], [-121.19137, 38.6661], [-121.19136, 38.66554], [-121.19178, 38.66432], [-121.19303, 38.6642], [-121.19307, 38.66348], [-121.19337, 38.66335], [-121.19387, 38.66338], [-121.19399, 38.6643], [-121.19422, 38.66514], [-121.19554, 38.66515], [-121.19559, 38.66619], [-121.19794, 38.66697], [-121.19795, 38.66782]]], [[[-121.21697, 38.64197], [-121.21514, 38.64623], [-121.21587, 38.64711], [-121.2152, 38.64802], [-121.21487, 38.64889], [-121.21441, 38.64966], [-121.21436, 38.64981], [-121.2137, 38.65052], [-121.21371, 38.65054], [-121.21478, 38.65039], [-121.21472, 38.65195], [-121.21333, 38.65221], [-121.21335, 38.65275], [-121.21445, 38.65249], [-121.21398, 38.65326], [-121.21369, 38.65325], [-121.21352, 38.65326], [-121.21336, 38.65329], [-121.2132, 38.65334], [-121.21101, 38.65449], [-121.21082, 38.65456], [-121.21054, 38.65461], [-121.21028, 38.65461], [-121.20995, 38.65454], [-121.20972, 38.65443], [-121.20971, 38.6544], [-121.20973, 38.65434], [-121.2105, 38.6538], [-121.2105, 38.65378], [-121.21041, 38.65371], [-121.20865, 38.65495], [-121.20852, 38.65503], [-121.20833, 38.65511], [-121.20685, 38.65553], [-121.20669, 38.65556], [-121.20648, 38.65557], [-121.20474, 38.65554], [-121.20446, 38.65559], [-121.20424, 38.65569], [-121.20404, 38.65585], [-121.20392, 38.65603], [-121.20387, 38.65622], [-121.20361, 38.65623], [-121.19851, 38.65802], [-121.1956, 38.65893], [-121.19551, 38.65864], [-121.19644, 38.65771], [-121.20366, 38.65496], [-121.20699, 38.65496], [-121.20721, 38.64636], [-121.19851, 38.64793], [-121.19881, 38.64738], [-121.20315, 38.64362], [-121.21419, 38.64351], [-121.21697, 38.64197]]], [[[-121.19858, 38.64201], [-121.19828, 38.64215], [-121.19793, 38.64243], [-121.19773, 38.64253], [-121.19818, 38.64217], [-121.19858, 38.64201]]], [[[-121.21411, 38.63551], [-121.21303, 38.6361], [-121.21377, 38.63717], [-121.2082, 38.6384], [-121.20762, 38.63851], [-121.20728, 38.63855], [-121.20732, 38.6381], [-121.20744, 38.63765], [-121.20805, 38.63687], [-121.20816, 38.63658], [-121.20796, 38.6363], [-121.20691, 38.63669], [-121.20691, 38.63785], [-121.20665, 38.63801], [-121.20595, 38.63815], [-121.20496, 38.63902], [-121.20408, 38.6395], [-121.19971, 38.64147], [-121.19887, 38.64187], [-121.19834, 38.64114], [-121.19899, 38.64085], [-121.19838, 38.64012], [-121.19939, 38.63973], [-121.20007, 38.6396], [-121.2006, 38.63946], [-121.20065, 38.63956], [-121.201, 38.63946], [-121.20187, 38.63915], [-121.20255, 38.63887], [-121.20316, 38.63856], [-121.20575, 38.63717], [-121.20813, 38.63594], [-121.20839, 38.63571], [-121.21133, 38.63414], [-121.21245, 38.63372], [-121.21272, 38.63399], [-121.21274, 38.63403], [-121.21411, 38.63551]]], [[[-121.21372, 38.65338], [-121.21281, 38.65431], [-121.21206, 38.65514], [-121.21155, 38.65512], [-121.21031, 38.65591], [-121.20878, 38.65646], [-121.20698, 38.65617], [-121.20405, 38.65622], [-121.20402, 38.6562], [-121.20409, 38.65601], [-121.20421, 38.65587], [-121.20437, 38.65575], [-121.2046, 38.65567], [-121.20476, 38.65565], [-121.20649, 38.65569], [-121.20671, 38.65567], [-121.20695, 38.65562], [-121.20841, 38.65521], [-121.20868, 38.65508], [-121.2095, 38.6545], [-121.20959, 38.65451], [-121.20993, 38.65466], [-121.21021, 38.65472], [-121.21049, 38.65474], [-121.21083, 38.65469], [-121.21111, 38.65458], [-121.21322, 38.65347], [-121.21346, 38.6534], [-121.21372, 38.65338]]]]} | Open Access 1 | 23067 | Folsom Lake State Recreation Area | 13811 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=500 | Sacramento 41 | 749.378 | Folsom Lake SRA | 1956 | State Recreation Area 39 | 4 |
16811 | 16811 | 16810 | {"type": "Polygon", "coordinates": [[[-115.54272, 34.95743], [-115.54272, 34.95989], [-115.54258, 34.9717], [-115.50314, 34.9719], [-115.50314, 34.96475], [-115.5031, 34.96474], [-115.50309, 34.96468], [-115.48109, 34.9647], [-115.48109, 34.9285], [-115.5383, 34.92847], [-115.53833, 34.95743], [-115.54272, 34.95743]], [[-115.51411, 34.95022], [-115.5142, 34.95021], [-115.5141, 34.94483], [-115.51192, 34.94483], [-115.51191, 34.9449], [-115.5119, 34.94656], [-115.50532, 34.94657], [-115.50531, 34.95023], [-115.50972, 34.95022], [-115.50972, 34.9538], [-115.50974, 34.95385], [-115.5119, 34.95385], [-115.5119, 34.95381], [-115.51193, 34.9538], [-115.51192, 34.95041], [-115.5141, 34.95039], [-115.51411, 34.95022]]]} | Open Access 1 | 9003 | Providence Mountains State Recreation Area | 1700 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=615 | San Bernardino 22 | 5859.124 | Providence Mtns. SRA | 1956 | State Recreation Area 39 | 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]);