|
IDEA
|
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
12-11-2019
10:38 AM
|
3
|
0
|
694
|
|
POST
|
Bumping this one up... I am sure someone has some info on this one...
... View more
12-11-2019
10:21 AM
|
4
|
1
|
1092
|
|
POST
|
https://community.esri.com/thread/241323-export-geometry-from-override-field This is a related question.
... View more
12-06-2019
05:52 PM
|
0
|
1
|
1075
|
|
POST
|
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
12-06-2019
03:01 PM
|
0
|
2
|
1170
|
|
POST
|
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
12-04-2019
09:57 AM
|
4
|
2
|
1199
|
|
POST
|
Thanks Dan. I think I am just going to stop fighting it and stuff everything into Oracle as strings. Then the applications on the other side can add validation as needed.
... View more
10-30-2019
02:30 PM
|
0
|
0
|
10815
|
|
POST
|
a dtype of object is a tough one since there is no guarantee that any of the objects in the array have a common dtype, especially if it contains geometry. So, most of the columns have string values, but some have date or integer values. So, would I need to iterate over each value in every row and test (for string, int, float, date) for each column to nail down the datatypes? How are you getting the array? (as a *.npy or *,npz file are best) It starts as a list of dictionaries. Then I turn it into pandas and then into a numpy array. There does not appear to be any datatype information. The shape of the array in (20, ) which is weird. I would have thought it would (20, 130) or something. (keep in mind that I am only grabbing the first 20 rows of the dataset. The real thing has a few hundred thousand rows) the shape for array[0] and array[-1] are (). which also feels weird. I guess I don't understand shape in this case.
... View more
10-29-2019
12:38 PM
|
0
|
0
|
10815
|
|
POST
|
Thanks Dan. I get the structured array bit. The problem is that the source df from the city is all of the type object. So, it would be nice to detect the "true" data type of each column and assign that to the structured array. I guess I could do it by hand and then make a fixed schema to load the data into but with 270 columns this could be quite the task. Also, it would be nice to have the program be dynamic so that if the source schema changed the schema in sde could be made to reflect it.
... View more
10-29-2019
09:14 AM
|
0
|
1
|
10815
|
|
POST
|
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
10-28-2019
04:21 PM
|
0
|
7
|
12290
|
|
POST
|
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
10-24-2019
03:29 PM
|
0
|
0
|
790
|
|
POST
|
arcpy.Delete_management (relationship) Delete—Help | ArcGIS for Desktop Can you not just call delete?
... View more
10-11-2019
10:46 AM
|
1
|
0
|
2609
|
|
POST
|
So, right now I am just checking if a relationship exists. If it does I am making the assumption that it is feature linked. But this feels a little soft. I am I missing it someplace in the describe object?
... View more
09-17-2019
02:52 PM
|
0
|
0
|
872
|
|
POST
|
Is there a way to test if annotation is feature linked with arcpy?
... View more
09-17-2019
02:37 PM
|
0
|
1
|
898
|
|
POST
|
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
09-10-2019
05:22 PM
|
0
|
1
|
2115
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 10-04-2024 05:39 PM | |
| 1 | 07-30-2024 09:05 AM | |
| 1 | 07-08-2024 05:32 PM | |
| 1 | 03-20-2024 10:27 AM | |
| 6 | 03-13-2024 03:38 PM |
| Online Status |
Offline
|
| Date Last Visited |
11-12-2025
11:02 AM
|