Tag Info

New answers tagged

0

Mark C explained you how to store image in DB but actually, most of the time, there is absolutely no need to store image content (as blob) in a database. I would give you the advice of storing it as just a file and store the path into the database. You, then, just have to create a new varchar field containing a filepath like /images/user/my_image.png This ...


0

I found a blog posting entitled KML / KMZ data import into MySQL for use with GIS functions by Romain which looks like it will do much of what you are asking. For demonstration purposes, the KML polygons will be inserted into a simple table storing a string and a matching polygon definition.


1

This sort of thing is what humans are good at but computers aren't good at. One approach that may help is sorting the points in clockwise order, this will give you mostly what you want but will still need some manual intervention with a software package like ArcGis or QGIS. In essence find the leftest point (lowest X), if two are colinear then the one with ...


0

How would you define and determine major? How did you solve the problem with US zips? There are plenty of single zip codes that cover multiple towns or large rural areas. In your example, it appears that Lerwick is the primary population center and has sufficient people to justify its own post code district. Looks like the airport/surrounding region/town ...


0

Shetland Postcodes are quiet rural so cover a large area and other Islands http://www.doogal.co.uk/UKPostcodes.php?Search=ZE2 Lots of points with the same postcode sector. ZE2 is a multi-part polygon with a hole (donut) So the Centroid is going to be offsetted by the western islands. You will need to go to the full postcode for more accurate locations ...



Top 50 recent answers are included