[postgis-users] when rasters in Postgis?
Gerry Creager N5JXS
gerry.creager at tamu.edu
Sun Sep 25 16:11:01 PDT 2005
Stephen Woodbridge wrote:
> Giorgio Plazzotta wrote:
>> but i am glad also to partecipate at a discussion about the advantages
>> and disadvantages of inserting the data inside the geodatabase or
>> leave them as external files.
> I think both cases of raster data in the database and data outside the
> database are needed. This speaks to having a raster object and a raster
> reference object that might be equivalent expect one stores the data and
> one maintains a reference to a file.
Forgive me for coming in late, but for our rasters, we store the data
and if available, the worldfile data in PostGIS, (and a centroid) as
well as the fully qualified filename. In this manner we can query and
retrieve the image via centroid or corners, return a FQFN and snag it.
>> I tried to ask the list before about the performance difference
>> between splitting a large vector file into several tiles managed
>> through a tileindex or inserting it inside postgis, but nobody answered.
> I know the answer to this :) It will depend on your usage. Mapserver is
> fastest serving tiled shapefiles. So if you just need to serve maps you
> are probably better off using shapefiles, but if you need to do other
> operations on the vector data then PostGIS might offer some significant
> benefits. If you want to do thematic mapping you have to have your
> layers that will be rendered in PostGIS, but all layers do not need to
> be in PostGIS. While having the data in PostGIS it also opens the door
> to performing other types of geo-spatial computations, but if you never
> plan to take advantage of them in a production environment, you need to
> ask is it worth it.
> For example, I put the polygon layers that I want to style thematically
> in PostGIS and keep all my highways and streets in shapefiles. This way
> I get the best of both.
> postgis-users mailing list
> postgis-users at postgis.refractions.net
Gerry Creager -- gerry.creager at tamu.edu
Texas Mesonet -- AATLT, Texas A&M University
Cell: 979.229.5301 Office: 979.458.4020 FAX: 979.847.8578
Office: 903A Eller Bldg, TAMU, College Station, TX 77843
More information about the postgis-users