Questions tagged [table]
A set of data elements arranged in rows and columns.
544
questions
32
votes
6
answers
32k
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 ...
24
votes
10
answers
14k
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
5
answers
19k
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 ...
11
votes
1
answer
35k
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 ...
11
votes
1
answer
18k
views
Creating 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 ...
10
votes
3
answers
17k
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 ...
10
votes
1
answer
6k
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
2
answers
6k
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 ...
7
votes
3
answers
4k
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
2
answers
5k
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 ...
7
votes
3
answers
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
1
answer
4k
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 ...
7
votes
2
answers
5k
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 ...
7
votes
2
answers
2k
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 ...
6
votes
3
answers
2k
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 ...