A tabular set of data linked one-to-one to a set of spatial features.

learn more… | top users | synonyms

3
votes
0answers
64 views

Can you use wildcards for column headers in Field Calculator?

I know you can use wildcards for fields like so (in the Field Calculator): case when "column" ILIKE '%example%' then 1 else 0 end Can you do something similar for the column headers themselves? I ...
3
votes
0answers
93 views

How to export data from sql server into shapefile in the decimal format in QGIS 2.4?

The last couple of days, I have been working on exporting data from SQL to a shapefile in QGIS 2.4. While converting into a shapefile, the data type changes automatically from Float to Integer in the ...
3
votes
1answer
78 views

Can QGIS table editor achieve similar results to Pivot tables in Excel?

Is it possible to achieve similar results to Pivot Tables in QGIS table editor so as to use just QGIS instead of several software solutions? Or are there maybe some plugins capable of achieving those ...
3
votes
1answer
79 views

How do I add a field to a table using the QGIS graphic modeler?

I was wondering if anyone could help as I'm struggling to get anything out of the QGIS graphic modeler. For info I have no programming skills whatsoever. I need to be able to add a new field to an ...
3
votes
0answers
152 views

QGIS Select Single Feature not correct in attribute table

For some reason, QGIS is not displaying the correct row of my data when I click on a feature with "Select Single Feature" or even the other select tools. I have a point database linked from mysql. ...
3
votes
0answers
83 views

Add attribute table to a raster in postGIS

I would like to add attributes to a raster stored in a postgis database. I use the following command to insert the raster in the database: raster2pgsql -s 4236 -I -C -M ...
3
votes
0answers
68 views

How do I merge US counties consistently? [closed]

I am new to QGIS. My project involves county-level data. The problem is that US counties keep changing! (See the US Historical Counties project: http://publications.newberry.org/ahcbp/) Since my ...
3
votes
0answers
296 views

How to calculate the distance to multiple locations from each cell of my raster?

I'm working with Arcgis 10.1 and Python 2.7.2 How can I calculate the distance to multiple locations from each cell of my raster? I tried euclidean distance but it only provides the distance to ...
3
votes
0answers
256 views

How to create raster attribute table to a raster data using gdal python?

I classified a remote sensing data and saved it as a raster using Gdal python. I want to create a raster attribute table for this classified result.. my classified raster has five classes with ...
3
votes
1answer
277 views

Build Raster Attribute Table with GDAL Utilities

Is there a way to build a raster attribute table using one of the GDAL utilities? I know you can view it using gdalinfo and I have successfully created one using Python, but it would be so much ...
2
votes
2answers
145 views

How to show the entire number of records in the attribute table?

How do I show the entire number of records in an attribute table? The number should be around 100k records, but it only loads 2k at a time.
2
votes
3answers
108 views

Problem with deleting features/objects in Attribute Table

I am a new to the field of GIS-Software. So i hope for your patience. English is not my native language so sorry for that too ;). My overall goal is to export a DXF-File with just the special objects ...
2
votes
3answers
3k views

Automatically update field value in one column based on change to another column in same table?

When editing I want to be able to change the attributes of one field and upon doing this allow for the automatic update of another field in the same attribute table. Essentially I have one layer ...
2
votes
2answers
92 views

How to compare two string field values within a given string value in ArcGIS10

I have a polygon shapefile which displays villages [NAMING]. On its attribute table I have, in one Field, their names and for each feature and I have its municipality too [POLYGON_NM]. Now what I ...
2
votes
3answers
234 views

How can I do a batch edit of circle diameters using the attribute table in ArcGIS?

I need to edit the diameter of a bunch of circles to reflect their correct diameters, and I wondered if there was a way of drawing from the attribute table to make all the circles equal their correct ...
2
votes
1answer
87 views

From CSV file (latitude and longitude fields) to point .shp

How i create a new point shapefile from CSV table? If i have a CSV file with a latitude and longitude fields, is there a method for to have in output a puntal shapefile?
2
votes
1answer
230 views

