<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7654.12">
<TITLE>AutoCAD Map 3d 2011 BulkCopy to PostGIS DB with FDOPostgreSQL Provider 3.5</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">Dear List,</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">#################################################################################################################</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">### an Import of towns_poly.shp with shp2pgsql results in following table</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">### when mapping the columns from the shapefile "towns.shp" to the columns of the table "towns" in the postgis db bulkcopy will work</FONT></SPAN></P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">#################################################################################################################</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">-- Table: towns</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">-- DROP TABLE towns;</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">CREATE TABLE towns</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">(</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> gid serial NOT NULL,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> objectid bigint,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> towns_id bigint,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> town_id smallint,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> town character varying(21),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> fips_stco integer,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> ccd_mcd character varying(3),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> fips_place character varying(5),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> pop1980 integer,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> pop1990 integer,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> pop2000 integer,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> popch80_90 integer,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> popch90_00 integer,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> fourcolor smallint,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "type" character varying(2),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> island smallint,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> fips_mcd integer,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> fips_count smallint,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> shape_area numeric,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> shape_len numeric,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> the_geom geometry,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> CONSTRAINT towns_pkey PRIMARY KEY (gid),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> CONSTRAINT enforce_dims_the_geom CHECK (st_ndims(the_geom) = 2),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'POLYGON'::text OR the_geom IS NULL),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 26986)</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">)</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">WITH (</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> OIDS=FALSE</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">);</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">ALTER TABLE towns OWNER TO postgres;</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">################################################################################################################################</FONT></SPAN></P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">### bulkcopy of the shapefile "towns.shp" with FDOPostgreSQL Provider 3.5 to the public schema in postgis will result in the table "towns_fdopoly" below</FONT></SPAN></P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">### the wrong srid 31254 in the create table statement is an srid of a dataset which was already present in the schema public. The correct srid of the prj file of "towns.shp" is 26986 (MA83)</FONT></SPAN></P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">### copying of the data in the columns shape_area and shape_len from towns.shp to the postgis table which is already created from the FDOPostgreSQLProvider as [numeric (19,11)]</FONT></SPAN></P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">### causes following error</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">### RDBMS: [PGRES_FATAL_ERROR] ERROR: Overflow by type >>numeric<<</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">### DETAIL: rounding a value of a column with precision 19, scale 11 has to have less then 10^8</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">#################################################################################################################################</FONT></SPAN></P>
<BR>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">-- Table: "TOWNS_FDOPOLY"</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">-- DROP TABLE "TOWNS_FDOPOLY";</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">CREATE TABLE "TOWNS_FDOPOLY"</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">(</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "FeatId" serial NOT NULL,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "OBJECTID" numeric(10,0),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "TOWNS_ID" numeric(10,0),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "TOWN_ID" numeric(3,0),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "TOWN" character varying(21),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "FIPS_STCO" numeric(5,0),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "CCD_MCD" character varying(3),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "FIPS_PLACE" character varying(5),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "POP1980" numeric(6,0),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "POP1990" numeric(6,0),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "POP2000" numeric(6,0),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "POPCH80_90" numeric(5,0),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "POPCH90_00" numeric(5,0),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "FOURCOLOR" numeric(1,0),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "TYPE" character varying(2),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "ISLAND" numeric(1,0),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "FIPS_MCD" numeric(8,0),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "FIPS_COUNT" numeric(3,0),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "SHAPE_AREA" numeric(19,11),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "SHAPE_LEN" numeric(19,11),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> "Geometry" geometry,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> CONSTRAINT pk_public_towns_fdopoly PRIMARY KEY ("FeatId"),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> CONSTRAINT "enforce_dims_Geometry" CHECK (st_ndims("Geometry") = 2),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> CONSTRAINT "enforce_srid_Geometry" CHECK (st_srid("Geometry") = 31254)</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">)</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">WITH (</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> OIDS=FALSE</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">);</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">ALTER TABLE "TOWNS_FDOPOLY" OWNER TO postgres;</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">-- Index: towns_fdopoly_geometry_si</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">-- DROP INDEX towns_fdopoly_geometry_si;</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">CREATE INDEX towns_fdopoly_geometry_si</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> ON "TOWNS_FDOPOLY"</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> USING gist</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> ("Geometry");</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">Karl</FONT></SPAN>
</P>
</BODY>
</HTML>