A set of data elements arranged in rows and columns.

learn more… | top users | synonyms

1
vote
1answer
16 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 ...
0
votes
0answers
6 views

Default table setting in GeoServer? [closed]

In GeoServer I have two data tables. How do I select the other one to be the viewed one on the website, currently at the moment they have two different names, but we need to restore the original ...
2
votes
1answer
34 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
23 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
7 views

Creating Temp Table in SQL

I am trying to understand how I could make my Temporary Table Ambiguous instead of having to write out all of the different combinations within my data: Declare @Year as Integer Declare @LastYear as ...
0
votes
0answers
36 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
31 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
29 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
36 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
25 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
66 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
41 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
66 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
22 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. ...
0
votes
1answer
54 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 ...
1
vote
1answer
39 views

NAD27 to NAD83, saving AFTER transformation?

I need to measure the distance (with the ruler) of points from two different layers. One layer is NAD83 and the other is NAD27. When importing the NAD27 csv file, I specified it was NAD27. Then I ...
2
votes
1answer
65 views

Reclass in QGIS?

I'm new in QGIS and I'm trying to reclass a raster with reclassify grid values. I want to reclassify by table, however fixed table has only 3 rows and I need some more, but button to add is not ...
0
votes
1answer
33 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 ...
4
votes
1answer
58 views

Equivalent of excel Alt+Enter in attribute table?

On excel, you can do "carriage return", that is, jump a line, using Alt+enter within a cell. When I copy a cell from excel in my attribute table, this format is respected. I can find no way to write ...
0
votes
1answer
9 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 ...
2
votes
1answer
61 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
1
vote
1answer
44 views

How to configure GeoExplorer to render as HTML the content of the “Table panel” cells (especially as URL)?

I want to show in GeoExplorer the values of feature attribute set as url link, e.g. link to give users the chance for clicking them. It works inside the feature info window, but in the table panel ...
3
votes
2answers
76 views

Iterate calculate field in multiple tables in ModelBuilder

I would like to iterate calculate field in multiple tables using ArcGIS Model Builder. The figure below explains details of the calculations. My existing model calculates value only for the first ...
0
votes
1answer
66 views

How to properly write a txt to use as table in ArcGIS 10.1

I just wrote a txt. to use it as a table in ArcGIS, but for some reason when I open it, ArcGIS shows it in a completely wrong way. What am I doing wrong? Here is the original content: ...
1
vote
1answer
55 views

Create a New attribute table in ArcMap?

I am trying to create a new table of attributes for later purposes, in arcGIS but just an empty one, How can i do this? I also have it as an Excel format, but I don't know if there is any way to ...
5
votes
1answer
147 views

How do I extract partial data from one field to another?

Answer Below I am attempting to extract a date stamp that is contained in one field and insert it into another field. The issue is that the date (in bold below) is not in the same location in each ...
2
votes
2answers
66 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 ...
1
vote
0answers
55 views

QGIS Freehand editing plug-in: blocked attribute table

I can't save object after drawing by Freehand editing plug-in. I suppose it will be connected with creating some (special) column in the table. Could anyone suggest a solution?
3
votes
1answer
61 views

Trimble GPS data is not displaying in ArcMap attribute table

I am currently having difficulty trouble shooting a problem. While using a TRIMBLE GEOXH (GeoExplorer 2008 Series) I have the problem of missing data after exporting it to ArcMap from my GPS receiver. ...
3
votes
3answers
67 views

How to divide attribute table in map composer between 2 or more pages?

Does anyone know how to divide attribute table between 2 or more pages? In exported PDF it's unfortunately clipped.
1
vote
1answer
60 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 ...
3
votes
1answer
62 views

Merging .dbf Tables in Python w/o merging all fields of same name

I'd like to merge several tables together using Python. They all have the same field names: "TIME", "X", "Y", and "VALUE". I would like the "VALUE" fields to remain separate when merged, so that the ...
2
votes
1answer
46 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. ...
1
vote
1answer
41 views

I need to find the longest string of ALL cells in a table

I need to find the longest string of ALL cells in a table. Unfortunately, the table can have varying number of fields each time. This need to be a generic function. Any leads please?
2
votes
1answer
157 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 ...
3
votes
1answer
134 views

Creating .shp from .dbf in ArcMap?

How do I create a shapefile using the latitude and longitude information in my dBASE table? I am using ArcMap 10.1
1
vote
1answer
77 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 ...
1
vote
1answer
76 views

How to make reclassified raster layers automatically display break values in their attribute tables?

I am using ArcGIS 10.2. I have many raster layers which I need to reclassify (using the quantile method), I Also need to know the break values of these reclassifications. I know that the break ...
1
vote
0answers
67 views

How to convert picture to annotation in ArcGIS 10.1?

I have been tasked to display analytical data tables (currently in MS Excel) in an ArcGIS (v 10.1) map document (.mxd) and would also like to convert them to map document annotation, if possible. ...
1
vote
1answer
98 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). ...
1
vote
1answer
92 views

Updating a feature class

I am working on ArcGIS 10.2.1. I have a feature class containing more than 4000 records and a table having approximately 1000 records. Both feature class and table have some common fields however, ...
1
vote
1answer
117 views

Join of two attribute tables with different amounts of rows

I have a hard time sorting the following out: I have two different Shapefiles. The attributetable of one, lets call it shapefile A looks the following: SHAPEFILE A ATTRIBUTETABLE Name Type ...
0
votes
0answers
56 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 ...
1
vote
0answers
29 views

Odd characters showing up in symbology view

I am trying to symbolize based on company name but there are weird Greek symbols showing up in my Symbology view of the actual field values. Has anyone ever had this problem? The weird symbols do not ...
0
votes
3answers
122 views

UpdateCursor 'is not defined' Python

I have several files (shapefiles). Table 1 has only one row with several fields whereas Table 2 has several rows. What I want is to take a value from Table 1 and populate all rows in Table 2. I used a ...
1
vote
3answers
54 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 ...
0
votes
1answer
180 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 ...
1
vote
1answer
43 views

Attribute table in map composer is limited to 99 rows. How to change it?

I am using Qgis 2.2. I am about to create a cadastral index map, which are showing the parcels in specific gridcells, also there is an attribute table connected controlled by an atlas function. So by ...
-1
votes
1answer
55 views

converting a python list to arcmap table [closed]

I have values stored in a list that need processing in the costDistance tool in ArcMap 10.2 (desktop). For this they need to be converted into a table or file readable by arcmap's tools. Anyone with ...
0
votes
0answers
73 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 ...