Latest Contributions by BogiBjornsson

Greetings, Perhaps someone can shed some light on my question. I have two instances of Web Adaptor (v.10.3.1) setup on the same machine which are pointing to two different ArcGIS Server Sites. I wanted to know if you could upgrade only one instance to another version (e.g. 10.5.1 or 10.6) and leave the other instance at it's current version. Thanks in advance, Cheers! ... View more

Howdy! I have a bit of a problem with a python script tool that I am trying to get to work when I chain it to other tools in a model made in model builder. It's just a simple dummy tool I set up to try to sort things out, the model selects a polygon, based on user input via a point type feature set, and buffers this selected polygon (this is the script part) then I wanted to copy the result output (featureclass) to another location by chaining the script tool to the copy features tool but no matter what I try it gives me an error that an input value is required (see model diagram, script tool parameter settings and script tool code below). Script tool runs fine on it's own by the way and gives proper results. Model diagram: Mybuffers Script tool code: import arcpy import os from arcpy import env #Set environement variables scratch = env.scratchGDB env.overwriteOutput = True arcpy.SetLogHistory(False) #Important to reduce metadata writing #Get input parameters inpnt = arcpy.GetParameterAsText(0) mypolys = arcpy.GetParameterAsText(1) outfcname = os.path.join(scratch, "mybuffers") #Make feature layer from input point(s) inpntlyrname = "InputPoints" inpntlyr = arcpy.MakeFeatureLayer_management(inpnt, inpntlyrname) #Make feature layer from polygons polylyrname = "MyPolygons" polylyr = arcpy.MakeFeatureLayer_management(mypolys, polylyrname) #Select polygons that intersect input points selpolys = arcpy.SelectLayerByLocation_management(polylyr, "INTERSECT",                                                   inpntlyr, "25 Meters", "NEW_SELECTION") #Buffer selected polygons arcpy.Buffer_analysis(selpolys, outfcname, "5000 Meters") #Set output parameter outputfc = arcpy.SetParameterAsText(2, outfcname)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Mybuffers script tool parameters settings (for the output parameter): It's like the copy features tool is not getting the data from the script tool even though I've used countless different versions of the SetParameterAsText() and read as much as I can take of the official help. Perhaps there is some good hearted soul willing to look over my code to help me see where I'm going wrong because I'm stuck and getting really annoyed at this Cheers! UPDATE 23.10.2017: I've been relying on the official help in the link below, chapter heading "Derived output that does not modify an input parameter". I have now tested setting up exactly the same example with the post data to repository script tool and the copy features section of the model fails in the exact same way i.e. "input value required", the second tool in the chain does not run. Setting script tool parameters—Help | ArcGIS Desktop  ... View more

Greetings! I would like to pose a question about two snippets of Python code that basically take in a list of events, each of which contain a latitude, longitude and depth like so eventslist = [[ lat1, lng1, depth1], [lat2,lng2, depth2] ... [latN, lngN, depthN]] and input these as points into two separate Geodatabase Featureclasses. I have verified that both these code snippets work but I would like to ask, which snippet in your opinion is the more efficient/correct one in regards to where to start/end the edit operation (edit.startOperation()) and creation/deletion of the insert cursors. Also if you think another solution is even more preferable then please don't hesitate to suggest, thanks in advance! SNIPPET 1 #Start an edit session to insert new events. Need to have edit session because of using two insert cursors at the same time. edit = arcpy.da.Editor(env.workspace) edit.startEditing(False, False) #Iterate over the list of new events, each event contains lat, lng and depth     for event in newevents:          edit.startOperation()         cursor = arcpy.da.InsertCursor(inFc, ["SHAPE@", "lat", "lng", "depth"])         cursor2 = arcpy.da.InsertCursor(archiveFc, ["SHAPE@", "lat", "lng", "depth"])         lat,lng,Z = (event[0], event[1], event[2])         location = arcpy.Point(lng, lat, Z) #Create the 3-D point object         pointGeom = arcpy.PointGeometry(location) #Create the shape geometry as pointGeometry         row = [pointGeom, lat, lng, depth]         row2 = [pointGeom, lat, lng, depth]         cursor.insertRow(row) #Insert the new events into longterm class using insert cursor         cursor2.insertRow(row2) #Insert the new events into archive class using insert cursor2         del row, row2         del cursor, cursor2            edit.stopOperation() edit.stopEditing(True)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ SNIPPET 2 #Start an edit session to insert new events. Need to have edit session because of using two insert cursors at the same time. edit = arcpy.da.Editor(env.workspace) edit.startEditing(False, False) edit.startOperation() cursor = arcpy.da.InsertCursor(inFc, ["SHAPE@", "lat", "lng", "depth"]) cursor2 = arcpy.da.InsertCursor(archiveFc, ["SHAPE@", "lat", "lng", "depth"]) #Iterate over the list of new events, each event is a list that contains lat, lng and depth for event in newevents:       lat,lng,Z = (event[0], event[1], event[2])     location = arcpy.Point(lng, lat, Z) #Create the 3-D point object     pointGeom = arcpy.PointGeometry(location) #Create the shape geometry as pointGeometry     row = [pointGeom, lat, lng, depth]     row2 = [pointGeom, lat, lng, depth]     cursor.insertRow(row) #Insert the new events into longterm class using insert cursor     cursor2.insertRow(row2) #Insert the new events into archive class using insert cursor2     del row, row2 edit.stopOperation() del cursor, cursor2  edit.stopEditing(True)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

We have a dynamic map service based on an mxd map document containing a Query Layer from a spatially (PostGIS) enabled PostgreSQL table (uses geometry data type for shape column). The service works fine both in ArcGIS clients and JavaScript browser applications through REST, no problems. Our PostgreSQL DBA contacted me however and told me that the service was leaving open and idle queries in the database which he says is not acceptable. He sent me a report as an example, see below. POSTGRES_TXN_IDLE WARNING: DB "postgres" (host:******) longest idle in   txn: 56384s (15 hours 39 minutes 44 seconds) PID:32278   database:****** username:********* address:***.****.***   port:**** query:BEGIN My understanding is that this is normal behavior for ArcGIS server map service connections but I would like to verify if this is the correct understanding or not (we have AGS 10.3.1 and PostgreSQL 9.3.x). So is this normal behavior or not? The only viable solution that I can think of to meet the DBAs demand is to set the minimum number of service instances to zero so that idle services (and their connections to the DB) are closed after x minutes of inactivity. This however would result in a bit of a performance hit for the first user that comes along, and no instances are running, and he has to wait for at least one instance of the service to start up. UPDATE 20160321: Found a post by another user which seems to confirm this behavior on PostgreSQL connections. He had some interesting findings and our DBA seems to agree with him that this is not a good way to make connections to a database. Here is the post, check it out. arcgis server connection pooling ... View more