| 1 | = PostGIS Raster SoC Idea 2012 - Distance Analysis Tools for PostGIS Raster = |
| 2 | |
| 3 | '''Student:''' Qing Liu |
| 4 | |
| 5 | '''Idea''': |
| 6 | The idea for this proposed project is to add two spatial analysis functions to PostGIS Raster that |
| 7 | implement two main ways of performing distance analysis: Euclidean distance calculation and |
| 8 | cost-weighted distance calculation. |
| 9 | |
| 10 | Euclidean distance function will create a distance surface representing the Euclidean distance |
| 11 | from each cell in the source layer to the starting point or the closest source (as designated by user). |
| 12 | The basic concepts of the algorithm would be using the center of the source cell to calculate |
| 13 | the distance from it to the rest cells in the raster layer or within the user-defined extent. |
| 14 | |
| 15 | Cost-weighted distance will create a raster layer representing the accumulative cost distance |
| 16 | for each cell to the starting point or the closest source (as designated by user). A cost raster |
| 17 | layer will be generated using one or several factor layers representing the impedance of passing |
| 18 | through each cell according to user’s criteria. User can also put weights on the input factor layers |
| 19 | to represent different levels of importance for those factors. Factors such as: elevation, slope, |
| 20 | orientation, land use / land cover type; vehicle speed, accessibility; and a binary map layer could |
| 21 | also be used as a mask for defining geographic extent or as a filter for the output cost layer. |
| 22 | The accumulative cost values will be then assigned to each cell representing the cost per unit |
| 23 | distance for moving through this cell. |
| 24 | |
| 25 | '''GSoC 2012 Proposal: ''' |
| 26 | [[BR]] |
| 27 | [http://google-melange.appspot.com/gsoc/proposal/review/google/gsoc2012/kya_na/1] |
| 28 | |
| 29 | |
| 30 | == Week 1 Report == |
| 31 | |
| 32 | '''What did you get done this week?''' |
| 33 | * Compiled PostGIS 2.0 sucessfully. |
| 34 | * Loaded raster data into PostgreSQL and practiced some query by finishing the raster/vector tutorial |
| 35 | * Write an analysis of how Euclidean distance and Cost-weighted distance are computed in ArcGIS and GRASS. |
| 36 | * Setup wiki page. |
| 37 | |
| 38 | ''' What do you plan on doing next week?''' |
| 39 | * Learn more about PostGIS Raster concepts and functions |
| 40 | * Write an analysis of how Euclidean distance and Cost-weighted distance are computed in Oracle |
| 41 | * Start to write a proposal on how adopt the concepts and algorithms in PostGIS. |
| 42 | |
| 43 | '''Are you blocked on anything?''' |
| 44 | * As of now I was not blocked on anything yet, but working in a spatial database is something new and challenging to me. I will need to read and reserch more about it. |
| 45 | * However, it took me some time to understand how raster coverage is stored in PostGIS, and how Raster type works. |
| 46 | |
| 47 | |
| 48 | '''Links of Analyses:''' |
| 49 | * How Euclidean distance and Cost-weighted distance are computed in ArcGIS and GRASS[[BR]][https://docs.google.com/document/d/1G6Ge3239kCBkn5qqpa1_0PNsvM9OWewsbI-2ZtSc3Cc/edit] |