Browse by Tags
All Tags »
SDE (
RSS)
In my previous post I overviewed some important issues concerning st_geometry. You saw all kind of cool things you can do in simple sql queries. In order to use these queries you need to do some additional configurations to your database after you install sde. In here you can find instructions of how to do this. Example of Net configuration of st_geometry in linux: listener.ora: LSNR_MYDB = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myDbSeverUrl)(PORT =...
In the last couple of months we have been using the new st_geometry type of the ArcSDE geodatabase. St_geometry allows us to use simple queries in order to retrieve and manipulate geographic layers. For example: 1: select * from buildings b 2: where sde.st_intersects(b.shape,st_point( 'POINT (35.122 32.999)' ,1) = 1; This query will return all the buildings that intersects the point (35.122,32.999). St_geometry is available from version 9.2 of ArcSDE (ESRI recommends to use st_geometry from...
A long time ago I presented a problem : How can you migrate from Oracle 9i with SDE 9.1 to Oracle 10g with SDE 9.2 . After a long time I have found a solution. This solution was suggested to me by Tom Brown from ESRI. In his visit in Israel Shani and I had a rare chance to meet him and ask him a couple of questions. This was one of them. And now, I will present the solution : In order to perform the migration you need to follow these steps : Definitions : Source : Oracle 9i + SDE 9.1 Destination...
In our project, we have two users in the database : applicative user and strong user. The strong user is the owner of all the objects (tables,layers,sequences, etc...) and the applicative user has only limited privileges for the object in the strong user. When creating a new database table, you only have to run the grant SQL command on the table to give the access privileges to the app user. When creating a new layer, you just can't only give privileges to the table which represents the layer...
There are two ways to create a view : Through ArcSDE command line commands. A toolbox tool in ArcCatalog. In order to use it, open the toolbox in ArcCatalog -> Data Management -> Layers and Table views -> Make Table View, and follow the wizard (for more information, check out the ArcGIS 9.2 Desktop Help ). In order to create the view, you need to use the command sdetable : sdetable -o create_view -T < view name > -t < table list separated by comma > -c < column names from...
I would like to present a problem I had when it was decided that our GIS application needed a new version of the geographic database. Let me explain : Our geographic database includes two components : Oracle database : version 9i. ESRI's SDE component : version 9.1. We decided that it was time to use the new versions of these components (Oracle 10g,SDE 9.2) so we can use their new features. We had no experience doing these sort pf thing, so I was assigned (As the team's applicative DBA) to find a...
ArcSDE (Spatial Database environment) is a software product from ESRI which handles geographic databases. I like to think about it as another tier which wraps all the access to the geographic features that are stored in the database. When you want to access some geographic data , SDE generates queries which access the geographic tables and retrieves the data. After this very short intro, a question raises : How do know which queries and which operations SDE performs on the database ? This is critical...