Questions tagged [table]

A set of data elements arranged in rows and columns.

Filter by
Sorted by
Tagged with
1
vote
1answer
25 views

Why “new” dataset table is deleted when trying to update existing dataset table in Esri Insights workbook?

I have an established Insights workbook, with designated cards. The data being used comes from "Table A" when I add "Table B" (updated data) and attempt to 'Update' Table A - which should be a very ...
0
votes
0answers
7 views

How to fix blank “input field” column in pivot table?

I need to us the pivot too, so the GM_Naam field are rows and the BG2015 fields are separate columns containing the Area_Ha values. But when I look at the resulting table, the GM_Naam field is ...
3
votes
1answer
226 views

Add cumulative sum column to attribute table

I have an attribute table in QGIS in which I would like to calculate the cumulative sum. The table is sorted by N (number of fatalities) and I would like to calculate the cumulative sum on F (...
16
votes
8answers
3k views

Sorting by multiple fields at same time in QGIS?

Is it possible to sort multiple fields at the same time in QGIS? For example, I'd like to sort a table by state name, and then within each state, sort by county name. This would be the same as ...
0
votes
1answer
99 views

Static Tables and/or Tabs in ArcGIS Pro Layout

Is it possible to create a non-dynamic/static table in a layout in ArcGIS Pro? I would like to create a table to act as a revision box. If not a table, can text be entered with tabs and tab stops ...
1
vote
1answer
2k views

Splitting table column and using to update another table in ArcPy

I have a table (T1) which I need to populate (using python for ArcGIS) the fields Val1, Val2 and Val3 ID Val1 Val2 Val3 0 1 2 with data from another table (T2): ID Data 0 V1 1 V1 2 V1 0 V2 ...
1
vote
1answer
17 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 ...
0
votes
1answer
18 views

How do I view and export table with slope data for raster and TIN?

Using an original point file, I created a DEM raster with IDW interpolation as well as a TIN. I used surface analysis to create 3D slope layers, one with degrees for the raster (IDW) and one with ...
1
vote
0answers
33 views

Labeling feature with table using ArcMap?

Is there a way to write an expression that puts the variables into a table like in the sample image? I can do it manually like in the sample but I will be making about 150 maps, so it would be way ...
1
vote
2answers
194 views

CreateTable_management as part of a script tool fail

I am trying to create a table as part of a script tool, and it always fails with error 999999. The general idea of the script is that it is calculating proportional coverage of things in a series of ...
2
votes
1answer
812 views

Using US Census block group data field names for feature classes?

I may be missing something here, but it seems like getting usable US Census data into a shapefile or feature class is much harder than it used to be. Downloading the Tiger block group shapefiles is no ...
0
votes
0answers
19 views

QGIS: Bug in boundary layer attribute values. cluttered attribute values after performing a join

I've managed to join a boundary map layer with an delimited text layer to produce a choropleth map. However, suddenly there was an error in the attribute value, its all cluttered when I reopened the ...
4
votes
1answer
296 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....
0
votes
1answer
24 views

Write variable content into specific cell of datasheet (Mapbasic)

I have a value stored in a variable. How can I write this value to a table (for example into Row2 Column4) using Mapbasic?
0
votes
0answers
21 views

Adding table to ArcGIS desktop [duplicate]

I have a table in csv format with three fields. When I open it in ArcMap it shows five fields, the two extra fields are false xy coords. How do I stop this? Is it caused by recent windows updates?
0
votes
1answer
40 views

Google Earth Engine : Get “table” and not a Chart, of time series multiple polygons

Based on the example mentioned here, and based on the answer provided below, // Define a FeatureCollection: regions of the American West. var regions = ee.FeatureCollection([ ee.Feature( // San ...
1
vote
0answers
17 views

Setting constraint so that new value in “Table A” must already exist in “Table B”, else return error? [closed]

I'm trying to set up some kind of constraint so that I can only enter values in "Table A", if that value exists in "Table B". I want this to act sort of like a selection list, where there are only a ...
0
votes
3answers
625 views

Service or way to input a table of lat long and return an output of street addresses?

The following website can be used to enter a single pair of latitude and longitude coordinates and return a street address: https://www.latlong.net/Show-Latitude-Longitude.html I want to get street ...
0
votes
0answers
18 views

Listing all domains and their coded values into table via ArcPy?

I am new to Python. I'm trying to gather a list of all of our Domains (we have a lot) and their coded values and export them into a table or a format that can easily be put into a table. I've had luck ...
0
votes
0answers
52 views

Mapbox GL JS and data grid: how to make them speak to each other?

I'm looking for a solution to display cartographic data with Mapbox GL JS along with tabular data (see for example here). I didn't find anything in Mapbox GL JS that allows such a thing (maybe I'm ...
0
votes
1answer
32 views

Python batch script to delete Attributes

I currently have a script that will select and delete all the values less than 0.1 in a column. The script below works, however it specifies a specific .shp, I want to batch this so it runs through ...
1
vote
1answer
59 views

Creating multi-attribute primary key in table in ArcGIS Desktop

If I have this file geodatabase table with the format of: ColA | ColB| ColC | ColD | ColE | ColF etc... I want to declare a combination of columns will be the primary key (ColA | ColB| ColC). When I ...
1
vote
1answer
72 views

Matching up fields in different tables using ArcGIS Desktop?

I work for a University, and we have some utility/site people go out with their GPS and shoot points pretty often when there are new projects, construction, etc. The data dictionary that they have ...
0
votes
1answer
78 views

Optimising a PostGIS table

I've been uploading a huge amount of contour information to a PostGIS / PostGres table. Uploaded using QGIS' db manager to a separate table a chunk at a time, and then using a quick bit of SQL to ...
0
votes
0answers
17 views

Selecting street segments (polylines) based on intersections with others and adding value to its field from Excel table?

I have a shapefile of city streets polylines and an excel sheet with similar data. I need to select a street segment based on the two segments it intersects. Then I add the value from the "ID" field ...
0
votes
1answer
84 views

How do I get Table from Vector layers for use with joinattributestable

I am attempting to run: processing.runandload('qgis:joinattributestable', layer1, layer2, 'id', 'id', None) To join my tables and output to a temporary viewing layer. layer1 and layer2 are both ...
0
votes
0answers
7 views

Assigning points to buffers in MapInfo12.0

First time using MapInfo. I want to essentially spatially join a point(s) that is situated inside a buffer together (so that the point and buffer have the same numerical ID). My table currently listed ...
0
votes
0answers
33 views

ArcGIS Online Dashboard Summary Table

In short, I'd like to add a panel with a summary table in the ArcGIS Online Dashboard, but it does not appear that there is an option for that. Has anyone done something similar? To get more in ...
-3
votes
1answer
56 views

Excluding certain Tables and Table Columns out of Analysis using ArcPy? [closed]

My code currently follows this format: Create FGDB From local folder, get list of all tables Do TableToGeodatabase_conversion on all tables What I want to do now is exclude certain tables from being ...
0
votes
0answers
27 views

Checking if feature class is table in FGDB using ArcPy?

I basically want to do something like: if my_fgdb has data type "tables" then do this A similar function I know of is something like .startswith("xx"), so something similar to that like .typeis("...
0
votes
1answer
27 views

ArcGIS attribute tables exploitation

I have kind of the same question as "greyline" : How to implement 3NF (third normal form) in ArcGIS attribute tables? I need, among other things, to place foreign key in my tables to combine them and ...
1
vote
1answer
92 views

Invalid Primary Key error message when attempting to join table view and feature layer

I am attempting to join a feature layer to a table view in order to export a table of all non-joining features in the table view by selecting NULLS from the join field related to the feature layer. ...
0
votes
1answer
45 views

Mean values from a table in Earth Engine

I have uploaded a table containing information on river basins within countries (https://code.earthengine.google.com/?asset=users/basins/TFDD_BCU). I want to calculate the mean population density in ...
1
vote
1answer
50 views

Table to Distance Between in PostGIS

I am a new user in PostGIS. I need to create a table with the ID_DIR of table A, ID_SQ of table B and have a new column called "Distance" that would be the distance between the ID_DIR and the ID_SQ in ...
1
vote
0answers
32 views

Exporting empty fields as NULL

I am using QGIS 3.4 and I work with a shapefile and its Attribute Table with a few rows where some fields are just blank (no zero value or NULL). When I export the shapefile file to ArcGIS Pro all ...
2
votes
1answer
54 views

Converting 0 to NULL in attribute table

I am using QGIS 3.4 and I want to change all my 0 values to NULL. How can I do that in the attribute table?
1
vote
1answer
41 views

Attribute Joining with .shp and .dbf showing NULL values in ArcMap?

I have a shapefile that only has 2 fields, one of which is the same as one of the fields in the .dbf file. I tried joining these 2 by their common field but after I do so, the 10 other fields in the ....
0
votes
1answer
50 views

Fetching data from ArcGIS attribute tables using ArcPy? [closed]

I want to fetch/extract data from ArcGIS attribute tables (to set some temporal series) using Python. Because of the structure of my tables and their disposition, I thought of using the "division" ...
5
votes
2answers
153 views

Finding minimum value of different columns using QGIS?

I'll try to calculate the minimum value of four different columns in my QGIS table like: The min. value would be 1,50286 in the first row. Is there any expression or tool to find the minimum value ...
1
vote
2answers
54 views

Decimals are in wrong place in latitude and longitude in Excel

Somebody gave me an Excel table and the latitude and longitude had the wrong place for decimals. Is there a workaround to fix the problem? I am pretty much stuck trying to figure it out. Here is the ...
0
votes
0answers
12 views

Creating polygon for each day from table with change of area over time (by day) using ArcGIS Pro?

I have a .csv with data in rows over time (date field and multiple attributes for each day) of the same single area - the fields are high temperature, low temperature, humidity, precipitation. I want ...
6
votes
2answers
1k views

How to delete fields from a Geopackage attribute table?

Using QGIS 2.14.0 on a Microsoft Surface Book with Windows 10, I created a geopackage from a layer using Save As... I can successfully add a field to the geopackage's attribute table, calculate ...
5
votes
3answers
11k views

Avoiding General function failure and deleting table field in ArcGIS Desktop?

I am trying to delete a table field: From ArcMap table view, I right click on the field heading and select Delete field. Unfortunately, I obtain the following message: Failed to delete the selected ...
1
vote
1answer
111 views

Analytical hierarchy process tool - SAGA. How to configure Pairwise comparisons table?

What is the configuration and extension (.txt, .csv ...) of the Pairwise comparisons table file requested by the SAGA AHP tool- Analytical Hierarchy Process - in QGIS? Are there examples of ...
2
votes
1answer
72 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 ...
1
vote
1answer
23 views

Select records from shape that do not match another table's values

New to the forum, so I apologize for my bad English and if I'm being inconvenient somehow! I read answers that are similar to my question but none of the ones I found fits my case. I have a shapefile ...
0
votes
0answers
45 views

Classifying Attribute Table values? [duplicate]

I have an attribute table with a lot of lines. I want to classify them considering their length: SHORT (from 0 to 50) MEDIUM (from 50 to 150) LONG (from 150 to 180) How can I do avoiding to modify ...
1
vote
1answer
57 views

ArcPy rollback update / insert cursors if error occurs

Is it possible to rollback an update made with an update cursor or an insert made with an insert cursor if an error occurs? I need to go through a feature class and break numbers up into 100 groups. ...
0
votes
0answers
20 views

Table to domain giving ERROR 999999?

I am getting an Error while trying to execute "table to a domain". The domain is "Nednaam": The table is a .xls file, named "NedFlora", also a tekst file and looks like this: My input: My output: ...
1
vote
0answers
208 views

Creating title blocks in QGIS

I am trying to create a table in composer to be positioned at the base of the map and is essentially a title block to provide information in text, image and table form. The only success I have had is ...