Questions tagged [plsql]

Procedural Language/Structured Query Language

Filter by
Sorted by
Tagged with
1 vote
1 answer
126 views

Update geometries with ST_UnaryUnion at TRIGGER

We are currently working on database with multipolygons and we're using QGIS 3. Sometimes it's very useful to work with parts (each page of document is separate part of multipolygon), however at the ...
Krakatau's user avatar
  • 117
1 vote
1 answer
2k 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 ...
User1974's user avatar
  • 1,132
0 votes
1 answer
301 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 ...
User1974's user avatar
  • 1,132
4 votes
1 answer
3k views

Creating polygons (squares) from point using PostGIS?

I want to create a regular grid of polygons/squares from this point knowing that between two successive points 100 meters, so each square would have 100*100 m2 in its area.
malyon's user avatar
  • 55
-3 votes
1 answer
4k views

ERROR: syntax error at or near "group" LINE 4: ...E ST_DWithin [closed]

I'm writing an SQL query but I am getting a syntax error on the line with the GROUP BY. What can possibly be the problem? UPDATE intersection_points i SET nbr_victimes = sum(tue+bl+bg) FROM ...
malyon's user avatar
  • 55
0 votes
0 answers
153 views

View With SDO_GEOM Function for ArcMap

I have a table of boundaries(polygons) which need to be served up through ArcGIS Server with their centroids(points). I'm using Oracle spatial and thought the most efficient way of doing this was to ...
user1567453's user avatar
7 votes
0 answers
201 views

Is it possible to add an ArcGIS attachment to a row in Oracle using oracle stored procedures? [closed]

So far I have been able to attach files to features within a featureclass using the python tools and ArcObjects. Within Oracle I have been able to add features with geometries using the ST_Geometry ...
sb92's user avatar
  • 79