units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
74 rows where DES_TP = 2 and MNG_AGENCY = 122 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 74
MNG_AGENCY 1
- Huntington Beach, City of · 74 ✖
DES_TP 1
- Local Park · 74 ✖
AGNCY_TYP 1 ✖
- City Agency 74
ACCESS_TYP 1
- Open Access 74
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL ▼ | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
305 | 305 | 304 | {"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 | 1042 | Glen View Park | 19325 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 3.31 | Glen View Park | 0 | Local Park 2 | 4 | |
386 | 386 | 385 | {"type": "Polygon", "coordinates": [[[-118.05417, 33.72241], [-118.05416, 33.72158], [-118.05339, 33.72158], [-118.05338, 33.72109], [-118.05364, 33.72108], [-118.05364, 33.72069], [-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], [-118.0544, 33.72239], [-118.05436, 33.72241], [-118.05417, 33.72241]]]} | Open Access 1 | 1408 | Harbour View Park | 19671 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 3.406 | Harbour View Park | 0 | Local Park 2 | 4 | |
580 | 580 | 579 | {"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 | 1928 | Hope View Park | 20087 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 3.924 | Hope View Park | 0 | Local Park 2 | 4 | |
787 | 787 | 786 | {"type": "Polygon", "coordinates": [[[-118.03115, 33.70861], [-118.03105, 33.70865], [-118.03101, 33.70868], [-118.03099, 33.70875], [-118.031, 33.7088], [-118.03105, 33.70887], [-118.03106, 33.70892], [-118.03108, 33.71], [-118.03053, 33.71023], [-118.03055, 33.71007], [-118.03063, 33.71005], [-118.03064, 33.70998], [-118.03061, 33.70997], [-118.03061, 33.70937], [-118.02998, 33.70937], [-118.03022, 33.70912], [-118.03041, 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 | 5126 | Marine View Park | 21850 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 2.794 | Marine View Park | 0 | Local Park 2 | 4 | |
1029 | 1029 | 1028 | {"type": "Polygon", "coordinates": [[[-118.02866, 33.75342], [-118.02769, 33.75342], [-118.02749, 33.75337], [-118.02741, 33.75339], [-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 | 5645 | Franklin Park | 19062 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 1.45 | Franklin Park | 0 | Local Park 2 | 4 | |
1367 | 1367 | 1366 | {"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 | 11881 | Schroeder Park | 25194 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 2.483 | Schroeder Park | 0 | Local Park 2 | 4 | |
1396 | 1396 | 1395 | {"type": "Polygon", "coordinates": [[[-117.97577, 33.72084], [-117.97411, 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 | 8637 | Pleasant View Park | 23803 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 2.117 | Pleasant View Park | 0 | Local Park 2 | 4 | |
2217 | 2217 | 2216 | {"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 | 6134 | Oak View Center Park | 23016 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 1.629 | Oak View Ctr. Park | 0 | Local Park 2 | 4 | |
4087 | 4087 | 4086 | {"type": "Polygon", "coordinates": [[[-117.99766, 33.65576], [-117.99763, 33.65581], [-117.99719, 33.65622], [-117.99604, 33.65577], [-117.99615, 33.65556], [-117.99634, 33.65525], [-117.99638, 33.65514], [-117.9971, 33.65543], [-117.99742, 33.65561], [-117.99766, 33.65576]]]} | Open Access 1 | 47461 | Pacific City Park | 31173 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 2.339 | Pacific City Park | 0 | Local Park 2 | 4 | |
4942 | 4942 | 4941 | {"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 | 14652 | Talbert Park | 26172 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 5.669 | Talbert Park | 0 | Local Park 2 | 4 | |
6943 | 6943 | 6942 | {"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 | 5846 | Sowers Park | 25709 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 2.359 | Sowers Park | 0 | Local Park 2 | 4 | |
7594 | 7594 | 7593 | {"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 | 12172 | Seeley Park | 25283 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 3.371 | Seeley Park | 0 | Local Park 2 | 4 | |
7760 | 7760 | 7759 | {"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 | 8350 | Perry Park | 23613 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 1.867 | Perry Park | 0 | Local Park 2 | 4 | |
7906 | 7906 | 7905 | {"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 | 10219 | Robinwood Park | 24503 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 1.51 | Robinwood Park | 0 | Local Park 2 | 4 | |
8078 | 8078 | 8077 | {"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.72605], [-118.07184, 33.72612], [-118.07173, 33.7263], [-118.07235, 33.72659]]]} | Open Access 1 | 12030 | Sea Bridge Park | 25230 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 3.714 | Sea Bridge Park | 0 | Local Park 2 | 4 | |
9142 | 9142 | 9141 | {"type": "Polygon", "coordinates": [[[-117.97119, 33.6764], [-117.96917, 33.67642], [-117.96916, 33.67593], [-117.96888, 33.67593], [-117.96889, 33.67476], [-117.971, 33.67475], [-117.97107, 33.67477], [-117.9711, 33.67483], [-117.97112, 33.67587], [-117.97118, 33.67587], [-117.97119, 33.6764]]]} | Open Access 1 | 15170 | Wardlow Park | 27257 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 9.111 | Wardlow Park | 0 | Local Park 2 | 4 | |
9229 | 9229 | 9228 | {"type": "Polygon", "coordinates": [[[-118.04582, 33.72101], [-118.04437, 33.72102], [-118.04437, 33.72077], [-118.04473, 33.72076], [-118.0447, 33.71915], [-118.04538, 33.71915], [-118.04538, 33.71928], [-118.04546, 33.71928], [-118.04547, 33.71941], [-118.04571, 33.71942], [-118.04573, 33.72075], [-118.04581, 33.72076], [-118.04582, 33.72101]]]} | Open Access 1 | 15350 | Wieder Park | 27488 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 4.82 | Wieder Park | 0 | Local Park 2 | 4 | |
10561 | 10561 | 10560 | {"type": "Polygon", "coordinates": [[[-117.98267, 33.6682], [-117.98263, 33.66821], [-117.98258, 33.66825], [-117.98254, 33.66832], [-117.98253, 33.66844], [-117.98254, 33.66877], [-117.98249, 33.66881], [-117.9816, 33.66881], [-117.98159, 33.66789], [-117.98266, 33.66788], [-117.98266, 33.66818], [-117.98267, 33.6682]]]} | Open Access 1 | 18795 | Drew Park | 18272 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 2.309 | Drew Park | 0 | Local Park 2 | 4 | |
10654 | 10654 | 10653 | {"type": "Polygon", "coordinates": [[[-117.99549, 33.69851], [-117.99332, 33.69853], [-117.99331, 33.69754], [-117.99547, 33.69752], [-117.99549, 33.69851]]]} | Open Access 1 | 18996 | Terry Park | 26268 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 5.442 | Terry Park | 0 | Local Park 2 | 4 | |
10659 | 10659 | 10658 | {"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.67399], [-118.0137, 33.67394], [-118.01374, 33.67393], [-118.01411, 33.67395]]]} | Open Access 1 | 19000 | Bailey Park | 15760 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 0.556 | Bailey Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);