Latest Contributions by WalterDziuba1

Afternoon, I've created a spatial view with ArcCatalog and have now added it as the data source to my project *.mxd The view contains 149,400 records. lt's been constructed from one of our data sets and inner joined to three other tables from an external database. The view has a 1:M cardinality to the remaining external data. When I attempt to update my map extent in ArcMap, not all of the geometry is being displayed. But only a small fraction of the points display correctly. My Question : Why is the entire collection of points not being displayed? Walter ... View more

Afternoon, I'm attempting to create a query layer from a feature class in our SDE database plus three additional tables from an external database that is stored in the same SQL Server instance. The SQL statement supplied contains four joins. One to our feature class, and the remaining three to the external database. I'm using the "Make Query Layer" tool set. It accepts the SQL statement supplied and I select three columns to be the unique identifiers. Great so far.  My Question: Is the query layer dynamic? Meaning, does it react like a view where it will continue to read data from the three external tables when additional data is added to those external tables? And finally, it's weird, but the results window states that the process was successful, but I cannot find the output query layer anywhere in my database...!!  Walter ... View more

I often create views using ArcCatalog with New>View and add the view to my database. The view is created with the following naming convention: TestDeploy.dbo.SpecialView I then add the view to my .mxd and continue on with my project. During the publishing process, the analyze step flags an error with this view, stating that the view is not recognized and is not registered to the database. I then use the tool "Feature Class to Feature Class" into another temporary .gdb and then copy the view back with the same command. Unfortunately, this step alters the view into a table and does not retain it's view parameters Then, the newly created table will have the following naming convention: TestDeploy.DBO.SpecialView Why does the initial New>View create the view with lower case "dbo"? And why does the transferred table now become "DBO"? Is there an issue with my database connection that it creates a dbo.view and not a DBO.view? Walter ... View more

I've published a feature service to our instance of ArcGIS server v 10.4.1 and am attempting to manually apply edits to test out the service. While using the REST endpoint's "ApplyEdits" hyperlink, I'm inserting the following line into the "Adds" section: [{"attributes":{"Junk":"junk,"BeginDate":1428292800000,"EndDate":1428465600000,"CreateDate":1491418656097}}] The error that I'm receiving at this time is: "Unable to complete operation. Internal error during object insert" But after I review the server logs for that feature service, it states: Error: Insufficient permissions. How do I apply the necessary permissions to allow edits to be applied to this feature service? Any help would be appreciated. Walter ... View more

Afternoon, I have a rest end point that contains 24 hour entries for each day regarding precipitation. But I only need to extract the last hour of that day, or the max(date) value. For example: 2005-01-14 01:00:00 2005-01-14 04:00:00 2005-01-14 05:00:00 2005-01-14 08:00:00 2005-01-14 23:00:00 So in the example above, I only need to extract the last value.  How does one query the rest end point to extract only that value? Any help would be appreciated.....Walter ... View more