Sanitation
PlatformDomainsAcademyDesign SystemFeedback
v1.4
v1.4
  • Introducing Water-Sanitation
  • Water-Sanitation
    • Solution Design
    • Approach
    • Release Notes
      • FSM 1.4 - Technical Release Summary
      • Service Build Update
        • Release Builds for Core
      • MDMS Changes
      • Configuration Updates
      • Test Cases
      • Localisation
      • Impel Release Notes
      • Gate 2 Checklist
      • Workflow Configuration Changes
      • Master Migration Document
      • Driver-Individual Migration Script
  • Water-Sanitation Product Suite
    • Waste Management System
      • Functional Specifications
        • TQM UI
          • How to Enable TQM UI
          • UI: Plant Operator
            • Landing and Home Page
            • Plant-User Mapping
            • Inbox/Update Tests
            • View Past Test Results/Test's Summary Screen
            • Help Section
          • UI: ULB Admin
            • ULB Admin Home Page
            • Inbox/Test Details Screen
            • View Past Test Results
            • Create Adhoc Test
        • TQM UI/UX Audit
      • Faecal Sludge Management (FSM)
        • Features
        • Sanitation Actors & Interactions
        • User Interface Design
        • FSM User Manual
          • FSM Citizen User Manual
          • Employee User Manual
          • Manage Vendor, Sanitation Worker and Vehicle Details
          • DSO User Manual
          • Septage Treatment Plant Operator User Manual
        • Test Cases
        • FSM Functional Specification
          • Sanitation Worker UI
            • FSM Registry
            • Create Sanitation Worker
            • Edit Sanitation Worker
            • Assign Sanitation Workers to FSM Applications
            • Sanitation Worker Details
          • FSM UI Docs
            • FSM Citizen UI
            • FSM Employee UI
            • FSM DSO UI
            • FSM FSTPO UI
          • FSM UI/UX Audit
        • FSM Technical Specification
          • Vehicle Technical Specification
          • Vendor Technical Specification
          • Calculator Technical Specification
        • FSM Release Notes
          • Known Issues List
        • Product Requirement Document
        • Training
        • Sanitation Worker Welfare
          • Vendor Registry
          • FSM Service
          • Sanitation Worker( FSM 1.4) UI/UX Audit
        • FSM-DSS Technical Documentation
        • Enablement toolkits(Assetization) for FSM
          • Getting started with DIGIT
          • Requirements to enable FSM Module in a new evironment
          • Dependency services of the FSM module
          • Data templates for data collection
          • Data loading steps
            • Loading Billing Slab Data
            • Loading Vendor,Vehicle and Driver Data
            • Loading Localisations
            • Plant Mapping of FSTP
            • Creating users for FSM
          • Preparation of MDMS Data for Data Loading
          • SMS Templates for FSM
        • URC Release Notes
          • Steps to Configure URC
        • Garima Release Notes
          • Steps to Configure Garima
        • User Personas
      • Treatment Quality Monitoring (TQM)
        • Features
        • User Stories
          • Treatment Quality Monitoring Dashboard KPIs
        • User Interface Design
        • User Manual
          • Employee User Manual
          • Treatment Plant Operator User Manual
        • TQM Setup
          • User Manual
        • Release Notes
          • Known Issue List
        • Product Requirement Document: Treatment Quality Monitoring (TQM)
        • PQM Technical Specification
        • TQM Impel Checklist & Roll-out Plan
    • Water & Sewerage Connections
    • NalJal
  • Technology
    • Architecture
      • PQM
        • Low Level Design
          • Services
            • PQM Service
            • PQM Anomaly Finder
            • PQM Scheduler
      • FSM
        • Low Level Design
          • Services
            • FSM Service
            • FSM Calculator
          • Registries
            • FSM Vendor Registry
            • FSM Vehicle Registry
    • Source Code
  • Reference Implementations
    • Odisha - SUJOG
      • Functional Customisation
        • Urban-Rural Convergence
        • Garima Implementation
          • User Interface Design
          • Product Requirement Document (PRD)
      • Technical Customisation
      • Technical Specification: Urban-Rural Convergence
      • Standard Operating Procedure (SOP)
      • Program Rollout Plan
      • Implementation Plan
      • Implementation Guide
      • Implementation Checklist
      • TQM Gate 2 Plans & Checklist
  • Setup
    • Setup
      • On AWS
    • Deployment Guide
      • Legacy/Re-Indexing the FSM Data
      • Legacy/Re-Indexing the PQM Data
      • FSM devops setups
      • FSM Calculator devops setup
      • Vendor registry devops setup
      • Vehicle registry devops setup
    • Development Guide
      • Backend Developer Guide
      • UI Developer Guide
    • Configuration
      • TQM
        • PQM Service
        • PQM Anomaly Finder
        • PQM Scheduler
      • FSM
        • FSM Service
        • Vendor Registry
        • Vehicle Registry
        • FSM Calculator
    • Operations Guide
  • COMMUNITY
    • Community Project: Vehicle Tracking
      • Release Notes
        • Service Build Update
          • Release Builds for Core
        • Test Cases
      • Architecture
        • Vehicle Tracking
          • High Level Design
          • Low Level Design
      • User Manuals
        • Employee User Manual
        • Driver User Manual
      • Demo
      • Product Requirement Document (PRD)
      • Deployment Guide
      • Setup
      • Source Code
    • Contribute
    • Issues
