To load many raster at the same time use the * wildcard. E.g. raster2pgsql.py -r c:/yourfolder/*.jpg
To georeference your tiles properly, you could use the -F raster2pgsql option to create a new column with the original filename and then use string functions to extract the upper left X an upper left Y and set them in the raster. If your X and Y coordinates are encoded on three digits you could do something like: UPDATE yourrasttable SET rast = ST_SetUpperLeft(rast, substring(filename, 1, 3)::float4, substring(filename, 5, 3)::float4) You can also set the pixel size at the same time: UPDATE yourrasttable SET rast = ST_SetUpperLeft(ST_SetScale(rast, 0.34256), substring(filename, 1, 3)::float4, substring(filename, 5, 3)::float4) Hope this help, Pierre > -----Original Message----- > From: [email protected] [mailto:postgis-users- > [email protected]] On Behalf Of Knut Krause > Sent: Thursday, August 18, 2011 4:58 AM > To: [email protected] > Subject: [postgis-users] Importing tiles in PostGIS raster > > Hi, > > I want to import a raster image in PostGIS. Now my raster image is already > split > into tiles and I can't see how I can handle those images with raster2pgsql.py. > Currently the filenames are x_y.jpg where x and y refer to the coordinate of > the > upper left corner. How can I import those images using the correct > coordinates? > All examples just mention the SRID and no positions. > > Would be great if someone has experience with that. > > Regards > > > Knut _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
