Questions tagged [table]

A set of data elements arranged in rows and columns.

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

Table to point feature class using ModelBuilder of ArcMap

I am trying to convert a table in a fGDB to a point feature class using ArcMap 10.8. I need to do this in the ModelBuilder . The table has about 8000 records, containing X and Y coordinates and many ...
1
vote
1answer
37 views

PyQgis : Creates table coordinates of selected feature and add it to layout

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 ...
1
vote
0answers
14 views

GEE ui.panel error

I want to creata app to calculate "RMSE" index by table , but I can not select the variance in table here is my code link: https://code.earthengine.google.com/?scriptPath=users%...
1
vote
1answer
90 views

Exporting/Listing printed console results in a table in Google Earth Engine

I wrote a code with different function to bring me different output values e.g. the values at specific dates, statistics, cloud cover, etc. I printed them all individually in the console but now I ...
1
vote
0answers
29 views

Ask ArcMap to recognize updated CSV file content

I have a CSV file that I am updating outside of ArcMap (v10.4.1). How can I get ArcMap to see the revised content instead of the old content? ArcMap does not automatically see the updated version. My ...
2
votes
0answers
23 views

Switching between alias names and table names using ArcPy in ArcGIS Pro

Whenever I add standalone tables from my file geodatabase to an ArcGIS Pro map, the alias names are displayed instead of the table names. I want to view these tables using only their table names. ...
2
votes
1answer
19 views

Loading non-spatial tables from geopackage into ArcGIS Pro

I have a geopackage comprising spatial and nonsapatial tables. I would like to be able to load all of the tables into an ArcGIS Pro 2.6 project, however, when I connect to the geopackage I'm only able ...
2
votes
1answer
75 views

Google Earth Engine: Calculate milliseconds since epoch from datetime of uploaded shapefile?

I want to get the milliseconds since epoch of thousands of points, each with different timestamps. Here is what I believe I need to do, but my Google Earth Engine knowledge is limited and I can't find ...
0
votes
1answer
43 views

SpatiaLite splitting large polygons from imported shape file into multiple rows

I have this shapefile: shapes.shp in which I have imported in SpatiaLite using this command: spatialite_tool --import --shapefile shapes --db-path db.sqlite --table shapes --charset UTF-8 --srid 27700 ...
1
vote
1answer
75 views

Google Earth Engine Coordinates from Table

