Skip to content

Instantly share code, notes, and snippets.

@andrewxhill
Last active August 29, 2015 13:57
Show Gist options
  • Save andrewxhill/9378741 to your computer and use it in GitHub Desktop.
Save andrewxhill/9378741 to your computer and use it in GitHub Desktop.

Prior to georeferences

  • "You have latitude and longitude columns in your table"

    • let's do it!
  • "You have city names, administrative areas, postal codes, or IP addresses"

    • "My column contains, " [1, 2, 3, 4, 5]

      1. "City names"

        • Which column are your city names stored in? {}
        • Do you have a state/province column? {}
        • Do you know which country they are in? [DROP DOWN] or {}

        A. You can only have [points]

      2. "Postal Codes"

        • Which column are your Postal Codes stored in? {}
        • Do you know which country they are in? [DROP DOWN] or {}

        A. I'd like [points, polygons]

      3. "State/Province names"

        • Which column are your State/Province names stored in? {}
        • Do you know which country they are in? [DROP DOWN] or {}

        A. I'd like [points, polygons]

      4. "Country names"

        • Which column are your Country names stored in? {}

        A. I'd like [points, polygons]

      5. "IP Addresses"

        • Which column are your IP addresses stored in? {}

        A. You can only have [points]

  • "You have street addresses"

    • this costs $

Post georeferencing

* Free geocoder, points
  "3,000 out of 5,321 rows were succesfully turned into points!"
  "It seems that some of your rows didn't finish succesfully. Perhaps 
   these rows contained empty values or perhaps we just didn't know 
   what the values ment. We encourage you to take a look and try again."
   "This job cost you $0 because we love you for being you!"

* Free geocoder, polygons
  "3,000 out of 5,321 rows were succesfully turned into polygons!"
  "It seems that some of your rows didn't finish succesfully. Perhaps 
   these rows contained empty values or perhaps we just didn't know 
   what the values ment. We encourage you to take a look and try again."
   "This job cost you $0 because we love you for being you!"

* Costly geocoder, underquota
  "3,000 out of 5,321 rows were succesfully turned into points!"
  "It seems that some of your rows didn't finish succesfully. Perhaps 
   these rows contained empty values or perhaps we just didn't know 
   what the values ment. Unsuccessful rows don't count against your 
   quota, so we encourage you to take a look and try again."
   "This job cost you $0 because we love you! You have X,XXX remaining in 
    your free quota this month."

* Costly geocoder, overquota
  "3,000 out of 5,321 rows were succesfully turned into points!"
  "It seems that some of your rows didn't finish succesfully. Perhaps 
   these rows contained empty values or perhaps we just didn't know 
   what the values ment. Unsuccessful rows don't count against your 
   quota, so we encourage you to take a look and try again."
   "This job cost you $1.11 because X,XXX of them were over your freely 
    available quota. This will be added to next months bill. 
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment