Questions tagged [st-geometry]

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

Filter by
Sorted by
Tagged with
1
vote
0answers
24 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
32 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
1answer
265 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
127 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
322 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
24 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
693 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
168 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
44 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
216 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
225 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
300 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
98 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
738 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
478 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
306 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
418 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
557 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
201 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
948 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
163 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
187 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
503 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
569 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
427 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
2k 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
472 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
224 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
168 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
743 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
182 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
567 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
231 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
787 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
737 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
446 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 insert 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
400 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
538 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
854 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
516 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 ...
2
votes
1answer
1k views

How to create a shapefile or gml from a Oracle database using SDE.ST_Geometry?

I have a ORACLE database 10g(Oracle Database 10g Enterprise Edition Release 10.2.0.3.0) with a SDE.ST_Geometry field and i want to make a program in python so i can create several shapefiles based on ...
3
votes
1answer
1k views

Can't select geometry from Oracle DB using SQL

I'm trying to select the geometry field from an ArcSDE feature class in an Oracle 11g database (inside of a Python script via PyODBC). This is my query: SELECT SHAPE FROM USR.FEAT_CLASS This is ...