|
POST
|
If you actually trace the SDE API calls, you'll see it's not the connecting, per se, but the need to inventory the objects present so they can be symbolized in the UI. There are queries to list tables, and feature classes, and feature datasets, and rasters, and raster datasets,... Then for feature classes, the geometry type needs to be queried, so the right icon is used. So yes, thirty seconds is not completely unreasonable for 700 tables.
... View more
07-16-2021
08:18 AM
|
2
|
0
|
2700
|
|
POST
|
This isn't likely to be a tiny task. These forums aren't really geared to tasks that would take an experienced developer weeks to complete. They're usually for more immediate problems which can be addressed in a paragraph or two. We can help you if you work at it and get stuck, but you'll need to come up with a plan and start to see it through. The alternative is to contract with someone to code it for you, but I usually don't get involved at that level. - V
... View more
07-14-2021
01:50 PM
|
2
|
0
|
3027
|
|
POST
|
While theoretically possible, a great deal would depend on the exact format of the file. - V
... View more
07-12-2021
01:53 PM
|
1
|
2
|
3057
|
|
POST
|
There are some times when the 'sde' login needs advanced privileges (install/upgrade on other than RDS), but other than that, there shouldn't be any problem with plain vanilla user privs. - V
... View more
06-23-2021
10:28 AM
|
2
|
0
|
2045
|
|
POST
|
Maintaining an open arcpy.ArcSDESQLExecute cursor would probably accomplish the same thing.
... View more
06-23-2021
07:39 AM
|
1
|
0
|
2723
|
|
POST
|
Poison starfish (if I can't run PostgreSQL on coconuts with vines and ferrous rocks for cores). - V
... View more
06-23-2021
07:36 AM
|
2
|
0
|
2495
|
|
POST
|
My (hazy) memory was that they were in the INFO file, and could be edited, but would be clobbered by the next BUILD or CLEAN. - V (Since 4.01/5.0-beta)
... View more
06-22-2021
02:28 PM
|
1
|
0
|
2532
|
|
POST
|
18791 days after 01-Jan-1970 isn't likely to be 19-Jan-1970; perhaps you used a converter based on milliseconds, and you need to multiply by an additional 1000? - V
... View more
06-17-2021
07:39 AM
|
0
|
1
|
18125
|
|
POST
|
The SQL looks good, though making the 'sde' login the owner isn't best practice (the 'sde' login should be treated as an administrative account, used only when absolutely necessary, and never to own geodata). - V
... View more
06-13-2021
06:48 PM
|
0
|
1
|
2887
|
|
POST
|
In ArcGIS parlance there's a difference between a "GlobalID" and a "GUID". Both utilize UUID field types, but a GlobalID is a primary key ("GlobalIDs uniquely identify a feature or table row in a geodatabase and across geodatabases."), while a GUID is a field that utilizes the native UUID datatype (possibly referencing a GlobalID in a different table). There are many ways to manifest a GlobalID as a GUID in a table, but the details vary depending on the storage types of the table sources. If both are in a single Enterprise geodatabase instance, the UPDATE is as easy as the supporting RDBMS permits cross-table joins to be. If you're using file geodatabase or a number of different data sources, then the tools that support this are limited (but there are still multiple ways). Ironically, as good as the UUID type is for distinguishing unique records, it is large and inefficient at that task; integer types make for much more efficient storage and comparison in very-large tables. How "standalone" is your standalone table? How large are the tables (in rows)? What data source(s) are you using? What have you tried? - V
... View more
06-10-2021
12:20 PM
|
0
|
5
|
2914
|
|
POST
|
No, no, no! Don't use shapefile to transfer data between SQL databases -- It will corrupt any numeric NULLs, datetime or string data exceeding 254 width (not to mention all field names in excess of ten characters). File geodatabase was designed to support all the types likely to be found in either database. Note that there could be reserved word issues to resolve after export but before import. - V
... View more
06-04-2021
10:45 AM
|
2
|
0
|
1712
|
|
POST
|
I've seen anecdotal evidence that PG 13.x (with PostGIS 3.1) can be used in a database connection from Desktop (as a non-geodatabase, without EnableEnterpriseGeodatabase) , but that this connection can't be registered with an ArcGIS Server 10.8.1 instance. When the user switched to PostgreSQL 12.6, there was no difficulty registering the connection.
... View more
05-10-2021
08:36 AM
|
0
|
1
|
3977
|
|
POST
|
Shapefile is dreadful for this purpose, since it doesn't support the feature dataset container that supports networks. File geodatabase is really your only option. - V
... View more
05-03-2021
11:09 AM
|
2
|
0
|
1856
|
|
POST
|
Legal questions like this are best asked of your lawyer, or by your lawyer to Esri's laywers. Asking strangers on the Internet is worth less than you pay for it (and does not absolve liability), but it seems that your use does not meet the "for free" criteria, and therefore such use would violate the Esri TOS. - V
... View more
05-03-2021
09:37 AM
|
0
|
0
|
3684
|
|
POST
|
You know how it works. Only Development makes promises about future development, and Support reports the supported environments. Even if I knew the plan (and I don't), it's not my place to say more than, "It ain't there yet." My problem was with a PG 11.8 to PG 11.9 transfer, where a geodatabase upgrade wasn't available, but the OID support was corrupted by the export -- pg_dump actually corrupted the geodatabase before the PG 12 support geodatabase changes could engage. - V
... View more
04-29-2021
08:57 AM
|
0
|
0
|
4037
|
| Title | Kudos | Posted |
|---|---|---|
| 2 | 3 weeks ago | |
| 1 | a month ago | |
| 1 | 4 weeks ago | |
| 2 | a month ago | |
| 2 | 05-22-2026 04:57 PM |