I am trying to import Table data into GEE. The original CSV file is at TERN Star Transects. I have followed the steps at GEE Importing Table Data (including making sure to specify either the x and y ...
0
votes
1answer
48 views

HTML table file in atlas

I have I field "MEMORIAL" in one of my vector layers with the source of a html file. The file is a table that I would like to appear in my atlas through HTML frame. How can I do that?
0
votes
1answer
43 views

Interpreting total cost variable in QNEAT 3 OD Matrix using QGIS

I am using QGIS 3.16. The Matrix itself is optimised for Travel Time using pre-defined speed-limits on roads (These are ok, I have checked them). However, the total cost output is in the thousands (i....
3
votes
2answers
70 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 ...
0
votes
1answer
57 views

How to convert an 2D array image to table - Google Earth Engine

I'm trying to get a table from a 2d-array image. Basically, the Image (called segmentationInfo) looks like this: The 2-D ‘LandTrendr’ annual segmentation array looks like this: [ [1985, 1986, 1987, ...
0
votes
0answers
17 views

How to read postgres sql Table (No geometry) in PYQGIS? [duplicate]

In my database there is a table without geometry. how to read that from from pyqgis. self.uri = QgsDataSourceUri() self.uri.setConnection(self.Hostname, self.Portid, self.Dbname, self.Username, self....
1
vote
0answers
28 views

Generating Table or chart of point values per polygon from time series - Google Earth Engine

I'm trying to generate a table with my GNDVI points value from a time series. I have a feature collection of my polygons, another feature collection of my random points in the polygons. I have a image ...
0
votes
0answers
21 views

Display selected feature table in layout [duplicate]

l have table and want to display selected feature in layout (print version). When select other country (look image) show me these country data in print version. Mostly do this by copy and paste in ...
2
votes
1answer
68 views

Adding a table frame in ATLAS for QGIS

I am customizing an ATLAS in QGIS and I would like to insert a table frame to introduce all attributes belonging to one feature. I have seen it is possible to add the attribute table but for my ...
1
vote
1answer
202 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 ...
0
votes
0answers
15 views

Changing entries in attribute table from text to rational number [duplicate]

I recently merged two sets of data in a single attributes table. To my surprise I can not opperate the variables or observations because, for some reason, it recognized the numbers in different ...
1
vote
1answer
112 views

Store the filenames of .kml files into the attribute table of a shapefile

I have to be joining .kml files in a single shapefile. The problem is that the kml files comes with a name that when I convert it into a shapefile it is not kept in the attribute table. thus, I lose a ...
0
votes
0answers
44 views

Building table about LULC historical (rows: categories; column: data by year)

I'm working with datas of Land Use and Land Cover (LULC) (annual shapefiles) in a period of 1985 to 2018. I want to build a historical LULC table (rows = category; column = year LULC) using these ...
1
vote
1answer
81 views

Accessing data from time series in GEE

I have a code for NDVI time series from an image collection. This code prints the time series in a table or a chart. Is there a way to access the values in the table of the time series in google earth ...
0
votes
0answers
36 views

Printing a table fro time series on google earth engine

I'm quite new to GEE. I have code that prints a time series of my image collection. I know that it is possible to download the data to a csv file but is there a way to view my time series data in a ...
1
vote
1answer
54 views

Extract multiple values from multiple points and export as a table

I am using Google Earth Engine to collect a training dateset for supervised classification, and the code is shown as follow: // 0. Global Variables var site = ee.Geometry.Polygon([[-80.79, 24.98], [-...
1
vote
0answers
55 views

Raster to ASCII -9999 for all cells!

I am trying to simply get the value of each cell in my raster using the Raster To ASCII tool in ArcGIS Desktop. I have absolutely no idea what I am doing wrong. The output I get is all -9999 when the ...
0
votes
0answers
43 views

Opening Access table in MapInfo

This morning, when I tried to open the Microsoft Access Database in MapInfo, MapInfo crashes. I then tried to save a .tab file as Microfost Access Database format and the same happens, MapInfo crashes....
1
vote
0answers
32 views

SQL for Select By Attribute to only select Feature Class Polygons based on values from a Table

I have a polygon feature class with one of the attributes being Parcel ID Numbers (Parcels_in_City). I have a table with only Parcel ID Numbers (Parcels_with_Trees). Is there a SQL query that can be ...
0
votes
1answer
74 views

How to export image/imagecollection (raster) as table in GEE?

I have calculated LST (land surface temperature) of a city, so I have an image. I can export it to my drive as .tiff, but what I need is a table that contain LST value for each longitude and latitude ...
0
votes
0answers
29 views

static external HTML table renders smaller than expected in QGIS

A colleague gave me a QGIS layout including a static html frame. The HTML is exported from MS Word (don't ask). It contains of a table (with shading), and some lines of text outside of the table. It ...
0
votes
0answers
49 views

Adding multiple Excel files and display XY data using ModelBuilder

I would like to use ModelBuilder to add multiple Excel files and display the XY data as a shapefile and eventually convert the point data to raster. I am using ArcGIS Desktop 10.4. I have tried the &...
-1
votes
1answer
50 views

Adding a property while converting a table into a list in GEE

Is there a way to add a property when converting from a table to a list? I have a table of lat and long points uploaded from a .csv (locTable), and found a GEE code that changed the format of my table ...
3
votes
2answers
127 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 ...
2
votes
2answers
107 views

Writing a number if another field is not null in QGIS Table

I am trying to make a condition in a new column that if there is a value in another column, a number will be filled accordingly For example Here's the table If there is a value in "watt_3" ...
1
vote
0answers
43 views

Rotate a table but not the text in a QGIS Layout

I'm working in a QGIS Layout and I have an special requirement: I have to rotate a table but I need that the text remains horizontal. When I check the rotation settings, the "Expression" option just ...
0
votes
1answer
87 views

Load multiple file geodatabase tables into R directly from a FGDB (arcgisbinding package)

I have a large number of file geodatabase tables that I'd like to load directly into R as data frames. I have upwards of 80 - 100 tables and it would be much more convenient to automate this process. ...
0
votes
1answer
49 views

Overwrite previously exported Excel file

I am exporting a table to Excel and I would like the overwrite access to be on. Below is the code line. Please let me know how I can give overwrite access through the code if it is possible. #Export ...
1
vote
1answer
43 views

How to get a report of the unjoinable records from a table when joining attributes by field value in QGIS?

I am working on a "Join attributes by field value" processing, but I would like to get the "unjoined" records from the table, not those from the vector layer, and if it's possible, to get a report in ...
0
votes
0answers
29 views

When copying information into another layers attribute table objects turn invisible

When I try to copy the information of one layer into another via attribute tables the data is shown in the table but it's not visible (when I push the button in the attribute table to show only ...
0
votes
0answers
24 views

Table to Table works differently when implemented in Jupiter Notebook and ArcMap

I tried to import a lot of tables from geodatabase to .csv to later work with them. I encountered strange values and decided to do it manually for one table through the ArcMap interface. Everything ...
1
vote
1answer
270 views

Plot Circles / Polygons with KM radius from CSV in Google Earth Engine

I'm looking to plot a series of points with a set radius in google earth engine from a CSV. The table.draw function I'm currently using plots a pixel based radius, how can I convert this to a Km based ...
0
votes
2answers
646 views

Google Earth Engine: How to Create A Table From Lists

I want to create table-format feature collection from a couple of lists. These lists only have 4 elements in it. My objective is to create a feature collection with a column per list and a row per ...
0
votes
1answer
165 views

Appending a table asset with ImageCollection pixel values for specific dates and coordinates in Earth Engine

In Earth Engine I have a table asset of coordinates and dates (properties `LAT', 'LONG', 'DATE') for which I would like to return a pixel value from my ImageCollection dswe_ic, which gives a monthly ...
1
vote
2answers
157 views

Error message: Invalid geometry Refactor Fields QGIS

I'm trying to do a simple modification of changing field type to vector table by using the tool Refactor Fields. However, the output log returns the following error message, every time: Traceback (...
3
votes
1answer
182 views

Export Table of Unique Values by Field

I get a lot of shapefiles with no metadata. Grrr. Often there are tons of table columns (fields) with no description of what the column is for or what the coded values mean. Is there an easy way to ...
0
votes
1answer
47 views

Recovering table data from table layer of ArcGIS.com

I am a researcher tracking Florida's COVID-19 tests that they report on the coronavirus dashboard here: https://experience.arcgis.com/experience/96dd742462124fa0b38ddedb9b25e429 They used to have a ...
0
votes
1answer
28 views

QGIS: cannot reload attributes columns [duplicate]

Unfortunately I have clicked on the edit button in the attributes table and the spreadsheet with the polygons and their attributes has disappeared (see picture). It is likely that I am making a ...
3
votes
1answer
468 views

Change date format into readable format in GEE

I have code in GEE which create table with the sentinel2 mean NDVI data for certain period. my problem is that the table in the end has two column with the dates, one is the name of each image (not ...
2
votes
2answers
79 views

Creating table in ArcToolbox Script with ArcPy

I want to create a Python Script for ArcGIS, using arcpy. The script would have several user input fields. I would like to create a table based on one or two of the user input (the path and name). I ...
1
vote
1answer
1k views

Adding x,y coordinates from table in Google Earth Engine

This might be quite basic, but I'm struggling with adding points to a map from a CSV table of x,y coordinates in Google Earth Engine (I have over 2000 points). I have managed to add the points as a ...

1
2 3 4 5
10