Skip to main content

Questions tagged [table]

A set of data elements arranged in rows and columns.

Filter by
Sorted by
Tagged with
2 votes
1 answer
136 views

What is the name given to the table layer in QGIS?

What name is given to this selected layer? It's not a vector layer where you can add geometries, it's something like a table or spreadsheet.
Aloísio Ângelo's user avatar
1 vote
0 answers
44 views

Synchronizing point layer with external table in QGIS

In QGIS I have an external table imported from MySQL where several users insert data through a website. This table is imported into QGIS and I have a join with a geopack that contains the x and ...
Kestrelol's user avatar
0 votes
2 answers
36 views

Feature class to shapefile problem

When exporting feature class to shapefile, fields in attribute table are approx. half disappears (because of maximum number of characters in field and maybe because of Arabic fields language ). How ...
hassan zorkot's user avatar
0 votes
0 answers
19 views

Print composer custom table with sums for groups

How do I build a result table within the print composer that aggreates the sums from an abundance field (integer) for the responding values? Species Abundance x 1 y 1 x 1 Result Species count x ...
Eric Walter's user avatar
0 votes
1 answer
37 views

Add (only) geometries to table without geometries from other layer based on common field

I'm looking for a processing tool or virtual layer to do this: I have a table without geometries with lots of fields (mssql), including a cadastral reference. There is a database (with geometries) ...
E. P.'s user avatar
  • 1
0 votes
0 answers
24 views

Update/refresh Table in QGIS-Layout

I have two tables in my layout. One is a Attribute table (of a polygon layer) the other one a table which shows the Sum of the first table multiply by 2. While the attribute table is updated when ...
Stefan's user avatar
  • 74
1 vote
1 answer
55 views

Why do I need to use quotation marks ("") to call a table in PostGIS? I remember not to need it in other exercises [closed]

When I try to run the following code I get an error that disappear when I call the tables using quotation marks. I remember having run tables before without it. select cine as INE from "...
user's user avatar
  • 151
0 votes
0 answers
30 views

Troubleshoot Attribute Rule to Update Parent Table

I am using ArcGIS Pro 3.2.1 and working with an Arcade expression to update a parent layer when new inspections are performed in the related table. I have tried a 1:M relationship class with GlobalIDs,...
Mikhayla's user avatar
0 votes
1 answer
67 views

Getting attribute values from a no geometry table for use in geometry by expression in QGIS

I have a no geometry table (named TABLE) with 3 fields. There are “Station”, “Offset”, and “Angle”. There are many rows of values (real numbers). These values will be used in geometry by expression. ...
Francis's user avatar
  • 169
0 votes
1 answer
102 views

Merging two cells in QGIS

I want to merge 2 cells and I can't seem to find anything online, what should I do exactly?
Zahariuc Andrei's user avatar
0 votes
0 answers
58 views

Shortcut for the "Update selected" feature in the attribute table with QGIS

I am using QGIS version 3.28 on Windows 11 and I use the attribute table all the time and I was wondering if there was a way to set up a shortcut for the "Update selected" feature since it ...
Arturo Chesi Visani's user avatar
0 votes
1 answer
58 views

Deleting file geodatabase table with quotes in name using ArcGIS Pro

I am using ArcGIS Pro 3.1.2. I somehow managed to accidentally rename a table in my file geodatabase with quotation marks in the name. Trying to open it will yield a Failed to open table. error. I am ...
sushi's user avatar
  • 317
1 vote
1 answer
133 views

Changing color and font for cell in QgsLayoutItemTextTable object using PyQGIS

I am in the process of creating, with PyQGIS, a PDF file. First I set up the following objects: A value project = QgsProject.instance() A layoutManager object "manager" A QgsPrintLayout ...
theonewhodidnotknow's user avatar
0 votes
1 answer
46 views

Using arcpy, need to find which polygon each set of coordinates in a table intersects with

I'm writing a Python script tool for ArcGIS Pro and among other things, I need it to compare coordinate values (lat & lon) in a GDB table to a polygon feature class and determine which polygon ...
jencarta's user avatar
  • 176
1 vote
1 answer
104 views

Principal Component Analysis (PCA) error found for getting results as a Chart (ui.chart) in GEE

I am trying hard to get principal component analysis results as 'chart/csv.' format by applying ui.chart code but it shows the error "Error generating chart: No features contain non-null values ...
Hanif Bhuian's user avatar
3 votes
2 answers
101 views

Update fields in table in PostGIS database by joining attribute by field value from a layer

I have a table in my PostGIS database. Its geometric objects I loaded in to my QGIS project as layer where I can edit them. In this layer (layer A) there are features with null values in some fields. ...
CruiseLee's user avatar
3 votes
1 answer
114 views

Autofill records with previous values in QGIS

