Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [table]

A set of data elements arranged in rows and columns.

0
votes
0answers
15 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
43 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
16 views

Filter fusion table data [on hold]

I need to filter a collection based on data in the fusion table. For instance, I need to filter MOD13Q1 collection based on the date which is situated in a fusion table as the start date and the end ...
5
votes
2answers
95 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
31 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
10 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
44 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
55 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
44 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
36 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
16 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
65 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
23 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
29 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
64 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
31 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
30 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
103 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
62 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 ...
1
vote
4answers
109 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
48 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
40 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
79 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
127 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
28 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 ...
0
votes
1answer
36 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. ...
2
votes
1answer
96 views

Pivot Table - flatten multiple fields

I'm trying to flatten a table, but I want to keep/relate certain fields tied to each other. For context, I ran a Generate Near Table to try to find the traffic volumes near intersections. I am trying ...
1
vote
1answer
46 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
52 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
43 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?
0
votes
3answers
260 views

Convert a list into ee.FeatureCollection in Google Earth Engine

Starting with this, I have // load var landCover = ee.ImageCollection('MODIS/006/MCD12Q1'); var country = ee.FeatureCollection('USDOS/LSIB_SIMPLE/2017'); // filter // filter on image for 2017 and ...
0
votes
1answer
101 views

OSRM Table service returns empty array when I use a HTTP Server

I am currently trying to use OSRM's Table service to get the durations of the fastest routes between two points, to be able to build a time matrix using Python and later use it as a parameter in an ...
3
votes
1answer
180 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....
1
vote
1answer
280 views

Google Earth Engine - Remove geometry fields from FeatureCollection for export to table

How do I remove the geometry fields from this feature collection? They are not necessary and give me a messy table in excel. // Add reducer output to the Features in the collection. function ...
0
votes
1answer
24 views

Using Make Table View tool in ArcGIS Pro?

I was going through the documentation of MakeTableView Tools here # http://pro.arcgis.com/en/pro-app/tool-reference/data-management/make-table-view.htm I came across the output of the tool as a ...
-2
votes
1answer
80 views

Answer to fixing corrupted shapefiles [closed]

Where 'Number of shapefile records does not match number of table records' Error occurs; I found that none of the Arc tools would help me but QGIS has the ability to open just the shapefile; in my ...
1
vote
0answers
113 views

Filter on joined tables in QGIS

QGIS 3.2.3: I have a shapefile and an Excel table which is joined to the shapefile based on matching IDs. I would like to filter the shapefile while using a joined field from the Excel table. When I ...
1
vote
2answers
42 views

Breaking lines in PostGIS?

I have a roads table and I want to break the lines in the intersections like the v.clean tool from GRASS (I'm talking about how the break tool in the parameters works). How can I do the same process ...
1
vote
2answers
45 views

Adding formatted sequence Number based on location?

I have Feature Point DATA. I need to add some sequence number to the attribute of each point, based on their location in the display map. In my attribute it'S ordered in the opposite way. In ...
2
votes
0answers
45 views

What are these files? Why they cannot be turned on/off?

My question is why there are some layers which cannot be turned off? In my Google Earth project those were main maps and then other polygons/paths were, but In QGIS I am not able to turn them all off/...
1
vote
1answer
29 views

Error 2 Creation of data source “A”.“B” failed: ERROR: relation “B” already exist [closed]

Does anyone know what I may be doing wrong? Foolish question from a newbie perhaps but as I reckon it may be the code for table "B" that I created, how do I edit the code in pgAdmin3? The key aim of ...
-1
votes
1answer
27 views

Using dBase table converted from CSV to Make Route Event Layer?

I'm using the tool 'Make Route Event Layer' and I need to use a dBase table for the event table, but the data are saved in a CSV file. When I try with dBase table that I created myself all go good, ...
0
votes
1answer
88 views

Adding values from a table to an image band - Google Earth Engine

I'm trying to add values from a table to a cluster image. The cluster image has 50 cluster classes, and my table has 50 values for each cluster class. How do I add the values from that table to the ...
0
votes
1answer
55 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 ...
0
votes
0answers
79 views

ArcGIS Online Symbology from related Table

I have not found a method of accomplishing this: I have a layer (and related tables) in SQL server hosted on ArcGIS Server 10.6.1 being consumed in ArcGIS Online Web Map. All this works great but I ...
1
vote
2answers
131 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 ...
0
votes
0answers
43 views

QGIS MSSQL datatable only querying one record

I made a successful connection to a local MSSQL Database where there are no spatial tables (only datatables). I list the tables/views in the database (clicking on "Also list tables with no geometry" ...
2
votes
2answers
156 views

How to add a dynamic number of pictures into a Leaflet popup?

I have a huge dataset of playgrounds I want to represent in a Leaflet map. Each playground has a different number of photos (between 1 and 13) connected as an attribute value. The value contains the ...