topic Re: esri geoenrichment token failed in SAS Visual Analytics

esri geoenrichment token failed

Hans_vanderBent — Fri, 01 Jun 2018 12:55:46 GMT

I am new to SAS Viya, and as a gis expert off course one of the first things I try is to add geographical data to a dempo server.

I have set the click box for use of the Esri plugin, and as soon as I click on import geo enrichment, I get a message that the token cannot be found. What could be wrong? Google had no answers for me So my hope lies here....

Re: esri geoenrichment token failed

Hans_vanderBent — Fri, 22 Jun 2018 07:28:04 GMT

Fixed, added my Esri account datails, hoped to see a lot of Esri possibillities in SAS, but I cannot get the Dutch open data working. So a small step in all.

Re: esri geoenrichment token failed

FalkoSchulz — Fri, 22 Jun 2018 07:47:25 GMT

Hi Hans,

After entering the ArcGIS Online credentials - you have access to Esri premiums services. These include access to demographic data and geographic selection (e.g. drive-time analysis). There are some details in the related documentation - assuming you are using SAS VA 8.2?

I'm not exactly sure what issues you have in regards to the Dutch open data. SAS supports import of various data formats including CSV, XLS or Esri shape files. If you have access to polygon data in Esri shape file format - there is a related doc explaining how to import these into SAS.

Hope this helps. Regards, Falko

Re: esri geoenrichment token failed

FalkoSchulz — Fri, 22 Jun 2018 07:51:51 GMT

Forgot to mention - you may also find a recent blog I published useful https://blogs.sas.com/content/sascom/2018/01/30/building-visualizing-custom-polygons-sas-visual-analytics - as it described some of these aspects. Given you know about GIS - you may find this useful. Regards, Falko

Re: esri geoenrichment token failed

Hans_vanderBent — Fri, 22 Jun 2018 09:12:05 GMT

Thanks for the reply, this is what I learned from our local Sas connection too.

What I am looking for is to be able to use the open data, and background images on the Dutch Esri site see screenshot.

The Dutch site has a lot of data avaliable for free were the geo-enrichment possibillity of esri.com charges a fee.... also the data on esri.com is less well defined.

Re: esri geoenrichment token failed

FalkoSchulz — Sat, 23 Jun 2018 10:20:44 GMT

I see. So can I assume you have entered the full services url http://services.arcgisonline.nl/arcgis/rest/services in the Environment Manager as per http://go.documentation.sas.com/?cdcId=calcdc&cdcVersion=3.3&docsetId=calconfig&docsetTarget=n08000sasconfiguration0admin.htm&locale=en#n08043sasconfiguration0admin (localEsriServicesUrl property for maps service)? Also, have added the related url to the whitelist using the allowedDomains property as per http://go.documentation.sas.com/?cdcId=calcdc&cdcVersion=3.3&docsetId=calconfig&docsetTarget=n08000sasconfiguration0admin.htm&locale=en#n08303sasconfiguration0admin . After a refresh of VA - services should get loaded and be available for background map selection.

Note, that premium services are linked to ArcGIS Online and can’t be used with custom esri servers.

cheers, Falko

Re: esri geoenrichment token failed

Hans_vanderBent — Mon, 25 Jun 2018 07:34:31 GMT

Thanks for the reply, followed up on your advice, but still no maps to be seen. Ill ask my esri contacts if there is something preventing their services to be seen by other applications.

this is all I see (note the Arrow indicating multiple layers is invisible at the Dutch service)

I used this link in aswell the maps service as the cross domain proxy

http://services.arcgisonline.nl/arcgis/rest/services

Re: esri geoenrichment token failed

FalkoSchulz — Mon, 25 Jun 2018 10:30:26 GMT

I just had a quick try using the url in my environment and it seems services get populated as expected:

Chances are that the white-list configuration or some other network issue preventing access to this service. I used a value "https?://.*\.arcgisonline\.nl(:\d+)?/" for allowedDomains for the crossdomainproxy service.

You could also try opening the chrome debugger (F12) and open the network-tab. Refresh VA while the debugger is open. Once restarted - type in a filter value "arcgisonline" and it should show related service requests only. You may spot the one for arcgisonline.nl and the detail page may give more information why such failed.

Hope this helps. Cheers, Falko

Re: esri geoenrichment token failed

Hans_vanderBent — Mon, 25 Jun 2018 13:22:12 GMT

