[postgis-users] PostgreSQL geometric data types vs GEOMETRY data type

[Baris Ergun]

Also take a look at this post

http://stackoverflow.com/questions/1023229/spatial-data-in-postgresql

And here are the postgresql spatial methods

http://www.postgresql.org/docs/9.3/static/functions-geometry.html

Postgis provides you more generic and complex way of declaring geospatial
objects both geometrically and geographically.

Postgresql looks like more handling operation in Eucledian Geometry. In
postgis you are using a GIS which is aware of Srids, 2d 3d and measure
geometries, rasters, topologies.....
On 3 Jan 2014 03:17, "Peter Len" <peteralen at earthlink.net> wrote:

> Yeah,  I am new to PostgreSQL and PostGIS and so first was looking and
> playing with the PostgreSQL built-in geometric data types like POINT and
> POLYGON.  I did not know that PostGIS added its own datatype (Geometry and
> Geography).  It seems that just using the PostgreSQL data types is fine to
> use if you don't need all the extra PostGIS functionality.  But for more
> robust geospatial functions, adding in PostGIS and using its data types is
> the way to go.  On top of that, we are looking to use GeoServer and I
> believe (although not positive) that the Geoserver data source will deal
> with PostGIS.  So.....  I am now enlightened on the difference.  Thanks for
> all the feedback!!
>
>
>
> --
> View this message in context:
> http://postgis.17.x6.nabble.com/PostgreSQL-geometric-data-types-vs-GEOMETRY-data-type-tp5005378p5005384.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140106/0392dbe3/attachment.html>