v.db.reclass(1) 	      Grass User's Manual	       v.db.reclass(1)



NNAAMMEE
       vv..ddbb..rreeccllaassss   -  Changes vector category values for an existing vector
       map according to results of SQL queries.
       _(_G_R_A_S_S _V_e_c_t_o_r _P_r_o_g_r_a_m_)

SSYYNNOOPPSSIISS
       vv..ddbb..rreeccllaassss
       vv..ddbb..rreeccllaassss hheellpp
       vv..ddbb..rreeccllaassss  [	--dd]  ttyyppee==_n_a_m_e	iinnppuutt==_n_a_m_e   oouuttppuutt==_n_a_m_e    ttaabbllee==_n_a_m_e
       [kkeeyy==_n_a_m_e] rruulleess==_n_a_m_e [TTIITTLLEE==_n_a_m_e]

DDEESSCCRRIIPPTTIIOONN
       _v_._d_b_._r_e_c_l_a_s_s  allows  a	user  to  create a new vector map based on the
       reclassification of an existing vector map.  The user provides the pro-
       gram  with  a  rules  file, input vector map name, an output vector map
       name, and the type of input map, table, key.  There is an option (d) to
       dissolve  common boundaries between adjoining map areas of the same re-
       classed category value.


       NNoottee:: The dissolve option will work on only those areas	which  are  of
       the same conversion category value.  If a map area is inside (island) a
       converted area and is NOT converted to the same value,  its  boundaries
       are output to the resultant map.

CCOOMMMMAANNDD LLIINNEE OOPPTTIIOONNSS
   FFllaaggss::
       --dd     Dissolve common boundaries (default is no) .






   PPaarraammeetteerrss::
       ttyyppee==_n_a_m_e
	      Select area, line, or site.
	      Options:	area, line, site (multiple allowed)

       iinnppuutt==_n_a_m_e
	      Vector input map name.

       oouuttppuutt==_n_a_m_e
	      Vector output map name.

       ttaabbllee==_n_a_m_e
	      Database table.

       kkeeyy==_n_a_m_e
	      Column corresponding to cats in vector map.

       rruulleess==_n_a_m_e
	      Name  of text file containing reclassification rules. Rules file
	      may contain on each row either pair:

	      _k_e_y_w_o_r_d _v_a_l_u_e

	      (separated by space) or comment beginning by  #(hash).   Defini-
	      tion  of	new  category  begins with kyeword _c_a_t followed by new
	      category value.  Keyword _w_h_e_r_e specifies SQL where condition and
	      optionaly _l_a_b_e_l keyword specifies category label.

       TTIITTLLEE==_n_a_m_e
	      Title for the resulting vector map.


EEXXAAMMPPLLEE
       vv..ddbb..rreeccllaassss --dd iinnppuutt==_l_a_n_d oouuttppuutt==_l_a_n_d___u ttyyppee==_a_r_e_a
	      ttaabbllee==_t_l_a_n_d kkeeyy==_i_d rruulleess==_l_a_n_d_._r_c_l


       the rules file contains :

       # land reclass file
       cat 1
       where use = 'E13' and owner = 'Jara Cimrman'
       cat 2
       where use = 'E14'
       label Use type E14

       Produces  a  new  vector  area file _l_a_n_d___u containing 'area' boundaries
       from _l_a_n_d with area category  values  selected  from  database  by  SQL
       select  statement:  _s_e_l_e_c_t  _i_d _f_r_o_m _t_l_a_n_d _w_h_e_r_e _u_s_e _= _'_E_1_3_' _a_n_d _o_w_n_e_r _=
       _'_J_a_r_a _C_i_m_r_m_a_n_'  changed to category 1; values selected from database by
       SQL  select  statement: _s_e_l_e_c_t _i_d _f_r_o_m _t_l_a_n_d _w_h_e_r_e _u_s_e _= _'_E_1_4_'  changed
       to category 2.  Any common boundaries are dissolved.



SSEEEE AALLSSOO
       _v_._e_x_t_r_a_c_t

AAUUTTHHOORR
       R.L. Glenn, USDA, SCS, NHQ-CGIS

       from v.reclass to v.db.reclass rewritten by Radim Blazek

       _L_a_s_t _c_h_a_n_g_e_d_: _$_D_a_t_e_: _2_0_0_2_/_0_1_/_2_5 _0_5_:_4_5_:_3_5 _$



GRASS 5.0						       v.db.reclass(1)
