Exporting from SDE Feature Class to Shapefile, Field Name Issue

1739
3
Jump to solution
03-21-2017 10:58 PM
BenVan_Kesteren1
Occasional Contributor III

Hey All, 

I have a feature class that resides within my SDE, I have added this to an ArcMap document, and created a join to a SQL Query Layer, the Table view looks good, showing field names, not alias.

So I then run the Feature Class to Feature Class tool to convert it to a shapefile.

I then take a look at the resultant shapefile, and I note that the field names have been exported, not retaining the Alias as viewed within the MXD.

What I am wanting is to retain the field alias (or as much as possible with the naming constraints of a shapefile). Any ideas on how I can achieve this?

Here is the original Feature Class properties:

Original Feature Class within SDE

I think create a join to my SQL Query Layer:

I then run Feature Class to Feature Class tool, and this is the name of the output fields:

0 Kudos
1 Solution

Accepted Solutions
DanPatterson_Retired
MVP Emeritus
3 Replies
DanPatterson_Retired
MVP Emeritus

Do you try the field mapping option ?

BenVan_Kesteren1
Occasional Contributor III

Excellent, exactly what I require. I previously thought field mapping was for changing field types from one to another, I didn't realise that we could rename at the same time.

Thats fantastic, exactly what I required.

Cheers

0 Kudos
NeilAyres
MVP Alum

There are a lot of restrictions in the 30(?) year old shapefile format. One is the width of the column headers, which I think is 10 characters.

Don't think that alias' are supported at all.

ESRI Shapefile / DBF 

geotools - How to bypass 10 character limit of field name in ShapeFiles? - Geographic Information Sy...