Questions tagged [pivot-table]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
0 answers

Defining additional fields in a pivot table of a N-M relation in QGIS

I have a N-M relation in a GeoPackage, defined using QGIS 3.32. For the sake of this question you can consider the "airports - airlines" example on the QGIS documentation: https://docs.qgis....
barotto's user avatar
  • 11
1 vote
0 answers

Combining data in pivot table using ArcMap

I have created a pivot table by using summary statistics in ArcMap. I have summarized three columns that I would like to sort by the same row data. Is there any way to combine the values in these ...
kiwiman88's user avatar
0 votes
0 answers

Making a pivot table in ArcGIS using Standard license

Having issued with using the pivot table tool in ArcGIS Pro due to the license level, I want to know if any geographer here knows how to make the pivot table of pivot table-like output using a set of ...
Stella J's user avatar
0 votes
0 answers

How to summarize one-to-many spatial join results with the same ID while each ID does have multiple string features

After using the One-to-many option in the spaital join tool, I received a shapefile which includes 13 million rows and several columns. I am wondering how I can calculate the sum of different values ...
Farbod Tavakoli's user avatar
0 votes
0 answers

Is it possible to create a unique pivot table for each page of a QGIS Atlas?

I have a shapefile of city points and a LibreOffice spreadsheet of daily information about each city. The data is fine, I successfully built a pivot table in LibreOffice that sums city data over a two ...
Ronald Halliday's user avatar
1 vote
1 answer

Pivot table - Get counts of values in field by key field

I'm trying to create a pivot table which displays counts of unique values per a key field: I've tried a combo of PivotTable and Statistics but the results are not correct. The PivotTable doesn't ...
Emil Brundage's user avatar
1 vote
1 answer

pivot-table and group geometries

Postgresql11 - postgis2.4 Here is a table mytbl with points and an attribute var : geom | var pt a pt b pt1 a pt1 a pt1 b pt2 c ... I want to "rotate" the table like this : ...
Leehan's user avatar
  • 1,214
1 vote
0 answers

Creating virtual layer or view table from original table using pivot table on QGIS?

I have a table and I need to produce a virtual layer with pivot or crosstable command. Is it possible on QGIS 3.6 or 3.8? My original sql is: select cd_setor, Name, Path_relativo from Fotos order ...
Denilson's user avatar
  • 695
2 votes
1 answer

Flattening multiple fields using Pivot Table in ArcPy? [closed]

I'm trying to flatten a table, but I want to keep/relate certain fields tied to each other. For context, I ran a Generate Near Table to try to find the traffic volumes near intersections. I am trying ...
forci020's user avatar
5 votes
0 answers

Taking ArcGIS feature class to pandas pivot table? [closed]

I'm new to pandas and am trying to create a pivot table based off of two fields - DIVISION and MATERIAL. I'd like to count each occurances of each value. Rows would be DIVISION and columns would be ...
Emil Brundage's user avatar
4 votes
1 answer

Labelling Max coverage by Area

I'm struggling to find a quick way to identify and label an area by the maximum coverage of an overlapping polygon. Has anyone done a process like this lately? I'm currently playing with the Pivot ...
Cheekychives's user avatar
3 votes
1 answer

Crosstable two fields of pointfile using ArcMap?

I'd like to produce a simple crosstabulation from two fields of a point feature class. These fields contain land use class information which I'd like to compare. One option is to export a dbf and do ...
reima's user avatar
  • 638