National Dashboard: Steps for Index Creation
This document lists the steps required to follow to create national dashboard indexes.
Prior Knowledge of ElasticSearch
For understanding purposes, we are listing out the steps needed to be followed to create a property tax index for the national dashboard.
- 1.Open Kibana
- 2.Create an index using the following query -
1
PUT pt-national-dashboard
2
{}
3. Add corresponding field mappings for the created index -
1
PUT pt-national-dashboard/_mapping/nss
2
{
3
"properties" : {
4
"assessedPropertiesForUsageCategory" : {
5
"type" : "long"
6
},
7
"assessments" : {
8
"type" : "long"
9
},
10
"cessForUsageCategory" : {
11
"type" : "long"
12
},
13
"createdBy" : {
14
"type" : "text",
15
"fields" : {
16
"keyword" : {
17
"type" : "keyword",
18
"ignore_above" : 256
19
}
20
}
21
},
22
"createdTime" : {
23
"type" : "long"
24
},
25
"date" : {
26
"type" : "date",
27
"format" : "dd-MM-yyyy HH:mm:ss||dd-MM-yyyy||epoch_millis||dd-MM-yyyy'T'HH:mm:ss.SSSZ"
28
},
29
"financialYear" : {
30
"type" : "text",
31
"fields" : {
32
"keyword" : {
33
"type" : "keyword",
34
"ignore_above" : 256
35
}
36
}
37
},
38
"interestForUsageCategory" : {
39
"type" : "long"
40
},
41
"lastModifiedBy" : {
42
"type" : "text",
43
"fields" : {
44
"keyword" : {
45
"type" : "keyword",
46
"ignore_above" : 256
47
}
48
}
49
},
50
"lastModifiedTime" : {
51
"type" : "long"
52
},
53
"module" : {
54
"type" : "text",
55
"fields" : {
56
"keyword" : {
57
"type" : "keyword",
58
"ignore_above" : 256
59
}
60
}
61
},
62
"penaltyForUsageCategory" : {
63
"type" : "long"
64
},
65
"propertiesRegisteredForFinancialYear" : {
66
"type" : "long"
67
},
68
"propertyTaxForUsageCategory" : {
69
"type" : "long"
70
},
71
"rebateForUsageCategory" : {
72
"type" : "long"
73
},
74
"region" : {
75
"type" : "text",
76
"fields" : {
77
"keyword" : {
78
"type" : "keyword",
79
"ignore_above" : 256
80
}
81
}
82
},
83
"state" : {
84
"type" : "text",
85
"fields" : {
86
"keyword" : {
87
"type" : "keyword",
88
"ignore_above" : 256
89
}
90
}
91
},
92
"todaysClosedApplications" : {
93
"type" : "long"
94
},
95
"todaysCollectionForUsageCategory" : {
96
"type" : "long"
97
},
98
"todaysTotalApplications" : {
99
"type" : "long"
100
},
101
"transactionsForUsageCategory" : {
102
"type" : "long"
103
},
104
"ulb" : {
105
"type" : "text",
106
"fields" : {
107
"keyword" : {
108
"type" : "keyword",
109
"ignore_above" : 256
110
}
111
}
112
},
113
"usageCategory" : {
114
"type" : "text",
115
"fields" : {
116
"keyword" : {
117
"type" : "keyword",
118
"ignore_above" : 256
119
}
120
}
121
},
122
"ward" : {
123
"type" : "text",
124
"fields" : {
125
"keyword" : {
126
"type" : "keyword",
127
"ignore_above" : 256
128
}
129
}
130
}
131
}
132
}