nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Hosted Feature layer - Enforces lower case field names????

Andrew-Bowne

Are lower case field names enforced in a hosted feature layer? I am trying to use all UPPER CASE field names (as I learned was the standard many many years ago) and the field keep defaulting to all lower.

This is causing some issues in a custom app that we have which is looking for uppercase field names.

Find more posts tagged with

Data and services

Accepted answers

ChristopherCounsell

The ArcGIS Data Store leverages PostgreSQL as an internal database. This only supports lower case field names.

All field names must be lowercase when publishing Hosted Feature Layers to ArcGIS Enterprise.

I don't have an enterprise documentation link but it's listed as a limitation in the Survey123/Enterprise documentation:

https://doc.arcgis.com/en/survey123/get-started/survey123withenterprise.htm#ESRI_SECTION1_F5A1901B74F54A728668DC98AA2FDFCB

All comments

MapNat

Thank you for this! Explained why a feature layer shared via distributed collaboration (feature layer in the source portal, hosted feature layer in the target portal) had mixed case field names in the source but came through with lowercase field names.

GrahamWood-HWC

Thanks Chris.

This was once classified as a bug but the archived enterprise doccos point out that this is a limitation of data store using PostgreSQL..
https://support.esri.com/en-us/bug/when-publishing-a-hosted-feature-service-to-portal-for-bug-000099829

Andrew-Bowne

Thanks, Chris. I had a a feeling that this might be the case. I am just not very familiar with PostgreSQL. It's an unfortunate limitation.

I looked everywhere and could not find any sort of documentation about the limitation. Thanks for finding something (in a rather obscure place).

ChristopherCounsell

The ArcGIS Data Store leverages PostgreSQL as an internal database. This only supports lower case field names.

All field names must be lowercase when publishing Hosted Feature Layers to ArcGIS Enterprise.

I don't have an enterprise documentation link but it's listed as a limitation in the Survey123/Enterprise documentation:

https://doc.arcgis.com/en/survey123/get-started/survey123withenterprise.htm#ESRI_SECTION1_F5A1901B74F54A728668DC98AA2FDFCB

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.