Alteryx Designer Desktop Ideas

Hi,

 

I recently had a project that involved clipping the spatial polygon from one record with the spatial polygon of a different dataset. Currently, the only way I know how to use Alteryx to do this is to use a Spatial Match tool to get both spatial objects in the same record line, which allows me to use the Spatial Process tool. In my case, I was trying to trim polygons to the US, so my second spatial object was a polygon for the entire US, which then got attached to every record of my data in order to do the Spatial Process.

 

My suggestion is simple, make the Spatial Process tool have an option that would allow for two Inputs. I bring my target data in on one stream, chose the process method I want, and use the second Input as my "clip" data. This would allow people to trip/clip their data without having to append the clip data to every single record in the target dataset.

 

Same concept applies for the Distance tool, currently have to have both spatial objects in one record. My suggestion is to allow the Distance tool to also allow two inputs, I understand there is the Find Nearest tool and that as two inputs, but I'm not always just wanting the nearest, or to have a cutoff distance. Sometimes, I just want to know the distance in my target data to the location in my secondary file, for every record..

I haven’t found a common spatial file format to use between Alteryx, MapInfo Pro and ArcMap.  The one file/db type that all 3 software packages have the ability to use is SQLite.  Problem is that each of these GIS packages stores data differently in SQLite. 
I propose the following…  Alteryx should have 2 new SQLite options to save output (and read from) in SQLite-ESRI and SQLite-MapInfo.  This does not get us to the holy grail of one common file format but does get us down to 2.  (If you guys could figure out 1 common format that would be better)

Having these new SQLite formats would fix a common issue shared by the Alteryx supported ESRI and MapInfo formats, namely 2G file limits, multiple files per dataset and short field names.  Currently, to save an output for ESRI and Mapinfo, I take a single yxdb and save multiple shape or tab files.  The conversion back is an aggregation of individual files into an yxdb.  SQLite, as a database, has the ability to store many tables which further reduces files (much like a file geodatabase).

Finally, I have been begging for Alteryx to have the ability to read and write to an ESRI file geodatabase, which seems to never come to fruition.  This SQLite solution would eliminate my need to write out to file geodatabases.
 

Hi,

Recently in Feb 2016, Australia released the geocoded national address file to the public for no extra cost and will continually update this each quarter.

 I think It would be a game changer to build this functionality natively into the alteryx product to enable any alteryx user simple access to it. also I think it would drive a lot of sales for the alteryx product.

 

http://www.data.gov.au/dataset/geocoded-national-address-file-g-naf

 

adrian

In the Report Map tool, I'm locked from changing the 'Background Color' menu, and the color appears to be set to R=253, G=254, B=255, which is basically white. 

 

However, when we use our TomTom basemap, we see that the background is actually blue, despite what's listed in the Background Color window.  (This goes beyond the 'Ocean' layer, and appears to cover all space 'under' the continents and ocean.)  Since we oftren print large maps of the east coast, this tends to use a lot of blue ink.  I've attached a sample image to illustrate this.

 

My solve to-date has been to edit the underlying TeleAtlas text file and change the default background (117 157 181) to white (255 255 255).  Unfortunately, we lose these changes with each data update.

 

Could Alteryx unlock the Background Color menu, and have it affect the 'base' layer, underneath oceans and continents in TomTom maps?  Not sure how it might affect aerial imagery.

May I suggest you add the capability to use maps from the OpenStreetMap project offline.

 

Many thanks

I want the ability to select a field from my reference YXDB file in the Map Input tool to color-code the features based on their value. For example, I have a file of store locations, with each record containing last quarter's sales figures. I want to use that file as my reference in the Map Input, and have the points for each stores sized bigger-to-smaller based on their sales. Or another example would be color-coding sales territories/polygons.

Alteryx's spatial tools are really powerful and offer a lot of value for analysis.  However, when rendering a map for output, there is currently no way to place an image inside of a polygon.  This feature would be very useful for customized layers on maps and other spatial-based processes.

