ESRI Coordinate Row Filter Workflow

[lelloba]

Hi Creedsmith,

have a look at this:

Coordinates inside polygon - Application – lelloba

Seems to work (to be honest, I’ve checked only a couple of rows):

The final output contains both rows with houses inside a geofence and houses not belonging to anything.
I have not used views/visuals nor followed the article you’ve sent me yet.

Hope it’s ok for you, let me know
RB

[smithcreed]

@lelloba thank you; I will play with this for awhile.

Along with the other article linked prior, you may wish to also look at this, if you have not already done so read-multiple-shp-files-in-loop — NodePit

Sometimes, it’s a matter of looking at a bunch of different concepts that helps you arrive where you really want to be.

[smithcreed]

@lelloba I’m having a terrible time installing and getting R to work to run your Snippet Node. Are you running an Apple or Windows machine? Is this the link Rtools42 for Windows where I can install all the KNIME Console packages in red text? Thanks

[smithcreed]

So, ten hours in and I cannot get R (installed latest version of R and Rtools) to work. The R Snippet throws error notices. I’ll have to search out another method. Thanks for your help.

[lelloba]

Hi Creedsmith,

I am using Windows. Which is the sequence of steps you have followed for installation?

Maybe this can help:

Install R alongside KNIME on Windows and MacOS

Over the last months I have collected a few entries about the installation of R alongside KNIME that contain some maybe useful hints how to overcome certain obstacles while installing them. I want to bring them together here. (If you are looking for a basic guide about how to install R in the first place you might look here or here). A few maybe unnecessary remarks upfront. Yes it takes some effort to get KNIME and R up and running but in the end you will be rewarded with the whole world of pos…

Otherwise, we need to translate the code into something else.

RB

[Thyme]

@smithcreed Getting R to run with KNIME can be tricky to do (took me a while the last time I did it). I may have a different approach to that problem. If all you want is the code snippet, you can get it from the settings.xml of that node:

1. Save the imported workflow to your workspace
2. Open your workspace in the Windows Explorer, navigate to the workflow and node.
3. Find the snippet somewhere within the settings.xml (near the top)
4. The text is escaped html if I remember correctly, you’ll need to un-escape it.

This doesn’t require you to have the extension installed and/or working, so it’s obviously a read only process. Since the implementation of @lelloba is not R specific, you could use any scripting node (or possibly pure-KNIME?) after translating the syntax.

[smithcreed]

@Thyme @lelloba I finally got R to function on windows and KNIME, I think. I’m now trying to understand how the results are coming out. I show 60 properties not within any polygon. I would have expected far fewer and will try mapping everything out to see what is going on.

I ended up installing the fully R-Tidyverse libraries to get things running. Thanks