Infrastructure Map Server General Discussion

Infrastructure Map Server General Discussion

Reply
Member
samuel
Posts: 4
Registered: ‎03-24-2008
Message 1 of 3 (222 Views)

Create Columns Geometry in Sql Server which is only point

222 Views, 2 Replies
02-06-2014 11:26 AM

We need to create a spatial table with the geometry field with only point. But when we create a table in sql server directly using the Geometry field, and when we connected at AIMS is always the same line, point and polygon.

 

I wonder how to create a table that only accepts point.

Valued Mentor
gluckett
Posts: 414
Registered: ‎10-10-2003
Message 2 of 3 (186 Views)

Re: Create Columns Geometry in Sql Server which is only point

02-11-2014 06:12 PM in reply to: samuel
SQL Server Spatial tables will always accept any type. If you mean that the legend in Studio shows Points, Lines and Polygons, then you can turn off the Lines and Polygons in Studio and then AIMS will ignore those types.

If you use MapGuide Maestro, you can completely remove the line and polygon with a checkbox.
Valued Mentor
jackie.ng
Posts: 284
Registered: ‎10-06-2008
Message 3 of 3 (183 Views)

Re: Create Columns Geometry in Sql Server which is only point

02-11-2014 07:42 PM in reply to: samuel

Unless SQL Server lets you specify some kind of geometry type constraint on that column, I doubt MapGuide/FDO would know anything about that and thus just returns all geometry types as supported.

 

You can exclude certain geometry types from showing in the legend (if that's your concern) by removing their style rules in the Layer Definition.

 

- Jackie

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!