March 2016 Summaries

What is constantly increasing its volume variety and velocity and greatly effects your business's bottom line if not properly utilized? Big Data! At CartoDB, our technology allows you to filter and drill-down hundred of millions of data points and provide actionable analysis like never before. We are dedicating a whole week to show you the benefits of big data analysis, featuring blog posts, a white paper, a webinar about Deep Insights, an exclusive event, and more! To stay in the loop, follow us on social media networks using the hashtag #CartoDBforBigData and check our blog for interesting and informative content. Our EMEA Sales Director will be hosting a 45-minute webinar next Thursday to demonstrate how to manage and analyze data, create a widgets' dashboard, and achieve tangible benefits.

To get started with CartoDB's native mobile SDK, developers need to register an account at developer.nutiteq.com, which requires re-registering on cartodb.com as well. The process involves selecting a package, developing the app, sharing it, and publishing it to the app store or sharing privately within an enterprise. The development process includes accessing resources such as guides, code samples, sample projects, and support channels like StackOverflow and public forums. The guidelines for the Nutiteq Maps SDK are currently available on developer.nutiteq.com and will soon be included in CartoDB's developer documentation.

Improve your (musical) timing with CartoDB Time Isolines and derive the best data insights The CartoDB platform now offers a new feature called Time and Distance Isolines, which allows users to measure time directly through SQL statements. This feature provides insight and analysis on how long it takes pedestrians to move from one hotspot to another, making tactical business planning easier. By visualizing this data, businesses can determine the most efficient way to spend their time, as time is money. The feature was tested with SXSW music events, where it showed how much time it takes to get from each venue and hotel to other entertainment spots. To use this feature, users must scrape data from a website using node.js and libraries like request, cheerio, and underscore, then upload the data to a PostgreSQL table using CartoDB's Import API. The addresses of the venues are automatically geocoded in the process, converting raw data into geo-data that can be put on a map with the CartoDB Editor. Users can create isolines for each hotspot by calling the cdb_isochrone function, and they can also use this feature to show synthetical lists of closest events from a given venue. The app also incorporates data from Spotify's REST API to match SXSW artist names to song samples and artist visuals. The app is built using CartoDB.js as the nerve center, with heavy use of templating using underscore.js to allow for dynamic HTML elements and SQL requests to CartoDB SQL APIs.

CartoDB, a location intelligence company, is expanding its team with 10 open positions in various departments such as Marketing, Sales, and Product, across its New York and Madrid offices. The company has welcomed several new faces, including Rafael Martin Soriano, who joined from SeedRocket, a startup accelerator, bringing his experience as an account executive to help customers integrate location intelligence into their organizations. Ramiro Aznar Ballarin, the newest solutions engineer, comes from a participatory urban planning studio and is eager to apply his GIS expertise to develop proofs-of-concept using customer data. Rafael Porres Molina, who joined from Amazon Web Services in Dublin, ensures the product's responsiveness and reliability, particularly for large-scale traffic, and appreciates CartoDB's work in the open source community and its user-centric approach. These new team members are expected to bring their unique skills and passions to the company, including a love for sports, music, and origami.

Transform Millions of Data into Actionable Insights CartoDB's Deep Insights technology enables the visualization, dynamic filtering, and exploration of large location datasets at a groundbreaking scale in a single all-in-one visualization solution. This solution empowers everyone to instantly visualize big data patterns and trends that otherwise would not have been identifiable. CartoDB for Deep Insights helps organizations discover patterns, trends, and connections by managing and analyzing their data effectively, creating dashboards based on business needs, and providing tangible benefits. The webinar will be hosted by Jaime de Mora EMEA Sales Director at CartoDB to share examples of different use cases that already utilize this solution.

