units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
20 rows where ACCESS_TYP = 2 and COUNTY = 26
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, AGNCY_NAME, AGNCY_TYP, LAYER, MNG_AG_LEV, YR_EST, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1404 | 1404 | 1403 | {"type": "Polygon", "coordinates": [[[-122.19364, 38.14035], [-122.19255, 38.14085], [-122.19094, 38.14174], [-122.18499, 38.14511], [-122.18197, 38.14671], [-122.181, 38.14603], [-122.18073, 38.14577], [-122.17709, 38.14318], [-122.17439, 38.14115], [-122.17323, 38.14032], [-122.17291, 38.14042], [-122.17248, 38.14069], [-122.17242, 38.1407], [-122.17245, 38.14065], [-122.17237, 38.14024], [-122.17271, 38.14009], [-122.17271, 38.14007], [-122.1676, 38.13214], [-122.16758, 38.13205], [-122.1682, 38.13241], [-122.17857, 38.12654], [-122.18461, 38.12402], [-122.18657, 38.12318], [-122.18795, 38.12517], [-122.18982, 38.12792], [-122.18862, 38.12856], [-122.18862, 38.12858], [-122.18901, 38.1289], [-122.18938, 38.12931], [-122.18977, 38.1297], [-122.19033, 38.13018], [-122.19068, 38.13063], [-122.19095, 38.13094], [-122.19139, 38.13124], [-122.19179, 38.13148], [-122.19208, 38.13161], [-122.19238, 38.13177], [-122.19408, 38.13497], [-122.19423, 38.13573], [-122.19448, 38.13723], [-122.19412, 38.13869], [-122.19364, 38.14035]], [[-122.19099, 38.1342], [-122.19123, 38.13468], [-122.19131, 38.13478], [-122.19157, 38.13526], [-122.19183, 38.13515], [-122.19156, 38.13457], [-122.19133, 38.13422], [-122.1909, 38.13352], [-122.19067, 38.13331], [-122.19034, 38.13316], [-122.18936, 38.13246], [-122.18847, 38.13188], [-122.18796, 38.13157], [-122.18726, 38.13108], [-122.18631, 38.13097], [-122.1859, 38.13091], [-122.18525, 38.13097], [-122.18611, 38.13175], [-122.18555, 38.13206], [-122.18555, 38.13207], [-122.18649, 38.13293], [-122.18679, 38.13315], [-122.18704, 38.13336], [-122.18772, 38.13324], [-122.18846, 38.13375], [-122.18936, 38.13477], [-122.18982, 38.1347], [-122.1903, 38.13436], [-122.19041, 38.13416], [-122.19078, 38.13407], [-122.19099, 38.1342]]]} | Restricted Access 2 | 8824 | Vallejo Swett | 26783 | 3081 | Solano Land Trust 361 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/ | Non Governmental Organization 10 | 3081 | Solano Land Trust 358 | Non Profit 6 | Non Profit - Land Trust 10 | Solano 26 | 861.807 | Vallejo Swett | 1999 | Private Conservation 16 | 2 | |
| 2376 | 2376 | 2375 | {"type": "Polygon", "coordinates": [[[-122.14962, 38.16492], [-122.14827, 38.16492], [-122.14383, 38.16372], [-122.14268, 38.16401], [-122.14097, 38.16366], [-122.1404, 38.16353], [-122.1403, 38.16348], [-122.13817, 38.16059], [-122.13799, 38.16055], [-122.13779, 38.16009], [-122.13516, 38.15925], [-122.13438, 38.15924], [-122.1332, 38.15863], [-122.13319, 38.15864], [-122.13323, 38.15938], [-122.13347, 38.16], [-122.13346, 38.16038], [-122.1328, 38.16056], [-122.12629, 38.16307], [-122.12495, 38.16282], [-122.12063, 38.16183], [-122.12048, 38.16095], [-122.11981, 38.16003], [-122.11869, 38.16047], [-122.11495, 38.1562], [-122.12004, 38.15349], [-122.12095, 38.14364], [-122.14773, 38.14371], [-122.14962, 38.16492]]]} | Restricted Access 2 | 17191 | King Ranch | 20659 | 3081 | Solano Land Trust 361 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/ | Non Governmental Organization 10 | 3081 | Solano Land Trust 358 | Non Profit 6 | Non Profit - Land Trust 10 | Solano 26 | 1313.512 | King Ranch | 2002 | Private Conservation 16 | 2 | |
| 2551 | 2551 | 2550 | {"type": "Polygon", "coordinates": [[[-122.19184, 38.13515], [-122.19158, 38.13526], [-122.19131, 38.13478], [-122.19123, 38.13468], [-122.19099, 38.1342], [-122.19079, 38.13407], [-122.19041, 38.13416], [-122.1903, 38.13436], [-122.18981, 38.13471], [-122.18936, 38.13477], [-122.18846, 38.13375], [-122.18772, 38.13324], [-122.18704, 38.13336], [-122.18679, 38.13315], [-122.18649, 38.13293], [-122.18554, 38.13206], [-122.1861, 38.13174], [-122.18524, 38.13097], [-122.18589, 38.13091], [-122.18631, 38.13097], [-122.18726, 38.13107], [-122.18796, 38.13157], [-122.18847, 38.13188], [-122.18936, 38.13246], [-122.19034, 38.13316], [-122.19067, 38.13331], [-122.1909, 38.13352], [-122.19133, 38.13422], [-122.19156, 38.13457], [-122.19184, 38.13515]]]} | Restricted Access 2 | 17806 | McIntyre Ranch | 22040 | 1365 | Vallejo, City of 531 | City 2 | City Agency 2 | http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails | City 2 | 1365 | Vallejo, City of 524 | City 2 | City Agency 2 | Solano 26 | 23.753 | McIntyre Ranch | 0 | Local Other or Unknown 14 | 4 | |
| 3546 | 3546 | 3545 | {"type": "Polygon", "coordinates": [[[-121.94776, 38.35645], [-121.94605, 38.35706], [-121.94576, 38.3565], [-121.94534, 38.35665], [-121.94491, 38.35597], [-121.94666, 38.35525], [-121.94676, 38.35524], [-121.94734, 38.35568], [-121.94757, 38.3557], [-121.94774, 38.35584], [-121.94776, 38.35645]]]} | Restricted Access 2 | 28309 | Cooper School Park | 31609 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 7.337 | Cooper School Park | 0 | Local Park 2 | 4 | |
| 3803 | 3803 | 3802 | {"type": "MultiPolygon", "coordinates": [[[[-122.10658, 38.5004], [-122.09761, 38.50035], [-122.09774, 38.50434], [-122.09775, 38.50723], [-122.09305, 38.50723], [-122.093, 38.50397], [-122.09232, 38.49092], [-122.09697, 38.4909], [-122.09687, 38.4893], [-122.09688, 38.48804], [-122.0969, 38.48794], [-122.09688, 38.4865], [-122.09693, 38.48236], [-122.10164, 38.48238], [-122.10165, 38.48207], [-122.10631, 38.48211], [-122.10633, 38.48923], [-122.1065, 38.49317], [-122.10655, 38.49628], [-122.10658, 38.5004]]], [[[-122.1064, 38.50769], [-122.10633, 38.50813], [-122.10619, 38.50846], [-122.1061, 38.5086], [-122.10598, 38.5087], [-122.10582, 38.50877], [-122.10572, 38.50879], [-122.10561, 38.50879], [-122.10518, 38.50894], [-122.10504, 38.50897], [-122.10464, 38.50918], [-122.10452, 38.50932], [-122.10427, 38.5095], [-122.1042, 38.50947], [-122.10212, 38.50969], [-122.10231, 38.50753], [-122.10582, 38.50758], [-122.1064, 38.50769]]]]} | Restricted Access 2 | 35111 | Stebbins Cold Canyon Reserve | 25816 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Solano 26 | 606.446 | Stebbins Cold Canyon Reserve | 0 | State Conservation Area 8 | 2 | |
| 5596 | 5596 | 5595 | {"type": "Polygon", "coordinates": [[[-122.16317, 38.26342], [-122.16304, 38.26457], [-122.16289, 38.26488], [-122.16282, 38.26526], [-122.16275, 38.26549], [-122.16266, 38.2657], [-122.16195, 38.26717], [-122.16224, 38.2679], [-122.16257, 38.26905], [-122.16284, 38.27014], [-122.16307, 38.27081], [-122.16288, 38.27111], [-122.16026, 38.27474], [-122.15949, 38.27508], [-122.15854, 38.27538], [-122.15786, 38.27533], [-122.15697, 38.27515], [-122.15593, 38.27509], [-122.15389, 38.27474], [-122.15229, 38.27479], [-122.15135, 38.27503], [-122.15097, 38.2751], [-122.15009, 38.27511], [-122.14943, 38.27508], [-122.14882, 38.27519], [-122.14823, 38.27604], [-122.1478, 38.27661], [-122.14631, 38.27761], [-122.13521, 38.27753], [-122.12964, 38.27753], [-122.12964, 38.27358], [-122.12749, 38.27358], [-122.12613, 38.27372], [-122.12677, 38.27314], [-122.12722, 38.27235], [-122.12864, 38.27056], [-122.12997, 38.26942], [-122.13099, 38.26817], [-122.13233, 38.26904], [-122.13255, 38.26879], [-122.13276, 38.26866], [-122.13302, 38.26858], [-122.13329, 38.26857], [-122.1335, 38.26861], [-122.13368, 38.26868], [-122.13376, 38.26873], [-122.13394, 38.2689], [-122.13404, 38.26897], [-122.13452, 38.26921], [-122.13467, 38.26831], [-122.13469, 38.26791], [-122.13469, 38.26771], [-122.13465, 38.26747], [-122.1346, 38.26732], [-122.13447, 38.26712], [-122.13374, 38.26611], [-122.13321, 38.26499], [-122.13249, 38.26377], [-122.13207, 38.26273], [-122.13199, 38.26246], [-122.13191, 38.26232], [-122.13177, 38.26151], [-122.13167, 38.2608], [-122.13078, 38.26054], [-122.13299, 38.25698], [-122.13349, 38.25596], [-122.13646, 38.25362], [-122.13716, 38.25378], [-122.13767, 38.25385], [-122.1381, 38.25388], [-122.13872, 38.25387], [-122.13915, 38.25382], [-122.13974, 38.25371], [-122.14001, 38.25365], [-122.14171, 38.25305], [-122.14246, 38.25282], [-122.14343, 38.25454], [-122.14393, 38.2555], [-122.14397, 38.25573], [-122.14406, 38.25575], [-122.14825, 38.25531], [-122.14953, 38.25523], [-122.15289, 38.25406], [-122.15289, 38.25346], [-122.15461, 38.25303], [-122.15561, 38.25282], [-122.1576, 38.25255], [-122.15744, 38.25221], [-122.15741, 38.25212], [-122.15742, 38.25209], [-122.15733, 38.25189], [-122.15733, 38.25176], [-122.15735, 38.25169], [-122.15763, 38.25182], [-122.15782, 38.2522], [-122.15779, 38.25262], [-122.15788, 38.25266], [-122.15749, 38.25327], [-122.15828, 38.25467], [-122.15867, 38.25522], [-122.15877, 38.2554], [-122.15876, 38.2556], [-122.15817, 38.25561], [-122.15798, 38.25577], [-122.15808, 38.25637], [-122.15826, 38.25644], [-122.15879, 38.25637], [-122.15885, 38.25655], [-122.1589, 38.25716], [-122.159, 38.25759], [-122.15912, 38.25797], [-122.15928, 38.25874], [-122.15935, 38.25894], [-122.15937, 38.25965], [-122.15941, 38.26015], [-122.15918, 38.26085], [-122.15922, 38.26103], [-122.15916, 38.26174], [-122.15925, 38.26207], [-122.1592, 38.26243], [-122.15946, 38.26348], [-122.15969, 38.26398], [-122.15971, 38.26398], [-122.16233, 38.26243], [-122.16237, 38.26247], [-122.16206, 38.2631], [-122.1625, 38.26349], [-122.16317, 38.26342]]]} | Restricted Access 2 | 35116 | Rockville Trails Preserve | 28161 | 3081 | Solano Land Trust 361 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/ | Non Governmental Organization 10 | 3081 | Solano Land Trust 358 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/RockvilleTrails.aspx | Solano 26 | 1573.93 | Rockville Trails Preserve | 0 | Private Conservation 16 | 2 |
| 7627 | 7627 | 7626 | {"type": "Polygon", "coordinates": [[[-122.20934, 38.07296], [-122.20924, 38.07319], [-122.20883, 38.07387], [-122.2085, 38.07392], [-122.20821, 38.07399], [-122.20786, 38.07424], [-122.20742, 38.07433], [-122.20715, 38.07423], [-122.20684, 38.07421], [-122.20685, 38.07409], [-122.20691, 38.07399], [-122.20701, 38.07373], [-122.20708, 38.0736], [-122.20707, 38.07355], [-122.20729, 38.07329], [-122.20754, 38.07308], [-122.2077, 38.07299], [-122.20824, 38.07272], [-122.2085, 38.07255], [-122.20874, 38.07232], [-122.20891, 38.07208], [-122.20916, 38.0723], [-122.20934, 38.07296]]]} | Restricted Access 2 | 47621 | Glen Cove School Park | 31356 | 2224 | Greater Vallejo Recreation and Park District 341 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/?page=Glen_Cove_School_Park | Solano 26 | 6.841 | Glen Cove School Park | 0 | Local Park 2 | 4 |
| 7795 | 7795 | 7794 | {"type": "Polygon", "coordinates": [[[-122.1729, 38.16479], [-122.14962, 38.16492], [-122.14663, 38.13128], [-122.16514, 38.13302], [-122.16508, 38.13304], [-122.16505, 38.13338], [-122.16517, 38.13339], [-122.17024, 38.14122], [-122.17098, 38.14089], [-122.17096, 38.14104], [-122.17094, 38.14109], [-122.16917, 38.14194], [-122.16924, 38.14268], [-122.1697, 38.1454], [-122.17088, 38.15287], [-122.17224, 38.16075], [-122.1729, 38.16479]]]} | Restricted Access 2 | 8836 | Eastern Swett | 18392 | 3081 | Solano Land Trust 361 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/ | Non Governmental Organization 10 | 3081 | Solano Land Trust 358 | Non Profit 6 | Non Profit - Land Trust 10 | Solano 26 | 1715.026 | Eastern Swett | 2002 | Private Conservation 16 | 2 | |
| 9930 | 9930 | 9929 | {"type": "Polygon", "coordinates": [[[-121.84235, 38.25685], [-121.83602, 38.26394], [-121.83312, 38.26707], [-121.83311, 38.2711], [-121.82945, 38.27111], [-121.82645, 38.27432], [-121.82358, 38.27798], [-121.82356, 38.28536], [-121.82097, 38.28535], [-121.81442, 38.28518], [-121.81447, 38.28517], [-121.81448, 38.28333], [-121.81451, 38.28254], [-121.81452, 38.27627], [-121.80554, 38.27616], [-121.80553, 38.27613], [-121.8053, 38.27616], [-121.80552, 38.25635], [-121.82403, 38.25652], [-121.82404, 38.25691], [-121.84235, 38.25685]]]} | Restricted Access 2 | 17078 | Jepson Prairie Reserve | 33186 | 3081 | Solano Land Trust 361 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/ | Non Governmental Organization 10 | 217 | University of California 51 | State 5 | State Agency 5 | Solano 26 | 1546.442 | Jepson Prairie Reserve | 0 | State Conservation Area 8 | 2 | |
| 10088 | 10088 | 10087 | {"type": "Polygon", "coordinates": [[[-122.21548, 38.18844], [-122.20971, 38.18989], [-122.2097, 38.1899], [-122.20972, 38.18993], [-122.20957, 38.18997], [-122.20942, 38.19007], [-122.20927, 38.19031], [-122.20939, 38.19045], [-122.20962, 38.19067], [-122.2102, 38.19107], [-122.21063, 38.19142], [-122.21102, 38.19176], [-122.21125, 38.19204], [-122.21086, 38.19191], [-122.21039, 38.1919], [-122.20803, 38.19229], [-122.2065, 38.19244], [-122.20517, 38.19253], [-122.20303, 38.195], [-122.20038, 38.19816], [-122.19827, 38.19743], [-122.18154, 38.19131], [-122.17397, 38.18864], [-122.17227, 38.18783], [-122.17294, 38.18746], [-122.17317, 38.18734], [-122.17373, 38.1871], [-122.17404, 38.187], [-122.17455, 38.18669], [-122.17517, 38.18645], [-122.17589, 38.18624], [-122.177, 38.18601], [-122.17825, 38.18569], [-122.17876, 38.18564], [-122.17926, 38.1855], [-122.18022, 38.1852], [-122.18082, 38.18493], [-122.18155, 38.18446], [-122.18212, 38.18393], [-122.18282, 38.18333], [-122.18367, 38.18248], [-122.1846, 38.18173], [-122.18525, 38.18092], [-122.18609, 38.1804], [-122.18671, 38.18021], [-122.18724, 38.17988], [-122.18769, 38.1795], [-122.18813, 38.17926], [-122.18895, 38.17876], [-122.1896, 38.17833], [-122.1904, 38.17862], [-122.19569, 38.18033], [-122.20124, 38.18226], [-122.20456, 38.18336], [-122.20852, 38.17882], [-122.20856, 38.17702], [-122.20843, 38.17334], [-122.20855, 38.17294], [-122.20885, 38.17308], [-122.20916, 38.17343], [-122.21013, 38.17418], [-122.21058, 38.17411], [-122.21097, 38.17455], [-122.211, 38.17485], [-122.21097, 38.175], [-122.21098, 38.17511], [-122.21097, 38.17545], [-122.21112, 38.17572], [-122.21146, 38.17591], [-122.21166, 38.17631], [-122.21193, 38.17662], [-122.21208, 38.17687], [-122.21289, 38.17725], [-122.21347, 38.17773], [-122.21373, 38.17806], [-122.2141, 38.17832], [-122.21444, 38.1787], [-122.21482, 38.17925], [-122.21499, 38.17946], [-122.21492, 38.17987], [-122.21465, 38.18028], [-122.21414, 38.18069], [-122.21366, 38.18093], [-122.21364, 38.18099], [-122.21359, 38.18105], [-122.21344, 38.18133], [-122.21336, 38.18173], [-122.21328, 38.18201], [-122.21335, 38.1826], [-122.21346, 38.18297], [-122.21354, 38.18331], [-122.21342, 38.18371], [-122.21326, 38.18399], [-122.21298, 38.18429], [-122.21282, 38.18454], [-122.21286, 38.18479], [-122.21325, 38.1851], [-122.21363, 38.18587], [-122.2139, 38.18631], [-122.21544, 38.18836], [-122.21548, 38.18844]]]} | Restricted Access 2 | 17506 | Lynch Canyon | 29277 | 3081 | Solano Land Trust 361 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/ | Non Governmental Organization 10 | 3081 | Solano Land Trust 358 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/LynchCanyon.aspx | Solano 26 | 1152.887 | Lynch Canyon | 1994 | Private Conservation 16 | 2 |
| 11287 | 11287 | 11286 | {"type": "MultiPolygon", "coordinates": [[[[-121.75699, 38.51703], [-121.75697, 38.51836], [-121.75692, 38.51824], [-121.75685, 38.51815], [-121.75673, 38.5181], [-121.75649, 38.51805], [-121.75317, 38.51763], [-121.75268, 38.51755], [-121.75246, 38.51753], [-121.75205, 38.51753], [-121.75187, 38.51754], [-121.75157, 38.51761], [-121.7512, 38.51763], [-121.74956, 38.51765], [-121.74832, 38.51762], [-121.74759, 38.51766], [-121.74722, 38.51765], [-121.74666, 38.51773], [-121.74532, 38.518], [-121.7443, 38.51814], [-121.74362, 38.5182], [-121.74052, 38.51828], [-121.73603, 38.51837], [-121.73603, 38.51729], [-121.74998, 38.51721], [-121.75019, 38.51722], [-121.75019, 38.51532], [-121.75511, 38.51533], [-121.75694, 38.5155], [-121.75693, 38.51703], [-121.75699, 38.51703]]], [[[-121.76097, 38.51739], [-121.76006, 38.51843], [-121.75913, 38.51832], [-121.75904, 38.5183], [-121.75863, 38.51828], [-121.75754, 38.51816], [-121.75727, 38.51816], [-121.75715, 38.51821], [-121.75707, 38.51832], [-121.75704, 38.51831], [-121.75704, 38.51828], [-121.75706, 38.51702], [-121.75755, 38.51691], [-121.75843, 38.51664], [-121.75878, 38.51658], [-121.75898, 38.51658], [-121.75928, 38.5167], [-121.75956, 38.51687], [-121.75981, 38.51698], [-121.76073, 38.51727], [-121.76097, 38.51739]]], [[[-121.77089, 38.51779], [-121.77044, 38.51813], [-121.77009, 38.51842], [-121.7697, 38.51852], [-121.76947, 38.51856], [-121.76771, 38.51878], [-121.76634, 38.51889], [-121.76399, 38.51899], [-121.76264, 38.51895], [-121.76206, 38.51888], [-121.76141, 38.51873], [-121.76093, 38.51859], [-121.7607, 38.51857], [-121.76034, 38.51847], [-121.76016, 38.51844], [-121.76105, 38.51743], [-121.76119, 38.5175], [-121.76145, 38.51753], [-121.76227, 38.51756], [-121.76251, 38.51759], [-121.76346, 38.51758], [-121.76378, 38.51753], [-121.76414, 38.51747], [-121.76455, 38.51742], [-121.76572, 38.51737], [-121.76747, 38.51724], [-121.76764, 38.51725], [-121.7703, 38.51761], [-121.77089, 38.51779]]], [[[-121.78397, 38.52325], [-121.78363, 38.52355], [-121.7837, 38.52387], [-121.78274, 38.52399], [-121.78249, 38.52399], [-121.78229, 38.52396], [-121.78093, 38.52354], [-121.78057, 38.5234], [-121.78026, 38.52324], [-121.77342, 38.51964], [-121.77204, 38.51897], [-121.77195, 38.51896], [-121.77189, 38.51899], [-121.77187, 38.51898], [-121.77254, 38.51835], [-121.77264, 38.5183], [-121.77285, 38.51839], [-121.7733, 38.51865], [-121.77383, 38.51887], [-121.77398, 38.519], [-121.77426, 38.51917], [-121.77518, 38.51962], [-121.77547, 38.51987], [-121.77588, 38.52002], [-121.77621, 38.52021], [-121.77625, 38.52028], [-121.77629, 38.5203], [-121.77654, 38.52029], [-121.77697, 38.52042], [-121.7771, 38.52048], [-121.77734, 38.52062], [-121.77736, 38.52066], [-121.77735, 38.52076], [-121.77768, 38.52098], [-121.77772, 38.52104], [-121.77788, 38.52111], [-121.77793, 38.52117], [-121.77812, 38.5213], [-121.77847, 38.52147], [-121.77865, 38.52165], [-121.7788, 38.52176], [-121.77891, 38.52189], [-121.77936, 38.5222], [-121.77961, 38.52243], [-121.77984, 38.52253], [-121.78114, 38.52306], [-121.78152, 38.52312], [-121.782, 38.52312], [-121.7824, 38.52317], [-121.78397, 38.52325]]], [[[-121.78388, 38.5251], [-121.78364, 38.52523], [-121.78353, 38.52607], [-121.78304, 38.52603], [-121.78293, 38.52649], [-121.78283, 38.52648], [-121.78288, 38.52627], [-121.78292, 38.52596], [-121.78295, 38.52562], [-121.78294, 38.52546], [-121.78288, 38.52518], [-121.78253, 38.52433], [-121.78251, 38.52423], [-121.78252, 38.52418], [-121.78255, 38.52412], [-121.78258, 38.52409], [-121.78264, 38.52407], [-121.78305, 38.52401], [-121.78319, 38.52471], [-121.78304, 38.52473], [-121.78308, 38.52495], [-121.78379, 38.52489], [-121.78388, 38.5251]]]]} | Restricted Access 2 | 21914 | Putah Creek Riparian Reserve | 24035 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Solano 26 | 136.113 | Putah Creek Riparian Reserve | 0 | State Conservation Area 8 | 2 | |
| 12476 | 12476 | 12475 | {"type": "Polygon", "coordinates": [[[-122.00372, 38.35245], [-122.00296, 38.35252], [-122.00294, 38.3523], [-122.00275, 38.35231], [-122.00272, 38.35216], [-122.00244, 38.35216], [-122.00227, 38.35204], [-122.00224, 38.35177], [-122.00199, 38.35177], [-122.00197, 38.35154], [-122.00179, 38.35153], [-122.00176, 38.35144], [-122.00151, 38.35143], [-122.00148, 38.35103], [-122.0019, 38.35074], [-122.00199, 38.35076], [-122.00224, 38.35092], [-122.00243, 38.35107], [-122.00248, 38.35121], [-122.00263, 38.35141], [-122.00357, 38.35193], [-122.00365, 38.352], [-122.00372, 38.35245]]]} | Restricted Access 2 | 28306 | Alamo School Park | 31601 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 4.025 | Alamo School Park | 0 | Local Park 2 | 4 | |
| 12494 | 12494 | 12493 | {"type": "Polygon", "coordinates": [[[-121.95197, 38.33224], [-121.9516, 38.33235], [-121.95152, 38.33221], [-121.95135, 38.33224], [-121.95129, 38.33217], [-121.95113, 38.33221], [-121.95058, 38.3326], [-121.95066, 38.33278], [-121.95007, 38.33302], [-121.95032, 38.33339], [-121.94992, 38.33336], [-121.94998, 38.33173], [-121.9501, 38.33154], [-121.95021, 38.33142], [-121.95046, 38.33125], [-121.95048, 38.33103], [-121.95196, 38.331], [-121.95197, 38.33224]]]} | Restricted Access 2 | 28307 | Cambridge School Park | 31605 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 6.902 | Cambridge School Park | 0 | Local Park 2 | 4 | |
| 12497 | 12497 | 12496 | {"type": "Polygon", "coordinates": [[[-122.0039, 38.3646], [-122.00387, 38.36624], [-122.00154, 38.3662], [-122.00153, 38.36566], [-122.00163, 38.36566], [-122.00165, 38.36592], [-122.00216, 38.36593], [-122.00217, 38.36567], [-122.00267, 38.36566], [-122.00267, 38.36535], [-122.00318, 38.36535], [-122.00318, 38.36517], [-122.00274, 38.36462], [-122.00284, 38.36458], [-122.0039, 38.3646]]]} | Restricted Access 2 | 28311 | Hemlock School Park | 31596 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 5.323 | Hemlock School Park | 0 | Local Park 2 | 4 | |
| 12858 | 12858 | 12857 | {"type": "Polygon", "coordinates": [[[-122.03267, 38.31034], [-122.03263, 38.31122], [-122.03261, 38.31135], [-122.03212, 38.3133], [-122.02898, 38.31232], [-122.02885, 38.31231], [-122.02696, 38.31291], [-122.0254, 38.31237], [-122.02458, 38.31092], [-122.02115, 38.30989], [-122.0203, 38.30958], [-122.01987, 38.30887], [-122.01952, 38.30865], [-122.01898, 38.3085], [-122.01805, 38.30781], [-122.01789, 38.30725], [-122.0191, 38.30705], [-122.02055, 38.30706], [-122.02129, 38.30724], [-122.02334, 38.30805], [-122.02476, 38.30814], [-122.02476, 38.30826], [-122.02483, 38.30887], [-122.0281, 38.30887], [-122.02811, 38.30884], [-122.02937, 38.30929], [-122.02941, 38.30957], [-122.02961, 38.30975], [-122.02986, 38.30979], [-122.03025, 38.30968], [-122.0305, 38.30968], [-122.03063, 38.31002], [-122.03106, 38.31005], [-122.03113, 38.30985], [-122.03152, 38.31008], [-122.03182, 38.31012], [-122.03188, 38.3105], [-122.03204, 38.31066], [-122.03224, 38.31115], [-122.03235, 38.31105], [-122.03267, 38.31034]]]} | Restricted Access 2 | 22288 | Lagoon Valley Gateway Open Space | 30789 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 96.658 | Lagoon Valley Gateway OS | 0 | Local Recreation Area 3 | 4 | |
| 14572 | 14572 | 14571 | {"type": "Polygon", "coordinates": [[[-121.99785, 38.15685], [-121.99598, 38.1576], [-121.99716, 38.15927], [-121.99666, 38.15949], [-121.9971, 38.16029], [-121.99485, 38.16124], [-121.99394, 38.16074], [-121.99091, 38.16057], [-121.99045, 38.16043], [-121.98978, 38.16007], [-121.98937, 38.15959], [-121.98931, 38.15916], [-121.98953, 38.15829], [-121.98946, 38.15811], [-121.98786, 38.15733], [-121.98772, 38.15722], [-121.9876, 38.15658], [-121.98653, 38.1545], [-121.9901, 38.15315], [-121.99235, 38.15279], [-121.99506, 38.1517], [-121.99785, 38.15685]]]} | Restricted Access 2 | 47518 | Grizzly Island Wildlife Area | 19524 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Grizzly-Island-WA | Solano 26 | 161.374 | Grizzly Island Wildlife Area | 1931 | State Conservation Area 8 | 2 |
| 15520 | 15520 | 15519 | {"type": "Polygon", "coordinates": [[[-121.84233, 38.27135], [-121.84227, 38.27465], [-121.84193, 38.27468], [-121.842, 38.27648], [-121.84228, 38.27646], [-121.84225, 38.2783], [-121.83652, 38.27835], [-121.83656, 38.27647], [-121.83789, 38.27642], [-121.83783, 38.27469], [-121.83544, 38.27473], [-121.83532, 38.27836], [-121.82374, 38.27819], [-121.82374, 38.27777], [-121.82992, 38.27111], [-121.83175, 38.27111], [-121.83725, 38.27124], [-121.83731, 38.2729], [-121.8386, 38.27297], [-121.83861, 38.27296], [-121.83864, 38.27127], [-121.84233, 38.27135]], [[-121.83313, 38.27467], [-121.83319, 38.27276], [-121.83263, 38.27277], [-121.83262, 38.27469], [-121.83313, 38.27467]], [[-121.84011, 38.27472], [-121.84005, 38.27652], [-121.84099, 38.27645], [-121.84107, 38.27469], [-121.84011, 38.27472]]]} | Restricted Access 2 | 18016 | Calhoun Cut Ecological Reserve | 16682 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Calhoun-Cut-ER | Solano 26 | 238.5 | Calhoun Cut ER | 1993 | State Conservation Area 8 | 2 |
| 15853 | 15853 | 15852 | {"type": "Polygon", "coordinates": [[[-122.40701, 38.1558], [-122.4061, 38.15579], [-122.40609, 38.15581], [-122.40612, 38.15588], [-122.40423, 38.15594], [-122.40393, 38.15584], [-122.3963, 38.15586], [-122.36626, 38.15587], [-122.36687, 38.15482], [-122.36715, 38.15402], [-122.36716, 38.1538], [-122.36714, 38.15358], [-122.36709, 38.15336], [-122.36705, 38.15322], [-122.36685, 38.15288], [-122.36669, 38.15269], [-122.36638, 38.15247], [-122.36605, 38.1523], [-122.36565, 38.15225], [-122.36541, 38.15224], [-122.36505, 38.15233], [-122.36429, 38.15258], [-122.36438, 38.15181], [-122.36434, 38.15055], [-122.36431, 38.14595], [-122.36426, 38.14285], [-122.36434, 38.14207], [-122.36437, 38.14169], [-122.36576, 38.14221], [-122.36811, 38.14332], [-122.3696, 38.14394], [-122.37114, 38.14428], [-122.3755, 38.14554], [-122.37617, 38.14592], [-122.37659, 38.14629], [-122.37756, 38.14698], [-122.37939, 38.14793], [-122.38052, 38.14854], [-122.38053, 38.14853], [-122.38055, 38.14606], [-122.38003, 38.14598], [-122.37858, 38.14525], [-122.37742, 38.14504], [-122.37609, 38.14458], [-122.37307, 38.14323], [-122.36585, 38.14046], [-122.36362, 38.13981], [-122.36295, 38.13953], [-122.36133, 38.13896], [-122.36078, 38.13868], [-122.3602, 38.13857], [-122.35958, 38.13826], [-122.35892, 38.1379], [-122.35782, 38.13749], [-122.35577, 38.13678], [-122.35534, 38.13661], [-122.35486, 38.13658], [-122.35396, 38.13625], [-122.35318, 38.136], [-122.35183, 38.13539], [-122.35053, 38.13484], [-122.34938, 38.13437], [-122.34845, 38.13391], [-122.34763, 38.13358], [-122.3463, 38.13314], [-122.34561, 38.13282], [-122.34488, 38.13241], [-122.34449, 38.13229], [-122.34435, 38.13223], [-122.34434, 38.13224], [-122.34433, 38.13458], [-122.33483, 38.13109], [-122.32238, 38.12607], [-122.31734, 38.12411], [-122.31156, 38.12166], [-122.31076, 38.12118], [-122.30995, 38.12073], [-122.30911, 38.1203], [-122.30825, 38.1199], [-122.30738, 38.11952], [-122.30649, 38.11916], [-122.30559, 38.11883], [-122.30467, 38.11852], [-122.30374, 38.11824], [-122.30162, 38.11788], [-122.30003, 38.11771], [-122.29842, 38.11765], [-122.29514, 38.11767], [-122.29517, 38.12202], [-122.29391, 38.12176], [-122.29147, 38.12115], [-122.29096, 38.12095], [-122.28991, 38.12067], [-122.28949, 38.1205], [-122.28948, 38.12051], [-122.28961, 38.12104], [-122.28905, 38.12096], [-122.28843, 38.12096], [-122.28752, 38.12099], [-122.28684, 38.12105], [-122.28634, 38.12112], [-122.28545, 38.12115], [-122.28516, 38.12112], [-122.28475, 38.12104], [-122.28445, 38.12092], [-122.28428, 38.12081], [-122.28424, 38.12066], [-122.28424, 38.12054], [-122.28442, 38.12047], [-122.28489, 38.12022], [-122.2849, 38.12015], [-122.28483, 38.12013], [-122.28473, 38.12014], [-122.28458, 38.1202], [-122.28436, 38.12025], [-122.28389, 38.12032], [-122.28372, 38.12027], [-122.28358, 38.12021], [-122.28348, 38.12004], [-122.28343, 38.11989], [-122.28331, 38.11964], [-122.2837, 38.11942], [-122.28408, 38.11929], [-122.28482, 38.11962], [-122.28624, 38.11904], [-122.28761, 38.11865], [-122.28884, 38.11843], [-122.28879, 38.11821], [-122.2892, 38.11772], [-122.29018, 38.11765], [-122.29513, 38.11767], [-122.29515, 38.11712], [-122.29842, 38.11716], [-122.30296, 38.1171], [-122.30355, 38.11722], [-122.30514, 38.11791], [-122.30785, 38.11928], [-122.31264, 38.12161], [-122.3168, 38.12337], [-122.31755, 38.1222], [-122.31754, 38.12218], [-122.31088, 38.11879], [-122.3078, 38.11718], [-122.30626, 38.11634], [-122.30514, 38.11566], [-122.30214, 38.11361], [-122.29654, 38.11052], [-122.30158, 38.10554], [-122.37487, 38.10534], [-122.37578, 38.10654], [-122.37608, 38.10703], [-122.37609, 38.10709], [-122.37881, 38.1114], [-122.38859, 38.12709], [-122.39096, 38.13086], [-122.39201, 38.13255], [-122.39286, 38.13382], [-122.39433, 38.13619], [-122.39494, 38.13713], [-122.39602, 38.13888], [-122.3965, 38.13957], [-122.39688, 38.14018], [-122.39728, 38.14077], [-122.39768, 38.14148], [-122.3981, 38.14212], [-122.39867, 38.14315], [-122.39947, 38.14445], [-122.39999, 38.14523], [-122.40043, 38.14576], [-122.40084, 38.14642], [-122.40133, 38.14727], [-122.40173, 38.14786], [-122.40201, 38.14838], [-122.40308, 38.14995], [-122.40338, 38.15027], [-122.40366, 38.15067], [-122.40393, 38.15092], [-122.40435, 38.15143], [-122.40492, 38.15219], [-122.40548, 38.15285], [-122.40584, 38.1534], [-122.40649, 38.15446], [-122.40701, 38.1558]]]} | Restricted Access 2 | 44494 | San Pablo Bay National Wildlife Refuge | 24964 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Solano 26 | 6803.264 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
| 15854 | 15854 | 15853 | {"type": "MultiPolygon", "coordinates": [[[[-122.31755, 38.12219], [-122.3168, 38.12337], [-122.31264, 38.12161], [-122.30785, 38.11928], [-122.30514, 38.11792], [-122.30354, 38.11722], [-122.30296, 38.1171], [-122.29842, 38.11716], [-122.29378, 38.1171], [-122.29378, 38.11315], [-122.29654, 38.11052], [-122.30214, 38.11361], [-122.30514, 38.11566], [-122.30626, 38.11634], [-122.3078, 38.11718], [-122.31088, 38.11879], [-122.31755, 38.12219]]], [[[-122.34433, 38.13458], [-122.34415, 38.15443], [-122.343, 38.15442], [-122.34265, 38.15444], [-122.34132, 38.15462], [-122.34103, 38.15471], [-122.34042, 38.15496], [-122.33985, 38.15526], [-122.33972, 38.15536], [-122.33934, 38.15573], [-122.33536, 38.1557], [-122.33583, 38.15539], [-122.33598, 38.15524], [-122.33613, 38.1549], [-122.3364, 38.15457], [-122.33713, 38.15379], [-122.33722, 38.15368], [-122.33741, 38.15329], [-122.33766, 38.15251], [-122.33765, 38.152], [-122.3376, 38.1514], [-122.3374, 38.15076], [-122.33735, 38.14974], [-122.33722, 38.1494], [-122.33595, 38.14868], [-122.33563, 38.14838], [-122.33474, 38.14766], [-122.33439, 38.14701], [-122.33421, 38.14628], [-122.33387, 38.1452], [-122.33335, 38.14458], [-122.33305, 38.14404], [-122.33248, 38.14341], [-122.33221, 38.14322], [-122.33127, 38.14273], [-122.33108, 38.14257], [-122.33098, 38.14243], [-122.33098, 38.14219], [-122.33083, 38.14193], [-122.32996, 38.14116], [-122.32968, 38.14087], [-122.32964, 38.14057], [-122.32982, 38.14001], [-122.32956, 38.13962], [-122.32927, 38.1394], [-122.32881, 38.13887], [-122.32858, 38.13844], [-122.32874, 38.13667], [-122.3287, 38.13601], [-122.32826, 38.13561], [-122.32805, 38.13513], [-122.32799, 38.13507], [-122.32762, 38.13486], [-122.32718, 38.13472], [-122.32694, 38.1347], [-122.32629, 38.13477], [-122.3258, 38.13509], [-122.32558, 38.13515], [-122.32441, 38.13495], [-122.32421, 38.13494], [-122.32363, 38.13508], [-122.32312, 38.13515], [-122.32293, 38.13525], [-122.32242, 38.13584], [-122.32213, 38.13601], [-122.32141, 38.13626], [-122.32117, 38.13641], [-122.32096, 38.13671], [-122.32087, 38.13704], [-122.32087, 38.13732], [-122.32074, 38.1376], [-122.32, 38.13836], [-122.31975, 38.13929], [-122.31953, 38.13936], [-122.31924, 38.13924], [-122.31882, 38.13895], [-122.31854, 38.13882], [-122.31826, 38.13882], [-122.31782, 38.13903], [-122.31768, 38.13874], [-122.31756, 38.13856], [-122.31729, 38.13829], [-122.31693, 38.13806], [-122.31672, 38.13786], [-122.31659, 38.13753], [-122.31658, 38.13706], [-122.3165, 38.13694], [-122.31635, 38.13682], [-122.31622, 38.13674], [-122.3155, 38.13649], [-122.31508, 38.13642], [-122.31445, 38.13638], [-122.31409, 38.13631], [-122.31376, 38.13622], [-122.31263, 38.1357], [-122.3123, 38.1356], [-122.31175, 38.13548], [-122.31102, 38.13541], [-122.31069, 38.13535], [-122.31042, 38.13521], [-122.31021, 38.13501], [-122.31008, 38.13488], [-122.30926, 38.13374], [-122.30907, 38.13355], [-122.30899, 38.13359], [-122.3089, 38.13348], [-122.30881, 38.13353], [-122.30861, 38.13321], [-122.30812, 38.13256], [-122.30796, 38.13217], [-122.30787, 38.13177], [-122.30767, 38.1312], [-122.30758, 38.13088], [-122.30787, 38.1305], [-122.30788, 38.1304], [-122.3078, 38.13032], [-122.30767, 38.13002], [-122.30723, 38.12944], [-122.30646, 38.12872], [-122.3062, 38.12851], [-122.30572, 38.1282], [-122.30526, 38.12801], [-122.30467, 38.12782], [-122.30353, 38.12756], [-122.30289, 38.12747], [-122.30178, 38.12743], [-122.30113, 38.12743], [-122.30033, 38.12738], [-122.30016, 38.12728], [-122.29999, 38.12714], [-122.29994, 38.12704], [-122.29978, 38.1269], [-122.30005, 38.12673], [-122.30031, 38.12628], [-122.30052, 38.12575], [-122.30077, 38.12485], [-122.30082, 38.12459], [-122.3008, 38.1244], [-122.30052, 38.12375], [-122.29916, 38.12339], [-122.29779, 38.12316], [-122.29555, 38.12291], [-122.29517, 38.12263], [-122.29514, 38.11767], [-122.29842, 38.11765], [-122.30003, 38.11771], [-122.30162, 38.11788], [-122.30374, 38.11824], [-122.30467, 38.11852], [-122.30559, 38.11883], [-122.30649, 38.11916], [-122.30738, 38.11952], [-122.30825, 38.1199], [-122.30911, 38.1203], [-122.30995, 38.12073], [-122.31076, 38.12118], [-122.31156, 38.12166], [-122.31734, 38.12411], [-122.32238, 38.12607], [-122.33483, 38.13109], [-122.34433, 38.13458]]], [[[-122.38055, 38.14606], [-122.38053, 38.14855], [-122.37939, 38.14793], [-122.37756, 38.14698], [-122.37659, 38.14629], [-122.37617, 38.14592], [-122.37551, 38.14554], [-122.37114, 38.14428], [-122.3696, 38.14394], [-122.36811, 38.14332], [-122.36576, 38.14221], [-122.36437, 38.14169], [-122.3644, 38.14004], [-122.36585, 38.14046], [-122.37307, 38.14323], [-122.37609, 38.14458], [-122.37742, 38.14504], [-122.37858, 38.14525], [-122.38003, 38.14598], [-122.38055, 38.14606]]]]} | Restricted Access 2 | 44495 | San Pablo Bay National Wildlife Refuge | 24964 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Solano 26 | 1733.092 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
| 16190 | 16190 | 16189 | {"type": "Polygon", "coordinates": [[[-122.07441, 38.2671], [-122.07432, 38.26712], [-122.07414, 38.26795], [-122.07374, 38.26798], [-122.07347, 38.2683], [-122.07341, 38.26849], [-122.07314, 38.26846], [-122.07313, 38.26825], [-122.07257, 38.26801], [-122.0722, 38.26781], [-122.07206, 38.26811], [-122.07198, 38.26848], [-122.07166, 38.26846], [-122.07073, 38.2676], [-122.07082, 38.26741], [-122.0699, 38.26709], [-122.06978, 38.26736], [-122.06967, 38.26749], [-122.06963, 38.26774], [-122.06984, 38.26789], [-122.06993, 38.26838], [-122.07034, 38.26877], [-122.06881, 38.26882], [-122.06879, 38.26881], [-122.06831, 38.26887], [-122.06813, 38.26805], [-122.06893, 38.26793], [-122.06894, 38.26789], [-122.06912, 38.26784], [-122.06927, 38.26732], [-122.06918, 38.26687], [-122.06911, 38.26677], [-122.06925, 38.26673], [-122.06995, 38.2666], [-122.07006, 38.26643], [-122.07042, 38.26639], [-122.07077, 38.26616], [-122.07043, 38.2659], [-122.07087, 38.2659], [-122.07109, 38.26574], [-122.07267, 38.26569], [-122.07292, 38.26616], [-122.07349, 38.26677], [-122.07396, 38.26677], [-122.07441, 38.2671]]]} | Restricted Access 2 | 29160 | Spyglass Open Space | 25758 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 24.304 | Spyglass OS | 0 | Local Recreation Area 3 | 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]);