12,509 reputation
240107
bio website linkedin.com/in/ryankdalton
location Whitefish, MT
age 41
visits member for 4 years, 2 months
seen 19 mins 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
10
comment Joining tables without losing original field names in ArcGIS for Desktop?
@Johannes, Before working on your data outside of ArcGIS, why not try converting your data to a more modern database format that ArcGIS supports like a file geodatabsae, or even a personal geodatabase. At least then you would know that it is a shapefile limitation, and not an Arc limitation/Issue/Bug.
Dec
9
comment Creating new shapefile based on its attributes with python
Good answer. Using this methodology, you could also very easily script what your particular attribute queries are going to be, and then just run the Select Layer by Attribute tool iteratively over all of your predefined queries.
Dec
7
comment What is the best web editor and server for postgis?
Sorry, my mistake.
Dec
7
comment What is the best web editor and server for postgis?
Did you see that @Mapperz already posted this suggestion for OpenLayers?
Dec
7
revised Display the outline of many polygons
edited tags; edited title
Dec
7
answered Display the outline of many polygons
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?