A set of data elements arranged in rows and columns.

learn more… | top users | synonyms

0
votes
1answer
12 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
1answer
37 views

Copy table to attribute table

I have some tables with columns that I need to join/copy to another table, in case an attribute table. I was using join but I realized that it would be a better solution to add new fields to my ...
1
vote
1answer
28 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
0answers
10 views

A better way to do Tablular Labels (Chemboxes)

So it's been a couple years since I've looked for a new solution for this, but I recently have a newer project manager who really wants "chemboxes", basically labels/callouts with tabular data. I've ...
0
votes
0answers
7 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
33 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: ...
1
vote
1answer
23 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 ...
0
votes
0answers
12 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 ...
2
votes
1answer
54 views

Creating a table of multiple rows and columns from attribute table

I am trying to create a street index a City. I have a table that has all the street names and their grid references. I am looking to create a street index using that. I think turning off the undesired ...
0
votes
1answer
37 views

Arcpy to append results of pivot table

Good Day All, So I have a script that does some processing but the main part are two things run a multiple ring buffer using arcpy.MultipleRingBuffer_analysis and four rings do some zonal ...
0
votes
1answer
53 views

Write CSV table for join self in ArcGIS for Desktop?

I wonder how I would write a table for a join which I want to perform. Right now I wrote a .txt File, tab-seperated. The headerline only contains letters. Here is the problematic table: ...
1
vote
0answers
75 views

Access 2000 database via ArcCatalog displays decimals as integers?

I import an Access 2000 database through ArcCatalog. When I complete the process and check the attribute table, the values come not as decimals as they are in the database but as integer numbers. Why ...
1
vote
1answer
66 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
63 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
50 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 ...
0
votes
0answers
40 views

ArcGIS/arcpy: add field to table iteration [closed]

I want the average precipitation for 50 regions in my country for each hour. To do this, I have built a arcpy script that performs 50.000 iterations (hours) over .nc files. The result of each ...
1
vote
0answers
44 views

netcdf python error

I am basically copying and pasting the code provided on Esri's website and every time I try to run it in ipython, the program crashes and needs to restart the kernels. The code is below, does anyone ...
0
votes
1answer
49 views

Create Table from Selection

This is a continuation of a problem that was solved earlier this week. The code below performs a select by location and was originally intended to export all feature classes from the SDE database to ...
0
votes
1answer
60 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 ...
2
votes
3answers
154 views

How do I normalize the values in a single Field (from a table) in ArcGIS?

First of all, this is my first post, and I would like to appreciate all the useful information I have found so far on this site. Second of all, I have encountered a problem, in Field Calculator. ...
0
votes
2answers
69 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 ...
-1
votes
1answer
94 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, ...
1
vote
1answer
109 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
51 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
58 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
50 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 ...
0
votes
2answers
112 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 ...
1
vote
2answers
137 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 ...
0
votes
1answer
80 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 ...
1
vote
1answer
57 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. ...
0
votes
0answers
86 views

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

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 ...
1
vote
3answers
43 views

Listing Attribute Table in order of Selected objects

Currently when I open my attribute table, I get the order or points by which they are added and I would like to get them in order in which I selected them. For example, I select points (in order): 6, ...
0
votes
0answers
24 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 ...
1
vote
3answers
103 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 = ...
2
votes
1answer
35 views

Working with related table

I tried to dissolve smaller features into larger (from unit to district) with field in related table. I can easily see the related records of related (many) table but unable to dissolved the features ...
0
votes
1answer
30 views

Is the PostGIS Raster primary key required to be named rid?

In all examples from the PostGIS Raster reference the primary key in tables with a raster column is named rid. I wonder if that naming is expected by any functionality of PostGIS itself or any client ...
0
votes
0answers
70 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 ...
1
vote
0answers
73 views

Maintaining same number of digits in Excel file when converting to table in ArcGIS for Desktop?

I have two fields containing lat and long values which are precise up to 8 digits. When I use the excel to table tool, Arc removes the last two digits in both fields leaving me with lat and long ...
2
votes
2answers
56 views

replaceDataSource for Tables from one SDE server to another server

I found the code that works to change the layers in my mxd from one SDE workspace to the other SDE worksspace. The script runs, but does not change the tables to the new SDE workspace. I replaced lyr ...
1
vote
0answers
18 views

Catalog table list into web browser

I'm looking to do some cataloging of both workspaces and table metadata - I want to cycle through a workspace and pick up the table names and associate those with the wrokspace name (I can then track ...
0
votes
2answers
88 views

Python column checker-comparing 2 fields

One problem I am having is the following: I want to create an automatic program to see how well the automozation has been with comparing the results of 2 columns to each other in the same column. In ...
1
vote
1answer
31 views

Compare 2 tables of different lengths

I have a problem and am looking for some help with the following: 2 Layers: Not_Joined and Joined Not_Joined: Old digitized data that has X attribute in it. Joined: Spatially joined layer that has ...
1
vote
1answer
35 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
0answers
32 views

QGIS 2.4 Join Attributes Table tool does not recognize non spatial data to execute

I'm using the graphical modeler in QGIS 2.4 to automate some processes and certain tools are basicly necessaries to get to the point. The "Join attibrutes table" tool, despite it's basic, can help us ...
0
votes
2answers
76 views

Editing tables in ArcGIS for Desktop with Python Parser of Field Calculator?

so I'm trying to edit a table so that the name column will not contain spaces. I just don't know how to write the Python script that should go with it. This is what I have for the Python script ...
1
vote
0answers
45 views

Pivot Table not displaying in ArcGIS?

When I performed my pivot table in MS Excel and then made a chart of it and I am trying to copy and paste it to ArcGIS and it is not displaying at all... Is there a work around to do this ?
1
vote
1answer
241 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 ...
2
votes
1answer
115 views

How to transfer attributes from standalone table to feature class using ArcGIS for Desktop?

In short, I have a stand alone table that has an identical table schema to a feature class. I am creating a feature in the feature class and need to copy the selected row from the stand alone table ...
0
votes
1answer
73 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
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 ...