12,310 reputation
237104
bio website linkedin.com/in/ryankdalton
location Whitefish, MT
age 41
visits member for 4 years
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
7
comment How to best organize files for a large arcpy script tool?
Or how about this: Guidelines for organizing Python Toolboxes (.pyt) in ArcGIS
Dec
6
revised Why am I getting duplicate ghost points (features), i.e., one point in the feature class but two points?
edited tags
Dec
6
awarded  Popular Question
Dec
6
revised FieldPyculator Plugin - How to concatenate fields?
edited tags
Dec
6
answered Joining tables without losing original field names in ArcGIS for Desktop?
Dec
6
comment How to geocode an address to a polygon?
After looking more closely at the data, another advantage of the option 1 stated above is that some parcels may have more than 1 address point per polygon (think apartments and condos). By joining/geocoding first to the point, you will 1) get better geocodes and 2) not need to worry about getting multiple addresses on each polygon. For example, there are 394732 parcels, 530750 address points, a max count of 632 points in a single parcel, and 24 "stacked" points representing multiple addresses at the same location.
Dec
6
comment How to dissolve polygons that have been split back into their original polygons?
How many "original polygons" will be in the resultant layer? If it is just 1, just add a dummy field, calculate it with all the same value, then run the dissolve command.
Dec
6
comment How to geocode an address to a polygon?
I almost wrote an identical answer, but liked your detail. Some additional info will solve this problem, though. If you also download the "Alameda County Secondary Addresses", which has the addresses AND the parcel number, you can either 1A) join your table to the SPAD points using the address field, or 1B) geocode to the SPAD points, and then 1C) select the intersecting parcels or 2) spatial join the SPAD point address data to the parcels and then join or geocode to the parcel polygons. I would suggest going with option 1, though, it will be easier.
Dec
5
comment Arcpy (10.0) and centroids/points shapefile
@Baltok, you should really add your ET Geowizards comments as another answer. If it turns out to be correct, it would be good to have that captured in a "checkmarked" answer.
Dec
5
comment Are there any open source Python modules compatible with arcpy that will allow complex SQL queries?
Yes, if you convert from a shapefile to another format (file gdb, personal gdb, arcsde gdb, postgis, etc) then of course the database specs will change and you will have different sql capabilities based upon whatever the native database format is. You said that your didn't want to convert the data, though...
Dec
5
comment Are there any open source Python modules compatible with arcpy that will allow complex SQL queries?
Also, since you are working with a shapefile which uses a DBF to store its database info, you will be limited to the query capabilities of the DBF format.
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.