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

Can you import multiple geocoded png files as point symbols?

DavidZiegler

I have a hundreds of company logo png files that I am trying to batch import as point symbols. I haven't had much luck batch importing them to XY points (seems you have to do it individually...way too many for this).

However, could one geocode (associated XY coords) with the png files (via some software, or other) and then import them as point symbols?

Find more posts tagged with

Content Management

Geodatabase

Feature Services

Accepted answers

JohannesLindner

You could assign geotags to the logos and run GeotaggedPhotosToPoints, creating an attachment tables from the logos and then symbolize the points with the attachments (see last point of the list below).

This might be simpler and can be done completely in ArcGIS:

Input: Table (Excel/CSV/etc) with X, Y, LogoPath
import table into ArcGIS Pro
right-click on the table -> Display XY Data -> save as point feature class
add field LogoData (BLOB)
read the logos into the feature class with this python script (run in ArcGIS Pro Python window)

with arcpy.da.UpdateCursor("NameOfLogoLayer", ["LogoPath", "LogoData"]) as cursor:
    for row in cursor:
        with open(row[0], "rb") as f:
            cursor.updateRow([row[0], f.read()])

symbolize the layer
- Single Symbol
- Allow symbol property connections
- Picture Marker, map File to LogoData, set size

Result:

All comments

JoeBorgione

How wide-spread geographically are you points? You could georeference the images if you can figure out ground truth monuments. Do this images have some sort of xy notation?

DavidZiegler

Joe, I have found programs that can assign lat-long (i.e. from an excel sheet with XY and png file columns) to each png file.

JohannesLindner

This might be simpler and can be done completely in ArcGIS:

Input: Table (Excel/CSV/etc) with X, Y, LogoPath
import table into ArcGIS Pro
right-click on the table -> Display XY Data -> save as point feature class
add field LogoData (BLOB)
read the logos into the feature class with this python script (run in ArcGIS Pro Python window)

with arcpy.da.UpdateCursor("NameOfLogoLayer", ["LogoPath", "LogoData"]) as cursor:
    for row in cursor:
        with open(row[0], "rb") as f:
            cursor.updateRow([row[0], f.read()])

symbolize the layer
- Single Symbol
- Allow symbol property connections
- Picture Marker, map File to LogoData, set size

Result:

DavidZiegler

I am going to try this. Thanks for providing this--I hope it works. I may come back to ask you questions.

DavidZiegler

add field LogoData (BLOB)

[Johannes, what does this mean?]

JohannesLindner

@DavidZiegler Create a new field in the point feature class with the name "LogoData" and the field type BLOB (Binary Large OBject).

Fields of this type can store byte data, so everything you can think of. Images, PDFs, Excel, Word, music, video, etc.

We're going to use it to store the logo files directly in the feature class.

DavidZiegler

Johannes,

I put the code verbatim into the Python script window (found in analysis); but, how do I run it? I don't see a go, or run.

JohannesLindner

Change NameOfLogoLayer to the actual name of the logo layer (or the path to the feature class).

To run, skip to the end of the code and press enter.

DavidZiegler

Does the Python need to be activated?

DavidZiegler

Johannes: Sent you a direct message with attachment.

DavidZiegler

Johannes: Sent another attachment, with code--the code ran this time, but got an error. Screen capture is in private message. Again, many thanks.

DavidZiegler

Johannes: I have the URL of the logo in logo path--but what goes into logo data? I have nothing in that column--what should be there?

DavidZiegler

Johannes has provided an effective path here to putting multiple company or other picture (png or other) logos on a map. I can't thank him enough.

DavidZiegler

IT WORKED!!

DavidZiegler

Ultimately, after several errors on my part, IT WORKED!

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.