topic Re: how to keep precision in shape file & scv table join in Python Questions https://community.esri.com/t5/python-questions/how-to-keep-precision-in-shape-file-scv-table-join/m-p/480602#M37586 <HTML><HEAD></HEAD><BODY><P>Are you really using a shape file or just using that term instead of geodatabse feature class?&nbsp; If the former, precision in a dbf isn't one of their strong points.</P><P></P><P>I suggest you perform a table to table to get the csv into a geodatabas table.&nbsp; You can preserve the field types with <A href="https://pro.arcgis.com/en/pro-app/tool-reference/conversion/table-to-table.htm">the tool</A>, and then you can copy the parameters from a successful tool run if you want to automate it.&nbsp; Then&nbsp; make the join to the actual table.</P></BODY></HTML> Tue, 14 Apr 2020 18:04:37 GMT JoeBorgione 2020-04-14T18:04:37Z how to keep precision in shape file & scv table join https://community.esri.com/t5/python-questions/how-to-keep-precision-in-shape-file-scv-table-join/m-p/480601#M37585 <HTML><HEAD></HEAD><BODY><P>Hello, I am joining&nbsp; a shapefile with a csv table. One of the fields in the csv table is a double type field that has 9 digits to the right. I need all the digits to the right of the decimal point.</P><P>The join is working, looks like the digits are there when I join, but the export of the join brings only 6 digits to the right and many of them are&nbsp;<STRONG> 0</STRONG> when the&nbsp; initial attribute&nbsp; in the csv table was for ex 0.00003300. I am concerned about 0s.&nbsp;</P><P>Thank you so much.&nbsp;</P></BODY></HTML> Tue, 14 Apr 2020 17:42:57 GMT https://community.esri.com/t5/python-questions/how-to-keep-precision-in-shape-file-scv-table-join/m-p/480601#M37585 TatianaVlad 2020-04-14T17:42:57Z Re: how to keep precision in shape file & scv table join https://community.esri.com/t5/python-questions/how-to-keep-precision-in-shape-file-scv-table-join/m-p/480602#M37586 <HTML><HEAD></HEAD><BODY><P>Are you really using a shape file or just using that term instead of geodatabse feature class?&nbsp; If the former, precision in a dbf isn't one of their strong points.</P><P></P><P>I suggest you perform a table to table to get the csv into a geodatabas table.&nbsp; You can preserve the field types with <A href="https://pro.arcgis.com/en/pro-app/tool-reference/conversion/table-to-table.htm">the tool</A>, and then you can copy the parameters from a successful tool run if you want to automate it.&nbsp; Then&nbsp; make the join to the actual table.</P></BODY></HTML> Tue, 14 Apr 2020 18:04:37 GMT https://community.esri.com/t5/python-questions/how-to-keep-precision-in-shape-file-scv-table-join/m-p/480602#M37586 JoeBorgione 2020-04-14T18:04:37Z