0
votes
1answer
48 views

Help in importing excel data

I have downloaded the hourly solar radiation data from NREL which is in CSV format but the problem is that the file does not have an exclusive column called latitude and longitude. There are 100s of ...
0
votes
0answers
19 views

export latitude and longitude from google earth to excel [duplicate]

I need to export the latitude and longitude of 300 specified sites from google earth to an excel file. I there any systematic way to do it? I really appreciate your help I have found the following ...
0
votes
1answer
236 views

QGIS: CSV point grid to polygon - not raster

I have a CSV file with various data in 1 degree wide by 0.5 degree high rectangles, for which I have the N,S,E,W, & centroid lat/longs, i.e. every bit of spatial data required. I'm trying to ...
2
votes
1answer
1k views

Import database (Excel file) into PostgreSQL [closed]

In order to import my database (excel file) into PostgreSQL, I converted the Excel file into ".csv" file. Then, I used the application: "Import Data For PostgreSQL" and I could import my database but ...
0
votes
1answer
744 views

How can I show excel file with addresses inside in Google Earth?

I have excel file with 1 column of address , city and country. I want to "import" it into Google Earth and get placemarks of the addresses (2800 POI). How can I do it ?
2
votes
2answers
176 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
2answers
1k 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
743 views

How to change data type in Excel file before creating feature class?

I am trying to import data from Excel spreadsheets where each point coordinate has a 'datetime' timestamp (e.g. "2012-06-01 14:45:32") associated to it. When I check the table properties ArcGIS 10 ...
2
votes
1answer
4k 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 ...