Latest Contributions by MarcoBoeringa

The first thing that comes to mind is Representations, as those are indeed stored in the geodatabase. You can even have multiple different "Representations" for a single feature or group of features. Also see: A quick tour of representations In addition, you might wish to have a look at a specialized product of ESRI like ArcGIS Schematics. ... View more

Anthony, we don't fully support AlwaysOn at 10.1. At 10.1 you can connect to a read-only database, not a geodatabase. The ability to connect to a read-only geodatabase will be part of the 10.2 release. The ability to do read-only routing via the Listener using the APPLICATIONINTENT connection parameter will be available in the following release. -Shannon For those of you like me who wanted to know more about this and what for example the ApplicationIntent keyword means, see this Microsoft link and especially the video (switch to HD and full screen to get a better view of the demos): http://www.microsoft.com/en-us/sqlserver/solutions-technologies/mission-critical-operations/high-availability.aspx ... View more

The thing that I find confusing is the link to the SQL Server Native Client 11.0 article in that it does not list Windows 8 or Windows Server 2012 as being supported.  I assume that that is just an oversight, correct? No, it isn't. It seems Microsoft recently decided to rename the SQL Server Native Client, and it is now called: "Microsoft ODBC Driver 11 for SQL Server on Windows" (/ Linux in the Linux version). See this Microsoft Blog post: Introducing the new Microsoft ODBC Drivers for SQL Server And also see the download page for the Microsoft ODBC Driver 11 for SQL Server on Windows: http://www.microsoft.com/en-us/download/details.aspx?id=36434 It lists Windows 8 under System Requirements... ... View more

is there a way to know the version name for each feature that posted in default version. please help, i need this so bad. thanks Not a direct answer to your question, but as to standard supported functionality that might fulfil your needs, 10.1 introduced "Editor tracking": http://resources.arcgis.com/en/help/main/10.1/index.html#//01m600000068000000 As long as you haven't compressed the database to state 0, I could also imagine some of the information you might need is in the geodatabase system tables, e.g. versions, states and lineages tables combined with A/D, but I can't give you any real clues as to how to get that info in terms of SQL just like that. Vince may be able to give directions, if any... ... View more

Jamal, I haven't yet had time to test the replication of a table myself, but this Help page says: "For tables the default filter is Schema Only; only the schema for the table will be replicated. To apply a filter to a table you must first create a table view setting desired filters. You can then use this as input into the Create Replica tool. See the Make Table View for more information. For more information on filters and replication see Preparing data for replication." It seems you may need to make a Table View first, and use that as input for the Create Replica tool. I don't know the reason for this, except maybe that most (or some) stand-alone non-spatial tables part of geodatabases, may actually be very big and actively maintained tables from business systems, for which it is better to only replicate a selection of the data really necessary in the child replica, to avoid excessive data traffic between parent and child. ... View more

Why tables participating in replica are found to be empty on the child geodatabase? Jamal, I think Jake Skinner (ESRI) described the issue and solution in this thread: http://forums.arcgis.com/threads/46668-Non-spatial-table-replication The screenshots in that thread are no longer there, but the setting Jake is referring to is the one under: Expand Feature Classes and Tables (optional) in the Create Replica dialog. You need to choose "ALL_ROWS" instead of "USE_DEFAULTS" to add all records in case of tables. ... View more

Does a geoprocessing tool exist that can find all DTED tiles that intersect an AOI (or Polygon feature class)? I have a area of interest represented by a polygon and DTED tiles (some of which intersect with the AOI). Is there a tool that I can use to find which tiles intersect? Thanks! If you create a Mosaic Dataset, you can than use the included Footprint layer of the Mosaic to find out which DTED tiles intersect your AOI. ... View more

What I wanted to highlight here is that the order of versions when reconciled/posted with the parent is determinant! In my previous example, if the first version is U2 and the second version is U1 then feature 10 will be deleted from the target. Correct? Not necessarily..., it may get a bit complicated now, but versions reference so called "database states". Each time you make any type of edit to a Feature Class, you create a new "database state", and the version starts referencing that state from that moment onwards until the next edit completes. The database state references a certain combination of records in the base table and A/D delta tables. Your single version may actually go through a whole set of "states" during its life-time until you delete the version once you no longer need it. Even during a single edit session (the time in between clicking Start Editing and Stop Editing in ArcMap), your version may go through multiple states, as you can perform multiple edits in a single edit session. It is the time you complete your edits (transaction closing time?) to specific records / geometries, which ultimately determines which records / geometries might be considered the "valid" or last "state" of the object they represent. It is this time and database state information that is used in the (batch) reconciliation and post process to determine if there are any conflicts due to other users having edited, saved and posted the same object to the same target version before you post it. You can than use the reconciliation tools to review the conflicting states and determine whether you favor the current target, or your own edit version. So don't confuse the creation time of the version with the save / completion times of specific edits to specific records / geometries. Jamal, I also strongly encourage you to read Derek Law's basic introduction to versioning to better understand what is going on "under the hood": Versioning 101 And for a really comprehensive overview (older 2004 document, but the mechanism of versioning described there is still highly relevant): Versioning - ESRI Technical paper ... View more

