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.
23
questions
2
votes
1
answer
95
views
When importing coordinate data into My Maps (Google) layer I want to set the image path to Google Drive
I have a Google Spreadsheet with coordinate data and a path to an image in a Google Drive folder, I want to import the spreadsheet into a map in My Maps and tell the importer that the column [IMAGE] ...
0
votes
0
answers
22
views
Export spreadsheet to shapefile not working
Pretty basic, but I've never had this happen. I have a spreadsheet with X/Y which I have imported into ArcMap (all fine no issues).
However when I export it to a shapefile it is blank. If I export it ...
1
vote
0
answers
45
views
Blank screen when displaying vector file from spreadsheet in QGIS
I have a spreadsheet plugin installed. The Excel spreadsheet has coordinates in Australia's national grid GDA94 zone 56 which are metric. I open the Excel file and use the geometry button and ...
- 11
1
vote
1
answer
65
views
Modifying SpreadsheetLayers Plugin
I'm trying to make a small change in this QGIS plugin (https://github.com/camptocamp/QGIS-SpreadSheetLayers), but I did not succeed.
I have an ods spreadsheet in which the coordinates can come in ...
- 11
1
vote
2
answers
468
views
Adding National Grid Reference data from spreadsheet into QGIS
I have been given some point data and loaded it against the relevant open street map. I'm looking to create a point shapefile based on the National Grid References (NGR) found within a spreadsheet.
If ...
- 25
2
votes
1
answer
207
views
Preparing data for timeline animation in QGIS
I have a data-spreadsheet containing a value-attribute that changes over time for a number of administrative units. I have a polygon layer as well with features for each of the administrative units. ...
- 41.1k
1
vote
0
answers
28
views
Adding spreadsheet information to KML
I have a KML from Indy Neighborhoods ArcGIS. I have the results of a factor analysis based on neighborhood traits from savi.org. From this, I did a clustering. I would like to combine the contents of ...
- 111
2
votes
1
answer
59
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 ...
- 1,257
1
vote
0
answers
43
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 ...
- 11
0
votes
0
answers
37
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 ...
user144785
2
votes
0
answers
115
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 ...
- 571
0
votes
0
answers
32
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
1
answer
399
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 ...
- 101
4
votes
1
answer
2k
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. ...
- 153
1
vote
0
answers
52
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 ...
- 33
2
votes
2
answers
780
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 ...
- 33
1
vote
1
answer
79
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 ...
- 41
0
votes
0
answers
47
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 ...
- 315
2
votes
3
answers
146
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 ...
- 21
2
votes
1
answer
1k
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 ...
- 303
1
vote
0
answers
139
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 ...
- 317
2
votes
1
answer
44
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 ...
- 131
2
votes
1
answer
786
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, ...
- 13.8k