Develop query for PostgreSQL/PostGIS

$10-30 AUD

Selesai

Disiarkan

sekitar 9 tahun yang lalu

$10-30 AUD

Dibayar semasa penghantaran

I have street name data in a PostgreSQL database. PostGIS is installed. The table "map_data" has many fields, but the important ones are ID (Intenger) NAME(char) the_geom(geometry(LineString,4326) Using the inputs Latitude and Longitude I need to return the streen name. Query may need to find nearest street if the co-ordinates do not fall exactly on street.

Geolocation

Geospatial

PostgreSQL

ID Projek: 7649099

Tentang projek

4 cadangan

Projek jarak jauh

Aktif 9 tahun yang lalu

Ingin menjana wang?

Alamat e-mel

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda

Dapatkan bayaran untuk kerja anda

Tuliskan cadangan anda

Ianya percuma untuk mendaftar dan membida pekerjaan

Dianugerahkan kepada:

@AlexYes

Hi, Thanks for inviting me! I have the experience of developing such kind of queries. Regards, Alex.

$25 AUD dalam 1 hari

5.0

(29 ulasan)

5.8

4 pekerja bebas membida secara purata $60 AUD untuk pekerjaan ini

@andrewharvey4

...I don't have a one liner solution, but can put together a PL/pgSQL function for this. Cheers, Andrew

$168 AUD dalam 1 hari

0.0

(0 ulasan)

0.0

@pavelmoskotin

Good Day! I have experience with Postgres geometry and may quickly turn back to you with proposed solution on the task mentioned. Will be glad to hear, best regards, Pavel.

$25 AUD dalam 3 hari

0.0

(0 ulasan)

0.0

@krunalrp15

i have worked on postgresql to develop gis based applications from more than 3 years.

$40 AUD dalam 2 hari

0.0

(0 ulasan)

0.0

@adrase

I can do this. I work with PostGIS on daily basis. I do spatial analysis with milions of records. This is simple query with postgis functions.I can write procedure for you that will return street name from latlong inputs or simple query, what you prefer. I guarantee you will be pleased.

$23 AUD dalam 1 hari