MySQL Geometry Query

$10-30 AUD

Fullført

Lagt ut

over 6 år siden

$10-30 AUD

Betalt ved levering

I currently have a MySQL Geometry database which is filled with MultiPolygons. I need to retrieve all polygons within a certain radius (for example 100km) of a given point. I looked at ST_Buffer but not sure if this will work. All I need is someone to make the query for me and for it to work. To give you the table names for this query, please see below a query used for DIFFERENT application. It retrieves 1 polygon for each point: SELECT * FROM raw_sa1regions2011 where st_contains(SHAPE, point(117.83433, -35.0005)); I need this job done URGENTLY (and if you can't do it instantly, you can't do it)

Database Administration

MySQL

PHP

Software Architecture

SQL

Prosjekt-ID: 15821542

Om prosjektet

9 forslag

Eksternt prosjekt

Aktiv 6 år siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

Tildelt til:

@softechk

Hello, I have reviewed your project [login to view URL] mentioned in the project description, you want to retrieve all polygons within a certain radius of a given point in your MySQL Geometry database. It can be done using ST_Intersects and ST_Buffer in MySQL query. You may provide the sample data so that I can test the MySQL query on my side and provide you working MySQL query. Thanks.

$24 AUD om 1 dag

4,9

(44 omtaler)

5,2

9 frilansere byr i gjennomsnitt $64 AUD for denne jobben

@wpmonsters

Hello, We are the team of professionals called WordPress Monsters and we would be happy to help with your project! We're trully comfortable working with WP as we have remarkable experience in this sphere. Over the last 2 years we have helped businesspeople to breath new life into their projects. Today we can call ourselves experts in building personal blogs, landing pages and online stores. Thank you for taking time to read our application. Let me know if you have any questions and when you would like to discuss the project details. Best regards.

$350 AUD om 3 dager

5,0

(19 omtaler)

5,2

@Lionanaimal

i need 2 hours maximum to fix it i am a javascript expert who is mastered in JQuery Regards Relevant Skills and Experience . Proposed Milestones $60 AUD - all

$60 AUD om 1 dag