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

[Hisaji ONO]

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
> 
=== 以下のメッセージは省略されました ===