units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
21 rows where ACCESS_TYP = 1, COUNTY = 6 and MNG_AGENCY = 290
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 1
- City Agency 21
ACCESS_TYP 1
- Open Access · 21 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |
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 | |
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 | |
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 | |
7067 | 7067 | 7066 | {"type": "MultiPolygon", "coordinates": [[[[-118.39374, 33.85407], [-118.39363, 33.85402], [-118.39346, 33.85391], [-118.3936, 33.85387], [-118.39374, 33.85407]]], [[[-118.39448, 33.85549], [-118.39417, 33.85555], [-118.39408, 33.85529], [-118.39387, 33.85486], [-118.39328, 33.85395], [-118.39335, 33.85394], [-118.39338, 33.85394], [-118.39353, 33.85406], [-118.39367, 33.85413], [-118.39379, 33.85422], [-118.39392, 33.85436], [-118.39413, 33.85469], [-118.39434, 33.85508], [-118.39448, 33.85549]]], [[[-118.39453, 33.85565], [-118.39456, 33.85576], [-118.39461, 33.85604], [-118.39464, 33.85632], [-118.39463, 33.85675], [-118.39457, 33.85718], [-118.39443, 33.85769], [-118.39418, 33.85847], [-118.39408, 33.85904], [-118.39407, 33.85951], [-118.39417, 33.8601], [-118.39386, 33.86016], [-118.3938, 33.85992], [-118.39375, 33.85956], [-118.39374, 33.85913], [-118.39376, 33.85892], [-118.39385, 33.85843], [-118.39415, 33.85749], [-118.39423, 33.85718], [-118.39429, 33.85684], [-118.39431, 33.8566], [-118.3943, 33.85627], [-118.39428, 33.85609], [-118.39417, 33.85589], [-118.39404, 33.85575], [-118.3942, 33.8557], [-118.39453, 33.85565]]], [[[-118.39536, 33.86445], [-118.39504, 33.86451], [-118.39389, 33.86032], [-118.39421, 33.86026], [-118.39536, 33.86445]]], [[[-118.40176, 33.87623], [-118.40145, 33.87635], [-118.40139, 33.87605], [-118.40129, 33.87574], [-118.40112, 33.8754], [-118.4009, 33.87508], [-118.40072, 33.87486], [-118.40029, 33.87447], [-118.39989, 33.87415], [-118.39942, 33.87374], [-118.39899, 33.87331], [-118.39879, 33.87309], [-118.39837, 33.87256], [-118.39797, 33.87194], [-118.39776, 33.87156], [-118.39764, 33.8713], [-118.39609, 33.86793], [-118.39589, 33.8674], [-118.39571, 33.86687], [-118.39512, 33.86478], [-118.3954, 33.86473], [-118.39594, 33.86669], [-118.39617, 33.86737], [-118.39642, 33.868], [-118.39798, 33.87137], [-118.39825, 33.87186], [-118.39856, 33.87234], [-118.39882, 33.87268], [-118.399, 33.87291], [-118.3995, 33.87344], [-118.39994, 33.87385], [-118.40047, 33.87428], [-118.40052, 33.87427], [-118.40074, 33.87446], [-118.401, 33.87472], [-118.40112, 33.87486], [-118.40138, 33.87522], [-118.40155, 33.87554], [-118.4017, 33.87597], [-118.40176, 33.87623]]], [[[-118.40194, 33.8771], [-118.4016, 33.87711], [-118.40149, 33.8765], [-118.40178, 33.87638], [-118.40194, 33.8771]]]]} | Open Access 1 | 6097 | Hermosa Valley Greenbelt Park | 19872 | 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 | 19.084 | Hermosa Valley Greenbelt 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 | |
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 | |||
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 | |
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 | |
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 | |
7079 | 7079 | 7078 | {"type": "Polygon", "coordinates": [[[-118.40772, 33.87286], [-118.40805, 33.87357], [-118.40912, 33.87571], [-118.40966, 33.87693], [-118.40916, 33.87712], [-118.40823, 33.87745], [-118.40805, 33.87708], [-118.40801, 33.87707], [-118.40813, 33.87703], [-118.40816, 33.8771], [-118.40822, 33.87711], [-118.40823, 33.87709], [-118.40822, 33.87708], [-118.40836, 33.87708], [-118.40837, 33.87706], [-118.40666, 33.87357], [-118.40626, 33.87284], [-118.40629, 33.87284], [-118.40629, 33.87283], [-118.40491, 33.87024], [-118.40366, 33.86737], [-118.40335, 33.86655], [-118.40196, 33.86259], [-118.40194, 33.86259], [-118.40145, 33.86122], [-118.40147, 33.86121], [-118.39993, 33.85693], [-118.39788, 33.85239], [-118.3992, 33.85195], [-118.39906, 33.85149], [-118.39933, 33.85141], [-118.3994, 33.85192], [-118.39969, 33.85292], [-118.40028, 33.85445], [-118.40058, 33.85514], [-118.4014, 33.85734], [-118.40174, 33.85811], [-118.4023, 33.85951], [-118.40309, 33.86178], [-118.40365, 33.86348], [-118.40422, 33.86503], [-118.40487, 33.86666], [-118.40569, 33.86859], [-118.40699, 33.87144], [-118.40772, 33.87286]]]} | Open Access 1 | 6096 | Hermosa City Beach | 19869 | 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 | 91.811 | Hermosa City Beach | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);