Questions tagged [table]

A set of data elements arranged in rows and columns.

Filter by
Sorted by
Tagged with
1
vote
2answers
79 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
67 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
1answer
82 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
438 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 ...
2
votes
2answers
605 views

Remove tables - not just layers - from the map document [duplicate]

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
133 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
47 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 ...
5
votes
2answers
4k views

Working around 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
174 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 ...
6
votes
2answers
1k 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 ...
1
vote
1answer
394 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
22 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 ...
2
votes
2answers
555 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
340 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
221 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
4k 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 ...
7
votes
3answers
3k 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
1k 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 ...
-3
votes
2answers
321 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?
19
votes
5answers
12k 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
501 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 ...
4
votes
3answers
1k 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
771 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
40 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
665 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
1answer
216 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 ...
8
votes
2answers
5k 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
191 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 ...
1
vote
1answer
381 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 ...
1
vote
1answer
888 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
507 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
498 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
5k 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
670 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
60 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 ...
1
vote
2answers
220 views

Complete matrix from Generate Near Table [duplicate]

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
69 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
1k 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 ...
1
vote
1answer
503 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
132 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 ...
3
votes
2answers
2k 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(): ...
1
vote
0answers
41 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 ...
4
votes
2answers
431 views

Getting all (or selected) values from single field in table using ArcPy?

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
79 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
34 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
128 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 ...
4
votes
1answer
271 views

edits to attribute table in qgis do not show up in arcgis

I have received a point file that was made in QGIS. if a row is deleted in QGIS it appears to be deleted, in QGIS. If I import that shp file into arcgis the attribute still shows the rows that were ...
1
vote
2answers
82 views

Variable Expression In ArcGIS

I am creating many models doing many tasks. Basically, the first model will join 2 tables and the steps are as follow: make table view for each table, then add join for, then it will copy the rows for ...
6
votes
2answers
2k views

Way to find minimum value from a group of values - QGIS?

I'm wondering if there is a way to find the minimum value of a group within QGIS? Basically I need to find the minimum distance of each unique value in a table of about 5000 records. I can do the ...
3
votes
1answer
4k views

Editing Related Tables in ArcGIS Online?

Is it possible to edit a related table via the browser in ArcGIS Online? The last update I heard in February was only available via ArcGIS Collector. I was wondering if ArcGIS Online supports ...