By leveraging MemSQL in-memory capabilities with new geospatial analysis and Apache Spark, Esri was able to create a geolocation heatmap that visualizes valuable data intelligence such as the average speed of a taxi ride, where the worst traffic jams occur in NYC and flow of traffic during workdays and weekends.
"The possibilities behind real-time geospatial intelligence are endless," said Mansour Raad, big data advocate and senior software architect at Esri. "In this particular case, we were able to use open transportation data to derive meaningful, actionable intelligence quickly and in real-time. This kind of analysis can redefine the way urban developers resolve traffic congestion issues or help taxi businesses improve their efficiency with supply or demand of cabs depending on time of day and flow of traffic."
See it in person
What: The Esri, MemSQL and Spark live-demonstration of geospatial intelligence leveraging open data sets from 170 million real-world NYC taxi rides.
When: Wednesday, March 18, 2015 at TRACK B -- Applications from 4:30 p.m. to 5:00 p.m. ET
Where: Spark Summit 2015, The Sheraton New York Times Square, 811 7th Avenue at 53rd Street New York, NY.
About Spark Summit East
The Spark Summit is an event to bring the Apache Spark community together. Attendees will hear from leading production users of Spark, SparkSQL, Spark Streaming and related projects, find out where the project development is going and learn how to use the Spark stack in a variety of applications.
Since 1969, Esri has been giving customers around the world the power to think and plan geographically. The market leader in GIS, Esri software is used in more than 350,000 organizations worldwide including each of the 200 largest cities in the United States, most national governments, more than two-thirds of Fortune 500 companies, and more than 7,000 colleges and universities. Esri applications, running on more than one million desktops and thousands of Web and enterprise servers, provide the backbone for the world's mapping and spatial analysis. Esri is the only vendor that provides complete technical solutions for desktop, mobile, server, and Internet platforms. Visit us at www.esri.com.
MemSQL is the leader in real-time databases for transactions and analytics.
As a purpose built database for instant access to real-time and historical data, MemSQL uses a familiar SQL interface and a horizontally scalable distributed architecture that runs on commodity hardware or in the cloud.
Innovative enterprises use MemSQL to better predict and react to opportunities by extracting previously untapped value in their data to drive new revenue.
MemSQL is proven in production environments across hundreds of nodes in high velocity Big Data environments.
Based in San Francisco, MemSQL is a Y Combinator company funded by prominent investors including Accel Partners, Khosla Ventures, First Round Capital and Data Collective. Follow us @MemSQL or visit at www.memsql.com.