My rough suggestion would be to scale a selected image to the size of the polygon's bounding rectangle, and then trim the edges of the image to fit inside the polygon itself.

As a GIS department, we use numerous spatial datasets on a daily basis.  Many of these are quite large and we are looking for ways to optimize their performance.  Right now, we are forced to use an indexed folder system to increase performance, but we would like to move to Calgary databases.  The problem is, that Calgary databases only hold point features which limits the number of our datasets that we can use it with.  If we could spatially index line and polygon features as well, that would dramatically increase the usefulness of a Calgary database.

I'm still relatively new, so I trust someone will correct and instruct me if this already exists. I have looked and have not been able to find it.

 

It would be nice if there was an option to return the standard 2 letter abbreviations for states from the Allocate Input tool's "Pick Variables" "geographic Identifiers." Currently, the only identifiers available are "Key" an"Name":

 

Where, Key is numeric ("02", "44", etc.), and Name is the full state Name. In order to join to most of our databases, I usually need this to be the standard 2 letter abbreviation. This forces me to join to another database table to translate it.

 

Could you please add a second/separate opacity setting for polygons?  Many times I'd like to have a solid border around a trade area, but with about a 50% opacity setting for the fill.

 

Thanks!

Do put an option to take any distance.

 

it sure have case that we do not care the distance.

 

same go to other spatial tool have similar setting.

With more people moving into urban developments, it would be helpful to allow analysts to measure customers within a "walking distance". Similar to drive time analysis, a step up would be to incorporate "walk time" analysis.

Currently, the map input for an application defaults either to a global view of the United States or to a fixed boundary. Usng a chained application, it would be an extremely useful option to be able to specifiy spatial objects (points, lines, polygons) in the first application and then allow the second application to zoom in appropriately to those spatial objects. This could be done by either specifying a custom zoom level and using those spatial objects as a center through a reference layer, or by allowing the zoom's boundary to contain all the spatial objects (similar to the map reporting tools).

 

 

US and Canada datasets are underlined so far but,

 

Alteryx is expanding towards, Denmark, Germany, France and several other countries...

The question is; Why don't we have Eurostat data provided as well?

 

 

 

Bulk options for some datasets are available.

Even one can get a grasp on micro datasets and Alteryx may have a deal inf this micro dataset is anonymized...

 

 

 

 

 

 

 

Hello!

 

I think it would be useful to have an ability to groupby spatialobj in the summarize tool. I currently work around this by using several tools and I think it would be great to use the native summarize tool.

In GIS, spatial data is regularly stored/transmitted as text. With this comes metadata, including the projection used.

 

Example Issue: When extracting data from ESRI's ArcGIS REST Directories, the projection can be extracted from the information, but must be manually defined in the Make Points Tool. If you are trying to compile data from several different sources, all using different projections, you cannot automate the process. 

 

Suggested Solution: Add WKT to macro interface configuration options so that an Action Interface Tool can update the Create Points Tool.

 

Attachments:

JSON extract.png - This is a screenshot of the spatial reference metadata in a JSON formatted query from an ArcGIS REST Directory. 

action tool.png - Current configuration options for Create Points Tool in the Action Interface Tool.

Working for an education company, it would be a huge value for us to be able to have the US school districts available in the spatial sweet of apps, so I could take all of the US schools that are customers and map them to their School Districts in a polygon map.

When using spatial processing tools please add the abilty to join between the target and universe based on a field.  This field based join could be used to narrow the geographies prior to performing spatial tests thus greatly improving processing time.

I appreciate being able to write to an ESRI File GeoDatabase. It would be even better if in the process of writing to an ESRI File GeoDatabase I could identify fields to index and have them indexed when writing to the File GeoDatabse. Currently I have to add the index in ArcGIS after the fact. Writing to an ESRI File GeoDatabase currently adds a spatial index automatically, but I'm talking about an attribute index here.