Smathermather's Weblog

Remote Sensing, GIS, Ecology, and Oddball Techniques

PostGIS 2.0SVN and Raster

Posted by smathermather on October 28, 2011

Got PostGIS 2.0 installed on a Debian machine, with Raster enabled, and put my first image in thanks to the directions in PostGIS In Action. Here’s the auto-generated SQL in pgAdmin:


CREATE TABLE ldi_10ft
(
  rid serial NOT NULL,
  rast raster,
  CONSTRAINT ldi_10ft_pkey PRIMARY KEY ( rid ),
  CONSTRAINT enforce_srid_rast CHECK (st_srid( rast ) = 3734)
)
WITH (
  OIDS=FALSE
);

CREATE INDEX ldi_10ft_rast_gis_idx
  ON ldi_10ft
  USING gist
  (st_convexhull(rast) );

Now for some rastery fun.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: