I have a Geotiff image, which I want to load into a PostgreSQL database.
Currently I am using the command line code for saving this image to my database :
raster2pgsql -I -C -e -Y -F -s 26986 -t 128x128 -l 2,4 C:\Users\Digital-Globe-Quickbird\pyramids_geotiff.tif public.boston | psql -U postgres -d test -h 188.8.131.52 -p 5432
And after Run this command it creates one table for that image and stores the data in it.
Now I want to fetch the data from the table and plot it on Google map.
I am executing this query on pgAdmin for fetching the data :
select rid,rast::geometry from boston limit 10;
And I get the output like this :
Now I don’t know how to plot this data on Google map. please let me know how can do this.