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 ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, PARK_URL
ACCESS_TYP 3
- Open Access 105
- Restricted Access 10
- No Public Access 1
LAYER 2 ✖
- City 115
- Special District 1
MNG_AG_TYP 1
- City Agency 116
MNG_AGENCY 1
- Los Angeles, City of · 116 ✖
DES_TP 1
- Local Recreation Area · 116 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
917 | 917 | 916 | {"type": "Polygon", "coordinates": [[[-118.446, 34.13918], [-118.44599, 34.13919], [-118.44597, 34.13919], [-118.44542, 34.13894], [-118.44542, 34.13891], [-118.446, 34.13918]]]} | Open Access 1 | 6396 | Oak Forest West Access | 22965 | 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.044 | Oak Forest West Access | 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 | |
15062 | 15062 | 15061 | {"type": "Polygon", "coordinates": [[[-118.27397, 34.0274], [-118.2738, 34.02768], [-118.27344, 34.02752], [-118.27359, 34.02728], [-118.27363, 34.02726], [-118.27367, 34.02726], [-118.27397, 34.0274]]]} | Open Access 1 | 45823 | Orthopedic Hospital Universal Access Playground | 28842 | 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/playground/facility/orthoUAPk.htm | Los Angeles 6 | 0.325 | Orthopedic Hospital Universal Access Playground | 0 | Local Recreation Area 3 | 4 |
1000 | 1000 | 999 | {"type": "Polygon", "coordinates": [[[-118.24176, 33.93869], [-118.24175, 33.93903], [-118.24158, 33.93902], [-118.24126, 33.93886], [-118.24127, 33.93867], [-118.24176, 33.93869]]]} | Open Access 1 | 6220 | Watts Towers Art Center | 27314 | 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.366 | Watts Towers Art Ctr. | 0 | Local Recreation Area 3 | 4 | |
15060 | 15060 | 15059 | {"type": "MultiPolygon", "coordinates": [[[[-118.28236, 34.06725], [-118.28241, 34.06724], [-118.28243, 34.06726], [-118.28244, 34.06728], [-118.28224, 34.06759], [-118.28219, 34.06761], [-118.28217, 34.06759], [-118.28217, 34.06756], [-118.28236, 34.06725]]], [[[-118.28248, 34.06718], [-118.28245, 34.06718], [-118.28244, 34.06715], [-118.28245, 34.06713], [-118.28248, 34.06712], [-118.28251, 34.06713], [-118.28252, 34.06715], [-118.28251, 34.06717], [-118.28248, 34.06718]]], [[[-118.28271, 34.06671], [-118.28276, 34.06669], [-118.28279, 34.06671], [-118.28279, 34.06674], [-118.28259, 34.06705], [-118.28254, 34.06706], [-118.28252, 34.06704], [-118.28252, 34.06702], [-118.28271, 34.06671]]], [[[-118.28283, 34.06664], [-118.2828, 34.06663], [-118.28279, 34.06661], [-118.2828, 34.06658], [-118.28283, 34.06657], [-118.28285, 34.06658], [-118.28287, 34.0666], [-118.28286, 34.06663], [-118.28283, 34.06664]]], [[[-118.28306, 34.06616], [-118.28311, 34.06614], [-118.28314, 34.06616], [-118.28314, 34.06619], [-118.28294, 34.0665], [-118.28289, 34.06651], [-118.28287, 34.06649], [-118.28287, 34.06647], [-118.28306, 34.06616]]], [[[-118.28318, 34.06609], [-118.28315, 34.06608], [-118.28313, 34.06606], [-118.28314, 34.06604], [-118.28317, 34.06602], [-118.2832, 34.06603], [-118.28322, 34.06606], [-118.28321, 34.06608], [-118.28318, 34.06609]]], [[[-118.28341, 34.06561], [-118.28346, 34.0656], [-118.28348, 34.06562], [-118.28348, 34.06564], [-118.28329, 34.06595], [-118.28323, 34.06597], [-118.28321, 34.06595], [-118.28321, 34.06592], [-118.28341, 34.06561]]], [[[-118.28352, 34.06555], [-118.2835, 34.06554], [-118.28348, 34.06551], [-118.28349, 34.06549], [-118.28352, 34.06548], [-118.28355, 34.06549], [-118.28356, 34.06551], [-118.28355, 34.06554], [-118.28352, 34.06555]]], [[[-118.28376, 34.06506], [-118.28381, 34.06506], [-118.28383, 34.0651], [-118.28363, 34.06541], [-118.28358, 34.06542], [-118.28356, 34.06538], [-118.28376, 34.06506]]], [[[-118.28387, 34.065], [-118.28384, 34.06499], [-118.28383, 34.06496], [-118.28384, 34.06494], [-118.28387, 34.06493], [-118.28389, 34.06494], [-118.28391, 34.06496], [-118.2839, 34.06498], [-118.28387, 34.065]]], [[[-118.28411, 34.06451], [-118.28416, 34.06451], [-118.28418, 34.06452], [-118.28418, 34.06455], [-118.28398, 34.06487], [-118.28393, 34.06488], [-118.28391, 34.06483], [-118.28411, 34.06451]]]]} | Open Access 1 | 45818 | Occidental Parkway | 28837 | 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/parks/facility/occidentalParkwayPk.htm | Los Angeles 6 | 0.539 | Occidental Parkway | 0 | Local Recreation Area 3 | 4 |
16933 | 16933 | 16932 | {"type": "Polygon", "coordinates": [[[-118.45482, 34.21511], [-118.45417, 34.21512], [-118.45417, 34.21468], [-118.45441, 34.21468], [-118.45442, 34.2147], [-118.45482, 34.2147], [-118.45482, 34.21511]]]} | Open Access 1 | 25947 | Andres and Maria Cardenas Recreation Center | 28617 | 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/reccenter/facility/andresMariaRC.htm | Los Angeles 6 | 0.697 | Andres and Maria Cardenas Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
9130 | 9130 | 9129 | {"type": "Polygon", "coordinates": [[[-118.1982, 34.0513], [-118.19807, 34.0515], [-118.19808, 34.05158], [-118.19791, 34.05157], [-118.19774, 34.05153], [-118.19725, 34.05132], [-118.19747, 34.05098], [-118.1982, 34.0513]]]} | Restricted Access 2 | 15135 | Wabash Recreation Center | 28866 | 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.784 | Wabash Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
8277 | 8277 | 8276 | {"type": "Polygon", "coordinates": [[[-118.26691, 34.09233], [-118.26691, 34.09236], [-118.26676, 34.09258], [-118.2656, 34.09211], [-118.26575, 34.09207], [-118.26597, 34.09195], [-118.26602, 34.09195], [-118.26688, 34.09229], [-118.26691, 34.09233]]]} | Open Access 1 | 12659 | Silver Lake Recreation Center | 25488 | 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.877 | Silver Lake Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
7169 | 7169 | 7168 | {"type": "Polygon", "coordinates": [[[-118.50409, 34.09527], [-118.5041, 34.09539], [-118.50408, 34.09553], [-118.50389, 34.09616], [-118.50387, 34.0965], [-118.50376, 34.0969], [-118.50375, 34.09712], [-118.50371, 34.09712], [-118.5037, 34.09707], [-118.50362, 34.09707], [-118.50363, 34.09692], [-118.50374, 34.09653], [-118.50377, 34.09614], [-118.50396, 34.09549], [-118.50397, 34.09527], [-118.50389, 34.09486], [-118.50364, 34.09423], [-118.50374, 34.09421], [-118.50392, 34.0946], [-118.50404, 34.09495], [-118.50409, 34.09527]]]} | Open Access 1 | 6383 | Mandeville Canyon Open Space | 21739 | 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.925 | Mandeville Canyon OS | 0 | Local Recreation Area 3 | 4 | |
16932 | 16932 | 16931 | {"type": "Polygon", "coordinates": [[[-118.28341, 33.74301], [-118.28271, 33.74301], [-118.28272, 33.74245], [-118.28339, 33.74246], [-118.28341, 33.74249], [-118.28341, 33.74301]]]} | Open Access 1 | 46872 | Rancho San Pedro Recreation Center | 30349 | 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.985 | Rancho San Pedro Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
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 | |
7907 | 7907 | 7906 | {"type": "Polygon", "coordinates": [[[-118.38532, 34.04891], [-118.38454, 34.05009], [-118.38451, 34.0501], [-118.38448, 34.0501], [-118.38446, 34.05007], [-118.38463, 34.04893], [-118.38475, 34.0488], [-118.38532, 34.04891]]]} | Open Access 1 | 10207 | Robertson Recreation Center | 24498 | 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.236 | Robertson Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
3181 | 3181 | 3180 | {"type": "Polygon", "coordinates": [[[-118.32975, 34.09132], [-118.32975, 34.09151], [-118.32899, 34.09152], [-118.32899, 34.09084], [-118.32975, 34.09084], [-118.32975, 34.09132]]]} | Open Access 1 | 1902 | Hollywood Recreation Center | 20054 | 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.295 | Hollywood 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 |
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 | |
17013 | 17013 | 17012 | {"type": "Polygon", "coordinates": [[[-118.28562, 33.73651], [-118.28561, 33.73685], [-118.28455, 33.73685], [-118.28456, 33.73651], [-118.28492, 33.7365], [-118.28492, 33.73611], [-118.28561, 33.73611], [-118.2856, 33.73648], [-118.28562, 33.73651]]]} | Open Access 1 | 5894 | Anderson Playground and Senior Citizen Center | 15480 | 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.615 | Anderson Playground and Senior Citizen Ctr. | 0 | Local Recreation Area 3 | 4 | |
16807 | 16807 | 16806 | {"type": "Polygon", "coordinates": [[[-118.25173, 34.02093], [-118.25148, 34.02131], [-118.25016, 34.02062], [-118.25047, 34.02028], [-118.25173, 34.02093]]]} | Open Access 1 | 15153 | Central Recreation Center | 17072 | 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.652 | Central Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
7865 | 7865 | 7864 | {"type": "Polygon", "coordinates": [[[-118.2415, 34.06352], [-118.24093, 34.0646], [-118.24034, 34.06439], [-118.24089, 34.06331], [-118.2415, 34.06352]]]} | Open Access 1 | 45724 | Alpine Park and Recreation Center | 30744 | 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/reccenter/facility/alpineRC.htm | Los Angeles 6 | 1.936 | Alpine Park and 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 | |
7552 | 7552 | 7551 | {"type": "MultiPolygon", "coordinates": [[[[-118.47493, 34.12552], [-118.47447, 34.12605], [-118.47402, 34.12645], [-118.474, 34.12642], [-118.47417, 34.12576], [-118.47439, 34.12544], [-118.47465, 34.12535], [-118.47493, 34.12552]]], [[[-118.47699, 34.12316], [-118.47679, 34.12337], [-118.47611, 34.12426], [-118.47573, 34.12467], [-118.47575, 34.12458], [-118.47616, 34.12407], [-118.47611, 34.1237], [-118.47615, 34.12347], [-118.47673, 34.12322], [-118.47699, 34.12316]]], [[[-118.47826, 34.12206], [-118.47809, 34.12238], [-118.47786, 34.12238], [-118.47801, 34.12212], [-118.47826, 34.12206]]]]} | Open Access 1 | 7162 | Sepulveda Pass Open Space | 25306 | 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.135 | Sepulveda Pass OS | 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]);