Starting to Learn GeoDa - HELP!

[Devon Collins]

Hi!

I used this once for an assignment in graduate school and now I need to use it for work. I am having issues starting. Specifically, I have an excel of data points and a SHP file of Virginia with its counties and I want to join the excel (or csv) to the map and I cannot for the life of me figure it out. 

I have been trying to look stuff up on the internet and videos on youtube, but I am having issues getting to what I need. Please help! I am a little desperate!

Thanks a million,

Devon

[Luc Anselin]

First of all, make sure you have all the files associated with the Virginia counties map, not just shp, but also shx

and dbf, and preferably but not necessarily prj all in the same directory.

Also make sure you have a common identifier (key) variable between the map and the excel file and that this

key variable is integer.

Then, open the map in GeoDa (drop the shp file into the “drop files here” box). Open the table and select “Merge”.

Then pull in the excel or csv file, select the common key  and the variables to be merged. After they are added

to the table, make sure to save the file either under the old shape file name or Save As under a new name.

If that doesn’t work, there is likely something strange in the files (sometimes there is trouble with excel). Then

first load the excel file in GeoDa and Save As dbf and use the dbf file in the merge operation.

Hope this helps.

L.

--
You received this message because you are subscribed to the Google Groups "Openspace List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openspace-lis...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/openspace-list/929c9719-f541-4870-adcf-0f86ec59b658n%40googlegroups.com.

[Ali Guedez]

Hi, to join data excel and geoda use merge function, but you have to get a code cell in excel as well as geoda, the same code name to each one.

I hope to be usefull

--

[Julia Koschinsky]

Hi Devon,

Load your Virginia shapefile in GeoDa (needs to have an ID that matches that in your csv). 

Then go to Table-Merge and load your csv (specify the matching IDs from both files).

Best,

Julia

Julia Koschinsky, Ph.D.

Executive Director

Center for Spatial Data Science

University of Chicago

https://spatial.uchicago.edu/

---

From: openspa...@googlegroups.com <openspa...@googlegroups.com> on behalf of Devon Collins <dco...@g.uky.edu>
Sent: Thursday, July 2, 2020 12:31 PM
To: Openspace List <openspa...@googlegroups.com>
Subject: [Openspace] Starting to Learn GeoDa - HELP!

 

--

[Collins, Devon]

Thank you all so much for the help! It indeed does help!

As a follow-up question - is there a good source that I can find a list of state and county codes so I can better link and reference data such as this?

Thanks again,

Devon

You received this message because you are subscribed to a topic in the Google Groups "Openspace List" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/openspace-list/S8dHCG5urBo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to openspace-lis...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/openspace-list/CAGprzDWZbqpptYY7DgC80v0y8FETaLCNtX9Zgg0vx8Fr1szhcg%40mail.gmail.com.

[Frank Howell]

Colin,

See https://transition.fcc.gov/oet/info/maps/census/fips/fips.txt

https://www.nrcs.usda.gov/wps/portal/nrcs/detail/national/home/?cid=nrcs143_013697

Sincerely,

Frank

----

Frank M. Howell, PhD

Professor Emeritus, Mississippi State University

To view this discussion on the web visit https://groups.google.com/d/msgid/openspace-list/CAAmeRJ6kOBgBOPwmXVLdFh%2Be2aBs1Qp0GqbcDo2kQ18B1FY4JQ%40mail.gmail.com.

[Collins, Devon]

Thank you kindly!

To view this discussion on the web visit https://groups.google.com/d/msgid/openspace-list/CAFz2rFhuXAp6RFBpMKXBLxW0tTWC3deDwex44opNUP2znnDs9w%40mail.gmail.com.