Tag Info

New answers tagged

0

The SDO_GEOR.getNODATA() function does not extract the NODATA cells. What it does it to show you how the NODATA cells are identified, i.e. the value, or range of values (or even multiple ranges possible) that identify a NODATA cell. You can achieve what you want using the Raster Algebra mechanism. Among other things that lets you select cells from a raster ...


0

Connecting to a linux database is absolutely no different from connecting to a database on Windows, or any other platform for that matter. The interconnect protocol (SQL*net) is the same everywhere. The platforms for the client and server play no role here, neither does the fact that one is 32-bit and the other is 64-bit. Also the versions of the Oracle ...


0

You have to take a look at your two data sets and find out some rule that defines if two buildings is the same. For instance you can check if the centroid of one epolygon is inside a polygon i the other layer. I am not familliar with the functions in Oracle vut I guess it is about the same as PostGIS. So, if you can use the method above it woild look ...


0

Assuming both tables use some building ID that is the same for a building in either table, something like SELECT [columns] FROM table_1 UNION SELECT [columns] FROM table_2 WHERE NOT EXISTS (SELECT 1 FROM table_1 WHERE table_1.BuildingID = table_2.BuildingID)


0

I was having the same (or similar) issue with simply reading from a database. I noticed as well that a non-spatial table was being added to the SDO_GEOM_METADATA table. To resolve it, I removed the table name from the OCI connection string. Since I had the two tables (joining a non-spatial to the spatial for the query) in the SQL, it still worked and I no ...



Top 50 recent answers are included