torsdag den 30. juli 2009

sql server and mappoint 2009, together at last


En lignende SQL Server PlugIn må komme til ArcGIS ...
/Sik


Give me an SQL Server ArcGIS PlugIn that can do the same ... bye bye SDE ...
/Sik

Quote

by Chris Pendleton

[... ]

for the first time outside the walls of Redmond, The Microsoft® MapPoint® Add-In for SQL Server

[...]


At a high level, you can now:

  • Create maps from your spatial and non-spatial data stored in SQL Server 2008.

  • Customize the display of your map data using a variety of query and retrieval options and map symbolization.

  • Query, edit, and insert individual rows in your database from the map.

  • Seamlessly integrate maps into the work you do in Office programs.


[...]


Map Management

  • Create, open, edit, and save layers

  • Reload a map file into MapPoint when creating a new map

  • Map files are stored as XML and can be edited with text editors or created by external programs

  • MapPoint will reflect any database changes when a map is re-opened.

  • Information stored in each map file include layer definitions, symbology, map extent, MapPoint base map type, current MapPoint map view and database connections


[...]


Map Layers

  • Select the data source for each layer from a list of tables with geography columns

  • Dynamically view the data source by entering a SQL Server common table expression (CTE)

  • user can select a geography column for each feature’s geography

  • user can optionally select a column to be the source for text for feature labeling on the map

  • the optional generalize distance can be entered to reduce the amount of detail for each feature

  • the optional feature limit can restrict the amount of data returned by the database

  • whether the layer is based on a table or a CTE, the user can enter a SQL WHERE clause to select specific rows

  • WHERE clauses (and the CTE definition) can contain spatial queries. For example, a WHERE clause may select only those features within a certain area contained in a row in a different table

  • WHERE clause execution can be optimized by using a parameterized query

  • SQL expressions are fully validated before being used to creating layers

  • features can be limited to a particular area of the map

  • the mapping limit can be taken from the current map view, from a selection box on the map, or the coordinates can be entered directly

  • the geometry type of the features in a layer can all be the same type, or differ (points, lines, or polygons)

  • the feature geometry shown on the map may be altered by the SQL code used to define the layer



Read more: http://www.bing.com/community/blogs/maps/archive/2009/07/30/sql-server-and-mappoint-2009-together-at-last.aspx

2 kommentarer:

  1. I recently came accross your blog and have been reading along. I thought I would leave my first comment. I dont know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often.


    Susan

    http://8080proxy.com

    SvarSlet
  2. I recently came accross your blog and have been reading along. I thought I would leave my first comment. I dont know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often.


    Susan

    http://8080proxy.com

    SvarSlet