The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [table]

A set of data elements arranged in rows and columns.

Filter by
Sorted by
Tagged with
1
vote
1answer
62 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 ...
3
votes
0answers
295 views

Adding field vector layer in QGIS modeler and using it in next steps? [closed]

I am trying to create a model with QGIS to intersect a polygon layer P with a vector grid G and find the % of P for every cells of G. These are the steps to find this : create grid G with id unique ...
1
vote
1answer
353 views

Merge records with identical ID in ArcGIS Desktop?

I need to merge records with the same PIN, and populate the null fields with values if they exist. The highlighted ones in the image are what I'm talking about. This is just a test run; for the ...
2
votes
1answer
198 views

Input unsupported or doesn't exist in MakeFeatureLayer()

I have the following code below to clean up a table to ensure that phone numbers and emails are entered in correctly, and am trying to debug my code. I am new at Arcpy, so I am still trying to figure ...
2
votes
1answer
210 views

How to Split attribute tables into new records (Data Management)

(Arcgis user) I created a fgdb for inspections in the Esri Collector app. How can i create a export table of the feature that splits the fieldnames into seperated records related to fieldname Code? ...
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 ...
0
votes
1answer
5k views

Where is “Refactor Fields”

I need to change the name of a field in an attribute table. I just installed QGIS 2.18.3. I understand that I should now use "Refactor Fields" instead of Table Manager. I don't see it anywhere, ...
1
vote
1answer
54 views

SQL Spatial Table and trailing white space issues

When accessing a table from our MSSQL Server via MapInfo, none of the fields contain trailing white spaces, the same holds true when exported to CSV via MapInfo. However, when exporting the same ...
2
votes
1answer
57 views

ArcMap issue - Table text in data view area

I had the oddest of errors in ArcMap today. After zooming out after doing some union and polygon to raster operations, the system become very slow and one of the layer's table information is drawn in ...
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 ...
4
votes
1answer
655 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 ...
2
votes
1answer
155 views

Error Failed to Execute_when trying to join table and Shapefile

I am trying to join a shpfile w/ an excel document. Both the shpfile and table have the same number of rows with matching "Unique_Joiner" columns. Below is the script im running through the IDLE GUI....
1
vote
1answer
72 views

Summarizing Data in ArcGIS Desktop?

I need to summarize a set of incident data by several different stations. I have a set of five stations. The stations code emergency response using 10 incident codes, 1 being least severe and 10 being ...
3
votes
1answer
91 views

Finding '_' without treating it as a wild character

Does anyone know how to select records containing an underscore without the query treating it as a wild character? For instance, I'm trying to select records in a text field ending with '_' to ...
3
votes
1answer
224 views

Copy and paste a non-spatial record in the same table (make a duplicate a record)

How can I duplicate (copy/paste) a non-spatial record into the same table in ArcMap? I can copy and paste to/from spatial tables, but there doesn't seem to be a way to do this in the attribute table ...
0
votes
1answer
6k views

Can't add a new field to an attribute table

I haven't been able to find a question that matches my situation. I have a .csv file that I made, and I loaded it into arc to join it to another layer. Due to another issue for another question, I ...
2
votes
1answer
285 views

How to retrieve data from a related table by using ArcGIS JavaScript API 4.1?

I have a feature layer and a related table. I want retrieve information from the related table and show them. Which API is referenced when using ArcGIS JavaScript API 4.1.?
1
vote
1answer
365 views

ArcGIS Python TableSelect_analysis ERROR 000210: Cannot create output

I have a very strange issue: I try to execute the following script which uses TableSelect_analysis and construct as outputs the corresponding tables from another table depending on a specific ...
1
vote
1answer
98 views

Combine / Group - ArcGIS attributes table [closed]

I need to group several rows in a single one, combining data cell (mainly “text”) in Arcgis desktop 10.2.2. One cell could have several records separated by comma. I have attached a screenshot in ...
4
votes
2answers
741 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) ...
1
vote
0answers
301 views

ST_Instersects and Join result to new table

