All Questions
Tagged with grouping postgresql
7 questions
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....
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 ...
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 ...
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 ...
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 ...
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(...
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(...