Ask A Cartographer

unrecognized characters

December 07 2011 | 0 comments
Categories: Map Data

Dear Sirs,

I would like to ask for your experience and knowledge on the following subject.

I have a shapefile with 260.000 records and 4 fields. This shapefile has been downloaded from the Internet and is from an official site of The Greek Agriculture Ministry. The codes of the fields are in Greek capital letters indicating vegetation types. The first problem is that I cannot read the Greek letters; instead of these I read ASCII characters.

After many suggestions I used ArcView 3.3 and I exported the DB as a .txt file. This file was imported in Microsoft Office 2007 (due to the number of records) and exported as an .xlsx file. The problem with the Greek characters is solved and I can read them in this way. Now I have a new problem, as you could understand. I have a shapefile with a DB with unrecognized characters and an .xlsx file with recognized characters and I try to combine them. I have tried many ideas unfortunately without any success. (I am using ArcGIS 9.3 on Windows 7). So, I am asking for your advice on what I have to do.

Mapping Center Answer:

Create a key field to link the two -- for example, if your original data had an ObjectID (OID), then copy that into the Excel file as well and use that field to create the join or relate in ArcMap. If it didn't have a unique identifier, then create one and again include that the in Excel file to create the relationship between the shapefile and the Excel file.

If you would like to post a comment, please login.

Contact Us | Legal | Privacy |