Data Analisys + Data Base

After 1 month I achieve some basic data analysis using *only* PostgreSQL+PostGIS. This is an example of what I did:

  1. defined a regular spatial grid in PL/pgSQL (see fig 0 full size,the thumbnail is horrible) < [Interested in this function? Comment below, I could think of putting all the code somewhere]
  2. collected all the measurement in an area (the diamonds scattered around, all size in fig 1)
  3. selected all the measurements falling in each pixel (the smaller version of the diamonds in fig 2)
  4. calculated the average value of all the measurements parameters’ per pixel (fig 3)
  5. used some parameter to colorize the grid, in this case I used the reflectance at 0.5 microns (empty polygon contains no measurements).

And all using Free&Opensource software!
(Yeah, ehm just the DB feeding is not that open, but that’s my fault. I’ll learn!!)

PS: I acquired a new orthographic corrector, it’s called DictatorWannabe (thanks!) . It is smart,fast and efficient, and it will rule the World.

Annunci
Questa voce è stata pubblicata in News. Contrassegna il permalink.

2 pensieri su “Data Analisys + Data Base

  1. “PS: I acquired a new orthographic corrector, it’s called DictatorWannabe (thanks!) . It is smart,fast and efficient, and it will rule the World.” —-> I’m writing from the floor laughing! XD

Rispondi

Inserisci i tuoi dati qui sotto o clicca su un'icona per effettuare l'accesso:

Logo WordPress.com

Stai commentando usando il tuo account WordPress.com. Chiudi sessione / Modifica )

Foto Twitter

Stai commentando usando il tuo account Twitter. Chiudi sessione / Modifica )

Foto di Facebook

Stai commentando usando il tuo account Facebook. Chiudi sessione / Modifica )

Google+ photo

Stai commentando usando il tuo account Google+. Chiudi sessione / Modifica )

Connessione a %s...