Tagged Questions

The tag has no wiki summary.

learn more… | top users | synonyms

11
votes
2answers
183 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 ...
6
votes
1answer
175 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 ...
5
votes
3answers
606 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 ...
4
votes
2answers
87 views

Arcpy memory leak

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 = ...
4
votes
4answers
127 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, ...
3
votes
1answer
93 views

Field Name & Alias

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 ? ...
3
votes
2answers
75 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 ...
3
votes
1answer
178 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 ...
3
votes
2answers
322 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).
2
votes
1answer
51 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
88 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
3answers
74 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 ...
2
votes
1answer
54 views

Write table blob field to file

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 ...
2
votes
2answers
50 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 ...
2
votes
0answers
58 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
1answer
172 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 ...
1
vote
1answer
43 views

Append to rather than overwrite to a single table in 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
1answer
31 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
36 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
82 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? ...
1
vote
0answers
30 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
1answer
49 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
2answers
157 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 ...
0
votes
1answer
111 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
34 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
52 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
0
votes
1answer
44 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
1answer
214 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
26 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
0answers
53 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
0answers
26 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) ...
0
votes
0answers
56 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 ...