Tropical Storms over the past 50 -Asia and the Pacific

A map showing 50 years historical typhoon tracks in the Asia Pacific region. I found it from this site.

Now I wonder: In the average, how many typhoons hit Bicol(Philippines) in a year? I have to google that one ;)

Web Map Rectifier

A cool new OpenLayers web application that will let you:

1) Upload a map image.
2) Add GCP's (ground control points) visually.
3) Create a UMN Mapserver WMS link that could be used in an OpenLayers map.

Try it out yourself by clicking on this link.

Free Philippines GIS Data Set

Ever tried googling for shapefiles philippines gis data sets? You can get plenty but most of them are only ADM1 level spatial data.

NAMRIA I think already have shapefiles available up to the barangay level but not for free. Pity.

Try this: http://gis.naga.gov.ph/phildata/

You'll get barangay shapefiles of Camarines Sur. If you have some data to share send it over so that we could publish. Its only bandwidth.

***cross posted from the naga city forum

Shapefiles Philippines plus Tons of Data

The PIDS website uses MapServer to publish tons of statistical data about the Philippines. Shapefiles included. Never mind the UI. (looks to me like it could still be improved!)

Try this and this and this. Mind the URL's. I'm sure you'll figure it out!

IMPORT/EXPORT

If you want to export/import data from/to oracle databases, here's a general procedure.

I used this to setup a clean oracle database on a new machine.
I took it from Paul's notes. Thanks Paul!

Exporting a schema from the SOURCE

From the DOS prompt:

C:\> exp [username]@[database] rows=y file=*

when prompted for a filename give it a valid filename (eg. export.dmp) or accept default

where:

exp - ORACLE utility program to export data in proprietary format
username - the owner of the schema you wnat to export
database - the source ORACLE database name


Importing the schema to the DESTINATION

Assumptions: Oracle server is up and runnning in the destination machine.

From SQL-Plus: Login as SYSTEM/manager

SQL> create [username] identified by [password] temporary tablespace temp default tablespace users;
SQL> grant dba to [username];

From the DOS prompt:

C:\> imp [username]@[database] file=* full=y

when prompted for a filename, give the it the name of the [export.dmp] you supplied while exporting

where:
imp - ORACLE utility program to import data
username - the destination owner of the schema you want to import
database - the destination ORACLE database name