Tag Info

New answers tagged

2

Following functions exist in Oracle: SDO_CS.MAP_EPSG_SRID_TO_ORACLE SDO_CS.MAP_ORACLE_SRID_TO_EPSG So SELECT SDO_CS.MAP_ORACLE_SRID_TO_EPSG(xxx) FROM dual; yields: 90112 -> null 327680 -> 31300 8307 -> 4326 (Weird that 90112 isn't mapped...)


0

I eventually found the cause (and solution) to this problem, and wanted to share them in case someone ran into a similar situation. In my sql snippet included in my original post, you can see that I am attempting to filter out null geometries (N.SHAPE IS NOT NULL). Eventually I found that the table had geometries that were not truly null, but had no ...


0

Save the syntax below to a file with a .sql extension (ie: C:\TEMP\get_table_privs.sql). Then log into SQL*Plus as the owner of the table you want to see the privileges for and execute the script. Hope this helps. -ST ------------------------- -- GET_TABLE_PRIVS.SQL -- ------------------------- select table_name from sde.layers where owner = USER union ...


2

It looks like EZConnect can't connect for whatever reason (3a works/3b doesn't). You can try adding "ezconnect" to NAMES.DIRECTORY_PATH in the sqlnet.ora file. Hopefully that will make 3b from @Albert Godfrind's answer work. The LDAP connection may fail from QGIS because you have something like the Oracle Instant Client somewhere in the path before your ...


2

Those sort of issues can be hard to track. My approach would be to remove QGIS and SDE from the picture and make sure the connection works with plain Oracle tools. That will also help your IT support debug the issue. 1) Do: $ tnsping <tns_name> Does this work ? Or does it fail the same way 2) Do: $ tnsping ...


0

If you have the same issue GDAL can be a good aproach.. Please take a look on http://www.gdal.org/ogr2ogr.html http://www.gdal.org/ogr/drv_oci.html import cx_Oracle # Import osgeo try: from osgeo import ogr, osr, gdal print "Import success!" except: sys.exit('ERROR: cannot find GDAL/OGR modules') # To connect to oracle ...


0

If you have SSRS that implies you must have a SQL database instance to support it. I would copy the oracle data into a table in that SQL instance (e.g. using SSIS), and then update a geography column in that SQL table from the text lat and long. You will probably also want a spatial index on top of that for performance.


0

You can use GeoRaptor in SQLDeveloper to validate SDO geometry and the generate a SQL script to rectify those errors. GeoRaptor will provide the exact ORA error. You can also validate metadata through GeoRaptor and with bad metadata, ArcGIS can have issues drawing the feature.



Top 50 recent answers are included