surveydata_road template.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN
1	userid	district	localbody	block	panch	munci	version	road_locn_lat_lng	road_points	roadid	roadname	roadcode	road_start_end_chain	roadlength	roadcategory	road_soiltype	road_terraintype	road_surfacetype	roadtype	roadlandwidth	roadformationwidthwidth	roadcarriagewaywidth	roadyear_maintain	road_img_lat_lng	road_image_path	road_remarks	imei	regtime_old	type	jn_names	jn_latlng	jn_remarks	jn_joins	roadlandwidth_	roadformationwidthwidth_	roadcarriagewaywidth_	json_status	lsgdcode	offline_id	ward_boundary_exist	ward_boundary_locn	ward_make_boundary	ownership	jn_eletricpostname	verified_status	todelete	edit_count	verified_by	merged_road_id	edited_by	update_time	messagebox	webedit	jn_name2	jn_name3	verifyroad	approved_on	externalsurvey	startchain	endchain	grid	roadcode_g	id	regtime	final_verify	sachithra_details
2	character varying(50)	character varying(50)	character varying(50)	character varying(50)	character varying(50)	character varying(100)	character varying(10)	text	text	character varying(100)	character varying(100)	character varying(100)	character varying(100)	character varying(100)	character varying(100)	character varying(100)	character varying(100)	character varying(100)	character varying(100)	character varying(100)	character varying(100)	character varying(100)	character varying(100)	text	text	character varying(500)	character varying(50)	timestamp without timezone	character varying(50)	text	text	text	text	double precision	double precision	double precision	text	character varying(100)	character varying	character varying(20)	text	text	text	text	text	character varying	character varying	jsonb	character varying	jsonb	timestamp without timezone	character varying	jsonb	text	text	jsonb	jsonb	character varying(50)	character varying(100)	character varying(100)	character varying(100)	character varying(100)	integer	timestamp without timezone	jsonb	text
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100