units_with_maps_view (view)
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | {"type": "MultiPolygon", "coordinates": [[[[-119.81381, 35.34552], [-119.81381, 35.34738], [-119.80923, 35.34738], [-119.80923, 35.34541], [-119.80972, 35.34541], [-119.81013, 35.34538], [-119.8103, 35.34539], [-119.81054, 35.34546], [-119.81111, 35.34574], [-119.81129, 35.34579], [-119.81147, 35.3458], [-119.8117, 35.34579], [-119.81196, 35.34572], [-119.81212, 35.34571], [-119.81282, 35.34581], [-119.81305, 35.34581], [-119.81326, 35.34576], [-119.81381, 35.34552]]], [[[-119.81382, 35.33979], [-119.81381, 35.34534], [-119.81366, 35.34539], [-119.81319, 35.34561], [-119.81302, 35.34565], [-119.81283, 35.34565], [-119.81212, 35.34554], [-119.81192, 35.34556], [-119.81166, 35.34562], [-119.81145, 35.34564], [-119.81131, 35.34562], [-119.81115, 35.34558], [-119.81065, 35.34532], [-119.81038, 35.34524], [-119.81017, 35.34522], [-119.80971, 35.34524], [-119.80923, 35.34524], [-119.80924, 35.33978], [-119.81382, 35.33979]]], [[[-119.82704, 35.32867], [-119.82698, 35.33645], [-119.82241, 35.33644], [-119.82247, 35.32864], [-119.82704, 35.32867]]], [[[-119.83167, 35.32188], [-119.83164, 35.32529], [-119.82707, 35.32526], [-119.82709, 35.32187], [-119.83167, 35.32188]]], [[[-119.87616, 35.33992], [-119.87611, 35.34358], [-119.87127, 35.34359], [-119.87133, 35.33991], [-119.87616, 35.33992]]], [[[-119.89351, 35.42432], [-119.89344, 35.43176], [-119.88452, 35.43172], [-119.88455, 35.42766], [-119.88017, 35.42762], [-119.88025, 35.41685], [-119.88465, 35.41689], [-119.88462, 35.42062], [-119.8891, 35.42065], [-119.88907, 35.42429], [-119.89351, 35.42432]]], [[[-119.91564, 35.35494], [-119.9074, 35.35492], [-119.90743, 35.35107], [-119.91559, 35.35108], [-119.91564, 35.35494]]], [[[-119.98771, 35.15445], [-119.97836, 35.15438], [-119.97835, 35.15074], [-119.97386, 35.1507], [-119.97385, 35.1434], [-119.96057, 35.14329], [-119.96056, 35.13594], [-119.95186, 35.13583], [-119.95176, 35.13211], [-119.93416, 35.13206], [-119.93422, 35.13942], [-119.92964, 35.13942], [-119.92962, 35.13574], [-119.92509, 35.13574], [-119.92509, 35.13199], [-119.93416, 35.13205], [-119.93413, 35.12836], [-119.92962, 35.12836], [-119.9296, 35.11739], [-119.93408, 35.11739], [-119.9341, 35.12104], [-119.9385, 35.12105], [-119.93853, 35.1247], [-119.94732, 35.1247], [-119.94731, 35.12105], [-119.95171, 35.12106], [-119.95174, 35.1247], [-119.95614, 35.1247], [-119.95611, 35.11739], [-119.96052, 35.11745], [-119.96053, 35.11744], [-119.96053, 35.11378], [-119.95609, 35.11377], [-119.95606, 35.10648], [-119.96052, 35.10648], [-119.96051, 35.10286], [-119.95164, 35.10283], [-119.95165, 35.10647], [-119.94724, 35.10646], [-119.94723, 35.10281], [-119.94283, 35.1028], [-119.94281, 35.09915], [-119.92956, 35.09909], [-119.92955, 35.09233], [-119.92504, 35.09229], [-119.92503, 35.0834], [-119.93394, 35.08342], [-119.93394, 35.07986], [-119.94273, 35.07981], [-119.94273, 35.07632], [-119.95595, 35.0795], [-119.95597, 35.08374], [-119.95156, 35.08367], [-119.95158, 35.08844], [-119.95951, 35.0885], [-119.96877, 35.08868], [-119.96882, 35.09924], [-119.97358, 35.09927], [-119.97359, 35.10289], [-119.97833, 35.10291], [-119.97834, 35.10652], [-119.98729, 35.10654], [-119.98726, 35.11786], [-119.98736, 35.1326], [-119.98754, 35.14719], [-119.98771, 35.15445]]], [[[-119.94287, 35.11375], [-119.93407, 35.11373], [-119.93405, 35.11008], [-119.94286, 35.1101], [-119.94287, 35.11375]]], [[[-119.99529, 35.08891], [-119.98727, 35.08886], [-119.98727, 35.09272], [-119.9873, 35.10298], [-119.98281, 35.10293], [-119.9828, 35.0993], [-119.97833, 35.09928], [-119.97832, 35.0959], [-119.97356, 35.09588], [-119.97355, 35.09259], [-119.97832, 35.09262], [-119.97832, 35.08487], [-119.98517, 35.08651], [-119.99529, 35.08891]]], [[[-120.00615, 35.46146], [-120.00613, 35.4649], [-120.00234, 35.46491], [-120.00233, 35.46144], [-120.00615, 35.46146]]], [[[-120.14323, 35.33794], [-120.14319, 35.34533], [-120.13868, 35.3453], [-120.13868, 35.34891], [-120.12093, 35.34879], [-120.121, 35.34148], [-120.11217, 35.34142], [-120.1122, 35.3376], [-120.1077, 35.33753], [-120.10767, 35.33379], [-120.09076, 35.33373], [-120.09077, 35.33015], [-120.08602, 35.33013], [-120.08596, 35.32282], [-120.09446, 35.32289], [-120.09447, 35.31538], [-120.09028, 35.31536], [-120.09025, 35.31175], [-120.08586, 35.31174], [-120.08589, 35.31535], [-120.07242, 35.3153], [-120.07238, 35.31169], [-120.06361, 35.31166], [-120.06357, 35.30815], [-120.05881, 35.30809], [-120.04094, 35.30794], [-120.0409, 35.2934], [-120.04509, 35.29342], [-120.04497, 35.27868], [-120.04895, 35.27869], [-120.04893, 35.27555], [-120.04494, 35.27553], [-120.04492, 35.27185], [-120.06328, 35.27192], [-120.06331, 35.27559], [-120.0677, 35.27561], [-120.06773, 35.27878], [-120.07664, 35.27883], [-120.07662, 35.28297], [-120.08123, 35.28298], [-120.08129, 35.29026], [-120.08568, 35.29028], [-120.08574, 35.29754], [-120.09452, 35.29757], [-120.09447, 35.30842], [-120.12093, 35.30851], [-120.12088, 35.32311], [-120.12981, 35.32317], [-120.12982, 35.33427], [-120.13882, 35.33426], [-120.13876, 35.33793], [-120.14323, 35.33794]]], [[[-120.09452, 35.26843], [-120.08988, 35.26833], [-120.08985, 35.2644], [-120.09451, 35.26438], [-120.09452, 35.26843]]], [[[-120.09513, 35.20632], [-120.09506, 35.21353], [-120.09013, 35.21349], [-120.09017, 35.20629], [-120.09513, 35.20632]]], [[[-120.09882, 35.3374], [-120.09879, 35.34135], [-120.09452, 35.34131], [-120.09451, 35.33733], [-120.09882, 35.3374]]], [[[-120.13017, 35.25016], [-120.12576, 35.25007], [-120.12586, 35.24648], [-120.11705, 35.24647], [-120.11701, 35.24278], [-120.11247, 35.24283], [-120.11273, 35.23551], [-120.10854, 35.23548], [-120.10851, 35.22819], [-120.11268, 35.22821], [-120.11273, 35.2355], [-120.12983, 35.23589], [-120.13017, 35.25016]]], [[[-120.16973, 35.42162], [-120.16973, 35.42528], [-120.16524, 35.42523], [-120.16524, 35.42157], [-120.16973, 35.42162]]], [[[-120.20739, 35.78567], [-120.20293, 35.78573], [-120.20289, 35.78258], [-120.20317, 35.78242], [-120.20336, 35.78229], [-120.20375, 35.78194], [-120.20733, 35.7819], [-120.20739, 35.78567]]], [[[-120.21461, 35.04488], [-120.20574, 35.04499], [-120.20557, 35.03789], [-120.21444, 35.0377], [-120.21461, 35.04488]]], [[[-120.21192, 35.77485], [-120.20723, 35.77492], [-120.20717, 35.77115], [-120.21188, 35.77111], [-120.21192, 35.77485]]], [[[-120.21977, 35.74564], [-120.21976, 35.74941], [-120.21165, 35.74945], [-120.21163, 35.74567], [-120.21977, 35.74564]]], [[[-120.25297, 35.17868], [-120.24952, 35.17868], [-120.24942, 35.17536], [-120.24358, 35.17555], [-120.24346, 35.17186], [-120.24933, 35.17174], [-120.24943, 35.17535], [-120.25283, 35.17524], [-120.25297, 35.17868]]], [[[-120.27313, 35.16599], [-120.26432, 35.16632], [-120.26418, 35.16403], [-120.25249, 35.1643], [-120.25248, 35.16431], [-120.25263, 35.16797], [-120.24794, 35.16806], [-120.2477, 35.16082], [-120.25674, 35.16056], [-120.25664, 35.15675], [-120.26378, 35.15654], [-120.26411, 35.16259], [-120.27287, 35.16234], [-120.27313, 35.16599]]], [[[-120.26073, 35.58568], [-120.26064, 35.5895], [-120.24796, 35.58909], [-120.24802, 35.58546], [-120.26073, 35.58568]]], [[[-120.26292, 35.12755], [-120.25541, 35.12774], [-120.25537, 35.12411], [-120.26283, 35.12392], [-120.26292, 35.12755]]], [[[-120.26905, 35.08002], [-120.26015, 35.08056], [-120.26095, 35.06464], [-120.26395, 35.06467], [-120.26413, 35.06911], [-120.26865, 35.069], [-120.26905, 35.08002]]], [[[-120.28202, 35.17288], [-120.28193, 35.17511], [-120.26875, 35.17563], [-120.26884, 35.17342], [-120.26455, 35.17359], [-120.26444, 35.17001], [-120.26863, 35.16989], [-120.26877, 35.16996], [-120.26885, 35.17342], [-120.28202, 35.17288]]], [[[-120.2695, 35.60449], [-120.2649, 35.60438], [-120.26486, 35.60075], [-120.26944, 35.60079], [-120.2695, 35.60449]]], [[[-120.27609, 35.13252], [-120.27602, 35.13255], [-120.27587, 35.13266], [-120.27551, 35.1328], [-120.27533, 35.13295], [-120.27519, 35.13303], [-120.27506, 35.13313], [-120.27173, 35.13321], [-120.27167, 35.1295], [-120.27607, 35.12945], [-120.27609, 35.13252]]], [[[-120.27611, 35.12169], [-120.27609, 35.1258], [-120.27168, 35.12585], [-120.27171, 35.12169], [-120.27611, 35.12169]]], [[[-120.2761, 35.1331], [-120.2761, 35.1331], [-120.27532, 35.13312], [-120.27544, 35.13306], [-120.27564, 35.1329], [-120.27593, 35.13279], [-120.27609, 35.13268], [-120.2761, 35.1331]]], [[[-120.29406, 35.14374], [-120.28079, 35.14403], [-120.28042, 35.1343], [-120.29374, 35.13399], [-120.29406, 35.14374]]], [[[-120.28937, 35.12912], [-120.28497, 35.12922], [-120.28492, 35.13286], [-120.28049, 35.13298], [-120.28049, 35.1315], [-120.28076, 35.1314], [-120.28094, 35.13129], [-120.28105, 35.13118], [-120.28125, 35.13113], [-120.28172, 35.13089], [-120.28291, 35.13049], [-120.28356, 35.13017], [-120.28371, 35.13005], [-120.28376, 35.12996], [-120.28381, 35.1298], [-120.28386, 35.12971], [-120.2841, 35.12942], [-120.28483, 35.12892], [-120.28498, 35.12879], [-120.28525, 35.12863], [-120.28535, 35.12859], [-120.28545, 35.12858], [-120.2858, 35.12858], [-120.28685, 35.1285], [-120.28704, 35.12844], [-120.28734, 35.12825], [-120.28745, 35.12824], [-120.28752, 35.12825], [-120.28789, 35.12844], [-120.28817, 35.12852], [-120.28828, 35.12859], [-120.28844, 35.12872], [-120.28854, 35.12878], [-120.28877, 35.12888], [-120.28937, 35.12908], [-120.28937, 35.12912]]], [[[-120.28937, 35.12892], [-120.28877, 35.12873], [-120.28855, 35.12862], [-120.28838, 35.12848], [-120.28826, 35.1284], [-120.28797, 35.12832], [-120.28761, 35.12814], [-120.28749, 35.1281], [-120.28737, 35.1281], [-120.28727, 35.12813], [-120.28694, 35.12832], [-120.28678, 35.12837], [-120.28654, 35.12838], [-120.28618, 35.12842], [-120.28573, 35.12845], [-120.28546, 35.12844], [-120.28529, 35.12847], [-120.28515, 35.12852], [-120.28489, 35.12867], [-120.28472, 35.12882], [-120.28398, 35.12933], [-120.28371, 35.12964], [-120.28366, 35.12974], [-120.2836, 35.12993], [-120.28354, 35.13001], [-120.28347, 35.13006], [-120.28282, 35.13037], [-120.28165, 35.13077], [-120.28119, 35.131], [-120.28097, 35.13106], [-120.2809, 35.1311], [-120.28081, 35.13119], [-120.28063, 35.1313], [-120.28049, 35.13135], [-120.28051, 35.12568], [-120.28932, 35.12551], [-120.28937, 35.12892]]], [[[-120.29517, 35.17858], [-120.28639, 35.1787], [-120.28633, 35.17499], [-120.29511, 35.17486], [-120.29517, 35.17858]]], [[[-120.30198, 35.30604], [-120.28902, 35.30634], [-120.28849, 35.29615], [-120.29283, 35.2961], [-120.29292, 35.30322], [-120.29921, 35.3031], [-120.30194, 35.30308], [-120.30198, 35.30604]]], [[[-120.2948, 35.40659], [-120.29035, 35.40664], [-120.29032, 35.4036], [-120.29477, 35.40358], [-120.2948, 35.40659]]], [[[-120.32467, 35.14197], [-120.31585, 35.14221], [-120.31584, 35.14222], [-120.31589, 35.14329], [-120.31181, 35.14337], [-120.31196, 35.14706], [-120.30307, 35.1472], [-120.30278, 35.13988], [-120.31168, 35.13968], [-120.3115, 35.13599], [-120.31152, 35.13237], [-120.31537, 35.13229], [-120.31532, 35.1309], [-120.31974, 35.13087], [-120.31984, 35.13444], [-120.31999, 35.13826], [-120.3245, 35.13815], [-120.32467, 35.14197]]], [[[-120.30841, 35.40357], [-120.30841, 35.40642], [-120.30381, 35.40648], [-120.30375, 35.40355], [-120.30841, 35.40357]]], [[[-120.3169, 35.16511], [-120.31399, 35.16516], [-120.31384, 35.16512], [-120.31364, 35.16512], [-120.31355, 35.1651], [-120.31297, 35.16477], [-120.31276, 35.16471], [-120.31255, 35.16469], [-120.31239, 35.16151], [-120.31673, 35.16148], [-120.3169, 35.16511]]], [[[-120.31336, 35.16517], [-120.31257, 35.16518], [-120.31255, 35.16483], [-120.31274, 35.16484], [-120.31289, 35.16489], [-120.31336, 35.16517]]], [[[-120.3185, 35.31594], [-120.31832, 35.31606], [-120.31769, 35.31642], [-120.31748, 35.31657], [-120.31729, 35.31676], [-120.31676, 35.31747], [-120.3139, 35.3175], [-120.31381, 35.31411], [-120.31837, 35.31401], [-120.3185, 35.31594]]], [[[-120.31856, 35.31747], [-120.31856, 35.31747], [-120.317, 35.31746], [-120.31738, 35.31695], [-120.31746, 35.31685], [-120.3176, 35.31672], [-120.31784, 35.31653], [-120.3185, 35.31615], [-120.31856, 35.31747]]], [[[-120.33421, 35.22859], [-120.33419, 35.23235], [-120.33059, 35.23238], [-120.33049, 35.22854], [-120.33421, 35.22859]]], [[[-120.33481, 35.22091], [-120.33471, 35.22493], [-120.33075, 35.22496], [-120.3307, 35.22465], [-120.33077, 35.22094], [-120.33481, 35.22091]]], [[[-120.3611, 35.05543], [-120.35384, 35.05543], [-120.35325, 35.055], [-120.35221, 35.05452], [-120.35219, 35.05188], [-120.34775, 35.05192], [-120.34777, 35.05248], [-120.3389, 35.0484], [-120.3389, 35.03742], [-120.34324, 35.0374], [-120.34327, 35.03381], [-120.36101, 35.03381], [-120.3611, 35.05543]]], [[[-120.34864, 35.10623], [-120.34661, 35.10629], [-120.34611, 35.09707], [-120.34864, 35.10623], [-120.34864, 35.10623]]], [[[-120.37204, 35.35892], [-120.37198, 35.36216], [-120.36206, 35.36193], [-120.3622, 35.35525], [-120.36732, 35.3552], [-120.36733, 35.35888], [-120.37204, 35.35892]]], [[[-120.39025, 35.36968], [-120.39024, 35.37685], [-120.38092, 35.37672], [-120.3809, 35.36958], [-120.39025, 35.36968]]], [[[-120.41918, 35.22163], [-120.4186, 35.23357], [-120.41859, 35.24019], [-120.41861, 35.24785], [-120.41858, 35.24932], [-120.40657, 35.24964], [-120.40183, 35.24958], [-120.40176, 35.2459], [-120.38814, 35.24583], [-120.38806, 35.23891], [-120.39666, 35.23866], [-120.39661, 35.2346], [-120.38787, 35.23473], [-120.38779, 35.23196], [-120.38286, 35.232], [-120.38277, 35.22105], [-120.39426, 35.22121], [-120.39432, 35.22139], [-120.39384, 35.22405], [-120.39387, 35.22538], [-120.40047, 35.2254], [-120.41528, 35.22612], [-120.41529, 35.22611], [-120.41541, 35.2215], [-120.41668, 35.22158], [-120.41918, 35.22163]], [[-120.40604, 35.24328], [-120.40567, 35.23588], [-120.40156, 35.23451], [-120.40176, 35.24589], [-120.40631, 35.24659], [-120.41089, 35.24736], [-120.41053, 35.24418], [-120.40604, 35.24328]]], [[[-120.41792, 35.2872], [-120.41774, 35.29098], [-120.41174, 35.29138], [-120.4104, 35.28759], [-120.41214, 35.2874], [-120.41792, 35.2872]]], [[[-120.45846, 35.16937], [-120.45284, 35.16941], [-120.45272, 35.16453], [-120.45618, 35.16746], [-120.45846, 35.16937]]], [[[-120.47648, 35.29322], [-120.47645, 35.29458], [-120.47204, 35.29267], [-120.47208, 35.28706], [-120.47225, 35.28725], [-120.47237, 35.28745], [-120.47243, 35.28761], [-120.47248, 35.28795], [-120.47256, 35.28823], [-120.4735, 35.29028], [-120.47364, 35.29052], [-120.47382, 35.29071], [-120.47406, 35.2909], [-120.47429, 35.29102], [-120.4747, 35.29118], [-120.4749, 35.29132], [-120.47503, 35.29147], [-120.47548, 35.29232], [-120.47568, 35.2926], [-120.47583, 35.29277], [-120.47604, 35.29295], [-120.47625, 35.29309], [-120.47648, 35.29322]]], [[[-120.4853, 35.29455], [-120.48163, 35.29591], [-120.48181, 35.29633], [-120.48137, 35.29622], [-120.48101, 35.29609], [-120.48073, 35.29598], [-120.48039, 35.29581], [-120.48032, 35.29577], [-120.47917, 35.29488], [-120.47899, 35.29467], [-120.47872, 35.29429], [-120.4786, 35.29418], [-120.47846, 35.29409], [-120.47756, 35.29251], [-120.47678, 35.29192], [-120.47672, 35.29121], [-120.47652, 35.29121], [-120.47653, 35.29068], [-120.47597, 35.28949], [-120.47611, 35.28944], [-120.47868, 35.29056], [-120.47998, 35.29267], [-120.48187, 35.29195], [-120.48449, 35.29308], [-120.4853, 35.29455]]], [[[-120.4892, 35.30519], [-120.4892, 35.30926], [-120.47634, 35.30343], [-120.47663, 35.29979], [-120.4892, 35.30519]]], [[[-120.48191, 35.29654], [-120.48015, 35.2971], [-120.47859, 35.29433], [-120.47888, 35.29474], [-120.47911, 35.295], [-120.48024, 35.29585], [-120.48059, 35.29604], [-120.48102, 35.29622], [-120.48147, 35.29636], [-120.48187, 35.29645], [-120.48191, 35.29654]]], [[[-120.51929, 35.36689], [-120.5065, 35.36702], [-120.50647, 35.37784], [-120.50166, 35.37784], [-120.50168, 35.38163], [-120.51064, 35.38156], [-120.51076, 35.39271], [-120.50237, 35.39278], [-120.5023, 35.38584], [-120.49377, 35.3859], [-120.49373, 35.38173], [-120.49716, 35.38168], [-120.49712, 35.37421], [-120.49283, 35.3742], [-120.49278, 35.36722], [-120.47959, 35.36715], [-120.47957, 35.36319], [-120.48897, 35.36319], [-120.48903, 35.35955], [-120.49273, 35.35955], [-120.49271, 35.35613], [-120.50152, 35.35613], [-120.50157, 35.36319], [-120.50655, 35.36319], [-120.50662, 35.35955], [-120.51028, 35.35955], [-120.51031, 35.36319], [-120.51927, 35.36319], [-120.51929, 35.36689]]], [[[-120.55423, 35.41659], [-120.5499, 35.41669], [-120.54998, 35.42051], [-120.54138, 35.42067], [-120.54138, 35.42484], [-120.53682, 35.42481], [-120.53688, 35.42799], [-120.5325, 35.4281], [-120.53257, 35.43156], [-120.52804, 35.43166], [-120.52407, 35.43194], [-120.52401, 35.42472], [-120.524, 35.42111], [-120.51539, 35.42116], [-120.51542, 35.42486], [-120.49339, 35.42499], [-120.49337, 35.42133], [-120.49775, 35.42127], [-120.49763, 35.41758], [-120.50219, 35.41758], [-120.51098, 35.4175], [-120.51102, 35.41387], [-120.50654, 35.41392], [-120.50647, 35.41031], [-120.50256, 35.41033], [-120.50249, 35.40331], [-120.51465, 35.40321], [-120.51463, 35.39971], [-120.52406, 35.39963], [-120.52404, 35.40313], [-120.51851, 35.40318], [-120.51858, 35.41024], [-120.51981, 35.41024], [-120.51986, 35.41384], [-120.51531, 35.41389], [-120.51539, 35.41749], [-120.52399, 35.41747], [-120.52399, 35.4141], [-120.52788, 35.414], [-120.52795, 35.4172], [-120.53664, 35.417], [-120.53651, 35.41042], [-120.54134, 35.41049], [-120.54136, 35.41369], [-120.55416, 35.41339], [-120.55423, 35.41659]]], [[[-120.54151, 35.36352], [-120.54156, 35.36673], [-120.54118, 35.37447], [-120.52394, 35.37483], [-120.52389, 35.36684], [-120.52893, 35.36681], [-120.52892, 35.36378], [-120.54151, 35.36352]]], [[[-120.55883, 35.39928], [-120.5587, 35.40598], [-120.54994, 35.40605], [-120.55, 35.40262], [-120.54564, 35.40266], [-120.54567, 35.39923], [-120.54144, 35.39926], [-120.54148, 35.39596], [-120.5283, 35.39618], [-120.52828, 35.39225], [-120.53257, 35.39189], [-120.5327, 35.385], [-120.54097, 35.38489], [-120.54082, 35.38148], [-120.54599, 35.38149], [-120.54609, 35.38461], [-120.5503, 35.38458], [-120.55051, 35.39157], [-120.54129, 35.39163], [-120.54148, 35.39596], [-120.55432, 35.39584], [-120.55425, 35.39933], [-120.55883, 35.39928]]], [[[-120.58463, 35.43239], [-120.58066, 35.4324], [-120.58066, 35.42913], [-120.58463, 35.42912], [-120.58463, 35.43239]]], [[[-120.60895, 35.46254], [-120.60469, 35.46257], [-120.60026, 35.46257], [-120.60023, 35.45921], [-120.60466, 35.45921], [-120.60466, 35.45877], [-120.60891, 35.45875], [-120.60895, 35.46254]]], [[[-120.69479, 35.36458], [-120.69477, 35.36846], [-120.69287, 35.36846], [-120.6929, 35.36459], [-120.69479, 35.36458]]], [[[-120.73011, 35.44874], [-120.73002, 35.45187], [-120.72294, 35.44862], [-120.73011, 35.44874], [-120.73011, 35.44874]]], [[[-120.83473, 35.22841], [-120.83466, 35.23278], [-120.83036, 35.2328], [-120.83037, 35.23616], [-120.81234, 35.23596], [-120.8122, 35.23916], [-120.80776, 35.23908], [-120.80792, 35.23591], [-120.81096, 35.23593], [-120.81068, 35.2217], [-120.78884, 35.22147], [-120.78887, 35.21785], [-120.79412, 35.2179], [-120.79407, 35.21418], [-120.79809, 35.21419], [-120.79816, 35.2102], [-120.7993, 35.2102], [-120.79927, 35.21367], [-120.80494, 35.21366], [-120.80499, 35.2172], [-120.81624, 35.21724], [-120.81713, 35.21778], [-120.81695, 35.22412], [-120.81264, 35.22404], [-120.81277, 35.22775], [-120.82123, 35.22774], [-120.82146, 35.2204], [-120.83473, 35.22841]]], [[[-120.8119, 35.2464], [-120.81174, 35.25011], [-120.8072, 35.25021], [-120.80277, 35.25009], [-120.80294, 35.24615], [-120.8119, 35.2464]]], [[[-120.83687, 35.46421], [-120.83656, 35.47521], [-120.82343, 35.47495], [-120.82353, 35.47128], [-120.81457, 35.4711], [-120.81467, 35.46753], [-120.81027, 35.46744], [-120.81048, 35.45994], [-120.80596, 35.45983], [-120.80597, 35.45621], [-120.8194, 35.45646], [-120.81935, 35.46013], [-120.8238, 35.4602], [-120.82375, 35.46399], [-120.83687, 35.46421]]], [[[-120.86985, 35.55893], [-120.86526, 35.5587], [-120.86529, 35.555], [-120.86972, 35.55518], [-120.86985, 35.55893]]], [[[-120.91545, 35.61254], [-120.91081, 35.61222], [-120.91066, 35.61864], [-120.91045, 35.62567], [-120.90859, 35.62563], [-120.90908, 35.62502], [-120.90929, 35.62511], [-120.91026, 35.62398], [-120.90711, 35.62231], [-120.90846, 35.6216], [-120.90786, 35.62064], [-120.9057, 35.62155], [-120.90119, 35.61905], [-120.89915, 35.62153], [-120.89955, 35.62176], [-120.89871, 35.62175], [-120.8988, 35.62155], [-120.89879, 35.62154], [-120.89634, 35.62077], [-120.89639, 35.62002], [-120.89456, 35.61901], [-120.89579, 35.61758], [-120.89641, 35.61795], [-120.89642, 35.61795], [-120.89647, 35.61415], [-120.90587, 35.61495], [-120.90596, 35.61108], [-120.89177, 35.60988], [-120.8918, 35.60752], [-120.88194, 35.60727], [-120.882, 35.60239], [-120.87794, 35.60235], [-120.87792, 35.60179], [-120.87815, 35.5934], [-120.88656, 35.59378], [-120.8864, 35.59678], [-120.89197, 35.59726], [-120.89193, 35.5998], [-120.89635, 35.60018], [-120.89628, 35.59638], [-120.89199, 35.59606], [-120.89208, 35.59016], [-120.89234, 35.57924], [-120.90064, 35.57949], [-120.90106, 35.58633], [-120.90537, 35.58645], [-120.90564, 35.59004], [-120.91008, 35.59015], [-120.91011, 35.59298], [-120.91056, 35.59302], [-120.91125, 35.59382], [-120.9108, 35.60104], [-120.91505, 35.60139], [-120.91545, 35.61254]]], [[[-120.89201, 35.54537], [-120.89197, 35.54896], [-120.88791, 35.54875], [-120.88778, 35.54512], [-120.89201, 35.54537]]], [[[-120.90318, 35.62552], [-120.90106, 35.62548], [-120.90108, 35.62432], [-120.90108, 35.62432], [-120.90318, 35.62552]]], [[[-120.91218, 35.58573], [-120.9118, 35.58656], [-120.90972, 35.5865], [-120.9091, 35.57949], [-120.90982, 35.57951], [-120.91006, 35.57997], [-120.91018, 35.58007], [-120.91034, 35.58015], [-120.9101, 35.58093], [-120.91011, 35.58097], [-120.91016, 35.58109], [-120.91024, 35.58122], [-120.9109, 35.58201], [-120.91055, 35.58194], [-120.9097, 35.5842], [-120.91086, 35.5845], [-120.91129, 35.58347], [-120.91149, 35.58351], [-120.91151, 35.5836], [-120.91164, 35.58388], [-120.9117, 35.58405], [-120.91167, 35.5841], [-120.91141, 35.58429], [-120.91139, 35.58435], [-120.91139, 35.58441], [-120.91176, 35.58532], [-120.91182, 35.58539], [-120.91217, 35.5857], [-120.91218, 35.58573]]], [[[-120.91358, 35.58254], [-120.91115, 35.58206], [-120.91041, 35.58118], [-120.9103, 35.58101], [-120.91027, 35.58093], [-120.9105, 35.58019], [-120.9105, 35.58013], [-120.91045, 35.58005], [-120.91028, 35.57996], [-120.9102, 35.57988], [-120.91, 35.57951], [-120.9134, 35.57959], [-120.91358, 35.58254]]], [[[-120.91841, 35.58674], [-120.91198, 35.58656], [-120.91233, 35.58579], [-120.91235, 35.58571], [-120.9123, 35.58562], [-120.91192, 35.58526], [-120.91155, 35.58438], [-120.9118, 35.58419], [-120.91185, 35.58413], [-120.91187, 35.58407], [-120.91186, 35.58397], [-120.91167, 35.58355], [-120.91638, 35.58459], [-120.91673, 35.58377], [-120.91665, 35.58311], [-120.91816, 35.58319], [-120.91841, 35.58674]]], [[[-120.9176, 35.547], [-120.91322, 35.54668], [-120.9132, 35.54311], [-120.91757, 35.54344], [-120.9176, 35.547]]], [[[-121.05137, 35.67433], [-121.05136, 35.67795], [-121.04601, 35.67773], [-121.04589, 35.67401], [-121.05137, 35.67433]]], [[[-121.07811, 35.66714], [-121.07806, 35.67076], [-121.07362, 35.67076], [-121.07367, 35.66714], [-121.07811, 35.66714]]]]} | 1 | 21483 | BLM | 16162 | 102 | 1 | 1 | 1 | http://www.blm.gov/wo/st/en.html | 1 | 102 | 1 | 1 | 1 | 1 | 29770.057 | BLM | 1899 | 1 | 3 | |
1 | {"type": "Polygon", "coordinates": [[[-120.84977, 37.77283], [-120.84915, 37.77309], [-120.84786, 37.77119], [-120.84847, 37.77095], [-120.84977, 37.77283]]]} | 1 | 14 | Oaklawn Memorial Park | 23029 | 1227 | 2 | 2 | 2 | http://www.oakdalegov.com/#!recreation/c222d | 2 | 1227 | 2 | 2 | 2 | 2 | 3.595 | Oaklawn Memorial Park | 0 | 2 | 4 | |
2 | {"type": "Polygon", "coordinates": [[[-120.81796, 37.78801], [-120.81602, 37.78793], [-120.81565, 37.78787], [-120.81358, 37.7878], [-120.81268, 37.78774], [-120.8117, 37.78776], [-120.8111, 37.78789], [-120.81064, 37.78764], [-120.80991, 37.78733], [-120.80928, 37.78757], [-120.80895, 37.78704], [-120.80743, 37.78568], [-120.80702, 37.78537], [-120.80701, 37.78515], [-120.80703, 37.78338], [-120.80993, 37.78254], [-120.81293, 37.78022], [-120.81292, 37.77802], [-120.81434, 37.77723], [-120.81693, 37.77715], [-120.81697, 37.78113], [-120.81726, 37.78253], [-120.81756, 37.78477], [-120.81686, 37.78479], [-120.81635, 37.78482], [-120.8157, 37.78465], [-120.81513, 37.78463], [-120.81405, 37.78454], [-120.81371, 37.7843], [-120.81343, 37.78428], [-120.81288, 37.78427], [-120.81092, 37.78458], [-120.81058, 37.78429], [-120.81017, 37.78433], [-120.80902, 37.785], [-120.80861, 37.78529], [-120.80875, 37.78561], [-120.80897, 37.78583], [-120.80941, 37.78606], [-120.80994, 37.78614], [-120.81072, 37.78613], [-120.81093, 37.78596], [-120.8114, 37.78609], [-120.81224, 37.78639], [-120.81288, 37.78655], [-120.8129, 37.78674], [-120.81368, 37.78684], [-120.8148, 37.78683], [-120.81525, 37.78688], [-120.81579, 37.78697], [-120.81674, 37.78697], [-120.81725, 37.78683], [-120.81777, 37.7866], [-120.81796, 37.78801]], [[-120.81641, 37.7829], [-120.81637, 37.78261], [-120.81576, 37.78291], [-120.81539, 37.78302], [-120.81522, 37.78337], [-120.81521, 37.78348], [-120.8154, 37.78386], [-120.81556, 37.78389], [-120.81566, 37.78395], [-120.81602, 37.78396], [-120.81609, 37.784], [-120.81655, 37.78409], [-120.81655, 37.78401], [-120.81644, 37.78328], [-120.81641, 37.7829]]]} | 2 | 9 | Oakdale Golf & Country Club | 32983 | 1227 | 2 | 2 | 2 | http://www.oakdalegov.com/#!recreation/c222d | 2 | 1227 | 2 | 2 | 2 | 2 | 137.317 | Oakdale Golf & Country Club | 0 | 3 | 4 | |
3 | {"type": "Polygon", "coordinates": [[[-120.8183, 37.79059], [-120.81762, 37.7907], [-120.81665, 37.79072], [-120.81597, 37.7907], [-120.81518, 37.79071], [-120.81444, 37.7908], [-120.81354, 37.79068], [-120.81324, 37.79069], [-120.81119, 37.79087], [-120.81012, 37.79017], [-120.80995, 37.78962], [-120.81, 37.78839], [-120.80928, 37.78757], [-120.80991, 37.78733], [-120.81064, 37.78764], [-120.8111, 37.78789], [-120.81169, 37.78776], [-120.81268, 37.78774], [-120.81358, 37.7878], [-120.81565, 37.78787], [-120.81602, 37.78793], [-120.81796, 37.78801], [-120.8183, 37.79059]]]} | 2 | 24 | Stanley Wakefield Wilderness Area | 25790 | 1227 | 2 | 2 | 2 | http://www.oakdalegov.com/#!recreation/c222d | 2 | 1227 | 2 | 2 | 2 | 2 | 57.379 | Stanley Wakefield Wilderness Area | 0 | 4 | 2 | |
4 | {"type": "MultiPolygon", "coordinates": [[[[-118.10598, 33.73945], [-118.10581, 33.73968], [-118.1051, 33.73933], [-118.10527, 33.73909], [-118.10598, 33.73945]]], [[[-118.10701, 33.73996], [-118.10683, 33.7402], [-118.10615, 33.73985], [-118.10632, 33.73962], [-118.10701, 33.73996]]], [[[-118.10746, 33.7402], [-118.10729, 33.74044], [-118.10691, 33.74024], [-118.10708, 33.74], [-118.10746, 33.7402]]]]} | 1 | 25 | Eisenhower Park | 18475 | 1329 | 3 | 2 | 2 | http://www.sealbeachca.gov/living/community/facilities/ | 2 | 1329 | 3 | 2 | 2 | 3 | 1.46 | Eisenhower Park | 0 | 2 | 4 | |
5 | {"type": "MultiPolygon", "coordinates": [[[[-117.11089, 32.73295], [-117.11088, 32.73298], [-117.11086, 32.73286], [-117.1107, 32.73261], [-117.11037, 32.73248], [-117.10993, 32.73245], [-117.10979, 32.73242], [-117.10919, 32.73273], [-117.10874, 32.73272], [-117.10872, 32.73247], [-117.10818, 32.73272], [-117.10811, 32.73272], [-117.10788, 32.73308], [-117.10775, 32.73295], [-117.10773, 32.73295], [-117.1074, 32.73315], [-117.10734, 32.73317], [-117.10705, 32.7334], [-117.10683, 32.73321], [-117.10705, 32.73283], [-117.10727, 32.73261], [-117.10691, 32.73234], [-117.10697, 32.73229], [-117.10703, 32.73226], [-117.10776, 32.73211], [-117.10766, 32.73176], [-117.10765, 32.73157], [-117.10769, 32.73139], [-117.10774, 32.73124], [-117.10782, 32.73111], [-117.10802, 32.73089], [-117.10797, 32.73062], [-117.10803, 32.73067], [-117.10847, 32.7309], [-117.10876, 32.73109], [-117.10866, 32.73109], [-117.10858, 32.73107], [-117.10849, 32.73117], [-117.10866, 32.73138], [-117.10875, 32.73158], [-117.10881, 32.73182], [-117.10883, 32.73208], [-117.10939, 32.73195], [-117.10985, 32.73194], [-117.10996, 32.73191], [-117.11035, 32.73217], [-117.11072, 32.73258], [-117.11089, 32.73286], [-117.11089, 32.73295]]], [[[-117.10995, 32.73399], [-117.10989, 32.73404], [-117.10985, 32.734], [-117.10991, 32.73395], [-117.10995, 32.73399]]]]} | 1 | 26 | Azalea Neighborhood Park | 30115 | 1297 | 4 | 2 | 2 | http://www.sandiego.gov/park-and-recreation/ | 2 | 1297 | 4 | 2 | 2 | 4 | 9.138 | Azalea Neighborhood Park | 0 | 2 | 4 | |
6 | {"type": "Polygon", "coordinates": [[[-121.93881, 36.98905], [-121.93822, 36.98905], [-121.93821, 36.98875], [-121.93824, 36.98871], [-121.93853, 36.9887], [-121.93856, 36.98875], [-121.93875, 36.98872], [-121.93881, 36.98905]]]} | 1 | 28 | Richard Vessey Park | 24328 | 327 | 5 | 3 | 3 | http://www.scparks.com/ | 3 | 327 | 5 | 3 | 3 | 5 | 0.46 | Richard Vessey Park | 0 | 2 | 4 | |
7 | {"type": "Polygon", "coordinates": [[[-117.70487, 34.09777], [-117.70457, 34.09776], [-117.7046, 34.09775], [-117.70462, 34.09772], [-117.70461, 34.09748], [-117.70381, 34.09747], [-117.7042, 34.09652], [-117.7048, 34.09652], [-117.70482, 34.09772], [-117.70483, 34.09775], [-117.70487, 34.09777]]]} | 1 | 30 | El Barrio Park | 18477 | 1057 | 6 | 2 | 2 | http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 | 2 | 1057 | 6 | 2 | 2 | 6 | 2.099 | El Barrio Park | 0 | 2 | 4 | |
8 | {"type": "Polygon", "coordinates": [[[-119.48323, 34.37952], [-119.48284, 34.37978], [-119.48215, 34.37935], [-119.48075, 34.37775], [-119.4785, 34.37584], [-119.47796, 34.37557], [-119.47746, 34.37548], [-119.47737, 34.37524], [-119.47812, 34.37527], [-119.47861, 34.37543], [-119.47887, 34.37564], [-119.47904, 34.37573], [-119.47969, 34.37544], [-119.48031, 34.37629], [-119.48123, 34.37728], [-119.48177, 34.37797], [-119.48233, 34.37854], [-119.48323, 34.37952]]]} | 1 | 36 | Rincon Beach Park | 24367 | 325 | 7 | 3 | 3 | http://cosb.countyofsb.org/parks/ | 3 | 325 | 7 | 3 | 3 | 7 | 11.623 | Rincon Beach Park | 0 | 2 | 4 | |
9 | {"type": "MultiPolygon", "coordinates": [[[[-117.09436, 32.74201], [-117.09395, 32.74201], [-117.09393, 32.74146], [-117.09346, 32.74146], [-117.09345, 32.74102], [-117.09291, 32.74017], [-117.09284, 32.74016], [-117.09282, 32.73919], [-117.09236, 32.73919], [-117.09235, 32.7385], [-117.0928, 32.73849], [-117.09279, 32.73755], [-117.09339, 32.73754], [-117.09339, 32.73696], [-117.09359, 32.73697], [-117.0936, 32.73699], [-117.0938, 32.73699], [-117.09383, 32.7391], [-117.09321, 32.73912], [-117.09324, 32.74037], [-117.09385, 32.74037], [-117.09387, 32.74118], [-117.09435, 32.74118], [-117.09436, 32.74201]]], [[[-117.09277, 32.74057], [-117.0927, 32.74058], [-117.09269, 32.74084], [-117.09238, 32.74085], [-117.09238, 32.74039], [-117.09276, 32.74038], [-117.09277, 32.74057]]], [[[-117.09497, 32.74242], [-117.09456, 32.74242], [-117.09456, 32.74223], [-117.09497, 32.74222], [-117.09497, 32.74242]]], [[[-117.09603, 32.7429], [-117.09564, 32.74291], [-117.09564, 32.7427], [-117.09603, 32.7427], [-117.09603, 32.7429]]]]} | 1 | 31 | 47th Street Canyon | 15202 | 1297 | 4 | 2 | 2 | http://www.sandiego.gov/park-and-recreation/ | 2 | 1297 | 4 | 2 | 2 | 4 | 9.994 | 47th Street Canyon | 0 | 3 | 4 | |
10 | {"type": "Polygon", "coordinates": [[[-117.08431, 32.9339], [-117.08421, 32.93398], [-117.08411, 32.93375], [-117.08393, 32.93344], [-117.08356, 32.93329], [-117.08306, 32.93325], [-117.08297, 32.9331], [-117.08313, 32.93271], [-117.08313, 32.93246], [-117.08292, 32.93223], [-117.08257, 32.9321], [-117.08257, 32.93151], [-117.08386, 32.93278], [-117.08402, 32.93297], [-117.08415, 32.93318], [-117.08425, 32.93342], [-117.0843, 32.93368], [-117.08431, 32.9339]]]} | 1 | 46738 | Butterfly Mini-Park | 30187 | 1297 | 4 | 2 | 2 | http://www.sandiego.gov/park-and-recreation/ | 2 | 1297 | 4 | 2 | 2 | 4 | 3.079 | Butterfly Mini-Park | 0 | 2 | 4 | |
11 | {"type": "Polygon", "coordinates": [[[-120.70087, 35.73565], [-120.70026, 35.73762], [-120.70033, 35.73765], [-120.69995, 35.73853], [-120.69975, 35.73891], [-120.69913, 35.73992], [-120.6988, 35.73992], [-120.70087, 35.73565]]]} | 1 | 48 | Rios Caledonia Adobe | 24392 | 323 | 8 | 3 | 3 | http://www.slocountyparks.com/ | 3 | 323 | 8 | 3 | 3 | 1 | 3.26 | Rios Caledonia Adobe | 5 | |||
12 | {"type": "Polygon", "coordinates": [[[-120.84861, 37.76492], [-120.8483, 37.76505], [-120.84814, 37.76482], [-120.84845, 37.76468], [-120.84861, 37.76492]]]} | 1 | 49 | William Meyer Park | 27553 | 1227 | 2 | 2 | 2 | http://www.oakdalegov.com/#!recreation/c222d | 2 | 1227 | 2 | 2 | 2 | 2 | 0.233 | William Meyer Park | 0 | 2 | 4 | |
13 | {"type": "Polygon", "coordinates": [[[-122.03122, 36.97381], [-122.03122, 36.97381], [-122.03111, 36.97409], [-122.03105, 36.97384], [-122.03122, 36.97381]]]} | 1 | 42 | Rincon Park | 24369 | 1320 | 9 | 2 | 2 | http://www.cityofsantacruz.com/departments/parks-recreation | 2 | 1320 | 9 | 2 | 2 | 5 | 0.055 | Rincon Park | 0 | 2 | 4 | |
14 | {"type": "Polygon", "coordinates": [[[-120.87737, 37.76176], [-120.87616, 37.76176], [-120.87611, 37.76172], [-120.8761, 37.76055], [-120.87615, 37.76051], [-120.87682, 37.76051], [-120.87688, 37.76054], [-120.87736, 37.76051], [-120.87737, 37.76176]]]} | 1 | 43 | William A. Fish Veterans Memorial Park | 27537 | 1227 | 2 | 2 | 2 | http://www.oakdalegov.com/#!recreation/c222d | 2 | 1227 | 2 | 2 | 2 | 2 | 3.803 | William A. Fish Veterans Memorial Park | 0 | 2 | 4 | |
15 | {"type": "Polygon", "coordinates": [[[-121.15169, 37.47476], [-121.15143, 37.47478], [-121.15101, 37.47485], [-121.15025, 37.47485], [-121.15026, 37.4736], [-121.15131, 37.4736], [-121.15156, 37.47359], [-121.15169, 37.47476]]]} | 1 | 66 | Ambercot Park | 15443 | 1248 | 10 | 2 | 2 | http://www.ci.patterson.ca.us/ | 2 | 1248 | 10 | 2 | 2 | 2 | 4.088 | Ambercot Park | 0 | 2 | 4 | |
16 | {"type": "Polygon", "coordinates": [[[-118.12258, 34.69275], [-118.12251, 34.69275], [-118.1225, 34.69267], [-118.1217, 34.69267], [-118.12164, 34.69261], [-118.12164, 34.69054], [-118.12169, 34.69048], [-118.12257, 34.69049], [-118.12258, 34.69275]]]} | 1 | 56 | El Dorado Park | 18505 | 1169 | 11 | 2 | 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | 2 | 1169 | 11 | 2 | 2 | 6 | 5.137 | El Dorado Park | 0 | 2 | 4 | |
17 | {"type": "Polygon", "coordinates": [[[-118.95325, 34.18233], [-118.94954, 34.18265], [-118.94921, 34.18001], [-118.94982, 34.17958], [-118.95014, 34.17942], [-118.95045, 34.17932], [-118.95086, 34.17926], [-118.95165, 34.17922], [-118.9523, 34.17926], [-118.95325, 34.18233]]]} | 1 | 58 | Borchard Park | 16277 | 2025 | 12 | 4 | 4 | http://www.crpd.org/ | 4 | 2025 | 12 | 4 | 4 | 8 | 27.263 | Borchard Park | 0 | 2 | 4 | |
18 | {"type": "Polygon", "coordinates": [[[-117.08916, 32.92533], [-117.08917, 32.92536], [-117.08915, 32.92627], [-117.08884, 32.92626], [-117.08902, 32.92612], [-117.08902, 32.926], [-117.08877, 32.92601], [-117.08855, 32.92613], [-117.08872, 32.92567], [-117.0877, 32.92529], [-117.08912, 32.92531], [-117.08916, 32.92533]]]} | 1 | 46740 | Dry Creek Mini-Park | 30190 | 1297 | 4 | 2 | 2 | http://www.sandiego.gov/park-and-recreation/ | 2 | 1297 | 4 | 2 | 2 | 4 | 1.479 | Dry Creek Mini-Park | 0 | 2 | 4 | |
19 | {"type": "Polygon", "coordinates": [[[-121.7511, 36.90667], [-121.74954, 36.9078], [-121.74933, 36.90761], [-121.75087, 36.90647], [-121.7511, 36.90667]]]} | 1 | 76 | River Park | 24419 | 1373 | 13 | 2 | 2 | http://cityofwatsonville.org/parks-community-services | 2 | 1373 | 13 | 2 | 2 | 5 | 1.349 | River Park | 0 | 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW units_with_maps_view AS select id, AsGeoJSON(geometry) as 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 from CPAD_2020a_Units order by id;