Product: MapInfo AnySite Desktop
Version: 9.0, 8.8
Platform: Not Platform Related
Category: Documentation
Summary:
AnySite Desktop 8.x and mapping Excel spreadsheet's or .dbf tables of zipcodes to regions and shading thematically.
Question:
If a user has an Excel spreadsheet or .dbf of zipcodes, how can this be brought into AnySite and mapped and shaded thematically?
Answer:
Excel files:
** Note: For versions of AnySite 8.8 or earlier, if using Microsoft Office 2007, the file must be saved back a version in order to be compatible
with AnySite at this time. Use File>Save As and select the file type of .xls but one version back.
But if using AnySite 9.0, you do not need to change the version - AS 9.0 supports Office 2007 file formats.
First make sure of the following for the name of the file and the column headers:
************
first row has column headings (note dBASE allows a maximum of 10 characters)
remove any spaces and non-standard characters (!@#$%^&*()-+=|\{}[]:;”’<,>.?/) from column headings.
remove any grid line styles
remove any cell color/fill
expand all rows and columns so the entire contents of each cell is visible on the screen
Maximum 254 columns
Maximum 65,000 rows
************
Then, before adding the excel spreadsheet as an linked layer, make sure ZIPCODE data type is character.
Open your spreadsheet using Excel.
Highlight the Zipcode column
Click on Data > Text to Columns
Choose Delimited and click Next
Delimiter will be Tab. Click on Next
Column data format - Select Text then click Finish
Now your Zipcode column should have tiny green triangles in the top left corner
of each cell. This indicates that the column format is set to character.
Click on File > Save to save your file.
Next, define a range for the spreadsheet in Excel by Highlighting the columns and cells in the spreadsheet that have data.
Then go to Insert>Name>Define and take the default name by clicking the Add button.
You have created your Excel -based Database, ready for linking.
DBF Files
Note the DBF-specific requirements:
If using the desired format of a dBASE file:
a. first row has column headings (note dBASE allows a maximum of 10 characters)
b. dbf file name needs to be 8 characters or less. no spaces. underscores are ok
c. remove any spaces and non-standard characters (!@#$%^&*()-+=|\{}[]:;”’<,>.?/) from column headings.
d. remove any grid line styles
e. remove any cell color/fill
f. expand all rows and columns so the entire contents of each cell is visible on the screen
g. Maximum 254 columns
h. Maximum 65,000 rows
The next step will be creating a database and then a linked layer in AnySite:
1)
A. Creating the Database using Excel:
1. In the AnySite Configurator, click on Tools > Database Manager. Click on Add.
2. Give the Database a Name.
3. Select Generic/Unspecified then click on Configure
4. Select the Microsoft Excel Driver. Click OK
5. Select Version Excel 97-2000 then click on Select Workbook
6. Select your worksheet (Baylor's cases.xls in this example).
Click OK.
7. Click OK again.
8. The database connection you added is now added into the Database Manager. Click OK
B: Creating the Database using DBF:
The process for creating a Database from a dbf is almost identical to the process listed above for xls files:
Here are the steps for creating a .dbf -based database:
In the Configurator:
1. Click on Tools > Database Manager
2. Click on Add
3. Name the database and Type = dBASE. Click Configure
4. In the ODBC Setup... Version = dBASE IV/ Uncheck Use Current Directory / Click on Select Directory
5. In the Select Directory window, select the folder that your dbf file is in. Click OK
6. OK all the way out back to the Configurator.
2) Linking the Excel or DBF-based database to the ZIPCODE Region layer:
1. In the Configurator, click on Layers > Linked > New
Give the layer a Name and click on Edit
2. Select your database - Test2. Then, select Table and click the drop-down and choose the zip code field (Zip in this example).
Select Linked to Zip Codes and click OK.
3. Click on Type.
Object Type will be Regions
Enable the layer for Editing, Searching On and Reporting On
Click OK.
4. Click on Styles and select Style Override. Click on the white polygon to select the stye you want for the Baylor's Cases layer. Then click OK
5. Check the boxes for Selectable, In Legend, and In Layer Control
6. Click on Address
For the ID select Zipcode -
(It is important to note that if you wanted to link to a County or Census tract layer, for example,
you select the field in your table that holds the County or Census Tract FIPS code for the ID field-
The ID field is what joins your table to the region table already in AnySite.)
Click OK.
7. Click OK
3) To create a dot density or Ranged Thematic on the table:
1. In the Configurator click on Thematics > Dot Densities > New
2. Give the Dot Density a Name
Data Source - Select your table (Baylor's Cases in these screenshots)
Variable - Select your SumOfCases column
Format - Select #,0
Dot Density Settings - Choose the format on how you want the dots to appear on your map
Click OK
To run the dot density you created in AnySite:
In the AnySite application, click on the Dot Density tool 
Select your shade (Baylor's Cases).
You'll see dots on your map:
Create Ranged thematic shades the exact same way as the instructions for Dot Density Thematics listed above.
Last Modified: 11/10/2011 02:25:08 PM
|