Showing posts with label spatial. Show all posts
Showing posts with label spatial. Show all posts

Friday, March 23, 2012

is ther something free(evaluation,beta..) spatial DBMS?

hi
i know oracle-spatial and db2(spatial)
but i want to know
"is ther something free(evaluation,beta..) spatial DBMS?"
* spatial DBMS : can handle geometry data type (point,line,polygon...)
and spatial function (contain,cross,touch..)
thanks
JinOn Wed, 19 Nov 2003 19:49:45 +0900, "ice" <yjwon@.geomania.com> wrote:
>hi
>i know oracle-spatial and db2(spatial)
>but i want to know
>"is ther something free(evaluation,beta..) spatial DBMS?"
>* spatial DBMS : can handle geometry data type (point,line,polygon...)
> and spatial function (contain,cross,touch..)
>thanks
>Jin
>
>
>
Try PostGIS
Paul|||yes, try postGIS (www.refractions.net), which can be used with postgresql.
These are both open source.
best of luck
--
____________
remove the 'obvious' from my address
to reply.
"Paul Cooper" <paul.cooper@.Nobasspam.ac.uk> wrote in message
news:bujmrvgvibf0jvhui3o51n6ep6dru87eep@.4ax.com...
: On Wed, 19 Nov 2003 19:49:45 +0900, "ice" <yjwon@.geomania.com> wrote:
:
: >hi
: >
: >i know oracle-spatial and db2(spatial)
: >
: >but i want to know
: >
: >"is ther something free(evaluation,beta..) spatial DBMS?"
: >
: >* spatial DBMS : can handle geometry data type (point,line,polygon...)
: > and spatial function (contain,cross,touch..)
: >
: >thanks
: >
: >Jin
: >
: >
: >
: >
: >
:
: Try PostGIS
:
: Paul|||There's some spatial capability that is relatively new in MySQL. I'm not
sure if all this is implemented yet, see
http://www.mysql.com/doc/en/Spatial_extensions_in_MySQL.html
I'd be interested in comments from people who have worked with this.
-Ken
ice wrote:
> hi
>
...
> "is ther something free(evaluation,beta..) spatial DBMS?"
>
...

Monday, March 19, 2012

Is Sql-Server 2005 Object Oriented DBMS

Greetings,
I would like to konw if Sqlserver 2005 supports Geographic Information
System (GIS) data, i.e., supports spatial data, like Oracle?
MTIA,
Grawshagrawsha2000@.yahoo.com wrote:
> Greetings,
> I would like to konw if Sqlserver 2005 supports Geographic Information
> System (GIS) data, i.e., supports spatial data, like Oracle?
>
> MTIA,
> Grawsha
SQL Server doesn't have specific features designed for GIS but it does
support user-defined datatypes and CLR (.NET) code in the database. You
can build "complex" types (points and vectors maybe) from .NET classes.
That may cover some of the features you have in mind.
As for OODBMS, it would help if you could be more specific. "OODBMS" is
commonly used as a marketing category or an imprecise term for any of
various different features and techniques. If you are looking for
encapsulation, inheritence and subclassing then you can achieve that
through .NET code either inside or outside the database server. If you
need an object store then you can also serialize .NET objects to a SQL
Server database.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||>> I would like to konw if Sqlserver 2005 supports Geographic Information
Searching MSDN bought up the following, not sure if helps:
http://msdn.microsoft.com/library/e...lValFuncSQL.asp
Anith