12,509 reputation
240107
bio website linkedin.com/in/ryankdalton
location Whitefish, MT
age 41
visits member for 4 years, 2 months
seen 19 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
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.
Aug
13
revised How do I calculate Manhattan distance with PostGIS?
added link to Taxicab Distance article from Wikipedia
Aug
13
comment Can ArcGIS ModelBuilder be exported to Python and run in QGIS?
Can you describe the use case for why you want to migrate models/python scripts from ArcGIS to QGIS? Are they migrating from ArcGIS to QGIS, or do you just know ArcGIS and want to convert your models to their platform? If the latter, you might just look at learning the QGIS Processing Framework, the equivalent of ArcGIS ModelBuilder.
Aug
12
answered What is the most efficient way to search a geodatabase for NULL-like records?
Aug
12
comment What is the most efficient way to search a geodatabase for NULL-like records?
Is this a personal (mdb), file (gdb), or RDBMS (ArcSDE)?
Aug
12
comment all-in-one gis packages for windows 8.1?
How about the OSGeo-Live Virtual Machine? "OSGeo-Live is a self-contained Virtual Machine based on Xubuntu, that allows you to try a wide variety of open source geospatial software without installing anything. It is composed entirely of free software, allowing it to be freely distributed, duplicated and passed around. It provides pre-configured applications for a range of geospatial use cases, including storage, publishing, viewing, analysis and manipulation of data. It also contains sample datasets and documentation."
Aug
12
answered Unable to save to in Geojson format with the correct projection
Aug
11
awarded  Caucus
Aug
11
revised Preparing Huff model with data to use in QGIS?
edited tags
Aug
11
comment Preparing Huff model with data to use in QGIS?
Searching this site for Huff Model will provide you a few other references that you may find useful, but probably do not answer your question explicitly.
Aug
11
comment Categorized style hiding map
Which version of QGIS are you using?
Aug
8
revised How to download hospitals and restaurants from OSM in shp format?
added 39 characters in body
Aug
8
revised How to download hospitals and restaurants from OSM in shp format?
edited tags
Aug
8
revised Where can I find a list of (preferably free) valid USPS zipcodes?
edited tags
Aug
8
revised Most Up-To-Date Source for US Zip Code Boundaries
edited tags