search

pgaval / calipso

Automatically exported from code.google.com/p/calipso
1 stars 0 forks source link

geodata information model #2

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
as discussed, we need to establish a rough datamodel for geomapping to add the 
appropriate customfields

Original issue reported on code.google.com by manosbat...@gmail.com on 18 Oct 2010 at 4:56

GoogleCodeExporter commented 9 years ago 
Just country, latitude and longitude as the main fields would be ok. Will add 
this as a custom field type/attribute.

CREATE TABLE IF NOT EXISTS `location` ( -- table description
    `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
    `latitude` DOUBLE NOT NULL default '0', -- field description
    `longitude` DOUBLE NOT NULL default '0', -- field description
  PRIMARY KEY (`id`)
)

Original comment by manosbat...@gmail.com on 30 Oct 2010 at 4:39

GoogleCodeExporter commented 9 years ago 
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`)
)

Original comment by manosbat...@gmail.com on 16 Nov 2010 at 2:21