12,065 reputation
133102
bio website linkedin.com/in/ryankdalton
location Whitefish, MT
age 41
visits member for 3 years, 10 months
seen 3 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.


17h
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.
18h
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
Aug
26
revised Is there a way to add an autoincrementing primary key field to an existing spatialite table/layer?
added 110 characters in body
Aug
26
revised Find the closest line vertex from the linestring using PostGIS
deleted 38 characters in body; edited title
Aug
25
revised GIS files for US Special Districts?
deleted 2 characters in body
Aug
22
answered Statewide (and more) Address Point data source
Aug
22
comment Making Map with Color Ramp Using SQL Database Intergration?
What are your data sources? Is it a shapefile, personal or file geodatabase that you are trying to join to MSSQL Server tabular data? If both the spatial and tabular data are both contained within the SQL Server database, you should consider applying the join within the database. it will be much faster and eliminate a lot of the headaches that will follow.
Aug
22
awarded  Popular Question
Aug
21
revised How to merge Shapefiles from multiple folders into Geodatabase Featureclass?
edited title
Aug
20
revised Automated search of misplaced points with Python or Model Builder
added 141 characters in body
Aug
20
answered Automated search of misplaced points with Python or Model Builder
Aug
20
comment Where can I find “QGIS Training Manual” data?
Moderators: this question & the one linked by @GISKid should be merged with Where can I download the exercise data for The Free Quantum GIS Training Manual?