Questions tagged [st-geometry]

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

19 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
554 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
29 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
176 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
668 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
1answer
38 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
41 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
28 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
49 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
269 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
220 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
252 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
777 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
0answers
34 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
854 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
483 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
280 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 ...