I have a track (point layer with date and positions) and some information associated to it. I enter this information when some event changes (Effort on/off or Beaufort goes up or down in this example)....
Kike's user avatar
  • 33
0 votes
1 answer
111 views

qgis._core.QgsLayoutTable represents a C++ abstract class and cannot be instantiated

When i try to access the QgsLayoutTable class it says that it is abstract, but in the documentation it is referred as a builder exactly as a QgsLayoutItemTextTable or QgsLayoutItemAttributeTable. ...
Kabloom's user avatar
0 votes
0 answers
29 views

How to create a points layer without XY cordinates in my attribute table

I have tried a few methods. I loaded a table and tried to join it with "add join" using the object ID as the the common attribute, but it did not join the table the way I planned. I ...
Ramon Hernandez's user avatar
1 vote
0 answers
24 views

Table creation for cross section line using QGIS

When I export a 2D .dxf line with the profile tool in QGIS 3.28.5, it also creates some empty layers in the dxf. Dimensions, table background, table content, table grid and viewports. Is there a way ...
Pitheas's user avatar
  • 741
0 votes
1 answer
269 views

Exporting values from Images in ImageCollection to CSV

I am working with rainfall monthly totals for a 30-year period using CHIRPS pentad. //1.Reference Period var historical = ee.List.sequence(1991, 2020) var months = ee.List.sequence(1, 5) //print(...
Adi's user avatar
  • 327
0 votes
0 answers
71 views

QGis 3.28.2 changing attribute value

As you can see in the picture attached, in the column of ID is distributed with different values, I want to delete them and equate the values with the numbers I pictured in red. The numbers should be ...
eva's user avatar
  • 59
5 votes
0 answers
97 views

Filtered features in attribute table

Attribute table header of point layer says: "Features total 1200, Filtered: 1197, Selected: 0" There is no layer filter active and also no filter is set in the layer properties under tab &...
Hannes's user avatar
  • 129
0 votes
0 answers
29 views

Add new point to feature class but keep numbering scheme

I am using ArcGIS Pro. I need to add a point to a feature class. The objects are named based on spatial attributes, ie one point is named 1364, the next one down is 1365 etc. I need to add a point ...
NeedsSpatialAttention's user avatar
1 vote
0 answers
30 views

Display the table of a shapefile in Google Earth Engineer apps UI interface [closed]

I'm trying to insert a table similar to the one in the attached image. Would anyone have any idea where to start? https://code.earthengine.google.com/475917a534535468d35beb6c57623ca9
Francisco Godoy's user avatar
1 vote
1 answer
123 views

Column disappears after applying symbology

I have a CSV file that I loaded into QGIS and I made points layers from X,Y columns that was in that CSV file. Now, this file has a column that called "Value". This column is updated once a ...
Yovel Rodoy's user avatar
1 vote
2 answers
143 views

QGIS - Issue importing CSV Table (owner information) with quotation marks

When importing my CSV table into QGIS, rows containing quotes are not correctly separated into columns. Is it possible to define the column separator to tolerate quotes or is there another problem? ...
Marek's user avatar
  • 537
0 votes
1 answer
67 views

How can I put this data into a table?

Here is a chart of monthly mean rainfall vs month, and I would like to now get a data table. I would also like to export the table to the drive. I am not sure how to generate a table, basically I just ...
Mas's user avatar
  • 33
1 vote
1 answer
30 views

MakeTableView error

I'm trying to join a layer with an Excel CSV utilizing the first 6 digits of the column called "concated" and "BBL". but I get the following error: Runtime error Traceback (most ...
Jose Vasquez's user avatar
0 votes
0 answers
20 views

How to add multiple shapefile into a single table in PostGIS? [duplicate]

