Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Part I

An Urban Local Body (ULB) is defined as a tenant. The information which describes the various attributes of a ULB is known as tenant information. This detail is required to add the ULB into the system.

Data Table

S. No.

ULB Name*

ULB Code*

ULB Grade*

City Name*

City Local Name

...

City Code

...

District Name*

District Code*

Region Name

Region Code

...

Part II

...

 1

...

Longitude

...

ULB Website*

...

Contact Number*

...

Email Address*

...

 

...

 

...

 

...

 

...

 

...

 

...

 

...

 

...

 

...

 

...

 

...

 

...

 

...

 

...

 

Sonepur Nagar Panchayat

47

Corp

Sonepur

Sonepur

Banka

BN47

Bihar

BBD47

Contact Number*

Address*

ULB Website*

Latitude

Longitude

Email Address

GIS Location Link

Call Center No.

...

Face Book Link

Twitter Link

Logo file Path*

...

population

...

male Population

...

female population

...

workingPopulation

...

literacyRate

...

languagesSpoken1

...

languagesSpoken2

98362532657

Main Hall, Sonepur

nagarsewa.sonepur.com

24.8874° N

86.9198° E

snp@bihar.gov.in

 

 

 

 

 

...

 

...

 

...

 

...

 

...

 

...

 

...

 

...

 

...

 

...

 

...

 

Procedure

Step 1 - Download the template

Step 2 - Share via email or Share it in a pen drive to EO or City Manager

Step 3 - Please state the requirements over a call or email and explain the template to EO or City Manager

Step 4 - Please give a 10 days deadline to collate and provide the information back to eGov.

Step 5 - Please validate the data received in excel

Step 6 - Once Validated, Upload the data into the application.

Data Definition

...

Particular 

...

Explanation

...

ULB Name* 

...

 Provide the Name of ULB and is a Mandatory Field.

...

City Name* 

...

 Provide the City Name and is a Mandatory Field.

...

Local Name* 

...

 Any Local Name given to the ULB and is a Mandatory Field.

...

City Code 

...

 Provide the City Code to be sourced from LG directory for the City

...

Grade* 

...

 Provide the Grade to be sourced from LG directory for the city

...

District Name* 

...

Note: Data given in the table is a sample data.

Procedure

Data Definition

Sr. No.

Column Name 

Data Type

Data Size

Is Mandatory?

Definition/ Description

1

ULB Name

Text

256

Yes

Name of ULB. E.g. Kannur Municipal Corporation/ Saptarishi Municipal Council.

2

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.

3

ULB Grade

Alphanumeric

64

Yes

Grade of ULB. e.g. Corporation, Municipality, Nagar Panchayat etc.

4

City Name

Text

256

Yes

Name of city/ town which is covered by the ULB. E.g. Kannur/ Saptarishi.

5

City Local Name

Text

256

No

Name of the city in local language. e.g Telugu, Hindi etc.

6

District Name

Text

256

Yes

Name of the District where the city is situated

...

Address* 

...

 Provide the postal address of the city correspondence and is a mandatory field.

...

GIS Location Link 

...

 Provide the GIS Location link of the city

...

Call Center No

...

 Provide Call center number for the city

...

FB Link 

...

 URL of the Face book page of the city

...

Twitter Link 

...

 URL of the twitter page of the city

...

Logo file Path 

...

 web Path from where the logo can be downloaded. 

...

population 

...

 Provide an estimated population of the city

...

malePopulation 

...

 Provide an estimated male population of the city

...

femalePopultion 

...

 Provide an estimated female population of the city

...

workingPopulation 

...

 Provide an estimated working population of the city

...

literacyRate 

...

 Provide an estimated literacy rate of the city

...

languagesSpoken1 

...

 Common languages spoken in the city

...

languagesSpoken2 

...

 Common languages spoken in the city

...

languagesSpoken3 

...

 Common languages spoken in the city

Steps to fill data

  1. Please share the attached excel with the ULB EO

  2. Data will be filled by ULB internal team and will be validated by the ULB EO

  3. Once validated the data will be shared by EO to eGov Team

Validations

These are the mandatory fields without which the data cant be uploaded in the application

ULB Name*

City Name*

Local Name*

City Code

Grade*

District Name*

ULB Website*

Contact Number*

Email Address*

Address*

Logo *

Do’s and Don'ts

  1. 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

View file
nameTemplate Tenant Infomation.xlsx

...

.

7

District Code 

...

 Provide the District Code to be sourced from LG directory for the city

...

Region Name 

...

 Provide the Region Name to be sourced from LG directory for the city

...

Region Code 

...

 Provide the Region Code to be sourced from LG directory for the city

...

Latitude 

...

 Coordinates of the city

...

Longitude 

...

 Coordinates of the city

...

ULB Website* 

...

 URL address of the website for the state and is a mandatory field

...

Contact Number* 

...

 Provide phone numbers of the contact person and is a mandatory field.

...

Email Address* 

...

 Provide the email address of the city correspondence and is a mandatory field.

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

Contact Number

Alphanumeric

10

Yes

 Contact person phone no. of ULB

11

Address

Text

256

Yes

 Postal address of the ULB for the correspondence.

12

ULB Website

Alphanumeric

256

Yes

URL address of the website for the ULB

13

Email Address

Alphanumeric

64

No

 Email of address of ULB where the email from the citizen can be reviced.

14

Latitude 

Alphanumeric

64

No

Latitude part of coordinates of centroid of the city

15

Longitude 

Alphanumeric

64

No

Longitude part of coordinates of centroid of the city

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

  1. Download the data template attached to this page.

  2. Have it open and go through all the headers and understand the meaning as given in this document under section 'Data Definition'.

  3. Make sure all the headers, its data type, field size and its definition/ description are understood properly.

  4. In case of any doubt, please reach out to the person who has shared this document with you and discuss the same to clear out the doubts.

  5. 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.

  6. Verify the data once again by going through the checklist by taking care of each and every point mentioned in the checklist.

Checklist

The checklist is a set of activities to be performed once the data is filled into a template to ensure data type, size, and format of data is as per the expectation. These activities have been divided into 2 groups as given below.

Common Checklist

This checklist covers all the activities which are common across the entities.

To see common checklist refer to the page Checklist consisting of all the activities which are to be followed to ensure completeness and quality of data.

Entity Specific Checklist

This checklist covers the activities which are specific to the entity. There are no checklist activities exists which are specific to the entity.

Attachments

  1. Configuration data template - Tenant Information

View file
nameConfiruation data template - Tenant Information_V1.xlsx

2. Sample configuration data - Tenant Information

View file
nameSample configuration data - Tenant Information.xlsx