All Questions
14 questions
0
votes
0
answers
73
views
QGIS how to improve triggers on SQL - SpatiaLite
I'm looking for a way to improve the way my triggers are working on a SpatiaLite layer.
Currently, it takes 45 seconds to work on 1000 entities. Is there a way to improve the performance?
My triggers ...
- 825
1
vote
0
answers
62
views
Refresh attribute table after SQL trigger
I'm utilizing a trigger on a SpatialLite layer in QGIS.
This trigger is designed to update a field when its content matches with another in the database.
Here's the trigger's code:
CREATE TRIGGER ...
- 825
3
votes
1
answer
145
views
Date management problem in a trigger with PostgreSQL [closed]
I created two tables on PostgreSQL.
I would like to note in a layer a date and retrieve:
the corresponding year in a variable,
then reuse the year variable in various other attributes integrating ...
- 1,015
1
vote
0
answers
21
views
How can I round numeric area values in PostGIS? [duplicate]
I am using a trigger function in PostGIS to calculate the area in hectare of each polygon that is created or changed. The field is called "flaeche_ha_gis", the datatype is "double"....
- 2,385
2
votes
1
answer
541
views
PostGIS trigger : table and materialized view
I have a PostGIS polygons table for my "cities".
I have a point table for my "boreholl".
I created a "mv" materialized view defined by a spatial join as follows:
SELECT ...
- 919
1
vote
0
answers
110
views
ST contains not working properly with trigger
I have table1, on which people do regular inserts, and table2, that needs to get updated based on what was inserted to table1.
table1 has
id integer
type text
ref text
geom polygon ...
- 2,350
2
votes
1
answer
687
views
Perform intersection using a TRIGGER
I've two geometry table inside my DB:
buffer: id INTEGER SERIAL PRIMARY KEY, geom POLYGON
polygons: geom MULTIPOLYGON
I need have the intersection between buffer and polygons and I will do this ...
- 970
3
votes
1
answer
786
views
Trigger PostGIS QGIS
I have 2 layers on PostGIS: a point layer named 'tdia' and a polygon layer named 'com':
-the com layer contains the city name. (Polygon)
-the tdia layer contains bus stops. (point)
I want to create a ...
- 1,015
0
votes
0
answers
63
views
Automatically Trigger write fields from polygon to point when adding point
When editing, I would like to create an SQL trigger that will write fields from my parcels layer to a point layer that the end user is editing.
Essentially, when a point is placed on a parcel, that ...
- 31
1
vote
1
answer
2k
views
Updating PostgreSQL geometry column using SQL (Trgger)
I'm looking to inderstand the role of date_part('epoch'::text, now()) WHERE id=NEW.id; in the trigger function below.
CREATE OR REPLACE FUNCTION fn_test_table_geo_update_event() RETURNS trigger
AS $...
- 35
1
vote
1
answer
13k
views
Postgresql Trigger to insert records in my table from another one
I spent few days trying to resolve this question but it was impossible.
I have two tables:
Table1.
CREATE TABLE point
(
id_point integer NOT NULL DEFAULT,
layer text,
elevation numeric,
...
- 145
3
votes
1
answer
1k
views
Triggers for delta tables
I have been facing an issue to capture the delta updates on SDE.
We have written triggers on A and D tables to capture the delta updates(to capture the version name based on state id's), however I ...
- 31
2
votes
1
answer
5k
views
Trigger a python script to run after a row is added to the feature class
I have a Python script which runs on a SDE feature class daily (as a scheduled task). I would actually like this script to run whenever a new row is added to the feature class (data is captured in the ...
- 4,055
4
votes
3
answers
4k
views
Trigger on SQL Server 2008 ArcSDE 10 and ArcGIS Server 10
I need to build a sql server db trigger to update a date field with the current date when a record is inserted or updated, I think. I will be using the date field as a way to recognize updates/...
- 3,398