superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
76 rows where MNG_AGENCY = 122 sorted by PARK_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3763 | 3763 | 3762 | {"type": "Polygon", "coordinates": [[[-117.96625, 33.64478], [-117.96566, 33.64478], [-117.96564, 33.64375], [-117.96508, 33.64374], [-117.96508, 33.64337], [-117.96624, 33.64336], [-117.96625, 33.64478]]]} | Open Access 1 | Eader Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/eader-park.cfm | 18334 | 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.686 | Eader Park | |
13677 | 13677 | 13676 | {"type": "MultiPolygon", "coordinates": [[[[-117.97078, 33.65111], [-117.96703, 33.65113], [-117.96703, 33.65064], [-117.97069, 33.65061], [-117.97075, 33.65064], [-117.97077, 33.65069], [-117.97078, 33.65111]]], [[[-117.97752, 33.65107], [-117.97529, 33.65108], [-117.97531, 33.65291], [-117.97363, 33.65292], [-117.97364, 33.65408], [-117.97108, 33.6541], [-117.97104, 33.65111], [-117.97111, 33.65109], [-117.9711, 33.65068], [-117.97112, 33.65065], [-117.97116, 33.65062], [-117.97751, 33.65057], [-117.97752, 33.65107]]]]} | Open Access 1 | Edison Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/edison-park.cfm | 31166 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 40.009 | Edison Park | |
13679 | 13679 | 13678 | {"type": "MultiPolygon", "coordinates": [[[[-118.00137, 33.66846], [-118.00123, 33.66851], [-118.00109, 33.66854], [-118.00094, 33.66855], [-118.0009, 33.66854], [-118.00066, 33.668], [-118.00113, 33.66787], [-118.00137, 33.66846]]], [[[-118.0015, 33.66736], [-118.00154, 33.66739], [-118.0017, 33.66763], [-118.00178, 33.66769], [-118.00192, 33.66772], [-118.00207, 33.6677], [-118.00218, 33.66772], [-118.00232, 33.66779], [-118.00238, 33.66786], [-118.00242, 33.66795], [-118.00241, 33.66808], [-118.00236, 33.66816], [-118.00229, 33.66823], [-118.00219, 33.66827], [-118.00209, 33.66829], [-118.00185, 33.66824], [-118.00172, 33.66825], [-118.00163, 33.66829], [-118.00141, 33.66844], [-118.00107, 33.6676], [-118.00128, 33.66748], [-118.00145, 33.66737], [-118.0015, 33.66736]]]]} | Open Access 1 | Farquhar Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/farquhar-park.cfm | 31167 | 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.802 | Farquhar Park | |
4227 | 4227 | 4226 | {"type": "Polygon", "coordinates": [[[-118.01016, 33.68053], [-118.00996, 33.68077], [-118.0093, 33.6804], [-118.00927, 33.68037], [-118.00927, 33.68033], [-118.00937, 33.68019], [-118.00941, 33.68017], [-118.00946, 33.68017], [-118.00976, 33.68034], [-118.00983, 33.68045], [-118.00989, 33.68049], [-118.00996, 33.6805], [-118.01005, 33.68047], [-118.01016, 33.68053]]]} | Open Access 1 | Finley Park | 18905 | 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.557 | Finley Park | ||
4383 | 4383 | 4382 | {"type": "Polygon", "coordinates": [[[-118.02866, 33.75342], [-118.02769, 33.75342], [-118.02749, 33.75337], [-118.02741, 33.7534], [-118.02734, 33.75347], [-118.02707, 33.7534], [-118.02705, 33.75282], [-118.02729, 33.75282], [-118.02737, 33.75286], [-118.02739, 33.75291], [-118.02741, 33.75315], [-118.02825, 33.75314], [-118.02841, 33.75306], [-118.02866, 33.75306], [-118.02866, 33.75342]]]} | Open Access 1 | Franklin Park | 19062 | 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.452 | Franklin Park | ||
13680 | 13680 | 13679 | {"type": "Polygon", "coordinates": [[[-118.06802, 33.72364], [-118.06785, 33.7239], [-118.06769, 33.72381], [-118.06745, 33.72369], [-118.06762, 33.72346], [-118.06802, 33.72364]]]} | Open Access 1 | French Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/french-park.cfm | 31168 | 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.334 | French Park | |
4559 | 4559 | 4558 | {"type": "Polygon", "coordinates": [[[-118.036, 33.71978], [-118.0359, 33.71996], [-118.03581, 33.72025], [-118.03579, 33.72045], [-118.03583, 33.72074], [-118.0358, 33.72076], [-118.03539, 33.72084], [-118.0353, 33.72088], [-118.03522, 33.7208], [-118.03495, 33.7208], [-118.03493, 33.72083], [-118.03282, 33.72084], [-118.0328, 33.72002], [-118.0349, 33.72], [-118.03491, 33.71978], [-118.036, 33.71978]]]} | Open Access 1 | Gibbs Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/gibbs-park.cfm | 19289 | 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.858 | Gibbs Park | |
4573 | 4573 | 4572 | {"type": "Polygon", "coordinates": [[[-117.96216, 33.65367], [-117.96217, 33.65436], [-117.96215, 33.6544], [-117.9621, 33.65444], [-117.96168, 33.65444], [-117.96166, 33.65417], [-117.95798, 33.65419], [-117.95797, 33.65472], [-117.95756, 33.65473], [-117.95755, 33.65454], [-117.95718, 33.65454], [-117.95716, 33.65419], [-117.95382, 33.65421], [-117.95382, 33.65372], [-117.96216, 33.65367]]]} | Open Access 1 | Gisler Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/gisler-park.cfm | 19304 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 11.754 | Gisler Park | |
4592 | 4592 | 4591 | {"type": "Polygon", "coordinates": [[[-118.01213, 33.73489], [-118.01191, 33.73503], [-118.01177, 33.73516], [-118.0117, 33.73525], [-118.01163, 33.7355], [-118.01163, 33.73585], [-118.01122, 33.73585], [-118.01119, 33.73402], [-118.01212, 33.73402], [-118.01213, 33.73489]]]} | Open Access 1 | Glen View Park | 19325 | 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.31 | Glen View Park | ||
4641 | 4641 | 4640 | {"type": "Polygon", "coordinates": [[[-118.01306, 33.71283], [-118.0119, 33.71284], [-118.01185, 33.71282], [-118.01182, 33.7128], [-118.0118, 33.71276], [-118.01179, 33.71217], [-118.01174, 33.71208], [-118.01164, 33.71202], [-118.0118, 33.71188], [-118.01231, 33.71188], [-118.01233, 33.71203], [-118.01263, 33.71203], [-118.01265, 33.71208], [-118.01305, 33.71207], [-118.01306, 33.71283]]]} | Open Access 1 | Golden View Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/golden-view-park.cfm | 19374 | 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 | Golden View 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 | |
4713 | 4713 | 4712 | {"type": "MultiPolygon", "coordinates": [[[[-118.00915, 33.73873], [-118.00872, 33.73874], [-118.00873, 33.73936], [-118.00767, 33.73936], [-118.00765, 33.73733], [-118.00913, 33.73732], [-118.00915, 33.73873]]], [[[-118.00929, 33.73713], [-118.00927, 33.73717], [-118.00918, 33.73721], [-118.00791, 33.73722], [-118.00788, 33.7356], [-118.00795, 33.7356], [-118.00796, 33.73588], [-118.00906, 33.73604], [-118.00909, 33.73631], [-118.00927, 33.73696], [-118.00929, 33.73713]]]]} | Open Access 1 | Greer Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/greer-park.cfm | 19494 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 11.095 | Greer Park | |
4897 | 4897 | 4896 | {"type": "Polygon", "coordinates": [[[-118.05443, 33.72234], [-118.0544, 33.72239], [-118.05436, 33.72241], [-118.05417, 33.72241], [-118.05415, 33.72158], [-118.05339, 33.72158], [-118.05338, 33.72109], [-118.05364, 33.72107], [-118.05364, 33.7207], [-118.05357, 33.72068], [-118.05357, 33.72042], [-118.05361, 33.72031], [-118.05367, 33.72022], [-118.05376, 33.72014], [-118.054, 33.72003], [-118.05407, 33.72006], [-118.05425, 33.7205], [-118.05433, 33.72078], [-118.05441, 33.72126], [-118.05443, 33.72234]]]} | Open Access 1 | Harbour View Park | 19671 | 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.415 | Harbour View Park | ||
4969 | 4969 | 4968 | {"type": "Polygon", "coordinates": [[[-118.04595, 33.72971], [-118.04398, 33.72972], [-118.04391, 33.72969], [-118.0439, 33.72907], [-118.04415, 33.72895], [-118.04415, 33.72858], [-118.04461, 33.72858], [-118.04463, 33.72874], [-118.0448, 33.72873], [-118.04482, 33.72859], [-118.0449, 33.72859], [-118.04491, 33.72892], [-118.04501, 33.72893], [-118.04503, 33.72962], [-118.04595, 33.72962], [-118.04595, 33.72971]]]} | Open Access 1 | Haven View Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/haven-view-park.cfm | 19741 | 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.97 | Haven View Park | |
4970 | 4970 | 4969 | {"type": "Polygon", "coordinates": [[[-117.95893, 33.66789], [-117.95781, 33.6679], [-117.9578, 33.66708], [-117.95781, 33.66704], [-117.95787, 33.66701], [-117.95834, 33.66699], [-117.95844, 33.66703], [-117.95854, 33.66704], [-117.95857, 33.66703], [-117.95862, 33.66698], [-117.95864, 33.66689], [-117.95891, 33.66689], [-117.95893, 33.66789]]]} | Open Access 1 | Hawes Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/hawes-park.cfm | 19742 | 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 | Hawes 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 | |
5251 | 5251 | 5250 | {"type": "Polygon", "coordinates": [[[-118.01718, 33.70818], [-118.01661, 33.70819], [-118.01657, 33.70552], [-118.01715, 33.70552], [-118.01718, 33.70818]]]} | Open Access 1 | Hope View Park | 20087 | 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.923 | Hope View 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 | |
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 | |
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 |
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]);