SF311 - Tweet Data Analysis

Summarization

The tweets cover a range of complaints and concerns about issues in San Francisco, including a junkie drug den on wheels, fallen trees, sewer backups, and stray pellets on the sidewalk. There are calls to action directed at SF311 and other city departments, with a focus on cleaning up the city and addressing safety hazards. Residents express frustration with the lack of progress and a perceived lack of action from public officials. There is also concern about the homeless population and the need for a plan to address their needs.

Topic Modeling

1. City cleanliness and maintenance (e.g. reporting tree problems, sewer backups, street flooding, cleaning up junk and tagging)
2. Safety and security (e.g. stealing power, blocking hydrants, traffic lights out, drug den on wheels)
3. Vagrancy and homelessness (e.g. junkies, shitbums, service resistance, no plan)
4. Government and public workers (e.g. thanking them for cleaning up damage, reporting to SF311 for assistance)
5. ADA violations and accessibility (e.g. dispatch call issues, traffic control officer needed)

Emotional Analysis

The tweets express a range of negative emotions including frustration, anger and disgust directed towards the city's services and officials for not addressing issues such as drug dens, junk piles, blocked streets, and power theft. However, some tweets showed appreciation towards the city's public workers who were cleaning up damage and keeping residents safe during storms. Many tweets also expressed concern for safety issues and pleaded for action to be taken.

Trend Analysis

1. Complaints about trash, junkies, and safety in certain areas of San Francisco
2. Appreciation for public workers who respond promptly to damage and safety issues
3. Requesting assistance from @SF311 for various issues such as power outages and traffic control
4. Reporting downed trees due to intense storms
5. Concerns about the increase in homeless issues and lack of a clear plan to address them