2
votes
0answers
44 views

Editing the QGIS Attribute Table

Is there a way to edit the name, type and length given to each column on the attribute table once the information has been imported from Excel?
0
votes
0answers
36 views

MapInfo Populating Dates in Table

I am opening an Excel spreadsheet in MapInfo. One column of the Excel spreadsheet holds a date per row. Some of the rows dont have an assigned date this is fine. When opening the table in MapInfo, ...
0
votes
1answer
83 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
326 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
2k 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
1k 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
206 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
815 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 ...