Tag Info

New answers tagged


Use postgresql as database, and install postgis extension, and enable the extension for your database. Then use a column similar to location GEOGRAPHY(POINT,4326) to store location. Create a index for the column using GIST index type, similar as: CREATE INDEX global_points_gix ON global_points USING GIST ( location ); Insert similar as: INSERT INTO ...

Top 50 recent answers are included