Latest Contributions by MarcoBoeringa

Jamal, When you get to the grant privliges window have you selected grant from the drop down list under select? Regards Anthony My idea too when looking at the screenshots. ... View more

Have you verified you have all required privileges, especially those listed under the "Geodatabase administrator" section in the Help link below?: User privileges for geodatabases in DB2 http://resources.arcgis.com/en/help/main/10.1/index.html#//00290000003m000000 ... View more

That's nice but the problem is that the lake is shrinking not expanding and the DEM doesn't tell me the elevation under water so I can't get the elevation under water body !! The only reliable way in case of a shrinking lake would be to determine the bottom surface by means of sounding, for example using a multi-beam sonar, and than use that to fill up the gap in the DEM. A crude alternative is to determine some weighted centre point of the smallest circumference, and than model the shrinkage in let's say each degree direction of 360 degree round based on your existing shapes, and than use that somehow as input for an ArcGIS spatial adjustment rubbersheeting operation to automatically define "displacement links". But this isn't going to be an "easy" solution and modelling operation... ... View more

Jamal, You probably have, but since you don't state it, I ask it here explicitly anyway: have you run the same SQL statement in SQL Server Management Studio without the redundant "TOP 1000" keyword text? Did you get the same results (it should, but who knows...)? I think you can simply remove the "TOP 1000" text in the edit / SQL window visible in your screenshot, and than hit "Execute" to do this. I also think it may be time to have a closer look at all the new tools in the Geodatabase Administration toolset, and see if you can figure out if there are any differences in the reported geodatabase state before and after each run of the script. I know you already looked at some of these options, as it is in your screenshots, but have you checked everything? ... View more

Because in all case, in my particular database the number of records is less than 1000! This is why I aimed at using that option. Still don't get it... If you only have a test database with a couple of records like yours, TOP can be left out. I think there is not much use for this option anyway, unless in very specific cases or running test queries against very large datasets. And your target was to determine if all edits of the database were properly reconciled & posted & compressed to the base table, so you want all records. And if you entered "SELECT TOP 50 PERCENT" in the query that I can't read from your screenshot, that would definitely explain 20 records of 41 being returned from the feature layers base table even with a successful operation... :rolleyes: But I figure I don't have to explain that to you! 😉 Best, Marco ... View more

Jamal, Although the first screenshot is not fully displaying your SQL statement, I think I see a "SELECT TOP" statement being used in SQL Server Management Studio. Why do you use the "TOP" keyword, as it is normally used to restrict the number of records returned in case of very large tables and query results? This option shouldn't be used if you want to return all records of the feature layer's base table after having run the Python script, you should use a plain "SELECT" statement. ... View more

Jamal, The Help says that the Input database connection defaults "to use the workspace defined in the environment". Since I already see the versions filled out in the dialog, I don't think there is any need to fill in the "Input database connection", as it probably just uses the connection information from the context from which you opened the option (in your case I guess the Geodatabase Administration dialog). I think the "Input database connection" text line is just an "extra" available for when you use the Reconcile Versions option straight from ArcToolbox, in a ModelBuilder model, or in Python scripting, when the connection isn't yet defined. It would have been better if unnecessary options were hidden in specific cases like this, but I guess this is the small price we need to pay for something like the flexible ModelBuilder and ArcToolbox framework. ... View more

How was this data loaded in your ArcSDE geodatabase? ArcSDE normally runs a thorough check during loading of data using ArcGIS tools, preventing self-intersecting geometries in your database, but if this was an already existing spatial database without ArcSDE geodatabase repository that you "enabled" as a geodatabase, there may be invalid geometries / shapes in the database. Anyway, running the Check Geometry and Repair Geometry tools is likely to fix these issues. ... View more

@ldonahue: It is registered as versioned but without the option to move edits to base. I've corrected my first post. @vangelo: with mv_view I can't create a join between two tables. I'm using ArcGIS 10.0 SP 5. I was under the impression that if you were creating sde views on versioned data that once you reconcile/post/synchronize, that your sde view will be updated. This section of the ArcGIS Help page "What are versioned views?" may be of relevance: "Versioned views do not work with functionality implemented at the geodatabase level. Therefore, they should not be used to edit data that participates in geodatabase behavior. See What type of data can be edited using SQL for more information. If you query a versioned view without setting the version and state, you are referencing the current state of the DEFAULT version. If other users are committing edits to the DEFAULT version (thereby changing the state that the DEFAULT version references), your subsequent queries will see the latest state of DEFAULT and their edits. If you specify version to query using the set_current_version function or procedure (names vary slightly depending on your database management system), you are referencing the state that the specified version was referencing when you set the version. For example, if you run the set_current_version function to set the version to a named version called decedits and decedits is pointing to state 4 in the state tree, all subsequent SQL queries you make against decedits will see state 4 of the data even if other users are posting edits to decedits, causing the current state of decedits to be state 25. To see state 25, run the set_current_version function again to set the version to the current state of decedits." ... View more

