January 27, 2010

Microsoft SQL Azure Lessons Learned Chatting With ESRI

[ 4 ] Comments
Share

Ben Riga has recorded a great episode of Lesson Learned where he chats with Rex Hansen.

In this episode of Lessons Learned I chat with Rex Hansen of ESRI.  Rex works on MapIt; a product for visualizing enterprise data on maps.  This was recently released as a on-premises product that enables developers to work with the tabular and spatial data in SQL Server 2008 and integrate that data with maps on ArcGIS online and Bing Maps.

ESRI MapIt was announced at the Microsoft Worldwide Business Partner Conference 2009. This latest product offering from ESRI is a combination of software and online services that enable you to create simple maps from your enterprise data.

I had a full write up on MapIt here: http://geo.geek.nz/esri/…

The latest version of MapIt extends functionality to Microsoft Windows Azure and SQL Azure. MapIt takes advantage of SQL Azure to consume location-based data as well as Windows Azure allowing the MapIt Spatial Data Services to be deployed as a web role.

Get Microsoft Silverlight

This episode of Lessons Learned was recorded during the Microsoft Professional Developer Conference 2009. Rex provides an overview of MapIt and walks Ben through building a Silverlight application with the ArcGIS API for Microsoft Silverlight/WPF.

For those that haven’t been able to see what MapIt offers with Windows and SQL Azure, definitely check out the video!

4 Responses To Microsoft SQL Azure Lessons Learned Chatting With ESRI

  1. Kirk Kuykendall says:
    January 28, 2010 at 6:28 AM

    Jithen – Thanks for posting this.

    I don’t see any place for a Filter Geometry here:
    http://mapit.cloudapp.net/databases/MapIt/dbo.ESRI_RO/query

    Like what’s here:
    http://sampleserver1.arcgisonline.com/ArcGIS/rest/services/Specialty/ESRI_StatesCitiesRivers_USA/MapServer/0/query

    Even though Azure doesn’t support native spatial, it seems like ESRI could filter the points. Last time I checked there’s no simple way to do a point in polygon test on the client. Even if there were, I’d still be limited to a 500 point response, right?

    • Jithen (J) Singh says:
      January 28, 2010 at 8:07 AM

      Hi Kirk,

      Yup there is no Filter Geometry since they are essentially using created X and Y fields.

      You could try and take those points and pass it off to the Geometry Server or a GP service that would filter them, then back to the client but yes you would still be limited. It’s 1000 on the MapIt REST API and this can be changed via the .config.

      Cheers

  2. Chris Spagnuolo says:
    January 28, 2010 at 7:11 AM

    Thanks Jithen. That was great.

  3. Moncler outlet shop says:
    November 17, 2010 at 5:47 PM

    …

    I discovered your blog on google and verify several of the early posts. Preserve up the good function. I just additional up your RSS feed to my MSN News Reader. Looking forward to reading through a lot more from you later on!…