A set of data elements arranged in rows and columns.

learn more… | top users | synonyms

3
votes
0answers
46 views

How to handle large tables in QGIS using python?

I'm currently writing a plugin that calculates values based on a QgsVectorLayer's attributes. To display and print the values I'm using a QgsComposerTextTableV2. I have several problems with my ...
0
votes
1answer
30 views

Calculate Raster with value from table

I would like to multiply all the values within a raster layer with one value, which is written in an *.csv table (it is the only value in this table). I tried this code (changing Times tool to Minus ...
0
votes
0answers
29 views

Updating table from Excel spreadsheet using ArcPy? [closed]

This is my code import arcpy arcpy.env.workspace = r"D:\Users\ShawnO\Desktop\PythonExercizes\Parcel_Ownership_update_model\Parcels.gdb" # Local variables: Parcel_Owners = "D:\\Users\\ShawnO\\Desktop\...
2
votes
1answer
128 views

Arcpy.da.SearchCursor() help when attribute doesn't exist

I'm updating text elements off of an arcpy.da.SearchCursor script and needed to construct the script to return a response for when the attribute does NOT exist. Here is the snippet of the code THAT ...
1
vote
2answers
53 views

Why does deleting columns in the QGIS attribute table take longer than in ArcGIS?

In QGis, I recognised that deleting columns takes quite a while - is there a faster way than doing it in the attribute table (in editing mode?). I am speaking about a table with ~ 300 000 lines... ...
2
votes
3answers
99 views

Adding excel table to QGIS print composer?

Can anyone suggest some ideas to add a excel table to the print composer which will then be exported as a A3 png while retaining resolution. Attempted pasting in word as an enhanced meta file then ...
0
votes
1answer
34 views

Finding field with maximum value and field name using ArcPy cursor?

I was wondering if an equivalent of summary statistics exists for finding such statistics across fields rather than records in a table. For example, of several fields, I wanted to find which one has ...
0
votes
1answer
31 views

Files resulting in dBASE table and projection file but not shapefile

Received data from an agency I'm working with. The documentation they included said what they're sending me is a shapefil. When I go into ArcCatalog all that appears is a dbase table and project file. ...
1
vote
1answer
78 views

Merge Shapefiles and Add File Name to Attribute Table

I am trying to merge lots of point shapefiles together to form 1 large shapefile. What i want to be able to do is get the name of each of the point files to appear in the attribute table either during ...
2
votes
1answer
32 views

How can i add coordinates of Polygon nodes on a Polygon data table?

I'm new in this domain and I want to know if I can add to data table of a Polygon.shp, coordinates of node. I have this table pkuid/ name_poly/ area/ lenght/ (here nr_point ex:1,2,3,4 it' about order/ ...
0
votes
0answers
17 views

Adding data labels of Polygon Areas directly to ArcMap?

I need to know whether it's possible to add data labels of polygon area sizes directly to the map and how to do this? I have area data for about 38 polygons, and the distance between each (this is ...
1
vote
2answers
31 views

Merging two atributes columns in ArcGIS for Desktop?

I have a shapefile that is a result of a merge between a land use chart (with two gaps) and two files to fill the gaps, but the atributes in the Land Use Chart are designated by "LEG" and in the Gap ...
1
vote
1answer
47 views

Storing Lat Long Ranges in Tables

Has anyone tried to store nation-wide lat/long ranges as a look-up table? For example: If you had a polygon dataset that covered the entire US (for example, county polygons). And you wanted to look ...
1
vote
0answers
7 views

Showing Attribute Tables in GeoExt

We are making a simple webmap with a Postgis database and Geoserver. So now we have the layers working in Geoserver and we can see the cartography and the the features using GeoExt, but we're not able ...
1
vote
2answers
53 views

How can I display my Excel file in Arcmap 10.4?

I am currently working on a project. I have created an excel spreadsheet: So, I need to attach the spreadsheet into ArcMap 10.4 and show the states population percentage. I have already created a ...
0
votes
0answers
14 views

How can I create a definition query to show the next 5 years of data, based on a text field with the year on a joined table in SDE?

I need to show the next 5 years of construction data, but I want it to automatically update what is shown based on a text field called ConYearStartNbr that shows when the construction is set to start ...
2
votes
2answers
91 views

Remove tables - not just layers - from the map document

How do you remove tables/table views from the table of contents (TOC) in the map document? I've written code that cleans things up after each tool run, but I cannot figure out how to get rid of the ...
1
vote
1answer
114 views

Is *.xls MS Excel default format in ArcMap?

Is it always necessary that whenever we want to show our data kept in Excel spreadsheets in ArcMap, that it must be in .xls? Is .xls a default format for ArcMap?
1
vote
0answers
25 views

Joining a table with an If/Then Statement

I want to join two tables in ArcMap, but not every feature has the same common attribute in the two tables I want to join. For example, "Feature 1" is in both Table 1 and Table 2 and both tables have ...
3
votes
2answers
127 views

Table does not contain OIDs arcpy Error 000339

I have a script I'm working on that takes a SQL table view and performs a Table to Table (arcpy.TableToTable_conversion) If I leave out the Where Clause the Table to Table works flawlessly, however ...
2
votes
1answer
42 views

Adding a table nulls all values in one column

I've read (and had to deal with) values being changed to "NULL" when joining data from a table to a shapefile. Now I'm having an even more basic problem: for some tables, when I add the table, one of ...
5
votes
1answer
98 views

How to delete fields from a Geopackage attribute table?

Using QGIS 2.14.0 on a Microsoft Surface Book with Windows 10, I created a geopackage from a layer using Save As... I can successfully add a field to the geopackage's attribute table, calculate ...
0
votes
1answer
44 views

How can I delete an ITable?

I have created an ITable but I need to be able to delete it if it already exists. How can I delete an ITable? This is the code that I have so far which checks for an existing ITable. public static ...
1
vote
0answers
19 views

Create pointe layer with table [duplicate]

I have a table with 13,000 points of geographic coordinates ( degrees, minutes , seconds) How I can create a layer of points ? QGIS or Arcgis . it is possible to create a layer of points with ...
3
votes
2answers
55 views

Center Text In Table Column

I'm building a static map, and want to center text in a table I've added to the layout. How can this be accomplished in ArcGIS Desktop?
0
votes
2answers
50 views

Add total to a table in layout?

How can I add a total (sum) at the bottom of this table? I would like to sum the vines and Acerage columns. Using Arcmap.
1
vote
2answers
60 views

Error 999999 exporting table view?

ArcGIS 10.1. When I try to export a table view with CopyRows_management, I get an invalid sql error. However, the sql statement by all accounts work fine. When I perform a GetCount_management, the ...
1
vote
2answers
130 views

Arcpy Creating Multi-page Table/PDF with Reportlab/PyPDF2

I am writing a scrip to batch automate hundreds of map PDF's. Along with the PDF's I generate a unique Table/reportlist for each map from the 'receptors' that fall within each boundary of the map. The ...
6
votes
3answers
132 views

QGIS Table Manager plugin does not appear

I installed Table Manager Plugin, but cannot find it under the plugin menu. Anybody know where to find it?
3
votes
1answer
54 views

Calculating summary statistics and access resulting value in table using ArcPy?

With arcpy, I want to calculate the mean value of a specific field in a shapefile and print the resulting value for the user. I use the Summary Statistics tool and it works, but the resulting value ...
-2
votes
1answer
52 views

How to the display the information in an OpenLayers popup as a two column table?

My pop-up info in OpenLayers is showing its information horizontally (see screenshot below). I would like it to display vertically instead. Is it possible?
6
votes
3answers
308 views

Read a table from an ESRI file geodatabase (.gdb) using R

I am trying to read a table directly from an ESRI file geodatabase into R. An example data file can be downloaded here. The database contains a point feature class (Zone9_2014_01_Broadcast) and two ...
1
vote
3answers
32 views

Dissolving while retaining field informations in the same entry instead of multiple entries

I have 1520 covenants. Many covenants have more than 1 VM symbols attached to it, currently showing as rows. EG. Covenant #97 has 4 VM Symbols, with the VM Symbols 1, 67, 117 and 171. How do I change ...
3
votes
3answers
127 views

How to create a line with all attribute information of the original GPX points?

I am trying to make a shapefile line contain all the data that the GPX file has. So i load the gpx file into Qgis, (prompts me for tracks, waypoints, trackpoints, routes, etc) When i choose "Tracks"...
2
votes
2answers
97 views

Getting the number of records from a table in ArcGIS 10.3

How do you output the number of records in a table in ModelBuilder? I can open the table and see how many records are there but I want to tabulate the number of records available from a number of ...
1
vote
0answers
21 views

“undo” pivot table with ArcGIS ModelBuilder?

I have a table in a geodatabase with an ID and a text field for each day of a week. The text fields contains 0 or 1 for monday, 0 or 2 for tuesday, and so on. One ID can have multiple day entries, so ...
1
vote
1answer
48 views

is there a way to save a temporary file as a permanent raster layer

I am trying to build a raster table for a temporary layer i created from an image difference on ArcGIS image analysis. Is there a way to save the temporary layer from this image analysis as a ...
2
votes
0answers
50 views

Extracting Mean from Raster and Writing to Table in ArcPy?

I am simply trying to extract the mean of each raster within a geodatabase and write the value to a table. I have done this successfully with another set of rasters, but now I keep getting the ...
6
votes
2answers
449 views

How to join a table to a shapefile with non-matching IDs and names (similar strings)?

I'm having an annoying problem that I'm trying to find an automated solution for. The shorthand version is that I have a shapefile and a table of created data for regions within countries. The created ...
2
votes
1answer
53 views

Visualize tables into QGIS maps? [closed]

I'm looking for a way to show attributes as number in little tables via QGIS. For example I want to show various facilities a city has with a small table. You can see the example of what I mean in ...
0
votes
0answers
32 views

How to iterate a raster calculator with a change in the input raster and in the values calculated? Than, how to put the results in a table?

What I do without iteration is the following: Change radiance to reflectance for band 3 with raster calculator Samething as #1 on band 4 (the values in the formula are different from #1) Calculate ...
1
vote
1answer
68 views

Connect multiple 2 points with a line in ArcGIS?

I have a table in which each row has two columns representing the objectID of two different point features in the Map. There are thousands of such rows. How do I connect the each of these two points ...
0
votes
0answers
15 views

Using ArcPy to insert Excel table into ArcMap Layout View? [duplicate]

I have been using python to batch automate maps and I have been using a manually drawn table on the layout view and have been using the ArcPy text elements to replace text with the values for each map....
1
vote
1answer
94 views

Nearest Neighbour function

I'm trying to create a function which calculates the nearest neighbors under a certain length in a table s_1 an stores them in an output table. This is what I've got so far: CREATE OR REPLACE ...
1
vote
2answers
118 views

Error adding row - sequence size must match size of row

I have this table with one row timestamp_pretty 3.1.2014 9:13 timestamp 1,38874E+12 msgid 3 targetType A mmsi 205533000 lat 53.4346 long ...
1
vote
1answer
57 views

Assigning a value to a polygon cell

In ArcMap 10.3 I have a raster file with a polygon grid overlayed on it: If the pixels in the colored raster have values such as blue = 5, yellow = 1, green = 3 etc, is there a way to output a table ...
6
votes
2answers
560 views

How can I turn a python list into a table?

I am trying to create a table of coded values so each textual description has a numerical attribute. The order of numbers is not important - they just need to be unique. What I have so far is a ...
1
vote
1answer
88 views

How to make a SQL query that would sum multiple records in ArcGIS?

I've got a large file geodatabase that contains a polyline feature class of water-pipes. The feature class have many fields, but the ones that I'm interested in is that of the water-pipe's Length and ...
1
vote
0answers
37 views

Creating look up tables in QGIS that last more than one session?

It seems that when I create a Look up Table or Value Map for a shapefile or a PostgreSQL table in QGIS it saves it for one session, then when I open it again it had disappears. Can someone ...
0
votes
2answers
96 views

Complete matrix from Generate Near Table

I am trying to make a matrix with all the distances from 4000 objects to 1000 other objects. I used the Generate Near Table and deselected "find closest option only". The output is table with 4 ...