none
GIS/Geographical/Spatial alerts with StreamInsight

    Question

  • Hey,

    I wish to use StreamInsight to do geographical/spatial queries on a time window, examples of such queries:

    1. Did person X go to zone Y.

    2. Did person X meet with person Y.

    I read the documentation of StreamInsight, and I understand that it is possible, but I was wondering if there are any samples of GIS queries like I wrote above, in order to save me some time in the implementation.

    The data is assumed to be retrieved once per ~hour, and it consists of detentions with Longitude, Latitude and an identifier for that detection (unique).

    Thanks,

    Adam

    Monday, September 23, 2013 8:53 AM

Answers

  • Yes, it is possible.

    The only sample that I am aware of is in the LinqPad samples for StreamInsight. When you install LinqPad, go to Samples ... Download/Import More Samples. The StreamInsight samples will be there.


    DevBiker (aka J Sawyer)
    Microsoft MVP - Sql Server (StreamInsight)


    Ruminations of J.net


    If I answered your question, please mark as answer.
    If my post was helpful, please mark as helpful.

    • Marked as answer by adamfbs Monday, September 23, 2013 11:57 AM
    Monday, September 23, 2013 10:24 AM
  • You didn't find the geo example in the LinqPad samples?

    It's under 101 StreamInsight Queries ... 2_Query Patterns ... 10. Working with Geography Data.


    DevBiker (aka J Sawyer)
    Microsoft MVP - Sql Server (StreamInsight)


    Ruminations of J.net


    If I answered your question, please mark as answer.
    If my post was helpful, please mark as helpful.

    • Marked as answer by adamfbs Tuesday, September 24, 2013 8:26 AM
    Monday, September 23, 2013 1:23 PM

All replies

  • Yes, it is possible.

    The only sample that I am aware of is in the LinqPad samples for StreamInsight. When you install LinqPad, go to Samples ... Download/Import More Samples. The StreamInsight samples will be there.


    DevBiker (aka J Sawyer)
    Microsoft MVP - Sql Server (StreamInsight)


    Ruminations of J.net


    If I answered your question, please mark as answer.
    If my post was helpful, please mark as helpful.

    • Marked as answer by adamfbs Monday, September 23, 2013 11:57 AM
    Monday, September 23, 2013 10:24 AM
  • Thanks, I didn't find something related to spatial/GIS queries, but I will try to find an example that is close to what I'm looking for.
    Monday, September 23, 2013 11:57 AM
  • You didn't find the geo example in the LinqPad samples?

    It's under 101 StreamInsight Queries ... 2_Query Patterns ... 10. Working with Geography Data.


    DevBiker (aka J Sawyer)
    Microsoft MVP - Sql Server (StreamInsight)


    Ruminations of J.net


    If I answered your question, please mark as answer.
    If my post was helpful, please mark as helpful.

    • Marked as answer by adamfbs Tuesday, September 24, 2013 8:26 AM
    Monday, September 23, 2013 1:23 PM
  • Thanks, was searching but couldn't find it at first :)
    Tuesday, September 24, 2013 8:26 AM