I am looking for a model to store geographic location of some stores. My first idea, maybe dumb one, is to describe the relevant data as individual colums, something like:
id: bigserial | country: text | county: text | street: text | ...
----------------------------------------------------------------------
1 | France | Paris | Av. Charles F... | ...
2 | USA | Flodria | W South St. | ...
...
I found these ones, but are are pretty old and I am looking for suggestions/new ways or if the old ways are actually the stable and efficent ways.
Which data type for latitude and longitude?
https://dba.stackexchange.com/questions/165915/how-do-i-parse-addresses-in-postgresql
Another important thing is to use this data in feature integreation with maps and POI providers such as Google Maps.
