Latest Contributions by forestknutsen1

The certificate popup window warnings are a real-time suck for me in dev environments that don't have proper certificates when calling arcpy.CreateGeocodeSDDraft. Can a parameter be added to the arcpy server calls to suppress the warning? This problem makes arcpy useless in some situations.     print "Create sddraft" analyze_message = arcpy.CreateGeocodeSDDraft(loc_path=loc_path,                                              out_sddraft=out_sddraft,                                              service_name=service_name,                                              server_type=server_type,                                              connection_file_path=connection_file_path,                                              copy_data_to_server=copy_data_to_server,                                              supported_operations=supported_operations,                                              folder_name=folder_name) suppress certificate warning   ... View more

I am looking into extracting feature classes from our SDE (oracle). Is it possible to extract the feature using the representation geometry for the feature instead of the normal geometry? I can see hex values in the blob in the representation override field within oracle.  ... View more

How robust is 3D data support in the UN? We are interested in visualizing underground features: vaults, conduits, and cables. We may like to add transformers, fuses, switches, etc. at some point. Can someone point us to some examples? Thanks! ... View more

I have a pandas data frame (df) that I want to put into an Esri table in sde. I am having a hard time dealing with the datatypes in an effective way. All the columns in the df have the datatype object. So, after some digging, it looks like strings get the data-type object in pandas. There is a good explication for why this is on StackOverflow: python - Strings in a DataFrame, but dtype is object - Stack Overflow  All, well and good. After I convert it to a numpy array the datatype is 'O' and then to an Esri table it fails. I think the problem is in the datatype. When I set the datatype to '|S256' it works fine. I also suspect that some of the columns have a data type of int or float.  So, I need an elegant way to detect the data type and assign it to the numpy array. Suggestions? This is the code so far. It works fine. I am dropping down to one column for testing. But, there are around 250 columns between two tables in the real data. from sodapy import Socrata import cama_helper client = Socrata('data.muni.org', None) if __name__ == '__main__': client = Socrata('data.muni.org', None) for cama_id, cama_name in {'r3di-nq2j': 'cama_residential', 'ijws-5rpw': 'cama_commercial'}.items(): df = cama_helper.get_data_as_panda(client, cama_id) cama_helper.load_sde(df, cama_name) # cama_helper import pandas import arcpy import numpy def get_data_as_panda(client, cama_id): results = client.get(cama_id, limit=20) df = pandas.DataFrame.from_records(results) df.drop(df.columns[[0, 1, 2]], axis=1, inplace=True) return df def load_sde(df, cama_name, connection=None): s = df.iloc[:, 1] df = s.to_frame() #numpy_array = df.to_records() numpy_array = df.to_numpy() numpy_array2 = numpy.array(numpy_array, numpy.dtype([('textfield', '|S256')])) arcpy.da.NumPyArrayToTable(numpy_array2, r'Temp.gdb\{}'.format(cama_name)) ... View more

I have marker symbol for a representation that I would like to use as a "normal" point symbol (no representation) for a different feature class. I tried this: How to save a representation rule from a representation in a style Organizing representation rules with styles—Help | ArcGIS for Desktop  But the resulting style was not available in the symbol selection dialog for the point feature class. I am guessing that the style can only be used as a representation.  ... View more

Is there a way to test if annotation is feature linked with arcpy? ... View more

After cloning a map to a production portal I want to change the map owner and the folder it is in...  So, first I get the item I want to change in the target portal. Then I try and reassign it. item.reassign_to('user first and last name', target_folder='test')‍ Then I get an error: RuntimeError: You do not have permissions to access this resource or perform this operation. I am an admin on the portal. I have also tried with the site admin user without any luck. What am I doing wrong? Thanks! ... View more