topic Re: Import csv into ArcGIS Pro in ArcGIS Pro Questions

Import csv into ArcGIS Pro

ChuckChamberlain — Wed, 06 Sep 2017 14:41:10 GMT

Hello, I'm currently trialing ArcGIS pro. I have some historical climate data I'm trying to import into ArcGIS, but I'm not sure exactly how to load in the data. Its in the csv format. I have attached a sample. Any suggestions on how to import this would be greatly appreciated. Thankyou

Re: Import csv into ArcGIS Pro

JakeSkinner — Wed, 06 Sep 2017 15:05:30 GMT

Hi Chuck,

Can you give some more background on what you would like to do with the data?

For the ip46Pts.csv file, you can display these as points by adding the table to Pro > right-click on table > Display XY Data.

Re: Import csv into ArcGIS Pro

JayantaPoddar — Wed, 06 Sep 2017 15:49:59 GMT

You could try Add x,y coordinate data as a layer—ArcGIS Pro | ArcGIS Desktop

Re: Import csv into ArcGIS Pro

ChuckChamberlain — Wed, 06 Sep 2017 17:22:13 GMT

Thanks Jake,

Some additional info:

This contains 119 years of ensembled climate data (from 1981 to 2100) for the given area.

The dataset includes daily precipitation Precipitation;
We generated climate data on each of the grids on and in the watershed
Data are provided in probabilistic statistics output format, i.e., 10^th percentile, 50^th percentile and 90^th percentile; Obviously 50^th percentile results are the most likely 10^th and 90^th percentiles and two extremes with less possibility of occurrence.Looking to have the data displayed so that an anayst can look for trends over time in preciptiation, and look at different probabilitic outcomes (10%, 50%, or 90%).

thanks

Re: Import csv into ArcGIS Pro

JakeSkinner — Wed, 06 Sep 2017 17:41:19 GMT

Does the GRID_ID correspond to the POINT_ID? For example, are you looking to create a join based off of these fields?

Re: Import csv into ArcGIS Pro

ChuckChamberlain — Wed, 06 Sep 2017 18:16:34 GMT

yes, exactly - i think I need to somehow join these fields

Re: Import csv into ArcGIS Pro

JakeSkinner — Wed, 06 Sep 2017 19:00:20 GMT

You can do this, but you need to format the precipitation table differently. For example:

DailyPrecipitation	GRID_ID	Percentile	Pr (mm)
1/1/1981	1	10	2.3
1/1/1981	1	50	3.2
1/1/1981	1	90	6.1
2/1/1981	2	10	1.2

You can then join this table to the XY Data:

Joins and relates—ArcGIS Pro | ArcGIS Desktop