|
POST
|
It's clear why the DBA team would restrict DBA access to GIS administrators. It's also clear why GIS administrators would keep the SDE password away from DBAs. It's not clear why the GIS administrator doesn't have SDE user access. This is a clear violation of SLA (Service Level Agreement) protocol. Note that the SDE user should not have DBA privileges (except during upgrade, and then only briefly), so there really isn't any reason for the DBAs to restrict that account. 'SDE' should only be used for enterprise geodatabase administration, which is why it's clearly in the GIS admin responsibility zone. Even if the extra account works perfectly for the most frequent procedures, it's not safe to assume that it will work for all required operations, and the extra work and risk doesn't seem worth the limited gain. - V
... View more
03-15-2021
06:18 AM
|
2
|
0
|
3407
|
|
POST
|
Good call. The intertubes says the "SQLSTATE=42601" error is associated with IBM DB2. - V
... View more
02-26-2021
05:24 PM
|
1
|
0
|
3194
|
|
POST
|
Getting folks to download a Microsoft file format with security challenges to review your data could result in low participation. Providing an ASCII table in a code block would get more viewers. Note that Esri and Microsoft (and the other RDBMS vendors) have different definitions of valid geometry (at times), so using Esri tools like Check Geometry might be required to confirm data integrity. I transfer tens to hundreds of millions of records between FGDB and PostgreSQL quite frequently without data loss, so I wonder if there's something specific about the data that you are using. Have you tried to identify common properties in the dropped data? (One way would be to pass the preserved unique key values back into the database, then create a LEFT OUTER JOIN where the returned keys have a NULL value.) -- V
... View more
02-22-2021
02:25 PM
|
0
|
1
|
3907
|
|
POST
|
There are no spatial operators in the basic SQL supported on file geodatabase, so no, that is not an option. It would be an option in a true database source. - V
... View more
02-21-2021
04:20 PM
|
0
|
0
|
6277
|
|
POST
|
No, Esri libraries are not going to update the database tables when they aren't used. You'd need to write your SQL trigger to also update the last_editor and last_update. Getting triggers to play nice with versioning seems an opportunity for "bleeding edge" experimentation. - V
... View more
02-12-2021
03:18 PM
|
1
|
1
|
2483
|
|
POST
|
> I've never seen the updating of an attribute field result in the changing of the geometry of a feature. But you didn't change an attribute field, you changed the geometry. There's no way for SQL to rewrite the CAD BLOB, so the CAD data is lost. - V
... View more
02-05-2021
07:01 AM
|
0
|
1
|
2315
|
|
POST
|
I connect to PostgreSQL RDS databases all the time, however, I *NEVER* connect as the postgres login. I suggest you create a data ownership login and try connecting as that. You should make sure that you have enabled the postgis extension in the database, and that the database name is all lower-case (which would give a different error). - V
... View more
01-24-2021
08:32 PM
|
0
|
2
|
3583
|
|
POST
|
It's been ages since I last used 9.3.1, which has been out of support over seven years now (it's so different from modern releases it might as well be a different product). There isn't nearly enough information here to begin to speculate about what could be the problem. Among the details missing: RDBMS in use (exact version) Definitions of the tables involved in the query The exact SQL to create the view The exact parameters (except password) used in the sdetable commands An indication of the cardinality of the joins Example output An indication of the uniqueness of the registered rowid column Working with ancient software is a considerable risk to your organization. I recommend you migrate your data to a modern software stack (supported OS, DBMS, and application stack). - V
... View more
01-23-2021
09:30 PM
|
2
|
0
|
2852
|
|
POST
|
Low hanging fruit on file geodatabase query performance includes: Making sure the dataset is on a local device (not a network-mounted drive) Periodically rebuilding the spatial index Building attribute indexes to cover query terms Spatial queries on badly fragmented datasets can also take a long time, even with a fresh spatial index. I use relational databases, not file geodatabase, to juggle tens to hundreds of millions of rows, and I always make sure my data is physically organized from left to right and top to bottom in chunks (e.g., countries by UTM Zone and MGRS tile; counties by state, from west to east). The same physical ordering options are available for file geodatabase as enterprise, but they're rarely as necessary in the smaller table sizes (under 100-200k rows). Tech Support can be of use with modern software, but when using something ancient you'd need to test against something modern to see if it's already been addressed. - V
... View more
01-22-2021
10:44 AM
|
0
|
0
|
2910
|
|
POST
|
ArcGIS 10.1 was retired from support over three years ago. The current release is 10.8.1. Your issue may be release independent, but there's really no way to tell, since you haven't mentioned data format, indexing, data volume, or actual timing (in seconds). Please help us to help you by including enough details to make an answer possible. - V
... View more
01-15-2021
09:13 AM
|
1
|
2
|
2981
|
|
POST
|
The REST endpoint provides all the data. Any client which can emulate the client app's request protocol can get that data. You could harden the endpoint in front of the Web Adaptor's servlet engine, but it might not take a lot to engineer around that (especially if a concerted effort was made), and there might be a significant performance cost. If you want to protect the back-end database, you might stage a publishing database (or FGDB folder), which is effectively read-only, in the DMZ to prevent the risk of tampering. I'm afraid this might be a "Doctor, doctor, it hurts when I do this!"/"Don't do that." situation - V
... View more
01-08-2021
11:13 AM
|
0
|
1
|
1567
|
|
POST
|
Are you editing the hosted data or the source of the Enterprise feature class used to create the hosted data? You can publish a map/feature service which accesses the Enterprise geodatabase feature class directly, but the "hosted" part of the name generally indicates that the federated DataStore is now managing the data, not the original source geodatabase (at least, with respect to the hosted service), which would correlate to the behavior you are seeing. - V
... View more
01-05-2021
12:03 PM
|
0
|
1
|
6400
|
|
POST
|
Yes, the ArcMap docs for 10.7 should correlate to ArcGIS Server 10.7. According to the Enterprise docs, Python 3 was available on Linux at 10.5, and this blog indicates that all of Server has Python 3 support (I haven't used this functionality). - V
... View more
12-16-2020
05:48 AM
|
1
|
1
|
6040
|
|
POST
|
You could generate a view or SQL query using Query Layers which includes ST_X and ST_Y function calls (the usage for which varies by RDBMS implementation). Since "LONG" is reserved in some databases, I recommend using "LON" to pair with "LAT". -- PostgreSQL geometry/geography
CREATE VIEW mypoints_w_coords AS
SELECT objectid,colA,colB,ST_Y(shape) as lat,ST_X(shape) as lon,shape
FROM mypoints;
-- ORACLE SDE.ST_GEOMETRY
CREATE VIEW mypoints_w_coords AS
SELECT objectid,colA,colB,SDE.ST_Y(shape) as lat,SDE.ST_X(shape) as lon,shape
FROM mypoints;
-- SQL Server geometry/geography
CREATE VIEW mypoints_w_coords AS
SELECT objectid,colA,colB,shape.STY as lat,shape.STX as lon,shape
FROM [myschema].mypoints; Note that some elements of geodatabase functionality aren't available with views, so processing the geometry in the client as with Arcade is probably a better solution.
... View more
12-16-2020
05:24 AM
|
2
|
0
|
4082
|
|
POST
|
No, ArcPy is different between the Python 2.7 and Python 3 releases. ArcGIS Pro (Python 3) is the focus of new development, so it has more functionality than the ArcMap/ArcCatalog/ArcGIS Server (Python 2.7) flavor (besides the new Pro-specific mapping interfaces). The Pro release also bundles the ArcGIS API for Python, which provides easier access to some AGOL/Portal functionality (Enterprise).
... View more
12-16-2020
04:57 AM
|
2
|
4
|
6051
|
| Title | Kudos | Posted |
|---|---|---|
| 2 | 3 weeks ago | |
| 1 | 05-29-2026 12:51 PM | |
| 1 | a month ago | |
| 2 | 05-29-2026 08:31 AM | |
| 2 | 05-22-2026 04:57 PM |