Questions tagged [table]

A set of data elements arranged in rows and columns.

Filter by
Sorted by
Tagged with
0
votes
0answers
18 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
21 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?
-1
votes
0answers
57 views

Create graphically a graph (made of nodes and edges) and generate a table [closed]

I want to manually, by means of a graphical GUI, create a graph, in the sense of a mathematical structure made of points connected by edges. I have already a set of geocoded points in a GIS layer. I ...
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
32 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
16 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
41 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
31 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
58 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
28 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
55 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
25 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
31 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
51 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
49 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
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
40 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
43 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
51 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
143 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
49 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
65 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
94 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
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
54 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
19 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
178 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 ...
0
votes
1answer
56 views

Create a Dynamic Table in your Map Layout

I am trying to create a graphic table in the layout below are ESRI instruction but I don't have an option to insert the Graphic Table Element (see attached photo You can only add this table in layout ...
1
vote
0answers
49 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
126 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
50 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... ...
1
vote
1answer
31 views

More creative or efficient solution for a proximity table (1:m) to all points within X distance, keeping obs. where no points fall within X distance?

I have a proximity question. I am open to Arc or Python solutions. I am mainly asking because I think I am lacking a little creativity in approaching the situation. The Situation I have two point ...
3
votes
1answer
173 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 (...
2
votes
1answer
67 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 ...
2
votes
4answers
203 views

Retrieve last Row and specific field values with SearchCursor

I have a shapefile from which I want to retrieve the last row values for specific fields to use them as input in a tool. So far this is what I have which does not work. length=int(arcpy....
1
vote
1answer
61 views

Copy Table Failing with ERROR 000732 in ArcPy?

Very new to Python. I am trying to copy between Feature Datasets, Feature Classes, and Tables between two GDBs. Here's my code: The following attempt works when Irfan_FC is a feature class: #Copy ...
0
votes
2answers
49 views

Adding row with default values to new created table with ArcPy?

In my code I am creating a table with some fields. The fields should be filled with 0 (Datatype of the fields are LONG or DOUBLE). I want to fill them because afterwards I want to update the values. ...
0
votes
0answers
152 views

How to update column based on data from another table (Mapinfo Pro)?

What I want to do is update column (Table A) by values from another table (Table B) using condition intersects. There are few objects in table B which intersects one object from table A. When I try to ...
5
votes
2answers
187 views

Table to Table converting ArcMap table to CSV file in external location cuts column names short?

I am having a strange problem with the ArcPy Table to Table function. For some reason, when I use the function to create a CSV file in a folder that exists outside of my python project folder, several ...
0
votes
0answers
40 views

export pymssql query to geodatabase table

I have thousands of databases in Microsoft SQL Server and I want the user to select the server and DB they want so I cannot use arcpy.ArcSDESQLExecute I am trying to use pymssql to connect to the ...
1
vote
1answer
87 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. ...
1
vote
1answer
53 views

Point data extraction and printing as a TABLE

I am working with MODIS-NDVI image collection in Google Earth Engine. Below, you can find a script which is creating a chart of NDVI values over the given period for particular location. I would like ...
1
vote
0answers
83 views

Copying tables results in duplication of some tables, feature classes and relationship classes

ArcGIS Pro 2.2.3. I have a file geodatabase called "supportSource.gdb" with 3 tables, 2 feature classes and 3 relationship classes. I just want to copy the contents of this file geodatabase to ...
1
vote
1answer
44 views

For periodic updates can a geodatabase table be replaced?

I am pulling in CSV tables, that are updated frequently, into a file geodatabase. Is there a way to overwrite the old table with the new one?