12,310 reputation
237104
bio website linkedin.com/in/ryankdalton
location Whitefish, MT
age 41
visits member for 4 years
seen 18 mins ago

I am particularly interested in location analytics, blending Business Intelligence with spatial analysis. Examples include retail/real estate site selection, trade area analysis, customer research, and marketing through demographic analysis.

I use Python for process and workflow automation, database reporting & manipulation, and developing new spatial tools.

I've been a GIS professional for 15+ years, most of which using ESRI tools (since Arc/Info 7.x). More recently I find myself using more open-source tools (QGIS, PostGIS, GDAL/OGR, web-based tools) and ultimately choosing "the right tool for the job" rather than being tied to a single vendor or toolset.


Dec
4
answered Arcpy (10.0) and centroids/points shapefile
Dec
4
awarded  Notable Question
Dec
4
comment How do I select * rows of multiple columns in one query using Select by Attributes within ArcMap?
Select statements in ArcGIS are very basic. ArcGIS is automatically set up to "Select * from [Table]". You only have the ability to add the WHERE clause. You also will not have the ability to use your GROUP BY, HAVING, and ORDER BY statements,
Dec
4
comment How to make labels' size relative to the map in QGIS1.8?
As a followup to @underdark, what are your map units? Feet, meters, degrees?
Dec
4
comment How to create a generic tool with ModelBuilder in ArcGIS?
It would probably be helpful for you to look at the online help, which has an excellent tutorial on building models and exposing parameters. resources.arcgis.com/en/help/main/10.1/index.html#//…
Dec
4
revised How can I reduce the size of my file geodatadase?
edited the web help to reference FILE geodatabase compress, not ARCSDE compress help.
Dec
4
answered How can I reduce the size of my file geodatadase?
Dec
4
accepted Are there QGIS tools that will allow users to get tabular statistics from their table?
Dec
4
revised Are there QGIS tools that will allow users to get tabular statistics from their table?
Update to the tools that are similar, but now exact.
Dec
4
asked Are there QGIS tools that will allow users to get tabular statistics from their table?
Dec
3
comment Python: “Import Script” greyed out
Do you have a strong need to import the script into the tools cache? Why not just allow the ArcGIS script tool to point to the script (on disk) itself. Unless it is for portability or to "hide" the script from a user, there is no need to "Import Script"...
Dec
3
revised Import CSV: Is there a cap for number of row
added 5 characters in body; edited tags
Dec
3
comment Can I do full SQL expressions through the “WHERE” clause in UpdateCursor?
Where is "public.shapefile" coming from? Are you trying to select data from a Postgresql database and then update all fields in a shapefile? Your where clause doesn't seem to make sense...
Dec
3
comment Can I do full SQL expressions through the “WHERE” clause in UpdateCursor?
What is your data source? PostGIS or a shapefile? Is your "public.shapefile" part of an ArcSDE database? More details about what you are trying to accomplish will help you get better answers.
Dec
3
revised Is it possible to increase/reduce features proportionally?
Added links to the ArcGIS scale tool refered to by OP
Dec
3
revised How to extract most probable flow line from multiple lines?
edited tags
Dec
1
comment How to use Heatmap plugin and its output?
There is an excellent tutorial on using the heatmap at qgis.spatialthoughts.com/2012/07/…
Dec
1
comment How to create heatmap (concentration of points) in QGIS?
Take a look at this excellent tutorial at qgis.spatialthoughts.com/2012/07/…
Dec
1
comment Where is the Heatmap Plugin
There is a good tutorial here: qgis.spatialthoughts.com/2012/07/…
Nov
30
revised Is there a “Tabulate Area” function in QGIS?
added 122 characters in body; edited title