Contents
How does St _ geometry work in ArcGIS Desktop?
ST_Geometry constructs a geometry from a well-known text representation. When creating spatial tables that will be used with ArcGIS, it is best to create the column as the geometry supertype (for example, ST_Geometry) rather than specifying an ST_Geometry subtype, such as ST_LineString.
How to use Esri’s St geometry in SDO?
One possible solution is to get ESRI’s ST_Geometry into a WKT or WKB notation, then use that to construct SDO_GEOMETRY objects. Something like this (assuming table SHAPES contains a column called SHAPE of type sde.ST_Geometry:
How to create table shapes with sde.st _ geometry?
Something like this (assuming table SHAPES contains a column called SHAPE of type sde.ST_Geometry: Now the catch is that this will not have any spatial index, so will be very slow to display and impossible to use with any spatial query. Maybe then you can create a copy instead, in a new table: Then setup the usual metadata and spatial index.
How to create a spatial table in ArcGIS?
When creating spatial tables that will be used with ArcGIS, it is best to create the column as the geometry supertype (for example, ST_Geometry) rather than specifying an ST_Geometry subtype, such as ST_LineString. Use optimized point construction when performing batch inserts of large numbers of point data.
How to change the spatial reference of St _ geometry?
If the data is stored in a database (rather than a geodatabase), do the following to change the spatial reference of the ST_Geometry data: Create a backup copy of the table. Create a second (destination) ST_Geometry column on the table.
How is the St transform function used in ArcMap?
The ST_Transform function is then used in an UPDATE statement to take the linestring in ln1, convert it from the coordinate reference assigned to SRID 4326 to the coordinate reference assigned to SRID 3857, and place it in column ln2. SRIDs 4326 and 3857 have the same geographic datum.
Where does the SRID go in St _ transform?
If you created a spatial index on the spatial column in an Oracle database, the SRID at the time the spatial index was created is written to the st_geometry_columns table. Using ST_Transform to alter the SRID of the ST_Geometry data does not update the SRID in the sde_geometry_columns or st_geometry_columns table.
When to use optimized point construction in ArcMap?
Use optimized point construction when performing batch inserts of large numbers of point data. These examples create a table (geoms) and insert point, linestring, and polygon values into it. Create a table, radii, and insert circles into it. Create a table, track, and insert ellipses into it. Create a table, pwedge, and insert a wedge into it.