192.com Aerial Imagery Updated

192.com Aerial Imagery Updated

192.com have updated the to most up-to-date online aerial photography for London.
High Resolution aerial photography from Getmapping.com
The new imagery has been captured using the latest digital camera technology with each image pixel equivalent to 12.5cm from the ground. The result are high quailty true-colour photographs - right down to road markings and visable street furniture.

This data is more up to date than google 'satellite' mode and microsoft bing aerial (multimap) mapping sources.



New orthorectified aerial images on 192.com include Wembley Stadium including the Wembley Arch and Wimbledon’s new multi-million centre court roof. Also visible on the new photography is the beginning of the preparations for The Ashes Test Matches at Lords and the Oval Cricket grounds.

"This new photography shows a step forward for aerial imagery used on the net and we believe it will help our users to get richer search results and a more enjoyable experience. The images are truly amazing and even let people check out the most recent aerial shots of their home."
Dominic Blackburn - Product Director

Check the new updated aerial photographs
http://www.192.com/places/


A couple links to some well know landmarks:

Buckingham Palace
http://www.192.com/places/search/?Type=All&place=BUCKINGHAM%20PALACE&gre=529168&grn=179747
(includes Super Zoom Mode)

Wembley Stadium
http://www.192.com/places/search/?location=wembley%20stadium&distance=1838&page=1&searchType=All&place=WEMBLEY%20STADIUM&gre=519384&grn=185519

source:http://www.journalism.co.uk/66/articles/535540.php
& email - thanks to Neil Watts - neil.watts@192.com

Super Lightweight Spatial Database [SpatiaLite]

Superlight Spatial Database [SpatiaLite]

After a quick review of 'Free' Open Source GIS software. Had a look at Spatial Databases
There is a SpatiaLite - and it's easy to use 1,2,3 Go! (five minute guide)

What can you do quickly?


What is an MBR? Above graphically shows the Bottom Left and Top Right of a rectangle using this as an extent to find spatial features within.This is one of the most basic ways to find something spatially.
More on MBR [Minimum Bounding Rectangle] Function [Wiki]


SQL request to find all features within the MBR

*Data used was OpenStreetMap in shapefile format
Not saying this is best spatial database out there but is certain to be the quickest to download,install and load data within it.

Features:
* Enhanced GUI tool v1.2
* SQL mathematical functions
* EXIF-GPS geometry-handling functions
* Virtual Table module VirtualNetwork
* Supporting routing [Dijkstra's Shortest Path algorithm]
* Supports importing and exporting to shapefiles [big plus]
* Supports standard WKT and WKB formats

Tutorials and Documentation to get you started.
http://www.gaia-gis.it/spatialite/docs.html

Why Super Lightweight? [8.3mb windows application] that's why.

Related links:
http://www.gaia-gis.it/spatialite/ [Main Homepage]
http://groups.google.com/group/spatialite-users?pli=1 [Google Group - Spatialite]

http://mapperz.blogspot.com/2008/09/open-street-map-in-shapefile-format.html
http://www.geofabrik.de/data/download.html [Open Street Map data in shapefiles]

Downloads
http://www.gaia-gis.it/spatialite/binaries.html [Applications for Mac,Windows,Linux]
http://www.gaia-gis.it/spatialite/resources.html [Sample Databases, Routing, Test Scripts]

Mapperz