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

Affiliates: 0,09 $ — how to earn
Pay with:
i agree with "Terms for Customers"
Sold: 0
Refunds: 0

Uploaded: 14.06.2015
Content: pack.7z (2048,35 kB)

Description

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 http://dev.mysql.com/doc/refman/5.6/en/spatial-datatypes.html).
Precision as here http://dimik.github.io/ymaps/examples/regions/ 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)

Feedback

0
No feedback yet.
Period
1 month 3 months 12 months
0 0 0
0 0 0
In order to counter copyright infringement and property rights, we ask you to immediately inform us at support@plati.market 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.)