Latest Contributions by MarcoBoeringa

Below is my understanding of this issue. Correct me if i am wrong. My cell size is 20m because of large area coverage. Although my sample point might deviate from the center point of the raster cell, unless the cell itself is a rubber and it can bend itself, otherwise no matter where my sample point located in the cell, its estimated value should equal to itself value which is also the center point value because this cell passing through this point when modeling. The bold text is a misunderstanding of the process of Spline interpolation. In fact, the sentence just before it "unless the cell itself is a rubber and it can bend itself" is closer to reality. During the actual interpolation, there IS NO raster, there is just the mathematical equations and the surface being bend with the sample points as a kind of "control points" restricting the process. Only after the actual interpolation, will a raster be generated from the mathematical surface. This means the values of sample points, and the final raster cells who's centres need to be determined / estimated from the computed surface, can and will deviate from each other UNLESS the sample point happens to be EXACTLY in the centre of a raster cell (which is an extremely rare case). If it is true by saying "there *usually* is a difference between your sample points locations and the raster cell's centres. It is actually the raster cell's centres that are being calculated. ". Under this circumstance, the spline will not pass the sample point? because of the distance between the sample pt and raster center? so the algrithim will not be followed? This is again a misunderstanding, the spline function will pass through the sample points, no matter what. ... View more

How big are the raster cells of the resulting raster you are calculating? I am asking this because there is one thing you need to realize: there *usually* is a difference between your sample points locations and the raster cell's centres. It is actually the raster cell's centres that are being calculated. So although the fitted mathematical curve should pass exactly through the data points, any cell below a sample point that doesn't have an exact match between its centre and the sample point, may result in a cell value different from the sample point. This issue will be more pronounced (and the differences between the sample points value and the estimated / calculated cell value bigger) with larger cell sizes. Just to visualize this: imagine a soccer pitch as being a cell: the centre point of the pitch is the actual point that is being estimated in the interpolation. Now your soccer player (the sample point), might actually be in completely different position, e.g. near one of the goals, resulting in a difference between sample points value and the estimated cell. ... View more

vangelo, When I tried to publish an mxd in arcmap 10.2, a dialog box came up saying the table was not registered and the data had to be copied to the server.  The words copied to the server make it sound like a one time upload of the data, meaning any inserts after the publication would not be viewable.  Maybe I am just misreading the dialog box.  Would you explain how you would publish a map service of an unregistered table, so that the sql inserts will be seen after the initial publication? Thank you. It may not be entirely relevant, but I do think you should start reading this recent (April 2014) Support Services Blog article: The Evolution of Query Layers (Please note right-click and choosing "Open in new TAB" does not always succeed in opening the right Blog article, use left click instead to open in current page if you have problems, or search the ESRI site with the title of the Blog article) ... View more

Ouch.  I thought you could access simple feature classes from Server, but it seems as if it can't.  Working around that will wander into unsupported realms.  How urgent is your SQL insert requirement? - V Are you sure? I included, based on Help documentation, an option for creating a web service based on a Query Layer in my Geodatabase Framework document. The web service uses the Query Layer in ArcMap, and must be published as a Map Service from within ArcMap. According to this Help page, the requirements for a web service based on a Query Layer are: "The following describe feature service data requirements specific to data stored in a database: All data must be from a single database.     Write permissions on the data are required if you plan to allow edits to the data. When using operating system authentication, these permissions must be granted to the ArcGIS Server account.     When you add database data to ArcMap, a query layer is created. If you alter the query layer definition, be sure the query contains only one table, does not have duplicate columns, and does not include virtual or merged columns.     The data that is published is determined by the query layer defined for the table in ArcMap. For example, tables that contain data types that are not supported by ArcGIS can be published, but the unsupported data types are not accessible through ArcGIS or the feature service. See Viewing database data in ArcGIS for information on how the query layer is initially defined when a database table is added to ArcMap.     The table must contain a unique integer column maintained by the database. If you create tables and load the data to the database using ArcGIS for Desktop, a database-maintained unique integer ObjectID is added automatically. If you create data outside of ArcGIS, be sure to include a database-maintained unique integer column in the table. If such a column does not exist, you cannot publish a feature service. You can use the Add Incrementing ID Field geoprocessing tool to add a database-maintained integer column to your table if it is in an IBM DB2, Microsoft SQL Server, Oracle, or PostgreSQL database." ... View more

