Questions tagged [st-geometry]

ST_Geometry is a data type that allows you to define columns that store spatial data

Filter by
Sorted by
Tagged with
1 vote
1 answer
52 views

How many vertices does a SDE.ST_GEOMETRY rectangle have?

SDE.ST_GEOMETRY; Oracle 18c; 10.7.1 EGDB How many vertices does a SDE.ST_GEOMETRY rectangle have? (Drawn using the rectangle construction tool in the Create Features pane in ArcMap 10.7.1.) The ...
user avatar
  • 798
4 votes
2 answers
304 views

Why do single-part WKT polygon vertices require double parentheses?

Regarding the WKT standard: Wikipedia: Well-known text representation of geometry Why do single-part polygon vertices require double parentheses? That seems inconsistent with single-part points and ...
user avatar
  • 798
0 votes
0 answers
22 views

Construct ST_GEOMETRY rectangle from two vertices: lower-left and upper-right

Oracle 18c SDE.ST_GEOMETRY 10.7.1 EGDB: I have two vertices of a rectangle: Lower-left: 10,10 Upper-right: 100,100 I want to construct a rectangle polygon from those two vertices using ST_GEOMETRY ...
user avatar
  • 798
1 vote
0 answers
95 views

Get map to use function-based spatial index (ST_GEOMETRY)

