4,801 reputation
1614
bio website
location
age
visits member for 1 year, 2 months
seen 28 mins ago

17h
revised Excel Table Objects get invisible and lose data after re-opening map
loose -> lose
2d
comment Rename long column names for dbf conversion
There is no standard naming convention to make longer than ten character names fit within 10 characters (short of truncate, then use digits if there's more than one). Anything clever would require human intervention (and an understanding of the domain in which it was deployed). Personally, I'd recommend avoiding shapefiles for database export, since it's not only the names that get mangled, the datatypes and values do as well.
2d
comment Is there a performance difference between SQL Server 2008 and 2008 R2?
What version of ArcGIS are you using? What geometry storage type are you using? Even if there is no performance benefit, the native geometry implementation at R2 is probably better, and you're more likely to have compatibility with modern ArcGIS releases. As a rule, the best way to find out if you'll have a performance improvement is to benchmark a representative sample in both releases on a test host under identical load; it's the only way to be sure.
2d
comment How to find the overlap of two buffer polygons?
What software are you using? (please update the question) Why are the VFDs only ~1km apart?
2d
comment Shapefile name specific failure with Append in ArcGIS 10.2
In what OS environment are you running each of these tests? (please edit the question)
Oct
27
comment GIS software recommendation
Could you please spell the Esri software correctly? It's also only one GIS platform. There are other GIS solutions besides ArcGIS and QGIS.
Oct
27
comment Converting ASCII file to shapefile in ArcGIS Desktop?
What do you mean by "not working"? Please edit the question to describe the error.
Oct
25
comment Spatial search performance on a collection of Points in a PostGis database
A table that large will be subject to spatial fragmentation performance issues. You should make sure the table order is clustered, such that drawing all features fills in bands from left/right to top/bottom or top/bottom to left/right. The performance difference, vice random distribution, could be measured in minutes.
Oct
25
comment Are there naming rules for direct connections from ArcGIS to PostgreSQL?
Underscores should be valid, but hyphens will be interpreted as subtraction (best possible case) or a syntax error.
Oct
24
comment Are there naming rules for direct connections from ArcGIS to PostgreSQL?
In the database name? No, that's not a valid SQL identifier. ArcGIS doesn't add oodles of quotes in every statement to trap for invalid characters.
Oct
24
comment where is the sequence in Oracle associated with the Objectid field in ArcGIS, and how to manage it?
Command-line was deprecated at 10.2, and will be unavailable at 10.3. You could certainly install the application server binaries for this, or just register with geodatabase. BUT, accessing the sequence may not help. If you intend to load these tables outside of ArcSDE's ken, you should not register an SDE-set rowid -- Instead, create and maintain your own sequence.
Oct
24
comment where is the sequence in Oracle associated with the Objectid field in ArcGIS, and how to manage it?
No, it is not. A table is only registered with ArcSDE if you have used 'sdetable -o register' on it, or have right-clicked "Register with geodatabase". If you are offered the latter, then it hasn't been done previously. ArcGIS isn't going to spontaneously register tables; you must proactively do so.
Oct
24
comment Are there naming rules for direct connections from ArcGIS to PostgreSQL?
I connect to servers with hyphens in the name all the time. I think you need to provide more detail.
Oct
24
comment where is the sequence in Oracle associated with the Objectid field in ArcGIS, and how to manage it?
Has the table been registered with ArcSDE? Is there an SDE-set registered rowid?
Oct
23
revised Will ArcGIS 10.1 run on the new windows 10 technical preview?
differing product bewteen title and body
Oct
23
comment Will ArcGIS 10.1 run on the new windows 10 technical preview?
It will likely run, but can't possibly be supported before final Microsoft release. It's possible that only 10.2.2 and 10.3 would be certified.
Oct
23
comment Combining duplicate points while preserving their associated attributes
No, I mean a database (SQL compliant; e.g, PostgreSQL)
Oct
23
comment Combining duplicate points while preserving their associated attributes
If it's sent in CSV, you have complete control over how the tables you use are laid out; you just need to come up with an import sequence to support it. Do you have access to a database to do the manipulation? It changes potential answers.
Oct
23
comment Combining duplicate points while preserving their associated attributes
The way to accomplish this in a relational database is to avoid compound fields and use two tables, Stops and Stop_Tasks, with a one-to-many relationship and a view that sums the task times. ArcGIS has two different options to implement 1:M relationships. resources.arcgis.com/en/help/main/10.1/index.html#/…
Oct
23
comment ERROR: operator is not unique: unknown || geometry
Please edit the question to provide some context -- What are you tying to do? What software are you using, on which operating system? What version are you using? What data layers are involved?