Questions tagged [st-geometry]
ST_Geometry is a data type that allows you to define columns that store spatial data
95
questions
0
votes
0answers
12 views
Oracle query to Update parcels street column with nearest street line using Esri ST_GEOMETRY
I want to update the parcels street column with nearest street layer, from the below image P1 street column should update with L1 and P2 street column update with L2. Using ST_Distance and I got the ...
1
vote
0answers
31 views
Filter collection of images with selected geometry
I am developing an application to analyze the images of the districts of a region.
I select the districts this way and it works fine (see image)
var selectd = ui.Select ({
items: Object.keys (...
1
vote
1answer
52 views
Query for ST_Geometry line vertices via a recursive SQL WITH clause?
I'm exploring ways to get ST_Geometry line vertices as individual rows in a query resultset (via Oracle SQL).
The reason being, ST_Geometry doesn't have a GetVertices function (see ESRI idea here).
...
3
votes
0answers
77 views
PostGIS Query using ST_Intersects not using spatial index
As code is better than 1000 words, here we go :
explain analyze SELECT DISTINCT(zones.office_id) AS office_id FROM "zones" JOIN offices ON zones.office_id = offices.id WHERE ST_Intersects('...
0
votes
2answers
73 views
Select specific attribute from SDE.ST_Geometry UDT? (without using accessor functions)
Oracle 18c; ArcGIS 10.7.1
I have an SDE.ST_Geometry polyline feature class.
As an experiment/learning exercise, I am trying to learn how to interact directly with the user-defined type (UDT) SHAPE ...
2
votes
1answer
22 views
What densification method does SDE.ST_Geometry use to approximate arcs as segments?
Oracle 18c; ArcGIS 10.7.1
I have an SDE.ST_Geometry polyline FC that has arcs.
In a related post, we established that true arcs/curves are only available to ArcObjects, whereas the actual geometry ...
0
votes
1answer
16 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 ...
2
votes
1answer
80 views
Convert ST_POINT subtype to ST_GEOMETRY supertype?
Oracle 18c; ArcGIS 10.7.1
I have a query that produces an ST_POINT column:
--Mimics the SDO_GEOMETRY get_vertices function
--https://docs.oracle.com/database/121/SPATL/sdo_util-getvertices.htm
...
1
vote
1answer
45 views
Why does SDE.ST_NUMPOINTS() add extra vertices for lines with arcs?
Oracle 18c/10.7.1 EGDB:
I have a polyline FC with a feature that has an arc.
I want to count the number of vertices in the line using the SDE.ST_NUMPOINTS() function.
select
sde.st_numpoints(...
1
vote
2answers
45 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
26 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 ...
0
votes
1answer
59 views
ST_GEOMETRY: spatial column must appear immediately after spatial relationship function for spatial index to be used
The docs for SDE.ST_GEOMETRY have a blurb that says the following:
When are spatial indexes used with ST_Geometry?
...the spatial column must appear immediately after the
spatial relationship ...
0
votes
0answers
16 views
How to insert the result of ST_Intersection into another column when the result has multiple geometry types [duplicate]
In PostGIS I have three tables table1, table2 and table3 of same type:
CREATE TABLE tableX
(
myid integer NOT NULL,
wkb_geometry geometry(LineString,4326)
)
table1 and table2 are populated. I ...
1
vote
1answer
91 views
ST_GEOMETRY points: get attribute of intersecting polygon
I have an SDE.ST_GEOEMTRY point feature class.
I want to create an SQL query from the points. The query would perform a spatial join/intersection with an SDE.ST_GEOMETRY polygon feature class. An ...
1
vote
1answer
45 views
Populating a table that uses a different geometry from another table of a different geometry
Does anyone know how I can populate a table that uses a different geometry from another table of a different geometry? (example geometry(points) -> geometry(Linestring) or geometry(polygon)
I'm new ...
0
votes
1answer
52 views
What system tables get INSERTS when registering object with Oracle EGDB (ST_Geometry)?
In ArcGIS Desktop, I can register ST_Geometry objects with the geodatabase (Enterprise 10.7.1; Oracle 18c):
Register with Geodatabase
Register feature classes, tables, views, and raster layers that ...
3
votes
5answers
214 views
Materialized view with FAST refresh on remote table: How to include a SHAPE column?
I want to create an Oracle materialized view with the fast refresh option on a remote table (in an enterprise GDB).
I can do this successfully without a SHAPE column:
create materialized view log on ...
1
vote
0answers
147 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
733 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
@...
2
votes
1answer
372 views
Calculate irregular polygon center-point that falls within the polygon boundary
I have an SDE.ST_GEOMETRY polygon FC in an Oracle 18c/10.7.1 geodatabase.
I can calculate the X and Y of the polygon centroids using the SDE.ST_GEOMETRY ST_Centroid function:
sde.st_x(sde....
2
votes
2answers
394 views
Snap a point to a line and get the line ID (Oracle Spatial or SDE.ST_GEOMETRY)
I have an Oracle 18c/10.7.1 geodatabase that has:
A sidewalk polyline feature class (existing features)
And a sidewalk inspection point feature class (the features are created via ArcGIS Collector/...
2
votes
1answer
5k views
Converting raster layer to simple feature in R [closed]
I have read my raster data using
r <- raster("F:\\Studies\\Whole2015.tif")
class(r)
> class(r)
[1] "RasterLayer"
attr(,"package")
[1] "raster"
How can I transform my data to simple feature?
I ...
2
votes
0answers
146 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
138 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
3answers
1k views
Converting SDE.ST_GEOMETRY polyline to SDO_GEOMETRY with SQL: Why are there so many nulls?
I have a SDE.ST_GEOMETRY column in an Oracle 18c/10.7.1 geodatabase.
I want to convert the SDE.ST_GEOMETRY shape column to SDO_GEOMETRY using SQL.
Steps:
Convert the SDE.ST_GEOMETRY shape column to ...
0
votes
2answers
217 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
722 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
236 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
396 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
265 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
545 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
118 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
153 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
159 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
46 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
2k 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
243 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
674 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
36 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
2k 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
288 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
61 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
571 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 ...
21
votes
1answer
5k 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 ...
asked Sep 10 '17 at 21:57
DPSSpatial_BoycottingGISSE
17.8k3 gold badges56 silver badges102 bronze badges
1
vote
0answers
391 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
538 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
126 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
1k 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
608 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
451 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 ...
