A set of data elements arranged in rows and columns.

learn more… | top users | synonyms

1
vote
1answer
715 views

How to add Table View to Data Frame using ArcPy in ArcMap 10.0?

How does one add a table to the current map in ArcMap 10.0? 10.1 has the function arcpy.mapping.AddTableView, but this function does not exist in earlier versions. Must the table be made into a layer ...
2
votes
1answer
2k views

How to reclass a raster with reclassify grid values in QGIS?

I'm new in QGIS and I'm trying to reclass a raster with reclassify grid values. I want to reclassify by table, however fixed table has only 3 rows and I need some more, but button to add is not ...
1
vote
1answer
43 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 ...
0
votes
0answers
4 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
86 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 ...
0
votes
2answers
176 views

Deleting rows on dbf table with python for ModelBuilder?

Being not very familiar with python, and after carrying out unfruitful long researches on internet, I submit to you my problem, hoping favorable reply. I have a DBF table with geochemical data and I ...
1
vote
2answers
41 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 ...
6
votes
3answers
206 views

Equivalent of excel Alt+Enter in attribute table?

On Excel, you can do "carriage return", that is, jump a line, using Alt+Enter within a cell. When I copy a cell from excel in my attribute table, this format is respected. I can find no way to write ...
0
votes
0answers
13 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
86 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
111 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
73 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 ...
5
votes
1answer
76 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 ...
2
votes
1answer
40 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 ...
0
votes
2answers
40 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.
0
votes
1answer
41 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
49 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?
1
vote
2answers
56 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 ...
6
votes
3answers
117 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
42 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 ...
4
votes
3answers
173 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 ...
-2
votes
1answer
41 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?
1
vote
3answers
30 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 ...
2
votes
1answer
2k views

Add new rows to a shapefile

I'm using QGIS. When I enable editing of a shapefile's table attributes and select, 'open attribute table,' is it possible to add new rows to the shapefile's table attributes? The problem I'm trying ...
1
vote
1answer
125 views

Georeference disabled in CartoDB synced dataset

If I upload a dataset with synced option enable then I haven't the option to do the geocoding. Is that normal? How I can geocode the addresses? If manually I can't do the geocoding how I can do ...
3
votes
3answers
101 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
88 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
2answers
3k views

how to create table and layer in c#

I have used Make XY Event Layer to Creates a new point feature layer based on x- and y-coordinates using python and it worked for me. Now as a need of my project i want to apply the same in c# using ...
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
42 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 ...
0
votes
3answers
447 views

UpdateCursor 'is not defined' Python

I have several files (shapefiles). Table 1 has only one row with several fields whereas Table 2 has several rows. What I want is to take a value from Table 1 and populate all rows in Table 2. I used a ...
6
votes
2answers
350 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
412 views

Export “Zonal Statistics As Table” output in Modelbuilder

I have an extremely simple model that takes as input a shapefile for zones along with a value raster. All the model does is produce a table of my desired zonal statistic for each zone (the mean). ...
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
56 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
83 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 ...
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 ...
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 ...
6
votes
1answer
2k views

Adding Table to Layout View using ArcPy?

I am using ArcGIS 10.1 and I have a non-spatial table and some layers in a Data Frame. When I switch to Layout View I want to be able to show the map in a data frame element and the table in another ...
0
votes
1answer
75 views

Arcpy to append results of pivot table

I have a script that does some processing but the main part are two things run a multiple ring buffer using arcpy.MultipleRingBuffer_analysis and four rings do some zonal statistics using ...
2
votes
0answers
124 views

Connecting Access Table to ArcGIS (Replace Function!)

I have an Access Query where the Field names contain symbols like "-", ":" and spaces. When I was connecting my database to ArcCatalogue that specific Query-table was not visible. Then I used Replace ...
1
vote
2answers
112 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
250 views

Making reclassified raster layers automatically display break values in their attribute tables?

I am using ArcGIS 10.2. I have many raster layers which I need to reclassify (using the quantile method), I Also need to know the break values of these reclassifications. I know that the break ...
1
vote
1answer
53 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 ...
1
vote
1answer
83 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 ...
6
votes
2answers
501 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 ...