SDE.ST_GEOMETRY — Oracle 18c — ArcMap/EGDB 10.7.1: I have a view that returns the startpoint of lines as an ST_GEOMETRY column: create or replace view bc_atn_startpoint_vw as ( select objectid, ...
user avatar
  • 798
0 votes
1 answer
33 views

Equivalent to USER_SDO_GEOM_METADATA for SDE.ST_GEOMETRY

Background - SDO_GEOMETRY: If I were to create a function-based spatial index that returns an SDO_GEOMETRY, I would manually insert records into SDO_GEOMETRY's USER_SDO_GEOM_METADATA for these ...
user avatar
  • 798
0 votes
1 answer
15 views

Polyline endpoint query layer in ArcGIS Pro

I have an Oracle 18c/SDE.ST_GEOMETRY polyline FC (15,000 features). I want to create a query layer (or db view) that will display the startpoints and endpoints of the lines in ArcGIS Pro. Is there a ...
user avatar
  • 798
0 votes
1 answer
71 views

Improve performance of startpoint query (ST_GEOMETRY)

I have a SDE.ST_GEOMETRY query in an Oracle 18c EGDB that gets the startpoint of polylines: select objectid, sde.st_geomfromwkb(sde.st_asbinary(sde.st_startpoint(sde.st_geometryn(shape,1))), ...
user avatar
  • 798
0 votes
1 answer
39 views

Select SDE.ST_GEOMETRY as JSON text (using SQL)

I have a multipart M-enabled SDE.ST_GEOMETRY polyline FC (in an Oracle 18c EGDB): Using SQL, I want to select the geometry as JSON text: {"hasM":true,"paths":[[[0,5,0],[10,10,11....
user avatar
  • 798
0 votes
1 answer
40 views

ST_GEOMETRY feature class: Add a hidden SDO_GEOMETRY column

I have an SDE.ST_GEOMETRY FC in an Oracle 18c EGDB. I want to use Oracle Spatial functions on the data (calculate polyline midpoint, M-values, dynamic segmentation, etc.). Ideally, I'd convert the ...
user avatar
  • 798
0 votes
4 answers
156 views

Convert M-enabled SDE.ST_GEOMETRY to SDO_GEOMETRY using SQL

I have an M-enabled SDE.ST_GEOMETRY polyline FC in an Oracle 18c EGDB. select sde.st_astext(shape) as st_to_wkt from test_st_geom MULTILINESTRING M (( 0.0 5.0 -100000.0, 10.0 10.0 -100000.0, 30.0 0.0 -...
user avatar
  • 798
1 vote
0 answers
74 views

Conditionally skip field calculation for certain rows

Regarding the field calculator in the ArcGIS Pro 2.9 attribute table (Python): Is there a way to skip calculating a certain record, if certain conditions are met in the script? For example, if the ...
user avatar
  • 798
0 votes
1 answer
38 views

How does SDE.ST_LENGTH() get calculated?

I have an Oracle 18c SDE.ST_GEOMETRY polyline FC. The lines in the FC have true curves. If I query for the length of the lines in SQL using SDE.ST_LENGTH(SHAPE), how does the length get calculated? ...
user avatar
  • 798
0 votes
1 answer
51 views

Select feature parts and vertices as rows

I have a Oracle 18c SDE.ST_GEOMETRY FC that has multi-part polylines. I want to select the parts and vertices as individual rows in a query: Since we don't have a GetVertices() function in SDE....
user avatar
  • 798
3 votes
1 answer
91 views

Editing vertex without removing true curves using ArcPy

ArcMap 10.7.1 — Oracle 18c SDE.ST_GEOMETRY I have a polyline FC that has true curves. And I have an ArcPy script that updates the M-values of the vertices in the lines: import arcpy connection = &...
user avatar
  • 798
0 votes
0 answers
28 views

What column is true curve data stored in? (SDE.ST_GEOMETRY for Oracle)

I have an Oracle 18c SDE.ST_GEOMETRY polyline FC: The lines in the FC have true curves (aka CAD BLOBs). Question: What column is the true curves data stored in? @Vince mentioned in a comment that ...
user avatar
  • 798
0 votes
0 answers
32 views

Update vertex via SQL — without reconstructing shape

ArcGIS 10.7.1 — Oracle 18c GDB — SDE.ST_GEOMETRY I have a multipart polyline in an SDE.ST_GEOMETRY FC. I want to update the coordinates of a specific vertex with a known value — via SQL. I believe it ...
user avatar
  • 798
0 votes
0 answers
25 views

Preserve arcs/curves when converting SDE.ST_GEOMETRY to SDO_GEOMETRY via SQL

ArcGIS 10.7.1; Oracle 18c GDB I have an SDE.ST_GEOMETRY polyline FC that has lines with arcs: In an SQL query, I want to convert the ST_GEOMETRY shape to SDO_GEOMETRY. I can do the conversion by ...
user avatar
  • 798
0 votes
0 answers
15 views

SDE.ST_GEOMETRY function returns negative infinity

ArcMap & Enterprise 10.7.1 — Oracle 18c SDE.ST_GEOMETRY — SQL Developer 18.1.0.095 I have an SDE.ST_GEOMETRY polyline FC that is M-enabled: I can query for the M-value of the endpoint of the ...
user avatar
  • 798
0 votes
0 answers
26 views

Use SDE.ST_GEOMETRY functions in Select by Attributes window

ArcGIS Desktop & Enterprise 10.7.1 — Oracle 18c — Polyline FC registered as versioned (with base). Background: I want to use Oracle SDE.ST_GEOMETRY functions in the Select by Attributes window in ...
user avatar
  • 798
0 votes
0 answers
13 views

Oracle query to Update parcels street column with nearest street line using Esri ST_GEOMETRY

I want to update the parcels street column with nearest street layer, from the below image P1 street column should update with L1 and P2 street column update with L2. Using ST_Distance and I got the ...
user avatar
1 vote
0 answers
38 views

Filter collection of images with selected geometry

I am developing an application to analyze the images of the districts of a region. I select the districts this way and it works fine (see image) var selectd = ui.Select ({ items: Object.keys (...
user avatar
1 vote
1 answer
96 views

Query for ST_Geometry line vertices via a recursive SQL WITH clause?

I'm exploring ways to get ST_Geometry line vertices as individual rows in a query resultset (via Oracle SQL). The reason being, ST_Geometry doesn't have a GetVertices function (see ESRI idea here). ...
user avatar
  • 798
3 votes
0 answers
126 views

PostGIS Query using ST_Intersects not using spatial index

As code is better than 1000 words, here we go : explain analyze SELECT DISTINCT(zones.office_id) AS office_id FROM "zones" JOIN offices ON zones.office_id = offices.id WHERE ST_Intersects('...
user avatar
0 votes
2 answers
112 views

Select specific attribute from SDE.ST_Geometry UDT? (without using accessor functions)

Oracle 18c; ArcGIS 10.7.1 I have an SDE.ST_Geometry polyline feature class. As an experiment/learning exercise, I am trying to learn how to interact directly with the user-defined type (UDT) SHAPE ...
user avatar
  • 798
2 votes
1 answer
44 views

What densification method does SDE.ST_Geometry use to approximate arcs as segments?

Oracle 18c; ArcGIS 10.7.1 I have an SDE.ST_Geometry polyline FC that has arcs. In a related post, we established that true arcs/curves are only available to ArcObjects, whereas the actual geometry ...
user avatar
  • 798
0 votes
1 answer
20 views

Multi-part ST_GEOMETRY: Does the feature-part array start at 1 or 0?

Oracle 18c; ArcGIS 10.7.1 I have an SDE.ST_GEOMETRY polyline FC that has multi-part features. Question: What method does ArcGIS use to assign numbers to the feature-parts in the array? Do the part ...
user avatar
  • 798
2 votes
1 answer
150 views

Convert ST_POINT subtype to ST_GEOMETRY supertype?

Oracle 18c; ArcGIS 10.7.1 I have a query that produces an ST_POINT column: --Mimics the SDO_GEOMETRY get_vertices function --https://docs.oracle.com/database/121/SPATL/sdo_util-getvertices.htm ...
user avatar
  • 798
1 vote
1 answer
52 views

Why does SDE.ST_NUMPOINTS() add extra vertices for lines with arcs?

Oracle 18c/10.7.1 EGDB: I have a polyline FC with a feature that has an arc. I want to count the number of vertices in the line using the SDE.ST_NUMPOINTS() function. select sde.st_numpoints(...
user avatar
  • 798
1 vote
2 answers
61 views

Does SDE.ST_LENGTH() calculate the true length of arcs?

Oracle 18c/10.7.1 EGDB I have a polyline FC that has features with arcs. Does the Oracle SDE.ST_LENGTH() function calculate the true length of arcs? Or does it only calculate the straight-line length ...
user avatar
  • 798
1 vote
1 answer
44 views

Select SDE.ST_GEOMETRY polylines that have arcs?

Oracle 18c/10.7.1 EGDB: I have an SDE.ST_GEOMETRY polyline feature class. Some of the polylines in the feature class have arcs. Question: Is there a way to use Oracle SDE.ST_GEOEMTRY functions to ...
user avatar
  • 798
0 votes
1 answer
85 views

ST_GEOMETRY: spatial column must appear immediately after spatial relationship function for spatial index to be used

The docs for SDE.ST_GEOMETRY have a blurb that says the following: When are spatial indexes used with ST_Geometry? ...the spatial column must appear immediately after the spatial relationship ...
user avatar
  • 798
0 votes
0 answers
16 views

How to insert the result of ST_Intersection into another column when the result has multiple geometry types [duplicate]

In PostGIS I have three tables table1, table2 and table3 of same type: CREATE TABLE tableX ( myid integer NOT NULL, wkb_geometry geometry(LineString,4326) ) table1 and table2 are populated. I ...
user avatar
  • 101
1 vote
1 answer
177 views

ST_GEOMETRY points: get attribute of intersecting polygon

I have an SDE.ST_GEOEMTRY point feature class. I want to create an SQL query from the points. The query would perform a spatial join/intersection with an SDE.ST_GEOMETRY polygon feature class. An ...
user avatar
  • 798
1 vote
1 answer
72 views

Populating a table that uses a different geometry from another table of a different geometry

Does anyone know how I can populate a table that uses a different geometry from another table of a different geometry? (example geometry(points) -> geometry(Linestring) or geometry(polygon) I'm new ...
user avatar
0 votes
1 answer
63 views

What system tables get INSERTS when registering object with Oracle EGDB (ST_Geometry)?

In ArcGIS Desktop, I can register ST_Geometry objects with the geodatabase (Enterprise 10.7.1; Oracle 18c): Register with Geodatabase Register feature classes, tables, views, and raster layers that ...
user avatar
  • 798
3 votes
5 answers
286 views

Materialized view with FAST refresh on remote table: How to include a SHAPE column?

I want to create an Oracle materialized view with the fast refresh option on a remote table (in an enterprise GDB). I can do this successfully without a SHAPE column: create materialized view log on ...
user avatar
  • 798
1 vote
1 answer
227 views

I need to remove Z dimension on spatial column (ST_GEOMETRY) with Esri on Oracle using the PL/SQL packages

I need to remove Z dimension on spatial column (ST_GEOMETRY) with Esri on Oracle using the PL/SQL packages I need to do the following, but using the ESRI PL/SQL packages on Oracle. I have used a ...
user avatar
  • 131
1 vote
0 answers
936 views

Error while creating PostGIS entity with Hibernate and GeometrySerializer : No qualifying bean of type 'GeometryParser<?>'

I tried to create a simple application with a geometry persistent layer (Spring boot with hibernate-spatial) Here is my Entity class : // Annotations from lombok project @NoArgsConstructor @...
user avatar
  • 187
2 votes
1 answer
455 views

Calculate irregular polygon center-point that falls within the polygon boundary

I have an SDE.ST_GEOMETRY polygon FC in an Oracle 18c/10.7.1 geodatabase. I can calculate the X and Y of the polygon centroids using the SDE.ST_GEOMETRY ST_Centroid function: sde.st_x(sde....
user avatar
  • 798
2 votes
2 answers
438 views

Snap a point to a line and get the line ID (Oracle Spatial or SDE.ST_GEOMETRY)

I have an Oracle 18c/10.7.1 geodatabase that has: A sidewalk polyline feature class (existing features) And a sidewalk inspection point feature class (the features are created via ArcGIS Collector/...
user avatar
  • 798
2 votes
1 answer
6k views

Converting raster layer to simple feature in R [closed]

I have read my raster data using r <- raster("F:\\Studies\\Whole2015.tif") class(r) > class(r) [1] "RasterLayer" attr(,"package") [1] "raster" How can I transform my data to simple feature? I ...
user avatar
  • 43
2 votes
0 answers
206 views

Get length of a line stored in SQL Server Geometry column with srid 4326

I have some spatial data stored in SQL database geometry column called sp_geography (The field is defined as Geometry). The SQL below: f.sp_geography.STLength() returns, for example 0....
user avatar
  • 33
1 vote
1 answer
177 views

How to generate a Street View URL/hyperlink using SQL? (UTM to WGS84)

I have a point feature class in an Oracle 18c GDB that is projected as NAD83 UTM 17N (SRID = 26917). I would like to extract the X&Y coordinates from the points as WGS84 latitude & longitude ...
user avatar
  • 798
1 vote
3 answers
2k views

Converting SDE.ST_GEOMETRY polyline to SDO_GEOMETRY with SQL: Why are there so many nulls?

I have a SDE.ST_GEOMETRY column in an Oracle 18c/10.7.1 geodatabase. I want to convert the SDE.ST_GEOMETRY shape column to SDO_GEOMETRY using SQL. Steps: Convert the SDE.ST_GEOMETRY shape column to ...
user avatar
  • 798
0 votes
2 answers
271 views

Convert X & Y columns to a SHAPE column (using a method that would perform well in Portal)

I have a non-spatial table in an external system. The table has X & Y columns. The table will be synced to an Oracle 18c/10.7.1 geodatabase table or FC (via the ArcGIS REST API). There will be ...
user avatar
  • 798
1 vote
1 answer
898 views

Convert PostgreSQL geometry to Esri ST_Geometry

I am trying to create a spatial view in ArcMap where I run a ST_Intersect against a ST_Geometry point dataset and a PostgreSQL geometry polygon dataset. Both datasets are the same SRID. I am having ...
user avatar
  • 13
1 vote
1 answer
283 views

How to find nearest neighbor in Oracle's ST_GEOMETRY?

I am trying to find nearest road segment to a point in Oracle. I can do this with SDO_GEOMETRY type i.e select /*+ LEADING(pois) INDEX(route ALL_ROUTES_SPTAIL_INDEX) */ route.* from DEVICE_STATUS ...
user avatar
  • 418
0 votes
1 answer
499 views

Use PHP form to insert geometry from WKT into SQL Server 2017

I have a PHP 7.3 form that asks the user for a Name, a WKT and an SRID. I would like to upload the WKT and SRID to SQL Server 2017 so that it creates a geometric object in Upload_WKT_Test using ...
user avatar
  • 3,643
1 vote
1 answer
341 views

Use SDE.ST_GEOMETRY functions in a custom function

I have a dummy query where I generate an SDE.ST_GEOMETRY point: select shape as srid_test from ( select sde.st_geometry ('point (10.01 50.76)', 4326) as shape from ...
user avatar
  • 798
2 votes
1 answer
655 views

Get midpoint of SDE.ST_GEOMETRY polylines?

I have a polyline SDE.ST_GEOMETRY feature class in an Oracle 12c geodatabase (10.7.1). I want to create a view on the feature class that has X and Y columns that contain the coordinates of the ...
user avatar
  • 798