1. Home
  2. FAQs
  3. FAQ – How can I get my data ready to use the Uploader tool?

FAQ – How can I get my data ready to use the Uploader tool?

Contents

You can upload existing data as either a shapefile or CSV file. A shapefile is comprised of a number of different component files, all of which must be compressed into a .zip file prior to upload. A CSV with x/y data and a known coordinate system can also be uploaded.

Please click here for the full Uploader tool documentation.

Tips:

  • Work through your file column by column to check that each corresponding field existing in TreePlotter and that the options you have for each tie up with the options in TreePlotter, adding in any missing options
  • If fields that have a lookup are written exactly as they are in TP, that will save you some manual mapping later on
  • Species is one of the most important fields to get right, and it is easier if there is an exact match
    • You can download a copy of your species list by going into Hub > Data Tools > Lookup Table Editor and clicking on the download button against Species (click here for a quick video)
    • Add any missing species using the Lookup Table Editor
  • Headings shouldn’t contain spaces or ampersands (&). They also shouldn’t solely contain a number
  • You may like to make your headings short and logical as they may be truncated
  • Dates need to be in the format MM/DD/YYYY.
    • If you have them in the format DD/MM/YYYY, then this Excel function will convert it =IF(H2<>””,CONCATENATE(MONTH(H2),”/”,DAY(H2),”/”,YEAR(H2)),””) (where H is the column with the date in)
  • If you’re having trouble with the spreadsheet, you may find copying and pasting the entire contents into a new spreadsheet and paste it ‘as values’ so it doesn’t copy over any of the formatting. Then save it as a CSV UTF-8
  • If you only have Eastings and Northings, use QGIS, or other GIS software, to convert the CSV into a shapefile
  • If your tree data is in a shapefile, note that it should be Point data and not MultiPoint

Updated on July 16, 2021

Was this article helpful?

Related Articles