Skip to main content

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
0 votes
0 answers
25 views

Get vertex of SDE.ST_GEOMETRY polygon using SQL

Oracle 18c 10.7.1 EGDB: I want to write a SQL query that has rows with the XY coordinates of each vertex of an SDE.ST_GEOMETRY polygon feature class. I can do it for a line FC using a cross join, a ...
User1974's user avatar
  • 1,172
0 votes
1 answer
20 views

ST_GEOMETRY SQL function to find problem annotation shapes

ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB; SDE.ST_GEOEMTRY: I have a issue with an annotation feature class: In 2.9.12, I get a "shape integrity error" when I open the attribute table and ...
User1974's user avatar
  • 1,172
0 votes
0 answers
53 views

SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended"

I was trying to update one table based on the spatial join table. When I try to run following code: UPDATE p SET p.mileage = ip.length_unusually FROM PIPELINE p JOIN ...
Nimisha Wagle's user avatar
0 votes
0 answers
31 views

SRID in ST_Geometry fails to update with ‘Define Projection’ but Esri feature class CRS does update

I need to re-define (not reproject) a CRS for a feature class in an enterprise geodatabase (SQL Server). When I use the 'Define Projection' in AGS Pro (2.9.5), the CRS shown in Esri states the proper ...
Rex's user avatar
  • 596
0 votes
0 answers
18 views

Access control point vertices using SQL

ArcGIS Pro 3.2.1; Oracle 18c 10.7.1 EGDB; SDE.ST_GEOMETRY Regarding control points: Video: Suppress symbol effect in ArcGIS Pro Introduction to control points CIMGeometricEffectAddControlPoints Class ...
User1974's user avatar
  • 1,172
2 votes
0 answers
44 views

Is there any PostGIS st_makevalid equivalent for use in Esri's sde.st_geometry?

I am inserting into an Enterprise Geodatabase (Postgres running sde.st_geometry). I am encountering errors on inserts when a multipolygon has parts with a zero-area. I know of Desktop's Repair ...
Andrew Nelson's user avatar
0 votes
1 answer
430 views

Joining tables with GROUP BY in ArcGIS Pro

I have a layer "Table1" and an attribute table "Table 2" both stored in a PostgreSQL enterprise geodatabase, these 2 data have one field in common for which the cardinality of the ...
MAR's user avatar
  • 183
1 vote
1 answer
162 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 ...
User1974's user avatar
  • 1,172
5 votes
2 answers
1k 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 ...
User1974's user avatar
  • 1,172
0 votes
0 answers
75 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 ...
User1974's user avatar
  • 1,172
1 vote
0 answers
221 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, ...
User1974's user avatar
  • 1,172
0 votes
1 answer
182 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 ...
User1974's user avatar
  • 1,172
0 votes
1 answer
83 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 ...
User1974's user avatar
  • 1,172
2 votes
1 answer
261 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))), ...
User1974's user avatar
  • 1,172
0 votes
1 answer
707 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....
User1974's user avatar
  • 1,172
0 votes
1 answer
260 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 ...
User1974's user avatar
  • 1,172
0 votes
4 answers
1k 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 -...
User1974's user avatar
  • 1,172
1 vote
1 answer
406 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 ...
User1974's user avatar
  • 1,172
0 votes
1 answer
452 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? ...
User1974's user avatar
  • 1,172
0 votes
1 answer
71 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....
User1974's user avatar
  • 1,172
3 votes
1 answer
262 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 = &...
User1974's user avatar
  • 1,172
0 votes
0 answers
119 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 ...
User1974's user avatar
  • 1,172
1 vote
0 answers
64 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 (...
Ricardo Vicari's user avatar
1 vote
1 answer
451 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). ...
User1974's user avatar
  • 1,172
3 votes
0 answers
490 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('...
LondonUnderground's user avatar
0 votes
2 answers
474 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 ...
User1974's user avatar
  • 1,172
2 votes
1 answer
118 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 ...
User1974's user avatar
  • 1,172
0 votes
1 answer
49 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 ...
User1974's user avatar
  • 1,172
2 votes
1 answer
401 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 ...
User1974's user avatar
  • 1,172
1 vote
1 answer
84 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(...
User1974's user avatar
  • 1,172
1 vote
2 answers
111 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 ...
User1974's user avatar
  • 1,172
2 votes
1 answer
102 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 ...
User1974's user avatar
  • 1,172
0 votes
1 answer
219 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 ...
User1974's user avatar
  • 1,172
0 votes
0 answers
18 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 ...
Michael S's user avatar
  • 101
1 vote
1 answer
663 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 ...
User1974's user avatar
  • 1,172
1 vote
1 answer
334 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 ...
Felix Chan's user avatar
0 votes
1 answer
105 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 ...
User1974's user avatar
  • 1,172
3 votes
5 answers
499 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 ...
User1974's user avatar
  • 1,172
1 vote
1 answer
1k 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 ...
Doc's user avatar
  • 131
1 vote
0 answers
2k 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 @...
jossefaz's user avatar
  • 237
2 votes
1 answer
1k 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....
User1974's user avatar
  • 1,172
2 votes
2 answers
733 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/...
User1974's user avatar
  • 1,172
2 votes
1 answer
14k 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 ...
Fang's user avatar
  • 43
2 votes
0 answers
715 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....
Shev's user avatar
  • 43
3 votes
1 answer
907 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 ...
User1974's user avatar
  • 1,172
1 vote
3 answers
3k 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 ...
User1974's user avatar
  • 1,172
0 votes
2 answers
492 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 ...
User1974's user avatar
  • 1,172
1 vote
1 answer
2k 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 ...
MCline's user avatar
  • 13
1 vote
1 answer
536 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 ...
Ayaz49's user avatar
  • 428
0 votes
1 answer
889 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 ...
Rayner's user avatar
  • 3,721