Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (22)
- All (399)
- Biography (1)
- Blog (44)
- Business Requirements (1)
- Commentary (1)
- Conversion (2)
- Customers (2)
- Data Models (1)
- Education (2)
- GeoRaptor (13)
- GPS (1)
- Image Processing (2)
- Import Export (8)
- Licensing (2)
- LiDAR (1)
- Linear Referencing (4)
- Manifold GIS (3)
- Mapping (1)
- MySQL Spatial (7)
- Networking and Routing (including Optimization) (5)
- Open Source (18)
- Oracle Spatial and Locator (194)
- Partitioning (1)
- PostGIS (36)
- Projections (1)
- Published Articles (1)
- qGIS (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (37)
- Space Curves (9)
- Spatial Database Functions (109)
- Spatial DB comparison (1)
- Spatial XML Processing (11)
- SQL Server Spatial (92)
- Standards (3)
- Stored Procedure (17)
- Tessellation or Gridding (10)
- Tools (2)
- Topological Relationships (1)
- Training (2)
- Triangulation (2)
National Broadband Network, Spatial Data & Processing
As a spatial practitioner familiar with many aspects of spatial data capture and processing, I have been watching the responses to the opportunity that the National Broadband Network (NBN) offers the people of Australia and its federal, state, local and private spatial practitioners.
One hears very little from NBN Co about what it is doing with regards to using spatial data and processing in its rollout of its fibre and wireless services. In fact, one hears very little at all unless one regularly reads The Australian newspaper’s IT and Telecommunications section!
I have a particular interest in how well the NBN does its job.
- I live in Tasmania where the NBN is being rolled out;
- I live in the country. Not so far that I don’t currently have ADSL2+ but far enough for the NBN to have decreed that I won’t get a fibre service because fibre will only be rolled out to villages with a population (or number of houses) of 1000 or more. (I don’t recall the Prime Minister or Senator Conroy saying that this was a Government mandated limit on rollout – I thought the people in the bush were to get the same service as the city – especially where they already have copper based Internet!) ;
- I run a computer business that requires quality Internet access;
- I did some work for Telstra Mobiles about 15 years ago in respect of mobile tower location;
- I have been interested in, promoted and worked with LiDAR data and see great potential for its application to NBN wireless tower location.
- I am interested in open geodata but not so much OpenStreetMap, rather a public dataset of the locations of buildings in which people reside.
OK, let’s put all this together.
Topography and Forests
Tasmania is of interest to me due to its highly topographic and forested nature. Its varied topography and vast areas of Private and Crown forests, and National Parks, makes the provision of Television, Radio, Wireless and Mobile Phone technologies difficult in all but the major residential areas.
Having an accurate model of this topography with its forest cover is therefore important.
The current digital elevation dataset for Tasmania are very coarse and also do not take into account the vegetation/forest that covers our hills.
If we do not have a good model of our topography and vegetation cover we will not be able to determine the optimal television, radio, mobile and wireless tower locations that would ensure maximal coverage in terms of signal and quality.
I have done some simple tests with the current coarse elevation dataset, vegetation and mobile towers in my area and they confirm that the coverage I experience at my house is, as expected, predictable (I live in the bottom of a cleared valley 25 minutes drive from Hobart).
How can the models and the coverage area be improved?
By having better models and a clearer understanding of the location of all customers.
Modelling Topography and Forests through LiDAR
Forestry Tasmania (FT) has led the state of Tasmania for the past 10 years or so in the application of LiDAR to its forest management. With LiDAR, and clever algorithms, it is now able to measure the standing volume of timber in native – and plantation – forest doing away with the unbiased statistical sampling methods.
FT, as a good corporate citizen, has asked other agencies to join with it in funding the rollout. But its vision was ignored until very recent. Even so, there is still, to my knowledge, no moves by any of the Government departments and agencies in Tasmania to fund the capture and use of LiDAR even though its applications, particularly for asset capture for Local Government, is phenomenal.
Besides mapping its own forests, FT is also starting to build quite a nice income stream by providing its LiDAR interpolation skills to external agencies and companies.
LiDAR Cost
The cost to LiDAR the state is not high – of the order of $5M.
This amount is rough and depends on clear specification of:
- The capture parameters (swath width, flying height etc)
- The area to be covered (do we need to cover the World Heritage Area?).
But actual cost could be born by many interested parties such as: Google, NBN Co, Telstra, Optus, Vodaphone, State and Local Government, Forestry Tasmania, private agricultural companies etc.
Determining Service for Occupied Buildings.
If one is going to provide good service one needs to know where one’s customers are. The current method of providing mobile coverage is to site the towers where one can in the hope that whoever created the tower there in the first place knew it to be a good site to provide coverage to the majority of customers.
This approach is a top-down approach (a 180 degree approach) which is known to be insufficient to providing coverage.
How do we know the locations are optimal?
We can only know this by knowing the location of occupied buildings within the area being covered.
For example, even using simple line-of-sight algorithms it is relatively easy to create a view-shed from one or more mobile towers that would allow one to identify which occupied buildings within the view-shed would get service and a prediction of the quality of the service.
But, critically, such a dataset would allow one to do a reverse view-shed to identify optimal tower locations.
Building Dataset Availability
However, we don’t have a good, publically available dataset holding these locations.
The current Geographic Names Address File (G-NAF) from the PSMA is great but it doesn’t define a point that locates an occupied dwelling accurately via a point at the centre of its footprint. Also, the dataset only holds rateable property locations and not the location of all possible residential buildings.
Now, the Australian Bureau of Statistics (ABS) each census visits all residential dwellings and locates them. However, the locational aspect of each dwelling is thrown away after census to ensure, as with its other data, that individuals cannot be identified.
This is a pity because individual confidentiality would not be compromised by having a dataset that contained nothing more than:
building_id | longitude | latitude | Status |
---|---|---|---|
1 | 147.5678902 | -43.6475869 | occupied |
Note that one does not need any other information: address, name of occupier, age, sex etc.
But such a dataset cannot be sourced from the ABS. So, as they say “get over it!”.
Where could we get one from? Possibly by the following method.
- Create a website called www.openbuildinglocation.org
- Preload the database behind this website with the location of the buildings that exist on the current topographic map series for Tasmania (and elsewhere);
- Tag loaded building with whether they are occupied or not;
- Encourage people to edit the data by uploading their own house location via GPS, clicking on an appropriate background map source (with no legal restrictions).
Conclusion
LiDAR can:
- Measure the ground elevation;
- Measure vegetation / forest height;
- (And allow extraction of 3D roads and other assets).
(The roads dataset would be great for determining quality of wireless/radar coverage along major or minor roads.)
Coupled with a decent occupied building point location dataset the elevation and vegetation height datasets would provide a critical base set of data that is targeted to the needs of a modern digital economy.
I have not seen any moves towards the capture and provision of such datasets.
Are we failing to grasp this due to competition and privacy issues? Or because Governments and their agencies rarely ever provide the sort of leadership that is required?
Documentation
- MySQL Spatial General Functions
- Oracle LRS Objects
- Oracle Spatial Exporter (Java + pl/SQL)
- Oracle Spatial Object Functions
- Oracle Spatial Object Functions (Multi Page)
- PostGIS pl/pgSQL Functions
- SC4O Oracle Java Topology Suite (Java + pl/SQL)
- SQL Server Spatial General TSQL Functions
- SQL Server Spatial LRS TSQL Functions