units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where COUNTY = 37 and DES_TP = 15
This data as json, copyable, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16568 | 16568 | 16567 | {"type": "MultiPolygon", "coordinates": [[[[-120.93113, 37.30843], [-120.93032, 37.30902], [-120.92851, 37.3079], [-120.928, 37.30777], [-120.92774, 37.3073], [-120.92617, 37.30644], [-120.92566, 37.30632], [-120.92598, 37.30539], [-120.92575, 37.30492], [-120.92471, 37.30454], [-120.92403, 37.30439], [-120.92306, 37.3052], [-120.9224, 37.30647], [-120.92217, 37.3065], [-120.92233, 37.30552], [-120.92133, 37.3039], [-120.92174, 37.30371], [-120.92243, 37.30383], [-120.92269, 37.30432], [-120.92418, 37.30404], [-120.92408, 37.30331], [-120.92353, 37.30296], [-120.92329, 37.30263], [-120.92242, 37.30219], [-120.9218, 37.30165], [-120.92163, 37.30116], [-120.9218, 37.30077], [-120.92192, 37.2986], [-120.92234, 37.29759], [-120.9227, 37.29741], [-120.92296, 37.29691], [-120.92471, 37.29693], [-120.92563, 37.29719], [-120.92692, 37.29771], [-120.92791, 37.2984], [-120.92821, 37.29916], [-120.92726, 37.30011], [-120.92821, 37.30243], [-120.92717, 37.30305], [-120.92739, 37.30594], [-120.93113, 37.30843]]], [[[-120.92991, 37.30949], [-120.92937, 37.30986], [-120.92969, 37.31018], [-120.92945, 37.31029], [-120.92918, 37.31039], [-120.92878, 37.3105], [-120.92613, 37.31106], [-120.92594, 37.31096], [-120.92349, 37.30829], [-120.92342, 37.30819], [-120.92204, 37.30776], [-120.92125, 37.30735], [-120.92097, 37.30701], [-120.92067, 37.30657], [-120.92062, 37.30606], [-120.92079, 37.3021], [-120.92066, 37.30157], [-120.92022, 37.30114], [-120.91869, 37.3002], [-120.91777, 37.2993], [-120.91661, 37.29878], [-120.91533, 37.29864], [-120.91486, 37.29873], [-120.91372, 37.29933], [-120.91269, 37.30009], [-120.90975, 37.30248], [-120.90698, 37.30406], [-120.90668, 37.30413], [-120.90639, 37.30414], [-120.90601, 37.30406], [-120.90497, 37.30361], [-120.90449, 37.30346], [-120.90309, 37.30357], [-120.90231, 37.30361], [-120.90186, 37.30361], [-120.90125, 37.30389], [-120.89943, 37.30462], [-120.89885, 37.30487], [-120.89856, 37.30494], [-120.89806, 37.305], [-120.89758, 37.30501], [-120.89721, 37.30498], [-120.89684, 37.30487], [-120.89647, 37.30469], [-120.8958, 37.30433], [-120.89551, 37.30424], [-120.89484, 37.30412], [-120.89343, 37.30391], [-120.89249, 37.30388], [-120.89226, 37.30382], [-120.8916, 37.30343], [-120.89063, 37.30294], [-120.88926, 37.30248], [-120.88812, 37.30211], [-120.88692, 37.30162], [-120.88553, 37.30068], [-120.88442, 37.30037], [-120.88295, 37.29997], [-120.88158, 37.29987], [-120.87941, 37.29978], [-120.87905, 37.29972], [-120.87669, 37.29957], [-120.87604, 37.2994], [-120.87421, 37.29906], [-120.87241, 37.29863], [-120.87202, 37.29857], [-120.87191, 37.29792], [-120.8715, 37.29848], [-120.86853, 37.2989], [-120.86833, 37.29879], [-120.86775, 37.29868], [-120.86067, 37.29614], [-120.85878, 37.29648], [-120.85581, 37.29705], [-120.85403, 37.29721], [-120.85148, 37.29747], [-120.85151, 37.29531], [-120.8521, 37.29544], [-120.85267, 37.29554], [-120.85312, 37.2956], [-120.85346, 37.29553], [-120.85363, 37.29541], [-120.85381, 37.29519], [-120.85405, 37.29476], [-120.85414, 37.29449], [-120.85418, 37.29398], [-120.85418, 37.2935], [-120.85429, 37.29313], [-120.8545, 37.29291], [-120.85484, 37.29274], [-120.85527, 37.29268], [-120.85569, 37.29272], [-120.85614, 37.29283], [-120.8566, 37.29299], [-120.85693, 37.293], [-120.85792, 37.29282], [-120.85816, 37.29276], [-120.85918, 37.29234], [-120.86028, 37.29202], [-120.86133, 37.29138], [-120.86217, 37.29007], [-120.86296, 37.28907], [-120.86355, 37.28849], [-120.86486, 37.28837], [-120.86553, 37.28856], [-120.866, 37.29002], [-120.86574, 37.29153], [-120.86588, 37.29231], [-120.86633, 37.29276], [-120.86693, 37.29284], [-120.86798, 37.29289], [-120.86896, 37.29252], [-120.86955, 37.29212], [-120.86968, 37.29107], [-120.8698, 37.28986], [-120.8698, 37.28913], [-120.87017, 37.28891], [-120.87085, 37.2887], [-120.87183, 37.2886], [-120.87295, 37.2887], [-120.87375, 37.28901], [-120.87434, 37.2893], [-120.87486, 37.28982], [-120.87625, 37.29142], [-120.87655, 37.29236], [-120.87623, 37.29276], [-120.87534, 37.29282], [-120.87472, 37.29316], [-120.87334, 37.29403], [-120.87242, 37.29477], [-120.87162, 37.29695], [-120.87181, 37.29739], [-120.87257, 37.29763], [-120.87329, 37.29747], [-120.8744, 37.29699], [-120.87535, 37.29633], [-120.87602, 37.29586], [-120.8766, 37.29517], [-120.87703, 37.29446], [-120.87725, 37.29417], [-120.87752, 37.29337], [-120.87803, 37.29358], [-120.87833, 37.29379], [-120.87851, 37.29399], [-120.87862, 37.29414], [-120.87858, 37.29464], [-120.87859, 37.29465], [-120.87894, 37.29338], [-120.87821, 37.2928], [-120.87734, 37.2929], [-120.87656, 37.29463], [-120.87423, 37.29644], [-120.87326, 37.29706], [-120.87264, 37.29734], [-120.87198, 37.29706], [-120.87276, 37.29516], [-120.87367, 37.29435], [-120.87544, 37.29318], [-120.87656, 37.29304], [-120.87701, 37.29228], [-120.8766, 37.29132], [-120.87594, 37.29063], [-120.87534, 37.28899], [-120.87449, 37.28773], [-120.87341, 37.28693], [-120.87084, 37.28678], [-120.86935, 37.2874], [-120.86919, 37.28884], [-120.86916, 37.28987], [-120.86921, 37.29067], [-120.86905, 37.29209], [-120.86844, 37.29238], [-120.86695, 37.29254], [-120.86622, 37.2915], [-120.86649, 37.29], [-120.86598, 37.28843], [-120.86517, 37.28802], [-120.86363, 37.28795], [-120.8627, 37.28848], [-120.86233, 37.28886], [-120.86204, 37.28934], [-120.8614, 37.29007], [-120.86053, 37.29099], [-120.85968, 37.29161], [-120.85856, 37.29173], [-120.85699, 37.29232], [-120.85611, 37.29252], [-120.85524, 37.29231], [-120.85386, 37.29242], [-120.85335, 37.2932], [-120.85312, 37.29453], [-120.85244, 37.29508], [-120.85151, 37.29478], [-120.85154, 37.28889], [-120.85152, 37.28225], [-120.85154, 37.27456], [-120.85153, 37.2707], [-120.85154, 37.26022], [-120.85153, 37.25765], [-120.85153, 37.25693], [-120.85183, 37.2547], [-120.85224, 37.25197], [-120.85228, 37.24777], [-120.85291, 37.24789], [-120.85325, 37.24824], [-120.85393, 37.24843], [-120.85431, 37.24845], [-120.85624, 37.24896], [-120.85685, 37.24931], [-120.85732, 37.24937], [-120.85793, 37.25011], [-120.85799, 37.2507], [-120.85773, 37.25112], [-120.85781, 37.25211], [-120.85824, 37.25259], [-120.85871, 37.25297], [-120.85933, 37.25317], [-120.85974, 37.25375], [-120.86013, 37.25399], [-120.8607, 37.25421], [-120.86128, 37.25422], [-120.86181, 37.2545], [-120.86261, 37.25461], [-120.86279, 37.2551], [-120.86304, 37.25603], [-120.86291, 37.25696], [-120.8624, 37.2573], [-120.86153, 37.25732], [-120.86139, 37.25744], [-120.8617, 37.25888], [-120.86229, 37.25996], [-120.86267, 37.26029], [-120.8636, 37.26046], [-120.86449, 37.261], [-120.86491, 37.26135], [-120.86529, 37.26174], [-120.86582, 37.26208], [-120.86622, 37.2623], [-120.86614, 37.26272], [-120.86523, 37.26302], [-120.86421, 37.26331], [-120.86388, 37.26364], [-120.86379, 37.26407], [-120.86382, 37.26432], [-120.86415, 37.2648], [-120.86494, 37.26623], [-120.86538, 37.26666], [-120.86596, 37.26742], [-120.86675, 37.26759], [-120.86729, 37.26796], [-120.8673, 37.26906], [-120.86785, 37.27007], [-120.86825, 37.2704], [-120.86921, 37.27024], [-120.86805, 37.27129], [-120.86783, 37.27182], [-120.86779, 37.27227], [-120.86867, 37.27305], [-120.86891, 37.27339], [-120.86942, 37.27328], [-120.86946, 37.27376], [-120.87002, 37.27443], [-120.87018, 37.27443], [-120.87023, 37.27449], [-120.87071, 37.27493], [-120.87122, 37.27564], [-120.87135, 37.27599], [-120.87167, 37.27626], [-120.87181, 37.2816], [-120.88049, 37.28157], [-120.88089, 37.29659], [-120.88023, 37.29634], [-120.87896, 37.2956], [-120.87856, 37.29478], [-120.87832, 37.29535], [-120.8783, 37.29583], [-120.87838, 37.29621], [-120.87862, 37.29657], [-120.87871, 37.29681], [-120.87889, 37.29701], [-120.87927, 37.29724], [-120.87976, 37.2974], [-120.88088, 37.29721], [-120.88286, 37.29705], [-120.88338, 37.29697], [-120.88466, 37.2972], [-120.88549, 37.29741], [-120.88618, 37.29723], [-120.88654, 37.29719], [-120.88661, 37.29732], [-120.88661, 37.2976], [-120.88665, 37.29804], [-120.88684, 37.29853], [-120.88732, 37.29936], [-120.88812, 37.30063], [-120.88899, 37.30119], [-120.8901, 37.30128], [-120.89036, 37.30106], [-120.89107, 37.29996], [-120.89166, 37.29934], [-120.89224, 37.29883], [-120.89308, 37.29865], [-120.89362, 37.2987], [-120.89438, 37.29933], [-120.8949, 37.29957], [-120.89586, 37.29959], [-120.89626, 37.29923], [-120.89716, 37.29853], [-120.89791, 37.29827], [-120.89877, 37.29828], [-120.89926, 37.29844], [-120.89951, 37.29858], [-120.89972, 37.29888], [-120.89949, 37.29926], [-120.8995, 37.30008], [-120.89929, 37.30081], [-120.8999, 37.30113], [-120.90112, 37.30163], [-120.90174, 37.30165], [-120.90231, 37.30094], [-120.90234, 37.30035], [-120.90126, 37.29913], [-120.9011, 37.29849], [-120.90098, 37.29752], [-120.90076, 37.29693], [-120.9015, 37.29647], [-120.90266, 37.29673], [-120.90326, 37.29745], [-120.90376, 37.29801], [-120.90371, 37.29834], [-120.90373, 37.29906], [-120.90487, 37.29958], [-120.90567, 37.29914], [-120.90608, 37.29937], [-120.90689, 37.30088], [-120.90777, 37.3015], [-120.90874, 37.3017], [-120.90916, 37.30168], [-120.90991, 37.30145], [-120.91084, 37.30061], [-120.91147, 37.29944], [-120.91163, 37.2981], [-120.91259, 37.29819], [-120.91321, 37.29738], [-120.9136, 37.29695], [-120.91408, 37.29598], [-120.91524, 37.29493], [-120.91574, 37.2946], [-120.91656, 37.29432], [-120.91744, 37.29425], [-120.91835, 37.29462], [-120.91942, 37.29538], [-120.92066, 37.29528], [-120.92158, 37.29527], [-120.92227, 37.29617], [-120.92225, 37.29682], [-120.92186, 37.29716], [-120.92136, 37.29808], [-120.92137, 37.29921], [-120.92108, 37.3006], [-120.9214, 37.30162], [-120.92195, 37.3023], [-120.92264, 37.30286], [-120.92331, 37.30301], [-120.9237, 37.30374], [-120.92282, 37.30398], [-120.92229, 37.30348], [-120.92107, 37.30362], [-120.92102, 37.3043], [-120.9211, 37.30503], [-120.92111, 37.30561], [-120.92158, 37.30608], [-120.92188, 37.30651], [-120.92196, 37.30682], [-120.92188, 37.30728], [-120.92188, 37.30744], [-120.92199, 37.30756], [-120.92213, 37.30755], [-120.92228, 37.30752], [-120.92359, 37.30583], [-120.92378, 37.30517], [-120.92434, 37.30486], [-120.92502, 37.30501], [-120.92522, 37.30519], [-120.9251, 37.30598], [-120.92539, 37.30648], [-120.92599, 37.30673], [-120.92591, 37.30712], [-120.92596, 37.3075], [-120.92628, 37.30768], [-120.92672, 37.30775], [-120.92728, 37.30778], [-120.92784, 37.30803], [-120.92825, 37.30834], [-120.9288, 37.30872], [-120.92918, 37.30902], [-120.92973, 37.30939], [-120.92991, 37.30949]]]]} | Open Access 1 | 16883 | Great Valley Grasslands State Park | 1550 | 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/default.asp?page_id=559 | Merced 37 | 2731.894 | Great Valley Grasslands SP | 1982 | State Park 15 | 4 |
| 16570 | 16570 | 16569 | {"type": "Polygon", "coordinates": [[[-121.24767, 37.02874], [-121.24749, 37.0291], [-121.24733, 37.02932], [-121.24721, 37.02952], [-121.24716, 37.02987], [-121.24716, 37.03018], [-121.2471, 37.03052], [-121.24709, 37.03075], [-121.24719, 37.03098], [-121.24723, 37.03124], [-121.247, 37.0312], [-121.24675, 37.03111], [-121.24648, 37.03093], [-121.24615, 37.0308], [-121.24523, 37.03065], [-121.2448, 37.03054], [-121.24436, 37.03046], [-121.2436, 37.03034], [-121.24324, 37.03041], [-121.24278, 37.03062], [-121.24245, 37.0307], [-121.2422, 37.03073], [-121.24194, 37.0307], [-121.24136, 37.03053], [-121.24101, 37.03053], [-121.24059, 37.03064], [-121.2402, 37.03077], [-121.23967, 37.03097], [-121.23937, 37.03101], [-121.23892, 37.03125], [-121.23853, 37.03152], [-121.23853, 37.03167], [-121.23869, 37.0319], [-121.23879, 37.03214], [-121.23882, 37.03234], [-121.23878, 37.0325], [-121.23865, 37.03268], [-121.23852, 37.03292], [-121.23835, 37.03313], [-121.23808, 37.03333], [-121.23785, 37.03339], [-121.23766, 37.03334], [-121.23721, 37.03298], [-121.23689, 37.03264], [-121.23665, 37.03256], [-121.23639, 37.03255], [-121.23615, 37.03264], [-121.236, 37.03275], [-121.23591, 37.03301], [-121.23605, 37.03353], [-121.23609, 37.03409], [-121.23607, 37.03451], [-121.23602, 37.03474], [-121.23594, 37.03487], [-121.23579, 37.03496], [-121.23563, 37.03503], [-121.2354, 37.03509], [-121.23492, 37.03513], [-121.23457, 37.03512], [-121.23424, 37.03509], [-121.23382, 37.03509], [-121.23334, 37.03512], [-121.23298, 37.03523], [-121.23275, 37.0354], [-121.23248, 37.03569], [-121.23221, 37.03587], [-121.23148, 37.03655], [-121.23115, 37.03669], [-121.2309, 37.03676], [-121.2303, 37.03687], [-121.22967, 37.03682], [-121.22927, 37.03674], [-121.22888, 37.03663], [-121.22854, 37.0366], [-121.22813, 37.03657], [-121.22694, 37.03655], [-121.22662, 37.03659], [-121.22584, 37.03682], [-121.22536, 37.03682], [-121.2244, 37.03679], [-121.22404, 37.03685], [-121.22357, 37.03707], [-121.22333, 37.03716], [-121.22279, 37.03722], [-121.22243, 37.03731], [-121.22211, 37.0375], [-121.2219, 37.03776], [-121.22211, 37.03862], [-121.22214, 37.03901], [-121.22212, 37.03933], [-121.22197, 37.03996], [-121.22205, 37.04039], [-121.22221, 37.04064], [-121.22234, 37.04093], [-121.2223, 37.04173], [-121.22232, 37.04203], [-121.22241, 37.04212], [-121.2226, 37.04224], [-121.22297, 37.04244], [-121.22308, 37.04263], [-121.22317, 37.04317], [-121.2232, 37.04366], [-121.22317, 37.04434], [-121.22308, 37.04468], [-121.22301, 37.04505], [-121.22324, 37.04548], [-121.22333, 37.04608], [-121.22322, 37.04628], [-121.22319, 37.04646], [-121.22332, 37.04669], [-121.22372, 37.04704], [-121.22381, 37.04726], [-121.22385, 37.04752], [-121.22388, 37.04793], [-121.22389, 37.04877], [-121.22395, 37.04903], [-121.22415, 37.04935], [-121.22465, 37.04968], [-121.22483, 37.04993], [-121.22488, 37.05011], [-121.22489, 37.05029], [-121.22474, 37.05116], [-121.22463, 37.05158], [-121.22449, 37.0519], [-121.2243, 37.05196], [-121.22379, 37.05237], [-121.2237, 37.05289], [-121.22363, 37.05314], [-121.22347, 37.05332], [-121.2233, 37.05346], [-121.22318, 37.05378], [-121.22314, 37.05401], [-121.22303, 37.05423], [-121.22258, 37.05437], [-121.22219, 37.05436], [-121.22111, 37.0544], [-121.22036, 37.05447], [-121.21996, 37.05449], [-121.21964, 37.05442], [-121.21899, 37.0541], [-121.21882, 37.05415], [-121.21841, 37.05434], [-121.21786, 37.05447], [-121.21757, 37.05472], [-121.21724, 37.05506], [-121.21678, 37.05545], [-121.21627, 37.05586], [-121.21599, 37.05614], [-121.21571, 37.05632], [-121.21543, 37.05641], [-121.21516, 37.05638], [-121.21493, 37.05633], [-121.21477, 37.05624], [-121.21469, 37.05604], [-121.21443, 37.05569], [-121.21418, 37.05551], [-121.21349, 37.05534], [-121.21306, 37.05517], [-121.21262, 37.05504], [-121.21239, 37.0551], [-121.21223, 37.05521], [-121.21215, 37.05535], [-121.21183, 37.05582], [-121.21162, 37.05605], [-121.21146, 37.05616], [-121.21117, 37.0563], [-121.21095, 37.05645], [-121.21086, 37.05659], [-121.21083, 37.05683], [-121.21075, 37.05706], [-121.21039, 37.05765], [-121.2101, 37.05797], [-121.20982, 37.05822], [-121.20947, 37.05848], [-121.20914, 37.05867], [-121.20898, 37.05886], [-121.20894, 37.05907], [-121.20894, 37.05963], [-121.20883, 37.05999], [-121.20869, 37.06037], [-121.20854, 37.06068], [-121.20827, 37.06144], [-121.20823, 37.06176], [-121.20827, 37.06197], [-121.20861, 37.06281], [-121.20881, 37.06309], [-121.20916, 37.06333], [-121.20955, 37.06375], [-121.20968, 37.06396], [-121.20976, 37.06421], [-121.20979, 37.06454], [-121.20706, 37.06371], [-121.20641, 37.06313], [-121.20424, 37.06261], [-121.20272, 37.0635], [-121.20001, 37.06717], [-121.19974, 37.06745], [-121.19953, 37.0676], [-121.1993, 37.06774], [-121.19892, 37.06791], [-121.19891, 37.06794], [-121.19864, 37.06801], [-121.19835, 37.06806], [-121.19791, 37.06809], [-121.19762, 37.06807], [-121.19733, 37.06803], [-121.19691, 37.06791], [-121.19665, 37.0678], [-121.19086, 37.06509], [-121.18861, 37.06492], [-121.18034, 37.06489], [-121.18146, 37.06108], [-121.1711, 37.05618], [-121.16075, 37.06456], [-121.15771, 37.06392], [-121.15086, 37.05868], [-121.15204, 37.05085], [-121.14979, 37.04878], [-121.15146, 37.04332], [-121.1565, 37.03962], [-121.15055, 37.03862], [-121.15258, 37.03435], [-121.16257, 37.03298], [-121.16717, 37.03231], [-121.17106, 37.03178], [-121.18964, 37.02908], [-121.199, 37.02774], [-121.21722, 37.02522], [-121.23513, 37.02232], [-121.24262, 37.02113], [-121.24281, 37.02115], [-121.24315, 37.02143], [-121.24338, 37.02165], [-121.24358, 37.02193], [-121.24375, 37.02215], [-121.24397, 37.02227], [-121.24409, 37.02251], [-121.24419, 37.02276], [-121.24506, 37.02333], [-121.24539, 37.02349], [-121.24577, 37.02358], [-121.246, 37.02367], [-121.24635, 37.02413], [-121.24643, 37.0244], [-121.24644, 37.02465], [-121.24642, 37.02495], [-121.24667, 37.02512], [-121.24673, 37.02526], [-121.24715, 37.02604], [-121.24738, 37.02631], [-121.24749, 37.02652], [-121.24751, 37.02673], [-121.24744, 37.02699], [-121.24739, 37.02755], [-121.2474, 37.02785], [-121.2475, 37.02833], [-121.24764, 37.02851], [-121.24767, 37.02874]], [[-121.2005, 37.06116], [-121.20045, 37.06115], [-121.20044, 37.06119], [-121.20049, 37.06119], [-121.2005, 37.06116]]]} | Open Access 1 | 16888 | Pacheco State Park | 1668 | 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=560 | Merced 37 | 6223.09 | Pacheco SP | 1995 | State Park 15 | 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]);