superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where MNG_AGENCY = 577 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
13339 | 13339 | 13338 | {"type": "MultiPolygon", "coordinates": [[[[-124.08853, 40.86727], [-124.08849, 40.86738], [-124.08823, 40.86732], [-124.08827, 40.86721], [-124.08853, 40.86727]]], [[[-124.09773, 40.87241], [-124.0977, 40.87249], [-124.09755, 40.87251], [-124.09741, 40.87256], [-124.09735, 40.8727], [-124.09726, 40.87269], [-124.09716, 40.87293], [-124.09704, 40.8729], [-124.09711, 40.87263], [-124.09748, 40.87243], [-124.09773, 40.87241]]]]} | No Public Access 3 | City of Arcata Openspace | 30673 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 0.304 | City of Arcata Openspace | ||
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 | ||
12203 | 12203 | 12202 | {"type": "Polygon", "coordinates": [[[-124.08449, 40.87943], [-124.0841, 40.87955], [-124.08362, 40.87974], [-124.08387, 40.87914], [-124.08395, 40.87899], [-124.08409, 40.87906], [-124.08449, 40.87943]]]} | Open Access 1 | Arcata Skateboard Park | 30675 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 0.656 | Arcata Skateboard 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 | ||
13145 | 13145 | 13144 | {"type": "MultiPolygon", "coordinates": [[[[-124.0864, 40.88579], [-124.08616, 40.88604], [-124.08552, 40.8859], [-124.08554, 40.88586], [-124.08609, 40.88597], [-124.08628, 40.88577], [-124.0864, 40.88579]]], [[[-124.08872, 40.88422], [-124.08785, 40.88561], [-124.08769, 40.88558], [-124.08732, 40.88562], [-124.08738, 40.88553], [-124.08782, 40.88545], [-124.08839, 40.88455], [-124.08846, 40.88429], [-124.08854, 40.88416], [-124.08872, 40.88422]]], [[[-124.08879, 40.88379], [-124.08864, 40.88404], [-124.08855, 40.88401], [-124.08871, 40.88376], [-124.08879, 40.88379]]]]} | No Public Access 3 | Janes Creek Openspace | 30677 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 0.744 | Janes Creek Openspace | ||
13222 | 13222 | 13221 | {"type": "Polygon", "coordinates": [[[-124.08343, 40.88819], [-124.08333, 40.88847], [-124.08299, 40.8884], [-124.08271, 40.88841], [-124.08255, 40.88846], [-124.0825, 40.88849], [-124.08243, 40.88858], [-124.08226, 40.88855], [-124.08235, 40.88833], [-124.08242, 40.88832], [-124.08249, 40.88828], [-124.08269, 40.88804], [-124.08293, 40.88806], [-124.08304, 40.88803], [-124.08314, 40.88798], [-124.08343, 40.88819]]]} | Open Access 1 | Janes Creek Meadows Park | 30681 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 0.827 | Janes Creek Meadows Park | ||
13333 | 13333 | 13332 | {"type": "Polygon", "coordinates": [[[-124.07617, 40.89], [-124.07601, 40.89045], [-124.07572, 40.89096], [-124.0756, 40.89093], [-124.07551, 40.89046], [-124.07554, 40.89023], [-124.07553, 40.89005], [-124.07564, 40.89004], [-124.07577, 40.88998], [-124.0759, 40.88996], [-124.07602, 40.88996], [-124.07617, 40.89]]]} | Open Access 1 | Woodland Heights Park | 30670 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 0.94 | Woodland Heights Park | ||
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 | ||
13338 | 13338 | 13337 | {"type": "Polygon", "coordinates": [[[-124.10116, 40.86867], [-124.10115, 40.86872], [-124.10078, 40.86853], [-124.10047, 40.86857], [-124.10009, 40.86882], [-124.09992, 40.86902], [-124.09985, 40.86948], [-124.10023, 40.87019], [-124.09988, 40.87097], [-124.09984, 40.87143], [-124.09954, 40.87187], [-124.0992, 40.87218], [-124.09912, 40.87217], [-124.09948, 40.87184], [-124.09959, 40.87145], [-124.10015, 40.8702], [-124.09965, 40.86926], [-124.10003, 40.86878], [-124.10045, 40.86852], [-124.1008, 40.86847], [-124.10116, 40.86867]]]} | Open Access 1 | Janes Creek Linear Park | 30672 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1.049 | Janes Creek Linear Park | ||
13208 | 13208 | 13207 | {"type": "Polygon", "coordinates": [[[-124.09033, 40.88257], [-124.08988, 40.88248], [-124.08972, 40.88274], [-124.08962, 40.88276], [-124.08955, 40.88283], [-124.08946, 40.88276], [-124.08882, 40.88322], [-124.08862, 40.88319], [-124.08881, 40.88305], [-124.08885, 40.88279], [-124.08964, 40.88244], [-124.08964, 40.88242], [-124.08949, 40.88239], [-124.08987, 40.88222], [-124.09005, 40.88221], [-124.09006, 40.88216], [-124.09029, 40.8821], [-124.09033, 40.88257]]]} | Open Access 1 | Stewart Court Openspace | 30680 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1.23 | Stewart Court Openspace | ||
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 | ||
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 | ||
13340 | 13340 | 13339 | {"type": "MultiPolygon", "coordinates": [[[[-124.0907, 40.87504], [-124.09043, 40.87498], [-124.09042, 40.87491], [-124.09035, 40.87489], [-124.0905, 40.87451], [-124.0907, 40.87504]]], [[[-124.09106, 40.87533], [-124.09097, 40.87542], [-124.09102, 40.87562], [-124.09096, 40.87576], [-124.09097, 40.87604], [-124.09089, 40.87657], [-124.09081, 40.8764], [-124.09075, 40.8762], [-124.09062, 40.87551], [-124.09044, 40.87505], [-124.09103, 40.87517], [-124.09106, 40.87533]]], [[[-124.09083, 40.87428], [-124.09074, 40.87443], [-124.09073, 40.87459], [-124.09067, 40.87467], [-124.09055, 40.87437], [-124.0906, 40.87423], [-124.09083, 40.87428]]]]} | Open Access 1 | Dellanina Nature Preserve | 30674 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1.332 | Dellanina Nature Preserve | ||
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 | ||
11163 | 11163 | 11162 | {"type": "MultiPolygon", "coordinates": [[[[-124.0932, 40.88057], [-124.09245, 40.88055], [-124.09246, 40.88037], [-124.0932, 40.88038], [-124.09315, 40.88044], [-124.09314, 40.88048], [-124.09316, 40.88053], [-124.0932, 40.88057]]], [[[-124.09396, 40.87952], [-124.09421, 40.88044], [-124.09415, 40.88086], [-124.09415, 40.881], [-124.09403, 40.88131], [-124.09378, 40.88156], [-124.09362, 40.88161], [-124.09383, 40.88129], [-124.09385, 40.88065], [-124.0934, 40.88063], [-124.09341, 40.88058], [-124.09346, 40.88053], [-124.09348, 40.88049], [-124.09346, 40.88043], [-124.09341, 40.88035], [-124.09386, 40.88036], [-124.0939, 40.8795], [-124.09396, 40.87952]]]]} | Open Access 1 | Westwood Manor Park | 27438 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1.731 | Westwood Manor Park | ||
11327 | 11327 | 11326 | {"type": "Polygon", "coordinates": [[[-124.10363, 40.87107], [-124.10351, 40.87107], [-124.10349, 40.87112], [-124.10345, 40.87115], [-124.10343, 40.87119], [-124.10345, 40.87126], [-124.10354, 40.87129], [-124.10355, 40.87196], [-124.10344, 40.87196], [-124.10341, 40.87169], [-124.1033, 40.87168], [-124.10332, 40.87166], [-124.10338, 40.87163], [-124.10335, 40.87155], [-124.10335, 40.87129], [-124.10291, 40.87128], [-124.10295, 40.87121], [-124.10295, 40.87116], [-124.1028, 40.87113], [-124.10264, 40.87104], [-124.1026, 40.87104], [-124.10253, 40.87087], [-124.10253, 40.87073], [-124.10252, 40.87072], [-124.10258, 40.87061], [-124.10267, 40.87053], [-124.10267, 40.87046], [-124.10282, 40.87048], [-124.10284, 40.87043], [-124.10338, 40.87058], [-124.10349, 40.87075], [-124.10348, 40.8709], [-124.10363, 40.87093], [-124.10363, 40.87107]]]} | Open Access 1 | Windsong Park | 27634 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1.775 | Windsong 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]);