6,603 reputation
21440
bio website getspatial.com
location San Diego, CA
age 37
visits member for 3 years, 2 months
seen Apr 13 at 9:09

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.


Apr
2
comment How to get “.GDB” (Esri File Geodatabase) support in Quantum GIS (osgeo4w - qgis)
@danagerous - This answer was written when QGIS 1.8 was the current install version. As you have shown, the current version is now up to 2.2.0. The process and steps to ensure that the library is installed remain the same, but you would always want to use the most current version available for both QGIS and the gdal-fgdb library.
Apr
1
comment Is there an online source of raw contour data?
It is worth noting that in addition to having a layer of the contour lines, this site allows you to download a DEM. I would venture that there are more areas where a DEM is available, than there are areas where the actual contours have been generated. The DEM can then be used to generate contours at a chosen interval, using your preferred GIS package.
Apr
1
comment Problem opening shape file in qgis
@Vince - Unfortunately, even if you are able to recreate an .shx file that is correct regarding record numbers, the data may still be corrupted. This is because the components of a shapefile are editable by more than just software which treats them as a whole. The .dbf may be edited in Excel. Any sorts that are performed and then saved will change the records associated with a particular record number. So, while it may be possible to recreate an .shx file and gain access to a shapefile in some software, it is no guarantee of the integrity of the data.
Apr
1
comment Problem opening shape file in qgis
possible duplicate of How do I load a .dbf file into QGIS?
Mar
27
comment Inserting union of two tables into another table Postgresql
Your initial problem is of syntax. You have the geom referenced with the destination table. In the values section, however, you are listing 3 different columns. The references to the spc as a, and simple_us as b should be in a subquery to the `ST_Union command. This is in addition to the information that @Mapperz provided.
Mar
25
comment Create an X,Y latitude and longitude grid from an raster
I think there is a bit of confusion in your terminology. A LandSat image, IS a raster image. Each pixel in the raster represents a return value from the ground, located with an x and y coordinate. What is your project? Having a bit more detail about what you intend to do with the raster, may help figure out the operation you actually want to perform.
Mar
18
awarded  Good Answer
Mar
14
comment How to get “.GDB” (Esri File Geodatabase) support in Quantum GIS (osgeo4w - qgis)
@jeff - This process should be essentially the same for the current versions of the OSGeo4W installer, QGIS and the File GDB support. As Peter's comment above suggests, version numbers have changed, and the type comes up as a default for the "Directory" source type now. Other than that, should be relevant. Now that it has been a while, drop a comment if it worked for you, or if you had a problem.
Mar
12
reviewed Leave Closed Buffer is giving me a different distance
Mar
12
reviewed Leave Open Live XML Truck Fleet GPS Data To ArcGIS
Mar
12
comment Why can't I perform any operation over a 700MB MIF file containing 5 multipolygons? It takes forever
I suggest this only because it is entirely possible for a layer that is extremely large in one format, like MIF, to be much smaller in the PostGIS database simply because of the way that the data is encoded in one format vs the other.
Mar
12
comment Why can't I perform any operation over a 700MB MIF file containing 5 multipolygons? It takes forever
Just to clarify, did you load the file into PostGIS, with the resultant table being 160MB? You suspect that something went wrong, but have you actually tried to load the new layer from PostGIS into QGIS, for example, and see if it comes up? Also, it wouldn't hurt to provide some more detail about the features in the layer, source of the data, etc.
Mar
7
comment Hydrology toolbox versus ArcHydro toolbox
More current information is available at the ArcHydro forum on the ESRI website: forums.arcgis.com/forums/88-Arc-Hydro
Mar
5
comment Hydrology toolbox versus ArcHydro toolbox
ArcHydro is built as a schema and interface on top of the Hydrology tools. There is effectively no difference in the way the tools work, except that the ArcHydro toolset is standardized, and documented and has quality checks throughout it. That is where the added functionality comes in over the Hydrology toolset.
Feb
13
comment Creating Parallel Road Lines
This question gives you a couple of options for how to approach this from a pythonic perspective. gis.stackexchange.com/questions/21520/…
Feb
13
comment QGIS layer only displays when I uncheck on-the-fly transformation
What format is this layer in? The projection information you are showing looks like there is an error in the definition. When you bring the layer into QGIS as the only layer, what are the x and y coordinate ranges that are shown? When on-the-fly is checked, what direction is this layer offset from the others you have loaded? Providing more details about the layer and coordinates you see in it already, will help diagnose the problem.
Feb
10
reviewed Leave Open How to get tiff file of project limits at specific scale using QGIS 2.0?
Feb
5
awarded  arcgis
Feb
2
awarded  Yearling
Jan
24
comment Why does reading shapefile from PostgreSQL database give Error reading OID from table …?
Please detail the process you are using to add the query layer. There are a couple of spots where the process of adding the layer sometimes selects more than one column as a unique identifier. This may be what you are running up against.