Not sure if you said where the lats and longs came from, but if any of your
geocodes are historical, or worked out from looking at paper maps rather
than a GPS then you should probably think about storing the Datum that was
used as the basis for the geocode. Different datums can vary by up to a few
Peter Neish | Systems Officer, Victorian Parliamentary Library
Department of Parliamentary Services
Parliament of Victoria
From: Mark Jordan <[log in to unmask]>
To: [log in to unmask]
Date: 30/06/2012 01:53 AM
Subject: Re: [CODE4LIB] Storing lat / long
Sent by: Code for Libraries <[log in to unmask]>
Thanks everybody, looks like decimal degrees is the format to go with. Our
local GIS expert came to the same conclusion. Spatial db extensions are not
an option for us at the moment; we've got to store them as strings.
----- Original Message -----
> On Jun 28, 2012, at 3:46 PM, Matthew LeVan wrote:
> > I'd think it would depend on what you plan to do with the
> > coordinates once
> > you have them stored. If you intend to do anything at all
> > complicated
> > (spatial queries, KML generation, your own custom maps, area/volume
> > calculations), you might want to consider a spatial database
> > extension (
> > http://en.wikipedia.org/wiki/Spatial_database).
> > I've used the SQLite SpatiaLite and Postgres PostGIS extensions,
> > and
> > they're fairly straightforward to setup.
> Agreed. If you're going to be searching on them (places w/in 50
> miles of (x), closest to (y)) ... spatial database extensions are
> the way to go.
> If you're just going to be returning them for display, it probably
> doesn't matter so much, but odds are someone in the future is going
> to ask about it.
> (and that being said; I store two copies of most anything coordinate
> or unit related ... one for searching that's well normalized, and
> one for display purposes ... database normalization be damned)
Parliament of Victoria .
Important Disclaimer Notice:
The information contained in this email including any attachments, may be
confidential and/or privileged. If you are not the intended recipient, please
notify the sender and delete it from your system. Any unauthorised
disclosure, copying or dissemination of all or part of this email, including
any attachments, is not permitted. This email, including any attachments, should
be dealt with in accordance with copyright and privacy legislation.
Except where otherwise stated, views expressed are those of the individual sender.