Questions tagged [table]

A set of data elements arranged in rows and columns.

Filter by
Sorted by
Tagged with
0
votes
0answers
10 views

Adding Images/Attachments to Survey123 in Inbox

Project Background: I have a spreadsheet of existing assets that I will be inspecting in an upcoming site visit. I uploaded the Existing Assets CSV file to AGOL to create a feature layer. A PDF of the ...
4
votes
1answer
43 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" ...
1
vote
1answer
15 views

Updating ArcGIS Online Hosted Table

I published a table (File Geodatabase Table) to ArcGIS Online as a hosted feature for the purposes of creating an Operations Dashboard. Unfortunately, I have no idea how to update it. I've been able ...
2
votes
1answer
28 views

Reading through shapefile table with Geotools

Goal: Read through a shapefile table with Geotools. I'm confused about FeatureSource, FeatureCollection, and FeatureIterator in Geotools. In ArcGIS, I can open a table in an existing shapefile, and ...
1
vote
1answer
24 views

Creating a table view using SQL?

I'm trying to create a table view using SQL to join a table and a feature class together. When I try to create the view, I get an error saying there is an incorrect syntax near the keyword 'CREATE'. I'...
0
votes
0answers
31 views

Add missing features to attribute table

I have two tables with complementing data in them. Both have an ID column (tree_ID). Table A is missing several features which are in table B. How can i copy only features from B to A which are NOT ...
0
votes
0answers
22 views

Exporting Each Image in a Collection to Table (CSV)

I have calculate composite NDVI for each month from Sentinel-2 and added the NDVI band to resulting imagery (12 Image collections for 12 months). My interest is to export at once each month's ...
2
votes
2answers
40 views

QGIS 3.6 - Deleted Polygons

I'm putting together a large map consisting of some big datasets, and unfortunately deleted some (around 25) polygons from a key layer when editing a smaller version of the map for a different request....
1
vote
0answers
19 views

Making chart with related table using ArcGIS Pro

I have a feature class with some locations of drills. I also have a table with data how deep the drill went and some more technical data in it. I used relate on the feature class to connect the ...
1
vote
1answer
35 views

Getting subtypes from standalone table in ArcObjects

I have been working in the next code to get all Subtypes from a standalone table in a single string that concatenates it. I work with ArcMap and arcobjects library in C# (sharp) language. But I can ...
3
votes
1answer
45 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 ...
0
votes
0answers
8 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 ...
1
vote
1answer
65 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
31 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
35 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 ...
0
votes
0answers
20 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 ...
0
votes
1answer
26 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?
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
1answer
67 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 ...
0
votes
0answers
22 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
68 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
33 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
60 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 ...
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
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
36 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
58 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("...
1
vote
0answers
34 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 ...
3
votes
1answer
58 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?
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" ...
0
votes
1answer
32 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
45 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 ....
1
vote
1answer
54 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
2answers
57 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 ...
5
votes
2answers
171 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
1answer
55 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 ...
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 ...
2
votes
1answer
88 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
194 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 ...
1
vote
1answer
26 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
76 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
27 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
255 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 ...
0
votes
0answers
17 views

Getting list of regions that lines intersect with using ArcGIS Pro?

I am using ArcGIS Pro. I have a bunch of line features with unique ids and a bunch of polygons with unique ids. I want to know how many and which polygons each line interacts with. The only way I ...
1
vote
0answers
83 views

Show towns per province using QGIS value relation widget?

I have basic (maybe a little more) knowledge of databases and GIS. I study Archaeology and for my thesis I am designing a local database in QGIS (consist of shapefiles with their relationships). I ...
1
vote
0answers
152 views

Adding table to layout using PyQGIS [closed]

I need to create a table based on a Python list and paste it in layout view in QGIS. I also found a QgsLayoutTable class in PyQGIS but there's no example of creating a simple table. Does anyone know ...
2
votes
1answer
57 views

“Empty” cells in attributes table - QGIS3 - QuickOSM

Just why? (look at picture below) Why no data in attributes table? There should be infomation about map features. I check this area in QGIS on PC with Windows, and there is no problem with table... ...