Spatial Retrievals of Appropriate Locations for Ocean Energy Utilizing Electric Power Generation Plants

Free Open Source Software: FOSS based Geographic Information System: GIS for spatial retrievals of appropriate locations for ocean wind and tidal motion utilizing electric power generation plants is proposed. Using scatterometer onboard earth observation satellites, strong wind coastal areas are retrieved with FOSS/GIS of PostgreSQL/GIS. PostGIS has to be modified together with altimeter and scatterometer database. These modification and database creation would be a good reference to the users who would like to create GIS system together with database with FOSS.


INTRODUCTION
Geographic Information System: GIS is used for exploration and spatial retrieval of appropriate locations and areas.GIS software is widely available now a day [1].GIS can be created with Free Open Source Software: FOSS [2].Functionalities of GIS is as follows, ・Display superimposing the thematic maps and imagery data ・Spatial and temporal retrieval of the maps and data ・Quantitative analysis (length, area, etc.) ・Simulation (assessment, 3D scenery analysis, etc.) There are the following issues should be discussed, ・ Difficulty on customization of the GIS to specific applications ・Expensive system and database updating cost ・Reverse retrievals for the spatial and temporal search for confirmation of the original data ・Apply image processing to the retrieved data In order to overcome the aforementioned problems of FOSS 1 based GIS, example of customization of PostgreSQL2 /GIS (PostGIS3 ) for the specific purpose of spatial retrieval of ocean energy 4 , or marine energy 5 , ocean wind and tidal motion utilizing power generation plant locations are attempted.
In order for that, retrievals of the appropriate ocean areas in the Japanese vicinity for exploration of ocean related energy sources, geoid, ocean winds, wave heights and tidal effects are required [3].The data for the aforementioned energy sources are available from satellite based radar altimeter6 and scatterometer 7 .Then exploration of possible areas for ocean related power generations is followed by [4], [5].Also, create the database containing geoid8 , tides, ocean winds, wave height and so on from the NASA/JPL PODAAC9 (Topex/Poseidon10 and Jason satellites11 data) by extracting the geo-referenced and time stamped data from the PODAAC has to be done.After that, access to the database through php12 and Mapscript13 then display the retrieval results of the appropriate ocean areas for the ocean energy exploration on the php web browser.These procedures are demonstrated in this paper.Also the GIS is used as Neural Network [6], [7].
The following section describes the proposed PostGIS followed by the data descriptions required for spatial retrievals of appropriate locations for electric power generation plants utilizing ocean energy.Then demonstration is followed by.Finally, conclusion and some discussions are followed.

A. Availability of FOSS/GIS
There are not so small numbers of FOSS/GIS systems which are available and downloadable from their web sites.Table 1 shows just a small portion of available FOSS/GIS.As for the well-known Grass of GIS, it is easy to install it on your computer through the following procedure, www.ijacsa.thesai.orgLink to Grass of GIS software Installation of GRASSLink14 s GRASSLinks is web interface for GRASS GIS of PDS installation Before using GRASSLinks, GRASS GIS has to be installed Information on Installation of GRASS is available from the http://www.media.osaka-cu.ac.jp/~raghavan/grassinfo/.As for the well-known Mapserver, it is easy to install it on your computer through the following procedure, MapServer international version (i18n) (i18n Version of Mapserver: Package) MapServer 4.0.1 source code and patch for the international use As for the well known PostgreSQL/GIS, PostGIS, it is easy to install it on your computer through the following procedure, PostGIS allows store the objects in concern to the GIS (Geographic Information Systems) database PostgtreSQL extension of PostGIS supports fundamental functions for analysis of GIS objects and spatial R-Tree index of the GiST base PostgreSQL can be downloaded from the http://www.postgresql.org/PostGIS is source code tree of the PostgreSQL and can be installed by using the definition of installation process of the PostgreSQL PostGIS can be compiled with GNU C17 , gcc and/or ANSI C18 complier GNU Make, gmake and/or make can be used for making the PostGIS.GNU make is the default version of make.Version can be confirmed with "make -v".Make file of PostGIS will not be processed properly when the different version of make is used Proj4 is the library of the map projection conversion tools as one of the options of the PostGIS.Proj4 is available from the http://www.remotesensing.org/projIn order to utilize Mapserver, the following procedure is required, Minnesota Mapserver is the internet Web mapping server and is compatible to the mapping server specification  Editing of the database can be done in accordance with PostgresSQL data manipulation as shown in Fig. 1.Fig. 2 shows example of PostgresSQL database server.

