A set of data elements arranged in rows and columns.

learn more… | top users | synonyms

11
votes
2answers
265 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
4answers
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
661 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
654 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
1answer
119 views

How do I extract partial data from one field to another?

Answer Below I am attempting to extract a date stamp that is contained in one field and insert it into another field. The issue is that the date (in bold below) is not in the same location in each ...
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
432 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
376 views

How to add 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 ...
4
votes
1answer
93 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
376 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
963 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
208 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
181 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
3answers
51 views

How to divide attribute table in map composer between 2 or more pages?

Does anyone know how to divide attribute table between 2 or more pages? In exported PDF it's unfortunately clipped.
3
votes
1answer
100 views

Creating .shp from .dbf in ArcMap?

How do I create a shapefile using the latitude and longitude information in my dBASE table? I am using ArcMap 10.1
3
votes
1answer
87 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?
3
votes
1answer
1k 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
35 views

Merging .dbf Tables in Python w/o merging all fields of same name

I'd like to merge several tables together using Python. They all have the same field names: "TIME", "X", "Y", and "VALUE". I would like the "VALUE" fields to remain separate when merged, so that the ...
3
votes
1answer
121 views

Making Geoprocessing Service results table sortable using ArcGIS API for JavaScript?

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. ...
3
votes
1answer
290 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? ...
3
votes
1answer
23 views

Trimble GPS data is not displaying in ArcMap attribute table

I am currently having difficulty trouble shooting a problem. While using a TRIMBLE GEOXH (GeoExplorer 2008 Series) I have the problem of missing data after exporting it to ArcMap from my GPS receiver. ...
3
votes
1answer
210 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
518 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
3answers
257 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 ...
2
votes
1answer
127 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
584 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
612 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
88 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
221 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
1answer
39 views

How to save MakeNetCDFTableView output?

I was trying to extract the time-series data from the netcdf using grid points (lat/long) by MakeNetCDFTableView. I have more than 100 grid points and I want to extract the data from the netcdf file. ...
2
votes
2answers
2k 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
2answers
45 views

Unable to merge CSV and CSVT with shapefile using QGIS due to “text” fields?

I know the question is all over this site, unfortunately I cannot find a solution. I have this CSV file and this CSVT file that I want to merge with this shapefile. I've tried to format the .csv using ...
2
votes
1answer
64 views

MapBasic sentence to update column contained in an object table

I was looking for a MapBasic sentence to update a MapInfo table. I've got two tables and I want to update one of them (POINTS) with an attribute of another (REGIONS). I would like to update points ...
2
votes
2answers
395 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 ...
2
votes
2answers
53 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
134 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
111 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
1answer
4k views

Making POINT from longitude/latitude coordinates in existing table using 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 ...
2
votes
0answers
23 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
167 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
2answers
2k 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
99 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
386 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
46 views

Add value in Attributestable without reducing the attributetable

I am working with the modelbuilder to create a model which can be used by people who do not have a lot of experience with ArcMap. I have a Shapefile with a huge attributetable. I created a new column ...
1
vote
1answer
53 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
301 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
45 views

Copy tables from one server to another in PostgreSQL

I am trying to copy a number of tables from one server to another using PostgreSQL as part of reorganising our data structure. I am pretty new to PostgreSQL so haven't much experience with it. Is ...
1
vote
1answer
36 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
42 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: ...