Think GIT

PG Routing Shooting Star issue

2011-01-26T04:10:00.001-08:00

In a recent project I’m using PG Routing for routing with Navteq data. To route start to stop PGRouting comes with three different algorithms.

Djikstra – classic shortest path.
Shortest Path A* – using heuristics to find the shortest path.
Shortest Path Shooting Star – using heuristics with traffic rules to find the shortest path.

The Djikstra and Shortest Path A* works fine and are pretty fast after working with the network and bounding box. When trying the algorithm Shortest Path Shooting Star there are some problems. One major problem is when starting reverse direction of the first link.

Navteq’s segments starts from south. So when calculating a route on that starts off south there is a phenomena, see image. It should a straight line from the top point to the bottom point, very badly visualized.

Tech Days 2010, blog posts and start with Bing Maps

2010-05-19T13:39:00.001-07:00

Speaking Swedish or understand Swedish? If you are interested in BIng Maps, SharePoint, DeepEarth, Microsoft and GIS you can watch my presentation at Tech Days 2010 in Örebro, Sweden the 24th of Mars this year.

Lately Johannes Kebeck, a Bing Maps TSP blogged about my favorite project SMIL. That blog post is one post in a blog series about integrating maps into SharePoint. His latest post is about integration themetic maps from SQL Server 2008 R2.

If you are intested in starting developing with Bing Maps you should really go to Bing Maps portal. Johannes Kebeck, Chris Pendleton and BingMapsDev are people you can follow on twitter to get the latest news. Another good start is to go the developer forum. When should also have a look at Deep Earth Toolkit for Bing Maps.

Creating a Silverlight Web Part for SharePoint 2007

2010-05-12T12:28:00.001-07:00

In this blog post I describe an approach to add a Silverlight Web Part in SharePoint 2007. Adding Silverlight Web Parts to SharePoint can really make magic to SharePoint, i.e. maps (my personal favorite topic), Web Parts with drag and drop support from the file system etc. I always create a Silverlight project and separate and load it to a web part. I describe my favorite approach:

Create a Web Part project, rename the Web Part and it’s files to something appropriate. I use Visual Studio 2008 extensions for Windows SharePoint Services 3.0 (version 1.2) in this example.
Create a folder name it Templates.
Create a folder name it ControlTemplates
Create a folder name it YourWebPart-name.
Choice File –> Add –> New Project. Choose web and give it a name.
Get rid of the Default.aspx file in the web project.
Add a User Control to the web project, get rid of the code behind and add your the reference to the web part assembly to the inherits of the file, example: <%@ Control Language="C#" AutoEventWireup="true" Inherits="MyNameSpace.ClassName, AssemblyName, Version=1.0.0.0, Culture=Neutral, PublicKeyToken=3283a693cab37f84" %> See understanding SharePoint for more info. The nice part now is that you can start designing the user control as with any .aspx-file, well almost. Add your .xap file and Silverlight.js-file to this project.

Add javascript and code for loading your silverlight control, i.e

<div id="silverlightMultiFileUploadControlHost" >
        <object id="MultiFileUploader" data="data:application/x-silverlight-2," type="application/x-silverlight-2" width="450" height="280">
            <param name="source" value="/_controltemplates/mPost.MultiFileUpload/mpost.SilverlightMultiFileUpload.xap" />
            <param name="onerror" value="onSilverlightError" />
             <param name="initParams" value="MaxFileSizeKB=,MaxUploads=2,FileFilter=,ChunkSize=4194304,CustomParam=[site=<%=Site%>;docLib=<%=DocumentLibrary%>;httpService=<%=HttpService%>],DefaultColor=White" />
            <param name="background" value="white" />
            <param name="onload" value="pluginLoaded" />
             <param name="minRuntimeVersion" value="4.0.50401.0" />
		  <param name="autoUpgrade" value="true" />
		  <a href="http://go.microsoft.com/fwlink/?LinkID=149156&v=4.0.5040

1.0" style="text-decoration:none">
 			  <img src="http://go.microsoft.com/fwlink/?LinkId=161376" alt="Get Microsoft Silverlight" style="border-style:none"/>
		  </a>
        </object>
        <iframe style='visibility: hidden; height: 0; width: 0; border: 0px'></iframe>
    </div>

Add properties to your .cs file. I always add a SPWeb property to access the web from the user control and make sure that the .designer.cs file has the same class name.

