Stack Exchange Network

Stack Exchange network consists of 174 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
8 views

Reducing hourly rainfall data to monthly data and printing as a TABLE [duplicate]

I am working with GSMaP image collection (hourly rainfall data) in Google Earth Engine. Below, you can find a script which is calculating and making a chart of sum rainfall in particular location ...
1
vote
0answers
33 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
41 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
51 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 ...
-1
votes
0answers
23 views

Relationship between an element and a table with no geometry

I'm trying to relate an element in a shapefile with a table that is on QGIS already. This table doesn´t have geometry but does have hyperlinks that I want to keep. I need an action button for each ...
0
votes
1answer
29 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 ...
2
votes
1answer
42 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
43 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
20 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
48 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
84 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
39 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
38 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
44 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
18 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
23 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
51 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
28 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
19 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
73 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
37 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
114 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. Every playground has a different number of photos (between 1 and 13) connected as an attribute value. The value contains ...
0
votes
1answer
64 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 ...
1
vote
3answers
75 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
41 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
15 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
48 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
31 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
48 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
188 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
13 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,...
0
votes
1answer
24 views

Finding coinciding points in point shapefile using ArcMap?

I have a point SHP with some points overlapping, they have the exact same X & Y coordinates, I want to extract these points to a new table. I tried FindSimilar python script but no results.
1
vote
0answers
45 views

Table not displaying all rows in ArcGIS Desktop?

I'm working with a txt file in ArcGIS. When I display the table and scroll down it seems to encounter an error and won't display any records past about 10,400. There are roughly 200,000 records. It ...
-2
votes
1answer
60 views

Calculating total numbers of wells that fall into each county of table using ArcPy?

Directions: For each county calculate the total numbers of wells that fall into that county, and update the county table with the total count. This is the code I have so far. Problems: The ...
1
vote
1answer
18 views

Table field names mixed up in table view of ArcMap?

I'm having trouble figuring out why apparently a table from a file geodatabase isn't interpreted correctly. These are some of the fields as they should show up in the table view: However, the table ...
0
votes
1answer
44 views

Selecting records in table from feature class using ArcGIS ModelBuilder?

I have a table and a feature class in a file geodatabase. I want to export records from the table that match what is in the feature class using ModelBuilder. For example the table contains 100 records ...
0
votes
1answer
30 views

Exporting Feature Classes in SDE to shapefiles and tables

How can I export feature classes and tables in SDE to shapefiles and tables? I am able to export the feature classes to shapefiles based on an extent. The problem I am running into is, I want to ...
4
votes
2answers
225 views

Using vlookup function in ArcMap?

I am trying to automate a field calculation using ModelBuilder, using a GDB table to populate a feature class field given two conditions: Traffic Count Value and Posted Speed limit I have created ...
0
votes
0answers
29 views

Getting spreadsheets to autopopulate tables?

I am working on the Arcgis local government solutions Election Results web app and hosting it out to arcgis online organization. After looking at the spreadsheets, the tables and related feature ...
1
vote
0answers
133 views

Investigating slow performance when opening tables in ArcGIS Desktop? [closed]

My ArcGIS 10.5 performance is very slow just in opening some thinks like: Options, tables, labels, arctoolbox, draw menu ect. It open the mentioned things in about 3 minutes. I have tried different ...
2
votes
2answers
56 views

Show the rule-based style in the attribute table?

I need this for a university project and have been trying everything I could without success... I had this shapefile from our region (LAZIO) where I could easily get out of it area values and from ...
0
votes
0answers
14 views

assigning numbers to a new field in Arcmap [duplicate]

I want to assign number to each value in a field to a new field. For example in my table there are values like, A, AE, X, AC.. In a new field there should be A=1, AE=2, X=3, AC=4. How can i do this ...
1
vote
2answers
39 views

Inserting an annotation onto all plotted points?

I have an attribute table of 73 polling stations, and using the labelling function, I have labelled all of the points in preparation for printing on polling cards for our some 60000 electorate. After ...
0
votes
2answers
317 views

Is there a service or way to input a table of lat long and return an output of street addresses?

The following website can be used to enter a single pair of latitude and longitude coordinates and return a street address: https://www.latlong.net/Show-Latitude-Longitude.html I want to get street ...
0
votes
1answer
162 views

Register with Geodatabase greyed out

I'm having trouble registering a table with a Geodatabase in an SDE, the option is greyed out. This is a weekly task for me and I have never had this happen before. I receive a new table weekly from ...
0
votes
0answers
33 views

Is it possible to copy-paste a table from excel into an Activated data frame?

I am creating a map series via data driven pages, and need each map to have its own table. I know you can copy-paste excel tables directly into the mxd, however, when I try to activate the data frame ...
1
vote
1answer
105 views

Create a pivot table for m-n relationship in QGIS?

My dataset comprises many polygons representing workspaces over a large area: -1 vector layer comprising my polygons (each polygon ID appears 1 time) For my online atlas however I need to obtain a ...
0
votes
1answer
764 views

Sorting strings separated by commas within field using Python Parser of ArcGIS Field Calculator?

In ArcGIS 10.4.1, I am using the Python Parser of the Field Calculator. My Python knowledge is limited. I would like to recalculate a field of strings that are separated by commas so that they are ...
1
vote
1answer
33 views

Points drawn outside a certain area get placed on perimeter of smaller area

I am trying to add points to a table in MapInfo (geologic map) but cannot get points to display in correct location. Are there boundaries for tables? How to change this? I'm using Mapinfo 10.5.