Latest Contributions by AdamZiegler

‎09-29-2014

We are doing some heavy back-end database re-architecting with Oracle right now. For anyone who hasn't gotten to see 12c, the CDB/PDB is an option not a requirement. Oracle will make that the only option at 13c. If you can make it work at 12 then less work for you at 13. You also need to be licensed for multi-tenon to have more than one PDB in your CDB.

‎03-18-2013

Hello all, I have received conflicting information on deploying a multi-machine ArcGIS Server site with an ArcGIS Server Image Server extension. What I am trying to nail down is, does each ArcGIS Server instance within my site need to have the extension or does one license of the extension cover the site? I am planning for a 10.1 environment, so that's the answer I'm looking for. Thanks, Adam Z

‎03-18-2013

Here's an Amazon resource that will allow you to calculate costs. Are you looking to host both your web applications and an instance of ArcGIS Server or just the web app piece? Amazon Cost Calculator I would think if it's only your web app and it's a Flex app you wouldn't need to beefy of a server since the heavy lifting is done by the client and ArcGIS Servers. This is an older ESRI white paper on estimating cost. Estimating the Cost of a GIS in the Amazon Cloud Adam Z

‎03-01-2013

Okay, I am back in ST_GEOMETRY business. The problem had a few causes. The database and database server were not properly set up to use ST_GEOMETRY (see help) Privileges were not granted to PUBLIC on all of the ST_% objects - EXECUTE and some SELECT, UPDATE, INSERT, DELETE PUBLIC Synonyms were not created on all the necessary ST_% objects To get up and running again: Configured the database and database server correctly (see help) [INDENT] Created the proper libraries pointing to the ST_GEOMETRY binaries Added entries in the database server tnsnames.ora and listener.ora Recompiled the invalid ST objects in the SDE schema [/INDENT] Applied the proper privileges to the ST_GEOMETRY objects [INDENT] I was fortunate enough to get my hands on the grants of a fresh proper 10.0 database - thanks Jake Using that I compared the grants to what my DB had Here's the select statement to get the grants: [INDENT] select grantee, owner, grantor, privilege, table_name from dba_tab_privs where owner='SDE' and table_name LIKE 'ST_%' order by table_name; [/INDENT] The grants that I was missing were added to a SQL script that I ran against the DB [/INDENT] Create the PUBLIC synonyms still needed [INDENT] Jake hooked me up again with a nice list of the synonyms from a good DB That was compared to my DB I created a sql script to create the synonyms Here are the select statements to retrieve the necessary synonyms [INDENT] select synonym_name from all_synonyms where owner = 'PUBLIC' and synonym_name LIKE 'ST_%'; select synonym_name from all_synonyms where owner = 'PUBLIC' and synonym_name LIKE 'USER_ST_GEOM%'; select synonym_name from all_synonyms where owner = 'PUBLIC' and synonym_name LIKE 'ALL_ST_GEOM%'; [/INDENT] [/INDENT] So, thank you to Vince for pointing me in the direction of my problem and thank you to Jake for getting me what a correct DB should be. I've attached the output of what the proper DB privileges and synonyms should be. Thanks, Adam Z

‎02-28-2013

Great, thanks for the insight Vince. I'll work through it and re-post any findings/solutions. Adam Z

‎02-27-2013

