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

[Martin Davis]

Yep, that's exactly what it is - just the binary format used for a 
geometry object in Shapefiles.

Paul Ramsey wrote:
> 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>

-- 
Martin Davis
Senior Technical Architect
Refractions Research, Inc.
(250) 383-3022