Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 941
  • Last Modified:

Convert Latitude and Longitude to Polygon and create view

Dear Experts

I have a table consisting of the following:

pAddress    (char50)        [Property Address]
pLat             (varchar20)  [Latitude]
pLong          (varchar20)  [Longitude]


I would like to create a view from this table that includes another column (polygon).  The polygon value will be calculated from the pLat and pLong values.

Is this possible?

Thanks




0
grantballantyne
Asked:
grantballantyne
1 Solution
 
lcohanDatabase AnalystCommented:
It should be something like:

create view get_polygon_values as
select pAddress as    [Property Address],
      pLat  as  [Latitude],
      pLong as  [Longitude],
      pLat + ';' + pLong as [Polygon]
from tablename
GO

select * from get_polygon_values


You should update the view whith whatever your mean for [Polygon] is. I just gave an example by concatenating the two fields.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now