topic Re: Values changed to 0 or 1 when converting from .csv to .shp in Data Management Questions https://community.esri.com/t5/data-management-questions/values-changed-to-0-or-1-when-converting-from-csv/m-p/28635#M1523 <HTML><HEAD></HEAD><BODY><P>Could you attach a sample of the CSV data? This help us to better analyse the issue.</P></BODY></HTML> Fri, 16 Dec 2016 20:42:51 GMT JayantaPoddar 2016-12-16T20:42:51Z Values changed to 0 or 1 when converting from .csv to .shp https://community.esri.com/t5/data-management-questions/values-changed-to-0-or-1-when-converting-from-csv/m-p/28634#M1522 <HTML><HEAD></HEAD><BODY><P>Hi everyone! I am converting a series of large datasets (&gt;60,000 rows) from .csv to .shp files. These are files with quantified LiDAR metrics. However, when I convert these files from .csv to .shp, I've noticed that several of the values go missing (changed to either 0 or 1) in the attribute table. Is there a work-around for this? I attached screenshots of both tables to show what's happening. Thank you in advance for your help!</P></BODY></HTML> Fri, 16 Dec 2016 20:34:32 GMT https://community.esri.com/t5/data-management-questions/values-changed-to-0-or-1-when-converting-from-csv/m-p/28634#M1522 ChristineButterfield 2016-12-16T20:34:32Z Re: Values changed to 0 or 1 when converting from .csv to .shp https://community.esri.com/t5/data-management-questions/values-changed-to-0-or-1-when-converting-from-csv/m-p/28635#M1523 <HTML><HEAD></HEAD><BODY><P>Could you attach a sample of the CSV data? This help us to better analyse the issue.</P></BODY></HTML> Fri, 16 Dec 2016 20:42:51 GMT https://community.esri.com/t5/data-management-questions/values-changed-to-0-or-1-when-converting-from-csv/m-p/28635#M1523 JayantaPoddar 2016-12-16T20:42:51Z Re: Values changed to 0 or 1 when converting from .csv to .shp https://community.esri.com/t5/data-management-questions/values-changed-to-0-or-1-when-converting-from-csv/m-p/28636#M1524 <HTML><HEAD></HEAD><BODY><P>I added a 40-row sample to the original post.</P></BODY></HTML> Fri, 16 Dec 2016 21:28:20 GMT https://community.esri.com/t5/data-management-questions/values-changed-to-0-or-1-when-converting-from-csv/m-p/28636#M1524 ChristineButterfield 2016-12-16T21:28:20Z Re: Values changed to 0 or 1 when converting from .csv to .shp https://community.esri.com/t5/data-management-questions/values-changed-to-0-or-1-when-converting-from-csv/m-p/28637#M1525 <HTML><HEAD></HEAD><BODY><P>It seems like it was changing my data because of the column names, which had numbers in them. *sigh*</P></BODY></HTML> Fri, 16 Dec 2016 21:32:50 GMT https://community.esri.com/t5/data-management-questions/values-changed-to-0-or-1-when-converting-from-csv/m-p/28637#M1525 ChristineButterfield 2016-12-16T21:32:50Z Re: Values changed to 0 or 1 when converting from .csv to .shp https://community.esri.com/t5/data-management-questions/values-changed-to-0-or-1-when-converting-from-csv/m-p/28638#M1526 <HTML><HEAD></HEAD><BODY><P>good &nbsp;guess is that the fields are being read as an integer type because of the first row. &nbsp;Fix the format of the csv so that the data type is obviously floating point ie 0.0000. &nbsp;If the csv is originating from some piece of software, format the columns explicitly with the desired number of decimal points to ensure proper numeric conversion. &nbsp;Data are generally not upcast to a higher level</P></BODY></HTML> Fri, 16 Dec 2016 21:34:47 GMT https://community.esri.com/t5/data-management-questions/values-changed-to-0-or-1-when-converting-from-csv/m-p/28638#M1526 DanPatterson_Retired 2016-12-16T21:34:47Z Re: Values changed to 0 or 1 when converting from .csv to .shp https://community.esri.com/t5/data-management-questions/values-changed-to-0-or-1-when-converting-from-csv/m-p/28639#M1527 <HTML><HEAD></HEAD><BODY><P>Thank you Christine,</P><P>Here is what you need to do</P><P>EDIT: Copy the 3rd row of values to 1st row as mentioned by <A href="https://community.esri.com/people/Dan_Patterson">Dan_Patterson</A>‌. Then follow these steps.</P><P>1. Open the CSV file on ArcMap (Drag from Arccatalog, drop on Table of Contents of ArcMap)</P><P>2. Right-click CSV file &gt; Display XY Data.</P><P></P><P><IMG __jive_id="285122" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/285122_pastedImage_1.png" /></P><P></P><P>3. The resulting Event layer will now consider the Fields as DOUBLE (and not LONG as earlier).</P><P>4. Export the Event Layer to Shapefile. A snapshot of the attribute table is shown below.</P><P><IMG __jive_id="285123" class="image-2 jive-image" src="https://community.esri.com/legacyfs/online/285123_pastedImage_2.png" /></P></BODY></HTML> Fri, 16 Dec 2016 21:52:00 GMT https://community.esri.com/t5/data-management-questions/values-changed-to-0-or-1-when-converting-from-csv/m-p/28639#M1527 JayantaPoddar 2016-12-16T21:52:00Z