I have Point of Interest data in MySQL. This are the fields
latitude,longitude,address,types
in which I have stored the data. Now i want to import it into PostGIS Database. But does it required geometry of this point??
which command is to be used to find nearest point with radius or distance ?
Best Answer
Bring your data into PostgreSQL with something like mysql_fdw, or other methods.
Once you have this table, add a geography column, and populate the new column:
Now select the nearest 10 places that are within 100 kms: