Latest Contributions by MarcoBoeringa

Therefore, all users are complaining due to the very slow speed in panning and zooming the maps accommodated in the web application. Jamal, I noticed one thing in your screenshots that concerns me. You have a lot of labels visible, and those labels seem to be dynamic. They are not a fixed size nor position. Dynamic labeling is very costly in most cases, and you probably want to avoid this in your web services. What you should consider, is converting your labels to Annotation Feature Classes in your geodatabase, probably best as a feature-linked version, that updates with updates to your parcels layer. As the Help page I linked says: "Geodatabase annotation is indexed spatially, meaning that it will draw and select much faster." You would also do good to set a fixed reference scale for the Annotation and labels, e.g. 1:5000, so as to have the labels scale. And set a visible scale range. As the Help says: "To maximize ArcMap display and query performance, always define a visible scale range for each annotation class so annotation features only draw when you're zoomed in enough to read their text." ... View more

Kevin, This has already been discussed in some length in this thread ArcGIS 10.2 and particularily, see this response of an ESRI employee in that thread: http://forums.arcgis.com/threads/79232-ArcGIS-10.2?p=287668&viewfull=1#post287668 So yes, there is most likely not going to be a 10.1 SP2, and you'll probably be forced to do a full upgrade to 10.2 if you want to take advantage of bug fixes, with the added bonus of some nice new functionality. Anyway, even if there would have been a 10.1 SP2, from a technical point of view, with so many fixes as announced now, it is likely that a plethora of components would have to be replaced during installation of the Service Pack, so as to make the distinction between a simple Service Pack upgrade and a full re-install insignificant... Marco ... View more

I wasn't confused about the primary roles of "ArcGIS Professional Application" and "ArcGIS Runtime SDK for .NET" as desktop end-user application and software development platforms respectively. Just wondering - and this is probably an outrageous(!) thought at the moment considering the differences - whether ArcObjects would at some time be superseded by the ArcGIS Runtime as the main development platform for desktop applications, and would even form the basis of the main out-of-the-box, end-user application, "ArcGIS Professional" or whatever it would be called by then... ... View more

Hi, No, the new ArcGIS Professional Application is not currently based on the new ArcGIS Runtime SDK for .NET. So it is still using ArcObjects, just with the added capabilities of .NET Framework 4.5, the Task based async functionality, Visual Studio 2012 support like 10.2, and a new redesigned user interface? "Not currently", does that mean there are (possibly quite far in the future) plans for a migration / integration? ... View more

Is the new "ArcGIS Professional Application" as unveiled on this year's UC, and that seems set to replace the ArcGIS for Desktop applications (ArcMap, ArcScene etc.) entirely at the next major release, and as presented in this video: Unveiling the new ArcGIS Professional Application based on this "new" development platform (ArcGIS Runtime SDK for .NET)? All indications seem so... or am I wrong? ... View more

Jamal, I can't comment on why things might be failing at your site, Michael is in a better position to do that, but in general, you should not consider caching as the only alternative for hosting data. If you just want to serve non-complex data, like small scale polygons of provinces like the once you showed in this thread with few vertices per polygon, and with simple outline symbology, you are probably much better off serving data straight from the feature source (or a copied file geodatabase), than to create a huge cache. It will bloat storage requirements compared to the original feature data. Caches are best used for complex large scale data that may take up (tens of) gigabytes of diskspace using complex symbology, like detailed cadastral land records, high quality topographic data etc. E.g. say you have an MXD having 20 layers with large scale topographic data symbolized using layered line symbology for roads, complex hatch symbols for polygons to represent 50 different land use types and so on, dynamic labelling etc. with a re-draw time of (a dozen) seconds per screen in ArcMap. If this MXD needs to serve as a basemap layer, e.g. a background to other more dynamic data, than that type of data is best served through cached services, as you wouldn't ever be able to serve that data dynamically to hundreds, or thousands, of users at a time. Just imagine with every hit to your website, the server needing 10 seconds to render a single image before it can send of the rendered data to the user... It really depends on the type of data, and the complexity of the symbology to be used, what type of method you chose to host the data. ... View more

The parentheses should be correct. You're right, my mistake in the first post, the parentheses are correct. I think you are missing a space before the words GROUP BY and that the underlying SDE database parsing is not as forgiving as the parsing done by the personal geodatabase Microsoft Jet database engine. The missing space is good catch. I doubt Oracle would accept it, and it is amazing the Jet engine does... I usually insert a debug line after such dynamically created SQL queries, helps in catching these errors by reviewing the statement before processing. ... View more

