A set of data elements arranged in rows and columns.

learn more… | top users | synonyms

2
votes
2answers
128 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
2answers
3k 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
1answer
120 views

Reordering Tables in ArcMap Layer List?

I'm trying to reorder the TABLES in my ArcMap layer list. I can't find a way to do it. I can reorder normal layers since they appear in the "List by Drawing Order" tab of the "Table of Contents". ...
2
votes
0answers
24 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
273 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
0answers
108 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
78 views

AttributeError: 'module' object has no attribute 'TabletoNumPyArray'

I am trying to create a Python array using data from an ArcGIS attribute table. Here's the code I've written so far: import arcpy import numpy input = "c:/data/from/arcgis" arr = ...
1
vote
1answer
458 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
119 views

How to return a unique value from table using Arcpy?

Using Arcpy in Python, I would like to return / print '0.15' from the following table: When I use the following code I get "(u'D', 0.20)" as my print statement in Python: import arcpy fc = ...
1
vote
3answers
78 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
332 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
1answer
228 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
457 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
32 views

With Modelbuilder, how to iterate field value so final output table is empty if input is empty?

I have created a model which will output two Excel tables (the green circles at the end) per state. I am using "Iterate Field Values" to go through each state to create the tables. While this gives me ...
1
vote
1answer
37 views

Make feature class from table data

I would like to create a feature class using an attribute table of another feature class. However, it does not use XY coordinates, so I can't create it that way. I thought I could export the data and ...
1
vote
1answer
231 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
58 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
90 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
500 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
2k views

How to avoid General function failure and delete table field in ArcGIS for Desktop?

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
1answer
35 views

How do I add a text file to ArcMap using ArcPy?

I'm specifically referring to the output of the Compare Table (Data Management) tool, which is a comma delimited text file. When you add the text file manually, you can actually view it like any ...
1
vote
1answer
45 views

Layout misshapen when export to PDF in Arc GIS 10

I want to include an Excel table in my ArcMap Layout which is working fine as long as I won't print to PDF. If I export the map to PDF the table looks like this: There are a lot of weird characters ...
1
vote
1answer
58 views

Order by column is sorting String like though it is an Integer column

The question is very easy. The usual sorting of an Integer column is really bad. I need it like 1,2,3...11,12 and so on. But currently it's more like 1,10,11...2,20... Here a picture Is there an ...
1
vote
1answer
62 views

Convert a lat, long, value table into a raster

I would like to to convert a table with latitude, long, and a value into a raster. My file looks like this: X Y Z 32.85138942 -6.643054718 0 32.85138942 -7.059721474 1004 32.85138942 ...
1
vote
2answers
187 views

converting csv to dbf

I have a python created CSV that I am looking to turn into a dbf but it is not getting read properly by the TABLE TO TABLE conversion tool. I select the csv, set the output to be XXX.dbf but the ...
1
vote
1answer
48 views

How to use a feature class attribute to look up values in a table and pass them as parameters to a function?

My problem: I have a set of points inside a polygon. My goal is to figure out how long it takes (in days) for each point to move outside the polygon, based on a daily movement which affects all the ...
1
vote
1answer
42 views

I need to find the longest string of ALL cells in a table

I need to find the longest string of ALL cells in a table. Unfortunately, the table can have varying number of fields each time. This need to be a generic function. Any leads please?
1
vote
1answer
188 views

Join of two attribute tables with different amounts of rows

I have a hard time sorting the following out: I have two different Shapefiles. The attributetable of one, lets call it shapefile A looks the following: SHAPEFILE A ATTRIBUTETABLE Name Type ...
1
vote
2answers
128 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
175 views

Why a severe performance difference using deleteSearchedRows

The issue I am having involves two versioned tables. A function deletes 48 rows from Table A and and 48 rows from Table B using deleteSearchedRows. However, the delete from Table A takes roughly 4 ...
1
vote
1answer
141 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
163 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
303 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
159 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
443 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
481 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
1
vote
1answer
33 views

Georeference disabled in CartoDB synced dataset

If I upload a dataset with synced option enable then I haven't the option to do the geocoding. Is that normal? How I can geocode the addresses? If manually I can't do the geocoding how I can do ...
1
vote
1answer
92 views

Opening spatial weights matrix file (SWM) from ArcGIS for Desktop in Excel?

I successfully generate spatial weights matrix file (SWM) to get the nearest neighbors for polygons shapes in ArcMap 10.2.2 but I am confused how to open this file its a compressed file and when I try ...
1
vote
1answer
69 views

Multiple Attribute Tables - CMV

I am trying to add multiple tables using tabs to one of my viewers but can't get it to work. Below is the code that I have added to my viewer.js widget option (it adds a table for 'Site 2' but not ...
1
vote
1answer
52 views

How to turn a shapefile into a table?

How do you completely turn a shapefile (created with QGIS, including .shx and the other 4-5 files) into one tabular dataset. I am actually doing this when I import the shapefile into Postgresql ...
1
vote
1answer
123 views

Deleting a standalone table from the TOC— C# ArcObjects

I'm looking to delete a standalone table that has been added to the arcmap document from an access database. I only want to delete it from the TOC, not from the file and I can't seem to get it to ...
1
vote
1answer
68 views

How to change the attribute length of an existing field afterwards

I already have about 100 values in a field in QGIS. I set it to 50 characters because I was thinking that would be enough. But that was wrong. I need more space in the column. But there is no way to ...
1
vote
1answer
59 views

Attribute Table Missing Information

I'm taking a QGIS MOOC on Canvas, and in one of the labs we're to change layer style using an attribute table. However, the attribute table displays some very strange information on my system. ...
1
vote
1answer
291 views

MapInfo, SQL data from multiple tab files which have the same columns

New to the GIS forum so apologies in advance for any potential etiquette failures... I'm working in MapInfo. I have multiple tables with the same structure. One of my columns is pipe diameter. I ...
1
vote
1answer
91 views

NAD27 to NAD83, saving AFTER transformation?

I need to measure the distance (with the ruler) of points from two different layers. One layer is NAD83 and the other is NAD27. When importing the NAD27 csv file, I specified it was NAD27. Then I ...
1
vote
1answer
59 views

Create a New attribute table in ArcMap?

I am trying to create a new table of attributes for later purposes, in arcGIS but just an empty one, How can i do this? I also have it as an Excel format, but I don't know if there is any way to ...
1
vote
1answer
144 views

How to make reclassified raster layers automatically display break values in their attribute tables?

I am using ArcGIS 10.2. I have many raster layers which I need to reclassify (using the quantile method), I Also need to know the break values of these reclassifications. I know that the break ...
1
vote
1answer
172 views

Updating a feature class

I am working on ArcGIS 10.2.1. I have a feature class containing more than 4000 records and a table having approximately 1000 records. Both feature class and table have some common fields however, ...
1
vote
1answer
50 views

Attribute table in map composer is limited to 99 rows. How to change it?

I am using Qgis 2.2. I am about to create a cadastral index map, which are showing the parcels in specific gridcells, also there is an attribute table connected controlled by an atlas function. So by ...