friendster

from nico, paolo and andrei

moving...

summer of '07



pic from: http://www.go.dlr.de/wt/dv/ig/icons/funet/moving.gif

UNOSAT Images Typhoon Reming Effect

UNOSAT - satellite images for all - GIS in action

Flooding Extent Around Town of Naga, Camarines Sur Province, Philippines

Flooding Extent Around Town of Calabanga, Camarines Sur Province, Philippines

Flooding Extent Around Town of Nabua, Camarines Sur Province, Philippines

Flooding & Mudslide Damage over Guinobatan Town, Albay Province, Philippines

Flooding & Mudslide Damage over the Town of Daraga, Albay Province, Philippines

Overview Map of Typhoon Durian Track, Philippines

Brainbench Certification

Last week I had a chance to take a paid Brainbench certification for C++ and my result was a disappointing 3.42 out of 5.

The questions were mainly on language features and syntax. No question regarding design and/or applications. The results revealed that I was weak on C++ data types. I expected myself to rate higher than what I got. Time for me to hit the books, other C++ language reference materials and go back to the basics.

Reminder to myself, before taking tests:

• Study, study, study!


• Be prepared. Have (online) reference materials ready when you are taking the test and be very familiar with it - to easily search for answers for particular topic.


• Better yet, have a instance of your *favorite* c++ compiler ready - to compile the some of the given code snippets.


• Use the 3 minute alloted time per question wisely. Don't be quick to click the next question button.


• Take a practice test form the BB site. Some of them are available for free. Practice makes perfect.

Naga City GIS Day

The City Government of Naga celebrated GIS day Nov 15, 2006.





Read all about it from this post.

Komiks

Find Larry Alcala from one of his "A Slice of Life" cartoon strip. Click on the image to see more!

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