AW: [postgis-users] I need geo-database ?

[Uwe Seher]

Hello!

> I am new to postgis and geo-database.

Welcome in a fascinating new world ;)

> In ESRI's shape file has a shape column. But it is closed to see the
> geometric shape with coordinates.  And one can not query on real
> coordinates on  table.

In the Shape-column are the coordinates of the geometry in a binary format.
I think it is something (or it is) like WKB-format from PostGIS. You can
access the coordinates and objects in the shape-column by programming in
Arcobjects.

> Can you tell me more about the comparision of geo-table with
> conventiaonal table ?

The difference is only the geometry-column where the geometry is stored.
With this Field you can make some geoprocessing functions directly in the
database and you dont have to bother ArcGIS ;).

> so I could say that I need geo-database  and  conventianal  table (and
> ESRI' shape file)
> are not enough to carry out certain works.

No, in theory you need only a geodatabase table (or a view) with a
geometry-field. You can handle it as a common db-table.
In the real world you get some problems, because ArcGIS doesnt process the
PostGIS-Formt. But ther is the pgArc-extension on sourcforge and myself is
working on something comparable.

> What does geo-table provide more than conventional-table does ?

the geometry-field. And PostGIS some additional Functionality. Geo-tables in
MySQL for example can only handle the geometry without functionality.

> kind regards
>
> regards
>
> Ahmet Temiz

Greetings

Uwe Seher


> -----Ursprüngliche Nachricht-----
> Von: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net]Im Auftrag von
> orkun
> Gesendet: Mittwoch, 29. Juni 2005 09:39
> An: postgis-users at postgis.refractions.net
> Betreff: [postgis-users] I need geo-database ?
>
>
> hello
>
> I am new to postgis and geo-database.
>
> I want to know what db table containing geographic columns is more
> beneficial
> than conventional db table.
>
> For example as far as I know,
>
> Can you tell me more about the comparision of geo-table with
> conventiaonal table ?
>
>
> ______________________________________
> XamimeLT - installed on mailserver for domain @deprem.gov.tr
> Queries to: postmaster at deprem.gov.tr
> ______________________________________
> The views and opinions expressed in this e-mail message are the
> sender's own
> and do not necessarily represent the views and the opinions of
> Earthquake Research Dept.
> of General Directorate of Disaster Affairs.
>
> Bu e-postadaki fikir ve gorusler gonderenin sahsina ait olup,
> yasal olarak T.C.
> B.I.B. Afet Isleri Gn.Mud. Deprem Arastirma Dairesi'ni baglayici
> nitelikte degildir.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

____________
Virus checked by G DATA AntiVirusKit