We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [table]

A set of data elements arranged in rows and columns.

Filter by
Sorted by
Tagged with
4
votes
1answer
272 views

edits to attribute table in qgis do not show up in arcgis

I have received a point file that was made in QGIS. if a row is deleted in QGIS it appears to be deleted, in QGIS. If I import that shp file into arcgis the attribute still shows the rows that were ...
1
vote
2answers
82 views

Variable Expression In ArcGIS

I am creating many models doing many tasks. Basically, the first model will join 2 tables and the steps are as follow: make table view for each table, then add join for, then it will copy the rows for ...
6
votes
2answers
2k views

Way to find minimum value from a group of values - QGIS?

I'm wondering if there is a way to find the minimum value of a group within QGIS? Basically I need to find the minimum distance of each unique value in a table of about 5000 records. I can do the ...
3
votes
1answer
5k views

Editing Related Tables in ArcGIS Online?

Is it possible to edit a related table via the browser in ArcGIS Online? The last update I heard in February was only available via ArcGIS Collector. I was wondering if ArcGIS Online supports ...
1
vote
1answer
120 views

Debugging ERROR 000732 Cannot create table from feature class in file geodatabase?

I am unable to create table from feature class in file geodatabase. below is the screen of shot of the tool with error message ERROR 000732
0
votes
1answer
241 views

FME - Exploding Series of Attributes to Features for Each Combination

Given a unique identifier attribute (TYPE below), there needs to be the combination for each comparison between the identifier and (n) value attributes to be written as a new feature. See the example ...
0
votes
1answer
62 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
45 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 ...
1
vote
1answer
56 views

What is the most efficient way to get the values of a previous row in a table using ArcPy? [duplicate]

I am very new to ArcGis and I would like to get a specific value of the previous row in a table. I found this question here on gis.stackexchange.com and experimented a little bit. However, I found ...
1
vote
1answer
675 views

Create FeatureDataSet in geodatabase with Arcpy from a table

I create an empty file geodatabase (gdb), and I would like to import in this gdb several feature dataset, at least 120 different dataset. I would like to import those dataset from a table like an ...
1
vote
1answer
7k 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 = arcpy.da....
1
vote
0answers
157 views

Surface Volume: output table given all in one column?

The model iterates through a Point Feature Class to calculate different volumes. As an output I get two different styles of tables, both in one and the same iteration. One is the actual correct output ...
2
votes
1answer
391 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
444 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
votes
1answer
40 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 ...
2
votes
1answer
136 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
233 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
76 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 ...
1
vote
1answer
270 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 ...
2
votes
1answer
1k 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 ...
1
vote
1answer
150 views

Arcpy to append results of pivot table

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 statistics using arcpy.sa....
0
votes
1answer
138 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: http://www....
1
vote
0answers
96 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 ...
3
votes
1answer
1k 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
402 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
97 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
0answers
78 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
118 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 ...
1
vote
1answer
2k 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 ...
3
votes
3answers
3k views

Normalizing values in single Field (from table) in ArcGIS for Desktop?

have encountered a problem, in Field Calculator. The situation : I have a polygon feature with a table, comprised of a single Field ("Field1"). There are 675 records in this field. The minimum ...
1
vote
1answer
490 views

Deleting rows on dbf table with python for ModelBuilder?

Being not very familiar with python, and after carrying out unfruitful long research on internet, I submit to you my problem, hoping favorable reply. I have a DBF table with geochemical data and I ...
-1
votes
1answer
650 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
949 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
571 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 ...
0
votes
1answer
2k views

Changing attribute length of 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
630 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 -7....
1
vote
1answer
773 views

Using Configurable Map Viewer Attributes Table?

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
3k 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
1k 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 the ...
1
vote
1answer
559 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
150 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 ...
2
votes
3answers
171 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, ...
1
vote
3answers
811 views

Returning 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 = "C:/...
2
votes
1answer
69 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 ...
1
vote
1answer
100 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 ...
2
votes
0answers
174 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
292 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
56 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
813 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 ...
0
votes
1answer
59 views

Compare 2 tables of different lengths

I have 2 Layers: Not_Joined and Joined Not_Joined: Old digitized data that has X attribute in it. Joined: Spatially joined layer that has the polylines with X attribute in in the table Each row in "...