Greetings all, I have run into a wall and am in need of some direction. I recently tried to create a new feature class using ST_GEOMETRY and I cannot get the feature class to draw in ArcMap. I have the same issue when trying to preview the feature class in ArcCatalog. The selected object failed to draw: ST_GEOM_TEST: Underlying DBMS error [ORA-00942: table or view does not exist][APPDEV1.ST_GEOM_TEST] So, I have an Oracle 11g database with SDE 10.0 installed. Full disclosure on the upgrade to 10.0 from 9.3.1 is that we did not have the proper set up for ST_GEOMETRY on our database server box. We do not use SDE service anymore and were not planning to use ST_GEOMETRY. I have since updated the SDE libraries to know where to find the ST_GEOMETRY and RASTER .so binaries. We are running IBM AIX 6.1. There were some invalid objects that recompiled to valid after I fixed the SDE libraries. I also re-configured the listener per the instructions and all of that seems to be working properly. I can use sde -o describe and describe_long on the table. The long description is below (fields between OBJECTID and SHAPE omitted for space preservation). ArcSDE 10.0 for Oracle11g Build 2063 Tue May 22 14:45:23 2012 Attribute Administration Utility ----------------------------------------------------- ---------------------------------------------------------------- Column Owner : APPDEV1 Column Table : ST_GEOM_TEST Column Name : OBJECTID Row ID Column Type : SDE Maintained SDE Column Type : SE_INT32 Column Size : 10 Decimal Digits : 0 Null Allowed? : False ---------------------------------------------------------------- Column Owner : APPDEV1 Column Table : ST_GEOM_TEST Column Name : SHAPE SDE Column Type : SE_SHAPE Column Size : 0 Decimal Digits : 0 Null Allowed? : True Layer ID : 1167 Anybody have any ideas on where I can look or troubleshoot next? Any and all insights/ideas are welcome and let me know if more information is needed. Thanks! Adam Z

‎02-26-2013

I think it may be a version issue you're dealing with. You said you versioned the data, are you editing that data through a child version of default? Are your spatial views pulling data from the Default version or a child of Default? If your views are looking at default and you are editing a child of default then you need to reconcile and post your changes to the default version. You could also use the 'move to base' option to ensure your edits are being pushed to the default version of the database. Did you create the map service consuming the views prior to versioning the data? If that is the case, you may need to look at the service again. When you create a spatial view of a versioned feature class you need to tell ArcMap what version to look at, you will be prompted to chose a version when you add the spatial view. I think that is stored in the mxd and then in the service. Adam Z

‎02-12-2013

The entire feature class contains 421,357 features, 234,713 of which are classified as buildings. The view and layer with definition query both return 234,713. Although the spatial view also creates views of the S and F tables which are not filtered by the where clause (and how could they be...). I'm not sure what you were asking about the fraction of area in buildings to non-buildings. Do you mean total area of each? Under you advice I changed the order of the definition query layer to be attribute first and it slowed it dramatically. Much slower than the spatial view (by a factor of at least 5). I checked the order of the spatial view layer in ArcMap and it is set to spatial first, but from what you said it seems like I can do more to ensure spatial search first in the the database as well. How is this accomplished in the spatial view creation? Thanks, Adam Z

‎02-12-2013

I also forgot to mention that the stand-alone buildings layer loads as fast as the layer with the definition query applied. Adam Z

‎02-12-2013

Thanks for the reply Vince. We did test that as an option as well. I didn't mention it because I want the footprints 'stand-alone' to remain synchronized with the building footprints in the impervious layer. That's why I wanted to use a where clause in either the spatial view or within the definition query of an ArcMap layer. Once separated into two physical tables they are forever separated, right? To keep them topologically correct then becomes editing on two layers versus one. And if I were to separate buildings as a stand-alone and roads and other as a stand-alone I then degraded my impervious layer into two separate layers taht need to be re-merged to do surface water modeling. I was testing at scales that I thought were appropriate for building footprints, 1:15,000 max. The time difference in display is pretty minimal as well, say 1.5 seconds to draw for the spatial view and 1 second for the definition query. I'm also using this as a test case for more complex spatial views that I have coming down the line. At the county we use variations of parcels very often and current methods of creating those variations involves truncating and appending geometries and then applying attributes from external systems (i.e. addressing and assessment). We have our base layer and 4 variations of them in our database. I would like to maintain one versioned parcel geometry and apply it to multiple variations of parcels so that I can then use geodatabase replication to a database that will be used by ArcGIS server (either internal or potentially on the cloud). The construction of our parcel variation layers don't play nice with GDB replication. Thanks, Adam Z

‎02-12-2013

