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
9 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
35 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
16 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
15 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 ...
0
votes
0answers
11 views

Table of coordinate in the layout once you are using the data driven page [closed]

I'm using data driven page to produce many map of block. These blocks are define by they coordinates and they name. these blocks are in polygon. And i would like to show to the layout the coordinate ...
1
vote
0answers
26 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 ...
2
votes
0answers
31 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
24 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
26 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
78 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
58 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
72 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
37 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
38 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
39 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
90 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
24 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
18 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
62 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
43 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
45 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
135 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
61 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
113 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
183 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
23 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
67 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
96 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
40 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
43 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
26 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
26 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
71 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
40 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
45 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
1answer
93 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
38 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
143 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 ...
0
votes
1answer
67 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 ...
2
votes
3answers
107 views

Historical Hurricane data

I am searching for a data source on past hurricanes that includes the coordinates of the path at different times including wind speed pressure and category. Any other added data would also be helpful.
0
votes
0answers
47 views

Create dynamic table in layout that is connected to Access

I was wondering if it was possible to have a dynamic table that would be updated when changes are made to Access document? So far, I have been able to link my Access database to ArcMap but haven't ...
0
votes
1answer
32 views

Editing DB contents

I have loaded polylines from the CSV below: name;type,status;wkt 01001-4;Integrated;virgin;LINESTRING(xx.x yy.y,xx.x yy.y) and it populates the table in the DB. What I would like to do is change ...
0
votes
0answers
17 views

QGis deletes data after entering editing mode

we observed strange behaviour of Qgis 2.18.15 - when entering editing mode for a shapefile layer, Qgis erases data from specified columns in table of attributes - for the first record in the table. ...
0
votes
2answers
51 views

Exporting to Excel gives ERROR 000732?

I have a script that buffers a selected point, and intersects that buffer with features that the user inputs. I would like to convert the table outputted from the Intersect process into a excel file. ...
2
votes
1answer
35 views

Transfer geometry from shapefile to related table?

We would like to contact our volunteers based on their geographic location. We settled on zip codes as a reasonable proxy for location, and now have a table with volunteer contact information and zip ...
1
vote
1answer
54 views

Using VBScript for advanced labeling in ArcMap?

I am trying to do some advanced labeling with VBScript and need some help getting to the finish line. I have never scripted anything prior to last week so I am definitely a newbie when it comes to ...
0
votes
0answers
311 views

Google earth engine - export month data as a table for analysis

My code has been adapated from Code for monthly NDVI medians in Google Earth Engine to calculate average sst by month and year var sst = ee.ImageCollection('NASA/OCEANDATA/MODIS-Aqua/L3SMI') .select('...
0
votes
0answers
15 views

Enable time in related tables on ArcGIS Pro

Is there an option for user to enable time in related tables, then make a relationship class with another layer? Example: Tables I have: 1) Tax report from 2016 Parcel number, Tax revenue, year 1,...