A set of data elements arranged in rows and columns.

learn more… | top users | synonyms

1
vote
1answer
262 views

Why a severe performance difference using deleteSearchedRows

The issue I am having involves two versioned tables. A function deletes 48 rows from Table A and and 48 rows from Table B using deleteSearchedRows. However, the delete from Table A takes roughly 4 ...
1
vote
1answer
204 views

classify a table via field calculator

I have a dataset of several states and a table with many informations about them, they are already joined, what i want to do now is to create 5 classes about the average lifespan. they have to be ...
1
vote
1answer
203 views

QGIS 2.0 Table Join creates unwanted prefix in field names

I used to join shapefiles and CSV files via the "joins" tool in the layer properties just fine in QGIS 1.8 . Now i've updated to QGIS 2.0, and when i do the exact same thing, QGIS puts the name of ...
1
vote
2answers
645 views

Perform “Add Join” on multiple tables ArcMap or R

The operation I want to perform is the Add join in ArcMap 10.0. It works perfectly when done with one file but I need to do it with a few hundreds tables. What I have is ONE shapefile with divisions, ...
1
vote
1answer
358 views

PostgreSQL/GIS table relations in QGIS 1.8.0

I am building a database in PostgreSQL 9.2 with the PostGIS 2.0 extension. The database consists of a schema called Water which contains water related geographic features (as example, boreholes and ...
1
vote
1answer
171 views

Python: Grabbing X,Y coordinate from matching fields

Here is my table. What I am trying to do is write a python script to go over the Zip_Crid values. If there are matching values, I need to grab x1, y1, x2, y2 and put it in a new field. Haven't ...
1
vote
1answer
608 views

Automatically updating a table column with the name of table

Does anyone know a straightforward way in MapBasic to automatically update a table column with the name of the table the column exists in? Going from the MapBasic reference guide it seems the ...
1
vote
1answer
26 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 ...
1
vote
1answer
33 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
34 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
2answers
71 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 ...
1
vote
1answer
93 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 ...
1
vote
1answer
243 views

Opening spatial weights matrix file (SWM) from ArcGIS for Desktop in Excel?

I successfully generate spatial weights matrix file (SWM) to get the nearest neighbors for polygons shapes in ArcMap 10.2.2 but I am confused how to open this file its a compressed file and when I try ...
1
vote
1answer
61 views

How to turn a shapefile into a table?

How do you completely turn a shapefile (created with QGIS, including .shx and the other 4-5 files) into one tabular dataset. I am actually doing this when I import the shapefile into Postgresql ...
1
vote
1answer
263 views

Deleting a standalone table from the TOC— C# ArcObjects

I'm looking to delete a standalone table that has been added to the arcmap document from an access database. I only want to delete it from the TOC, not from the file and I can't seem to get it to ...
1
vote
1answer
184 views

How to change the attribute length of an existing field afterwards

I already have about 100 values in a field in QGIS. I set it to 50 characters because I was thinking that would be enough. But that was wrong. I need more space in the column. But there is no way to ...
1
vote
2answers
241 views

CMV Attributes Table issue

I've created a CMV query widget that I am trying to link up with the Attribute Table widget. The table tab is being created in the bottom pane but that's as far as I'm able to get. I'm unable to get ...
1
vote
1answer
85 views

Attribute Table Missing Information

I'm taking a QGIS MOOC on Canvas, and in one of the labs we're to change layer style using an attribute table. However, the attribute table displays some very strange information on my system. ...
1
vote
1answer
830 views

MapInfo, SQL data from multiple tab files which have the same columns

New to the GIS forum so apologies in advance for any potential etiquette failures... I'm working in MapInfo. I have multiple tables with the same structure. One of my columns is pipe diameter. I ...
1
vote
1answer
147 views

NAD27 to NAD83, saving AFTER transformation?

I need to measure the distance (with the ruler) of points from two different layers. One layer is NAD83 and the other is NAD27. When importing the NAD27 csv file, I specified it was NAD27. Then I ...
1
vote
1answer
75 views

Create a New attribute table in ArcMap?

I am trying to create a new table of attributes for later purposes, in arcGIS but just an empty one, How can i do this? I also have it as an Excel format, but I don't know if there is any way to ...
1
vote
1answer
330 views

Updating a feature class

I am working on ArcGIS 10.2.1. I have a feature class containing more than 4000 records and a table having approximately 1000 records. Both feature class and table have some common fields however, ...
1
vote
1answer
52 views

Attribute table in map composer is limited to 99 rows. How to change it?

I am using Qgis 2.2. I am about to create a cadastral index map, which are showing the parcels in specific gridcells, also there is an attribute table connected controlled by an atlas function. So by ...
1
vote
1answer
54 views

matching up fields in different tables

I am going to attempt to explain my problem, and hopefully someone out there will have some insight/solutions/work arounds. I work for a University, and we have some utility/site people go out with ...
1
vote
1answer
339 views

When I join a table to a shapefile and then export it the titles of the columns are transformed to data1, data2

I'm using QGIS 2.0.1 The table is in an excel format that i import through "add vector" and the shapefile is a polygone I join the attributes by right clicking the polygone-->properties-->join Then ...
1
vote
1answer
657 views

Create a Dynamic Table in your Map Layout - how to use Graphic table element?

Is this Solution (Create a Dynamic Table in your Map Layout using graphic table element) is part of this Extension ESRi production-mapping extension ? how can i use graphic table element ?
1
vote
1answer
961 views

Make Table View with field_info Output

I am using Make Table View to copy data from one table to a table view object and in the process hide and/or rename some fields. When I output the data to a dbf it hides and/or renames the fields ...
1
vote
1answer
528 views

Tables within the Reclassify tool- what is it, where is it?

ArcMap 10.1 here. I have a raster set I'm looking to reclassify. The field I need to re-classify is currently a string of words like "Thing 1" and "Thing 2" and I'm going to set them to be 1 and 2. I ...
1
vote
0answers
18 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
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 ...
1
vote
0answers
18 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 ...
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
48 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 ...
1
vote
1answer
37 views

What is the most efficient way to get the values of a previous row in a table using ArcPy? [duplicate]

I am very new to ArcGis and I would like to get a specific value of the previous row in a table. I found this question here on gis.stackexchange.com and experimented a little bit. However, I found ...
1
vote
0answers
66 views

Surface Volume: output table given all in one column?

The model iterates through a Point Feature Class to calculate different volumes. As an output I get two different styles of tables, both in one and the same iteration. One is the actual correct output ...
1
vote
0answers
18 views

A better way to do Tablular Labels (Chemboxes)

So it's been a couple years since I've looked for a new solution for this, but I recently have a newer project manager who really wants "chemboxes", basically labels/callouts with tabular data. I've ...
1
vote
0answers
83 views

Access 2000 database via ArcCatalog displays decimals as integers?

I import an Access 2000 database through ArcCatalog. When I complete the process and check the attribute table, the values come not as decimals as they are in the database but as integer numbers. Why ...
1
vote
0answers
52 views

netcdf python error

I am basically copying and pasting the code provided on Esri's website and every time I try to run it in ipython, the program crashes and needs to restart the kernels. The code is below, does anyone ...
1
vote
0answers
96 views

Maintaining same number of digits in Excel file when converting to table in ArcGIS for Desktop?

I have two fields containing lat and long values which are precise up to 8 digits. When I use the excel to table tool, Arc removes the last two digits in both fields leaving me with lat and long ...
1
vote
0answers
28 views

Catalog table list into web browser

I'm looking to do some cataloging of both workspaces and table metadata - I want to cycle through a workspace and pick up the table names and associate those with the wrokspace name (I can then track ...
1
vote
1answer
41 views

Compare 2 tables of different lengths

I have a problem and am looking for some help with the following: 2 Layers: Not_Joined and Joined Not_Joined: Old digitized data that has X attribute in it. Joined: Spatially joined layer that has ...
1
vote
0answers
48 views

QGIS 2.4 Join Attributes Table tool does not recognize non spatial data to execute

I'm using the graphical modeler in QGIS 2.4 to automate some processes and certain tools are basicly necessaries to get to the point. The "Join attibrutes table" tool, despite it's basic, can help us ...
1
vote
0answers
84 views

Pivot Table not displaying in ArcGIS?

When I performed my pivot table in MS Excel and then made a chart of it and I am trying to copy and paste it to ArcGIS and it is not displaying at all... Is there a work around to do this ?
1
vote
1answer
38 views

Adding images to raster field in batch

So I've got about 300 records in an attribute table that each need an image to go with them. I've created a raster field on the table, and I've got all the needed images as rasters in the same GDB. ...
1
vote
1answer
256 views

Attribute Table Subtract Value From Previous Value

I have a river shapefile and need to ensure every vertice has a lower elevation that the previous uphill vertice. I have converted the polylineZ to points using ET GeoWizards. This gives me a Z ...
1
vote
1answer
140 views

How to configure GeoExplorer to render as HTML the content of the “Table panel” cells (especially as URL)?

I want to show in GeoExplorer the values of feature attribute set as url link, e.g. link to give users the chance for clicking them. It works inside the feature info window, but in the table panel ...
1
vote
0answers
142 views

How to convert picture to annotation in ArcGIS 10.1?

I have been tasked to display analytical data tables (currently in MS Excel) in an ArcGIS (v 10.1) map document (.mxd) and would also like to convert them to map document annotation, if possible. ...
1
vote
0answers
35 views

Odd characters showing up in symbology view

I am trying to symbolize based on company name but there are weird Greek symbols showing up in my Symbology view of the actual field values. Has anyone ever had this problem? The weird symbols do not ...
1
vote
0answers
125 views

How to Build Query Table from two OLE DB tables using ArcPy?

When I run the following code to create a subset of a table, the error says "An invalid SQL statement was used" [Query]. The error shows in line 39. Is there any idea you can figure this out? import ...
1
vote
0answers
72 views

My fusion table map with search not working

My maps are not working. It shows the search box but not the map: // ]]></script> <script type="text/javascript">// <![CDATA[ var map; var layer_0; function initialize() { map = ...