Tag Archives: Web mapping

CartoDB Rebranded as Carto

Community Health Maps has long recommended the use of CartoDB for those interested in low cost online mapping and data visualization. In fact, CHM caught the beginning of this wave because CartoDB wasn’t even launched until 2012!

CartoDB

Original CartoDB logo

Early last month (July 2016) CartoDB was rebranded as Carto, which includes a new logo. However, once you get beyond the new logo your current account page including your data and maps remains unchanged.  You can still build maps the way you always have in what is now known as Carto Editor.

Carto

New Carto logo

The main difference is that Carto now offers up a new interface named Carto Builder. The good news for Community Health Mappers is that their goal with Carto Builder is to introduce an updated interface. One that still does not require complex geospatial skills and programming. With Carto Builder they aim to make Location Intelligence (LI) more accessible to more people.  This means it will give you point and click access to deeper analysis of your data. Builder will have all the functionality currently found in Editor along with the new tools.

Eventually Carto Editor will be phased out and Carto Builder will be the interface everyone uses. You can request early access to Carto Builder here: http://go.carto.com/request-beta-access. New users of Carto will be given access the the Carto Builder in phases, over the next several months. All existing maps and data will be seamlessly migrated to the new interface. The following page answers Frequently Asked Questions about the migration from Editor to Builder: https://carto.com/docs/carto-builder/faqs/

Once the migration is complete I will post about the new functionality. Stay tuned!

 

Community Health Mapping: A New Year Review

To start the New Year I thought I’d begin with a review of Community Health Mapping (CHM). There are a lot of new project partners, and I thought it would be a good time to give a project overview. CHM is a collaborative effort between the National Library of MedicineCenter for Public Service Communications and Bird’s Eye View. The National Library of Medicine is funding the initiative.

The overall goal is to empower community organizations serving vulnerable or underserved populations with low cost, intuitive mapping technology. Therefore we’ve been working with programs organizations who:

  • Focus on vulnerable populations
  • Frequently use and collect data
  • Need effective, scalable & easy to use mapping tools
  • Lack resources (i.e., for proprietary GIS training & software)

We have identified a suite of tools that allow you to collect custom field data, analyze that data, combine it with other spatial datasets, and generate both static maps and/or dynamic maps on the internet. This allows organizations to collect and work with their own data, and if appropriate, share it with others. CHM involves three components that meet all basic mapping needs:

  • Field Data Collection
  • Desktop Analysis and Cartography
  • Internet Mapping
Community Health Mapping Workflow

Community Health Mapping Workflow

A given project may not require all three, however, collectively these components address the basic needs of all mapping projects.

Field Data Collection:

Rather than focusing on the use of expensive GPS receivers, we recommend the use of smart phones and tablets for these reasons:

  • Most community-based organizations already have them!
  • Many know how to use them
  • They’re intuitive
  • They’re portable
  • They come with an on board GPS receiver (iPhone 5 uses GPS + GLONASS)
  • Have on board cameras
  • Can connect to wireless networks
  • Access to the internet
  • Email is available
  • “There’s an app for that!”
SmartPhones and Tablets vs. Traditional GPS Receivers

SmartPhones and Tablets vs. Traditional GPS Receivers

Of course an important consideration is horizontal accuracy. You can read our blog post on that topic to see if mobile smart devices meet your project needs.

When collecting data you need to be able to develop your own custom data collection form. The top three mobile apps we have found are:

Desktop Analysis and Cartography:

After community field data collection, the next step typically involves bringing the data into a desktop GIS. This is the middle step in the workflow. Here the data can be viewed against basemaps such as Google or OpenStreetMap, and combined with other organizational data. This is also where analyses (proximity, density etc.) can be conducted. Presentation quality maps can also be generated in this step.

The software we found to be the best fit is QGIS. This is an open source desktop GIS software. It has many strengths:

  • It can consume many kinds of data, including all the data that would come out of the field data collection apps.
  • It is both intuitive and robust.
  • It has a large suite of geoprocessing tools for analyzing data.
  • It will run on Windows, Mac, or Linux.
  • It is free to download and install.
  • It is well documented.
  • There is a large user community.
  • New functionality is being continuously added. New stable versions are being released every 4 months!
