I have a set of linked tables. Last of them has geometry column. I need to get data from this set of tables by some criteria (including geometry intersection). The idea is to apply intersection analysis on the last step to speed up query. So I do filtration by all criteria except intersection: SELECT table1.someColumn,… Read More PostgreSQL(PostGIS): Calling ST_Intersects for result of WITH clause

i have the below posted tables. the relation is one to many. single site could has different operations and single operation is to be applied on a single site at a time. therefore, the primary key of the table Site will be a foreign key in the table operation. but what i want to have… Read More how to make row unique in one to many relation

i want to set a default value to a geometry column indicates that it is null or empty.for example, a string initially is initialized to null or "" to indicate being void/empty. what is the equivalent to null/empty for geometries. what is the value to be set to a geometry column inidicates that it is… Read More What is the suitable value to initialize an empty column of type geometry