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

[Paul Ramsey]

My understanding it that it is just a Shape record, but if it's not,  
it is probably nothing more complex than a differenced version of the  
same thing. (using the first coordinate, create all the rest of the  
coordinates as offsets from the first).  In any event, the answer is  
available in OGR, since Frank has already figured out the details and  
provides read support for geodatabase on platforms that support ODBC.

P

On 13-Nov-06, at 5:34 AM, Clay, Bruce 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