topic create shape file for joined data in Spatial Data Science Questions

create shape file for joined data

SelamMuluneh — Sat, 25 Apr 2020 19:56:17 GMT

How to create shape file for the no of cases are per county which are joined with the county map from from TIGER.

So the map has latitude and longitude and I need to create a shape file once I joined them and exported.

And I did a display xy data, for the exported table of the joined data and it is not working.

Any idea you can give me please?

Re: create shape file for joined data

DavidPike — Sun, 26 Apr 2020 11:33:27 GMT

I don't fully understand the question, which data types are you joining? If it's a spatial join you will need to save the displayed data into a gis format first, right click on the displayed data in the TOC and go to data->export data

Re: create shape file for joined data

SelamMuluneh — Sun, 26 Apr 2020 17:11:38 GMT

Sorry about that, the data type for the table is CSV standalone table, and the map is shape file.

I joined them on their common field COUNTYFP and when the data is exported its type is dbf, but I need a shape file for further analyisis, or I need to do Kernel Density on the output shape file.

Please let me know what you think.

Thank you,

Selam M

Re: create shape file for joined data

DavidPike — Sun, 26 Apr 2020 17:32:46 GMT

What you need to do is add the join to the shapefile table, not your csv. The attributes of the matching records from your csv will be transferred to the attribute table of the counties shapefile. Because a join is temporary in nature, you will then have to export the shapefile to a new one (right click on the the shapefile in the table of contents, data->exportdata).