GPSFileDepot Forums

General Category => Map Making Support => Topic started by: gwe4 on April 07, 2011, 03:39:04 AM

Title: Find record in .dbf that is associated with image in .shp file
Post by: gwe4 on April 07, 2011, 03:39:04 AM
Is there a way to interpret the data in the .dbf file so that I can figure out what record is connected to a particular body of water in a .shp file?  The reason I ask is that I have three large man made lakes in my map that are all coded as swamps.  Additionally, there is no name data for them.  I would like to find the record for those bodies of water so I can change to type to lake and also give them a name.  Is there some way to convert lat. and long. to some of the number data in the file?  Thank you.
Title: Re: Find record in .dbf that is associated with image in .shp file
Post by: Boyd on April 07, 2011, 08:15:19 AM
This kind of thing can easily be done with Globalmapper, although you wouldn't actually be editing the .dbf but exporting a new version of shapefile and .dbf. You can play with the free trial version, although it won't let you export anything. If you contact them however, I believe they will give you a free trial license key that works for a month: http://globalmapper.com/
Title: Re: Find record in .dbf that is associated with image in .shp file
Post by: maps4gps on April 07, 2011, 08:53:38 AM
Is the source data NHD? 
You could us GM to look at the data and note the COMID; then find the record with that COMID in the .dbf file.  Make the changes to that record in the .dbf file.  Do NOT add nor remove any records from the .dbf file and it will stay in sync with the other shape files.   No need to make a new shape file. 
Title: Re: Find record in .dbf that is associated with image in .shp file
Post by: Seldom on April 07, 2011, 11:03:44 AM
GM's the easiest way to do it, but how many "Swamps" do you have in your database?  If not too many, and not too large, you could open the DBF in Excel and search for "swamp", then change it to "lake".
Title: Re: Find record in .dbf that is associated with image in .shp file
Post by: gwe4 on April 11, 2011, 03:24:28 AM
Thank you for all the good advice.  Worked like a charm!
Title: Re: Find record in .dbf that is associated with image in .shp file
Post by: -Oz- on April 13, 2011, 09:33:43 AM
You can also load these files into postGIS and process it that wa.