Preparation of MDMS Data for Data Loading
This document shows the preparation of the mdms changes be to done for data loading.
To add data in tenant/tenants.json - 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.
Adding in tenant/citymodule.json - To enable ulb to create application,add new tenant code in FSM module.
Adding FSTP details in FSM/FSTPPlantInfo.json Required Details:
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.
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"
Creating Boundary data for Gram Panchayat in ULBNAME/egov-location/boundary-data.json The GP details will be given in Annexure-5,in hierarchyType - REVENUE ,add GP data after locality data. The json format of GP is :
Example:
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.
Add the GP data after locality data in boundary-data.json file .
Check the format once,change id into string if it is in integer format.
Add "children": [] for each GP separately after converting to json.
Adding Slum Details in ULBNAME/FSM/Slum.json The name of the slums will be provided.The format of slum adding in mdms is:
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.
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
The code should be different for each vehicle and in format make.name .
Billing-slab pricing preparation For adding the rate slabs(pricing) of vehicles,consider different combination of propertyType , slum and tank capacity.
Required combination of property types and Sub-property types added in MDMS :
RESIDENTIAL and RESIDENTIAL.SUB-PROPERTY_TYPE
INSTITUTIONAL and INSTITUTIONAL.SUB-PROPERTY_TYPE
COMMERCIAL and COMMERCIAL.SUB-PROPERTY_TYPE
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 :
RESIDENTIAL and RESIDENTIAL.SUB-PROPERTY_TYPE - 1000
INSTITUTIONAL and INSTITUTIONAL.SUB-PROPERTY_TYPE - 1000
COMMERCIAL and COMMERCIAL.SUB-PROPERTY_TYPE - 1000
For slum YES(Per trip Pricing for Slum areas) :
RESIDENTIAL and RESIDENTIAL.SUB-PROPERTY_TYPE - 800
INSTITUTIONAL and INSTITUTIONAL.SUB-PROPERTY_TYPE - 800
COMMERCIAL and COMMERCIAL.SUB-PROPERTY_TYPE - 800
D. for capacity 3000L,the pricing is given as
For slum NO :
RESIDENTIAL and RESIDENTIAL.SUB-PROPERTY_TYPE - 2000
INSTITUTIONAL and INSTITUTIONAL.SUB-PROPERTY_TYPE - 2000
COMMERCIAL and COMMERCIAL.SUB-PROPERTY_TYPE - 3000
For slum YES(Per trip Pricing for Slum areas) :
RESIDENTIAL and RESIDENTIAL.SUB-PROPERTY_TYPE - 1500
INSTITUTIONAL and INSTITUTIONAL.SUB-PROPERTY_TYPE - 1500
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.
Last updated