topic Re: Working with a Shapefile and SQL table in ArcGIS Mapping and Charting Questions https://community.esri.com/t5/arcgis-mapping-and-charting-questions/working-with-a-shapefile-and-sql-table/m-p/571124#M1978 <HTML><HEAD></HEAD><BODY><P>Hi Brad,</P><P></P><P>Take a look at this link on how to create a Join:</P><P></P><P><A href="http://desktop.arcgis.com/en/desktop/latest/manage-data/tables/joining-attributes-in-one-table-to-another.htm" title="http://desktop.arcgis.com/en/desktop/latest/manage-data/tables/joining-attributes-in-one-table-to-another.htm">Joining attributes in one table to another—Help | ArcGIS for Desktop</A> </P><P></P><P>After you create the join, you can display the data using Unique Values:</P><P></P><P><A href="http://desktop.arcgis.com/en/desktop/latest/map/working-with-layers/drawing-a-layer-using-categories.htm#GUID-7D77FB92-7FD0-46FD-BEB2-E7B61AA6D865" title="http://desktop.arcgis.com/en/desktop/latest/map/working-with-layers/drawing-a-layer-using-categories.htm#GUID-7D77FB92-7FD0-46FD-BEB2-E7B61AA6D865">Drawing a layer using categories—Help | ArcGIS for Desktop</A> </P></BODY></HTML> Fri, 20 Mar 2015 19:16:47 GMT JakeSkinner 2015-03-20T19:16:47Z Working with a Shapefile and SQL table https://community.esri.com/t5/arcgis-mapping-and-charting-questions/working-with-a-shapefile-and-sql-table/m-p/571123#M1977 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>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.</P><P></P><P>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!</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 20 Mar 2015 19:03:09 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/working-with-a-shapefile-and-sql-table/m-p/571123#M1977 BradPriddle 2015-03-20T19:03:09Z Re: Working with a Shapefile and SQL table https://community.esri.com/t5/arcgis-mapping-and-charting-questions/working-with-a-shapefile-and-sql-table/m-p/571124#M1978 <HTML><HEAD></HEAD><BODY><P>Hi Brad,</P><P></P><P>Take a look at this link on how to create a Join:</P><P></P><P><A href="http://desktop.arcgis.com/en/desktop/latest/manage-data/tables/joining-attributes-in-one-table-to-another.htm" title="http://desktop.arcgis.com/en/desktop/latest/manage-data/tables/joining-attributes-in-one-table-to-another.htm">Joining attributes in one table to another—Help | ArcGIS for Desktop</A> </P><P></P><P>After you create the join, you can display the data using Unique Values:</P><P></P><P><A href="http://desktop.arcgis.com/en/desktop/latest/map/working-with-layers/drawing-a-layer-using-categories.htm#GUID-7D77FB92-7FD0-46FD-BEB2-E7B61AA6D865" title="http://desktop.arcgis.com/en/desktop/latest/map/working-with-layers/drawing-a-layer-using-categories.htm#GUID-7D77FB92-7FD0-46FD-BEB2-E7B61AA6D865">Drawing a layer using categories—Help | ArcGIS for Desktop</A> </P></BODY></HTML> Fri, 20 Mar 2015 19:16:47 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/working-with-a-shapefile-and-sql-table/m-p/571124#M1978 JakeSkinner 2015-03-20T19:16:47Z Re: Working with a Shapefile and SQL table https://community.esri.com/t5/arcgis-mapping-and-charting-questions/working-with-a-shapefile-and-sql-table/m-p/571125#M1979 <HTML><HEAD></HEAD><BODY><P>Hi Jake</P><P></P><P>I got it working thanks to your help. Awesome stuff! Thanks!</P><P></P><P>Brad</P><P></P><P>Brad Priddle</P><P>Business Analyst</P><P>Underwriting – Rating &amp; Products</P><P></P><P></P><P>10 Factory Lane | St John’s, NL, Canada | A1C 6H5</P><P>Tel: 709.737.1142 | Cell: 709.687.5119</P><P>E-mail: bpriddle@johnson.ca&lt;mailto:bpriddle@johnson.ca&gt; Web: www.johnson.ca&lt;http://www.johnson.ca/&gt;</P><P>Join our community: &lt;http://www.linkedin.com/company/rsa-canada?trk=top_nav_home&gt; </P><P></P><P>Proud national insurance sponsor of the AIR MILES® Reward Program. For more information &amp; all your broker needs, visit www.rsabroker.ca&lt;http://www.rsabroker.ca/&gt;</P><P>RSA is a registered trade name of Royal &amp; Sun Alliance Insurance Company of Canada</P></BODY></HTML> Fri, 20 Mar 2015 19:39:00 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/working-with-a-shapefile-and-sql-table/m-p/571125#M1979 BradPriddle 2015-03-20T19:39:00Z Re: Working with a Shapefile and SQL table https://community.esri.com/t5/arcgis-mapping-and-charting-questions/working-with-a-shapefile-and-sql-table/m-p/571126#M1980 <HTML><HEAD></HEAD><BODY><P>I got it working Jake, thanks!</P></BODY></HTML> Fri, 20 Mar 2015 19:39:09 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/working-with-a-shapefile-and-sql-table/m-p/571126#M1980 BradPriddle 2015-03-20T19:39:09Z