Facebook Twitter Instagram
falling fruit Map the urban harvest!

Import Locations from CSV

Show instructions

This is an admin-only function for doing bulk imports of locations. It assumes a comma seperated values (CSV) file with the following fields:

Ids, Types, Description, Lat, Lng, Address, Season Start, Season Stop, No Season, Access, Unverified, Yield Rating, Quality Rating, Author, Photo URL

Ids: Unique identifiers of the corresponding location(s) in the original data source, as a comma seperated list (e.g. "ID1, ID2"). For data without a unique identifer, row order should be used instead.

Types: The types of each location, in the format "id: English common name [scientific name]", or any subset of those parts (e.g. "id", "[scientific name]", etc). If the name does not match an existing type, a new pending type is created. If the name matches multiple existing types, an error is returned. Separate multiple types with commas (eg. "Apple [Malus domestica], U-pick").

Description: Whatever information should be displayed in the location's infobox (location details, access issues, plant health, etc). <br> (HTML line break) tags are converted to \n (newline) characters. No other markup is currently supported.

Lat/Lng: Latitude and longitude in decimal degrees (WGS84).

Address: Full street address of the location (number, street, city, state / province, zip code, country). It is geocoded and converted to coordinates, so don't provide an address if you are already providing Lat and Lng.

Season Start/Stop: Months that harvesting begins and ends, respectively, with 1 corresponding to January and 12 corresponding to December.

No Season: Whether season does not apply (eg. Rosemary). Mark 'x', 't', or 'true' if true (no season), otherwise leave blank.

Access: Access status of the location, on a scale from 1 to 5:

  • 1: Source is on my property
  • 2: I have permission from the owner to add the source
  • 3: Source is on public land
  • 4: Source is on private property but overhangs public land
  • 5: Source is on private property (ask before you pick)
  • Unverified: Whether the location or identity of one or more of the sources at the location have not been verified. Mark 'x', 't', or 'true' if true (unverified), otherwise leave blank.

    Yield/Quality Rating: The productivity and tastiness of the sources at the location, on a scale from 1 to 5:

  • 1: Poor
  • 2: Fair
  • 3: Good
  • 4: Very Good
  • 5: Excellent
  • Author: Author of the location, as displayed on the map. If left blank, the author is "Anonymous".

    Photo URL: Full path to a photo of the location. A review will be created with the photo added.