Add a column to a layer object (inner join) then map amended layer

GagneetSerai — Sat, 12 May 2018 00:19:08 GMT

I'm new to ArcGIS for Python and I've been trying to figure this out for 2 weeks. I am doing this in a ESRI python 3 jupyter notebook. editing feature layer‌ spatial dataframe #jupyter notebook

import pandas as pd
import arcgis
from arcgis.gis import GIS
my_gis = GIS()

#get feature layer
search_subset = my_gis.content.search("SA2_GEN_ID_2011", item_type = "Feature Layer")
subset_item = search_subset[0]
subset_feature_layer = subset_item.layers[0]

#query and create spatialdataframe
query_result = subset_feature_layer.query( where='SA2_MAIN>300000000 AND SA2_MAIN<400000000')
att_data_frame = query_result.df

#merge with suburb risk data (output is now a regular dataframe)
suburb_risk_data = pd.read_csv("https://s3-ap-southeast-2.amazonaws.com/interestrates/stress_example_1.csv")
suburb_risk_data['SA2_MAIN'] = suburb_risk_data['SA2_MAIN'].astype(str)
output = pd.merge(suburb_risk_data, att_data_frame, on='SA2_MAIN', how='inner')

Now i run into difficulty, I don't know how to convert the output dataframe into an object that I can map using the .add_layer() method. The output dataframe has a 'SHAPE' column with the geographical information required for mapping (I think).

#map the merged data (this fails because output is a dataframe)

subset_map = my_gis.map("Queensland, Australia", zoomlevel=6)
subset_map.add_layer(output, { "renderer":"ClassedColorRenderer", "field_name":"stress_likelihood" })
subset_map

I need to edit the layer here because I run a fairly complex python script above this to calculate the variables that I merge with the feature layer. I need to show how the variables change geographically based on the inputs the user provides.

Any help much appreciated!

Re: Add a column to a layer object (inner join) then map amended layer

J_R_Matchett — Sat, 09 Jun 2018 23:26:14 GMT

Does converting the SpatialDataFrame to a FeatureSet work?

subset_map.add_layer(output.to_featureset(), { "renderer":"ClassedColorRenderer", "field_name":"stress_likelihood" })‍‍

topic Add a column to a layer object (inner join) then map amended layer in ArcGIS API for Python Questions

Add a column to a layer object (inner join) then map amended layer

Re: Add a column to a layer object (inner join) then map amended layer