units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where AGNCY_NAME = 8 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
DES_TP 4
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16927 | 16927 | 16926 | {"type": "MultiPolygon", "coordinates": [[[[-120.6486, 35.47827], [-120.64691, 35.47993], [-120.64474, 35.48211], [-120.64314, 35.47842], [-120.64254, 35.47751], [-120.64174, 35.47671], [-120.64078, 35.47603], [-120.63969, 35.47551], [-120.63961, 35.47559], [-120.63571, 35.47391], [-120.63519, 35.47363], [-120.63473, 35.47327], [-120.63438, 35.47285], [-120.63412, 35.47237], [-120.64037, 35.46871], [-120.6405, 35.46878], [-120.64087, 35.4689], [-120.6417, 35.46914], [-120.64319, 35.46938], [-120.64348, 35.4694], [-120.64491, 35.46934], [-120.64506, 35.46931], [-120.64513, 35.47088], [-120.64566, 35.47188], [-120.64588, 35.47365], [-120.6459, 35.47365], [-120.647, 35.47288], [-120.64704, 35.47299], [-120.64715, 35.47313], [-120.64723, 35.47319], [-120.64742, 35.47326], [-120.64749, 35.47332], [-120.64761, 35.47347], [-120.64684, 35.47375], [-120.64621, 35.47385], [-120.64521, 35.47416], [-120.64491, 35.47415], [-120.6449, 35.47417], [-120.64525, 35.47453], [-120.6486, 35.47827]]], [[[-120.64709, 35.47263], [-120.64603, 35.47336], [-120.64582, 35.47184], [-120.64531, 35.47085], [-120.64525, 35.46978], [-120.64704, 35.46978], [-120.64709, 35.47263]]], [[[-120.64864, 35.47105], [-120.64865, 35.47288], [-120.64863, 35.47292], [-120.64856, 35.47299], [-120.64843, 35.47307], [-120.64824, 35.47314], [-120.64786, 35.47317], [-120.64769, 35.4732], [-120.6475, 35.47317], [-120.64741, 35.47312], [-120.64725, 35.473], [-120.6472, 35.47292], [-120.64718, 35.47285], [-120.64718, 35.47278], [-120.6472, 35.47274], [-120.64728, 35.47267], [-120.64717, 35.47257], [-120.64713, 35.47259], [-120.64711, 35.47107], [-120.64864, 35.47105]]]]} | Restricted Access 2 | 48426 | Chalk Mountain Golf Course | 33050 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 227.705 | Chalk Mtn. GC | 0 | Local Recreation Area 3 | 4 | |
16433 | 16433 | 16432 | {"type": "Polygon", "coordinates": [[[-120.74154, 35.3331], [-120.73974, 35.33628], [-120.73643, 35.3387], [-120.73575, 35.33844], [-120.73517, 35.33868], [-120.73285, 35.3378], [-120.72967, 35.33978], [-120.72435, 35.34033], [-120.72421, 35.34083], [-120.72439, 35.34155], [-120.72495, 35.34214], [-120.72174, 35.3459], [-120.71513, 35.35322], [-120.71224, 35.35091], [-120.72459, 35.32556], [-120.72558, 35.3253], [-120.72633, 35.32599], [-120.72988, 35.32905], [-120.73035, 35.3294], [-120.73084, 35.32971], [-120.73136, 35.33], [-120.73191, 35.33026], [-120.73247, 35.33048], [-120.73305, 35.33067], [-120.73498, 35.33122], [-120.7373, 35.33191], [-120.73941, 35.33243], [-120.74154, 35.3331]]]} | Restricted Access 2 | 14529 | El Chorro Regional Park and Dairy Creek Golf Course | 33039 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 684.123 | El Chorro RP and Dairy Creek GC | 0 | Local Recreation Area 3 | 4 | |
14206 | 14206 | 14205 | {"type": "MultiPolygon", "coordinates": [[[[-120.64475, 35.29287], [-120.64465, 35.29305], [-120.64413, 35.29433], [-120.64404, 35.29441], [-120.64389, 35.29445], [-120.64286, 35.29441], [-120.64292, 35.29421], [-120.6425, 35.29418], [-120.64267, 35.29411], [-120.64372, 35.29308], [-120.64418, 35.29278], [-120.64434, 35.29269], [-120.64475, 35.29287]]], [[[-120.64377, 35.29458], [-120.6437, 35.29472], [-120.64281, 35.29519], [-120.64277, 35.29455], [-120.64377, 35.29458]]]]} | Open Access 1 | 44067 | Cuesta Canyon County Park | 17849 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 5.731 | Cuesta Canyon County Park | 0 | Local Park 2 | 4 | |
14193 | 14193 | 14192 | {"type": "Polygon", "coordinates": [[[-120.8994, 35.44501], [-120.89928, 35.44513], [-120.89917, 35.44528], [-120.8991, 35.44542], [-120.89902, 35.44564], [-120.89897, 35.44571], [-120.89886, 35.44584], [-120.89882, 35.44596], [-120.89867, 35.44589], [-120.89871, 35.44576], [-120.89885, 35.44561], [-120.89897, 35.4453], [-120.89912, 35.44507], [-120.89925, 35.44494], [-120.8994, 35.44501]]]} | Open Access 1 | 44028 | Paul Andrew Park | 33176 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | https://slocountyparks.com/day-use-parks/paul-andrew-park/ | San Luis Obispo 1 | 0.448 | Paul Andrew Park | 0 | Local Park 2 | 4 |
10370 | 10370 | 10369 | {"type": "Polygon", "coordinates": [[[-120.70316, 35.18542], [-120.70293, 35.18607], [-120.70292, 35.18601], [-120.70288, 35.18597], [-120.7028, 35.18595], [-120.70274, 35.18597], [-120.70204, 35.18641], [-120.70158, 35.18682], [-120.70176, 35.18626], [-120.70316, 35.18542]]]} | Open Access 1 | 18304 | Ontario Road Staging Area Park | 23147 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 1.185 | Ontario Road Staging Area Park | 0 | Local Park 2 | 4 | |
10296 | 10296 | 10295 | {"type": "MultiPolygon", "coordinates": [[[[-120.50201, 35.02849], [-120.49971, 35.03343], [-120.4986, 35.03308], [-120.49843, 35.03301], [-120.49819, 35.03289], [-120.49524, 35.03088], [-120.49522, 35.03085], [-120.49522, 35.0308], [-120.49548, 35.03047], [-120.49593, 35.02976], [-120.49622, 35.02925], [-120.49661, 35.02847], [-120.49909, 35.02926], [-120.49982, 35.02776], [-120.50201, 35.02849]]], [[[-120.50667, 35.03003], [-120.50484, 35.03377], [-120.50263, 35.03787], [-120.50037, 35.03396], [-120.50026, 35.03382], [-120.5001, 35.03366], [-120.49995, 35.03355], [-120.49978, 35.03346], [-120.50209, 35.02851], [-120.50667, 35.03003]]]]} | Open Access 1 | 18118 | Nipomo Community Park | 22767 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 134.886 | Nipomo Community Park | 0 | Local Park 2 | 4 | |
10228 | 10228 | 10227 | {"type": "Polygon", "coordinates": [[[-120.86112, 35.31032], [-120.86111, 35.31276], [-120.86105, 35.31586], [-120.86045, 35.31587], [-120.86045, 35.31573], [-120.86041, 35.31569], [-120.86078, 35.31419], [-120.86095, 35.31265], [-120.85951, 35.31264], [-120.85951, 35.31144], [-120.8592, 35.31143], [-120.85933, 35.31126], [-120.85933, 35.3112], [-120.8593, 35.31114], [-120.8592, 35.3111], [-120.85909, 35.31112], [-120.859, 35.31102], [-120.85674, 35.31101], [-120.85674, 35.31089], [-120.85678, 35.31076], [-120.85674, 35.31066], [-120.85667, 35.31059], [-120.85667, 35.3103], [-120.86112, 35.31032]]]} | Open Access 1 | 17895 | Monarch Grove Natural Area | 22365 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 17.519 | Monarch Grove Natural Area | 0 | Local Conservation Area 4 | 2 | |
10185 | 10185 | 10184 | {"type": "MultiPolygon", "coordinates": [[[[-120.51236, 35.03141], [-120.51151, 35.03142], [-120.50616, 35.0315], [-120.50672, 35.03036], [-120.50677, 35.03033], [-120.50812, 35.0308], [-120.50813, 35.03123], [-120.51014, 35.03122], [-120.5108, 35.03095], [-120.51138, 35.03074], [-120.51225, 35.03007], [-120.51225, 35.02817], [-120.5119, 35.02817], [-120.5119, 35.02787], [-120.51192, 35.02784], [-120.51196, 35.02782], [-120.51235, 35.02782], [-120.51236, 35.03141]]], [[[-120.50742, 35.03009], [-120.50724, 35.03034], [-120.50686, 35.03021], [-120.50683, 35.03017], [-120.50683, 35.03014], [-120.50708, 35.02961], [-120.50714, 35.02943], [-120.50717, 35.0294], [-120.50723, 35.0294], [-120.50741, 35.02947], [-120.50714, 35.02999], [-120.50742, 35.03009]]], [[[-120.50768, 35.02852], [-120.50733, 35.02929], [-120.50726, 35.02926], [-120.50723, 35.02921], [-120.50728, 35.02905], [-120.50756, 35.02853], [-120.50761, 35.0285], [-120.50768, 35.02852]]], [[[-120.51174, 35.02817], [-120.51117, 35.02818], [-120.51117, 35.02918], [-120.5108, 35.02919], [-120.51056, 35.02923], [-120.51033, 35.02932], [-120.51011, 35.02947], [-120.5095, 35.02885], [-120.50923, 35.02904], [-120.50905, 35.02889], [-120.50882, 35.02877], [-120.50771, 35.02838], [-120.50767, 35.02833], [-120.50791, 35.02787], [-120.50797, 35.02784], [-120.50911, 35.02784], [-120.51168, 35.02782], [-120.51172, 35.02784], [-120.51174, 35.02787], [-120.51174, 35.02817]]]]} | Open Access 1 | 17778 | Mesa Meadows Natural Area | 22177 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 21.08 | Mesa Meadows Natural Area | 0 | Local Conservation Area 4 | 2 | |
10056 | 10056 | 10055 | {"type": "MultiPolygon", "coordinates": [[[[-120.44688, 35.20932], [-120.44643, 35.20836], [-120.4464, 35.2023], [-120.44557, 35.201], [-120.44538, 35.19952], [-120.44614, 35.19898], [-120.44418, 35.19285], [-120.44415, 35.19105], [-120.44146, 35.18992], [-120.44208, 35.18763], [-120.44135, 35.18746], [-120.44152, 35.18696], [-120.44093, 35.18652], [-120.44119, 35.18652], [-120.44306, 35.18634], [-120.4432, 35.18635], [-120.44334, 35.18638], [-120.44345, 35.18643], [-120.44356, 35.1865], [-120.44347, 35.18655], [-120.44333, 35.18666], [-120.44311, 35.18661], [-120.443, 35.18661], [-120.44286, 35.18664], [-120.44277, 35.18669], [-120.44269, 35.18675], [-120.44262, 35.18684], [-120.44259, 35.18691], [-120.44211, 35.18881], [-120.44203, 35.18901], [-120.44201, 35.18917], [-120.44204, 35.18942], [-120.44215, 35.18967], [-120.4423, 35.18986], [-120.44254, 35.19004], [-120.44284, 35.19017], [-120.44316, 35.19022], [-120.44346, 35.19021], [-120.44375, 35.19014], [-120.44394, 35.19005], [-120.44456, 35.18959], [-120.4448, 35.18928], [-120.44494, 35.18903], [-120.44496, 35.18896], [-120.44501, 35.1889], [-120.44511, 35.18886], [-120.44521, 35.18886], [-120.44532, 35.18891], [-120.44537, 35.189], [-120.44537, 35.18908], [-120.44499, 35.18943], [-120.44439, 35.18992], [-120.44431, 35.19004], [-120.44426, 35.19017], [-120.44423, 35.19029], [-120.44423, 35.19046], [-120.44429, 35.19068], [-120.44447, 35.19096], [-120.44455, 35.1912], [-120.44458, 35.1914], [-120.44454, 35.1922], [-120.44458, 35.19261], [-120.44465, 35.1929], [-120.44474, 35.19318], [-120.44487, 35.19345], [-120.44508, 35.19383], [-120.44515, 35.19401], [-120.44518, 35.19418], [-120.44521, 35.19494], [-120.44523, 35.19507], [-120.44567, 35.19608], [-120.44575, 35.19631], [-120.44582, 35.19664], [-120.44588, 35.19717], [-120.44596, 35.19748], [-120.44604, 35.19766], [-120.44645, 35.19845], [-120.44649, 35.19859], [-120.44649, 35.19873], [-120.44646, 35.19885], [-120.44618, 35.19933], [-120.4461, 35.19952], [-120.44603, 35.19976], [-120.44599, 35.2], [-120.44598, 35.20024], [-120.44603, 35.2006], [-120.44616, 35.201], [-120.44636, 35.20146], [-120.44658, 35.20191], [-120.44683, 35.20235], [-120.44691, 35.20253], [-120.4477, 35.20548], [-120.44771, 35.20563], [-120.4477, 35.20582], [-120.44732, 35.20727], [-120.4473, 35.20742], [-120.44731, 35.20759], [-120.44737, 35.20781], [-120.44746, 35.208], [-120.44795, 35.20836], [-120.448, 35.20848], [-120.448, 35.20862], [-120.44794, 35.20876], [-120.44781, 35.20888], [-120.44688, 35.20932]]], [[[-120.51019, 35.20164], [-120.51023, 35.20515], [-120.51001, 35.21242], [-120.50573, 35.21259], [-120.50116, 35.21257], [-120.49703, 35.21258], [-120.49703, 35.21612], [-120.49272, 35.21613], [-120.49269, 35.21435], [-120.48836, 35.21434], [-120.48835, 35.21614], [-120.48169, 35.21615], [-120.48173, 35.21796], [-120.47957, 35.21802], [-120.47956, 35.21981], [-120.47957, 35.22572], [-120.47734, 35.22574], [-120.47734, 35.22738], [-120.47603, 35.22838], [-120.47598, 35.22839], [-120.47561, 35.22937], [-120.47479, 35.22938], [-120.47492, 35.22911], [-120.47412, 35.22893], [-120.47373, 35.22939], [-120.47099, 35.2294], [-120.47094, 35.21984], [-120.47259, 35.21982], [-120.47255, 35.21351], [-120.47309, 35.21349], [-120.47311, 35.21093], [-120.4709, 35.2109], [-120.47087, 35.20606], [-120.46827, 35.20608], [-120.46828, 35.20784], [-120.46124, 35.21403], [-120.45748, 35.21593], [-120.45611, 35.21597], [-120.45592, 35.2147], [-120.45589, 35.21455], [-120.45582, 35.21442], [-120.45547, 35.21386], [-120.45541, 35.21379], [-120.4553, 35.2137], [-120.45509, 35.21362], [-120.45261, 35.21323], [-120.45249, 35.2132], [-120.45228, 35.21311], [-120.45207, 35.21297], [-120.4518, 35.21261], [-120.45186, 35.21445], [-120.45412, 35.21485], [-120.45424, 35.21733], [-120.45392, 35.21748], [-120.45197, 35.21753], [-120.45185, 35.21445], [-120.44827, 35.21395], [-120.44808, 35.21414], [-120.448, 35.21425], [-120.44794, 35.21436], [-120.44786, 35.21462], [-120.44775, 35.21479], [-120.44766, 35.21488], [-120.4472, 35.21521], [-120.44698, 35.21545], [-120.44688, 35.21562], [-120.44655, 35.21629], [-120.44591, 35.2167], [-120.4458, 35.21675], [-120.44552, 35.2168], [-120.44528, 35.21688], [-120.44512, 35.21696], [-120.44493, 35.21711], [-120.44483, 35.21716], [-120.44462, 35.21722], [-120.44456, 35.21722], [-120.44449, 35.2172], [-120.44404, 35.21671], [-120.44393, 35.21661], [-120.44378, 35.21652], [-120.44308, 35.21623], [-120.44302, 35.21618], [-120.44298, 35.21614], [-120.44296, 35.21603], [-120.44316, 35.21503], [-120.44321, 35.21466], [-120.44323, 35.21423], [-120.44318, 35.21364], [-120.4432, 35.2134], [-120.44324, 35.21329], [-120.4433, 35.21318], [-120.44364, 35.21277], [-120.44378, 35.21255], [-120.44389, 35.21233], [-120.44402, 35.21195], [-120.44414, 35.21137], [-120.44433, 35.21099], [-120.44437, 35.2108], [-120.44437, 35.21064], [-120.44432, 35.2105], [-120.44423, 35.21042], [-120.44409, 35.21037], [-120.44397, 35.21037], [-120.44387, 35.2104], [-120.44351, 35.21067], [-120.44345, 35.21068], [-120.44339, 35.21066], [-120.44336, 35.21062], [-120.44336, 35.21057], [-120.44353, 35.21028], [-120.44554, 35.20984], [-120.44573, 35.20987], [-120.44586, 35.20987], [-120.44607, 35.20985], [-120.44624, 35.2098], [-120.44796, 35.20899], [-120.44807, 35.2089], [-120.44814, 35.2088], [-120.4482, 35.20866], [-120.44821, 35.20855], [-120.44819, 35.20841], [-120.44811, 35.20826], [-120.44762, 35.2079], [-120.44753, 35.20766], [-120.4475, 35.20747], [-120.44752, 35.2073], [-120.4479, 35.2058], [-120.44791, 35.20563], [-120.44789, 35.20541], [-120.44712, 35.20252], [-120.44702, 35.20228], [-120.44669, 35.2017], [-120.44648, 35.20126], [-120.44627, 35.20072], [-120.4462, 35.20042], [-120.44619, 35.20005], [-120.44624, 35.19975], [-120.44629, 35.19956], [-120.44637, 35.19939], [-120.44666, 35.19889], [-120.4467, 35.1987], [-120.44668, 35.19853], [-120.44664, 35.1984], [-120.44623, 35.1976], [-120.44614, 35.19739], [-120.44608, 35.19715], [-120.44601, 35.19657], [-120.44594, 35.19627], [-120.44584, 35.19598], [-120.44542, 35.19503], [-120.44541, 35.19492], [-120.44539, 35.19419], [-120.44535, 35.19398], [-120.44527, 35.19377], [-120.44508, 35.19343], [-120.44493, 35.19312], [-120.44484, 35.19286], [-120.44478, 35.19258], [-120.44474, 35.19214], [-120.44478, 35.19141], [-120.44476, 35.19122], [-120.44469, 35.19097], [-120.44463, 35.19085], [-120.44449, 35.19066], [-120.44443, 35.19046], [-120.44443, 35.19036], [-120.44445, 35.19023], [-120.4445, 35.19011], [-120.44456, 35.19001], [-120.44515, 35.18953], [-120.44554, 35.18917], [-120.44557, 35.18907], [-120.44557, 35.18897], [-120.44554, 35.18889], [-120.44548, 35.18881], [-120.44542, 35.18876], [-120.44531, 35.18871], [-120.44512, 35.18869], [-120.445, 35.18872], [-120.44493, 35.18875], [-120.4448, 35.18886], [-120.44474, 35.189], [-120.44465, 35.18916], [-120.44441, 35.18947], [-120.44381, 35.18992], [-120.44359, 35.19001], [-120.44334, 35.19006], [-120.44307, 35.19005], [-120.4428, 35.18997], [-120.44257, 35.18985], [-120.44239, 35.18968], [-120.44228, 35.18951], [-120.44223, 35.18934], [-120.44222, 35.18913], [-120.44224, 35.189], [-120.4423, 35.18886], [-120.44279, 35.18693], [-120.44286, 35.18684], [-120.44297, 35.18679], [-120.4431, 35.18677], [-120.44326, 35.18682], [-120.44339, 35.18682], [-120.44349, 35.18677], [-120.44362, 35.18666], [-120.4438, 35.18661], [-120.4439, 35.18661], [-120.44429, 35.18668], [-120.44457, 35.18668], [-120.44564, 35.18654], [-120.44586, 35.18653], [-120.44608, 35.18654], [-120.44626, 35.18656], [-120.44664, 35.18668], [-120.44681, 35.18671], [-120.44702, 35.18672], [-120.44725, 35.18671], [-120.44744, 35.18673], [-120.44755, 35.18676], [-120.4477, 35.18683], [-120.44862, 35.18709], [-120.44926, 35.18723], [-120.44963, 35.18727], [-120.44989, 35.18728], [-120.45161, 35.18719], [-120.45196, 35.18721], [-120.45237, 35.18728], [-120.45265, 35.18729], [-120.45448, 35.18691], [-120.45425, 35.18679], [-120.45269, 35.18711], [-120.45257, 35.18712], [-120.45236, 35.18712], [-120.452, 35.18705], [-120.45169, 35.18703], [-120.44988, 35.18711], [-120.44966, 35.18711], [-120.44931, 35.18707], [-120.44868, 35.18693], [-120.44779, 35.18668], [-120.44765, 35.18662], [-120.4475, 35.18657], [-120.44731, 35.18655], [-120.44695, 35.18656], [-120.44681, 35.18655], [-120.44638, 35.18642], [-120.44611, 35.18637], [-120.44571, 35.18637], [-120.44463, 35.18651], [-120.44442, 35.18652], [-120.44421, 35.1865], [-120.44393, 35.18644], [-120.44378, 35.18644], [-120.44367, 35.18636], [-120.44353, 35.18628], [-120.44337, 35.18622], [-120.44321, 35.18619], [-120.44297, 35.18618], [-120.44239, 35.18624], [-120.44159, 35.18491], [-120.44158, 35.18089], [-120.45052, 35.18503], [-120.45214, 35.18458], [-120.45323, 35.18477], [-120.45422, 35.18477], [-120.4552, 35.18419], [-120.4569, 35.18531], [-120.45729, 35.18531], [-120.45806, 35.18581], [-120.4581, 35.18526], [-120.45694, 35.1845], [-120.45638, 35.18378], [-120.45615, 35.18293], [-120.45598, 35.18265], [-120.45584, 35.18265], [-120.45583, 35.18181], [-120.45342, 35.17995], [-120.45311, 35.17996], [-120.45306, 35.17819], [-120.45415, 35.17819], [-120.4541, 35.17633], [-120.45499, 35.1782], [-120.45572, 35.17821], [-120.45573, 35.17904], [-120.45771, 35.18046], [-120.45797, 35.18147], [-120.45866, 35.18226], [-120.45895, 35.18266], [-120.45899, 35.18313], [-120.4598, 35.18314], [-120.46011, 35.18286], [-120.46082, 35.18284], [-120.46082, 35.18283], [-120.46035, 35.18226], [-120.46051, 35.18226], [-120.46099, 35.18283], [-120.46219, 35.18359], [-120.47583, 35.18403], [-120.47668, 35.18213], [-120.48394, 35.18537], [-120.49252, 35.18437], [-120.49258, 35.18698], [-120.49234, 35.18699], [-120.49218, 35.18702], [-120.49186, 35.18713], [-120.49178, 35.18717], [-120.4903, 35.18822], [-120.49017, 35.18829], [-120.48998, 35.18835], [-120.48966, 35.1884], [-120.48942, 35.18839], [-120.48918, 35.18833], [-120.48877, 35.18815], [-120.48836, 35.18793], [-120.48804, 35.18772], [-120.48767, 35.18745], [-120.48741, 35.18722], [-120.48699, 35.18681], [-120.48674, 35.18665], [-120.4865, 35.18653], [-120.4862, 35.18645], [-120.48595, 35.18641], [-120.4841, 35.18633], [-120.48374, 35.18626], [-120.4834, 35.18614], [-120.48314, 35.186], [-120.48175, 35.18477], [-120.48146, 35.18459], [-120.48114, 35.18444], [-120.48092, 35.18437], [-120.48064, 35.18431], [-120.4804, 35.18428], [-120.48012, 35.18427], [-120.47988, 35.18428], [-120.47964, 35.18432], [-120.4794, 35.18438], [-120.47913, 35.18447], [-120.47876, 35.18471], [-120.47855, 35.18488], [-120.47842, 35.18502], [-120.47822, 35.18529], [-120.47768, 35.1863], [-120.47749, 35.1865], [-120.47724, 35.18666], [-120.47706, 35.18673], [-120.47688, 35.18677], [-120.47655, 35.18679], [-120.47608, 35.18668], [-120.47551, 35.18652], [-120.4753, 35.18649], [-120.47509, 35.1865], [-120.47482, 35.18654], [-120.4746, 35.18661], [-120.47436, 35.18674], [-120.47415, 35.18691], [-120.47401, 35.18709], [-120.47195, 35.19103], [-120.47179, 35.1913], [-120.47169, 35.19151], [-120.47099, 35.1933], [-120.47091, 35.19343], [-120.4708, 35.19356], [-120.47058, 35.19374], [-120.47031, 35.19388], [-120.47004, 35.19394], [-120.46975, 35.19396], [-120.46949, 35.19392], [-120.46888, 35.19379], [-120.46821, 35.19363], [-120.46773, 35.19349], [-120.46752, 35.19341], [-120.46724, 35.19326], [-120.46704, 35.19311], [-120.46684, 35.19289], [-120.46669, 35.19268], [-120.46614, 35.19145], [-120.46587, 35.19095], [-120.46555, 35.19046], [-120.46525, 35.19009], [-120.46493, 35.18973], [-120.46465, 35.18945], [-120.46453, 35.18936], [-120.46435, 35.18925], [-120.4634, 35.18879], [-120.46313, 35.18862], [-120.46289, 35.18841], [-120.46271, 35.18822], [-120.46253, 35.18798], [-120.46146, 35.18626], [-120.46132, 35.18611], [-120.46115, 35.18597], [-120.46097, 35.18588], [-120.46079, 35.1858], [-120.46054, 35.18573], [-120.46027, 35.1857], [-120.46004, 35.1857], [-120.45982, 35.18574], [-120.45958, 35.18582], [-120.45937, 35.18593], [-120.45918, 35.18607], [-120.45903, 35.18624], [-120.45782, 35.18818], [-120.45776, 35.18832], [-120.45773, 35.18844], [-120.45773, 35.1886], [-120.45786, 35.18903], [-120.45789, 35.18929], [-120.45788, 35.18958], [-120.45782, 35.18983], [-120.45801, 35.18987], [-120.45806, 35.18972], [-120.45809, 35.18951], [-120.4581, 35.18933], [-120.45808, 35.18912], [-120.45804, 35.18891], [-120.45793, 35.18858], [-120.45793, 35.18846], [-120.45796, 35.18835], [-120.458, 35.18825], [-120.4592, 35.18633], [-120.45934, 35.18617], [-120.45949, 35.18606], [-120.45967, 35.18597], [-120.45989, 35.1859], [-120.46008, 35.18587], [-120.46028, 35.18586], [-120.46048, 35.18589], [-120.46072, 35.18595], [-120.4609, 35.18603], [-120.46106, 35.18613], [-120.46119, 35.18624], [-120.4613, 35.18636], [-120.46237, 35.18809], [-120.46254, 35.18831], [-120.46273, 35.18851], [-120.46299, 35.18873], [-120.46332, 35.18894], [-120.46425, 35.18939], [-120.46442, 35.18949], [-120.46485, 35.18991], [-120.46516, 35.19026], [-120.4655, 35.19072], [-120.4658, 35.1912], [-120.46595, 35.1915], [-120.46653, 35.19277], [-120.46669, 35.19301], [-120.46688, 35.1932], [-120.46712, 35.19339], [-120.46736, 35.19352], [-120.46763, 35.19363], [-120.46794, 35.19373], [-120.46855, 35.19389], [-120.46913, 35.19402], [-120.4697, 35.19412], [-120.46995, 35.19412], [-120.47014, 35.19409], [-120.47033, 35.19405], [-120.47064, 35.19391], [-120.4709, 35.19372], [-120.47105, 35.19356], [-120.47114, 35.19343], [-120.47123, 35.19324], [-120.47186, 35.19162], [-120.47198, 35.19136], [-120.47216, 35.19103], [-120.47419, 35.18716], [-120.47431, 35.18701], [-120.47448, 35.18687], [-120.47466, 35.18677], [-120.47488, 35.1867], [-120.4751, 35.18666], [-120.47532, 35.18666], [-120.4755, 35.18669], [-120.47602, 35.18683], [-120.47654, 35.18695], [-120.47673, 35.18695], [-120.47695, 35.18692], [-120.47719, 35.18686], [-120.47736, 35.18679], [-120.47752, 35.1867], [-120.47767, 35.18659], [-120.47786, 35.18637], [-120.47838, 35.1854], [-120.47851, 35.18521], [-120.47864, 35.18505], [-120.47885, 35.18486], [-120.47906, 35.18471], [-120.47923, 35.18462], [-120.47947, 35.18454], [-120.47971, 35.18448], [-120.47993, 35.18445], [-120.48038, 35.18444], [-120.48063, 35.18447], [-120.48085, 35.18452], [-120.48122, 35.18466], [-120.48144, 35.18477], [-120.48167, 35.18493], [-120.483, 35.18612], [-120.48328, 35.18627], [-120.48361, 35.18639], [-120.48392, 35.18647], [-120.48416, 35.1865], [-120.48593, 35.18657], [-120.4862, 35.18662], [-120.48648, 35.18671], [-120.48667, 35.18681], [-120.48686, 35.18694], [-120.48746, 35.18751], [-120.48799, 35.18791], [-120.48832, 35.18811], [-120.48876, 35.18833], [-120.4891, 35.18848], [-120.4893, 35.18854], [-120.48954, 35.18856], [-120.48976, 35.18856], [-120.48999, 35.18852], [-120.49024, 35.18844], [-120.49051, 35.1883], [-120.49192, 35.18729], [-120.49206, 35.18723], [-120.49223, 35.18718], [-120.4924, 35.18715], [-120.49258, 35.18715], [-120.49267, 35.19089], [-120.49262, 35.19429], [-120.48949, 35.19428], [-120.48948, 35.19429], [-120.48984, 35.19488], [-120.48931, 35.19528], [-120.49089, 35.19717], [-120.49028, 35.19892], [-120.49282, 35.20018], [-120.49359, 35.20084], [-120.49355, 35.20207], [-120.49261, 35.20212], [-120.49259, 35.20528], [-120.50593, 35.20518], [-120.50592, 35.20163], [-120.51019, 35.20164]]], [[[-120.44415, 35.2106], [-120.44417, 35.21077], [-120.44415, 35.21091], [-120.44396, 35.21129], [-120.44391, 35.21147], [-120.44385, 35.21181], [-120.44379, 35.21203], [-120.44369, 35.2123], [-120.44358, 35.21251], [-120.44342, 35.21275], [-120.44317, 35.21304], [-120.4431, 35.21314], [-120.44273, 35.21308], [-120.44277, 35.21136], [-120.44316, 35.21059], [-120.44317, 35.21068], [-120.44324, 35.21077], [-120.44334, 35.21083], [-120.44346, 35.21085], [-120.44356, 35.21083], [-120.44364, 35.2108], [-120.44399, 35.21054], [-120.44409, 35.21054], [-120.44415, 35.2106]]]]} | Open Access 1 | 17406 | Lopez Lake Recreation Area | 29275 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://slocountyparks.org/camp/lopez-lake/ | San Luis Obispo 1 | 4266.531 | Lopez Lake Rec. Area | 0 | Local Recreation Area 3 | 4 |
9841 | 9841 | 9840 | {"type": "Polygon", "coordinates": [[[-120.64277, 35.46619], [-120.64156, 35.46683], [-120.64042, 35.46748], [-120.64028, 35.46754], [-120.64011, 35.46754], [-120.64004, 35.46759], [-120.63996, 35.46768], [-120.63992, 35.4678], [-120.63996, 35.46802], [-120.63999, 35.46815], [-120.64005, 35.46834], [-120.64011, 35.46844], [-120.6402, 35.46857], [-120.64037, 35.46871], [-120.63791, 35.47016], [-120.63743, 35.46939], [-120.63727, 35.46901], [-120.63719, 35.4686], [-120.63727, 35.46813], [-120.63748, 35.46751], [-120.63739, 35.46725], [-120.63738, 35.46625], [-120.63752, 35.46583], [-120.63746, 35.46519], [-120.6386, 35.46461], [-120.64051, 35.46353], [-120.64277, 35.46619]]]} | Open Access 1 | 16821 | Heilmann Regional Park | 33134 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 48.892 | Heilmann RP | 0 | Local Park 2 | 4 | |
7318 | 7318 | 7317 | {"type": "Polygon", "coordinates": [[[-120.38069, 35.65556], [-120.38069, 35.65694], [-120.37742, 35.65689], [-120.37739, 35.65552], [-120.38069, 35.65556]]]} | Open Access 1 | 11956 | CW Clarke Park | 17868 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 11.182 | CW Clarke Park | 0 | Local Park 2 | 4 | |
6518 | 6518 | 6517 | {"type": "Polygon", "coordinates": [[[-120.71877, 35.18867], [-120.71877, 35.18888], [-120.71571, 35.18845], [-120.71498, 35.18848], [-120.71489, 35.18895], [-120.71472, 35.18942], [-120.71433, 35.18946], [-120.71376, 35.19011], [-120.71369, 35.19037], [-120.7137, 35.19053], [-120.71428, 35.19078], [-120.71465, 35.19089], [-120.7145, 35.19134], [-120.71428, 35.19154], [-120.71401, 35.19172], [-120.71389, 35.19198], [-120.71326, 35.19208], [-120.71321, 35.19217], [-120.71324, 35.19223], [-120.71357, 35.19254], [-120.71364, 35.19288], [-120.71353, 35.19302], [-120.71341, 35.19314], [-120.71319, 35.19333], [-120.71326, 35.1937], [-120.71377, 35.19428], [-120.71329, 35.19436], [-120.71323, 35.19434], [-120.71322, 35.19431], [-120.71282, 35.19279], [-120.71276, 35.1923], [-120.71276, 35.19187], [-120.71297, 35.19186], [-120.71337, 35.19109], [-120.71343, 35.19006], [-120.71445, 35.18914], [-120.71463, 35.18849], [-120.71386, 35.1885], [-120.7133, 35.18849], [-120.7111, 35.18795], [-120.71117, 35.18767], [-120.71344, 35.18825], [-120.71577, 35.18824], [-120.71877, 35.18867]]]} | Open Access 1 | 2755 | Canyon Creek Park | 16812 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 13.188 | Canyon Creek Park | 0 | Local Park 2 | 4 | |
5980 | 5980 | 5979 | {"type": "MultiPolygon", "coordinates": [[[[-120.4173, 35.31679], [-120.40935, 35.31666], [-120.40964, 35.31285], [-120.411, 35.3143], [-120.41124, 35.31444], [-120.41153, 35.31454], [-120.41174, 35.31458], [-120.41192, 35.31459], [-120.41216, 35.31458], [-120.41704, 35.31472], [-120.41731, 35.31477], [-120.41757, 35.31488], [-120.41771, 35.31496], [-120.41782, 35.31508], [-120.41788, 35.31522], [-120.41789, 35.31537], [-120.41781, 35.31555], [-120.41758, 35.31597], [-120.41746, 35.31622], [-120.41737, 35.31647], [-120.4173, 35.31679]]], [[[-120.50681, 35.32693], [-120.5068, 35.34504], [-120.48918, 35.34481], [-120.48917, 35.34537], [-120.48362, 35.34331], [-120.47178, 35.33897], [-120.47169, 35.3526], [-120.46721, 35.35253], [-120.46726, 35.346], [-120.45847, 35.34562], [-120.4583, 35.35033], [-120.44546, 35.34994], [-120.44546, 35.34567], [-120.43653, 35.34543], [-120.43643, 35.34175], [-120.4413, 35.34186], [-120.44114, 35.33459], [-120.43623, 35.33442], [-120.43612, 35.33085], [-120.42645, 35.33093], [-120.4269, 35.32274], [-120.42249, 35.32245], [-120.42254, 35.3195], [-120.41869, 35.31901], [-120.4181, 35.31857], [-120.41785, 35.31834], [-120.41799, 35.31565], [-120.41806, 35.31548], [-120.41809, 35.31529], [-120.41806, 35.31512], [-120.41799, 35.315], [-120.41787, 35.31486], [-120.4177, 35.31475], [-120.41743, 35.31463], [-120.41726, 35.31459], [-120.41706, 35.31456], [-120.41215, 35.31441], [-120.41188, 35.31442], [-120.41165, 35.31439], [-120.4115, 35.31435], [-120.41131, 35.31428], [-120.41114, 35.31419], [-120.40997, 35.31293], [-120.40965, 35.31261], [-120.40973, 35.31163], [-120.40999, 35.31162], [-120.41001, 35.31103], [-120.40978, 35.31101], [-120.40988, 35.30958], [-120.41438, 35.3094], [-120.42561, 35.30914], [-120.42572, 35.31301], [-120.43054, 35.31319], [-120.43058, 35.31709], [-120.43577, 35.31779], [-120.44373, 35.31771], [-120.44383, 35.31362], [-120.45392, 35.31394], [-120.45387, 35.30961], [-120.4577, 35.30976], [-120.45818, 35.3015], [-120.46285, 35.30148], [-120.46288, 35.30578], [-120.46685, 35.30579], [-120.46686, 35.31422], [-120.47191, 35.31425], [-120.47181, 35.332], [-120.48917, 35.33827], [-120.48919, 35.32291], [-120.47969, 35.31989], [-120.47985, 35.31681], [-120.47542, 35.31538], [-120.47634, 35.30343], [-120.4892, 35.30926], [-120.48919, 35.31601], [-120.49278, 35.31592], [-120.49289, 35.3195], [-120.49738, 35.31934], [-120.49736, 35.3228], [-120.49619, 35.32344], [-120.49566, 35.32369], [-120.49491, 35.324], [-120.49417, 35.32435], [-120.49384, 35.32447], [-120.4935, 35.32458], [-120.49191, 35.32494], [-120.49176, 35.325], [-120.49165, 35.32508], [-120.49153, 35.3252], [-120.49146, 35.32535], [-120.49128, 35.32635], [-120.49128, 35.32664], [-120.49133, 35.32692], [-120.4914, 35.3272], [-120.49151, 35.32747], [-120.49164, 35.32744], [-120.49153, 35.32717], [-120.49146, 35.3269], [-120.49142, 35.32658], [-120.49142, 35.32631], [-120.49159, 35.32537], [-120.49165, 35.32525], [-120.49174, 35.32516], [-120.49183, 35.3251], [-120.49195, 35.32505], [-120.49345, 35.3247], [-120.49406, 35.32451], [-120.49448, 35.32434], [-120.49503, 35.32407], [-120.49594, 35.32369], [-120.49644, 35.32344], [-120.49763, 35.32345], [-120.49796, 35.3238], [-120.49794, 35.32503], [-120.50014, 35.32514], [-120.50002, 35.33047], [-120.50232, 35.33054], [-120.50243, 35.32688], [-120.50681, 35.32693]]], [[[-120.41833, 35.31896], [-120.41782, 35.3189], [-120.41783, 35.31858], [-120.41796, 35.31869], [-120.41833, 35.31896]]]]} | Open Access 1 | 564 | Santa Margarita Lake Regional Park and Natural Area | 11439 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/activities/santa_margarita.htm | San Luis Obispo 1 | 5623.374 | Santa Margarita Lake RP and Natural Area | 0 | Local Conservation Area 4 | 2 |
5975 | 5975 | 5974 | {"type": "Polygon", "coordinates": [[[-120.60526, 35.39209], [-120.60496, 35.39235], [-120.60474, 35.3926], [-120.60455, 35.39286], [-120.60443, 35.39309], [-120.60389, 35.39241], [-120.60489, 35.39187], [-120.60496, 35.39195], [-120.60481, 35.39207], [-120.60494, 35.39217], [-120.60518, 35.39199], [-120.60526, 35.39209]]]} | Open Access 1 | 560 | Santa Margarita Community Park | 25094 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 1.636 | Santa Margarita Community Park | 0 | Local Park 2 | 4 | |
3906 | 3906 | 3905 | {"type": "Polygon", "coordinates": [[[-120.68988, 35.7518], [-120.68637, 35.75282], [-120.68543, 35.7525], [-120.68529, 35.75228], [-120.68512, 35.75228], [-120.68514, 35.75221], [-120.68616, 35.75215], [-120.6861, 35.75083], [-120.68543, 35.75084], [-120.68542, 35.74725], [-120.68987, 35.74723], [-120.68988, 35.7518]]]} | Open Access 1 | 1959 | Wolf Property Natural Area | 27671 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 54.586 | Wolf Property Natural Area | 0 | Local Conservation Area 4 | 2 | |
2695 | 2695 | 2694 | {"type": "MultiPolygon", "coordinates": [[[[-120.62428, 35.10545], [-120.62366, 35.10564], [-120.6231, 35.1049], [-120.62418, 35.10482], [-120.62428, 35.10545]]], [[[-120.62597, 35.10646], [-120.62472, 35.10684], [-120.62438, 35.10481], [-120.62511, 35.10475], [-120.62594, 35.10521], [-120.62551, 35.10565], [-120.6255, 35.10593], [-120.62574, 35.10626], [-120.62594, 35.10634], [-120.62597, 35.10646]]]]} | Open Access 1 | 18260 | Oceano Memorial Park | 23065 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 6.953 | Oceano Memorial Park | 0 | Local Park 2 | 4 | |
2694 | 2694 | 2693 | {"type": "Polygon", "coordinates": [[[-120.62642, 35.1044], [-120.62597, 35.10496], [-120.62525, 35.10457], [-120.6257, 35.10401], [-120.62642, 35.1044]]]} | Open Access 1 | 18257 | Oceano Memorial Campground | 23064 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 1.456 | Oceano Memorial Campground | 0 | Local Recreation Area 3 | 4 | |
2320 | 2320 | 2319 | {"type": "Polygon", "coordinates": [[[-120.48026, 35.03952], [-120.47988, 35.03981], [-120.47918, 35.0393], [-120.47957, 35.03902], [-120.48026, 35.03952]]]} | Open Access 1 | 17031 | Jim Miller Park | 20412 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 0.993 | Jim Miller Park | 0 | Local Park 2 | 4 | |
2313 | 2313 | 2312 | {"type": "Polygon", "coordinates": [[[-120.73725, 35.17986], [-120.73672, 35.18012], [-120.7367, 35.1801], [-120.73618, 35.18036], [-120.73607, 35.1802], [-120.73594, 35.18024], [-120.73585, 35.1803], [-120.73577, 35.18031], [-120.73612, 35.17952], [-120.73725, 35.17986]]]} | Open Access 1 | 16972 | Avila Park | 15732 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 1.514 | Avila Park | 0 | Local Park 2 | 4 | |
2257 | 2257 | 2256 | {"type": "Polygon", "coordinates": [[[-120.5224, 35.17674], [-120.52095, 35.17779], [-120.52068, 35.17801], [-120.52048, 35.1782], [-120.52022, 35.1785], [-120.51996, 35.17888], [-120.51981, 35.17917], [-120.51963, 35.1796], [-120.51912, 35.1796], [-120.51887, 35.17973], [-120.51864, 35.17995], [-120.51835, 35.18017], [-120.51803, 35.18033], [-120.51772, 35.18041], [-120.51707, 35.18055], [-120.51675, 35.18072], [-120.51607, 35.18122], [-120.51547, 35.18159], [-120.5141, 35.18133], [-120.51375, 35.1813], [-120.5134, 35.1813], [-120.51361, 35.1807], [-120.51436, 35.1804], [-120.5146, 35.17859], [-120.52025, 35.17532], [-120.52084, 35.17586], [-120.52091, 35.1757], [-120.52108, 35.17542], [-120.52162, 35.17528], [-120.52199, 35.17516], [-120.5224, 35.17674]]]} | Open Access 1 | 18104 | Biddle Park | 16068 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 62.881 | Biddle 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]);