units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
116 rows where DES_TP = 3 and MNG_AGENCY = 24 sorted by AGNCY_NAME
This data as json, copyable, CSV (advanced)
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 96
MNG_AGENCY 1
- Los Angeles, City of · 96 ✖
DES_TP 1
- Local Recreation Area · 96 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4979 | 4979 | 4978 | {"type": "Polygon", "coordinates": [[[-118.34681, 34.02798], [-118.34681, 34.02798], [-118.34618, 34.02885], [-118.34614, 34.02759], [-118.34681, 34.02798]]]} | Open Access 1 | 15079 | Vineyard Recreation Center | 27140 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 1.061 | Vineyard Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
4994 | 4994 | 4993 | {"type": "Polygon", "coordinates": [[[-118.30142, 33.82395], [-118.29959, 33.82397], [-118.29959, 33.82332], [-118.29946, 33.82332], [-118.29945, 33.82232], [-118.30141, 33.82231], [-118.30142, 33.82395]]]} | Open Access 1 | 6200 | Normandale Recreation Center | 22800 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 7.97 | Normandale Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
5062 | 5062 | 5061 | {"type": "Polygon", "coordinates": [[[-118.21546, 34.07238], [-118.21496, 34.07239], [-118.21496, 34.07274], [-118.21444, 34.07275], [-118.21443, 34.07196], [-118.21545, 34.07195], [-118.21546, 34.07238]]]} | Open Access 1 | 4187 | Lincoln Heights Recreation Center | 21250 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 1.593 | Lincoln Heights Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
5178 | 5178 | 5177 | {"type": "Polygon", "coordinates": [[[-118.20833, 34.13041], [-118.20832, 34.13374], [-118.20706, 34.13351], [-118.20706, 34.13058], [-118.20833, 34.13041]]]} | Open Access 1 | 15505 | Yosemite Recreation Center | 27785 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 10.006 | Yosemite Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
5702 | 5702 | 5701 | {"type": "Polygon", "coordinates": [[[-118.21106, 34.03932], [-118.21067, 34.03991], [-118.21062, 34.03994], [-118.21057, 34.03993], [-118.20993, 34.03964], [-118.21034, 34.03899], [-118.21106, 34.03932]]]} | Restricted Access 2 | 45762 | Roosevelt High School Pool | 28767 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/dos/aquatic/facility/rooseveltPool.htm | Los Angeles 6 | 1.493 | Roosevelt High School Pool | 0 | Local Recreation Area 3 | 4 |
5710 | 5710 | 5709 | {"type": "Polygon", "coordinates": [[[-118.2722, 34.12839], [-118.27164, 34.12791], [-118.2691, 34.12331], [-118.26956, 34.12305], [-118.26994, 34.12261], [-118.27156, 34.12603], [-118.2722, 34.12839]]]} | Restricted Access 2 | 45780 | Los Feliz Golf Course | 28786 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://golf.lacity.org/cdp_los_feliz.htm | Los Angeles 6 | 11.795 | Los Feliz GC | 0 | Local Recreation Area 3 | 4 |
5714 | 5714 | 5713 | {"type": "Polygon", "coordinates": [[[-118.27606, 34.08649], [-118.27593, 34.08661], [-118.27562, 34.08597], [-118.27577, 34.08592], [-118.27581, 34.08609], [-118.27587, 34.08623], [-118.27595, 34.08636], [-118.27606, 34.08649]]]} | Open Access 1 | 45805 | Larissa Parkway | 28825 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.221 | Larissa Parkway | 0 | Local Recreation Area 3 | 4 | |
5843 | 5843 | 5842 | {"type": "Polygon", "coordinates": [[[-118.18237, 34.07792], [-118.18013, 34.07793], [-118.18013, 34.07751], [-118.18011, 34.0774], [-118.18007, 34.07733], [-118.18, 34.07725], [-118.17993, 34.07718], [-118.1795, 34.07695], [-118.17947, 34.07691], [-118.18026, 34.07568], [-118.18235, 34.07567], [-118.18237, 34.07792]]]} | Open Access 1 | 169 | El Sereno Recreation Center | 18543 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 13.93 | El Sereno Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
5871 | 5871 | 5870 | {"type": "Polygon", "coordinates": [[[-118.24545, 34.09931], [-118.24468, 34.0998], [-118.24403, 34.09922], [-118.24481, 34.09872], [-118.24487, 34.09872], [-118.24545, 34.09931]]]} | Open Access 1 | 245 | Elysian Valley Recreation Center | 18609 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.004 | Elysian Valley Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
5927 | 5927 | 5926 | {"type": "Polygon", "coordinates": [[[-118.2058, 34.03807], [-118.20518, 34.03902], [-118.20469, 34.03879], [-118.2044, 34.03922], [-118.20354, 34.03884], [-118.20443, 34.03747], [-118.20518, 34.0378], [-118.20518, 34.03783], [-118.20534, 34.0379], [-118.20536, 34.03788], [-118.2058, 34.03807]]]} | Open Access 1 | 411 | Evergreen Recreation Center | 18767 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 5.393 | Evergreen Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
5953 | 5953 | 5952 | {"type": "Polygon", "coordinates": [[[-118.29665, 33.73253], [-118.29665, 33.73325], [-118.29467, 33.73324], [-118.29468, 33.73253], [-118.29665, 33.73253]]]} | Open Access 1 | 5891 | Ralph C. Daniels Field Sports Center | 28619 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.587 | Ralph C. Daniels Field Sports Ctr. | 0 | Local Recreation Area 3 | 4 | |
6394 | 6394 | 6393 | {"type": "Polygon", "coordinates": [[[-118.18925, 34.11305], [-118.18679, 34.11383], [-118.18662, 34.11346], [-118.18815, 34.11212], [-118.18864, 34.1122], [-118.18925, 34.11305]]]} | Open Access 1 | 1811 | Highland Park Recreation Center | 19937 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 5.416 | Highland Park Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
6592 | 6592 | 6591 | {"type": "Polygon", "coordinates": [[[-118.28341, 34.08393], [-118.283, 34.08459], [-118.28255, 34.08441], [-118.28134, 34.08636], [-118.28032, 34.08591], [-118.28183, 34.08349], [-118.28339, 34.0839], [-118.28341, 34.08393]]]} | Open Access 1 | 3982 | Bellevue Recreation Center | 28615 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 9.129 | Bellevue Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
6674 | 6674 | 6673 | {"type": "Polygon", "coordinates": [[[-118.64797, 34.19522], [-118.64792, 34.19556], [-118.64772, 34.19554], [-118.64752, 34.19555], [-118.64721, 34.19561], [-118.64698, 34.19569], [-118.6464, 34.19595], [-118.64635, 34.19593], [-118.64625, 34.19573], [-118.64624, 34.19563], [-118.64627, 34.19542], [-118.64631, 34.19537], [-118.6464, 34.1953], [-118.64642, 34.19522], [-118.6464, 34.19518], [-118.64636, 34.19513], [-118.64629, 34.19511], [-118.64623, 34.19511], [-118.64624, 34.19507], [-118.64797, 34.19522]]]} | Open Access 1 | 4956 | Mae Boyar Recreation Center | 21665 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.247 | Mae Boyar Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
6755 | 6755 | 6754 | {"type": "Polygon", "coordinates": [[[-118.43113, 34.01704], [-118.42626, 34.01947], [-118.42529, 34.01837], [-118.43024, 34.016], [-118.43078, 34.01658], [-118.43113, 34.01704]]]} | Open Access 1 | 5100 | Mar Vista Recreation Center | 21787 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 19.06 | Mar Vista Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
6937 | 6937 | 6936 | {"type": "Polygon", "coordinates": [[[-118.30014, 34.04536], [-118.29922, 34.04533], [-118.29922, 34.04401], [-118.30011, 34.04389], [-118.30014, 34.04391], [-118.30014, 34.04536]]]} | Open Access 1 | 5833 | Normandie Playground | 22801 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.267 | Normandie Playground | 0 | Local Recreation Area 3 | 4 | |
7017 | 7017 | 7016 | {"type": "Polygon", "coordinates": [[[-118.53593, 34.2532], [-118.53593, 34.25409], [-118.53391, 34.25409], [-118.53391, 34.25537], [-118.53112, 34.25537], [-118.53086, 34.25535], [-118.53057, 34.25529], [-118.53059, 34.25521], [-118.53164, 34.25372], [-118.53391, 34.25187], [-118.53391, 34.25274], [-118.53593, 34.25274], [-118.53593, 34.2532]]]} | Open Access 1 | 5968 | Northridge Recreation Center | 22889 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 24.037 | Northridge Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
7114 | 7114 | 7113 | {"type": "Polygon", "coordinates": [[[-118.26976, 33.7748], [-118.2695, 33.77481], [-118.26952, 33.77513], [-118.2687, 33.77517], [-118.26849, 33.77245], [-118.26957, 33.77239], [-118.26976, 33.7748]]]} | Open Access 1 | 6189 | Wilmington Recreation Center | 27599 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 7.337 | Wilmington Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
7122 | 7122 | 7121 | {"type": "MultiPolygon", "coordinates": [[[[-118.30133, 33.7987], [-118.29923, 33.7987], [-118.29923, 33.79799], [-118.29929, 33.79798], [-118.29929, 33.79793], [-118.30133, 33.79794], [-118.30133, 33.7987]]], [[[-118.30133, 33.79878], [-118.30133, 33.79949], [-118.29969, 33.79949], [-118.29969, 33.79878], [-118.30133, 33.79878]]], [[[-118.29965, 33.79878], [-118.29964, 33.79949], [-118.29923, 33.79948], [-118.29923, 33.79878], [-118.29965, 33.79878]]], [[[-118.30133, 33.79957], [-118.30133, 33.80001], [-118.29923, 33.80001], [-118.29922, 33.79956], [-118.30133, 33.79957]]]]} | Open Access 1 | 6193 | Harbor City Recreation Center | 19661 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 10.133 | Harbor City Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
7124 | 7124 | 7123 | {"type": "MultiPolygon", "coordinates": [[[[-118.29099, 34.11673], [-118.29087, 34.11681], [-118.29069, 34.11659], [-118.29038, 34.11611], [-118.29001, 34.11526], [-118.28991, 34.11456], [-118.29006, 34.11456], [-118.2902, 34.11522], [-118.29036, 34.11572], [-118.29055, 34.11609], [-118.29077, 34.11645], [-118.29099, 34.11673]]], [[[-118.2915, 34.11316], [-118.29134, 34.11325], [-118.29093, 34.11343], [-118.29057, 34.11371], [-118.29029, 34.114], [-118.29014, 34.11433], [-118.29002, 34.11432], [-118.29011, 34.11401], [-118.29036, 34.11373], [-118.29069, 34.11346], [-118.29088, 34.11333], [-118.29112, 34.11324], [-118.29144, 34.11306], [-118.2915, 34.11316]]], [[[-118.29222, 34.11761], [-118.29216, 34.11772], [-118.29187, 34.1176], [-118.29158, 34.11744], [-118.2913, 34.11723], [-118.29103, 34.11696], [-118.29115, 34.1169], [-118.29158, 34.11729], [-118.29188, 34.11746], [-118.29222, 34.11761]]], [[[-118.29187, 34.11227], [-118.29187, 34.11253], [-118.29176, 34.11285], [-118.29162, 34.11306], [-118.29154, 34.11299], [-118.29171, 34.11256], [-118.29172, 34.11229], [-118.29187, 34.11227]]], [[[-118.29177, 33.92221], [-118.29175, 33.92359], [-118.29163, 33.92359], [-118.2916, 33.92218], [-118.29177, 33.92221]]], [[[-118.29175, 33.91936], [-118.29175, 33.92009], [-118.29175, 33.92009], [-118.29162, 33.92003], [-118.2916, 33.91941], [-118.29175, 33.91936]]], [[[-118.29176, 33.91824], [-118.29161, 33.91833], [-118.29161, 33.91659], [-118.29175, 33.9166], [-118.29176, 33.91824]]], [[[-118.29174, 33.92128], [-118.29174, 33.92128], [-118.29173, 33.92206], [-118.29162, 33.92204], [-118.29161, 33.92128], [-118.29174, 33.92128]]], [[[-118.29176, 33.9184], [-118.29176, 33.91916], [-118.29162, 33.91919], [-118.29161, 33.91845], [-118.29176, 33.9184]]], [[[-118.29175, 33.92106], [-118.29165, 33.92106], [-118.29165, 33.92028], [-118.29175, 33.92033], [-118.29175, 33.92106]]], [[[-118.29188, 34.11136], [-118.29188, 34.11215], [-118.29173, 34.11218], [-118.29175, 34.11136], [-118.29178, 34.11124], [-118.29183, 34.11122], [-118.29188, 34.11136]]]]} | Open Access 1 | 6204 | Vermont Parkway | 26998 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 4.664 | Vermont Parkway | 0 | Local Recreation Area 3 | 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]);