Using Spreadsheets in Pro

By
One of the exciting new features in Pro is the ability to upload data in the form of spreadsheets. To add a spreadsheet, you can either click the spreadsheet button in the top right, or goto Menu > Account > Files, then upload the file and import it to the map, once you do either of these things you will get this window.



From here it is pretty straight forward. Select the address column, or alternatively latitude and longitude columns, that pick what you wish to do with the data, whether it is to plot markers to the map, or do some drawing functions. Also in this window you can select a range via start index and end index, this allows you to only plot the points within a certain range of rows. For instance, if I only wanted to add rows 50-100 of a spreadsheet.

We are working on implementing thematic mapping support, and when it is implemented we will let you know here.

Comments

Post a Comment

Comments are moderated, thanks for your patience.

Popular posts from this blog

Route Optimization Comes to Scribble Maps

By
Image
Route optimization also known as the travelling sales person problem (TSP) is a type of routing to figure out which order you should visit locations in the fastest time possible. As you can imagine this is very useful if you need to drop off packages, do movie location scouting, make sales calls to a physical location, or need to do routine inspections. Well we are happy to announce that this functionality has now come to Scribble Maps. For demonstration purpose we have selected a bunch of different cafes in the Toronto region. Let's pretend that in the course of a day or multiple days you want to visit all of them. Here is a picture of the original points. Unoptimized Points From here we going to go to our Operations & Analysis panel and select Create > Optimized Route. Next you will want to select your start location, end location, and the way points folder that contains the points in your route. After clicking "Create Optimized Route" your
Read more

Map Crop, TMS, and WMS!

By
Image
We have a rolled out a large feature for our VIP users and think it is worth writing a post about! Introducing Base Layers Module Looking in the bottom window you can see we have added a new panel (you can collapse/expand it with the arrow). This new area allows you to not only crop the map but also add both TMS and WMS layer types. We are planning to add more as well! Map Cropping Map cropping allows you to take any polygon or multiple polygons and crop out the rest of the map. In the above image we have made a map crop of the state of Nebraska. In this example we have the crop out color set to  black with a slight transparency but you can set the color to anything you want and also make the cropped out areas not visible at all. To get this effect with the state we used the "Region Highlight" tool to create a polygon for Nebraska and then applied the crop using it. How to add a map crop There is two ways to add a crop. The first is to click the + butto
Read more