Working with a Shapefile and SQL table

[BradPriddle]

Hi

I am new with ArcGIS, like 24 hours. So far, I imported a Shapefile of FSA codes for Canada, ie, Forward Sorting Address, as a layer. It breaks each province up into sections based on that code. I have established a connection to our SQL server and am able to see the tables within it. The FSA shapefile has 3 columns in the data table, one being the FSA code. I have a SQL table with FSA codes and each code has one of four ratings. The SQL table is just a test at the moment to see if I can get this working.

What I want to do is have each FSA area on the map display a specific color based on the code rating we assigned it in the SQL table. I figure some sort of join is next but haven't figured it out yet. Any help would be appreciated!

Thanks!

[JakeSkinner]

Hi Brad,

Take a look at this link on how to create a Join:

Joining attributes in one table to another—Help | ArcGIS for Desktop

After you create the join, you can display the data using Unique Values:

Drawing a layer using categories—Help | ArcGIS for Desktop

[BradPriddle]

Hi Jake

I got it working thanks to your help. Awesome stuff! Thanks!

Brad

Brad Priddle

Business Analyst

Underwriting – Rating & Products

10 Factory Lane | St John’s, NL, Canada | A1C 6H5

Tel: 709.737.1142 | Cell: 709.687.5119

E-mail: bpriddle@johnson.ca<mailto:bpriddle@johnson.ca> Web: www.johnson.ca<http://www.johnson.ca/>

Join our community: <http://www.linkedin.com/company/rsa-canada?trk=top_nav_home>

Proud national insurance sponsor of the AIR MILES® Reward Program. For more information & all your broker needs, visit www.rsabroker.ca<http://www.rsabroker.ca/>

RSA is a registered trade name of Royal & Sun Alliance Insurance Company of Canada

[BradPriddle]

I got it working Jake, thanks!