By leveraging US census data in CARTO's Data Observatory, researchers have been able to visualize Airbnb's impact on neighborhoods at a block-by-block level. The analysis reveals that while Airbnb listings are concentrated in centrally-located city areas, their effect on neighborhoods is more nuanced, with high-density neighborhoods like Manhattan's Upper East Side and Lower East Side experiencing lower rates of Airbnb listings per square mile due to existing large stock of apartments. In contrast, lower-density neighborhoods like Brooklyn's Williamsburg and Greenpoint are more susceptible to impact from Airbnb listings. The study also found that areas with high profitability clusters, such as Chinatown and Manhattan Valley, have median Airbnb listing prices that cost 25% of median rent, allowing residents to easily pay a month's rent in just four days. These findings provide new insights into the effects of the sharing economy on neighborhoods and can be applied to other cities across the US.

CartoDB takes Barcelona by Storm, again! We can still feel our presence in Barcelona after MWC 2016 and we keep coming back for more of that great energy. CartoDB is one of the 30 most disruptive Fintech Startups selected by an expert group in a single event. eFintech Show is an important conference for the business intelligence community, where our CPO will be speaking on ‘Location the Missing Dimension in Fintech Data.’ He'll focus on how big data analytics can capture and process large amounts of information daily, allowing companies to create products tailored to each customer's needs in real time. This event comes at a significant time for finance firms looking to leverage advanced spatial analytics and social data to achieve accurate risk management and gain a competitive edge.

The author created maps showing walking routes for people in Brooklyn to their nearest L train stop, using data from the US Census and LODES dataset. They used Valhalla's routing solution to generate pedestrian routes, but found that with many overlapping segments, it was difficult to gauge the number of people along each route. To address this issue, they developed a PL/PGSQL function to segment the lines into straight parts with no turns, and then aggregated the data to style the routes by line thickness and color based on the number of commuters and maximum commute time along each segment. The final map shows powerful and impactful visualizations of the walking commutes, allowing users to better understand the impact of the L train closure on local communities.

The US Census provides a wealth of detailed information about the population, but its packaged data lacks sufficient attributes to answer certain questions. Machine learning can help overcome this limitation by upsampling the data to finer spatial resolutions, such as Census Block Groups. By using a predictive model trained on PUMAS data at a coarser scale, the model can be applied to the Census Block Group level to create new variables and produce maps of specific populations, like those with vision and hearing problems. This approach enables segmentation, which is valuable for various applications, including non-profits, businesses, and election campaigns.

This meetup aims to explore creative cartography and its connections to other fields such as design, coding, and journalism. It will feature a lineup of speakers from various backgrounds, including award-winning dataviz studios, collaborators of Le Monde, and experts in technical black magic. The event is hosted at Le Tank, a co-working space that promotes diversity and brings complex topics to a mainstream audience. CartoDB is supporting the event and invites attendees to meet Erik, who will be presenting on complex datasets using technical techniques.

CartoDB is a leading location intelligence platform that helps organizations unlock insights from their location data, but only 10% of companies are currently utilizing it. The company aims to change this by providing solutions and business intelligence for its users. CartoDB's CEO Javier de la Torre presented at Data Driven NYC event on February 16, 2016, showcasing real examples of using location data to solve complex problems, highlighting the rapidly changing nature of the location intelligence market. The platform enables transformation of location data into valuable insights, and CartoDB is well-positioned to capitalize on the growing demand for location-based solutions.

To make insightful dot density visualizations, users can explore CARTO's blog post on spatial data visualization and learn how to create them using SQL. By applying a PLPGSQL function to census block group data, users can turn geometries and counts into points that convey the diversity of ethnic groups across the US. This method is particularly useful for smaller areas where computation time is manageable, allowing for powerful insights into population demographics.

This month, Plushcap announces its acquisition of Nutiteq, a leader in SDK development for mobile platforms, and launches Deep Insights for big data analysis at any scale. In March, the company is hosting several webinars to help users leverage location data with CartoDB, providing actionable insights through Rilos, data-driven maps, market and trend analysis, visualization design, and more.