units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where AGNCY_NAME = 587 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
DES_TP 10
- Local Park 25
- Local Recreation Area 3
- Local Conservation Area 3
- Local Resource Management Area 3
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency · 40 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3116 | 3116 | 3115 | {"type": "Polygon", "coordinates": [[[-124.09163, 40.87827], [-124.09018, 40.87896], [-124.0902, 40.87926], [-124.08942, 40.87931], [-124.08939, 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 | 25392 | Shay Park | 25378 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 4.66 | Shay Park | 0 | Local Park 2 | 4 | |
3117 | 3117 | 3116 | {"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 | 25393 | Larson Park | 21039 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 2.175 | Larson Park | 0 | Local Park 2 | 4 | |
3996 | 3996 | 3995 | {"type": "Polygon", "coordinates": [[[-124.06854, 40.86404], [-124.0684, 40.86405], [-124.06846, 40.86466], [-124.06734, 40.86467], [-124.06703, 40.86377], [-124.06672, 40.86309], [-124.06685, 40.86302], [-124.06697, 40.86297], [-124.06725, 40.86295], [-124.06737, 40.86291], [-124.06748, 40.86283], [-124.06753, 40.86276], [-124.06754, 40.86269], [-124.06804, 40.86252], [-124.06795, 40.8623], [-124.0683, 40.86229], [-124.06839, 40.86331], [-124.06844, 40.86361], [-124.06854, 40.86404]]]} | Unknown Access 4 | 46793 | Arcata Ridge Trail | 30248 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 6.431 | Arcata Ridge Trail | 0 | Local Recreation Area 3 | 4 | |
4691 | 4691 | 4690 | {"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 | 44899 | Arcata Plaza | 15571 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 1.01 | Arcata Plaza | 0 | Local Park 2 | 4 | |
12176 | 12176 | 12175 | {"type": "MultiPolygon", "coordinates": [[[[-124.0809, 40.90088], [-124.08082, 40.90117], [-124.08031, 40.90155], [-124.0803, 40.90137], [-124.08001, 40.90137], [-124.08016, 40.90113], [-124.08043, 40.90093], [-124.08058, 40.90074], [-124.0809, 40.90088]]], [[[-124.08262, 40.9], [-124.0818, 40.90012], [-124.08143, 40.90028], [-124.08122, 40.90049], [-124.08104, 40.90075], [-124.08071, 40.9006], [-124.08146, 40.8999], [-124.08251, 40.89977], [-124.08262, 40.9]]], [[[-124.08444, 40.90006], [-124.0829, 40.90006], [-124.08274, 40.89974], [-124.08351, 40.89951], [-124.08428, 40.89974], [-124.08444, 40.90006]]]]} | Open Access 1 | 25386 | Valley West Park | 26813 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 3.57 | Valley West Park | 0 | Local Park 2 | 4 | |
12177 | 12177 | 12176 | {"type": "Polygon", "coordinates": [[[-124.09141, 40.89419], [-124.09106, 40.8951], [-124.08936, 40.89476], [-124.0896, 40.89423], [-124.08968, 40.89424], [-124.08979, 40.89399], [-124.08908, 40.89382], [-124.08916, 40.89365], [-124.09141, 40.89419]]]} | Open Access 1 | 25387 | Pacific Union Park | 23307 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 4.148 | Pacific Union Park | 0 | Local Park 2 | 4 | |
12189 | 12189 | 12188 | {"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.08852, 40.89321], [-124.08886, 40.8933]]]} | Open Access 1 | 25388 | Chevret-Vaissade Park | 17186 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 1.478 | Chevret-Vaissade Park | 0 | Local Park 2 | 4 | |
12190 | 12190 | 12189 | {"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 | 25389 | Cahill Park | 16657 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 0.726 | Cahill Park | 0 | Local Park 2 | 4 | |
12191 | 12191 | 12190 | {"type": "Polygon", "coordinates": [[[-124.09816, 40.88452], [-124.09781, 40.88546], [-124.09624, 40.88518], [-124.09642, 40.88458], [-124.09643, 40.88448], [-124.09616, 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 | 25390 | Ennes Park | 18680 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 4.669 | Ennes Park | 0 | Local Park 2 | 4 | |
12192 | 12192 | 12191 | {"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.88064], [-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 | 25391 | Westwood Manor Park | 27438 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 1.723 | Westwood Manor Park | 0 | Local Park 2 | 4 | |
12193 | 12193 | 12192 | {"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 | 25394 | Bloomfield Park | 16169 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 0.227 | Bloomfield Park | 0 | Local Park 2 | 4 | |
12194 | 12194 | 12193 | {"type": "Polygon", "coordinates": [[[-124.10196, 40.87464], [-124.10178, 40.87506], [-124.10161, 40.87507], [-124.1017, 40.8743], [-124.10188, 40.87446], [-124.1019, 40.8745], [-124.10191, 40.87458], [-124.10196, 40.87464]]]} | Open Access 1 | 25395 | Greeniview Park | 19481 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 0.359 | Greeniview Park | 0 | Local Park 2 | 4 | |
12195 | 12195 | 12194 | {"type": "Polygon", "coordinates": [[[-124.10363, 40.87107], [-124.1035, 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.87165], [-124.10338, 40.87163], [-124.10335, 40.87155], [-124.10335, 40.87128], [-124.10291, 40.87128], [-124.10295, 40.87121], [-124.10296, 40.87116], [-124.1028, 40.87113], [-124.10263, 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 | 25397 | Windsong Park | 27634 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 1.768 | Windsong Park | 0 | Local Park 2 | 4 | |
12196 | 12196 | 12195 | {"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 | 25396 | Mountain View Park | 22560 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 0.262 | Mtn. View Park | 0 | Local Park 2 | 4 | |
12198 | 12198 | 12197 | {"type": "Polygon", "coordinates": [[[-124.08833, 40.87401], [-124.08824, 40.87428], [-124.08822, 40.87429], [-124.08819, 40.87435], [-124.08811, 40.87435], [-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.08751, 40.87447], [-124.0877, 40.87396], [-124.08777, 40.87397], [-124.0878, 40.8739], [-124.08833, 40.87401]]]} | Open Access 1 | 25398 | Stewart Park | 25847 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 1.293 | Stewart Park | 0 | Local Park 2 | 4 | |
12199 | 12199 | 12198 | {"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 | 25399 | Vinum Park | 27151 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 0.09 | Vinum Park | 0 | Local Park 2 | 4 | |
12200 | 12200 | 12199 | {"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.08404, 40.86725], [-124.08456, 40.86735], [-124.08463, 40.86739], [-124.08493, 40.86744], [-124.085, 40.86763]]]} | Open Access 1 | 25400 | Arcata Ball Park | 15568 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 4.152 | Arcata Ball Park | 0 | Local Recreation Area 3 | 4 | |
12201 | 12201 | 12200 | {"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 | 25401 | D Street Linear Park | 17890 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 1.238 | D Street Linear Park | 0 | Local Park 2 | 4 | |
12202 | 12202 | 12201 | {"type": "Polygon", "coordinates": [[[-124.06734, 40.85995], [-124.0671, 40.86059], [-124.0665, 40.86058], [-124.06618, 40.86039], [-124.06578, 40.86068], [-124.0642, 40.86067], [-124.0642, 40.86061], [-124.06574, 40.86061], [-124.06612, 40.86035], [-124.06618, 40.86035], [-124.06618, 40.86013], [-124.0661, 40.85993], [-124.06609, 40.85936], [-124.0664, 40.85938], [-124.06655, 40.85941], [-124.06667, 40.85946], [-124.06678, 40.85952], [-124.06734, 40.85995]]]} | Open Access 1 | 25403 | Sunny Brae Park | 26002 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 2.929 | Sunny Brae Park | 0 | Local Park 2 | 4 | |
12203 | 12203 | 12202 | {"type": "Polygon", "coordinates": [[[-124.07064, 40.85552], [-124.07035, 40.85549], [-124.07033, 40.85561], [-124.07028, 40.85566], [-124.07013, 40.8556], [-124.07014, 40.85547], [-124.06892, 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 | 25404 | Bayside Park | 15898 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 4.738 | Bayside 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]);