Latest Contributions by JamesFox1

I had a question perhaps someone can shed some light on. We have an SDE database (SQL Server 2016) with a multiple spatial references (all listed in the SDE metadata table), each of the same projection but differing extent parameters. When our users edit this dataset, they get a data frame error message when using ArcDesktop (ArcMap) 10.8.1, however when performing the same edit in ArcPro 2.8, no such error message is present.  I have moved this data around, imported, exported, restored,..etc and upgraded the data SDE to 10.8.1, but the multiple references all re-generate and as such, no effect in ArcDesktop in clearing up that error message. So the signs point to a toolage based fix, but I checked my technical support rep and they can't track down any specific product based fixed so  I thought maybe someone here in the technical ether may have run across this perhaps. My user things this is data issue but again the signs appear to point at some kind of product fix and would like to track that down.    Thanks much, -James Fox - GIS Database Consultant ... View more

I have a GIS Information Architecture question that has a few of us runing in circles in our shop of late. How does one apply a projection transformation within an MXD? I have data from an SDE database in NAD83 but need it transformed into WGS84 Web Mercator in the MXD so it can be published as Web Mercator to web services to avoid the "projection o n the fly" performance penalty when said web services are consumed over the internet. I have been approached with maintaining redundant copies of the data in SDE, in each projection synched with database triggers but my team feels that this is an inefficient solution that may be quite brittle. The examples I have found apply the transformation in a layer in an MXD but have found no layer "XY Coordinates" layer projection property to apply the tranformation on. Only source which will transform the base SDE data, which is not what we want to do! Our data is edited in NAD83 via Desktop but needs to be consumed over the web in Web Mercator (ideally in an efficient manner)  If I save off the layer into a .lry file, there is a projection transformation function but again it will override the source data and not transform it in the layer only. Would this transformation be better done at the publish web service level? I see lots of discussion on web service caching but not on these types of transformation doing in the web service itself (Hopefully I am missing something here?)  I am sure this has been resolved elsewhere in large GIS shops, any thoughts? Thanks, -Jim ... View more

I had python script tool that accessed a sequence value and got the value via arcpy.ArcSDESQLExecute call. We are porting our SDE environment from Oracle 11g to SQL Server 2012 and as such changed the sequence select from ALL_SEQUENCES to sys.sequences as shown:         select_list = 'SELECT DISTINCT current_value ' #  SELECT LAST_NUMBER '         from_clause = 'FROM sys.sequences ' # ' FROM ALL_SEQUENCES '         where_clause = 'WHERE NAME = \''+seq_name+'\' ' # 'WHERE SEQUENCE_OWNER = \'' + schema + '\' AND SEQUENCE_NAME This SQL works in SSMS or SQL_CMD but not in arcpy (it did work correctly in Oracle 11g) is there now an arcpy call that will get a sequence value (CURRVAL) directly without building SQL and using ArcSDESQLExecute? -Jim ... View more

When setting up a hatching class for a linear referenced route layer, is it possible to define a End hatch definition for only "one" of the two endpoints? We need a way to set up an endpoint hatching that labels the first endpoint as blank and the second endpoint as the lenghth of the route. Thanks, -Jim James Fox Geodatabase Administrator - BIA Div. of Water and Power Lakewood, CO ... View more

When creating a geodatabase by connecting to a MS SQL Server database, does a native client need to exist on the client machine if SSMS and/or SQL Server itself does not reside there? James Fox DBA - BIA Division of Water and Power Golden, CO wendell.fox@bia.gov ... View more

My organization is looking to bring an ESRI developer on-board in the next few months to build us a re-vamped event driven desktop based spatial viewer for our geodatabases. We are probably looking an MXD hosted on an ArcGIS server with our GIS styles and viewer application functionality.   I know ESRI has been hyping the javascript API in the last year, we are probably looking at a Microsoft Visual Studio based solution (VS 2010 for a ArcServer 10.1 and SDE) Our previous developer built our previous viewer in VB.NET but we are curious if there is a preference to using VB vs. C# from an ESRI perspective for building the viewer app. VB may be simpler to work with but C# may have more functionality and libraries at it's doisposal. My first guess would be both are equally fine but we may need to narrow this down for getting the best skillset for finding our developer as well as being able to build the most otimal ArcGIS server based viewer. -Jim ... View more

I need to be able to get an Oracle Database Sequence value (either CURRVAL or NEXTVAL) using an arcpy sql query. I used a generic sql execute function as opposed to the SelectCursor function but cannot seem to be able to get the sequence value returned fromthe sql call into the python script. The examples I have seen can execute the call but the value I get returned is a float, I am guessing a representation of a boolean which represents whether the sql successfully executed or not. The code we have is something like this:    sql = "SELECT ID_SEQ.CURRVAL FROM DUAL"    connSQl = arcpy.ArcSDESQLExecute("\Database Connections\Geodatabase.sde")    sqlresults = connSQL.execute(sql)    ## sqlResults is non-iterable so I cannot for loop through a list [as rows to qualify]    The sequence value is a positive integer yet I get some value 2e-10 back 1. Can anyone show me what I am doing wrong here or if there is another function I should be using to talk to a a non-table database object like a sequence. There must be since SDE uses so many of them for IDs. 2. If not, the same question for a PL/SQL stored procedure call, getting a return value out.  Our sequences have PL/SQL function accessors so if there is way to get these values this way that would be fine. We would prefer to use arcpy and avoid the other oracle based sql call modules simply to keep our connection credentials encapsulated in our sde objects. If you know of some examples out there, throw me bone since my searches come up[ with only table examples. ("table scraps" if you will...) Thanks much, -James Fox ... View more

This is a new issue but spawned from the same environment of the "Issues creating a geodatabase with ArcGIS Desktop v10.1 / SDE v10.0 on SQL Svr 2008R2" thread I posted  earlier.  (http://forums.arcgis.com/threads/91662-Issues-creating-a-geodatabase-with-ArcGIS-Desktop-v10.1-SDE-v10.0-on-SQL-Svr-2008R2) I can connect to this database via reseting the default schema mapped to the connected user. And I create/import a feature class. However that is it. I cannot create or import a feature dataset into this database. Right click on "New" and only feature class or table appear. No feature datasets, no ratsers nor any toolboxes. And I cannot find information on this either. It appears however that the geodatabase is "enabled" but functionality is not present. All the system tools seem to be present, however no feature dataset tools are present and "quick import/export" under the Data Management Toolbox is disabled. Is SDE really just "minimally" functional until the Post Install is run then? Funny, I don't see the SDE user or schema either. But one would think I should NOT BE ABLE TO CONNECT AT ALL TO SQL SERVER if SDE is not really enabled or functioning, right?  -Jim ... View more