Latest Contributions by TomWeisenberger

‎06-20-2018

Having the same problem here. It just started out of nowhere. Dump file shows the same server OS Version, may be related to a Windows Update. I opened a support case with Esri, will post any resolution. Hao Hu did you get this resolved?

‎06-13-2018

I was going to suggest something like this. Want to be able to have a web map/app private within My Content on our organization's Portal, but still be able to share it without having the person it's being shared with a member of the Portal and then within a Group. (we have 100k+ employees...no way we'd be able to manage them all in the Portal) You may also not want to share an item with everyone that's a member of a Group. Another simpler option to a password would be a shareable link of a private web map/app in the Share options box.

‎03-13-2018

Hi Derek, Our 10.6 ArcGIS Enterprise has been recently setup on an Intranet server on our network. I assume in this scenario we are not going to be able to set up a distributed collaboration with our AGOL? We could possibly set up a Portal web adapter on a web server to get it connected to the internet. Would that be necessary for outside Collaboration? We'd prefer the Portal be purely inside our firewall if possible, so we'd have to weigh our options. Thanks! -Tom Weisenberger Los Angeles County eGIS

‎10-14-2014

In our case the locks are more than just map services, they are from users throughout the enterprise as well. I've tried adding arcpy.AcceptConnections(Connection, False) followed by arcpy.DisconnectUser(Connection, "ALL") to the script prior to removing the spatial index, loading data, and rebuilding the index but have not had any success. Ideally it would be best to have available a geoprocessing/arcpy tool that replicates exactly how load_only_io and normal_io command lines worked, which is flawless and efficient. For now we will continue to use the command line for as long as possible until we can find a viable alternative. Please let me know if there are any updates on this or tried and tested workarounds. Thanks! Tom Weisenberger Los Angeles County - Enterprise GIS

‎07-14-2014

Melissa, thanks for your response. I will investigate if this alternative will work for us. This is the main parcel feature class used by several map services and by users throughout the enterprise - so lots of connections to it. My main concern using this method is schema locks. Even though the parcel load script runs at night I would need to add code to remove all connections/locks first in order to run Remove Spatial Index. I'm concerned about failures if any locks remain. The command line would do it all regardless of any locks. (or does it remove connections/locks itself?) Tom Weisenberger Los Angeles County - Enterprise GIS

‎07-14-2014

We require an alternative to load_only_io mode if Esri is going this route of abandoning SDE command line and offering geoprocessing alternatives. Fortunately SDE command line is still installed from SDE 10 on our server and it still works with our newly upgraded 10.2 geodatabases. I have a weekly update script that loads 2.3 million parcels from a spatial view to a stand-alone repository feature class. When performing a simple truncate (TruncateTable) and load (Append), without setting the parcel feature class in load_only_io mode first - load time is over 7 hours! Indexes rebuilt by RebuildIndexes then AnalyzeDatasets as recommended. As we've traditionally done, by using SDE command line in python script subprocess, setting the feature class into load_only_io mode first, then back into normal_io mode - load time is less than an hour. This works great and rebuilds indexes at the same time. We've had no problems with this process for years and are worried that progressive upgrades are actually moving somethings backwards without appropriate consideration of customers requirements and established processes. Please provide either a separate "bulk-load" tool that efficiently loads data into SDE at the same rate or provide a geoprocessing tool that does the same SDE command line for load_only_io and normal_io so these can be accessed through arcpy. Tom Weisenberger Los Angeles County - Enterprise GIS

‎10-17-2013

Trying to find a simple solution in Python for what seems to be a GIS 101 operation: take a point and update its attributes, a new field, with information derived from its spatial relationship of a polygon boundary it falls within. Basically I'm working on a script that geocodes addresses and then gets information about them spatially from various political and administrative boundaries (about 8). I don't want a new/separate layer for each spatial join that would then need to be merged together I don't want all the fields back from the polygon boundary, usually just 1. I don't want to do a union of all my boundaries first into a big messy layer to do 1 spatial join and get all the results...then trim the fields down. Ideally a quick update in place like a UpdateCursor with spatial intersects function would be great! Like SQL Spatial does. (See below) Best solution I have right now is to load the points into SQL Spatial/SDE and then call a stored procedure that uses the STIntersects function using pyodbc. This works good as a work around. While the intersect operation itself is pretty fast I'd rather not have to import and export from SQL Spatial/SDE just to do it there. Would like to stay within the file geodatabase where all the other processing is done. Should be something similar and simple as all the SQL Spatial geometry functions in ArcGIS/Python. Haven't been able to find anything in update cursors or geometry functions that will do this very basic, yet powerful, GIS operation. Anybody know of anything? Example in SQL Spatial, quick field update where point intersects Congressional District...then intersect with the next boundary. Where is this in Python? UPDATE r SET r.CONGRESS_DIST = s.DISTRICT from eGIS.AddressPoints r, eGIS_Spatial.eGIS.CA_CONGRESSIONAL_DISTRICTS_2011 s where s.Shape.STIntersects(r.Shape) = 1 UPDATE r SET r.PD_STATION = s.LABEL from eGIS.AddressPoints r, eGIS_Spatial.eGIS.SHERIFF_REPORTING_DISTRICTS s where s.Shape.STIntersects(r.Shape) = 1 ...

Online Status	Offline
Date Last Visited	‎12-23-2020 12:15 PM

My Ideas

Latest Contributions by TomWeisenberger

Re: Error handling service request: Could not initialize service 'Utilities/PrintingTools.GPServer'

Re: Public sharing with password

Re: Copy content between Portal A and AGOL

Re: Alternatives to using SDE command line tools - Blog Discussion

Re: Alternatives to using SDE command line tools - Blog Discussion

Re: Alternatives to using SDE command line tools - Blog Discussion

How to do Simple Update of Point Attributes from Polygon where Intersects?

Re: Public sharing with password

Re: Alternatives to using SDE command line tools -...