topic Re: Help with choropleth mapping... in ArcGIS Enterprise Portal Questions https://community.esri.com/t5/arcgis-enterprise-portal-questions/help-with-choropleth-mapping/m-p/226485#M3021 <HTML><HEAD></HEAD><BODY><SPAN>Perhaps the -ve was left out of the Lancashire data putting it to the east of 0 Long.&nbsp; spatial join should be by coordinates, so I would check file separately in its own dataframe to ensure that the unprojected coordinates line up where they should</SPAN></BODY></HTML> Fri, 19 Nov 2010 15:45:03 GMT DanPatterson_Retired 2010-11-19T15:45:03Z Help with choropleth mapping... https://community.esri.com/t5/arcgis-enterprise-portal-questions/help-with-choropleth-mapping/m-p/226482#M3018 <HTML><HEAD></HEAD><BODY><SPAN>...I am new to this so please bear with me! I am trying to make a map of how many passports are checked per county in the UK. I have a table with my grid references (eastings/northings) county and number of checks, which I have added as x,y data onto my map of the UK. I know I need to join my table and basemap to make a choropleth map, however I seem to be having a few problems when I do this. Some of the counties that have definitely checked passports are showing up as "0". When I use the identify tool and click on the point for that data, it appears that somehow the data has got mixed up i.e. Lancashire has checked 500 passports but when I click on the point that is in Lancashire it actually thinks it is London and has no passports!</SPAN><BR /><BR /><SPAN>Is this something to do with the projection? I have double checked and the projection is the British National Grid so not really sure what is going wrong? If anyone could offer some advice that would be great!</SPAN><BR /><BR /><SPAN>Ps I have done plenty of other maps without this problem, for some reason it just doesn't like this dataset!</SPAN><BR /><BR /><SPAN>Thanks <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN></BODY></HTML> Fri, 19 Nov 2010 14:30:56 GMT https://community.esri.com/t5/arcgis-enterprise-portal-questions/help-with-choropleth-mapping/m-p/226482#M3018 charlotterobin 2010-11-19T14:30:56Z Re: Help with choropleth mapping... https://community.esri.com/t5/arcgis-enterprise-portal-questions/help-with-choropleth-mapping/m-p/226483#M3019 <HTML><HEAD></HEAD><BODY><SPAN>Have you tried the join on unprojected data?</SPAN></BODY></HTML> Fri, 19 Nov 2010 14:37:45 GMT https://community.esri.com/t5/arcgis-enterprise-portal-questions/help-with-choropleth-mapping/m-p/226483#M3019 DanPatterson_Retired 2010-11-19T14:37:45Z Re: Help with choropleth mapping... https://community.esri.com/t5/arcgis-enterprise-portal-questions/help-with-choropleth-mapping/m-p/226484#M3020 <HTML><HEAD></HEAD><BODY><SPAN>I have just tried and no it still has the same problem <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></SPAN></BODY></HTML> Fri, 19 Nov 2010 14:39:44 GMT https://community.esri.com/t5/arcgis-enterprise-portal-questions/help-with-choropleth-mapping/m-p/226484#M3020 charlotterobin 2010-11-19T14:39:44Z Re: Help with choropleth mapping... https://community.esri.com/t5/arcgis-enterprise-portal-questions/help-with-choropleth-mapping/m-p/226485#M3021 <HTML><HEAD></HEAD><BODY><SPAN>Perhaps the -ve was left out of the Lancashire data putting it to the east of 0 Long.&nbsp; spatial join should be by coordinates, so I would check file separately in its own dataframe to ensure that the unprojected coordinates line up where they should</SPAN></BODY></HTML> Fri, 19 Nov 2010 15:45:03 GMT https://community.esri.com/t5/arcgis-enterprise-portal-questions/help-with-choropleth-mapping/m-p/226485#M3021 DanPatterson_Retired 2010-11-19T15:45:03Z