11,930 reputation
13398
bio website linkedin.com/in/ryankdalton
location Whitefish, MT
age 41
visits member for 3 years, 9 months
seen 2 days 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.


Nov
3
comment How to upgrade PostGIS in OSGEO-Live Xubuntu virtual machine?
This post to the postgis user list suggests I would need to build PostGIS 2.0 from source...
Nov
3
comment How to upgrade PostGIS in OSGEO-Live Xubuntu virtual machine?
So I did a select version() and it said the OSGEO Live DVD 6.0 is running postgresql 9.1.5. Running select postgis_full_version() says it is PostGIS 1.5.3. After creating a new DB, then CREATE EXTENSION postgis, I got ERROR: could not open extension control file "/usr/share/postgresql/9.1/extension/postgis.control": No such file or directory. Thoughts?
Nov
2
revised Incorporating SQL Statements in Model Builder
edited tags
Nov
2
answered Incorporating SQL Statements in Model Builder
Nov
2
answered Is “Hawth's Tools” available for ArcGIS 10?
Nov
2
revised Is there a silent installation command without the desktop shortcuts?
edited tags
Nov
2
revised How to avoid map refreshes in print composer?
edited tags
Nov
1
comment How to connect places (points) without crossing lines?
adding more detail to what @Radar asked, if you have say streetname and address attached to the points, you could use that data to help 1) only connect points with the same streetname together, 2) order your data sequentially (by address number, or even/odd address numbers so they dont cross a street, and 3) provide line virtual breakpoints between blocks (only connect lines from 100-199, 200-299, etc). Does that pretty much describe what you are trying to accomplish?
Nov
1
awarded  Cleanup
Nov
1
revised Problem with the where clause in ArcGIS when dealing with variables
rolled back to a previous revision
Nov
1
revised Problem with the where clause in ArcGIS when dealing with variables
added 8 characters in body
Oct
31
revised Where can I find QGIS tutorials and resources?
added 12 characters in body
Oct
31
comment What is the fastest way to iterate through a list of features?
What exactly are you trying to accomplish? An upstream or downstream trace? Having a better idea of your actual goals will help people point you in the right direction for the entire process, not just a single step.
Oct
31
answered Where can I find QGIS tutorials and resources?
Oct
30
revised Identify tool (attribute pop-up)
edited tags
Oct
26
comment How integrated can an IDE get for arcpy scripting?
Similar or duplicate question (code complete): Is there a way to code-complete arcpy scripts using an external editor?. Check out my comments for PyScripter under the answer by @VietThanh Le.
Oct
24
comment Which GIS best for this problem?
QGIS is not only great, but its also FREE. And this great training manual for QGIS will help lesson your learning curve.
Oct
23
comment Select by “Not-in” Location
And this would be a really simple ModelBuilder tool to build, if you want ot use this repeatedly. Just add the "Select By Location" tool to your model twice and adjust each tool as described above.
Oct
23
comment Merge Zip Codes to Create new sales Markets
For most GIS products, the method would be called a "dissolve", which would remove the internal boundaries based upon a common attribute in an attribute field (column).
Oct
23
revised Calculating from a location to another location (calculation must be on a line/road path)
edited tags