I have installed a tile server using the following link and my main purpose was to geocode as many times as possible. Initially I was using openstreet API to geocode but they have certain limits so they suggested me to build my own server. In my current server I have loaded the California data into PostgreSQL server and now want to use it as a geocoder. If you see their server running process :
Testing your tileserver
Now that everything is installed, set-up and loaded, you can start up your tile server and hopefully everything is working. We’ll run it interactively first, just to make sure that everything’s working properly. Remember to substitute your username again:
sudo mkdir /var/run/renderd
sudo chown username /var/run/renderd
sudo -u username renderd -f -c /usr/local/etc/renderd.conf and on a different session:
service apache2 reload
My server is also running without any error as you can see in the below picture.
How can I use it to extract latitude and longitude of my addresses?
There is no information regarding this on the link. My database contains the following table here and data is loaded. I want to extract latitude/longitude from it and pass as many queries as possible.
List of relations
Schema | Name | Type | Owner
--------+--------------------+-------+------------
public | planet_osm_line | table | openstreet
public | planet_osm_nodes | table | openstreet
public | planet_osm_point | table | openstreet
public | planet_osm_polygon | table | openstreet
public | planet_osm_rels | table | openstreet
public | planet_osm_roads | table | openstreet
public | planet_osm_ways | table | openstreet
public | spatial_ref_sys | table | openstreet
