7,653 reputation
22147
bio website getspatial.com
location San Diego, CA
age 38
visits member for 4 years, 2 months
seen yesterday

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.


1d
comment Is there a solution to glitches when deleting features from Shapefiles on network drives?
Did you place a comment on the bug asking developers for help as well?
1d
comment Should I be able to open personal DB converted to MSSQL as a MSSQL Layer?
Someone kindly led me to this question that is likely the source of your difficulty, and the solution: Opening Esri Personal GDB using QGIS 2.6
Apr
23
comment Should I be able to open personal DB converted to MSSQL as a MSSQL Layer?
ESRI Personal GDB is directly supported by QGIS through the OGR, no need to convert to MSSQL.
Apr
22
comment PostGIS and Mobile Devices Maps
PostGIS is merely an extension to Postgresql, a database, that enables it to recognize spatial data. How the spatial data is structured within the database, is completely up to you. This structure may include the types of spatial data, the attributes, and perhaps most importantly in your case, the projection and units that the spatial coordinates are stored in. These are all things that you will define before loading data into the database. This structure should be guided by your proposed use for the data, ie, interacting with an Android device, etc.
Apr
22
comment How to read ESRI File Geodatabase (FileGDB) with OGR?
Where did the file come from? Do you know what is supposed to be in the file? If it is a FileGDB, do you know what version it is? This may make a difference. What system are you using? How did you install GDAL? You should upgrade to the latest version of GDAL. Basically all of my questions lead to the point of you needing to add more detail to your question to handle some of the possible variables. The more detailed information you can provide, the better your chance of getting a good answer.
Apr
21
comment Trajectory / ballistics
I may be making this unnecessarily complicated, but I feel like you are overlooking a couple of critical variables here. Distance for a given load is dependent on the velocity and angle of launch. Essentially the amount of charge your canon has, and the angle of the muzzle. To simplify, given a fixed charge, or launch velocity, your load will travel farther horizontally at a lower launch angle. High launch angle clears taller obstacle, but has to be closer horizontally to target. How are you planning to control for those variables?
Apr
21
comment Using ArcGIS, can data relationships be created between separate geodatabase containers?
In order to build relationships in ArcGIS, you need 2 things. First, you need spatial data. Second, you need attribute data with some link to the spatial data. If you want to build relationships between pure attribute data, you need to have at the very least, a common Unique ID. If you don't have this, you don't have a relationship between data. If you don't have a common ID link, the most you can do is link tables from each DB to spatial data, and see if there is a spatial overlay relationship. If this explanation is not on the right track, please clarify your question.
Apr
21
reviewed Approve Using ArcGIS, can data relationships be created between separate geodatabase containers?
Apr
15
comment File GDB Edits Never Written to Database
I don't know if there is a definite answer to your question to say when you can tell if this is happening. The fact is that if a layer is being pulled from a file gdb and the connection to that gdb is lost, anything that takes place after that time is going to be suspect. I am surprised that you were even able to reference the layers if a reboot or network connection disconnect did occur. It could be that because you had an edit session open, the layers were being held in memory to allow for undos. Once the first disconnect happened though, likely no further communication with fgdb.
Apr
14
comment Finding the coordinate system for LiDAR points
Great! I realize that I forgot to include the units which does make all the difference.
Apr
14
comment Finding the coordinate system for LiDAR points
Which datum did you use? 1927 or 1983? The coordinates you listed would seem to indicate they are State Plane Zone II North American Datum 1983.
Apr
9
comment GIS Equipment for 911 Call Center
Where are you located? Have you gotten in contact with, assuming they exist, your local city or county GIS staff? They may very well have some of what you are looking for, and collaboration could save effort and improve the product for both parties.
Apr
8
awarded  Popular Question
Apr
8
awarded  Notable Question
Mar
13
awarded  Necromancer
Feb
11
comment Formatting Date Label in ArcMap
Is your field a date format field, or a text field?
Feb
2
awarded  Yearling
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.