topic Re: Database import issues in Data Management Questions https://community.esri.com/t5/data-management-questions/database-import-issues/m-p/308082#M17592 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">I'm having problems with a database that I imported. I converted an SPSS database into an excel database, and my latitude/longitude variables have 13 decimal places. Everything translated correctly from SPSS to Excel. When I import and open up the Excel database in Arc 10, the decimal places are chopped to six. If I select the latitude variable and adjust the number of decimal places under "field properties" and "number format" to 13, then only nine of the decimal places actually show up on the screen. What happened to the rest of the decimals? How do I get them back?<BR /><BR />I want the latitude/longitude variables to be that precise because a given location may fall in the incorrect census tract if it is not.<BR /><BR />Thanks!</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>Wow.&nbsp; 0.0000000000001 degrees.&nbsp; Using excel to do the math, </SPAN><A href="http://nationalatlas.gov/articles/mapping/a_latlong.html">and using the figure of 49 miles per degree in a mid-latitude location </A><SPAN>&nbsp; that calculates to 0.0000000258720 feet. I'll let you do the math to figure out how many fractions of an inch that is, but I'm guessing it's somewhere on the level of a neutron. Think about it; are your census tracts that spatially precise?&nbsp; </SPAN><BR /><BR /><SPAN>I like to provide answers and try not to give advice, but I will here; life is short.&nbsp; Nine decimal places will provide more than enough precision.</SPAN><BR /><BR /><BR /><SPAN>All the best!</SPAN></BODY></HTML> Sat, 14 Jan 2012 10:59:16 GMT JoeBorgione 2012-01-14T10:59:16Z Database import issues https://community.esri.com/t5/data-management-questions/database-import-issues/m-p/308081#M17591 <HTML><HEAD></HEAD><BODY><SPAN>I'm having problems with a database that I imported. I converted an SPSS database into an excel database, and my latitude/longitude variables have 13 decimal places. Everything translated correctly from SPSS to Excel. When I import and open up the Excel database in Arc 10, the decimal places are chopped to six. If I select the latitude variable and adjust the number of decimal places under "field properties" and "number format" to 13, then only nine of the decimal places actually show up on the screen. What happened to the rest of the decimals? How do I get them back?</SPAN><BR /><BR /><SPAN>I want the latitude/longitude variables to be that precise because a given location may fall in the incorrect census tract if it is not.</SPAN><BR /><BR /><SPAN>Thanks!</SPAN></BODY></HTML> Fri, 13 Jan 2012 15:41:10 GMT https://community.esri.com/t5/data-management-questions/database-import-issues/m-p/308081#M17591 RickMassatti 2012-01-13T15:41:10Z Re: Database import issues https://community.esri.com/t5/data-management-questions/database-import-issues/m-p/308082#M17592 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">I'm having problems with a database that I imported. I converted an SPSS database into an excel database, and my latitude/longitude variables have 13 decimal places. Everything translated correctly from SPSS to Excel. When I import and open up the Excel database in Arc 10, the decimal places are chopped to six. If I select the latitude variable and adjust the number of decimal places under "field properties" and "number format" to 13, then only nine of the decimal places actually show up on the screen. What happened to the rest of the decimals? How do I get them back?<BR /><BR />I want the latitude/longitude variables to be that precise because a given location may fall in the incorrect census tract if it is not.<BR /><BR />Thanks!</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>Wow.&nbsp; 0.0000000000001 degrees.&nbsp; Using excel to do the math, </SPAN><A href="http://nationalatlas.gov/articles/mapping/a_latlong.html">and using the figure of 49 miles per degree in a mid-latitude location </A><SPAN>&nbsp; that calculates to 0.0000000258720 feet. I'll let you do the math to figure out how many fractions of an inch that is, but I'm guessing it's somewhere on the level of a neutron. Think about it; are your census tracts that spatially precise?&nbsp; </SPAN><BR /><BR /><SPAN>I like to provide answers and try not to give advice, but I will here; life is short.&nbsp; Nine decimal places will provide more than enough precision.</SPAN><BR /><BR /><BR /><SPAN>All the best!</SPAN></BODY></HTML> Sat, 14 Jan 2012 10:59:16 GMT https://community.esri.com/t5/data-management-questions/database-import-issues/m-p/308082#M17592 JoeBorgione 2012-01-14T10:59:16Z