My Blog of Japan Japan!

Posts from September 2007

Setting size and zoom level of maps

What I though was going to be an easy case of looking through the google maps API for a solution to bounds turned into a mammoth task today. I wanted a way to make the centre and zoom of a map change according to the points it contained, with the centre being the average of [...]


Posted
27 September 2007 @ 7pm

Posted In:
Japan

Hardcore Chamber Music

These guys are playing at Super Deluxe all next week, October 1st to 8th. Looks like it’s going to be a pretty radical gig!
Hardcore Chamber Music


Posted
27 September 2007 @ 9am

Posted In:
Japan

Youtube video of Don Quixote

I wanted to try seeing how much traffic a youtube video would get, so I put up one that i took at Don Quixote in Inage and linked it to the page. I worked hard to get a nice attention grabbing frame in the exact middle, by chopping a little off the end of the [...]


Posted
26 September 2007 @ 5pm

Posted In:
Japan

A Tour of Yukarigaoka’s Little Train Line

There’s a little loop line monorail that travels around Yukarigaoka. This year was the 30th anniversary, so they had streamers up. As usual, they were letting people ride for free on the day of the festival in summer.
Searching for information about the fire station nearby, I came across this tour of the railway.
http://homepage3.nifty.com/ohanahan/03yukari1.html
Once, when they [...]


Using LIMIT statements in MySQL

To get the front page images, I used a LIMIT function in SQL. something like this:
SELECT * FROM places ORDER BY add_date DESC LIMIT 0,6
And use these results to query the database again and grab the main photo details.
Easy, I thought. They I realised that sometimes a place doesn’t have a photo to go along [...]


Programming zoom levels and fitting points

Last week I started adding content to the front page. In PHP, I programmed a script to pull the latest 6 places from the database, grab their main photo and display it with a link to the page. I also grabbed the coordinates for each place and put them all on a map. The general [...]


Posted
20 September 2007 @ 12pm

Posted In:
Japan, News

My Map of Japan

Welcome to My Map of Japan. This is a site where I get to try out PHP programming techniques with a little SQL and CSS. The site has been build from scratch, so it’s rough around the edges, but as I work on it, I’ll give updates here.
The idea of this site is to capture [...]