Introduction
This page gives an overview of the tenant's information to be sourced at state level. The sheet has 29 fields which are explained below.
Data Table
S. No. | ULB Name* | ULB Code* | ULB Grade* | City Name* | City Local Name | District Name* | District Code* | Region Name | Region Code |
|---|---|---|---|---|---|---|---|---|---|
1 | Sonepur Nagar Panchayat | 47 | Corp | Sonepur | Sonepur | Banka | BN47 | Bihar | BBD47 |
ULB Website* | Contact Number* | Address* | Latitude | Longitude | Email Address | GIS Location Link | Call Center No. | Face Book Link | Twitter Link | Logo file Path* |
|---|---|---|---|---|---|---|---|---|---|---|
98362532657 | Main Hall, Sonepur | 24.8874° N | 86.9198° E |
|
|
|
|
|
Procedure
Data Definition
Sr. No. | Column Name | Data Type | Data Size | Is Mandatory? | Definition/ Description |
1 | ULB Code | Alphanumeric | 64 | Yes | It is unique identifier which is assigned to each ULB. LGD (Local Government Directory) has already assigned a code urban local bodies and the same is used here. |
2 | ULB Name | Text | 256 | Yes | Name of ULB. E.g. Kannur Municipal Corporation/ Saptarishi Municipal Council. |
3 | City Name | Text | 256 | Yes | Name of city/ town which is covered by the ULB. E.g. Kannur/ Saptarishi. |
4 | Local Name | Text | 256 | Yes | Name of the city in local language. e.g Telugu, Hindi etc. |
5 | Grade | Alphanumeric | 64 | Yes | Grade of ULB. e.g. Corporation, Municipality, Nagar Panchayat etc. |
6 | District Name | Text | 256 | Yes | Name of the District where the city is situated. |
7 | District Code | Alphanumeric | 64 | Yes | It is unique identifier which is assigned to each district. LGD (Local Government Directory) has already assigned a code districts and the same is used here. |
8 | Region Name | Text | 256 | No | Name of region district belongs to. |
9 | Region Code | Alphanumeric | 64 | No | Unique code of the region to uniquely identify it. |
10 | Latitude | Alphanumeric | 64 | No | Latitude part of coordinates of centroid of the city |
11 | Longitude | Alphanumeric | 64 | No | Longitude part of coordinates of centroid of the city |
12 | ULB Website* | Alphanumeric | 256 | Yes | URL address of the website for the ULB |
13 | Contact Number* | Alphanumeric | 10 | Yes | Contact person phone no. of ULB |
14 | Email Address* | Alphanumeric | 64 | Yes | Email of address of ULB where the email from the citizen can be reviced. |
15 | Address* | Text | 256 | Yes | Postal address of the ULB for the correspondence. |
16 | GIS Location Link | Text | NA | No | GIS Location link of the ULB |
17 | Call Center No | Alphanumeric | 10 | No | Call center contact number of ULB |
18 | Face Book Link | Text | NA | No | Face book page link of ULB |
19 | Twitter Link | Text | NA | No | Twitter page link of the ULB |
20 | Logo file Path | Document | NA | Yes | URL of logo file path to download the logo of ULB |
Steps to fill data
Step1: Download the data template attached to this page.
Step2: Have it open and go through all the headers and understand the meaning given in this document under section 'Data Definition'.
Step3: Make sure all the headers, its data type, field size and its definition/ description are understood properly.
Step4: In case of any doubt, please reach out to the respective person to discuss the same and clear out the doubts.
Step5: Start filling the data starting from serial no. and complete a record at once. repeat this exercise till the entire data is filled into a template.
Step6: Verify the data once again by going through the checklist and taking care of each and every point mentioned in the checklist.
Validations
All the fields with * sign are mandatory to be filled in. Without this information, the system configurations cannot be executed.
A “single entry” should be made against the respective column. Incase of multiple entries, continuation must be followed
Do’s and Don'ts
Please cross-check for spelling in the filled excel received from the ULB
2. District Name and Code to be cross-checked from the LG DIrectory.
Attachments
Please click below to view a template of tenant info
Please click below to view a Sample of tenant info