Latest Contributions by yockee

Hi, I want to migrate from EGDB Sql Server into EGDB Postgresql. Here is the condition: - EGDB Sql Server (non versioning) reside on VM. The size of the EGDB is not large, only 50GB - EGDB Postgresql will be on the cloud Questions: 1. What are the considerations I should take ? Is copy feature class to feature class suffice enough ? 2. There are BLOB fields containing photos. Will it be a smooth copying (say, using Export or Import tools or maybe feature class to feature class) between different databases ? 3. How can I do this in the quickest and most correct way possible ? Thanks   ... View more

Hi, I am in the middle of migration from VM hosted on-premise to Cloud. There are 2 cloud candidates that we are considering: AWS and GCP. We are considering clouds because we are under assumption that the geodatabase has to be placed on a shared drive / clouds to enable multiuser concurrent editing. I have read here that there are some kind of "limitation" on performance about geodatabase on cloud.  We want to place the enterprise geodatabase on cloud (either AWS or GCP, depending on the suitability and price) and then access it from local client. The editing of data are pretty simple: no versioning required, no replication, some topology, geometric network, simple cross section analysis and joins with another data source from local database will be involved. And the rest is pretty much straight forward, simple editing of object and attributes. The size of the whole geodatabase is not big, merely 30 GB - 50 GB max. The editor personnel are only 5 - 7 people maximum. Now, this is what I want to propose based on our need: - ArcMAP 10.8.2 (which will be discontinued in 2 years time). This is because I do not really need enterprise geodatabase. The concurrent multiuser editing can be done by running some trickeries like here. But, due to licensing limitation / policy from Esri, may be I am forced to propose this: - ArcGIS Pro with named licensing (this requires Portal) - ArcGIS Server Standard (because the named licensing requires Portal) I want to avoid using ArcGIS Server Standard because at the moment we don't need it. May be sometimes in 2 years we will need it. And I do not need Cloud as well because I just can use file geodatabase on shared folder. the FGDB is suffice enough to cover our needs. Any suggestion about which recommendation I should follow ? Is my proposal about using ArcMap only good enough ? Personally, considering our needs, I want to avoid using cloud and I do not need ArcGIS Enterprise Standard. Any comments or recommendations are welcome. Thanks. ... View more

please help me to understand. What are the differences between the indexes Axxx_IX1 and Sxxx_idx$ ? The Axxx_IX1 can be seen using this query : SELECT * FROM dba_indexes WHERE  table_name = 'your_feature_class'; Here it says that Axxx_IX1 has Index_Type of  "domain". The Sxxx_IDX$ can be found using : SELECT * FROM sde.st_geometry_columns WHERE table_name = 'your_feature_class' --where xxx is the GEOM_ID colomn.  To see both of them : SELECT table_name,index_id,srid,grid,status,index_name FROM sde.st_geometry_index WHERE table_name = 'your_feature_class' . From this article it says INDEX_NAME is Name of the st_spatial_index (domain index). So I think they are different. But I do not understand the differences and when the A and S indexes are used. Help please. ... View more