I have two polygon layers that are not exactly coincident and if I use STIntersects on the target polygon I get two different values where the polygons are not coincident. I was wondering if there is a query that can be used instead of STIntersects that would be similar to selecting the centroid of the polygon...? Thanks in advance! SQL Server has an STCentroid command. If you dynamically convert one of the two polygon layers to centroids, and than use that new layer as input for the STIntersects command in combination with the other polygon layer in the view definition, I think you are there... Although I second Vince's remarks about possible performance issues, I think you may be fine if the layers don't exceed some 10000 records or so. I have run some tests with views containing STCentroid and STBuffer, and the performance was acceptable for layers up to about that size (Core I5 3GHz Desktop, locally installed SQL Server Express) ... View more

I have been having an issue setting up data replication using a geodata service on 'sync' enabled data. Does anyone have any ideas how to get past the issue below? We have a cloud server with a number of datasets that are going to be used for offline editing in AGOL. To enable the data to be used offline, it must be stored as non-versioned. This is fine, no issues here. The issue comes when we want to replicate the same data off the cloud server, to our servers within our network, for displaying in internal GIS viewers, etc. In order to replicate data, the data must be versioned. So does anyone have any ideas how I can get around this issue when one process requires non versioned data while the other process required versioned data. I think you are actually working outside the intended "scope" of this functionality of "offline editing in AGOL with 'sync' enabled data", when you attempt to replicate it back to "on premises" (at least at the current state of affairs / technology). As this Help page clearly states: "Do not use this scenario �?�If you want to publish a service type other than a feature or WFS-T service. �?�If your data already resides in an enterprise geodatabase. �?�If you want to publish database tables accessed through an OLE DB connection file (.odc) �?�If you want to synchronize changes between the publisher's machine and ArcGIS Server's Managed Database." It seems "replicating" back is not supported in this scenario, also illustrated by the following remark on the same page: "Once published, you and your users should only work with the data exposed by the feature or WFS-T service. If you want to update the data in ArcGIS Server's Managed Database, you can add the feature or WFS-T service in ArcMap and use the local editing commands to upload the new data." So what can you do to move data back? According to the same Help page, you need to "copy" the data of the server manually: "If you want to save your data before deleting the service, you can use the tools in ArcGIS for Desktop to export the enterprise geodatabase data into a file geodatabase that you can transfer to your local machine." Also mind the big caveat(!): "�?�Deleting the service deletes the service's data." If you are not careful, and delete the service without backing up the data in the ArcGIS Server's Managed Database, you will have lost all edits synced to the offline editing Feature Service. Also be careful when updating from the "on premises" to the ArcGIS Server's Managed Database, per this caveat: "�?�Whenever you update your data on premises, you must do an overwrite of the dataset in ArcGIS Server's Managed Database in order for the server to reflect the changes." Your other option is to NOT use offline editing, but only online editing and "normal" publishing of a Feature Service as described here. This will allow full synchronization back and forth between publisher's database and webserver's database. E.g. see this quote from that page: "This scenario is also well suited for publishing feature services to on-premises or cloud servers. For example, if you publish a feature service using this scenario, edits made on-premises could be pushed to the server's geodatabase, thereby becoming available to end users of your feature service. Conversely, if web editors change any features in the server's geodatabase, the edits can be synchronized with the publisher's geodatabase." Maybe that a future version of this offline editing functionality will contain more options, including a better option for synching back to the publisher's geodatabase, as it still seems in full development. ... View more

Are you sure Geodatabase Replication isn't suitable for your scenario? This would save you from trying to handle this through models, and additionally have the benefit of just copying over changes, instead of everything. See the Understanding distributed data and Scenarios using distributed data as starters to Geodatabase Replication. ... View more

