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
2 votes
0 answers
40 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
284 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
135 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,114
5 votes
2 answers
865 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,114
0 votes
0 answers
56 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,114
1 vote
0 answers
191 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,114
0 votes
1 answer
144 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,114
0 votes
1 answer
67 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,114
2 votes
1 answer
217 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,114
0 votes
1 answer
575 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,114
0 votes
1 answer
179 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,114
0 votes
4 answers
796 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,114
1 vote
1 answer
330 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,114
0 votes
1 answer
306 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,114
0 votes
1 answer
64 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,114
3 votes
1 answer
227 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,114
0 votes
0 answers
100 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,114
1 vote
0 answers
63 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
345 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,114
3 votes
0 answers
448 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
379 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,114
2 votes
1 answer
98 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,114
0 votes
1 answer
41 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,114
2 votes
1 answer
358 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,114
1 vote
1 answer
76 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,114
1 vote
2 answers
103 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,114
2 votes
1 answer
85 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,114
0 votes
1 answer
199 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,114
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
510 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,114
1 vote
1 answer
261 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
100 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,114
3 votes
5 answers
448 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,114
1 vote
1 answer
742 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
  • 197
2 votes
1 answer
801 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,114
2 votes
2 answers
609 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,114
2 votes
1 answer
12k 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
588 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
2 votes
1 answer
675 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,114
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,114
0 votes
2 answers
411 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,114
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
473 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
805 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,711
1 vote
1 answer
620 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 ...
User1974's user avatar
  • 1,114
2 votes
1 answer
1k 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 ...
User1974's user avatar
  • 1,114
0 votes
1 answer
184 views

Selecting the SHAPE column in Toad

I've noticed that SQL clients select the SHAPE column from SDE.ST_GEOMETRY in different ways: select shape from roads Toad: SDE.ST_GEOMETRY(1,1,666666.0,4444444.5,666666.0,4444444.5,NULL,NULL,NULL,...
User1974's user avatar
  • 1,114
2 votes
1 answer
260 views

ST_3DIntersection PostGIS incorrect result

I have tried multiple times to obtain the 3D Intersection between a 3D linestring and a solid cube in both PostGIS 2.5.2 and 2.5.3 with the SFCGAL backend. Below is a query that works as expected and ...
pawarit28's user avatar
1 vote
1 answer
308 views

Measuring area covered by linestring

I have a trajectory given by GPS which I store as a ST_LineString() and I'd like to know the area covered by the line string. I know the "width" of the trajectory, but I'm not sure how to approach the ...
Jan J's user avatar
  • 21