Links

National Dashboard: Steps for Index Creation

Overview

This document lists the steps required to follow to create national dashboard indexes.

Pre-requisites

Prior Knowledge of ElasticSearch

Index Creation Steps

For understanding purposes, we are listing out the steps needed to be followed to create a property tax index for the national dashboard.
  1. 1.
    Open Kibana
  2. 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
}
All content on this page by eGov Foundation is licensed under a Creative Commons Attribution 4.0 International License.