This project is read-only.

Documentation

Topics: Project Management Forum
Oct 23, 2006 at 5:05 PM
I see references to documentation in some of the forum comments. Is documentation available?
Oct 24, 2006 at 3:40 AM
There is no comprehensive documentation yet. In this moment, all available documentaion is the Getting started guide and msscmd.exe help page. And this forum, that someday could generate a FAQ document.

MsSqlSpatial is very similar to PostGIS and other OGC compliant spatial database extensions, so their documentation may be useful to some extent, specially introductory and conceptual sections. See:
http://postgis.refractions.net/docs/
http://publib.boulder.ibm.com/infocenter/db2luw/v8/
http://download-west.oracle.com/docs/html/B14255_01/toc.htm
http://reference.mapinfo.com/software/spatialware_for_sql_server/english/4_8/sw48_userguide.pdf

I think the table of contents of any of the linked manuals above would be a good starting point to document MsSqlSpatial. BTW, I'm looking for volunteers for documentation. Would you like to help? ;)

Best regards,
Ricardo Stuven.
Oct 24, 2006 at 1:28 PM
Sorry, one of the links above instead should be:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/opt/csbp3041.htm
Oct 27, 2006 at 3:02 PM
Thank you for the information and the links you provided. We will contribute any documentation we create.

Schad Meldrum
Oct 27, 2006 at 7:42 PM
> We will contribute any documentation we create.

Thank you, that will be really appreciated.

Best regards,
Ricardo Stuven.
Jan 24, 2007 at 2:28 PM
Hi Ricardo Stuven,

First, kudos for MsSqlSpatial! A customer had asked me about Spatial DB on SQL Server and this was the natural choice. That fits!

But they also asked for a tutorial. So, I've been working on the creation of a 'MsSqlSpatial for newcommers'.

I'm writing it in portuguese but after finished will be easy to translate it to english. I pretend to post it at my website( www.webmapit.com.br ) but I think it's more important to have it at MsSqlSpatial site first.

How should I do? Can I send a copy of it for you? Or do you prefer I wiki it for u? ( despite I never wikied under CodePlex, I know MediaWiki's wikimarkup )

The draft of the text looks like this:
----------------------------------------
//Spatial Database using MS-SQL Server//

1 - Step by step setup
1.1 - .NET framework 2.0
1.2 - Microsoft SQL Server 2005 Express
1.2.1 - Enabling MIXED MODE logins
1.2.2 - Protocols
1.2.3 - Other important configurations
1.2.4 - References
1.3 - Books Online
1.4 - SQL Server Management Studio Express
1.5 - MsSqlSpatial
1.5.1 - Defining a test database
1.5.2 - Enabling MsSqlSpatial extension at the test database
1.5.3 - Notes & References
1.6 - MDAC 2.8
2 - Introducing MsSqlSpatial
2.1 - Defining spatial tables
2.1.1 - ST.ImportFromShapefile
2.1.2 - msscmd
2.1.3 - Create spatial tables by hand
2.2 - Running spatial queries
- SQL samples on SQL Server Management Studio Express
- VB6 sample using MDAC 2.8
2.3 - Viewing MsSqlSpatial maps
- MapServer ( using ODBC connectors)
- MapServer WMS / WFS maps ( lot of clients)
- SharpMap ( with MS VC# Express or SharpDevelop )
- FWTools OpenEV ( just open the .ovf file)
---------------------------------

currently, I'm writing 2.1.3 section.

If need more info, just mail me at http://www.webmapit.com.br/contact/

best.
Jan 25, 2007 at 3:26 AM
That's great. Now you have permission to create new pages in the wiki. Please, put your material there and let's see how we follow the work together. I am not a native English speaker either, so we'll need some help from people with better English skills.

Best regards,
Ricardo Stuven.
Dec 3, 2007 at 11:32 PM
Hi,

I have published this "new" doc at http://anthologis.com/2007/12/03/mssqlspatial-intro/

best regards,

Eduardo