<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Stephen,</div><div><font class="Apple-style-span" face="monospace"><span class="Apple-style-span" style="white-space: pre;"><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="white-space: normal;"><br></span></font></span></font></div><div>Had to fix the typos, but this does seem to work. thanks. Here is the updated SQL:</div><div><br></div><div><div>CREATE TABLE parks (</div><div> park_id INTEGER,</div><div> park_name VARCHAR,</div><div> park_date DATE,</div><div> park_type VARCHAR,</div><div> park_geom geometry,</div><div> CONSTRAINT enforce_dims_park_geom CHECK (st_ndims(park_geom) = 2),</div><div> CONSTRAINT enforce_geotype_park_geom CHECK (geometrytype(park_geom) = 'MULTIPOLYGON'::text OR park_geom IS NULL),</div><div> CONSTRAINT enforce_srid_park_geom CHECK (st_srid(park_geom) = 4326)</div><div>);</div></div><div><pre class="data"><br></pre><div>-Greg</div></div><br><div><div>On Jun 27, 2010, at 11:14 PM, Stephen Woodbridge wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">CREATE TABLE parks (<br> park_id INTEGER,<br> park_name VARCHAR,<br> park_date DATE,<br> park_type VARCHAR,<br> park_geom geomtery,<br> CONSTRAINT enforce_dims_park_geom CHECK (st_ndims(park_geom) = 2),<br> CONSTRAINT enforce_geotype_park_geom CHECK (geometrytype(park_geom) = 'MULTIPOLYGON'::text OR the_geom IS NULL),<br> CONSTRAINT enforce_srid_park_geom CHECK (st_srid(park_geom) = 4326)<br>);</blockquote></div><br></body></html>