Geographic Information Systems

Questions tagged [spreadsheet]

Ask Question

working sheet from a spreadsheet program like OpenOffice Calc or MS Excel. GIS layers are meant to be directly created from spreadsheets containing addresses or coordinates using some special mechanisms.

18 questions
Newest
Active
Bountied
Unanswered
Filter by
Sorted by
Tagged with
1
vote
1answer
32 views

Create points along a line from spreadsheet data in QGIS

I have a sewer network comprising: Manholes - a points layer Pipes - a polyline layer, with attributes comprising the upstream and downstream manhole I have a spreadsheet of pipe defects (from a ...
0
votes
0answers
16 views

Populating excel sheet with numerical output of Get Count using ModelBuilder?

Working on ArcGIS desktop 10.7 (very much still learning). I'm trying to create a model that will count objects from several layers based on the setting of a specific category, then from that ...
1
vote
0answers
29 views

QGIS - How to add joined values table data to shapefile

For some reason I lost my previous question here but I proceeded a little bit after upgrading to the newer version of QGIS. My problem was combining spreadsheet .csv data to the .shp map layer, where ...
0
votes
0answers
28 views

Getting duplicate values when joining .csv spreadsheet to .shp map layer using QGIS?

I need to join .csv/spreadsheet data to the .shp map layer. The join itself isn't a problem with same join & target values (building) but some data goes missing because of duplicate values. For ...
2
votes
0answers
77 views

How do I work with Excel and QGIS so that Excel formulas are intact when data is edited in QGIS?

I work a lot with Excel spreadsheets that are linked across multiple tabs and files. In this case, I have a sheet with coordinates and a whole lot of other data fields which needs to be imported into ...
0
votes
1answer
69 views

Get current travel times for a list of destinations from Google Maps into a Sheet

I have a list of coordinates in Google Sheets (around 20). I'd like to input a location and receive current travel times to each coordinate, for the different transport modes. Is this possible from ...
0
votes
0answers
30 views

Getting spreadsheets to autopopulate tables?

I am working on the Arcgis local government solutions Election Results web app and hosting it out to arcgis online organization. After looking at the spreadsheets, the tables and related feature ...
-1
votes
1answer
159 views

Importing and synching polygons from a Google Spreadsheet into Carto - can it be done?

I have used Google Spreadsheets as a way to provide our large organisation a way to update carto maps with new locations without needing to consistently contact the web/GIS teams but only with ...
3
votes
1answer
601 views

Removing and deleting duplicates in FME?

I'm analysing a large folder containing huge amounts of data, using FME. I'm filtering it down as much as possible, and I'm a little stuck at this part. Right now it is just about creating lists. ...
1
vote
0answers
42 views

Referencing an external editable CSV file in a spatialite base

I would like to join a CSV file attributes to multiple spatialite layers, but I would like to be able to edit the csv externally (export it from a different project on Excel or Numbers every time I ...
1
vote
2answers
480 views

QGIS / Spatialite / DB Browser : basic : joining tables and more

Question : Is it possible to create a table in QGIS that will be a dynamic reference for geographical data entries? As I'm sure this will sound very general and unclear, here's the actual situation I ...
1
vote
1answer
53 views

Error Opening File?

I have searched the internet for a few hours now and have gotten to the point where I need to ask this. I am currently developing a code that will take a large subdirectory of .xlsx files, read them ...
0
votes
0answers
39 views

ArcGIS 10.3 connecting to spreadsheets

I have feature classes of property parcels that are polygons. My client maintains data about the parcels in a google doc spreadsheet (online) and updates the information regularly. I am required to ...
2
votes
3answers
65 views

Getting Spreadsheet Data of Points from PNG using ArcMap?

I'm rather new to using ArcMap. For my research project, I have a layer of point data. I have been downloading datasets and layers of aggregated annual precipitation across the United States. All I ...
1
vote
1answer
752 views

Linking Google sheet as a database for GIS [closed]

I’m working on a database update, at the moment this database is simply an excel spreadsheet not formatted to be used in a GIS project. The database has to be updated and modified over time. Some ...
1
vote
0answers
110 views

In QGIS import/update multiple layers from single spreadsheet

I have a spreadsheet I regularly update with new data. It contains X, Y and several column pairs. How does one assign in one operation information from the pairs (and associated X,Y) to their ...
2
votes
1answer
28 views

Sheetsee optionsJSON problem

I am doing some basic work with G Sheets and Sheetsee.js library. I have it working as far as I get my coordinates showing up on a map. I'm using the demo-map file as my starter, I just changed the ...
2
votes
1answer
595 views

QGIS create layer from spreadsheet file (Spreadsheet Layer plugin)

With the QGIS plugin 'Speadsheet Layers' i try to create a layer with the following parameters: But I'm just getting a layer with no geometry. I've been playing arround with real instead of integers, ...