Questions tagged [st-geometry]

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

25 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
632 views

Update sde.st_geometry M values to cumulative distance (geometric length)

I'm trying to write a query to update sde.st_geometry M values to the cumulative length of a line. The M values in my route feature class are purely based on the geometric length of the line. The ...
2
votes
0answers
71 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....
2
votes
0answers
189 views

Esri ST_Geometry function to make line from points

I'm attempting to write a SQL statement that joins two point feature classes, both in an Oracle ArcSDE geodatabase using ST_Geometry, and selects a line geometry connecting the points of each ...
2
votes
0answers
706 views

How to insert a large feature using C# and ST_GEOMETRY in Oracle

I am using the st_polyfromtext command to insert features into an Oracle database like this: INSERT INTO polygon_test VALUES ( sde.st_polyfromtext ('polygon ((10.01 20.03, 10.52 40.11, 30.29 41.56, ...
2
votes
0answers
69 views

Why are ellipse polygones simplified when used in a FeatureService?

I have polygons with ellipse shape in a SDE Oracle ST_GEOMETRY geodatabase. All those polygons are correctly displayed when in a MapService. But when displayed in a FeatureService, some polygons ...
1
vote
2answers
24 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
0answers
22 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
vote
0answers
37 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
0answers
317 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 @...
1
vote
1answer
87 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
1answer
100 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 ...
1
vote
0answers
32 views

Optimal Way to Assign Most Popular Neighbor Variable in PostGIS

I've got a census block table in Postgres with the appropriate geom column and a string variable. All census blocks that have a population greater than 0 have an assignment for my string variable. ...
1
vote
0answers
55 views

How do I get the coordinates of the nearest point on a polygon?

The following SQL uses ST_Geometry to return a resultset of 10 records, ordered by distance from a fixed location (a point geometry) to the nearest point of the polygon. How do I get the coordinates ...
1
vote
0answers
332 views

Esri ST_Geometry functions too slow on Oracle

I'm writing an SQL statement to create a feature class and using st_geometry functions. But it's taking too long. So I begin the statement with a join, which is taking 150-200ms SELECT PRC.OBJECTID ...
1
vote
0answers
1k views

Can I retrieve row_to_json from PHP for a table in PostgreSQL?

I am able to retrieve JSON from a PostgreSQL database using this command: SELECT row_to_json(fc) FROM ( SELECT 'FeatureCollection' As type, array_to_json(array_agg(f)) As features FROM (SELECT '...
1
vote
0answers
248 views

SDE.ST_INTERSECTS fails to find point

The following query fails to find a point that is less than 3 meters from the buffered point: SELECT NODE_ID FROM ZLEVEL WHERE SDE.ST_INTERSECTS( ZLEVEL.SHAPE, SDE.ST_BUFFER(SDE.ST_POINT(...
1
vote
0answers
270 views

Convert Polygon exterior ring to points and linestring to points in SQL

I am try create materialized views in Oracle listing a polygon and linestring vertices with their longitude and latitude in separate columns. So I know I would need to count the vertices in each ...
1
vote
0answers
820 views

Spatial query by ESRI ST_Geometry take too long

I am using ESRI ST_Geometry in my application, and I found that the spatial query is rather slow: The following sql is used for query pois inside a certain bounding_box: select * from ( select ...
0
votes
1answer
14 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 ...
0
votes
0answers
22 views

Automatically move points so that they don't overlap (reposition into cluster pattern)

I have workorder points in a SDE.ST_GEOMETRY feature class (Oracle 18c/10.7.1. geodatabase). I serve up the point feature class to an external system via a Map Service. Problem: The workorder points ...
0
votes
0answers
36 views

Does ST_GeomFromText find exact matches for provided string or it finds similar, but not 100% same string?

SELECT * FROM centroids WHERE centroid = ST_GeomFromText('POINT (21.6198205 41.9418615)', 4326); Record have centroid geometry equal to POINT (21.619820510769063 41.94186153740355) Running on ...
0
votes
0answers
889 views

Using St_geometry in oracle 11g

We are using ST_Geometry for Oracle 11g at the moment. And we need to query features (points,lines,polygons in a view) inside a given extent(either a circle or a polygon or a rectangle), and we use ...
0
votes
0answers
39 views

How to model multiple topology classes in one query with ArcGIS

We have a lot of geographic data with different geometry type in our application, which are persisted in the Oracle 11g database with ST_Geometry supported by Arcgis SDE 10. The features can be ...
0
votes
0answers
528 views

ESRI ST_Geometry struct parse in java

I am trying to read and parse the ESRI ST_Geometry which is an oracle user defined type in java manually, and I follow this instructions, and it said that: .... Points: Contains the byte stream of ...
0
votes
0answers
286 views

Using Geometry commands in MS SQL Server 2008?

I am looking to find the most effect way to use SDE and ST_Geometry SQL commands. Can anyone tell me how/what commands I might use to perform a spatial query in MS Sql Server 2008, to Select ...