The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
0answers
33 views

Spatialite android trigger problem

I am developing an android application that uses the database spatialite, I use this project to integrate the database on android https://code.google.com/p/spatialite-android/ It works normally, ...
2
votes
1answer
98 views

plpgsql | before update trigger: insert the new pseudo-record in another record and leave the old one as it was

I've got the following table: CREATE TABLE alumbrado_puntos_luz ( id numeric(8,0), "GEOMETRY" geometry, revision_actual numeric(10,0), revision_expirada numeric(10,0), CONSTRAINT ...
1
vote
1answer
263 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, ...
2
votes
2answers
91 views

How to hand over polygon attribute to new point while digitizing?

My task is to work with bird observation data in an area, that is divided into zones as different polygons (A1, A2, etc.). I have the hand-written lists of observations and want to bring all entries ...
1
vote
2answers
351 views

Trigger to fill attributes (data, client ip) in table for each new objects, PostGIS

In PostgreSQL/PostGIS database stores shapefiles. Client users software - QGIS. Please help me write PostgreSQL/PostGIS trigger, which for each newly added/updated feature in layer added 'time create' ...
3
votes
1answer
128 views

PostGIS Trigger doesn't work

The trigger below don't works and I need that when a new pipeline (adutoras) is inserted or updated, the procedure check what are the municipalities (municipios) that intersects the pipes and put the ...
0
votes
1answer
138 views

Trigger on link length and filling attribute table

I create linear geometry in QGIS 1.8.0 (geometry stored in PostGIS 2.0). Help create trigger functions: in database should not be a lines less than 2 meters (linear geometry with length <2 meters ...