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



NNAAMMEE
       vv..rreeccllaassss..iinnff   -  Generate new vector map layer derived from attribute
       data in the currently selected database.
       _(_G_R_A_S_S_-_R_D_B_M_S _V_e_c_t_o_r _I_n_t_e_r_f_a_c_e _P_r_o_g_r_a_m_)

SSYYNNOOPPSSIISS
       vv..rreeccllaassss..iinnff
       vv..rreeccllaassss..iinnff hheellpp
       vv..rreeccllaassss..iinnff [[--dd]] ssqqll==_n_a_m_e kkeeyy==_n_a_m_e ttyyppee==_n_a_m_e iinnppuutt==_n_a_m_e [[oouuttppuutt==_n_a_m_e_]

DDEESSCCRRIIPPTTIIOONN
       v.reclass.inf  generates a new vector map layer based on the results of
       one or more queries to the currently selected database.	The user  con-
       structs a series of mutually exclusive SQL select statments designed to
       return groups of records from  the  database.  Each  group  of  records
       should  be  internally consistent in terms of attribute characteristics
       specified by the user in the SELECT clause. These groups should also be
       mutually  exclusive, thereby insuring that a row returned by one SELECT
       clause is not also returned by a subsequent SELECT clause.  Each  group
       of  records  therefore  forms  the  basis  for a single category in the
       resulting GRASS vector map. v.reclass.inf processes each SELECT	state-
       ment in order returning groups of records which will form a single cat-
       egory in the resulting map.  As each SELECT statement is processed  the
       group  of  records returned receives a common category value. The cate-
       gory value is incremented by one for each  subsequent  SELECT  statment
       which  is  processed.  The resulting reclass map will have one category
       for each of the original SELECT statements.


       For example, the rows associated with the first SELECT  statement  will
       be  assigned  to  category  1,  those associated with the second SELECT
       statement will be assigned to category 2 and so on. The output map will
       contain only those line segments associated with database rows returned
       by the SELECT statement(s).



CCOOMMMMAANNDD LLIINNEE OOPPTTIIOONNSS
       FFllaaggss::

       --dd     Disolve common boundaries between reclassed areas.


       PPaarraammeetteerrss::

       ssqqll==_f_i_l_e_n_a_m_e
	      Name of file containing SQL query statements.

       kkeeyy==_d_a_t_a_b_a_s_e___c_o_l_u_m_n___n_a_m_e
	      Key column in db.

       ttyyppee==_a_r_e_a_/_l_i_n_e_.
	      Key column in db.

       iinnppuutt==_m_a_p
	      Name of existing vector file to be reclassed using query output.

       oouuttppuutt==_m_a_p
	      Name of new raster (reclass),  file.





EEXXAAMMPPLLEE:: pprroodduucceess vveeccttoorr mmaapp ooff pprriimmaarryy aanndd sseeccoonnddaarryy rrooaaddss..
       vv..rreeccllaassss..iinnff ssqqll==_v_e_c_t_._s_q_l kkeeyy==_t_l_i_d iinnppuutt==_t_._r_o_a_d_s_._i_n_f oouuttppuutt==_t_._r_o_a_d_s_._1_2



	     _v_e_c_t_._s_q_l:

	    SELECT UNIQUE tlid,cfcc FROM type1
	    WHERE cfcc MATCHES "A1*"
	    ORDER BY tlid;
	    SELECT UNIQUE tlid,cfcc FROM type1
	    WHERE cfcc MATCHES "A2*"
	    ORDER BY tlid


BBUUGGSS
       None known.



NNOOTTEE
       This program requires the Informix database software.



SSEEEE AALLSSOO
       g.column.inf,  g.select.inf,  g.stats.inf,   g.table.inf,   d.rast.inf,
       d.site.inf,   d.vect.inf,   d.what.r.inf,  d.what.s.inf,  d.what.v.inf,
       r.rescale.inf



AAUUTTHHOORR
       James A. Farley, Wang Song and W. Fredrick Limp University of Arkansas,
       CAST

       _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.reclass.inf(1)
