Coordinates of regions boundaries (RU, BY, KZ, UA)

Affiliates: 0,08 $how to earn
Pay with:
i agree with "Terms for Customers"
Sold: 0
Uploaded: 14.06.2015
Content: pack.7z 2048,35 kB


Coordinates of regions boundaries   (RU, BY, KZ, UA)

Coordinates of regions boundaries. Incude Russia, Belarus, Kazakhstan and Ukraine regions. Actuality: May 2015. Archive contains SQL file that create 4 tables (for each country). Format region polygon: MySQL spatial (more
Precision as here at the highest level of quality. Crimea and Sevastopol are present, but drawing a little worse than other regions.

Additional information

Base allows you:
1) determine that region contains point by SQL query
SELECT * FROM region_ru WHERE ST_CONTAINS (ST_GEOMFROMTEXT (plgn), POINT (55.75494,37.62062))
2) determine the geometric center of the region by SQL query (for display on a map, for example)
SELECT name, ST_AsText (ST_Centroid (ST_GeomFromText (plgn))) AS cntr FROM region_kz
3) display regions on Yandex and Google maps (example included)


No feedback yet.
In order to counter copyright infringement and property rights, we ask you to immediately inform us at the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)