Skip to main content

All Questions

Tagged with
Filter by
Sorted by
Tagged with
0 votes
1 answer
107 views

PostgreSQL and extension tablefunc with enumerated type

In PostgreSQL, I created an enumerated type CREATE TYPE w_sebio.t_sebio_type_sad as ENUM ('transféré', 'traité', 'non soumis', 'ouvert', 'non traité','PAC réalisé'); then a table CREATE TABLE w_sebio....
fcka's user avatar
  • 1,015
5 votes
1 answer
210 views

Selecting N points within each geometry using SQL

I have grid and point tables in my Postgres db. The points are not equally distributed over the grid. The grid table is 100k+ geometries and the points are in the 100's of millions so efficiency ...
RedM's user avatar
  • 1,653
0 votes
1 answer
540 views

Joining tables with GROUP BY in ArcGIS Pro

I have a layer "Table1" and an attribute table "Table 2" both stored in a PostgreSQL enterprise geodatabase, these 2 data have one field in common for which the cardinality of the ...
MAR's user avatar
  • 183
2 votes
1 answer
112 views

Identify groups of stacked geometries in PostGIS

I need to create a column in my PostGIS table with values identifying different groups of stacked/duplicate geometries, such that one group of stacked geometries might get a value of 1, another group ...
user2642365's user avatar
7 votes
1 answer
467 views

GROUP BY on geography in postgres 9.4.0 returns wrong/different results

table definition: CREATE TABLE search ( id bigserial NOT NULL, location geography(Point,4326) NOT NULL, location_aggregated geography(Point,4326) NOT NULL, created timestamp with time zone ...
Michael K.'s user avatar
0 votes
2 answers
458 views

PostgreSQL/PostGIS - group by series of values

I need to sum up linear objects' length and to group them by intervals of several years. I have one table storing my objects like this : - gid serial NOT NULL, - year INTEGER, - the_geom geometry(...
wiltomap's user avatar
  • 2,720
15 votes
4 answers
102k views

GROUP BY timestamp interval 10 minutes PostgreSQL [closed]

I need to group by a period of time spliting up by 10 minutes. I have this query below that returns me a result set: SELECT timestamp FROM table_1, table_2_shape_polygon WHERE ST_Within(...
Marco Amaral's user avatar