units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
22 rows where COUNTY = 6 and MNG_AGENCY = 290 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
DES_TP 4
- Local Park 19
- Local Recreation Area 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 22
MNG_AGENCY 1
- Hermosa Beach, City of · 22 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15316 | 15316 | 15315 | {"type": "Polygon", "coordinates": [[[-118.3888, 33.86582], [-118.38873, 33.86578], [-118.38873, 33.86578], [-118.38878, 33.86576], [-118.3888, 33.86582]]]} | Open Access 1 | 46498 | Scout Park | 29783 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.004 | Scout Park | 0 | Local Park 2 | 4 | |
4443 | 4443 | 4442 | {"type": "Polygon", "coordinates": [[[-118.38594, 33.85816], [-118.38592, 33.85821], [-118.38575, 33.85816], [-118.38594, 33.85816], [-118.38594, 33.85816]]]} | Open Access 1 | 46502 | Third Street & Prospect Avenue Park | 29786 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.012 | Third Street & Prospect Avenue Park | 0 | Local Park 2 | 4 | |
6967 | 6967 | 6966 | {"type": "Polygon", "coordinates": [[[-118.38992, 33.85746], [-118.38985, 33.85749], [-118.38978, 33.85725], [-118.38985, 33.85722], [-118.38992, 33.85746]]]} | Open Access 1 | 6104 | Ocean View Parkette | 29776 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.051 | Ocean View Parkette | 0 | Local Park 2 | 4 | |
15328 | 15328 | 15327 | {"type": "Polygon", "coordinates": [[[-118.39599, 33.85309], [-118.39592, 33.85328], [-118.39582, 33.85331], [-118.39579, 33.85324], [-118.39582, 33.85314], [-118.39599, 33.85309]]]} | Open Access 1 | 46504 | Kay Etow Parkette | 29788 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.065 | Kay Etow Parkette | 0 | Local Park 2 | 4 | |
7073 | 7073 | 7072 | {"type": "Polygon", "coordinates": [[[-118.40324, 33.87754], [-118.40315, 33.87758], [-118.40301, 33.87736], [-118.40313, 33.87732], [-118.40324, 33.87754]]]} | Open Access 1 | 6109 | Shaffer Park | 29777 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.073 | Shaffer Park | 0 | Local Park 2 | 4 | |
955 | 955 | 954 | {"type": "Polygon", "coordinates": [[[-118.38819, 33.85698], [-118.38808, 33.85702], [-118.38796, 33.85679], [-118.38808, 33.85675], [-118.38819, 33.85698]]]} | Open Access 1 | 6103 | Moondust Park | 22451 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.081 | Moondust Park | 0 | Local Park 2 | 4 | |
4442 | 4442 | 4441 | {"type": "Polygon", "coordinates": [[[-118.39438, 33.86006], [-118.39427, 33.86008], [-118.39421, 33.85979], [-118.39432, 33.85977], [-118.39438, 33.86006]]]} | Open Access 1 | 46500 | Eighth Street and Valley Drive Green Space | 33371 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.086 | Eighth Street and Valley Drive Green Space | None 396 | |||
15291 | 15291 | 15290 | {"type": "Polygon", "coordinates": [[[-118.38722, 33.85852], [-118.3872, 33.85858], [-118.38658, 33.8584], [-118.3866, 33.85834], [-118.38722, 33.85852]]]} | Open Access 1 | 46495 | Fifth Street & Prospect Avenue Park | 29780 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.102 | Fifth Street & Prospect Avenue Park | 0 | Local Park 2 | 4 | |
15315 | 15315 | 15314 | {"type": "Polygon", "coordinates": [[[-118.39163, 33.86965], [-118.39122, 33.86971], [-118.39117, 33.86944], [-118.39157, 33.86938], [-118.39163, 33.86965]]]} | Open Access 1 | 46497 | Seaview Parkette | 29782 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.287 | Seaview Parkette | 0 | Local Park 2 | 4 | |
15327 | 15327 | 15326 | {"type": "Polygon", "coordinates": [[[-118.39424, 33.8571], [-118.39415, 33.8575], [-118.39414, 33.8575], [-118.39387, 33.85836], [-118.39388, 33.85822], [-118.39385, 33.85801], [-118.39379, 33.85777], [-118.39397, 33.85771], [-118.39411, 33.85726], [-118.39407, 33.85716], [-118.39424, 33.8571]]]} | Open Access 1 | 46503 | Ardmore Park | 29787 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.354 | Ardmore Park | 0 | Local Park 2 | 4 | |
15314 | 15314 | 15313 | {"type": "Polygon", "coordinates": [[[-118.39417, 33.8568], [-118.39413, 33.85701], [-118.3936, 33.85718], [-118.39348, 33.85693], [-118.39387, 33.8568], [-118.39391, 33.85688], [-118.39417, 33.8568]]]} | Open Access 1 | 46494 | Bi-Centennial Park | 29778 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.395 | Bi-Centennial Park | 0 | Local Park 2 | 4 | |
7008 | 7008 | 7007 | {"type": "Polygon", "coordinates": [[[-118.38814, 33.85983], [-118.38758, 33.8599], [-118.38754, 33.85963], [-118.38812, 33.85955], [-118.38814, 33.85967], [-118.38814, 33.85983]]]} | Open Access 1 | 6102 | Fort Lots-o-Fun Park | 19006 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.41 | Fort Lots-o-Fun Park | 0 | Local Park 2 | 4 | |
15395 | 15395 | 15394 | {"type": "Polygon", "coordinates": [[[-118.39514, 33.8615], [-118.39468, 33.86158], [-118.39458, 33.86123], [-118.39504, 33.86114], [-118.39514, 33.8615]]]} | Restricted Access 2 | 46635 | Lawn Bowling Green | 29962 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=262 | Los Angeles 6 | 0.443 | Lawn Bowling Green | 1958 | Local Park 2 | 4 |
7072 | 7072 | 7071 | {"type": "Polygon", "coordinates": [[[-118.39247, 33.86342], [-118.3922, 33.86326], [-118.39194, 33.86317], [-118.39179, 33.86314], [-118.39193, 33.86304], [-118.39206, 33.86292], [-118.39218, 33.86278], [-118.39224, 33.86266], [-118.39247, 33.86342]]]} | Open Access 1 | 6107 | Greenwood Park | 19486 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.477 | Greenwood Park | 0 | Local Park 2 | 4 | |
7080 | 7080 | 7079 | {"type": "Polygon", "coordinates": [[[-118.38718, 33.85905], [-118.38653, 33.85914], [-118.38641, 33.85852], [-118.38712, 33.85872], [-118.38718, 33.85905]]]} | Open Access 1 | 6101 | Edith Rodaway Friendship Park | 18449 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.806 | Edith Rodaway Friendship Park | 0 | Local Park 2 | 4 | |
6320 | 6320 | 6319 | {"type": "Polygon", "coordinates": [[[-118.40237, 33.86403], [-118.40186, 33.86413], [-118.40176, 33.86383], [-118.40163, 33.86384], [-118.40157, 33.86359], [-118.40218, 33.86348], [-118.40237, 33.86403]]]} | Open Access 1 | 6113 | Noble Park | 22778 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.848 | Noble Park | 0 | Local Park 2 | 4 | |
7068 | 7068 | 7067 | {"type": "Polygon", "coordinates": [[[-118.39638, 33.85776], [-118.39602, 33.85783], [-118.39598, 33.8577], [-118.39474, 33.85792], [-118.39461, 33.85742], [-118.39467, 33.85718], [-118.39472, 33.8568], [-118.39603, 33.85656], [-118.39615, 33.85698], [-118.39618, 33.85699], [-118.39638, 33.85776]]]} | Open Access 1 | 6098 | South Park | 25671 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 4.48 | South Park | 0 | Local Park 2 | 4 | |
16943 | 16943 | 16942 | {"type": "Polygon", "coordinates": [[[-118.39494, 33.86453], [-118.39402, 33.8647], [-118.39378, 33.8647], [-118.39362, 33.86466], [-118.3934, 33.86458], [-118.39317, 33.86443], [-118.393, 33.86423], [-118.39295, 33.86403], [-118.39386, 33.86385], [-118.39371, 33.86329], [-118.39456, 33.86313], [-118.39494, 33.86453]]]} | Open Access 1 | 6106 | Community Center | 29775 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 4.795 | Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
7071 | 7071 | 7070 | {"type": "Polygon", "coordinates": [[[-118.39692, 33.86182], [-118.39538, 33.86211], [-118.39546, 33.86244], [-118.39494, 33.86254], [-118.39468, 33.86158], [-118.39513, 33.8615], [-118.39504, 33.86115], [-118.39458, 33.86123], [-118.39451, 33.86096], [-118.39635, 33.86062], [-118.39665, 33.86175], [-118.3969, 33.86171], [-118.39692, 33.86182]]]} | Open Access 1 | 6105 | Clark Stadium and Building | 29774 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 6.2 | Clark Stadium and Building | None 578 | |||
7074 | 7074 | 7073 | {"type": "Polygon", "coordinates": [[[-118.4027, 33.87389], [-118.40098, 33.87456], [-118.40068, 33.8743], [-118.3998, 33.87356], [-118.39936, 33.87311], [-118.39916, 33.87289], [-118.39918, 33.87288], [-118.40182, 33.87287], [-118.40205, 33.87309], [-118.40239, 33.87335], [-118.4027, 33.87389]]]} | Open Access 1 | 6110 | Valley Park | 26797 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 9.047 | Valley 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]);