Powered by GitBook

All content on this page by eGov Foundation is licensed under a Creative Commons Attribution 4.0 International License.

On this page

Was this helpful?

Export as PDF
  1. Water-Sanitation Product Suite
  2. Waste Management System
  3. Faecal Sludge Management (FSM)
  4. Enablement toolkits(Assetization) for FSM

Preparation of MDMS Data for Data Loading

Was this helpful?

This document shows the preparation of the mdms changes be to done for data loading.

  1. To add data in - For showing the tenant at login screen Sample Data :

DETAILS

DESCRIPTION

DATA FROM ULB

Name of ULB

(E.g.: Berhampur Municipal Corporation or Balasore Municipality or Banki NAC)

ANGUL MUNICIPALITY

ULB Census Code (Optional)

->

PIN codes covered within ULB Boundary (separate by commas)

(Eg.: 759001, 759013)

759122, 759132, 759123, 759143

District Name

->

ANGUL

District Code (Optional)

->

Helpline Phone numbers for Septic tank cleaning

(Write both Landline with Code and Mobile No. if you have, separated by commas.) (Eg.: 0674-234563, 91-9876786543)

14420

ULB's full postal Address

->

AT/PO-AMLAPADA, DIST-ANGUL, PIN-759122

ULB Email Address

->

Example : Create a json for new ulb and Add required details given.

{
    "code": "od.angul",
    "name": "Angul",
    "description": "Angul",
    "logoId": "https://digitaldesksujog051120.blob.core.windows.net/assets/Logos/odlogo.png",
    "imageId": null,
    "domainUrl": "https://sujog.odisha.gov.in",
    "type": "CITY",
    "twitterUrl": null,
    "facebookUrl": null,
    "emailId": "angulmunicipality@gmail.com",
    "OfficeTimings": {
        "Mon - Fri": "9.00 AM - 6.00 PM",
        "Sat": "9.00 AM - 12.00 PM"
    },
    "pincode": [
        759122,
        759132,
        759123,
        759143
    ],
    "city": {
        "name": "Angul",
        "localName": null,
        "districtCode": "Angul",
        "districtName": "Angul",
        "regionName": "Angul",
        "ulbGrade": "Angul Municipality",
        "longitude": 0,
        "latitude": 0,
        "shapeFileLocation": null,
        "captcha": null,
        "code": "ANG",
        "ddrName": "Angul",
        "wsBillHeaderLine1": "OFFICE OF THE AE/JE",
        "wsBillHeaderLine2": "PUBLIC HEALTH ENGINEERING ORGANIZATION : Angul",
        "districtTenantCode": "od.angul"
    },
    "address": "AT/PO-Amlapada,Dist-Angul, Pin-759122",
    "contactNumber": "",
    "helpLineNumber": "14420"
}
  1. {
        "module": "FSM",
        "code": "FSM",
        "active": true,
        "tenants": [
            {
                "code": "pg.citya"
            },
            {
                "code": "pg.angul"
            }
        ]
    }

DETAILS

DESCRIPTION

DATA FROM ULB

FSTP Plant Address

->

NUAMAUSA, PANCHAMAHALLA, ANGUL, 759132

B.2. FSTP Installed Capacity in Kilo-Liters

(Eg.: 45 KLD)

18 KLD

B.3. Plant Operation Timing Duration

(Eg.: 09:00 AM - 08:00 PM)

