A set of data elements arranged in rows and columns.

learn more… | top users | synonyms

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 ...
1
vote
1answer
107 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 ...
0
votes
1answer
27 views

Using address locator with data tables

I have been struggling for some time to find a way to search the asset tables using the FIND tool; I "discovered" address locators. Is this going to be my solution? The problem: I have polygons ...
0
votes
1answer
33 views

matching up fields in different tables

I am going to attempt to explain my problem, and hopefully someone out there will have some insight/solutions/work arounds. I work for a University, and we have some utility/site people go out with ...
0
votes
1answer
27 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, ...
4
votes
0answers
371 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 ...
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
166 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
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
0answers
29 views

QGIS Freehand editing plug-in: blocked attribute table

I can't save object after drawing by Freehand editing plug-in. I suppose it will be connected with creating some (special) column in the table. Could anyone suggest a solution?
1
vote
0answers
52 views

How to convert picture to annotation in ArcGIS 10.1?

I have been tasked to display analytical data tables (currently in MS Excel) in an ArcGIS (v 10.1) map document (.mxd) and would also like to convert them to map document annotation, if possible. ...
1
vote
0answers
28 views

Odd characters showing up in symbology view

I am trying to symbolize based on company name but there are weird Greek symbols showing up in my Symbology view of the actual field values. Has anyone ever had this problem? The weird symbols do not ...
1
vote
0answers
62 views

How to Build Query Table from two OLE DB tables using ArcPy?

When I run the following code to create a subset of a table, the error says "An invalid SQL statement was used" [Query]. The error shows in line 39. Is there any idea you can figure this out? import ...
1
vote
0answers
41 views

My fusion table map with search not working

My maps are not working. It shows the search box but not the map: // ]]></script> <script type="text/javascript">// <![CDATA[ var map; var layer_0; function initialize() { map = ...
1
vote
0answers
119 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 ...
1
vote
0answers
184 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
0answers
176 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
34 views

ArcPy select and merge dropping records from table?

I'm working on a python script for ArcGIS using the arcpy module. I have ArcGIS 10.1 and Python 2.7 on Windows 7 machine and using Notepad ++ and IDLE to run it. The script selects specific records ...
0
votes
0answers
48 views

How to select records in a table based on attributes in related table

I am using ArcMap 10.1 and Python I have a list of addresses to geocode, but I want to thin the list because I only need a specific area of the addresses. I have a layer containing the streets in ...
0
votes
0answers
23 views

Using file directories from a table

I have a toolset that will be using a set of file directories as input (shapefiles, raster etc.).The table can be stored as CSV or DBF. Is there a way to read a specific cell (row,column) of the ...
0
votes
0answers
41 views

binary map file editing

in Mapsforge binary .map file exist a zoom table.defining of this table is: A table indicating the number of POIs and ways in this tile for the different zoom levels covered by the enclosing ...
0
votes
0answers
61 views

In ArcGIS, how to automatically recalculate a calculation if I modify the Excel data source?

There's a database with buildings. Each of them has a few parameters, for example building type codes. In a distinct table each building type codes has 4 attributes. During the Join, the datas will ...
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
58 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 ...
0
votes
0answers
80 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
0answers
71 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
0answers
425 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 ...
0
votes
0answers
409 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?
0
votes
0answers
173 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 ...