7,930 reputation
11665
bio website linkedin.com/in/ryankdalton
location Whitefish, MT
age 39
visits member for 2 years, 7 months
seen yesterday
stats profile views 673

I've been a career GIS user for 15+ years. I am particularly interested in extending Business Intelligence through spatial analysis. Examples include enhanced retail/real estate decision-making during site selection, trade area analysis, customer research, and marketing through demographic analysis.

I have been using Python more and more for process automation, developing new tools and database maniupulation.

Most of my career I've been in the ESRI camp, but am now starting to use more open-source tools (QGIS, PostGIS, GDAL/OGR, web-based GIS) so I can "choose the right tool" for the job.


2d
comment How to find out what projection my data is using?
You could try entering an XY into ProjFinder and see if anything hits.
2d
comment Use QuantumGIS to bulk-import csv files
Link to OGR
May
21
comment Is there an address gazetteer for QGIS?
please ask your question as a separate question, and reference this question for details. Thanks.
May
20
comment How to truncate field names to 10 characters in model builder
Are you trying to edit field NAMES (ie- column headers) or field VALUES (the data in the row/cell)? These 2 questions have very different answers.
May
18
comment Mapping elements in a warehouse
Take a look at the other questions tagged with indoor, which may help you with your other tasks.
May
15
comment How to find parcels related to geocoded addresses?
Can you post a screenshot of 1 or 2 records from each table? Or better yet, a small sample subset for us to look at? You might get better suggestions that way.
May
15
comment How to find parcels related to geocoded addresses?
I assume you have your own parcel polygon layer that you are trying to compare the points to, correct? If so, does the parcel layer have an address field that you can compare to the address field in the geocoded table?
May
2
comment Exporting Selection Using Python
Generally speaking, all ArcGIS GP operations behave on 1) the selected features , and 2) the whole data set if none is selected. Therefore, as long as you have features selected, only those features will be exported.
Apr
30
comment How to embed a PDF into an Excel spreadsheet?
Mike, I changed your tags to give more visibility to your question. The "exportreport" and "exporttopdf" tags you added have never been used, whereas "pdf" and "reports" are much more common and people may already be following and searching on them. Since you already had the functions listed in the question, your question will still show up in a search. Tags are meant to be generic, not specific. Please reconsider using "pdf" and "reports".
Apr
30
comment CMYK Lines and Fills in QGIS
Sounds like a good "future project" for QGIS.
Apr
26
comment How to import or incorporate formated Excel tab into QGIS print composer
Are you hoping to somehow have this live-linked to the Excel sheet? Or could you just capture a screenshot, save as image, and import the image into the print composer?
Apr
26
comment Conflicting measurement units with buffer ftools
Please see @whuber's comment to Tomek's answer. The same principle applies to your answer.
Apr
25
comment Measuring Script Writing Competency
Take a look at this nice update to the matrix, which allows for a "checkbox" interface. Code available from here.
Apr
23
comment Non-spatial Data Driven Pages
I think what you are looking for is scripting your map document changes in Python by using the arcpy.mapping toolset. See the reference to building complete map books, and more specifically within the document, "Simple reference series map book".
Apr
22
comment Shapefiles to Text
Just and FYI, but while this does write out the feature vertices to points to a text file, it does not write the data out as OGC compliant Well Known Text (WKT), in case that is what you are looking for.
Apr
18
comment How to convert geometry to WKT using ArcPy?
While I unfortunately do not have access to 10.1 yet, I was ultimately able to update the Python script that you linked to. Thanks!
Apr
17
comment How to georeference PNG images using QGIS?
@djq, Please mark the answer as "accepted" to close this question out. Thanks.
Apr
17
comment Pros and cons of using Ruby/Rails/RGeo or Python/GeoDjango for a web based GIS
@PolyGeo, ORM = Object Relational Mapper. A python example of this is SQLAlchemy. It is basically a level of abstraction that allows you to seamlessly change out your web mapping engine or SQL engine without having to rewrite the code to match system-specific architecture.
Apr
12
comment What is the best free web GIS browser?
I haven't used any of their pay versions yet, but from how I read each of their plans, paid accounts allow for restricted access "private" (not public) usage.
Apr
12
comment Are the public domain vehicle tracks available?
Part 2 of the question same as: Simulate (Mock) GPS Tracks