A set of data elements arranged in rows and columns.

learn more… | top users | synonyms

3
votes
3answers
57 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 ...
2
votes
2answers
62 views

Getting the number of records from a table in ArcGIS 10.3

How do you output the number of records in a table in ModelBuilder? I can open the table and see how many records are there but I want to tabulate the number of records available from a number of ...
1
vote
0answers
18 views

“undo” pivot table with ArcGIS ModelBuilder?

I have a table in a geodatabase with an ID and a text field for each day of a week. The text fields contains 0 or 1 for monday, 0 or 2 for tuesday, and so on. One ID can have multiple day entries, so ...
1
vote
1answer
26 views

is there a way to save a temporary file as a permanent raster layer

I am trying to build a raster table for a temporary layer i created from an image difference on ArcGIS image analysis. Is there a way to save the temporary layer from this image analysis as a ...
2
votes
0answers
32 views

Extracting Mean from Raster and Writing to Table in ArcPy?

I am simply trying to extract the mean of each raster within a geodatabase and write the value to a table. I have done this successfully with another set of rasters, but now I keep getting the ...
5
votes
2answers
89 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 ...
2
votes
1answer
49 views

Visualize tables into QGIS maps? [closed]

I'm looking for a way to show attributes as number in little tables via QGIS. For example I want to show various facilities a city has with a small table. You can see the example of what I mean in ...
0
votes
0answers
20 views

How to iterate a raster calculator with a change in the input raster and in the values calculated? Than, how to put the results in a table?

What I do without iteration is the following: Change radiance to reflectance for band 3 with raster calculator Samething as #1 on band 4 (the values in the formula are different from #1) Calculate ...
1
vote
1answer
33 views

Connect multiple 2 points with a line in ArcGIS?

I have a table in which each row has two columns representing the objectID of two different point features in the Map. There are thousands of such rows. How do I connect the each of these two points ...
0
votes
0answers
10 views

Using ArcPy to insert Excel table into ArcMap Layout View? [duplicate]

I have been using python to batch automate maps and I have been using a manually drawn table on the layout view and have been using the ArcPy text elements to replace text with the values for each ...
1
vote
1answer
68 views

Nearest Neighbour function

I'm trying to create a function which calculates the nearest neighbors under a certain length in a table s_1 an stores them in an output table. This is what I've got so far: CREATE OR REPLACE ...
1
vote
2answers
85 views

Error adding row - sequence size must match size of row

I have this table with one row timestamp_pretty 3.1.2014 9:13 timestamp 1,38874E+12 msgid 3 targetType A mmsi 205533000 lat 53.4346 long ...
1
vote
1answer
34 views

Assigning a value to a polygon cell

In ArcMap 10.3 I have a raster file with a polygon grid overlayed on it: If the pixels in the colored raster have values such as blue = 5, yellow = 1, green = 3 etc, is there a way to output a table ...
6
votes
2answers
415 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 ...
1
vote
1answer
55 views

How to make a SQL query that would sum multiple records in ArcGIS?

I've got a large file geodatabase that contains a polyline feature class of water-pipes. The feature class have many fields, but the ones that I'm interested in is that of the water-pipe's Length and ...
1
vote
0answers
37 views

Creating look up tables in QGIS that last more than one session?

It seems that when I create a Look up Table or Value Map for a shapefile or a PostgreSQL table in QGIS it saves it for one session, then when I open it again it had disappears. Can someone ...
0
votes
2answers
67 views

Complete matrix from Generate Near Table

I am trying to make a matrix with all the distances from 4000 objects to 1000 other objects. I used the Generate Near Table and deselected "find closest option only". The output is table with 4 ...
3
votes
1answer
41 views

Feature Class relate with table

I use ArcGIS 10.1 for Desktop. I have a polygon Feature Class with municipalities. In a non-geographic table, I have these same municipalities, with an additional contract information. The ...
0
votes
1answer
177 views

CartoDB json to HTML Table using Javascript or Jquery

I am trying to display the dataset inside the cartoDB as HTML table. When i give request to the postgre database by SQL API, it is returning as the format (json) below in the snapshot. I want the ...
0
votes
0answers
16 views

Viewing my local cartodb dataset as table in browser?

I am trying to visualize dataset in my local cartodb as a table in my browser, but when i tried with the following code am getting the below error var table = document.getElementById('mytable'); var ...
0
votes
1answer
38 views

Text wrapping on tables in ArcMap?

I currently have a table (not a text box) that I'd like to have overlaid on the map in layout view of ArcMap 10.3. It, unfortunately, has a long title in the column. So, when I go to put the table on ...
2
votes
1answer
40 views

QGIS table does not dynamically update after applying a filter

Using QGIS 2.10.1, if I open a table and then apply a filter using Layer Properties > General > Provider Feature Filter, the table view does not update. In other words, the initial list of records ...
0
votes
1answer
21 views

Arcmap Working out a ratio (and totaling data) using table data - ArcGIS for Desktop