Go back to your web part project and add the following methods:

   protected override void OnLoad(EventArgs e)

        {

            ScriptManager scriptManager = ScriptManager.GetCurrent(Page);

            if (scriptManager == null)
            { scriptManager = new ScriptManager();

                Controls.Add(scriptManager);
            }
        }
      protected override void OnPreRender(EventArgs e)

        {

            base.OnPreRender(e);

            ClientScriptManager cs = Page.ClientScript;
            if (!cs.IsClientScriptIncludeRegistered("sl_javascript"))

                cs.RegisterClientScriptInclude(this.GetType(), "sl_ja vascript", "~/_controltemplates/mPost.MultiFileUpload/Silverlight.js");

            if (!cs.IsClientScriptIncludeRegistered("spsl_javascript"))

                cs.RegisterClientScriptInclude(this.GetType(), "spsl_javascript", "~/_controltemplates/mPost.MultiFileUpload/SpSilverlight.js");

        }

Of course you need to change the script source to your path.

Add reference System.Web.Extensions

Choóse add existing item in your web part project. Add your user control as a link (we want to compile it with the web part assembly), also add a Silverlight.js and your .xap file the same way to this folder.

You’re done, all you have to do now is to load the user control to the web part in the CreateChildControls method like:

mPost.MultiFileUploadWebPart.MultiFileUploadUC uc = (mPost.MultiFileUploadWebPart.MultiFileUploadUC)
                    Page.Page.LoadControl("~/_controlTemplates/mPost.MultiFileUpload/MultiFileUploadUC.ascx");
 Controls.Add(uc);

In 14 steps I can write shiny cool Silverlight web parts for SharePoint 2007. There are some steps, especially with the 5 part assembly that is a little tricky. Of course my favorite Silverlight web part is the one in SMIL and Silverlight Multi File Upload that has inspired this blog post. See http://slfileupload.codeplex.com/SourceControl/changeset/view/47874#1002455 for a working code example.

Technorati Tags: Silverlight,SharePoint 2007,User Control

SharePoint MultifileUpload – HTTP Handlers and “the security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again”

2010-05-04T01:32:00.001-07:00

In a current project I added a custom HTTP handler for a silverlight multifile upload web part for SharePoint. First, it’s obvious I need a client and a server pattern for make this happen. The client is just a Silverlight Web Part, nothing special nothing fancy. The server is a HTTP-handler, i.e an .ashx-file.

Integrate ASHX file into SharePoint

In order to integrate http-handler my favorite approach is to use WSPBuilder. Add a new WSPBuilder project, close it and open your .csproj file in notepad, or your favorite text editor, insert the following line right after <PropertyGroup>:

Compile the project and find your public key token, either by writing
sn –T dll-file in the .NET console window or by just adding to dll to the GAC.

Now, all you need to do is create a directory structure in the hive 12 structure. I.e 12/Layouts, it’s common practice to add a directory after Layouts, in my case MultifileUpload. The next step is just to add Generic Handler to your solution. When you’ve done that you need to reference to your assembly in the GAC on the following pattern: AssemblyName, Version, Culture, PublicKeyToken. Example:

<%@ Assembly Name="MultiFileUpload, Version=1.0.0.0, Culture=neutral, PublicKeyToken=a8aa1afe43cd31d3" %>

My complete markup is as follows:

<%@ Assembly Name="MultiFileUpload, Version=1.0.0.0, Culture=neutral, PublicKeyToken=a8aa1afe43cd31d3" %>
<%@ WebHandler Language="C#" CodeBehind="MultiFileUpload.ashx.cs" Class="MultiFileUpload.MultiFileUpload" %>

By now you’re all set, you should be able to open IIS-manager and browse to the .ashx-file and open it in a web browser. Make sure the .ashx-file is at least in the C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS folder.

In my case I uploaded files to a document library with a Silverlight web part, in order to make that to work I needed to add:

site.AllowUnsafeUpdate = true.

This is strange because I make the call from a web browser inside SharePoint, perhaps it has something to do that it is actually a Silverlight web part?

The web part and the server code is given back to the project. http://slfileupload.codeplex.com/.

More info:MSDN, myrocode.com, Mike Poulson.

Technorati Tags: SharePoint,HTTP Handler

SMIL Part 2

2010-04-25T14:30:00.001-07:00

List and Views become Layers

A fundamental part in SharePoint is Lists and Views. SMIL consider SharePoint as a platform where various applications can live and use all features from SharePoint, such as document management, issue tracking, integration to Microsoft Office etc. One web site in SharePoint is one application which can be customized and populated with specific data.

SMIL using lists in SharePoint almost as de-normalized tables in a databases and views are just as views in the database. Of course SharePoint cannot replace a database and there are drawbacks from not storing spatial information in a spatial database. However, the framework (Deep Earth and Bing Maps) SMIL is built on gives opportunities to make spatial operations in the client thanks to NetTopolgySuite and GeoAPI.

SMIL’s Layer Panel groups lists that contains geographic data, and shows every view as a layer. The upside of this is that layers are auto generated and published with SMIL’s GeoRss-feed by just creating a view in a SharePoint list. One upside of this approach is that SharePoint do filtering and anyone who has privileges can create new Layers for the users. Another nice thing is that person doesn’t have to be a GIS-specialist and learn a new tool. This approach is great to filter data that are stored in SharePoint as long as you don’t have to bother WHERE things are.

Info Window

If the user hover the mouse over a SMIL symbol an info window of that item shows. The window first shows, which list, view and item title. In this case Tasks, All tasks, Task 2. Then there are two buttons. One Open button where you can open that particular list item and continue to work with that list item, the list item opens in a new window. Of course, as shown in SMIL Part 1, there are a map in the list item view that showing the position of the item. Next to the Open button there is a Select button. If the web part is connected to another list view web part the list view web part can be filtered by SMIL’s map web part. In this way, the user stays in this window.

In the drop down list, the views that is available in that lists are listed so the user can change view to get more or less information in details-section below.

Summarize

To sum up, SMIL tries to use as much as possible that is already built in SharePoint by using the concept of lists and views. The upside is that any SharePoint administrator can create new layers with this approach.

<< SMIL Part 1

Technorati Tags: Bing Maps,Deep Earth,Maps in SharePoint,Layers,Lists,Views

SMIL Part 1

2010-04-21T13:31:00.000-07:00

This is the first of a series of posts about SMIL. This post will be an overview and the later one will be more technical.

SMIL (SharePoint Map Integration Layer) is an open source project with the aim to geo-enable SharePoint. After all, almost all information has a location, almost 94% according to some. So geo-enable SharePoint makes sense. SMIL takes advantages of all the juicy stuff in SharePoint, document management, images, versioning, workflows etc and adds a geo-layer above SharePoint.

SMIL, is built with Bing Maps Silverlight control as map control with Deep Earth Toolkit on top.

Each list that contains geographical information, i e has SMILs custom datafield, are exposed via GeoRss-feeds. Also, the list is per default a group in a layer panel and each view in SharePoint a layer in the layer panel. There are many advantages with this approach since any SharePoint administrator or power user can build, and customize views, and filtering data from SharePoint.

After installation, the next blog post, you have SMIL running you can easily geo-tag any document, issue, task. For example you can start planning issues according to where they are and how an issue is in geographical relationship with issue. Or you might have resource planning tool in SharePoint and you want to know where things are. Do you have a lot of contracts for real estates - you can add them on a map. There are many applications and people tend to like maps!

List and List Items

In order to geo-reference list items in SharePoint all you have to do is to add a column with the custom data field, SMIL.Coordiante to a list. Then you can just start to add push pins to represent the location of the item or you can search for a location. If you view the item, the map is still interactive but you cannot move the pushpin, you need to edit the SharePoint item to do that – standard SharePoint.

As mentioned SMIL using SharePoint filtering to filter data, but you can select surrounding information in SharePoint from a selected item in a map, if you have connected the Web Part to a corresponding List View Web Part. Each item has an info box on the map displaying metadata from that item inte SharePoint and you can change the view to get more or less information of that item. The idea is to have a short description view and a detailed view.

Images

SMIL also extract EXIF information from geo-tagged images and plot thumbnails on the map. If you don’t have a camera that stores coordinates along with the EXIF information you can just geo-reference them in SharePoint just as with any other list item, by using SMIL’s default geo-referencing tool.

Part 2 >>

Technorati Tags: SharePoint,Maps,Map,GIS,Bing Maps,DeepEarth,Sivlerlight,EXIF

This blog will be in English from now on

2010-04-21T12:41:00.001-07:00

Due to my work in different open source projects, Deep Earth and SMIL, this blog will know be in English from now on.

DeepEarth Toolkit för Bing Maps

2010-02-25T13:36:00.001-08:00

Det är bekräftat. Jag ska hålla en session på Tech Days i år. Sessionen kommer att handla om DeepEarth Toolkit för Bing Maps. Det kommer att handla om hur du kan integrera in kartor i SharePoint och hur du där kan hantera bilder, listor, dokument etc. Sen kommer jag förhoppningsvis hinna visa exempel på exempel på hur man kan berika sin applikation med multitouch.

Välkommen.

Reflektion Webbseminarie - Data på Karta

2010-02-09T06:23:00.000-08:00

Förra veckan hade vi ett webbseminarie "Data på Karta- Visualisera Mera med SharePoint". Det var drygt 150 anmälda och ungefär 110 medverkade på seminariet. Att arrangera ett webbseminarie är en annorlunda och spännande erfarenhet. Kan tänka mig att det påminner en hel del om att sända radio.

Kort sammanfattning från seminariet. Peter Nicks (Produktchef SharePoint i Sverige på Microsoft) inledde med nyheter i SharePoint 2010. Därefter annonserade Carla Parry, Bing Maps Team i England, att Microsoft kommer på kartdagarna i år! Sen presenterade vi SMIL och en produkt från IDV Solutions.

