A set of data elements arranged in rows and columns.

learn more… | top users | synonyms

1
vote
1answer
561 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
379 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
164 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
48 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
373 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
304 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
94 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
220 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
69 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
3answers
381 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
2answers
67 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
1answer
73 views

converting a python list to arcmap table [closed]

I have values stored in a list that need processing in the costDistance tool in ArcMap 10.2 (desktop). For this they need to be converted into a table or file readable by arcmap's tools. Anyone with ...
0
votes
3answers
564 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
166 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
470 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
39 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 ...
0
votes
1answer
107 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
66 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
60 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
43 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
562 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
1answer
901 views

How can I change the precision in the attribute table? [duplicate]

I'm working with QGIS, v. 2.0.1. I opened a csv-table (from an Excel-file) and now the precision is very high but I don't need this. At the moment the values are for example 15.00000000000000, how ...
0
votes
3answers
124 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
179 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
1answer
44 views

Debugging ERROR 000732 Cannot create table from feature class in file geodatabase?

I am unable to create table from feature class in file geodatabase. below is the screen of shot of the tool with error message ERROR 000732
0
votes
1answer
37 views

FME - Exploding Series of Attributes to Features for Each Combination

Given a unique identifier attribute (TYPE below), there needs to be the combination for each comparison between the identifier and (n) value attributes to be written as a new feature. See the example ...
0
votes
1answer
53 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
64 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 ...
0
votes
1answer
345 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
245 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
180 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 ...
0
votes
1answer
934 views

Adding and Editing Excel table to the data frame

I have few excel tables of almost 5-6 columns and i need to paste them at different locations in the same map. The values in the excel table gets revised every quarter and i need to edit the table. ...
0
votes
1answer
183 views

Values in attribute table not showing up

I have values in an attribute table I want to label my layer with. But when I label it, a totally different set of values show up. In the attribute table, my values are between 0 and 200. But the ...
0
votes
1answer
186 views

Mapinfo appending TAB file error - multiple points appearing in the same location

I have two TAB files with identical table structures and when appending one to the other all appended points get placed in one location, however when I append them the other way round it works fine. ...
0
votes
1answer
1k views

How to insert values from one table into another?

I am trying to write a script that iterates through each row of a table, calculates for this row something. The result of this calculation is finally stored in another table (with just one row). Now I ...
0
votes
0answers
20 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 ...
0
votes
0answers
10 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
2answers
67 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 ...
0
votes
0answers
16 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
0answers
44 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 ...
0
votes
1answer
42 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 ...
0
votes
0answers
16 views

Change dbase table alias

How can I change the alias of a dbase table without completley renaming the file? I've tried right clicking the the file, opening properties, and changing the alias, but it will not allow me to edit ...
0
votes
1answer
30 views

Mapping Ecclesiastical Parish Data

I am looking for a way to plot data relating to the number of people in a given location - the location being an ecclesiastical parish. So I need software that will allow me to import a map of ...
0
votes
0answers
23 views

Fail in searches on the joined table data

When a table is joined to a standalone table, the searches on the joined table data return a fail. Is there another way to solve this inconvenient without save the layer with joined table under a new ...
0
votes
1answer
21 views

Adding data column by column in postgreSQL database

I organize my data in different txt files and dat. files, mostly in each file there is one specific column of data. Now I want to import and combine 4 of them to create a table. Say I have one file ...
0
votes
0answers
12 views

Cannot Load Object - Region object type is not supported in this table. Operation canceled

I have linked an Access Database with MapInfo and created a mappable tab. However I am unable to populate the table with any regions/polygons/poly lines etc. It says "Cannot Load Object - Region ...
0
votes
0answers
89 views

import table from sql database results in empty ouput - ArcMap

I am trying to import a table to a .gdb from a SQL Server database (not spatial). I can see the table's rows and data in ArcCatalog preview. When I import, there are no errors but I get a message: ...
0
votes
0answers
39 views

Small individual tables/crosstabs for points from Access to plot on maps

I currently have an Access database (accdb format) that is currently linked in GIS (ArcGIS 10.1) through an OLE DB connection. I have a groundwater analytical table with 36,000+ records that contains ...
0
votes
1answer
229 views

Iterate through all fields in attribute table and multiply by field

I have a table with a whole bunch of census variables (race, age, education, etc). I want to multiply all of these fields by a factor that I calculated. For example: Field1 has values of 10,20,30,40 ...
0
votes
2answers
137 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 ...