Use Graphic Geometry with a SQL Server spatial query

Permanently deleted user

July 20, 2017 02:16

I would like the user to draw a polygon graphic, then pass the graphic to a sql query in a workflow.

 

How can I convert the graphicgeometry to be suitable in a sql server spatial query.

 

I can only think of parsing the polygon graphic to build a string of coords that could be passed into the sql query.

 

Anyone tried this before?

0

• 

  Permanently deleted user

  August 16, 2017 18:43

  Mark, 

   

  Have you heard back from anyone regarding your initial posting?

   

  I too have a need to take the polygon (geometry) results from a "DisplayCaptureGeometry" and am trying to feed that into a SQLQuery

   

  Walter

  0
• 

  Permanently deleted user

  August 16, 2017 23:20

  Hi Walter, No I have not heard anything on this front, and I have not had time to follow it up.. I will start looking into more seriously when I get a project out of the way. But I will be watching your post with interest.

  0
• 

  Permanently deleted user

  August 16, 2017 23:21

  Link to Walter's related post (In case I forget)

   

  https://support.geocortex.com/essentialsGSCForum?id=906f20000000CP4AAM

  0
• 

  Permanently deleted user

  August 17, 2017 07:55

  Hi Mark,

   

  “ I can only think of parsing the polygon graphic to build a string of coords that could be passed into the sql query. ”

   

  Yes, that would be a way but do you have limitation that you cannot use a query task that does that for you already?

  0
• 

  Permanently deleted user

  August 17, 2017 21:56

  Thanks Francesca, I was wanting to pass to sql server to build some complex queries for reporting purposes, so the standard query task will not give what I want.

  0

Please sign in to leave a comment.