Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now
13

To easily understand these terms, let's use example of an online mapping service (say Google maps, Mapquest etc.) When you type an address or a placename in the searchbox and in return the map shows a marker at the place. The process of associating an address or a placename with coordinates on the map is called Geocoding. In a spatial database this is done ...


13

There are actually a number of ways of tracing any ArcSDE connection. Calls between the client application and the ArcSDE client are logged in the SDE Trace file, between the ArcSDE client and server in the SDE Intercept file, the ArcSDE server will log certain events in the service or direct connect log, and database calls are logged in the DBMS logfiles. ...


11

I see them as separate activities. Geocoding is the process of taking coded location information (such as addresses or grids) and turning it into explicit location information (X and Y coordinates, usually). Reverse geocoding is the opposite, taking XY data and locating the nearest address, grid, etc. Georeferencing is the process of taking a raster image ...


8

This question has been converted to Community Wiki and wiki locked because it is an example of a question that seeks a list of answers and appears to be popular enough to protect it from closure. It should be treated as a special case and should not be viewed as the type of question that is encouraged on this, or any Stack Exchange site, but if ...


7

The delta tables and state tree have a direct performance impact on your queries. First, you need to understand versioning; I did a short explanation of the relationship of the state tree and version labels in a different answer. I think it would help you to go over it. After reading that answer, you can then realize how a long state id branch (from root ...


7

Oracle Spatial has functions in SDO_UTIL-package which you can use to export sdo_geometry as GML, WKT etc. in your select statements.


7

At 10.1 they added geoprocessing tools to import/export XML workspace documents. At 10.0 you'd need to write something (see these: 1, 2) using ArcObjects, use Delete Rows beforehand, or use a more complex combination of geoprocessing tools and logic in Python (e.g. what X-Ray for ArcCatalog does).


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

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 ...


7

Managed to track down the answer. You can specify an ESCAPE character in query such as: MY_FIELD LIKE '____$_%' ESCAPE '$' This will search for exactly 4 characters followed by an underscore character plus anything else after that. Found the documentation on this page: http://desktop.arcgis.com/en/arcmap/10.3/map/working-with-layers/sql-reference-for-...


7

Oracle Spatial and Postgis both have their own pros and cons. While dealing with the spatial data Postgis always outperform Oracle Spatial. I have been working for last 2 year on Oracle Spatial and i recently switched to PostGIS, and i saw a huge performance difference in both of them. The reason why it perform much faster is because spatial data parsing. ...


6

The simlest tool for loading shapefile into oracle spatial database is provided by Oracle itself as Mapbuilder. You can download it from Oracle site. You need to register (free) once with Oracle. You need to connect to your database where you want to save the shapefile and choose the Import Shapefile as option as shown below: Then you need to browse and ...


6

The "multiversion" name is somewhat misleading. Every versioned feature class has three tables in the database: The business/base table (this is the table that you could query directly) The additions table (something like A100) The deletes table (something like D100) Any changes in the current version will be in the 'A' table and deletions in the 'D' ...


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

My abbreviated take: Georeferencing involves fitting an image to the Earth based on matching up visual features of the image with their known location. Input: Imagery, Image control points, Matching geospatial control points Output: Image with data attached showing how it fits onto the globe Geocoding involves converting some human placename or label into ...


5

Create your own primary key field (like 'id') - if using Oracle Spatial 11g then see the best practices for Oracle Locator and Spatial (11g) Particularly important Metadata, tolerance and coordinate systems Every SDO_GEOMETRY column in a table requires an entry in the Oracle Locator metadata dictionary, USER_SDO_GEOM_METADATA. The metadata entry includes ...


5

At least two things can cause this - maybe more. The views should be added to Oracle's own spatial metadata catalog. This has been discussed a few times on MapInfo-L, see http://groups.google.com/group/mapinfo-l/browse_thread/thread/8088c4afeadeb1c6?pli=1. The other problem could be that you don't have a primary key in your view. For MapInfo Pro to be able ...


5

There are various functions you can use to get the minimum bounding rectangle in Oracle Spatial: SDO_GEOM.SDO_MBR SDO_MIN_MBR_ORDINATE SDO_MAX_MBR_ORDINATE There are lots of examples here: http://www.spatialdbadvisor.com/oracle_spatial_tips_tricks/55/oracle-locator-vs-enterprise-licensing-the-sdogeom-package in section 2, which hopefully will help. It ...


5

The easy way is to select * from user_sdo_geom_metadata or select * from all_sdo_geom_metadata. This isn't as thorough as pecoanddeco's answer would provide but if your metadata is up to date it's pretty good. Note that individual geometry rows can have different SRIDs from the metadata (although that will break spatial indexing). For geometry types your ...


5

Esri has no control over Oracle licensing policy, they just allow you to use the SDO_GEOMETRY datatype, as provided by Oracle. Some of the SDO accessor functions require more than just Locator. Your determination of what is sufficient should really be based on what SQL manipulation you require, since Esri doesn't use more than SDO_FILTER.


5

The 'sdeexport' command accepts a WHERE clause flag (-w). Just set it to 1=0, and the resulting export file will be empty. Note that an 'sdeimport' of the resulting file will not have any ArcGIS metadata, or ArcGIS anything (feature datasets, domains,...), so you really don't want to do this unless you have a bunch of simple feature classes created with ...


5

In ArcGIS for Desktop, you can use the tool Densify. Adds vertices along line or polygon features. Also replaces curve segments (Bezier, circular arcs, and elliptical arcs) with line segments.


5

ArcGIS has supported 64-bit Oracle 11g since 9.3.1. In fact, ArcGIS Server has been exclusively 64-bit since 10.1 was released (Desktop continues to be 32-bit, so that might be the cause of this confusion). Configuring the SDE.ST_GEOMETRY custom datatype for use with Oracle 11g clients other than ArcGIS requires up to four steps: Installing the datatype (...


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

If you have a materialized view with a geometry column, you don't need to "create a spatial view" -- it's already created! At this point you have two options: Use the materialized view as a Query Layer Register the view with your enterprise geodatabase Unfortunately, in the crush to retire ArcSDE application servers and the admin utilities that let users ...


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

It is your plan to "add a sde.st_geometry user-defined type" that means you will need ArcGIS Server (of which ArcSDE is a component) licensed. If that is a mandatory requirement then your most cost effective (but still very expensive, for personal budgets) option may be the EDN. For an effectively free Database Server (Desktop) (formerly called ...


4

[First post apologies: This is meant to be a comment not a definitive answer.] If you have any edit versions that are relatively old and have not been posted they should be deleted, posted or reconciled. An old unreconciled version keeps an old view of default, which prevents delta records belonging to newer versions from being compressed into the base ...


4

The UNION ALL does not perform the same as what you want to achieve. Like the manual says, it is really an alternative to a combined mask. For example, the "+" in expression "MASK=INSIDE+COVEREDBY" stands for an inclusive OR, and so can be replaced by a UNION ALL, that also represents an inclusive OR. But you want to do something else: you want to find out ...


4

Rather than use the Oracle tools (which if they're anything like anything Oracle I've ever seen are a completely mess), you could try using OGR2OGR - There is a GUI app for it too - http://www.ogr2gui.ca/en/screenshot.php Hopefully that'll do what you want and be simpler as well.


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