units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where MNG_AGENCY = 577 sorted by map
This data as json, copyable, CSV (advanced)
DES_TP 4
- Local Park 16
- Local Recreation Area 2
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 20
MNG_AGENCY 1
- Arcata, City of · 20 ✖
ACCESS_TYP 1
- Open Access 20
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
14370 | 14370 | 14369 | {"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 | 47026 | Arcata Skateboard Park | 30675 | 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.656 | Arcata Skateboard Park | 0 | Local Recreation Area 3 | 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 | |
14416 | 14416 | 14415 | {"type": "Polygon", "coordinates": [[[-124.08511, 40.88587], [-124.08396, 40.88873], [-124.08299, 40.8885], [-124.08291, 40.88869], [-124.08254, 40.8887], [-124.08248, 40.88872], [-124.08231, 40.88899], [-124.08225, 40.889], [-124.08209, 40.88899], [-124.0825, 40.88849], [-124.08255, 40.88846], [-124.08271, 40.88841], [-124.08299, 40.8884], [-124.08333, 40.88846], [-124.08346, 40.88813], [-124.08351, 40.88808], [-124.0837, 40.88795], [-124.08381, 40.8877], [-124.08407, 40.88743], [-124.08412, 40.88735], [-124.08413, 40.88722], [-124.08402, 40.88687], [-124.08407, 40.88654], [-124.08409, 40.88648], [-124.08416, 40.8864], [-124.08428, 40.88634], [-124.08431, 40.88628], [-124.08427, 40.88623], [-124.08392, 40.88608], [-124.08335, 40.88579], [-124.08313, 40.88574], [-124.08272, 40.88605], [-124.0824, 40.88632], [-124.08238, 40.88637], [-124.08241, 40.8865], [-124.0824, 40.8867], [-124.08231, 40.88697], [-124.08161, 40.88806], [-124.08155, 40.88806], [-124.0815, 40.88804], [-124.08147, 40.888], [-124.08147, 40.88788], [-124.08148, 40.88782], [-124.08156, 40.88762], [-124.08194, 40.88677], [-124.08197, 40.88667], [-124.08197, 40.88643], [-124.08192, 40.8863], [-124.08184, 40.88613], [-124.08275, 40.88537], [-124.08511, 40.88587]]]} | Open Access 1 | 47031 | Janes Creek Meadows Openspace | 30682 | 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 | 8.926 | Janes Creek Meadows Openspace | None 1225 | |||
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 | |
14395 | 14395 | 14394 | {"type": "Polygon", "coordinates": [[[-124.09033, 40.88257], [-124.08988, 40.88247], [-124.08972, 40.88274], [-124.08961, 40.88276], [-124.08955, 40.88283], [-124.08947, 40.88276], [-124.08882, 40.88322], [-124.08862, 40.88319], [-124.08881, 40.88305], [-124.08885, 40.88279], [-124.08965, 40.88244], [-124.08965, 40.88242], [-124.08949, 40.88239], [-124.08987, 40.88222], [-124.09006, 40.88221], [-124.09006, 40.88216], [-124.09029, 40.8821], [-124.09033, 40.88257]]]} | Open Access 1 | 47029 | Stewart Court Openspace | 30680 | 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.226 | Stewart Court Openspace | None 1222 | |||
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 | |
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 | |
14363 | 14363 | 14362 | {"type": "Polygon", "coordinates": [[[-124.10116, 40.86867], [-124.10115, 40.86872], [-124.10078, 40.86853], [-124.10046, 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.09955, 40.87187], [-124.0992, 40.87218], [-124.09912, 40.87217], [-124.09948, 40.87184], [-124.09959, 40.87145], [-124.10015, 40.87019], [-124.09965, 40.86926], [-124.10003, 40.86878], [-124.10045, 40.86852], [-124.1008, 40.86847], [-124.10116, 40.86867]]]} | Open Access 1 | 47023 | Janes Creek Linear Park | 30672 | 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.044 | Janes Creek Linear 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 |
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]);