POST
|
Why in the world did they do that? Thanks for the alert on this. No telling how many users have unknowingly corrupted their edits.
... View more
12-24-2019
03:28 PM
|
6
|
0
|
391
|
POST
|
Several of our SQL 2012 geodatabases are still at 10.4.1. ArcGIS Pro crashes when attempting to view locks when the NULL column value is encountered! Pro crashing is beyond disappointing for a new product! ESRI wants customers to migrate to Pro but in my experience it crashes just as much as ArcMap.
... View more
11-22-2019
11:35 AM
|
1
|
1
|
233
|
POST
|
When you say geodatabase do you mean enterprise like SQL Server or file geodatabase? If SQL Server, you could have a single table with year, site and density with a view that makes it look like you have it above.
... View more
11-13-2019
03:09 PM
|
0
|
1
|
24
|
POST
|
Timm, I have the same issue. How did you do it or did you learn?
... View more
10-17-2019
02:08 PM
|
0
|
0
|
23
|
IDEA
|
We have a staging database where feature classes are staged using the same name as the one in the master database. Our existing tools have inputs for the target fc and the source fc then doing a truncate-append. If the user has update rights to both locations this could be disastrous if they get mixed up! Once both are set I always double check to see that I didn't get the target and source backwards.
... View more
09-11-2019
02:46 PM
|
6
|
0
|
141
|
POST
|
Shapefiles are a type of Feature Class. We have a few users who mistakenly call all GIS feature classes (shapefiles, SDE, personal gdb, file gdb) shapefiles. I've learned to ask them what them mean by shapefile so I get them what they really need. Same goes for layer, some users call everything including shapefiles layers.
... View more
09-11-2019
02:14 PM
|
1
|
0
|
1678
|
POST
|
As I understand it, Python 2.7 is not going to stop working and does not have to be uninstalled. However, there will be no bugfixes going forward.
... View more
09-11-2019
01:54 PM
|
0
|
0
|
42
|
POST
|
Joshua, that fixed the issue. I'll report this behavior to ESRI since it seems like a bug.
... View more
09-06-2019
01:27 PM
|
0
|
1
|
76
|
POST
|
Hi Josh, You are correct, I didn't mention Pro vs ArcMap because we run these scripts in a CMD window. Also, we upgraded all of our ArcGIS Pros to 2.4.1 so I haven't been able to test it with an early version of Pro. I changed the script to run with python 2.7 to verify that it, at least, worked correctly in ArcMap python. The only change needed was changing line 14 from memory to in_memory. Having said that, CopyRows shouldn't be changing field definitions in the first place.
... View more
09-06-2019
12:16 PM
|
0
|
3
|
76
|
POST
|
One of my users has a script that works in 2.7 and was working with 3.x but now breaks after the ArcGIS Pro 2.4.1 update. When copying an SDE table into memory using the arcpy.CopyRows_management all text field sizes are increasing from what there are to 5000. For example, text fields of size 1 and 100 become 5000. Our tables are a SQL 2012 / SDE 10.4.1 geodatabase. To see if I could replicate this issue I even created an empty table from scratch containing only two fields, the first is DataSource defined text length 100 and the other is Flag defined as text length 1. Is anyone else seeing this? The user says it was working in version 3 before we pushed out Pro 2.4.1. c:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3>python.exe h:\treg\test_inmemory2.py SDE table is : H:\Treg\(Prod) MyDatabase @Reader.sde\ MyDatabase .DBO.WS_Test OBJECTID is a type OID with a length of 4 DataSource is a type String with a length of 100 Flag is a type String with a length of 1 Copying table H:\Treg\(Prod) MyDatabase@Reader.sde\ MyDatabase .DBO.WS_Test into memory... temp table is : memory\tmpTable OBJECTID is a type OID with a length of 4 DataSource is a type String with a length of 5000 Flag is a type String with a length of 5000 try : ##Import modules import os , sys import os . path as path import traceback import arcpy from arcpy import env arcpy . env . overwriteOutput = True sdeTable = r "H:\Treg\(Prod) MyDatabase@Reader.sde\MyDatabase.DBO.WS_Test" tmpTable = r "memory\tmpTable" print ( 'SDE table is : {}\n' . format ( sdeTable ) ) ##check field lengths in SDE text fields fields = arcpy . ListFields ( sdeTable ) for field in fields : print ( '{0} is a type {1} with a length of {2}' . format ( field . name , field . type , field . length ) ) print ( '\nCopying table {} into memory...' . format ( sdeTable ) ) arcpy . CopyRows_management ( sdeTable , tmpTable ) print ( '\ntemp table is : {}\n' . format ( tmpTable ) ) ##check field length on in memory text fields fields = arcpy . ListFields ( tmpTable ) for field in fields : print ( '{0} is a type {1} with a length of {2}' . format ( field . name , field . type , field . length ) ) except : print ( '\n*** ERROR IN SCRIPT!' ) print ( '\n***PYTHON ERROR INFO: \n' + str ( traceback . format_exc ( ) ) )
... View more
09-06-2019
11:43 AM
|
0
|
9
|
256
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|