topic Re: Load data in a Feature Class in Data Management Questions

Load data in a Feature Class

PasqualeLanera1 — Tue, 15 Jan 2013 15:44:24 GMT

I have created an empty Feature Class in Geographic WGS84. After I have tried to upload data from a table (mdb, csv o xls) with the Loadre Wizard. The feature class is uploaded with all data but nothing point is been projected on the map. Why ?
In the table the wgs84 coordinate are in two fields: longitude and latitude.

Could you help me ?

Re: Load data in a Feature Class

ThomasFurcron — Tue, 15 Jan 2013 16:58:19 GMT

You can't just load a table into a feature class. You will have to add the table to ArcMap then right click on it and say Plot XY data and specify the X and Y fields (Lat & Long). Once it plots that information you should be able to take that and load it into your geodatabase.

Tom

Re: Load data in a Feature Class

PasqualeLanera1 — Wed, 16 Jan 2013 06:52:03 GMT

You can't just load a table into a feature class. You will have to add the table to ArcMap then right click on it and say Plot XY data and specify the X and Y fields (Lat & Long). Once it plots that information you should be able to take that and load it into your geodatabase.

Tom

Thanks a lot. Your procedure run !!!
But ...
I have some problem with some field data type.
The original data are from an Excel file. In the original file some coloumn are numeric (I choose numeric format from the FormatCell - right click) but when I load the spreendsheet in ArcMap the same data are converted in text. WHY ???
I can't understand the motive. I checked for the right decimal delimiting carachter or the presence of '. Nothing to do.
Is it possible to change the field data type in a Table or Feature Class in ArcGIS ?

Re: Load data in a Feature Class

ThomasFurcron — Thu, 17 Jan 2013 12:33:06 GMT

Thanks a lot. Your procedure run !!!
But ...
I have some problem with some field data type.
The original data are from an Excel file. In the original file some coloumn are numeric (I choose numeric format from the FormatCell - right click) but when I load the spreendsheet in ArcMap the same data are converted in text. WHY ???
I can't understand the motive. I checked for the right decimal delimiting carachter or the presence of '. Nothing to do.
Is it possible to change the field data type in a Table or Feature Class in ArcGIS ?

It does not always bring in data from ecel correctly. I would just create a geodatabase and import the table and add new fields and then calculate them to the correct format that you need.

Good Luck
Tom

Re: Load data in a Feature Class

PasqualeLanera1 — Thu, 17 Jan 2013 13:38:41 GMT

It does not always bring in data from ecel correctly. I would just create a geodatabase and import the table and add new fields and then calculate them to the correct format that you need.

Good Luck
Tom

Thank a lot.
After I have spent some time I have understand the problem.