Tom, I think there are basically two options (neither I have used since I haven't ever used dimensions although I know what they are): 1) Re-create your dimensions using the dimension tools in ArcGIS. ArcGIS can create dimensions as a special type of Annotation class in a geodatabase, see here: What are dimensions? The dimension construction tools There seems to be a basic but useful set of dimension construction tools, so it may be of use to you. 2) Use the commercial FME (Feature Manipulation Engine) product to convert your CAD dimensions to ESRI geodatabase dimensions. I found at least one reference and example on the FME site for converting Microstation dimensions to ESRI geodatabase dimensions, but it requires the FME software to get further insights in this process: Convert dimensions from Microstation to Geodatabase ... View more

Tom, I think there are basically two options (neither I have used since I haven't ever used dimensions although I know what they are): 1) Re-create your dimensions using the dimension tools in ArcGIS. ArcGIS can create dimensions as a special type of Annotation class in a geodatabase, see here: What are dimensions? The dimension construction tools There seems to be a basic but useful set of dimension construction tools, so it may be of use to you. 2) Use the commercial FME (Feature Manipulation Engine) product from Safe Software to convert your CAD dimensions to ESRI geodatabase dimensions. I found at least one reference and example on the FME site for converting Microstation dimensions to ESRI geodatabase dimensions, but it requires the FME software to get further insights in this process. Convert dimensions from Microstation to Geodatabase ... View more

Never used Parcel Editor myself, but have you tried installing the recent: "ArcGIS 10.1 SP1 for (Desktop, Engine, Server) PostgreSQL and Parcel Editing Performance Patch" http://support.esri.com/en/downloads/patches-servicepacks/view/productid/67/metaid/1941 and of course Service Pack 1 for 10.1: http://support.esri.com/en/downloads/patches-servicepacks/view/productid/160/metaid/1913 ... View more

Also, in terms of Application Server versus Direct Connect, and why ESRI may have decided to make Direct Connect default, it may have to do with a number of (or probably many) clients of ESRI having seen a significant rise in the number of concurrent users using enterprise geodatabases (and not just through cached webservices). Where in the past for most organizations it used to be that only a few highly active editors / viewers concurrently accessed the database (e.g. maximum a dozen) through ArcMap, now for some shops maybe dozens or even hundreds might access it. In that scenario, Direct Connect is probably the best option. However, if you still are within a mid-size organization, with maybe a (few) dozen maximum active users at any point in time, and have a beefy modern 8+ core database server / Application Server with a tens or hundreds of Gigabytes big enterprise geodatabase, than Application Server connections may still be very much a valid choice. In fact, the server with it's specialized high performance hardware and processors (e.g. Xeon), may outperform your desktop in processing the GIS data, especially in cases of network bandwidth constraints. Also, this remark by D.E.Wright on the GIS StackExchange Forum may be of interest: �??There are some very good reasons to use an ArcSDE Server Engine (Edit: Should be ArcSDE Application Server in official ESRI terminology), the first being the load. When you utilize a ArcSDE (Edit: Application) Server Service you are taking the bulk of that data load off the database server and queuing it versus relying on just your local machine to store all that temp data. One thing you will see especially with a MSSQL server when you make your initial database connection in a MXD is that ArcGIS does a 'SELECT *' (as seen in your query analyzer and logs on your DB Server) against that table/feature-class. Now, this can be a huge impact if you have very large datasets; the ArcSDE Service/Process helps in this by aiding in the request of the appropriate data scope. Now as we have all gotten bigger machines, with more RAM its much easier to just load everything into the current session and run with it; but don't just discount the idea of using the service just because the ArcGIS docs say you 'don't need it' anymore, versus when you probably could/should use it.�?� ... View more

I have a question though - I've heared a rumor that ESRI will probably eventually stop supporting Application Server Connection, is that true? What is the "recommended" method of connection by ESRI? Rumours are rumours, and since I don't work for ESRI, I can say nothing sensible about it. From a technical point of view, I see little reason why ESRI would decide to abandon the Application Server option completely. As much of the code base for the Application Server executables is the same as for the Direct Connect DLL drivers (see Derek Law's slightly older but still relevant Enterprise Geodatabase 101 here on the ESRI website), there isn't a whole lot to win by abandoning the Application Server option. From a "support" point of view, there may be reasons, as it seems the Application Server option seems to be a bit more difficult to get up-and-running for some users, and causing more questions and confusion requiring ESRI intervention. As for "recommended", ESRI made Direct Connect default, so I guess this would qualify as the "recommended" option. I doubt though, Vince would give you such an answer, as he probably justly and more precisely will tell you it all depends on the configuration of your specific client/server hard- and software LAN network environment. As I said before in this thread: "It is up to you to decide if you want to travel by "public transport" or use your "private car". One mode of transport may be faster than the other (or the other way around), depending on the conditions in your local "area".." ... View more

Some of you here said that if I do not install ArcSDE application on the server, and use only ArcGIS for Desktop, I'll need to install an Oracle Client (32bit ofcourse) on each desktop that will direct connect to the geodatabase via ArcCatalog/ArcMap. However, I need to be able to connect to the geodatabase (direct connection or application connection) via a desktop without an Oracle client installed. For that, I'll need to install the ArcSDE application on the server, correct? Also, will I need to use application connection or a direct connection? Ariel, if you need the full geodatabase functionality but can't install the Oracle Client, than yes, your only option is to install and run an ArcSDE Application Server (which isn't a bad thing or so ;)). In this scenario, the connection is called an Application Server connection, so you won't be using Direct Connect. Please note you need to add the following line to your Windows services file of your client PC running ArcGIS for Desktop per installation instructions for the ArcSDE Application Server. Please note this has to be done on each machine connecting to your Application Server!: esri_sde      5151/tcp The Windows services file is simply called "services" without a file extension and in Windows 7 located in: C:\Windows\System32\drivers\etc ... View more