{"id":7933,"date":"2019-01-29T02:58:01","date_gmt":"2019-01-29T01:58:01","guid":{"rendered":"http:\/\/www.sigterritoires.fr\/?p=7933"},"modified":"2019-01-30T06:30:13","modified_gmt":"2019-01-30T05:30:13","slug":"how-to-develop-a-pgrouting-application-in-windows-6-setting-up-geoserver","status":"publish","type":"post","link":"https:\/\/www.sigterritoires.fr\/index.php\/en\/how-to-develop-a-pgrouting-application-in-windows-6-setting-up-geoserver\/","title":{"rendered":"How to develop a pgrouting application in Windows (6): Setting up Geoserver"},"content":{"rendered":"\n

We have discussed in previous articles how to set up the network data\nfor pgrouting and how to develop a wrapper to search the route between two\npoints. <\/p>\n\n\n\n

Here we will discuss how to set up Geoserver to provide the result of\nthe wrapper as a WMS or WFS layer to be used in a web page using OpenLayers 3\n(next article) .Among all the Postgres \/ Postgis<\/a> \/ Geoserver \/ OpenLayers\nchain, this part is, still, the simplest. We simply have to set up a Workspace,\na   Data Warehouse, and a layer using the wrapper SQL query developed in\nthe previous article. <\/p>\n\n\n\n\n\n\n\n

Setting up a workspace<\/strong> <\/p>\n\n\n\n

For the entire Geoserver setting up, you must log in as administrator to\nthe administration interface. \n\nOnce logged in, click Workspaces<\/em> in the Data<\/em>\nmodule (left menu) and click Add New Workspace.<\/em><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Fill in the two fields with a name for the workspace (here pgrouting)\nand the domain address (http:\/\/pgrouting.org), then click the Send<\/strong>\nbutton . <\/p>\n\n\n\n

Setting up a data warehouse<\/strong> <\/p>\n\n\n\n

Click Warehouses<\/em> in the Data<\/em> module on the left menu and\nclick Add New Warehouse.<\/em> \n\nOn the list of Vector data sources, select PostGIS<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The warehouse configuration page opens  \n\n\n\n<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

In the workspaces list select the workspace that has just been created:\npgrouting, and give a name to your data source (here itineraries<\/em> ). <\/p>\n\n\n\n

Fill in the correct connection details for your Postgres database: the\ndatabase is the name of your Postgres database containing the network tables, a\nusername and login password. Avoid using the postgres username for obvious\nsecurity reasons. Create a username with rights only on the data necessary for\nyour application. <\/p>\n\n\n\n

The rest of the information can be left the same. \n\nClick the Save<\/strong> button . You will have the\nconfiguration page of a new layer.  \n\n\n\n<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nClick\non Configure a new SQL view<\/em><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Assign a name to the display and enter the last sql query that we tested\nin the previous article: <\/p>\n\n\n\n

SELECT ST_MakeLine (route.geom) FROM (SELECT geom\nFROM pgr_route_entreAetB (‘ways’,% x1%,% y1%,% x2%,% y2%) ORDER BY seq) AS\nroute<\/em> <\/p>\n\n\n\n

But at this stage you do not need to enter true coordinate values: we\nreplace them with variables. The values \u200b\u200bof these variables will be WMS or WFS\nparameters that will be received. \n\nIn SQL View Settings,<\/strong> click Guess\nSettings From SQL<\/em> .  \n\n\n\n<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

You must enter default values. They will be used in case of request\nwithout coordinates. <\/p>\n\n\n\n

Enter the following string   ^ -? [\\ d.] + $ in Regular\nValidation Expression.<\/strong> The user will,only, be entitled to enter numbers in\nthe variables. \n\nIn Attributes<\/strong> , click Refresh<\/em> . \n\n\n\n<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Modify the geometry type to match the geometry returned by the sql query\n(in this case a LineString) as well as the return SRID (here 4326). <\/p>\n\n\n\n

Click Save<\/strong> . <\/p>\n\n\n\n

It only remains to set up the rest of the parameters for the layer. In\nour case it is enough to make sure that the native SRIDs and data are the needed\nfor our application. \n\nFor native SRID, as explained when setting up\nthe network tables, pgrouting works exclusively in 4326 (latitude \/ longitude).\nOn the other hand, in our WEB page (which we have not discussed yet) we will\nuse OpenStreetMap as a base map. Therefore, we need to set up the Geoserver\noutput in EPSG: 3857 (the SRID used by OSM).\n\n\n\n<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Do not forget to change CRS management<\/strong> into a CRR re-projecter\nfrom native to the CRS stated<\/em> . <\/p>\n\n\n\n

Click Emprises<\/strong> -> Based on Data<\/em> and   Calculated\non native emprises<\/em> to complete the layer configuration. <\/p>\n\n\n\n

Click Save<\/strong> . \n\nMake sure you have everything set up by clicking\nLayer Preview and selecting OpenLayers. You must get the route between the\npoints you entered as default points:  \n\n\n\n<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

You have completed the Geoserver setting up. <\/p>\n","protected":false},"excerpt":{"rendered":"

We have discussed in previous articles how to set up the network data for pgrouting and how to develop a wrapper to search the route between two points. Here we will discuss how to set up…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"give_campaign_id":0,"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"sfsi_plus_gutenberg_text_before_share":"","sfsi_plus_gutenberg_show_text_before_share":"","sfsi_plus_gutenberg_icon_type":"","sfsi_plus_gutenberg_icon_alignemt":"","sfsi_plus_gutenburg_max_per_row":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[1260],"tags":[],"class_list":["post-7933","post","type-post","status-publish","format-standard","hentry","category-non-classe-en"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p6XU0A-23X","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/7933","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/comments?post=7933"}],"version-history":[{"count":0,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/7933\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/media?parent=7933"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/categories?post=7933"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/tags?post=7933"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}