Tamamlanmış

create mysql table with point in polygon lookup

I have MySQL running with MyIsam which supports Spatial indexes. I have a number of areas defined by large polygons with a set of lat, lon points for each polygon. My objective is to save each area with the polygon in a table and subsequently send a query to search which areas have a point (lat, lon) inside the polygon. The query needs to be super fast ( < 0.05 sec), inserting doesn't need to be so fast.

You have the following tasks:

1) Create a query to build the table. The table will have following columns: id, name, polygon (polygon defined by latitude, longitude coordinates like: lat1 lon1, lat2 lon2, ...

2) An example query to insert 3 rows into the table. which also updates the index from 3).

3) Create a spatial index on the table on for fast point in polygon search.

4) Provide two example sql queries: 1 to get rows for 1 point (provided by latitude, longitude) and 2 to get rows for multiple points where each returned row has the original points in it so that we know which point returned wich rows.

Please provide sql statements needed for each task above.

Beceriler: Veri Tabanı Yönetimi, MySQL, SQL

Daha fazlasını gör: mysql st_contains polygon, mysql polygon example, mysql polygon area, mysql polygon contains point, mysql polygon latitude longitude, st_contains polygon point example, mysql point, mysql check if point is in polygon, create mysql table form data, mysql table insert post form, create mysql table form post, php video upload insert mysql table, fcmspro create mysql table, create pdf mysql table, create mysql table text file mls, vb6 create mysql table, fpdf create pdf mysql table, php mysql table insert form, create mysql table xml, php mysql table insert delete script

İşveren Hakkında:
( 75 değerlendirme ) Goes, Netherlands

Proje NO: #17715924

Seçilen:

MzHashmi

Assalamo alaikum Sir...I can make these queries in quick manners and update you as soon as possible ..thank's

%selectedBids___i_period_sub_7% gün içinde 52%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(2 Değerlendirme)
2.4

Bu iş için 6 freelancer ortalamada $67 teklif veriyor

OutsourceMan

Hello, This is vaishali from "Hire WordPress Experts" and I am here to help you with create mysql table with point in polygon lookup . We have gone through the information provided by you. and I can assure you that Daha Fazla

$74 USD in 3 gün içinde
(131 Değerlendirme)
7.4
royalwebraisers

HI, I can help you in creating the spatial mysql query to find the point within polygon. Let me know when we can discuss in details. Looking forward for your response. Thanks.

$100 USD in 2 gün içinde
(79 Değerlendirme)
6.1
gursukh

can I help you.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(36 Değerlendirme)
5.2
mohamedmssouda

Hello Sir I am professional database administrator with experience more than 5 years in multinational companies and I am ready to start the work now and finish ASAP

$52 USD in 10 gün içinde
(15 Değerlendirme)
3.6
sudipkhan

Hello, I have designed and developed vehicle tracking system and area calculation system and some other gis application. I can do it.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0