12,325 reputation
238105
bio website linkedin.com/in/ryankdalton
location Whitefish, MT
age 41
visits member for 4 years
seen yesterday

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.


Sep
3
revised Word cloud labels in QGIS from database
added 30 characters in body
Sep
3
comment Most Up-To-Date Source for US Zip Code Boundaries
Is it possible for an EDDM user to download/import polygon zip code boundaries into traditional GIS software? Or is there another (licensing) option for using the ZIP code boundaries within GIS software?
Sep
3
revised Most Up-To-Date Source for US Zip Code Boundaries
added 25 characters in body
Sep
3
comment How to draw ploygon in leaflet that use event?
Some added details would be helpful, here. Are you wanting to draw a circle of a particular size on-click? Maybe a mocked-up picture would demonstrate what you are looking for.
Sep
3
comment Installed PostGIS extension not listed for database
@MickyInTheSky, check out how to Change schema of multiple PostgreSQL tables in one operation for migrating your data to another schema.
Sep
3
revised Definition Query / SQL problem in ArcGIS
Updated formatting
Sep
3
comment My woes rendering shape files on web-based mapping application
What type of data? Points, lines, polygons? Do you need the features to be "interactive" (ie- click for an information popup, etc)? The more information you can provide on your use case, the better the answers you will receive.
Sep
2
revised Pause ArcPy script until feature class lock goes away
added time.sleep function to pause
Sep
2
comment Pause ArcPy script until feature class lock goes away
I was just in the middle of posting practically the same code as you with "TestSchemaLock". I've also updated your second example code with the "time.sleep" function for pausing.
Sep
2
awarded  Notable Question
Sep
1
comment Setting up QGIS Server at low cost for small user community?
One other option, listed only in the comments by @Erick in the answer by "pgager" is OpenShift by RedHat.
Sep
1
comment Setting up QGIS Server at low cost for small user community?
A likely duplicate of Looking for a FREE Cloud based 'Web Mapping Stack' Host, at least in the general sense of the question.
Aug
29
revised openlayers leaflet and popup
edited tags
Aug
29
comment SQL query to have a complete geojson feature from PostGIS
Great, that makes sense. I guess I just didn't look closely enough. Feel free to mark this as "Accepted" once GIS.SE allows it to close out the question. Thanks!
Aug
28
comment SQL query to have a complete geojson feature from PostGIS
since you moved this from the body of your question to the answer, does this mean this query and result now working correctly? Running this through GeoJSONLint, it still does not appear to be giving valid output.
Aug
28
comment where styles from QGIS are saved in PostgreSQl
@bable, Since you answered your own question, please provide an "Answer" below and then mark it as accepted. If you could also add a bit more detail about what you found, such as which table you found the styles saved in, and what format it was saved, and any other additional information that would be helpful to future readers. Thanks!
Aug
28
comment Unicode Decode Error for shapefile in Python
Great you were able to answer your own question. It usually takes 2 days on GIS.SE be allowed to accept your own answer, but please do so when available to close the thread. Thanks!
Aug
28
revised Fast Offline OSM Routing Library to Replace MoNav (.NET)
added 90 characters in body
Aug
27
revised Is there a universal map/ layer format?
added link to shapefile technical specifications
Aug
26
revised FWTools Python ImportError: DLL load failed:parameter is incorrect
edited tags; edited title