meta user
network profile
| bio | website | linkedin.com/in/ryankdalton |
|---|---|---|
| location | Whitefish, MT | |
| age | 39 | |
| visits | member for | 2 years, 7 months |
| seen | 4 hours ago | |
| stats | profile views | 670 |
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.
|
Apr 26 |
revised |
Site to download al USGS Topo Maps in bulk added 22 characters in body |
|
Apr 26 |
answered | Site to download al USGS Topo Maps in bulk |
|
Apr 26 |
comment |
Help with joining a large dbf file to shape file Creating related tables (an ArcMap function) is available to ArcView and above licenses. Creating Relationship Classes (a geodatabase function) is available to ArcEditor & ArcInfo license. This help page details the differences- help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/… |
|
Apr 22 |
comment |
Export list of coordinates in a points layer to spreadsheet? If you want to automate the process, simply add these tools and input/output files into a ModelBuilder tool. Use the "Copy Rows" function to export just the table and not the shapefile. CopyRows only saves to DBF, but the same process @Wolf mentioned above will work. If you really want to get creative, export the model to a python script and then you could script the DBF->CSV conversion using pure python. |
|
Apr 21 |
revised |
Where should I start advanced GIS learning deleted 1 characters in body; added 4 characters in body |
|
Apr 21 |
answered | Where should I start advanced GIS learning |
|
Apr 20 |
comment |
Matching ArcGIS and QGIS coordinate systems there are some other good references for getting this info at: gis.stackexchange.com/questions/7608/… |
|
Apr 20 |
comment |
Thiessen Polygon delineation within a Feature Why not just build this process in ModelBuilder and throw a "clip" routine at the end so that the results come out the way you want. If automation of the routine is all that is necessary, this seems like an easy way to accomplish the task. |
|
Apr 19 |
accepted | Bulk load multiple shapefiles into PostGIS |
|
Apr 18 |
revised |
Google Earth portable solution and imagery data made link to "portable.html" hotlinked |
|
Apr 18 |
suggested | suggested edit on Google Earth portable solution and imagery data |
|
Apr 18 |
answered | Creating Polys and Displaying geo points within. ( Where to start? ) |
|
Apr 15 |
comment |
How to hide “internal” polygon boundaries? Good answer. While simple, creating multiple layer files that reference the same data layer, and simply applying the appropriate definition query to each can often be the quickest and simplest method of displaying this type of data. |
|
Apr 15 |
answered | QGIS composer - How can I eliminate striping across transparent raster layers? |
|
Apr 15 |
accepted | PostGIS feature compare function? |
|
Apr 14 |
comment |
PostGIS feature compare function? As an update to my previous comment, I have determined it is an issue with the "geometry" field. If I use pure text fields, the query works fine. If I use "=", the query works fine. It's just if I include "!=" and the "geometry" field in the row() statement that I get the error. |
|
Apr 14 |
comment |
PostGIS feature compare function? @Sean, thanks for you great update to the code. When I ran this and made the updates to the table names and attributes, I got the following error: "Could not choose a best candidate operator. You might need to add explicit type casts", referring to the "!=". Thoughts? Running Postgres 9.0.1 and PostGIS 1.5.2. |
|
Apr 14 |
comment |
PostGIS feature compare function? @Sean: I am so very close to making this work, but when I attempted to do a UNION (as I used in the ST_EQUALS answer) to include all of the new geometries, I couldn't get it to work because it said I needed the same number of rows in my union query. The Row()=Row() creates an boolean column that doesn't exist in my source data (part of the UNION statement), so how do I create/reference a "fake" column in my UNION query to match the ROW()=ROW() select statement? |
|
Apr 13 |
revised |
Compiling Python Scripts That Use ArcGIS Geoprocessing Tools edited tags |
|
Apr 13 |
comment |
PostGIS feature compare function? What I really wanted to get as a result were all geometries in layer A (updated) that had been added or changed since layer B (original). I was able to accomplish that result with the following syntax: SELECT A.fields FROM A EXCEPT SELECT A.fields FROM A,B WHERE ST_EQUALS(A.geom,B.geom). The result is all of the feature geometries from layer A that have changed or been added. Thanks! |
