Latest Contributions by RandyKreuziger

This would be easy for ESRI to write.  Back in the AML days there was a Pull Fields tool that created a new table / feature class of just the fields the user wanted to keep.  To the good old days :) ... View more

It's an opportunity but I'd rather give input to affect this year's User Conference, otherwise you potentially have to wait a year if it's something you'd like to see address at the UC. For example, I'd love to see an advanced metadata workshop.  There are elements of metadata that are not exported when running the ArcGIS2FGDC.  Not sure hope popular it would be but I'd like to learn how to customize the metadata stylesheets. It's too bad attendees can't propose workshops for the UC that are then voted on in time for the upcoming UC.  In 2013 I remember getting a preconference survey but when I attended in 2014 I didn't receive any.  Our local ESRI support person said survey's were sent out for the 2014 UC but I never received one. ... View more

Sandra, did you ever hear back on your question?  In our agency it's require that all database manipulation be done through TSQL scripts with strict separation of duties.  Because of this our enterprise geodatabases are kept on another SQL Server instance.  I've explained that industry "best practices" can't always be applied or strictly applied geodatabases.  The first, that you cannot create a SDE geodatabase from scratch using only TSQL.  The response from above was, "ESRI doesn't know what they are doing and we should find another GIS system to replace it."  Really, and I hear it at least once a month. As the SDE administrator I do let a few users own their own SDE database on theseparate SQL Server instance I manage.  It's only for SDE/SQL databases.  Another thing that the rest of the IT Data shop doesn't understand is that ArcGIS is the "Application." The GIS analyst is not developing software, therefore they don't need the traditional separated dev, test, and production databases. Maybe the user needs to do a one time analysis and needs the power and scalability of SQL Server.  The analyst isn't necessary going to know ahead of time the schemas for the final tables let alone all the intermediate tables.  Therefore, the requirement that create all the empty table schemas in advance doesn't work.  That doesn't mean that SDE/SQL databases can't be allowed in the enterprise. I'd also like to hear from others on this too. ... View more

Derek,   My agency has an ELA but we still had to pay for the full cost of named users. ... View more

What about using an Active Directory group to restrict the map services containing sensitive data.  Add all 300 to a group then use that group in ArcGIS Server Manager for security.  We have some sensitive data that resides in SDE so we did a map service and restricted it to a AD group.  I think the users are prompted so they do have to re-enter their credentials but there is no need for portal named users. ... View more

Kim, we recently upgraded to 10.2.2 so we're still able to create SDE views.  You mentioned two years ago that the problem of metadata for views was something that ESRI planned to address before the admin commands were retired.  Has it been addressed at 10.3, or if not, at 10.4? Thanks ... View more

ESRI really needs to create a mechanism to change the ownership of enterprise domains.  That request was submitted as an enhancement several years ago but there has been no movement on it!  If the owner of a domain leaves and their network login is deleted there is no way to delete or modify their domains without hacking around in the GDB tables.  Not safe, but the only option available. ... View more

I'm assuming the only data coming from the county is data they manage in the first place so that your copies in SDE aren't versioned is that correct? I've sent up 3 scheduled python jobs to handle cases like this. Script 1 download and unzips the file geodatabase. Script 2 copies up to a staging SDE database all the feature classes that need to be loaded.  You could do your clipping as part of this script. Script 3 compares the schemas of the staged feature classes to the existing feature classes in our corporate SDE database.  If the schemas match I do the truncate append, if they don't match I send out an email alert and move on to the next feature class. You could easily combine scripts 1 and 2 to keep things simple. ... View more

Our Corporate Library SDE database has no versioned feature classes so we do the Truncate / Append all the time.  Many of the datasets are coming from other state agencies so it's just easier to do it this way. ... View more

Could there be a SDE table remaining in the map?  Change your Table of Contents to List By Source. And if that doesn't work check out the data sources in the MXD through ArcCatalog's "Set Data Sources" thing. ... View more

We got around this with our own data by putting all the feature classes into a single MXD / Map Service.  That way it's a single map service with the labels rendered on ArcGIS Server. ... View more

I couldn't stop and restart the SQL instance with all that's happening on that server but I did go in using SQL Server Management Studio | Activity Monitor where I discovered a blocking process.  I killed the blocking spid in SQL and that allowed the hung ArcCatalog Delete to finish. ... View more