7,404 reputation
21846
bio website getspatial.com
location San Diego, CA
age 37
visits member for 3 years, 11 months
seen Dec 21 at 21:21

Geographer specifically focused on utilities-based GIS since 1999. My expertise is primarily in the areas of data organization, geodatabase design and data creation. Most of my time has been spent with ESRI products. Over the last few years, i have been familiarizing myself with the open source GIS software that is currently available.


Dec
19
comment How to avoid duplicate GIDs when copying features from one PostGIS layer to another?
Did you ever find a solution to this problem? I am encountering the exact same issue. I do not want to have to put a trigger in place in PostgreSQL when it is a matter of QGIS not pulling default values when new features are created by copying others.
Dec
17
comment ArcGIS and QGIS compatibility: issues with Shapefiles or Geodatabases?
@Slinn - Oddly enough, I had never tested this before, but I just successfully edited a layer from a File GDB in QGIS. I then viewed the edits back in ArcGIS. So, there would be no need to export GDB to shp or vice versa because the basic feature types supported by shapefiles are going to be editable in QGIS in the FGDB or PGDB. Your advanced feature types like annotation are where you become limited. Use of those will tie you more to the ESRI universe, which is not good or bad, just something to be aware of.
Dec
17
comment ArcGIS and QGIS compatibility: issues with Shapefiles or Geodatabases?
It really isn't a matter of whether ArcGIS and QGIS play nice together. It is a matter of what data formats you choose to use. This is where you run into differences in support between the two software packages. Shapefiles are universally editable. Others, like File or Personal GDB, are editable in both, but not all feature types are supported. Others, like PostGIS/PostgreSQL without SDE, are editable in one, QGIS, but only viewable in the other, ArcGIS, through a query layer. It depends on what your end uses are as to what combination is going to be more appropriate for you.
Dec
16
reviewed Approve QGIS Select overlapped feature
Dec
15
comment name 'row' is not defined error appears overnight
Just to be clear with your testing. You said you tested it on 3 machines, all with ArcGIS 10, and it worked on one of them. Do they all have the same flavor of ArcGIS 10, and one of them doesn't accidentally have 10.1 or 10.2? Not sure if it makes a difference, but narrowing it down to apples to apples always helps.
Dec
15
reviewed Reopen Store GPS trace with timestamps, then interpolate location by time
Dec
15
reviewed Leave Open Syntax error using ArcPy Spatial Analyst module in Python
Dec
11
comment PostGIS 1.5 Errors with PostgreSQL 8.4
Here is the documentation for upgrading a PostgreSQL cluster. I would read through this as it gives pretty good direction. What might have to happen, since you are a couple of major releases behind is that you would have to upgrade in stages. Set up a 9.0 cluster and upgrade to that, then jump to the current release. As they say in the documentation though, they definitely recommend upgrading as opposed to not even though it may be challenging. Upgrading PostgreSQL
Dec
11
comment PostGIS 1.5 Errors with PostgreSQL 8.4
I am glad you found the solution. I meant to ask though, why you are installing this version of PostgreSQL/PostGIS as opposed to the current version which is PG 9.3/PostGIS 2.1?
Dec
11
comment Geocoding Result layer does not show up in ArcMap?
Welcome to GISse! I think in order to be able to help you more effectively, you need to provide some more explanation of what you are doing, and the steps you have taken so far. You are geocoding addresses. What are you using as your geocoding base layer? What is the base layer you are overlaying the roads and addresses on? What are the coordinate systems of each? What is the coordinate system of the data frame? Geocoding parameters? It is detail like this that will help other people give you advice or guidance to work toward an answer.
Dec
10
comment Cannot see line made with PostGIS ST_MakeLine() in QGIS
Could you paste in some of the records from your source table? I think it might be a problem with the records not grouping properly to form the lines. How many records are in your source table, and do you have any expectation of the number of lines you expected to create?
Dec
10
comment Cannot see line made with PostGIS ST_MakeLine() in QGIS
I am still not sure about the view working. What you have shown as a printout of records is a select * from your original table limit 1. All this does is select one of your GPS records and return that. You should try a simple query in Postgresql for SELECT * FROM line01 LIMIT 1 and see if that returns anything. Doing a grouping by time somewhat concerns me as even a slight variation there is going to mean that the records won't group. Can you include more records from your source table? Let's look at that and go from there.
Dec
9
reviewed Approve idw tag wiki excerpt
Dec
9
comment Cannot see line made with PostGIS ST_MakeLine() in QGIS
In the Add PostGIS Table(s) window, is your layer listed as a geometry layer, with the correct column shown as the geometry column, the data type showing as geometry, and the spatial type and SRID all defined? Also, have you looked at the view in PostGIS to see that it is actually returning any records, and not simply an empty table?
Dec
9
reviewed Leave Open Extracting metadata from shapefile in FME?
Dec
9
reviewed Approve How to get multiple dynamic custom markers on map using MapBox in MySQL and PHP?
Dec
8
comment Changing workspace path of query layer using ArcPy?
I'm not sure how to test this, but what if the problem is with the mxd itself. It may not be a bug, but may be planned. There are some cases in the mxd, where if something changes with a layer, it clears other settings. The example that jumps to mind is symbology. If you have symbology set based on an attribute and change the attribute, it clears the symbology even if the new field contains the same data. It could be that whether by plan or by accident, when the workspace is changed, query layers clear the setting which specifies the Object ID field. Have you asked ESRI about this?
Dec
6
revised Installing Data Interoperability when already authorized on ArcGIS Administrator?
Add additional explanation
Dec
6
comment Troubleshooting a few missing shapefiles on Google Fusion Tables
I want to clarify terminology to make sure we are on the same page. The first part of your question references multiple shapefiles. The zip file and data layer you reference is actually a single shapefile. It contains multiple polygons, each of which represents an election precinct. Finding out if that shapefile contains the listed precincts is a matter of loading the shapefile into QGIS and searching the attribute table for each of those numbers. If they show up, that indicates a different issue. The QGIS help document has good instructions for loading and viewing shapefile data.
Dec
6
comment Points In Attribute Table Will Not Display In Data View
@ChrisW - +1 for your idea of bringing the shapefile into a blank ArcMap document. Often when there is some spatial reference conflict, you can have a perfectly valid spatial layer, regardless of format, but it will not show up when brought in to a data frame containing other layers which all have defined spatial references. If you have no luck in ArcMap, you might try opening it in QGIS, which can be more forgiving of quirks in shapefiles than is ArcMap.