12,509 reputation
240106
bio website linkedin.com/in/ryankdalton
location Whitefish, MT
age 41
visits member for 4 years, 1 month
seen 3 hours 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
5
comment Sort layers in QGIS table of contents?
I have posted a feature request for this functionality.
Dec
5
comment Are there QGIS tools that will allow users to get tabular statistics from their table?
I have submitted a bug report for Group Stats sorting.
Dec
5
comment Are there QGIS tools that will allow users to get tabular statistics from their table?
Group Stats is a great little utility. Its a shame that the field sorting for numeric values like count, sum, etc uses alphanumeric sorting (ie- 1,10,100,2,21,3,350) instead of numeric sorting. But the fact that you can at least copy/paste the results into a spreadsheet and re-sort that way makes it pretty useful.
Dec
5
revised Arcpy (10.0) and centroids/points shapefile
updated info about license level
Dec
5
comment Arcpy (10.0) and centroids/points shapefile
@artwork21, your statement is correct, but maybe a bit misleading. As long as you have the "inside" check box ticked on, it will create a point somewhere on the surface of the polygon. But you are correct that it will not put the point in the center of oddly shaped or multi-part polygons.
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