tubackkhoa / gbif-dataportal

Automatically exported from code.google.com/p/gbif-dataportal
0 stars 1 forks source link

Web Services: Add CSV response with certain fields for AquaMaps #101

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
Currently the only response format is XML

This is critical to AquaMaps. The crucial fields that need to be included for 
them are: 

scientific name, collection date, catalog number, lat/long coordinates, 
provider ID, altitude, and depth, see below:

desc occurrence_record;
+---------------------+-----------------------+------+-----+---------+-------+
| Field               | Type                  | Null | Key | Default | Extra |
+---------------------+-----------------------+------+-----+---------+-------+

| data_provider_id    | smallint(5) unsigned  | NO   | MUL | NULL    |       | 

| catalogue_number_id | int(10) unsigned      | NO   | MUL | NULL    |       | 
| taxon_concept_id    | int(10) unsigned      | NO   | MUL | NULL    |       | 
| taxon_name_id       | mediumint(8) unsigned | NO   | MUL | NULL    |       | 

| nub_concept_id      | int(10) unsigned      | YES  | MUL | NULL    |       | 

| latitude            | float                 | YES  |     | NULL    |       | 
| longitude           | float                 | YES  |     | NULL    |       | 

| occurrence_date     | date                  | YES  | MUL | NULL    |       | 

| altitude_metres     | smallint(6)           | YES  | MUL | NULL    |       | 
| depth_centimetres   | mediumint(8) unsigned | YES  | MUL | NULL    |       | 

There is no need to include auxiliary records like images, links, identifiers, 
and typifications. The query is quite simple on the OR table and should not 
require any joins.

Ideally this work needs to be completed before March 2011

Original issue reported on code.google.com by kyle.br...@gmail.com on 17 Jan 2011 at 11:37

GoogleCodeExporter commented 9 years ago

Original comment by kyle.br...@gmail.com on 17 Jan 2011 at 11:38