I think you have the last parenthesis placed wrong: subiqf.setWhereClause(fieldName+" In (SELECT "+fieldName+" FROM "+className.getName()+"GROUP BY "+fieldName+" HAVING Count(*)>1 )"); should be: subiqf.setWhereClause(fieldName+" In (SELECT "+fieldName+" FROM "+className.getName()+"GROUP BY "+fieldName+" HAVING Count(*)>1 ))"; ... View more

The goal of what I am trying to do is create a dynamic SDE geodatabase, so my feature class will become a dynamic layer when I publish it as a feature service.  I want to be able to consume that service on ESRIs web application.  If I add another record to SQL database server on the back end the point feature will have a dynamic connection to SDE and display on the web application. ... From the reply post it was mentioned to use the specific option of adding a dynamic X, Y data.  Is there a way to create a dynamic SDE, publish it as a feature service so the data becomes dynamic? I am not entirely sure what you mean with "dynamic SDE", because data served from ArcSDE is by definition "dynamic", as pulled straight from the database... But in terms of options of having a X,Y table data with no spatial column displayed as a dynamic point feature layer in a webapplication, you may consider re-posting this question in an ArcGIS for Server or Runtime forum. I think you are more likely to get good suggestions there instead of here in the Geodatabase & ArcSDE sub-forum. By the way, this GIS Stack Exchange thread suggests you should be able to create a dynamic service from an X,Y event layer if the web service is based on an MXD: http://gis.stackexchange.com/questions/25753/publish-xy-event-layer-to-arcgis-server ... View more

Dear experts, I have a spatial view with 25 columns in the database server that looks like this: ... BTW, is view replicate-able using One-Way replication ? [arcsde 10.0, sql server 2005] A view is a view, that is, it doesn't contain data by itself, only references existing data in other tables. If you replicate the Feature Classes and Tables used in your view, and copy the view definition to the child geodatabase, you should have the most up-to-date "view" of the database after a synchronization. There are some specific options for / things to take notice of with Relationship Classes and replication, see the Help for that: Replicating related data Synchronizing with filters and related data ... View more

The fact that your Feature Class has a column called "Shape" does not mean there are actually shapes in there. Unless, like William suggested, you use the Add XY Event Layer option in ArcMap to convert the tabular X,Y data to a dynamically created point layer, and export the data from there to a static layer if needed, your X,Y data will remain just that: X,Y data. ArcMap doesn't "magically" convert X,Y data to point shapes by loading it in a pre-existing point Feature Class, unless, you use the specific option of adding dynamic X,Y data designed for this purpose first, and than convert that layer to a static point Feature Class. Again, see the Help link above, and that William also pointed out for you, for what to do. ... View more

We're currently connecting via ArcReader and a few web apps which are already migrated to the Direct Connect method. If you can already use Direct Connect in ArcReader on your local PC, than you must have the required database client installed. So you shouldn´t have to worry about it. More info on this Help page: http://resources.arcgis.com/en/help/main/10.1/index.html#//019v00000009000000 Again, note the database client is only required in Direct Connect, Application Server connections do not use the database client. But since ESRI plans to phase out the Application Server, the database client can better be assumed compulsory. Wouldn't the database client simply be installed with ArcGIS Desktop or ArcReader? The database client is a separate install, see the first Help page linked above. You can download it either from the database vendor, or the ESRI Customer Care portal. But your IT department is likely to have already installed such a client in their default drive-images in case database connections are used by other non-GIS desktop applications in your organization. ... View more

I found a related table that was selected to participate in the replica and it was related by way of a Simple M-N (many to many) relationship class.  At the FGDB level (i.e., the replicate) I am not sure how this is handled because of the fact that an RDBMS will create an intermediary table to act as a sort of "pivot table" in this situation.  In other words, I am not certain whether or not simple, one-way replication even supports a M-N relationship at 9.3.1 SP2. You may wish to have good look at this 9.3 Help page: Replicating related data(ArcInfo and ArcEditor only) Are you applying spatial or attribute filtering to the replica, as per the Help page, possibly resulting in broken relationships? And have a look here: Synchronizing with filters and related data(ArcInfo and ArcEditor only) Especially see the text under "Example two" for this link above. Overall, it seems relationships are pretty well handled in replication. ... View more

So when upgrading to 10.1 from 9.3.1, and not wanting to install the 10.1 ArcSDE Server Application, do I have to uninstall ArcSDE 9.3.1 from my existing Geodatabase ? I guess you meant to say: "... do I have to uninstall the ArcSDE 9.3.1 Application Server from my database server..." ? If so: yes. Of course, the geodatabase itself with the entire ArcSDE Repository and the ArcSDE and geodatabase system tables therein, should be left untouched, otherwise nothing is left to upgrade... So when upgrading to 10.1 from 9.3.1, and not wanting to install the 10.1 ArcSDE Server Application, do I have to uninstall ArcSDE 9.3.1 from my existing Geodatabase? Then simply run the "Upgrade Geodatabase" tool in ArcCatalog to get it to 10.1? Don't forget you need to install an appropriate database client. Without client, you won't be able to connect any more once your Application Server is down! There may also be an extra issue if you decided to migrate to a new server and in the process go from a 32 bit to 64 bit environment... There are descriptions for that in the Help, but it isn't an easy task. ... View more