<div>
<div class="content wysiwyg-content">
Dear Experts<br />
<br />
I have a table consisting of the following:<br />
<br />
pAddress &nbsp; &nbsp;(char50) &nbsp; &nbsp; &nbsp; &nbsp;[Property Address]<br />
pLat &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (varchar20) &nbsp;[Latitude]<br />
pLong &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(varchar20) &nbsp;[Longitude]<br />
<br />
<br />
I would like to create a view from this table that includes another column (polygon). &nbsp;The polygon value will be calculated from the pLat and pLong values.<br />
<br />
Is this possible?<br />
<br />
Thanks<br />
<br />
<br />
<br />
<br />

</div>
</div>


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






Convert Latitude and Longitude to Polygon and create view

The Global Positioning System (GPS) is a space-based global navigation satellite system (GNSS) that provides reliable location and time information in all weather and at all times and anywhere on or near the Earth when and where there is an unobstructed line of sight to four or more GPS satellites. A geographic information system (GIS) or geospatial information system is any system that captures, stores, analyzes, manages, and presents data that are linked to location(s). In the simplest terms, GIS is the merging of cartography, statistical analysis, and database technology.

GIS/GPS Programming

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.