For example, the highly touted Blogs are anemic--take your own contributions as an example, 233 Forum posts to date and 27 Answers; but only 1 blog item posted by Rhonda Glennon on January 28, 2011. Personally, I can live with a not-to-active "Blog". Blogs are just what someone wants to write about, not necessarily targeted at my specific problems, hence there is a chance of a very active blog actually "not being helpful", while the Forums allow the user to start their "own" topic (I do like to read the Blogs now and then though!). No one expects a product engineer to spend an inordinate amount of time on direct technical support--writing clear help documents, KB articles, and the occasional white paper should be a primary focus--we understand that. We generally recognize that participation in the forums by Esri employees (by all but Jim Barry) IS voluntary. But with the release cycles accelerating across all product components--maintaining a one post a day average personal commitment to the Forums does not seem like too much to ask. Agree entirely. I don't expect ESRI staff to dedicate as much time as some of us (MVPs or not) voluntary do, but ESRI staff could be more active. For example, that Vince is more or less holding up the "Geodatabase & ArcSDE" subforum on its own, while there must be a substantial group of ESRI developers involved in geodatabase / ArcSDE development, is a sign on the wall. By the way, a very nice example of why the Forums can be a primary channel for support, is the thread below that Vince answered. The original question is so specialized, it would probably have taken a long trip through official "Technical Support" channels to get answered. A waste of time and money for the one posing the question, but also for ESRI Technical Support itself. This is a prime example where more participation by ESRI staff could actually help in freeing up support personnel for those cases where it really matters to have direct contact with ESRI technical staff. ArcSDE C-API SE_stream_calculate_table_statistics() crash with Oracle At the opposite end, there is also a plethora of "non-specialized", "How-to-do-this?" newbie type of questions here on the Forums, that gets easily answered by anyone more experienced. This is also where the Forums can excel as a support platform. But, making the call for help here remains the most likely channel for getting responsive and accurate resolution to usage and configuration issues.  Would simply observe that it would be more so if more Esri product engineers and support technicians would resume volunteering their time to support the Esri Forums as THE premier resource for ArcGIS support. +1 ... View more

File a tech support issue...venting on the forum will bring no resolution (cough cough) I do wish ESRI staff were more active here on the forums to listen and target this kind of posts that may indicate (serious) issues. Some are, but quite a number of posts that would deserve some attention of ESRI staff, go unnoticed. The amount of traffic here on the forums is not that unwieldy (in fact: I think it is very manageable...), that the big pool of ESRI employees would have a tough time keeping up with it. Far from it! It is not Facebook here... ... View more

It is probably unrelated, but I noticed there is an old ESRI bug reference for ArcGIS 9.3.1 with this same Oracle error (ORA-29902): Bug:  Encountering Oracle error ORA-29902: error in executing ODCIIndexStart() routine when creating spatial index with st_geometry ... View more

also, i found out that i can see the table records in ArcCatalog under the "Preview" tab when i choose "Table".....However, when i choose "geography" option the error pops up. Are you sure you have configured the ST_Geometry type correctly on this database? The fact that you are able to see the table records, but not the geometries, pretty much excludes a rights / privileges issue with this specific table and / or user. This more suggests some misconfiguration of the ST_Geometry type. See Add the ST_Geometry type to an Oracle database in the Help. *** EDIT ***: overlooked / forgot it again, but you already wrote that you managed to view the spatial data with schema owner, so it is probably configured right. ... View more

Unfortunately, Server Object Extension (SOE) is not helpful because we do not control what extensions are installed on the customer servers. We're interested to get the converted data from server using techniques officially supported by Esri, or convert the data on the client side. Looking at that blog that Domenico pointed out, and the tools ESRI seem to offer to deploy such a SOE on the server as presented therein, I wouldn't consider SOEs "unsupported techniques" in the context of ArcGIS for Server... ... View more

I really would make an attempt to create a new user using the build-in tools of ArcGIS for Desktop (right click the Database Connection in ArcCatalog and choose Administration / Add User or use the Create Database User tool). ST_Geometry storage is just to different from SDE_Binary to assume you can use Oracle scripts suitable for SDE_Binary in an ST_Geometry environment. Also see the Create Database User tool Help for what database privileges are necessary and granted by the tool. ... View more

How did you create this second user? Have you already attempted to use the build-in tools of ArcGIS for creating the database user, and granting privileges? You may be overlooking something if you do this at the database level. ... View more