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

[P Kishor]

afaik, it is not publicly documented like shapefile. I also hear that
ESRI is going to be doing away with personal geodb in the near future,
and might be going back to some kind of flat file structure... perhaps
a super shapefile format?

On 11/13/06, Clay, Bruce <bclay at ball.com> wrote:
> 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
> _______________________________________________
> 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
====================================================