Questions tagged [st-geometry]
ST_Geometry is a data type that allows you to define columns that store spatial data
64
questions
0
votes
0answers
26 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 where
Toad: SDE.ST_GEOMETRY(1,1,666666.0,4444444.5,666666.0,4444444.5,NULL,NULL,...
2
votes
1answer
41 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
31 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
33 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
399 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
139 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
351 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
25 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
808 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
179 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
47 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
232 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
2k 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
245 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
314 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
814 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
504 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
320 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
435 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
596 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
207 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
172 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
198 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
521 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
594 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
455 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
493 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
231 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
169 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
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
781 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
189 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
595 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
234 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 ?
0
votes
0answers
806 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
38 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 ...
1
vote
0answers
747 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
453 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 ...
2
votes
1answer
8k views
Bulk inserting with Python and cx_Oracle into st_geometry enabled table?
I'm trying to make a bulk insert of a CSV file with Python and cx_Oracle into an st_geometry enabled table of an Oracle database with ArcSDE.
I could do it with the method execute() of cx_Oracle but ...
1
vote
1answer
403 views
Precision loss when trying to select the latitude and logitude coordinates from an sde.ST_GEOMETRY using SDE.STX() and SDE.STY() functions
In an oracle 11g enterprise geodatabase I am trying the following:
INSERT INTO MySTATION (STATION_ID, DB_VERSION_NU, CREATED_DT, MOD_DT, SHAPE)
VALUES (1, 0, sysdate, sysdate, SDE.ST_GEOMETRY('...
1
vote
1answer
546 views
Use Hibernate with Oracle and Esri St_geometry type
Can anyone tell me whether I could use Hibernate with esri ST_GEOMETRY type?
I have found that Hibernate Spatial does support SDO_Geometry, but nothing for ST_Geometry.
I am using oracle 11g and ...
4
votes
5answers
883 views
How do you generate WKT from a graphic drawn on a map?
All,
In order to do some quick analysis using SQL spatial, I'd like to generate spatial objects using the STGeomFromText / ST_GeomFromText function.
With point data, I can do this by geocoding an ...
3
votes
1answer
528 views
Adding ST_GEOMETRY column to existing table that already has X Y columns?
I have created and Oracle 11g geospatial geodatabase and have create an arcsde connection.
I have been connected using arcmap, as a simple user (not sde or schema-user), who has all the proper rights ...
