Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to create a spreadsheet to hold data from our cemetery. I will use the spreadsheet to get the data into a PostgreSQL database. What I dont know yet is the format that the point (positional) data will be in. Is there a 'standard' format for it? Do I need one column that will hold the lat and long positional data together or do I need two columns one for the lat dat and one for the long data. If two columns is there a 'standard' for which comes first in the spreadsheet and should the positional data be at the beginning, left side of spreadsheet, or the end, right side of the spreadsheet?

Any other advice would be useful and appreciated.

share|improve this question
How sure are you about using a sheadsheet software? Have you considered collecting the data using a GIS from the beginning? PS: The order of columns does not matter at all and separate lat and lon columns are fine. – underdark Jan 5 '13 at 22:20
Hi underdark. No I hadn't considered using a GIS as you suggest. Only because I am familiar with spreadsheets and not familiar with how I would do it with QGIS/PostGis/ or PostgreSQL. It would be good for my education to do it with a GIS. Can you point me in the direction of the relevant instructions or give me some idea of the keywords to use in searches so I can find them myself please? – nigellaw Jan 6 '13 at 11:14

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.