D. The Data Required for Spatial Retrievals of Appropriate Locations for Ocean Energy Utilizing Electric Power Generation Plants
There are some of required data for finding appropriate locations of ocean energy utilizing electric power generation plants.Namely, Ocean wind direction and speed can be estimated with scatterometer data.One of the scatterometers onboard satellites is SeaWinds19 on Advanced Earth Observing Satellite: ADEOS-II20 .Major specification of SeaWinds is shown in Table 3. www.ijacsa.thesai.orgAlong with satellite orbit, scatterometer observes ocean surface as shown in Fig. 5. Global coverage can be done.Then ocean wind direction and speed is estimated as shown in Fig. 6 (a), (b).From the MapServer site, Japan and its vicinity of map is downloaded.Web site is designed with php.Under the web site, there is the PostGIS with the databases of Topex/Poseidon altimeter data derived geoid and significant wave height as well as ADEOS-II scatterometer (SeaWinds) data derived wind direction and wind speed.Through web site, search conditions of ocean wind speed, significant wave height, and geoid can be input using radio button.Then search results are obtained after the input.If the search condition of wind speed (it is greater than 20 m/s) is input, then spatial retrieval result is displayed as shown in Fig. 7. Spatial retrieval result with the search condition of which geoid potential is greater than 40 m is shown in Fig. 8. Also, spatial retrieval result with the search condition of which geoid potential is greater than 40 m and wind aped is greater than 20 m/s is shown in Fig. 9.Meanwhile, Fig. 10 shows spatial retrieval result with the search conditions of which wind speed, significant wave height, geoid potential, and the distance from the nearest coastal lines.Such these spatial retrievals are specific feature of GIS.www.ijacsa.thesai.org

IV. CONCLUSION
Customization can be done smoothly.It is easy to customize the PostGIS (extension of PostgreSQL) with Mapserver through the php.Also, it is confirmed that the most of functionalities of PostGIS (Submittion of queries, retrievals of the appropriate data from the database, display the retrieved results on the php web browser).Furthermore, image processing and analysis are also available and can be applied to the retrieved data.
Because the proposed PostGIS is modified version of free open source software, everybody may download and install and modify easily.The proposed system is open to the public upon request with the condition of credibility of the name of Arai/Saga University.

Figure 1 Figure 2
Figure 1 Editing of the database can be done in accordance with PostgresSQL data manipulation

5
days average of wind speed and vector wind is shown in Fig.6 (a) while 5 days average of dynamic height 21 and winds are shown in Fig.6 (b), respectively.

Figure 5 Figure 6
Figure 5 Example of scatterometer observed ocean wind along with satellite orbit.

Figure 7
Figure 7 Spatial retrieval result with the condition of which wind speed is greater than 20 m/s

Figure 8 Figure 8
Figure 8 Spatial retrieval result with the search condition of which geoid potential is greater than 40m

Figure 9
Figure 9 Spatial retrieval result with the search conditions among wind speed, significant wave height, geoid potential, and the distance from the nearest coastal lines.

TABLE I
After that, Modification of the analysis program is required followed by extraction of the required data.Conversion of the extracted data to GIS database (database table can be created with PostgreSQL) is www.ijacsa.thesai.orgalsorequired.Table2shows example of the database in PostGIS.Database is described with table style.

TABLE II .
EXAMPLES OF DATABASE IN POSTGIS

TABLE III .
MAJOR SPECIFICATION OF SEAWINDS