superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
76 rows where ACCESS_TYP = 1 and MNG_AGENCY = 122 sorted by PARK_URL descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 76
MNG_AGENCY 1
- Huntington Beach, City of · 76 ✖
ACCESS_TYP 1
- Open Access · 76 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13686 | 13686 | 13685 | {"type": "Polygon", "coordinates": [[[-118.00466, 33.674], [-118.00464, 33.67403], [-118.00463, 33.67443], [-118.00345, 33.67443], [-118.00346, 33.6756], [-118.00191, 33.67561], [-118.00186, 33.6756], [-118.00182, 33.67556], [-118.00181, 33.67537], [-118.00191, 33.67526], [-118.00191, 33.67523], [-118.00381, 33.67339], [-118.00466, 33.674]]]} | Open Access 1 | Worthy Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/worthy-park.cfm | 31176 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 6.819 | Worthy Park | |
10462 | 10462 | 10461 | {"type": "Polygon", "coordinates": [[[-118.06599, 33.72644], [-118.06594, 33.72672], [-118.06559, 33.72665], [-118.06533, 33.72665], [-118.06529, 33.72668], [-118.06529, 33.72581], [-118.06531, 33.72576], [-118.06531, 33.72601], [-118.06556, 33.72602], [-118.06556, 33.72627], [-118.06565, 33.72631], [-118.06564, 33.72637], [-118.06569, 33.72645], [-118.06573, 33.72647], [-118.0658, 33.72648], [-118.06599, 33.72644]]]} | Open Access 1 | Trinidad Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/trinidad-park.cfm | 26539 | 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.725 | Trinidad 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 | |
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 | |
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 | |
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 | |
5627 | 5627 | 5626 | {"type": "Polygon", "coordinates": [[[-118.03256, 33.73135], [-118.03247, 33.73137], [-118.03249, 33.73247], [-118.03076, 33.73248], [-118.03071, 33.73028], [-118.03254, 33.73027], [-118.03256, 33.73135]]]} | Open Access 1 | Marina Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/marina-park.cfm | 21834 | 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.968 | Marina 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 | |
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 | |
13683 | 13683 | 13682 | {"type": "Polygon", "coordinates": [[[-117.95161, 33.68111], [-117.95086, 33.68111], [-117.95084, 33.67975], [-117.95159, 33.67974], [-117.95161, 33.68111]]]} | Open Access 1 | Lamb Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/lamb-park.cfm | 31172 | 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.598 | Lamb 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 | |
4875 | 4875 | 4874 | {"type": "Polygon", "coordinates": [[[-118.00068, 33.66868], [-118.00066, 33.66872], [-118.00061, 33.66874], [-118.00025, 33.6687], [-118.0, 33.66874], [-117.99983, 33.66879], [-117.99953, 33.66895], [-117.99934, 33.66902], [-117.99913, 33.66907], [-117.99893, 33.66909], [-117.99872, 33.66908], [-117.99851, 33.66905], [-117.99832, 33.66899], [-117.99805, 33.66886], [-117.99804, 33.66848], [-117.99819, 33.66832], [-117.99832, 33.66824], [-117.99846, 33.66819], [-117.99862, 33.66816], [-117.99885, 33.66818], [-117.99927, 33.66828], [-117.99968, 33.66832], [-118.00008, 33.66831], [-118.00047, 33.66825], [-118.00052, 33.66829], [-118.00068, 33.66868]]]} | Open Access 1 | Lake Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/lake-park.cfm | 20959 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 4.226 | Lake 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 | |
5361 | 5361 | 5360 | {"type": "Polygon", "coordinates": [[[-118.01263, 33.71971], [-118.01231, 33.71972], [-118.01231, 33.72001], [-118.01191, 33.72013], [-118.01101, 33.72094], [-118.01101, 33.72111], [-118.01069, 33.72111], [-118.01061, 33.72103], [-118.0105, 33.721], [-118.01034, 33.72103], [-118.01015, 33.72103], [-118.01013, 33.71961], [-118.01032, 33.71961], [-118.01048, 33.71963], [-118.01059, 33.7196], [-118.01065, 33.71966], [-118.01098, 33.71964], [-118.01097, 33.71843], [-118.01262, 33.71842], [-118.01263, 33.71971]]]} | Open Access 1 | Irby Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/irby-park.cfm | 20228 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 10.818 | Irby Park | |
12238 | 12238 | 12237 | {"type": "MultiPolygon", "coordinates": [[[[-118.00637, 33.70704], [-118.00631, 33.70706], [-118.00632, 33.70813], [-118.00629, 33.70817], [-118.00622, 33.7082], [-118.00432, 33.70821], [-118.00429, 33.70711], [-118.00008, 33.70717], [-118.00006, 33.70581], [-118.0, 33.70579], [-117.99998, 33.70472], [-118.00005, 33.7047], [-118.00004, 33.70396], [-118.0008, 33.70395], [-118.00129, 33.70372], [-118.00219, 33.70361], [-118.00216, 33.70308], [-118.00194, 33.7031], [-118.00167, 33.70337], [-118.00136, 33.70337], [-118.00136, 33.70258], [-118.00183, 33.70256], [-118.00181, 33.70184], [-118.00233, 33.70183], [-118.00232, 33.70108], [-118.0, 33.70109], [-117.99999, 33.70102], [-117.99993, 33.70101], [-117.99991, 33.69928], [-118.00249, 33.69925], [-118.00246, 33.69747], [-118.00199, 33.69746], [-118.00194, 33.69392], [-118.00332, 33.6939], [-118.00334, 33.69393], [-118.00342, 33.69393], [-118.00343, 33.6939], [-118.00618, 33.69387], [-118.0062, 33.69471], [-118.00613, 33.69473], [-118.00615, 33.69559], [-118.00621, 33.69561], [-118.00625, 33.69833], [-118.00618, 33.69835], [-118.00629, 33.7058], [-118.00635, 33.70582], [-118.00637, 33.70704]], [[-118.00621, 33.70812], [-118.00622, 33.7081], [-118.0062, 33.70738], [-118.00561, 33.70738], [-118.0054, 33.70756], [-118.00541, 33.70812], [-118.00621, 33.70812]]], [[[-118.01501, 33.69733], [-118.01496, 33.69735], [-118.01498, 33.69916], [-118.01287, 33.69918], [-118.01286, 33.69895], [-118.01285, 33.69894], [-118.01201, 33.69947], [-118.01143, 33.69976], [-118.01072, 33.70021], [-118.01077, 33.70465], [-118.0066, 33.70468], [-118.00647, 33.69562], [-118.00641, 33.69561], [-118.00639, 33.6947], [-118.00646, 33.69468], [-118.00645, 33.69399], [-118.00648, 33.69392], [-118.00655, 33.6939], [-118.00843, 33.69388], [-118.00845, 33.69382], [-118.01044, 33.6938], [-118.01045, 33.6944], [-118.01051, 33.69442], [-118.01052, 33.6938], [-118.01269, 33.69378], [-118.0127, 33.6944], [-118.01173, 33.69441], [-118.01172, 33.6945], [-118.01173, 33.69451], [-118.0127, 33.69451], [-118.01271, 33.69512], [-118.01174, 33.69513], [-118.01173, 33.69522], [-118.01174, 33.69523], [-118.01271, 33.69523], [-118.01272, 33.69585], [-118.01175, 33.69586], [-118.01174, 33.69595], [-118.01175, 33.69596], [-118.01272, 33.69596], [-118.01273, 33.69657], [-118.01175, 33.69659], [-118.01174, 33.6966], [-118.01176, 33.69669], [-118.01273, 33.69668], [-118.01274, 33.6973], [-118.01177, 33.69731], [-118.01176, 33.69734], [-118.01283, 33.69735], [-118.01284, 33.69734], [-118.01279, 33.69378], [-118.01387, 33.69377], [-118.01389, 33.6938], [-118.01496, 33.69379], [-118.01501, 33.69733]], [[-118.01053, 33.69556], [-118.01054, 33.69527], [-118.01039, 33.69526], [-118.01038, 33.69555], [-118.01053, 33.69556]], [[-118.01046, 33.69513], [-118.01054, 33.69513], [-118.01052, 33.69453], [-118.01045, 33.69454], [-118.01046, 33.69513]]]]} | Open Access 1 | Huntington Beach Central Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/huntington_central_park/ | 29219 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 345.35 | Huntington Beach Central Park | |
13681 | 13681 | 13680 | {"type": "Polygon", "coordinates": [[[-118.05687, 33.72512], [-118.05686, 33.72528], [-118.05681, 33.72534], [-118.05676, 33.72538], [-118.05667, 33.72539], [-118.0562, 33.7254], [-118.0562, 33.72512], [-118.05687, 33.72512]]]} | Open Access 1 | Humboldt Beach | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/humboldt-beach.cfm | 31169 | 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.446 | Humboldt Beach | |
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 |
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]);