superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
76 rows where MNG_AGENCY = 122 sorted by map
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 56
MNG_AGENCY 1
- Huntington Beach, City of · 56 ✖
ACCESS_TYP 1
- Open Access 56
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5972 | 5972 | 5971 | {"type": "Polygon", "coordinates": [[[-117.97583, 33.66579], [-117.97583, 33.66648], [-117.9743, 33.66637], [-117.97438, 33.66607], [-117.97442, 33.66579], [-117.97583, 33.66579]]]} | Open Access 1 | Moffett Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/moffett-park.cfm | 22347 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 2.381 | Moffett Park | |
7360 | 7360 | 7359 | {"type": "Polygon", "coordinates": [[[-117.9777, 33.67712], [-117.97736, 33.67712], [-117.9772, 33.67696], [-117.9771, 33.67669], [-117.97696, 33.67661], [-117.97684, 33.67658], [-117.9756, 33.67659], [-117.97544, 33.67656], [-117.97563, 33.6763], [-117.97762, 33.6763], [-117.97766, 33.67633], [-117.97769, 33.67638], [-117.9777, 33.67712]]]} | Open Access 1 | Newland Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/newland-park.cfm | 22728 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 2.248 | Newland Park | |
4765 | 4765 | 4764 | {"type": "Polygon", "coordinates": [[[-117.97795, 33.6865], [-117.97735, 33.6865], [-117.97731, 33.68648], [-117.97729, 33.68645], [-117.97724, 33.68366], [-117.97155, 33.68368], [-117.97154, 33.68313], [-117.97592, 33.68312], [-117.97593, 33.6831], [-117.97577, 33.68279], [-117.9757, 33.68275], [-117.97573, 33.68269], [-117.97575, 33.68258], [-117.9758, 33.68254], [-117.97637, 33.68253], [-117.97645, 33.68251], [-117.97653, 33.68245], [-117.97691, 33.68242], [-117.9778, 33.68241], [-117.9778, 33.68269], [-117.97786, 33.68274], [-117.97784, 33.68279], [-117.97784, 33.68285], [-117.9779, 33.68311], [-117.97795, 33.6865]]]} | Open Access 1 | Lagenbeck Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/lagenbeck-park.cfm | 20838 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 17.044 | Lagenbeck Park | |
5306 | 5306 | 5305 | {"type": "Polygon", "coordinates": [[[-117.97841, 33.64277], [-117.97662, 33.64365], [-117.97445, 33.64427], [-117.9734, 33.64289], [-117.97087, 33.64141], [-117.96566, 33.63891], [-117.96324, 33.6366], [-117.96422, 33.63562], [-117.97333, 33.63989], [-117.97502, 33.64075], [-117.97841, 33.64277]]]} | Open Access 1 | Huntington Beach Wetlands Addition | 20157 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 93.375 | Huntington Beach Wetlands Addition | ||
13673 | 13673 | 13672 | {"type": "Polygon", "coordinates": [[[-117.9811, 33.65217], [-117.97985, 33.65217], [-117.97981, 33.65214], [-117.9798, 33.6521], [-117.9798, 33.6516], [-117.97983, 33.65157], [-117.97987, 33.65155], [-117.98043, 33.65155], [-117.98051, 33.65156], [-117.98063, 33.65163], [-117.98073, 33.65163], [-117.98082, 33.65159], [-117.98102, 33.65144], [-117.98109, 33.65136], [-117.9811, 33.65217]]]} | Open Access 1 | Bauer Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/bauer-park.cfm | 31161 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 2.023 | Bauer Park | |
5958 | 5958 | 5957 | {"type": "Polygon", "coordinates": [[[-117.98242, 33.69516], [-117.98239, 33.69516], [-117.9823, 33.69527], [-117.98222, 33.69532], [-117.98201, 33.69537], [-117.98202, 33.69595], [-117.98197, 33.69608], [-117.98188, 33.69619], [-117.98163, 33.69641], [-117.98125, 33.69685], [-117.98086, 33.6968], [-117.98052, 33.69764], [-117.98041, 33.69764], [-117.9804, 33.69668], [-117.98063, 33.69667], [-117.98063, 33.69652], [-117.98094, 33.69609], [-117.98103, 33.696], [-117.98122, 33.69573], [-117.98128, 33.6957], [-117.98163, 33.69572], [-117.98172, 33.69535], [-117.98182, 33.69533], [-117.98205, 33.69534], [-117.98221, 33.6953], [-117.98233, 33.6952], [-117.98238, 33.69512], [-117.9824, 33.69503], [-117.98242, 33.69504], [-117.98242, 33.69516]]]} | Open Access 1 | Lambert Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/lambert-park.cfm | 20993 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 3.548 | Lambert Park | |
3708 | 3708 | 3707 | {"type": "Polygon", "coordinates": [[[-117.98267, 33.6682], [-117.98263, 33.66821], [-117.98258, 33.66825], [-117.98254, 33.66832], [-117.98253, 33.66844], [-117.98254, 33.66877], [-117.98249, 33.66881], [-117.9816, 33.66881], [-117.98159, 33.66789], [-117.98266, 33.66788], [-117.98266, 33.66817], [-117.98267, 33.6682]]]} | Open Access 1 | Drew Park | 18272 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 2.309 | Drew Park | ||
5953 | 5953 | 5952 | {"type": "Polygon", "coordinates": [[[-117.98326, 33.71135], [-117.98321, 33.71147], [-117.98321, 33.71163], [-117.98315, 33.71163], [-117.98313, 33.71136], [-117.98153, 33.71137], [-117.98152, 33.71034], [-117.98171, 33.71018], [-117.98172, 33.71], [-117.9822, 33.70999], [-117.98218, 33.71107], [-117.98231, 33.7112], [-117.98314, 33.71121], [-117.98326, 33.71135]]]} | Open Access 1 | Lake View Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/lake-view-park.cfm | 20967 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 2.641 | Lake View Park | |
8097 | 8097 | 8096 | {"type": "Polygon", "coordinates": [[[-117.98513, 33.6855], [-117.98491, 33.68534], [-117.98477, 33.68528], [-117.98462, 33.68524], [-117.98445, 33.68522], [-117.98444, 33.68423], [-117.98511, 33.68423], [-117.98513, 33.6855]]]} | Open Access 1 | Perry Park | 23613 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1.866 | Perry Park | ||
5024 | 5024 | 5023 | {"type": "Polygon", "coordinates": [[[-117.98565, 33.69303], [-117.98466, 33.69303], [-117.98465, 33.69223], [-117.98564, 33.69223], [-117.98565, 33.69303]]]} | Open Access 1 | Helme Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/helme-park.cfm | 19809 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 2.0 | Helme Park | |
1785 | 1785 | 1784 | {"type": "Polygon", "coordinates": [[[-117.98765, 33.67267], [-117.98687, 33.67386], [-117.98688, 33.67419], [-117.98733, 33.67419], [-117.98734, 33.67457], [-117.98688, 33.67459], [-117.9869, 33.67599], [-117.98641, 33.67682], [-117.98645, 33.67935], [-117.98583, 33.67934], [-117.98577, 33.6793], [-117.98576, 33.67902], [-117.98573, 33.67883], [-117.98566, 33.67864], [-117.98556, 33.67846], [-117.98544, 33.6783], [-117.98528, 33.67815], [-117.98511, 33.67802], [-117.98486, 33.67788], [-117.98473, 33.67777], [-117.98478, 33.67771], [-117.98439, 33.67729], [-117.98438, 33.67724], [-117.98457, 33.677], [-117.98469, 33.67675], [-117.98473, 33.67649], [-117.98472, 33.67606], [-117.98474, 33.6759], [-117.98479, 33.67575], [-117.98565, 33.67392], [-117.98579, 33.67354], [-117.98585, 33.67328], [-117.98588, 33.67301], [-117.98588, 33.67237], [-117.98765, 33.67236], [-117.98765, 33.67267]]]} | Open Access 1 | Bartlett Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/bartlett-park.cfm | 15843 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 27.767 | Bartlett Park | |
6586 | 6586 | 6585 | {"type": "Polygon", "coordinates": [[[-117.99377, 33.65964], [-117.99356, 33.65995], [-117.99356, 33.66027], [-117.99287, 33.66027], [-117.99283, 33.66025], [-117.9928, 33.66022], [-117.9927, 33.65989], [-117.99265, 33.65964], [-117.99263, 33.65932], [-117.99377, 33.65931], [-117.99377, 33.65964]]]} | Open Access 1 | Manning Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/manning-park.cfm | 21755 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 2.359 | Manning Park | |
10071 | 10071 | 10070 | {"type": "Polygon", "coordinates": [[[-117.9945, 33.72733], [-117.99329, 33.72734], [-117.99328, 33.72655], [-117.99449, 33.72654], [-117.9945, 33.72733]]]} | Open Access 1 | Sun View Park | 25982 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 2.452 | Sun View Park | ||
7600 | 7600 | 7599 | {"type": "Polygon", "coordinates": [[[-117.995, 33.71048], [-117.99414, 33.71048], [-117.99414, 33.71088], [-117.99374, 33.71091], [-117.99373, 33.71073], [-117.99349, 33.71073], [-117.99348, 33.71021], [-117.99499, 33.7102], [-117.995, 33.71048]]]} | Open Access 1 | Oak View Center Park | 23016 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1.634 | Oak View Ctr. Park | ||
6792 | 6792 | 6791 | {"type": "Polygon", "coordinates": [[[-117.99511, 33.67831], [-117.99421, 33.67831], [-117.99419, 33.6782], [-117.99413, 33.67821], [-117.99413, 33.67831], [-117.99318, 33.67832], [-117.99316, 33.67714], [-117.9951, 33.67712], [-117.99511, 33.67831]]]} | Open Access 1 | McCallen Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/mccallen-park.cfm | 21991 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 5.812 | McCallen Park | |
10295 | 10295 | 10294 | {"type": "Polygon", "coordinates": [[[-117.99549, 33.69851], [-117.99332, 33.69853], [-117.99331, 33.69754], [-117.99547, 33.69752], [-117.99549, 33.69851]]]} | Open Access 1 | Terry Park | 26268 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 5.44 | Terry Park | ||
13684 | 13684 | 13683 | {"type": "Polygon", "coordinates": [[[-117.99766, 33.65576], [-117.99763, 33.65581], [-117.99719, 33.65622], [-117.99604, 33.65577], [-117.99615, 33.65556], [-117.99634, 33.65525], [-117.99638, 33.65514], [-117.9971, 33.65543], [-117.99742, 33.65561], [-117.99766, 33.65576]]]} | Open Access 1 | Pacific City Park | 31173 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 2.338 | Pacific City Park | ||
13675 | 13675 | 13674 | {"type": "Polygon", "coordinates": [[[-117.99902, 33.7319], [-117.99897, 33.73195], [-117.99899, 33.73204], [-117.99897, 33.73206], [-117.99899, 33.73208], [-117.99891, 33.73212], [-117.99888, 33.7322], [-117.99871, 33.73219], [-117.99871, 33.73204], [-117.99868, 33.73203], [-117.99867, 33.73198], [-117.99867, 33.73192], [-117.99871, 33.7319], [-117.9987, 33.73161], [-117.99867, 33.73159], [-117.99867, 33.73152], [-117.99877, 33.73152], [-117.99879, 33.73154], [-117.99881, 33.73152], [-117.99888, 33.73152], [-117.99888, 33.73154], [-117.9989, 33.73155], [-117.99891, 33.73151], [-117.99896, 33.73151], [-117.99895, 33.73156], [-117.99898, 33.73158], [-117.99897, 33.7316], [-117.99898, 33.73161], [-117.99897, 33.73163], [-117.99898, 33.73165], [-117.99897, 33.73171], [-117.99899, 33.73171], [-117.99902, 33.73169], [-117.99897, 33.73175], [-117.99898, 33.73177], [-117.99897, 33.7319], [-117.99899, 33.73191], [-117.99902, 33.73188], [-117.99902, 33.7319]]]} | Open Access 1 | Boardwalk Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/boardwalk-park.cfm | 31163 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 0.465 | Boardwalk Park | |
13632 | 13632 | 13631 | {"type": "Polygon", "coordinates": [[[-117.9999, 33.66174], [-117.9991, 33.66252], [-117.99902, 33.66247], [-117.99902, 33.66178], [-117.99905, 33.66172], [-117.99913, 33.66169], [-117.9993, 33.66173], [-117.99953, 33.66176], [-117.99971, 33.66176], [-117.9999, 33.66174]]]} | Open Access 1 | Triangle Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/triangle-park.cfm | 31102 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 0.929 | Triangle Park | |
4720 | 4720 | 4719 | {"type": "Polygon", "coordinates": [[[-118.00009, 33.6893], [-117.99911, 33.69028], [-117.99831, 33.68971], [-117.99828, 33.68967], [-117.99828, 33.68963], [-117.9983, 33.6896], [-117.99894, 33.68897], [-117.99921, 33.68877], [-117.99957, 33.68859], [-118.00009, 33.6893]]]} | Open Access 1 | Green Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/green-park.cfm | 19465 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 3.998 | Green 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]);