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

[Paul Ramsey]

This is not just any old "Access Database", it is an ESRI  
"geodatabase" so you will need special tools to read out of it and  
into PostGIS, a simple ODBC copy is not going to do it. Try ogr2ogr  
from FWTools.

P

On 13-Nov-06, at 6:28 PM, P Kishor wrote:

> I thought we went over this...
>
> On 11/13/06, Hendra Yana <Hendra at lskk.ee.itb.ac.id> wrote:
>> Thanks for the reply man....
>>
>> Here is the sample cut of my MS-Access Database with the shape  
>> data field
>> http://lskk.ee.itb.ac.id/Hendra/downloads/Disbun.rar
>>
>>
>> My questions are:
>>
>> 1. Where is field of the_geom field in postgresql?
>>
>> 2. How to export this MS-Access to postgresql that support postgis?
>
> try one of the translators such as ogr2ogr (as mentioned, IIRC, in
> another email).
>
>>
>> 3. I try to export one field in MS-Access to csv format but the  
>> OLE Object
>> Data type doesn't export well (empty), why?
>
> think about it -- how do you think a binary piece of information can
> be represented in pure text? Is it possible? No, it is not possible.
>
> ..
>
>
> -- 
> 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