Hello all, I was hoping to open a discussion on SDE Spatial Views versus a SDE layer in a mxd with an applied definition query. I've searched around but haven't found any good information on best practices with spatial views and when might be appropriate and when might not be appropriate to use them. Here is my scenario. I work for a county and we recently acquired an impervious surface layer that was derived by a consultant from LiDAR and photo analysis. The data is classified as either Building, Road or other. The data team requested that the data be loaded into the SDE database and be provided as two separate layers; impervious layer and building footprints. Additionally, manual edits will need to take place on the building footprints to make them more useable to the end users (i.e. splitting condos and row homes). Because of that I wanted to make sure that there was one layer that was being edited to maintain topological correctness. Upon hearing the request my initial thought was to load the entire impervious surface as a feature class and then create a spatial view of the impervious surface using the where clause of type = Building. As we worked through some of our testing, what was found was that a Spatial View is actually slower to perform than the impervious layer added to ArcMap with a definition query applied to it. I ran traces from the DB side and found the same thing, it is more expensive to run the Spatial View than allowing ArcMap to use a definition query. I had been under the assumption that using a literal from an application would be less efficient than compiling that into a db object. If anyone can weigh in on this that has a bit more experience I would really appreciate it. Thanks, Adam Z

‎01-29-2013

Hi, I too have seen this issue before long ago. Please post your environment info along with a sdelayer -o describe_long of the feature class and spatial view. In my situation, i believe my problem was passing the wrong srid to view creation command that prevented the use of the spatial index. good luck, Anthony Anthony, Thanks for the reply. The view I created was actually using the geometry of an existing feature class, so I did not need to specify the SRID (not using Oracle Spatial). Our RDBMS is Oracle 11g (11.2.0.3) on AIX 6.2. SDE is 10.0 (and I actually just discovered that no SPs have been applied...which will be remedied tomorrow). The long description of the table is attached. Thanks, Adam Z

‎01-29-2013

When creating a spatial view, ArcGIS will not create a spatial index (or any index) on the view (DBMS' may not support indexes on view at all unless it is a materialized view), the key aspect is to make sure the underlying database tables that are referenced in the view have the appropriate indexes. Hope this helps, -Brent Okay, that is good. As long as the geometries being used are indexed everything should be fine. I can ignore the High Warnings that is given by ArcGIS Server when publishing the view out as a service. Thanks! Adam Z

‎01-15-2013

Hello all, I have a question in regards to Spatial Views. I am trying to minimize redundancy in my parcel dataset by using spatial views. I have different tabular sets that I join to the managed parcel geometries so that I don't need to re-process feature classes constantly to get updated geometries. This has been successful to this point in ArcMap and consumed in a MXD based map service. I recently tried to use the spatial view in a msd based map service and received a High Warning that my layer did not have a spatial index. I found this odd at first, because the feature class that is the source of the geometry does have a spatial index, so why isn't that used in the spatial view? I tried to create a spatial index on the spatial view and that isn't allowed (which I expected). I guess I'm just looking for confirmation that the best way to use my RDBMS is to redundantly store geometry.....which would sort of laugh in the face of having a RDBMS. I mean SDE feature classes are essentially views anyway. Thanks, Adam Z

‎08-17-2012

Adam, Version 3.0.2 - August 17, 2012 * Added startatoldesttime and resetslideronlayerchange options. You are the best! Thanks! Adam Z

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by AdamZiegler

Re: ArcSDE in Oracle 12c ... anyone ... anyone ...

ArcGIS Server Image Server Extension

Re: Estimated Cost of Hosting ArcGIS for Server on Amazon EC2 (Cloud)

Re: Trouble with ST_GEOMETRY

Re: Trouble with ST_GEOMETRY

Trouble with ST_GEOMETRY

Re: Spatial Views not Updating

Re: SDE Spatial Views versus Definition Query on a Layer

Re: SDE Spatial Views versus Definition Query on a Layer

Re: SDE Spatial Views versus Definition Query on a Layer

SDE Spatial Views versus Definition Query on a Layer

Re: SDE Spatial Views and Spatial Indexes

Re: SDE Spatial Views and Spatial Indexes

SDE Spatial Views and Spatial Indexes

Re: Config Issues with Enhanced Time Slider Widget version 2.5.1.1 for FlexViewer 2.5

Re: SDE Spatial Views and Spatial Indexes

SDE Spatial Views and Spatial Indexes

Re: Trouble with ST_GEOMETRY