Re: Issue 2 in calipso: geodata information model

[cal...@googlecode.com]

Updates:
Status: Started

Comment #2 on issue 2 by ma...@abiss.gr: geodata information model
http://code.google.com/p/calipso/issues/detail?id=2

also adding altitude to follow WGS84, will add this to our model.

CREATE TABLE IF NOT EXISTS `location_point` ( -- location point geographic
information, as defined in the W3C Geo Vocabularies.
`id` bigint(20) unsigned NOT NULL auto_increment, -- field description
`location_name` varchar(255) default NULL, -- field description
`country_id` int(11) default NULL, -- field description
`altitude` DOUBLE NOT NULL default '0', -- The WGS84 Altitude of the
Point
`latitude` DOUBLE NOT NULL default '0', -- The WGS84 Latitude of the
Point
`longitude` DOUBLE NOT NULL default '0', -- The WGS84 Longitude of the
Point
PRIMARY KEY (`id`)
)