superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
76 rows where MNG_AGENCY = 122 and MNG_AG_TYP = 2 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10231 | 10231 | 10230 | {"type": "Polygon", "coordinates": [[[-118.06762, 33.72106], [-118.06761, 33.7211], [-118.06754, 33.72114], [-118.06743, 33.72114], [-118.06703, 33.72096], [-118.06732, 33.72058], [-118.06761, 33.721], [-118.06762, 33.72106]]]} | Open Access 1 | Tarbox Park | 26189 | 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.434 | Tarbox Park | ||
10213 | 10213 | 10212 | {"type": "Polygon", "coordinates": [[[-117.97129, 33.68368], [-117.96722, 33.68371], [-117.96721, 33.68335], [-117.96727, 33.68316], [-117.97128, 33.68313], [-117.97129, 33.68368]]]} | Open Access 1 | Talbert Park | 26172 | 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.665 | Talbert 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 | ||
9843 | 9843 | 9842 | {"type": "Polygon", "coordinates": [[[-117.96654, 33.66494], [-117.96582, 33.66494], [-117.9658, 33.66366], [-117.96652, 33.66365], [-117.96654, 33.66494]]]} | Open Access 1 | Sowers Park | 25709 | 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.358 | Sowers Park | ||
9485 | 9485 | 9484 | {"type": "Polygon", "coordinates": [[[-117.95873, 33.64693], [-117.95787, 33.64693], [-117.95785, 33.64543], [-117.95811, 33.64541], [-117.95837, 33.64536], [-117.9587, 33.64535], [-117.95873, 33.64693]]]} | Open Access 1 | Seeley Park | 25283 | 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.37 | Seeley Park | ||
9429 | 9429 | 9428 | {"type": "Polygon", "coordinates": [[[-118.07235, 33.72659], [-118.07228, 33.72661], [-118.07221, 33.72666], [-118.0722, 33.72671], [-118.07221, 33.72677], [-118.07183, 33.72757], [-118.07183, 33.72762], [-118.07179, 33.72768], [-118.07173, 33.72773], [-118.07178, 33.7276], [-118.07151, 33.72691], [-118.07117, 33.72671], [-118.07101, 33.72674], [-118.07094, 33.72682], [-118.07049, 33.72655], [-118.07125, 33.72566], [-118.07173, 33.72594], [-118.07178, 33.72604], [-118.07184, 33.72612], [-118.07174, 33.72631], [-118.07235, 33.72659]]]} | Open Access 1 | Sea Bridge Park | 25230 | 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.719 | Sea Bridge Park | ||
9364 | 9364 | 9363 | {"type": "Polygon", "coordinates": [[[-118.0208, 33.74187], [-118.01992, 33.74188], [-118.01991, 33.7408], [-118.02002, 33.74079], [-118.02027, 33.74075], [-118.02078, 33.74074], [-118.0208, 33.74187]]]} | Open Access 1 | Schroeder Park | 25194 | 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.482 | Schroeder Park | ||
8838 | 8838 | 8837 | {"type": "Polygon", "coordinates": [[[-118.0394, 33.73704], [-118.03823, 33.73704], [-118.03823, 33.73653], [-118.03938, 33.73653], [-118.0394, 33.73704]]]} | Open Access 1 | Robinwood Park | 24503 | 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.509 | Robinwood Park | ||
8414 | 8414 | 8413 | {"type": "Polygon", "coordinates": [[[-118.07112, 33.7252], [-118.07073, 33.72527], [-118.07071, 33.72521], [-118.07066, 33.72516], [-118.07086, 33.72496], [-118.07101, 33.72503], [-118.07104, 33.72505], [-118.07109, 33.72512], [-118.07112, 33.7252]]]} | Open Access 1 | Prince Park | 24007 | 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.218 | Prince Park | ||
8252 | 8252 | 8251 | {"type": "Polygon", "coordinates": [[[-117.97577, 33.72084], [-117.97412, 33.72085], [-117.9741, 33.72107], [-117.97401, 33.72112], [-117.97398, 33.72121], [-117.97382, 33.72105], [-117.97371, 33.72092], [-117.97358, 33.72067], [-117.97355, 33.72054], [-117.97409, 33.72051], [-117.97576, 33.72048], [-117.97577, 33.72084]]]} | Open Access 1 | Pleasant View Park | 23803 | 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.119 | Pleasant 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 | ||
8021 | 8021 | 8020 | {"type": "Polygon", "coordinates": [[[-118.02386, 33.6759], [-118.02378, 33.67597], [-118.02352, 33.67582], [-118.02325, 33.67569], [-118.02296, 33.67559], [-118.02266, 33.67551], [-118.0222, 33.67543], [-118.02146, 33.67538], [-118.02104, 33.67529], [-118.02199, 33.6744], [-118.02268, 33.67491], [-118.02265, 33.67497], [-118.02386, 33.6759]]]} | Open Access 1 | Pattinson Park | 23522 | 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.495 | Pattinson 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 | ||
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 | |
7287 | 7287 | 7286 | {"type": "Polygon", "coordinates": [[[-118.00654, 33.71912], [-118.00228, 33.71915], [-118.00227, 33.71766], [-118.00652, 33.71763], [-118.00654, 33.71912]]]} | Open Access 1 | Murdy Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/murdy-park.cfm | 22603 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 16.177 | Murdy 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 | |
6673 | 6673 | 6672 | {"type": "Polygon", "coordinates": [[[-118.03115, 33.70861], [-118.03105, 33.70865], [-118.03101, 33.70868], [-118.03099, 33.70875], [-118.03106, 33.70892], [-118.03108, 33.71], [-118.03053, 33.71023], [-118.03055, 33.71007], [-118.03063, 33.71004], [-118.03064, 33.70999], [-118.03061, 33.70997], [-118.03061, 33.70938], [-118.02998, 33.70937], [-118.03022, 33.70912], [-118.0304, 33.70888], [-118.03046, 33.70877], [-118.03048, 33.70864], [-118.03046, 33.70855], [-118.0304, 33.70847], [-118.03033, 33.70841], [-118.03032, 33.70837], [-118.03115, 33.70837], [-118.03115, 33.70861]]]} | Open Access 1 | Marine View Park | 21850 | 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.8 | Marine View 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 | |
6070 | 6070 | 6069 | {"type": "Polygon", "coordinates": [[[-117.95262, 33.66614], [-117.95257, 33.66614], [-117.95255, 33.66584], [-117.95215, 33.66586], [-117.95156, 33.66593], [-117.95157, 33.66564], [-117.95152, 33.66493], [-117.95073, 33.66492], [-117.95046, 33.66512], [-117.95042, 33.66523], [-117.95031, 33.66523], [-117.95021, 33.66515], [-117.9502, 33.66567], [-117.95018, 33.6656], [-117.95014, 33.66553], [-117.95007, 33.66548], [-117.94998, 33.66546], [-117.94957, 33.66546], [-117.94934, 33.66543], [-117.94923, 33.66546], [-117.94917, 33.6655], [-117.94902, 33.66545], [-117.94885, 33.66541], [-117.94914, 33.6644], [-117.94963, 33.66441], [-117.94975, 33.66446], [-117.95007, 33.66446], [-117.95009, 33.66439], [-117.9526, 33.66437], [-117.95262, 33.66614]]]} | Open Access 1 | LeBard Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/lebard-park.cfm | 21126 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 9.405 | LeBard Park | |
5985 | 5985 | 5984 | {"type": "Polygon", "coordinates": [[[-118.01959, 33.71377], [-118.01947, 33.71376], [-118.01937, 33.71373], [-118.01911, 33.71353], [-118.01894, 33.71347], [-118.01878, 33.71345], [-118.01873, 33.7134], [-118.01872, 33.71317], [-118.01876, 33.713], [-118.01873, 33.7129], [-118.01883, 33.71281], [-118.01883, 33.71227], [-118.01904, 33.7123], [-118.01916, 33.71225], [-118.01922, 33.71218], [-118.01956, 33.71218], [-118.01959, 33.71377]]]} | Open Access 1 | Lark View Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/lark-view-park.cfm | 21028 | 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.75 | Lark View 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]);