Coordinates vs. Lat + Long

Hello Dev list,

I’m poking around in the table looking at the GPS coordinates and found three columns, one of which doesn’t appear to be in the GUI:

latitude character varying(255),

longitude character varying(255),

coordinates text,

Is the column ‘coordinates’ a hold over from a previous version?

···

Timothy Harding

RPCV Vanuatu

Skype: hardingt@gmail.com

+1 (541) 632-6623

Hi Tim,

The “coordinates” field is the one that is used by dhis2. Those other two fields are not standard. The coordinates field is used to store also polygon data, not just coordinates for point locations.

Regards,

Jason

···

On Mar 12, 2015 7:23 AM, “Timothy Harding” hardingt@gmail.com wrote:

Hello Dev list,

I’m poking around in the table looking at the GPS coordinates and found three columns, one of which doesn’t appear to be in the GUI:

latitude character varying(255),

longitude character varying(255),

coordinates text,

Is the column ‘coordinates’ a hold over from a previous version?

Timothy Harding

RPCV Vanuatu

Skype: hardingt@gmail.com

+1 (541) 632-6623


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Thanks Jason,

Looks like ‘featuretype’ defines whether it is a polygon or a point.

Follow up Q: Is there a reason why latitude and longitude are in the demo database if they are not standard?

···

On Wed, Mar 11, 2015 at 11:50 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Tim,

The “coordinates” field is the one that is used by dhis2. Those other two fields are not standard. The coordinates field is used to store also polygon data, not just coordinates for point locations.

Regards,

Jason

On Mar 12, 2015 7:23 AM, “Timothy Harding” hardingt@gmail.com wrote:

Hello Dev list,

I’m poking around in the table looking at the GPS coordinates and found three columns, one of which doesn’t appear to be in the GUI:

latitude character varying(255),

longitude character varying(255),

coordinates text,

Is the column ‘coordinates’ a hold over from a previous version?

Timothy Harding

RPCV Vanuatu

Skype: hardingt@gmail.com

+1 (541) 632-6623


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Timothy Harding

RPCV Vanuatu

Skype: hardingt@gmail.com

+1 (541) 632-6623

Hi,

correct, those two fields are obsolete - was used earlier but removed from data model, so can safely be removed, will fix later.

regards,

Lars

···

On Thu, Mar 12, 2015 at 7:59 AM, Timothy Harding hardingt@gmail.com wrote:

Thanks Jason,

Looks like ‘featuretype’ defines whether it is a polygon or a point.

Follow up Q: Is there a reason why latitude and longitude are in the demo database if they are not standard?


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Timothy Harding

RPCV Vanuatu

Skype: hardingt@gmail.com

+1 (541) 632-6623

On Wed, Mar 11, 2015 at 11:50 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Tim,

The “coordinates” field is the one that is used by dhis2. Those other two fields are not standard. The coordinates field is used to store also polygon data, not just coordinates for point locations.

Regards,

Jason

On Mar 12, 2015 7:23 AM, “Timothy Harding” hardingt@gmail.com wrote:

Hello Dev list,

I’m poking around in the table looking at the GPS coordinates and found three columns, one of which doesn’t appear to be in the GUI:

latitude character varying(255),

longitude character varying(255),

coordinates text,

Is the column ‘coordinates’ a hold over from a previous version?

Timothy Harding

RPCV Vanuatu

Skype: hardingt@gmail.com

+1 (541) 632-6623


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp