Latest Contributions by MehdiPira1

Hi Louis K.‌ Here's the script that does what you are after: from arcgis.gis import GIS from arcgis.features import SpatialDataFrame import pandas as pd gis = GIS(portal, "username", "password", verify_cert=False) print("Connected") search_result = gis.content.search(query="owner: s*", item_type="Feature Service", sort_field="numViews", sort_order="asc", max_items=5000) df_list = [] for item in search_result: items = item.items() df = pd.DataFrame.from_dict(items) dfTransposed = df.T dfTransposed.columns = dfTransposed.iloc[0] dfTransposed = dfTransposed[1:] dfTransposed = dfTransposed.set_index('name', inplace=False) dfTransposed = dfTransposed[["owner", "created", "modified", "numViews"]] df_list.append(dfTransposed) merged_df = pd.concat(df_list) # export to excel merged_df.to_excel(r"Path to output.xlsx")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Just input your destination path for the excel output to the script. ... View more

Hi Matt Starry (SWLP)‌, Can you please explain more about what you are trying to achieve? ... View more

Hi Cara Joos‌, WhatDavid Pike‌'s mentioned above is right. However, if you are after tools out of the toolbox, you can use Dissolve tool for the polyline provided that it has a field with the same value so that you could use it as a dissolve parameter/field to aggregate features. you can add a field with same values if it's not already there. Once the polyline feature class is aggregated (continuous), use the Feature to Polygon tool.          =>           =>    Note that sometimes just using the Feature to Polygon tool will do the split without using the Dissolve tool, depending on your polyline feature class. I hope that's helpful. Cheers. ... View more

Hi Alberto Cañivano‌ I tested the same code with a sample feature layer and it's working fine.  I just changed the item.tables index to 0 as I only have one related table to the feature layer. item = gis.content.get("xxxxxxxxxxxx") foto = (item.tables)[0] field_service_dataframe = pd.DataFrame.spatial.from_layer(foto) field_service_dataframe‍‍‍‍ Output: I recommend check you feature layer first, then change the index. you can also check the code on other feature layers to see if it throws the same error. I hope that helps. ... View more

Hi Eric Wagner‌, I was wondering if it would be possible to update or customize surveys by adding more questions and republishing and then customize the dashboards. Thanks Mehdi ... View more

Hi Christian Bischof, Here's the python code which takes an excel file with a startpoint and endpoint column each containing x and y coordinates as input and outputs an excel file with shape_length (distance) calculated in a new column. Just change the variables' values, sheet name and the spatial_reference accordingly it should work. import arcpy import pandas as pd excelTable = r"D:\temp\XY_Coordinates.xlsx" csvTable = r"D:\temp\out_csv.csv" outputFC = r"D:\temp\output.gdb\out_coordinates" out_Excel = r"D:\temp\XY_Coordinates_output.xlsx" arcpy.env.overwriteOutput = True read_file = pd.read_excel (excelTable, sheet_name='Sheet1') read_file.to_csv (csvTable, index = None, header=True) # Convert x and y coordinates into line arcpy.XYToLine_management( csvTable, outputFC, 'Start_X', 'Start_Y', 'End_X', 'End_Y', 'NORMAL_SECTION', '#', "PROJCS['GDA_1994_MGA_Zone_50',GEOGCS['GCS_GDA_1994',DATUM['D_GDA_1994',SPHEROID['GRS_1980',6378137.0,298.257222101]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Transverse_Mercator'],PARAMETER['False_Easting',500000.0],PARAMETER['False_Northing',10000000.0],PARAMETER['Central_Meridian',117.0],PARAMETER['Scale_Factor',0.9996],PARAMETER['Latitude_Of_Origin',0.0],UNIT['Meter',1.0]];-5120900 1900 10000;-100000 10000;-100000 10000;0.001;0.001;0.001;IsHighPrecision" ) # Converting gdb feature class attribute to Excel arcpy.TableToExcel_conversion(outputFC, out_Excel)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Here's a screenshot of the output: ... View more

Not a problem Modern Electric‌. Great to hear that Could you please flag the question as Answered? Thanks. ... View more

Not a problem, Kathy Gillis‌ This sign # is for Priority Ranks. Refer to the link below for more info: Priority ranks and geoprocessing tools—Help | Documentation  ... View more