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

Developers: Saving Google API Credits with Autocomplete

By
There are a lot of winners with Google's new API pricing. However, if your app is using the whole suite of mapping functionality and you have a lot of users you might find your pool will start declining fast. Two functions that will draw directly on your pool and are not subject to the daily free quota is autocomplete and place search. If you use your Google licence with the Scribble Maps API we do some of these optimizations out of the box, but if you are building your own custom implementation directly on top of the Google Maps API, there is a simple update you can do to save you some autocomplete credits. The standard auto-complete functionality will send out an auto-complete request with every change in the input. It's possible to cut the amount of credits used significantly by putting in a timeout when the input changes. Here is a very basic example. var acTimeOut; textSearchInput.onkeyup = function() { clearTimeout(acTimeout); acTimeout = setTimeout(func
Read more

New Overhauled Search!

By
Image
We are very excited about our new search and we think you will love the utility of the new features we have added. Auto-Complete + POI + Location Our previous search only supported street addresses but our new search now has auto-complete, POI searching, and address searching. This search is available not only on editor but on all widgets as well starting today. Nearby Search The largest addition to the search function is the ability to search for POIs. Clicking on a location on the left will take you to the nearby search function where you can see places in the vicinity of your selected location or marker. You can change markers of categories and add places one by one or all at the same time. Tutorial and Real Estate Maps We think this functionality is useful in a lot of different areas but think it is particularly useful in real estate. We have created a tutorial video covering this new search functionality that uses a real estate example.
Read more