A set of data elements arranged in rows and columns.

learn more… | top users | synonyms

0
votes
0answers
3 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
35 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
10 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
85 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
107 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
59 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
37 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
72 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
35 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
47 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
37 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
53 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
64 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
114 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
35 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
36 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?
4
votes
3answers
135 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
28 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 ...
3
votes
3answers
88 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 ...
2
votes
2answers
78 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
37 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
38 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
301 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
52 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
29 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
50 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 ...
1
vote
1answer
78 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
106 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
47 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
481 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
74 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
83 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 ...
3
votes
1answer
46 views

Feature Class relate with table

I use ArcGIS 10.1 for Desktop. I have a polygon Feature Class with municipalities. In a non-geographic table, I have these same municipalities, with an additional contract information. The ...
0
votes
1answer
453 views

CartoDB json to HTML Table using Javascript or Jquery

I am trying to display the dataset inside the cartoDB as HTML table. When i give request to the postgre database by SQL API, it is returning as the format (json) below in the snapshot. I want the ...
0
votes
0answers
24 views

Viewing my local cartodb dataset as table in browser?

I am trying to visualize dataset in my local cartodb as a table in my browser, but when i tried with the following code am getting the below error var table = document.getElementById('mytable'); var ...
0
votes
1answer
58 views

Text wrapping on tables in ArcMap?

I currently have a table (not a text box) that I'd like to have overlaid on the map in layout view of ArcMap 10.3. It, unfortunately, has a long title in the column. So, when I go to put the table on ...
2
votes
1answer
43 views

QGIS table does not dynamically update after applying a filter

Using QGIS 2.10.1, if I open a table and then apply a filter using Layer Properties > General > Provider Feature Filter, the table view does not update. In other words, the initial list of records ...
0
votes
1answer
24 views

Arcmap Working out a ratio (and totaling data) using table data - ArcGIS for Desktop

I am trying to work out a ratio between two columns (each with many rows) of data. I have one column, named 'amounts' with varying numbers in them, each one is a reference for a area (A polygon, so ...
1
vote
2answers
56 views

Getting number of objects in attribute table using PyQGIS?

I have a layer and I would like to access the number of rows the attribute table has from my code. Is there a way to do that without doing it like this: Index = 0 for Feat in Layer.getFeatures(): ...
0
votes
0answers
67 views

ArcMap Complex Labeling with Python

This is going to be very general because I've been finding it hard to find a sufficient starting point (as far as code goes) for my problem... So basically, this is it: I want to Label polygon ...
1
vote
0answers
20 views

Mapping negative percentage values from *.xls table in QGIS?

Trying to map some negative percentage values in QGIS. Working with a .xls table and importing this as a vector file to QGIS, then joining the file with a shapefile. Have converted negative percent ...
3
votes
2answers
91 views

How to get all (or selected) values from a single field in a table?

I'm looking for a way to get all of the values from a single field in an ArcGIS table. Reasons for doing this might include pasting the values into a text document or SQL where clause. Since ArcGIS ...
0
votes
1answer
49 views

Python Scripting Displaying Incorrect Names after Join Field

My problem is that the code is adding numbers to the field names, and this is incorrect. Problem: Field should be names VALUE_122, but after running JoinField code, it becomes VALUES_122_123. The ...
1
vote
0answers
27 views

listing existing joins in table of contents feature

I am looking for a way to use python in ArcGIS desktop to check and print out the joins that exist between tables and feature classes in my map rather than right-clicking, going to joins and relates ...
1
vote
0answers
53 views

Populate empty attribute table from constantly growing CSV in QGIS

I have a Python script running that will generate a line feature from a point depending on a degree of rotation around that point. I have a non-spatial CSV setup to get fed this rotation data from ...