I am using sql server 2008. I attempted to use geography data type. But i'm using lightswitch 2012 and it doesnt' support geography so I have to change the data type for long/lat. Whats the best practice in this case? decimal(9,6) ???
Best practice on how to store geography
231 Views Asked by Sirus At
1
There are 1 best solutions below
Related Questions in SQL-SERVER
- SQL server not returning all rows
- Big data with spatial queries/indexing
- Conditional null constraint on Null
- SQL Query - Order by String (which contains number and chars)
- Optimising a slow running SQL Server Stored procedure ordered by calculated fields to return a closest match
- Dynamics CRM Publishing Customizations - Multi Developers
- Is there anyway to set the relationship of many tables from Model?
- Implementation of Rank and Dense Rank in MySQL
- ORM Code First versa Database First in Production
- MVC : Insert data to two tables
- Data streams in case of Merge
- table with multiple IDs but seperate notes need sorting (Tried SQL code to make a union query)
- SQL table Partitioning by Year with ColumnStore index implemented on the table
- Defining which network to use for SQL Server 2012 Management Studio
- Fill a week days in a table with preceding Sundays value
Related Questions in VISUAL-STUDIO-LIGHTSWITCH
- Create a custom Lightswitch control that mimicks the lookup function
- How to change TextAlignment by code? LightSwitch 2013
- How Does the Silverlight Client Talk to the Server in a 3 Tier Lightswitch Application?
- Cannot build Lightswitch project after adding a datasource
- lightswitch html client input validation not updated
- JavaScript executes and works on MSVS but doesn't work when published
- Lightswitch HTML Client: How to re-render an item (re-execute postRender callback)
- Publishing Lightswitch localy
- Performance of the LightSwitch HTML Client's Tables_SingleOrDefault and Tables.filter operations
- Lightswitch Cannot read property 'read' of undefined
- lightswitch create cusom table/list with javascript
- How to implement Collapse/Expand in LightSwitch 2013?
- How to setup MS SQL for Lightswitch intrinsic deploy - exception occurred when building the database for the application
- Lightswitch DesignTimeSafeException
- Linq to SQL query filter with Lightswitch computed property
Related Questions in LIGHTSWITCH-2012
- How Does the Silverlight Client Talk to the Server in a 3 Tier Lightswitch Application?
- Entity saved successfully but still showing "Save operation failed ok"
- Navigate back in Lightswitch (HTML5) on iOS 7 devices
- LightSwitch Object Reference Issue during migration from VS2012 Update 3 to VS2013 Update 1 RC
- WCF RIA in LightSwitch: cardinality of Association
- Best practice on how to store geography
- Lightswitch can't connect to the database on local development (VS 2012)
- Integrate Lightswitch HTML deployed as Web Site with Windows Azure Active Directory
- LightSwitch Programmatic Move between screens
- copying one record to another in lightswitch
- Selected Item of Visuual Collection is not set in LightSwitch while changing the selection in Screen
- Predefined Add Dialog not working as expected in Lightswitch 2012
- Set related entity to current user in HTML Client
- Users and Employees table
- Displaying current month unpaid customer in lightswitch
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Yes using decimal(9,6) would be the best approach in your case.
Actually, Latitude is still easy to deal with. It's about 69 miles per degree.
Longitude is a little more complex, since 1° of longitude = (69.11) x (cosine of the latitude).
You may check out the Spatial data-types which are specially made for these purposes.