Questions tagged [st-geometry]
ST_Geometry is a data type that allows you to define columns that store spatial data
114
questions
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 ...
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 ...
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 ...
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,
...
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 ...
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 ...
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))), ...
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....
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 ...
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 -...
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 ...
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?
...
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....
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 = &...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 (...
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).
...
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('...
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 ...
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 ...
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 ...
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
...
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(...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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
@...
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....
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/...
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 ...
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....
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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
...
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 ...