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