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 :
My question is how can I use it to extract latitude and longitude of my addresses? There is no information regarding this on the link and I would really appreciate if any could help me here. 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
أكثر...
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.
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 question is how can I use it to extract latitude and longitude of my addresses? There is no information regarding this on the link and I would really appreciate if any could help me here. 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
أكثر...