9.00AM-5.00PM

Eg.

{
    "PlantCode": "ANG_001",
    "PlantName": "ANGUL Plant",
    "active": true,
    "PlantType": "SeTP",
    "PlantLocation": "ANGUL",
    "PlusCode": "R3RW+7JQ",
    "PlantOperationalTimings": "09.00am-05.00pm",
    "PlantOperationalCapacityKLD": "18",
    "ULBS": "pg.angul"
}

Field Name

Description

Comments

Plus code

Copy paste the plus code of the plant location

Go to google maps , search for the plant and in the left panel you will have option to copy the plus code of the location.

Plus code is a simple digital address based out of latitude and longitude

Unique Code for Plant

This will be an unique code for the SeTP plant

For example : If the plant is the ANGUL Plant then the there can be 3 alphabets to identify the city "ANG_001 "

001 - is a running sequence number for a state.If the first row is 001 the second row can be 002.

If the second row plant is from PURI then the code can be "PURI_002"

  • {
        "id": 6,
        "boundaryNum": 1,
        "name": "GP 1",
        "localname": "GP1",
        "longitude": null,
        "latitude": null,
        "label": "GP",
        "code": "GP1",
        "children": [
            {
                "id": 11,
                "boundaryNum": 1,
                "name": "Village 1",
                "localname": "Village local 1",
                "longitude": 74.871552,
                "latitude": 31.63089,
                "label": "Village",
                "code": "VIL1",
                "pincode": [
                    143001
                ],
                "area": "V-Area1",
                "children": []
            },
            {
                "id": 12,
                "boundaryNum": 1,
                "name": "Village 2",
                "localname": "Village local 2",
                "longitude": null,
                "latitude": null,
                "label": "Village",
                "code": "VIL2",
                "pincode": [
                    143001
                ],
                "area": "V-Area1",
                "children": []
            }
        ]
    },

Example:

{
    "tenantId": "pg.rourkela",
    "moduleName": "egov-location",
    "TenantBoundary": [
        {
            "hierarchyType": {
                "code": "REVENUE",
                "name": "REVENUE"
            },
            "boundary": {
                "id": 1,
                "boundaryNum": 1,
                "name": "Rourkela",
                "localname": "Rourkela",
                "longitude": null,
                "latitude": null,
                "label": "City",
                "code": "pg.rourkela",
                "children": [
                    {
                        "id": "2",
                        "boundaryNum": 1,
                        "name": "Pradhanpalli",
                        "localname": "Pradhanpalli",
                        "longitude": null,
                        "latitude": null,
                        "label": "Locality",
                        "code": "VIL1"
                    },
                    {
                        "id": "3",
                        "boundaryNum": 1,
                        "name": "Other",
                        "localname": "Other",
                        "longitude": null,
                        "latitude": null,
                        "label": "GP",
                        "code": "OTH1",
                        "children": []
                    }
                ]
            }
        }
    ]
}

Steps to create the jsons of GP data -

  • The GP data is given in excel format.

  • Copy all the GP’s list and make an excel with format given below

id

boundaryNum

name

localname

longitude

latitude

label

code

10

1

Kodama

Kodama

null

null

GP

GUD5

11

1

M K Rai

M K Rai

null

null

GP

GUD6

12

1

Madhubana

Madhubana

null

null

GP

GUD7

  • The name and localname is the GP name provided

  • The label is always GP and boundaryNum is 1.

  • Id is unique for each GP and should be in sequential order.

  • Provide a proper format of GP code according to GPname.

  • Convert the excel data into json using excel-json online converter.

  • Check the format once,change id into string if it is in integer format.

  • Add "children": [] for each GP separately after converting to json.

  1. {
        "name": "slumname",
        "active": true,
        "code": "CODE001",
        "locality": "VIL1"
    }

Steps To Create the jsons of Slum data : The slum data is provided in excel format.

  • Make an excel with with given format

name

active

code

locality

Adibasi Sahi(Poda khaman)

true

ANAN001

VIL1

Badaharijan Sahi

true

ANAN002

VIL1

  • Add all the slums in name field

  • change the code according to ulb name

  • add locality VIL1 according to boundary-data.

  • convert the excel data into json using excel to json converter.

  • create a folder of a respective tenant and inside it add slum.json file in FSM folder.

  1. Adding New Vehicles in VehicleMakeModel Before pushing the vehicle data,new vehicle should be added in mdms.