Splitting strings into new rows, retaining geometry

UPDATED BELOW I have 9 shapefiles, each shapefile has 700,000+ rows and I have roughly 12 attribute fields in each shapefile. There are three attribute fields, common to every shapefile, that I am ...
2
votes
1answer
403 views

How to provide meanings (metadata) of attributes/fields with shapefiles?

Usually when doing GIS projects, especially when working as a freelancer, you're just provided with a bunch of shapefiles and you have to figure out yourself what all the table attributes mean. ...
2
votes
1answer
87 views

Why do edits made in attribute table not show in associated layer? QGIS 1.8.0

I have compiled a heat map layer to display over a background raster map. I discovered that the heat map layer was incorrectly positioned because I had made an error in the coordinate entry fields of ...
2
votes
1answer
192 views

Updating and inserting a field within the same loop

I am working with an empty feature class where I am writing a script to create polylines within the featureclass and attach an associated text value with the polyline. I am using a for loop as noted ...
2
votes
1answer
396 views

How to bulk delete shapefile columns?

I have shape-file with next attribute table: - name of features, unique number for each feature of layer I must split shape-file by NAME field, but in result in attribute tables of layers should be ...
2
votes
3answers
1k views

Creating new shapefile based on its attributes with python

I have a shapefile which has an attribute year. I used to generally copy and paste these features in the dataframe and then using the definition query just show polygons which were established before ...
2
votes
1answer
2k views

ArcGIS 10.0 \ arcpy - CalculateField_management : help with syntax for updating text in attribute table of feature classes

I am trying to add (ie "Author", "LastUpdated") to feature classes within a gdb and then populate each of those fields. I have been able to get my code to run properly for the numerical field but I ...
2
votes
2answers
5k views

How to merge (append) two tables in ArcGIS 9.3.1?

How do I merge 2 tables (they both have the same field names and columns) in ArcGIS 9.3.1 ? Thanks,
2
votes
2answers
29 views

fit a wrap column in the print composer QGIS 2.4

i have an attribute table in the map composer, and the field i want to see is quite long...so i wrap it. but the field width is not fitting this new length. how can i do that. is qgis prepared to do ...
2
votes
1answer
126 views

Possible to set an attribute field to update automatically based on another field?

If I have 2 attribute columns and I wish to change certain values, is it possible for the second attribute column to automatically update its values based on an expression? Example: Age | Status 10 ...
2
votes
2answers
117 views

How to show only raster attribute table using GDAL?

I have a binary ArcGRID raster (AIG/Arc/Info Binary Grid) with an attribute table. I would like to get only this attribute table but gdalinfo outputs also projection information and bounds and then ...
2
votes
1answer
421 views

How to create attribute table for raster data?

I have raster dataset for rainfall but its not having attribute table. How can I create tabular data using the same raster file? How to join it back again to it? Software used is ArcMap 10.1.
2
votes
2answers
705 views

Model Builder - iterate through columns in a table

This seems like it should be a no-brainer, but I am unable to find any info on how to use model builder to run a certain spatial analysis function on each column in a table. Problem: I have a table ...
2
votes
1answer
1k views

How to delete row from attribute table on QGIS1.8.0

Is it possible to delete row from attribute table!? I can delete from selecting feature. I encountered invisible polygon. I could not select feature. Thus, I would like to know how to delete from ...
2
votes
1answer
2k views

find polygon corner coordinates

I am trying to get the coordinates of each node of the polygon I create. I would like the attribute table to display the name of the polygon (ex. address) and then the coordinates of the nodes (ex. ...
2
votes
1answer
104 views

Dynamic Attribute Table

This seems silly to me, but I haven't hit this before. I have multiple (30+) point tables, 100 data points each, and want to start designing symbology and doing things like point distance. However, my ...
2
votes
2answers
4k views

Auto fill column in attribute table

Is there a way to fill a column in the attribute table with the same value, similar to a paste . Is there something in the calculator that can be used to fill selected records/attributes.
2
votes
1answer
425 views

Could not commit changes to layer X

I am editing a layer's (Z) attribute table. I made some columns, used the field calculator to fill them up, made some more, went back and deleted some and then tried to save the edits and got the ...
2
votes
2answers
120 views

“show only visible features” doesn't seem to work

I'm trying (unsuccesfully) to place the attribute table next to a map containing the same in print composer. Let's say for example my map in the primary window contains 6 districts and my map in the ...
2
votes
1answer
59 views

Populate field with current time

I am trying to populate a field with the current time. Here is what I tried that did not work: Start editing Open Attribute Table Add Field -> Name: time Type: Date Right Click on Field Name ...
2
votes
1answer
58 views

Why don't all the attributes in the SQL query appear in table?

I have an SQL query that works fine in the DB Manager but when I load the table as a layer one column does not get loaded. The different thing about this column is that it is static -- text generated ...
2
votes
2answers
82 views

How to change precision on a column in the attribute table without losing data?

I have data in an Excel-file that I want to join with a shapefile in my project. The Excel-file contains values like volumes. The Excel-file and the shapefile I want to join it with both contain the ...
2
votes
1answer
110 views

How to do a “fuzzy” intersection?

I have two layers that look like this: I want the intersection (or whatever the correct term may be) to look like this where the output polygons are the same as the original base layer, just with ...
2
votes
2answers
294 views

Creating New Layer After Sorting Attribute Table using QGIS?

I have been self-teaching myself some open source GIS. I downloaded QGIS and have been following this four part tutorial - ...
2
votes
1answer
94 views

QGIS 2.4 : How to search an Attribute Table?

I am learning how to use QGIS on v.2.4. When opening an attibute table, it does not have any clear "look for" search bar as seen in older versions in screenshots and videos. There is now a (SQL?) ...
2
votes
1answer
52 views

Summarizing Table on 2 fields

I have a table of Census Blocks linked to ZIP4 values. I'm trying to create another table getting the unique ZIP4 values associated with each Census Block. I've tried using the Frequency, and Summary ...
2
votes
2answers
134 views

Auto fill second column with predefined names depending on first column (QGIS)

I want to create a point layer. In the attribute table I want to have two columns. In the first column I want to type an abbreviation like A. Then I want the second column to be auto filled with ...
2
votes
1answer
50 views

Expression to create and populate column based on filtered fields

I wanted to create a column and populate it with data based on data from other fields. If column_1 contains fields which has similar string (eg. field_1 = "Country: UK", field_2 = "Country: US", ...
2
votes
1answer
318 views

How to adjust QGIS attribute table view column width using Python?

I'm programmatically opening the Attribute table via Python through a plugin. All of the columns have a default width, but some of the data that I'm using do not fit. It's not enough to be able to ...
2
votes
1answer
307 views

How to make autoIncrement number start with (001…009, 011…099)?

i have a challenge with my time in my work, i have feature class called "Parcel" storing many data, i generated an autoIncrement number by using field calculator, in field "parcel code" Expression: ...
2
votes
1answer
66 views

QGIS; Is it possible to show layer name in attribute table in print composer?

When adding attribute tables in the print composers it is not possible to distinguish between various tables from various layers; each table is generic and does not indicate which layer the table is ...
2
votes
2answers
185 views

Correctly calculating attribute table column in gvSIG

I am trying to conduct a multicriteria evaluation, and it is necessary to check the compatibility of two different land-use types that I have in seperate layers. I am working in gvSIG 1.12, and have a ...
2
votes
1answer
1k views

ArcMap - Opening the attribute table gives 'Could not load data from the data source' error

ArcMap wont display the attribute table of a dataset. I get an error 'Could not load data from the data source' and it says 'An invalid SQL statement was used'. It then opens a table with the correct ...
2
votes
2answers
824 views

Why are edits in shapefile table not saved?

I have created a shapefile (point data) and wish to change some parameters in the files table data. I can edit the data and see the coresponding change in my my symbology. However, when I save the ...