A set of data elements arranged in rows and columns.

learn more… | top users | synonyms

0
votes
1answer
143 views

CartoDB table join error: Column reference is ambiguous

I've got a CartoDB question that seems dumb b/c the layer is correctly rendering. Anyway, I have two layers, named sampling_points sample_point I'm trying to inner join the sample_point data to ...
0
votes
1answer
103 views

How do I merge two columns into one column steps? [duplicate]

When I save the table after I set up the classifcation and then ArcGIS save it as a INFO file and then you have two columns that you want to merge into one. Is there a better way to do that ? What I ...
0
votes
1answer
103 views

US Census block group data - field names for feature classes

I may be missing something here, but it seems like getting usable US Census data into a shapefile or feature class is much harder than it used to be. Downloading the Tiger block group shapefiles is no ...
0
votes
1answer
562 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 ...
0
votes
1answer
771 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. ...
0
votes
1answer
134 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
161 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
2k 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
1k 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 ...
0
votes
0answers
16 views

Change dbase table alias

How can I change the alias of a dbase table without completley renaming the file? I've tried right clicking the the file, opening properties, and changing the alias, but it will not allow me to edit ...
0
votes
1answer
21 views

Mapping Ecclesiastical Parish Data

I am looking for a way to plot data relating to the number of people in a given location - the location being an ecclesiastical parish. So I need software that will allow me to import a map of ...
0
votes
0answers
22 views

Fail in searches on the joined table data

When a table is joined to a standalone table, the searches on the joined table data return a fail. Is there another way to solve this inconvenient without save the layer with joined table under a new ...
0
votes
1answer
16 views

Adding data column by column in postgreSQL database

I organize my data in different txt files and dat. files, mostly in each file there is one specific column of data. Now I want to import and combine 4 of them to create a table. Say I have one file ...
0
votes
0answers
8 views

Cannot Load Object - Region object type is not supported in this table. Operation canceled

I have linked an Access Database with MapInfo and created a mappable tab. However I am unable to populate the table with any regions/polygons/poly lines etc. It says "Cannot Load Object - Region ...
0
votes
0answers
49 views

import table from sql database results in empty ouput - ArcMap

I am trying to import a table to a .gdb from a SQL Server database (not spatial). I can see the table's rows and data in ArcCatalog preview. When I import, there are no errors but I get a message: ...
0
votes
0answers
23 views

Small individual tables/crosstabs for points from Access to plot on maps

I currently have an Access database (accdb format) that is currently linked in GIS (ArcGIS 10.1) through an OLE DB connection. I have a groundwater analytical table with 36,000+ records that contains ...
0
votes
1answer
88 views

Iterate through all fields in attribute table and multiply by field

I have a table with a whole bunch of census variables (race, age, education, etc). I want to multiply all of these fields by a factor that I calculated. For example: Field1 has values of 10,20,30,40 ...
0
votes
2answers
88 views

Deleting rows on dbf table with python for ModelBuilder?

Being not very familiar with python, and after carrying out unfruitful long researches on internet, I submit to you my problem, hoping favorable reply. I have a DBF table with geochemical data and I ...
0
votes
2answers
166 views

CMV Attributes Table issue

I've created a CMV query widget that I am trying to link up with the Attribute Table widget. The table tab is being created in the bottom pane but that's as far as I'm able to get. I'm unable to get ...
0
votes
0answers
120 views

How do I join multiple features with a single geometry-less table entry? [duplicate]

I have three features with the same ID, let's say "5". I also have a corresponding text table containing IDs among other info (for example a "category" value). I want to join the table with the ...
0
votes
0answers
25 views

How to show an overview of all Joins and Relations in ArcMap Project?

Is it possible to get an overview of all Joins and Relations between my Tables and Files in ArcMap 10.1? Right now I have to right-click on every file to see how it is connected to another file. It ...
0
votes
0answers
82 views

Is it possible to insert Excel table with filter in ArcMap layout view?

Please see the image (https://apps.health.ny.gov/statistics/environmental/public_health_tracking/tracker/mapaction.map?activeTool=showIndicator&indicator=asthma). There are "Map display" and ...
0
votes
0answers
37 views

Using Modelbuilder or Python to write output a folder name using database or table file? [duplicate]

Has anyone worked on Modelbuilder or python to write to automate creating a folder using the database or table file to write output a folder name and or/create the subfolders? I recalled I had an aml ...
0
votes
0answers
37 views

How to save SQL-like WHERE as .qqf in QGIS 2.6?

I used to use QGIS 1.7.4. And there was "advanced search". I can save SQL where clause as .qqf. But I installed QGIS 2.6 and I cannot find this kind of things. Could you please teach me how to save ...
0
votes
0answers
72 views

QGIS - Tabular output for labeling

I'm new to QGIS and am trying to figure out how to output labels under a tabular symbology (I would have liked to post a file showing what I want but can't find a way to submit a file) : So my ...
0
votes
0answers
112 views

Array to Feature Class and XYZ to Table Issues

I am trying export vertices of a line to a point feature class using the code below. I am using ArcGIS 10.2.2 and do not have access to Spatial, 3D, or Network analyst. I used ET GeoWizards to export ...
0
votes
1answer
122 views

Attribute Table Subtract Value From Previous Value

I have a river shapefile and need to ensure every vertice has a lower elevation that the previous uphill vertice. I have converted the polylineZ to points using ET GeoWizards. This gives me a Z ...
0
votes
1answer
57 views

table update w/ cursor geometry conflict

I'm creating a table using arcpy with a list of results (stored in 2d lists) following an update to some features. This can sometimes include geometry, so I've attempted to substitute those for a ...
0
votes
1answer
24 views

How to drop a table in spatialite that starts with a certain string?

I am using spatialite (v4.2.0) on a Windows 7 (64bit) PC. I need a way to drop a specific table that always begins with "_old" from my database. The file may not be in the database in the first ...
0
votes
0answers
102 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
1answer
566 views

ArcGIS automatically convert string variables to numeric? [duplicate]

If arcgis is automatically coverting string values to numeric variables in a text document generated by stata, how do you change those variables back into string? I tried opening up the fields under ...
0
votes
0answers
193 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
25 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
1answer
52 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
43 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
0answers
81 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
81 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
246 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
41 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, ...
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? ...
0
votes
0answers
1k 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
1answer
121 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
738 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
1answer
181 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
0answers
262 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 ...
-1
votes
1answer
116 views

How to create a relationship class between a feature layer and a standalone table

I need to create a join between a shapefile and a table that have been added to the map, the issue seems to be with the memRelFact.Open("Table-Layer", (IObjectClass)fromTable, ...