units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
25 rows where DES_TP = 2 and MNG_AGENCY = 577 sorted by map
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 25
MNG_AGENCY 1
- Arcata, City of · 25 ✖
DES_TP 1
- Local Park · 25 ✖
ACCESS_TYP 1
- Open Access 25
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12215 | 12215 | 12214 | {"type": "MultiPolygon", "coordinates": [[[[-124.07687, 40.87124], [-124.07681, 40.8714], [-124.07594, 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 | 25406 | Redwood Park | 24251 | 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.69 | Redwood Park | 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 | |
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 | |
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 | |
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 | |
12273 | 12273 | 12272 | {"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.07578, 40.88998], [-124.0759, 40.88996], [-124.07602, 40.88996], [-124.07617, 40.89]]]} | Open Access 1 | 46910 | Woodland Heights Park | 30670 | 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.94 | Woodland Heights Park | 0 | Local Park 2 | 4 | |
14437 | 14437 | 14436 | {"type": "Polygon", "coordinates": [[[-124.08115, 40.90861], [-124.07801, 40.90861], [-124.07678, 40.90858], [-124.07676, 40.90785], [-124.07678, 40.90688], [-124.07731, 40.90688], [-124.07732, 40.9067], [-124.07806, 40.9067], [-124.07806, 40.90609], [-124.07862, 40.90609], [-124.07862, 40.90612], [-124.07875, 40.90612], [-124.0785, 40.90669], [-124.07851, 40.90671], [-124.08114, 40.90672], [-124.08112, 40.90744], [-124.08115, 40.90861]]]} | Open Access 1 | 47020 | Carlson Park | 30657 | 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 | 19.718 | Carlson Park | 0 | Local Park 2 | 4 | |
12678 | 12678 | 12677 | {"type": "Polygon", "coordinates": [[[-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.86521], [-124.07794, 40.86501], [-124.07786, 40.86482], [-124.07774, 40.86461], [-124.07736, 40.86414], [-124.07729, 40.86399], [-124.07723, 40.86382], [-124.07879, 40.86381], [-124.07878, 40.86204], [-124.07938, 40.86218], [-124.07963, 40.86221], [-124.07982, 40.86226], [-124.0801, 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.08245, 40.86613], [-124.08118, 40.86589]], [[-124.08031, 40.86541], [-124.0803, 40.86539], [-124.07952, 40.86513], [-124.0793, 40.8655], [-124.0801, 40.86576], [-124.08031, 40.86541]]]} | Open Access 1 | 29649 | Arcata Community Park | 15569 | 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 | 30.385 | Arcata Community 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 | |
14438 | 14438 | 14437 | {"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 | 47030 | Janes Creek Meadows Park | 30681 | 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.826 | Janes Creek Meadows 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 | |
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 | |
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 | |
12216 | 12216 | 12215 | {"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 | 25407 | Rotary Park | 24701 | 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.278 | Rotary 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 | |
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 | |
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 | |
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 | |
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 |
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]);