11

Yes, absolutely, you can do that. The principle is to define a function-based index. The steps are like this: Assume I have a table like this: create table customers ( id number primary key, name varchar2(30), longitude number, latitude number ); 1) Define a function that transforms the long and lat columns into a geometry. Note that should any of ...


11

One way of doing it: Close ArcGIS and ArcCatalog. In SQL Developer (Oracle 11g), the sequence of any Oracle table, if registered with the Geodatabase, will be created by SDE under a name similar to this one: 'R5834' If you click in SQL Developer onto the tab 'Other Users' and then onto the 'SDE' user, you should be able to see the table 'TABLE_REGISTRY'. ...


8

I was asked this question today ("How do I identify if a featureclass has curves) and was given some arcpy code suggestions. Modify the following code as you see fit (a flag variable instead of a message for example) geometries = arcpy.CopyFeatures_management("inputFeatures", arcpy.Geometry()) import json for g in geometries: j = json.loads(g.JSON) ...


8

In short, unsaved/temporary edits in ArcGIS geodatabase are stored in a table, specifically Delta tables also know as A (add) & D (delete) tables based on the information I'm aware of and researched. In Esri's Registering as versioned with the option to move edits to base If you decide to register a feature dataset, stand-alone feature class, or table ...


8

By default the auto commit interval is set to 1000. You can change the interval using the following: arcpy.env.autoCommit = 5000


7

This problem has to do with spatial index. When you export the data into a new workspace, be it a file geodatabase or a shapefile, the export process creates a new feature class in the target workspace. The new feature class is then assigned a spatial index according to the default environment variables in your ArcGIS. There are some rules when setting ...


7

Business rules vs data integrity rules When you model your database, you specify the business logic in two spaces: a. The data integrity rules. This includes among others having an integer column so users won't be able to enter strings. b. The business domain rules. This includes having check/unique/foreign key constraints on columns so it won't be ...


6

Postgis, spatialite and Qgis mainly use GDAL/Proj definitions with EPSG codes as ID for CRS. You find a lot of them at spatialreference.org, but that database is a bit outdated. For Dutch RD, there is EPSG:28991 Amersfoort/RD Old EPSG:28992 Amersfoort/RD New Oracle used their own SRID up to release 10.1, and switched to EPSG codes as of release 10.2 ...


6

Oracle DBMS is is capable of storing spatial data either through custom formats (like Esri) or native (Oracle Spatial). This means it is worth learning for GIS Analyst because you will be able to interact with the DBMS either by using SQL/PLSQL/spatial SQL functions (for analysis and data retrieval, and you can do a lot with those spatial functions without ...


6

No, it is not possible to directly edit Query Layers (in any database) using the standard graphical editing tools of ArcMap/arcpy (as if they were shapefile, file geodatabase, or enterprise-enabled feature classes). The underlying ArcSDE technology is the mechanism that permits both versioned and non-versioned editing of database tables -- No ArcSDE, no ...


5

It looks like you are hitting a known issue. NIM034235 IFieldChecker.ValidateTableName should check that table names do not exceed the workspace's maximum number of characters. mackayj80 describes the issue in this Esri blog post.


5

In GIS applications, often times the SELECT * FROM portion of the SQL expression is typically supplied for you, effectively leaving the user to just enter the WHERE clause. Additionally, applications often abstract the SQL language to make it easier for their customers to use & understand (who may not know the ANSI SQL standards), choosing to implement ...


5

Keep in mind what you are doing -- You are asking the database to return all features within the display envelope AND whose ids are in the first 1000. And you are likely doing so with a spatial constraint first option. Yes, it is very normal to see poor performance under such circumstances. Best practice for rendering very large tables is not to. This ...


5

You actually have to install both 32bit and 64bit Oracle clients to get everything working properly. The article you show in your screenshot is referencing ArcGIS desktop (not the background processing), which is still a 32bit program. You will have to have the 32bit client to connect with ArcGIS Desktop and other 32bit programs. You'll also need the 64bit ...


5

Just because Oracle supports the creation of custom objects in the database doesn't mean that all clients will be able to read their values. In this case, your PyODBC client doesn't know how to unpack the SDE.ST_GEOMETRY column type, so it hasn't told Oracle how it will handle geometry, and Oracle is generating the error saying it hasn't been told how to ...


5

The solution depends on the geometry of your layer. Point Geometries For points you can access the X and Y co-ordinates directly: update TABLE1 s1 set X = s1.GEOMETRY.SDO_POINT.x,y=s1.geometry.sdo_point.y Polygon, Multi-point SDO_UTIL.GETVERTICES will return all vertices of your geometry, and your previous query would fail if the geometry had more than ...


5

I have researched that when you add a new SDE feature class through your Oracle connection in ArcCatalog, these are the SDE tables to be affected: -SDE.COLUMN_REGISTRY -SDE.GDB_FIELDINFO -SDE.TABLE_REGISTRY -SDE.GDB_OBJECTCLASSES -SDE.GDB_FEATURECLASSES -SDE.LAYERS -SDE.GEOMETRY_COLUMNS Actually you can also check the above list, if you have 'admin' ...


5

I'll start with a declaimer: I've cobbled this info together from various scraps of documentation that I found on various ESRI pages. I'm not a geodatabase developer or XML developer, so it's very possible that I've missed the mark here in some way. The Solution: Extract the XML from the DEFINITION field from SDE.GDB_ITEMS_VW. In this example, for simplicity,...


5

By default, yes, it normally is unless someone overrode that and designed the table differently. Is this an ArcSDE database? There may also be GlobalID fields that act as primary keys across multiple databases with relationship tables, so that may add some complications. You are correct; there can only be one primary key. However, with the right ...


5

As already suggested by user30184: Go in the global settings and switch the logging level to GEOTOOLS_DEVELOPER_LOGGING, see http://docs.geoserver.org/latest/en/user/configuration/globalsettings.html#config-globalsettings Look in the logs for details about the queries being run, either directly on $GEOSERVER_DATA_DIR/logs/geoserver.log or from the web UI, "...


4

If anyone is still interested in this, it was fixed at Version 10.1. ESRI Technical Support Number: NIM070156 and NIM062420 http://support.esri.com/en/bugs/nimbus/TklNMDcwMTU2 http://support.esri.com/en/bugs/nimbus/TklNMDYyNDIw


4

All ArcPy does is provide hooks in to the normal ArcGIS desktop. Just like desktop once you have a connection it will keep it open until it is explicitly closed by ArcGIS (usually when the associated python windows are closed). As for the drivers it will use the drivers you installed for ArcGIS to connect to your ArcSDE/RDBMS


4

Find the registration ID: SELECT T.REGISTRATION_ID , T.TABLE_NAME FROM SDE.TABLE_REGISTRY T WHERE T.TABLE_NAME LIKE '%YOUR_TABLE%' (let's say the registration ID is 555). Build this statement: SELECT SDE.VERSION_USER_DDL.NEXT_ROW_ID('OWNER_NAME', 555) FROM dual


4

Not sure why the question got "voted down". Thanks for the constructive input. Anywho, for those that understood the question, or are facing a similar challenge, here is/are the solution/s that was/were reached, tested, and proven to work. Summary It was the connection property parameter names. DB_CONNECTION_PROPERTIES vs. ...


4

The DBA is probably using Oracle's standard administration tools and console (Enterprise Manager / Grid Control). That console will highlight the high consumers in terms of number of SQL statements executed, rows fetched, CPU or IO consumption, etc. It also highlights the top SQL statements in the same way. To find out the details of what statements get ...


4

This is the question/response I got from oracle's spatial expert in Europe in 2014. q: Does oracle have the concept of an empty geometry? If so can you give me an example? Would this be a valid way of creating an empty point? SDO_GEOMETRY(2001, NULL, SDO_POINT_TYPE(NULL, NULL, NULL), NULL, NULL) My initial reaction was there is no such thing as an empty ...


4

I think the answer is no. The OBJECTID in an Oracle geodatabase table does not have a primary key constraint , by default. When I query an Oracle geodatabase table to return the column that has a primary key constraint, the OBJECTID is not returned/flagged: SELECT cols.table_name, cols.column_name, cols.position, cons.status, cons....


4

The best resource I've come across to provide an answer is Esri's Not registered as versioned or unregistering data as versioned There are no ways I'm aware of redoing/undoing edits in unregistered tables. However, this resource provides further insight as to possibly finding a solution. ....As mentioned above, your data is initially not registered as ...


4

Manually trace what the database does: Create a test table: In SQL Developer,: create table test_table ( field1 varchar2(255) ); In ArcCatalog: Register the table with the Geodatabase Register the table as versioned, with the option to move edits to base. In SQL Developer, run this query: Note: I need ensure that I use a connection that has ...


4

You can double-click one of those objects. That bring up a little pencil icon on the side. Clicking that brings up an "edit" window that shows the object content. That works fine for points. Hard to read when you deal with complex lines or polygons. Note that for points, you can get the X and Y values easily like this: select id, p.location.sdo_point.x as ...


Only top voted, non community-wiki answers of a minimum length are eligible