---

fmaps.h

Go to the documentation of this file.

/* fmaps.h - fmaps main header file
 *
 * Copyright (C) 2000  Franck Martin <franck@sopac.org>
 *
 * This Program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public
 * License as published by the Free Software Foundation; either
 * version 2 of the License, or (at your option) any later version.
 *
 * This Program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Library General Public License for more details.
 *
 * You should have received a copy of the GNU General Public
 * License along with this Program; if not, write to the
 * Free Software Foundation, Inc., 59 Temple Place - Suite 330,
 * Boston, MA 02111-1307, USA.
 */

/*
 * Modified by the FMaps Team and others 2000.  See the AUTHORS
 * file for a list of people on the FMaps Team.  See the ChangeLog
 * files for a list of changes.  These files are distributed with
 * FMaps at http://FMaps.sourceforge.net/.
 */

#include <gtk/gtk.h>

#include "gtkfmaps.h"

#ifndef LIBPQ_H
#  include "libpq-fe.h"
#  define LIBPQ_H
#endif

#ifndef __FMAPS_H__
#define __FMAPS_H__

#ifdef __cpluplus
extern "C" {
#endif /* __cpluplus */


gchar   *pghost,        /* hostname of the backend server */
                        *pgport,        /* port of the backend server */
                        *pgoptions,     /* special options to start up the backend server */
                        *pgtty;         /* debugging tty for the backend server */
gchar   *dbName,        /* name of database */
      *username,            /* name of the user */
                        *password;          /* password of the user */

PGconn          *conn;            /* connection handle to the database */
PGresult        *res;           
PGnotify        *notify;


typedef enum
{
  EXPORT_ELLIPSOID = 0,
  IMPORT_ELLIPSOID = 1,
  EXPORT_DATUM = 2,
  IMPORT_DATUM = 3,
  EXPORT_PROJECTION = 4,
  IMPORT_PROJECTION = 5,
  EXPORT_MIFMID = 6,  
  IMPORT_MIFMID = 7,
  EXPORT_SHAPEFILE = 8,
  IMPORT_SHAPEFILE = 9
} FM_FileSelection_Action;

FM_FileSelection_Action fileselection_action;

/* structure to store the status of each row */
typedef struct _FM_RowStatus FM_RowStatus;

struct _FM_RowStatus
{
  gboolean expandedbefore;
  gboolean selectable;
  gboolean selected;
};

/* Widgets */
GtkWidget *dlgPreferences;
GtkWidget *Fmaps;

/* procedures */
void fmaps_init(void);
void fmaps_quit(void);

void FM_ConnectDB(void);
void FM_Create_Map_Tables(const gchar *tablename);
int FM_Create_System_Table(PGconn *conn,gchar *tablename,gchar *tablestructure);
void FM_CheckDB(PGconn *conn);
void FM_MessageBox(const char *message);
void FM_Rebuild_Clist(GtkCList *clist, gint type);
void FM_Rebuild_Directory(void);

/* Import Export Functions*/
void FM_Import_Ellipsoid(PGconn* conn,const char *name);
void FM_Export_Ellipsoid(PGconn* conn,const char *name);
void FM_Import_Datum(PGconn* conn,const char *name);
void FM_Export_Datum(PGconn* conn,const char *name);
void FM_Import_Projection(PGconn* conn,const char *name);
void FM_Export_Projection(PGconn* conn,const char *name);
void FM_Import_MIFMID(PGconn* conn,const char *name);
void FM_Import_ShapeFile(PGconn* conn,const char *name);

/* Table Window Management functions */
void FM_Display_Table(GtkWidget *tablewindow,gchar *tablename);

/* MetaData Window Management functions */
void FM_Init_MetaData(GtkWidget *metadatawindow);
void FM_Display_MetaData(GtkWidget *metadatawindow,gchar *tablename);
void FM_Save_MetaData(GtkWidget *metadatawindow);


/* Metadata ISO 15046-15 Conformance level 1
 *  Cataloguing Information Schema
 *  The standard is still in draft
 */

#define F_CATALOGUE_TABLE "CREATE TABLE f_catalogue (meta_file_id varchar(50),meta_parent_id varchar(50),title varchar(50),edition varchar(50),series varchar(50),issue_id varchar(50),refdate DATETIME,data_charset varchar(10),abstract varchar(255),purpose varchar(255),progress INT4,access_constraints varchar(255),use_constraints varchar(50),lineage_statement varchar(255),quality_narrative varchar(255),spatial_reference_code1 BOOLEAN,spatial_reference_code2 BOOLEAN,conform_level_code INT4,lang_meta_code char(2),meta_charset varchar(10),meta_date DATETIME)"

/* progress:
 * 1-completed 2-in work 3-planned 4-required 5-on-going 6-historical archive 7-obsolete
 * conform_level_code:
 * 1-Level 1 2-Level 2 3-Level 1 with extensions
 *
 * spatial_reference_code1: geographic identifiers
 * spatial_reference_code2: coordinates
 */

#define F_CATALOGUE_INITITATIVE_TABLE "CREATE TABLE f_catalogue_initiative (CID OID,init_type varchar(50),init_name varchar(50),refdate DATETIME)"

#define F_CATALOGUE_PARTY_TABLE "CREATE TABLE f_catalogue_party (CID OID,party_individual varchar(50),party_org varchar(50), party_role_code INT4,address varchar(255),city varchar(50),admin_area varchar(50),country char(2),resource_url varchar(100),email varchar(100),phone varchar(50))"

/* party_role_code:
 * 1-originator 2-publisher 3-custodian 4-principal investigator 5-content provider
 * 6-processor 7-distributor 8-point of contact 9-metadata provider
 */

#define F_CATALOGUE_EXTENTS_TABLE "CREATE TABLE f_catalogue_extents (CID OID,westbc FLOAT8,eastbc FLOAT8,northbc FLOAT8,southbc FLOAT8,geo_name varchar(50),geo_name_ref varchar(50),time_extent DATETIME,min_elev INT4,max_elev INT4)"

#define F_CATALOGUE_RESOLUTION_CODE_TABLE "CREATE TABLE f_catalogue_resolution_code (CID OID,resolution_code INT4)"

/* resolution_code:
 * 0-1:500k-smaller 3-1:15k-1:39k  6-1:500-larger 9-2-5meters     12-20-29 meters 15-100-999 meters
 * 1-1:200k-1:499k  4-1:5k-1:14999 7-<1 meter     10-6-9 meters   13-30-40 meters 16-1-9 meters
 * 2-1:40k-1:199k   5-1:25k-1:4999 8-1-2 meters   11-10-19 meters 14-50-99 meters 17->=10km
 */

#define F_CATALOGUE_LANG_DATA_CODE_TABLE "CREATE TABLE f_catalogue_lang_data_code (CID OID,lang_data_code char(2))"

#define F_CATALOGUE_THEME_CODE_TABLE "CREATE TABLE f_catalogue_theme_code (CID OID,theme_code INT4)"

/* theme_code:
 * 1-cadatral     5-geodetic control   9-soils       13-hydrologic    17-oceanographic 21-industry and energy
 * 2-cultural and 6-transportation and 10-political  14-environmental 18-modelling and 22-buildings and
 * demographic      communications        boundaries    monitoring       simulation       structures
 * 3-topography   7-radiance/imagery   11-vegetation 15-wetlands      19-facilities
 * 4-atmosphere   8-biosphere          12-cryosphere 16-land use      20-geologic    
 */
  
#define F_CATALOGUE_KEYWORD_INFO_TABLE "CREATE TABLE f_catalogue_keyword_info (CID OID,keywords varchar(50),keyword_type_code INT4,keyword_thesaurus varchar(50))"

/* keyword_type_code:
 * 1-temporal 2-theme 3-place 4-stratum 5-discipline
 */
 
#define F_CATALOGUE_SPATIAL_REP_TYPE_CODE_TABLE "CREATE TABLE f_catalogue_spatial_rep_type_code (CID OID,spatial_rep_type_code INT4)"

/* spatial_rep_type_code:
 * 1-text 2-vector 3-raster 4-image
 */
 
#define F_CATALOGUE_DISTRIB_ID_TABLE "CREATE TABLE f_catalogue_distrib_id (CID OID,distrib_id varchar(50))"

#define F_CATALOGUE_FORMAT_CODE_TABLE "CREATE TABLE f_catalogue_format_code (CID OID, format_code varchar(50))"

#define F_CATALOGUE_MEDIA_TABLE "CREATE TABLE f_catalogue_media (CID OID,media varchar(50))"

#define F_CATALOGUE_RESOURCE_URL_TABLE "CREATE TABLE f_catalogue_resource_url (CID OID,resource_url varchar(100))"


/* old metadata table creation */
#define F_DATA_TABLE "CREATE TABLE f_data (dataid SERIAL, data varchar(25),topic varchar(10),objects varchar(10),projid INT4, datumid INT4, ellipsoidid INT4);"
#define F_DATA_TABLE_FIELD "(data, topic, objects, projid, datumid, ellipsoidid)"


/* Projection table creation */

#define F_PROJ_TABLE "CREATE TABLE f_projection (projid INT4, name varchar(50),type INT4, par1 FLOAT8, par2 FLOAT8, par3 FLOAT8, par4 FLOAT8, par5 FLOAT8, par6 FLOAT8, par7 FLOAT8, par8 FLOAT8, par9 FLOAT8, par10 FLOAT8)"
#define F_DATUM_TABLE "CREATE TABLE f_datum (datumid INT4, name varchar(50), type INT4, ellipsoidid INT4, dx FLOAT8, dy FLOAT8, dz FLOAT8, ox FLOAT8, oy FLOAT8, oz FLOAT8, scale FLOAT8, pm FLOAT8)"
#define F_ELLIPSOID_TABLE "CREATE TABLE f_ellipsoid (ellipsoidid INT4, name varchar(50), a FLOAT8, f FLOAT8)"
#define F_PROJDATUM_TABLE "CREATE TABLE f_projdatum (projdatumid SERIAL, name varchar(100), projid INT4, datumid INT4, ellipsoidid INT4)"

/* The Real Thing now 
 * The geographical object table
 *
 * tid: relates to the OID in the data table
 * size: size of a point or line width
 * factor/pattern: for a line
 * pattern: for a point, a predefined 3D object
 * r,g,b,a: Color/Alpha of the object if no color array
 * t1,t2: datetime start, datetime end
 * geo: the geographic object
 * color: the color array
 * edge: the edge array to select which edge is seen or not
 */
#define F_GEO_TABLE "(tid OID, size FLOAT8, factor INT2, pattern INT4, r INT2, g INT2, b INT2, a INT2, t1 DATETIME, t2 DATETIME, geo GEOOBJ, color INT2[][], edge BOOL[])"
#define F_GEO_TABLE_FIELD "tid , size , factor , pattern , r , g , b , a , t1, t2, geo , color , edge"


#ifdef __cpluplus
}
#endif /* __cpluplus */

#endif /* __FMAPS_H__ */

---