Uploading data with coordinates and geographic boundaries

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • February 22, 2018 at 4:55 pm #457 Score: 0
    R.Meggie B.Harvey
    Participant

    Hi CODAP team,

    I recently tried uploading two different data sets, one with coordinates and the other with state boundaries, and was not able to get the map to populate the data. Is there a way that I need to format the data so that it can appear in the map?

    Thanks!

    February 22, 2018 at 5:14 pm #458
    Bill Finzer
    Keymaster

    Hi Meggie,

    Thanks for this question.

    Regarding coordinates: CODAP looks for attributes with names that suggest latitude and longitude.

    For latitude these are: ‘latitude’, ‘lat’, ‘Latitude’, ‘Lat’, ‘LAT’, ‘LATITUDE’, ‘LATITUD’, ‘latitud’

    And for longitude these are: ‘longitude’, ‘long’, ‘lng’, ‘Longitude’, ‘Long’, ‘Lng’, ‘LONG’, ‘LON’,

      'LONGITUDE', 'LONGITUD', 'longitud'

    Once you have attribute names CODAP can recognize, making a map should show points for each case. (Close any maps you have open first.)

    I’ll answer the question about boundaries in a following post.

    Bill

    February 22, 2018 at 5:24 pm #459
    Bill Finzer
    Keymaster

    Regarding state boundaries, let’s assume you have an attribute whose values are names of states. Let’s say the name of this attribute is State.

    Now you need an attribute that whose values are the boundaries themselves. The name of this attribute can be any of the following: ‘boundary’, ‘boundaries’, ‘polygon’, ‘Boundary’, ‘Boundaries’, ‘Polygon’

    Finally, you write a formula for this boundary attribute: lookupBoundary(US_state_boundaries,State)

    After you accept this formula you should see for values small blue polygons that represent the boundaries for each of the states.

    Hope this helps,

    Bill

    February 22, 2018 at 5:36 pm #460
    Dan Damelin
    Keymaster

    Here’s an example doc that shows how to use the lookup function to get state boundaries. This was made by starting from an empty table and following Bill’s instructions.

    https://codap.concord.org/app/#shared=34210 

    February 22, 2018 at 6:34 pm #461
    R.Meggie B.Harvey
    Participant

    Thank you Dan and Bill–that was really helpful. I was able to get the state data to work with no problem. I am still having trouble with the coordinates, however.

    I have attached a screenshot of my table with attributes labeled as “Latitude” and “Longitude” showing the attribute properties as well. Any suggestions?

    Thanks again!

    Attachments:

    1. Screen-Shot-2018-02-22-at-1.31.41-PM.png

    February 22, 2018 at 8:35 pm #463
    Bill Finzer
    Keymaster

    Looks like Latitude is misspelled?

    February 23, 2018 at 1:44 pm #464
    R.Meggie B.Harvey
    Participant

    That did it–I must have checked my spreadsheet a dozen times and still missed the misspelling. Arg. Thanks for catching it!

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.