Is MySQL’s GIS really worth using? Is GIS worth using in MySQL? In the past few post, I have explored what GIS is and how it is used. GIS encoded data is wonderful and can help with all kinds of cool queries. I’m late getting this article written so lets get right to it. The [...]
WHAT CAN YOU DO WITH GEO DATA? Geo spatial indexes are what make this type of data valuable. With shape and point data you can find relationships between object in our physical world. How close is the lightning in the storm front? What homes where hailed on? (WDT) What schools are in my city? With a [...]
What data is available? GEO data is expensive to create, so has been created by governments. In the past governments charged for this data. In 1980 the USGS was charging $300 (usd) per county for Oklahoma GEO data. (I complained to my congressman.) Today, a quick Internet search turns up lots of free GIS data. I was [...]
In my business (weather) we use lots map based (Geo) information. Almost every table has latitude and longitude. Working with this kind of data can be exciting and frustrating. This should give you a quick start into GIS with MySQL. “A geographic information system (GIS), or geographical information system, is any system that captures, stores, [...]