POST
|
We have an old js application (https://maps.tucsonaz.gov/zoombiz/ ) built from an ESRI template (can't remember which one, it's pretty old) The locator we wired up got retired, and we need to put in a new one. Simple, mostly. However there are some additional parameters in the Config.js code that I can't quite crack. Here's the locator we are now wanting to use: Geocoders/COMPOSITE_LOCATOR_WEB (GeocodeServer) And here's what we need for the app, in addition to the service URL: LocatorParameters: ["SingleKey"], // Set Locator fields (fields to be used for searching). CandidateFields: "Score, Match_addr, Addr_type", //Set which fields are returned in results DisplayField: "${Match_addr}", //Set which field from results is displayed LocatorFieldName: 'Addr_type',//The returned field which specifies match type (specific locator within composite) LocatorFieldValues: ["Address", "Addr", "Address_1", "Customer_Address"] //List of acceptable individual locators (within composite) My hunch is that it's the last item - LocatorFieldValues - that's not working with the new locator service, as well as possibly the LocatorParameters (is 'SingleLine' a viable entry there?) Any tips on the configuration, or where to look in the service properties to find this? Thanks - Allen
... View more
05-15-2018
02:19 PM
|
0
|
4
|
640
|
POST
|
We have a fairly straight-forward GeoEvent service that recently stopped working. Essentially the service takes an input table that has geometry stored as a string, and writes to a polygon feature class (using a field calculator on the geometry string field). These polygons are then used as geofences in a separate GeoEvent service. However something has caused this to stop working - I cannot get the service to write to the feature class any more. No configuration changes were made, nor schema changes to any table/FC involved. I've tried different versions of the output feature service (new services w/ new, empty feature class) - multiple restarts of the service and full server reboots (it's dev environment) - no change. - We are running Enterprise 10.5, and I have installed the patch for GEP (GeoEvent-10.5-Patch1) to not avail. - The service WILL write to json output successfully, so it must be related to the output (Update a Feature). - The Monitor shows that the correct # of records are sent to the output, but nothing gets written to the feature service. - There are 2 errors I see in the logs: 1) Error Code 400 - Error while writing to feature service xxxx. Error: Unable to complete operation > Operation rolled back... 2) com.esri.ges.fabric.internal.ZKPersistenceUtility > KeeperErrorCode = ConnectionLoss for /geoevent/config/clusters/default/arcgisServerConnections....(much more here that I can't intelligently decipher). I've checked to Default connection in the data store, and all appears ok there. I'm stumped after 2 days of trying to track this down. Likely will open a ticket, but figured I'd ask wiser more experienced heads than myself first.
... View more
04-30-2018
02:57 PM
|
0
|
3
|
1027
|
POST
|
Question very similar to this one: https://community.esri.com/message/599770?commentID=599770#comment-599770?q=Update%20Hosted%20Datastore%20features%20wit… But for a feature layer hosted in Enterprise/Portal datastore. I have set up the connection to our Portal site in the data store section of GeoEvent. I go to create an output (Update a Feature) and the connection works - I can see my content there, and select the hosted feature service (it has just one layer) in the 'Service Name' box with no issues: <MyHostedLayer> (FeatureServer) What I can't do is select the Layer in the next box - The drop down is empty, so I can't create the Update a Feature output. So - is this possible? Is there a different Output I need to use when updating hosted data (we are using regular PG Datastore for our hosted stuff in Portal). And does it matter that for now our GeoEvent instance is NOT part of our Enterprise instance that contains our Portal site? Thanks - Allen https://community.esri.com/message/599770?commentID=599770#comment-599770?q=Update%20Hosted%20Datastore%20features%20with%20GeoEvent
... View more
04-18-2018
03:07 PM
|
0
|
0
|
602
|
POST
|
Thanks Jonathan - This particular server is not federated, but we actually do have a server federated with this Portal - which I did not use here because of the editor tracking + web tier issue (thinking web tier security works better w/ editor tracking). In hindsight though, I would guess that if we publish this layer on the federated server it should behave as desired, correct?
... View more
04-02-2018
03:38 PM
|
0
|
1
|
714
|
POST
|
We have an editing web app under construction that will allow Fire Dept. staff to quickly enter hydrant inspection results on a mobile device (VPN connection to our network since we're using Portal). We have the actual feature service that will be edited published on a web-tier secured server and added to Portal as a feature layer ( I have found web tier is a better for editor tracking credentials to flow through - but if someone has tips on other options, I'm all ears). The issue is that the web tier secured layer asks for credentials a second time (in addition to the users logging in to Portal which is expected and fine w/ users). I seem to recall one can change a setting in IIS that impacts this behavior - possibly disabling anonymous authentication? The net goal here is to have the web tier server read the Portal credentials the user signs in with to avoid 2 sign ins (both the Portal site and web tier server use AD). I know for single sign-on we have modified settings in browsers on individual machines, but this would be prohibitive in this case Thanks - Allen
... View more
04-02-2018
12:21 PM
|
0
|
3
|
821
|
POST
|
Here's a fun one. We are building an application that uses Geoevent to poll a map service for features (permits in this case), geotag the permits with a geofence, and write the output to a new feature class. The problem we are having relates to the 'Get Incremental Updates' property and the way our permit data gets updated. I really want to set the GEV Service to poll every 5-30 minutes (doesn't need to be 'real time') and only bring over new OR modified records. My understanding is that this is what 'get incremental updates' does (at least for new features). The problem we have is that nothing gets picked up at all when we set 'Get Incremental Updates' to 'yes'. My concern is that because our permit data gets truncated/appended every night, the objectids get shuffled as part of that process, thereby rendering the Get Incremental Updates option powerless to do what it's designed to do. Just wondering if that's the correct interpretation of this functionality. Thanks - Allen
... View more
03-23-2018
12:23 PM
|
1
|
0
|
526
|
POST
|
Thanks Vince - I've always been a little murky on the details of working with spatial views. We are running an old SDE version (10.1), with desktop 10.3.1 in this case (yes, I know, and we are in the process of upgrading databases to allow us to work with current versions of ESRI software). The upside of this is that we can still use the command line to create views (using 'sdetable'), and views created in this way behave essentially as feature classes in the Arc Desktop environment. Add it in ArcMap, and the geometry/objectid questions do not come up - it has the geometry of whatever SHAPE field you include in the query to create the view. I had forgotten we had this ability (command-line view creation) - and a new spatial view created with this method works as expected in a python script (arcpy append with the view as the 'source' data).
... View more
03-15-2018
12:59 PM
|
0
|
1
|
859
|
POST
|
So the view in question was created in our SDE database using arcpy.CreateDatabaseView_Management. The work needed is simply writing certain records from the view in the SDE database into an FC or table within that same SDE database after a bunch of python code is executed. The view appear to be registered with the database, giving that the option to do so is grayed-out in the catalog view in Arc desktop. However, when trying to add the view in ArcMap, it is asking for a Geometry type, and to identify what field to use as unique identifier (even though there is an OBJECTID column in the view). This leads me to believe the spatial view was not created correctly.
... View more
03-15-2018
10:04 AM
|
0
|
3
|
859
|
POST
|
Having a difficult time with what should be a simple task - In a python script, i'm trying to write records from a view in an SDE database (sqlserver) to either a table or feature class (whichever works - the idea is to write a set of records to an table/FC that serves as an archive, with a date marking the date of the run time for the script) I've tried CopyRows, Append, ArcSDESQLExecute - all fail, for a variety of reasons - geometry type not supported (Append) or an error relating to being unable to insert NULL values into OBJECTID column - fair enough but my understanding is that because the target table is registered with the database, and would automatically generate an OBJECTID (this is for ArcSDESQLExecute method with an 'Insert' SQL statement). My hunch is something is not right with the view (the 'source' data) - but am looking for suggestions/experiences around working with views in Arcpy tools in a python (not desktop ArcGIS) environment. Thanks - Allen
... View more
03-14-2018
12:37 PM
|
0
|
6
|
1069
|
POST
|
James this is perfect - Works like a charm almost 'out of the box'. Many thanks
... View more
02-28-2018
02:48 PM
|
0
|
0
|
2023
|
POST
|
Hopefully a simple (and fun!) Python loop question. We have a dataset that looks like this: ROWID ATTRB1 ATTRB2 ATTRB3 ATTRB4 1 AAA BBB CCC ABCD, EFGH,IKL Where ATTRB4 often contains a comma-separated list of values. Unfortunately we need these values as a join field in a SQL view, so the comma-separated list format output we receive needs to be changed so that there is only 1 value in the ATTRB4 column So, what I'm working on is creating a non-normalized version of this table (actually a feature class) that will have 3 duplicate rows (duplicate rows not a problem in this case) , with identical values for ATT1-3 but with the ATT4 value being a single one of the comma-separated list values: ROWID ATTRB1 ATTRB2 ATTRB3 ATTRB4 1 AAA BBB CCC ABCD 2 AAA BBB CCC EFGH 3 AAA BBB CCC IJKL I believe I need to get the comma-separated ATTRB4 column into a list, and loop through it, but am not quite sure how to wrap my head around the code here. Thanks Allen PS the comma-separated list values are the result of GeoEvent service (v 10.5.1) that uses a GeoFence and GeoTagger to identify points in certain areas and add the GeoFence name to the output - so when a point is within multiple areas, the multi-value list is result. If anyone happens to know a way to force GeoEvent to output in the format shown in the 2nd table, that would work too.
... View more
02-28-2018
01:27 PM
|
0
|
2
|
7743
|
POST
|
Thanks Josh - The snippet from the tool result is in fact the original source for my code here. It's been my experience that the snippet rarely works as-is with no modifications in an IDE (especially relating to datasources), and that was the case here, so I've tried many permutations of the paths. I currently have it so that the Append_management does read the input data: (inputs=r"\\ServerName\DATABASECONNECTIONS\SQLCONNECTION.sde\UserName.dbo.tablename", target=...) where the DATABASECONNECTIONS folder contains the appropriate .sde connection file for the database in question. And it actually adds the correct # of records to the target. however every attribute minus objectid is null, which is fun. I can figure that out - was mainly trying to see how to reference a non-spatial SQL table within this tool, and confirm that it's possible in an arcpy tool within a python script.
... View more
02-22-2018
08:38 AM
|
0
|
0
|
558
|
POST
|
I'm wondering if anyone can help with the syntax (or confirm that it can be done) to reference an SQL table that's in a non-spatial database in a python script In my case I'm trying to append from this table into an SDE table. I need the field mapping, because there is an ID field in the source table (non-spatial) that needs to be preserved and by default it treats it as an object id field, so it changes every time the job is run, which is a problem. So it is mapped to the correct column in the target (SDE) table. The connection to the SQL non-spatial database is fine in ArcMap, and I can run the append tool without issue. Whne I grab the python snippet, no matter how I modify the table name/path, the Append_management section fails, saying 'Cannot open table...' (the input table). Here's what I have: (only import currently is arcpy) arcpy.Append_management (inputs="SQLDB.TABLENAME.dbo.users", *this is what the table is listed as under 'properties' in the catalog window in ArcMap target= SDE_DEV + "\TABLENAME_DEV", schema_type="NO_TEST", field_mapping=....) SDE_DEV is a variable that is the path to the SDE connection file + sde file name to our dev sde database. I've tried the same methodology for the input dataset, with no luck so far. Gracias - Allen
... View more
02-21-2018
12:52 PM
|
0
|
2
|
865
|
POST
|
1st day with Enterprise (Portal) 10.6, and the new Ops Dashboard is really nice. One issue that I had hoped would be resolved is apparently still happening for us. Basically we have a whole bunch of level 1 users, who have no need, desire, or skills, to do anything in Portal. So, the idea is that they just have the URL to the dashboard, sign in (we use active directory) and boom, they have their dashboard with essentially no learning curve, or new interfaces to navigate. However, when a level 1 user goes to the Dahsboard URL, sign-in fails, and they are taken to our Portal homepage. I'm really hopeful this is something that can be addresses through a security setting in Portaladmin, or on the server (IIS). This is a deal-breaker for our particular user-base. A little history - using the old version Ops Dashboard, with Portal/Enterprise 10.5, this functionality was fine. When we upgraded to Enterprise 10.5.1, we noticed that the direct URL to the Dashboard failed to load, just spun indefinitely. This was a bug that was logged, with the workaround being that if you made the users Level 2, AND made them an administrator, it would open for them. We balked at implementing this, and waited for 10.6, but after re-building the dashboard in the new environment this morning, the behavior is still happening. They can get to the dashboard by logging into Portal, finding the group this is shared with, and opening it there. So it is accessible to them permissions-wise. Also, a direct link to the WebMap being used by the dashboard works as desired (go to webmap URL, sign in, and you're good).
... View more
02-05-2018
12:23 PM
|
0
|
6
|
1282
|
POST
|
Thanks Jonathan - That did the trick. We have applied new certificates to our ArcServer machines, and did not get them loaded into this Portal instance.
... View more
01-26-2018
02:57 PM
|
0
|
0
|
1529
|
Title | Kudos | Posted |
---|---|---|
1 | 01-07-2016 02:59 PM | |
1 | 09-04-2015 03:52 PM | |
1 | 08-31-2015 02:24 PM | |
1 | 08-13-2019 04:21 PM | |
1 | 09-12-2019 01:30 PM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:25 AM
|