topic Re: Standalone table to Shapefile in ArcGIS Pro Questions

Standalone table to Shapefile

SarahRadel — Mon, 24 Oct 2022 21:04:03 GMT

Good evening, I have ran into a brick wall trying to figure out how I can convert my standalone table to a shapefile. I am working with NLCD data and have made some calculations in excel. I imported my excel to table and I need for the standalone table to become a shapefile. My files do not have x/y just coord. I am hoping someone has the answer to help me convert this standalone table to a shapefile.

Thank you so much in advance.

Re: Standalone table to Shapefile

DanLee — Mon, 24 Oct 2022 21:20:27 GMT

Are they supposed to be polygons? So you have lat/long of the vertices and polygon IDs?

Re: Standalone table to Shapefile

SarahRadel — Mon, 24 Oct 2022 21:51:59 GMT

They are supposed to be thematic

Re: Standalone table to Shapefile

DanLee — Mon, 24 Oct 2022 22:10:01 GMT

Can you share a sample data or show a screenshot of the table?

Re: Standalone table to Shapefile

SarahRadel — Mon, 24 Oct 2022 22:26:39 GMT

Absolutely! Thank you so much for helping me.

Re: Standalone table to Shapefile

DanLee — Mon, 24 Oct 2022 22:58:29 GMT

The csv contains only one row. I don't see any coordinates. Are the coordinates missing from the table? Without coordinates it's impossible to make it a shape.

Re: Standalone table to Shapefile

SarahRadel — Mon, 24 Oct 2022 23:06:43 GMT

I am using nlcd imagery

Re: Standalone table to Shapefile

SarahRadel — Mon, 24 Oct 2022 23:25:04 GMT

So, I copied the center x and center y for the last and added it to my table and then did a display x/y and it did not keep my data 😞

Re: Standalone table to Shapefile

DanLee — Tue, 25 Oct 2022 00:11:55 GMT

This table, USA NLCD Land Cover, is very different from the csv you shared. This looks like a polygon feature class, probably converted from imagery/raster. It has the Shape field, showing "Polygon" type; and it has a Shape_Length field. Perhaps it has a Shape_Area field as well.

The CenterX and CenterY values you have are not long/lat but likely projected coordinates (in meters or ft). When you use Display XY (or actually the Table XY To Points tool), the default for Coordinate System is a GCS (geographic coordinate system), which takes the input xy values as long/lat (in decimal degrees).

You need to find out what projected coordinate values are in the CenterX and CenterY fields and specify that projected coordinate system (PCS) to run the Display XY tool.

Re: Standalone table to Shapefile

SarahRadel — Tue, 25 Oct 2022 00:24:17 GMT

I see that it is projected in North America Albers Equal Area Conic in meters. I'm going to give it try. Fingers crossed!

Re: Standalone table to Shapefile

DanLee — Tue, 25 Oct 2022 00:25:24 GMT

Yes, Fingers crossed! 🙂

Re: Standalone table to Shapefile

SarahRadel — Tue, 25 Oct 2022 00:33:44 GMT

WooHOO! It worked!! Thank you so much for all of your help!

Re: Standalone table to Shapefile

DanLee — Tue, 25 Oct 2022 00:43:06 GMT

Excellent! Glad to be able to help. You are very welcome. 🙂

Re: Standalone table to Shapefile

SarahRadel — Tue, 25 Oct 2022 00:49:53 GMT

One more thing....my point is now in Kansas! Can I go to project and change the projection?

Re: Standalone table to Shapefile

DanLee — Tue, 25 Oct 2022 17:42:41 GMT

Yes, you can change your Map - Properties - Coordinate System. Or you can project your data to a desired projection using the Project tool.

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/project.htm

Re: Standalone table to Shapefile

SarahRadel — Tue, 25 Oct 2022 20:25:18 GMT

Thank you so much for all of your help!

Re: Standalone table to Shapefile

DanLee — Tue, 25 Oct 2022 20:30:58 GMT

You are welcome. Good luck with your project!