I am having two tables, table1 and table2. I want to know which parts of table2 intersect with table1. Having that information, I want to write the attributes from table2 into table1 (where they ...
2
votes
0answers
152 views

Split line into the different lengths from attribute table data

Is it possible in QGIS to split one line in one direction into multiple segments of varying length which I have in the attribute table? For example: overall line is 10 m long, in table I have data: 1....
2
votes
1answer
138 views

How to set my ESPG to geography POINT in PostGIS?

I'm trying to create a table into my PostGIS 2.3 CREATE TABLE destinations ( id serial PRIMARY KEY, sector integer REFERENCES sectors(id)...
4
votes
2answers
801 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, ...
0
votes
1answer
107 views

PostgreSQL table corrupt not display in QGIS

I have a problem with a PostgreSQL table. It is the result of a query that joins 77 tables with 4 columns (geom, inicio, fuente, temporada). I used ST_SRID and ST_Transform because I could not join ...
0
votes
1answer
32 views

Mean values from multiple tables [closed]

I have 15 years of monthly air pollution values in multiple monthly tables I interpolated and then summarized by table for each census division in ArcGIS. I want to summarize the mean monthly values ...
0
votes
1answer
183 views

Is there a way to add an attribute table to a qgis2web export?

I use qgis2web for mapping building type in some area then publish it on web, so it needs a list (or table) to show on web that only a few building (not all building in that area) that I used. Is ...
1
vote
1answer
720 views

Creating ArcGIS report with multiple related tables?

Is there a way to create a report in ArcGIS 10.3 that includes data from multiple related tables in a file geodatabase? I'll give an example using soil profile data. I have a point feature class ...
4
votes
2answers
876 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 ...
-1
votes
1answer
413 views

ArcGIS Online Nonspatial Data [closed]

How is nonspatial data managed in ArcGIS Online? If I have a table that is not part of a join or relate, but standalone, can I edit it on a map? In collector? Through REST? It appears the only way to ...
2
votes
1answer
157 views

Create Replica using arcpy

I am creating a Replica from an ArcSDE database using python/arcpy (CreateReplica_management (in_data, in_type, out_geodatabase, out_name, {access_type}, {initial_data_sender}, {...
0
votes
0answers
23 views

How to update spatial point locations in ArcGIS [duplicate]

In ArcGIS, is there a way to quickly reflect changes made to XY coordinate values in my table? In edit mode I can change the values in my X and Y columns but I'm not able to refresh the map. ...
0
votes
1answer
3k views

ArcMap won't let me add fields to a table?

For some reason, my ArcMap will not let me add a field in my tables, regardless of the table. Further, the "Add field" option is grayed out. In ArcCatalog, no extra field is available to be typed in. ...
0
votes
1answer
259 views

Append New Records

I would like to append records from a view to a table to serve as a log. I tried using the ArcGIS Append tool but it creates duplicate records. Is there a way to append only those records from the ...
1
vote
1answer
90 views

ModelBuilder Iteration - Don't want to re-iterate through certain processes?

I can't seem to figure out how to not re-iterate through the beginning part of my model whereby I import a table from excel into a dbf and join it to the feature classes being iterated. I am copying ...
1
vote
1answer
223 views

Filling blanks (missing values) in table with value above using ArcGIS Field Calculator?

I'm using ArcMap to tidy up some field collected point data. The point data is a sequential track from a handheld device. In the attribute table i have a field with differant activities that separate ...
1
vote
2answers
147 views

Delete Table Rows Based On Two Field Values

How can I delete a row in a table if value A from Field 1 does not match value B from Field 4 ? I attempted to use code from a previous post as I figured it would be a start but didn't work. ...
3
votes
1answer
1k views

Renaming columns in attribute table of joined data - integer data

Using QGIS 2.14.4 (Essen). I am trying to join an excel for data about species surveys which were conducted at different locations, by blocks of area which is a separate shapefile I have already. I am ...
0
votes
1answer
492 views

How to link spatial and non spatial table in geoserver

I have a vector data published in GeoServer. I have other two non-spatial table which can be linked to the vector by a common field name. Now I would like to know how this can be done using GeoServer?...
0
votes
1answer
211 views

Using ogr2ogr to Export from Access to CSV (or Oracle)

I received a an Access database too many observations to simply export as a CSV by either the export buttons in Access or copying and pasting. I tried using ogr2ogr and only get the headers in my "...
3
votes
1answer
148 views

Not able to use “Save” button in QGIS's Table Manager

I'm getting a message that says "Failed backing up the old table to..." when I use the "Save" button Table Manager after deleteting fields from a shapefile. It says I should use "Save As..." instead, ...
1
vote
1answer
455 views

Create a table that is not registered with the geodatabase

I am doing some testing that requires having a Oracle table that is not registered with the geodatabase. For instance, Adding an Incrementing ID Field can only be performed on a table that is not ...
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 ...
0
votes
1answer
88 views

Calculate Raster with value from table

I would like to multiply all the values within a raster layer with one value, which is written in an *.csv table (it is the only value in this table). I tried this code (changing Times tool to Minus ...
1
vote
1answer
229 views

Arcpy.da.SearchCursor() help when attribute doesn't exist

I'm updating text elements off of an arcpy.da.SearchCursor script and needed to construct the script to return a response for when the attribute does NOT exist. Here is the snippet of the code THAT ...
2
votes
2answers
139 views

Why does deleting columns in the QGIS attribute table take longer than in ArcGIS?

In QGis, I recognised that deleting columns takes quite a while - is there a faster way than doing it in the attribute table (in editing mode?). I am speaking about a table with ~ 300 000 lines... ...
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 ...
0
votes
1answer
591 views

Finding field with maximum value and field name using ArcPy cursor?

I was wondering if an equivalent of summary statistics exists for finding such statistics across fields rather than records in a table. For example, of several fields, I wanted to find which one has ...
1
vote
1answer
51 views

Files resulting in dBASE table and projection file but not shapefile?

Received data from an agency I'm working with. The documentation they included said what they're sending me is a Shapefile. When I go into ArcCatalog all that appears is a dbase table and project file....