|
POST
|
I am getting a oracle error. The field name length violates the oracle column length.
... View more
11-19-2018
10:48 AM
|
0
|
3
|
1780
|
|
POST
|
We have some python code the scrapes fgdb's off a public site and loads them into an oracle sde. However, one of the feature classes has a very long field name that is making arcpy copy features puke. What is the best way to truncate this field name? I have thought of a few options -- none of which I am thrilled with... 1) export to shapefile then copy that into sde 2) read the fc shcema info with arcpy and build a new fc with that truncates field names as needed. Then append the original data into the new fc with field mapping objects Anyone have a more elegant solution?
... View more
11-19-2018
09:26 AM
|
0
|
5
|
1899
|
|
POST
|
Thanks Joshua. So, I am guessing that you would feel the same way about analyze/statistics... There is no reason why we cannot implement the python. It is just the that the DBA and the senior GIS analyst programmer feel that esri's python functions are redundant.
... View more
11-13-2018
09:21 AM
|
0
|
2
|
3932
|
|
POST
|
We are trying to improve our geodatabase health. So we would like to: Rebuild Indexes—Help | ArcGIS for Desktop Update database statistics—Help | ArcGIS Desktop after a compress with arcpy. According to our DBA oracle is already doing this as needed. Using estimate statistics and rebuild indexes. As I understand it oracle preforms an "analysis" per table to see if the estimate statistics and/or rebuild indexes is needed for any given table. So, my questions are: 1) Is the rebuild indexes arcpy function the same as calling oracle's rebuild index? 2) Is the analyze arcpy function the same as calling oracle's estimate statistics? 3) Can we just go with what oracle has in place or is it recommended that we update indexes and statistics with arcpy after a compress?
... View more
11-12-2018
02:54 PM
|
0
|
7
|
4349
|
|
POST
|
I have a python scrip that uploads a service definition file to a server. When I run the code I get the below message. Is there a way to suppress this? I would like to run the python script as a batch job with task manager... it looks like when it hits this it just hangs. I have a sever connection file that uses http. import arcpy
import os
loc_path = r"\\xxx\CW_Composite.loc"
out_sddraft = r"\\xxx\cw_xsys_geocoder.sddraft"
service_name = "CW_Composite_xsys_py"
server_type = "FROM_CONNECTION_FILE"
connection_file_path = r"\\xxx\ceav456_admin.ags"
copy_data_to_server = True
folder_name = "Locators"
supported_operations = ["GEOCODE", "REVERSE_GEOCODE"]
out_sd = r"\\xxx\cw_xsys_geocoder.sd"
def delete_file(sd_file):
if os.path.isfile(sd_file):
os.remove(sd_file)
delete_file(out_sddraft)
delete_file(out_sd)
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)
if analyze_message["errors"] == {}:
print "Create sd file"
arcpy.server.StageService(out_sddraft, out_sd)
print "Upload service"
arcpy.server.UploadServiceDefinition(out_sd, connection_file_path)
print "Done!"
... View more
09-22-2018
12:00 PM
|
0
|
1
|
1677
|
|
POST
|
I have noticed the env overwrite is not always honored. I typically delete (as Dan suggested) or add a number to the end of my names and increment it to generate unqunie names,
... View more
09-10-2018
09:41 AM
|
0
|
0
|
2769
|
|
POST
|
Thanks Jonathan and George. Yes, we know that support for 10.2 is ending soon. We are ArcFM users--this has been holding us back (also we have corruption in our versions within sde ). But we hope to move forward as fast as possible to stay in a supported version. I understand that we had problems with shared log past. So, there is not a lot of appetite for that approach in the team.
... View more
09-06-2018
05:44 PM
|
0
|
0
|
3941
|
|
POST
|
What about comparing all used domain values with a table of all domain values? Get a table of all domains Table To Domain—Help | ArcGIS for Desktop Get a unique list of all domains with Summarize Attributes—GeoAnalytics Tools | ArcGIS Desktop, you may have to merge and re-summarize if your domain is on more then one table Or better yet if you have a sde you can use sql select distinct, etc. with cx_oracle Welcome to cx_Oracle’s documentation! — cx_Oracle 7.0.0-dev documentation Left join the list of all domains and the summarized (select distinct) and then select where null
... View more
08-23-2018
09:18 AM
|
1
|
1
|
2325
|
|
POST
|
We have a new 10.2 geodatabase in Oracle. When we went to reconcile and post we would get errors. We tracked the problem down to missing sde_logfiles and sde_logfile_data. We fixed the problem as outlined in this Esri article: https://support.esri.com/en/technical-article/000012549 The article has one select 100 or more features from a feature class to create the log tables. So, our question is: is there a way we can ensure the log files exist for users so we don't have to ask them to select 100 features before they reconcile and post? I guess we could script something... but I would think that Esri has a way to do this...
... View more
08-21-2018
06:05 PM
|
1
|
3
|
4661
|
|
POST
|
I have a task to add and remove a number of fields across a number of feature classes and tables. I would like the fields to be in a new order when done. They have relationships classes, domains, and possibly joins on them. Also they are versioned. In the past I have made new copy feature classes with python or XTools to do this and replaced (deleted) the original. I also noticed that there are some xml schema export/import workflow options for this. But I don't see anything that will let me do it in place. Is there a way to change the filed order with python (or otherwise) for existing feature classes and tables in an oracle gdb?
... View more
08-01-2018
10:55 AM
|
0
|
1
|
1200
|
|
POST
|
I was able to recreate the view with arcsde command line tools and register it. Still no clue on how it got twisted to start with... Thanks for the help Asrujit.
... View more
07-09-2018
09:12 AM
|
1
|
0
|
1212
|
|
POST
|
Looks like this is how to do it in the first place... Register a table or view with the geodatabase—ArcGIS Help | ArcGIS Desktop But it is not showing up. Arc 10.1
... View more
07-03-2018
05:33 PM
|
0
|
2
|
1212
|
|
POST
|
I have an oracle view that was setup to look like a point FC in ArcCatalog at some point. And now it is missing in the prod environment and in turn breaking stuff. However, at a database (ddl level) level they look the same. So, I am wondering... 1) How is this done in the first place? 2) What could have changed in prod to make it vanish? 3) How can I restore it and save the day?
... View more
07-03-2018
04:43 PM
|
0
|
3
|
1299
|
| 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
|