A set of data elements arranged in rows and columns.

learn more… | top users | synonyms

0
votes
0answers
8 views

Trying to geocode and map a large street segment table with no lat-long [on hold]

I have a table with 26000+ street segments with address ranges and school zones I would like to convert to a GIS layer. Any suggestions?
0
votes
1answer
33 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
51 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
73 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
35 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
39 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
48 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
31 views

ArcGIS/arcpy: add field to table iteration

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
37 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
46 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
45 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
130 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
55 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
73 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
88 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
45 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
53 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
42 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
81 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
88 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
47 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
51 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
52 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
84 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
33 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
28 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
62 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
68 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
49 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
15 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
74 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
33 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
28 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
72 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
38 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
172 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
93 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
54 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 ...
1
vote
1answer
41 views

How to use a feature class attribute to look up values in a table and pass them as parameters to a function?

My problem: I have a set of points inside a polygon. My goal is to figure out how long it takes (in days) for each point to move outside the polygon, based on a daily movement which affects all the ...
0
votes
1answer
68 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
2answers
48 views

Diverse values to one field for soil analysis

I have soil analysis data in an Excel table. For one analysis point there are values at three depths. Besides the Excel file I also have a shapefile with the points to which I want to add the soil ...
0
votes
0answers
34 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
88 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 ...
2
votes
1answer
112 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". ...
1
vote
1answer
30 views

Adding images to raster field in batch

So I've got about 300 records in an attribute table that each need an image to go with them. I've created a raster field on the table, and I've got all the needed images as rasters in the same GDB. ...