Questions tagged [st-geometry]
ST_Geometry is a data type that allows you to define columns that store spatial data
73
questions
2
votes
0answers
25 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
1answer
34 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
2answers
56 views
Converting SDE.ST_GEOMETRY polyline to SDO_GEOMETRY with SQL: Why are there so many nulls?
I have a SDE.ST_GEOMETRY polyline FC in an Oracle 18c/10.7.1 geodatabase.
I want to convert the SDE.ST_GEOMETRY shape column to SDO_GEOMETRY using SQL.
Reason: So that I can do linear referencing ...
0
votes
2answers
64 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
1answer
55 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
1answer
50 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
1answer
51 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
1answer
77 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
1answer
125 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 ...
0
votes
1answer
76 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,...
2
votes
1answer
57 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 ...
1
vote
1answer
39 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 ...
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 ...
1
vote
1answer
663 views
Convert geometry set to simple features collection using `sf` in R
How can geometry set objects be converted to simple features collection objects with the package sf in R? I want to add attribute data to the geometry but am prevented from doing so because geometry ...
3
votes
1answer
163 views
create spatial view in postgis on an ArcGIS table with ST_Geometry type
I am working on PostgreSQL 9.4.5 with Postgis 2.2.3.
I work on a spatial table created on ArcGIS, with geometry type "ST_POINT". I would like to create a spatial view of that table in postgreSQL ...
0
votes
2answers
423 views
query to check srid of features in feature class? [duplicate]
What query should I use to check the SRID of the features in a feature class? The storage type of the feature class in st_geometry?
I tried the following query but no luck :
select top 1 [...
1
vote
0answers
26 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. ...
5
votes
1answer
997 views
STContains always returns 0 when i query from table. But same data works when I manually create a polygon geometry object and select
I'm new to sql geometry. I've a table that stores polygon or multipolygon in a column. Below given a sample stringified row. Latitude, longitude, geom columns respectively
36.846642 -119.613123 ...
1
vote
1answer
195 views
st_geometry syntax for Oracle Sql
I'm trying to pass in a geometry(polygon) collected as an ESRI.ArcGIS.Client.Geometry.Geometry type on a map and passing it as an IN parameter into an oracle sql query. I'm also trying to use ...
1
vote
0answers
48 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 ...
0
votes
1answer
298 views
Creating point from lat / lon values stored in two fields?
I'm trying to create a point from latitude & longitude values stored in two fields (lat, lon). I need to perform a transform to get the point from its source coordinate system into the coordinate ...
17
votes
1answer
3k views
Is it ok to group by geometry in PostGIS?
Is it OK to group by geometry?
We do a lot of counting points by polygon geometries, which involves intersecting the data first in order to count instances of students. by school boundary, block ...
1
vote
0answers
263 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 ...
4
votes
2answers
353 views
How is the st_length function stored in an Oracle geodatabase?
How is the st_length function stored in an Oracle geodatabase? Is it in a:
PL/SQL function
Separate .dll library
Somewhere else?
I've noticed that the sde.st_length function works, even when the ...
1
vote
1answer
103 views
Postgresql ST_Point problem (Can't see point symbol on map)
i am using Arcgis for Server and Arcgis Portal webmaps with Postgresql db.
Created a Feature Class with ArcCatalog and shared as Feature Service, so i am trying to add data to this Feature Class with ...
0
votes
1answer
894 views
Use a sde.st_geometry function in a PL/SQL trigger
I have a PL/SQL trigger:
1 create or replace trigger "projects_to_meas_trig" before update of asset_id
2 on projects
3
4 for each row
5 declare
6 v_length number;
7 begin
8 ...
1
vote
2answers
522 views
Enabling Enterprise Geodatabase in BigSQL Postgres 9.5.x install and ArcGIS Server/Desktop?
I have followed Esri's ArcGIS 10.5 documentation multiple times over: http://desktop.arcgis.com/en/arcmap/10.5/manage-data/gdbs-in-postgresql/setup-geodatabase-postgresql-windows.htm
Every time I try ...
2
votes
1answer
354 views
What is ST_Geometry, ST_Curve and ST_Surface on PostGIS?
I dont't have any experience with geographics databases so I hope that you be patiente with me, so I opened this question (PostGis and datatypes WKT) in the past week about the datatypes in the ...
3
votes
1answer
477 views
How do I get a list of coordinates from a polygon?
I have a table with polygon geometries and need to get a list of polygon vertices. Using select sde.st_astext(geometry_column) from table_name; I can get the WKT representation of the polygon but I'd ...
7
votes
1answer
710 views
Get ArcMap to recognize ST_POINT (SDE.ST_GEOMETRY)
I have a sde.st_geometry line feature class called ROADS. I've created a view using a st_geometry function called st_startpoint which returns an st_point column. st_point is a subclass of st_geometry; ...
0
votes
1answer
224 views
Get XML from Oracle sde.st_geometry SHAPE column using SQL
How can I access the XML contents of the SHAPE column of a feature class in sde.st_geometry/Oracle? I want to access the XML using SQL so that I can ultimately directly query the vertices that make up ...
1
vote
1answer
1k views
function st_within(sde.st_geometry, geometry) does not exist
If I run the following query in PostgreSQL 9.2 I get the geometry:
select st_geomfromtext('POLYGON((-123.13974380493164 49.258142464379425,-123.11695575714111 49.25450118750378,-123.11914443969727 49....
0
votes
1answer
185 views
Get PL/SQL definition of SDE.ST_GEOMETRY functions
I'd like to learn how to write PL/SQL spatial functions for use in an Oracle ST_GEOMETRY geodatabase. And I figure, the best way to learn something is to start with something that works, thoroughly ...
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
214 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(...
3
votes
0answers
548 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
1answer
676 views
SQL for spatial view of line start/end points (Oracle ST_GEOMETRY)
How do I create a spatial view that generates dynamic point geometry of the start point and end point of a line feature class?
I have successfully made a similar view that is a buffer of a line ...
1
vote
1answer
496 views
Control number of segments in ST_Buffer for geographies?
I've been attempting to construct circles centered around a list of points in PostGIS with good success. I've opted to circumvent having to look up UTM zones and using optimal SRID by simple letting ...
3
votes
2answers
3k views
Using geometry or point for postgis
I have a table with points that has lon/lat, i am adding postgis to my app. I am doing some tests and I found type POINT and type GEOMETRY. I want to convert my columns lon and lat to a point. For ...
2
votes
1answer
3k views
How to convert a Shape (SDE.ST_GEOMETRY) to Latitude and Longitude?
A table Oracle have a Shape field of type SDE.ST_GEOMETRY, I want to convert it to latitude and longitude.
I need the Latitude and Longitude to build dynamic maps on Google Maps.
I saw on the ...
3
votes
1answer
561 views
Get the geometry type of an empty ArcSDE feature class
I'm trying to use raw SQL to get the geometry type (e.g. POINT, LINESTRING, POLYGON) of an Oracle ArcSDE feature class using the ST_Geometry spatial type. If I run
SELECT SDE.ST_GeometryType(SHAPE) ...
1
vote
0answers
245 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 ...
2
votes
0answers
175 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 ...
1
vote
1answer
3k views
ST_GEOMETRY to SDO_GEOMETRY
Is it possible for QGIS to read ESRI ST_GEOMETRY in an Oracle database? The ESRI geometry type looks like this:
SDE.ST_GEOMETRY(260,61,491455.9942,5456922.8891,492388.3189,5457507.9101,NULL,NULL,NULL,...
2
votes
0answers
828 views
How to convert the BLOB value for the features geometry of type st_geometry kept in ArcGIS databse on Oracle [closed]
I am using ArcGIS Oracle database and I am trying to access feature geometry points as string. But the problem is that the points are kept as blobs and I can't convert to meaningful string.
select ...
3
votes
2answers
202 views
Do I need to use ESRI's Create Spatial Type functionality
Does anyone know if I need to use ESRI's Create Spatial Type functionality when creating a field in a non ESRI / non geodatabase Oracle 11g database?
I have an older customer database in Oracle. ...
0
votes
1answer
632 views
function st_length3d(geometry) does not exist
Whenever I execute this query:
SELECT ST_Length3D(ST_GeomFromEWKT('LINESTRING(0 0 0,5 0 3,5 10 5)'));
Postgresql is throwing an error:
ERROR: function st_length3d(geometry) does not exist SQL ...
1
vote
2answers
3k views
Querying Oracle geometry data type
How to query or find the geometry data type a given Oracle Database is using in SQL Developer (i.e. SDO_Geometry, ST_Geometry, etc)?
I thought I could just describe a feature class within the ...
2
votes
1answer
1k views
What is the difference between ST_GEOMETRY and WKT?
What is the difference between ST_GEOMETRY and WKT? Is ST_GEOMETRY just a database type and WKT (well-known text) is a textual representation of the data?
0
votes
1answer
248 views
It possible to query/convert LONG RAW (SDEBINARY) from SQL?
Curently we have ArcSDE 9.3/Oracle10, and layers in SDEBINARY.
It is possible to make queries with SDE.ST_GEOMETRY or SDO_GEOMETRY commands ?
