Questions tagged [table]
A set of data elements arranged in rows and columns.
540
questions
4
votes
2
answers
595
views
PostGIS- slow spatial UPDATE queries on 50mil rows
PostgreSQL 11.8, AWS hosted RDS instance, SSD, 8GB RAM, 3.0 GHz Intel Scalable Processor. Plenty of storage space.
I'm finding running updates on a large table using spatial queries is taking a very ...
4
votes
1
answer
2k
views
Calculate average values of points intersecting grid
I'm using QGIS 2.18.16.
I have a layer with 100k locations, each with several values in the attribute table (ex: mass, E impact, v, ...) for each point (imported via CSV file).
I use a vector grid to ...
4
votes
1
answer
3k
views
Using field mappings to remove fields from merged table using ArcMap
I'm trying to combine a (large) number of tables into a merged table, keeping only certain fields. I've tried the below, but it still gives all the fields.
Any ideas?
listEventTables = arcpy....
4
votes
1
answer
325
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 ...
4
votes
1
answer
264
views
Getting 2 point features with max/min ID from each group with same value in two fields
I'm working in QGIS for a Digital Terrain Model.
I've got a table with point features, arguably vertices extracted from multipart iso-curves because the features are provided with a "vertex_par" ...
4
votes
1
answer
1k
views
Joining multible rows in csv file to a single row in shp file using ArcGIS
I have two tables (one is actually a shapefile and the other one is a comma separated file).
I really need your help with joining the csv file table (which has many rows for one ID number) with the ...
4
votes
2
answers
2k
views
Using vlookup function in ArcMap?
I am trying to automate a field calculation using ModelBuilder, using a GDB table to populate a feature class field given two conditions:
Traffic Count Value and
Posted Speed limit
I have created ...
4
votes
1
answer
651
views
Table with groupings and sums in print composer?
Assuming I have a basic shapefile with the following columns: name, use, acres
I would like to generate a more visually appealing dynamic table in layout view:
Use ...
4
votes
2
answers
2k
views
Excel table losing color in over half of the highlighted cells when exported from ArcMap 10.4 to PDF
I'm trying to add a table to from Excel into layout view. Bringing it into Arcmap it holds the color in all the highlighted cells and looks perfect. There are about 85 highlighted boxes (out of 740) ...
4
votes
1
answer
192
views
End execution of script and send email if schema has changed
I would like to append the data from one feature class to another after confirming that the schemas match in both feature classes.
I can append the data from one FC to another by using this simple ...
4
votes
1
answer
304
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 ...
4
votes
1
answer
203
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 ...
4
votes
2
answers
3k
views
Google Earth Engine - error when exporting table
I'm trying to export a frequency histogram table of a classified image for a region.
function country (image) {var c = image.reduceRegion({
geometry: image.geometry(),
reducer: ee.Reducer....
4
votes
2
answers
710
views
Copy and paste a non-spatial record in the same table (make a duplicate a record)
How can I duplicate (copy/paste) a non-spatial record into the same table in ArcMap? I can copy and paste to/from spatial tables, but there doesn't seem to be a way to do this in the attribute table ...
3
votes
3
answers
4k
views
Normalizing values in single Field (from table) in ArcGIS for Desktop?
have encountered a problem, in Field Calculator.
The situation : I have a polygon feature with a table, comprised of a single Field ("Field1"). There are 675 records in this field. The minimum ...
3
votes
1
answer
3k
views
Copy/Paste attribute table qgis without the wkt_geom column?
Is there a way to copy the attribute table on qgis and paste it on excel without the wkt_geom column?
3
votes
2
answers
638
views
Select JSON records as an Excel table
I have an internal map service that serves up GIS records via JSON objects.
For the purpose of this question, instead of using my internal/private
data, we can use the JSON data on ESRI's public ...
3
votes
2
answers
1k
views
Create Table (Data Management), Unable to Save to Feature Dataset
I'm trying to create a table in a feature dataset and get the error: Parameters are not valid. The code works when I write only to the gdb. Am I not allowed to write to a feature dataset or am I doing ...
3
votes
1
answer
306
views
How to add ITable (Table object) to current map (or document)?
I created an in-memory results ITable and I need to add it to the current ArcMap document/map to see the generated data.
How can I do it?
3
votes
1
answer
5k
views
Exporting Lists from Earth Engine
I am using code from the emapr lab to learn to use LandTrendr to get mean NDVI values per year for a geometry. I am trying to export the generated list from earth engine to Drive. The list only ...
3
votes
2
answers
225
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 ...
3
votes
3
answers
3k
views
Adding a CSV with GPS coordinates points to Google Earth Engine
I'm trying to add a CSV with Lat/Lon to Google Earth Engine.
I looked at the answer below, however, I seem to be making an error somewhere.
Adding x,y coordinates from table in Google Earth Engine
My ...
3
votes
1
answer
913
views
Inconsistent display of HTML table font size in QGIS layouts
I'm using QGIS 3.10.1, and am having trouble with getting HTML tables to render correctly in a layout. I generated the HTML table using the "TABLEIZER!" online tool, and just pasted the results into ...
3
votes
1
answer
166
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, ...
3
votes
1
answer
7k
views
Joining tables results in null values within joined part using ArcGIS Pro
I have tried various geoprocessing tools, read through the stack exchange, googled questions, and I still have not figured this out.
I am trying to join a table based on GEOID field. I made sure ...
3
votes
2
answers
94
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. ...
3
votes
1
answer
174
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 ...
3
votes
1
answer
452
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 ...
3
votes
1
answer
2k
views
Table join results in NULL in QGIS
I'm trying to join a field named "Area" belonging to the shapefile 'Ancient Woodland' with the shapefile 'Net Development Area' (see screenshots below).
The results only return NULL which I ...
3
votes
1
answer
240
views
Finding '_' without treating it as a wild character
Does anyone know how to select records containing an underscore without the query treating it as a wild character?
For instance, I'm trying to select records in a text field ending with '_' to ...
3
votes
3
answers
2k
views
Creating a table of multiple rows and columns from attribute table
I am trying to create a street index a City. I have a table that has all the street names and their grid references. I am looking to create a street index using that. I think turning off the undesired ...
3
votes
1
answer
232
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 ...
3
votes
1
answer
509
views
Merging or joining two tables with some matching columns in QGIS to calclulate unique values
I have two tables (A and B) that display the presence or absence of a species within a polygon and within each polygons associated buffer layer. The purpose of the buffer layer is to account for a ...
3
votes
1
answer
402
views
Copy the layer_styles table from one database to another?
I am trying to copy the layer_styles table to another database. A quick and painless process is preferred, to make the movement of the layer_styles tables easy to repeat in the future.
I have tried ...
3
votes
1
answer
293
views
Joining from list with duplicates in list in QGIS
I have a vector layer that i would like to join with a list. The problem is that my vector layer does not hold any overlapping or duplicate objects, but my list does. The list does not have any ...
3
votes
1
answer
771
views
Using the field calculator in SAGA-GIS
I am working with SAGA-GIS and need to create an euclidean allocation raster. For this, I need to first create an integer raster with values for certain areas. This integer raster shall be based on a ...
3
votes
1
answer
683
views
Adding HTML Table in Print Composer
I am trying to add an HTML table to the bottom left corner of my Print Composer. The table is populating with data based on the current atlas feature. The problem is that the table has a different ...
3
votes
1
answer
272
views
Previewing table in ArcGIS Pro without adding to map?
In ArcMap I often preview a table by using the Catalog window to right-click it, which opens the Item Description window and enables me to go to the Preview tab.
Is there an equivalent workflow (i.e. ...
3
votes
1
answer
86
views
Feature Class relate with table
I use ArcGIS 10.1 for Desktop.
I have a polygon Feature Class with municipalities.
In a non-geographic table, I have these same municipalities, with an additional contract information.
The ...
3
votes
1
answer
2k
views
Opening spatial weights matrix file (SWM) from ArcGIS for Desktop in Excel?
I successfully generate spatial weights matrix file (SWM) to get the nearest neighbors for polygons shapes in ArcMap 10.2.2 but I am confused how to open this file its a compressed file and when I try ...
3
votes
2
answers
915
views
QGIS Freehand editing plug-in: blocked attribute table
I can't save object after drawing by Freehand editing plug-in. I suppose it will be connected with creating some (special) column in the table.
Could anyone suggest a solution?
3
votes
1
answer
238
views
Switch between raw field values and displayed values in the attribute table?
When working with the attribute forms value map or value relation i have found no way to switch between raw field values and displayed values in the attribute table (neither in the project properties ...
3
votes
2
answers
915
views
PyQgis open vector layer attribute table
Is there a Qgs dialog or widget that I can use in a standalone pyqgis application to open the attribute table of a QgsVectorLayer? this seems to be such a simple thing, there has to be an existing ...
3
votes
1
answer
1k
views
Renaming columns in attribute table of joined data - integer data
Using QGIS 2.14.4 (Essen). I am trying to join an excel for data about species surveys which were conducted at different locations, by blocks of area which is a separate shapefile I have already. I am ...
3
votes
1
answer
3k
views
Calculating summary statistics and access resulting value in table using ArcPy?
With arcpy, I want to calculate the mean value of a specific field in a shapefile and print the resulting value for the user.
I use the Summary Statistics tool and it works, but the resulting value ...
3
votes
1
answer
5k
views
Editing Related Tables in ArcGIS Online?
Is it possible to edit a related table via the browser in ArcGIS Online?
The last update I heard in February was only available via ArcGIS Collector.
I was wondering if ArcGIS Online supports ...
3
votes
1
answer
203
views
Copy table to attribute table
I have some tables with columns that I need to join/copy to another table, in case an attribute table. I was using join but I realized that it would be a better solution to add new fields to my ...
3
votes
2
answers
1k
views
Iterate calculate field in multiple tables in ModelBuilder
I would like to iterate calculate field in multiple tables using ArcGIS Model Builder.
The figure below explains details of the calculations. My existing model calculates value only for the first ...
3
votes
1
answer
1k
views
Trimble GPS data is not displaying in ArcMap attribute table
I am currently having difficulty trouble shooting a problem. While using a TRIMBLE GEOXH (GeoExplorer 2008 Series) I have the problem of missing data after exporting it to ArcMap from my GPS receiver. ...
3
votes
1
answer
963
views
Merging .dbf Tables in Python w/o merging all fields of same name
I'd like to merge several tables together using Python. They all have the same field names: "TIME", "X", "Y", and "VALUE".
I would like the "VALUE" fields to remain separate when merged, so that the ...