How to add multiple same geometry shapefile (such as polygons) into a single table in PostGIS? For example: test_1 is a shapefile (polygon) test_2 is a shapefile (polygon) test_3 is a shapefile (...
Hasan's user avatar
  • 55
1 vote
0 answers
15 views

Creating table rows for measurements in forms

I have a question about forms combined with tables. I'm trying to create a form which allows me to add multiple rows of data to a point e.g. I want be able to create multiple rows and fill these in ...
masterd212's user avatar
0 votes
0 answers
35 views

Time format/ data display changes following join then export to data

I am working on a simple join of data in an excel table to create an attribute table from kml's that were converted to polygons. The join works perfectly, however when exporting the data as a new ...
A Wohl's user avatar
  • 1
1 vote
3 answers
823 views

Combining multiple values (unique and different) into one column to based on unique value

I have a table consisting of two columns (1) unique values (some multiple times) and (2) values (unique and different) - I want to create a table that will contain two columns (1) unique values (no ...
Pikachun's user avatar
  • 113
0 votes
1 answer
106 views

RuntimeError: [blank] when trying to add a standalone table to a map with python

I am trying to add a standalone table to a map, but when I attempt to create the table object I get a blank runtime error ('RuntimeError: '). This error occurs when running the arcpy.mp.Table() line. ...
dpederson95's user avatar
0 votes
0 answers
113 views

NULL Values in the ID field if I copy features from a shapefile layer to geopackage layer using QGIS

I can't figure out this problem. If I copy from my shapefile layer with copy/paste to another layer which is a geopackage layer, I get NULL values in the ID field. Do you have any ideas? The added ...
Barrylim_work's user avatar
0 votes
1 answer
80 views

Joining fields from two datasets and appending from one to other in ArcMap

I am looking to be able to append a field titled "premise ID" from one data set (from billing department) to the data set used in ArcMap. The data set provided from billing is taken and ...
GIS4life's user avatar
1 vote
1 answer
156 views

Arcpy.CreateTable_management in Python toolbox not creating table in memory

The following creates a table in memory as expected when executed in the Python window [ArcGIS Pro 2.9, Windows 10]: arcpy.CreateTable_management('memory','dataTable') When I try to do the same thing ...
cmagagnosc's user avatar
1 vote
1 answer
254 views

Interpreting total time variable in QNEAT 3 OD Matrix using QGIS

In QGIS 3.26.1, I used the QNEAT3 "OD Matrix from Layers as Table (m:n)" function. (Ancillary info: I am using the TIGER/Line 2019 primary and secondary road data for the US, in order to ...
Benjamin's user avatar
0 votes
1 answer
103 views

Arcpy.CreateTable_management fails in Python toolbox (.pyt)

I am trying to create a table within a Python toolbox (.pyt). This works with file GDB's, but I would like to use a memory dataset if possible. A table can be created in memory manually or by calling ...
cmagagnosc's user avatar
0 votes
1 answer
244 views

ArcPy TableToNumPyArray TypeError

I have a geodatabase table that I want to convert to a numpy array to create a Pandas dataframe. Using the arcpy TableToNumPyArray function on the table object fails. import arcpy, numpy # `tbls` is ...
champezius's user avatar
-1 votes
0 answers
30 views

How to properly add consecutive numbers after text for ID in attribute table [duplicate]

So after trying this expression 'GI_' + lpad($id, 2, 0) I get this; and I have about 12650 rows, and the id freezes in GI_10. I want the rows to start from GI_00 and end with GI_12650.
Catherine Paul's user avatar
1 vote
1 answer
74 views

Can I save nested Layers in a long format table?

I want to create a QGIS project for sampling crustaceans in rivers using Qfield. I want to collect environmental data as well as the abundance of each species found in different microhabitats. So far ...
Daniel97's user avatar
1 vote
0 answers
20 views

Alternate view to normal view in attribute table [closed]

I have somehow accidentally changed how my attribute table looks and I dont know how to get it to go back to the original state has anyone any idea how to change?
sophie's user avatar
  • 11
4 votes
1 answer
343 views

Using values from table in QGIS Modeler for filtering

I have a list of values (species names) in a .csv file and a vector layer of sightings of many species. Is there a way to load the list in the QGIS Modeler and use it to filter my vector layer so that ...
Patrick Marti's user avatar
1 vote
1 answer
273 views

Change the headlines of a attribute table in QGIS

I would like to change the heading of a column in the attribute table of QGIS. Originally I had a vector layer linked to an Excel table and so now I have old and new forest locations. But both columns ...
Mel's user avatar
  • 11
2 votes
2 answers
732 views

Compare tables in two different geodatabases

I have two geodatabases, one with February data (Final_Project_2.gdb) which contains 6 feature classes. The second geodatabase has March data, (Clipped.gdb), which also contains 6 feature classes, the ...
Yerce81's user avatar
  • 21
2 votes
0 answers
53 views

If-then formular in table QGIS

I am working with QGIS and I have a table with several columns, some of them I defined as drop-down columns. In the next step I would like to define certain specifications. For example: If column A is ...
zebraslot's user avatar
1 vote
0 answers
116 views

QGIS Print Layout attribute table source as model output

I have created a model which extracts features from larger shapefile databases around a site boundary. Each time I run the model I am using a different site boundary, however the outputs have the same ...
JackP's user avatar
  • 323
0 votes
0 answers
37 views

Formulating Table Relate using ArcMap

I'm moving our floorplans for a major organization into GIS to take advantage of analytical capabilities. I've prepared and figured polygons for each classification layer I want but when it comes to ...
MCon's user avatar
  • 13
4 votes
2 answers
171 views

Join tables with different amount of rows using SQL in QGIS3

I want to join two tables. The second table has only one row. I want to append this row to every row of table 1. How can I achieve that with SQL in QGIS3?
gislost's user avatar
  • 113

1
2 3 4 5
11