Are there any potential security issues with using a FGDB over a RDBMS? What do yo mean with "security issues"? File geodatabases are just a bunch of (binary) files stored on a drive. They differ in this in no way of a set of normal HTML files representing a basic website, or the individual files making up an ESRI Shapefile. There is no inherent security mechanism in the file geodatabase itself, like database authentication. If access to the FGDB needs to be restricted, than you need to use the normal web authentication methods to restrict access to the website hosting it (password protected HTTPS site?). In a sense, file geodatabases may be a "more" secure method of hosting the data, as there is no RDBMS system to be potentially compromised and made wrong use of. ... View more

Then why the edits of the version of u1 are not transferred to the resulted default ArcSDE geodatabase while the edits of version of u2 are transferred to default ArcSDE geodatabase? Jamal: From this Help page: "If you resolve conflicts in favor of the edit version, all conflicting features in the current edit session take precedence over conflicting representations in the target version." 1) You delete feature 10 in version U1 2) You start batch reconciliation and posting with the option "in favor of the edit version" as per your screenshot. 2) Reconciliation and posting of version U1 takes place, where feature 10 is deleted from the target database, no conflicts are detected in this phase. 4) Now reconcilation and posting of version U2 takes place, again "in favor of the edit version". A conflict is detected. U2 has the original feature 10 with an edit to its attributes, but this feature is deleted from the target. Since it takes precedence over the target version, where the feature is deleted, feature 10 is posted back to the target, including the attribute edit done in feature 10. And yes, the deleted feature in version U1 is back... Jamal, if you want detailed control over each conflict, you should review any edits manually, not run a "batch reconciliation" on multiple versions. ArcGIS has all these tools specifically for this reason: to allow you to make a good judgement of the conflict by thoroughly reviewing it. As to best practices: multi-user edit conflicts are allowed and reconciliation supported in ArcGIS, but this doesn't mean you should be lax on good working practices. Well designed work flows and good work orders should always try to avoid conflicting edits as much as possible to avoid excess work in the conflict detecting & reconciliation. ... View more

How about the sequence of reconcile/post between the default ArcSDE geodatabase and these multiple versions? With which version the default ArcSDE geodatabase is first reconciled/posted? For example, is the default ArcSDE geodatabase first reconciled/posted with Sami's version or Reda's version? which edits of these two versions are first transferred to the default ArcSDE geodatabase? Jamal, I think Leo covered it mostly, but ultimately, the exact time edits were saved determines which edits preferentially should be saved to the DEFAULT. Like Leo said, the conflict resolution options will allow you to see any conflicting edits, and allow you to make a judgement on which edits are favoured over others. If users are editing completely different areas (e.g. Sami is editing municipality Nablus, and Reda is editing Hebron), and consequently no conflicts are to be expected, than the whole point of reconcile order becomes mute and non-consequential in terms of reconciliation. I also recommend you to read: Versioning 101 Essential information about ArcSDE geodatabases By Derek Law, Esri Product Management And these pages by SPP Innovations: Versioning for Dummies: Part 1 Versioning for Dummies: Part 2, the State ID Versioning for Dummies - Part 3: Reconcile, Post, and Compress... ... View more

Some changes occur on the file geodatabase and then the �??synchronize changes�?� applied from the ArcSDE geodatabase to the file geodatabase as shown in the screenshot below: Jamal, just to get this straight: The bold text should be "Some changes occur on the ArcSDE geodatabase"?! You do intend to send changes done on the production ArcSDE geodatabase to the publication file geodatabase to be hosted on the internet in a One-Way replica? ... View more

How about the 10.2? is such tool (adding features to an existing replica) built �?? in on the core? I haven't specifically heard about it, but than I also didn't dig into it to find out. Jake Skinner can most likely tell you... ... View more

I wanted to use the �??create replica�?� as geoprocessing tool but couldn�??t figure out which option is equivalent to �??Select Register existing data only�?� Jamal, there are cases where the Geoprocessing Tools and corresponding Wizards or dialogs in the user interface of ArcGIS don't entirely match. This seems to be one of those cases. It means you will need to use the Create Replica Wizard (or ArcObjects programming) to do the job. It would be nice if things always corresponded for the full 100%, but I can appreciate there might be cases where it is difficult to implement from a technical point of view. ... View more