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.
27
questions
0
votes
2
answers
186
views
Open GeoPackage in spreadsheet with drag-n-drop
I would like to use GeoPackage as the default format for a project at work. The only issue is non-gis user prefer shapefile because they can drag-n-drop the .dbf in a spreadsheet and immediately use ...
- 11
2
votes
1
answer
61
views
Calculations wrong with my delimited layer
I'm really at my wit's end with using QGIS for marking data points in a delimited layer that just won't show up I need it for a grad paper. It worked previously with another data spreadsheet that I ...
- 41
1
vote
1
answer
166
views
Exporting names of "legend column" to spreadsheet (and not value) using QGIS
I want to export a layer to spreadsheet but need the name in the "legend" column (see pic).
Does anyone have a solution for this?
When I use the tool "export to spreadsheet", it's ...
- 97
2
votes
1
answer
800
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
28
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
90
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
106
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
3k
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 ...
- 23
2
votes
1
answer
438
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. ...
- 73.8k
1
vote
0
answers
51
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
76
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,357
1
vote
0
answers
52
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
58
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
156
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 ...
- 569
0
votes
0
answers
38
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
531
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 ...
- 121
5
votes
1
answer
3k
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. ...
- 163
1
vote
0
answers
58
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
924
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
138
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
55
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
171
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
2k
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 ...
- 323
1
vote
0
answers
165
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
49
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
882
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, ...
- 14.7k
2
votes
2
answers
4k
views
Can Python read value of cell in spreadsheet? [closed]
Can Python read the value of a cell in a spreadsheet?
The simplest example would be a script that ran a buffer tool on a given shapefile.
For the distance parameter, instead of just using a number ...
- 18.9k