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



NNAAMMEE
       _v_._r_e_c_l_a_s_s_._p_g  -	Generate  new  vector map layer derived from attribute
       data in the currently selected database. (GRASS-RDBMS Vector  Interface
       Program)

SSYYNNOOPPSSIISS
       vv..rreeccllaassss..ppgg

       vv..rreeccllaassss..ppgg hheellpp

       vv..rreeccllaassss..ppgg  [--dd]]   iinnppuutt=name kkeeyy=name ttaabb=name ccooll=name [wwhheerree=name]
       [oouuttppuutt=name] ttyyppee=name

       vv..rreeccllaassss..ppgg [[--ssdd]] ssqqll=file iinnppuutt=name [oouuttppuutt=name] ttyyppee=name

DDEESSCCRRIIPPTTIIOONN
       _v_._r_e_c_l_a_s_s_._p_g reclasses vector maps according to the SELECT  query.  The
       input map may be of vector area, line or vector site type, resulting in
       the reclass map of the same type.

       The sql file if chosen to input contains a single  line	like:  'select
       key_col, reclass_col from info_tab [where _c_l_a_u_s_e]'.

       The  users needs to either input two names of the columns interactively
       or feed them from the input sql file. The first name is the old map key
       column,	the  second  one  is  the key for the new map. Additionally, a
       clause to choose only some vectors to be reclassed from the  input  map
       can  be	imposed  by user, either interactively or from the input file.
       Both columns used for creating the reclass rules  must  be  of  numeric
       (integer) type.

       If  the user omitted the output map name, the reclass map would only be
       displayed on monitor and not created.

CCOOMMMMAANNDD LLIINNEE OOPPTTIIOONNSS
   FFllaagg::
       --dd  Dissolve common boundaries between reclassed areas


   PPaarraammeetteerrss::
       ssqqll==ffiilleennaammee
	   Name of file containing SQL query statements

       kkeeyy==ddaattaabbaasseeccoolluummnnnnaammee
	   Key column in db

       ttaabb==nnaammee
	   Table containing [col]

       ccooll==nnaammee
	   Column to base reclass on

       wwhheerree==nnaammee
	   Where clause for query (ie. where col='paved')

       ttyyppee==aarreeaa//lliinnee//ssiittee
	   Select area, line or site as type of the input/output vector map

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

       oouuttppuutt==mmaapp
	   Name of new raster (reclass) file

       EEXXAAMMPPLLEE::

       1.  Reclass  to	vector	map  of  quartiles  from  forest  stands   map
       (_k_u_r_u_m_a___i_d).

       _v_._r_e_c_l_a_s_s_._p_g  _-_s _-_d _s_q_l_=_r_e_c_l_a_s_s_._s_q_l _i_n_p_u_t_=_k_u_r_u_m_a___i_d _o_u_t_p_u_t_=_k_u_r_u_m_a___q_u_a_r_t
       _t_y_p_e_=_a_r_e_a

       and reclass.sql is:

       _s_e_l_e_c_t _r_e_c___i_d_, _q_u_a_r_t_n_u_m _f_r_o_m _i_n_f_o___k_u_r_u_m_a

       2. Reclass to vector map of forest types (_k_u_r_u_m_a___o_a_k) from map of  for-
       est plots (_k_u_r_u_m_a___i_d) taking only oak (types 32-37).

       _v_._r_e_c_l_a_s_s_._p_g   _-_d   _k_u_r_u_m_a___i_d  _k_e_y_=_r_e_c___i_d  _c_o_l_=_t_y_p_e___i_d  _t_a_b_=_i_n_f_o___k_u_r_u_m_a
       _w_h_e_r_e_=_'_t_y_p_e___i_d _> _3_1 _a_n_d _t_y_p_e___i_d _< _3_8_' _o_u_t_p_u_t_=_k_u_r_u_m_a___o_a_k _t_y_p_e_=_a_r_e_a





BBUUGGSS
       None known.

NNOOTTEE
       This program requires the PostgreSQL database software.	It uses  other
       GRASS modules _v_._r_e_c_l_a_s_s and _d_._v_e_c_t launched from inside.

SSEEEE AALLSSOO
       _g_._s_e_l_e_c_t_._p_g_,  _g_._s_t_a_t_s_._p_g_,  _g_._t_a_b_l_e_._p_g_, _d_._r_a_s_t_._p_g_, _d_._s_i_t_e_._p_g_, _d_._v_e_c_t_._p_g_,
       _d_._w_h_a_t_._r_._p_g_, _d_._w_h_a_t_._s_._p_g_, _d_._w_h_a_t_._v_._p_g_, _r_._r_e_c_l_a_s_s_._p_g_, _r_._r_e_s_c_a_l_e_._p_g

AAUUTTHHOORR
       Original Informix  SQL-tools:  James  A.  Farley,  Wang	Song,  and  W.
       Fredrick Limp University of Arkansas, CAST

       Postgres modifications: Janne Soimasuo, Faculty of Forestry, University
       of Joensuu, Finland.

       Updated to GRASS 5 by Alex Shevlakov (sixote@yahoo.com)



GRASS 5.0						       v.reclass.pg(1)
