superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
76 rows where MNG_AGENCY = 122
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 61
MNG_AGENCY 1
- Huntington Beach, City of · 61 ✖
ACCESS_TYP 1
- Open Access 61
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | |
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 | |
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 | |
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 | |
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 | |
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 | ||
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 | ||
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 | |
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 | |
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 | |
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 |
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]);