Questions tagged [table]

A set of data elements arranged in rows and columns.

Filter by
Sorted by
Tagged with
1
vote
1answer
290 views

raster info as table in R

I want to display the information of a raster layer as a table or data frame in R. In particular, I am most interested in the raster name and resolution. I want the information which shows by just ...
-1
votes
1answer
362 views

arcpy.CopyFeatures_management() gives ERROR 000732?

I'm using ArcGIS Desktop 10.2.2. I have a feature class in a geodatabase that from time to time I want to update with new data in an excel table. I wrote the following script to convert an excel ...
1
vote
1answer
226 views

Sum Values for multiple unique field values

I am trying to modify an existing table that I can relate to a feature in Arcmap(v10.5). Currently, the table fields and values look like this: I would like to summarize the table. For each unique "...
4
votes
0answers
185 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 ...
-1
votes
1answer
100 views

How can I combine multiple personal geodatabase with same format in Access file? [closed]

I have multiple geodatabases with the same format in features and attribute tables, their difference is thier location, how I can combine them in one file in Access format which has one attribute ...
1
vote
1answer
3k views

creating a view of multiple tables using Postgresql

This might be the stupidest question for postgresql user. Please do understand that i just started to use postgresql. what i am trying to do is joining 3 tables using same key field (which is ...
0
votes
2answers
72 views

Listing table as ArcPy AddMessage?

I have a script that shows certain features that are within a user-set distance of a point. I would like, however, to have those features that are "in the buffer zone" to be listed at the end when the ...
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:\...
0
votes
1answer
70 views

Joining a queried table to a feature class

I have a table in a geodatabase that I would like to join to a feature class. The table contains well locations with multiple sample dates and associated data, however, I am only interested in sample ...
1
vote
2answers
218 views

Uploading table (shape) to asset using Google Earth Engine? [closed]

I am trying to upload a table (shape) to my assets and it has been uploading for 7 days. Is it normal? I do not understand why spends so many time.
0
votes
0answers
464 views

Uploading Table in Google Earth Engine?

I am trying to upload a table (shape) in Google Earth Engine. I have never had problems when I tried to upload a table but this time I am having the next problem: Error: Encountered 1 bad features ...
0
votes
2answers
425 views

Merging Rows in Table using ArcGIS Desktop?

I am fairly new to GIS and I am using ArcGIS Desktop 10.4. The wildlife monitoring company I work for uses camera pods to sample fisheries population and uses side scan sonar to collect habitat data. ...
2
votes
2answers
445 views

PyQgis open vector layer attribute table

Is there a Qgs dialog or widget that I can use in a standalone pyqgis application to open the attribute table of a QgsVectorLayer? this seems to be such a simple thing, there has to be an existing ...
2
votes
1answer
1k views

Copy/Paste attribute table qgis without the wkt_geom column?

Is there a way to copy the attribute table on qgis and paste it on excel without the wkt_geom column?
0
votes
0answers
47 views

Listing all tables with no geometry using Oracle DB and ArcMap

I imported all my data (including attribute tables without geometry) to Oracle Database (default db : SYSTEM) I connected it to QGIS and ArcMap. I need tables that starts with RDF*. it shows in QGIS ...
0
votes
2answers
3k views

Limit the number of rows allowed in a table in PostgreSQL [closed]

I would like to set a maximum number of rows on a PostgreSQL table. I want users to be able to delete and recreate rows if need be; but there should never be more than x rows in my table. Is there a ...
0
votes
1answer
761 views

The table was not found. Reclassify Arcpy

I am new to Python and trying to determine what is wrong with the following code: -- error message -- arcgisscripting.ExecuteError: ERROR 999999: Error executing function. The table was not ...
2
votes
1answer
133 views

Debugging ModelBuilder Error 999999?

I have to build a model for my class midterm which requires us to take a .csv file and convert it to a table, then take the table and create an XY event layer which will be used to create a new ...
0
votes
1answer
96 views

Adding table of certain attributes to map layout?

I am using ArcMap 10.2 and I'm looking for a way to add a table containing certain fields from select elements from a featureclass to my map. Ive tried the add table option from the attribute table, ...
3
votes
1answer
340 views

Using the field calculator in SAGA-GIS

I am working with SAGA-GIS and need to create an euclidean allocation raster. For this, I need to first create an integer raster with values for certain areas. This integer raster shall be based on a ...
3
votes
1answer
229 views

Table with groupings and sums in print composer?

Assuming I have a basic shapefile with the following columns: name, use, acres I would like to generate a more visually appealing dynamic table in layout view: Use      ...
2
votes
2answers
60 views

Finding out what geographies ACS 2015 5 year variables are reported at for use with Census API?

I'm trying to query the US Census 2015 5 year ACS API for certain variables at the block group level, but unfortunately not all variables/tables are reported at the block group level. How can I ...
2
votes
1answer
641 views

Table Join Resulting in NULL

I'm trying to join a field named "Area" belonging to the shapefile 'Ancient Woodland' with the shapefile 'Net Development Area' (see screenshots below). The results only return 'NULL' which I don't ...
0
votes
1answer
84 views

How do I get Table from Vector layers for use with joinattributestable

I am attempting to run: processing.runandload('qgis:joinattributestable', layer1, layer2, 'id', 'id', None) To join my tables and output to a temporary viewing layer. layer1 and layer2 are both ...
2
votes
1answer
157 views

What is the proper syntax to use for the TableSelect_analysis to deselect everything?

I can use the code: for lyr in arcpy.mapping.ListLayers(dataframe): arcpy.SelectLayerByAttribute_management(lyr, "CLEAR_SELECTION") to deselect features in each layer in my map. However, the ...
1
vote
2answers
22 views

Long Field Name in ArcGIS Online Hosted Table Strips Data

I've encountered an issue when uploading a CSV to ArcGIS Online as a hosted table where if the field name exceeds X number of characters (I have not discovered this number yet), all data in that field ...
1
vote
1answer
855 views

Why does QGIS recognize the geometry type of some MSSQL tables and not others?

In QGIS, when I go to add a MSSQL table, it recognizes the geometry type and SRID of some tables and not others. When it doesn't recognize these I can set them manually and load the data without a ...
0
votes
1answer
76 views

Why is the 'Shape' field not removed from list using del built in function?

I am preparing a table from a polygon feature class in order to write a CSV file. Therefore I want to remove certain fields from the table, as they are not needed in the final CSV product. I first ...
1
vote
0answers
355 views

Using ArcGIS JavaScript API feature table using bootstrap wrappers

I am trying to create a feature table following this sample. https://developers.arcgis.com/javascript/3/jssamples/featuretable.html This sample uses the data-dojo-type="dijit/layout/BorderContainer ...
0
votes
1answer
326 views

Arcpy.AddJoin error

I am trying to populate a table by joining an excel sheet to a featureclass and using field calculator to populate the fields, but I am getting errors for the arcpy.addjoin_management. import arcpy ...
0
votes
2answers
1k views

Create a table from GeoJSON Data from Ajax link - Using Leaflet Javascript

I have an ajax link getting data from GeoServer. When a user selects features on a map, a new bounding box is calculate and sent via Ajax to GeoServer and the features within that bounding box are ...
2
votes
1answer
61 views

Displaying attribute tables with merged cells in ArcGIS Desktop?

I am new to ArcGIS Desktop 10.1. I would like to display a table providing information about the Region, Province and district in the layout view of ArcMap. For example, this is my attribute table: ...
1
vote
1answer
268 views

Find records with highest value based on unique ID

I'm trying to find a way to return all records that have the highest value in a field for each set of unique IDs. The attached table shows what I'm trying to achieve. The highlighted records would be ...
2
votes
2answers
581 views

Selecting points within buffer using PostGIS?

I have approx 73,000 locations. For each location, I need to know which of the other locations is within a 1km radius from it. I would like this result to be in a table (so perhaps using a PostGIS ...
1
vote
1answer
100 views

Convert PostGIS raster table into DTED2

I've the following table in PostGIS -- Table: public.elevation_data -- DROP TABLE public.elevation_data; CREATE TABLE public.elevation_data ( rid integer NOT NULL DEFAULT nextval('...
0
votes
1answer
148 views

Want to insert a new field to CSV with filename as attribute [closed]

I have thousands of CSV files with the approximately the following structure: csv_20160601T004301Z: name,x,y, name1,23,66 name2,23,67 csv_20160601T005001Z: name,x,y, name1,23,66 name2,23,67 etc. ...
6
votes
2answers
414 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 ...
2
votes
1answer
666 views

Empty fields after joining attributes by location to join point to polygon layer

I'm trying to join a point layer to a polygon layer to get a specific field in the attribute table into the polygon layer. I want the polygon layer "Zone" to have the field "Improved" from the point ...
0
votes
0answers
23 views

Updating table with arcpy make terminal hangs

I am using this simple code to update a table on ArcMap: # Setup tableName = 'myTable' tableInput = tableName +'.dbf' fldName = 'myField' # Updating tableUpdate = arcpy.UpdateCursor(tableName) i = 0 ...
3
votes
1answer
61 views

Using categorized and graduated visualizations with narrow table

I'm working with county data in a narrow table format with a WKT column. To simplify, if the headers are id, geo_level, metric, metric_unit, and metric_value, some entries for the county with id 5 are:...
2
votes
1answer
250 views

Split millions of points in shp with 100'000 points each [closed]

I havie over 8 million points in a shapefile. Now I would like to split these 8 mio points into parts of 100'000 points each, in order to facilitate further calculations with these points. In the end ...
1
vote
1answer
340 views

Dynamic updating of Events Layers created from XY Data in ArcGIS Desktop?

Are Events layers created from displaying XY Data in a table, updated dynamically when the table is updated? I have an Access db table that I am dumping data into, and I created an Events layer from ...
2
votes
1answer
150 views

Select all fields from table and use with arcpy.DeleteIdentical_management()?

I would like to use arcpy.DeleteIdentical_management() function without having to specify all fields in the table. Is there a keyword used to select all field in a table? I tried "*" or "ALL" but ...
1
vote
0answers
16 views

Passing table from model to script in same model [duplicate]

In my case, i have a model, that produce 2 Tables (zonal statistis). I have a script that should work with that tables. How do I pass these tables to a Script? my script takes certain fields in these ...
1
vote
1answer
365 views

Get a specific value from a table with using a few conditions in Python

I have a table that each different values in the table is the result of a combination of different conditions. For example in the below image the condition is as follow: if coverType=fallow , ...
3
votes
1answer
199 views

Previewing table in ArcGIS Pro without adding to map?

In ArcMap I often preview a table by using the Catalog window to right-click it, which opens the Item Description window and enables me to go to the Preview tab. Is there an equivalent workflow (i.e. ...
1
vote
0answers
24 views

Edit a not geometric table via a flow WFS

I want to know if it is possible to modify a non-geometric table via a flow WFS in QGIS. I have a flow WFS in QGIS with a layer connected to a table on which we can add several recordings (relation 1-...
1
vote
0answers
170 views

Table to Excel creating sheet name with special characters 10.3

I have been searching through forums to solve this issue with no luck. I work for a housing finance agency specializing in affordable housing. When we receive applications, we send letters to ...
1
vote
1answer
60 views

Assigning non-geographic data to table in MapInfo?

I'm trying to update a non-georeferenced table (Table A) to make it georeferenced/mappable. I'm trying to do this using a common set of data also found in a georeferenced table (Table B). So both ...
1
vote
0answers
61 views

Link multiple value from table to point shapefile [duplicate]

In QGis 2.18 is there a way to link (like join) a table with multiple value for each ID CODE with a Point shapefile with only 1 point for each ID CODE?? (picture in annex) It would be fine also a ...