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 map descending
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 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
12901 | 12901 | 12900 | {"type": "Polygon", "coordinates": [[[-118.07112, 33.7252], [-118.07073, 33.72527], [-118.07071, 33.72521], [-118.07066, 33.72516], [-118.07086, 33.72496], [-118.07101, 33.72503], [-118.07104, 33.72506], [-118.07109, 33.72512], [-118.07112, 33.7252]]]} | Open Access 1 | 30354 | Prince Park | 24007 | 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.218 | Prince Park | 0 | Local Park 2 | 4 | |
12899 | 12899 | 12898 | {"type": "Polygon", "coordinates": [[[-118.06828, 33.72459], [-118.06804, 33.72464], [-118.06803, 33.72458], [-118.06796, 33.72452], [-118.06789, 33.72451], [-118.0678, 33.72454], [-118.06773, 33.72449], [-118.06743, 33.72457], [-118.06714, 33.7247], [-118.06707, 33.72464], [-118.06699, 33.72463], [-118.06694, 33.72464], [-118.06688, 33.72468], [-118.06685, 33.72474], [-118.06655, 33.72482], [-118.0666, 33.72492], [-118.06633, 33.72499], [-118.06631, 33.72503], [-118.06623, 33.72502], [-118.06616, 33.72505], [-118.06612, 33.72508], [-118.06609, 33.72514], [-118.06612, 33.72522], [-118.06592, 33.7253], [-118.06555, 33.7253], [-118.06555, 33.72559], [-118.06499, 33.72559], [-118.065, 33.72549], [-118.06519, 33.72548], [-118.06531, 33.72529], [-118.06529, 33.72524], [-118.06536, 33.7252], [-118.06539, 33.72515], [-118.06546, 33.72516], [-118.06572, 33.72507], [-118.06594, 33.7249], [-118.06594, 33.72485], [-118.066, 33.72483], [-118.06605, 33.7248], [-118.0662, 33.72481], [-118.06648, 33.72463], [-118.06662, 33.7244], [-118.06668, 33.72441], [-118.06676, 33.72439], [-118.0668, 33.72437], [-118.06683, 33.72431], [-118.06696, 33.72427], [-118.06712, 33.72403], [-118.06733, 33.72412], [-118.06749, 33.72388], [-118.06775, 33.72403], [-118.06759, 33.72427], [-118.06828, 33.72459]]]} | Open Access 1 | 30352 | Conrad Park | 17595 | 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 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/conrad-park.cfm | Orange 3 | 2.752 | Conrad Park | 0 | Local Park 2 | 4 |
6344 | 6344 | 6343 | {"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 | 47453 | French Park | 31168 | 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 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/french-park.cfm | Orange 3 | 0.334 | French Park | 0 | Local Park 2 | 4 |
12902 | 12902 | 12901 | {"type": "Polygon", "coordinates": [[[-118.06732, 33.72058], [-118.06761, 33.721], [-118.06762, 33.72106], [-118.06761, 33.7211], [-118.06754, 33.72114], [-118.06743, 33.72114], [-118.06703, 33.72096], [-118.06732, 33.72058]]]} | Open Access 1 | 30355 | Tarbox Park | 26189 | 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.434 | Tarbox Park | 0 | Local Park 2 | 4 | |
2915 | 2915 | 2914 | {"type": "Polygon", "coordinates": [[[-118.06599, 33.72644], [-118.06594, 33.72672], [-118.06559, 33.72665], [-118.06532, 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 | 19008 | Trinidad Park | 26539 | 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 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/trinidad-park.cfm | Orange 3 | 0.722 | Trinidad Park | 0 | Local Park 2 | 4 |
12896 | 12896 | 12895 | {"type": "Polygon", "coordinates": [[[-118.06, 33.71724], [-118.05953, 33.71725], [-118.05952, 33.71646], [-118.05955, 33.71643], [-118.05972, 33.71641], [-118.05999, 33.71707], [-118.06, 33.71724]]]} | Open Access 1 | 30351 | Booster Park | 16274 | 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 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/booster-park.cfm | Orange 3 | 0.752 | Booster Park | 0 | Local Park 2 | 4 |
4138 | 4138 | 4137 | {"type": "Polygon", "coordinates": [[[-118.0585, 33.7167], [-118.05849, 33.71686], [-118.05845, 33.71692], [-118.0584, 33.71695], [-118.05831, 33.71697], [-118.05784, 33.71697], [-118.05784, 33.7167], [-118.0585, 33.7167]]]} | Open Access 1 | 47450 | Davenport Beach Park | 31164 | 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 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/davenport-beach-park.cfm | Orange 3 | 0.443 | Davenport Beach Park | 0 | Local Park 2 | 4 |
6330 | 6330 | 6329 | {"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 | 47455 | Humboldt Beach | 31169 | 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 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/humboldt-beach.cfm | Orange 3 | 0.446 | Humboldt Beach | 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 | |
469 | 469 | 468 | {"type": "Polygon", "coordinates": [[[-118.04595, 33.72971], [-118.04398, 33.72972], [-118.04391, 33.72969], [-118.0439, 33.72907], [-118.04415, 33.72896], [-118.04415, 33.72858], [-118.04461, 33.72858], [-118.04462, 33.72874], [-118.04481, 33.72873], [-118.04482, 33.72859], [-118.0449, 33.72859], [-118.04491, 33.72892], [-118.04501, 33.72893], [-118.04502, 33.72962], [-118.04595, 33.72962], [-118.04595, 33.72971]]]} | Open Access 1 | 1517 | Haven View Park | 19741 | 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 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/haven-view-park.cfm | Orange 3 | 2.961 | Haven View 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 | |
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 | |
10663 | 10663 | 10662 | {"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.03538, 33.72084], [-118.0353, 33.72088], [-118.03522, 33.7208], [-118.03494, 33.7208], [-118.03493, 33.72083], [-118.03282, 33.72084], [-118.0328, 33.72002], [-118.03491, 33.72], [-118.03491, 33.71978], [-118.036, 33.71978]]]} | Open Access 1 | 19004 | Gibbs Park | 19289 | 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 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/gibbs-park.cfm | Orange 3 | 6.855 | Gibbs Park | 0 | Local Park 2 | 4 |
912 | 912 | 911 | {"type": "Polygon", "coordinates": [[[-118.03256, 33.73135], [-118.03247, 33.73136], [-118.03249, 33.73247], [-118.03076, 33.73248], [-118.03071, 33.73028], [-118.03254, 33.73027], [-118.03256, 33.73135]]]} | Open Access 1 | 5831 | Marina Park | 21834 | 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 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/marina-park.cfm | Orange 3 | 9.968 | Marina Park | 0 | Local Park 2 | 4 |
6339 | 6339 | 6338 | {"type": "Polygon", "coordinates": [[[-118.03212, 33.67979], [-118.02419, 33.67306], [-118.02306, 33.67218], [-118.00691, 33.66057], [-118.00615, 33.65996], [-118.00628, 33.65984], [-118.00705, 33.66045], [-118.02319, 33.67205], [-118.02433, 33.67294], [-118.03211, 33.67955], [-118.03212, 33.67979]]]} | Open Access 1 | 47447 | Bluff Top Park | 31162 | 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 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/bluff-top-park.cfm | Orange 3 | 14.823 | Bluff Top 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 | |
1315 | 1315 | 1314 | {"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.70406], [-118.03025, 33.70426], [-118.03039, 33.70438]]]} | Open Access 1 | 7379 | Bolsa View Park | 16249 | 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 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/bolsa-view-park.cfm | Orange 3 | 2.674 | Bolsa 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 | |
866 | 866 | 865 | {"type": "Polygon", "coordinates": [[[-118.02397, 33.72238], [-118.0239, 33.72238], [-118.02391, 33.72252], [-118.02388, 33.72257], [-118.02382, 33.72259], [-118.02365, 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 | 5602 | Carr Park | 16906 | 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 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/carr-park.cfm | Orange 3 | 11.205 | Carr 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]);