Questions tagged [pivot-table]
The pivot-table tag has no usage guidance.
12
questions
0
votes
0
answers
27
views
Change latitude (rows) and longitude (columns) in columns using ArcGIS [closed]
I have a data frame as dBase table in ArcGIS where latitude (lat) values are the names of the rows, and longitude (lon) values are the names of the columns, and for each cell of the data frame is a ...
- 343
1
vote
0
answers
48
views
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 ...
- 23
0
votes
0
answers
356
views
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 ...
- 1
0
votes
0
answers
246
views
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 ...
0
votes
0
answers
150
views
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 ...
1
vote
1
answer
511
views
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 ...
- 13.8k
1
vote
1
answer
45
views
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 :
...
- 1,164
1
vote
0
answers
145
views
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 ...
- 665
2
votes
1
answer
151
views
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 ...
- 33
5
votes
0
answers
757
views
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 ...
- 13.8k
4
votes
1
answer
59
views
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 ...
- 55
3
votes
1
answer
230
views
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 ...
- 638