Latest Contributions by JamesFox1

‎11-22-2011

Thanks Vince, I kind of figured as such. A one time, non-updatable snapshot at create time. -Jim

‎11-22-2011

I have a question about how a spatial view is stored and if it is update-able in a file GDB. I copied a group of objects out of a relational SDE geodatabase into a file GDB and some of the objects are spatial views. They seemed to copy fine but then I realized "how is a spatial view defined for a file GDB"? My understanding is that a spatial view is technically a view defined at a relational database level against base tables maintained by the ArcGIS metadata so that the geometry can render and process correctly. But is a spatial view in file GDB stored as an "internal view" against the base tables in the GDB file? I started cleaning up some the base tables in this file GDB, renaming the table names and such and it seems like the data in these spatial views did not change. This tells me that a spatial view in a file GDB is some kind of "snapshot" set of data taken at the time when the spatial view was copied from the original relational SDE database, sort of like a materialized view in common relational databases. if it is just a materialized snaphot, is update-able or refreshable then or would a file GDB spatial view then need to be deleted and re-created to be updated? Any thoughts on this? -Jim

‎11-21-2011

I am wondering if there is a quick and easy way to move a relationship class out a relational SDE geodatabase into say another file GDB? Export and load data can move the features but I have a few relationship classes which I would rather move than have to recreate them by hand in the destination GDB. ArcCatalog cut and paste copying doesn't quite seem to work, some may copy over but with errors on some of the attributes (in red) while other don't copy at all (invalid index errors) I know you can export a Feature Dataset with an XML export but I dont think this will pick up the relationship classes in the dataset. -Jim

‎11-08-2011

To be able to persist map/layer properties (symbology, map and layer properties,..etc) as identifiable objects in a relational SDE geodatabase. To be able to associate persist map/layer properties to features and/or feature classes by default or in an ad-hoc manner.

‎10-19-2011

It would be nice to be able to configure a feature relationship class to set the displayed labeling of related records to say a particular attribute value of that record that can be configured when the data is diplayed in a table of contents view in ArcDesktop tools like ArcCatalog or ArcMap. Currently, when the relationship class is created you set a generic display label text for the relationship, forwards and backwards. However this text is not displayed when parsing a table of contents tree in ArcDesktop tools, instead the attribute value that is physically first in the database record (typically OBJECTID) is displayed. Currently, 3rd party feature re-formatting tools (such as X-Tools) will not allow you to adjust the physical ordering of the ESRI attributes (FID, OBJECTID or SHAPE) when reordering attributes of a feature class. It would be less confusing for users if this label can be configured to a more user friendly attribute value than OBJECTID.

‎10-19-2011

The NoSQL movement is pushing the threshold ahead in cloud based data management and storage to support the exponentially increasing massive data requirements we are seeing in the online world today. Yes, these technologies do not currently address all the ACID properties that RDBMS products support. Yes, these products are currently startup, incubator based, open source technologies and initiatives that are not currently standards based but I envision that these issues WILL be solved shortly and minimally these cloud based technologies can be in the short term integrated into portions of relational products that address certain performance critical areas such as data movement and caching. Oracle just announced BDA (Big Data Appliance) last week so this is already given. I see GIS with immense amounts of data as having one of the biggest needs for this. Some of the data paradigms involved like graph databases are a perfect fit for GIS and especially ESRI products in general. I would like to see a large GIS data project with a Hadoop type of map-reduce solution for the data movement portion along with a traditional relational transaction/business logic architecture for a backend geodatabase.

‎10-19-2011

Thanks Vince, The point I am trying make is that the NoSQL movement is pushing the threshold ahead in cloud based data management and storage to support the exponentially increasing massive data requirements we are seeing in the online world today. Yes, these technologies do not currently address all the ACID properties that RDBMS products support. Yes, these products are currently startup, incubator based, open source technologies and initiatives that are not currently standards based but I envision that these issues WILL be solved shortly and minimally these cloud based technologies can be in the short term integrated into portions of relational products that address certain performance critical areas such as data movement and caching. Oracle just announced BDA (Big Data Appliance) last week so this is already given. I see GIS with immense amounts of data as having one of the biggest needs for this. Some of the data paradigms involved like graph databases are a perfect fit for GIS and especially ESRI products in general. I would like to see a large GIS data project with a Hadoop type of map-reduce solution for the data movement portion along with a traditional relational transaction/business logic architecture for a backend geodatabase. I am sure such a project may be going on a this very moment. -Jim

‎10-17-2011

As a workaround, I am able to build this query into a query layer in ArcMap which can be saved as layer file or a layer in an MXD but cannot be saved as database object. So to use this outer join this MXD or layer must be used or the outer join query must be constructed by the user in a new query view layer but it would be nice if this layer definition can exist as a database object as opposed to an operating system file. As with the Spatial Views, only one geometry can be listed in the select list but the outer join selection of attributes can be done in this manner. -Jim

‎10-17-2011

Is there anyway to select multiple geometry columns in a spatial view for an outer join? I have several normalized feature classes and tables I need to join in spatial view and to show the multiple records. A spatial view is driven by the displyed geometries so to see both geometry columns but the sdotable command gives an error for more than one geometry column in a spatial view definition (I could try the prefered way for spatial views for ST_GEOMETRY columns of building a database view and registering it using sdelayer but I have not had any success building spatial views using this method!) The option would be to de-normalize and flatten these tables into one table but that would result in a huge number of redundant sparse columns from the join. We looked at using relationship classes and drill down into the normalized tables but our users would rather see one attribute table. Client: 10.0 Server: ArcGIS 9.2 Oracle 10g (10.2.5) -Jim