Baltimore Diabetes Data in QGIS Desktop

Baltimore Diabetes Data in QGIS Desktop

Web Presentation

Often you may want to present an interactive map of your results. Interactive means the map reader can zoom in/out, pan the map and turn layers off and on. For this we recommend CartoDB.

You can sign up for a free account, which gives you 50Mb of storage space. Data can be collected with a smart phone or tablet and brought directly into CartoDB.  It is a very intuitive platform. You can literally drag and drop a spreadsheet onto the CartoDB page and have the data upload to your account.  It will accept the most common geospatial file formats including: spreadsheets and comma delimited text files with addresses or coordinates, KML/KMZ, GPX, and shapefiles.

CartoDB also has great documentation including:

Baltimore Diabetes Data in CartoDB

Baltimore Diabetes Data in CartoDB

In Conclusion

This blog has a lot of resources including reviews of mapping technology and case studies. You might begin by clicking on some of the links in this entry. We are also working on a 6 lab CHM curriculum that interested parties will be able to use to hone their skills. Stay tuned for that!

We are always looking for new partners and continuously work to support current project partners. If you are interested, or have questions please don’t hesitate to contact John Scott (jscott at cpsc.com) or Kurt Menke (kurt at birdseyeviewgis.com). Most importantly get out and do some mapping in 2016!

 

 

 

Tableau Public for Data Visualizations

Tableau Public is free software that can help users publish interactive data visualizations to the internet. This software is another great option for data visualization along with GIS Cloud or CartoDB. It has powerful charting and graphing tools, and also allows you to map data and display that data against several online datasets and basemaps.

No plug-ins or programming skills are required, just a browser with JavaScript enabled. Tableau Public uses a simple drag and drop process that anyone can learn. You can work with either the free Tableau Desktop app, or Tableau Online the free cloud based server. Either way you can save your work to the Tableau Public Web servers, which are accessible by everyone on the Internet. One important note about this is that any data you publish is accessible to everyone on the internet.

People see and understand data, reports and dashboards faster with visual analytics technology, which can help uncover key trends, relationships, patterns, and outliers that might otherwise be a challenge to find. Tableau Public can be used to pare down information to its simplest form by stripping away the less important data.

The software can connect to Microsoft Excel, Microsoft Access, and multiple text file formats. It has a limit of 1,000,000 rows of data allowed in any single file. Your organization may use up to 50 megabytes of space.

Tableau Public projects can be shared by emailing a link or by embedding the work in a blog, wiki, or website. Clicking on an emailed link will open a browser page with the view loaded. If embedded onto a page, anyone who visits the page will see the live interactive view.  The following shows the use of Tableau Public in two health related studies.

Public Health Case Studies

To visualize the specific social problem of teen pregnancy over time, Tableau Public was used by the Wisconsin Council on Children and Families to show the decline in births to teen mothers in Wisconsin over recent years. The data depicts racial disparities in teen births in Wisconsin as well as differences in birth rates between older and younger teens. The online link to the data visualizations created with Tableau Public for this study can be found here: http://tblsft.com/public/gallery/teen-pregnancy-declines

The figure below is a screenshot of one of the data visualizations from this study. Data visualizations are interactive. Here the white popup window is showing data from a specific place on the line graph.

Teen Pregnancy Data Visualization

Teen Pregnancy Data Visualization

Such visualizations may help communities address and manage such issues as health problems associated with prematurity and poor academic performance of children of teen parents.

Data can also be mapped by geographic coordinates, city, state, county, and zip code. The visualization below deals with Medicare Costs and combines a map with a chart showing trends in the data.

Tableau Public Desktop - Medicare Cost Data Visualization

Tableau Public Desktop – Medicare Cost Data Visualization

Other data visualization examples created with Tableau Public can be found in the Gallery:

http://www.tableausoftware.com/public/gallery

Other Tableau Public Resources can be found here:

https://public.tableau.com/s/resources

 

 

Using CartoDB for Beautiful Online Maps

