units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
101 rows where DES_TP = 2 and MNG_AGENCY = 294 sorted by map
This data as json, copyable, CSV (advanced)
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 81
MNG_AGENCY 1
- Long Beach, City of · 81 ✖
DES_TP 1
- Local Park · 81 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2714 | 2714 | 2713 | {"type": "MultiPolygon", "coordinates": [[[[-118.21183, 33.82355], [-118.21117, 33.82355], [-118.21118, 33.82341], [-118.21183, 33.82341], [-118.21183, 33.82355]]], [[[-118.21441, 33.82237], [-118.21313, 33.8242], [-118.21309, 33.82422], [-118.21282, 33.82418], [-118.21282, 33.82385], [-118.21441, 33.82237]]]]} | Open Access 1 | 6689 | Tanaka Park | 26179 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.624 | Tanaka Park | 0 | Local Park 2 | 4 | |
5166 | 5166 | 5165 | {"type": "Polygon", "coordinates": [[[-118.07283, 33.81486], [-118.07254, 33.81515], [-118.07246, 33.81527], [-118.07239, 33.81542], [-118.07195, 33.8153], [-118.07283, 33.81486]]]} | Open Access 1 | 6690 | Lilly Park | 21238 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.332 | Lilly Park | 0 | Local Park 2 | 4 | |
4318 | 4318 | 4317 | {"type": "Polygon", "coordinates": [[[-118.0838, 33.8066], [-118.08379, 33.80859], [-118.08207, 33.80859], [-118.08208, 33.80794], [-118.08217, 33.80718], [-118.08229, 33.80687], [-118.08247, 33.8066], [-118.0838, 33.8066]]]} | Restricted Access 2 | 48251 | El Dorado Community Gardens | 32803 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 8.255 | El Dorado Community Gardens | 0 | Local Park 2 | 4 | |
16815 | 16815 | 16814 | {"type": "Polygon", "coordinates": [[[-118.09007, 33.81023], [-118.0898, 33.81023], [-118.08979, 33.81025], [-118.08952, 33.81025], [-118.08951, 33.81028], [-118.08938, 33.81028], [-118.08938, 33.81031], [-118.089, 33.81031], [-118.08899, 33.81032], [-118.087, 33.81031], [-118.08681, 33.8103], [-118.08646, 33.81026], [-118.08528, 33.81025], [-118.08526, 33.80869], [-118.08528, 33.80858], [-118.08528, 33.80779], [-118.0838, 33.8078], [-118.08379, 33.8066], [-118.08225, 33.8066], [-118.0825, 33.80624], [-118.08262, 33.8061], [-118.08326, 33.80558], [-118.08379, 33.80511], [-118.08429, 33.80462], [-118.0848, 33.80407], [-118.08488, 33.80402], [-118.085, 33.80397], [-118.08519, 33.80394], [-118.08609, 33.80401], [-118.0878, 33.80432], [-118.08845, 33.8044], [-118.08879, 33.80441], [-118.08879, 33.80434], [-118.08978, 33.80435], [-118.09007, 33.81023]]]} | Open Access 1 | 6665 | El Dorado Nature Center | 18502 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 87.546 | El Dorado Nature Ctr. | 1998 | Local Park 2 | 4 | |
11512 | 11512 | 11511 | {"type": "Polygon", "coordinates": [[[-118.0907, 33.82486], [-118.09069, 33.82685], [-118.09002, 33.82684], [-118.09001, 33.82754], [-118.08923, 33.8273], [-118.08925, 33.82484], [-118.0907, 33.82486]]]} | No Public Access 3 | 48217 | El Dorado East Regional Park | 32766 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 8.523 | El Dorado East RP | 0 | Local Park 2 | 4 | |
3981 | 3981 | 3980 | {"type": "Polygon", "coordinates": [[[-118.09099, 33.82783], [-118.09001, 33.82754], [-118.09002, 33.82684], [-118.0909, 33.82686], [-118.09099, 33.82783]]]} | Open Access 1 | 46620 | Gemmrig Park | 29935 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.955 | Gemmrig Park | 0 | Local Park 2 | 4 | |
15099 | 15099 | 15098 | {"type": "Polygon", "coordinates": [[[-118.09898, 33.80692], [-118.09897, 33.80754], [-118.09893, 33.80755], [-118.09861, 33.80755], [-118.09855, 33.80754], [-118.0985, 33.80752], [-118.09845, 33.80743], [-118.09845, 33.807], [-118.09847, 33.80695], [-118.09853, 33.80691], [-118.0986, 33.8069], [-118.09893, 33.8069], [-118.09898, 33.80692]]]} | Open Access 1 | 45891 | Good Neighbor Park | 28968 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/Park/Park-and-Facilities/Directory/Good-Neighbor-Park/ | Los Angeles 6 | 0.84 | Good Neighbor Park | 0 | Local Park 2 | 4 |
7341 | 7341 | 7340 | {"type": "Polygon", "coordinates": [[[-118.09912, 33.77631], [-118.09911, 33.77677], [-118.09895, 33.77678], [-118.09833, 33.77779], [-118.09836, 33.7755], [-118.09895, 33.77631], [-118.09912, 33.77631]]]} | Open Access 1 | 6660 | College Estates Park | 17500 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 2.3 | College Estates Park | 0 | Local Park 2 | 4 | |
7355 | 7355 | 7354 | {"type": "Polygon", "coordinates": [[[-118.10496, 33.76788], [-118.10478, 33.76807], [-118.10463, 33.76829], [-118.10453, 33.76851], [-118.10446, 33.76881], [-118.10442, 33.76956], [-118.1044, 33.77172], [-118.10433, 33.77169], [-118.10426, 33.7717], [-118.1042, 33.77174], [-118.10417, 33.77181], [-118.1042, 33.77187], [-118.10426, 33.77192], [-118.10435, 33.77192], [-118.10441, 33.77189], [-118.1044, 33.77411], [-118.10409, 33.77412], [-118.10408, 33.77402], [-118.10409, 33.76939], [-118.10411, 33.76887], [-118.10418, 33.76857], [-118.1043, 33.76826], [-118.10441, 33.76807], [-118.10453, 33.7679], [-118.10471, 33.76769], [-118.10488, 33.76753], [-118.10488, 33.76751], [-118.10482, 33.76748], [-118.10486, 33.76746], [-118.105, 33.76749], [-118.10504, 33.76752], [-118.10503, 33.76755], [-118.10488, 33.7677], [-118.10487, 33.76774], [-118.10488, 33.76781], [-118.10496, 33.76788]]]} | Open Access 1 | 6680 | Channel View Park | 17123 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 5.302 | Channel View Park | 1968 | Local Park 2 | 4 | |
15094 | 15094 | 15093 | {"type": "Polygon", "coordinates": [[[-118.10508, 33.83028], [-118.10508, 33.83056], [-118.10362, 33.83055], [-118.10362, 33.83028], [-118.10508, 33.83028]]]} | Open Access 1 | 45881 | Birdcage Park | 28957 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/Park/Park-and-Facilities/Directory/Birdcage-Park/ | Los Angeles 6 | 1.034 | Birdcage Park | 0 | Local Park 2 | 4 |
15110 | 15110 | 15109 | {"type": "Polygon", "coordinates": [[[-118.11318, 33.75143], [-118.11287, 33.75143], [-118.11283, 33.75139], [-118.11283, 33.75133], [-118.11296, 33.75122], [-118.11318, 33.75143]]]} | Open Access 1 | 45912 | Maurice 'Mossy' Kent Park | 28987 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/park-and-facilities/directory/mossy-kent-park/ | Los Angeles 6 | 0.108 | Maurice 'Mossy' Kent Park | 0 | Local Park 2 | 4 |
15107 | 15107 | 15106 | {"type": "Polygon", "coordinates": [[[-118.11478, 33.75315], [-118.11414, 33.75364], [-118.11355, 33.7531], [-118.11356, 33.7529], [-118.11459, 33.75211], [-118.11469, 33.75221], [-118.11463, 33.75219], [-118.11458, 33.75219], [-118.11362, 33.75292], [-118.11361, 33.75308], [-118.11414, 33.75356], [-118.11474, 33.75311], [-118.11478, 33.75315]]]} | Open Access 1 | 45907 | Lookout Park | 28983 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.467 | Lookout Park | 0 | Local Park 2 | 4 | |
982 | 982 | 981 | {"type": "Polygon", "coordinates": [[[-118.1171, 33.74531], [-118.11692, 33.74554], [-118.11665, 33.7454], [-118.11684, 33.74516], [-118.1171, 33.74531]]]} | Open Access 1 | 6681 | Alamitos Park | 15315 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.225 | Alamitos Park | 0 | Local Park 2 | 4 | |
14942 | 14942 | 14941 | {"type": "Polygon", "coordinates": [[[-118.11811, 33.76285], [-118.11631, 33.76422], [-118.11624, 33.76415], [-118.11618, 33.76418], [-118.11611, 33.76416], [-118.11597, 33.76427], [-118.11571, 33.76358], [-118.11587, 33.76352], [-118.1161, 33.76331], [-118.11638, 33.76318], [-118.11666, 33.76312], [-118.1168, 33.76307], [-118.11682, 33.76311], [-118.11628, 33.7633], [-118.11636, 33.76346], [-118.11659, 33.76339], [-118.11663, 33.76345], [-118.11677, 33.76341], [-118.11675, 33.76333], [-118.11691, 33.76328], [-118.1169, 33.76324], [-118.117, 33.7632], [-118.11694, 33.76308], [-118.11685, 33.76311], [-118.11683, 33.76306], [-118.11754, 33.76277], [-118.11791, 33.76267], [-118.11811, 33.76285]]]} | Open Access 1 | 45541 | Jack Nichol Park | 28370 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 3.508 | Jack Nichol Park | 2007 | Local Park 2 | 4 | |
15392 | 15392 | 15391 | {"type": "Polygon", "coordinates": [[[-118.11977, 33.76092], [-118.11936, 33.76122], [-118.11897, 33.76132], [-118.11864, 33.76148], [-118.1184, 33.76157], [-118.11836, 33.76161], [-118.11829, 33.76175], [-118.11825, 33.76178], [-118.11814, 33.7618], [-118.11783, 33.76151], [-118.11805, 33.76134], [-118.11853, 33.76125], [-118.1189, 33.76111], [-118.11927, 33.76109], [-118.11934, 33.76106], [-118.11943, 33.76114], [-118.11949, 33.76108], [-118.11965, 33.76081], [-118.11977, 33.76092]]]} | Open Access 1 | 46611 | Marina Pacifica Park | 29922 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.136 | Marina Pacifica Park | 0 | Local Park 2 | 4 | |
977 | 977 | 976 | {"type": "Polygon", "coordinates": [[[-118.1256, 33.75282], [-118.12556, 33.75298], [-118.12512, 33.75279], [-118.1256, 33.75282], [-118.1256, 33.75282]]]} | Open Access 1 | 6656 | Treasure Island Park | 26519 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.102 | Treasure Island Park | 0 | Local Park 2 | 4 | |
7340 | 7340 | 7339 | {"type": "Polygon", "coordinates": [[[-118.12671, 33.7698], [-118.12625, 33.76903], [-118.12654, 33.76867], [-118.12596, 33.76849], [-118.12615, 33.76802], [-118.12599, 33.76797], [-118.126, 33.76796], [-118.12631, 33.76806], [-118.1267, 33.76827], [-118.1269, 33.76836], [-118.12715, 33.76844], [-118.12738, 33.76848], [-118.12774, 33.76849], [-118.12912, 33.7684], [-118.12935, 33.76843], [-118.12968, 33.76852], [-118.12989, 33.76855], [-118.13092, 33.76859], [-118.13105, 33.76861], [-118.13121, 33.76866], [-118.13156, 33.7689], [-118.13167, 33.76904], [-118.13173, 33.76923], [-118.13172, 33.76937], [-118.13166, 33.76953], [-118.13146, 33.76962], [-118.1313, 33.76975], [-118.13122, 33.7698], [-118.12671, 33.7698]]]} | Open Access 1 | 6655 | Marina Vista Park | 21841 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 17.572 | Marina Vista Park | 0 | Local Park 2 | 4 | |
7346 | 7346 | 7345 | {"type": "Polygon", "coordinates": [[[-118.12859, 33.79721], [-118.12818, 33.79721], [-118.12654, 33.79721], [-118.12693, 33.79678], [-118.12699, 33.79668], [-118.12703, 33.79654], [-118.12704, 33.79618], [-118.12708, 33.79614], [-118.12853, 33.79614], [-118.12859, 33.79616], [-118.12861, 33.79621], [-118.12859, 33.79721]]]} | Open Access 1 | 6668 | Los Altos Park | 21474 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 4.61 | Los Altos Park | 0 | Local Park 2 | 4 | |
7353 | 7353 | 7352 | {"type": "Polygon", "coordinates": [[[-118.12999, 33.81894], [-118.12997, 33.82212], [-118.12801, 33.82211], [-118.12799, 33.8221], [-118.12797, 33.82208], [-118.12797, 33.82135], [-118.12799, 33.81897], [-118.12804, 33.81894], [-118.12999, 33.81894]]]} | Open Access 1 | 6677 | Wardlow Park | 27258 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 16.103 | Wardlow Park | 0 | Local Park 2 | 4 | |
7343 | 7343 | 7342 | {"type": "Polygon", "coordinates": [[[-118.13132, 33.78375], [-118.13112, 33.78358], [-118.13112, 33.78353], [-118.13131, 33.78342], [-118.13151, 33.78334], [-118.13174, 33.78331], [-118.13181, 33.78335], [-118.13182, 33.7834], [-118.1318, 33.78348], [-118.13176, 33.78363], [-118.1317, 33.78373], [-118.13156, 33.7839], [-118.1315, 33.7839], [-118.13132, 33.78375]]]} | Open Access 1 | 6662 | Los Altos Plaza Park | 21475 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.638 | Los Altos Plaza 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]);