The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [table]

A set of data elements arranged in rows and columns.

Filter by
Sorted by
Tagged with
0
votes
0answers
43 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
98 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 ...
2
votes
0answers
105 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?
0
votes
3answers
747 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
330 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 ...
4
votes
1answer
301 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
576 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
28 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
94 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
154 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
43 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
47 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
46 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
35 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
33 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
152 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
102 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
295 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
195 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 ...
2
votes
2answers
184 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
79 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
159 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
1answer
33 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
2answers
63 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
45 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
88 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
1answer
27 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
96 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
86 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
31 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
82 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
47 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
474 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
223 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
65 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 ...
1
vote
2answers
40 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
3answers
628 views

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
278 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 ...
1
vote
1answer
184 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
1k 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
50 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.
0
votes
1answer
129 views

Code features based on their rank of an attrbute

I would like to have all the records in a table given a rank value based on the values in another field. The caveat is that there are tied rankings. For example in the attached screen cap, EPDO is the ...
1
vote
1answer
521 views

Appending rows to empty FeatureClass with ArcPy

My goal is to delete all rows in an existing feature class, then append new rows from a new shapefile... everything works except for the append. The table-view portion as the input is giving me the ...
1
vote
1answer
25 views

Why “new” dataset table is deleted when trying to update existing dataset table in Esri Insights workbook?

I have an established Insights workbook, with designated cards. The data being used comes from "Table A" when I add "Table B" (updated data) and attempt to 'Update' Table A - which should be a very ...
1
vote
0answers
92 views

joining tables with different number of entries

I work in ArcGIS 10.3 and I have this problem: I have a dbf table of about 300 restaurants, each restaurant has a different values like address, number of seats etc. I have another dbf table of beers ...
0
votes
1answer
133 views

Bulk exporting of maps based on attribute table using QGIS?

I have 73 locations that I have plotted in my attribute table, which I've labelled and can successfully create a map using Template Selector and then export this to a PDF for processing. Is there a ...
2
votes
1answer
40 views

Join from list with duplicates in list

I have a vector layer that i would like to join with a list. The problem is that my vactor layer does not hold any overlapping or dublicate objects, but my list does. The list does not have any ...