[postgis-users] HELP! Ms-Access shape data to the_geom ofpostgresql

[Clay, Bruce]

Does anyone have the data format for the blob?


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of P
Kishor
Sent: Monday, November 13, 2006 7:43 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] HELP! Ms-Access shape data to the_geom
ofpostgresql

coordinate data in Access (equivalent to the geom in PostGIS) is
stored as a blob.

On 11/13/06, Marc Angelo <computrain at paradise.net.nz> wrote:
> I can't give you a full answer but I can tell you why (I think) the
"data
> conversion" is failing (somebody please correct me if I am wrong). I
think
> you will find that the co-ordinate data in Access is a "double" or
"single"
> data type as Access does not have a "geometry" data type like in
Postgres.
> When you use the PostGres ODBC connector you are just transferring the
data
> from one database to another so Postgres is just placing the data in
the
> fields in the nearest data type that is equivalant to the Acces data
type.
>
> If the data needs only to be transferred once (not on a regular basis)
from
> Access you could import the data by writing a small routine in C++.Net
or
> VB.Net. I wrote a small app a while ago that imported geometry data
into
> Postgres.
> I connected to PostGres using NPGSQL data connector. All my data was
in csv
> fomat inside a text file. The routine opened the csv file and then
imported
> each record into Postgres by using an SQL insert statement combined
with the
> GeometryFromText() function which converts text coordinates into a
geometry
> data type in Postgres.
> Having said that I am not competent with SQL so I suspect that you
could
> write an SQL statement within Postgres to import and convert data that
> resides in a csv file.....this would mean exporting your data from
Access
> into a .txt or csv file.
>
> Hope this gives you at least some help.
>
> Cheers
> Marc
>
>
> ----- Original Message -----
> From: "Hendra Yana" <Hendra at lskk.ee.itb.ac.id>
> To: <postgis-users at postgis.refractions.net>
> Sent: Monday, November 13, 2006 9:00 PM
> Subject: [postgis-users] HELP! Ms-Access shape data to the_geom of
> postgresql
>
>
> > Help....
> >
> > I've been trying to convert database from Ms-Access shape data to
the_geom
> > for postgresql.
> >
> > I try to export from MS-Access to postgresql with PGSQL-ODBC
connection,
> > but the result in postgresql still not result as the_geom field but
still
> > the shape data in fields.
> >
> > Can anyone tell me how to Convert database from Ms-Access shape data
to
> > the_geom for postgresql???
> >
> > thanks for reply....
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Free Edition.
> > Version: 7.1.409 / Virus Database: 268.14.3/531 - Release Date:
12/11/2006
> >
> >
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>


-- 
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation https://edu.osgeo.org/
------------------------------------------------------------------------
-------------------------------
collaborate, communicate, compete
====================================================
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users