12,310 reputation
238104
bio website linkedin.com/in/ryankdalton
location Whitefish, MT
age 41
visits member for 4 years
seen 7 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.


Aug
26
revised Find the closest line vertex from the linestring using PostGIS
deleted 38 characters in body; edited title
Aug
25
revised GIS files for US Special Districts?
deleted 2 characters in body
Aug
22
answered Statewide (and more) Address Point data source
Aug
22
comment Making Map with Color Ramp Using SQL Database Intergration?
What are your data sources? Is it a shapefile, personal or file geodatabase that you are trying to join to MSSQL Server tabular data? If both the spatial and tabular data are both contained within the SQL Server database, you should consider applying the join within the database. it will be much faster and eliminate a lot of the headaches that will follow.
Aug
22
awarded  Popular Question
Aug
21
revised How to merge Shapefiles from multiple folders into Geodatabase Featureclass?
edited title
Aug
20
revised Automated search of misplaced points with Python or Model Builder
added 141 characters in body
Aug
20
answered Automated search of misplaced points with Python or Model Builder
Aug
20
comment Where can I find “QGIS Training Manual” data?
Moderators: this question & the one linked by @GISKid should be merged with Where can I download the exercise data for The Free Quantum GIS Training Manual?
Aug
20
comment Where can I find “QGIS Training Manual” data?
Did the link in the 1.2. Preparing Exercise Data not provide you with what you need?
Aug
20
revised Where can I find “QGIS Training Manual” data?
edited tags; edited title
Aug
20
awarded  Popular Question
Aug
19
comment What is a simple python code to practice with in arcgis?
It's ok, there are lots of duplicate questions asked here, so you are not alone. Just try to do your research by searching for logical keywords in the search bar. For example [python] [arcpy] and then sort by "Votes". Welcome to GIS.SE!
Aug
19
comment What is a simple python code to practice with in arcgis?
Duplicate of What are some resources for learning ArcPy? and What are the best resources for learning GIS programming with Python?
Aug
19
answered Creating shapefile from selection - remove from map
Aug
13
comment What is the most efficient way to search a geodatabase for NULL-like records?
@Barbarossa, is that 1m40s for arcpy.da.UpdateCursor correct? If so, wow, that's much faster than the others!
Aug
13
revised Can ArcGIS ModelBuilder be exported to Python and run in QGIS?
edited title
Aug
13
comment What is the most efficient way to search a geodatabase for NULL-like records?
@Barbarossa, You say using select & calculate is slower than cursoring through all records and updating individual columns per row? I hope you share your benchmark statistics after you complete the two code options because that would surprise me, especially on larger datasets.
Aug
13
revised Can ArcGIS ModelBuilder be exported to Python and run in QGIS?
moved comment to part of the question for explanation of use case
Aug
13
comment How do I calculate Manhattan distance with PostGIS?
Have you also considered extending your PostGIS data with the pgRouting module and using it's built-in functions? Apparently the A* method uses something similar.