|
POST
|
Hi Vince, I do not quiet get this statement "...and populate the contents of the new table(s) via INSERT INTO newtableN(columnlist) SELECT columnlist FROM temptableN. " Did you mean: create an empty FC first and then load the data with INSERT INTO query. Thanks
... View more
02-16-2023
05:57 PM
|
0
|
2
|
4269
|
|
POST
|
Hi George, Questions: - Why are you looking at cloud if you say "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."? --> I was advised by the IT team that now we will be using cloud. I am aware the consequences if the arcgis geodb is put on cloud, notably the performance drawbacks. But I am going to use this pattern: put the db on cloud, and download it on to the local client for editing. Then put it back again to cloud. Make sense ? Or maybe, I can use two-way-replication between cloud egdb and local egdb (or may be even one way replication with the local egdb acting as primary). Is it worth trying ? Any other consideration ? - Is your organization trying to save money on storage? --> I might say "yes". thanks for the advice
... View more
02-16-2023
04:48 PM
|
0
|
1
|
2338
|
|
POST
|
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
02-13-2023
07:23 PM
|
0
|
3
|
2405
|
|
POST
|
Hi, sorry I was wrong. It turns out that I have ArcMAP 10.5. so, how do I run that piece of code on ArcGIS Pro ?
... View more
02-05-2023
08:11 PM
|
0
|
1
|
1819
|
|
POST
|
Hi, I used to be able to run this geoprocessing using ArcMap 10.5 against Oracle 12 Database : import arcpy arcpy.AnalyzeDatasets_management("D:/path_to_connectionfile/dbspatial.sde", "SYSTEM", ["xxx";"xxx"],"ANALYZE_BASE", "NO_ANALYZE_DELTA", "NO_ANALYZE_ARCHIVE") Now the database has been upgraded to Oracle 19 and I can not connect to geodatabase anymore using ArcMap 10.6. The only way I can connect is by using ArcGIS Pro. But I am very unfamiliar with its layout. I want to do the geoprocessing above or may be there are any equivalent format to achieve the same thing. I can connect to the geodatabase just fine but I just have not find a way to run that geoprocessing. Need your help and advice
... View more
02-04-2023
04:23 PM
|
0
|
3
|
1875
|
|
POST
|
Thanks. Nice insight. But, how come I find the Axx table even though it's not registered as versioned ? Maybe it **was** registered as Versioned before and now it's not. Is it possible?
... View more
12-11-2022
08:00 PM
|
0
|
1
|
2864
|
|
POST
|
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
12-08-2022
11:55 PM
|
0
|
5
|
2914
|
|
POST
|
I read here. It says : "A feature class created using ST_Geometry storage with a spatial index creates an additional table within the Oracle database. The spatial index table is named S<n>_IDX$, where <n> is the geometry index value for the table. The value can be obtained by querying the SDE.ST_GEOMETRY_COLUMNS table. The spatial index table is created as an Oracle Indexed Organized Table (IOT). The spatial index on the ST_Geometry attribute appears as A<n>_IX1 when viewed through Enterprise Manager. The value of <n> represents the LAYER_ID value stored in the LAYERS table." Based on that article, so I am thinking that those 2 indexes are actually the same. Am I wrong? But I think , the A<n>_IX and S<n>$_IX are 2 different entities. Index "A<n>_IX" can be found on "dba_ind_columns" whereas the "S<n>$_IX" can be found on "user_indexes" The A<n>_IX can not be moved straight away. It has to be dropped and then recreate. But still the tablespace_name shows NULL. Whereas the S<n>$_IX can be moved straight away using ALTER TABLE "S<id>_IDX$" MOVE TABLESPACE NEWTBS1; Should I move both the A<n>_IX and S<n>$_IX ? And moreover, the Feature Class is not registered as versioned. I am just confused and still learning to understand it fully. Please pardon me.
... View more
12-08-2022
08:19 PM
|
0
|
1
|
3330
|
|
POST
|
UPDATE: It turns out that the default tablespace name is always NULL. Interesting ! Here is what I do : - Observe the original tablespace : SELECT * FROM user_indexes where index_name = 'A346_IX1' --the tablespacename = NULL - Drop it : DROP INDEX A346_IX1 FORCE; --success - Recreate it : CREATE INDEX SDE.A280_IX1 ON STREET(SHAPE) INDEXTYPE IS sde.st_spatial_index PARAMETERS('st_grids=1,3,0 st_srid=32748 tablespace NEWTBS'); --success - Observer again once more : SELECT * FROM user_indexes where index_name = 'A346_IX1' ----the tablespacename = NULL too The result of the 2 observations are EXACTLY THE SAME. Question 1 : But why the default tablesapce is always NULL? Where are all the spatial indexes are stored then? Moreover, I read article here : https://support.esri.com/en/technical-article/000009505 . It says that the spatial index's name follows this pattern : S<geom_id>_IDX$. If I follow this, then my feature class has spatial index name : S1244_idx$. So, now I end up with 2 spatial indexes : A346_IX1 vs S1244_idx$. Question 2 : Which one is the correct spatial index ? Then I change the tablespace location using : ALTER TABLE "S1244_IDX$" MOVE TABLESPACE NEWTBS; ---success Check if it works : SELECT tablespace_name FROM user_indexes WHERE index_name = 'S1244_IDX$'; -- tablespace is NULL. Note : I find A346_IX1 with query : SELECT table_name, index_name, column_name FROM dba_ind_columns WHERE table_owner='SDE' AND table_name in ('STREET') order BY table_name, column_position;
... View more
11-29-2022
12:32 AM
|
0
|
1
|
3346
|
|
POST
|
I still can not move my spatial index storage to a new place. Here is what I do : - Drop the index: DROP INDEX SDE.A280_IX1 FORCE; - Run this query : "CREATE INDEX SDE.A280_IX1 REBUILD PARAMETERS('st_grids=1,3,0 st_srid=32748 tablespace=NEWTBS');" - Run : ALTER INDEX A280_IX1 rebuild Success. But this does not changed the tablespace location to a new location - Run : ALTER INDEX A280_IX1 rebuild tablespace NEWTBS online; -- Error : ORA-29871: invalid alter option for a domain index - Run : ALTER INDEX A280_IX1 tablespace NEWTBS; --Error: ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option - Run : ALTER INDEX A276_IX1 REBUILD MOVE TABLESPACE NEWTBS; --ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option When I query "SELECT * FROM dba_indexes WHERE rownum < 5 AND table_name = 'STREET'", the tablespace = NULL and Status = Valid What am I missing? Are there any legitimate ways of doing it correctly? Thanks.
... View more
11-28-2022
10:11 PM
|
0
|
2
|
3347
|
|
POST
|
Hi, I need to rebuild my spatial indexes using query. This is the query that I am expecting to run : CREATE INDEX SDE.A280_IX1 ON BANGKAIKAPAL_PT_1K(SHAPE) INDEXTYPE IS sde.st_spatial_index PARAMETERS('st_grids=1,3,0 st_srid=32748 tablespace NEW_TBS'); I need to find st_grids value using query. How can I do that ? I have been searching the web and can not find anything. What I want is something similar in finding SRID : "SELECT sde.st_srid (SHAPE) sridcol FROM SDE.STREET;" Thankyou
... View more
11-28-2022
08:50 PM
|
0
|
2
|
1777
|
|
POST
|
Hi @MarceloMarques I try to move the spatial index into new tablespace (the same with the feature class's tablespace). Here is what I do : - DROP INDEX SDE.A276_IX1 FORCE; -- I have to drop it otherwise it can not be rebuild - CREATE INDEX SDE.A276_IX1 ON FEATURECLASS_LN_1K(SHAPE) INDEXTYPE IS sde.st_spatial_index PARAMETERS('st_grids=840 st_srid=32748 ST_COMMIT_ROWS = 10000 PCTFREE 0 INITRANS 4 TABLESPACE USERDATA1'); --recreating the index because ALTER index REBUILD does not work But when I check using query : "SELECT * FROM dba_indexes WHERE rownum < 5 AND table_name = 'FEATURECLASS_LN_1K'", the TABLESPACE_NAME = NULL and STATUS = VALID. How can I create spatial index via query correctly ? Why is the tablespace_name is NULL ?
... View more
10-31-2022
12:39 AM
|
0
|
4
|
14687
|
|
POST
|
Additional question. 1. Actually, a Feature Class has 3 indexes associated with it : Lob (SYS_IL*), Normal (R*_SDE_ROWID) and Spatial (A*_IX1). For the Lob index, do I need to move it as well ? There is no indication that the Lob Index is unusable. How can I move the Lob Index anyway ? when I run this query "ALTER INDEX SYS_IL0000196018C00023$$ REBUILD TABLESPACE DATAUSER1" There is error : "SQL Error [2243] [42000]: ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option" 2. This command fails for moving spatial index : ALTER INDEX SDE.A280_IX1 REBUILD PARALLEL 8 NOLOGGING TABLESPACE DATAUSER1; Any other alternative command ?
... View more
10-19-2022
11:52 PM
|
0
|
1
|
14723
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 11-25-2024 12:33 AM | |
| 1 | 11-21-2025 12:57 AM | |
| 1 | 11-12-2024 08:22 PM | |
| 1 | 10-13-2024 11:55 PM | |
| 1 | 02-25-2022 05:49 AM |
| Online Status |
Offline
|
| Date Last Visited |
02-04-2026
05:39 PM
|