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
- Dynamic query creation with Array like implementation
- 'pyodbc.Cursor' object has no attribute 'callproc', mssql with django
- Driver com.microsoft.sqlserver.jdbc.SQLServerDriver claims to not accept jdbcUrl, ${SPRING_DATASOURCE_URL}: GitHub Actions
- PHP Laravel SQLServer could not find driver
- Upsert huge amount of data by EFCore.BulkExtensions
- How to locate relevant tables or columns in a SQL Server database
- Cannot delete SQL datafile (.mdf) as its currently in use
- Writing query in CTE returning the wrong output
- Group By Sum and without Group by sum Amount is different
- plan_handle is always different for each query in SQL Server Cache
- Adding a different string to a table fails
- The specified data type in the EF modelBuilder doesn't correspond to the one that is created
- SQL71561: SqlComputedColumn: When column selected
- How to Solve Error Associated with Trusted Authority
- SQL Server Data Model and Insert Performance
Related Questions in VISUAL-STUDIO-LIGHTSWITCH
- How do I install Silverlight now that it has been discontinued?
- I need syncfusion ReportViewer for Lightswitch silverlight client
- How to fix LightSwitch HTML application becoming unscrollable (more frequent on mobile)
- Lightswitch html dropdown list limits matches to 15?
- How do I make the sort on child table work properly?
- How do I keep a VS Lightswitch Combo box from timing out?
- LightSwitch Model Loading Failed in VSTS
- Debug a dll using C# 7.0 and build from VS 2017 when consumed by a LightSwitch project that can only run on VS2013
- How to add multi select checkbox at the top of the listview Visual Studio LightSwitch
- Check\Uncheck all the items in the List - Visual Studio LightSwitch
- Lightswitch: Custom button doesn't call method
- how to terminate the execution of a loop when a key is press?
- Swapping foreign site Css on the fly using Tampermonkey
- How to work with Lightswitch projects in Visual Studio 2017 professional
- Multi selection checkbox - select/unselect all in Lightswitch datagrid
Related Questions in LIGHTSWITCH-2012
- LightSwitch: Distributed transactions on Azure
- Lightswitch Desktop DataGrid "Enter" like "TAB"
- LightSwitch Metadata Missing: DataService ApplicationData
- Error MSB4184 Microsoft.LightSwitch.Publish.targets when Building project using Team Foundation Build
- Lightswitch Get text of textbox control to clipboard
- Lightswitch Multiple filtered tabs
- How to use addNew api in lightswitch
- Clear searchbox (textbox text) after query
- Flipswitch in lightswitch is going in an infinite loop
- Lightswitch load all data or run a async method synchronously
- Microsoft LightSwitch - How to write my own custom message in trace.axd
- Lightswitch screen does not appear in Visual Studio
- Consume data returned from a WCF Service Application in HTML Lightswitch
- LightSwitch VS Deployment Error Message: "Only members on the system admin role or the database owner can set the compatibility level"
- MS Lightswitch Application, add temporary fields in data table
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 # Hahtags
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.