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

Paul Ramsey pramsey at refractions.net
Wed Nov 15 13:11:55 PST 2006


In the file itself? I understand they use a multi-level gridding  
system. Probably you could figure it out by examining the f_* tables  
carefully.

P

On 15-Nov-06, at 12:58 PM, Hisaji ONO wrote:

> Hello.
>
>
>  How about spatial indexes?
>
>
>  Regards.
>
> --- Martin Davis <mbdavis at refractions.net> wrote:
>
>> 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
>>
>> _______________________________________________
>> 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




More information about the postgis-users mailing list