12,589 reputation
240107
bio website linkedin.com/in/ryankdalton
location Whitefish, MT
age 41
visits member for 4 years, 3 months
seen 12 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 Are there any open source Python modules compatible with arcpy that will allow complex SQL queries?
What kind of duplicates are you looking for? Geometry duplicates (overlapping features), duplicates values within a field, or duplicate rows comparing multiple fields?
Dec
5
comment Is there anything faster than a cursor in ArcGIS to calculate records?
At the 2012 User Conference, they demonstrated up to a 10x improvement using arcpy_da cursors vs arcpy cursors.
Dec
5
comment How to get $length in meters in QGIS?
We can't help you unless we know what software are you using?
Dec
5
comment Viewshed Analysis With GDAL
It's been a while since you sort of answered this question without a real answer? Do you have an update or maybe just delete the answer?
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"...