How to join *.dbf and *.shp
Started by
henryd
, Dec 28 2012 10:15 AM
2 replies to this topic
#1
Posted 28 December 2012 - 10:15 AM
Hello everyone!
I have a shapefile with GPS data, representing clusters of a national survey. When I open the shp file in ArcMap, each cluster is represented by a point. Each cluster has an ID number (I can see them in a list when I open the dbf file in excel). But I don´t know how to open it in ArcMap and connect the cluster ID to the points on my map. I tried to import the dbf into ArcMap using join and relate, but the dbf file does not appear. Only shp files appear.
Does anyone know how to go about it?
I have a shapefile with GPS data, representing clusters of a national survey. When I open the shp file in ArcMap, each cluster is represented by a point. Each cluster has an ID number (I can see them in a list when I open the dbf file in excel). But I don´t know how to open it in ArcMap and connect the cluster ID to the points on my map. I tried to import the dbf into ArcMap using join and relate, but the dbf file does not appear. Only shp files appear.
Does anyone know how to go about it?
#2
Posted 28 December 2012 - 11:14 AM
I actually realized how to do it. I simply chose to display labels...
#3
Posted 28 December 2012 - 11:15 AM
Hello everyone!
I have a shapefile with GPS data, representing clusters of a national survey. When I open the shp file in ArcMap, each cluster is represented by a point. Each cluster has an ID number (I can see them in a list when I open the dbf file in excel). But I don´t know how to open it in ArcMap and connect the cluster ID to the points on my map. I tried to import the dbf into ArcMap using join and relate, but the dbf file does not appear. Only shp files appear.
Does anyone know how to go about it?
If the .dbf accompanies the .shp file and has the same name it should simply appear as the table of attributes in ArcGIS (right click on the layer name and choose "open attribute table").
If the .dbf is a separate file with extra attribute info you need to first verify that both the .shp and the .dbf have a common id field and that it is of the same type (number or text). You should be able to do a table join between the two but you may need to add the dbf to the map as a table first. You can also open the dbf in excel and save as a 97-2003 .xls file then use that file to join to the .shp.
Let us know if any of that works.
David
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users


Sign In
Create Account
Sweden
Back to top
United States