I am trying to work out a ratio between two columns (each with many rows) of data. I have one column, named 'amounts' with varying numbers in them, each one is a reference for a area (A polygon, so ...
1
vote
2answers
50 views

Getting number of objects in attribute table using PyQGIS?

I have a layer and I would like to access the number of rows the attribute table has from my code. Is there a way to do that without doing it like this: Index = 0 for Feat in Layer.getFeatures(): ...
0
votes
0answers
44 views

ArcMap Complex Labeling with Python

This is going to be very general because I've been finding it hard to find a sufficient starting point (as far as code goes) for my problem... So basically, this is it: I want to Label polygon ...
1
vote
0answers
18 views

Mapping negative percentage values from *.xls table in QGIS?

Trying to map some negative percentage values in QGIS. Working with a .xls table and importing this as a vector file to QGIS, then joining the file with a shapefile. Have converted negative percent ...
3
votes
2answers
82 views

How to get all (or selected) values from a single field in a table?

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 ...
0
votes
1answer
42 views

Python Scripting Displaying Incorrect Names after Join Field

My problem is that the code is adding numbers to the field names, and this is incorrect. Problem: Field should be names VALUE_122, but after running JoinField code, it becomes VALUES_122_123. The ...
1
vote
0answers
27 views

listing existing joins in table of contents feature

I am looking for a way to use python in ArcGIS desktop to check and print out the joins that exist between tables and feature classes in my map rather than right-clicking, going to joins and relates ...
1
vote
0answers
48 views

Populate empty attribute table from constantly growing CSV in QGIS

I have a Python script running that will generate a line feature from a point depending on a degree of rotation around that point. I have a non-spatial CSV setup to get fed this rotation data from ...
1
vote
1answer
56 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 ...
1
vote
2answers
71 views

Variable Expression In ArcGIS

I am creating many models doing many tasks. Basically, the first model will join 2 tables and the steps are as follow: make table view for each table, then add join for, then it will copy the rows for ...
5
votes
2answers
308 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 ...
0
votes
1answer
44 views

Debugging ERROR 000732 Cannot create table from feature class in file geodatabase?

I am unable to create table from feature class in file geodatabase. below is the screen of shot of the tool with error message ERROR 000732
0
votes
1answer
37 views

FME - Exploding Series of Attributes to Features for Each Combination

Given a unique identifier attribute (TYPE below), there needs to be the combination for each comparison between the identifier and (n) value attributes to be written as a new feature. See the example ...
0
votes
0answers
16 views

Change dbase table alias

How can I change the alias of a dbase table without completley renaming the file? I've tried right clicking the the file, opening properties, and changing the alias, but it will not allow me to edit ...
0
votes
1answer
30 views

Mapping Ecclesiastical Parish Data

I am looking for a way to plot data relating to the number of people in a given location - the location being an ecclesiastical parish. So I need software that will allow me to import a map of ...
0
votes
0answers
23 views

Fail in searches on the joined table data

When a table is joined to a standalone table, the searches on the joined table data return a fail. Is there another way to solve this inconvenient without save the layer with joined table under a new ...
1
vote
1answer
37 views

What is the most efficient way to get the values of a previous row in a table using ArcPy? [duplicate]

I am very new to ArcGis and I would like to get a specific value of the previous row in a table. I found this question here on gis.stackexchange.com and experimented a little bit. However, I found ...
0
votes
1answer
107 views

Create FeatureDataSet in geodatabase with Arcpy from a table

I create an empty file geodatabase (gdb), and I would like to import in this gdb several feature dataset, at least 120 different dataset. I would like to import those dataset from a table like an ...
1
vote
1answer
1k views

AttributeError: 'module' object has no attribute 'TabletoNumPyArray'

I am trying to create a Python array using data from an ArcGIS attribute table. Here's the code I've written so far: import arcpy import numpy input = "c:/data/from/arcgis" arr = ...
1
vote
0answers
66 views

Surface Volume: output table given all in one column?

The model iterates through a Point Feature Class to calculate different volumes. As an output I get two different styles of tables, both in one and the same iteration. One is the actual correct output ...
2
votes
1answer
83 views

How do I add a text file to ArcMap using ArcPy?

I'm specifically referring to the output of the Compare Table (Data Management) tool, which is a comma delimited text file. When you add the text file manually, you can actually view it like any ...
1
vote
1answer
85 views

Layout misshapen when export to PDF in Arc GIS 10

I want to include an Excel table in my ArcMap Layout which is working fine as long as I won't print to PDF. If I export the map to PDF the table looks like this: There are a lot of weird characters ...
0
votes
1answer
21 views

Adding data column by column in postgreSQL database

I organize my data in different txt files and dat. files, mostly in each file there is one specific column of data. Now I want to import and combine 4 of them to create a table. Say I have one file ...
0
votes
1answer
53 views

Copy table to attribute table

I have some tables with columns that I need to join/copy to another table, in case an attribute table. I was using join but I realized that it would be a better solution to add new fields to my ...
1
vote
1answer
92 views

Georeference disabled in CartoDB synced dataset

If I upload a dataset with synced option enable then I haven't the option to do the geocoding. Is that normal? How I can geocode the addresses? If manually I can't do the geocoding how I can do ...
1
vote
0answers
18 views

A better way to do Tablular Labels (Chemboxes)

So it's been a couple years since I've looked for a new solution for this, but I recently have a newer project manager who really wants "chemboxes", basically labels/callouts with tabular data. I've ...
0
votes
0answers
12 views

Cannot Load Object - Region object type is not supported in this table. Operation canceled

I have linked an Access Database with MapInfo and created a mappable tab. However I am unable to populate the table with any regions/polygons/poly lines etc. It says "Cannot Load Object - Region ...
0
votes
0answers
89 views

import table from sql database results in empty ouput - ArcMap

I am trying to import a table to a .gdb from a SQL Server database (not spatial). I can see the table's rows and data in ArcCatalog preview. When I import, there are no errors but I get a message: ...