units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
115 rows where AGNCY_LEV = 2, DES_TP = 3 and MNG_AGENCY = 24 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
ACCESS_TYP 3
- Open Access 104
- Restricted Access 10
- No Public Access 1
MNG_AGENCY 1
- Los Angeles, City of · 115 ✖
DES_TP 1
- Local Recreation Area · 115 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
999 | 999 | 998 | {"type": "Polygon", "coordinates": [[[-118.24932, 33.93589], [-118.24931, 33.93673], [-118.24783, 33.93674], [-118.24784, 33.93589], [-118.24932, 33.93589]]]} | Open Access 1 | 6218 | 109th Street Recreation Center | 15168 | 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.184 | 109th Street Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
7130 | 7130 | 7129 | {"type": "Polygon", "coordinates": [[[-118.28686, 33.95825], [-118.28478, 33.95826], [-118.28477, 33.95515], [-118.28686, 33.95513], [-118.28685, 33.95598], [-118.28686, 33.95825]]]} | Open Access 1 | 6214 | Algin Sutton Recreation Center | 15356 | 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 | 16.444 | Algin Sutton 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 | |
294 | 294 | 293 | {"type": "Polygon", "coordinates": [[[-118.36564, 34.02332], [-118.36557, 34.02447], [-118.36551, 34.02475], [-118.36542, 34.02503], [-118.36317, 34.02482], [-118.36308, 34.02548], [-118.3629, 34.02546], [-118.36318, 34.02338], [-118.36465, 34.02338], [-118.36466, 34.02331], [-118.36564, 34.02332]]]} | Open Access 1 | 788 | Baldwin Hills Recreation Center | 15776 | 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.253 | Baldwin Hills Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
7859 | 7859 | 7858 | {"type": "MultiPolygon", "coordinates": [[[[-118.46843, 34.06341], [-118.46752, 34.06354], [-118.46768, 34.06439], [-118.46705, 34.06446], [-118.4662, 34.06345], [-118.46615, 34.06137], [-118.46801, 34.0612], [-118.46843, 34.06341]], [[-118.46822, 34.06256], [-118.46823, 34.06254], [-118.46777, 34.06236], [-118.46743, 34.06218], [-118.46714, 34.06195], [-118.4668, 34.0616], [-118.46643, 34.06159], [-118.46637, 34.06162], [-118.46632, 34.0617], [-118.46632, 34.062], [-118.46702, 34.06192], [-118.46719, 34.06218], [-118.46727, 34.0626], [-118.46734, 34.06263], [-118.46745, 34.06306], [-118.46759, 34.06303], [-118.46752, 34.06265], [-118.46784, 34.06262], [-118.46822, 34.06256]]], [[[-118.47003, 34.06038], [-118.46961, 34.06142], [-118.47002, 34.0619], [-118.46857, 34.0624], [-118.46866, 34.06209], [-118.46868, 34.06182], [-118.46866, 34.06166], [-118.46849, 34.06075], [-118.47003, 34.06038]]]]} | Open Access 1 | 45701 | Barrington Recreation Center | 15835 | 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/barringtonRC.htm | Los Angeles 6 | 17.099 | Barrington Rec. 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 | |
9391 | 9391 | 9390 | {"type": "Polygon", "coordinates": [[[-118.41232, 34.04556], [-118.4122, 34.04566], [-118.41134, 34.0462], [-118.41122, 34.04639], [-118.41049, 34.04727], [-118.41012, 34.04771], [-118.40947, 34.04839], [-118.40568, 34.04382], [-118.40567, 34.04378], [-118.40569, 34.04375], [-118.40691, 34.04308], [-118.40754, 34.04391], [-118.40772, 34.04398], [-118.40826, 34.04398], [-118.40863, 34.04405], [-118.40952, 34.04518], [-118.41007, 34.0452], [-118.41049, 34.04518], [-118.4113, 34.04507], [-118.41196, 34.04482], [-118.4123, 34.04532], [-118.41232, 34.04556]]]} | Open Access 1 | 15706 | Cheviot Hills Park and Recreation Center | 17185 | 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 | 34.166 | Cheviot Hills Park and Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
9990 | 9990 | 9989 | {"type": "Polygon", "coordinates": [[[-118.30462, 34.02364], [-118.30314, 34.02363], [-118.30313, 34.02288], [-118.30462, 34.02289], [-118.30462, 34.02364]]]} | Open Access 1 | 18556 | Denker Recreation Center | 18085 | 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.81 | Denker Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
16974 | 16974 | 16973 | {"type": "MultiPolygon", "coordinates": [[[[-118.22363, 34.07096], [-118.22308, 34.0712], [-118.22285, 34.07084], [-118.22221, 34.07112], [-118.22203, 34.07083], [-118.2225, 34.07061], [-118.22205, 34.06988], [-118.22277, 34.06957], [-118.22363, 34.07096]]], [[[-118.22415, 34.07179], [-118.22314, 34.07164], [-118.22307, 34.07151], [-118.22402, 34.0711], [-118.22415, 34.07179]]]]} | Open Access 1 | 6927 | Downey Playground and Recreation Center | 18255 | 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.549 | Downey Playground and Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
17061 | 17061 | 17060 | {"type": "Polygon", "coordinates": [[[-118.18962, 34.14217], [-118.18947, 34.14226], [-118.18929, 34.14243], [-118.18907, 34.14278], [-118.18904, 34.1429], [-118.18898, 34.14331], [-118.1889, 34.14346], [-118.18882, 34.14354], [-118.18874, 34.14359], [-118.18865, 34.14363], [-118.1885, 34.14366], [-118.18835, 34.14366], [-118.1882, 34.14362], [-118.18745, 34.14325], [-118.18624, 34.14242], [-118.18638, 34.1418], [-118.18647, 34.14153], [-118.18666, 34.14107], [-118.18684, 34.14075], [-118.18737, 34.14048], [-118.1888, 34.13965], [-118.18904, 34.14048], [-118.18919, 34.14068], [-118.18922, 34.14076], [-118.18929, 34.14098], [-118.18929, 34.1411], [-118.18962, 34.14217]]]} | Open Access 1 | 6962 | Eagle Rock Recreation Center | 18347 | 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 | 21.266 | Eagle Rock Rec. Ctr. | 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 | |
3572 | 3572 | 3571 | {"type": "Polygon", "coordinates": [[[-118.4037, 34.2292], [-118.40363, 34.22925], [-118.40364, 34.22929], [-118.40362, 34.22931], [-118.40221, 34.23034], [-118.40077, 34.22897], [-118.40228, 34.22787], [-118.4037, 34.2292]]]} | Open Access 1 | 519 | Fernangeles Recreation Center | 18880 | 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.262 | Fernangeles Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
2907 | 2907 | 2906 | {"type": "Polygon", "coordinates": [[[-118.2343, 34.11538], [-118.23311, 34.11682], [-118.23255, 34.1176], [-118.23164, 34.11715], [-118.23068, 34.11666], [-118.2302, 34.11658], [-118.23129, 34.11609], [-118.2325, 34.11535], [-118.23326, 34.1146], [-118.23381, 34.11501], [-118.23351, 34.11525], [-118.23351, 34.11526], [-118.23352, 34.11527], [-118.23383, 34.11503], [-118.2343, 34.11538]]]} | Open Access 1 | 1011 | Glassell Park and Recreation Center | 19309 | 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/glassellParkRC.htm | Los Angeles 6 | 12.663 | Glassell Park and Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
7194 | 7194 | 7193 | {"type": "Polygon", "coordinates": [[[-118.34172, 34.25537], [-118.34043, 34.2563], [-118.34044, 34.25641], [-118.34035, 34.25673], [-118.34035, 34.25683], [-118.34042, 34.25704], [-118.34042, 34.25714], [-118.34039, 34.2572], [-118.34031, 34.25726], [-118.34008, 34.25733], [-118.34003, 34.25738], [-118.3399, 34.25768], [-118.33994, 34.25797], [-118.33988, 34.25807], [-118.33974, 34.25819], [-118.3397, 34.25824], [-118.33977, 34.25865], [-118.33975, 34.25872], [-118.33969, 34.2588], [-118.33959, 34.25885], [-118.33944, 34.25885], [-118.33898, 34.25859], [-118.3389, 34.25857], [-118.33883, 34.25857], [-118.3382, 34.2587], [-118.3377, 34.25897], [-118.3376, 34.25898], [-118.33701, 34.2589], [-118.3369, 34.25892], [-118.3367, 34.25901], [-118.33652, 34.25903], [-118.33522, 34.25891], [-118.33481, 34.25879], [-118.3345, 34.25867], [-118.33443, 34.25863], [-118.33438, 34.25854], [-118.33438, 34.25848], [-118.33441, 34.25841], [-118.33441, 34.25829], [-118.33439, 34.25817], [-118.33437, 34.25814], [-118.3343, 34.2581], [-118.33423, 34.25811], [-118.33402, 34.25796], [-118.33282, 34.25776], [-118.33176, 34.25745], [-118.33175, 34.25642], [-118.33162, 34.25606], [-118.33187, 34.2553], [-118.33131, 34.25461], [-118.33174, 34.2526], [-118.33464, 34.25337], [-118.34172, 34.25537]]]} | No Public Access 3 | 6842 | Green Verdugo Reservoir | 19469 | 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 | 105.007 | Green Verdugo Reservoir | 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 | |
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 | |
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 | |
3902 | 3902 | 3901 | {"type": "MultiPolygon", "coordinates": [[[[-118.28275, 34.03276], [-118.28253, 34.0331], [-118.28239, 34.03304], [-118.28261, 34.03269], [-118.28275, 34.03276]]], [[[-118.28381, 34.033], [-118.28378, 34.03302], [-118.2827, 34.03255], [-118.28329, 34.0316], [-118.28337, 34.03159], [-118.28376, 34.03176], [-118.2838, 34.03182], [-118.28381, 34.033]]], [[[-118.2838, 34.03365], [-118.28341, 34.03348], [-118.28363, 34.03314], [-118.28377, 34.0332], [-118.2838, 34.03324], [-118.2838, 34.03365]]]]} | Open Access 1 | 1924 | Hoover Recreation Center | 20083 | 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.988 | Hoover Rec. Ctr. | 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]);