3liz / lizmap-pgrouting-module Goto Github PK
View Code? Open in Web Editor NEWPgRouting module for Lizmap
Home Page: https://docs.3liz.org/lizmap-pgrouting-module/
PgRouting module for Lizmap
Home Page: https://docs.3liz.org/lizmap-pgrouting-module/
Re-launching
php lizmap/install/configurator.php pgrouting
do not ask again the questions about the SRID, pgsql group, etc. not even if deleting beforehand the folder where the pgrouting module was installed.
Bonjour, j'utilise pgrouting pour un de mes projet (version Lizmap Web Client 3.6). J'ai suivi la documentation avec une Installation manuelle du module (la dernière archive ZIP ) . Mais dès que je procède à l'installation et imprt de la couche route dans ma table pgrouting dans postgis, mon serveur ne marche plus, il me met "This web site is closed" .
Journal :
2023-12-12T08:21:45 WARNING Récupération du HTTP http://localhost/lizmap36/lizmap/www/index.php/view/app/metadata échouée avec l'erreur Error transferring http://localhost/lizmap36/lizmap/www/index.php/view/app/metadata - server replied: Application not available
2023-12-12T08:22:08 INFO État de l'application
variable d'environnement QGIS_PREFIX_PATH : C:/PROGRA1/QGIS321.0/apps/qgis
Préfixe: C:/PROGRA1/QGIS321.0/apps/qgis
Chemin des extensions: C:/PROGRA1/QGIS321.0/apps/qgis/plugins
Chemin des paquets de données: C:/PROGRA1/QGIS321.0/apps/qgis/.
Nom du thème actif: default
Chemin du thème actif: C:/PROGRA1/QGIS321.0/apps/qgis/./resources/themes\default\icons/
Chemin du thème par défaut: :/images/themes/default/
Chemins de recherche SVG: C:/PROGRA1/QGIS321.0/apps/qgis/./svg/
C:/Users/gakou/AppData/Roaming/QGIS/QGIS3\profiles\default/svg/
Chemin de la BD utilisateur: C:/PROGRA1/QGIS321.0/apps/qgis/./resources/qgis.db
Chemin de la BD d'authentification: C:/Users/gakou/AppData/Roaming/QGIS/QGIS3\profiles\default/qgis-auth.db .
Pourriez-vous m'aider s'il vous plait ?
In the Search Class, be sure that the data provided by the request is not null.
https://github.com/3liz/lizmap-pgrouting-module/blob/master/pgrouting/classes/search.class.php#L80
Add a class to check the pg routing config:
As part of the installation/configuration it is created also a "pgrouting_demo" schema, with a "edition" table in it.
This table is part of the sample projects here
and here
https://github.com/3liz/lizmap-pgrouting-module/tree/master/tests/lizmap/instances/pgrouting
anyway is unclear its function, as I can't see any mention in docs, and also I can't see any change in the table content when/after using lizmap/pgrouting.
Bonus question 1: what is the function of the JS file in media/js/pgrouting? is it mandatory? why its content is different here
and here
?
Bonus question 2: what is the function of the "qgis_plugin" table also created inside the "pg_routing" schema?
If you already have set start and end point, you only be able to move these points.
If you move the map, you are not able to get the points and move it, you prefer to restart the operation.
LWC 3.6.3 pgrouting 0.3.1 installed via composer
Behaviour with original pgrouting.js
Video del 05-03-2023 02:00:52 PM.webm
after that I've commented the from line 181 to 193,
then ,
Video del 05-03-2023 01:58:45 PM.webm
after the comments selection become drawed
Error 500. A technical error has occured. Sorry for this trouble.
mapBuilder/urls.xml: include file urls.xml of the module pgrouting does not exist ()
I've tried to reconfigure mapBuilder, mapBuilderAdmin and LCW but the result is the same
php configurator.php mapBuilder
Configuration migration is starting
Configuration migration is finished
Configuration is starting
All modules dependencies are ok
Configuration starts
Modules are configured
Configuration is finished
php configurator.php mapBuilderAdmin
Configuration migration is starting
Configuration migration is finished
Configuration is starting
All modules dependencies are ok
Configuration starts
Modules are configured
Configuration is finished
sudo php installer.php
Installation is starting
All modules dependencies are ok
Installation starts
Module mapBuilder upgraded to the version 2.1.1
Module mapBuilderAdmin upgraded to the version 2.1.1
All modules are installed or upgraded
Installation is finished
php configurator.php
Configuration migration is starting
Configuration migration is finished
Configuration is starting
All modules dependencies are ok
Configuration starts
Configuration of the module jelix
Configuration of the module jcommunity
Configuration of the module jacl2
Configuration of the module jacl2db
Configuration of the module master_admin
Configuration of the module jauthdb_admin
Configuration of the module jacl2db_admin
Configuration of the module admin
Configuration of the module lizmap
Configuration of the module mapBuilder
Configuration of the module mapBuilderAdmin
Configuration of the module wps
Configuration of the module pgrouting
SRID your are using? (default is '32633') >
PostgreSQL group of user to grant access on the schema pgrouting ? > lizmap
Which is the type of your database? (default is 'pgsql')
[0] mssql
[1] mysqli
[2] oci
[3] pgsql
[4] sqlite3
[5] sqlsrv
Use a PDO to connect to the database? ( 'y' or 'n', default is n) > y
For all tables accessible from this connection, are they name prefixed? ( 'y' or 'n', default is n) > n
Configuration of the module view
Configuration of the module action
Configuration of the module proj4php
Configuration of the module dynamicLayers
Configuration of the module filter
Configuration of the module dataviz
Modules are configured
Configuration is finished
Installation is starting
All modules dependencies are ok
Installation starts
All modules are installed or upgraded
Installation is finished
For now, the symbology is hard-coded in the JS files :
lizmap-pgrouting-module/pgrouting/www/js/pgrouting.js
Lines 239 to 272 in 4359b48
It would be nice to have the possibility to override these default symbology for the Lizmap administrator.
After road selection and deselection by refresh pgrouting button, the pointer remain holded on pgrouting mode, and switch to default pointer only after a page refresh by browser
I attach a screencast
Video del 07-03-2023 11:38:58 AM.webm
While following
https://github.com/3liz/lizmap-pgrouting-module/blob/master/docs/configuration.md
the queries to create the nodes and edges tables are depending on having imported the line vector contained in the mentioned shapefile, but this vector is not found inside
That zip file contains indeed the SQL with the INSERT statements for the nodes and edges tables, but there aren't the CREATE TABLE ones to create the necessary structure for this tables.
With concatenated dropdowns/comboboxes.
user choose a road, a separate combobox show only the door numbers in that specific road. Of course this would need to have a relation with a table with roads lines/names, and points representing the door numbers.
Trying to follow documentation here
https://github.com/3liz/lizmap-pgrouting-module/blob/master/docs/installation.md
php lizmap/install/configurator.php pgrouting
Configuration migration is starting
Configuration migration is finished
In ModuleInfos.php line 113:
No module.xml file into /home/gmanghi/www/naturalgis_demo/lizmap/lizmap-modules/pgrouting/
configure [-p|--parameters PARAMETERS] [-r|--remove] [-f|--force] [-e|--entry-points ENTRY-POINTS] [--] [<module>]
do not ask "all parameters for the PostgreSQL database access", just the other infos (SRID, role, etc.), so the next step
php lizmap/install/installer.php
fails with
Installation is starting
All modules dependencies are ok
Installation starts
[error] An error occured during the installation of the module pgrouting: error during the connection localhost
Installation is finished
I'm using LMWC 3.6.9 and PHP 8.1 and the doubt is if the path to follow is the one described in "Launching the installer with Lizmap Web Client 3.6"
or in "Launching the installer with Lizmap 3.5"
because the latter also says "If you are using Lizmap Web Client 3.6 or higher..." as the former, but maybe this just an error in the docs(?).
Any help is much appreciated.
It seems to me (correct if I'm wrong) that at the moment the module is especially targeted to use distance/length as cost.
It would be nice to support a second set of cost columns for time in minutes, or have the function compute this cost using the length column and a column that would hold the speed value.
If no routes have been found, the previous roadmap still displayed and no message is displayed.
At the moment only partial distances are shown.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.