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; } } }

Types de champs pour la géocodification

dgiersz_cuyahoga

Lorsque j'essaie d'ajouter des données Excel en utilisant le type d'emplacement Adresse, seuls les champs texte apparaissent dans les listes déroulantes pour choisir les champs à utiliser. Changer les champs numériques en texte ne fait aucune différence. Comment puis-je faire en sorte qu'il reconnaisse les champs dont j'ai besoin pour la géolocalisation ?

Trouver plus de publications taguées avec

Accepted answers

dgiersz_cuyahoga

Yeah, the workaround I gave the end user was to calculate a new column with the number and street together.

However, I just tested adding a non-numeric character (an empty space after the number) to one row in the number column and that was enough for the dropdowns to show the column.

It's interesting that the ZIP dropdown shows all field types, but the other fields only show strings.

All comments

dgiersz_cuyahoga

Yeah, the workaround I gave the end user was to calculate a new column with the number and street together.

However, I just tested adding a non-numeric character (an empty space after the number) to one row in the number column and that was enough for the dropdowns to show the column.

It's interesting that the ZIP dropdown shows all field types, but the other fields only show strings.

ShannonCardoza

I think some additional formatting is needed, see below when I tried it:

I used the address column for street number, street for street name and so on. Is that an option for you (to format or prep the data a bit more)?

-SC

dgiersz_cuyahoga

Thanks for the reply @ShannonCardoza! Yes, the dropdown for ZIP (and ZIP+4) include every field, even the number fields. I also changed the field types of all cells to Text but that doesn't help.

I want to put the house number in the 'Address or Place' field then the street name in the 'Address2' field, but it appears only the ZIP fields accept numbers.

ShannonCardoza

Good afternoon @dgiersz_cuyahoga,

Thank you for your post. From the screenshot, I cannot tell but if you scroll down to another field, for example Zip code can you see additional options in the dropdown field? Here is a recording of me trying to recreate your workflow and I didnt see an issue to select the appropriate fields for geolocating.

Did you change any of the formatting in Excel?

You may also find our documentation, Work with data types helpful. I look forward to your reply!

Thanks,

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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