A set of data elements arranged in rows and columns.

learn more… | top users | synonyms

1
vote
1answer
176 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
426 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
2answers
283 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
304 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 ...
1
vote
1answer
670 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
341 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
1answer
17 views

Python for select by attribute then remove from current selection

I have a table called"July_join". Within this table I have many attributes or columns. I want first to select every thing under "grade" column that has values of 90, then remove from this selection ...
1
vote
1answer
29 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
38 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
11 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
75 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
45 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
3answers
45 views

Listing Attribute Table in order of Selected objects

Currently when I open my attribute table, I get the order or points by which they are added and I would like to get them in order in which I selected them. For example, I select points (in order): 6, ...
1
vote
0answers
77 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
21 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
31 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
39 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
50 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
31 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
105 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
104 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
32 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
101 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
68 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 = ...
1
vote
1answer
30 views

Is it possible to move a visualization to another table?

Is it possible to move a visualization to another table? e.g. when merging two tables, it creates a 3rd. OR to completely replace a table and maintain the viz?? I don't want to lose the original ...
1
vote
1answer
300 views

Split table column and use to update another table

I have a table (T1) which I need to populate (using python for ArcGIS) the fields Val1, Val2 and Val3 ID Val1 Val2 Val3 0 1 2 with data from another table (T2): ID Data 0 V1 1 V1 2 V1 0 V2 ...
1
vote
0answers
153 views

Display Table of contents of the map in ArcMap in the online published Map/Web map application

The following is the sample layer information of the map in ArcMap 10.1: How can I have the same Table of contents in the published map online or in web map application, so that user can ...
1
vote
0answers
47 views

Create dynamic table in layout view (Arcmap) [duplicate]

I want to add an attribute table to my layout view in Arcmap 10.1. I only want some columns and I have made a few other customizations. However, some attributes might change along the way and I don't ...
1
vote
0answers
316 views

Problems running zonal statistics - not all zones represented

I have been working on a Python script to automate the steps illustrated by whuber here:Create points around the edge of viewshed results I am trying to create a horizon graph illustrating the ...
1
vote
0answers
243 views

ArcGIS opposite to pivot table

fellow GIS-ers :)! I've been trying to find a tool to do the opposite to what the "pivot table" tool does but I dont thin there is any tools for that. I have a raster data set derived from Landsat ...
0
votes
2answers
78 views

Editing tables in ArcGIS for Desktop with Python Parser of Field Calculator?

so I'm trying to edit a table so that the name column will not contain spaces. I just don't know how to write the Python script that should go with it. This is what I have for the Python script ...
0
votes
2answers
127 views

Change column order in postgis 2.0

Is it possible to change the column order of a table in postgresql/postgis 2.0? If so, how is it done?
0
votes
2answers
108 views

Python column checker-comparing 2 fields

One problem I am having is the following: I want to create an automatic program to see how well the automozation has been with comparing the results of 2 columns to each other in the same column. In ...
0
votes
1answer
68 views

How to properly write a txt to use as table in ArcGIS 10.1

I just wrote a txt. to use it as a table in ArcGIS, but for some reason when I open it, ArcGIS shows it in a completely wrong way. What am I doing wrong? Here is the original content: ...
0
votes
2answers
59 views

Diverse values to one field for soil analysis

I have soil analysis data in an Excel table. For one analysis point there are values at three depths. Besides the Excel file I also have a shapefile with the points to which I want to add the soil ...
0
votes
3answers
234 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 ...
0
votes
3answers
372 views

Using ArcPy and Python to export Table View as PDF format?

I am using ArcPy to select from a layer and display the result on map as a table view. Now I want to export the table view as a PDF format. Anybody know about it? If it is beyond ArcPy to export ...
0
votes
2answers
126 views

url completion in cartoDB info windows

By far the most of my data is taken up a column of long strings pointing to the source of the data for each point. I need to keep that. However, it would be neat if CartoDB could use this information ...
0
votes
1answer
366 views

Help with Python Update Cursor syntax

I'm having trouble running a loop to update the values in a particular field in attribute table by reading from a csv file. Any input is greatly appreciated. The following is the sample code: import ...
0
votes
1answer
54 views

Write CSV table for join self in ArcGIS for Desktop?

I wonder how I would write a table for a join which I want to perform. Right now I wrote a .txt File, tab-seperated. The headerline only contains letters. Here is the problematic table: ...
0
votes
1answer
52 views

Create Table from Selection

This is a continuation of a problem that was solved earlier this week. The code below performs a select by location and was originally intended to export all feature classes from the SDE database to ...
0
votes
1answer
34 views

Is the PostGIS Raster primary key required to be named rid?

In all examples from the PostGIS Raster reference the primary key in tables with a raster column is named rid. I wonder if that naming is expected by any functionality of PostGIS itself or any client ...
0
votes
1answer
408 views

Copy/ Paste from spatial attribute tables into non-spatial tables in Arcmap

Imagine I have a shapefile which has its own attribute table and I have a non-spatial stand alone table too. I am going to copy the rows from the shapefile attribute table into the stand alone table ...
0
votes
3answers
90 views

Using Sort_Management for multiple tables

I like to convert tables (100+) living in access database to a geodatabase tables, sorting them and deleting unnecessary fields in each table at the same time. I figured I use the Sort_management ...
0
votes
1answer
54 views

Create FeatureDataSet in geodatabase with Arcpy from a table

I create an empty file geodatabase (gdb), and I would like to import in this gdb several feature dataset, at least 120 different dataset. I would like to import those dataset from a table like an ...
0
votes
1answer
42 views

Copy table to attribute table

I have some tables with columns that I need to join/copy to another table, in case an attribute table. I was using join but I realized that it would be a better solution to add new fields to my ...
0
votes
1answer
41 views

Arcpy to append results of pivot table

Good Day All, So 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 ...
0
votes
1answer
121 views

CartoDB table join error: Column reference is ambiguous

I've got a CartoDB question that seems dumb b/c the layer is correctly rendering. Anyway, I have two layers, named sampling_points sample_point I'm trying to inner join the sample_point data to ...
0
votes
1answer
95 views

How do I merge two columns into one column steps? [duplicate]

When I save the table after I set up the classifcation and then ArcGIS save it as a INFO file and then you have two columns that you want to merge into one. Is there a better way to do that ? What I ...
0
votes
1answer
88 views

US Census block group data - field names for feature classes

I may be missing something here, but it seems like getting usable US Census data into a shapefile or feature class is much harder than it used to be. Downloading the Tiger block group shapefiles is no ...