CartoDB is an online cloud based platform for storing and visualizing spatial data. It is the perfect tool for the third part of the workflow (outlined in the Introduction). You can sign up for a free account, which gives you 50Mb of storage space. Data can be collected with a smart phone or tablet with iForm, and brought directly into CartoDB.  It is a very intuitive platform. You can literally drag and drop a spreadsheet onto the CartoDB page and have the data upload to your account.  It will accept the most common geospatial file formats including: spreadsheets and comma delimited text files with addresses or coordinates, KML/KMZ, GPX, and shapefiles. Below is an example of a spreadsheet of Baltimore Dialysis Centers in CartoDB. This shows the spreadsheet in Data View .

CartoDB Data View

CartoDB Data View

After telling CartoDB which columns contain the latitude and longitude values, the data can be viewed in Map View (below). Here the default Positron basemap is being used. There are a variety of basemaps to choose from including imagery, Stamen maps and Nokia maps.

CartoDB Map View

CartoDB Map View

Once multiple data layers have been uploaded you can create a visualization. Below is a map focusing on Balitmore Diabetes. It includes Baltimore neighborhoods classified by the number of diabetics, food deserts and dialysis centers.  CartoDB provides wizards and other tools for styling your data. The dynamic map can be accessed here: http://cdb.io/1G4xP7j

CartoDB Visualization

CartoDB Visualization

Visualizations can be shared via hyperlinks and embedded into webpages.  CartoDB also has great documentation including:

Sign up for a free account and take it for a spin. On a related note Community Health Maps is almost done with a complete curriculum for community health mapping. It consists of six labs. The final lab shows you how to work with CartoDB from setting up an account to sharing a visualization. Stay tuned!

Display and Share Your Maps Online via GIS Cloud  

The third step in the workflow (outlined in the Introduction) is to share your maps online via GIS Cloud.  This is an online mapping platform. You can sign up for a free account, upload your data, and share your maps with others. The maps will be dynamic, meaning you can do things like pan and zoom, turn layers on and off and identify features.

GIS Cloud Homepage

GIS Cloud Homepage

Pricing

Your free account comes with a Map Viewer and Map Editor and gives you 100Mb of space in your cloud account. If you require more space you can upgrade to Premium subscription which offers 1 Gb of space. Premium accounts cost $55/month.

Data Upload

GIS Cloud accepts all common GIS file formats and the data upload section is very intuitive. You can zip all your data and just upload the zip file and GIS Cloud will take care of the rest. You can even drag and drop files anywhere in the browser and they will upload to your account. Once uploaded it offers a nice range of options for symbolizing your data.

GIS Cloud Symbology Options

GIS Cloud Symbology Options

Map Editor

Here you have a variety of tools available including those for data editing, feature selection, basic analysis, table joins, geocoding addresses. It even has a database manager. You can create new layers in your cloud account and edit them here. With the analysis tools you can compute areas, measure proximity of one feature to another, buffer a layer by a certain distance, and create density maps.

GIS Cloud Map Editor Toolbars

GIS Cloud Map Editor Toolbars

Map Viewer

Here your data can be viewed against basemaps such as Google and OpenStreetMap. Your map can also be shared and published. There are several ways to share your maps. The two easiest methods are to provide the link to your map, or embed the dynamic map in a web page. Clicking the Share and Publish button opens the window below. Here you are provided the url to your map viewer and the javascript for embedding the map into a webpage. I would have embedded a dynamic map here,  however, WordPress does not allow bloggers to post JavaScript on WordPress.org blogs. You can also share your map with other GIS Cloud users by Publishing the map. Click on the image below to open up the ENHIP Schools in a GIS Cloud Map Viewer window.

GIS Cloud Map Viewer

GIS Cloud Map Viewer

Resources

Our Resources page has a GIS Cloud document that covers uploading data, styling data and sharing a map.

There are additional online mapping platforms such as CartoDB and MangoMaps. We found GIS Cloud to be the best combination of being intuitive yet powerful. However, all three options have free licensing levels. So you can try them yourself and decide which works best for you. These other options will be covered in future posts. Happy mapping!