A set of data elements arranged in rows and columns.

learn more… | top users | synonyms

2
votes
1answer
355 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 "<...
2
votes
1answer
4k views

How to avoid General function failure and delete table field in ArcGIS for Desktop?

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
3answers
1k 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 ...
2
votes
1answer
382 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 ...
2
votes
1answer
696 views

How to get a table from a leaflet map?

I have a map Here based on leaflet JS and the layers are geojson. I would like to get a table at on another div when I click on each layers. How would I be able to do that? Thanks
2
votes
1answer
318 views

Table analog of MakeQueryLayer

As of 10.1, arcpy provides the rather handy MakeQueryLayer function. This allows us to use arcpy to create query layers programmatically instead of having to go through MXDs (as was the case in 10.0). ...
2
votes
2answers
1k 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. ...
2
votes
1answer
32 views

How can i add coordinates of Polygon nodes on a Polygon data table?

I'm new in this domain and I want to know if I can add to data table of a Polygon.shp, coordinates of node. I have this table pkuid/ name_poly/ area/ lenght/ (here nr_point ex:1,2,3,4 it' about order/ ...
2
votes
1answer
42 views

Adding a table nulls all values in one column

I've read (and had to deal with) values being changed to "NULL" when joining data from a table to a shapefile. Now I'm having an even more basic problem: for some tables, when I add the table, one of ...
2
votes
1answer
126 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 ...
2
votes
3answers
73 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, ...
2
votes
1answer
75 views

How to save MakeNetCDFTableView output?

I was trying to extract the time-series data from the netcdf using grid points (lat/long) by MakeNetCDFTableView. I have more than 100 grid points and I want to extract the data from the netcdf file. ...
2
votes
1answer
243 views

Can I batch import attribute tables into existing excel spreadsheets

I am using arcGIS 10.2 and I need to import the attribute tables of 100 layers into existing excel spreadsheets which will make graphs based on the values in the attribute tables. Doing this ...
2
votes
1answer
872 views

How to add a table into the TOC in a Python script?

I recently experienced some troubles in adding a table from a specific folder to the TOC using a Python script. Any idea on how can I solve? Thanks, Annalisa
2
votes
2answers
4k 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 ...
2
votes
1answer
51 views

QGIS table does not dynamically update after applying a filter

Using QGIS 2.10.1, if I open a table and then apply a filter using Layer Properties > General > Provider Feature Filter, the table view does not update. In other words, the initial list of records ...
2
votes
1answer
51 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 ...
2
votes
2answers
119 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 ...
2
votes
1answer
355 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 ...
2
votes
2answers
137 views

Unable to merge CSV and CSVT with shapefile using QGIS due to “text” fields?

I know the question is all over this site, unfortunately I cannot find a solution. I have this CSV file and this CSVT file that I want to merge with this shapefile. I've tried to format the .csv using ...
2
votes
1answer
1k views

MapBasic sentence to update column contained in an object table

I was looking for a MapBasic sentence to update a MapInfo table. I've got two tables and I want to update one of them (POINTS) with an attribute of another (REGIONS). I would like to update points ...
2
votes
1answer
432 views

Export “Zonal Statistics As Table” output in Modelbuilder

I have an extremely simple model that takes as input a shapefile for zones along with a value raster. All the model does is produce a table of my desired zonal statistic for each zone (the mean). Next,...
2
votes
1answer
2k 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 ...
2
votes
2answers
67 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 ...
2
votes
1answer
280 views

How to write table blob field to file using ArcObjects?

I have a table with blob field and some others as well. I am trying to read blob field and save it to file using IBlobStream, and the thing compiles. The problem comes up in run-time, when calling ...
2
votes
2answers
166 views

Create multiple tables from distinct attribute category values using Model Builder

I've got a shapefile I would like to extract distinct values from an attribute field and have the output as tables based on those values. The shapefile is made of polygons representing parcels and ...
2
votes
0answers
49 views

Extracting Mean from Raster and Writing to Table in ArcPy?

I am simply trying to extract the mean of each raster within a geodatabase and write the value to a table. I have done this successfully with another set of rasters, but now I keep getting the ...
2
votes
1answer
171 views

Reordering Tables in ArcMap Layer List?

I'm trying to reorder the TABLES in my ArcMap layer list. I can't find a way to do it. I can reorder normal layers since they appear in the "List by Drawing Order" tab of the "Table of Contents". ...
2
votes
0answers
24 views

Are there are shortcuts for exporting polygon vertex location as a table [duplicate]

Someone came to ask me how he can export the X and Y locations of vertices from his polygon shapefile to excel. So I told him to convert it to points, add columns, calculate geometry, and then export ...
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
382 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
126 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
1answer
114 views

Is *.xls MS Excel default format in ArcMap?

Is it always necessary that whenever we want to show our data kept in Excel spreadsheets in ArcMap, that it must be in .xls? Is .xls a default format for ArcMap?
1
vote
1answer
2k 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
2answers
173 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?
1
vote
2answers
64 views

Getting number of objects in attribute table using PyQGIS?

I have a layer and I would like to access the number of rows the attribute table has from my code. Is there a way to do that without doing it like this: Index = 0 for Feat in Layer.getFeatures(): ...
1
vote
1answer
980 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
526 views

PostGIS Create Table with Geometry

I have written a query that will create a table and perform a GROUP BY from an existing spatial table, but the table does have the geometry. I am wondering where, and what, in this query I put to ...
1
vote
3answers
509 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 = "C:/...
1
vote
3answers
118 views

Add value in Attributestable without reducing the attributetable

I am working with the modelbuilder to create a model which can be used by people who do not have a lot of experience with ArcMap. I have a Shapefile with a huge attributetable. I created a new column ...
1
vote
1answer
279 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
2answers
3k 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 ...
1
vote
2answers
688 views

How to Append to rather than overwrite single table using ArcPy?

The code thus far works to create multiple output files, but I'd like to set it up so that the data is all exported onto a single table across multiple rows. The issue is I believe with the part in ...
1
vote
1answer
78 views

Merge Shapefiles and Add File Name to Attribute Table

I am trying to merge lots of point shapefiles together to form 1 large shapefile. What i want to be able to do is get the name of each of the point files to appear in the attribute table either during ...
1
vote
2answers
31 views

Merging two atributes columns in ArcGIS for Desktop?

I have a shapefile that is a result of a merge between a land use chart (with two gaps) and two files to fill the gaps, but the atributes in the Land Use Chart are designated by "LEG" and in the Gap ...
1
vote
3answers
32 views

Dissolving while retaining field informations in the same entry instead of multiple entries

I have 1520 covenants. Many covenants have more than 1 VM symbols attached to it, currently showing as rows. EG. Covenant #97 has 4 VM Symbols, with the VM Symbols 1, 67, 117 and 171. How do I change ...
1
vote
1answer
86 views

How to make a SQL query that would sum multiple records in ArcGIS?

I've got a large file geodatabase that contains a polyline feature class of water-pipes. The feature class have many fields, but the ones that I'm interested in is that of the water-pipe's Length and ...
1
vote
1answer
117 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 ...
1
vote
1answer
55 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
1answer
1k views

Copy tables from one server to another in PostgreSQL

I am trying to copy a number of tables from one server to another using PostgreSQL as part of reorganising our data structure. I am pretty new to PostgreSQL so haven't much experience with it. Is ...