Project Funding & Visualization for New York

Description: 
This mashup analyzes the most funded cities in New York based on community projects. We then create a visual representation of the types of projects that are occurring within these cities via WordCloud.
 

City Funding Chart

All senator sponsored projects within the cities of New York were queried. All of the appropriations regarding those projects and the cities in which they were occurring were summed up. Those summations yielded the 10 cities that received the most funding from senators within the past year. Below is the chart listing those cities and the amount of money invested in them through community projects. By hovering over each city column, a visual representation of the projects occurring within those cities will populate below via WordCloud.

Loading Chart ...


Project Word Cloud

Loading Cloud...


Conclusions

Based on the word cloud we see what these projects are focusing on within each city. We can visually see the needs of these cities and why they attract the attention that they do. These concentrated areas are projects for youth, development, education, as well as community among others. It is possible that within these cities these are the areas where the city needs to make the biggest improvement. Once more semantic data becomes available, such as the education level of New Yorkers, these conclusions can be tested.



Thumbnail: 
AttachmentSize
Bronx_query.sparql690 bytes
Albany_query.sparql691 bytes
Brooklyn_query.sparql693 bytes
Syracuse_query.sparql693 bytes
New_York_query.sparql691 bytes
10bargraph.sparql600 bytes
Buffalo_query.sparql692 bytes
Flushing_query.sparql693 bytes
Jamaica_query.sparql692 bytes
White_Plains_query.sparql697 bytes
Yonkers_query.sparql692 bytes
Your rating: None Average: 5 (2 votes)

Warning: Table './drupal/watchdog' is marked as crashed and last (automatic?) repair failed query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:372:\"Table './drupal/accesslog' is marked as crashed and last (automatic?) repair failed\nquery: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('Project Funding & Visualization for New York', 'node/4167', '', '10.0.1.254', 0, '78p4ltmtnkl3cuhnra3msnnu47', 55, 1575577886)\";s:5:\"%file\";s:58:\"/data/www/html/drupal/modules/statistics/statistics.module\";s:5:\"%line\";i:63;}', 3, '', 'https://logd.tw.rpi.edu/d in /data/www/html/drupal/includes/database.mysqli.inc on line 134