topic Re: Add a feature layer (published from a csv file) to a webmap in ArcGIS API for Python Questions

Add a feature layer (published from a csv file) to a webmap

DonaldPike — Tue, 08 Aug 2023 18:11:44 GMT

Hello,
I have an existing feature layer published from a csv file that I'm trying to add to a webmap. I have the following code that runs without errors but when I go back into the GUI (through ArcGIS online) the layer doesn't show up as having been added.

from arcgis.gis import GIS from arcgis.mapping import WebMap from arcgis.features import FeatureLayer from pprint import pprint print("Logging in...") gis = GIS("https://fotnf.maps.arcgis.com/", "friendsofthetonto", "XXXXXXXX") print(f"Connected to {gis.properties.portalHostname} as {gis.users.me.username}") webmap_item = gis.content.get('e1405425e52d43689cfdaecd43e0239d') webmap = WebMap(webmap_item) csv_item2 = gis.content.get('ec6e29fe17a44512887d761f5e3524d6') csv_layer2 = FeatureLayer(csv_item2.url) webmap.add_layer(csv_item2) webmap_item.update(data=webmap)

Re: Add a feature layer (published from a csv file) to a webmap

DonaldPike — Tue, 08 Aug 2023 18:17:43 GMT

BTW, this is using version 2.1.0.3 of the arcgis python package.

Re: Add a feature layer (published from a csv file) to a webmap

jcarlson — Tue, 08 Aug 2023 18:37:23 GMT

Creating a FeatureLayer requires the URL to be the full path to the individual layer. I might have a URL like this:

https://maps.co.kendall.il.us/server/rest/services/Hosted/Cemeteries/FeatureServer

But that's the URL for the service. The layer itself is:

https://maps.co.kendall.il.us/server/rest/services/Hosted/Cemeteries/FeatureServer/0

If your service only has a single layer in it, you can access it by using csv_item2.layers[0], which returns a FeatureLayer object, and you can bypass calling the FeatureLayer constructor.

Re: Add a feature layer (published from a csv file) to a webmap

DonaldPike — Tue, 08 Aug 2023 23:33:55 GMT

Thanks for the suggestion.

I tried changing the code to the following (passing csv_item2.layers[0] directly into webmap.add_layer()):

from arcgis.gis import GIS from arcgis.mapping import WebMap from arcgis.features import FeatureLayer from pprint import pprint print("Logging in...") gis = GIS("https://fotnf.maps.arcgis.com/", "friendsofthetonto", "XXXXXXXX") print(f"Connected to {gis.properties.portalHostname} as {gis.users.me.username}") webmap_item = gis.content.get('e1405425e52d43689cfdaecd43e0239d') webmap = WebMap(webmap_item) csv_item2 = gis.content.get('ec6e29fe17a44512887d761f5e3524d6') # csv_layer2 = FeatureLayer(csv_item2.url) webmap.add_layer(csv_item2.layers[0]) webmap_item.update(data=webmap)

But I'm still getting the same result where the code runs without errors but the new layer doesn't show up.

Here's a screencast of the issue:
https://d.pr/v/RNdZiv

Re: Add a feature layer (published from a csv file) to a webmap

Clubdebambos — Wed, 23 Aug 2023 10:58:53 GMT

Hi @DonaldPike

If your csv_item2 is a CSV item you will need to publish the CSV Item as a Feature Service first before you can add the Feature Layer from within this Feature Service to a WebMap. (it can aslo be published as a Table Service and added to a WebMap as a Table)

Re: Add a feature layer (published from a csv file) to a webmap

DonaldPike — Thu, 07 Sep 2023 22:16:29 GMT

I was eventually able to get this working. Here's the code that we ended up with to publish and add the csv layer to an existing webmap:

def update(_args): data_layer_definition = ( get_polys_layout_default() if _args.is_polys else get_points_layout_default() ) popup_config = ( get_polys_popup_config_default() if _args.is_polys else get_points_popup_config_default() ) gis = _args.gis # UPLOAD CSV snake_case_random = uuid.uuid1() points_or_polys_text = "polys" if _args.is_polys else "points" csv_file_orig = _args.data_path / f"Joined.csv" csv_file_new = _args.data_path / f"Joined_{snake_case_random}.csv" shutil.copy(csv_file_orig.resolve(), csv_file_new.resolve()) csv_agol = gis.content.add( item_properties={ "title": f"Temp CSV {points_or_polys_text} {snake_case_random}", }, data=csv_file_new.as_posix(), ) csv_agol.move(f"Oliver") feature_layer = csv_agol.publish() # ASSOCIATE CSV WITH WEBMAP webmap_item = gis.content.get("a752f298d15c4767a34e0b4981245afc") web_map_definition = webmap_item.get_data() title = "Points Status Layer" if _args.is_polys: title = "Polys Status Layer" layer_index = None arcpy.AddMessage("Here 40") arcpy.AddMessage(len(web_map_definition["operationalLayers"])) for index, layer in enumerate(web_map_definition["operationalLayers"]): if layer["title"].startswith(title): layer_index = index break # arcpy.AddMessage("Here 50") # arcpy.AddMessage(web_map_definition["operationalLayers"][layer_index]) arcpy.AddMessage(f"Layer index: {layer_index}") arcpy.AddMessage("Here 50") # arcpy.AddMessage(web_map_definition["operationalLayers"][layer_index]["popupInfo"]) # exit() if layer_index is None: # Add the layer since it doesn't already exist. arcpy.AddMessage("Adding layer") # Add the feature layer's URL to the web map definition's # operationalLayers web_map_definition["operationalLayers"].append( { "id": feature_layer.id, "layerType": "ArcGISFeatureLayer", "url": feature_layer.url, "visibility": True, "layerDefinition": data_layer_definition, "opacity": 1, "title": f"{title} {_args.current_day.strftime('%Y-%m-%d')}", "popupInfo": popup_config, } ) else: # Replace the existing layer arcpy.AddMessage("Replacing layer") web_map_definition["operationalLayers"][layer_index][ "id" ] = feature_layer.id web_map_definition["operationalLayers"][layer_index][ "url" ] = feature_layer.url # Update the title with the current date web_map_definition["operationalLayers"][layer_index][ "title" ] = f"{title} {_args.current_day.strftime('%Y-%m-%d')}" arcpy.AddMessage(web_map_definition["operationalLayers"]) # Add the feature layer's URL to the web map definition's operationalLayers # Update the web map's definition webmap_item.update(data=web_map_definition) arcpy.AddMessage(f"Done")