PostGIS 2.0SVN and Raster

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:

  rid serial NOT NULL,
  rast raster,
  CONSTRAINT ldi_10ft_pkey PRIMARY KEY ( rid ),
  CONSTRAINT enforce_srid_rast CHECK (st_srid( rast ) = 3734)

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: Logo

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

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.