Questions tagged [table]

A set of data elements arranged in rows and columns.

Filter by
Sorted by
Tagged with
19
votes
5answers
12k views

Read a table from an ESRI file geodatabase (.gdb) using R

I am trying to read a table directly from an ESRI file geodatabase into R. An example data file can be downloaded here. The database contains a point feature class (Zone9_2014_01_Broadcast) and two ...
16
votes
8answers
3k views

Sorting by multiple fields at same time in QGIS?

Is it possible to sort multiple fields at the same time in QGIS? For example, I'd like to sort a table by state name, and then within each state, sort by county name. This would be the same as ...
11
votes
4answers
15k views

ArcGIS fails to import all records from huge CSV file to file geodatabase table despite being within FGDB table size limits

I'm using ArcGIS 10.0 on Windows 7 64-bit with 4GB of RAM. I have some very large tables in CSV format to import to ArcGIS, they all have about 30 fields, upwards of 5 million records per table (a ...
10
votes
1answer
30k views

Making POINT from longitude/latitude coordinates in existing table using PostGIS?

I would like to make a POINT using the longitude and latitude columns of an existing table. Here's a link to the documentation of ST_MakePoint. Here's my table: CREATE TABLE sysinst.bio ( oid ...
10
votes
1answer
13k views

Creating a spatial “Many to one” join

I'm trying to create what I call a "many to one" join. I don't know if that would be the correct term or not. I have a table that has unique account numbers for mobile homes (i.e. - M1007970) per ...
9
votes
1answer
3k views

How to create a customizabe table in QGIS Print Composer?

I would like to add a custom table to a map layout created in QGIS. I would like a fair bit of control over the look of the table (borders, background colours of the cells, etc.), and it appears that ...
8
votes
2answers
5k views

How to join a table to a shapefile with non-matching IDs and names (similar strings)?

I'm having an annoying problem that I'm trying to find an automated solution for. The shorthand version is that I have a shapefile and a table of created data for regions within countries. The created ...
8
votes
2answers
9k views

Table join with .csv file results in null fields after join

Similar to questions already asked about .dbf files, I'm attempting to join .csv files to a .gdb or shapefile coverage in QGIS. The tables as added to QGIS prior to the join look fine, but after the ...
7
votes
3answers
3k views

QGIS Table Manager plugin does not appear

I installed Table Manager Plugin, but cannot find it under the plugin menu. Anybody know where to find it?
7
votes
3answers
3k views

Creating geodatabase feature class using geodatabase table schema with ArcPy?

Is there a way in ArcPy to create an empty polygon geodatabase feature class that will acquire the schema of a geodatabase table? I know that it's possible in ArcCatalog (New -> Feature Class and ...
7
votes
1answer
3k views

Adding Table to Layout View using ArcPy?

I am using ArcGIS 10.1 and I have a non-spatial table and some layers in a Data Frame. When I switch to Layout View I want to be able to show the map in a data frame element and the table in another ...
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 ...
6
votes
2answers
5k views

How can I turn a python list into a table?

I am trying to create a table of coded values so each textual description has a numerical attribute. The order of numbers is not important - they just need to be unique. What I have so far is a ...
6
votes
3answers
486 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 ...
6
votes
2answers
4k views

Keep the same field headers after joining a table to a shapefile in QGIS

I noticed that after joining a table to a shapefile the headers of each fields in the table used for the join are changed by QGIS and they are attributed to a different name. For instance, I had a ...
6
votes
2answers
415 views

Creating Direction data in QGIS between two layers?

Can I do it in Qgis, that there are two layers, a target layer and an input layer, and I ascertain with an algorithm so that the closest points on the input layer are on the target layer in what ...
6
votes
1answer
5k views

Using Group By with Summarize on alphanumeric field in ArcGIS Desktop?

Is it possible to create from Summarize option, a new table with the COUNT of a string field and the code of municipalities, in my case, like that: +-------------------+--------------+ | ...
6
votes
1answer
2k views

Create multiple shapefiles from one table

I've imported a table into ArcGIS which I'd like to split into multiple shapefiles. The splits would occur between groups of records separated by any of 3 columns. In other words, col1, col2, and col3 ...
6
votes
2answers
1k views

How to delete fields from a Geopackage attribute table?

Using QGIS 2.14.0 on a Microsoft Surface Book with Windows 10, I created a geopackage from a layer using Save As... I can successfully add a field to the geopackage's attribute table, calculate ...
5
votes
2answers
4k views

Working around Table does not contain OIDs arcpy Error 000339?

I have a script I'm working on that takes a SQL table view and performs a Table to Table (arcpy.TableToTable_conversion) If I leave out the Where Clause the Table to Table works flawlessly, however ...
5
votes
2answers
154 views

Finding minimum value of different columns using QGIS?

I'll try to calculate the minimum value of four different columns in my QGIS table like: The min. value would be 1,50286 in the first row. Is there any expression or tool to find the minimum value ...
5
votes
4answers
2k views

How do I fill in serial letters (AA, AB,AC…,BA,BB,BC…ZZ) to a shape?

(I am using ArcGIS software, ArcMap...) MY PROBLEM I have a shape file containing points. The shape file contains 3 columns named FID, Shape* and Label. In the column I want to fill in AA, AB, AC...,...
5
votes
2answers
200 views

Table to Table converting ArcMap table to CSV file in external location cuts column names short?

I am having a strange problem with the ArcPy Table to Table function. For some reason, when I use the function to create a CSV file in a folder that exists outside of my python project folder, several ...
5
votes
3answers
11k views

Avoiding General function failure and deleting table field in ArcGIS 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 ...
5
votes
1answer
329 views

Extracting partial data from one field to another using Python Parser of ArcGIS Field Calculator?

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 line of the ...
5
votes
1answer
411 views

Writing QGIS field calculator formula?

I have a table with 2 fields, field1 contains site specific data, field2 contains a number which groups the field1: Field1, Field2 180, 1 203, 1 220, 1 205, 1 160, 2 140, 2 135, 2 I want to sort ...
5
votes
1answer
163 views

How to adapt a PostGIS query to modify the input table instead of creating a new table?

I use the following SQL query to create a table that contains dissovled polygons of an existing table: -- Schema: public -- Table: t_union -- Input table: input_table CREATE TABLE public.t_union AS ...
5
votes
3answers
5k views

Table to table script using Excel sheets (not workbooks) arcpy

So what I'm trying to do is to create feature classes from the sheets in an Excel table. I can get it to work if I save each excel sheet as its own workbook, however this isn't really what I want. I ...
4
votes
4answers
9k views

How to retain Field Name / Alias on Export of Table?

Is there a way I can modify the Field Name or to make him keep the Alias when a table is exported? Or is there a way to keep the Alias instead of the Field Name, when exporting for example to .dbf ? ...
4
votes
2answers
795 views

How to select duplicate records based on multiple fields?

I have a feature class with two fields of interest: "name" and "identifier" (Original Data; Figure 1). Note that there are several duplicate rows in the table and the table may or may not be sorted, ...
4
votes
3answers
981 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.
4
votes
1answer
2k views

Shapefile to table within python

I was just curious as to whats the best way within a python script to get the output a dbf file/ table while the input is a shapefile. (if possible which i'm assuming it is) Is there a way of ...
4
votes
2answers
621 views

Does ArcPy leak memory when importing CSV files?

I'm trying to import a great number of csv files of about 250MB each. I wrote a python script for that as follows: import gc import glob tables = glob.glob("C:\\Users\\emportella\\Documents\\ArcGIS\\...
4
votes
1answer
12k 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
4
votes
1answer
271 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 ...
4
votes
2answers
430 views

Getting all (or selected) values from single field in table using ArcPy?

I'm looking for a way to get all of the values from a single field in an ArcGIS table. Reasons for doing this might include pasting the values into a text document or SQL where clause. Since ArcGIS ...
4
votes
2answers
7k views

QGIS, Table Manager cannot rename column title

My current attribute table has a column whose title exceeds the ten letters maximum. I installed Table Manager, hoping I could rename the certain field to further use it (in order to add some ...
4
votes
1answer
379 views

How to convert all tables from FGDB into CSV using OGR2OGR?

I am trying to convert tables in FGDB to CSV formats. I have 40 or more tables though by the way. This is the code that i used and it seemed to work fine ogr2ogr -overwrite -progress -f csv "D:\...
4
votes
3answers
1k views

How to create a line with all attribute information of the original GPX points?

I am trying to make a shapefile line contain all the data that the GPX file has. So i load the gpx file into Qgis, (prompts me for tracks, waypoints, trackpoints, routes, etc) When i choose "Tracks"...
4
votes
1answer
3k views

Using field mappings to remove fields from a merged table

EDIT: Soreted, thanks :-) I'm trying to combine a (large) number of tables into a merged table, keeping only certain fields. I've tried the below, but it still gives all the fields. Any ideas? ...
4
votes
2answers
874 views

Setting up a dynamic table Excel to ArcMap

I am trying to create a GIS map that contains data for over 200 monitoring wells that are sampled 4 times a year. I would like to set up the GIS map so the attributes table for the well layer updates ...
4
votes
2answers
470 views

Using vlookup function in ArcMap?

I am trying to automate a field calculation using ModelBuilder, using a GDB table to populate a feature class field given two conditions: Traffic Count Value and Posted Speed limit I have created ...
4
votes
1answer
653 views

Joining multible rows in csv file to a single row in shp file using ArcGIS

I have two tables (one is actually a shapefile and the other one is a comma separated file). I really need your help with joining the csv file table (which has many rows for one ID number) with the ...
4
votes
1answer
174 views

End execution of script and send email if schema has changed

I would like to append the data from one feature class to another after confirming that the schemas match in both feature classes. I can append the data from one FC to another by using this simple ...
4
votes
1answer
296 views

Google Earth Engine - error when exporting table

I'm trying to export a frequency histogram table of a classified image for a region. function country (image) {var c = image.reduceRegion({ geometry: image.geometry(), reducer: ee.Reducer....
4
votes
2answers
739 views

Excel table losing color in over half of the highlighted cells when exported from ArcMap 10.4 to PDF

I'm trying to add a table to from Excel into layout view. Bringing it into Arcmap it holds the color in all the highlighted cells and looks perfect. There are about 85 highlighted boxes (out of 740) ...
4
votes
0answers
186 views

Creating labels with table style

Hello I'm trying to create a label in QGIS that is formatted similar to the "table" styled yellow labels in the photo below. The attached image was from a map created in AutoCAD. I would like the ...
4
votes
0answers
231 views

How to handle large tables in QGIS using python?

I'm currently writing a plugin that calculates values based on a QgsVectorLayer's attributes. To display and print the values I'm using a QgsComposerTextTableV2. I have several problems with my ...
3
votes
2answers
11k views

How to reclass a raster with reclassify grid values 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 ...
3
votes
3answers
3k views

Adding excel table to QGIS print composer?

Can anyone suggest some ideas to add a excel table to the print composer which will then be exported as a A3 png while retaining resolution. Attempted pasting in word as an enhanced meta file then ...