Questions tagged [spreadsheet]
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
0
votes
0answers
14 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
19 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
26 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 ...
-7
votes
1answer
28 views
Spreadsheet vs Shapefile [closed]
I have the same dataset both in Shapefile and Spreadsheet.
What can be the advantages/disadvantages of using one format rather than the another?
2
votes
0answers
74 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
57 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
29 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
123 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
468 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
418 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
50 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
61 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
609 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
102 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
27 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
523 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, ...