Vehicle Make

Eg.: Swaraj, Eicher, Mahindra etc. ->

Mahindra

Vehicle Model

Eg.: Truck, Tractor, Pick Up etc. ->

Truck

GPS Tracker is present in vehicle?

YES or NO ->

No

Cesspool Tank Capacity (in Litres)

->

1000

Eg. new vehicle add

{
    "code": "MAHINDRA",
    "name": "Mahindra",
    "active": true
},
{
    "code": "MAHINDRA.TRUCK",
    "name": "Truck",
    "active": true,
    "make": "MAHINDRA",
    "capacity": "1000"
}
  1. Billing-slab pricing preparation For adding the rate slabs(pricing) of vehicles,consider different combination of propertyType , slum and tank capacity.

    1. RESIDENTIAL and RESIDENTIAL.SUB-PROPERTY_TYPE

    2. INSTITUTIONAL and INSTITUTIONAL.SUB-PROPERTY_TYPE

    3. COMMERCIAL and COMMERCIAL.SUB-PROPERTY_TYPE

    4. Sample Data for pricing :

Name of the ULB: (Write in right side box)

Anandapur Municipality

Details

Description

Vehicle-1

Vehicle-2

Cesspool Tank Capacity (in Litres)

->

1000

3000

Per trip Pricing for Residential properties

->

1000

2000

Per trip Pricing for Commercial properties

->

1000

3000

Per trip Pricing for Institutional properties

->

1000

2000

Per trip Pricing for Slum areas

->

800

1500

Steps to make billing-slab data: A. Create an excel file in given format

tenantId

capacityFrom

capacityTo

propertyType

slum

price

status

od.anandapur

0

1000

RESIDENTIAL

YES

1000

ACTIVE

od.anandapur

0

1000

RESIDENTIAL.INDEPENDENT_HOUSE

NO

800

ACTIVE

B. Consider all property types and sub-property type present in mdms with slum YES and with slum NO.

C. for capacity 1000L,the pricing is given as

For slum NO :

  1. RESIDENTIAL and RESIDENTIAL.SUB-PROPERTY_TYPE - 1000

  2. INSTITUTIONAL and INSTITUTIONAL.SUB-PROPERTY_TYPE - 1000

  3. COMMERCIAL and COMMERCIAL.SUB-PROPERTY_TYPE - 1000

For slum YES(Per trip Pricing for Slum areas) :

  1. RESIDENTIAL and RESIDENTIAL.SUB-PROPERTY_TYPE - 800

  2. INSTITUTIONAL and INSTITUTIONAL.SUB-PROPERTY_TYPE - 800

  3. COMMERCIAL and COMMERCIAL.SUB-PROPERTY_TYPE - 800

D. for capacity 3000L,the pricing is given as

For slum NO :

  1. RESIDENTIAL and RESIDENTIAL.SUB-PROPERTY_TYPE - 2000

  2. INSTITUTIONAL and INSTITUTIONAL.SUB-PROPERTY_TYPE - 2000

  3. COMMERCIAL and COMMERCIAL.SUB-PROPERTY_TYPE - 3000

For slum YES(Per trip Pricing for Slum areas) :

  1. RESIDENTIAL and RESIDENTIAL.SUB-PROPERTY_TYPE - 1500

  2. INSTITUTIONAL and INSTITUTIONAL.SUB-PROPERTY_TYPE - 1500

  3. COMMERCIAL and COMMERCIAL.SUB-PROPERTY_TYPE - 1500

E. After creating the excel file by considering the combinations,convert the excel file into json.

F. Push the same json file in billing slab api using runner.

Adding in - To enable ulb to create application,add new tenant code in FSM module.

Adding FSTP details in Required Details:

Creating Boundary data for Gram Panchayat in The GP details will be given in Annexure-5,in hierarchyType - REVENUE ,add GP data after locality data. The json format of GP is :

Add the GP data after locality data in file .

Adding Slum Details in The name of the slums will be provided.The format of slum adding in mdms is:

The code should be different for each vehicle and in format .

Required combination of property types and Sub-property types added in :

tenant/tenants.json
tenant/citymodule.json
FSM/FSTPPlantInfo.json
ULBNAME/egov-location/boundary-data.json
boundary-data.json
ULBNAME/FSM/Slum.json
make.name
MDMS
angulmunicipality@gmail.com