A set of data elements arranged in rows and columns.

learn more… | top users | synonyms

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 ...
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 ...
6
votes
1answer
456 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
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, ...
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 ...
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 = ...
4
votes
1answer
71 views

end execution of script and send email if schema has changed

I would like to append the data from one feature class to another after confirming that the schemas match in both feature classes. I can append the data from one FC to another by using this simple ...
4
votes
0answers
219 views

How to create a customizabe table in QGIS Print Composer?

I would like to add a custom table to a map layout created in QGIS. I would like a fair bit of control over the look of the table (borders, background colours of the cells, etc.), and it appears that ...
3
votes
1answer
543 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 ? ...
3
votes
1answer
155 views

Shapefile to table within python

I was just curious as to whats the best way within a python script to get the output a dbf file/ table while the input is a shapefile. (if possible which i'm assuming it is) Is there a way of ...
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 ...
3
votes
1answer
83 views

How to add a table to Layout View using Arcpy?

I am using ArcGIS 10.1 and I have a non-spatial table and some layers in a Data Frame. When I switch to Layout View I want to be able to show the map in a data frame element and the table in another ...
3
votes
1answer
389 views

Creating a spatial “Many to one” join

I'm trying to create what I call a "many to one" join. I don't know if that would be the correct term or not. I have a table that has unique account numbers for mobile homes (i.e. - M1007970) per ...
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 ...
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).
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
82 views

Invalid SQL Error when using InsertCursor on table created using CreateTable

I am trying to write a list of items to a new table in Arc. When I attempt to add a new row to an Arc table, I get the following error: Runtime error Traceback (most recent call last): File ...
2
votes
3answers
414 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
369 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
1answer
42 views

Table analog of MakeQueryLayer

As of 10.1, arcpy provides the rather handy MakeQueryLayer function. This allows us to use arcpy to create query layers programmatically instead of having to go through MXDs (as was the case in 10.0). ...
2
votes
2answers
108 views

How to Rank Field in ArcGIS 10.1?

I have a table of crimes by precinct. There is a field with the precinct number (I.E. 1, 2, 3, 4...) I also have a field each for Burglaries, Assault, Arsons with a count of how many in each precinct. ...
2
votes
2answers
44 views

How to flag parcels as being within stop type dependent distance of transit stops?

first question here! I have a parcel layer and a transit stop layer. The transit stop layer has different bus stops, light rail stops, etc. I want to add to my parcel layer attribute table fields ...
2
votes
1answer
112 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 ...
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 ...
2
votes
0answers
20 views

Are there are shortcuts for exporting polygon vertex location as a table [duplicate]

Someone came to ask me how he can export the X and Y locations of vertices from his polygon shapefile to excel. So I told him to convert it to points, add columns, calculate geometry, and then export ...
2
votes
0answers
45 views

Why is ArcMap deleting data from a field when I add a new one?

My copy of ArcMap 10 is acting pretty strangely. I have a shapefile and all I've done is added a new field as a FLOAT and for some reason all data in another one of my fields is being deleted! Does ...
2
votes
0answers
105 views

Loading postgresql tables in Arcgis for Desktop 10.1

I have postgresql version 9.0.5 installed and configured. Also in my ArcGIS for Desktop 10.1 in "Add Database connection" I have my postgresql connected and I can see all the tables in it (figure1). ...
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. ...
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 ...
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 ...
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 ...
1
vote
3answers
79 views

How to create a geodatabase feature class using a geodatabase table schema with ArcPy?

Is there a way in ArcPy to create an empty polygon geodatabase feature class that will acquire the schema of a geodatabase table? I know that it's possible in ArcCatalog (New -> Feature Class and ...
1
vote
1answer
31 views

ArcGIS “Zoom to layer” scale

I'd like to quickly inspect the features in a feature class by double clicking the row in the table view and looking at the surrounding base layer. This works, but the feature fills the screen, so I ...
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
1answer
16 views

MakeQueryTable_management

When I run this code, it says "An invalid SQL statement was used". Any idea what does it mean? import arcpy from arcpy import env env.workspace ="C:/RG/Projects/CriticalDataNetwork/CDEC.gdb" try: ...
1
vote
2answers
51 views

Counting Characters using Field Calculator - Arcmap

I am trying to use field calculator to populate a column based on the the number of characters in another column. I am using the Python Parser. I am not sure if the .count() function is appropriate in ...
1
vote
1answer
79 views

Join Tables related by a composite primary key in qgis

I have two tables, one has the geometry and other has attributes. The table with geometry has unique number primary key, and 4 columns admin1,admin2,admin3,featureid. Table two is a csv file has the ...
1
vote
2answers
44 views

cartodb runs out of space *after* shrinking the data in the tables?

I try to work in CartoDB with data I import from CSVs (or xlsx, see below). The data is 24.1 MB in ASCII CSV, 10 MB in xlsx. I spent quite some time shrinking my data's size, and I was happy to ...
1
vote
1answer
51 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
50 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
1answer
136 views

keep the same field headers after joining a table to a shape file in QGIS

I noticed that after joining a table to a shape file the headers of each fields in the table used for the join are changed by QGIS and they are attributed to a different name. For instance, i had a ...
1
vote
1answer
202 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
107 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
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
1answer
131 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
10 views

Keep column titles when exporting SQL query in MapInfo

Is there a way to keep column titles when exporting a query in MapInfo as a csv or a new tab. This is my result: And my export looks like this: It's not a major issue, I jus like saving myself ...
1
vote
1answer
39 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
2answers
123 views

Table join with .csv file results in null fields after join

Similar to questions already asked about .dbf files, I'm attempting to join .csv files to a .gdb or shapefile coverage in QGIS. The tables as added to QGIS prior to the join look fine, but after the ...
1
vote
2answers
63 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
59 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 ...