Thanks a lot!!

We are getting close now, the only issue I still see is that the Dutch Esri service uses dutch projection (RD New) and we have to get Viya to use that system instead of the WGS84 the EPSGcode of RD new is EPSG:28992 is it possible to enter that somewhere to get the wanted information in the right place?

Re: esri geoenrichment token failed

Hans_vanderBent — Tue, 26 Jun 2018 08:32:53 GMT

We still seem to have issues using the dutch coördinates, we can see the dutch basemaps now, and our data has the right x/y data but somehow Viya refuses to plot our data on the right spot. We loaded our csv file giving the data the EPSG:28992 custom entry for the coördinate system, but I believe SAS does not recognise the esri service being in the same system (Ersi.nl that is) Does vIya look at the metadata of the GIS server, and see its system settings?

Re: esri geoenrichment token failed

FalkoSchulz — Thu, 28 Jun 2018 03:45:37 GMT

Let me check with our mapping experts here whether there are any limitations/restrictions in terms of supported projections.

Re: esri geoenrichment token failed

Hans_vanderBent — Thu, 28 Jun 2018 07:02:52 GMT

That would be great, thanks for the help thus far.

To make the current situation clear:

We can get the Esri NL server to show data;

We can get our data to show using lat/lon, but as soon as we use our data giving the dutch system ESPG:28992 it shows not over the dutch esri service.

So My best guess is that the Esri NL server is not recognised as using the Dutch coördinate system

Re: esri geoenrichment token failed

JeffP — Thu, 28 Jun 2018 11:34:36 GMT

There is an appropriate place in the panel for creating a geography variable where you can enter custom coordinate spaces for your custom coordinates. From the drop-down under "Coordinate space" at the bottom of the panel, choose "Custom" and then a text box will appear where you can enter your custom value. "EPSG:28992" will work in your case.

VA supports as many data coordinate systems as it does display coordinate systems. Not every data system is compatible with every display system, but that is not the case here since both your data and view are 28992. Here is what the panel should look like:

If this does not work for you, perhaps you can share your coordinates and I can investigate further.

Re: esri geoenrichment token failed

Hans_vanderBent — Fri, 29 Jun 2018 09:28:42 GMT

Good morning, is there a way I can send you some of our data.

We get the same results, the panel works, but we cant get our data to show on the map.

I can give you a small batch, say 10 records and the adress for the dutch esri server is mentioned above, when we use falco's way to enter that adress in the cross domain proxy it works.

Giving our data the custom projection shows 100% match, but we cant see the data on the Dutch map. When I open the same data in ArcGIS it is spot on.

Re: esri geoenrichment token failed

JeffP — Fri, 29 Jun 2018 11:24:10 GMT

You can attach an Excel spreadsheet or a sas data set or you can email it to me at jeff.phillips@sas.com. Does it matter which map service is chosen from the ones available at the site listed?

Re: esri geoenrichment token failed

Hans_vanderBent — Fri, 29 Jun 2018 11:26:31 GMT

I added the data in txt format to the post above, you can import that to sas. The Dutch Esri server has some similar maps as the esri.com (canvas grey) but all maps should work as they all use the ESPG:28992

Re: esri geoenrichment token failed

JeffP — Fri, 29 Jun 2018 19:34:32 GMT

Good news: I found the problem.

Bad news: It's a bug in our code that converts the data.

I'm not sure when I can get a fix for you yet, but in the meantime, you can display the points in the 28992 by using the arcgisonline.nl maps. However, the data has to be in some other coordinate system. I noticed with the data you sent, there are lat/lon values in there as well. Those should work.

I'll post back once I know when my fix for this problem can be obtained.

Re: esri geoenrichment token failed

Hans_vanderBent — Sat, 30 Jun 2018 09:48:20 GMT

Thanks, but.... using lat long over the dutch esri server does not work either 😉 I think both are bugged in transformations.

Please let me know what and when it could be fixed, we are still in a proof of concept fase but..... 😉

Re: esri geoenrichment token failed

JeffP — Mon, 02 Jul 2018 14:10:50 GMT

Yes, I see we have problems there too. I have both fixed now and it will be available in the 8.3.1 release of Visual Analytics due out late this year.

Re: esri geoenrichment token failed

Hans_vanderBent — Tue, 03 Jul 2018 07:16:05 GMT

That would be great thanks!