A spreadsheet application by Microsoft
1
vote
1answer
32 views
QGis creating shape file of several points out of two Excel sheets
I am about to create a Qgis file on which it should be visible which companies are working together. As source I have got two Excel Tables.
Table = Distribution Centers
Table = Point of sales
I ...
1
vote
1answer
46 views
Software program (or spreadsheet calculations) to find Borehole Deviation?
I was given a bunch of surveyed borehole data (azimuth, depth, dip, geology, etc) and am required to calculate a deviation variable. Besides querying the data and averaging the surveyed borehole ...
1
vote
2answers
67 views
Help excel table not transferring to Arc correctly!
New to GIS and Ive been trying to figure this out for a while. I have an excel sheet with CT names such as 0128.03, 0128.04, starting from 0001.00 and up. Not all CTs have .01, .02 at the end just ...
1
vote
4answers
117 views
Get pixel value from a raster in a xy table
I'm trying to find a way to convert a raster (in my case it's a Landsat satellite image) into a table with 3 columns which would represent: 1) x coordinates (the so called "xllcorners" in ASCII ...
4
votes
1answer
70 views
Using matplotlib to create and export graphs automatically from ArcMap
I am going to start a project soon where, after the data has been processed in various ways, an output jpg showing a graph of the data should be produced. The workflow is as follows:
1. A feature ...
0
votes
0answers
14 views
EM (electromagnetic) map to AWC (available water holding capacity) map
How do you use an equation from a regression analysis from Microsoft Excel to create a new available water holding capacity (AWC) map from an electromagnetic (EM) map. They are both to be in raster ...
1
vote
0answers
81 views
How to embed a PDF into an Excel spreadsheet? [closed]
This is what I want to do:
Create report using a polygon feature class to output areas of polygons using some logic and the ExportReport() function (This I have accomplished)
Create a PDF of the ...
3
votes
1answer
67 views
How to import or incorporate formated Excel tab into QGIS print composer
I would like to know if there's a way to import formated Excel Tab into QGIS print composer.
Below is an attachment of formatted Excel tab example I has been asked to display on qgis map composer.
...
1
vote
1answer
45 views
Tables within the Reclassify tool- what is it, where is it?
ArcMap 10.1 here. I have a raster set I'm looking to reclassify. The field I need to re-classify is currently a string of words like "Thing 1" and "Thing 2" and I'm going to set them to be 1 and 2.
I ...
2
votes
1answer
148 views
Joining Excel with arcmap by model builder
I am trying to use the model builder tool in ArcMap 10.
I would like to join an Excel file (xls) with a shp.file.
The Excel file and the shapefile have one identical column with data but the ...
0
votes
0answers
22 views
Exporting QGIS attribute table to excel [duplicate]
I have a million rows in the attribute table, with lat/lon columns that I want to export to Excel. Selecting all the rows causes QGIS to crash. Is there another way to do the export?
The million rows ...
-4
votes
2answers
154 views
Problem in converting X,Y data from Excel to Shape file
I have X,Y data in Excel in decimal degree format. I'm applying my standard procees to convert them into shape file. My problem is the file is converting but in the resultant shape file either ...
0
votes
1answer
49 views
ArcGIS Statistics tool problem
I have an excel file for average rainfall by month and I added that on ArcMap. while I tried to check the statistics the tool is passive for last 3 months and I checked the data on arcmap, they are ...
0
votes
1answer
69 views
Convert large amount of County names to FIPS in excel file?
Is their a way (other than manual) to convert a large data set with county names to their respective FIPS code?
2
votes
2answers
318 views
Is there a way to populate a spreadsheet of city names with their latitudes and longitudes from Google Maps or some other service?
I have a long list of cities in the United States, and would like to get the coordinates for each city without looking up each one individually. Is there a way to do this?
1
vote
2answers
47 views
Seek assistance with: SQL Server 2008 Query that takes values from a column in another table (or from a flat file)
I am given a list in MS Excel of 554 statistical units (called Primary Sampling Units or PSUs) from another department and have to query all 554 PSUs from a SQL Server 2008 Spatial database table ...
3
votes
2answers
150 views
Why do I lose data after converting from .xlsx to .shp?
I have a fairly large excel file that I need to convert to a shapefile, but everytime I export the data, I lose a bunch of it. The excel file has about 277,000 records, but the shapefile will only ...
0
votes
0answers
53 views
Adding a new attribute to shapefile from Excel sheet [duplicate]
I have a shapefile in QGIS and I needed to add a attribute to the attribute table. The problem is that I have the information I need to add in an Excel file. How can I add the information from the ...
4
votes
1answer
313 views
What is the best way to connect spatial data with attributes in Excel table?
I have many attributes which are stored in an Excel table. They refer to USA counties. I need to somehow connect those attributes to polygons in some format (don't know which is the best) and ...
8
votes
3answers
776 views
How to import coordinate data from excel into QGIS?
I have an excel file containing data collected over many years as latitude and longitude coordinates for archaeological sites - how can I import it into QGIS as a new layer?
5
votes
3answers
674 views
Table to table script using Excel sheets (not workbooks) arcpy
So what I'm trying to do is to create feature classes from the sheets in an Excel table. I can get it to work if I save each excel sheet as its own workbook, however this isn't really what I want.
I ...
1
vote
1answer
145 views
How to create Feature Class based on DBF schema?
I have an attribute table schema (about 30 fields) stored in an Excel document, which I exported as a dbf. I can easily make a geodatabase table from this, using the Excel sheet as a template. How can ...
3
votes
2answers
683 views
How to edit Shapefile Attributes?
How might I go about exporting a polygon shapefile (e.g. CSV) so that attributes (not geometry) are editable by others, and importing it with the changed attributes (of which there are several columns ...
0
votes
1answer
268 views
How to layer statistics from Excel onto a map?
Would another free app or program be better and easier to do this than mapbox.com ?
I simply want to layer census 2010 data by shading areas onto a map like on theatlanticcities.com/posts/map/ & ...
5
votes
2answers
396 views
Importing attributes from Excel file into new Polygons
I have a constantly updated Excel file containing address information which I am currently copying into the attributes of new polygons which I am creating on a daily basis. I am currently doing this ...
2
votes
2answers
127 views
Some data Loss when Import PGDB Table from Excel
When import table from excel some data were loss. i was try to change field type but i cant solve this error. I have attached an example image to show the problem.
4
votes
3answers
2k views
What is a good resource for making choropleth maps using excel data?
I would like to make a choropleth map of Malaysian regions, colour-coding them by population density.
Is there a place where I can find templates of such a map?
4
votes
2answers
645 views
Importing data with empty cells without GIS replacing the empty cell with 0
I am importing data from excel into ArcGIS 10. The data are columns of GPS data, associated date and time, and a unique point identifier. For some of the rows the GPS data is missing and so the Lat ...
3
votes
1answer
342 views
Why are the results from the same data different in ArcGIS vs MS Excel?
I have done some interpolation in Geostatistical Analyst in ArcGIS and I got the Standard Deviation (SD) a bit different from the SD that I calculated in Excel Spreadsheet.
What algorithm does each ...
1
vote
0answers
200 views
Placemark that pulls information off an excel sheet row and display's the data in the description part of the Placemark
I am trying to find out if a certain function is available to link an excel sheet with a kmz.
What i need to happen is have a Placemark that pulls information off an excel sheet row and display's the ...
3
votes
1answer
805 views
saving a dbf as xls in python
i've been let loose in the workplace to learn python to do things in Arcmap10.
so, i've learning python as i go and trying to remember the programming i have done.
where i am in this project is ...
2
votes
1answer
98 views
Plugging in population data into a map of provinces
Have shapefiles for provinces in several countries in an Asian region, but currently trying to plug in animal population data for each province with graduated symbols displayed the data. Am trying to ...
2
votes
1answer
647 views
Converting map coordinates using AutoCad to Excel sheet
I have some maps of pieces of lands and I want to convert the coordinates to excel sheet
I want to arrange the data like this in the excel sheet:
land number( the pink number in the pic) ...
1
vote
1answer
196 views
ArcPy: Creating weekly-sum layers by summing field values from seven consecutive daily .dbf's
So I have 490 consecutive daily rainfall shapefiles/.dbf files in a single directory. Each consists of a uniform even-spaced grid of 220 points having uniform pointIDs, number of records, field names ...
8
votes
3answers
6k views
How to convert .shp to .csv including attributes AND geometry?
I have a .shp file with 60k+ entries, all of which are polygons with corresponding attributes (acreage totals, landowner names, tax ID #s, etc.). What I ultimately need is a .csv file with all of ...
1
vote
1answer
1k views
How to generate shape file from Excel or CSV files? [duplicate]
Possible Duplicate:
How can I convert an excel file with x, y columns to a shapefile?
Probably this could be an easy question for most of the people. But I would like to know the way to ...
6
votes
1answer
737 views
Excel object does not display more than 19 fields in ArcMap 10
I have an A0 map. I want to put a table underneath it. I want to insert an Excel object as the table. When I do this, the size of the table is 19 fields/columns. I cannot increase this number of ...
4
votes
4answers
1k views
Using a list of geographic locations, and determining the X closest locations to a user-defined location
I've got a list of geographical locations in an Excel spreadsheet. I want users to be able to search for a user-defined location, and then have the X number of closest locations from the list pulled ...
0
votes
2answers
1k views
How to import data from excel and associate it with individual shapes?
New user on ArcMap - Working with shapefiles...
Question: the shapefile I am working on, a polygon is a plot of land, each plot of land has a history of owners. I am currently having to copy/paste ...
3
votes
4answers
521 views
update spatial data from excel to ms-sql server 2008
I have 1000's of data with 50's of column. It is point data. The data
is in MS-SQL server.Now each day I need to load 100's of data similar
in structure. How can I achieve it ? I tried to append ...
4
votes
2answers
980 views
VBA functions use in ArcGIS Field Calculator
Would this be ok to use them for the field calculator in ArcGIS 9.3 ? See here MS Excel VBA Functions
Or should I fix them in MS Excel and save as a file and then use the join with the shapefile or ...
0
votes
1answer
529 views
How to dynamically connect Excel data sources to MapInfo?
How to connect Excel(2010) with Mapinfo(10.0)? I saw that Excel can be connected using Excel as Data Source but my Data Source is already MS-SQL. Actually I would like to reflect any changes in excel ...
8
votes
2answers
221 views
How can I find the median column in a database?
I have data on period of construction for dwellings in dissemination areas. I have transferred this data to my study areas and would like to determine the median period of construction for each study ...
3
votes
7answers
8k views
Having problems with joining an excel table to a shapefile in ArcMap
I have a shapefile of lower layer super output areas (LSOA) for England and Wales and I have a spreadsheet of the indices of deprivation for each of the LSOA's in England. I want to join the ...
3
votes
1answer
138 views
Can the Reporting Tool in ArcMap connect to Auxiliary data, like Excel tables?
Is it possible in ArcMap 10, using the reporting tool, to connect a report to non-spatial data, like from Excel or Access tables?
17
votes
4answers
797 views
Run a Python Script when opening an MXD?
Can anyone tell me how to accomplish this? I want a Python script to run on opening the MXD which would pull an excel worksheet into a GDB and refresh the map. I only want this to happen in this ...
0
votes
1answer
3k views
saving .xls as .dbf…at a dead end [duplicate]
Possible Duplicate:
DBF creation and manipulation without excel 2003
Hi -
I'm trying to convert an excel file to a shapefile in arview 3.3. using suggestions by Bill Huber (on the ESRI ...
5
votes
3answers
26k views
Export table from ArcGis to Excel file
Is there a way to export a table with selected records to an Excel spreadsheet?
I was trying to export just to .txt file but ArcGIS gives me an error message.
The other problem I have is with ...
9
votes
11answers
3k views
DBF creation and manipulation without excel 2003
My company just upgraded to Office 2007 and now I am no longer able to easily manipulate and create dbf's. I do not understand MS's decision by removing this capability but alas there is no use ...
2
votes
1answer
3k views
how can i convert an excel table to a shapefile with correct scale in arcmap?
i know that there is already one similar question to this one but my problem is different and none of the provided answers did resolve my problem.
i've an excel table with some rows and in each row ...
