POST
|
First: sorry for the late reply as I had another task to finish. Second: let me describe my problem in detailed.. I have a dataset consists of more than 50 Feature class, all of them are projected into (Proj1) system. The features inside every FC are located in 3 regions, My task is to reproject the features based on their regions, i.e. every region has its own transformation parameters to be projected to (Proj2) system. For every feature class, I need to split it into 3 feature classes based on its region, and then project each one of them separately by custom transformation parameters to (Proj2) system. So at the end I should have for every feature class in (Proj1) system, 3 resulted feature classes projected into (Proj2) system. Now I should merge them back again into 1 feature class projected into (Proj2) system. All that is not a big deal, except this constraint: I have to maintain the OID!! as there are other systems that are linked with these FCs via the OID. This means simply I want for every Fc to (Split, Project, Merge) the features with maintaining the OID. This is my problem in detail, hope its clear. -- My first thought of it is to try to edit in the OId after finishing the projection and merging. however I think its not doable at all! Now am thinking of another way, to do the following: 1-Loop on the features in the FC and project their geometry and store their new location. 2- modify the projection of the FC to be (Proj2) directly. This should be a long operation (as I have about 3 million feature), however it will do the task with maintaining the OID. So what do you think ?
... View more
02-05-2014
03:25 AM
|
0
|
0
|
2933
|
POST
|
You really should not use ArcGIS registered rowid column values for anything, much less as foreign keys into other tables. If you change an objectid value, you have corrupted your geodatabase instance -- please do not do this. I recommend you find a different procedure for making the changes you need to make. You can copy the relevant subset with a SQL query that changes the column name, register that table, do whatever is necessary, copy the result back, then delete the intermediary feature class. This will not invalidate the rest of your instance, and is probably more likely to work. - V Let me share my problem to get you in, I have FC falls in two zones projection, and I need to reproject it to another system. which means I need to split it into two FCs, each has fallen in one zone, Reproject, and then merge them back again into one FC. My issue is that there is another system linked to this FC by OID, and if the OID changed it will fail, and updating the OID in the other system is a very expensive operation, so my only way is to do my task with keeping the OID, how can I do that ?
... View more
01-14-2014
08:52 PM
|
0
|
0
|
2933
|
POST
|
Thanks a lot guys for the two solutions, i'll try both and tell you the results. Thanks again.
... View more
01-13-2014
07:40 PM
|
0
|
0
|
1093
|
POST
|
And your select statement needs to get a specific set of ObjectIDs? No, I just need to save current OIDs in a new field, do whatever I want with the features, and then retrieve the OIDs back.
... View more
01-13-2014
05:36 AM
|
0
|
0
|
2933
|
POST
|
All, Thanks for the quick replies. @timw1984 : I need to keep the OID as other systems are using them, I can't change them. @ldonahue : I am not using edit sessions, I need to extract some data, and the re-project them.
... View more
01-13-2014
05:20 AM
|
0
|
0
|
2933
|
POST
|
I'm using ArcGIS 10.1, and I have polyline feature Class, some of it's features have curves in it, how can I detect these features?
... View more
01-13-2014
04:45 AM
|
0
|
8
|
1582
|
POST
|
I'm using ArcGIS 10.1 and I've a scenario where I want to do some changes in the feature class like (change projection, extract some features with specific criteria) and I want to maintain the objectID. I'm thinking to save the current objectid and return it back after finishing my modification. but i don't know how to do it? any ideas?
... View more
01-13-2014
04:39 AM
|
0
|
9
|
7431
|
POST
|
While creating the connection in Desktop 10.2, did you use the syntax "sde: oracle11g:TNSNAME" ? If yes, just try creating the connection with "TNSNAME" in the Instance parameter. http://support.esri.com/en/bugs/nimbus/TklNMDg0OTg3 Regards, Thanks, it worked after updating the instance name to the TNSNAME only
... View more
11-25-2013
08:59 PM
|
0
|
0
|
525
|
POST
|
I have a problem in upgrading ArcSDE 9.3.1 to 10.2, please find below steps that I have done. 1- Original Database was Oracle 9i Enterprise edition release 9.2.0.8.0 64bit, hosted on UNIX, ArcSde version 9.1 2- I performed full database backup for the database 3- Restored the dump file on Oracle 11g Enterprise edition release 11.2.0.2 64bit hosted on Linux Redhat enterprise 64bit 4- Performed ArcSDE 9.3.1 for oracle 10g post install, a. I selected Custom b. Selected Repository Setup �??Only�?�, and uncheck all other options c. I kept default file for GIOMGR.defs, and dbinit.sde d. I selected Upgrade for DB tune, and regarding Geometry, I selected �??Keep Current default geometry storage�?� 5- Connect using ArcCatalog 9.3.1 and perform Geodatabase upgrade 6- Make direct connection using ArcCatalog 10.2 installed on Windows 7 64bit machine, having oracle 11g client 32bit installed, using �??SDE�?� user 7- I tried to perform upgrade Geodatabase a.First I selected �??Perform prerequisite check�?� only: it passed with the below warning �??Connected RDBMS instance is not setup for ST_GEOMETRY configuration. [Unable to determine current version of ST_SHAP ELIB. Please check the ST_Geometry shape library path on the Oracle server, which is set to "C:\Program Files\ArcGIS\ArcSD E\ora10gexe\bin\st_shapelib.dll". Refer to the ArcGIS help topics for more details.�?�, I copied the �??libst_shapelib.so�?� to the ora cle home \lib directory on the database server (Linux), but it didn�??t solve the problem, even by updating the extproc.ora file as mentioned in the below link http://resources.arcgis.com/en/help/main/10.1/index.html#//002n00000091000000 , however it was just a warning so I conti nued to upgrade the database. b.I selected �??Upgrade Geodatabase�?� only, I got the same warning of ST_GEOMETRY, then it continue and gives me the below error Running Pre-Requisite check (C:\Users\hboieth\AppData\Roaming\ESRI\Desktop10.2\ArcCatalog\SDE on HAYTHAM.sde). Instance supports XML type. Updating server tables and stored procedures. Could not update server tables and stored procedures. Refer to upgrade logfiles for more details: C:\Users\hboieth\AppData\Local\Esri\Desktop10.2\GDBUpgrade.log C:\Users\hboieth\AppData\Local\Temp\sde_setup.log Unpaused the database. Failed to execute (UpgradeGDB). Failed at Mon Nov 25 20:39:25 2013 (Elapsed Time: 0.97 seconds) c.Below the �??sde_setup.log�?� [Mon Nov 25 19:21:41 2013] ST_Geometry Schema Owner: (SDE) Type Release: 1007 [Mon Nov 25 19:21:41 2013] Instance initialized for ((sde)) . . . [Mon Nov 25 19:21:41 2013] Cannot upgrade a user schema geodatabase when the master schema geodatabase is at a previous release. The master schema geodatabase must be upgraded first. [Mon Nov 25 19:21:41 2013] ERROR: Geodatabase schema object install not completed (-522).
... View more
11-25-2013
06:34 AM
|
0
|
3
|
2334
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|