Thursday, August 8, 2019

Data Aggregation By Region

An often needed ability is to be able to combine or aggregate data for a region. For example being able to find the combined sales or averages sales of sales people in a particular region. With Scribble Maps this easily done using operations.

To get started you need two things present on your maps.

#1 Markers with attributes

You can upload these markers through our import list feature and the column values will be automatically added to each marker as attributes. You can also manually add attributes directly to a markers but this is not recommended if you are using large data sets.

#2 Region(s)

A region is nothing more than a shape (polygon). You can either draw them directly on the map, add them via a KML file, or use our region highlighter tool.

Aggregate That Data!

First go to the operations panel and then select either "In region" or "In multiple regions" in the aggregate column.

Next, select the group containing the regions you want to aggregate your data for and then which attributes you would like to aggregate and how. You can choose sum, average, or count. Finally click the "Aggregate Data" button.

Finally you will see the results of your operation which, in this example, is the sum sales for each region.

That's all there is to it to start aggregating data by region. This will hopefully help you with some of your spatial data analysis needs!

Monday, April 29, 2019

Data Filtering with Scribble Maps

We recently rolled out a large new feature to Scribble Maps called Data filtering. This allows you to quickly filter spreadsheets such as XLS, CVS, or just attributes you add yourself. To those unfamiliar with data filtering and GIS it might be a bit intimidating at first but data filtering is nothing more than showing data that you want to see based on specific conditions.

We use data filtering all the time for ourselves. For instance when we are picking a hotel and want to see the ones with the highest ratings or ones that are in a certain price range. Both of these are examples of data filtering.

The cool thing about Data Filtering in Scribble Maps is that once you define filters they can be used on our share view by others. When others are viewing your map they can turn on and off filters for the map to get to the data they are looking for.

In order to filter data in Scribble Maps an overlay such as a marker or a shape needs to have an attribute. Attributes can either be added manually one by one through the three dot menu "..." or when importing a list. An example of an attribute would be a "cost" for a house listing.

To get to our data filtering screen you can just click the data filter icon in the toolbar.

One of the hardest things to understand might be the "Match ALL" versus "Match ANY". Another way to think of "Match ALL" is using the word "and". For "Match ANY" use the word "or".

Match ALL - I want to see any houses with a cost of 100,000 and has a lot size greater than 1000.
Matchy ANY - I want to see any with a cost of 100,000 or has a lot size of greater than 1000.

Match ANY will naturally return more results than match all. If you are interested in getting started with Data Filtering in Scribble Maps check out this tutorial video we put together for you!