A set of data elements arranged in rows and columns.

learn more… | top users | synonyms

0
votes
1answer
537 views

How to delete a table field in ArcGIS?

I am trying to delete a table field: From ArcMap table view, I right click on the field heading and select Delete field. Unfortunately, I obtain the following message: Failed to delete the selected ...
1
vote
2answers
1k views

QGIS, Table Manager cannot rename column title

My current attribute table has a column whose title exceeds the ten letters maximum. I installed Table Manager, hoping I could rename the certain field to further use it (in order to add some ...
2
votes
1answer
82 views

How do I make a GP Results table sortable? Or add Dojo Grid

Im aware a sort() function exists, just not sure where it should be placed in my code. I have a function that draws routes on the map and i'm getting my results that are in my table from those routes. ...
1
vote
0answers
41 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 ...
0
votes
1answer
86 views

Geoexplorer displays the layers I import, but not the table behind them

If I import layers into GeoSrver, they display in GeoExplorer, and I can use the identify tool to find more info about areas of the layer I select. However the table from which this data comes from ...
0
votes
1answer
66 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
69 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
2answers
838 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 ...
0
votes
1answer
468 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 ...
5
votes
4answers
542 views

How do I fill in serial letters (AA, AB,AC…,BA,BB,BC…ZZ) to a shape?

(I am using ArcGIS software, ArcMap...) MY PROBLEM I have a shape file containing points. The shape file contains 3 columns named FID, Shape* and Label. In the column I want to fill in AA, AB, ...
1
vote
0answers
142 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 ...
2
votes
3answers
413 views

What is a seamless table?

A client has asked me to provide a dataset in seamless table format. Could anybody describe to me what a seamless table is? I understand that it is a format used by mapinfo, but can I create a ...
1
vote
1answer
137 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
2answers
224 views

How to Append to rather than overwrite single table using ArcPy?

The code thus far works to create multiple output files, but I'd like to set it up so that the data is all exported onto a single table across multiple rows. The issue is I believe with the part in ...
1
vote
0answers
130 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 ...
1
vote
1answer
230 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 ...
4
votes
2answers
364 views

Does ArcPy leak memory when importing CSV files?

I'm trying to import a great number of csv files of about 250MB each. I wrote a python script for that as follows: import gc import glob tables = ...
0
votes
0answers
35 views

Generate Adjacency Table from a Region Grouped Raster Layer

I’ve searched high and low to no avail looking for any existing tools, scripts, ArcGIS geoprocessing steps that will output an adjacency table something like this: VALUE,ADJ_VALUE,LENGTH_EDGE (m) ...
1
vote
1answer
129 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 ...
2
votes
1answer
111 views

How to write table blob field to file using ArcObjects?

I have a table with blob field and some others as well. I am trying to read blob field and save it to file using IBlobStream, and the thing compiles. The problem comes up in run-time, when calling ...
3
votes
1answer
540 views

How to retain Field Name / Alias on Export of Table?

Is there a way I can modify the Field Name or to make him keep the Alias when a table is exported? Or is there a way to keep the Alias instead of the Field Name, when exporting for example to .dbf ? ...
2
votes
2answers
98 views

Create multiple tables from distinct attribute category values using Model Builder

I've got a shapefile I would like to extract distinct values from an attribute field and have the output as tables based on those values. The shapefile is made of polygons representing parcels and ...
0
votes
0answers
141 views

Help exporting CSVs using MapBasic

I'm a beginner to MapBasic and I'm currently working on a tool, I want to export a table as a .csv either using Run Command or Export. I want to export it to a specific directory, for example ...
1
vote
1answer
2k views

Make POINT from longitude/latitude coordinates from existing table in PostGIS

I would like to make a POINT using the longitude and latitude columns of an existing table. Here's a link to the documentation of ST_MakePoint. Here's my table: CREATE TABLE sysinst.bio ( oid ...
0
votes
1answer
190 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
3answers
59 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 ...
1
vote
1answer
180 views

Using field mappings to remove fields from a merged table

EDIT: Soreted, thanks :-) I'm trying to combine a (large) number of tables into a merged table, keeping only certain fields. I've tried the below, but it still gives all the fields. Any ideas? ...
0
votes
1answer
206 views

How to add a table into the TOC in a Python script?

I recently experienced some troubles in adding a table from a specific folder to the TOC using a Python script. Any idea on how can I solve? Thanks, Annalisa
6
votes
1answer
455 views

Create multiple shapefiles from one table

I've imported a table into ArcGIS which I'd like to split into multiple shapefiles. The splits would occur between groups of records separated by any of 3 columns. In other words, col1, col2, and col3 ...
2
votes
2answers
1k views

Creating non-spatial Many to One Joins/Relationships between tables

I may have missed a trick here but I can't seem to find a solution. I have a table of ~1.6 million postcodes, also containing co-ordinates, and a separate file detailing ~6000 a population with ...
3
votes
2answers
147 views

Create Table (Data Management), Unable to Save to Feature Dataset

I'm trying to create a table in a feature dataset and get the error: Parameters are not valid. The code works when I write only to the gdb. Am I not allowed to write to a feature dataset or am I doing ...
2
votes
1answer
73 views

How to add a ITable (Table object) to the current map (or document)?

I created an in-memory results ITable and I need to add it to the current ArcMap document/map to see the generated data. How can I do it?
2
votes
1answer
366 views

How to Group By with Summarize on alphanumeric field in ArcGIS?

Is it possible to create from Summarize option, a new table with the COUNT of a string field and the code of municipalities, in my case, like that: +-------------------+--------------+ | ...
2
votes
0answers
91 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 ...
11
votes
2answers
226 views

How to sort by multiple fields at the same time?

Is it possible to sort multiple fields at the same time in QGIS? For example, I'd like to sort a table by state name, and then within each state, sort by county name. This would be the same as the ...
5
votes
3answers
2k views

Table to table script using Excel sheets (not workbooks) arcpy

So what I'm trying to do is to create feature classes from the sheets in an Excel table. I can get it to work if I save each excel sheet as its own workbook, however this isn't really what I want. I ...
1
vote
1answer
335 views

PostGIS Create Table with Geometry

I have written a query that will create a table and perform a GROUP BY from an existing spatial table, but the table does have the geometry. I am wondering where, and what, in this query I put to ...
8
votes
3answers
3k views

ArcGIS fails to import all records from huge CSV file to file geodatabase table despite being within FGDB table size limits

I'm using ArcGIS 10.0 on Windows 7 64-bit with 4GB of RAM. I have some very large tables in CSV format to import to ArcGIS, they all have about 30 fields, upwards of 5 million records per table (a ...
3
votes
2answers
455 views

How to extract cell values from a raster file with Idrisi Taiga?

I need to convert raster cells into points. I use Idrisi and I need to generate a table containing xy (coordinates) and z (cell value).
3
votes
1answer
204 views

Adding table to the MapServer so the layers and tables can be associated

I'd like to add tables to my MapServer. I want it to include both feature layers and tables which enables me to associate the layers with the relevant tables and retrieving the necessary fields of the ...