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 36
MNG_AGENCY 1
- Huntington Beach, City of · 36 ✖
ACCESS_TYP 1
- Open Access 36
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
13717 | 13717 | 13716 | {"type": "Polygon", "coordinates": [[[-118.00553, 33.69197], [-118.00522, 33.69204], [-118.0051, 33.69221], [-118.00496, 33.6923], [-118.00474, 33.6925], [-118.00449, 33.69287], [-118.00436, 33.69293], [-118.00422, 33.69294], [-118.00412, 33.6932], [-118.00388, 33.69321], [-118.0038, 33.69323], [-118.00374, 33.69328], [-118.0037, 33.69333], [-118.00368, 33.69339], [-118.00368, 33.6936], [-118.00365, 33.69366], [-118.0036, 33.69368], [-118.00305, 33.69368], [-118.00293, 33.69366], [-118.00201, 33.69367], [-118.0019, 33.6937], [-118.00142, 33.69369], [-118.00139, 33.69366], [-118.00138, 33.69363], [-118.0014, 33.6936], [-118.00144, 33.69359], [-118.00163, 33.69365], [-118.00221, 33.69361], [-118.00226, 33.69348], [-118.00225, 33.69345], [-118.00223, 33.69341], [-118.00215, 33.69336], [-118.00197, 33.69328], [-118.00189, 33.69319], [-118.00176, 33.69316], [-118.00162, 33.69315], [-118.00159, 33.69313], [-118.00154, 33.693], [-118.00146, 33.69292], [-118.00143, 33.69284], [-118.00143, 33.69281], [-118.0014, 33.69276], [-118.00127, 33.69269], [-118.00111, 33.69265], [-118.0011, 33.69262], [-118.0009, 33.69256], [-118.00079, 33.69247], [-118.00074, 33.69245], [-118.00087, 33.69223], [-118.00102, 33.69202], [-118.0014, 33.69161], [-118.00158, 33.69149], [-118.00173, 33.69144], [-118.00188, 33.69142], [-118.00203, 33.69143], [-118.00218, 33.69146], [-118.00275, 33.69169], [-118.00263, 33.69192], [-118.0028, 33.69202], [-118.00288, 33.6921], [-118.00312, 33.69247], [-118.00321, 33.69254], [-118.00333, 33.69259], [-118.00348, 33.69263], [-118.00363, 33.69262], [-118.00374, 33.69258], [-118.00389, 33.69247], [-118.00395, 33.69237], [-118.00415, 33.69222], [-118.00431, 33.69195], [-118.00437, 33.69188], [-118.00451, 33.69164], [-118.00471, 33.69156], [-118.00492, 33.69131], [-118.00528, 33.69134], [-118.00548, 33.69141], [-118.0055, 33.69144], [-118.00551, 33.69156], [-118.00553, 33.69197]]]} | Open Access 1 | Baca Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/baca-park.cfm | 31214 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 14.568 | Baca 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 | |
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 | ||
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 | ||
3101 | 3101 | 3100 | {"type": "Polygon", "coordinates": [[[-118.01229, 33.72641], [-118.0119, 33.72641], [-118.01192, 33.72613], [-118.0119, 33.72607], [-118.01186, 33.72601], [-118.0118, 33.72598], [-118.01173, 33.72596], [-118.01142, 33.72599], [-118.01138, 33.72597], [-118.01136, 33.72594], [-118.01136, 33.72567], [-118.01141, 33.72551], [-118.01146, 33.72541], [-118.01169, 33.72513], [-118.01177, 33.72497], [-118.01181, 33.72481], [-118.01186, 33.72477], [-118.01215, 33.72476], [-118.01215, 33.72503], [-118.01227, 33.72504], [-118.01229, 33.72641]]]} | Open Access 1 | College View Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/college-view-park.cfm | 17515 | 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.594 | College View 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 | |
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 | |
1722 | 1722 | 1721 | {"type": "Polygon", "coordinates": [[[-118.01411, 33.67395], [-118.01404, 33.67436], [-118.01368, 33.67446], [-118.0136, 33.67444], [-118.01358, 33.67441], [-118.01358, 33.67436], [-118.01364, 33.67399], [-118.01366, 33.67398], [-118.0137, 33.67394], [-118.01374, 33.67393], [-118.01411, 33.67395]]]} | Open Access 1 | Bailey Park | 15760 | 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.556 | Bailey 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 | ||
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 | |
2186 | 2186 | 2185 | {"type": "Polygon", "coordinates": [[[-118.02066, 33.73424], [-118.01946, 33.73425], [-118.01943, 33.73321], [-118.01956, 33.73328], [-118.01967, 33.73337], [-118.01981, 33.73345], [-118.01994, 33.73349], [-118.02008, 33.7335], [-118.02022, 33.7336], [-118.02065, 33.73362], [-118.02066, 33.73424]]]} | Open Access 1 | Circle View Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/circle-view-park.cfm | 17267 | 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.314 | Circle View 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 | ||
2349 | 2349 | 2348 | {"type": "Polygon", "coordinates": [[[-118.02235, 33.74789], [-118.02102, 33.74789], [-118.02099, 33.74694], [-118.02233, 33.74691], [-118.02235, 33.74789]]]} | Open Access 1 | Clegg-Stacey Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/clegg-stacey-park.cfm | 17418 | 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.253 | Clegg-Stacey 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 | ||
2658 | 2658 | 2657 | {"type": "Polygon", "coordinates": [[[-118.02397, 33.72238], [-118.02391, 33.72239], [-118.02391, 33.72252], [-118.02388, 33.72257], [-118.02382, 33.72259], [-118.02366, 33.7226], [-118.02365, 33.72265], [-118.0219, 33.72266], [-118.02187, 33.72052], [-118.02394, 33.72051], [-118.02397, 33.72238]]]} | Open Access 1 | Carr Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/carr-park.cfm | 16906 | 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.206 | Carr 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 | ||
2129 | 2129 | 2128 | {"type": "Polygon", "coordinates": [[[-118.03039, 33.70438], [-118.03038, 33.70442], [-118.03025, 33.70461], [-118.02969, 33.7044], [-118.02812, 33.70442], [-118.02812, 33.70402], [-118.02845, 33.70383], [-118.02854, 33.7039], [-118.02861, 33.70391], [-118.02886, 33.70387], [-118.02912, 33.70387], [-118.02928, 33.70388], [-118.0297, 33.70398], [-118.02989, 33.70405], [-118.03025, 33.70426], [-118.03039, 33.70438]]]} | Open Access 1 | Bolsa View Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/bolsa-view-park.cfm | 16249 | 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.675 | Bolsa View 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 |
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]);