‎10-12-2011

Does ESRI have plans for supporting any of NoSQL (non-SQL?) alternative database platforms and/or architectures like Cassandra, BigTable, Neo4J, HBase, Tokyo Cabinet,..etc that are gaining popularity these days in the large data web application sites like Facebook, Twitter and Google? These Platforms appear to be well suited for flatter database designs (ie - web page history and such) with huge data throughput and performance requirements which also may not have as stringent transactional, business rule enforced or relational integrity requirements as with traditional hugely normalized databases in these high impact database areas. The reason I ask is that many of of the SDE geodatabase designs I have seen so far appear to have a flatter design with fewer layers of normalization than that of the large traditional non-spatial RDBMS enterprise databases. Also with ArcGIS provding much of the data integrity through it's own functionality with domains, topologies and relationship classes I would guess these new up and coming platforms could be of major interest. Sorry if I may seem a little ignorant in this area, but I have not yet attended any of the ESRI user conferences yet! -Jim

‎10-05-2011

I have tested this out and found when revoking all of these oracle privs except for CONNECT that ArcGIS editing functions are diminished. Specifically, when I try to import one or more excel spreadsheets into database tables in ArcCatalog I get a ArcDesktop 999999 error (generic error, contact your administrator...) for an SDE user. However, this import works fine when I add all those Oracle priviledges back to this user. I should try this out with FC moves and ArcMap versioning editing since I am unsure of this behavior with these activities. Is there a chart somewhere outlining the specific ArcDesktop editing ability and the exact set of Oracle system privaledges needed to perform these actions? The environment is complex since ArcGIS SDE uses sequences and temp tables and the like. My point is when all these priviledges are in place that SDE user can see all the user schemas in the entire Oracle database, which is not what we want. -Jim

‎10-03-2011

I am trying to make some static tables "invisible" owned by one SDE user from another SDE user (two GIS editor users) but cannot seem to do this. I use permissions "revoke edit and view" in ArcCatalog on the table to the other SDE user, and while it seems to execute, the table is still visible when I connect as that user. I try the equvalent operation using the sdetable - o revoke... command - same thing. The only think I can think is the SELECT ANY TABLE oracle system priviledge that I was told *MUST* be granted to any SDE user (along with the dozens of other privs) to use the ESRI environment (versioning...etc) is overriding any object level access you wish to control. Is this correct? If so, could the ESRI functionality be maintained without this one priv and using only the others (SELECT ANY SEQUENCE,..etc)? Or could this finer grain access and visibility be used for static readers only and all GIS editors would have to see everything in the instance? -Jim

‎09-19-2011

Are there any good enterprise ETL tools that would be recommended for moving data between data warehouse sized geodatabases? Specifically the types of products similar to IBM Data Stage and such where you would connect to multiple data sources, grpahically and tabularly specify and script out transformation rules,..etc. I know I could probably research this but would have to sift through and prototype tons of marketing literature, sales brochures and the like and figured this forum would be a good place to get the rundown on best products out there that have been used succesfully on large database projects. -Jim

‎09-19-2011

I am adding columns to a Feature Class DBMS table using an Oracle client. After commiting the change in Oracle (and verifying it was correct) I get the following error when I open the feature class in Arc Desktop: Could not load data from the data source. If you cannot correct the problem, press the refresh button to reload the data. Possible problems can include bad network connection, invalid field field, etc. Underlying DBMS Error [ORA-00904: "A"."{column name}"; invalid identifier] ... When I look up the error it seems that the column name may be invalid: http://www.dba-oracle.com/t_ora_00904_string_invalid_identifier.htm However it is not. I am getting this with any column I add in SQL. This makes no sense but I suspect something funky may be going on the SDE metadata to kick this off. This is not the case when adding the column manually in ArcCatalog to the FC fields in the peroperty tab but I have a lot of these these columns to add and would like to automate this. I am sure that there are scripts and methods in Python to do this but being an Oracle DBA I would do this quicker in an SQL script. Any clues? Oracle: 10.2 ArcGIS: 9.2 (via ArcDesktop 10.0) -Jim

‎09-01-2011

Oracle Client: 10.2.0.1.0 installed on the W7. I looked up the error in Oracle forums but it points to general tnsnames issue which if it were the cause then probably no clients should be able to connect then. Quite perplexing. -Jim

Online Status	Offline
Date Last Visited	‎08-03-2021 03:26 PM

My Ideas

Latest Contributions by JamesFox1

Re: Spatial View in a File GDB, is it materialized?

Spatial View in a File GDB, is it materialized?

Exporting a relationship class from an SDE to a file GDB

ArcMap Properties stored in SDE Geodatabase

Configurable Relationship Class Data Labeling

Cloud Database / NoSQL Support for SDE Geodatabase

Re: Any Plans for ArcGIS SDE Support for NoSQL Databases ?

Re: Can multiple geometry columns be selected in a spatial view for an outer join?

Can multiple geometry columns be selected in a spatial view for an outer join?

Any Plans for ArcGIS SDE Support for NoSQL Databases ?

Re: Revoking access to table/feature class owned by one SDE user from another SDE use

Revoking access to table/feature class owned by one SDE user from another SDE user

Any good SDE Geodatabase ETL Tools

Adding columns by SQL to a feature Class producing ORA-00904 ...

Re: Oracle Direct Connection failed for active Windows 7 client

Spatial View in a File GDB, is it materialized?

Exporting a relationship class from an SDE to a fi...

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

Configurable Relationship Class Data Labeling

ArcMap Properties stored in SDE Geodatabase