Tagged Questions

A set of data elements arranged in rows and columns.

learn more… | top users | synonyms

0
votes
1answer
128 views

How can I change the precision in the attribute table?

I'm working with QGIS, v. 2.0.1. I opened a csv-table (from an Excel-file) and now the precision is very high but I don't need this. At the moment the values are for example 15.00000000000000, how ...
1
vote
1answer
123 views

QGIS - select/aggregate by attributes and calculate

I need to know how I can select/aggregate equal attributes in a table. The column "Number" has attributes like 1.1 or 1.3 or 4.3. There are a lot of 1.1 or 1.3....in the column. In step1 I want to ...
1
vote
1answer
82 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 ...
2
votes
3answers
324 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
58 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
79 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 ...
4
votes
1answer
425 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 ...
2
votes
2answers
245 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. ...
1
vote
1answer
104 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
27 views

Is it possible to move a visualization to another table?

Is it possible to move a visualization to another table? e.g. when merging two tables, it creates a 3rd. OR to completely replace a table and maintain the viz?? I don't want to lose the original ...
0
votes
0answers
21 views

No values in overlay tab, only in diagram tab

I have basically the same issue like in this post. I joined a table to a .shp with the intention to display those values (integers) as a column overlay. Producing pie charts (Diagram tab) works fine, ...
0
votes
0answers
60 views

export spatial information from table that is joined to a shapefile in QGIS 2.0

I have a table with data values per district for different years. The table looks like this: district name / year / value. The same district is thus present in the data multiple times for different ...
2
votes
2answers
458 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 ...
0
votes
0answers
92 views

How to add and join Geodatabase Table to Feature Class in QGIS?

After finally figuring out how to open .gdb files from Arc 10 in QGIS, I need to join some tables to the spatial gdb coverages I've opened in QGIS. According to the colleague who converted the .gdb ...
0
votes
1answer
321 views

Adding and Editing Excel table to the data frame

I have few excel tables of almost 5-6 columns and i need to paste them at different locations in the same map. The values in the excel table gets revised every quarter and i need to edit the table. ...
4
votes
1answer
94 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 ...
0
votes
1answer
158 views

Create a Dynamic Table in your Map Layout - how to use Graphic table element?

Is this Solution (Create a Dynamic Table in your Map Layout using graphic table element) is part of this Extension ESRi production-mapping extension ? how can i use graphic table element ?
0
votes
0answers
74 views

Bug in Qgis 2.0 Field Calculator with Values from Joined table

I have a data of hospitals. I have two excel sheets, one has no of patients examined in each hospital and other has no. of patients treated in each hospital. I want to find percentage of treated ...
0
votes
1answer
29 views

How to make XY to Line dynamic to access query?

I have connected the Access file to the ArcGIS file, and displayed it using the tool XY to line, but when I change the access file, this is not automatically adjusted in the ArcGIS template. Somehow, ...
1
vote
2answers
124 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
160 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
1answer
490 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 ...
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 ...
1
vote
1answer
156 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 ...
0
votes
0answers
11 views

Table Manager - Shapefile (Labels) [duplicate]

I have a point shapefile which is an output of the plugin table manager. Now I’m labeling the features, but i can´t seem to get the move label bottom to work, and is active. Is there any connection? ...
2
votes
1answer
135 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 ...
1
vote
1answer
193 views

Split table column and use to update another table

I have a table (T1) which I need to populate (using python for ArcGIS) the fields Val1, Val2 and Val3 ID Val1 Val2 Val3 0 1 2 with data from another table (T2): ID Data 0 V1 1 V1 2 V1 0 V2 ...
2
votes
0answers
181 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). ...
1
vote
0answers
125 views

Display Table of contents of the map in ArcMap in the online published Map/Web map application

The following is the sample layer information of the map in ArcMap 10.1: How can I have the same Table of contents in the published map online or in web map application, so that user can ...
0
votes
2answers
96 views

Change column order in postgis 2.0

Is it possible to change the column order of a table in postgresql/postgis 2.0? If so, how is it done?
0
votes
0answers
483 views

Add new rows to a shapefile

I'm using QGIS. When I enable editing of a shapefile's table attributes and select, 'open attribute table,' is it possible to add new rows to the shapefile's table attributes? The problem I'm trying ...
4
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 ...
5
votes
0answers
399 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 ...
0
votes
1answer
84 views

ArcMap, Joining information from lyr with attribute table

I'm working on a landcover project with ArcMap 10.1 right now and use the ModelBuilder a lot. So far I extracted a table from a certain layer using the Summary Statistics tool. However, one field of ...
0
votes
0answers
450 views

Create .avl file Table

i would like to create a table of the .avl file i use as my symbology layer but cant come up with a way to do it in arcmap 10. Any thoughts?
1
vote
1answer
244 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
134 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 ...
2
votes
2answers
60 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 ...
0
votes
1answer
1k 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 ...
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 ...
3
votes
1answer
124 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. ...
1
vote
0answers
44 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
113 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
86 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
99 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
1k 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
712 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
679 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
191 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
606 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 ...