Skip to main content
Solved

Geocoding Table in Database


Forum|alt.badge.img+1
  • Do Gooder (Customer)
  • 1 reply

Hello

I am looking to replicate something that exists in our current environment with a different system. We have a table that has a list of all possible zipcodes with information such as CBSA, Latitude, Longitude, City, State etc.

Does IFS have such a table? I have been unable to find anything like this in the IFSAPP database.

Thank you

Best answer by Mathias Dahl

​@shauns 

The coordinates we get back from the geocoding are stored as "map positions" in IFS, in an entity with the same name. Have a look in map_position_tab or why not the Map Positions screen? 🙃

View original
Did this topic help you find an answer to your question?

3 replies

Alexander Heinze
Superhero (Employee)
Forum|alt.badge.img+23

IFS Cloud creates (and geocodes) locations upon creation/update of addresses. Have a look at the Location Addresses page.


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • 1 reply
  • April 1, 2025
Alexander Heinze wrote:

IFS Cloud creates (and geocodes) locations upon creation/update of addresses. Have a look at the Location Addresses page.

Thanks Alexander. Are these stored somewhere in the IFSAPP database after creation? From my understanding it uses an API to call the geocoding from either HERE maps or Google maps and displays the information on the screen but this isnt stored anywhere. Is this assumption correct?


Mathias Dahl
Superhero (Employee)
Forum|alt.badge.img+32
  • Superhero (Employee)
  • 2842 replies
  • Answer
  • April 1, 2025

​@shauns 

The coordinates we get back from the geocoding are stored as "map positions" in IFS, in an entity with the same name. Have a look in map_position_tab or why not the Map Positions screen? 🙃


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings