superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where ACCESS_TYP = 1, MNG_AGENCY = 577 and MNG_AG_LEV = 2
This data as json, copyable, CSV (advanced)
| Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3 | 3 | 2 | {"type": "Polygon", "coordinates": [[[-124.07492, 40.87037], [-124.07461, 40.87119], [-124.07397, 40.87105], [-124.0737, 40.87112], [-124.07367, 40.87137], [-124.07234, 40.87141], [-124.07235, 40.8723], [-124.07129, 40.87238], [-124.07056, 40.87281], [-124.0682, 40.87301], [-124.06744, 40.87317], [-124.06676, 40.87295], [-124.06379, 40.87317], [-124.06382, 40.87373], [-124.06444, 40.87406], [-124.06534, 40.87462], [-124.06538, 40.87559], [-124.06714, 40.87566], [-124.06821, 40.87656], [-124.06822, 40.87759], [-124.0653, 40.87896], [-124.06241, 40.87839], [-124.06239, 40.8784], [-124.0624, 40.87901], [-124.06238, 40.88], [-124.06554, 40.88184], [-124.06606, 40.88232], [-124.06712, 40.88074], [-124.06769, 40.8814], [-124.06846, 40.88182], [-124.06902, 40.88199], [-124.07093, 40.88148], [-124.07235, 40.88141], [-124.0722, 40.88199], [-124.07224, 40.88215], [-124.07251, 40.88258], [-124.07253, 40.88301], [-124.07212, 40.88302], [-124.0721, 40.88305], [-124.06825, 40.883], [-124.06812, 40.88314], [-124.06791, 40.88307], [-124.06779, 40.88306], [-124.06763, 40.88299], [-124.06229, 40.88293], [-124.0575, 40.88284], [-124.0576, 40.87934], [-124.0432, 40.87927], [-124.04326, 40.8719], [-124.04336, 40.86838], [-124.04635, 40.86837], [-124.0514, 40.86833], [-124.05143, 40.86674], [-124.0518, 40.86688], [-124.05202, 40.86692], [-124.0521, 40.86691], [-124.05214, 40.86695], [-124.05213, 40.86831], [-124.05283, 40.86832], [-124.05286, 40.87227], [-124.05337, 40.87223], [-124.06247, 40.87221], [-124.06249, 40.87019], [-124.06309, 40.86987], [-124.06369, 40.86962], [-124.06409, 40.86941], [-124.06445, 40.86926], [-124.06466, 40.86922], [-124.06486, 40.86915], [-124.06589, 40.86866], [-124.06606, 40.86862], [-124.06629, 40.86862], [-124.06665, 40.86874], [-124.0669, 40.86879], [-124.06714, 40.86879], [-124.06781, 40.86875], [-124.06879, 40.86889], [-124.06915, 40.8689], [-124.06946, 40.86887], [-124.06977, 40.86879], [-124.0709, 40.86834], [-124.07478, 40.86835], [-124.07414, 40.87], [-124.0745, 40.87028], [-124.07492, 40.87037]]]} | Open Access 1 | Arcata Community Forest | http://www.cityofarcata.org/departments/environmental-services/city-forests/trail-map | 295 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 636.027 | Arcata Community Forest | |
| 1210 | 1210 | 1209 | {"type": "Polygon", "coordinates": [[[-124.08692, 40.86833], [-124.08671, 40.86888], [-124.08598, 40.86873], [-124.08619, 40.86818], [-124.08692, 40.86833]]]} | Open Access 1 | Arcata Plaza | 15571 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1.009 | Arcata Plaza | ||
| 1546 | 1546 | 1545 | {"type": "Polygon", "coordinates": [[[-124.085, 40.86763], [-124.08467, 40.8685], [-124.08346, 40.86823], [-124.08341, 40.86778], [-124.08344, 40.86712], [-124.08346, 40.86703], [-124.08349, 40.86697], [-124.08355, 40.86692], [-124.08369, 40.86686], [-124.08378, 40.86684], [-124.08416, 40.86688], [-124.08405, 40.86725], [-124.08456, 40.86735], [-124.08463, 40.86739], [-124.08493, 40.86744], [-124.085, 40.86763]]]} | Open Access 1 | Arcata Ball Park | 15568 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 4.155 | Arcata Ball Park | ||
| 1547 | 1547 | 1546 | {"type": "Polygon", "coordinates": [[[-124.08256, 40.86612], [-124.08245, 40.86613], [-124.08118, 40.86589], [-124.08058, 40.86581], [-124.08036, 40.86582], [-124.08035, 40.8659], [-124.07797, 40.86594], [-124.07798, 40.8655], [-124.078, 40.86534], [-124.07798, 40.8652], [-124.07794, 40.86501], [-124.07786, 40.86482], [-124.07774, 40.86461], [-124.07736, 40.86414], [-124.07728, 40.86399], [-124.07723, 40.86382], [-124.07878, 40.86381], [-124.07878, 40.86204], [-124.07938, 40.86218], [-124.07964, 40.86221], [-124.07982, 40.86226], [-124.08009, 40.86236], [-124.08045, 40.86255], [-124.08067, 40.86271], [-124.08195, 40.86389], [-124.08214, 40.86407], [-124.08228, 40.86425], [-124.0824, 40.86448], [-124.08249, 40.86476], [-124.08266, 40.86597], [-124.08266, 40.86603], [-124.08263, 40.86606], [-124.08256, 40.86612]], [[-124.0803, 40.86541], [-124.0803, 40.86539], [-124.07952, 40.86513], [-124.07931, 40.8655], [-124.08009, 40.86576], [-124.0803, 40.86541]]]} | Open Access 1 | Arcata Community Park | 15569 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 30.41 | Arcata Community Park | ||
| 1554 | 1554 | 1553 | {"type": "MultiPolygon", "coordinates": [[[[-124.09223, 40.85202], [-124.09217, 40.85221], [-124.09217, 40.85225], [-124.09215, 40.85228], [-124.0922, 40.85233], [-124.09217, 40.85237], [-124.09208, 40.85261], [-124.09198, 40.85277], [-124.09191, 40.85305], [-124.09182, 40.85328], [-124.09181, 40.85336], [-124.09173, 40.85337], [-124.09169, 40.85341], [-124.09169, 40.85343], [-124.09173, 40.85348], [-124.09167, 40.85366], [-124.09157, 40.85371], [-124.09157, 40.85374], [-124.09162, 40.85379], [-124.09161, 40.85386], [-124.09154, 40.85392], [-124.09147, 40.85408], [-124.09139, 40.8543], [-124.09136, 40.85444], [-124.09125, 40.85461], [-124.09119, 40.85468], [-124.0911, 40.85476], [-124.09093, 40.85484], [-124.09088, 40.8549], [-124.09081, 40.8549], [-124.09077, 40.85493], [-124.09069, 40.85491], [-124.09058, 40.85492], [-124.08966, 40.8546], [-124.08891, 40.85519], [-124.08854, 40.85492], [-124.0858, 40.85304], [-124.08464, 40.85214], [-124.08416, 40.85171], [-124.08351, 40.85098], [-124.0832, 40.85056], [-124.08307, 40.85033], [-124.08347, 40.85033], [-124.08347, 40.85012], [-124.08388, 40.84935], [-124.08421, 40.84866], [-124.08428, 40.84847], [-124.08437, 40.84857], [-124.08442, 40.84866], [-124.08445, 40.84869], [-124.08445, 40.84881], [-124.0845, 40.84884], [-124.08456, 40.84887], [-124.08452, 40.84889], [-124.08454, 40.84892], [-124.08453, 40.84895], [-124.08462, 40.849], [-124.08463, 40.84906], [-124.08462, 40.8491], [-124.08468, 40.8492], [-124.0847, 40.8493], [-124.08472, 40.84932], [-124.08477, 40.84932], [-124.08488, 40.84929], [-124.08491, 40.8493], [-124.08493, 40.84933], [-124.08488, 40.84936], [-124.08491, 40.84939], [-124.08488, 40.84946], [-124.0849, 40.84948], [-124.08498, 40.84946], [-124.08497, 40.8494], [-124.08498, 40.84938], [-124.085, 40.84942], [-124.08507, 40.84946], [-124.08527, 40.84947], [-124.0863, 40.84945], [-124.08703, 40.8494], [-124.08735, 40.84934], [-124.08739, 40.84938], [-124.08747, 40.84932], [-124.08835, 40.84911], [-124.08866, 40.84906], [-124.08893, 40.84899], [-124.09039, 40.84871], [-124.09053, 40.84867], [-124.0906, 40.84866], [-124.09085, 40.84869], [-124.09104, 40.84876], [-124.09123, 40.84889], [-124.09137, 40.84909], [-124.09142, 40.8492], [-124.09144, 40.84929], [-124.09153, 40.84949], [-124.09164, 40.84995], [-124.09173, 40.85017], [-124.09176, 40.8503], [-124.09176, 40.85036], [-124.09182, 40.85046], [-124.09186, 40.85057], [-124.09196, 40.851], [-124.09205, 40.85128], [-124.09213, 40.85139], [-124.09214, 40.85145], [-124.09218, 40.85155], [-124.09217, 40.85166], [-124.0922, 40.85178], [-124.09218, 40.85184], [-124.09223, 40.85202]]], [[[-124.09288, 40.86131], [-124.09233, 40.86198], [-124.08922, 40.86191], [-124.08921, 40.86125], [-124.08924, 40.86109], [-124.08935, 40.86059], [-124.08901, 40.8605], [-124.08951, 40.85919], [-124.08989, 40.85814], [-124.08992, 40.85752], [-124.0895, 40.85628], [-124.08941, 40.85607], [-124.08932, 40.8559], [-124.08918, 40.85571], [-124.08897, 40.85547], [-124.08919, 40.85561], [-124.0896, 40.85596], [-124.09038, 40.85673], [-124.09101, 40.85744], [-124.0915, 40.8581], [-124.09191, 40.85878], [-124.09215, 40.85924], [-124.09236, 40.85971], [-124.09243, 40.85988], [-124.09269, 40.86069], [-124.09277, 40.86087], [-124.09288, 40.86131]]], [[[-124.10303, 40.86232], [-124.10334, 40.86264], [-124.10336, 40.8627], [-124.10336, 40.86281], [-124.1033, 40.86302], [-124.10326, 40.86308], [-124.10312, 40.86323], [-124.10288, 40.86341], [-124.1028, 40.86351], [-124.10277, 40.86358], [-124.10253, 40.86395], [-124.10204, 40.86408], [-124.10169, 40.8642], [-124.10189, 40.86465], [-124.10226, 40.86484], [-124.10237, 40.86492], [-124.10241, 40.86497], [-124.10243, 40.86513], [-124.10247, 40.8652], [-124.10291, 40.86556], [-124.10302, 40.86563], [-124.10308, 40.86571], [-124.10311, 40.8658], [-124.10309, 40.8659], [-124.10298, 40.86611], [-124.10292, 40.86618], [-124.10288, 40.86622], [-124.10274, 40.86627], [-124.10243, 40.86646], [-124.10239, 40.86695], [-124.10229, 40.86746], [-124.10181, 40.8675], [-124.10212, 40.86728], [-124.10215, 40.86708], [-124.10209, 40.86683], [-124.10224, 40.86614], [-124.10238, 40.86608], [-124.10246, 40.86575], [-124.10239, 40.86561], [-124.10216, 40.86535], [-124.10208, 40.86506], [-124.10164, 40.86479], [-124.09867, 40.86479], [-124.0984, 40.86542], [-124.0975, 40.86525], [-124.09736, 40.86557], [-124.09736, 40.86587], [-124.09543, 40.86547], [-124.09575, 40.86468], [-124.09314, 40.86393], [-124.09319, 40.86344], [-124.09322, 40.86268], [-124.09318, 40.86204], [-124.09306, 40.8613], [-124.09401, 40.86015], [-124.09505, 40.85893], [-124.0951, 40.85892], [-124.09517, 40.85895], [-124.09529, 40.85919], [-124.09541, 40.85934], [-124.09555, 40.85945], [-124.09574, 40.85955], [-124.09593, 40.85961], [-124.09638, 40.85966], [-124.09677, 40.85962], [-124.09678, 40.85961], [-124.09592, 40.85949], [-124.09568, 40.85939], [-124.09556, 40.85931], [-124.09543, 40.85917], [-124.0952, 40.85867], [-124.09512, 40.85863], [-124.09503, 40.85863], [-124.09495, 40.85869], [-124.09495, 40.85883], [-124.09493, 40.85887], [-124.09387, 40.86011], [-124.09303, 40.86114], [-124.09295, 40.86086], [-124.09281, 40.86051], [-124.09262, 40.85988], [-124.09236, 40.85926], [-124.09209, 40.85874], [-124.09174, 40.85817], [-124.09137, 40.85765], [-124.09083, 40.85698], [-124.09047, 40.85659], [-124.09037, 40.85632], [-124.09158, 40.85532], [-124.09172, 40.8553], [-124.09178, 40.85527], [-124.09179, 40.85525], [-124.09178, 40.85521], [-124.0918, 40.85517], [-124.09191, 40.85507], [-124.09234, 40.85459], [-124.09283, 40.85414], [-124.09301, 40.85393], [-124.09315, 40.85381], [-124.09323, 40.85376], [-124.0934, 40.85372], [-124.0936, 40.85371], [-124.09385, 40.85375], [-124.09408, 40.85376], [-124.09499, 40.85403], [-124.09519, 40.85412], [-124.09576, 40.85429], [-124.09614, 40.85442], [-124.09623, 40.85447], [-124.09628, 40.85448], [-124.09635, 40.85452], [-124.09687, 40.8547], [-124.09726, 40.85486], [-124.09757, 40.85496], [-124.09828, 40.85524], [-124.09844, 40.85537], [-124.09857, 40.85553], [-124.09861, 40.85559], [-124.09862, 40.85579], [-124.09854, 40.85603], [-124.09843, 40.85622], [-124.09847, 40.85636], [-124.09846, 40.85643], [-124.09838, 40.85664], [-124.09822, 40.85663], [-124.09769, 40.85819], [-124.09827, 40.85834], [-124.09854, 40.85836], [-124.09888, 40.85836], [-124.09989, 40.85815], [-124.10004, 40.85815], [-124.10027, 40.85818], [-124.10047, 40.8583], [-124.10059, 40.8584], [-124.10061, 40.85846], [-124.09991, 40.8586], [-124.09982, 40.85879], [-124.09984, 40.85888], [-124.10008, 40.85926], [-124.1002, 40.8595], [-124.10025, 40.85956], [-124.10031, 40.8596], [-124.1004, 40.85964], [-124.10096, 40.85977], [-124.10103, 40.85981], [-124.10107, 40.85986], [-124.10074, 40.86022], [-124.10055, 40.86034], [-124.10046, 40.86045], [-124.10041, 40.86063], [-124.10041, 40.86091], [-124.10042, 40.86098], [-124.10088, 40.86186], [-124.10121, 40.86266], [-124.10134, 40.86277], [-124.10153, 40.86286], [-124.1017, 40.8629], [-124.10192, 40.8629], [-124.10223, 40.86276], [-124.10263, 40.8624], [-124.10272, 40.86234], [-124.1029, 40.8623], [-124.10303, 40.86232]]], [[[-124.09302, 40.86339], [-124.09163, 40.863], [-124.09292, 40.86147], [-124.093, 40.86205], [-124.09303, 40.86246], [-124.09304, 40.86295], [-124.09302, 40.86339]]]]} | Open Access 1 | Arcata Marsh & Wildlife Sanctuary | 15570 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 316.549 | Arcata Marsh & Wildlife Sanctuary | ||
| 1845 | 1845 | 1844 | {"type": "Polygon", "coordinates": [[[-124.07064, 40.85552], [-124.07035, 40.85549], [-124.07033, 40.85561], [-124.07028, 40.85566], [-124.07013, 40.8556], [-124.07013, 40.85546], [-124.06893, 40.85533], [-124.0689, 40.85545], [-124.06812, 40.85538], [-124.06823, 40.85434], [-124.06957, 40.85436], [-124.07064, 40.85552]]]} | Open Access 1 | Bayside Park | 15898 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 4.741 | Bayside Park | ||
| 2083 | 2083 | 2082 | {"type": "Polygon", "coordinates": [[[-124.09816, 40.87522], [-124.09806, 40.87548], [-124.09772, 40.8754], [-124.09781, 40.87514], [-124.09816, 40.87522]]]} | Open Access 1 | Bloomfield Park | 16169 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 0.227 | Bloomfield Park | ||
| 2478 | 2478 | 2477 | {"type": "Polygon", "coordinates": [[[-124.08621, 40.88376], [-124.08501, 40.884], [-124.08491, 40.88399], [-124.08505, 40.88368], [-124.08526, 40.88372], [-124.08612, 40.8835], [-124.08621, 40.88376]]]} | Open Access 1 | Cahill Park | 16657 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 0.726 | Cahill Park | ||
| 2890 | 2890 | 2889 | {"type": "Polygon", "coordinates": [[[-124.08886, 40.8933], [-124.08859, 40.8939], [-124.08786, 40.89378], [-124.08791, 40.89359], [-124.08798, 40.89359], [-124.08806, 40.89356], [-124.08811, 40.89352], [-124.08813, 40.89347], [-124.08813, 40.89341], [-124.0881, 40.89337], [-124.08804, 40.89333], [-124.08798, 40.89331], [-124.08813, 40.89282], [-124.08864, 40.89295], [-124.08853, 40.89321], [-124.08886, 40.8933]]]} | Open Access 1 | Chevret-Vaissade Park | 17186 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1.48 | Chevret-Vaissade Park | ||
| 3402 | 3402 | 3401 | {"type": "MultiPolygon", "coordinates": [[[[-124.08224, 40.86983], [-124.08197, 40.87049], [-124.08181, 40.87124], [-124.08181, 40.87138], [-124.08178, 40.87152], [-124.08149, 40.87201], [-124.08143, 40.87205], [-124.08135, 40.87207], [-124.08115, 40.87203], [-124.08116, 40.87198], [-124.08124, 40.87204], [-124.08133, 40.87205], [-124.08139, 40.87203], [-124.08144, 40.87198], [-124.08145, 40.87191], [-124.08138, 40.87182], [-124.08138, 40.87175], [-124.08212, 40.8698], [-124.08224, 40.86983]]], [[[-124.08273, 40.86822], [-124.08237, 40.86951], [-124.08229, 40.8697], [-124.08217, 40.86967], [-124.08271, 40.86822], [-124.08273, 40.86822]]]]} | Open Access 1 | D Street Linear Park | 17890 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1.238 | D Street Linear Park | ||
| 4036 | 4036 | 4035 | {"type": "Polygon", "coordinates": [[[-124.09816, 40.88452], [-124.09781, 40.88546], [-124.09624, 40.88518], [-124.09642, 40.88458], [-124.09643, 40.88448], [-124.09617, 40.88441], [-124.09613, 40.88449], [-124.09577, 40.88442], [-124.09578, 40.88437], [-124.09586, 40.88431], [-124.09586, 40.88424], [-124.09581, 40.88418], [-124.09568, 40.88415], [-124.09576, 40.88393], [-124.09816, 40.88452]]]} | Open Access 1 | Ennes Park | 18680 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 4.671 | Ennes Park | ||
| 4741 | 4741 | 4740 | {"type": "Polygon", "coordinates": [[[-124.10196, 40.87464], [-124.10178, 40.87506], [-124.10161, 40.87507], [-124.1017, 40.8743], [-124.10188, 40.87446], [-124.10191, 40.87458], [-124.10196, 40.87464]]]} | Open Access 1 | Greeniview Park | 19481 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 0.358 | Greeniview Park | ||
| 6008 | 6008 | 6007 | {"type": "Polygon", "coordinates": [[[-124.08408, 40.88028], [-124.08369, 40.88029], [-124.08369, 40.88098], [-124.0828, 40.88077], [-124.08276, 40.88073], [-124.08253, 40.88085], [-124.08238, 40.88096], [-124.08226, 40.88107], [-124.08211, 40.88124], [-124.08228, 40.881], [-124.08245, 40.8808], [-124.08266, 40.88058], [-124.08296, 40.88032], [-124.0833, 40.88008], [-124.08351, 40.87995], [-124.08381, 40.8798], [-124.08407, 40.8797], [-124.08408, 40.88028]]]} | Open Access 1 | Larson Park | 21039 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 2.178 | Larson Park | ||
| 6127 | 6127 | 6126 | {"type": "Polygon", "coordinates": [[[-124.10402, 40.87414], [-124.10396, 40.87415], [-124.1039, 40.87418], [-124.10339, 40.87389], [-124.10351, 40.87388], [-124.10401, 40.87388], [-124.10402, 40.87414]]]} | Open Access 1 | Mountain View Park | 22560 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 0.262 | Mtn. View Park | ||
| 7850 | 7850 | 7849 | {"type": "Polygon", "coordinates": [[[-124.09141, 40.89419], [-124.09106, 40.8951], [-124.08936, 40.89476], [-124.0896, 40.89423], [-124.08968, 40.89424], [-124.08978, 40.89399], [-124.08908, 40.89382], [-124.08916, 40.89365], [-124.09141, 40.89419]]]} | Open Access 1 | Pacific Union Park | 23307 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 4.152 | Pacific Union Park | ||
| 8602 | 8602 | 8601 | {"type": "MultiPolygon", "coordinates": [[[[-124.07687, 40.87124], [-124.07681, 40.8714], [-124.07595, 40.87121], [-124.07587, 40.87138], [-124.07464, 40.8711], [-124.07477, 40.87078], [-124.07687, 40.87124]]], [[[-124.07613, 40.87058], [-124.07601, 40.87091], [-124.07506, 40.87069], [-124.07517, 40.87037], [-124.07613, 40.87058]]], [[[-124.07704, 40.87078], [-124.07692, 40.87111], [-124.07627, 40.87097], [-124.07639, 40.87064], [-124.07704, 40.87078]]]]} | Open Access 1 | Redwood Park | 24251 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 2.691 | Redwood Park | ||
| 9027 | 9027 | 9026 | {"type": "Polygon", "coordinates": [[[-124.08807, 40.8624], [-124.08802, 40.86253], [-124.08718, 40.86235], [-124.08723, 40.86221], [-124.08807, 40.8624]]]} | Open Access 1 | Rotary Park | 24701 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 0.278 | Rotary Park | ||
| 9345 | 9345 | 9344 | {"type": "Polygon", "coordinates": [[[-124.08305, 40.87281], [-124.08288, 40.87326], [-124.08285, 40.87325], [-124.08292, 40.87278], [-124.08305, 40.87281]]]} | Open Access 1 | Vinum Park | 27151 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 0.09 | Vinum Park | ||
| 9580 | 9580 | 9579 | {"type": "Polygon", "coordinates": [[[-124.09163, 40.87827], [-124.09018, 40.87896], [-124.0902, 40.87926], [-124.08942, 40.87931], [-124.08938, 40.87902], [-124.08899, 40.87904], [-124.08936, 40.87884], [-124.08966, 40.87866], [-124.08999, 40.8784], [-124.09022, 40.87817], [-124.0905, 40.87782], [-124.09073, 40.87745], [-124.09081, 40.87728], [-124.09093, 40.87696], [-124.09163, 40.87827]]]} | Open Access 1 | Shay Park | 25378 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 4.664 | Shay Park | ||
| 9967 | 9967 | 9966 | {"type": "Polygon", "coordinates": [[[-124.08833, 40.87401], [-124.08824, 40.87428], [-124.08821, 40.87429], [-124.08819, 40.87435], [-124.08811, 40.87436], [-124.08791, 40.8749], [-124.08773, 40.87486], [-124.08771, 40.8749], [-124.08738, 40.87483], [-124.08749, 40.87451], [-124.08715, 40.87443], [-124.08716, 40.8744], [-124.0875, 40.87447], [-124.0877, 40.87396], [-124.08777, 40.87397], [-124.0878, 40.8739], [-124.08833, 40.87401]]]} | Open Access 1 | Stewart Park | 25847 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1.299 | Stewart Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps(
id INT,
map,
ACCESS_TYP INT,
PARK_NAME TEXT,
PARK_URL TEXT,
SUID_NMA INT,
MNG_AG_ID INT,
MNG_AGENCY INT,
MNG_AG_LEV INT,
MNG_AG_TYP INT,
AGNCY_WEB TEXT,
LAYER INT,
ACRES REAL,
LABEL_NAME TEXT,
YR_EST INT,
FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
ON [superunits_with_maps] ([ACCESS_TYP]);