Det var ett par saker som annonserades, bl a att SMIL är gratis för våra kunder. Vi spelade in seminariet och du kan se det här: http://www.swecosundsvall.se/~perf/datapakarta/index.htm

Avatar och 10-talet.

2010-01-10T10:47:00.001-08:00

Var och såg Avatar. Grymma kartapplikationer och en försmak av som kan förväntas under 2010-talet. Med dagens 3d-applikationer från Google och Microsoft kan förväntningarna inte vara lägre ställda. En kort subjektiv tillbakablick på sisådär 40 år :-)

70-talet var IBMs
80-talet Apples
90-talet Microsofts
00-talet Google
10-talet ?

Kommer Apple komma tillbaka i o m IPhone som en användares primära enhet? Köpte en HTC HD2 nyligen, 1 Ghz CPU med > 400 MB RAM! Det är alltså en telefon, eller hur? Jag tror att OpenSource kommer att explodera under 10-talet. Microsoft och Google kommer naturligtvis växa sig starkare. Open Source kommer också växa sig starkare på Windows. Och slutligen, vilken mobiltillverkare kommer Microsoft att köpa upp för att komma åt marknadsandelar?

GetPivot

2009-12-16T02:04:00.000-08:00

Såg Pivot på SoulSolutions sida. Först funderade jag på vad man kan använda det till. Kolla http://www.getpivot.com/. Kolla tillämpning på http://memorabilia.hardrock.com/. Man skulle t ex i SharePoint kunna dynamisk bygg upp navigeringen enligt metadata och sen klicka sig fram till olika items. Bildbibliotek, dokumentbibliotek, kontaktkort. Det ska bli intressant att följa utvecklingen.

Bing Map Beta ute

2009-12-15T13:46:00.001-08:00

Bing Map släpper en SilverLight Beta, rätt coola lösningar med SilverLight förståss. MS har verkligen lyckats få in Photosynth i Bing Maps. Synd bara att få Europeiska städer finns med. Men häftigt att gå längs NYC eller Las Vegas gator. Kolla beta på http://www.bing.com/maps/default.aspx?q=&mkt=en-US&setlang=match&uid=A122C07E&FORM=W0FD&smkt=en-GB

Silverligth Magnifier

2009-10-11T01:21:00.001-07:00

DeepEarth projektet har utvecklat ett förstoringsglas till Bing Maps. Roligt och ett annorlunda exempel på vad som kan förväntas för på Bing Maps på Silverlight. S exempel på http://kongo.swecosundsvall.se/magnifier

Multitouch + kartappar

2009-10-03T00:46:00.001-07:00

En hårdvaruleverantör kommer att skicka mig hårdvara för att utvärdera och utveckla multitouch applikationer på. Har du en såndan hårdvara redan idag kolla till denna blog då och då.

Maps + Movie

2009-09-28T14:31:00.000-07:00

E4-Sundsvall är ett exempel på hur man kommer kunna kombinera kartor och multimedia nu när tekniker som SilverLight, Flash, Flex etc blir mer och mer utbrett. Kartan är Bing Maps och filemn finns hos vägverket och sann mashup-anda.

Karta + Penna

2009-09-24T11:03:00.000-07:00

En Wii-kontroll, en lödkolv, lite motstånd, en IR-lampa, en whiteboardpenna. Med dessa ingredienser går det att bygga en simulerad touchscreen. Även multitouch. Se filmen när vi leker med en kartapp vi byggt.

Mer info för hur du kommer igång finns på http://johnnylee.net/projects/wii/

Nominerad

2009-09-18T04:24:00.000-07:00

Vi är nominerade i .NET Awards 2009 för vår SharePoint integration SMIL (SharePoint Map Integration Layer), aka Kongo!!!

Maps and Media

2009-09-15T06:20:00.000-07:00

SilverLight, även Flash och Flex, öppnar för nya intressanta kartlösningar. Här är en demo på vad vi kan förvänta oss http://kongo.swecosundsvall.se/maklare/

Seminarie dags

2009-09-10T12:23:00.000-07:00

Så, då är det dags. Den 29e oktober kommer ett seminarie som handlar om Microsoft GIS hållas i Sundsvall. Det ska bli intressant att se uppslutningen. Självklara saker att ta upp är SQL Server 2008, Bing Maps och hur man kan publicera geografisk data i SharePoint.

Några andra intressanta saker kan vara bildhantering, dokument på karta etc samt vad vi gör i Deep Earth projektet, http://deepearth.codeplex.com/.

2009-08-29T07:19:00.000-07:00

Think GIT

Nästan all information som generas i system har ett geografiskt läge. Denna blogg ska handla om det.