![]() I have subsequently been involved with migrating our spatial data to Postgis and our corporate data (with spatial elements) to SQL Server. I subsequently was involved in MySQL, I attended/spoke at a couple of conferences and was heavily involved in the beta testing of the more GIS-compliant functions in MySQL that was finally released with version 5.5. I decided to try out MySQL and Postgis, at the time there was no spatial in SQL Server and we had a small startup atmosphere, so MySQL seemed a good fit. Ten years ago I was tasked with putting a largish - 450 million spatial objects - dataset from GML to a spatial database. I have worked with all three databases and done migrations between them, so hopefully I can still add something to an old post. I've already done some development using MySql, but I can change if necessary. It appears all 3 of these can talk with R using ODBC, so may not be an issue. I cannot find any noncommercial PostgreSQL equivalent, although I'm not opposed to paying $180 for Devart's dotConnect for PostgreSQL Professional Edition. Thanks to Connector/Net 6.3.4, MySql works well C# and. Despite the 10GB DB limit in SQL Server Express 2008 R2, I'm not sure I want to live with this and other limitations of the free version. MySql's Spatial Extensions seem comparatively minimal? Google searches suggest that PostgreSQL + PostGIS may be the strongest? At least a lot of products seem to use it. I'm weakest with PostgreSQL, but I am willing to learn if everything else checks out. What database is best for the underlying data store for all this data? Here's my desires: These records include data of at least three different types, and I will be trying to see if each set influences the other. I need to analyze a few million geocoded records, each of which will have latitude and longitude. EDIT: I have been using Postgres with PostGIS for a few months now, and I am satisfied.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |