topic Re: Creating points from excel/access in Data Management Questions https://community.esri.com/t5/data-management-questions/creating-points-from-excel-access/m-p/398536#M22865 <HTML><HEAD></HEAD><BODY><SPAN>What would the calculation be for the new fields?</SPAN></BODY></HTML> Mon, 17 Dec 2012 17:36:40 GMT NicoleHanson 2012-12-17T17:36:40Z Creating points from excel/access https://community.esri.com/t5/data-management-questions/creating-points-from-excel-access/m-p/398534#M22863 <HTML><HEAD></HEAD><BODY><SPAN>I'm trying to create points from the excel/access table.&nbsp; I have Lat/Long, and they are in a format like: 462508 for Lat and 1163445 for Long.&nbsp; It's not creating a shapefile that I would expect.&nbsp; Is there any way to calculate these values into Decimal Degrees?</SPAN></BODY></HTML> Mon, 17 Dec 2012 16:10:34 GMT https://community.esri.com/t5/data-management-questions/creating-points-from-excel-access/m-p/398534#M22863 NicoleHanson 2012-12-17T16:10:34Z Re: Creating points from excel/access https://community.esri.com/t5/data-management-questions/creating-points-from-excel-access/m-p/398535#M22864 <HTML><HEAD></HEAD><BODY><SPAN>Looks like your coordinates are UTM based (or something similar). Create your shapefile using the proper UTM zone, then pop it onto your map, then create 2 new fields for LAT and LON and populate them using Calculate Geometry</SPAN></BODY></HTML> Mon, 17 Dec 2012 17:14:38 GMT https://community.esri.com/t5/data-management-questions/creating-points-from-excel-access/m-p/398535#M22864 michaelcollins1 2012-12-17T17:14:38Z Re: Creating points from excel/access https://community.esri.com/t5/data-management-questions/creating-points-from-excel-access/m-p/398536#M22865 <HTML><HEAD></HEAD><BODY><SPAN>What would the calculation be for the new fields?</SPAN></BODY></HTML> Mon, 17 Dec 2012 17:36:40 GMT https://community.esri.com/t5/data-management-questions/creating-points-from-excel-access/m-p/398536#M22865 NicoleHanson 2012-12-17T17:36:40Z Re: Creating points from excel/access https://community.esri.com/t5/data-management-questions/creating-points-from-excel-access/m-p/398537#M22866 <HTML><HEAD></HEAD><BODY><SPAN>Check this out:</SPAN><BR /><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//005s00000027000000">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//005s00000027000000</A></BODY></HTML> Mon, 17 Dec 2012 17:44:24 GMT https://community.esri.com/t5/data-management-questions/creating-points-from-excel-access/m-p/398537#M22866 michaelcollins1 2012-12-17T17:44:24Z Re: Creating points from excel/access https://community.esri.com/t5/data-management-questions/creating-points-from-excel-access/m-p/398538#M22867 <HTML><HEAD></HEAD><BODY><SPAN>OK, I did that, but it seems to be shifted from other data I have in ArcMap.</SPAN></BODY></HTML> Mon, 17 Dec 2012 17:59:22 GMT https://community.esri.com/t5/data-management-questions/creating-points-from-excel-access/m-p/398538#M22867 NicoleHanson 2012-12-17T17:59:22Z Re: Creating points from excel/access https://community.esri.com/t5/data-management-questions/creating-points-from-excel-access/m-p/398539#M22868 <HTML><HEAD></HEAD><BODY><SPAN>Shifted by how much? Perhaps you used NAD83 instead of NAD27 or vice versa.</SPAN></BODY></HTML> Tue, 18 Dec 2012 15:01:06 GMT https://community.esri.com/t5/data-management-questions/creating-points-from-excel-access/m-p/398539#M22868 michaelcollins1 2012-12-18T15:01:06Z Re: Creating points from excel/access https://community.esri.com/t5/data-management-questions/creating-points-from-excel-access/m-p/398540#M22869 <HTML><HEAD></HEAD><BODY><SPAN>It was more of a spreading and shifting.&nbsp; </SPAN><BR /><BR /><SPAN>I asked a coworker for some help, he knows python, and he was able to get the data changed to DD.&nbsp; Thanks for your help.</SPAN></BODY></HTML> Tue, 18 Dec 2012 15:17:57 GMT https://community.esri.com/t5/data-management-questions/creating-points-from-excel-access/m-p/398540#M22869 NicoleHanson 2012-12-18T15:17:57Z