All Questions
23
questions
3
votes
1
answer
181
views
How do I complete an existing attribute table with .CSV or .XLSX
I have an existing vector layer (points) I was working on some time ago. The layer represents boreholes in the area of my interest (over 250 points).
Some time ago we got access to a number of ...
3
votes
2
answers
658
views
Select JSON records as an Excel table
I have an internal map service that serves up GIS records via JSON objects.
For the purpose of this question, instead of using my internal/private
data, we can use the JSON data on ESRI's public ...
0
votes
1
answer
124
views
Summarizing individual data in table using ArcGIS Pro
I am attempting to summarize a a bunch of individual rows in a table I added into ArcGIS Pro, and I'm wondering if there is any type of tool or work flow I could use to do so?
This is kind of a ...
2
votes
2
answers
822
views
Decimals are in wrong place in latitude and longitude in Excel
Somebody gave me an Excel table and the latitude and longitude had the wrong place for decimals. Is there a workaround to fix the problem? I am pretty much stuck trying to figure it out. Here is the ...
2
votes
0
answers
664
views
Filter on joined tables in QGIS
QGIS 3.2.3: I have a shapefile and an Excel table which is joined to the shapefile based on matching IDs.
I would like to filter the shapefile while using a joined field from the Excel table.
When I ...
0
votes
2
answers
110
views
Exporting to Excel gives ERROR 000732?
I have a script that buffers a selected point, and intersects that buffer with features that the user inputs. I would like to convert the table outputted from the Intersect process into a excel file. ...
4
votes
2
answers
2k
views
Using vlookup function in ArcMap?
I am trying to automate a field calculation using ModelBuilder, using a GDB table to populate a feature class field given two conditions:
Traffic Count Value and
Posted Speed limit
I have created ...
3
votes
1
answer
3k
views
Copy/Paste attribute table qgis without the wkt_geom column?
Is there a way to copy the attribute table on qgis and paste it on excel without the wkt_geom column?
1
vote
0
answers
246
views
Table to Excel creating sheet name with special characters 10.3
I have been searching through forums to solve this issue with no luck. I work for a housing finance agency specializing in affordable housing. When we receive applications, we send letters to ...
4
votes
3
answers
7k
views
Adding excel table to QGIS print composer?
Can anyone suggest some ideas to add a excel table to the print composer which will then be exported as a A3 png while retaining resolution. Attempted pasting in word as an enhanced meta file then ...
1
vote
2
answers
813
views
How can I display my Excel file in Arcmap 10.4?
I am currently working on a project. I have created an excel spreadsheet:
So, I need to attach the spreadsheet into ArcMap 10.4 and show the states population percentage. I have already created a ...
1
vote
1
answer
135
views
Is *.xls MS Excel default format in ArcMap?
Is it always necessary that whenever we want to show our data kept in Excel spreadsheets in ArcMap, that it must be in .xls? Is .xls a default format for ArcMap?
7
votes
2
answers
5k
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 ...
1
vote
1
answer
580
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 ...
1
vote
1
answer
409
views
With Modelbuilder, how to iterate field value so final output table is empty if input is empty?
I have created a model which will output two Excel tables (the green circles at the end) per state. I am using "Iterate Field Values" to go through each state to create the tables. While this gives me ...