Questions tagged [table]
A set of data elements arranged in rows and columns.
516
questions
0
votes
0
answers
12
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 ...
- 31
0
votes
0
answers
25
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 ...
- 1
1
vote
3
answers
154
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 ...
- 113
0
votes
0
answers
13
views
Can Attribute Rules be Portable to Hosted AGO TABLES?
I added a "Calculation Rule" (Immediate) to a standalone table stored in my ArcGIS Pro default FGDB, and then published to AGO as a hosted table. I tested the attribute rule before and after ...
- 1
0
votes
1
answer
55
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. ...
0
votes
0
answers
42
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 ...
- 267
0
votes
1
answer
30
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 ...
- 1
1
vote
1
answer
67
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 ...
- 21
1
vote
1
answer
80
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 ...
- 21
0
votes
1
answer
50
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 ...
- 21
0
votes
1
answer
121
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 ...
- 74
-1
votes
0
answers
29
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.
1
vote
1
answer
49
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 ...
- 33
1
vote
0
answers
17
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?
- 11
4
votes
1
answer
120
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 ...
1
vote
0
answers
54
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 ...
- 11
2
votes
2
answers
343
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 ...
- 21
2
votes
0
answers
43
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 ...
- 21
1
vote
0
answers
61
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 ...
- 51
0
votes
0
answers
36
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 ...
- 13
4
votes
2
answers
111
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?
- 113
6
votes
1
answer
122
views
Inconsistent behaviour of getFeature() and getFeatures() when accessing CSV table with no geometry using PyQGIS
I load the following CSV data into QGIS 3 (specs below) as a table with no geometry using default options.
"V1","time","V2"
-49,"2021-12-28T00:12:17.725753Z",13....
- 424
0
votes
1
answer
2k
views
Importing CSV table with coordinates to Google Earth Engine
Exactly the same problem as this: Adding a CSV with GPS coordinates points to Google Earth Engine
I have tried the solution to redownload the .csv file as mentioned here but that did not work.
I have ...
- 21
2
votes
1
answer
93
views
Print composer custom table: Using contents of table fields in expression
I am looking for a way to - well, kind of use a custom table in the print composer like an excel sheet. I've used a custom table in my Print Layout to calculate values based on Atlas features. So far, ...
- 31
1
vote
1
answer
105
views
Joining CSV tables by multiple attributes
I am using QGIS 3.16
I have a shapefile with an attribute table containing regions, district-numbers and building-numbers and I have an additional table (CSV) that (besides other relevant information) ...
- 83
0
votes
0
answers
55
views
Joining Table attribute to Map attributes without matching properties
I have a Dataset (10Gb) that I imported to QGIS 3.22.
It contains multiple tables and maps.
The first map categorizes land usage (HWRM_HWRK_LN) and I was able to attribute a color gradient.
The four ...
- 1
0
votes
1
answer
57
views
Joining field of multiple tables into one shapefile using ArcMap
I have one shapefile containing several zones (polygons), which are several agricultural parcels. Each parcel has its own FID. I also have five tables containing the crop type of each parcel for five ...
- 135
4
votes
1
answer
162
views
Text file auto-loading incorrectly in QGIS
In QGIS 3.18. I have a tab-separated text file (.txt) loaded as a table. This table serves as the layer reference for the Value Relation widget for several fields (that is: the allowed check box ...
- 1,031
-1
votes
1
answer
144
views
Creating table from lists in sorted manner in Google Earth Engine
I have calculated the area coverage of landcover types in a region and sort them
now I want to export the results as a table to drive in a sorted manner
when I combine them in a new dictionary object ...
- 117
0
votes
0
answers
134
views
ArcMap stopped working after trying to open table of contents
I use ArcMap 10.8.1. Recently it stops working and crashes.
There is a trigger for the crash - Table of contents. When I open the program, it doesn't show, but when I try to open the table of content, ...
1
vote
1
answer
366
views
Expression-based table relation in QGIS, avoiding joins and relates
In QGIS 3.18. I have two tables, one as a part of a .shp and the other a tab-delimited .txt with no geometry:
my .shp attribute table contains a list of sites, and
my .txt table contains a list of ...
- 1,031
3
votes
1
answer
134
views
How do I complete an existing attribute table with .CSV or .XLSX
I have an existing vector layer (points) I was working on some time ago. The layer represents boreholes in the area of my interest (over 250 points).
Some time ago we got access to a number of ...
- 53
1
vote
1
answer
70
views
Removing table on map using ArcMap
I am using ArcMap 10.7 and very often I export data from attribute tables to external Excel files.
Very recently I saw several table layers appearing on my map (figure below) and I guess this was ...
- 11
1
vote
1
answer
232
views
Adding a CSV with GPS coordinates points and bathymetry data to Google Earth Engine
I'm trying to construct a bathymetry point map on GEE, and I want to import a CSV that contains bathymetry data.
The CSV that I'm about to import to GEE has the following columns: Latitude, Longitude ...
- 11
0
votes
1
answer
310
views
Adding a table of attribute information onto map
I am using ArcMap.
How can I take a feature's attribute information (i.e buildings) and place the names and building numbers in a table, so that anyone looking at the map can relate the building ...
- 1
3
votes
1
answer
228
views
How to export Coordinates when clicking on Points?
Assumed I click around on a map, while I need to export the coordinates of the points where I have clicked into a simple text file. In best case, writing into the text file should be performed ...
- 181
3
votes
1
answer
167
views
Selecting features based on one to many relation in QGIS 3
There are two layers: [1] one is a polygon layer with an "ID", [2] the other one is a table with one or many owners for each "ID".
My goal is to select every polygon owned by a ...
- 31
0
votes
1
answer
244
views
Increasing decimal in table chart Google Earth Engine
I have code that generates NDVI times series chart. The values are with 3 decimal places. I want to increase the decimal places to 4 or 5. Is there a way of doing that?
My code:
// Load raster data (...
- 49
1
vote
0
answers
195
views
Iterate multiple tables for input into "Tables to Domain" tool in ArcGIS Pro ModelBuilder
I would like to iterate over multiple tables in a geodatabase then feed the tables into the "Table to Domain" tool in ArcGIS ModelBuilder.
Currently it only seems to iterate over 1 table.
I ...
- 11
0
votes
0
answers
146
views
Get table in ArcPy object
I would like to get the output of StackProfile() into an ArcPy object to avoid writing files. As far as I know this is possible to do with geometry objects but I have not found a way to do it for ...
- 69
3
votes
2
answers
137
views
Summary of raster values for a region
I'm stuck with a problem:
I got three raster's layers: "Sand", "Clay" and "BD" (Bulk density) of the same region.
How can I obtain a "table" or a "Data ...
- 111
0
votes
0
answers
46
views
Images Shown in Popup Not in Table of ArcGIS Pro
I'm trying to export data from a map layer to an excel file. From ArcGIS Online I opened the layer using ArcGIS Pro. The images exist in AGOL, and can be seen from the pop-ups in Pro when individual ...
1
vote
1
answer
72
views
Table to point feature class using ModelBuilder of ArcMap
I am trying to convert a table in a fGDB to a point feature class using ArcMap 10.8. I need to do this in the ModelBuilder .
The table has about 8000 records, containing X and Y coordinates and many ...
- 15
4
votes
1
answer
159
views
Creating table coordinates of selected feature and adding it to layout with PyQGIS
I am working on a Plugin that allows users to look for a feature in the database, select it, and then open the Layout designer with map, arrow legend and some labels.
I am looking to add a table that ...
- 63
1
vote
0
answers
92
views
GEE ui.panel error
I want to creata app to calculate "RMSE" index by table , but I can not select the variance in table
here is my code link: https://code.earthengine.google.com/?scriptPath=users%...
1
vote
1
answer
605
views
Exporting/Listing printed console results in a table in Google Earth Engine
I wrote a code with different function to bring me different output values e.g. the values at specific dates, statistics, cloud cover, etc. I printed them all individually in the console but now I ...
- 111
1
vote
0
answers
100
views
Ask ArcMap to recognize updated CSV file content
I have a CSV file that I am updating outside of ArcMap (v10.4.1).
How can I get ArcMap to see the revised content instead of the old content?
ArcMap does not automatically see the updated version.
My ...
- 171
3
votes
1
answer
262
views
Switching between alias names and table names using ArcPy in ArcGIS Pro
Whenever I add standalone tables from my file geodatabase to an ArcGIS Pro map, the alias names are displayed instead of the table names. I want to view these tables using only their table names. ...
- 31
2
votes
1
answer
104
views
Loading non-spatial tables from geopackage into ArcGIS Pro
I have a geopackage comprising spatial and nonsapatial tables. I would like to be able to load all of the tables into an ArcGIS Pro 2.6 project, however, when I connect to the geopackage I'm only able ...
- 91
2
votes
1
answer
557
views
Google Earth Engine: Calculate milliseconds since epoch from datetime of uploaded shapefile?
I want to get the milliseconds since epoch of thousands of points, each with different timestamps. Here is what I believe I need to do, but my Google Earth Engine knowledge is limited and I can't find ...
