I'm a newbie and I'd like to realize a project based on a local OSM with postgis +mapnik +angular and leaflet.
The project requirement is :
An ACME company owns geographically distributed equipment which has to be serviced on expiry date. They already have a postgres "ACME" database with a table "equipment" {eqID,eqcustomerID eqNameid, eqAddress, eqServiceExpiryDate}. ACME database (or just a table "equipment") should be integrated into a GIS system built on a local openstreetmap server by using postgis and mapnik and have a capability to display as markers:
- all devices which servicing date is expired
- all devices of a specified customer presented by different markers which depends on expire date.
- all devices in a specified city/town
So far I got working local mapnik/postgresql server with osm data imported into the postgis database and tested with leaflet.
I know that "equipment" table should be "expanded" by long/lat values. However, I have no idea where I can put equipment data from postgres database in local osm tables and how to present them....
Any help is welcome.